{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["المقسطون","حركة تسديد عميل","المبالغ المتاخره"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":169,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"المقسطون","index":0,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,5,1,7],[22,12,22,13],[3,11,4,13],[3,8,4,9],[22,2,22,5],[13,9,13,10],[4,5,4,6],[6,5,6,6],[16,5,16,6],[3,0,4,2],[12,9,12,10],[15,12,15,13],[16,12,16,13],[10,8,11,9],[14,8,14,11]]}
[]
[null,null,"ملف العميــل",100,"الاســم ",{"$f":"VLOOKUP(D2,B26:K61,2,0)","v":1},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-02-23"}]
[]
["نظـام الخصــم ",null,null,null,null,null,null,null,"حساب نســبة التقسـيط ",null,null,"نظام تحويل التاريخ من هجري لميلادي "]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D2,B26:K61,4,0)","v":45000},null,null,null,null,"السعر","الاشهر",null,"بداية التسديد ","نهاية التسديد"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D2,B26:K61,5,0)","v":46400},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D2,B26:K61,3,1)","v":40},null,{"$f":"D11","v":"2008-10-25"},{"$f":"D12","v":"2011-12-20"}]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I7*(J7%+5%))","v":22500},null,{"$f":"TEXT(L7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2008-10-26"},{"$f":"TEXT(M7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2011-12-21"}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D2,B26:K61,6,0)","v":1160},null,null,null,null,"بعد الزيادة",{"$f":"SUM(I7+J8)","v":72500},null,{"$f":"TEXT(L7+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1429/10/26"},{"$f":"TEXT(M7+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1433/01/26"}]
[null,null,"ماتم سداده من المبلغ",{"$f":"IF($D$11>$K$2,0,IF($D$12<$K$2,$D$7,(SUM(DATEDIF($D$11,$K$2,\"Y\")*12)+(DATEDIF($D$11,$K$2,\"ym\"))+(IF(DATEDIF($D$11,$K$2,\"md\")<>0,1,0)))*D9))","v":46400},null,"المدة",{"$f":"(D7-D8)/D9","v":40},null,"القسط الشهري",{"$f":"SUM(J9/J7)","v":1812.5}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D2,B26:K61,7,0)","v":"2008-10-25"},null,"الربح كامل",{"$f":"D7-D6","v":1400},null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D2,B26:K61,8,0)","v":"2011-12-20"},null,"الربح الشهري",{"$f":"G11/G10","v":35}]
[null,null,"الأشهر المسددة",{"$f":"(D10/D9)","v":40},null,"النسبة ",{"$f":"(G11/(D6-D8))*100","v":3.1111111111111112},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,"الأشهر المتبقية",{"$f":"D16/D9","v":0},null,"النسبة السنوية",{"$f":"(G13/G10)*12","v":0.93333333333333335},null,{"$f":"D2","v":100},{"$f":"F2","v":1},null,{"$f":"G10","v":40},{"$f":"D11","v":"2008-10-25"},{"$f":"D12","v":"2011-12-20"}]
[null,null,null,null,null,"النسبة الشهرية",{"$f":"G13/G10","v":7.7777777777777779E-2},null,"حالة الاشهر وقيمة العقد",null,null,null,{"$f":"TEXT(M14,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2008-10-26"},{"$f":"EDATE(M15,L14)","v":"2012-02-26"}]
[null,null,"الباقي من المبلغ",{"$f":"D7-D10","v":0},null,null,null,null,"الأشهر المسددة",{"$f":"'حركة تسديد عميل'!H7","v":39},"المبــالغ المســدة",{"$f":"(J16*D9)","v":45240},"نسبة السداد بـ  %"]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":0},null,null,null,null,"الأشهر المتبقية",{"$f":"L14-J16","v":1},"المبــالغ المتبـقية",{"$f":"(J17*D9)","v":1160},{"$f":"L16/D7","v":0.97499999999999998}]
[null,null,"المطلوب",{"$f":"D16-D17","v":0},null,null,null,null,"حـالة العقــد",{"$f":"VLOOKUP(D2,B26:N61,11,0)","v":"العقـد منتهى"},"مبلغ السداد المبكر",{"$f":"IF(J18=\"سداد مبكر\",INDEX(N26:N61,MATCH(J18,L26:L61,0)),\"\")","v":""},"تاريخ السداد المبكر",{"$f":"IF(J18=\"سداد مبكر\",INDEX(M26:M61,MATCH(J18,L26:L61,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D4,B27:L62,11,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"ملاحظة : اذا تم السداد قبل الموعد المحدد يتم إضافة 1000 ( الف ريال )"]
[]
[null,"رقم الملف","الاسم","مدة القرض ( بالشهر ) ","السعر النقدي","القيمة بعد التقسيط","القسط ","من","الى","الربــح ","الدخل الشهري","حـالة العقـد","سداد مبكر بتاريخ","المبلغ المسدد"]
[null,100,1,40,45000,46400,1160,"2008-10-25",{"$f":"MID(TEXT(H26,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H26+ROUND((D26-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H26+ROUND((D26-1)*354.367056/12,0)","v":"2011-12-20"},{"$f":"SUM(E26*(D26%+5%))","v":20250},0,{"$f":"IFERROR(IF(AND(M26<>\"\",M26<I26),\"سداد مبكر\",IF(TODAY()=I26,\"العقد انتهى اليوم\",IF(TODAY()>I26,\"العقـد منتهى\",IF(TODAY()<H26,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,200,2,40,45000,43500,1087,"2009-01-21","2012-03-18",20250,0,{"$f":"IFERROR(IF(AND(M27<>\"\",M27<I27),\"سداد مبكر\",IF(TODAY()=I27,\"العقد انتهى اليوم\",IF(TODAY()>I27,\"العقـد منتهى\",IF(TODAY()<H27,\"لم يتم تداولة\",\"العقـد سارى\")))),\"\")","v":"العقـد منتهى"}]
[null,300,3,40,45000,46400,1160,"2010-03-10","2013-05-05",20250,0,"العقـد منتهى"]
[null,400,4,40,45000,39160,979,"2010-06-07","2013-08-01",20250,0,"العقـد منتهى"]
[null,500,5,40,45000,43520,1088,"2010-11-01","2013-12-28",20250,0,"العقـد منتهى"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E26:E61)","v":225000},{"$f":"SUM(F26:F61)","v":218980},null,null,null,{"$f":"SUM(J26:J61)","v":101250},{"$f":"SUM(K26:K61)","v":0}]

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

{"sheet":"المبالغ المتاخره","index":2,"n_rows":36,"n_cols":43,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,0,7,0],[6,1,7,1],[16,6,16,7],[16,3,16,5],[12,6,12,7],[11,3,11,4],[11,6,11,7],[14,6,14,7],[15,6,15,7],[20,8,20,10],[1,1,1,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[20,3,20,5],[9,3,9,4],[9,5,9,6],[12,3,12,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ملف العميــل",{"$f":"'حركة تسديد عميل'!B2","v":100},{"$f":"VLOOKUP(C21,B25:AQ61,2,0)","v":1},null,null,null,null,"هذه الخلية تعني الأشهر"]
[]
[]
[]
[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,1,1160]
[null,200,2,2000]
[null,300,3,1160]
[null,400,4,1160]
[null,500,5,1160]
[null,null,null,1160]
[null,null,null,1160]
[null,null,null,1160]
[null,null,null,1160]
[null,null,null,1160]
[null,null,null,1160]