You should be able to find these routines in the HVAC Toolkit book - sold by ashrae. I don't have it handy so not sure if you can use the routine directly in excel - you might need visual basic. I have done this previously in matlab, C++<br>
-Rohini<br><br><div class="gmail_quote">On Thu, Dec 9, 2010 at 4:43 PM, Alec Stevens <span dir="ltr"><<a href="mailto:astevens@dmiinc.com">astevens@dmiinc.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal">Hi,</p><p class="MsoNormal">Does anyone have an Excel-friendly equation they would be willing to share that can convert Tdb and RH into Twb? We have metered data giving us Tdb, RH, and Tdp, but we need to know wetbulb. We usually solve this problem with an Excel psychrometric add-in, but we need to distribute this spreadsheet to a client and cannot distribute the add-in at the same time.</p>
<p class="MsoNormal"> </p><p class="MsoNormal">We’ve tried a couple of multivariable regressions on the data, but because it is nonlinear, it is not proving to be that straightforward. Next stop might be a two-way lookup table, but that is kind of cumbersome and was hoping to avoid it.</p>
<p class="MsoNormal"> </p><p class="MsoNormal">Any help much appreciated.</p><p class="MsoNormal"> </p><p class="MsoNormal">Sincerely,<br>Alec Stevens</p><p class="MsoNormal"> </p><p class="MsoNormal">DMI<br>35 Walnut Street, Wellesley, MA 02481<br>
p: 781 431 1100 x11 f:781 431 1109<br>e: <a href="mailto:astevens@dmiinc.com" target="_blank">astevens@dmiinc.com</a></p><p class="MsoNormal"> </p></div></div><br>_______________________________________________<br>
Bldg-sim mailing list<br>
<a href="http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org" target="_blank">http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org</a><br>
To unsubscribe from this mailing list send a blank message to <a href="mailto:BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG">BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>--------------------------------------------------------------------------------<br>Rohini Brahme, Ph.D. LEED AP<br>Building energy analysis, tool development, and training<br>
Dallas/Fort Worth, TX<br><br>