{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["صافي الثروة الشخصية","الأصول","الديون"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"صافي الثروة الشخصية","index":0,"n_rows":21,"n_cols":25,"rows_kept":21,"merged":[[3,2,4,7]]}
[{"$nulls":14}," "]
[{"$nulls":16},"النقد والنقد المعادل",{"$f":"SUMIF(TBL_Assets[الفئة],'صافي الثروة الشخصية'!Q2,TBL_Assets[القيمة])+ROW(Q2)/10000","v":42500.0002},{"$f":"_xlfn.RANK.EQ(R2,$R$2:$R$6,0)","v":5},null,{"$f":"INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),1)","v":"النقد والنقد المعادل"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),2),2)","v":42500},null,"إجمالي الأصول",{"$f":"SUM(TBL_Assets[القيمة])","v":1923500}]
[null,null," صافي الثروة الشخصية",{"$nulls":13},"خصائص",{"$f":"SUMIF(TBL_Assets[الفئة],'صافي الثروة الشخصية'!Q3,TBL_Assets[القيمة])+ROW(Q3)/10000","v":1205000.0003},{"$f":"_xlfn.RANK.EQ(R3,$R$2:$R$6,0)","v":1},null,{"$f":"INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),1)","v":"مدخرات التقاعد"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),2),2)","v":98000},null,"إجمالي الديون",{"$f":"SUM(TBL_Debts[القيمة])","v":652500}]
[null,null,{"$f":"F6-F8","v":{"v":1271000,"d":"ر.س.‏ 1,271,000"}},{"$nulls":6},"الأصول/الديون",{"$nulls":6},"الاستثمارات",{"$f":"SUMIF(TBL_Assets[الفئة],'صافي الثروة الشخصية'!Q4,TBL_Assets[القيمة])+ROW(Q4)/10000","v":475000.0004},{"$f":"_xlfn.RANK.EQ(R4,$R$2:$R$6,0)","v":2},null,{"$f":"INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),1)","v":"التأمين على الحياة"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),2),2)","v":103000}]
[{"$nulls":16},"مدخرات التقاعد",{"$f":"SUMIF(TBL_Assets[الفئة],'صافي الثروة الشخصية'!Q5,TBL_Assets[القيمة])+ROW(Q5)/10000","v":98000.0005},{"$f":"_xlfn.RANK.EQ(R5,$R$2:$R$6,0)","v":4},null,{"$f":"INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),1)","v":"الاستثمارات"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),2),2)","v":475000}]
[{"$nulls":4},"إجمالي الأصول",{"$f":"SUM(TBL_Assets[القيمة])","v":{"v":1923500,"d":"ر.س.‏ 1,923,500"}},{"$nulls":10},"التأمين على الحياة",{"$f":"SUMIF(TBL_Assets[الفئة],'صافي الثروة الشخصية'!Q6,TBL_Assets[القيمة])+ROW(Q6)/10000","v":103000.0006},{"$f":"_xlfn.RANK.EQ(R6,$R$2:$R$6,0)","v":3},null,{"$f":"INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),1)","v":"خصائص"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),2),2)","v":1205000}]
[]
[{"$nulls":4},"إجمالي الديون",{"$f":"SUM(TBL_Debts[القيمة])","v":{"v":652500,"d":"ر.س.‏ 652,500"}}]
[]
[]
[]
[{"$nulls":3},"ملخص مخطط الأصول"]
[{"$nulls":10},{"$f":"U6","v":"خصائص"},{"$f":"V6","v":{"v":1205000,"d":"ر.س.‏ 1,205,000"}}]
[]
[{"$nulls":10},{"$f":"U5","v":"الاستثمارات"},{"$f":"V5","v":{"v":475000,"d":"ر.س.‏ 475,000"}}]
[]
[{"$nulls":10},{"$f":"U4","v":"التأمين على الحياة"},{"$f":"V4","v":{"v":103000,"d":"ر.س.‏ 103,000"}}]
[]
[{"$nulls":10},{"$f":"U3","v":"مدخرات التقاعد"},{"$f":"V3","v":{"v":98000,"d":"ر.س.‏ 98,000"}}]
[]
[{"$nulls":10},{"$f":"U2","v":"النقد والنقد المعادل"},{"$f":"V2","v":{"v":42500,"d":"ر.س.‏ 42,500"}}]

{"sheet":"الأصول","index":1,"n_rows":25,"n_cols":5,"rows_kept":25}
[{"$nulls":4}," "]
[null,"الأصول"]
[]
[null,"الفئة","العنصر","القيمة"]
[null,"خصائص","المنزل",{"v":560000,"d":"ر.س.‏ 560,000.00"}]
[null,"خصائص","أخرى",{"v":255000,"d":"ر.س.‏ 255,000.00"}]
[null,"مدخرات التقاعد","حسابات التقاعد",{"v":98000,"d":"ر.س.‏ 98,000.00"}]
[null,"الاستثمارات","الأسهم",{"v":53000,"d":"ر.س.‏ 53,000.00"}]
[null,"الاستثمارات","السندات",{"v":25000,"d":"ر.س.‏ 25,000.00"}]
[null,"الاستثمارات","صناديق الاستثمار",{"v":33000,"d":"ر.س.‏ 33,000.00"}]
[null,"الاستثمارات","الأقراص المضغوطة",{"v":74000,"d":"ر.س.‏ 74,000.00"}]
[null,"الاستثمارات","السبائك الذهبية",{"v":20000,"d":"ر.س.‏ 20,000.00"}]
[null,"الاستثمارات","صناديق الائتمان",{"v":250000,"d":"ر.س.‏ 250,000.00"}]
[null,"التأمين على الحياة","حساب الادخار الصحي",{"v":18000,"d":"ر.س.‏ 18,000.00"}]
[null,"التأمين على الحياة","قيمة اسمية لبوليصة التأمين على الحياة",{"v":85000,"d":"ر.س.‏ 85,000.00"}]
[null,"الاستثمارات","أخرى",{"v":20000,"d":"ر.س.‏ 20,000.00"}]
[null,"النقد والنقد المعادل","حسابات الشيكات",{"v":35500,"d":"ر.س.‏ 35,500.00"}]
[null,"النقد والنقد المعادل","حسابات الادخار",{"v":5000,"d":"ر.س.‏ 5,000.00"}]
[null,"النقد والنقد المعادل","أخرى",{"v":2000,"d":"ر.س.‏ 2,000.00"}]
[null,"خصائص","السيارات",{"v":55000,"d":"ر.س.‏ 55,000.00"}]
[null,"خصائص","المركبات الأخرى",{"v":85000,"d":"ر.س.‏ 85,000.00"}]
[null,"خصائص","الأثاث",{"v":100000,"d":"ر.س.‏ 100,000.00"}]
[null,"خصائص","المقتنيات",{"v":50000,"d":"ر.س.‏ 50,000.00"}]
[null,"خصائص","المجوهرات",{"v":60000,"d":"ر.س.‏ 60,000.00"}]
[null,"خصائص","السلع الترفيهية الأخرى",{"v":40000,"d":"ر.س.‏ 40,000.00"}]

{"sheet":"الديون","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[{"$nulls":3}," "]
[null,"الديون"]
[]
[null,"الفئة","القيمة"]
[null,"القروض العقارية",{"v":400000,"d":"ر.س.‏ 400,000.00"}]
[null,"قروض الأصول العقارية",{"v":50000,"d":"ر.س.‏ 50,000.00"}]
[null,"قروض السيارات",{"v":30000,"d":"ر.س.‏ 30,000.00"}]
[null,"القروض الشخصية",{"v":12500,"d":"ر.س.‏ 12,500.00"}]
[null,"بطاقات الائتمان",{"v":65000,"d":"ر.س.‏ 65,000.00"}]
[null,"قروض الطلاب",{"v":10000,"d":"ر.س.‏ 10,000.00"}]
[null,"قروض للمشاريع الاستثمارية",{"v":20000,"d":"ر.س.‏ 20,000.00"}]
[null,"قروض التأمين على الحياة",{"v":5000,"d":"ر.س.‏ 5,000.00"}]
[null,"قروض التقسيط الأخرى",{"v":10000,"d":"ر.س.‏ 10,000.00"}]
[null,"الديون الأخرى",{"v":50000,"d":"ر.س.‏ 50,000.00"}]