Spreadsheet: 42227d1240839561-counting-dates-within-a-specific-range-we-blank-template-1-v3
Sheet: MGMT INFO

 | Management Information for: |  |  |  |  |  | Company_Name - Office_Name - Weekend XX (XX/XX/XX - XX/XX/XX)
 | Clients |  | Competence |  |  |  |  |  |  |  |  |  |  |  |  | Total Per Client
 |  |  | TM | TCM | LO | COSS | HSM | LXA | PO | PC | ES | MC | CC | TL | SAC
 |  |  | pts* | *charge* | lo* | COSS* | hand* | [NAME]* | points* | protect* | eng* | [NAME]* | crane* | tandem* | site access*
 |  |  | TM* | TCM* | LO* | *site safety* | HSM* | LXA* | PO* | PC* | ES* | MC* | CC* | TL* | SAC*
 | A Client | 'A Client'!B:B | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Sheet02 | '[NAME]:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet03 | 'Sheet03'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet04 | 'Sheet04'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet05 | 'Sheet05'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet06 | 'Sheet06'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet07 | 'Sheet07'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet08 | 'Sheet08'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet09 | 'Sheet09'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet10 | 'Sheet10'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet11 | 'Sheet11'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet12 | 'Sheet12'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet13 | 'Sheet13'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet14 | '[NAME]:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet15 | 'Sheet15'!B:B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Per Competence |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Trackworkers |  | 1
 | Safety Critical |  | 0
 | Other |  | 0
 | Clients |  | Shifts Offered With >48h Notice | Shifts Offered With <48h Notice | Shifts Filled | Shifts Unfillable | Shifts Cancelled >48h Notice | Shifts Cancelled <48h Notice | [NAME] |  | Clients |  | Hours Invoiced | Turnover | Gross Profit | GP Margin
 | A Client | 'A Client'!B:B |  |  |  | 1 |  |  | 1 |  | A Client |  | 12 | 192 | 96 | 0.5
 | Sheet02 | '[NAME]:B |  |  |  | 0 |  |  | 0 |  | Sheet02 |  | 0 | 0 | 0 | 0
 | Sheet03 | 'Sheet03'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet03 |  | 0 | 0 | 0 | 0
 | Sheet04 | 'Sheet04'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet04 |  | 0 | 0 | 0 | 0
 | Sheet05 | 'Sheet05'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet05 |  | 0 | 0 | 0 | 0
 | Sheet06 | 'Sheet06'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet06 |  | 0 | 0 | 0 | 0
 | Sheet07 | 'Sheet07'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet07 |  | 0 | 0 | 0 | 0
 | Sheet08 | 'Sheet08'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet08 |  | 0 | 0 | 0 | 0
 | Sheet09 | 'Sheet09'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet09 |  | 0 | 0 | 0 | 0
 | Sheet10 | 'Sheet10'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet10 |  | 0 | 0 | 0 | 0
 | Sheet11 | 'Sheet11'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet11 |  | 0 | 0 | 0 | 0
 | Sheet12 | 'Sheet12'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet12 |  | 0 | 0 | 0 | 0
 | Sheet13 | 'Sheet13'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet13 |  | 0 | 0 | 0 | 0
 | Sheet14 | '[NAME]:B |  |  |  | 0 |  |  | 0 |  | Sheet14 |  | 0 | 0 | 0 | 0
 | Sheet15 | 'Sheet15'!B:B |  |  |  | 0 |  |  | 0 |  | Sheet15 |  | 0 | 0 | 0 | 0
 | Total: |  |  |  |  |  |  |  |  |  | Total: |  | 12 | 192 | 96 | 0.5