{"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",2,65,1012.7,12,2,null,"00",1,94,1022.7,10.199999999999999,1]
["01",2,67,1012.9,12.4,1,null,"01",1,95,1022.7,10.1,0]
["02",3,69,1012.7,12.3,1,null,"02",1,96,1023,9.9,0]
["03",2,73,1012.4,12.4,2,null,"03",0,97,1023.2,9.5,0]
["04",2,74,1012.5,12.6,5,null,"04",1,98,1023.3,9.6,0]
["05",2,75,1012.4,12.7,7,null,"05",0,98,1023.5,9,1]
["06",2,75,1012.8,12.7,7,null,"06",0,98,1024,8.6,3]
["07",1,78,1013.8,13,7,null,"07",0,98,1024.7,8.8000000000000007,4]
["08",1,82,1014,13.5,7,null,"08",0,98,1025.0999999999999,10,7]
["09",1,78,1013.9,14.3,7,null,"09",1,97,1025.5999999999999,12.4,7]
["10",2,69,1013.6,14.9,7,null,"10",1,93,1025.8,13.7,8]
["11",2,64,1013.1,15.3,6,null,"11",1,89,1026,14.7,5]
["12",2,64,1012.7,15,7,null,"12",1,81,1026,14.9,3]
["13",3,54,1012.5,13.2,7,null,"13",1,74,1025.9000000000001,14.6,2]
["14",2,71,1012.5,16,7,null,"14",1,68,1025.8,13.9,2]
[15,2,75,1012.8,14.4,8,null,"15",1,67,1025.9000000000001,13,1]
["16",2,77,1014,13.2,8,null,"16",0,62,1025.9000000000001,11.7,1]
["17",2,80,1014.6,12.6,8,null,"17",0,67,1026.0999999999999,11.9,0]
["18",0,83,1014.7,12.7,8,null,"18",1,76,1026.5999999999999,11.7,1]
["19",0,85,1014.8,12.3,7,null,"19",1,82,1026.9000000000001,11.2,1]
["20",1,88,1014.5,11.9,8,null,"20",2,88,1027.0999999999999,10.9,0]
["21",1,88,1015,12.1,8,null,"21",0,90,1027.0999999999999,10.3,0]
["22",0,90,1015,12.3,7,null,"22",0,93,1027.0999999999999,9.6999999999999993,0]
["23",0,89,1014.7,11.9,7,null,"23",0,95,1027.2,9.6,0]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":75.5},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1013.5},{"$f":"AVERAGE(E3:E26)","v":13.154166666666667},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":6.2},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.6},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":87.3},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1025.3},{"$f":"AVERAGE(L3:L26)","v":11.245833333333335},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":2}]
[]
[null,null,null,null,"2016-09-30",null,null,null,null,null,null,"2016-09-27"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,95,1026.9000000000001,9.1,0,null,"00",3,70,1022.5,11.8,3]
["01",1,96,1026.8,9.1,0,null,"01",1,73,1022.5,11.6,4]
["02",0,96,1026.5999999999999,9.1,0,null,"02",3,72,1022,11.3,6]
["03",0,96,1026.2,9.1999999999999993,0,null,"03",3,71,1021.4,11.3,4]
["04",0,96,1026,8.5,0,null,"04",2,70,1021.4,10.9,3]
["05",0,97,1025.5999999999999,9.3000000000000007,1,null,"05",1,66,1021,10.3,4]
["06",1,96,1025.5999999999999,9.6,6,null,"06",0,70,1020.8,10.5,7]
["07",0,96,1025.3,9.8000000000000007,7,null,"07",1,78,1020.6,11.6,6]
["08",1,95,1025.4000000000001,11.3,7,null,"08",0,63,1020,11.1,6]
["09",3,79,1025.2,14.4,7,null,"09",1,67,1019.7,13.5,6]
["10",3,71,1024.3,14.3,7,null,"10",2,41,1019.2,8.6999999999999993,6]
["11",3,64,1023.7,13.9,7,null,"11",2,35,1018.3,7.6,5]
["12",3,60,1023.2,13.3,7,null,"12",2,31,1017.5,6.5,5]
["13",3,58,1022.9,12.9,7,null,"13",1,47,1016.5,13,5]
["14",2,59,1022.4,12.7,7,null,"14",2,51,1015.3,14,5]
["15",2,59,1022.5,12.8,8,null,"15",2,51,1014.3,14.1,4]
["16",2,60,1022.2,12.5,8,null,"16",2,55,1013.8,14,4]
["17",2,63,1022.4,12.4,7,null,"17",2,56,1013.1,13.2,2]
["18",3,67,1022,12.6,6,null,"18",2,61,1013.2,12.9,2]
["19",2,66,1022.2,12.1,7,null,"19",2,60,1012.7,12.4,1]
["20",2,68,1022.4,12.1,7,null,"20",2,60,1012.8,12.3,1]
["21",3,69,1022,12.1,4,null,"21",2,64,1013.1,12.3,2]
["22",3,68,1022.4,11.7,4,null,"22",2,65,1013.1,12.5,3]
["23",2,69,1022.6,11.6,6,null,"23",2,64,1012.8,12.2,2]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.7},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":76.8},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1024},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":11.5},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":5},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.8},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":60},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1017.4},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":11.7},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":4}]
[]
[null,null,null,null,"2016-09-28",null,null,null,null,null,null,"2015-09-29"]

{"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:","September",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.",19,26.8,12.2,8.1999999999999993,44,67,2.6,".",null,null,6.7,1020.4,12.2,1,null,null,null,null,null,null,3,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.8,25.2,13.2,8.6999999999999993,53,75,3.7,".",null,null,7.9,1020,14,1,null,null,null,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":8},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=3\")","v":2},{"$f":"COUNTIF(I6:I15,\">=10\")","v":1},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",20,26.4,14.6,11.7,47,71,5.3,".",null,null,3.8,1017,14.1,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":1},{"$f":"COUNTIF(C18:C27,\">=25\")","v":6},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":4},{"$f":"COUNTIF(I18:I27,\">=1\")","v":3},{"$f":"COUNTIF(I18:I27,\">=3\")","v":3},{"$f":"COUNTIF(I18:I27,\">=10\")","v":1},{"$f":"COUNTIF(I18:I27,\">=20\")","v":1}]
["04.",19.3,25.9,14.7,11.8,48,76,5.9,14,"R",null,2.1,1011.8,14.6,2,null,null,1,1,1,null,6,null,null,null,null,{"$f":"COUNTIF(C30:C39,\">=30\")","v":0},{"$f":"COUNTIF(C30:C39,\">=25\")","v":1},{"$f":"COUNTIF(C30:C39,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I39,\">=0,1\")","v":1},{"$f":"COUNTIF(I30:I39,\">=1\")","v":1},{"$f":"COUNTIF(I30:I39,\">=3\")","v":0},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",15.8,18.899999999999999,14.3,12.8,83,92,7.1,7.2,"R",null,0.2,1015.2,14.5,2,null,null,1,null,null,null,5]
["06.",15.5,19.899999999999999,13.3,11.2,70,90,5.2,".",null,null,3.7,1026.4000000000001,14,1,null,null,null,null,null,null,3,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.7,25.4,10.199999999999999,8.5,60,84,1.8,".",null,null,10.1,1023.4,14.6,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":2},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",20.2,28.2,13.1,11.4,43,77,0.8,".",null,null,9.9,1014.8,15.5,1,null,null,null,null,null,null,4,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":3},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":1}]
["09.",20.3,26.3,15,12.2,61,80,1.2,".",null,null,7.1,1016,16.5,1,null,null,null,null,null,null,3,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":1}]
["10.",20.8,27.9,14.3,12.1,58,82,1.3,".",null,null,9.6999999999999993,1017,17.2,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B6:B15)","v":187.4},{"$f":"SUM(C6:C15)","v":250.90000000000003},{"$f":"SUM(D6:D15)","v":134.9},{"$f":"SUM(E6:E15)","v":108.60000000000001},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":21.2},"XX",null,{"$f":"SUM(L6:L15)","v":61.2},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":2},{"$f":"SUM(S6:S15)","v":1},{"$f":"SUM(T6:T15)","v":1},{"$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.740000000000002},{"$f":"AVERAGE(C6:C15)","v":25.090000000000003},13.49,10.860000000000001,"XXX",79.400000000000006,3.4899999999999998,"XXX","XX",null,{"$f":"L16/10","v":6.12},{"$f":"AVERAGE(M6:M15)","v":1018.2},{"$f":"AVERAGE(N6:N15)","v":14.719999999999999},{"$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":3.7},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$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.",22.4,28.9,17.2,"-",49,76,3.7,".",null,null,9.3000000000000007,1017,17.600000000000001,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":3},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$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.",21.8,30.6,15.1,12.2,33,76,1,".",null,null,9.6999999999999993,1018.7,16.600000000000001,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":0},{"$f":"COUNTIF(L30:L39,\"<1\")","v":0},{"$f":"COUNTIF(L30:L39,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",21.9,29.7,15.4,12.7,45,71,0.5,".",null,null,9.4,1017,15.8,1,null,null,null,null,null,null,4]
["14.",20.6,28.6,14.3,12,46,70,0.5,".",null,null,9.3000000000000007,1016.1,14.6,1,null,null,null,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",18.899999999999999,26.6,11.8,8.6999999999999993,43,67,0.4,".",null,null,9.4,1014.6,12.6,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":22.4},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":30.6},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":3.7},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":26.7}]
["16.",19.8,26.5,14.2,10.3,54,76,4.4000000000000004,7.1,"R",null,8.6999999999999993,1011.7,15.2,1,null,null,1,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",16.399999999999999,17.600000000000001,15.7,14.2,94,97,8,26.7,"R",null,".",1009.9,16.100000000000001,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":11.6},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":5.7},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":26},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",13,15.9,11.4,11.4,98,99,8,6.8,"R",null,".",1012.5,12.9,1,null,null,1,null,null,null,3]
["19.",12.2,15.2,9.6999999999999993,"-",79,94,6.6,0.9,"R",null,".",1015.9,11.3,1,null,null,1,null,null,null,4]
["20.",11.6,16.399999999999999,7.8,5.2,54,83,6.5,".",null,null,2.2999999999999998,1018.6,8.6999999999999993,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B18:B27)","v":178.59999999999997},{"$f":"SUM(C18:C27)","v":236},{"$f":"SUM(D18:D27)","v":132.60000000000002},{"$f":"SUM(E18:E27)","v":86.7},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":41.499999999999993},"XX",null,{"$f":"SUM(L18:L27)","v":58.099999999999994},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":4},{"$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":17.859999999999996},{"$f":"AVERAGE(C18:C27)","v":23.6},13.260000000000002,10.8375,59.5,80.900000000000006,3.96,"XXX","XX",null,{"$f":"L28/10","v":5.81},{"$f":"AVERAGE(M18:M27)","v":1015.2},{"$f":"AVERAGE(N18:N27)","v":14.14},{"$f":"AVERAGE(O18:O27)","v":1},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3.3}]
["21.",13.1,18,8.6,"-",69,85,6.1,1.4,"R",null,1.4,1019.4,10.5,1,null,null,1,null,null,null,3]
["22.",11.7,18.3,5.7,3.7,57,87,2.7,".",null,null,8.1999999999999993,1022.3,9.3000000000000007,0,null,null,null,null,null,null,3]
["23.",13.3,20.9,8,6.6,50,84,3.8,".",null,null,3.8,1023.5,10.3,1,null,null,null,null,null,null,4]
["24.",13.7,20.399999999999999,8.3000000000000007,6.4,63,84,2.8,".",null,null,8.4,1025.4000000000001,10.9,0,null,null,null,null,null,null,3]
["25.",13.9,21.8,8.1999999999999993,5.6,52,82,4.3,".",null,null,2.8,1021.7,10.4,1,null,null,null,null,null,null,3]
["26.",14.1,20.8,8.5,6.1,62,84,3.3,".",null,null,8,1021.2,11.1,1,null,null,null,null,null,null,3]
["27.",13.5,20.2,8.6,6.4,62,87,2,".",null,null,7.3,1025.3,11.2,1,null,null,null,null,null,null,3]
["28.",16.2,21.7,9,6.8,57,77,5,".",null,null,4.9000000000000004,1024,11.5,2,null,null,null,null,1,null,6]
["29.",20.100000000000001,25.9,15.3,11.8,26,60,4,".",null,null,6.7,1017.4,11.7,2,null,null,null,null,null,null,5]
["30.",17.5,23.4,12.9,"-",54,75,6.2,".",null,null,1.8,1013.5,13.2,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B30:B39)","v":147.1},{"$f":"SUM(C30:C39)","v":211.39999999999998},{"$f":"SUM(D30:D39)","v":93.100000000000009},{"$f":"SUM(E30:E39)","v":53.400000000000006},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":1.4},"XX",null,{"$f":"SUM(L30:L39)","v":53.29999999999999},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":1},{"$f":"SUM(S30:S39)","v":0},{"$f":"SUM(T30:T39)","v":1},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":14.709999999999999},{"$f":"AVERAGE(C30:C39)","v":21.139999999999997},{"$f":"AVERAGE(D30:D39)","v":9.31},{"$f":"AVERAGE(E30:E39)","v":6.6750000000000007},"XXX",{"$f":"AVERAGE(G30:G39)","v":80.5},{"$f":"AVERAGE(H30:H39)","v":4.0200000000000005},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1021.3700000000001},{"$f":"AVERAGE(N30:N39)","v":11.010000000000002},{"$f":"AVERAGE(O30:O39)","v":1.1000000000000001},{"$f":"ROUND(AVERAGE(P30:P39),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":3.8}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":513.1},{"$f":"SUM(C16+C28+C40)","v":698.3},{"$f":"SUM(D16+D28+D40)","v":360.6},{"$f":"SUM(E16+E28+E40)","v":248.70000000000002},"XXX","XXX,",{"$f":"SUM(H16+H28+H40)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I16+I28+I40)","v":64.099999999999994},"XX",null,{"$f":"SUM(L16+L28+L40)","v":172.6},"XXX","XXX","XXX",{"$f":"SUM(P16+P28+P40)","v":{"$error":"#VALUE!"}},"X",{"$f":"SUM(R16+R28+R40)","v":7},{"$f":"SUM(S16+S28+S40)","v":1},{"$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":17.103333333333335},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C39)","v":23.276666666666664},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D39)","v":12.020000000000001},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E39)","v":9.5653846153846143},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G39)","v":80.266666666666666},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H39)","v":3.8233333333333328},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1018.2566666666669},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":13.289999999999997},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":1.1000000000000001},{"$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":3.6}]
[]
[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":7},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":3}]
["TTT",14.3,"XXXX",{"$f":"SUM(B43-B47)","v":2.8033333333333346},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":1},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":6},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":1}]
["RRR",50,{"$f":"SUM(I42*100/B48)","v":128.19999999999999},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":15},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":1}]
["sss",150,{"$f":"SUM(L42*100/B49)","v":115.06666666666666},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":2},"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.",380,{"$f":"SUM(L42*100/B51)","v":45.421052631578945},"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,1,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":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:","September",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,"-"," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-",{"$f":"IF(R16=1,1,\"-\")","v":"-"},"-",1,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,"-","-",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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-",1,1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,1,"-"]
["30.","-","-","-","-",1,1,"-"]
["Su.",{"$f":"SUM(B9:B38)","v":"00:00:00"},0,7,15,28,4,1]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39)","v":4}]

{"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)"]
[]
["September 2016"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":30.6},"am","2016-09-12"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":17.103333333333335},{"$f":"Kurztabelle!B47","v":14.3},{"$f":"C7-D7","v":2.8033333333333346},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":5.7},"am","2016-09-22"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":64.099999999999994},{"$f":"Kurztabelle!B48","v":50},{"$f":"100/D9*C9","v":128.19999999999999},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":172.6},{"$f":"Kurztabelle!B49","v":150},{"$f":"100/D10*C10","v":115.06666666666666},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2016-09-01",19,26.8,12.2,null,null,6.7,1020.4,16.45,"(Wa)"]
["2016-09-02",18.8,25.2,13.2,null,null,7.9,1020,16.3,null,"H Jan","Leicht schwül."]
["2016-09-03",20,26.4,14.6,null,null,3.8,1017,16.149999999999999,null,null,"Leicht schwül."]
["2016-09-04",19.3,25.9,14.7,14,null,2.1,1011.8,16,"Wz","T Netti","Von 18:30 Uhr - 19:19 Uhr leichtes Gewitter mit Regen (WW 95). Von 19:20 Uhr - 20:39 Uhr mäßiger Regenschauer (WW 81). Von 20:40 Uhr - 21:39 Uhr leichter Regenschauer (WW 80). Von 13:30 Uhr - 13:39 Uhr starker Regen (WW 65). Von 13:20 Uhr - 13:29 Uhr; 13:40 Uhr - 13:49 Uhr mäßiger Regen (WW 63). Von 13:50 Uhr - 14:39 Uhr; 15:18 Uhr - 15:20 Uhr leichter Regen (WW 61). Von 18:30 Uhr - Von 18:00 Uhr - 18:29 Uhr Wetterleuchten (WW 13). Leicht schwül."]
["2016-09-05",15.8,18.899999999999999,14.3,7.2,null,0.2,1015.2,15.85,"TrM",null,"Von 16:40 Uhr - 17:04 Uhr mäßiger Regenschauer (WW 81). Von 13:50 Uhr - 14:04 Uhr; Um 14:20 Uhr; 17:05 Uhr - 17:19 Uhr leichter Regenschauer (WW 80).  Von 08:15 Uhr - 09:09 Uhr; 09:45 Uhr - 09:54 Uhr; 10:30 Uhr - 10:39 Uhr; 18:25 Uhr - 19:04 Uhr mäßiger Regen (WW 63). Um 16:20 Uhr leichter Regen (WW 61). Von 11:20 Uhr - 11:39 Uhr mäßiger Sprühregen (WW 53). Von 11:40 Uhr - 13:09 Uhr mäßiger Sprühregen, unterbrochen (WW 52). Leicht schwül."]
["2016-09-06",15.5,19.899999999999999,13.3,null,null,3.7,1026.4000000000001,15.7,"HM","H Johannes","Leicht schwül."]
["2016-09-07",17.7,25.4,10.199999999999999,null,null,10.1,1023.4,15.55,null,null,"Mäßig schwül."]
["2016-09-08",20.2,28.2,13.1,null,null,9.9,1014.8,15.4,"SEa",null,"Mäßig schwül."]
["2016-09-09",20.3,26.3,15,null,null,7.1,1016,15.25,"BM",null,"Stark schwül."]
["2016-09-10",20.8,27.9,14.3,null,null,9.6999999999999993,1017,15.1,null,null,"Stark schwül."]
["2016-09-11",22.4,28.9,17.2,null,null,9.3000000000000007,1017,14.95,"SWa","H Karl","Stark schwül."]
["2016-09-12",21.8,30.6,15.1,null,null,9.6999999999999993,1018.7,14.8,"Sa",null,"Stark schwül."]
["2016-09-13",21.9,29.7,15.4,null,null,9.4,1017,14.65,null,null,"Mäßig schwül."]
["2016-09-14",20.6,28.6,14.3,null,null,9.3000000000000007,1016.1,14.5,"HNFa","H Lukas","Mäßig schwül."]
["2016-09-15",18.899999999999999,26.6,11.8,null,null,9.4,1014.6,14.35]
["2016-09-16",19.8,26.5,14.2,7.1,null,8.6999999999999993,1011.7,14.2,null,null,"Von 20:50 Uhr - 21:24 Uhr; 22:20 Uhr - 22:49 Uhr mäßiger Regen (WW 63). Von 22:00 Uhr - 22:19 Uhr; 23:25 Uhr - 23:34 Uhr leichter Regen (WW 61). Mäßig schwül."]
["2016-09-17",16.399999999999999,17.600000000000001,15.7,26.7,null,null,1009.9,14.05,"HFz","T Theresia","Von 06:45 Uhr - 06:59 Uhr; 07:40 Uhr - 08:44 Uhr; 09:00 Uhr - 09:29 Uhr; 15:20 Uhr - 15:29 Uhr; 18:40 Uhr - 18:59 Uhr starker Regen (WW 65). Von 03:00 Uhr - 03:39 Uhr; 05:40 Uhr - 06:44 Uhr; 07:00 Uhr - 07:39 Uhr; 08:45 Uhr - 08:59 Uhr; 09:30 Uhr - 09:39 Uhr; 13:10 Uhr - 13:24 Uhr; 13:25 Uhr - 13:39 Uhr; 14:10 Uhr - 15:19 Uhr; 15:30 Uhr - 15:49 Uhr; 16:40 Uhr - 17:44 Uhr; 18:10 Uhr - 18:39 Uhr; 19:00 Uhr - 19:49 Uhr; 20:00 Uhr - 20:09 Uhr mäßiger Regen (WW 63). Von 04:30 Uhr - 05:39 Uhr; 09:40 Uhr - 09:59 Uhr; 13:40 Uhr - 14:09 Uhr; 16:30 Uhr - 16:39 Uhr; 17:45 Uhr - 17:59 Uhr; 19:00 Uhr - 19:09 Uhr; 20:50 Uhr - 21:09 Uhr; Um 22:00 Uhr; Um 22:15 Uhr; 22:40 Uhr - 22:49 Uhr; 23:10 Uhr - 23:59 Uhr leichter Regen (WW 61). Leicht schwül."]
["2016-09-18",13,15.9,11.4,6.8,null,null,1012.5,13.9,null,null,"Von 00:10 Uhr - 00:24 Uhr; 00:40 Uhr - 00:49 Uhr; 04:55 Uhr - 05:44 Uhr; 06:00 Uhr - 08:19 Uhr; 08:50 Uhr - 09:19 Uhr; 09:40 Uhr - 11:39 Uhr mäßiger Regen (WW 63). Von 00:00 Uhr - 00:09 Uhr; 00:25 Uhr - 00:39 Uhr; 01:50 Uhr - 01:59 Uhr; 02:50 Uhr - 03:09 Uhr; 05:45 Uhr - 05:59 Uhr; 08:20 Uhr - 08:49 Uhr; 09:20 Uhr - 09:39 Uhr; Zwischen 13:00 Uhr und 14:59 Uhr leichter Regen (WW 61). Gegen 17:00 Uhr; Gegen 21:00 Uhr leichter Sprühregen (WW 51). Leicht schwül."]
["2016-09-19",12.2,15.2,9.6999999999999993,0.9,null,null,1015.9,13.75,"HFa","H Matthias","Von 03:30 Uhr - 04:39 Uhr; 04:55 Uhr - 05:14 Uhr; 07:45 Uhr -  08:24 Uhr mäßiger Regen (WW 63). Von 02:50 Uhr - 03:04 Uhr; 05:15 Uhr - 05:34 Uhr; 07:25 Uhr - 07:44 Uhr; 08:25 Uhr - 08:59 Uhr leichter Regen (WW 61). "]
["2016-09-20",11.6,16.399999999999999,9.6999999999999993,null,null,2.2999999999999998,1018.6,13.6]
["2016-09-21",13.1,18,8.6,1.4,null,1.4,1019.4,13.45,null,null,"Von 19:20 Uhr - 19:29 Uhr starker Regen (WW 65). Von 19:10 Uhr - 19:19 Uhr mäßiger Regen (WW 63). Von 19:30 Uhr - 19:32 Uhr leichter Regen (WW 61)."]
["2016-09-22",11.7,18.3,5.7,null,null,8.1999999999999993,1022.3,13.3,"HM","H Nikolaus","In der Nacht und morgens Elbtalnebel (WW 40)."]
["2016-09-23",13.3,20.9,8,null,null,3.8,1023.5,13.15]
["2016-09-24",13.7,20.399999999999999,8.3000000000000007,null,null,8.4,1025.4000000000001,13,null,null,"Morgens Elbtalnebel (WW 40)."]
["2016-09-25",13.9,21.8,8.1999999999999993,null,null,2.8,1021.7,12.85,null,null,"Leicht schwül."]
["2016-09-26",14.1,20.8,8.5,null,null,8,1021.2,12.7,"BM","H Otto"]
["2016-09-27",13.5,20.2,8.6,null,null,7.3,1025.3,12.55]
["2016-09-28",16.2,21.7,9,null,null,4.9000000000000004,1024,12.4]
["2016-09-29",20.100000000000001,25.9,15.3,null,null,6.7,1017.4,12.25,"Wa"]
["2016-09-30",17.5,23.4,12.9,null,null,1.8,1013.5,12.1,null,null,"Leicht schwül."]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":17.103333333333335},{"$f":"AVERAGE(C2:C31)","v":23.276666666666664},{"$f":"AVERAGE(D2:D31)","v":12.083333333333334},"-",null,{"$f":"AVERAGE(G2:G31)","v":6.3925925925925942},{"$f":"AVERAGE(H2:H31)","v":1018.2566666666669},{"$f":"AVERAGE(I2:I31)","v":14.275}]
["Mittel",14.3,null,null,50,"-",150,1018.3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]