{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ProjectInformation","PrintSheets","PrintSheetTemplate","Note1","BridgeBlock","DE108_26A","108_26A","Index"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":8,"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":"ProjectInformation","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[8,0,8,1]]}
["CPN DATA"]
["INFORMATION ADDED BY DESIGNER"]
["Engineer of Record","HDR\\Iowa DOT\\City of Dubuque"]
["Lead Designer"]
["County","DUBUQUE"]
["Project Number","NHSX-020-9(251)--3H-31"]
["English or Metric","English"]
["Revised"]
["Bridge Block"]
["File No."]

{"sheet":"PrintSheets","index":1,"n_rows":380,"n_cols":179,"rows_kept":380,"cut":false,"hidden":false,"merged":[[379,1,379,178],[283,171,283,178],[284,1,284,178],[378,1,378,7],[378,8,378,14],[378,15,378,21],[378,22,378,30],[378,31,378,64],[378,65,378,100],[378,101,378,106],[378,107,378,118],[378,119,378,148],[378,149,378,158],[378,159,378,164],[378,165,378,170],[378,171,378,178],[93,159,93,164],[93,165,93,170],[93,171,93,178],[94,1,94,178],[283,1,283,7],[283,8,283,14],[283,15,283,21],[283,22,283,30],[283,31,283,64],[283,65,283,100],[283,101,283,106],[283,107,283,118],[283,119,283,148],[283,149,283,158],[283,159,283,164],[283,165,283,170],[93,65,93,100],[93,101,93,106],[93,107,93,118],[93,119,93,148],[93,149,93,158],[93,1,93,7],[93,8,93,14],[93,15,93,21],[93,22,93,30],[93,31,93,64],[188,171,188,178],[189,1,189,178],[188,101,188,106],[188,107,188,118],[188,119,188,148],[188,149,188,158],[188,159,188,164],[188,165,188,170],[188,1,188,7],[188,8,188,14],[188,15,188,21],[188,22,188,30],[188,31,188,64],[188,65,188,100]]}
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"FILE NO.",null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$11<>\"\",ProjectInformation!$B$11,\"\")","v":""},null,null,null,null,null,null,{"$f":"UPPER(ProjectInformation!B8)","v":""},null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$4<>\"\",ProjectInformation!$B$5<>\"\"),ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4&\"\\\"&ProjectInformation!$B$5,IF(AND(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$4<>\"\"),ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4,IF(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$3,\"\")))","v":"HDR\\Iowa DOT\\City of Dubuque"},null,null,null,null,null,null,null,null,null,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(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","v":"NHSX-020-9(251)--3H-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY",null,null,null,null,null,"PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$7<>\"\",ProjectInformation!$B$7,\"\")","v":"English"},null,null,null,null,null,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 NUMBER",null,null,null,null,null,null,null,null,null,"J.1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$9<>\"\",ProjectInformation!$B$9,\"\")","v":""}]
["","8/31/2017     10:59:49 AM     cpodany     c:\\pwworking\\oma\\d2373617\\31020251j01.xlsm"]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"FILE NO.",null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$10<>\"\",ProjectInformation!$B$10,\"\")","v":""},null,null,null,null,null,null,{"$f":"UPPER(ProjectInformation!B7)","v":"ENGLISH"},null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4,\"\")","v":"HDR\\Iowa DOT\\City of Dubuque\\"},null,null,null,null,null,null,null,null,null,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(ProjectInformation!$B$5<>\"\",ProjectInformation!$B$5,\"\")","v":"DUBUQUE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY",null,null,null,null,null,"PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","v":"NHSX-020-9(251)--3H-31"},null,null,null,null,null,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 NUMBER",null,null,null,null,null,null,null,null,null,"J.1",null,null,null,null,null,{"$f":"IF(FP189<>\"\",\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$8<>\"\",ProjectInformation!$B$8,\"\")","v":""}]
["","8/31/2017     7:38:38 AM     cpodany     c:\\pwworking\\oma\\d2373617\\31020251j01.xlsm"]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"FILE NO.",null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$11<>\"\",ProjectInformation!$B$11,\"\")","v":""},null,null,null,null,null,null,{"$f":"UPPER(ProjectInformation!B8)","v":""},null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$4<>\"\",ProjectInformation!$B$5<>\"\"),ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4&\"\\\"&ProjectInformation!$B$5,IF(AND(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$4<>\"\"),ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4,IF(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$3,\"\")))","v":"HDR\\Iowa DOT\\City of Dubuque"},null,null,null,null,null,null,null,null,null,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(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","v":"NHSX-020-9(251)--3H-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY",null,null,null,null,null,"PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$7<>\"\",ProjectInformation!$B$7,\"\")","v":"English"},null,null,null,null,null,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 NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(FP284<>\"\",\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$9<>\"\",ProjectInformation!$B$9,\"\")","v":""}]
["","8/31/2017     7:38:38 AM     cpodany     c:\\pwworking\\oma\\d2373617\\31020251j01.xlsm"]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"FILE NO.",null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$11<>\"\",ProjectInformation!$B$11,\"\")","v":""},null,null,null,null,null,null,{"$f":"UPPER(ProjectInformation!B8)","v":""},null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$4<>\"\",ProjectInformation!$B$5<>\"\"),ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4&\"\\\"&ProjectInformation!$B$5,IF(AND(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$4<>\"\"),ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4,IF(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$3,\"\")))","v":"HDR\\Iowa DOT\\City of Dubuque"},null,null,null,null,null,null,null,null,null,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(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","v":"NHSX-020-9(251)--3H-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY",null,null,null,null,null,"PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$7<>\"\",ProjectInformation!$B$7,\"\")","v":"English"},null,null,null,null,null,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 NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(FP379<>\"\",\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$9<>\"\",ProjectInformation!$B$9,\"\")","v":""}]
["","8/31/2017     7:38:38 AM     cpodany     c:\\pwworking\\oma\\d2373617\\31020251j01.xlsm"]

{"sheet":"PrintSheetTemplate","index":2,"n_rows":95,"n_cols":179,"rows_kept":95,"cut":false,"hidden":true,"merged":[[93,171,93,178],[94,1,94,178],[93,101,93,106],[93,107,93,118],[93,119,93,148],[93,149,93,158],[93,159,93,164],[93,165,93,170],[93,1,93,7],[93,8,93,14],[93,15,93,21],[93,22,93,30],[93,31,93,64],[93,65,93,100]]}
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"FILE NO.",null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$10<>\"\",ProjectInformation!$B$10,\"\")","v":""},null,null,null,null,null,null,{"$f":"UPPER(ProjectInformation!$B$7)","v":"ENGLISH"},null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$3<>\"\",ProjectInformation!$B$3&\"\\\"&ProjectInformation!$B$4,\"\")","v":"HDR\\Iowa DOT\\City of Dubuque\\"},null,null,null,null,null,null,null,null,null,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(ProjectInformation!$B$5<>\"\",ProjectInformation!$B$5,\"\")","v":"DUBUQUE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY",null,null,null,null,null,"PROJECT NUMBER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","v":"NHSX-020-9(251)--3H-31"},null,null,null,null,null,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 NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(FP94<>\"\",\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$8<>\"\",ProjectInformation!$B$8,\"\")","v":""}]
[""]

{"sheet":"Note1","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,2,0]]}
["SEE V SHEETS FOR ADDITIONAL BID ITEMS AND QUANTITIES"]

{"sheet":"BridgeBlock","index":4,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":true,"merged":[[2,2,2,8],[3,2,3,7],[2,9,2,12],[3,8,3,12]]}
[2]
[null,"","","","","","","","","","","","",""]
[null,null,"Design No.",null,null,null,null,null,null,{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,"File No.",null,null,null,null,null,{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]

{"sheet":"DE108_26A","index":5,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,2,15,2],[16,4,17,4]]}
["TabTitle",{"$f":"C15","v":"STAGING NOTES"}]
["Number of Tab Columns",1]
["DE Starter Row Number",18]
["TabSheet Starter Row Number",5]
["TabSheet Header Row Count",4]
["Top Header Cell","E15"]
["Bottom Header Cell","E18"]
["DESheet Row Count",25]
["Fixed Empty Rows",5]
["Usable Empty Rows",0]
["Total Rows Placed",30,"xlLeft(1)",null,{"$f":"C11","v":"xlLeft(1)"}]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":30},"General",null,{"$f":"C12","v":"General"}]
["Last Tab DE Starter Row",18,{"$f":"CELL(\"width\",C13)","v":159},null,{"$f":"CELL(\"width\",E13)","v":0}]
["Last Tab TabSheet Starter Row",5,"A",null,{"$f":"LOWER(C14)","v":"a"}]
["Last Copy Starter Row",1,"STAGING NOTES",null,"108-26A"]
["Tab Loop Number",2,null,null,{"$f":"B17","v":"2008-08-01"}]
["Revision Date","2008-08-01",{"$f":"\"This Data Entry Sheet fills Tab \"&E15&\" effective \"&TEXT(B17,\"mm-dd-yy\")","v":"This Data Entry Sheet fills Tab 108-26A effective 08-01-08"},null,{"$f":"C15","v":"STAGING NOTES"}]
["Tabulation Width",2,"Stage 1A"]
["Horizontal Grid Lines","No","Traffic:"]
[null,null,"Maintain traffic on existing US 20."]
[null,null,"Maintain access from US 20."]
[]
[null,null,"Construction:"]
[null,null,"Construct Landfill Road but defer tie-in portion at west end until bridge and road is ready to open. "]
[null,null,"Construct Landfill Road Bridge over Catfish Creek."]
[]
[]
[null,null,"Stage 1B"]
[null,null,"Traffic:"]
[null,null,"Open Landfill Road from existing landfill access to just west of new bridge for local access."]
[null,null,"Close access to parcels from US 20 east of landfill. "]
[]
[null,null,"Construction:"]
[null,null,"Continue construction of Landfill Road."]
[]
[]
[null,null,"Stage 1C"]
[null,null,"Traffic:"]
[null,null,"Open Landfill Road from Landfill to Seippel Road via detour pavement and staged construction at west end."]
[]
[null,null,"Construction:"]
[null,null,"Remove detour pavement and existing Landfill access from US 20"]

{"sheet":"108_26A","index":6,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,0,3,0]]}
["108-26A"]
["2008-08-01"]
["STAGING NOTES"]
[]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C18)-1,COLUMNS($C$18:C18)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C18)-1,COLUMNS($C$18:C18)-1),\"\")","v":"Stage 1A"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C19)-1,COLUMNS($C$18:C19)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C19)-1,COLUMNS($C$18:C19)-1),\"\")","v":"Traffic:"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C20)-1,COLUMNS($C$18:C20)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C20)-1,COLUMNS($C$18:C20)-1),\"\")","v":"Maintain traffic on existing US 20."}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C21)-1,COLUMNS($C$18:C21)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C21)-1,COLUMNS($C$18:C21)-1),\"\")","v":"Maintain access from US 20."}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C22)-1,COLUMNS($C$18:C22)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C22)-1,COLUMNS($C$18:C22)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C23)-1,COLUMNS($C$18:C23)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C23)-1,COLUMNS($C$18:C23)-1),\"\")","v":"Construction:"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C24)-1,COLUMNS($C$18:C24)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C24)-1,COLUMNS($C$18:C24)-1),\"\")","v":"Construct Landfill Road but defer tie-in portion at west end until bridge and road is ready to open. "}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C25)-1,COLUMNS($C$18:C25)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C25)-1,COLUMNS($C$18:C25)-1),\"\")","v":"Construct Landfill Road Bridge over Catfish Creek."}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C26)-1,COLUMNS($C$18:C26)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C26)-1,COLUMNS($C$18:C26)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C27)-1,COLUMNS($C$18:C27)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C27)-1,COLUMNS($C$18:C27)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C28)-1,COLUMNS($C$18:C28)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C28)-1,COLUMNS($C$18:C28)-1),\"\")","v":"Stage 1B"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C29)-1,COLUMNS($C$18:C29)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C29)-1,COLUMNS($C$18:C29)-1),\"\")","v":"Traffic:"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C30)-1,COLUMNS($C$18:C30)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C30)-1,COLUMNS($C$18:C30)-1),\"\")","v":"Open Landfill Road from existing landfill access to just west of new bridge for local access."}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C31)-1,COLUMNS($C$18:C31)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C31)-1,COLUMNS($C$18:C31)-1),\"\")","v":"Close access to parcels from US 20 east of landfill. "}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C32)-1,COLUMNS($C$18:C32)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C32)-1,COLUMNS($C$18:C32)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C33)-1,COLUMNS($C$18:C33)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C33)-1,COLUMNS($C$18:C33)-1),\"\")","v":"Construction:"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C34)-1,COLUMNS($C$18:C34)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C34)-1,COLUMNS($C$18:C34)-1),\"\")","v":"Continue construction of Landfill Road."}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C35)-1,COLUMNS($C$18:C35)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C35)-1,COLUMNS($C$18:C35)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C36)-1,COLUMNS($C$18:C36)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C36)-1,COLUMNS($C$18:C36)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C37)-1,COLUMNS($C$18:C37)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C37)-1,COLUMNS($C$18:C37)-1),\"\")","v":"Stage 1C"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C38)-1,COLUMNS($C$18:C38)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C38)-1,COLUMNS($C$18:C38)-1),\"\")","v":"Traffic:"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C39)-1,COLUMNS($C$18:C39)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C39)-1,COLUMNS($C$18:C39)-1),\"\")","v":"Open Landfill Road from Landfill to Seippel Road via detour pavement and staged construction at west end."}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C40)-1,COLUMNS($C$18:C40)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C40)-1,COLUMNS($C$18:C40)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C41)-1,COLUMNS($C$18:C41)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C41)-1,COLUMNS($C$18:C41)-1),\"\")","v":"Construction:"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C42)-1,COLUMNS($C$18:C42)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C42)-1,COLUMNS($C$18:C42)-1),\"\")","v":"Remove detour pavement and existing Landfill access from US 20"}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C43)-1,COLUMNS($C$18:C43)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C43)-1,COLUMNS($C$18:C43)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C44)-1,COLUMNS($C$18:C44)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C44)-1,COLUMNS($C$18:C44)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C45)-1,COLUMNS($C$18:C45)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C45)-1,COLUMNS($C$18:C45)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C46)-1,COLUMNS($C$18:C46)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C46)-1,COLUMNS($C$18:C46)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_26A!$C$18,ROWS($C$18:C47)-1,COLUMNS($C$18:C47)-1)<>\"\",OFFSET(DE108_26A!$C$18,ROWS($C$18:C47)-1,COLUMNS($C$18:C47)-1),\"\")","v":""}]

{"sheet":"Index","index":7,"n_rows":164,"n_cols":15,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
["100-0A","1997-10-28","4.5.1","ADAIR",null,"Live English File Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\ExcelTabs\\",null,"Brian R. Smith","bsmith2","Methods","ROADWAY DESIGN",null,"108_26A(1)","='108_26A'!$A$1:$A$34"]
["100-1A","1997-07-15","05/21/13","ADAMS",null,"Live Metric File Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\ExcelTabs\\MetricTabs\\",null,"Khyle B. Clute","kclute","Methods","ROADWAY DESIGN"]
["100-1C","2012-04-17","J","ALLAMAKEE",null,"Index File Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\Indexes\\",null,"Thomas M. Hamski","thamski","Methods","ROADWAY DESIGN"]
["100-1D","2005-10-18",null,"APPANOOSE",null,"Index File Name","TNT_EnglishIndexes.xlsx",null,"Wesley L. Mayberry","wmayber","Methods","ROADWAY DESIGN"]
["100-4A","2002-10-29",null,"AUDUBON",null,"Last Revision English File Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\Old_Details\\ExcelTabs\\",null,"John M. Narigon","jnarigo","Methods","ROADWAY DESIGN"]
["100-7","2012-10-16",null,"BENTON",null,"Last Revision Metric File Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\Old_Details\\ExcelTabs\\MetricTabs\\",null,"Christopher Poole","cpoole","Methods","ROADWAY DESIGN"]
["100-10","2011-10-18",null,"BLACK HAWK",null,"Seed Path","Z:\\IADOTE\\v8i\\HDR\\seed_files\\Spreadsheets\\ExcelTabulations.xltm",null,"Daniel J. Harness","dharnes","Methods","ROADWAY DESIGN"]
["100-11","2008-08-01",null,"BOONE",null,"VersionCheck Path","Z:\\IADOTE\\v8i\\HDR\\seed_files\\Spreadsheets\\ExcelTabulations.xlsm",null,"R.D. Skogerboe","dskoger","Road1","ROADWAY DESIGN"]
["100-12","2008-08-01",null,"BREMER",null,"Standard Road Plan Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\Indexes\\SRP_EnglishIndex.xls",null,"Jason R. Strum","jstrum","Road1","ROADWAY DESIGN"]
["100-12A","2008-08-01",null,"BUCHANAN",null,"Last Revision Standard Road Plan Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\Indexes\\Old_Indexes\\SRP_EnglishIndex.xls",null,"Robert A. Schoenrock","rschoen","Road1","ROADWAY DESIGN"]
["100-13","2010-04-20",null,"BUENA VISTA",null,"AddIn Path","Z:\\IADOTE\\v8i\\HDR\\seed_files\\Spreadsheets\\ExcelTabulations.xlam",null,"Stacy M. Ryan","sryan","Road1","ROADWAY DESIGN"]
["100-14","2010-04-20",null,"BUTLER",null,"Old Files Path","Z:\\IADOTE\\v8i\\RoadDesignDetails\\Old_Details\\ExcelTabs\\",null,"Nathan A. Thede","nthede","Road1","ROADWAY DESIGN"]
["100-15","2010-04-20",null,"CALHOUN",null,null,null,null,"Yanxiao Jia","yjia","Road2","ROADWAY DESIGN"]
["100-16","2010-10-19",null,"CARROLL",null,null,null,null,"Ryan R. Miller","rmille3","Road2","ROADWAY DESIGN"]
["100-17","2010-04-20",null,"CASS",null,null,null,null,"Jason M. Holst","jholst","Road2","ROADWAY DESIGN"]
["100-18","2010-04-20",null,"CEDAR",null,null,null,null,"Dustin T. Skogerboe","dskoge2","Road2","ROADWAY DESIGN"]
["100-19","2012-10-16",null,"CERRO GORDO",null,null,null,null,"Dung T. Ta","dta","Road2","ROADWAY DESIGN"]
["100-20","2008-08-01",null,"CHEROKEE",null,null,null,null,"Paul W. Flattery","pflatte","Road3","ROADWAY DESIGN"]
["100-21","2008-08-01",null,"CHICKASAW",null,null,null,null,"Kelly C. Bell","kbell","Road3","ROADWAY DESIGN"]
["100-22","2008-08-01",null,"CLARKE",null,null,null,null,"Angela K. Johnson","ajohns1","Road3","ROADWAY DESIGN"]
["100-23","2010-10-19",null,"CLAY",null,null,null,null,"Elijah D. Gansen","egansen","Road3","ROADWAY DESIGN"]
["100-24","2013-04-16",null,"CLAYTON",null,null,null,null,"James R. Schoenrock","jschoen","Consultant","ROADWAY DESIGN"]
["100-26","2008-08-01",null,"CLINTON",null,null,null,null,"Randall E. Schlei","rschlie","Consultant","ROADWAY DESIGN"]
["100-27","2009-10-20",null,"CRAWFORD",null,null,null,null,"Mark D. Mastellar","mmastel","Roadside","ROADWAY DESIGN"]
["100-28","2010-10-19",null,"DALLAS",null,null,null,null,"Robert L. Stanley","rstanle","Soils","GEOTECHNICAL DESIGN"]
["101-4","2002-04-30",null,"DAVIS",null,null,null,null,"Stephen J. Megivern","smegive","Soils","GEOTECHNICAL DESIGN"]
["101-5","2002-04-30",null,"DECATUR",null,null,null,null,"Mark A. Dell","mdell","Soils","GEOTECHNICAL DESIGN"]
["101-6","2002-04-30",null,"DELAWARE",null,null,null,null,"David R. Claman","dclaman","Bridge","HYDRAULIC DESIGN"]
["101-7","2002-04-30",null,"DES MOINES",null,null,null,null,"Zachary K. Abrams","zabrams","TrafficAndSafety","ROADWAY DESIGN"]
["101-8","2013-04-16",null,"DICKINSON"]
["101-13","2004-04-20",null,"DUBUQUE"]
["101-16","2009-10-20",null,"EMMET"]
["101-17","2011-04-19",null,"FAYETTE"]
["101-18","2011-04-19",null,"FLOYD"]
["102-3","2013-04-16",null,"FRANKLIN"]
["102-4","2011-10-18",null,"FREMONT"]
["102-5","2012-10-16",null,"GREENE"]
["102-5A","2008-08-01",null,"GRUNDY"]
["102-6C","2011-10-18",null,"GUTHRIE"]
["102-10","2008-08-01",null,"HAMILTON"]
["102-11","2008-08-01",null,"HANCOCK"]
["102-12","2008-08-01",null,"HARDIN"]
["102-14","2012-04-17",null,"HARRISON"]
["102-15","2008-08-01",null,"HENRY"]
["103-1","2010-10-19",null,"HOWARD"]
["103-3","2012-10-16",null,"HUMBOLDT"]
["103-4","2011-04-19",null,"IDA"]
["103-5","2008-08-01",null,"IOWA"]
["103-6","2011-04-19",null,"JACKSON"]
["103-7","2008-08-01",null,"JASPER"]
["104-3","2012-10-16",null,"JEFFERSON"]
["104-4","2009-10-20",null,"JOHNSON"]
["104-5A","2011-10-18",null,"JONES"]
["104-5B","2011-10-18",null,"KEOKUK"]
["104-5C","2012-04-17",null,"KOSSUTH"]
["104-8","2008-08-01",null,"LEE"]
["104-8A","2010-04-20",null,"LINN"]
["104-9","2012-04-17",null,"LOUSIA"]
["104-10","2008-08-01",null,"LUCAS"]
["104-11","2008-08-01",null,"LYON"]
["104-12","2012-10-16",null,"MADISON"]
["104-13","2013-04-16",null,"MAHASKA"]
["105-1","1994-09-27",null,"MARION"]
["105-3","2005-10-18",null,"MARSHALL"]
["105-4","2011-10-18",null,"MILLS"]
["106-1","2008-08-01",null,"MITCHELL"]
["106-2","2008-08-01",null,"MONONA"]
["106-3","2008-08-01",null,"MONROE"]
["106-4","2013-04-16",null,"MONTGOMERY"]
["106-5","2008-08-01",null,"MUSCATINE"]
["106-7","2008-08-01",null,"O'BRIEN"]
["106-8","2011-04-19",null,"OSCEOLA"]
["107-7","2008-08-01",null,"PAGE"]
["107-22","2013-04-16",null,"PALO ALTO"]
["107-23","2011-10-18",null,"PLYMOUTH"]
["107-24","2008-08-01",null,"POCAHONTAS"]
["107-25","2008-08-01",null,"POLK"]
["107-29","2012-04-17",null,"POTTAWATTAMIE"]
["107-30","2012-04-17",null,"POWESHIEK"]
["107-31","2011-04-19",null,"RINGGOLD"]
["108-1","2008-08-01",null,"SAC"]
["108-2","2008-08-01",null,"SCOTT"]
["108-2A","2008-08-01",null,"SHELBY"]
["108-8A","2010-10-19",null,"SIOUX"]
["108-8B","2011-10-18",null,"STORY"]
["108-8C","2011-10-18",null,"TAMA"]
["108-8D","2010-10-19",null,"TAYLOR"]
["108-9A","2010-04-20",null,"UNION"]
["108-11A","2008-08-01",null,"VAN BUREN"]
["108-12","2008-08-01",null,"WAPELLO"]
["108-13A","2008-08-01",null,"WARREN"]
["108-15","2008-08-01",null,"WASHINGTON"]
["108-16","2010-10-19",null,"WAYNE"]
["108-18","2011-10-18",null,"WEBSTER"]
["108-18B","2012-10-16",null,"WINNEBAGO"]
["108-22","2013-04-16",null,"WINNESHIEK"]
["108-23A","2008-08-01",null,"WOODBURY"]
["108-24","2011-04-19",null,"WORTH"]
["108-26A","2008-08-01",null,"WRIGHT"]
["108-27","2012-10-16"]
["108-28","2008-08-01"]
["108-29","2012-10-16"]
["108-30","2013-04-16"]
["108-33","2013-04-16"]
["108-34","2010-10-19"]
["108-35","2012-04-17"]
["110-1","2013-04-16"]
["110-2","2013-04-16"]
["110-3","2008-08-01"]
["110-4","2008-08-01"]
["110-5","2008-08-01"]
["110-6","2008-08-01"]
["110-7A","2012-04-17"]
["110-7B","2010-10-19"]
["110-8","2008-08-01"]
["110-9","2011-10-18"]
["110-10","2008-08-01"]
["110-11","2008-08-01"]
["110-12A","2013-04-16"]
["110-13","2010-04-20"]
["110-14","2013-04-16"]
["110-15","2013-04-16"]
["110-16","2013-04-16"]
["111-1","2012-04-17"]
["111-2","1989-02-28"]
["111-23","2002-10-29"]
["111-25","2011-10-18"]
["112-3","2013-04-16"]
["112-5","2008-08-01"]
["112-6","2013-04-16"]
["112-7","2010-10-19"]
["112-8","2012-10-16"]
["112-9","2012-04-17"]
["112-10","2011-04-19"]
["113-1","2013-04-16"]
["113-2","2013-04-16"]
["113-3","2011-10-18"]
["113-10","2012-10-16"]
["213-2","2011-10-18"]
["213-3","2011-10-18"]
["231-1","2011-10-18"]
["231-2","2012-10-16"]
["232-3A","2012-10-16"]
["232-3B","2012-10-16"]
["232-3C","2012-10-16"]
["232-3D","2012-10-16"]
["232-4","2011-10-18"]
["232-6","2011-10-18"]
["232-7","2012-10-16"]
["232-9","2011-10-18"]
["232-11","2012-10-16"]
["241-5","2011-10-18"]
["252-1","2012-10-16"]
["253-1","2011-10-18"]
["254-1","2001-10-02"]
["262-3","2012-10-16"]
["262-4","2013-04-16"]
["262-5","2005-10-18"]
["262-6","2005-10-18"]
["263-1","2011-10-18"]
["271-1","2011-10-18"]
["271-2","1985-08-20"]
["271-4","2011-10-18"]
["271-9","1994-09-27"]