Spreadsheets have earned themselves a bad reputation amongst software purists, because they can, and often are, used in an unstructured way. Building a scheduling system requires a structured and disciplined approach. Please resist the trap that many fall into, by creating a table on a single worksheet that looks like the report that you want to see. The approach used here is to create lists in the form of databases, with a heading at the top of each column, and with universal formulae that can be copied and pasted down a column, and work on every row. If all the calculations are done in a structured database, then reports, with sub-totals and charts, can easily be created with a PivotTable.

We use finite scheduling techniques, and our philosophy of scheduling embraces Theory of Constraints (TOC), and Constraint Management thinking.