{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Design","Survey","Cost Est.","IN-ENG-57L","IN-ENG-42","Profile","IN-ENG-14P","IN-ENG-14T","DWA","Specs","Defaults","Comments"],"not_rendered":{"charts":2,"images":24,"macros":1,"external_links":1,"defined_names":124,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Profile","index":5,"reason":"not_a_worksheet"}],"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":"Design","index":0,"n_rows":117,"n_cols":45,"rows_kept":117,"cut":false,"hidden":false,"merged":[[102,7,102,8],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[93,2,93,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[90,15,91,15],[91,2,92,3],[91,4,92,4],[91,5,92,5],[1,0,1,15],[80,0,80,15],[88,9,88,11],[90,1,92,1],[90,2,90,5],[90,6,91,6],[90,7,91,7],[90,8,91,8],[90,9,91,9],[90,10,91,10],[90,11,90,13],[82,3,82,6],[82,10,82,11],[82,14,82,15],[83,2,83,6],[83,10,83,11],[83,14,83,15],[23,7,23,8],[3,10,3,11],[4,10,4,11],[21,2,21,3],[9,9,9,11],[15,2,15,3],[19,2,19,3],[17,2,17,3],[18,2,18,3],[20,2,20,3],[16,2,16,3],[14,2,14,3],[3,14,3,15],[4,14,4,15],[3,3,3,6],[12,32,12,39],[12,25,12,29],[11,1,13,1],[11,15,12,15],[11,11,11,13],[11,6,12,6],[11,7,12,7],[11,2,11,5],[11,10,12,10],[12,4,13,4],[4,2,4,6],[11,8,12,8],[12,5,13,5],[11,9,12,9],[12,2,13,3]]}
[]
["(5/2010)"]
[]
[null,"Landowner:",null,null,null,null,null,null,"Designed by:",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2020-08-13"}]
[null,"County:",null,null,null,null,null,null,"Checked by:",null,null,null,null,"Date:"]
[]
[null,"Waterway Type:",null,null,null,null,null,null,"Retardance Values:"]
[null,null,null,null,null,null,null,null,"Capacity =",null,{"$f":"+Ret_Cap","v":"C"},null,"Stability = ",null,{"$f":"+Ret_Stab","v":"D"}]
[null,"Solve for:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AO15:AO22)=8,\"\",\"RECOMPUTE\")","v":""}]
[]
[null,"W/W       ID","Reach",null,null,null,"Design Q","Slope",{"$f":"IF(WW_Solve=\"Width\",\"Depth\", IF(WW_Type=\"Trapezoidal\",\"Bottom Width\",\"Top Width\"))","v":"Top Width"},{"$f":"IF(WW_Type = \"Trapezoidal\",\"Side Slope Ratio\", \" \")","v":" "},{"$f":"IF(WW_Solve=\"Depth\",\"Depth\",IF(WW_Type=\"Trapezoidal\",\"Bottom Width\",\"\"))","v":"Depth"},"Capacity",null,null,"Stability","Seed Area"]
[null,null,"Station",null," ","Station",null,null,null,null,null,"TW2","D2","V2","V1",null,null,null,null,null,null,null,null,null,null,"Goal Seek Values",null,null,null,null,null,"Compute","Values Used in Calculations",null,null,null,null,null,null,null,"Has been Recalc.?","Recalc.","TW1","D1","Parabolic Shape"]
[null,null,null,null,null,null,"(cfs)","(%)","(ft)",{"$f":"IF(WW_Type =\"Trapezoidal\",\"(Z:1)\", \" \")","v":" "},{"$f":"IF(WW_Solve=\"Depth\",\"(ft)\",IF(WW_Type=\"Trapezoidal\",\"(ft)\",\"\"))","v":"(ft)"},"(ft)","(ft)","(fps)","(fps)","(ac)",null,null,null,"n1","n2","q1act","q2act","VR1","VR2","D1","D2","TW1","TW2","BW",null,"Yes = 1","Des. Q","Slope","D/Wdth","SS","Type","Solve","Cap","Stab.","Yes = 1","Subset","(ft)","(ft)","Factor"]
[null,1,18,null,"to",132,26,7,26,null,{"$f":"IF(ISNUMBER(AF15),IF(WW_Solve=\"Depth\",M15,IF(WW_Type=\"Trapezoidal\",AD15,\"\")),\"\")","v":0.58707656666993235},{"$f":"IF(ISNUMBER(AF15),IF(WW_Type=\"Trapezoidal\",IF(WW_Solve=\"Depth\",$I15+2*$J15*M15,$K15+2*$J15*M15),IF(WW_Solve=\"Depth\",$I15,AC15)),\"\")","v":26},{"$f":"IF(ISNUMBER(AF15),IF(WW_Solve=\"Depth\",AA15,I15),\"\")","v":0.58707656666993235},{"$f":"IF(ISNUMBER(AO15),IF(ISNUMBER(AF15),IF(WW_Type = \"Parabolic\",$G15/AreaP(M15,L15),IF(WW_Solve = \"Depth\",$G15/AreaT(M15,$I15,$J15),$G15/AreaT(M15,$K15,$J15))),\"\"),\"*****\")","v":2.5550329976691675},{"$f":"IF(ISNUMBER(AO15),IF(ISNUMBER(AF15),IF(WW_Type = \"Parabolic\",$G15/AreaP(AR15,AQ15),IF(WW_Solve = \"Depth\",$G15/AreaT(AR15,$I15,$J15),$G15/AreaT(AR15,$K15,$J15))),\"\"),\"*****\")","v":3.3320758151557954},{"$f":"IF(ISNUMBER(AF15),L15*ABS(F15-C15)/43560,\"\")","v":6.8044077134986225E-2},null,null,null,{"$f":"EXP(VLOOKUP(Ret_Stab,Ret_Table,2)*(0.01329*LN(X15)^2-0.09543*LN(X15)+0.2971)-4.16)","v":5.6213338520510178E-2},{"$f":"EXP(VLOOKUP(Ret_Cap,Ret_Table,2)*(0.01329*LN(Y15)^2-0.09543*LN(Y15)+0.2971)-4.16)","v":8.2478589158608853E-2},{"$f":"IF(WW_Type=\"Parabolic\",ManningsQP(T15,AR15,AB15,H15),IF(WW_Solve=\"Depth\",ManningsQT($T15,$Z15,$I15,$J15,$H15),ManningsQT(T15,Z15,AD15,J15,H15)))","v":26.000069523334147},{"$f":"IF(WW_Type=\"Parabolic\",IF(WW_Solve=\"Depth\",ManningsQP(U15,AA15,L15,H15),ManningsQP(U15,M15,AC15,H15)),IF(WW_Solve=\"Depth\",ManningsQT(U15,AA15,I15,J15,H15),ManningsQT($U15,M15,AD15,J15,H15)))","v":26.000389053497365},{"$f":"IF(WW_Type=\"Parabolic\",VRP($G15,$AR15,$AB15),IF(WW_Solve=\"Depth\",VRT($G15,Z15,$I15,J15),VRT($G15,Z15,AD15,J15)))","v":1.0913022827692607},{"$f":"IF(WW_Type=\"Parabolic\",IF(WW_Solve=\"Depth\",VRP($G15,$AA15,$I15),VRP(G15,I15,AC15)),IF(WW_Solve=\"Depth\",VRT($G15,$AA15,$I15,$J15),VRT($G15,I15,AD15,J15)))","v":0.99864224484126196},1,0.58707656666993235,23.797640210934624,40,16,null,1,26,7,26,null,"Parabolic","Depth","C","D",{"$f":"IF(AG15=G15,IF(H15=AH15,IF(AI15=I15,IF(J15=AJ15,IF(ISNUMBER(AP15),1,\"\"),\"\"),\"\"),\"\"),\"\")","v":1},{"$f":"+IF(ISNUMBER(AF15),IF(AK15=WW_Type, IF(AL15=WW_Solve,IF(AM15=Ret_Cap,IF(AN15=Ret_Stab,1,\"\"),\"\"),\"\"),\"\"),1)","v":1},{"$f":"IF(ISNUMBER($AF15),IF(WW_Type=\"Trapezoidal\",IF(WW_Solve=\"Depth\",$I15+2*$J15*$AR15,$K15+2*$J15*$AR15),$AB15),\"\")","v":23.797640210934624},{"$f":"IF(ISNUMBER($AF15),IF(WW_Type = \"Trapezoidal\",$Z15,(AB15/AS15)^2),\"\")","v":0.49183093159031888},{"$f":"+L15/SQRT(M15)","v":33.933290501849427}]
[null,null,null,null,"to",null,null,null,null,null,"",{"$f":"IF(ISNUMBER(AF16),IF(WW_Type=\"Trapezoidal\",IF(WW_Solve=\"Depth\",$I16+2*$J16*M16,$K16+2*$J16*M16),IF(WW_Solve=\"Depth\",$I16,AC16)),\"\")","v":""},"","","",{"$f":"IF(ISNUMBER(AF16),L16*ABS(F16-C16)/43560,\"\")","v":""},null,null,null,{"$f":"EXP(VLOOKUP(Ret_Stab,Ret_Table,2)*(0.01329*LN(X16)^2-0.09543*LN(X16)+0.2971)-4.16)","v":{"$error":"#VALUE!"}},{"$f":"EXP(VLOOKUP(Ret_Cap,Ret_Table,2)*(0.01329*LN(Y16)^2-0.09543*LN(Y16)+0.2971)-4.16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,1.1841476846462002,46.947314398296626,40,16,null,null,null,null,null,null,null,null,null,null,1,{"$f":"+IF(ISNUMBER(AF16),IF(AK16=WW_Type, IF(AL16=WW_Solve,IF(AM16=Ret_Cap,IF(AN16=Ret_Stab,1,\"\"),\"\"),\"\"),\"\"),1)","v":1},"",{"$f":"IF(ISNUMBER($AF16),IF(WW_Type = \"Trapezoidal\",$Z16,(AB16/AS16)^2),\"\")","v":""},{"$f":"+L16/SQRT(M16)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"to",null,null,null,null,null,"","","","","","",null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,1.46690536100053,56.819693450955825,40,16,null,null,null,null,null,null,null,null,null,null,1,{"$f":"+IF(ISNUMBER(AF17),IF(AK17=WW_Type, IF(AL17=WW_Solve,IF(AM17=Ret_Cap,IF(AN17=Ret_Stab,1,\"\"),\"\"),\"\"),\"\"),1)","v":1},"","",{"$error":"#VALUE!"}]
[null,null,null,null,"to",null,null,null,null,null,"","","","","","",null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,0.58760172781365361,27.094090601143211,40,16,null,null,null,null,null,null,null,null,null,null,1,1,"","",{"$error":"#VALUE!"}]
[null,null,null,null,"to",null,null,null,null,null,"","","","","","",null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,0.75176526720539305,18.449036180716533,40,16,null,null,null,null,null,null,null,null,null,null,1,1,"","",{"$error":"#VALUE!"}]
[null,null,null,null,"to",null,null,null,null,null,"","","","","","",null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,0.59282513867387798,18.450803092653704,40,16,null,null,null,null,null,null,null,null,null,null,1,1,"","",{"$error":"#VALUE!"}]
[null,null,null,null,"to",null,null,null,null,null,"","","","","","",null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0.57118394291305363,1,40,40,34.84967939506533,null,null,null,null,null,null,null,null,null,null,1,1,"","",{"$error":"#VALUE!"}]
[null,null,null,null,"to",null,null,null,null,null,"","","","","","",null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0.48004731590723981,1,40,40,54.93164664201781,null,null,null,null,null,null,null,null,null,null,1,1,"","",{"$error":"#VALUE!"}]
[]
[null,null,"Total Waterway Length=",null,null,null,null,{"$f":"ABS(SUM(F15:F22)-SUM(C15:D22))","v":114},null,"feet",null,"Total Waterway Area = ",null,null,null,{"$f":"ROUNDUP(SUM(P15:P22),1)","v":0.1}]
[]
[null,"Warnings:"]
[null,{"$f":"+IF(ISNUMBER(N15),IF(N15<1.5,\"Velocity is less than 1.5 fps in Line 1\",IF(O15>5,\"Velocity is greater than 5 fps in Line 1\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N16),IF(N16<1.5,\"Velocity is less than 1.5 fps in Line 2\",IF(O16>5,\"Velocity is greater than 5 fps in Line 2\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N17),IF(N17<1.5,\"Velocity is less than 1.5 fps in Line 3\",IF(O17>5,\"Velocity is greater than 5 fps in Line 3\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N18),IF(N18<1.5,\"Velocity is less than 1.5 fps in Line 4\",IF(O18>5,\"Velocity is greater than 5 fps in Line 4\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N19),IF(N19<1.5,\"Velocity is less than 1.5 fps in Line 5\",IF(O19>5,\"Velocity is greater than 5 fps in Line 5\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N20),IF(N20<1.5,\"Velocity is less than 1.5 fps in Line 6\",IF(O20>5,\"Velocity is greater than 5 fps in Line 6\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N21),IF(N21<1.5,\"Velocity is less than 1.5 fps in Line 7\",IF(O21>5,\"Velocity is greater than 5 fps in Line 7\",\"\")),\"\")","v":""}]
[null,{"$f":"+IF(ISNUMBER(N22),IF(N22<1.5,\"Velocity is less than 1.5 fps in Line 8\",IF(O22>5,\"Velocity is greater than 5 fps in Line 8\",\"\")),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+A2","v":"(5/2010)"}]
[]
[null,"Landuser:",null,{"$f":"IF(ISBLANK(+D4),\"\",(D4))","v":""},"","","",null,"Designed by:",null,{"$f":"IF(ISBLANK(+K4),\"\",(K4))","v":""},{"$f":"IF(ISBLANK(+L4),\"\",(L4))","v":""},null,"Date:",{"$f":"TODAY()","v":"2020-08-13"}]
[null,"County:",{"$f":"IF(ISBLANK(+C5),\"\",(C5))","v":""},"","","","",null,"Checked by:",null,null,null,null,"Date:"]
[]
[null,"Waterway Type:",null,null,{"$f":"+WW_Type","v":"Parabolic"},null,null,null,"Retardance Values:"]
[null,null,null,null,null,null,null,null,"Capacity =",null,{"$f":"+Ret_Cap","v":"C"},null,"Stability = ",null,{"$f":"+Ret_Stab","v":"D"}]
[null,"Solve for:",null,null,{"$f":"+WW_Solve","v":"Depth"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(+J10),\"\",(J10))","v":""},{"$f":"IF(ISBLANK(+K10),\"\",(K10))","v":""},{"$f":"IF(ISBLANK(+L10),\"\",(L10))","v":""}]
[]
[null,"W/W       ID","Reach",null,null,null,"Design Q","Slope",{"$f":"IF(WW_Solve=\"Width\",\"Depth\", IF(WW_Type=\"Trapezoidal\",\"Bottom Width\",\"Top Width\"))","v":"Top Width"},{"$f":"IF(WW_Type = \"Trapezoidal\",\"Side Slope Ratio\", \" \")","v":" "},{"$f":"IF(WW_Solve=\"Depth\",\"Depth\",IF(WW_Type=\"Trapezoidal\",\"Bottom Width\",\"\"))","v":"Depth"},"Capacity",null,null,"Stability","Seed Area"]
[null,null,"Station",null," ","Station",null,null,null,null,null,"TW2","D2","V2","V1"]
[null,null,null,null,null,null,"(cfs)","(%)","(ft)",{"$f":"IF(WW_Type =\"Trapezoidal\",\"(Z:1)\", \" \")","v":" "},{"$f":"IF(WW_Solve=\"Depth\",\"(ft)\",IF(WW_Type=\"Trapezoidal\",\"(ft)\",\"\"))","v":"(ft)"},"(ft)","(ft)","(fps)","(fps)","(ac)"]
[null,{"$f":"IF(ISBLANK(+B15),\"\",(B15))","v":1},{"$f":"IF(ISBLANK(+C15),\"\",(C15))","v":18},{"$f":"IF(ISBLANK(+D15),\"\",(D15))","v":""},"to",{"$f":"IF(ISBLANK(+F15),\"\",(F15))","v":132},26,7,26,"",0.58707656666993235,26,0.58707656666993235,2.5550329976691675,3.3320758151557954,6.8044077134986225E-2]
[null,{"$f":"IF(ISBLANK(+B16),\"\",(B16))","v":""},"","","to","",{"$f":"IF(ISBLANK(+G16),\"\",(G16))","v":""},"","","","","","","","",""]
[null,"","","","to","","","","","","","","","","",""]
[null,"","","","to","","","","","","","","","","",""]
[null,"","","","to","","","","","","","","","","",""]
[null,"","","","to","","","","","","","","","","",""]
[null,"","","","to","","","","","","","","","","",""]
[null,"","","","to","","","","","","","","","","",""]
[]
[null,null,"Total Waterway Length=",null,null,null,null,{"$f":"IF(ISBLANK(+H24),\"\",(H24))","v":114},{"$f":"IF(ISBLANK(+I24),\"\",(I24))","v":""},"feet",null,"Total Waterway Area = ",null,null,null,{"$f":"IF(ISBLANK(+P24),\"\",(P24))","v":0.1}]
[]
[null,"Warnings:"]
[null,{"$f":"IF(ISBLANK(+B27),\"\",(B27))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Survey","index":1,"n_rows":49,"n_cols":31,"rows_kept":49,"cut":false,"hidden":false,"merged":[[8,24,9,24],[8,25,9,25],[5,14,5,15],[6,2,6,15],[9,27,9,30],[8,27,8,30],[5,2,5,11],[8,23,9,23],[3,2,3,5],[3,9,3,11],[3,14,3,15],[4,1,4,5],[4,9,4,11],[4,14,4,15]]}
[]
[]
[]
["Landuser:",null,{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""},null,null,null,null,"Designed by:",null,{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,null,"Date:",{"$f":"TODAY()","v":"2020-08-13"}]
["County:",{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,null,null,null,"Checked by:",null,null,null,null,null,"Date:"]
["Surveyed by:",null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
["TBM Descr.:"]
[]
["Station","BS","HI","FS","ELEV",null,null,null,null,null,null,null,"Centerline",null,null,null,null,null,null,null,null,"counter",null,"Station","Average Ground","Low Bank",null,"Low Bank"]
["TBM",null,{"$f":"IF(ISBLANK(A10),\"\",+E10+B10)","v":0},null,null,null,"RR","Offset","Elev","RR","Offset","Elev","RR","Elev","RR","Offset","Elev","RR","Offset","Elev","Comments",0,"lowbank",null,null,null,null,"Potentials"]
[null,null,{"$f":"IF(ISBLANK(A11),\"\",IF(ISNUMBER(B11),E11+B11,C10))","v":""},null,{"$f":"IF(ISBLANK(A11),\"\",IF(ISNUMBER(D11),C10-D11,E10))","v":""},null,null,null,{"$f":"IF(ISNUMBER(G11),IF(ISNUMBER($A11),$C11-G11,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(J11),IF(ISNUMBER($A11),$C11-J11,\"\"),\"\")","v":""},null,{"$f":"IF(ISNUMBER(M11),IF(ISNUMBER($A11),$C11-M11,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(O11),IF(ISNUMBER($A11),$C11-O11,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(R11),IF(ISNUMBER($A11),$C11-R11,\"\"),\"\")","v":""},null,{"$f":"+IF(ISNUMBER(OFFSET(A11,V10,0)),V10,IF(ISNUMBER(OFFSET(A11,V10+1,0)),V10+1,IF(ISNUMBER(OFFSET(A11,V10+2,0)),V10+2,V10+3)))","v":3},{"$f":"IF(MIN(AB11,AC11,AD11,AE11)>0,MIN(AB11,AC11,AD11,AE11),\"\")","v":""},{"$f":"IF(ISBLANK(OFFSET(A11,V11,0)),\"\",OFFSET(A11,V11,0))","v":""},{"$f":"IF(ISNUMBER(X11),VLOOKUP($X11,$A11:$W28,14,FALSE),\"\")","v":""},{"$f":"IF(ISNUMBER(X11),VLOOKUP($X11,$A11:$W28,23,FALSE),\"\")","v":""},null,{"$f":"+IF(H11>12,I11,\"\")","v":""},{"$f":"+IF(K11>12,L11,\"\")","v":""},{"$f":"+IF(P11>12,Q11,\"\")","v":""},{"$f":"+IF(S11>12,T11,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(A12),\"\",IF(ISNUMBER(B12),E12+B12,C11))","v":""},null,{"$f":"IF(ISBLANK(A12),\"\",IF(ISNUMBER(D12),C11-D12,E11))","v":""},null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,{"$f":"+IF(ISNUMBER(OFFSET(A12,V11,0)),V11,IF(ISNUMBER(OFFSET(A12,V11+1,0)),V11+1,IF(ISNUMBER(OFFSET(A12,V11+2,0)),V11+2,V11+3)))","v":6},"","","",{"$f":"IF(ISNUMBER(X12),VLOOKUP($X12,$A12:$W29,23,FALSE),\"\")","v":""},null,{"$f":"+IF(H12>12,I12,\"\")","v":""},{"$f":"+IF(K12>12,L12,\"\")","v":""},{"$f":"+IF(P12>12,Q12,\"\")","v":""},{"$f":"+IF(S12>12,T12,\"\")","v":""}]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,9,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,12,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,15,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,18,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,21,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,24,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,27,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,30,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,33,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,36,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,39,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,42,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,45,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,48,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,51,"","",{"$f":"IF(ISNUMBER(X27),VLOOKUP($X27,$A27:$V44,14,FALSE),\"\")","v":""},"",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,54,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,{"$f":"IF(ISNUMBER(G29),IF(ISNUMBER($A29),$C29-G29,\"\"),\"\")","v":""},null,null,"",null,"",null,null,{"$f":"IF(ISNUMBER(O29),IF(ISNUMBER($A29),$C29-O29,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(R29),IF(ISNUMBER($A29),$C29-R29,\"\"),\"\")","v":""},null,57,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,60,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,63,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,66,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,69,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,72,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,75,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,{"$f":"IF(ISNUMBER(J36),IF(ISNUMBER($A36),$C36-J36,\"\"),\"\")","v":""},null,"",null,null,"",null,null,"",null,78,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,81,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,84,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,87,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,90,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,93,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,96,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,99,"","","","",null,"","","",""]
[null,null,{"$f":"IF(ISBLANK(A44),\"\",IF(ISNUMBER(B44),E44+B44,C43))","v":""},null,{"$f":"IF(ISBLANK(A44),\"\",IF(ISNUMBER(D44),C43-D44,E43))","v":""},null,null,null,{"$f":"IF(ISNUMBER(G44),IF(ISNUMBER($A44),$C44-G44,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(J44),IF(ISNUMBER($A44),$C44-J44,\"\"),\"\")","v":""},null,"",null,null,{"$f":"IF(ISNUMBER(O44),IF(ISNUMBER($A44),$C44-O44,\"\"),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(R44),IF(ISNUMBER($A44),$C44-R44,\"\"),\"\")","v":""},null,{"$f":"+IF(ISNUMBER(OFFSET(A44,V43,0)),V43,IF(ISNUMBER(OFFSET(A44,V43+1,0)),V43+1,IF(ISNUMBER(OFFSET(A44,V43+2,0)),V43+2,V43+3)))","v":102},{"$f":"IF(MIN(AB44,AC44,AD44,AE44)>0,MIN(AB44,AC44,AD44,AE44),\"\")","v":""},{"$f":"IF(ISBLANK(OFFSET(A44,V44,0)),\"\",OFFSET(A44,V44,0))","v":""},"",{"$f":"IF(ISNUMBER(X44),VLOOKUP($X44,$A44:$W61,23,FALSE),\"\")","v":""},null,{"$f":"+IF(H44>12,I44,\"\")","v":""},{"$f":"+IF(K44>12,L44,\"\")","v":""},{"$f":"+IF(P44>12,Q44,\"\")","v":""},{"$f":"+IF(S44>12,T44,\"\")","v":""}]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,105,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,108,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,111,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,114,"","","","",null,"","","",""]
[null,null,"",null,"",null,null,null,"",null,null,"",null,"",null,null,"",null,null,"",null,117,"","","","",null,"","","",""]

{"sheet":"Cost Est.","index":2,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[15,0,15,2],[16,0,16,2],[17,0,17,2],[22,0,22,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[0,0,0,10],[14,0,14,2],[13,0,13,2],[7,6,7,8],[8,0,8,2],[1,0,1,10],[12,0,12,2],[3,9,3,10],[4,9,4,10],[3,4,3,5],[7,3,7,4],[7,0,7,2],[3,6,3,7],[4,6,4,7],[4,4,4,5],[9,0,9,2]]}
["Cost Estimate"]
["Grassed Waterway"]
[]
[null,"Landuser:",{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""},null,"Designed by:",null,{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,"Date:",{"$f":"TODAY()","v":"2020-08-13"}]
[null,"County:",{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,"Checked by:",null,null,null,"Date:"]
[]
[]
["Item",null,null,"Quantity",null,null,"Unit Cost",null,null,null,"Total Cost"]
["Waterway Construction",null,null,{"$f":"+Design!H24","v":114},"feet","@",null,"per","foot","=",{"$f":"+G9*D9","v":0}]
["Seeding/Mulching",null,null,{"$f":"+Design!P24","v":0.1},"acres","@",null,"per","acre","=",{"$f":"+G10*D10","v":0}]
[{"$f":"+'IN-ENG-14P'!C48","v":6},"-inch Plastic Drainage Tubing",null,{"$f":"+IF(ISNUMBER('IN-ENG-14P'!G48),'IN-ENG-14P'!G48,0)","v":1343},"feet","@",null,"per","foot","=",{"$f":"+G11*D11","v":0}]
[{"$f":"+'IN-ENG-14P'!C50","v":"---"},"-inch Plastic Drainage Tubing",null,{"$f":"+IF(ISNUMBER('IN-ENG-14P'!G50),'IN-ENG-14P'!G50,0)","v":0},"feet","@",null,"per","foot","=",{"$f":"+G12*D12","v":0}]
["Erosion Control Blanket/Mulch Netting",null,null,{"$f":"+IF(ISBLANK(Defaults!L14),\"--\",Defaults!L14)","v":0},"sq. yds.","@",null,"per","sq. yd.","=",{"$f":"+G13*D13","v":0}]
["Other:"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(A15),\"\",\"@\")","v":""},null,{"$f":"+IF(ISBLANK(A15),\"\",\"per\")","v":""},{"$f":"+IF(ISBLANK(E15),\"\",E15)","v":""},{"$f":"+IF(ISBLANK(A15),\"\",\"=\")","v":""},{"$f":"IF(ISBLANK(A15),\"\",+G15*D15)","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(A16),\"\",\"@\")","v":""},null,{"$f":"+IF(ISBLANK(A16),\"\",\"per\")","v":""},{"$f":"+IF(ISBLANK(E16),\"\",E16)","v":""},{"$f":"+IF(ISBLANK(A16),\"\",\"=\")","v":""},{"$f":"IF(ISBLANK(A16),\"\",+G16*D16)","v":""}]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,"",null,"","","",""]
[null,null,null,null,null,null,null,null,"Subtotal:",null,{"$f":"+SUM(K9:K23)","v":0}]
[]
[null,null,null,null,null,null,null,null,"+10%",null,{"$f":"+K24*0.1","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total:",null,{"$f":"CEILING(+K24+K26,100)","v":0}]

{"sheet":"IN-ENG-57L","index":3,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[39,0,49,0],[14,2,14,18],[15,5,15,17],[17,5,17,17],[21,2,21,7],[19,3,19,4],[19,5,19,11],[27,10,27,17],[41,11,41,16],[35,10,35,17],[37,10,37,17],[38,10,38,17],[22,2,27,8],[26,10,26,17],[36,10,36,17],[31,18,31,19],[6,1,6,19],[7,1,7,19],[12,1,12,19],[9,1,9,19],[11,3,11,5],[24,10,25,19],[38,18,38,19],[33,10,33,17],[29,18,29,19],[27,18,27,19],[30,10,30,17],[29,10,29,17],[37,18,37,19],[33,18,33,19],[32,18,32,19],[31,10,31,17],[32,10,32,17],[26,18,26,19],[28,18,28,19],[30,18,30,19],[34,18,34,19],[35,18,35,19],[36,18,36,19],[49,16,50,17],[48,2,48,5],[49,3,49,5],[28,1,28,8],[48,12,48,16],[47,11,47,16],[44,11,44,16],[42,12,42,16],[45,12,45,16],[34,10,34,17],[28,10,28,17],[45,3,45,5],[51,32,51,34],[38,5,38,7],[39,1,39,8],[48,21,48,26],[40,32,40,34],[45,30,45,37],[47,33,47,36],[48,34,48,36],[41,21,41,26],[42,22,42,26],[41,2,41,5],[42,3,42,5],[50,31,50,34],[44,21,44,26],[45,22,45,26]]}
[]
[]
[]
[]
[]
[]
[null,"U. S. DEPARTMENT OF AGRICULTURE"]
[null,"NATURAL RESOURCES CONSERVATION SERVICE"]
[]
[null,"IN COOPERATION WITH"]
[]
[null,null,null,{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,"COUNTY SOIL AND WATER CONSERVATION DISTRICT"]
[null,"INDIANA"]
[]
[null,null,"DETAIL PLANS FOR"]
[null,null,null,null,"(PRACTICE)","GRASSED WATERWAY"]
[]
[null,null,null,"(COOPERATOR)",null,"Boyers"]
[]
[null,null,null,"(LOCATION)",null,"WW1",null,null,null,null,null,null,"SEC.",null,"T",null,"R"]
[]
[null,null,"NOTICE TO THE COOPERATOR AND CONTRACTOR"]
[null,null,"NO REPRESENTATION IS MADE BY THE NATURAL RESOURCES CONSERVATION SERVICE AS TO THE EXISTENCE OR NONEXISTENCE OF UNDERGROUND HAZARDS.  AT LEAST 2 WORKING DAYS PRIOR TO THE START OF CONSTRUCTION, THE OWNERS OF PIPELINES OR OTHER UNDERGROUND UTILITIES MUST BE NOTIFIED OF THE PENDING CONSTRUCTION.  UTILITIES THAT PARTICIPATE WITH THE INDIANA UNDERGROUND PLANT PROTECTION SERVICES, INC., CAN BE NOTIFIED BY CALLING 1-800-382-5544, TOLL FREE or 811."]
[]
[null,null,null,null,null,null,null,null,null,null,"INDEX OF DRAWINGS"]
[]
[null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"SHEET NO."]
[null,null,null,null,null,null,null,null,null,null,"COVER SHEET",null,null,null,null,null,null,null,1]
[null,"CONSTRUCTION DATA"]
[null,null,"LAYOUT BY:"]
[null,null,null,null,null,null,"DATE:"]
[null,null,"CONTRACTOR NAME AND ADDRESS:"]
[]
[]
[]
[null,null,"CONSTRUCTION COMPLETED                (DATE):"]
[null,null,null,"NO CHANGES DURING CONSTRUCTION"]
[null,null,"AS-BUILTS SUBMITTED BY:"]
[null,null,null,null,"TITLE:"]
["DRAWING NO. IN-ENG-57L.XLS  (REVISED 5/08)","CONSTRUCTION APPROVAL SIGNATURES"]
[null,null,"CONSTRUCTION  (DOES)  (DOES NOT)  MEET STANDARDS & SPECIFICATIONS.",null,null,null,null,null,null,null,null,"PREPARED BY:"]
[null,null,null,null,null,null,"DATE:",null,null,null,null,{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,null,null,null,"DATE:",{"$f":"TODAY()","v":"2020-08-13"}]
[null,null,"TITLE:",null,null,null,null,null,null,null,null,"TITLE:"]
[null,null,"AS-BUILTS REVIEWED AND APPROVED BY:",null,null,null,null,null,null,null,null,"REVIEWED AND APPROVED BY:"]
[null,null,null,null,null,null,"DATE:",null,null,null,null,null,null,null,null,null,null,"DATE:"]
[null,null,"TITLE:",null,null,null,null,null,null,null,null,"TITLE:"]
[null,null,"ALL INSTALLATION REPORTS HAVE BEEN RECEIVED AND REVIEWED AND",null,null,null,null,null,null,null,null,"REVIEWED AND CONCURRED BY:"]
[null,null,"SEEDING HAS BEEN COMPLETED TO MEET STANDARDS & SPECIFICATIONS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[null,null,null,null,null,null,"DATE:",null,null,null,null,"TITLE:"]
[null,null,"TITLE:",null,null,null,null,null,null,null,null,null,null,null,null,null,"SHEET 1 OF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN-ENG-57L"]

{"sheet":"IN-ENG-42","index":4,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,14,53,14],[43,9,43,22],[16,19,16,22],[22,19,22,22],[21,19,21,22],[19,19,19,22],[3,11,3,12],[4,11,4,12],[3,13,3,18],[3,19,3,22],[41,9,41,22],[44,9,44,22],[45,9,45,22],[4,19,4,22],[5,19,5,22],[6,19,6,22],[7,19,7,22],[22,13,22,18],[10,8,10,10],[7,8,7,10],[6,8,6,10],[5,8,5,10],[10,19,10,22],[21,13,21,18],[0,1,0,22],[50,10,51,10],[46,10,47,10],[48,10,49,10],[52,10,53,10],[48,14,49,14],[50,11,51,12],[16,1,16,4],[17,1,17,4],[17,8,17,10],[17,11,17,12],[17,13,17,18],[2,8,2,10],[2,11,2,12],[6,11,6,12],[5,13,5,18],[6,13,6,18],[7,13,7,18],[8,8,8,10],[10,11,10,12],[10,13,10,18],[9,13,9,18],[8,11,8,12],[9,11,9,12],[39,0,53,0],[35,12,35,21],[12,1,12,22],[48,11,49,12],[37,12,37,21],[36,10,36,13],[15,19,15,22],[46,19,47,20],[17,19,17,22],[48,17,48,19],[16,8,16,10],[16,11,16,12],[50,17,50,19],[53,18,54,21],[50,14,51,14],[52,16,52,17],[42,9,42,22],[46,16,47,18],[20,19,20,22],[18,19,18,22],[16,13,16,18],[52,11,53,12],[52,18,52,21],[40,9,40,22],[9,1,9,4],[10,1,10,4],[9,8,9,10],[8,13,8,18],[2,13,2,18],[4,13,4,18],[7,11,7,12],[5,11,5,12],[14,19,14,22],[13,13,13,22],[8,19,8,22],[2,1,2,4],[2,19,2,22],[3,1,3,4],[4,1,4,4],[4,8,4,10],[3,8,3,10],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,19,9,22],[19,13,19,18],[14,13,14,18],[20,1,20,4],[20,8,20,10],[20,11,20,12],[20,13,20,18],[18,1,18,4],[18,8,18,10],[18,11,18,12],[18,13,18,18],[15,1,15,4],[15,8,15,10],[15,11,15,12],[15,13,15,18],[13,1,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,13,12],[44,2,44,4],[45,2,49,7],[50,5,51,5],[50,2,51,4],[14,8,14,10],[14,11,14,12],[22,1,22,4],[22,8,22,10],[22,11,22,12],[46,11,47,12],[21,1,21,4],[21,8,21,10],[21,11,21,12],[19,1,19,4],[19,8,19,10],[19,11,19,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,"LANDUSER",null,{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,null,"COUNTY SWCD, INDIANA"]
[null,null,null,null,null,null,null,null,null,null,"LOCATION",null,{"$f":"+IF(ISBLANK(Location),\"\",Location)","v":"WW1"}]
[null,null,null,null,null,null,null,null,null,null,null,"Sec.",{"$f":"+IF(ISBLANK(section),\"\",section)","v":""},null,"T",{"$f":"+IF(ISBLANK(Township),\"\",Township)","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(twp),\"\",twp)","v":""},null,"R",{"$f":"IF(ISBLANK(range),\"\",range)","v":""}]
["DRAWING NO. IN-ENG-42.XLS (REV. 8/99)"]
[null,null,null,null,null,null,null,null,null,"PLAN VIEW"]
[]
[]
[]
[null,null,"TBM Description:",null,null,null,null,null,null,"U.S. DEPARTMENT OF AGRICULTURE"]
[null,null,{"$f":"+IF(ISBLANK(Survey!C7),\"\",Survey!C7)","v":""},null,null,null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE"]
[null,null,null,null,null,null,null,null,null,null,"Designed",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,"Date",null,"Approved by",null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-08-13"}]
[null,null,null,null,null,null,null,null,null,null,"Drawn",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,{"$f":"TODAY()","v":"2020-08-13"},null,"Title"]
[]
[null,null,"TBM Elevation = ",null,null,{"$f":"+IF(ISBLANK(Survey!E10),\"\",Survey!E10)","v":""},null,null,null,null,"Traced",null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,null,null,null,null,"Checked",null,null,null,null,null,"Sheet",null,"Drawing No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN-ENG-42"]

{"sheet":"IN-ENG-14P","index":6,"n_rows":63,"n_cols":27,"rows_kept":63,"cut":false,"hidden":false,"merged":[[47,7,48,7],[49,7,50,7],[49,6,50,6],[55,13,56,14],[51,11,51,24],[52,11,52,24],[53,12,54,12],[55,12,56,12],[51,6,52,6],[53,7,56,7],[55,19,55,21],[0,1,1,24],[27,21,27,24],[12,21,12,24],[13,21,13,24],[11,21,11,24],[3,15,3,20],[21,21,21,23],[10,21,10,24],[7,21,7,24],[6,15,6,20],[22,21,22,24],[8,21,8,24],[20,13,20,14],[19,10,19,14],[17,1,18,24],[20,1,20,2],[19,3,19,5],[19,7,19,8],[10,15,10,20],[6,21,6,24],[7,15,7,20],[7,10,7,12],[2,15,2,20],[5,21,5,24],[3,21,3,24],[5,15,5,20],[2,21,2,24],[4,21,4,24],[4,15,4,20],[11,15,11,20],[13,15,13,20],[6,10,6,12],[6,13,6,14],[7,13,7,14],[8,15,8,20],[9,15,9,20],[11,13,11,14],[13,13,13,14],[8,13,8,14],[3,13,3,14],[19,15,19,24],[20,15,20,20],[23,21,23,24],[20,10,20,12],[9,21,9,24],[20,21,20,24],[15,5,15,22],[12,15,12,20],[12,13,12,14],[13,10,13,12],[22,13,22,14],[23,13,23,14],[21,15,21,20],[22,15,22,20],[23,15,23,20],[21,13,21,14],[13,7,13,8],[10,10,10,12],[9,10,9,12],[9,13,9,14],[24,21,24,24],[44,14,44,23],[43,12,43,15],[30,21,30,24],[29,10,29,12],[29,13,29,14],[29,15,29,20],[30,13,30,14],[24,15,24,20],[25,21,25,24],[25,15,25,20],[30,15,30,20],[29,21,29,24],[26,21,26,24],[27,15,27,20],[28,21,28,24],[30,10,30,12],[24,13,24,14],[25,13,25,14],[27,13,27,14],[26,13,26,14],[26,15,26,20],[59,13,60,14],[53,13,54,14],[28,15,28,20],[59,20,59,23],[57,19,57,21],[53,21,54,22],[59,16,60,16],[28,13,28,14],[42,14,42,23],[46,0,60,0],[60,20,61,23],[57,16,58,16],[59,18,59,19],[59,12,60,12],[57,12,58,12],[57,3,60,7],[51,2,52,5],[57,2,60,2],[51,7,52,7],[53,2,56,4],[53,5,56,6],[47,3,48,5],[47,2,48,2],[49,2,50,2],[47,11,50,24],[44,5,46,6],[44,7,46,7],[47,6,48,6],[49,3,50,5],[44,2,46,4],[57,13,58,14],[55,16,56,16],[53,18,54,20],[7,7,7,8],[11,10,11,12],[2,13,2,14],[10,13,10,14],[12,10,12,12],[11,7,11,8],[12,7,12,8],[2,1,2,2],[2,10,2,12],[4,10,4,12],[3,1,3,2],[2,7,2,8],[3,10,3,12],[3,7,3,8],[4,7,4,8],[7,1,7,2],[2,3,2,5],[5,1,5,2],[4,13,4,14],[5,13,5,14],[5,10,5,12],[4,1,4,2],[5,7,5,8],[6,1,6,2],[6,7,6,8],[9,7,9,8],[12,1,12,2],[8,7,8,8],[8,10,8,12],[10,7,10,8],[28,7,28,8],[27,7,27,8],[21,7,21,8],[22,7,22,8],[10,1,10,2],[11,1,11,2],[28,10,28,12],[27,10,27,12],[25,10,25,12],[21,10,21,12],[26,10,26,12],[24,10,24,12],[22,10,22,12],[23,10,23,12],[13,1,13,2],[19,1,19,2],[20,7,20,8],[8,1,8,2],[9,1,9,2],[42,1,43,8],[23,1,23,2],[30,1,30,2],[27,1,27,2],[30,7,30,8],[23,7,23,8],[29,7,29,8],[26,7,26,8],[24,7,24,8],[25,7,25,8],[29,1,29,2],[26,1,26,2],[28,1,28,2],[24,1,24,2],[25,1,25,2]]}
[null,"CONSTRUCTION DATA"]
[]
[null,"W/W",null,"Reach",null,null,"Length","Grade",null,"Design","Design",null,null,"Seeding "]
[null,"ID",null,null,null,null,null,null,null,"Depth","Top Width",null,null,"Width"]
[null,null,null,null,null,null,null,null,null,"(D)","(T)"]
[null,null,null,"Sta.",null,"Sta.","feet","%",null,"feet","feet",null,null,"feet"]
[null,{"$f":"IF(ISBLANK(Design!B15),\"\",Design!B15)","v":1},null,{"$f":"IF(ISBLANK(Design!C15),\"\",Design!C15)","v":18},"to",{"$f":"IF(ISBLANK(Design!F15),\"\",Design!F15)","v":132},{"$f":"IF(ISBLANK(Design!C15),\"\",ABS(Design!F15-Design!C15))","v":114},{"$f":"IF(ISBLANK(Design!H15),\"\",Design!H15)","v":7},null,{"$f":"IF(ISBLANK(Design!M15),\"\",Design!M15)","v":0.58707656666993235},{"$f":"IF(ISBLANK(Design!L15),\"\",Design!L15)","v":26},null,null,{"$f":"IF(ISBLANK(K7),\"\",K7)","v":26},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N7),G7*N7,\"\")","v":2964}]
[null,{"$f":"IF(ISBLANK(Design!B16),\"\",Design!B16)","v":""},null,{"$f":"IF(ISBLANK(Design!C16),\"\",Design!C16)","v":""},"to",{"$f":"IF(ISBLANK(Design!F16),\"\",Design!F16)","v":""},{"$f":"IF(ISBLANK(Design!C16),\"\",ABS(Design!F16-Design!C16))","v":""},{"$f":"IF(ISBLANK(Design!H16),\"\",Design!H16)","v":""},null,{"$f":"IF(ISBLANK(Design!M16),\"\",Design!M16)","v":""},{"$f":"IF(ISBLANK(Design!L16),\"\",Design!L16)","v":""},null,null,{"$f":"IF(ISBLANK(K8),\"\",K8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N8),G8*N8,\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(Design!B17),\"\",Design!B17)","v":""},null,{"$f":"IF(ISBLANK(Design!C17),\"\",Design!C17)","v":""},"to",{"$f":"IF(ISBLANK(Design!F17),\"\",Design!F17)","v":""},{"$f":"IF(ISBLANK(Design!C17),\"\",ABS(Design!F17-Design!C17))","v":""},{"$f":"IF(ISBLANK(Design!H17),\"\",Design!H17)","v":""},null,{"$f":"IF(ISBLANK(Design!M17),\"\",Design!M17)","v":""},{"$f":"IF(ISBLANK(Design!L17),\"\",Design!L17)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B18),\"\",Design!B18)","v":""},null,{"$f":"IF(ISBLANK(Design!C18),\"\",Design!C18)","v":""},"to",{"$f":"IF(ISBLANK(Design!F18),\"\",Design!F18)","v":""},{"$f":"IF(ISBLANK(Design!C18),\"\",ABS(Design!F18-Design!C18))","v":""},{"$f":"IF(ISBLANK(Design!H18),\"\",Design!H18)","v":""},null,{"$f":"IF(ISBLANK(Design!M18),\"\",Design!M18)","v":""},{"$f":"IF(ISBLANK(Design!L18),\"\",Design!L18)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B19),\"\",Design!B19)","v":""},null,{"$f":"IF(ISBLANK(Design!C19),\"\",Design!C19)","v":""},"to",{"$f":"IF(ISBLANK(Design!F19),\"\",Design!F19)","v":""},{"$f":"IF(ISBLANK(Design!C19),\"\",ABS(Design!F19-Design!C19))","v":""},{"$f":"IF(ISBLANK(Design!H19),\"\",Design!H19)","v":""},null,{"$f":"IF(ISBLANK(Design!M19),\"\",Design!M19)","v":""},{"$f":"IF(ISBLANK(Design!L19),\"\",Design!L19)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B20),\"\",Design!B20)","v":""},null,{"$f":"IF(ISBLANK(Design!C20),\"\",Design!C20)","v":""},"to",{"$f":"IF(ISBLANK(Design!F20),\"\",Design!F20)","v":""},{"$f":"IF(ISBLANK(Design!C20),\"\",ABS(Design!F20-Design!C20))","v":""},{"$f":"IF(ISBLANK(Design!H20),\"\",Design!H20)","v":""},null,{"$f":"IF(ISBLANK(Design!M20),\"\",Design!M20)","v":""},{"$f":"IF(ISBLANK(Design!L20),\"\",Design!L20)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B21),\"\",Design!B21)","v":""},null,{"$f":"IF(ISBLANK(Design!C21),\"\",Design!C21)","v":""},"to",{"$f":"IF(ISBLANK(Design!F21),\"\",Design!F21)","v":""},{"$f":"IF(ISBLANK(Design!C21),\"\",ABS(Design!F21-Design!C21))","v":""},{"$f":"IF(ISBLANK(Design!H21),\"\",Design!H21)","v":""},null,{"$f":"IF(ISBLANK(Design!M21),\"\",Design!M21)","v":""},{"$f":"IF(ISBLANK(Design!L21),\"\",Design!L21)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B22),\"\",Design!B22)","v":""},null,{"$f":"IF(ISBLANK(Design!C22),\"\",Design!C22)","v":""},"to",{"$f":"IF(ISBLANK(Design!F22),\"\",Design!F22)","v":""},{"$f":"IF(ISBLANK(Design!C22),\"\",ABS(Design!F22-Design!C22))","v":""},{"$f":"IF(ISBLANK(Design!H22),\"\",Design!H22)","v":""},null,{"$f":"IF(ISBLANK(Design!M22),\"\",Design!M22)","v":""},{"$f":"IF(ISBLANK(Design!L22),\"\",Design!L22)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,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":"SUM(AA7:AA14)/43560","v":6.8044077134986225E-2}]
[null,null,"Describe Outlet:",null,null,"riprap"]
[]
[null,"AS-BUILT DATA"]
[]
[null,"W/W",null,"Reach",null,null,"Length","Grade",null,"Average","Waterway Width",null,null,null,null,"Waterway Area"]
[null,"ID",null,null,null,null,null,null,null,"Depth","Const.",null,null,"Seeded",null,"Const.",null,null,null,null,null,"Seeded"]
[]
[null,null,null,"Sta.",null,"Sta.","feet","%",null,"feet","feet",null,null,"feet",null,"acres",null,null,null,null,null,"acres"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ESTIMATED QUANTITIES",null,null,null,null,null,null,null,null,null,null,"LANDUSER",null,{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,null,"COUNTY SWCD, INDIANA"]
[null,null,"Grassed Waterway:",null,null,{"$f":"+SUM(G7:G14)","v":114},null,"feet",null,null,null,null,"LOCATION",null,{"$f":"+IF(ISBLANK(Location),\"\",Location)","v":"WW1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sec.",{"$f":"+IF(ISBLANK(section),\"\",section)","v":""},null,"T",{"$f":"+IF(ISBLANK(Township),\"\",Township)","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(twp),\"\",twp)","v":""},null,"R",{"$f":"IF(ISBLANK(range),\"\",range)","v":""}]
["DRAWING NO. IN-ENG-14P.XLS (REV. 8/99)"]
[null,null,{"$f":"+IF(Defaults!I41>0,Defaults!H41,\"---\")","v":6},"-in. Drainage Tubing:",null,null,{"$f":"+IF(Defaults!I41>0,Defaults!I41,\"---\")","v":1343},"feet",null,null,null,"GRASSED WATERWAY"]
[]
[null,null,{"$f":"IF(Defaults!H42=Defaults!H41,\"---\",IF(Defaults!I41=0,\"---\",Defaults!H42))","v":"---"},"-in. Drainage Tubing:",null,null,{"$f":"IF(Defaults!H42=Defaults!H41,\"---\",IF(Defaults!I41=0,\"---\",Defaults!I42))","v":"---"},"feet"]
[]
[null,null,"Mulch Netting/Blanket:",null,null,null,{"$f":"1.1*SUM(Defaults!L5:L12)","v":0},"sq. yd.",null,null,null,"U.S. DEPARTMENT OF AGRICULTURE"]
[null,null,null,null,null,null,null,null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE"]
[null,null,"Seeding/Mulching:",null,null,{"$f":"AA15","v":6.8044077134986225E-2},null,"acres",null,null,null,null,"Designed",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,"Date",null,"Approved by",null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-08-13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Drawn",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,{"$f":"TODAY()","v":"2020-08-13"},null,"Title"]
[]
[null,null,"Other:",null,null,null,null,null,null,null,null,null,"Traced",null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Checked",null,null,null,null,null,"Sheet",null,"Drawing No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN-ENG-14P"]

{"sheet":"IN-ENG-14T","index":7,"n_rows":63,"n_cols":27,"rows_kept":63,"cut":false,"hidden":false,"merged":[[46,0,60,0],[15,5,15,22],[47,11,50,24],[47,3,48,5],[47,6,48,6],[47,7,48,7],[49,2,50,2],[49,3,50,5],[49,6,50,6],[53,2,56,4],[57,2,60,2],[51,2,52,5],[57,3,60,7],[51,6,52,6],[51,7,52,7],[53,5,56,6],[53,7,56,7],[42,1,43,8],[44,2,46,4],[44,5,46,6],[44,7,46,7],[49,7,50,7],[47,2,48,2],[30,7,30,8],[0,1,1,24],[17,1,18,24],[2,10,2,12],[3,10,3,12],[4,10,4,12],[5,10,5,12],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[7,7,7,8],[8,7,8,8],[11,15,11,20],[12,15,12,20],[11,13,11,14],[12,13,12,14],[11,10,11,12],[6,7,6,8],[7,10,7,12],[8,10,8,12],[7,13,7,14],[10,10,10,12],[3,13,3,14],[11,1,11,2],[30,1,30,2],[28,7,28,8],[29,7,29,8],[22,10,22,12],[21,7,21,8],[20,10,20,12],[13,10,13,12],[20,7,20,8],[19,1,19,2],[20,1,20,2],[13,7,13,8],[24,7,24,8],[25,7,25,8],[22,7,22,8],[23,7,23,8],[23,1,23,2],[24,1,24,2],[25,1,25,2],[27,10,27,12],[26,1,26,2],[26,7,26,8],[26,10,26,12],[27,7,27,8],[27,1,27,2],[7,21,7,24],[8,21,8,24],[9,21,9,24],[10,21,10,24],[11,21,11,24],[12,21,12,24],[13,21,13,24],[28,1,28,2],[29,1,29,2],[13,13,13,14],[13,15,13,20],[10,15,10,20],[7,15,7,20],[9,15,9,20],[8,13,8,14],[9,13,9,14],[8,15,8,20],[12,1,12,2],[13,1,13,2],[9,1,9,2],[9,10,9,12],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[10,13,10,14],[2,3,2,5],[2,1,2,2],[4,1,4,2],[5,1,5,2],[7,1,7,2],[19,7,19,8],[10,1,10,2],[12,10,12,12],[8,1,8,2],[6,1,6,2],[3,1,3,2],[19,3,19,5],[57,12,58,12],[55,12,56,12],[59,13,60,14],[57,19,57,21],[26,21,26,24],[26,15,26,20],[42,14,42,23],[28,10,28,12],[55,19,55,21],[60,20,61,23],[57,16,58,16],[59,18,59,19],[59,20,59,23],[44,14,44,23],[59,12,60,12],[55,16,56,16],[59,16,60,16],[55,13,56,14],[57,13,58,14],[53,13,54,14],[53,18,54,20],[53,12,54,12],[53,21,54,22],[43,12,43,15],[20,21,20,24],[26,13,26,14],[30,21,30,24],[51,11,51,24],[52,11,52,24],[19,15,19,24],[24,15,24,20],[22,21,22,24],[22,13,22,14],[23,21,23,24],[21,10,21,12],[24,21,24,24],[21,21,21,23],[20,13,20,14],[20,15,20,20],[19,10,19,14],[24,10,24,12],[25,10,25,12],[23,10,23,12],[21,13,21,14],[29,13,29,14],[29,15,29,20],[30,10,30,12],[21,15,21,20],[2,21,2,24],[6,10,6,12],[6,13,6,14],[6,21,6,24],[2,15,2,20],[2,13,2,14],[3,15,3,20],[6,15,6,20],[4,13,4,14],[5,13,5,14],[5,15,5,20],[4,21,4,24],[5,21,5,24],[3,21,3,24],[4,15,4,20],[29,10,29,12],[22,15,22,20],[28,13,28,14],[28,15,28,20],[28,21,28,24],[27,21,27,24],[25,13,25,14],[25,15,25,20],[30,13,30,14],[30,15,30,20],[23,13,23,14],[24,13,24,14],[29,21,29,24],[23,15,23,20],[25,21,25,24],[27,13,27,14],[27,15,27,20]]}
[null,"CONSTRUCTION DATA"]
[]
[null,"W/W",null,"Reach",null,null,"Length","Grade",null,"Design","Design",null,null,"Bottom",null,"Side Slope",null,null,null,null,null,"Seeding"]
[null,"ID",null,null,null,null,null,null,null,"Depth","Top Width",null,null,"Width",null,"Ratio",null,null,null,null,null,"Width"]
[null,null,null,null,null,null,null,null,null,"(D)","(T)",null,null,"(B)"]
[null,null,null,"Sta.",null,"Sta.","feet","%",null,"feet","feet",null,null,"feet",null,"Z:1",null,null,null,null,null,"feet"]
[null,{"$f":"IF(ISBLANK(Design!B15),\"\",Design!B15)","v":1},null,{"$f":"IF(ISBLANK(Design!C15),\"\",Design!C15)","v":18},"to",{"$f":"IF(ISBLANK(Design!F15),\"\",Design!F15)","v":132},{"$f":"IF(ISBLANK(Design!C15),\"\",ABS(Design!F15-Design!C15))","v":114},{"$f":"IF(ISBLANK(Design!H15),\"\",Design!H15)","v":7},null,{"$f":"IF(ISBLANK(Design!M15),\"\",Design!M15)","v":0.58707656666993235},{"$f":"IF(ISBLANK(Design!L15),\"\",Design!L15)","v":26},null,null,{"$f":"IF(ISBLANK(Design!I15),\"\",IF(WW_Solve=\"Depth\",Design!I15,Design!K15))","v":26},null,{"$f":"IF(ISBLANK(Design!J15),\"\",Design!J15)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(K7),\"\",K7)","v":26},null,null,null,null,{"$f":"IF(ISNUMBER(V7),V7*G7,\"\")","v":2964}]
[null,{"$f":"IF(ISBLANK(Design!B16),\"\",Design!B16)","v":""},null,{"$f":"IF(ISBLANK(Design!C16),\"\",Design!C16)","v":""},"to",{"$f":"IF(ISBLANK(Design!F16),\"\",Design!F16)","v":""},{"$f":"IF(ISBLANK(Design!C16),\"\",ABS(Design!F16-Design!C16))","v":""},{"$f":"IF(ISBLANK(Design!H16),\"\",Design!H16)","v":""},null,{"$f":"IF(ISBLANK(Design!M16),\"\",Design!M16)","v":""},{"$f":"IF(ISBLANK(Design!L16),\"\",Design!L16)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I16),\"\",IF(WW_Solve=\"Depth\",Design!I16,Design!K16))","v":""},null,{"$f":"IF(ISBLANK(Design!J16),\"\",Design!J16)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(K8),\"\",K8)","v":""},null,null,null,null,{"$f":"IF(ISNUMBER(V8),V8*G8,\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(Design!B17),\"\",Design!B17)","v":""},null,{"$f":"IF(ISBLANK(Design!C17),\"\",Design!C17)","v":""},"to",{"$f":"IF(ISBLANK(Design!F17),\"\",Design!F17)","v":""},{"$f":"IF(ISBLANK(Design!C17),\"\",ABS(Design!F17-Design!C17))","v":""},{"$f":"IF(ISBLANK(Design!H17),\"\",Design!H17)","v":""},null,{"$f":"IF(ISBLANK(Design!M17),\"\",Design!M17)","v":""},{"$f":"IF(ISBLANK(Design!L17),\"\",Design!L17)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I17),\"\",IF(WW_Solve=\"Depth\",Design!I17,Design!K17))","v":""},null,{"$f":"IF(ISBLANK(Design!J17),\"\",Design!J17)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(K9),\"\",K9)","v":""},null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B18),\"\",Design!B18)","v":""},null,{"$f":"IF(ISBLANK(Design!C18),\"\",Design!C18)","v":""},"to",{"$f":"IF(ISBLANK(Design!F18),\"\",Design!F18)","v":""},{"$f":"IF(ISBLANK(Design!C18),\"\",ABS(Design!F18-Design!C18))","v":""},{"$f":"IF(ISBLANK(Design!H18),\"\",Design!H18)","v":""},null,{"$f":"IF(ISBLANK(Design!M18),\"\",Design!M18)","v":""},{"$f":"IF(ISBLANK(Design!L18),\"\",Design!L18)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I18),\"\",IF(WW_Solve=\"Depth\",Design!I18,Design!K18))","v":""},null,{"$f":"IF(ISBLANK(Design!J18),\"\",Design!J18)","v":""},null,null,null,null,null,"",null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B19),\"\",Design!B19)","v":""},null,{"$f":"IF(ISBLANK(Design!C19),\"\",Design!C19)","v":""},"to",{"$f":"IF(ISBLANK(Design!F19),\"\",Design!F19)","v":""},{"$f":"IF(ISBLANK(Design!C19),\"\",ABS(Design!F19-Design!C19))","v":""},{"$f":"IF(ISBLANK(Design!H19),\"\",Design!H19)","v":""},null,{"$f":"IF(ISBLANK(Design!M19),\"\",Design!M19)","v":""},{"$f":"IF(ISBLANK(Design!L19),\"\",Design!L19)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I19),\"\",IF(WW_Solve=\"Depth\",Design!I19,Design!K19))","v":""},null,{"$f":"IF(ISBLANK(Design!J19),\"\",Design!J19)","v":""},null,null,null,null,null,"",null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B20),\"\",Design!B20)","v":""},null,{"$f":"IF(ISBLANK(Design!C20),\"\",Design!C20)","v":""},"to",{"$f":"IF(ISBLANK(Design!F20),\"\",Design!F20)","v":""},{"$f":"IF(ISBLANK(Design!C20),\"\",ABS(Design!F20-Design!C20))","v":""},{"$f":"IF(ISBLANK(Design!H20),\"\",Design!H20)","v":""},null,{"$f":"IF(ISBLANK(Design!M20),\"\",Design!M20)","v":""},{"$f":"IF(ISBLANK(Design!L20),\"\",Design!L20)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I20),\"\",IF(WW_Solve=\"Depth\",Design!I20,Design!K20))","v":""},null,{"$f":"IF(ISBLANK(Design!J20),\"\",Design!J20)","v":""},null,null,null,null,null,"",null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B21),\"\",Design!B21)","v":""},null,{"$f":"IF(ISBLANK(Design!C21),\"\",Design!C21)","v":""},"to",{"$f":"IF(ISBLANK(Design!F21),\"\",Design!F21)","v":""},{"$f":"IF(ISBLANK(Design!C21),\"\",ABS(Design!F21-Design!C21))","v":""},{"$f":"IF(ISBLANK(Design!H21),\"\",Design!H21)","v":""},null,{"$f":"IF(ISBLANK(Design!M21),\"\",Design!M21)","v":""},{"$f":"IF(ISBLANK(Design!L21),\"\",Design!L21)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I21),\"\",IF(WW_Solve=\"Depth\",Design!I21,Design!K21))","v":""},null,{"$f":"IF(ISBLANK(Design!J21),\"\",Design!J21)","v":""},null,null,null,null,null,"",null,null,null,null,""]
[null,{"$f":"IF(ISBLANK(Design!B22),\"\",Design!B22)","v":""},null,{"$f":"IF(ISBLANK(Design!C22),\"\",Design!C22)","v":""},"to",{"$f":"IF(ISBLANK(Design!F22),\"\",Design!F22)","v":""},{"$f":"IF(ISBLANK(Design!C22),\"\",ABS(Design!F22-Design!C22))","v":""},{"$f":"IF(ISBLANK(Design!H22),\"\",Design!H22)","v":""},null,{"$f":"IF(ISBLANK(Design!M22),\"\",Design!M22)","v":""},{"$f":"IF(ISBLANK(Design!L22),\"\",Design!L22)","v":""},null,null,{"$f":"IF(ISBLANK(Design!I22),\"\",IF(WW_Solve=\"Depth\",Design!I22,Design!K22))","v":""},null,{"$f":"IF(ISBLANK(Design!J22),\"\",Design!J22)","v":""},null,null,null,null,null,"",null,null,null,null,""]
[null,null,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":"SUM(AA7:AA14)/43560","v":6.8044077134986225E-2}]
[null,null,"Describe Outlet:",null,null,{"$f":"IF(ISBLANK('IN-ENG-14P'!F16:W16),\"\",'IN-ENG-14P'!F16:W16)","v":"riprap"}]
[]
[null,"AS-BUILT DATA"]
[]
[null,"W/W",null,"Reach",null,null,"Length","Grade",null,"Average","Waterway Width",null,null,null,null,"Waterway Area"]
[null,"ID",null,null,null,null,null,null,null,"Depth","Const.",null,null,"Seeded",null,"Const.",null,null,null,null,null,"Seeded"]
[]
[null,null,null,"Sta.",null,"Sta.","feet","%",null,"feet","feet",null,null,"feet",null,"acres",null,null,null,null,null,"acres"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[null,null,null,null,"to"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ESTIMATED QUANTITIES",null,null,null,null,null,null,null,null,null,null,"LANDUSER",null,{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,null,"COUNTY SWCD, INDIANA"]
[null,null,"Grassed Waterway:",null,null,{"$f":"+SUM(G7:G14)","v":114},null,"feet",null,null,null,null,"LOCATION",null,{"$f":"+IF(ISBLANK(Location),\"\",Location)","v":"WW1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sec.",{"$f":"+IF(ISBLANK(section),\"\",section)","v":""},null,"T",{"$f":"+IF(ISBLANK(Township),\"\",Township)","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(twp),\"\",twp)","v":""},null,"R",{"$f":"IF(ISBLANK(range),\"\",range)","v":""}]
["DRAWING NO. IN-ENG-14T.XLS (REV. 8/99)"]
[null,null,{"$f":"+IF(Defaults!I41>0,Defaults!H41,\"---\")","v":6},"-in. Drainage Tubing:",null,null,{"$f":"+IF(Defaults!I41>0,Defaults!I41,\"---\")","v":1343},"feet",null,null,null,"GRASSED WATERWAY"]
[]
[null,null,{"$f":"IF(Defaults!H42=Defaults!H41,\"---\",IF(Defaults!I41=0,\"---\",Defaults!H42))","v":"---"},"-in. Drainage Tubing:",null,null,{"$f":"IF(Defaults!H42=Defaults!H41,\"---\",IF(Defaults!I41=0,\"---\",Defaults!I42))","v":"---"},"feet"]
[]
[null,null,"Mulch Netting/Blanket:",null,null,null,{"$f":"+'IN-ENG-14P'!G52:G53","v":0},"sq. yd.",null,null,null,"U.S. DEPARTMENT OF AGRICULTURE"]
[null,null,null,null,null,null,null,null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE"]
[null,null,"Seeding/Mulching:",null,null,{"$f":"AA15","v":6.8044077134986225E-2},null,"acres",null,null,null,null,"Designed",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,"Date",null,"Approved by",null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-08-13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Drawn",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,{"$f":"TODAY()","v":"2020-08-13"},null,"Title"]
[]
[null,null,"Other:",{"$f":"+IF(ISBLANK('IN-ENG-14P'!D58:H61),\"\",'IN-ENG-14P'!D58:H61)","v":""},null,null,null,null,null,null,null,null,"Traced",null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Checked",null,null,null,null,null,"Sheet",null,"Drawing No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN-ENG-14T"]

{"sheet":"DWA","index":8,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[39,0,53,0],[40,9,40,22],[41,9,41,22],[42,9,42,22],[43,9,43,22],[44,2,44,4],[44,9,44,22],[45,2,49,7],[45,9,45,22],[46,10,47,10],[46,11,47,12],[46,16,47,18],[46,19,47,20],[48,10,49,10],[48,11,49,12],[48,14,49,14],[48,17,48,19],[52,10,53,10],[52,11,53,12],[52,14,53,14],[52,16,52,17],[52,18,52,21],[53,18,54,21],[50,2,51,4],[22,1,22,4],[22,8,22,10],[22,11,22,12],[22,13,22,18],[22,19,22,22],[35,12,35,21],[50,5,51,5],[50,10,51,10],[50,11,51,12],[50,14,51,14],[50,17,50,19],[36,10,36,13],[37,12,37,21],[20,1,20,4],[20,8,20,10],[20,11,20,12],[20,13,20,18],[20,19,20,22],[21,1,21,4],[21,8,21,10],[21,11,21,12],[21,13,21,18],[21,19,21,22],[18,1,18,4],[18,8,18,10],[18,11,18,12],[18,13,18,18],[18,19,18,22],[19,1,19,4],[19,8,19,10],[19,11,19,12],[19,13,19,18],[19,19,19,22],[16,1,16,4],[16,8,16,10],[16,11,16,12],[16,13,16,18],[16,19,16,22],[17,1,17,4],[17,8,17,10],[17,11,17,12],[17,13,17,18],[17,19,17,22],[14,19,14,22],[15,1,15,4],[15,8,15,10],[15,11,15,12],[15,13,15,18],[15,19,15,22],[12,1,12,22],[13,1,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,13,12],[13,13,13,22],[14,8,14,10],[14,11,14,12],[14,13,14,18],[9,1,9,4],[9,8,9,10],[9,11,9,12],[9,13,9,18],[9,19,9,22],[10,1,10,4],[10,8,10,10],[10,11,10,12],[10,13,10,18],[10,19,10,22],[6,11,6,12],[6,13,6,18],[6,19,6,22],[7,1,7,4],[7,8,7,10],[7,11,7,12],[7,13,7,18],[7,19,7,22],[8,1,8,4],[8,8,8,10],[8,11,8,12],[8,13,8,18],[8,19,8,22],[0,1,0,22],[2,1,2,4],[2,8,2,10],[2,11,2,12],[2,13,2,18],[2,19,2,22],[24,3,33,19],[3,1,3,4],[3,8,3,10],[3,11,3,12],[3,13,3,18],[3,19,3,22],[4,1,4,4],[4,8,4,10],[4,11,4,12],[4,13,4,18],[4,19,4,22],[5,1,5,4],[5,8,5,10],[5,11,5,12],[5,13,5,18],[5,19,5,22],[6,1,6,4],[6,8,6,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A fallow, mowed, or disked area shall be left on both sides of the waterway as shown.  This area shall be used by the contractor to spread excess spoil.  Spoil shall be spread in such a way as to ensure all water runoff will enter the constructed waterway practice without restriction. All spoil shall be temporarily seeded or planted to a crop."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,"LANDUSER",null,{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,null,"COUNTY SWCD, INDIANA"]
[null,null,null,null,null,null,null,null,null,null,"LOCATION",null,{"$f":"+IF(ISBLANK(Location),\"\",Location)","v":"WW1"}]
[null,null,null,null,null,null,null,null,null,null,null,"Sec.",{"$f":"+IF(ISBLANK(section),\"\",section)","v":""},null,"T",{"$f":"+IF(ISBLANK(Township),\"\",Township)","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(twp),\"\",twp)","v":""},null,"R",{"$f":"IF(ISBLANK(range),\"\",range)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"Designated Work Area"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"U.S. DEPARTMENT OF AGRICULTURE"]
[null,null,{"$f":"+IF(ISBLANK(Survey!C7),\"\",Survey!C7)","v":""},null,null,null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE"]
[null,null,null,null,null,null,null,null,null,null,"Designed",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,"Date",null,"Approved by",null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-08-13"}]
[null,null,null,null,null,null,null,null,null,null,"Drawn",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,{"$f":"TODAY()","v":"2020-08-13"},null,"Title"]
[]
[null,null,null,null,null,{"$f":"+IF(ISBLANK(Survey!E10),\"\",Survey!E10)","v":""},null,null,null,null,"Traced",null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,null,null,null,null,"Checked",null,null,null,null,null,"Sheet",null,"Drawing No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN-ENG-42"]

{"sheet":"Specs","index":9,"n_rows":72,"n_cols":24,"rows_kept":72,"cut":false,"hidden":false,"merged":[[46,10,46,22],[42,15,42,17],[42,18,42,20],[38,18,38,22],[37,10,37,22],[38,10,38,17],[40,21,40,22],[41,21,41,22],[35,18,35,22],[44,21,44,22],[44,11,44,12],[44,13,44,14],[43,18,43,20],[43,21,43,22],[22,10,22,17],[23,10,23,17],[19,18,19,20],[20,18,20,22],[20,10,20,17],[32,12,32,17],[34,18,34,22],[44,15,44,17],[44,18,44,20],[35,10,35,11],[35,12,35,17],[42,11,42,12],[42,13,42,14],[40,11,40,12],[40,13,40,14],[40,15,40,17],[40,18,40,20],[41,11,41,12],[41,13,41,14],[41,15,41,17],[41,18,41,20],[32,18,32,22],[1,18,1,22],[6,18,6,22],[9,18,9,22],[7,18,7,22],[2,18,2,22],[3,18,3,22],[4,18,4,22],[2,10,2,17],[18,18,18,20],[3,10,3,17],[4,10,4,17],[7,10,7,17],[10,10,10,17],[15,18,15,22],[16,18,16,22],[16,12,16,17],[16,10,16,11],[10,18,10,22],[13,10,13,19],[15,12,15,16],[63,13,64,14],[63,18,64,20],[67,19,67,21],[63,21,64,22],[65,19,65,23],[63,3,64,3],[63,12,64,12],[65,3,66,3],[65,12,66,12],[65,13,66,14],[65,16,66,16],[69,18,69,19],[69,20,69,23],[70,20,71,23],[67,3,68,3],[67,12,68,12],[69,3,70,3],[69,12,70,12],[69,13,70,14],[69,16,70,16],[67,13,68,14],[67,16,68,16],[62,11,62,24],[18,11,18,12],[19,11,19,12],[18,13,18,14],[18,15,18,17],[26,10,26,17],[52,14,52,23],[18,21,18,22],[19,13,19,14],[19,21,19,22],[19,15,19,17],[21,18,21,22],[22,18,22,22],[23,18,23,22],[26,18,26,22],[25,10,25,17],[25,18,25,22],[21,10,21,17],[55,17,55,18],[47,10,47,22],[42,21,42,22],[43,11,43,12],[43,13,43,14],[43,15,43,17],[27,2,27,8],[28,2,28,8],[32,2,32,8],[59,0,69,0],[34,12,34,16],[31,12,31,16],[28,10,28,17],[53,12,53,15],[57,11,57,24],[54,14,54,23],[31,18,31,22],[29,10,29,17],[28,18,28,22],[29,18,29,22],[48,10,48,22],[45,11,45,12],[45,13,45,14],[45,15,45,17],[45,18,45,20],[45,21,45,22],[58,11,58,24],[59,11,59,24],[60,11,60,24],[61,11,61,24]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Seeding Type",null,null,null,null,null,null,null,"Rate (lb/ac.)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SeedType1),\"\",SeedType1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SeedRate1),\"\",SeedRate1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SeedType2),\"\",SeedType2)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SeedRate2),\"\",SeedRate2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SeedType3),\"\",SeedType3)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(SeedRate3),\"\",SeedRate3)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mulch Type",null,null,null,null,null,null,null,"Rate (ton/ac.)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(MulchType),\"\",MulchType)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(MulchRate),\"\",MulchRate)","v":""}]
[null,null,"Construction Tolerances"]
[null,null,"Trapezoidal Waterway",null,null,null,null,null,null,null,"Temporary Seeding Type",null,null,null,null,null,null,null,"Rate (lb/ac.)"]
[null,null,"Depth at Centerline:",null,null,null,"Grade to 0.2' below",null,null,null,{"$f":"IF(ISBLANK(TempSeedType),\"\",TempSeedType)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(TempSeedRate),\"\",TempSeedRate)","v":""}]
[null,null,"Depth at Toe:",null,null,null,"Grade to 0.2' above"]
[null,null,"Bottom Width:",null,null,null,"10% wider not to exceed 2'",null,null,null,"Lime ",null,"Rate (ton/ac.)",null,null,null,null,null,"Or to a pH of:"]
[null,null,"Parabolic Waterway",null,null,null,null,null,null,null,null,null,{"$f":"+IF(ISBLANK(LimeRate),\"\",LimeRate)","v":2},null,null,null,null,null,{"$f":"+IF(ISBLANK(LimepH),\"\",LimepH)","v":6}]
[null,null,"Depth at Centerline:",null,null,null,"Grade to 0.2' below"]
[null,null,"Top Width:",null,null,null,"10% wider not to exceed 5'",null,null,null,"Fertilizer",null,"Rate (lbs./ac.)",null,null,null,null,null,"Type:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(ISBLANK(FertilizerRate),\"\",IF(FertilizerRate>500,500,FertilizerRate))","v":500},null,{"$f":"+IF(ISBLANK(LimeRate),\"\",LimeRate)","v":2},null,{"$f":"+IF(ISBLANK(LimeRate),\"\",LimeRate)","v":2},null,"12-12-12 or equiv."]
[]
[null,null,null,null,null,null,null,null,null,null,"Erosion Control Blanket Type"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(ISBLANK(BlanketType), \"\", BlanketType)","v":""},null,null,null,null,null,null,null,"or equivalent"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date","Lime",null,"Fertilizer",null,"Mulch",null,null,"Seed",null,null,"Temp. Seed"]
[null,null,null,null,null,null,null,null,null,null," * 3/1 - 5/15","Yes",null,"Yes",null,"Yes",null,null,"Yes",null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,"**5/16 - 5/31","Yes",null,"Yes",null,"Yes",null,null,"Yes",null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,"   5/16 - 7/31","Yes",null,"1/3 of rate",null,"No",null,null,"No",null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,"   8/1 - 9/15","Yes",null,"Yes",null,"Yes",null,null,"Yes",null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,"** 9/15 - 9/30","Yes",null,"Yes",null,"Yes",null,null,"Yes",null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,"   10/1 - 2/28  No Seeding"]
[null,null,null,null,null,null,null,null,null,null,"   * Switchgrass Spring Seeding 4/1 - 6/15"]
[null,null,null,null,null,null,null,null,null,null,"** Only Tall Fescue or Perennial Ryegrass with Mulch Cover"]
[null,null,null,null,null,null,null,null,null,null,"Where waterway excavation is likely to expose subsoil with poor "]
[null,null,null,null,null,null,null,null,null,null,"growing conditions, the waterway will be undercut 6\" and "]
[null,null,null,null,null,null,null,null,null,null,"backfilled with topsoil."]
[null,null,null,null,null,null,null,null,null,null,null,null,"LANDUSER",null,{"$f":"IF(ISBLANK(Landuser),\"\",Landuser)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(County),\"\",County)","v":""},null,null,null,"COUNTY SWCD, INDIANA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,{"$f":"+IF(ISBLANK(Location),\"\",Location)","v":"WW1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sec.",{"$f":"+IF(ISBLANK(section),\"\",section)","v":""},null,"T",{"$f":"IF(ISBLANK(twp),\"\",twp)","v":""},null,null,"R",{"$f":"IF(ISBLANK(range),\"\",range)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"GRASSED WATERWAY"]
[null,null,null,null,null,null,null,null,null,null,null,"CONSTRUCTION SPECIFICATIONS / O&M"]
["WW Design (Rev 4/07)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"U.S. DEPARTMENT OF AGRICULTURE"]
[null,null,null,null,null,null,null,null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Designed",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,"Date",null,"Approved by",null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-08-13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Drawn",{"$f":"IF(ISBLANK(Designer),\"\",Designer)","v":""},null,null,{"$f":"TODAY()","v":"2020-08-13"},null,"Title"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Traced",null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Checked",null,null,null,null,null,"Sheet",null,"Drawing No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of"]

{"sheet":"Defaults","index":10,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[[12,19,12,20],[48,14,48,18],[49,14,49,18],[13,19,13,20],[14,19,14,20],[1,0,1,4],[2,0,2,4],[15,10,15,11],[47,14,47,18],[58,14,58,18],[46,14,46,18],[54,14,54,18],[55,14,55,18],[56,14,56,18],[57,14,57,18],[50,14,50,18],[51,14,51,18],[52,14,52,18],[53,14,53,18]]}
[]
["Default Values",null,null,null,null,null,null,null,null,null,null,null,null,null,"W/W Types Table:","Parabolic",null,null,null,null,"Retardance "]
["(To change defaults, you must edit the template file)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trapezoidal",null,null,null,"Number","Values","I"]
[null,null,null,null,null,null,null,"Beg. Blanket","End Blank.","Width","Length","Area",null,null,null,null,null,null,null,1,"A",10]
["Waterway Choice:","Parabolic",null,"Temp. Seeding Type:",null,null,null,null,null,null,{"$f":"+ABS(I5-H5)","v":0},{"$f":"+K5*BlanketW1/9","v":0},null,null,"W/W Solve for Table:","Depth",null,null,null,2,"B",7.6429999999999998]
[null,"(Trapezoidal or Parabolic)",null,"Temp. Seeding Rate:",null,"lb/ac",null,null,null,null,0,{"$f":"+K6*BlanketW2/9","v":0},null,null,null,"Width",null,null,null,3,"C",5.601]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+K7*BlanketW3/9","v":0},null,null,null,null,null,null,null,4,"D",4.4359999999999999]
["W/W Solve for Choice:","Depth",null,"Mulch Type:",null,null,null,null,null,null,0,{"$f":"+K8*BlanketW4/9","v":0},null,null,"Seeding Types","Tall Fescue",null,null,null,5,"E",2.8759999999999999]
[null,"(Depth or Width)",null,"Mulching Rate:",null,"ton/ac",null,null,null,null,0,{"$f":"+K9*BlanketW5/9","v":0},null,null,"    Table:","Low Endophyte Tall Fescue"]
[null,null,null,"Lime Rate:",2,"ton/ac",null,null,null,null,0,{"$f":"+K10*BlanketW6/9","v":0},null,null,null,"Orchardgrass",null,null,null,"Retardance, Cap. = ",null,"C"]
["Maximum Velocity:",5,"fps","Lime pH:",6,null,null,null,null,null,0,{"$f":"+K11*BlanketW7/9","v":0},null,null,null,"Timothy",null,null,null,"Retardance, Stab. =",null,"D"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+K12*BlanketW8/9","v":0},null,null,null,"Perennial Ryegrass"]
["Seeding Type 1:",null,null,"Blanket/Net Type:",null,null,null,null,null,null,"Total:",{"$f":"+SUM(L5:L12)","v":0},"sq. yd.",null,null,"Smooth Bromegrass",null,null,null,"Stationing Increases:"]
["Seeding Type 2:",null,null,null,null,null,null,null,null,null,"  +10%",{"$f":"+ROUNDUP(L13*1.1,0)","v":0},"sq. yd.",null,null,"Redtop",null,null,null,"Upstream"]
["Seeding Type 3:",null,null,"Fertilization Rate:",500,"lbs/ac.",null,null,null,null,null,null,null,null,null,"Alsike Clover",null,null,null,"Downstream"]
["Seeding Rate 1:",null,"lb/ac",null,"(not to exceed 500 lbs./ac.)",null,null,null,null,"Criteria","Inverted Table",null,null,null,null,"Ladino Clover"]
["Seeding Rate 2:",null,"lb/ac",null,null,null,null,"Length","Tile Sizes","Length","Length","Tile Sizes",null,null,null,"Alfalfa"]
["Seeding Rate 3:",null,"lb/ac","Stationing Increases:","Upstream",null,null,{"$f":"SUM(IF($J$30:$J$37=4,$K$30:$K$37,0))","v":0},4,">0",{"$f":"+H27","v":0},{"$f":"+I27","v":24},null,null,null,"Red Clover"]
[null,null,null,null,"(Upstream or Downstream)",null,null,{"$f":"SUM(IF($J$30:$J$37=5,$K$30:$K$37,0))","v":0},5,null,{"$f":"+H26","v":0},{"$f":"+I26","v":21},null,null,null,"Birdsfoot Trefoil"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=6,$K$30:$K$37,0))","v":1343},6,null,{"$f":"+H25","v":0},{"$f":"+I25","v":18},null,null,null,"Korean Lespedeza"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=8,$K$30:$K$37,0))","v":0},8,null,{"$f":"+H24","v":0},{"$f":"+I24","v":15},null,null,null,"Switchgrass"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=10,$K$30:$K$37,0))","v":0},10,null,{"$f":"+H23","v":0},{"$f":"+I23","v":12},null,null,null,"Indiangrass"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=12,$K$30:$K$37,0))","v":0},12,null,{"$f":"+H22","v":0},{"$f":"+I22","v":10},null,null,null,"Buffalograss"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=15,$K$30:$K$37,0))","v":0},15,null,{"$f":"+H21","v":0},{"$f":"+I21","v":8}]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=18,$K$30:$K$37,0))","v":0},18,null,{"$f":"+H20","v":1343},{"$f":"+I20","v":6},null,null,"Temp. Seeding Types:","Wheat"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=21,$K$30:$K$37,0))","v":0},21,null,{"$f":"+H19","v":0},{"$f":"+I19","v":5},null,null,null,"Rye"]
[null,null,null,null,null,null,null,{"$f":"SUM(IF($J$30:$J$37=24,$K$30:$K$37,0))","v":0},24,null,{"$f":"+H18","v":0},{"$f":"+I18","v":4},null,null,null,"Annual Ryegrass"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oats"]
[null,null,null,null,null,null,null,"Beg. Tile","End Tile","Size","Length",null,null,null,null,"Sorghum  - Sudan Grass"]
[null,null,null,null,null,null,null,0,2039,null,{"$f":"+ABS(I30-H30)","v":2039},null,null,null,null,"Corn"]
[null,null,null,null,null,null,null,2039,3382,6,{"$f":"+ABS(I31-H31)","v":1343},null,null,null,null,"Pearl Millet"]
[null,null,null,null,null,null,null,3382,5707,null,2325,null,null,null,null,"Soybeans"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Mulch Type Table:","Straw"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Project Title Options Table:"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,"GRASSED WATERWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRASSED WATERWAY & LATERALS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRASSED WATERWAY & ROCK CHUTE"]
[null,null,null,null,null,null,null,"Use Size:","Length:",null,null,null,null,null,"GRASSED WATERWAY & BLOCK CHUTE"]
[null,null,null,null,null,null,null,{"$f":"IF(I41=0,\"\",VLOOKUP(I41,H17:I27,2,FALSE))","v":6},{"$f":"DMAX(H17:J27,H17,J17:J18)","v":1343},null,null,null,null,null,"GRASSED WATERWAY & ALUMINUM TOEWALL STRUCTURE"]
[null,null,null,null,null,null,null,{"$f":"IF(I42=0,\"\",VLOOKUP(I42,K17:L27,2,FALSE))","v":6},{"$f":"DMIN(H17:J27,H17,J17:J18)","v":1343},null,null,null,null,null,"GRASSED WATERWAY & GROUTED ROCK CHUTE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRASSED WATERWAY & CONCRETE TOEWALL STRUCTURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRASSED WATERWAY & WOOD TOEWALL STRUCTURE"]
[null,null,null,null,null,null,null,"Plotting Information",null,"Actual","Use",null,null,null,"GRASSED WATERWAY & PIPE STRUCTURE"]
[null,null,null,null,null,null,null,"Number of Stations:",null,{"$f":"COUNT(Survey!X11:X49)","v":0}]
[null,null,null,null,null,null,null,"Minimum Station:",null,{"$f":"MIN(Survey!X11:X49)","v":0},0,null,null,null,"Project Index Options:"]
[null,null,null,null,null,null,null,"Maximum Station:",null,{"$f":"MAX(Survey!X11:X49)","v":0},350,null,null,null,"PLAN VIEW"]
[null,null,null,null,null,null,null,"Minimum Elevation:",null,{"$f":"FLOOR(MIN(Survey!Y11:Z49),1)","v":0},100,null,null,null,"PROFILE ALONG CENTERLINE"]
[null,null,null,null,null,null,null,"Maximum Elevation:",null,{"$f":"CEILING(MAX(Survey!Y11:Z49),1)","v":0},117.5,null,null,null,"GRASSED WATERWAY DETAILS"]
[null,null,null,null,null,null,null,"Plot Series:","Plot?",null,null,null,null,null,"CONSTRUCTION SPECS/O&M"]
[null,null,null,null,null,null,null,"Ex. Grnd.",true,null,null,null,null,null,"CROSS-SECTION"]
[null,null,null,null,null,null,null,"Low Bank",false,null,null,null,null,null,"ROCK LINED CHUTE DETAILS"]
[null,null,null,null,null,null,null,"P. Grade:",false,null,null,null,null,null,"BLOCK CHUTE DETAILS"]
[null,null,null,null,null,null,null,"Last # Ser.:",1,null,null,null,null,null,"ALUMINUM TOEWALL STRUCTURE DETAILS"]
[null,null,null,null,null,null,null,"Location of Last Station to Plot:",null,null,{"$f":"ADDRESS(NumStat+10,24,1,1)","v":"$X$10"},null,null,null,"GROUTED ROCK CHUTE DETAILS"]
[null,null,null,null,null,null,null,"Starting Elevation of Pln. Grade:",null,null,null,null,null,null,"CONCRETE TOEWALL STRUCTURE DETAILS"]
[null,null,null,null,null,null,null,"Location of Last EG Elev. To Plot:",null,null,{"$f":"ADDRESS(NumStat+10,25,1,1)","v":"$Y$10"},null,null,null,"WOOD TOEWALL STRUCTURE DETAILS"]
[null,null,null,null,null,null,null,"Location of Last LB El. To Plot:",null,null,{"$f":"ADDRESS(NumStat+10,26,1,1)","v":"$Z$10"},null,null,null,"PIPE STRUCTURE DETAILS"]
[null,null,null,null,null,null,null,"Location of Last PG El. To Plot:",null,null,{"$f":"ADDRESS(P84+73,16,1,1)","v":"$P$75"}]
[null,null,null,null,null,null,null,"Location of Last PG Stat. :",null,null,{"$f":"ADDRESS(P84+73,15,1,1)","v":"$O$75"},null,null,null,null,"Job Titles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District Conservationist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resource Conservationist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Conservationist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Conservation Technician"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Civil Engineering Technician"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resource Specialist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ag. Conservation Specialist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technician"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agricultural Engineer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Civil Engineer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Station","Planned Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!C15","v":18},{"$f":"+ElevPG","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F15","v":132},{"$f":"IF(StatDir=\"Upstream\",+P74+ABS(O74-O75)*Design!H15/100,+P74-ABS(O74-O75)*Design!H15/100)","v":7.98}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F16","v":0},{"$f":"IF(Design!B16=Design!$B$15,IF(StatDir=\"Upstream\",+P75+ABS(O75-O76)*Design!H16/100,+P75-ABS(O75-O76)*Design!H16/100),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F17","v":0},{"$f":"IF(Design!B17=Design!$B$15,IF(StatDir=\"Upstream\",+P76+ABS(O76-O77)*Design!H17/100,+P76-ABS(O76-O77)*Design!H17/100),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F18","v":0},{"$f":"IF(Design!B18=Design!$B$15,IF(StatDir=\"Upstream\",+P77+ABS(O77-O78)*Design!H18/100,+P77-ABS(O77-O78)*Design!H18/100),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F19","v":0},{"$f":"IF(Design!B19=Design!$B$15,IF(StatDir=\"Upstream\",+P78+ABS(O78-O79)*Design!H19/100,+P78-ABS(O78-O79)*Design!H19/100),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F20","v":0},{"$f":"IF(Design!B20=Design!$B$15,IF(StatDir=\"Upstream\",+P79+ABS(O79-O80)*Design!H20/100,+P79-ABS(O79-O80)*Design!H20/100),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F21","v":0},{"$f":"IF(Design!B21=Design!$B$15,IF(StatDir=\"Upstream\",+P80+ABS(O80-O81)*Design!H21/100,+P80-ABS(O80-O81)*Design!H21/100),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Design!F22","v":0},{"$f":"IF(Design!B22=Design!$B$15,IF(StatDir=\"Upstream\",+P81+ABS(O81-O82)*Design!H22/100,+P81-ABS(O81-O82)*Design!H22/100),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Grd. Break:",{"$f":"+COUNT(P74:P82)","v":2}]

{"sheet":"Comments","index":11,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,1,2,9],[3,1,4,9],[5,1,5,9],[3,0,4,0],[12,1,12,9],[8,1,8,9],[6,1,7,9],[11,1,11,9],[1,0,2,0],[6,0,7,0],[9,1,10,9],[9,0,10,0]]}
["Comments:"]
[1999,"This workbook was originally created by Jill Davis, NRCS Engineer in 1999."]
[]
["6/04","Version 1.13, revised 5/03, posted to website 6/04."]
[]
["2/06","Unlocked 14P and 14T sheets so that seeding widths can be changed by user. 2/06"]
["12/08","Updated IN-ENG-57L to ver 5_08"]
[]
["2/09","Fixed project info button to fill out IN-ENG-57L correctly"]
["12/09","Fixed formatting on Profile sheet title block.  Office 2007 update prevents auto resizing of profile chart window."]
[]
["12/09 ","Added Work Limits Sheet"]
["5/10","Updated seeding dates and changed \"Work Limits\" to \"Designated Work Area\""]