{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Multiple_Bridges"],"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":"Multiple_Bridges","index":0,"n_rows":76,"n_cols":30,"rows_kept":76,"cut":false,"hidden":false,"merged":[[25,1,35,1],[25,2,35,2],[25,22,35,22],[16,14,16,22],[16,1,16,13],[25,16,35,16],[26,11,35,11],[17,3,17,5],[18,3,18,5],[19,3,19,5],[25,3,35,3],[26,10,35,10],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[36,17,36,21],[23,6,24,22],[14,4,14,5],[13,4,13,5],[37,17,37,21],[26,6,35,6],[26,7,35,7],[26,8,35,8],[26,9,35,9],[25,14,35,14],[25,15,35,15],[25,17,35,21],[26,12,35,12],[26,13,35,13],[25,6,25,13],[48,17,48,21],[49,17,49,21],[50,17,50,21],[51,17,51,21],[52,17,52,21],[67,17,67,21],[68,17,68,21],[69,17,69,21],[70,17,70,21],[58,17,58,21],[59,17,59,21],[60,17,60,21],[66,17,66,21],[63,17,63,21],[64,17,64,21],[65,17,65,21],[61,17,61,21],[62,17,62,21],[75,17,75,21],[71,17,71,21],[72,17,72,21],[73,17,73,21],[74,17,74,21],[25,25,35,26],[54,17,54,21],[55,17,55,21],[56,17,56,21],[57,17,57,21],[38,17,38,21],[39,17,39,21],[40,17,40,21],[41,17,41,21],[53,17,53,21],[42,17,42,21],[43,17,43,21],[44,17,44,21],[45,17,45,21],[46,17,46,21],[47,17,47,21]]}
[3,"04 Admin Configuration\\CADD Standards Dev\\Worksets\\000000_JD_Misc\\Projects\\GenSum\\GenSum2.xlsm"]
["M",{"$f":"GetLocalDir(B1)","v":"c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\GenSum2.xlsm"}]
[null,{"$f":"formatLocalPathForNamedRange(B2,\"QryItem\")","v":"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum2.xlsm]QryItem'"}]
[null,"'c:\\ohiodotdir\\jdrsek\\ohiodot-pw-04\\d0653897\\[GenSum.xlsm]QryItem'"]
[]
[]
[]
[]
[]
[null,null,null,"SPREADSHEET","1)",null,"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)",null,"DO NOT ENTER ANY DATA INTO THE ITEM NUMBER, ITEM DESCRIPTION & ITEM UNITS"]
[null,null,null,null,"3)",null,"ENTER ITEM CODE (FOR EXAMPLE: 201E11000) AND ADDITIONAL DESCRIPTION INTO THE BLUE CELLS"]
[null,null,null,null,"4)",null,"ENTER ALL DATA REQUIRED"]
[null,null,null,null,"5)",null,"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)",null,"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 ONLY",null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT ENTER DATA IN THESE COLUMNS"]
[null,null,null,"BridgeName"]
[null,null,null,"SFN"]
[null,null,null,"Split Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALC:",null,"DATE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECKED:",null,"DATE:"]
[null,"Page #",null,null,null,null,"E S T I M A T E D     Q U A N T I T I E S"]
[]
[null,"ITEM_CODE","ADDITIONAL_DESCRIPTION","SEE SHEET",null,null,"BRIDGE NO. / STRUCTURE FILE NO.",null,null,null,null,null,null,null,"ITEM","EXTENSION","UNIT","DESCRIPTION",null,null,null,null,"SEE                    SHEET",null,null,"SUPPLEMENTAL INFO"]
[null,null,null,null,null,null,{"$f":"G18 & \"\n\" & G19 & \"\n\" & G20","v":"\n\n"},{"$f":"H18 & \"\n\" & H19 & \"\n\" & H20","v":"\n\n"},{"$f":"I18 & \"\n\" & I19 & \"\n\" & I20","v":"\n\n"},"\n\n","\n\n","\n\n","\n\n","\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),8)),\"\")=\"True\",\"SPECIAL\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),11)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),8)),\"\")=\"True\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),11)),\"\")&IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),13)),\"\"),IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),13)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),2)),\"\")=\"LS\",\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),2)),\"\")))","v":""},{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),IF(C37=\"\",\"\",C37),IF(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),8)),\"\")=\"True\",TRIM(RIGHT(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),3)),\"123456789012\"),LEN(IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),3)),\"123456789012\"))-9))&C37,IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),3))&C37,\"ITEM CODE DOES NOT EXIST IN ITEM MASTER\")))","v":""},null,null,null,null,{"$f":"IF(D37=\"\",\"\",D37)","v":""},null,null,{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IFERROR(IF(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),5)=\"True\",\"(Required) \",IF(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),6)=\"True\",\"(Optional) \",\"\"))&TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),4)),\"\"))","v":""},null,{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),5)),\"\"))","v":""},{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),6)),\"\"))","v":""},{"$f":"IF(OR(TRIM(B37)=0,TRIM(B37)=\"\"),\"\",IFERROR(TRIM(INDEX(QryItemNamed,MATCH(TRIM(B37),ITEM,0),7)),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,{"$f":"IF(D38=\"\",\"\",D38)","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,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"",null,null,"",null,"","",""]