{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المقسطون","تسديد عميل"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[22,12,22,13],[3,11,4,13],[3,8,4,9],[15,8,15,11],[11,8,12,9],[14,9,14,10],[13,9,13,10],[22,2,22,5],[2,5,2,7],[4,5,4,6],[6,5,6,6],[16,5,16,6],[3,0,4,2]]}
[]
[null,null,null,null,null,null,null,null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2021-08-20"}]
[null,null,"ملف العميــل",2000,"الاســم ",{"$f":"VLOOKUP(D3,B26:K61,2,0)","v":20}]
["نظـام الخصــم ",null,null,null,null,null,null,null,"حساب نســبة التقسـيط ",null,null,"نظام تحويل التاريخ من هجري لميلادي "]
[null,null,null,null,"إسم البضاعة :"]
[null,null,"السعر النقدي",{"$f":"VLOOKUP(D3,B26:K61,4,0)","v":45000},null,null,null,null,"السعر","الاشهر",null,"بداية التسديد ","نهاية التسديد"]
[null,null,"قيمة العقد بالتقسيط",{"$f":"VLOOKUP(D3,B26:K61,5,0)","v":60750},"موديلها :",null,null,null,50000,{"$f":"VLOOKUP(D3,B26:K61,3,1)","v":40},null,{"$f":"D11","v":"2015-07-11"},{"$f":"D12","v":"2018-09-05"}]
[null,null,"المقدم",0,null,null,null,null,"الزيادة  ",{"$f":"SUM(I7*(J7%+5%))","v":22500},null,{"$f":"TEXT(L7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2015-07-12"},{"$f":"TEXT(M7,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2018-09-06"}]
[null,null,"القسط الشهري",{"$f":"VLOOKUP(D3,B26:K61,6,0)","v":1518.75},null,null,null,null,"بعد الزيادة",{"$f":"SUM(I7+J8)","v":72500},null,{"$f":"TEXT(L7+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1436/09/25"},{"$f":"TEXT(M7+1,\"[$-,197]B2yyyy/mm/dd;@\")","v":"1439/12/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":60750},null,"المدة",{"$f":"(D7-D8)/D9","v":40},null,"القسط الشهري",{"$f":"SUM(J9/J7)","v":1812.5}]
[null,null,"بداية التسديد",{"$f":"VLOOKUP(D3,B26:K61,7,0)","v":"2015-07-11"},null,"الربح كامل",{"$f":"D7-D6","v":15750}]
[null,null,"نهاية التسديد",{"$f":"VLOOKUP(D3,B26:K61,8,0)","v":"2018-09-05"},null,"الربح الشهري",{"$f":"G11/G10","v":393.75},null,"التاريخ الميلادي والتاريخ الهجري"]
[null,null,"الأشهر المسددة",{"$f":"(D10/D9)","v":40},null,"النسبة ",{"$f":"(G11/(D6-D8))*100","v":35}]
[null,null,"الأشهر المتبقية",{"$f":"D16/D9","v":0},null,"النسبة السنوية",{"$f":"(G13/G10)*12","v":10.5},null,"ملف العميــل","الاســم",null,"مدة العقـد","من ","الى"]
[null,null,null,null,null,"النسبة الشهرية",{"$f":"G13/G10","v":0.875},null,{"$f":"D3","v":2000},{"$f":"F3","v":20},null,{"$f":"G10","v":40},{"$f":"D11","v":"2015-07-11"},{"$f":"D12","v":"2018-09-05"}]
[null,null,"الباقي من المبلغ",{"$f":"D7-D10","v":0},null,null,null,null,"حالة الاشهر وقيمة العقد",null,null,null,{"$f":"TEXT(M15,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2015-07-12"},{"$f":"EDATE(M16,L15)","v":"2018-11-12"}]
[null,null,"الخصم",{"$f":"((D16*G14%)*(D14/12))/(1+((G14%)*(D14/12)))","v":0},null,null,null,null,"الأشهر المسددة",{"$f":"IF(DATEDIF(M15,NOW(),\"m\")+1>L15,L15,DATEDIF(M15,NOW(),\"m\")+1)","v":40},"المبــالغ المســدة",{"$f":"(J17*D9)","v":60750},"حـالة العقــد","المبلغ المسدد"]
[null,null,"المطلوب",{"$f":"D16-D17","v":0},null,null,null,null,"الأشهر المتبقية",{"$f":"L15-J17","v":0},"المبــالغ المتبـقية",{"$f":"(J18*D9)","v":0},{"$f":"VLOOKUP(D3,B26:N61,11,0)","v":"العقـد منتهى"},{"$f":"IF(M18=\"سداد مبكر\",INDEX(N26:N61,MATCH(M18,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,600,6,40,45000,69024,5507,"2010-12-31","2014-02-25",20250,0,"العقـد منتهى"]
[null,700,7,40,45000,38124,2118,"2011-01-30","2014-03-26",20250,0,"العقـد منتهى"]
[null,800,8,40,45000,57592,2504,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,900,9,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1000,10,40,45000,58000,1450,"2011-07-26","2014-09-19",20250,0,"العقـد منتهى"]
[null,1100,11,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1200,12,40,45000,58000,1450,"2011-08-24","2014-10-19",20250,0,"العقـد منتهى"]
[null,1300,13,40,45000,76850,1921,"2011-11-21","2015-01-15",20250,0,"العقـد منتهى"]
[null,1400,14,40,45000,62360,1559,"2012-02-17","2015-04-14",20250,0,"العقـد منتهى"]
[null,1500,15,40,45000,60900,1523,"2012-03-18","2015-05-13",20250,0,"العقـد منتهى"]
[null,1600,16,40,45000,50760,1269,"2014-06-23","2017-08-17",20250,0,"العقـد منتهى"]
[null,1700,17,40,45000,50760,1269,"2014-10-19","2017-12-13",20250,0,"العقـد منتهى"]
[null,1800,18,40,45000,53640,{"$f":"F43/D43","v":1341},"2015-01-15","2018-03-12",20250,0,"العقـد منتهى"]
[null,1900,19,40,45000,60920,1523,"2015-05-13","2018-07-08",20250,0,"العقـد منتهى"]
[null,2000,20,40,45000,60750,1518.75,"2015-07-11","2018-09-05",20250,0,"العقـد منتهى"]
[null,2100,21,40,45000,105624,2640.6,"2017-02-21","2020-04-18",20250,0,"العقـد منتهى"]
[null,2200,22,40,45000,{"$f":"E47+J47","v":65250},1631.25,"2018-01-12","2021-03-08",20250,0,"العقـد منتهى"]
[null,2300,23,40,45000,{"$f":"E48+J48","v":65250},1631.25,"2018-04-10","2021-06-05",20250,0,"سداد مبكر","2019-02-07",39889]
[null,2400,24,35,50000,{"$f":"E49+J49","v":70000},{"$f":"F49/D49","v":2000},"2019-11-01","2022-08-01",20000,{"$f":"G49","v":2000},"العقـد سارى"]
[null,2500,25,35,50000,{"$f":"E50+J50","v":70000},{"$f":"F50/D50","v":2000},"2020-09-25",{"$f":"MID(TEXT(H50,\"b2dd.mm.yyyy\"),1,2)-MID(TEXT(H50+ROUND((D50-1)*354.367056/12,0),\"b2dd.mm.yyyy\"),1,2)+H50+ROUND((D50-1)*354.367056/12,0)","v":"2023-06-26"},{"$f":"SUM(E50*(D50%+5%))","v":20000},{"$f":"G50","v":2000},"العقـد سارى"]
[null,2600,26,35,50000,{"$f":"E51+J51","v":70000},2000,"2021-03-27",{"$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-12-26"},20000,{"$f":"G51","v":2000},"العقـد سارى"]
[null,null,null,null,null,null,{"$f":"F52/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,null,null,0]
[null,null,null,null,{"$f":"SUM(E26:E61)","v":1185000},{"$f":"SUM(F26:F61)","v":1538784},null,null,null,{"$f":"SUM(J26:J61)","v":525750},{"$f":"SUM(K26:K61)","v":6000}]

{"sheet":"تسديد عميل","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,1,5,1],[13,2,16,3],[1,3,1,4]]}
[]
["ملف العميــل",2100,"الاســم",{"$f":"VLOOKUP('تسديد عميل'!B2,المقسطون!B25:I60,2,0)","v":21},null,null,"تاريخ اليوم :",{"$f":"TODAY()","v":"2021-08-20"}]
[]
[null,"مدة العقـد","تاريخ بداية العقد","تاريخ نهاية العقد",null,"القســـــــط ",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,6,0)","v":2640.6}]
[null,{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,3,0)","v":40},{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,7,0)","v":"2017-02-21"},{"$f":"TEXT(C5+((B5-1)*29.5),\"B2yyyy/mm/\")&TEXT(C5,\"B2dd\")","v":"1441/08/25"},null,"السعر النقدي ",{"$f":"VLOOKUP(B2,المقسطون!$B$25:$H$60,4,0)","v":45000}]
[null,null,{"$f":"TEXT(C5,\"[$-,197000]B2yyyy/mm/dd;@\")+1","v":"2017-02-22"},{"$f":"EDATE(C6,B5)","v":"2020-06-22"},null,"الربـــــــــح ",{"$f":"VLOOKUP(B2,المقسطون!B25:K60,9,0)","v":20250}]
[null,null,null,null,null,"قيمة القرض",{"$f":"VLOOKUP(B2,المقسطون!B25:I60,5,0)","v":105624}]
[null,"حالة الاشهر وقيمة العقد",null,null,null,"نسبة السداد بـ  %",{"$f":"G9/G7","v":1.0000000000000007}]
[null,"الأشهر المسددة",{"$f":"IF(COUNT(F19:F58)>D5,D5,COUNT(F19:F58))","v":40},null,null,"التســديدات",{"$f":"SUM(F19:F58)","v":105624.00000000007}]
[null,"الأشهر المتبقية",{"$f":"B5-C9","v":0},null,null,"البـــاقي",{"$f":"-(G9-G7)","v":-7.2759576141834259E-11}]
[null,"المبــالغ المســدة",{"$f":"G9","v":105624.00000000007},null,null,"حـالة العقــد",{"$f":"VLOOKUP(B2,المقسطون!B26:N61,11,0)","v":"العقـد منتهى"}]
[null,"المبــالغ المتبـقية",{"$f":"G10","v":-7.2759576141834259E-11},null,null,"تاريخ السداد المبكر",{"$f":"IF(G11=\"سداد مبكر\",INDEX(المقسطون!M26:M61,MATCH(G11,المقسطون!L26:L61,0)),\"\")","v":""}]
[null,null,null,null,null,"قيمة السداد المبكر",{"$f":"IF(G11=\"سداد مبكر\",INDEX(المقسطون!N27:N62,MATCH(G11,المقسطون!L27:L62,0)),\"\")","v":""}]
[null,null,"حركة تسديد عميل"]
[]
[]
[]
[null,"الشهــر","تاريخ التحصيل","رصيد القرض","القسط","التسديدات"]
[null,{"$f":"IF(C19=\"\",\"\",ROW()-18)","v":1},{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/05/25"},{"$f":"G7","v":105624},{"$f":"IF(C19=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B19=\"\",\"\",IF(TODAY()>=h2g(C19),E19,\"\"))","v":2640.6}]
[null,{"$f":"IF(C20=\"\",\"\",ROW()-18)","v":2},{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/06/25"},{"$f":"IF(C20=\"\",\"\",D19-E20)","v":102983.4},{"$f":"IF(C20=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B20=\"\",\"\",IF(TODAY()>=h2g(C20),E20,\"\"))","v":2640.6}]
[null,3,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/07/25"},{"$f":"IF(C21=\"\",\"\",D20-E21)","v":100342.79999999999},{"$f":"IF(C21=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B21=\"\",\"\",IF(TODAY()>=h2g(C21),E21,\"\"))","v":2640.6}]
[null,4,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/08/25"},97702.199999999983,{"$f":"IF(C22=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B22=\"\",\"\",IF(TODAY()>=h2g(C22),E22,\"\"))","v":2640.6}]
[null,5,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/09/25"},95061.599999999977,{"$f":"IF(C23=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B23=\"\",\"\",IF(TODAY()>=h2g(C23),E23,\"\"))","v":2640.6}]
[null,6,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/10/25"},92420.999999999971,{"$f":"IF(C24=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B24=\"\",\"\",IF(TODAY()>=h2g(C24),E24,\"\"))","v":2640.6}]
[null,7,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/11/25"},89780.399999999965,{"$f":"IF(C25=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B25=\"\",\"\",IF(TODAY()>=h2g(C25),E25,\"\"))","v":2640.6}]
[null,8,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1438/12/25"},87139.799999999959,{"$f":"IF(C26=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B26=\"\",\"\",IF(TODAY()>=h2g(C26),E26,\"\"))","v":2640.6}]
[null,9,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/01/25"},84499.199999999953,{"$f":"IF(C27=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B27=\"\",\"\",IF(TODAY()>=h2g(C27),E27,\"\"))","v":2640.6}]
[null,10,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/02/25"},81858.599999999948,{"$f":"IF(C28=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B28=\"\",\"\",IF(TODAY()>=h2g(C28),E28,\"\"))","v":2640.6}]
[null,11,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/03/25"},79217.999999999942,{"$f":"IF(C29=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B29=\"\",\"\",IF(TODAY()>=h2g(C29),E29,\"\"))","v":2640.6}]
[null,12,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/04/25"},76577.399999999936,{"$f":"IF(C30=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B30=\"\",\"\",IF(TODAY()>=h2g(C30),E30,\"\"))","v":2640.6}]
[null,13,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/05/25"},73936.79999999993,{"$f":"IF(C31=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B31=\"\",\"\",IF(TODAY()>=h2g(C31),E31,\"\"))","v":2640.6}]
[null,14,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/06/25"},71296.199999999924,{"$f":"IF(C32=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B32=\"\",\"\",IF(TODAY()>=h2g(C32),E32,\"\"))","v":2640.6}]
[null,15,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/07/25"},68655.599999999919,{"$f":"IF(C33=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B33=\"\",\"\",IF(TODAY()>=h2g(C33),E33,\"\"))","v":2640.6}]
[null,16,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/08/25"},66014.999999999913,{"$f":"IF(C34=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B34=\"\",\"\",IF(TODAY()>=h2g(C34),E34,\"\"))","v":2640.6}]
[null,17,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/09/25"},63374.399999999914,{"$f":"IF(C35=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B35=\"\",\"\",IF(TODAY()>=h2g(C35),E35,\"\"))","v":2640.6}]
[null,18,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/10/25"},60733.799999999916,{"$f":"IF(C36=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B36=\"\",\"\",IF(TODAY()>=h2g(C36),E36,\"\"))","v":2640.6}]
[null,19,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/11/25"},58093.199999999917,{"$f":"IF(C37=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B37=\"\",\"\",IF(TODAY()>=h2g(C37),E37,\"\"))","v":2640.6}]
[null,20,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1439/12/25"},55452.599999999919,{"$f":"IF(C38=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B38=\"\",\"\",IF(TODAY()>=h2g(C38),E38,\"\"))","v":2640.6}]
[null,21,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/01/25"},52811.99999999992,{"$f":"IF(C39=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B39=\"\",\"\",IF(TODAY()>=h2g(C39),E39,\"\"))","v":2640.6}]
[null,22,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/02/25"},50171.399999999921,{"$f":"IF(C40=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B40=\"\",\"\",IF(TODAY()>=h2g(C40),E40,\"\"))","v":2640.6}]
[null,23,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/03/25"},47530.799999999923,{"$f":"IF(C41=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B41=\"\",\"\",IF(TODAY()>=h2g(C41),E41,\"\"))","v":2640.6}]
[null,24,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/04/25"},44890.199999999924,{"$f":"IF(C42=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B42=\"\",\"\",IF(TODAY()>=h2g(C42),E42,\"\"))","v":2640.6}]
[null,25,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/05/25"},42249.599999999926,{"$f":"IF(C43=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B43=\"\",\"\",IF(TODAY()>=h2g(C43),E43,\"\"))","v":2640.6}]
[null,26,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/06/25"},39608.999999999927,{"$f":"IF(C44=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B44=\"\",\"\",IF(TODAY()>=h2g(C44),E44,\"\"))","v":2640.6}]
[null,27,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/07/25"},36968.399999999929,{"$f":"IF(C45=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B45=\"\",\"\",IF(TODAY()>=h2g(C45),E45,\"\"))","v":2640.6}]
[null,28,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/08/25"},34327.79999999993,{"$f":"IF(C46=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B46=\"\",\"\",IF(TODAY()>=h2g(C46),E46,\"\"))","v":2640.6}]
[null,29,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/09/25"},31687.199999999932,{"$f":"IF(C47=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B47=\"\",\"\",IF(TODAY()>=h2g(C47),E47,\"\"))","v":2640.6}]
[null,30,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/10/25"},29046.599999999933,{"$f":"IF(C48=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B48=\"\",\"\",IF(TODAY()>=h2g(C48),E48,\"\"))","v":2640.6}]
[null,31,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/11/25"},26405.999999999935,{"$f":"IF(C49=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B49=\"\",\"\",IF(TODAY()>=h2g(C49),E49,\"\"))","v":2640.6}]
[null,32,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1440/12/25"},23765.399999999936,{"$f":"IF(C50=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B50=\"\",\"\",IF(TODAY()>=h2g(C50),E50,\"\"))","v":2640.6}]
[null,33,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/01/25"},21124.799999999937,{"$f":"IF(C51=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B51=\"\",\"\",IF(TODAY()>=h2g(C51),E51,\"\"))","v":2640.6}]
[null,34,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/02/25"},18484.199999999939,{"$f":"IF(C52=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B52=\"\",\"\",IF(TODAY()>=h2g(C52),E52,\"\"))","v":2640.6}]
[null,35,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/03/25"},15843.599999999939,{"$f":"IF(C53=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B53=\"\",\"\",IF(TODAY()>=h2g(C53),E53,\"\"))","v":2640.6}]
[null,36,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/04/25"},13202.999999999938,{"$f":"IF(C54=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B54=\"\",\"\",IF(TODAY()>=h2g(C54),E54,\"\"))","v":2640.6}]
[null,37,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/05/25"},10562.399999999938,{"$f":"IF(C55=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B55=\"\",\"\",IF(TODAY()>=h2g(C55),E55,\"\"))","v":2640.6}]
[null,38,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/06/25"},7921.7999999999374,{"$f":"IF(C56=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B56=\"\",\"\",IF(TODAY()>=h2g(C56),E56,\"\"))","v":2640.6}]
[null,39,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/07/25"},5281.1999999999371,{"$f":"IF(C57=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B57=\"\",\"\",IF(TODAY()>=h2g(C57),E57,\"\"))","v":2640.6}]
[null,40,{"$f":"IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>$G$12,\"\",IF(h2g(TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\"))>h2g($D$5),\"\",TEXT($C$5+((ROW()-19)*29.5),\"B2yyyy/mm/\")&TEXT($C$5,\"B2dd\")))","v":"1441/08/25"},2640.5999999999372,{"$f":"IF(C58=\"\",\"\",IF($G$7=\"\",\"\",$G$7/$B$5))","v":2640.6},{"$f":"IF(B58=\"\",\"\",IF(TODAY()>=h2g(C58),E58,\"\"))","v":2640.6}]