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.
Saved workbook valuesInputOutput
| Row | B | C | D |
|---|---|---|---|
| 5 | Program Area (m2) | 5000 | |
| 6 | Program | Commercial - Office Buliding - Office Space | |
| 7 | Occupant Density Method | ASHRAE 62.1-2022 Occupant Density | |
| 9 | Total People Count | 250 | |
| 12 | Flow Rate Method | ASHRAE 62.1-2022 Flow Rates | |
| 19 | Air Velocity (m/s) | 8 | |
| 29 | Peak Heating Load (kW) | 170 | |
| 30 | Peak 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 / description | Type / constraints / default |
|---|---|
program_area_m2Nonnegative floor program area. Units: m². Omitted input retains publisher's source default 5000. | Type: number Constraints: min: 0 Default: 5000 |
programExact 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_methodSelect 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_densityActive 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_methodSelect 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_areaActive 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_personActive 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_sDedicated 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_fractionDOAS 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_kwPeak sensible heating load Units: kW. Omitted input retains publisher's source default 170. | Type: number Constraints: min: 0 Default: 170 |
peak_cooling_kwPeak sensible cooling load Units: kW. Omitted input retains publisher's source default 240. | Type: number Constraints: min: 0 Default: 240 |
cooling_setpoint_cCooling setpoint must exceed supply_air_temperature_c Units: °C. Omitted input retains publisher's source default 24. | Type: number Default: 24 |
heating_setpoint_cHeating 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_sAll-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_fractionAll-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 / description | Type / constraints / default |
|---|---|
people_countOccupant count Units: persons. Positive unless stated otherwise. | Type: number |
outdoor_flow_l_per_sTotal ventilation outdoor airflow Units: L/s. Positive unless stated otherwise. | Type: number |
doas_total_shaft_m2Combined DOAS supply and exhaust shaft area Units: m². Positive unless stated otherwise. | Type: number |
all_air_total_shaft_m2Combined all-air supply and return shaft area Units: m². Positive unless stated otherwise. | Type: number |
shaft_comparisonSource 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/mcpSlug: 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.