{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["365計算版","YearFrac計算版","資料"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"365計算版","index":0,"n_rows":204,"n_cols":11,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
[]
["附表"]
["編號","借款","始日","末日","試算本","累計本金","試算息","試算還","累計利息","年利率","還款"]
[1,650000,"2001-11-30",{"$f":"IF(C5<>\"\",C5,\"\")","v":"2001-12-15"},{"$f":"B4","v":650000},{"$f":"B4","v":650000},{"$f":"IF(D4=\"\",F4*((C4-C4)/365)*J4,F4*((D4-C4)/365)*J4)","v":5342.465753424658},{"$f":"G4-K4","v":5342.465753424658},{"$f":"IFERROR(IF(J4<>\"\",IF(G4-K5<=0,0,G4-K5),\"\"),\"\")","v":5342.465753424658},0.2]
[2,500000,"2001-12-15","2001-12-31",{"$f":"F4+B5","v":1150000},{"$f":"IFERROR(IF(OR(B5<>\"\",K5<>\"\"),F4+B5+IF(AND(E5>0,H5<0),H5,0),\"\"),\"\")","v":1150000},{"$f":"IF(D5=\"\",I4+E5*((C5-C5)/365)*J5,I4+E5*((D5-C5)/365)*J5)","v":15424.657534246577},{"$f":"G5-K6","v":15424.657534246577},{"$f":"IFERROR(IF(J5<>\"\",IF(G5-K6<=0,0,G5-K6),\"\"),\"\")","v":15424.657534246577},{"$f":"IF(C5<>\"\",J4,\"\")","v":0.2}]
[3,1200000,"2001-12-31","2002-02-06",{"$f":"F5+B6","v":2350000},{"$f":"IFERROR(IF(OR(B6<>\"\",K6<>\"\"),F5+B6+IF(AND(E6>0,H6<0),H6,0),\"\"),\"\")","v":2350000},{"$f":"IF(D6=\"\",I5+E6*((C6-C6)/365)*J6,I5+E6*((D6-C6)/365)*J6)","v":63068.493150684939},{"$f":"G6-K7","v":63068.493150684939},63068.493150684939,0.2]
[4,750000,"2002-02-06","2002-02-22",{"$f":"F6+B7","v":3100000},3100000,90246.57534246576,90246.57534246576,90246.57534246576,0.2]
[5,350000,"2002-02-22","2002-03-01",3450000,3450000,103479.45205479453,103479.45205479453,103479.45205479453,0.2]
[6,550000,"2002-03-01","2002-04-30",4000000,4000000,234986.30136986301,234986.30136986301,234986.30136986301,0.2]
[7,300000,"2002-04-30","2002-05-08",4300000,4300000,253835.61643835617,253835.61643835617,253835.61643835617,0.2]
[8,500000,"2002-05-08","2002-05-14",4800000,4800000,269616.43835616438,269616.43835616438,269616.43835616438,0.2]
[9,600000,"2002-05-14","2002-05-30",5400000,5400000,316958.90410958906,316958.90410958906,316958.90410958906,0.2]
[10,350000,"2002-05-30","2002-06-05",5750000,5750000,335863.01369863015,335863.01369863015,335863.01369863015,0.2]
[11,300000,"2002-06-05","2002-06-13",6050000,6050000,362383.56164383562,362383.56164383562,362383.56164383562,0.2]
[12,100000,"2002-06-13","2002-06-17",6150000,6150000,375863.01369863015,375863.01369863015,375863.01369863015,0.2]
[13,100000,"2002-06-17","2002-06-18",6250000,6250000,379287.67123287672,379287.67123287672,379287.67123287672,0.2]
[14,500000,"2002-06-18","2002-06-21",6750000,6750000,390383.56164383562,390383.56164383562,390383.56164383562,0.2]
[15,350000,"2002-06-21","2002-07-01",7100000,7100000,429287.67123287672,429287.67123287672,429287.67123287672,0.2]
[16,300000,"2002-07-01","2002-07-08",7400000,7400000,457671.23287671234,457671.23287671234,457671.23287671234,0.2]
[17,350000,"2002-07-08","2002-07-17",7750000,7750000,495890.41095890413,495890.41095890413,495890.41095890413,0.2]
[18,300000,"2002-07-17","2002-07-31",8050000,8050000,557643.83561643842,557643.83561643842,557643.83561643842,0.2]
[19,300000,"2002-07-31","2002-09-23",8350000,8350000,804712.3287671234,804712.3287671234,804712.3287671234,0.2]
[20,175000,"2002-09-23","2002-09-30",8525000,8525000,837410.95890410966,837410.95890410966,837410.95890410966,0.2]
[21,500000,"2002-09-30","2002-10-11",9025000,9025000,891808.21917808231,891808.21917808231,891808.21917808231,0.2]
[22,300000,"2002-10-11","2002-11-21",9325000,9325000,1101301.3698630137,1101301.3698630137,1101301.3698630137,0.2]
[23,300000,"2002-11-21","2002-12-02",9625000,9625000,1159315.0684931506,1159315.0684931506,1159315.0684931506,0.2]
[24,500000,"2002-12-02","2002-12-16",10125000,10125000,1236986.3013698629,1236986.3013698629,1236986.3013698629,0.2]
[25,500000,"2002-12-16","2003-01-28",10625000,10625000,1487328.7671232875,1487328.7671232875,1487328.7671232875,0.2]
[26,500000,"2003-01-28","2003-01-30",11125000,11125000,1499520.5479452054,499520.54794520536,499520.54794520536,0.2]
[1,null,"2003-01-30","2003-02-10",11125000,11125000,566575.34246575332,566575.34246575332,566575.34246575332,0.2,1000000]
[27,500000,"2003-02-10","2003-02-21",11625000,11320443.835616438,636643.8356164383,-304556.1643835617,0,0.2]
[2,null,"2003-02-21","2003-02-28",11320443.835616438,10363864.716081817,43420.880465378119,-956579.11953462183,0,0.2,941200]
[3,null,"2003-02-28","2003-03-30",10363864.716081817,9534229.6155242585,170364.89944244083,-829635.10055755917,0,0.2,1000000]
[4,null,"2003-03-30","2003-04-07",9534229.6155242585,9534229.6155242585,41793.883246133744,41793.883246133744,41793.883246133744,0.2,1000000]
[28,500000,"2003-04-07","2003-04-30",10034229.615524258,9202482.2829660401,168252.66744178196,-831747.33255821804,0,0.2]
[5,null,"2003-04-30",{"$f":"IF(C37<>\"\",C37,\"\")","v":"2003-06-03"},9202482.2829660401,8673925.7885117084,171443.50554566871,-528556.49445433123,0,0.2,1000000]
[6,null,"2003-06-03","2003-06-30",8673925.7885117084,7802252.361821197,128326.5733094883,-871673.42669051164,0,{"$f":"IF(C37<>\"\",J36,\"\")","v":0.2},700000]
[7,null,"2003-06-30","2003-07-01",7802252.361821197,6806527.5685947975,4275.2067736006566,-995724.79322639934,0,0.2,1000000]
[8,null,"2003-07-01","2003-07-18",6806527.5685947975,6569930.8390967762,63403.270501978943,-236596.72949802107,0,0.2,1000000]
[9,null,"2003-07-18","2003-07-30",6569930.8390967762,5613130.3843401521,43199.545243376058,-956800.45475662395,0,0.2,300000]
[10,null,"2003-07-30","2003-09-08",5613130.3843401521,5613130.3843401521,123027.5152732088,123027.5152732088,123027.5152732088,0.2,1000000]
[29,500000,"2003-09-08","2003-10-01",6113130.3843401521,5813200.0907584699,200069.70641831757,-299930.29358168243,0,0.2]
[11,null,"2003-10-01","2003-10-06",5813200.0907584699,4629126.6663495889,15926.575591119094,-1184073.424408881,0,0.2,500000]
[12,null,"2003-10-06","2003-10-09",4629126.6663495889,3836736.189636739,7609.5232871500084,-792390.47671285004,0,0.2,1200000]
[13,null,"2003-10-09","2003-10-22",3836736.189636739,3836736.189636739,27330.175597412392,27330.175597412392,27330.175597412392,0.2,800000]
[30,1000000,"2003-10-22","2003-10-30",4836736.189636739,3885268.4964763946,48532.306839655634,-951467.69316034438,0,0.2]
[14,null,"2003-10-30","2003-11-30",3885268.4964763946,3451264.8380603772,65996.34158398259,-434003.65841601742,0,0.2,1000000]
[15,null,"2003-11-30","2003-12-30",3451264.8380603772,3007997.9586860272,56733.120625650037,-443266.87937434996,0,0.2,500000]
[16,null,"2003-12-30","2004-01-12",3007997.9586860272,3007997.9586860272,21426.834774201838,21426.834774201838,21426.834774201838,0.2,500000]
[31,300000,"2004-01-12","2004-02-28",3307997.9586860272,2914617.0696565267,106619.11097049953,-393380.88902950048,0,0.2]
[17,null,"2004-02-28","2004-03-30",2914617.0696565267,2464125.6335794595,49508.563922932779,-450491.43607706722,0,0.2,500000]
[18,null,"2004-03-30","2004-04-30",2464125.6335794595,1505982.0142046448,41856.380625185346,-958143.61937481468,0,0.2,500000]
[19,null,"2004-04-30","2004-08-05",1505982.0142046448,1505982.0142046448,80043.975549507159,80043.975549507159,80043.975549507159,0.2,1000000]
[32,500000,"2004-08-05","2004-08-10",2005982.0142046448,2005982.0142046448,85539.816684314399,85539.816684314399,85539.816684314399,0.2]
[33,500000,"2004-08-10","2004-08-18",2505982.0142046446,2505982.0142046446,96524.943321923798,96524.943321923798,96524.943321923798,0.2]
[34,200000,"2004-08-18","2004-08-27",2705982.0142046446,2315851.5263637421,109869.51215909739,-390130.48784090264,0,0.2]
[20,null,"2004-08-27","2004-08-30",2315851.5263637421,2315851.5263637421,3806.8792214198497,3806.8792214198497,3806.8792214198497,0.2,500000]
[35,500000,"2004-08-30","2004-11-03",2815851.5263637421,1919949.0078940075,104097.48153026546,-895902.51846973458,0,0.2]
[21,null,"2004-11-03","2005-04-18",1919949.0078940075,1919949.0078940075,174636.45770433167,174636.45770433167,174636.45770433167,0.2,1000000]
[36,500000,"2005-04-18","2005-05-04",2419949.0078940075,2115801.4569004234,195852.44900641611,-304147.55099358386,0,0.2]
[22,null,"2005-05-04",{"$f":"IF(C62<>\"\",C62,\"\")","v":"2005-08-04"},2115801.4569004234,1722461.0371934858,106659.58029306245,-393340.41970693757,0,{"$f":"IF(C61<>\"\",J60,\"\")","v":0.2},500000]
[23,null,"2005-08-04","2006-10-04",1722461.0371934858,1124525.9149164583,402064.8777229726,-597935.12227702746,0,0.2,500000]
[24,null,"2006-10-04","2007-02-15",1124525.9149164583,707093.84510758449,82567.930191126259,-417432.06980887376,0,0.2,1000000]
[25,null,"2007-02-15","2007-07-16",707093.84510758449,265598.59612744494,58504.751019860421,-441495.24898013956,0,0.2,500000]
[26,null,"2007-07-16","2007-12-04",265598.59612744494,-213881.18356901,20520.220303545066,-479479.77969645493,0,0.2,500000]
[27,null,"2007-12-04","",{"$f":"F65+B66","v":-213881.18356901},-213881.18356901,0,{"$f":"G66-K67","v":0},0,0.2,500000]
[null,null,null,"",-213881.18356901,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(J69<>\"\",IF(G69-K70<=0,0,G69-K70),\"\"),\"\")","v":""},""]
[null,null,null,"",{"$error":"#VALUE!"},{"$f":"IFERROR(IF(OR(B70<>\"\",K70<>\"\"),F69+B70+IF(AND(E70>0,H70<0),H70,0),\"\"),\"\")","v":""},{"$f":"IF(D70=\"\",I69+E70*((C70-C70)/365)*J70,I69+E70*((D70-C70)/365)*J70)","v":{"$error":"#VALUE!"}},{"$f":"G70-K71","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,"",{"$f":"F70+B71","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C126<>\"\",C126,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(C125<>\"\",J124,\"\")","v":""}]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(J133<>\"\",IF(G133-K134<=0,0,G133-K134),\"\"),\"\")","v":""},""]
[null,null,null,"",{"$error":"#VALUE!"},{"$f":"IFERROR(IF(OR(B134<>\"\",K134<>\"\"),F133+B134+IF(AND(E134>0,H134<0),H134,0),\"\"),\"\")","v":""},{"$f":"IF(D134=\"\",I133+E134*((C134-C134)/365)*J134,I133+E134*((D134-C134)/365)*J134)","v":{"$error":"#VALUE!"}},{"$f":"G134-K135","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,"",{"$f":"F134+B135","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C190<>\"\",C190,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(C189<>\"\",J188,\"\")","v":""}]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(J197<>\"\",IF(G197-K198<=0,0,G197-K198),\"\"),\"\")","v":""},""]
[null,null,null,"",{"$error":"#VALUE!"},{"$f":"IFERROR(IF(OR(B198<>\"\",K198<>\"\"),F197+B198+IF(AND(E198>0,H198<0),H198,0),\"\"),\"\")","v":""},{"$f":"IF(D198=\"\",I197+E198*((C198-C198)/365)*J198,I197+E198*((D198-C198)/365)*J198)","v":{"$error":"#VALUE!"}},{"$f":"G198-K199","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,"",{"$f":"F198+B199","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C205<>\"\",C205,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$f":"G202-#REF!","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,null,{"$f":"F202+B203","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$f":"G203-#REF!","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(J203<>\"\",IF(G203-#REF!<=0,0,G203-#REF!),\"\"),\"\")","v":""},{"$f":"IF(C203<>\"\",J202,\"\")","v":""}]
["合計",{"$f":"SUBTOTAL(109,表格5[借款])","v":16125000},{"$f":"SUBTOTAL(103,表格5[始日])","v":63},null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,表格5[還款])","v":20441200}]

{"sheet":"YearFrac計算版","index":1,"n_rows":204,"n_cols":11,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"請輸入0,1,3,4"]
["附表",null,null,null,null,null,null,null,3]
["編號","借款","始日","末日","試算本","累計本金","試算息","試算還","累計利息","年利率","還款"]
[1,650000,"2001-11-30",{"$f":"IF(C5<>\"\",C5,\"\")","v":"2001-12-15"},{"$f":"B4","v":650000},{"$f":"B4","v":650000},{"$f":"IF(D4=\"\",F4*YEARFRAC(C4,C4,I2)*J4,F4*YEARFRAC(C4,D4,I2)*J4)","v":5342.465753424658},{"$f":"G4-K4","v":5342.465753424658},{"$f":"IFERROR(IF(J4<>\"\",IF(G4-K5<=0,0,G4-K5),\"\"),\"\")","v":5342.465753424658},0.2]
[2,500000,"2001-12-15","2001-12-31",{"$f":"F4+B5","v":1150000},{"$f":"IFERROR(IF(OR(B5<>\"\",K5<>\"\"),F4+B5+IF(AND(E5>0,H5<0),H5,0),\"\"),\"\")","v":1150000},{"$f":"IF(D5=\"\",I4+E5*YEARFRAC(C5,C5,$I$2)*J5,I4+E5*YEARFRAC(C5,D5,$I$2)*J5)","v":15424.657534246577},{"$f":"G5-K6","v":15424.657534246577},{"$f":"IFERROR(IF(J5<>\"\",IF(G5-K6<=0,0,G5-K6),\"\"),\"\")","v":15424.657534246577},{"$f":"IF(C5<>\"\",J4,\"\")","v":0.2}]
[3,1200000,"2001-12-31","2002-02-06",{"$f":"F5+B6","v":2350000},{"$f":"IFERROR(IF(OR(B6<>\"\",K6<>\"\"),F5+B6+IF(AND(E6>0,H6<0),H6,0),\"\"),\"\")","v":2350000},{"$f":"IF(D6=\"\",I5+E6*YEARFRAC(C6,C6,$I$2)*J6,I5+E6*YEARFRAC(C6,D6,$I$2)*J6)","v":63068.493150684939},{"$f":"G6-K7","v":63068.493150684939},63068.493150684939,0.2]
[4,750000,"2002-02-06","2002-02-22",{"$f":"F6+B7","v":3100000},3100000,90246.57534246576,90246.57534246576,90246.57534246576,0.2]
[5,350000,"2002-02-22","2002-03-01",3450000,3450000,103479.45205479453,103479.45205479453,103479.45205479453,0.2]
[6,550000,"2002-03-01","2002-04-30",4000000,4000000,234986.30136986301,234986.30136986301,234986.30136986301,0.2]
[7,300000,"2002-04-30","2002-05-08",4300000,4300000,253835.61643835617,253835.61643835617,253835.61643835617,0.2]
[8,500000,"2002-05-08","2002-05-14",4800000,4800000,269616.43835616438,269616.43835616438,269616.43835616438,0.2]
[9,600000,"2002-05-14","2002-05-30",5400000,5400000,316958.90410958906,316958.90410958906,316958.90410958906,0.2]
[10,350000,"2002-05-30","2002-06-05",5750000,5750000,335863.01369863015,335863.01369863015,335863.01369863015,0.2]
[11,300000,"2002-06-05","2002-06-13",6050000,6050000,362383.56164383562,362383.56164383562,362383.56164383562,0.2]
[12,100000,"2002-06-13","2002-06-17",6150000,6150000,375863.01369863015,375863.01369863015,375863.01369863015,0.2]
[13,100000,"2002-06-17","2002-06-18",6250000,6250000,379287.67123287672,379287.67123287672,379287.67123287672,0.2]
[14,500000,"2002-06-18","2002-06-21",6750000,6750000,390383.56164383562,390383.56164383562,390383.56164383562,0.2]
[15,350000,"2002-06-21","2002-07-01",7100000,7100000,429287.67123287672,429287.67123287672,429287.67123287672,0.2]
[16,300000,"2002-07-01","2002-07-08",7400000,7400000,457671.23287671234,457671.23287671234,457671.23287671234,0.2]
[17,350000,"2002-07-08","2002-07-17",7750000,7750000,495890.41095890413,495890.41095890413,495890.41095890413,0.2]
[18,300000,"2002-07-17","2002-07-31",8050000,8050000,557643.83561643842,557643.83561643842,557643.83561643842,0.2]
[19,300000,"2002-07-31","2002-09-23",8350000,8350000,804712.3287671234,804712.3287671234,804712.3287671234,0.2]
[20,175000,"2002-09-23","2002-09-30",8525000,8525000,837410.95890410966,837410.95890410966,837410.95890410966,0.2]
[21,500000,"2002-09-30","2002-10-11",9025000,9025000,891808.21917808231,891808.21917808231,891808.21917808231,0.2]
[22,300000,"2002-10-11","2002-11-21",9325000,9325000,1101301.3698630137,1101301.3698630137,1101301.3698630137,0.2]
[23,300000,"2002-11-21","2002-12-02",9625000,9625000,1159315.0684931506,1159315.0684931506,1159315.0684931506,0.2]
[24,500000,"2002-12-02","2002-12-16",10125000,10125000,1236986.3013698629,1236986.3013698629,1236986.3013698629,0.2]
[25,500000,"2002-12-16","2003-01-28",10625000,10625000,1487328.7671232875,1487328.7671232875,1487328.7671232875,0.2]
[26,500000,"2003-01-28","2003-01-30",11125000,11125000,1499520.5479452054,499520.54794520536,499520.54794520536,0.2]
[1,null,"2003-01-30","2003-02-10",11125000,11125000,566575.34246575332,566575.34246575332,566575.34246575332,0.2,1000000]
[27,500000,"2003-02-10","2003-02-21",11625000,11320443.835616438,636643.8356164383,-304556.1643835617,0,0.2]
[2,null,"2003-02-21","2003-02-28",11320443.835616438,10363864.716081817,43420.880465378119,-956579.11953462183,0,0.2,941200]
[3,null,"2003-02-28","2003-03-30",10363864.716081817,9534229.6155242585,170364.89944244083,-829635.10055755917,0,0.2,1000000]
[4,null,"2003-03-30","2003-04-07",9534229.6155242585,9534229.6155242585,41793.883246133744,41793.883246133744,41793.883246133744,0.2,1000000]
[28,500000,"2003-04-07","2003-04-30",10034229.615524258,9202482.2829660401,168252.66744178196,-831747.33255821804,0,0.2]
[5,null,"2003-04-30","2003-06-03",9202482.2829660401,8673925.7885117084,171443.50554566871,-528556.49445433123,0,0.2,1000000]
[6,null,"2003-06-03","2003-06-30",8673925.7885117084,7802252.361821197,128326.5733094883,-871673.42669051164,0,0.2,700000]
[7,null,"2003-06-30","2003-07-01",7802252.361821197,6806527.5685947975,4275.2067736006566,-995724.79322639934,0,0.2,1000000]
[8,null,"2003-07-01","2003-07-18",6806527.5685947975,6569930.8390967762,63403.270501978943,-236596.72949802107,0,0.2,1000000]
[9,null,"2003-07-18","2003-07-30",6569930.8390967762,5613130.3843401521,43199.545243376058,-956800.45475662395,0,0.2,300000]
[10,null,"2003-07-30","2003-09-08",5613130.3843401521,5613130.3843401521,123027.5152732088,123027.5152732088,123027.5152732088,0.2,1000000]
[29,500000,"2003-09-08","2003-10-01",6113130.3843401521,5813200.0907584699,200069.70641831757,-299930.29358168243,0,0.2]
[11,null,"2003-10-01","2003-10-06",5813200.0907584699,4629126.6663495889,15926.575591119094,-1184073.424408881,0,0.2,500000]
[12,null,"2003-10-06","2003-10-09",4629126.6663495889,3836736.189636739,7609.5232871500084,-792390.47671285004,0,0.2,1200000]
[13,null,"2003-10-09","2003-10-22",3836736.189636739,3836736.189636739,27330.175597412392,27330.175597412392,27330.175597412392,0.2,800000]
[30,1000000,"2003-10-22","2003-10-30",4836736.189636739,3885268.4964763946,48532.306839655634,-951467.69316034438,0,0.2]
[14,null,"2003-10-30","2003-11-30",3885268.4964763946,3451264.8380603772,65996.34158398259,-434003.65841601742,0,0.2,1000000]
[15,null,"2003-11-30","2003-12-30",3451264.8380603772,3007997.9586860272,56733.120625650037,-443266.87937434996,0,0.2,500000]
[16,null,"2003-12-30","2004-01-12",3007997.9586860272,3007997.9586860272,21426.834774201838,21426.834774201838,21426.834774201838,0.2,500000]
[31,300000,"2004-01-12","2004-02-28",3307997.9586860272,2914617.0696565267,106619.11097049953,-393380.88902950048,0,0.2]
[17,null,"2004-02-28","2004-03-30",2914617.0696565267,2464125.6335794595,49508.563922932779,-450491.43607706722,0,0.2,500000]
[18,null,"2004-03-30","2004-04-30",2464125.6335794595,1505982.0142046448,41856.380625185346,-958143.61937481468,0,0.2,500000]
[19,null,"2004-04-30","2004-08-05",1505982.0142046448,1505982.0142046448,80043.975549507159,80043.975549507159,80043.975549507159,0.2,1000000]
[32,500000,"2004-08-05","2004-08-10",2005982.0142046448,2005982.0142046448,85539.816684314399,85539.816684314399,85539.816684314399,0.2]
[33,500000,"2004-08-10","2004-08-18",2505982.0142046446,2505982.0142046446,96524.943321923798,96524.943321923798,96524.943321923798,0.2]
[34,200000,"2004-08-18","2004-08-27",2705982.0142046446,2315851.5263637421,109869.51215909739,-390130.48784090264,0,0.2]
[20,null,"2004-08-27","2004-08-30",2315851.5263637421,2315851.5263637421,3806.8792214198497,3806.8792214198497,3806.8792214198497,0.2,500000]
[35,500000,"2004-08-30","2004-11-03",2815851.5263637421,1919949.0078940075,104097.48153026546,-895902.51846973458,0,0.2]
[21,null,"2004-11-03","2005-04-18",1919949.0078940075,1919949.0078940075,174636.45770433167,174636.45770433167,174636.45770433167,0.2,1000000]
[36,500000,"2005-04-18","2005-05-04",2419949.0078940075,2115801.4569004234,195852.44900641611,-304147.55099358386,0,0.2]
[22,null,"2005-05-04","2005-08-04",2115801.4569004234,1722461.0371934858,106659.58029306245,-393340.41970693757,0,0.2,500000]
[23,null,"2005-08-04","2006-10-04",1722461.0371934858,1124525.9149164583,402064.8777229726,-597935.12227702746,0,0.2,500000]
[24,null,"2006-10-04","2007-02-15",1124525.9149164583,707093.84510758449,82567.930191126259,-417432.06980887376,0,0.2,1000000]
[25,null,"2007-02-15","2007-07-16",707093.84510758449,265598.59612744494,58504.751019860421,-441495.24898013956,0,0.2,500000]
[26,null,"2007-07-16","2007-12-04",265598.59612744494,-213881.18356901,20520.220303545066,-479479.77969645493,0,0.2,500000]
[27,null,"2007-12-04","",-213881.18356901,-213881.18356901,0,0,0,0.2,500000]
[null,null,null,"",-213881.18356901,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C69<>\"\",C69,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(J69<>\"\",IF(G69-K70<=0,0,G69-K70),\"\"),\"\")","v":""},{"$f":"IF(C69<>\"\",J68,\"\")","v":""}]
[null,null,null,"",{"$error":"#VALUE!"},{"$f":"IFERROR(IF(OR(B70<>\"\",K70<>\"\"),F69+B70+IF(AND(E70>0,H70<0),H70,0),\"\"),\"\")","v":""},{"$f":"IF(D70=\"\",I69+E70*YEARFRAC(C70,C70,$I$2)*J70,I69+E70*YEARFRAC(C70,D70,$I$2)*J70)","v":{"$error":"#VALUE!"}},{"$f":"G70-K71","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,"",{"$f":"F70+B71","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C133<>\"\",C133,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(J133<>\"\",IF(G133-K134<=0,0,G133-K134),\"\"),\"\")","v":""},{"$f":"IF(C133<>\"\",J132,\"\")","v":""}]
[null,null,null,"",{"$error":"#VALUE!"},{"$f":"IFERROR(IF(OR(B134<>\"\",K134<>\"\"),F133+B134+IF(AND(E134>0,H134<0),H134,0),\"\"),\"\")","v":""},{"$f":"IF(D134=\"\",I133+E134*YEARFRAC(C134,C134,$I$2)*J134,I133+E134*YEARFRAC(C134,D134,$I$2)*J134)","v":{"$error":"#VALUE!"}},{"$f":"G134-K135","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,"",{"$f":"F134+B135","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C197<>\"\",C197,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(J197<>\"\",IF(G197-K198<=0,0,G197-K198),\"\"),\"\")","v":""},{"$f":"IF(C197<>\"\",J196,\"\")","v":""}]
[null,null,null,"",{"$error":"#VALUE!"},{"$f":"IFERROR(IF(OR(B198<>\"\",K198<>\"\"),F197+B198+IF(AND(E198>0,H198<0),H198,0),\"\"),\"\")","v":""},{"$f":"IF(D198=\"\",I197+E198*YEARFRAC(C198,C198,$I$2)*J198,I197+E198*YEARFRAC(C198,D198,$I$2)*J198)","v":{"$error":"#VALUE!"}},{"$f":"G198-K199","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,"",{"$f":"F198+B199","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,"",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",""]
[null,null,null,{"$f":"IF(C205<>\"\",C205,\"\")","v":""},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$f":"G202-#REF!","v":{"$error":"#VALUE!"}},"",""]
[null,null,null,null,{"$f":"F202+B203","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},{"$f":"G203-#REF!","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(J203<>\"\",IF(G203-#REF!<=0,0,G203-#REF!),\"\"),\"\")","v":""},{"$f":"IF(C203<>\"\",J202,\"\")","v":""}]
["合計",{"$f":"SUBTOTAL(109,表格6[借款])","v":16125000},{"$f":"SUBTOTAL(103,表格6[始日])","v":63},null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,表格6[還款])","v":20441200}]

{"sheet":"資料","index":2,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["主鍵","編號","借款","日期","還款"]
[1,1,650000,"2001-11-30"]
[2,2,500000,"2001-12-15"]
[3,3,1200000,"2001-12-31"]
[4,4,750000,"2002-02-06"]
[5,5,350000,"2002-02-22"]
[6,6,550000,"2002-03-01"]
[7,7,300000,"2002-04-30"]
[8,8,500000,"2002-05-08"]
[9,9,600000,"2002-05-14"]
[10,10,350000,"2002-05-30"]
[11,11,300000,"2002-06-05"]
[12,12,100000,"2002-06-13"]
[13,13,100000,"2002-06-17"]
[14,14,500000,"2002-06-18"]
[15,15,350000,"2002-06-21"]
[16,16,300000,"2002-07-01"]
[17,17,350000,"2002-07-08"]
[18,18,300000,"2002-07-17"]
[19,19,300000,"2002-07-31"]
[20,20,175000,"2002-09-23"]
[21,21,500000,"2002-09-30"]
[22,22,300000,"2002-10-11"]
[23,23,300000,"2002-11-21"]
[24,24,500000,"2002-12-02"]
[25,25,500000,"2002-12-16"]
[26,26,500000,"2003-01-28"]
[27,27,500000,"2003-02-10"]
[28,28,500000,"2003-04-07"]
[29,29,500000,"2003-09-08"]
[30,30,1000000,"2003-10-22"]
[31,31,300000,"2004-01-12"]
[32,32,500000,"2004-08-05"]
[33,33,500000,"2004-08-10"]
[34,34,200000,"2004-08-18"]
[35,35,500000,"2004-08-30"]
[36,36,500000,"2005-04-18"]
[37,1,null,"2003-01-30",1000000]
[38,2,null,"2003-02-21",941200]
[39,3,null,"2003-02-28",1000000]
[40,4,null,"2003-03-30",1000000]
[41,5,null,"2003-04-30",1000000]
[42,6,null,"2003-06-03",700000]
[43,7,null,"2003-06-30",1000000]
[44,8,null,"2003-07-01",1000000]
[45,9,null,"2003-07-18",300000]
[46,10,null,"2003-07-30",1000000]
[47,11,null,"2003-10-01",500000]
[48,12,null,"2003-10-06",1200000]
[49,13,null,"2003-10-09",800000]
[50,14,null,"2003-10-30",1000000]
[51,15,null,"2003-11-30",500000]
[52,16,null,"2003-12-30",500000]
[53,17,null,"2004-02-28",500000]
[54,18,null,"2004-03-30",500000]
[55,19,null,"2004-04-30",1000000]
[56,20,null,"2004-08-27",500000]
[57,21,null,"2004-11-03",1000000]
[58,22,null,"2005-05-04",500000]
[59,23,null,"2005-08-04",500000]
[60,24,null,"2006-10-04",1000000]
[61,25,null,"2007-02-15",500000]
[62,26,null,"2007-07-16",500000]
[63,27,null,"2007-12-04",500000]
["合計",{"$f":"SUBTOTAL(103,表格2[編號])","v":63},{"$f":"SUBTOTAL(109,表格2[借款])","v":16125000},null,{"$f":"SUBTOTAL(109,表格2[還款])","v":20441200}]