<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Jeff</div><div><br></div>Is it possible to create running averages based on certain criteria? For instance, could I calculate the average of the temperature each day only when radiation is present (during daytime hours) so that the average does not reflect the cold nights?<div><br></div><div>The closest solution I have found to this is to use an 8 hour running average, so that you are getting 3 averages each day: <i>Midnight to 8am, 8am to 4pm, and 4pm to Midnight</i>. And then using Excel to average only the 8am to 4pm data and erase everything else. The problem with this is the radiation is still present after 8am or before 4pm at certain locations and depending on the time of season.<br><div><br></div><div>Thanks,</div><div>Nick</div><div><br><div><div><div>On Apr 8, 2011, at 12:44 PM, Jeff Thornton wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">You can also use the utility model that creates a running average - in your case a running 24 hour average. This will keep you from getting step changes at midnight.<br><br>Jeff<br><br>Jeff Thornton <br> President - TESS, LLC <br> <br> 22 North Carroll Street - Suite 370<br> Madison WI 53703 USA <br> <br> Phone: 608-274-2577 <br> Fax: 608-278-1475 <br> E-mail: <a href="mailto:thornton@tess-inc.com">thornton@tess-inc.com</a> <br> Web: <a href="http://www.tess-inc.com">www.tess-inc.com</a><br> <br> <br> <br> <!--replyfwdwrap--><div style="background-image: url("http://webmail.fusemail.com/de/r_bg_img.gif"); background-position: center top; background-repeat: repeat-x;"><strong>----- Original Message -----</strong><br><strong>From:</strong> "Adrien JEZEQUEL - ITF" <<a href="mailto:a.jezequel@itf.biz">a.jezequel@itf.biz</a>> <br><strong>Sent:</strong> Thu, April 7, 2011 9:10<br><strong>Subject:</strong> Re: [TRNSYS-users] average ambient day temperature<br><br><table cellspacing="5" width="100%"><tbody><tr><td><div class="!
PrivateMsgDiv"><!-- begin sanitized html --> <div class="bodyclass" style="color: rgb(0, 0, 0);"><font size="-1"><font face="Arial">Lana,<br> <br> I think you can also use Type55, from utility library.<br> <br> Best regards<br> </font></font> <div class="moz-signature"><hr size="2" color="#3300ff" align="LEFT" width="450"> !
<table border="0"> <tbody> <tr> <td width="120" rowspan="3"><center><a href="http://www.itf.biz/" target="_new"><span><logo_itf_2010.jpg></span></a><br> <font size="1" face="CALIBRI" color="#0000ff"><a href="http://www.itf.biz/" target="_new">www.itf.biz</a></font></center></td> <td colspan="2"><font size="2" face="CALIBRI" color="#000000">Adrien JEZEQUEL<br> Simulations Thermiques Dynamiques</font></td> </tr> <tr><td align="LEFT"><font size="4" face="CALIBRI" color="#0000f
f"><b>ITF</b></font></td> <td><font size="2" face="CALIBRI" color="#0000ff">62, Rue du Bolliet<br> 73230 St Alban Leysse<br> FRANCE<br> </font></td> </tr> <tr> <td align="LEFT" width="40"><font size="2" face="CALIBRI" color="#0000ff"> Phone :<br> Fax :<br> Mail:<br> </font></td> <td><font size="2" face="CALIBRI" color="#0000ff"> +33(0) 479 750 029<br> +33(0) 479 852 122<br> <a class="moz-txt-link-freetext" href="mailto:a.jezequel@itf.biz" target="_new">a.jezequel@itf.biz</a> ou <a class="moz-txt-link-freetext" href="mailto:aj@itf.biz" target="_new">aj@itf.biz</a></font></td> </tr> </tbody> </table> <i><font size="1" face="CALIBRI" color="#008000">Afin de contribuer au respect de l'environnement, !
merci de n'imprimer cet e-mail que si nécessaire<br> <font size="1" face="CALIBRI" color="#008000">Please, consider our environmental responsability before printing this email<br> </font></font></i></div> <br> Le 07/04/2011 14:56, Arno Dentel a écrit : <blockquote cite="mid:009f01cbf523$3eefe240$bccfa6c0$@dentel@ohm-hochschule.de" type="cite"> <style type="text/css">
</style> <div class="WordSection1"><p class="MsoNormal"><span lang="EN-US" style="color: blue;">Lana,</span></p><p class="MsoNormal"><span lang="EN-US" style="color: blue;">you can use Type127 to calculate an running mean value.</span></p><div><span lang="EN-US" style="color: blue;"> </span><br class="webkit-block-placeholder"></div><p class="MsoNormal"><span lang="EN-US" style="color: blue;">Best regards,</span></p><p class="MsoNormal"><span lang="EN-US" style="color: blue;">Arno</span></p><div><span lang="EN-US" style="color: blue;"> </span><br class="webkit-block-placeholder"></div><div><span lang="EN-US" style="color: blue;"> </span><br class="webkit-block-placeholder"></div> <div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;"><p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma"!
;,"sans-serif";">Von:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";"> <a class="moz-txt-link-abbreviated" href="mailto:trnsys-users-bounces@cae.wisc.edu" target="_new">trnsys-users-bounces@cae.wisc.edu</a> [<a class="moz-txt-link-freetext" href="mailto:trnsys-users-bounces@cae.wisc.edu" target="_new">mailto:trnsys-users-bounces@cae.wisc.edu</a>] <b>Im Auftrag von </b>Lana Saracevic<br> <b>Gesendet:</b> Donnerstag, 7. April 2011 10:04<br> <b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:trnsys-users@cae.wisc.edu" target="_new">trnsys-users@cae.wisc.edu</a><br> <b>Betreff:</b> [TRNSYS-users] average ambient day temperature</span></p></div></div><div> <br class="webkit-block-placeholder"></div><p class="MsoNormal"><span lang="EN-US" style="font-size: 10pt; font-family: "Arial",&q!
uot;sans-serif";">Dear all,</span></p><p cla="" ss="MsoNormal"><span lang="EN-US" style="font-size: 10pt; font-family: "Arial","sans-serif";">is there a Type that can calculate the average ambient day temperature of each day in the year, and where can I find it? I would like to use that to control the inlet temperature of a concrete core activation system.</span></p><div><span lang="EN-US" style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><br class="webkit-block-placeholder"></div><div><span lang="EN-US" style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span><br class="webkit-block-placeholder"></div><p class="MsoNormal" style="page-break-after: avoid;"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;">Freundliche Grüße / Best Regards</span></p><div style="page-break-after: avoid; "><span style="fon!
t-size: 10pt; font-family: "Arial","sans-serif"; color: black;"> </span><br class="webkit-block-placeholder"></div><p class="MsoNormal" style="page-break-after: avoid;"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;">Lana Saracevic</span></p><div style="page-break-after: avoid; "><span lang="EN-US" style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;"> </span><br class="webkit-block-placeholder"></div><p class="MsoNormal" style="line-height: 115%;"><b><span lang="EN-US" style="font-size: 12pt; line-height: 115%; font-family: "Arial","sans-serif"; color: rgb(0, 161, 224);">________________________</span></b><span lang="EN-US" style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";"> </span></p><p class="MsoNormal" style="line-height: 115%;"><span lang="EN-US" style="font-size: 8pt; line-height: 115%; font-fami!
ly: "Arial","sans-serif";"> <span><untitled1.2.3.gif></span></span></p><div style="line-height: 115%; "><span lang="EN-US" style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";"> </span><br class="webkit-block-placeholder"></div><p class="MsoNormal" style="line-height: 115%;"><span lang="EN-US" style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";">Bayer Technology Services GmbH</span></p><p class="MsoNormal" style="line-height: 115%;"><span lang="EN-US" style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";">BTS-ENG-CSA-HVAC</span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";">Leverkusen, B610</span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; l!
ine-height: 115%; font-family: "Arial","sans-serif";">Phone: +49 214 30 38445</span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";">Fax: +49 214 30 52774</span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";">E-mail: <u><span style="color: rgb(0, 161, 224);"><a class="moz-txt-link-abbreviated" href="mailto:lana.saracevic@bayer.com" target="_new">lana.saracevic@bayer.com</a></span></u></span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";">Web: <u><span style="color: rgb(0, 161, 224);"><a class="moz-txt-link-freetext" href="http://www.bayertechnology.com/" target="_new">http://www.bayertech!
nology.com</a></span></u></span></p><div><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif";"> </span><br class="webkit-block-placeholder"></div><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif"; color: rgb(95, 95, 95);">Geschäftsführer: Dr. Dirk Van Meirvenne</span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif"; color: rgb(95, 95, 95);">Aufsichtsratsvorsitzender: Dr. Wolfgang Plischke</span></p><p class="MsoNormal" style="line-height: 115%;"><span style="font-size: 8pt; line-height: 115%; font-family: "Arial","sans-serif"; color: rgb(95, 95, 95);">Sitz der Gesellschaft: Leverkusen | Eintragung: Amtsgericht Köln, HRB 49896</span></p><div> <br class="webkit-block-placeholder"></div></div> <pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
TRNSYS-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:TRNSYS-users@cae.wisc.edu" target="_new">TRNSYS-users@cae.wisc.edu</a>
<a class="moz-txt-link-freetext" href="https://mailman.cae.wisc.edu/listinfo/trnsys-users" target="_new">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a>
</pre> </blockquote></div> <!-- end sanitized html --> <hr size="1" noshade="noshade"><pre>_______________________________________________
TRNSYS-users mailing list
<a href="javascript:bodyCreateMail('TRNSYS-users%40cae.wisc.edu')">TRNSYS-users@cae.wisc.edu</a>
<a href="https://mailman.cae.wisc.edu/listinfo/trnsys-users" target="_blank">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a>
</pre></div></td></tr> </tbody></table></div>_______________________________________________<br>TRNSYS-users mailing list<br><a href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a><br>https://mailman.cae.wisc.edu/listinfo/trnsys-users<br></blockquote></div><br></div></div></div></body></html>