{"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":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,78,1007.5,19.399999999999999,7,null,"00",0,97,1022,16.100000000000001,6]
["01",1,74,1007.8,18.7,6,null,"01",0,97,1022.4,15.1,5]
["02",1,79,1007.4,18.100000000000001,2,null,"02",0,98,1022.6,15.6,2]
["03",0,83,1007.4,17.8,1,null,"03",0,98,1023,14.7,2]
["04",0,85,1007.4,17.8,1,null,"04",0,98,1023.2,14.7,4]
["05",0,85,1007.6,17,1,null,"05",0,99,1023.7,14.6,8]
["06",0,83,1007.6,16.8,null,null,"06",0,99,1024,15,8]
["07",null,null,null,null,null,null,"07",0,99,1024.5999999999999,15.7,8]
["08",null,null,null,null,null,null,"08",1,99,1025,16.2,6]
["09",null,null,null,null,null,null,"09",1,92,1024.9000000000001,16.2,7]
["10",null,null,null,null,null,null,"10",1,84,1025.4000000000001,16.7,6]
["11",null,null,null,null,null,null,"11",1,79,1025,16.100000000000001,5]
["12",null,null,null,null,null,null,"12",1,70,1024.5,16.399999999999999,3]
["13",null,null,null,null,null,null,"13",2,63,1024,16.7,2]
["14",null,null,null,null,null,null,"14",1,61,1023.4,17,2]
[15,null,null,null,null,null,null,"15",1,61,1023,17.2,3]
["16",null,null,null,null,null,null,"16",0,60,1022.6,16.8,3]
["17",null,null,null,null,null,null,"17",0,64,1022.1,17.2,4]
["18",null,null,null,null,null,null,"18",1,67,1021.5,17.5,3]
["19",null,null,null,null,null,null,"19",1,72,1021.5,17.2,3]
["20",null,null,null,null,null,null,"20",0,79,1021.9,17.100000000000001,3]
["21",null,null,null,null,null,null,"21",1,85,1021.9,17,3]
["22",null,null,null,null,null,null,"22",1,89,1021.9,16.7,3]
["23",null,null,null,null,null,null,"23",1,91,1021.8,16.5,3]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.4},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":81},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1007.5},{"$f":"AVERAGE(E3:E26)","v":17.942857142857143},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":3},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.6},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":83.4},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1023.2},{"$f":"AVERAGE(L3:L26)","v":16.249999999999996},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":4.3}]
[]
[null,null,null,null,"2015-09-01",null,null,null,null,null,null,"2015-08-29"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,93,1021.5,16.100000000000001,3,null,"00",0,90,1015.7,18.7,3]
["01",0,95,1021,15.9,2,null,"01",1,88,1015.3,18.100000000000001,3]
["02",0,95,1020.6,15.9,2,null,"02",0,87,1014.8,17.7,3]
["03",0,95,1020.2,15.5,2,null,"03",0,85,1014.6,17.3,4]
["04",1,96,1019.8,15.4,1,null,"04",1,87,1014.1,17.2,2]
["05",1,96,1019.7,15.3,1,null,"05",0,88,1014.1,16.8,2]
["06",0,96,1019.6,15.7,1,null,"06",0,89,1014.5,17.399999999999999,1]
["07",0,91,1019.6,17,1,null,"07",0,88,1014.2,18.600000000000001,1]
["08",1,86,1019.4,19,4,null,"08",0,77,1013.7,18.7,1]
["09",1,79,1019.3,20.5,4,null,"09",0,74,1013.2,20.5,1]
["10",1,69,1019.9,21.5,5,null,"10",1,67,1012.8,21.7,1]
["11",2,59,1018.8,21.3,5,null,"11",1,56,1012.4,22,1]
["12",2,54,1018.1,20.5,2,null,"12",2,46,1011.9,20,1]
["13",1,52,1017.7,20.6,1,null,"13",2,45,1011.4,19.7,1]
["14",2,50,1017.4,20.399999999999999,2,null,"14",2,47,1011,20.399999999999999,1]
["15",1,50,1016.6,20.6,1,null,"15",2,49,1010.1,19.600000000000001,1]
["16",2,50,1016.1,20.2,1,null,"16",2,54,1009.5,20.7,1]
["17",1,58,1016,21.2,1,null,"17",2,52,1008.9,19.7,1]
["18",1,63,1016.1,21.2,1,null,"18",1,56,1008.8,19.399999999999999,2]
["19",1,69,1016.2,20.7,1,null,"19",2,61,1008.5,18.7,2]
["20",0,78,1016.3,20.6,1,null,"20",1,69,1008.5,18.8,2]
["21",0,83,1016.4,20.399999999999999,1,null,"21",1,70,1008.4,18.600000000000001,4]
["22",0,87,1016.2,19.8,2,null,"22",0,73,1008.1,18.899999999999999,7]
["23",0,87,1016,19.2,1,null,"23",2,77,1008.1,19.3,7]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":0.8},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":76.3},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1018.3},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":18.899999999999999},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":1.9},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":69.8},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1011.8},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":19.100000000000001},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":2.2000000000000002}]
[]
[null,null,null,null,"2015-08-30",null,null,null,null,null,null,"2015-08-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:","August",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.",19.3,28.4,8.6,6.3,28,58,6,".",null,null,7.4,1016,9.4,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.",22.2,30.1,17.100000000000001,15.8,35,57,5.5,".",null,null,5.6,1017.7,13,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":8},{"$f":"COUNTIF(C6:C15,\">=25\")","v":10},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":0},{"$f":"COUNTIF(I6:I15,\">=1\")","v":0},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",23.4,31.4,14.4,10.3,32,61,1.5,".",null,null,12.2,1017.8,14.5,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":4},{"$f":"COUNTIF(C18:C27,\">=25\")","v":5},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":6},{"$f":"COUNTIF(I18:I27,\">=1\")","v":6},{"$f":"COUNTIF(I18:I27,\">=3\")","v":4},{"$f":"COUNTIF(I18:I27,\">=10\")","v":3},{"$f":"COUNTIF(I18:I27,\">=20\")","v":2}]
["04.",25.9,33.9,16.399999999999999,13.4,33,57,2.2000000000000002,".",null,null,11.8,1013.3,15.8,1,null,null,null,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":2},{"$f":"COUNTIF(C30:C40,\">=25\")","v":7},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":3},{"$f":"COUNTIF(I30:I40,\">=1\")","v":2},{"$f":"COUNTIF(I30:I40,\">=3\")","v":1},{"$f":"COUNTIF(I30:I40,\">=10\")","v":1},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",21.9,27.3,18.100000000000001,16.899999999999999,50,71,4.4000000000000004,".",null,null,7.4,1017.6,16.3,1,null,null,null,null,null,null,3]
["06.",26.3,35.4,15.8,13.4,31,58,3.8,".",null,null,11.3,1015.7,15.9,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.",28.9,38,18.899999999999999,14.7,22,48,2.4,".",null,null,12.1,1015.3,15.1,1,null,null,null,null,null,null,4,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":0},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":8}]
["08.",28.3,35.4,21.8,16.899999999999999,32,52,1.4,".",null,null,11.9,1015.3,17.100000000000001,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":4},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":2}]
["09.",24.2,30.2,18.600000000000001,16.8,50,69,2.9,".",null,null,10.8,1018,17.8,2,null,null,null,null,null,null,4,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":3}]
["10.",27.3,36.799999999999997,18.5,16.899999999999999,26,62,2.1,".",null,null,10.8,1013.9,18.2,1,null,null,null,null,1,null,6]
["Su",{"$f":"SUM(B6:B15)","v":247.70000000000005},{"$f":"SUM(C6:C15)","v":326.90000000000003},{"$f":"SUM(D6:D15)","v":168.2},{"$f":"SUM(E6:E15)","v":141.4},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":0},"XX",null,{"$f":"SUM(L6:L15)","v":101.3},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":0},{"$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":24.770000000000003},{"$f":"AVERAGE(C6:C15)","v":32.690000000000005},16.82,14.14,"XXX",59.3,3.2199999999999998,"XXX","XX",null,{"$f":"L16/10","v":10.129999999999999},{"$f":"AVERAGE(M6:M15)","v":1016.0600000000001},{"$f":"AVERAGE(N6:N15)","v":15.309999999999999},{"$f":"AVERAGE(O6:O15)","v":1.2},{"$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":7},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",27.2,34.4,19.2,"-",32,54,1.5,".",null,null,10.4,1013.6,16.600000000000001,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":4},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$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.",24.9,32.1,19.5,16.8,45,69,3.4,".",null,null,7.4,1018.4,18.399999999999999,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":1},{"$f":"COUNTIF(L30:L40,\"<1\")","v":0},{"$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.",25.2,32.9,19,16.2,44,69,2.8,".",null,null,7.6,1016.6,18.600000000000001,1,null,null,null,null,null,null,4]
["14.",27.2,35.9,19.100000000000001,15.6,30,57,4,1.1000000000000001,"R",null,8.6999999999999993,1008.1,16.7,2,null,null,1,1,1,null,6,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",23.2,29.5,19.7,16.100000000000001,47,73,4.5,1,"R",null,6.3,1007.1,17.899999999999999,2,null,null,1,1,null,null,5,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":28.9},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":38},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":6.3},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":75.5}]
["16.",19.8,22.2,16.899999999999999,14.3,86,94,7,16.100000000000001,"R",null,".",1008.6,18.8,1,null,null,1,1,null,null,3,2,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",18.899999999999999,22.2,15.9,13.6,83,96,8,75.5,"R",null,".",1008.7,18.3,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":15.3},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":8.6},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":22},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",15.3,16.2,14.5,14.4,96,98,8,22.5,"R",null,".",1013.8,15,1,null,null,1,null,null,null,3]
["19.",15.3,16.100000000000001,14.8,14.4,96,98,8,3.9,"R",null,".",1019.3,15,1,null,null,null,null,null,null,3]
["20.",17.3,22.6,13.2,"-",48,80,7.1,".",null,null,4.3,1023.4,13.4,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B18:B27)","v":214.30000000000004},{"$f":"SUM(C18:C27)","v":264.09999999999997},{"$f":"SUM(D18:D27)","v":171.8},{"$f":"SUM(E18:E27)","v":121.4},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":120.10000000000001},"XX",null,{"$f":"SUM(L18:L27)","v":44.699999999999989},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":3},{"$f":"SUM(T18:T27)","v":1},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":21.430000000000003},{"$f":"AVERAGE(C18:C27)","v":26.409999999999997},17.18,15.175000000000001,60.7,78.8,5.4300000000000006,"XXX","XX",null,{"$f":"L28/10","v":4.4699999999999989},{"$f":"AVERAGE(M18:M27)","v":1013.76},{"$f":"AVERAGE(N18:N27)","v":16.869999999999997},{"$f":"AVERAGE(O18:O27)","v":1.2},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3.8}]
["21.",17.600000000000001,24.8,10.3,7.6,36,69,2.2999999999999998,".",null,null,9.8000000000000007,1024.5,11.1,1,null,null,null,null,null,null,4]
["22.",17.399999999999999,25.3,10.1,"-",35,64,1.2,".",null,null,9.1999999999999993,1020.2,9.9,1,null,null,null,null,null,null,4]
["23.",17.7,24.8,9.5,6.8,47,70,2.4,2.9,"R",null,9.3000000000000007,1013.5,11.6,2,null,null,1,null,null,null,5]
["24.",20.9,26.6,15.9,13.5,55,76,5.8,10,"R",null,5.7,1007.8,16.100000000000001,2,null,null,1,null,null,null,5]
["25.",17.100000000000001,20.7,15.1,13.4,58,76,6.2,".",null,null,2.9,1014.7,12.7,2,null,null,null,1,1,null,6]
["26.",18.399999999999999,25.9,11,8,36,67,3.5,".",null,null,10.199999999999999,1017.9,11.4,1,null,null,null,null,null,null,5]
["27.",22.3,29.6,13.5,10.1,41,59,6,0,null,null,6.7,1012.2,13.4,2,null,null,null,null,null,null,5]
["28.",18.2,24.1,16.100000000000001,"-",48,86,7.6,0.4,"R",null,".",1016.2,15.8,1,null,null,1,null,null,null,4]
["29.",19.5,25.6,14.7,"-",59,83,4.3,".",null,null,6.7,1023.2,16.3,1,null,null,null,null,null,null,3]
["30.",24.1,32.5,15.7,13.7,49,76,1.9,".",null,null,8.8000000000000007,1018.3,18.899999999999999,1,null,null,null,null,null,null,4]
["31.",25.7,33.5,18.8,15.8,43,70,2.2000000000000002,".",null,null,8.3000000000000007,1011.8,19.100000000000001,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B30:B40)","v":218.89999999999998},{"$f":"SUM(C30:C40)","v":293.39999999999998},{"$f":"SUM(D30:D40)","v":150.70000000000002},{"$f":"SUM(E30:E40)","v":88.899999999999991},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":13.3},"XX",null,{"$f":"SUM(L30:L40)","v":77.599999999999994},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":3},{"$f":"SUM(S30:S40)","v":1},{"$f":"SUM(T30:T40)","v":1},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":19.899999999999999},{"$f":"AVERAGE(C30:C40)","v":26.672727272727272},{"$f":"AVERAGE(D30:D40)","v":13.700000000000001},{"$f":"AVERAGE(E30:E40)","v":11.112499999999999},"XXX",{"$f":"AVERAGE(G30:G40)","v":72.36363636363636},{"$f":"AVERAGE(H30:H40)","v":3.9454545454545453},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1016.3909090909088},{"$f":"AVERAGE(N30:N40)","v":14.209090909090911},{"$f":"AVERAGE(O30:O40)","v":1.3636363636363635},{"$f":"ROUND(AVERAGE(P30:P40),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4.4545454545454541}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":680.90000000000009},{"$f":"SUM(C16+C28+C41)","v":884.4},{"$f":"SUM(D16+D28+D41)","v":490.70000000000005},{"$f":"SUM(E16+E28+E41)","v":351.7},"XXX","XXX,",{"$f":"SUM(H16+H28+H41)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I16+I28+I41)","v":133.4},"XX",null,{"$f":"SUM(L16+L28+L41)","v":223.6},"XXX","XXX","XXX",{"$f":"SUM(P16+P28+P41)","v":{"$error":"#VALUE!"}},"X",{"$f":"SUM(R16+R28+R41)","v":8},{"$f":"SUM(S16+S28+S41)","v":4},{"$f":"SUM(T16+T28+T41)","v":5},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":21.964516129032262},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":28.529032258064518},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":15.829032258064515},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":13.526923076923079},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":70.225806451612897},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":4.1903225806451605},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1015.4354838709679},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":15.42258064516129},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.2580645161290323},{"$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.2848484848484842}]
[]
[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":9},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":5}]
["TTT",18.600000000000001,"XXXX",{"$f":"SUM(B44-B48)","v":3.3645161290322605},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":14},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":8},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":0}]
["RRR",84,{"$f":"SUM(I43*100/B49)","v":158.8095238095238},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":22},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":9}]
["sss",211,{"$f":"SUM(L43*100/B50)","v":105.97156398104265},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":4},"Schneedecke cm"]
["astr.",null,null,"XXXX","Polartag",null,null,null,0,null,null,">/=  20,0",null,null,{"$f":"SUM(AI7:AI9)","v":2},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",449,{"$f":"SUM(L43*100/B52)","v":49.799554565701555},"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":4},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":0}]
[null,null,null,null,"Tropennacht",null,null,null,1,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":13}]
[]
[]
[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:","August",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,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.","-",{"$f":"IF(R12=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-",{"$f":"IF(R13=1,1,\"-\")","v":"-"},"-","-",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.","-",{"$f":"IF(R16=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-",{"$f":"IF(R22=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-",1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-","-","-",1,"-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-","-",1,"-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-",1,1,1,1,"-"]
["30.","-","-","-","-",1,1,"-"]
["31.","-","-","-","-",1,"-","-"]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,6,9,26,8,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":8}]

{"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)"]
[]
["August 2015"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":38},"am","2015-08-07"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":21.964516129032262},{"$f":"Kurztabelle!B48","v":18.600000000000001},{"$f":"C7-D7","v":3.3645161290322605},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":8.6},"am","2015-08-01"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":133.4},{"$f":"Kurztabelle!B49","v":84},{"$f":"100/D9*C9","v":158.80952380952382},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":223.6},{"$f":"Kurztabelle!B50","v":211},{"$f":"100/D10*C10","v":105.97156398104265},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":49,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2015-08-01",19.3,28.4,8.6,null,null,7.4,1016,19.649999999999999]
["2015-08-02",22.2,30.1,17.100000000000001,null,null,5.6,1017.7,19.649999999999999,"SEa","(H Finnchen)"]
["2015-08-03",23.4,31.4,14.4,null,null,12.2,1017.8,19.600000000000001,null,null,"Mäßig schwül."]
["2015-08-04",25.9,33.9,16.399999999999999,null,null,11.8,1013.3,19.600000000000001,"SWz","T Bonimir","Mäßig schwül."]
["2015-08-05",21.9,27.3,18.100000000000001,null,null,7.4,1017.6,19.55,"SWa","H Finnchen","Mäßig schwül."]
["2015-08-06",26.3,35.4,15.8,null,null,11.3,1015.7,19.5,null,null,"Stark schwül."]
["2015-08-07",28.9,38,18.899999999999999,null,null,12.1,1015.3,19.45,null,null,"Mäßig schwül."]
["2015-08-08",28.3,35.4,21.8,null,null,11.9,1015.3,19.399999999999999,null,null,"Stark schwül."]
["2015-08-09",24.2,30.2,18.600000000000001,null,null,10.8,1018,19.350000000000001,"U",null,"Stark schwül."]
["2015-08-10",27.3,36.799999999999997,18.5,null,null,10.8,1013.9,19.25,"SEz","T Detlef","Stark schwül."]
["2015-08-11",27.2,34.4,19.2,null,null,10.4,1013.6,19.2,null,null,"Mäßig schwül."]
["2015-08-12",24.9,32.1,19.5,null,null,7.4,1018.4,19.149999999999999,"HNz","H Hildegard","Stark schwül."]
["2015-08-13",25.2,32.9,19,null,null,7.6,1016.6,19.100000000000001,"HFz",null,"Stark schwül."]
["2015-08-14",27.2,35.9,19.100000000000001,1.1000000000000001,null,8.6999999999999993,1008.1,19,"SWz","T Eberhardt","Gegen 20:00 Uhr leichter Regenschauer (WW 80). Von 20:00 Uhr - 20:09 Uhr Ferngewitter (WW 17). Von 19:35 Uhr - 19:59 Uhr; 20:10 Uhr - 21:09 Uhr Wetterleuchten (WW 13). Mäßig schwül."]
["2015-08-15",23.2,29.5,19.7,1,null,6.3,1007.1,18.899999999999999,null,null,"Von 16:23 Uhr - 16:32 Uhr mäßiger Regenschauer (WW 81). Vor 06:00 Uhr; Gegen 15:15 Uhr Ferngewitter (WW 17).",null,null,null,null,null,null,null,null,"Stark schwül."]
["2015-08-16",19.8,22.2,16.899999999999999,16.100000000000001,null,null,1008.6,18.8,"SEz","T Florian","Von 11:50 Uhr - 12:19 Uhr; 17:00 Uhr - 18:22 Uhr leichtes Gewitter mit Regen (WW 95). Von 11:10 Uhr - 11:49 Uhr starker Regenschauer (WW 81). Von 18:23 Uhr - 20:09 Uhr mäßiger Regen (WW 63). Von 20:10 Uhr - 20:19 Uhr leichter Regen (WW 61). Von 14:30 Uhr - 16:59 Uhr Gewitter in der Ferne (WW 17). Von 17:50 Uhr - 23:59 Uhr mäßiger Dunst (WW 10). Gegen 05:00 Uhr - 08:39 Uhr; 11:10 Uhr - 14:59 Uhr: 16:50 Uhr - 17:49 Uhr leichter Dunst (WW 10).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2015-08-17",18.899999999999999,22.2,15.9,75.5,null,null,1008.7,18.7,null,null,"Von 17:50 Uhr - 19:19 Uhr; 20:20 Uhr - 20:39 Uhr; 21:50 Uhr - 22:09 Uhr starker Regen (WW 65). Von 16:00 Uhr - 16:50 Uhr starker Regen, unterbrochen (WW 64). Von 20:09 Uhr - 20:19 Uhr; 20:40 Uhr - 21:49 Uhr; 22:10 Uhr - 23:59 Uhr mäßiger Regen (WW 63). Von 14:00 Uhr - 15:59 Uhr; 16:51 Uhr - 17:49 Uhr; 19:20 Uhr - 20:09 Uhr leichter Regen (WW 61). Von 00:00 Uhr - 08:59 Uhr; 16:10 Uhr -20:59 Uhr mäßiger Dunst (WW 10). Von 09:00 Uhr - 11:19 Uhr; 14:30 Uhr - 16:09 Uhr; 21:00 Uhr - 23:59 Uhr leichter Dunst (WW 10).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2015-08-18",15.3,16.2,14.5,22.5,null,null,1013.8,18.600000000000001,null,null,"Von 04:50 Uhr - 06:29 Uhr starker Regen (WW 65). Von 00:00 Uhr - 00:19 Uhr; 02:00 Uhr - 02:39 Uhr; 04:10 Uhr - 04:39 Uhr; 06:30 Uhr - 07:59 Uhr; 09:30 Uhr - 13:39 Uhr; 16:00 Uhr - 17:19 Uhr; 17:30 Uhr -  19:10 Uhr: 20:40 Uhr - 23:19 Uhr mäßiger Regen (WW 63). Von 00:20 Uhr - 01:59 Uhr; 02:40 Uhr - 04:09 Uhr; 08:00 Uhr - 08:19 Uhr  - 09:29 Uhr; 13:40 Uhr - 15:59 Uhr; 17:20 Uhr - 17:29 Uhr; 19:11 Uhr - 20:39 Uhr; 23:20 Uhr - 23:59 Uhr leichter Regen (WW 61). Von 00:00 Uhr - 12:59 Uhr leichter Dunst (WW 10). Leicht schwül."]
["2015-08-19",15.3,16.100000000000001,14.8,3.9,null,null,1019.3,18.45,null,null,"Von 11:40 Uhr - 12:29 Uhr; 13:00 Uhr - 13:39 Uhr mäßiger Regen (WW 63). Von 00:00 Uhr - 00:49 Uhr; 06:30 Uhr - 11:39 Uhr; 12:30 Uhr - 12:59 Uhr leichter Regen (WW 61). Gegen 05:00 Uhr - 06:29 Uhr mäßiger Sprühregen (WW 53). Gegen 05:00 Uhr - 14:29 Uhr leichter Dunst (WW 10). Leicht schwül."]
["2015-08-20",17.3,22.6,13.2,null,null,4.3,1023.4,18.350000000000001,"HFa","H Isabel","Von 03:40 Uhr - 06:39 Uhr starker Dunst (WW 10). Von 03:30 Uhr - 03:39 Uhr; 06:40 Uhr - 07:19 Uhr mäßiger Dunst WW 10). Von 03:00 Uhr - 03:29 Uhr; 07:20 Uhr - 08:39 Uhr leichter Dunst (WW 10)."]
["2015-08-21",17.600000000000001,24.8,10.3,null,null,9.8000000000000007,1024.5,18.2]
["2015-08-22",17.399999999999999,25.3,10.1,null,null,9.1999999999999993,1020.2,18.05]
["2015-08-23",17.7,24.8,9.5,2.9,null,9.3000000000000007,1013.5,17.899999999999999,"SWz","T Hans"]
["2015-08-24",20.9,26.6,15.9,10,null,5.7,1007.8,17.75,null,null,"Von 03:10 Uhr - 03:49 Uhr; Gegen 06:00 Uhr mäßiger Regen (WW 63). Gegen 02:30 Uhr; 04:30 Uhr; 06:30 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2015-08-25",17.100000000000001,20.7,15.1,null,null,2.9,1014.7,17.600000000000001,null,null,"Von 00:00 Uhr - 00:49 Uhr mäßiger Regenschauer (WW 81). Von 00:50 Uhr - 02:29 Uhr; Gegen 06:30 Uhr leichter Regenschauer (WW 80). Gegen 00:00 Uhr leichtes Ferngewitter (WW 17). Mäßig schwül."]
["2015-08-26",18.399999999999999,25.9,11,null,null,10.199999999999999,1017.9,17.45,null,"T Immanuel"]
["2015-08-27",22.3,29.6,13.5,null,null,6.7,1012.2,17.3,null,null,"Leicht schwül."]
["2015-08-28",18.2,24.1,16.100000000000001,null,null,null,1016.2,17.149999999999999,null,null,"Gegen 09:30 Uhr; 18:00 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2015-08-29",19.5,25.6,14.7,null,null,null,1023.2,17,"SWa","H Karma","Gegen 03:30 Uhr - 08:19 Uhr Uhr leichter Dunst (WW 10). Mäßig schwül."]
["2015-08-30",24.1,32.5,15.7,null,null,8.8000000000000007,1018.3,16.850000000000001,null,null,"Extrem schwül."]
["2015-08-31",25.7,33.5,18.8,null,null,8.3000000000000007,1011.8,16.7,null,null,"Extrem schwül."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":21.964516129032262},{"$f":"AVERAGE(C2:C32)","v":28.529032258064518},{"$f":"AVERAGE(D2:D32)","v":15.829032258064515},"-",null,{"$f":"AVERAGE(G2:G32)","v":8.6760000000000019},{"$f":"AVERAGE(H2:H32)","v":1015.4354838709679},{"$f":"AVERAGE(I2:I32)","v":18.554838709677419}]
["Mittel",18.600000000000001,null,null,84,"-",211,1015.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]