Scheduling in Excel
3.MODIFYING THE WORKSHEET:
See the instructions for CPMDAILY.XLS.3. PROJECT MANAGEMENT (cont)
FILE NAME: CPMHOUR
FUNCTION: Critical-Path-Method, hourly schedule
OVERVIEW: Similar to CPMDAILY, except that time is measured in hours rather than days. The start and finish times are treated as hours since the beginning of the project.
INPUT: Enter task descriptions in C8.... The first and last are always labeled dummy start and dummy finish. Number the tasks in D8.... The dummy start is always zero and the dummy finish is assigned an arbitrary number much larger than the last task. Enter the number of weeks needed to do each task in F9.... In G9..., enter the numbers of the immediately preceding tasks. If there is only 1 immediately preceding task, use zero as the second. The dummy start is always preceded by two zeros while the dummy finish is preceded by the last task and NA. In G28...., enter the numbers of the immediate successors to each task. If there is only one immediate successor, enter the dummy finish number. For the dummy finish, enter NA.
OUTPUT: Early start and early finish day numbers for each task are shown in I9.... Late start and late finish day numbers are shown in I28.... The number of days of slack for each task is shown in K9... and repeated in cells K28..... Gantt charts of the schedule are shown at the bottom of the worksheet.
1. Get Started
2. Workstation Production Models
3. Scheduling 2 Workstation in Series
4. Scheduling 3 Workstation in Series
5. Scheduling 4 and more Workstation in Series
6. Scheduling 2 Workstation in Parallel
7. Project Management - Daily Schedule
10. Gantt Charting