{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المقسطون","حركة تسديد عميل"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":127,"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":37,"n_cols":14,"rows_kept":37,"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:K36,2,0)","v":1},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-02-16"}]
[]
["نظـام الخصــم ",null,null,null,null,null,null,null,"حساب نســبة التقسـيط ",null,null,"نظام تحويل التاريخ من هجري لميلادي "]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D2,B26:K36,4,0)","v":45000},null,null,null,null,"السعر","الاشهر",null,"بداية التسديد ","نهاية التسديد"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D2,B26:K36,5,0)","v":46400},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D2,B26:K36,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:K36,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:K36,7,0)","v":"2008-10-25"},null,"الربح كامل",{"$f":"D7-D6","v":1400},null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D2,B26:K36,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":38},"المبــالغ المســدة",{"$f":"(J16*D9)","v":44080},"نسبة السداد بـ  %"]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":0},null,null,null,null,"الأشهر المتبقية",{"$f":"L14-J16","v":2},"المبــالغ المتبـقية",{"$f":"(J17*D9)","v":2320},{"$f":"L16/D7","v":0.95}]
[null,null,"المطلوب",{"$f":"D16-D17","v":0},null,null,null,null,"حـالة العقــد",{"$f":"VLOOKUP(D2,B26:N36,11,0)","v":"العقـد منتهى"},"مبلغ السداد المبكر",{"$f":"IF(J18=\"سداد مبكر\",INDEX(N26:N36,MATCH(J18,L26:L36,0)),\"\")","v":""},"تاريخ السداد المبكر",{"$f":"IF(J18=\"سداد مبكر\",INDEX(M26:M36,MATCH(J18,L26:L36,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D4,B27:L37,11,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,C27:M37,11,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D5,B28:L38,11,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,C28:M38,11,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D6,B28:L39,11,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E6,C28:M39,11,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D7,B28:L40,11,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E7,C28:M40,11,0)","v":{"$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,null,null,null,null,null,{"$f":"F28/40","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E26:E36)","v":90000},{"$f":"SUM(F26:F36)","v":89900},null,null,null,{"$f":"SUM(J26:J36)","v":40500},{"$f":"SUM(K26:K36)","v":0}]

{"sheet":"حركة تسديد عميل","index":1,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,3,1,5],[13,3,16,5],[7,8,7,9]]}
[]
["ملف العميــل",200,"الاســم",{"$f":"VLOOKUP(B2,المقسطون!B25:I35,2,0)","v":2},null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2022-02-16"}]
[]
[]
[null,"مدة العقد (بالاشهر)",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$35,3,0)","v":40},null,null,"حـالة العقــد",{"$f":"VLOOKUP(B2,المقسطون!B26:N36,11,0)","v":"العقـد منتهى"}]
[null,null,null,"الأقساط التأخرة ",{"$f":"SUM(I19:I58)","v":2175}]
[null," بداية العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$35,7,0)","v":"2009-01-21"},null,null,null,"الأشهر المسددة",{"$f":"IF(COUNT(H19:H58)>C9,C9,COUNT(H19:H58))","v":38}]
[null,null,{"$f":"TEXT(C7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2009-01-22"},null,null,null,"الأشهر المتبقية",{"$f":"C5-H7","v":2}]
[null," نهاية العقد",{"$f":"TEXT(C7+((C5-1)*29.5),\"B2yyyy/mm/\")&TEXT(C7,\"B2dd\")","v":"1433/04/25"},null,null,null,"المبــالغ المســدة",{"$f":"SUM(H19:H58)","v":41325}]
[null,null,{"$f":"ConvertDate(C9)","v":"2012/03/18"},null,null,null,"المبــالغ المتبـقية",{"$f":"-(H9-C14)","v":2175}]
[null,"القســـــــط ",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$35,6,0)","v":1087},null,null,null,"نسبة السداد بـ  %",{"$f":"H9/C14","v":0.95}]
[null,"السعر النقدي ",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$35,4,0)","v":45000}]
[null,"الربـــــــــح ",{"$f":"VLOOKUP(B2,المقسطون!B26:N36,9,0)","v":20250},null,null,null,"الســداد المبكـر"]
[null,"قيمة العقد",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$35,5,0)","v":43500},"حركة تسديد عميل",null,null,"تاريخ السداد المبكر",{"$f":"IF(G5=\"سداد مبكر\",INDEX(المقسطون!M26:M36,MATCH(G5,المقسطون!L26:L36,0)),\"\")","v":""}]
[]
[null,null,null,null,null,null,"قيمة السداد المبكر",{"$f":"IF(G5=\"سداد مبكر\",INDEX(المقسطون!N27:N37,MATCH(G5,المقسطون!L27:L37,0)),\"\")","v":""}]
[]
[null,null,"الشهــر"," التحصيل بالتاريخ ( هـ )"," التحصيل بالتاريخ ( م )","رصيد القرض","القسط","التسديدات","الأقساط المتأخرة",null,"تم التحصيل","التاريخ المتأخر"]
[null,null,{"$f":"IF(D19=\"\",\"\",ROW()-18)","v":1},{"$f":"IF(K19<>\"\",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"},{"$f":"IF(D19<>\"\",ConvertDate(D19),\"\")","v":"2009/01/21"},{"$f":"C14","v":43500},{"$f":"IF(D19=\"\",\"\",IF($C$14=\"\",\"\",$C$14/$C$5))","v":1087.5},{"$f":"IF(K19=\"\",\"\",IF(TODAY()>=h2g(D19),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K19=\"\",$C$14/$C$5,\"\")","v":""},null,"8","2022-02-16"]
[null,null,2,{"$f":"IF(K20<>\"\",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"},{"$f":"IF(D20<>\"\",ConvertDate(D20),\"\")","v":"2009/02/20"},{"$f":"IF(D20=\"\",\"\",F19-G20)","v":42412.5},1087.5,{"$f":"IF(K20=\"\",\"\",IF(TODAY()>=h2g(D20),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K20=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,3,{"$f":"IF(K21<>\"\",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",{"$f":"IF(D21=\"\",\"\",F20-G21)","v":41325},1087.5,{"$f":"IF(K21=\"\",\"\",IF(TODAY()>=h2g(D21),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K21=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,4,{"$f":"IF(K22<>\"\",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",40237.5,1087.5,{"$f":"IF(K22=\"\",\"\",IF(TODAY()>=h2g(D22),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K22=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,5,{"$f":"IF(K23<>\"\",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",39150,1087.5,{"$f":"IF(K23=\"\",\"\",IF(TODAY()>=h2g(D23),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K23=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,6,{"$f":"IF(K24<>\"\",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",38062.5,1087.5,{"$f":"IF(K24=\"\",\"\",IF(TODAY()>=h2g(D24),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K24=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,7,{"$f":"IF(K25<>\"\",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",36975,1087.5,{"$f":"IF(K25=\"\",\"\",IF(TODAY()>=h2g(D25),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K25=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,8,{"$f":"IF(K26<>\"\",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",35887.5,1087.5,{"$f":"IF(K26=\"\",\"\",IF(TODAY()>=h2g(D26),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K26=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,9,{"$f":"IF(K27<>\"\",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",34800,1087.5,{"$f":"IF(K27=\"\",\"\",IF(TODAY()>=h2g(D27),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K27=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,10,{"$f":"IF(K28<>\"\",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",33712.5,1087.5,{"$f":"IF(K28=\"\",\"\",IF(TODAY()>=h2g(D28),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K28=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,11,{"$f":"IF(K29<>\"\",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",32625,1087.5,{"$f":"IF(K29=\"\",\"\",IF(TODAY()>=h2g(D29),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K29=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,12,{"$f":"IF(K30<>\"\",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",31537.5,1087.5,{"$f":"IF(K30=\"\",\"\",IF(TODAY()>=h2g(D30),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K30=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,13,{"$f":"IF(K31<>\"\",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",30450,1087.5,{"$f":"IF(K31=\"\",\"\",IF(TODAY()>=h2g(D31),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K31=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,14,{"$f":"IF(K32<>\"\",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",29362.5,1087.5,{"$f":"IF(K32=\"\",\"\",IF(TODAY()>=h2g(D32),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K32=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,15,{"$f":"IF(K33<>\"\",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",28275,1087.5,{"$f":"IF(K33=\"\",\"\",IF(TODAY()>=h2g(D33),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K33=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,16,{"$f":"IF(K34<>\"\",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",27187.5,1087.5,{"$f":"IF(K34=\"\",\"\",IF(TODAY()>=h2g(D34),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K34=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,17,{"$f":"IF(K35<>\"\",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",26100,1087.5,{"$f":"IF(K35=\"\",\"\",IF(TODAY()>=h2g(D35),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K35=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,18,{"$f":"IF(K36<>\"\",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",25012.5,1087.5,{"$f":"IF(K36=\"\",\"\",IF(TODAY()>=h2g(D36),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K36=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,19,{"$f":"IF(K37<>\"\",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",23925,1087.5,{"$f":"IF(K37=\"\",\"\",IF(TODAY()>=h2g(D37),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K37=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,20,{"$f":"IF(K38<>\"\",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",22837.5,1087.5,{"$f":"IF(K38=\"\",\"\",IF(TODAY()>=h2g(D38),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K38=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,21,{"$f":"IF(K39<>\"\",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",21750,1087.5,{"$f":"IF(K39=\"\",\"\",IF(TODAY()>=h2g(D39),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K39=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,22,{"$f":"IF(K40<>\"\",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",20662.5,1087.5,{"$f":"IF(K40=\"\",\"\",IF(TODAY()>=h2g(D40),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K40=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,23,{"$f":"IF(K41<>\"\",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",19575,1087.5,{"$f":"IF(K41=\"\",\"\",IF(TODAY()>=h2g(D41),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K41=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,24,{"$f":"IF(K42<>\"\",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",18487.5,1087.5,{"$f":"IF(K42=\"\",\"\",IF(TODAY()>=h2g(D42),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K42=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,25,{"$f":"IF(K43<>\"\",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",17400,1087.5,{"$f":"IF(K43=\"\",\"\",IF(TODAY()>=h2g(D43),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K43=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,26,{"$f":"IF(K44<>\"\",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",16312.5,1087.5,{"$f":"IF(K44=\"\",\"\",IF(TODAY()>=h2g(D44),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K44=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,27,{"$f":"IF(K45<>\"\",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",15225,1087.5,{"$f":"IF(K45=\"\",\"\",IF(TODAY()>=h2g(D45),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K45=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,28,{"$f":"IF(K46<>\"\",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",14137.5,1087.5,{"$f":"IF(K46=\"\",\"\",IF(TODAY()>=h2g(D46),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K46=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,29,{"$f":"IF(K47<>\"\",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",13050,1087.5,{"$f":"IF(K47=\"\",\"\",IF(TODAY()>=h2g(D47),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K47=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,30,{"$f":"IF(K48<>\"\",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",11962.5,1087.5,{"$f":"IF(K48=\"\",\"\",IF(TODAY()>=h2g(D48),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K48=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,31,{"$f":"IF(K49<>\"\",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",10875,1087.5,{"$f":"IF(K49=\"\",\"\",IF(TODAY()>=h2g(D49),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K49=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,32,{"$f":"IF(K50<>\"\",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",9787.5,1087.5,{"$f":"IF(K50=\"\",\"\",IF(TODAY()>=h2g(D50),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K50=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,33,{"$f":"IF(K51<>\"\",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",8700,1087.5,{"$f":"IF(K51=\"\",\"\",IF(TODAY()>=h2g(D51),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K51=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,34,{"$f":"IF(K52<>\"\",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",7612.5,1087.5,{"$f":"IF(K52=\"\",\"\",IF(TODAY()>=h2g(D52),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K52=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,35,{"$f":"IF(K53<>\"\",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",6525,1087.5,{"$f":"IF(K53=\"\",\"\",IF(TODAY()>=h2g(D53),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K53=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,36,{"$f":"IF(K54<>\"\",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",5437.5,1087.5,{"$f":"IF(K54=\"\",\"\",IF(TODAY()>=h2g(D54),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K54=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,37,{"$f":"IF(K55<>\"\",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",4350,1087.5,{"$f":"IF(K55=\"\",\"\",IF(TODAY()>=h2g(D55),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K55=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,38,{"$f":"IF(K56<>\"\",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/02/25"},"2012/01/19",3262.5,1087.5,{"$f":"IF(K56=\"\",\"\",IF(TODAY()>=h2g(D56),$C$14/$C$5,\"\"))","v":1087.5},{"$f":"IF(K56=\"\",$C$14/$C$5,\"\")","v":""},null,"8"]
[null,null,"",{"$f":"IF(K57<>\"\",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(K57=\"\",\"\",IF(TODAY()>=h2g(D57),$C$14/$C$5,\"\"))","v":""},{"$f":"IF(K57=\"\",$C$14/$C$5,\"\")","v":1087.5}]
[null,null,"",{"$f":"IF(K58<>\"\",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(K58=\"\",\"\",IF(TODAY()>=h2g(D58),$C$14/$C$5,\"\"))","v":""},{"$f":"IF(K58=\"\",$C$14/$C$5,\"\")","v":1087.5}]