I thought I was pretty clever to come up with this worksheet, but it has turned out to be a nightmere with any changes. The worksheet (which I have worksheet for every month) is used to collect data for staffing. the rows with all the fomulas are hidden from users. We track if a company (fire trucks with 4 men) is an advance, intermediate or basic life support apparatus (P=advance, I=intermediate, B=basic). We work in 3 24 hours shifts which is called the A,B & C shift (row 3 under the date of month). The city is broken into 6 battalions (geographical boundries) with each battalion having a Chief (supervisor). So that is why you will see E1A, E1B, E1C, ect.
When changes are made (either fire trucks going in service or out of service) it makes it very difficult to report all the percentages. I have tried several ways to place this into 1 worksheet so that I can use a pivot table to collect my data, but have not been successful. I want to keep it easy to use, but also easy for me to report my data.
Any idea on possible layouts would be greatly appreciated. I realize this might be better in a database, but I am stuck using excel for this task.