{"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",1,86,1028.0999999999999,1.5,0,null,"00",1,90,1022.3,1.2,2]
["01",1,87,1028.4000000000001,1.5,0,null,"01",1,90,1021.8,1.7,1]
["02",1,89,1028.4000000000001,1.1000000000000001,0,null,"02",1,89,1021.4,1.5,3]
["03",1,88,1028.3,0.7,0,null,"03",1,89,1021.1,1.5,3]
["04",1,90,1028,0.1,0,null,"04",1,89,1021.2,1.8,3]
["05",0,91,1028.2,-0.1,0,null,"05",1,89,1020.7,1.6,4]
["06",0,92,1028,-0.3,1,null,"06",1,89,1020.5,1.3,4]
["07",0,94,1028.2,-0.1,1,null,"07",1,90,1020.6,1.8,6]
["08",0,94,1028.7,0,5,null,"08",1,89,1020.6,2.5,7]
["09",1,95,1028.7,0.6,2,null,"09"]
["10",1,96,1028.5999999999999,3,2,null,"10"]
["11",2,65,1028,4.5999999999999996,1,null,"11"]
["12",3,54,1027.4000000000001,2.8,2,null,"12"]
["13",2,54,1026.5999999999999,3.3,2,null,"13"]
["14",2,55,1025.8,3.3,2,null,"14"]
[15,2,58,1025.2,3.2,2,null,"15"]
["16",2,63,1024.7,2.7,3,null,"16"]
["17",1,69,1024.5999999999999,2.2000000000000002,3,null,"17"]
["18",2,76,1024.5,1.9,2,null,"18"]
["19",1,82,1024,1.7,0,null,"19"]
["20",1,85,1023.7,1.7,0,null,"20"]
["21",1,86,1023.1,1,0,null,"21"]
["22",1,87,1023,1.1000000000000001,0,null,"22"]
["23",1,91,1022.8,1.6,2,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1.2},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":80.3},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1026.5},{"$f":"AVERAGE(E3:E26)","v":1.6291666666666667},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":1.3},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":89.3},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1021.1},{"$f":"AVERAGE(L3:L26)","v":1.6555555555555559},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":3.7}]
[]
[null,null,null,null,"2013-10-31",null,null,null,null,null,null,"2013-11-01"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",3,56,1007.8,7.4,7,null,"00",2,69,1017.5,4.5999999999999996,5]
["01",3,59,1008.3,7.7,8,null,"01",2,69,1017.8,4.5,6]
["02",2,61,1008.2,7.7,7,null,"02",2,69,1018.1,4.7,6]
["03",2,64,1008.9,7.8,5,null,"03",2,73,1018.2,4.7,7]
["04",2,65,1009.2,7.6,4,null,"04",2,74,1018.5,4.5999999999999996,7]
["05",2,67,1009.6,7.4,6,null,"05",2,76,1018.9,4.5,8]
["06",2,67,1010.2,7.2,6,null,"06",2,74,1019.1,4.7,8]
["07",2,67,1010.5,7.1,7,null,"07",2,77,1019.8,4.7,6]
["08",1,66,1011.1,6.9,8,null,"08",2,78,1020.6,4.8,6]
["09",1,67,1012,7.2,7,null,"09",2,78,1021.4,4.9000000000000004,6]
["10",3,61,1012.6,6.6,8,null,"10",2,70,1022.1,5.6,4]
["11",3,59,1012.8,6.6,7,null,"11",2,66,1022.7,5.0999999999999996,5]
["12",3,54,1012.7,5.8,7,null,"12",2,64,1022.7,5.5,6]
["13",2,56,1012.5,6.9,7,null,"13",2,63,1022.9,4,5]
["14",3,45,1012.4,4.5,6,null,"14",2,59,1023,3.8,4]
["15",3,47,1013.1,4.3,6,null,"15",1,63,1023.4,4.5999999999999996,2]
["16",2,51,1013.9,4.0999999999999996,4,null,"16",2,57,1023.6,3.3,2]
["17",1,55,1014.4,3.8,2,null,"17",1,66,1024.2,3.3,1]
["18",1,61,1015.3,3.9,2,null,"18",2,70,1025,3.1,1]
["19",2,61,1016,3.8,1,null,"19",2,75,1025.7,3.1,1]
["20",2,69,1016.3,3.8,0,null,"20",2,79,1026.4000000000001,2.6,0]
["21",2,69,1016.9,3.9,0,null,"21",2,76,1027,2.4,0]
["22",2,67,1017,4.0999999999999996,5,null,"22",1,81,1027.4000000000001,2,0]
["23",3,67,1017.3,4.7,7,null,"23",1,84,1027.8,2,0]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":2.2000000000000002},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":60.9},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1012.5},{"$f":"AVERAGE(E33:E56)","v":5.8666666666666663},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":5.3},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.8},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":71.3},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1022.2},{"$f":"AVERAGE(L33:L56)","v":4.0458333333333325},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":4}]
[]
[null,null,null,null,"2013-10-29",null,null,null,null,null,null,"2013-10-30"]

{"sheet":"Kurztabelle","index":1,"n_rows":54,"n_cols":34,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,18,1,19]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","Oktober",null,null,null,null,null,null,null,null,null,null,null,"Jahr:",2013]
[]
["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.",5.2,13.8,-0.2,-1.1000000000000001,56,83,1.8,".",null,null,2.8,1016.7,2.8,1,null,null,null,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"]
["02.",5.4,13.6,0.1,-0.6,48,78,1,".",null,null,3.8,1025,1.7,1,null,null,null,null,null,null,4,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":4},{"$f":"COUNTIF(I6:I15,\">=1\")","v":1},{"$f":"COUNTIF(I6:I15,\">=3\")","v":1},{"$f":"COUNTIF(I6:I15,\">=10\")","v":1}]
["03.",5.9,11.9,0.2,-1.7,45,72,0.3,".",null,null,4.9000000000000004,1028.2,0.6,1,null,null,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":8},{"$f":"COUNTIF(I18:I27,\">=1\")","v":6},{"$f":"COUNTIF(I18:I27,\">=3\")","v":3},{"$f":"COUNTIF(I18:I27,\">=10\")","v":1}]
["04.",8.1999999999999993,13.6,4.0999999999999996,2.2000000000000002,46,60,4,".",null,null,4.3,1024.3,0.7,1,null,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":3},{"$f":"COUNTIF(I30:I39,\">=1\")","v":1},{"$f":"COUNTIF(I30:I39,\">=3\")","v":0},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0}]
["05.",8.6,13.8,5.4,3.3,50,67,5.3,".",null,null,1.6,1019,2.8,0,null,null,null,null,null,null,3]
["06.",9.4,12,5.8,5,82,89,6.7,0.4,"R",null,".",1023.9,7.5,0,null,null,1,null,null,null,1,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.2,15.7,10.199999999999999,10,77,92,8,0.1,"R",null,".",1027.5,10.8,0,null,null,1,null,null,null,2,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":4},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",12.6,18.100000000000001,8.5,7.8,52,80,4.3,".",null,null,3.6,1024.7,8.9,1,null,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":7},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",11.6,15.1,8.3000000000000007,7.2,70,84,7.6,0.7,"R",null,".",1018,8.9,0,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(D30:D39,\"<0\")","v":0},{"$f":"COUNTIF(D30:D39,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F39,\">=70\")","v":2},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":0}]
["10.",10.7,14.9,7.3,7.2,76,89,7.8,19.899999999999999,"R",null,".",1007.3,9.1,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":89.799999999999983},{"$f":"SUM(C6:C15)","v":142.5},49.699999999999989,39.300000000000004,"XXX","XXX",{"$f":"SUM(H6:H15)","v":46.8},{"$f":"SUM(I6:I15)","v":21.099999999999998},"XX",null,{"$f":"SUM(L6:L15)","v":21.000000000000004},{"$f":"SUM(M6:M15)","v":10214.599999999999},53.800000000000004,6,{"$f":"COUNT(P6:P15)","v":0},"X",{"$f":"SUM(R6:R15)","v":4},{"$f":"SUM(S6:S15)","v":0},0,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":8.9799999999999986},{"$f":"AVERAGE(C6:C15)","v":14.25},4.9699999999999989,3.9300000000000006,"XXX",79.400000000000006,4.68,{"$f":"I16/10","v":2.11},"XX",null,{"$f":"L16/10","v":2.1000000000000005},{"$f":"AVERAGE(M6:M15)","v":1021.4599999999998},{"$f":"AVERAGE(N6:N15)","v":5.3800000000000008},0.6,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":2.9},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":4},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$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.",9.1,13.1,7.4,7.2,95,98,8,15.9,"R",null,".",1014,8.8000000000000007,0,null,null,1,null,null,null,2,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":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",10.4,13.6,8.1,7.8,92,97,7.5,7.3,"R",null,".",1018,10,0,null,null,1,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":0},{"$f":"COUNTIF(L30:L39,\"<1\")","v":1},{"$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.",8.6,12.9,3.5,2.8,68,91,4,".",null,null,2.5,1020.3,7.2,1,null,null,null,null,null,null,2]
["14.",8.9,15.8,2.7,1.1000000000000001,63,87,5.3,".",null,null,6.1,1020.1,6.6,1,null,null,null,null,null,null,3,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",10.199999999999999,13.3,7.2,5,77,86,6.7,5.0999999999999996,"R",null,".",1010.7,8,0,null,null,1,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":16.8},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":23.6},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-1.7},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":19.899999999999999}]
["16.",8.3000000000000007,10.199999999999999,6.2,3.9,87,94,7,2.2000000000000002,"R",null,".",1011.9,7.4,1,null,null,1,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",10.6,15.6,4.4000000000000004,2.2000000000000002,67,85,5.6,2.9,"R",null,2.2999999999999998,1011.9,7.9,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":5.2},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":-0.2},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":41},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",9.6999999999999993,11.8,4.5,2.8,74,85,6.9,0.4,"R",null,".",1016.9,7.4,1,null,null,1,null,null,null,5]
["19.",7.9,12.7,1.4,-0.6,72,87,2.5,0.1,"R",null,3.8,1018,5.7,0,null,null,1,null,null,null,3]
["20.",12.8,17.3,10.3,9.4,78,89,6.8,2,"R",null,0.3,1015.3,11.1,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B18:B27)","v":96.5},{"$f":"SUM(C18:C27)","v":136.30000000000001},55.7,41.599999999999994,"XXX","XXX",{"$f":"SUM(H18:H27)","v":60.3},{"$f":"SUM(I18:I27)","v":35.9},"XX",null,{"$f":"SUM(L18:L27)","v":15},{"$f":"SUM(M18:M27)","v":10157.099999999999},80.099999999999994,6,{"$f":"COUNT(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":8},{"$f":"SUM(S18:S27)","v":0},0,0,"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":9.65},{"$f":"AVERAGE(C18:C27)","v":13.63},5.57,4.1599999999999993,77.3,89.9,6.0299999999999994,{"$f":"I28/10","v":3.59},"XX",null,{"$f":"L28/10","v":1.5},{"$f":"AVERAGE(M18:M27)","v":1015.7099999999998},{"$f":"AVERAGE(N18:N27)","v":8.01},0.6,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3.1}]
["21.",14.9,19.600000000000001,11,8.9,64,82,6.6,".",null,null,2.8,1016.1,11.7,1,null,null,null,null,null,null,3]
["22.",14.3,21.1,9.1999999999999993,7.8,58,85,3.2,".",null,null,2.9,1014.3,11.6,1,null,null,null,null,null,null,3]
["23.",15.4,20.399999999999999,12.8,10.6,70,84,5.4,0.6,"R",null,1.1000000000000001,1010.6,12.8,1,null,null,1,null,null,null,3]
["24.",14.7,19.600000000000001,8.1999999999999993,6.6,62,78,3.7,".",null,null,1.8,1017.3,11,1,null,null,null,null,null,null,4]
["25.",11.6,17.7,6.4,5,76,90,5.8,".",null,null,1.5,1018.1,9.9,1,null,null,null,null,null,null,3]
["26.",16.5,23.6,12.1,10,55,79,5.8,0.1,"R",null,1.3,1014.3,12.5,1,null,null,1,null,null,null,5]
["27.",16.8,21.2,11.1,8.6,42,69,6.3,1.6,"R",null,1.8,1008.8,10.8,3,null,null,1,null,1,null,6]
["28.",16.8,22.2,12.3,13,41,63,6.3,".",null,null,0.5,1004.7,9.4,3,null,null,null,null,1,null,6]
["29.",13.2,16.5,8.9,6.1,44,61,5.3,".",null,null,1.7,1012.5,5.9,2,null,null,null,null,null,null,5]
["30.",8.9,12.4,3.6,1.7,56,71,4,".",null,null,1.3,1022.2,4,2,null,null,null,null,null,null,5]
["31.",5,12.6,0.7,-1.1000000000000001,51,80,1.3,".",null,null,2.9,1026.5,1.6,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B30:B40)","v":148.1},{"$f":"SUM(C30:C40)","v":206.89999999999998},96.3,77.2,"XXX",{"$f":"SUM(G30:G40)","v":842},{"$f":"SUM(H30:H40)","v":53.699999999999996},{"$f":"SUM(I30:I40)","v":2.2999999999999998},"XX",null,{"$f":"SUM(L30:L40)","v":19.599999999999998},{"$f":"SUM(M30:M40)","v":11165.400000000001},101.2,{"$f":"SUM(O30:O40)","v":17},{"$f":"COUNT(P30:P40)","v":0},"X",{"$f":"SUM(R30:R40)","v":3},{"$f":"SUM(S30:S40)","v":0},2,0,"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":13.463636363636363},{"$f":"AVERAGE(C30:C40)","v":18.809090909090909},8.754545454545454,7.0181818181818185,"XXX",{"$f":"AVERAGE(G30:G40)","v":76.545454545454547},{"$f":"AVERAGE(H30:H40)","v":4.8818181818181818},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M30:M40)","v":1015.0363636363637},{"$f":"AVERAGE(N30:N40)","v":9.2000000000000011},1.5454545454545454,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4.2727272727272725}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":334.4},{"$f":"SUM(C16+C28+C41)","v":485.7},{"$f":"SUM(D16+D28+D41)","v":201.7},{"$f":"SUM(E16+E28+E41)","v":158.10000000000002},"XXX","XXX,",{"$f":"SUM(H16+H28+H41)","v":160.79999999999998},{"$f":"SUM(I16+I28+I41)","v":59.3},"XX",null,{"$f":"SUM(L16+L28+L41)","v":55.599999999999994},{"$f":"SUM(M16+M28+M41)","v":31537.1},{"$f":"SUM(N16+N28+N41)","v":235.10000000000002},"XXX",{"$f":"SUM(P16+P28+P41)","v":0},"X",{"$f":"SUM(R16+R28+R41)","v":15},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":2},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":10.787096774193548},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":15.667741935483873},6.5064516129032253,5.0999999999999996,"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":81.774193548387103},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":5.1870967741935505},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1017.3258064516127},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":7.5838709677419374},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":0.93548387096774188},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":3.4242424242424243}]
[]
[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":15},"ohne Sonne",null,null,null,null,null,9]
["TTT",9.4,"XXXX",{"$f":"SUM(B44-B48)","v":1.387096774193548},"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,2]
["RRR",50,{"$f":"SUM(I43*100/B49)","v":118.6},"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",122,{"$f":"SUM(L43*100/B50)","v":45.573770491803273},"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","Min.d.Lufttemp.°C",null,null,null,null,null,null,">/=  20,0",null,null,0,">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",341,{"$f":"SUM(L43*100/B52)","v":16.304985337243398},"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":1},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","starker Eistag",null,null,null,{"$f":"SUM(AB12:AB14)","v":0},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":13},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":0}]

{"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:","Oktober",null,null,null,"Jahr:",2013]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","01:40:00",1,1,1,1,"-","-",null,null,null,null,null,{"$f":"IF(ISNUMBER(B9),B9*24,\" \")","v":1.6666666666666665},{"$f":"IF(ISNUMBER(N9),IF(N9<1,1,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<8,2,\" \"),\" \")","v":2},{"$f":"IF(ISNUMBER(N9),IF(N9<24,3,\" \"),\" \")","v":3},{"$f":"MIN(O9:Q9)","v":2}]
["02.","-",{"$f":"IF(R10=1,1,\"-\")","v":"-"},"-","-",1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-","-",1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","03:00:00",1,1,1,1,"-","-",null,null,null,null,null,3," ",2,3,2]
["07.","-","-",1,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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["30.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["31.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["Su.",{"$f":"SUM(B9:B39)","v":"04:40:00"},{"$f":"SUM(C9:C39)","v":2},{"$f":"SUM(D9:D39)","v":8},{"$f":"SUM(E9:E38)","v":13},29,9,3]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":2}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":9}]

{"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,"(213 m ü. NHN)"]
[]
["Oktober 2013"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":23.6},"am","2013-10-26"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":10.787096774193548},{"$f":"Kurztabelle!B48","v":9.4},{"$f":"C7-D7","v":1.387096774193548},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":-0.2},"am","2013-10-01"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":59.3},{"$f":"Kurztabelle!B49","v":50},{"$f":"100/D9*C9","v":118.6},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":55.599999999999994},{"$f":"Kurztabelle!B50","v":122},{"$f":"100/D10*C10","v":45.573770491803273},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Die Wetterstation kann, durch geographische Hindernisse, nicht die maximal mögliche Sonnenscheindauer aufzeichnen. Es gilt ein Übergangsprozentsatz von: Nov - Feb 50 %; Mär & Okt 65 %; Apr & Sep 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"]
["2013-10-01",5.2,13.8,-0.2,null,null,2.8,1016.7,11.85,null,null,"Von 08:40 Uhr - 09:19 Uhr starker Nebel. Von 08:20 Uhr - 08:39 Uhr; 09:20 Uhr - 09:29 Uhr mäßiger Nebel. Von 08:00 Uhr - 08:19 Uhr; 09:30 Uhr - 09:39 Uhr leichter Nebel. Von 07:30 Uhr - 07:59 Uhr; 09:40 Uhr - 09:49 Uhr starker Dunst. Von 07:10 Uhr- 07:29 Uhr; 09:50 Uhr - 09:59 Uhr mäßiger Dunst. Von 07:00 Uhr - 07:09 Uhr; 10:00 Uhr - 10:09 Uhr leichter Dunst."]
["2013-10-02",5.4,13.6,0.1,null,null,3.8,1025,11.7]
["2013-10-03",5.9,11.9,0.2,null,null,4.9000000000000004,1028.2,11.55,"SEa"]
["2013-10-04",8.1999999999999993,13.6,4.0999999999999996,null,null,4.3,1024.3,11.35]
["2013-10-05",8.6,13.8,5.4,null,null,1.6,1019,11.2,null,null,"Beginn des Blattfalls der Birke."]
["2013-10-06",9.4,12,5.8,0.4,null,null,1023.9,11.05,"BM","H Liane","Von 21:20 Uhr - 23:29 Uhr starker Nebel. Von 21:10 Uhr - 21:19 Uhr; 23:30 Uhr - 23:39 Uhr mäßiger Nebel. Von 21:00 Uhr - 21:09 Uhr; 23:40 Uhr - 23:49 Uhr leichter Nebel. Von 20:50 Uhr - 20:59 Uhr; 23:50 Uhr - 23:59 Uhr starker Dunst. Von 20:40 Uhr - 20:49 Uhr mäßiger Dunst. Von 20:30 Uhr - 20:39 Uhr leichter Dunst."]
["2013-10-07",12.2,15.7,10.199999999999999,0.1,null,null,1027.5,10.85,null,null,"Von 00:00 Uhr - 08:09 Uhr starker Dunst. Von 08:10 Uhr - 08:49 Uhr mäßiger Dunst. Von 08:50 Uhr - 09:29 Uhr leichter Dunst."]
["2013-10-08",12.6,18.100000000000001,8.5,null,null,3.6,1024.7,10.7,null,null,"Beginn des allgemeinen Blattfalls."]
["2013-10-09",11.6,15.1,8.3000000000000007,0.7,null,null,1018,10.55]
["2013-10-10",10.7,14.9,7.3,19.899999999999999,null,null,1007.3,10.4,"TM","T Xenon","Von 19:30 Uhr - 23:59 Uhr mäßiger Dunst. Von 19:20 Uhr - 19:29 Uhr leichter Dunst. "]
["2013-10-11",9.1,13.1,7.4,15.9,null,null,1014,10.199999999999999,null,null,"Von 17:20 Uhr - 23:59 Uhr leichter Dunst. Von 00:00 Uhr - 17:19 Uhr mäßiger Dunst."]
["2013-10-12",10.4,13.6,8.1,7.3,null,null,1018,10.050000000000001,null,null,"Von 00:00 Uhr - 01:49 Uhr; 17:10 Uhr - 17:49 Uhr leichter Dunst. Von 17:10 Uhr - 17:49 Uhr Sichteinschränkung durch Niederschlag."]
["2013-10-13",8.6,12.9,3.5,null,null,2.5,1020.3,9.9,"Ws"]
["2013-10-14",8.9,15.8,2.7,null,null,6.1,1020.1,9.6999999999999993,null,null,"Beginn des phänologischen Spätherbst."]
["2013-10-15",10.199999999999999,13.3,7.2,5.0999999999999996,null,null,1010.7,9.5500000000000007]
["2013-10-16",8.3000000000000007,10.199999999999999,6.2,2.2000000000000002,null,null,1011.9,9.4,"NWz","T Yannick","Von 02:30 Uhr - 09:29 Uhr; 10:20 Uhr - 11:29 Uhr leichter Dunst."]
["2013-10-17",10.6,15.6,4.4000000000000004,null,null,2.2999999999999998,1011.9,9.25,"U"]
["2013-10-18",9.6999999999999993,11.8,4.5,0.4,null,null,1016.9,9.1]
["2013-10-19",7.9,12.7,1.4,0.1,null,3.8,1018,8.9,"SEa","H Nastassja"]
["2013-10-20",12.8,17.3,10.3,2,null,0.3,1015.3,8.75,"SWz","T Jannick 1","Von 16:50 Uhr - 19:19 Uhr leichter Dunst."]
["2013-10-21",14.9,19.600000000000001,11,null,null,2.8,1016.1,8.6,"SWa","T Zenith"]
["2013-10-22",14.3,21.1,9.1999999999999993,null,null,2.9,1014.3,8.4]
["2013-10-23",15.4,20.399999999999999,12.8,0.6,null,1.1000000000000001,1010.6,8.25,"SWz"]
["2013-10-24",14.7,19.600000000000001,8.1999999999999993,null,null,1.8,1017.3,8.1]
["2013-10-25",11.6,17.7,6.4,null,null,1.5,1018.1,7.95,"Wz","T Albrecht"]
["2013-10-26",16.5,23.6,12.1,0.1,null,1.3,1014.3,7.75,"SWz",null,"Gartenblumen blühen das 2. mal.            Leicht schwül."]
["2013-10-27",16.8,21.2,11.1,1.6,null,1.8,1008.8,7.6]
["2013-10-28",16.8,22.2,12.3,null,null,0.5,1004.7,7.45,null,"Orkan \"Christian\""]
["2013-10-29",13.2,16.5,8.9,null,null,1.7,1012.5,7.3,"Wa","H Petra","Die Heuschrecken sind das letzte mal zu hören."]
["2013-10-30",8.9,12.4,3.6,null,null,1.3,1022.2,7.15]
["2013-10-31",5,12.6,0.7,null,null,2.9,1026.5,7]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":10.787096774193548},{"$f":"AVERAGE(C2:C32)","v":15.667741935483873},{"$f":"AVERAGE(D2:D32)","v":6.5064516129032253},null,null,null,{"$f":"AVERAGE(H2:H32)","v":1017.3258064516127},{"$f":"AVERAGE(I2:I32)","v":9.4048387096774171}]
["Mittel",9.4,null,null,50,"-",122,1017.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]

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