A Field Perspective on Engineering Commissioning Resources
  • Home
    • What's New
  • Blog
    • Blog Support
  • SketchUp Models
    • SketchUp Resources
    • Bureaucratic Affairs Building HHW System Logic Exercise
    • Bureaucratic Affairs Building Scavenger Hunt
    • Chilled Water Plant System Diagram Exercise
    • The HIjend Hotel >
      • Chilled Water Plant Scoping Exercise
      • Ballroom AHU Scoping Exercise
      • Cooling Tower Scoping Exercise
  • Tools
    • Altitude Correction Factor
    • Economizer Evaluation Checklist
    • Eikon for Educators and WindLGC
    • Effective Duct Length Tool
    • Excel Third Axis Tool
    • Excel Time Value Conversion
    • Insulation Savings Tools
    • Logic Diagram Tool
    • Mixed Air Calculations
    • Monitoring Plan Spreadsheet
    • Pipe Friction Chart
    • Plot Digitizer >
      • Plot Digitizer Pump Curve Example
    • Square Law Spreadsheet
    • System Diagram Symbols
    • Thermodynamic Diagrams Spreadsheet
    • Universal Translator Data Analysis Tool
    • y = (m * x) + b Spreadsheet
  • Useful Formulas
    • Affinity Laws
    • Circular Equivalent Duct
    • Effective Duct Length
    • FT Guide Appendix C
    • HVAC Equations and Concepts
    • Hydraulic Diameter
    • Pump Power and Energy
    • "Square Law"
  • What's That Thing?
    • Cooling Towers
    • Pumps
    • Valves
  • Resources
    • Bill Coad's Writings
    • Data Logging Resources
    • EBCx Skills Guidebook
    • Energy Design Resources
    • Fisher Controls Valve Cavitation Bulletin
    • Functional Testing Guide
    • Honeywell Gray Manual
    • MCC Powers Bulletins
    • NBCIP Reports
    • PEC Tool Lending Library
    • PID Resources
    • Pneumatic Control Resources
    • Resource List
    • Scoping Resources
    • TAB Resources
    • Vintage Carrier Design Manual
    • VRF Systems
    • Williams' Wisdom
  • Videos
    • Bureaucratic Affairs HHW Logic Answers
    • Cooling Tower Flow Variation
    • Economizer Stratification
    • Functional Testing
    • Induction Principles
    • Monitoring Plans
    • Ripple Effects
    • Testing a Pump
    • The Garden of Low Entropy
    • Variable Flow Systems
  • Training
    • Materials from Classes and Presentations >
      • ACEEE
      • ASHRAE
      • ASHRAE - Engineers Notebook
      • BCxA and NCBC
      • BEST Institute
      • Case Studies
      • ERDC 2020 RCx Academy
      • ELPNW
      • ICEBO
      • Marriott AEP
      • Magazine Articles
      • NAVFAC
      • Pacific Energy Center Design, Performance and Commissioning Issues Classes >
        • PEC Class Materials Archive
      • Pacific Energy Center EBCx Project Review
      • Pacific Energy Center EBCx Workshop Series >
        • EBCx Workshop Series 12
        • EBCx Workshop Series 13
        • EBCx Workshop Series 14
        • EBCx Workshop Series 15 >
          • Student One On One Discussions
        • EBCx Workshop Series 16
        • EBCx Workshop Series 17
      • Portland General Electric
      • U of W >
        • U of W Archive
    • On Demand Training >
      • Fans, Ducts and AHUs
      • Induction Motor Principles
      • Introduction to Functional Testing
      • Scope of Work Documents
    • Training Opportunities
  • Contact
    • Copyright and Permissions
  • Home
    • What's New
  • Blog
    • Blog Support
  • SketchUp Models
    • SketchUp Resources
    • Bureaucratic Affairs Building HHW System Logic Exercise
    • Bureaucratic Affairs Building Scavenger Hunt
    • Chilled Water Plant System Diagram Exercise
    • The HIjend Hotel >
      • Chilled Water Plant Scoping Exercise
      • Ballroom AHU Scoping Exercise
      • Cooling Tower Scoping Exercise
  • Tools
    • Altitude Correction Factor
    • Economizer Evaluation Checklist
    • Eikon for Educators and WindLGC
    • Effective Duct Length Tool
    • Excel Third Axis Tool
    • Excel Time Value Conversion
    • Insulation Savings Tools
    • Logic Diagram Tool
    • Mixed Air Calculations
    • Monitoring Plan Spreadsheet
    • Pipe Friction Chart
    • Plot Digitizer >
      • Plot Digitizer Pump Curve Example
    • Square Law Spreadsheet
    • System Diagram Symbols
    • Thermodynamic Diagrams Spreadsheet
    • Universal Translator Data Analysis Tool
    • y = (m * x) + b Spreadsheet
  • Useful Formulas
    • Affinity Laws
    • Circular Equivalent Duct
    • Effective Duct Length
    • FT Guide Appendix C
    • HVAC Equations and Concepts
    • Hydraulic Diameter
    • Pump Power and Energy
    • "Square Law"
  • What's That Thing?
    • Cooling Towers
    • Pumps
    • Valves
  • Resources
    • Bill Coad's Writings
    • Data Logging Resources
    • EBCx Skills Guidebook
    • Energy Design Resources
    • Fisher Controls Valve Cavitation Bulletin
    • Functional Testing Guide
    • Honeywell Gray Manual
    • MCC Powers Bulletins
    • NBCIP Reports
    • PEC Tool Lending Library
    • PID Resources
    • Pneumatic Control Resources
    • Resource List
    • Scoping Resources
    • TAB Resources
    • Vintage Carrier Design Manual
    • VRF Systems
    • Williams' Wisdom
  • Videos
    • Bureaucratic Affairs HHW Logic Answers
    • Cooling Tower Flow Variation
    • Economizer Stratification
    • Functional Testing
    • Induction Principles
    • Monitoring Plans
    • Ripple Effects
    • Testing a Pump
    • The Garden of Low Entropy
    • Variable Flow Systems
  • Training
    • Materials from Classes and Presentations >
      • ACEEE
      • ASHRAE
      • ASHRAE - Engineers Notebook
      • BCxA and NCBC
      • BEST Institute
      • Case Studies
      • ERDC 2020 RCx Academy
      • ELPNW
      • ICEBO
      • Marriott AEP
      • Magazine Articles
      • NAVFAC
      • Pacific Energy Center Design, Performance and Commissioning Issues Classes >
        • PEC Class Materials Archive
      • Pacific Energy Center EBCx Project Review
      • Pacific Energy Center EBCx Workshop Series >
        • EBCx Workshop Series 12
        • EBCx Workshop Series 13
        • EBCx Workshop Series 14
        • EBCx Workshop Series 15 >
          • Student One On One Discussions
        • EBCx Workshop Series 16
        • EBCx Workshop Series 17
      • Portland General Electric
      • U of W >
        • U of W Archive
    • On Demand Training >
      • Fans, Ducts and AHUs
      • Induction Motor Principles
      • Introduction to Functional Testing
      • Scope of Work Documents
    • Training Opportunities
  • Contact
    • Copyright and Permissions

Mixed Air Calculation Spreadsheet

Conservation of mass and energy are both fundamental principles that apply in HVAC systems.  By starting with the steady flow energy equation and making some simplifying assumptions and substitutions, you can derive a number of useful relationships that will allow you to calculate things for a mixed air plenum, like the outdoor air percentage based on the outdoor air, return air, and mixed air temperature or the outdoor temperature that will created a specific mixed air temperature given a known outdoor air percentage and a known return air temperature.
Picture
The tool can be handy for a number of reasons.  For example, say you are scoping a facility and notice that the preheat coil is active on a mild day.  If you know what the minimum outdoor air percentage and design mixed air temperature are (things you can typically find in the design documents or control system settings) and have a sense of what the return temperature is (usually somewhere in the upper 60's to lower 70's°F and something you can measure in the field), then you can predict how cold it would need to be outside before the system, when it was on minimum outdoor air, would require preheat to maintain the desired mixed air temperature set point, assuming ideal mixing is occurring.  I (and the folks I work with) frequently perform this assessment and often find opportunities in the form of control system set point calibration or coordination issues, poor mixing conditions, improper minimum outdoor air settings, or leaking preheat valves.

The results of that calculation can be quite surprising if you have never done it before.  For instance, if you were looking at a system that targeted 20% minimum outdoor air, has a design mixed air temperature set point of 53°F, and has return air coming back at 72°F, then it would have to be 23°F below zero before you should need preheat, at least in theory.   So, if you are looking at the system I just described on a pleasant spring day and it is using preheat, something is not right.

 
​This spreadsheet tool has for basic relationships built into it:
  • Outdoor percentage based on outdoor air, return air, and supply air temperature
  • Outdoor air temperature that results in a 32°F mixed air temperature
  • Outdoor air temperature that results in a specific mixed air temperature of interest
  • Mixed air temperature created by a known outdoor air percentage, a known outdoor air temperature, and a known return air temperature

While the tool was developed for use with mixed air plenums, the physics of it will apply to any point in an HVAC system where mixing is occurring, like a tee in a piping system where flows come together.  Thus, it can be used to assess those types of situations as long as you keep the units consistent.  If you are interested in how the relationships were derived, you can see the derivation in a post on the blog titled Economizers–The Physics of a Mixed Air Plenum.

​Note that when you download the spreadsheet, you will need to strip out the descriptive name and parenthesis around the file name to get it to run properly on some systems.  For instance, for this file, you would need to eliminate the parenthesis and the words 
Mixed Air Calculations Spreadsheet from the file name.  You can also change the file name to something that works better for you if you want as long as you keep the .xlsx file extension.
Mixed Air Calculation Spreadsheet (mixed_air_calculations_vweb.xlsx)
File Size: 127 kb
File Type: xlsx
Download File

Home

Blog

Resources

Contact

Picture
A Field Perspective on Engineering - © 2017 Facility Dynamics Engineering, All Rights Reserved
(Contact Me to Check on Lefts or Any Other Questions You May Have about Permissions)