{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["決算入力","決算分析"],"not_rendered":{"charts":6,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"決算入力","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"merged":[[0,6,0,7],[0,11,0,12],[0,15,0,16],[1,11,1,12],[1,15,1,16]],"flags":["formulas_cached_only"]}
["【はっしゃん式】決算入力シート",{"$nulls":9},"コード","銘柄名",null,"決算年","決算月","更新日"]
[{"$nulls":10},"xxxx","会社名",null,2021,3,"2021-11-08T15:24:11.570"]
["■時系列決算データ比較"]
[null,null,"2017年","3月期","構成比","2018年","3月期","構成比","2019年","3月期","構成比","2020年","3月期","構成比","2021年","3月期","構成比"]
[null,"売上高",null,null,"百万",null,null,"百万",null,null,"百万",null,null,"百万",null,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,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[null,"営業利益",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[null,"経常利益",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,0,"-"]
[null,"純利益",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,0,"-"]
[]
[null,"発行株数",null,null,"千株",null,null,"千株",null,null,"千株",null,null,"千株",null,0,"千株"]
[null,"ＥＰＳ／ＰＥＲ",null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[]
[null,null,"資産","資本","負債","資産","資本","負債","資産","資本","負債","資産","資本","負債","資産","資本","負債"]
[null,"バランスシート",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
[null,"ＢＰＳ／ＰＢＲ",{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"}]
[null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"}]
[null,null,"営業","投資","財務","営業","投資","財務","営業","投資","財務","営業","投資","財務","営業","投資","財務"]
[null,"キャッシュフロー",{"$nulls":12},0,0,0]
[null,"現金残／ＦＣＦ",null,null,0,null,null,0,null,null,0,null,null,0,null,0,0]
[]
[null,null,"資産価値","事業価値","理論株価","資産価値","事業価値","理論株価","資産価値","事業価値","理論株価","資産価値","事業価値","理論株価","資産価値","事業価値","理論株価"]
[null,"理論株価",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"株価／理論比","2017-03-31",null,{"v":0,"d":"0.0%"},"2018-03-31",null,{"v":0,"d":"0.0%"},"2019-03-31",null,{"v":0,"d":"0.0%"},"2020-03-31",null,{"v":0,"d":"0.0%"},"2021-11-08",0,{"v":0,"d":"0.0%"}]
[]
["■今期会社予想"]
[null,null,"期初",null,"前期比","１Q","","前期比","２Ｑ","","前期比","３Ｑ","","前期比","実績","","前期比"]
[null,"売上高",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[null,"経常利益",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[null,"純利益",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[]
["■今期四半期決算"]
[null,null,"期初",null,"前期比","１Ｑ",null,"進捗率","２Ｑ",null,"進捗率","３Ｑ",null,"進捗率","４Ｑ",null,"進捗率"]
[null,"売上高",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},null,{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"}]
[null,"経常利益",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},null,{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"}]
[null,"純利益",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},null,{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"},null,null,{"v":0,"d":"0.0%"}]
[]
[null,"発行株数",null,0,"千株",null,null,"千株",null,null,"千株",null,null,"千株",null,null,"千株"]
[null,"ＥＰＳ／ＰＥＲ",null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[]
[null,null,"資産","資本","負債","資産","資本","負債","資産","資本","負債","資産","資本","負債","資産","資本","負債"]
[null,"バランスシート",0,0,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"ＢＰＳ／ＰＢＲ",{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"}]
[null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"},null,null,{"v":0,"d":"0.0"}]
[null,null,"営業","投資","財務","営業","投資","財務","営業","投資","財務","営業","投資","財務","営業","投資","財務"]
[null,"キャッシュフロー"]
[null,"現金残／ＦＣＦ",null,0,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[null,null,"資産価値","事業価値","理論株価","資産価値","事業価値","理論株価","資産価値","事業価値","理論株価","資産価値","事業価値","理論株価","資産価値","事業価値","理論株価"]
[null,"理論株価",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"株価／理論比","2020-03-31",0,{"v":0,"d":"0.0%"},"2020-06-30",null,{"v":0,"d":"0.0%"},"2020-09-30",null,{"v":0,"d":"0.0%"},"2020-12-31",null,{"v":0,"d":"0.0%"},"2021-03-31",null,{"v":0,"d":"0.0%"}]

{"sheet":"決算分析","index":1,"n_rows":114,"n_cols":17,"rows_kept":114,"merged":[[0,11,0,12],[0,15,0,16],[1,11,1,12],[1,15,1,16]],"flags":["formulas_cached_only"]}
["【はっしゃん式】決算分析シート",{"$nulls":9},"コード","銘柄名",null,"決算年","決算月","更新日"]
[{"$nulls":10},"xxxx","会社名",null,2021,3,"2021-11-08T15:24:11.570"]
["■時系列決算データ比較"]
[null,null,"2017年","3月期","構成比","2018年","3月期","構成比","2019年","3月期","構成比","2020年","3月期","構成比","2021年","3月期","構成比"]
[null,"売上高",null,0,"百万",null,0,"百万",null,0,"百万",null,0,"百万",null,0,"百万"]
[null,"売上原価",null,0,"-",null,0,"-",null,0,"-",null,0,"-",null,0,"-"]
[null,"売上総利益",null,0,"-",null,0,"-",null,0,"-",null,0,"-",null,0,"-"]
[null,"販管費",null,0,"-",null,0,"-",null,0,"-",null,0,"-",null,0,"-"]
[null,"営業利益",null,0,"-",null,0,"-",null,0,"-",null,0,"-",null,0,"-"]
[null,"経常利益",null,0,"-",null,0,"-",null,0,"-",null,0,"-",null,0,"-"]
[null,"純利益",null,0,"-",null,0,"-",null,0,"-",null,0,"-",null,0,"-"]
[]
[null,"発行株数",null,0,"千株",null,0,"千株",null,0,"千株",null,0,"千株",null,0,"千株"]
[null,"ＥＰＳ／ＰＥＲ",null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[]
[null,null,"資産","資本","負債","資産","資本","負債","資産","資本","負債","資産","資本","負債","資産","資本","負債"]
[null,"バランスシート",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ＢＰＳ／ＰＢＲ",{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0%"},0,{"v":0,"d":"0.0"}]
[]
[null,null,"営業","投資","財務","営業","投資","財務","営業","投資","財務","営業","投資","財務","営業","投資","財務"]
[null,"キャッシュフロー",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"現金残／ＦＣＦ",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
{"$rows_empty":28}
["■時系列比較データ"]
[null,null,"売上",{"$nulls":4},"売上増収率",{"$nulls":3},"前期比","売上増収率",{"$nulls":3},"３期前比較"]
[null,"売上","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"経常利益",{"$nulls":4},"経常増益率",{"$nulls":3},"前期比","経常増益率",{"$nulls":3},"３期前比較"]
[null,"経常利益","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"株価",null,"(期末株価)",null,null,"株価上昇率",{"$nulls":3},"前期比","株価上昇率",{"$nulls":3},"３期前比較"]
[null,"株価","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"発行株数",{"$nulls":4},"発行株数増加率",{"$nulls":3},"前期比","発行株数増加率",{"$nulls":3},"３期前比較"]
[null,"発行株数","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"時価総額",{"$nulls":4},"時価総額増加率",{"$nulls":3},"前期比","時価総額増加率",{"$nulls":3},"３期前比較"]
[null,"時価総額","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"ＥＰＳ",null,"(経常*30%)",null,null,"ＥＰＳ増加率",{"$nulls":3},"前期比","ＥＰＳ増加率",{"$nulls":3},"３期前比較"]
[null,"ＥＰＳ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"現金残",{"$nulls":4},"現金残増加率",{"$nulls":3},"前期比","現金残増加率",{"$nulls":3},"３期前比較"]
[null,"現金残","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[]
[null,null,"売上原価",{"$nulls":4},"粗利益",{"$nulls":3},"前期比","販管費",{"$nulls":3},"３期前比較"]
[null,"ＰＬ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"粗利益率",{"$nulls":4},"販管費比率",{"$nulls":3},"前期比","経常利益率",{"$nulls":3},"３期前比較"]
[null,"利益率","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"１株資産",{"$nulls":4},"１株資本",{"$nulls":4},"１株負債"]
[null,"１株ＢＳ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ＲＯＡ",null,"(経常*30%)",null,null,"ＲＯＥ",null,"(経常*30%)",null,null,"自己資本比率"]
[null,"収益効率","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[]
[null,null,"資産価値",{"$nulls":4},"事業価値",{"$nulls":4},"理論株価"]
[null,"理論株価","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"ＰＢＲ",{"$nulls":4},"理論ＰＢＲ"]
[null,"ＰＢＲ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"ＰＥＲ",null,"(経常*30%)",null,null,"理論ＰＥＲ"]
[null,"ＰＥＲ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[]
[null,null,"営業ＣＦ",{"$nulls":4},"投資ＣＦ",{"$nulls":4},"財務ＣＦ"]
[null,"１株ＣＦ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"ＦＣＦ",{"$nulls":4},"ＰＣＦＲ",{"$nulls":4},"理論ＰＣＦＲ"]
[null,"１株ＣＦ","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)","４期前","３期前","２期前","前期","(今期)"]
[null,2021,0,0,0,0,0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]