<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV> Hi there,</DIV>
<DIV> </DIV>
<DIV>Spreadsheet is attached that does exactly what you want to do. If you unprotected the sheet you will see how the wb formula is used.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards<BR></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Alec Stevens <astevens@dmiinc.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> bldg-sim@lists.onebuilding.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri, 10 December, 2010 11:43:23 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Bldg-sim] wetbulb formula<BR></FONT><BR>
<META content=off http-equiv=x-dns-prefetch-control>
<STYLE><!-- _filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"sans-serif";} a:link, span.MsoHyperlink {color:blue;text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple;text-decoration:underline;} span.EmailStyle17 {font-family:"sans-serif";color:windowtext;} .MsoChpDefault {} _filtered {margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {} --></STYLE>
<DIV class=WordSection1>
<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: astevens@dmiinc.com</P>
<P class=MsoNormal> </P></DIV>
<META content=on http-equiv=x-dns-prefetch-control></DIV></DIV></div></body></html>