{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Force Acct Labor 7 DY","Sheet1"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Force Acct Labor 7 DY","index":0,"n_rows":45,"n_cols":18,"rows_kept":45,"merged":[[0,1,0,16],[1,1,3,11],[4,1,4,4],[4,5,4,8],[4,9,4,13],[4,14,4,16],[5,1,5,4],[5,5,5,8],[5,9,5,13],[5,14,5,16],[6,1,6,8],[6,9,6,13],[6,14,6,16],[7,1,7,8],[7,9,7,13],[7,14,7,15],[7,16,7,17],[9,1,9,17],[10,1,11,1],[10,2,11,2],[10,3,10,11],[10,12,10,17],[12,2,15,2],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,14],[12,15,13,15],[12,16,13,16],[12,17,13,17],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,15,15,15],[14,16,15,16],[14,17,15,17],[16,2,19,2],[16,4,17,4],[16,5,17,5],[16,6,17,6],[16,7,17,7],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,11,17,11],[16,12,17,12],[16,13,17,13],[16,14,17,14],[16,15,17,15],[16,16,17,16],[16,17,17,17],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12],[18,13,19,13],[18,14,19,14],[18,15,19,15],[18,16,19,16],[18,17,19,17],[20,2,23,2],[20,4,21,4],[20,5,21,5],[20,6,21,6],[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[20,11,21,11],[20,12,21,12],[20,13,21,13],[20,14,21,14],[20,15,21,15],[20,16,21,16],[20,17,21,17],[22,4,23,4],[22,5,23,5],[22,6,23,6],[22,7,23,7],[22,8,23,8],[22,9,23,9],[22,10,23,10],[22,11,23,11],[22,12,23,12],[22,13,23,13],[22,14,23,14],[22,15,23,15],[22,16,23,16],[22,17,23,17],[24,2,27,2],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[24,10,25,10],[24,11,25,11],[24,12,25,12],[24,13,25,13],[24,14,25,14],[24,15,25,15],[24,16,25,16],[24,17,25,17],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[26,11,27,11],[26,12,27,12],[26,13,27,13],[26,14,27,14],[26,15,27,15],[26,16,27,16],[26,17,27,17],[28,2,31,2],[28,4,29,4],[28,5,29,5],[28,6,29,6],[28,7,29,7],[28,8,29,8],[28,9,29,9],[28,10,29,10],[28,11,29,11],[28,12,29,12],[28,13,29,13],[28,14,29,14],[28,15,29,15],[28,16,29,16],[28,17,29,17],[30,4,31,4],[30,5,31,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[30,9,31,9],[30,10,31,10],[30,11,31,11],[30,12,31,12],[30,13,31,13],[30,14,31,14],[30,15,31,15],[30,16,31,16],[30,17,31,17],[32,2,35,2],[32,4,33,4],[32,5,33,5],[32,6,33,6],[32,7,33,7],[32,8,33,8],[32,9,33,9],[32,10,33,10],[32,11,33,11],[32,12,33,12],[32,13,33,13],[32,14,33,14],[32,15,33,15],[32,16,33,16],[32,17,33,17],[34,4,35,4],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[34,9,35,9],[34,10,35,10],[34,11,35,11],[34,12,35,12],[34,13,35,13],[34,14,35,14],[34,15,35,15],[34,16,35,16],[34,17,35,17],[36,2,39,2],[36,4,37,4],[36,5,37,5],[36,6,37,6],[36,7,37,7],[36,8,37,8],[36,9,37,9],[36,10,37,10],[36,11,37,11],[36,12,37,12],[36,13,37,13],[36,14,37,14],[36,15,37,15],[36,16,37,16],[36,17,37,17],[38,4,39,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[38,10,39,10],[38,11,39,11],[38,12,39,12],[38,13,39,13],[38,14,39,14],[38,15,39,15],[38,16,39,16],[38,17,39,17],[40,1,40,15],[41,1,41,15],[42,1,42,15],[43,1,43,17],[45,1,45,6],[45,7,45,14],[45,15,45,17]]}
[null,"ONLY need to fill out the yellow boxes because the white boxes are automatically filled from previous sheets.  Period Covering is filled in when you put the dates for the week in."]
[null,"LABOR SUMMARY FORM (PROJECT)"]
[]
[{"$nulls":12},"PAGE ",null,"OF"]
[null,"APPLICANT ",{"$nulls":3},"PA ID NO.",{"$nulls":3},"PROJECT NO.",{"$nulls":4},"DISASTER"]
[{"$nulls":5}," "]
[null,"LOCATION / SITE",{"$nulls":7},"Category",{"$nulls":4},"PERIOD COVERING"]
[{"$nulls":9},"  "]
[null,"DESCRIPTION OF WORK PERFORMED"]
[]
[null,null,"Type of Employee (Permanent, Temporary, Seasonal)","Dates and Hours Worked Each Week",{"$nulls":8},"Costs"]
[{"$nulls":3},"Date",{"$nulls":8},"Hours","Hourly Rate","Benefit Rate per Hour","Total Hourly Rate","Cost","DHS&EM Use Only\n(Final costs after audit)"]
[null,"NAME 1",{"$nulls":10},{"$f":"SUM(E13:L14)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"(N13*O13)+N13","v":0},{"$f":"+P13*M13","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E15:L16)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N15*O15+N15","v":0},{"$f":"+P15*M15","v":0}]
[{"$nulls":3},"O.T."]
[null,"NAME 2",{"$nulls":10},{"$f":"SUM(E17:L18)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N17*O17+N17","v":0},{"$f":"+P17*M17","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E19:L20)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N19*O19+N19","v":0},{"$f":"+P19*M19","v":0}]
[{"$nulls":3},"O.T."]
[null,"NAME 3",{"$nulls":10},{"$f":"SUM(E21:L22)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N21*O21+N21","v":0},{"$f":"+P21*M21","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E23:L24)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N23*O23+N23","v":0},{"$f":"+P23*M23","v":0}]
[{"$nulls":3},"O.T."]
[null,"NAME 4",{"$nulls":10},{"$f":"SUM(E25:L26)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N25*O25+N25","v":0},{"$f":"+P25*M25","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E27:L28)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N27*O27+N27","v":0},{"$f":"+P27*M27","v":0}]
[{"$nulls":3},"O.T."]
[null,"NAME 5",{"$nulls":10},{"$f":"SUM(E29:L30)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N29*O29+N29","v":0},{"$f":"+P29*M29","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E31:L32)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N31*O31+N31","v":0},{"$f":"+P31*M31","v":0}]
[{"$nulls":3},"O.T."]
[null,"NAME 6",{"$nulls":10},{"$f":"SUM(E33:L34)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N33*O33+N33","v":0},{"$f":"+P33*M33","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E35:L36)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N35*O35+N35","v":0},{"$f":"+P35*M35","v":0}]
[{"$nulls":3},"O.T."]
[null,"NAME 7",{"$nulls":10},{"$f":"SUM(E37:L38)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N37*O37+N37","v":0},{"$f":"+P37*M37","v":0}]
[{"$nulls":3},"REG."]
[null,"JOB TITLE",{"$nulls":10},{"$f":"SUM(E39:L40)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+N39*O39+N39","v":0},{"$f":"+P39*M39","v":0}]
[{"$nulls":3},"O.T."]
[null,"PROJECT LABOR REGULAR TIME",{"$nulls":14},{"$f":"Q13+Q17+Q21+Q25+Q29+Q33+Q37","v":0}]
[null,"PROJECT LABOR OVERTIME",{"$nulls":14},{"$f":"Q15+Q19+Q23+Q27+Q31+Q35+Q39","v":0}]
[null,"TOTAL COSTS FOR LABOR",{"$nulls":14},{"$f":"SUM(Q13:Q40)","v":0}]
[null,"I CERTIFY THAT THE ABOVE INFORMATION WAS OBTAINED FROM PAYROLL RECORDS, INVOICES, OR OTHER DOCUMENTS THAT ARE AVAILABLE FOR AUDIT."]
[null,"Certifier's Printed Name and Title ",{"$nulls":5},"Certifier's Signature",{"$nulls":7},"Date"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}