{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1","Erdbodentem."],"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":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,83,1017.4,0,7,null,"00",2,86,1016.2,-0.2,0]
["01",2,90,1017.1,1.1000000000000001,8,null,"01",2,87,1015.4,-0.6,0]
["02",2,92,1018.5,1.4,8,null,"02",1,87,1015,-1.5,1]
["03",2,94,1018.5,1.9,8,null,"03",1,87,1014.1,-1.2,1]
["04",2,95,1018.6,2.1,8,null,"04",1,89,1012.8,-1.7,5]
["05",2,94,1018.7,1.9,8,null,"05",3,83,1011.8,-0.4,3]
["06",1,94,1019.2,1.9,8,null,"06",3,84,1010.8,-0.5,3]
["07",1,93,1019.8,1.7,8,null,"07",3,82,1010.2,-0.2,5]
["08",1,94,1020.5,1.5,8,null,"08"]
["09",2,94,1020.9,1.7,8,null,"09"]
["10",1,94,1021.1,1.6,8,null,"10"]
["11",1,93,1021.3,2,8,null,"11"]
["12",1,87,1021.2,1.9,7,null,"12"]
["13",1,80,1020.7,1.5,7,null,"13"]
["14",1,77,1020,1.5,7,null,"14"]
[15,2,70,1019.4,0.9,7,null,"15"]
["16",2,65,1019.4,-0.3,3,null,"16"]
["17",1,70,1019.1,-0.2,2,null,"17"]
["18",1,79,1019,-0.5,1,null,"18"]
["19",1,82,1019.1,-0.9,1,null,"19"]
["20",1,85,1018.8,-0.5,1,null,"20"]
["21",1,85,1018.4,-0.1,1,null,"21"]
["22",2,86,1017.6,-0.3,2,null,"22"]
["23",2,86,1017.1,-0.6,0,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.4},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":85.9},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1019.2},{"$f":"AVERAGE(E3:E26)","v":0.88333333333333319},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":5.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":2},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":85.6},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1013.3},{"$f":"AVERAGE(L3:L26)","v":-0.78750000000000009},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":2.2999999999999998}]
[]
[null,null,null,null,"2015-02-28",null,null,null,null,null,null,"2015-03-01"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,91,1022.2,-1.5,4,null,"00",2,90,1016.5,-2.8,0]
["01",1,92,1022.5,-1.7,2,null,"01",1,86,1016,-2.4,0]
["02",0,92,1022.6,-2.2999999999999998,0,null,"02",1,87,1015.3,-2.2000000000000002,0]
["03",1,93,1022.9,-2.2000000000000002,0,null,"03",0,91,1014.6,-2.9,0]
["04",1,93,1022.9,-2.4,0,null,"04",0,91,1013.8,-2.9,0]
["05",1,94,1023.3,-2.8,0,null,"05",1,91,1013.6,-3.2,0]
["06",1,94,1023.3,-3.6,0,null,"06",0,92,1013.4,-3.4,0]
["07",0,95,1023.3,-3,1,null,"07",1,91,1013,-3.3,0]
["08",1,95,1023.7,-2.7,0,null,"08",1,93,1013.3,-1.3,0]
["09",0,94,1023.7,-1.8,0,null,"09",1,92,1013,-0.4,0]
["10",1,93,1023.6,-0.3,0,null,"10",1,88,1013,1,0]
["11",1,85,1023.3,1.5,1,null,"11",2,71,1012.7,1.7,0]
["12",1,69,1022.7,1.6,1,null,"12",2,64,1012.6,1.7,0]
["13",1,65,1021.8,1.7,1,null,"13",2,63,1012.4,2.1,1]
["14",1,63,1020.8,1.7,1,null,"14",2,63,1012.1,2.2000000000000002,1]
["15",1,54,1020.1,-0.1,1,null,"15",2,62,1012.2,1.8,2]
["16",2,54,1019.6,-0.5,2,null,"16",2,63,1012.5,1.4,1]
["17",2,59,1019.2,-0.7,1,null,"17",1,69,1012.6,1.3,0]
["18",1,68,1018.9,-0.7,0,null,"18",1,74,1013.5,0.6,1]
["19",1,76,1018.9,-1,0,null,"19",0,79,1014.4,0.1,1]
["20",2,77,1018.5,-1.5,0,null,"20",1,82,1015,-0.2,0]
["21",2,74,1017.9,-2.2000000000000002,0,null,"21",1,86,1015.8,-0.6,0]
["22",1,82,1017.5,-2.4,0,null,"22",1,86,1016.4,-1.1000000000000001,2]
["23",1,83,1016.9,-2.8,0,null,"23",1,85,1016.9,-0.3,5]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":80.599999999999994},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1021.3},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":-1.2},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":0.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.1000000000000001},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":80.8},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1013.9},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":-0.5},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":0.6}]
[]
[null,null,null,null,"2015-02-26",null,null,null,null,null,null,"2015-02-27"]

{"sheet":"Kurztabelle","index":1,"n_rows":110,"n_cols":35,"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,"2015"]
[]
["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,"Bft","SS","Art ( D )","RR","Ge","Bf6","Bf8","Bft","Gewitter"]
["01.",1.3,4.9000000000000004,-1.6,-3.3,63,81,5.8,0,null,null,1.4,990.2,-1.6,1,0,null,null,null,null,null,4,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"]
["02.",1.3,4.0999999999999996,-0.2,-1.7,62,79,6.3,0.3,"S",null,2.2000000000000002,996.6,-1.8,2,0,null,1,null,null,null,4,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":7},{"$f":"COUNTIF(I6:I15,\">=1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",1.1000000000000001,3.6,-0.3,-1.1000000000000001,67,82,6.7,0.8,"S",null,2,1001.6,-1.7,2,1,"D",1,null,null,null,5,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":0},{"$f":"COUNTIF(I18:I27,\">=1\")","v":0},{"$f":"COUNTIF(I18:I27,\">=3\")","v":0},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",-1.6,-0.1,-3.4,-4.4000000000000004,81,89,7.4,0.4,"S",null,".",1012,-3.1,1,2,"D",1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(C30:C37,\">=30\")","v":0},{"$f":"COUNTIF(C30:C37,\">=25\")","v":0},{"$f":"COUNTIF(C30:C37,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I37,\">=0,1\")","v":3},{"$f":"COUNTIF(I30:I37,\">=1\")","v":1},{"$f":"COUNTIF(I30:I37,\">=3\")","v":0},{"$f":"COUNTIF(I30:I37,\">=10\")","v":0},{"$f":"COUNTIF(I30:I37,\">=20\")","v":0}]
["05.",-1.8,0.3,-3.4,-3.9,69,86,7.2,0,"S",null,1.6,1022,-3.9,1,1,"D",1,null,null,null,4]
["06.",-1.9,-0.9,-3.1,-3.9,81,84,7.8,".",null,null,0.1,1028,-4.3,2,1,"D",null,null,null,null,5,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.4,2.8,-4.9000000000000004,-7.2,61,81,6.6,1,"R;S",null,3.7,1026.8,-4.4000000000000004,2,1,"D",1,null,1,null,7,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":3},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",0.8,3,-0.8,-2.2000000000000002,51,74,5.5,0.3,"R;S",null,1.3,1019.2,-3.3,3,2,"D",1,1,1,null,7,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":6},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",2.8,4.4000000000000004,-0.8,-2.2000000000000002,67,90,7.8,1.8,"R",null,".",1021,1.2,3,0,null,1,null,1,null,7,null,null,null,null,{"$f":"COUNTIF(D30:D37,\"<0\")","v":4},{"$f":"COUNTIF(D30:D37,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F37,\">=70\")","v":2},null,{"$f":"COUNTIF(F30:F37,\"<=40\")","v":0}]
["10.",4.2,4.7,3.6,2.8,89,93,8,0.1,"R",null,".",1027,3.1,2,0,null,1,null,null,null,5]
["Su",{"$f":"SUM(B6:B15)","v":4.8},{"$f":"SUM(C6:C15)","v":26.8},-14.9,-27.099999999999998,"XXX","XXX",{"$f":"SUM(H6:H15)","v":69.099999999999994},{"$f":"SUM(I6:I15)","v":4.6999999999999993},"XX",null,{"$f":"SUM(L6:L15)","v":12.3},{"$f":"SUM(M6:M15)","v":10144.4},-19.800000000000004,19,{"$f":"SUM(P6:P15)","v":8},"X",{"$f":"SUM(R6:R15)","v":8},{"$f":"SUM(S6:S15)","v":1},3,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.48},{"$f":"AVERAGE(C6:C15)","v":2.68},-1.49,-2.71,"XXX",83.9,6.9099999999999993,"XXX","XX",null,{"$f":"L16/10","v":1.23},{"$f":"AVERAGE(M6:M15)","v":1014.4399999999999},{"$f":"AVERAGE(N6:N15)","v":-1.9800000000000004},1.9,{"$f":"ROUND(AVERAGE(P6:P15),1)","v":0.8},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":5.0999999999999996},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":3},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":6},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",3.1,4.5999999999999996,-1.7,-2.8,82,88,7,".",null,null,".",1027.8,1.4,1,0,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":2},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$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.",-0.3,3.9,-2.8,-5,77,90,0.5,".",null,null,3.8,1022.6,-1.3,2,0,null,null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(L30:L37,\".\")","v":0},{"$f":"COUNTIF(L30:L37,\"<1\")","v":1},{"$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.",1.2,4.4000000000000004,-0.7,-2.8,77,86,0,".",null,null,4.2,1020.5,-0.9,2,0,null,null,null,null,null,5]
["14.",0.4,3.2,-1.2,-3.9,80,88,0.3,".",null,null,4,1014.9,-1.5,2,0,null,null,null,null,null,5,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",3.4,7.1,-1.1000000000000001,-3.9,68,81,4.7,".",null,null,0.3,1016.5,0.3,2,0,null,null,null,null,null,5,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B37)","v":4.5999999999999996},{"$f":"MAX(C6:C15,C18:C27,C30:C37)","v":9.9},{"$f":"MIN(E6:E15,E18:E27,E30:E37)","v":-7.2},null,{"$f":"MAX(I6:I15,I18:I27,I30:I37)","v":2.2000000000000002}]
["16.",3.2,9.9,-0.1,-2.8,55,78,0,".",null,null,4.3,1022.3,-0.4,2,0,null,null,null,null,null,4,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",2.2999999999999998,6.1,-0.2,-3.3,72,84,2.4,".",null,null,4.3,1030.5999999999999,-0.1,2,0,null,null,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B37)","v":-1.9},{"$f":"MIN(D6:D15,D18:D27,D30:D37)","v":-4.9000000000000004},{"$f":"MIN(F6:F15,F18:F27,F30:F37)","v":49},null,{"$f":"MAX(P6:P15,P18:P27,P30:P37)","v":2}]
["18.",2.6,4.7,-1.6,-2.8,79,87,6.4,".",null,null,".",1039.3,0.7,1,0,null,null,null,null,null,3]
["19.",0.8,6.7,-2.9,-4.4000000000000004,67,86,0.7,".",null,null,4.0999999999999996,1030,-1.3,1,0,null,null,null,null,null,3]
["20.",2.7,8.9,-4.5,-5.6,65,79,0,".",null,null,4,1017,-0.8,2,0,null,null,null,null,null,5]
["Su",{"$f":"SUM(B18:B27)","v":19.399999999999999},{"$f":"SUM(C18:C27)","v":59.500000000000007},-16.8,-37.300000000000004,"XXX","XXX",{"$f":"SUM(H18:H27)","v":22},{"$f":"SUM(I18:I27)","v":0},"XX",null,{"$f":"SUM(L18:L27)","v":29},{"$f":"SUM(M18:M27)","v":10241.5},-3.9000000000000004,17,{"$f":"SUM(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":0},{"$f":"SUM(S18:S27)","v":0},0,0,"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":1.94},{"$f":"AVERAGE(C18:C27)","v":5.9500000000000011},-1.6800000000000002,-3.7300000000000004,72.2,84.7,2.2000000000000002,"XXX","XX",null,{"$f":"L28/10","v":2.9},{"$f":"AVERAGE(M18:M27)","v":1024.1500000000001},{"$f":"AVERAGE(N18:N27)","v":-0.39},1.7,{"$f":"ROUND(AVERAGE(P18:P27),1)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4.3}]
["21.",4.5999999999999996,9.6,0.5,-2.8,63,76,4.0999999999999996,0,null,null,2.2000000000000002,1001.5,0.6,2,0,null,null,null,1,null,6]
["22.",2.9,5.3,-1.2,-3.3,75,83,6.6,".",null,null,0.3,1008.6,0.4,1,0,null,null,null,null,null,3]
["23.",3,7.7,-1.2,-3.3,67,86,4.9000000000000004,2.2000000000000002,"R",null,1.4,1002.7,0.7,2,0,null,1,null,null,null,5]
["24.",4.5,9.1999999999999993,0.9,-1.1000000000000001,53,78,6.9,".",null,null,3.4,1007,0.8,1,0,null,null,null,null,null,4]
["25.",3.3,7.4,0.7,-1.7,70,82,5.0999999999999996,".",null,null,1.6,1018.2,0.6,1,0,null,null,null,null,null,4]
["26.",2,9.1,-2.8,-3.9,49,81,0.6,".",null,null,5.2,1021.3,-1.2,1,0,null,null,null,null,null,3]
["27.",2.7,9.1,-2.4,-4.4000000000000004,60,81,0.6,0.4,"R",null,5.6,1013.9,-0.5,1,0,null,1,null,null,null,4]
["28.",3.1,6.1,1.1000000000000001,-1.7,64,86,5.6,0.3,"R",null,1.3,1019.2,0.9,1,0,null,1,null,null,null,3]
["Su",{"$f":"SUM(B30:B37)","v":26.1},{"$f":"SUM(C30:C37)","v":63.5},{"$f":"SUM(D30:D37)","v":-4.4000000000000004},{"$f":"SUM(E30:E37)","v":-22.2},"XXX",{"$f":"SUM(G30:G37)","v":653},{"$f":"SUM(H30:H37)","v":34.400000000000006},{"$f":"SUM(I30:I37)","v":2.9},"XX",null,{"$f":"SUM(L30:L37)","v":21.000000000000004},{"$f":"SUM(M30:M37)","v":8092.4},{"$f":"SUM(N30:N37)","v":2.3000000000000003},{"$f":"SUM(O30:O37)","v":10},{"$f":"SUM(P30:P37)","v":0},"X",{"$f":"SUM(R30:R37)","v":3},{"$f":"SUM(S30:S37)","v":0},{"$f":"SUM(T30:T37)","v":1},{"$f":"SUM(U30:U37)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B37)","v":3.2625000000000002},{"$f":"AVERAGE(C30:C37)","v":7.9375},{"$f":"AVERAGE(D30:D37)","v":-0.55000000000000004},{"$f":"AVERAGE(E30:E37)","v":-2.7749999999999999},"XXX",{"$f":"AVERAGE(G30:G37)","v":81.625},{"$f":"AVERAGE(H30:H37)","v":4.3000000000000007},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M37)","v":1011.55},{"$f":"AVERAGE(N30:N37)","v":0.28750000000000003},{"$f":"AVERAGE(O30:O37)","v":1.25},{"$f":"ROUND(AVERAGE(P30:P37),1)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V37)","v":4}]
["MSu",{"$f":"SUM(B16+B28+B38)","v":50.3},{"$f":"SUM(C16+C28+C38)","v":149.80000000000001},{"$f":"SUM(D16+D28+D38)","v":-36.1},{"$f":"SUM(E16+E28+E38)","v":-86.600000000000009},"XXX","XXX,",{"$f":"SUM(H16+H28+H38)","v":125.5},{"$f":"SUM(I16+I28+I38)","v":7.6},"XX",null,{"$f":"SUM(L16+L28+L38)","v":62.3},{"$f":"SUM(M16+M28+M38)","v":28478.300000000003},{"$f":"SUM(N16+N28+N38)","v":-21.400000000000002},"XXX",{"$f":"SUM(P16+P28+P38)","v":8},"X",{"$f":"SUM(R16+R28+R38)","v":11},{"$f":"SUM(S16+S28+S38)","v":1},{"$f":"SUM(T16+T28+T38)","v":4},{"$f":"SUM(U16+U28+U38)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B37)","v":1.7964285714285715},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C37)","v":5.3500000000000005},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D37)","v":-1.2892857142857144},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E37)","v":-3.0928571428571421},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G37)","v":83.535714285714292},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H37)","v":4.4821428571428568},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M37)","v":1017.0821428571428},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N37)","v":-0.76428571428571446},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O37)","v":1.6428571428571428},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P37),1)","v":0.3},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V39)","v":4.4666666666666659}]
[]
[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":10},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":5}]
["TTT",0.9,"XXXX",{"$f":"SUM(B41-B45)","v":0.89642857142857146},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":3},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":3}]
["RRR",35,{"$f":"SUM(I40*100/B46)","v":21.714285714285715},"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":79.871794871794876},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":2},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":6}]
["mgl.",280,{"$f":"SUM(L40*100/B49)","v":22.25},"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":0}]
["sss",null,null,"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":23},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":11},">/= 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 auf 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:","Januar",null,null,null,"Jahr:",2015]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","-","-","-","-",1,"-","-",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.","-",{"$f":"IF(R10=1,1,\"-\")","v":"-"},"-","-",1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-","-",1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-",1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-",1,"-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-",1,1,"-","-"]
["Su.",{"$f":"SUM(B9:B36)","v":"00:00:00"},0,8,18,24,1,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":1}]

{"sheet":"Monatsdiagramm","index":3,"n_rows":67,"n_cols":9,"rows_kept":67,"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,"(211 m ü. NHN)"]
[]
["Februar 2015"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":9.9},"am","2015-02-16"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B30","v":1.7964285714285715},{"$f":"Kurztabelle!B45","v":0.9},{"$f":"C7-D7","v":0.89642857142857146},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":-4.9000000000000004},"am","2015-02-20"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I40","v":7.6},{"$f":"Kurztabelle!B46","v":35},{"$f":"100/D9*C9","v":21.714285714285715},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L40","v":62.3},{"$f":"Kurztabelle!B47","v":78},{"$f":"100/D10*C10","v":79.871794871794876},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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 80 %; Mai - August 90 %."]
["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"]
["2015-02-01",1.3,4.9000000000000004,-1.6,null,null,1.4,990.2,0.6]
["2015-02-02",1.3,4.0999999999999996,-0.2,0.3,0,2.2000000000000002,996.6,0.6,null,null,"Gegen 23:00 Uhr leichter Schneefall (WW 71)."]
["2015-02-03",1.1000000000000001,3.6,-0.3,0.8,1,2,1001.6,0.6,"NWz","wt. Mischka","Gegen 08:30 Uhr; 11:45 Uhr leichter Schneeschauer (WW 85). Gegen 04:00 Uhr; 19:30 Uhr; Von 22:00 Uhr - 23:59 Uhr leichter Schneefall (WW 71)."]
["2015-02-04",-1.6,-0.1,-3.4,0.4,2,null,1012,0.65,null,null,"Von 00:00 Uhr - 01:59 Uhr; 07:50 Uhr - 17:39 Uhr; Gegen 23:00 Uhr leichter Schneefall (WW 71)."]
["2015-02-05",-1.8,0.3,-3.4,null,1,1.6,1022,0.65,"NEz",null,"Zwischen 00:00 Uhr und 06:00 Uhr; Gegen 09:30 Uhr leichter Schneefall (WW 71)."]
["2015-02-06",-1.9,-0.9,-3.1,null,1,0.1,1028,0.65,null,"H Gabriela"]
["2015-02-07",-1.4,2.8,-4.9000000000000004,1,1,3.7,1026.8,0.7,"U","T Othmar","Von 19:30 Uhr - 22:29 Uhr leichter Regen und Sprühregen (WW 58)."]
["2015-02-08",0.8,3,-0.8,0.3,2,1.3,1019.2,0.7,"HB","H Gabriela","Von 05:00 Uhr - 05:49 Uhr leichter Schneefall mit Gewitter (WW 93). Von 01:50 Uhr - 02:29 Uhr leichter Schneeregen (WW  68). Von 02:30 Uhr - 03:09 Uhr leichter Schneefall (WW 71)."]
["2015-02-09",2.8,4.4000000000000004,-0.8,1.8,0,null,1021,0.75,null,null,"Von 17:10 Uhr - 23:59 Uhr leichter Regen (WW 61). Vor 07:00 Uhr Regen/Schneefall nicht näher definierbar. Von 07:00 Uhr - 17:09 Uhr leichter Sprühregen (WW 51)."]
["2015-02-10",4.2,4.7,3.6,0.1,null,null,1027,0.75,"HM",null,"Von 00:00 Uhr - 07:49 Uhr; 10:10 Uhr - 12:09 Uhr leichter Regen (WW 61)."]
["2015-02-11",3.1,4.5999999999999996,-1.7,null,null,null,1027.8,0.8]
["2015-02-12",-0.3,3.9,-2.8,null,null,3.8,1022.6,0.8]
["2015-02-13",1.2,4.4000000000000004,-0.7,null,null,4.2,1020.5,0.85,"SEa"]
["2015-02-14",0.4,3.2,-1.2,null,null,4,1014.9,0.85]
["2015-02-15",3.4,7.1,-1.1000000000000001,null,null,0.3,1016.5,0.9,null,"H Hanne"]
["2015-02-16",3.2,9.9,-0.1,null,null,4.3,1022.3,0.9]
["2015-02-17",2.2999999999999998,6.1,-0.2,null,null,4.3,1030.5999999999999,0.95,"BM","H Isa"]
["2015-02-18",2.6,4.7,-1.6,null,null,null,1039.3,0.95]
["2015-02-19",0.8,6.7,-2.9,null,null,4.0999999999999996,1030,1]
["2015-02-20",2.7,8.9,-4.5,null,null,4,1017,1,"SWz","T Thomas"]
["2015-02-21",4.5999999999999996,9.6,0.5,null,null,2.2000000000000002,1001.5,1.05]
["2015-02-22",2.9,5.3,-1.2,null,null,0.3,1008.6,1.1000000000000001,"Wz"]
["2015-02-23",3,7.7,-1.2,2.2000000000000002,null,1.4,1002.7,1.1499999999999999,null,"T Uli","Von 15:40 Uhr - 16:59 Uhr mäßiger Regen (WW 63). Von 14:50 Uhr - 15:39 Uhr; 17:00 Uhr - 17:09 Uhr leichter Regen (WW 61)."]
["2015-02-24",4.5,9.1999999999999993,0.9,null,null,3.4,1007,1.2]
["2015-02-25",3.3,7.4,0.7,null,null,1.6,1018.2,1.25,"U","T Winfried"]
["2015-02-26",2,9.1,-2.8,null,null,5.2,1021.3,1.3,"Ww"]
["2015-02-27",2.7,9.1,-2.4,0.4,null,5.7,1013.9,1.35]
["2015-02-28",3.1,6.1,1.1000000000000001,0.3,null,1.3,null,1.4,"Wz",null,"Zwischen 03:00 Uhr und 05:59 Uhr; 07:20 Uhr - 08:29 Uhr leichter Regen (WW 61). Von 08:30 Uhr - 09:49 Uhr mäßiger Sprühregen (WW 53). Von 09:50 Uhr - 10:19 Uhr leichter Sprühregen (WW 51)."]
["Durchschnitt",{"$f":"AVERAGE(B2:B29)","v":1.7964285714285715},{"$f":"AVERAGE(C2:C29)","v":5.3500000000000005},{"$f":"AVERAGE(D2:D29)","v":-1.2892857142857144},"-",null,{"$f":"AVERAGE(G2:G29)","v":2.7130434782608699},{"$f":"AVERAGE(H2:H29)","v":1017.0037037037036},{"$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":"Erdbodentem.","index":6,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,1,34,2],[31,3,31,4],[32,3,32,4],[35,5,35,6],[35,1,35,2],[35,3,35,4],[34,3,34,4],[31,1,31,2],[32,1,32,2],[33,1,33,2],[30,5,30,6],[31,5,31,6],[34,5,34,6],[33,3,33,4],[32,5,32,6],[33,5,33,6],[25,1,25,2],[30,1,30,2],[26,1,26,2],[27,1,27,2],[28,5,28,6],[29,5,29,6],[26,5,26,6],[27,5,27,6],[30,3,30,4],[28,1,28,2],[29,1,29,2],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[27,3,27,4],[17,5,17,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,1,23,2],[24,1,24,2],[18,1,18,2],[17,3,17,4],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[19,3,19,4],[20,3,20,4],[17,1,17,2],[23,3,23,4],[24,3,24,4],[18,3,18,4],[21,3,21,4],[22,3,22,4],[6,0,7,0],[13,5,13,6],[8,1,8,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[13,3,13,4],[12,5,12,6],[16,1,16,2],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[16,3,16,4],[14,3,14,4],[15,3,15,4],[14,1,14,2],[15,1,15,2],[14,5,14,6],[15,5,15,6],[16,5,16,6],[4,6,4,7],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,7,7,7],[6,5,7,6]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Februar",null,null,null,"Jahr:",2015]
[]
["Dat.","6 Uhr","7 Uhr","11 Uh","12 Uhr","19 Uhr",null,"NN","0 °C - "]
[null,null,null,null,null,null,null,null,"Eindringtiefe"]
["01.","-",null,"-",null,"-",null,"n","> 0 °C"]
["02.","-",null,"-",null,"-",null,"n","> 0 °C"]
["03.","-",null,"-",null,"-",null,"t","< 0 cm"]
["04.","0,5 °C/> 0 °C/> 0 °C",null,"-",null,"-",null,"t","8 cm"]
["05.","0,6 °C/> 0 °C/> 0 °C",null,"-",null,"-",null,"t","7 cm"]
["06.","-",null,"-",null,"-",null,"t","-"]
["07.","-",null,"-",null,"-",null,"t","-"]
["08.","-",null,"-",null,"-",null,"n","-"]
["09.","0,7 °C/> 0 °C/> 0 °C",null,"-",null,"-",null,"t","> 0 °C"]
["10.","-",null,"-",null,"-",null,"t","> 0 °C"]
["11.","-",null,"-",null,"-",null,"t","> 0 °C"]
["12.","1,1 °C/> 0 °C/> 0 °C",null,"-",null,"-",null,"h","2 cm"]
["13.","1,7 °C/> 0 °C/> 0 °C",null,"-",null,"-",null,"h","4 cm"]
["14.","1,1 °C/> 0 °C/> 0 °C",null,"-",null,"-",null,"h","3 cm"]
["15.","-",null,"-",null,"-",null,"h","> 0 °C"]
["16.","-",null,"-",null,"-",null,"h","> 0 °C"]
["17.","-",null,"-",null,"-",null,"n","> 0 °C"]
["18.","1,5 °C/1,5 °C/3,8 °C",null,"-",null,"-",null,"n","> 0 °C"]
["19.","1,1 °C/1,5 °C/3,8 °C",null,"-",null,"-",null,"h","2 cm"]
["20.","0,5 °C/0,9 °C/4,3 °C",null,"-",null,"-",null,"h","9 cm"]
["21.","-",null,"-",null,"-",null,"n","> 0 °C"]
["22.","-",null,"-",null,"-",null,"t","> 0 °C"]
["23.","-",null,"-",null,"-",null,"t","> 0 °C"]
["24.","-",null,"-",null,"-",null,"t","> 0 °C"]
["25.",null,null,"-",null,"-",null,"n","> 0 °C"]
["26.","1,2 °C/1,2 °C/> 0 °C",null,"-",null,"-",null,"h","8 cm"]
["27.","1,0 °C/1,6 °C/4,6 °C",null,"-",null,"-",null,"h","8 cm"]
["28.","-",null,"-",null,"-",null,"n","> 0 °C"]
[]
[null,"Temperatur - 10 cm/Temperatur - 20 cm/Temperatur -50 cm"]