Psychrometric formulas in spreadsheets
Over the years, I have programmed the psychrometric formulas in many different programming languages. And even more spreadsheets.
At some point, I grew tired of having to pull out my ASHRAE Fundamentals text and type in the coefficients for the Hyland and Wexter partial pressure formulation.
The other issue with spreadsheets is that relying on add-ins or VBA macros isn’t portable. To avoid that, every spreadsheet needs to have it’s own explicit copy of the formulas, directly in the cells themselves.
So I decided to build a page that would help me write these formulas for whatever new spreadsheet or program I was writing that would need psychrometric formulas.
And thus, excel-psychrometrics.com was born.
This page allows you to quickly copy the psychrometric formulas that you will need, allowing you to update the cells or variables that are required for your situation.
So while the current domain has Excel in the name, it is not limited to be useful only for Excel. It can easily be used for any spreadsheet. I chose to put excel in the domain simply because it is shorter than spreadsheet and probably more memorable.
So head over to excel-psychrometrics.com and see if it can help you! If you like it and you by chance have a GitHub account, be sure to give it a star.