{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["BUDGET SUMMARY","ITEMIZED EXPENSES","ChartData"],"not_rendered":{"charts":1,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"BUDGET SUMMARY","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"merged":[[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
[]
[]
[]
[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","Alpine Ski House"]
[null,"Licensed/Bonded Number","C#12345678"]
[null,"Contact Name","Mike Miller"]
[null,"Website","http://www.alpineskihouse.com/"]
[null,"Phone",6035550198]
[null,"Address","789 Smith Street, Bozeman, MT 06030"]
[]
[null,"FINANCIAL STATUS"]
[]
[null,"Cash Amount",{"v":3500,"d":"$3,500"}]
[null,"Financed Amount",{"v":0,"d":"$0"}]
[null,"Total Allotted Funds",{"$f":"SUM(C19:C20)","v":{"v":3500,"d":"$3,500.00"}}]
[null,"Funds Used To Date",{"$f":"SUM(tblData[Amount])","v":{"v":2810,"d":"$2,810.00"}}]
[null,"Funds Remaining",{"$f":"C21-C22","v":{"v":690,"d":"$690.00"}}]

{"sheet":"ITEMIZED EXPENSES","index":1,"n_rows":31,"n_cols":4,"rows_kept":31}
[]
[]
[]
[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(tblData[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,tblData[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%)"}]