To watch a tutorial video on how to use the Headcount sheet, scroll to the bottom of this article.
The Headcount sheet allows you to track how many of a certain item (meals, walkie talkies, etc) you will need to provide on a particular day of your project. It lists all of the production labor categories (Sections A, B, G, L, M, O, & Q), and also has a section called “Additional People” where you can list others who will also be present on set.
To access this sheet, press the Headcount button, which can be found on the Ribbon tab and Menu sheet.
Using the sheet is simple: you just input a number into the various cells, and it will generate totals at the bottom of each section, as well as a Grand Total at the very bottom.
If you need more rows for the Additional People section, you can click the plus button underneath it, and then add as many as you need. If you want to delete some of the rows, select a cell in the rows you want to delete, and then click the minus button.
Note: this sheet is not directly tied to the budget pages, so nothing you input on it will make any changes to the budget.
Options
The Options menu of the sheet will allow you to customize the look of the Headcount sheet based on the particulars of your project. There are three tabs to the Options menu: General, Day Sections, and Categories.
GENERAL tab
Show Name column – you can show or hide the NAME column with this checkbox.
Show Notes column – you can show or hide the NOTES column with this checkbox.
Show Estimate Days – you can show or hide the numbers from the Estimate, both from the ‘No’ column and the ‘Days’ column, with this checkbox.
Show Working Days – you can show or hide the numbers from the Working, both from the ‘No’ column and the ‘Days’ column, with this checkbox.
Show Section A – you can show or hide Section A with this checkbox.
Show Section B – you can show or hide Section B with this checkbox.
Show Section G – you can show or hide Section G with this checkbox.
Show Section L – you can show or hide Section L with this checkbox.
Show Section M – you can show or hide Section M with this checkbox.
Show Section O – you can show or hide Section O with this checkbox.
Show Section Q – you can show or hide Section Q with this checkbox. (This checkbox will only be visible if you have Page 7 enabled.)
Show Additional People – you can show or hide the Additional People section with this checkbox.
DAY SECTIONS tab
You can have up to 12 'Day' Sections on the Headcount sheet. If you do not need that many, you can uncheck the ones you don’t need, and they will be hidden. You can also name each Day Section whatever you would like. For instance, you might want to call Day Section 1 “Prelight Day”, Day Section 2 “Shoot Day - Stage”, and Day Section 3 “Shoot Day - Location.”
CATEGORIES tab
You can choose which categories to show for each Day Section. There are also 6 customizable categories. You can name those whatever you would like.
Tutorial Video