{"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",0,87,1019.4,14.7,5,null,"00",1,68,1012.7,18.100000000000001,8]
["01",0,89,1019.2,14.7,3,null,"01",1,91,1013,18.5,8]
["02",0,92,1019.1,14.3,2,null,"02",1,95,1012.1,18.3,8]
["03",0,93,1019.3,13.9,1,null,"03",1,95,1014,18.3,8]
["04",1,94,1019.4,13.6,2,null,"04",0,97,1012.7,17.8,8]
["05",1,94,1019.3,13.5,1,null,"05",0,98,1012.6,17.899999999999999,7]
["06",0,92,1019.4,14.8,1,null,"06",0,98,1013.2,18.399999999999999,8]
["07",0,86,1019.5,16.100000000000001,2,null,"07",0,96,1013.5,18.7,8]
["08",0,77,1019.5,17.600000000000001,2,null,"08",0,92,1013.9,19.2,8]
["09",0,61,1019.2,16.3,6,null,"09",1,91,1013.9,19.7,8]
["10",1,61,1018.8,16.600000000000001,7,null,"10",1,80,1013.8,19.399999999999999,7]
["11",1,55,1018.7,16.3,6,null,"11",1,78,1013.5,19.3,7]
["12",1,57,1018.3,16.5,5,null,"12",1,74,1013.2,19.600000000000001,7]
["13",null,null,null,null,null,null,"13",1,81,1013.2,19.399999999999999,7]
["14",null,null,null,null,null,null,"14",1,82,1012.3,18.600000000000001,7]
[15,null,null,null,null,null,null,"15",0,80,1012.2,18.8,7]
["16",null,null,null,null,null,null,"16",1,76,1011.3,18.8,7]
["17",null,null,null,null,null,null,"17",1,77,1011.1,18.399999999999999,7]
["18",null,null,null,null,null,null,"18",1,78,1010.6,17.899999999999999,8]
["19",null,null,null,null,null,null,"19",1,90,1011,18,8]
["20",null,null,null,null,null,null,"20",1,94,1011.5,16.7,8]
["21",null,null,null,null,null,null,"21",1,96,1011.8,16.7,8]
["22",null,null,null,null,null,null,"22",0,97,1012,16.899999999999999,8]
["23",null,null,null,null,null,null,"23",1,96,1012.3,17.2,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.4},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":79.8},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1019.2},{"$f":"AVERAGE(E3:E26)","v":15.3},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":3.3},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.7},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":87.5},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1012.6},{"$f":"AVERAGE(L3:L26)","v":18.358333333333331},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":7.6}]
[]
[null,null,null,null,"2013-08-01",null,null,null,null,null,null,"2013-07-29"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,95,1012.7,16,8,null,"00",1,69,1017.5,13.4,7]
["01",1,96,1013.8,15.8,8,null,"01",0,71,1017.2,13.2,3]
["02",1,95,1014.1,15.5,8,null,"02",0,78,1017,12.9,1]
["03",1,95,1014.3,15.4,8,null,"03",0,81,1016.5,12.7,1]
["04",1,94,1014.8,15.2,8,null,"04",1,75,1016.2,12.6,3]
["05",1,93,1015.4,15,8,null,"05",1,73,1016.2,13.2,6]
["06",1,92,1016,15.3,8,null,"06",0,76,1016.3,14.2,6]
["07",1,91,1017,15.4,8,null,"07",1,74,1016.2,14.7,7]
["08",1,87,1017.4,16.100000000000001,7,null,"08",1,74,1016.4,15.1,7]
["09",1,81,1017.5,16.5,5,null,"09",1,72,1016.3,15.5,8]
["10",1,77,1017.6,15.5,5,null,"10",1,81,1016.6,16.7,6]
["11",1,66,1017.4,15.4,6,null,"11",1,72,1016.8,15.7,7]
["12",0,86,1017.5,16.399999999999999,6,null,"12",1,66,1017,14.9,7]
["13",1,75,1016.9,17.3,6,null,"13",1,65,1016.9,15.6,7]
["14",1,67,1017,15,6,null,"14",1,82,1017.3,16.3,7]
["15",1,60,1017,14.4,5,null,"15",1,69,1017.1,16.600000000000001,7]
["16",1,56,1016.5,14.2,5,null,"16",1,71,1017.9,14.8,7]
["17",1,54,1016.5,14,4,null,"17",1,70,1017.8,15.4,7]
["18",1,53,1016.4,12.9,3,null,"18",1,72,1018,15.8,8]
["19",0,61,1016.5,13.9,3,null,"19",1,72,1018,15.4,7]
["20",1,66,1017,13.2,3,null,"20",1,74,1018.4,15.2,7]
["21",1,72,1017.3,13.5,5,null,"21",0,78,1019,15,7]
["22",1,72,1017.5,13.9,7,null,"22",1,78,1019.2,14.9,5]
["23",1,71,1017.3,13.9,7,null,"23",0,83,1019.5,15.1,5]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":0.9},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":77.3},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1016.3},{"$f":"AVERAGE(E33:E56)","v":14.987499999999997},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":6.1},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":0.8},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":74},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1017.3},{"$f":"AVERAGE(L33:L56)","v":14.7875},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":6}]
[]
[null,null,null,null,"2013-07-30",null,null,null,null,null,null,"2013-07-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:","Juli",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.",18.399999999999999,24.2,12.4,12.8,41,65,5.6,".",null,null,12.1,1018.9,11.3,1,null,null,null,null,null,null,3,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.",18.8,25.1,12.7,12.2,47,75,5,0.3,"R",null,9.3000000000000007,1014.8,14,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":4},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=1\")","v":1},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0}]
["03.",18.7,25,12.7,12.8,55,82,6.2,1.5,"R",null,2.5,1012.2,15.4,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":5},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":0},{"$f":"COUNTIF(I18:I27,\">=1\")","v":0},{"$f":"COUNTIF(I18:I27,\">=3\")","v":0},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0}]
["04.",18.8,22.8,13.4,13.3,67,82,5.7,".",null,null,6.8,1019.1,15.6,1,null,null,null,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":4},{"$f":"COUNTIF(C30:C40,\">=25\")","v":8},{"$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":2},{"$f":"COUNTIF(I30:I40,\">=10\")","v":2}]
["05.",18.899999999999999,24.3,16.399999999999999,16.7,60,84,7.1,0,null,null,1.4,1026,16.2,1,null,null,null,null,null,null,3]
["06.",19.2,24.3,14.4,14.4,57,79,5.6,".",null,null,10.199999999999999,1030.0999999999999,15.3,1,null,null,null,null,null,null,2,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.",18.399999999999999,24.4,11.8,12.2,43,72,0.7,".",null,null,13,1029.5999999999999,12.8,1,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":0},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",19.100000000000001,25.6,11.4,11.7,45,72,1.8,".",null,null,11.7,1028.9000000000001,13.5,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":0},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",20.2,27.1,13,12.8,43,71,1.6,".",null,null,12.1,1023.6,14.4,1,null,null,null,null,null,null,2,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":7}]
["10.",18.899999999999999,24.1,14,13.9,52,73,3.6,".",null,null,10.9,1016.8,13.7,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B6:B15)","v":189.39999999999998},{"$f":"SUM(C6:C15)","v":246.89999999999998},{"$f":"SUM(D6:D15)","v":132.19999999999999},{"$f":"SUM(E6:E15)","v":132.80000000000001},"XXX",{"$f":"SUM(G6:G15)","v":755},{"$f":"SUM(H6:H15)","v":42.900000000000006},{"$f":"SUM(I6:I15)","v":1.8},{"$f":"SUM(K6:K15)","v":0},null,{"$f":"SUM(L6:L15)","v":90},{"$f":"SUM(M6:M15)","v":10220},{"$f":"SUM(N6:N15)","v":142.19999999999999},{"$f":"SUM(O6:O15)","v":10},{"$f":"COUNT(P6:P15)","v":0},"X",{"$f":"SUM(R6:R15)","v":2},{"$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":18.939999999999998},{"$f":"AVERAGE(C16/10)","v":24.689999999999998},{"$f":"AVERAGE(D16/10)","v":13.219999999999999},{"$f":"E16/10","v":13.280000000000001},"XXX",{"$f":"AVERAGE(G16/10)","v":75.5},{"$f":"AVERAGE(H16/10)","v":4.2900000000000009},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M16/10)","v":1022},{"$f":"AVERAGE(N16/10)","v":14.219999999999999},{"$f":"O16/10","v":1},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":2.7},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":6},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",14.7,16.8,11.9,11.7,67,79,7.3,0,null,null,".",1017.4,11,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":1},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$f":"COUNTIF(L18:L27,\">=10\")","v":4},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",16.399999999999999,21,12.4,11.7,58,75,7,".",null,null,3.1,1019.6,11.7,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":4},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":0},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",17.399999999999999,23.1,10.9,11.1,47,71,4.8,".",null,null,9.4,1020,11.7,1,null,null,null,null,null,null,3]
["14.",17.2,22.1,12.7,12.8,63,76,5.8,".",null,null,8,1020.5,12.9,1,null,null,null,null,null,null,3,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",16.2,21.4,11.6,10.6,51,74,5.5,".",null,null,6.7,1021.4,11.4,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":27.9},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":34.700000000000003},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":9.4},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":24}]
["16.",18.3,25.6,9.8000000000000007,9.4,43,69,2.8,".",null,null,13,1023,11.8,1,null,null,null,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",19.7,26.7,11.7,11.7,41,68,5,".",null,null,10.8,1022.5,13.1,1,null,null,null,null,null,null,2,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":14.7},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":9.8000000000000007},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":26},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",20.3,27.7,12.9,12.8,45,70,3.3,".",null,null,10.199999999999999,1022.3,14.4,1,null,null,null,null,null,null,2]
["19.",20.6,26.2,13.8,13.9,48,69,3.5,".",null,null,11.4,1020,14.3,1,null,null,null,null,null,null,4]
["20.",19.899999999999999,25.8,16.100000000000001,15.6,44,69,4,".",null,null,5.5,1020,13.8,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B18:B27)","v":180.70000000000002},{"$f":"SUM(C18:C27)","v":236.39999999999998},{"$f":"SUM(D18:D27)","v":123.80000000000001},{"$f":"SUM(E18:E27)","v":121.3},"XXX",{"$f":"SUM(G18:G27)","v":720},{"$f":"SUM(H18:H27)","v":49},{"$f":"SUM(I18:I27)","v":0},{"$f":"SUM(K18:K27)","v":0},null,{"$f":"SUM(L18:L27)","v":78.100000000000009},{"$f":"SUM(M18:M27)","v":10206.700000000001},{"$f":"SUM(N18:N27)","v":126.1},{"$f":"SUM(O18:O27)","v":10},{"$f":"COUNT(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":0},{"$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":18.07},{"$f":"AVERAGE(C28/10)","v":23.639999999999997},{"$f":"AVERAGE(D28/10)","v":12.38},{"$f":"AVERAGE(E28/10)","v":12.129999999999999},"XXX",{"$f":"AVERAGE(G28/10)","v":72},{"$f":"AVERAGE(H28/10)","v":4.9000000000000004},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M28/10)","v":1020.6700000000001},{"$f":"AVERAGE(N28/10)","v":12.61},{"$f":"O28/10","v":1},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":2.9}]
["21.",19.899999999999999,27.8,11.3,11.1,37,65,0.1,".",null,null,13.1,1021.6,12.5,1,null,null,null,null,null,null,3]
["22.",21.5,29.7,12.2,11.1,29,60,1.2,".",null,null,13.1,1017.7,12.3,1,null,null,null,null,null,null,2]
["23.",21.4,29.8,13.3,12.8,37,61,2.2000000000000002,".",null,null,10.7,1014.3,13,1,null,null,null,null,null,null,3]
["24.",21.7,30.2,11.9,11.7,28,58,4.0999999999999996,0.9,"R",null,11.2,1014.4,11.8,1,null,null,1,null,null,null,3]
["25.",20.9,26.9,17.399999999999999,17.8,50,78,5.8,".",null,null,4.8,1015.9,16.600000000000001,0,null,null,null,null,null,null,2]
["26.",23.4,31.2,15.3,15,34,67,3.6,".",null,null,9.8000000000000007,1014.7,16.2,1,null,null,null,null,null,null,3]
["27.",26.4,34.4,16.8,16.7,33,59,3.1,".",null,null,9.8000000000000007,1010.6,16.8,0,null,null,null,null,null,null,2]
["28.",27.9,34.700000000000003,20.6,18.899999999999999,26,50,4,10.8,"R",null,6.7,1009.9,15.9,1,null,null,1,null,null,null,3]
["29.",20.399999999999999,24.6,16.8,16.399999999999999,68,87,7.6,24,"R",null,0.8,1012.6,18.399999999999999,1,null,null,1,1,null,null,4,3]
["30.",19.399999999999999,24.1,16.100000000000001,16.2,50,77,6.1,0.7,"R",null,3.5,1016.3,15,1,null,null,1,1,null,null,3,2]
["31.",19.5,23.3,15.6,14.4,64,74,6,0,null,null,1.5,1017.3,14.8,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B30:B40)","v":242.40000000000003},{"$f":"SUM(C30:C40)","v":316.70000000000005},{"$f":"SUM(D30:D40)","v":167.29999999999998},{"$f":"SUM(E30:E40)","v":162.1},"XXX",{"$f":"SUM(G30:G40)","v":736},{"$f":"SUM(H30:H40)","v":43.800000000000004},{"$f":"SUM(I30:I40)","v":36.400000000000006},{"$f":"SUM(K30:K40)","v":0},null,{"$f":"SUM(L30:L40)","v":84.999999999999986},{"$f":"SUM(M30:M40)","v":11165.3},{"$f":"SUM(N30:N40)","v":163.30000000000001},{"$f":"SUM(O30:O40)","v":9},{"$f":"COUNT(P30:P40)","v":0},"X",{"$f":"SUM(R30:R40)","v":4},{"$f":"SUM(S30:S40)","v":2},{"$f":"SUM(T30:T40)","v":0},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":22.036363636363639},{"$f":"AVERAGE(C41/11)","v":28.790909090909096},15.209090909090907,14.736363636363636,"XXX",{"$f":"AVERAGE(G41/10)","v":73.599999999999994},{"$f":"AVERAGE(H41/11)","v":3.9818181818181824},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M41/11)","v":1015.0272727272727},{"$f":"AVERAGE(N41/11)","v":14.845454545454546},0.81818181818181823,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":2.9090909090909092}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":612.5},{"$f":"SUM(C16+C28+C41)","v":800},{"$f":"SUM(D16+D28+D41)","v":423.29999999999995},{"$f":"SUM(E16+E28+E41)","v":416.20000000000005},"XXX",{"$f":"SUM(G16+G28+G41)","v":2211},{"$f":"SUM(H16+H28+H41)","v":135.70000000000002},{"$f":"SUM(I16+I28+I41)","v":38.200000000000003},{"$f":"SUM(J16+J28+J41)","v":0},null,{"$f":"SUM(L16+L28+L41)","v":253.10000000000002},{"$f":"SUM(M16+M28+M41)","v":31592},{"$f":"SUM(N16+N28+N41)","v":431.59999999999997},"XXX",{"$f":"SUM(P16+P28+P41)","v":0},"X",{"$f":"SUM(R16+R28+R41)","v":6},{"$f":"SUM(S16+S28+S41)","v":2},{"$f":"SUM(T16+T28+T41)","v":0},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":19.758064516129025},{"$f":"AVERAGE(C43/31)","v":25.806451612903224},{"$f":"AVERAGE(D43/31)","v":13.654838709677417},13.425806451612905,"XXX",{"$f":"AVERAGE(G43/30)","v":73.7},{"$f":"AVERAGE(H43/31)","v":4.3774193548387101},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M43/31)","v":1019.0967741935484},{"$f":"AVERAGE(N43/31)","v":13.92258064516129},{"$error":"#VALUE!"},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":2.836363636363636}]
[]
[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":6},"ohne Sonne",null,null,null,null,null,1]
["TTT",18.3,"XXXX",{"$f":"SUM(B44-B48)","v":1.4580645161290242},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":4},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":3},"0,1 bis 0,9",null,null,null,null,null,1]
["RRR",86,{"$f":"SUM(I43*100/B49)","v":44.418604651162795},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":17},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":2},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":14}]
["sss",220,{"$f":"SUM(L43*100/B50)","v":115.04545454545456},"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.",480,{"$f":"SUM(L43*100/B52)","v":52.729166666666671},"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":0},">/= 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:","Juli",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,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,1," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-",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,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-","-",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,"-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-","-",1,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,"-",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,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.","XXXXXXXXX",{"$f":"SUM(C9:C39)","v":0},{"$f":"SUM(D9:D39)","v":1},7,29,16,2]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":16}]

{"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)"]
[]
["Juli 2013"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":34.700000000000003},"am","2013-07-27"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":19.758064516129025},{"$f":"Kurztabelle!B48","v":18.3},{"$f":"C7-D7","v":1.4580645161290242},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":9.8000000000000007},"am","2013-07-16"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":38.200000000000003},{"$f":"Kurztabelle!B49","v":86},{"$f":"100/D9*C9","v":44.418604651162795},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":253.10000000000002},{"$f":"Kurztabelle!B50","v":220},{"$f":"100/D10*C10","v":115.04545454545455},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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-07-01",18.399999999999999,24.2,12.4,null,null,12.1,1018.9,17.95,"Ww ","H Walburga"]
["2013-07-02",18.8,25.1,12.7,0.3,null,9.3000000000000007,1014.8,18,null,null,"Leicht schwül."]
["2013-07-03",18.7,25,12.7,1.5,null,2.5,1012.2,18.05,"Wz","T Sky","Mäßig schwül."]
["2013-07-04",18.8,22.8,13.4,null,null,6.8,1019.1,18.100000000000001,null,null,"Mäßig schwül."]
["2013-07-05",18.899999999999999,24.3,16.399999999999999,null,null,1.4,1026,18.149999999999999,"BM","H Xena","Mäßig schwül."]
["2013-07-06",19.2,24.3,14.4,null,null,10.199999999999999,1030.0999999999999,18.2,null,null,"Mäßig schwül."]
["2013-07-07",18.399999999999999,24.4,12.2,null,null,13,1029.5999999999999,18.25,"HB",null,"Leicht schwül."]
["2013-07-08",19.100000000000001,25.6,11.4,null,null,11.7,1028.9000000000001,18.3,null,null,"Leicht schwül."]
["2013-07-09",20.2,27.1,13,null,null,12.1,1023.6,18.350000000000001,null,null,"Leicht schwül."]
["2013-07-10",18.899999999999999,24.1,14,null,null,10.9,1016.8,18.399999999999999,"NWa",null,"Leicht schwül."]
["2013-07-11",14.7,16.8,11.9,null,null,null,1017.4,18.45,"Na"]
["2013-07-12",16.399999999999999,21,12.4,null,null,3.1,1019.6,18.5]
["2013-07-13",17.399999999999999,23.1,10.9,null,null,9.4,1020,18.5,null,null,"Leicht schwül."]
["2013-07-14",17.2,22.1,12.7,null,null,8,1020.5,18.55,null,null,"Die 1. Heuschrecken sind zu hören.        Leicht schwül."]
["2013-07-15",16.2,21.4,11.6,null,null,6.7,1021.4,18.55,"BM","H Yasmine"]
["2013-07-16",18.3,25.6,9.8000000000000007,null,null,13,1023,18.55,null,null,"Beginn der Goldrutenblüte."]
["2013-07-17",19.7,26.7,11.7,null,null,10.8,1022.5,18.600000000000001,"HB",null,"Leicht schwül."]
["2013-07-18",20.3,27.7,12.9,null,null,10.199999999999999,1022.3,18.55,null,null,"Leicht schwül."]
["2013-07-19",20.6,26.2,13.8,null,null,11.4,1020,18.55,null,null,"Leicht schwül."]
["2013-07-20",19.899999999999999,25.8,16.100000000000001,null,null,5.5,1020,18.5,null,null,"Leicht schwül."]
["2013-07-21",19.899999999999999,27.8,11.3,null,null,13.1,1021.6,18.5,"HNa",null,"Beginn der Beifußblüte."]
["2013-07-22",21.5,29.7,12.2,null,null,13.1,1017.7,18.45,null,null,"Leicht schwül. Beginn der Gerstenernt. "]
["2013-07-23",21.4,29.8,13.3,null,null,10.7,1014.3,18.399999999999999,null,null,"Leicht schwül.  "]
["2013-07-24",21.7,30.2,11.9,0.9,null,11.2,1014.4,18.399999999999999,null,null,"Leicht schwül."]
["2013-07-25",20.9,26.9,17.399999999999999,null,null,4.8,1015.9,18.350000000000001,"SWa","H Zlatka","Mäßig schwül."]
["2013-07-26",23.4,31.2,15.3,null,null,9.8000000000000007,1014.7,18.3,null,null,"Mäßig schwül."]
["2013-07-27",26.4,34.4,16.8,null,null,9.8000000000000007,1010.6,18.25,"Sz","T Zaki","Stark schwül."]
["2013-07-28",27.9,34.700000000000003,20.6,10.8,null,6.7,1009.9,18.2,null,null,"Mäßig schwül."]
["2013-07-29",20.399999999999999,24.6,16.8,24,null,0.8,1012.6,18.149999999999999,null,"T Bernd","Stark schwül. Von 03:05 Uhr - 03:24 Uhr mäßiger Dunst. Von 01:25 Uhr - 01:34 Uhr; 19:05 Uhr - 19:29 Uhr leichter Dunst. Von 01:25 - 01:34 Uhr; 03:05 Uhr - 03:24 Uhr; 19:05 Uhr - 19:29 Uhr Sichteinschränkung durch Starkniederschlag."]
["2013-07-30",19.399999999999999,24.1,16.100000000000001,0.7,null,3.5,1016.3,18.100000000000001,null,null,"Mäßig schwül."]
["2013-07-31",19.5,23.3,15.6,null,null,1.5,1017.3,18.05,"Wa","H Antonia","Leicht schwül."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":19.758064516129025},{"$f":"AVERAGE(C2:C32)","v":25.806451612903228},{"$f":"AVERAGE(D2:D32)","v":13.667741935483875},null,null,null,{"$f":"AVERAGE(H2:H32)","v":1019.0967741935484},{"$f":"AVERAGE(I2:I32)","v":18.329032258064519}]
["Mittel",18.3,null,null,86,"-",220,1015.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":[[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[33,3,33,4],[6,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[22,5,22,6],[38,5,38,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[35,5,35,6],[36,5,36,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[38,3,38,4],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[37,5,37,6],[36,1,36,2],[37,1,37,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[36,3,36,4],[37,3,37,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[34,3,34,4],[35,3,35,4],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[38,1,38,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],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[33,1,33,2],[34,1,34,2],[35,1,35,2],[6,0,7,0],[4,6,4,7],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,7,7,7],[31,1,31,2],[32,1,32,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Juli",null,null,null,"Jahr:",2013]
[]
["Dat.","7 Uhr","8 Uhr","12 Uh","13 Uhr","20 Uhr",null,"NN"]
[]
["01.","15,2 °C/15,7 °C",null,"22,4 °C/17,4 °C",null,"22,9 °C/ 20,8 °C",null,"n"]
["02.","17,2 °C/17,4 °C",null,"24,6 °C/19,9 °C",null,"22,6 °C/21,0 °C",null,"n"]
["03.","17,7 °C/18,4 °C",null,"25,2 °C/20,4 °C",null,"21,5 °C/21,0 °C",null,"n"]
["04.","19,2 °C/18,6 °C",null,"22,6 °C/19,4 °C",null,"21,4 °C/20,7 °C",null,"n"]
["05.","19,8 °C/19,4 °C",null,"22,2 °C/20,2 °C",null,"22,4 °C/22,0 °C",null,"t"]
["06.","17,9 °C/18,8 °C",null,"24,8 °C/20,4 °C",null,"22,3 °C/21,4 °C",null,"n"]
["07.","17,5 °C/19,6 °C",null,"31,8 °C/23,8 °C",null,"23,1 °C/24,6 °C",null,"h"]
["08.","17,9 °C/19,1 °C",null,"27,1 °C/22,0 °C",null,"25,2 °C/25,0 °C",null,"n"]
["09.","18,9 °C/19,9 °C",null,"27,8 °C/22,2 °C",null,"26,9 °C/26,0 °C",null,"n"]
["10.","19,6 °C/20,4 °C",null,"27,9 °C/23,1 °C",null,"25,6 °C/25,6 °C",null,"n"]
["11.","18,4 °C/20,0 °C",null,"21,4 °C/20,2 °C",null,"19,6 °C/20,5 °C",null,"t"]
["12.","18,0 °C/18,0 °C",null,"18,2 °C/17,8 °C",null,"18,0 °C/20,2 °C",null,"t"]
["13.","18,6 °C/19,4 °C",null,"25,2 °C/22,4 °C",null,"23,6 °C/23,4 °C",null,"n",9]
["14.","17,6 °C/19,0 °C",null,"27,4 °C/23,2 °C",null,"25,0 °C/24,0 °C",null,"n",9]
["15.","18,9 °C/19,1 °C",null,"25,1 °C/22,8 °C",null,"24,5 °C/24,2 °C",null,"n",9]
["16.","17,7 °C/19,0 °C",null,"27,2 °C/21,6 °C",null,"27,2 °C/26,3 °C",null,"n",9]
["17.","20,2 °C/19,2 °C",null,"28,2 °C/23,2 °C",null,"27,7 °C/26,8 °C",null,"n",9]
["18.","19,8 °C/20,8 °C",null,"28,7 °C/23,0 °C",null,"27,9 °C/27,2 °C",null,"n",9]
["19.","20,0 °C/21,2 °C",null,"30,0 °C/24,0 °C",null,"28,5 °C/27,6 °C",null,"n",9]
["20.","19,0 °C/21,4 °C",null,"28,0 °C/24,6 °C",null,"26,8 °C/26,6 °C",null,"n",9]
["21.","18,9 °C/20,4 °C",null,"29,3 °C/24,1 °C",null,"26,8 °C/26,4 °C",null,"h",9]
["22.","19,0 °C/20,4 °C",null,"29,8 °C/24,0 °C",null,"28,4 °C/27,8 °C",null,"h",9]
["23.","19,6 °C/21,4 °C",null,"30,0 °C/24,4 °C",null,"28,8 °C/28,1 °C",null,"n",9]
["24.","19,8 °C/ 21,5 °C",null,"29,9 °C/24,2 °C",null,"26,4 °C/28,3 °C",null,"n",9]
["25.","22,4 °C/23,4 °C",null,"28,2 °C/23,0 °C",null,"28,0 °C/27,3 °C",null,"n",9]
["26.","21,4 °C/22,2 °C",null,"30,0 °C/24,4 °C",null,"29,0 °C/28,2 °C",null,"n",9]
["27.","23,6 °C/ 22,8 °C",null,"32,3 °C/26,4 °C",null,"31,0 °C/29,9 °C",null,"n",9]
["28.","25,8 °C/25,6 °C",null,"31,0 °C/26,8 °C",null,"31,8 °C/30,2 °C",null,"n",9]
["29.","23,6 °C/24,6 °C",null,"27,6 °C/25,6 °C",null,"24,0 °C/25,4 °C",null,"t"]
["30.","20,2 °C/21,6 °C",null,"24,8 °C/23,6 °C",null,"24,0 °C/24,8 °C",null,"n"]
["31.","19,8 °C/20,8 °C",null,"23,0 °C/21,4 °C",null,"22,7 °C/24,4 °C",null,"n"]