{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["متعقّب الأموال الشخصي","الملخص الشهري","بيانات المخطط"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"متعقّب الأموال الشخصي","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[19,1,20,1],[21,1,23,1]]}
[null,"متعقّب الأموال الشخصي"]
[]
[{"$nulls":3},"الملخص النقدي"]
[{"$nulls":3},"الحساب","المبلغ النقدي الأولي","إجمالي الإنفاق","المبلغ النقدي المتبقي"]
[{"$nulls":3},"جاري",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[الحساب],\"=\" &CashSummaryTable[[#This Row],[الحساب]],CashSpent[المبلغ])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[المبلغ النقدي الأولي]]-CashSummaryTable[[#This Row],[إجمالي الإنفاق]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"ادّخار",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[الحساب],\"=\" &CashSummaryTable[[#This Row],[الحساب]],CashSpent[المبلغ])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[المبلغ النقدي الأولي]]-CashSummaryTable[[#This Row],[إجمالي الإنفاق]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"غير ذلك",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[الحساب],\"=\" &CashSummaryTable[[#This Row],[الحساب]],CashSpent[المبلغ])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[المبلغ النقدي الأولي]]-CashSummaryTable[[#This Row],[إجمالي الإنفاق]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3}," الإجمالي ",{"$f":"SUBTOTAL(109,CashSummaryTable[المبلغ النقدي الأولي])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[إجمالي الإنفاق])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[المبلغ النقدي المتبقي])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"النقود التي أنفقتها"]
[{"$nulls":3},"التاريخ","الوصف","المبلغ","الحساب"]
[{"$nulls":3},"2012-01-04","سحب من الصراف الآلي ",{"v":40,"d":"40.00"},"جاري"]
[{"$nulls":3},"2012-01-05","الغداء ",{"v":5,"d":"5.00"},"جاري"]
[{"$nulls":3},"2012-01-06","سداد قرض السيارة ",{"v":230,"d":"230.00"},"ادّخار"]
[{"$nulls":3},"2012-02-03","سداد رسوم الكهرباء ",{"v":70,"d":"70.00"},"جاري"]
[{"$nulls":3},"2012-02-07","العشاء ",{"v":53,"d":"53.00"},"جاري"]
[{"$nulls":3},"2012-03-01","سحب نقدي ",{"v":100,"d":"100.00"},"ادّخار"]
[{"$nulls":3},"2012-03-06","سداد قرض السيارة ",{"v":230,"d":"230.00"},"جاري"]
[{"$nulls":3},"2012-04-06","سداد رسوم الكهرباء ",{"v":70,"d":"70.00"},"ادّخار"]
[null,"المبلغ النقدي المتبقي:",null,"2012-04-20","سحب من الصراف الآلي ",{"v":30,"d":"30.00"},"جاري"]
[{"$nulls":3},"2012-05-03","سحب من الصراف الآلي ",{"v":50,"d":"50.00"},"ادّخار"]
[null,{"$f":"CashSummaryTable[[#Totals],[المبلغ النقدي المتبقي]]/CashSummaryTable[[#Totals],[المبلغ النقدي الأولي]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","سحب من الصراف الآلي ",{"v":30,"d":"30.00"},"غير ذلك"]

{"sheet":"الملخص الشهري","index":1,"n_rows":27,"n_cols":6,"rows_kept":27}
[null,"الملخص الشهري"]
[null,"ملخص الحساب"]
{"$rows_empty":13}
[null,"ملخص الإنفاق"]
[null,"مجموع من المبلغ"]
[null,null,"ادّخار","جاري","غير ذلك","الإجمالي الكلي"]
[null,"يناير",230,45,null,275]
[null,"فبراير",null,123,null,123]
[null,"مارس"]
[null,"سحب نقدي ",100,null,null,100]
[null,"سداد قرض السيارة ",null,230,null,230]
[null,"أبريل",70,30,null,100]
[null,"مايو"]
[null,"سحب من الصراف الآلي ",50,null,30,80]
[null,"الإجمالي الكلي",450,428,30,908]

{"sheet":"بيانات المخطط","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"بيانات PivotChart"]
[null,"إن PivotTable هذا هو مصدر البيانات لـ PivotChart الخاص بملخص الحساب على الورقة \"الملخص الشهري\""]
[null,"مجموع من المبلغ","تسميات الأعمدة"]
[null,"تسميات الصفوف","ادّخار","جاري","غير ذلك","الإجمالي الكلي"]
[null,"يناير",{"v":230,"d":"230.00"},{"v":45,"d":"45.00"},null,{"v":275,"d":"275.00"}]
[null,"فبراير",null,{"v":123,"d":"123.00"},null,{"v":123,"d":"123.00"}]
[null,"مارس",{"v":100,"d":"100.00"},{"v":230,"d":"230.00"},null,{"v":330,"d":"330.00"}]
[null,"أبريل",{"v":70,"d":"70.00"},{"v":30,"d":"30.00"},null,{"v":100,"d":"100.00"}]
[null,"مايو",{"v":50,"d":"50.00"},null,{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"الإجمالي الكلي",{"v":450,"d":"450.00"},{"v":428,"d":"428.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]