{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["DATEN","Wdh x","Wind x"],"not_rendered":{"charts":2,"images":1,"external_links":1,"defined_names":2,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"DATEN","index":0,"n_rows":53,"n_cols":19,"rows_kept":53}
[null,"Versuchsanstalt Musterhausen",{"$nulls":3},"Gelbe Felder sind zu überschreiben bzw. auszufüllen",{"$nulls":5},"Versuchs-Nr.:",null,null,"xxx"]
[null,"Musterstraße",{"$nulls":3},"Felder mit roter Schrift berrechnen sich aus der dahinter liegenden Formel ",{"$nulls":5},"Versuchs-Datum:",null,null,"xxx"]
[null,"Musterstadt",{"$nulls":9},"Kulturart:",null,null,"xxx"]
["VERSUCHSFLÄCHE",{"$nulls":8},"VERSUCHSANORDNUNG (Kultur)"]
[null,"Betrieb:","xxx",null,null,"Flurstück:",null,null,"Kollektorart:",null,null,"Kollektorgröße:"]
[null,"Straße:","xxx",null,null,"Lage:","xxx",null,"Anzahl je Wdh.:",null,null,"Wiederholungen:"]
[null,"Ort:","xxx",null,null,"Hangneigung:",{"$nulls":4},"Hauptwindrichtung aus xxx°"]
["KULTUR",{"$nulls":8},"VERSUCHSANORDNUNG (Bodensediment/Abtrift)"]
[null,"Sorte:","xxx",null,null,"Unterlage:",null,null,"Standardanordnung Abdrift:",null,null,"Feldbau:",null," "]
[null,"Alter:","xxx",null,null,"Standraum:",{"$nulls":5},"Weinbau:"]
[null,"Anbauform:","xxx",null,null,"Bestandesdichte:",{"$nulls":5},"Obstbau:"]
[null,"Entwicklungsstadium:",{"$nulls":3},"Wüchsigkeit:",{"$nulls":5},"Hopfenbau:"]
[null,"Bestandeshöhe:","xxx","cm",null,"Begrenzung oben:","xxx","cm","Änderungen:"," "]
[{"$nulls":5},"Begrenzung unten:","xxx","cm"]
["BEHANDLUNGSFLÜSSIGKEIT",{"$nulls":7},"Abtrift:  Bodensediment"]
[null,"Flüssigkeitsmenge:",1000,"l",null,"Flüssigkeitsaufwand:",{"v":300,"d":"300.0"},"l/ha","Kollektorart:","z..B. Petrischalen",null,"Kollektorgröße:",null,145]
[null,"Nachweisstoff:","xxx",null,null,"Konzentration",{"$f":"L41/10","v":{"v":0.27952069716775607,"d":"0.280"}},"%","Anzahl je Wdh.:",10,null,"Wiederholungen:",null," "]
[null,"Nachweisstoffmenge:",100,"g",null,"Nachweisstoffaufwand:",{"$f":"G16*G17*10","v":{"v":838.5620915032682,"d":"838.56"}},"g/ha"]
[null,"Hilfsstoffe:"," ",null,null,"Konzentration:",{"$f":"C20/C16/10","v":{"v":0,"d":"0.00"}},"%","Meßentfernungen:",null,"xxx"]
[null,"Hilfsstoffmenge:",null,"g",null,"Hilfsstoffaufwand:",{"$f":"G16*G19*10","v":{"v":0,"d":"0.00"}},"g/ha"]
["PFLANZENSCHUTZGERÄT",{"$nulls":7},"Abtrift: Schwebeteilchen"]
[null,"Hersteller:","Mustermann",null,null,"Typ:","xyz",null,"Kollektorart:","xxx",null,"Kollektorgröße:",null,"xxx"]
[{"$nulls":8},"Anzahl je Wdh.:","xxx",null,"Wiederholungen:",null,"xxx"]
[null,"Arbeitsbreite:","xxx","m",null,"Fahrgeschwindigkeit:","xxx","km/h","Höhe oben:","xxx","m","Vertikaler Abstand:",null,"xxx","m"]
[null,"Behandelte Reihen:","xxx",null,null,"Gesamtdüsenausstoß:",{"$f":"C42+G42","v":{"v":0,"d":"0.00"}},"l/min","Höhe unten:","xxx","m"]
[null,"Düsentyp:","xxx",null,null,"Abstand 1. Düse vom Boden:","xxx","cm"]
[null,"Abspritzwinkel: ","xxx",null,"°","Gestängehöhe:"," ","cm","Bemerkungen:"]
[{"$nulls":4},"°","Spritzdruck:","xxx","bar"]
[null,"Düsenanordnung (von oben nach unten, von hinten betrachtet) und Düsenausstoß:",{"$nulls":6},"Sediment in der Anlage:"]
[null,null,"links",{"$nulls":3},"rechts",null,"Kollektorart:",null,null,"Kollektorgröße:"]
[null,"Größe","Ausstoß (l/min)","Winkel",null,"Größe","Ausstoß (l/min)","Winkel","Anzahl je Wdh.:",null,null,"Wiederholungen:"]
[10,"Musterdüse","xxx",null,10,"Musterdüse","xxx",{"$nulls":4},"Abstand in Fahrtricht.:",null,null,"m"]
[9,"Musterdüse","xxx",null,9,"Musterdüse","xxx"]
[8,"Musterdüse","xxx",null,8,"Musterdüse","xxx",null,"Angaben zum Fluorometer (Messmethodik)"]
[7,"Musterdüse","xxx",null,7,"Musterdüse","xxx",null,"Fluorometer:"]
[6,"Musterdüse","xxx",null,6,"Musterdüse","xxx"]
[5,"Musterdüse","xxx",null,5,"Musterdüse","xxx",null,"Stammlösung im Labor (g/l)",null,null,{"v":1,"d":"1.000"}]
[4,"Musterdüse","xxx",null,4,"Musterdüse","xxx",null,"Verdünnung der Stammlösung",null,null,1000,{"$nulls":5},"Hilfstabelle"]
[3,"Musterdüse","xxx",null,3,"Musterdüse","xxx",null,"Kalibrierlösung der Stammlösgung (g/l)",null,null,{"$f":"L37/L38","v":{"v":1E-3,"d":"0.00100000"}},null,"FI Wert:",{"v":91.8,"d":"91.80"},null,null,{"$f":"L39*1000","v":1},"mg/l"]
[2,"Musterdüse","xxx",null,2,"Musterdüse","xxx",null,"Kalibrierlösung der Stammlösgung (mg/l)",null,null,{"$f":"L39*1000","v":{"v":1,"d":"1.000"}},{"$nulls":5},{"$f":"R39*1000","v":1000},"µg/l"]
[1,"Musterdüse","xxx",null,1,"Musterdüse","xxx",null,"reale Stammlösung der Tankprobe (g/l)",null,null,{"$f":"L43*L42","v":{"v":2.7952069716775605,"d":"2.79520697"}},{"$nulls":5},{"$f":"R40*1000","v":1000000},"ng/l"]
[null,"Summe:",{"$f":"SUM(C32:C41)","v":{"v":0,"d":"0.00"}},"l/min",null,"Summe:",{"$f":"SUM(G32:G41)","v":{"v":0,"d":"0.00"}},"l/min","Verdünnung der Tankprobe:",null,null,1000]
[null,"Stellung der Luftleitbleche:",{"$nulls":6},"Kalibrierlösung der Tankprobe (g/l)",null,null,{"$f":"L39*O43/O39","v":{"v":2.7952069716775606E-3,"d":"0.00279521"}},null,"FI Wert:",{"v":256.6,"d":"256.60"}]
[null,"oben links:",null,"°",null,"oben rechts:",null,"°"]
[null,"unten links:",null,"°",null,"unten rechts:",null,"°","Bemerkungen:"]
[null,"Winkel zur Horizontalen gemessen, nach oben mit (+), nach unten mit (-) gekennzeichnet"]
[null,"Gebläsetyp:","xxx",null,null,"Drehrichtung:","xxx"]
[null,"Getriebestufe:","xxx",null,null,"Drehzahl:","xxx","1/min",null,"WETTERDATEN"]
[null,"Angaben zur ","xxx",{"$nulls":5},"Versuch","Uhrzeit","Temp.","LFrel."]
[null,"Versuchsbeschreibung:","xxx",{"$nulls":7},"°C","%"]
[{"$nulls":8},1,"xxx","xxx","xxx"]
[{"$nulls":8},2,"xxx","xxx","xxx"]
[{"$nulls":8},3,"xxx","xxx","xxx"]

{"sheet":"Wdh x","index":1,"n_rows":60,"n_cols":49,"rows_kept":60}
[null,"Abdrift - Bodensediment",{"$nulls":19},"Versuchs-Nr.:",null,{"$f":"+DATEN!O1","v":"xxx"}]
[{"$nulls":31},"Kalibriergerade (bitte Einheit beachten, "]
[null,"Nachweisstoffaufwand:",{"$nulls":5},{"$f":"+DATEN!G18","v":{"v":838.5620915032682,"d":"838.6"}},"g/ha","bzw.",{"$nulls":3},{"$f":"H3/100","v":{"v":8.385620915032682,"d":"8.386"}},"ug/cm²",null,"Behandelte Reihen:",{"$nulls":4},{"$f":"+DATEN!C25","v":"xxx"},null,"Arbeitsbreite:",{"$nulls":3},{"$f":"+DATEN!C24","v":"xxx"},"m",null,null,"Berechnung erfolgt hier auf Basis von µg/l) "]
[{"$nulls":4},"3 m",{"$nulls":6},"5 m",{"$nulls":6},"10 m",{"$nulls":6},"15 m"]
[{"$nulls":31},"Umrechnunge je nach Gerät anpassen"]
[{"$nulls":31},"µg/l","mg/l",null,"Der Bereich und die Abstände der Kalibrierreihe sind so zu wählen, dass die Messwerte optimal abgebildet werden. "]
[null,"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},null,null,1000,{"$f":"AF7/(1000)","v":1}]
["Meß-","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag",{"$nulls":5},"Werte der Kalibriergraden eingeben!"]
["wert","wert","ml","cm²","µg/l","µg/l","ug/cm²","%","wert","ml","cm²","µg/l","µg/l","ug/cm²","%","wert","ml","cm²","µg/l","µg/l","ug/cm²","%","wert","ml","cm²","µg/l","µg/l","ug/cm²","%",null,null,"Datum:"]
["Nr."," ",{"$nulls":6}," ",{"$nulls":6}," ",{"$nulls":6}," ",{"$nulls":8},"Laborant:",null,null,"Konzentration"]
[1,100,40,145,{"$f":"(B11-$AJ$41-$AA$41)/$AJ$42","v":{"v":8256.204936582286,"d":"8256.2049"}},{"$f":"IF(E11<$AJ$52,\"\",IF(E11<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),E11))","v":{"v":8256.204936582286,"d":"8256.2049"}},{"$f":"IF(F11=\"\",0,((F11)*(C11/D11))*$H$7/1000)","v":{"v":2.2775737756089067,"d":"2.2776"}},{"$f":"(G11)/$N$3*100","v":{"v":27.16046669276404,"d":"27.160"}},"xx","xx",145,{"$f":"(I11-$AJ$41-$AA$41)/$AJ$42","v":{"$error":"#VALUE!"}},{"$f":"IF(L11<$AJ$52,\"\",IF(L11<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),L11))","v":{"$error":"#VALUE!"}},{"$f":"IF(M11=\"\",0,((M11)*(J11/K11))*$O$7/1000)","v":{"$error":"#VALUE!"}},{"$f":"(N11)/$N$3*100","v":{"$error":"#VALUE!"}},"xx","xx",145,{"$f":"(P11-$AJ$41-$AA$41)/$AJ$42","v":{"$error":"#VALUE!"}},{"$f":"IF(S11<$AJ$52,\"\",IF(S11<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),S11))","v":{"$error":"#VALUE!"}},{"$f":"IF(T11=\"\",0,((T11)*(Q11/R11))*$V$7/1000)","v":{"$error":"#VALUE!"}},{"$f":"(U11)/$N$3*100","v":{"$error":"#VALUE!"}},"xx","xx",145,{"$f":"(W11-$AJ$41-$AA$41)/$AJ$42","v":{"$error":"#VALUE!"}},{"$f":"IF(Z11<$AJ$52,\"\",IF(Z11<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),Z11))","v":{"$error":"#VALUE!"}},{"$f":"IF(AA11=\"\",0,((AA11)*(X11/Y11))*$AC$7/1000)","v":{"$error":"#VALUE!"}},{"$f":"(AB11)/$N$3*100","v":{"$error":"#VALUE!"}},null,null,"Projekt:",null,null,"µg/l","FL-Wert"]
[2,50,40,145,{"v":4068.26745960739,"d":"4068.2675"},{"v":4068.26745960739,"d":"4068.2675"},{"$f":"IF(F12=\"\",0,((F12)*(C12/D12))*$H$7/1000)","v":{"v":1.1222806785123836,"d":"1.1223"}},{"$f":"(G12)/$N$3*100","v":{"v":13.383393905876433,"d":"13.383"}},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(M12=\"\",0,((M12)*(J12/K12))*$O$7/1000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(T12=\"\",0,((T12)*(Q12/R12))*$V$7/1000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(AA12=\"\",0,((AA12)*(X12/Y12))*$AC$7/1000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"Versuch:",null,null,"x (µg/l)","y","y_dach","Residuum","(x_i-x_quer)^2","(y_i-y_quer)^2","quadr. Res","(y_i-y_dach_i)^2/(n-2)","s^2_yx*(1+1/n+((x_i-x_quer)^2/[x²])","unteres Prog","oberes Prog"]
[3,20,10,145,{"v":1555.5049734224522,"d":"1555.5050"},{"v":1555.5049734224522,"d":"1555.5050"},{"v":0.10727620506361739,"d":"0.1073"},{"v":1.279287558435967,"d":"1.279"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Nachweisstoff:",null,null,9600,{"v":117.3,"d":"117.30"},{"$f":"$AJ$41+$AJ$42*AI13","v":{"v":116.04363807728555,"d":"116.04"}},{"$f":"AJ13-AK13","v":{"v":1.2563619227144471,"d":"1.26"}},{"$f":"(AI13-$AJ$28)^2","v":{"v":28090000,"d":"28090000.00"}},{"$f":"(AJ13-$AJ$29)^2","v":{"v":4164.551111111111,"d":"4164.55"}},{"$f":"AL13^2","v":{"v":1.5784452808467424,"d":"1.58"}},{"$f":"((AJ13-AK13)^2)/($AJ$35-2)","v":{"v":0.3946113202116856,"d":"0.39"}},{"$f":"$AJ$32*(1+1/$AJ$35+(AM13/$AJ$31))","v":{"v":1.670968321635631,"d":"1.67"}},{"$f":"AK13-SQRT(AQ13)*$AJ$37","v":{"v":112.45464021644534,"d":"112.45"}},{"$f":"AK13+SQRT(AQ13)*$AJ$37","v":{"v":119.63263593812576,"d":"119.63"}}]
[4,10,10,145,{"v":717.9174780274728,"d":"717.9175"},{"v":556.6695497040636,"d":"556.6695"},{"v":0.03839100342786645,"d":"0.0384"},{"v":0.4578194485162561,"d":"0.458"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Analysegerät:",null,null,7200,{"v":85.9,"d":"85.90"},{"v":87.38991517436378,"d":"87.39"},{"$f":"AJ14-AK14","v":{"v":-1.489915174363773,"d":"-1.49"}},{"v":8410000,"d":"8410000.00"},{"v":1097.8177777777787,"d":"1097.82"},{"$f":"AL14^2","v":{"v":2.2198472267994322,"d":"2.22"}},{"v":0.5549618066998581,"d":"0.55"},{"v":1.3497036032906797,"d":"1.35"},{"v":84.16433162991645,"d":"84.16"},{"v":90.61549871881111,"d":"90.62"}]
[5,5,20,145,{"v":299.1237303299831,"d":"299.1237"},{"v":556.6695497040636,"d":"556.6695"},{"v":0.0767820068557329,"d":"0.0768"},{"v":0.9156388970325122,"d":"0.916"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Messeinheit",null,null,4800,{"v":58.3,"d":"58.30"},{"v":58.73619227144202,"d":"58.74"},{"$f":"AJ15-AK15","v":{"v":-0.43619227144202455,"d":"-0.44"}},{"v":250000,"d":"250000.00"},{"v":30.617777777777835,"d":"30.62"},{"v":0.19026369766575282,"d":"0.19"},{"v":0.047565924416438206,"d":"0.05"},{"v":1.2164962810500901,"d":"1.22"},{"v":55.67391519041156,"d":"55.67"},{"v":61.79846935247248,"d":"61.80"}]
[6,2,"xx",145,{"v":47.84748171148935,"d":"47.8475"},"",{"v":0,"d":"0.0000"},{"v":0,"d":"0.000"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Gemessen bei HV ",null,null,2400,{"v":30.2,"d":"30.20"},{"v":30.082469368520254,"d":"30.08"},{"$f":"AJ16-AK16","v":{"v":0.1175306314797453,"d":"0.12"}},{"v":3610000,"d":"3610000.00"},{"v":509.2544444444441,"d":"509.25"},{"v":0.013813449336027695,"d":"0.01"},{"v":0.003453362334006924,"d":"0.00"},{"v":1.2713463549138624,"d":"1.27"},{"v":26.951916573645107,"d":"26.95"},{"v":33.2130221633954,"d":"33.21"}]
[7,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"/Frequenz (high/low)",null,null,1200,{"v":16,"d":"16.00"},{"v":15.75560791705937,"d":"15.76"},{"$f":"AJ17-AK17","v":{"v":0.24439208294062986,"d":"0.24"}},{"v":9610000,"d":"9610000.00"},{"v":1351.7877777777771,"d":"1351.79"},{"v":0.05972749020405971,"d":"0.06"},{"v":0.014931872551014927,"d":"0.01"},{"v":1.369292915384884,"d":"1.37"},{"v":12.50670097742773,"d":"12.51"},{"v":19.00451485669101,"d":"19.00"}]
[8,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$nulls":5},600,{"v":8.9,"d":"8.90"},{"v":8.592177191328929,"d":"8.59"},{"v":0.30782280867107126,"d":"0.31"},{"v":13690000,"d":"13690000.00"},{"v":1924.2844444444438,"d":"1924.28"},{"v":0.09475488153814694,"d":"0.09"},{"v":0.023688720384536736,"d":"0.02"},{"v":1.435896576505179,"d":"1.44"},{"v":5.265193505918205,"d":"5.27"},{"v":11.919160876739653,"d":"11.92"}]
[9,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[10,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Mittelwert",{"$nulls":6},"Mittelwert",{"$nulls":6},"Mittelwert",{"$nulls":6},"Mittelwert"]
[{"$nulls":4},"20 m",{"$nulls":6},"50 m",{"$nulls":6},"100 m",{"$nulls":6},"Leerschalen"]
[]
[]
[null,"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"},"Korrekturfaktor:",{"$nulls":5},{"v":1,"d":"1.00"}]
["Meß-","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag","Meß-","Abw.fl.","Fläche","Konzentration","Valide Messwerte","Belag","Belag"]
["wert","wert","ml","cm²","µg/l","µg/l","ug/cm²","%","wert","ml","cm²","µg/l","µg/l","ug/cm²","%","wert","ml","cm²","µg/l","µg/l","ug/cm²","%","wert","ml","cm²","µg/l","µg/l","ug/cm²","%",{"$nulls":5},"x _quer",{"$f":"AVERAGE(AI13:AI25)","v":{"v":4300,"d":"4300.00"}}]
["Nr."," ",{"$nulls":6}," ",{"$nulls":6}," ",{"$nulls":6}," ",{"$nulls":11},"y_quer",{"$f":"AVERAGE(AJ13:AJ25)","v":{"v":52.76666666666666,"d":"52.77"}}]
[1,"xx","xx",145,{"$f":"(B30-$AJ$41-$AA$41)/$AJ$42","v":{"$error":"#VALUE!"}},{"$f":"IF(E30<$AJ$52,\"\",IF(E30<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),E30))","v":{"$error":"#VALUE!"}},{"$f":"IF(F30=\"\",0,((F30)*(C30/D30))*$H$26/1000)","v":{"$error":"#VALUE!"}},{"$f":"(G30)/$N$3*100","v":{"$error":"#VALUE!"}},"xx","xx",145,{"$f":"(I30-$AJ$41-$AA$41)/$AJ$42","v":{"$error":"#VALUE!"}},{"$f":"IF(L30<$AJ$52,\"\",IF(L30<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),L30))","v":{"$error":"#VALUE!"}},{"$f":"IF(M30=\"\",0,((M30)*(J30/K30))*$O$26/1000)","v":{"$error":"#VALUE!"}},{"$f":"N30/$N$3*100","v":{"$error":"#VALUE!"}},"xx","xx",145,{"$f":"(P30-$AJ$41-$AA$41)/$AJ$42","v":{"$error":"#VALUE!"}},{"$f":"IF(S30<$AJ$52,\"\",IF(S30<$AJ$54,(($AJ$54-$AJ$52)/2+$AJ$52),S30))","v":{"$error":"#VALUE!"}},{"$f":"IF(T30=\"\",0,((T30)*(Q30/R30))*$V$26/1000)","v":{"$error":"#VALUE!"}},{"$f":"U30/$N$3*100","v":{"$error":"#VALUE!"}},0,40,145,{"$f":"(W30-$AJ$41)/$AJ$42","v":{"v":-119.6700173675065,"d":"-119.6700"}},{"$f":"IFERROR(Z30,\"\")","v":{"v":-119.6700173675065,"d":"-119.6700"}},{"$nulls":7},"Reststreuung",{"$f":"SQRT(SUM(AO13:AO25)/($AJ$35-2))","v":{"v":1.0194179744332257,"d":"1.02"}}]
[2,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(F31=\"\",0,((F31)*(C31/D31))*$H$26/1000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(M31=\"\",0,((M31)*(J31/K31))*$O$26/1000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(T31=\"\",0,((T31)*(Q31/R31))*$V$26/1000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},0,40,145,{"v":-119.6700173675065,"d":"-119.6700"},{"$f":"IFERROR(Z31,\"\")","v":{"v":-119.6700173675065,"d":"-119.6700"}},{"$nulls":7},"[x²]",{"$f":"SUM(AM12:AM25)","v":{"v":63660000,"d":"63660000.00"}},"summe(x_i-x_quer)^2"]
[3,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,40,145,{"v":-119.6700173675065,"d":"-119.6700"},{"v":-119.6700173675065,"d":"-119.6700"},{"$nulls":7},"s²_yx",{"$f":"SUM(AP12:AP25)","v":{"v":1.0392130065975407,"d":"1.04"}},"summe((y_i-y_dach_i)^2/(n-2))"]
[4,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,40,145,{"v":-119.6700173675065,"d":"-119.6700"},{"v":-119.6700173675065,"d":"-119.6700"},{"$nulls":20},"Graphik"]
[5,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},"",{"$f":"IF(AA34=\"\",\"\",((AA34)*(X34/Y34))*$AC$26)","v":""},{"$f":"IF(AB34=\"\",\"\",AB34/$N$3*100)","v":""},{"$nulls":18},0,{"$f":"AJ44","v":{"v":4.845301579115308,"d":"4.85"}}]
[6,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},"","","",{"$nulls":5},"Anzahl",{"$f":"COUNT(AJ13:AJ25)","v":6},{"$nulls":11},{"$f":"MAX(AI13:AI25)","v":9600},{"$f":"AJ44","v":{"v":4.845301579115308,"d":"4.85"}}]
[7,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},"","","",{"$nulls":5},"Sig-Niveau",0.05]
[8,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},"","","",{"$nulls":5},"t-Wert",{"$f":"TINV(AJ36,AJ35-2)","v":{"v":2.7764451051977934,"d":"2.776"}},{"$nulls":11},{"$f":"AJ52","v":{"v":286.16638404094635,"d":"286.1664"}},{"v":0,"d":"0.00"}]
[9,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},"","","",{"$nulls":18},{"$f":"AJ52","v":{"v":286.16638404094635,"d":"286.1664"}},{"$f":"MAX(AJ12:AK25)","v":{"v":117.3,"d":"117.30"}}]
[10,"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"xx","xx",145,{"$error":"#VALUE!"},"","",""]
[{"$nulls":34},"Präzisionsberechnung",{"$nulls":12},{"$f":"AJ53","v":{"v":572.3327680818927,"d":"572.3328"}},{"v":0,"d":"0.00"}]
[null,"Mittelwert",{"$nulls":6},"Mittelwert",{"$nulls":6},"Mittelwert",{"$nulls":6},"Mittelwert",{"$nulls":3},{"$f":"IF((AVERAGE(AA30:AA39)<0),0,AVERAGE(AA30:AA39))","v":{"v":0,"d":"0.0000"}},{"$f":"AVERAGE(AB30:AB39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AC30:AC39)","v":{"$error":"#DIV/0!"}},{"$nulls":5},"a-Achsenabschnitt",{"$f":"INTERCEPT(AJ13:AJ25,AI13:AI25)","v":{"v":1.4287464655984863,"d":"1.4"}},{"$nulls":11},{"$f":"AJ53","v":{"v":572.3327680818927,"d":"572.3328"}},{"$f":"MAX(AJ12:AK25)","v":{"v":117.3,"d":"117.30"}}]
[{"$nulls":34},"b-Steigung",{"$f":"SLOPE(AJ13:AJ25,AI13:AI25)","v":{"v":0.011939051209550737,"d":"0.0"}}]
[{"$nulls":34},"wurzel",{"$f":"SQRT((1/1)+(1/AJ35)+(AJ28^2/(SUM(AM13:AM25))))","v":{"v":1.2071105700678222,"d":"1.207"}},{"$nulls":11},{"$f":"AJ54","v":{"v":827.1727153671808,"d":"827.1727"}},{"v":0,"d":"0.00"}]
["Hilfstabelle für Grafik und Auswertung Verlustminderung",{"$nulls":33},"y_p",{"$f":"AJ41+AJ30*AJ37*AJ43","v":{"v":4.845301579115308,"d":"4.85"}},{"$nulls":11},{"$f":"AJ54","v":{"v":827.1727153671808,"d":"827.1727"}},{"$f":"MAX(AJ12:AK25)","v":{"v":117.3,"d":"117.30"}}]
[{"$nulls":34},"s_x0",{"$f":"AJ30/AJ42","v":{"v":85.38517479661485,"d":"85.3852"}}]
[null,{"$f":"E4","v":"3 m"},{"$f":"L4","v":"5 m"},{"$f":"S4","v":"10 m"},{"$f":"Z4","v":"15 m"},{"$f":"E23","v":"20 m"},"50 m",{"$f":"S23","v":"100 m"},"Nullwerte",{"$nulls":25},"VB_x",{"$f":"AJ45*AJ37*SQRT((1/1)+(1/AJ35)+((AJ44-AJ29)^2/(AJ42^2*SUM(AM13:AM25))))","v":{"v":282.4727001129444,"d":"282.4727"}}]
[1,{"$f":"IF(H11<0,0,H11)","v":{"v":27.16046669276404,"d":"27.160"}},{"$f":"IF(O11<0,0,O11)","v":{"$error":"#VALUE!"}},{"$f":"IF(V11<0,0,V11)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC11<0,0,AC11)","v":{"$error":"#VALUE!"}},{"$f":"IF(H30<0,0,H30)","v":{"$error":"#VALUE!"}},{"$f":"IF(O30<0,0,O30)","v":{"$error":"#VALUE!"}},{"$f":"IF(V30<0,0,V30)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC30<0,0,AC30)","v":{"v":0,"d":"0.000"}},{"$nulls":25},"x_p",{"$f":"2*AJ46","v":{"v":564.9454002258888,"d":"564.9454"}}]
[2,{"$f":"IF(H12<0,0,H12)","v":{"v":13.383393905876433,"d":"13.383"}},{"$f":"IF(O12<0,0,O12)","v":{"$error":"#VALUE!"}},{"$f":"IF(V12<0,0,V12)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC12<0,0,AC12)","v":{"$error":"#VALUE!"}},{"$f":"IF(H31<0,0,H31)","v":{"$error":"#VALUE!"}},{"$f":"IF(O31<0,0,O31)","v":{"$error":"#VALUE!"}},{"$f":"IF(V31<0,0,V31)","v":{"$error":"#VALUE!"}},{"$f":"IF(AC31<0,0,AC31)","v":{"v":0,"d":"0.000"}},{"$nulls":25},"VB_x1",{"$f":"AJ45*AJ37*SQRT((1/1)+(1/AJ35)+((MIN(AI13:AI25)-AJ28)^2/SUM(AM13:AM25)))","v":{"v":278.66399322831256,"d":"278.6640"}},"Vertrauensbereich für den niedrigsten Messwert"]
[3,{"v":1.279287558435967,"d":"1.279"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":0,"d":"0.000"},{"$nulls":25},"VB_rel",{"$f":"AJ48/MIN(AI13:AI25)*100","v":{"v":46.443998871385425,"d":"46.4440"}},"rel. Vertrauensbereich (Präzision)"]
[4,{"v":0.4578194485162561,"d":"0.458"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":0,"d":"0.000"}]
[5,{"v":0.9156388970325122,"d":"0.916"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$nulls":26},"µg/l"]
[6,{"v":0,"d":"0.000"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$nulls":24},"NWG","x_N",{"$f":"(AJ44-AJ41)/AJ42","v":{"v":286.16638404094635,"d":"286.1664"}}]
[7,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$nulls":24},"EG","x_E",{"$f":"2*AJ52","v":{"v":572.3327680818927,"d":"572.3328"}}]
[8,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$nulls":24},"BSTG","x_B",{"$f":"3*AJ30/AJ42*AJ37*SQRT((1/1)+(1/AJ35)+((3*AJ52-AJ28)^2/SUM(AM13:AM25)))","v":{"v":827.1727153671808,"d":"827.1727"}}]
[9,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[]
[]
[null,null,"unter der NWG"]
[null,null,"unter der BSTG"]

{"sheet":"Wind x","index":2,"n_rows":6,"n_cols":8,"rows_kept":6}
["Windrichtung und Windgeschwindigkeit "]
[{"$nulls":7},"Skizze zum Versuchsaufbau"]
["Datum","Uhrzeit","Windrichtung","Windgeschwindigkeit","Temperatur","relative Luftfeuchte",null,"Beispielhafte Darstellung für Hauptwindrichtung aus 270°"]
[null,null,"[Grad]","[m/s]","[°C]","[%]"]
[]
["sekündliche Aufzeichnung während der Fahrten oder enstprechende Dateien (csv, txt, xls o.ä.) mitliefern"]