{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Assets","Liabilities","Categories"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":12,"n_cols":4,"rows_kept":12}
[null,"Balance Sheet"]
[null,null,{"$f":"\"FY-\"&YEAR(TODAY())-1","v":"FY-2016"},{"$f":"\"FY-\"&YEAR(TODAY())","v":"FY-2017"}]
[null,"Asset Type","Previous Year","Current Year"]
[null,"Current Assets",{"$f":"SUMIFS(Assets[Previous Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Previous Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":600,"d":"600 "}},{"$f":"SUMIFS(Assets[Current Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Current Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":600,"d":"600 "}}]
[null,"Fixed Assets",{"$f":"SUMIFS(Assets[Previous Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Previous Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":-100,"d":"(100)"}},{"$f":"SUMIFS(Assets[Current Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Current Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":-85,"d":"(85)"}}]
[null,"Other Assets",{"$f":"SUMIFS(Assets[Previous Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Previous Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Assets[Current Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Current Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":0,"d":"0 "}}]
[null,"Current Liabilities",{"$f":"SUMIFS(Assets[Previous Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Previous Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":500,"d":"500 "}},{"$f":"SUMIFS(Assets[Current Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Current Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":350,"d":"350 "}}]
[null,"Long-term Liabilities",{"$f":"SUMIFS(Assets[Previous Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Previous Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Assets[Current Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Current Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":0,"d":"0 "}}]
[null,"Owner Equity",{"$f":"SUMIFS(Assets[Previous Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Previous Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":0,"d":"0 "}},{"$f":"SUMIFS(Assets[Current Year],Assets[Asset Type],Dashboard[[#This Row],[Asset Type]])+SUMIFS(Liabilities[Current Year],Liabilities[Liability Type],Dashboard[[#This Row],[Asset Type]])","v":{"v":350,"d":"350 "}}]
[null,"Total Assets",{"$f":"Assets[[#Totals],[Previous Year]]","v":{"v":500,"d":"500 "}},{"$f":"Assets[[#Totals],[Current Year]]","v":{"v":515,"d":"515 "}}]
[null,"Total Liabilities & Stockholder Equity",{"$f":"Liabilities[[#Totals],[Previous Year]]","v":{"v":500,"d":"500 "}},{"$f":"Liabilities[[#Totals],[Current Year]]","v":{"v":700,"d":"700 "}}]
[null,"Balance",{"$f":"C10-C11","v":{"v":0,"d":"0 "}},{"$f":"D10-D11","v":{"v":-185,"d":"(185)"}}]

{"sheet":"Assets","index":1,"n_rows":14,"n_cols":5,"rows_kept":14}
[null,"Assets"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2016"},{"$f":"FY_YEAR_2","v":"FY-2017"}]
[null,"Asset Type","Description","Previous Year","Current Year"]
[null,"Current Assets","Cash",{"v":600,"d":"600 "},{"v":600,"d":"600 "}]
[null,"Current Assets","Investments"]
[null,"Current Assets","Inventories"]
[null,"Current Assets","Accounts receivable"]
[null,"Current Assets","Pre-paid expenses"]
[null,"Fixed Assets","Property and equipment"]
[null,"Fixed Assets","Leasehold improvements"]
[null,"Fixed Assets","Equity and other investments"]
[null,"Fixed Assets","Less accumulated depreciation (Negative Value)",{"v":-100,"d":"(100)"},{"v":-85,"d":"(85)"}]
[null,"Other Assets","Charity"]
[null,"Total Assets",null,{"$f":"SUBTOTAL(109,Assets[Previous Year])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,Assets[Current Year])","v":{"v":515,"d":"515 "}}]

{"sheet":"Liabilities","index":2,"n_rows":12,"n_cols":5,"rows_kept":12}
[null,"Liabilities"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2016"},{"$f":"FY_YEAR_2","v":"FY-2017"}]
[null,"Liability Type","Description","Previous Year","Current Year"]
[null,"Current Liabilities","Accounts payable",null,{"v":350,"d":"350 "}]
[null,"Current Liabilities","Accrued wages"]
[null,"Current Liabilities","Accrued compensation",{"v":500,"d":"500 "}]
[null,"Current Liabilities","Income tax payable"]
[null,"Current Liabilities","Unearned revenue"]
[null,"Long-term Liabilities","Mortgage payable"]
[null,"Owner Equity","Investment capital",null,{"v":350,"d":"350 "}]
[null,"Owner Equity","Accumulated retained earnings"]
[null,"Total Liabilities & Stockholder Equity",null,{"$f":"SUBTOTAL(109,Liabilities[Previous Year])","v":{"v":500,"d":"500 "}},{"$f":"SUBTOTAL(109,Liabilities[Current Year])","v":{"v":700,"d":"700 "}}]

{"sheet":"Categories","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"Categories"]
[]
[null,"Categories"]
[null,"Current Assets"]
[null,"Fixed Assets"]
[null,"Other Assets"]
[null,"Current Liabilities"]
[null,"Long-term Liabilities"]
[null,"Owner Equity"]