{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["サマリー","資産","負債","分類"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"サマリー","index":0,"n_rows":12,"n_cols":4,"rows_kept":12}
[null,"貸借対照表"]
[null,null,{"$f":"\"FY-\"&YEAR(TODAY())-1","v":"FY-2016"},{"$f":"\"FY-\"&YEAR(TODAY())","v":"FY-2017"}]
[null,"資産の種類","前年度","現行年度"]
[null,"流動資産",{"$f":"SUMIFS(資産[前年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[前年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":600,"d":"600 "}},{"$f":"SUMIFS(資産[現行年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[現行年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":600,"d":"600 "}}]
[null,"固定資産",{"$f":"SUMIFS(資産[前年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[前年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":-100,"d":"(100)"}},{"$f":"SUMIFS(資産[現行年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[現行年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":-85,"d":"(85)"}}]
[null,"その他の資産",{"$f":"SUMIFS(資産[前年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[前年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(資産[現行年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[現行年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":0,"d":"0 "}}]
[null,"流動負債",{"$f":"SUMIFS(資産[前年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[前年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":500,"d":"500 "}},{"$f":"SUMIFS(資産[現行年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[現行年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":350,"d":"350 "}}]
[null,"固定負債",{"$f":"SUMIFS(資産[前年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[前年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(資産[現行年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[現行年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":0,"d":"0 "}}]
[null,"自己資本",{"$f":"SUMIFS(資産[前年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[前年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(資産[現行年度],資産[資産の種類],ダッシュボード[[#This Row],[資産の種類]])+SUMIFS(負債[現行年度],負債[負債の種類],ダッシュボード[[#This Row],[資産の種類]])","v":{"v":350,"d":"350 "}}]
[null,"合計資産",{"$f":"資産[[#Totals],[前年度]]","v":{"v":500,"d":"500 "}},{"$f":"資産[[#Totals],[現行年度]]","v":{"v":515,"d":"515 "}}]
[null,"負債と純資産の合計",{"$f":"負債[[#Totals],[前年度]]","v":{"v":500,"d":"500 "}},{"$f":"負債[[#Totals],[現行年度]]","v":{"v":700,"d":"700 "}}]
[null,"差引勘定",{"$f":"C10-C11","v":{"v":0,"d":"0 "}},{"$f":"D10-D11","v":{"v":-185,"d":"(185)"}}]

{"sheet":"資産","index":1,"n_rows":14,"n_cols":5,"rows_kept":14}
[null,"資産"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2016"},{"$f":"FY_YEAR_2","v":"FY-2017"}]
[null,"資産の種類","説明","前年度","現行年度"]
[null,"流動資産","現金",{"v":600,"d":"600 "},{"v":600,"d":"600 "}]
[null,"流動資産","投資"]
[null,"流動資産","在庫"]
[null,"流動資産","売掛金"]
[null,"流動資産","前払い費用"]
[null,"固定資産","有形固定資産"]
[null,"固定資産","建物附属設備"]
[null,"固定資産","持ち分とその他の投資"]
[null,"固定資産","減価償却累計額 (負の値)",{"v":-100,"d":"(100)"},{"v":-85,"d":"(85)"}]
[null,"その他の資産","募金/寄付"]
[null,"合計資産",null,{"$f":"SUBTOTAL(109,資産[前年度])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,資産[現行年度])","v":{"v":515,"d":"515 "}}]

{"sheet":"負債","index":2,"n_rows":12,"n_cols":5,"rows_kept":12}
[null,"負債"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2016"},{"$f":"FY_YEAR_2","v":"FY-2017"}]
[null,"負債の種類","説明","前年度","現行年度"]
[null,"流動負債","買掛金",null,{"v":350,"d":"350 "}]
[null,"流動負債","未払賃金"]
[null,"流動負債","未払報酬",{"v":500,"d":"500 "}]
[null,"流動負債","未払法人税等"]
[null,"流動負債","前受収益"]
[null,"固定負債","抵当借入金"]
[null,"自己資本","投資資本",null,{"v":350,"d":"350 "}]
[null,"自己資本","累積利益剰余金"]
[null,"負債と純資産の合計",null,{"$f":"SUBTOTAL(109,負債[前年度])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,負債[現行年度])","v":{"v":700,"d":"700 "}}]

{"sheet":"分類","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"分類"]
[]
[null,"分類"]
[null,"流動資産"]
[null,"固定資産"]
[null,"その他の資産"]
[null,"流動負債"]
[null,"固定負債"]
[null,"自己資本"]