{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["المقسطون"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":84,"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":"المقسطون","index":0,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[9,10,9,12],[10,10,10,12],[15,8,15,9],[16,5,16,6],[22,2,22,5],[16,9,16,10],[17,9,17,10],[22,8,22,11]]}
[]
[null,null,null,null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2021-03-20"}]
[null,null,"ملف العميــل",2400,"الاســم :",{"$f":"VLOOKUP(D3,B26:K61,2,0)","v":100}]
[null,"نظـام الخصــم :"]
[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,null,null,"حساب نســبة التقسـيط :"]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D3,B26:K61,6,0)","v":2000},null,null,null,null,null,null,null,null,null,"2017-12-01"]
[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":34000},null,"المدة",{"$f":"(D7-D8)/D9","v":35},null,"السعر","الاشهر",null,null,null,{"$f":"TEXT(N9,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2017/12/01"}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D3,B26:K61,7,0)","v":"2019-11-01"},null,"الربح كامل",{"$f":"D7-D6","v":20000},null,50000,{"$f":"VLOOKUP(D3,B26:K61,3,1)","v":35},null,null,null,{"$f":"TEXT(N9,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1439/03/13"}]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D3,B26:K61,8,0)","v":"2022-08-01"},null,"الربح الشهري",{"$f":"G11/G10","v":571.42857142857144},null,"الزيادة  ",{"$f":"SUM(I11*(J11%+5%))","v":20000}]
[null,null,"الأشهر المسددة",{"$f":"(D10/D9)","v":17},null,"النسبة ",{"$f":"(G11/(D6-D8))*100","v":40},null,"بعد الزيادة",{"$f":"SUM(I11+J12)","v":70000}]
[null,null,"الأشهر المتبقية",{"$f":"D16/D9","v":18},null,"النسبة السنوية",{"$f":"(G13/G10)*12","v":13.714285714285714},null,"القسط الشهري",{"$f":"SUM(J13/J11)","v":2000},null,null,"1441/03/4",{"$f":"ConvertDate(M14)","v":"2019/11/01"}]
[null,null,null,null,null,"النسبة الشهرية",{"$f":"G13/G10","v":1.1428571428571428},null,null,null,null,null,"1444/03/06",{"$f":"ConvertDate(M15)","v":"2022/10/01"}]
[null,null,"الباقي من المبلغ",{"$f":"D7-D10","v":36000},null,null,null,null,"التاريخ الميلادي والتاريخ الهجري :"]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":6142.1800947867287},null,null,null,null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,"المطلوب",{"$f":"D16-D17","v":29857.81990521327},null,null,null,null,{"$f":"D3","v":2400},{"$f":"F3","v":100},null,{"$f":"G10","v":35},"2019-11-01",{"$f":"EDATE(M18,L18)","v":"2022-10-01"}]
[]
[]
[]
[]
[null,null,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )",null,null,null,null,null,null,null,null,null,{"$f":"D11","v":"2019-11-01"},{"$f":"EDATE(M23,L18)","v":"2022-10-01"}]
[]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد","حـالة العقـد"]
[null,100,100,40,32000,46400,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":"2011-12-20"},{"$f":"SUM(E26*(D26%+5%))","v":14400},0,{"$f":"IFERROR(IF(TODAY()=I26,\"العقد انتهى اليوم\",IF(TODAY()>I26,\"العقـد منتهى\",IF(TODAY()<H26,\"لم يتم تداولة\",\"العقـد سارى\"))),\"\")","v":"العقـد منتهى"},null,null,{"$f":"IF(M26,\"سداد مبكر\",M26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2300,100,35,50000,{"$f":"E48+J48","v":70000},{"$f":"F48/D48","v":2000},"2018-04-10","2021-01-08",20000,0,{"$f":"IFERROR(IF(TODAY()=I48,\"العقد انتهى اليوم\",IF(TODAY()>I48,\"العقـد منتهى\",IF(TODAY()<H48,\"لم يتم تداولة\",\"العقـد سارى\"))),\"\")","v":"العقـد منتهى"},"2019-02-07",39889,{"$f":"IF(M48,\"سداد مبكر\",M48)","v":"سداد مبكر"}]
[null,2400,100,35,50000,{"$f":"E49+J49","v":70000},{"$f":"F49/D49","v":2000},"2019-11-01","2022-08-01",20000,{"$f":"G49","v":2000},{"$f":"IFERROR(IF(TODAY()=I49,\"العقد انتهى اليوم\",IF(TODAY()>I49,\"العقـد منتهى\",IF(TODAY()<H49,\"لم يتم تداولة\",\"العقـد سارى\"))),\"\")","v":"العقـد سارى"},null,null,0]
[null,2500,100,35,50000,{"$f":"E50+J50","v":70000},2000,"2020-09-25","2023-06-26",20000,{"$f":"G50","v":2000},"العقـد سارى",null,null,0]
[null,2600,100,35,50000,{"$f":"E51+J51","v":70000},{"$f":"F51/D51","v":2000},"2019-11-01",{"$f":"MID(TEXT(H51,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H51+ROUND((D51-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H51+ROUND((D51-1)*354.367056/12,0)","v":"2022-08-01"},{"$f":"SUM(E51*(D51%+5%))","v":20000},{"$f":"G51","v":2000},{"$f":"IFERROR(IF(TODAY()=I51,\"العقد انتهى اليوم\",IF(TODAY()>I51,\"العقـد منتهى\",IF(TODAY()<H51,\"لم يتم تداولة\",\"العقـد سارى\"))),\"\")","v":"العقـد سارى"},null,null,0]
[null,null,null,null,null,null,{"$f":"F52/40","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E26:E61)","v":232000},{"$f":"SUM(F26:F61)","v":326400},null,null,null,{"$f":"SUM(J26:J61)","v":94400},{"$f":"SUM(K26:K61)","v":6000}]