{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["概要","資産","負債と資本"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"概要","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
[{"$nulls":4}," "]
[null,null,{"$f":"YEAR(TODAY())-1 & \" 年\"","v":"2018 年"},{"$f":"YEAR(TODAY()) & \" 年\"","v":"2019 年"}]
[]
[null,"残高概要","年 1","年 2"]
[null,"合計資産",{"$f":"表_流動資産[[#Totals],[年 1]]+表_固定資産[[#Totals],[年 1]]+表_その他の資産[[#Totals],[年 1]]","v":{"v":9545,"d":"¥9,545.00"}},{"$f":"表_流動資産[[#Totals],[年 2]]+表_固定資産[[#Totals],[年 2]]+表_その他の資産[[#Totals],[年 2]]","v":{"v":12735,"d":"¥12,735.00"}}]
[null,"合計負債と合計資本",{"$f":"表_流動負債[[#Totals],[年 1]]+表_長期負債[[#Totals],[年 1]]+表_資本[[#Totals],[年 1]]","v":{"v":8540,"d":"¥8,540.00"}},{"$f":"表_流動負債[[#Totals],[年 2]]+表_長期負債[[#Totals],[年 2]]+表_資本[[#Totals],[年 2]]","v":{"v":6227,"d":"¥6,227.00"}}]
[null,"残高",{"$f":"C5-C6","v":{"v":1005,"d":"¥1,005.00"}},{"$f":"D5-D6","v":{"v":6508,"d":"¥6,508.00"}}]

{"sheet":"資産","index":1,"n_rows":21,"n_cols":5,"rows_kept":21}
[{"$nulls":4}," "]
[null,null,{"$f":"前年度","v":"2018 年"},{"$f":"現行年度","v":"2019 年"}]
[null,"流動資産","年 1","年 2"]
[null,"現金",{"v":1000,"d":"¥1,000.00"},{"v":1700,"d":"¥1,700.00"}]
[null,"投資",{"v":1500,"d":"¥1,500.00"},{"v":2550,"d":"¥2,550.00"}]
[null,"在庫",{"v":650,"d":"¥650.00"},{"v":1250,"d":"¥1,250.00"}]
[null,"売掛金",{"v":150,"d":"¥150.00"},{"v":230,"d":"¥230.00"}]
[null,"前払い費用",{"v":1230,"d":"¥1,230.00"},{"v":950,"d":"¥950.00"}]
[null,"その他",{"v":120,"d":"¥120.00"},{"v":120,"d":"¥120.00"}]
[null,"合計流動資産",{"$f":"SUBTOTAL(109,表_流動資産[年 1])","v":{"v":4650,"d":"¥4,650.00"}},{"$f":"SUBTOTAL(109,表_流動資産[年 2])","v":{"v":6800,"d":"¥6,800.00"}}]
[]
[null,"固定資産","年 1","年 2"]
[null,"有形固定資産",{"v":2500,"d":"¥2,500.00"},{"v":2500,"d":"¥2,500.00"}]
[null,"建物附属設備",{"v":450,"d":"¥450.00"},{"v":350,"d":"¥350.00"}]
[null,"持ち分とその他の投資",{"v":1250,"d":"¥1,250.00"},{"v":1600,"d":"¥1,600.00"}]
[null,"減価償却累計額",{"v":545,"d":"¥545.00"},{"v":1295,"d":"¥1,295.00"}]
[null,"合計固定資産",{"$f":"SUBTOTAL(109,表_固定資産[年 1])","v":{"v":4745,"d":"¥4,745.00"}},{"$f":"SUBTOTAL(109,表_固定資産[年 2])","v":{"v":5745,"d":"¥5,745.00"}}]
[]
[null,"その他の資産","年 1","年 2"]
[null,"営業権",{"v":150,"d":"¥150.00"},{"v":190,"d":"¥190.00"}]
[null,"合計その他の資産",{"$f":"SUBTOTAL(109,表_その他の資産[年 1])","v":{"v":150,"d":"¥150.00"}},{"$f":"SUBTOTAL(109,表_その他の資産[年 2])","v":{"v":190,"d":"¥190.00"}}]

{"sheet":"負債と資本","index":2,"n_rows":19,"n_cols":5,"rows_kept":19}
[{"$nulls":4}," "]
[null,null,{"$f":"前年度","v":"2018 年"},{"$f":"現行年度","v":"2019 年"}]
[null,"流動負債","年 1","年 2"]
[null,"買掛金",{"v":180,"d":"¥180.00"},{"v":252,"d":"¥252.00"}]
[null,"未払賃金",{"v":250,"d":"¥250.00"},{"v":370,"d":"¥370.00"}]
[null,"未払報酬",{"v":240,"d":"¥240.00"},{"v":190,"d":"¥190.00"}]
[null,"未払法人税等",{"v":120,"d":"¥120.00"},{"v":130,"d":"¥130.00"}]
[null,"前受収益",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"}]
[null,"その他",{"v":250,"d":"¥250.00"},{"v":235,"d":"¥235.00"}]
[null,"合計流動負債",{"$f":"SUBTOTAL(109,表_流動負債[年 1])","v":{"v":1040,"d":"¥1,040.00"}},{"$f":"SUBTOTAL(109,表_流動負債[年 2])","v":{"v":1177,"d":"¥1,177.00"}}]
[]
[null,"長期負債","年 1","年 2"]
[null,"抵当借入金",{"v":1500,"d":"¥1,500.00"},{"v":1900,"d":"¥1,900.00"}]
[null,"合計長期負債",{"$f":"SUBTOTAL(109,表_長期負債[年 1])","v":{"v":1500,"d":"¥1,500.00"}},{"$f":"SUBTOTAL(109,表_長期負債[年 2])","v":{"v":1900,"d":"¥1,900.00"}}]
[]
[null,"資本","年 1","年 2"]
[null,"投資資本",{"v":5500,"d":"¥5,500.00"},{"v":2500,"d":"¥2,500.00"}]
[null,"累積利益剰余金",{"v":500,"d":"¥500.00"},{"v":650,"d":"¥650.00"}]
[null,"合計資本",{"$f":"SUBTOTAL(109,表_資本[年 1])","v":{"v":6000,"d":"¥6,000.00"}},{"$f":"SUBTOTAL(109,表_資本[年 2])","v":{"v":3150,"d":"¥3,150.00"}}]