![]() In addition to identifying critical tasks, calculating slack time can help identify tasks that can be delayed, allowing a project manager to make decisions about where to allocate resources. Slack or float time is the amount of time the task can be delayed without causing the overall project to take longer. The PERT algorithm calculates the slack time or float time for each task. This spreadsheet finds the critical path using the PERT algorithm. ![]() ![]() There can be multiple parallel critical paths, and the critical path may change if you are able to reduce the duration of one of the critical tasks. In other words, unless you can reduce the duration of one or more tasks on the critical path, you can't reduce the time your project will take. The critical path is the string of dependent tasks that limit a project from being completed faster. This is a simple yet huge breakthrough that makes the spreadsheet a lot easier to use. Update - The new version 1.2 uses an updated algorithm that assumes all tasks have the Finish task as a successor. Task dependencies are defined by simply listing the predecessors for each task. Milestones (tasks with zero duration) are shown as black diamonds, but you don't have to mess with the axis scaling like the free version. The Gantt Chart shows the tasks on the Critical Path as red bars, the flexible tasks as blue bars, and the slack time as gray bar extensions. You can choose to calculate the expected time (Duration) using either the Triangular or Beta distribution. Unlike a normal project schedule or gantt chart, this spreadsheet lets you use the statistical aspect of the PERT algorithm by defining the duration of a task using O-M-P times (Optimistic, Most Likely, and Pessimistic). This version lets you include up to 500 tasks (more upon request, if necessary). This spreadsheet implements the PERT algorithm and Critical Path Method to aid in project planning and scheduling.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |