{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sparplan"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Sparplan","index":0,"n_rows":130,"n_cols":5,"rows_kept":130,"merged":[[0,0,0,12]]}
["             Sparplan – Sparplan Rechner"]
[]
["Startkapital (€)",{"v":1000,"d":"1,000.00 €"},null,"Endsaldo (€)",{"$f":"IFERROR(INDEX($E$11:$E$130,$B$7),$B$3)","v":{"v":4732.76,"d":"4,732.76 €"}}]
["Monatliche Einzahlung (€)",{"v":250,"d":"250.00 €"},null,"Summe Einzahlungen (€)",{"$f":"SUM($B$11:$B$130)","v":{"v":3650,"d":"3,650.00 €"}}]
["Jahreszins (%)",{"v":3,"d":"3.00"},null,"Summe Zinsen (€)",{"$f":"SUM($D$11:$D$130)","v":{"v":82.75999999999999,"d":"82.76 €"}}]
["Startdatum","2026-01-01",null,"Monatlicher Zins (%)",{"$f":"ROUND($B$5/12/100,6)","v":{"v":0.0025,"d":"0.2500%"}}]
["Laufzeit (Monate)",12,null,"Ziel erreicht?",{"$f":"IF($B$8=\"\",\"-\",IF($E$3>=$B$8,\"Ja\",\"Nein\"))","v":"Nein"}]
["Zielbetrag (€) (optional)",{"v":5000,"d":"5,000.00 €"},null,"Hinweis",{"$f":"IF($B$8=\"\",\"Kein Zielbetrag gesetzt\",IF($E$3>=$B$8,\"Ziel erreicht\",\"Ziel nicht erreicht\"))","v":"Ziel nicht erreicht"}]
[]
["Monat","Eingezahlt","Zinsen (%)","Zinsen (€)","Saldo"]
[{"$f":"IF(ROW()-10<=$B$7,CHOOSE(MONTH(EDATE($B$6,ROW()-11)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")&\" \"&YEAR(EDATE($B$6,ROW()-11)),\"\")","v":"Januar 2026"},{"$f":"IF($A11=\"\",\"\",$B$4)","v":{"v":250,"d":"250.00 €"}},{"$f":"IF($A11=\"\",\"\",$B$5/100)","v":{"v":0.03,"d":"3.00%"}},{"$f":"IF($A11=\"\",\"\",ROUND((($B$3+$B11)*($B$5/12/100)),2))","v":{"v":3.13,"d":"3.13 €"}},{"$f":"IF($A11=\"\",\"\",ROUND($B$3+$B11+$D11,2))","v":{"v":1253.13,"d":"1,253.13 €"}}]
["Februar 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"$f":"IF($A12=\"\",\"\",ROUND((($E11+$B12)*($B$5/12/100)),2))","v":{"v":3.76,"d":"3.76 €"}},{"$f":"IF($A12=\"\",\"\",ROUND($E11+$B12+$D12,2))","v":{"v":1506.89,"d":"1,506.89 €"}}]
["März 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"v":4.39,"d":"4.39 €"},{"v":1761.28,"d":"1,761.28 €"}]
["April 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"v":5.03,"d":"5.03 €"},{"v":2016.31,"d":"2,016.31 €"}]
["Mai 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"v":5.67,"d":"5.67 €"},{"v":2271.98,"d":"2,271.98 €"}]
["Juni 2026",{"v":100,"d":"100.00 €"},{"v":0.03,"d":"3.00%"},{"v":5.93,"d":"5.93 €"},{"v":2377.91,"d":"2,377.91 €"}]
["Juli 2026",{"v":350,"d":"350.00 €"},{"v":0.03,"d":"3.00%"},{"v":6.82,"d":"6.82 €"},{"v":2734.73,"d":"2,734.73 €"}]
["August 2026",{"v":500,"d":"500.00 €"},{"v":0.03,"d":"3.00%"},{"v":8.09,"d":"8.09 €"},{"v":3242.82,"d":"3,242.82 €"}]
["September 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"v":8.73,"d":"8.73 €"},{"v":3501.55,"d":"3,501.55 €"}]
["Oktober 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"v":9.38,"d":"9.38 €"},{"v":3760.93,"d":"3,760.93 €"}]
["November 2026",{"v":250,"d":"250.00 €"},{"v":0.03,"d":"3.00%"},{"v":10.03,"d":"10.03 €"},{"v":4020.96,"d":"4,020.96 €"}]
["Dezember 2026",{"v":700,"d":"700.00 €"},{"v":0.03,"d":"3.00%"},{"v":11.8,"d":"11.80 €"},{"v":4732.76,"d":"4,732.76 €"}]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
[{"$f":"IF(ROW()-10<=$B$7,CHOOSE(MONTH(EDATE($B$6,ROW()-11)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")&\" \"&YEAR(EDATE($B$6,ROW()-11)),\"\")","v":""},{"$f":"IF($A43=\"\",\"\",$B$4)","v":""},{"$f":"IF($A43=\"\",\"\",$B$5/100)","v":""},"",""]
["","","",{"$f":"IF($A44=\"\",\"\",ROUND((($E43+$B44)*($B$5/12/100)),2))","v":""},{"$f":"IF($A44=\"\",\"\",ROUND($E43+$B44+$D44,2))","v":""}]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
[{"$f":"IF(ROW()-10<=$B$7,CHOOSE(MONTH(EDATE($B$6,ROW()-11)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")&\" \"&YEAR(EDATE($B$6,ROW()-11)),\"\")","v":""},{"$f":"IF($A75=\"\",\"\",$B$4)","v":""},{"$f":"IF($A75=\"\",\"\",$B$5/100)","v":""},"",""]
["","","",{"$f":"IF($A76=\"\",\"\",ROUND((($E75+$B76)*($B$5/12/100)),2))","v":""},{"$f":"IF($A76=\"\",\"\",ROUND($E75+$B76+$D76,2))","v":""}]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
[{"$f":"IF(ROW()-10<=$B$7,CHOOSE(MONTH(EDATE($B$6,ROW()-11)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")&\" \"&YEAR(EDATE($B$6,ROW()-11)),\"\")","v":""},{"$f":"IF($A107=\"\",\"\",$B$4)","v":""},{"$f":"IF($A107=\"\",\"\",$B$5/100)","v":""},"",""]
["","","",{"$f":"IF($A108=\"\",\"\",ROUND((($E107+$B108)*($B$5/12/100)),2))","v":""},{"$f":"IF($A108=\"\",\"\",ROUND($E107+$B108+$D108,2))","v":""}]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]