{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"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":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[7,0,7,12],[6,0,6,12],[0,0,3,1],[1,9,1,10],[2,9,2,10],[1,11,1,12],[2,11,2,12],[1,2,1,7],[2,2,2,7],[4,2,4,8],[4,0,4,1],[3,2,3,6]]}
[]
[null,null,"COMMONWEALTH OF PENNSYLVANIA",null,null,null,null,null,null,"DISTRICT"]
[null,null,"DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,"PLANT CODE"]
[]
["Aggregate 2023",null,"Enter only aggregate being shipped to PENN DOT Projects"]
[]
["PLANT SUMMARY"]
["Total Combined Daily Shipments"]
[]
[null,"Date","Today","To Date",null,"Date","Today","To Date ",null,"Date","Today","To Date"]
[null,null,null,{"$f":"IF(ISBLANK(C11),\" \",C11)","v":" "},null,null,null,{"$f":"IF(ISBLANK(G11),\" \",D46+G11)","v":" "},null,null,null,{"$f":"IF(ISBLANK(K11),\" \",H46+K11)","v":" "}]
[null,null,null,{"$f":"IF(ISBLANK(C12),\" \",D11+C12)","v":" "},null,null,null,{"$f":"IF(ISBLANK(G12),\" \",H11+G12)","v":" "},null,null,null,{"$f":"IF(ISBLANK(K12),\" \",L11+K12)","v":" "}]
[null,null,null,{"$f":"IF(ISBLANK(C13),\" \",D12+C13)","v":" "},null,null,null,{"$f":"IF(ISBLANK(G13),\" \",H12+G13)","v":" "},null,null,null,{"$f":"IF(ISBLANK(K13),\" \",L12+K13)","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," "]

{"sheet":"Sheet2","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,0,6,12],[7,0,7,12],[0,0,3,1],[1,9,1,10],[1,11,1,12],[2,9,2,10],[2,11,2,12],[3,2,3,6],[4,0,4,1],[1,2,1,7],[2,2,2,7],[4,2,4,8]]}
[]
[null,null,"COMMONWEALTH OF PENNSYLVANIA",null,null,null,null,null,null,"DISTRICT",null,{"$f":"IF(ISBLANK(Sheet1!L2),\" \",Sheet1!L2)","v":" "}]
[null,null,"DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,"PLANT CODE",null,{"$f":"IF(ISBLANK(Sheet1!L3),\" \",Sheet1!L3)","v":" "}]
[]
[{"$f":"Sheet1!A5","v":"Aggregate 2023"},null,"Enter only aggregate being shipped to PENN DOT Projects"]
[]
["PLANT SUMMARY"]
["Total Combined Daily Shipments"]
[]
[null,"Date","Today","To Date",null,"Date","Today","To Date ",null,"Date","Today","To Date"]
[null,null,null,{"$f":"IF(ISBLANK(C11),\" \",Sheet1!L46+C11)","v":" "},null,null,null,{"$f":"IF(ISBLANK(G11),\" \",D46+G11)","v":" "},null,null,null,{"$f":"IF(ISBLANK(K11),\" \",H46+K11)","v":" "}]
[null,null,null,{"$f":"IF(ISBLANK(C12),\" \",D11+C12)","v":" "},null,null,null,{"$f":"IF(ISBLANK(G12),\" \",H11+G12)","v":" "},null,null,null,{"$f":"IF(ISBLANK(K12),\" \",L11+K12)","v":" "}]
[null,null,null,{"$f":"IF(ISBLANK(C13),\" \",D12+C13)","v":" "},null,null,null,{"$f":"IF(ISBLANK(G13),\" \",H12+G13)","v":" "},null,null,null,{"$f":"IF(ISBLANK(K13),\" \",L12+K13)","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," "]