{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المقسطون","حركة تسديد عميل(2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":126,"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":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[22,2,22,5],[16,12,16,13],[13,9,13,10],[2,5,2,7],[4,5,4,6],[6,5,6,6],[16,5,16,6],[3,0,4,2],[22,12,22,13],[3,11,4,13],[3,8,4,9],[15,8,15,11],[17,12,17,13],[11,8,12,9],[14,9,14,10]]}
[]
[null,null,null,null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2021-07-31"}]
[null,null,"ملف العميــل",2300,"الاســم :",{"$f":"VLOOKUP(D3,B26:K61,2,0)","v":1}]
["نظـام الخصــم :",null,null,null,null,null,null,null,"حساب نســبة التقسـيط :",null,null,"نظام التحويل من تاريخ ميلادي لهجري :"]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D3,B26:K61,4,0)","v":45000},null,null,null,null,"السعر","الاشهر",null,"2021-03-27"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D3,B26:K61,5,0)","v":65250},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D3,B26:K61,3,1)","v":40},null,{"$f":"TEXT(L6,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2021/03/27"}]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I7*(J7%+5%))","v":22500},null,{"$f":"TEXT(L6,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1442/08/14"}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D3,B26:K61,6,0)","v":1631.25},null,null,null,null,"بعد الزيادة",{"$f":"SUM(I7+J8)","v":72500}]
[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":65250},null,"المدة",{"$f":"(D7-D8)/D9","v":40},null,"القسط الشهري",{"$f":"SUM(J9/J7)","v":1812.5}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D3,B26:K61,7,0)","v":"2018-04-10"},null,"الربح كامل",{"$f":"D7-D6","v":20250}]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D3,B26:K61,8,0)","v":"2021-06-05"},null,"الربح الشهري",{"$f":"G11/G10","v":506.25},null,"التاريخ الميلادي والتاريخ الهجري :"]
[null,null,"الأشهر المسددة",{"$f":"(D10/D9)","v":40},null,"النسبة ",{"$f":"(G11/(D6-D8))*100","v":45}]
[null,null,"الأشهر المتبقية",{"$f":"D16/D9","v":0},null,"النسبة السنوية",{"$f":"(G13/G10)*12","v":13.5},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,null,null,null,"النسبة الشهرية",{"$f":"G13/G10","v":1.125},null,{"$f":"D3","v":2300},{"$f":"F3","v":1},null,{"$f":"G10","v":40},{"$f":"D11","v":"2018-04-10"},{"$f":"D12","v":"2021-06-05"}]
[null,null,"الباقي من المبلغ",{"$f":"D7-D10","v":0},null,null,null,null,"حالة الاشهر وقيمة العقد",null,null,null,"2019-11-01",{"$f":"EDATE(M16,L15)","v":"2023-03-01"}]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":0},null,null,null,null,"الأشهر المسددة",{"$f":"IF(DATEDIF(M15,NOW(),\"m\")+1>L15,L15,DATEDIF(M15,NOW(),\"m\")+1)","v":40},"المبــالغ المســدة",{"$f":"(J17*D9)","v":65250},"حـالة العقــد"]
[null,null,"المطلوب",{"$f":"D16-D17","v":0},null,null,null,null,"الأشهر المتبقية",{"$f":"L15-J17","v":0},"المبــالغ المتبـقية",{"$f":"(J18*D9)","v":0},{"$f":"VLOOKUP(D3,B26:L61,11,0)","v":"سداد مبكر"}]
[]
[]
[]
[]
[null,null,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )"]
[]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد"]
[null,100,1,40,45000,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":20250},0,{"$f":"IFERROR(IF(AND(M26<>\"\",M26<I26),\"سداد مبكر\",IF(TODAY()=I26,\"العقد انتهى اليوم\",IF(TODAY()>I26,\"العقـد منتهى\",IF(TODAY()<H26,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,200,1,40,45000,43500,1087,"2009-01-21","2012-03-18",20250,0,{"$f":"IFERROR(IF(AND(M27<>\"\",M27<I27),\"سداد مبكر\",IF(TODAY()=I27,\"العقد انتهى اليوم\",IF(TODAY()>I27,\"العقـد منتهى\",IF(TODAY()<H27,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,300,1,40,45000,46400,1160,"2010-03-10","2013-05-05",20250,0,"العقـد منتهى"]
[null,400,1,40,45000,39160,979,"2010-06-07","2013-08-01",20250,0,"العقـد منتهى"]
[null,500,1,40,45000,43520,1088,"2010-11-01","2013-12-28",20250,0,"العقـد منتهى"]
[null,600,1,40,45000,69024,5507,"2010-12-31","2014-02-25",20250,0,"العقـد منتهى"]
[null,700,1,40,45000,38124,2118,"2011-01-30","2014-03-26",20250,0,"العقـد منتهى"]
[null,800,1,40,45000,57592,2504,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,900,1,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1000,1,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1100,1,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1200,1,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1300,1,40,45000,76850,1921,"2011-11-21","2015-01-15",20250,0,"العقـد منتهى"]
[null,1400,1,40,45000,62360,1559,"2012-02-17","2015-04-14",20250,0,"العقـد منتهى"]
[null,1500,1,40,45000,60900,1523,"2012-03-18","2015-05-13",20250,0,"العقـد منتهى"]
[null,1600,1,40,45000,50760,1269,"2014-06-23","2017-08-17",20250,0,"العقـد منتهى"]
[null,1700,1,40,45000,50760,1269,"2014-10-19","2017-12-13",20250,0,"العقـد منتهى"]
[null,1800,1,40,45000,53640,{"$f":"F43/D43","v":1341},"2015-01-15","2018-03-12",20250,0,"العقـد منتهى"]
[null,1900,1,40,45000,60920,1523,"2015-05-13","2018-07-08",20250,0,"العقـد منتهى"]
[null,2000,1,40,45000,60750,1518.75,"2015-07-11","2018-09-05",20250,0,"العقـد منتهى"]
[null,2100,1,40,45000,105624,2640.6,"2017-02-21","2020-04-18",20250,0,"العقـد منتهى"]
[null,2200,1,40,45000,{"$f":"E47+J47","v":65250},1631.25,"2018-01-12","2021-03-08",20250,0,"العقـد منتهى"]
[null,2300,1,40,45000,{"$f":"E48+J48","v":65250},1631.25,"2018-04-10","2021-06-05",20250,0,"سداد مبكر","2019-02-07",39889]
[null,2400,1,35,50000,{"$f":"E49+J49","v":70000},{"$f":"F49/D49","v":2000},"2019-11-01","2022-08-01",20000,{"$f":"G49","v":2000},"العقـد سارى"]
[null,2500,1,35,50000,{"$f":"E50+J50","v":70000},{"$f":"F50/D50","v":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"},{"$f":"SUM(E50*(D50%+5%))","v":20000},{"$f":"G50","v":2000},"العقـد سارى"]
[null,2600,1,35,50000,{"$f":"E51+J51","v":70000},2000,"2021-03-27",{"$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":"2023-12-26"},20000,{"$f":"G51","v":2000},"العقـد سارى"]
[null,null,null,null,null,null,{"$f":"F52/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,{"$f":"SUM(E26:E61)","v":1185000},{"$f":"SUM(F26:F61)","v":1538784},null,null,null,{"$f":"SUM(J26:J61)","v":525750},{"$f":"SUM(K26:K61)","v":6000}]

{"sheet":"حركة تسديد عميل(2)","index":1,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[15,1,16,2]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"TODAY()","v":"2021-07-31"}]
[null,"رقم الملف",2500,"القســـــــط ",{"$f":"VLOOKUP(C8,المقسطون!$B$25:$H$60,6,0)","v":2000}]
[null,null,null,"السعر النقدي ",{"$f":"VLOOKUP(C8,المقسطون!$B$25:$H$60,4,0)","v":50000}]
[null,"الاســـــم /",{"$f":"VLOOKUP('حركة تسديد عميل(2)'!C8,المقسطون!B25:I60,2,0)","v":1},"الربـــــــــح ",{"$f":"VLOOKUP(C8,المقسطون!B25:K60,9,0)","v":20000}]
[null,"مدة القرض (بالاشهر)",{"$f":"VLOOKUP(C8,المقسطون!$B$25:$H$60,3,0)","v":35},"قيمة القرض",{"$f":"VLOOKUP(C8,المقسطون!B25:I60,5,0)","v":70000}]
[null,"تاريخ بداية القرض",{"$f":"VLOOKUP(C8,المقسطون!$B$25:$H$60,7,0)","v":"2020-09-25"},"نسبة السداد بـ  %",{"$f":"E16/C15","v":0.56000000000000005}]
[null,"تاريخ نهاية القرض",{"$f":"TEXT(C12+((C11-1)*29.5),\"B2yyyy/mm/\")&TEXT(C12,\"B2dd\")","v":"1444/12/08"}]
[]
[null,"السعر النقدي ",{"$f":"E9","v":50000},"التســديدات",{"$f":"SUM(F19:F59)","v":22000}]
[null,"حركة تسديد عميل",null,"البـــاقي",{"$f":"SUM(C15-E15)","v":28000}]
[]
[null,"الشهــر","تاريخ التحصيل","رصيد القرض","القسط","التسديدات"]
[null,{"$f":"IF(ROW()-18>$C$11,\"\",ROW()-18)","v":1},{"$f":"IF(B19=\"\",\"\",TEXT($C$12+((B19-1)*29.5),\"B2yyyy/mm/\")&TEXT($C$12,\"B2dd\"))","v":"1442/02/08"},{"$f":"E11","v":70000},{"$f":"IF(C19=\"\",\"\",IF($E$11=\"\",\"\",$E$11/$C$11))","v":2000},{"$f":"IF(B19=\"\",\"\",IF(TODAY()>=h2g(C19),E19,\"\"))","v":2000}]
[null,2,{"$f":"IF(B20=\"\",\"\",TEXT($C$12+((B20-1)*29.5),\"B2yyyy/mm/\")&TEXT($C$12,\"B2dd\"))","v":"1442/03/08"},{"$f":"IF(C20=\"\",\"\",D19-E20)","v":68000},{"$f":"IF(C20=\"\",\"\",IF($E$11=\"\",\"\",$E$11/$C$11))","v":2000},{"$f":"IF(B20=\"\",\"\",IF(TODAY()>=h2g(C20),E20,\"\"))","v":2000}]
[null,3,"1442/04/08",{"$f":"IF(C21=\"\",\"\",D20-E21)","v":66000},2000,{"$f":"IF(B21=\"\",\"\",IF(TODAY()>=h2g(C21),E21,\"\"))","v":2000}]
[null,4,"1442/05/08",64000,2000,{"$f":"IF(B22=\"\",\"\",IF(TODAY()>=h2g(C22),E22,\"\"))","v":2000}]
[null,5,"1442/06/08",62000,2000,{"$f":"IF(B23=\"\",\"\",IF(TODAY()>=h2g(C23),E23,\"\"))","v":2000}]
[null,6,"1442/07/08",60000,2000,{"$f":"IF(B24=\"\",\"\",IF(TODAY()>=h2g(C24),E24,\"\"))","v":2000}]
[null,7,"1442/08/08",58000,2000,{"$f":"IF(B25=\"\",\"\",IF(TODAY()>=h2g(C25),E25,\"\"))","v":2000}]
[null,8,"1442/09/08",56000,2000,{"$f":"IF(B26=\"\",\"\",IF(TODAY()>=h2g(C26),E26,\"\"))","v":2000}]
[null,9,"1442/10/08",54000,2000,{"$f":"IF(B27=\"\",\"\",IF(TODAY()>=h2g(C27),E27,\"\"))","v":2000}]
[null,10,"1442/11/08",52000,2000,{"$f":"IF(B28=\"\",\"\",IF(TODAY()>=h2g(C28),E28,\"\"))","v":2000}]
[null,11,"1442/12/08",50000,2000,{"$f":"IF(B29=\"\",\"\",IF(TODAY()>=h2g(C29),E29,\"\"))","v":2000}]
[null,12,"1443/01/08",48000,2000,{"$f":"IF(B30=\"\",\"\",IF(TODAY()>=h2g(C30),E30,\"\"))","v":""}]
[null,13,"1443/02/08",46000,2000,{"$f":"IF(B31=\"\",\"\",IF(TODAY()>=h2g(C31),E31,\"\"))","v":""}]
[null,14,"1443/03/08",44000,2000,{"$f":"IF(B32=\"\",\"\",IF(TODAY()>=h2g(C32),E32,\"\"))","v":""}]
[null,15,"1443/04/08",42000,2000,{"$f":"IF(B33=\"\",\"\",IF(TODAY()>=h2g(C33),E33,\"\"))","v":""}]
[null,16,"1443/05/08",40000,2000,{"$f":"IF(B34=\"\",\"\",IF(TODAY()>=h2g(C34),E34,\"\"))","v":""}]
[null,17,"1443/06/08",38000,2000,{"$f":"IF(B35=\"\",\"\",IF(TODAY()>=h2g(C35),E35,\"\"))","v":""}]
[null,18,"1443/07/08",36000,2000,{"$f":"IF(B36=\"\",\"\",IF(TODAY()>=h2g(C36),E36,\"\"))","v":""}]
[null,19,"1443/08/08",34000,2000,{"$f":"IF(B37=\"\",\"\",IF(TODAY()>=h2g(C37),E37,\"\"))","v":""}]
[null,20,"1443/09/08",32000,2000,{"$f":"IF(B38=\"\",\"\",IF(TODAY()>=h2g(C38),E38,\"\"))","v":""}]
[null,21,"1443/10/08",30000,2000,{"$f":"IF(B39=\"\",\"\",IF(TODAY()>=h2g(C39),E39,\"\"))","v":""}]
[null,22,"1443/11/08",28000,2000,{"$f":"IF(B40=\"\",\"\",IF(TODAY()>=h2g(C40),E40,\"\"))","v":""}]
[null,23,"1443/12/08",26000,2000,{"$f":"IF(B41=\"\",\"\",IF(TODAY()>=h2g(C41),E41,\"\"))","v":""}]
[null,24,"1444/01/08",24000,2000,{"$f":"IF(B42=\"\",\"\",IF(TODAY()>=h2g(C42),E42,\"\"))","v":""}]
[null,25,"1444/02/08",22000,2000,{"$f":"IF(B43=\"\",\"\",IF(TODAY()>=h2g(C43),E43,\"\"))","v":""}]
[null,26,"1444/03/08",20000,2000,{"$f":"IF(B44=\"\",\"\",IF(TODAY()>=h2g(C44),E44,\"\"))","v":""}]
[null,27,"1444/04/08",18000,2000,{"$f":"IF(B45=\"\",\"\",IF(TODAY()>=h2g(C45),E45,\"\"))","v":""}]
[null,28,"1444/05/08",16000,2000,{"$f":"IF(B46=\"\",\"\",IF(TODAY()>=h2g(C46),E46,\"\"))","v":""}]
[null,29,"1444/06/08",14000,2000,{"$f":"IF(B47=\"\",\"\",IF(TODAY()>=h2g(C47),E47,\"\"))","v":""}]
[null,30,"1444/07/08",12000,2000,{"$f":"IF(B48=\"\",\"\",IF(TODAY()>=h2g(C48),E48,\"\"))","v":""}]
[null,31,"1444/08/08",10000,2000,{"$f":"IF(B49=\"\",\"\",IF(TODAY()>=h2g(C49),E49,\"\"))","v":""}]
[null,32,"1444/09/08",8000,2000,{"$f":"IF(B50=\"\",\"\",IF(TODAY()>=h2g(C50),E50,\"\"))","v":""}]
[null,33,"1444/10/08",6000,2000,{"$f":"IF(B51=\"\",\"\",IF(TODAY()>=h2g(C51),E51,\"\"))","v":""}]
[null,34,"1444/11/08",4000,2000,{"$f":"IF(B52=\"\",\"\",IF(TODAY()>=h2g(C52),E52,\"\"))","v":""}]
[null,35,"1444/12/08",2000,2000,{"$f":"IF(B53=\"\",\"\",IF(TODAY()>=h2g(C53),E53,\"\"))","v":""}]
[null,"","","",{"$f":"IF(C54=\"\",\"\",IF($E$14=\"\",\"\",$E$14/$C$11))","v":""},{"$f":"IF(B54=\"\",\"\",IF(TODAY()>=h2g(C54),E54,\"\"))","v":""}]
[null,"","","","",{"$f":"IF(B55=\"\",\"\",IF(TODAY()>=h2g(C55),E55,\"\"))","v":""}]
[null,"","","","",{"$f":"IF(B56=\"\",\"\",IF(TODAY()>=h2g(C56),E56,\"\"))","v":""}]
[null,"","","","",{"$f":"IF(B57=\"\",\"\",IF(TODAY()>=h2g(C57),E57,\"\"))","v":""}]
[null,"","","","",{"$f":"IF(B58=\"\",\"\",IF(TODAY()>=h2g(C58),E58,\"\"))","v":""}]
[null,{"$f":"IF(ROW()-18>$C$11,\"\",ROW()-18)","v":""},"","",{"$f":"IF(C59=\"\",\"\",IF($E$11=\"\",\"\",$E$11/$C$11))","v":""},{"$f":"IF(B59=\"\",\"\",IF(TODAY()>=h2g(C59),E59,\"\"))","v":""}]