{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1","Erdbodenst."],"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,90,1019.2,14,8,null,"00",1,90,1019.8,11.3,2]
["01",1,93,1019.6,14.1,8,null,"01",1,91,1020.2,10.5,2]
["02",1,92,1020.1,13.2,8,null,"02",1,90,1020.4,10.1,2]
["03",1,83,1020.9,10.5,8,null,"03",0,91,1020.2,9.4,1]
["04",1,79,1021.1,9.1999999999999993,7,null,"04",1,91,1020.3,9,1]
["05",1,80,1021.3,8.4,5,null,"05",1,92,1020.5,8.5,1]
["06",1,82,1021.9,8.4,2,null,"06",1,88,1021,9.1999999999999993,0]
["07",1,81,1022.2,9.4,0,null,"07",0,89,1021.5,10.5,0]
["08",1,70,1022.6,9,5,null,"08",1,83,1021.9,12,0]
["09",1,68,1022.9,9,6,null,"09",1,74,1021.8,13,0]
["10",1,65,1023.2,8.6,5,null,"10",1,67,1021.8,13.6,0]
["11",1,53,1023.2,6,7,null,"11",1,57,1021.6,12.8,1]
["12",null,null,null,null,null,null,"12",1,52,1021.4,11.8,2]
["13",null,null,null,null,null,null,"13",1,47,1021.2,11.8,3]
["14",null,null,null,null,null,null,"14",1,43,1020.7,10.199999999999999,3]
[15,null,null,null,null,null,null,"15",1,43,1020.4,10.6,4]
["16",null,null,null,null,null,null,"16",1,42,1020.1,9.6999999999999993,4]
["17",null,null,null,null,null,null,"17",1,46,1020.1,10.4,4]
["18",null,null,null,null,null,null,"18",0,49,1020.2,10.199999999999999,5]
["19",null,null,null,null,null,null,"19",1,60,1020.4,10.8,4]
["20",null,null,null,null,null,null,"20",1,68,1020.8,10.9,3]
["21",null,null,null,null,null,null,"21",1,73,1021.1,11,1]
["22",null,null,null,null,null,null,"22",1,73,1021.1,10.7,3]
["23",null,null,null,null,null,null,"23",0,79,1021.2,10.4,3]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":1},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":78},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1021.5},{"$f":"AVERAGE(E3:E26)","v":9.9833333333333343},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":5.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.8},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":69.900000000000006},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1020.8},{"$f":"AVERAGE(L3:L26)","v":10.766666666666666},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":2}]
[]
[null,null,null,null,"2013-09-01",null,null,null,null,null,null,"2013-08-29"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,85,1021.2,10,3,null,"00",0,77,1017.9,11.4,7]
["01",0,86,1021,10.1,3,null,"01",0,75,1017.8,11.2,7]
["02",0,86,1020.9,10,3,null,"02",0,78,1017.9,11.4,8]
["03",0,87,1020.7,9.8000000000000007,4,null,"03",0,80,1017.5,11.4,7]
["04",0,88,1020.4,9.6999999999999993,3,null,"04",0,82,1017.3,11.3,7]
["05",0,89,1020.2,9.1999999999999993,1,null,"05",0,86,1017.4,11.3,6]
["06",0,88,1020.3,9.4,1,null,"06",0,84,1017.5,11.6,6]
["07",0,87,1020.3,10.9,0,null,"07",0,84,1017.7,12.6,6]
["08",1,80,1020.3,12.4,0,null,"08",1,76,1017.8,13.3,5]
["09",1,67,1020,13.7,5,null,"09",1,70,1017.9,13.9,4]
["10",1,63,1020.1,15,5,null,"10",1,58,1017.9,12.9,4]
["11",1,48,1019.5,12,4,null,"11",1,57,1017.6,12.7,7]
["12",1,49,1019.2,12.1,4,null,"12",1,50,1017.7,13.5,6]
["13",1,42,1018.9,10.5,6,null,"13",1,53,1017.4,13,6]
["14",1,45,1018.4,11.5,5,null,"14",1,49,1017.1,12.7,3]
["15",0,50,1018,12.4,3,null,"15",1,47,1016.7,11.7,5]
["16",0,50,1017.9,12.3,3,null,"16",1,47,1016.6,11.6,7]
["17",0,47,1017.6,11.1,3,null,"17",1,51,1016.7,11.9,8]
["18",0,54,1017.6,12,5,null,"18",1,54,1016.7,12,8]
["19",1,62,1017.9,12.3,6,null,"19",1,69,1017.3,13.4,8]
["20",1,65,1018,11.9,6,null,"20",0,76,1017.5,13.8,8]
["21",0,70,1018,11.5,5,null,"21",0,77,1017.8,13.9,8]
["22",0,75,1018,11.5,6,null,"22",2,78,1018.8,13.9,8]
["23",1,77,1018,11.5,6,null,"23",1,83,1018.9,14,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":0.4},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":68.3},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1019.3},{"$f":"AVERAGE(E33:E56)","v":11.366666666666669},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":3.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":0.6},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":68.400000000000006},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1017.6},{"$f":"AVERAGE(L33:L56)","v":12.516666666666664},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":6.5}]
[]
[null,null,null,null,"2013-08-30",null,null,null,null,null,null,"2013-08-31"]

{"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:","August",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.",21.9,28.7,14.4,13.3,47,72,2.6,".",null,null,9.6999999999999993,1018,16.100000000000001,1,null,null,null,null,null,null,2,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.",25.4,33.1,16.600000000000001,14.4,36,63,0,".",null,null,12.3,1014.9,17.100000000000001,0,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":3},{"$f":"COUNTIF(C6:C15,\">=25\")","v":8},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":5},{"$f":"COUNTIF(I6:I15,\">=1\")","v":4},{"$f":"COUNTIF(I6:I15,\">=3\")","v":3},{"$f":"COUNTIF(I6:I15,\">=10\")","v":1}]
["03.",26.5,33.799999999999997,19.2,17.2,36,62,2.2000000000000002,".",null,null,8.8000000000000007,1014.6,18,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":1},{"$f":"COUNTIF(C18:C27,\">=25\")","v":3},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":2},{"$f":"COUNTIF(I18:I27,\">=1\")","v":2},{"$f":"COUNTIF(I18:I27,\">=3\")","v":0},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0}]
["04.",22.2,29.1,17,16.100000000000001,59,82,5.3,4.9000000000000004,"R",null,4.8,1019,18.899999999999999,1,null,null,1,1,null,null,3,3,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":1},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":4},{"$f":"COUNTIF(I30:I40,\">=1\")","v":2},{"$f":"COUNTIF(I30:I40,\">=3\")","v":0},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0}]
["05.",20.9,28.4,15.1,14.4,53,84,4.5,".",null,null,6.2,1018.4,17.899999999999999,1,null,null,null,null,null,null,2]
["06.",24,33.200000000000003,17.3,16.100000000000001,32,73,4.3,7.8,"R",null,9.8000000000000007,1013.6,18.3,1,null,null,1,1,null,null,5,3,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",22.3,29.7,17,16.7,56,83,6.4,".",null,null,5.8,1012.1,18.899999999999999,0,null,null,null,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":0},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":1},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":3}]
["08.",22.7,28,17.7,16.600000000000001,58,76,6.9,1.7,"R",null,3.6,1013.1,18.3,1,null,null,1,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":0},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":4}]
["09.",16.2,19.7,13.4,12.7,71,90,7.8,12.2,"R",null,0.1,1019.5,14.6,0,null,null,1,null,null,null,3,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":0},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",17.3,24.7,11.6,10.6,50,82,4.5999999999999996,0.3,"R",null,6.5,1018.2,13.8,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":219.4},{"$f":"SUM(C6:C15)","v":288.39999999999998},{"$f":"SUM(D6:D15)","v":159.29999999999998},{"$f":"SUM(E6:E15)","v":148.1},"XXX",{"$f":"SUM(G6:G15)","v":767},{"$f":"SUM(H6:H15)","v":44.6},{"$f":"SUM(I6:I15)","v":26.9},{"$f":"SUM(K6:K15)","v":0},null,{"$f":"SUM(L6:L15)","v":67.600000000000009},{"$f":"SUM(M6:M15)","v":10161.400000000001},{"$f":"SUM(N6:N15)","v":171.9},{"$f":"SUM(O6:O15)","v":7},{"$f":"COUNT(P6:P15)","v":0},"X",{"$f":"SUM(R6:R15)","v":5},{"$f":"SUM(S6:S15)","v":2},{"$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":21.94},{"$f":"AVERAGE(C16/10)","v":28.839999999999996},{"$f":"AVERAGE(D16/10)","v":15.929999999999998},{"$f":"E16/10","v":14.809999999999999},"XXX",{"$f":"AVERAGE(G16/10)","v":76.7},{"$f":"AVERAGE(H16/10)","v":4.46},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M16/10)","v":1016.1400000000001},{"$f":"AVERAGE(N16/10)","v":17.190000000000001},{"$f":"O16/10","v":0.7},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":2.9},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$f":"COUNTIF(L6:L15,\">=10\")","v":1},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",16.399999999999999,21.1,11.1,10,48,74,3.9,".",null,null,6.4,1017.4,11.3,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$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.",17.399999999999999,23.8,9.1999999999999993,8.3000000000000007,46,70,3.6,".",null,null,5.5,1015.4,11.5,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":0},{"$f":"COUNTIF(L30:L40,\"<1\")","v":1},{"$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.",15.9,20.8,12,10.6,48,76,5.8,0,null,null,3.5,1015.6,11.6,1,null,null,null,null,null,null,3]
["14.",15.1,20.7,10.4,9.4,46,70,3.5,".",null,null,6,1021.2,9.3000000000000007,1,null,null,null,null,null,null,3,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",15.7,23,7.1,9.6,39,67,2.8,".",null,null,7.2,1023.1,8.6999999999999993,1,null,null,null,null,null,null,2,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":26.5},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":33.799999999999997},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":7.8},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":12.2}]
["16.",18.600000000000001,26.1,10.9,9.4,35,60,2.5,".",null,null,10.5,1020.2,9.8000000000000007,1,null,null,null,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",20.9,29.2,12.4,10.6,37,62,2.5,".",null,null,8.3000000000000007,1015.1,12.6,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":14.7},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":7.1},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":32},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",22.3,30.4,15.8,14.4,38,63,6.3,0,null,null,3.6,1013.7,14.4,1,null,null,null,null,null,null,4]
["19.",19.7,22.4,17.100000000000001,16.2,49,75,7.6,1.8,"R",null,0,1014.7,15.1,1,null,null,1,null,null,null,3]
["20.",15.4,20.8,11.9,11.1,63,85,6.7,1.1000000000000001,"R",null,1.3,1024.0999999999999,12.9,1,null,null,1,null,null,null,4]
["Su",{"$f":"SUM(B18:B27)","v":177.4},{"$f":"SUM(C18:C27)","v":238.3},{"$f":"SUM(D18:D27)","v":117.9},{"$f":"SUM(E18:E27)","v":109.6},"XXX",{"$f":"SUM(G18:G27)","v":702},{"$f":"SUM(H18:H27)","v":45.2},{"$f":"SUM(I18:I27)","v":2.9000000000000004},{"$f":"SUM(K18:K27)","v":0},null,{"$f":"SUM(L18:L27)","v":52.29999999999999},{"$f":"SUM(M18:M27)","v":10180.500000000002},{"$f":"SUM(N18:N27)","v":117.2},{"$f":"SUM(O18:O27)","v":10},{"$f":"COUNT(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":2},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":0},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":17.740000000000002},{"$f":"AVERAGE(C28/10)","v":23.830000000000002},{"$f":"AVERAGE(D28/10)","v":11.790000000000001},{"$f":"AVERAGE(E28/10)","v":10.959999999999999},"XXX",{"$f":"AVERAGE(G28/10)","v":70.2},{"$f":"AVERAGE(H28/10)","v":4.5200000000000005},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M28/10)","v":1018.0500000000002},{"$f":"AVERAGE(N28/10)","v":11.72},{"$f":"O28/10","v":1},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3.2}]
["21.",15.4,22.3,10.3,8.9,46,76,4.9000000000000004,".",null,null,4.8,1026.0999999999999,10.8,1,null,null,null,null,null,null,3]
["22.",16,23.6,8.6,7.8,44,72,3.9,".",null,null,8.4,1021.4,10.199999999999999,1,null,null,null,null,null,null,3]
["23.",15.8,22.4,10.1,9.1,53,83,6.8,1.3,"R",null,0.6,1019.6,12.8,1,null,null,1,null,null,null,3]
["24.",17.7,24.8,11.2,10.6,45,75,4.0999999999999996,".",null,null,6.3,1015.5,12.7,1,null,null,null,null,null,null,3]
["25.",16.7,23.8,12,11.1,45,78,6.3,2,"R",null,4.2,1012.3,12.5,0,null,null,1,null,null,null,3]
["26.",16.100000000000001,21.9,11.1,10.6,47,77,5.8,".",null,null,1.7,1015.3,11.7,1,null,null,null,null,null,null,4]
["27.",14.7,21.7,8.1999999999999993,7.8,54,77,4.5,".",null,null,3.5,1015.5,10.4,1,null,null,null,null,null,null,3]
["28.",16.2,22.1,11.9,11.7,56,78,6.5,0.2,"R",null,3.4,1016.6,12.1,1,null,null,1,null,null,null,2]
["29.",16.899999999999999,24.4,9.6999999999999993,8.3000000000000007,41,70,2,".",null,null,9.3000000000000007,1020.8,10.8,1,null,null,null,null,null,null,3]
["30.",17.899999999999999,25.1,10.8,10,41,68,3.8,".",null,null,3.6,1019.3,11.4,0,null,null,null,null,null,null,2]
["31.",18.7,24.3,13.4,12.2,45,68,6.5,0.6,"R",null,5,1017.6,12.5,1,null,null,1,null,null,null,4]
["Su",{"$f":"SUM(B30:B40)","v":182.10000000000002},{"$f":"SUM(C30:C40)","v":256.39999999999998},{"$f":"SUM(D30:D40)","v":117.30000000000001},{"$f":"SUM(E30:E40)","v":108.10000000000001},"XXX",{"$f":"SUM(G30:G40)","v":822},{"$f":"SUM(H30:H40)","v":55.1},{"$f":"SUM(I30:I40)","v":4.0999999999999996},{"$f":"SUM(K30:K40)","v":0},null,{"$f":"SUM(L30:L40)","v":50.800000000000004},{"$f":"SUM(M30:M40)","v":11200},{"$f":"SUM(N30:N40)","v":127.9},{"$f":"SUM(O30:O40)","v":9},{"$f":"COUNT(P30:P40)","v":0},"X",{"$f":"SUM(R30:R40)","v":4},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":0},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":16.554545454545458},{"$f":"AVERAGE(C41/11)","v":23.309090909090909},10.663636363636364,9.827272727272728,"XXX",{"$f":"AVERAGE(G41/10)","v":82.2},{"$f":"AVERAGE(H41/11)","v":5.0090909090909088},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M41/11)","v":1018.1818181818181},{"$f":"AVERAGE(N41/11)","v":11.627272727272727},0.81818181818181823,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":3}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":578.90000000000009},{"$f":"SUM(C16+C28+C41)","v":783.1},{"$f":"SUM(D16+D28+D41)","v":394.5},{"$f":"SUM(E16+E28+E41)","v":365.8},"XXX",{"$f":"SUM(G16+G28+G41)","v":2291},{"$f":"SUM(H16+H28+H41)","v":144.9},{"$f":"SUM(I16+I28+I41)","v":33.9},{"$f":"SUM(J16+J28+J41)","v":0},null,{"$f":"SUM(L16+L28+L41)","v":170.70000000000002},{"$f":"SUM(M16+M28+M41)","v":31541.9},{"$f":"SUM(N16+N28+N41)","v":417},"XXX",{"$f":"SUM(P16+P28+P41)","v":0},"X",{"$f":"SUM(R16+R28+R41)","v":11},{"$f":"SUM(S16+S28+S41)","v":2},{"$f":"SUM(T16+T28+T41)","v":0},{"$f":"SUM(U16+U28+U41)","v":0},"XXX",6]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":18.674193548387095},{"$f":"AVERAGE(C43/31)","v":25.261290322580646},{"$f":"AVERAGE(D43/31)","v":12.725806451612904},11.8,"XXX",{"$f":"AVERAGE(G43/30)","v":76.36666666666666},{"$f":"AVERAGE(H43/31)","v":4.6741935483870973},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M43/31)","v":1017.4806451612903},{"$f":"AVERAGE(N43/31)","v":13.451612903225806},{"$f":"AVERAGE(O17,O29,O42)","v":0.83939393939393936},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":3.0333333333333332}]
[]
[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":11},"ohne Sonne",null,null,null,null,null,1]
["TTT",17.899999999999999,"XXXX",{"$f":"SUM(B44-B48)","v":0.77419354838709609},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":4},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":8},"0,1 bis 0,9",null,null,null,null,null,1]
["RRR",86,{"$f":"SUM(I43*100/B49)","v":39.418604651162788},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":12},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":3},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":2}]
["sss",208,{"$f":"SUM(L43*100/B50)","v":82.067307692307693},"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","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.",446,{"$f":"SUM(L43*100/B52)","v":38.27354260089686},"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":0},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":1},">/= 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":7}]

{"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:","August",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.","-",{"$f":"IF(R9=1,1,\"-\")","v":"-"},"-","-",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.","-","-","-","-",1,1," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-","-",1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-",1,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,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-","-","-",1,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,1,"-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-","-",1,"-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["30.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["31.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["Su.","XXXXXXXXX",{"$f":"SUM(C9:C39)","v":0},{"$f":"SUM(D9:D39)","v":1},10,31,10,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":10}]

{"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)"]
[]
["August 2013"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":33.799999999999997},"am","2013-08-03"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":18.674193548387095},{"$f":"Kurztabelle!B48","v":17.899999999999999},{"$f":"C7-D7","v":0.77419354838709609},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":7.1},"am","2013-08-15"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":33.9},{"$f":"Kurztabelle!B49","v":86},{"$f":"100/D9*C9","v":39.418604651162788},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":170.70000000000002},{"$f":"Kurztabelle!B50","v":208},{"$f":"100/D10*C10","v":82.067307692307708},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":14,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2013-08-01",21.9,28.7,14.4,null,null,9.6999999999999993,1016.1,18.05,"SWa",null,"Mäßig schwül."]
["2013-08-02",25.4,33.1,16.600000000000001,null,null,12.3,1014.9,18.05,null,null,"Stark schwül. Beginn der Pflaumenernte."]
["2013-08-03",26.5,33.799999999999997,19.2,null,null,8.8000000000000007,1014.6,18.05,"TrW","T Dirk","Stark schwül."]
["2013-08-04",22.2,29.1,17,4.9000000000000004,null,4.8,1019,18.05,null,null,"Extrem schwül.",null,"Tropennacht (20,1 °C)"]
["2013-08-05",20.9,28.4,15.1,null,null,6.2,1018.4,18.05,"SWz","H Beibhinn","Extrem schwül."]
["2013-08-06",24,33.200000000000003,17.3,7.8,null,9.8000000000000007,1013.6,18.05,null,null,"Extrem schwül."]
["2013-08-07",22.3,29.7,17,null,null,5.8,1012.1,18.05,"U","T Franz","Stark schwül."]
["2013-08-08",22.7,28,17.7,1.7,null,3.6,1013.1,18,"Wz",null,"Stark schwül. Tropennacht (20,2 °C)."]
["2013-08-09",16.2,19.7,13.4,12.2,null,0.1,1019.5,18,null,null,"Leicht schwül."]
["2013-08-10",17.3,24.7,11.6,0.3,null,6.5,1018.2,18,"Wa","H Cornelia","Mäßig schwül."]
["2013-08-11",16.399999999999999,21.1,11.1,null,null,6.4,1017.4,18]
["2013-08-12",17.399999999999999,23.8,9.1999999999999993,null,null,5.5,1015.4,18]
["2013-08-13",15.9,20.8,12,null,null,3.5,1015.6,17.95]
["2013-08-14",15.1,20.7,10.4,null,null,6,1021.2,17.95]
["2013-08-15",15.7,23,7.1,null,null,7.2,1023.1,17.899999999999999]
["2013-08-16",18.600000000000001,26.1,10.9,null,null,10.5,1020.2,17.899999999999999]
["2013-08-17",20.9,29.2,12.4,null,null,8.3000000000000007,1015.1,17.899999999999999,null,null,"Leicht schwül."]
["2013-08-18",22.3,30.4,15.8,null,null,3.6,1013.7,17.850000000000001,null,null,"Mäßig schwül."]
["2013-08-19",19.7,22.4,17.100000000000001,1.8,null,0,1014.7,17.850000000000001,null,null,"Leicht schwül."]
["2013-08-20",15.4,20.8,11.9,1.1000000000000001,null,1.3,1024.0999999999999,17.8,"HNa","H Fortuna","Beginn der Apfelernte."]
["2013-08-21",15.4,22.3,10.3,null,null,4.8,1026.0999999999999,17.8]
["2013-08-22",16,23.6,8.6,null,null,8.4,1021.4,17.75]
["2013-08-23",15.8,22.4,10.1,null,null,0.6,1019.6,17.75,"HNFz"]
["2013-08-24",17.7,24.8,11.2,null,null,6.3,1015.5,17.7]
["2013-08-25",16.7,23.8,12,2,null,4.2,1012.3,17.7]
["2013-08-26",16.100000000000001,21.9,11.1,null,null,1.7,1015.3,17.649999999999999]
["2013-08-27",14.7,21.7,8.1999999999999993,null,null,3.5,1015.5,17.649999999999999,"NEz"]
["2013-08-28",16.2,22.1,11.9,0.2,null,3.4,1016.6,17.600000000000001]
["2013-08-29",16.899999999999999,24.4,9.6999999999999993,null,null,9.3000000000000007,1020.8,17.600000000000001,"BM","H Gerlinde"]
["2013-08-30",17.899999999999999,25.1,10.8,null,null,3.6,1019.3,17.55,null,null,"Leicht schwül."]
["2013-08-31",18.7,24.3,13.4,0.6,null,5,1017.6,17.5,"NWz","T Kasimir"]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":18.674193548387095},{"$f":"AVERAGE(C2:C32)","v":25.261290322580638},{"$f":"AVERAGE(D2:D32)","v":12.725806451612904},null,null,null,{"$f":"AVERAGE(H2:H32)","v":1017.4193548387095},{"$f":"AVERAGE(I2:I32)","v":17.861290322580643}]
["Mittel",17.899999999999999,null,null,86,"-",208,1015.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":"Erdbodenst.","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,5,11,6],[12,5,12,6],[38,3,38,4],[37,5,37,6],[16,5,16,6],[17,5,17,6],[33,3,33,4],[38,5,38,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[36,3,36,4],[37,3,37,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[34,3,34,4],[35,3,35,4],[38,1,38,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[31,1,31,2],[32,1,32,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[30,1,30,2],[18,1,29,7],[30,5,30,6],[31,5,31,6],[6,0,7,0],[13,5,13,6],[14,5,14,6],[15,5,15,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[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]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","August",null,null,null,"Jahr:",2013]
[]
["Dat.","7 Uhr","8 Uhr","12 Uh","13 Uhr","20 Uhr",null,"NN"]
[]
["01.","18,6 °C/19,6 °C",null,"25,8 °C/22,8 °C",null,"23,6 °C/23,2 °C",null,"n"]
["02.","20,4 °C/21,0 °C",null,"32,0 °C/24,4 °C",null,"27,0 °C/25,4 °C",null,"h",9]
["03.","20,8 °C/21,6 °C",null,"31,1 °C/25,2 °C",null,"27,6 °C/26,2 °C",null,"n",9]
["04.","21,2 °C/22,4 °C",null,"32,2 °C/26,0 °C",null,"26,2 °C/25,0 °C",null,"n"]
["05.","20,4 °C/21,4 °C",null,"24,8 °C/22,2 °C",null,"24,8 °C/25,2 °C",null,"n"]
["06.","20,6 °C/21,2 °C",null,"29,4 °C/23,9 °C",null,"24,0 °C/24,8 °C",null,"n"]
["07.","20,8 °C/22,0 °C",null,"29,0 °C/23,9 °C",null,"24,4 °C/24,8 °C",null,"n"]
["08.","21,6 °C/21,4 °C",null,"25,0 °C/22,3 °C",null,"23,8 °C/24,8 °C",null,"t"]
["09.","20,6 °C/21,0 °C",null,"20,0 °C/20,6 °C",null,"19,0 °C/20,2 °C",null,"t"]
["10.","16,2 °C/17,9 °C",null,"23,0 °C/20,6 °C",null,"21,4 °C722,5 °C",null,"n"]
["11.","-"]
["12."]
["13."]
["14."]
["15.",null,null,null,null,null,null,null,9]
["16.",null,null,null,null,null,null,null,9]
["17.",null,null,null,null,null,null,null,9]
["18.",null,null,null,null,null,null,null,9]
["19."]
["20."]
["21."]
["22.",null,null,null,null,null,null,null,9]
["23.","-",null,"-",null,"-",null,null,9]
["24.","14,6 °C/16,6 °C",null,"25,0 °C/18,0 °C",null,"18,2 °C/19,0 °C",null,"n",9]
["25.","15,4 °C/17,0 °C",null,"22,0 °C/18,8 °C",null,"17,4 °C/18,4 °C",null,"n"]
["26.","15,8 °C/16,8 °C",null,"20,4 °C/17,7 °C",null,"17,8 °C/19,6 °C",null,"n"]
["27.","15,0 °C/16,6 °C",null,"21,4 °C/16,8 °C",null,"18,0 °C/18,6 °C",null,"n",9]
["28.","14,6 °C/16,0 °C",null,"22,0 °C/17,9 °C",null,"19,6 °C/20,2 °C",null,"n",9]
["29.","13,2 °C/15,4 °C",null,"24,9 °C/18,1 °C",null,"21,0 °C/21,6 °C",null,"n",9]
["30.","14,9 °C/16,5 °C",null,"24,2 °C/18,0 °C",null,"20,5 °C/20,8 °C",null,"n",9]
["31.","16,2 °C/16,5 °C",null,"23,1 °C/19,5 °C",null,"20,0 °C/21,0 °C",null,"n",9]