{"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,90,1012.5,16,3,null,"00",0,96,1015.1,15.3,2]
["01",1,91,1012.2,16,6,null,"01",0,96,1015.7,15.3,6]
["02",0,92,1012,16.2,7,null,"02",1,96,1015.8,15.4,6]
["03",0,94,1011.7,15.4,3,null,"03",1,97,1015.8,15.4,7]
["04",0,93,1011.5,14.8,3,null,"04",1,97,1016,16,7]
["05",0,94,1011.5,14.8,5,null,"05",0,97,1016.2,16.2,7]
["06",0,91,1011.5,15.8,7,null,"06",1,94,1016.4,16.7,7]
["07",0,90,1011.3,16.2,7,null,"07",1,91,1016.9,16.8,7]
["08",0,90,1011.3,17.399999999999999,7,null,"08",1,86,1017.1,17.100000000000001,7]
["09",0,85,1011.3,18.100000000000001,7,null,"09",1,80,1017.2,16.2,6]
["10",0,84,1011,19,8,null,"10",1,73,1017.1,17,3]
["11",1,81,1011.4,19.2,8,null,"11",1,69,1016.7,18.3,3]
["12",1,75,1010.9,19.8,7,null,"12",1,65,1016.4,17.399999999999999,4]
["13",1,76,1010.4,19.100000000000001,8,null,"13",1,55,1016,15.4,6]
["14",2,91,1010.4,18.3,8,null,"14",1,53,1015.6,15.1,7]
[15,2,94,1010.9,17.8,8,null,"15",1,55,1015,16.399999999999999,6]
["16",1,96,1010.4,18.7,8,null,"16",1,54,1014.8,15.3,7]
["17",2,96,1010.4,18.8,8,null,"17",1,57,1014.5,15.7,6]
["18",0,97,1010.5,19.2,8,null,"18",0,58,1014.2,15.4,7]
["19",0,98,1010.6,19.2,7,null,"19",0,65,1014,16.3,7]
["20",0,96,1011.1,18.5,7,null,"20",1,76,1014.2,16.5,4]
["21",1,95,1010.4,17.7,7,null,"21",2,81,1014.3,16.7,3]
["22",3,91,1012.5,16.7,8,null,"22",2,76,1014.1,15.7,3]
["23",3,95,1013.6,15.5,8,null,"23",1,83,1013.9,15.7,4]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.8},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":90.6},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1011.3},{"$f":"AVERAGE(E3:E26)","v":17.424999999999997},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":6.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.9},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":77.099999999999994},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1015.5},{"$f":"AVERAGE(L3:L26)","v":16.137499999999999},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":5.5}]
[]
[null,null,null,null,"2016-07-31",null,null,null,null,null,null,"2016-07-28"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",2,85,1013.5,15.9,7,null,"00",2,76,1012.7,15.6,7]
["01",1,85,1013.2,16.100000000000001,8,null,"01",2,89,1012.5,16.8,8]
["02",1,84,1013,16.100000000000001,8,null,"02",0,95,1012.5,16.899999999999999,3]
["03",1,83,1012.9,15.9,8,null,"03",0,92,1012.4,16.600000000000001,6]
["04",1,78,1013.2,15.5,8,null,"04",0,94,1012.6,16.3,6]
["05",0,82,1013.2,15.8,8,null,"05",0,87,1012.6,14.9,5]
["06",1,82,1013.2,16.2,7,null,"06",0,82,1013.2,15.6,4]
["07",1,77,1013.3,16.899999999999999,6,null,"07",0,74,1013.1,15.6,4]
["08",2,73,1013.3,16.600000000000001,5,null,"08",1,70,1013.3,16,2]
["09",1,69,1013.2,17.2,4,null,"09",1,64,1013,16.899999999999999,1]
["10",2,66,1013.3,16.2,6,null,"10",1,62,1012.7,16.100000000000001,6]
["11",2,72,1013.3,16.899999999999999,7,null,"11",2,58,1012.2,16.899999999999999,6]
["12",2,71,1013,17.100000000000001,6,null,"12",1,60,1012.1,16.3,7]
["13",2,62,1012.7,16.8,3,null,"13",3,53,1011.8,16.3,5]
["14",1,59,1012.3,16.899999999999999,3,null,"14",2,56,1011.4,16.600000000000001,7]
["15",2,56,1012.1,16.5,3,null,"15",2,51,1011.3,15.9,7]
["16",2,55,1011.8,15.7,5,null,"16",2,69,1011.9,17.8,7]
["17",2,60,1011.9,16,6,null,"17",1,68,1012,17.600000000000001,5]
["18",1,63,1011.9,16,7,null,"18",1,72,1012,18.100000000000001,3]
["19",1,65,1012,16.100000000000001,6,null,"19",1,77,1012,18,5]
["20",1,70,1012.3,15.8,5,null,"20",0,81,1012.3,17.5,3]
["21",2,72,1012.5,15.5,5,null,"21",1,86,1012.5,17.399999999999999,6]
["22",2,76,1012.5,15.7,6,null,"22",0,89,1012.6,16.899999999999999,7]
["23",1,78,1012.3,15.6,7,null,"23",0,92,1012.7,16.600000000000001,5]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.4},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":71.8},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1012.7},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":16.2},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":6},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":74.900000000000006},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1012.4},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":16.600000000000001},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":5.2}]
[]
[null,null,null,null,"2016-07-29",null,null,null,null,null,null,"2016-07-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:","Juli",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.",21.9,27.6,15.2,"-",49,72,3.8,0.5,"R",null,8.3000000000000007,1015.3,16.3,1,null,null,1,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.",18.100000000000001,27.8,12,"-",51,87,6.3,6.8,"R",null,2.1,1013.9,15.9,1,null,null,1,1,null,null,5,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":5},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":7},{"$f":"COUNTIF(I6:I15,\">=1\")","v":4},{"$f":"COUNTIF(I6:I15,\">=3\")","v":2},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",14.7,20.5,10.1,"-",50,78,3.9,1.2,"R",null,6.2,1020,10.7,2,null,null,1,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":1},{"$f":"COUNTIF(C18:C27,\">=25\")","v":4},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":5},{"$f":"COUNTIF(I18:I27,\">=1\")","v":3},{"$f":"COUNTIF(I18:I27,\">=3\")","v":2},{"$f":"COUNTIF(I18:I27,\">=10\")","v":2},{"$f":"COUNTIF(I18:I27,\">=20\")","v":2}]
["04.",16.5,22.9,8.6,"-",39,71,2.6,0.8,"R",null,11.2,1021.4,10.6,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":9},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":6},{"$f":"COUNTIF(I30:I40,\">=1\")","v":4},{"$f":"COUNTIF(I30:I40,\">=3\")","v":2},{"$f":"COUNTIF(I30:I40,\">=10\")","v":1},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",18.2,26.3,11.7,"-",44,78,5.2,2.2999999999999998,"R",null,6.6,1014.3,13.7,1,null,null,1,1,1,null,6]
["06.",16.2,20.6,13.5,"-",48,67,5.5,0.1,"R",null,5.8,1015.9,10.1,3,null,null,1,null,1,null,7,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.3,21.5,11.5,"-",47,68,3.8,0,null,null,9.8000000000000007,1020.7,10.199999999999999,2,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":1}]
["08.",19.2,27.4,11.1,"-",44,70,7.1,6,"R",null,2.5,1016.5,13,2,null,null,1,1,1,null,6,2,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":3},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":1}]
["09.",18.399999999999999,23.8,14.4,"-",49,74,5.0999999999999996,".",null,null,5.9,1017.1,13.5,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":1},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",22.3,29.2,13.6,10.1,49,71,5.8,".",null,null,9.1999999999999993,1014.5,16.100000000000001,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B6:B15)","v":181.8},{"$f":"SUM(C6:C15)","v":247.60000000000002},{"$f":"SUM(D6:D15)","v":121.69999999999999},{"$f":"SUM(E6:E15)","v":10.1},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":17.700000000000003},"XX",null,{"$f":"SUM(L6:L15)","v":67.599999999999994},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":7},{"$f":"SUM(S6:S15)","v":3},{"$f":"SUM(T6:T15)","v":4},{"$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":18.18},{"$f":"AVERAGE(C6:C15)","v":24.76},12.169999999999998,10.1,"XXX",73.599999999999994,4.91,"XXX","XX",null,{"$f":"L16/10","v":6.76},{"$f":"AVERAGE(M6:M15)","v":1016.9599999999998},{"$f":"AVERAGE(N6:N15)","v":13.01},{"$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":4.9000000000000004},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":1},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",25.6,32.1,18.899999999999999,16.3,40,63,6.5,".",null,null,5.7,1008.9,17.3,1,null,null,null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":1},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$f":"COUNTIF(L18:L27,\">=10\")","v":2},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",21.1,25.2,17.8,16.399999999999999,54,71,7.4,0,null,null,1.4,1011.5,15.7,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":0},{"$f":"COUNTIF(L30:L40,\"<1\")","v":1},{"$f":"COUNTIF(L30:L40,\">=10\")","v":2},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":0},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",18.399999999999999,23.7,15.5,14.4,57,79,6.5,34.9,"R",null,3.7,1011.3,14.9,1,null,null,1,1,null,null,5]
["14.",13.7,15.2,12.7,12.7,80,94,7.8,32.299999999999997,"R",null,".",1012.6,12.8,2,null,null,1,null,1,null,6,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",14.3,17.100000000000001,12.1,11.1,74,86,7.5,0.2,"R",null,0.3,1021.4,11.9,2,null,null,1,null,1,null,6,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":25.6},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":32.1},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":7.9},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":34.9}]
["16.",17.600000000000001,23.5,9.8000000000000007,7.9,42,69,4,1,"R",null,10.9,1023.4,11.3,1,null,null,1,null,null,null,5,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",19.399999999999999,24.2,16.5,16.100000000000001,70,86,6.8,0.3,"R",null,1.7,1019.4,16.899999999999999,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":13.7},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":8.6},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":39},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",19.3,23.4,16.7,13.9,54,74,5.8,".",null,null,2.8,1019.7,14.3,2,null,null,null,null,null,null,5]
["19.",20.6,26.4,15.1,12.4,54,75,4.0999999999999996,".",null,null,6,1020.9,15.6,1,null,null,null,null,null,null,4]
["20.",21.2,27.7,13.3,11.4,47,73,1.4,".",null,null,13,1018.2,15.6,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B18:B27)","v":191.2},{"$f":"SUM(C18:C27)","v":238.5},{"$f":"SUM(D18:D27)","v":148.4},{"$f":"SUM(E18:E27)","v":132.60000000000002},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":68.699999999999989},"XX",null,{"$f":"SUM(L18:L27)","v":45.5},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":1},{"$f":"SUM(T18:T27)","v":2},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":19.119999999999997},{"$f":"AVERAGE(C18:C27)","v":23.85},14.84,13.260000000000002,57.2,77,5.7799999999999994,"XXX","XX",null,{"$f":"L28/10","v":4.55},{"$f":"AVERAGE(M18:M27)","v":1016.7299999999999},{"$f":"AVERAGE(N18:N27)","v":14.63},{"$f":"AVERAGE(O18:O27)","v":1.3},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4.8}]
["21.",19.899999999999999,24.7,15.8,13.9,63,87,6.1,1.9,"R",null,1.1000000000000001,1014.7,17.5,1,null,null,1,null,null,null,4]
["22.",22.1,29.1,15.1,13.5,50,77,3.1,".",null,null,11.7,1015.9,17.5,1,null,null,null,null,null,null,3]
["23.",21.6,29.5,15.1,13.3,53,76,6.4,19.8,"R",null,6.3,1016.6,16.8,1,null,null,1,null,null,null,4]
["24.",20.8,25.6,18.100000000000001,18,69,90,5.8,".",null,null,1.5,1018.1,19,1,null,null,null,null,null,null,3]
["25.",22.4,28.9,15.8,13.8,49,77,3,".",null,null,12.7,1017.2,17.7,1,null,null,null,null,null,null,3]
["26.",21.6,26.3,17.5,15.5,69,83,6.2,0.3,"R",null,2.4,1018.3,18.399999999999999,1,null,null,1,null,null,null,4]
["27.",20.5,28.3,15.9,"-",58,90,6.5,1.1000000000000001,"R",null,1.7,1015.9,18.7,1,null,null,1,1,null,null,4]
["28.",20.7,26.3,15.7,14.4,49,77,5.5,".",null,null,3.8,1015.5,16.100000000000001,1,null,null,null,null,null,null,4]
["29.",21.7,26.1,18.3,16.5,52,72,6,0.4,"R",null,4.9000000000000004,1012.7,16.2,1,null,null,1,null,null,null,5]
["30.",21.5,27.6,16.899999999999999,14.6,47,75,5.2,".",null,null,5.2,1012.4,16.600000000000001,1,null,null,null,null,null,null,5]
["31.",18.899999999999999,24.7,15.5,13.6,71,91,6.8,7,"R",null,0.3,1011.3,17.399999999999999,1,null,null,1,1,null,null,5,2]
["Su",{"$f":"SUM(B30:B40)","v":231.7},{"$f":"SUM(C30:C40)","v":297.10000000000002},{"$f":"SUM(D30:D40)","v":179.70000000000002},{"$f":"SUM(E30:E40)","v":147.1},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":30.5},"XX",null,{"$f":"SUM(L30:L40)","v":51.599999999999994},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":6},{"$f":"SUM(S30:S40)","v":2},{"$f":"SUM(T30:T40)","v":0},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":21.063636363636363},{"$f":"AVERAGE(C30:C40)","v":27.009090909090911},{"$f":"AVERAGE(D30:D40)","v":16.33636363636364},{"$f":"AVERAGE(E30:E40)","v":14.709999999999999},"XXX",{"$f":"AVERAGE(G30:G40)","v":81.36363636363636},{"$f":"AVERAGE(H30:H40)","v":5.5090909090909088},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1015.3272727272725},{"$f":"AVERAGE(N30:N40)","v":17.445454545454545},{"$f":"AVERAGE(O30:O40)","v":1},{"$f":"AVERAGE(P30:P40)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":604.70000000000005},{"$f":"SUM(C16+C28+C41)","v":783.2},{"$f":"SUM(D16+D28+D41)","v":449.80000000000007},{"$f":"SUM(E16+E28+E41)","v":289.8},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":116.89999999999999},"XX",null,{"$f":"SUM(L16+L28+L41)","v":164.7},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":18},{"$f":"SUM(S16+S28+S41)","v":6},{"$f":"SUM(T16+T28+T41)","v":6},{"$f":"SUM(U16+U28+U41)","v":0},"XXX",8]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":19.506451612903231},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":25.264516129032256},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":14.509677419354841},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":13.800000000000002},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":77.451612903225808},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":5.4032258064516121},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1016.3064516129033},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":15.106451612903228},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.2903225806451613},{"$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.5666666666666664}]
[]
[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":18},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":1}]
["TTT",19,"XXXX",{"$f":"SUM(B44-B48)","v":0.5064516129032306},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":1},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":11},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":2}]
["RRR",85,{"$f":"SUM(I43*100/B49)","v":137.52941176470588},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":18},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":6},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":5}]
["sss",221,{"$f":"SUM(L43*100/B50)","v":74.524886877828052},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":3},"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.",493,{"$f":"SUM(L43*100/B52)","v":33.40770791075051},"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,0,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":2}]
[]
[]
[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:","Juli",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,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.","-",{"$f":"IF(R12=1,1,\"-\")","v":"-"},"-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["05.","-",{"$f":"IF(R13=1,1,\"-\")","v":"-"},"-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-","-","-",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,1,"-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-","-","-",1,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,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",1,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,"-",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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-",1,1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,"-","-"]
["30.","-","-","-","-",1,"-","-"]
["31.","-","-","-",1,1,"-","-"]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,4,11,29,16,1]
[]
[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)"]
[]
["Juli 2016"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":32.1},"am","2016-07-11"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":19.506451612903231},{"$f":"Kurztabelle!B48","v":19},{"$f":"C7-D7","v":0.5064516129032306},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":8.6},"am","2016-07-04"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":116.89999999999999},{"$f":"Kurztabelle!B49","v":85},{"$f":"100/D9*C9","v":137.52941176470588},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":164.7},{"$f":"Kurztabelle!B50","v":221},{"$f":"100/D10*C10","v":74.524886877828052},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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"]
["2016-07-01",21.9,27.6,15.2,0.5,null,8.3000000000000007,1015.3,17.7,"-","-","Mäßig schwül."]
["2016-07-02",18.100000000000001,27.8,12,6.8,null,2.1,1013.9,17.8,"-","-","Von 11:10 Uhr - 11:39 Uhr leichtes Gewitter mit Regen (WW 95). Von 12:55 Uhr - 13:19 Uhr mäßiger Regenschauer (WW 81). Von 11:40 Uhr - 11:54 Uhr; 13:20 Uhr - 13:34 Uhr leichter Regenschauer (WW 80). Von 05:05 Uhr - 05:19 Uhr mäßiger Regen (WW 63). Von 15:10 Uhr - 18:44 Uhr mäßiger Regen, unterbrochen (WW 62).",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."]
["2016-07-03",14.7,20.5,10.1,1.2,null,6.2,1020,17.899999999999999,"-","-","Von 13:15 Uhr - 13:49 Uhr leichter Regenschauer (WW 80). Von 16:00 Uhr - 16:19 Uhr mäßiger Regen (WW 63)."]
["2016-07-04",16.5,22.9,8.6,0.8,null,11.2,1021.4,18,"-","-"]
["2016-07-05",18.2,26.3,11.7,2.2999999999999998,null,6.6,1014.3,18.100000000000001,"-","-","Von 19:00 Uhr - 19:29 Uhr leichtes Gewitter mit Regen (WW 95). Von 05:30 Uhr - 06:44 Uhr mäßiger Regen (WW 63). Mäßig schwül."]
["2016-07-06",16.2,20.6,13.5,0.1,null,5.8,1015.9,18.2,"-","-","Gegen 10:40 Uhr leichter Regenschauer (WW 80)."]
["2016-07-07",16.3,21.5,11.5,null,null,9.8000000000000007,1020.7,18.3,"-","-"]
["2016-07-08",19.2,27.4,11.1,6,null,2.5,1016.5,18.399999999999999,"-","-","Von 18:45 Uhr - 19:04 Uhr; 22:45 Uhr - 22:59 Uhr leichtes Gewitter mit Regen (WW 95). Von 21:30 Uhr - 21:39 Uhr; 23:00 Uhr - 23:29 Uhr mäßiger Regenschauer (WW 81). Von 21:40 Uhr - 21:59 Uhr leichter Regenschauer (WW 80). Von 19:05 Uhr - 19:19 Uhr Ferngewitter (WW 17). Leicht schwül."]
["2016-07-09",18.399999999999999,23.8,14.4,null,null,5.9,1017.1,18.5,"SWa","H Axel"]
["2016-07-10",22.3,29.2,13.6,null,null,9.1999999999999993,1014.5,18.600000000000001,null,null,"Stark schwül."]
["2016-07-11",25.6,32.1,18.899999999999999,null,null,5.7,1008.9,18.7,"SWz","T Tiba"]
["2016-07-12",21.1,25.2,17.8,null,null,1.4,1011.5,18.8,null,null,"Von 19:00 Uhr - 19:14 Uhr leichter Regen (WW 61). Von 18:30 Uhr - 18:59 Uhr Regentropfen (WW 60). Mäßig schwül."]
["2016-07-13",18.399999999999999,23.7,15.5,34.9,null,3.7,1011.3,18.899999999999999,"TrM","T Ulrike 2","Von 12:20 Uhr - 12:59 Uhr leichtes Gewitter mit Regen (WW 95). Von 10:50 Uhr - 11:19 Uhr; 13:00 Uhr - 13:09 Uhr leichter Regenschauer (WW 80). Von 20:10 Uhr - 20:29 Uhr; 20:50 Uhr - 21:09 Uhr starker Regen (WW 65). Von 20:30 Uhr - 20:49 Uhr; 21:40 Uhr - 23:59 Uhr mäßiger Regen (WW 63). Von 21:10 Uhr - 21:39 Uhr leichter Regen (WW 61). Leicht schwül."]
["2016-07-14",13.7,15.2,12.7,32.299999999999997,null,null,1012.6,19,null,null,"Von 01:40 Uhr - 01:49 Uhr; 12:30 Uhr - 12:39 Uhr; 14:00 Uhr - 14:09 Uhr starker Regen (WW 65). Von 05:50 Uhr - 10:19 Uhr starker Regen, unterbrochen (WW 64). Von 00:00 Uhr - 01:39 Uhr; 01:50 Uhr - 03:19 Uhr; 03:50 Uhr - 05:49 Uhr; 10:20 Uhr - 12:29 Uhr; 12:40 Uhr - 13:59 Uhr mäßiger Regen (WW 63). Von 03:20 Uhr - 03:49 Uhr; 14:10 Uhr - 14:59 Uhr leichter Regen (WW 61)."]
["2016-07-15",14.3,17.100000000000001,12.1,0.2,null,0.3,1021.4,19.100000000000001,"NWz",null,"Von 00:05 Uhr - 01:39 Uhr; Gegen 04:00 Uhr mäßiger Regen (WW 63). Gegen 07:00 Uhr leichter Regen (WW 61). Von 07:30 Uhr - 07:39 Uhr; 09:58 Uhr - 10:14 Uhr leichten Sprühregen (WW 51)."]
["2016-07-16",17.600000000000001,23.5,9.8000000000000007,1,null,10.9,1023.4,19.2,"BM","H Burkhard"]
["2016-07-17",19.399999999999999,24.2,16.5,0.3,null,1.7,1019.4,19.3,null,null,"Von 03:20 Uhr - 03:39 Uhr; 05:20 Uhr - 06:19 Uhr mäßiger Regen (WW 63). Von 03:05 Uhr - 03:19 Uhr; Gegen 09:30 Uhr; 11:10 Uhr - 12:59 Uhr leichter Regen (WW 61). Von 06:20 Uhr - 06:44 Uhr leichter Sprühregen (WW 51). Mäßig schwül."]
["2016-07-18",19.3,23.4,16.7,null,null,2.8,1019.7,19.399999999999999]
["2016-07-19",20.6,26.4,15.1,null,null,6,1020.9,19.5,"HM",null,"Mäßig schwül."]
["2016-07-20",21.2,27.7,13.3,null,null,13,1018.2,19.600000000000001,null,null,"Mäßig schwül."]
["2016-07-21",19.899999999999999,24.7,15.8,1.9,null,1.1000000000000001,1014.7,19.649999999999999,"HFa",null,"Von 12:30 Uhr - 12:49 Uhr; 13:10 Uhr - 13:49 Uhr leichter Regenschauer (WW 80). Von 13:50 Uhr - 17:39 Uhr; 18:50 Uhr - 19:09 Uhr leichter Regen (WW 61).",null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2016-07-22",22.1,29.1,15.1,null,null,11.7,1015.9,19.7,null,null,"Stark schwül."]
["2016-07-23",21.6,29.5,15.1,19.8,null,6.3,1016.6,19.75,"HFz",null,"Von 18:40 Uhr - 19:59 Uhr; 22:40 Uhr - 22:49 Uhr leichter Regenschauer (WW 80). Von 20:00 Uhr - 20:49 Uhr mäßiger Regen (WW 63). Von 20:50 Uhr - 21:29 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2016-07-24",20.8,25.6,18.100000000000001,null,null,1.5,1018.1,19.8,null,null,"Von 02:30 Uhr - 02:39 Uhr starker Regenschauer (WW 81). Von 02:10 Uhr - 02:29 Uhr; 02:40 Uhr - 03:19 Uhr mäßiger Regenschauer (WW 81). Von 00:50 Uhr - 01:09 Uhr; 03:20 Uhr - 04:09 Uhr; 04:50 Uhr - 05:29 Uhr leichter Regenschauer (WW 80).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2016-07-25",22.4,28.9,15.8,null,null,12.7,1017.2,19.8,"Wz","T Xaveria","Morgens Elbtalnebel (WW 40).",null,null,"Stark schwül."]
["2016-07-26",21.6,26.3,17.5,0.3,null,2.4,1018.3,19.75,null,null,"Stark schwül."]
["2016-07-27",20.5,28.3,15.9,1.1000000000000001,null,1.7,1015.9,19.75,null,null,"Von 14:48 Uhr - 15:39 Uhr; 17:35 Uhr - 18:34 Uhr leichter Regenschauer (WW 80). Von 06:10 Uhr - 06:39 Uhr; 09:55 Uhr - 10:11 Uhr; 10:37 Uhr - 11:09 Uhr leichter Regen (WW 61). Von 13:14 Uhr - 13:49 Uhr Ferngewitter (WW 17).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extrem schwül."]
["2016-07-28",20.7,26.3,15.7,null,null,3.8,1015.5,19.7,null,"T Arvenn","Mäßig schwül."]
["2016-07-29",21.7,26.1,18.3,0.4,null,4.9000000000000004,1012.7,19.7,null,null,"Von 10:44 Uhr - 10:55 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2016-07-30",21.5,27.6,16.899999999999999,null,null,5.2,1012.4,19.649999999999999,null,null,"Von 01:10 Uhr - 01:49 Uhr leichter Regenschauer (WW 80). Mäßig schwül."]
["2016-07-31",18.899999999999999,24.7,15.5,7,null,0.3,1011.3,19.649999999999999,null,null,"Von 13:00 Uhr - 13:19 Uhr; 14:40 Uhr - 14:49 Uhr leichtes Gewitter mit Regen (WW 95). Von 13:20 Uhr - 13:29 Uhr; 14:50 Uhr - 15:29 Uhr; 16:05 Uhr - 16:39 Uhr; 22:15 Uhr - 22:39 Uhr; 23:10 Uhr - 23:19 Uhr mäßiger Regenschauer (WW 81). Von 13:30 Uhr - 14:39 Uhr; 15:30 Uhr - 15:47 Uhr; 22:40 Uhr - 23:09 Uhr; Um 23:40 Uhr leichter Regenschauer (WW 80). Abends Elbtalnebel (WW 40). Von 12:52 Uhr - 12:59 Uhr Ferngewitter (WW 17). Von 20:15 Uhr - Uhr Wetterleuchten (WW 13).",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."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":19.506451612903231},{"$f":"AVERAGE(C2:C32)","v":25.264516129032256},{"$f":"AVERAGE(D2:D32)","v":14.509677419354841},"-",null,{"$f":"AVERAGE(G2:G32)","v":5.49},{"$f":"AVERAGE(H2:H32)","v":1016.3064516129033},{"$f":"AVERAGE(I2:I32)","v":19.029032258064515}]
["Mittel",19,null,null,85,"-",222,1015.7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]