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

{"sheet":"Sparplan","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,6,0,7],[7,6,7,7]]}
["Monat","Eingezahlt","Zinsen (%)","Zinsen (€)","Saldo",null,"Einstellungen"]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,0)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Januar"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND(($H$3+B2)*C2,2)","v":{"v":3,"d":"€ 3.00"}},{"$f":"($H$3+B2+D2)","v":{"v":1203,"d":"€ 1,203.00"}},null,"Startdatum","2026-01-01"]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,1)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Februar"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E2+B3)*C3,2)","v":{"v":3.51,"d":"€ 3.51"}},{"$f":"(E2+B3+D3)","v":{"v":1406.51,"d":"€ 1,406.51"}},null,"Startkapital (€)",{"v":1000,"d":"€ 1,000.00"}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,2)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"März"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E3+B4)*C4,2)","v":{"v":4.02,"d":"€ 4.02"}},{"$f":"(E3+B4+D4)","v":{"v":1610.53,"d":"€ 1,610.53"}},null,"Monatliche Einzahlung (€)",{"v":200,"d":"€ 200.00"}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,3)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"April"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E4+B5)*C5,2)","v":{"v":4.53,"d":"€ 4.53"}},{"$f":"(E4+B5+D5)","v":{"v":1815.06,"d":"€ 1,815.06"}},null,"Jährlicher Zinssatz (%)",{"v":3,"d":"3.00"}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,4)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Mai"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E5+B6)*C6,2)","v":{"v":5.04,"d":"€ 5.04"}},{"$f":"(E5+B6+D6)","v":{"v":2020.1,"d":"€ 2,020.10"}},null,"Laufzeit (Monate)",12]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,5)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Juni"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E6+B7)*C7,2)","v":{"v":5.55,"d":"€ 5.55"}},{"$f":"(E6+B7+D7)","v":{"v":2225.65,"d":"€ 2,225.65"}},null,"Sparziel (€) (optional)",{"v":5000,"d":"€ 5,000.00"}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,6)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Juli"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E7+B8)*C8,2)","v":{"v":6.06,"d":"€ 6.06"}},{"$f":"(E7+B8+D8)","v":{"v":2431.71,"d":"€ 2,431.71"}},null,"Übersicht"]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,7)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"August"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E8+B9)*C9,2)","v":{"v":6.58,"d":"€ 6.58"}},{"$f":"(E8+B9+D9)","v":{"v":2638.29,"d":"€ 2,638.29"}},null,"Endsaldo (€)",{"$f":"E13","v":{"v":3469.78,"d":"€ 3,469.78"}}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,8)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"September"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E9+B10)*C10,2)","v":{"v":7.1,"d":"€ 7.10"}},{"$f":"(E9+B10+D10)","v":{"v":2845.39,"d":"€ 2,845.39"}},null,"Gesamteinzahlungen (€)",{"$f":"B14","v":{"v":2400,"d":"€ 2,400.00"}}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,9)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Oktober"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E10+B11)*C11,2)","v":{"v":7.61,"d":"€ 7.61"}},{"$f":"(E10+B11+D11)","v":{"v":3053,"d":"€ 3,053.00"}},null,"Gesamtzinsen (€)",{"$f":"D14","v":{"v":69.78,"d":"€ 69.78"}}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,10)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"November"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E11+B12)*C12,2)","v":{"v":8.13,"d":"€ 8.13"}},{"$f":"(E11+B12+D12)","v":{"v":3261.13,"d":"€ 3,261.13"}},null,"Ziel erreicht?",{"$f":"IF($H$7=\"\",\"\",IF(H9>=$H$7,\"Ja\",\"Nein\"))","v":"Nein"}]
[{"$f":"CHOOSE(MONTH(EDATE($H$2,11)),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Dezember"},{"$f":"IF($H$4=\"\",\"\",$H$4)","v":{"v":200,"d":"€ 200.00"}},{"$f":"IF($H$5=\"\",\"\",$H$5/12/100)","v":{"v":0.0025,"d":"0.25%"}},{"$f":"ROUND((E12+B13)*C13,2)","v":{"v":8.65,"d":"€ 8.65"}},{"$f":"(E12+B13+D13)","v":{"v":3469.78,"d":"€ 3,469.78"}}]
["Gesamt",{"$f":"SUM(B2:B13)","v":{"v":2400,"d":"€ 2,400.00"}},"",{"$f":"SUM(D2:D13)","v":{"v":69.78,"d":"€ 69.78"}},{"$f":"E13","v":{"v":3469.78,"d":"€ 3,469.78"}}]