{"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",0,78,1019.5,0.5,0,null,"00",3,66,1001.6,-1.3,7]
["01",0,78,1019.4,0.3,0,null,"01",1,70,1002.3,-1.2,7]
["02",1,78,1019.2,-0.1,0,null,"02",1,72,1002.9,-0.8,4]
["03",0,79,1019.1,-0.3,1,null,"03",1,74,1003.4,-1,4]
["04",0,79,1018.9,-0.3,2,null,"04",1,76,1004,-1.3,3]
["05",0,79,1018.9,-0.2,3,null,"05",1,74,1004.5,-1,3]
["06",1,76,1018.9,1.4,5,null,"06",0,77,1004.5,-0.2,5]
["07",2,71,1019.1,3.4,5,null,"07",2,64,1005.2,-0.9,4]
["08",2,54,1019,4.5,5,null,"08",3,61,1005.4,-1.1000000000000001,5]
["09",2,45,1018.8,3.9,6,null,"09",3,62,1005.5,-0.8,7]
["10",3,40,1018.6,3,5,null,"10",3,55,1005.5,-0.5,7]
["11",2,40,1018.2,3.5,6,null,"11",3,55,1005.6,0,7]
["12",2,38,1017.9,3,6,null,"12",4,53,1006.5,-1.5,7]
["13",2,33,1017.5,1.6,7,null,"13",3,52,1006.7,-1,7]
["14",2,32,1017.2,1.3,7,null,"14",3,58,1007.2,0.4,7]
[15,1,35,1016.7,2.7,7,null,"15",2,52,1006.9,-0.2,7]
["16",1,34,1016.7,2.1,7,null,"16",2,53,1007.6,-0.1,7]
["17",2,36,1016.6,2.5,7,null,"17",3,53,1008.1,-0.8,6]
["18",2,41,1016.7,2.7,6,null,"18",1,57,1008.6,-0.1,5]
["19",0,46,1016.7,2.9,4,null,"19",2,60,1009.1,0,6]
["20",2,59,1017.1,4.5999999999999996,4,null,"20",2,66,1009.5,0.3,5]
["21",1,63,1017.4,4.3,3,null,"21",2,68,1010.1,0,6]
["22",1,67,1017.3,4.4000000000000004,3,null,"22",2,74,1010.4,0.9,4]
["23",1,77,1017.5,3.9,2,null,"23",2,74,1010.8,0.4,1]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.3},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":56.6},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1018},{"$f":"AVERAGE(E3:E26)","v":2.3166666666666669},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":4.2},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":2.1},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":63.6},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1006.3},{"$f":"AVERAGE(L3:L26)","v":-0.49166666666666664},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":5.5}]
[]
[null,null,null,null,"2016-04-30",null,null,null,null,null,null,"2016-04-27"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",3,75,1010.9,0.5,2,null,"00",0,85,1018.7,-0.4,0]
["01",2,74,1011.3,0.6,1,null,"01",0,87,1018.9,-0.6,0]
["02",2,76,1011.7,1.1000000000000001,6,null,"02",0,87,1019,-1.2,0]
["03",2,75,1012.1,1.1000000000000001,7,null,"03",1,89,1019.2,-1.4,0]
["04",2,77,1012.2,0.1,7,null,"04",1,89,1019.2,-1.5,0]
["05",2,77,1012.3,-0.1,4,null,"05",0,90,1019.6,-1.5,0]
["06",3,74,1013.1,0.2,5,null,"06",1,89,1020.1,0.4,2]
["07",3,68,1013.6,0.6,7,null,"07",1,86,1020.4,2,1]
["08",3,64,1013.8,0.8,6,null,"08",1,77,1020.6,4.3,1]
["09",3,58,1013.8,0.7,6,null,"09",3,48,1020.5,0.7,2]
["10",2,56,1014.2,0.4,7,null,"10",3,47,1020.6,1.1000000000000001,3]
["11",3,50,1014.3,-0.3,6,null,"11",3,47,1020.5,2,2]
["12",2,50,1014.1,0.8,6,null,"12",2,45,1020.3,1.6,2]
["13",2,48,1014.1,0.2,5,null,"13",2,42,1020,1.7,3]
["14",3,41,1014.2,-0.9,4,null,"14",2,44,1019.8,1,4]
["15",3,56,1014.5,2.6,4,null,"15",2,42,1019.7,1.8,4]
["16",3,55,1014.9,1.3,5,null,"16",2,42,1019.4,1.8,3]
["17",2,58,1015.3,1.1000000000000001,5,null,"17",2,42,1019.1,1.3,2]
["18",2,56,1015.6,0.3,2,null,"18",2,44,1018.9,1,2]
["19",1,60,1016.1,0.4,2,null,"19",1,50,1019.2,1.2,3]
["20",1,72,1016.9,0.8,2,null,"20",1,56,1019.3,1,2]
["21",2,72,1017.4,0.7,1,null,"21",1,63,1019.4,0.7,2]
["22",0,80,1017.7,0.2,1,null,"22",1,70,1019.5,0.8,1]
["23",0,85,1018.2,-0.1,1,null,"23",1,74,1019.5,0.7,2]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":2.1},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":64.900000000000006},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1014.3},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":0.5},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":4.3},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.4},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":64},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1019.6},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":0.8},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":1.7}]
[]
[null,null,null,null,"2016-04-28",null,null,null,null,null,null,"2016-04-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:","April",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.",4.0999999999999996,8.9,0.7,0,70,90,5.7,0.1,"S;R",null,1.7,1020,2.7,1,1,"D",1,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.",8.1,15.6,-0.8,-4.7,35,68,4.4000000000000004,".",null,null,9.9,1022,1.4,2,0,null,null,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":0},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":6},{"$f":"COUNTIF(I6:I15,\">=1\")","v":3},{"$f":"COUNTIF(I6:I15,\">=3\")","v":1},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",12.6,19.2,6.5,2,48,62,5.5,".",null,null,8.6999999999999993,1013.9,5,2,0,null,null,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":6},{"$f":"COUNTIF(I18:I27,\">=1\")","v":5},{"$f":"COUNTIF(I18:I27,\">=3\")","v":3},{"$f":"COUNTIF(I18:I27,\">=10\")","v":1},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",13.8,20.2,6.8,2.2999999999999998,49,72,6.3,".",null,null,2.7,1008,8.6999999999999993,1,0,null,null,null,null,null,3,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":4},{"$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.",15.4,24.7,7.3,3,44,77,5.9,1.8,"R",null,8.5,1005.9,10.9,1,0,null,1,1,null,null,5]
["06.",12,16.3,9.4,"-",44,71,5.0999999999999996,0.6,"R",null,4.8,1010.2,6.6,2,0,null,1,null,1,null,7,null,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",10.9,13.7,8.1,3.2,57,70,5.4,0.2,"R",null,0.9,1009.9,5.6,2,0,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":1},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":2},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":1}]
["08.",9.6999999999999993,13.8,6,"-",45,65,7,".",null,null,3.2,1011.5,3.2,1,0,null,null,null,null,null,3,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":5},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",7.9,12.7,3,0.2,53,72,6.1,5.2,"R",null,1.1000000000000001,1010.1,2.9,1,0,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(D30:D39,\"<0\")","v":1},{"$f":"COUNTIF(D30:D39,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F39,\">=70\")","v":0},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":4}]
["10.",6.5,8.1999999999999993,5.2,5.2,86,92,8,1.2,"R",null,".",1014.6,5.3,1,0,null,1,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":101.00000000000001},{"$f":"SUM(C6:C15)","v":153.29999999999998},{"$f":"SUM(D6:D15)","v":52.2},{"$f":"SUM(E6:E15)","v":11.2},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":9.1},"XX",null,{"$f":"SUM(L6:L15)","v":41.5},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":6},{"$f":"SUM(S6:S15)","v":1},{"$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":10.100000000000001},{"$f":"AVERAGE(C6:C15)","v":15.329999999999998},5.2200000000000006,1.4,"XXX",73.900000000000006,5.94,"XXX","XX",null,{"$f":"L16/10","v":4.1500000000000004},{"$f":"AVERAGE(M6:M15)","v":1012.61},{"$f":"AVERAGE(N6:N15)","v":5.2299999999999995},{"$f":"AVERAGE(O6:O15)","v":1.4},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":0.1},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4.5},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":1},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":1},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",8.3000000000000007,11.2,5.2,2.1,83,89,7.9,".",null,null,".",1015.7,6.5,1,0,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":2},{"$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.",12.5,18.2,8.1,5.6,53,78,5.9,1.4,"R",null,6.7,1011.2,8.4,1,0,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":0},{"$f":"COUNTIF(L30:L39,\"<1\")","v":2},{"$f":"COUNTIF(L30:L39,\">=10\")","v":3},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",11.8,18.8,6.9,5.8,54,85,6.1,13.1,"R",null,6.3,1007,9.1,1,0,null,1,1,1,null,7]
["14.",9.4,12.7,9,8.1999999999999993,74,89,6.5,3.1,"R",null,1.3,1009.8,7.8,2,0,null,1,null,null,null,5,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",8.6,13.6,2.7,0.1,75,88,5.6,1.6,"R",null,0.3,1008.3,6.6,2,0,null,1,null,null,null,5,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":15.4},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":24.7},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-4.7},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":13.1}]
["16.",11.9,15.3,10.3,5.4,70,81,6.8,9.9,"R",null,0.1,1004.6,8.6,2,0,null,1,null,1,null,6,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",8.3000000000000007,10.3,7.3,3.2,85,92,7.5,0.3,"R",null,".",1009,7.5,1,0,null,1,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":3.9},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":-0.8},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":32},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":1}]
["18.",8.1999999999999993,12.9,4.0999999999999996,0.9,52,76,4,".",null,null,5.2,1019.6,3.9,1,0,null,null,null,null,null,3]
["19.",8.6,12.3,3.4,-0.5,57,70,5.8,0,null,null,0.5,1022.4,3.3,2,0,null,null,null,null,null,5]
["20.",7.4,12.1,3.5,"-",54,70,4,".",null,null,4.7,1028.5,2.2999999999999998,2,0,null,null,null,null,null,5]
["Su",{"$f":"SUM(B18:B27)","v":95},{"$f":"SUM(C18:C27)","v":137.4},{"$f":"SUM(D18:D27)","v":60.5},{"$f":"SUM(E18:E27)","v":30.8},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":29.400000000000002},"XX",null,{"$f":"SUM(L18:L27)","v":25.1},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":6},{"$f":"SUM(S18:S27)","v":1},{"$f":"SUM(T18:T27)","v":2},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":9.5},{"$f":"AVERAGE(C18:C27)","v":13.74},6.05,3.4222222222222225,65.7,81.8,6.01,"XXX","XX",null,{"$f":"L28/10","v":2.5100000000000002},{"$f":"AVERAGE(M18:M27)","v":1013.61},{"$f":"AVERAGE(N18:N27)","v":6.3999999999999995},{"$f":"AVERAGE(O18:O27)","v":1.5},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4.9000000000000004}]
["21.",9,16.8,0.6,-2.5,46,71,0,".",null,null,11.3,1024.7,3.5,1,0,null,null,null,null,null,3]
["22.",8.6,14.1,3.4,0.6,39,68,3,".",null,null,11.1,1017.4,2.5,2,0,null,null,null,null,null,4]
["23.",5.3,10.8,2.2999999999999998,0.2,65,83,7,2.7,"R",null,0.8,1010.2,2.6,2,0,null,1,null,null,null,4]
["24.",3.9,8.6999999999999993,1.1000000000000001,-0.7,57,80,4.9000000000000004,0.2,"G;R",null,3,1010.3,0.6,2,0,null,1,null,null,null,5]
["25.",4.4000000000000004,9.4,1.2,-1,44,71,4.7,0.4,"G;R",null,3.7,1009,-0.7,2,0,null,1,null,null,null,5]
["26.",5.4,8.6999999999999993,3.4,-1,52,74,5.8,1.6,"R",null,0.9,1001.3,0.9,3,0,null,1,null,1,null,6]
["27.",6.1,9.5,2,-1.8,49,64,5.5,0,"R",null,2.6,1006.3,-0.5,2,0,null,null,null,1,null,6]
["28.",6.8,12.3,1.8,"-",39,65,4.3,0,"R",null,7.6,1014.3,0.5,2,0,null,null,1,1,null,6]
["29.",8,15.1,-0.3,-3.8,40,64,1.7,".",null,null,11,1019.6,0.8,2,0,null,null,null,null,null,5]
["30.",11.6,18.8,2.6,"-",32,57,4.2,".",null,null,8.1999999999999993,1018,2.2999999999999998,1,0,null,null,null,null,null,5]
["Su",{"$f":"SUM(B30:B39)","v":69.099999999999994},{"$f":"SUM(C30:C39)","v":124.19999999999999},{"$f":"SUM(D30:D39)","v":18.100000000000001},{"$f":"SUM(E30:E39)","v":-10},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":4.9000000000000004},"XX",null,{"$f":"SUM(L30:L39)","v":60.2},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":4},{"$f":"SUM(S30:S39)","v":1},{"$f":"SUM(T30:T39)","v":3},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":6.9099999999999993},{"$f":"AVERAGE(C30:C39)","v":12.419999999999998},{"$f":"AVERAGE(D30:D39)","v":1.81},{"$f":"AVERAGE(E30:E39)","v":-1.25},"XXX",{"$f":"AVERAGE(G30:G39)","v":69.7},{"$f":"AVERAGE(H30:H39)","v":4.1100000000000012},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1013.11},{"$f":"AVERAGE(N30:N39)","v":1.25},{"$f":"AVERAGE(O30:O39)","v":1.9},{"$f":"AVERAGE(P30:P39)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":4.9000000000000004}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":265.10000000000002},{"$f":"SUM(C16+C28+C40)","v":414.9},{"$f":"SUM(D16+D28+D40)","v":130.80000000000001},{"$f":"SUM(E16+E28+E40)","v":32},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I40)","v":43.4},"XX",null,{"$f":"SUM(L16+L28+L40)","v":126.8},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R40)","v":16},{"$f":"SUM(S16+S28+S40)","v":3},{"$f":"SUM(T16+T28+T40)","v":7},{"$f":"SUM(U16+U28+U40)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":8.8366666666666696},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C39)","v":13.830000000000002},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D39)","v":4.3599999999999994},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E39)","v":1.2800000000000002},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G39)","v":75.13333333333334},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H39)","v":5.3533333333333335},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1013.11},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":4.293333333333333},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":1.6},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P39),1)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":4.7666666666666666}]
[]
[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":16},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":3}]
["TTT",9,"XXXX",{"$f":"SUM(B43-B47)","v":-0.16333333333333044},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":10},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":6}]
["RRR",42,{"$f":"SUM(I42*100/B48)","v":103.33333333333333},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":4},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":3}]
["sss",170,{"$f":"SUM(L42*100/B49)","v":74.588235294117652},"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":1}]
["mgl.",414,{"$f":"SUM(L42*100/B51)","v":30.628019323671499},"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":2},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":7},">/= 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":5}]
[]
[]
[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:","April",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,"-"," -",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-",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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-",1,1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",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,1,"-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,1,"-"]
["30.","-","-","-","-",1,1,"-"]
["Su.",{"$f":"SUM(B9:B38)","v":"00:00:00"},0,4,9,30,15,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39)","v":15}]

{"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)"]
[]
["April 2016"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":24.7},"am","2016-04-05"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":8.8366666666666696},{"$f":"Kurztabelle!B47","v":9},{"$f":"C7-D7","v":-0.16333333333333044},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":-0.8},"am","2016-04-02"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":43.4},{"$f":"Kurztabelle!B48","v":42},{"$f":"100/D9*C9","v":103.33333333333333},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":126.8},{"$f":"Kurztabelle!B49","v":170},{"$f":"100/D10*C10","v":74.588235294117652},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2016-04-01",4.0999999999999996,8.9,0.7,0.1,1,1.7,1020,6.7,null,null,"Von 06:20 Uhr - 07:29 Uhr mäßiger Schneeregen (WW 69). Von 07:30 Uhr - 07:39 Uhr leichter Schneeregen (WW 68). Von 03:10 Uhr - 03:59 Uhr; 04:20 Uhr - 06:19 Uhr mäßiger Regen (WW 63). Von 00:40 Uhr - 01:09 Uhr; 03:00 Uhr - 03:09 Uhr; 04:00 Uhr - 04:19 Uhr leichter Regen (WW 61)."]
["2016-04-02",8.1,15.6,-0.8,null,0,9.9,1022,6.85,"Sa","H Leo"]
["2016-04-03",12.6,19.2,6.5,null,null,8.6999999999999993,1013.9,7]
["2016-04-04",13.8,20.2,6.8,null,null,2.7,1008,7.15,"TrW","T Luana"]
["2016-04-05",15.4,24.7,7.3,1.8,null,8.5,1005.9,7.3,null,null,"Von 23:40 Uhr - 23:59 Uhr mäßiger Regen (WW 63). Um 22:30 Uhr, Von 22:45 Uhr - 23:04 Uhr; 23:30 Uhr - 23:39 Uhr leichter Regen (WW 61). Um 15:50 Uhr Regentropfen (WW 60). Von 16:34 Uhr - 17:09 Uhr leichtes Gewitter in der Ferne (WW 17). Von 17:10 Uhr - 18:09 Uhr; 20:20 Uhr - Gegen 21:40 Uhr leichtes Wetterleuchten (WW 13)."]
["2016-04-06",12,16.3,9.8000000000000007,0.6,null,4.8,1010.2,7.45,"TrM","T Myrna","Von 00:00 Uhr - 00:19 Uhr; 00:50 Uhr - 02:19 Uhr; 11:30 Uhr - 11:59 Uhr mäßiger Regen (WW 63). Von 00:20 Uhr - 00:49 Uhr leichter Regen (WW 61)."]
["2016-04-07",10.9,13.7,8.1,0.2,null,0.9,1009.9,7.6,null,null,"Gegen 11:00 Uhr; Von 11:30 Uhr - 11:44 Uhr; 12:10 Uhr - 12:39 Uhr leichter Regen (WW 61)."]
["2016-04-08",9.6999999999999993,13.8,6,null,null,3.2,1011.5,7.75,null,"T Ninotschka"]
["2016-04-09",7.9,12.7,3,5.2,null,1.1000000000000001,1010.1,7.9,"Ww","T Ortrun","Von 23:10 Uhr - 23:59 Uhr leichter Regen (WW 61)."]
["2016-04-10",6.5,8.1999999999999993,5.2,1.2,null,null,1014.6,8.0500000000000007,null,null,"Von 01:20 Uhr - 04:59 Uhr; 05:30 Uhr - 07:49 Uhr mäßiger Regen (WW 63). Von 00:00 Uhr - 01:19 Uhr; 05:00 Uhr - 05:29 Uhr; 07:50 Uhr - 11:59 Uhr leichter Regen (WW 61). Von 13:00 Uhr - Gegen 14:30 Uhr Regentropfen (WW 60). Von 18:10 Uhr - 19:14 Uhr mäßiger Sprühregen (WW 53)."]
["2016-04-11",8.3000000000000007,11.2,5.2,null,null,null,1015.7,8.1999999999999904,"TB"]
["2016-04-12",12.5,18.2,8.1,1.4,null,6.7,1011.2,8.3499999999999908,"SWz",null,"Von 20:50 Uhr - 21:09 Uhr mäßiger Regenschauer (WW 81). "]
["2016-04-13",11.8,18.8,6.9,13.1,null,6.3,1007,8.4999999999999893,null,null,"Von 15:38 Uhr - 15:40 Uhr mäßiges Gewitter mit Regen (WW 95). Von 15:34 Uhr - 15:37 Uhr; 15:41 Uhr - 16:19 Uhr leichtes Gewitter mit Regen (WW 95). Von 20:50 Uhr - 21:19 Uhr mäßiger Regenschauer (WW 81). Von 20:20 Uhr - 20:49 Uhr; 21:20 Uhr - 22:59 Uhr leichter Regenschauer (WW 80). Von 15:25 Uhr - 15:33 Uhr Trockengewitter (WW 17)."]
["2016-04-14",9.4,12.7,9,3.1,null,1.3,1009.8,8.6499999999999897,"Ws","T Petra","Von 19:10 Uhr - 19:29 Uhr mäßiger Regenschauer (WW 81). Von 12:50 Uhr - 13:09 Uhr; 14:30 Uhr - 14:39 Uhr; 18:20 Uhr - 18:39 Uhr leichter Regenschauer (WW 80)."]
["2016-04-15",8.6,13.6,2.7,1.6,null,0.3,1008.3,8.7999999999999901,"Wz",null,"Von 13:30 Uhr - 13:59 Uhr; 14:40 Uhr - 14:49 Uhr; 19:20 Uhr - 19:39 Uhr mäßiger Regen (WW 63). Von 13:10 Uhr - 13:29 Uhr; 14:00 Uhr - 14:39 Uhr; 14:50 Uhr - Uhr leichter Regen (WW 61)."]
["2016-04-16",11.9,15.3,10.3,9.9,null,0.1,1004.6,8.9499999999999904,null,null,"Von 09:30 Uhr - 09:59 Uhr; 10:35 Uhr - 10:54 Uhr; 11:50 Uhr - 12:09 Uhr leichter Regen (WW 61)."]
["2016-04-17",8.3000000000000007,10.3,7.3,0.3,null,5.2,1009,9.0999999999999908,"NWz",null,"Von 03:50 Uhr - 04:09 Uhr starker Regen (WW 65). Von 02:40 Uhr - 03:49 Uhr; 04:10 Uhr - 07:59 Uhr mäßiger Regen (WW 63). Von 12:20 Uhr - 13:04 Uhr leichter Regen (WW 61). Von 13:05 Uhr - 13:09 Uhr Regentropfen (WW 60). Von 08:00 Uhr - 08:29 Uhr mäßigen Sprühregen (WW 53)."]
["2016-04-18",8.1999999999999993,12.9,4.0999999999999996,null,null,null,1019.6,9.2499999999999893,"NWa","H Norbert"]
["2016-04-19",8.6,12.3,3.4,null,null,0.5,1022.4,9.3999999999999897,null,null,"Gegen 12:00 Uhr Regentropfen (WW 60)."]
["2016-04-20",7.4,12.1,3.5,null,null,4.7,1028.5,9.5499999999999901]
["2016-04-21",9,16.8,0.6,null,null,11.3,1024.7,9.6999999999999904,"BM"]
["2016-04-22",8.6,14.1,3.4,null,null,11.1,1017.4,9.8499999999999908,"Na"]
["2016-04-23",5.3,10.8,2.2999999999999998,2.7,null,0.8,1010.2,9.9999999999999893,"NWz","T Stefanie","Von 15:20 Uhr - 15:39 Uhr; 16:00 Uhr - 16:19 Uhr; 16:40 Uhr - 16:59 Uhr; 17:40 Uhr - 18:59 Uhr mäßiger Regen (WW 63). Von 14:40 Uhr - 15:19 Uhr; 15:40 Uhr - 15:59 Uhr; 16:20 Uhr - 16:39 Uhr; 17:00 Uhr - 17:39 Uhr; 19:00 Uhr - 19:59 Uhr leichter Regen (WW 61). Von 13:50 Uhr - 14:49 Uhr Regentropfen (WW 60)."]
["2016-04-24",3.9,8.6999999999999993,1.1000000000000001,0.2,null,3,1010.3,10.15,"TrM","T Uta","Gegen 10:00 Uhr; 11:00 Uhr; 11:30 Uhr - 11:39 Uhr; Um 12:40 Uhr; 13:40 Uhr leichter Graupelschauer (WW 87). Von 12:00 Uhr - 12:14 Uhr; 16:20 Uhr - 16:39 Uhr leichter Schneeregenschauer (WW 83)."]
["2016-04-25",4.4000000000000004,9.4,1.2,0.4,null,3.7,1009,10.3,null,null,"Von 09:55 Uhr - 10:04 Uhr leichter Graupelschauer (WW 87). Von 18:00 Uhr - 18:04 Uhr leichter Regen (WW 61)."]
["2016-04-26",5.4,8.6999999999999993,3.4,1.6,null,0.9,1001.3,10.45,null,null,"Von 09:20 Uhr - 10:09 Uhr mäßiger Regen (WW 63). Von 06:30 Uhr - 09:19 Uhr; 10:10 Uhr - 10:49 Uhr leichter Regen (WW 61)."]
["2016-04-27",6.1,9.5,2,null,null,2.6,1006.3,10.6,null,null,"Von 17:00 Uhr - 17:19 Uhr; 19:05 Uhr - 19:09 Uhr leichter Regenschauer (WW 80)."]
["2016-04-28",6.8,12.3,1.8,null,null,7.6,1014.3,10.75,null,"T Viola","Um 12:30 Uhr; 16:20 Uhr leichter Regenschauer (WW 80). Von 16:31 Uhr - 16:44 Uhr leichtes  Ferngewitter (WW 17)."]
["2016-04-29",8,15.1,-0.3,null,null,11,1019.6,10.9,"SWa","H Oliver"]
["2016-04-30",11.6,18.8,2.6,null,null,8.1999999999999993,1018,11.05]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":8.8366666666666696},{"$f":"AVERAGE(C2:C31)","v":13.830000000000002},{"$f":"AVERAGE(D2:D31)","v":4.3733333333333331},"-",null,{"$f":"AVERAGE(G2:G31)","v":4.6962962962962953},{"$f":"AVERAGE(H2:H31)","v":1013.11},{"$f":"AVERAGE(I2:I31)","v":8.8749999999999964}]
["Mittel",9,null,null,42,"-",170,1014.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]