{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["ProjectInformation","PrintSheets","DE102_15","DE108_23A","DE108_26A","DE111_01","102_15","108_23A","108_26A","111_01","PrintSheetTemplate","Index"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"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":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,5],[1,0,1,1],[1,3,1,5]]}
["CPN DATA",null,null,"INDEX OF TABULATIONS"]
["INFORMATION ADDED BY DESIGNER",null,null,"INFORMATION ADDED BY AUTOMATION"]
["Design Team","Flattery\\Bell"]
["County","BENTON"]
["Project Number","NHS-030-6(87)--19-06"]
["English or Metric","English"]
["Revised"]

{"sheet":"PrintSheets","index":1,"n_rows":95,"n_cols":179,"rows_kept":95,"cut":false,"hidden":false,"merged":[[94,1,94,178],[93,107,93,118],[93,119,93,148],[93,149,93,158],[93,159,93,164],[93,165,93,170],[93,171,93,178],[93,1,93,14],[93,15,93,21],[93,22,93,30],[93,31,93,64],[93,65,93,100],[93,101,93,106]]}
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"UPPER(ProjectInformation!B6)","v":"ENGLISH"},null,null,null,null,null,null,null,null,null,null,null,null,null,"IOWA DOT",null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,{"$f":"ProjectInformation!B3","v":"Flattery\\Bell"},null,null,null,null,null,null,null,null,null,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":"ProjectInformation!B4","v":"BENTON"},null,null,null,null,null,null,null,null,null,null,null,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":"ProjectInformation!B5","v":"NHS-030-6(87)--19-06"},null,null,null,null,null,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(FP94<>0,\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"ProjectInformation!B7","v":"00:00:00"}]
["","10/24/2013     2:31:31 PM     kbell     c:\\pw_work\\pwmain\\kbell\\dms36272\\06030087J01.xlsm"]

{"sheet":"DE102_15","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,2,15,4],[14,6,14,8],[15,6,15,8],[16,2,16,4],[16,6,17,8]]}
["TabTitle",{"$f":"C15","v":"TABULATION OF SPECIAL EVENTS"}]
["Number of Tab Columns",3]
["DE Starter Row Number",19]
["TabSheet Starter Row Number",6]
["TabSheet Header Row Count",5]
["Top Header Cell","G15"]
["Bottom Header Cell","I19"]
["DESheet Row Count",2]
["Fixed Empty Rows",10]
["Usable Empty Rows",0]
["Total Rows Placed",12,"xlLeft","xlLeft","xlCenter",null,{"$f":"C11","v":"xlLeft"},"xlLeft","xlCenter"]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":12},"General","General","mm/dd/yy",null,"General","General","mm/dd/yy"]
["Last Tab DE Starter Row",19,{"$f":"CELL(\"width\",C13)","v":65},{"$f":"CELL(\"width\",D13)","v":65},{"$f":"CELL(\"width\",E13)","v":27},null,{"$f":"CELL(\"width\",G13)","v":0},{"$f":"CELL(\"width\",H13)","v":0},{"$f":"CELL(\"width\",I13)","v":0}]
["Last Tab Tabsheet Starter Row",6,"A","B","C",null,"a","b","c"]
["Last Copy Starter Row",1,"TABULATION OF SPECIAL EVENTS",null,null,null,"102-15"]
["Tab Loop Number",2,null,null,null,null,{"$f":"B17","v":"2008-08-01"}]
["Revision Date","2008-08-01",{"$f":"\"This Data Entry Sheet fills Tab \"&G15&\" effective \"&TEXT(B17,\"mm-dd-yy\")","v":"This Data Entry Sheet fills Tab 102-15 effective 08-01-08"},null,null,null,{"$f":"C15","v":"TABULATION OF SPECIAL EVENTS"}]
["Tabulation Width",2,"Event","Location","Date"]
["Horizontal Grid Lines","Yes",null,null,null,null,{"$f":"C18","v":"Event"},{"$f":"D18","v":"Location"},{"$f":"E18","v":"Date"}]
[null,null,"TBD"]

{"sheet":"DE108_23A","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,2,15,2],[16,4,17,4]]}
["TabTitle",{"$f":"C15","v":"TRAFFIC CONTROL PLAN"}]
["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",8]
["Fixed Empty Rows",10]
["Usable Empty Rows",0]
["Total Rows Placed",18,"xlLeft(1)",null,{"$f":"IF(C11<>\"\",C11,\"\")","v":"xlLeft(1)"}]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":18},"General",null,{"$f":"IF(C12<>\"\",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,"a"]
["Last Copy Starter Row",1,"TRAFFIC CONTROL PLAN",null,"108-23A"]
["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-23A effective 08-01-08"},null,{"$f":"C15","v":"TRAFFIC CONTROL PLAN"}]
["Tabulation Width",2]
["Horizontal Grid Lines","No","U.S. 30 traffic will be maintained at all times."]
[]
[null,null,"Iowa 21 traffic will be maintained on offsite detour during bridge/interchange construction."]
[]
[null,null,"U.S. 218 traffic will be maintained via offsite detour during bridge/interchange construction."]
[]
[null,null,"No two adjacent sideroads are to be closed at the same time."]
[]
[null,null,"Closures on County Rd V66 should be limited to the summer months when school is out (wording per email from Newman Abuissa per"]
[null,null,"County Engineer request…will need to reword)"]
[]
[null,null,"Closures on all paved roads should be minimized."]

{"sheet":"DE108_26A","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"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",4]
["Fixed Empty Rows",10]
["Usable Empty Rows",0]
["Total Rows Placed",14,"xlLeft(1)",null,{"$f":"C11","v":"xlLeft(1)"}]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":14},"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]
["Horizontal Grid Lines","No","Stage 1 & 2: Grade and Pave Eastbound U.S. 30 lanes"]
[]
[null,null,"Stage 3 & 4: Grade and Pave Westbound U.S. 30 lanes/obliterate existing U.S. 30"]

{"sheet":"DE111_01","index":5,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,6,25,6],[14,2,16,3],[14,5,14,6],[15,5,15,6],[16,5,18,6],[17,2,21,3],[19,5,23,6],[22,2,22,3],[23,2,24,2],[23,3,24,3],[24,5,25,5]]}
["TabTitle",{"$f":"C15","v":"COORDINATED OPERATIONS"}]
["Number of Tab Columns",2]
["DE Starter Row Number",26]
["TabSheet Starter Row Number",13]
["TabSheet Header Row Count",12]
["Top Header Cell","F15"]
["Bottom Header Cell","G26"]
["DESheet Row Count",1]
["Fixed Empty Rows",2]
["Usable Empty Rows",0]
["Total Rows Placed",3,"xlLeft(1)","xlLeft(1)",null,{"$f":"C11","v":"xlLeft(1)"},{"$f":"D11","v":"xlLeft(1)"}]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":3},"General","General",null,{"$f":"C12","v":"General"},{"$f":"D12","v":"General"}]
["Last Tab DE Starter Row",26,{"$f":"CELL(\"width\",C13)","v":35},{"$f":"CELL(\"width\",D13)","v":37},null,{"$f":"CELL(\"width\",F13)","v":0},{"$f":"CELL(\"width\",G13)","v":0}]
["Last Tab Tabsheet Starter Row",13,"A","B",null,{"$f":"LOWER(C14)","v":"a"},{"$f":"LOWER(D14)","v":"b"}]
["Last Copy Starter Row",1,"COORDINATED OPERATIONS",null,null,"111-01"]
["Tab Loop Number",2,null,null,null,{"$f":"B17","v":"2012-04-17"}]
["Revision Date","2012-04-17",null,null,null,{"$f":"C15","v":"COORDINATED OPERATIONS"}]
["Tabulation Width",1,"Other work in progress during the same period of time will include the construction of the projects listed. Coordinate operations with those of other contractors working within the same area. "]
["Horizontal Grid Lines","Yes"]
[null,null,null,null,null,{"$f":"C18","v":"Other work in progress during the same period of time will include the construction of the projects listed. Coordinate operations with those of other contractors working within the same area. "}]
[]
[]
[null,null,{"$f":"\"This Data Entry Sheet fills Tab \"&F15&\" effective \"&TEXT(B17,\"mm-dd-yy\")","v":"This Data Entry Sheet fills Tab 111-01 effective 04-17-12"}]
[null,null,"Project","Type of Work"]
[null,null,null,null,null,{"$f":"C24","v":"Project"},{"$f":"D24","v":"Type of Work"}]
[null,null,"TBD"]

{"sheet":"102_15","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,3,2]]}
["102-15"]
["2008-08-01"]
["TABULATION OF SPECIAL EVENTS"]
[]
["Event","Location","Date"]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C19)-1,COLUMNS($C$19:C19)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C19)-1,COLUMNS($C$19:C19)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D19)-1,COLUMNS($D$19:D19)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D19)-1,COLUMNS($D$19:D19)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E19)-1,COLUMNS($E$19:E19)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E19)-1,COLUMNS($E$19:E19)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C20)-1,COLUMNS($C$19:C20)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C20)-1,COLUMNS($C$19:C20)-1),\"\")","v":"TBD"},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D20)-1,COLUMNS($D$19:D20)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D20)-1,COLUMNS($D$19:D20)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E20)-1,COLUMNS($E$19:E20)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E20)-1,COLUMNS($E$19:E20)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C21)-1,COLUMNS($C$19:C21)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C21)-1,COLUMNS($C$19:C21)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D21)-1,COLUMNS($D$19:D21)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D21)-1,COLUMNS($D$19:D21)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E21)-1,COLUMNS($E$19:E21)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E21)-1,COLUMNS($E$19:E21)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C22)-1,COLUMNS($C$19:C22)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C22)-1,COLUMNS($C$19:C22)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D22)-1,COLUMNS($D$19:D22)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D22)-1,COLUMNS($D$19:D22)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E22)-1,COLUMNS($E$19:E22)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E22)-1,COLUMNS($E$19:E22)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C23)-1,COLUMNS($C$19:C23)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C23)-1,COLUMNS($C$19:C23)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D23)-1,COLUMNS($D$19:D23)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D23)-1,COLUMNS($D$19:D23)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E23)-1,COLUMNS($E$19:E23)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E23)-1,COLUMNS($E$19:E23)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C24)-1,COLUMNS($C$19:C24)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C24)-1,COLUMNS($C$19:C24)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D24)-1,COLUMNS($D$19:D24)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D24)-1,COLUMNS($D$19:D24)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E24)-1,COLUMNS($E$19:E24)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E24)-1,COLUMNS($E$19:E24)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C25)-1,COLUMNS($C$19:C25)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C25)-1,COLUMNS($C$19:C25)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D25)-1,COLUMNS($D$19:D25)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D25)-1,COLUMNS($D$19:D25)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E25)-1,COLUMNS($E$19:E25)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E25)-1,COLUMNS($E$19:E25)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C26)-1,COLUMNS($C$19:C26)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C26)-1,COLUMNS($C$19:C26)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D26)-1,COLUMNS($D$19:D26)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D26)-1,COLUMNS($D$19:D26)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E26)-1,COLUMNS($E$19:E26)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E26)-1,COLUMNS($E$19:E26)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C27)-1,COLUMNS($C$19:C27)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C27)-1,COLUMNS($C$19:C27)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D27)-1,COLUMNS($D$19:D27)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D27)-1,COLUMNS($D$19:D27)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E27)-1,COLUMNS($E$19:E27)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E27)-1,COLUMNS($E$19:E27)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C28)-1,COLUMNS($C$19:C28)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C28)-1,COLUMNS($C$19:C28)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D28)-1,COLUMNS($D$19:D28)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D28)-1,COLUMNS($D$19:D28)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E28)-1,COLUMNS($E$19:E28)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E28)-1,COLUMNS($E$19:E28)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C29)-1,COLUMNS($C$19:C29)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C29)-1,COLUMNS($C$19:C29)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D29)-1,COLUMNS($D$19:D29)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D29)-1,COLUMNS($D$19:D29)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E29)-1,COLUMNS($E$19:E29)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E29)-1,COLUMNS($E$19:E29)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE102_15!$C$19,ROWS($C$19:C30)-1,COLUMNS($C$19:C30)-1)<>\"\",OFFSET(DE102_15!$C$19,ROWS($C$19:C30)-1,COLUMNS($C$19:C30)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$D$19,ROWS($D$19:D30)-1,COLUMNS($D$19:D30)-1)<>\"\",OFFSET(DE102_15!$D$19,ROWS($D$19:D30)-1,COLUMNS($D$19:D30)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE102_15!$E$19,ROWS($E$19:E30)-1,COLUMNS($E$19:E30)-1)<>\"\",OFFSET(DE102_15!$E$19,ROWS($E$19:E30)-1,COLUMNS($E$19:E30)-1),\"\")","v":""}]

{"sheet":"108_23A","index":7,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,3,0]]}
["108-23A"]
["2008-08-01"]
["TRAFFIC CONTROL PLAN"]
[]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C18)-1,COLUMNS($C$18:C18)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C18)-1,COLUMNS($C$18:C18)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C19)-1,COLUMNS($C$18:C19)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C19)-1,COLUMNS($C$18:C19)-1),\"\")","v":"U.S. 30 traffic will be maintained at all times."}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C20)-1,COLUMNS($C$18:C20)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C20)-1,COLUMNS($C$18:C20)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C21)-1,COLUMNS($C$18:C21)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C21)-1,COLUMNS($C$18:C21)-1),\"\")","v":"Iowa 21 traffic will be maintained on offsite detour during bridge/interchange construction."}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C22)-1,COLUMNS($C$18:C22)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C22)-1,COLUMNS($C$18:C22)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C23)-1,COLUMNS($C$18:C23)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C23)-1,COLUMNS($C$18:C23)-1),\"\")","v":"U.S. 218 traffic will be maintained via offsite detour during bridge/interchange construction."}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C24)-1,COLUMNS($C$18:C24)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C24)-1,COLUMNS($C$18:C24)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C25)-1,COLUMNS($C$18:C25)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C25)-1,COLUMNS($C$18:C25)-1),\"\")","v":"No two adjacent sideroads are to be closed at the same time."}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C26)-1,COLUMNS($C$18:C26)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C26)-1,COLUMNS($C$18:C26)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C27)-1,COLUMNS($C$18:C27)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C27)-1,COLUMNS($C$18:C27)-1),\"\")","v":"Closures on County Rd V66 should be limited to the summer months when school is out (wording per email from Newman Abuissa per"}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C28)-1,COLUMNS($C$18:C28)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C28)-1,COLUMNS($C$18:C28)-1),\"\")","v":"County Engineer request…will need to reword)"}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C29)-1,COLUMNS($C$18:C29)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C29)-1,COLUMNS($C$18:C29)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C30)-1,COLUMNS($C$18:C30)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C30)-1,COLUMNS($C$18:C30)-1),\"\")","v":"Closures on all paved roads should be minimized."}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C31)-1,COLUMNS($C$18:C31)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C31)-1,COLUMNS($C$18:C31)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C32)-1,COLUMNS($C$18:C32)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C32)-1,COLUMNS($C$18:C32)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C33)-1,COLUMNS($C$18:C33)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C33)-1,COLUMNS($C$18:C33)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C34)-1,COLUMNS($C$18:C34)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C34)-1,COLUMNS($C$18:C34)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE108_23A!$C$18,ROWS($C$18:C35)-1,COLUMNS($C$18:C35)-1)<>\"\",OFFSET(DE108_23A!$C$18,ROWS($C$18:C35)-1,COLUMNS($C$18:C35)-1),\"\")","v":""}]

{"sheet":"108_26A","index":8,"n_rows":18,"n_cols":1,"rows_kept":18,"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":""}]
[{"$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":"Stage 1 & 2: Grade and Pave Eastbound U.S. 30 lanes"}]
[{"$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":""}]
[{"$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":"Stage 3 & 4: Grade and Pave Westbound U.S. 30 lanes/obliterate existing U.S. 30"}]
[{"$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":""}]
[{"$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":""}]
[{"$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":""}]
[{"$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":""}]
[{"$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":""}]
[{"$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":""}]
[{"$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":""}]

{"sheet":"111_01","index":9,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,4,1],[5,0,9,1],[10,0,11,0],[10,1,11,1]]}
["111-01"]
["2012-04-17"]
["COORDINATED OPERATIONS"]
[]
[]
["Other work in progress during the same period of time will include the construction of the projects listed. Coordinate operations with those of other contractors working within the same area. "]
[]
[]
[]
[]
["Project","Type of Work"]
[]
[{"$f":"IF(OFFSET(DE111_01!$C$26,ROWS($C$26:C26)-1,COLUMNS($C$26:C26)-1)<>\"\",OFFSET(DE111_01!$C$26,ROWS($C$26:C26)-1,COLUMNS($C$26:C26)-1),\"\")","v":"TBD"},{"$f":"IF(OFFSET(DE111_01!$D$26,ROWS($D$26:D26)-1,COLUMNS($D$26:D26)-1)<>\"\",OFFSET(DE111_01!$D$26,ROWS($D$26:D26)-1,COLUMNS($D$26:D26)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE111_01!$C$26,ROWS($C$26:C27)-1,COLUMNS($C$26:C27)-1)<>\"\",OFFSET(DE111_01!$C$26,ROWS($C$26:C27)-1,COLUMNS($C$26:C27)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE111_01!$D$26,ROWS($D$26:D27)-1,COLUMNS($D$26:D27)-1)<>\"\",OFFSET(DE111_01!$D$26,ROWS($D$26:D27)-1,COLUMNS($D$26:D27)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE111_01!$C$26,ROWS($C$26:C28)-1,COLUMNS($C$26:C28)-1)<>\"\",OFFSET(DE111_01!$C$26,ROWS($C$26:C28)-1,COLUMNS($C$26:C28)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE111_01!$D$26,ROWS($D$26:D28)-1,COLUMNS($D$26:D28)-1)<>\"\",OFFSET(DE111_01!$D$26,ROWS($D$26:D28)-1,COLUMNS($D$26:D28)-1),\"\")","v":""}]

{"sheet":"PrintSheetTemplate","index":10,"n_rows":95,"n_cols":179,"rows_kept":95,"cut":false,"hidden":true,"merged":[[94,1,94,178],[93,107,93,118],[93,119,93,148],[93,149,93,158],[93,159,93,164],[93,165,93,170],[93,171,93,178],[93,1,93,14],[93,15,93,21],[93,22,93,30],[93,31,93,64],[93,65,93,100],[93,101,93,106]]}
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOWA DOT",null,null,null,null,null,null,"DESIGN TEAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,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<>0,\"REVISED\",\"\")","v":""},null,null,null,null,null,"00:00:00"]
[""]

{"sheet":"Index","index":11,"n_rows":124,"n_cols":15,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["100-0A","1997-10-28","4.4",null,null,"Live English File Path","W:\\Highway\\Design\\RoadDesignDetails\\ExcelTabs\\",null,"R.D. Skogerboe","dskoger","Road1","ROADWAY DESIGN",null,"102_15(1)","='102_15'!$A$1:$C$17"]
["100-1A","1997-07-15","07/30/12",null,null,"Live Metric File Path","W:\\Highway\\Design\\RoadDesignDetails\\ExcelTabs\\MetricTabs\\",null,"Jason R. Strum","jstrum","Road1","ROADWAY DESIGN",null,"108_23A(1)","='108_23A'!$A$1:$A$22"]
["100-1B","---  ","J",null,null,"Index File Path","W:\\Highway\\Design\\RoadDesignDetails\\PDFsandWebFiles\\Indexes\\",null,"Robert A. Schoenrock","rschoen","Road1","ROADWAY DESIGN",null,"111_01(1)","='111_01'!$A$1:$B$15"]
["100-1C","2012-04-17",null,null,null,"Index File Name","TNT_EnglishIndexes.xlsx",null,"Stacy M. Ryan","sryan","Road1","ROADWAY DESIGN",null,"108_26A(1)","='108_26A'!$A$1:$A$18"]
["100-1D","2005-10-18",null,null,null,"Last Revision English File Path","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\",null,"Yanxiao Jia","yjia","Road2","ROADWAY DESIGN"]
["100-4A","2002-10-29",null,null,null,"Last Revision Metric File Path","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\MetricTabs\\",null,"Ryan R. Miller","rmille3","Road2","ROADWAY DESIGN"]
["100-7","2012-10-16",null,null,null,"Seed Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\ExcelTabulations.xltm",null,"Jennifer L. Hoskins","jhoskin","Road2","ROADWAY DESIGN"]
["100-10","2011-10-18",null,null,null,"VersionCheck Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\ExcelTabulations.xlsm",null,"Paul W. Flattery","pflatte","Road3","ROADWAY DESIGN"]
["100-11","2008-08-01",null,null,null,"Standard Road Plan Path","W:\\Highway\\Design\\StandardRoadPlans\\PDFsAndWebFiles\\Indexes\\SRP_EnglishIndex.xls",null,"Kelly C. Bell","kbell","Road3","ROADWAY DESIGN"]
["100-12","2008-08-01",null,null,null,"Last Revision Standard Road Plan Path","W:\\Highway\\Design\\StandardRoadPlans\\PDFsAndWebFiles\\Old_Indexes\\SRP_EnglishIndex.xls",null,"James R. Schoenrock","jschoen","Road5","ROADWAY DESIGN"]
["100-12A","2008-08-01",null,null,null,"AddIn Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\PW_Addin\\ExcelTabulations.xlam",null,"Jason M. Holst","jholst","Road5","ROADWAY DESIGN"]
["100-13","2010-04-20",null,null,null,null,null,null,"Donald G. Drake","drake","Road5","ROADWAY DESIGN"]
["100-14","2010-04-20",null,null,null,null,null,null,"Robert L. Stanley","rstanle","Soils","GEOTECHNICAL DESIGN"]
["100-15","2010-04-20",null,null,null,null,null,null,"Stephen J. Megivern","smegive","Soils","GEOTECHNICAL DESIGN"]
["100-16","2010-10-19",null,null,null,null,null,null,"David R. Claman","dclaman","Bridge","HYDRAULIC DESIGN"]
["100-17","2010-04-20"]
["100-18","2010-04-20"]
["100-20","2008-08-01"]
["100-21","2008-08-01"]
["100-22","2008-08-01"]
["100-23","2010-10-19"]
["100-24","2011-10-18"]
["100-26","2008-08-01"]
["100-27","2009-10-20"]
["100-28","2007-10-16"]
["101-4","2002-04-30"]
["101-5","2002-04-30"]
["101-6","2002-04-30"]
["101-7","2002-04-30"]
["101-8","2011-04-19"]
["102-3","2012-10-16"]
["102-4","2011-10-18"]
["102-5","2012-10-16"]
["102-5A","2008-08-01"]
["102-6C","2011-10-18"]
["102-10","2008-08-01"]
["102-11","2008-08-01"]
["102-12","2008-08-01"]
["103-1","2010-10-19"]
["103-3","2012-10-16"]
["103-4","2011-04-19"]
["103-5","2008-08-01"]
["103-6","2011-04-19"]
["103-7","2008-08-01"]
["104-3","2012-10-16"]
["105-1","1994-09-27"]
["105-3","2005-10-18"]
["105-4","2011-10-18"]
["106-1","2008-08-01"]
["106-2","2008-08-01"]
["106-3","2008-08-01"]
["106-4","2008-08-01"]
["106-5","2008-08-01"]
["106-7","2008-08-01"]
["106-8","2011-04-19"]
["108-1","2008-08-01"]
["108-2","2008-08-01"]
["108-2A","2008-08-01"]
["108-8A","2010-10-19"]
["108-8B","2011-10-18"]
["108-8C","2011-10-18"]
["108-8D","2010-10-19"]
["108-9A","2010-04-20"]
["108-11A","2008-08-01"]
["108-12","2008-08-01"]
["108-13A","2008-08-01"]
["108-15","2008-08-01"]
["108-16","2010-10-19"]
["108-18","2011-10-18"]
["108-18B","2012-10-16"]
["108-22","2012-10-16"]
["108-23A","2008-08-01"]
["108-24","2011-04-19"]
["108-26A","2008-08-01"]
["108-27","2012-10-16"]
["108-28","2008-08-01"]
["108-29","2012-10-16"]
["108-30","2012-10-16"]
["110-1","2012-10-16"]
["110-2","2008-08-01"]
["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","2011-04-19"]
["110-13","2010-04-20"]
["110-14","2012-10-16"]
["110-15","2012-10-16"]
["111-1","2012-04-17"]
["111-2","1989-02-28"]
["112-3","2008-08-01"]
["113-1","2012-04-17"]
["113-2","2011-10-18"]
["113-3","2011-10-18"]
["0","00:00:00"]
["0","00:00:00"]
["203-3","--"]
["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"]
["0","00:00:00"]
["232-6","2011-10-18"]
["232-7","2012-10-16"]
["232-8","--"]
["232-9","2011-10-18"]
["232-10","--"]
["232-11","2012-10-16"]
["0","00:00:00"]
["0","00:00:00"]
["0","00:00:00"]
["271-1","2011-10-18"]
["271-2","1985-08-20"]
["271-4","2011-10-18"]
["271-9","1994-09-27"]