Site Feasibility for Developers: Plot Ratio, Site Coverage, Unit Yield, Parking Ratios & Build-Cost Checks

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn a plot's dimensions into site area, cut away the fictional setbacks to get the buildable envelope, cap it with the site coverage limit using MIN and name the limit that binds.
• Turn the fictional plot ratio into a maximum gross floor area, round the floors needed up with ROUNDUP, find the floors the height limit allows with ROUNDDOWN and take the achievable floor area with MIN.
• Deduct cores, corridors, plant rooms and a wall allowance from each floor's gross area, total the net sellable area and measure the building's efficiency against a fictional target.
• Split the net area by target shares, count the whole units of each type with ROUNDDOWN, total units and area used, measure the leftover area and test the share of family units against a fictional rule.
• Apply fictional parking and bike ratios per unit type, round the spaces up, add visitor spaces, test how many surface spaces fit on the open ground and price the rest underground.
• Turn the fictional open space, density and parking rules into a maximum number of flats each, take the smallest with MIN and let INDEX/MATCH name the binding constraint.
• Price six building elements with SUMPRODUCT, add contingency and fees, and turn the total into cost per flat, per net sellable m² and per m² of GFA against a fictional benchmark.
• Value three massing options from net area and sale price, calculate profit and profit on cost, rank them with RANK.EQ, chart the result and pick the scheme that clears the hurdle with the most homes.