Lessons 22-38 of the workbook build a complete scheduling tool. Here is how each piece works, so you can build your own for a sewing floor, embroidery or washing.
1. A simple Gantt chart that flags late jobs
Enter each job's hours in column C. The first job starts at 0; each next job starts when the previous one stops:
- Start:
=IF(C17>0, E16, " ") - Stop:
=IF(C17>0, C17+D17, " ") - Hours left to the delivery date:
=INT((E11-NOW())*10)(10 working hours a day) - Status:
=IF(E17<=E$13, "In-time", "Late")
The chart area has hour numbers across the top and a 1 where the job runs:
=IF(H$15<=$C$36, IF(AND(H$15<=$E16, $D16<H$15), 1, " "), " ")
Conditional formatting colours 1s turquoise for in-time jobs and red for late ones. Move rows up or down to test a better sequence.