{"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":600},{"$f":"SUMIFS(资产[当前年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[当前年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":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":0},{"$f":"SUMIFS(资产[当前年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[当前年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":0}]
[null,"流动负债",{"$f":"SUMIFS(资产[上一年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[上一年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":500},{"$f":"SUMIFS(资产[当前年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[当前年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":350}]
[null,"长期负债",{"$f":"SUMIFS(资产[上一年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[上一年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":0},{"$f":"SUMIFS(资产[当前年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[当前年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":0}]
[null,"所有者权益",{"$f":"SUMIFS(资产[上一年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[上一年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":0},{"$f":"SUMIFS(资产[当前年度],资产[资产类型],仪表板[[#This Row],[资产类型]])+SUMIFS(负债[当前年度],负债[负债类型],仪表板[[#This Row],[资产类型]])","v":350}]
[null,"总资产",{"$f":"资产[[#Totals],[上一年度]]","v":500},{"$f":"资产[[#Totals],[当前年度]]","v":515}]
[null,"总负债和股东权益",{"$f":"负债[[#Totals],[上一年度]]","v":500},{"$f":"负债[[#Totals],[当前年度]]","v":700}]
[null,"余额",{"$f":"C10-C11","v":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,"流动资产","现金",600,600]
[null,"流动资产","投资"]
[null,"流动资产","库存"]
[null,"流动资产","应收帐款"]
[null,"流动资产","预付费用"]
[null,"固定资产","财产和设备"]
[null,"固定资产","租赁权益改良"]
[null,"固定资产","产权及其他投资"]
[null,"固定资产","减去累计折旧（负值）",{"v":-100,"d":"(100)"},{"v":-85,"d":"(85)"}]
[null,"其他资产","慈善"]
[null,"总资产",null,{"$f":"SUBTOTAL(109,资产[上一年度])","v":500},{"$f":"SUBTOTAL(109,资产[当前年度])","v":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,350]
[null,"流动负债","应付工资"]
[null,"流动负债","应付薪酬",500]
[null,"流动负债","应付所得税"]
[null,"流动负债","预收收入"]
[null,"长期负债","应付抵押款"]
[null,"所有者权益","投资资本",null,350]
[null,"所有者权益","累计留存收益"]
[null,"总负债和股东权益",null,{"$f":"SUBTOTAL(109,负债[上一年度])","v":500},{"$f":"SUBTOTAL(109,负债[当前年度])","v":700}]

{"sheet":"类别","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"类别"]
[]
[null,"类别"]
[null,"流动资产"]
[null,"固定资产"]
[null,"其他资产"]
[null,"流动负债"]
[null,"长期负债"]
[null,"所有者权益"]