{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Retaining_Wall"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":"Retaining_Wall","index":0,"n_rows":73,"n_cols":19,"rows_kept":73,"cut":false,"hidden":false,"merged":[[16,1,16,6],[20,9,21,12],[22,1,23,1],[22,14,23,15],[22,3,23,3],[22,2,23,2],[22,8,23,8],[22,9,23,9],[22,10,23,10],[22,11,23,11],[16,7,16,11],[22,12,23,12],[22,7,23,7],[22,5,22,6]]}
[5,"04 Admin Configuration\\CADD Standards Dev\\Worksets\\000000_JD_Misc\\Projects\\GenSum\\GENSUM.xlsm"]
[null,{"$f":"GetLocalDir(B1)","v":"c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\GenSum.xlsm"}]
[null,{"$f":"formatLocalPathForNamedRange(B2,\"QryItem\")","v":"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"}]
[null,"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"]
[]
[]
[]
[]
[]
[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,null,"INSTRUCTIONS:","2)","DO NOT ENTER ANY DATA INTO THE ITEM NUMBER, ITEM DESCRIPTION & ITEM UNITS"]
[null,null,null,"3)","ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,null,null,"4)","ENTER ALL DATA REQUIRED"]
[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,"6)","DO NOT EDIT Cells A1, B2, B3, or B4. Cell B1 should list the file the item master data being pulled from."]
[]
[null,"ENTER DATA IN THESE COLUMNS",null,null,null,null,null,"DO NOT ENTER DATA IN THESE COLUMNS"]
[]
[]
[]
[null,"Page #",null,null,null,"CALC:",null,"DATE:",null,{"$f":"CONCATENATE(\"ESTIMATED QUANTITIES\",\" RETAINING WALL (\",C22,\")\")","v":"ESTIMATED QUANTITIES RETAINING WALL ()"}]
[null,"Wall_Name",null,null,null,"CHECKED:",null,"DATE:"]
[null,"ITEM_CODE","ADDITIONAL_DESCRIPTION","See Sheet",null,"Participation",null,"ITEM","EXTENSION","TOTAL","UNIT","DESCRIPTION","SEE               SHEET",null,"SUPPLEMENTAL INFO"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),13)),\"\")))","v":""},{"$f":"IF(B25=\"\",\"\",IF(OR(K25=\"\", K25=\"LS\", K25=\"LUMP\"),IF(SUM(COUNTIF(F25:G25,\"LS\")+COUNTIF(F25:G25,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(F25:G25)>0,ROUNDUP(SUM(F25:G25),0),\"\")))","v":""},{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),IF(C25=\"\",\"\",C25),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),3)),\"123456789012\"))-9))&C25,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),3))&C25,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},{"$f":"IF(D25=\"\",\"\",D25)","v":""},null,{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(B25)=0,TRIM(B25)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B25),ITEM,0),7)),\"\"))","v":""}]
[null,null,null,null,null,null,null,"","",{"$f":"IF(B26=\"\",\"\",IF(OR(K26=\"\", K26=\"LS\", K26=\"LUMP\"),IF(SUM(COUNTIF(F26:G26,\"LS\")+COUNTIF(F26:G26,\"LUMP\"))>0,\"LS\",\"\"),IF(SUM(F26:G26)>0,ROUNDUP(SUM(F26:G26),0),\"\")))","v":""},"","",{"$f":"IF(D26=\"\",\"\",D26)","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,{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),13)),\"\")))","v":""},"",{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),IF(C57=\"\",\"\",C57),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),3)),\"123456789012\"))-9))&C57,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),3))&C57,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},"",null,{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(B57)=0,TRIM(B57)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B57),ITEM,0),7)),\"\"))","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,"","",""]