If each cell in a column contains the same formula, that formula will be automatically filled into any rows added to the bottom of the table.Ģ. Defining it as a header row permits two Numbers features to operate:ġ. B: The name of the most recent phase that must be completed before the current phase begins, C: the number of weeks separating the end of the earlier phase and the beginning of the current phase, and D: the number of weeks required to complete the current phase. Rows 1 and 2 of the first table should be the same for every project.įor each row in the blue area, four pieces of data are needed:Ī: The name of the current phase. It will need to be Unlocked only to permit adding or removing rows to chart a project with more or fewer stages than the seven shown in the example. The Calculations table should be Locked (Arrange > Lock) to avoid accidental changes in the formulas. The model contains two tables and a horizontal bar chart.ĪLL data entry is done on the upper table, Project schedule input.ĪLL calculations are done on the lower table, Calculations. The document follows Jerry's model, but may be using different formulas.
For a copy of the file, see instructions at the end of this post. Here is a copy of my take on Jerry's template, posted in the thread linked in Wayne's message above.
