Spreadsheet: 701651d1603875217-how-to-add-sumifs-formula-to-express-time-value-example
Sheet: Security - 2

ARENA FOH STAFF SECURITY COSTS - END STAGE - SEATED - WITH LEVEL 4
 | External Doors - Arena Plaza | External Doors - Arena Plaza | ARENA FLOOR | Level 1 | Level 2 | Level 3 | Level 4
 | EVENT ID
 | EVENT
 | EVENT DATE
 | EXTERNAL DOORS
 | INTERNAL DOORS
 | SHOW START TIME
 | APPROX END TIME
 | EVENT VENUE | ARENA
GL - EXTERNAL DOORS - ARENA PLAZA
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
External Doors - Arena Plaza | Day Rate | Zone Manager | Zone Manager
External Doors - Arena Plaza |  | Supervisor | Main Plaza Supervisor
 | Overall Total
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
External Doors - Arena Plaza |  | Security Guard Early Finish | Prohibited Items - Position 1
External Doors - Arena Plaza |  | Security Guard Suites | Prohibited Items - Position 2
External Doors - Arena Plaza |  | Security Guard | Canopy B - Secure Barrier Line - Position 1
External Doors - Arena Plaza |  | Security Guard | Canopy B - Secure Barrier Line - Position 2
External Doors - Arena Plaza |  | Security Guard | Canopy B - Secure Barrier Line - Position 3
External Doors - Arena Plaza |  | Security Guard | Canopy B - Secure Barrier Line - Position 4
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance A - Queue Coordinator
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance A - Male Wander (Redeploy Front Stage Position 1)
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance A - Female Wander  (Redeploy Front Stage Position 2)
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance A - Male Wander (Redeploy Response Floor)
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance A - Female Wander (Redeploy Response Floor)
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance B & I - Queue Manage  (Redeploy Floor Entry 2)
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance B & I - Queue Coordinator  (Redeploy Floor Entry 1)
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance B & I - Male Wander (Redeploy Response Level 1)
External Doors - Arena Plaza |  | Security Guard Early Finish | Canopy B - Entrance B & I - Female Wander
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance B & I - Male Wander (Redeploy Response Level 1)
External Doors - Arena Plaza |  | Security Guard Early Finish | Canopy B - Entrance B & I - Female Wander
External Doors - Arena Plaza |  | Security Guard Early Finish | Canopy B - Entrance C - Queue Coordinator
External Doors - Arena Plaza |  | Security Guard | Canopy B - Entrance C - Male Wander
External Doors - Arena Plaza |  | Security Guard Early Finish | Canopy B - Entrance C - Female Wander
External Doors - Arena Plaza |  | Security Guard Early Finish | Box Office Position 1 / (Relief)
 | Overall Total
GL - EXTERNAL DOORS - MAIN FOYER
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
External Doors - Main Foyer | Daily Rate | Security Manager | Backstage Manager
 | Overall Total
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
External Doors - Main Foyer |  |  | Entrance A - Escalator
External Doors - Main Foyer |  |  | Entrance C - Escalator
External Doors - Main Foyer |  | Security Guard Early Finish | Entrance A - Temperature Check
External Doors - Main Foyer |  | Security Guard | Entrance A - Temperature Check
External Doors - Main Foyer |  | Security Guard Early Finish | Entrance B - Temperature Check
External Doors - Main Foyer |  | Security Guard | Entrance B - Temperature Check
External Doors - Main Foyer |  | Security Guard Early Finish | Entrance C - Temperature Check
External Doors - Main Foyer |  | Security Guard | Entrance C - Temperature Check
External Doors - Main Foyer |  | Security Guard - Backstage | Staff Entrance F
External Doors - Main Foyer |  | Security Guard - Backstage | Staff [NAME]
External Doors - Main Foyer |  | Security Guard - Backstage | Loading Dock - Stage Door Left
External Doors - Main Foyer |  | Security Guard - Backstage | Loading Dock - Stage Door Right
External Doors - Main Foyer |  | Security Guard - Backstage | Dressing Room Corridor -  Position 1
External Doors - Main Foyer |  | Security Guard - Backstage | Dressing Room Corridor -  Position 2
External Doors - Main Foyer |  | Security Guard - Backstage | Dressing Room Corridor -  Position 3
External Doors - Main Foyer |  | Security Guard - Backstage | Dressing Room Corridor -  Position 4
 | Total
 | FOOD AND BEVERAGE SECURITY
External Doors - Main Foyer |  | F&B Security | F&B Concessions
External Doors - Main Foyer |  | F&B Security | F&B Concessions
External Doors - Main Foyer |  | F&B Security | F&B Concessions
External Doors - Main Foyer |  | F&B Security | F&B Concessions
 | Total
 | Overall Total
GL - ARENA FLOOR
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Arena Floor | Daily Rate | Security Manager | Contract Security Manager
 | Overall Total
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Arena Floor |  | Security Guard | Stage Left
Arena Floor |  | Security Guard | Stage Right
Arena Floor |  | Security Guard | Stage Stairs - Left
Arena Floor |  |  | Front of Stage 1 (Redeployed from Ext)
Arena Floor |  |  | Front of Stage 2 (Redeployed from Ext)
Arena Floor |  |  | [NAME] (I) (Redeployed from Ext)
Arena Floor |  |  | [NAME] (D) (Redeployed from Ext)
Arena Floor |  | Security Guard | Floor Tunnel Exit 1
Arena Floor |  | Security Guard | Floor Tunnel Exit 2
Arena Floor |  | Security Guard | FOH Mixer
Arena Floor |  | Security Guard | Response Security 1 (Ground and Level 1)
Arena Floor |  | Security Guard | Response Security 2 (Ground and Level 1)
Arena Floor |  |  | Response Security 3 (Redeployed from Ext)
Arena Floor |  |  | Response Security 4 (Redeployed from Ext)
 | Overall Total
 | FOOD AND BEVERAGE SECURITY
Arena Floor |  |  | F&B Concessions
Arena Floor |  |  | F&B Concessions
 | Total
 | Overall Total
LEVEL 1
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 1 | Daily Rate | Zone Manager | Zone Manager
Level 1 | Daily Rate | Control Room Manager | Control Room Manager
Level 1 |  | Control Room | Logger (Control Room)
Level 1 |  | Control Room | Control Room Operator 1
 | Overall Total
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 1 |  | Security Guard | Escalator Landing A - Position 1
Level 1 |  | Security Guard | Ecsalator Landing C - Position 1
Level 1 |  |  | VIP [NAME] in Concorse
Level 1 |  |  | VIP Lobby Right - Outside in concorse
Level 1 |  | Security Guard | BOH Entrance - Door 11
Level 1 |  | Security Guard | BOH Entrance - Door 16
Level 1 |  | Security Guard Suites | Response Security (Level 2 & 3)
Level 1 |  | Security Guard Suites | Response Security (Level 2 & 3)
Level 1 |  |  | Response Security (Redeployed from Ext)
Level 1 |  |  | Response Security (Redeployed from Ext)
 | Total
 | FOOD AND BEVERAGE SECURITY
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
Level 1 |  | F&B Security | F&B Concessions
 | Total
 | Overall Total
LEVEL 2
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 2 | Daily Rate | Zone Manager | Zone Manager
 | Overall Total
 |  |  |  | Roster |  |  | Actual
AREA | NAME |  | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 2 |  | Security Guard Suites | BOH Entrance - VVIP Suite
Level 2 |  | Security Guard Suites | BOH Entrance - Premier Club
Level 2 |  | Security Guard Suites | Premier Club - Position 1
 | Overall Total
LEVEL 3
 |  |  |  | Roster |  |  | Actual
AREA | NAME |  | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 3 |  | Security Guard Suites | BOH Entrance - VVIP Suite
Level 3 |  | Security Guard Suites | BOH Entrance - Premier Club
Level 3 |  | Security Guard Suites | Premier Club - Position 1
 | Overall Total
LEVEL 4
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 4 | Daily Rate | Zone Manager | Zone Manager
Level 4 |  | Supervisor | Supervisor
 | Overall Total
 |  |  |  | Roster |  |  | Actual
AREA | NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
Level 4 |  | Security Guard | Escalator Landing B - Position 1
Level 4 |  | Security Guard | Escalator Landing B - Position 2
Level 4 |  | Security Guard | Escalator Landing A - Position 1
Level 4 |  | Security Guard | Escalator Landing C - Position 1
Level 4 |  | Security Guard | BOH Entrance - Door 17
Level 4 |  | Security Guard | BOH Entrance - Door 32
Level 4 |  | Security Guard | [NAME]
Level 4 |  | Security Guard | [NAME] 9
Level 4 |  | Security Guard | Response Security
Level 4 |  | Security Guard | Response Security
Level 4 |  | Security Guard | Response Security (Redeployed from Ext)
Level 4 |  | Security Guard | Response Security (Redeployed from Ext)
 | Total
 | FOOD AND BEVERAGE SECURITY
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
Level 4 |  | F&B Security | F&B Concessions
 | Total
 | Overall Total