{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Budget summary","Itemized expenses","ChartData"],"not_rendered":{"charts":1,"images":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Budget summary","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[{"$nulls":3},"Itemized Expenses"]
[null,"HOME","CONSTRUCTION \nBUDGET"]
[null,"PROJECT INFORMATION"]
[null,"Project name","Kitchen remodel"]
[null,"Project description","Take out old flooring, replace with new tile. Finish and trim all new flooring. Replace current cabinets with more modern style. Finish and trim all cabinets."]
[null,"Contractor","Demo and Build Construction, LLC."]
[null,"Licensed/Bonded number","C#12345678"]
[null,"Contact name","Michael Peltier"]
[null,"Website","http://websitegoeshere.com/"]
[null,"Phone",6035550198]
[null,"Address","789 Smith Street, Bozeman, MT 06030"]
[null,"FINANCIAL STATUS"]
[null,"Account","Amount"]
[null,"Cash amount",{"v":3500,"d":"$3,500"}]
[null,"Financed amount",{"v":0,"d":"$0"}]
[null,"Total allotted funds",{"$f":"SUM(C14:C15)","v":{"v":3500,"d":"$3,500"}}]
[null,"Funds used to date",{"$f":"SUM(Data[Amount])","v":{"v":2810,"d":"$2,810"}}]
[null,"Funds remaining",{"$f":"C16-C17","v":{"v":690,"d":"$690"}}]

{"sheet":"Itemized expenses","index":1,"n_rows":27,"n_cols":5,"rows_kept":27}
[{"$nulls":4},"Budget Summary"]
[null,"LIST","OF \nEXPENSES"]
[null,"PROJECT FUNDS ALLOTTED","FUNDS USED TO DATE","FUNDS REMAINING"]
[null,{"$f":"AllottedFunds","v":{"v":3500,"d":"$3,500.00"}},{"$f":"SUM(Data[Amount])","v":{"v":2810,"d":"$2,810.00"}},{"$f":"FundsRemaining","v":{"v":690,"d":"$690.00"}}]
[null,"Item","Category","Amount"]
[null,"Tile flooring","Materials",{"v":350,"d":"$350.00"}]
[null,"Floor glue","Materials",{"v":75,"d":"$75.00"}]
[null,"Flooring","Materials",{"v":400,"d":"$400.00"}]
[null,"Floor caulking","Materials",{"v":20,"d":"$20.00"}]
[null,"Floor trim","Materials",{"v":40,"d":"$40.00"}]
[null,"New cabinets","Materials",{"v":250,"d":"$250.00"}]
[null,"Cabinet coating","Materials",{"v":200,"d":"$200.00"}]
[null,"Cabinet hardware","Materials",{"v":100,"d":"$100.00"}]
[null,"Take out flooring","Labor",{"v":150,"d":"$150.00"}]
[null,"Strip flooring glue","Labor",{"v":50,"d":"$50.00"}]
[null,"Sand floor","Labor",{"v":50,"d":"$50.00"}]
[null,"Prep floor","Labor",{"v":100,"d":"$100.00"}]
[null,"Floor installation","Labor",{"v":200,"d":"$200.00"}]
[null,"Floor caulking","Labor",{"v":25,"d":"$25.00"}]
[null,"Floor trim","Labor",{"v":50,"d":"$50.00"}]
[null,"Remove old cabinets","Labor",{"v":150,"d":"$150.00"}]
[null,"Prep cabinet area","Labor",{"v":50,"d":"$50.00"}]
[null,"Install new cabinets","Labor",{"v":300,"d":"$300.00"}]
[null,"Caulk cabinets","Labor",{"v":100,"d":"$100.00"}]
[null,"Apply cabinet coating","Labor",{"v":100,"d":"$100.00"}]
[null,"Install cabinet hardware","Labor",{"v":50,"d":"$50.00"}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Data[Amount])","v":{"v":2810,"d":"$2,810.00"}}]

{"sheet":"ChartData","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"hidden":true}
["This sheet should remain hidden."]
["Chart Labels"]
[{"$f":"FundsUsedLabel&\": \"&TEXT(FundsUsed,\"$#,##0.00\")&\" (\"&TEXT(FundsUsed/SUM(FundsUsed:FundsRemaining),\"0%\")&\")\"","v":"Funds used to date: $2,810.00 (80%)"}]
[{"$f":"FundsRemainingLabel&\": \"&TEXT(FundsRemaining,\"$#,##0.00\")&\" (\"&TEXT(FundsRemaining/SUM(FundsUsed:FundsRemaining),\"0%\")&\")\"","v":"Funds remaining: $690.00 (20%)"}]