{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Estimateur d'épargnes"],"not_rendered":{"charts":1,"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"Estimateur d'épargnes","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[0,1,0,6],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[4,2,4,3],[5,2,5,3],[7,2,7,3],[8,2,8,3]]}
[null,"PAUSE D'HIVER\nVOYAGE AU MEXIQUE"]
[null," Commencez à économiser sur :"," Finir d'économiser par :",null," Épargner de l’argent :"]
[null,{"$f":"TODAY()-120","v":"2021-12-03"},{"$f":"DateSavingsBegin+180","v":"2022-06-01"},null,"UNE FOIS PAR MOIS"]
[null,"COÛT DE DÉPLACEMENT :",{"v":6000,"d":"6,000 €"},null,"Le graphique circulaire comparant l'épargne actuelle totale à l'argent qui reste à épargner se trouve dans cette cellule."]
[null,"ÉPARGNE PRIORITAIRE :",{"v":300,"d":"300 €"}]
[null,"ACTUEL OBJECTIF D’ÉPARGNE :",{"$f":"IFERROR(EventCost-MontantÉpargné, \"\")","v":{"v":5700,"d":"5,700 €"}}]
[null,{"$f":"IFERROR(IF(SavingsPlanInfo>0,\"Si j’épargne \"&TEXT(SavingsPlanInfo,\"# ##0 € \")&PROPER(SavingFrequency)&\", à partir de \"&TEXT(TODAY(),\"jj.mm.aa\"&\":\"),\"La date de l'événement est trop proche pour un \"&PROPER(SavingFrequency)&\" Plan d’épargne\"), \"\")","v":"Si j’épargne 1 140 € Une Fois Par Mois, à partir de 02.04.22:"}]
[null,"J’ai épargné :",{"$f":" IFERROR(IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*ÉpargnesQuotidiennes,0)+MontantÉpargné,MontantÉpargné), \"\")","v":{"v":4100,"d":"4,100 €"}}]
[null,"J’ai encore besoin d’épargner :",{"$f":"IFERROR(MAX(0,EventCost-SavingsToDate), \"\")","v":{"v":1900,"d":"1,900 €"}}]
[]
[null,"DÉTAILS DU PLAN D'ÉPARGNE"]
[null,"Intervalle d’épargne","Tous les jours","Une fois par semaine","Bi-hebdomadairement","Une fois par mois","1 fois par an"]
[null,"Montant à épargner :",{"$f":"IFERROR(MIN(Objectif,IF(DaysUntilEvent=\"\",0,Objectif/DaysUntilEvent)), \"\")","v":{"v":31.666666666666668,"d":"32 €"}},{"$f":"IFERROR(MIN(Objectif,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Objectif/WeeksUntilEvent))), \"\")","v":{"v":221.66666666666666,"d":"222 €"}},{"$f":"IFERROR(IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Objectif,IF(D13=\"\",0,Objectif/BiWeeksUntilEvent))), \"\")","v":{"v":475,"d":"475 €"}},{"$f":"IFERROR(MIN(Objectif,IF(Objectif=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Objectif/MonthsUntilEvent))), \"\")","v":{"v":1140,"d":"1,140 €"}},{"$f":"IFERROR(IF(OR(Objectif=\"\",Objectif=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Objectif/YearsUntilEvent)), \"\")","v":{"v":0,"d":"0 €"}}]
[null,"Intervalle de temps","Jours","Semaines","Bi-hebdomadaire","Mois","Années"]
[null,"Temps jusqu'à ce que l'objectif soit atteint :",{"$f":"IFERROR(IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"D\"),\"\"), \"\")","v":180},{"$f":"IFERROR(IF(DaysUntilEvent<>\"\",DaysUntilEvent/7,\"\"), \"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IFERROR(IF(OR(WeeksUntilEvent=0,WeeksUntilEvent=\"\"),0,ROUNDDOWN(WeeksUntilEvent/2,0)), \"\")","v":12},{"$f":"IFERROR(IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"M\"),\"\"), \"\")","v":5},{"$f":"IFERROR(IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"Y\"),\"\"), \"\")","v":0}]