Spreadsheet: 875607d1722216516-how-to-keep-a-drop-down-table-list-from-changing-excel-drop-down-list
Sheet: 102

 | Unit 102
 |  |  |  |  |  | Budget Summary |  |  |  | Cabinets: 86 1/16" wide, 79" tall to soffit. Tall pantry: 18 1/2" wide. Sink cabs 65" wide
 |  |  | Length | Depth |  | Materials
 |  |  | 5 | 0 |  |  | Budget | Actual
 |  | In Inches |  |  |  | Total | 0 | 0
 |  | Total Sq Ft | 80 |  |  | Per Sq Ft | 0 | 0
 |  | % of total | #N/A
 |  |  |  |  |  | Labor
 |  | Total Cabinets | 10 |  |  |  | Budget | Actual |  | 108 | 115 | 85 | 55 | 31
 |  |  |  |  |  | Total | #N/A | #N/A
 |  |  |  |  |  | Per Sq Ft | #N/A | #N/A
 | Materials
 | Unit | Location | Category | Item | Coverage | Coverage Per | Qty | Unit | Budget Cost (Each) | Budget Cost (Total) | Actual Cost (Each) | Actual Cost (Total) | Difference | Supplier | Item name | Item # | Link
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Pantry #1: 18x42 wall | 18 |  | 1 |  |  | 159 |  | 0 |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Shaker-18-in-W-x-12-in-D-x-42-in-H-Assembled-Wall-Kitchen-Cabinet-in-Satin-White-KW1842-SSW/205390909
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Pantry #1: 18x42 wall | 18 |  | 1 |  |  | 159 |  | 0
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Right Sink Base | 15 |  | 1 |  |  | 189 |  | 0
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Sink Base | 30 |  | 1 |  |  | 219 |  |  |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Shaker-30-in-W-x-24-in-D-x-34-5-in-H-Assembled-Sink-Base-Kitchen-Cabinet-in-Satin-White-KSB30-SSW/205390954
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Stove Counter Base | 9 |  | 1 |  |  | 155 |  |  |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Shaker-12-in-W-x-24-in-D-x-34-5-in-H-Assembled-Base-Kitchen-Cabinet-in-Satin-White-with-Ball-Bearing-Drawer-Glides-KB12-SSW/204610519
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Upper 1 36" | 36 |  | 1 |  |  | 219 |  |  |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Shaker-24-in-W-x-12-in-D-x-30-in-H-Assembled-Wall-Kitchen-Cabinet-in-Satin-White-KW2430-SSW/204640135
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Upper 1 36" | 36 |  | 1 |  |  | 219
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | 30x12 microwave | 30 |  | 1 |  |  | 145 |  |  |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Shaker-30-in-W-x-12-in-D-x-12-in-H-Assembled-Wall-Bridge-Kitchen-Cabinet-in-Satin-White-KW3012-SSW/204640266
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | 30x12 Fridge Cabinet | 30 |  | 1 |  |  | 145
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | [NAME] In Between | 9x30 |  | 1 |  |  | 88 | 1379
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Granite | 14.33333333333333 |  | 1 |  | 50 | 716.6666666666667 | 870 | 870
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Sink and Cutout | 0 |  | 1 |  | 200 | 200 | 235 | 235
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Faucet cut | 0 |  | 1 |  | 100 | 100
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Trip charge (small job) |  |  |  |  | 0 | 0 | 185 | 185
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Backsplash | 10.75 | 12 | 2 | boxes | 49 | 98
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Grout: Custom Products Sanded Walnut | #N/A |  | 1 |  | 15 | 15
 | 102 | Kitchen | Appliances | Fridge |  |  | 1 |  | 1000 | 1000
 | 102 | Kitchen | Appliances | Dishwasher |  |  | 1 |  | 500 | 500
 | 102 | Kitchen | Appliances | Stove |  |  | 1 |  | 700 | 700
 | 102 | Kitchen | Appliances | Microwave |  |  | 1 |  | 250 | 250
 | 102 | Kitchen | Electrical | Electrical (new panel, couple of outlets) |  |  | 1 |  | 700 | 700
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Hardware |  |  | 1 |  | 100 | 100
 | 102 | Bathroom
 | 102 | Bathroom
 | 102 | Bathroom
 |  |  |  | Total |  |  |  |  |  | 6076.666666666667 |  | 1290
 |  |  |  | Cost Per Sq Ft |  |  |  |  |  | 75.95833333333334 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.homedepot.com/p/MSI-Metro-Anthracite-12-in-x-24-in-Matte-Porcelain-Stone-Look-Floor-and-Wall-Tile-14-sq-ft-Case-NHDMETANT1224C/308759731
 | Labor
 | Unit | Location | Category | Item | Coverage | Coverage Per | Qty | Unit | Budget Cost (Each) | Budget Cost (Total) | Actual Cost (Each) | Actual Cost (Total) | Difference | Supplier | Item name | Item # | Link
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Cabinet Installation |  |  | 8 |  | 55 | 440
 | 102 | Kitchen | Cabinets, Countertops, Backsplash | Backsplash |  |  |  |  |  | 500
 |  |  |  | Total |  |  |  |  |  | 940
 |  |  |  | Cost Per Sq Ft |  |  |  |  |  | 9.4
 |  |  | COURTLAND POLAR WHITE
 |  |  | x | Pantry #1: 18x42 wall | 18 |  | 1 |  |  | 159
 |  |  | x | Pantry #1: 18x42 wall | 18 |  | 1 |  |  | 159
 |  |  | x | Right Sink Base | 15 |  | 1 |  |  | 189
 |  |  | x | Sink Base | 30 |  | 1 |  |  | 219
 |  |  |  | Stove Counter Base | 9 |  | 1 |  |  | 155 |  |  |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Courtland-9-in-W-x-24-in-D-x-34-5-in-H-Assembled-Shaker-Base-Kitchen-Cabinet-in-Polar-White-BF09-CSW/314971385
 |  |  | x | Upper 1 36" | 36 |  | 1 |  |  | 219
 |  |  | x | Upper 1 36" | 36 |  | 1 |  |  | 219
 |  |  | x | 30x12 microwave | 30 |  | 1 |  |  | 145 |  |  |  |  |  |  | https://www.homedepot.com/p/Hampton-Bay-Courtland-30-in-W-x-12-in-D-x-12-in-H-Assembled-Shaker-Wall-Kitchen-Cabinet-in-Polar-White-W3012-CSW/314765401
 |  |  | x | 30x12 Fridge Cabinet | 30 |  | 1 |  |  | 145
 |  |  |  | [NAME] In Between | 9x30 |  | 1 |  |  | 88
 |  |  |  |  |  |  |  |  |  | 1697
 |  |  |  |  | 30
 |  |  |  |  | 24
 |  |  |  |  | 15
 |  |  |  |  | 69