{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["مقدر المدخرات"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"مقدر المدخرات","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[0,0,0,6],[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]]}
["رحلة عطلة الشتاء إلى المكسيك"]
[]
[]
[]
[null," بدء الادخار في:"," إنهاء الادخار في:",null,null,"ادخار النقود:"]
[null,{"$f":"TODAY()-120","v":"2012-07-01"},{"$f":"DateSavingsBegin+180","v":"2012-12-28"},null,null,"كل أسبوعين"]
[]
[]
[]
[null,"تكلفة الرحلة:",{"v":6000,"d":" 6,000 ر.س.‏"}]
[null,"المدخرات السابقة:",{"v":300,"d":" 300 ر.س.‏"}]
[]
[]
[null,"هدف الادخار الحالي:",{"$f":"EventCost-AmountSaved","v":{"v":5700,"d":" 5,700 ر.س.‏"}}]
[]
[]
[{"$f":"IF(SavingsPlanInfo>0,\"  إذا ادخرت \"&TEXT(SavingsPlanInfo,\"#,##0 ر.س. \")&PROPER(SavingFrequency)&\",  اعتباراً من \"&TEXT(TODAY(),\"mm.dd.yy\"&\":\"),\"   تاريخ الحدث قريب جداً  \"&PROPER(SavingFrequency)&\" من خطة التوفير \")","v":"  إذا ادخرت 475 ر.س.‏ كل أسبوعين,  اعتباراً من 10.29.12:"}]
[null,"لقد وفرت:",{"$f":" IF(SavingsPlanInfo>0,IF(TODAY()>DateSavingsBegin,(TODAY()-DateSavingsBegin)*DailySavings,0)+AmountSaved,AmountSaved)","v":{"v":4100,"d":" 4,100 ر.س.‏"}}]
[null,"ما زلت بحاجة لتوفير:",{"$f":"MAX(0,EventCost-SavingsToDate)","v":{"v":1900,"d":" 1,900 ر.س.‏"}}]
[]
[]
[]
["تفاصيل خطة الادخار"]
[null,"الفاصل الزمني للادخار","يومياً","أسبوعياً","كل أسبوعين","شهرياً","سنوياً"]
[null,"القدر المطلوب توفيره:",{"$f":"MIN(Goal,IF(DaysUntilEvent=\"\",0,Goal/DaysUntilEvent))","v":{"v":31.666666666666668,"d":" 32 ر.س.‏"}},{"$f":"MIN(Goal,IF(WeeksUntilEvent=\"\",0,IF(ROUNDUP(WeeksUntilEvent,0)=0,0,Goal/WeeksUntilEvent)))","v":{"v":221.66666666666666,"d":" 222 ر.س.‏"}},{"$f":"IF(OR(BiWeeksUntilEvent=0,BiWeeksUntilEvent=\"\"),0,MIN(Goal,IF(D25=\"\",0,Goal/BiWeeksUntilEvent)))","v":{"v":475,"d":" 475 ر.س.‏"}},{"$f":"MIN(Goal,IF(Goal=\"\",0,IF(OR(MonthsUntilEvent=0,MonthsUntilEvent=\"\"),0,Goal/MonthsUntilEvent)))","v":{"v":1140,"d":" 1,140 ر.س.‏"}},{"$f":"IF(OR(Goal=\"\",Goal=0),0,IF(OR(YearsUntilEvent=0,YearsUntilEvent=\"\"),0,Goal/YearsUntilEvent))","v":{"v":0,"d":" 0 ر.س.‏"}}]
[]
[null,"الفاصل الزمني","الأيام","الأسابيع","كل أسبوعين","الأشهر","السنوات"]
[null,"الوقت حتى تحقيق الهدف:",{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"D\"),\"\")","v":{"v":180,"d":" 180 ر.س.‏"}},{"$f":"IF(DaysUntilEvent<>\"\",DaysUntilEvent/7,\"\")","v":{"v":25.714285714285715,"d":" 26 ر.س.‏"}},{"$f":"IF(OR(WeeksUntilEvent=0,WeeksUntilEvent=\"\"),0,ROUNDDOWN(WeeksUntilEvent/2,0))","v":{"v":12,"d":" 12 ر.س.‏"}},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"M\"),\"\")","v":{"v":5,"d":" 5 ر.س.‏"}},{"$f":"IF(DateSavingsBegin<>\"\",DATEDIF(DateSavingsBegin,EventDate,\"Y\"),\"\")","v":{"v":0,"d":" 0 ر.س.‏"}}]