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

{"sheet":"Sparhilfe","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[0,0,0,6],[4,2,4,4],[5,2,5,4],[5,5,5,6],[9,2,9,3],[10,2,10,3],[13,2,13,3],[17,2,17,3],[18,2,18,3]]}
["WINTERURLAUBSREISE NACH MEXIKO"]
[]
[]
[]
[null," Sparen beginnen am:"," Sparen beenden bis:",{"$nulls":3}," Sparintervall:"]
[null,{"$f":"TODAY()-120","v":"2012-06-21"},{"$f":"DatumBeginnSparen+180","v":"2012-12-18"},null,null,"ZWEIWÖCHENTLICH"]
[]
[]
[]
[null,"REISEKOSTEN:",{"v":6000,"d":"6,000 €"}]
[null,"FRÜHER GESPART:",{"v":300,"d":"300 €"}]
[]
[]
[null,"AKTUELLES SPARZIEL:",{"$f":"EreignisKosten-GesparterBetrag","v":{"v":5700,"d":"5,700 €"}}]
[]
[]
[{"$f":"IF(ErsparnissePlanInfo>0,\"  Wenn ich spare \"&TEXT(ErsparnissePlanInfo,\"#.##0 € \")&PROPER(SparenHäufigkeit)&\", Stand \"&TEXT(TODAY(),\"TT.MM.JJ\"&\":\"),\"  Datum der Veranstaltung ist zu nah für \"&PROPER(SparenHäufigkeit)&\" Sparplan\")","v":"  Wenn ich spare 475 € Zweiwöchentlich, Stand 19.10.12:"}]
[null,"Ich habe gespart:",{"$f":" IF(ErsparnissePlanInfo>0,IF(TODAY()>DatumBeginnSparen,(TODAY()-DatumBeginnSparen)*TäglicheErsparnisse,0)+GesparterBetrag,GesparterBetrag)","v":{"v":4100,"d":"4,100 €"}}]
[null,"Ich muss noch sparen:",{"$f":"MAX(0,EreignisKosten-ErsparnisseBisHeute)","v":{"v":1900,"d":"1,900 €"}}]
[]
[]
[]
["DETAILS ZUM SPARPLAN"]
[null,"Sparintervall","Täglich","Wöchentlich","Zweiwöchentlich","Monatlich","Jährlich"]
[null,"Zu sparender Betrag:",{"$f":"MIN(Ziel,IF(TageBisEreignis=\"\",0,Ziel/TageBisEreignis))","v":{"v":31.666666666666668,"d":"32 €"}},{"$f":"MIN(Ziel,IF(WochenBisEreignis=\"\",0,IF(ROUNDUP(WochenBisEreignis,0)=0,0,Ziel/WochenBisEreignis)))","v":{"v":221.66666666666666,"d":"222 €"}},{"$f":"IF(OR(ZweiWochenBisEreignis=0,ZweiWochenBisEreignis=\"\"),0,MIN(Ziel,IF(D25=\"\",0,Ziel/ZweiWochenBisEreignis)))","v":{"v":475,"d":"475 €"}},{"$f":"MIN(Ziel,IF(Ziel=\"\",0,IF(OR(MonateBisEreignis=0,MonateBisEreignis=\"\"),0,Ziel/MonateBisEreignis)))","v":{"v":1140,"d":"1,140 €"}},{"$f":"IF(OR(Ziel=\"\",Ziel=0),0,IF(OR(JahreBisEreignis=0,JahreBisEreignis=\"\"),0,Ziel/JahreBisEreignis))","v":{"v":0,"d":"0 €"}}]
[]
[null,"Zeitintervall","Tage","Wochen","Zweiwöchentlich","Monate","Jahre"]
[null,"Zeit bis zum Erreichen des Ziels:",{"$f":"IF(DatumBeginnSparen<>\"\",DATEDIF(DatumBeginnSparen,EreignisDatum,\"D\"),\"\")","v":180},{"$f":"IF(TageBisEreignis<>\"\",TageBisEreignis/7,\"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IF(OR(WochenBisEreignis=0,WochenBisEreignis=\"\"),0,ROUNDDOWN(WochenBisEreignis/2,0))","v":12},{"$f":"IF(DatumBeginnSparen<>\"\",DATEDIF(DatumBeginnSparen,EreignisDatum,\"M\"),\"\")","v":5},{"$f":"IF(DatumBeginnSparen<>\"\",DATEDIF(DatumBeginnSparen,EreignisDatum,\"Y\"),\"\")","v":0}]