{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المقسطون"," تسديد عميل"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":128,"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":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,3,3,7],[1,5,1,7],[23,12,23,13],[4,11,5,13],[4,8,5,9],[14,9,14,10],[5,5,5,6],[7,5,7,6],[23,2,23,4],[4,0,5,2],[13,9,13,10],[16,12,16,13],[17,12,17,13],[11,8,12,9],[15,8,15,11]]}
[]
[null,null,"ملف العميــل",100,"الاســم ",{"$f":"VLOOKUP(D2,B27:K62,2,0)","v":"عميل رقم 100"},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-10-29"}]
[]
[null,null,"تقيـيم العميل"]
["نظـام الخصــم ",null,null,null,null,null,null,null,"حساب نســبة التقسـيط "]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D2,B27:K62,4,0)","v":35000},null,null,null,null,"السعر","الاشهر"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D2,B27:K62,5,0)","v":50750},"موديلها :",null,null,null,35000,40]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I8*(J8%+5%))","v":15750}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D2,B27:K62,6,0)","v":1269},null,null,null,null,"بعد الزيادة",{"$f":"SUM(I8+J9)","v":50750}]
[null,null,"ماتم سداده من المبلغ",{"$f":"IF($D$12>$K$2,0,IF($D$13<$K$2,$D$8,(SUM(DATEDIF($D$12,$K$2,\"Y\")*12)+(DATEDIF($D$12,$K$2,\"ym\"))+(IF(DATEDIF($D$12,$K$2,\"md\")<>0,1,0)))*D10))","v":50750},null,null,null,null,"القسط الشهري",{"$f":"SUM(J10/J8)","v":1268.75}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D2,B27:K62,7,0)","v":"2008-10-25"},null,null,null,null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D2,B27:K62,8,0)","v":"2011-12-20"},null,"المدة",{"$f":"(D8-D9)/D10","v":39.992119779353821}]
[null,null,"الأشهر المسددة",{"$f":"(D11/D10)","v":39.992119779353821},null,"الربح كامل",{"$f":"D8-D7","v":15750},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,"الأشهر المتبقية",{"$f":"D17/D10","v":0},null,"الربح الشهري",{"$f":"G14/G13","v":393.82758620689657},null,{"$f":"D2","v":100},{"$f":"F2","v":"عميل رقم 100"},null,{"$f":"G13","v":39.992119779353821},{"$f":"D12","v":"2008-10-25"},{"$f":"D13","v":"2011-12-20"}]
[null,null,null,null,null,"النسبة ",{"$f":"(G14/(D7-D9))*100","v":45},null,"حالة الاشهر وقيمة العقد",null,null,null,{"$f":"TEXT(M15,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2008/10/25"},{"$f":"EDATE(M16,L15)","v":"2012-01-25"}]
[null,null,"الباقي من المبلغ",{"$f":"D8-D11","v":0},null,"النسبة السنوية",{"$f":"(G16/G13)*12","v":13.502660098522167}]
[null,null,"الخصم",{"$f":"((D17*G17%)*(D15/12))/(1+((G17%)*(D15/12)))","v":0},null,"النسبة الشهرية",{"$f":"G16/G13","v":1.1252216748768473}]
[null,null,"المطلوب",{"$f":"D17-D18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D5,B28:L63,11,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"VLOOKUP(E7,C30:M65,11,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"VLOOKUP(E8,C31:M66,11,0)","v":{"$error":"#N/A"}}]
[null,null,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"رقم الصف","رقم العامود"]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد",4,4]
[null,100,"عميل رقم 100",40,35000,50750,1269,"2008-10-25",{"$f":"MID(TEXT(H27,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H27+ROUND((D27-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H27+ROUND((D27-1)*354.367056/12,0)","v":"2011-12-20"},{"$f":"SUM(E27*(D27%+5%))","v":15750},0,{"$f":"IFERROR(IF(AND(M27<>\"\",M27<I27),\"سداد مبكر\",IF(TODAY()=I27,\"العقد انتهى اليوم\",IF(TODAY()>I27,\"العقـد منتهى\",IF(TODAY()<H27,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E27:E62)","v":35000},{"$f":"SUM(F27:F62)","v":50750},null,null,null,{"$f":"SUM(J27:J62)","v":15750},{"$f":"SUM(K27:K62)","v":0}]

{"sheet":" تسديد عميل","index":1,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[21,9,21,12],[34,8,34,10],[48,8,48,10],[15,4,16,5],[19,9,19,12],[20,9,20,12]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-10-29"}]
[null,"ملف العميــل",100,"الاســـــم ",{"$f":"VLOOKUP(' تسديد عميل'!C6,المقسطون!B26:I61,2,0)","v":"عميل رقم 100"}]
[]
[null,null,null,"مدة القرض (بالاشهر)",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,3,0)","v":40},null,"القسـط الشهري",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,6,0)","v":1269}]
[null,null,null,"تاريـخ بدايـة القـرض",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,7,0)","v":"2008-10-25"},null,"الســعر النقـدي ",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,4,0)","v":35000}]
[null,null,null,"تاريـخ نهايـة القـرض",{"$f":"TEXT(E9+((E8-1)*29.5),\"B2yyyy/mm/\")&TEXT(E9,\"B2dd\")","v":"1433/01/25"},null,"الربــــــــــــح ",{"$f":"VLOOKUP(C6,المقسطون!B26:K61,9,0)","v":15750}]
[null,null,null,"حــــــالة العقـــــــد",{"$f":"VLOOKUP(C6,المقسطون!B27:N62,11,0)","v":"العقـد منتهى"},null,"قيمــة القــرض",{"$f":"VLOOKUP(C6,المقسطون!B26:I61,5,0)","v":50750}]
[null,null,null,"نسبة السداد بـ  %",{"$f":"H12/H11","v":1},null,"المبالغ المســددة",{"$f":"SUM(H19:H58)","v":50750}]
[null,null,null,null,null,null,"المبالغ  المتبيقية",{"$f":"SUM(H11-H12)","v":0}]
[null,null,null,null,null,null,"الأشهر المسددة",{"$f":"(H12/H8)","v":39.992119779353821}]
[null,null,null,null,null,null,"الأشهر المتبقية",{"$f":"H13/H8","v":0}]
[null,null,null,null,"حركة تسديد عميل"]
[]
[null,null,null,"الشهــر","تاريخ التحصيل","رصيد القرض","القسط","التسديدات"]
[null,null,null,{"$f":"IF(ROW()-18>$E$8,\"\",ROW()-18)","v":1},{"$f":"IF(D19=\"\",\"\",TEXT($E$9+((D19-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":"1429/10/25"},{"$f":"H11","v":50750},{"$f":"IF(E19=\"\",\"\",IF($H$11=\"\",\"\",$H$11/$E$8))","v":1268.75},{"$f":"IF(D19=\"\",\"\",IF(TODAY()>=h2g(E19),G19,\"\"))","v":1268.75}]
[null,null,null,2,{"$f":"IF(D20=\"\",\"\",TEXT($E$9+((D20-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":"1429/11/25"},{"$f":"IF(E20=\"\",\"\",F19-G20)","v":49481.25},1268.75,{"$f":"IF(D20=\"\",\"\",IF(TODAY()>=h2g(E20),G20,\"\"))","v":1268.75},null,"اريد الاثنى عشر أولى بدل القسط 1269 يكون 1000"]
[null,null,null,3,"1429/12/25",{"$f":"IF(E21=\"\",\"\",F20-G21)","v":48212.5},1268.75,{"$f":"IF(D21=\"\",\"\",IF(TODAY()>=h2g(E21),G21,\"\"))","v":1268.75},null,"ومن شهر13 الى شهر22 يكون القسط ١٥٣٨ بمعنى القسط 1269+269"]
[null,null,null,4,{"$f":"IF(D22=\"\",\"\",TEXT($E$9+((D22-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":"1430/01/25"},46943.75,1268.75,{"$f":"IF(D22=\"\",\"\",IF(TODAY()>=h2g(E22),G22,\"\"))","v":1268.75},null,"ومن القسط 23 الى نهاية الأقساط يكون القسط 1296"]
[null,null,null,5,"1430/02/25",45675,1268.75,{"$f":"IF(D23=\"\",\"\",IF(TODAY()>=h2g(E23),G23,\"\"))","v":1268.75}]
[null,null,null,6,"1430/03/25",44406.25,1268.75,{"$f":"IF(D24=\"\",\"\",IF(TODAY()>=h2g(E24),G24,\"\"))","v":1268.75}]
[null,null,null,7,"1430/04/25",43137.5,1268.75,{"$f":"IF(D25=\"\",\"\",IF(TODAY()>=h2g(E25),G25,\"\"))","v":1268.75}]
[null,null,null,8,"1430/05/25",41868.75,1268.75,{"$f":"IF(D26=\"\",\"\",IF(TODAY()>=h2g(E26),G26,\"\"))","v":1268.75}]
[null,null,null,9,"1430/06/25",40600,1268.75,{"$f":"IF(D27=\"\",\"\",IF(TODAY()>=h2g(E27),G27,\"\"))","v":1268.75}]
[null,null,null,10,"1430/07/25",39331.25,1268.75,{"$f":"IF(D28=\"\",\"\",IF(TODAY()>=h2g(E28),G28,\"\"))","v":1268.75}]
[null,null,null,11,"1430/08/25",38062.5,1268.75,{"$f":"IF(D29=\"\",\"\",IF(TODAY()>=h2g(E29),G29,\"\"))","v":1268.75}]
[null,null,null,12,"1430/09/25",36793.75,1268.75,{"$f":"IF(D30=\"\",\"\",IF(TODAY()>=h2g(E30),G30,\"\"))","v":1268.75}]
[null,null,null,13,"1430/10/25",35525,1268.75,{"$f":"IF(D31=\"\",\"\",IF(TODAY()>=h2g(E31),G31,\"\"))","v":1268.75}]
[null,null,null,14,"1430/11/25",34256.25,1268.75,{"$f":"IF(D32=\"\",\"\",IF(TODAY()>=h2g(E32),G32,\"\"))","v":1268.75}]
[null,null,null,15,"1430/12/25",32987.5,1268.75,{"$f":"IF(D33=\"\",\"\",IF(TODAY()>=h2g(E33),G33,\"\"))","v":1268.75}]
[null,null,null,16,"1431/01/25",31718.75,1268.75,{"$f":"IF(D34=\"\",\"\",IF(TODAY()>=h2g(E34),G34,\"\"))","v":1268.75}]
[null,null,null,17,"1431/02/25",30450,1268.75,{"$f":"IF(D35=\"\",\"\",IF(TODAY()>=h2g(E35),G35,\"\"))","v":1268.75},"يكون القسط ١٥٣٨"]
[null,null,null,18,"1431/03/25",29181.25,1268.75,{"$f":"IF(D36=\"\",\"\",IF(TODAY()>=h2g(E36),G36,\"\"))","v":1268.75}]
[null,null,null,19,"1431/04/25",27912.5,1268.75,{"$f":"IF(D37=\"\",\"\",IF(TODAY()>=h2g(E37),G37,\"\"))","v":1268.75}]
[null,null,null,20,"1431/05/25",26643.75,1268.75,{"$f":"IF(D38=\"\",\"\",IF(TODAY()>=h2g(E38),G38,\"\"))","v":1268.75}]
[null,null,null,21,"1431/06/25",25375,1268.75,{"$f":"IF(D39=\"\",\"\",IF(TODAY()>=h2g(E39),G39,\"\"))","v":1268.75}]
[null,null,null,22,"1431/07/25",24106.25,1268.75,{"$f":"IF(D40=\"\",\"\",IF(TODAY()>=h2g(E40),G40,\"\"))","v":1268.75}]
[null,null,null,23,"1431/08/25",22837.5,1268.75,{"$f":"IF(D41=\"\",\"\",IF(TODAY()>=h2g(E41),G41,\"\"))","v":1268.75}]
[null,null,null,24,"1431/09/25",21568.75,1268.75,{"$f":"IF(D42=\"\",\"\",IF(TODAY()>=h2g(E42),G42,\"\"))","v":1268.75}]
[null,null,null,25,"1431/10/25",20300,1268.75,{"$f":"IF(D43=\"\",\"\",IF(TODAY()>=h2g(E43),G43,\"\"))","v":1268.75}]
[null,null,null,26,"1431/11/25",19031.25,1268.75,{"$f":"IF(D44=\"\",\"\",IF(TODAY()>=h2g(E44),G44,\"\"))","v":1268.75}]
[null,null,null,27,"1431/12/25",17762.5,1268.75,{"$f":"IF(D45=\"\",\"\",IF(TODAY()>=h2g(E45),G45,\"\"))","v":1268.75}]
[null,null,null,28,"1432/01/25",16493.75,1268.75,{"$f":"IF(D46=\"\",\"\",IF(TODAY()>=h2g(E46),G46,\"\"))","v":1268.75}]
[null,null,null,29,"1432/02/25",15225,1268.75,{"$f":"IF(D47=\"\",\"\",IF(TODAY()>=h2g(E47),G47,\"\"))","v":1268.75}]
[null,null,null,30,"1432/03/25",13956.25,1268.75,{"$f":"IF(D48=\"\",\"\",IF(TODAY()>=h2g(E48),G48,\"\"))","v":1268.75}]
[null,null,null,31,"1432/04/25",12687.5,1268.75,{"$f":"IF(D49=\"\",\"\",IF(TODAY()>=h2g(E49),G49,\"\"))","v":1268.75},"يكون القسط 1269"]
[null,null,null,32,"1432/05/25",11418.75,1268.75,{"$f":"IF(D50=\"\",\"\",IF(TODAY()>=h2g(E50),G50,\"\"))","v":1268.75}]
[null,null,null,33,"1432/06/25",10150,1268.75,{"$f":"IF(D51=\"\",\"\",IF(TODAY()>=h2g(E51),G51,\"\"))","v":1268.75}]
[null,null,null,34,"1432/07/25",8881.25,1268.75,{"$f":"IF(D52=\"\",\"\",IF(TODAY()>=h2g(E52),G52,\"\"))","v":1268.75}]
[null,null,null,35,"1432/08/25",7612.5,1268.75,{"$f":"IF(D53=\"\",\"\",IF(TODAY()>=h2g(E53),G53,\"\"))","v":1268.75}]
[null,null,null,36,"1432/09/25",6343.75,1268.75,{"$f":"IF(D54=\"\",\"\",IF(TODAY()>=h2g(E54),G54,\"\"))","v":1268.75}]
[null,null,null,37,"1432/10/25",5075,1268.75,{"$f":"IF(D55=\"\",\"\",IF(TODAY()>=h2g(E55),G55,\"\"))","v":1268.75}]
[null,null,null,38,"1432/11/25",3806.25,1268.75,{"$f":"IF(D56=\"\",\"\",IF(TODAY()>=h2g(E56),G56,\"\"))","v":1268.75}]
[null,null,null,39,"1432/12/25",2537.5,1268.75,{"$f":"IF(D57=\"\",\"\",IF(TODAY()>=h2g(E57),G57,\"\"))","v":1268.75}]
[null,null,null,40,"1433/01/25",1268.75,1268.75,{"$f":"IF(D58=\"\",\"\",IF(TODAY()>=h2g(E58),G58,\"\"))","v":1268.75}]