Learned from the HVAC Lab and applied to the Water Quality Lab

Hi all,

I have graded a few HVAC Labs, and from what I have seen the most errors came from units conversion, units sloppiness, and misusing intermediate parameters (e.g., using a hypothetical parameter in the cell G17 instead of one in the cell G18). Thus, WATCH UNITS! Units may "annoy" you but they also give you best support in such Labs. Working with units in Excel is not obvious because they do not accompany your formulas. So take a piece of paper and solve manually all units along the equation chain, from the units given in the PDF to what units are required in the answer.

I learned from Prof. Mitchell to establish a column where you actually list your named variable. It gives you more visual control over your Excel formulas when you construct them and check for bugs. See the pic below.

May the Force be with you, always.

Walter