Spreadsheet: 770933d1646338348-help-needed-using-sumif-xlookup-from-2-different-tables-active-plans-per-subdivision-and-standard-options-per-community-experimental-
Sheet: Standard Options by Sub Level

ASM Code | Option | Option Class | Level 1 (Vinyl) | Level 2 (Vinyl) | Level 3 (Vinyl) | Level 4 (Vinyl) | Level 5 (Vinyl) | Level 6 (HARDIE) | Level 7 (HARDIE) | Level 8 (HARDIE) | Level 9 (HARDIE) | Level 10 (HARDIE)
3846200001002 | Crawl (Green Star) | FOUNDATION/GRADING/CONCRETE
[PHONE] | Raised Slab | FOUNDATION/GRADING/CONCRETE
[PHONE] | High Crawl (Green Star) | FOUNDATION/GRADING/CONCRETE
[PHONE] | Extra High Crawl (Green Star) | FOUNDATION/GRADING/CONCRETE
[PHONE] | Basement - Unfinished (Certain Lots) | FOUNDATION/GRADING/CONCRETE
[PHONE] | 10 ft. Ceilings (Two Stories) w/ 9 ft. Ceilings Upstairs, 8ft. Interior Doors, 7ft. Windows | STRUCTUAL/FRAMING
[PHONE] | Faucet Package 1 (Brushed Nickel) | PLUMBING
[PHONE] | Faucet Package 2 (Black) | PLUMBING |  |  |  |  | X |  |  |  |  | X
[PHONE] | Heat Pump | HVAC/GAS
[PHONE] | SU | LOW VOLTAGE/SECURITY | X | X | X | X | X |  | X | X | X | X
[PHONE] | Fiber Cement Siding ILO Vinyl | EXTERIOR SIDING |  |  |  |  |  | X | X | X | X | X
[PHONE] | [NAME] | EXTERIOR SIDING
[PHONE] | [NAME] 3 | EXTERIOR SIDING
[PHONE] | Stone Accents - Around Garage Door | EXTERIOR SIDING | X
[PHONE] | Stone Accents - Front Porch Area | EXTERIOR SIDING | X
[PHONE] | Soft Close Cabinet Drawers | CABINETS
[PHONE] | Base Height Vanities (Master [NAME] Only) | CABINETS
[PHONE] | Base Height Vanities (Whole House) | CABINETS
[PHONE] | Cabinet Selection - Cambridge (Stained) | CABINETS
[PHONE] | Cabinet Selection - Cambridge (Painted) | CABINETS
[PHONE] | Cabinet Selection - Atlanta (Stained) | CABINETS
[PHONE] | Cabinet Selection - Atlanta (Painted) | CABINETS
[PHONE] | Cabinet Selection - Brunswick (Stained) | CABINETS
[PHONE] | Cabinet Selection - Brunswick (Painted) | CABINETS
[PHONE] | Cabinet Upgrade - Add Beaded Crown | CABINETS
[PHONE] | Cabinet Upgrade - Add Cove Crown | CABINETS | X
[PHONE] | Lever Handles for Interior Doors | INTERIOR OPTIONS
[PHONE] | Preferred Interior Paint Upgrade | PAINT | X |  | X | X | X |  |  | X | X | X
[PHONE] | Choice Interior Paint Upgrade | PAINT
[PHONE] | Washable Interior Paint Package | PAINT
[PHONE] | Level 1 Granite Upgrade - Kitchen | COUNTERTOPS |  |  | X | X | X |  |  | X | X | X
[PHONE] | Level 2 Granite Upgrade - Kitchen | COUNTERTOPS
[PHONE] | Level 3 Granite Upgrade - Kitchen | COUNTERTOPS
[PHONE] | Level 4 Granite/Quartz Upgrade - Kitchen | COUNTERTOPS
[PHONE] | Level 1 Granite Upgrade - Master Bath | COUNTERTOPS |  |  |  |  | X |  |  |  |  | X
[PHONE] | Level 2 Granite Upgrade - Master Bath | COUNTERTOPS
[PHONE] | Level 3 Granite Upgrade - Master Bath | COUNTERTOPS
[PHONE] | Level 4 Granite/Quartz Upgrade - Master Bath | COUNTERTOPS
[PHONE] | Level 1 Granite Upgrade - Bath 2 | COUNTERTOPS |  |  |  |  | X |  |  |  |  | X
[PHONE] | Level 2 Granite Upgrade - Bath 2 | COUNTERTOPS
[PHONE] | Level 3 Granite Upgrade - Bath 2 | COUNTERTOPS
[PHONE] | Level 4 Granite/Quartz Upgrade - Bath 2 | COUNTERTOPS
[PHONE] | Level 1 Granite Upgrade - Bath 3 | COUNTERTOPS |  |  |  |  | X |  |  |  |  | X
[PHONE] | Level 2 Granite Upgrade - Bath 3 | COUNTERTOPS
[PHONE] | Level 3 Granite Upgrade - Bath 3 | COUNTERTOPS
[PHONE] | Level 4 Granite/Quartz Upgrade - Bath 3 | COUNTERTOPS
[PHONE] | Level 1 Granite Upgrade - Bath 4 | COUNTERTOPS |  |  |  |  | X |  |  |  |  | X
[PHONE] | Level 2 Granite Upgrade - Bath 4 | COUNTERTOPS
[PHONE] | Level 3 Granite Upgrade - Bath 4 | COUNTERTOPS
[PHONE] | Level 4 Granite/Quartz Upgrade - Bath 4 | COUNTERTOPS
[PHONE] | Level 1 Granite Upgrade - Bath 5 | COUNTERTOPS |  |  |  |  | X |  |  |  |  | X
[PHONE] | Level 2 Granite Upgrade - Bath 5 | COUNTERTOPS
[PHONE] | Level 3 Granite Upgrade - Bath 5 | COUNTERTOPS
[PHONE] | Level 4 Granite/Quartz Upgrade - Bath 5 | COUNTERTOPS
[PHONE] | Light Package - Level 1 (Traditional) | ELECTRICAL
[PHONE] | Light Package - Level 2 (Farmhouse) | ELECTRICAL |  |  |  | X | X |  |  |  | X | X
[PHONE] | Flooring Selection | FLOORING
[PHONE] | Basement - Finished (Certain Lots) | FOUNDATION/GRADING/CONCRETE
[PHONE] | Concrete in Crawl Space (note: down at contract) | FOUNDATION/GRADING/CONCRETE
[PHONE] | Additional Concrete (Per SQFT) | CONCRETE
[PHONE] | Waterproofing - Level 2 - Fluid Applied Waterproofing Membrane (Watchdog by Tremco Barrier Solutions) 6" [NAME] | FOUNDATION/GRADING/CONCRETE
[PHONE] | Add Roof Above Patio or [NAME] | STRUCTUAL/FRAMING
[PHONE] | Side Entry Garage | STRUCTUAL/FRAMING
[PHONE] | Third Car Garage - 12x20 | STRUCTUAL/FRAMING
[PHONE] | Add Rain Shower Head (with separate valve) | PLUMBING
[PHONE] | Additional [NAME] | PLUMBING
[PHONE] | Additional Shower Head (with separate valve) | PLUMBING
[PHONE] | Comfort Height Raised Toilet – 17” | PLUMBING
[PHONE] | [NAME]) | PLUMBING
[PHONE] | [NAME] | PLUMBING
[PHONE] | Tankless Water Heater (Gas) | PLUMBING
[PHONE] | 50 Gallon Gas Water Heater | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Exterior Water Spigots (2) | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Elongated Toilets and Seats | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Double Stainless Steel Kitchen Sink | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Master [NAME]: Double Sinks | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Master [NAME]: Garden Tub & Separate Shower | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Hall Bathroom: Fiberglass Shower - Tub Combination | PLUMBING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Additional Gas Line - Misc | HVAC/GAS
[PHONE] | Central Vac. System (up to 4000 sq. ft.) Includes Vacuum Lines, One Set of Utensils, and One Tank | LOW VOLTAGE/SECURITY
[PHONE] | Vent Microwave Range Hood to Exterior | HVAC/GAS
[PHONE] | Gas Furnace | HVAC/GAS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Electric Air Conditioning Unit | HVAC/GAS | X | X | X | X | X | X | X | X | X | X
[PHONE] | 3-Way Electrical Switch (Includes 2 Switches) | ELECTRICAL
[PHONE] | Additional Cable/Phone Outlet | ELECTRICAL
[PHONE] | Additional Electrical Outlet - 110v | ELECTRICAL
[PHONE] | Additional Electrical Outlet - 110v Exterior | ELECTRICAL
[PHONE] | Additional Electrical Outlet - 110v GFCI | ELECTRICAL
[PHONE] | Additional Electrical Outlet - 220v | ELECTRICAL
[PHONE] | Additional Electrical Outlet - 220v Exterior | ELECTRICAL
[PHONE] | Additional Light Switch | ELECTRICAL
[PHONE] | Ceiling Fan Prewire | ELECTRICAL
[PHONE] | Crawlspace Floor Outlet | ELECTRICAL
[PHONE] | [NAME] | ELECTRICAL
[PHONE] | Flat Screen TV Package (Outlet and Conduit) | ELECTRICAL
[PHONE] | Flood Light (Pre-Wire Only) | ELECTRICAL
[PHONE] | Pre-Wire Overhead Lighting | ELECTRICAL
[PHONE] | Pre-Wired Electric Vehicle Charge Station | ELECTRICAL
[PHONE] | Wiring for Hot Tub - 220v | ELECTRICAL
[PHONE] | Ventless Gas Fireplace | FIREPLACE | X | X | X | X | X | X | X | X | X | X
[PHONE] | Additional Fireplace – Gas Logs | FIREPLACE
[PHONE] | Additional Fireplace - Wood Burning | FIREPLACE
[PHONE] | Garage Key Pad | GARAGE
[PHONE] | Security System Wiring & Equipment: Doors, Motion Detectors & Key Pad (No Monitoring) | LOW VOLTAGE/SECURITY
[PHONE] | Security System Wiring and Surround Sound Wiring | LOW VOLTAGE/SECURITY
[PHONE] | Wireless Contacts for Security System (OnDuty) (Per Window) | LOW VOLTAGE/SECURITY
[PHONE] | [NAME] | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | [NAME] | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | 6' [NAME] (Low-E, Double Pane) | WINDOWS
[PHONE] | Additional Sliding Glass Door | WINDOWS/EXTERIOR DOORS
[PHONE] | Additional Window - 3060 Single Window | WINDOWS/EXTERIOR DOORS
[PHONE] | Bay Window ILO (1) 3060 | WINDOWS/EXTERIOR DOORS
[PHONE] | Black Windows/Garage Door Package | WINDOWS/EXTERIOR DOORS
[PHONE] | French Door (Double - 1 Side Stationary) | WINDOWS/EXTERIOR DOORS | X
[PHONE] | French Door (Double - Both Sides Operable) | WINDOWS/EXTERIOR DOORS
[PHONE] | French Door (Single) | WINDOWS/EXTERIOR DOORS
[PHONE] | Frosted Window - Tub in Master [NAME] | WINDOWS/EXTERIOR DOORS
[PHONE] | Garage Side Exterior Door | STRUCTUAL/FRAMING
[PHONE] | Storm Door (All [NAME]) | WINDOWS/EXTERIOR DOORS
[PHONE] | Wood Grained Fiberglass Front Door With Sidelights | EXTERIOR OPTIONS
[PHONE] | Transom Window Over Front Door | EXTERIOR OPTIONS
[PHONE] | [NAME] | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Garage Door Opener with 2 Remotes | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Garage Door with Fixed Windows | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Shakes | EXTERIOR OPTIONS |  |  |  |  |  | X | X | X | X | X
[PHONE] | Vertical Board And Batten | EXTERIOR OPTIONS |  |  |  |  |  | X | X | X | X | X
[PHONE] | Extra Shutters (Per Set) | EXTERIOR OPTIONS
[PHONE] | Deck (Per Plan) | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Deck (Per SQFT) | EXTERIOR OPTIONS
[PHONE] | Composite Decking (Floor only - Per SQFT) | EXTERIOR OPTIONS
[PHONE] | Concrete Patio (Per Plan) | EXTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | EnergyStar Fiberglass Package Grade 1 Insulation Installation Air Sealing (Caulk Top and [NAME]) | INTERIOR OPTIONS
[PHONE] | Fiberglass Sound Insulation (Ceiling - Per Ro | INTERIOR OPTIONS
[PHONE] | Fiberglass Sound Insulation (Per Interior Wall) | INTERIOR OPTIONS
[PHONE] | R38 Insulation in Attic (Per SQFT) | INTERIOR OPTIONS
[PHONE] | R49 Insulation in Attic (Per SQFT) | INTERIOR OPTIONS
[PHONE] | Walls: [NAME] | STRUCTUAL/FRAMING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Attic: Blown-In [NAME] | STRUCTUAL/FRAMING | X | X | X | X | X | X | X | X | X | X
[PHONE] | Smooth Ceilings | INTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Drywall Corners - Rounded | INTERIOR OPTIONS | X | X | X | X | X | X | X | X | X | X
[PHONE] | Drywall Corners - Square | INTERIOR OPTIONS
[PHONE] | 12" Bank of Drawers | CABINETS
[PHONE] | 30" Bank of 3 Drawers (Per Cabinet) | CABINETS
[PHONE] | 6" Corbels (Brace for Countertop Overhangs) | CABINETS
[PHONE] | 9" Corbels (Brace for Countertop Overhangs) | CABINETS
[PHONE] | Roll-Out Trays (Per Cabinet) | CABINETS
[PHONE] | Vertical Roll Out Organizer (9" Cabinet) for [NAME], etc. | CABINETS
[PHONE] | [NAME] (no pulls) - Kitchen & Bathrooms | CABINETS
[PHONE] | [NAME] and Pull Sets  - Kitchen & Bathrooms | CABINETS
[PHONE] | Cabinet Pulls (no knobs) - Kitchen & Bathrooms | CABINETS
[PHONE] | Refrigerator Side Panel with - 12" Cabinet | CABINETS
[PHONE] | Refrigerator Side Panel with - 24" Cabinet | CABINETS
[PHONE] | Arched Doorway | STRUCTUAL/FRAMING | X | X | X | X | X | X | X | X | X | X
[PHONE] | [NAME] (Painted) | INTERIOR OPTIONS
[PHONE] | [NAME] (Painted) | INTERIOR OPTIONS
[PHONE] | Garage Base Boards | INTERIOR OPTIONS
[PHONE] | Chair Rail (Per Room) | TRIM
[PHONE] | Chair Rail with [NAME] (Per Room) | TRIM
[PHONE] | Cove Crown Molding (Per Room) | TRIM
[PHONE] | [NAME] (Per Room) | TRIM
[PHONE] | Decorative Interior Columns | STRUCTUAL/FRAMING
[PHONE] | Farmhouse Trim Package | TRIM |  |  |  |  | X |  |  |  |  | X
[PHONE] | Judges Paneling (Per Room) | TRIM
[PHONE] | [NAME] (Per SQFT) | INTERIOR OPTIONS
[PHONE] | Square Post & Square Stair Rails | INTERIOR OPTIONS
[PHONE] | Stair Square Post -Wrought Iron Spindles Only | INTERIOR OPTIONS
[PHONE] | 5-1/4 in. Baseboards | TRIM | X | X | X | X | X |  | X | X | X | X
[PHONE] | 7 in. Baseboards | TRIM | X
[PHONE] | Coffered Ceiling (Larger Room) | TRIM
[PHONE] | Coffered Ceiling With Cove Moulding (L) | TRIM
[PHONE] | Coffered Ceiling (Small Room) | TRIM
[PHONE] | Coffered Ceiling with Cove Crown Molding (S) | TRIM
[PHONE] | [NAME] | STRUCTUAL/FRAMING |  |  | X | X |  |  |  | X | X
[PHONE] | Pan Ceiling - Master Bedroom | STRUCTUAL/FRAMING |  |  |  |  | X |  |  |  |  | X
[PHONE] | Upgraded [NAME] Hearth Stone Up to Mantel, Wood Stained Mantel | FIREPLACE
[PHONE] | Upgraded Fireplace Raised Hearth & Stone to C | FIREPLACE
[PHONE] | Upgraded Fireplace Raised Hearth & White Stone Up to Mantel, Wood Stained Mantel | FIREPLACE
[PHONE] | Upgraded Fireplace Raised Hearth & White Stone Up to Ceiling, Wood Stained Mantel | FIREPLACE
[PHONE] | Interior Accent Wall | PAINT
[PHONE] | Farm House Sink - Double Bowl Stainless | COUNTERTOPS |  |  |  |  | X |  |  |  |  | X
[PHONE] | Farm House Sink - Double Bowl White | COUNTERTOPS
[PHONE] | Farm House Sink - Single Bowl Stainless | COUNTERTOPS
[PHONE] | Farm House Sink - Single Bowl White | COUNTERTOPS
[PHONE] | Cultred Marble - Master Bathroom | INTERIOR OPTIONS | X | X | X | X |  | X | X | X | X
[PHONE] | Cultred Marble - Bath 2 | INTERIOR OPTIONS | X | X | X | X |  | X | X | X | X
[PHONE] | Upgrade Carpet Pad | FLOORING
[PHONE] | Hardwood Floor: 5” Hand-scraped (Per SQFT) | FLOORING
[PHONE] | [NAME] Tile Backsplash - All Plans | TILE FLOORING/TILE BACKSPLASH
[PHONE] | Subway Tile Backsplash - All Plans | TILE FLOORING/TILE BACKSPLASH
[PHONE] | Add Bench to Tile Shower (3’ Depth) | TILE SHOWER
[PHONE] | Add Bench to Tile Shower (Corner) | TILE SHOWER
[PHONE] | Ceramic Tile Shower - 3' x 5" (Base) | TILE SHOWER
[PHONE] | Ceramic Tile Shower - 3' x 5" (Level 1) | TILE SHOWER
[PHONE] | Ceramic Tile Shower - 3' x 5" (Level 2) | TILE SHOWER
[PHONE] | Ceramic Tile Shower - 3' x 5" (Level 3) | TILE SHOWER
[PHONE] | Additional Row of Wire Shelving | INTERIOR OPTIONS
[PHONE] | Assist Bar For Shower/Tub (Concealed Screws) | INTERIOR OPTIONS
[PHONE] | Framed Shower Door (Sliding - 32" or Less) | SHOWER DOOR
[PHONE] | Framed Shower Door (32" + up to 28" Glass Panel) | SHOWER DOOR
[PHONE] | Frameless Shower Door (32" or Less) | SHOWER DOOR
[PHONE] | Frameless Shower Door (32" + up to 28" Glass Panel) | SHOWER DOOR
[PHONE] | Light Package - Standard | INTERIOR OPTIONS
[PHONE] | 2 Bulb Fluorescent Light | ELECTRICAL
[PHONE] | Ceiling Fan Pre-Wire and Installation | ELECTRICAL
[PHONE] | Flood Light Prewire and Install | ELECTRICAL
[PHONE] | Garage LED Light | ELECTRICAL
[PHONE] | Outdoor Ceiling Fan (Prewired & Install) | ELECTRICAL
[PHONE] | Pendant Light Prewire (existing switch) | ELECTRICAL
[PHONE] | Pendant Light Prewire (new switch) | ELECTRICAL
[PHONE] | Recessed Light Prewire and Install | ELECTRICAL
[PHONE] | Under Cabinet Lighting - LED | ELECTRICAL
[PHONE] | Pendant Light (Standard) | ELECTRICAL
[PHONE] | Pendant Light (Traditional) | ELECTRICAL
[PHONE] | Pendant Light (Farmhouse) | ELECTRICAL
[PHONE] | Frigidaire Black (Electric) | APPLIANCES | X | X |  |  |  | X | X
[PHONE] | Frigidaire Black (Gas) | APPLIANCES
[PHONE] | [NAME] (Electric) | APPLIANCES |  |  | X | X |  |  |  | X | X
[PHONE] | [NAME] (Gas) | APPLIANCES
[PHONE] | [NAME] (Electric) | APPLIANCES |  |  |  |  | X |  |  |  |  | X
[PHONE] | [NAME] (Gas) | APPLIANCES
[PHONE] | LG Upgrade Front Control Stainless (Electric) | APPLIANCES
[PHONE] | LG Upgrade Front Control Stainless (Gas) | APPLIANCES
[PHONE] | LG Upgrade Front Control Black Stainless(Ele) | APPLIANCES
[PHONE] | LG Upgrade Front Control Black Stainless(Gas) | APPLIANCES
[PHONE] | LG Built-In Package Stainless (Electric) | APPLIANCES
[PHONE] | LG Built-In Package Stainless (Gas) | APPLIANCES
[PHONE] | Frigidaire Side by Side Refrigerator Black (Model # FRSS2623AB) | APPLIANCES
[PHONE] | Frigidaire Side by Side Refrigerator Stainless (Model # FRSS2623AS) | APPLIANCES
[PHONE] | Frigidaire French Door Refrigerator Stainless (Model # FFHB2750TS) | APPLIANCES
[PHONE] | [NAME] by Side Refrigerator Stainless (Model # GRSS2652AF) | APPLIANCES
[PHONE] | Frigidaire Gallery French Door Refrigerator Stainless (Model # FGHB2868TF) | APPLIANCES
[PHONE] | LG Side by Side Refrigerator Stainless (Model # LRSXS2706S) | APPLIANCES
[PHONE] | LG French Door Refrigerator Stainless (Model # LFXS26973S) | APPLIANCES
[PHONE] | LG French Door Refrigerator Black Stainless (Model # [NAME]) | APPLIANCES
[PHONE] | 4' x 4' Bathroom Window Blind | INTERIOR OPTIONS
[PHONE] | Blinds Regular Window (Per Window) | INTERIOR OPTIONS
[PHONE] | Sliding Glass Door Blind | INTERIOR OPTIONS
[PHONE] | Sodded Front Lawn (10 Pallets) | LANDSCAPING
[PHONE] | Bushes, Shrub, Mulch and One Tree | LANDSCAPING
[PHONE] | 4" Conduit Below Driveway for Underground [NAME] | LANDSCAPING
[PHONE] | Drip Irrigation (up to 400 Feet) | LANDSCAPING
[PHONE] | One (1) Tank of Hydroseed | LANDSCAPING
[PHONE] | Pallet of Sod | LANDSCAPING
[PHONE] | Underground Drains for Downspouts (Up to 20 Feet) | LANDSCAPING
[PHONE] | [NAME] for Sprinkler System (4 Zones or Less) | LANDSCAPING
[PHONE] | Sprinkler System (2 Zones) | LANDSCAPING |  | X | X | X |  |  | X | X | X
[PHONE] | Sprinkler System (3 Zones) | LANDSCAPING |  |  |  |  | X |  |  |  |  | X
[PHONE] | Sprinkler System (4 Zones) | LANDSCAPING