{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Template 1","Template 2"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Template 1","index":0,"n_rows":43,"n_cols":12,"rows_kept":43}
[{"$nulls":3},"Work In","Date",{"$nulls":3},"Payroll"]
[null,"Period","Period","Period?","Payroll","Date ","Received","Days","Checked?",null,null,{"$f":"IF(H2=\"On Time\",1,\"\")","v":""}]
["Project/Company","From","To"," (X for Yes)","Processed","Due","Date","Late","(X for Yes)","Remarks",null,{"$f":"IF(H3=\"On Time\",1,\"\")","v":""}]
["J#",{"$nulls":8},"Started Work  00/00/15     Fringe Benefits Checked:"]
["Contract ID","2015-01-01","2015-01-07","X","2015-01-14",{"$f":"IF(D5=\"X\",IF(E5=0,\"Waiting\",E5+7),\"---\")","v":"2015-01-21"},"2015-01-22",{"$f":"IFERROR(IF(G5=0,\"---\",IF((G5-F5)<=0,\"On Time\",G5-F5)),\"---\")","v":1},"X"]
["Prime Contractor","2015-01-08","2015-01-14",null,null,"---",null,{"$f":"IFERROR(IF(G6=0,\"---\",IF((G6-F6)<=0,\"On Time\",G6-F6)),\"---\")","v":"---"}]
[{"$nulls":5},"---",null,{"$f":"IFERROR(IF(G7=0,\"---\",IF((G7-F7)<=0,\"On Time\",G7-F7)),\"---\")","v":"---"}]
[{"$nulls":5},"---"," ",{"$f":"IFERROR(IF(G8=0,\"---\",IF((G8-F8)<=0,\"On Time\",G8-F8)),\"---\")","v":"---"}]
[]
["Total Weeks Worked",null,{"$f":"COUNTIF(D5:D8,\"X\")","v":1}]
["Total Weeks With Received Payrolls",null,{"$f":"COUNT(G5:G8)","v":1},{"$nulls":8},{"$f":"IF(H11=\"On Time\",1,\"\")","v":""}]
["Payrolls Checked",null,{"$f":"COUNTIF(I5:I8,\"X\")","v":1}]
["On Time Payrolls",null,{"$f":"COUNTIF(H5:H8,\"On Time\")","v":0},{"$nulls":8},{"$f":"IF(H13=\"On Time\",1,\"\")","v":""}]
["Missing Payrolls",{"$f":"C10-C11","v":0}]
["Percentage of Payrolls Checked",{"$f":"C12/C11","v":{"v":1,"d":"100%"}},{"$f":"IF(B15<0.5,\"Check More (50% Min.)\",\"\")","v":""}]
["Percentage Received On Time",{"$f":"C13/C11","v":{"v":0,"d":"0%"}},{"$nulls":9},{"$f":"IF(H16=\"On Time\",1,\"\")","v":""}]
[]
[{"$nulls":11},{"$f":"IF(H18=\"On Time\",1,\"\")","v":""}]
[{"$nulls":3},"Work In","Date",{"$nulls":3},"Payroll"]
[null,"Period","Period","Period?","Payroll","Date ","Received","Days","Checked?",null,null,{"$f":"IF(H20=\"On Time\",1,\"\")","v":""}]
["Project/Company","From","To","(X for Yes)","Processed","Due","Date","Late","(X for Yes)","Remarks",null,{"$f":"IF(H21=\"On Time\",1,\"\")","v":""}]
["J#",{"$nulls":8},"Started Work  00/00/15     Fringe Benefits Checked:"]
["Contract ID","2015-01-01","2015-01-07","X","2015-01-14",{"$f":"IF(D23=\"X\",IF(E23=0,\"Waiting\",E23+7),\"---\")","v":"2015-01-21"},"2015-01-21",{"$f":"IFERROR(IF(G23=0,\"---\",IF((G23-F23)<=0,\"On Time\",G23-F23)),\"---\")","v":"On Time"}]
["Sub- Contractor","2015-01-08","2015-01-14",null,null,"---",null,{"$f":"IFERROR(IF(G24=0,\"---\",IF((G24-F24)<=0,\"On Time\",G24-F24)),\"---\")","v":"---"}]
[{"$nulls":5},"---",null,{"$f":"IFERROR(IF(G25=0,\"---\",IF((G25-F25)<=0,\"On Time\",G25-F25)),\"---\")","v":"---"}]
[{"$nulls":5},"---"," ",{"$f":"IFERROR(IF(G26=0,\"---\",IF((G26-F26)<=0,\"On Time\",G26-F26)),\"---\")","v":"---"}]
[]
["Total Weeks Worked",null,{"$f":"COUNTIF(D23:D26,\"X\")","v":1}]
["Total Weeks With Received Payrolls",null,{"$f":"COUNT(G23:G26)","v":1},{"$nulls":8},{"$f":"IF(H29=\"On Time\",1,\"\")","v":""}]
["Payrolls Checked",null,{"$f":"COUNTIF(I23:I26,\"X\")","v":0}]
["On Time Payrolls",null,{"$f":"COUNTIF(H23:H26,\"On Time\")","v":1},{"$nulls":8},{"$f":"IF(H31=\"On Time\",1,\"\")","v":""}]
["Missing Payrolls",{"$f":"C28-C29","v":0}]
["Percentage of Payrolls Checked",{"$f":"C30/C29","v":{"v":0,"d":"0%"}},{"$f":"IF(B33<0.5,\"Check More (50% Min.)\",\"\")","v":"Check More (50% Min.)"}]
["Percentage Received On Time",{"$f":"C31/C29","v":{"v":1,"d":"100%"}},{"$nulls":9},{"$f":"IF(H34=\"On Time\",1,\"\")","v":""}]
[]
[{"$nulls":11},{"$f":"IF(H36=\"On Time\",1,\"\")","v":""}]
[]
["Total Missing Payrolls For Project",{"$f":"SUM(B14+B32)","v":0}]
[]
["Total Percentage Payrolls Checked",{"$f":"SUM(C12+C30)/SUM(C11+C29)","v":{"v":0.5,"d":"50%"}},{"$f":"IF(B40<0.5,\"Check More (50% Min.)\",\"\")","v":""}]
[]
["Total Project On Time Percentage",{"$f":"SUM(C13+C31)/SUM(C11+C29)","v":{"v":0.5,"d":"50%"}},{"$nulls":7},{"$f":"IF(G42=\"On Time\",1,\"\")","v":""}]
[{"$nulls":11},{"$f":"IF(H43=\"On Time\",1,\"\")","v":""}]

{"sheet":"Template 2","index":1,"n_rows":45,"n_cols":30,"rows_kept":45,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[6,2,6,8],[6,9,6,15],[6,16,6,22],[6,23,6,29],[36,0,36,1],[37,0,37,1],[37,3,37,5],[37,10,37,12],[37,17,37,19],[37,24,37,26],[38,3,38,5],[38,10,38,12],[38,17,38,19],[38,24,38,26],[39,3,39,5],[39,10,39,12],[39,17,39,19],[39,24,39,26],[40,0,40,1],[40,3,40,5],[40,10,40,12],[40,17,40,19],[40,24,40,26],[41,3,41,5],[41,10,41,12],[41,17,41,19],[41,24,41,26],[42,3,42,5],[42,10,42,12],[42,17,42,19],[42,24,42,26],[43,0,43,1],[43,3,43,5],[43,10,43,12],[43,17,43,19],[43,24,43,26]]}
["Project"]
["Prime Contractor"]
["Job Number"]
["Contract ID"]
["Start Date"]
[]
[null,null,"XXXX - Prime Contractor",{"$nulls":6},"XXXX - Sub-Contractor",{"$nulls":6},"XXXX - Sub-Contractor",{"$nulls":6},"XXXX - Sub-Contractor"]
["Period\nFrom","Period\nTo","Work In Period?\n(X for Yes)","Date \nPayroll\nProcessed","Due\nDate","Received\nDate","Days\nLate","Payroll\nChecked?\n(X for Yes)","Comments","Work In Period?\n(X for Yes)","Date \nPayroll\nProcessed","Due\nDate","Received\nDate","Days\nLate","Payroll\nChecked?\n(X for Yes)","Comments","Work In Period?\n(X for Yes)","Date \nPayroll\nProcessed","Due\nDate","Received\nDate","Days\nLate","Payroll\nChecked?\n(X for Yes)","Comments","Work In Period?\n(X for Yes)","Date \nPayroll\nProcessed","Due\nDate","Received\nDate","Days\nLate","Payroll\nChecked?\n(X for Yes)","Comments"]
[{"$nulls":8},"Started Work: 00/00/15",{"$nulls":6},"Started Work: 00/00/15",{"$nulls":6},"Started Work: 00/00/15",{"$nulls":6},"Started Work: 00/00/15"]
[{"$nulls":8},"Fringe Benefits Checked: ",{"$nulls":6},"Fringe Benefits Checked: ",{"$nulls":6},"Fringe Benefits Checked: ",{"$nulls":6},"Fringe Benefits Checked: "]
["2015-01-01","2015-01-07","X","2015-01-14",{"$f":"IF(C11=\"X\",IF(D11=0,\"Waiting\",D11+7),\"---\")","v":"2015-01-21"},"2015-01-21",{"$f":"IFERROR(IF(F11=0,\"---\",IF((F11-E11)<=0,\"On Time\",F11-E11)),\"---\")","v":"On Time"},"X",null,"X","2015-01-14",{"$f":"IF(J11=\"X\",IF(K11=0,\"Waiting\",K11+7),\"---\")","v":"2015-01-21"},"2015-01-22",{"$f":"IFERROR(IF(M11=0,\"---\",IF((M11-L11)<=0,\"On Time\",M11-L11)),\"---\")","v":1},"X",null,"X","2015-01-14",{"$f":"IF(Q11=\"X\",IF(R11=0,\"Waiting\",R11+7),\"---\")","v":"2015-01-21"},"2015-01-20",{"$f":"IFERROR(IF(T11=0,\"---\",IF((T11-S11)<=0,\"On Time\",T11-S11)),\"---\")","v":"On Time"},null,null,"X",null,{"$f":"IF(X11=\"X\",IF(Y11=0,\"Waiting\",Y11+7),\"---\")","v":"Waiting"},null,{"$f":"IFERROR(IF(AA11=0,\"---\",IF((AA11-Z11)<=0,\"On Time\",AA11-Z11)),\"---\")","v":"---"}]
["2015-01-08","2015-01-14",null,null,{"$f":"IF(C12=\"X\",IF(D12=0,\"Waiting\",D12+7),\"---\")","v":"---"},null,{"$f":"IFERROR(IF(F12=0,\"---\",IF((F12-E12)<=0,\"On Time\",F12-E12)),\"---\")","v":"---"},{"$nulls":4},{"$f":"IF(J12=\"X\",IF(K12=0,\"Waiting\",K12+7),\"---\")","v":"---"},null,{"$f":"IFERROR(IF(M12=0,\"---\",IF((M12-L12)<=0,\"On Time\",M12-L12)),\"---\")","v":"---"},{"$nulls":4},{"$f":"IF(Q12=\"X\",IF(R12=0,\"Waiting\",R12+7),\"---\")","v":"---"},null,{"$f":"IFERROR(IF(T12=0,\"---\",IF((T12-S12)<=0,\"On Time\",T12-S12)),\"---\")","v":"---"},{"$nulls":4},{"$f":"IF(X12=\"X\",IF(Y12=0,\"Waiting\",Y12+7),\"---\")","v":"---"},null,{"$f":"IFERROR(IF(AA12=0,\"---\",IF((AA12-Z12)<=0,\"On Time\",AA12-Z12)),\"---\")","v":"---"}]
[{"$nulls":4},{"$f":"IF(C13=\"X\",IF(D13=0,\"Waiting\",D13+7),\"---\")","v":"---"},null,"---",{"$nulls":4},{"$f":"IF(J13=\"X\",IF(K13=0,\"Waiting\",K13+7),\"---\")","v":"---"},null,"---",{"$nulls":4},{"$f":"IF(Q13=\"X\",IF(R13=0,\"Waiting\",R13+7),\"---\")","v":"---"},null,"---",{"$nulls":4},{"$f":"IF(X13=\"X\",IF(Y13=0,\"Waiting\",Y13+7),\"---\")","v":"---"},null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---",{"$nulls":4},"---",null,"---"]
[]
[]
["Total Missing Payrolls",null,null,"Total Weeks Worked",{"$nulls":3},{"$f":"COUNTIF(C11:C35,\"X\")","v":1},null,null,"Total Weeks Worked",{"$nulls":3},{"$f":"COUNTIF(J11:J35,\"X\")","v":1},null,null,"Total Weeks Worked",{"$nulls":3},{"$f":"COUNTIF(Q11:Q35,\"X\")","v":1},null,null,"Total Weeks Worked",{"$nulls":3},{"$f":"COUNTIF(X11:X35,\"X\")","v":1}]
[{"$f":"SUM(C42:AAB42)","v":1},null,null,"Total Weeks With Received Payrolls",{"$nulls":3},{"$f":"COUNT(F11:F35)","v":1},null,null,"Total Weeks With Received Payrolls",{"$nulls":3},{"$f":"COUNT(M11:M35)","v":1},null,null,"Total Weeks With Received Payrolls",{"$nulls":3},{"$f":"COUNT(T11:T35)","v":1},null,null,"Total Weeks With Received Payrolls",{"$nulls":3},{"$f":"COUNT(AA11:AA35)","v":0}]
[{"$nulls":3},"Payrolls Checked",{"$nulls":3},{"$f":"COUNTIF(H11:H35,\"X\")","v":1},null,null,"Payrolls Checked",{"$nulls":3},{"$f":"COUNTIF(O11:O35,\"X\")","v":1},null,null,"Payrolls Checked",{"$nulls":3},{"$f":"COUNTIF(V11:V35,\"X\")","v":0},null,null,"Payrolls Checked",{"$nulls":3},{"$f":"COUNTIF(AC11:AC35,\"X\")","v":0}]
["Total % Payrolls Checked",null,null,"On Time",{"$nulls":3},{"$f":"COUNTIF(G11:G35,\"On Time\")","v":1},null,null,"On Time",{"$nulls":3},{"$f":"COUNTIF(N11:N35,\"On Time\")","v":0},null,null,"On Time",{"$nulls":3},{"$f":"COUNTIF(U11:U35,\"On Time\")","v":1},null,null,"On Time",{"$nulls":3},{"$f":"COUNTIF(AB11:AB35,\"On Time\")","v":0}]
[{"$f":"SUM(C40:AAB40)/SUM(C39:AAB39)","v":{"v":0.6666666666666666,"d":"67%"}},null,null,"Missing Payrolls",null,null,{"$f":"H38-H39","v":0},{"$nulls":3},"Missing Payrolls",null,null,{"$f":"O38-O39","v":0},{"$nulls":3},"Missing Payrolls",null,null,{"$f":"V38-V39","v":0},{"$nulls":3},"Missing Payrolls",null,null,{"$f":"AC38-AC39","v":1}]
[{"$nulls":3},"Percentage of Payrolls Checked",null,null,{"$f":"H40/H39","v":{"v":1,"d":"100%"}},{"$f":"IF(G43<0.5,\"Check More (50% Min.)\",\"\")","v":""},null,null,"Percentage of Payrolls Checked",null,null,{"$f":"O40/O39","v":{"v":1,"d":"100%"}},{"$f":"IF(N43<0.5,\"Check More (50% Min.)\",\"\")","v":""},null,null,"Percentage of Payrolls Checked",null,null,{"$f":"V40/V39","v":{"v":0,"d":"0%"}},{"$f":"IF(U43<0.5,\"Check More (50% Min.)\",\"\")","v":"Check More (50% Min.)"},null,null,"Percentage of Payrolls Checked",null,null,{"$f":"AC40/AC39","v":{"$error":"#DIV/0!"}},{"$f":"IF(AB43<0.5,\"Check More (50% Min.)\",\"\")","v":{"$error":"#DIV/0!"}}]
["Total Project % On Time",null,null,"Percentage Received On Time",null,null,{"$f":"H41/H39","v":{"v":1,"d":"100%"}},{"$nulls":3},"Percentage Received On Time",null,null,{"$f":"O41/O39","v":{"v":0,"d":"0%"}},{"$nulls":3},"Percentage Received On Time",null,null,{"$f":"V41/V39","v":{"v":1,"d":"100%"}},{"$nulls":3},"Percentage Received On Time",null,null,{"$f":"AC41/AC39","v":{"$error":"#DIV/0!"}}]
[{"$f":"SUM(C41:AAB41)/SUM(C39:AAB39)","v":{"v":0.6666666666666666,"d":"67%"}}]