{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["المقسطون","حركة تسديد عميل"," تسديد عميل","الاقساط والاشهر"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":210,"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":[[1,5,1,7],[22,12,22,13],[3,11,4,13],[3,8,4,9],[22,2,22,5],[13,9,13,10],[4,5,4,6],[6,5,6,6],[16,5,16,6],[3,0,4,2],[12,9,12,10],[15,12,15,13],[16,12,16,13],[10,8,11,9],[14,8,14,11]]}
[]
[null,null,"ملف العميــل",100,"الاســم ",{"$f":"VLOOKUP(D2,B26:K61,2,0)","v":100},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-02-05"}]
[]
["نظـام الخصــم ",null,null,null,null,null,null,null,"حساب نســبة التقسـيط ",null,null,"نظام تحويل التاريخ من هجري لميلادي "]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D2,B26:K61,4,0)","v":45000},null,null,null,null,"السعر","الاشهر",null,"بداية التسديد ","نهاية التسديد"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D2,B26:K61,5,0)","v":46400},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D2,B26:K61,3,1)","v":40},null,{"$f":"D11","v":"2008-10-25"},{"$f":"D12","v":"2011-12-20"}]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I7*(J7%+5%))","v":22500},null,{"$f":"TEXT(L7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2008-10-26"},{"$f":"TEXT(M7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2011-12-21"}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D2,B26:K61,6,0)","v":1160},null,null,null,null,"بعد الزيادة",{"$f":"SUM(I7+J8)","v":72500},null,{"$f":"TEXT(L7+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1429/10/26"},{"$f":"TEXT(M7+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1433/01/26"}]
[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":46400},null,"المدة",{"$f":"(D7-D8)/D9","v":40},null,"القسط الشهري",{"$f":"SUM(J9/J7)","v":1812.5}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D2,B26:K61,7,0)","v":"2008-10-25"},null,"الربح كامل",{"$f":"D7-D6","v":1400},null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D2,B26:K61,8,0)","v":"2011-12-20"},null,"الربح الشهري",{"$f":"G11/G10","v":35}]
[null,null,"الأشهر المسددة",{"$f":"(D10/D9)","v":40},null,"النسبة ",{"$f":"(G11/(D6-D8))*100","v":3.1111111111111112},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,"الأشهر المتبقية",{"$f":"D16/D9","v":0},null,"النسبة السنوية",{"$f":"(G13/G10)*12","v":0.93333333333333335},null,{"$f":"D2","v":100},{"$f":"F2","v":100},null,{"$f":"G10","v":40},{"$f":"D11","v":"2008-10-25"},{"$f":"D12","v":"2011-12-20"}]
[null,null,null,null,null,"النسبة الشهرية",{"$f":"G13/G10","v":7.7777777777777779E-2},null,"حالة الاشهر وقيمة العقد",null,null,null,{"$f":"TEXT(M14,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2008-10-26"},{"$f":"EDATE(M15,L14)","v":"2012-02-26"}]
[null,null,"الباقي من المبلغ",{"$f":"D7-D10","v":0},null,null,null,null,"الأشهر المسددة",{"$f":"'حركة تسديد عميل'!H7","v":40},"المبــالغ المســدة",{"$f":"(J16*D9)","v":46400},"نسبة السداد بـ  %"]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":0},null,null,null,null,"الأشهر المتبقية",{"$f":"L14-J16","v":0},"المبــالغ المتبـقية",{"$f":"(J17*D9)","v":0},{"$f":"L16/D7","v":1}]
[null,null,"المطلوب",{"$f":"D16-D17","v":0},null,null,null,null,"حـالة العقــد",{"$f":"VLOOKUP(D2,B26:N61,11,0)","v":"العقـد منتهى"},"مبلغ السداد المبكر",{"$f":"IF(J18=\"سداد مبكر\",INDEX(N26:N61,MATCH(J18,L26:L61,0)),\"\")","v":""},"تاريخ السداد المبكر",{"$f":"IF(J18=\"سداد مبكر\",INDEX(M26:M61,MATCH(J18,L26:L61,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D4,B27:L62,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"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )"]
[]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد"]
[null,100,100,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,null,null,null,null,null,{"$f":"F53/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,{"$f":"SUM(E26:E61)","v":45000},{"$f":"SUM(F26:F61)","v":46400},null,null,null,{"$f":"SUM(J26:J61)","v":20250},{"$f":"SUM(K26:K61)","v":0}]

{"sheet":"حركة تسديد عميل","index":1,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,3,1,5],[13,3,16,5]]}
[]
["ملف العميــل",100,"الاســم",{"$f":"VLOOKUP(B2,المقسطون!B25:I60,2,0)","v":100},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-02-05"}]
[]
[]
[null,"مدة العقد (بالاشهر)",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,3,0)","v":40},null,null,"حـالة العقــد",{"$f":"VLOOKUP(B2,المقسطون!B26:N61,11,0)","v":"العقـد منتهى"}]
[]
[null," بداية العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,7,0)","v":"2008-10-25"},null,null,null,"الأشهر المسددة",{"$f":"IF(COUNT(H19:H58)>C9,C9,COUNT(H19:H58))","v":40}]
[null,null,{"$f":"TEXT(C7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2008-10-26"},null,null,null,"الأشهر المتبقية",{"$f":"C5-H7","v":0}]
[null," نهاية العقد",{"$f":"TEXT(C7+((C5-1)*29.5),\"B2yyyy/mm/\")&TEXT(C7,\"B2dd\")","v":"1433/01/25"},"المتأخرات :",null,null,"المبــالغ المســدة",{"$f":"SUM(H19:H58)","v":46400}]
[null,null,{"$f":"ConvertDate(C9)","v":"2011/12/20"},null,null,null,"المبــالغ المتبـقية",{"$f":"-(H9-C14)","v":0}]
[null,"القســـــــط ",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,6,0)","v":1160},null,null,null,"نسبة السداد بـ  %",{"$f":"H9/C14","v":1}]
[null,"السعر النقدي ",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,4,0)","v":45000}]
[null,"الربـــــــــح ",{"$f":"VLOOKUP(B2,المقسطون!B26:N61,9,0)","v":20250},null,null,null,"الســداد المبكـر"]
[null,"قيمة العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,5,0)","v":46400},"حركة تسديد عميل",null,null,"تاريخ السداد المبكر",{"$f":"IF(G5=\"سداد مبكر\",INDEX(المقسطون!M26:M61,MATCH(G5,المقسطون!L26:L61,0)),\"\")","v":""}]
[]
[null,null,null,null,null,null,"قيمة السداد المبكر",{"$f":"IF(G5=\"سداد مبكر\",INDEX(المقسطون!N27:N62,MATCH(G5,المقسطون!L27:L62,0)),\"\")","v":""}]
[]
[null,null,"الشهــر"," التحصيل بالتاريخ ( هـ )"," التحصيل بالتاريخ ( م )","رصيد القرض","القسط","التسديدات","الأقساط المتأخرة"]
[null,null,{"$f":"IF(D19=\"\",\"\",ROW()-18)","v":1},{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1429/10/25"},{"$f":"IF(D19<>\"\",ConvertDate(D19),\"\")","v":"2008/10/25"},{"$f":"C14","v":46400},{"$f":"IF(D19=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":1160},{"$f":"IF(C19=\"\",\"\",IF(TODAY()>=h2g(D19),G19,\"\"))","v":1160}]
[null,null,{"$f":"IF(D20=\"\",\"\",ROW()-18)","v":2},{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1429/11/25"},{"$f":"IF(D20<>\"\",ConvertDate(D20),\"\")","v":"2008/11/23"},{"$f":"IF(D20=\"\",\"\",F19-G20)","v":45240},1160,{"$f":"IF(C20=\"\",\"\",IF(TODAY()>=h2g(D20),G20,\"\"))","v":1160}]
[null,null,3,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1429/12/25"},"2008/12/23",{"$f":"IF(D21=\"\",\"\",F20-G21)","v":44080},1160,{"$f":"IF(C21=\"\",\"\",IF(TODAY()>=h2g(D21),G21,\"\"))","v":1160}]
[null,null,4,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/01/25"},"2009/01/21",42920,1160,{"$f":"IF(C22=\"\",\"\",IF(TODAY()>=h2g(D22),G22,\"\"))","v":1160}]
[null,null,5,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/02/25"},"2009/02/20",41760,1160,{"$f":"IF(C23=\"\",\"\",IF(TODAY()>=h2g(D23),G23,\"\"))","v":1160}]
[null,null,6,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/03/25"},"2009/03/21",40600,1160,{"$f":"IF(C24=\"\",\"\",IF(TODAY()>=h2g(D24),G24,\"\"))","v":1160}]
[null,null,7,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/04/25"},"2009/04/20",39440,1160,{"$f":"IF(C25=\"\",\"\",IF(TODAY()>=h2g(D25),G25,\"\"))","v":1160}]
[null,null,8,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/05/25"},"2009/05/19",38280,1160,{"$f":"IF(C26=\"\",\"\",IF(TODAY()>=h2g(D26),G26,\"\"))","v":1160}]
[null,null,9,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/06/25"},"2009/06/18",37120,1160,{"$f":"IF(C27=\"\",\"\",IF(TODAY()>=h2g(D27),G27,\"\"))","v":1160}]
[null,null,10,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/07/25"},"2009/07/17",35960,1160,{"$f":"IF(C28=\"\",\"\",IF(TODAY()>=h2g(D28),G28,\"\"))","v":1160}]
[null,null,11,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/08/25"},"2009/08/16",34800,1160,{"$f":"IF(C29=\"\",\"\",IF(TODAY()>=h2g(D29),G29,\"\"))","v":1160}]
[null,null,12,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/09/25"},"2009/09/14",33640,1160,{"$f":"IF(C30=\"\",\"\",IF(TODAY()>=h2g(D30),G30,\"\"))","v":1160}]
[null,null,13,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/10/25"},"2009/10/14",32480,1160,{"$f":"IF(C31=\"\",\"\",IF(TODAY()>=h2g(D31),G31,\"\"))","v":1160}]
[null,null,14,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/11/25"},"2009/11/12",31320,1160,{"$f":"IF(C32=\"\",\"\",IF(TODAY()>=h2g(D32),G32,\"\"))","v":1160}]
[null,null,15,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1430/12/25"},"2009/12/12",30160,1160,{"$f":"IF(C33=\"\",\"\",IF(TODAY()>=h2g(D33),G33,\"\"))","v":1160}]
[null,null,16,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/01/25"},"2010/01/10",29000,1160,{"$f":"IF(C34=\"\",\"\",IF(TODAY()>=h2g(D34),G34,\"\"))","v":1160}]
[null,null,17,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/02/25"},"2010/02/09",27840,1160,{"$f":"IF(C35=\"\",\"\",IF(TODAY()>=h2g(D35),G35,\"\"))","v":1160}]
[null,null,18,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/03/25"},"2010/03/10",26680,1160,{"$f":"IF(C36=\"\",\"\",IF(TODAY()>=h2g(D36),G36,\"\"))","v":1160}]
[null,null,19,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/04/25"},"2010/04/09",25520,1160,{"$f":"IF(C37=\"\",\"\",IF(TODAY()>=h2g(D37),G37,\"\"))","v":1160}]
[null,null,20,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/05/25"},"2010/05/08",24360,1160,{"$f":"IF(C38=\"\",\"\",IF(TODAY()>=h2g(D38),G38,\"\"))","v":1160}]
[null,null,21,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/06/25"},"2010/06/07",23200,1160,{"$f":"IF(C39=\"\",\"\",IF(TODAY()>=h2g(D39),G39,\"\"))","v":1160}]
[null,null,22,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/07/25"},"2010/07/06",22040,1160,{"$f":"IF(C40=\"\",\"\",IF(TODAY()>=h2g(D40),G40,\"\"))","v":1160}]
[null,null,23,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/08/25"},"2010/08/05",20880,1160,{"$f":"IF(C41=\"\",\"\",IF(TODAY()>=h2g(D41),G41,\"\"))","v":1160}]
[null,null,24,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/09/25"},"2010/09/03",19720,1160,{"$f":"IF(C42=\"\",\"\",IF(TODAY()>=h2g(D42),G42,\"\"))","v":1160}]
[null,null,25,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/10/25"},"2010/10/03",18560,1160,{"$f":"IF(C43=\"\",\"\",IF(TODAY()>=h2g(D43),G43,\"\"))","v":1160}]
[null,null,26,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/11/25"},"2010/11/01",17400,1160,{"$f":"IF(C44=\"\",\"\",IF(TODAY()>=h2g(D44),G44,\"\"))","v":1160}]
[null,null,27,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1431/12/25"},"2010/12/01",16240,1160,{"$f":"IF(C45=\"\",\"\",IF(TODAY()>=h2g(D45),G45,\"\"))","v":1160}]
[null,null,28,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/01/25"},"2010/12/31",15080,1160,{"$f":"IF(C46=\"\",\"\",IF(TODAY()>=h2g(D46),G46,\"\"))","v":1160}]
[null,null,29,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/02/25"},"2011/01/30",13920,1160,{"$f":"IF(C47=\"\",\"\",IF(TODAY()>=h2g(D47),G47,\"\"))","v":1160}]
[null,null,30,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/03/25"},"2011/02/28",12760,1160,{"$f":"IF(C48=\"\",\"\",IF(TODAY()>=h2g(D48),G48,\"\"))","v":1160}]
[null,null,31,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/04/25"},"2011/03/30",11600,1160,{"$f":"IF(C49=\"\",\"\",IF(TODAY()>=h2g(D49),G49,\"\"))","v":1160}]
[null,null,32,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/05/25"},"2011/04/28",10440,1160,{"$f":"IF(C50=\"\",\"\",IF(TODAY()>=h2g(D50),G50,\"\"))","v":1160}]
[null,null,33,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/06/25"},"2011/05/28",9280,1160,{"$f":"IF(C51=\"\",\"\",IF(TODAY()>=h2g(D51),G51,\"\"))","v":1160}]
[null,null,34,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/07/25"},"2011/06/26",8120,1160,{"$f":"IF(C52=\"\",\"\",IF(TODAY()>=h2g(D52),G52,\"\"))","v":1160}]
[null,null,35,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/08/25"},"2011/07/26",6960,1160,{"$f":"IF(C53=\"\",\"\",IF(TODAY()>=h2g(D53),G53,\"\"))","v":1160}]
[null,null,36,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/09/25"},"2011/08/24",5800,1160,{"$f":"IF(C54=\"\",\"\",IF(TODAY()>=h2g(D54),G54,\"\"))","v":1160}]
[null,null,37,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/10/25"},"2011/09/23",4640,1160,{"$f":"IF(C55=\"\",\"\",IF(TODAY()>=h2g(D55),G55,\"\"))","v":1160}]
[null,null,38,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/11/25"},"2011/10/22",3480,1160,{"$f":"IF(C56=\"\",\"\",IF(TODAY()>=h2g(D56),G56,\"\"))","v":1160}]
[null,null,39,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1432/12/25"},"2011/11/21",2320,1160,{"$f":"IF(C57=\"\",\"\",IF(TODAY()>=h2g(D57),G57,\"\"))","v":1160}]
[null,null,40,{"$f":"IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>$H$14,\"\",IF(h2g(TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\"))>h2g($C$9),\"\",TEXT($C$7+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$7,\"B2dd\")))","v":"1433/01/25"},"2011/12/20",1160,1160,{"$f":"IF(C58=\"\",\"\",IF(TODAY()>=h2g(D58),G58,\"\"))","v":1160}]

{"sheet":" تسديد عميل","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":true,"merged":[[15,4,16,5]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-02-05"}]
[null,"ملف العميــل",2300,"الاســـــم ",{"$f":"VLOOKUP(' تسديد عميل'!C6,المقسطون!B25:I60,2,0)","v":{"$error":"#N/A"}}]
[]
[null,null,null,"مدة القرض (بالاشهر)",{"$f":"VLOOKUP(C6,المقسطون!$B$25:$H$60,3,0)","v":{"$error":"#N/A"}},null,"القسـط الشهري",{"$f":"VLOOKUP(C6,المقسطون!$B$25:$H$60,6,0)","v":{"$error":"#N/A"}}]
[null,null,null,"تاريـخ بدايـة القـرض",{"$f":"VLOOKUP(C6,المقسطون!$B$25:$H$60,7,0)","v":{"$error":"#N/A"}},null,"الســعر النقـدي ",{"$f":"VLOOKUP(C6,المقسطون!$B$25:$H$60,4,0)","v":{"$error":"#N/A"}}]
[null,null,null,"تاريـخ نهايـة القـرض",{"$f":"TEXT(E9+((E8-1)*29.5),\"B2yyyy/mm/\")&TEXT(E9,\"B2dd\")","v":{"$error":"#N/A"}},null,"الربــــــــــــح ",{"$f":"VLOOKUP(C6,المقسطون!B25:K60,9,0)","v":{"$error":"#N/A"}}]
[null,null,null,"حــــــالة العقـــــــد",{"$f":"VLOOKUP(C6,المقسطون!B26:N61,11,0)","v":{"$error":"#N/A"}},null,"قيمــة القــرض",{"$f":"VLOOKUP(C6,المقسطون!B25:I60,5,0)","v":{"$error":"#N/A"}}]
[null,null,null,"نسبة السداد بـ  %",{"$f":"H12/H11","v":{"$error":"#N/A"}},null,"المبالغ المســددة",{"$f":"SUM(H19:H58)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"المبالغ  المتبيقية",{"$f":"SUM(H11-H12)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"الأشهر المسددة",{"$f":"(H12/H8)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"الأشهر المتبقية",{"$f":"H13/H8","v":{"$error":"#N/A"}}]
[null,null,null,null,"حركة تسديد عميل"]
[]
[null,null,null,"الشهــر","تاريخ التحصيل","رصيد القرض","القسط","التسديدات"]
[null,null,null,{"$f":"IF(ROW()-18>$E$8,\"\",ROW()-18)","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",TEXT($E$9+((D19-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"IF(E19=\"\",\"\",IF($H$11=\"\",\"\",$H$11/$E$8))","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",IF(TODAY()>=h2g(E19),G19,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$f":"IF(D20=\"\",\"\",TEXT($E$9+((D20-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":{"$error":"#N/A"}},{"$f":"IF(E20=\"\",\"\",F19-G20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(D20=\"\",\"\",IF(TODAY()>=h2g(E20),G20,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(E21=\"\",\"\",F20-G21)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(D21=\"\",\"\",IF(TODAY()>=h2g(E21),G21,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$f":"IF(D22=\"\",\"\",TEXT($E$9+((D22-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D22=\"\",\"\",IF(TODAY()>=h2g(E22),G22,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D23=\"\",\"\",IF(TODAY()>=h2g(E23),G23,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D24=\"\",\"\",IF(TODAY()>=h2g(E24),G24,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D25=\"\",\"\",IF(TODAY()>=h2g(E25),G25,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D26=\"\",\"\",IF(TODAY()>=h2g(E26),G26,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D27=\"\",\"\",IF(TODAY()>=h2g(E27),G27,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D28=\"\",\"\",IF(TODAY()>=h2g(E28),G28,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D29=\"\",\"\",IF(TODAY()>=h2g(E29),G29,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D30=\"\",\"\",IF(TODAY()>=h2g(E30),G30,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D31=\"\",\"\",IF(TODAY()>=h2g(E31),G31,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D32=\"\",\"\",IF(TODAY()>=h2g(E32),G32,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D33=\"\",\"\",IF(TODAY()>=h2g(E33),G33,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D34=\"\",\"\",IF(TODAY()>=h2g(E34),G34,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D35=\"\",\"\",IF(TODAY()>=h2g(E35),G35,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D36=\"\",\"\",IF(TODAY()>=h2g(E36),G36,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D37=\"\",\"\",IF(TODAY()>=h2g(E37),G37,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D38=\"\",\"\",IF(TODAY()>=h2g(E38),G38,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D39=\"\",\"\",IF(TODAY()>=h2g(E39),G39,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D40=\"\",\"\",IF(TODAY()>=h2g(E40),G40,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D41=\"\",\"\",IF(TODAY()>=h2g(E41),G41,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D42=\"\",\"\",IF(TODAY()>=h2g(E42),G42,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D43=\"\",\"\",IF(TODAY()>=h2g(E43),G43,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D44=\"\",\"\",IF(TODAY()>=h2g(E44),G44,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D45=\"\",\"\",IF(TODAY()>=h2g(E45),G45,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D46=\"\",\"\",IF(TODAY()>=h2g(E46),G46,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D47=\"\",\"\",IF(TODAY()>=h2g(E47),G47,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D48=\"\",\"\",IF(TODAY()>=h2g(E48),G48,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D49=\"\",\"\",IF(TODAY()>=h2g(E49),G49,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D50=\"\",\"\",IF(TODAY()>=h2g(E50),G50,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D51=\"\",\"\",IF(TODAY()>=h2g(E51),G51,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D52=\"\",\"\",IF(TODAY()>=h2g(E52),G52,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D53=\"\",\"\",IF(TODAY()>=h2g(E53),G53,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D54=\"\",\"\",IF(TODAY()>=h2g(E54),G54,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D55=\"\",\"\",IF(TODAY()>=h2g(E55),G55,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D56=\"\",\"\",IF(TODAY()>=h2g(E56),G56,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D57=\"\",\"\",IF(TODAY()>=h2g(E57),G57,\"\"))","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(D58=\"\",\"\",IF(TODAY()>=h2g(E58),G58,\"\"))","v":{"$error":"#N/A"}}]

{"sheet":"الاقساط والاشهر","index":3,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"الشـــــــهر",22]
[]
[null,"المبلغ الاساسي",50000]
[null,"الـزيادة",{"$f":"INDEX(D10:D49,MATCH(C2,B10:B49,0))","v":13500}]
[null,"المبلغ بعد الزيادة",{"$f":"INDEX(C10:C49,MATCH(C2,B10:B49,0))","v":63500}]
[null,"القسط الشهري",{"$f":"INDEX(E10:E49,MATCH(C2,B10:B49,0))","v":2886.3636363636365}]
[]
[null,"الاشهر ","المبلغ بعد الزيادة","الزيادة ","القسط الشهري"]
[null,1,{"$f":"C4+D10","v":50750},{"$f":"C4*0.015","v":750},{"$f":"C10/1","v":50750}]
[null,2,{"$f":"C4+D11","v":51250},{"$f":"C4*0.025","v":1250},{"$f":"C11/2","v":25625}]
[null,3,{"$f":"C4+D12","v":51750},{"$f":"C4*0.035","v":1750.0000000000002},{"$f":"C12/3","v":17250}]
[null,4,{"$f":"C4+D13","v":52250},{"$f":"C4*0.045","v":2250},{"$f":"C13/4","v":13062.5}]
[null,5,{"$f":"C4+D14","v":52750},{"$f":"C4*0.055","v":2750},{"$f":"C14/5","v":10550}]
[null,6,{"$f":"C4+D15","v":53250},{"$f":"C4*0.065","v":3250},{"$f":"C15/6","v":8875}]
[null,7,{"$f":"C4+D16","v":53750},{"$f":"C4*0.075","v":3750},{"$f":"C16/7","v":7678.5714285714284}]
[null,8,{"$f":"C4+D17","v":54250},{"$f":"C4*0.085","v":4250},{"$f":"C17/8","v":6781.25}]
[null,9,{"$f":"C4+D18","v":54750},{"$f":"C4*0.095","v":4750},{"$f":"C18/9","v":6083.333333333333}]
[null,10,{"$f":"C4+D19","v":57500},{"$f":"C4*0.15","v":7500},{"$f":"C19/10","v":5750}]
[null,11,{"$f":"C4+D20","v":58000},{"$f":"C4*0.16","v":8000},{"$f":"C20/11","v":5272.727272727273}]
[null,12,{"$f":"C4+D21","v":58500},{"$f":"C4*0.17","v":8500},{"$f":"C21/12","v":4875}]
[null,13,{"$f":"C4+D22","v":59000},{"$f":"C4*0.18","v":9000},{"$f":"C22/13","v":4538.4615384615381}]
[null,14,{"$f":"C4+D23","v":59500},{"$f":"C4*0.19","v":9500},{"$f":"C23/14","v":4250}]
[null,15,{"$f":"C4+D24","v":60000},{"$f":"C4*0.2","v":10000},{"$f":"C24/15","v":4000}]
[null,16,{"$f":"C4+D25","v":60500},{"$f":"C4*0.21","v":10500},{"$f":"C25/16","v":3781.25}]
[null,17,{"$f":"C4+D26","v":61000},{"$f":"C4*0.22","v":11000},{"$f":"C26/17","v":3588.2352941176468}]
[null,18,{"$f":"C4+D27","v":61500},{"$f":"C4*0.23","v":11500},{"$f":"C27/18","v":3416.6666666666665}]
[null,19,{"$f":"C4+D28","v":62000},{"$f":"C4*0.24","v":12000},{"$f":"C28/19","v":3263.1578947368421}]
[null,20,{"$f":"C4+D29","v":62500},{"$f":"C4*0.25","v":12500},{"$f":"C29/20","v":3125}]
[null,21,{"$f":"C4+D30","v":63000},{"$f":"C4*0.26","v":13000},{"$f":"C30/21","v":3000}]
[null,22,{"$f":"C4+D31","v":63500},{"$f":"C4*0.27","v":13500},{"$f":"C31/22","v":2886.3636363636365}]
[null,23,{"$f":"C4+D32","v":64000},{"$f":"C4*0.28","v":14000.000000000002},{"$f":"C32/23","v":2782.608695652174}]
[null,24,{"$f":"C4+D33","v":64500},{"$f":"C4*0.29","v":14499.999999999998},{"$f":"C33/24","v":2687.5}]
[null,25,{"$f":"C4+D34","v":65000},{"$f":"C4*0.3","v":15000},{"$f":"C34/25","v":2600}]
[null,26,{"$f":"C4+D35","v":65500},{"$f":"C4*0.31","v":15500},{"$f":"C35/26","v":2519.2307692307691}]
[null,27,{"$f":"C4+D36","v":66000},{"$f":"C4*0.32","v":16000},{"$f":"C36/27","v":2444.4444444444443}]
[null,28,{"$f":"C4+D37","v":66500},{"$f":"C4*0.33","v":16500},{"$f":"C37/28","v":2375}]
[null,29,{"$f":"C4+D38","v":67000},{"$f":"C4*0.34","v":17000},{"$f":"C38/29","v":2310.344827586207}]
[null,30,{"$f":"C4+D39","v":67500},{"$f":"C4*0.35","v":17500},{"$f":"C39/30","v":2250}]
[null,31,{"$f":"C4+D40","v":68000},{"$f":"C4*0.36","v":18000},{"$f":"C40/31","v":2193.5483870967741}]
[null,32,{"$f":"C4+D41","v":68500},{"$f":"C4*0.37","v":18500},{"$f":"C41/32","v":2140.625}]
[null,33,{"$f":"C4+D42","v":69000},{"$f":"C4*0.38","v":19000},{"$f":"C42/33","v":2090.909090909091}]
[null,34,{"$f":"C4+D43","v":69500},{"$f":"C4*0.39","v":19500},{"$f":"C43/34","v":2044.1176470588234}]
[null,35,{"$f":"C4+D44","v":70000},{"$f":"C4*0.4","v":20000},{"$f":"C44/35","v":2000}]
[null,36,{"$f":"C4+D45","v":70500},{"$f":"C4*0.41","v":20500},{"$f":"C45/36","v":1958.3333333333333}]
[null,37,{"$f":"C4+D46","v":71000},{"$f":"C4*0.42","v":21000},{"$f":"C46/37","v":1918.918918918919}]
[null,38,{"$f":"C4+D47","v":71500},{"$f":"C4*0.43","v":21500},{"$f":"C47/38","v":1881.578947368421}]
[null,39,{"$f":"C4+D48","v":72000},{"$f":"C4*0.44","v":22000},{"$f":"C48/39","v":1846.1538461538462}]
[null,40,{"$f":"C4+D49","v":72500},{"$f":"C4*0.45","v":22500},{"$f":"C49/40","v":1812.5}]