{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ProjectInformation","DE108_29","PrintSheetTemplate","Note1","BridgeBlock","Index"],"not_rendered":{"charts":0,"images":25,"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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[9,0,9,1],[3,0,4,0]]}
["CPN DATA"]
["INFORMATION ADDED BY DESIGNER"]
["Section Engineer","Abrams"]
["Design Team","Haugh"]
[null,"Sorenson"]
["County","Statewide"]
["Project Number","HSIPX--000-T(3)--3L-00"]
["English or Metric","ENGLISH"]
["Revised"]
["Bridge Block"]
["File No."]

{"sheet":"DE108_29","index":1,"n_rows":283,"n_cols":57,"rows_kept":283,"cut":false,"hidden":false,"merged":[[19,53,22,53],[19,54,22,54],[19,55,22,55],[19,56,23,56],[20,3,23,3],[20,4,23,4],[20,31,23,31],[20,32,23,32],[19,47,22,47],[19,48,22,48],[19,49,22,49],[19,50,22,50],[19,51,22,51],[19,52,22,52],[19,41,22,41],[19,42,22,42],[19,43,22,43],[19,44,22,44],[19,45,22,45],[19,46,22,46],[19,35,22,35],[19,36,22,36],[19,37,22,37],[19,38,22,38],[19,39,22,39],[19,40,22,40],[19,16,22,16],[19,17,22,17],[19,18,22,18],[19,19,22,19],[19,34,22,34],[19,21,22,21],[19,22,22,22],[19,23,22,23],[19,24,22,24],[19,25,22,25],[19,26,22,26],[19,27,22,27],[19,28,23,28],[19,30,23,30],[19,31,19,32],[19,33,22,33],[19,11,22,11],[19,12,22,12],[19,13,22,13],[19,14,22,14],[19,15,22,15],[19,8,22,8],[14,30,14,56],[15,2,16,28],[15,30,15,56],[16,30,17,56],[17,2,17,28],[18,2,18,28],[18,30,18,56],[19,2,23,2],[19,3,19,4],[19,5,22,5],[19,6,22,6],[19,7,22,7],[19,20,22,20],[19,9,22,9],[19,10,22,10]]}
["TabTitle",{"$f":"C16","v":"PAVEMENT MARKING SYMBOLS AND LEGENDS"}]
["Number of Tab Columns",27]
["DE Starter Row Number",25]
["TabSheet Starter Row Number",11]
["TabSheet Header Row Count",10]
["Top Header Cell","AE15"]
["Bottom Header Cell","BE24"]
["DESheet Row Count",112]
["Fixed Empty Rows",0]
["Usable Empty Rows",5]
["Total Rows Placed",117,"xlLeft(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlLeft(1)",null,{"$f":"C11","v":"xlLeft(1)"},"xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)",{"$f":"G11","v":"xlRight(1)"},{"$f":"K11","v":"xlRight(1)"},"xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)",{"$f":"X11","v":"xlRight(1)"},"xlRight(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlLeft(1)"]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":117},"General","#+00.00","General",0,"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","General",null,"General","#+00.00","General",0,"0","0","0","0","0","0","0","0",{"$f":"G12","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0","0","General"]
["Last Tab DE Starter Row",84,{"$f":"CELL(\"width\", C13)","v":21},16,5,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,33,null,{"$f":"CELL(\"width\", AE13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Last Tab Tabsheet Starter Row",80,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA",null,{"$f":"LOWER(C14)","v":"a"},"b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z","aa"]
["Last Copy Starter Row",70,null,null,"Totals:",{"$f":"SUBTOTAL(9,F25:F641)","v":0},0,0,0,0,0,0,667,0,0,0,0,0,0,0,0,0,0,0,0,0,0,347,null,null,"108-29"]
["Tab Loop Number",3,"PAVEMENT MARKING SYMBOLS AND LEGENDS",null,null,null,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":"B17","v":"2015-04-21"}]
["Revision Date","2015-04-21",null,null,null,null,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":"$C$16","v":"PAVEMENT MARKING SYMBOLS AND LEGENDS"}]
["Tabulation Width",4,"Refer to PM-111"]
["Horizontal Grid Lines","Yes",{"$f":"\"This Data Entry Sheet fills Tab \"&AE15&\" effective \"&TEXT(B17,\"mm-dd-yy\")","v":"This Data Entry Sheet fills Tab 108-29 effective 04-21-15"},null,null,null,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":"C18","v":"Refer to PM-111"}]
[null,null,"Road\nIdentification","Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groove Cuts","Remarks",null,{"$f":"C20","v":"Road\nIdentification"},{"$f":"D20","v":"Location"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB20","v":"Groove Cuts"},{"$f":"$AC$20","v":"Remarks"}]
[null,null,null,"Station","Side",null,null,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":"D21","v":"Station"},{"$f":"E21","v":"Side"}]
[]
[]
[null,null,null,null,null,"STAW","RTAW","LTAW","CSRW","CSLW","CSTW","CRLW","FERW","LLRW","RLRW","RRCW","BLSW","WCSW","WPSB","SCLW","XNGW","STPW","AHDW","ONLW","BIKW","LANW","XITW","EACH",null,null,null,null,null,{"$f":"F24","v":"STAW"},"RTAW","LTAW","CSRW","CSLW","CSTW","CRLW","FERW","LLRW","RLRW","RRCW","BLSW","WCSW","WPSB","SCLW","XNGW","STPW","AHDW","ONLW","BIKW","LANW","XITW","EACH"]
[null,null,"I80 Exit 75",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.1"]
[null,null,"I80 Exit 88",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.2"]
[null,null,"I80 Exit 100",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.3"]
[null,null,"I80 Exit 118",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.4"]
[null,null,"I80 Exit 125",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.5"]
[null,null,"I80 Exit 129",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.6"]
[null,null,"I80 Exit 131",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.7"]
[null,null,"I80 Exit 135",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.8"]
[null,null,"I80 Exit 136",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.9"]
[null,null,"I80 Exit 164",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.10"]
[null,null,"I80 Exit 201",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.11"]
[null,null,"I80 Exit 230",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.12"]
[null,null,"I80 Exit 240",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.13"]
[null,null,"I80 Exit 242",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.14"]
[null,null,"I80 Exit 267",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.15"]
[]
[null,null,"I380 Exit 17",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.16"]
[null,null,"I380 Exit 18",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.17"]
[null,null,"I380 Exit 19B",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.18"]
[null,null,"I380 Exit 20A",null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"N.19"]
[null,null,"I380 Exit 20B",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.20"]
[null,null,"I380 Exit 22",null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"N.21"]
[null,null,"I380 Exit 24",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.22"]
[]
[null,null,"I35 Exit 33",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.23"]
[null,null,"I35 Exit 34",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.24"]
[null,null,"I35 Exit 56",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.25"]
[null,null,"I35 Exit 69",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.26"]
[null,null,"I35 Exit 70",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.27"]
[null,null,"I35 Exit 89",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.28"]
[null,null,"I35 Exit 90",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.29"]
[]
[null,null,"I235 Exit 3",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.30"]
[null,null,"I235 Exit 7",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.31"]
[null,null,"I235 Exit 8A",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.32"]
[null,null,"I235 Exit 9",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.33"]
[]
[null,null,"I280 Exit 1",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.34"]
[]
[null,null,"I29 Exit 56",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.35"]
[null,null,"I29 Exit 112",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.36"]
[null,null,"I29 Exit 134",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.37"]
[null,null,"I29 Exit 143",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.38"]
[]
[null,null,"US20 Exit 227",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.39"]
[null,null,"US20 Exit 282",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.40"]
[null,null,"US20 Exit 285",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.41"]
[null,null,"US20 Exit 292",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.42"]
[null,null,"US20 Exit 294",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.43"]
[null,null,"US20 & Bryant St",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.44"]
[]
[null,null,"US151 Exit 49",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.45"]
[]
[null,null,"US218 Exit 19",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.46"]
[null,null,"US218 Exit 66",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.47"]
[null,null,"US218 Exit 89",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.48"]
[null,null,"US218 Exit 181",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.49"]
[null,null,"US218 Exit 195",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.50"]
[]
[null,null,"US34 Exit 8",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.51"]
[null,null,"US34 Exit 255",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.52"]
[null,null,"US34 Exit 259",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.53"]
[null,null,"US34 Exit 260",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.54"]
[null,null,"US34 Exit 263",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.55"]
[]
[null,null,"US61 Exit 47",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.56"]
[null,null,"US61 Exit 156",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.57"]
[]
[null,null,"US65 Exit 77",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.58"]
[null,null,"US65 Exit 83",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.59"]
[]
[null,null,"IA163 Exit 18",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.60"]
[null,null,"IA163 Exit 40",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.61"]
[]
[null,null,"IA5 Exit 64",null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"N.62"]
[null,null,"IA5 Exit 64",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.63"]
[]
[null,null,"IA100 Exit 7",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.64"]
[]
[null,null,"IA141 Exit 148",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.65"]
[]
[null,null,"US30 Exit 142",null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"N.66"]
[null,null,"US30 Exit 148",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.67"]
[null,null,"US30 Exit 150",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.68"]
[null,null,"US30 Exit 158",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.69"]
[null,null,"US30 Exit 179",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.70"]
[null,null,"US30 Exit 202",null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"N.71"]
[null,null,"US30 Exit 250",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.72"]
[null,null,"US30 Exit 252A",null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"N.73"]
[null,null,"US30 Exit 253",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.74"]
[null,null,"US30 Exit 254A",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.75"]
[]
[null,null,"IA163 & 60th St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.76"]
[null,null,"IA163 & 64th St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.77"]
[null,null,"IA163 & 70th St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.78"]
[null,null,"IA163 & 75th St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.79"]
[null,null,"IA163 & 80th St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.80"]
[]
[null,null,"US30 & Story St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.81"]
[null,null,"US30 & Linn St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.82"]
[null,null,"US30 & Corporal Roger Snedden Dr",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.83"]
[null,null,"US30 & Marshall St",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.84"]
[null,null,"US30 & U Ave",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.85"]
[null,null,"US30 & W Ave",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.86"]
[null,null,"US30 & 600th Ave",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.89"]
[null,null,"US30 & 18th St",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"N.90"]
[null,null,"US30 & S14",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.91"]
[null,null,"US30 & S27",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.92"]
[null,null,"US30 & 32nd Ave",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.93"]
[null,null,"US30 & IA279",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"N.94"]
[]
[null,null,"US63 N of Exit 205",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"N.95"]
[]
[]
[]
[null,null,"Start of Change Order #2"]
[]
[null,null,"All Distances Measured from STOP Bar to tip of Wrong Way Arrow"]
[]
[]
[null,null,"I-235 and 31st St","290'","EB","CO.101",null,null,null,null,null,null,2]
[null,null,"I-235 and 31st St","280'","WB","CO.101",null,null,null,null,null,null,2]
[]
[null,null,"I-280 & Locust St","300'","NB","CO.105",null,null,null,null,null,null,1]
[null,null,"I-280 & Locust St","290'","SB","CO.105",null,null,null,null,null,null,1]
[]
[null,null,"I-29 and Wesley Parkway","350'","NB","CO.91","In CADD",null,null,null,null,null,3]
[null,null,"I-29 and Wesley Parkway","350'","SB","CO.91","In CADD",null,null,null,null,null,3]
[]
[null,null,"I-35 & Hwy 210","250'","NB","CO.118",null,null,null,null,null,null,1]
[null,null,"I-35 & Hwy 210","250'","SB","CO.118",null,null,null,null,null,null,1]
[]
[null,null,"I-380 & 29th St","350'","NB","CO.77","In CADD",null,null,null,null,null,2]
[null,null,"I-380 & 42nd St","350'","NB","CO.79","In CADD",null,null,null,null,null,1]
[null,null,"I-380 & Boyson Rd","365'","NB","CO.80","In CADD",null,null,null,null,null,1]
[null,null,"I-380 & Boyson Rd","350'","SB","CO.80","In CADD",null,null,null,null,null,1]
[null,null,"I-380 & County Home Road","350'","NB","CO.108",null,null,null,null,null,null,1]
[null,null,"I-380 & County Home Road","375'","SB","CO.108",null,null,null,null,null,null,1]
[null,null,"I-380 & Diagonal Dr","265'","NB","CO.78","In CADD",null,null,null,null,null,2]
[null,null,"I-380 & Penn Ave","300'","NB","CO.94","In CADD",null,null,null,null,null,1]
[null,null,"I-380 & Penn Ave","350'","SB","CO.94","In CADD",null,null,null,null,null,1]
[null,null,"I-380 and 330th St","265'","NB","CO.90",null,null,null,null,null,null,1]
[null,null,"I-380 and 330th St","325'","SB","CO.90",null,null,null,null,null,null,1]
[null,null,"I-380 and Ia 100","530'","NB","CO.117",null,null,null,null,null,null,2]
[null,null,"I-380 and Ia 100","350'","SB","CO.117",null,null,null,null,null,null,1]
[null,null,"I-380 SE Ramp & IA-150","200'","NB","CO.111",null,null,null,null,null,null,1]
[null,null,"I-380 SE Ramp & IA-150","260'","SB","CO.111",null,null,null,null,null,null,1]
[]
[null,null,"I-74 & 53rd St","550'","NB","CO.114",null,null,null,null,null,null,2]
[null,null,"I-74 & 53rd St","615'","SB","CO.114",null,null,null,null,null,null,1]
[null,null,"I-74 & Middle Rd","380'","NB","CO.113",null,null,null,null,null,null,2]
[null,null,"I-74 & Middle Rd","250'","SB","CO.113",null,null,null,null,null,null,1]
[null,null,"I-74 & US-6/Spruce Hills Dr","n/a","NB","CO.103",null,null,null,null,null,null,0]
[null,null,"I-74 & US-6/Spruce Hills Dr","280'","SB","CO.103",null,null,null,null,null,null,1]
[]
[null,null,"I-80 & 24th St","600'","EB","CO.102",null,null,null,null,null,null,2]
[null,null,"I-80 & 24th St","425'","WB","CO.102",null,null,null,null,null,null,1]
[null,null,"I-80 & Ia 1","565'","EB","CO.120",null,null,null,null,null,null,1]
[null,null,"I-80 & Ia 1","560'","WB","CO.120",null,null,null,null,null,null,1]
[null,null,"I-80 & Ia 415/2nd Ave","400'","EB","CO.99",null,null,null,null,null,null,1]
[null,null,"I-80 & Ia 415/2nd Ave","700'","WB","CO.99",null,null,null,null,null,null,1]
[null,null,"I-80 & Madison","350'","EB","CO.95","In CADD",null,null,null,null,null,2]
[null,null,"I-80 & Madison","365'","WB","CO.95","In CADD",null,null,null,null,null,1]
[null,null,"I-80 & Hubbell","750'","EB","CO.81","In CADD",null,null,null,null,null,2]
[null,null,"I-80 & Hubbell","565'","WB","CO.81","In CADD",null,null,null,null,null,1]
[null,null,"I-80 and Ia 173","350'","EB","CO.88","In CADD",null,null,null,null,null,1]
[null,null,"I-80 and Ia 173","365'","WB","CO.88","In CADD",null,null,null,null,null,1]
[]
[null,null,"I-880 & CR L-34","1@180' 2 @400'","N","CO.86","In CADD",null,null,null,null,null,3]
[null,null,"I-880 & CR L-34","1@180' 2 @400'","S","CO.86","In CADD",null,null,null,null,null,3]
[]
[null,null,"Ia 27 & US-218","350'","NB","CO.82","In CADD",null,null,null,null,null,1]
[null,null,"Ia 27 & US-218","1@275' 2 @550'","W","CO.82","In CADD",null,null,null,null,null,3]
[]
[null,null,"Ia 60 & 190th St","U.A.C.","NB","CO.128",null,null,null,null,null,null,0]
[null,null,"Ia 60 & 190th St","U.A.C.","SB","CO.128",null,null,null,null,null,null,0]
[null,null,"Ia 60 & 230th St","U.A.C.","NB","CO.131",null,null,null,null,null,null,0]
[null,null,"Ia 60 & 230th St","U.A.C.","SB","CO.131",null,null,null,null,null,null,0]
[null,null,"Ia 60 & 2nd Ave","310'","NB","CO.96",null,null,null,null,null,null,1]
[null,null,"Ia 60 & 2nd Ave","270'","SB","CO.96",null,null,null,null,null,null,1]
[null,null,"Ia 60 & 470th","Opposite exist","NB","CO.98",null,null,null,null,null,null,1]
[null,null,"Ia 60 & 470th","Opposite exist","SB","CO.98",null,null,null,null,null,null,1]
[null,null,"Ia 60 & A22","Complex See Diagram",null,"CO.92",null,null,null,null,null,null,2]
[null,null,"Ia 60 & A22","Opposite exist","W","CO.92",null,null,null,null,null,null,2]
[null,null,"Ia 60 & A34","U.A.C.","Both","CO.130",null,null,null,null,null,null,0]
[null,null,"Ia 60 & A52","U.A.C.","Both","CO.133",null,null,null,null,null,null,0]
[null,null,"Ia 60 & B14","U.A.C.","Both","CO.135",null,null,null,null,null,null,0]
[null,null,"Ia 60 & B40","U.A.C.","Both","CO.137",null,null,null,null,null,null,0]
[null,null,"Ia 60 & C12","U.A.C.","Both","CO.142",null,null,null,null,null,null,0]
[null,null,"Ia 60 & C16","U.A.C.","Both","CO.143",null,null,null,null,null,null,0]
[null,null,"Ia 60 & C38","135'","NB","CO.145",null,null,null,null,null,null,2]
[null,null,"Ia 60 & C38","135'","SB","CO.145",null,null,null,null,null,null,2]
[null,null,"Ia 60 & Hospers Dr N.","U.A.C.","Both","CO.136",null,null,null,null,null,null,0]
[null,null,"Ia 60 & Hospers Dr S.","U.A.C.","Both","CO.139",null,null,null,null,null,null,0]
[null,null,"Ia 60 & Ia 9","315'","NB","CO.127",null,null,null,null,null,null,1]
[null,null,"Ia 60 & Ia 9","320'","SB","CO.127",null,null,null,null,null,null,1]
[null,null,"Ia 60 & K64/Jackson Ave","U.A.C.","Both","CO.141",null,null,null,null,null,null,0]
[null,null,"Ia 60 & L14","U.A.C.","Both","CO.140",null,null,null,null,null,null,0]
[null,null,"Ia 60 & L36/Olive Ave","U.A.C.","Both","CO.129",null,null,null,null,null,null,0]
[null,null,"Ia 60 & L36/Oak Hill Ave","U.A.C.","Both","CO.132",null,null,null,null,null,null,0]
[null,null,"Ia 60 & Log Ave","U.A.C.","Both","CO.138",null,null,null,null,null,null,0]
[null,null,"Ia 60 & Marble Ave","U.A.C.","Both","CO.144",null,null,null,null,null,null,0]
[null,null,"Ia 60 & Northwest Blvd","U.A.C.","Both","CO.134",null,null,null,null,null,null,0]
[null,null,"Ia 60 & Opal / 2nd Ave","Complex See Diagram",null,"CO.126",null,null,null,null,null,null,2]
[null,null,"Ia 60 & Opal / 2nd Ave","Complex See Diagram",null,"CO.126",null,null,null,null,null,null,2]
[null,null,"Ia 60 & US 18","250'","NB","CO.112",null,null,null,null,null,null,1]
[null,null,"Ia 60 & US 18","275'","SB","CO.112",null,null,null,null,null,null,1]
[null,null,"Ia 60 & US 75","275'","NB","CO.123",null,null,null,null,null,null,1]
[null,null,"Ia 60 & US 75","300'","SB","CO.123",null,null,null,null,null,null,1]
[null,null,"Ia 60 & W Ramp & 450th St","265'","NB","CO.124",null,null,null,null,null,null,1]
[null,null,"Ia 60 & W Ramp & 450th St","260'","SB","CO.124",null,null,null,null,null,null,1]
[null,null,"Ia 60 NW Ramp & Nest Ave","300'","NB","CO.125",null,null,null,null,null,null,1]
[null,null,"Ia 60 NW Ramp & Nest Ave","325'","SB","CO.125",null,null,null,null,null,null,1]
[]
[null,null,"US 151 & Ia 38","630'","NB","CO.110",null,null,null,null,null,null,1]
[null,null,"US 151 & Ia 38","310'","SB","CO.110",null,null,null,null,null,null,1]
[]
[null,null,"US 169 & 2nd Ave","300'","NB","CO.85",null,null,null,null,null,null,1]
[null,null,"US 169 & 2nd Ave","235'","SB","CO.85",null,null,null,null,null,null,1]
[]
[null,null,"US 20 & Lakeport St","400'","EB","CO.106",null,null,null,null,null,null,2]
[null,null,"US 20 & Lakeport St","300'","WB","CO.106",null,null,null,null,null,null,2]
[null,null,"US 20 & Quail Ave / Nelson Ave","Complex See Diagram",null,"CO.93",null,null,null,null,null,null,3]
[null,null,"US 20 & Quail Ave / Nelson Ave","315'","WB","CO.93",null,null,null,null,null,null,1]
[null,null,"US 20 & Xirus Ave","300'","EB","CO.116",null,null,null,null,null,null,1]
[null,null,"US 20 & Xirus Ave","320'","WB","CO.116",null,null,null,null,null,null,1]
[null,null,"US 20 and Jefferson Rd","1@220' 2 @440'","N","CO.84","In CADD",null,null,null,null,null,3]
[null,null,"US 20 and Jefferson Rd","1@170' 2 @375'","S","CO.84","In CADD",null,null,null,null,null,3]
[]
[null,null,"US 218 & Ia 14","1@200' 2 @450'","E","CO.87","In CADD",null,null,null,null,null,3]
[null,null,"US 218 & Ia 14","1@190' 2 @380'","W","CO.87","In CADD",null,null,null,null,null,3]
[]
[null,null,"US 30 & 6th Ave","370'","EB","CO.107",null,null,null,null,null,null,1]
[null,null,"US 30 & 6th Ave","280'","WB","CO.107",null,null,null,null,null,null,1]
[null,null,"US 30 & BUS-30/Lincoln Hwy","Complex See Diagram",null,"CO.83","In CADD",null,null,null,null,null,5]
[null,null,"US 30 & US 169","Complex See Diagram",null,"CO.109",null,null,null,null,null,null,2]
[null,null,"US 30 & US 169","Complex See Diagram",null,"CO.109",null,null,null,null,null,null,2]
[null,null,"US 30 and Ia 17","350'","EB","CO.89","In CADD",null,null,null,null,null,1]
[null,null,"US 30 and Ia 17","310'","WB","CO.89","In CADD",null,null,null,null,null,1]
[]
[null,null,"US 34 & 235th St","Complex See Diagram",null,"CO.119",null,null,null,null,null,null,2]
[null,null,"US 34 & 235th St","265'","E","CO.119",null,null,null,null,null,null,1]
[null,null,"US 34 & Grand Ave/Jewel Ave","Complex See Diagram",null,"CO.76","In CADD",null,null,null,null,null,7]
[null,null,"US 34 & US 71","Complex See Diagram",null,"CO.100",null,null,null,null,null,null,3]
[null,null,"US 34 & US 71","Complex See Diagram",null,"CO.100",null,null,null,null,null,null,2]
[]
[null,null,"US 63 & 145th Ave","Complex See Diagram",null,"CO.104",null,null,null,null,null,null,2]
[null,null,"US 63 & 145th Ave","Complex See Diagram",null,"CO.104",null,null,null,null,null,null,2]
[null,null,"US 63 and Ia 346","430'","SB","CO.115","In CADD",null,null,null,null,null,1]
[null,null,"US 63 and Ia 346","1@210' 2 @420'","E","CO.115","In CADD",null,null,null,null,null,3]
[null,null,"US 63 N Ramp & La Salle Ave","330'","N","CO.97",null,null,null,null,null,null,1]
[null,null,"US 63 N Ramp & La Salle Ave","Complex See Diagram",null,"CO.97",null,null,null,null,null,null,3]
[]
[null,null,"US 75 & 200th St","275'","NB","CO.121",null,null,null,null,null,null,1]
[null,null,"US 75 & 200th St","300'","SB","CO.121",null,null,null,null,null,null,1]
[null,null,"US 75 & IA-3 ","255'","NB","CO.122",null,null,null,null,null,null,1]
[null,null,"US 75 & IA-3 ","270'","SB","CO.122",null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M145:M281)","v":160}]

{"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$11<>\"\",ProjectInformation!$B$11,\"\")","v":""},null,null,null,null,null,null,{"$f":"UPPER(ProjectInformation!$B$8)","v":"ENGLISH"},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":"Abrams\\Haugh\\Sorenson"},null,null,null,null,null,null,null,null,null,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":"Statewide"},null,null,null,null,null,null,null,null,null,null,null,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":"HSIPX--000-T(3)--3L-00"},null,null,null,null,null,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$9<>\"\",ProjectInformation!$B$9,\"\")","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":"Index","index":5,"n_rows":164,"n_cols":17,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
["100-0A","1997-10-28","4.5.6","ADAIR",null,"Live English File Path","W:\\Highway\\Design\\RoadDesignDetails\\ExcelTabs\\",null,"Stuart S. Nielsen","snielse","Methods","ROADWAY DESIGN",null,"100_1A(1)","='100_1A'!$A$1:$F$30",null,"A_DE111Series.xlsm"]
["100-1A","1997-07-15","10/17/19","ADAMS",null,"Live Metric File Path","W:\\Highway\\Design\\RoadDesignDetails\\ExcelTabs\\MetricTabs\\",null,"Khyle B. Clute","kclute","Methods","ROADWAY DESIGN",null,"100_4A(1)","='100_4A'!$A$1:$C$59",null,"C_DE100Series.xlsm"]
["100-1C","2012-04-17","C","ALLAMAKEE",null,"Index File Path","W:\\Highway\\Design\\RoadDesignDetails\\PDFsandWebFiles\\Indexes\\",null,"Thomas M. Hamski","thamski","Methods","ROADWAY DESIGN",null,"100_4A(2)","='100_4A'!$A$60:$C$100",null,"C_DE102Series.xlsm"]
["100-1D","2005-10-18",null,"APPANOOSE",null,"Index File Name","TNT_EnglishIndexes.xlsx",null,"Wesley L. Mayberry","wmayber","Methods","ROADWAY DESIGN",null,"105_4(1)","='105_4'!$A$1:$C$25",null,"C_DE103Series.xlsm"]
["100-4A","2002-10-29",null,"AUDUBON",null,"Last Revision English File Path","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\",null,"John M. Narigon","jnarigo","Methods","ROADWAY DESIGN",null,"108_22(1)","='108_22'!$A$1:$X$20",null,"C_DE104Series.xlsm"]
["100-7","2012-10-16",null,"BENTON",null,"Last Revision Metric File Path","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\MetricTabs\\",null,"Christopher Poole","cpoole","Methods","ROADWAY DESIGN",null,"108_29(1)","='108_29'!$A$1:$AA$69",null,"C_DE105Series.xlsm"]
["100-10","2011-10-18",null,"BLACK HAWK",null,"Seed Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\ExcelTabulations.xltm",null,"Daniel J. Harness","dharnes","Methods","ROADWAY DESIGN",null,"108_29(2)","='108_29'!$A$70:$AA$137",null,"C_DE106Series.xlsm"]
["100-11","2008-08-01",null,"BOONE",null,"VersionCheck Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\ExcelTabulations.xlsm",null,"Jason M. Holst","jholst","Road1","ROADWAY DESIGN",null,"190_66(1)","='190_66'!$A$1:$D$20",null,"C_DE107Series.xlsm"]
["100-12","2008-08-01",null,"BREMER",null,"Standard Road Plan Path","W:\\Highway\\Design\\StandardRoadPlans\\PDFsAndWebFiles\\Indexes\\SRP_EnglishIndex.xls",null,"Jason R. Strum","jstrum","Road1","ROADWAY DESIGN",null,"190_65(1)","='190_65'!$A$1:$B$20",null,"C_DE108Series.xlsm"]
["100-12A","2008-08-01",null,"BUCHANAN",null,"Last Revision Standard Road Plan Path","W:\\Highway\\Design\\StandardRoadPlans\\PDFsAndWebFiles\\Old_Indexes\\SRP_EnglishIndex.xls",null,"Robert A. Schoenrock","rschoen","Road1","ROADWAY DESIGN",null,"190_51(1)","='190_51'!$A$1:$Z$90",null,"C_DE110Series.xlsm"]
["100-13","2010-04-20",null,"BUENA VISTA",null,"AddIn Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\ExcelTabulations.xlam",null,"Stacy M. Ryan","sryan","Road1","ROADWAY DESIGN",null,"190_51(2)","='190_51'!$A$91:$Z$180",null,"C_DE111Series.xlsm"]
["100-14","2010-04-20",null,"BUTLER",null,"Old Files Path","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\",null,"Jonathan W. Bahr","jbahr","Road1","ROADWAY DESIGN",null,"190_51(3)","='190_51'!$A$181:$Z$270",null,"C_DE112Series.xlsm"]
["100-15","2010-04-20",null,"CALHOUN",null,null,null,null,"Yanxiao Jia","yjia","Road2","ROADWAY DESIGN",null,"190_51(4)","='190_51'!$A$271:$Z$360",null,"C_DE113Series.xlsm"]
["100-16","2010-10-19",null,"CARROLL",null,null,null,null,"Ryan R. Miller","rmille3","Road2","ROADWAY DESIGN",null,"190_51(5)","='190_51'!$A$361:$Z$450",null,"C_DE190Series.xlsm"]
["100-17","2010-04-20",null,"CASS",null,null,null,null,"Dustin T. Skogerboe","dskoge2","Road2","ROADWAY DESIGN",null,"190_51(6)","='190_51'!$A$451:$Z$540",null,"C_DE192Series.xlsm"]
["100-18","2010-04-20",null,"CEDAR",null,null,null,null,"Dung T. Ta","dta","Road2","ROADWAY DESIGN",null,"190_51(7)","='190_51'!$A$541:$Z$630",null,"C_DE231Series.xlsm"]
["100-19","2012-10-16",null,"CERRO GORDO",null,null,null,null,"Allison L. P. Smyth","asmyth","Road2","ROADWAY DESIGN",null,"190_51(8)","='190_51'!$A$631:$Z$720",null,"C_DE232Series.xlsm"]
["100-20","2008-08-01",null,"CHEROKEE",null,null,null,null,"Paul W. Flattery","pflatte","Road3","ROADWAY DESIGN",null,"190_51(9)","='190_51'!$A$721:$Z$810",null,"C_DE252Series.xlsm"]
["100-21","2008-08-01",null,"CHICKASAW",null,null,null,null,"Kelly C. Bell","kbell","Road3","ROADWAY DESIGN",null,"190_51(10)","='190_51'!$A$811:$Z$900",null,"C_DE253Series.xlsm"]
["100-22","2008-08-01",null,"CLARKE",null,null,null,null,"Angela K. Johnson","ajohns1","Road3","ROADWAY DESIGN",null,"190_51(11)","='190_51'!$A$901:$Z$990",null,"C_DE254Series.xlsm"]
["100-23","2010-10-19",null,"CLAY",null,null,null,null,"Elijah D. Gansen","egansen","Road3","ROADWAY DESIGN",null,"190_51(12)","='190_51'!$A$991:$Z$1080",null,"C_DE259Series.xlsm"]
["100-24","2013-04-16",null,"CLAYTON",null,null,null,null,"James R. Schoenrock","jschoen","Consultant","ROADWAY DESIGN",null,"190_51(13)","='190_51'!$A$1081:$Z$1170",null,"C_DE262Series.xlsm"]
["100-26","2008-08-01",null,"CLINTON",null,null,null,null,"Randall E. Schlei","rschlie","Consultant","ROADWAY DESIGN",null,"190_51(14)","='190_51'!$A$1171:$Z$1260",null,"C_DE271Series.xlsm"]
["100-27","2009-10-20",null,"CRAWFORD",null,null,null,null,"Seana K. Godbold","sgodbol","Roadside","LANDSCAPE DESIGN",null,"190_51(15)","='190_51'!$A$1261:$Z$1350",null,"C_DE281Series.xlsm"]
["100-28","2010-10-19",null,"DALLAS",null,null,null,null,"Robert L. Stanley","rstanle","Soils","GEOTECHNICAL DESIGN",null,"190_51(16)","='190_51'!$A$1351:$Z$1440",null,"C_DE282Series.xlsm"]
["101-4","2002-04-30",null,"DAVIS",null,null,null,null,"Stephen J. Megivern","smegive","Soils","GEOTECHNICAL DESIGN",null,"190_51(17)","='190_51'!$A$1441:$Z$1530",null,"C_DE290Series.xlsm"]
["101-5","2002-04-30",null,"DECATUR",null,null,null,null,"Mark A. Dell","mdell","Soils","GEOTECHNICAL DESIGN",null,"190_51(18)","='190_51'!$A$1531:$Z$1620",null,"G_DE101Series.xlsm"]
["101-6","2002-04-30",null,"DELAWARE",null,null,null,null,"David R. Claman","dclaman","Bridge","HYDRAULIC DESIGN",null,"190_51(19)","='190_51'!$A$1621:$Z$1694",null,"J_DE108Series.xlsm"]
["101-7","2002-04-30",null,"DES MOINES",null,null,null,null,"Zachary K. Abrams","zabrams","TrafficAndSafety","ROADWAY DESIGN",null,"190_62(1)","='190_62'!$A$1:$K$90",null,"J_DE111Series.xlsm"]
["101-8","2013-04-16",null,"DICKINSON",null,null,null,null,"Engineer of Record","Khocket","Methods","ROADWAY DESIGN",null,"190_62(2)","='190_62'!$A$91:$K$180",null,"J_DE113Series.xlsm"]
["101-13","2004-04-20",null,"DUBUQUE",null,null,null,null,"William L. Kaufman","wkaufma","Bridge","HYDRAULIC DESIGN",null,"190_62(3)","='190_62'!$A$181:$K$270",null,"S_DE113Series.xlsm"]
["101-16","2009-10-20",null,"EMMET",null,null,null,null,"David J. Heer","dheer","Soils","GEOTECHNICAL DESIGN",null,"190_62(4)","='190_62'!$A$271:$K$360",null,"R_DE100Series.xlsm"]
["101-17","2011-04-19",null,"FAYETTE",null,null,null,null,null,null,null,null,null,"190_62(5)","='190_62'!$A$361:$K$450",null,"R_DE105Series.xlsm"]
["101-18","2011-04-19",null,"FLOYD",null,null,null,null,null,null,null,null,null,"190_62(6)","='190_62'!$A$451:$K$540",null,"R_DE110Series.xlsm"]
["102-3","2013-04-16",null,"FRANKLIN",null,null,null,null,null,null,null,null,null,"190_62(7)","='190_62'!$A$541:$K$630",null,"R_DE111Series.xlsm"]
["102-4","2011-10-18",null,"FREMONT",null,null,null,null,null,null,null,null,null,"190_62(8)","='190_62'!$A$631:$K$720",null,"R_DE231Series.xlsm"]
["102-5","2012-10-16",null,"GREENE",null,null,null,null,null,null,null,null,null,"190_62(9)","='190_62'!$A$721:$K$810",null,"R_DE232Series.xlsm"]
["102-5A","2008-08-01",null,"GRUNDY",null,null,null,null,null,null,null,null,null,"190_62(10)","='190_62'!$A$811:$K$900",null,"R_DE262Series.xlsm"]
["102-6C","2011-10-18",null,"GUTHRIE",null,null,null,null,null,null,null,null,null,"190_62(11)","='190_62'!$A$901:$K$977",null,"R_DE281Series.xlsm"]
["102-10","2008-08-01",null,"HAMILTON",null,null,null,null,null,null,null,null,null,"259_01(1)","='259_01'!$A$1:$A$90",null,"R_DE282Series.xlsm"]
["102-11","2008-08-01",null,"HANCOCK",null,null,null,null,null,null,null,null,null,"259_01(2)","='259_01'!$A$91:$A$180"]
["102-12","2008-08-01",null,"HARDIN",null,null,null,null,null,null,null,null,null,"259_01(3)","='259_01'!$A$181:$A$270"]
["102-14","2012-04-17",null,"HARRISON",null,null,null,null,null,null,null,null,null,"259_01(4)","='259_01'!$A$271:$A$326"]
["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,"LOUISA"]
["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",null,"SeriesList.xlsx"]
["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"]