{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Single_Bridge"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Single_Bridge","index":0,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[22,2,23,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[17,14,17,15],[21,17,23,18],[16,1,16,5],[16,6,16,15],[20,14,20,15],[19,14,19,15],[18,14,18,15],[22,7,23,7],[22,8,23,8],[21,13,23,13],[21,15,23,15],[21,14,23,14],[22,9,23,9],[20,1,21,10],[22,10,23,10],[22,1,23,1]]}
[3,"04 Admin Configuration\\CADD Standards Dev\\Worksets\\000000_JD_Misc\\Projects\\GenSum\\GENSUM.xlsm"]
["S",{"$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,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,null,"INSTRUCTIONS:","2)","DO NOT ENTER ANY DATA INTO THE ITEM NUMBER, ITEM DESCRIPTION & ITEM UNITS"]
[null,null,null,null,"3)","ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,null,null,null,"4)","ENTER ALL DATA REQUIRED"]
[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,"6)","DO NOT EDIT Cells A1, B2, B3, or B4. Cell B1 should list the file the item master data being pulled from."]
[]
[null,"DO NOT ENTER DATA IN THESE COLUMNS",null,null,null,null,"ENTER DATA IN THESE COLUMNS ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page #"]
[null,null,null,null,null,null,null,"CALC:",null,"DATE:",null,null,null,"Bridge_Name"]
[null,null,null,null,null,null,null,"CHECKED:",null,"DATE:",null,null,null,"SFN"]
[null,{"$f":"CONCATENATE(\"E S T I M A T E D     Q U A N T I T I E S\",\" (\",O21,\")\")","v":"E S T I M A T E D     Q U A N T I T I E S (Enter in Split Name)"},null,null,null,null,null,null,null,null,null,null,null,"Split_Name","Enter in Split Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM_CODE","QTY NOT FROM SHEET","ADDITIONAL_DESCRIPTION",null,"SUPPLEMENTAL INFO"]
[null,"ITEM","EXTENSION","TOTAL","UNIT","DESCRIPTION","ABUT.","PIERS","SUPER.","GEN.","SEE               SHEET"]
[]
[null,{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),13)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),3)),\"\")=\"LS\",\"LS\",IF((SUM(G25:J25)+O25)=0,\"\",SUM(G25:J25)+O25)))","v":""},{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),IF(P25=\"\",\"\",P25),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),3)),\"123456789012\"))-9))&P25,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),3))&P25,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(N25)=0,TRIM(N25)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N25),ITEM,0),7)),\"\"))","v":""}]
[null,"","",{"$f":"IF(OR(TRIM(N26)=0,TRIM(N26)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N26),ITEM,0),3)),\"\")=\"LS\",\"LS\",IF((SUM(G26:J26)+O26)=0,\"\",SUM(G26:J26)+O26)))","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,{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),13)),\"\")))","v":""},"",{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),IF(P57=\"\",\"\",P57),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),3)),\"123456789012\"))-9))&P57,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),3))&P57,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(N57)=0,TRIM(N57)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(N57),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,"","","","","",null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,"","","","","",null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,"","","","","",null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,"","","","","",null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,"","","","","",null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]