{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ملخص المصروفات","دفتر يومية المصروفات"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"ملخص المصروفات","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"ملخص المصروفات",null,null,"قم بتعديل أسماء \"الفئات\" في عنوان جدول \"ملخص المصروفات\" أدناه لتخصيص هذا القالب ليناسب احتياجاتك. إذا كنت بحاجة إلى إضافة فئات إضافية، فانسخ العمود الأخير في الجدول والصقه على يسار العمود المنسوخ. عندما تقوم بتغيير اسم الفئة، سيتم تحديث الصيغ تلقائياً. تأكد من أن هذا الجدول يحتوي على نفس عدد الصفوف الموجودة في ورقة العمل \"دفتر يومية المصروفات\"."]
[null,"التاريخ","تأمين السيارة","مستلزمات المكتب","الكهرباء","الرهن","الهاتف","‏‏فارغ 1","‏‏فارغ 2","‏‏فارغ 3","فارغ 4"]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A1),1),\"\")","v":"2018-04-04"},{"$f":"IFERROR(INDIRECT(\"السجل[@المبلغ]\")*(INDIRECT(\"السجل[@الفئة]\")=اسم_الفئة),\"\")","v":0},0,0,{"v":1200,"d":"ر.س.‏ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A2),1),\"\")","v":"2018-04-09"},0,0,{"v":85,"d":"ر.س.‏ 85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A3),1),\"\")","v":"2018-04-14"},{"v":100,"d":"ر.س.‏ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A4),1),\"\")","v":"2018-04-19"},0,0,0,{"v":1200,"d":"ر.س.‏ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A5),1),\"\")","v":"2018-04-24"},0,0,0,{"v":99,"d":"ر.س.‏ 99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A6),1),\"\")","v":"2018-04-29"},0,0,0,0,{"v":68,"d":"ر.س.‏ 68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A7),1),\"\")","v":"2018-05-04"},{"v":100,"d":"ر.س.‏ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A8),1),\"\")","v":"2018-05-09"},0,{"v":345,"d":"ر.س.‏ 345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A9),1),\"\")","v":"2018-05-14"},0,0,0,{"v":1200,"d":"ر.س.‏ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A10),1),\"\")","v":"2018-05-19"},0,0,{"v":74,"d":"ر.س.‏ 74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A11),1),\"\")","v":"2018-05-24"},0,0,0,0,{"v":123,"d":"ر.س.‏ 123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A12),1),\"\")","v":"2018-05-29"},0,{"v":99,"d":"ر.س.‏ 99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A13),1),\"\")","v":"2018-06-03"},{"v":100,"d":"ر.س.‏ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A14),1),\"\")","v":"2018-06-08"},0,0,0,{"v":1200,"d":"ر.س.‏ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(السجل[],ROW(A15),1),\"\")","v":"2018-06-13"},0,{"v":128,"d":"ر.س.‏ 128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,ملخص_المصروفات[تأمين السيارة])","v":{"v":300,"d":"ر.س.‏ 300.00"}},{"$f":"SUBTOTAL(109,ملخص_المصروفات[مستلزمات المكتب])","v":{"v":572,"d":"ر.س.‏ 572.00"}},{"$f":"SUBTOTAL(109,ملخص_المصروفات[الكهرباء])","v":{"v":159,"d":"ر.س.‏ 159.00"}},{"$f":"SUBTOTAL(109,ملخص_المصروفات[الرهن])","v":{"v":4899,"d":"ر.س.‏ 4,899.00"}},{"$f":"SUBTOTAL(109,ملخص_المصروفات[الهاتف])","v":{"v":191,"d":"ر.س.‏ 191.00"}},{"$f":"SUBTOTAL(109,ملخص_المصروفات[‏‏فارغ 1])","v":0},{"$f":"SUBTOTAL(109,ملخص_المصروفات[‏‏فارغ 2])","v":0},{"$f":"SUBTOTAL(109,ملخص_المصروفات[‏‏فارغ 3])","v":0},{"$f":"SUBTOTAL(109,ملخص_المصروفات[فارغ 4])","v":0}]

{"sheet":"دفتر يومية المصروفات","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"دفتر يومية المصروفات"]
[null,"التاريخ","الرقم","الوصف","الفئة","المبلغ"]
[null,{"$f":"TODAY()-70","v":"2018-04-04"},"100","Woodgrove Bank","الرهن",{"v":1200,"d":"ر.س.‏ 1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-09"},101,"City Power & Light","الكهرباء",{"v":85,"d":"ر.س.‏ 85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-14"},102,"Humongous Insurance","تأمين السيارة",{"v":100,"d":"ر.س.‏ 100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-19"},103,"Woodgrove Bank","الرهن",{"v":1200,"d":"ر.س.‏ 1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-24"},104,"City Power & Light","الرهن",{"v":99,"d":"ر.س.‏ 99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-29"},105,"شركة الهاتف","الهاتف",{"v":68,"d":"ر.س.‏ 68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-04"},106,"Humongous Insurance","تأمين السيارة",{"v":100,"d":"ر.س.‏ 100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-09"},107,".Litware, Inc","مستلزمات المكتب",{"v":345,"d":"ر.س.‏ 345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-14"},110,"Woodgrove Bank","الرهن",{"v":1200,"d":"ر.س.‏ 1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-19"},111,"City Power & Light","الكهرباء",{"v":74,"d":"ر.س.‏ 74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-24"},108,"شركة الهاتف","الهاتف",{"v":123,"d":"ر.س.‏ 123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-29"},109,".Litware, Inc","مستلزمات المكتب",{"v":99,"d":"ر.س.‏ 99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-03"},112,"Humongous Insurance","تأمين السيارة",{"v":100,"d":"ر.س.‏ 100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-08"},113,"Woodgrove Bank","الرهن",{"v":1200,"d":"ر.س.‏ 1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-13"},114,".Litware, Inc","مستلزمات المكتب",{"v":128,"d":"ر.س.‏ 128.00"}]
[null,"الإجماليات",{"$nulls":3},{"$f":"SUBTOTAL(109,السجل[المبلغ])","v":{"v":6121,"d":"ر.س.‏ 6,121.00"}}]