{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Commune,Gemeinde xy","Graph1","Graph2","data","liste","exemple, Bsp."],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph1","index":1,"reason":"not_a_worksheet"},{"sheet":"Graph2","index":2,"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":"Commune,Gemeinde xy","index":0,"n_rows":55,"n_cols":33,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,4,2,7],[6,4,6,6],[7,4,7,6],[5,4,5,7],[4,4,4,7],[3,4,3,7],[9,18,10,18],[9,19,10,19],[9,3,9,7],[9,8,9,12],[9,13,9,17],[9,20,9,21],[10,28,10,29],[9,30,10,31],[9,22,9,29],[8,32,10,32]]}
[{"$f":"bi(\"Charge globale rejetée à la STEP et évaluation des eaux claires parasites\",\"Globale Abwasserfracht und Abschätzung des ständigen Fremdwasseranteils\")","v":"Globale Abwasserfracht und Abschätzung des ständigen Fremdwasseranteils"},null,null,null,null,null,null,null,null,null,null,{"$f":"bi(\"Remplir uniquement les cellules en vert\",\"Nur die grüne Spalten ausfüllen\")","v":"Nur die grüne Spalten ausfüllen"}]
[]
[null,null,null,{"$f":"bi(\"Commune :\",\"Gemeinde :\")","v":"Gemeinde :"},"Leuk"]
[null,null,null,{"$f":"bi(\"Convention du (date):\",\"Abkommen vom (Datum) :\")","v":"Abkommen vom (Datum) :"},"2014-12-15"]
[null,null,null,{"$f":"bi(\"Point de mesure :\",\"Messpunkt :\")","v":"Messpunkt :"},"Kanalisation Abzw. Gerberstr./Herrw.",null,null,null,{"$f":"bi(\"Localisation à décrire\",\"Ort beschreiben\")","v":"Ort beschreiben"}]
[null,null,null,{"$f":"bi(\"Type de prélèvement :\",\"Probenahmeart :\")","v":"Probenahmeart :"},"24h, prop.Durchfluss",null,null,null,{"$f":"bi(\"Prélèvement moyen 24 h, proportionnel au temps / au débit?\",\"24-Stunden-Sammelproben, proportional zu Zeit- oder zu Durchfluss?\")","v":"24-Stunden-Sammelproben, proportional zu Zeit- oder zu Durchfluss?"}]
[null,null,null,"Langue/Sprache :"]
[null,null,null,{"$f":"bi(\"STEP: \",\"ARA: \")","v":"ARA: "}]
[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":"bi(\"Débit d'ECP excédentaire par rapport au débit spécifique admis\",\"Überschüssiges Fremdwasser bei angenommener Abwassermenge\")","v":"Überschüssiges Fremdwasser bei angenommener Abwassermenge"}]
[null,null,null,"Concentrations mesurées",null,null,null,null,{"$f":"bi(\"Charges polluantes\",\"Schmutzfracht\")","v":"Schmutzfracht"},null,null,null,null,{"$f":"bi(\"Charges en EH\",\"Fracht in EW\")","v":"Fracht in EW"},null,null,null,null,{"$f":"bi(\"charge moyenne\",\"Mittlere Fracht\")","v":"Mittlere Fracht"},{"$f":"bi(\"Débit specifique\",\"spez. Abwassermenge\")","v":"spez. Abwassermenge"},{"$f":"bi(\"Débits maximum\",\"max Durchfluss\")","v":"max Durchfluss"},null,{"$f":"bi(\"Evaluation part d'eau claire parasite\",\"Abschätzung des Fremdwasseranteils\")","v":"Abschätzung des Fremdwasseranteils"},null,null,null,null,null,null,null,{"$f":"bi(\"Eaux usée\",\"Abwasser\")","v":"Abwasser"}]
[null,null,{"$f":"bi(\"débit\",\"Durchfluss\")","v":"Durchfluss"},{"$f":"bi(\"DCO\",\"CSB\")","v":"CSB"},{"$f":"bi(\"DBO5\",\"BSB5\")","v":"BSB5"},"Ntot","NH4","Ptot",{"$f":"bi(\"DCO\",\"CSB\")","v":"CSB"},{"$f":"bi(\"DBO5\",\"BSB5\")","v":"BSB5"},"Ntot","NH4","Ptot",{"$f":"bi(\"DCO\",\"CSB\")","v":"CSB"},{"$f":"bi(\"DBO5\",\"BSB5\")","v":"BSB5"},"Ntot","NH4","Ptot",null,null,{"$f":"bi(\"QTS 14\",\"QTW 14\")","v":"QTW 14"},{"$f":"\"2\"&U11","v":"2QTW 14"},{"$f":"bi(\"DCO\",\"CSB\")","v":"CSB"},{"$f":"bi(\"DBO5\",\"BSB5\")","v":"BSB5"},"Ntot","NH4","Ptot",{"$f":"bi(\"moyenne\",\"Mittel\")","v":"Mittel"},{"$f":"bi(\"Eaux claires parasites\",\"Fremdwassermenge\")","v":"Fremdwassermenge"}]
[{"$f":"bi(\"Date\",\"Datum\")","v":"Datum"},null,"m3/d","mg/l","mg/l","mg/l","mg/l","mg/l","kg/d","kg/d","kg/d","kg/d","kg/d",{"$f":"bi(\"EH\",\"EW\")","v":"EW"},"EW","EW","EW","EW","EW",{"$f":"bi(\"l/EH.d\",\"l/EW.d\")","v":"l/EW.d"},"l/s","l/s","%","%","%","%","%","%","m3/d","l/s","m3/d","l/s",{"$f":"bi(\"de \",\"von \")&T14&bi(\" l/EH.d\",\"l/EW.d\")","v":"von 250l/EW.d"}]
[{"$f":"bi(\"Charges maximum selon convention\",\"Maximale Frachten gemäss Abkommen\")","v":"Maximale Frachten gemäss Abkommen"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C14/14/3.6","v":347.22222222222223}]
[null,null,17500,null,null,null,null,null,{"$f":"$S$14*data!B4/1000","v":6600},{"$f":"$S$14*data!B5/1000","v":3300},{"$f":"$S$14*data!B6/1000","v":610.5},{"$f":"$S$14*data!B7/1000","v":374},{"$f":"$S$14*data!B8/1000","v":97.9},null,null,null,null,null,55000,250,88,{"$f":"U14*2","v":176},null,null,null,null,null,null,null,{"$f":"(T14-data!B3) * S14 / 86400","v":50.925925925925924}]
[{"$f":"bi(\"Résultat des mesures\",\"Messergebnisse\")","v":"Messergebnisse"}]
["2014-05-10",{"$f":"IF(C16=\"\",\"\",WEEKDAY(A16,2))","v":"1900-01-06"},16500,null,170,35,23,5,{"$f":"IF($C16=\"\",\"\",IF(D16=\"\",\"\",D16*$C16/1000))","v":""},{"$f":"IF($C16=\"\",\"\",IF(E16=\"\",\"\",E16*$C16/1000))","v":2805},{"$f":"IF($C16=\"\",\"\",IF(F16=\"\",\"\",F16*$C16/1000))","v":577.5},{"$f":"IF($C16=\"\",\"\",IF(G16=\"\",\"\",G16*$C16/1000))","v":379.5},{"$f":"IF($C16=\"\",\"\",IF(H16=\"\",\"\",H16*$C16/1000))","v":82.5},{"$f":"IF($C16=\"\",\"\",IF(I16=\"\",\"\",I16*1000/data!$B$4))","v":""},{"$f":"IF($C16=\"\",\"\",IF(J16=\"\",\"\",J16*1000/data!$B$5))","v":46750},{"$f":"IF($C16=\"\",\"\",IF(K16=\"\",\"\",K16*1000/data!$B$6))","v":52027.027027027027},{"$f":"IF($C16=\"\",\"\",IF(L16=\"\",\"\",L16*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C16=\"\",\"\",IF(M16=\"\",\"\",M16*1000/data!$B$8))","v":46348.314606741573},{"$f":"IF(C16=\"\",\"\",AVERAGE(N16:R16))","v":50233.541290795089},{"$f":"IF(C16=\"\",\"\",C16/S16*1000)","v":328.46579349211635},{"$f":"IF(C16=\"\",\"\",C16/(14 * 3.6))","v":327.38095238095241},{"$f":"IF(C16=\"\",\"\",U16*2)","v":654.76190476190482},{"$f":"IF(D16=\"\",\"\",1- (D16 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E16=\"\",\"\",1- (E16 / (data!$B$5*1000/data!$B$3)))","v":0.51833333333333331},{"$f":"IF(F16=\"\",\"\",1- (F16 / (data!$B$6*1000/data!$B$3)))","v":0.463963963963964},{"$f":"IF(G16=\"\",\"\",1- (G16 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H16=\"\",\"\",1- (H16 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},{"$f":"IF(AND(D16=\"\",E16=\"\",F16=\"\",G16=\"\",H16=\"\"),\"\",AVERAGE(W16:AA16))","v":0.48244230185241421},{"$f":"IF(C16=\"\",\"\",AB16*C16)","v":7960.2979805648347},{"$f":"IF(C16=\"\",\"\",AC16/60/60/24*1000)","v":92.133078478759657},{"$f":"IF(C16=\"\",\"\",C16-AC16)","v":8539.7020194351644},{"$f":"IF(C16=\"\",\"\",AE16/60/60/24*1000)","v":98.839143743462543},{"$f":"IF(C16=\"\",\"\",IF(T16>T$14,(T16-T$14)*S16/86400,\"\"))","v":45.620540246541978}]
["2014-05-11","1900-01-07",16000,null,174,35.799999999999997,25.800000000000004,5.5,{"$f":"IF($C17=\"\",\"\",IF(D17=\"\",\"\",D17*$C17/1000))","v":""},2784,{"$f":"IF($C17=\"\",\"\",IF(F17=\"\",\"\",F17*$C17/1000))","v":572.79999999999995},{"$f":"IF($C17=\"\",\"\",IF(G17=\"\",\"\",G17*$C17/1000))","v":412.80000000000007},{"$f":"IF($C17=\"\",\"\",IF(H17=\"\",\"\",H17*$C17/1000))","v":88},{"$f":"IF($C17=\"\",\"\",IF(I17=\"\",\"\",I17*1000/data!$B$4))","v":""},{"$f":"IF($C17=\"\",\"\",IF(J17=\"\",\"\",J17*1000/data!$B$5))","v":46400},{"$f":"IF($C17=\"\",\"\",IF(K17=\"\",\"\",K17*1000/data!$B$6))","v":51603.603603603602},{"$f":"IF($C17=\"\",\"\",IF(L17=\"\",\"\",L17*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C17=\"\",\"\",IF(M17=\"\",\"\",M17*1000/data!$B$8))","v":49438.20224719101},{"$f":"IF(C17=\"\",\"\",AVERAGE(N17:R17))","v":52036.922050933958},{"$f":"IF(C17=\"\",\"\",C17/S17*1000)","v":307.47398903300109},{"$f":"IF(C17=\"\",\"\",C17/(14 * 3.6))","v":317.46031746031747},{"$f":"IF(C17=\"\",\"\",U17*2)","v":634.92063492063494},{"$f":"IF(D17=\"\",\"\",1- (D17 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E17=\"\",\"\",1- (E17 / (data!$B$5*1000/data!$B$3)))","v":0.50700000000000001},{"$f":"IF(F17=\"\",\"\",1- (F17 / (data!$B$6*1000/data!$B$3)))","v":0.45171171171171176},{"$f":"IF(G17=\"\",\"\",1- (G17 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H17=\"\",\"\",1- (H17 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},{"$f":"IF(AND(D17=\"\",E17=\"\",F17=\"\",G17=\"\",H17=\"\"),\"\",AVERAGE(W17:AA17))","v":0.44710770320882676},{"$f":"IF(C17=\"\",\"\",AB17*C17)","v":7153.7232513412282},{"$f":"IF(C17=\"\",\"\",AC17/60/60/24*1000)","v":82.797722816449408},{"$f":"IF(C17=\"\",\"\",C17-AC17)","v":8846.2767486587727},102.38746236873581,{"$f":"IF(C17=\"\",\"\",IF(T17>T$14,(T17-T$14)*S17/86400,\"\"))","v":34.615387584103132}]
["2014-05-12","1900-01-01",16500,null,177,36.399999999999991,23,5,"",2920.5,600.59999999999991,379.5,82.5,{"$f":"IF($C18=\"\",\"\",IF(I18=\"\",\"\",I18*1000/data!$B$4))","v":""},{"$f":"IF($C18=\"\",\"\",IF(J18=\"\",\"\",J18*1000/data!$B$5))","v":48675},{"$f":"IF($C18=\"\",\"\",IF(K18=\"\",\"\",K18*1000/data!$B$6))","v":54108.108108108099},{"$f":"IF($C18=\"\",\"\",IF(L18=\"\",\"\",L18*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C18=\"\",\"\",IF(M18=\"\",\"\",M18*1000/data!$B$8))","v":46348.314606741573},51235.061561065362,322.04508977381045,327.38095238095241,654.76190476190482,{"$f":"IF(D18=\"\",\"\",1- (D18 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E18=\"\",\"\",1- (E18 / (data!$B$5*1000/data!$B$3)))","v":0.49849999999999994},{"$f":"IF(F18=\"\",\"\",1- (F18 / (data!$B$6*1000/data!$B$3)))","v":0.44252252252252267},{"$f":"IF(G18=\"\",\"\",1- (G18 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H18=\"\",\"\",1- (H18 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.47212360815872056,7790.0395346188889,90.162494613644554,8709.9604653811111,100.80972760857769,42.722622797843272]
["2014-05-13","1900-01-02",16000,null,184,37.79999999999999,25.800000000000004,5.5,"",2944,604.79999999999984,412.80000000000007,88,{"$f":"IF($C19=\"\",\"\",IF(I19=\"\",\"\",I19*1000/data!$B$4))","v":""},{"$f":"IF($C19=\"\",\"\",IF(J19=\"\",\"\",J19*1000/data!$B$5))","v":49066.666666666664},{"$f":"IF($C19=\"\",\"\",IF(K19=\"\",\"\",K19*1000/data!$B$6))","v":54486.486486486479},{"$f":"IF($C19=\"\",\"\",IF(L19=\"\",\"\",L19*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C19=\"\",\"\",IF(M19=\"\",\"\",M19*1000/data!$B$8))","v":49438.20224719101},53424.309438321339,299.48913085104238,317.46031746031747,634.92063492063494,{"$f":"IF(D19=\"\",\"\",1- (D19 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E19=\"\",\"\",1- (E19 / (data!$B$5*1000/data!$B$3)))","v":0.47866666666666668},{"$f":"IF(F19=\"\",\"\",1- (F19 / (data!$B$6*1000/data!$B$3)))","v":0.42108108108108122},{"$f":"IF(G19=\"\",\"\",1- (G19 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H19=\"\",\"\",1- (H19 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.43236671221783585,6917.8673954853739,{"$f":"IF(C19=\"\",\"\",AC19/60/60/24*1000)","v":80.067909669969595},9082.132604514627,105.11727551521558,30.600956486338692]
["2014-05-14","1900-01-03",16000,null,186,38.199999999999989,23,5,"",2976,611.19999999999982,368,80,{"$f":"IF($C20=\"\",\"\",IF(I20=\"\",\"\",I20*1000/data!$B$4))","v":""},{"$f":"IF($C20=\"\",\"\",IF(J20=\"\",\"\",J20*1000/data!$B$5))","v":49600},{"$f":"IF($C20=\"\",\"\",IF(K20=\"\",\"\",K20*1000/data!$B$6))","v":55063.06306306304},{"$f":"IF($C20=\"\",\"\",IF(L20=\"\",\"\",L20*1000/data!$B$7))","v":54117.647058823532},{"$f":"IF($C20=\"\",\"\",IF(M20=\"\",\"\",M20*1000/data!$B$8))","v":44943.8202247191},50931.132586651416,314.14969955318554,317.46031746031747,634.92063492063494,{"$f":"IF(D20=\"\",\"\",1- (D20 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E20=\"\",\"\",1- (E20 / (data!$B$5*1000/data!$B$3)))","v":0.47299999999999998},{"$f":"IF(F20=\"\",\"\",1- (F20 / (data!$B$6*1000/data!$B$3)))","v":0.41495495495495516},{"$f":"IF(G20=\"\",\"\",1- (G20 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H20=\"\",\"\",1- (H20 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.45885671626682867,7341.7074602692583,{"$f":"IF(C20=\"\",\"\",AC20/60/60/24*1000)","v":84.973465975338627},8658.2925397307408,100.21171920984652,37.815009876587339]
["2014-05-15","1900-01-04",16000,null,186,38.199999999999989,25.800000000000004,5.5,"",2976,611.19999999999982,412.80000000000007,88,{"$f":"IF($C21=\"\",\"\",IF(I21=\"\",\"\",I21*1000/data!$B$4))","v":""},{"$f":"IF($C21=\"\",\"\",IF(J21=\"\",\"\",J21*1000/data!$B$5))","v":49600},{"$f":"IF($C21=\"\",\"\",IF(K21=\"\",\"\",K21*1000/data!$B$6))","v":55063.06306306304},{"$f":"IF($C21=\"\",\"\",IF(L21=\"\",\"\",L21*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C21=\"\",\"\",IF(M21=\"\",\"\",M21*1000/data!$B$8))","v":49438.20224719101},53701.78691579881,297.94166859078717,317.46031746031747,634.92063492063494,{"$f":"IF(D21=\"\",\"\",1- (D21 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E21=\"\",\"\",1- (E21 / (data!$B$5*1000/data!$B$3)))","v":0.47299999999999998},{"$f":"IF(F21=\"\",\"\",1- (F21 / (data!$B$6*1000/data!$B$3)))","v":0.41495495495495516},{"$f":"IF(G21=\"\",\"\",1- (G21 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H21=\"\",\"\",1- (H21 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.4294185140196376,6870.6962243142016,79.521947040673624,9129.3037756857993,105.66323814451158,29.798070266785846]
["2014-05-16","1900-01-05",16500,null,196,40.199999999999989,23,5,"",3234,663.29999999999973,379.5,82.5,{"$f":"IF($C22=\"\",\"\",IF(I22=\"\",\"\",I22*1000/data!$B$4))","v":""},{"$f":"IF($C22=\"\",\"\",IF(J22=\"\",\"\",J22*1000/data!$B$5))","v":53900},{"$f":"IF($C22=\"\",\"\",IF(K22=\"\",\"\",K22*1000/data!$B$6))","v":59756.756756756738},{"$f":"IF($C22=\"\",\"\",IF(L22=\"\",\"\",L22*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C22=\"\",\"\",IF(M22=\"\",\"\",M22*1000/data!$B$8))","v":46348.314606741573},53953.473723227522,305.81904854990984,327.38095238095241,654.76190476190482,{"$f":"IF(D22=\"\",\"\",1- (D22 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E22=\"\",\"\",1- (E22 / (data!$B$5*1000/data!$B$3)))","v":0.44466666666666665},{"$f":"IF(F22=\"\",\"\",1- (F22 / (data!$B$6*1000/data!$B$3)))","v":0.38432432432432451},{"$f":"IF(G22=\"\",\"\",1- (G22 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H22=\"\",\"\",1- (H22 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.4441157252758377,7327.9094670513223,84.813766979760672,9172.0905329486777,106.15845524246156,34.856846865661126]
["2014-05-17","1900-01-06",16000,null,198,40.599999999999987,25.800000000000004,5.5,"",3168,649.5999999999998,412.80000000000007,88,{"$f":"IF($C23=\"\",\"\",IF(I23=\"\",\"\",I23*1000/data!$B$4))","v":""},{"$f":"IF($C23=\"\",\"\",IF(J23=\"\",\"\",J23*1000/data!$B$5))","v":52800},{"$f":"IF($C23=\"\",\"\",IF(K23=\"\",\"\",K23*1000/data!$B$6))","v":58522.5225225225},{"$f":"IF($C23=\"\",\"\",IF(L23=\"\",\"\",L23*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C23=\"\",\"\",IF(M23=\"\",\"\",M23*1000/data!$B$8))","v":49438.20224719101},55366.651780663677,288.98261833466802,317.46031746031747,634.92063492063494,{"$f":"IF(D23=\"\",\"\",1- (D23 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E23=\"\",\"\",1- (E23 / (data!$B$5*1000/data!$B$3)))","v":0.43899999999999995},{"$f":"IF(F23=\"\",\"\",1- (F23 / (data!$B$6*1000/data!$B$3)))","v":0.37819819819819844},{"$f":"IF(G23=\"\",\"\",1- (G23 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H23=\"\",\"\",1- (H23 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.41172932483044844,6587.6691972871749,76.246171264897868,9412.330802712826,108.93901392028732,24.980752949468513]
["2014-05-18","1900-01-07",16500,null,205,41.999999999999986,23,5,"",3382.5,692.99999999999977,379.5,82.5,{"$f":"IF($C24=\"\",\"\",IF(I24=\"\",\"\",I24*1000/data!$B$4))","v":""},{"$f":"IF($C24=\"\",\"\",IF(J24=\"\",\"\",J24*1000/data!$B$5))","v":56375},{"$f":"IF($C24=\"\",\"\",IF(K24=\"\",\"\",K24*1000/data!$B$6))","v":62432.432432432412},{"$f":"IF($C24=\"\",\"\",IF(L24=\"\",\"\",L24*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C24=\"\",\"\",IF(M24=\"\",\"\",M24*1000/data!$B$8))","v":46348.314606741573},55241.142642146435,298.69041824292867,327.38095238095241,654.76190476190482,{"$f":"IF(D24=\"\",\"\",1- (D24 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E24=\"\",\"\",1- (E24 / (data!$B$5*1000/data!$B$3)))","v":0.41916666666666669},{"$f":"IF(F24=\"\",\"\",1- (F24 / (data!$B$6*1000/data!$B$3)))","v":0.356756756756757},{"$f":"IF(G24=\"\",\"\",1- (G24 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H24=\"\",\"\",1- (H24 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.43084883338394586,7109.0057508351065,82.280159153184115,9390.9942491648944,108.69206306903813,31.130953003048518]
["2014-05-19","1900-01-01",16000,null,205,41.999999999999986,25.800000000000004,5.5,"",3280,671.99999999999977,412.80000000000007,88,{"$f":"IF($C25=\"\",\"\",IF(I25=\"\",\"\",I25*1000/data!$B$4))","v":""},{"$f":"IF($C25=\"\",\"\",IF(J25=\"\",\"\",J25*1000/data!$B$5))","v":54666.666666666664},{"$f":"IF($C25=\"\",\"\",IF(K25=\"\",\"\",K25*1000/data!$B$6))","v":60540.540540540518},{"$f":"IF($C25=\"\",\"\",IF(L25=\"\",\"\",L25*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C25=\"\",\"\",IF(M25=\"\",\"\",M25*1000/data!$B$8))","v":49438.20224719101},56337.822951834845,284.00103450356886,317.46031746031747,634.92063492063494,{"$f":"IF(D25=\"\",\"\",1- (D25 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E25=\"\",\"\",1- (E25 / (data!$B$5*1000/data!$B$3)))","v":0.41916666666666669},{"$f":"IF(F25=\"\",\"\",1- (F25 / (data!$B$6*1000/data!$B$3)))","v":0.356756756756757},{"$f":"IF(G25=\"\",\"\",1- (G25 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H25=\"\",\"\",1- (H25 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.40141063113675479,6422.5700981880764,74.33530206236199,9577.4299018119236,110.84988312282317,22.170651181033453]
["2014-05-20",{"$f":"IF(C26=\"\",\"\",WEEKDAY(A26,2))","v":"1900-01-02"},16000,415,205,41.999999999999986,25.800000000000004,5.5,{"$f":"IF($C26=\"\",\"\",IF(D26=\"\",\"\",D26*$C26/1000))","v":6640},{"$f":"IF($C26=\"\",\"\",IF(E26=\"\",\"\",E26*$C26/1000))","v":3280},{"$f":"IF($C26=\"\",\"\",IF(F26=\"\",\"\",F26*$C26/1000))","v":671.99999999999977},{"$f":"IF($C26=\"\",\"\",IF(G26=\"\",\"\",G26*$C26/1000))","v":412.80000000000007},{"$f":"IF($C26=\"\",\"\",IF(H26=\"\",\"\",H26*$C26/1000))","v":88},{"$f":"IF($C26=\"\",\"\",IF(I26=\"\",\"\",I26*1000/data!$B$4))","v":55333.333333333336},{"$f":"IF($C26=\"\",\"\",IF(J26=\"\",\"\",J26*1000/data!$B$5))","v":54666.666666666664},{"$f":"IF($C26=\"\",\"\",IF(K26=\"\",\"\",K26*1000/data!$B$6))","v":60540.540540540518},{"$f":"IF($C26=\"\",\"\",IF(L26=\"\",\"\",L26*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C26=\"\",\"\",IF(M26=\"\",\"\",M26*1000/data!$B$8))","v":49438.20224719101},{"$f":"IF(C26=\"\",\"\",AVERAGE(N26:R26))","v":56136.925028134545},{"$f":"IF(C26=\"\",\"\",C26/S26*1000)","v":285.01739259820812},{"$f":"IF(C26=\"\",\"\",C26/(14 * 3.6))","v":317.46031746031747},{"$f":"IF(C26=\"\",\"\",U26*2)","v":634.92063492063494},{"$f":"IF(D26=\"\",\"\",1- (D26 / (data!$B$4*1000/data!$B$3)))","v":0.41208333333333336},{"$f":"IF(E26=\"\",\"\",1- (E26 / (data!$B$5*1000/data!$B$3)))","v":0.41916666666666669},{"$f":"IF(F26=\"\",\"\",1- (F26 / (data!$B$6*1000/data!$B$3)))","v":0.356756756756757},{"$f":"IF(G26=\"\",\"\",1- (G26 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H26=\"\",\"\",1- (H26 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},{"$f":"IF(AND(D26=\"\",E26=\"\",F26=\"\",G26=\"\",H26=\"\"),\"\",AVERAGE(W26:AA26))","v":0.4035451715760705},{"$f":"IF(C26=\"\",\"\",AB26*C26)","v":6456.7227452171282},{"$f":"IF(C26=\"\",\"\",AC26/60/60/24*1000)","v":74.730587328901947},{"$f":"IF(C26=\"\",\"\",C26-AC26)","v":9543.2772547828718},{"$f":"IF(C26=\"\",\"\",AE26/60/60/24*1000)","v":110.45459785628324},{"$f":"IF(C26=\"\",\"\",IF(T26>T$14,(T26-T$14)*S26/86400,\"\"))","v":22.751953043592163}]
["2014-05-21","1900-01-03",16000,433,214,43.799999999999976,25.800000000000004,5.5,6928,3424,700.79999999999961,412.80000000000007,88,{"$f":"IF($C27=\"\",\"\",IF(I27=\"\",\"\",I27*1000/data!$B$4))","v":57733.333333333336},{"$f":"IF($C27=\"\",\"\",IF(J27=\"\",\"\",J27*1000/data!$B$5))","v":57066.666666666664},{"$f":"IF($C27=\"\",\"\",IF(K27=\"\",\"\",K27*1000/data!$B$6))","v":63135.135135135104},{"$f":"IF($C27=\"\",\"\",IF(L27=\"\",\"\",L27*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C27=\"\",\"\",IF(M27=\"\",\"\",M27*1000/data!$B$8))","v":49438.20224719101},57615.843947053458,277.70139086573704,317.46031746031747,634.92063492063494,{"$f":"IF(D27=\"\",\"\",1- (D27 / (data!$B$4*1000/data!$B$3)))","v":0.38658333333333328},{"$f":"IF(E27=\"\",\"\",1- (E27 / (data!$B$5*1000/data!$B$3)))","v":0.39366666666666661},{"$f":"IF(F27=\"\",\"\",1- (F27 / (data!$B$6*1000/data!$B$3)))","v":0.3291891891891896},{"$f":"IF(G27=\"\",\"\",1- (G27 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H27=\"\",\"\",1- (H27 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.38783165806255698,6205.3065290009117,71.820677418992034,9794.6934709990892,113.36450776619316,18.47267376431293]
["2014-05-22","1900-01-04",16500,412,216,44.199999999999967,23,5,6798,3564,729.29999999999939,379.5,82.5,{"$f":"IF($C28=\"\",\"\",IF(I28=\"\",\"\",I28*1000/data!$B$4))","v":56650},{"$f":"IF($C28=\"\",\"\",IF(J28=\"\",\"\",J28*1000/data!$B$5))","v":59400},{"$f":"IF($C28=\"\",\"\",IF(K28=\"\",\"\",K28*1000/data!$B$6))","v":65702.702702702649},{"$f":"IF($C28=\"\",\"\",IF(L28=\"\",\"\",L28*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C28=\"\",\"\",IF(M28=\"\",\"\",M28*1000/data!$B$8))","v":46348.314606741573},56781.9681677712,290.585207459667,327.38095238095241,654.76190476190482,{"$f":"IF(D28=\"\",\"\",1- (D28 / (data!$B$4*1000/data!$B$3)))","v":0.41633333333333333},{"$f":"IF(E28=\"\",\"\",1- (E28 / (data!$B$5*1000/data!$B$3)))","v":0.38800000000000001},{"$f":"IF(F28=\"\",\"\",1- (F28 / (data!$B$6*1000/data!$B$3)))","v":0.32306306306306354},{"$f":"IF(G28=\"\",\"\",1- (G28 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H28=\"\",\"\",1- (H28 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.41497366130175128,6847.0654114788958,79.248442262487231,9652.9345885211042,111.723779959735,26.672545810847243]
["2014-05-23","1900-01-05",16000,418,null,44.799999999999969,25.800000000000004,5.5,6688,"",716.7999999999995,412.80000000000007,88,{"$f":"IF($C29=\"\",\"\",IF(I29=\"\",\"\",I29*1000/data!$B$4))","v":55733.333333333336},{"$f":"IF($C29=\"\",\"\",IF(J29=\"\",\"\",J29*1000/data!$B$5))","v":""},{"$f":"IF($C29=\"\",\"\",IF(K29=\"\",\"\",K29*1000/data!$B$6))","v":64576.576576576539},{"$f":"IF($C29=\"\",\"\",IF(L29=\"\",\"\",L29*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C29=\"\",\"\",IF(M29=\"\",\"\",M29*1000/data!$B$8))","v":49438.20224719101},57613.498627510526,277.71269548209625,317.46031746031747,634.92063492063494,{"$f":"IF(D29=\"\",\"\",1- (D29 / (data!$B$4*1000/data!$B$3)))","v":0.40783333333333338},{"$f":"IF(E29=\"\",\"\",1- (E29 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F29=\"\",\"\",1- (F29 / (data!$B$6*1000/data!$B$3)))","v":0.31387387387387433},{"$f":"IF(G29=\"\",\"\",1- (G29 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H29=\"\",\"\",1- (H29 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.38785657708270083,6205.7052333232132,71.825292052352012,9794.2947666767868,113.35989313283318,18.47945998984224]
["2014-05-24","1900-01-06",16500,434,null,46.399999999999963,23,5,7161,"",765.59999999999945,379.5,82.5,{"$f":"IF($C30=\"\",\"\",IF(I30=\"\",\"\",I30*1000/data!$B$4))","v":59675},{"$f":"IF($C30=\"\",\"\",IF(J30=\"\",\"\",J30*1000/data!$B$5))","v":""},{"$f":"IF($C30=\"\",\"\",IF(K30=\"\",\"\",K30*1000/data!$B$6))","v":68972.97297297293},{"$f":"IF($C30=\"\",\"\",IF(L30=\"\",\"\",L30*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C30=\"\",\"\",IF(M30=\"\",\"\",M30*1000/data!$B$8))","v":46348.314606741573},57701.277777281568,285.95553921158506,327.38095238095241,654.76190476190482,{"$f":"IF(D30=\"\",\"\",1- (D30 / (data!$B$4*1000/data!$B$3)))","v":0.38516666666666666},{"$f":"IF(E30=\"\",\"\",1- (E30 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F30=\"\",\"\",1- (F30 / (data!$B$6*1000/data!$B$3)))","v":0.28936936936936997},{"$f":"IF(G30=\"\",\"\",1- (G30 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H30=\"\",\"\",1- (H30 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.40550198653709907,6690.7827778621349,77.439615484515443,9809.2172221378642,113.53260673770677,24.012506431476957]
["2014-05-25","1900-01-07",16000,438,null,46.799999999999962,25.800000000000004,5.5,7008,"",748.79999999999939,412.80000000000007,88,{"$f":"IF($C31=\"\",\"\",IF(I31=\"\",\"\",I31*1000/data!$B$4))","v":58400},{"$f":"IF($C31=\"\",\"\",IF(J31=\"\",\"\",J31*1000/data!$B$5))","v":""},{"$f":"IF($C31=\"\",\"\",IF(K31=\"\",\"\",K31*1000/data!$B$6))","v":67459.459459459409},{"$f":"IF($C31=\"\",\"\",IF(L31=\"\",\"\",L31*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C31=\"\",\"\",IF(M31=\"\",\"\",M31*1000/data!$B$8))","v":49438.20224719101},59000.886014897907,271.1823682776552,317.46031746031747,634.92063492063494,{"$f":"IF(D31=\"\",\"\",1- (D31 / (data!$B$4*1000/data!$B$3)))","v":0.37949999999999995},{"$f":"IF(E31=\"\",\"\",1- (E31 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F31=\"\",\"\",1- (F31 / (data!$B$6*1000/data!$B$3)))","v":0.2832432432432439},{"$f":"IF(G31=\"\",\"\",1- (G31 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H31=\"\",\"\",1- (H31 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.37311558609170981,5969.849377467357,69.095478905872184,10030.150622532643,116.08970627931299,14.46502889207782]
["2014-05-26","1900-01-01",16500,446,null,47.599999999999959,23,5,7359,"",785.3999999999993,379.5,82.5,{"$f":"IF($C32=\"\",\"\",IF(I32=\"\",\"\",I32*1000/data!$B$4))","v":61325},{"$f":"IF($C32=\"\",\"\",IF(J32=\"\",\"\",J32*1000/data!$B$5))","v":""},{"$f":"IF($C32=\"\",\"\",IF(K32=\"\",\"\",K32*1000/data!$B$6))","v":70756.756756756702},{"$f":"IF($C32=\"\",\"\",IF(L32=\"\",\"\",L32*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C32=\"\",\"\",IF(M32=\"\",\"\",M32*1000/data!$B$8))","v":46348.314606741573},58559.723723227507,281.76362439796372,327.38095238095241,654.76190476190482,{"$f":"IF(D32=\"\",\"\",1- (D32 / (data!$B$4*1000/data!$B$3)))","v":0.36816666666666664},{"$f":"IF(E32=\"\",\"\",1- (E32 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F32=\"\",\"\",1- (F32 / (data!$B$6*1000/data!$B$3)))","v":0.27099099099099166},{"$f":"IF(G32=\"\",\"\",1- (G32 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H32=\"\",\"\",1- (H32 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.39665739194250449,6544.8469670513241,75.750543600131067,9955.1530329486759,115.22167862209116,21.528577189735234]
["2014-05-27","1900-01-02",16000,450,null,47.999999999999964,25.800000000000004,5.5,7200,"",767.99999999999943,412.80000000000007,88,{"$f":"IF($C33=\"\",\"\",IF(I33=\"\",\"\",I33*1000/data!$B$4))","v":60000},{"$f":"IF($C33=\"\",\"\",IF(J33=\"\",\"\",J33*1000/data!$B$5))","v":""},{"$f":"IF($C33=\"\",\"\",IF(K33=\"\",\"\",K33*1000/data!$B$6))","v":69189.189189189143},{"$f":"IF($C33=\"\",\"\",IF(L33=\"\",\"\",L33*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C33=\"\",\"\",IF(M33=\"\",\"\",M33*1000/data!$B$8))","v":49438.20224719101},59833.318447330334,267.40953728121178,317.46031746031747,634.92063492063494,{"$f":"IF(D33=\"\",\"\",1- (D33 / (data!$B$4*1000/data!$B$3)))","v":0.36250000000000004},{"$f":"IF(E33=\"\",\"\",1- (E33 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F33=\"\",\"\",1- (F33 / (data!$B$6*1000/data!$B$3)))","v":0.26486486486486549},{"$f":"IF(G33=\"\",\"\",1- (G33 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H33=\"\",\"\",1- (H33 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.36427099149711523,5828.3358639538437,67.457591017984299,10171.664136046156,117.72759416720086,12.056370233419145]
["2014-05-28","1900-01-03",16500,450,null,47.999999999999964,23,5,7425,"",791.99999999999943,379.5,82.5,{"$f":"IF($C34=\"\",\"\",IF(I34=\"\",\"\",I34*1000/data!$B$4))","v":61875},{"$f":"IF($C34=\"\",\"\",IF(J34=\"\",\"\",J34*1000/data!$B$5))","v":""},{"$f":"IF($C34=\"\",\"\",IF(K34=\"\",\"\",K34*1000/data!$B$6))","v":71351.351351351303},{"$f":"IF($C34=\"\",\"\",IF(L34=\"\",\"\",L34*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C34=\"\",\"\",IF(M34=\"\",\"\",M34*1000/data!$B$8))","v":46348.314606741573},58845.872371876161,280.39349804737947,327.38095238095241,654.76190476190482,{"$f":"IF(D34=\"\",\"\",1- (D34 / (data!$B$4*1000/data!$B$3)))","v":0.36250000000000004},{"$f":"IF(E34=\"\",\"\",1- (E34 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F34=\"\",\"\",1- (F34 / (data!$B$6*1000/data!$B$3)))","v":0.26486486486486549},{"$f":"IF(G34=\"\",\"\",1- (G34 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H34=\"\",\"\",1- (H34 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.3937091937443063,6496.2016967810541,75.187519638669613,10003.798303218946,115.78470258355262,20.70060077582129]
["2014-05-29","1900-01-04",16000,466,null,49.599999999999966,25.800000000000004,5.5,7456,"",793.59999999999945,412.80000000000007,88,{"$f":"IF($C35=\"\",\"\",IF(I35=\"\",\"\",I35*1000/data!$B$4))","v":62133.333333333336},{"$f":"IF($C35=\"\",\"\",IF(J35=\"\",\"\",J35*1000/data!$B$5))","v":""},{"$f":"IF($C35=\"\",\"\",IF(K35=\"\",\"\",K35*1000/data!$B$6))","v":71495.495495495445},{"$f":"IF($C35=\"\",\"\",IF(L35=\"\",\"\",L35*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C35=\"\",\"\",IF(M35=\"\",\"\",M35*1000/data!$B$8))","v":49438.20224719101},60943.228357240245,262.53942285778413,317.46031746031747,634.92063492063494,{"$f":"IF(D35=\"\",\"\",1- (D35 / (data!$B$4*1000/data!$B$3)))","v":0.33983333333333332},{"$f":"IF(E35=\"\",\"\",1- (E35 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F35=\"\",\"\",1- (F35 / (data!$B$6*1000/data!$B$3)))","v":0.2403603603603609},{"$f":"IF(G35=\"\",\"\",1- (G35 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H35=\"\",\"\",1- (H35 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.3524781987043224,5639.6511792691581,65.273740500800443,10360.348820730842,119.91144468438475,8.8448253552075968]
["2014-05-30","1900-01-05",16500,476,null,50.599999999999959,23,5,7854,"",834.8999999999993,379.5,82.5,{"$f":"IF($C36=\"\",\"\",IF(I36=\"\",\"\",I36*1000/data!$B$4))","v":65450},{"$f":"IF($C36=\"\",\"\",IF(J36=\"\",\"\",J36*1000/data!$B$5))","v":""},{"$f":"IF($C36=\"\",\"\",IF(K36=\"\",\"\",K36*1000/data!$B$6))","v":75216.216216216155},{"$f":"IF($C36=\"\",\"\",IF(L36=\"\",\"\",L36*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C36=\"\",\"\",IF(M36=\"\",\"\",M36*1000/data!$B$8))","v":46348.314606741573},60705.838588092374,271.80252153269032,327.38095238095241,654.76190476190482,{"$f":"IF(D36=\"\",\"\",1- (D36 / (data!$B$4*1000/data!$B$3)))","v":0.32566666666666666},{"$f":"IF(E36=\"\",\"\",1- (E36 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F36=\"\",\"\",1- (F36 / (data!$B$6*1000/data!$B$3)))","v":0.22504504504504574},{"$f":"IF(G36=\"\",\"\",1- (G36 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H36=\"\",\"\",1- (H36 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.37454590545601801,6180.0074400242975,71.527863889170106,10319.992559975703,119.44435833305211,15.318754085380869]
["2014-05-31","1900-01-06",16000,480,null,50.999999999999957,25.800000000000004,5.5,7680,"",815.99999999999932,412.80000000000007,88,{"$f":"IF($C37=\"\",\"\",IF(I37=\"\",\"\",I37*1000/data!$B$4))","v":64000},{"$f":"IF($C37=\"\",\"\",IF(J37=\"\",\"\",J37*1000/data!$B$5))","v":""},{"$f":"IF($C37=\"\",\"\",IF(K37=\"\",\"\",K37*1000/data!$B$6))","v":73513.513513513448},{"$f":"IF($C37=\"\",\"\",IF(L37=\"\",\"\",L37*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C37=\"\",\"\",IF(M37=\"\",\"\",M37*1000/data!$B$8))","v":49438.20224719101},61914.399528411413,258.42130622066173,317.46031746031747,634.92063492063494,{"$f":"IF(D37=\"\",\"\",1- (D37 / (data!$B$4*1000/data!$B$3)))","v":0.31999999999999995},{"$f":"IF(E37=\"\",\"\",1- (E37 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F37=\"\",\"\",1- (F37 / (data!$B$6*1000/data!$B$3)))","v":0.21891891891891957},{"$f":"IF(G37=\"\",\"\",1- (G37 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H37=\"\",\"\",1- (H37 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.34215950501062875,5474.5520801700604,63.362871298264594,10525.44791982994,121.8223138869206,6.0347235867725342]
["2014-06-01","1900-01-07",16500,372,null,40.199999999999967,23,5,6138,"",663.29999999999939,379.5,82.5,{"$f":"IF($C38=\"\",\"\",IF(I38=\"\",\"\",I38*1000/data!$B$4))","v":51150},{"$f":"IF($C38=\"\",\"\",IF(J38=\"\",\"\",J38*1000/data!$B$5))","v":""},{"$f":"IF($C38=\"\",\"\",IF(K38=\"\",\"\",K38*1000/data!$B$6))","v":59756.756756756709},{"$f":"IF($C38=\"\",\"\",IF(L38=\"\",\"\",L38*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C38=\"\",\"\",IF(M38=\"\",\"\",M38*1000/data!$B$8))","v":46348.314606741573},53265.973723227515,309.76623248708023,327.38095238095241,654.76190476190482,{"$f":"IF(D38=\"\",\"\",1- (D38 / (data!$B$4*1000/data!$B$3)))","v":0.47299999999999998},{"$f":"IF(E38=\"\",\"\",1- (E38 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F38=\"\",\"\",1- (F38 / (data!$B$6*1000/data!$B$3)))","v":0.38432432432432484},{"$f":"IF(G38=\"\",\"\",1- (G38 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H38=\"\",\"\",1- (H38 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.45119905860917109,7444.7844670513232,86.166486887168091,9055.2155329486777,104.80573533505412,36.846140847142614]
["2014-06-02","1900-01-01",16000,406,null,40.599999999999966,25.800000000000004,5.5,6496,"",649.59999999999945,412.80000000000007,88,{"$f":"IF($C39=\"\",\"\",IF(I39=\"\",\"\",I39*1000/data!$B$4))","v":54133.333333333336},{"$f":"IF($C39=\"\",\"\",IF(J39=\"\",\"\",J39*1000/data!$B$5))","v":""},{"$f":"IF($C39=\"\",\"\",IF(K39=\"\",\"\",K39*1000/data!$B$6))","v":58522.522522522471},{"$f":"IF($C39=\"\",\"\",IF(L39=\"\",\"\",L39*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C39=\"\",\"\",IF(M39=\"\",\"\",M39*1000/data!$B$8))","v":49438.20224719101},55699.985113997005,287.25321860057937,317.46031746031747,634.92063492063494,{"$f":"IF(D39=\"\",\"\",1- (D39 / (data!$B$4*1000/data!$B$3)))","v":0.42483333333333329},{"$f":"IF(E39=\"\",\"\",1- (E39 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F39=\"\",\"\",1- (F39 / (data!$B$6*1000/data!$B$3)))","v":0.37819819819819878},{"$f":"IF(G39=\"\",\"\",1- (G39 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H39=\"\",\"\",1- (H39 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.40818765816378189,6531.0025306205098,75.590307067367007,9468.9974693794902,109.5948781178182,24.016246776629021]
["2014-06-03","1900-01-02",16500,420,null,41.999999999999964,23,5,6930,"",692.99999999999943,379.5,82.5,{"$f":"IF($C40=\"\",\"\",IF(I40=\"\",\"\",I40*1000/data!$B$4))","v":57750},{"$f":"IF($C40=\"\",\"\",IF(J40=\"\",\"\",J40*1000/data!$B$5))","v":""},{"$f":"IF($C40=\"\",\"\",IF(K40=\"\",\"\",K40*1000/data!$B$6))","v":62432.432432432382},{"$f":"IF($C40=\"\",\"\",IF(L40=\"\",\"\",L40*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C40=\"\",\"\",IF(M40=\"\",\"\",M40*1000/data!$B$8))","v":46348.314606741573},55584.892642146428,296.84324671141161,327.38095238095241,654.76190476190482,{"$f":"IF(D40=\"\",\"\",1- (D40 / (data!$B$4*1000/data!$B$3)))","v":0.40500000000000003},{"$f":"IF(E40=\"\",\"\",1- (E40 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F40=\"\",\"\",1- (F40 / (data!$B$6*1000/data!$B$3)))","v":0.35675675675675733},{"$f":"IF(G40=\"\",\"\",1- (G40 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H40=\"\",\"\",1- (H40 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.42730716671727925,7050.5682508351074,81.603799199480406,9449.4317491648926,109.36842302274181,30.136306012307791]
["2014-06-04","1900-01-03",16000,420,null,41.999999999999964,25.800000000000004,5.5,6720,"",671.99999999999943,412.80000000000007,88,{"$f":"IF($C41=\"\",\"\",IF(I41=\"\",\"\",I41*1000/data!$B$4))","v":56000},{"$f":"IF($C41=\"\",\"\",IF(J41=\"\",\"\",J41*1000/data!$B$5))","v":""},{"$f":"IF($C41=\"\",\"\",IF(K41=\"\",\"\",K41*1000/data!$B$6))","v":60540.540540540489},{"$f":"IF($C41=\"\",\"\",IF(L41=\"\",\"\",L41*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C41=\"\",\"\",IF(M41=\"\",\"\",M41*1000/data!$B$8))","v":49438.20224719101},56671.156285168174,282.33057253125918,317.46031746031747,634.92063492063494,{"$f":"IF(D41=\"\",\"\",1- (D41 / (data!$B$4*1000/data!$B$3)))","v":0.40500000000000003},{"$f":"IF(E41=\"\",\"\",1- (E41 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F41=\"\",\"\",1- (F41 / (data!$B$6*1000/data!$B$3)))","v":0.35675675675675733},{"$f":"IF(G41=\"\",\"\",1- (G41 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H41=\"\",\"\",1- (H41 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.39786896447008824,6365.9034315214121,73.679437864831158,9634.0965684785879,111.50574732035402,21.206145008193914]
["2014-06-05","1900-01-04",16500,422,null,42.19999999999996,23,5,6963,"",696.29999999999927,379.5,82.5,{"$f":"IF($C42=\"\",\"\",IF(I42=\"\",\"\",I42*1000/data!$B$4))","v":58025},{"$f":"IF($C42=\"\",\"\",IF(J42=\"\",\"\",J42*1000/data!$B$5))","v":""},{"$f":"IF($C42=\"\",\"\",IF(K42=\"\",\"\",K42*1000/data!$B$6))","v":62729.729729729668},{"$f":"IF($C42=\"\",\"\",IF(L42=\"\",\"\",L42*1000/data!$B$7))","v":55808.823529411769},{"$f":"IF($C42=\"\",\"\",IF(M42=\"\",\"\",M42*1000/data!$B$8))","v":46348.314606741573},55727.966966470754,296.0811401917349,327.38095238095241,654.76190476190482,{"$f":"IF(D42=\"\",\"\",1- (D42 / (data!$B$4*1000/data!$B$3)))","v":0.40216666666666667},{"$f":"IF(E42=\"\",\"\",1- (E42 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F42=\"\",\"\",1- (F42 / (data!$B$6*1000/data!$B$3)))","v":0.3536936936936943},{"$f":"IF(G42=\"\",\"\",1- (G42 / (data!$B$7*1000/data!$B$3)))","v":0.42500000000000004},{"$f":"IF(H42=\"\",\"\",1- (H42 / (data!$B$8*1000/data!$B$3)))","v":0.52247191011235961},0.42583306761818018,7026.2456156999733,81.322287218749693,9473.7543843000276,109.64993500347255,29.722317805350816]
["2014-06-06","1900-01-05",16000,310,null,57.199999999999946,25.800000000000004,5.5,4960,"",915.19999999999914,412.80000000000007,88,{"$f":"IF($C43=\"\",\"\",IF(I43=\"\",\"\",I43*1000/data!$B$4))","v":41333.333333333336},{"$f":"IF($C43=\"\",\"\",IF(J43=\"\",\"\",J43*1000/data!$B$5))","v":""},{"$f":"IF($C43=\"\",\"\",IF(K43=\"\",\"\",K43*1000/data!$B$6))","v":82450.450450450386},{"$f":"IF($C43=\"\",\"\",IF(L43=\"\",\"\",L43*1000/data!$B$7))","v":60705.882352941189},{"$f":"IF($C43=\"\",\"\",IF(M43=\"\",\"\",M43*1000/data!$B$8))","v":49438.20224719101},58481.967095978987,273.5886084977484,317.46031746031747,634.92063492063494,{"$f":"IF(D43=\"\",\"\",1- (D43 / (data!$B$4*1000/data!$B$3)))","v":0.56083333333333329},{"$f":"IF(E43=\"\",\"\",1- (E43 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F43=\"\",\"\",1- (F43 / (data!$B$6*1000/data!$B$3)))","v":0.12396396396396481},{"$f":"IF(G43=\"\",\"\",1- (G43 / (data!$B$7*1000/data!$B$3)))","v":0.35499999999999987},{"$f":"IF(H43=\"\",\"\",1- (H43 / (data!$B$8*1000/data!$B$3)))","v":0.4747191011235955},0.3786290996052234,6058.0655936835747,70.116499926893226,9941.9344063164244,115.06868525829195,15.966530393579305]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C44=\"\",\"\",IF(I44=\"\",\"\",I44*1000/data!$B$4))","v":""},{"$f":"IF($C44=\"\",\"\",IF(J44=\"\",\"\",J44*1000/data!$B$5))","v":""},{"$f":"IF($C44=\"\",\"\",IF(K44=\"\",\"\",K44*1000/data!$B$6))","v":""},{"$f":"IF($C44=\"\",\"\",IF(L44=\"\",\"\",L44*1000/data!$B$7))","v":""},{"$f":"IF($C44=\"\",\"\",IF(M44=\"\",\"\",M44*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D44=\"\",\"\",1- (D44 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E44=\"\",\"\",1- (E44 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F44=\"\",\"\",1- (F44 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G44=\"\",\"\",1- (G44 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H44=\"\",\"\",1- (H44 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C45=\"\",\"\",IF(I45=\"\",\"\",I45*1000/data!$B$4))","v":""},{"$f":"IF($C45=\"\",\"\",IF(J45=\"\",\"\",J45*1000/data!$B$5))","v":""},{"$f":"IF($C45=\"\",\"\",IF(K45=\"\",\"\",K45*1000/data!$B$6))","v":""},{"$f":"IF($C45=\"\",\"\",IF(L45=\"\",\"\",L45*1000/data!$B$7))","v":""},{"$f":"IF($C45=\"\",\"\",IF(M45=\"\",\"\",M45*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D45=\"\",\"\",1- (D45 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E45=\"\",\"\",1- (E45 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F45=\"\",\"\",1- (F45 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G45=\"\",\"\",1- (G45 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H45=\"\",\"\",1- (H45 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C46=\"\",\"\",IF(I46=\"\",\"\",I46*1000/data!$B$4))","v":""},{"$f":"IF($C46=\"\",\"\",IF(J46=\"\",\"\",J46*1000/data!$B$5))","v":""},{"$f":"IF($C46=\"\",\"\",IF(K46=\"\",\"\",K46*1000/data!$B$6))","v":""},{"$f":"IF($C46=\"\",\"\",IF(L46=\"\",\"\",L46*1000/data!$B$7))","v":""},{"$f":"IF($C46=\"\",\"\",IF(M46=\"\",\"\",M46*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D46=\"\",\"\",1- (D46 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E46=\"\",\"\",1- (E46 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F46=\"\",\"\",1- (F46 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G46=\"\",\"\",1- (G46 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H46=\"\",\"\",1- (H46 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C47=\"\",\"\",IF(I47=\"\",\"\",I47*1000/data!$B$4))","v":""},{"$f":"IF($C47=\"\",\"\",IF(J47=\"\",\"\",J47*1000/data!$B$5))","v":""},{"$f":"IF($C47=\"\",\"\",IF(K47=\"\",\"\",K47*1000/data!$B$6))","v":""},{"$f":"IF($C47=\"\",\"\",IF(L47=\"\",\"\",L47*1000/data!$B$7))","v":""},{"$f":"IF($C47=\"\",\"\",IF(M47=\"\",\"\",M47*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D47=\"\",\"\",1- (D47 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E47=\"\",\"\",1- (E47 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F47=\"\",\"\",1- (F47 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G47=\"\",\"\",1- (G47 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H47=\"\",\"\",1- (H47 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C48=\"\",\"\",IF(I48=\"\",\"\",I48*1000/data!$B$4))","v":""},{"$f":"IF($C48=\"\",\"\",IF(J48=\"\",\"\",J48*1000/data!$B$5))","v":""},{"$f":"IF($C48=\"\",\"\",IF(K48=\"\",\"\",K48*1000/data!$B$6))","v":""},{"$f":"IF($C48=\"\",\"\",IF(L48=\"\",\"\",L48*1000/data!$B$7))","v":""},{"$f":"IF($C48=\"\",\"\",IF(M48=\"\",\"\",M48*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D48=\"\",\"\",1- (D48 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E48=\"\",\"\",1- (E48 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F48=\"\",\"\",1- (F48 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G48=\"\",\"\",1- (G48 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H48=\"\",\"\",1- (H48 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C49=\"\",\"\",IF(I49=\"\",\"\",I49*1000/data!$B$4))","v":""},{"$f":"IF($C49=\"\",\"\",IF(J49=\"\",\"\",J49*1000/data!$B$5))","v":""},{"$f":"IF($C49=\"\",\"\",IF(K49=\"\",\"\",K49*1000/data!$B$6))","v":""},{"$f":"IF($C49=\"\",\"\",IF(L49=\"\",\"\",L49*1000/data!$B$7))","v":""},{"$f":"IF($C49=\"\",\"\",IF(M49=\"\",\"\",M49*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D49=\"\",\"\",1- (D49 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E49=\"\",\"\",1- (E49 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F49=\"\",\"\",1- (F49 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G49=\"\",\"\",1- (G49 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H49=\"\",\"\",1- (H49 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,{"$f":"IF($C50=\"\",\"\",IF(D50=\"\",\"\",D50*$C50/1000))","v":""},"",{"$f":"IF($C50=\"\",\"\",IF(F50=\"\",\"\",F50*$C50/1000))","v":""},{"$f":"IF($C50=\"\",\"\",IF(G50=\"\",\"\",G50*$C50/1000))","v":""},{"$f":"IF($C50=\"\",\"\",IF(H50=\"\",\"\",H50*$C50/1000))","v":""},{"$f":"IF($C50=\"\",\"\",IF(I50=\"\",\"\",I50*1000/data!$B$4))","v":""},{"$f":"IF($C50=\"\",\"\",IF(J50=\"\",\"\",J50*1000/data!$B$5))","v":""},{"$f":"IF($C50=\"\",\"\",IF(K50=\"\",\"\",K50*1000/data!$B$6))","v":""},{"$f":"IF($C50=\"\",\"\",IF(L50=\"\",\"\",L50*1000/data!$B$7))","v":""},{"$f":"IF($C50=\"\",\"\",IF(M50=\"\",\"\",M50*1000/data!$B$8))","v":""},"",{"$f":"IF(C50=\"\",\"\",C50/S50*1000)","v":""},{"$f":"IF(C50=\"\",\"\",C50/(14 * 3.6))","v":""},{"$f":"IF(C50=\"\",\"\",U50*2)","v":""},{"$f":"IF(D50=\"\",\"\",1- (D50 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E50=\"\",\"\",1- (E50 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F50=\"\",\"\",1- (F50 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G50=\"\",\"\",1- (G50 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H50=\"\",\"\",1- (H50 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C51=\"\",\"\",IF(I51=\"\",\"\",I51*1000/data!$B$4))","v":""},{"$f":"IF($C51=\"\",\"\",IF(J51=\"\",\"\",J51*1000/data!$B$5))","v":""},{"$f":"IF($C51=\"\",\"\",IF(K51=\"\",\"\",K51*1000/data!$B$6))","v":""},{"$f":"IF($C51=\"\",\"\",IF(L51=\"\",\"\",L51*1000/data!$B$7))","v":""},{"$f":"IF($C51=\"\",\"\",IF(M51=\"\",\"\",M51*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D51=\"\",\"\",1- (D51 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E51=\"\",\"\",1- (E51 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F51=\"\",\"\",1- (F51 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G51=\"\",\"\",1- (G51 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H51=\"\",\"\",1- (H51 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C52=\"\",\"\",IF(I52=\"\",\"\",I52*1000/data!$B$4))","v":""},{"$f":"IF($C52=\"\",\"\",IF(J52=\"\",\"\",J52*1000/data!$B$5))","v":""},{"$f":"IF($C52=\"\",\"\",IF(K52=\"\",\"\",K52*1000/data!$B$6))","v":""},{"$f":"IF($C52=\"\",\"\",IF(L52=\"\",\"\",L52*1000/data!$B$7))","v":""},{"$f":"IF($C52=\"\",\"\",IF(M52=\"\",\"\",M52*1000/data!$B$8))","v":""},"","","","",{"$f":"IF(D52=\"\",\"\",1- (D52 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E52=\"\",\"\",1- (E52 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F52=\"\",\"\",1- (F52 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G52=\"\",\"\",1- (G52 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H52=\"\",\"\",1- (H52 / (data!$B$8*1000/data!$B$3)))","v":""},"","","","","",""]
[null,"",null,null,null,null,null,null,"","","","","",{"$f":"IF($C53=\"\",\"\",IF(I53=\"\",\"\",I53*1000/data!$B$4))","v":""},{"$f":"IF($C53=\"\",\"\",IF(J53=\"\",\"\",J53*1000/data!$B$5))","v":""},{"$f":"IF($C53=\"\",\"\",IF(K53=\"\",\"\",K53*1000/data!$B$6))","v":""},{"$f":"IF($C53=\"\",\"\",IF(L53=\"\",\"\",L53*1000/data!$B$7))","v":""},{"$f":"IF($C53=\"\",\"\",IF(M53=\"\",\"\",M53*1000/data!$B$8))","v":""},{"$f":"IF(C53=\"\",\"\",AVERAGE(N53:R53))","v":""},"","","",{"$f":"IF(D53=\"\",\"\",1- (D53 / (data!$B$4*1000/data!$B$3)))","v":""},{"$f":"IF(E53=\"\",\"\",1- (E53 / (data!$B$5*1000/data!$B$3)))","v":""},{"$f":"IF(F53=\"\",\"\",1- (F53 / (data!$B$6*1000/data!$B$3)))","v":""},{"$f":"IF(G53=\"\",\"\",1- (G53 / (data!$B$7*1000/data!$B$3)))","v":""},{"$f":"IF(H53=\"\",\"\",1- (H53 / (data!$B$8*1000/data!$B$3)))","v":""},{"$f":"IF(AND(D53=\"\",E53=\"\",F53=\"\",G53=\"\",H53=\"\"),\"\",AVERAGE(W53:AA53))","v":""},"","","","",""]
[]
[{"$f":"bi(\"Moyennes\",\"Mittelwerte\")","v":"Mittelwerte"},null,{"$f":"IF(C16=\"\",\"\",AVERAGE(C16:C53))","v":16214.285714285714},{"$f":"IF(D16=\"\",\"\",AVERAGE(D16:D53))","v":""},193.53846153846155,43.328571428571415,24.5,5.2678571428571432,"",3133.6923076923076,702.44999999999982,396.92857142857144,85.357142857142861,"",52228.205128205125,63283.783783783736,58371.848739495814,47953.451043338668,56198.091690973393,289.40735764919543,null,null,{"$f":"IF(W16=\"\",\"\",AVERAGE(W16:W53))","v":""},0.4516410256410256,0.33640926640926688,0.38750000000000007,0.49689004815409316,0.41057467544791987,6660.6101268202401,77.090394986345359,9553.6755874654737,110.57494892899854,25.055124902110769]

{"sheet":"data","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"bi(\"Charge spécifique par EH\",\"Spezifische Frachten pro EW\")","v":"Spezifische Frachten pro EW"},null,null,null,null,"Sprache:",2,"FR"]
[null,null,null,null,null,null,null,"DE"]
[{"$f":"bi(\"débit\",\"Durchfluss\")","v":"Durchfluss"},170,{"$f":"bi(\"(l/EH.d)\",\"(l/EW.Tag)\")","v":"(l/EW.Tag)"}]
[{"$f":"bi(\"DCO\",\"CSB\")","v":"CSB"},120,{"$f":"bi(\"(g O2/EH.d)\",\"(g O2/EW.Tag)\")","v":"(g O2/EW.Tag)"}]
[{"$f":"bi(\"DBO5\",\"BSB5\")","v":"BSB5"},60,{"$f":"bi(\"(g O2/EH.d)\",\"(g O2/EW.Tag)\")","v":"(g O2/EW.Tag)"}]
["Ntot",11.1,{"$f":"bi(\"(g N/EH.d)\",\"(g N/EW.Tag)\")","v":"(g N/EW.Tag)"}]
["NH4",6.8,{"$f":"bi(\"(g N/EH.d)\",\"(g N/EW.Tag)\")","v":"(g N/EW.Tag)"}]
["Ptot",1.78,{"$f":"bi(\"(g P/EH.d)\",\"(g P/EW.Tag)\")","v":"(g P/EW.Tag)"}]

{"sheet":"liste","index":4,"n_rows":105,"n_cols":91,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
["STEP","NoSTEP","Exploitant_prénom","Exploitant_nom","CapBiol","AnCons","AnTrans","Coord_STEP_X","Coord_STEP_Y","Coord_STEP_alt","EX_IMM_NOM","EX_FIN_NOM","Coord_rejet_X","Coord_rejet_Y","Coord_rejet_alt","QSTEP","VBio","DBO5c","DBO5rdt","DOCc","DOCrdt","Ptotc","Ptotrdt","NNH4c","NNH4rdt","NO2c","MESc","champs de reserve (disponible)","Habitants rac.","Lits touristiques rac.","champs de reserve (disponible)","FQ_SORTIE","FDBO5_ENTREE","FDBO5_SORTIE","FCOT_ENTREE","FCOT_SORTIE","FCOD_ENTREE","FCOD_SORTIE","FNH4_ENTREE","FNH4_SORTIE","FNTOT_ENTREE","FNTOT_SORTIE","FNO2_ENTREE","FNO2_SORTIE","FPTOT_ENTREE","FPTOT_SORTIE","FMES_ENTREE","FMES_SORTIE","FTEMP","FBOUES","Langue","Responsable","Type STEP","EH_part_indus","commentaire général","Relevage","Dégrilleur grossier","Dessableur","Déshuileur","Tamiseur","Salsnes","autre","Décantation primaire","Boues activées","Chenal d'oxydation","Lit bactérien","Biofiltre","Disque biologique","Lagunage/Phytoplancton","Classique","Filtration","Micro-tamis","Membrane","Flottation","autre","Filtration","Ozonation","Charbon actif","autre","Methode d'analyse de la DBO5","Choix du débimètre utilisé pour calculs","Le preleveur de sortie mesure","Bypass DP sans eaux usées industrielles","Analyses effectuées par le labo (N° du Labo)","Analyses effectuées par le labo","Epaississement des boues","Stabilisation","Valorisation du biogaz","Déshydratation","Séchage","Incinération"]
[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,"Exigences fréqunce analyse                                        0 = aucune,                          H = horaire,                           J = journalier","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse","Exigences fréqunce analyse",null,null," (1=urbaine, 2=industrielle, 3=mixte)",null,null,"1=absent 2=présent","1=absent 2=présent","1=absent 2=présent","1=absent 2=présent","1=absent 2=présent","1=absent 2=présent","1=absent 2=présent","1=classique, 2=lamellaire, 3=autre, 4=absent","1=faible, 2=moyenne, 3=forte, 4=forte+faible, 5=lit fluidisé, 6=autre","1=absent, 2=présent","1=absent, 2=présent","1=absent, 2=présent","1=absent, 2=présent","1=absent, 2=présent","Clarif. sec.: Classique: 1=absent, 2=présent","Clarif. sec. : Filtration: 1=absent, 2=présent","Clarif. sec. : Micro-tamis: 1=absent, 2=présent","Clarif. sec. : Membrane: 1=absent, 2=présent","Clarif. sec. : Flottation: 1=absent, 2=présent","Clarif. sec. : autre: 1=absent, 2=présent","Traitement tert. : Filtration: 1=absent, 2=présent","Traitement tert. : Ozonation: 1=absent, 2=présent","Traitement tert. : Charbon actif: 1=absent, 2=présent","Traitement tert. : autre: 1=absent, 2=présent","1=Dilution, 2=OxitopC, 3=Hach-Lange, 4=Macherey-Nagel, 5=autre","1=entrée STEP, 2=sortie STEP","1=aucun devers. 2=devers entrée STEP, 3=devers sortie prim., 4= devers. entrée STEP+sortie prim","1=non, 2=oui",null,null,"1=épaississeur statique, 2=table d'égouttage,3= tambour d'égouttage, 4=épaisisseur à vis, 5=flottation, 6=centri, 7=autre","1=digestion, 2=digestion à froid, 3=stabilisation aérée, 4=autre, 5= absent","1=chaudière à gaz, 2=CCF 3=injection réseau, 4 pile combustible  5 pas de valorisation","1=épaississement statique, 2=tasster, 3=presse à vis, 4=centri, 5=filtre à bande, 6= filtre presse 7=autre","1=absent, 2=présent","1=absent, 2=présent"]
["Ausserbinn","6051/00",null,null,100,2001,0,654560,136900,1260,"Binna","Rhône",654430,136820,1140,17,null,20,0,null,null,null,null,null,null,0.3,20,null,29,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(E3<200,0,1)","v":0},2,"MM",1,0,null,1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"à completer",null,"5","5",null,1,1]
["Ayent-Voos","6082/00","Jean-Marie","Morard",11250,1995,0,597920,123270,518,"Lienne","Rhône",597960,122920,516,5400,null,15,90,10,85,0.8,90,null,null,0.3,15,null,3800,9130,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"                   \r\n",1,2,2,2,1,1,2,1,null,1,1,1,2,1,1,1,1,1,1,1,1,1,1,2,1,1,1,1,2,"Ayent-Voos",1,"5",1,2,1,1]
["Bagnes-Le Châble","6031/02","Patrice","Berguerand",19833,1993,0,581750,103500,860,"Dranse de Bagnes","Dranse",581700,103550,855,5950,null,15,90,10,85,0.8,90,null,null,0.3,15,null,7713,40477,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"\r\n",1,2,2,2,2,1,1,2,6,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,3,"Bagnes-LeChable",2,1,2,4,1,1]
["Bagnes-Verbier","6031/01","Patrice","Berguerand",18750,1966,0,582575,104995,1320,"Torrent de Saint Jean","Dranse de Bagnes",582600,104950,1300,3750,null,15,90,10,85,0.8,90,null,null,0.3,15,null,1521,0,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,null,1,2,2,2,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,4,"à completer",1,1,2,4,1,1]
["Binn","6054/00","Paul","Imhof",450,2002,0,657075,134950,1400,"Binna","Rhône",657050,134955,1395,195,null,20,90,null,null,0.8,80,null,null,0.3,20,null,118,444,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,"\r\n",1,2,1,1,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,5,"à completer",1,"5","5",null,1,1]
["Binn-Giesse","6054/01","Paul","Imhof",200,2011,0,658400,135450,1450,"Binna","Rhône",658400,135450,1450,34,25,20,90,null,null,null,null,null,null,0.3,20,null,4,417,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,"Bérénice: selon Meinrad, c'est une sorte de fosse donc on peut indiquer le point de rejet au même endroit que la step..",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,6,"à completer",7,"5","5",null,1,1]
["Bister","6172/00","Beat","Hauser",169,1976,0,648245,135070,905,"Rhône","Rhône",648130,135170,785,35,null,30,90,null,null,null,null,null,null,0.3,null,null,30,40,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"MM",1,0,null,1,2,1,1,1,1,1,1,null,1,1,1,2,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,6,"à completer",7,"5","5",null,1,1]
["Blatten","6192/00","Thomas","Kalbermatten",1200,2000,0,627865,140100,1450,"Lonza","Rhône",627845,139920,1432,420,null,20,90,null,null,0.8,80,null,null,0.3,20,null,306,440,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,"\r\n",1,2,2,1,2,1,1,1,null,1,1,1,2,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,7,"Wiler",1,"5","5",null,1,1]
["Bourg St-Pierre","6032/02","Denis","Darbellay",400,2009,0,582050,89650,1575,"Dranse d'Entremont","Dranse",581922,89773,1520,120,null,20,90,null,null,0.8,80,null,null,0.3,20,null,181,520,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,"Bérénice : anciennes coord point de rejet : 582025/89650 alt. 1570\r\n",1,1,2,2,2,1,1,"4",2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,8,"Bagnes-LeChable",1,"5",1,1,1,1]
["Briggematte-Randa","6287/00","Andreas","Brantschen",6000,1981,0,626410,105530,1400,"Matter Vispa","Vispa",626379,105577,1410,2000,245,20,90,10,85,0.8,85,null,null,0.3,20,null,1571,1265,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,2,"DO",1,0,null,2,1,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,9,"Briggematte-Randa",1,1,1,3,1,1]
["Briglina-Brig","6002/00","Walter","Zeiter",55000,1984,0,639520,128550,660,"Grosser Graben","Rhône",639470,128470,655,20000,3628,15,90,10,85,0.8,90,null,null,0.3,15,null,27233,16312,null,"H",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,"\r\n",2,2,2,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,10,"Briglina-Brig",1,1,2,5,1,1]
["Brunni-Fiesch","6057/00","Armin","Clausen",36167,1981,2001,652900,138180,982,"Rhône (Prise d'eau Fieschertal)","Rhône",652930,138130,978,10800,2192,15,90,10,85,0.8,90,null,null,0.3,15,null,3787,21700,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,2,null,1,0,null,1,1,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,3,1,1,1,11,"Brunni-Fiesch / ARA Goms",1,1,2,5,1,1]
["Chamoson","6022/00","Bernard","Reymond",5000,1978,2001,584900,115100,474,"Rhône","Rhône",585260,114690,472,1500,343,15,90,10,85,0.8,90,null,null,0.3,15,null,3287,2342,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,"Selon BG (diag 2012) capa hydraulique 5352 m3/j (223m3/h)\r\n\r\nPrise en compte du bypass entrée STEP doit être limité par 2 QTS et pas la cap. hydrl. de la STEP !  (Onglet \"contanten_bypass\" E28); + Calculer la charge liée aux forts bypass pendant les vendanges\r\n",1,1,2,2,2,1,1,1,2,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,12,"Chamoson",2,"5","5",5,1,1]
["Champéry","6151/00","Thierry","Marclay",3750,1975,0,556500,113950,925,"Vièze","Rhône",556540,113950,920,1200,500,20,90,10,85,0.8,85,null,null,0.3,20,null,941,7004,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,1,1,2,1,2,1,1,"4",2,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,3,1,1,1,13,"Champery",1,"5","5",4,1,2]
["Charrat","6132/00","Dany","Boson",2125,1977,0,575975,108550,459,"Canal du Syndicat","Rhône",575975,108525,459,680,null,20,90,10,85,0.8,85,null,null,0.3,20,null,0,0,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,14,"à completer",null,"5","5",null,1,1]
["Col Gd St-Bernard","6032/00","Denis","Darbellay",355,1982,0,579390,79740,2450,"Dranse d'Entremont","Dranse",579415,79730,2430,50,null,20,90,null,null,0.8,80,null,null,0.3,20,null,23,200,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,null,1,2,1,1,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,15,"Bagnes-LeChable",null,"5",1,1,1,2]
["Collombey-Illarsaz","6152/02","Frédéric","Sudan",500,1983,1996,560750,129250,384,"Canal des Roselettes","Canal Stockalper",560725,129275,383,150,null,20,90,null,null,0.8,80,2,90,0.3,20,null,647,0,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,null,2,1,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,16,"Vionnaz",1,"5","5",null,1,1]
["Collombey-Muraz","6152/01","Frédéric","Sudan",7500,1978,0,561700,126200,386,"Canal du Bras-Neuf","Canal Stockalper",561725,126270,385,2600,1142,20,90,10,85,0.8,85,3.5,90,0.3,20,null,6663,21,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,"Prise en compte du bypass entrée STEP doit être limité par 2 QTS et pas la cap. hydrl. de la STEP ! \r\nL'exploitant limite à Qmax 53 l/s = 4580 m3/j depuis le 18.12.2012\r\n! Retours du TDBoues perturbent le prélèvement d'entrée jusqu'au 20.09.2012",2,2,2,2,2,1,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,17,"Vionnaz",1,1,1,3,1,1]
["Collombey-Tamoil","6152/00","David","Craquelin",8000,1963,0,562500,125900,390,"Rhône","Rhône",562432,126606,390,12000,null,15,0,null,null,null,null,10,0,null,20,null,0,0,null,"H",52,52,365,365,0,0,52,52,0,0,0,12,0,12,0,52,365,1,1,"PM",2,20000,null,1,1,1,2,1,1,1,3,null,1,2,1,1,1,1,2,1,1,1,1,1,1,2,1,1,2,1,1,18,"Collombey-Tamoil",1,"5","5",null,1,1]
["Conthey-Erde","6023/00","Laurent","Roh",2625,1973,1994,588520,120400,720,"Chenet des Fontaines","Canal Sion-Riddes",588450,120350,705,900,150,20,90,10,85,0.8,85,null,null,0.3,20,null,1734,324,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,2,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,19,"Conthey-Erde",null,3,"5",null,1,1]
["Eisten","6282/00","Django","Wyssen",400,2003,0,635080,116765,1040,"Saaser Vispa","Vispa",635090,116795,1040,40,null,20,90,null,null,null,null,null,null,0.3,20,null,122,211,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,null,1,2,1,1,2,1,2,1,null,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,20,"Eisten",1,"5","5",null,1,1]
["Embd","6283/00","Schaller","Rolf",600,1998,0,631080,118480,858,"Matter Vispa","Vispa",631110,118460,850,192.5,null,20,90,null,null,0.8,80,null,null,0.3,20,null,310,54,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,null,1,0,"\r\n",1,2,2,2,2,1,2,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,21,"St-Niklaus",1,"5","5",null,1,1]
["Evionnaz","6213/00","Jean-Claude","Gex",9000,1989,2010,568090,113830,450,"Rhône","Rhône",568200,113850,448,3600,1212,20,90,10,85,0.8,85,2,90,0.3,20,null,5950,2195,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,"\r\n",2,1,2,2,2,1,1,"4",1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,3,2,1,1,22,"Evionnaz",2,1,2,4,1,1]
["Evionnaz-BASF","6213/11","Vincent","Frachebourg",84600,1988,1993,568080,113800,450,"Rhône","Rhône",568217,113959,448,300,1600,200,95,200,90,12,0,250,0,0.3,300,null,0,0,null,"H",24,24,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,1,"PM",2,25000,null,2,2,2,2,2,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,23,"Evionnaz-BASF",null,"5","5",null,1,1]
["Evolène","6083/00","Didier","Escobar",6000,2010,0,604076,106880,1340,"Borgne","Rhône",604070,106855,1305,1800,null,20,90,10,85,0.8,80,2,90,0.3,20,null,1598,0,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,null,1,1,2,2,2,1,1,2,null,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,24,"Evolène",2,1,2,4,1,1]
["Ferden","6195/00","Leo","Rittler",500,2004,0,624260,137200,1350,"Lonza","Rhône",624360,137210,1310,150,null,20,90,null,null,0.8,80,null,null,0.3,20,null,244,193,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,null,2,2,1,1,2,1,2,1,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,25,"Wiler",null,4,"5",null,1,1]
["Goppenstein","6301/00","Liegenschaften Bewirtschaftung","BLS Netz AG",20,2014,0,624320,135241,1216,"Lonza","Rhône",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,null,1,0,null,1,1,1,1,1,1,1,"4",null,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"5","5",null,1,1]
["Graechen","6285/00","Benito","Pollinger",15750,1991,0,630180,116120,1400,"Schlifiwasser","Matter Vispa",629816,116803,1020,3840,null,15,90,10,85,0.8,90,null,null,0.3,15,null,1221,4,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,2,null,1,0,null,1,1,2,2,2,1,1,1,6,1,2,1,1,1,1,2,1,1,1,1,2,1,1,1,1,1,1,1,26,"Graechen",1,1,2,6,1,1]
["Guttet","6108/00","Beat","Kuonen",1000,1973,2001,617390,129720,1060,"Feschilju","Rhône",618225,129225,950,320,271,20,90,null,null,0.8,80,null,null,0.3,20,null,428,650,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,null,1,0,null,1,2,1,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,27,"Guttet",1,"5","5",1,1,1]
["Hérémence","6084/00","Nicolas","Dayer",3334,1996,0,598375,114400,720,"Borgne","Rhône",598400,114430,710,2000,null,20,90,10,85,0.8,85,2.5,90,0.3,20,null,1000,0,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,1,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,2,1,1,28,"Hérémence",1,"5","5",1,1,1]
["Hérémence-Gde Dixence","6084/01","Aldo","Dayer",250,1996,0,597300,103700,2120,"Dixence","Rhône",597310,103744,2080,50,null,20,90,null,null,0.8,80,null,null,0.3,20,null,0,0,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,"\r\n",1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,29,"SPE / DUS",null,"5","5",null,1,1]
["Hérémence-Mâche","6084/02","Nicolas","Dayer",350,2012,0,596530,111450,1225,"Dixence","Rhône",596593,111428,1220,90,200,15,90,10,85,0.8,80,2,90,0.3,15,null,0,0,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,"\r\n",1,1,1,1,2,1,1,"4",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,29,"Hérémence",2,2,"5",null,1,1]
["Hotel Alpenrösli","6073/00","Siegfried","Steiner",80,0,0,0,0,0,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,null,1,0,"Tropfkérper KSW             \r\n",1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"5","5",null,1,1]
["Icogne","6239/00","Daniel","Kamerzin",1067,1980,0,599375,126025,835,"Torrent de Croge","Liène",599360,126060,825,350,184,20,90,null,null,0.8,80,null,null,0.3,20,null,542,1239,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,null,1,1,2,2,2,1,1,"4",2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,30,"Sierre-Noes",7,3,"5",4,1,1]
["Inden","6109/00","Armin","Bayard",563,1996,0,614190,131520,915,"Dala","Rhône",614300,131465,850,158,null,20,90,null,null,0.8,80,null,null,0.3,20,null,120,154,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,null,1,2,2,2,2,1,1,1,null,1,1,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,31,"Leukerbad",1,"5","5",null,1,1]
["Isérables","6134/00","César","Vuillamoz",2500,1976,0,584865,112085,955,"Fare","Rhône",584830,112090,950,800,null,20,90,10,85,0.8,85,null,null,0.3,20,null,835,493,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,1,1,2,2,2,1,1,1,null,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,32,"Riddes",1,"5","5",4,1,1]
["Kippel","6197/00","Leo","Ritler",1000,2003,0,625500,138460,1340,"Lonza","Rhône",625520,138389,1330,195,null,20,90,null,null,0.8,80,null,null,0.3,20,null,330,210,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,null,1,2,1,1,2,1,2,1,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,33,"Wiler",null,4,"5",null,1,1]
["Lavey-St-Maurice","5406/00","Manuel","Baqueiro",10000,1976,0,0,0,0,null,"Rhône",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,5025,459,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"\r\n",1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"5","5",null,1,1]
["Leukerbad","6111/00","Renald","Allet",13750,1979,0,614080,135140,1290,"Dala","Rhône",614090,135045,1280,5600,700,15,90,10,85,0.8,90,null,null,0.3,15,null,1679,8748,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,2,null,1,0,"Fehler BSB5 Zulauf ARA durch NH4 und Ptot zu korrigieren",1,2,2,2,2,1,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,34,"Leukerbad",2,1,1,5,1,1]
["Leuk-Radet","6110/00","Reinhard","Bregy",30500,1995,0,619060,128720,620,"Rhône","Rhône",619200,128550,618,9766,2710,15,90,10,85,0.8,90,null,null,0.3,15,null,13169,10923,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,null,2,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,35,"Leuk-Radet",1,1,2,5,1,1]
["Leytron","6135/00","Jean-Daniel","Dorsaz",7500,1978,1996,581800,114300,475,"Rhône","Rhône",582000,114000,473,2400,1000,20,90,10,85,0.8,85,null,null,0.3,20,null,2414,0,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,null,2,2,2,2,2,1,1,2,2,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,36,"Leytron",7,3,"5",4,1,1]
["Martigny","6136/00","Jean-Pierre","Chappot",64700,1975,2014,572550,107110,460,"Canal du Syndicat","Rhône",572303,107774,455,20253,1200,15,90,10,85,0.3,90,2,90,0.3,10,null,36017,11229,null,"H",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,null,2,2,2,2,2,1,1,1,3,1,1,2,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,37,"Martigny",2,1,3,4,1,1]
["Mase","6085/00","Marco","Cervetti",867,1980,0,599340,115625,1270,"Décharge du bisse de Tsa Crêta (torrent)","Manna",599490,115560,1210,280,null,20,90,null,null,0.8,80,null,null,0.3,20,null,230,124,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,null,1,1,2,2,2,1,1,"4",null,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,38,"Sierre-Granges",1,"5","5",null,1,1]
["Massongex-Daviaz","6215/00","Laurent","Gallay",188,1977,0,564610,119520,715,"Rogneuse","Rhône",564650,119550,710,53,20,null,null,null,null,null,null,null,null,null,null,null,142,8,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"RB",1,0,null,1,1,1,1,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,39,"à completer",7,"5","5",null,1,1]
["Mex","6216/00","Manuel","Baqueiro",375,1975,0,566075,114575,1000,"Torrent de St. Barthélemy","Rhône",566050,114570,990,105,null,20,90,null,null,0.8,80,null,null,0.3,20,null,130,0,null,"J",0,4,0,0,0,0,0,4,0,0,0,4,0,4,0,0,0,1,1,"RB",1,0,null,1,2,1,1,1,1,1,"4",2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,40,"SPE / DUS",null,2,"5",null,1,1]
["Monthey-CIMO","6153/00","Eric","Guibert",360000,1970,1993,564150,123270,395,"Rhône","Rhône",564105,123430,394,20000,18500,25,95,80,90,0.8,0,20,0,null,40,null,18841,584,null,"H",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,1,"PM",3,0,"Bassin d¿aération Bio I : 2 x 3500 m3 = 7000 m3\r\nBassin d¿aération bio II : 2 x 2390 m3 = 4780 m3    \r\n\r\nMonthey-CIMO: La charge du bypass est calculée avec la concentration moyenne chimie+ville. Vu que le bypass ne concerne que l'eau de ville, il faut corriger. Soustraire les boues BASF brûlées par CIMO.\r\nATTENTION l'entrée ville (EV) est prélevée après DP -> à recalculer les eaux brutes\r\n",2,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,2,41,"Monthey-CIMO",1,"5","5",4,1,1]
["Nendaz-Bieudron","6024/03","Dominique","Theytaz",40500,1982,2006,586250,115250,478,"Rhône","Rhône",586130,115210,477,17700,1512,15,90,10,85,0.3,90,null,null,0.3,15,null,9281,24770,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"STEP mixte à majorité domestique -> assimilé à domestique. Nendaz-Bieudron mesure le bypass sortie primaire déjà avec le rejet de la STEP, il faut manuellement effacer dans l'onglet calc tout les calculs des charges bypass DP+tous les calculs débit bypass DP (onglet \"calc\", colonnes DZ à EF et colonnes GS à GY). \r\n",1,1,2,1,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,3,1,42,"Nendaz-Bieudron",2,1,2,4,1,1]
["Nendaz-Siviez","6024/02","Dominique","Theytaz",2500,1972,0,590550,109900,1690,"Printse","Rhône",590565,109900,1685,800,null,20,90,10,85,0.8,85,null,null,0.3,20,null,32,0,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,43,"à completer",null,"5","5",null,1,1]
["Oberwald-Gletsch","6066/00","Pius","Zumoberhaus",167,1992,0,670820,157260,1760,"Rhône","Rhône",670815,157245,1750,24.5,20,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"MM",1,0,"Hôtel Glacier du Rhône\r\nExploité de mai à octobre",1,1,1,1,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,44,"à completer",7,"5","5",null,1,1]
["Port-Valais","6154/00","Philippe","Moncalvo",7700,1979,2007,556335,136170,374,"Canal Stockalper","Léman",556315,136220,373,2695,1540,20,90,10,85,0.8,85,2,90,0.3,20,null,3430,1977,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,null,2,2,2,2,2,1,1,"4",2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,45,"Vionnaz",1,1,2,1,1,1]
["Regional-ARA Visp","6297/00","Thomas","Kahoun",388833,1976,1990,632400,127750,643,"Grossgrundkanal","Rhône",632290,127800,640,28650,11200,25,95,80,90,0.8,0,40,80,0.3,40,null,11995,3138,null,"H",26,26,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DO",3,0,null,2,1,2,2,2,1,1,3,4,1,1,1,1,1,2,1,1,1,2,1,1,1,1,1,null,null,null,null,null,null,1,3,"5",4,2,2]
["Restaurant Rhonequelle","6072/00","Marzio","Eusebio",60,0,0,0,0,0,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,null,1,0,"Tropfkörper KSW\r\n",1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,46,"Regional-ARA Visp",null,"5","5",null,1,1]
["Riddes","6139/00","Jean-Pascal","Monnet",8750,1978,2002,582730,113340,465,"Rhône","Rhône",582680,114070,468,3150,700,20,90,10,85,0.8,85,null,null,0.3,20,null,2888,7485,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,null,2,2,2,2,2,1,1,2,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,3,1,1,1,47,"Riddes",1,3,"5",6,1,1]
["Saastal","6289/00","Damian","Andenmatten",27367,1989,0,636740,113250,1360,"Saaser Vispa (amén. hydroélec. Mattmark)","Vispa",636641,113257,1330,8760,630,15,90,10,85,0.8,90,null,null,0.3,15,null,3497,14262,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,null,1,2,2,2,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,2,1,1,48,"Saastal",1,1,2,5,1,1]
["Saillon","6140/00","Joao","Mendes",3000,1984,0,581290,112620,460,"Rhône","Rhône",581380,112560,460,1200,null,20,90,10,85,0.8,85,2,90,0.3,20,null,2332,1642,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,"Attention au rendement Salsnes! Il faut corriger les valeurs en entrée!\r\n",2,1,1,1,1,2,1,"4",null,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,49,"Saillon",1,"5","5",4,1,1]
["Saxon","6141/00","Gérard","Lonfat",4900,1977,0,578200,110100,460,"Canal du Syndicat","Rhône",578190,110035,460,1750,900,20,90,10,85,0.8,85,null,null,0.3,20,null,5043,1450,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,2,2,2,2,2,1,1,"4",null,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,50,"Nendaz-Bieudron",1,"5","5",4,1,1]
["Sierre-Granges","6248/02","Paul-Henri","Emery",27500,1976,0,601110,122730,500,"Rhône","Rhône",600720,123000,500,9800,1000,15,90,10,85,0.8,90,null,null,0.3,15,null,10569,20569,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"Attention: retour des boues en amont du prélevement d'entrée !",2,2,2,2,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,51,"Sierre-Granges",null,1,2,4,1,1]
["Sierre-Noes","6248/01","Michel","Favre",97500,1976,1994,605260,125175,516,"Rhône","Rhône",604310,124825,515,30000,null,15,90,10,85,0.3,90,null,null,0.3,15,null,31819,6666,null,"H",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"\r\n",2,2,2,2,2,1,1,2,null,1,1,2,1,1,1,2,1,1,1,1,1,1,1,1,2,2,1,1,52,"Sierre-Noes",3,1,2,4,1,1]
["Simplon-Dorf","6009/01","Edwin","Henzen",450,2008,0,647820,116235,1440,"Chrummbach","Doveria",647850,116260,1410,160,null,20,90,null,null,0.8,80,null,null,0.3,20,null,322,220,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,"Visite le 01/07/2010\r\n",1,2,1,1,1,1,2,1,null,1,1,1,2,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,53,"Briglina-Brig",1,"5","5",1,1,1]
["Simplon-Gabi","6009/00","Harald","Jordan",65,1985,0,114950,649150,1210,"Doveria","Doveria",649170,114950,1205,9,null,null,null,null,null,null,null,null,null,null,null,null,4,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"MM",1,0,null,1,1,1,1,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,54,"à completer",7,"5","5",null,1,1]
["Sion-Chandoline","6266/03","Narcisse","Beney",32500,1980,0,594260,118850,488,"Rhône","Rhône",593860,118695,485,11700,9650,15,90,10,85,0.8,90,null,null,0.3,15,null,15864,9393,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,null,2,1,1,2,2,1,1,"4",2,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,56,"Sion-Chateauneuf",1,"5","5",4,1,1]
["Sion-Chateauneuf","6266/01","Luc","Favre",66667,1971,2000,590800,118760,480,"Rhône","Rhône",590380,117690,478,25837,2476,15,90,10,85,0.3,90,null,null,0.3,15,null,32023,3410,null,"H",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"Sion-Chateauneuf mesure le bypass sortie primaire déjà avec le rejet de la STEP,  il faut manuellement effacer dans l'onglet calc tout les calculs des charges bypass DP+tous les calculs débit bypass DP (onglet \"calc\", colonnes DZ à EF et colonnes GS à GY). ",2,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,2,3,1,57,"Sion-Chateauneuf",2,1,2,4,1,1]
["Sion-Molignon","6266/04","Luc","Favre",125,1984,0,596460,122000,590,"Torrent de Pradelaman (bisse du Clavau)","Canal d'Uvrier",596495,121940,585,15,null,null,null,null,null,null,null,null,null,null,null,null,20,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"RB",1,0,null,1,1,1,1,1,1,1,"4",null,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,58,"à completer",null,"5","5",null,1,1]
["Stalden","6293/00","Johann","Camenisch",8250,1987,2001,633625,121515,695,"Vispa","Rhône",633640,121550,695,1560,null,20,90,10,85,0.8,85,null,null,0.3,20,null,2460,1709,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,2,"DO",1,0,null,1,2,2,1,2,1,1,"4",null,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,59,"Briglina-Brig",1,"5","5",5,1,1]
["Steinhaus","6070/00",null,"ARA Betriebsleiter",140,1995,0,656600,141455,1220,"Rhône","Rhône",656540,141500,1175,24,null,null,null,null,null,null,null,null,null,null,null,null,30,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(E67<200,0,1)","v":0},2,"MM",1,0,"\r\n",1,1,1,1,1,1,1,"4",null,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,60,"à completer",null,"5","5",null,1,1]
["St-Gingolph","6155/00","Daniel","Imhof",3227,1974,2001,552080,137770,390,"Léman",null,552080,137850,385,825,null,20,90,10,85,0.8,85,null,null,0.3,20,null,1344,1525,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,"\r\n",2,1,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,61,"Vionnaz",1,2,"5",5,1,1]
["St-Martin","6087/00","Gery","Gaspoz",2400,1979,0,599815,113895,1270,"Borgne","Rhône",599845,113350,1120,660,520,20,90,10,85,0.8,85,null,null,0.3,20,null,710,761,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,2,1,2,2,2,1,1,"4",2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,62,"St-Martin",null,"5","5",1,1,1]
["St-Martin La Luette","6087/02",null,null,120,0,0,600233,112117,965,"La Borgne","Rhône",600260,112132,960,88,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"RB",1,0,"\r\n",1,1,1,1,1,1,1,1,null,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,2,"5",null,1,1]
["St-Martin Ossona","6087/01",null,"Expoitant STEP",125,2008,0,598670,114530,880,"(infiltration)",null,598670,114530,880,17,null,null,null,null,null,null,null,null,null,null,null,null,4,34,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"RB",1,0,"Bérénice: sorte d'infiltration --> coord. du rejet = coord. step (attentes infos Robert)",1,1,1,1,1,1,1,1,null,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,2,"5",null,1,1]
["St-Martin Praz-Jean","6087/03",null,null,100,0,0,600777,111541,1031,null,null,600764,111514,1020,58.6,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"RB",1,0,"\r\n",1,1,1,1,1,1,1,1,null,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,2,"5",null,1,1]
["St-Niklaus","6292/00","Roman","Brantschen",5875,1990,0,628820,115370,1050,"Matter Vispa","Vispa",628960,115680,1043,1880,330,20,90,10,85,0.8,85,null,null,0.3,20,null,2435,1332,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,2,"DO",1,0,null,2,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,63,"St-Niklaus",1,1,2,1,1,1]
["Trient","6142/00","Lionel","Lugon-Moulin",375,2003,0,565510,101135,1270,"Trient","Rhône",565491,101134,1260,90,72,20,90,null,null,0.8,80,null,null,0.3,20,null,140,417,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,1,"RB",1,0,"\r\n",1,2,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,64,"Martigny",1,"5","5",7,1,1]
["Troistorrents","6156/00","Michel","Défago",13417,1992,0,561110,121580,578,"Vièze","Rhône",561195,121450,520,7425,750,15,90,10,85,0.8,90,null,null,0.3,15,null,4426,9561,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,null,1,1,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,65,"Troistorrents",1,1,1,5,1,1]
["Ulrichen-Nufenen","6071/00","Pius","Zumoberhaus",250,1990,0,672615,148035,2400,"Chummbach","Agene",672310,148165,2240,27,null,20,90,null,null,0.8,80,null,null,0.3,20,null,0,0,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,null,1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,66,"à completer",null,"5","5",null,1,1]
["Unterbäch","6201/00","Erich","Huemer",3750,1971,2000,627760,126600,1140,"Findelsuön","Löübbach",627800,126650,1130,1050,null,20,90,10,85,0.8,85,2,90,0.3,20,null,406,1030,null,"H",12,12,12,0,0,12,12,12,12,0,0,12,12,12,0,12,52,1,2,"MM",1,0,null,1,2,2,2,1,1,2,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,67,"Unterbäch",2,1,1,2,1,1]
["Val d'Anniviers-Fang","6233/00","Dominique","Barmaz",22500,1998,0,610080,121680,815,"Navisence","Rhône",610030,121690,800,6300,null,15,85,10,85,0.3,90,1.5,90,0.3,15,null,2730,23533,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,null,1,2,2,2,2,1,1,2,null,1,1,2,1,1,1,2,1,1,1,1,1,1,1,1,2,1,1,1,68,"Val d'Anniviers-Fang",2,1,2,5,1,1]
["Varen","6116/00","Peter","Oggier",1334,1982,0,612625,129280,656,"Rhône","Rhône",612620,129150,578,400,null,20,90,null,null,0.8,80,null,null,0.3,20,null,625,207,null,"J",0,12,0,0,0,0,0,12,0,0,0,12,0,12,0,0,0,1,2,"MM",1,0,null,1,2,2,1,1,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,69,"Briglina-Brig",1,"5","5",1,2,1]
["Vétroz-Conthey","6025/00","Laurent","Roh",24000,1975,1997,588150,117700,478,"Rhône","Rhône",588400,116570,475,7500,5630,15,90,10,85,0.8,90,null,null,0.3,15,null,11321,472,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,104,104,0,52,52,1,1,"PM",1,0,"Soustraire les boues de Conhey-Erde",2,1,2,2,2,1,1,1,2,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,1,1,1,70,"Vétroz-Conthey",1,1,1,2,1,1]
["Vionnaz","6158/02","Yvan","Werlen",4200,1991,2013,559400,129650,380,"Canal Stockalper","Léman",559440,129690,378,1680,860,15,90,10,85,0.8,90,1,90,0.3,15,null,1943,80,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"PM",1,0,"ne pas subventionner centrif. Imposer trsprt boues à Coll-Muraz\r\n\r\nVionnaz: choisir methode d'analyse --> \"dilution\" car DBO est déjà corrigée dans le fichier de la STEP mixte (au labo, Oxitop est utilisé).  STEP mixte à majorité domestique -> assimilé à domestique",2,1,2,2,2,1,1,"4",1,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,71,"Vionnaz",1,"5","5",5,1,1]
["Vionnaz-Torgon","6158/01","Yvan","Werlen",2800,1977,0,556860,129720,960,"Torrent de Torgon","Avançon",556875,129585,895,1000,155,20,90,10,85,0.8,85,null,null,0.3,20,null,345,3872,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,1,"RB",1,0,null,1,1,2,2,2,1,1,"4",2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,2,1,1,72,"Vionnaz",1,"5","5",5,1,2]
["Vouvry","6159/00","Alain","Pot",5000,1970,2003,557780,132730,380,"Rhône","Rhône",557890,132730,376,1800,1000,20,90,10,85,0.8,85,null,null,0.3,20,null,3372,0,null,"H",52,52,12,0,0,12,52,52,24,0,0,12,52,52,0,52,52,1,1,"PM",1,0,null,1,1,2,2,2,1,1,1,2,1,1,1,1,1,2,1,1,1,1,1,1,1,1,1,2,2,1,1,73,"Vionnaz",1,"5","5",4,1,1]
["Wiler","6202/00","Leo","Rittler",2450,2003,0,626250,138870,1350,"Lonza","Rhône",626177,138826,1340,600,null,20,90,10,85,0.8,85,null,null,0.3,20,null,587,975,null,"H",24,24,12,0,0,12,24,24,24,0,0,12,24,24,0,24,52,1,2,"MM",1,0,null,1,1,1,1,1,1,2,3,null,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,3,1,1,1,74,"Wiler",null,4,"5",null,1,1]
["Zermatt","6300/00","Beni","Zenhäusern",60000,1983,2013,624350,97575,1589,"Matter Vispa","Vispa",624742,97982,1560,17000,null,10,90,10,85,0.5,90,2,90,0.3,10,null,5600,29704,null,"H",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,"Vor Umbau, ab 1983: 40'000 EW ohne Nitrifikation ",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,"5","5",4,1,1]
["Zwischbergen-Gondo","6011/00","Simon","Squaratti",157,1986,0,654270,116285,820,"Doveria","Doveria",654295,116240,820,50,null,null,null,null,null,null,null,null,null,null,null,null,87,0,null,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"MM",1,0,null,1,1,1,1,1,1,1,"4",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,76,"à completer",null,"5","5",null,1,1]
["vide 6","6300/05","à remplir","à remplir",60005,1983,2013,"624350","97575",1594,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DI",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 7","6300/06","à remplir","à remplir",60006,1983,2013,"624350","97575",1595,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"MI",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 8","6300/07","à remplir","à remplir",60007,1983,2013,"624350","97575",1596,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 9","6300/08","à remplir","à remplir",60008,1983,2013,"624350","97575",1597,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"FR",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 10","6300/09","à remplir","à remplir",60009,1983,2013,"624350","97575",1598,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"SA",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 11","6300/10","à remplir","à remplir",60010,1983,2013,"624350","97575",1599,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"SO",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 12","6300/11","à remplir","à remplir",60011,1983,2013,"624350","97575",1600,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"MO",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 13","6300/12","à remplir","à remplir",60012,1983,2013,"624350","97575",1601,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DI",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 14","6300/13","à remplir","à remplir",60013,1983,2013,"624350","97575",1602,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"MI",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 15","6300/14","à remplir","à remplir",60014,1983,2013,"624350","97575",1603,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 16","6300/15","à remplir","à remplir",60015,1983,2013,"624350","97575",1604,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"FR",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 17","6300/16","à remplir","à remplir",60016,1983,2013,"624350","97575",1605,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"SA",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 18","6300/17","à remplir","à remplir",60017,1983,2013,"624350","97575",1606,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"SO",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
["vide 19","6300/00","à remplir","à remplir",60000,1983,2013,"624350","97575",1589,"Matter Vispa",null,"624742","97982",1560,17000,0,10,90,10,85,0.5,90,2,90,0.3,10,null,5726,15120,null,"J",52,52,12,0,0,12,104,104,24,0,0,12,104,104,0,52,52,1,2,"DO",1,0,"-",2,1,2,2,2,1,1,1,6,1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,2,1,1,1,75,"Zermatt",1,5,5,4,1,1]
[null,"Concerne STEP de : ",null,null,40]
[1,{"$f":"A102+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"BM102+1","v":66},67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91]
[]
[{"$f":"A1","v":"STEP"},{"$f":"B1","v":"NoSTEP"},null,null,"CapBiol","AnCons","AnTrans","Coord_STEP_X","Coord_STEP_Y","Coord_STEP_alt","EX_IMM_NOM","EX_FIN_NOM","Coord_rejet_X","Coord_rejet_Y","Coord_rejet_alt","QSTEP","VBio","DBO5c","DBO5rdt","DOCc","DOCrdt","Ptotc","Ptotrdt","NNH4c","NNH4rdt","NO2c","MESc","champs de reserve (disponible)","Habitants rac.","Lits touristiques rac.","champs de reserve (disponible)","FQ_SORTIE","FDBO5_ENTREE","FDBO5_SORTIE","FCOT_ENTREE","FCOT_SORTIE","FCOD_ENTREE","FCOD_SORTIE","FNH4_ENTREE","FNH4_SORTIE","FNTOT_ENTREE","FNTOT_SORTIE","FNO2_ENTREE","FNO2_SORTIE","FPTOT_ENTREE","FPTOT_SORTIE","FMES_ENTREE","FMES_SORTIE","FTEMP","FBOUES","Langue","Responsable","Type STEP","EH_part_indus","commentaire général",{"$f":"BD1","v":"Relevage"},"Dégrilleur grossier","Dessableur","Déshuileur","Tamiseur","Salsnes","autre","Décantation primaire","Boues activées","Chenal d'oxydation","Lit bactérien","Biofiltre","Disque biologique","Lagunage/Phytoplancton","Classique","Filtration","Micro-tamis","Membrane","Flottation","autre","Filtration","Ozonation","Charbon actif","autre","Methode d'analyse de la DBO5","Choix du débimètre utilisé pour calculs","Le preleveur de sortie mesure","Bypass DP sans eaux usées industrielles","Analyses effectuées par le labo (N° du Labo)","Analyses effectuées par le labo","Epaississement des boues","Stabilisation","Valorisation du biogaz","Déshydratation","Séchage","Incinération"]
[{"$f":"IF(INDEX($A$3:$DJ100,$E$101,A102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,A102))","v":"Leuk-Radet"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,B102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,B102))","v":"6110/00"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,C102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,C102))","v":"Reinhard"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,D102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,D102))","v":"Bregy"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,E102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,E102))","v":30500},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,F102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,F102))","v":1995},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,G102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,G102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,H102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,H102))","v":619060},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,I102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,I102))","v":128720},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,J102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,J102))","v":620},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,K102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,K102))","v":"Rhône"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,L102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,L102))","v":"Rhône"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,M102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,M102))","v":619200},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,N102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,N102))","v":128550},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,O102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,O102))","v":618},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,P102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,P102))","v":9766},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,Q102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,Q102))","v":2710},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,R102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,R102))","v":15},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,S102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,S102))","v":90},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,T102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,T102))","v":10},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,U102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,U102))","v":85},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,V102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,V102))","v":0.8},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,W102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,W102))","v":90},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,X102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,X102))","v":""},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,Y102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,Y102))","v":""},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,Z102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,Z102))","v":0.3},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AA102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AA102))","v":15},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AB102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AB102))","v":""},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AC102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AC102))","v":13169},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AD102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AD102))","v":10923},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AE102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AE102))","v":""},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AF102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AF102))","v":"H"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AG102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AG102))","v":52},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AH102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AH102))","v":52},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AI102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AI102))","v":12},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AJ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AJ102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AK102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AK102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AL102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AL102))","v":12},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AM102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AM102))","v":52},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AN102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AN102))","v":52},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AO102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AO102))","v":24},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AP102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AP102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AQ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AQ102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AR102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AR102))","v":12},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AS102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AS102))","v":104},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AT102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AT102))","v":104},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AU102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AU102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AV102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AV102))","v":52},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AW102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AW102))","v":52},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AX102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AX102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AY102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AY102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,AZ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,AZ102))","v":"DO"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BA102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BA102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BB102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BB102))","v":0},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BC102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BC102))","v":""},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BD102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BD102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BE102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BE102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BF102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BF102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BG102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BG102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BH102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BH102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BI102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BI102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BJ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BJ102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BK102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BK102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BL102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BL102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BM102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BM102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BN102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BN102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BO102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BO102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BP102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BP102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BQ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BQ102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BR102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BR102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BS102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BS102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BT102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BT102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BU102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BU102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BV102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BV102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BW102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BW102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BX102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BX102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BY102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BY102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,BZ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,BZ102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CA102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CA102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CB102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CB102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CC102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CC102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CD102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CD102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CE102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CE102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CF102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CF102))","v":35},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CG102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CG102))","v":"Leuk-Radet"},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CH102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CH102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CI102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CI102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CJ102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CJ102))","v":2},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CK102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CK102))","v":5},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CL102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CL102))","v":1},{"$f":"IF(INDEX($A$3:$DJ100,$E$101,CM102)=\"\",\"\",INDEX($A$3:$DJ100,$E$101,CM102))","v":1}]

{"sheet":"exemple, Bsp.","index":5,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,0,28,4],[29,0,29,4],[30,0,30,4],[16,0,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[26,0,26,4],[27,0,27,4]]}
[]
[{"$f":"bi(\"Eaux parasites. Dans les calculs, on utilise la méthode A)\",\"Fremdwasserberechnung. In der Berechnung wird Methode A) angewendet\")","v":"Fremdwasserberechnung. In der Berechnung wird Methode A) angewendet"}]
[]
[{"$f":"bi(\" A) Calcul % eaux claires parasites par rapport aux concentrations en entrée, moyenne annuelle\",\"A) Berechnung % Fremdwasseranteil im Bezug auf Zulaufkonzentrationen, Jahresmittelwert\")","v":"A) Berechnung % Fremdwasseranteil im Bezug auf Zulaufkonzentrationen, Jahresmittelwert"}]
[{"$f":"bi(\"Part des eaux claires totales (Part des eaux claires permanentes et pluviales dans les eaux traitées tout temps confondus)\",\"Gesamter Fremdwasseranteil (ständiger Anteil und Regenwasser, am mittleren Abwasseranfall, unabhängig von der Witterung\")","v":"Gesamter Fremdwasseranteil (ständiger Anteil und Regenwasser, am mittleren Abwasseranfall, unabhängig von der Witterung"}]
[{"$f":"bi(\"EXEMPLE\",\"BEISPIEL\")","v":"BEISPIEL"},{"$f":"bi(\"1 EH\",\"1 EW\")&\" =\"","v":"1 EW ="},60,{"$f":"bi(\"g DBO5 par jour\",\"g BSB5 pro Tag\")","v":"g BSB5 pro Tag"}]
[null,{"$f":"bi(\"1 EH\",\"1 EW\")&\" =\"","v":"1 EW ="},170,{"$f":"bi(\"litres eau usée entrée STEP par jour\",\"Liter Abwasser Zulauf ARA pro Tag\")","v":"Liter Abwasser Zulauf ARA pro Tag"}]
[null,{"$f":"bi(\"correspond à\",\"entspricht\")","v":"entspricht"},{"$f":"C6*1000/C7","v":352.94117647058823},{"$f":"bi(\"mg/l DBO5\",\"mg/l BSB5\")","v":"mg/l BSB5"}]
[]
[{"$f":"bi(\"     Comparaison de la conc. DBO5 en entrée STEP avec la concentration de 353 mg/l DBO5:\",\"     Vergleich der BSB5-Konz. im Zulauf der ARA mit der BSB5-Konzentration von 353 mg/l:\")","v":"     Vergleich der BSB5-Konz. im Zulauf der ARA mit der BSB5-Konzentration von 353 mg/l:"}]
[null,{"$f":"bi(\"Concentration DBO5 analysée en entrée STEP\",\"Analysierte BSB5-Konz. im Zulauf der ARA\")","v":"Analysierte BSB5-Konz. im Zulauf der ARA"},null,null,null,200,"mg/l"]
[null,{"$f":"bi(\"Déficit par rapport à 353 mg/l BSB5\",\"Defizit im Vergleich zu 353 mg/l BSB5\")","v":"Defizit im Vergleich zu 353 mg/l BSB5"},null,null,null,{"$f":"ROUND(1-F11/C8,2)","v":0.43}]
[null,{"$f":"bi(\"Qmoyen\",\"QMittel\")","v":"QMittel"},null,null,null,17500,"m3/d"]
[null,{"$f":"bi(\"Débit ECP en entrée STEP\",\"Durchfluss Fremdwasser im Zulauf der ARA\")","v":"Durchfluss Fremdwasser im Zulauf der ARA"},null,null,null,{"$f":"ROUND(F13*F12,0)","v":7525},"m3/d"]
[]
[{"$f":"bi(\"     Ensuite on peut calculer les débits:\",\"    Danach Berechnung der Durchflüsse:\")","v":"    Danach Berechnung der Durchflüsse:"}]
[{"$f":"bi(\"débit moyen journalier\",\"Mittl. Tägl. Durchfluss\")","v":"Mittl. Tägl. Durchfluss"},null,null,null,null,null,"m3/d","% ECP","l/s"]
[{"$f":"bi(\"Qmoyen\",\"QMittel\")","v":"QMittel"},null,null,null,null,null,17500,null,{"$f":"G18/86.4","v":202.54629629629628}]
[{"$f":"bi(\"ECP\",\"Fremdw.\")","v":"Fremdw."},{"$f":"bi(\" = Qmoyen * % ECP\",\"= QMittel * % Fremdwasser\")","v":"= QMittel * % Fremdwasser"},null,null,null,null,{"$f":"G18*H19","v":10500},0.6,{"$f":"G19/86.4","v":121.52777777777777}]
[{"$f":"bi(\"EU théor.\",\"Th. Abw.\")","v":"Th. Abw."},{"$f":"bi(\" = Qmoyen - ECP\",\" = QMittel - Fremdwasser\")","v":" = QMittel - Fremdwasser"},null,null,null,null,{"$f":"G18-G19","v":7000},null,{"$f":"G20/86.4","v":81.018518518518519}]
[]
[{"$f":"bi(\"B) Calcul quantité d'eaux claires parasites (m3/d) par rapport au débit en entrée, moyenne annuelle\",\"B) Berechnung Fremdwassermenge (m3/d) im Bezug auf Zulaufmenge, Jahresmittelwert\")","v":"B) Berechnung Fremdwassermenge (m3/d) im Bezug auf Zulaufmenge, Jahresmittelwert"}]
[{"$f":"bi(\"Part des eaux claires permanentes, dans les eaux traitées par temps sec\",\"Ständiger Fremdwasseranteil, Abwassermenge bei Trockenwetter\")","v":"Ständiger Fremdwasseranteil, Abwassermenge bei Trockenwetter"}]
[{"$f":"bi(\"     Un autre mode de calcul est de calculer le nb moyen d'EH avec la charge en entrée de la STEP.\",\"     Andere Berechnung: Berechnung der EW mit BSB-Fracht im Zulauf der ARA\")","v":"     Andere Berechnung: Berechnung der EW mit BSB-Fracht im Zulauf der ARA"}]
[{"$f":"bi(\"     Ensuite on calcul de débit eau usée avec la valeur de 170 L / jour / EH.\",\"     Dann wird die Abwassermenge mit 170 L / Tag / EW berechnet.\")","v":"     Dann wird die Abwassermenge mit 170 L / Tag / EW berechnet."}]
[{"$f":"bi(\"     Pour le débit ECP, on calcule: ECP = QTS - Q eau usée.\",\"     Für die Fremdwassermenge, berechnet man: Fremdw. = QTW - Q Abwasser.\")","v":"     Für die Fremdwassermenge, berechnet man: Fremdw. = QTW - Q Abwasser."}]
[{"$f":"bi(\"EH en entrée STEP d'après la charge moyenne DBO5\",\"EW Zulauf ARA gemäss BSB-Fracht\")","v":"EW Zulauf ARA gemäss BSB-Fracht"},null,null,null,null,42000,{"$f":"bi(\"EH\",\"EW\")","v":"EW"}]
[{"$f":"bi(\"Débit eau usée par EH\",\"Abwassermenge pro EW\")","v":"Abwassermenge pro EW"},null,null,null,null,{"$f":"C7","v":170},{"$f":"bi(\"l/EH/jour\",\"L/EW/d\")","v":"L/EW/d"}]
[{"$f":"bi(\"Débit eau usée théorique calculé\",\"Theoretische Abwassermenge berechnet\")","v":"Theoretische Abwassermenge berechnet"},null,null,null,null,{"$f":"F27*F28/1000","v":7140},"m3/d",{"$f":"F29/24*1000/60/60","v":82.638888888888886},"l/s"]
[{"$f":"bi(\"QTS\",\"QTW\")","v":"QTW"},null,null,null,null,14000,"m3/d",{"$f":"F30/24*1000/60/60","v":162.03703703703704},"l/s"]
[{"$f":"A19","v":"Fremdw."},null,null,null,null,{"$f":"F30-F29","v":6860},"m3/d",{"$f":"F31/24*1000/60/60","v":79.398148148148138},"l/s"]
["ECP",null,null,null,null,{"$f":"ROUND(100*F31/F30,0)/100","v":0.49}]