{"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":"Preceding_Year","v":"2018 年"},{"$f":"Current_Year","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":"Preceding_Year","v":"2018 年"},{"$f":"Current_Year","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"}}]