Critical path analysis using Excel functions and formulas.

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 analysis cannot be overstressed in order to calculate minimum required overall project period based on a logical and reliable schedule.

You can download a file.

.00:00 1. Overview00:37 2. Precedence Diagram Method02:03 3. Excel Functions Employed for Critical Path Analysis 03:54 4. Early Schedule Calculation along Forward Pass06:33 5. Late Schedule Calculation along Backward Pass09:03 6. Identify Critical Activities10:09 7. Draw Schedule Bars based on the CPA result

[fredgebauer]

Hello, would you provide an updated Excel workbook link, the current link does not work? Thank you,