<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>Mike:</DIV>
<DIV> </DIV>
<DIV>That spreadsheet came from me via an "Unimpeachable source". You run eQuest, extract the "cut and paste" from the .CSV file created in .sim file and compare it to actual utility data. You NEVER can input utility data directly into eQuest and expect it to disseminate (sp?) electricity, for example, into lights, plug lod, space cooling, etc.</DIV>
<DIV> </DIV>
<DIV>BTW, the spreadsheet has an interesting feature in that you can put a multiplier into the spreadsheet to see what elements in your model may need "tweaking" in order to match your bills.</DIV>
<DIV> </DIV>
<DIV>Unfortunately, I do not have a tool whereas you can input actual weather from that year and modify the model to match the real weather (a competing program DOES).</DIV>
<DIV> </DIV>
<DIV><BR>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><A name=_MailAutoSig><SPAN style="COLOR: #1f497d; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><FONT face=Calibri>John R. Aulbach, PE, CEM<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></SPAN></A></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="COLOR: #1f497d; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><FONT face=Calibri>Senior Energy Engineer<o:p></o:p></FONT></SPAN></SPAN></P>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="COLOR: #17365d; mso-fareast-font-family: 'Times New Roman'; mso-no-proof: yes"><FONT face=Calibri>
<HR style="COLOR: #17365d" align=left SIZE=2 width="30%" noShade>
</FONT></SPAN></SPAN></DIV>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><FONT face=Calibri><SPAN style="mso-bookmark: _MailAutoSig"><B><SPAN style="FONT-VARIANT: small-caps; COLOR: navy; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">Partner</SPAN></B></SPAN><SPAN style="mso-bookmark: _MailAutoSig"><B><SPAN style="FONT-VARIANT: small-caps; COLOR: green; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"> </SPAN></B></SPAN><SPAN style="mso-bookmark: _MailAutoSig"><B><SPAN style="FONT-VARIANT: small-caps; COLOR: #006600; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">Energy</SPAN><SPAN style="FONT-VARIANT: small-caps; COLOR: navy; mso-no-proof: yes"><o:p></o:p></SPAN></B></SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="COLOR: #1f497d; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><FONT face=Calibri>1990 E. Grand Avenue, El Segundo, CA 90245<BR>W: 888-826-1216, X254| D: 310-765-7295 | F: 310-817-2745<o:p></o:p></FONT></SPAN></SPAN></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="mso-bookmark: _MailAutoSig"></SPAN><A href="http://www.ptrenergy.com/"><FONT color=#0000ff><FONT face=Calibri><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">www.ptrenergy.com</SPAN></SPAN><SPAN style="mso-bookmark: _MailAutoSig"></SPAN></FONT></FONT></A><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="COLOR: #1f497d; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><FONT face=Calibri> </FONT></SPAN></SPAN><A href="mailto:%7C%20jaulbach@ptrenergy.com"><FONT color=#0000ff><FONT face=Calibri><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">| jaulbach@ptrenergy.com</SPAN></SPAN><SPAN style="mso-bookmark:
_MailAutoSig"></SPAN></FONT></FONT></A><SPAN style="mso-bookmark: _MailAutoSig"><SPAN style="COLOR: #1f497d; mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><o:p></o:p></SPAN></SPAN></P><SPAN style="mso-bookmark: _MailAutoSig"></SPAN>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="mso-fareast-font-family: 'Times New Roman'; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><o:p><FONT face=Calibri> </FONT></o:p></SPAN></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoNormal><o:p><FONT face=Calibri> </FONT></o:p></P></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<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> mike steadman <steadys@charter.net><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> equest-users@lists.onebuilding.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wed, June 29, 2011 7:10:41 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Equest-users] Actual vs model- utiltiys<BR></FONT><BR>
<STYLE></STYLE>
<DIV><FONT size=2 face=Arial>Ok, </FONT></DIV>
<DIV><FONT size=2 face=Arial>here is my stupid question-I deleted my equest box with some great answers</FONT></DIV>
<DIV><BR><FONT size=2 face=Arial>Some one sent me this wonderful spreadsheet about utilitys-thank you</FONT></DIV>
<DIV><FONT size=2 face=Arial>yet I am cloudy on what the answer really means for inputting actual utilty use into my model.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Is that even done with equest and if so, where in the process can you do it, Schematic wizard.? DD wizard?</FONT></DIV>
<DIV><FONT size=2 face=Arial>I see rates for block, demand , yet nothing for inputting the exact amount of therms or KWH in each month with usage numbers, I have built my model and saved in DD mode so editing the utilty use from the component tree seems to not work?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>My memory with this attached spreadsheet - I would run my building simulation and save to a sheet like this and then revise to current usage and somehow upload back into my model. WoW.!!</FONT></DIV>
<DIV><FONT size=2 face=Arial>Can anybody help with that process</FONT></DIV>
<DIV><FONT size=2 face=Arial>Thanks in advance</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Mike S</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Energy Manager</FONT></DIV>
<DIV><FONT size=2 face=Arial>ABI Mechanical</FONT></DIV>
<DIV><FONT size=2 face=Arial>Traverse City Michigan 49685</FONT></DIV>
<DIV><FONT size=2 face=Arial>231-943-4114 ext 250</FONT></DIV>
<DIV><FONT size=2 face=Arial><A href="mailto:msteadman@abimechanical.com" rel=nofollow target=_blank ymailto="mailto:msteadman@abimechanical.com">msteadman@abimechanical.com</A></FONT></DIV></DIV></DIV></div></body></html>