Spreadsheet: 42547d1241089766-if-date-1-is-48hrs-before-date-2-return-1-we-blank-template-1-v4-test
Sheet: MGMT INFO

 | Management Information for: |  |  |  |  |  | Company Name - Office_Name - Weekend 06 (02/05/09 - 03/05/09)
 | Clients |  | Competence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Per Client
 |  |  | TM | TCM | LO | COSS | HSM | LXA | PO | PC | ES | MC | CC | TL | SAC | LINE | SUP | TECH
 |  |  | pts* | *charge* | lkt* | COSS* | hand* | [NAME]* | points* | protect* | eng* | [NAME]* | crane* | tandem* | site access* | le * |  | to *
 |  |  | TM* | TCM* | LO* | *site safety* | HSM* | LXA* | PO* | PC* | ES* | MC* | CC* | TL* | SAC* | LINE* | SUP* | TECH*
 | A Client | 'A Client'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | B Client | 'B Client'!g1:g500 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Sheet03 | 'Sheet03'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet04 | 'Sheet04'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet05 | 'Sheet05'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet06 | 'Sheet06'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet07 | 'Sheet07'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet08 | 'Sheet08'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet09 | 'Sheet09'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet10 | 'Sheet10'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet11 | 'Sheet11'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet12 | 'Sheet12'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet13 | 'Sheet13'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet14 | 'Sheet14'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sheet15 | 'Sheet15'!g1:g500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Per Competence |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Trackworkers |  | 0
 | Safety Critical |  | 1
 | Other |  | 0
 | Clients |  | Total Shifts Offered | Offered With >48h Notice | Offered With <48h Notice | Shifts Filled | Shifts Unfillable | Total Shifts Cancelled | Shifts Cancelled >48h Notice | Shifts Cancelled <48h Notice | [NAME] |  |  | Clients |  | Hours Invoiced | Turnover | Gross Profit | GP Margin
 | A Client | 'A Client'!g1:g500 |  |  |  |  | 0 | 0 |  |  | 0 |  |  | A Client |  | 0 | 0 | 0 | 0
 | B Client | 'B Client'!g1:g500 | 2 | -4 | 6 | 2 | 0 | 1 | -5 | 6 | 0 |  |  | B Client |  | 12 | 240 | 60 | 0.25
 | Sheet03 | 'Sheet03'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet03 |  | 0 | 0 | 0 | 0
 | Sheet04 | 'Sheet04'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet04 |  | 0 | 0 | 0 | 0
 | Sheet05 | 'Sheet05'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet05 |  | 0 | 0 | 0 | 0
 | Sheet06 | 'Sheet06'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet06 |  | 0 | 0 | 0 | 0
 | Sheet07 | 'Sheet07'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet07 |  | 0 | 0 | 0 | 0
 | Sheet08 | 'Sheet08'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet08 |  | 0 | 0 | 0 | 0
 | Sheet09 | 'Sheet09'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet09 |  | 0 | 0 | 0 | 0
 | Sheet10 | 'Sheet10'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet10 |  | 0 | 0 | 0 | 0
 | Sheet11 | 'Sheet11'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet11 |  | 0 | 0 | 0 | 0
 | Sheet12 | 'Sheet12'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet12 |  | 0 | 0 | 0 | 0
 | Sheet13 | 'Sheet13'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet13 |  | 0 | 0 | 0 | 0
 | Sheet14 | 'Sheet14'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet14 |  | 0 | 0 | 0 | 0
 | Sheet15 | 'Sheet15'!g1:g500 |  |  |  |  | 0 |  |  |  | 0 |  |  | Sheet15 |  | 0 | 0 | 0 | 0
 | Total: |  |  |  |  |  |  |  |  |  |  |  |  | Total: |  | 12 | 240 | 60 | 0.25