{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["0_ポートフォリオ","1_資産推移"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"0_ポートフォリオ","index":0,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"資産配分のシミュレーションツール",null,null,null,null,null,null,null,null,null,null,null,null,null,"年間投資額",100000]
[null,null,"https://myindex.jp/user/myaa.php",null,null,null,null,null,null,null,null,null,null,null,"※ 投資は自己責任で"]
[null,"資産グループ","国内株","持ち株会","海外株(先進株)","ｴﾏｰｼﾞｪﾝｼｰ株(新興株)","全世界株式","国債","国内債券","外国債(先進債)","外国債(エマージング債券)","国内REIT","海外REIT","FX","総資産(評価額)"]
[null,"詳細(購入銘柄)","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx","xxxxxx"]
[null,"割合",0.15,0.15,0.15,0.15,0,0.15,0,0,0,0.15,0.1,0,{"$f":"SUM(C6:N6)","v":1}]
[null,"総資産適正分割額",{"$f":"$O$8*C6","v":1312.5},{"$f":"$O$8*D6","v":1312.5},{"$f":"$O$8*E6","v":1312.5},{"$f":"$O$8*F6","v":1312.5},{"$f":"$O$8*G6","v":0},{"$f":"$O$8*H6","v":1312.5},0,0,0,1312.5,875,0]
[null,"資産評価額(現在)",600,1000,1550,1000,0,4200,0,0,0,200,200,0,{"$f":"SUM(C8:N8)","v":8750}]
[null,"過不足割合",{"$f":"(C8-C7)/C7","v":-0.54285714285714282},-0.23809523809523808,0.18095238095238095,-0.23809523809523808,{"$error":"#DIV/0!"},2.2000000000000002,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-0.84761904761904761,-0.77142857142857146,{"$error":"#DIV/0!"}]
[null,"信託報酬",1.7279999999999999E-3,0,1.836E-3,3.6719999999999999E-3,null,null,null,null,null,2.7000000000000001E-3,5.94E-3]
[null,"信託報酬割合",{"$f":"C10*C6","v":2.5919999999999996E-4},{"$f":"D10*D6","v":0},2.7539999999999997E-4,5.5079999999999994E-4,0,0,0,0,0,4.0500000000000003E-4,5.9400000000000002E-4,0,{"$f":"SUM(C11:N11)","v":2.0843999999999997E-3}]
[null,"通常月購入額",{"$f":"$O$12*C6","v":1250},1250,1250,1250,0,1250,0,0,0,1250,833.33333333333348,0,{"$f":"R2/12","v":8333.3333333333339}]
[null,"毎日積立購入額",{"$f":"C12/30","v":41.666666666666664},{"$f":"D12/30","v":41.666666666666664},41.666666666666664,41.666666666666664,{"$f":"G12/30","v":0},41.666666666666664,0,0,0,{"$f":"L12/30","v":41.666666666666664},27.777777777777782]
[null,"リバランス額",{"$f":"C7-C8","v":712.5},312.5,-237.5,312.5,0,-2887.5,0,0,0,1112.5,675,0]
[null,"新規購入額",{"$f":"C12+C14","v":1962.5},1562.5,1012.5,1562.5,{"$f":"G12+G14","v":0},-1637.5,0,0,0,2362.5,1508.3333333333335,0]
[null,"備考"]

{"sheet":"1_資産推移","index":1,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Index","日時","国内株","持ち株会","海外株(先進株)","ｴﾏｰｼﾞｪﾝｼｰ株(新興株)","全世界株式","国債","国内債券","外国債(先進債)","外国債(エマージング債券)","国内REIT","海外REIT","FX","総資産(評価額)"]
[1,"2021-04-10",420,560,2100,700,0,2940,0,0,0,140,140,0,7000]
[2,"2021-04-12",600,800,3000,1000,0,4200,0,0,0,200,200,0,10000]
[3,"2021-04-13",600,1000,1550,1000,0,4200,0,0,0,200,200,0,8750]
[4,"2022-01-09",600,1000,1550,1000,0,4200,0,0,0,200,200,0,8750]