{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Detail Monthly Man Power (2)","Sheet2","Sheet3"],"not_rendered":{"external_links":3,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Detail Monthly Man Power (2)","index":0,"n_rows":22,"n_cols":52,"rows_kept":22,"merged":[[1,1,3,1],[1,2,3,3],[1,5,3,8],[1,9,3,9],[5,1,6,1],[5,2,5,11],[5,12,5,21],[5,22,5,31],[5,32,5,41],[5,42,5,51],[19,1,19,8],[19,12,19,19],[19,22,19,29],[19,32,19,39],[19,42,19,49],[21,1,26,7]]}
[]
[null,"4 Weeks: Monthly Average",{"$f":"SUM(L20,V20,AF20,AP20)/4","v":{"v":71.625,"d":"72"}}]
[]
[]
[]
[null,"Name of Contractors","Week 1",{"$nulls":9},"Week 2",{"$nulls":9},"Week 3",{"$nulls":9},"Week 4",{"$nulls":9},"Week 5"]
[null,null,"Mon","Tue","Wed","Thu","Fri","Sat","Sun","Nr. D/W","Weekly Count","Contractor Av/W","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Nr. D/W","Weekly Count","Contractor Av/W","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Nr. D/W","Weekly Count","Contractor Av/W","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Nr. D/W","Weekly Count","Contractor Av/W","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Nr. D/W","Weekly Count","Contractor Av/W"]
[null,"Panel (e.g. TAP; NCC; etc)",200,2,1,1,1,2,0,{"$f":"COUNTIF(C8:I8,\"<>0\")","v":6},{"$f":"SUM(C8:I8)","v":207},{"$f":"IF(J8=0,0,K8/J8)","v":{"v":34.5,"d":"35"}},11,11,11,11,11,11,11,{"$f":"COUNTIF(M8:S8,\"<>0\")","v":7},{"$f":"SUM(M8:S8)","v":77},{"$f":"U8/T8","v":11},11,11,11,11,11,11,11,{"$f":"COUNTIF(W8:AC8,\"<>0\")","v":7},{"$f":"SUM(W8:AC8)","v":77},{"$f":"AE8/AD8","v":11},11,11,11,11,11,11,11,{"$f":"COUNTIF(AG8:AM8,\"<>0\")","v":7},{"$f":"SUM(AG8:AM8)","v":77},{"$f":"AO8/AN8","v":11},0,0,0,0,0,0,0,{"$f":"COUNTIF(AQ8:AW8,\"<>0\")","v":0},{"$f":"SUM(AQ8:AW8)","v":0},{"$f":"AY8/AX8","v":{"$error":"#DIV/0!"}}]
[null,"Contractor 1",10,10,10,10,10,10,10,{"$f":"COUNTIF(C9:I9,\"<>0\")","v":7},70,{"$f":"IF(J9=0,0,K9/J9)","v":10},10,10,10,10,10,10,10,{"$f":"COUNTIF(M9:S9,\"<>0\")","v":7},70,{"$f":"U9/T9","v":10},10,10,10,10,10,10,10,{"$f":"COUNTIF(W9:AC9,\"<>0\")","v":7},70,{"$f":"AE9/AD9","v":10},10,10,10,10,10,10,10,{"$f":"COUNTIF(AG9:AM9,\"<>0\")","v":7},{"$f":"SUM(AG9:AM9)","v":70},{"$f":"AO9/AN9","v":10},0,0,0,0,0,0,0,{"$f":"COUNTIF(AQ9:AW9,\"<>0\")","v":0},{"$f":"SUM(AQ9:AW9)","v":0},{"$f":"AY9/AX9","v":{"$error":"#DIV/0!"}}]
[null,"Contractor 2",9,0,9,9,9,9,9,6,54,9,9,9,9,9,9,9,9,7,63,9,9,9,9,9,9,9,9,7,63,9,9,9,9,9,9,9,9,7,63,9,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 3",8,8,8,8,8,8,8,7,56,8,8,8,8,8,8,8,8,7,56,8,8,8,8,8,8,8,8,7,56,8,8,8,8,8,8,8,8,7,56,8,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 4",7,7,7,7,7,7,7,7,49,7,7,7,7,7,7,7,7,7,49,7,7,7,7,7,7,7,7,7,49,7,7,7,7,7,7,7,7,7,49,7,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 5",6,6,6,6,6,6,6,7,42,6,6,6,6,6,6,6,6,7,42,6,6,6,6,6,6,6,6,7,42,6,6,6,6,6,6,6,6,7,42,6,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 6",5,5,5,5,5,5,5,7,35,5,5,5,5,5,5,5,5,7,35,5,5,5,5,5,5,5,5,7,35,5,5,5,5,5,5,5,5,7,35,5,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 7",4,4,4,4,4,4,4,7,28,4,4,4,4,4,4,4,4,7,28,4,4,4,4,4,4,4,4,7,28,4,4,4,4,4,4,4,4,7,28,4,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 8",3,3,3,3,3,3,3,7,21,3,3,3,3,3,3,3,3,7,21,3,3,3,3,3,3,3,3,7,21,3,3,3,3,3,3,3,3,7,21,3,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 9",2,2,2,2,2,2,2,7,14,2,2,2,2,2,2,2,2,7,14,2,2,2,2,2,2,2,2,7,14,2,2,2,2,2,2,2,2,7,14,2,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Contractor 10",0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,7,7,1,1,1,1,1,1,1,1,7,7,1,1,1,1,1,1,1,1,7,7,1,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":10},{"$f":"SUM(K8:K18)","v":576},{"$f":"SUM(L8:L18)","v":{"v":88.5,"d":"89"}},{"$nulls":8},{"$f":"SUM(U8:U18)","v":462},{"$f":"SUM(V8:V18)","v":66},{"$nulls":8},{"$f":"SUM(AE8:AE18)","v":462},{"$f":"SUM(AF8:AF18)","v":66},{"$nulls":8},{"$f":"SUM(AO8:AO18)","v":462},{"$f":"SUM(AP8:AP18)","v":66},{"$nulls":8},{"$f":"SUM(AY8:AY18)","v":0},{"$f":"SUM(AZ8:AZ18)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Instructions:\n1. You must put the actual head count on each day e.g 11\n2. If there were no contractors on a specific day put 0, don't leave an empty space "]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":3,"rows_kept":11}
["A1/A2, use =IF(A2=0,\"\",A1/A2) to return an empty string, or =IF(A2=0,0,A1/A2) to return 0."]
[]
[]
[]
[]
[null,null,"A"]
[null,1,1]
[null,2,0]
[null,3,{"$f":"'Detail Monthly Man Power (2)'!A1/0","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"'Detail Monthly Man Power (2)'!A1/'Detail Monthly Man Power (2)'!A2","v":{"$error":"#DIV/0!"}}]
[null,5,{"$f":"QUOTIENT('Detail Monthly Man Power (2)'!A1,'Detail Monthly Man Power (2)'!A2)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}