{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["AutoCalc","Kapitalkosten 2% Zins","Kapitalkosten 3% Zins","Kapitalkosten 5% Zins","Kapitalkosten 8% Zins"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"AutoCalc","index":0,"n_rows":261,"n_cols":19,"rows_kept":261,"cut":false,"hidden":false,"merged":[[70,12,70,18],[58,2,58,4],[71,12,71,18],[104,17,104,18],[79,5,79,6],[79,9,79,10],[102,14,102,16],[103,14,103,16],[104,14,104,16],[37,2,37,4],[38,2,38,4],[56,2,56,4],[57,2,57,4],[59,2,59,4],[32,2,32,5],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[0,1,0,12],[3,2,3,4],[6,2,6,4],[10,2,10,4],[31,2,31,4],[30,2,30,4],[11,2,11,4],[11,9,11,10],[12,2,12,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[28,2,28,4],[29,2,29,4],[105,17,105,18],[242,12,242,15],[195,4,195,5],[202,12,202,14],[203,4,203,5],[210,12,210,14],[211,4,211,5],[224,4,224,5],[223,12,223,15],[194,12,194,14],[153,12,153,14],[247,12,247,15],[252,12,252,15],[116,3,116,4],[123,3,123,4],[130,3,130,4],[231,12,231,15],[237,12,237,15],[154,4,154,5],[168,1,168,18]]}
[1,"Energiespeicher mit zentralem Oberbecken und gestrecktem Unterbecken in Regionen mit natürlichen Höhenunterschieden"]
[{"$f":"A1+1","v":2}]
[{"$f":"A2+1","v":3},"Auslegungsparameter:"]
[4,null,"Oberbecken Außendurchmesser auf Geländeniveau",null,null,"Da",3000,"[m]"]
[5,null,"maximale Pegeldifferenz im Oberbecken",null,null,"Po",90,"[m]"]
[6,null,"maximale Pegeldifferenz im Unterbecken",null,null,"Pu",20,"[m]"]
[7,null,"mittlere Breite des Unterbeckens",null,null,"Bmu",1000,"[m]",null,"damit wird indirekt das Verhältnis von Uferlänge zu Beckeninhalt festgelegt. "]
[8,null,"prozentuale Volumenreserve",null,null,"pVr",0,null,null,"Aushubvolumen, das nicht für den Wall eingesetzt wird"]
[9]
[10,"geometrische Daten der Landschaft"]
[11,null,"Höhenniveau des Oberbeckens",null,null,"Hno",120,"[m]"]
[12,null,"Höhenniveau des Unterbeckens",null,null,"Hnu",0,"[m]",null,"Bezugsebene"]
[13,null,"Höhenniveau der Wasserressource",null,null,"Hnw",-24,"[m]",null,"dieses sollte nicht über dem Niedrigstwasserstand des Unterbeckens liegen"]
[14]
[15,"geometrische Vorgaben für das Oberbecken"]
[16,null,"Außendurchmesser auf Geländeniveau",null,null,"Da",{"$f":"G4","v":3000},"[m]","=",{"$f":"G16/1000","v":3},"[km]"]
[17,null,"Kronenbreite des Walles",null,null,"Bk",15,"[m]","=",{"$f":"G17/1000","v":1.4999999999999999E-2},"[km]"]
[18,null,"Freibordhöhe",null,null,"Hf",2,"[m]","=",{"$f":"G18/1000","v":2E-3},"[km]"]
[19,null,"Ausbildung der Böschungen",null,null,null,"Höhe",null,"Länge","Gefälle","Winkel"]
[20,null,"Böschung der Außenseite",null,null,"Ba",1,"[mhor/mver]",2,{"$f":"G20/I20","v":0.5},{"$f":"DEGREES(ATAN(J20))","v":26.56505117707799},null,"Hinweis: ","[mhor/mver] = [mhorizontal/mvertikal]"]
[21,null,"Böschung der Innenseite",null,null,"Bi",1,"[mhor/mver]",2,{"$f":"G21/I21","v":0.5},{"$f":"DEGREES(ATAN(J21))","v":26.56505117707799}]
[22,null,"Maximal vorgesehene Pegelabsenkung",null,null,"Po",{"$f":"G5","v":90},"[m]","=",{"$f":"G22/1000","v":0.09},"[km]"]
[23,null,"Formfaktor zur Ermittlung der Wallhöhe",null,null,"Ff ",0.27574644471856863,null,null,"je nach Durchmesser / Höhen Verhältnis des Ringwalls wird damit eine Aushubreserve gesteuert"]
[24,null,"Wallumfang am Außenfuß",null,null,"Uwa",{"$f":"G16*PI()","v":9424.7779607693792},"[m]","=",{"$f":"G24/1000","v":9.4247779607693793},"[km]",null,"= Da * π"]
[25]
[26,"geometrische Vorgaben für das Unterbecken"]
[27,null,"Stauziel Unterbecken unter Gelände Hnu",null,null,"To",1,"[m]","=",{"$f":"G27/1000","v":1E-3},"[km]"]
[28,null,"Pegelschwankung Unterbecken",null,null,"Pu",{"$f":"G6","v":20},"[m]","=",{"$f":"G28/1000","v":0.02},"[km]"]
[29,null,"Absenkziel Unterbecken",null,null,"Tu",{"$f":"G27+G28","v":21},"[m]","=",{"$f":"G29/1000","v":2.1000000000000001E-2},"[km]",null,"= To + Pu"]
[30,null,"Mindestwasserstand im Unterbecken",null,null,"Tmu",3,"[m]","=",{"$f":"G30/1000","v":3.0000000000000001E-3},"[km]"]
[31,null,"Ausgrabungstiefe Unterbecken",null,null,"Ta",{"$f":"G29+G30","v":24},"[m]","=",{"$f":"G31/1000","v":2.4E-2},"[km]",null,"= Tu + Tmu"]
[32,null,"Restwasservolumen im Unterbecken",null,null,"Vru",{"$f":"G36*G30*(G35-I34*(2*G29+G30))","v":42721547.500766255},"[m³]","=",{"$f":"G32/1000/1000/1000","v":4.2721547500766253E-2},"[km³]",null,"= Tmu * Lmu * (Bmu - BA * (2 * Tu + Tmu))"]
[33,null,"Böschungsverhältnisse",null,null,null,"Höhe",null,"Länge","Gefälle","Winkel"]
[34,null,"Gefälle von außen ins Unterbecken",null,null,"Bu",1,"[mhor/mver]",5,{"$f":"G34/I34","v":0.2},{"$f":"DEGREES(ATAN(J34))","v":11.309932474020215}]
[35,null,"mittlere Breite des Unterbeckens",null,null,"Bmu",{"$f":"G7","v":1000},"[m]","=",{"$f":"G35/1000","v":1},"[km]"]
[36,null,"mittlere Länge des Unterbeckens",null,null,"Lmu",18374.859140114517,"[m]","=",{"$f":"G36/1000","v":18.374859140114516},"[km]"]
[37,null,"Fläche des Unterbeckens",null,null,"Au",{"$f":"G35*G36","v":18374859.140114516},"[m²]","=",{"$f":"G37/1000/1000","v":18.374859140114516},"[km²]",null,"= Bmu * Lmu"]
[38,null,"Aushubvolumen des Unterbeckens",null,null,"Vb",{"$f":"G31*G36*(G35-G31*I34)","v":388077025.0392186},"[m³]","=",{"$f":"G38/1000/1000/1000","v":0.38807702503921859},"[km³]",null,"= Ta * Lmu * (Bmu - Bu * Ta)  "]
[39,null,"Austauschvolumen des Unterbeckens",null,null,"Vau",{"$f":"G28*G36*(G35-I34*(2*G27+G28))","v":327072492.69403839},"[m²]","=",{"$f":"G39/1000/1000/1000","v":0.32707249269403837},"[km³]",null,"= Pu * Lmu * (Bmu - Bu * (2 * To + Pu))  "]
[40,null,"fiktives Volumen eines geradlinigen Walls zur Höheberechnung",null,null,"Vf",{"$f":"G38*(1+G23)","v":495087884.97074211},"[m³]","=",{"$f":"G40/1000/1000/1000","v":0.49508788497074208},"[km³]",null,"= Vb * (1 + Ff)"]
[41]
[42,"Ausbildung des Ringwalls"]
[43,null,"Wallhöhe aus Aushubvolumen des Unterbeckens",null,null,"Hw",{"$f":"(2*G40/G24/(I20+I21) +(G17/(I20+I21))^2)^0.5-G17/(I20+I21)","v":158.35888486652553},"[m]","=",{"$f":"G43/1000","v":0.15835888486652552},"[km]",null,"= (2 * Vf / Uwa / (Ba + Bi) + (Bk / (Ba +Bi))^0,5 - Bk / (Ba + Bi) "]
[44,null,"Wallfußbreite",null,null,"Bw",{"$f":"G17+(I20+I21)*G43","v":648.43553946610211},"[m]","=",0.64843553946610211,"[km]",null,"= Bk + (Ba + Bi) * Hw"]
[45,null,"Wallinnendurchmesser am Beckenboden",null,null,"Di",{"$f":"G16-2*G44","v":1703.1289210677958},"[m]","=",1.7031289210677958,"[km]",null,"= Da - 2 * Bw"]
[46,null,"Wallinnendurchmesser bei maximalem Füllstand",null,null,"Dif",{"$f":"G45+2*(G43-G18)*I21","v":2328.564460533898},"[m]","=",2.3285644605338982,"[km]",null,"= Di - 2 * (Hw - Hf) * Bi"]
[47,null,"Wallinnendurchmesser bei minimalem Füllstand",null,null,"Dil",{"$f":"G46-2*G22*I21","v":1968.564460533898},"[m]","=",1.9685644605338981,"[km]",null,"= Di - 2 * (Hw - Hf) * Bi"]
[48,null,"Walldurchmesser am inneren Kronenrand",null,null,"Dki",{"$f":"G45+2*(G43)*I21","v":2336.564460533898},"[m]","=",2.3365644605338982,"[km]",null,"= Di - 2 * Hw * Bi"]
[49,null,"Walldurchmesser am äußeren Kronenrand",null,null,"Dka",{"$f":"G48+2*G17","v":2366.564460533898},"[m]","=",2.366564460533898,"[km]",null,"= Dki + 2 * Bk"]
[50,null,"exaktes Wallvolumen bei Idealform",null,null,"Vw",{"$f":"PI()/12*G43*(G16^2+G16*G49+G49^2-G48^2-G48*G45-G45^2)","v":388077025.04603064},"[m³]","=",{"$f":"G50/1000/1000/1000","v":0.38807702504603064},"[km³]",null,"= π / 12 * Hw * (Da^2 + Da * Dka + Dka^2 - Dki^2 - Dki * Di - Di^2)"]
[51,null,"Volumenreserve zur freien Verwendung",null,null,"Vr",{"$f":"G38-G50","v":-6.8120360374450684E-3},"[m³]","=",{"$f":"G51/1000/1000/1000","v":-6.8120360374450683E-12},"[km³]",null,"= Vb - Vw"]
[52,null,"prozentuale Volumenreserve",null,null,"pVi",{"$f":"G51/G50","v":-1.7553309260286869E-11},null,null,null,null,null,"= Vr / Vw"]
[53,null,"Seitenlänge der inneren Wallflanke",null,null,"Sw",{"$f":"(G43^2+(G43*I21)^2)^(1/2)","v":354.10123140261379},"[m]","=",{"$f":"G53/1000","v":0.35410123140261379},"[km]",null,"= (Hw^2 + (Hw * Bi)^2)^0,5"]
[54,null,"Innere Oberfläche des Walles",null,null,"Awi",{"$f":"G53*PI()/2*(G45+G48)","v":2246961.9433815},"[m²]","=",{"$f":"G54/1000/1000","v":2.2469619433815002},"[km²]",null,"= Sw * π / 2 * (Di + Dki)"]
[55]
[56,"resultierende Daten des Oberbeckens"]
[57,null,"Oberbeckenwasservolumen",null,null,"Vo",{"$f":"PI()/12*(G43-G18)*(G45^2+G45*G46+G46^2)","v":503034007.94759196},"[m³]","=",{"$f":"G57/1000/1000/1000","v":0.5030340079475919},"[km3]",null,"= π / 12 * (Hw - Hf) * (Dif^2 + Dif * Di + Di^2)"]
[58,null,"abgegebenes Volumen bei maximaler Pegelabsenkung",null,null,"Vao",{"$f":"PI()/12*G22*(G47^2+G47*G46+G46^2)","v":327072492.69646257},"[m³]","=",{"$f":"G58/1000/1000/1000","v":0.3270724926964626},"[km3]",null,"= π / 12 * Po * (Dil^2 + Dil * Dif + Dif^2)"]
[59,null,"Bodenfläche innerhalb des Walls",null,null,"Ab",{"$f":"PI()/4*G45^2","v":2278163.7075063488},"[m²]","=",{"$f":"G59/1000/1000","v":2.2781637075063492},"[km²]",null,"= π / 4 * Di^2"]
[60,null,"abzudichtende Gesamtfläche des Oberbeckens",null,null,"Ad",{"$f":"G54+G59","v":4525125.6508878488},"[m²]","=",{"$f":"G60/1000/1000","v":4.5251256508878486},"[km²]",null,"= Awi + Ab"]
[61,null,"Flächenbedarf des Oberbeckens",null,null,"Ao",{"$f":"G16^2*PI()/4","v":7068583.4705770342},"[m²]","=",{"$f":"G61/1000/1000","v":7.0685834705770336},"[km²]",null,"= π / 4 * Da^2"]
[62]
[63,"resultierende Daten der Gesamtanlage"]
[64,null,"Gesamtflächenbedarf",null,null,"Ag",{"$f":"G37+G61","v":25443442.610691551},"[m²]","=",{"$f":"G64/1000/1000","v":25.443442610691552},"[km²]",null,"= Au + Ao"]
[65,null,"Wasservolumenbedarf",null,null,"Vg",{"$f":"G57+G32","v":545755555.44835818},"[m³]","=",{"$f":"G65/1000/1000/1000","v":0.54575555544835819},"[km³]",null,"= Vo + Vru"]
[66]
[{"$f":"A66+1","v":67},"energietechnische Daten"]
[68,null,"Höhendifferenz aufgeladen",null,null,"Hmax",{"$f":"G29+G11+G43-G18","v":297.3588848665255},"[m]","=",{"$f":"G68/1000","v":0.29735888486652551},"[km]",null,"= Tu + Hno + Hw - Hf"]
[69,null,"Höhendifferenz endladen",null,null,"Hmin",{"$f":"G68-G28-G22","v":187.3588848665255},"[m]","=",0.18735888486652549,"[km]",null,"= Hmax - Po - Pu"]
[70,null,"mittlere Höhendifferenz der Wasserflächen",null,null,"Hmit",{"$f":"(G68+G69)/2","v":242.3588848665255},"[m]","=",0.24235888486652549,"[km]",null,"= (Hmax + Hmin) / 2"]
[71,null,"Austauschvolumenschwerpunkt des Oberbeckens",null,null,"Hso",{"$f":" G11  + G43 - G18  - G22/4*(G46^2+2*G46*G47+3*G47^2)/(G46^2+G46*G47+G47^2)","v":233.86632468123918},"[m]","=",0.23386632468123919,"[km]",null,"= Hno + Hw - Hf - Po /4 *(Dif^2 + 2 * Dif * Dil + 3 * Dil^2) / (Dif^2 + Dif * Dil + Dil^2)"]
[72,null,"Austauschvolumenschwerpunkt des Unterbeckens",null,null,"Hsu",{"$f":"-(G27+G28/3*(G35-2*I34*G27 + 2*(G35-2*I34*G29)) / (G35-2*I34*G27 + G35-2*I34*G29))","v":-10.625468164794009},"[m]","=",-1.0625468164794009E-2,"[km]",null,"= -(To + Pu / 3 * (Bmu - 2 * Bu * To + 2 * (Bmu - 2 * Bu * Tu)) /  (Bmu - 2 * Bu * To + Bmu - 2 * Bu * Tu))"]
[73,null,"Höhendifferenz Austauschvolumenschwerpunkte",null,null,"Hsd",{"$f":"G71-G72","v":244.49179284603318},"[m]","=",0.24449179284603317,"[km]",null,"= Hso + Hsu"]
[74,null,"Höhenverhältnis ",null,null,"Hv [-]",{"$f":"G68/G69","v":1.5871085327945029},null,null,null,null,null,"= Hmax / Hmin"]
[75,null,"Speicherendladungswirkungsgrad",null,null,"Eta",0.93]
[76,null,"Speicherkapazität",null,null,"Kap",{"$f":"G58*9.81*G73*G75/3600","v":202655204.32439986},"[kWh]","=",{"$f":"G76/1000/1000","v":202.65520432439985},"[GWh]",null,"= Vao * 9,81 * Hsd * Eta / 3600"]
[77]
[78,"technische Auslegung des Speichersystems "]
[79,null,"Verhältnis von Spitzenleistung zu Durchschnittsleistung",null,null,null,1.6]
[80,null,"Leistung bei Speicherreichweite in Tagen",null,null,"Durchschnittsleistung",null,null,null,"Spitzenleistung"]
[81,null,0.5,{"$f":"C81*24","v":12},"[h]","Pd05",{"$f":"G$76/C81/24/1000","v":16887.93369369999},"[MW]",null,{"$f":"G81*G$79","v":27020.693909919984},"Pn05 [MW]"]
[82,null,1,{"$f":"C82*24","v":24},"[h]","Pd05",8443.9668468499949,"[MW]",null,13510.346954959992,"Pn05 [MW]"]
[83,null,2,48,"[h]","Pd05",4221.9834234249975,"[MW]",null,6755.1734774799961,"Pn05 [MW]"]
[84,null,5,120,"[h]","Pd05",1688.7933693699988,"[MW]",null,2702.0693909919983,"Pn05 [MW]"]
[85,null,7,168,"[h]","Pd07",1206.2809781214276,"[MW]",null,1930.0495649942841,"Pn07 [MW]"]
[86,null,10,240,"[h]","Pd10",844.3966846849994,"[MW]",null,1351.0346954959991,"Pn10 [MW]"]
[87,null,14,336,"[h]","Pd14",603.14048906071378,"[MW]",null,965.02478249714204,"Pn14 [MW]"]
[88,null,20,480,"[h]","Pd20",422.1983423424997,"[MW]",null,675.51734774799957,"Pn20 [MW]"]
[89]
[90,"Anlagenkennwerte"]
[91,null,"flächenspezifische Speicherkapazität",null,null,null,{"$f":"G76/G64","v":7.9649286232690235},"[kWh/m²]",null,{"$f":"1/G91","v":0.12555040318610824},"[m²/kWh]"]
[92,null,"erdbauvolumenspezifische Kapazität",null,null,null,{"$f":"G76/G38","v":0.5222035607594131},"[kWh/m³]",null,{"$f":"1/G92","v":1.9149620476462335},"[m³/kWh]"]
[93]
[94,"Kennwerte für Dichtungsmaßnahmen"]
[95,null,"Länge einer Innendichtung in der Mitte des Ringwalls",null,null,"Uwid",{"$f":"(G48+G49)/2*PI()","v":7387.6576336561393},"[m]","=",{"$f":"G95/1000","v":7.387657633656139},"[km]",null,"= (Dki + Dka) / 2 * π"]
[96,null,"Fläche der Innendichtung im Ringwall",null,null,"Awid",{"$f":"G43*G95","v":1169901.2246414609},"[m²]","=",{"$f":"G96/1000/1000","v":1.1699012246414608},"[km²]",null,"= Uwid * Hw"]
[97,null,"Tiefe der Abdichtung unter dem Ringwall des Oberbeckens",null,null,"Tdo",20,"[m]","=",{"$f":"G97/1000","v":0.02},"[km]"]
[98,null,"Fläche der Abdichtung unter dem Ringwall",null,null,"Audo",{"$f":"G95*G97","v":147753.15267312279},"[m²]","=",{"$f":"G98/1000/1000","v":0.14775315267312281},"[km²]",null,"= Uwid * Tdo"]
[99,null,"Länge der Abdichtung zum Grundwasser des Unterbeckens",null,null,"Ldu",{"$f":"2*(G35+G36)","v":38749.718280229034},"[m]","=",{"$f":"G99/1000","v":38.749718280229033},"[km]",null,"= 2 * (Bmu + Lmu)"]
[100,null,"Tiefe der Abdichtung des Unterbeckens gegen Grundwasser",null,null,"Tdu",30,"[m]","=",{"$f":"G100/1000","v":0.03},"[km]"]
[101,null,"Fläche der Abdichtung des Unterbeckens gegen Grundwasser",null,null,"Audu",{"$f":"G99*G100","v":1162491.548406871},"[m²]","=",{"$f":"G101/1000/1000","v":1.162491548406871},"[km²]",null,"= Ldu * Tdu"]
[102]
[103,null,null,null,null,null,null,null,null,null,null,null,null,null,"spezifische Kosten bzgl. der"]
[104,null,null,null,null,null,null,null,null,null,null,null,null,null,"mittleren bedarfsgerecht"]
[105,null,null,null,null,"geschätzt",null,null,null,null,null,null,null,null,"abrufbaren Leistung von",null,null,"bezogen auf die"]
[106,"Kostenermittlung",null,null,null,"von ... bis","Preis pro Einheit",null,null,"Menge",null,null,"Kosten",null,null,{"$f":"G87","v":603.14048906071378},"[MW]","Speicherkapazität"]
[107,null,"Grunderwerb",null,null,"1 ... 10",3,"[€/m²]",null,{"$f":"G64","v":25443442.610691551},"[m²]",null,{"$f":"G107*J107/10^6","v":76.330327832074659},"Mio €",null,{"$f":"M107/P$106*1000","v":126.55480641159714},"[€/kW]",{"$f":"M107/$G$76*1000*1000","v":0.37665120955832476},"[€/kWh]"]
[108,null,"Umsiedlungen",null,null,null,0.5,"[M€/Anw]",null,20,"[Stück]",null,{"$f":"G108*J108","v":10},"Mio €",null,16.579885087093484,"[€/kW]",4.9344896092540121E-2,"[€/kWh]"]
[{"$f":"A108+1","v":109},null,"Flächen vorbereiten",null,null,"2 ... 4",3,"[€/m²]",null,{"$f":"G64","v":25443442.610691551},"[m²]",null,{"$f":"G109*J109/10^6","v":76.330327832074659},"Mio €",null,126.55480641159714,{"$f":"Q$107","v":"[€/kW]"},0.37665120955832476,{"$f":"S$107","v":"[€/kWh]"}]
[110,null,"Bau und Verlegung von Straßen um das Unterbecken",null,null,null,500,"[€/m]",null,{"$f":"G99","v":38749.718280229034},"[m]",null,{"$f":"G110*J110/10^6","v":19.374859140114516},"Mio €",null,32.123293812172157,"[€/kW]",9.560504110765522E-2,"[€/kWh]"]
[111,null,"Bau und Verlegung von Straßen um das Oberbecken",null,null,null,500,"[€/m]",null,{"$f":"G24","v":9424.7779607693792},"[m]",null,{"$f":"G111*J111/10^6","v":4.7123889803846897},"Mio €",null,7.8130867780463795,"[€/kW]",2.3253234458471363E-2,"[€/kWh]"]
[112,null,"Straße auf der Dammkrone des Oberbeckens",null,null,null,500,"[€/m]",null,{"$f":"G95","v":7387.6576336561393},"[m]",null,{"$f":"G112*J112/10^6","v":3.69382881682807},"Mio €",null,6.1243257314403889,"[€/kW]",1.8227159915001158E-2,"[€/kWh]"]
[113,null,"Auffahrt auf die Dammkrone des Oberbeckens (10% Steigung)",null,null,null,1000,"[€/m]",null,{"$f":"G43*10","v":1583.5888486652552},"[m]",null,{"$f":"G113*J113/10^6","v":1.5835888486652552},"Mio €",null,2.6255721136072609,"[€/kW]",7.814202719069227E-3,"[€/kWh]"]
[114,null,"Brücken über das Unterbecken",null,null,null,10,"[M€]",null,1,"[Stück]",null,{"$f":"G114*J114","v":10},"Mio €",null,16.579885087093484,"[€/kW]",4.9344896092540121E-2,"[€/kWh]"]
[115,null,"Bauwerke zum und am Gewässer zur Befüllung der Anlage",null,null,null,20,"[M€]",null,null,null,null,{"$f":"G115","v":20},"Mio €",null,33.159770174186967,"[€/kW]",9.8689792185080241E-2,"[€/kWh]"]
[116,null,"Landschaftsbau für Speicher",null,null,"3 ... 12",6,"[€/m³]",null,{"$f":"G38","v":388077025.0392186},"[m³]"]
[117,null,"1. Bodenart:",null,null,null,1]
[118,null,null,"Lösen",null,null,1,"[€/m³]"]
[119,null,null,"Fördern",null,null,1,"[€/m³]"]
[120,null,null,"Einbauen",null,null,1,"[€/m³]"]
[121,null,null,"Verdichten",null,null,3,"[€/m³]"]
[122,null,null,"Bodenverbesserung",null,null,0,"[€/m³]"]
[123,null,null,"Kosten zur 1. Bodenart",null,null,{"$f":"SUM(G118:G122)","v":6},"[€/m³]",null,{"$f":"G117*J$116","v":388077025.0392186},"[m³]",null,{"$f":"G123*J123/10^6","v":2328.4621502353116},"Mio €",null,{"$f":"M123/P$106*1000","v":3860.5634880548073},{"$f":"Q$107","v":"[€/kW]"},{"$f":"M123/$G$76*1000*1000","v":11.4897722858774},{"$f":"S$107","v":"[€/kWh]"}]
[124,null,"2. Bodenart:",null,null,null,0]
[125,null,null,"Lösen",null,null,1,"[€/m³]"]
[126,null,null,"Fördern",null,null,1,"[€/m³]"]
[127,null,null,"Einbauen",null,null,1,"[€/m³]"]
[128,null,null,"Verdichten",null,null,3,"[€/m³]"]
[129,null,null,"Bodenverbesserung",null,null,0,"[€/m³]"]
[130,null,null,"Kosten zur 2. Bodenart",null,null,{"$f":"SUM(G125:G129)","v":6},"[€/m³]",null,{"$f":"G124*J$116","v":0},"[m³]",null,{"$f":"G130*J130/10^6","v":0},"Mio €",null,{"$f":"M130/P$106*1000","v":0},{"$f":"Q$107","v":"[€/kW]"},{"$f":"M130/$G$76*1000*1000","v":0},{"$f":"S$107","v":"[€/kWh]"}]
[131,null,"3. Bodenart:",null,null,null,{"$f":"100%-G117-G124","v":0}]
[132,null,null,"Lösen",null,null,1,"[€/m³]"]
[133,null,null,"Fördern",null,null,1,"[€/m³]"]
[134,null,null,"Einbauen",null,null,1,"[€/m³]"]
[135,null,null,"Verdichten",null,null,3,"[€/m³]"]
[136,null,null,"Bodenverbesserung",null,null,0,"[€/m³]"]
[137,null,null,"Kosten zur 3. Bodenart",null,null,{"$f":"SUM(G132:G136)","v":6},"[€/m³]",null,{"$f":"G131*J$116","v":0},"[m³]",null,{"$f":"G137*J137/10^6","v":0},"Mio €",null,{"$f":"M137/P$106*1000","v":0},{"$f":"Q$107","v":"[€/kW]"},{"$f":"M137/$G$76*1000*1000","v":0},{"$f":"S$107","v":"[€/kWh]"}]
[{"$f":"A137+1","v":138},null,"Oberflächenabdichtung Oberbecken (Alternative 1)",null,null," ... 65",60,"[€/m²]",null,{"$f":"G60","v":4525125.6508878488},"[m²]",null,271.50753905327093,"Mio €",null,450.15637977827788,{"$f":"Q$107","v":"[€/kW]"},1.3397511302924936,"[€/kWh]"]
[139,null,"Innendichtung im Wall des Oberbeckens (Alternative 2)",null,null," ... 200",0,"[€/m²]",null,{"$f":"G96","v":1169901.2246414609},"[m²]",null,0,"Mio €",null,0,"[€/kW]",0,"[€/kWh]"]
[140,null,"+ Tiefenabdichtung unter dem Wall des Oberbeckens",null,null," ... 200",0,"[€/m²]",null,{"$f":"G98","v":147753.15267312279},"[m²]",null,0,"Mio €",null,0,"[€/kW]",0,"[€/kWh]"]
[141,null,"Tiefenabdichtung zur Grundwasserabtrennung des Unterbeckens",null,null,"50 ... 200",200,"[€/m²]",null,{"$f":"G101","v":1162491.548406871},"[m²]",null,232.4983096813742,"Mio €",null,385.47952574606592,"[€/kW]",1.1472604932918626,"[€/kWh]"]
[142,null,"Wasserfüllung",null,null,"2 ... 10",0.1,"[€/m³]",null,{"$f":"G65","v":545755555.44835818},"[m³]",null,54.575555544835822,"Mio €",null,90.485643949766555,"[€/kW]",0.2693025117552576,"[€/kWh]"]
[143,null,"Pumpspeichertechnik für ersten Maschinensatz",null,null,"200 ... 600 ",400,"[€/kW]",null,{"$f":"P$106*G$79","v":965.02478249714204},"[MW]",null,{"$f":"G143*J143/10^3","v":386.00991299885681},"Mio €",null,640,"[€/kW]",{"$f":"M143/$G$76*1000*1000","v":1.9047619047619044},"[€/kWh]"]
[144,null," + für zweiten Maschinensatz bei Höhenverhältnissen > ca. 1,3",null,null,"200 ... 600 ",500,"[€/kW]",null,{"$f":"J143","v":965.02478249714204},"[MW]",null,{"$f":"G144*J144/10^3","v":482.51239124857102},"Mio €",null,800,"[€/kW]",{"$f":"M144/$G$76*1000*1000","v":2.3809523809523809},"[€/kWh]"]
[145,null," + für dritten Maschinensatz bei Höhenverhältnissen > ca. 1,69",null,null,"200 ... 600 ",0,"[€/kW]",null,{"$f":"J144","v":965.02478249714204},"[MW]",null,{"$f":"G145*J145/10^3","v":0},"Mio €",null,0,"[€/kW]",0,"[€/kWh]"]
[146,null,"Überwachungssysteme für Böschungen, Leckagen, ...",null,null,null,10,"[M€]",null,null,null,null,{"$f":"G146","v":10},"Mio €",null,{"$f":"M146/P$106*1000","v":16.579885087093484},"[€/kW]",{"$f":"M146/$G$76*1000*1000","v":4.9344896092540121E-2},"[€/kWh]"]
[147,null,"Pauschale Kosten für Krafthaus, Toilette, Kran, ...",null,null,"5 ... 10",7,"[M€]",null,null,null,null,{"$f":"G147","v":7},"Mio €",null,11.60591956096544,"[€/kW]",3.4541427264778088E-2,"[€/kWh]"]
[148,null,"Netzanbindung",null,null,"0,7 ... 2,5",1,"[M€/km]",null,10,"[km]",null,{"$f":"G148*J148","v":10},"Mio €",null,16.579885087093484,"[€/kW]",4.9344896092540121E-2,"[€/kWh]"]
[149,null,"Pauschale Kosten für Ausgleichsmaßnahmen",null,null,"... 20",10,"[M€]",null,null,null,null,{"$f":"G149","v":10},"Mio €",null,16.579885087093484,"[€/kW]",4.9344896092540121E-2,"[€/kWh]"]
[150,null,"Energiespeicherkosten",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M107:M147)","v":3994.5911802123624},"Mio €",null,{"$f":"M150/P$106*1000","v":6622.9862737838121},"[€/kW]",19.711268671975624,"[€/kWh]"]
[151]
[152,"jährliche Speicherbetriebskosten bezogen auf Investitionskosten",null,null,null,null,0.01,null,null,null,null,null,{"$f":"M150*G152","v":39.945911802123625},"[M€/a]"]
[153]
[154,"Investitionskostenanteile des Speichers an den Stromkosten des Gesamtsystems",null,null,null,null,null,null,null,null,null,null,"Annuitäten bei einem Zissatz von"]
[155,null,"bei",null,"Jahresstromerzeugung",null,{"$f":"P106*24*365/1000","v":5283.5106841718525},"[GWh]",null,null,null,null,0.02,0.03,0.05,0.08]
[156,null,1,"jähriger Betrachtung",null,null,{"$f":"$M$150/G$155/C156","v":0.75604866139084603},"[€/kWh]","=",{"$f":"G156*100","v":75.604866139084606},"[ct/kWh]",null,{"$f":"$J156*'Kapitalkosten 2% Zins'!$C$7","v":77.116963461866305},{"$f":"$J156*'Kapitalkosten 3% Zins'!$C$7","v":77.873012123257141},{"$f":"$J156*'Kapitalkosten 5% Zins'!$C$7","v":79.38510944603884},{"$f":"$J156*'Kapitalkosten 8% Zins'!$C$7","v":81.653255430211374}]
[157,null,2,{"$f":"D156","v":"jähriger Betrachtung"},null,null,0.37802433069542302,{"$f":"H156","v":"[€/kWh]"},"=",37.802433069542303,{"$f":"K156","v":"[ct/kWh]"},null,{"$f":"$J157*'Kapitalkosten 2% Zins'!D7","v":38.940286304935526},{"$f":"$J157*'Kapitalkosten 3% Zins'!D7","v":39.510346995624225},{"$f":"$J157*'Kapitalkosten 5% Zins'!D7","v":40.660297009599695},{"$f":"$J157*'Kapitalkosten 8% Zins'!D7","v":42.395428687491687}]
[158,null,5,{"$f":"D157","v":"jähriger Betrachtung"},null,null,0.1512097322781692,{"$f":"H157","v":"[€/kWh]"},"=",15.12097322781692,"[ct/kWh]",null,{"$f":"$J158*'Kapitalkosten 2% Zins'!E7","v":16.040328400068187},{"$f":"$J158*'Kapitalkosten 3% Zins'!E7","v":16.508322521469122},{"$f":"$J158*'Kapitalkosten 5% Zins'!E7","v":17.462455932144373},{"$f":"$J158*'Kapitalkosten 8% Zins'!E7","v":18.93523872453374}]
[159,null,10,"jähriger Betrachtung",null,null,7.5604866139084598E-2,"[€/kWh]","=",7.5604866139084601,"[ct/kWh]",null,{"$f":"$J159*'Kapitalkosten 2% Zins'!F7","v":8.4170897472642885},{"$f":"$J159*'Kapitalkosten 3% Zins'!F7","v":8.8631584574848876},{"$f":"$J159*'Kapitalkosten 5% Zins'!F7","v":9.7912081893421519},{"$f":"$J159*'Kapitalkosten 8% Zins'!F7","v":11.267393200707778}]
[160,null,15,"jähriger Betrachtung",null,null,5.0403244092723072E-2,"[€/kWh]","=",5.0403244092723076,"[ct/kWh]",null,{"$f":"$J160*'Kapitalkosten 2% Zins'!G7","v":5.8839487072742607},{"$f":"$J160*'Kapitalkosten 3% Zins'!G7","v":6.3330416121404225},{"$f":"$J160*'Kapitalkosten 5% Zins'!G7","v":7.2837728038394109},{"$f":"$J160*'Kapitalkosten 8% Zins'!G7","v":8.8329165110292553}]
[161,null,20,"jähriger Betrachtung",null,null,3.7802433069542299E-2,"[€/kWh]","=",3.7802433069542301,"[ct/kWh]",null,{"$f":"$J161*'Kapitalkosten 2% Zins'!H7","v":4.6236911936018581},{"$f":"$J161*'Kapitalkosten 3% Zins'!H7","v":5.0817054726724322},{"$f":"$J161*'Kapitalkosten 5% Zins'!H7","v":6.0667612735985657},{"$f":"$J161*'Kapitalkosten 8% Zins'!H7","v":7.7005824308641833}]
[162,null,25,"jähriger Betrachtung",null,null,3.0241946455633842E-2,"[€/kWh]","=",3.0241946455633841,"[ct/kWh]",null,{"$f":"$J162*'Kapitalkosten 2% Zins'!I7","v":3.8724812436439131},{"$f":"$J162*'Kapitalkosten 3% Zins'!I7","v":4.3417606477692114},{"$f":"$J162*'Kapitalkosten 5% Zins'!I7","v":5.364316462300331},{"$f":"$J162*'Kapitalkosten 8% Zins'!I7","v":7.0825882550433068}]
[163,null,30,{"$f":"D161","v":"jähriger Betrachtung"},null,null,2.5201622046361536E-2,{"$f":"H161","v":"[€/kWh]"},"=",2.5201622046361538,{"$f":"K161","v":"[ct/kWh]"},null,{"$f":"$J163*'Kapitalkosten 2% Zins'!J7","v":3.3757572731101284},{"$f":"$J163*'Kapitalkosten 3% Zins'!J7","v":3.8573602704160974},{"$f":"$J163*'Kapitalkosten 5% Zins'!J7","v":4.9181721472135935},{"$f":"$J163*'Kapitalkosten 8% Zins'!J7","v":6.7157534445364693}]
[164,null,50,"jähriger Betrachtung",null,null,1.5120973227816921E-2,"[€/kWh]","=",1.5120973227816921,"[ct/kWh]",null,{"$f":"$J164*'Kapitalkosten 2% Zins'!K7","v":2.4059736551440891},{"$f":"$J164*'Kapitalkosten 3% Zins'!K7","v":2.9384209249285926},{"$f":"$J164*'Kapitalkosten 5% Zins'!K7","v":4.1414001920140233},{"$f":"$J164*'Kapitalkosten 8% Zins'!K7","v":6.1801610123205784}]
[165]
[166,"Betriebskosten des Speichers bezogen auf die Stromkosten des Gesamtsystems",null,null,null,null,{"$f":"M152/G155","v":7.5604866139084613E-3},{"$f":"H164","v":"[€/kWh]"},"=",{"$f":"G166*100","v":0.75604866139084614},{"$f":"K164","v":"[ct/kWh]"}]
[167,null,"auf Jahreserzeugung bezogene Speicherkosten bei 50-jähriger Betrachtung",null,null,null,{"$f":"G164+G166","v":2.2681459841725381E-2},{"$f":"H166","v":"[€/kWh]"},{"$f":"I166","v":"="},{"$f":"J164+$J166","v":2.2681459841725382},{"$f":"K166","v":"[ct/kWh]"},null,{"$f":"M164+$J166","v":3.1620223165349355},{"$f":"N164+$J166","v":3.694469586319439},{"$f":"O164+$J166","v":4.8974488534048692},{"$f":"P164+$J166","v":6.9362096737114243}]
[168]
[169,"Betrachtung einer vollständigen Ringwallspeicher-Hybridenergieanlage"]
[170]
[171,"technische Daten der regenerativen Erzeugungsanlagen",null,null,null,"Die Auslegung hat so zu erfolgen, dass die oben angesetzte Speicherreichweite genügt, um die zu erwartenden Flauten zu überbrücken!"]
[172,null,"Windenergieanteil der Kombination",null,null,null,0.8]
[173,null,"Solarenergieanteil",null,null,null,{"$f":"1-G172","v":0.19999999999999996}]
[174,null,"Erzeugungsreserve",null,null,null,0.3]
[175,null,"durchschnittlich verfügbare Erzeugungsleistung des Gesamtsystems",null,null,null,{"$f":"P106*(1+G174)","v":784.08263577892797},"[MW]"]
[176,null,"durchschnittlich verfügbare Windleistung",null,null,null,{"$f":"G$175*G172","v":627.26610862314237},"[MW]"]
[177,null,"durchschnittlich verfügbare Solarleistung",null,null,null,{"$f":"G$175*G173","v":156.81652715578556},"[MW]"]
[178,null,"Benutzungsgrad der Windenergieanlagen",null,null,null,0.5,null,"=",{"$f":"24*365*G178","v":4380},"Volllaststunden"]
[179,null,"Benutzungsgrad der Solarenergieanlagen",null,null,null,0.1,null,"=",{"$f":"24*365*G179","v":876},"Volllaststunden"]
[180,null,"Peakleistung der Windenergieanlagen",null,null,null,{"$f":"G175/G178","v":1568.1652715578559},"[MW]",null,"Nennleistung je Anlage",null,null,2,"[MW]","=>  ca. ",{"$f":"G180/M180","v":784.08263577892797},"Anlagen"]
[181,null,null,null,null,null,null,null,null,"Fläche je Windenergieanlage",null,null,5000,"[m²]","=>  ca. ",{"$f":"P180*M181/1000/1000","v":3.9204131788946404},"km²"]
[182,null,"Peakleistung der Solarenergieanlagen",null,null,null,{"$f":"G177/G179","v":1568.1652715578555},"[MW]",null,"Peakleistung flächenbezogen",null,null,130,"[Wp/m²]","=>  ca. ",{"$f":"G182/M182","v":12.062809781214273},"km²"]
[183]
[184,"Investitionskosten Daten der regenerativen Erzeugungsanlagen"]
[185,null,"spezifische Kosten der Windenergieanlagen",null,null,null,1500,"[€/kWp]"]
[186,null,"spezifische Kosten der Solarenergieanlagen",null,null,null,2800,"[€/kWp]",null,null,null,null,"Kostenanteil an den Investitionskosten der Erzeugungsanlagen"]
[187,null,"Investitionskosten für die Windenergieanlagen",null,null,null,{"$f":"G180*G185/1000","v":2352.247907336784},"[M€]",null,null,null,null,{"$f":"G187/G$189","v":0.34883720930232565}]
[188,null,"Investitionskosten für die Solarenergieanlagen",null,null,null,{"$f":"G182*G186/1000","v":4390.8627603619952},"[M€]",null,null,null,null,{"$f":"G188/G$189","v":0.65116279069767435}]
[189,null,"Investitionskosten der Erzeugungsanlagen",null,null,null,{"$f":"G187+G188","v":6743.1106676987793},"[M€]"]
[190]
[191,"Betriebskosten der regenerativen Erzeugungsanlagen"]
[192,null,"jährliche Kosten der Windenergie bezogen auf die Investitionskosten",null,null,null,0.06,null,null,null,null,null,{"$f":"G187*G192","v":141.13487444020703},"[M€/a]"]
[193,null,"jährliche Kosten der Solarenergie bezogen auf die Investitionskosten",null,null,null,0.02,null,null,null,null,null,{"$f":"G188*G193","v":87.81725520723991},"[M€/a]"]
[194]
[195,"Investitionskostenanteile der Erzeugungsanlagen an den Stromkosten des Gesamtsystems",null,null,null,null,null,null,null,null,null,null,"Annuitäten bei einem Zissatz von"]
[196,null,"bei",null,"Jahresstromerzeugung",null,{"$f":"G$155","v":5283.5106841718525},"[GWh]",null,null,null,null,0.02,0.03,0.05,0.08]
[197,null,10,{"$f":"D$156","v":"jähriger Betrachtung"},null,null,{"$f":"$G$189/G$196/C197","v":0.12762557077625569},{"$f":"H$156","v":"[€/kWh]"},"=",{"$f":"G197*100","v":12.762557077625569},{"$f":"K$156","v":"[ct/kWh]"},null,{"$f":"$J197*'Kapitalkosten 2% Zins'!$F$7","v":14.208554794520545},{"$f":"$J197*'Kapitalkosten 3% Zins'!$F$7","v":14.961545662100454},{"$f":"$J197*'Kapitalkosten 5% Zins'!$F$7","v":16.528149543378994},{"$f":"$J197*'Kapitalkosten 8% Zins'!$F$7","v":19.020038812785387}]
[198,null,15,{"$f":"D197","v":"jähriger Betrachtung"},null,null,{"$f":"$G$189/G$196/C198","v":8.5083713850837128E-2},{"$f":"H197","v":"[€/kWh]"},"=",{"$f":"G198*100","v":8.5083713850837128},{"$f":"K197","v":"[ct/kWh]"},null,{"$f":"$J198*'Kapitalkosten 2% Zins'!$G$7","v":9.9324600456620988},{"$f":"$J198*'Kapitalkosten 3% Zins'!$G$7","v":10.690555936073059},{"$f":"$J198*'Kapitalkosten 5% Zins'!$G$7","v":12.295447488584472},{"$f":"$J198*'Kapitalkosten 8% Zins'!$G$7","v":14.910495433789952}]
[199,null,20,{"$f":"D198","v":"jähriger Betrachtung"},null,null,{"$f":"$G$189/G$196/C199","v":6.3812785388127846E-2},{"$f":"H198","v":"[€/kWh]"},"=",{"$f":"G199*100","v":6.3812785388127846},{"$f":"K198","v":"[ct/kWh]"},null,{"$f":"$J199*'Kapitalkosten 2% Zins'!$H$7","v":7.8050694063926933},{"$f":"$J199*'Kapitalkosten 3% Zins'!$H$7","v":8.5782251141552504},{"$f":"$J199*'Kapitalkosten 5% Zins'!$H$7","v":10.241058675799085},{"$f":"$J199*'Kapitalkosten 8% Zins'!$H$7","v":12.99904726027397}]
[200,null,25,{"$f":"D199","v":"jähriger Betrachtung"},null,null,{"$f":"$G$189/G$196/C200","v":5.105022831050228E-2},{"$f":"H199","v":"[€/kWh]"},"=",{"$f":"G200*100","v":5.1050228310502277},{"$f":"K199","v":"[ct/kWh]"},null,{"$f":"$J200*'Kapitalkosten 2% Zins'!$I$7","v":6.5369817351598165},{"$f":"$J200*'Kapitalkosten 3% Zins'!$I$7","v":7.3291536529680359},{"$f":"$J200*'Kapitalkosten 5% Zins'!$I$7","v":9.0552894977168936},{"$f":"$J200*'Kapitalkosten 8% Zins'!$I$7","v":11.955835844748858}]
[201,null,30,{"$f":"D199","v":"jähriger Betrachtung"},null,null,{"$f":"$G$189/G$196/C201","v":4.2541856925418564E-2},{"$f":"H199","v":"[€/kWh]"},"=",{"$f":"G201*100","v":4.2541856925418564},{"$f":"K199","v":"[ct/kWh]"},null,{"$f":"$J201*'Kapitalkosten 2% Zins'!$J$7","v":5.6984817351598176},{"$f":"$J201*'Kapitalkosten 3% Zins'!$J$7","v":6.5114566210045659},{"$f":"$J201*'Kapitalkosten 5% Zins'!$J$7","v":8.3021710045662083},{"$f":"$J201*'Kapitalkosten 8% Zins'!$J$7","v":11.336596575342465}]
[202]
[{"$f":"A202+1","v":203},"Investitionskostenanteile der Windenergieanlagen an den Stromkosten des Gesamtsystems",null,null,null,null,null,null,null,null,null,null,"Annuitäten bei einem Zissatz von"]
[204,null,"bei",null,"Jahresstromerzeugung",null,{"$f":"G$155","v":5283.5106841718525},"[GWh]",null,null,null,null,0.02,0.03,0.05,0.08]
[205,null,10,{"$f":"D$156","v":"jähriger Betrachtung"},null,null,{"$f":"$G$187/G$155/C205","v":4.4520547945205484E-2},{"$f":"H$156","v":"[€/kWh]"},"=",{"$f":"G205*100","v":4.4520547945205484},{"$f":"K$156","v":"[ct/kWh]"},null,{"$f":"$J205*'Kapitalkosten 2% Zins'!$F$7","v":4.9564726027397263},{"$f":"$J205*'Kapitalkosten 3% Zins'!$F$7","v":5.2191438356164381},{"$f":"$J205*'Kapitalkosten 5% Zins'!$F$7","v":5.7656335616438366},{"$f":"$J205*'Kapitalkosten 8% Zins'!$F$7","v":6.6348972602739735}]
[206,null,15,{"$f":"D205","v":"jähriger Betrachtung"},null,null,{"$f":"$G$187/G$155/C206","v":2.9680365296803658E-2},{"$f":"H205","v":"[€/kWh]"},"=",{"$f":"G206*100","v":2.9680365296803659},{"$f":"K205","v":"[ct/kWh]"},null,{"$f":"$J206*'Kapitalkosten 2% Zins'!$G$7","v":3.4648116438356173},{"$f":"$J206*'Kapitalkosten 3% Zins'!$G$7","v":3.7292636986301377},{"$f":"$J206*'Kapitalkosten 5% Zins'!$G$7","v":4.2891095890410966},{"$f":"$J206*'Kapitalkosten 8% Zins'!$G$7","v":5.2013356164383575}]
[207,null,20,{"$f":"D206","v":"jähriger Betrachtung"},null,null,{"$f":"$G$187/G$155/C207","v":2.2260273972602742E-2},{"$f":"H206","v":"[€/kWh]"},"=",{"$f":"G207*100","v":2.2260273972602742},{"$f":"K206","v":"[ct/kWh]"},null,{"$f":"$J207*'Kapitalkosten 2% Zins'!$H$7","v":2.7226986301369864},{"$f":"$J207*'Kapitalkosten 3% Zins'!$H$7","v":2.992404109589041},{"$f":"$J207*'Kapitalkosten 5% Zins'!$H$7","v":3.5724623287671236},{"$f":"$J207*'Kapitalkosten 8% Zins'!$H$7","v":4.5345513698630135}]
[208,null,25,{"$f":"D207","v":"jähriger Betrachtung"},null,null,{"$f":"$G$187/G$155/C208","v":1.7808219178082195E-2},{"$f":"H207","v":"[€/kWh]"},"=",{"$f":"G208*100","v":1.7808219178082194},{"$f":"K207","v":"[ct/kWh]"},null,{"$f":"$J208*'Kapitalkosten 2% Zins'!$I$7","v":2.2803424657534248},{"$f":"$J208*'Kapitalkosten 3% Zins'!$I$7","v":2.5566815068493156},{"$f":"$J208*'Kapitalkosten 5% Zins'!$I$7","v":3.1588219178082197},{"$f":"$J208*'Kapitalkosten 8% Zins'!$I$7","v":4.1706404109589048}]
[209,null,30,{"$f":"D207","v":"jähriger Betrachtung"},null,null,{"$f":"$G$187/G$155/C209","v":1.4840182648401829E-2},{"$f":"H207","v":"[€/kWh]"},"=",{"$f":"G209*100","v":1.484018264840183},{"$f":"K207","v":"[ct/kWh]"},null,{"$f":"$J209*'Kapitalkosten 2% Zins'!$J$7","v":1.9878424657534253},{"$f":"$J209*'Kapitalkosten 3% Zins'!$J$7","v":2.2714383561643845},{"$f":"$J209*'Kapitalkosten 5% Zins'!$J$7","v":2.8961061643835624},{"$f":"$J209*'Kapitalkosten 8% Zins'!$J$7","v":3.9546267123287682}]
[210]
[211,"Investitionskostenanteile der Solarenergieanlagen an den Stromkosten des Gesamtsystems",null,null,null,null,null,null,null,null,null,null,"Annuitäten bei einem Zissatz von"]
[212,null,"bei",null,"Jahresstromerzeugung",null,{"$f":"G$155","v":5283.5106841718525},"[GWh]",null,null,null,null,0.02,0.03,0.05,0.08]
[213,null,10,{"$f":"D$156","v":"jähriger Betrachtung"},null,null,{"$f":"$G$188/G$155/C213","v":8.3105022831050215E-2},{"$f":"H$156","v":"[€/kWh]"},"=",{"$f":"G213*100","v":8.3105022831050217},{"$f":"K$156","v":"[ct/kWh]"},null,{"$f":"$J213*'Kapitalkosten 2% Zins'!$F$7","v":9.2520821917808203},{"$f":"$J213*'Kapitalkosten 3% Zins'!$F$7","v":9.7424018264840164},{"$f":"$J213*'Kapitalkosten 5% Zins'!$F$7","v":10.762515981735159},{"$f":"$J213*'Kapitalkosten 8% Zins'!$F$7","v":12.385141552511413}]
[214,null,15,{"$f":"D213","v":"jähriger Betrachtung"},null,null,{"$f":"$G$188/G$155/C214","v":5.5403348554033477E-2},{"$f":"H213","v":"[€/kWh]"},"=",{"$f":"G214*100","v":5.5403348554033478},{"$f":"K213","v":"[ct/kWh]"},null,{"$f":"$J214*'Kapitalkosten 2% Zins'!$G$7","v":6.4676484018264837},{"$f":"$J214*'Kapitalkosten 3% Zins'!$G$7","v":6.9612922374429216},{"$f":"$J214*'Kapitalkosten 5% Zins'!$G$7","v":8.0063378995433769},{"$f":"$J214*'Kapitalkosten 8% Zins'!$G$7","v":9.7091598173515976}]
[215,null,20,{"$f":"D214","v":"jähriger Betrachtung"},null,null,{"$f":"$G$188/G$155/C215","v":4.1552511415525108E-2},{"$f":"H214","v":"[€/kWh]"},"=",{"$f":"G215*100","v":4.1552511415525109},{"$f":"K214","v":"[ct/kWh]"},null,{"$f":"$J215*'Kapitalkosten 2% Zins'!$H$7","v":5.0823707762557069},{"$f":"$J215*'Kapitalkosten 3% Zins'!$H$7","v":5.5858210045662089},{"$f":"$J215*'Kapitalkosten 5% Zins'!$H$7","v":6.6685963470319622},{"$f":"$J215*'Kapitalkosten 8% Zins'!$H$7","v":8.4644958904109568}]
[216,null,25,{"$f":"D215","v":"jähriger Betrachtung"},null,null,{"$f":"$G$188/G$155/C216","v":3.3242009132420085E-2},{"$f":"H215","v":"[€/kWh]"},"=",{"$f":"G216*100","v":3.3242009132420085},{"$f":"K215","v":"[ct/kWh]"},null,{"$f":"$J216*'Kapitalkosten 2% Zins'!$I$7","v":4.2566392694063921},{"$f":"$J216*'Kapitalkosten 3% Zins'!$I$7","v":4.7724721461187203},{"$f":"$J216*'Kapitalkosten 5% Zins'!$I$7","v":5.8964675799086752},{"$f":"$J216*'Kapitalkosten 8% Zins'!$I$7","v":7.7851954337899532}]
[217,null,30,{"$f":"D215","v":"jähriger Betrachtung"},null,null,{"$f":"$G$188/G$155/C217","v":2.7701674277016738E-2},{"$f":"H215","v":"[€/kWh]"},"=",{"$f":"G217*100","v":2.7701674277016739},{"$f":"K215","v":"[ct/kWh]"},null,{"$f":"$J217*'Kapitalkosten 2% Zins'!$J$7","v":3.7106392694063928},{"$f":"$J217*'Kapitalkosten 3% Zins'!$J$7","v":4.2400182648401827},{"$f":"$J217*'Kapitalkosten 5% Zins'!$J$7","v":5.4060648401826477},{"$f":"$J217*'Kapitalkosten 8% Zins'!$J$7","v":7.3819698630136976}]
[218]
[219,"Betriebskosten der Erzeugung an den Stromkosten des Gesamtsystems"]
[220,null,"Windenergie",null,null,null,{"$f":"M192/G$196","v":2.6712328767123289E-2},{"$f":"H201","v":"[€/kWh]"},"=",{"$f":"G220*100","v":2.6712328767123288},{"$f":"K160","v":"[ct/kWh]"}]
[221,null,"Solarenergie",null,null,null,{"$f":"M193/G$196","v":1.6621004566210042E-2},{"$f":"H220","v":"[€/kWh]"},"=",{"$f":"G221*100","v":1.6621004566210043},{"$f":"K220","v":"[ct/kWh]"}]
[222,null,"zusammen",null,null,null,{"$f":"SUM(G220:G221)","v":4.3333333333333335E-2},{"$f":"H221","v":"[€/kWh]"},"=",{"$f":"SUM(J220:J221)","v":4.333333333333333},{"$f":"K221","v":"[ct/kWh]"}]
[223]
[224,"Investitionskostenanteile des gesamten Ringwallspeicher-Hybridsystems bei 50 jähriger Nutzung der Speicheranlagen",null,null,null,null,null,null,null,null,null,null,"Annuitäten bei einem Zissatz von"]
[225,null,"bei",null,"Jahresstromerzeugung",null,{"$f":"G$155","v":5283.5106841718525},"[GWh]",null,null,null,null,0.02,0.03,0.05,0.08]
[226,null,20,"jähriger Nutzung der Erzeugungsanlagen",null,null,{"$f":"G$164+G199","v":7.893375861594476E-2},{"$f":"H$156","v":"[€/kWh]"},"=",{"$f":"J$164+J199","v":7.8933758615944765},{"$f":"K$156","v":"[ct/kWh]"},null,{"$f":"M$164+M199","v":10.211043061536783},{"$f":"N$164+N199","v":11.516646039083843},{"$f":"O$164+O199","v":14.382458867813108},{"$f":"P$164+P199","v":19.179208272594551}]
[227,null,25,{"$f":"D226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,{"$f":"G$164+G200","v":6.6171201538319208E-2},{"$f":"H226","v":"[€/kWh]"},"=",{"$f":"J$164+J200","v":6.6171201538319195},{"$f":"K226","v":"[ct/kWh]"},null,{"$f":"M$164+M200","v":8.9429553903039061},10.267574577896628,13.196689689730917,18.135996857069436]
[228,null,30,{"$f":"D226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,{"$f":"G$164+G201","v":5.7662830153235485E-2},{"$f":"H226","v":"[€/kWh]"},"=",{"$f":"J$164+J201","v":5.7662830153235483},{"$f":"K226","v":"[ct/kWh]"},null,8.1044553903039063,9.449877545933159,12.443571196580232,17.516757587663044]
[229]
[230,"Betriebskosten des gesamten Hybridsystems",null,null,null,null,{"$f":"G166+G228","v":6.5223316767143949E-2},{"$f":"H227","v":"[€/kWh]"},"=",{"$f":"J166+J222","v":5.089381994724179},{"$f":"K198","v":"[ct/kWh]"}]
[231]
[232,"Stromerzeugungskosten des gesamten Ringwallspeicher-Hybridsystems bei 50 jähriger Nutzung der Speicheranlagen",null,null,null,null,null,null,null,null,null,null,"Annuitäten bei einem Zissatz von"]
[233,null,"bei",null,"Jahresstromerzeugung",null,{"$f":"G$155","v":5283.5106841718525},"[GWh]",null,null,null,null,0.02,0.03,0.05,0.08]
[234,null,20,{"$f":"D226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,{"$f":"G226+G$230","v":0.1441570753830887},{"$f":"H226","v":"[€/kWh]"},"=",{"$f":"J226+J$230","v":12.982757856318656},{"$f":"K226","v":"[ct/kWh]"},null,{"$f":"M226+$J$230","v":15.300425056260963},{"$f":"N226+$J$230","v":16.606028033808023},{"$f":"O226+$J$230","v":19.471840862537288},{"$f":"P226+$J$230","v":24.268590267318729}]
[235,null,25,{"$f":"D234","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,{"$f":"G227+G$230","v":0.13139451830546317},{"$f":"H234","v":"[€/kWh]"},"=",{"$f":"J227+J$230","v":11.706502148556098},{"$f":"K234","v":"[ct/kWh]"},null,{"$f":"M227+$J$230","v":14.032337385028086},15.356956572620806,18.286071684455095,23.225378851793614]
[236,null,30,{"$f":"D234","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,{"$f":"G228+G$230","v":0.12288614692037944},{"$f":"H234","v":"[€/kWh]"},"=",{"$f":"J228+J$230","v":10.855665010047726},{"$f":"K234","v":"[ct/kWh]"},null,13.193837385028086,14.539259540657337,17.532953191304411,22.606139582387222]
[237]
[238,"Speicherkostenanteil an den Gesamtkosten des Ringwallspeicher-Hybridsystems bei 50 jähriger Nutzung der Speicheranlagen",null,null,null,null,null,null,null,null,null,null,"Speicheranteil bei Kapitalverzinsung"]
[239,null,20,{"$f":"D226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"J$167/J234","v":0.17470448184232601},null,null,{"$f":"M$167/M234","v":0.20666238388201053},0.22247761950045553,0.25151442475206759,0.28581016026514172]
[240,null,25,{"$f":"D239","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"J$167/J235","v":0.19375095612589074},null,null,0.22533824763283417,0.2405730307856789,0.26782399948525676,0.29864785922214421]
[241,null,30,{"$f":"D239","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"J$167/J236","v":0.20893662268255331},null,null,0.23965903355176182,0.25410300820260395,0.27932823409542851,0.3068285785121635]
[242]
[243,"Windenergiekostenanteil an den Gesamtkosten des Ringwallspeicher-Hybridsystems bei 50 jähriger Nutzung der Speicheranlagen"]
[244,null,20,{"$f":"D$226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"(J207+$J$220)/J234","v":0.37721263295295354},null,null,{"$f":"(M207+$J$220)/M234","v":0.3525347490030748},{"$f":"(N207+$J$220)/N234","v":0.34105910063326617},{"$f":"(O207+$J$220)/O234","v":0.32065253868687715},{"$f":"(P207+$J$220)/P234","v":0.29691812203360674}]
[245,null,25,{"$f":"D244","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"(J208+$J$220)/J235","v":0.38030615277080637},null,null,{"$f":"(M208+$J$220)/M235","v":0.35286889180336245},0.34042646137856813,0.31882489006518833,0.2945860789324804]
[246,null,30,{"$f":"D244","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"(J209+$J$220)/J236","v":0.38277260192779688},null,null,0.35312511489285997,0.3399534356653523,0.31753572717327799,0.29310000342576858]
[247]
[248,"Solarenergiekostenanteil an den Gesamtkosten des Ringwallspeicher-Hybridsystems bei 50 jähriger Nutzung der Speicheranlagen"]
[249,null,20,{"$f":"D$226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"(J215+$J$221)/J234","v":0.44808288520472045},null,null,{"$f":"(M215+$J$221)/M234","v":0.44080286711491456},0.4364632798662782,0.42783303656105531,0.41727171770125154]
[250,null,25,{"$f":"D249","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"(J216+$J$221)/J235","v":0.42594289110330297},null,null,0.42179286056380338,0.4190005078357531,0.41335111044955508,0.4067660618453755]
[251,null,30,{"$f":"D249","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"(J217+$J$221)/J236","v":0.40829077538964997},null,null,0.40721585155537826,0.40594355613204397,0.40313603873129356,0.40007141806206803]
[252]
[253,"Kontrollsumme"]
[254,null,20,{"$f":"D$226","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"J239+J244+J249","v":1},null,null,{"$f":"M239+M244+M249","v":0.99999999999999989},0.99999999999999989,1,1]
[255,null,25,{"$f":"D254","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"J240+J245+J250","v":1},null,null,1,1.0000000000000002,1.0000000000000002,1]
[256,null,30,{"$f":"D254","v":"jähriger Nutzung der Erzeugungsanlagen"},null,null,null,null,null,{"$f":"J241+J246+J251","v":1},null,null,1,1.0000000000000002,1,1]
[]
["Autor:"]
["Dr.-Ing. Matthias Popp, Burgstraße 19, D-95632 Wunsiedel"]
["Beiträge zur Verbesserung des Layouts und  zur einheitlichen Darstellung der verwendeten Einheiten:"]
["Tobias Conradi, Berlin"]

{"sheet":"Kapitalkosten 2% Zins","index":1,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,2,3,10],[3,12,3,19]]}
[]
[null,"Tilgungsverlauf in Abhängigkeit des Zinssatzes und der Tilgungsrate"]
[]
[null,"Zins",0.02]
[null,"Annuität",1.02,0.51505000000000001,0.21215999999999999,0.11133,7.7825000000000005E-2,6.1156000000000002E-2,5.1220000000000002E-2,4.4650000000000002E-2,3.1822999999999997E-2]
[null,"Dauer",1,2,5,10,15,20,25,30,50,"Jahre"]
[null,"Kosten",{"$f":"C5*C6","v":1.02},{"$f":"D5*D6","v":1.0301},1.0608,1.1133,1.1673750000000001,1.22312,{"$f":"I5*I6","v":1.2805},1.3395000000000001,1.5911499999999998]
[null,null,"Restwert"]
[null,"Jahr"]
[null,0,1,1,1,1,1,1,1,1,1]
[null,{"$f":"B10+1","v":1},{"$f":"C10*(1+$C$4)-C$5","v":0},{"$f":"D10*(1+$C$4)-D$5","v":0.50495000000000001},{"$f":"E10*(1+$C$4)-E$5","v":0.80784},{"$f":"F10*(1+$C$4)-F$5","v":0.90866999999999998},0.94217499999999998,0.95884400000000003,{"$f":"I10*(1+$C$4)-I$5","v":0.96877999999999997},0.97535000000000005,0.98817699999999997]
[null,{"$f":"B11+1","v":2},null,{"$f":"D11*(1+$C$4)-D$5","v":-1.0000000000287557E-6},{"$f":"E11*(1+$C$4)-E$5","v":0.61183679999999996},0.81551339999999994,0.88319349999999996,0.9168648800000001,0.93693559999999998,0.95020700000000013,0.97611753999999984]
[null,3,null,null,{"$f":"E12*(1+$C$4)-E$5","v":0.41191353599999991},0.72049366799999992,0.82303236999999996,0.87404617760000014,0.90445431199999993,0.92456114000000023,0.96381689079999977]
[null,4,null,null,{"$f":"E13*(1+$C$4)-E$5","v":0.20799180671999992},0.62357354135999987,0.7616680173999999,0.83037110115200019,0.87132339823999994,0.8984023628000003,0.95127022861599975]
[null,5,null,null,{"$f":"E14*(1+$C$4)-E$5","v":-8.3571456000741673E-6},0.52471501218719985,0.69907637774799991,0.7858225231750402,0.83752986620479986,0.87172041005600032,0.93847263318831975]
[null,6,null,null,null,0.42387931243094384,0.63523290530295984,0.740382973638541,0.80306046352889582,0.84450481825712032,0.9254190858520861]
[null,7,null,null,null,0.32102689867956274,0.57011256340901906,0.69403463311131186,0.76790167279947374,0.81674491462226273,0.91210446756912777]
[null,8,null,null,null,0.21611743665315403,0.50368981467719942,0.64675932577353812,0.73203970625546322,0.78842981291470804,0.89852355692051034]
[null,9,null,null,null,0.10910978538621711,0.43593861097074338,0.59853851228900889,0.6954605003805725,0.75954840917300226,0.88467102805892051]
[null,10,null,null,null,-3.801890605853453E-5,0.36683238319015821,0.5493532825347891,0.65814971038818393,0.7300893773564624,0.87054144862009886]
[null,11,null,null,null,null,0.29634403085396133,0.49918434818548485,0.62009270459594756,0.7000411649035917,0.85612927759250079]
[null,12,null,null,null,null,0.22444591147104057,0.44801203514919452,0.58127455868786648,0.66939198820166357,0.84142886314435072]
[null,13,null,null,null,null,0.15110982970046138,0.39581627585217843,0.54168004986162377,0.63812982796569684,0.82643444040723768]
[null,14,null,null,null,null,7.6307026294470615E-2,0.34257660136922202,0.50129365085885624,0.60624242452501087,0.81114012921538237]
[null,15,null,null,null,null,8.1668203600199218E-6,0.28827213339660646,0.46009952387603342,0.57371727301551112,0.79553993179968996]
[null,16,null,null,null,null,null,0.23288157606453858,0.41808151435355412,0.54054161847582138,0.77962773043568367]
[null,17,null,null,null,null,null,{"$f":"H26*(1+$C$4)-H$5","v":0.17638320758582937},0.37522314464062523,0.50670245084533783,0.7633972850443973]
[null,18,null,null,null,null,null,0.11875487173754597,0.33150760753343778,0.47218649986224454,0.74684223074528522]
[null,19,null,null,null,null,null,5.9973969172296887E-2,0.28691775968410654,0.43698022985948942,0.72995607536019091]
[null,20,null,null,null,null,null,1.7448555742823058E-5,0.24143611487778871,0.40106983445667921,0.71273219686739475]
[null,21,null,null,null,null,null,null,0.19504483717534449,0.36444123114581278,0.69516384080474258]
[null,22,null,null,null,null,null,null,0.14772573391885135,0.32708005576872901,0.67724411762083736]
[null,23,null,null,null,null,null,null,9.9460248597228393E-2,0.28897165688410359,0.65896599997325411]
[null,24,null,null,null,null,null,null,5.0229453569172966E-2,0.25010109002178565,0.64032231997271916]
[null,25,null,null,null,null,null,null,1.4042640556426178E-5,0.2104531118222214,0.6213057663721735]
[null,26,null,null,null,null,null,null,null,0.17001217405866584,0.60190888169961698]
[null,27,null,null,null,null,null,null,null,0.12876241753983916,0.58212405933360933]
[null,28,null,null,null,null,null,null,null,8.6687665890635951E-2,0.5619435405202815]
[null,29,null,null,null,null,null,null,null,4.3771419208448674E-2,0.5413594113306871]
[null,30,null,null,null,null,null,null,null,-3.152407382356337E-6,0.52036359955730083]
[null,31,null,null,null,null,null,null,null,null,0.49894787154844683]
[null,32,null,null,null,null,null,null,null,null,0.47710382897941578]
[null,33,null,null,null,null,null,null,null,null,{"$f":"K42*(1+$C$4)-K$5","v":0.45482290555900412}]
[null,34,null,null,null,null,null,null,null,null,0.43209636367018422]
[null,35,null,null,null,null,null,null,null,null,0.40891529094358792]
[null,36,null,null,null,null,null,null,null,null,0.38527059676245967]
[null,37,null,null,null,null,null,null,null,null,0.36115300869770889]
[null,38,null,null,null,null,null,null,null,null,0.33655306887166309]
[null,39,null,null,null,null,null,null,null,null,0.31146113024909639]
[null,40,null,null,null,null,null,null,null,null,0.28586735285407833]
[null,41,null,null,null,null,null,null,null,null,0.25976169991115988]
[null,42,null,null,null,null,null,null,null,null,0.23313393390938308]
[null,43,null,null,null,null,null,null,null,null,0.20597361258757077]
[null,44,null,null,null,null,null,null,null,null,0.17827008483932219]
[null,45,null,null,null,null,null,null,null,null,0.15001248653610866]
[null,46,null,null,null,null,null,null,null,null,0.12118973626683086]
[null,47,null,null,null,null,null,null,null,null,9.1790530992167468E-2]
[null,48,null,null,null,null,null,null,null,null,6.1803341612010822E-2]
[null,49,null,null,null,null,null,null,null,null,3.1216408444251047E-2]
[null,50,null,null,null,null,null,null,null,null,1.7736613136073998E-5]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,{"$f":"B65+1","v":56}]
[null,{"$f":"B66+1","v":57}]
[null,{"$f":"B67+1","v":58}]
[null,{"$f":"B68+1","v":59}]
[null,{"$f":"B69+1","v":60}]

{"sheet":"Kapitalkosten 3% Zins","index":2,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,2,3,10]]}
[]
[null,"Tilgungsverlauf in Abhängigkeit des Zinssatzes und der Tilgungsrate"]
[]
[null,"Zins",0.03]
[null,"Annuität",1.03,0.52259,0.21834999999999999,0.11723,8.3765000000000006E-2,6.7213999999999996E-2,5.7426999999999999E-2,5.1020000000000003E-2,3.8865499999999997E-2]
[null,"Dauer",1,2,5,10,15,20,25,30,50,"Jahre"]
[null,"Kosten",{"$f":"C5*C6","v":1.03},{"$f":"D5*D6","v":1.04518},1.09175,1.1722999999999999,1.256475,1.3442799999999999,1.435675,1.5306000000000002,1.9432749999999999]
[null,null,"Restwert"]
[null,"Jahr"]
[null,0,1,1,1,1,1,1,1,1,1]
[null,{"$f":"B10+1","v":1},{"$f":"C10*(1+$C$4)-C$5","v":0},{"$f":"D10*(1+$C$4)-D$5","v":0.50741000000000003},{"$f":"E10*(1+$C$4)-E$5","v":0.81164999999999998},{"$f":"F10*(1+$C$4)-F$5","v":0.91277000000000008},0.94623500000000005,0.96278600000000003,0.97257300000000002,0.97898000000000007,0.99113450000000003]
[null,{"$f":"B11+1","v":2},null,{"$f":"D11*(1+$C$4)-D$5","v":4.230000000005063E-5},0.61764949999999996,0.82292310000000013,0.89085705000000015,0.92445558000000005,0.94432319000000009,0.95732940000000022,0.98200303499999997]
[null,3,null,null,0.41782898500000004,0.73038079300000014,0.8338177615000002,0.88497524740000011,0.91522588570000007,0.93502928200000035,0.97259762605]
[null,4,null,null,0.21201385455000005,0.63506221679000019,0.77506729434500021,0.8443105048220001,0.88525566227100005,0.91206016046000038,0.96291005483149994]
[null,5,null,null,2.4270186500058299E-5,0.5368840832937003,0.71455431317535023,0.80242581996666018,0.85438633213913007,0.88840196527380044,0.95293185647644496]
[null,6,null,null,null,0.43576060579251136,0.65222594257061073,0.75928459456566,0.82259092210330398,0.86403402423201447,0.94265431217073836]
[null,7,null,null,null,0.33160342396628673,0.58802772084772914,0.71484913240262982,0.78984164976640314,0.83893504495897497,0.93206844153586055]
[null,8,null,null,null,0.22432152668527533,0.521903552473161,0.66908060637470879,0.7561098992593952,0.81308309630774434,0.92116499478193636]
[null,9,null,null,null,0.11382117248583359,0.45379565904735586,0.62193902456595007,0.72136619623717713,0.78645558919697678,0.90993444462539452]
[null,10,null,null,null,5.8076604085993688E-6,0.38364452881877653,0.57338319530292858,0.6855801821242925,0.75902925687288614,0.89836697796415643]
[null,11,null,null,null,null,0.31138886468333982,0.52337069116201651,0.64872058758802131,0.73078013457907276,0.88645248730308113]
[null,12,null,null,null,null,0.23696553062383999,0.47185781189687703,0.61075520521566196,0.70168353861644506,0.87418056192217364]
[null,13,null,null,null,null,0.16030949654255519,0.41879954625378335,0.57165086137213184,0.67171404477493846,0.86154047877983886]
[null,14,null,null,null,null,8.1353781438831846E-2,0.36414953264139688,0.53137338721329574,0.64084546611818671,0.84852119314323404]
[null,15,null,null,null,null,2.9394881996797073E-5,0.30786001862063878,0.48988758882969463,0.60905083010173233,0.83511132893753104]
[null,16,null,null,null,null,null,0.24988181917925795,0.44715721649458551,0.57630235500478433,0.82129916880565701]
[null,17,null,null,null,null,null,{"$f":"H26*(1+$C$4)-H$5","v":0.19016427375463568},0.40314493298942305,0.54257142565492789,0.80707264386982669]
[null,18,null,null,null,null,null,0.12865520196727476,0.35781228097910578,0.5078285684245758,0.79241932318592156]
[null,19,null,null,null,null,null,6.5300858026293013E-2,0.31111964940847897,0.47204342547731309,0.77732640288149923]
[null,20,null,null,null,null,null,4.58837670818113E-5,0.26302623889073334,0.43518472824163251,0.76178069496794421]
[null,21,null,null,null,null,null,null,0.21349002605745532,0.3972202700888815,0.74576861581698251]
[null,22,null,null,null,null,null,null,0.16246772683917898,{"$f":"J31*(1+$C$4)-J$5","v":0.35811687819154797},0.72927617429149205]
[null,23,null,null,null,null,null,null,0.10991475864435435,0.31784038453729441,0.71228895952023685]
[null,24,null,null,null,null,null,null,5.5785201403684988E-2,0.27635559607341326,0.69479212830584403]
[null,25,null,null,null,null,null,null,3.1757445795539685E-5,0.23362626395561564,0.67677039215501933]
[null,26,null,null,null,null,null,null,null,{"$f":"J35*(1+$C$4)-J$5","v":0.1896150518742841},0.65820800391966994]
[null,27,null,null,null,null,null,null,null,0.14428350343051261,0.63908874403726001]
[null,28,null,null,null,null,null,null,null,9.7592008533427976E-2,0.61939590635837782]
[null,29,null,null,null,null,null,null,null,4.9499768789430819E-2,0.59911228354912915]
[null,30,null,null,null,null,null,null,null,-3.5238146886260036E-5,0.57822015205560306]
[null,31,null,null,null,null,null,null,null,null,{"$f":"K40*(1+$C$4)-K$5","v":0.55670125661727121}]
[null,32,null,null,null,null,null,null,null,null,0.53453679431578938]
[null,33,null,null,null,null,null,null,null,null,0.51170739814526311]
[null,34,null,null,null,null,null,null,null,null,0.48819312008962101]
[null,35,null,null,null,null,null,null,null,null,0.46397341369230971]
[null,36,null,null,null,null,null,null,null,null,0.43902711610307904]
[null,37,null,null,null,null,null,null,null,null,0.41333242958617145]
[null,38,null,null,null,null,null,null,null,null,0.3868669024737566]
[null,39,null,null,null,null,null,null,null,null,0.35960740954796933]
[null,40,null,null,null,null,null,null,null,null,0.33153013183440844]
[null,41,null,null,null,null,null,null,null,null,0.30261053578944069]
[null,42,null,null,null,null,null,null,null,null,0.2728233518631239]
[null,43,null,null,null,null,null,null,null,null,0.24214255241901761]
[null,44,null,null,null,null,null,null,null,null,0.21054132899158814]
[null,45,null,null,null,null,null,null,null,null,0.17799206886133578]
[null,46,null,null,null,null,null,null,null,null,0.14446633092717587]
[null,47,null,null,null,null,null,null,null,null,0.10993482085499115]
[null,48,null,null,null,null,null,null,null,null,7.4367365480640893E-2]
[null,49,null,null,null,null,null,null,null,null,3.7732886445060121E-2]
[null,50,null,null,null,null,null,null,null,null,-6.2696158806968549E-7]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]

{"sheet":"Kapitalkosten 5% Zins","index":3,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,2,3,10]]}
[]
[null,"Tilgungsverlauf in Abhängigkeit des Zinssatzes und der Tilgungsrate"]
[]
[null,"Zins",0.05]
[null,"Annuität",1.05,0.53779999999999994,0.23097000000000001,0.12950500000000001,9.6339999999999995E-2,8.0242999999999995E-2,7.0952000000000001E-2,6.5050999999999998E-2,5.4776900000000003E-2]
[null,"Dauer",1,2,5,10,15,20,25,30,50,"Jahre"]
[null,"Kosten",{"$f":"C5*C6","v":1.05},{"$f":"D5*D6","v":1.0755999999999999},1.1548500000000002,1.29505,1.4450999999999998,1.60486,1.7738,1.95153,2.738845]
[null,null,"Restwert"]
[null,"Jahr"]
[null,0,1,1,1,1,1,1,1,1,1]
[null,{"$f":"B10+1","v":1},{"$f":"C10*(1+$C$4)-C$5","v":0},{"$f":"D10*(1+$C$4)-D$5","v":0.5122000000000001},{"$f":"E10*(1+$C$4)-E$5","v":0.81903000000000004},{"$f":"F10*(1+$C$4)-F$5","v":0.92049500000000006},0.95366000000000006,0.96975700000000009,0.97904800000000003,0.98494900000000007,0.99522310000000003]
[null,{"$f":"B11+1","v":2},null,{"$f":"D11*(1+$C$4)-D$5","v":1.0000000000176534E-5},0.62901150000000006,0.83701475000000014,0.90500300000000011,0.93800185000000014,0.95704840000000002,0.96914545000000007,0.99020735500000012]
[null,3,null,null,0.42949207500000008,0.74936048750000017,0.85391315000000023,0.90465894250000023,0.93394882000000001,0.9525517225000002,0.98494082275000006]
[null,4,null,null,0.21999667875000012,0.65732351187500027,0.80026880750000029,0.86964888962500031,0.90969426100000006,0.93512830862500018,0.97941096388750015]
[null,5,null,null,2.6512687500118703E-5,0.56068468746875033,0.74394224787500041,0.83288833410625041,0.88422697405000006,0.9168337240562503,0.9736046120818751]
[null,6,null,null,null,0.4592139218421879,0.68479936026875043,0.79428975081156306,0.85748632275250014,0.89762441025906292,0.96750794268596896]
[null,7,null,null,null,0.3526696179342973,0.62269932828218799,0.75376123835214126,0.82940863889012517,0.87745463077201613,0.96110643982026733]
[null,8,null,null,null,0.24079809883101219,0.55749429469629741,0.7112063002697484,0.79992707083463144,0.85627636231061699,0.95438486181128068]
[null,9,null,null,null,0.12333300377256282,0.48902900943111227,0.66652361528323589,0.76897142437636301,0.83403918042614789,0.94732720490184463]
[null,10,null,null,null,-5.3460388090564859E-6,0.4171404599026679,0.61960679604739777,0.73646799559518117,0.81069013944745538,0.93991666514693684]
[null,11,null,null,null,null,0.34165748289780135,0.57034413584976773,0.70233939537494028,0.78617364641982823,0.93213559840428373]
[null,12,null,null,null,null,0.26240035704269143,0.51861834264225615,0.66650436514368727,0.76043132874081976,0.92396547832449794]
[null,13,null,null,null,null,0.17918037489482602,0.46430625977436896,0.62887758340087163,0.73340189517786081,0.9153868522407228]
[null,14,null,null,null,null,9.1799393639567337E-2,0.40727857276308743,0.58936946257091527,0.70502098993675388,0.90637929485275892]
[null,15,null,null,null,null,4.936332154571732E-5,0.34739950140124182,0.54788593569946109,0.67522103943359169,0.89692135959539687]
[null,16,null,null,null,null,null,0.28452647647130391,0.50432823248443415,0.64393109140527138,0.88699052757516672]
[null,17,null,null,null,null,null,{"$f":"H26*(1+$C$4)-H$5","v":0.21850980029486911},0.45859264410865586,0.61107664597553502,0.87656315395392503]
[null,18,null,null,null,null,null,0.14919229030961256,0.41057027631408866,0.57657947827431177,0.86561441165162134]
[null,19,null,null,null,null,null,7.6408904825093202E-2,0.36014679012979312,0.54035745218802744,0.85411823223420247]
[null,20,null,null,null,null,null,-1.3649933652132296E-5,0.30720212963628279,0.50232432479742883,0.84204724384591256]
[null,21,null,null,null,null,null,null,0.25161023611809691,0.46238954103730034,0.82937270603820823]
[null,22,null,null,null,null,null,null,0.19323874792400175,0.42045801808916539,0.81606444134011868]
[null,23,null,null,null,null,null,null,0.13194868532020188,0.37642991899362366,0.8020907634071246]
[null,24,null,null,null,null,null,null,6.7594119586211962E-2,0.33020041494330488,0.78741840157748089]
[null,25,null,null,null,null,null,null,2.1825565522562429E-5,0.28165943569047014,0.77201242165635497]
[null,26,null,null,null,null,null,null,null,0.23069140747499364,0.75583614273917277]
[null,27,null,null,null,null,null,null,null,0.17717497784874334,0.73885104987613137]
[null,28,null,null,null,null,null,null,null,0.12098272674118052,0.72101670236993798]
[null,29,null,null,null,null,null,null,null,6.1980863078239551E-2,0.7022906374884349]
[null,30,null,null,null,null,null,null,null,2.8906232151529321E-5,0.6826282693628567]
[null,31,null,null,null,null,null,null,null,null,0.66198278283099954]
[null,32,null,null,null,null,null,null,null,null,0.64030502197254957]
[null,33,null,null,null,null,null,null,null,null,{"$f":"K42*(1+$C$4)-K$5","v":0.61754337307117702}]
[null,34,null,null,null,null,null,null,null,null,0.59364364172473583]
[null,35,null,null,null,null,null,null,null,null,0.56854892381097266]
[null,36,null,null,null,null,null,null,null,null,0.54219947000152136]
[null,37,null,null,null,null,null,null,null,null,0.51453254350159738]
[null,38,null,null,null,null,null,null,null,null,0.48548227067667726]
[null,39,null,null,null,null,null,null,null,null,0.45497948421051115]
[null,40,null,null,null,null,null,null,null,null,0.42295155842103671]
[null,41,null,null,null,null,null,null,null,null,0.38932223634208857]
[null,42,null,null,null,null,null,null,null,null,0.354011448159193]
[null,43,null,null,null,null,null,null,null,null,0.31693512056715267]
[null,44,null,null,null,null,null,null,null,null,0.27800497659551032]
[null,45,null,null,null,null,null,null,null,null,0.23712832542528584]
[null,46,null,null,null,null,null,null,null,null,0.19420784169655014]
[null,47,null,null,null,null,null,null,null,null,0.14914133378137767]
[null,48,null,null,null,null,null,null,null,null,0.10182150047044657]
[null,49,null,null,null,null,null,null,null,null,5.21356754939689E-2]
[null,50,null,null,null,null,null,null,null,null,-3.4440731332657792E-5]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]

{"sheet":"Kapitalkosten 8% Zins","index":4,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,2,3,10]]}
[]
[null,"Tilgungsverlauf in Abhängigkeit des Zinssatzes und der Tilgungsrate"]
[]
[null,"Zins",0.08]
[null,"Annuität",1.08,0.56074999999999997,0.25045000000000001,0.14903,0.11683,0.101853,9.3678999999999998E-2,8.8827000000000003E-2,8.1742899999999993E-2]
[null,"Dauer",1,2,5,10,15,20,25,30,50,"Jahre"]
[null,"Kosten",{"$f":"C5*C6","v":1.08},{"$f":"D5*D6","v":1.1214999999999999},1.2522500000000001,1.4903,1.7524500000000001,2.0370599999999999,2.3419750000000001,2.6648100000000001,4.0871449999999996]
[null,null,"Restwert"]
[null,"Jahr"]
[null,0,1,1,1,1,1,1,1,1,1]
[null,{"$f":"B10+1","v":1},{"$f":"C10*(1+$C$4)-C$5","v":0},{"$f":"D10*(1+$C$4)-D$5","v":0.5192500000000001},{"$f":"E10*(1+$C$4)-E$5","v":0.82955000000000001},{"$f":"F10*(1+$C$4)-F$5","v":0.93097000000000008},0.96317000000000008,0.9781470000000001,0.98632100000000011,0.99117300000000008,0.99825710000000012]
[null,{"$f":"B11+1","v":2},null,{"$f":"D11*(1+$C$4)-D$5","v":4.0000000000151026E-5},0.64546400000000004,0.85641760000000011,0.92339360000000026,0.95454576000000024,0.97154768000000014,0.98163984000000015,0.99637476800000024]
[null,3,null,null,0.44665112000000012,0.77590100800000017,0.88043508800000037,0.92905642080000028,0.95559249440000016,0.97134402720000024,0.99434184944000037]
[null,4,null,null,0.23193320960000013,0.6889430886400002,0.83403989504000042,0.90152793446400037,0.93836089395200017,0.96022454937600044,0.99214629739520055]
[null,5,null,null,3.7866368000127881E-5,0.59502853573120029,0.78393308664320049,0.87179716922112049,0.91975076546816037,0.94821551332608056,0.98977510118681666]
[null,6,null,null,null,0.4936008185896964,0.72981773357465662,0.8396879427588102,0.89965182670561328,0.93524575439216706,0.98721420928176207]
[null,7,null,null,null,0.38405888407687216,0.67137315226062921,0.80500997817951514,0.87794497284206241,0.9212384147435404,0.98444844602430315]
[null,8,null,null,null,0.26575359480302196,0.60825300444147956,0.76755777643387646,0.85450157066942756,0.90611048792302373,0.98146142170624751]
[null,9,null,null,null,0.13798388238726372,0.54008324479679803,0.72710939854858669,0.82918269632298192,0.8897723269568657,0.97823543544274749]
[null,10,null,null,null,-7.4070217551680528E-6,0.46645990438054197,0.68342515043247376,0.80183831202882061,0.87212711311341506,0.97475137027816749]
[null,11,null,null,null,null,0.38694669673098536,0.63624616246707177,0.77230637699112636,0.85307028216248837,0.97098857990042109]
[null,12,null,null,null,null,0.30107243246946425,0.58529285546443754,0.74041188715041661,0.83248890473548753,0.96692476629245483]
[null,13,null,null,null,null,0.20832822706702142,0.53026328390159261,0.70596583812245006,0.81026101711432663,0.96253584759585131]
[null,14,null,null,null,null,0.10816448523238316,0.47083134661372006,0.66876410517224616,0.78625489848347285,0.95779581540351943]
[null,15,null,null,null,null,-1.2355949026182644E-5,0.40664485434281772,0.62858623358602594,0.76032829036215077,0.95267658063580118]
[null,16,null,null,null,null,null,0.33732344269024317,0.58519413227290806,0.73232755359112289,0.94714780708666535]
[null,17,null,null,null,null,null,{"$f":"H26*(1+$C$4)-H$5","v":0.26245631810546266},0.53833066285474074,0.70208675787841279,0.94117673165359872]
[null,18,null,null,null,null,null,0.18159982355389967,0.48771811588312003,0.66942669850868586,0.93472797018588671]
[null,19,null,null,null,null,null,9.4274809438211649E-2,0.43305656515376961,0.63415383438938078,0.92776330780075777]
[null,20,null,null,null,null,null,-3.6205806731415269E-5,0.3740220903660712,0.59605914114053127,0.92024147242481857]
[null,21,null,null,null,null,null,null,0.31026485759535694,0.55491687243177379,0.91211789021880418]
[null,22,null,null,null,null,null,null,0.24140704620298548,0.5104832222263157,0.90334442143630866]
[null,23,null,null,null,null,null,null,0.16704060989922431,0.46249488000442096,0.8938690751512135]
[null,24,null,null,null,null,null,null,8.6724858691162268E-2,0.41066747040477469,0.88363570116331069]
[null,25,null,null,null,null,null,null,-1.6152613544748173E-5,0.35469386803715669,0.87258365725637566]
[null,26,null,null,null,null,null,null,null,0.29424237748012927,0.86064744983688579]
[null,27,null,null,null,null,null,null,null,0.22895476767853962,0.84775634582383674]
[null,28,null,null,null,null,null,null,null,0.15844414909282278,0.83383395348974376]
[null,29,null,null,null,null,null,null,null,8.2292681020248601E-2,0.81879776976892338]
[null,30,null,null,null,null,null,null,null,4.909550186849021E-5,0.80255869135043734]
[null,31,null,null,null,null,null,null,null,null,0.78502048665847246]
[null,32,null,null,null,null,null,null,null,null,0.76607922559115038]
[null,33,null,null,null,null,null,null,null,null,{"$f":"K42*(1+$C$4)-K$5","v":0.74562266363844254}]
[null,34,null,null,null,null,null,null,null,null,0.72352957672951801]
[null,35,null,null,null,null,null,null,null,null,0.69966904286787956]
[null,36,null,null,null,null,null,null,null,null,0.67389966629731002]
[null,37,null,null,null,null,null,null,null,null,0.6460687396010949]
[null,38,null,null,null,null,null,null,null,null,0.61601133876918257]
[null,39,null,null,null,null,null,null,null,null,0.58354934587071727]
[null,40,null,null,null,null,null,null,null,null,0.54849039354037477]
[null,41,null,null,null,null,null,null,null,null,0.51062672502360484]
[null,42,null,null,null,null,null,null,null,null,0.46973396302549325]
[null,43,null,null,null,null,null,null,null,null,0.42556978006753271]
[null,44,null,null,null,null,null,null,null,null,0.37787246247293538]
[null,45,null,null,null,null,null,null,null,null,0.32635935947077022]
[null,46,null,null,null,null,null,null,null,null,0.27072520822843182]
[null,47,null,null,null,null,null,null,null,null,0.21064032488670636]
[null,48,null,null,null,null,null,null,null,null,0.14574865087764288]
[null,49,null,null,null,null,null,null,null,null,7.5665642947854342E-2]
[null,50,null,null,null,null,null,null,null,null,-2.4005616317296363E-5]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]