{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["المقسطون","حركة تسديد عميل"," تسديد عميل","الاقساط والاشهر","نموذج","data","check List","المبالغ المتاخره"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":338,"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":14,"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],[23,2,23,5],[14,9,14,10],[5,5,5,6],[7,5,7,6],[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,"ملف العميــل",2800,"الاســم ",{"$f":"VLOOKUP(D2,B27:K62,2,0)","v":"عميل"},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2023-07-27"}]
[]
[null,null,"تقيـيم العميل",{"$f":"'حركة تسديد عميل'!E8","v":"عميل مميز"}]
["نظـام الخصــم ",null,null,null,null,null,null,null,"حساب نســبة التقسـيط ",null,null,"نظام تحويل التاريخ من هجري لميلادي "]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D2,B27:K62,4,0)","v":50000},null,null,null,null,"السعر","الاشهر",null,"بداية التسديد ","نهاية التسديد"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D2,B27:K62,5,0)","v":82500},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D2,B27:K62,3,1)","v":60},null,{"$f":"D12","v":"2023-09-10"},{"$f":"D13","v":"2028-06-17"}]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I8*(J8%+5%))","v":32500},null,{"$f":"TEXT(L8,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2023/09/10"},{"$f":"TEXT(M8,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2028-06-18"}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D2,B27:K62,6,0)","v":1375},null,"الأقساط التأخرة ",{"$f":"'حركة تسديد عميل'!E6","v":0},null,"بعد الزيادة",{"$f":"SUM(I8+J9)","v":82500},null,{"$f":"TEXT(L8+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"2023/09/11"},{"$f":"TEXT(M8+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"2028/06/18"}]
[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":0},null,"المبــالغ المتأخرة ",{"$f":"'حركة تسديد عميل'!E7","v":{"$error":"#N/A"}},null,"القسط الشهري",{"$f":"SUM(J10/J8)","v":1375}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D2,B27:K62,7,0)","v":"2023-09-10"},null,null,null,null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D2,B27:K62,8,0)","v":"2028-06-17"},null,"المدة",{"$f":"(D8-D9)/D10","v":60}]
[null,null,"الأشهر المسددة",{"$f":"(D11/D10)","v":0},null,"الربح كامل",{"$f":"D8-D7","v":32500},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,"الأشهر المتبقية",{"$f":"D17/D10","v":60},null,"الربح الشهري",{"$f":"G14/G13","v":541.66666666666663},null,{"$f":"D2","v":2800},{"$f":"F2","v":"عميل"},null,{"$f":"G13","v":60},{"$f":"D12","v":"2023-09-10"},{"$f":"D13","v":"2028-06-17"}]
[null,null,null,null,null,"النسبة ",{"$f":"(G14/(D7-D9))*100","v":65},null,"حالة الاشهر وقيمة العقد",null,null,null,{"$f":"TEXT(M15,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2023/09/10"},{"$f":"EDATE(M16,L15)","v":"2028-09-10"}]
[null,null,"الباقي من المبلغ",{"$f":"D8-D11","v":82500},null,"النسبة السنوية",{"$f":"(G16/G13)*12","v":13},null,"الأشهر المسددة",{"$f":"'حركة تسديد عميل'!H7","v":0},"المبــالغ المســدة",{"$f":"(J17*D10)","v":0},"نسبة السداد بـ  %"]
[null,null,"الخصم",{"$f":"((D17*G17%)*(D15/12))/(1+((G17%)*(D15/12)))","v":32500},null,"النسبة الشهرية",{"$f":"G16/G13","v":1.0833333333333333},null,"الأشهر المتبقية",{"$f":"L15-J17","v":60},"المبــالغ المتبـقية",{"$f":"'حركة تسديد عميل'!H10","v":82500},{"$f":"L17/D8","v":0}]
[null,null,"المطلوب",{"$f":"D17-D18","v":50000},null,null,null,null,"حـالة العقــد",{"$f":"VLOOKUP(D2,B27:N62,11,0)","v":"لم يتم تداولة"},"مبلغ السداد المبكر",{"$f":"IF(J19=\"سداد مبكر\",INDEX(N27:N62,MATCH(J19,L27:L62,0)),\"\")","v":""},"تاريخ السداد المبكر",{"$f":"IF(J19=\"سداد مبكر\",INDEX(M27:M62,MATCH(J19,L27:L62,0)),\"\")","v":""}]
[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,100,100,40,45000,46400,1160,"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":20250},0,{"$f":"IFERROR(IF(AND(M27<>\"\",M27<I27),\"سداد مبكر\",IF(TODAY()=I27,\"العقد انتهى اليوم\",IF(TODAY()>I27,\"العقـد منتهى\",IF(TODAY()<H27,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,200,200,40,45000,43500,1087,"2009-01-21","2012-03-18",20250,0,{"$f":"IFERROR(IF(AND(M28<>\"\",M28<I28),\"سداد مبكر\",IF(TODAY()=I28,\"العقد انتهى اليوم\",IF(TODAY()>I28,\"العقـد منتهى\",IF(TODAY()<H28,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,300,300,40,45000,46400,1160,"2010-03-10","2013-05-05",20250,0,"العقـد منتهى"]
[null,400,400,40,45000,39160,979,"2010-06-07","2013-08-01",20250,0,"العقـد منتهى"]
[null,500,500,40,45000,43520,1088,"2010-11-01","2013-12-28",20250,0,"العقـد منتهى"]
[null,600,600,40,45000,69024,5507,"2010-12-31","2014-02-25",20250,0,"العقـد منتهى"]
[null,700,700,40,45000,38124,2118,"2011-01-30","2014-03-26",20250,0,"العقـد منتهى"]
[null,800,800,40,45000,57592,2504,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,900,900,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1000,1000,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1100,1100,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1200,1200,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1300,1300,40,45000,76850,1921,"2011-11-21","2015-01-15",20250,0,"العقـد منتهى"]
[null,1400,1400,40,45000,62360,1559,"2012-02-17","2015-04-14",20250,0,"العقـد منتهى"]
[null,1500,1500,40,45000,60900,1523,"2012-03-18","2015-05-13",20250,0,"العقـد منتهى"]
[null,1600,1600,40,45000,50760,1269,"2014-06-23","2017-08-17",20250,0,"العقـد منتهى"]
[null,1700,1700,40,45000,50760,1269,"2014-10-19","2017-12-13",20250,0,"العقـد منتهى"]
[null,1800,1800,40,45000,53640,{"$f":"F44/D44","v":1341},"2015-01-15","2018-03-12",20250,0,"العقـد منتهى"]
[null,1900,1900,40,45000,60920,1523,"2015-05-13","2018-07-08",20250,0,"العقـد منتهى"]
[null,2000,2000,40,45000,60750,1518.75,"2015-07-11","2018-09-05",20250,0,"العقـد منتهى"]
[null,2100,2100,40,45000,105624,2640.6,"2017-02-21","2020-04-18",20250,0,"العقـد منتهى"]
[null,2200,2200,40,45000,{"$f":"E48+J48","v":65250},1631.25,"2018-01-12","2021-03-08",20250,0,"العقـد منتهى"]
[null,2300,2300,40,45000,65250,1631.25,"2018-04-10","2021-06-05",20250,0,"سداد مبكر","2019-02-07",39889]
[null,2400,2400,35,50000,70000,2000,"2019-11-01","2022-08-01",20000,{"$f":"G50","v":2000},"العقـد منتهى"]
[null,2500,2500,35,50000,70000,2000,"2020-09-25","2023-06-26",20000,{"$f":"G51","v":2000},"العقـد منتهى"]
[null,2600,2600,35,50000,70000,2000,"2021-03-27","2023-12-26",20000,{"$f":"G52","v":2000},"العقـد سارى"]
[null,2700,2700,35,50000,70000,{"$f":"F53/D53","v":2000},"2022-01-27","2024-10-27",{"$f":"SUM(E53*(D53%+5%))","v":20000},{"$f":"G53","v":2000},{"$f":"IFERROR(IF(AND(M53<>\"\",M53<I53),\"سداد مبكر\",IF(TODAY()=I53,\"العقد انتهى اليوم\",IF(TODAY()>I53,\"العقـد منتهى\",IF(TODAY()<H53,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد سارى"}]
[null,2800,"عميل",60,50000,82500,{"$f":"F54/60","v":1375},"2023-09-10","2028-06-17",32500,{"$f":"G54","v":1375},"لم يتم تداولة"]
[null,null,null,null,null,null,{"$f":"F55/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,{"$f":"SUM(E27:E62)","v":1285000},{"$f":"SUM(F27:F62)","v":1691284},null,null,null,{"$f":"SUM(J27:J62)","v":578250},{"$f":"SUM(K27:K62)","v":9375}]

{"sheet":"حركة تسديد عميل","index":1,"n_rows":78,"n_cols":9,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,3,1,5],[13,3,16,5],[9,5,11,5]]}
[]
["ملف العميــل",2800,"الاســم",{"$f":"VLOOKUP(B2,المقسطون!B26:I61,2,0)","v":"عميل"},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2023-07-27"}]
[]
[]
[null,"مدة العقد (بالاشهر)",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,3,0)","v":60},null,null,"حـالة العقــد",{"$f":"VLOOKUP(B2,المقسطون!B27:N62,11,0)","v":"لم يتم تداولة"}]
[null,null,null,"الأقساط التأخرة ",{"$f":"COUNT(I19:I58)","v":0}]
[null," بداية العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,7,0)","v":"2023-09-10"},"المبــالغ المتأخرة ",{"$f":"SUM(I19:I58)","v":{"$error":"#N/A"}},null,"الأشهر المسددة",{"$f":"IF(COUNT(H19:H58)>C9,C9,COUNT(H19:H58))-E6","v":0}]
[null,null,{"$f":"TEXT(C7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2023-09-11"},"تقيــم العــــميل",{"$f":"IF(E6=0,\"عميل مميز\",IF(E6=1,\"عميل جيد جداً\",IF(E6=2,\"عميل جيد\",IF(E6>=3,\"بلاك لست Blacklist\"))))","v":"عميل مميز"},null,"الأشهر المتبقية",{"$f":"C5-H7","v":60}]
[null," نهاية العقد",{"$f":"TEXT(C7+((C5-1)*29.5),\"B2yyyy/mm/\")&TEXT(C7,\"B2dd\")","v":"1450/01/25"},null,null,null,"المبــالغ المســدة",{"$f":"SUM(H7*C11)","v":0}]
[null,null,{"$f":"ConvertDate(C9)","v":"2028/06/17"},null,null,"؟","المبــالغ المتبـقية",{"$f":"SUM(H8*C11)","v":82500}]
[null,"القســـــــط ",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,6,0)","v":1375},null,"هل ممكن حل لهذه المشكلة ؟",null,"نسبة السداد بـ  %",{"$f":"H9/C14","v":0}]
[null,"السعر النقدي ",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,4,0)","v":50000}]
[null,"الربـــــــــح ",{"$f":"VLOOKUP(B2,المقسطون!B27:N62,9,0)","v":32500},null,null,null,"الســداد المبكـر"]
[null,"قيمة العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,5,0)","v":82500},"حركة تسديد عميل",null,null,"تاريخ السداد المبكر",{"$f":"IF(G5=\"سداد مبكر\",INDEX(المقسطون!M27:M62,MATCH(G5,المقسطون!L27:L62,0)),\"\")","v":""}]
[]
[null,null,null,null,null,null,"قيمة السداد المبكر",{"$f":"IF(G5=\"سداد مبكر\",INDEX(المقسطون!N28:N63,MATCH(G5,المقسطون!L28:L63,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":"1445/02/25"},{"$f":"IF(D19<>\"\",ConvertDate(D19),\"\")","v":"2023/09/10"},{"$f":"C14","v":82500},{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I19<>\"\",G19-I19,IF(C19=\"\",\"\",IF(TODAY()>=h2g(D19),G19,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/03/25"},{"$f":"IF(D20<>\"\",ConvertDate(D20),\"\")","v":"2023/10/09"},{"$f":"IF(D20=\"\",\"\",F19-G20)","v":81125},{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I20<>\"\",G20-I20,IF(C20=\"\",\"\",IF(TODAY()>=h2g(D20),G20,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/04/25"},"2023/11/08",{"$f":"IF(D21=\"\",\"\",F20-G21)","v":79750},{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I21<>\"\",G21-I21,IF(C21=\"\",\"\",IF(TODAY()>=h2g(D21),G21,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/05/25"},"2023/12/07",78375,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I22<>\"\",G22-I22,IF(C22=\"\",\"\",IF(TODAY()>=h2g(D22),G22,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/06/25"},"2024/01/06",77000,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I23<>\"\",G23-I23,IF(C23=\"\",\"\",IF(TODAY()>=h2g(D23),G23,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/07/25"},"2024/02/04",75625,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I24<>\"\",G24-I24,IF(C24=\"\",\"\",IF(TODAY()>=h2g(D24),G24,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/08/25"},"2024/03/05",74250,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I25<>\"\",G25-I25,IF(C25=\"\",\"\",IF(TODAY()>=h2g(D25),G25,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/09/25"},"2024/04/03",72875,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I26<>\"\",G26-I26,IF(C26=\"\",\"\",IF(TODAY()>=h2g(D26),G26,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/10/25"},"2024/05/03",71500,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I27<>\"\",G27-I27,IF(C27=\"\",\"\",IF(TODAY()>=h2g(D27),G27,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/11/25"},"2024/06/01",70125,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I28<>\"\",G28-I28,IF(C28=\"\",\"\",IF(TODAY()>=h2g(D28),G28,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1445/12/25"},"2024/07/01",68750,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I29<>\"\",G29-I29,IF(C29=\"\",\"\",IF(TODAY()>=h2g(D29),G29,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/01/25"},"2024/07/31",67375,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I30<>\"\",G30-I30,IF(C30=\"\",\"\",IF(TODAY()>=h2g(D30),G30,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/02/25"},"2024/08/30",66000,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I31<>\"\",G31-I31,IF(C31=\"\",\"\",IF(TODAY()>=h2g(D31),G31,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/03/25"},"2024/09/28",64625,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I32<>\"\",G32-I32,IF(C32=\"\",\"\",IF(TODAY()>=h2g(D32),G32,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/04/25"},"2024/10/28",63250,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I33<>\"\",G33-I33,IF(C33=\"\",\"\",IF(TODAY()>=h2g(D33),G33,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/05/25"},"2024/11/26",61875,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I34<>\"\",G34-I34,IF(C34=\"\",\"\",IF(TODAY()>=h2g(D34),G34,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/06/25"},"2024/12/26",60500,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I35<>\"\",G35-I35,IF(C35=\"\",\"\",IF(TODAY()>=h2g(D35),G35,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/07/25"},"2025/01/24",59125,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I36<>\"\",G36-I36,IF(C36=\"\",\"\",IF(TODAY()>=h2g(D36),G36,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/08/25"},"2025/02/23",57750,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I37<>\"\",G37-I37,IF(C37=\"\",\"\",IF(TODAY()>=h2g(D37),G37,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/09/25"},"2025/03/24",56375,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I38<>\"\",G38-I38,IF(C38=\"\",\"\",IF(TODAY()>=h2g(D38),G38,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/10/25"},"2025/04/23",55000,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I39<>\"\",G39-I39,IF(C39=\"\",\"\",IF(TODAY()>=h2g(D39),G39,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/11/25"},"2025/05/22",53625,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I40<>\"\",G40-I40,IF(C40=\"\",\"\",IF(TODAY()>=h2g(D40),G40,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1446/12/25"},"2025/06/21",52250,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I41<>\"\",G41-I41,IF(C41=\"\",\"\",IF(TODAY()>=h2g(D41),G41,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/01/25"},"2025/07/20",50875,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I42<>\"\",G42-I42,IF(C42=\"\",\"\",IF(TODAY()>=h2g(D42),G42,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/02/25"},"2025/08/19",49500,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I43<>\"\",G43-I43,IF(C43=\"\",\"\",IF(TODAY()>=h2g(D43),G43,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/03/25"},"2025/09/17",48125,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I44<>\"\",G44-I44,IF(C44=\"\",\"\",IF(TODAY()>=h2g(D44),G44,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/04/25"},"2025/10/17",46750,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I45<>\"\",G45-I45,IF(C45=\"\",\"\",IF(TODAY()>=h2g(D45),G45,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/05/25"},"2025/11/15",45375,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I46<>\"\",G46-I46,IF(C46=\"\",\"\",IF(TODAY()>=h2g(D46),G46,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/06/25"},"2025/12/15",44000,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I47<>\"\",G47-I47,IF(C47=\"\",\"\",IF(TODAY()>=h2g(D47),G47,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/07/25"},"2026/01/13",42625,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I48<>\"\",G48-I48,IF(C48=\"\",\"\",IF(TODAY()>=h2g(D48),G48,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/08/25"},"2026/02/12",41250,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I49<>\"\",G49-I49,IF(C49=\"\",\"\",IF(TODAY()>=h2g(D49),G49,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/09/25"},"2026/03/13",39875,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I50<>\"\",G50-I50,IF(C50=\"\",\"\",IF(TODAY()>=h2g(D50),G50,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/10/25"},"2026/04/12",38500,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I51<>\"\",G51-I51,IF(C51=\"\",\"\",IF(TODAY()>=h2g(D51),G51,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/11/25"},"2026/05/11",37125,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I52<>\"\",G52-I52,IF(C52=\"\",\"\",IF(TODAY()>=h2g(D52),G52,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1447/12/25"},"2026/06/10",35750,{"$f":"VLOOKUP(B2,المقسطون!B27:N62,6,0)","v":1375},{"$f":"IF(I53<>\"\",G53-I53,IF(C53=\"\",\"\",IF(TODAY()>=h2g(D53),G53,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1448/01/25"},"2026/07/10",34375,{"$f":"IF(D54=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":1375},{"$f":"IF(I54<>\"\",G54-I54,IF(C54=\"\",\"\",IF(TODAY()>=h2g(D54),G54,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1448/02/25"},"2026/08/09",33000,1375,{"$f":"IF(I55<>\"\",G55-I55,IF(C55=\"\",\"\",IF(TODAY()>=h2g(D55),G55,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1448/03/25"},"2026/09/07",31625,1375,{"$f":"IF(I56<>\"\",G56-I56,IF(C56=\"\",\"\",IF(TODAY()>=h2g(D56),G56,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1448/04/25"},"2026/10/07",30250,1375,{"$f":"IF(I57<>\"\",G57-I57,IF(C57=\"\",\"\",IF(TODAY()>=h2g(D57),G57,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[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":"1448/05/25"},"2026/11/05",28875,1375,{"$f":"IF(I58<>\"\",G58-I58,IF(C58=\"\",\"\",IF(TODAY()>=h2g(D58),G58,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(D59=\"\",\"\",ROW()-18)","v":41},{"$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":"1448/06/25"},{"$f":"IF(D59<>\"\",ConvertDate(D59),\"\")","v":"2026/12/05"},{"$f":"IF(D59=\"\",\"\",F58-G59)","v":27500},{"$f":"IF(D59=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":1375},{"$f":"IF(I59<>\"\",G59-I59,IF(C59=\"\",\"\",IF(TODAY()>=h2g(D59),G59,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,42,{"$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":"1448/07/25"},"2027/01/03",26125,1375,{"$f":"IF(I60<>\"\",G60-I60,IF(C60=\"\",\"\",IF(TODAY()>=h2g(D60),G60,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,43,{"$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":"1448/08/25"},"2027/02/02",24750,1375,{"$f":"IF(I61<>\"\",G61-I61,IF(C61=\"\",\"\",IF(TODAY()>=h2g(D61),G61,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,44,{"$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":"1448/09/25"},"2027/03/03",23375,1375,{"$f":"IF(I62<>\"\",G62-I62,IF(C62=\"\",\"\",IF(TODAY()>=h2g(D62),G62,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,45,{"$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":"1448/10/25"},"2027/04/02",22000,1375,{"$f":"IF(I63<>\"\",G63-I63,IF(C63=\"\",\"\",IF(TODAY()>=h2g(D63),G63,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,46,{"$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":"1448/11/25"},"2027/05/01",20625,1375,{"$f":"IF(I64<>\"\",G64-I64,IF(C64=\"\",\"\",IF(TODAY()>=h2g(D64),G64,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,47,{"$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":"1448/12/25"},"2027/05/31",19250,1375,{"$f":"IF(I65<>\"\",G65-I65,IF(C65=\"\",\"\",IF(TODAY()>=h2g(D65),G65,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,48,{"$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":"1449/01/25"},"2027/06/29",17875,1375,{"$f":"IF(I66<>\"\",G66-I66,IF(C66=\"\",\"\",IF(TODAY()>=h2g(D66),G66,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,49,{"$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":"1449/02/25"},"2027/07/29",16500,1375,{"$f":"IF(I67<>\"\",G67-I67,IF(C67=\"\",\"\",IF(TODAY()>=h2g(D67),G67,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,50,{"$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":"1449/03/25"},"2027/08/27",15125,1375,{"$f":"IF(I68<>\"\",G68-I68,IF(C68=\"\",\"\",IF(TODAY()>=h2g(D68),G68,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,51,{"$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":"1449/04/25"},"2027/09/26",13750,1375,{"$f":"IF(I69<>\"\",G69-I69,IF(C69=\"\",\"\",IF(TODAY()>=h2g(D69),G69,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(D70=\"\",\"\",ROW()-18)","v":52},{"$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":"1449/05/25"},{"$f":"IF(D70<>\"\",ConvertDate(D70),\"\")","v":"2027/10/25"},{"$f":"IF(D70=\"\",\"\",F69-G70)","v":12375},{"$f":"IF(D70=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":1375},{"$f":"IF(I70<>\"\",G70-I70,IF(C70=\"\",\"\",IF(TODAY()>=h2g(D70),G70,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,53,{"$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":"1449/06/25"},"2027/11/24",11000,1375,{"$f":"IF(I71<>\"\",G71-I71,IF(C71=\"\",\"\",IF(TODAY()>=h2g(D71),G71,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,54,{"$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":"1449/07/25"},"2027/12/23",9625,1375,{"$f":"IF(I72<>\"\",G72-I72,IF(C72=\"\",\"\",IF(TODAY()>=h2g(D72),G72,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,55,{"$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":"1449/08/25"},"2028/01/22",8250,1375,{"$f":"IF(I73<>\"\",G73-I73,IF(C73=\"\",\"\",IF(TODAY()>=h2g(D73),G73,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,56,{"$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":"1449/09/25"},"2028/02/20",6875,1375,{"$f":"IF(I74<>\"\",G74-I74,IF(C74=\"\",\"\",IF(TODAY()>=h2g(D74),G74,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,57,{"$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":"1449/10/25"},"2028/03/21",5500,1375,{"$f":"IF(I75<>\"\",G75-I75,IF(C75=\"\",\"\",IF(TODAY()>=h2g(D75),G75,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,58,{"$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":"1449/11/25"},"2028/04/19",4125,1375,{"$f":"IF(I76<>\"\",G76-I76,IF(C76=\"\",\"\",IF(TODAY()>=h2g(D76),G76,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,59,{"$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":"1449/12/25"},"2028/05/19",2750,1375,{"$f":"IF(I77<>\"\",G77-I77,IF(C77=\"\",\"\",IF(TODAY()>=h2g(D77),G77,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]
[null,null,60,{"$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":"1450/01/25"},"2028/06/17",1375,1375,{"$f":"IF(I78<>\"\",G78-I78,IF(C78=\"\",\"\",IF(TODAY()>=h2g(D78),G78,\"\")))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0)=0,\"\",VLOOKUP($B$2,'المبالغ المتاخره'!$B$20:$AQ$55,ROW()-16,0))","v":{"$error":"#N/A"}}]

{"sheet":" تسديد عميل","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[15,4,16,5]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2023-07-27"}]
[null,"ملف العميــل",2800,"الاســـــم ",{"$f":"VLOOKUP(' تسديد عميل'!C6,المقسطون!B26:I61,2,0)","v":"عميل"}]
[]
[null,null,null,"مدة القرض (بالاشهر)",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,3,0)","v":60},null,"القسـط الشهري",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,6,0)","v":1375}]
[null,null,null,"تاريـخ بدايـة القـرض",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,7,0)","v":"2023-09-10"},null,"الســعر النقـدي ",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,4,0)","v":50000}]
[null,null,null,"تاريـخ نهايـة القـرض",{"$f":"TEXT(E9+((E8-1)*29.5),\"B2yyyy/mm/\")&TEXT(E9,\"B2dd\")","v":"1450/01/25"},null,"الربــــــــــــح ",{"$f":"VLOOKUP(C6,المقسطون!B26:K61,9,0)","v":32500}]
[null,null,null,"حــــــالة العقـــــــد",{"$f":"VLOOKUP(C6,المقسطون!B27:N62,11,0)","v":"لم يتم تداولة"},null,"قيمــة القــرض",{"$f":"VLOOKUP(C6,المقسطون!B26:I61,5,0)","v":82500}]
[null,null,null,"نسبة السداد بـ  %",{"$f":"H12/H11","v":0},null,"المبالغ المســددة",{"$f":"SUM(H19:H58)","v":0}]
[null,null,null,null,null,null,"المبالغ  المتبيقية",{"$f":"SUM(H11-H12)","v":82500}]
[null,null,null,null,null,null,"الأشهر المسددة",{"$f":"(H12/H8)","v":0}]
[null,null,null,null,null,null,"الأشهر المتبقية",{"$f":"H13/H8","v":60}]
[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":"1445/02/25"},{"$f":"H11","v":82500},{"$f":"IF(E19=\"\",\"\",IF($H$11=\"\",\"\",$H$11/$E$8))","v":1375},{"$f":"IF(D19=\"\",\"\",IF(TODAY()>=h2g(E19),G19,\"\"))","v":""}]
[null,null,null,2,{"$f":"IF(D20=\"\",\"\",TEXT($E$9+((D20-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":"1445/03/25"},{"$f":"IF(E20=\"\",\"\",F19-G20)","v":81125},1375,{"$f":"IF(D20=\"\",\"\",IF(TODAY()>=h2g(E20),G20,\"\"))","v":""}]
[null,null,null,3,"1445/04/25",{"$f":"IF(E21=\"\",\"\",F20-G21)","v":79750},1375,{"$f":"IF(D21=\"\",\"\",IF(TODAY()>=h2g(E21),G21,\"\"))","v":""}]
[null,null,null,4,{"$f":"IF(D22=\"\",\"\",TEXT($E$9+((D22-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":"1445/05/25"},78375,1375,{"$f":"IF(D22=\"\",\"\",IF(TODAY()>=h2g(E22),G22,\"\"))","v":""}]
[null,null,null,5,"1445/06/25",77000,1375,{"$f":"IF(D23=\"\",\"\",IF(TODAY()>=h2g(E23),G23,\"\"))","v":""}]
[null,null,null,6,"1445/07/25",75625,1375,{"$f":"IF(D24=\"\",\"\",IF(TODAY()>=h2g(E24),G24,\"\"))","v":""}]
[null,null,null,7,"1445/08/25",74250,1375,{"$f":"IF(D25=\"\",\"\",IF(TODAY()>=h2g(E25),G25,\"\"))","v":""}]
[null,null,null,8,"1445/09/25",72875,1375,{"$f":"IF(D26=\"\",\"\",IF(TODAY()>=h2g(E26),G26,\"\"))","v":""}]
[null,null,null,9,"1445/10/25",71500,1375,{"$f":"IF(D27=\"\",\"\",IF(TODAY()>=h2g(E27),G27,\"\"))","v":""}]
[null,null,null,10,"1445/11/25",70125,1375,{"$f":"IF(D28=\"\",\"\",IF(TODAY()>=h2g(E28),G28,\"\"))","v":""}]
[null,null,null,11,"1445/12/25",68750,1375,{"$f":"IF(D29=\"\",\"\",IF(TODAY()>=h2g(E29),G29,\"\"))","v":""}]
[null,null,null,12,"1446/01/25",67375,1375,{"$f":"IF(D30=\"\",\"\",IF(TODAY()>=h2g(E30),G30,\"\"))","v":""}]
[null,null,null,13,"1446/02/25",66000,1375,{"$f":"IF(D31=\"\",\"\",IF(TODAY()>=h2g(E31),G31,\"\"))","v":""}]
[null,null,null,14,"1446/03/25",64625,1375,{"$f":"IF(D32=\"\",\"\",IF(TODAY()>=h2g(E32),G32,\"\"))","v":""}]
[null,null,null,15,"1446/04/25",63250,1375,{"$f":"IF(D33=\"\",\"\",IF(TODAY()>=h2g(E33),G33,\"\"))","v":""}]
[null,null,null,16,"1446/05/25",61875,1375,{"$f":"IF(D34=\"\",\"\",IF(TODAY()>=h2g(E34),G34,\"\"))","v":""}]
[null,null,null,17,"1446/06/25",60500,1375,{"$f":"IF(D35=\"\",\"\",IF(TODAY()>=h2g(E35),G35,\"\"))","v":""}]
[null,null,null,18,"1446/07/25",59125,1375,{"$f":"IF(D36=\"\",\"\",IF(TODAY()>=h2g(E36),G36,\"\"))","v":""}]
[null,null,null,19,"1446/08/25",57750,1375,{"$f":"IF(D37=\"\",\"\",IF(TODAY()>=h2g(E37),G37,\"\"))","v":""}]
[null,null,null,20,"1446/09/25",56375,1375,{"$f":"IF(D38=\"\",\"\",IF(TODAY()>=h2g(E38),G38,\"\"))","v":""}]
[null,null,null,21,"1446/10/25",55000,1375,{"$f":"IF(D39=\"\",\"\",IF(TODAY()>=h2g(E39),G39,\"\"))","v":""}]
[null,null,null,22,"1446/11/25",53625,1375,{"$f":"IF(D40=\"\",\"\",IF(TODAY()>=h2g(E40),G40,\"\"))","v":""}]
[null,null,null,23,"1446/12/25",52250,1375,{"$f":"IF(D41=\"\",\"\",IF(TODAY()>=h2g(E41),G41,\"\"))","v":""}]
[null,null,null,24,"1447/01/25",50875,1375,{"$f":"IF(D42=\"\",\"\",IF(TODAY()>=h2g(E42),G42,\"\"))","v":""}]
[null,null,null,25,"1447/02/25",49500,1375,{"$f":"IF(D43=\"\",\"\",IF(TODAY()>=h2g(E43),G43,\"\"))","v":""}]
[null,null,null,26,"1447/03/25",48125,1375,{"$f":"IF(D44=\"\",\"\",IF(TODAY()>=h2g(E44),G44,\"\"))","v":""}]
[null,null,null,27,"1447/04/25",46750,1375,{"$f":"IF(D45=\"\",\"\",IF(TODAY()>=h2g(E45),G45,\"\"))","v":""}]
[null,null,null,28,"1447/05/25",45375,1375,{"$f":"IF(D46=\"\",\"\",IF(TODAY()>=h2g(E46),G46,\"\"))","v":""}]
[null,null,null,29,"1447/06/25",44000,1375,{"$f":"IF(D47=\"\",\"\",IF(TODAY()>=h2g(E47),G47,\"\"))","v":""}]
[null,null,null,30,"1447/07/25",42625,1375,{"$f":"IF(D48=\"\",\"\",IF(TODAY()>=h2g(E48),G48,\"\"))","v":""}]
[null,null,null,31,"1447/08/25",41250,1375,{"$f":"IF(D49=\"\",\"\",IF(TODAY()>=h2g(E49),G49,\"\"))","v":""}]
[null,null,null,32,"1447/09/25",39875,1375,{"$f":"IF(D50=\"\",\"\",IF(TODAY()>=h2g(E50),G50,\"\"))","v":""}]
[null,null,null,33,"1447/10/25",38500,1375,{"$f":"IF(D51=\"\",\"\",IF(TODAY()>=h2g(E51),G51,\"\"))","v":""}]
[null,null,null,34,"1447/11/25",37125,1375,{"$f":"IF(D52=\"\",\"\",IF(TODAY()>=h2g(E52),G52,\"\"))","v":""}]
[null,null,null,35,"1447/12/25",35750,1375,{"$f":"IF(D53=\"\",\"\",IF(TODAY()>=h2g(E53),G53,\"\"))","v":""}]
[null,null,null,36,"1448/01/25",34375,1375,{"$f":"IF(D54=\"\",\"\",IF(TODAY()>=h2g(E54),G54,\"\"))","v":""}]
[null,null,null,37,"1448/02/25",33000,1375,{"$f":"IF(D55=\"\",\"\",IF(TODAY()>=h2g(E55),G55,\"\"))","v":""}]
[null,null,null,38,"1448/03/25",31625,1375,{"$f":"IF(D56=\"\",\"\",IF(TODAY()>=h2g(E56),G56,\"\"))","v":""}]
[null,null,null,39,"1448/04/25",30250,1375,{"$f":"IF(D57=\"\",\"\",IF(TODAY()>=h2g(E57),G57,\"\"))","v":""}]
[null,null,null,40,"1448/05/25",28875,1375,{"$f":"IF(D58=\"\",\"\",IF(TODAY()>=h2g(E58),G58,\"\"))","v":""}]

{"sheet":"الاقساط والاشهر","index":3,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"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}]

{"sheet":"نموذج","index":4,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[56,2,56,3],[56,5,56,7],[56,9,56,10],[59,2,59,10],[51,1,51,11],[52,3,52,7],[52,9,52,10],[54,2,54,3],[54,5,54,7],[54,9,54,10],[50,1,50,11],[39,2,39,3],[39,5,39,7],[39,9,39,10],[41,2,41,3],[41,5,41,7],[41,9,41,10],[44,1,44,11],[46,2,46,10],[48,2,48,4],[48,6,48,7],[48,9,48,10],[17,13,17,18],[19,2,19,7],[19,9,19,10],[37,3,37,7],[37,9,37,10],[23,1,23,9],[25,4,25,10],[27,2,27,3],[27,6,27,10],[29,2,29,10],[31,4,31,10],[33,4,33,6],[33,8,33,10],[34,1,34,10],[34,15,34,17],[35,1,35,10],[21,2,21,7],[12,1,12,4],[12,5,12,10],[14,1,14,2],[14,5,14,10],[17,2,17,7],[17,9,17,10],[14,13,14,18],[16,1,16,2],[1,9,1,10],[4,1,4,11],[6,1,6,10],[8,2,8,10],[10,3,10,4],[10,6,10,7],[10,9,10,10]]}
[]
[null," الرقم :",100,null,"    ",null,null,null,"التاريخ:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"إقـــــــــــــــــــــــــــــرار"]
[]
[null,"الحمد لله رب العالمين والصلاة والسلام على نبينا محمد وعلى آله وصحبه وسلم وبعد :"]
[]
[null,"أقــر أنـا :",{"$f":"VLOOKUP(C2,المقسطون!B26:L62,2,0)","v":"1900-04-09"}]
[]
[null,null,"رقــــم الهويــــة الوطنيـــــة :",null,null,"تاريخها :",null,null,"مصدرها :"]
[]
[null,"وأنــا بحـالتي المعتبـرة شـرعاً بأن عنـدي وفـي ذمتـي للأخ /"]
[]
[null,"مبلغــاً مـن المــال وقــدره :",null,null,"ريـــــــــــــال",{"$f":"IF(LEN($D$15)>0,B_Only(D15,1,0,2,\"ريال\",\"ريالان\",\"ريالات\"),\"\")","v":""}]
[]
[null," وذلك قيمة سيارة :"]
[null,"نوعهـــــــا :",null,null,null,null,null,null,"موديلها :"]
[]
[null,"رقم الهيكل :",null,null,null,null,null,null,"اللـــون :"]
[]
[null,"الحـــــــــالة:"]
[]
[null,"وإستلمتها بعد معاينتها وقبلتها بحالتها الراهنة ، على أن يكون السداد على النحو التالي :"]
[]
[null,"أولاً:","مدة التقسـيط",null,{"$f":"NoToTxt(D26,\"شـهراً\",\"\")","v":"صفر"}]
[null,null,null,0]
[null,"ثانياً :","أن أدفــع مبلغــاً مقدمـاً قــدره :",null,null,"ريـــــال",{"$f":"IF(LEN($E$28)>0,B_Only(E28,1,0,2,\"ريال\",\"ريالان\",\"ريالات\"),\"\")","v":""},null,null,null,null," "]
[]
[null,"ثالثاً :","أن أدفــع المتبــقي مــن قيمــة السيــارة عــلى أقســاط شـهريــة قيمــة كــل قســط :"]
[]
[null,null,null,"ريــــــــــــــال",{"$f":"IF(LEN($C$32)>0,B_Only(C32,1,0,2,\"ريال\",\"ريالان\",\"ريالات\"),\"\")","v":""}]
[]
[null,"تبدأ من شهر",null,"من تاريــــــخ :",null,null,null,"الى تاريخ",{"$f":"CONCATENATE(MID(E$34,1,4)+INT((MID(E$34,6,2)+D$26-2)/12),\"/\",TEXT(IF(MOD(MID(E$34,6,2)+D26,12)>1,MOD(MID(E$34,6,2)+D$26-1,12),MOD(MID(E$34,6,2)+D$26,12)+11),\"00\"),\"/\",RIGHT(E34,2))","v":{"$error":"#VALUE!"}}]
[null,"ويستمر التقسيط حتى سداد كامل المبلغ 0وإنني أتعهد على نفسي بعدم تأخير أي قسط عن موعده او تأجيله أو المماطلة في الدفع "]
[null,"وأعطي على ذلك عهد الله وميثاقه المؤكد.وعليه جرى الإقرار والتوقيع والله على ذلك شهيد 0"]
[]
[null,"المقر بما فيه :","الإســــــــم :",null,null,null,null,null,"التوقيع :","..............................."]
[]
[null,"الوظيفـــــة :",null,null,"جهة العمل :",null,null,null,"قسم :"]
[]
[null,"هاتف العمل :",null,null,"هاتف المنزل :",null,null,null,"جوال :"]
[]
[]
[null,"إقرار كفالة غرم وأداء"]
[]
[null,"أقــر أنـا :"]
[]
[null,"الهوية الوطنية :",null,null,null,"تاريخها :",null,null,"مصـدرها :"]
[]
[null,"أقر بأنني أكفل الطرف الثاني كفالة غرم وأداء إذا تأخر في دفع ما عليه من مسستحقات وأتحمل المسئولية كاملة في دفع هذه المستحقات "]
[null,"في مواعيدها المحددة بالإتفاق المتقدم ذكره "]
[null,"الكفيل الغارم :","الإســــم :",null,null,null,null,null,"التوقيع :","..............................."]
[]
[null,"الوظيفـــــة :",null,null,"جهة العمل :",null,null,null,"قسم :"]
[]
[null,"هاتف العمل :",null,null,"هاتف المنزل :",null,null,null,"جوال :"]
[]
[]
[null,"ملاحظـة :"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الشهور"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"محرم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"صفر"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"ربيع الأول"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"ربيع الأخر"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"جمادى الأولى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"جمادى الأخرة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"رجب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"شعبان"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"رمضان"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"شوال"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"ذو القعدة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"ذو الحجة"]

{"sheet":"data","index":5,"n_rows":3,"n_cols":37,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37]
["الرقم","التاريخ","اسم المشتري","الهوية الوطنية","تاريخها","مصدرها","اسم البائع","المبلغ","نوع السيارة","مودليها","رقم الهيكل","لون السيارة","حالة السيارة","مدة القسط","المقدم","القسط الشهري","شهر القسط","تاريخ القسط","اسم المشتري","الوظيفة","جهة العمل","قسم","هاتف العمل","هاتف المنزل","جوال المشتري","اسم الكفيل","ر هوية وطنية","تاريخها","مصدرها","اسم الكفيل","الوظيفة","جهة العمل","قسم","هاتف العمل","هاتف المنزل","جوال الكفيل","ملاحظات"]
[100,null,null,null,null,null,"محمد",5464,null,null,null,null,null,30,3232,null,null,"1436/09/25"]

{"sheet":"check List","index":6,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[3,"اسم المشتري"]
[4,"الهوية الوطنية"]
[5,"تاريخها"]
[6,"مصدرها"]
[7,"اسم البائع"]
[8,"المبلغ"]
[9,"نوع السيارة"]
[10,"مودليها"]
[11,"رقم الهيكل"]
[12,"لون السيارة"]
[13,"حالة السيارة"]
[14,"مدة القسط"]
[15,"المقدم"]
[16,"القسط الشهري"]
[17,"شهر القسط"]
[18,"تاريخ القسط"]
[20,"الوظيفة"]
[21,"جهة العمل"]
[22,"قسم"]
[23,"هاتف العمل"]
[24,"هاتف المنزل"]
[25,"جوال المشتري"]
[26,"اسم الكفيل"]
[27,"ر هوية وطنية"]
[28,"تاريخها"]
[29,"مصدرها"]
[31,"الوظيفة"]
[32,"جهة العمل"]
[33,"قسم"]
[34,"هاتف العمل"]
[35,"هاتف المنزل"]
[36,"جوال الكفيل"]

{"sheet":"المبالغ المتاخره","index":7,"n_rows":46,"n_cols":43,"rows_kept":46,"cut":false,"hidden":false,"merged":[[15,4,15,7],[16,4,16,7],[14,1,14,3],[15,1,15,3],[3,1,3,2],[4,1,4,2],[6,0,7,0],[6,1,7,1],[1,1,1,7],[3,3,3,7],[14,4,14,7],[12,5,12,7],[11,3,11,4],[6,3,6,4],[7,3,7,4],[11,5,11,7],[12,3,12,4],[7,5,7,7],[6,5,6,7],[4,3,4,7],[9,5,9,7]]}
[]
[null," الفرق بين التاريخين  عدد السنين بخلية وعدد الاشهر بخلية وعدد الأيام بخلية"]
[]
[null,"تاريخ بداية العقد بالهجري",null,"تاريخ نهاية العقد بالهجري"]
[null,"1442/3/03",null,"1444/1/03"]
[]
[null,"مدة الخدمة ","عدد السنوات","عدد الأشهر",null,"عدد الأيام"]
[null,null,{"$f":"kh_count_y_m_d($B$5,$D$5,\"y\",1)","v":1},{"$f":"kh_count_y_m_d($B$5,$D$5,\"m\",1)","v":10},null,{"$f":"kh_count_y_m_d($B$5,$D$5,\"d\",1)","v":22}]
[]
[null,null,"1443/01/01",null,null,{"$f":"ConvertDate(C10)","v":"2021/08/09"}]
[]
[null,null,"تاريخ الفاتورة","عدد الأشهر",null,"تاريخ الإنتهاء"]
[null,null,"2020-12-09",5,null,{"$f":"MID(TEXT(C13,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(C13+ROUND((D13)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+C13+ROUND((D13)*354.367056/12,0)","v":"2021-05-05"}]
[]
[null,"=TEXT(B35,\"[$-,197000]B2dd/mm/yyyy;@\")",null,null,"2020-03-01"]
[null,"=TEXT(B35,\"[$-,197000]B2dd/mm/yyyy;@\")",null,null,{"$f":"TEXT(E15,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2020/03/01"}]
[null,null,null,null,{"$f":"TEXT(E15,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1441/07/06"}]
[]
[null,"رقم الملف","الاسم",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,100," محمد المغيصيب      "]
[null,200," محمد عائض عسيري"]
[null,300," صاهود الصاهود"]
[null,400,"عبدالرحمن ال عايد"]
[null,500,"علي زاهر الشهري      "]
[null,600," محمد المرداوي      "]
[null,700," ناصر ابراهيم ال حيان      "]
[null,800," ابراهيم بن ناصر ال حيان      "]
[null,900," بندربن ناصر الدوسري      "]
[null,1000," علي بن زاهر الشهري      "]
[null,1100," خالد ابراهيم الدعيجي      "]
[null,1200," صاهود بن سليم الصاهود      "]
[null,1300,"محمد ابراهيم المغصيب      "]
[null,1400,"محمد بن خليفة الوهابي      "]
[null,1500," خلود الجنوبي     "]
[null,1600," صاهود بن سليم الصاهود      "]
[null,1700," محمد إبراهيم المغيصيب   "]
[null,1800," صاهود بن سليم الصاهود      "]
[null,1900," خالد ابراهيم الدعيجي    "]
[null,2000,"فهد بن عبدالله المريشد"]
[null,2100,"سعد سعود القريني"]
[null,2200,"ناصر خالد بن بديع"]
[null,2300,"خالد إبراهيم الدعيجي"]
[null,2400,"خالد إبراهيم الدعيجي",2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[null,2500,"عبدالرحمن بن عبدالله بن عتيق",null,null,null,null,null,null,null,null,null,null,null,null,2000,null,null,null,null,null,null,2000]
[null,2600,"خالد إبراهيم الدعيجي"]
[null,2700,"عبدالرحمن عبدالله السويد"]