{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","New Inlet Invert"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,6,3,7],[3,9,3,10],[3,1,3,2]]}
["I.D. 2150-00-70"]
["STH 100 INLET REPLACEMENTS"]
[]
[null,"Station",null,null,"AsBuilt",null,"Existing",null,null,"Proposed"]
[null,"Current","AsBuilt",null,"Structure #",null,"Structure Type","Cover Type",null,"Structure Type","Cover Type"]
[null,"294+05","131+86",null,"2A",null,35,"X",null,"2.5x2","WM"]
[null,"294+45","131+10",null,"2B",null,35,"X",null,"2.5x2","WM"]
[]
[null,"311+40","148+50",null,"31A",null,34,"W",null,"2x3","H"]
[]
[null,"367+45","204+50?",null,"NO # to 50A",null,null,"NOT SHOWN IN LIST"]
[]
[null,"369+50","206+25",null,"24B",null,34,"W",null,"2x3","H"]
[]
[null,"379+40","216+50",null,"30B",null,34,"W",null,"2x3","H"]
[]
[null,"382+40","219+46",null,"31C",null,34,"W",null,"2x3","H"]
[null,"382+40","219+46",null,"31B",null,34,"W",null,"2x3","H"]
[]
[null,"385+90","223+00",null,"32B",null,34,"W",null,"2x3","H"]
[]
[null,"389+05","226+09",null,"33C",null,34,"W",null,"2x3","H"]
[null,"389+05","226+09",null,"33B",null,34,"W",null,"2x3","H"]
[]
[null,"391+95","229+00",null,"34D",null,34,"W",null,"2x3","H"]
[]
[null,"399+10","236+25",null,"25D",null,34,"W",null,"2x3","H"]
[]
[null,"400+05","237+15",null,"24E",null,34,"W",null,"2x3","H"]
[]
[null,"403+60","240+65",null,"22D",null,31,"W",null,"2.5x2","WM"]
[null,"403+60","240+65",null,"22C",null,31,"W",null,"2.5x2","WM"]
[]
[null,"406+30","243+40",null,"21B",null,35,"W",null,"2.5x2","WM"]

{"sheet":"New Inlet Invert","index":1,"n_rows":62,"n_cols":22,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,10,2,14],[2,0,2,7]]}
["Find existing slope to use for new structure depth"]
[]
["EXISTING",null,null,null,null,null,null,null,null,null,"NEW"]
[null,null,null,null,null,null,null,"(invert-invert)/length*100=",null,null,null,null,null,"(exist slope*new length)/100","exist invert +or- new depth"]
["Station","Asbuilt year\\\nMeasure Down","Asbuilt structure #","Measure down structure #","invert","invert","length","SLOPE",null,"Station","structure #","pipe #","length","depth","invert"]
["130+86",1969,"2A - 2","31978-42423",749.59,748.33,56,{"$f":"(E6-F6)/G6*100","v":2.2499999999999836},null,"293+78",1,"1a",39.08,{"$f":"(H6*M6)/100","v":0.87929999999999353},{"$f":"ROUND(E6-N6,2)","v":748.71}]
[null,1969,"2D - 2","31972-42423",748.75,748.36,52.2,{"$f":"(E7-F7)/G7*100","v":0.74712643678158297},null,null,2,"2a",40.9,{"$f":"(H7*M7)/100","v":0.30557471264366742},{"$f":"ROUND(E7-N7,2)","v":748.44}]
[]
[]
["149+00",1969,"31A - 31","31913-31885",728,727.21,37,{"$f":"(E10-F10)/G10*100","v":2.1351351351350365},null,"311+43",3,"3a",44.6,{"$f":"(H10*M10)/100","v":0.95227027027022626},{"$f":"ROUND(F10+N10,2)","v":728.16}]
[]
[]
["205+00","1995-1969","136 - 50A","31535-31533",688.49,687.42,154,{"$f":"(E13-F13)/G13*100","v":0.69480519480522729},null,"367+45",4,"4a",5,{"$f":"(M13*0.01)","v":0.05},{"$f":"ROUND(E13+N13,2)","v":688.54},"Pipe run 1.0% from exist to New inlet"]
[null,null,null,null,null,null,null,null,null,null,5,"-","change to mh"]
[]
[]
["206+00",1969,"24B - 24","31526-31523",676.65,675.96,34.9,{"$f":"(E17-F17)/G17*100","v":1.9770773638966788},null,"371+91",6,"6a",12.3,{"$f":"(H17*M17)/100","v":0.2431805157592915},{"$f":"ROUND(E17+N17,2)","v":676.89}]
[]
[]
["216+50",1969,"30B - 30C","31496-31497",673.54,673.47,31.7,{"$f":"(E20-F20)/G20*100","v":0.2208201892742471},null,"379+40",7,"7a",9.5,{"$f":"(H20*M20)/100","v":2.0977917981053477E-2},{"$f":"ROUND(E20-N20,2)","v":673.52}]
[]
[]
["219+46",1995,"342-45","27956-42424",672.3,"UNABLE TO OPEN",44.6,null,null,"382+40",8,"change to inlet",null,"APPROX.",671.67,"These IE should be verified in field"]
[null,null,"45-44","42424-31501","UNABLE TO OPEN",671.63,10.1,null,null,null,"8-9","8a",8,null,{"$f":"F24","v":671.63},"Same invert as 31501 as it's close"]
["FIELD VERIFIED",null,"44-126","31501-31502",671.63,671.45,22.2,{"$f":"(E25-F25)/G25*100","v":0.81081081081058548},null,null,"9-10","9a",14,{"$f":"(H25*M25)/100","v":0.11351351351348196},{"$f":"ROUND(E25-N25,2)","v":671.52}]
["MESURE DOWNS",null,"126-220","31502-EXIST",671.45,670.28,40.6,"unable to measure S. IE",null,null,"10-11","10a",7,null,671.47]
[null,null,null,null,null,null,null,null,null,null,"11-12","11a",5,"APPROX.",{"$f":"E26","v":671.45}]
[]
[null,null,null,"28143-31447",669.7,669.35,39.6,{"$f":"(E29-F29)/G29*100","v":0.88383838383844127},null,"385+93",12,"12a",4.3,{"$f":"(H29*M29)/100","v":3.800505050505297E-2},{"$f":"ROUND(F29-N29,2)","v":669.31}]
[null,null,null,"31447-31448",669.35,668.99,31.6,{"$f":"(E30-F30)/G30*100","v":1.1392405063291571},null,null,null,"12b",16.399999999999999]
[null,null,null,"31448-31449",668.89,668.62,38.799999999999997,{"$f":"(E31-F31)/G31*100","v":0.69587628865974704},null,null,13,"13a",7,{"$f":"(H31*M31)/100","v":4.8711340206182292E-2},{"$f":"ROUND(E31+N31,2)","v":668.94}]
[]
[]
[null,null,null,"28273-31436",665.77,665.32,41.8,{"$f":"(E34-F34)/G34*100","v":1.0765550239232817},null,"389+02",14,"14a","change to inlet",null,665.22]
[null,null,null,"31436-31435",665.22,665.19,10,{"$f":"(E35-F35)/G35*100","v":0.29999999999972715},null,null,15,"15a","change to mh",null,665.09]
[null,null,null,"31435-31439",665.09,664.84,18.399999999999999,{"$f":"(E36-F36)/G36*100","v":1.3586956521739131},null,null,16,"16a",9.1999999999999993,{"$f":"(H36*M36)/100","v":0.125},{"$f":"ROUND(E36-N36,2)","v":664.97}]
[null,null,null,"31439-34163",664.74,663.59,50.5,2.2772277227722322,null,null,17,null,7,{"$f":"(H37*M37)/100","v":0.15940594059405627},{"$f":"ROUND(O36-N37,2)","v":664.81}]
[]
[]
["229+00",1969,"34C-34D","31430-31432",662.52,662.34,22.4,0.80357142857120523,null,"391+92",18,"18a",9,{"$f":"(H40*M40)/100","v":7.2321428571408469E-2},{"$f":"ROUND(E40-N40,2)","v":662.45}]
[null,null,"34D-34","31432-31469",662.24,"UNABLE TO OPEN",null,0.93,null,null,19,"change to mh",12.1,{"$f":"(H41*M41)/100","v":0.11253000000000001},{"$f":"E41-N41","v":662.12747000000002}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,20,null,"change to mh",null,659.44]
["236+25",1969,"25C-25D","31015-31017",659.44,659.15,30,{"$f":"(E45-F45)/G45*100","v":0.96666666666692436},null,"399+18",21,"20a",7,{"$f":"(H45*M45)/100","v":6.7666666666684708E-2},{"$f":"ROUND(E45-N45,2)","v":659.37}]
[]
[]
[null,null,null,"29034-31022",659.93,659.49,47.2,{"$f":"(E48-F48)/G48*100","v":0.93220338983038309},null,"400+08",null,null,7,{"$f":"(H48*M48)/100","v":6.5254237288126807E-2},{"$f":"ROUND(F48-N48,2)","v":659.42}]
[null,null,null,"31022-31020",659.39,659.55,6.7,{"$f":"(E49-F49)/G49*100","v":-2.3880597014920619},"IE does not make sense",null,null,"These IE should be verified in field",null,null,659.39,null,"31022-31020",659.49,null,7,{"$f":"R49-(T49*U50/100)","v":659.42446808510635},"used next run's slope"]
["237+30",1969,"24C-24E",null,79.55,79.05,54,{"$f":"(E50-F50)/G50*100","v":0.92592592592592582},null,null,"24e ex","exist mh",null,null,659.45,null,"29034-31022",659.93,659.49,47,{"$f":"(R50-S50)/T50*100","v":0.93617021276583179}]
[null,null,null,"31020-31019",659.45,659.18,16,1.6875000000005969,null,null,23,"23a",null,null,659.44,null,null,659.42,659.18,5,{"$f":"R51-((R51-S51)/T51)","v":659.37199999999996}]
[]
[]
[null,null,null,"30222-31050",660.48,659.74,92,{"$f":"(E54-F54)/G54*100","v":0.80434782608696642},null,"403+56",40,"These IE should be verified in field",null,null,{"$f":"E56","v":658.95}]
[null,null,null,"12\" inlet-31050","NOT MEASURED",661.05,null,null,null,null,null,null,null,null,661.04,"Inlet moved short distance, SE IE "]
[null,null,null,"31050-31052",658.95,658.9,24,{"$f":"(E56-F56)/G56*100","v":0.20833333333361756},null,null,41,"40a",7.2,{"$f":"(H56*M56)/100","v":1.5000000000020464E-2},{"$f":"ROUND(E56-N56,2)","v":658.94}]
["240+65",1969,"22d-22","31052-31033",658.8,{"$f":"E57 - 0.25","v":658.55},36,{"$f":"(E57-F57)/G57*100","v":0.69444444444444442},"658.55 from 1969 asbuilt",null,42,"41a",14.2,null,658.8]
[null,"2006 60th St.",null,"7-7b",660.49,660.33,40,{"$f":"(E58-F58)/G58*100","v":0.39999999999992036},null,null,43,"42a",8,{"$f":"(H57*M58)/100","v":5.5555555555555552E-2},{"$f":"ROUND(E57-N58,2)","v":658.74}]
[]
[]
["243+40",1969,"21a-21b","31064-31063",667.38,667.21,32,{"$f":"(E61-F61)/G61*100","v":0.5312499999998721},null,"406+32",44,null,17,{"$f":"(H61*M61)/100","v":9.0312499999978257E-2},{"$f":"ROUND(E61-N61,2)","v":667.29}]
[null,null,"21b-21c","31063-31053",667.11,666.91,32,{"$f":"(E62-F62)/G62*100","v":0.62500000000014211},null,null,null,null,5,{"$f":"(H62*M62)/100","v":3.1250000000007105E-2},{"$f":"ROUND(E62-N62,2)","v":667.08}]