{"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,93,1014.7,13.5,1,null,"00",2,82,1013.1,13.4,7]
["01",0,94,1014.1,13.3,3,null,"01",1,83,1013.1,12.9,6]
["02",1,96,1013.2,13.5,7,null,"02",0,87,1013,12.8,4]
["03",0,93,1012.7,14.2,7,null,"03",0,89,1013.1,12.5,3]
["04",2,93,1012.2,14.6,7,null,"04",0,86,1012.9,13.2,5]
["05",2,93,1012.9,14.8,7,null,"05",0,92,1013.2,14.1,6]
["06",0,97,1013.2,15,8,null,"06",0,91,1013.2,15,6]
["07",1,98,1012.8,15.7,8,null,"07",1,86,1013.1,16.5,7]
["08",1,95,1013,16.8,8,null,"08",2,79,1013.2,16.2,7]
["09",0,92,1012.7,18.8,6,null,"09",2,77,1013.7,16.2,8]
["10",1,78,1012.7,17.8,5,null,"10",1,83,1013.9,18.5,7]
["11",2,61,1013,15.4,6,null,"11",1,74,1014,18.100000000000001,7]
["12",2,65,1013.1,16.3,6,null,"12",2,69,1014.5,16.7,8]
["13",3,53,1012.9,15.2,5,null,"13",1,65,1014.5,15.3,8]
["14",3,53,1012.6,15.5,5,null,"14",2,79,1014.4,17.3,8]
[15,3,52,1012.3,14.6,4,null,"15",2,72,1014.1,17.2,7]
["16",2,51,1012,14.9,4,null,"16",2,76,1013.7,18.600000000000001,6]
["17",2,52,1011.7,15.2,5,null,"17",1,76,1013.7,19,6]
["18",2,51,1011.7,14,5,null,"18",0,76,1013.7,18.399999999999999,7]
["19",2,54,1012,14,6,null,"19",1,75,1014.2,17.2,6]
["20",2,61,1012.3,14,7,null,"20",0,82,1014.6,16.8,4]
["21",2,64,1012.9,13.5,7,null,"21",1,88,1015.2,15.7,4]
["22",1,70,1013.1,13.2,7,null,"22",0,92,1015.2,15.7,1]
["23",2,78,1013.1,13.6,7,null,"23",1,94,1015.4,15.3,1]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":74.5},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1012.8},{"$f":"AVERAGE(E3:E26)","v":14.891666666666667},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":5.9},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":81.400000000000006},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1013.9},{"$f":"AVERAGE(L3:L26)","v":15.941666666666665},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":5.8}]
[]
[null,null,null,null,"2016-06-29",null,null,null,null,null,null,"2016-06-30"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,89,1017.5,14.5,7,null,"00",3,76,1018.4,11,1]
["01",1,93,1017.4,14.8,7,null,"01",2,77,1018.3,11.2,2]
["02",0,90,1017.1,14.5,6,null,"02",0,84,1018.3,11.7,1]
["03",1,91,1017.4,13.9,7,null,"03",1,83,1018,12.2,7]
["04",1,87,1017.8,13.1,6,null,"04",0,86,1018.1,12.9,7]
["05",1,79,1018.1,12.2,8,null,"05",1,96,1018.1,14.1,8]
["06",0,83,1018.3,13.4,7,null,"06",1,97,1018,14.4,6]
["07",1,83,1018.6,13.7,7,null,"07",0,93,1018,15.4,7]
["08",2,77,1019,12.7,7,null,"08",1,87,1017.9,16.100000000000001,6]
["09",1,74,1019.2,12.8,7,null,"09",1,80,1017.7,16.600000000000001,7]
["10",1,69,1019.3,12.4,6,null,"10",2,80,1017.8,16.3,7]
["11",1,66,1019.2,12.9,5,null,"11",2,77,1017.8,16.100000000000001,8]
["12",1,70,1018.7,14.3,5,null,"12",2,84,1018.3,16,8]
["13",1,60,1018.1,14.1,5,null,"13",1,81,1018.1,16.100000000000001,5]
["14",2,56,1017.5,13.6,4,null,"14",1,71,1017.4,15.9,5]
["15",2,51,1017.1,11.9,4,null,"15",1,70,1017,16.399999999999999,5]
["16",2,54,1017.3,12.3,4,null,"16",1,70,1016.4,15.8,5]
["17",2,54,1017,12.7,4,null,"17",0,66,1016.2,14.7,6]
["18",1,58,1017.1,12.8,5,null,"18",0,68,1015.8,14.5,6]
["19",1,69,1017.3,13,6,null,"19",1,72,1015.8,15.2,4]
["20",1,73,1017.5,12.9,5,null,"20",1,77,1016,15.4,6]
["21",2,78,1017.7,12.9,6,null,"21",2,84,1015.8,14.8,6]
["22",3,76,1018.1,11.9,6,null,"22",2,86,1015.6,14,6]
["23",2,74,1018.3,10.9,1,null,"23",1,90,1014.9,13.7,1]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.3},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":73.099999999999994},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1017.9},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":13.1},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":5.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.1000000000000001},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":80.599999999999994},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1017.2},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":14.6},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":5.4}]
[]
[null,null,null,null,"2016-06-27",null,null,null,null,null,null,"2016-06-28"]

{"sheet":"Kurztabelle","index":1,"n_rows":112,"n_cols":35,"rows_kept":112,"cut":false,"hidden":false,"merged":[[1,12,1,13]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","Juni",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.3,23,13.7,"-",69,90,6.8,20,"R",null,2.4,1010.5,15.6,1,null,null,1,1,null,null,5,2,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.",17.5,22.9,13.3,11.9,65,89,6.5,4.9000000000000004,"R",null,4.9000000000000004,1010.4,15.5,1,null,null,1,1,null,null,4,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":2},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":4},{"$f":"COUNTIF(I6:I15,\">=1\")","v":4},{"$f":"COUNTIF(I6:I15,\">=3\")","v":3},{"$f":"COUNTIF(I6:I15,\">=10\")","v":1},{"$f":"COUNTIF(I6:I15,\">=20\")","v":1}]
["03.",16.8,20.399999999999999,14.5,14.4,85,96,7.1,4.9000000000000004,"R",null,0.3,1010.6,16.100000000000001,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":0},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":7},{"$f":"COUNTIF(I18:I27,\">=1\")","v":7},{"$f":"COUNTIF(I18:I27,\">=3\")","v":5},{"$f":"COUNTIF(I18:I27,\">=10\")","v":2},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",18.399999999999999,24.6,14.1,13.9,60,90,4.3,1.4,"R",null,5.7,1012.3,16.600000000000001,0,null,null,1,1,null,null,4,null,null,null,null,{"$f":"COUNTIF(C30:C39,\">=30\")","v":3},{"$f":"COUNTIF(C30:C39,\">=25\")","v":5},{"$f":"COUNTIF(C30:C39,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I39,\">=0,1\")","v":4},{"$f":"COUNTIF(I30:I39,\">=1\")","v":3},{"$f":"COUNTIF(I30:I39,\">=3\")","v":1},{"$f":"COUNTIF(I30:I39,\">=10\")","v":1},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",19.100000000000001,26.6,12.4,11.9,46,80,3.3,".",null,null,12,1015.5,15.2,1,null,null,null,1,null,null,5]
["06.",18,23.8,11.5,"-",49,76,1.6,".",null,null,11.9,1020,13.4,1,null,null,null,null,null,null,4,null,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",17.899999999999999,24.3,10,9.4,39,71,3.5,".",null,null,10.7,1022.2,12.1,1,null,null,null,null,null,null,3,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.",19.5,26.3,10.7,8.6999999999999993,37,68,2.5,".",null,null,13.3,1016.9,12.9,1,null,null,null,1,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":2},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",16.899999999999999,21.1,13.5,12.4,62,78,5.6,".",null,null,6.3,1015,12.9,2,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(D30:D39,\"<0\")","v":0},{"$f":"COUNTIF(D30:D39,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F39,\">=70\")","v":0},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":0}]
["10.",16.8,21.8,13,11.1,35,68,4.4000000000000004,".",null,null,7.6,1011.6,10.4,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B6:B15)","v":178.20000000000002},{"$f":"SUM(C6:C15)","v":234.80000000000004},{"$f":"SUM(D6:D15)","v":126.7},{"$f":"SUM(E6:E15)","v":93.7},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":31.199999999999996},"XX",null,{"$f":"SUM(L6:L15)","v":75.099999999999994},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":4},{"$f":"SUM(S6:S15)","v":5},{"$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.82},{"$f":"AVERAGE(C6:C15)","v":23.480000000000004},12.67,11.7125,"XXX",80.599999999999994,4.5600000000000005,"XXX","XX",null,{"$f":"L16/10","v":7.51},{"$f":"AVERAGE(M6:M15)","v":1014.5},{"$f":"AVERAGE(N6:N15)","v":14.070000000000002},{"$f":"AVERAGE(O6:O15)","v":1.1000000000000001},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4.3},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$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.",15.6,20.3,12.8,12.1,52,77,7.3,0,"R",null,0.7,1011.1,11.4,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",17.3,22.5,11.2,9.5,59,80,6.7,1.5,"R",null,4.5999999999999996,1008.6,13.5,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":0},{"$f":"COUNTIF(L30:L39,\"<1\")","v":0},{"$f":"COUNTIF(L30:L39,\">=10\")","v":2},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",16.2,21,13.8,13.5,73,92,7.4,1.9,"R",null,1.3,1002,14.8,1,null,null,1,1,null,null,4]
["14.",16.5,22.6,11.2,10,57,85,6.2,13.2,"R",null,3.7,1000.2,13.8,1,null,null,1,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",15.4,21,11.8,"-",67,91,5.8,6.8,"R",null,1.3,1001.1,13.9,1,null,null,1,1,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":25.8},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":32.6},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":8.3000000000000007},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":20}]
["16.",16.600000000000001,21.4,10.4,8.5,63,85,4.8,19.100000000000001,"R",null,5.6,1003.7,13.9,1,null,null,1,1,null,null,3,2,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",15.4,18.100000000000001,13.9,13.4,72,90,6.6,6.4,"R",null,1,1004.3,13.6,2,null,null,1,null,1,null,6,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":15.4},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":10},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":35},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",16.7,22.5,13,10.1,54,82,3.8,4.3,"R",null,9.1999999999999993,1015.5,13.4,2,null,null,1,1,null,null,5,2]
["19.",16.5,21.9,10.199999999999999,8.3000000000000007,56,82,5.2,0,"R",null,4.5,1020.6,13.3,1,null,null,null,null,null,null,3]
["20.",17.2,21.7,13.2,11.1,57,79,2.2000000000000002,".",null,null,5.7,1020.9,13.4,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B18:B27)","v":163.39999999999998},{"$f":"SUM(C18:C27)","v":213},{"$f":"SUM(D18:D27)","v":121.50000000000001},{"$f":"SUM(E18:E27)","v":96.499999999999986},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":53.199999999999996},"XX",null,{"$f":"SUM(L18:L27)","v":37.6},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":7},{"$f":"SUM(S18:S27)","v":4},{"$f":"SUM(T18:T27)","v":1},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":16.339999999999996},{"$f":"AVERAGE(C18:C27)","v":21.3},12.150000000000002,10.722222222222221,61,84.3,5.6,"XXX","XX",null,{"$f":"L28/10","v":3.7600000000000002},{"$f":"AVERAGE(M18:M27)","v":1008.8},{"$f":"AVERAGE(N18:N27)","v":13.5},{"$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.9}]
["21.",18.3,23.1,15.3,13,58,80,6.1,".",null,null,2.2000000000000002,1020.3,14.7,1,null,null,null,null,null,null,4]
["22.",20.399999999999999,26.1,13.8,12.1,61,81,4.8,0,"R",null,4.9000000000000004,1024,16.7,1,null,null,null,null,null,null,3]
["23.",23.7,30.5,15,13.1,46,73,0.3,".",null,null,15.2,1022.5,17.899999999999999,1,null,null,null,null,null,null,4]
["24.",25.8,32.6,17.100000000000001,14.3,42,68,0.3,".",null,null,15.1,1016.5,18.8,1,null,null,null,null,null,null,4]
["25.",22.6,31.2,18.8,"-",60,84,4.3,17.100000000000001,"R",null,5.5,1010.3,19.5,1,null,null,1,1,1,null,6,2]
["26.",18.600000000000001,23.1,14.6,"-",52,79,5.8,".",null,null,6.9,1016.2,14.7,2,null,null,null,null,null,null,5]
["27.",18.2,23.1,15.2,"-",47,73,5.6,1.7,"R",null,4.0999999999999996,1017.9,13.1,1,null,null,1,null,null,null,4]
["28.",18,22.2,14.2,"-",62,81,5.4,1.8,"R",null,3.7,1017.2,14.6,1,null,null,1,null,null,null,4]
["29.",20.3,26.4,13.9,"-",48,74,5.9,0,"R",null,7.3,1012.8,14.9,2,null,null,null,null,null,null,5]
["30.",19.3,23.9,14.3,"-",64,81,5.8,0.3,"R",null,3.9,1013.9,15.9,1,null,null,1,null,null,null,4]
["Su",{"$f":"SUM(B30:B39)","v":205.20000000000002},{"$f":"SUM(C30:C39)","v":262.2},{"$f":"SUM(D30:D39)","v":152.20000000000002},{"$f":"SUM(E30:E39)","v":52.5},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":20.900000000000002},"XX",null,{"$f":"SUM(L30:L39)","v":68.800000000000011},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":4},{"$f":"SUM(S30:S39)","v":1},{"$f":"SUM(T30:T39)","v":1},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":20.520000000000003},{"$f":"AVERAGE(C30:C39)","v":26.22},{"$f":"AVERAGE(D30:D39)","v":15.220000000000002},{"$f":"AVERAGE(E30:E39)","v":13.125},"XXX",{"$f":"AVERAGE(G30:G39)","v":77.400000000000006},{"$f":"AVERAGE(H30:H39)","v":4.43},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1017.1599999999999},{"$f":"AVERAGE(N30:N39)","v":16.080000000000002},{"$f":"AVERAGE(O30:O39)","v":1.2},{"$f":"AVERAGE(P30:P39)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":4.3}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":546.80000000000007},{"$f":"SUM(C16+C28+C40)","v":710},{"$f":"SUM(D16+D28+D40)","v":400.40000000000003},{"$f":"SUM(E16+E28+E40)","v":242.7},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I40)","v":105.3},"XX",null,{"$f":"SUM(L16+L28+L40)","v":181.5},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R40)","v":15},{"$f":"SUM(S16+S28+S40)","v":10},{"$f":"SUM(T16+T28+T40)","v":2},{"$f":"SUM(U16+U28+U40)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":18.226666666666667},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C39)","v":23.666666666666671},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D39)","v":13.346666666666668},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E39)","v":11.557142857142859},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G39)","v":80.766666666666666},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H39)","v":4.8633333333333333},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1013.4866666666669},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":14.55},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":1.1666666666666667},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P39),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":4.166666666666667}]
[]
[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":15},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":0}]
["TTT",16.7,"XXXX",{"$f":"SUM(B43-B47)","v":1.5266666666666673},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":3},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":14},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":2}]
["RRR",61,{"$f":"SUM(I42*100/B48)","v":172.62295081967213},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":7},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":9},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":6}]
["sss",202,{"$f":"SUM(L42*100/B49)","v":89.851485148514854},"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":1},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",493,{"$f":"SUM(L42*100/B51)","v":36.815415821501013},"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":3}]
[]
[]
[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":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Juni",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,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,1,1,null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-","-","-",1,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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-",{"$f":"IF(R22=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["19.","-","-","-","-",1,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,"-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-",1,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,1]
["Su.",{"$f":"SUM(B9:B38)","v":"00:00:00"},0,3,9,30,16,5]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39)","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)"]
[]
["Juni 2016"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":32.6},"am","2016-06-24"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":18.226666666666667},{"$f":"Kurztabelle!B47","v":16.7},{"$f":"C7-D7","v":1.5266666666666673},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":10},"am","2016-06-07"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":105.3},{"$f":"Kurztabelle!B48","v":61},{"$f":"100/D9*C9","v":172.62295081967213},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":181.5},{"$f":"Kurztabelle!B49","v":202},{"$f":"100/D10*C10","v":89.851485148514854},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":119,"n_cols":39,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2016-06-01",17.3,23,13.7,20,null,2.4,1010.5,15.85,"[TM]",null,"Von 14:00 Uhr - 14:39 Uhr; 19:56 Uhr - 22:09 Uhr leichtes Gewitter mit Regen (WW 95). Von 13:50 Uhr - 13:59 Uhr; 14:40 Uhr - 14:59 Uhr; 19:28 Uhr - 20:55 Uhr Ferngewitter (WW 17). Mäßig schwül."]
["2016-06-02",17.5,22.9,13.3,4.9000000000000004,null,4.9000000000000004,1010.4,15.95,null,null,"Von 05:20 Uhr - 05:59 Uhr mäßiger Regenschauer (WW 81). Von  03:50 Uhr - 05:19 Uhr; 06:00 Uhr - 07:19 Uhr; Um 14:10 Uhr; Um 21:10 Uhr; 21:40 Uhr - 21:59 Uhr leichter Regenschauer (WW 80). Gegen 17:20 Uhr Ferngewitter (WW 17). Mäßig schwül."]
["2016-06-03",16.8,20.399999999999999,14.5,4.9000000000000004,null,0.3,1010.6,16.05,null,null,"Von 02:20 Uhr - 03:19 Uhr; 15:50 Uhr - 15:59 Uhr mäßiger Regenschauer (WW 81). Von 03:20 Uhr - 05:09 Uhr; Um 11:05 Uhr; Um 12:30 Uhr; Um 13:40 Uhr; Von 14:05 Uhr - 14:31 Uhr; 14:58 Uhr - 15:19 Uhr; 15:35 Uhr - 15:49 Uhr; 16:00 Uhr - 16:49 Uhr; 20:10 Uhr - 20:49 Uhr leichter Regenschauer (WW 80). Von 00:30 Uhr - 02:19 Uhr leichter Regen (WW 61). "]
["2016-06-04",18.399999999999999,24.6,14.1,1.4,null,5.7,1012.3,16.149999999999999,"U","H Tobias","Von 14:00 Uhr - 14:29 Uhr leichtes Gewitter mit Regen (WW 95). Mäßig schwül."]
["2016-06-05",19.100000000000001,26.6,12.4,null,null,12,1015.5,16.25,"HNFa",null,"Von 15:24 Uhr - 17:39 Uhr mäßiges Ferngewitter (WW 17). Von 17:40 Uhr - 18:29 Uhr leichtes Ferngewitter (WW 17). Mäßig schwül."]
["2016-06-06",18,23.8,11.5,null,null,11.9,1020,16.350000000000001,null,null,"Mäßig schwül."]
["2016-06-07",17.899999999999999,24.3,10,null,null,10.7,1022.2,16.399999999999999,"HNa"]
["2016-06-08",19.5,26.3,10.7,null,null,13.3,1016.9,16.5,"U","T Gisela","Von 18:10 Uhr - 18:49 Uhr leichtes Ferngewitter (WW 17). Leicht schwül."]
["2016-06-09",16.899999999999999,21.1,13.5,null,null,6.3,1015,16.600000000000001]
["2016-06-10",16.8,21.8,13,null,null,7.6,1011.6,16.649999999999999,"NWz"]
["2016-06-11",15.6,20.3,12.8,null,null,0.7,1011.1,16.75,null,"T Helma","Von 14:10 Uhr - 15:09 Uhr; 16:00 Uhr - 16:49 Uhr leichter Regen (WW 61). Von 15:30 Uhr - 15:59 Uhr Regentropfen (WW 60)."]
["2016-06-12",17.3,22.5,11.2,1.5,null,4.5999999999999996,1008.6,16.7,"Wz",null,"Von 13:44 Uhr - 13:49 Uhr; 18:20 Uhr - 18:49 Uhr; 20:50 Uhr - 21:29 Uhr; 22:35 Uhr - 23:59 Uhr leichter Regen (WW 61). Gegen 19:20 Uhr; Von 20:25 Uhr - 20:49 Uhr Regentropfen (WW 60). Leicht schwül."]
["2016-06-13",16.2,21,13.8,1.9,null,1.3,1002,16.8,"TB","T Ines","Von 16:10 Uhr - 18:09 Uhr leichter Regenschauer (WW 80). Von 07:00 Uhr - 07:09 Uhr mäßiger Regen (WW 63). Von 00:00 Uhr - 00:59 Uhr; 01:50 Uhr  - 03:09 Uhr leichter Regen (WW 61). Von 01:00 Uhr - 01:20 Uhr Regentropfen (WW 60). Von 16:00 Uhr - 16:09 Uhr leichtes Trockengewitter (WW 17). Leicht schwül."]
["2016-06-14",16.5,22.6,11.2,13.2,null,3.7,1000.2,16.850000000000001,null,null,"Von 19:50 Uhr - 19:59 Uhr starker Regenschauer (WW 81). Von 20:00 Uhr - 21:39 Uhr mäßiger Regenschauer (WW 81). Gegen 19:30 Uhr Regentropfen (WW 60). Leicht schwül."]
["2016-06-15",15.4,21,11.8,6.8,null,1.3,1001.1,16.899999999999999,"TM","T Johanna","Von 01:50 Uhr - 02:59 Uhr; 04:00 Uhr - 04:39 Uhr leichter Regenschauer (WW 80). Von 07:50 Uhr - 07:59 Uhr starker Regen (WW 65). Von 07:00 Uhr - 07:49 Uhr; 08:00 Uhr - 10:29  Uhr mäßiger Regen (WW 63).  Von 10:30 Uhr - 11:09 Uhr leichter Regen (WW 61). Gegen 19:30 Uhr Ferngewitter (WW 17). Mäßig schwül."]
["2016-06-16",16.600000000000001,21.4,10.4,19.100000000000001,null,5.6,1003.7,17,null,null,"17:47 Uhr; Von 20:43 Uhr - 20:49 Uhr; 20:55 Uhr - 21:29 Uhr leichtes Gewitter mit Regen (WW 95). Von 17:40 Uhr - 17:46 Uhr; 17:48 Uhr - 17:49 Uhr starker Regenschauer (WW 81); 17:50 Uhr - 18:09 Uhr; 21:30 Uhr - 21:39 Uhr mäßiger Regenschauer. Von 17:15 Uhr - 17:39 Uhr; 18:10 Uhr - 18:29 Uhr; 21:40 Uhr - 22:14 Uhr leichter Regenschauer (WW 80). Von 23:10 Uhr - 23:59 Uhr leichter Regen (WW 61). Von 20:38 Uhr - 20:42 Uhr; 20:50 Uhr - 20:54 Uhr Trockengewitter (WW 17). Von 21:30 Uhr - 22:24 Uhr Wetterleuchten (WW 13). Leicht schwül."]
["2016-06-17",15.4,18.100000000000001,13.9,6.4,null,1,1004.3,17.05,null,null,"Von 05:00 Uhr - 05:09 Uhr; 07:20 Uhr - 07:39 Uhr starker Regen (WW 65). Von 00:00 Uhr - 00:59 Uhr; 03:10 Uhr - 03:29 Uhr; 04:10 Uhr - 04:59 Uhr; 05:10 Uhr - 06:19 Uhr; 07:00 Uhr - 07:19 Uhr; 07:40 Uhr - 07:49 Uhr; 09:10 Uhr - Uhr mäßiger Regen (WW 63). Von 07:50 Uhr - 09:09 Uhr leichter Regen (WW 61). Von 06:20 Uhr - 06:59 Uhr leichter Regen, unterbrochen (WW 60). Von 02:30 Uhr - 02:39 Uhr Regentropfen (WW 60). Leicht schwül."]
["2016-06-18",16.7,22.5,13,4.3,null,9.1999999999999993,1015.5,17.100000000000001,"TrM","T Karin","Von 11:39 Uhr - 11:54 Uhr mäßiges Gewitter mit Regen (WW 95). Von 16:07 Uhr - 16:12 Uhr; 16:23 Uhr - 16:55 Uhr; 17:27 Uhr - 17:32 Uhr leichtes Gewitter mit Regen (WW 95). Von 12:28 Uhr - 12:39 Uhr mäßiger Regenschauer (WW 81). Von 12:40 Uhr - 12:46 Uhr; 16:56 Uhr - 17:26 Uhr leichter Regenschauer (WW 80). Von 11:37 Uhr - 11:38 Uhr; 11:55 Uhr - 11:59 Uhr mäßiges Ferngewitter (WW 17). Von 12:00 Uhr - 12:25 Uhr; Um 14:00 Uhr; Von 15:10 Uhr - 15:59 Uhr; 16:13 Uhr - 16:22 Uhr leichtes Ferngewitter (WW 17). Leicht schwül."]
["2016-06-19",16.5,21.9,10.199999999999999,null,null,4.5,1020.6,17.149999999999999,null,null,"Gegen 15:00 Uhr Regentropfen (WW 60). Leicht schwül."]
["2016-06-20",17.2,21.7,13.2,null,null,5.7,1020.9,17.2,"Wa","H Wolfgang","Leicht schwül."]
["2016-06-21",18.3,23.1,15.3,null,null,2.2000000000000002,1020.3,17.25,"SWa",null,"Leicht schwül."]
["2016-06-22",20.399999999999999,26.1,13.8,null,null,4.9000000000000004,1024,17.3,null,null,"Gegen 15:00 Uhr Regentropfen (WW 60).",null,null,null,"Stark schwül."]
["2016-06-23",23.7,30.5,15,null,null,15.2,1022.5,17.350000000000001,"Sa",null,"Stark schwül."]
["2016-06-24",25.8,32.6,17.100000000000001,null,null,15.1,1016.5,17.399999999999999,null,null,"Extrem schwül."]
["2016-06-25",22.6,31.2,18.8,17.100000000000001,null,5.5,1010.3,17.45,"Sz ","T Marine","Von 14:50 Uhr - 15:24 Uhr; 21:47 Uhr - 22:19 Uhr; 23:30 Uhr - 23:59 Uhr leichtes/mäßiges Gewitter mit Regen (WW 95).Von 22:20 Uhr - 22:29 Uhr mäßiger Regenschauer (WW 81). Von 15:25 Uhr - 15:59 Uhr; 16:50 Uhr - 17:59 Uhr; 22:30 Uhr - 22:49 Uhr leichter Regenschauer (WW 80). Vor 14:00 Uhr Regentropfen (WW 60). Von 10:50 Uhr - 11:44 Uhr; 13:50 Uhr - 14:49 Uhr; 21:20 Uhr - 21:46 Uhr leichtes Ferngewitter (WW 17). Von 21:00 Uhr - 21:19 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,"Extrem schwül."]
["2016-06-26",18.600000000000001,23.1,14.6,null,null,6.9,1016.2,17.5,null,null,"Von 00:00 Uhr - 00:19 Uhr leichtes Gewitter mit Regen (WW 95). Von 00:20 Uhr - 01:09 Uhr mäßiger Regenschauer (WW 81). Von 02:10 Uhr - 02:19 Uhr; 03:05 Uhr - 03:59 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2016-06-27",18.2,23.1,15.2,1.7,null,4.0999999999999996,1017.9,17.55,"-","-"]
["2016-06-28",18,22.2,14.2,1.8,null,3.7,1017.2,17.600000000000001,"-","-","Leicht schwül."]
["2016-06-29",20.3,26.4,13.9,null,null,7.3,1012.8,17.649999999999999,"-","-","Mäßig schwül."]
["2016-06-30",19.3,23.9,14.3,0.3,null,3.9,1013.9,17.7,"-","-","Stark schwül."]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":18.226666666666667},{"$f":"AVERAGE(C2:C31)","v":23.666666666666671},{"$f":"AVERAGE(D2:D31)","v":13.346666666666668},"-",null,{"$f":"AVERAGE(G2:G31)","v":6.05},{"$f":"AVERAGE(H2:H31)","v":1013.4866666666669},{"$f":"AVERAGE(I2:I31)","v":16.899999999999999}]
["Mittel",16.7,null,null,61,"-",202,1015.6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]