formualizer

Excel workbook · Catalog edition v1.0

MIT BuildVac Ventilation Requirements

MIT Sustainable Design Lab

Estimate outdoor, heating and cooling airflow. Size supply and exhaust shafts for dedicated outdoor air and supply and return shafts for all-air systems.

Inputs
18
Outputs
12
File size
35 KB
Verification
Independent scenario check

Try it

Try it loads a copy of this file from formualizer.com.

CALCULATIONB5:D44

Saved workbook valuesInputOutput

RowBCD
5Program Area (m2)5000
6ProgramCommercial - Office Buliding - Office Space
7Occupant Density MethodASHRAE 62.1-2022 Occupant Density
9Total People Count250
12Flow Rate MethodASHRAE 62.1-2022 Flow Rates
19Air Velocity (m/s)8
29Peak Heating Load (kW)170
30Peak Cooling Load (kW)240

What was checked

Changed-input scenarios match an independent calculation.

Scope and limitations

Catalog calculations, not certification.

Try it uses Formualizer’s exact-match program lookups for the listed building types.

MIT BuildVac Ventilation Requirements with version-pinned publisher workbook calculations, scenario inputs and formula-level audit traces.

  • Edition v1.0 is a catalog pin, not a separately established publisher release number.
  • Heating uses the same cold supply temperature as cooling exactly as authored; this conceptual comparison is not full HVAC design.
  • Runtime approximate VLOOKUP fails exact source default on unsorted Lists!A1:D18. Exact-match adaptation is bounded to documented program enum; source bytes are unchanged.

What it computes

Ports for the compact flow: quick_ventilation_shafts. The full port contract includes all 30 ports.

Inputs (15)
Port / descriptionType / constraints / default
program_area_m2

Nonnegative floor program area. Units: m². Omitted input retains publisher's source default 5000.

Type: number

Constraints: min: 0

Default: 5000

program

Exact source program label; preserve source spelling Buliding and double spaces. Three lookups use documented exact-match preparation for these labels. Units: source enum. Omitted input retains publisher's source default "Commercial - Office Buliding - Office Space".

Type: string

Constraints: one of: Commercial - Office Buliding - Lobbies and Corridors, Commercial - Office Buliding - Office Space, Education - Assembly, Education - Classrooms (5-8), Education - Classrooms (9+), Education - Lecture Classroom, Education - Lecture Hall, Education - Libraries, Education - University Laboratory, Public Assembly - Auditorium Seating, Public Assembly - Libraries, Public Assembly - Museums, Retail - General, Retail - Mall Common Areas, Retail - Supermarket, Residential - Common Corridors, Residential - Living Area

Default: "Commercial - Office Buliding - Office Space"

occupant_density_method

Select standard density or activate custom_occupant_density. Units: source enum. Omitted input retains publisher's source default "ASHRAE 62.1-2022 Occupant Density".

Type: string

Constraints: one of: ASHRAE 62.1-2022 Occupant Density, User-Defined Occupant Density

Default: "ASHRAE 62.1-2022 Occupant Density"

custom_occupant_density

Active only in User-Defined Occupant Density mode; must supply nonnegative numeric value when activating. Omitted baseline is formula placeholder "-" and is not a numeric assumption. Units: persons/m². Omitted input retains publisher's source default "-".

Type: number

Constraints: min: 0

flow_rate_method

Select standard rates or activate both custom flow-rate ports. Units: source enum. Omitted input retains publisher's source default "ASHRAE 62.1-2022 Flow Rates".

Type: string

Constraints: one of: ASHRAE 62.1-2022 Flow Rates, User-Defined Flow Rates

Default: "ASHRAE 62.1-2022 Flow Rates"

custom_flow_per_area

Active only in User-Defined Flow Rates mode; supply alongside custom_flow_per_person. Omitted baseline is formula placeholder "-". Units: L/s/m². Omitted input retains publisher's source default "-".

Type: number

Constraints: min: 0

custom_flow_per_person

Active only in User-Defined Flow Rates mode; supply alongside custom_flow_per_area. Omitted baseline is formula placeholder "-". Units: L/s/person. Omitted input retains publisher's source default "-".

Type: number

Constraints: min: 0

doas_velocity_m_per_s

Dedicated outdoor air shaft velocity Units: m/s. Omitted input retains publisher's source default 8.

Type: number

Constraints: min: 0.01

Default: 8

doas_safety_fraction

DOAS shaft oversizing margin (0.15 means 15%) Units: decimal fraction. Omitted input retains publisher's source default 0.15.

Type: number

Constraints: min: 0

Default: 0.15

peak_heating_kw

Peak sensible heating load Units: kW. Omitted input retains publisher's source default 170.

Type: number

Constraints: min: 0

Default: 170

peak_cooling_kw

Peak sensible cooling load Units: kW. Omitted input retains publisher's source default 240.

Type: number

Constraints: min: 0

Default: 240

cooling_setpoint_c

Cooling setpoint must exceed supply_air_temperature_c Units: °C. Omitted input retains publisher's source default 24.

Type: number

Default: 24

heating_setpoint_c

Heating setpoint must exceed supply_air_temperature_c for the source calculation Units: °C. Omitted input retains publisher's source default 18.

Type: number

Default: 18

all_air_velocity_m_per_s

All-air supply shaft velocity Units: m/s. Omitted input retains publisher's source default 8.

Type: number

Constraints: min: 0.01

Default: 8

all_air_safety_fraction

All-air shaft oversizing margin (0.15 means 15%) Units: decimal fraction. Omitted input retains publisher's source default 0.15.

Type: number

Constraints: min: 0

Default: 0.15

Outputs (5)
Port / descriptionType / constraints / default
people_count

Occupant count Units: persons. Positive unless stated otherwise.

Type: number

outdoor_flow_l_per_s

Total ventilation outdoor airflow Units: L/s. Positive unless stated otherwise.

Type: number

doas_total_shaft_m2

Combined DOAS supply and exhaust shaft area Units: m². Positive unless stated otherwise.

Type: number

all_air_total_shaft_m2

Combined all-air supply and return shaft area Units: m². Positive unless stated otherwise.

Type: number

shaft_comparison

Source textual comparison of DOAS and all-air shafts Units: text. Positive unless stated otherwise.

Type: string

Questions this workbook answers

  • MIT BuildVac ventilation requirements calculator
  • ASHRAE 62.1 outdoor airflow shaft area
  • DOAS versus all-air shaft sizing

Questions and answers

Which standard and units are used?

The source labels ASHRAE 62.1-2022. Area is m², outdoor rates L/s, loads kW, temperatures °C and safety margins decimal fractions.

How do custom occupancy and flow rates work?

Select User-Defined Occupant Density and supply persons/m². Select User-Defined Flow Rates and supply both L/s/m² and L/s/person.

For agents

Connect an MCP client to the catalog endpoint:

https://catalog.formualizer.com/v1/mcp

Slug: mit-buildvac-ventilation · Edition: v1.0

search_workbooks
Optional arguments: query (string), theme (string), tag (string).
inspect_workbook
Required: slug (string). Optional: edition (string), flow (string).
evaluate_workbook
Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
  "name": "evaluate_workbook",
  "arguments": {
    "slug": "mit-buildvac-ventilation",
    "edition": "v1.0",
    "flow": "quick_ventilation_shafts",
    "inputs": {
      "program_area_m2": 10000
    }
  }
}

cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

Flows

quick_ventilation_shafts

Quick ventilation and shaft comparison

Compare DOAS and all-air shafts with coupled density/rate method switches. Supply all custom numeric ports when activating their methods. Baseline supply temperature 12.8°C and air properties remain pinned.

15 input ports · 5 output ports. Full membership in the port contract.

full_ventilation_assessment

Full ventilation and all-air assessment

All source decision inputs including air properties and supply temperature, plus supply/return/exhaust diagnostics. Fixed return ratio 80%; source lookup table is pinned.

18 input ports · 12 output ports. Full membership in the port contract.

REST example

Bundle scenario: quick_ventilation_shafts_larger_office · Flow: quick_ventilation_shafts

curl 'https://catalog.formualizer.com/v1/models/mit-buildvac-ventilation/v1.0/evaluate?flow=quick_ventilation_shafts' \
  -H 'Content-Type: application/json' \
  --data '{"inputs":{"program_area_m2":10000}}'

Expected response

Expected values from the bundle, subject to the check level above.

{
  "outputs": {
    "people_count": 500,
    "outdoor_flow_l_per_s": 4250,
    "doas_total_shaft_m2": 1.2218749999999998,
    "all_air_total_shaft_m2": 6.995576139985888,
    "shaft_comparison": "Shafts for the all-air system are larger than shafts for the dedicated outdoor air system"
  }
}

Looking for another spreadsheet? Request a workbook.