{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Rehab Analysis","H.D. SKUs","Living Rm","Den-Sitting","Kitchen","Dining","Breakfast","Entrance-Foyer","Laundry","DOWN Hall","Down Bath","UP Hall","Master BED","Master Bath","Up Bath","Bed-2","Bed 3","Bed 4","Basement","Garage","Exterior","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Rehab Analysis","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PURCHASE COSTS:",null,null,"LABOR","PRICE",null,"MATERIALS","PRICE"]
[null,"Purchase Price",null,null,"INTERIOR   ",null,null,"GENERAL",null,"Need Price on fence replacement"]
[null,"Inspection(s)",null,null,"Demo",null,null,"Permits",null,"Need to check septic system"]
[null,"Appraisal(s)",null,null,"Interior Carpenty",null,null,"Dumpster"]
[null,"Survey(s)",null,null,"Framing",null,null,"Contractor"]
[null,"Lender Fees/Costs",null,null,"Door Replacement",null,null,"INTERIOR   "]
[null,"Closing Costs",null,null,"Window Replacement",null,null,"Framing Lumber"]
[null,"Other",null,null,"Other Carpenty",null,null,"Drywall"]
[null,"Total:",{"$f":"-SUM(C3:C9)","v":0},null,"Drywall Replacement & Repair",null,null,"Finish Carpentry"]
[null,null,null,null,"Plumbing",null,null,"Doors",{"$f":"SUM('H.D. SKUs'!F23:F34)","v":0}]
[null,"REHAB COSTS:",null,null,"Rough",null,null,"Windows"]
[null,"Labor (from page 2)",{"$f":"-F47","v":0},null,"Finish",null,null,"Finish Electrical"]
[null,"Materials (from page 2)",{"$f":"-I50","v":0},null,"Electrical",null,null,"Light Fixtures",{"$f":"'H.D. SKUs'!F13","v":0}]
[null,"Total:",{"$f":"SUM(C13:C14)","v":0},null,"Rough",null,null,"Fan Fixtures",{"$f":"SUM('H.D. SKUs'!F2:F4)","v":0}]
[null,null,null,null,"Finish",null,null,"Finish Plumbing"]
[null,"HOLDING COSTS:",null,null,"HVAC",null,null,"Hot Water Heater",{"$f":"'H.D. SKUs'!F20","v":0}]
[null,"Mortgage Payments",null,null,"Rough",null,null,"Toilets",{"$f":"'H.D. SKUs'!F18","v":0}]
[null,"Property Taxes",null,null,"Finish",null,null,"Sinks",{"$f":"SUM('H.D. SKUs'!F14:F15)","v":0}]
[null,"Insurance",null,null,"Painting",null,null,"Faucets",{"$f":"SUM('H.D. SKUs'!F16:F17)","v":0}]
[null,"Utilities",null,null,"Flooring",null,null,"Flooring"]
[null,"Lawn Care",null,null,"Carpet",null,null,"Tile"]
[null,"Other",null,null,"Hardwood",null,null,"Carpet"]
[null,"Total:",{"$f":"-SUM(C18:C23)","v":0},null,"Tile",null,null,"Pad"]
[null,null,null,null,"Vinyl",null,null,"Hardwood"]
[null,"SELLING COSTS",null,null,"Kitchen",null,null,"Vinyl"]
[null,"Selling Price",null,null,"Cabinet Installation",null,null,"Trim"]
[null,"Commission To Agents",{"$f":"-(C27*0.06)","v":0},null,"Countertop Installation",null,null,"Kitchen"]
[null,"Buyer Home Warranty",null,null,"Appliances Installation",null,null,"Appliances",{"$f":"SUM('H.D. SKUs'!F57:F63)","v":0}]
[null,"Buyer Termite Letter",null,null,"Trim Work",null,null,"Cabinets"]
[null,"Buyer's Closing Costs",null,null,"House Cleaning",null,null,"Countertops"]
[null,"Seller's Closing Costs",null,null,null,null,null,"Backsplash"]
[null,"Total:",{"$f":"SUM(C27,C28,-C29,-C30,-C31,-C32)","v":0},null,"EXTERIOR",null,null,"Garbage Disposal",{"$f":"'H.D. SKUs'!F19","v":0}]
[null,null,null,null,"Roofing",null,null,"Bathrooms"]
[null,"PROFIT:   ",{"$f":"SUM(C10,C15,C24,C33)","v":0},null,"Roof Maintanence",null,null,"Vanities"]
[null,null,null,null,"Roof Replacement",null,null,"Bath Hardware"]
[null,null,null,null,"Soffits/Fascia",null,null,"Shower/Tub"]
[null,null,null,null,"Gutters",null,null,"Tile"]
[null,null,null,null,"Exterior Carpenty",null,null,"Washer/Dryer",{"$f":"SUM('H.D. SKUs'!F64:F66)","v":0}]
[null,null,null,null,"Siding",null,null,"Finishing Touches"]
[null,null,null,null,"Exterior Trim",null,null,"Door Knobs/Deadbolts/Hinges",{"$f":"SUM('H.D. SKUs'!F36:F40)","v":0}]
[null,null,null,null,"Decks",null,null,"Switches",{"$f":"'H.D. SKUs'!F53","v":0}]
[null,null,null,null,"Landscaping",null,null,"Outlets",{"$f":"'H.D. SKUs'!F51","v":0}]
[null,null,null,null,"Termite Inspection/Treatment",null,null,"Switch Plates",{"$f":"'H.D. SKUs'!F54","v":0}]
[null,null,null,null,"Garage Doors Installation",null,null,"Outlet Covers",{"$f":"'H.D. SKUs'!F52","v":0}]
[null,null,null,null,"Foundation/Structural",null,null,"Mini Blinds",{"$f":"'H.D. SKUs'!F49","v":0}]
[null,null,null,null,"TOTAL:",{"$f":"SUM(F4:F46)","v":0},null,"Garage Doors",{"$f":"SUM('H.D. SKUs'!F43:F44)","v":0}]
[null,null,null,null,null,null,null,"All other Hardware items from SKU sheet",{"$f":"SUM('H.D. SKUs'!F21,'H.D. SKUs'!F42,'H.D. SKUs'!F45:F48,'H.D. SKUs'!F50,'H.D. SKUs'!F55)","v":0}]
[null,null,null,null,null,null,null,"SALES TAX:",{"$f":"SUM(I33:I48,I7:I29)*0.06","v":0}]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I3:I49)","v":0}]

{"sheet":"H.D. SKUs","index":1,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU","Quantity","Price","Total",{"$f":"SUM(F13,F22,F35,F41,F56,F67)","v":0}]
["Lighting","Upgraded Flush Mount Fan Lights (Master Bedroom/Living Room)","122-135",{"$f":"SUM('Entrance-Foyer'!D2,'Living Rm'!D2,'Den-Sitting'!D2,Basement!D2,'Master BED'!D2)","v":0},69.97,{"$f":"D2*E2","v":0}]
[null,"Upgraded 52\" Fan w/Downrod (Master Bedroom/Living Room with Tall Ceiling)","165-474",{"$f":"SUM('Entrance-Foyer'!D3,'Living Rm'!D3,'Den-Sitting'!D3,'Master BED'!D3)","v":0},69.97,0]
[null,"Basic Bedroom Fan/Light (Secondary Bedrooms)","270-614",{"$f":"SUM('Bed-2'!D3,'Bed 3'!D3,'Bed 4'!D3,Basement!D3)","v":0},26.47,0]
[null,"4-Light Track Light (Kitchen)","987-423",{"$f":"SUM(Kitchen!D3,Breakfast!D3,Basement!D4)","v":0},49.97,0]
[null,"3-Light Track Light (Eat-In Kitchen)","987-324",{"$f":"SUM(Kitchen!D4,Dining!D3,Breakfast!D4,Basement!D5)","v":0},38.64,0]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",{"$f":"SUM('Entrance-Foyer'!D4,Kitchen!D5,Laundry!D3,'DOWN Hall'!D3,'UP Hall'!D3,'Master BED'!D4,'Master Bath'!D3,'Up Bath'!D3,Basement!D6,Garage!D3)","v":0},22.97,0]
[null,"Chandelier (Entryway)","889-030",{"$f":"SUM('Entrance-Foyer'!D5)","v":0},59.97,0]
[null,"Bathroom Light Fixture","877-474",{"$f":"SUM('Down Bath'!D3,'Master Bath'!D4,'Up Bath'!D4,Basement!D7)","v":0},28.97,0]
[null,"Dining Room Hanging Light","324-275",{"$f":"SUM(Dining!D4,Breakfast!D5)","v":0},149,0]
[null,"Exterior - Hanging Light","240-177",{"$f":"SUM(Exterior!D3)","v":0},15.97,0]
[null,"Exterior - Flood/Senor Light","463-658",{"$f":"SUM(Exterior!D4)","v":0},26.97,0]
[null,null,null,null,null,{"$f":"SUM(F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12)","v":0}]
["Plumbing","Bathroom Sinks - 19\" Round","462-268",{"$f":"SUM('Down Bath'!D5,'Master Bath'!D6,'Up Bath'!D6,Basement!D9)","v":0},39,{"$f":"D14*E14","v":0}]
[null,"Kitchen Sink - 6\" Deep","622-291",{"$f":"SUM(Kitchen!D8)","v":0},49.95,0]
[null,"Faucet - Kitchen Goose Neck -CHECK FOR UPGRADE","527-019",{"$f":"SUM(Kitchen!D9)","v":0},89,0]
[null,"Faucet - Bathroom Sink","195-157",{"$f":"SUM('Down Bath'!D6,'Master Bath'!D7,'Up Bath'!D7,Basement!D10)","v":0},28,0]
[null,"Toilet","303-635",{"$f":"SUM('Down Bath'!D7,'Master Bath'!D8,'Up Bath'!D8,Basement!D11)","v":0},78,0]
[null,"Garbage Disposal","119-667",{"$f":"SUM(Kitchen!D10)","v":0},99.96,0]
[null,"Hot Water Heater - 40 Gallon Tall","182-755",{"$f":"SUM(Laundry!D6,Basement!D12,Garage!D6)","v":0},356,0]
[null,"Expansion Tank","594-885",{"$f":"SUM(Laundry!D7,Basement!D13,Garage!D7)","v":0},40.92,0]
[null,null,null,null,null,{"$f":"SUM(F14:F21)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",{"$f":"SUM('Entrance-Foyer'!D7,'Living Rm'!D6,'Den-Sitting'!D5,Kitchen!D12,Dining!D7,Breakfast!D7,Laundry!D9,'Down Bath'!D9,'DOWN Hall'!D5,'UP Hall'!D5,'Master BED'!D6,'Master Bath'!D10,'Up Bath'!D10,'Bed-2'!D5,'Bed 3'!D5,'Bed 4'!D5,Basement!D15,Garage!D9)","v":0},63,{"$f":"D23*E23","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",{"$f":"SUM('Entrance-Foyer'!D8,'Living Rm'!D7,'Den-Sitting'!D6,Kitchen!D13,Dining!D8,Breakfast!D8,Laundry!D10,'Down Bath'!D10,'DOWN Hall'!D6,'UP Hall'!D6,'Master BED'!D7,'Master Bath'!D11,'Up Bath'!D11,'Bed-2'!D6,'Bed 3'!D6,'Bed 4'!D6,Basement!D16,Garage!D10)","v":0},63,0]
[null,"Interior - 28 x 80 - LH","619-245",{"$f":"SUM('Entrance-Foyer'!D9,'Living Rm'!D8,'Den-Sitting'!D7,Kitchen!D14,Dining!D9,Breakfast!D9,Laundry!D11,'Down Bath'!D11,'DOWN Hall'!D7,'UP Hall'!D7,'Master BED'!D8,'Master Bath'!D12,'Up Bath'!D12,'Bed-2'!D7,'Bed 3'!D7,'Bed 4'!D7,Basement!D17,Garage!D11)","v":0},65,0]
[null,"Interior - 28 x 80 - RH","619-259",{"$f":"SUM('Entrance-Foyer'!D10,'Living Rm'!D9,'Den-Sitting'!D8,Kitchen!D15,Dining!D10,Breakfast!D10,Laundry!D12,'Down Bath'!D12,'DOWN Hall'!D8,'UP Hall'!D8,'Master BED'!D9,'Master Bath'!D13,'Up Bath'!D13,'Bed-2'!D8,'Bed 3'!D8,'Bed 4'!D8,Basement!D18,Garage!D12)","v":0},65,0]
[null,"Interior - 30 x 80 - LH","619-276",{"$f":"SUM('Entrance-Foyer'!D11,'Living Rm'!D10,'Den-Sitting'!D9,Kitchen!D16,Dining!D11,Breakfast!D11,Laundry!D13,'Down Bath'!D13,'DOWN Hall'!D9,'UP Hall'!D9,'Master BED'!D10,'Master Bath'!D14,'Up Bath'!D14,'Bed-2'!D9,'Bed 3'!D9,'Bed 4'!D9,Basement!D19,Garage!D13)","v":0},66,0]
[null,"Interior - 30 x 80 - RH","619-309",{"$f":"SUM('Entrance-Foyer'!D12,'Living Rm'!D11,'Den-Sitting'!D10,Kitchen!D17,Dining!D12,Breakfast!D12,Laundry!D14,'Down Bath'!D14,'DOWN Hall'!D10,'UP Hall'!D10,'Master BED'!D11,'Master Bath'!D15,'Up Bath'!D15,'Bed-2'!D10,'Bed 3'!D10,'Bed 4'!D10,Basement!D20,Garage!D14)","v":0},66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",{"$f":"SUM('Entrance-Foyer'!D13,'Living Rm'!D12,'Den-Sitting'!D11,Kitchen!D18,Dining!D13,Breakfast!D13,Laundry!D15,'DOWN Hall'!D11,'UP Hall'!D11,'Master BED'!D12,'Master Bath'!D16,'Up Bath'!D16,'Bed-2'!D11,'Bed 3'!D11,'Bed 4'!D11,Basement!D21,Garage!D15)","v":0},38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",{"$f":"SUM('Entrance-Foyer'!D14,'Living Rm'!D13,'Den-Sitting'!D12,Kitchen!D19,Dining!D14,Breakfast!D14,Laundry!D16,'DOWN Hall'!D12,'UP Hall'!D12,'Master BED'!D13,'Master Bath'!D17,'Up Bath'!D17,'Bed-2'!D12,'Bed 3'!D12,'Bed 4'!D12,Basement!D22,Garage!D16)","v":0},43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",{"$f":"SUM('Entrance-Foyer'!D15,'Living Rm'!D14,'Den-Sitting'!D13,Kitchen!D20,Dining!D15,Breakfast!D15,Laundry!D17,'DOWN Hall'!D13,'UP Hall'!D13,'Master BED'!D14,'Master Bath'!D18,'Up Bath'!D18,'Bed-2'!D13,'Bed 3'!D13,'Bed 4'!D13,Basement!D23,Garage!D17)","v":0},49.98,0]
[null,"Exterior - Front Entry Clear Fanlight Door  - LH 36\"","826-387",{"$f":"SUM(Exterior!D7)","v":0},188,0]
[null,"Exterior - Rear Entry Halflight Door - LH 32\"","826-322",{"$f":"SUM(Exterior!D8)","v":0},188,0]
[null,"Exterior - Aluminum Entry Door LH 36''","283-009",{"$f":"Exterior!D9","v":0},116,{"$f":"D34*E34","v":0}]
[null,null,null,null,null,{"$f":"SUM(F23:F34)","v":0}]
["Locks/HW","Deadbolt Set Project Pack (Per 2)","492-487",{"$f":"SUM(Exterior!D11)","v":0},27.98,{"$f":"D36*E36","v":0}]
[null,"Privacy Lock","332-208",{"$f":"SUM('Entrance-Foyer'!D18,'Living Rm'!D17,'Den-Sitting'!D16,Kitchen!D23,Dining!D18,Breakfast!D18,Laundry!D20,'Down Bath'!D17,'DOWN Hall'!D16,'UP Hall'!D16,'Master BED'!D17,'Master Bath'!D21,'Up Bath'!D21,'Bed-2'!D16,'Bed 3'!D16,'Bed 4'!D16,Basement!D26,Garage!D20)","v":0},7.98,{"$f":"D37*E37","v":0}]
[null,"Passage Knob","332-232",{"$f":"SUM('Entrance-Foyer'!D19,'Living Rm'!D18,'Den-Sitting'!D17,Kitchen!D24,Dining!D19,Breakfast!D19,Laundry!D21,'DOWN Hall'!D17,'UP Hall'!D17,'Master BED'!D18,'Master Bath'!D22,'Up Bath'!D22,'Bed-2'!D17,'Bed 3'!D17,'Bed 4'!D17,Basement!D27)","v":0},7.48,{"$f":"D38*E38","v":0}]
[null,"Hinges - Rounded Edged","207-394",{"$f":"SUM('Entrance-Foyer'!D20,'Living Rm'!D19,'Den-Sitting'!D18,Kitchen!D25,Dining!D20,Breakfast!D20,Laundry!D22,'Down Bath'!D18,'DOWN Hall'!D18,'UP Hall'!D18,'Master BED'!D19,'Master Bath'!D23,'Up Bath'!D23,'Bed-2'!D18,'Bed 3'!D18,'Bed 4'!D18,Basement!D28,Garage!D22,Exterior!D12)","v":0},2.78,{"$f":"D39*E39","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",{"$f":"SUM('Living Rm'!D20,'Den-Sitting'!D19,Kitchen!D26,Dining!D21,Breakfast!D21,Laundry!D23,'Down Bath'!D19,'DOWN Hall'!D19,'UP Hall'!D19,'Master BED'!D20,'Master Bath'!D24,'Up Bath'!D24,'Bed-2'!D19,'Bed 3'!D19,'Bed 4'!D19,Basement!D29,Garage!D23,Exterior!D13)","v":0},1.24,{"$f":"D40*E40","v":0}]
[null,null,null,null,null,{"$f":"SUM(F36:F40)","v":0}]
["Other","Garage Door Remotes","684-069",{"$f":"SUM(Garage!D25)","v":0},29.97,{"$f":"D42*E42","v":0}]
[null,"Double Garage Door",null,{"$f":"SUM(Garage!D26)","v":0}]
[null,"Single Garage Door",null,{"$f":"(Garage!D27)","v":0},369,{"$f":"(D44*E44)","v":0}]
[null,"Mailbox Post Spike",null,{"$f":"(Exterior!D16)","v":0},20,{"$f":"D45*E45","v":0}]
[null,"Mailbox","442-034",{"$f":"SUM(Exterior!D17)","v":0},17.97,{"$f":"D46*E46","v":0}]
[null,"Smoke Alarms - Pack of 6","929-281",null,24.97,{"$f":"D47*E47","v":0},"  Total Smoke Alarms Needed-->",{"$f":"SUM('Entrance-Foyer'!D23,'Living Rm'!D23,'Den-Sitting'!D22,Kitchen!D29,Dining!D24,Breakfast!D24,Laundry!D26,'DOWN Hall'!D22,'UP Hall'!D22,'Master BED'!D23,'Bed-2'!D22,'Bed 3'!D22,'Bed 4'!D22,Basement!D32,Garage!D28)","v":0}]
[null,"Thermostat",337534,{"$f":"SUM('Entrance-Foyer'!D24,'Den-Sitting'!D23,Kitchen!D30,Dining!D25,Breakfast!D25,'DOWN Hall'!D23,'UP Hall'!D23,'Master BED'!D24)","v":0},39.979999999999997,{"$f":"D48*E48","v":0}]
[null,"Mini Blinds",null,{"$f":"SUM('Entrance-Foyer'!D25,'Living Rm'!D24,'Den-Sitting'!D24,Kitchen!D31,Dining!D26,Breakfast!D26,Laundry!D27,'Down Bath'!D22,'DOWN Hall'!D24,'UP Hall'!D24,'Master BED'!D25,'Master Bath'!D27,'Up Bath'!D27,'Bed-2'!D23,'Bed 3'!D23,'Bed 4'!D23,Basement!D33,Garage!D29)","v":0},30,{"$f":"(D49*E49)","v":0}]
[null,"Mailbox Post",null,{"$f":"SUM(Exterior!D18)","v":0},35,{"$f":"D50*E50","v":0}]
[null,"Outlets - Pack of 10","697-882",null,3.9,0,"            Total Outlets Needed-->",{"$f":"SUM('Entrance-Foyer'!D26,'Living Rm'!D25,'Den-Sitting'!D25,Kitchen!D32,Dining!D27,Breakfast!D27,Laundry!D28,'Down Bath'!D23,'DOWN Hall'!D25,'UP Hall'!D25,'Master BED'!D26,'Master Bath'!D28,'Up Bath'!D28,'Bed-2'!D24,'Bed 3'!D24,'Bed 4'!D24,Basement!D34,Garage!D30)","v":0}]
[null,"Outlet Covers - Pack of 10","697-820",null,1.98,0,"   Total Outlet Covers Needed-->",{"$f":"SUM('Entrance-Foyer'!D27,'Living Rm'!D26,'Den-Sitting'!D26,Kitchen!D33,Dining!D28,Breakfast!D28,Laundry!D29,'Down Bath'!D24,'DOWN Hall'!D26,'UP Hall'!D26,'Master BED'!D27,'Master Bath'!D29,'Up Bath'!D29,'Bed-2'!D25,'Bed 3'!D25,'Bed 4'!D25,Basement!D35,Garage!D31)","v":0}]
[null,"Switches - Pack of 10","697-865",null,4.9000000000000004,0,"         Total Switches Needed-->",{"$f":"SUM('Entrance-Foyer'!D28,'Living Rm'!D27,'Den-Sitting'!D27,Kitchen!D34,Dining!D29,Breakfast!D29,Laundry!D30,'Down Bath'!D25,'DOWN Hall'!D27,'UP Hall'!D27,'Master BED'!D28,'Master Bath'!D30,'Up Bath'!D30,'Bed-2'!D26,'Bed 3'!D26,'Bed 4'!D26,Basement!D36,Garage!D32,)","v":0}]
[null,"Switch Covers - Pack of 10","697-798",null,1.98,0,"  Total Switch Covers Needed-->",{"$f":"SUM('Entrance-Foyer'!D29,'Living Rm'!D28,'Den-Sitting'!D28,Kitchen!D35,Dining!D30,Breakfast!D30,Laundry!D31,'Down Bath'!D26,'DOWN Hall'!D28,'UP Hall'!D28,'Master BED'!D29,'Master Bath'!D31,'Up Bath'!D31,'Bed-2'!D27,'Bed 3'!D27,'Bed 4'!D26,Basement!D37,Garage!D33,)","v":0}]
[null,"Doorstops","270-435",{"$f":"SUM('Entrance-Foyer'!D30,'Living Rm'!D29,'Den-Sitting'!D29,Kitchen!D36,Dining!D31,Breakfast!D31,Laundry!D32,'Down Bath'!D27,'DOWN Hall'!D29,'UP Hall'!D29,'Master BED'!D30,'Master Bath'!D32,'Up Bath'!D32,'Bed-2'!D28,'Bed 3'!D28,'Bed 4'!D28,Basement!D38,Garage!D34)","v":0},1.48,0]
[null,null,null,null,null,{"$f":"SUM(F42:F55)","v":0}]
["Appliances","Refrigerator (HTJ17CBDSA)","510-070",{"$f":"SUM(Kitchen!D38)","v":0},579,{"$f":"(D57*E57)","v":0}]
[null,"Refrigerator with ice maker (ED5GVEXVD)","134-721",{"$f":"SUM(Kitchen!D39)","v":0},1099,{"$f":"D58*E58","v":0}]
[null,"ELECTRIC Range  (JBS07SPSA)","984-448",{"$f":"SUM(Kitchen!D40)","v":0},549,{"$f":"(D59*E59)","v":0}]
[null,"GAS Range  (JGBS18GETSA )","265-403",{"$f":"SUM(Kitchen!D41)","v":0},549,0]
[null,"Microwave  (RVM1535MMSA)","867-011",{"$f":"SUM(Kitchen!D42)","v":0},229,0]
[null,"Dishwasher  (GSD2350VCS)","527-830",{"$f":"SUM(Kitchen!D43)","v":0},379,0]
[null,"Dishwasher Install Kit  (PM28X319GDS )","795-981",{"$f":"SUM(Kitchen!D44)","v":0},19.989999999999998,0]
[null,"Washer  (GHWP1000MWW)","772-941",{"$f":"SUM(Laundry!D35)","v":0},429,0]
[null,"Dryer  (GTDX100EMWW)","781-037",{"$f":"SUM(Laundry!D36)","v":0},429,0]
[null,"Dryer Power Cord  -3 prong (HD#627-833","627-833",{"$f":"SUM(Laundry!D37)","v":0},16.989999999999998,0]
[null,null,null,null,null,{"$f":"SUM(F57:F66)","v":0}]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F13,F22,F35,F41,F56,F67)","v":0}]

{"sheet":"Living Rm","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F5,F15,F21,F30)","v":0}]
["Lighting","Upgraded Flush Mount Fan Lights (Master Bedroom/Living Room)","122-135",null,69.97,{"$f":"D2*E2","v":0}]
[null,"Upgraded 52\" Fan w/Downrod (Master Bedroom/Living Room with Tall Ceiling)","165-474",null,69.97,{"$f":"D3*E3","v":0}]
[]
[null,null,null,null,null,{"$f":"SUM(F2:F4)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D6*E6","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F6:F14)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D17*E17","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D18*E18","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D19*E19","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D20*E20","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F20)","v":0}]
["Other",null,null,null,null,{"$f":"D22*E22","v":0}]
[null,"Smoke Alarm"]
[null,"Mini Blinds",null,null,30,{"$f":"(D24*E24)","v":0}]
[null,"Outlets","697-882",null,null,0]
[null,"Outlet Covers ","697-820",null,null,0]
[null,"Switches","697-865",null,null,0]
[null,"Switch Covers","697-798",null,null,0]
[null,"Doorstops","270-435",null,1.48,0]
[null,null,null,null,null,{"$f":"SUM(F22:F29)","v":0}]

{"sheet":"Den-Sitting","index":3,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F14,F20,F30)","v":0}]
["Lighting","Upgraded Flush Mount Fan Lights (Master Bedroom/Living Room)","122-135",null,69.97,{"$f":"D2*E2","v":0}]
[null,"Upgraded 52\" Fan w/Downrod (Master Bedroom/Living Room with Tall Ceiling)","165-474",null,69.97,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D5*E5","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F5:F13)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D16*E16","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D22*E22","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D23*E23","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D24*E24)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D25*E25","v":0}]
[null,"Outlet Covers","697-820",null,null,{"$f":"D26*E26","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D27*E27","v":0}]
[null,"Switch Covers","697-798",null,null,{"$f":"D28*E28","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D29*E29","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F29)","v":0}]

{"sheet":"Kitchen","index":4,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F6,F11,F21,F27,F37,F45)","v":0}]
["Lighting"]
[null,"4-Light Track Light (Kitchen)","987-423",null,49.97,{"$f":"D3*E3","v":0}]
[null,"3-Light Track Light (Eat-In Kitchen)","987-324",null,38.64,{"$f":"D4*E4","v":0}]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D5*E5","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F5)","v":0}]
["Plumbing"]
[null,"Kitchen Sink - 6\" Deep","622-291",null,49.95,{"$f":"D8*E8","v":0}]
[null,"Faucet - Kitchen Goose Neck -CHECK FOR UPGRADE","527-019",null,89,{"$f":"D9*E9","v":0}]
[null,"Garbage Disposal","119-667",null,99.96,{"$f":"D10*E10","v":0}]
[null,null,null,null,null,{"$f":"SUM(F7:F10)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D12*E12","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F12:F20)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D23*E23","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D24*E24","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D25*E25","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D26*E26","v":0}]
[null,null,null,null,null,{"$f":"SUM(F22:F26)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D29*E29","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D30*E30","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D31*E31)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D32*E32","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D33*E33","v":0}]
[null,"Switches","697-865",null,null,{"$f":"D34*E34","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D35*E35","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D36*E36","v":0}]
[null,null,null,null,null,{"$f":"SUM(F28:F36)","v":0}]
["Appliances","Refrigerator (HTJ17CBDSA)","510-070",null,579,{"$f":"(D38*E38)","v":0}]
[null,"Refrigerator with ice maker (ED5GVEXVD)","134-721",null,1099,{"$f":"D39*E39","v":0}]
[null,"ELECTRIC Range  (JBS07SPSA)","984-448",null,549,{"$f":"(D40*E40)","v":0}]
[null,"GAS Range  (JGBS18GETSA )","265-403",null,549,{"$f":"(D41*E41)","v":0}]
[null,"Microwave  (RVM1535MMSA)","867-011",null,229,{"$f":"(D42*E42)","v":0}]
[null,"Dishwasher  (GSD2350VCS)","527-830",null,379,{"$f":"(D43*E43)","v":0}]
[null,"Dishwasher Install Kit  (PM28X319GDS )","795-981",null,19.989999999999998,{"$f":"(D44*E44)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F38:F44)","v":0}]

{"sheet":"Dining","index":5,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F5,F16,F22,F32)","v":0}]
["Lighting"]
[null,"3-Light Track Light (Eat-In Kitchen)","987-324",null,38.64,{"$f":"D3*E3","v":0}]
[null,"Dining Room Hanging Light","324-275",null,149,{"$f":"D4*E4","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F4)","v":0}]
[]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D7*E7","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F7:F15)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D18*E18","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D19*E19","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D20*E20","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D21*E21","v":0}]
[null,null,null,null,null,{"$f":"SUM(F17:F21)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D24*E24","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D25*E25","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D26*E26)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D27*E27","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D28*E28","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D29*E29","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D30*E30","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D31*E31","v":0}]
[null,null,null,null,null,{"$f":"SUM(F23:F31)","v":0}]

{"sheet":"Breakfast","index":6,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F6,F16,F22,F32)","v":0}]
["Lighting"]
[null,"4-Light Track Light (Kitchen)","987-423",null,49.97,{"$f":"D3*E3","v":0}]
[null,"3-Light Track Light (Eat-In Kitchen)","987-324",null,38.64,{"$f":"D4*E4","v":0}]
[null,"Dining Room Hanging Light","324-275",null,149,{"$f":"D5*E5","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F5)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D7*E7","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F7:F15)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D18*E18","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D19*E19","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D20*E20","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D21*E21","v":0}]
[null,null,null,null,null,{"$f":"SUM(F17:F21)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D24*E24","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D25*E25","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D26*E26)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D27*E27","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D28*E28","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D29*E29","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D30*E30","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D31*E31","v":0}]
[null,null,null,null,null,{"$f":"SUM(F23:F31)","v":0}]

{"sheet":"Entrance-Foyer","index":7,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F6,F16,F21,F31)","v":0}]
["Lighting","Upgraded Flush Mount Fan Lights (Master Bedroom/Living Room)","122-135",null,69.97,{"$f":"D2*E2","v":0}]
[null,"Upgraded 52\" Fan w/Downrod (Master Bedroom/Living Room with Tall Ceiling)","165-474",null,69.97,{"$f":"D3*E3","v":0}]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D4*E4","v":0}]
[null,"Chandelier (Entryway)","889-030",null,59.97,{"$f":"D5*E5","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F5)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D7*E7","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F7:F15)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D18*E18","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D19*E19","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D20*E20","v":0}]
[null,null,null,null,null,{"$f":"SUM(F17:F20)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D23*E23","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D24*E24","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D25*E25)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D26*E26","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D27*E27","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D28*E28","v":0}]
[null,"Switch Covers","697-798",null,null,{"$f":"D29*E29","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D30*E30","v":0}]
[null,null,null,null,null,{"$f":"SUM(F22:F30)","v":0}]

{"sheet":"Laundry","index":8,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F8,F18,F24,F33,F38)","v":0}]
["Lighting"]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Plumbing"]
[null,"Hot Water Heater - 40 Gallon Tall","182-755",null,356,{"$f":"D6*E6","v":0}]
[null,"Expansion Tank","594-885",null,40.92,{"$f":"D7*E7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F5:F7)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D9*E9","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F9:F17)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D20*E20","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D21*E21","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D22*E22","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D23*E23","v":0}]
[null,null,null,null,null,{"$f":"SUM(F19:F23)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D26*E26","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D27*E27)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D28*E28","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D29*E29","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D30*E30","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D31*E31","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D32*E32","v":0}]
[null,null,null,null,null,{"$f":"SUM(F25:F32)","v":0}]
["Appliances"]
[null,"Washer  (GHWP1000MWW)","772-941",null,429,{"$f":"(D35*E35)","v":0}]
[null,"Dryer  (GTDX100EMWW)","781-037",null,429,{"$f":"(D36*E36)","v":0}]
[null,"Dryer Power Cord  -3 prong (HD#627-833","627-833",null,16.989999999999998,{"$f":"(D37*E37)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F34:F37)","v":0}]

{"sheet":"DOWN Hall","index":9,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F14,F20,F30)","v":0}]
["Lighting"]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D5*E5","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F5:F13)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D16*E16","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D22*E22","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D23*E23","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D24*E24)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D25*E25","v":0}]
[null,"Outlet Covers","697-820",null,null,{"$f":"D26*E26","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D27*E27","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D28*E28","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D29*E29","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F29)","v":0}]

{"sheet":"Down Bath","index":10,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F8,F15,F20,F28)","v":0}]
["Lighting"]
[null,"Bathroom Light Fixture","877-474",null,28.97,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Plumbing","Bathroom Sinks - 19\" Round","462-268",null,39,{"$f":"D5*E5","v":0}]
[null,"Faucet - Bathroom Sink","195-157",null,28,{"$f":"D6*E6","v":0}]
[null,"Toilet","303-635",null,78,{"$f":"D7*E7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F5:F7)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D9*E9","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,null,null,null,null,{"$f":"SUM(F9:F14)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F19)","v":0}]
["Other"]
[null,"Mini Blinds",null,null,30,{"$f":"(D22*E22)","v":0}]
[null,"Outlets","697-882",null,null,{"$f":"D23*E23","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D24*E24","v":0}]
[null,"Switches","697-865",null,null,{"$f":"D25*E25","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D26*E26","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D27*E27","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F27)","v":0}]

{"sheet":"UP Hall","index":11,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F14,F20,F30,)","v":0}]
["Lighting",null,null,null,null,{"$f":"D2*E2","v":0}]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D5*E5","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F5:F13)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D16*E16","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D22*E22","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D23*E23","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D24*E24)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D25*E25","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D26*E26","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D27*E27","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D28*E28","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D29*E29","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F29)","v":0}]

{"sheet":"Master BED","index":12,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F5,F15,F21,F31)","v":0}]
["Lighting","Upgraded Flush Mount Fan Lights (Master Bedroom/Living Room)","122-135",null,69.97,{"$f":"D2*E2","v":0}]
[null,"Upgraded 52\" Fan w/Downrod (Master Bedroom/Living Room with Tall Ceiling)","165-474",null,69.97,{"$f":"D3*E3","v":0}]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D4*E4","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F4)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D6*E6","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F6:F14)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D17*E17","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D18*E18","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D19*E19","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D20*E20","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F20)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D23*E23","v":0}]
[null,"Thermostat",337534,null,39.979999999999997,{"$f":"D24*E24","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D25*E25)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D26*E26","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D27*E27","v":0}]
[null,"Switches","697-865",null,null,{"$f":"D28*E28","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D29*E29","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D30*E30","v":0}]
[null,null,null,null,null,{"$f":"SUM(F22:F30)","v":0}]

{"sheet":"Master Bath","index":13,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F5,F9,F19,F25,F33)","v":0}]
["Lighting"]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D3*E3","v":0}]
[null,"Bathroom Light Fixture","877-474",null,28.97,{"$f":"D4*E4","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F4)","v":0}]
["Plumbing","Bathroom Sinks - 19\" Round","462-268",null,39,{"$f":"D6*E6","v":0}]
[null,"Faucet - Bathroom Sink","195-157",null,28,{"$f":"D7*E7","v":0}]
[null,"Toilet","303-635",null,78,{"$f":"D8*E8","v":0}]
[null,null,null,null,null,{"$f":"SUM(F6:F8)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D10*E10","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F10:F18)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D21*E21","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D22*E22","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D23*E23","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D24*E24","v":0}]
[null,null,null,null,null,{"$f":"SUM(F20:F24)","v":0}]
["Other"]
[null,"Mini Blinds",null,null,30,{"$f":"(D27*E27)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D28*E28","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D29*E29","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D30*E30","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D31*E31","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D32*E32","v":0}]
[null,null,null,null,null,{"$f":"SUM(F26:F32)","v":0}]

{"sheet":"Up Bath","index":14,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F5,F9,F19,F25,F33)","v":0}]
["Lighting"]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D3*E3","v":0}]
[null,"Bathroom Light Fixture","877-474",null,28.97,{"$f":"D4*E4","v":0}]
[null,null,null,null,null,{"$f":"SUM(F3:F4)","v":0}]
["Plumbing","Bathroom Sinks - 19\" Round","462-268",null,39,{"$f":"D6*E6","v":0}]
[null,"Faucet - Bathroom Sink","195-157",null,28,{"$f":"D7*E7","v":0}]
[null,"Toilet","303-635",null,78,{"$f":"D8*E8","v":0}]
[null,null,null,null,null,{"$f":"SUM(F6:F8)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D10*E10","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F10:F18)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D21*E21","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D22*E22","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D23*E23","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D24*E24","v":0}]
[null,null,null,null,null,{"$f":"SUM(F20:F24)","v":0}]
["Other"]
[null,"Mini Blinds",null,null,30,{"$f":"(D27*E27)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D28*E28","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D29*E29","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D30*E30","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D31*E31","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D32*E32","v":0}]
[null,null,null,null,null,{"$f":"SUM(F26:F32)","v":0}]

{"sheet":"Bed-2","index":15,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F14,F20,F29)","v":0}]
["Lighting"]
[null,"Basic Bedroom Fan/Light (Secondary Bedrooms)","270-614",null,26.47,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D5*E5","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F5:F13)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D16*E16","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D22*E22","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D23*E23)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D24*E24","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D25*E25","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D26*E26","v":0}]
[null,"Switch Covers","697-798",null,null,{"$f":"D27*E27","v":0}]
[null,"Doorstops","270-435",null,null,{"$f":"D28*E28","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F28)","v":0}]

{"sheet":"Bed 3","index":16,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F14,F20,F29)","v":0}]
["Lighting"]
[null,"Basic Bedroom Fan/Light (Secondary Bedrooms)","270-614",null,26.47,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D5*E5","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F5:F13)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D16*E16","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D22*E22","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D23*E23)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D24*E24","v":0}]
[null,"Outlet Covers","697-820",null,null,{"$f":"D25*E25","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D26*E26","v":0}]
[null,"Switch Covers","697-798",null,null,{"$f":"D27*E27","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D28*E28","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F28)","v":0}]

{"sheet":"Bed 4","index":17,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F14,F20,F29)","v":0}]
["Lighting"]
[null,"Basic Bedroom Fan/Light (Secondary Bedrooms)","270-614",null,26.47,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F2:F3)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D5*E5","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F5:F13)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D16*E16","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D17*E17","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D18*E18","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D22*E22","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D23*E23)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D24*E24","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D25*E25","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D26*E26","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D27*E27","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D28*E28","v":0}]
[null,null,null,null,null,{"$f":"SUM(F21:F28)","v":0}]

{"sheet":"Basement","index":18,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F8,F14,F24,F30,F39,)","v":0}]
["Lighting","Upgraded Flush Mount Fan Lights (Master Bedroom/Living Room)","122-135",null,69.97,{"$f":"D2*E2","v":0}]
[null,"Basic Bedroom Fan/Light (Secondary Bedrooms)","270-614",null,26.47,0]
[null,"4-Light Track Light (Kitchen)","987-423",null,49.97,0]
[null,"3-Light Track Light (Eat-In Kitchen)","987-324",null,38.64,0]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,0]
[null,"Bathroom Light Fixture","877-474",null,28.97,0]
[null,null,null,null,null,{"$f":"SUM(F2:F7)","v":0}]
["Plumbing","Bathroom Sinks - 19\" Round","462-268",null,39,{"$f":"D9*E9","v":0}]
[null,"Faucet - Bathroom Sink","195-157",null,28,{"$f":"D10*E10","v":0}]
[null,"Toilet","303-635",null,78,{"$f":"D11*E11","v":0}]
[null,"Hot Water Heater - 40 Gallon Tall","182-755",null,356,{"$f":"D12*E12","v":0}]
[null,"Expansion Tank","594-885",null,40.92,{"$f":"D13*E13","v":0}]
[null,null,null,null,null,{"$f":"SUM(F9:F13)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D15*E15","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F15:F23)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D26*E26","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D27*E27","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D28*E28","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D29*E29","v":0}]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]
["Other"]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D32*E32","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D33*E33)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D34*E34","v":0}]
[null,"Outlet Covers","697-820",null,null,{"$f":"D35*E35","v":0}]
[null,"Switches ","697-865",null,null,{"$f":"D36*E36","v":0}]
[null,"Switch Covers ","697-798",null,null,{"$f":"D37*E37","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D38*E38","v":0}]
[null,null,null,null,null,{"$f":"SUM(F31:F38)","v":0}]

{"sheet":"Garage","index":19,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F4,F8,F18,F24,F35)","v":0}]
["Lighting"]
[null,"Dome Lights - 2 Pack (Hallways, etc)","701-704",null,22.97,{"$f":"D3*E3","v":0}]
[null,null,null,null,null,{"$f":"SUM(F3:F3)","v":0}]
["Plumbing"]
[null,"Hot Water Heater - 40 Gallon Tall","182-755",null,356,{"$f":"D6*E6","v":0}]
[null,"Expansion Tank","594-885",null,40.92,{"$f":"D7*E7","v":0}]
[null,null,null,null,null,{"$f":"SUM(F5:F7)","v":0}]
["Doors","Interior - 24 x 80 - LH","619-164",null,63,{"$f":"D9*E9","v":0}]
[null,"Interior - 24 x 80 - RH","619-200",null,63,0]
[null,"Interior - 28 x 80 - LH","619-245",null,65,0]
[null,"Interior - 28 x 80 - RH","619-259",null,65,0]
[null,"Interior - 30 x 80 - LH","619-276",null,66,0]
[null,"Interior - 30 x 80 - RH","619-309",null,66,0]
[null,"Interior - Bi-Fold Door - 24\"","825-128",null,38.979999999999997,0]
[null,"Interior - Bi-Fold Door - 30\"","825-682",null,43.98,0]
[null,"Interior - Bi-Fold Door - 36\"","827-147",null,49.98,0]
[null,null,null,null,null,{"$f":"SUM(F9:F17)","v":0}]
["Locks/HW"]
[null,"Privacy Lock","332-208",null,7.98,{"$f":"D20*E20","v":0}]
[null,"Passage Knob","332-232",null,7.48,{"$f":"D21*E21","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D22*E22","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D23*E23","v":0}]
[null,null,null,null,null,{"$f":"SUM(F19:F23)","v":0}]
["Other","Garage Door Remotes","684-069",null,29.97,{"$f":"D25*E25","v":0}]
[null,"Double Garage Door",null,null,null,{"$f":"D26*E26","v":0}]
[null,"Single Garage Door",null,null,369,{"$f":"(D27*E27)","v":0}]
[null,"Smoke Alarm","929-281",null,null,{"$f":"D28*E28","v":0}]
[null,"Mini Blinds",null,null,30,{"$f":"(D29*E29)","v":0}]
[null,"Outlets ","697-882",null,null,{"$f":"D30*E30","v":0}]
[null,"Outlet Covers ","697-820",null,null,{"$f":"D31*E31","v":0}]
[null,"Switches","697-865",null,null,{"$f":"D32*E32","v":0}]
[null,"Switch Covers","697-798",null,null,{"$f":"D33*E33","v":0}]
[null,"Doorstops","270-435",null,1.48,{"$f":"D34*E34","v":0}]
[null,null,null,null,null,{"$f":"SUM(F25:F34)","v":0}]

{"sheet":"Exterior","index":20,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Area","Item","SKU",null,"Price","Total",{"$f":"SUM(F5,F10,F14,F19)","v":0}]
["Lighting"]
[null,"Exterior - Hanging Light","240-177",null,15.97,{"$f":"D3*E3","v":0}]
[null,"Exterior - Flood/Senor Light","463-658",null,26.97,{"$f":"D4*E4","v":0}]
[null,null,null,null,null,{"$f":"SUM(F3:F4)","v":0}]
["Doors"]
[null,"Exterior - Front Entry Clear Fanlight Door  - LH 36\"","826-387",null,188,{"$f":"D7*E7","v":0}]
[null,"Exterior - Rear Entry Halflight Door - LH 32\"","826-322",null,188,{"$f":"D8*E8","v":0}]
[null,"Exterior - Aluminum Entry Door LH 36''","283-009",null,116,{"$f":"D9*E9","v":0}]
[null,null,null,null,null,{"$f":"SUM(F7:F9)","v":0}]
["Locks/HW","Deadbolt Set Project Pack (Per 2)","492-487",null,27.98,{"$f":"D11*E11","v":0}]
[null,"Hinges - Rounded Edged","207-394",null,2.78,{"$f":"D12*E12","v":0}]
[null,"Hinge Screws - 18 Pack","208-133",null,1.24,{"$f":"D13*E13","v":0}]
[null,null,null,null,null,{"$f":"SUM(F11:F13)","v":0}]
["Other"]
[null,"Mailbox Post Spike",null,null,20,{"$f":"D16*E16","v":0}]
[null,"Mailbox","442-034",null,17.97,{"$f":"D17*E17","v":0}]
[null,"Mailbox Post",null,null,35,{"$f":"D18*E18","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F18)","v":0}]

{"sheet":"Sheet1","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}