ASHRAE 62.1 Ventilation Calculator

I have begun an Excel workbook that estimates outdoor-air requirements under ASHRAE 62.1-2025, but it still needs a robust calculation engine and clearer presentation. You will take what I have, apply the Standard’s mass-balance approach, and return a spreadsheet that quickly shows how much outside air is needed when air-cleaning devices are in use. Core inputs must include supply air, desired outside air when using the IAQP, zone size and height, expected occupancy with override, and the specific purification technology being applied and it's effectiveness. Within the sheet those variables should feed the ASHRAE mass-balance equations as well as ventilation-efficiency calculations so that the output reflects both source capture and recirculated air quality. If you prefer to keep the underlying 62.1 tables in a hidden tab that is fine—as long as I can update them when the standard is revised. I am aiming for an intermediate-level tool: the main results and any key intermediate numbers should be visible at a glance, supplemented by a few clear charts (for example, outdoor-air flow versus occupancy or purifier removal efficiency). No need for an exhaustive dashboard; a couple of well-chosen visuals will suffice. I will supply: • My existing starter workbook (basic layout, with formulas, but all needs checked) • Comply with ASHRAE 62.1-2025 You will deliver: • A clean, logically structured XLSX file with labelled input cells, protected calculation areas, and concise in-cell documentation • Built-in checks so obvious data-entry errors flag themselves If you already work with ASHRAE standards and are comfortable translating them into Excel logic, this should feel straightforward. Let me know how you would approach the mass-balance section and any questions you have about the current sheet.

ID Projek: 40322933