Видео 29
Просмотров 50 745

Exel User interface methods including RibbonX coding

14:49

Run Python from Excel

12:39

Project scheduling by Python and Excel; deterministic, probabilistic and schedule risk analysis

32:58

crosstabs plot by Python for Excel user

5:52

Schedule risk analysis with Monte Carlo simulation

9:34

Probabilistic schedule #PERT#Python algorithm#Probability distribution

8:16

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...

Видео

Exel User interface methods including RibbonX coding

14:49

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...

12:39

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

32:58

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...

5:52

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

9:34

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

8:16

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

27:55

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

59:53

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

16:57

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

15:02

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.

11:02

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:55

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

4:27

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...

5:32

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

6:40

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

6:24

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

7:24

Create summary data report without PIVOT table in Excel

Просмотров 1,1 тыс.4 года назад

Create summary data report without PIVOT table in Excel

4:04

Progress S-Curve Generator in Excel

Просмотров 9114 года назад

Progress S-Curve Generator in Excel

How to make a Gantt chart in Excel with VBA

12:42

How to make a Gantt chart in Excel with VBA

Просмотров 3,3 тыс.4 года назад

How to make a Gantt chart in Excel with VBA

5:16

Horizontal filter Excel add-in

Просмотров 3 тыс.4 года назад

Horizontal filter Excel add-in

4:47

Create timeline automatically in Excel

Просмотров 2084 года назад

Create timeline automatically in Excel

Enhanced Excel Data Entry Form functions

4:57

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

4:30

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

6:07

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

5:57

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

8:22

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:28

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 %

1:04:35

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 %

KingstoneSC