Spreadsheet: 838112d1690734459-calculating-time-car-park-calculations_1
Sheet: Sheet1

 |  |  |  |  |  |  | Total number of Spaces |  |  |  |  |  | 337 |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  | Changeover/Visitor = 10% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cant base it on headcount
 |  |  |  |  |  |  | Total Available for staff |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Impact of new contract
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do we have DEFRA?
 |  |  |  | Day |  |  |  |  | Changeover |  | Night |  |  |  |  |  |  |  | Row 1 | Row2 | Row 3 | Row 4 | Row 5 |  | What is DEFRA Headcount
Dept | Total Headcount (All shifts) | Existing Parking permits | Permits: headcount % | [NAME] | Shift Start | Shift End | Shift Headcount | Head count % | 30 mins ending | Cum Spaces | [NAME] | Shift Start | Shift End | Shift Headcount | Head count % | Day Spaces | Night Spaces
HMRC | 293 | 219 |  |  | 07:00:00 | 19:00:00 | 60 |  |  |  |  | 19:00:00 | 07:00:00 | 30 |  |  |  |  | A1 | A2 |  |  |  |  | What impact future chages will have on current
HMRC (HOs) | 6 | 6 |  |  | 07:00:00 | 19:00:00 | 2 |  |  |  |  | 19:00:00 | 07:00:00 | 2 |  |  |  |  |  |  |  |  |  |  | RFLT move from HMRC to SODEXO
HMRC - SMT/Estates | 4 | 11 |  |  | 09:00:00 | 17:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | We need current permit to headcount %
BF - Estimated | 200 | 225 |  |  |  |  | 60 |  |  |  |  |  |  | 60 |  |  |  |  | D2 | B1 | B2
Site Op - Winc | 64 | 73 |  |  | 06:00:00 | 18:00:00 | 18 |  |  |  |  | 18:00:00 | 06:00:00 | 12 |  |  |  |  |  |  |  | C2 | C1
Site Op - Winc | 3 |  |  |  | 09:00:00 | 17:00:00
DEFRA - Estimated | 50 |  |  |  |  |  | 20 |  |  |  |  |  |  | 20 |  |  |  |  |  |  | D1
Port Health |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1
Site Op - Mitie | 415 | 281 |  |  | 06:00:00 | 18:00:00 | 60 |  |  |  |  |  |  | 60
Site Op - Mitie |  |  |  |  | 07:00:00 | 19:00:00 | 60 |  |  |  |  |  |  | 60
Site Op - Mitie | 3 |  |  |  | 09:00:00 | 17:00:00
SODEXO | 57 | 25 |  |  | 06:00:00 | 18:00:00 | 19 |  |  |  |  | 18:00:00 | 06:00:00 | 12
BEIS
 |  |  |  |  | Total on Shift |  |  |  |  |  |  | Total on Shift
BF | 07:30:00
 | 15:30:00
 | 22:30:00
 |  |  |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Dept | Total Headcount (All shifts) | Existing Parking permits | Permits: headcount %
HMRC | 293 | 219 |  | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
HMRC (HOs) | 6 | 6 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
HMRC - SMT/Estates | 4 | 11 |  |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
BF - Estimated | 200 | 225 |  | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 52 | 52 | 30 | 38 | 38 | 38 | 38 | 68 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 52 | 52
BF |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Site Op - Winc | 64 | 73 |  | 12 | 12 | 12 | 12 | 12 | 12 | 30 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 30 | 12 | 12 | 12 | 12 | 12
Site Op - Winc | 3 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
DEFRA - Estimated | 50
Port Health
Site Op - Mitie | 415 | 281 |  | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
Site Op - Mitie |  |  |  | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
Site Op - Mitie | 3 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
SODEXO | 57 | 25 |  | 12 | 12 | 12 | 12 | 12 | 12 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 12 | 12 | 12 | 12 | 12
BEIS
 |  |  | Staff on site
Based on current % of Parking Permits
 |  |  |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Dept | Total Headcount (All shifts) | Existing Parking permits | Permits: headcount %
HMRC | 293 | 219
HMRC (HOs) | 6 | 6
HMRC - SMT/Estates | 4 | 11 |  |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
BF - Estimated | 200 | 225 |  | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 52 | 52 | 30 | 38 | 38 | 38 | 38 | 68 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 52 | 52
BF |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Site Op - Winc | 64 | 73 |  | 12 | 12 | 12 | 12 | 12 | 12 | 30 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 30 | 12 | 12 | 12 | 12 | 12
Site Op - Winc | 3 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
DEFRA - Estimated | 50
Port Health
Site Op - Mitie | 415 | 281
Site Op - Mitie
Site Op - Mitie | 3 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
SODEXO | 57 | 25 |  | 12 | 12 | 12 | 12 | 12 | 12 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 12 | 12 | 12 | 12 | 12
BEIS | 50 | 50 |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  | Spaces in use
 |  |  | Spaces not in use
 |  |  | % Occupancy
 |  |  |  | 337