{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1","Erdboden"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Modul1","index":5,"reason":"part_missing"}],"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":"Mittelhilfstabelle","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",67,1030,-14.3,5,null,"00",74,1025.0999999999999,-15.5,0]
["01",74,1029.8,-14.5,6,null,"01",76,1024.8,-15.9,0]
["02",74,1029.5,-14.5,2,null,"02",76,1024.5,-16.2,0]
["03",76,1029.0999999999999,-14.5,2,null,"03",79,1024.0999999999999,-16.399999999999999,0]
["04",77,1028.8,-14.3,0,null,"04",80,1023.8,-16.8,0]
["05",79,1028.9000000000001,-14.5,0,null,"05",81,1023.4,-16.8,0]
["06",81,1028.9000000000001,-15,2,null,"06",83,1023.4,-17,0]
["07",83,1029,-14,2,null,"07",83,1023.3,-17.2,1]
["08",84,1029.2,-13.4,1,null,"08",83,1023.3,-16.5,2]
["09",80,1029.3,-13.2,3,null,"09",80,1023.2,-15.6,2]
["10",71,1029,-14,3,null,"10",74,1023,-14.9,2]
["11",61,1028.5999999999999,-14.3,2,null,"11",70,1022.4,-14.3,2]
["12",56,1027.8,-14.6,4,null,"12",60,1022,-14.3,0]
["13",57,1027.3,-13.9,5,null,"13",53,1021.7,-14.8,2]
["14",54,1026.8,-14.4,6,null,"14",47,1021.5,-15.4,2]
[15,53,1026.3,-14.4,7,null,"15",48,1021.1,-15.2,3]
["16",55,1026.0999999999999,-14.4,7,null,"16",49,1021.1,-15.3,3]
["17",57,1026.0999999999999,-14.5,4,null,"17",51,1021.4,-15.3,3]
[18,59,1026.4000000000001,-14.9,2,null,"18",54,1021.7,-15.2,3]
["19",63,1026.0999999999999,-14.9,1,null,"19",60,1022.1,-14.8,4]
["20",68,1025.9000000000001,-15.2,0,null,"20",60,1022.4,-15,6]
["21",70,1025.7,-15.6,0,null,"21",59,1022.8,-15.4,6]
["22",72,1025.5999999999999,-15.5,0,null,"22",60,1023.1,-15.6,7]
["23",74,1025.3,-15.7,0,null,"23",67,1023.3,-15.3,7]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":68.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":1027.7},{"$f":"AVERAGE(D3:D26)","v":-14.520833333333334},{"$f":"ROUND(AVERAGE(E3:E26),1)","v":2.7},null,"Mittel",{"$f":"ROUND(AVERAGE(H3:H26),1)","v":67},{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1022.9},{"$f":"AVERAGE(J3:J26)","v":-15.612500000000002},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":2.2999999999999998}]
[]
[null,null,null,"2018-02-26",null,null,null,null,null,"2018-02-27"]
[]
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",72,1023.5,-14.8,5,null,"00",73,1031.5999999999999,-12,0]
["01",76,1023.5,-15.1,4,null,"01",74,1031.7,-12.3,0]
["02",74,1023.5,-15.9,0,null,"02",76,1031.7,-12.7,0]
["03",77,1023.5,-16.100000000000001,2,null,"03",74,1031.5,-13.5,0]
["04",80,1023.4,-15.8,0,null,"04",74,1031.5,-14.3,0]
["05",82,1023.8,-16.100000000000001,0,null,"05",76,1031.5,-14.3,3]
["06",81,1024.4000000000001,-16.100000000000001,3,null,"06",79,1031.4000000000001,-14.3,3]
["07",80,1024.9000000000001,-16.5,1,null,"07",80,1031.5,-14.4,1]
["08",77,1025.3,-15.9,2,null,"08",79,1031.7,-14.1,0]
["09",74,1025.7,-15,4,null,"09",76,1031.7,-12.9,0]
["10",67,1025.9000000000001,-14.9,3,null,"10",67,1031.8,-13.3,0]
["11",57,1025.8,-15.2,2,null,"11",59,1031.5999999999999,-13.4,0]
["12",53,1026,-15,2,null,"12",48,1031,-14.7,0]
["13",53,1026,-14.8,2,null,"13",46,1030.9000000000001,-14.9,0]
["14",52,1025.9000000000001,-14.7,1,null,"14",43,1030.3,-15.3,0]
["15",52,1025.5999999999999,-14.8,1,null,"15",44,1029.5999999999999,-15.2,0]
["16",52,1025.7,-15.1,0,null,"16",42,1029.7,-16.100000000000001,1]
["17",55,1025.8,-14.8,0,null,"17",45,1029.7,-15.7,1]
["18",58,1025.9000000000001,-15,0,null,"18",50,1029.9000000000001,-15.5,3]
["19",60,1026.3,-15.2,0,null,"19",53,1030.2,-15.1,5]
["20",63,1026.0999999999999,-15.2,0,null,"20",54,1030.5,-14.3,6]
["21",67,1026,-15,0,null,"21",57,1030.4000000000001,-14.4,2]
["22",66,1025.9000000000001,-15.5,0,null,"22",61,1030.3,-14.7,1]
["23",70,1025.2,-15.5,0,null,"23",65,1030.2,-14.5,2]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":66.599999999999994},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":1025.2},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":-15.3},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":1.3},null,"Mittel",{"$f":"ROUND(AVERAGE(H33:H56),1)","v":62.3},{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1030.9000000000001},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":-14.2},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1.2}]
[]
[null,null,null,"2018-02-28",null,null,null,null,null,"2018-02-25"]

{"sheet":"Kurztabelle","index":1,"n_rows":110,"n_cols":45,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,12,1,13]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","Februar",null,null,null,null,"Jahr:",null,null,"2018"]
[]
["Dat.","TTT","TxTx","TnTn","Tg","Umin.","UU","NN","RRRR","Art",null,"sss","PPPP","eee","fff",null,null,"Tage mit",null,null,null,"fk","Summe "]
[null,null,null,null,null,null,null,null,null,"*",null,null,null,null,"Km/h","SS","Art ( D )","RR","Ge","Bf6","Bf8","Km/h","Gewitter"]
["01.",4.4000000000000004,7.6,1.4,-2.2000000000000002,61,76,6.8,".",null,null,0.4,1001.9,0.6,6,0,null,null,null,null,null,29,null,null,null,null,"max >=30,0°C","max >=25,0°C","max  <0,0°C",null,"RR >=0,1 mm","RR >=1,0 mm","RR >=3,0 mm","RR >=10,0 mm","RR >=20,0 mm",null,null,null,null,null,null,null,null,null,"Hellmann"]
["02.",2.7,6.1,-0.7,-4.4000000000000004,51,69,4.0999999999999996,0.1,"l",null,3.6,1005.4,-2.6,8,0,null,1,null,null,null,32,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":0},{"$f":"COUNTIF(C6:C15,\"<0\")","v":2},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":3},{"$f":"COUNTIF(I6:I15,\">=1\")","v":1},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0},null,null,null,null,null,null,null,null,null,"200 cm3"]
["03.",2.1,3.8,-0.7,-2.2000000000000002,68,80,7.7,1.8,"lT",null,0.2,1005.6,-1,4,0,null,1,null,null,null,26,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":0},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":4},{"$f":"COUNTIF(I18:I27,\">=1\")","v":1},{"$f":"COUNTIF(I18:I27,\">=3\")","v":0},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0},null,null,null,null,null,null,null,null,null,11.4]
["04.",-0.9,0.3,-2.9,-5.6,86,90,6.2,0.2,"T",null,".",1016.8,-2.2999999999999998,1,3,"T",1,null,null,null,13,null,null,null,null,{"$f":"COUNTIF(C30:C37,\">=30\")","v":0},{"$f":"COUNTIF(C30:C37,\">=25\")","v":0},{"$f":"COUNTIF(C30:C37,\"<0\")","v":6},null,{"$f":"COUNTIF(I30:I37,\">=0,1\")","v":0},{"$f":"COUNTIF(I30:I37,\">=1\")","v":0},{"$f":"COUNTIF(I30:I37,\">=3\")","v":0},{"$f":"COUNTIF(I30:I37,\">=10\")","v":0},{"$f":"COUNTIF(I30:I37,\">=20\")","v":0}]
["05.",-2.2999999999999998,-0.2,-6.2,-8.3000000000000007,75,86,5.7,".",null,null,1.3,1027.5,-4.3,2,1,"D",null,null,null,null,18]
["06.",-4.8,0.5,-9.8000000000000007,-10.6,65,82,2.2000000000000002,".",null,null,4.5,1019.7,-7.5,3,1,"D",null,null,null,null,21,null,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",-1.6,1.7,-3.6,-7.2,73,80,2.6,".",null,null,2.1,1015.7,-4.5999999999999996,2,0,"F",null,null,null,null,18,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":9},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":5},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",-2.4,-0.9,-3.9,-6.1,72,80,7.3,".",null,null,".",1020.4,-5.4,2,0,"F",null,null,null,null,15,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":10},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":1},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",-1.5,2.4,-3.8,-5,64,79,4.3,".",null,null,4.3,1018.5,-4.7,1,0,"F",null,null,null,null,18,null,null,null,null,{"$f":"COUNTIF(D30:D37,\"<0\")","v":8},{"$f":"COUNTIF(D30:D37,\"<=-10\")","v":5},null,null,{"$f":"COUNTIF(F30:F37,\">=70\")","v":0},null,{"$f":"COUNTIF(F30:F37,\"<=40\")","v":0}]
["10.",-1,1.1000000000000001,-4.5999999999999996,-6.1,76,82,7.5,".",null,null,".",1017.3,-3.8,2,0,"R",null,null,null,null,18]
["Su",{"$f":"SUM(B6:B15)","v":-5.2999999999999989},{"$f":"SUM(C6:C15)","v":22.400000000000002},{"$f":"SUM(D6:D15)","v":-34.799999999999997},{"$f":"SUM(E6:E15)","v":-57.70000000000001},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":2.1},"XX",null,{"$f":"SUM(L6:L15)","v":16.399999999999999},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":3},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":0},{"$f":"SUM(U6:U15)","v":0},"XXX",null,null,null,null,"ohne Sonne","Son. 0,1-0,9","Son.  >=10,0",null,"Sch. >=1 cm","Sch. >=3 cm","Sch. >=10 cm"]
["Mi",{"$f":"AVERAGE(B6:B15)","v":-0.52999999999999992},{"$f":"AVERAGE(C6:C15)","v":2.2400000000000002},-3.4799999999999995,-5.7700000000000014,69.099999999999994,80.400000000000006,5.4399999999999995,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M6:M15)","v":1014.8799999999999},{"$f":"AVERAGE(N6:N15)","v":-3.56},{"$f":"AVERAGE(O6:O15)","v":3.1},{"$f":"AVERAGE(P6:P15)","v":0.5},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":20.8},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":3},{"$f":"COUNTIF(L6:L15,\"<1\")","v":2},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":3},{"$f":"COUNTIF(P6:P15,\">=3\")","v":1},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",2.1,4.4000000000000004,-0.1,-2.8,65,77,7.5,0.6,"lT",null,0.7,1007.8,-1.6,6,0,"R",1,null,null,null,35,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":2},{"$f":"COUNTIF(L18:L27,\"<1\")","v":2},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",1.5,4.5999999999999996,-0.6,-3.9,64,78,6,0.6,"r",null,1,1011.3,-1.9,6,0,"R",1,null,null,null,27,null,null,null,null,{"$f":"COUNTIF(L30:L37,\".\")","v":0},{"$f":"COUNTIF(L30:L37,\"<1\")","v":0},{"$f":"COUNTIF(L30:L37,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P37,\">=1\")","v":0},{"$f":"COUNTIF(P30:P37,\">=3\")","v":0},{"$f":"COUNTIF(P30:P37,\">=10\")","v":0}]
["13.",-0.4,3.9,-4.0999999999999996,-6.7,49,76,2.8,".",null,null,3.7,1017.5,-4.2,1,0,null,null,null,null,null,23]
["14.",-2.6,3.4,-6.7,-8.3000000000000007,57,77,0.5,".",null,null,5.3,1020.6,-6.1,1,0,null,null,null,null,null,13,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",-1.1000000000000001,2.1,-6.4,-8.3000000000000007,63,76,5,1.3,"lT",null,0.3,1021,-5,8,0,null,1,null,1,null,40,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B37)","v":4.4000000000000004},{"$f":"MAX(C6:C15,C18:C27,C30:C37)","v":8.1999999999999993},{"$f":"MIN(E6:E15,E18:E27,E30:E37)","v":-16.100000000000001},null,{"$f":"MAX(I6:I15,I18:I27,I30:I37)","v":1.8}]
["16.",3,8.1999999999999993,-0.3,-3.3,46,77,3.9,".",null,null,4.9000000000000004,1023.8,-0.9,6,0,"F",null,null,null,null,31,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",0.6,3.1,-2.8,-5,76,83,7.3,0.1,"T",null,".",1025.2,-2,1,0,null,null,null,null,null,13,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B37)","v":-10.4},{"$f":"MIN(D6:D15,D18:D27,D30:D37)","v":-15.1},{"$f":"MIN(F6:F15,F18:F27,F30:F37)","v":42},null,{"$f":"MAX(P6:P15,P18:P27,P30:P37)","v":3}]
["18.",1.1000000000000001,2.2999999999999998,-0.8,-4.4000000000000004,66,78,7.8,".",null,null,".",1028.5,-2.2999999999999998,1,0,null,null,null,null,null,11]
["19.",-0.7,3.6,-4.5999999999999996,-6.7,56,74,5.7,".",null,null,2.2000000000000002,1022.6,-4.9000000000000004,3,0,null,null,null,null,null,27]
["20.",-0.6,3.5,-3.3,-6.1,65,77,4.5,".",null,null,1.2,1019,-4.2,3,0,null,null,null,null,null,19]
["Su",{"$f":"SUM(B18:B27)","v":2.9},{"$f":"SUM(C18:C27)","v":39.1},{"$f":"SUM(D18:D27)","v":-29.7},{"$f":"SUM(E18:E27)","v":-55.5},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":2.6},"XX",null,{"$f":"SUM(L18:L27)","v":19.3},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":3},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":1},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":0.28999999999999998},{"$f":"AVERAGE(C18:C27)","v":3.91},-2.9699999999999998,-5.55,60.7,77.3,5.0999999999999996,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M18:M27)","v":1019.7299999999999},{"$f":"AVERAGE(N18:N27)","v":-3.31},{"$f":"AVERAGE(O18:O27)","v":3.6},{"$f":"AVERAGE(P18:P27)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":23.9}]
["21.",-2.5,1.6,-5.9,-8.3000000000000007,59,78,2.7,".",null,null,4.0999999999999996,1023.8,-6,3,0,null,null,null,null,null,27]
["22.",-3.3,1.2,-7.5,-9.4,51,74,1.7,".",null,null,4,1024.5,-7.5,5,0,null,null,null,null,null,32]
["23.",-5.3,-1.8,-8.1999999999999993,-11.4,56,74,0.8,".",null,null,5.3,1024.9000000000001,-9.1999999999999993,4,0,null,null,null,null,null,26]
["24.",-6.4,-0.7,-10.6,-11.7,47,70,2.6,0,"T",null,3.6,1028.8,-11.2,7,0,null,null,null,null,null,32]
["25.",-8.1,-4.3,-11.9,-13.3,42,62,1.2,".",null,null,6,1030.9000000000001,-14.2,5,0,null,null,null,null,null,24]
["26.",-9.6999999999999993,-5.6,-12.7,-14.4,51,68,2.7,".",null,null,2.2999999999999998,1027.7,-14.5,5,0,null,null,null,null,null,26]
["27.",-10.4,-5.7,-15.1,-16.100000000000001,46,67,2.2999999999999998,".",null,null,5.7,1022.9,-15.6,7,0,null,null,null,null,null,26]
["28.",-10.1,-6.3,-13.9,-15,51,67,1.3,".",null,null,5.7,1025.3,-15.3,7,0,null,null,null,null,null,29]
["Su",{"$f":"SUM(B30:B37)","v":-55.8},{"$f":"SUM(C30:C37)","v":-21.6},{"$f":"SUM(D30:D37)","v":-85.8},{"$f":"SUM(E30:E37)","v":-99.6},"XXX","XXX","XXX",{"$f":"SUM(I30:I37)","v":0},"XX",null,{"$f":"SUM(L30:L37)","v":36.700000000000003},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R37)","v":0},{"$f":"SUM(S30:S37)","v":0},{"$f":"SUM(T30:T37)","v":0},{"$f":"SUM(U30:U37)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B37)","v":-6.9749999999999996},-2.7,-10.725,-12.45,50.375,70,1.9125000000000001,"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M37)","v":1026.0999999999999},{"$f":"AVERAGE(N30:N37)","v":-11.687499999999998},{"$f":"AVERAGE(O30:O37)","v":5.375},{"$f":"AVERAGE(P30:P37)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V37)","v":27.75}]
["MSu",{"$f":"SUM(B16+B28+B38)","v":-58.199999999999996},{"$f":"SUM(C16+C28+C38)","v":39.9},{"$f":"SUM(D16+D28+D38)","v":-150.30000000000001},{"$f":"SUM(E16+E28+E38)","v":-212.8},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I38)","v":4.7},"XX",null,{"$f":"SUM(L16+L28+L38)","v":72.400000000000006},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R38)","v":6},{"$f":"SUM(S16+S28+S38)","v":0},{"$f":"SUM(T16+T28+T38)","v":1},{"$f":"SUM(U16+U28+U38)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B37)","v":-2.0785714285714287},1.425,-5.3678571428571429,-7.6000000000000005,60.75,76.321428571428569,4.3107142857142851,"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M37)","v":1019.8178571428571},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N37)","v":-5.7928571428571436},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O37)","v":3.9285714285714284},{"$f":"AVERAGE(P17,P29,P39)","v":0.16666666666666666},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V39)","v":24.150000000000002}]
[]
[null,"Norm","% v N.-","Abw.","Zahl der Tage",null,null,null,null,null,null,"Niederschlag mm",null,null,null,"Sonnensch.-dauer Std"]
[null,"wert","wert","K","Max.d.Lufttemp.°C",null,null,null,null,null,null,">/=  0,1",null,null,{"$f":"SUM(AE7:AE9)","v":7},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":5}]
["TTT",0.9,"XXXX",{"$f":"SUM(B41-B45)","v":-2.9785714285714286},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":2},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":4}]
["RRR",35,{"$f":"SUM(I40*100/B46)","v":13.428571428571429},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":0},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",78,{"$f":"SUM(L40*100/B47)","v":92.820512820512832},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":8},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":0},"Schneedecke cm"]
["astr.",null,null,"XXXX","Polartag",null,null,null,0,null,null,">/=  20,0",null,null,{"$f":"SUM(AI7:AI9)","v":0},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":3}]
["mgl.",280,{"$f":"SUM(L40*100/B49)","v":25.857142857142861},"XXXX","Min.d.Lufttemp.°C",null,null,null,null,null,null,"Rel. Luftfeuchte 14 Uhr",null,null,null,">/=   3",null,null,null,null,null,{"$f":"SUM(AF17:AF19)","v":1}]
["sss",null,null,"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":27},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":6},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":0}]
[null,null,null,null,"Tropennacht",null,null,null,0,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":0}]
[]
[]
[null,null,null,null,"Unter \"Tage mit\" sind die Angaben Bft 6 & Bft 8 nicht 10 min. - Mittel sonder 2,5 s - Werte."]
[null,null,null,null,"Wenn ein Wert auch mit einem 10 min. - Wert erreicht wird, erfolgt eine rote Markierung."]
[null,null,null,null,"Dies gilt rückwirkend bis November 2012."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Tage mit Bft 6 /8 eigentlich in 10 min. - Mittel"]

{"sheet":"Sichtst.","index":2,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Februar",null,null,null,"Jahr:",2018]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.",null,null,null,null,1,1,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B9),B9*24,\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<1,1,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<8,2,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<24,3,\" \"),\" \")","v":" "},{"$f":"MIN(O9:Q9)","v":0}]
["02.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["03.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["04.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["05.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["06.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["07.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["08.",null,null,1,1,null,null,null,null,null,null,null,null," "," "," "," ",0]
["09.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["10.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["11.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["12.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["13.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["14.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["15.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["16.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["17.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["18.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["19.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["20.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["21.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["22.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["23.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["24.",null,null,1,1,1,1,null,null,null,null,null,null," "," "," "," ",0]
["25.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["26.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["27.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["28.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["Su.",{"$f":"SUM(B9:B36)","v":"00:00:00"},0,9,18,27,3,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C37)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G37)","v":3}]

{"sheet":"Monatsdiagramm","index":3,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,0,2,1],[5,4,5,5],[7,4,7,5]]}
["Klimadiagramm",null,"Wetterstation Köttewitz",null,null,null,null,null,"(214 m ü. NHN)"]
[]
["Februar 2018"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":8.1999999999999993},"am","2018-02-16"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B30","v":-2.0785714285714287},{"$f":"Kurztabelle!B45","v":0.9},{"$f":"C7-D7","v":-2.9785714285714286},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":-15.1},"am","2018-02-27"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I40","v":4.7},{"$f":"Kurztabelle!B46","v":35},{"$f":"100/D9*C9","v":13.428571428571429},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L40","v":72.400000000000006},{"$f":"Kurztabelle!B47","v":78},{"$f":"100/D10*C10","v":92.820512820512832},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Die Wetterstation kann, durch geographische Hindernisse, nicht die maximal mögliche Sonnenscheindauer aufzeichnen. Es gilt ein Übergangsprozentsatz von:"]
["Dez 30 %; Okt/Nov & Jan/Feb 40 %; Mär & Sep 65 %; Apr & Aug 80 %; Mai - Jul 90 %. Durch Baumfällarbeiten seit Orkan Herwart (Okt 2017) Okt & Feb 50 %."]
["Diese Werte entsprechend annähernd 100 % (Normalwert Köttewitz). Nach 10 Jahren erfolgt die Umstellung des Prozentsatzes nach der örtlichen Aufzeichnung."]

{"sheet":"Daten für Diagr.","index":4,"n_rows":117,"n_cols":12,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2018-02-01",4.4000000000000004,7.6,1.4,null,null,0.4,1001.9,0.6,"TM","(T Kari)"]
["2018-02-02",2.7,6.1,-0.7,0.1,null,3.6,1005.4,0.6]
["2018-02-03",2.1,3.8,-0.7,1.8,0,0.2,1005.6,0.6]
["2018-02-04",-0.9,0.3,-2.9,0.2,3,null,1016.8,0.65,"BM","H Dino"]
["2018-02-05",-2.2999999999999998,-0.2,-6.2,null,1,1.3,1027.5,0.65]
["2018-02-06",-4.8,0.5,-9.8000000000000007,null,1,4.5,1019.7,0.65]
["2018-02-07",-1.6,1.7,-3.6,null,0,2.1,1015.7,0.7,"TrM","T Martina"]
["2018-02-08",-2.4,-0.9,-3.9,null,null,null,1020.4,0.7]
["2018-02-09",-1.5,2.4,-3.8,null,null,4.3,1018.5,0.75,"Ww","T Nathalie"]
["2018-02-10",-1,1.1000000000000001,-4.5999999999999996,null,null,null,1017.3,0.75,null,"T Ondra"]
["2018-02-11",2.1,4.4000000000000004,-0.1,0.6,null,0.7,1007.8,0.8,"Wz","T Philine"]
["2018-02-12",1.5,4.5999999999999996,-0.6,0.6,null,1,1011.3,0.8,"TrM"]
["2018-02-13",-0.4,3.9,-4.0999999999999996,null,null,3.7,1017.5,0.85,"BM","H Dino"]
["2018-02-14",-2.6,3.4,-6.7,null,null,5.3,1020.6,0.85,"Ww","T Renate"]
["2018-02-15",-1.1000000000000001,2.1,-6.4,1.3,null,0.3,1021,0.9]
["2018-02-16",3,8.1999999999999993,-0.3,null,null,4.9000000000000004,1023.8,0.9,null,"T Sabine"]
["2018-02-17",0.6,3.1,-2.8,0.1,null,null,1025.2,0.95]
["2018-02-18",1.1000000000000001,2.2999999999999998,-0.8,null,null,null,1028.5,0.95,"HFa","H Enric"]
["2018-02-19",-0.7,3.6,-4.5999999999999996,null,null,2.2000000000000002,1022.6,1]
["2018-02-20",-0.6,3.5,-3.3,null,null,1.2,1019,1]
["2018-02-21",-2.5,1.6,-5.9,null,null,4.0999999999999996,1023.8,1.05,null,"H Fritz"]
["2018-02-22",-3.3,1.2,-7.5,null,null,4,1024.5,1.1000000000000001]
["2018-02-23",-5.3,-1.8,-8.1999999999999993,null,null,5.3,1024.9000000000001,1.1499999999999999,"HNFz"]
["2018-02-24",-6.4,-0.7,-10.6,null,null,3.6,1028.8,1.2]
["2018-02-25",-8.1,-4.3,-11.9,null,null,6,1030.9000000000001,1.25,null,"H Hartmut"]
["2018-02-26",-9.6999999999999993,-5.6,-12.7,null,null,2.2999999999999998,1027.7,1.3]
["2018-02-27",-10.4,-5.7,-15.1,null,null,5.7,1022.9,1.35]
["2018-02-28",-10.1,-6.3,-13.9,null,null,5.7,1025.3,1.4]
["Durchschnitt",{"$f":"AVERAGE(B2:B29)","v":-2.0785714285714287},{"$f":"AVERAGE(C2:C29)","v":1.425},{"$f":"AVERAGE(D2:D29)","v":-5.3678571428571429},"-",null,{"$f":"AVERAGE(G2:G29)","v":3.1478260869565218},{"$f":"AVERAGE(H2:H29)","v":1019.8178571428571},{"$f":"AVERAGE(I2:I29)","v":0.90892857142857142}]
["Mittel",0.9,null,null,35,"-",78,1018.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[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]

{"sheet":"Erdboden","index":6,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,9,5,9],[4,10,5,10],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
[null,null,null,null,null,"Erdbodenstatistik "]
[]
[null,"Wetterstation: ","Köttewitz",null,"Monat:","Februar",null,null,null,"Jahr:",2018]
[]
["Dat.","Temperatur","Temperatur","Temperatur","Temperatur","NN","0 °C - Grenze","5 °C - Grenze","10 °C - Grenze","15 °C - Grenze","20 °C - Grenze"]
[null,"5 cm","-10 cm","- 20 cm","- 35 cm"]
["01.","2,8 °C/5,6 °C/-0,6 °C","5,0 °C/5,6 °C/4,4 °C","5,0 °C/5,0 °C/5,0 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm","< 20; 35 cm >"]
["02.","-2,8 °C/4,4 °C/1,7 °C","2,2 °C/3,3 °C/3,3 °C","3,3 °C/3,3 °C/3,3 °C","5,0 °C/4,4 °C/4,4 °C","n","> 50 cm"]
["03.","1,1 °C/3,9 °C/-1,1 °C","2,8 °C/3,9 °C/3,3 °C","3,3 °C/3,9 °C/3,3 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["04.","-1,1 °C/1,1 °C/-3,3 °C","2,2 °C/2,8 °C/2,2 °C","2,8 °C/2,8 °C/2,8 °C","3,9 °C/3,9 °C/3,9 °C","n","1 cm"]
["05.","-2,8 °C/0,6 °C/-6,1 °C","1,7 °C/2,2 °C/1,7 °C","2,2 °C/2,2 °C/2,2 °C","3,3 °C/3,3 °C/3,3 °C","n","5 cm"]
["06.","-10,6 °C/0,0 °C/-5,0 °C","0,6 °C/0,6 °C/0,6 °C","1,7 °C/1,7 °C/1,1 °C","3,3 °C/2,8 °C/2,8 °C","n","8 cm"]
["07.","-5,6 °C/1,7 °C/-3,9 °C","0,6 °C/0,6 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","2,8 °C/2,2 °C/2,2 °C","n","7 cm"]
["08.","-2,8 °C/1,1 °C/-2,8 °C","0,6 °C/0,6 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","2,2 °C/2,2 °C/2,2 °C","t","6 cm"]
["09.","-3,9 °C/2,8 °C/-5,6 °C","0,6 °C/1,1 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","2,2 °C/2,2 °C/1,7 °C","n","7 cm"]
["10.","-2,8 °C/2,8 °C/0,0 °C","0,6 °C/0,6 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","t","< 0 > 50 cm"]
["11.","-1,7°C/6,7 °C/1,1 °C","0,6 °C/1,1 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","t","> 50 cm"]
["12.","-1,7 °C/6,7 °C/-1,7 °C","0,6 °C/1,1 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","n","> 50 cm"]
["13.","-4,4 °C/3,3 °C/-5,6 °C","0,6 °C/1,1 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","n","7 cm"]
["14.","-7,8 °C/3,3 °C/-5,6 °C","0,0 °C/1,1 °C/0,0 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","h","9 cm"]
["15.","-6,7 °C/3,9 °C/1,1 °C","0,0 °C/0,6 °C/0,6 °C","0,6 °C/0,6 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","n","> 50 cm"]
["16.","0,0 °C/6,7 °C/-0,6 °C","0,6 °C/1,1 °C/0,6 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","n","> 50 cm"]
["17.","-5,0 °C/5,6 °C/-0,6 °C","0,0 °C/1,1 °C/0,6 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","t","> 50 cm"]
["18.","-0,6 °C/3,9 °C/-1,1 °C","0,6 °C/1,1 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","t","> 50 cm"]
["19.","-6,7 °C/6,1 °C/-3,9 °C","0,0 °C/1,1 °C/0,6 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","n","7 cm"]
["20.","-5,0 °C/5,0 °C/-3,9 °C","0,0 °C/1,1 °C/0,6 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","n","6 cm"]
["21.","-5,6 °C/2,8 °C/-6,7 °C","0,0 °C/1,1 °C/0,0 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","n","9 cm"]
["22.","-9,4 °C/2,8 °C/-5,6 °C","0,0 °C/0,6 °C/0,0 °C","0,6 °C/0,6 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","n","10 cm"]
["23.","-8,3 °C/0,6 °C/-10,6 °C","0,0 °C/0,0 °C/0,0 °C","0,0 °C/0,6 °C/0,0 °C","1,7 °C/1,7 °C/1,1 °C","h","10 cm"]
["24.","-11,7 °C/1,7 °C/-8,3 °C","-0,6 °C/0,0 °C/-0,6 °C","0,0 °C/0,0 °C/0,0 °C","1,1 °C/1,1 °C/1,1 °C","n","20 cm"]
["25.","-12,8 °C/-0,6 °C/-8,3 °C","-1,1 °C/-0,6 °C/-1,7 °C","0,0 °C/0,0 °C/-0,6 °C","1,1 °C/1,1 °C/1,1 °C","h","22 cm"]
["26.","-12,2 °C/-3,3 °C/-12,8 °C","-2,8 °C/-1,1 °C/-2,2 °C","-1,1 °C/-0,6 °C/-1,1 °C","1,1 °C/0,6 °C/0,6 °C","n","28 cm"]
["27.","-14,4 °C/-2,8 °C/-8,9 °C","-3,3 °C/-1,7 °C/-2,8 °C","-1,7 °C/-1,1 °C/-1,7 °C","0,6 °C/0,6 °C/0,6 °C","n","31 cm"]
["28.","-14,4 °C/-2,2 °C/-11,1 °C","-3,9 °C/-1,7 °C/-3,3 °C","-2,2 °C/-1,7 °C/-2,2 °C","0,6 °C/0,0 °C/0,0 °C","h","34 cm"]
[]
[null,"Werte von 7 Uhr/14 Uhr/21 Uhr MEZ"]
[]
[null,"Mit Gelb markiert ist der Temperaturbereich des Erdbodens."]