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

{"sheet":"Estimador de ahorros","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]]}
["RECESO INVERNAL\nVIAJE A MÉXICO"]
[]
[]
[]
[null," Comience ahorrando en:"," Termine ahorrando en:",{"$nulls":3}," Ahorrar dinero:"]
[null,{"$f":"TODAY()-120","v":"2012-05-29"},{"$f":"DateSavingsBegin+180","v":"2012-11-25"},null,null,"QUINCENAL"]
[]
[]
[]
[null,"COSTO DEL VIAJE:",{"v":6000,"d":"6,000 €"}]
[null,"AHORROS PREVIOS:",{"v":300,"d":"300 €"}]
[]
[]
[null,"OBJETIVO\nACTUAL DE AHORRO:",{"$f":"EventoCosto-ImporteAhorrado","v":{"v":5700,"d":"5,700 €"}}]
[]
[]
[{"$f":"IF(SavingsPlanInfo>0,\"  Si ahorro \"&TEXT(SavingsPlanInfo,\"$#,##0 \")&PROPER(SavingFrequency)&\", desde \"&TEXT(TODAY(),\"dd.mm.yy\"&\":\"),\"  La Fecha del evento está demasiado cerca para un \"&PROPER(SavingFrequency)&\" Plan de ahorro\")","v":"  Si ahorro $475,0 Quincenal, desde 26.09.yy:"}]
[null,"He ahorrado:",{"$f":" IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+ImporteAhorrado,ImporteAhorrado)","v":{"v":4100,"d":"4,100 €"}}]
[null,"Aún debo ahorrar:",{"$f":"MAX(0,EventoCosto-SavingsToDate)","v":{"v":1900,"d":"1,900 €"}}]
[]
[]
[]
["DETALLES DEL PLAN DE PAGOS"]
[null,"Intervalo de ahorro","Diario","Semanal","Quincenal","Mensual","Anual"]
[null,"Monto a ahorrar:",{"$f":"MIN(Meta,IF(DíasHastaElEvento=\"\",0,Meta/DíasHastaElEvento))","v":{"v":31.666666666666668,"d":"32 €"}},{"$f":"MIN(Meta,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Meta/WeeksUntilEvent)))","v":{"v":221.66666666666666,"d":"222 €"}},{"$f":"IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Meta,IF(D25=\"\",0,Meta/BiWeeksUntilEvent)))","v":{"v":475,"d":"475 €"}},{"$f":"MIN(Meta,IF(Meta=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Meta/MonthsUntilEvent)))","v":{"v":1140,"d":"1,140 €"}},{"$f":"IF(OR(Meta=\"\",Meta=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Meta/YearsUntilEvent))","v":{"v":0,"d":"0 €"}}]
[]
[null,"Intervalo de tiempo","Días","Semanas","Quincenal","Meses","Años"]
[null,"Tiempo hasta que se alcanzó el objetivo:",{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,FechaDelEvento,\"D\"),\"\")","v":180},{"$f":"IF(DíasHastaElEvento<>\"\",DíasHastaElEvento/7,\"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IF(OR(WeeksUntilEvent=0,WeeksUntilEvent=\"\"),0,ROUNDDOWN(WeeksUntilEvent/2,0))","v":12},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,FechaDelEvento,\"M\"),\"\")","v":5},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,FechaDelEvento,\"Y\"),\"\")","v":0}]