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

{"sheet":"Material","index":0,"n_rows":49,"n_cols":26,"rows_kept":49,"merged":[[0,1,0,12],[1,1,3,7],[4,1,4,2],[4,3,4,5],[4,6,4,8],[4,9,4,12],[5,1,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,12],[6,6,6,8],[6,9,6,12],[7,1,7,5],[7,6,7,8],[7,11,7,12],[8,1,8,12],[9,1,9,12],[10,1,11,1],[10,2,11,2],[10,3,11,4],[10,5,11,5],[10,6,11,6],[10,7,10,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,12,11,12],[10,15,10,16],[12,1,15,1],[12,2,15,2],[12,5,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,15,15,15],[12,16,15,16],[12,17,15,17],[16,1,19,1],[16,2,19,2],[16,5,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,15,19,15],[16,16,19,16],[16,17,19,17],[20,1,23,1],[20,2,23,2],[20,5,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,15,23,15],[20,16,23,16],[20,17,23,17],[24,1,27,1],[24,2,27,2],[24,5,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,15,27,15],[24,16,27,16],[24,17,27,17],[28,1,31,1],[28,2,31,2],[28,5,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,15,31,15],[28,16,31,16],[28,17,31,17],[32,1,35,1],[32,2,35,2],[32,5,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,15,35,15],[32,16,35,16],[32,17,35,17],[36,1,39,1],[36,2,39,2],[36,5,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,15,39,15],[36,16,39,16],[36,17,39,17],[40,1,43,1],[40,2,43,2],[40,5,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,15,43,15],[40,16,43,16],[40,17,43,17],[44,1,44,10],[45,1,45,10],[46,1,46,10],[47,1,47,12],[49,1,49,6],[49,7,49,10],[49,11,49,12]]}
[null,"ONLY need to fill out the yellow boxes because the white boxes are auto filled from previous sheets."]
[null,"MATERIAL SUMMARY FORM"]
[]
[{"$nulls":8},"PAGE ",1,"OF"]
[null," APPLICANT",null," PA ID NO.",null,null," PROJECT NO.",null,null," DISASTER"]
[]
[null," LOCATION/SITE",{"$nulls":4}," CATEGORY",null,null," PERIOD COVERING"]
[{"$nulls":10},"TO"]
[null," DESCRIPTION OF WORK PERFORMED"]
[]
[null,"Vendor","Description","Materials Used For ",null,"Date Purchased","Date Used","Info From\n(Check One)",null,"Qty","Unit Price","Cost ","DHS&EM\nuse only\n(Final costs after audit)",null,null,"Do Not Delete (Formula)",null,"(Validations)",{"$nulls":6},"",""]
[{"$nulls":7},"Invoice","Stock",{"$nulls":6},"Project","Admin"]
[{"$nulls":11},{"$f":"J13*K13","v":0},{"$nulls":3},{"$f":"SUMIF(D14,\"x\",L13)","v":0},{"$f":"SUMIF(D16,\"x\",L13)","v":0},"x"]
[{"$nulls":4},"Project",{"$nulls":12},"X"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J17*K17","v":0},{"$nulls":3},{"$f":"SUMIF(D18,\"x\",L17)","v":0},{"$f":"SUMIF(D20,\"x\",L17)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J21*K21","v":0},{"$nulls":3},{"$f":"SUMIF(D22,\"x\",L21)","v":0},{"$f":"SUMIF(D24,\"x\",L21)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J25*K25","v":0},{"$nulls":3},{"$f":"SUMIF(D26,\"x\",L25)","v":0},{"$f":"SUMIF(D28,\"x\",L25)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J29*K29","v":0},{"$nulls":3},{"$f":"SUMIF(D30,\"x\",L29)","v":0},{"$f":"SUMIF(D32,\"x\",L29)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J33*K33","v":0},{"$nulls":3},{"$f":"SUMIF(D34,\"x\",L33)","v":0},{"$f":"SUMIF(D36,\"x\",L33)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J37*K37","v":0},{"$nulls":3},{"$f":"SUMIF(D38,\"x\",L37)","v":0},{"$f":"SUMIF(D40,\"x\",L37)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[{"$nulls":11},{"$f":"J41*K41","v":0},{"$nulls":3},{"$f":"SUMIF(D42,\"x\",L41)","v":0},{"$f":"SUMIF(D44,\"x\",L41)","v":0}]
[{"$nulls":4},"Project"]
[]
[{"$nulls":4},"Administrative"]
[null,"MATERIAL FOR ADMINISTRATIVE USE",{"$nulls":9},{"$f":"Q45","v":0},{"$nulls":3},{"$f":"SUM(P13:P44)","v":0},{"$f":"SUM(Q13:Q44)","v":0}]
[null,"MATERIAL FOR PROJECT USE",{"$nulls":9},{"$f":"P45","v":0}]
[null,"MATERIAL TOTAL",{"$nulls":9},{"$f":"L45+L46","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"]