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

{"sheet":"Contract Work","index":0,"n_rows":46,"n_cols":19,"rows_kept":46,"merged":[[0,1,0,14],[1,1,3,9],[5,1,5,6],[5,7,5,8],[5,9,5,11],[5,12,5,14],[6,1,6,8],[6,11,6,14],[7,1,7,8],[8,1,8,14],[9,1,9,14],[9,16,9,17],[10,2,10,3],[10,4,10,5],[10,11,10,14],[11,1,13,1],[11,2,13,3],[11,6,13,6],[11,7,13,7],[11,8,13,8],[11,9,13,9],[11,10,13,10],[11,11,13,14],[11,16,13,16],[11,17,13,17],[11,18,13,18],[14,1,16,1],[14,2,16,3],[14,6,16,6],[14,7,16,7],[14,8,16,8],[14,9,16,9],[14,10,16,10],[14,11,16,14],[14,16,16,16],[14,17,16,17],[14,18,16,18],[17,1,19,1],[17,2,19,3],[17,6,19,6],[17,7,19,7],[17,8,19,8],[17,9,19,9],[17,10,19,10],[17,11,19,14],[17,16,19,16],[17,17,19,17],[17,18,19,18],[20,1,22,1],[20,2,22,3],[20,6,22,6],[20,7,22,7],[20,8,22,8],[20,9,22,9],[20,10,22,10],[20,11,22,14],[20,16,22,16],[20,17,22,17],[20,18,22,18],[23,1,25,1],[23,2,25,3],[23,6,25,6],[23,7,25,7],[23,8,25,8],[23,9,25,9],[23,10,25,10],[23,11,25,14],[23,16,25,16],[23,17,25,17],[23,18,25,18],[26,1,28,1],[26,2,28,3],[26,6,28,6],[26,7,28,7],[26,8,28,8],[26,9,28,9],[26,10,28,10],[26,11,28,14],[26,16,28,16],[26,17,28,17],[26,18,28,18],[29,1,31,1],[29,2,31,3],[29,6,31,6],[29,7,31,7],[29,8,31,8],[29,9,31,9],[29,10,31,10],[29,11,31,14],[29,16,31,16],[29,17,31,17],[29,18,31,18],[32,1,34,1],[32,2,34,3],[32,6,34,6],[32,7,34,7],[32,8,34,8],[32,9,34,9],[32,10,34,10],[32,11,34,14],[32,16,34,16],[32,17,34,17],[32,18,34,18],[35,1,37,1],[35,2,37,3],[35,6,37,6],[35,7,37,7],[35,8,37,8],[35,9,37,9],[35,10,37,10],[35,11,37,14],[35,16,37,16],[35,17,37,17],[35,18,37,18],[38,1,40,1],[38,2,40,3],[38,6,40,6],[38,7,40,7],[38,8,40,8],[38,9,40,9],[38,10,40,10],[38,11,40,14],[38,16,40,16],[38,17,40,17],[38,18,40,18],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,14],[46,1,46,6],[46,7,46,10],[46,11,46,14]]}
[null,"ONLY need to fill out the yellow boxes because the white boxes are auto filled from previous sheets."]
[null,"CONTRACT WORK SUMMARY FORM",{"$nulls":15},"Small Purchase"]
[{"$nulls":16},"x","Competitive"]
[{"$nulls":10},"PAGE",null,"OF",{"$nulls":4},"Non-Competitive"]
[null," APPLICANT",{"$nulls":5}," PA ID NO.",null," PROJECT NO.",null,null," DISASTER",{"$nulls":3}," ","Sealed Bid"]
[{"$nulls":17},"Verbal Quote(s)"]
[null," LOCATION/SITE",{"$nulls":7}," CATEGORY",null," PERIOD COVERING"]
[{"$nulls":12},"TO"]
[null," DESCRIPTION OF WORK PERFORMED"]
[{"$nulls":16},"Do Not Delete (Formula)",null,"(Validations)"]
[null,"Dates Worked","Contractor",null,"Contract Used For",null,"Procurement Method\n(Ex - Sealed Bids,Competive, Non-Competive Proposals etc.)","Type of Contract\n(Ex - Lump Sum, Unit Price, Purchase Order, etc.)","Billing or Invoice Number","Cost","DHS&EM USE Only\n(Final costs after audit)","Comments-Scope",{"$nulls":4},"Project","Admin"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E12,\"x\",J12)","v":0},{"$f":"SUMIF(E14,\"x\",J12)","v":0},"X"]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E15,\"x\",J15)","v":0},{"$f":"SUMIF(E17,\"x\",J15)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E18,\"x\",J18)","v":0},{"$f":"SUMIF(E20,\"x\",J18)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E21,\"x\",J21)","v":0},{"$f":"SUMIF(E23,\"x\",J21)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E24,\"x\",J24)","v":0},{"$f":"SUMIF(E26,\"x\",J24)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E27,\"x\",J27)","v":0},{"$f":"SUMIF(E29,\"x\",J27)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E30,\"x\",J30)","v":0},{"$f":"SUMIF(E32,\"x\",J30)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E33,\"x\",J33)","v":0},{"$f":"SUMIF(E35,\"x\",J33)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E36,\"x\",J36)","v":0},{"$f":"SUMIF(E38,\"x\",J36)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[{"$nulls":5},"Project",{"$nulls":3},0,{"$nulls":6},{"$f":"SUMIF(E39,\"x\",J39)","v":0},{"$f":"SUMIF(E41,\"x\",J39)","v":0}]
[]
[{"$nulls":5},"Administrative"]
[null,"CONTRACT FOR ADMINISTRATIVE USE ",{"$nulls":7},{"$f":"R42","v":0},{"$nulls":6},{"$f":"SUM(Q12:Q41)","v":0},{"$f":"SUM(R12:R41)","v":0}]
[null,"CONTRACT FOR PROJECT USE ",{"$nulls":7},{"$f":"Q42","v":0}]
[null,"CONTRACT TOTAL",{"$nulls":7},{"$f":"J43+J42","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"]