{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Modul1","index":5,"reason":"part_missing"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mittelhilfstabelle","index":0,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,82,1003.7,5.2,7,null,"00",3,69,1012.4,2.6,1]
["01",3,76,1004.2,4.7,6,null,"01",2,75,1012.9,2.7,3]
["02",3,78,1004,4.5999999999999996,6,null,"02",3,77,1012.4,3.4,4]
["03",3,78,1004,4.5999999999999996,5,null,"03",3,75,1012.1,2.8,6]
["04",3,79,1003.7,4.8,8,null,"04",3,76,1011.5,3,7]
["05",2,85,1004.3,5.3,7,null,"05",3,75,1011.5,3.3,8]
["06",2,79,1005.4,4,7,null,"06",2,76,1011.1,3.6,8]
["07",2,79,1006.3,3.8,3,null,"07",2,80,1010.8,4.8,8]
["08",3,73,1006.5,4.2,6,null,"08",2,82,1010.4,5.3,8]
["09",4,66,1007,3.7,6,null,"09",2,72,1009.9,5.6,8]
["10",4,58,1007.7,2.5,6,null,"10",3,65,1010.1,6.6,8]
["11",3,69,1008.6,3.3,7,null,"11",3,61,1010.3,6,8]
["12",4,55,1008.5,2.4,6,null,"12",3,60,1010.5,6.1,8]
["13",4,54,1008.7,2.2000000000000002,6,null,"13",2,63,1010.7,6.3,8]
["14",4,54,1009.1,2.2999999999999998,6,null,"14",2,66,1010.8,6.6,8]
[15,4,54,1009,1.4,5,null,"15",3,79,1011.2,7.8,8]
["16",2,49,1010,3.1,4,null,"16",2,92,1011.7,8.1,8]
["17",3,57,1010.2,2.5,2,null,"17",1,90,1011.6,8,7]
["18",2,57,1010.4,2,3,null,"18",2,87,1011.6,7.7,7]
["19",2,61,1010.8,1.5,2,null,"19",1,86,1011.9,7,7]
["20",1,68,1011.3,1.2,1,null,"20",2,85,1012.2,6.7,7]
["21",2,66,1011.8,1.6,3,null,"21",2,83,1012.3,6.2,7]
["22",2,71,1012,1.7,3,null,"22",2,82,1012.5,6,7]
["23",3,73,1012.1,2.7,2,null,"23",2,82,1012.7,6.2,7]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":2.8},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":67.5},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1007.9},{"$f":"AVERAGE(E3:E26)","v":3.1374999999999997},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":4.9000000000000004},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":2.2999999999999998},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":76.599999999999994},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1011.5},{"$f":"AVERAGE(L3:L26)","v":5.5166666666666666},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":6.9}]
[]
[null,null,null,null,"2016-03-29",null,null,null,null,null,null,"2016-03-30"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,84,1012.8,6.2,6,null,"00",0,83,1013.2,4.5999999999999996,8]
["01",2,87,1012.3,5.6,7,null,"01",1,87,1013.3,4.7,8]
["02",2,88,1012.9,5.7,7,null,"02",1,87,1013.1,4.5999999999999996,8]
["03",1,89,1012.7,5.6,8,null,"03",1,87,1012.7,4.0999999999999996,7]
["04",1,91,1012.5,5.4,8,null,"04",1,86,1012.6,2.8,3]
["05",1,91,1012.5,5.2,8,null,"05",0,89,1011.9,2.5,2]
["06",0,93,1012.9,5.6,8,null,"06",0,88,1011.5,2,2]
["07",1,95,1013.4,6.1,8,null,"07",1,90,1011,3.1,1]
["08",1,97,1013,6.8,8,null,"08",1,82,1010.6,4.5,2]
["09",0,96,1013.2,7.4,8,null,"09",1,70,1009.8,5.8,3]
["10",0,95,1012.9,8.5,8,null,"10",2,62,1009,5.9,6]
["11",1,94,1012.7,8.1999999999999993,8,null,"11",2,62,1008.2,6.4,4]
["12",1,89,1012.8,8.1999999999999993,8,null,"12",2,59,1007.1,7,6]
["13",1,88,1012.9,8.4,8,null,"13",3,58,1006.3,7.1,7]
["14",1,86,1012,8.9,8,null,"14",3,59,1005.2,7.4,7]
["15",2,85,1011.9,7.8,8,null,"15",3,59,1004.7,6.9,8]
["16",2,85,1011.6,7.3,8,null,"16",3,60,1004.3,7,8]
["17",2,86,1011.3,7.1,8,null,"17",3,58,1003.4,6.4,8]
["18",1,85,1011.4,6.6,8,null,"18",2,53,1002.9,4.5,6]
["19",2,87,1011.2,6.1,8,null,"19",3,53,1003.5,4.3,7]
["20",2,88,1011.6,5.5,8,null,"20",2,65,1003,5.0999999999999996,2]
["21",2,89,1011.4,5.4,8,null,"21",3,69,1002.7,5.8,6]
["22",2,93,1012.6,4.8,8,null,"22",4,73,1004.6,6,8]
["23",2,96,1012.5,4.3,8,null,"23",3,84,1004.6,5.9,7]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.3},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":89.9},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1012.4},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":6.5},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":7.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.9},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":71.8},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1007.9},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":5.2},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":5.6}]
[]
[null,null,null,null,"2016-03-31",null,null,null,null,null,null,"2016-03-28"]

{"sheet":"Kurztabelle","index":1,"n_rows":113,"n_cols":35,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,12,1,13]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","März",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.",-1,0.9,-4.9000000000000004,-8.3000000000000007,91,95,6.4,0.5,"S;R",null,".",1017.3,-1.6,1,15,"*",1,null,null,null,4,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.",2.7,6.8,-4.2,"-",80,90,7.7,0.4,"R",null,1.3,1004,1.1000000000000001,2,11,"*",1,null,null,null,5,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":5},{"$f":"COUNTIF(I6:I15,\">=1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=3\")","v":1},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",3.1,6.1,0.2,-3.6,66,83,7.3,".",null,null,".",1002.9,0.4,1,0,"R",null,null,null,null,3,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":1},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",2.6,8.3000000000000007,-2.2999999999999998,-6,51,78,4.0999999999999996,".",null,null,5.2,1004.6,-1.1000000000000001,2,0,"R",null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":0},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":9},{"$f":"COUNTIF(I30:I40,\">=1\")","v":7},{"$f":"COUNTIF(I30:I40,\">=3\")","v":2},{"$f":"COUNTIF(I30:I40,\">=10\")","v":1},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",5.0999999999999996,9.1,1.4,-2.1,67,80,7.7,3.8,"R",null,3.6,997.2,1.9,2,0,null,1,null,null,null,5]
["06.",4.2,8.1999999999999993,1.6,-0.1,67,84,6.5,0.5,"R",null,0.8,998.4,1.7,2,0,null,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.",3,6.9,-0.1,-4.5999999999999996,63,83,4.8,1.5,"G;R",null,2.2999999999999998,1004.8,0.3,1,0,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":6},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":5},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",2.4,5.7,-0.3,"-",70,86,7.2,0,"S;R",null,".",1013.8,0.2,1,0,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":3},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":6},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",1.6,6.3,-3,-6.5,73,88,4.8,".",null,null,6.4,1015.1,-0.3,1,0,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":0},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":4},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":1}]
["10.",4.0999999999999996,6.4,2,-0.4,82,88,7.8,".",null,null,".",1018.2,2.2999999999999998,0,0,null,null,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":27.799999999999997},{"$f":"SUM(C6:C15)","v":64.7},{"$f":"SUM(D6:D15)","v":-9.6000000000000032},{"$f":"SUM(E6:E15)","v":-31.6},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":6.7},"XX",null,{"$f":"SUM(L6:L15)","v":19.600000000000001},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":6},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":0},{"$f":"SUM(U6:U15)","v":0},"XXX",null,null,null,null,"ohne Sonne","Son. 0,1-0,9","Son.  >=10,0",null,"Sch. >=1 cm","Sch. >=3 cm","Sch. >=10 cm"]
["Mi",{"$f":"AVERAGE(B6:B15)","v":2.78},{"$f":"AVERAGE(C6:C15)","v":6.4700000000000006},-0.9600000000000003,-3.95,"XXX",85.5,6.43,"XXX","XX",null,{"$f":"L16/10","v":1.9600000000000002},{"$f":"AVERAGE(M6:M15)","v":1007.6300000000001},{"$f":"AVERAGE(N6:N15)","v":0.48999999999999994},{"$f":"AVERAGE(O6:O15)","v":1.3},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":2.6},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4.0999999999999996},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":4},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":2},{"$f":"COUNTIF(P6:P15,\">=3\")","v":2},{"$f":"COUNTIF(P6:P15,\">=10\")","v":2}]
["11.",4.4000000000000004,6.4,3.1,2,76,86,8,".",null,null,".",1026.5999999999999,2.2999999999999998,1,0,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":5},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":1},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",3.1,4,2.6,2.4,85,90,8,0,"R",null,".",1030.5,1.7,2,0,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":2},{"$f":"COUNTIF(L30:L40,\"<1\")","v":4},{"$f":"COUNTIF(L30:L40,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":0},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",2,2.7,1,"-",93,95,8,0.3,"R",null,".",1034.5999999999999,1.3,1,0,null,1,null,null,null,3]
["14.",2.4,6.1,-0.8,-3.5,65,83,6.7,5.0999999999999996,"R;S",null,3.1,1033.7,-0.7,1,0,null,1,null,null,null,3,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",2.6,4.3,0.4,0,79,89,8,0.1,"G",null,".",1025.9000000000001,1.1000000000000001,2,2,"D",1,null,null,null,4,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":10.4},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":17.899999999999999},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-8.3000000000000007},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":15.3}]
["16.",4,8.9,0.2,"-",61,80,3.8,".",null,null,5.8,1030.9000000000001,0.8,2,0,null,null,null,null,null,4,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",4.5,12.4,-2.2999999999999998,-5.6,48,77,0,".",null,null,9.1,1028.4000000000001,0.3,1,0,null,null,null,null,null,3,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":-1},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":-4.9000000000000004},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":37},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":15}]
["18.",3.8,10.199999999999999,-0.6,-4.8,59,84,4.0999999999999996,0.3,"R",null,7.9,1019.5,1.2,2,0,null,1,null,null,null,5]
["19.",4.9000000000000004,8.6999999999999993,2.6,-3.4,71,88,6.8,".",null,null,0.5,1019.4,3.1,1,0,null,null,null,null,null,4]
["20.",5.0999999999999996,6.8,3.8,"-",74,81,8,0.3,"R",null,".",1016,2,2,0,null,1,null,1,null,6]
["Su",{"$f":"SUM(B18:B27)","v":36.800000000000004},{"$f":"SUM(C18:C27)","v":70.5},{"$f":"SUM(D18:D27)","v":10},{"$f":"SUM(E18:E27)","v":-12.9},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":6.0999999999999988},"XX",null,{"$f":"SUM(L18:L27)","v":26.4},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":6},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":1},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":3.6800000000000006},{"$f":"AVERAGE(C18:C27)","v":7.05},1,-1.842857142857143,71.099999999999994,85.3,6.14,"XXX","XX",null,{"$f":"L28/10","v":2.6399999999999997},{"$f":"AVERAGE(M18:M27)","v":1026.5499999999997},{"$f":"AVERAGE(N18:N27)","v":1.31},{"$f":"AVERAGE(O18:O27)","v":1.5},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":0.2},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3.8}]
["21.",5.4,7.5,3.3,0.3,77,87,7.5,3.8,"R",null,0.2,1014.3,3.4,2,0,null,1,null,null,null,5]
["22.",5.4,8.1999999999999993,3.6,0.9,68,87,7.3,1,"R;G",null,0.2,1011,3.3,2,0,null,1,null,null,null,5]
["23.",5.5,8.6999999999999993,4.0999999999999996,2.8,70,88,7.7,2.8,"R",null,0.8,1008.7,3.6,1,0,null,1,null,null,null,4]
["24.",4.3,8.1,1.4,1,65,85,6.6,0.3,"R",null,2,1013,2,1,0,null,1,null,null,null,4]
["25.",5.9,9.3000000000000007,1.6,0.3,71,86,7.9,2.2000000000000002,"R",null,".",1013.3,3.6,1,0,null,1,null,null,null,4]
["26.",7.1,12.4,2.1,"-",61,85,5.5,".",null,null,1.8,1018.5,4.5999999999999996,1,0,null,null,null,null,null,4]
["27.",9.5,17.899999999999999,2.2999999999999998,-2.7,37,72,5.8,".",null,null,7.9,1013,4.3,2,0,null,null,null,1,null,7]
["28.",10.4,16.3,3.1,-0.8,50,72,5.6,1,"R",null,6.9,1007.9,5.2,2,0,null,1,null,1,null,6]
["29.",9,12.5,6.2,3.8,58,67,4.9000000000000004,0.3,"R",null,7.6,1007.9,3.1,3,0,null,1,null,null,null,7]
["30.",9.6,14.2,6.7,3.5,57,77,6.9,2,"R",null,0.5,1011.5,5.5,2,0,null,1,null,null,null,6]
["31.",8.1,11.2,4.7,"-",84,90,7.8,15.3,"R;S",null,".",1012.4,6.5,1,0,null,1,null,null,null,4]
["Su",{"$f":"SUM(B30:B40)","v":80.199999999999989},{"$f":"SUM(C30:C40)","v":126.3},{"$f":"SUM(D30:D40)","v":39.100000000000009},{"$f":"SUM(E30:E40)","v":9.1},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":28.700000000000003},"XX",null,{"$f":"SUM(L30:L40)","v":27.9},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":9},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":2},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":7.2909090909090901},{"$f":"AVERAGE(C30:C40)","v":11.481818181818182},{"$f":"AVERAGE(D30:D40)","v":3.5545454545454551},{"$f":"AVERAGE(E30:E40)","v":1.0111111111111111},"XXX",{"$f":"AVERAGE(G30:G40)","v":81.454545454545453},{"$f":"AVERAGE(H30:H40)","v":6.6818181818181817},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1011.9545454545455},{"$f":"AVERAGE(N30:N40)","v":4.1000000000000005},{"$f":"AVERAGE(O30:O40)","v":1.6363636363636365},{"$f":"AVERAGE(P30:P40)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":5.0909090909090908}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":144.79999999999998},{"$f":"SUM(C16+C28+C41)","v":261.5},{"$f":"SUM(D16+D28+D41)","v":39.500000000000007},{"$f":"SUM(E16+E28+E41)","v":-35.4},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":41.5},"XX",null,{"$f":"SUM(L16+L28+L41)","v":73.900000000000006},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":21},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":3},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":4.6709677419354838},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":8.435483870967742},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":1.2741935483870968},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":-1.4750000000000005},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":84},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":6.4258064516129041},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1015.2677419354841},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":2.0354838709677421},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.4838709677419355},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P40),1)","v":0.9},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":4.3303030303030301}]
[]
[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":19},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":11}]
["TTT",4.5,"XXXX",{"$f":"SUM(B44-B48)","v":0.17096774193548381},"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",45,{"$f":"SUM(I43*100/B49)","v":92.222222222222229},"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":0}]
["sss",113,{"$f":"SUM(L43*100/B50)","v":65.398230088495581},"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":3}]
["mgl.",366,{"$f":"SUM(L43*100/B52)","v":20.191256830601095},"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":2}]
["sss",null,null,"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":9},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":15},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":2}]
[null,null,null,null,"Tropennacht",null,null,null,0,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":1}]
[]
[]
[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":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","März",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-",{"$f":"IF(R13=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-",1,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.","02:00:00",1,1,1,1,"-","-",null,null,null,null,null,2," ",2,3,2]
["16.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-",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,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,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,1,1]
["30.","-","-","-","-",1,1,"-"]
["31.","-","-","-",1,1,"-","-"]
["Su.",{"$f":"SUM(B9:B39)","v":"02:00:00"},1,10,20,28,3,1]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":1}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":3}]

{"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)"]
[]
["März 2016"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":17.899999999999999},"am","2016-03-27"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":4.6709677419354838},{"$f":"Kurztabelle!B48","v":4.5},{"$f":"C7-D7","v":0.17096774193548381},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":-4.9000000000000004},"am","2016-03-01"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":41.5},{"$f":"Kurztabelle!B49","v":45},{"$f":"100/D9*C9","v":92.222222222222229},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":73.900000000000006},{"$f":"Kurztabelle!B50","v":113},{"$f":"100/D10*C10","v":65.398230088495581},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":120,"n_cols":12,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2016-03-01",-1,0.9,-4.9000000000000004,0.4,15,null,1017.3,1.5,"(TrM)","T Aloisia","Von 02:30 Uhr - 02:49 Uhr; 05:20 Uhr - 07:14 Uhr mäßiger Regen (WW 73). Von 00:00 Uhr - 02:29 Uhr; 02:50 Uhr - 05:19 Uhr; 07:15 Uhr - 09:29 Uhr leichter Schneefall (WW 71). Von 09:30 Uhr - 10:14 Uhr Schneeflocken (WW 70)."]
["2016-03-02",2.7,6.8,-4.2,0.4,11,1.3,1004,1.65,null,null,"Von 02:45 Uhr - 03:19 Uhr; Um 10:15 Uhr; 11:00 Uhr; Von 17:25 Uhr - 19:14 Uhr leichter Regen (WW 61)."]
["2016-03-03",3.1,6.1,0.2,null,0,null,1002.9,1.8,null,null,"Morgens Elbtalnebel (WW 40)."]
["2016-03-04",2.6,8.3000000000000007,-2.2999999999999998,null,null,5.2,1004.6,1.95,"U","T Bianca","Morgens Elbtalnebel (WW 40)."]
["2016-03-05",5.0999999999999996,9.1,1.4,3.8,null,3.6,997.2,2.15,"TrM"]
["2016-03-06",4.2,8.1999999999999993,1.6,0.5,null,0.8,998.4,2.35,null,null,"Von 03:15 Uhr - 05:09 Uhr; 05:50 Uhr - 07:49 Uhr mäßiger Regen (WW 63). Von 02:50 Uhr - 03:14 Uhr; 05:10 Uhr - 05:49 Uhr; 07:50 Uhr - 08:29 Uhr leichten Regen (WW 61)."]
["2016-03-07",3,6.9,-0.1,1.5,null,2.2999999999999998,1004.8,2.5499999999999998,null,null,"Von 13:00 Uhr - 13:19 Uhr leichter Graupelschauer (WW 87). Um 14:10 Uhr leichter Regenschauer (WW 80)."]
["2016-03-08",2.4,5.7,-0.3,null,null,null,1013.8,2.75,null,null,"Um 08:30 Uhr Schneeflocken (WW 70). Von 13:00 Uhr - 14:49 Uhr Regentropfen (WW 60)."]
["2016-03-09",1.6,6.3,-3,null,null,6.4,1015.1,2.95,"SEa","H Joachim","Morgens Nebelschwaden am Boden (WW 11)."]
["2016-03-10",4.0999999999999996,6.4,2,null,null,null,1018.2,3.15,"NEa"]
["2016-03-11",4.4000000000000004,6.4,3.1,null,null,null,1026.5999999999999,3.35]
["2016-03-12",3.1,4,2.6,null,null,null,1030.5,3.55,null,null,"Gegen 13:15 Uhr; 22:05 Uhr - 23:19 Uhr leichter Regen (WW 61). Gegen 08:15 Uhr leichter Sprühregen (WW 51)."]
["2016-03-13",2,2.7,1,0.3,null,null,1034.5999999999999,3.75,null,null,"Gegen 16:30 Uhr - Gegen 22:00 Uhr leichter Sprühregen (WW 51)."]
["2016-03-14",2.4,6.1,-0.8,5.0999999999999996,0,3.1,1033.7,3.95,"HB"]
["2016-03-15",2.6,4.3,0.4,0.1,2,null,1025.9000000000001,4.1500000000000004,null,null,"Von 20:20 Uhr - 20:29 Uhr leichter Graupelschauer (WW 87). Von 05:30 Uhr - 06:39 Uhr mäßiger Schneefall (WW 73). Von 06:40 Uhr - 06:59 Uhr leichter Schneefall (WW 71). Von 05:10 Uhr - 05:29 Uhr mäßiger Schneeregen (WW 69). Von 03:40 Uhr - 05:09 Uhr mäßiger Regen (WW 63). Von 02:50 Uhr - 03:39 Uhr leichter Regen (WW 61). Von 06:30 Uhr - 08:29 Uhr leichter Nebel (WW 45)."]
["2016-03-16",4,8.9,0.2,null,0,5.8,1030.9000000000001,4.3499999999999996,"BM"]
["2016-03-17",4.5,12.4,-2.2999999999999998,null,null,9.1,1028.4000000000001,4.55,"HB"]
["2016-03-18",3.8,10.199999999999999,-0.6,0.3,null,7.9,1019.5,4.75,"NWa"]
["2016-03-19",4.9000000000000004,8.6999999999999993,3.3,null,null,0.5,1019.4,4.9000000000000004,null,null,"Gegen 03:00 Uhr leichter Regen (WW 61)."]
["2016-03-20",5.0999999999999996,6.8,3.8,0.3,null,null,1016,5.05,"NWz","T Frauke","Von 20:25 Uhr - 20:39 Uhr mäßiger Regen (WW 63). Gegen 18:10 Uhr - 19:45 Uhr leichter Regen, unterbrochen (WW 60)."]
["2016-03-21",5.4,7.5,3.3,3.8,null,0.2,1014.3,5.2,null,null,"Von 12:26 Uhr - 12:30 Uhr; 20:50 Uhr - 21:09 Uhr; 21:50 Uhr - 22:09 Uhr mäßiger Regen (WW 63). Von 07:30 Uhr - 07:49 Uhr; 10:15 Uhr - 10:19 Uhr; 12:20 Uhr - 12:25 Uhr; 12:31 Uhr - 12:49 Uhr; Um 17:10 Uhr; 20:15 Uhr - 20:49 Uhr; 21:10 Uhr - 21:49 Uhr; 22:10 Uhr - 22:29 Uhr; 23:40 Uhr - 23:59 Uhr leichter Regen (WW 61). Von 11:55 Uhr - 12:19 Uhr Regentropfen (WW 60). Von 07:50 Uhr - 08:29 Uhr; 09:55 Uhr - 10:14 Uhr leichter Sprühregen (WW 51)."]
["2016-03-22",5.4,8.1999999999999993,3.6,1,null,0.2,1011,5.35,null,null,"Von 14:20 Uhr - 14:39 Uhr; 16:10 Uhr - 16:19 Uhr leichter Graupelschauer mit Regen (WW 87). Von 00:20 Uhr - 01:19 Uhr; 18:30 Uhr - 18:39 Uhr mäßiger Regen (WW 63). Von 00:00 Uhr - 00:19 Uhr; 01:20 Uhr - 02:49 Uhr; 10:30 Uhr - 10:49 Uhr leichter Regen (WW 61). Gegen 08:30 Uhr Regentropfen (WW 60)."]
["2016-03-23",5.5,8.6999999999999993,4.0999999999999996,2.8,null,0.8,1008.7,5.5,"U",null,"Von 17:50 Uhr - 17:59 Uhr starker Regen (WW 65). Von 16:50 Uhr - 17:04 Uhr; 18:00 Uhr - 18:04 Uhr; 18:30 Uhr - 18:59 Uhr mäßiger Regen (WW 63). Von 02:40 Uhr - 05:19 Uhr; 15:50 Uhr - 16:19 Uhr; 16:45 Uhr - 16:49 Uhr; 17:05 Uhr - 17:19 Uhr; 18:20 Uhr - 18:29 Uhr leichter Regen (WW 61). Von 15:30 Uhr - 15:49 Uhr Regentropfen (WW 60)."]
["2016-03-24",4.3,8.1,1.4,0.3,null,2,1013,5.65,"Wz","T Hedi","Von 00:50 Uhr - 01:49 Uhr mäßiger Regen (WW 63)."]
["2016-03-25",5.9,9.3000000000000007,1.6,2.2000000000000002,null,null,1013.3,5.8,null,null,"Von 20:10 Uhr - 20:49 Uhr mäßiger Regen (WW 63). Von 06:30 Uhr - 09:09 Uhr; 11:10 Uhr - 12:19 Uhr; 15:30 Uhr - 16:49 Uhr; 17:50 Uhr - 20:09 Uhr; 20:50 Uhr - 21:59 Uhr leichter Regen (WW 61). Von 09:10 Uhr - 09:19 Uhr; 11:00 Uhr - 11:09 Uhr; Zwischen 13:00 Uhr - 13:59 Uhr; 16:50 Uhr - 17:49 Uhr; 22:00 Uhr - 23:59 Uhr Regentropfen (WW 60)."]
["2016-03-26",7.1,12.4,2.1,null,null,1.8,1018.5,5.95,"SWa","H Kurt","Von 02:30 Uhr - 03:19 Uhr leichter Regen (WW 61). Von 06:10 Uhr - 07:39 Uhr leichter Regen, unterbrochen (WW 60)."]
["2016-03-27",9.5,17.899999999999999,2.2999999999999998,null,null,7.9,1013,6.1,"TrW","T Jeanne"]
["2016-03-28",10.4,16.3,3.1,1,null,6.9,1007.9,6.25,null,null,"Von 21:50 Uhr - 23:09 Uhr mäßiger Regen, unterbrochen (WW 62)."]
["2016-03-29",9,12.5,6.2,0.3,null,7.6,1007.9,6.4,null,null,"Von 04:30 Uhr - 04:44 Uhr mäßiger Regen (WW 63). Von 04:45 Uhr - 04:49 Uhr; 14:32 Uh; Um 15:15 Uhr leichter Regen (WW 61)."]
["2016-03-30",9.6,14.2,6.7,2,null,0.5,1011.5,6.55,null,"T Kerstin","Von 15:10 Uhr - 15:59 Uhr mäßiger Regen (WW 63). Von 07:20 Uhr - 08:39 Uhr; Gegen 12:50 Uhr; 14:30 Uhr - 15:09 Uhr; 16:00 Uhr - 16:09 Uhr leichter Regen (WW 61)."]
["2016-03-31",8.1,11.2,4.7,15.3,null,null,1012.4,6.7,"HNz",null,"Von 22:00 Uhr - 22:49 Uhr starker Regen (WW 65). Von 21:10 Uhr - 21:59 Uhr; 22:50 Uhr - 23:19 Uhr mäßiger Regen (WW 63). Von 06:00 Uhr - 07:39 Uhr mäßiger Regen, unterbrochen (WW 62). Von 07:40 Uhr - Gegen 09:00 Uhr; 11:40 Uhr - 12:09 Uhr  leichter Regen (WW 61)."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":4.6709677419354838},{"$f":"AVERAGE(C2:C32)","v":8.435483870967742},{"$f":"AVERAGE(D2:D32)","v":1.2967741935483872},"-",null,{"$f":"AVERAGE(G2:G32)","v":3.6949999999999994},{"$f":"AVERAGE(H2:H32)","v":1015.2677419354841},{"$f":"AVERAGE(I2:I32)","v":4.2129032258064516}]
["Mittel",4.5,null,null,45,"-",113,1016.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]