{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ProjectInformation","PrintSheets","DE110_9","110_9","Calculations","PrintSheetTemplate","Note1","BridgeBlock","Index"],"not_rendered":{"charts":0,"images":4,"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","Flattery"]
["Design Team","Johnson"]
[]
["County","TAMA"]
["Project Number","NHSX-030-6(189)--3H-86"]
["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\\Johnson"},null,null,null,null,null,null,null,null,null,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":"TAMA"},null,null,null,null,null,null,null,null,null,null,null,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":"NHSX-030-6(189)--3H-86"},null,null,null,null,null,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,"C.12",null,null,null,null,null,{"$f":"IF(FP94<>\"\",\"REVISED\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ProjectInformation!$B$9<>\"\",ProjectInformation!$B$9,\"\")","v":""}]
["","2/6/2018     10:23:23 AM     ajohns1     c:\\pw_work\\pwmain\\ajohns1\\d0569206\\86030189_C02_Tab110-9.xlsm"]

{"sheet":"DE110_9","index":2,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[18,2,18,7],[18,9,18,14],[14,9,14,14],[15,2,16,7],[15,9,15,14],[16,9,17,14],[17,2,17,7],[19,2,19,7],[19,9,19,14],[20,2,24,2],[20,3,24,3],[20,4,20,5],[20,6,23,6],[20,7,24,7],[20,9,24,9],[20,10,24,10],[20,11,20,12],[20,13,23,13],[20,14,24,14],[21,4,23,4],[21,5,23,5],[21,11,23,11],[21,12,23,12]]}
["TabTitle",{"$f":"C16","v":"CULVERT ABANDONMENT"}]
["Number of Tab Columns",6]
["DE Starter Row Number",26]
["TabSheet Starter Row Number",12]
["TabSheet Header Row Count",11]
["Top Header Cell","J15"]
["Bottom Header Cell","O25"]
["DESheet Row Count",23]
["Fixed Empty Rows",2]
["Usable Empty Rows",0]
["Total Rows Placed",25,"xlRight(1)","xlLeft(1)","xlRight(1)","xlRight(1)","xlRight(1)","xlLeft(1)",null,{"$f":"C11","v":"xlRight(1)"},{"$f":"D11","v":"xlLeft(1)"},"xlRight(1)","xlRight(1)","xlRight(1)","xlLeft(1)"]
["Total Rows Needed",{"$f":"SUM(B8:B10)","v":25},"#+00.00","General","0.0","0.0","0.0","General",null,{"$f":"C12","v":"#+00.00"},"General","0.0","0.0","0.0","General"]
["Last Tab DE Starter Row",26,{"$f":"CELL(\"Width\",C13)","v":30},50,17,20,14,70,null,{"$f":"CELL(\"Width\",J13)","v":0},0,0,0,0,0]
["Last Tab TabSheet Starter Row",12,"A","B","C","D","E","F",null,"a","b","c","d","e","f"]
["Last Copy Starter Row",1,null,"Totals:",{"$f":"SUBTOTAL(9,E26:E6000)","v":6514.9518518518516},{"$f":"SUBTOTAL(9,F26:F6000)","v":15.943643229166666},{"$f":"SUBTOTAL(9,G26:G6000)","v":543},null,null,"110-9"]
["Tab Loop Number",2,"CULVERT ABANDONMENT",null,null,null,null,null,null,{"$f":"B17","v":"2011-10-18"}]
["Revision Date","2011-10-18",null,null,null,null,null,null,null,{"$f":"C16","v":"CULVERT ABANDONMENT"}]
["Tabulation Width",2,"Refer to Details 4315 and 4316"]
["Horizontal Grid Lines","Yes","* Not a bid item",null,null,null,null,null,null,{"$f":"C18","v":"Refer to Details 4315 and 4316"}]
[null,null,{"$f":"\"This Data Entry Sheet fills Tab \"&J15&\" effective \"&TEXT(B17,\"mm-dd-yy\")","v":"This Data Entry Sheet fills Tab 110-9 effective 10-18-11"},null,null,null,null,null,null,{"$f":"C19","v":"* Not a bid item"}]
[null,null,"Location\nStation","Description","Fill Material",null,"4\"\nPerforated\nSubdrain*","Remarks",null,{"$f":"C21","v":"Location\nStation"},{"$f":"D21","v":"Description"},{"$f":"E21","v":"Fill Material"},null,{"$f":"G21","v":"4\"\nPerforated\nSubdrain*"},{"$f":"H21","v":"Remarks"}]
[null,null,null,null,"Flowable\nMortar","Granular\nBackfill*",null,null,null,null,null,{"$f":"E22","v":"Flowable\nMortar"},{"$f":"F22","v":"Granular\nBackfill*"}]
[]
[]
[null,null,null,null,"CY","TON","LF",null,null,null,null,{"$f":"E25","v":"CY"},{"$f":"F25","v":"TON"},{"$f":"G25","v":"LF"}]
[null,null,"453+84.52, 162.69' Rt.","3.7'x5.5'x178' Conc. Arch Culvert",{"$f":"(Calculations!K4+Calculations!L4+Calculations!Y4+Calculations!Z4+Calculations!AH4)/27","v":291.53925925925927},{"$f":"((Calculations!M4+Calculations!AA4)*125)/2000","v":0.24307015625},{"$f":"Calculations!AB4","v":14},"with 4'x5'x249' RCB Extensions"]
[null,null,"459+60.87, 168.59' Rt.","3.7'x5.5'x147' Conc. Arch Culvert",{"$f":"(Calculations!K5+Calculations!L5+Calculations!Y5+Calculations!Z5+Calculations!AH5)/27","v":247.70777777777781},{"$f":"((Calculations!M5+Calculations!AA5)*125)/2000","v":0.24307015625},{"$f":"Calculations!AB5","v":14},"with 4'x5'x117' RCB Extensions and 24\"x156' CMP Tee"]
[null,null,"475+31.53, 157.92' Rt.","3'x3'x241' RCB",{"$f":"(Calculations!K6+Calculations!L6+Calculations!Y6+Calculations!Z6+Calculations!AH6)/27","v":80.203703703703709},{"$f":"((Calculations!M6+Calculations!AA6)*125)/2000","v":0.19147845486111112},{"$f":"Calculations!N6","v":10}]
[null,null,"493+95.50, 152.76' Rt.","5'x7'x280' RCB",{"$f":"(Calculations!K7+Calculations!L7+Calculations!Y7+Calculations!Z7+Calculations!AH7)/27","v":362.75925925925924},{"$f":"((Calculations!M7+Calculations!AA7)*125)/2000","v":0.29466185763888891},{"$f":"Calculations!N7","v":18}]
[null,null,"497+75.15, 151.70' Rt.","2'x2'x145' RCB",{"$f":"(Calculations!K8+Calculations!L8+Calculations!Y8+Calculations!Z8+Calculations!AH8)/27","v":21.37037037037037},{"$f":"((Calculations!M8+Calculations!AA8)*125)/2000","v":0.16568260416666666},{"$f":"Calculations!N8","v":8}]
[null,null,"511+30.61, 147.95' Rt.","4.75'x6'x287' Conc. Arch Culvert",{"$f":"(Calculations!K9+Calculations!L9+Calculations!Y9+Calculations!Z9+Calculations!AH9)/27","v":241.74925925925925},{"$f":"((Calculations!M9+Calculations!AA9)*125)/2000","v":0.79840749999999994},{"$f":"Calculations!N9","v":16}]
[null,null,"531+45.64, 134.84' Rt.","4'x4'x189' RCB",{"$f":"(Calculations!K10+Calculations!L10+Calculations!Y10+Calculations!Z10+Calculations!AH10)/27","v":111.85185185185185},{"$f":"((Calculations!M10+Calculations!AA10)*125)/2000","v":0.21727430555555557},{"$f":"Calculations!N10","v":12}]
[null,null,"538+86.05, 138.76' Rt.","5.5'x8'x141' Conc. Arch Culvert",{"$f":"(Calculations!K11+Calculations!L11+Calculations!Y11+Calculations!Z11+Calculations!AH11)/27","v":183.1611111111111},{"$f":"((Calculations!M11+Calculations!AA11)*125)/2000","v":0.97090750000000003},{"$f":"Calculations!N11","v":20}]
[null,null,"554+57.18, 145.52' Rt.","2'x2'x161' RCB",{"$f":"(Calculations!K12+Calculations!L12+Calculations!Y12+Calculations!Z12+Calculations!AH12)/27","v":23.74074074074074},{"$f":"((Calculations!M12+Calculations!AA12)*125)/2000","v":0.16568260416666666},{"$f":"Calculations!N12","v":8}]
[null,null,"556+89.66, 146.29' Rt.","2'x2'x216' RCB",{"$f":"(Calculations!K13+Calculations!L13+Calculations!Y13+Calculations!Z13+Calculations!AH13)/27","v":31.888888888888889},{"$f":"((Calculations!M13+Calculations!AA13)*125)/2000","v":0.16568260416666666},{"$f":"Calculations!N13","v":8}]
[null,null,"558+77.37, 146.91' Rt.","24\"x163' RCP",{"$f":"(Calculations!K14+Calculations!L14+Calculations!Y14+Calculations!Z14+Calculations!AH14)/27","v":18.865925925925929},{"$f":"((Calculations!M14+Calculations!AA14)*125)/2000","v":0.14340750000000002},{"$f":"Calculations!N14","v":8}]
[null,null,"566+82.25, 149.58' Rt.","5'x5'x170' RCB",{"$f":"(Calculations!K15+Calculations!L15+Calculations!Y15+Calculations!Z15+Calculations!AH15)/27","v":157.24074074074073},{"$f":"((Calculations!M15+Calculations!AA15)*125)/2000","v":0.24307015625},{"$f":"Calculations!N15","v":14}]
[null,null,"577+31.18, 153.06' Rt.","6.25'x9.25'x271' Conc. Arch Culvert",{"$f":"(Calculations!K16+Calculations!L16+Calculations!Y16+Calculations!Z16+Calculations!AH16)/27","v":463.30555555555554},{"$f":"((Calculations!M16+Calculations!AA16)*125)/2000","v":1.1371575},{"$f":"Calculations!N16","v":22.5}]
[null,null,"593+45.94, 158.41' Rt.","3.7'x5.5'x320' Conc. Arch Culvert",{"$f":"(Calculations!K17+Calculations!L17+Calculations!Y17+Calculations!Z17+Calculations!AH17)/27","v":192.44611111111112},{"$f":"((Calculations!M17+Calculations!AA17)*125)/2000","v":0.60465750000000007},{"$f":"Calculations!N17","v":15}]
[null,null,"612+43.88, 158.62' Rt.","4.75'x6'x308' Conc. Arch Culvert",{"$f":"(Calculations!K18+Calculations!L18+Calculations!Y18+Calculations!Z18+Calculations!AH18)/27","v":259.47481481481481},{"$f":"((Calculations!M18+Calculations!AA18)*125)/2000","v":0.79840749999999994},{"$f":"Calculations!N18","v":16}]
[null,null,"626+42.71, 155.01' Rt.","3.7'x5.5'x281' Conc. Arch Culvert",{"$f":"(Calculations!K19+Calculations!L19+Calculations!Y19+Calculations!Z19+Calculations!AH19)/27","v":168.94500000000002},{"$f":"((Calculations!M19+Calculations!AA19)*125)/2000","v":0.60465750000000007},{"$f":"Calculations!N19","v":15}]
[null,null,"654+57.52, 134.34' Rt.","4.75'x6'x196' Conc. Arch Culvert",{"$f":"(Calculations!K20+Calculations!L20+Calculations!Y20+Calculations!Z20+Calculations!AH20)/27","v":257.20888888888891},{"$f":"((Calculations!M20+Calculations!AA20)*125)/2000","v":0.26886600694444446},{"$f":"Calculations!AB20","v":16},"with 5'x6'x66' RCB Extension and 24\"x40' CMP Tee"]
[null,null,"661+02.08, 130.50' Rt.","2'x2'x130' RCB",{"$f":"(Calculations!K21+Calculations!L21+Calculations!Y21+Calculations!Z21+Calculations!AH21)/27","v":19.148148148148149},{"$f":"((Calculations!M21+Calculations!AA21)*125)/2000","v":0.16568260416666666},{"$f":"Calculations!N21","v":8}]
[null,null,"664+83.45, 115.98' Rt.","2'x2'x105' RCB",{"$f":"(Calculations!K22+Calculations!L22+Calculations!Y22+Calculations!Z22+Calculations!AH22)/27","v":18.717777777777776},{"$f":"((Calculations!M22+Calculations!AA22)*125)/2000","v":0.16568260416666666},{"$f":"Calculations!N22","v":8},"with 30\"x18' RCP Extension"]
[null,null,"668+87.97, 90.61' Rt.","3'x3'x131' RCB",{"$f":"(Calculations!K23+Calculations!L23+Calculations!Y23+Calculations!Z23+Calculations!AH23)/27","v":64.563703703703695},{"$f":"((Calculations!M23+Calculations!AA23)*125)/2000","v":0.20090750000000002},{"$f":"Calculations!AB23","v":11},"with 42\"x59' RCP Extension"]
[null,null,"671+20.30, 75.69' Rt.","2'x3'x104' RCB",{"$f":"(Calculations!K24+Calculations!L24+Calculations!Y24+Calculations!Z24+Calculations!AH24)/27","v":41.587037037037042},{"$f":"((Calculations!M24+Calculations!AA24)*125)/2000","v":0.1834075},{"$f":"Calculations!AB24","v":10},"with 36\"x71' RCP Extensions"]
[]
[null,null,"TOTALS:",null,{"$f":"SUM(E26:E46)","v":3257.4759259259258},{"$f":"SUM(F26:F46)","v":7.9718216145833329},{"$f":"SUM(G26:G46)","v":271.5}]

{"sheet":"110_9","index":3,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,2,9,2],[7,3,9,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,0,5,5],[6,0,10,0],[6,1,10,1],[6,2,6,3],[6,4,9,4],[6,5,10,5]]}
["110-9"]
["2011-10-18"]
["CULVERT ABANDONMENT"]
[]
["Refer to Details 4315 and 4316"]
["* Not a bid item"]
["Location\nStation","Description","Fill Material",null,"4\"\nPerforated\nSubdrain*","Remarks"]
[null,null,"Flowable\nMortar","Granular\nBackfill*"]
[]
[]
[null,null,"CY","TON","LF"]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C26)-1,COLUMNS($C$26:C26)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C26)-1,COLUMNS($C$26:C26)-1),\"\")","v":"453+84.52, 162.69' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D26)-1,COLUMNS($D$26:D26)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D26)-1,COLUMNS($D$26:D26)-1),\"\")","v":"3.7'x5.5'x178' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E26)-1,COLUMNS($E$26:E26)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E26)-1,COLUMNS($E$26:E26)-1),\"\")","v":291.53925925925927},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F26)-1,COLUMNS($F$26:F26)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F26)-1,COLUMNS($F$26:F26)-1),\"\")","v":0.24307015625},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G26)-1,COLUMNS($G$26:G26)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G26)-1,COLUMNS($G$26:G26)-1),\"\")","v":14},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H26)-1,COLUMNS($H$26:H26)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H26)-1,COLUMNS($H$26:H26)-1),\"\")","v":"with 4'x5'x249' RCB Extensions"}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C27)-1,COLUMNS($C$26:C27)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C27)-1,COLUMNS($C$26:C27)-1),\"\")","v":"459+60.87, 168.59' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D27)-1,COLUMNS($D$26:D27)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D27)-1,COLUMNS($D$26:D27)-1),\"\")","v":"3.7'x5.5'x147' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E27)-1,COLUMNS($E$26:E27)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E27)-1,COLUMNS($E$26:E27)-1),\"\")","v":247.70777777777781},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F27)-1,COLUMNS($F$26:F27)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F27)-1,COLUMNS($F$26:F27)-1),\"\")","v":0.24307015625},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G27)-1,COLUMNS($G$26:G27)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G27)-1,COLUMNS($G$26:G27)-1),\"\")","v":14},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H27)-1,COLUMNS($H$26:H27)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H27)-1,COLUMNS($H$26:H27)-1),\"\")","v":"with 4'x5'x117' RCB Extensions and 24\"x156' CMP Tee"}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C28)-1,COLUMNS($C$26:C28)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C28)-1,COLUMNS($C$26:C28)-1),\"\")","v":"475+31.53, 157.92' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D28)-1,COLUMNS($D$26:D28)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D28)-1,COLUMNS($D$26:D28)-1),\"\")","v":"3'x3'x241' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E28)-1,COLUMNS($E$26:E28)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E28)-1,COLUMNS($E$26:E28)-1),\"\")","v":80.203703703703709},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F28)-1,COLUMNS($F$26:F28)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F28)-1,COLUMNS($F$26:F28)-1),\"\")","v":0.19147845486111112},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G28)-1,COLUMNS($G$26:G28)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G28)-1,COLUMNS($G$26:G28)-1),\"\")","v":10},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H28)-1,COLUMNS($H$26:H28)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H28)-1,COLUMNS($H$26:H28)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C29)-1,COLUMNS($C$26:C29)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C29)-1,COLUMNS($C$26:C29)-1),\"\")","v":"493+95.50, 152.76' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D29)-1,COLUMNS($D$26:D29)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D29)-1,COLUMNS($D$26:D29)-1),\"\")","v":"5'x7'x280' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E29)-1,COLUMNS($E$26:E29)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E29)-1,COLUMNS($E$26:E29)-1),\"\")","v":362.75925925925924},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F29)-1,COLUMNS($F$26:F29)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F29)-1,COLUMNS($F$26:F29)-1),\"\")","v":0.29466185763888891},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G29)-1,COLUMNS($G$26:G29)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G29)-1,COLUMNS($G$26:G29)-1),\"\")","v":18},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H29)-1,COLUMNS($H$26:H29)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H29)-1,COLUMNS($H$26:H29)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C30)-1,COLUMNS($C$26:C30)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C30)-1,COLUMNS($C$26:C30)-1),\"\")","v":"497+75.15, 151.70' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D30)-1,COLUMNS($D$26:D30)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D30)-1,COLUMNS($D$26:D30)-1),\"\")","v":"2'x2'x145' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E30)-1,COLUMNS($E$26:E30)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E30)-1,COLUMNS($E$26:E30)-1),\"\")","v":21.37037037037037},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F30)-1,COLUMNS($F$26:F30)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F30)-1,COLUMNS($F$26:F30)-1),\"\")","v":0.16568260416666666},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G30)-1,COLUMNS($G$26:G30)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G30)-1,COLUMNS($G$26:G30)-1),\"\")","v":8},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H30)-1,COLUMNS($H$26:H30)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H30)-1,COLUMNS($H$26:H30)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C31)-1,COLUMNS($C$26:C31)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C31)-1,COLUMNS($C$26:C31)-1),\"\")","v":"511+30.61, 147.95' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D31)-1,COLUMNS($D$26:D31)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D31)-1,COLUMNS($D$26:D31)-1),\"\")","v":"4.75'x6'x287' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E31)-1,COLUMNS($E$26:E31)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E31)-1,COLUMNS($E$26:E31)-1),\"\")","v":241.74925925925925},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F31)-1,COLUMNS($F$26:F31)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F31)-1,COLUMNS($F$26:F31)-1),\"\")","v":0.79840749999999994},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G31)-1,COLUMNS($G$26:G31)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G31)-1,COLUMNS($G$26:G31)-1),\"\")","v":16},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H31)-1,COLUMNS($H$26:H31)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H31)-1,COLUMNS($H$26:H31)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C32)-1,COLUMNS($C$26:C32)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C32)-1,COLUMNS($C$26:C32)-1),\"\")","v":"531+45.64, 134.84' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D32)-1,COLUMNS($D$26:D32)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D32)-1,COLUMNS($D$26:D32)-1),\"\")","v":"4'x4'x189' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E32)-1,COLUMNS($E$26:E32)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E32)-1,COLUMNS($E$26:E32)-1),\"\")","v":111.85185185185185},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F32)-1,COLUMNS($F$26:F32)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F32)-1,COLUMNS($F$26:F32)-1),\"\")","v":0.21727430555555557},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G32)-1,COLUMNS($G$26:G32)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G32)-1,COLUMNS($G$26:G32)-1),\"\")","v":12},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H32)-1,COLUMNS($H$26:H32)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H32)-1,COLUMNS($H$26:H32)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C33)-1,COLUMNS($C$26:C33)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C33)-1,COLUMNS($C$26:C33)-1),\"\")","v":"538+86.05, 138.76' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D33)-1,COLUMNS($D$26:D33)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D33)-1,COLUMNS($D$26:D33)-1),\"\")","v":"5.5'x8'x141' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E33)-1,COLUMNS($E$26:E33)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E33)-1,COLUMNS($E$26:E33)-1),\"\")","v":183.1611111111111},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F33)-1,COLUMNS($F$26:F33)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F33)-1,COLUMNS($F$26:F33)-1),\"\")","v":0.97090750000000003},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G33)-1,COLUMNS($G$26:G33)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G33)-1,COLUMNS($G$26:G33)-1),\"\")","v":20},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H33)-1,COLUMNS($H$26:H33)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H33)-1,COLUMNS($H$26:H33)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C34)-1,COLUMNS($C$26:C34)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C34)-1,COLUMNS($C$26:C34)-1),\"\")","v":"554+57.18, 145.52' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D34)-1,COLUMNS($D$26:D34)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D34)-1,COLUMNS($D$26:D34)-1),\"\")","v":"2'x2'x161' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E34)-1,COLUMNS($E$26:E34)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E34)-1,COLUMNS($E$26:E34)-1),\"\")","v":23.74074074074074},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F34)-1,COLUMNS($F$26:F34)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F34)-1,COLUMNS($F$26:F34)-1),\"\")","v":0.16568260416666666},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G34)-1,COLUMNS($G$26:G34)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G34)-1,COLUMNS($G$26:G34)-1),\"\")","v":8},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H34)-1,COLUMNS($H$26:H34)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H34)-1,COLUMNS($H$26:H34)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C35)-1,COLUMNS($C$26:C35)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C35)-1,COLUMNS($C$26:C35)-1),\"\")","v":"556+89.66, 146.29' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D35)-1,COLUMNS($D$26:D35)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D35)-1,COLUMNS($D$26:D35)-1),\"\")","v":"2'x2'x216' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E35)-1,COLUMNS($E$26:E35)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E35)-1,COLUMNS($E$26:E35)-1),\"\")","v":31.888888888888889},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F35)-1,COLUMNS($F$26:F35)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F35)-1,COLUMNS($F$26:F35)-1),\"\")","v":0.16568260416666666},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G35)-1,COLUMNS($G$26:G35)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G35)-1,COLUMNS($G$26:G35)-1),\"\")","v":8},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H35)-1,COLUMNS($H$26:H35)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H35)-1,COLUMNS($H$26:H35)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C36)-1,COLUMNS($C$26:C36)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C36)-1,COLUMNS($C$26:C36)-1),\"\")","v":"558+77.37, 146.91' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D36)-1,COLUMNS($D$26:D36)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D36)-1,COLUMNS($D$26:D36)-1),\"\")","v":"24\"x163' RCP"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E36)-1,COLUMNS($E$26:E36)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E36)-1,COLUMNS($E$26:E36)-1),\"\")","v":18.865925925925929},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F36)-1,COLUMNS($F$26:F36)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F36)-1,COLUMNS($F$26:F36)-1),\"\")","v":0.14340750000000002},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G36)-1,COLUMNS($G$26:G36)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G36)-1,COLUMNS($G$26:G36)-1),\"\")","v":8},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H36)-1,COLUMNS($H$26:H36)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H36)-1,COLUMNS($H$26:H36)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C37)-1,COLUMNS($C$26:C37)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C37)-1,COLUMNS($C$26:C37)-1),\"\")","v":"566+82.25, 149.58' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D37)-1,COLUMNS($D$26:D37)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D37)-1,COLUMNS($D$26:D37)-1),\"\")","v":"5'x5'x170' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E37)-1,COLUMNS($E$26:E37)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E37)-1,COLUMNS($E$26:E37)-1),\"\")","v":157.24074074074073},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F37)-1,COLUMNS($F$26:F37)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F37)-1,COLUMNS($F$26:F37)-1),\"\")","v":0.24307015625},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G37)-1,COLUMNS($G$26:G37)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G37)-1,COLUMNS($G$26:G37)-1),\"\")","v":14},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H37)-1,COLUMNS($H$26:H37)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H37)-1,COLUMNS($H$26:H37)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C38)-1,COLUMNS($C$26:C38)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C38)-1,COLUMNS($C$26:C38)-1),\"\")","v":"577+31.18, 153.06' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D38)-1,COLUMNS($D$26:D38)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D38)-1,COLUMNS($D$26:D38)-1),\"\")","v":"6.25'x9.25'x271' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E38)-1,COLUMNS($E$26:E38)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E38)-1,COLUMNS($E$26:E38)-1),\"\")","v":463.30555555555554},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F38)-1,COLUMNS($F$26:F38)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F38)-1,COLUMNS($F$26:F38)-1),\"\")","v":1.1371575},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G38)-1,COLUMNS($G$26:G38)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G38)-1,COLUMNS($G$26:G38)-1),\"\")","v":22.5},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H38)-1,COLUMNS($H$26:H38)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H38)-1,COLUMNS($H$26:H38)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C39)-1,COLUMNS($C$26:C39)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C39)-1,COLUMNS($C$26:C39)-1),\"\")","v":"593+45.94, 158.41' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D39)-1,COLUMNS($D$26:D39)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D39)-1,COLUMNS($D$26:D39)-1),\"\")","v":"3.7'x5.5'x320' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E39)-1,COLUMNS($E$26:E39)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E39)-1,COLUMNS($E$26:E39)-1),\"\")","v":192.44611111111112},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F39)-1,COLUMNS($F$26:F39)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F39)-1,COLUMNS($F$26:F39)-1),\"\")","v":0.60465750000000007},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G39)-1,COLUMNS($G$26:G39)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G39)-1,COLUMNS($G$26:G39)-1),\"\")","v":15},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H39)-1,COLUMNS($H$26:H39)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H39)-1,COLUMNS($H$26:H39)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C40)-1,COLUMNS($C$26:C40)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C40)-1,COLUMNS($C$26:C40)-1),\"\")","v":"612+43.88, 158.62' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D40)-1,COLUMNS($D$26:D40)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D40)-1,COLUMNS($D$26:D40)-1),\"\")","v":"4.75'x6'x308' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E40)-1,COLUMNS($E$26:E40)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E40)-1,COLUMNS($E$26:E40)-1),\"\")","v":259.47481481481481},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F40)-1,COLUMNS($F$26:F40)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F40)-1,COLUMNS($F$26:F40)-1),\"\")","v":0.79840749999999994},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G40)-1,COLUMNS($G$26:G40)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G40)-1,COLUMNS($G$26:G40)-1),\"\")","v":16},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H40)-1,COLUMNS($H$26:H40)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H40)-1,COLUMNS($H$26:H40)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C41)-1,COLUMNS($C$26:C41)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C41)-1,COLUMNS($C$26:C41)-1),\"\")","v":"626+42.71, 155.01' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D41)-1,COLUMNS($D$26:D41)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D41)-1,COLUMNS($D$26:D41)-1),\"\")","v":"3.7'x5.5'x281' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E41)-1,COLUMNS($E$26:E41)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E41)-1,COLUMNS($E$26:E41)-1),\"\")","v":168.94500000000002},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F41)-1,COLUMNS($F$26:F41)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F41)-1,COLUMNS($F$26:F41)-1),\"\")","v":0.60465750000000007},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G41)-1,COLUMNS($G$26:G41)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G41)-1,COLUMNS($G$26:G41)-1),\"\")","v":15},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H41)-1,COLUMNS($H$26:H41)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H41)-1,COLUMNS($H$26:H41)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C42)-1,COLUMNS($C$26:C42)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C42)-1,COLUMNS($C$26:C42)-1),\"\")","v":"654+57.52, 134.34' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D42)-1,COLUMNS($D$26:D42)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D42)-1,COLUMNS($D$26:D42)-1),\"\")","v":"4.75'x6'x196' Conc. Arch Culvert"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E42)-1,COLUMNS($E$26:E42)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E42)-1,COLUMNS($E$26:E42)-1),\"\")","v":257.20888888888891},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F42)-1,COLUMNS($F$26:F42)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F42)-1,COLUMNS($F$26:F42)-1),\"\")","v":0.26886600694444446},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G42)-1,COLUMNS($G$26:G42)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G42)-1,COLUMNS($G$26:G42)-1),\"\")","v":16},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H42)-1,COLUMNS($H$26:H42)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H42)-1,COLUMNS($H$26:H42)-1),\"\")","v":"with 5'x6'x66' RCB Extension and 24\"x40' CMP Tee"}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C43)-1,COLUMNS($C$26:C43)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C43)-1,COLUMNS($C$26:C43)-1),\"\")","v":"661+02.08, 130.50' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D43)-1,COLUMNS($D$26:D43)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D43)-1,COLUMNS($D$26:D43)-1),\"\")","v":"2'x2'x130' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E43)-1,COLUMNS($E$26:E43)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E43)-1,COLUMNS($E$26:E43)-1),\"\")","v":19.148148148148149},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F43)-1,COLUMNS($F$26:F43)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F43)-1,COLUMNS($F$26:F43)-1),\"\")","v":0.16568260416666666},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G43)-1,COLUMNS($G$26:G43)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G43)-1,COLUMNS($G$26:G43)-1),\"\")","v":8},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H43)-1,COLUMNS($H$26:H43)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H43)-1,COLUMNS($H$26:H43)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C44)-1,COLUMNS($C$26:C44)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C44)-1,COLUMNS($C$26:C44)-1),\"\")","v":"664+83.45, 115.98' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D44)-1,COLUMNS($D$26:D44)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D44)-1,COLUMNS($D$26:D44)-1),\"\")","v":"2'x2'x105' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E44)-1,COLUMNS($E$26:E44)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E44)-1,COLUMNS($E$26:E44)-1),\"\")","v":18.717777777777776},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F44)-1,COLUMNS($F$26:F44)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F44)-1,COLUMNS($F$26:F44)-1),\"\")","v":0.16568260416666666},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G44)-1,COLUMNS($G$26:G44)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G44)-1,COLUMNS($G$26:G44)-1),\"\")","v":8},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H44)-1,COLUMNS($H$26:H44)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H44)-1,COLUMNS($H$26:H44)-1),\"\")","v":"with 30\"x18' RCP Extension"}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C45)-1,COLUMNS($C$26:C45)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C45)-1,COLUMNS($C$26:C45)-1),\"\")","v":"668+87.97, 90.61' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D45)-1,COLUMNS($D$26:D45)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D45)-1,COLUMNS($D$26:D45)-1),\"\")","v":"3'x3'x131' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E45)-1,COLUMNS($E$26:E45)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E45)-1,COLUMNS($E$26:E45)-1),\"\")","v":64.563703703703695},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F45)-1,COLUMNS($F$26:F45)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F45)-1,COLUMNS($F$26:F45)-1),\"\")","v":0.20090750000000002},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G45)-1,COLUMNS($G$26:G45)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G45)-1,COLUMNS($G$26:G45)-1),\"\")","v":11},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H45)-1,COLUMNS($H$26:H45)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H45)-1,COLUMNS($H$26:H45)-1),\"\")","v":"with 42\"x59' RCP Extension"}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C46)-1,COLUMNS($C$26:C46)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C46)-1,COLUMNS($C$26:C46)-1),\"\")","v":"671+20.30, 75.69' Rt."},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D46)-1,COLUMNS($D$26:D46)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D46)-1,COLUMNS($D$26:D46)-1),\"\")","v":"2'x3'x104' RCB"},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E46)-1,COLUMNS($E$26:E46)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E46)-1,COLUMNS($E$26:E46)-1),\"\")","v":41.587037037037042},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F46)-1,COLUMNS($F$26:F46)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F46)-1,COLUMNS($F$26:F46)-1),\"\")","v":0.1834075},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G46)-1,COLUMNS($G$26:G46)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G46)-1,COLUMNS($G$26:G46)-1),\"\")","v":10},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H46)-1,COLUMNS($H$26:H46)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H46)-1,COLUMNS($H$26:H46)-1),\"\")","v":"with 36\"x71' RCP Extensions"}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C47)-1,COLUMNS($C$26:C47)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C47)-1,COLUMNS($C$26:C47)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D47)-1,COLUMNS($D$26:D47)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D47)-1,COLUMNS($D$26:D47)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E47)-1,COLUMNS($E$26:E47)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E47)-1,COLUMNS($E$26:E47)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F47)-1,COLUMNS($F$26:F47)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F47)-1,COLUMNS($F$26:F47)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G47)-1,COLUMNS($G$26:G47)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G47)-1,COLUMNS($G$26:G47)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H47)-1,COLUMNS($H$26:H47)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H47)-1,COLUMNS($H$26:H47)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C48)-1,COLUMNS($C$26:C48)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C48)-1,COLUMNS($C$26:C48)-1),\"\")","v":"TOTALS:"},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D48)-1,COLUMNS($D$26:D48)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D48)-1,COLUMNS($D$26:D48)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E48)-1,COLUMNS($E$26:E48)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E48)-1,COLUMNS($E$26:E48)-1),\"\")","v":3257.4759259259258},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F48)-1,COLUMNS($F$26:F48)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F48)-1,COLUMNS($F$26:F48)-1),\"\")","v":7.9718216145833329},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G48)-1,COLUMNS($G$26:G48)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G48)-1,COLUMNS($G$26:G48)-1),\"\")","v":271.5},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H48)-1,COLUMNS($H$26:H48)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H48)-1,COLUMNS($H$26:H48)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C49)-1,COLUMNS($C$26:C49)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C49)-1,COLUMNS($C$26:C49)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D49)-1,COLUMNS($D$26:D49)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D49)-1,COLUMNS($D$26:D49)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E49)-1,COLUMNS($E$26:E49)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E49)-1,COLUMNS($E$26:E49)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F49)-1,COLUMNS($F$26:F49)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F49)-1,COLUMNS($F$26:F49)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G49)-1,COLUMNS($G$26:G49)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G49)-1,COLUMNS($G$26:G49)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H49)-1,COLUMNS($H$26:H49)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H49)-1,COLUMNS($H$26:H49)-1),\"\")","v":""}]
[{"$f":"IF(OFFSET(DE110_9!$C$26,ROWS($C$26:C50)-1,COLUMNS($C$26:C50)-1)<>\"\",OFFSET(DE110_9!$C$26,ROWS($C$26:C50)-1,COLUMNS($C$26:C50)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$D$26,ROWS($D$26:D50)-1,COLUMNS($D$26:D50)-1)<>\"\",OFFSET(DE110_9!$D$26,ROWS($D$26:D50)-1,COLUMNS($D$26:D50)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$E$26,ROWS($E$26:E50)-1,COLUMNS($E$26:E50)-1)<>\"\",OFFSET(DE110_9!$E$26,ROWS($E$26:E50)-1,COLUMNS($E$26:E50)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$F$26,ROWS($F$26:F50)-1,COLUMNS($F$26:F50)-1)<>\"\",OFFSET(DE110_9!$F$26,ROWS($F$26:F50)-1,COLUMNS($F$26:F50)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$G$26,ROWS($G$26:G50)-1,COLUMNS($G$26:G50)-1)<>\"\",OFFSET(DE110_9!$G$26,ROWS($G$26:G50)-1,COLUMNS($G$26:G50)-1),\"\")","v":""},{"$f":"IF(OFFSET(DE110_9!$H$26,ROWS($H$26:H50)-1,COLUMNS($H$26:H50)-1)<>\"\",OFFSET(DE110_9!$H$26,ROWS($H$26:H50)-1,COLUMNS($H$26:H50)-1),\"\")","v":""}]

{"sheet":"Calculations","index":4,"n_rows":26,"n_cols":36,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,35,2,35],[1,1,2,1],[1,10,1,12],[1,29,1,31],[1,2,1,6],[1,7,1,9],[1,15,1,20],[1,21,1,23],[1,24,1,26]]}
[]
[null,{"$f":"DE110_9!C21","v":"Location\nStation"},"Pipe",null,null,null,null,"End Area (SF)",null,null,"Volume (CF)",null,null,"Length (LF)",null,"Extension",null,null,null,null,null,"End Area",null,null,"Volume (CF)",null,null,"Length (LF)",null,"Tee",null,null,"End Area","Volume (CF)",null,"Notes"]
[null,null,"Width (Span)","Height (Rise)","Diameter","Length","Type","Total Flowable Mortar","Flowable Mortar","Granular Backfill","Total Flowable Mortar","Flowable Mortar","Granular Backfill","Subdrain",null,"Width","Height","Diameter","Length","Type","Side","Total Flowable Mortar","Flowable Mortar","Granular Backfill","Total Flowable Mortar","Flowable Mortar","Granular Backfill","Subdrain",null,"Diameter","Length","Type","Total Flowable Mortar","Total Flowable Mortar"]
[null,{"$f":"DE110_9!C26","v":"453+84.52, 162.69' Rt."},3.7,5.5,null,178,"Concrete Arch Culvert",16.27,null,null,{"$f":"F4*H4","v":2896.06},null,null,null,null,4,5,null,249,"RCB Extensions","Both",{"$f":"P4*Q4","v":20},{"$f":"V4-(1*1*0.5)","v":19.5},{"$f":"(1*1*0.5)-(3.14159*((4/12)/2)^2)","v":0.41273361111111112},{"$f":"(S4-(Q4+2)-2)*V4","v":4800},{"$f":"((Q4+2)+2)*W4","v":175.5},{"$f":"((Q4+2)*X4)+(2*(X4+0.08726))","v":3.8891225},{"$f":"(Q4+2)*2","v":14},null,null,null,null,null,null,null,"Remove Flume"]
[null,{"$f":"DE110_9!C27","v":"459+60.87, 168.59' Rt."},3.7,5.5,null,147,"Concrete Arch Culvert",16.27,null,null,{"$f":"F5*H5","v":2391.69},null,null,null,null,4,5,null,117,"RCB Extensions","Both",{"$f":"P5*Q5","v":20},{"$f":"V5-(1*1*0.5)","v":19.5},{"$f":"(1*1*0.5)-(3.14159*((4/12)/2)^2)","v":0.41273361111111112},{"$f":"(S5-(Q5+2)-2)*V5","v":2160},{"$f":"((Q5+2)+2)*W5","v":175.5},{"$f":"((Q5+2)*X5)+(2*(X5+0.08726))","v":3.8891225},{"$f":"(Q5+2)*2","v":14},null,2,156,"CMP",12.57,{"$f":"AE5*AG5","v":1960.92},null,"Remove Flume"]
[null,{"$f":"DE110_9!C28","v":"475+31.53, 157.92' Rt."},3,3,null,241,"RCB",{"$f":"C6*D6","v":9},{"$f":"H6-(1*1*0.5)","v":8.5},{"$f":"(1*1*0.5)-(3.14159*((4/12)/2)^2)","v":0.41273361111111112},{"$f":"(F6-(D6+2)-2)*H6","v":2106},{"$f":"((D6+2)+2)*I6","v":59.5},{"$f":"((D6+2)*J6)+(2*(J6+0.08726))","v":3.0636552777777779},{"$f":"(D6+2)*2","v":10}]
[null,{"$f":"DE110_9!C29","v":"493+95.50, 152.76' Rt."},5,7,null,280,"RCB",{"$f":"C7*D7","v":35},{"$f":"H7-(1*1*0.5)","v":34.5},{"$f":"(1*1*0.5)-(3.14159*((4/12)/2)^2)","v":0.41273361111111112},{"$f":"(F7-(D7+2)-2)*H7","v":9415},{"$f":"((D7+2)+2)*I7","v":379.5},{"$f":"((D7+2)*J7)+(2*(J7+0.08726))","v":4.7145897222222226},{"$f":"(D7+2)*2","v":18}]
[null,{"$f":"DE110_9!C30","v":"497+75.15, 151.70' Rt."},2,2,null,145,"RCB",{"$f":"C8*D8","v":4},{"$f":"H8-(1*1*0.5)","v":3.5},0.41273361111111112,556,21,2.6509216666666666,8]
[null,{"$f":"DE110_9!C31","v":"511+30.61, 147.95' Rt."},4.75,6,null,287,"Concrete Arch Culvert",22.79,21.44,1.26,6312.83,{"$f":"((D9+2)+2)*I9","v":214.4},{"$f":"((D9+2)*J9)+(2*(J9+0.08726))","v":12.774519999999999},16]
[null,{"$f":"DE110_9!C32","v":"531+45.64, 134.84' Rt."},4,4,null,189,"RCB",{"$f":"C10*D10","v":16},{"$f":"H10-(1*1*0.5)","v":15.5},0.41273361111111112,2896,{"$f":"((D10+2)+2)*I10","v":124},3.4763888888888892,12]
[null,{"$f":"DE110_9!C33","v":"538+86.05, 138.76' Rt."},5.5,8,null,141,"Concrete Arch Culvert",35.19,33.82,1.28,4539.5099999999993,{"$f":"((D11+2)+2)*I11","v":405.84000000000003},15.534520000000001,20]
[null,{"$f":"DE110_9!C34","v":"554+57.18, 145.52' Rt."},2,2,null,161,"RCB",{"$f":"C12*D12","v":4},{"$f":"H12-(1*1*0.5)","v":3.5},0.41273361111111112,620,21,2.6509216666666666,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remove Flume"]
[null,{"$f":"DE110_9!C35","v":"556+89.66, 146.29' Rt."},2,2,null,216,"RCB",{"$f":"C13*D13","v":4},{"$f":"H13-(1*1*0.5)","v":3.5},0.41273361111111112,840,21,2.6509216666666666,8]
[null,{"$f":"DE110_9!C36","v":"558+77.37, 146.91' Rt."},null,null,2,163,"RCP",3.14,2.5299999999999998,0.53,499.26000000000005,10.119999999999999,2.2945200000000003,{"$f":"(E14+2)*2","v":8}]
[null,{"$f":"DE110_9!C37","v":"566+82.25, 149.58' Rt."},5,5,null,170,"RCB",{"$f":"C15*D15","v":25},{"$f":"H15-(1*1*0.5)","v":24.5},0.41273361111111112,4025,220.5,3.8891225,14]
[null,{"$f":"DE110_9!C38","v":"577+31.18, 153.06' Rt."},6.25,9.25,null,271,"Concrete Arch Culvert",46.23,44.79,1.36,11915.782499999999,593.46749999999997,18.194520000000001,22.5]
[null,{"$f":"DE110_9!C39","v":"593+45.94, 158.41' Rt."},3.7,5.5,null,320,"Concrete Arch Culvert",16.27,15.18,1,5051.835,144.21,9.6745200000000011,15]
[null,{"$f":"DE110_9!C40","v":"612+43.88, 158.62' Rt."},4.75,6,null,308,"Concrete Arch Culvert",22.79,21.44,1.26,6791.42,214.4,12.774519999999999,16]
[null,{"$f":"DE110_9!C41","v":"626+42.71, 155.01' Rt."},3.7,5.5,null,281,"Concrete Arch Culvert",16.27,15.18,1,4417.3050000000003,144.21,9.6745200000000011,15]
[null,{"$f":"DE110_9!C42","v":"654+57.52, 134.34' Rt."},4.75,6,null,196,"Concrete Arch Culvert",22.79,null,null,{"$f":"F20*H20","v":4466.84},null,null,null,null,5,6,null,66,"RCB Extension","Outlet",30,29.5,0.41273361111111112,1680,295,4.3018561111111113,{"$f":"(Q20+2)*2","v":16},null,2,40,"CMP",12.57,{"$f":"AE20*AG20","v":502.8}]
[null,{"$f":"DE110_9!C43","v":"661+02.08, 130.50' Rt."},2,2,null,130,"RCB",{"$f":"C21*D21","v":4},{"$f":"H21-(1*1*0.5)","v":3.5},{"$f":"(1*1*0.5)-(3.14159*((4/12)/2)^2)","v":0.41273361111111112},496,21,2.6509216666666666,8]
[null,{"$f":"DE110_9!C44","v":"664+83.45, 115.98' Rt."},2,2,null,105,"RCB",{"$f":"C22*D22","v":4},{"$f":"H22-(1*1*0.5)","v":3.5},0.41273361111111112,396,21,2.6509216666666666,8,null,null,null,2.5,18,"RCP Extension","Inlet",4.91,null,null,{"$f":"S22*V22","v":88.38}]
[null,{"$f":"DE110_9!C45","v":"668+87.97, 90.61' Rt."},3,3,null,131,"RCB",{"$f":"C23*D23","v":9},null,null,{"$f":"F23*H23","v":1179},null,null,null,null,null,null,3.5,59,"RCP Extension","Outlet",9.6199999999999992,8.7799999999999994,0.76,529.09999999999991,35.119999999999997,3.2145200000000003,{"$f":"(R23+2)*2","v":11}]
[null,{"$f":"DE110_9!C46","v":"671+20.30, 75.69' Rt."},2,3,null,104,"RCB",{"$f":"C24*D24","v":6},null,null,{"$f":"F24*H24","v":624},null,null,null,null,null,null,3,71,"RCP Extension","Both",7.07,6.29,0.69,473.69,25.16,2.93452,{"$f":"(R24+2)*2","v":10}]
[]
[null,"TOTALS:",null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K24)","v":72435.532500000001},{"$f":"SUM(L4:L24)","v":2615.1475},109.32000472222221,206.5,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y4:Y24)","v":9731.17},{"$f":"SUM(Z4:Z24)","v":706.28},18.229141111111112,65,null,null,null,null,null,{"$f":"SUM(AH4:AH24)","v":2463.7200000000003}]

{"sheet":"PrintSheetTemplate","index":5,"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\\Johnson"},null,null,null,null,null,null,null,null,null,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":"TAMA"},null,null,null,null,null,null,null,null,null,null,null,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":"NHSX-030-6(189)--3H-86"},null,null,null,null,null,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":6,"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":7,"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":8,"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,"Brian R. Smith","bsmith2","Methods","ROADWAY DESIGN",null,"110_9(1)","='110_9'!$A$1:$F$36",null,"A_DE111Series.xlsm"]
["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",null,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,null,"C_DE111Series.xlsm"]
["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",null,null,null,null,"C_DE112Series.xlsm"]
["100-15","2010-04-20",null,"CALHOUN",null,null,null,null,"Yanxiao Jia","yjia","Road2","ROADWAY DESIGN",null,null,null,null,"C_DE113Series.xlsm"]
["100-16","2010-10-19",null,"CARROLL",null,null,null,null,"Ryan R. Miller","rmille3","Road2","ROADWAY DESIGN",null,null,null,null,"C_DE190Series.xlsm"]
["100-17","2010-04-20",null,"CASS",null,null,null,null,"Dustin T. Skogerboe","dskoge2","Road2","ROADWAY DESIGN",null,null,null,null,"C_DE192Series.xlsm"]
["100-18","2010-04-20",null,"CEDAR",null,null,null,null,"Dung T. Ta","dta","Road2","ROADWAY DESIGN",null,null,null,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,null,null,null,"C_DE232Series.xlsm"]
["100-20","2008-08-01",null,"CHEROKEE",null,null,null,null,"Paul W. Flattery","pflatte","Road3","ROADWAY DESIGN",null,null,null,null,"C_DE252Series.xlsm"]
["100-21","2008-08-01",null,"CHICKASAW",null,null,null,null,"Kelly C. Bell","kbell","Road3","ROADWAY DESIGN",null,null,null,null,"C_DE253Series.xlsm"]
["100-22","2008-08-01",null,"CLARKE",null,null,null,null,"Angela K. Johnson","ajohns1","Road3","ROADWAY DESIGN",null,null,null,null,"C_DE254Series.xlsm"]
["100-23","2010-10-19",null,"CLAY",null,null,null,null,"Elijah D. Gansen","egansen","Road3","ROADWAY DESIGN",null,null,null,null,"C_DE259Series.xlsm"]
["100-24","2013-04-16",null,"CLAYTON",null,null,null,null,"James R. Schoenrock","jschoen","Consultant","ROADWAY DESIGN",null,null,null,null,"C_DE262Series.xlsm"]
["100-26","2008-08-01",null,"CLINTON",null,null,null,null,"Randall E. Schlei","rschlie","Consultant","ROADWAY DESIGN",null,null,null,null,"C_DE271Series.xlsm"]
["100-27","2009-10-20",null,"CRAWFORD",null,null,null,null,"Seana K. Godbold","sgodbol","Roadside","ROADWAY DESIGN",null,null,null,null,"C_DE281Series.xlsm"]
["100-28","2010-10-19",null,"DALLAS",null,null,null,null,"Robert L. Stanley","rstanle","Soils","GEOTECHNICAL DESIGN",null,null,null,null,"C_DE282Series.xlsm"]
["101-4","2002-04-30",null,"DAVIS",null,null,null,null,"Stephen J. Megivern","smegive","Soils","GEOTECHNICAL DESIGN",null,null,null,null,"C_DE290Series.xlsm"]
["101-5","2002-04-30",null,"DECATUR",null,null,null,null,"Mark A. Dell","mdell","Soils","GEOTECHNICAL DESIGN",null,null,null,null,"G_DE101Series.xlsm"]
["101-6","2002-04-30",null,"DELAWARE",null,null,null,null,"David R. Claman","dclaman","Bridge","HYDRAULIC DESIGN",null,null,null,null,"J_DE108Series.xlsm"]
["101-7","2002-04-30",null,"DES MOINES",null,null,null,null,"Zachary K. Abrams","zabrams","TrafficAndSafety","ROADWAY DESIGN",null,null,null,null,"J_DE111Series.xlsm"]
["101-8","2013-04-16",null,"DICKINSON",null,null,null,null,"Engineer of Record","Khocket","Methods","ROADWAY DESIGN",null,null,null,null,"J_DE113Series.xlsm"]
["101-13","2004-04-20",null,"DUBUQUE",null,null,null,null,"William L. Kaufman","wkaufma","Bridge","HYDRAULIC DESIGN",null,null,null,null,"S_DE113Series.xlsm"]
["101-16","2009-10-20",null,"EMMET",null,null,null,null,"David J. Heer","dheer","Soils","GEOTECHNICAL DESIGN"]
["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",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"]