{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["基準価額貼付","分配金貼付","パフォーマンス","期間指定パフォーマンス"],"not_rendered":{"charts":4,"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":"基準価額貼付","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["日付","基準価額"]

{"sheet":"分配金貼付","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["決算年月日","分配金"]

{"sheet":"パフォーマンス","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["日付","基準価額","分配金","分配金再投資基準価額","騰落率","最大下落率",null,"パフォーマンス分析"]
[{"$f":"WORKDAY(A3,-1)","v":{"$error":"#VALUE!"}},10000,0,10000,"－","－",null,"作成者　　：","ムササビ親分"]
[{"$f":"TEXT(基準価額貼付!A2,\"0000!/00!/00\")*1","v":{"$error":"#VALUE!"}},{"$f":"基準価額貼付!B2","v":0},{"$f":"SUMIF(分配金貼付!A:A,基準価額貼付!A2,分配金貼付!B:B)","v":0},{"$f":"D2*(B3+C3)/B2","v":0},{"$f":"D3/D2-1","v":-1},{"$f":"D3/MAX(D$2:D3)-1","v":-1},null,"公表サイト：","負けない資産運用の王道"]
[null,null,null,null,null,null,null,"※分析結果は将来の運用成果を保証するものではありません。運用結果は自己責任です。"]
[]
[null,null,null,null,null,null,null,"データ期間",null,{"$f":"A2","v":{"$error":"#VALUE!"}},"～",{"$f":"MAX(A:A)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"分配金再投資基準価額",null,{"$f":"VLOOKUP(L6,A:F,4,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"騰落率",null,{"$f":"VLOOKUP(MAX(A:A),A:D,4,0)/10000-1","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"リターン（年率）",null,{"$f":"(1+J8)^(365/(MAX(A:A)-A2))-1","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"リスク（年率）",null,{"$f":"STDEV(E:E)*SQRT(250)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"最大下落率",null,{"$f":"MIN(F:F)","v":-1}]
[null,null,null,null,null,null,null,"最大下落期間",null,{"$f":"INDEX(A:A,MATCH(MAX(INDIRECT(\"D2:D\"&MATCH(J11,F:F,0))),D:D,0))","v":{"$error":"#VALUE!"}},"～",{"$f":"INDEX(A:A,MATCH(J11,F:F,0))","v":{"$error":"#VALUE!"}}]

{"sheet":"期間指定パフォーマンス","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["日付","分配金再投資基準価額","分配金再投資基準価額（指数化）","騰落率","最大下落率",null,"パフォーマンス分析"]
[null,null,{"$f":"B2/B$2*100","v":{"$error":"#DIV/0!"}},"－","－",null,"作成者　　：","ムササビ親分"]
[null,null,{"$f":"B3/B$2*100","v":{"$error":"#DIV/0!"}},{"$f":"C3/C2-1","v":{"$error":"#DIV/0!"}},{"$f":"C3/MAX(C$2:C3)-1","v":{"$error":"#DIV/0!"}},null,"公表サイト：","負けない資産運用の王道"]
[null,null,null,null,null,null,"※分析結果は将来の運用成果を保証するものではありません。運用結果は自己責任です。"]
[]
[null,null,null,null,null,null,"期間指定（手入力）→",null,null,"～",null,null,"データ開始行","データ終了行"]
[null,null,null,null,null,null,"データ期間",null,{"$f":"IF(I6<パフォーマンス!$A$2,パフォーマンス!$A$2,VLOOKUP(I6,パフォーマンス!$A:$A,1,1))","v":{"$error":"#VALUE!"}},"～",{"$f":"IF(K6<パフォーマンス!$A$2,パフォーマンス!$A$2,VLOOKUP(K6,パフォーマンス!$A:$A,1,1))","v":{"$error":"#VALUE!"}},null,{"$f":"MATCH(I7,パフォーマンス!A:A,0)","v":{"$error":"#VALUE!"}},{"$f":"MATCH(K7,パフォーマンス!A:A,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"騰落率",null,{"$f":"VLOOKUP(MAX(A:A),A:C,3,0)/100-1","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"リターン（年率）",null,{"$f":"(1+I8)^(365/(MAX(A:A)-A2))-1","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"リスク（年率）",null,{"$f":"STDEV(D:D)*SQRT(250)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"最大下落率",null,{"$f":"MIN(E:E)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"最大下落期間",null,{"$f":"INDEX(A:A,MATCH(MAX(INDIRECT(\"C2:C\"&MATCH(I11,E:E,0))),C:C,0))","v":{"$error":"#DIV/0!"}},"～",{"$f":"INDEX(A:A,MATCH(I11,E:E,0))","v":{"$error":"#DIV/0!"}}]