{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ProjectInformation","PrintSheets","DERW_WALL","RW_WALL","PrintSheetTemplate","Note1","BridgeBlock","Index"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9,"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","Flattery"]
["Design Team","Bell"]
[]
["County","BENTON"]
["Project Number","NHXS-030-6(231)--3H-06"]
["English or Metric","ENGLISH"]
["Revised"]
["Bridge Block"]
["File No."]

{"sheet":"PrintSheets","index":1,"n_rows":95,"n_cols":179,"rows_kept":95,"cut":false,"hidden":false,"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!B8)","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":"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":"IF(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","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":"IF(ProjectInformation!$B$7<>\"\",ProjectInformation!$B$7,\"\")","v":"NHXS-030-6(231)--3H-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,"V.1",null,null,null,null,null,{"$f":"IF(FP94<>\"\",\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$9<>\"\",ProjectInformation!$B$9,\"\")","v":""}]
["","11/28/2017     11:26:22 AM     kbell     c:\\pw_work\\pwmain\\kbell\\d0797678\\06030231V01.xlsm"]

{"sheet":"DERW_WALL","index":2,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[14,2,15,2],[16,4,17,4]]}
["TabTitle",{"$f":"C15","v":"MSE RETAINING WALL CONSTRUCTION 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",49]
["Fixed Empty Rows",10]
["Usable Empty Rows",0]
["Total Rows Placed",59,"xlLeft(1)",null,{"$f":"IF(C11<>\"\",C11,\"\")","v":"xlLeft(1)"}]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":59},"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,"MSE RETAINING WALL CONSTRUCTION NOTES",null,"MSE"]
["Tab Loop Number",2,null,null,"SPECIAL"]
["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 MSE effective 08-01-08"},null,{"$f":"C15","v":"MSE RETAINING WALL CONSTRUCTION NOTES"}]
["Tabulation Width",2,"(1) The MSE Wall shall be designed for a 250 psf surcharge load to account for traffic live loads."]
["Horizontal Grid Lines","No"]
[null,null,"(2) The MSE wall shall be designed according to Iowa Department of Transportation standard specifications and AASHTO LRFD Bridge Design"]
[null,null,"    Specification."]
[]
[null,null,"(3) The MSE wall shall be designed for a minimum service life of 75 years."]
[]
[null,null,"(4) Refer to Sheet Q.18 for details on required bearing resistance."]
[]
[null,null,"(5) The parameters provided on Sheet Q.18 are based on the use of granular backfill material in the reinforced zone, the 1:1 temporary"]
[null,null,"    excavation zone and completion of the coreout detailed on Sheet Q.22."]
[]
[null,null,"(6) The minimum depth of embedment for the MSE wall is 4 feet."]
[]
[null,null,"(7) The length of the reinforcement strips (or mesh) will vary by wall station and shall be based on a minimum width to wall height ratio"]
[null,null,"    of 0.8 or 8 feet, whichever is greater."]
[]
[null,null,"(8) The MSE Wall designer shall review the bridge plans (Design No. 117) for the pile and corrugated metal pipe sleeve layout for"]
[null,null,"    incorporation into the MSE Wall design and construction."]
[]
[null,null,"(9) See Sheets X.220 through X.225 for soil types."]
[]
[null,null,"(10) The Contractor is responsible for ensuring the stability of the 1:1 temporary excavation slope.  The Contractor shall provide the"]
[null,null,"     Iowa DOT Resident Construction Engineer with supporting calculations if a slope other than 1:1 or temporary excavation support is  "]
[null,null,"     needed."]
[]
[null,null,"(11) The panels for the MSE Wall shall be cast as per the MSE Wall Details on Sheets V.2 through V.4."]
[]
[null,null,"(12) Two MSE Wall subdrains are required; one directly behind the wall panels and one at the back of the reinforced zone (see MSE Wall"]
[null,null,"     Details on Sheet V.2)."]
[]
[null,null,"(13) For estimating purposes only, the following assumptions were used:"]
[null,null,"     (a) The wall height at a given station is the distance between the top elevation of the leveling pad and the elevation of the top of"]
[null,null,"         coping of the MSE wall."]
[null,null,"     (b) The quantities of the granular backfill material and/or the excavation behind the wall were calculated based on the average end"]
[null,null,"         area between cross sections.  The average end area was computed with the estimated wall heights and reinforcement lengths.      "]
[null,null,"         These quantities may need to be adjusted if the required reinforcement length is greater than the estimated length, and/or if   "]
[null,null,"         the footing elevation is adjusted."]
[]
[null,null,"(14) The Contractor shall submit the design computations and the MSE Wall shop drawings at least 4 weeks prior to construction for"]
[null,null,"     review.  The submittal with cover letter shall be sent via email (in .PDF format) to:"]
[null,null,"          Soils Design Section"]
[null,null,"          Iowa Department of Transportation"]
[null,null,"          Attn:  Steve Megivern, P.E."]
[null,null,"          Stephen.Megivern@iowadot.us"]
[]
[null,null,"Only the submittal cover letter shall be sent via email (in .PDF format) to the applicable office(s) of the Resident Construction"]
[null,null,"Engineer (RCE) and District Materials Engineer (DME) for their information and documentation that the plans have been submitted.  The"]
[null,null,"Soils Design section will distribute final approved documents to the RCE and DME."]

{"sheet":"RW_WALL","index":3,"n_rows":63,"n_cols":1,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,0,3,0]]}
["MSE"]
["SPECIAL"]
["MSE RETAINING WALL CONSTRUCTION NOTES"]
[]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C18)-1,COLUMNS($C$18:C18)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C18)-1,COLUMNS($C$18:C18)-1),\"\")","v":"(1) The MSE Wall shall be designed for a 250 psf surcharge load to account for traffic live loads."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C19)-1,COLUMNS($C$18:C19)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C19)-1,COLUMNS($C$18:C19)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C20)-1,COLUMNS($C$18:C20)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C20)-1,COLUMNS($C$18:C20)-1),\"\")","v":"(2) The MSE wall shall be designed according to Iowa Department of Transportation standard specifications and AASHTO LRFD Bridge Design"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C21)-1,COLUMNS($C$18:C21)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C21)-1,COLUMNS($C$18:C21)-1),\"\")","v":"    Specification."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C22)-1,COLUMNS($C$18:C22)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C22)-1,COLUMNS($C$18:C22)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C23)-1,COLUMNS($C$18:C23)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C23)-1,COLUMNS($C$18:C23)-1),\"\")","v":"(3) The MSE wall shall be designed for a minimum service life of 75 years."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C24)-1,COLUMNS($C$18:C24)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C24)-1,COLUMNS($C$18:C24)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C25)-1,COLUMNS($C$18:C25)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C25)-1,COLUMNS($C$18:C25)-1),\"\")","v":"(4) Refer to Sheet Q.18 for details on required bearing resistance."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C26)-1,COLUMNS($C$18:C26)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C26)-1,COLUMNS($C$18:C26)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C27)-1,COLUMNS($C$18:C27)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C27)-1,COLUMNS($C$18:C27)-1),\"\")","v":"(5) The parameters provided on Sheet Q.18 are based on the use of granular backfill material in the reinforced zone, the 1:1 temporary"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C28)-1,COLUMNS($C$18:C28)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C28)-1,COLUMNS($C$18:C28)-1),\"\")","v":"    excavation zone and completion of the coreout detailed on Sheet Q.22."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C29)-1,COLUMNS($C$18:C29)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C29)-1,COLUMNS($C$18:C29)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C30)-1,COLUMNS($C$18:C30)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C30)-1,COLUMNS($C$18:C30)-1),\"\")","v":"(6) The minimum depth of embedment for the MSE wall is 4 feet."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C31)-1,COLUMNS($C$18:C31)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C31)-1,COLUMNS($C$18:C31)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C32)-1,COLUMNS($C$18:C32)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C32)-1,COLUMNS($C$18:C32)-1),\"\")","v":"(7) The length of the reinforcement strips (or mesh) will vary by wall station and shall be based on a minimum width to wall height ratio"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C33)-1,COLUMNS($C$18:C33)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C33)-1,COLUMNS($C$18:C33)-1),\"\")","v":"    of 0.8 or 8 feet, whichever is greater."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C34)-1,COLUMNS($C$18:C34)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C34)-1,COLUMNS($C$18:C34)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C35)-1,COLUMNS($C$18:C35)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C35)-1,COLUMNS($C$18:C35)-1),\"\")","v":"(8) The MSE Wall designer shall review the bridge plans (Design No. 117) for the pile and corrugated metal pipe sleeve layout for"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C36)-1,COLUMNS($C$18:C36)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C36)-1,COLUMNS($C$18:C36)-1),\"\")","v":"    incorporation into the MSE Wall design and construction."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C37)-1,COLUMNS($C$18:C37)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C37)-1,COLUMNS($C$18:C37)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C38)-1,COLUMNS($C$18:C38)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C38)-1,COLUMNS($C$18:C38)-1),\"\")","v":"(9) See Sheets X.220 through X.225 for soil types."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C39)-1,COLUMNS($C$18:C39)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C39)-1,COLUMNS($C$18:C39)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C40)-1,COLUMNS($C$18:C40)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C40)-1,COLUMNS($C$18:C40)-1),\"\")","v":"(10) The Contractor is responsible for ensuring the stability of the 1:1 temporary excavation slope.  The Contractor shall provide the"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C41)-1,COLUMNS($C$18:C41)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C41)-1,COLUMNS($C$18:C41)-1),\"\")","v":"     Iowa DOT Resident Construction Engineer with supporting calculations if a slope other than 1:1 or temporary excavation support is  "}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C42)-1,COLUMNS($C$18:C42)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C42)-1,COLUMNS($C$18:C42)-1),\"\")","v":"     needed."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C43)-1,COLUMNS($C$18:C43)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C43)-1,COLUMNS($C$18:C43)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C44)-1,COLUMNS($C$18:C44)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C44)-1,COLUMNS($C$18:C44)-1),\"\")","v":"(11) The panels for the MSE Wall shall be cast as per the MSE Wall Details on Sheets V.2 through V.4."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C45)-1,COLUMNS($C$18:C45)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C45)-1,COLUMNS($C$18:C45)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C46)-1,COLUMNS($C$18:C46)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C46)-1,COLUMNS($C$18:C46)-1),\"\")","v":"(12) Two MSE Wall subdrains are required; one directly behind the wall panels and one at the back of the reinforced zone (see MSE Wall"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C47)-1,COLUMNS($C$18:C47)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C47)-1,COLUMNS($C$18:C47)-1),\"\")","v":"     Details on Sheet V.2)."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C48)-1,COLUMNS($C$18:C48)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C48)-1,COLUMNS($C$18:C48)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C49)-1,COLUMNS($C$18:C49)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C49)-1,COLUMNS($C$18:C49)-1),\"\")","v":"(13) For estimating purposes only, the following assumptions were used:"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C50)-1,COLUMNS($C$18:C50)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C50)-1,COLUMNS($C$18:C50)-1),\"\")","v":"     (a) The wall height at a given station is the distance between the top elevation of the leveling pad and the elevation of the top of"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C51)-1,COLUMNS($C$18:C51)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C51)-1,COLUMNS($C$18:C51)-1),\"\")","v":"         coping of the MSE wall."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C52)-1,COLUMNS($C$18:C52)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C52)-1,COLUMNS($C$18:C52)-1),\"\")","v":"     (b) The quantities of the granular backfill material and/or the excavation behind the wall were calculated based on the average end"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C53)-1,COLUMNS($C$18:C53)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C53)-1,COLUMNS($C$18:C53)-1),\"\")","v":"         area between cross sections.  The average end area was computed with the estimated wall heights and reinforcement lengths.      "}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C54)-1,COLUMNS($C$18:C54)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C54)-1,COLUMNS($C$18:C54)-1),\"\")","v":"         These quantities may need to be adjusted if the required reinforcement length is greater than the estimated length, and/or if   "}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C55)-1,COLUMNS($C$18:C55)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C55)-1,COLUMNS($C$18:C55)-1),\"\")","v":"         the footing elevation is adjusted."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C56)-1,COLUMNS($C$18:C56)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C56)-1,COLUMNS($C$18:C56)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C57)-1,COLUMNS($C$18:C57)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C57)-1,COLUMNS($C$18:C57)-1),\"\")","v":"(14) The Contractor shall submit the design computations and the MSE Wall shop drawings at least 4 weeks prior to construction for"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C58)-1,COLUMNS($C$18:C58)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C58)-1,COLUMNS($C$18:C58)-1),\"\")","v":"     review.  The submittal with cover letter shall be sent via email (in .PDF format) to:"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C59)-1,COLUMNS($C$18:C59)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C59)-1,COLUMNS($C$18:C59)-1),\"\")","v":"          Soils Design Section"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C60)-1,COLUMNS($C$18:C60)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C60)-1,COLUMNS($C$18:C60)-1),\"\")","v":"          Iowa Department of Transportation"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C61)-1,COLUMNS($C$18:C61)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C61)-1,COLUMNS($C$18:C61)-1),\"\")","v":"          Attn:  Steve Megivern, P.E."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C62)-1,COLUMNS($C$18:C62)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C62)-1,COLUMNS($C$18:C62)-1),\"\")","v":"          Stephen.Megivern@iowadot.us"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C63)-1,COLUMNS($C$18:C63)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C63)-1,COLUMNS($C$18:C63)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C64)-1,COLUMNS($C$18:C64)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C64)-1,COLUMNS($C$18:C64)-1),\"\")","v":"Only the submittal cover letter shall be sent via email (in .PDF format) to the applicable office(s) of the Resident Construction"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C65)-1,COLUMNS($C$18:C65)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C65)-1,COLUMNS($C$18:C65)-1),\"\")","v":"Engineer (RCE) and District Materials Engineer (DME) for their information and documentation that the plans have been submitted.  The"}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C66)-1,COLUMNS($C$18:C66)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C66)-1,COLUMNS($C$18:C66)-1),\"\")","v":"Soils Design section will distribute final approved documents to the RCE and DME."}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C67)-1,COLUMNS($C$18:C67)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C67)-1,COLUMNS($C$18:C67)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C68)-1,COLUMNS($C$18:C68)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C68)-1,COLUMNS($C$18:C68)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C69)-1,COLUMNS($C$18:C69)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C69)-1,COLUMNS($C$18:C69)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C70)-1,COLUMNS($C$18:C70)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C70)-1,COLUMNS($C$18:C70)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C71)-1,COLUMNS($C$18:C71)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C71)-1,COLUMNS($C$18:C71)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C72)-1,COLUMNS($C$18:C72)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C72)-1,COLUMNS($C$18:C72)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C73)-1,COLUMNS($C$18:C73)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C73)-1,COLUMNS($C$18:C73)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C74)-1,COLUMNS($C$18:C74)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C74)-1,COLUMNS($C$18:C74)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C75)-1,COLUMNS($C$18:C75)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C75)-1,COLUMNS($C$18:C75)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DERW_WALL!$C$18,ROWS($C$18:C76)-1,COLUMNS($C$18:C76)-1)<>\"\",OFFSET(DERW_WALL!$C$18,ROWS($C$18:C76)-1,COLUMNS($C$18:C76)-1),\"\")","v":""}]

{"sheet":"PrintSheetTemplate","index":4,"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":"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":"IF(ProjectInformation!$B$6<>\"\",ProjectInformation!$B$6,\"\")","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":"IF(ProjectInformation!$B$7<>\"\",ProjectInformation!$B$7,\"\")","v":"NHXS-030-6(231)--3H-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,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":5,"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":6,"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":7,"n_rows":164,"n_cols":15,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
["100-0A","1997-10-28","4.5.5","ADAIR",null,"Live English File Path","W:\\Highway\\Design\\RoadDesignDetails\\ExcelTabs\\",null,"Brian R. Smith","bsmith2","Methods","ROADWAY DESIGN",null,"RW_WALL(1)","=RW_WALL!$A$1:$A$63"]
["100-1A","1997-07-15","10/01/15","ADAMS",null,"Live Metric File Path","W:\\Highway\\Design\\RoadDesignDetails\\ExcelTabs\\MetricTabs\\",null,"Khyle B. Clute","kclute","Methods","ROADWAY DESIGN"]
["100-1C","2012-04-17","J","ALLAMAKEE",null,"Index File Path","W:\\Highway\\Design\\RoadDesignDetails\\PDFsandWebFiles\\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","W:\\Highway\\Design\\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","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\MetricTabs\\",null,"Christopher Poole","cpoole","Methods","ROADWAY DESIGN"]
["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"]
["100-11","2008-08-01",null,"BOONE",null,"VersionCheck Path","W:\\Highway\\Design\\CADD\\SpreadSheets\\ExcelTabulations.xlsm",null,"Elijah D. Gansen","egansen","Methods","ROADWAY DESIGN"]
["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"]
["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"]
["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"]
["100-14","2010-04-20",null,"BUTLER",null,"Old Files Path","W:\\Highway\\Design\\RoadDesignDetails\\Old_Details\\ExcelTabs\\",null,"Nathan A. Thede","nthede","Road1","ROADWAY DESIGN"]
["100-15","2010-04-20",null,"CALHOUN",null,null,null,null,"Jason M. Holst","jholst","Road1","ROADWAY DESIGN"]
["100-16","2010-10-19",null,"CARROLL",null,null,null,null,"Yanxiao Jia","yjia","Road2","ROADWAY DESIGN"]
["100-17","2010-04-20",null,"CASS",null,null,null,null,"Ryan R. Miller","rmille3","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,"James R. Schoenrock","jschoen","Consultant","ROADWAY DESIGN"]
["100-24","2013-04-16",null,"CLAYTON",null,null,null,null,"Randall E. Schlei","rschlie","Consultant","ROADWAY DESIGN"]
["100-26","2008-08-01",null,"CLINTON",null,null,null,null,"Mark D. Mastellar","mmastel","Roadside","ROADWAY DESIGN"]
["100-27","2009-10-20",null,"CRAWFORD",null,null,null,null,"Stephen J. Megivern","smegive","Soils","GEOTECHNICAL DESIGN"]
["100-28","2010-10-19",null,"DALLAS",null,null,null,null,"Mark A. Dell","mdell","Soils","GEOTECHNICAL DESIGN"]
["101-4","2002-04-30",null,"DAVIS",null,null,null,null,"David R. Claman","dclaman","Bridge","HYDRAULIC DESIGN"]
["101-5","2002-04-30",null,"DECATUR",null,null,null,null,"Zachary K. Abrams","zabrams","TrafficAndSafety","ROADWAY DESIGN"]
["101-6","2002-04-30",null,"DELAWARE"]
["101-7","2002-04-30",null,"DES MOINES"]
["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,"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"]
["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"]