{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"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,99,1016.2,12.8,6,null,"00",0,96,1010.4,15,7]
["01",1,99,1015.6,12.5,3,null,"01",1,91,1010,14.5,7]
["02",1,99,1015.9,12.7,7,null,"02",1,93,1009.5,14.1,7]
["03",2,99,1015.1,13.1,7,null,"03",1,93,1009.2,13.6,4]
["04",1,99,1015.1,13.2,7,null,"04",1,96,1008.9,13.4,6]
["05",0,100,1014.8,13.2,7,null,"05",1,97,1008.2,13.1,6]
["06",1,100,1014.9,13.6,6,null,"06",1,95,1008,15,6]
["07",0,100,1015,14.1,7,null,"07",1,91,1007.9,16.899999999999999,5]
["08",0,98,1015,14.7,7,null,"08",2,82,1007.5,17.600000000000001,5]
["09",0,94,1014.8,15.9,7,null,"09",2,77,1007.7,18.3,4]
["10",1,87,1014.5,16.5,7,null,"10",2,77,1007.9,17.8,3]
["11",1,82,1014.1,16.8,7,null,"11",2,78,1007.2,19,2]
["12",0,74,1013.8,16.5,7,null,"12",2,71,1006.6,19.2,2]
["13",1,69,1013.2,17.2,6,null,"13",2,67,1006.3,18.899999999999999,6]
["14",1,76,1012.9,18.2,7,null,"14",2,70,1006,20,7]
[15,0,76,1012.6,18.100000000000001,6,null,"15",1,66,1005.5,19,7]
["16",0,76,1012.4,18.600000000000001,7,null,"16",1,68,1004.5,19.2,7]
["17",0,71,1011.9,17,7,null,"17",2,66,1004.2,19,4]
["18",3,73,1012.2,16.2,7,null,"18",1,72,1004.4,19.100000000000001,5]
["19",0,83,1011.6,16.2,3,null,"19",2,80,1004.4,18.100000000000001,4]
["20",0,87,1011.7,15.7,4,null,"20",1,87,1004.2,17.8,4]
["21",1,88,1011.4,14.9,3,null,"21",1,91,1003.7,17.600000000000001,2]
["22",1,93,1011.2,15.1,6,null,"22",0,92,1004.4,17.399999999999999,3]
["23",1,92,1010.9,15.3,6,null,"23",0,95,1004.2,16.899999999999999,6]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.7},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":88.1},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1013.6},{"$f":"AVERAGE(E3:E26)","v":15.337499999999999},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":6.1},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1.3},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":83},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1006.7},{"$f":"AVERAGE(L3:L26)","v":17.104166666666668},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":5}]
[]
[null,null,null,null,"2016-05-28",null,null,null,null,null,null,"2016-05-29"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,97,1003.7,16.600000000000001,4,null,"00",1,89,1008.2,12.6,1]
["01",0,97,1003,16.600000000000001,3,null,"01",1,90,1008.1,12.3,1]
["02",1,97,1002.3,15.6,3,null,"02",1,91,1008.4,12.2,1]
["03",1,97,1002.2,15.2,3,null,"03",0,91,1008.5,12.2,2]
["04",0,98,1002,15.1,2,null,"04",1,90,1008.7,11.8,5]
["05",0,96,1002.1,16,4,null,"05",1,90,1009.1,12.2,5]
["06",2,86,1002.1,17.5,5,null,"06",0,85,1009.4,13.2,2]
["07",3,83,1002.7,16.7,4,null,"07",1,88,1009.8,15.1,4]
["08",3,83,1003.6,18.2,5,null,"08",1,78,1010,15.7,4]
["09",2,81,1004.1,17,7,null,"09",1,73,1010,15.9,5]
["10",2,81,1004.5,16.3,8,null,"10",1,70,1009.8,16.100000000000001,4]
["11",2,72,1004.9,16.3,7,null,"11",1,71,1009.9,17.600000000000001,6]
["12",2,69,1005,15.8,6,null,"12",2,68,1009.7,15.9,6]
["13",2,58,1005.2,15.5,3,null,"13",1,71,1009.1,17,6]
["14",2,60,1004.9,16.2,5,null,"14",1,85,1009.4,16.3,6]
["15",2,58,1004.7,16,3,null,"15",1,93,1009.5,16,8]
["16",1,60,1004.5,16.2,4,null,"16",1,93,1010,15.9,7]
["17",2,56,1004.9,14.8,4,null,"17",1,92,1009.9,16.2,8]
["18",2,64,1005.6,15,3,null,"18",1,94,1010.5,16.899999999999999,7]
["19",2,68,1006.1,14.5,5,null,"19",2,89,1009.8,15.7,8]
["20",2,78,1006.5,14,2,null,"20",0,91,1010.2,15.4,7]
["21",2,80,1006.9,13.7,1,null,"21",1,95,1010.6,14.5,7]
["22",0,85,1007.8,13.2,1,null,"22",1,96,1011,14.4,3]
["23",0,88,1007.5,13.2,0,null,"23",1,96,1010.9,14.3,4]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.5},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":78.8},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1004.5},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":15.6},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":3.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":86.2},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1009.6},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":14.8},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":4.9000000000000004}]
[]
[null,null,null,null,"2016-05-30",null,null,null,null,null,null,"2016-05-31"]

{"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,"2016"]
[]
["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.",10.8,17.3,3.9,"-",49,70,5.6,".",null,null,5.4,1020.7,5.3,1,null,null,null,null,null,null,5,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.",10.9,16.5,4.9000000000000004,"-",53,73,3.5,".",null,null,5.4,1022.7,5.9,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":1},{"$f":"COUNTIF(I6:I15,\">=1\")","v":1},{"$f":"COUNTIF(I6:I15,\">=3\")","v":1},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",11.6,19.399999999999999,3.9,0.9,44,72,4.3,0,"R",null,7.8,1018,6.3,2,null,null,null,null,1,null,7,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":3},{"$f":"COUNTIF(I18:I27,\">=3\")","v":2},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",7.8,9.3000000000000007,6.8,"-",76,90,7.8,6.4,"R",null,".",1026.5,6.3,2,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":3},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":3},{"$f":"COUNTIF(I30:I40,\">=1\")","v":3},{"$f":"COUNTIF(I30:I40,\">=3\")","v":2},{"$f":"COUNTIF(I30:I40,\">=10\")","v":1},{"$f":"COUNTIF(I30:I40,\">=20\")","v":1}]
["05.",11.4,18.7,4.5,2.4,56,81,3.3,".",null,null,7.3,1026.8,7.9,1,null,null,null,null,null,null,3]
["06.",15.4,23.2,6.7,3,37,67,1,".",null,null,12,1019.9,8.4,2,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.",16.7,24.3,8.1999999999999993,4,32,57,0.8,".",null,null,12.1,1016.4,7.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":3}]
["08.",15.9,23.3,8,4.0999999999999996,40,62,1.7,".",null,null,8,1017.7,8.4,2,null,null,null,null,1,null,6,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":1}]
["09.",16.399999999999999,23.9,8.1,4.5999999999999996,44,68,1,".",null,null,10.7,1018,10,1,null,null,null,null,null,null,5,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":2},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":1}]
["10.",16.7,23.6,8.1999999999999993,5.0999999999999996,42,66,1.2,".",null,null,11.4,1014.2,9.6999999999999993,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B6:B15)","v":133.6},{"$f":"SUM(C6:C15)","v":199.50000000000003},{"$f":"SUM(D6:D15)","v":63.2},{"$f":"SUM(E6:E15)","v":24.1},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":6.4},"XX",null,{"$f":"SUM(L6:L15)","v":80.100000000000009},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":1},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":3},{"$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":13.36},{"$f":"AVERAGE(C6:C15)","v":19.950000000000003},6.32,3.4428571428571431,"XXX",70.599999999999994,3.02,"XXX","XX",null,{"$f":"L16/10","v":8.0100000000000016},{"$f":"AVERAGE(M6:M15)","v":1020.0899999999999},{"$f":"AVERAGE(N6:N15)","v":7.5400000000000009},{"$f":"AVERAGE(O6:O15)","v":1.6},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":5},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":1},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":4},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",16.8,23.4,9.1999999999999993,5.6,42,67,2.2999999999999998,".",null,null,11.9,1009.6,10.1,2,null,null,null,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$f":"COUNTIF(L18:L27,\">=10\")","v":1},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",15.9,23.4,8.9,5.7,46,74,4.0999999999999996,1.8,"R",null,7,1002,10.9,1,null,null,1,1,null,null,5,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":1},{"$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.8,22.6,11.6,"-",55,88,5.5,6,"R",null,2.6,998.6,12.8,1,null,null,1,1,null,null,5]
["14.",10,13.8,7.2,3.6,57,76,4.8,".",null,null,2.2999999999999998,1005.8,5.9,2,null,null,null,null,null,null,5,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",6.9,12.1,4.5,2,56,80,5.0999999999999996,4.8,"R;G",null,2.7,1014.2,3.6,3,null,null,1,null,1,null,7,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":20.399999999999999},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":28.3},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":0.9},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":23.2}]
["16.",7.7,10.9,5.2,3.8,62,79,6.3,0.8,"G;R",null,3.2,1017.2,4.3,2,null,null,1,null,1,null,6,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",9.3000000000000007,12.4,6.2,3.5,63,75,7.6,0,"R",null,0.5,1016.4,5,2,null,null,null,null,1,null,6,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":6.9},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":3.9},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":32},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",13.3,17.8,8,5.6,46,68,6.8,".",null,null,1.9,1013,7.2,1,null,null,null,null,null,null,4]
["19.",14.9,20.8,7.1,4.7,35,65,6.6,".",null,null,5.2,1011,7.8,1,null,null,null,null,null,null,3]
["20.",16.3,21.9,10.1,7.4,43,67,4.9000000000000004,".",null,null,4.3,1017.3,9.6999999999999993,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B18:B27)","v":125.9},{"$f":"SUM(C18:C27)","v":179.10000000000002},{"$f":"SUM(D18:D27)","v":78},{"$f":"SUM(E18:E27)","v":41.9},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":13.4},"XX",null,{"$f":"SUM(L18:L27)","v":41.6},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":4},{"$f":"SUM(S18:S27)","v":2},{"$f":"SUM(T18:T27)","v":4},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":12.59},{"$f":"AVERAGE(C18:C27)","v":17.910000000000004},7.8,4.655555555555555,50.5,73.900000000000006,5.3999999999999995,"XXX","XX",null,{"$f":"L28/10","v":4.16},{"$f":"AVERAGE(M18:M27)","v":1010.5099999999999},{"$f":"AVERAGE(N18:N27)","v":7.7299999999999995},{"$f":"AVERAGE(O18:O27)","v":1.7},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":5.2}]
["21.",17,22.8,10.199999999999999,7.3,47,69,6.5,".",null,null,3.6,1018,10.9,1,null,null,null,null,null,null,4]
["22.",20.399999999999999,28.3,10.4,7.6,34,61,4.9000000000000004,".",null,null,10.9,1011.9,11.9,2,null,null,null,null,null,null,5]
["23.",18.2,23.1,13.7,"-",62,77,6.8,5.0999999999999996,"R",null,5.5,1007.5,14,2,null,null,1,1,null,null,5]
["24.",15.4,19.2,11.7,"-",76,90,7.7,0,null,null,0.9,1009.4,13.7,2,null,null,null,null,null,null,5]
["25.",13.4,15.9,11.4,11.6,79,90,8,0,null,null,".",1014.4,11.7,1,null,null,null,null,null,null,4]
["26.",15.7,21.1,12,10.1,59,81,5.5,".",null,null,1.8,1016.5,12.2,1,null,null,null,null,null,null,3]
["27.",15.6,23.2,10.6,10.4,66,88,6.1,23.2,"R",null,1.2,1016.5,13.4,1,null,null,1,1,null,null,3]
["28.",17.600000000000001,23.9,12.4,11.9,66,88,6.1,".",null,null,5,1013.6,15.3,1,null,null,1,1,null,null,4]
["29.",20.3,26.4,13.4,12,61,83,5,".",null,null,8.6,1006.7,17.100000000000001,1,null,null,null,1,null,null,4]
["30.",19.7,25,14.4,"-",53,79,3.8,".",null,null,8.4,1004.5,15.6,2,null,null,null,null,1,null,6]
["31.",17.2,24.1,13.1,11.9,63,86,4.9000000000000004,2.5,"R",null,3.2,1009.6,14.8,1,null,null,1,1,null,null,3]
["Su",{"$f":"SUM(B30:B40)","v":190.5},{"$f":"SUM(C30:C40)","v":253},{"$f":"SUM(D30:D40)","v":133.30000000000001},{"$f":"SUM(E30:E40)","v":82.800000000000011},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":30.799999999999997},"XX",null,{"$f":"SUM(L30:L40)","v":49.1},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":4},{"$f":"SUM(S30:S40)","v":5},{"$f":"SUM(T30:T40)","v":1},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":17.318181818181817},{"$f":"AVERAGE(C30:C40)","v":23},{"$f":"AVERAGE(D30:D40)","v":12.118181818181819},{"$f":"AVERAGE(E30:E40)","v":10.350000000000001},"XXX",{"$f":"AVERAGE(G30:G40)","v":81.090909090909093},{"$f":"AVERAGE(H30:H40)","v":5.9363636363636365},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1011.6909090909091},{"$f":"AVERAGE(N30:N40)","v":13.690909090909093},{"$f":"AVERAGE(O30:O40)","v":1.3636363636363635},{"$f":"AVERAGE(P30:P40)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4.1818181818181817}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":450},{"$f":"SUM(C16+C28+C41)","v":631.6},{"$f":"SUM(D16+D28+D41)","v":274.5},{"$f":"SUM(E16+E28+E41)","v":148.80000000000001},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":50.599999999999994},"XX",null,{"$f":"SUM(L16+L28+L41)","v":170.8},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":9},{"$f":"SUM(S16+S28+S41)","v":7},{"$f":"SUM(T16+T28+T41)","v":8},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":14.516129032258064},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":20.374193548387098},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":8.8548387096774199},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":6.2},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":75.387096774193552},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":4.82258064516129},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1014.0193548387098},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":9.7838709677419367},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.5483870967741935},{"$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.7939393939393939}]
[]
[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":8},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":2}]
["TTT",13.9,"XXXX",{"$f":"SUM(B44-B48)","v":0.6161290322580637},"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":2}]
["RRR",65,{"$f":"SUM(I43*100/B49)","v":77.846153846153825},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":3},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":6}]
["sss",217,{"$f":"SUM(L43*100/B50)","v":78.709677419354833},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":1},"Schneedecke cm"]
["astr.",null,null,"XXXX","Polartag",null,null,null,0,null,null,">/=  20,0",null,null,{"$f":"SUM(AI7:AI9)","v":1},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",480,{"$f":"SUM(L43*100/B52)","v":35.583333333333336},"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":3},">/= 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:",2016]
[]
["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,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-",{"$f":"IF(R12=1,1,\"-\")","v":"-"},"-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-",{"$f":"IF(R13=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-",{"$f":"IF(R22=1,1,\"-\")","v":"-"},"-","-",1,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,"-","-",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,1,"-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,"-","-"]
["30.","-","-","-","-",1,1,1]
["31.","-","-","-","-",1,1,1]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,6,10,29,11,2]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":11}]

{"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 2016"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":28.3},"am","2016-05-22"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":14.516129032258064},{"$f":"Kurztabelle!B48","v":13.9},{"$f":"C7-D7","v":0.6161290322580637},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":3.9},"am","1./3.5.16"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":50.599999999999994},{"$f":"Kurztabelle!B49","v":65},{"$f":"100/D9*C9","v":77.84615384615384},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":170.8},{"$f":"Kurztabelle!B50","v":217},{"$f":"100/D10*C10","v":78.709677419354847},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":16,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2016-05-01",10.8,17.3,3.9,null,null,5.4,1020.7,11.3,"BM","(H Oliver)"]
["2016-05-02",10.9,16.5,4.9000000000000004,null,null,5.4,1022.7,11.5]
["2016-05-03",11.6,19.399999999999999,3.9,null,null,7.8,1018,11.7]
["2016-05-04",7.8,9.3000000000000007,6.8,6.4,null,null,1026.5,11.9,"HM","H Peter","Von 08:10 Uhr - 14:59 Uhr mäßiger Regen (WW 63). Von 07:30 Uhr - 08:09 Uhr; 15:00 Uhr - 15:29 Uhr leichter Regen (WW 61). Gegen 07:00 Uhr Regentropfen (WW 60)."]
["2016-05-05",11.4,18.7,4.5,null,null,7.3,1026.8,12.1]
["2016-05-06",15.4,23.2,6.7,null,null,12,1019.9,12.3,"SEa"]
["2016-05-07",16.7,24.3,8.1999999999999993,null,null,12.1,1016.4,12.5,"HFa"]
["2016-05-08",15.9,23.3,8,null,null,8,1017.7,12.65]
["2016-05-09",16.399999999999999,23.9,8.1,null,null,10.7,1018,12.85]
["2016-05-10",16.7,23.6,8.1999999999999993,null,null,11.4,1014.2,13,"SEa"]
["2016-05-11",16.8,23.4,9.1999999999999993,null,null,11.9,1009.6,13.2]
["2016-05-12",15.9,23.4,8.9,1.8,null,7,1002,13.35,"U","T Yekaterina","Gegen 16:10 Uhr leichtes Gewitter mit Regen (WW 95). Von 18:50 Uhr - 19:39 Uhr mäßiger Regen (WW 63)."]
["2016-05-13",14.8,22.6,11.6,6,null,2.6,998.6,13.5,null,null,"Von 14:10 Uhr - 14:19 Uhr leichtes Gewitter mit Regen (WW 95). Von 14:50 Uhr - 14:59 Uhr starker Regenschauer (WW 81). Von 14:30 Uhr - 14:49 Uhr; 15:00 Uhr - 15:09 Uhr mäßiger Regenschauer (WW 81). Von 13:50 Uhr - 14:09 Uhr; 14:20 Uhr - 14:29 Uhr; 15:10 Uhr - 15:19 Uhr; 16:00 Uhr - 16:29 Uhr leichter Regenschauer (WW 80). Gegen 01:10 Uhr leichter Regen (WW 61)."]
["2016-05-14",10,13.8,7.2,null,null,2.2999999999999998,1005.8,13.65,"TrM","T Zooey"]
["2016-05-15",6.9,12.1,4.5,4.8,null,2.7,1014.2,13.8,null,null,"Von 17:53 Uhr - 18:09 Uhr mäßiger Graupelschauer (WW 88). Von 20:35 Uhr - 21:09 Uhr mäßiger Regenschauer (WW 81). Von 07:45 Uhr - 08:39 Uhr; 09:50 Uhr - 10:59 Uhr leichter Regen (WW 61). Von 11:00 Uhr - Gegen 13:00 Uhr leichter Regen, unterbrochen (WW 60)."]
["2016-05-16",7.7,10.9,5.2,0.8,null,3.2,1017.2,13.95,null,null,"Um 10:30 Uhr; Von 11:40 Uhr - 12:04 Uhr leichter Graupelschauer (WW 87). "]
["2016-05-17",9.3000000000000007,12.4,6.2,null,null,0.5,1016.4,14.1,"U","T Arlette","14:20 Uhr leichter Regen (WW 61)."]
["2016-05-18",13.3,17.8,8,null,null,1.9,1013,14.25,"Ww"]
["2016-05-19",14.9,20.8,7.1,null,null,5.2,1011,14.4]
["2016-05-20",16.3,21.9,10.1,null,null,4.3,1017.3,14.55,"SWa","H Reimar"]
["2016-05-21",17,22.8,10.199999999999999,null,null,3.6,1018,14.65]
["2016-05-22",20.399999999999999,28.3,10.4,null,null,10.9,1011.9,14.8,"SWz","T Barbara"]
["2016-05-23",18.2,23.1,13.7,5.0999999999999996,null,5.5,1007.5,14.9,null,null,"Von 18:22 Uhr - 19:08 Uhr mäßiges Gewitter mit Regen (WW 95). Von 18:07 Uhr - 18:21 Uhr; 19:09 Uhr - 20:03 Uhr leichtes Gewitter mit Regen (WW 95). Von 17:44 Uhr - 18:06 Uhr; 20:04 Uhr - 20:21 Uhr Ferngewitter (WW 17). Von 20:22 Uhr - 21:29 Uhr Wetterleuchten (WW 13)."]
["2016-05-24",15.4,19.2,11.7,null,null,0.9,1009.4,15.05,null,null,"Regentropfen, nicht näher definiert."]
["2016-05-25",13.4,15.9,11.4,null,null,null,1014.4,15.15,"HNz","H Sören","Am Morgen Sprühregen, nicht näher definiert."]
["2016-05-26",15.7,21.1,12,null,null,1.8,1016.5,15.25,"HNFz"]
["2016-05-27",15.6,23.2,10.6,23.2,null,1.2,1016.5,15.35,null,"T Elvira 1","Von 15:31 Uhr - 17:09 Uhr leichtes Gewitter mit Regen (WW 95). Von 15:06 Uhr - 15:30 Uhr leichter Regenschauer (WW 80). Von 17:10 Uhr - 17:24 Uhr Ferngewitter (WW 17). Leicht schwül."]
["2016-05-28",17.600000000000001,23.9,12.4,null,null,5,1013.6,15.45,null,null,"Von 02:50 Uhr - 04:09 Uhr leichtes Gewitter mit Regen (WW 95). Von 04:10 Uhr - 04:29 Uhr mäßiger Regenschauer (WW 81). Von 04:30 Uhr - 04:49 Uhr leichter Regenschauer (WW 80). Mäßig schwül."]
["2016-05-29",20.3,26.4,13.4,null,null,8.6,1006.7,15.55,"TM","T Elvira 2","Von 16:35 Uhr- 17:09 Uhr Ferngewitter (WW 17).    ",null,null,null,"Stark schwül."]
["2016-05-30",19.7,25,14.4,null,null,8.4,1004.5,15.65,null,null,"Stark schwül."]
["2016-05-31",17.2,24.1,13.1,2.5,null,3.2,1009.6,15.75,null,"T Friederike","Von 13:21 Uhr - 14:07 Uhr leichtes Gewitter mit Regen (WW 95). Von 14:08 Uhr - 14:49 Uhr Ferngewitter (WW 17). Mäßig schwül."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":14.516129032258064},{"$f":"AVERAGE(C2:C32)","v":20.374193548387098},{"$f":"AVERAGE(D2:D32)","v":8.8548387096774199},"-",null,{"$f":"AVERAGE(G2:G32)","v":5.8896551724137938},{"$f":"AVERAGE(H2:H32)","v":1014.0193548387098},{"$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]