{"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":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,95,1020.8,10,8,null,"00",0,79,1019.9,9.4,8]
["01",1,92,1021.1,9.1999999999999993,8,null,"01",0,76,1019.8,9.1,8]
["02",1,91,1021.4,8.5,8,null,"02",1,76,1019.2,9.3000000000000007,7]
["03",1,90,1021.3,7.6,7,null,"03",1,76,1019,9.4,7]
["04",1,90,1021.6,7.2,7,null,"04",1,75,1018.6,9.5,7]
["05",1,90,1021.8,7,7,null,"05",1,75,1018.4,9.9,7]
["06",0,88,1022,7.3,6,null,"06",1,74,1018.2,10.8,7]
["07",1,84,1022,7.5,7,null,"07",null,null,null,null,7]
["08",1,82,1022.3,7.9,7,null,"08",null,null,null,null,7]
["09",1,76,1022.7,7.6,7,null,"09",null,null,null,null,7]
["10",1,73,1022.8,7.3,7,null,"10",null,null,null,null,3]
["11",1,70,1022.9,6.8,7,null,"11",null,null,null,null,7]
["12",1,66,1022.7,7.2,7,null,"12"]
["13",1,63,1022.4,6.7,7,null,"13"]
["14",1,60,1022.1,6.5,7,null,"14"]
[15,1,61,1022,7.3,7,null,"15"]
["16",1,62,1021.5,8.3000000000000007,7,null,"16"]
["17",1,61,1021,7.6,7,null,"17"]
["18",1,62,1020.7,7.9,5,null,"18"]
["19",1,66,1020.6,8.1,7,null,"19"]
["20",0,77,1020.3,9.6,7,null,"20"]
["21",0,78,1020.6,9.4,8,null,"21"]
["22",0,79,1020.6,9.5,8,null,"22"]
["23",0,81,1020.4,9.6999999999999993,8,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.8},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":76.5},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1021.6},{"$f":"AVERAGE(E3:E26)","v":7.9874999999999998},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":7.1},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.7},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":75.900000000000006},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1019},{"$f":"AVERAGE(L3:L26)","v":9.6285714285714299},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":6.8}]
[]
[null,null,null,null,"2013-06-30",null,null,null,null,null,null,"2013-07-01"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,95,1022.3,7.8,6,null,"00",0,95,1019.3,9.5,7]
["01",0,96,1021.9,7.1,4,null,"01",0,96,1019.1,9.4,7]
["02",1,96,1021.6,6.6,4,null,"02",0,96,1018.5,9.6,7]
["03",0,96,1021.4,6.4,5,null,"03",0,96,1018.2,9.6999999999999993,8]
["04",1,96,1021.3,6.3,7,null,"04",0,95,1017.7,9.8000000000000007,8]
["05",0,97,1021.4,6.9,8,null,"05",0,95,1017.6,10,8]
["06",0,96,1021.4,8,8,null,"06",0,96,1017.6,10.4,8]
["07",1,97,1021.4,9.4,8,null,"07",0,97,1017.3,11,8]
["08",1,94,1021.2,11.4,8,null,"08",0,88,1016.9,11.6,8]
["09",1,85,1020.9,12.1,6,null,"09",1,78,1016.6,11.4,8]
["10",0,78,1020.8,10.7,7,null,"10",1,73,1016.3,11.7,8]
["11",0,75,1020.6,10.8,6,null,"11",1,69,1016.2,11,8]
["12",0,72,1020.3,10.4,7,null,"12",1,70,1016,11.9,8]
["13",0,73,1020.2,11.3,6,null,"13",1,66,1015.2,11.8,8]
["14",1,72,1019.7,11.6,6,null,"14",1,64,1015.3,10.8,8]
["15",0,68,1019.5,10.8,7,null,"15",1,70,1015.6,11.2,8]
["16",0,74,1019.3,11.8,7,null,"16",1,75,1015.9,11.7,8]
["17",1,68,1019.2,10.1,7,null,"17",1,88,1016.3,12.5,8]
["18",1,79,1018.9,10.7,7,null,"18",0,88,1016.3,13.2,8]
["19",0,77,1018.9,11.2,7,null,"19",1,85,1016.5,12.2,8]
["20",0,85,1019,11.2,7,null,"20",1,92,1017,12.2,8]
["21",1,87,1019.9,10.6,7,null,"21",1,97,1018.1,12.4,8]
["22",1,93,1019.9,10.5,7,null,"22",1,96,1019.2,11,8]
["23",0,94,1019.8,9.5,7,null,"23",1,96,1020.4,10.5,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":0.5},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":85.1},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1020.5},{"$f":"AVERAGE(E33:E56)","v":9.716666666666665},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":6.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":0.6},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":85.9},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1017.2},{"$f":"AVERAGE(L33:L56)","v":11.104166666666666},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":7.9}]
[]
[null,null,null,null,"2013-06-28",null,null,null,null,null,null,"2013-06-29"]

{"sheet":"Kurztabelle","index":1,"n_rows":53,"n_cols":34,"rows_kept":53,"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:","Juni",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.",11.9,15.3,7.9,7.8,97,98,7.6,28.8,"R",null,".",1005.8,11.6,1,null,null,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"]
["02.",9.9,12.8,8.5,8.9,97,99,8,45.4,"R",null,".",1013.1,9.8000000000000007,1,null,null,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":6},{"$f":"COUNTIF(I6:I15,\">=1\")","v":5},{"$f":"COUNTIF(I6:I15,\">=3\")","v":4},{"$f":"COUNTIF(I6:I15,\">=10\")","v":4}]
["03.",8.6,10.6,7.1,7.2,93,96,7.9,18,"R",null,".",1020.8,8,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":3},{"$f":"COUNTIF(C18:C27,\">=25\")","v":5},{"$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":2},{"$f":"COUNTIF(I18:I27,\">=10\")","v":1}]
["04.",11,14.3,8.9,7.2,90,94,6.7,0.9,"R",null,0.3,1019.9,10.1,1,null,null,1,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":7},{"$f":"COUNTIF(I30:I39,\">=1\")","v":6},{"$f":"COUNTIF(I30:I39,\">=3\")","v":3},{"$f":"COUNTIF(I30:I39,\">=10\")","v":2}]
["05.",13.3,19.3,6.2,5.6,46,73,2.2999999999999998,".",null,null,12.8,1020.4,8.1,1,null,null,null,null,null,null,3]
["06.",14.7,20.2,9.6,10,67,86,5,".",null,null,3.3,1021.3,12.3,1,null,null,null,null,null,null,3,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.",16.7,23.6,10.8,10.6,65,87,5.5,1.1000000000000001,"R",null,6.3,1020.2,14.5,1,null,null,1,1,null,null,3,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":5},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",17,22.8,11.7,12.2,65,87,6.6,".",null,null,5.3,1016.3,14.7,1,null,null,null,1,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":1}]
["09.",16.100000000000001,20.9,13.1,13.9,75,92,6.3,17.2,"R",null,3.3,1009.9,14.8,1,null,null,1,1,null,null,3,2,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":3},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":0}]
["10.",14.4,16.899999999999999,13.1,13.9,65,91,7.3,".",null,null,0.3,1009,12.9,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":133.60000000000002},{"$f":"SUM(C6:C15)","v":176.70000000000002},{"$f":"SUM(D6:D15)","v":96.899999999999991},{"$f":"SUM(E6:E15)","v":97.300000000000011},"XXX",{"$f":"SUM(G6:G15)","v":903},{"$f":"SUM(H6:H15)","v":63.199999999999996},{"$f":"SUM(I6:I15)","v":111.4},{"$f":"SUM(K6:K15)","v":0},null,{"$f":"SUM(L6:L15)","v":31.600000000000005},{"$f":"SUM(M6:M15)","v":10156.700000000001},{"$f":"SUM(N6:N15)","v":116.80000000000001},{"$f":"SUM(O6:O15)","v":10},{"$f":"COUNT(P6:P15)","v":0},"X",{"$f":"SUM(R6:R15)","v":6},{"$f":"SUM(S6:S15)","v":3},{"$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":"SUM(B16/10)","v":13.360000000000003},{"$f":"AVERAGE(C16/10)","v":17.670000000000002},{"$f":"AVERAGE(D16/10)","v":9.69},{"$f":"E16/10","v":9.73},"XXX",{"$f":"AVERAGE(G16/10)","v":90.3},{"$f":"AVERAGE(H16/10)","v":6.3199999999999994},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M16/10)","v":1015.6700000000001},{"$f":"AVERAGE(N16/10)","v":11.680000000000001},{"$f":"O16/10","v":1},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":3.4},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":3},{"$f":"COUNTIF(L6:L15,\"<1\")","v":2},{"$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.",15.2,20.9,9.1999999999999993,8.9,44,74,3.2,".",null,null,10.7,1015.5,10.199999999999999,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$f":"COUNTIF(L18:L27,\">=10\")","v":6},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",17,23.6,9.1,8.9,39,70,2.6,".",null,null,11,1019.5,10.8,1,null,null,null,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":4},{"$f":"COUNTIF(L30:L39,\"<1\")","v":1},{"$f":"COUNTIF(L30:L39,\">=10\")","v":1},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",19.899999999999999,26.1,12.2,11.7,51,68,4.5999999999999996,4,"R",null,7.2,1016.2,13.6,1,null,null,1,null,null,null,3]
["14.",15.7,19.8,10.8,10.6,50,74,6,".",null,null,5.0999999999999996,1018.4,10.9,1,null,null,null,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",16.899999999999999,23.1,7.9,7.8,50,74,5.2,".",null,null,8.1999999999999993,1015.5,11.8,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":25.8},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":33.200000000000003},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":5.6},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":45.4}]
["16.",18.2,23.3,12.9,12.8,46,64,5.2,".",null,null,9,1016.1,11.1,1,null,null,null,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",19.8,27.2,10.9,11.1,53,77,5.0999999999999996,".",null,null,10,1016.4,15.3,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":8.6},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":6.2},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":39},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",24.6,30.6,17.100000000000001,17.2,55,76,2.2000000000000002,".",null,null,15.2,1014.7,19.8,1,null,null,null,null,null,null,2]
["19.",25.8,32.200000000000003,18.5,18.3,51,77,1,".",null,null,15.2,1014.5,20.9,0,null,null,null,null,null,null,2]
["20.",25.8,33.200000000000003,17.2,17.8,53,76,3.2,45.1,"R",null,12,1010.4,21,1,null,null,1,1,null,null,5]
["Su",{"$f":"SUM(B18:B27)","v":198.9},{"$f":"SUM(C18:C27)","v":260},{"$f":"SUM(D18:D27)","v":125.8},{"$f":"SUM(E18:E27)","v":125.1},"XXX",{"$f":"SUM(G18:G27)","v":730},{"$f":"SUM(H18:H27)","v":38.300000000000004},{"$f":"SUM(I18:I27)","v":49.1},{"$f":"SUM(K18:K27)","v":0},null,{"$f":"SUM(L18:L27)","v":103.60000000000001},{"$f":"SUM(M18:M27)","v":10157.199999999999},{"$f":"SUM(N18:N27)","v":145.39999999999998},{"$f":"SUM(O18:O27)","v":9},{"$f":"COUNT(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":2},{"$f":"SUM(S18:S27)","v":1},{"$f":"SUM(T18:T27)","v":0},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B28/10)","v":19.89},{"$f":"AVERAGE(C28/10)","v":26},{"$f":"AVERAGE(D28/10)","v":12.58},{"$f":"AVERAGE(E28/10)","v":12.51},"XXX",{"$f":"AVERAGE(G28/10)","v":73},{"$f":"AVERAGE(H28/10)","v":3.8300000000000005},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M28/10)","v":1015.7199999999999},{"$f":"AVERAGE(N28/10)","v":14.539999999999997},{"$f":"O28/10","v":0.9},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3}]
["21.",20,24.9,15.9,15.6,52,76,4.2,".",null,null,10.199999999999999,1012.9,15.3,1,null,null,null,null,null,null,3]
["22.",19.5,24.3,13.8,13.3,52,73,3.3,".",null,null,9.6999999999999993,1015.4,14.4,1,null,null,null,null,null,null,3]
["23.",18.2,23.1,13.6,12.8,50,75,4.8,1.3,"R",null,4.7,1013.1,13.4,1,null,null,1,null,null,null,3]
["24.",15.2,17.899999999999999,11.6,13.3,70,85,7.8,24.9,"R",null,".",1017.3,12.6,0,null,null,1,null,null,null,2]
["25.",11.3,13.2,10,10,95,96,8,29.4,"R",null,".",1019.4,10.9,1,null,null,1,null,null,null,4]
["26.",10.7,12.8,8.9,9.4,71,86,7.8,0.9,"R",null,".",1022.9,8.3000000000000007,1,null,null,1,null,null,null,4]
["27.",11.8,17.399999999999999,8.6,8.3000000000000007,55,83,7,1.6,"R",null,0.6,1023.5,8.9,1,null,null,1,null,null,null,2]
["28.",12.3,18.399999999999999,6.7,6.7,62,85,6.6,1.1000000000000001,"R",null,1,1020.5,9.6999999999999993,1,null,null,1,null,null,null,2]
["29.",13.6,18.5,9.9,11.1,62,86,7.9,6.3,"R",null,".",1017.2,11.1,1,null,null,1,null,null,null,3]
["30.",12.3,16.2,8.1999999999999993,8.3000000000000007,58,76,7.1,".",null,null,3.8,1021.6,8,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B30:B39)","v":144.9},{"$f":"SUM(C30:C39)","v":186.70000000000002},{"$f":"SUM(D30:D39)","v":107.20000000000002},{"$f":"SUM(E30:E39)","v":108.8},"XXX",{"$f":"SUM(G30:G39)","v":821},{"$f":"SUM(H30:H39)","v":64.5},{"$f":"SUM(I30:I39)","v":65.5},{"$f":"SUM(K30:K39)","v":0},null,{"$f":"SUM(L30:L39)","v":30},{"$f":"SUM(M30:M39)","v":10183.799999999999},{"$f":"SUM(N30:N39)","v":112.60000000000001},{"$f":"SUM(O30:O39)","v":9},{"$f":"COUNT(P30:P39)","v":0},"X",{"$f":"SUM(R30:R39)","v":7},{"$f":"SUM(S30:S39)","v":0},{"$f":"SUM(T30:T39)","v":0},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B40/10)","v":14.49},{"$f":"AVERAGE(C40/10)","v":18.670000000000002},10.720000000000002,10.879999999999999,"XXX",{"$f":"AVERAGE(G40/10)","v":82.1},{"$f":"AVERAGE(H40/10)","v":6.45},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M40/10)","v":1018.3799999999999},{"$f":"AVERAGE(N40/10)","v":11.260000000000002},0.9,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":2.9}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":477.4},{"$f":"SUM(C16+C28+C40)","v":623.40000000000009},{"$f":"SUM(D16+D28+D40)","v":329.9},{"$f":"SUM(E16+E28+E40)","v":331.2},"XXX",{"$f":"SUM(G16+G28+G40)","v":2454},{"$f":"SUM(H16+H28+H40)","v":166},{"$f":"SUM(I16+I28+I40)","v":226},{"$f":"SUM(J16+J28+J40)","v":0},null,{"$f":"SUM(L16+L28+L40)","v":165.20000000000002},{"$f":"SUM(M16+M28+M40)","v":30497.7},{"$f":"SUM(N16+N28+N40)","v":374.8},"XXX",{"$f":"SUM(P16+P28+P40)","v":0},"X",{"$f":"SUM(R16+R28+R40)","v":15},{"$f":"SUM(S16+S28+S40)","v":4},{"$f":"SUM(T16+T28+T40)","v":0},{"$f":"SUM(U16+U28+U40)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B17,B29,B41)","v":15.913333333333334},{"$f":"AVERAGE(C42/30)","v":20.780000000000005},{"$f":"AVERAGE(D42/30)","v":10.996666666666666},{"$f":"AVERAGE(E42/30)","v":11.04},"XXX",{"$f":"AVERAGE(G42/30)","v":81.8},{"$f":"AVERAGE(H42/30)","v":5.5333333333333332},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M42/30)","v":1016.59},{"$f":"AVERAGE(N42/30)","v":12.493333333333334},{"$error":"#VALUE!"},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":3.1}]
[]
[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,7]
["TTT",16.399999999999999,"XXXX",{"$f":"SUM(B43-B47)","v":-0.48666666666666458},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":3},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":13},"0,1 bis 0,9",null,null,null,null,null,2]
["RRR",62,{"$f":"SUM(I42*100/B48)","v":364.51612903225805},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":5},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":9},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":8}]
["sss",214,{"$f":"SUM(L42*100/B49)","v":77.196261682242991},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":7},"Schneedecke cm"]
["astr.",null,null,"XXXX","Min.d.Lufttemp.°C",null,null,null,null,null,null,">/=  20,0",null,null,5,">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",487,{"$f":"SUM(L42*100/B51)","v":33.921971252566735},"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":8},">/= 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":1}]

{"sheet":"Sichtst.","index":2,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Juni",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,1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-","-",1,1,1,null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-","-",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,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["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,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","01:30:00",1,1,1,1,"-","-",null,null,null,null,null,1.5," ",2,3,2]
["21.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,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,"-","-","-",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,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]
["Su.","XXXXXXXXX",{"$f":"SUM(C9:C38)","v":1},8,15,27,13,1]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":1}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39)","v":13}]

{"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)"]
[]
["Juni 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.200000000000003},"am","2013-06-20"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":15.913333333333336},{"$f":"Kurztabelle!B47","v":16.399999999999999},{"$f":"C7-D7","v":-0.48666666666666281},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":6.2},"am","2013-06-05"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":226},{"$f":"Kurztabelle!B48","v":62},{"$f":"100/D9*C9","v":364.51612903225805},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":165.20000000000002},{"$f":"Kurztabelle!B49","v":214},{"$f":"100/D10*C10","v":77.196261682243005},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":119,"n_cols":20,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2013-06-01",11.9,15.3,7.9,28.8,null,null,1005.8,13.85,null,null,"Von 10:50 Uhr - 12:19 Uhr starker Dunst. Von 06:40 Uhr - 10:49 Uhr; 12:20 Uhr - 13:19 Uhr; Von 20:20 Uhr - 23:59 Uhr  mäßiger Dunst. Von 13:20 Uhr - 15:19 Uhr leichter Dunst. Von 06:40 Uhr - 10:49 Uhr;  Von 20:20 Uhr - 23:59 Uhr Sichteinschränkung durch Starkniederschlag."]
["2013-06-02",9.9,12.8,8.5,45.4,null,null,1013.1,14,null,null,"Von 00:00 Uhr - 08:59 Uhr mäßiger Dunst. Von 09:00 Uhr - Uhr leichter Dunst. Von 00:00 Uhr - 08:59 Uhr; 09:39 Uhr - Uhr Sichteinschränkung durch Starkniederschlag."]
["2013-06-03",8.6,10.6,7.1,18,null,null,1020.8,14.2]
["2013-06-04",11,14.3,8.9,0.9,null,0.3,1019.9,14.35,"HNFz","H Sabine"]
["2013-06-05",13.3,19.3,6.2,null,null,12.8,1020.4,14.55,null,"H Therese"]
["2013-06-06",14.7,20.2,9.6,null,null,3.3,1021.3,14.75,null,null,"Beginn der Himbeerblüte. "]
["2013-06-07",16.7,23.6,10.8,null,null,6.3,1020.2,14.95,"TrW",null,"Mäßig schwül."]
["2013-06-08",17,22.8,11.7,null,null,5.3,1016.3,15.15,"TrM",null,"Mäßig schwül."]
["2013-06-09",16.100000000000001,20.9,13.1,17.2,null,3.3,1009.9,15.35,"Wz","T Ira","Mäßig schwül. Von 20:20 Uhr - 23:59 Uhr leichter Dunst."]
["2013-06-10",14.4,16.899999999999999,13.1,null,null,0.3,1009,15.55,null,null,"Von 06:30 Uhr - 07:19 Uhr starker Dunst. Von 03:00 Uhr - 06:29 Uhr; 07:30 Uhr - 08:39 Uhr mäßiger Dunst. Von 00:00 Uhr - 02:59 Uhr leichter Dunst."]
["2013-06-11",15.2,20.9,9.1999999999999993,null,null,10.7,1015.5,15.75,"Ww","H Therese","Beginn des phänologischen Frühsommers."]
["2013-06-12",17,23.6,9.1,null,null,11,1019.5,15.95,null,null,"Beginn der Klatschmohnblüte."]
["2013-06-13",19.899999999999999,26.1,12.2,4,null,7.2,1016.2,16.149999999999999,"SWz","T Jörn"]
["2013-06-14",15.7,19.8,10.8,null,null,5.0999999999999996,1018.4,16.350000000000001,"Wz","T Karl-Heinz","Leicht schwül."]
["2013-06-15",16.899999999999999,23.1,7.9,null,null,8.1999999999999993,1015.5,16.55]
["2013-06-16",18.2,23.3,12.9,null,null,9,1016.1,16.7,"TrW"]
["2013-06-17",19.8,27.2,10.9,null,null,10,1016.4,16.899999999999999,"Sa","H Velvet","Stark schwül."]
["2013-06-18",24.6,30.6,17.100000000000001,null,null,15.2,1014.7,17.149999999999999,null,"H Uta","Extrem schwül. "]
["2013-06-19",25.8,32.200000000000003,18.5,null,null,15.2,1014.5,17.3,null,null,"Extrem schwül. "]
["2013-06-20",25.8,33.200000000000003,17.2,45.1,null,12,1010.4,17.350000000000001,"TrW","T Norbert","Extrem schwül. ",null,"Beginn der Gelbreife bei Gerste.",null,null,"Nacht zu heute Tropennacht (20,8 °C).",null,null,"Von 21:40 Uhr - 23:09 Uhr leichter Nebel. Von 21:40 Uhr - 22:19 Uhr Sichteinschränkung durch Starkniederschlag."]
["2013-06-21",20,24.9,15.9,null,null,10.199999999999999,1012.9,17.45,null,null,"Mäßig schwül."]
["2013-06-22",19.5,24.3,13.8,null,null,9.6999999999999993,1015.4,17.5,null,"T Othello","Leicht schwül."]
["2013-06-23",18.2,23.1,13.6,1.3,null,4.7,1013.1,17.55,null,null,"Leicht schwül."]
["2013-06-24",15.2,17.899999999999999,11.6,24.9,null,0,1017.3,17.600000000000001,null,null,"Beginn des phänologischen Hochsommers."]
["2013-06-25",11.3,13.2,10,29.4,null,0,1019.4,17.649999999999999,"Sez","T Petar","Beginn der Sommerlindenblüte."]
["2013-06-26",10.7,12.8,8.9,0.9,null,0,1022.9,17.7,"TrM"]
["2013-06-27",11.8,17.399999999999999,8.6,1.6,null,0.6,1023.5,17.75,null,null,"Beginn der Kartoffelblüte."]
["2013-06-28",12.3,18.399999999999999,6.7,1.1000000000000001,null,1,1020.5,17.8]
["2013-06-29",13.6,18.5,9.9,6.3,null,0,1017.2,17.850000000000001,"NWz",null,"Von 20:00 Uhr - 23:59 Uhr mäßiger Dunst. Von 19:50 Uhr - 19:59 Uhr leichter Dunst. Von 19:50 Uhr - 23:29 Uhr Sichteinschränkung durch Niederschlag."]
["2013-06-30",12.3,16.2,8.1999999999999993,null,null,3.8,1021.6,17.899999999999999,null,null,"Von 00:00 Uhr - 00:39 Uhr leichter Dunst."]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":15.913333333333336},{"$f":"AVERAGE(C2:C31)","v":20.780000000000005},{"$f":"AVERAGE(D2:D31)","v":10.996666666666666},null,null,null,{"$f":"AVERAGE(H2:H31)","v":1016.5900000000003},{"$f":"AVERAGE(I2:I31)","v":16.32}]
["Mittel",16.399999999999999,null,null,62,"-",214,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]