{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Example","Construction Budget","Budget Review","Reference"],"not_rendered":{"external_links":2,"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Example","index":1,"n_rows":177,"n_cols":10,"rows_kept":177,"merged":[[2,1,3,3],[6,1,8,2],[7,5,7,8],[9,1,9,2],[10,1,18,2],[10,5,11,5],[20,1,21,1],[20,2,21,3],[24,1,26,5],[26,8,26,9],[176,1,176,5]]}
[]
[]
[null,"Construction Budget Submission Form"]
[]
[]
[null,"Version","4.4"]
[null,"Step 1: Fill out a description of the entire construction project. "]
[{"$nulls":3},{"$f":"\"Status: \"&IF(RF_Status=\"\",\"\",RF_Status)","v":"Status: Initial Budget"}]
[]
[null,"Scope of Work:",null,"Start Date:","2019-01-01","Total Budget:"]
[null,"This property is located in the New York, NY area and will be a complete gut and flip. We will be putting in new drywall, hardwood flooring, tile in the kitchen, and carpet in the bedrooms. We will be putting in all new mid-grade fixtures in the bathroom. We will be painting the exterior of the property, putting in new fencing, and putting in new sod. ",null,"Estimated Completion Date:","2019-07-01",{"$f":"IFERROR(SUM(AMT_Totals)-SUM(AMT_CatSubtotals),\"$0 .00 \")","v":{"v":71292,"d":"$71,292.00"}}]
[{"$nulls":3},"Expected Draws:",5]
[]
[{"$nulls":4},"Current","Projected"]
[{"$nulls":3},"Total Square Feet:",2200,2200]
[{"$nulls":3},"Rooms/Units:",10,10]
[{"$nulls":3},"Bedrooms:",3,3]
[{"$nulls":3},"Bathrooms:",2,2]
[{"$nulls":3},"Kitchens:",1,1]
[]
[null,"Property Address:","123 Main St, New York, NY 10030"]
[]
[]
[]
[null,"Step 2: Fill in each line item with the description of the construction cost, the amount, the estimated date of completion, and the draw item name (if necessary)."]
[]
[{"$nulls":8},"Lima One Capital\nBudget Review"]
[null,"Item Number","Category / Draw Item","Description","Amount","Estimated Completion Date",null,null,"Recommended Budget  ","  Comments"]
[]
[null,null,"Soft Costs"]
[null,"Column1","Column2","Column3","Column4","Column5","Column6"]
[null,"1000-2","Temp Gas*","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,{"$f":"IF(AMT_Recommend1=\"\",\"\",AMT_Recommend1)","v":""},{"$f":"IF(FR_Comments=\"\",\"\",FR_Comments)","v":""}]
[null,"1000-3","Temp Power*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-4","Temp Toilet",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-5","Architecutral Fees",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-6","Engineering Fees",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-7","Building Permit*","Plumbing, electrical, Framing, HVAC",{"v":1200,"d":"1,200.00"},"2019-09-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1200},null,"",""]
[null,"1000-8","Impact Fees",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-9","Survey",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-10","Survey/Drawings/Plans*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-11","Erosion Fence",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-12","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-13","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Soft Costs",null,{"$f":"G44","v":{"v":1200,"d":"1,200.00"}},null,{"$f":"SUM(G32:G43)","v":{"v":1200,"d":"1,200.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Demolition- Trashout",{"$nulls":5},"",""]
[null,"2000-1","Demolition*","Gut the entire home",{"v":2500,"d":"2,500.00"},"2019-09-18",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2500},null,"",""]
[null,"2000-2","Trashout",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"2000-3","Dumpster","4 30 yard dumpsters ",{"v":2000,"d":"2,000.00"},"2019-09-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2000},null,"",""]
[null,"2000-4","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"2000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Trashout",null,{"$f":"G52","v":{"v":4500,"d":"4,500.00"}},null,{"$f":"SUM(G47:G51)","v":{"v":4500,"d":"4,500.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Site Work",{"$nulls":5},"",""]
[null,"3000-1","Grading*","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-2","Underground *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-3","Conduit",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-4","Water Lines*","Replacing water lines",{"v":3750,"d":"3,750.00"},"2019-11-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":3750},null,"",""]
[null,"3000-5","Septic *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-6","Sewer Lines*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-7","Landscape",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-8","Fence",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-9","Concrete",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-10","Asphalt",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-11","Hardscape","7.5 ft wooden fencing in back yard",{"v":1750,"d":"1,750.00"},"2019-12-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1750},null,"",""]
[null,"3000-12","Softscape","Sod the entire front and back yard",{"v":2500,"d":"2,500.00"},"2020-01-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2500},null,"",""]
[null,"3000-13","Pool/Spa",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-14","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-15","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Yard-Landscape",null,{"$f":"G70","v":{"v":8000,"d":"8,000.00"}},null,{"$f":"SUM(G55:G69)","v":{"v":8000,"d":"8,000.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Foundation",{"$nulls":5},"",""]
[null,"4000-1","Footings*","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-2","PreTreat",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-3","Foundation - Post Tension Cables",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-4","Foundation *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-5","Excavation*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-6","Pour",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-7","Repair",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-8","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-9","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Foundation",null,{"$f":"G82","v":0},null,{"$f":"SUM(G73:G81)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Structure",{"$nulls":5},"",""]
[null,"5000-1","Framing *","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-2","Roof Trusses",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-3","Windows","Replace all windows (16 New)",{"v":5600,"d":"5,600.00"},"2019-10-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":5600},null,"",""]
[null,"5000-4","Joist System",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-6","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Structure",null,{"$f":"G91","v":{"v":5600,"d":"5,600.00"}},null,{"$f":"SUM(G85:G90)","v":{"v":5600,"d":"5,600.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Exterior",{"$nulls":5},"",""]
[null,"6000-1","Roofing*","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-2","Flashing",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-3","Siding ","Repair any damaged siding",{"v":500,"d":"500.00"},"2020-01-20",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":500},null,"",""]
[null,"6000-4","Stucco",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-5","Garage Door",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-6","Gutters/Soffit/Fascia",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-7","Solar",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-8","Deck",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-9","Driveway",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-10","Masonry Veneer ",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-11","Painting - Exterior","Paint Exterior",{"v":2250,"d":"2,250.00"},"2020-01-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2250},null,"",""]
[null,"6000-12","Porch",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-13","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-14","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Exterior",null,{"$f":"G108","v":{"v":2750,"d":"2,750.00"}},null,{"$f":"SUM(G94:G107)","v":{"v":2750,"d":"2,750.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Systems",{"$nulls":5},"",""]
[null,"7000-1","Rough HVAC*","Duct work installed",{"v":2000,"d":"2,000.00"},"2019-12-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2000},null,"",""]
[null,"7000-2","Final HVAC","Unit installed",{"v":2500,"d":"2,500.00"},"2019-12-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2500},null,"",""]
[null,"7000-3","Underslab Plumbing",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-4","Rough Plumbing*","All new plumbing in kitchen and bathrooms",{"v":5500,"d":"5,500.00"},"2019-11-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":5500},null,"",""]
[null,"7000-5","Plumbing - Fixtures","Bath Tub * 2 (With Shower); 2 toilets",{"v":1650,"d":"1,650.00"},"2019-12-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1650},null,"",""]
[null,"7000-6","Fire Suppression",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-7","Underslab Electrical",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-8","Rough Electrical*","Run new wire throughout the house & new panel",{"v":3500,"d":"3,500.00"},"2019-11-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":3500},null,"",""]
[null,"7000-9","Electrical Fixtures","Canned lights; oulet covers; other lights",{"v":1000,"d":"1,000.00"},"2020-02-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1000},null,"",""]
[null,"7000-10","Water Heater",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-11","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-12","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Systems",null,{"$f":"G123","v":{"v":16150,"d":"16,150.00"}},null,{"$f":"SUM(G111:G122)","v":{"v":16150,"d":"16,150.00"}},null,"",""]
[null," "," ",{"$nulls":5},"",""]
[null,null,"Interior",{"$nulls":5},"",""]
[null,"8000-1","Fireplace","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-2","Insulation","New Insulation",{"v":1000,"d":"1,000.00"},"2019-11-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1000},null,"",""]
[null,"8000-3","Drywall*","All rooms",{"v":2750,"d":"2,750.00"},"2020-03-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2750},null,"",""]
[null,"8000-4","Paint-Interior","All Rooms",{"v":4000,"d":"4,000.00"},"2020-04-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":4000},null,"",""]
[null,"8000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-6","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Interior",null,{"$f":"G132","v":{"v":7750,"d":"7,750.00"}},null,{"$f":"SUM(G126:G131)","v":{"v":7750,"d":"7,750.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Finishes",{"$nulls":5},"",""]
[null,"9000-1","Finish Carpentry","(Enter your description here)",null,null,{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-2","Interior Doors","16 4 panel doors",{"$f":"16*125","v":2000},"2020-02-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2000},null,"",""]
[null,"9000-3","Finish Hardware","Cabinet and door hardware",300,"2020-03-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":300},null,"",""]
[null,"9000-4","Exterior Doors","Replace both exterior doors",750,"2020-10-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":750},null,"",""]
[null,"9000-5","Mirrors","Vanity mirrors X2",225,"2020-02-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":225},null,"",""]
[null,"9000-6","Shower Doors",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-7","Cabinets","All new cherry cabinets",{"v":6667,"d":"6,667.00"},"2020-03-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":6667},null,"",""]
[null,"9000-8","Countertops","Granite ",{"v":2050,"d":"2,050.00"},"2020-03-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":2050},null,"",""]
[null,"9000-9","Millwork","New Throughout House",{"v":4195,"d":"4,195.00"},"2020-02-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":4195},null,"",""]
[null,"9000-10","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-11","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Finishes",null,{"$f":"G146","v":{"v":16187,"d":"16,187.00"}},null,{"$f":"SUM(G135:G145)","v":{"v":16187,"d":"16,187.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Flooring",{"$nulls":5},"",""]
[null,"10000-1","Tile ","Kitchen and bathrooms",{"v":1725,"d":"1,725.00"},"2020-03-01",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1725},null,"",""]
[null,"10000-2","Marble",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-3","Wood Flooring","Hardwood throughout hallways and living room",{"v":3330,"d":"3,330.00"},"2020-04-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":3330},null,"",""]
[null,"10000-4","Carpet","All bedrooms",{"v":1500,"d":"1,500.00"},"2020-03-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":1500},null,"",""]
[null,"10000-5","Vinyl",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-6","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-7","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Flooring",null,{"$f":"G156","v":{"v":6555,"d":"6,555.00"}},null,{"$f":"SUM(G149:G155)","v":{"v":6555,"d":"6,555.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Appliances",{"$nulls":5},"",""]
[null,"11000-1","Range","(Enter your description here)",{"v":500,"d":"500.00"},"2020-05-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":500},null,"",""]
[null,"11000-2","Cooktop",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-3","Microwave",null,{"v":350,"d":"350.00"},"2020-05-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":350},null,"",""]
[null,"11000-4","Dishwasher",null,{"v":500,"d":"500.00"},"2020-05-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":500},null,"",""]
[null,"11000-5","Refrigerator",null,{"v":750,"d":"750.00"},"2020-05-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":750},null,"",""]
[null,"11000-6","Package ",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-7","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-8","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Appliances",null,{"$f":"G167","v":{"v":2100,"d":"2,100.00"}},null,{"$f":"SUM(G159:G166)","v":{"v":2100,"d":"2,100.00"}},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Final - Misc",{"$nulls":5},"",""]
[null,"12000-1","Final Clean","(Enter your description here)",{"v":500,"d":"500.00"},"2020-05-15",{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":500},null,"",""]
[null,"12000-2","Staging",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-3","Contingency",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-4","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table162[[#This Row],[Column4]]=\"\",Table162[[#This Row],[Column4]]=0),\"\",ROUND(Table162[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Misc. ",null,{"$f":"G175","v":{"v":500,"d":"500.00"}},null,{"$f":"SUM(G170:G174)","v":{"v":500,"d":"500.00"}}]
[]
[null,"*THESE ITEMS REQUIRE PERMITS IN MOST JURISDICTIONS. BORROWERS ARE REQUIRED TO ADHERE TO ALL LOCAL LAWS, CODES, REGULATIONS AND REQUIREMENTS AS EXPRESSED IN YOUR LOAN DOCUMENTS."]

{"sheet":"Construction Budget","index":2,"n_rows":177,"n_cols":10,"rows_kept":177,"merged":[[2,1,3,3],[6,1,8,2],[7,5,7,8],[9,1,9,2],[10,1,18,2],[10,5,11,5],[20,1,21,1],[20,2,21,3],[24,1,26,5],[26,8,26,9],[176,1,176,5]]}
[]
[]
[null,"Construction Budget Submission Form"]
[]
[]
[null,"Version","4.4"]
[null,"Step 1: Fill out a description of the entire construction project. "]
[{"$nulls":3},{"$f":"\"Status: \"&IF(RF_Status=\"\",\"\",RF_Status)","v":"Status: Initial Budget"}]
[]
[null,"Scope of Work:",null,"Start Date:",null,"Total Budget:"]
[null,"Please provide a description of the whole project.",null,"Estimated Completion Date:",null,{"$f":"IFERROR(SUM(AMT_Totals)-SUM(AMT_CatSubtotals),\"$0 .00 \")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Expected Draws:"]
[]
[{"$nulls":4},"Current","Projected"]
[{"$nulls":3},"Total Square Feet:"]
[{"$nulls":3},"Rooms/Units:"]
[{"$nulls":3},"Bedrooms:"]
[{"$nulls":3},"Bathrooms:"]
[{"$nulls":3},"Kitchens:"]
[]
[null,"Property Address:"]
[]
[]
[]
[null,"Step 2: Fill in each line item with the description of the construction cost, the amount, the estimated date of completion, and the draw item name (if necessary)."]
[]
[{"$nulls":8},"Lima One Capital\nBudget Review"]
[null,"Item Number","Category / Draw Item","Description","Amount","Estimated Completion Date",null,null,"Recommended Budget  ","  Comments"]
[]
[null,null,"Soft Costs"]
[null,"Column1","Column2","Column3","Column4","Column5","Column6"]
[null,"1000-2","Temp Gas*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,{"$f":"IF(AMT_Recommend1=\"\",\"\",AMT_Recommend1)","v":""},{"$f":"IF(FR_Comments=\"\",\"\",FR_Comments)","v":""}]
[null,"1000-3","Temp Power*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-4","Temp Toilet",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-5","Architecutral Fees",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-6","Engineering Fees",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-7","Building Permit*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-8","Impact Fees",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-9","Survey",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-10","Survey/Drawings/Plans*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-11","Erosion Fence",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-12","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"1000-13","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Soft Costs",null,{"$f":"G44","v":0},null,{"$f":"SUM(G32:G43)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Demolition- Trashout",{"$nulls":5},"",""]
[null,"2000-1","Demolition*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"2000-2","Trashout",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"2000-3","Dumpster",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"2000-4","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"2000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Trashout",null,{"$f":"G52","v":0},null,{"$f":"SUM(G47:G51)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Site Work",{"$nulls":5},"",""]
[null,"3000-1","Grading*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-2","Underground *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-3","Conduit",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-4","Water Lines*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-5","Septic *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-6","Sewer Lines*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-7","Landscape",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-8","Fence",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-9","Concrete",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-10","Asphalt",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-11","Hardscape",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-12","Softscape",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-13","Pool/Spa",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-14","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"3000-15","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Yard-Landscape",null,{"$f":"G70","v":0},null,{"$f":"SUM(G55:G69)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Foundation",{"$nulls":5},"",""]
[null,"4000-1","Footings*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-2","PreTreat",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-3","Foundation - Post Tension Cables",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-4","Foundation *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-5","Excavation*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-6","Pour",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-7","Repair",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-8","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"4000-9","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Foundation",null,{"$f":"G82","v":0},null,{"$f":"SUM(G73:G81)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Structure",{"$nulls":5},"",""]
[null,"5000-1","Framing *",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-2","Roof Trusses",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-3","Windows",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-4","Joist System",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"5000-6","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Structure",null,{"$f":"G91","v":0},null,{"$f":"SUM(G85:G90)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Exterior",{"$nulls":5},"",""]
[null,"6000-1","Roofing*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-2","Flashing",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-3","Siding ",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-4","Stucco",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-5","Garage Door",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-6","Gutters/Soffit/Fascia",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-7","Solar",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-8","Deck",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-9","Driveway",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-10","Masonry Veneer ",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-11","Painting - Exterior",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-12","Porch",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-13","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"6000-14","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Exterior",null,{"$f":"G108","v":0},null,{"$f":"SUM(G94:G107)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Systems",{"$nulls":5},"",""]
[null,"7000-1","Rough HVAC*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-2","Final HVAC",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-3","Underslab Plumbing",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-4","Rough Plumbing*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-5","Plumbing - Fixtures",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-6","Fire Suppression",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-7","Underslab Electrical",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-8","Rough Electrical*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-9","Electrical Fixtures",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-10","Water Heater",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-11","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"7000-12","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Systems",null,{"$f":"G123","v":0},null,{"$f":"SUM(G111:G122)","v":0},null,"",""]
[null," "," ",{"$nulls":5},"",""]
[null,null,"Interior",{"$nulls":5},"",""]
[null,"8000-1","Fireplace",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-2","Insulation",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-3","Drywall*",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-4","Paint-Interior",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"8000-6","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Interior",null,{"$f":"G132","v":0},null,{"$f":"SUM(G126:G131)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Finishes",{"$nulls":5},"",""]
[null,"9000-1","Finish Carpentry",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-2","Interior Doors",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-3","Finish Hardware",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-4","Exterior Doors",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-5","Mirrors",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-6","Shower Doors",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-7","Cabinets",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-8","Countertops",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-9","Millwork",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-10","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"9000-11","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Finishes",null,{"$f":"G146","v":0},null,{"$f":"SUM(G135:G145)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Flooring",{"$nulls":5},"",""]
[null,"10000-1","Tile ",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-2","Marble",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-3","Wood Flooring",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-4","Carpet",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-5","Vinyl",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-6","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"10000-7","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Flooring",null,{"$f":"G156","v":0},null,{"$f":"SUM(G149:G155)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Appliances",{"$nulls":5},"",""]
[null,"11000-1","Range",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-2","Cooktop",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-3","Microwave",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-4","Dishwasher",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-5","Refrigerator",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-6","Package ",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-7","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"11000-8","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Appliances",null,{"$f":"G167","v":0},null,{"$f":"SUM(G159:G166)","v":0},null,"",""]
[{"$nulls":8},"",""]
[null,null,"Final - Misc",{"$nulls":5},"",""]
[null,"12000-1","Final Clean",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-2","Staging",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-3","Contingency",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-4","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,"12000-5","(Enter your line item here)",{"$nulls":3},{"$f":"IFERROR(IF(OR(Table16[[#This Row],[Column4]]=\"\",Table16[[#This Row],[Column4]]=0),\"\",ROUND(Table16[[#This Row],[Column4]],2)),\"\")","v":""},null,"",""]
[null,null,"Total Misc. ",null,{"$f":"G175","v":0},null,{"$f":"SUM(G170:G174)","v":0},null,"",""]
[]
[null,"*THESE ITEMS REQUIRE PERMITS IN MOST JURISDICTIONS. BORROWERS ARE REQUIRED TO ADHERE TO ALL LOCAL LAWS, CODES, REGULATIONS AND REQUIREMENTS AS EXPRESSED IN YOUR LOAN DOCUMENTS."]

{"sheet":"Budget Review","index":3,"n_rows":182,"n_cols":19,"rows_kept":182,"hidden":true,"merged":[[9,12,10,14],[12,13,12,15],[13,13,13,15],[14,13,14,15],[17,13,17,15],[18,13,18,15],[24,20,26,20],[24,21,26,21],[28,14,29,14],[28,15,29,15],[28,16,29,16],[28,17,29,17],[177,12,177,13]]}
{"$rows_empty":9}
[{"$nulls":12},"Budget Review"]
[]
[]
[{"$nulls":12},"Borrower Name:"]
[{"$nulls":12},"Property Address:",{"$f":"IFERROR('Construction Budget'!C21:D22,\"\")","v":""}]
[]
[{"$nulls":12},"Loan#:"]
[{"$nulls":12},"Date:",null,"Tier:"]
[{"$nulls":12},"Contractor Name:"]
[{"$nulls":12},"Underwriter:"]
[]
[{"$nulls":13},"AREA REVIEWED","APPROVED","NOT APPROVED","EXCEPTION"]
[{"$nulls":13},"Property Description"]
[{"$nulls":13},"Scope of Work"]
[{"$nulls":13},"Cost Breakdown/Bid",{"$nulls":3},"Status:",{"$f":"IF(RF_Status=\"\",\"\",RF_Status)","v":"Initial Budget"}]
[]
[]
[{"$nulls":14},"Original Budget","Recommended","Final Budget","Difference","Comments"]
[{"$nulls":14},{"$f":"SUM(AMT_OrigBudgetCatTotals)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AMT_RecomBudgetCatTotals1)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AMT_FinalBudgetCatTotals1)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AMT_AnalysisCatTotals1)","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B30=\"\",\"\",'Construction Budget'!B30)","v":""},{"$f":"IF('Construction Budget'!C30=\"\",\"\",'Construction Budget'!C30)","v":"Soft Costs"}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B32=\"\",\"\",'Construction Budget'!B32)","v":"1000-2"},{"$f":"IF('Construction Budget'!C32=\"\",\"\",'Construction Budget'!C32)","v":"Temp Gas*"},{"$nulls":3},{"$f":"IF(Q32=\"\",\"\",Q32-P32)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B33=\"\",\"\",'Construction Budget'!B33)","v":"1000-3"},{"$f":"IF('Construction Budget'!C33=\"\",\"\",'Construction Budget'!C33)","v":"Temp Power*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B34=\"\",\"\",'Construction Budget'!B34)","v":"1000-4"},{"$f":"IF('Construction Budget'!C34=\"\",\"\",'Construction Budget'!C34)","v":"Temp Toilet"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B35=\"\",\"\",'Construction Budget'!B35)","v":"1000-5"},{"$f":"IF('Construction Budget'!C35=\"\",\"\",'Construction Budget'!C35)","v":"Architecutral Fees"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B36=\"\",\"\",'Construction Budget'!B36)","v":"1000-6"},{"$f":"IF('Construction Budget'!C36=\"\",\"\",'Construction Budget'!C36)","v":"Engineering Fees"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B37=\"\",\"\",'Construction Budget'!B37)","v":"1000-7"},{"$f":"IF('Construction Budget'!C37=\"\",\"\",'Construction Budget'!C37)","v":"Building Permit*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B38=\"\",\"\",'Construction Budget'!B38)","v":"1000-8"},{"$f":"IF('Construction Budget'!C38=\"\",\"\",'Construction Budget'!C38)","v":"Impact Fees"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B39=\"\",\"\",'Construction Budget'!B39)","v":"1000-9"},{"$f":"IF('Construction Budget'!C39=\"\",\"\",'Construction Budget'!C39)","v":"Survey"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B40=\"\",\"\",'Construction Budget'!B40)","v":"1000-10"},{"$f":"IF('Construction Budget'!C40=\"\",\"\",'Construction Budget'!C40)","v":"Survey/Drawings/Plans*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B41=\"\",\"\",'Construction Budget'!B41)","v":"1000-11"},{"$f":"IF('Construction Budget'!C41=\"\",\"\",'Construction Budget'!C41)","v":"Erosion Fence"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B42=\"\",\"\",'Construction Budget'!B42)","v":"1000-12"},{"$f":"IF('Construction Budget'!C42=\"\",\"\",'Construction Budget'!C42)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B43=\"\",\"\",'Construction Budget'!B43)","v":"1000-13"},{"$f":"IF('Construction Budget'!C43=\"\",\"\",'Construction Budget'!C43)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B44=\"\",\"\",'Construction Budget'!B44)","v":""},{"$f":"IF('Construction Budget'!C44=\"\",\"\",'Construction Budget'!C44)","v":"Total Soft Costs"},{"$nulls":3},{"$f":"SUM(R32:R43)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B45=\"\",\"\",'Construction Budget'!B45)","v":""},{"$f":"IF('Construction Budget'!C45=\"\",\"\",'Construction Budget'!C45)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B46=\"\",\"\",'Construction Budget'!B46)","v":""},{"$f":"IF('Construction Budget'!C46=\"\",\"\",'Construction Budget'!C46)","v":"Demolition- Trashout"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B47=\"\",\"\",'Construction Budget'!B47)","v":"2000-1"},{"$f":"IF('Construction Budget'!C47=\"\",\"\",'Construction Budget'!C47)","v":"Demolition*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B48=\"\",\"\",'Construction Budget'!B48)","v":"2000-2"},{"$f":"IF('Construction Budget'!C48=\"\",\"\",'Construction Budget'!C48)","v":"Trashout"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B49=\"\",\"\",'Construction Budget'!B49)","v":"2000-3"},{"$f":"IF('Construction Budget'!C49=\"\",\"\",'Construction Budget'!C49)","v":"Dumpster"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B50=\"\",\"\",'Construction Budget'!B50)","v":"2000-4"},{"$f":"IF('Construction Budget'!C50=\"\",\"\",'Construction Budget'!C50)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B51=\"\",\"\",'Construction Budget'!B51)","v":"2000-5"},{"$f":"IF('Construction Budget'!C51=\"\",\"\",'Construction Budget'!C51)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B52=\"\",\"\",'Construction Budget'!B52)","v":""},{"$f":"IF('Construction Budget'!C52=\"\",\"\",'Construction Budget'!C52)","v":"Total Trashout"},{"$nulls":3},{"$f":"SUM(R47:R51)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B53=\"\",\"\",'Construction Budget'!B53)","v":""},{"$f":"IF('Construction Budget'!C53=\"\",\"\",'Construction Budget'!C53)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B54=\"\",\"\",'Construction Budget'!B54)","v":""},{"$f":"IF('Construction Budget'!C54=\"\",\"\",'Construction Budget'!C54)","v":"Site Work"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B55=\"\",\"\",'Construction Budget'!B55)","v":"3000-1"},{"$f":"IF('Construction Budget'!C55=\"\",\"\",'Construction Budget'!C55)","v":"Grading*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B56=\"\",\"\",'Construction Budget'!B56)","v":"3000-2"},{"$f":"IF('Construction Budget'!C56=\"\",\"\",'Construction Budget'!C56)","v":"Underground *"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B57=\"\",\"\",'Construction Budget'!B57)","v":"3000-3"},{"$f":"IF('Construction Budget'!C57=\"\",\"\",'Construction Budget'!C57)","v":"Conduit"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B58=\"\",\"\",'Construction Budget'!B58)","v":"3000-4"},{"$f":"IF('Construction Budget'!C58=\"\",\"\",'Construction Budget'!C58)","v":"Water Lines*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B59=\"\",\"\",'Construction Budget'!B59)","v":"3000-5"},{"$f":"IF('Construction Budget'!C59=\"\",\"\",'Construction Budget'!C59)","v":"Septic *"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B60=\"\",\"\",'Construction Budget'!B60)","v":"3000-6"},{"$f":"IF('Construction Budget'!C60=\"\",\"\",'Construction Budget'!C60)","v":"Sewer Lines*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B61=\"\",\"\",'Construction Budget'!B61)","v":"3000-7"},{"$f":"IF('Construction Budget'!C61=\"\",\"\",'Construction Budget'!C61)","v":"Landscape"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B62=\"\",\"\",'Construction Budget'!B62)","v":"3000-8"},{"$f":"IF('Construction Budget'!C62=\"\",\"\",'Construction Budget'!C62)","v":"Fence"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B63=\"\",\"\",'Construction Budget'!B63)","v":"3000-9"},{"$f":"IF('Construction Budget'!C63=\"\",\"\",'Construction Budget'!C63)","v":"Concrete"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B64=\"\",\"\",'Construction Budget'!B64)","v":"3000-10"},{"$f":"IF('Construction Budget'!C64=\"\",\"\",'Construction Budget'!C64)","v":"Asphalt"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B65=\"\",\"\",'Construction Budget'!B65)","v":"3000-11"},{"$f":"IF('Construction Budget'!C65=\"\",\"\",'Construction Budget'!C65)","v":"Hardscape"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B66=\"\",\"\",'Construction Budget'!B66)","v":"3000-12"},{"$f":"IF('Construction Budget'!C66=\"\",\"\",'Construction Budget'!C66)","v":"Softscape"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B67=\"\",\"\",'Construction Budget'!B67)","v":"3000-13"},{"$f":"IF('Construction Budget'!C67=\"\",\"\",'Construction Budget'!C67)","v":"Pool/Spa"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B68=\"\",\"\",'Construction Budget'!B68)","v":"3000-14"},{"$f":"IF('Construction Budget'!C68=\"\",\"\",'Construction Budget'!C68)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B69=\"\",\"\",'Construction Budget'!B69)","v":"3000-15"},{"$f":"IF('Construction Budget'!C69=\"\",\"\",'Construction Budget'!C69)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B70=\"\",\"\",'Construction Budget'!B70)","v":""},{"$f":"IF('Construction Budget'!C70=\"\",\"\",'Construction Budget'!C70)","v":"Total Yard-Landscape"},{"$nulls":3},{"$f":"SUM(R55:R69)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B71=\"\",\"\",'Construction Budget'!B71)","v":""},{"$f":"IF('Construction Budget'!C71=\"\",\"\",'Construction Budget'!C71)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B72=\"\",\"\",'Construction Budget'!B72)","v":""},{"$f":"IF('Construction Budget'!C72=\"\",\"\",'Construction Budget'!C72)","v":"Foundation"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B73=\"\",\"\",'Construction Budget'!B73)","v":"4000-1"},{"$f":"IF('Construction Budget'!C73=\"\",\"\",'Construction Budget'!C73)","v":"Footings*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B74=\"\",\"\",'Construction Budget'!B74)","v":"4000-2"},{"$f":"IF('Construction Budget'!C74=\"\",\"\",'Construction Budget'!C74)","v":"PreTreat"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B75=\"\",\"\",'Construction Budget'!B75)","v":"4000-3"},{"$f":"IF('Construction Budget'!C75=\"\",\"\",'Construction Budget'!C75)","v":"Foundation - Post Tension Cables"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B76=\"\",\"\",'Construction Budget'!B76)","v":"4000-4"},{"$f":"IF('Construction Budget'!C76=\"\",\"\",'Construction Budget'!C76)","v":"Foundation *"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B77=\"\",\"\",'Construction Budget'!B77)","v":"4000-5"},{"$f":"IF('Construction Budget'!C77=\"\",\"\",'Construction Budget'!C77)","v":"Excavation*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B78=\"\",\"\",'Construction Budget'!B78)","v":"4000-6"},{"$f":"IF('Construction Budget'!C78=\"\",\"\",'Construction Budget'!C78)","v":"Pour"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B79=\"\",\"\",'Construction Budget'!B79)","v":"4000-7"},{"$f":"IF('Construction Budget'!C79=\"\",\"\",'Construction Budget'!C79)","v":"Repair"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B80=\"\",\"\",'Construction Budget'!B80)","v":"4000-8"},{"$f":"IF('Construction Budget'!C80=\"\",\"\",'Construction Budget'!C80)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B81=\"\",\"\",'Construction Budget'!B81)","v":"4000-9"},{"$f":"IF('Construction Budget'!C81=\"\",\"\",'Construction Budget'!C81)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B82=\"\",\"\",'Construction Budget'!B82)","v":""},{"$f":"IF('Construction Budget'!C82=\"\",\"\",'Construction Budget'!C82)","v":"Total Foundation"},{"$nulls":3},{"$f":"SUM(R73:R81)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B83=\"\",\"\",'Construction Budget'!B83)","v":""},{"$f":"IF('Construction Budget'!C83=\"\",\"\",'Construction Budget'!C83)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B84=\"\",\"\",'Construction Budget'!B84)","v":""},{"$f":"IF('Construction Budget'!C84=\"\",\"\",'Construction Budget'!C84)","v":"Structure"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B85=\"\",\"\",'Construction Budget'!B85)","v":"5000-1"},{"$f":"IF('Construction Budget'!C85=\"\",\"\",'Construction Budget'!C85)","v":"Framing *"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B86=\"\",\"\",'Construction Budget'!B86)","v":"5000-2"},{"$f":"IF('Construction Budget'!C86=\"\",\"\",'Construction Budget'!C86)","v":"Roof Trusses"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B87=\"\",\"\",'Construction Budget'!B87)","v":"5000-3"},{"$f":"IF('Construction Budget'!C87=\"\",\"\",'Construction Budget'!C87)","v":"Windows"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B88=\"\",\"\",'Construction Budget'!B88)","v":"5000-4"},{"$f":"IF('Construction Budget'!C88=\"\",\"\",'Construction Budget'!C88)","v":"Joist System"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B89=\"\",\"\",'Construction Budget'!B89)","v":"5000-5"},{"$f":"IF('Construction Budget'!C89=\"\",\"\",'Construction Budget'!C89)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B90=\"\",\"\",'Construction Budget'!B90)","v":"5000-6"},{"$f":"IF('Construction Budget'!C90=\"\",\"\",'Construction Budget'!C90)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B91=\"\",\"\",'Construction Budget'!B91)","v":""},{"$f":"IF('Construction Budget'!C91=\"\",\"\",'Construction Budget'!C91)","v":"Total Structure"},{"$nulls":3},{"$f":"SUM(R85:R90)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B92=\"\",\"\",'Construction Budget'!B92)","v":""},{"$f":"IF('Construction Budget'!C92=\"\",\"\",'Construction Budget'!C92)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B93=\"\",\"\",'Construction Budget'!B93)","v":""},{"$f":"IF('Construction Budget'!C93=\"\",\"\",'Construction Budget'!C93)","v":"Exterior"},{"$nulls":3},{"$f":"IF(Q93=\"\",\"\",Q93-P93)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B94=\"\",\"\",'Construction Budget'!B94)","v":"6000-1"},{"$f":"IF('Construction Budget'!C94=\"\",\"\",'Construction Budget'!C94)","v":"Roofing*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B95=\"\",\"\",'Construction Budget'!B95)","v":"6000-2"},{"$f":"IF('Construction Budget'!C95=\"\",\"\",'Construction Budget'!C95)","v":"Flashing"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B96=\"\",\"\",'Construction Budget'!B96)","v":"6000-3"},{"$f":"IF('Construction Budget'!C96=\"\",\"\",'Construction Budget'!C96)","v":"Siding "},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B97=\"\",\"\",'Construction Budget'!B97)","v":"6000-4"},{"$f":"IF('Construction Budget'!C97=\"\",\"\",'Construction Budget'!C97)","v":"Stucco"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B98=\"\",\"\",'Construction Budget'!B98)","v":"6000-5"},{"$f":"IF('Construction Budget'!C98=\"\",\"\",'Construction Budget'!C98)","v":"Garage Door"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B99=\"\",\"\",'Construction Budget'!B99)","v":"6000-6"},{"$f":"IF('Construction Budget'!C99=\"\",\"\",'Construction Budget'!C99)","v":"Gutters/Soffit/Fascia"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B100=\"\",\"\",'Construction Budget'!B100)","v":"6000-7"},{"$f":"IF('Construction Budget'!C100=\"\",\"\",'Construction Budget'!C100)","v":"Solar"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B101=\"\",\"\",'Construction Budget'!B101)","v":"6000-8"},{"$f":"IF('Construction Budget'!C101=\"\",\"\",'Construction Budget'!C101)","v":"Deck"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B102=\"\",\"\",'Construction Budget'!B102)","v":"6000-9"},{"$f":"IF('Construction Budget'!C102=\"\",\"\",'Construction Budget'!C102)","v":"Driveway"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B103=\"\",\"\",'Construction Budget'!B103)","v":"6000-10"},{"$f":"IF('Construction Budget'!C103=\"\",\"\",'Construction Budget'!C103)","v":"Masonry Veneer "},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B104=\"\",\"\",'Construction Budget'!B104)","v":"6000-11"},{"$f":"IF('Construction Budget'!C104=\"\",\"\",'Construction Budget'!C104)","v":"Painting - Exterior"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B105=\"\",\"\",'Construction Budget'!B105)","v":"6000-12"},{"$f":"IF('Construction Budget'!C105=\"\",\"\",'Construction Budget'!C105)","v":"Porch"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B106=\"\",\"\",'Construction Budget'!B106)","v":"6000-13"},{"$f":"IF('Construction Budget'!C106=\"\",\"\",'Construction Budget'!C106)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B107=\"\",\"\",'Construction Budget'!B107)","v":"6000-14"},{"$f":"IF('Construction Budget'!C107=\"\",\"\",'Construction Budget'!C107)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B108=\"\",\"\",'Construction Budget'!B108)","v":""},{"$f":"IF('Construction Budget'!C108=\"\",\"\",'Construction Budget'!C108)","v":"Total Exterior"},{"$nulls":3},{"$f":"SUM(R94:R107)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B109=\"\",\"\",'Construction Budget'!B109)","v":""},{"$f":"IF('Construction Budget'!C109=\"\",\"\",'Construction Budget'!C109)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B110=\"\",\"\",'Construction Budget'!B110)","v":""},{"$f":"IF('Construction Budget'!C110=\"\",\"\",'Construction Budget'!C110)","v":"Systems"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B111=\"\",\"\",'Construction Budget'!B111)","v":"7000-1"},{"$f":"IF('Construction Budget'!C111=\"\",\"\",'Construction Budget'!C111)","v":"Rough HVAC*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B112=\"\",\"\",'Construction Budget'!B112)","v":"7000-2"},{"$f":"IF('Construction Budget'!C112=\"\",\"\",'Construction Budget'!C112)","v":"Final HVAC"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B113=\"\",\"\",'Construction Budget'!B113)","v":"7000-3"},{"$f":"IF('Construction Budget'!C113=\"\",\"\",'Construction Budget'!C113)","v":"Underslab Plumbing"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B114=\"\",\"\",'Construction Budget'!B114)","v":"7000-4"},{"$f":"IF('Construction Budget'!C114=\"\",\"\",'Construction Budget'!C114)","v":"Rough Plumbing*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B115=\"\",\"\",'Construction Budget'!B115)","v":"7000-5"},{"$f":"IF('Construction Budget'!C115=\"\",\"\",'Construction Budget'!C115)","v":"Plumbing - Fixtures"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B116=\"\",\"\",'Construction Budget'!B116)","v":"7000-6"},{"$f":"IF('Construction Budget'!C116=\"\",\"\",'Construction Budget'!C116)","v":"Fire Suppression"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B117=\"\",\"\",'Construction Budget'!B117)","v":"7000-7"},{"$f":"IF('Construction Budget'!C117=\"\",\"\",'Construction Budget'!C117)","v":"Underslab Electrical"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B118=\"\",\"\",'Construction Budget'!B118)","v":"7000-8"},{"$f":"IF('Construction Budget'!C118=\"\",\"\",'Construction Budget'!C118)","v":"Rough Electrical*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B119=\"\",\"\",'Construction Budget'!B119)","v":"7000-9"},{"$f":"IF('Construction Budget'!C119=\"\",\"\",'Construction Budget'!C119)","v":"Electrical Fixtures"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B120=\"\",\"\",'Construction Budget'!B120)","v":"7000-10"},{"$f":"IF('Construction Budget'!C120=\"\",\"\",'Construction Budget'!C120)","v":"Water Heater"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B121=\"\",\"\",'Construction Budget'!B121)","v":"7000-11"},{"$f":"IF('Construction Budget'!C121=\"\",\"\",'Construction Budget'!C121)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B122=\"\",\"\",'Construction Budget'!B122)","v":"7000-12"},{"$f":"IF('Construction Budget'!C122=\"\",\"\",'Construction Budget'!C122)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B123=\"\",\"\",'Construction Budget'!B123)","v":""},{"$f":"IF('Construction Budget'!C123=\"\",\"\",'Construction Budget'!C123)","v":"Total Systems"},{"$nulls":3},{"$f":"SUM(R111:R122)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B124=\"\",\"\",'Construction Budget'!B124)","v":" "},{"$f":"IF('Construction Budget'!C124=\"\",\"\",'Construction Budget'!C124)","v":" "}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B125=\"\",\"\",'Construction Budget'!B125)","v":""},{"$f":"IF('Construction Budget'!C125=\"\",\"\",'Construction Budget'!C125)","v":"Interior"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B126=\"\",\"\",'Construction Budget'!B126)","v":"8000-1"},{"$f":"IF('Construction Budget'!C126=\"\",\"\",'Construction Budget'!C126)","v":"Fireplace"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B127=\"\",\"\",'Construction Budget'!B127)","v":"8000-2"},{"$f":"IF('Construction Budget'!C127=\"\",\"\",'Construction Budget'!C127)","v":"Insulation"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B128=\"\",\"\",'Construction Budget'!B128)","v":"8000-3"},{"$f":"IF('Construction Budget'!C128=\"\",\"\",'Construction Budget'!C128)","v":"Drywall*"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B129=\"\",\"\",'Construction Budget'!B129)","v":"8000-4"},{"$f":"IF('Construction Budget'!C129=\"\",\"\",'Construction Budget'!C129)","v":"Paint-Interior"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B130=\"\",\"\",'Construction Budget'!B130)","v":"8000-5"},{"$f":"IF('Construction Budget'!C130=\"\",\"\",'Construction Budget'!C130)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B131=\"\",\"\",'Construction Budget'!B131)","v":"8000-6"},{"$f":"IF('Construction Budget'!C131=\"\",\"\",'Construction Budget'!C131)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B132=\"\",\"\",'Construction Budget'!B132)","v":""},{"$f":"IF('Construction Budget'!C132=\"\",\"\",'Construction Budget'!C132)","v":"Total Interior"},{"$nulls":3},{"$f":"SUM(R126:R131)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B133=\"\",\"\",'Construction Budget'!B133)","v":""},{"$f":"IF('Construction Budget'!C133=\"\",\"\",'Construction Budget'!C133)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B134=\"\",\"\",'Construction Budget'!B134)","v":""},{"$f":"IF('Construction Budget'!C134=\"\",\"\",'Construction Budget'!C134)","v":"Finishes"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B135=\"\",\"\",'Construction Budget'!B135)","v":"9000-1"},{"$f":"IF('Construction Budget'!C135=\"\",\"\",'Construction Budget'!C135)","v":"Finish Carpentry"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B136=\"\",\"\",'Construction Budget'!B136)","v":"9000-2"},{"$f":"IF('Construction Budget'!C136=\"\",\"\",'Construction Budget'!C136)","v":"Interior Doors"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B137=\"\",\"\",'Construction Budget'!B137)","v":"9000-3"},{"$f":"IF('Construction Budget'!C137=\"\",\"\",'Construction Budget'!C137)","v":"Finish Hardware"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B138=\"\",\"\",'Construction Budget'!B138)","v":"9000-4"},{"$f":"IF('Construction Budget'!C138=\"\",\"\",'Construction Budget'!C138)","v":"Exterior Doors"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B139=\"\",\"\",'Construction Budget'!B139)","v":"9000-5"},{"$f":"IF('Construction Budget'!C139=\"\",\"\",'Construction Budget'!C139)","v":"Mirrors"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B140=\"\",\"\",'Construction Budget'!B140)","v":"9000-6"},{"$f":"IF('Construction Budget'!C140=\"\",\"\",'Construction Budget'!C140)","v":"Shower Doors"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B141=\"\",\"\",'Construction Budget'!B141)","v":"9000-7"},{"$f":"IF('Construction Budget'!C141=\"\",\"\",'Construction Budget'!C141)","v":"Cabinets"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B142=\"\",\"\",'Construction Budget'!B142)","v":"9000-8"},{"$f":"IF('Construction Budget'!C142=\"\",\"\",'Construction Budget'!C142)","v":"Countertops"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B143=\"\",\"\",'Construction Budget'!B143)","v":"9000-9"},{"$f":"IF('Construction Budget'!C143=\"\",\"\",'Construction Budget'!C143)","v":"Millwork"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B144=\"\",\"\",'Construction Budget'!B144)","v":"9000-10"},{"$f":"IF('Construction Budget'!C144=\"\",\"\",'Construction Budget'!C144)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B145=\"\",\"\",'Construction Budget'!B145)","v":"9000-11"},{"$f":"IF('Construction Budget'!C145=\"\",\"\",'Construction Budget'!C145)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B146=\"\",\"\",'Construction Budget'!B146)","v":""},{"$f":"IF('Construction Budget'!C146=\"\",\"\",'Construction Budget'!C146)","v":"Total Finishes"},{"$nulls":3},{"$f":"SUM(R135:R145)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B147=\"\",\"\",'Construction Budget'!B147)","v":""},{"$f":"IF('Construction Budget'!C147=\"\",\"\",'Construction Budget'!C147)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B148=\"\",\"\",'Construction Budget'!B148)","v":""},{"$f":"IF('Construction Budget'!C148=\"\",\"\",'Construction Budget'!C148)","v":"Flooring"},{"$nulls":3},{"$f":"IF(Q148=\"\",\"\",Q148-P148)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B149=\"\",\"\",'Construction Budget'!B149)","v":"10000-1"},{"$f":"IF('Construction Budget'!C149=\"\",\"\",'Construction Budget'!C149)","v":"Tile "},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B150=\"\",\"\",'Construction Budget'!B150)","v":"10000-2"},{"$f":"IF('Construction Budget'!C150=\"\",\"\",'Construction Budget'!C150)","v":"Marble"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B151=\"\",\"\",'Construction Budget'!B151)","v":"10000-3"},{"$f":"IF('Construction Budget'!C151=\"\",\"\",'Construction Budget'!C151)","v":"Wood Flooring"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B152=\"\",\"\",'Construction Budget'!B152)","v":"10000-4"},{"$f":"IF('Construction Budget'!C152=\"\",\"\",'Construction Budget'!C152)","v":"Carpet"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B153=\"\",\"\",'Construction Budget'!B153)","v":"10000-5"},{"$f":"IF('Construction Budget'!C153=\"\",\"\",'Construction Budget'!C153)","v":"Vinyl"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B154=\"\",\"\",'Construction Budget'!B154)","v":"10000-6"},{"$f":"IF('Construction Budget'!C154=\"\",\"\",'Construction Budget'!C154)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B155=\"\",\"\",'Construction Budget'!B155)","v":"10000-7"},{"$f":"IF('Construction Budget'!C155=\"\",\"\",'Construction Budget'!C155)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B156=\"\",\"\",'Construction Budget'!B156)","v":""},{"$f":"IF('Construction Budget'!C156=\"\",\"\",'Construction Budget'!C156)","v":"Total Flooring"},{"$nulls":3},{"$f":"SUM(R149:R155)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B157=\"\",\"\",'Construction Budget'!B157)","v":""},{"$f":"IF('Construction Budget'!C157=\"\",\"\",'Construction Budget'!C157)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B158=\"\",\"\",'Construction Budget'!B158)","v":""},{"$f":"IF('Construction Budget'!C158=\"\",\"\",'Construction Budget'!C158)","v":"Appliances"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B159=\"\",\"\",'Construction Budget'!B159)","v":"11000-1"},{"$f":"IF('Construction Budget'!C159=\"\",\"\",'Construction Budget'!C159)","v":"Range"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B160=\"\",\"\",'Construction Budget'!B160)","v":"11000-2"},{"$f":"IF('Construction Budget'!C160=\"\",\"\",'Construction Budget'!C160)","v":"Cooktop"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B161=\"\",\"\",'Construction Budget'!B161)","v":"11000-3"},{"$f":"IF('Construction Budget'!C161=\"\",\"\",'Construction Budget'!C161)","v":"Microwave"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B162=\"\",\"\",'Construction Budget'!B162)","v":"11000-4"},{"$f":"IF('Construction Budget'!C162=\"\",\"\",'Construction Budget'!C162)","v":"Dishwasher"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B163=\"\",\"\",'Construction Budget'!B163)","v":"11000-5"},{"$f":"IF('Construction Budget'!C163=\"\",\"\",'Construction Budget'!C163)","v":"Refrigerator"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B164=\"\",\"\",'Construction Budget'!B164)","v":"11000-6"},{"$f":"IF('Construction Budget'!C164=\"\",\"\",'Construction Budget'!C164)","v":"Package "},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B165=\"\",\"\",'Construction Budget'!B165)","v":"11000-7"},{"$f":"IF('Construction Budget'!C165=\"\",\"\",'Construction Budget'!C165)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B166=\"\",\"\",'Construction Budget'!B166)","v":"11000-8"},{"$f":"IF('Construction Budget'!C166=\"\",\"\",'Construction Budget'!C166)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B167=\"\",\"\",'Construction Budget'!B167)","v":""},{"$f":"IF('Construction Budget'!C167=\"\",\"\",'Construction Budget'!C167)","v":"Total Appliances"},{"$nulls":3},{"$f":"SUM(R159:R166)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B168=\"\",\"\",'Construction Budget'!B168)","v":""},{"$f":"IF('Construction Budget'!C168=\"\",\"\",'Construction Budget'!C168)","v":""}]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B169=\"\",\"\",'Construction Budget'!B169)","v":""},{"$f":"IF('Construction Budget'!C169=\"\",\"\",'Construction Budget'!C169)","v":"Final - Misc"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B170=\"\",\"\",'Construction Budget'!B170)","v":"12000-1"},{"$f":"IF('Construction Budget'!C170=\"\",\"\",'Construction Budget'!C170)","v":"Final Clean"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B171=\"\",\"\",'Construction Budget'!B171)","v":"12000-2"},{"$f":"IF('Construction Budget'!C171=\"\",\"\",'Construction Budget'!C171)","v":"Staging"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B172=\"\",\"\",'Construction Budget'!B172)","v":"12000-3"},{"$f":"IF('Construction Budget'!C172=\"\",\"\",'Construction Budget'!C172)","v":"Contingency"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B173=\"\",\"\",'Construction Budget'!B173)","v":"12000-4"},{"$f":"IF('Construction Budget'!C173=\"\",\"\",'Construction Budget'!C173)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B174=\"\",\"\",'Construction Budget'!B174)","v":"12000-5"},{"$f":"IF('Construction Budget'!C174=\"\",\"\",'Construction Budget'!C174)","v":"(Enter your line item here)"},{"$nulls":3},""]
[{"$nulls":12},{"$f":"IF('Construction Budget'!B175=\"\",\"\",'Construction Budget'!B175)","v":""},{"$f":"IF('Construction Budget'!C175=\"\",\"\",'Construction Budget'!C175)","v":"Total Misc. "},{"$nulls":3},{"$f":"SUM(R170:R174)","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":12},"    Rehab Project Meets Minimum Guidelines"]
[{"$nulls":12},{"$f":"IF(RF_Analyst=\"\",\"\",RF_Analyst)","v":""},null,{"$f":"IF(RF_Date_Approved=\"\",\"\",RF_Date_Approved)","v":""}]
[{"$nulls":12},"Analyst Signature/Title",null,"Date"]
[{"$nulls":12}," ",null," "]
[{"$nulls":12},"Supervisor Signature/Title",null,"Date"]

{"sheet":"Reference","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"hidden":true}
[]
[{"$nulls":5},"Approvals:"]
[{"$nulls":5},1,false]
[{"$nulls":5},2,false]
[{"$nulls":5},3,false]
[{"$nulls":5},4,true]
[]
[{"$nulls":5},"RF_CountApprovals",{"$f":"COUNTIF(G3:G6,TRUE)","v":1}]
[]
[{"$nulls":5},"RF_Status","Initial Budget"]
[]
[{"$nulls":5},"RF_Analyst"]
[{"$nulls":5},"RF_Date_Approved"]