{"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,91,1036.2,5.9,1,null,"00",0,94,1036.5,4.9000000000000004,0]
["01",1,93,1036.0999999999999,5.4,1,null,"01",1,95,1036.5,4.8,1]
["02",1,93,1036,4.7,1,null,"02",1,95,1036.5,4.2,1]
["03",1,94,1036.2,5.0999999999999996,1,null,"03",1,95,1036.4000000000001,3.8,1]
["04",1,95,1036.2,4.2,1,null,"04",1,95,1036.2,3.2,0]
["05",1,96,1036.5,3.9,1,null,"05",1,95,1036.0999999999999,2.6,2]
["06",1,96,1036.7,3.6,1,null,"06",1,96,1036.4000000000001,2.4,1]
["07",1,96,1037.3,3.8,5,null,"07",1,96,1036.5999999999999,2.2999999999999998,1]
["08",1,96,1037.2,5,5,null,"08",1,97,1036.7,4.5,2]
["09",1,94,1037.8,7,6,null,"09",1,95,1036.9000000000001,5.9,5]
["10",1,87,1037.9000000000001,7.9,3,null,"10",0,83,1036.7,6.8,4]
["11",1,81,1037.7,9.1999999999999993,3,null,"11",1,71,1036.2,8.1999999999999993,5]
["12",1,72,1037.4000000000001,9.1,3,null,"12",2,65,1036,7,7]
["13",2,74,1037.0999999999999,9,5,null,"13",2,59,1035.4000000000001,5.5,7]
["14",2,73,1036.8,9.4,6,null,"14",1,62,1035.0999999999999,6.3,7]
[15,1,72,1036.5,9.3000000000000007,7,null,"15",1,65,1034.8,6.5,7]
["16",1,75,1036.3,9.5,7,null,"16",1,68,1034.5,7.2,7]
["17",1,75,1036.0999999999999,9,7,null,"17",0,72,1034.4000000000001,7.3,6]
["18",0,81,1036.0999999999999,8,6,null,"18",0,76,1034.4000000000001,7.2,6]
["19",1,82,1036.3,7.6,5,null,"19",1,81,1030.9000000000001,5.6,4]
["20",1,87,1036.4000000000001,6.8,6,null,"20",2,84,1030.8,4.8,4]
["21",1,91,1036.3,6.7,6,null,"21",0,88,1031.0999999999999,4.0999999999999996,3]
["22",1,91,1036.3,6.4,6,null,"22",1,88,1030.8,3.5,1]
["23",1,91,1036.3,5.7,0,null,"23",1,91,1031.0999999999999,2.9,0]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":86.5},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1036.7},{"$f":"AVERAGE(E3:E26)","v":6.7583333333333329},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":3.9},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.9},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":83.6},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1034.9000000000001},{"$f":"AVERAGE(L3:L26)","v":5.0624999999999991},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":3.4}]
[]
[null,null,null,null,"2015-09-29",null,null,null,null,null,null,"2015-09-30"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,88,1028.2,8.1999999999999993,7,null,"00",1,91,1034.5,6.4,6]
["01",1,88,1028.3,8.1,7,null,"01",1,92,1034.5,6.8,5]
["02",1,90,1028.4000000000001,8.1999999999999993,7,null,"02",1,93,1034.8,6.6,5]
["03",1,91,1028.8,7.9,7,null,"03",0,95,1034.8,5.8,6]
["04",1,91,1029,7.9,6,null,"04",1,95,1035,5.0999999999999996,4]
["05",0,93,1029.5,7.7,5,null,"05",1,96,1035.5,5.5,2]
["06",1,94,1029.9000000000001,7.6,3,null,"06",1,96,1036,5.3,1]
["07",1,95,1030.5,7.7,3,null,"07",1,96,1036.4000000000001,5.0999999999999996,0]
["08",1,91,1030.9000000000001,8.3000000000000007,2,null,"08",0,93,1036.5,6.6,0]
["09",0,89,1031.4000000000001,8.9,3,null,"09",1,91,1036.9000000000001,7.9,0]
["10",1,83,1031.5999999999999,9.8000000000000007,5,null,"10",1,87,1037.0999999999999,9.3000000000000007,1]
["11",1,82,1031.5,9.9,5,null,"11",1,78,1037.0999999999999,10.1,3]
["12",2,80,1031.7,10.6,5,null,"12",1,66,1036.5999999999999,9.9,4]
["13",1,81,1031.5,11.2,7,null,"13",2,63,1036.3,8.6999999999999993,4]
["14",2,74,1031.5,9.6,5,null,"14",2,61,1035.9000000000001,8,3]
["15",1,72,1031.5999999999999,9,6,null,"15",2,64,1035.8,8,4]
["16",1,73,1031.8,9.1999999999999993,5,null,"16",2,62,1035.2,7.9,3]
["17",1,75,1032.0999999999999,8.8000000000000007,4,null,"17",1,66,1035.3,7.6,3]
["18",1,77,1032.5,7.9,3,null,"18",0,72,1035.5999999999999,7.7,1]
["19",1,82,1033,7.3,2,null,"19",1,79,1035.9000000000001,7.4,1]
["20",2,88,1033.4000000000001,7.2,2,null,"20",1,85,1036.0999999999999,7.3,1]
["21",2,89,1033.8,7,3,null,"21",2,86,1036.0999999999999,7.1,1]
["22",2,89,1034,6.6,2,null,"22",1,87,1036.0999999999999,6.8,2]
["23",1,92,1034.2,6.3,2,null,"23",1,90,1036,6.2,1]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.1000000000000001},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":85.3},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1031.2},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":8.4},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":4.4000000000000004},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.1000000000000001},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":82.7},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1035.8},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":7.2},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":2.5}]
[]
[null,null,null,null,"2015-09-27",null,null,null,null,null,null,"2015-09-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:","September",null,null,null,null,"Jahr:",null,null,"2015"]
[]
["Dat.","TTT","TxTx","TnTn","Tg","Umin.","UU","NN","RRRR","Art",null,"sss","PPPP","eee","fff",null,null,"Tage mit",null,null,null,"fk","Summe "]
[null,null,null,null,null,null,null,null,null,"*",null,null,null,null,"Bft","SS","Art ( D )","RR","Ge","Bf6","Bf8","Bft","Gewitter"]
["01.",22.8,31.4,15.2,"-",47,76,3.6,14,"R",null,7.7,1007.8,18,1,null,null,1,1,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,20.399999999999999,12.6,"-",56,81,5,".",null,null,6.1,1015.9,12.5,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":1},{"$f":"COUNTIF(C6:C15,\">=25\")","v":1},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":7},{"$f":"COUNTIF(I6:I15,\">=1\")","v":5},{"$f":"COUNTIF(I6:I15,\">=3\")","v":2},{"$f":"COUNTIF(I6:I15,\">=10\")","v":1},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",15.2,21.3,12.2,"-",56,86,6.6,5.4,"R",null,2.1,1014.6,12.8,1,null,null,1,1,null,null,4,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":1},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":5},{"$f":"COUNTIF(I18:I27,\">=1\")","v":4},{"$f":"COUNTIF(I18:I27,\">=3\")","v":2},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",14.4,20.6,10.1,"-",49,84,3.9,0,null,null,3,1014.3,11.5,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C30:C39,\">=30\")","v":0},{"$f":"COUNTIF(C30:C39,\">=25\")","v":0},{"$f":"COUNTIF(C30:C39,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I39,\">=0,1\")","v":2},{"$f":"COUNTIF(I30:I39,\">=1\")","v":2},{"$f":"COUNTIF(I30:I39,\">=3\")","v":0},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",13.8,18.2,10.3,5.6,59,74,4.9000000000000004,2.9,"R",null,2.2000000000000002,1012.7,9.1999999999999993,3,null,null,1,null,1,null,6]
["06.",12.2,15.3,10.3,"-",72,82,6.8,0.6,"R",null,0.8,1015.3,9.1999999999999993,3,null,null,1,null,1,null,6,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.",12.1,16.100000000000001,10.199999999999999,7.6,60,82,6.2,2.1,"R",null,1.8,1021.2,9.1,2,null,null,1,null,null,null,5,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":0}]
["08.",13.2,17.7,7.5,4.2,60,77,4.9000000000000004,0.6,"R",null,3.2,1023.4,9.1,1,null,null,1,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":2},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",12.4,17.7,8.6,6,55,83,3.7,0,null,null,3.5,1023.9,9.4,1,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":6},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":0}]
["10.",10.8,18.3,7.1,4.9000000000000004,66,90,5.4,1.4,"R",null,1.9,1024.0999999999999,9.3000000000000007,1,null,null,1,1,null,null,4,3]
["Su",{"$f":"SUM(B6:B15)","v":142.80000000000001},{"$f":"SUM(C6:C15)","v":196.99999999999997},{"$f":"SUM(D6:D15)","v":104.1},{"$f":"SUM(E6:E15)","v":28.299999999999997},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":27},"XX",null,{"$f":"SUM(L6:L15)","v":32.299999999999997},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":7},{"$f":"SUM(S6:S15)","v":3},{"$f":"SUM(T6:T15)","v":2},{"$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":14.280000000000001},{"$f":"AVERAGE(C6:C15)","v":19.699999999999996},10.41,5.6599999999999993,"XXX",81.5,5.0999999999999996,"XXX","XX",null,{"$f":"L16/10","v":3.2299999999999995},{"$f":"AVERAGE(M6:M15)","v":1017.3199999999999},{"$f":"AVERAGE(N6:N15)","v":11.01},{"$f":"AVERAGE(O6:O15)","v":1.5},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4.5999999999999996},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$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.",12,17,6.6,4.5,80,92,4,0,null,null,1.4,1020.9,10.8,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":3},{"$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.",15.3,21.5,9.8000000000000007,5.4,60,84,2.6,".",null,null,6.8,1018.4,12.4,2,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":1},{"$f":"COUNTIF(L30:L39,\"<1\")","v":3},{"$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.",18.2,24,13.1,9.1999999999999993,55,77,5.2,".",null,null,5.7,1012.9,13.8,2,null,null,null,null,null,null,5]
["14.",16.7,19.100000000000001,14.9,"-",77,84,5,4,"R",null,0.5,1006.3,14,2,null,null,1,null,null,null,5,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",16.100000000000001,20.399999999999999,12.6,10.1,56,73,6.8,0.1,"R",null,0.4,1010.3,11.1,2,null,null,1,1,1,null,6,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":22.8},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":31.4},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-0.3},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":14}]
["16.",17.3,23.9,10.6,8.1999999999999993,58,79,4.8,0,null,null,0.8,1003.9,13.4,1,null,null,null,null,null,null,4,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",19.7,29.1,12.8,"-",44,75,4,6.1,"R",null,6.6,1003.3,14.8,1,null,null,1,null,1,null,6,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":8.1999999999999993},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":2.6},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":44},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",15.6,19.899999999999999,12.4,"-",63,79,4.7,".",null,null,4.5999999999999996,1016.6,11.9,2,null,null,null,null,null,null,5]
["19.",15.3,21.1,11.6,"-",55,83,4.0999999999999996,2.2999999999999998,"R",null,4.5,1020.8,12.1,1,null,null,1,null,null,null,4]
["20.",12.7,16.899999999999999,11.4,"-",64,86,6.3,1.7,"R",null,2.6,1020.9,10.4,2,null,null,1,null,1,null,6]
["Su",{"$f":"SUM(B18:B27)","v":158.9},{"$f":"SUM(C18:C27)","v":212.9},{"$f":"SUM(D18:D27)","v":115.8},{"$f":"SUM(E18:E27)","v":37.400000000000006},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":14.2},"XX",null,{"$f":"SUM(L18:L27)","v":33.9},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":1},{"$f":"SUM(T18:T27)","v":3},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":15.89},{"$f":"AVERAGE(C18:C27)","v":21.29},11.58,7.4800000000000013,61.2,81.2,4.7500000000000009,"XXX","XX",null,{"$f":"L28/10","v":3.3899999999999997},{"$f":"AVERAGE(M18:M27)","v":1013.43},{"$f":"AVERAGE(N18:N27)","v":12.47},{"$f":"AVERAGE(O18:O27)","v":1.6},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4.9000000000000004}]
["21.",12.4,15.8,9.8000000000000007,"-",74,87,6.3,".",null,null,0.2,1017.2,10.4,1,null,null,null,null,null,null,3]
["22.",13.4,18.600000000000001,7.9,5.3,62,81,6.3,1,"R",null,2.6,1008.1,10.1,1,null,null,1,null,null,null,4]
["23.",12.7,14.7,8.6,"-",77,90,6.9,2.9,"R",null,".",1009.9,11.2,1,null,null,1,null,null,null,3]
["24.",11.3,17.100000000000001,6.4,4.0999999999999996,70,90,3.3,".",null,null,2,1019.7,9.6,1,null,null,null,null,null,null,3]
["25.",12.9,18.8,7.1,4.9000000000000004,65,85,5.3,".",null,null,4,1021.4,10.3,1,null,null,null,null,null,null,4]
["26.",12.6,15.9,11.4,"-",73,85,6.6,0,null,null,0.7,1025.0999999999999,10.199999999999999,1,null,null,null,null,null,null,3]
["27.",10.8,15,7.4,5.0999999999999996,71,85,4.4000000000000004,".",null,null,1.6,1031.2,8.4,1,null,null,null,null,null,null,3]
["28.",10.199999999999999,16.5,5.7,2.6,62,83,2.5,".",null,null,4.9000000000000004,1035.8,7.2,1,null,null,null,null,null,null,3]
["29.",9,15,3.9,1.7,70,86,3.9,".",null,null,2.5,1036.7,6.8,1,null,null,null,null,null,null,4]
["30.",8.1999999999999993,14.7,2.6,-0.3,56,84,3.4,".",null,null,0.9,1034.9000000000001,5.0999999999999996,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B30:B39)","v":113.5},{"$f":"SUM(C30:C39)","v":162.10000000000002},{"$f":"SUM(D30:D39)","v":70.8},{"$f":"SUM(E30:E39)","v":23.4},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":3.9},"XX",null,{"$f":"SUM(L30:L39)","v":19.399999999999999},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":2},{"$f":"SUM(S30:S39)","v":0},{"$f":"SUM(T30:T39)","v":0},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":11.35},{"$f":"AVERAGE(C30:C39)","v":16.21},{"$f":"AVERAGE(D30:D39)","v":7.08},{"$f":"AVERAGE(E30:E39)","v":3.3428571428571425},"XXX",{"$f":"AVERAGE(G30:G39)","v":85.6},{"$f":"AVERAGE(H30:H39)","v":4.8899999999999997},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1024},{"$f":"AVERAGE(N30:N39)","v":8.93},{"$f":"AVERAGE(O30:O39)","v":1},{"$f":"ROUND(AVERAGE(P30:P39),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":3.4}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":415.20000000000005},{"$f":"SUM(C16+C28+C40)","v":572},{"$f":"SUM(D16+D28+D40)","v":290.7},{"$f":"SUM(E16+E28+E40)","v":89.1},"XXX","XXX,",{"$f":"SUM(H16+H28+H40)","v":{"$error":"#VALUE!"}},{"$f":"SUM(I16+I28+I40)","v":45.1},"XX",null,{"$f":"SUM(L16+L28+L40)","v":85.6},"XXX","XXX","XXX",{"$f":"SUM(P16+P28+P40)","v":{"$error":"#VALUE!"}},"X",{"$f":"SUM(R16+R28+R40)","v":14},{"$f":"SUM(S16+S28+S40)","v":4},{"$f":"SUM(T16+T28+T40)","v":5},{"$f":"SUM(U16+U28+U40)","v":0},"XXX",5]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":13.84},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C39)","v":19.066666666666666},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D39)","v":9.69},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E39)","v":5.2411764705882344},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G39)","v":82.766666666666666},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H39)","v":4.9133333333333331},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1018.25},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":10.803333333333335},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":1.3666666666666667},{"$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.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":14},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":1}]
["TTT",14.3,"XXXX",{"$f":"SUM(B43-B47)","v":-0.46000000000000085},"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":7}]
["RRR",50,{"$f":"SUM(I42*100/B48)","v":90.2},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":2},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":4},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",150,{"$f":"SUM(L42*100/B49)","v":57.06666666666667},"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":0},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",380,{"$f":"SUM(L42*100/B51)","v":22.526315789473685},"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":9},">/= 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":0}]
[]
[]
[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:",2015]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","-","-","-","-",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,"-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-",1,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.","02:16:00",1,1,1,1,"-","-",null,null,null,null,null,2.2666666666666666," ",2,3,2]
["11.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-","-",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,"-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,"-","-"]
["30.","-","-","-","-",1,1,"-"]
["Su.",{"$f":"SUM(B9:B38)","v":"02:16:00"},1,1,7,30,16,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":1}]
[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)"]
[]
["September 2015"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":31.4},"am","2015-09-01"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":13.84},{"$f":"Kurztabelle!B47","v":14.3},{"$f":"C7-D7","v":-0.46000000000000085},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":2.6},"am","2015-09-30"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":45.1},{"$f":"Kurztabelle!B48","v":50},{"$f":"100/D9*C9","v":90.2},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":85.6},{"$f":"Kurztabelle!B49","v":150},{"$f":"100/D10*C10","v":57.066666666666663},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":36,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2015-09-01",22.8,31.4,15.2,14,null,7.7,1007.8,16.45,"SWz","T Jonas","Von 16:40 Uhr - 17:19 Uhr leichtes Gewitter mit Regen (WW 95). 15:40 Uhr; 20:20 Uhr - 21:39 Uhr leichter Regenschauer (WW 80). Von 22:30 Uhr - 23:09 Uhr mäßiger Regen (WW 63). Von 23:10 Uhr - 23:59 Uhr leichter Regen (WW 61). Gegen 15:00 Uhr - 15:39 Uhr; 16:30 Uhr - 16:39 Uhr leichtes Ferngewitter (WW 17). ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stark schwül."]
["2015-09-02",15.9,20.399999999999999,12.6,null,null,6.1,1015.9,16.3,"Wz"]
["2015-09-03",15.2,21.3,12.2,5.4,null,2.1,1014.6,16.149999999999999,null,null,"Von 16:48 Uhr - 17:02 Uhr leichtes Gewitter mit Regen (WW 95). Von 17:03 Uhr - 17:19 Uhr starker Regen (WW 65). Gegen 15:20 Uhr; Von 16:30 Uhr - 16:47 Uhr mäßiger Regen (WW 63). Von 17:20 Uhr - 18:09 Uhr leichter Regen (WW 61)."]
["2015-09-04",14.4,20.6,10.1,null,null,3,1014.3,16,"Nz",null,"Gegen 14:30 Uhr Regentropfen (WW 60). Vor 06:00 Uhr - Gegen 09:00 Uhr Elbtalnebel (WW 13)."]
["2015-09-05",13.8,18.2,10.3,2.9,null,2.2000000000000002,1012.7,15.85,null,"T Kalle","Von 21:10 Uhr - 21:29 Uhr starker Regen (WW 65). Von 21:00 Uhr - 21:09 Uhr; 21:30 Uhr - 21:39 Uhr mäßiger Regen (WW 63). Von 18:40 Uhr - 19:09 Uhr mäßiger Regen, unterbrochen (WW 62)."]
["2015-09-06",12.2,15.3,10.3,0.6,null,0.8,1015.3,15.7,null,null,"Von 10:10 Uhr - 10:49 Uhr leichter Regen (WW 61). Gegen 08:00 Uhr - 10:09 Uhr leichter Regen, unterbrochen (WW 60)."]
["2015-09-07",12.1,16.100000000000001,10.199999999999999,2.1,null,1.8,1021.2,15.55,"Na","H Lajana","Von 09:40 Uhr - 09:49 Uhr starker Regen (WW 65). Von 08:10 Uhr - 09:39 Uhr mäßiger Regen, unterbrochen (WW 62).Gegen 12:30 Uhr leichter Regen (WW 61). Von 07:30 Uhr - 08:09 Uhr starker Sprühregen (WW 55). "]
["2015-09-08",13.2,17.7,7.5,0.6,null,3.2,1023.4,15.4]
["2015-09-09",12.4,17.7,8.6,null,null,3.5,1023.9,15.25,"HNFa",null,"Gegen 15:45 Uhr leichter Regenschauer (WW 80)."]
["2015-09-10",10.8,18.3,7.1,1.4,null,1.9,1024.0999999999999,15.1,"HFz",null,"Von 13:38  Uhr - 13:49 Uhr; 15:05 Uhr - 15:31 Uhr leichtes Gewitter mit Regen (WW 95). Von 12:55 Uhr - 13:04 Uhr; 13:35 Uhr - 13:37 Uhr; 15:00 Uhr - 15:04 Uhr Ferngewitter (WW 17). Von 07:10 Uhr - 09:19 Uhr Nebel (900 m) (WW 45). Gegen 06:45 Uhr - 07:09 Uhr Nebelschwaden (300 m) (WW 41)."]
["2015-09-11",12,17,6.6,null,null,1.4,1020.8,14.95,null,null,"Gegen 15:00 Uhr Regentropfen (WW 60). Vor 06:00 Uhr - Gegen 09:00 Uhr Elbtalnebel (WW 40). "]
["2015-09-12",15.3,21.5,9.8000000000000007,null,null,6.8,1018.4,14.8,"Sa"]
["2015-09-13",18.2,24,13.1,null,null,5.7,1012.9,14.65,null,null,"Leicht schwül."]
["2015-09-14",16.7,19.100000000000001,14.9,4,null,0.5,1006.3,14.5,"SWz","T Michael","Von 11:00 Uhr - 12:09 Uhr mäßiger Regen (WW 63). Gegen 15:15 Uhr leichter Regen (WW 61). Leicht schwül."]
["2015-09-15",16.100000000000001,20.399999999999999,12.6,0.1,null,0.4,1010.3,14.35,null,null,"Gegen 07:00 Uhr; 20:00 Uhr; 21:00 Uhr leichter Regen (WW 60)."]
["2015-09-16",17.3,23.9,10.6,null,null,0.8,1003.9,14.2,"TrW","\"Ex-Henri\"","Gegen 16:30 Uhr Regentropfen (WW 60). Mäßig schwül."]
["2015-09-17",19.7,29.1,12.8,6.1,null,6.6,1003.3,14.05,null,null,"Von 20:00 Uhr - 20:29 Uhr starker Regen (WW 65). Von 18:20 Uhr - 19:29 Uhr starker Regen, unterbrochen (WW 64). Von 20:30 Uhr - 21:09 Uhr mäßiger Regen (WW 63). Mäßig schwül."]
["2015-09-18",15.6,19.899999999999999,12.4,null,null,4.5999999999999996,1016.6,13.9]
["2015-09-19",15.3,21.1,11.6,2.2999999999999998,null,4.5,1020.8,13.75,"TrM",null,"Von 19:50 Uhr - 20:09 Uhr mäßiger Regenschauer (WW 81). Von 19:30 Uhr - 19:49 Uhr; 20:10 Uhr - 20:19 Uhr leichter Regenschauer (WW 80)."]
["2015-09-20",12.7,16.899999999999999,11.4,1.7,null,2.6,1020.9,13.6,null,null,"Gegen 14:10 Uhr; 16:30 Uhr mäßiger Regenschauer (WW 81)."]
["2015-09-21",12.4,15.8,9.8000000000000007,null,null,0.2,1017.2,13.45,"Wa","H Maybrit"]
["2015-09-22",13.4,18.600000000000001,7.9,1,null,2.6,1008.1,13.3,"TrM","T Oliver","Von 16:15 Uhr - Gegen 17:59 Uhr; Gegen 19:00 Uhr; Gegen 22:00 Uhr - Gegen 23:29 Uhr leichter Regen (WW 61)."]
["2015-09-23",12.7,14.7,8.6,2.9,null,null,1009.9,13.15,null,"T Nasar","Von 05:20 Uhr - 08:59 Uhr mäßiger Regen (WW 63). Gegen 05:00 Uhr - 05:19 Uhr; Gegen 11:00 Uhr leichter Regen (WW 61)."]
["2015-09-24",11.3,17.100000000000001,6.4,null,null,2,1019.7,13,"Wa","H Netti","Morgens Elbtalnebel."]
["2015-09-25",12.9,18.8,7.1,null,null,4,1021.4,12.85,"HB",null,"Morgens Elbtalnebel."]
["2015-09-26",12.6,15.9,11.4,null,null,0.7,1025.0999999999999,12.7,null,null,"Gegen 12:30 Uhr Regentropfen (WW 60)."]
["2015-09-27",10.8,15,7.4,null,null,1.6,1031.2,12.55,"HNa",null,"Morgens Elbtalnebel."]
["2015-09-28",10.199999999999999,16.5,5.7,null,null,4.9000000000000004,1035.8,12.4,null,null,"Morgens Elbtalnebel."]
["2015-09-29",9,15,3.9,null,null,2.5,1036.7,12.25,null,null,"Morgens Elbtalnebel."]
["2015-09-30",8.1999999999999993,14.7,2.6,null,null,0.9,1034.9000000000001,12.1,"BM",null,"Morgens Elbtalnebel."]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":13.84},{"$f":"AVERAGE(C2:C31)","v":19.066666666666666},{"$f":"AVERAGE(D2:D31)","v":9.69},"-",null,{"$f":"AVERAGE(G2:G31)","v":2.9517241379310342},{"$f":"AVERAGE(H2:H31)","v":1018.2466666666666},{"$f":"AVERAGE(I2:I31)","v":14.275}]
["Mittel",14.3,null,null,50,"-",150,1016.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]