{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["المقسطون","حركة تسديد عميل"," تسديد عميل","الاقساط والاشهر","نموذج","data"," الفرق بين التاريخين "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":296,"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":[[23,1,23,3],[3,3,3,7],[1,5,1,7],[23,12,23,13],[4,11,5,13],[4,8,5,9],[14,9,14,10],[5,5,5,6],[7,5,7,6],[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,"ملف العميــل",2600,"الاســم ",{"$f":"VLOOKUP(D2,B27:K62,2,0)","v":1},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2023-11-19"}]
[]
[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":70000},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D2,B27:K62,3,1)","v":35},null,{"$f":"D12","v":"2021-03-27"},{"$f":"D13","v":"2023-12-26"}]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I8*(J8%+5%))","v":20000},null,{"$f":"TEXT(L8,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2021/03/27"},{"$f":"TEXT(M8,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2023-12-27"}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D2,B27:K62,6,0)","v":2000},null,"الأقساط التأخرة ",{"$f":"'حركة تسديد عميل'!E6","v":0},null,"بعد الزيادة",{"$f":"SUM(I8+J9)","v":70000},null,{"$f":"TEXT(L8+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1442/08/15"},{"$f":"TEXT(M8+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1445/06/14"}]
[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":64000},null,"المبــالغ المتأخرة ",{"$f":"'حركة تسديد عميل'!E7","v":0},null,"القسط الشهري",{"$f":"SUM(J10/J8)","v":2000}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D2,B27:K62,7,0)","v":"2021-03-27"},null,null,null,null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D2,B27:K62,8,0)","v":"2023-12-26"},null,"المدة",{"$f":"(D8-D9)/D10","v":35}]
[null,null,"الأشهر المسددة",{"$f":"(D11/D10)","v":32},null,"الربح كامل",{"$f":"D8-D7","v":20000},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,"الأشهر المتبقية",{"$f":"D17/D10","v":3},null,"الربح الشهري",{"$f":"G14/G13","v":571.42857142857144},null,{"$f":"D2","v":2600},{"$f":"F2","v":1},null,{"$f":"G13","v":35},{"$f":"D12","v":"2021-03-27"},{"$f":"D13","v":"2023-12-26"}]
[null,null,null,null,null,"النسبة ",{"$f":"(G14/(D7-D9))*100","v":40},null,"حالة الاشهر وقيمة العقد",null,null,null,{"$f":"TEXT(M15,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2021/03/27"},{"$f":"EDATE(M16,L15)","v":"2024-02-27"}]
[null,null,"الباقي من المبلغ",{"$f":"D8-D11","v":6000},null,"النسبة السنوية",{"$f":"(G16/G13)*12","v":13.714285714285714},null,"الأشهر المسددة",{"$f":"'حركة تسديد عميل'!H7","v":0},"المبــالغ المســدة",{"$f":"(J17*D10)","v":0},"نسبة السداد بـ  %"]
[null,null,"الخصم",{"$f":"((D17*G17%)*(D15/12))/(1+((G17%)*(D15/12)))","v":198.89502762430939},null,"النسبة الشهرية",{"$f":"G16/G13","v":1.1428571428571428},null,"الأشهر المتبقية",{"$f":"L15-J17","v":35},"المبــالغ المتبـقية",{"$f":"'حركة تسديد عميل'!H10","v":42700},{"$f":"L17/D8","v":0}]
[null,null,"المطلوب",{"$f":"D17-D18","v":5801.1049723756905},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,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )"]
[]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد"]
[null,100,1,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,1,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,1,40,45000,46400,1160,"2010-03-10","2013-05-05",20250,0,"العقـد منتهى"]
[null,400,1,40,45000,39160,979,"2010-06-07","2013-08-01",20250,0,"العقـد منتهى"]
[null,500,1,40,45000,43520,1088,"2010-11-01","2013-12-28",20250,0,"العقـد منتهى"]
[null,600,1,40,45000,69024,5507,"2010-12-31","2014-02-25",20250,0,"العقـد منتهى"]
[null,700,1,40,45000,38124,2118,"2011-01-30","2014-03-26",20250,0,"العقـد منتهى"]
[null,800,1,40,45000,57592,2504,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,900,1,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1000,1,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1100,1,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1200,1,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1300,1,40,45000,76850,1921,"2011-11-21","2015-01-15",20250,0,"العقـد منتهى"]
[null,1400,1,40,45000,62360,1559,"2012-02-17","2015-04-14",20250,0,"العقـد منتهى"]
[null,1500,1,40,45000,60900,1523,"2012-03-18","2015-05-13",20250,0,"العقـد منتهى"]
[null,1600,1,40,45000,50760,1269,"2014-06-23","2017-08-17",20250,0,"العقـد منتهى"]
[null,1700,1,40,45000,50760,1269,"2014-10-19","2017-12-13",20250,0,"العقـد منتهى"]
[null,1800,1,40,45000,53640,{"$f":"F44/D44","v":1341},"2015-01-15","2018-03-12",20250,0,"العقـد منتهى"]
[null,1900,1,40,45000,60920,1523,"2015-05-13","2018-07-08",20250,0,"العقـد منتهى"]
[null,2000,1,40,45000,60750,1518.75,"2015-07-11","2018-09-05",20250,0,"العقـد منتهى"]
[null,2100,1,40,45000,105624,2640.6,"2017-02-21","2020-04-18",20250,0,"العقـد منتهى"]
[null,2200,1,40,45000,{"$f":"E48+J48","v":65250},1631.25,"2018-01-12","2021-03-08",20250,0,"العقـد منتهى"]
[null,2300,1,40,45000,65250,1631.25,"2018-04-10","2021-06-05",20250,0,"سداد مبكر","2019-02-07",39889]
[null,2400,1,35,50000,70000,2000,"2019-11-01","2022-08-01",20000,{"$f":"G50","v":2000},"العقـد منتهى"]
[null,2500,1,35,50000,70000,2000,"2020-09-25",{"$f":"MID(TEXT(H51,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H51+ROUND((D51-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H51+ROUND((D51-1)*354.367056/12,0)","v":"2023-06-26"},20000,2000,"العقـد منتهى"]
[null,2600,1,35,50000,70000,2000,"2021-03-27",{"$f":"MID(TEXT(H52,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H52+ROUND((D52-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H52+ROUND((D52-1)*354.367056/12,0)","v":"2023-12-26"},20000,2000,"العقـد سارى"]
[null,2700,1,35,50000,70000,{"$f":"F53/D53","v":2000},"2022-01-27",{"$f":"MID(TEXT(H53,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H53+ROUND((D53-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H53+ROUND((D53-1)*354.367056/12,0)","v":"2024-10-27"},{"$f":"SUM(E53*(D53%+5%))","v":20000},2000,{"$f":"IFERROR(IF(AND(M53<>\"\",M53<I53),\"سداد مبكر\",IF(TODAY()=I53,\"العقد انتهى اليوم\",IF(TODAY()>I53,\"العقـد منتهى\",IF(TODAY()<H53,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"سداد مبكر"},"2022-10-24",46781]
[null,2800,1,60,50000,82500,{"$f":"F54/60","v":1375},"2023-08-27",{"$f":"MID(TEXT(H54,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H54+ROUND((D54-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H54+ROUND((D54-1)*354.367056/12,0)","v":"2028-06-03"},32500,1375,"العقـد سارى"]
[null,2900,1,17,35000,42700,{"$f":"F55/D55","v":2511.7647058823532},"2023-11-27",{"$f":"MID(TEXT(H55,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H55+ROUND((D55-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H55+ROUND((D55-1)*354.367056/12,0)","v":"2025-03-14"},7700.0000000000009,2511.7647058823532,"لم يتم تداولة"]
[null,null,null,null,null,null,{"$f":"F56/40","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,"`"]
[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":1320000},{"$f":"SUM(F27:F62)","v":1733984},null,null,null,{"$f":"SUM(J27:J62)","v":585950},{"$f":"SUM(K27:K62)","v":11886.764705882353}]

{"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]]}
[]
["ملف العميــل",2900,"الاســم",{"$f":"VLOOKUP(B2,المقسطون!B26:I61,2,0)","v":1},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2023-11-19"}]
[]
[]
[null,"مدة العقد (بالاشهر)",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,3,0)","v":17},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-11-27"},"المبــالغ المتأخرة ",{"$f":"IFERROR(SUM(I19:I58),\"\")","v":0},null,"الأشهر المسددة",{"$f":"IF(COUNT(H19:H58)>C9,C9,COUNT(H19:H58))-E6","v":0}]
[null,null,{"$f":"TEXT(C7,\"[$-,197000]B2yyyy/mm/dd;@\")","v":"2023/11/27"},"تقيــم العــــميل",{"$f":"IF(E6=0,\"عميل مميز\",IF(E6=1,\"عميل جيد جداً\",IF(E6=2,\"عميل جيد\",IF(E6>=3,\"بلاك لست Blacklist\"))))","v":"عميل مميز"},null,"الأشهر المتبقية",{"$f":"C5-H7","v":17}]
[null," نهاية العقد",{"$f":"TEXT(C7+((C5-1)*29.5),\"B2yyyy/mm/\")&TEXT(C7,\"B2dd\")","v":"1446/09/15"},null,null,null,"المبــالغ المســدة",{"$f":"SUM(H7*C11)","v":0}]
[null,null,{"$f":"ConvertDate(C9)+1","v":"2025-03-15"},null,null,null,"المبــالغ المتبـقية",{"$f":"SUM(H8*C11)","v":42700}]
[null,"القســـــــط ",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,6,0)","v":2511.7647058823532},null,null,null,"نسبة السداد بـ  %",{"$f":"H9/C14","v":0}]
[null,"السعر النقدي ",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,4,0)","v":35000}]
[null,"الربـــــــــح ",{"$f":"VLOOKUP(B2,المقسطون!B27:N62,9,0)","v":7700.0000000000009},null,null,null,"الســداد المبكـر"]
[null,"قيمة العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$26:$H$61,5,0)","v":42700},"حركة تسديد عميل",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/05/15"},{"$f":"IF(D19<>\"\",ConvertDate(D19),\"\")","v":"2023/11/27"},{"$f":"C14","v":42700},{"$f":"IF($D$19=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":2511.7647058823532},{"$f":"IF(I19<>\"\",G19-I19,IF(C19=\"\",\"\",IF(TODAY()>=h2g(D19),G19,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/06/15"},{"$f":"IF(D20<>\"\",ConvertDate(D20),\"\")","v":"2023/12/27"},{"$f":"IF(D20=\"\",\"\",F19-G20)","v":40188.23529411765},{"$f":"IF($D$19=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":2511.7647058823532},{"$f":"IF(I20<>\"\",G20-I20,IF(C20=\"\",\"\",IF(TODAY()>=h2g(D20),G20,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/07/15"},"2024/01/25",{"$f":"IF(D21=\"\",\"\",F20-G21)","v":37676.470588235301},2511.7647058823532,{"$f":"IF(I21<>\"\",G21-I21,IF(C21=\"\",\"\",IF(TODAY()>=h2g(D21),G21,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/08/15"},"2024/02/24",35164.705882352951,2511.7647058823532,{"$f":"IF(I22<>\"\",G22-I22,IF(C22=\"\",\"\",IF(TODAY()>=h2g(D22),G22,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/09/15"},"2024/03/24",32652.941176470598,2511.7647058823532,{"$f":"IF(I23<>\"\",G23-I23,IF(C23=\"\",\"\",IF(TODAY()>=h2g(D23),G23,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/10/15"},"2024/04/23",30141.176470588245,2511.7647058823532,{"$f":"IF(I24<>\"\",G24-I24,IF(C24=\"\",\"\",IF(TODAY()>=h2g(D24),G24,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/11/15"},"2024/05/22",27629.411764705892,2511.7647058823532,{"$f":"IF(I25<>\"\",G25-I25,IF(C25=\"\",\"\",IF(TODAY()>=h2g(D25),G25,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/12/15"},"2024/06/21",25117.647058823539,2511.7647058823532,{"$f":"IF(I26<>\"\",G26-I26,IF(C26=\"\",\"\",IF(TODAY()>=h2g(D26),G26,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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":"1446/01/15"},"2024/07/21",22605.882352941186,2511.7647058823532,{"$f":"IF(I27<>\"\",G27-I27,IF(C27=\"\",\"\",IF(TODAY()>=h2g(D27),G27,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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":"1446/02/15"},"2024/08/20",20094.117647058833,2511.7647058823532,{"$f":"IF(I28<>\"\",G28-I28,IF(C28=\"\",\"\",IF(TODAY()>=h2g(D28),G28,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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":"1446/03/15"},"2024/09/18",17582.352941176479,2511.7647058823532,{"$f":"IF(I29<>\"\",G29-I29,IF(C29=\"\",\"\",IF(TODAY()>=h2g(D29),G29,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/04/15"},"2024/10/18",15070.588235294126,2511.7647058823532,{"$f":"IF(I30<>\"\",G30-I30,IF(C30=\"\",\"\",IF(TODAY()>=h2g(D30),G30,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/05/15"},"2024/11/16",12558.823529411773,2511.7647058823532,{"$f":"IF(I31<>\"\",G31-I31,IF(C31=\"\",\"\",IF(TODAY()>=h2g(D31),G31,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/06/15"},"2024/12/16",10047.05882352942,2511.7647058823532,{"$f":"IF(I32<>\"\",G32-I32,IF(C32=\"\",\"\",IF(TODAY()>=h2g(D32),G32,\"\")))","v":""}]
[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/07/15"},"2025/01/14",7535.2941176470667,2511.7647058823532,{"$f":"IF(I33<>\"\",G33-I33,IF(C33=\"\",\"\",IF(TODAY()>=h2g(D33),G33,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/08/15"},{"$f":"IF(D34<>\"\",ConvertDate(D34),\"\")","v":"2025/02/13"},5023.5294117647136,2511.7647058823532,{"$f":"IF(I34<>\"\",G34-I34,IF(C34=\"\",\"\",IF(TODAY()>=h2g(D34),G34,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[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/09/15"},"2025/03/14",2511.7647058823604,2511.7647058823532,{"$f":"IF(I35<>\"\",G35-I35,IF(C35=\"\",\"\",IF(TODAY()>=h2g(D35),G35,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I36<>\"\",G36-I36,IF(C36=\"\",\"\",IF(TODAY()>=h2g(D36),G36,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I37<>\"\",G37-I37,IF(C37=\"\",\"\",IF(TODAY()>=h2g(D37),G37,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I38<>\"\",G38-I38,IF(C38=\"\",\"\",IF(TODAY()>=h2g(D38),G38,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I39<>\"\",G39-I39,IF(C39=\"\",\"\",IF(TODAY()>=h2g(D39),G39,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I40<>\"\",G40-I40,IF(C40=\"\",\"\",IF(TODAY()>=h2g(D40),G40,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I41<>\"\",G41-I41,IF(C41=\"\",\"\",IF(TODAY()>=h2g(D41),G41,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I42<>\"\",G42-I42,IF(C42=\"\",\"\",IF(TODAY()>=h2g(D42),G42,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I43<>\"\",G43-I43,IF(C43=\"\",\"\",IF(TODAY()>=h2g(D43),G43,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I44<>\"\",G44-I44,IF(C44=\"\",\"\",IF(TODAY()>=h2g(D44),G44,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I45<>\"\",G45-I45,IF(C45=\"\",\"\",IF(TODAY()>=h2g(D45),G45,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I46<>\"\",G46-I46,IF(C46=\"\",\"\",IF(TODAY()>=h2g(D46),G46,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I47<>\"\",G47-I47,IF(C47=\"\",\"\",IF(TODAY()>=h2g(D47),G47,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I48<>\"\",G48-I48,IF(C48=\"\",\"\",IF(TODAY()>=h2g(D48),G48,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I49<>\"\",G49-I49,IF(C49=\"\",\"\",IF(TODAY()>=h2g(D49),G49,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I51<>\"\",G51-I51,IF(C51=\"\",\"\",IF(TODAY()>=h2g(D51),G51,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I52<>\"\",G52-I52,IF(C52=\"\",\"\",IF(TODAY()>=h2g(D52),G52,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I53<>\"\",G53-I53,IF(C53=\"\",\"\",IF(TODAY()>=h2g(D53),G53,\"\")))","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I54<>\"\",G54-I54,IF(C54=\"\",\"\",IF(TODAY()>=h2g(D54),G54,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I55<>\"\",G55-I55,IF(C55=\"\",\"\",IF(TODAY()>=h2g(D55),G55,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I56<>\"\",G56-I56,IF(C56=\"\",\"\",IF(TODAY()>=h2g(D56),G56,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I57<>\"\",G57-I57,IF(C57=\"\",\"\",IF(TODAY()>=h2g(D57),G57,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I58<>\"\",G58-I58,IF(C58=\"\",\"\",IF(TODAY()>=h2g(D58),G58,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,{"$f":"IF(D59=\"\",\"\",ROW()-18)","v":""},{"$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":""},{"$f":"IF(D59<>\"\",ConvertDate(D59),\"\")","v":""},{"$f":"IF(D59=\"\",\"\",F58-G59)","v":""},2511.7647058823532,{"$f":"IF(I59<>\"\",G59-I59,IF(C59=\"\",\"\",IF(TODAY()>=h2g(D59),G59,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I60<>\"\",G60-I60,IF(C60=\"\",\"\",IF(TODAY()>=h2g(D60),G60,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I61<>\"\",G61-I61,IF(C61=\"\",\"\",IF(TODAY()>=h2g(D61),G61,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I62<>\"\",G62-I62,IF(C62=\"\",\"\",IF(TODAY()>=h2g(D62),G62,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I63<>\"\",G63-I63,IF(C63=\"\",\"\",IF(TODAY()>=h2g(D63),G63,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I64<>\"\",G64-I64,IF(C64=\"\",\"\",IF(TODAY()>=h2g(D64),G64,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I65<>\"\",G65-I65,IF(C65=\"\",\"\",IF(TODAY()>=h2g(D65),G65,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,{"$f":"IF(D66=\"\",\"\",ROW()-18)","v":""},{"$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":""},{"$f":"IF(D66<>\"\",ConvertDate(D66),\"\")","v":""},{"$f":"IF(D66=\"\",\"\",F65-G66)","v":""},2511.7647058823532,{"$f":"IF(I66<>\"\",G66-I66,IF(C66=\"\",\"\",IF(TODAY()>=h2g(D66),G66,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I67<>\"\",G67-I67,IF(C67=\"\",\"\",IF(TODAY()>=h2g(D67),G67,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I68<>\"\",G68-I68,IF(C68=\"\",\"\",IF(TODAY()>=h2g(D68),G68,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I69<>\"\",G69-I69,IF(C69=\"\",\"\",IF(TODAY()>=h2g(D69),G69,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I70<>\"\",G70-I70,IF(C70=\"\",\"\",IF(TODAY()>=h2g(D70),G70,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I71<>\"\",G71-I71,IF(C71=\"\",\"\",IF(TODAY()>=h2g(D71),G71,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I72<>\"\",G72-I72,IF(C72=\"\",\"\",IF(TODAY()>=h2g(D72),G72,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I73<>\"\",G73-I73,IF(C73=\"\",\"\",IF(TODAY()>=h2g(D73),G73,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I74<>\"\",G74-I74,IF(C74=\"\",\"\",IF(TODAY()>=h2g(D74),G74,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I75<>\"\",G75-I75,IF(C75=\"\",\"\",IF(TODAY()>=h2g(D75),G75,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I76<>\"\",G76-I76,IF(C76=\"\",\"\",IF(TODAY()>=h2g(D76),G76,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I77<>\"\",G77-I77,IF(C77=\"\",\"\",IF(TODAY()>=h2g(D77),G77,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]
[null,null,"",{"$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":""},"","",2511.7647058823532,{"$f":"IF(I78<>\"\",G78-I78,IF(C78=\"\",\"\",IF(TODAY()>=h2g(D78),G78,\"\")))","v":""},{"$f":"IFERROR(IF(VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)=0,\"\",VLOOKUP($B$2,' الفرق بين التاريخين '!#REF!,ROW()-16,0)),\"\")","v":""}]

{"sheet":" تسديد عميل","index":2,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":false,"merged":[[15,4,16,5]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2023-11-19"}]
[null,"ملف العميــل",2900,"الاســـــم ",{"$f":"VLOOKUP(' تسديد عميل'!C6,المقسطون!B26:I61,2,0)","v":1}]
[]
[null,null,null,"مدة القرض (بالاشهر)",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,3,0)","v":17},null,"القسـط الشهري",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,6,0)","v":2511.7647058823532}]
[null,null,null,"تاريـخ بدايـة القـرض",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,7,0)","v":"2023-11-27"},null,"الســعر النقـدي ",{"$f":"VLOOKUP(C6,المقسطون!$B$26:$H$61,4,0)","v":35000}]
[null,null,null,"تاريـخ نهايـة القـرض",{"$f":"TEXT(E9+((E8-1)*29.5),\"B2yyyy/mm/\")&TEXT(E9,\"B2dd\")","v":"1446/09/15"},null,"الربــــــــــــح ",{"$f":"VLOOKUP(C6,المقسطون!B26:K61,9,0)","v":7700.0000000000009}]
[null,null,null,"حــــــالة العقـــــــد",{"$f":"VLOOKUP(C6,المقسطون!B27:N62,11,0)","v":"لم يتم تداولة"},null,"قيمــة القــرض",{"$f":"VLOOKUP(C6,المقسطون!B26:I61,5,0)","v":42700}]
[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":42700}]
[null,null,null,null,null,null,"الأشهر المسددة",{"$f":"(H12/H8)","v":0}]
[null,null,null,null,null,null,"الأشهر المتبقية",{"$f":"H13/H8","v":17}]
[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/05/15"},{"$f":"H11","v":42700},{"$f":"IF(E19=\"\",\"\",IF($H$11=\"\",\"\",$H$11/$E$8))","v":2511.7647058823532},{"$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/06/15"},{"$f":"IF(E20=\"\",\"\",F19-G20)","v":40188.23529411765},2511.7647058823532,{"$f":"IF(D20=\"\",\"\",IF(TODAY()>=h2g(E20),G20,\"\"))","v":""}]
[null,null,null,3,"1445/07/15",{"$f":"IF(E21=\"\",\"\",F20-G21)","v":37676.470588235301},2511.7647058823532,{"$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/08/15"},35164.705882352951,2511.7647058823532,{"$f":"IF(D22=\"\",\"\",IF(TODAY()>=h2g(E22),G22,\"\"))","v":""}]
[null,null,null,5,"1445/09/15",32652.941176470598,2511.7647058823532,{"$f":"IF(D23=\"\",\"\",IF(TODAY()>=h2g(E23),G23,\"\"))","v":""}]
[null,null,null,6,"1445/10/15",30141.176470588245,2511.7647058823532,{"$f":"IF(D24=\"\",\"\",IF(TODAY()>=h2g(E24),G24,\"\"))","v":""}]
[null,null,null,7,"1445/11/15",27629.411764705892,2511.7647058823532,{"$f":"IF(D25=\"\",\"\",IF(TODAY()>=h2g(E25),G25,\"\"))","v":""}]
[null,null,null,8,"1445/12/15",25117.647058823539,2511.7647058823532,{"$f":"IF(D26=\"\",\"\",IF(TODAY()>=h2g(E26),G26,\"\"))","v":""}]
[null,null,null,9,"1446/01/15",22605.882352941186,2511.7647058823532,{"$f":"IF(D27=\"\",\"\",IF(TODAY()>=h2g(E27),G27,\"\"))","v":""}]
[null,null,null,10,"1446/02/15",20094.117647058833,2511.7647058823532,{"$f":"IF(D28=\"\",\"\",IF(TODAY()>=h2g(E28),G28,\"\"))","v":""}]
[null,null,null,11,"1446/03/15",17582.352941176479,2511.7647058823532,{"$f":"IF(D29=\"\",\"\",IF(TODAY()>=h2g(E29),G29,\"\"))","v":""}]
[null,null,null,12,"1446/04/15",15070.588235294126,2511.7647058823532,{"$f":"IF(D30=\"\",\"\",IF(TODAY()>=h2g(E30),G30,\"\"))","v":""}]
[null,null,null,13,"1446/05/15",12558.823529411773,2511.7647058823532,{"$f":"IF(D31=\"\",\"\",IF(TODAY()>=h2g(E31),G31,\"\"))","v":""}]
[null,null,null,14,"1446/06/15",10047.05882352942,2511.7647058823532,{"$f":"IF(D32=\"\",\"\",IF(TODAY()>=h2g(E32),G32,\"\"))","v":""}]
[null,null,null,15,"1446/07/15",7535.2941176470667,2511.7647058823532,{"$f":"IF(D33=\"\",\"\",IF(TODAY()>=h2g(E33),G33,\"\"))","v":""}]
[null,null,null,16,"1446/08/15",5023.5294117647136,2511.7647058823532,{"$f":"IF(D34=\"\",\"\",IF(TODAY()>=h2g(E34),G34,\"\"))","v":""}]
[null,null,null,17,"1446/09/15",2511.7647058823604,2511.7647058823532,{"$f":"IF(D35=\"\",\"\",IF(TODAY()>=h2g(E35),G35,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D36=\"\",\"\",IF(TODAY()>=h2g(E36),G36,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D37=\"\",\"\",IF(TODAY()>=h2g(E37),G37,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D38=\"\",\"\",IF(TODAY()>=h2g(E38),G38,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D39=\"\",\"\",IF(TODAY()>=h2g(E39),G39,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D40=\"\",\"\",IF(TODAY()>=h2g(E40),G40,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D41=\"\",\"\",IF(TODAY()>=h2g(E41),G41,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D42=\"\",\"\",IF(TODAY()>=h2g(E42),G42,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D43=\"\",\"\",IF(TODAY()>=h2g(E43),G43,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D44=\"\",\"\",IF(TODAY()>=h2g(E44),G44,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D45=\"\",\"\",IF(TODAY()>=h2g(E45),G45,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D46=\"\",\"\",IF(TODAY()>=h2g(E46),G46,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D47=\"\",\"\",IF(TODAY()>=h2g(E47),G47,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D48=\"\",\"\",IF(TODAY()>=h2g(E48),G48,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D49=\"\",\"\",IF(TODAY()>=h2g(E49),G49,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D50=\"\",\"\",IF(TODAY()>=h2g(E50),G50,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D51=\"\",\"\",IF(TODAY()>=h2g(E51),G51,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D52=\"\",\"\",IF(TODAY()>=h2g(E52),G52,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D53=\"\",\"\",IF(TODAY()>=h2g(E53),G53,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D54=\"\",\"\",IF(TODAY()>=h2g(E54),G54,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D55=\"\",\"\",IF(TODAY()>=h2g(E55),G55,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D56=\"\",\"\",IF(TODAY()>=h2g(E56),G56,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D57=\"\",\"\",IF(TODAY()>=h2g(E57),G57,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D58=\"\",\"\",IF(TODAY()>=h2g(E58),G58,\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(D59=\"\",\"\",TEXT($E$9+((D59-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":""},{"$f":"IF(E59=\"\",\"\",F58-G59)","v":""},{"$f":"IF(E59=\"\",\"\",IF($H$11=\"\",\"\",$H$11/$E$8))","v":""},{"$f":"IF(D59=\"\",\"\",IF(TODAY()>=h2g(E59),G59,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D60=\"\",\"\",IF(TODAY()>=h2g(E60),G60,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D61=\"\",\"\",IF(TODAY()>=h2g(E61),G61,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D62=\"\",\"\",IF(TODAY()>=h2g(E62),G62,\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(D63=\"\",\"\",TEXT($E$9+((D63-1)*29.5),\"B2yyyy/mm/\")&TEXT($E$9,\"B2dd\"))","v":""},{"$f":"IF(E63=\"\",\"\",F62-G63)","v":""},{"$f":"IF(E63=\"\",\"\",IF($H$11=\"\",\"\",$H$11/$E$8))","v":""},{"$f":"IF(D63=\"\",\"\",IF(TODAY()>=h2g(E63),G63,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D64=\"\",\"\",IF(TODAY()>=h2g(E64),G64,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D65=\"\",\"\",IF(TODAY()>=h2g(E65),G65,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D66=\"\",\"\",IF(TODAY()>=h2g(E66),G66,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D67=\"\",\"\",IF(TODAY()>=h2g(E67),G67,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D68=\"\",\"\",IF(TODAY()>=h2g(E68),G68,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D69=\"\",\"\",IF(TODAY()>=h2g(E69),G69,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D70=\"\",\"\",IF(TODAY()>=h2g(E70),G70,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D71=\"\",\"\",IF(TODAY()>=h2g(E71),G71,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D72=\"\",\"\",IF(TODAY()>=h2g(E72),G72,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D73=\"\",\"\",IF(TODAY()>=h2g(E73),G73,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D74=\"\",\"\",IF(TODAY()>=h2g(E74),G74,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D75=\"\",\"\",IF(TODAY()>=h2g(E75),G75,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D76=\"\",\"\",IF(TODAY()>=h2g(E76),G76,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D77=\"\",\"\",IF(TODAY()>=h2g(E77),G77,\"\"))","v":""}]
[null,null,null,"","","","",{"$f":"IF(D78=\"\",\"\",IF(TODAY()>=h2g(E78),G78,\"\"))","v":""}]

{"sheet":"الاقساط والاشهر","index":3,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الشـــــــهر",60]
[]
[null,"المبلغ الاساسي",50000]
[null,"الـزيادة",{"$f":"INDEX(D10:D69,MATCH(C2,B10:B69,0))","v":32500}]
[null,"المبلغ بعد الزيادة",{"$f":"INDEX(C10:C69,MATCH(C2,B10:B69,0))","v":82500}]
[null,"القسط الشهري",{"$f":"INDEX(E10:E69,MATCH(C2,B10:B69,0))","v":1375}]
[]
[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}]
[null,41,{"$f":"C4+D50","v":73000},{"$f":"C4*0.46","v":23000},{"$f":"C50/41","v":1780.4878048780488}]
[null,42,{"$f":"C4+D51","v":73500},{"$f":"C4*0.47","v":23500},{"$f":"C51/42","v":1750}]
[null,43,{"$f":"C4+D52","v":74000},{"$f":"C4*0.48","v":24000},{"$f":"C52/43","v":1720.9302325581396}]
[null,44,{"$f":"C4+D53","v":74500},{"$f":"C4*0.49","v":24500},{"$f":"C53/44","v":1693.1818181818182}]
[null,45,{"$f":"C4+D54","v":75000},{"$f":"C4*0.5","v":25000},{"$f":"C54/45","v":1666.6666666666667}]
[null,46,{"$f":"C4+D55","v":75500},{"$f":"C4*0.51","v":25500},{"$f":"C55/46","v":1641.304347826087}]
[null,47,{"$f":"C4+D56","v":76000},{"$f":"C4*0.52","v":26000},{"$f":"C56/47","v":1617.0212765957447}]
[null,48,{"$f":"C4+D57","v":76500},{"$f":"C4*0.53","v":26500},{"$f":"C57/48","v":1593.75}]
[null,49,{"$f":"C4+D58","v":77000},{"$f":"C4*0.54","v":27000},{"$f":"C58/49","v":1571.4285714285713}]
[null,50,{"$f":"C4+D59","v":77500},{"$f":"C4*0.55","v":27500.000000000004},{"$f":"C59/50","v":1550}]
[null,51,{"$f":"C4+D60","v":78000},{"$f":"C4*0.56","v":28000.000000000004},{"$f":"C60/51","v":1529.4117647058824}]
[null,52,{"$f":"C4+D61","v":78500},{"$f":"C4*0.57","v":28499.999999999996},{"$f":"C61/52","v":1509.6153846153845}]
[null,53,{"$f":"C4+D62","v":79000},{"$f":"C4*0.58","v":28999.999999999996},{"$f":"C62/53","v":1490.566037735849}]
[null,54,{"$f":"C4+D63","v":79500},{"$f":"C4*0.59","v":29500},{"$f":"C63/54","v":1472.2222222222222}]
[null,55,{"$f":"C4+D64","v":80000},{"$f":"C4*0.6","v":30000},{"$f":"C64/55","v":1454.5454545454545}]
[null,56,{"$f":"C4+D65","v":80500},{"$f":"C4*0.61","v":30500},{"$f":"C65/56","v":1437.5}]
[null,57,{"$f":"C4+D66","v":81000},{"$f":"C4*0.62","v":31000},{"$f":"C66/57","v":1421.0526315789473}]
[null,58,{"$f":"C4+D67","v":81500},{"$f":"C4*0.63","v":31500},{"$f":"C67/58","v":1405.1724137931035}]
[null,59,{"$f":"C4+D68","v":82000},{"$f":"C4*0.64","v":32000},{"$f":"C68/59","v":1389.8305084745762}]
[null,60,{"$f":"C4+D69","v":82500},{"$f":"C4*0.65","v":32500},{"$f":"C69/60","v":1375}]

{"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-01-01"}]
[]
[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":" الفرق بين التاريخين ","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"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"}]