{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Rented Equip."],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Rented Equip.","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"merged":[[0,1,0,12],[1,1,3,7],[4,7,4,8],[4,9,4,12],[5,1,5,3],[5,4,5,5],[5,6,5,8],[5,9,5,12],[6,9,6,12],[7,1,7,5],[7,6,7,8],[7,9,7,10],[8,1,8,12],[9,1,9,12],[10,1,11,1],[10,2,11,3],[10,4,10,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,10,10],[10,11,11,11],[10,12,11,12],[10,14,10,15],[11,4,11,5],[12,1,15,1],[12,4,15,5],[12,6,15,6],[12,7,15,7],[12,8,15,8],[12,9,15,9],[12,10,15,10],[12,11,15,11],[12,12,15,12],[12,14,15,14],[12,15,15,15],[12,16,15,16],[16,1,19,1],[16,4,19,5],[16,6,19,6],[16,7,19,7],[16,8,19,8],[16,9,19,9],[16,10,19,10],[16,11,19,11],[16,12,19,12],[16,14,19,14],[16,15,19,15],[16,16,19,16],[20,1,23,1],[20,4,23,5],[20,6,23,6],[20,7,23,7],[20,8,23,8],[20,9,23,9],[20,10,23,10],[20,11,23,11],[20,12,23,12],[20,14,23,14],[20,15,23,15],[20,16,23,16],[24,1,27,1],[24,4,27,5],[24,6,27,6],[24,7,27,7],[24,8,27,8],[24,9,27,9],[24,10,27,10],[24,11,27,11],[24,12,27,12],[24,14,27,14],[24,15,27,15],[24,16,27,16],[28,1,31,1],[28,4,31,5],[28,6,31,6],[28,7,31,7],[28,8,31,8],[28,9,31,9],[28,10,31,10],[28,11,31,11],[28,12,31,12],[28,14,31,14],[28,15,31,15],[28,16,31,16],[32,1,35,1],[32,4,35,5],[32,6,35,6],[32,7,35,7],[32,8,35,8],[32,9,35,9],[32,10,35,10],[32,11,35,11],[32,12,35,12],[32,14,35,14],[32,15,35,15],[32,16,35,16],[36,1,39,1],[36,4,39,5],[36,6,39,6],[36,7,39,7],[36,8,39,8],[36,9,39,9],[36,10,39,10],[36,11,39,11],[36,12,39,12],[36,14,39,14],[36,15,39,15],[36,16,39,16],[40,1,43,1],[40,4,43,5],[40,6,43,6],[40,7,43,7],[40,8,43,8],[40,9,43,9],[40,10,43,10],[40,11,43,11],[40,12,43,12],[40,14,43,14],[40,15,43,15],[40,16,43,16],[44,1,47,1],[44,4,47,5],[44,6,47,6],[44,7,47,7],[44,8,47,8],[44,9,47,9],[44,10,47,10],[44,11,47,11],[44,12,47,12],[44,14,47,14],[44,15,47,15],[44,16,47,16],[48,1,48,10],[49,1,49,10],[50,1,50,10],[51,1,51,12],[53,1,53,6],[53,7,53,10],[53,11,53,12]]}
[null,"ONLY need to fill out the yellow boxes because the white boxes are auto filled from previous sheets."]
[null,"RENTED EQUIPMENT SUMMARY FORM"]
[]
[{"$nulls":9},"PAGE",null,"OF"]
[null," APPLICANT",null,null,"PROJECT NO.",null," PA ID NO.",null," PROJECT NO.","DISASTER"]
[]
[null," LOCATION / SITE",{"$nulls":4}," CATEGORY",null,null," PERIOD COVERING"]
[{"$nulls":11},"TO"]
[null," DESCRIPTION OF WORK PERFORMED"]
[]
[null,"Vendor","Equipment Used For",null,"TYPE OF EQUIPMENT",null,"Invoice Number","Dates Used","Hours Used ","Rate per Hour / Mile",null,"Cost","DHS&EM\nuse only\n(Final costs after audit)",null,"Do Not Delete (Formula)",null,"(Validations)"]
[{"$nulls":4},"Indicate size, Capacity, Horsepower, Make and Models as Appropriate",{"$nulls":4},"With Operator","Without Operator",{"$nulls":3},"Project","Admin"]
[{"$nulls":9},0,0,{"$f":"(I13*J13)+(I13*K13)","v":0},null,null,{"$f":"SUMIF(C14,\"x\",L13)","v":0},{"$f":"SUMIF(C16,\"x\",L13)","v":0},"x"]
[{"$nulls":3},"Project",{"$nulls":12},"X"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I17*J17)+(I17*K17)","v":0},null,null,{"$f":"SUMIF(C18,\"x\",L17)","v":0},{"$f":"SUMIF(C20,\"x\",L17)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I21*J21)+(I21*K21)","v":0},null,null,{"$f":"SUMIF(C22,\"x\",L21)","v":0},{"$f":"SUMIF(C24,\"x\",L21)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I25*J25)+(I25*K25)","v":0},null,null,{"$f":"SUMIF(C26,\"x\",L25)","v":0},{"$f":"SUMIF(C28,\"x\",L25)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I29*J29)+(I29*K29)","v":0},null,null,{"$f":"SUMIF(C30,\"x\",L29)","v":0},{"$f":"SUMIF(C32,\"x\",L29)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I33*J33)+(I33*K33)","v":0},null,null,{"$f":"SUMIF(C34,\"x\",L33)","v":0},{"$f":"SUMIF(C36,\"x\",L33)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I37*J37)+(I37*K37)","v":0},null,null,{"$f":"SUMIF(C38,\"x\",L37)","v":0},{"$f":"SUMIF(C40,\"x\",L37)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I41*J41)+(I41*K41)","v":0},null,null,{"$f":"SUMIF(C42,\"x\",L41)","v":0},{"$f":"SUMIF(C44,\"x\",L41)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[{"$nulls":9},0,0,{"$f":"(I45*J45)+(I45*K45)","v":0},null,null,{"$f":"SUMIF(C46,\"x\",L45)","v":0},{"$f":"SUMIF(C48,\"x\",L45)","v":0}]
[{"$nulls":3},"Project"]
[]
[{"$nulls":3},"Administrative"]
[null,"RENTED EQUIPMENT FOR ADMINISTRATIVE USE",{"$nulls":9},{"$f":"P49","v":0},null,null,{"$f":"SUM(O13:O48)","v":0},{"$f":"SUM(P13:P48)","v":0}]
[null,"RENTED EQUIPMENT FOR PROJECT USE",{"$nulls":9},{"$f":"O49","v":0}]
[null,"RENTED EQUIPMENT TOTAL",{"$nulls":9},{"$f":"O49+P49","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":3},"Date"]