{"text_format":"3","workbook":"xlsx","n_sheets":4,"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":[[0,1,1,5],[2,1,2,2],[2,3,2,4],[3,1,18,1],[19,1,20,1],[21,1,22,1]]}
[null,"متعقب الأموال الشخصي"]
[{"$nulls":6},"النقد المنفق >"]
[{"$nulls":3},"ملخص النقد"]
[null,"مخطط عمودي لعرض النسبة المئوية للنقد المتوفر في هذه الخلية.",null,"الحساب","النقد المبدئي","إجمالي الإنفاق","النقد المتبقي"]
[{"$nulls":3},"الجاري",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(النقد_المنفق[الحساب],\"=\" &CashSummaryTable[[#This Row],[الحساب]],النقد_المنفق[المبلغ])","v":{"v":496,"d":"496.00"}},{"$f":"CashSummaryTable[[#This Row],[النقد المبدئي]]-CashSummaryTable[[#This Row],[إجمالي الإنفاق]]","v":{"v":2504,"d":"2504.00"}}]
[{"$nulls":3},"المدخرات",{"v":500,"d":"500.00"},{"$f":"SUMIF(النقد_المنفق[الحساب],\"=\" &CashSummaryTable[[#This Row],[الحساب]],النقد_المنفق[المبلغ])","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(النقد_المنفق[الحساب],\"=\" &CashSummaryTable[[#This Row],[الحساب]],النقد_المنفق[المبلغ])","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":976,"d":"976.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[النقد المتبقي])","v":{"v":2724,"d":"2724.00"}}]
{"$rows_empty":11}
[null,"النقد\nالمتبقي:"]
[]
[null,{"$f":"CashSummaryTable[[#Totals],[النقد المتبقي]]/CashSummaryTable[[#Totals],[النقد المبدئي]]","v":{"v":0.7362162162162162,"d":"74%"}}]

{"sheet":"النقد المنفق","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,1,3],[2,1,2,2],[3,5,6,6],[7,5,14,6]]}
[null,"متعقب الأموال الشخصي"]
[{"$nulls":4},"< ملخص النقد","ملخص شهري >"]
[null,"النقد المنفق"]
[null,"التاريخ","الوصف","المبلغ","الحساب","يوجد \"مقسم طريقة العرض\" لتصفية بيانات الجدول استناداً إلى \"نوع الحساب\" في هذه الخلية."]
[null,{"$f":"TODAY()+105","v":"2023-03-29"},"السحب من ماكينة الصرّاف الآلي",{"v":40,"d":"40.00"},"الجاري"]
[null,{"$f":"TODAY()+106","v":"2023-03-30"},"الغداء",{"v":5,"d":"5.00"},"الجاري"]
[null,{"$f":"TODAY()+107","v":"2023-03-31"},"دفع السيارة",{"v":230,"d":"230.00"},"المدخرات"]
[null,{"$f":"TODAY()+135","v":"2023-04-28"},"دفع الكهرباء",{"v":70,"d":"70.00"},"الجاري","يوجد \"مقسم طريقة العرض\" لتصفية بيانات الجدول استناداً إلى \"الوصف\" في هذه الخلية."]
[null,{"$f":"TODAY()+139","v":"2023-05-02"},"العشاء",{"v":53,"d":"53.00"},"الجاري"]
[null,{"$f":"TODAY()+162","v":"2023-05-25"},"السحب النقدي",{"v":100,"d":"100.00"},"المدخرات"]
[null,{"$f":"TODAY()+167","v":"2023-05-30"},"دفع السيارة",{"v":230,"d":"230.00"},"الجاري"]
[null,{"$f":"TODAY()+198","v":"2023-06-30"},"دفع الكهرباء",{"v":70,"d":"70.00"},"المدخرات"]
[null,{"$f":"TODAY()+212","v":"2023-07-14"},"السحب من ماكينة الصرّاف الآلي",{"v":30,"d":"30.00"},"الجاري"]
[null,{"$f":"TODAY()+225","v":"2023-07-27"},"السحب من ماكينة الصرّاف الآلي",{"v":50,"d":"50.00"},"المدخرات"]
[null,{"$f":"TODAY()+232","v":"2023-08-03"},"السحب من ماكينة الصرّاف الآلي",{"v":30,"d":"30.00"},"أخرى"]
[null,{"$f":"TODAY()+283","v":"2023-09-23"},"دفع الكهرباء",{"v":68,"d":"68.00"},"الجاري"]

{"sheet":"ملخص شهري","index":2,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[0,1,1,4],[2,1,2,5],[3,1,3,6],[4,1,16,4],[4,5,8,6],[9,5,16,6],[17,1,17,5]]}
[null,"ملخص شهري"]
[{"$nulls":5},"< النقد المنفق"]
[null,"لتحديث هذه البيانات، حدد أولاً PivotChart.  قم بالنقر مرةً واحدةً بزر الماوس الأيمن للحصول علي القائمة المختصرة.  حدد تحديث أو تحديث الكل لتحديث المخطط."]
[null,"ملخص الحساب"]
[null,"مخطط عمودي لملخص الحساب يقارن الحساب الجاري وحساب التوفير وغير ذلك لكل شهر في هذه الخلية.",{"$nulls":3},"مقسم طريقة العرض لتصفية المخطط حسب نوع الحساب في هذه الخلية."]
[]
[]
[]
[]
[{"$nulls":5},"يوجد \"مقسم طريقة العرض\" لتصفية بيانات المخطط استناداً إلى \"الوصف\" في هذه الخلية."]
{"$rows_empty":7}
[null,"ملخص الإنفاق"]
[null,"التفاصيل"]
[null,null,"الجاري","المدخرات","أخرى","الإجمالي الكلي"]
[null,"مارس",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"السحب من ماكينة الصرّاف الآلي",{"v":40,"d":"40.00"},null,null,{"v":40,"d":"40.00"}]
[null,"الغداء",{"v":5,"d":"5.00"},null,null,{"v":5,"d":"5.00"}]
[null,"دفع السيارة",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"أبريل",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.00"}]
[null,"دفع الكهرباء",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.00"}]
[null,"مايو",{"v":283,"d":"283.00"},{"v":100,"d":"100.00"},null,{"v":383,"d":"383.00"}]
[null,"السحب النقدي",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"العشاء",{"v":53,"d":"53.00"},null,null,{"v":53,"d":"53.00"}]
[null,"دفع السيارة",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"يونيو",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"دفع الكهرباء",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"يوليو",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},null,{"v":80,"d":"80.00"}]
[null,"السحب من ماكينة الصرّاف الآلي",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},null,{"v":80,"d":"80.00"}]
[null,"أغسطس",null,null,{"v":30,"d":"30.00"},{"v":30,"d":"30.00"}]
[null,"السحب من ماكينة الصرّاف الآلي",null,null,{"v":30,"d":"30.00"},{"v":30,"d":"30.00"}]
[null,"سبتمبر",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"دفع الكهرباء",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"الإجمالي الكلي",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]

{"sheet":"بيانات المخطط","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"merged":[[0,1,0,2]]}
[null,"بيانات PivotChart"]
[null,"إن PivotTable هو مصدر البيانات لملخص حساب PivotChart علي ورقة الملخص الشهري"]
[null,"مجموع من المبلغ","تسميات الأعمدة"]
[null,"تسميات الصفوف","الجاري","المدخرات","أخرى","الإجمالي الكلي"]
[null,"مارس",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"أبريل",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.00"}]
[null,"مايو",{"v":283,"d":"283.00"},{"v":100,"d":"100.00"},null,{"v":383,"d":"383.00"}]
[null,"يونيو",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"يوليو",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},null,{"v":80,"d":"80.00"}]
[null,"أغسطس",null,null,{"v":30,"d":"30.00"},{"v":30,"d":"30.00"}]
[null,"سبتمبر",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"الإجمالي الكلي",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]