{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1","Erdbodentem."],"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,89,1020.2,3.1,1,null,"00",1,82,1017.6,2.1,5]
["01",2,90,1020.5,2.8,1,null,"01",2,79,1017.2,2.2999999999999998,5]
["02",1,93,1021,2,0,null,"02",2,79,1016.9,2.1,5]
["03",1,94,1021.6,1.7,1,null,"03",1,83,1016.7,2.1,5]
["04",2,93,1021.8,2,3,null,"04",1,84,1016.1,2.5,5]
["05",2,93,1021.9,1.8,1,null,"05",1,88,1015.9,2.2000000000000002,7]
["06",2,92,1022.3,2.7,1,null,"06",0,84,1016.1,2.8,7]
["07",1,89,1022.4,4.4000000000000004,1,null,"07",1,79,1015.8,4.9000000000000004,7]
["08",2,81,1022.7,4.8,2,null,"08",2,62,1015.4,4.4000000000000004,5]
["09",1,71,1022.7,3.7,3,null,"09",2,56,1015,4.9000000000000004,7]
["10",1,60,1022.8,2.2000000000000002,3,null,"10",2,55,1014.6,6.6,7]
["11",1,60,1022.4,3.2,4,null,"11",2,55,1014.4,5.9,8]
["12",1,53,1021.9,1.9,5,null,"12",2,53,1014.4,4.7,7]
["13",1,60,1021.2,5.0999999999999996,5,null,"13",2,74,1014.3,9.1999999999999993,7]
["14",1,55,1020.6,4,5,null,"14",2,65,1013.5,8.5,7]
[15,1,53,1019.6,4,5,null,"15",2,61,1012.9,7.7,6]
["16",1,54,1019,4.0999999999999996,6,null,"16",2,62,1012.4,7.6,5]
["17",2,53,1018.4,3.1,7,null,"17",2,58,1012,6.5,4]
["18",2,60,1018.2,4.5999999999999996,7,null,"18",2,61,1011.9,6.4,5]
["19",2,64,1018.1,3.9,7,null,"19",1,72,1011.7,6.8,7]
["20",2,72,1018.2,4,7,null,"20",2,74,1011.6,6.1,7]
["21",2,73,1018,3.3,7,null,"21",2,72,1010.9,5.8,6]
["22",1,82,1017.8,3.2,7,null,"22",2,76,1011.2,6.3,7]
["23",1,83,1017.5,2.7,5,null,"23",0,83,1011,6.4,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":73.599999999999994},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1020.5},{"$f":"AVERAGE(E3:E26)","v":3.2625000000000006},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":3.9},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1.6},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":70.7},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1014.1},{"$f":"AVERAGE(L3:L26)","v":5.2},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":6.2}]
[]
[null,null,null,null,"2015-04-29",null,null,null,null,null,null,"2015-04-30"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,90,1005.2,9.8000000000000007,7,null,"00",2,98,1004.1,8.9,7]
["01",0,94,1004.4,9.6999999999999993,3,null,"01",2,98,1004.5,8,8]
["02",1,95,1004,9.5,1,null,"02",2,98,1004.7,7,8]
["03",1,94,1003.3,9,0,null,"03",2,98,1005.2,5.9,8]
["04",0,95,1002.7,8.1,3,null,"04",1,98,1005.3,5.8,7]
["05",1,96,1002.2,8.8000000000000007,5,null,"05",1,97,1006.3,5.7,8]
["06",0,95,1001.9,9.5,2,null,"06",1,97,1006.7,5.7,8]
["07",1,89,1001.5,11.4,5,null,"07",2,97,1007.2,5.8,8]
["08",1,85,1001.3,13.4,7,null,"08",2,95,1008,4.9000000000000004,8]
["09",1,76,1001.3,13.5,7,null,"09",3,96,1008.8,4.7,8]
["10",2,75,1001.7,13.5,6,null,"10",2,96,1010.2,4.0999999999999996,8]
["11",1,64,1001.7,12.5,5,null,"11",2,96,1011.3,2.9,8]
["12",1,59,1001.2,13,5,null,"12",2,97,1012.4,2.4,8]
["13",1,56,1000.5,13.4,5,null,"13",2,97,1013.3,1.6,8]
["14",1,46,999.6,11.6,4,null,"14",2,98,1014.1,3.2,8]
["15",2,44,999.1,11.5,7,null,"15",1,97,1014.7,4.5,8]
["16",3,59,999.3,12.5,8,null,"16",1,96,1015.1,4.7,8]
["17",3,86,1001.4,11.6,8,null,"17",1,94,1015.5,5.2,8]
["18",3,95,1002.1,11.3,8,null,"18",1,94,1016,5.7,7]
["19",2,96,1002,10.199999999999999,8,null,"19",1,95,1016.7,5.4,7]
["20",1,97,1003.4,10.199999999999999,8,null,"20",1,97,1017.7,4.7,6]
["21",2,97,1003.8,9.8000000000000007,8,null,"21",1,95,1018.1,4.3,7]
["22",2,98,1003.6,9.9,8,null,"22",1,95,1018.6,3.8,6]
["23",2,98,1003.8,9.6,8,null,"23",1,95,1019.6,3.4,4]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.4},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":82.5},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1002.1},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":11},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":5.7},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.5},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":96.4},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1011.4},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":4.9000000000000004},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":7.5}]
[]
[null,null,null,null,"2015-04-27",null,null,null,null,null,null,"2015-04-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:","April",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.",3.6,6.7,1.3,0,68,80,7.4,6.2,"R;H",null,1.4,1008,0.6,3,null,null,1,1,1,1,8,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.",2.2000000000000002,5.2,0.7,0,77,91,7,9,"S;R",null,1.2,1009.1,0.9,3,3,"D",1,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":7},{"$f":"COUNTIF(I6:I15,\">=1\")","v":3},{"$f":"COUNTIF(I6:I15,\">=3\")","v":2},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",4,7.2,2.2000000000000002,1.1000000000000001,67,80,6.5,0.4,"G",null,1.2,1018,0.8,3,0,"V",1,null,1,null,6,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":5},{"$f":"COUNTIF(I18:I27,\">=1\")","v":1},{"$f":"COUNTIF(I18:I27,\">=3\")","v":0},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",3.4,9.3000000000000007,-0.9,-2.8,47,78,4.8,0.6,"R",null,4.7,1015.9,-0.2,1,null,null,1,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":4},{"$f":"COUNTIF(I30:I39,\">=1\")","v":4},{"$f":"COUNTIF(I30:I39,\">=3\")","v":3},{"$f":"COUNTIF(I30:I39,\">=10\")","v":2},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",3.2,8.1999999999999993,-1.6,-2.8,54,77,2.8,".",null,null,3.7,1021.6,-0.6,1,null,null,null,null,null,null,4]
["06.",2.8,6.6,-0.4,-2.2000000000000002,66,83,5.6,2,"G;R",null,1.8,1026.5,0.1,1,0,"V",1,null,null,null,5,null,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",6.2,11.8,-0.9,-2.8,48,72,4.9000000000000004,0.9,"R",null,5.9,1033.0999999999999,1,2,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":4},{"$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.",7.2,8.1999999999999993,6.5,5,76,86,8,0.1,"R",null,".",1030.7,5.0999999999999996,2,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":0},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":0},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":6}]
["09.",9.8000000000000007,15.6,5.9,5,56,78,4.8,".",null,null,8.8000000000000007,1029.2,6,2,null,null,null,null,null,null,5,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":1},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":4}]
["10.",11.7,18.899999999999999,3.8,2.2000000000000002,46,73,0.5,".",null,null,9.1999999999999993,1022.6,6.5,1,null,null,null,null,null,null,2]
["Su",{"$f":"SUM(B6:B15)","v":54.100000000000009},{"$f":"SUM(C6:C15)","v":97.699999999999989},16.600000000000001,2.7,"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":19.2},"XX",null,{"$f":"SUM(L6:L15)","v":37.9},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":7},{"$f":"SUM(S6:S15)","v":1},3,1,"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":5.410000000000001},{"$f":"AVERAGE(C6:C15)","v":9.77},1.6600000000000001,0.27,"XXX",79.8,5.2299999999999995,"XXX","XX",null,{"$f":"L16/10","v":3.79},{"$f":"AVERAGE(M6:M15)","v":1021.47},{"$f":"AVERAGE(N6:N15)","v":2.02},1.9,{"$f":"ROUND(AVERAGE(P6:P15),1)","v":1},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":5},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":1},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":1},{"$f":"COUNTIF(P6:P15,\">=3\")","v":1},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",14.4,22.1,7.2,3.9,28,64,4.9000000000000004,0.9,"R",null,4.7,1019,6.6,2,null,null,1,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$f":"COUNTIF(L18:L27,\">=10\")","v":1},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",10.8,15.7,6.1,4.4000000000000004,38,64,6.1,".",null,null,7,1027.3,3.9,2,null,null,null,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":1},{"$f":"COUNTIF(L30:L39,\"<1\")","v":1},{"$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.",10.1,13.2,5.7,3.9,37,60,5,0.1,"R",null,3.9,1025.7,2.8,3,null,null,1,null,1,null,7]
["14.",10.3,15.6,2.4,1.1000000000000001,35,62,4.7,".",null,null,8.3000000000000007,1025.8,2.7,2,null,null,null,null,null,null,5,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",16.600000000000001,23.1,10.4,6.7,31,56,2.5,".",null,null,9.9,1015.9,7.2,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":16.600000000000001},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":24.8},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-2.8},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":17}]
["16.",12,15.2,8.4,6.1,56,72,7,1.1000000000000001,"R",null,3.6,1012.7,7.2,2,null,null,1,null,null,null,4,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",8.1999999999999993,12.6,4.9000000000000004,2.8,51,69,6,0.3,"R",null,2.1,1014.5,2.8,2,null,null,1,null,null,null,4,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":2.2000000000000002},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":-1.6},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":28},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":3}]
["18.",6.2,9.8000000000000007,2.7,0.6,53,71,5.5,0.1,"G",null,1.7,1022.9,1.3,2,null,null,1,null,null,null,4]
["19.",7.6,14.6,0,-1.7,41,66,2.1,".",null,null,9.5,1022.6,1,1,null,null,null,null,null,null,4]
["20.",10.7,17.8,2.7,1.1000000000000001,39,62,2.8,".",null,null,10,1023.5,3.2,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B18:B27)","v":106.90000000000002},{"$f":"SUM(C18:C27)","v":159.69999999999999},50.5,28.900000000000006,"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":2.5},"XX",null,{"$f":"SUM(L18:L27)","v":60.7},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":0},3,0,"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":10.690000000000001},{"$f":"AVERAGE(C18:C27)","v":15.969999999999999},5.05,2.8900000000000006,40.9,64.599999999999994,4.66,"XXX","XX",null,{"$f":"L28/10","v":6.07},{"$f":"AVERAGE(M18:M27)","v":1020.99},{"$f":"AVERAGE(N18:N27)","v":3.8699999999999997},2,{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":5}]
["21.",12.7,20.399999999999999,3.1,0.6,33,56,0.8,".",null,null,10.4,1024.8,3.1,2,null,null,null,null,1,null,6]
["22.",7.8,12.1,3.5,1.1000000000000001,52,71,4.3,".",null,null,0.7,1024.0999999999999,2.9,2,null,null,null,null,null,null,4]
["23.",9.8000000000000007,17.899999999999999,1.7,0,48,74,0.6,".",null,null,10.6,1018.8,4.9000000000000004,1,null,null,null,null,null,null,3]
["24.",13.1,21.2,4.2,2.8,38,66,1,".",null,null,10.1,1013.8,6,1,null,null,null,null,null,null,4]
["25.",15.1,21.1,6.6,3.9,35,61,5.8,".",null,null,3.8,1009.6,7,2,null,null,null,null,null,null,5]
["26.",15.4,20.8,11.3,9.3000000000000007,52,75,6.3,1.3,"R",null,3.1,1007.2,11.1,1,null,null,1,1,null,null,4]
["27.",14.4,24.8,8.6999999999999993,7.2,40,82,5.7,17,"R",null,5,1002.1,11,1,null,null,1,1,1,null,6]
["28.",5.3,9.1999999999999993,1.7,1.1000000000000001,95,96,7.5,14.5,"R",null,".",1011.4,4.9000000000000004,2,null,null,1,null,null,null,5]
["29.",8.1,13.8,2.5,0.6,45,74,3.9,".",null,null,9.6999999999999993,1020.5,3.9,2,null,null,null,null,null,null,3]
["30.",10.6,16.600000000000001,3.9,2.8,49,71,6.2,6.8,"R",null,3.6,1014.1,5.2,2,null,null,1,null,null,null,5]
["Su",{"$f":"SUM(B30:B39)","v":112.3},{"$f":"SUM(C30:C39)","v":177.89999999999998},{"$f":"SUM(D30:D39)","v":47.2},{"$f":"SUM(E30:E39)","v":29.400000000000006},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":39.599999999999994},"XX",null,{"$f":"SUM(L30:L39)","v":56.999999999999993},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":4},{"$f":"SUM(S30:S39)","v":2},{"$f":"SUM(T30:T39)","v":2},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":11.23},{"$f":"AVERAGE(C30:C39)","v":17.79},{"$f":"AVERAGE(D30:D39)","v":4.7200000000000006},{"$f":"AVERAGE(E30:E39)","v":2.9400000000000004},"XXX",{"$f":"AVERAGE(G30:G39)","v":72.599999999999994},{"$f":"AVERAGE(H30:H39)","v":4.21},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1014.64},{"$f":"AVERAGE(N30:N39)","v":6},{"$f":"AVERAGE(O30:O39)","v":1.6},{"$f":"ROUND(AVERAGE(P30:P39),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":4.5}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":273.3},{"$f":"SUM(C16+C28+C40)","v":435.29999999999995},{"$f":"SUM(D16+D28+D40)","v":114.3},{"$f":"SUM(E16+E28+E40)","v":61.000000000000014},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I40)","v":61.3},"XX",null,{"$f":"SUM(L16+L28+L40)","v":155.6},"XXX","XXX","XXX",{"$f":"SUM(P16+P28+P40)","v":{"$error":"#VALUE!"}},"X",{"$f":"SUM(R16+R28+R40)","v":16},{"$f":"SUM(S16+S28+S40)","v":3},{"$f":"SUM(T16+T28+T40)","v":8},{"$f":"SUM(U16+U28+U40)","v":1},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":9.1100000000000012},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C39)","v":14.509999999999998},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D39)","v":3.81},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E39)","v":2.0333333333333332},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G39)","v":72.333333333333329},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H39)","v":4.6999999999999993},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1019.0333333333331},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":3.9633333333333338},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":1.8333333333333333},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P39),1)","v":1},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":4.833333333333333}]
[]
[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":2}]
["TTT",9,"XXXX",{"$f":"SUM(B43-B47)","v":0.11000000000000121},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":8},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":1}]
["RRR",42,{"$f":"SUM(I42*100/B48)","v":145.95238095238096},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":4}]
["sss",170,{"$f":"SUM(L42*100/B49)","v":91.529411764705884},"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":0},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":1}]
["mgl.",414,{"$f":"SUM(L42*100/B51)","v":37.584541062801932},"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":1}]
["sss",null,null,"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":4},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":10}]
[]
[]
[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:",2015]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","-","-","-","-",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,1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-","-",1,1," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-","-","-",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.","-","-","-","-",1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-","-",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,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-",1,1,1,"-"]
["30.","-","-","-","-",1,"-","-"]
["Su.",{"$f":"SUM(B9:B38)","v":"00:00:00"},0,3,8,30,11,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":11}]

{"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 2015"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":24.8},"am","2015-04-27"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":9.1100000000000012},{"$f":"Kurztabelle!B47","v":9},{"$f":"C7-D7","v":0.11000000000000121},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":-1.6},"am","2015-04-05"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":61.3},{"$f":"Kurztabelle!B48","v":42},{"$f":"100/D9*C9","v":145.95238095238093},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":155.6},{"$f":"Kurztabelle!B49","v":170},{"$f":"100/D10*C10","v":91.529411764705884},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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"]
["2015-04-01",3.6,6.7,1.3,6.2,0,1.4,1008,6.7,"NWz",null,"Gegen 19:20 Uhr leichter Hagelschauer (WW 89). Gegen 13:40 Uhr; 15:20 Uhr leichtes Gewitter mit Graupel (WW 96). Gegen 12:40 Uhr starker Regenschauer/mäßiger Graupelschauer  (WW 81 & WW 87). Gegen 03:00 Uhr; 09:30 Uhr; 10:30 Uhr; 12:00 Uhr mäßiger Regenschauer (WW 81)."]
["2015-04-02",2.2000000000000002,5.2,0.7,9,3,1.2,1009.1,6.85,null,"T Oskar","Gegen 13:30 Uhr; 15:00 Uhr leichter Graupelschauer (WW 87). Von 16:10 Uhr - 16:49 Uhr; 17:20 Uhr - 17:29 Uhr mäßiger Schneeschauer (WW 86). Von 03:20 Uhr - 04:09 Uhr; 08:00 Uhr - 11:09 Uhr mäßiger Schneefall (WW 73). Von 11:10 Uhr - 11:59 Uhr leichter Schneefall. Von 04:30 Uhr - 04:49 Uhr starker Regen (WW 65). Von 02:20 Uhr - 03:10 Uhr; 04:10 Uhr - 04:29 Uhr; 04:50 Uhr - 07:59 Uhr mäßiger Regen (WW 63)."]
["2015-04-03",4,7.2,2.2000000000000002,0.4,0,1.2,1018,7,"HB","H Ostra","Gegen 14:30 Uhr leichter Graupelschauer (WW 87)."]
["2015-04-04",3.4,9.3000000000000007,-0.9,0.6,null,4.7,1015.9,7.15,null,null,"Gegen 15:10 Uhr leichter Regenschauer (WW 81)."]
["2015-04-05",3.2,8.1999999999999993,-1.6,null,null,3.7,1021.6,7.3]
["2015-04-06",2.8,6.6,-0.4,2,null,1.8,1026.5,7.45,null,null,"Gegen 12:00 Uhr; 13:00 Uhr leichter Graupelschauer (WW 87). Gegen 15:20 Uhr leichter Regenschauer (WW 81). Von 08:10 Uhr - 09:09 Uhr mäßiger Schneefall (WW 73).Von 08:01 Uhr - 08:09 Uhr; 09:10 Uhr - 09:19 Uhr leichter Schneefall (WW 71)."]
["2015-04-07",6.2,11.8,-0.9,0.9,null,5.9,1033.0999999999999,7.6]
["2015-04-08",7.2,8.1999999999999993,6.5,0.1,null,null,1030.7,7.75,"HM",null,"Von 02:50 Uhr - 03:39 Uhr mäßiger Regen (WW 63). Von 06:50 Uhr - 09:09 Uhr; Gegen 14:30 Uhr leichter Sprühregen (WW 51)."]
["2015-04-09",9.8000000000000007,15.6,5.9,null,null,8.8000000000000007,1029.2,7.9]
["2015-04-10",11.7,18.899999999999999,3.8,null,null,9.1999999999999993,1022.6,8.0500000000000007,"SWa"]
["2015-04-11",14.4,22.1,7.2,0.9,null,4.7,1019,8.1999999999999904]
["2015-04-12",10.8,15.7,6.1,null,null,7,1027.3,8.3499999999999908,"HM","H Padma","Von 02:00 Uhr - 02:39 Uhr leichter Regenschauer (WW 80)."]
["2015-04-13",10.1,13.2,5.7,0.1,null,3.9,1025.7,8.4999999999999893,"NWz","T Stefan","Gegen 08:00 Uhr leichter Regenschauer (WW 80)."]
["2015-04-14",10.3,15.6,2.4,null,null,8.3000000000000007,1025.8,8.6499999999999897,"Wa","H Padma"]
["2015-04-15",16.600000000000001,23.1,10.4,null,null,9.9,1015.9,8.7999999999999901]
["2015-04-16",12,15.2,8.4,1.1000000000000001,null,3.6,1012.7,8.9499999999999904,"NWa ","H Quila","Von 19:30 Uhr - 19:59 Uhr mäßiger Regen (WW 63). Von 20:00 Uhr - Uhr leichter Regen (WW 61)."]
["2015-04-17",8.1999999999999993,12.6,4.9000000000000004,0.3,null,2.1,1014.5,9.0999999999999908]
["2015-04-18",6.2,9.8000000000000007,2.7,0.1,null,1.7,1022.9,9.2499999999999893,"HNa",null,"Gegen 11:10 Uhr leichter Graupelschauer (WW 87). Gegen 02:30 Uhr leichter Regen (WW 61)."]
["2015-04-19",7.6,14.6,0,null,null,9.5,1022.6,9.3999999999999897]
["2015-04-20",10.7,17.8,2.7,null,null,10,1023.5,9.5499999999999901]
["2015-04-21",12.7,20.399999999999999,3.1,null,null,10.4,1024.8,9.6999999999999904,"HB"]
["2015-04-22",7.8,12.1,3.5,null,null,0.7,1024.0999999999999,9.8499999999999908]
["2015-04-23",9.8000000000000007,17.899999999999999,1.7,null,null,10.6,1018.8,9.9999999999999893,"U"]
["2015-04-24",13.1,21.2,4.2,null,null,10.1,1013.8,10.15,"SWz","T Vasco"]
["2015-04-25",15.1,21.1,6.6,null,null,3.8,1009.6,10.3]
["2015-04-26",15.4,20.8,11.3,1.3,null,3.1,1007.2,10.45,null,null,"Gegen 14:10 Uhr leichtes Gewitter mit Regen (WW 95). Gegen 18:10 Uhr mäßiger Regenschauer (WW 81). Gegen 12:40 Uhr leichter Regenschauer (WW 80)."]
["2015-04-27",14.4,24.8,8.6999999999999993,17,null,5,1002.1,10.6,null,null,"Von 16:45 Uhr - 18:12 Uhr leichtes Gewitter mit Regen (WW 95). Von 16:26 Uhr - 16:44 Uhr; 18:13 Uhr -19:01 Uhr leichter Regen Gewitter hörbar (WW 91). Von 19:02 Uhr - 20:59 Uhr mäßiger Regenschauer (WW 81). Von 16:15 Uhr - 16:25 Uhr; 21:00 Uhr - 21:29 Uhr leichter Regenschauer (WW 80). "]
["2015-04-28",5.3,9.1999999999999993,1.7,14.5,null,null,1011.4,10.75,"Ws",null,"Von 12:20 Uhr - 12:59 Uhr mäßiger Schneeregen (WW 69). Von 09:00 Uhr - 09:09 Uhr; 10:20 Uhr - 11:09 Uhr starker Regen (WW 65). Von 08:30 Uhr - 08:59 Uhr; 09:10 Uhr - 10:19 Uhr; 11:10 Uhr - 12:19 Uhr; 13:00 Uhr - 14:19 Uhr mäßiger Regen (WW 63). Von 05:00 Uhr - 08:29 Uhr; 14:20 Uhr - 14:29 Uhr leichter Regen (WW 61).Vor 05:00 Uhr Regen, undefiniert (WW 60 - 63)."]
["2015-04-29",8.1,13.8,2.5,null,null,9.6999999999999993,1020.5,10.9,"Wz"]
["2015-04-30",10.6,16.600000000000001,3.9,6.8,null,3.6,1014.1,11.05,null,null,"Von 12:10 Uhr - 12:39 Uhr mäßiger Regenschauer (WW 81). Von 23:30 Uhr - 23:59 Uhr starker Regen (WW 65)."]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":9.1100000000000012},{"$f":"AVERAGE(C2:C31)","v":14.509999999999998},{"$f":"AVERAGE(D2:D31)","v":3.81},"-",null,{"$f":"AVERAGE(G2:G31)","v":5.5571428571428569},{"$f":"AVERAGE(H2:H31)","v":1019.0333333333331},{"$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]

{"sheet":"Erdbodentem.","index":6,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[16,1,16,2],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[16,3,16,4],[14,3,14,4],[15,3,15,4],[14,1,14,2],[15,1,15,2],[14,5,14,6],[15,5,15,6],[16,5,16,6],[4,6,4,7],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,7,7,7],[6,5,7,6],[6,0,7,0],[13,5,13,6],[8,1,8,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[13,3,13,4],[12,5,12,6],[23,1,23,2],[24,1,24,2],[18,1,18,2],[17,3,17,4],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[19,3,19,4],[20,3,20,4],[17,1,17,2],[23,3,23,4],[24,3,24,4],[18,3,18,4],[21,3,21,4],[22,3,22,4],[17,5,17,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[25,1,25,2],[30,1,30,2],[26,1,26,2],[27,1,27,2],[28,5,28,6],[29,5,29,6],[26,5,26,6],[27,5,27,6],[30,3,30,4],[28,1,28,2],[29,1,29,2],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[27,3,27,4],[30,5,30,6],[31,5,31,6],[34,5,34,6],[33,3,33,4],[32,5,32,6],[33,5,33,6],[31,3,31,4],[32,3,32,4],[34,3,34,4],[31,1,31,2],[32,1,32,2],[33,1,33,2],[35,5,35,6],[35,3,35,4],[37,5,37,6],[36,5,36,6],[36,3,36,4],[37,3,37,4],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","April",null,null,null,"Jahr:",2015]
[]
["Dat.","7 Uhr","8Uhr","12 Uh","13 Uhr","19 Uhr",null,"NN","10 °C - "]
[null,null,null,null,null,null,null,null,"Eindringtiefe"]
["01.","-",null,"-",null,"-",null,"-","-"]
["02.","-",null,"-",null,"-",null,"-","-"]
["03.","-",null,"7,8 °C/-/8,3 °C",null,"-",null,"t","< 10 °C"]
["04.","-",null,"-",null,"-",null,"-","-"]
["05.","-",null,"-",null,"-",null,"-","-"]
["06.","-",null,"-",null,"-",null,"-","-"]
["07.","-",null,"-",null,"-",null,"-","-"]
["08.","6,6 °C/-/7,9 °C",null,"-",null,"-",null,"t","< 10 °C"]
["09.","6,8 °C/-/8,1 °C",null,"13,2 °C/-/8,2 °C",null,"-",null,"n","Bis 36 cm"]
["10.","5,2 °C/-/9,0 °C",null,"17,2 °C/-/9,0 °C",null,"-",null,"h","Bis 45 cm"]
["11.","-",null,"-",null,"-",null,"-","-"]
["12.","-",null,"-",null,"-",null,"-","-"]
["13.","9,2 °C/-/-",null,"-",null,"-",null,"n","-"]
["14.","-",null,"-",null,"-",null,"-","-"]
["15.","-",null,"-",null,"-",null,"-","-"]
["16.","-",null,"-",null,"-",null,"-","-"]
["17.","-",null,"-",null,"-",null,"-","-"]
["18.","-",null,"-",null,"-",null,"-","-"]
["19.","-",null,"-",null,"-",null,"-","-"]
["20.","-",null,"-",null,"-",null,"-","-"]
["21.","-",null,"-",null,"-",null,"-","-"]
["22.","-",null,"-",null,"-",null,"-","-"]
["23.","-",null,"-",null,"-",null,"-","-"]
["24.","-",null,"-",null,"-",null,"-","-"]
["25.","-",null,"-",null,"-",null,"-","-"]
["26.","-",null,"-",null,"-",null,"-","-"]
["27.","-",null,"-",null,"-",null,"-","-"]
["28.","-",null,"-",null,"-",null,"-","-"]
["29.","-",null,"-",null,"-",null,"-","-"]
["30.","-",null,"-",null,"-",null,"-","-"]
[]
[null,"Temperatur - 10 cm/Temperatur - 20 cm/Temperatur -50 cm"]