Spreadsheet: 142318d1329772288-need-formula-to-calc-ytd-staffing-level-annes-staffing-file
Sheet: 2012

 | Staff Out of Office Tracker |  |  |  |  |  |  | H | = | Holiday |  |  | P | = | Personal |  |  |  |  |  |  |  |  | F | = | Training
 | 2012 |  |  |  |  |  |  | V | = | Vacation |  |  | S | = | Sick |  |  |  |  |  |  |  |  |  |  |  |  | = YTD Staffing
 |  |  | A |  |  | B |  |  | C |  |  | D |  |  | E |  |  | TBD | Later |  | TBD | Much Later |  | F |  |  | % Strength
 | 2012-01-01 00:00:00 | S
 |  | M | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5
 |  | [NAME] | S | 1
 |  | W
 |  | Th |  |  |  | S | 4.5 |  | S | 3
 |  | F |  |  |  | S | 7.5 |  | S | 7.5 |  | S | 0.5
 |  | S
 |  | S
 |  | M |  |  |  |  |  |  |  |  |  | S | 2 |  | P | 3
 |  | [NAME] |  |  |  |  |  |  | P | 0.25
 |  | W |  |  |  |  |  |  | P | 0.25
 |  | Th |  |  |  |  |  |  |  |  |  |  |  |  | P | 1
 |  | F |  |  |  | S | 0.5 |  | P | 1
 |  | S
 |  | S
 |  | M | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | S | 4
 |  | W |  |  |  | S | 3.5
 |  | Th |  |  |  | S | 3.5 |  | F | 3 |  | F | 2
 |  | F
 |  | S
 |  | S
 |  | M |  |  |  |  |  |  | S | 7.5
 |  | [NAME]
 |  | W |  |  |  |  |  |  | P | 2 |  |  |  |  | F | 7.5
 |  | Th |  |  |  |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | F |  |  |  |  |  |  |  |  |  | V | 1 |  | F | 7.5
 |  | S
 |  | S
 |  | M |  |  |  | P | 0.5 |  | P | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | 7.5
 |  | [NAME] |  |  |  |  |  |  | P | 2
 |  | W | S | 1.5
 |  | Th |  |  |  | P | 0.5
 |  | F | V | 1
 |  | S
 |  | S
 |  | M
 |  | [NAME] | V | 3 |  | F | 3.5 |  |  |  |  |  |  |  | P | 5
 |  | W |  |  |  |  |  |  |  |  |  |  |  |  | P | 3
 |  | Th
 |  | F | V | 3 |  |  |  |  |  |  |  | V | 7.5
 |  | S
 |  | S
 |  | M | H | 7.5 |  |  |  |  |  |  |  |  |  |  | P | 3.75
 |  | [NAME] |  |  |  |  |  |  | F | 1.5
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5
 |  | [NAME] |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | W |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | Th | V | 7.5
 |  | F | V | 7.5
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W |  |  |  |  |  |  |  |  |  | S | 1.75
 |  | Th |  |  |  |  |  |  | P | 3
 |  | F |  |  |  |  |  |  | H | 7.5
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W |  |  |  |  |  |  | V | 7.5
 |  | Th |  |  |  |  |  |  | F | 7.5
 |  | F |  |  |  |  |  |  | F | 3
 |  | S
 |  | S
 |  | M |  |  |  |  |  |  | F | 7.5
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5
 |  | Th |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | F |  |  |  |  |  |  |  |  |  | F | 7.5
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | [NAME] |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | W |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | Th |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | F |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | S
 |  | S
 |  | M |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | [NAME] |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | W |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | Th |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | F |  |  |  |  |  |  |  |  |  | V | 7.5
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5 |  | H | 7.5
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <--- Election Day - floating holiday earned
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <--- End of Mayan calendar
 |  | S
 |  | S
 |  | M
 |  | [NAME]
 |  | W
 |  | Th
 |  | F
 |  | S
 |  | S
 |  | M