{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,10,2,11],[2,12,2,13],[7,0,7,1],[0,0,3,1],[3,4,3,8],[5,12,5,13],[7,5,7,6],[7,2,7,4],[10,5,10,6],[9,3,9,6],[4,10,4,11],[3,12,3,13],[4,12,4,13],[3,10,3,11],[9,10,9,13],[10,10,10,11],[10,12,10,13],[5,10,5,11],[6,10,6,11],[6,12,6,13],[1,10,1,11],[1,12,1,13],[5,0,5,1],[1,3,1,8],[5,2,5,8],[2,3,2,8],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[11,3,11,4],[10,3,10,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[38,3,38,4],[39,3,39,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[46,3,46,4],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[40,3,40,4],[41,3,41,4],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[44,3,44,4],[45,3,45,4],[42,3,42,4],[43,3,43,4],[36,3,36,4],[37,3,37,4],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[44,5,44,6],[45,5,45,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[11,10,11,11],[11,12,11,13],[12,10,12,11],[12,12,12,13],[24,10,24,11],[24,12,24,13],[21,10,21,11],[21,12,21,13],[22,10,22,11],[22,12,22,13],[27,10,27,11],[27,12,27,13],[28,10,28,11],[28,12,28,13],[25,10,25,11],[25,12,25,13],[26,10,26,11],[26,12,26,13],[46,5,46,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[42,5,42,6],[43,5,43,6],[15,10,15,11],[15,12,15,13],[16,10,16,11],[16,12,16,13],[13,10,13,11],[13,12,13,13],[14,10,14,11],[14,12,14,13],[19,10,19,11],[19,12,19,13],[20,10,20,11],[20,12,20,13],[17,10,17,11],[17,12,17,13],[18,10,18,11],[18,12,18,13],[23,10,23,11],[23,12,23,13],[31,10,31,11],[31,12,31,13],[32,10,32,11],[32,12,32,13],[29,10,29,11],[29,12,29,13],[30,10,30,11],[30,12,30,13],[35,10,35,11],[35,12,35,13],[36,10,36,11],[36,12,36,13],[33,10,33,11],[33,12,33,13],[34,10,34,11],[34,12,34,13],[39,12,39,13],[40,10,40,11],[40,12,40,13],[37,10,37,11],[37,12,37,13],[38,10,38,11],[38,12,38,13],[39,10,39,11],[46,10,46,11],[46,12,46,13],[44,10,44,11],[44,12,44,13],[45,10,45,11],[45,12,45,13],[43,10,43,11],[43,12,43,13],[41,10,41,11],[41,12,41,13],[42,10,42,11],[42,12,42,13]]}
[]
[null,null,null,"COMMONWEALTH OF PENNSYLVANIA",null,null,null,null,null,null,"DISTRICT"]
[null,null,null,"DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,"PLANT CODE"]
[null,null,null,null,null,null,null,null,null,null,"SR"]
[null,null,null,null,null,null,null,null,null,null,"Section"]
["Concrete 2023",null,"PENN DOT Project Summary",null,null,null,null,null,null,null,"Contract No."]
[null,null,null,null,null,null,null,null,null,null,"Quantity"]
["Prime Contractor"]
[]
["Date","Material Class","Design","Yards Shipped",null,null,null,"Date","Material Class","Design","Yards Shipped"]
[null,null,null,"Today",null,"To Date",null,null,null,null,"Today",null,"To Date"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D12),\" \",D12)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K12),\" \",F47+K12)","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D13),\" \",F12+D13)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K13),\" \",M12+K13)","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D14),\" \",F13+D14)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K14),\" \",M13+K14)","v":" "}]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]

{"sheet":"Sheet2","index":1,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,3,46,4],[46,5,46,6],[46,10,46,11],[46,12,46,13],[45,3,45,4],[45,5,45,6],[45,10,45,11],[45,12,45,13],[43,3,43,4],[43,5,43,6],[43,10,43,11],[43,12,43,13],[44,3,44,4],[44,5,44,6],[44,10,44,11],[44,12,44,13],[41,10,41,11],[41,12,41,13],[42,3,42,4],[42,5,42,6],[42,10,42,11],[42,12,42,13],[39,3,39,4],[39,5,39,6],[39,10,39,11],[39,12,39,13],[40,3,40,4],[40,5,40,6],[40,10,40,11],[40,12,40,13],[41,3,41,4],[41,5,41,6],[37,3,37,4],[37,5,37,6],[37,10,37,11],[37,12,37,13],[38,3,38,4],[38,5,38,6],[38,10,38,11],[38,12,38,13],[35,3,35,4],[35,5,35,6],[35,10,35,11],[35,12,35,13],[36,3,36,4],[36,5,36,6],[36,10,36,11],[36,12,36,13],[33,3,33,4],[33,5,33,6],[33,10,33,11],[33,12,33,13],[34,3,34,4],[34,5,34,6],[34,10,34,11],[34,12,34,13],[31,3,31,4],[31,5,31,6],[31,10,31,11],[31,12,31,13],[32,3,32,4],[32,5,32,6],[32,10,32,11],[32,12,32,13],[29,3,29,4],[29,5,29,6],[29,10,29,11],[29,12,29,13],[30,3,30,4],[30,5,30,6],[30,10,30,11],[30,12,30,13],[27,3,27,4],[27,5,27,6],[27,10,27,11],[27,12,27,13],[28,3,28,4],[28,5,28,6],[28,10,28,11],[28,12,28,13],[25,3,25,4],[25,5,25,6],[25,10,25,11],[25,12,25,13],[26,3,26,4],[26,5,26,6],[26,10,26,11],[26,12,26,13],[23,3,23,4],[23,5,23,6],[23,10,23,11],[23,12,23,13],[24,3,24,4],[24,5,24,6],[24,10,24,11],[24,12,24,13],[21,3,21,4],[21,5,21,6],[21,10,21,11],[21,12,21,13],[22,3,22,4],[22,5,22,6],[22,10,22,11],[22,12,22,13],[19,3,19,4],[19,5,19,6],[19,10,19,11],[19,12,19,13],[20,3,20,4],[20,5,20,6],[20,10,20,11],[20,12,20,13],[17,3,17,4],[17,5,17,6],[17,10,17,11],[17,12,17,13],[18,3,18,4],[18,5,18,6],[18,10,18,11],[18,12,18,13],[15,3,15,4],[15,5,15,6],[15,10,15,11],[15,12,15,13],[16,3,16,4],[16,5,16,6],[16,10,16,11],[16,12,16,13],[13,3,13,4],[13,5,13,6],[13,10,13,11],[13,12,13,13],[14,3,14,4],[14,5,14,6],[14,10,14,11],[14,12,14,13],[11,3,11,4],[11,5,11,6],[11,10,11,11],[11,12,11,13],[12,3,12,4],[12,5,12,6],[12,10,12,11],[12,12,12,13],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,9,13],[10,10,10,11],[10,12,10,13],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,9,6],[10,3,10,4],[10,5,10,6],[4,10,4,11],[4,12,4,13],[7,0,7,1],[7,5,7,6],[7,2,7,4],[5,10,5,11],[5,12,5,13],[0,0,3,1],[1,10,1,11],[1,12,1,13],[2,10,2,11],[2,12,2,13],[3,4,3,8],[3,10,3,11],[3,12,3,13],[1,3,1,8],[5,0,5,1],[5,2,5,8],[2,3,2,8],[6,10,6,11],[6,12,6,13]]}
[]
[null,null,null,"COMMONWEALTH OF PENNSYLVANIA",null,null,null,null,null,null,"DISTRICT"]
[null,null,null,"DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,"PLANT CODE"]
[null,null,null,null,null,null,null,null,null,null,"SR"]
[null,null,null,null,null,null,null,null,null,null,"Section"]
[{"$f":"Sheet1!A6","v":"Concrete 2023"},null,"PENN DOT Project Summary",null,null,null,null,null,null,null,"Contract No."]
[null,null,null,null,null,null,null,null,null,null,"Quantity"]
["Prime Contractor"]
[]
["Date","Material Class","Design","Tons Shipped",null,null,null,"Date","Material Class","Design","Tons Shipped"]
[null,null,null,"Today",null,"To Date",null,null,null,null,"Today",null,"To Date"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D12),\" \",Sheet1!M47+D12)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K12),\" \",F47+K12)","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D13),\" \",F12+D13)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K13),\" \",M12+K13)","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D14),\" \",F13+D14)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K14),\" \",M13+K14)","v":" "}]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]

{"sheet":"Sheet3","index":2,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,3,46,4],[46,5,46,6],[46,10,46,11],[46,12,46,13],[45,3,45,4],[45,5,45,6],[45,10,45,11],[45,12,45,13],[43,3,43,4],[43,5,43,6],[43,10,43,11],[43,12,43,13],[44,3,44,4],[44,5,44,6],[44,10,44,11],[44,12,44,13],[41,10,41,11],[41,12,41,13],[42,3,42,4],[42,5,42,6],[42,10,42,11],[42,12,42,13],[39,3,39,4],[39,5,39,6],[39,10,39,11],[39,12,39,13],[40,3,40,4],[40,5,40,6],[40,10,40,11],[40,12,40,13],[41,3,41,4],[41,5,41,6],[37,3,37,4],[37,5,37,6],[37,10,37,11],[37,12,37,13],[38,3,38,4],[38,5,38,6],[38,10,38,11],[38,12,38,13],[35,3,35,4],[35,5,35,6],[35,10,35,11],[35,12,35,13],[36,3,36,4],[36,5,36,6],[36,10,36,11],[36,12,36,13],[33,3,33,4],[33,5,33,6],[33,10,33,11],[33,12,33,13],[34,3,34,4],[34,5,34,6],[34,10,34,11],[34,12,34,13],[31,3,31,4],[31,5,31,6],[31,10,31,11],[31,12,31,13],[32,3,32,4],[32,5,32,6],[32,10,32,11],[32,12,32,13],[29,3,29,4],[29,5,29,6],[29,10,29,11],[29,12,29,13],[30,3,30,4],[30,5,30,6],[30,10,30,11],[30,12,30,13],[27,3,27,4],[27,5,27,6],[27,10,27,11],[27,12,27,13],[28,3,28,4],[28,5,28,6],[28,10,28,11],[28,12,28,13],[25,3,25,4],[25,5,25,6],[25,10,25,11],[25,12,25,13],[26,3,26,4],[26,5,26,6],[26,10,26,11],[26,12,26,13],[23,3,23,4],[23,5,23,6],[23,10,23,11],[23,12,23,13],[24,3,24,4],[24,5,24,6],[24,10,24,11],[24,12,24,13],[21,3,21,4],[21,5,21,6],[21,10,21,11],[21,12,21,13],[22,3,22,4],[22,5,22,6],[22,10,22,11],[22,12,22,13],[19,3,19,4],[19,5,19,6],[19,10,19,11],[19,12,19,13],[20,3,20,4],[20,5,20,6],[20,10,20,11],[20,12,20,13],[17,3,17,4],[17,5,17,6],[17,10,17,11],[17,12,17,13],[18,3,18,4],[18,5,18,6],[18,10,18,11],[18,12,18,13],[15,3,15,4],[15,5,15,6],[15,10,15,11],[15,12,15,13],[16,3,16,4],[16,5,16,6],[16,10,16,11],[16,12,16,13],[13,3,13,4],[13,5,13,6],[13,10,13,11],[13,12,13,13],[14,3,14,4],[14,5,14,6],[14,10,14,11],[14,12,14,13],[11,3,11,4],[11,5,11,6],[11,10,11,11],[11,12,11,13],[12,3,12,4],[12,5,12,6],[12,10,12,11],[12,12,12,13],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,9,13],[10,10,10,11],[10,12,10,13],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,9,6],[10,3,10,4],[10,5,10,6],[4,10,4,11],[4,12,4,13],[7,0,7,1],[7,5,7,6],[7,2,7,4],[5,10,5,11],[5,12,5,13],[0,0,3,1],[1,10,1,11],[1,12,1,13],[2,10,2,11],[2,12,2,13],[3,4,3,8],[3,10,3,11],[3,12,3,13],[1,3,1,8],[2,3,2,8],[5,0,5,1],[5,2,5,8],[6,10,6,11],[6,12,6,13]]}
[]
[null,null,null,"COMMONWEALTH OF PENNSYLVANIA",null,null,null,null,null,null,"DISTRICT"]
[null,null,null,"DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,"PLANT CODE"]
[null,null,null,null,null,null,null,null,null,null,"SR"]
[null,null,null,null,null,null,null,null,null,null,"Section"]
[{"$f":"Sheet1!A6","v":"Concrete 2023"},null,"PENN DOT Project Summary",null,null,null,null,null,null,null,"Contract No."]
[null,null,null,null,null,null,null,null,null,null,"Quantity"]
["Prime Contractor"]
[]
["Date","Material Class","Design","Tons Shipped",null,null,null,"Date","Material Class","Design","Tons Shipped"]
[null,null,null,"Today",null,"To Date",null,null,null,null,"Today",null,"To Date"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D12),\" \",Sheet2!M47+D12)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K12),\" \",F47+K12)","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D13),\" \",F12+D13)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K13),\" \",M12+K13)","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D14),\" \",F13+D14)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(K14),\" \",M13+K14)","v":" "}]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null," ",null,null,null,null,null,null," "]