FILE NAME: GANTDAY
FUNCTION: Gantt-charting in daily time units.
OVERVIEW: This worksheet draws a Gantt chart for tasks in series, that is the tasks must be done one after the other. The worksheet can be modified to handle any sequencing of tasks and to work with time units of weeks, days, or hours.
INPUT: Enter kick-off date in D4. Enter task descriptions and the number of weeks required for each task in C9..E15.
OUTPUT: Start and finish dates are automatically computed in columnd F and G based on the kickoff date and the number of days for each task. Dates in row 8are automatically calculated. Formulas in the body of the Gantt chart check to see if a task is in progress during a given day. If so, a line is drawn.
MODIFYING THE WORKSHEET:
To add more tasks for a daily schedule, place the cursor at cell A12 and insert one row for each task. To reduce the number of items, delete rows at row 12. In cases where the tasks are not done in series, rather than use formulas in columns F and G, simply enter any start and finish times desired.
If you have 20 or more tasks, the Gantt Chart becomes quite large and difficult to see. One suggestion is to narrow the column widths. You can reduce the columns to width of 3 and still indicate if there is a task in progress. If you do this, you may want to move and stagger the date headings, and use strings instead of formulas. If you have a number, or formula that is bigger than the current column, the worksheet will just display ###. If you have a string, and the cells adjacent are empty, the string will overflow into the adjacent cells and you can read the values.
When printing, you may want to orient the picture in a landscape mode.
FUNCTION: Gantt-charting in weekly time units.
INPUT/OUTPUT/MODIFYING THE WORKSHEET: Similar to GANTDAY
FILE NAME: GANTHOUR.XLS
FUNCTION: Gantt-charting in hourly time units.
INPUT/OUTPUT/MODIFYING THE WORKSHEET: Similar to GANTDAY
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