{"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,70,1013.8,16,6,null,"00",1,73,1021.7,13.5,7]
["01",1,76,1014.1,16.100000000000001,6,null,"01",2,74,1022,13.2,6]
["02",1,81,1014,15.6,3,null,"02",2,73,1022.5,12.3,5]
["03",1,82,1014.3,16.100000000000001,2,null,"03",2,76,1023,11.7,4]
["04",1,85,1014.4,16,6,null,"04",2,77,1023.4,10.8,2]
["05",1,82,1014.4,16.5,6,null,"05",1,83,1024,10.9,1]
["06",1,84,1014.8,16.600000000000001,7,null,"06",1,85,1024.7,11,1]
["07",1,85,1015.2,17.3,7,null,"07",1,81,1025.0999999999999,11.9,2]
["08",1,83,1015.8,17.5,7,null,"08",2,75,1025.7,11.8,3]
["09",1,74,1016,16.5,6,null,"09",2,72,1026.0999999999999,11.9,5]
["10",1,68,1016.1,16,4,null,"10",1,68,1026.5999999999999,12.5,4]
["11",3,54,1016.3,14.3,6,null,"11",1,61,1026.5,10.6,3]
["12",2,54,1016.2,14.6,7,null,"12",1,54,1026.4000000000001,11.2,4]
["13",2,55,1016.1,14.8,6,null,"13",1,49,1026,9.6,3]
["14",2,51,1016,14.1,5,null,"14",1,46,1025.5999999999999,9.4,5]
[15,3,49,1015.7,13.8,6,null,"15",1,48,1025.4000000000001,9.9,4]
["16",3,48,1016.1,13,5,null,"16",1,49,1024.9000000000001,9.6,1]
["17",2,56,1016.7,13.9,5,null,"17",1,51,1024.7,9.6999999999999993,1]
["18",2,60,1017.2,13.8,6,null,"18",0,58,1024.5999999999999,10.199999999999999,1]
["19",1,61,1018,13.4,5,null,"19",0,61,1024.7,9.9,1]
["20",1,66,1018.9,14,6,null,"20",1,69,1025.3,9.8000000000000007,0]
["21",1,68,1019.6,14,6,null,"21",1,76,1025.5,9.5,0]
["22",1,71,1020.4,13.9,6,null,"22",1,80,1025.5999999999999,9.1999999999999993,0]
["23",1,70,1021.3,13.5,7,null,"23",1,85,1025.7,9.1,0]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":68},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1016.3},{"$f":"AVERAGE(E3:E26)","v":15.054166666666667},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":5.7},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1.2},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":67.7},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1024.8},{"$f":"AVERAGE(L3:L26)","v":10.799999999999999},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":2.6}]
[]
[null,null,null,null,"2016-08-29",null,null,null,null,null,null,"2016-08-30"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,87,1025.5,8.8000000000000007,0,null,"00",0,87,1017.1,14.5,0]
["01",0,89,1025.4000000000001,8.4,0,null,"01",0,84,1016.6,13.7,0]
["02",0,89,1025.4000000000001,8.4,0,null,"02",0,86,1016.1,13.6,0]
["03",0,89,1025.4000000000001,8.1,0,null,"03",0,87,1016.2,13.3,0]
["04",0,92,1025,7.8,0,null,"04",0,89,1015.9,13.4,0]
["05",0,92,1025,7.7,0,null,"05",1,90,1015.8,13.9,0]
["06",0,92,1025,8.4,0,null,"06",1,90,1015.8,14.6,0]
["07",1,86,1024.7,10.1,0,null,"07",1,85,1015.8,16.399999999999999,1]
["08",1,80,1024.4000000000001,12.1,0,null,"08",1,80,1015.6,18.399999999999999,1]
["09",2,69,1024.0999999999999,13.2,0,null,"09",2,64,1015.1,19.2,1]
["10",3,54,1024,11.5,0,null,"10",3,57,1014.8,19.5,2]
["11",3,51,1023.8,11.5,0,null,"11",2,49,1014.2,18.5,3]
["12",2,49,1023.6,12.2,0,null,"12",2,50,1013.9,19,4]
["13",2,48,1022.9,11.8,0,null,"13",3,48,1013.5,19.3,5]
["14",2,40,1022.3,9.9,0,null,"14",2,47,1013.1,19.100000000000001,4]
["15",2,41,1021.7,10.4,0,null,"15",2,48,1012.6,19.399999999999999,3]
["16",1,42,1021.2,10.6,0,null,"16",3,49,1012.2,18.7,4]
["17",2,42,1020.7,9.4,0,null,"17",2,51,1011.8,18.600000000000001,4]
["18",1,47,1020.4,9.9,0,null,"18",2,53,1011.4,17.899999999999999,3]
["19",1,55,1020.5,9.8000000000000007,0,null,"19",2,58,1011.4,17.899999999999999,5]
["20",0,66,1020.7,10,0,null,"20",2,60,1011.5,17.8,6]
["21",0,69,1020.5,9.6999999999999993,0,null,"21",1,65,1012.3,17.5,7]
["22",0,70,1020.5,9,0,null,"22",2,57,1013.6,16.3,7]
["23",0,75,1020.6,9.1999999999999993,0,null,"23",1,67,1013.6,16.399999999999999,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":67.3},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1023.1},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":9.9},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":0},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.5},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":66.7},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1014.2},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":17},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":2.8}]
[]
[null,null,null,null,"2016-08-31",null,null,null,null,null,null,"2015-08-28"]

{"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,"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.",17.100000000000001,22.3,11.9,"-",46,78,5.2,0,"R",null,5.2,1017.4,12.8,2,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.",15.9,21,10.8,8.6,61,83,6.1,0.5,"R",null,1.5,1017,12.9,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":3},{"$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":1},{"$f":"COUNTIF(I6:I15,\">=20\")","v":1}]
["03.",18.899999999999999,22.3,15.1,13,75,88,7.1,1,"R",null,0.1,1014,16.899999999999999,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":3},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":3},{"$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.",22.3,29.3,15.7,13.6,48,77,6.4,28.9,"R",null,4.5999999999999996,1011.9,17.5,1,null,null,1,null,null,null,4,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":1},{"$f":"COUNTIF(I30:I40,\">=3\")","v":0},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",16.3,19.2,14.1,"-",81,93,7.7,4.9000000000000004,"R",null,0.1,1015.2,15.2,1,null,null,1,1,null,null,5]
["06.",17.8,22.1,13.9,12.1,59,80,5.8,".",null,null,4,1023.4,14.1,2,null,null,null,null,null,null,5,null,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",18.7,25.3,12.2,10.199999999999999,39,71,3.8,".",null,null,7.9,1025.8,12.8,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":4},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":1}]
["08.",22.2,29,15.6,12.2,45,66,3.2,0.4,"R",null,8.9,1018.3,15.1,2,null,null,1,null,null,null,5,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":1},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":1}]
["09.",16.2,19.899999999999999,14.4,12,74,83,6.9,1.1000000000000001,"R",null,0.7,1018.4,13.4,1,null,null,1,null,null,null,3,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":2}]
["10.",12.3,15.3,9.1,"-",72,84,6.4,0.4,"R",null,0.7,1019.3,9.6999999999999993,1,null,null,1,null,null,null,4]
["Su",{"$f":"SUM(B6:B15)","v":177.7},{"$f":"SUM(C6:C15)","v":225.70000000000002},{"$f":"SUM(D6:D15)","v":132.80000000000001},{"$f":"SUM(E6:E15)","v":81.7},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":37.199999999999996},"XX",null,{"$f":"SUM(L6:L15)","v":33.700000000000003},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":7},{"$f":"SUM(S6:S15)","v":1},{"$f":"SUM(T6:T15)","v":0},{"$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":17.77},{"$f":"AVERAGE(C6:C15)","v":22.57},13.280000000000001,11.671428571428573,"XXX",80.3,5.8599999999999994,"XXX","XX",null,{"$f":"L16/10","v":3.37},{"$f":"AVERAGE(M6:M15)","v":1018.0699999999999},{"$f":"AVERAGE(N6:N15)","v":14.039999999999997},{"$f":"AVERAGE(O6:O15)","v":1.3},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4.4000000000000004},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":4},{"$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.3,18.7,7.7,5.4,44,72,4,".",null,null,6.8,1022.5,8,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":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.3,18.2,11.8,10.1,72,85,7.8,1.8,"R",null,".",1022.4,12.7,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":0},{"$f":"COUNTIF(L30:L40,\"<1\")","v":0},{"$f":"COUNTIF(L30:L40,\">=10\")","v":5},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":0},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",21.1,26.4,16.8,15,51,76,5.4,".",null,null,5.2,1021.5,16.2,2,null,null,null,null,null,null,4]
["14.",18.8,23.2,13.6,"-",59,76,5,".",null,null,1,1021.6,14.5,2,null,null,null,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",16.7,22.6,11.3,9.6,56,77,4.0999999999999996,".",null,null,7.2,1022.6,12.4,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":24.2},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":32.1},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":5.2},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":28.9}]
["16.",15.5,21.1,9.1,7.3,52,75,4.3,".",null,null,5.6,1018.6,10.8,1,null,null,null,null,null,null,4,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",13.9,18.7,9.3000000000000007,"-",60,83,5.2,".",null,null,1.9,1015.4,11,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":12.3},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":7.1},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":38},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",15.5,23.5,7.1,5.2,47,74,1,".",null,null,11.3,1011,10.199999999999999,1,null,null,null,null,null,null,3]
["19.",18.399999999999999,27.3,9.8000000000000007,6.9,39,67,1.9,0.2,"R",null,8.4,1011.1,11.4,1,null,null,1,null,null,null,3]
["20.",20.3,27.4,13.4,11.1,51,73,6.3,5.7,"R",null,4.3,1013.4,15.1,1,null,null,1,null,null,null,4]
["Su",{"$f":"SUM(B18:B27)","v":168.80000000000004},{"$f":"SUM(C18:C27)","v":227.1},{"$f":"SUM(D18:D27)","v":109.89999999999999},{"$f":"SUM(E18:E27)","v":70.599999999999994},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":7.7},"XX",null,{"$f":"SUM(L18:L27)","v":51.699999999999996},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":3},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":0},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":16.880000000000003},{"$f":"AVERAGE(C18:C27)","v":22.71},10.989999999999998,8.8249999999999993,53.1,75.8,4.5,"XXX","XX",null,{"$f":"L28/10","v":5.17},{"$f":"AVERAGE(M18:M27)","v":1018.01},{"$f":"AVERAGE(N18:N27)","v":12.23},{"$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.7}]
["21.",17.899999999999999,23.2,13.7,"-",52,82,5.3,1.4,"R",null,3.3,1017.4,14.6,1,null,null,1,1,null,null,5]
["22.",17.600000000000001,22.7,13.1,10.7,57,76,4.8,0.1,"R",null,2.2999999999999998,1024.9000000000001,13.2,1,null,null,1,null,null,null,4]
["23.",20.399999999999999,26.2,15.1,13.2,51,74,5.5,".",null,null,5.5,1026.9000000000001,15.3,1,null,null,null,null,null,null,4]
["24.",20.3,27.5,13.5,11.8,49,77,0.5,".",null,null,10.8,1025.4000000000001,15.9,1,null,null,null,null,null,null,3]
["25.",20.8,28.2,13.6,10.1,46,71,0,".",null,null,11,1021.8,14.9,1,null,null,null,null,null,null,4]
["26.",22.8,29.3,16.7,13.9,42,61,0,".",null,null,11,1018.5,14.7,2,null,null,null,null,1,null,6]
["27.",22.9,31.1,15.2,11.3,40,66,0,".",null,null,10.8,1018.5,15.7,1,null,null,null,null,null,null,4]
["28.",24.2,32.1,14.8,10.7,44,67,2.8,0.1,"R",null,9.6999999999999993,1014.2,17,2,null,null,1,1,1,null,6]
["29.",21.4,25.6,18.3,13.1,43,68,5.7,".",null,null,2.9,1016.3,15.1,2,null,null,null,null,1,null,6]
["30.",16.8,21.7,10.8,10.1,45,68,2.6,".",null,null,9.3000000000000007,1024.8,10.8,1,null,null,null,null,null,null,4]
["31.",16.8,24.8,8.8000000000000007,5.3,38,67,0,".",null,null,10.7,1023.1,9.9,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B30:B40)","v":221.9},{"$f":"SUM(C30:C40)","v":292.39999999999998},{"$f":"SUM(D30:D40)","v":153.60000000000002},{"$f":"SUM(E30:E40)","v":110.19999999999999},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":1.6},"XX",null,{"$f":"SUM(L30:L40)","v":87.300000000000011},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":3},{"$f":"SUM(S30:S40)","v":2},{"$f":"SUM(T30:T40)","v":3},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":20.172727272727272},{"$f":"AVERAGE(C30:C40)","v":26.581818181818178},{"$f":"AVERAGE(D30:D40)","v":13.963636363636367},{"$f":"AVERAGE(E30:E40)","v":11.02},"XXX",{"$f":"AVERAGE(G30:G40)","v":70.63636363636364},{"$f":"AVERAGE(H30:H40)","v":2.4727272727272731},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1021.0727272727272},{"$f":"AVERAGE(N30:N40)","v":14.281818181818183},{"$f":"AVERAGE(O30:O40)","v":1.2727272727272727},{"$f":"ROUND(AVERAGE(P30:P40),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4.5454545454545459}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":568.4},{"$f":"SUM(C16+C28+C41)","v":745.2},{"$f":"SUM(D16+D28+D41)","v":396.3},{"$f":"SUM(E16+E28+E41)","v":262.5},"XXX","XXX,",{"$f":"SUM(H16+H28+H41)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I16+I28+I41)","v":46.5},"XX",null,{"$f":"SUM(L16+L28+L41)","v":172.70000000000002},"XXX","XXX","XXX",{"$f":"SUM(P16+P28+P41)","v":{"$error":"#VALUE!"}},"X",{"$f":"SUM(R16+R28+R41)","v":13},{"$f":"SUM(S16+S28+S41)","v":3},{"$f":"SUM(T16+T28+T41)","v":3},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":18.335483870967739},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":24.038709677419355},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":12.78387096774194},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":10.5},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":75.41935483870968},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":4.2193548387096769},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1019.1161290322582},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":13.541935483870967},{"$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.2151515151515158},3]
[]
[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",18.600000000000001,"XXXX",{"$f":"SUM(B44-B48)","v":-0.26451612903226263},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":2},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":4}]
["RRR",84,{"$f":"SUM(I43*100/B49)","v":55.357142857142854},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":13},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":3},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":6}]
["sss",211,{"$f":"SUM(L43*100/B50)","v":81.848341232227483},"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.",449,{"$f":"SUM(L43*100/B52)","v":38.463251670378618},"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":5},">/= 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":4}]
[]
[]
[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:",2016]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","-","-","-",1,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,"-","-",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,1,"-",null,null,null,null,null," "," "," "," ",0]
["08.","-",{"$f":"IF(R16=1,1,\"-\")","v":"-"},"-","-",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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-",1,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,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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,1,"-"]
["30.","-","-","-","-",1,1,"-"]
["31.","-","-","-","-",1,1,1]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,3,9,31,17,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":17}]

{"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 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-08-28"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":18.335483870967739},{"$f":"Kurztabelle!B48","v":18.600000000000001},{"$f":"C7-D7","v":-0.26451612903226263},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":7.1},"am","2016-08-11"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":46.5},{"$f":"Kurztabelle!B49","v":84},{"$f":"100/D9*C9","v":55.357142857142854},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":172.70000000000002},{"$f":"Kurztabelle!B50","v":211},{"$f":"100/D10*C10","v":81.848341232227497},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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 & Aug 80 %; Mai - Jul 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":28,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2015-08-01",17.100000000000001,22.3,11.9,null,null,5.2,1017.4,19.649999999999999,"(Wz)","H Carl","Gegen 10:00 Uhr Regentropfen (WW 60). Leicht schwül."]
["2015-08-02",15.9,21,10.8,0.5,null,1.5,1017,19.649999999999999,null,null,"Von 11:25 Uhr - 11:59 Uhr mäßiger Regen (WW 63). Von 08:50 Uhr - 09:29 Uhr; 11:00 Uhr - 11:09 Uhr; 12:00 Uhr - 12:19 Uhr leichter Regen (WW 61). Leicht schwül."]
["2015-08-03",18.899999999999999,22.3,15.1,1,null,0.1,1014,19.600000000000001,null,null,"Von 14:55 Uhr - 15:14 Uhr mäßiger Regen (WW 63). Von 13:10 Uhr - 13:44 Uhr; 14:45 Uhr - 14:54 Uhr; Um 16:30 Uhr; 17:20 Uhr - 17:49 Uhr leichter Regen (WW 61). Um 18:20 Uhr mäßiger Sprühregen (WW 53).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2015-08-04",22.3,29.3,15.7,28.9,null,4.5999999999999996,1011.9,19.600000000000001,"SWz","T Christiane"]
["2015-08-05",16.3,19.2,14.1,4.9000000000000004,null,0.1,1015.2,19.55,"Wz","T Dagmar","Von 03:30 Uhr - 04:39 Uhr leichtes Gewitter mit Regen (WW 95). Von 02:20 Uhr - 04:09 Uhr; 04:40 Uhr - 05:09 Uhr mäßiger Regenschauer (WW 81). Von 05:10 Uhr - 11:39 Uhr mäßiger Regen (WW 63). Von 11:40 Uhr - 11:49 Uhr; 13:50 Uhr - leichter Regen (WW 61). Leicht schwül."]
["2015-08-06",17.8,22.1,13.9,null,null,4,1023.4,19.5,"Wa","H Daniel"]
["2015-08-07",18.7,25.3,12.2,null,null,7.9,1025.8,19.45]
["2015-08-08",22.2,29,15.6,0.4,null,8.9,1018.3,19.399999999999999]
["2015-08-09",16.2,19.899999999999999,14.4,1.1000000000000001,null,0.7,1018.4,19.350000000000001,"Wz","T Ella","Von 06:30 Uhr - 06:49 Uhr; 10:00 Uhr - 11:39 Uhr mäßiger Regen (WW 63). Von 06:50 Uhr - 07:19 Uhr; 07:40 Uhr - 08:04 Uhr; 08:35 Uhr - 08:54 Uhr; 11:55 Uhr - 12:19 Uhr leichter Regen (WW 61). Von 06:20 Uhr - 06:29 Uhr Regentropfen (WW 60)."]
["2015-08-10",12.3,15.3,9.1,0.4,null,0.7,1019.3,19.25,"NWz",null,"07:01 Uhr; Gegen 09:10 Uhr; 10:25 Uhr; 11:30 Uhr - 13:09 Uhr leichter Regen (WW 61)."]
["2015-08-11",13.3,18.7,7.7,null,null,6.8,1022.5,19.2,"NWa","H Egbert","Morgens Elbtalnebel (WW 40)."]
["2015-08-12",15.3,18.2,11.8,1.8,null,null,1022.4,19.149999999999999,"Wa",null,"Von 21:50 Uhr - 22:19 Uhr; 22:35 Uhr - 23:09 Uhr; 23:10 Uhr - 23:19 Uhr; 23:55 Uhr - 23:59 Uhr mäßiger Regen (WW 63). Zwischen 16:00 Uhr und 20:59 Uhr starker Sprühregen (WW 55). Von 11:10 Uhr - 11:29 Uhr; 12:45 Uhr - 12:49 Uhr mäßiger Sprühregen (WW 53). Von 11:00 Uhr - 11:09 Uhr; 11:30 Uhr - 11:54 Uhr leichter Sprühregen (WW 51). Leicht schwül."]
["2015-08-13",21.1,26.4,16.8,null,null,5.2,1021.5,19.100000000000001,null,null,"Von 00:00 Uhr - 00:14 Uhr; 02:40 Uhr - 02:54 Uhr mäßiger Regen (WW 63). Mäßig schwül."]
["2015-08-14",18.8,23.2,13.6,null,null,1,1021.6,19,"U"]
["2015-08-15",16.7,22.6,11.3,null,null,7.2,1022.6,18.899999999999999]
["2015-08-16",15.5,21.1,9.1,null,null,5.6,1018.6,18.8,"HNz","T Greta"]
["2015-08-17",13.9,18.7,9.3000000000000007,null,null,1.9,1015.4,18.7]
["2015-08-18",15.5,23.5,7.1,null,null,11.3,1011,18.600000000000001,"TB","T Hildegund","Morgens Elbtalnebel (WW 40)."]
["2015-08-19",18.399999999999999,27.3,9.8000000000000007,0.2,null,8.4,1011.1,18.45]
["2015-08-20",20.3,27.4,13.4,5.7,null,4.3,1013.4,18.350000000000001,null,null,"Von 07:10 Uhr - 07:59 Uhr mäßiger Regen (WW 63). Von 05:10 Uhr - 06:09 Uhr; 06:30 Uhr - 07:09 Uhr; 08:00 Uhr - 08:24 Uhr leichter Regen (WW 61). Stark schwül."]
["2015-08-21",17.899999999999999,23.2,13.7,1.4,null,3.3,1017.4,18.2,"Ww",null,"Von 12:56 Uhr - 13:10 Uhr leichtes Gewitter mit Regen (WW 95). Von 00:50 Uhr - 03:09 Uhr; 04:30 Uhr - 05:09 Uhr; 06:20 Uhr - 06:49 Uhr mäßiger Regen (WW 63). Von 00:10 Uhr - 00:49 Uhr; 03:10 Uhr - 04:29 Uhr; 05:10 Uhr - 06:19 Uhr leichter Regen (WW 61). Von 13:11 Uhr - 13:24 Uhr Ferngewitter (WW 17)."]
["2015-08-22",17.600000000000001,22.7,13.1,0.1,null,2.2999999999999998,1024.9000000000001,18.05,"Wa","H Gerd"]
["2015-08-23",20.399999999999999,26.2,15.1,null,null,5.5,1026.9000000000001,17.899999999999999,"HM",null,"Gegen 05:00 Uhr leichter Regen (WW 61). Leicht schwül."]
["2015-08-24",20.3,27.5,13.5,null,null,10.8,1025.4000000000001,17.75,null,null,"Mäßig schwül."]
["2015-08-25",20.8,28.2,13.6,null,null,11,1021.8,17.600000000000001,"SWa",null,"Mäßig schwül."]
["2015-08-26",22.8,29.3,16.7,null,null,11,1018.5,17.45,"SEa",null,"Leicht schwül."]
["2015-08-27",22.9,31.1,15.2,null,null,10.8,1018.5,17.3,null,null,"Mäßig schwül."]
["2015-08-28",24.2,32.1,14.8,0.1,null,9.6999999999999993,1014.2,17.149999999999999,"SWz","T Kitty","Um 21:30 Uhr leichter Regenschauer (WW 80). Von 21:40 Uhr - 21:59 Uhr Ferngewitter (WW 17). Von 21:20 Uhr - 21:39 Uhr; 22:00 Uhr - 22:49 Uhr Wetterleuchten (WW 13).",null,null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2015-08-29",21.4,25.6,18.3,null,null,2.9,1016.3,17,"U",null,"Von 02:40 Uhr - 02:54 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2015-08-30",16.8,21.7,10.8,null,null,9.3000000000000007,1024.8,16.850000000000001,"Wa","H Harald"]
["2015-08-31",16.8,24.8,8.8000000000000007,null,null,10.7,1023.1,16.7]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":18.335483870967739},{"$f":"AVERAGE(C2:C32)","v":24.038709677419355},{"$f":"AVERAGE(D2:D32)","v":12.78387096774194},"-",null,{"$f":"AVERAGE(G2:G32)","v":5.7566666666666668},{"$f":"AVERAGE(H2:H32)","v":1019.1161290322582},{"$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]