{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PAVEMENT CALCS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"PAVEMENT CALCS","index":0,"n_rows":331,"n_cols":33,"rows_kept":331,"cut":false,"hidden":false,"merged":[[176,15,187,15],[176,14,187,14],[176,13,187,13],[176,12,187,12],[257,29,268,29],[257,28,268,28],[257,27,268,27],[257,26,268,26],[257,25,268,25],[257,24,268,24],[257,23,268,23],[257,22,268,22],[257,21,268,21],[257,20,268,20],[257,19,268,19],[257,18,268,18],[257,17,268,17],[257,16,268,16],[257,15,268,15],[257,14,268,14],[257,13,268,13],[257,12,268,12],[176,25,187,25],[269,3,269,5],[329,3,329,11],[330,3,330,11],[256,3,268,5],[256,6,268,6],[256,7,268,7],[256,8,268,8],[256,9,268,9],[256,10,268,10],[89,3,89,29],[94,3,106,5],[175,11,187,11],[175,3,187,5],[175,6,187,6],[175,7,187,7],[256,11,268,11],[175,8,187,8],[176,29,187,29],[176,28,187,28],[176,27,187,27],[176,26,187,26],[176,24,187,24],[176,23,187,23],[176,22,187,22],[176,21,187,21],[176,20,187,20],[176,19,187,19],[176,18,187,18],[176,17,187,17],[95,29,106,29],[95,28,106,28],[95,27,106,27],[95,26,106,26],[249,3,249,11],[175,9,187,9],[94,7,106,7],[94,8,106,8],[94,9,106,9],[94,10,106,10],[94,11,106,11],[95,20,106,20],[95,19,106,19],[95,18,106,18],[95,17,106,17],[95,16,106,16],[95,15,106,15],[95,14,106,14],[95,13,106,13],[95,12,106,12],[170,3,170,29],[175,10,187,10],[95,25,106,25],[95,24,106,24],[95,23,106,23],[95,22,106,22],[95,21,106,21],[176,16,187,16],[8,3,8,29],[13,9,25,9],[13,7,25,7],[13,11,25,11],[13,3,25,5],[13,6,25,6],[13,10,25,10],[14,16,25,16],[14,17,25,17],[14,18,25,18],[14,19,25,19],[14,12,25,12],[14,13,25,13],[14,14,25,14],[14,15,25,15],[14,21,25,21],[94,6,106,6],[94,1,107,1],[175,1,188,1],[256,1,269,1],[14,22,25,22],[14,23,25,23],[14,24,25,24],[14,29,25,29],[14,25,25,25],[14,26,25,26],[14,27,25,27],[14,28,25,28],[13,1,26,1],[13,8,25,8],[26,3,26,5],[168,3,168,11],[107,3,107,5],[87,3,87,11],[14,20,25,20],[167,3,167,11],[86,3,86,11],[251,3,251,29],[188,3,188,5],[248,3,248,11]]}
[1,"04 Admin Configuration\\CADD Standards Dev\\Worksets\\000000_JD_Misc\\Projects\\GenSum\\GENSUM.xlsm",null,null,null,"SPREADSHEET","1)","SAVE THIS FILE TO THE PROPER FOLDER FOR YOUR PROJECT AS THE SAME NAME AS YOUR DGN (I.E. #####GS001.XLSX)"]
[null,{"$f":"GetLocalDir(B1)","v":"c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\GenSum.xlsm"},null,null,null,"INSTRUCTIONS:","2)","DO NOT ENTER ANY DATA INTO THE ITEM NUMBER, ITEM DESCRIPTION & ITEM UNITS"]
[null,{"$f":"formatLocalPathForNamedRange(B2,\"QryItem\")","v":"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"},null,null,null,null,"3)","ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'",null,null,null,null,"4)","ENTER ALL DATA REQUIRED"]
[null,null,null,null,null,null,"5)","DO NOT REMOVE THE PROTECTION FROM THIS SPREADSHEET, LEAVE THE PROTECTION ON SO THAT YOU DO NOT DELETE NEEDED FORMULAS OR RESIZE SHEET"]
[null,null,null,null,null,null,"6)","DO NOT EDIT Cells A1, B2, B3, or B4. Cell B1 should list the file the item master data being pulled from."]
[null,null,null,null,null,null,"NOTE:  PLEASE BE CAREFULL WITH THE UNITS USED ……. WATCH OUT FOR \"SQ FT\" TO \"SQ YD\" CONNVERSIONS"]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT CALC SHEET \" & B10","v":"PAVEMENT CALC SHEET "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"<--- ENTER STARTING SHEET NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,"ITEM_CODE"]
[null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,null,null,"TYPICAL SECTION LEGEND NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,"RATE / THICKNESS / ETC"]
[null,"Split #",null,"STATION RANGE",null,null,"TYPICAL SECTION","SIDE","DISTANCE\n(D)","AVERAGE  WIDTH\n(W)","SURFACE  AREA\n(A)\nA=DxW/9","CADD GENERATED AREA",{"$f":"IF(OR(TRIM(M10)=0,TRIM(M10)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(M10)=0,TRIM(M10)=\"\"),IF(M11=\"\",\"\",M11),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),3)),\"123456789012\"))-9))&M11,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),3))&M11,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"FT","FT","SQ YD","SQ YD",{"$f":"IF(OR(TRIM(M10)=0,TRIM(M10)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M10),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(D28<>\"\",F28-D28,\"\")","v":""},null,{"$f":"IF(D28<>\"\",I28*J28/9,\"\")","v":""}]
[null,null,null,null,"TO",null,null,null,{"$f":"IF(D29<>\"\",F29-D29,\"\")","v":""},null,{"$f":"IF(D29<>\"\",I29*J29/9,\"\")","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,{"$f":"IF(D37<>\"\",F37-D37,\"\")","v":""},null,{"$f":"IF(D37<>\"\",I37*J37/9,\"\")","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,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,"SUBTOTALS  ",null,null,null,null,null,null,null,null,{"$f":"IF(M10=\"\",\"\",IF(OR(M27=\"\", M27=\"LS\", M27=\"LUMP\"),IF(SUM(COUNTIF(M28:M86,\"LS\")+COUNTIF(M28:M86,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M28:M86)<>0,SUM(M28:M86),\"\")))","v":""},{"$f":"IF(N10=\"\",\"\",IF(OR(N27=\"\", N27=\"LS\", N27=\"LUMP\"),IF(SUM(COUNTIF(N28:N86,\"LS\")+COUNTIF(N28:N86,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(N28:N86)<>0,SUM(N28:N86),\"\")))","v":""},"","","","","","","","","","","","","","","",""]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,null,null,{"$f":"IF(M10=\"\",\"\",IF( M87=\"LS\",\"LS\",IF(M87<>\"\",ROUNDUP(M87,0),\"\")))","v":""},{"$f":"IF(N10=\"\",\"\",IF( N87=\"LS\",\"LS\",IF(N87<>\"\",ROUNDUP(N87,0),\"\")))","v":""},"","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT CALC SHEET \" & B91","v":"PAVEMENT CALC SHEET "}]
[null,null,null,null,null,null,null,null,null,null,null,"ITEM_CODE"]
[null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,null,null,"TYPICAL SECTION LEGEND NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,"RATE / THICKNESS / ETC"]
[null,"Split #",null,"STATION RANGE",null,null,"TYPICAL SECTION","SIDE","DISTANCE\n(D)","AVERAGE  WIDTH\n(W)","SURFACE  AREA\n(A)\nA=DxW/9","CADD GENERATED AREA",{"$f":"IF(OR(TRIM(M91)=0,TRIM(M91)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(M91)=0,TRIM(M91)=\"\"),IF(M92=\"\",\"\",M92),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),3)),\"123456789012\"))-9))&M92,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),3))&M92,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"FT","FT","SQ YD","SQ YD",{"$f":"IF(OR(TRIM(M91)=0,TRIM(M91)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M91),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(D109<>\"\",F109-D109,\"\")","v":""},null,{"$f":"IF(D109<>\"\",I109*J109/9,\"\")","v":""}]
[null,null,null,null,"TO",null,null,null,{"$f":"IF(D110<>\"\",F110-D110,\"\")","v":""},null,{"$f":"IF(D110<>\"\",I110*J110/9,\"\")","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,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,"SUBTOTALS  ",null,null,null,null,null,null,null,null,{"$f":"IF(M91=\"\",\"\",IF(OR(M108=\"\", M108=\"LS\", M108=\"LUMP\"),IF(SUM(COUNTIF(M109:M167,\"LS\")+COUNTIF(M109:M167,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M109:M167)<>0,SUM(M109:M167),\"\")))","v":""},{"$f":"IF(N91=\"\",\"\",IF(OR(N108=\"\", N108=\"LS\", N108=\"LUMP\"),IF(SUM(COUNTIF(N109:N167,\"LS\")+COUNTIF(N109:N167,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(N109:N167)<>0,SUM(N109:N167),\"\")))","v":""},"","","","","","","","","","","","","","","",""]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,null,null,{"$f":"IF(M91=\"\",\"\",IF( M168=\"LS\",\"LS\",IF(M168<>\"\",ROUNDUP(M168,0),\"\")))","v":""},{"$f":"IF(N91=\"\",\"\",IF( N168=\"LS\",\"LS\",IF(N168<>\"\",ROUNDUP(N168,0),\"\")))","v":""},"","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT CALC SHEET \" & B172","v":"PAVEMENT CALC SHEET "}]
[null,null,null,null,null,null,null,null,null,null,null,"ITEM_CODE"]
[null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,null,null,"TYPICAL SECTION LEGEND NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,"RATE / THICKNESS / ETC"]
[null,"Split #",null,"STATION RANGE",null,null,"TYPICAL SECTION","SIDE","DISTANCE\n(D)","AVERAGE  WIDTH\n(W)","SURFACE  AREA\n(A)\nA=DxW/9","CADD GENERATED AREA",{"$f":"IF(OR(TRIM(M172)=0,TRIM(M172)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(M172)=0,TRIM(M172)=\"\"),IF(M173=\"\",\"\",M173),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),3)),\"123456789012\"))-9))&M173,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),3))&M173,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"FT","FT","SQ YD","SQ YD",{"$f":"IF(OR(TRIM(M172)=0,TRIM(M172)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M172),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(D190<>\"\",F190-D190,\"\")","v":""},null,{"$f":"IF(D190<>\"\",I190*J190/9,\"\")","v":""}]
[null,null,null,null,"TO",null,null,null,{"$f":"IF(D191<>\"\",F191-D191,\"\")","v":""},null,{"$f":"IF(D191<>\"\",I191*J191/9,\"\")","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,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,"SUBTOTALS  ",null,null,null,null,null,null,null,null,{"$f":"IF(M172=\"\",\"\",IF(OR(M189=\"\", M189=\"LS\", M189=\"LUMP\"),IF(SUM(COUNTIF(M190:M248,\"LS\")+COUNTIF(M190:M248,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M190:M248)<>0,SUM(M190:M248),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,null,null,{"$f":"IF(M172=\"\",\"\",IF( M249=\"LS\",\"LS\",IF(M249<>\"\",ROUNDUP(M249,0),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[]
[null,"Page #",null,{"$f":"\"PAVEMENT CALC SHEET \" & B253","v":"PAVEMENT CALC SHEET "}]
[null,null,null,null,null,null,null,null,null,null,null,"ITEM_CODE"]
[null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL_DESCRIPTION"]
[null,null,null,null,null,null,null,null,null,null,null,"TYPICAL SECTION LEGEND NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,"RATE / THICKNESS / ETC"]
[null,"Split #",null,"STATION RANGE",null,null,"TYPICAL SECTION","SIDE","DISTANCE\n(D)","AVERAGE  WIDTH\n(W)","SURFACE  AREA\n(A)\nA=DxW/9","CADD GENERATED AREA",{"$f":"IF(OR(TRIM(M253)=0,TRIM(M253)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),11)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(M253)=0,TRIM(M253)=\"\"),IF(M254=\"\",\"\",M254),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),3)),\"123456789012\"))-9))&M254,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),3))&M254,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"FT","FT","SQ YD","SQ YD",{"$f":"IF(OR(TRIM(M253)=0,TRIM(M253)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(M253),ITEM,0),2)),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(D271<>\"\",F271-D271,\"\")","v":""},null,{"$f":"IF(D271<>\"\",I271*J271/9,\"\")","v":""}]
[null,null,null,null,"TO",null,null,null,{"$f":"IF(D272<>\"\",F272-D272,\"\")","v":""},null,{"$f":"IF(D272<>\"\",I272*J272/9,\"\")","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,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,"SUBTOTALS  ",null,null,null,null,null,null,null,null,{"$f":"IF(M253=\"\",\"\",IF(OR(M270=\"\", M270=\"LS\", M270=\"LUMP\"),IF(SUM(COUNTIF(M271:M329,\"LS\")+COUNTIF(M271:M329,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(M271:M329)<>0,SUM(M271:M329),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,"Total",null,"TOTALS CARRIED TO GENERAL SUMMARY  ",null,null,null,null,null,null,null,null,{"$f":"IF(M253=\"\",\"\",IF( M330=\"LS\",\"LS\",IF(M330<>\"\",ROUNDUP(M330,0),\"\")))","v":""},"","","","","","","","","","","","","","","","",""]