{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Cost Input","Setup"],"not_rendered":{"charts":1,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[1,1,1,5],[3,7,3,8],[4,7,4,8]]}
[null," DASHBORD FOR"]
[null,{"$f":"IF(LEN($D$4)=0,\"UNTITLED PROJECT\",UPPER($D$4))","v":"BEDROOM EXPANSION"}]
[]
[null,"ENTER PROJECT NAME:",null,"Bedroom Expansion",null,null,"TOTAL ACTUAL:",{"$f":"SUM(tblData[ACTUAL COST])","v":{"v":1849,"d":"$1,849.00"}}]
[null,"ENTER PROJECT BUDGET:",null,{"v":1000,"d":"$1,000.00"},null,null,"DIFFERENCE:",{"$f":"D5-H4","v":{"v":-849,"d":"($849.00)"}}]
[]
[]
[]
[null,"TOTAL ACTUAL"]
[null,"TOTAL BUDGET"]
[]
[]
[]
[null,"AREA","ROOM","ITEM","ESTIMATED ","ACTUAL "]
[null,"House","Bedroom","Carpet",{"v":300,"d":"$300.00"},{"v":450,"d":"$450.00"}]
[{"$nulls":3},"Electrical, general",{"v":500,"d":"$500.00"},{"v":400,"d":"$400.00"}]
[{"$nulls":3},"Networking",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"}]
[null,null,"Bedroom Total",null,{"v":1000,"d":"$1,000.00"},{"v":1050,"d":"$1,050.00"}]
[null,"House Total",null,null,{"v":1000,"d":"$1,000.00"},{"v":1050,"d":"$1,050.00"}]
[null,"Backyard","Yard","Electrical, general",{"v":75,"d":"$75.00"},{"v":85,"d":"$85.00"}]
[{"$nulls":3},"Gardening, general",{"v":50,"d":"$50.00"},{"v":64,"d":"$64.00"}]
[null,null,"Yard Total",null,{"v":125,"d":"$125.00"},{"v":149,"d":"$149.00"}]
[null,"Backyard Total",null,null,{"v":125,"d":"$125.00"},{"v":149,"d":"$149.00"}]
[null,"Guest house","Family room","Networking",{"v":250,"d":"$250.00"},{"v":140,"d":"$140.00"}]
[{"$nulls":3},"Door",{"v":75,"d":"$75.00"},{"v":85,"d":"$85.00"}]
[{"$nulls":3},"Television",{"v":500,"d":"$500.00"},{"v":425,"d":"$425.00"}]
[null,null,"Family room Total",null,{"v":825,"d":"$825.00"},{"v":650,"d":"$650.00"}]
[null,"Guest house Total",null,null,{"v":825,"d":"$825.00"},{"v":650,"d":"$650.00"}]
[null,"Grand Total",null,null,{"v":1950,"d":"$1,950.00"},{"v":1849,"d":"$1,849.00"}]

{"sheet":"Cost Input","index":1,"n_rows":14,"n_cols":8,"rows_kept":14}
[null,"COST INPUT FOR"]
[null,{"$f":"IF(LEN(ProjectName)=0,\"UNTITLED PROJECT\",UPPER(ProjectName))","v":"BEDROOM EXPANSION"}]
[]
[null,"DATE","AREA","ROOM","ITEM","ESTIMATED COST","ACTUAL COST","DIFFERENCE"]
[null,"2012-07-01","House","Bedroom","Carpet",{"v":300,"d":"$300.00"},{"v":450,"d":"$450.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":-150,"d":"($150.00)"}}]
[null,"2012-07-01","House","Bedroom","Networking",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":0,"d":"$0.00"}}]
[null,"2012-07-01","House","Bedroom","Electrical, general",{"v":500,"d":"$500.00"},{"v":400,"d":"$400.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":100,"d":"$100.00"}}]
[null,"2012-07-01","Backyard","Yard","Electrical, general",{"v":75,"d":"$75.00"},{"v":85,"d":"$85.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":-10,"d":"($10.00)"}}]
[null,"2012-07-01","Backyard","Yard","Gardening, general",{"v":50,"d":"$50.00"},{"v":64,"d":"$64.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":-14,"d":"($14.00)"}}]
[null,"2012-07-01","Guest house","Family room","Door",{"v":75,"d":"$75.00"},{"v":85,"d":"$85.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":-10,"d":"($10.00)"}}]
[null,"2012-07-01","Guest house","Family room","Television",{"v":500,"d":"$500.00"},{"v":425,"d":"$425.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":75,"d":"$75.00"}}]
[null,"2012-07-01","Guest house","Family room","Networking",{"v":250,"d":"$250.00"},{"v":140,"d":"$140.00"},{"$f":"tblData[[#This Row],[ESTIMATED COST]]-tblData[[#This Row],[ACTUAL COST]]","v":{"v":110,"d":"$110.00"}}]
[{"$nulls":6},"TOTAL ESTIMATED",{"$f":"SUBTOTAL(109,tblData[ESTIMATED COST])","v":{"v":1950,"d":"$1,950.00"}}]
[{"$nulls":6},"TOTAL ACTUAL",{"$f":"SUBTOTAL(109,tblData[ACTUAL COST])","v":{"v":1849,"d":"$1,849.00"}}]

{"sheet":"Setup","index":2,"n_rows":52,"n_cols":6,"rows_kept":52,"merged":[[3,1,3,5]]}
[null,"DATA LISTS FOR"]
[null,{"$f":"IF(LEN(ProjectName)=0,\"UNTITLED PROJECT\",UPPER(ProjectName))","v":"BEDROOM EXPANSION"}]
[]
[null,"TIP: The tables below populate the drop down lists on the Cost Input sheet to help avoid typing errors and makes it easier for you to add your information. When you change the lists, by adding, modifying, or deleting list items, the drop down lists will update automatically."]
[]
[null,"AREAS",null,"ROOMS",null,"ITEMS"]
[null,"Backyard",null,"Bathroom",null,"Air Conditioning"]
[null,"Basement",null,"Bedroom",null,"Bushes"]
[null,"Carport",null,"Closet",null,"Cabinet"]
[null,"Downstairs",null,"Dining Room",null,"Carpentry, General"]
[null,"Front Yard",null,"Family Room",null,"Carpet"]
[null,"Garage",null,"Garden",null,"Central Air"]
[null,"Garden",null,"Kitchen",null,"Chairs"]
[null,"Guest House",null,"Laundry Room",null,"Computer"]
[null,"House",null,"Living Room",null,"Countertop"]
[null,"Patio",null,"Master Bathroom",null,"Door"]
[null,"Pool",null,"Master Bedroom",null,"Drawer"]
[null,"Shed",null,"Pantry",null,"Electrical, General"]
[null,"Side Yard",null,"TV/movie Room",null,"Entertainment Center"]
[null,"Upstairs",null,"Yard",null,"Fireplace"]
[{"$nulls":5},"Floor"]
[{"$nulls":5},"Furnace"]
[{"$nulls":5},"Gardening, General"]
[{"$nulls":5},"Heat Pump"]
[{"$nulls":5},"HVAC"]
[{"$nulls":5},"Lawn"]
[{"$nulls":5},"Lighting, General"]
[{"$nulls":5},"Linoleum"]
[{"$nulls":5},"Microwave"]
[{"$nulls":5},"Networking"]
[{"$nulls":5},"Paneling"]
[{"$nulls":5},"Patio"]
[{"$nulls":5},"Plumbing, General"]
[{"$nulls":5},"Pool"]
[{"$nulls":5},"Railing"]
[{"$nulls":5},"Satellite"]
[{"$nulls":5},"Shower/Tub"]
[{"$nulls":5},"Shrubbery"]
[{"$nulls":5},"Stairs"]
[{"$nulls":5},"Steps"]
[{"$nulls":5},"Stove/Range"]
[{"$nulls":5},"Swamp Cooler"]
[{"$nulls":5},"Table"]
[{"$nulls":5},"Television"]
[{"$nulls":5},"Tile"]
[{"$nulls":5},"Toilet"]
[{"$nulls":5},"Toiletries"]
[{"$nulls":5},"Trash/Removal"]
[{"$nulls":5},"Trees"]
[{"$nulls":5},"Walkway"]
[{"$nulls":5},"Washer/Dryer"]
[{"$nulls":5},"Windows"]