{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["المقسطون (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":87,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"المقسطون (2)","index":0,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[17,12,17,13],[22,2,22,5],[22,12,22,13],[11,8,12,9],[13,9,13,10],[14,9,14,10],[15,8,15,11],[16,5,16,6],[16,12,16,13],[2,5,2,7],[3,0,4,2],[3,8,4,9],[3,11,4,13],[4,5,4,6],[6,5,6,6]]}
[]
[null,null,null,null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2021-07-23"}]
[null,null,"ملف العميــل",2500,"الاســم :",{"$f":"VLOOKUP(D3,B26:K61,2,0)","v":1}]
["نظـام الخصــم :"]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D3,B26:K61,4,0)","v":50000}]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D3,B26:K61,5,0)","v":70000},"موديلها :"]
[null,null,"المقدم",0]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D3,B26:K61,6,0)","v":2000}]
[null,null,"ماتم سداده من المبلغ",{"$f":"IF($D$11>$K$2,0,IF($D$12<$K$2,$D$7,(SUM(DATEDIF($D$11,$K$2,\"Y\")*12)+(DATEDIF($D$11,$K$2,\"ym\"))+(IF(DATEDIF($D$11,$K$2,\"md\")<>0,1,0)))*D9))","v":20000},null,"المدة",{"$f":"(D7-D8)/D9","v":35}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D3,B26:K61,7,0)","v":"2020-09-25"},null,"الربح كامل",{"$f":"D7-D6","v":20000}]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D3,B26:K61,8,0)","v":"2023-06-26"},null,"الربح الشهري",{"$f":"G11/G10","v":571.42857142857144},null,"التاريخ الميلادي والتاريخ الهجري :"]
[null,null,"الأشهر المسددة",{"$f":"(D10/D9)","v":10},null,"النسبة ",{"$f":"(G11/(D6-D8))*100","v":40}]
[null,null,"الأشهر المتبقية",{"$f":"D16/D9","v":25},null,"النسبة السنوية",{"$f":"(G13/G10)*12","v":13.714285714285714},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,null,null,null,"النسبة الشهرية",{"$f":"G13/G10","v":1.1428571428571428},null,{"$f":"D3","v":2500},{"$f":"F3","v":1},null,{"$f":"G10","v":35},{"$f":"D11","v":"2020-09-25"},{"$f":"D12","v":"2023-06-26"}]
[null,null,"الباقي من المبلغ",{"$f":"D7-D10","v":50000},null,null,null,null,"حالة الاشهر وقيمة العقد",null,null,null,"2019-11-01",{"$f":"EDATE(M16,L15)","v":"2022-10-01"}]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":11111.111111111111},null,null,null,null,"الأشهر المسددة",{"$f":"IF(DATEDIF(M15,NOW(),\"m\")+1>L15,L15,DATEDIF(M15,NOW(),\"m\")+1)","v":10},"المبــالغ المســدة",{"$f":"(J17*D9)","v":20000},"حـالة العقــد"]
[null,null,"المطلوب",{"$f":"D16-D17","v":38888.888888888891},null,null,null,null,"الأشهر المتبقية",{"$f":"L15-J17","v":25},"المبــالغ المتبـقية",{"$f":"(J18*D9)","v":50000},{"$f":"IFERROR(IF(M49,\"سداد مبكر\",IF(TODAY()=N15,\"العقد انتهى اليوم\",IF(TODAY()>N15,\"العقـد منتهى\",IF(TODAY()<M15,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد سارى"}]
[]
[]
[]
[]
[null,null,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )"]
[]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد"]
[null,100,1,0,0,0,1160,"2008-10-25",{"$f":"MID(TEXT(H26,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H26+ROUND((D26-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H26+ROUND((D26-1)*354.367056/12,0)","v":"2008-09-25"},{"$f":"SUM(E26*(D26%+5%))","v":0},0,{"$f":"IFERROR(IF(M26,\"سداد مبكر\",IF(TODAY()=I26,\"العقد انتهى اليوم\",IF(TODAY()>I26,\"العقـد منتهى\",IF(TODAY()<H26,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,200,1,0,0,0,1087,"2009-01-21","2008-12-23",0,0,{"$f":"IFERROR(IF(M27,\"سداد مبكر\",IF(TODAY()=I27,\"العقد انتهى اليوم\",IF(TODAY()>I27,\"العقـد منتهى\",IF(TODAY()<H27,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,300,1,0,0,0,1160,"2010-03-10","2010-02-09",0,0,"العقـد منتهى"]
[null,400,1,0,0,0,979,"2010-06-07","2010-05-08",0,0,"العقـد منتهى"]
[null,500,1,0,0,0,1088,"2010-11-01","2010-10-03",0,0,"العقـد منتهى"]
[null,600,1,0,0,0,5507,"2010-12-31","2010-12-01",0,0,"العقـد منتهى"]
[null,700,1,0,0,0,2118,"2011-01-30","2010-12-31",0,0,"العقـد منتهى"]
[null,800,1,0,0,0,2504,"2011-07-26","2011-06-26",0,0,"العقـد منتهى"]
[null,900,1,0,0,0,1450,"2011-07-26","2011-06-26",0,0,"العقـد منتهى"]
[null,1000,1,0,0,0,1450,"2011-07-26","2011-06-26",0,0,"العقـد منتهى"]
[null,1100,1,0,0,0,1450,"2011-08-24","2011-07-26",0,0,"العقـد منتهى"]
[null,1200,1,0,0,0,1450,"2011-08-24","2011-07-26",0,0,"العقـد منتهى"]
[null,1300,1,0,0,0,1921,"2011-11-21","2011-10-22",0,0,"العقـد منتهى"]
[null,1400,1,0,0,0,1559,"2012-02-17","2012-01-19",0,0,"العقـد منتهى"]
[null,1500,1,0,0,0,1523,"2012-03-18","2012-02-17",0,0,"العقـد منتهى"]
[null,1600,1,0,0,0,1269,"2014-06-23","2014-05-24",0,0,"العقـد منتهى"]
[null,1700,1,0,0,0,1269,"2014-10-19","2014-09-19",0,0,"العقـد منتهى"]
[null,1800,1,0,0,0,{"$f":"F43/D43","v":{"$error":"#DIV/0!"}},"2015-01-15","2014-12-17",0,0,"العقـد منتهى"]
[null,1900,1,0,0,0,{"$error":"#DIV/0!"},"2015-05-13","2015-04-14",0,0,"العقـد منتهى"]
[null,2000,1,0,0,0,{"$error":"#DIV/0!"},"2015-07-11","2015-06-12",0,0,"العقـد منتهى"]
[null,2100,1,0,0,0,{"$error":"#DIV/0!"},"2017-02-21","2017-01-23",0,0,"العقـد منتهى"]
[null,2200,1,40,40000,{"$f":"E47+J47","v":58000},1450,"2018-01-12","2021-03-08",18000,{"$f":"G47","v":1450},"العقـد منتهى"]
[null,2300,1,35,50000,{"$f":"E48+J48","v":70000},2000,"2018-04-10","2021-01-08",20000,0,"سداد مبكر","2019-02-07",39889]
[null,2400,1,35,50000,{"$f":"E49+J49","v":70000},2000,"2019-11-01","2022-08-01",20000,{"$f":"G49","v":2000},"العقـد سارى"]
[null,2500,1,35,50000,{"$f":"E50+J50","v":70000},2000,"2020-09-25",{"$f":"MID(TEXT(H50,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H50+ROUND((D50-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H50+ROUND((D50-1)*354.367056/12,0)","v":"2023-06-26"},20000,{"$f":"G50","v":2000},"العقـد سارى"]
[null,null,null,null,null,null,{"$f":"F51/40","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E26:E61)","v":190000},{"$f":"SUM(F26:F61)","v":268000},null,null,null,{"$f":"SUM(J26:J61)","v":78000},{"$f":"SUM(K26:K61)","v":5450}]