KingstoneSC
KingstoneSC
  • Видео 29
  • Просмотров 50 745
Project Scheduling Program complete(theoretical and real world) – Excel Runs Python
The package you can get its source code is a stand-alone program.
You can apply this package to your project planning- realistic, comprehensive and complete
It covers deterministic, probabilistic based on PERT theory and schedule risk analysis based on Monte Carlo simulation.
Excel plays a role of front-end program and this program runs from Excel without need to access Python scripting.
But if you want, you can access and customize the Python scripting for your purpose.
This video can be complete along with the following three videos for the purpose of knowing full details about program algorithm, structure and operation.
1. Theoretical project scheduling methods:
ruclips.net/video/mHJDrJOe3gE...
Просмотров: 182

Видео

Exel User interface methods including RibbonX coding
Просмотров 452 месяца назад
The user interface (UI) is the point of human-computer interaction and communication in a device. User Interface has been proposed when RUclips titled ‘running Python from Excel’ was published. ruclips.net/video/hdDFL-xgOys/видео.html At that time, Customize Ribbon method was adopted without detailed discussion. We are discussing detailed procedure of four methods including the Customize Ribbon...
Run Python from Excel
Просмотров 913 месяца назад
This video is discussing how to run Python scripts from Excel, by one click of control button on Excel worksheet. This way does not necessitate you to access python editor or command line to run Python scripts. If you need source file, please contact me. christopherzen.cho@gmail.com Contents 00:00 Introduction 00:30 Overview 01:51 Window Script Shell 03:06 Excel VBA 05:18 UserForm 06:53 Standar...
Project scheduling by Python and Excel; deterministic, probabilistic and schedule risk analysis
Просмотров 4718 месяцев назад
Three scheduling techniques are discussed in this video. Excel is front-end program for scheduling input and presentation of Python based program output. All three techniques should go through critical path analysis, if schedules are to be logical. The CPA algorithm is kept in a class for deterministic schedule. The probabilistic and schedule risk analysis classes inherit the class in the deter...
crosstabs plot by Python for Excel user
Просмотров 8910 месяцев назад
Two columns summary table is formed to view relationship between two categorical variables. First column lists each unique item of primary categorical variable while second column lists all dependent categorical variables as a string in a cell each. In addition, cross tabulation table (cross Tabs) is generated highlighting one to one relationship between two categorical variables, similar to sc...
Schedule risk analysis with Monte Carlo simulation
Просмотров 40110 месяцев назад
Schedule risk analysis based on Monte Carlo simulation is a planning procedure that aims to improve the predictability and performance of a project. Schedule risk analysis is a key weapon in any project manager’s arsenal and will provide meaningful and actionable information to drive better decision-making. Two steps are concerned: Monte Carlo simulation and its visualization. This video is foc...
Probabilistic schedule #PERT#Python algorithm#Probability distribution
Просмотров 24311 месяцев назад
The probabilistic scheduling, we are discussing is based on PERT, standing for Program Evaluation and Review Technique (PERT). PERT adopts three activity duration estimates to address uncertainty existing in deterministic nature of activity duration. Program performs critical path analysis to generate P50 schedule and create probability distribution. In addition, project prediction is possible ...
Skyline diagram, Python based Project visualization tool on Excel
Просмотров 836Год назад
A skyline diagram is designed to display project plan and progress in the shape of skyline. Excel is front-end program containing project data and to view output of the application, the skyline diagram, on it. Python is back-end program and Tkinter provides the Python application with an easy-to-program user interface. This session is focused on organizing the data required for creating a skyli...
Python based project management - 1. Deterministic schedule with Gantt chart
Просмотров 1,9 тыс.Год назад
Python is used to automate project management tools on excel worksheet. Deterministic schedule is implemented with Gantt chart on the worksheet through critical path analysis. You may download program files, python file and excel file, and supporting documents, PowerPoint, and word document, for easier reference while you have a time to watch this video. www.kingstonesc.com/article/project mana...
Python algorithm- critical path analysis on Excel worksheet
Просмотров 1,3 тыс.3 года назад
This video discusses python algorithm of critical path analysis and how to run the python file. Read schedule data on worksheet and write the outcome of python file run back to the worksheet. The Python file is called by Excel using xlwings library. The algorithm we are discussing is not simplistic but complete enough to adopt to project execution without modification and with quality comparabl...
Critical path analysis - Network Diagram Method
Просмотров 1 тыс.3 года назад
We are discussing how to implement critical path analysis using project network diagram method.. Automate to draw project network diagram based on schedule data table.. Program enters formulas in the activity node cells of the network diagram. Generate Gantt chart based on the network diagram. You can download a file for your use and give your feedback, if any. www.kingstonesc.com/youtube/019_1...
Critical path analysis using Excel functions and formulas.
Просмотров 4,2 тыс.3 года назад
When we develop a schedule, we assume that the schedule data is logical and reliable.Graphically displaying the schedule data is one thing while how to make the schedule logical is another thing.This video is concerned with the critical path analysis to make your schedule logical Excel functions are leveraged to formulate critical path analysis algorithm.The significance of critical path analys...
Week ending date and Month end date- Excel WEEKDAY function, DATE function and EOMONTH function
Просмотров 3,2 тыс.4 года назад
we discuss how to convert a specific date to the corresponding week or month starting date and week or month ending date. The Excel WEEKDAY function is used to return week ending date with 2nd argument Return type specified depending on the week end day. Three methods are available to convert a specific date to the month end date: First using the Excel EOMONTH function, second using the Excel D...
Progress Bar in Excel - Conditional formatting, Draw Shapes, Text histogram
Просмотров 1354 года назад
This video discusses how to create progress bar in a single cell. Three methods are discussed. 1. Using conditional formatting function 2. Drawing the shapes in proportion to the progress value by using Active X control and Macro. 3. Create text histogram using Excel REPT function You can download a file along with Source code. www.kingstonesc.com/youtube/018progressbar.zip 00:20 Conditional fo...
Format chart grid line - Excel chart
Просмотров 5044 года назад
We discuss how to format grid lines differently using error bars of scatter line chart.Firstly, we are discussing how to create a como chart without plotting blank cells.Secondly, chart data table are made clean.Lastly, grid lines are formatted differently using vertical error bars of scatter line chart.You can visit the url below to download worksheet. www.kingstonesc.com/youtube/011_04FormatG...
Create dynamic range formula - Excel function Offset with COUNTA or Index with COUNTA
Просмотров 8594 года назад
Create dynamic range formula - Excel function Offset with COUNTA or Index with COUNTA
How to build a package program - Excel VBA. Construction management platform
Просмотров 6524 года назад
How to build a package program - Excel VBA. Construction management platform
Create summary data report without PIVOT table in Excel
Просмотров 1,1 тыс.4 года назад
Create summary data report without PIVOT table in Excel
Progress S-Curve Generator in Excel
Просмотров 9114 года назад
Progress S-Curve Generator in Excel
How to make a Gantt chart in Excel with VBA
Просмотров 3,3 тыс.4 года назад
How to make a Gantt chart in Excel with VBA
Horizontal filter Excel add-in
Просмотров 3 тыс.4 года назад
Horizontal filter Excel add-in
Create timeline automatically in Excel
Просмотров 2084 года назад
Create timeline automatically in Excel
Enhanced Excel Data Entry Form functions
Просмотров 1684 года назад
Enhanced Excel Data Entry Form functions
Use Excel Data Entry Form to Add, edit, find, and delete rows and discuss limitation
Просмотров 4064 года назад
Use Excel Data Entry Form to Add, edit, find, and delete rows and discuss limitation
Create Multiple scale Pie Charts using Application.Union Method
Просмотров 1934 года назад
Create Multiple scale Pie Charts using Application.Union Method
Create Multiple scale Pie Charts using Excel chart filtering function
Просмотров 8 тыс.4 года назад
Create Multiple scale Pie Charts using Excel chart filtering function
How to make project S-curve and rundown curve based to period data in Excel and Excel VBA
Просмотров 1,9 тыс.4 года назад
How to make project S-curve and rundown curve based to period data in Excel and Excel VBA
How to make your own Excel Add-ins with RibbonX Custom UI
Просмотров 10 тыс.4 года назад
How to make your own Excel Add-ins with RibbonX Custom UI
How to make a Gantt chart in Excel with critical path method-Logical, interactive and progress %
Просмотров 6 тыс.4 года назад
How to make a Gantt chart in Excel with critical path method-Logical, interactive and progress %