{"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",2,71,1017.5,4.3,5,null,"00",1,82,1020.2,6.5,2]
["01",0,78,1017.9,4.3,1,null,"01",2,81,1019.7,6.2,1]
["02",2,80,1017.9,4.3,1,null,"02",1,85,1019.5,5.8,1]
["03",1,82,1017.9,3.6,4,null,"03",0,88,1019.3,5.7,2]
["04",1,87,1018.2,3.1,4,null,"04",0,87,1019.1,6,4]
["05",0,84,1017.9,3.5,2,null,"05",0,85,1019,6.3,4]
["06",0,83,1018.1,5.6,2,null,"06",0,91,1019,7.6,4]
["07",1,79,1018,7.2,5,null,"07",1,89,1019.4,8.9,4]
["08",1,77,1017.7,9.4,6,null,"08",2,62,1019.2,5.8,5]
["09",3,51,1017.1,6.7,6,null,"09",2,51,1018.7,4.0999999999999996,6]
["10",3,55,1016.9,7.8,6,null,"10",2,50,1018.1,5.3,8]
["11",3,53,1016.5,9,7,null,"11",2,53,1017.3,6.6,7]
["12",2,51,1016.4,8.1,7,null,"12",2,61,1016.4,9.5,7]
["13",2,53,1015.9,9.8000000000000007,7,null,"13",2,55,1015.7,9.6999999999999993,5]
["14",3,48,1015.3,8.6,7,null,"14",1,55,1015.2,10,5]
[15,2,46,1014.8,8.4,5,null,"15",1,51,1014.6,9.1999999999999993,3]
["16",2,42,1014.1,8.8000000000000007,3,null,"16",2,51,1013.9,9.1999999999999993,4]
["17",3,45,1013.6,9.1999999999999993,3,null,"17",1,58,1013.3,10.7,6]
["18",2,47,1013.4,9,5,null,"18",2,49,1013.1,7.8,7]
["19",2,51,1013.5,9.1,6,null,"19",1,56,1013.1,8.8000000000000007,7]
["20",1,65,1013.6,10.1,6,null,"20",1,57,1013,8.1,7]
["21",2,68,1013.8,9.1999999999999993,5,null,"21",2,59,1013.3,8,7]
["22",2,67,1013.7,9.6999999999999993,6,null,"22",2,58,1013.1,7.6,8]
["23",2,68,1013.5,10.3,7,null,"23",2,68,1014,9.3000000000000007,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.8},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":63.8},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1016},{"$f":"AVERAGE(E3:E26)","v":7.4624999999999986},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":4.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1.3},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":65.900000000000006},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1016.6},{"$f":"AVERAGE(L3:L26)","v":7.6125000000000007},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":5.0999999999999996}]
[]
[null,null,null,null,"2015-05-31",null,null,null,null,null,null,"2015-05-28"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,84,1014.5,10.7,8,null,"00",2,72,1008.3,10,8]
["01",1,90,1014.3,10.7,8,null,"01",2,68,1008.4,9.1999999999999993,8]
["02",1,90,1014.2,10,7,null,"02",2,71,1008.3,9.3000000000000007,6]
["03",1,93,1013.9,10.199999999999999,8,null,"03",1,78,1008,8.8000000000000007,6]
["04",1,92,1013.7,9.6999999999999993,8,null,"04",1,78,1008.6,9.1999999999999993,8]
["05",2,91,1014.2,9.8000000000000007,5,null,"05",1,72,1009.1,8.8000000000000007,7]
["06",1,90,1014.5,10.6,4,null,"06",2,69,1009.6,8.6999999999999993,8]
["07",1,83,1014.5,10.5,4,null,"07",3,83,1011.3,7.2,8]
["08",1,81,1014.3,11.6,6,null,"08",2,91,1011.4,7.9,7]
["09",1,79,1013.8,13.1,6,null,"09",1,89,1011.8,9.8000000000000007,7]
["10",1,72,1013.4,13.1,6,null,"10",2,75,1011.9,9,6]
["11",1,65,1012.7,11.6,5,null,"11",2,66,1012,8.5,5]
["12",1,61,1012.1,10.6,4,null,"12",3,52,1011.9,7.1,6]
["13",1,65,1011.3,12.5,6,null,"13",2,51,1012,6.9,6]
["14",1,61,1009.7,12.6,7,null,"14",2,50,1012.2,6.4,5]
["15",1,58,1009.1,10.6,7,null,"15",2,47,1012.2,6.2,5]
["16",1,56,1008.9,10.199999999999999,8,null,"16",2,49,1012.2,6.3,6]
["17",2,60,1009.2,10.6,8,null,"17",3,56,1013.2,7.1,7]
["18",2,64,1008.3,11.5,7,null,"18",3,58,1014.4,6.6,6]
["19",2,54,1008.1,9.6,6,null,"19",2,63,1015.5,6.3,7]
["20",2,66,1008,9.9,4,null,"20",2,77,1017,6,6]
["21",1,74,1008.3,11.2,7,null,"21",2,74,1017.1,5,6]
["22",2,71,1007.9,10.7,7,null,"22",2,76,1017.4,4.7,4]
["23",1,69,1008.1,9.9,7,null,"23",2,71,1017.5,4.3,6]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.3},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":73.7},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1011.5},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":10.9},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":6.4},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":2},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":68.2},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1012.1},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":7.5},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":6.4}]
[]
[null,null,null,null,"2015-05-29",null,null,null,null,null,null,"2015-05-30"]

{"sheet":"Kurztabelle","index":1,"n_rows":113,"n_cols":35,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,12,1,13]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","Mai",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.",9.6,14.8,6.7,6.1,49,77,6,".",null,null,3.3,1007.9,5.6,1,null,null,null,null,null,null,3,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.",9.1999999999999993,15.1,2.7,1.7,44,69,3.1,".",null,null,9.5,1011.4,3.5,1,null,null,null,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":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":5},{"$f":"COUNTIF(I6:I15,\">=1\")","v":4},{"$f":"COUNTIF(I6:I15,\">=3\")","v":3},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",12.5,20.3,3.3,2.2000000000000002,51,77,5.3,4.8,"R",null,8.1999999999999993,1009.6,8.1,2,null,null,1,null,null,null,4,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":5},{"$f":"COUNTIF(I18:I27,\">=1\")","v":2},{"$f":"COUNTIF(I18:I27,\">=3\")","v":1},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",16.899999999999999,22.9,11.7,10,55,79,6,0.3,"R",null,8.1999999999999993,1008.9,13,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":0},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":3},{"$f":"COUNTIF(I30:I40,\">=1\")","v":1},{"$f":"COUNTIF(I30:I40,\">=3\")","v":1},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",18.2,22.8,11.5,9.4,72,84,7.5,3.2,"R",null,1.7,1006.1,15.3,2,null,null,1,1,null,null,5]
["06.",15.9,20.9,12.4,10,40,71,5.4,".",null,null,1.3,1012.4,10.4,1,null,null,null,null,null,null,4,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.",13.1,18.3,7.6,4.4000000000000004,44,64,2.6,".",null,null,7.4,1017.2,6.2,2,null,null,null,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":0},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":1},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":2}]
["08.",13.8,21.1,6,5,38,69,5.6,2.6,"R",null,8.1,1017.2,7.6,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":0},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":0},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":3}]
["09.",15.1,20.9,10.6,10,51,77,7,4.8,"R",null,4.2,1016.2,10.7,2,null,null,1,1,null,null,6,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":0},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":0},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",13.1,17.600000000000001,6.3,5,46,72,4.5,".",null,null,6.8,1023.5,7.8,2,null,null,null,null,null,null,6]
["Su",{"$f":"SUM(B6:B15)","v":137.39999999999998},{"$f":"SUM(C6:C15)","v":194.7},78.8,63.8,"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":15.7},"XX",null,{"$f":"SUM(L6:L15)","v":58.699999999999996},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":5},{"$f":"SUM(S6:S15)","v":2},1,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":13.739999999999998},{"$f":"AVERAGE(C6:C15)","v":19.47},7.88,6.38,"XXX",73.900000000000006,5.3,"XXX","XX",null,{"$f":"L16/10","v":5.8699999999999992},{"$f":"AVERAGE(M6:M15)","v":1013.04},{"$f":"AVERAGE(N6:N15)","v":8.82},1.5,{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4.5999999999999996},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",13.4,21.4,3.8,2.8,38,69,5,".",null,null,11.5,1026.3,7,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":1},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$f":"COUNTIF(L18:L27,\">=10\")","v":4},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",17.7,23.9,8.4,6.1,48,63,6.4,4.5,"R",null,3.3,1017.8,10.3,2,null,null,1,1,null,null,6,2,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":0},{"$f":"COUNTIF(L30:L40,\"<1\")","v":1},{"$f":"COUNTIF(L30:L40,\">=10\")","v":1},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":0},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",14,19.600000000000001,9,8.3000000000000007,41,70,3.3,1.7,"R",null,10.199999999999999,1016.7,8.1999999999999993,1,null,null,1,null,null,null,4]
["14.",10.199999999999999,14.7,5.0999999999999996,3.9,52,78,5.0999999999999996,".",null,null,4,1011.9,6.3,1,null,null,null,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",11.4,18.899999999999999,2,1.7,34,69,2.2999999999999998,".",null,null,12.8,1014.9,5.0999999999999996,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":18.2},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":23.9},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":1.5},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":7.1}]
["16.",13.2,20.3,4.7,3.3,37,69,5.2,0.2,"R",null,8.9,1019.9,6.9,2,null,null,1,null,null,null,5,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",11.7,15.7,9.3000000000000007,8.9,43,64,6.1,".",null,null,4.3,1022.3,5,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":9.1999999999999993},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":2},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":34},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",15.2,21.8,5.9,3.9,41,63,4.9000000000000004,".",null,null,10.199999999999999,1012.4,7.7,2,null,null,null,null,null,null,5]
["19.",16.7,21.1,11.8,9.4,50,61,6.3,0.4,"R",null,3.5,1006.1,9,2,null,null,1,null,null,null,5]
["20.",12.7,15.8,8.9,8.3000000000000007,49,70,7.7,0.2,"R",null,".",1012.5,7,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B18:B27)","v":136.20000000000002},{"$f":"SUM(C18:C27)","v":193.20000000000002},68.900000000000006,56.599999999999994,"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":7.0000000000000009},"XX",null,{"$f":"SUM(L18:L27)","v":68.699999999999989},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":1},0,0,"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":13.620000000000001},{"$f":"AVERAGE(C18:C27)","v":19.32},6.8900000000000006,5.6599999999999993,43.3,67.599999999999994,5.2299999999999995,"XXX","XX",null,{"$f":"L28/10","v":6.8699999999999992},{"$f":"AVERAGE(M18:M27)","v":1016.0799999999999},{"$f":"AVERAGE(N18:N27)","v":7.25},1.5,{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4.4000000000000004}]
["21.",12.2,16.899999999999999,8.4,7.2,49,72,5.6,0,null,null,1.4,1021.8,7,1,null,null,null,null,null,null,4]
["22.",12.8,18.7,5.3,3.9,41,65,3.4,".",null,null,11.7,1024.7,6,1,null,null,null,null,null,null,3]
["23.",14.4,20.6,5.9,4.4000000000000004,47,68,5.3,".",null,null,7.4,1018.5,8,2,null,null,null,null,null,null,4]
["24.",14.4,18.899999999999999,10.3,8.9,56,78,5.8,".",null,null,4.2,1018.2,10.6,1,null,null,null,null,null,null,3]
["25.",15.2,20.5,8.6999999999999993,7.8,58,77,5.9,7.1,"R",null,4.7,1012.8,10.9,1,null,null,null,null,null,null,4]
["26.",12.3,15.9,10.1,10,57,78,7.2,".",null,null,1.8,1014.9,8.5,2,null,null,null,null,null,null,5]
["27.",10.5,12.7,8.4,"-",64,76,7.4,0,null,null,0.6,1020.5,6.3,2,null,null,null,null,null,null,5]
["28.",14.4,20.5,7.4,"-",41,66,5.0999999999999996,".",null,null,4.8,1016.6,7.6,1,null,null,null,null,null,null,4]
["29.",15.8,20.5,10.7,"-",53,74,6.7,0.5,"R",null,5.2,1011.5,10.9,1,null,null,1,null,null,null,4]
["30.",13.6,18.899999999999999,9.4,9.1999999999999993,43,68,6.4,0.8,"R",null,2.8,1012.1,7.5,2,null,null,1,null,null,null,5]
["31.",14.9,22.4,5.0999999999999996,1.5,42,64,4.8,".",null,null,9.4,1016,7.5,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B30:B40)","v":150.5},{"$f":"SUM(C30:C40)","v":206.5},{"$f":"SUM(D30:D40)","v":89.7},{"$f":"SUM(E30:E40)","v":52.899999999999991},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":8.4},"XX",null,{"$f":"SUM(L30:L40)","v":54},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":2},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":0},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":13.681818181818182},{"$f":"AVERAGE(C30:C40)","v":18.772727272727273},{"$f":"AVERAGE(D30:D40)","v":8.1545454545454543},{"$f":"AVERAGE(E30:E40)","v":6.6124999999999989},"XXX",{"$f":"AVERAGE(G30:G40)","v":71.454545454545453},{"$f":"AVERAGE(H30:H40)","v":5.7818181818181822},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1017.0545454545455},{"$f":"AVERAGE(N30:N40)","v":8.254545454545454},{"$f":"AVERAGE(O30:O40)","v":1.4545454545454546},{"$f":"ROUND(AVERAGE(P30:P40),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4.1818181818181817}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":424.1},{"$f":"SUM(C16+C28+C41)","v":594.4},{"$f":"SUM(D16+D28+D41)","v":237.39999999999998},{"$f":"SUM(E16+E28+E41)","v":173.29999999999998},"XXX","XXX,",{"$f":"SUM(H16+H28+H41)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I16+I28+I41)","v":31.1},"XX",null,{"$f":"SUM(L16+L28+L41)","v":181.39999999999998},"XXX","XXX","XXX",{"$f":"SUM(P16+P28+P41)","v":{"$error":"#VALUE!"}},"X",{"$f":"SUM(R16+R28+R41)","v":12},{"$f":"SUM(S16+S28+S41)","v":3},{"$f":"SUM(T16+T28+T41)","v":1},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":13.680645161290318},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":19.174193548387095},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":7.6580645161290333},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":6.1892857142857149},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":71},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":5.4483870967741925},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1015.4451612903224},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":8.112903225806452},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.4838709677419355},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P40),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":4.3939393939393936}]
[]
[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":13},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":1}]
["TTT",13.9,"XXXX",{"$f":"SUM(B44-B48)","v":-0.2193548387096822},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":7},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":1}]
["RRR",65,{"$f":"SUM(I43*100/B49)","v":47.846153846153847},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":5}]
["sss",217,{"$f":"SUM(L43*100/B50)","v":83.594470046082932},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},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":0}]
["mgl.",480,{"$f":"SUM(L43*100/B52)","v":37.791666666666657},"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":0},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":1},">/= 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":5}]
[]
[]
[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":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Mai",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,1," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-",1,1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-","-","-",1,"-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-","-","-",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,1,"-",null,null,null,null,null," "," "," "," ",0]
["14.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-","-",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,"-","-",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,1,"-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,"-","-"]
["30.","-","-","-","-",1,1,"-"]
["31.","-","-","-","-",1,1,"-"]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,0,3,30,16,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":16}]

{"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)"]
[]
["Mai 2015"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":23.9},"am","2015-05-12"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":13.680645161290318},{"$f":"Kurztabelle!B48","v":13.9},{"$f":"C7-D7","v":-0.2193548387096822},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":2},"am","2015-05-15"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":31.1},{"$f":"Kurztabelle!B49","v":65},{"$f":"100/D9*C9","v":47.846153846153854},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":181.39999999999998},{"$f":"Kurztabelle!B50","v":217},{"$f":"100/D10*C10","v":83.594470046082932},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":120,"n_cols":12,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2015-05-01",9.6,14.8,6.7,null,null,3.3,1007.9,11.3,null,null," Von 00:00 Uhr - 02:09 Uhr; 05:30 Uhr - 05:59 Uhr; 06:20 Uhr - 07:19 Uhr mäßiger Regen (WW 63). Von 07:20 Uhr - 07:23 Uhr leichter Regen (WW 61)."]
["2015-05-02",9.1999999999999993,15.1,2.7,null,null,9.5,1011.4,11.5]
["2015-05-03",12.5,20.3,3.3,4.8,null,8.1999999999999993,1009.6,11.7,"SWz","T Ivo","Von 20:10 Uhr - 22:29 Uhr mäßiger Regen (WW 63). Von 17:45 Uhr - 17:54 Uhr; 19:05 Uhr - 19:10 Uhr; 19:49 Uhr - 20:09 Uhr; 22:30 Uhr - 22:39 Uhr leichter Regen (WW 61)."]
["2015-05-04",16.899999999999999,22.9,11.7,0.3,null,8.1999999999999993,1008.9,11.9,null,null,"Leicht schwül."]
["2015-05-05",18.2,22.8,11.5,3.2,null,1.7,1006.1,12.1,null,"T Zoran","Von 16:20 Uhr - 16:49 Uhr leichtes Gewitter mit Regen (WW 95). Vor 06:00 Uhr ; Gegen 19:00 Uhr; 20:00 Uhr; 21:00 Uhr; vor 23:59 Uhr leichter Regen (WW 61). Von 15:50 Uhr - 16:19 Uhr Ferngewitter (WW 17)."]
["2015-05-06",15.9,20.9,12.4,null,null,1.3,1012.4,12.3,"Wz",null,"Vor 05:00 Uhr leichter Regen (WW 61)."]
["2015-05-07",13.1,18.3,7.6,null,null,7.4,1017.2,12.5,null,"H Suse"]
["2015-05-08",13.8,21.1,6,2.6,null,8.1,1017.2,12.65,null,"T Andreas","Von 05:00 Uhr - 06:09 Uhr mäßiger Regen (WW 63) Von 04:30 Uhr - 04:59 Uhr; 06:10 Uhr - 06:19 Uhr leichter Regen (WW 61)."]
["2015-05-09",15.1,20.9,10.6,4.8,null,4.2,1016.2,12.85,null,null,"Von 21:30 Uhr - 21:59 Uhr leichtes Gewitter mit Regen (WW 95). Von 22:00 Uhr - 22:09 Uhr; 22:50 Uhr - 23:09 Uhr starker Regenschauer (WW 81). Von 17:00 Uhr - 17:29 Uhr; 23:10 Uhr - 23:39 Uhr mäßiger Regenschauer (WW 81). Von 16:50 Uhr - 16:59 Uhr; Gegen 19:00 Uhr leichter Regenschauer (WW 80)."]
["2015-05-10",13.1,17.600000000000001,6.3,null,null,6.8,1023.5,13,"Wa","H Tina","Gegen 01:20 Uhr leichter Regenschauer (WW 80)."]
["2015-05-11",13.4,21.4,3.8,null,null,11.5,1026.3,13.2,"SWa"]
["2015-05-12",17.7,23.9,8.4,4.5,null,3.3,1017.8,13.35,"SWz","T Benedikt","Gegen 21:00 Uhr; 22:30 Uhr leichtes Gewitter mit Regen (WW 95). Von 21:30 Uhr - 22:09 Uhr mäßiger Regenschauer (WW 81). Von 21:10 Uhr - 21:29 Uhr leichter Regenschauer (WW 80). Von 21:10 Uhr - 22:29 Uhr Gewitter in der Ferne (WW 17)."]
["2015-05-13",14,19.600000000000001,9,1.7,null,10.199999999999999,1016.7,13.5,"Wz"]
["2015-05-14",10.199999999999999,14.7,5.0999999999999996,null,null,4,1011.9,13.65,"NWa","H Ulrike","Von 05:20 Uhr - 05:59 Uhr starker Regen (WW 65)."]
["2015-05-15",11.4,18.899999999999999,2,null,null,12.8,1014.9,13.8,"Wa",null,"Von 17:00 Uhr - 20:29 Uhr leichter Regen, unterbrochen (WW 60)."]
["2015-05-16",13.2,20.3,4.7,0.2,null,8.9,1019.9,13.95]
["2015-05-17",11.7,15.7,9.3000000000000007,null,null,4.3,1022.3,14.1]
["2015-05-18",15.2,21.8,5.9,null,null,10.199999999999999,1012.4,14.25,"Wz","T Diethelm"]
["2015-05-19",16.7,21.1,11.8,0.4,null,3.5,1006.1,14.4,"TrW",null,"Gegen 12:00 Uhr; 14:00 Uhr; 14:45 Uhr leichter Regenschauer (WW 80)."]
["2015-05-20",12.7,15.8,8.9,0.2,null,null,1012.5,14.55,null,null,"Von 11:30 Uhr - 14:59 Uhr; Gegen 17:00 Uhr leichter Regen, unterbrochen (WW 60)."]
["2015-05-21",12.2,16.899999999999999,8.4,null,null,1.4,1021.8,14.65,null,null,"Gegen 15:00 Uhr leichter Regen (WW 61)."]
["2015-05-22",12.8,18.7,5.3,null,null,11.7,1024.7,14.8,"NWa","H Viola"]
["2015-05-23",14.4,20.5,5.9,null,null,7.4,1018.5,14.9]
["2015-05-24",14.4,18.899999999999999,10.3,null,null,4.2,1018.2,15.05]
["2015-05-25",15.2,20.5,8.6999999999999993,7.1,null,4.7,1012.8,15.15,"TrM","T Gunnar"]
["2015-05-26",12.3,15.9,10.1,null,null,1.8,1014.9,15.25,null,null,"Von 00:40 Uhr - 05:29 Uhr mäßiger Regen (WW 63). Von 05:30 Uhr -  07:29 Uhr leichter Regen (WW 61)."]
["2015-05-27",10.5,12.7,8.4,null,null,0.6,1020.5,15.35,null,null,"Gegen 19:00 Uhr leichter Regen (WW 61)."]
["2015-05-28",14.4,20.5,7.4,null,null,4.8,1016.6,15.45,"Wz","T Hubertus"]
["2015-05-29",15.8,20.5,10.7,0.5,null,5.2,1011.5,15.55,null,null,"Gegen 15:00 Uhr leichter Regen (WW 61)."]
["2015-05-30",13.6,18.899999999999999,9.4,0.8,null,2.8,1012.1,15.65,null,null,"Von 07:50 Uhr - 07:59 Uhr starker Regen (WW 65). Von 07:30 Uhr - 07:49 Uhr mäßiger Regen (WW 63). Von 06:40 Uhr - 07:29 Uhr leichter Regen (WW 61)."]
["2015-05-31",14.9,22.4,5.0999999999999996,null,null,9.4,1016,15.75]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":13.680645161290318},{"$f":"AVERAGE(C2:C32)","v":19.170967741935481},{"$f":"AVERAGE(D2:D32)","v":7.6580645161290333},"-",null,{"$f":"AVERAGE(G2:G32)","v":6.046666666666666},{"$f":"AVERAGE(H2:H32)","v":1015.4451612903224},{"$f":"AVERAGE(I2:I32)","v":13.809677419354838}]
["Mittel",13.9,null,null,65,"-",217,1015.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,5,37,6],[36,5,36,6],[36,3,36,4],[37,3,37,4],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[35,5,35,6],[35,3,35,4],[30,5,30,6],[31,5,31,6],[34,5,34,6],[33,3,33,4],[32,5,32,6],[33,5,33,6],[31,3,31,4],[32,3,32,4],[34,3,34,4],[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],[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],[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]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Juni",null,null,null,"Jahr:",2015]
[]
["Dat.","7 Uhr","8Uhr","12 Uh","13 Uhr","19 Uhr",null,"NN","10 °C - "]
[null,null,null,null,null,null,null,null,"Eindringtiefe"]
["01.","-",null,"-",null,"-",null,"-","-"]
["02.","-",null,"-",null,"-",null,"-","-"]
["03.","-",null,"-",null,"-",null,"-","-"]
["04.","-",null,"-",null,"-",null,"-","-"]
["05.","-",null,"-",null,"-",null,"-","-"]
["06.","-",null,"-",null,"-",null,"-","-"]
["07.","-",null,"-",null,"-",null,"-","-"]
["08.","-",null,"-",null,"-",null,"-","-"]
["09.","-",null,"-",null,"-",null,"-","-"]
["10.","-",null,"-",null,"-",null,"-","-"]
["11.","-",null,"-",null,"-",null,"-","-"]
["12.","-",null,"-",null,"-",null,"-","-"]
["13.","-",null,"-",null,"-",null,"-","-"]
["14.","-",null,"-",null,"-",null,"-","-"]
["15.","-",null,"-",null,"-",null,"-","-"]
["16.","-",null,"-",null,"-",null,"-","-"]
["17.","-",null,"-",null,"-",null,"-","-"]
["18.","-",null,"-",null,"-",null,"-","-"]
["19.","-",null,"-",null,"-",null,"-","-"]
["20.","-",null,"-",null,"-",null,"-","-"]
["21.","-",null,"-",null,"-",null,"-","-"]
["22.","-",null,"-",null,"-",null,"-","-"]
["23.","-",null,"-",null,"-",null,"-","-"]
["24.","-",null,"-",null,"-",null,"-","-"]
["25.","-",null,"-",null,"-",null,"-","-"]
["26.","-",null,"-",null,"-",null,"-","-"]
["27.","-",null,"-",null,"-",null,"-","-"]
["28.","-",null,"-",null,"-",null,"-","-"]
["29.","-",null,"-",null,"-",null,"-","-"]
["30.","-",null,"-",null,"-",null,"-","-"]
[]
[null,"Temperatur - 10 cm/Temperatur - 20 cm/Temperatur -50 cm"]