{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Solarer Deckungsgrad","HGT Heizgradtage Schweiz","HGT Heizgradtage Deutschland"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Solarer Deckungsgrad","index":0,"n_rows":49,"n_cols":33,"rows_kept":49,"cut":false,"hidden":false,"merged":[[7,1,7,3],[14,24,14,25],[21,24,21,25],[22,24,22,25],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Ermittlung des solaren Deckungsgrades für Sonnehäuser"]
["mit grossem Speicher im Zentrum des Hauses"]
["Solarsystem Jenni"]
[]
[]
["Datum:","2016-10-27"]
[]
["Objekt:"]
[]
["Speicher Swiss Solartank®",0,"l",{"$error":"#DIV/0!"},{"$nulls":6},"Manko:",3395.96,"kWh"]
["max. E-Inhalt Speicher",0,"kWh",{"$nulls":7},"Überschuss:",0,"kWh"]
["Kollektornutzfläche",0,"m2",0,"LTS Kollektortyp"]
["Neigung",0,"°",0,"° Südabweichung (+O/-W)",{"$nulls":5},"Solarer Deckungsgrad",null,0,null,null,"%",{"$nulls":5},"Kollektor-Ertrag in kWh pro m2 und Monat"]
["Wärmebedarf QH",0,"kW    bei",-8,"°C"]
["Vollbetriebsstunden",16,"h",{"$nulls":7},"Kollektorertrag",null,{"$error":"#DIV/0!"},null,null,"kWh/m²",{"$nulls":5},"Kollektortyp:",{"$nulls":8},"LTS"]
["Warmwasserbedarf",160,"l/Tag, 60°C","DT = 50K"]
["Fensterfläche Süd",14.24,"m2"]
["Glasanteil an Fensterfl.",0.75,"-"]
["Verlustfaktor",0.6,"-"]
["Energiedurchlassgrad",0.95,"-"]
["Anzahl Personen",2,"-",{"$nulls":18},"Standort:"]
[{"$nulls":15},"Ende","Monat",{"$nulls":4},"Neigung:",{"$nulls":4},"°"]
[null,"Tage","Koll Temp.","Kollektor","Kollfläche","Globalstrahlung","Südfenster","Innere Abwärme","HGT 12/20","Wärmebedarf","WW","Total","Fehlbetrag","SP_OUT","SP_IN","SP Saldo","Tsp",{"$nulls":4},"Ausrichtung:",{"$nulls":4},"° Abweichung v. Süd (+ Richt. Ost / - Richt. West*)"]
[null,"-","°C","kWh/m2","kWh","Süd 70°","kWh","kWh",null,"kWh","kWh","kWh","kWh","kWh","kWh","kWh","°C",{"$nulls":9},"*gilt für SPF-Kollektorkatalog 2008 oder jünger"]
["Januar",31,30,0,0,40.8,248.37407999999996,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0,"T [°C]",null,"Jan.","Feb.","März","April","Mai","Juni","Juli","Aug.","Sep.","Okt.","Nov.","Dez."]
["Februar",28,50,0,0,64.3,391.43267999999995,174.72,0,0,260.512,260.512,260.512,260.512,0,0,{"$error":"#DIV/0!"},null,0]
["März",31,70,0,0,91.3,555.79788,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0,30]
["April",30,90,0,0,110,669.6360000000001,187.2,0,0,279.12000000000006,279.12000000000006,279.12000000000006,279.12000000000006,0,0,{"$error":"#DIV/0!"},null,0,40]
["Mai",31,90,0,0,118,718.3367999999999,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0,50]
["Juni",30,100,0,0,113,687.8988,187.2,0,0,279.12000000000006,279.12000000000006,279.12000000000006,279.12000000000006,0,0,{"$error":"#DIV/0!"},null,0,60]
["Juli",31,100,0,0,126,767.0376,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0,80]
["August ",31,100,0,0,123,748.7747999999998,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0,100,null,0,0,0,0,0,0,0,0,0,0,0,0]
["September",30,90,0,0,106,645.2855999999999,187.2,0,0,279.12000000000006,279.12000000000006,279.12000000000006,279.12000000000006,0,0,{"$error":"#DIV/0!"},null,0]
["Oktober",31,80,0,0,72.9,443.78603999999996,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0]
["November",30,50,0,0,50.5,307.42379999999997,187.2,0,0,279.12000000000006,279.12000000000006,279.12000000000006,279.12000000000006,0,0,{"$error":"#DIV/0!"},null,0,null,null,"Jan.","Feb.","März","April","Mai","Juni","Juli","Aug.","Sep.","Okt.","Nov.","Dez."]
["Dezember",31,30,0,0,40.8,248.37407999999996,193.44,0,0,288.42400000000004,288.42400000000004,288.42400000000004,288.42400000000004,0,0,{"$error":"#DIV/0!"},null,0,"Heizgradtage"]
["Total",null,null,null,0,null,null,null,0,0,3395.96,3395.96,3395.96,3395.96,0]
[{"$nulls":19},"HGT 12/20: Datenquelle -> siehe weitere Tabellenblätter"]
[]
[null,null,"Eingabe Objektname/Heizgradtage/Grunddaten/Arbeitstemperatur etc."]
[null,null,"Formelberechnet/übernommen"]
[null,null,"Endergebnis"]
[]
["©Jenni Energietechnik AG, www.jenni.ch"]
[]
["Bei den Ergebnissen handelt es sich um Richtwerte, die nur so gut sind, wie die getroffenen Annahmen, auf denen sie basieren."]
["Die Annahmen/Daten müssen projektspezifisch hinterfragt und angepasst werden."]
["Die vorliegenden Informationen entsprechen dem aktuellen Stand unserer Erfahrungen."]
["Rechtsansprüche können daraus keine abgeleitet werden."]

{"sheet":"HGT Heizgradtage Schweiz","index":1,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Klimastation",null,"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez",null,"HGT 20/12"]
[]
[null,"Airolo",null,708,598,583,447,300,110,41,59,156,376,547,690,null,4615]
[]
[null,"Bad Ragaz",null,646,523,483,273,145,44,21,24,63,259,438,662,null,3581]
[]
[null,"Basel-Binningen",null,619,500,465,273,120,27,7,8,47,233,442,607,null,3348]
[]
[null,"Beatenberg",null,666,571,571,417,289,138,74,89,140,302,495,652,null,4404]
[]
[null,"Bern",null,661,532,499,305,148,42,16,17,66,262,475,645,null,3668]
[]
[null,"Beznau",null,634,520,497,295,149,26,8,10,56,249,453,613,null,3510]
[]
[null,"Comprovasco",null,605,502,454,269,118,24,4,4,52,245,451,576,null,3304]
[]
[null,"Davos",null,813,712,700,528,401,214,151,195,282,460,618,807,null,5884]
[]
[null,"Delsberg",null,650,529,505,327,172,36,14,17,78,254,464,637,null,3683]
[]
[null,"Disentis",null,678,593,579,420,281,114,60,78,137,315,507,677,null,4439]
[]
[null,"Einsiedeln",null,710,598,591,421,276,103,54,68,156,349,511,703,null,4540]
[]
[null,"Fey-Nendaz",null,657,539,508,329,164,51,17,31,89,274,476,645,null,3780]
[]
[null,"Fribourg",null,666,644,521,337,181,59,21,29,87,283,490,654,null,3872]
[]
[null,"Genf",null,591,481,451,250,85,11,0,0,24,202,409,568,null,3072]
[]
[null,"Glarus",null,683,554,530,318,172,50,22,27,86,287,469,678,null,3876]
[]
[null,"Heiden",null,683,577,566,377,267,101,58,65,144,323,484,687,null,4332]
[]
[null,"Kreuzlingen",null,649,538,508,302,165,41,12,12,65,276,465,635,null,3668]
[]
[null,"la Chaux-de-Fonds",null,659,559,557,390,257,97,46,59,120,302,489,650,null,4185]
[]
[null,"Langenbruck",null,682,566,554,367,228,70,30,36,114,305,505,675,null,4132]
[]
[null,"Lausanne",null,620,506,473,277,130,32,11,11,52,212,443,610,null,3377]
[]
[null,"Locarno-Monti",null,547,445,366,174,41,7,2,0,12,132,386,519,null,2631]
[]
[null,"Lugano",null,561,450,382,185,36,5,0,0,5,112,375,533,null,2644]
[]
[null,"Luzern",null,653,529,498,300,151,46,16,15,67,273,468,637,null,3653]
[]
[null,"Montana",null,693,610,601,453,316,154,89,121,173,351,536,682,null,4779]
[]
[null,"Neuchâtel",null,633,517,481,280,127,28,6,8,41,232,450,611,null,3414]
[]
[null,"Olten",null,643,528,499,301,149,32,12,12,65,259,462,626,null,3588]
[]
[null,"Schaffhausen",null,663,538,504,287,154,36,15,18,73,278,478,651,null,3695]
[]
[null,"Sion",null,639,502,445,227,74,11,2,4,34,215,451,633,null,3237]
[]
[null,"St. Gallen",null,675,559,538,346,222,72,34,45,106,306,474,669,null,4046]
[]
[null,"Zürich SMA",null,655,533,502,305,167,54,22,26,74,261,471,647,null,3717]
[]
[null,"Zürich Stadt",null,615,501,467,255,110,23,7,6,35,207,433,601,null,3260]

{"sheet":"HGT Heizgradtage Deutschland","index":2,"n_rows":85,"n_cols":17,"rows_kept":85,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Klimastation",null,"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez",null,"HGT 20/12"]
[]
[null,"Aachen",null,528,469,418,303,124,39,6,5,63,232,394,494,null,3074]
[]
[null,"Augsburg",null,643,554,482,343,133,45,10,13,108,318,498,604,null,3750]
[]
[null,"Bamberg",null,629,541,474,320,115,28,2,8,99,311,482,585,null,3593]
[]
[null,"Berlin",null,604,523,468,300,91,14,0,2,57,265,453,562,null,3340]
[]
[null,"Bremen",null,574,508,470,331,132,35,4,4,77,278,436,535,null,3384]
[]
[null,"Dresden",null,619,536,475,322,117,33,4,6,84,275,466,574,null,3510]
[]
[null,"Düsseldorf",null,526,463,408,279,99,18,0,1,46,211,387,490,null,2928]
[]
[null,"Emden",null,520,458,448,310,128,25,0,0,38,257,418,525,null,3127]
[]
[null,"Erfurt",null,636,560,502,358,157,57,12,13,107,312,486,596,null,3796]
[]
[null,"Fichtelberg",null,756,685,679,556,385,267,195,171,329,486,624,720,null,5852]
[]
[null,"Frankfurt am Main",null,575,496,418,266,85,13,0,1,48,257,440,539,null,3137]
[]
[null,"Fritzlar",null,585,486,457,298,98,18,0,0,102,286,424,585,null,3339]
[]
[null,"Görlitz",null,644,557,498,341,131,41,6,10,107,299,485,600,null,3718]
[]
[null,"Greifswald",null,610,545,509,368,164,26,1,3,72,288,464,575,null,3625]
[]
[null,"Hamburg",null,583,515,481,345,146,35,3,4,80,281,441,544,null,3457]
[]
[null,"Hannover",null,578,512,469,329,129,35,3,4,78,273,434,540,null,3384]
[]
[null,"Hof",null,688,602,551,413,207,102,41,41,176,381,539,647,null,4388]
[]
[null,"Hohenpeissenberg",null,647,580,541,430,242,136,70,64,179,346,515,612,null,4362]
[]
[null,"Karlsruhe",null,562,478,392,245,73,9,0,1,41,228,424,527,null,2981]
[]
[null,"Kassel",null,601,526,466,321,130,42,8,8,87,290,464,565,null,3509]
[]
[null,"Kempten",null,665,580,525,405,196,85,32,33,148,346,523,631,null,4169]
[]
[null,"Konstanz",null,602,519,438,301,103,30,5,5,61,270,467,567,null,3366]
[]
[null,"Leipzig",null,603,534,471,325,116,29,2,4,71,275,465,573,null,3468]
[]
[null,"Lindenberg",null,633,547,493,325,116,31,3,6,87,292,479,591,null,3602]
[]
[null,"List/Sylt",null,572,524,519,398,209,58,2,0,45,244,416,517,null,3505]
[]
[null,"Magdeburg",null,607,532,477,323,115,30,2,3,75,286,460,567,null,3478]
[]
[null,"Meiningen",null,669,583,519,372,175,87,27,25,172,356,522,625,null,4102]
[]
[null,"München",null,643,532,470,301,86,23,6,8,105,292,497,607,null,3571]
[]
[null,"Neuruppin",null,610,541,496,335,116,25,2,2,79,290,465,572,null,3533]
[]
[null,"Nürburg",null,613,517,477,353,181,72,28,17,131,331,483,589,null,3792]
[]
[null,"Nürnberg",null,622,537,467,318,109,28,3,7,89,298,478,584,null,3539]
[]
[null,"Potsdam",null,622,540,484,319,111,28,3,5,85,294,473,582,null,3546]
[]
[null,"Rostock",null,592,526,503,380,178,26,0,0,53,268,440,543,null,3509]
[]
[null,"Saarbrücken",null,592,510,448,318,135,45,8,8,84,384,458,557,null,3447]
[]
[null,"Schleswig",null,593,533,514,390,199,57,5,5,94,300,452,551,null,3694]
[]
[null,"Schwerin",null,609,538,500,354,146,39,2,3,81,294,461,564,null,3593]
[]
[null,"Straubing",null,678,542,481,308,91,18,4,4,115,332,501,630,null,3704]
[]
[null,"Stuttgart",null,609,526,456,319,121,35,5,8,84,287,472,574,null,3498]
[]
[null,"Trier",null,578,501,439,310,126,35,6,6,76,269,447,544,null,3337]
[]
[null,"UFS TW Ems",null,463,426,441,367,222,4,0,160,180,130,305,420,null,3117]
[]
[null,"Westermakelsdorf",null,603,541,532,413,214,30,0,0,43,259,427,531,null,3594]
[]
[null,"Würzburg",null,611,524,446,297,105,28,2,5,72,286,468,571,null,3414]