Template · Architecture

Space program calculator (net to gross)

Converts a space program into net, department gross and building gross areas, with summary percentages.

See download membership

Preview below without an account. Downloads require the $19.85 yearly membership. Already registered? Sign in. XLSX, ODS and XML keep formulas; CSV and Numbers contain values only.

XLSXCSVODSXMLNumbers
Space program: spaces by department
Example data — replace the blue input cells with your own.
DepartmentSpaceQuantityNet area per space (m²)Total net area (m²)Notes
PublicEntrance lobby154.054.0
PublicReception and waiting130.030.0
PublicPublic WC, accessible24.59.0
PublicMultipurpose hall1160.0160.0
PublicCafé servery117.517.5
PublicLibrary reading area1133.0133.0
TeachingClassroom459.5238.0
TeachingWorkshop196.096.0
TeachingSeminar room130.030.0
TeachingTeaching store210.020.0
OfficesOffice, single214.028.0
OfficesOpen-plan workstations170.070.0

Showing the first 16 of 26 rows and 6 of 6 columns. Cells with formulas show the formula on hover.

What does this template do?

This calculator turns a list of spaces into net areas, then into department and building gross areas. Each space's net area is multiplied by its quantity. Each department adds its own grossing for internal circulation, walls and services, and the building adds a grossing factor for shared lobbies, lifts, stairs, shafts, plant and external walls.

The summary tab reports the totals, the net-to-gross ratio and the difference from a target building gross area. It also gives each department's share of the net and the gross area, and a building gross allocated to departments in proportion to their gross area, so the allocated figures add back to the total.

The example describes a fictional community learning centre with 21 space rows across five departments and a target of 1,250 square metres. Change the spaces and factors to match your brief. The factors are planning allowances, not measured values; confirm them with the client or the planning standard you work to.

What’s inside

  • Net area per space × quantity, totalled by department with SUMIF
  • Department grossing factor applied to each department's net area
  • Building grossing factor applied to the total department gross area
  • Net-to-gross ratio and difference from a target building gross area
  • Summary shares by department, with an allocated building gross that adds up

Which tabs does the workbook have?

TabWhat it holds
ProgramSpaces by department with quantity, net area per space and total net area.
GrossingDepartment grossing factors, building grossing factor, building gross area and comparison with the target.
SummaryTotals, net-to-gross ratio, and each department's share of net and gross area.
NotesWhat the workbook does, how to use it, the grossing method, the assumptions and the professional-verification note.

What formulas does this template use?

This template holds 97 formulas in 270 cells across 4 tabs, so 36% of its cells calculate. They use 5 distinct functions; the longest formula is 72 characters and 33 of them read from another tab.

FunctionUsesWhat it does
IF51one result when a test is true, another when false
SUM11adds numbers
SUMIF5adds values meeting one condition
ABS1absolute value
COUNTA1counts non-empty cells

Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.

How do you use it?

  1. On the Program tab, list each space with its department, quantity and net area.
  2. On the Grossing tab, set the grossing factor for each department from your planning standard.
  3. Set the building grossing factor for shared circulation and services.
  4. Enter the target building gross area from the brief.
  5. Read the totals, the net-to-gross ratio and the department shares on the Summary tab.

What is it good for?

  • Testing whether a programme fits a target gross area
  • Converting a room list into the gross area a client quotes
  • Comparing departments by share of net and gross area
  • Checking the net-to-gross ratio at early programming

Questions about this sheet

What is the difference between department and building grossing?

Department grossing covers circulation and walls inside each department. Building grossing covers the shared parts of the building, such as lobbies, lifts, stairs, shafts and plant.

Why is the allocated building gross different from the department gross?

The allocated figure adds the building grossing factor to each department in proportion to its gross area, so the allocations sum to the building gross.

Can I add a department?

Insert a row in the Grossing table, name the department exactly as it appears on the Program tab, and enter its factor. The check cell on the Grossing tab confirms that every department is counted.

Are the grossing factors standard?

They are example planning allowances. Use the figures from your brief, client or the area definitions in your jurisdiction.