<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.18854"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial>I'll have to look some more at the spreadsheet from the
"unimpeachable" source.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial>You might also find the following useful. Look at
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.cacx.org/resources/rcxtools/spreadsheet_tools.html">http://www.cacx.org/resources/rcxtools/spreadsheet_tools.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial>and scroll down until you reach "Utility Consumption Analysis
Tool." It allows you to enter the utility data in any order, and works
whether you have 0, 1, or 2 bills in a given month.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial>A side note: ECAM, mentioned on the same page, will be
improved and updated to Excel 2007 in early 2010.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=390594600-24122009>
<DIV align=left><FONT size=2 face=Tahoma>William E. Koran, P.E.</FONT></DIV>
<DIV align=left><FONT size=2 face=Tahoma>Senior Engineer</FONT></DIV>
<DIV align=left><FONT face=Tahoma>Q u E S T</FONT></DIV>
<DIV align=left><FONT size=1 face=Tahoma>Quantum Energy Services and
Technologies</FONT></DIV>
<DIV align=left><FONT size=2><FONT face=Tahoma>Web: </FONT><A
title=blocked::http://www.quest-world.com/
href="http://www.quest-world.com/"><FONT
title=blocked::http://www.quest-world.com/
face=Tahoma>www.quest-world.com</FONT></A></FONT></DIV></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> equest-users-bounces@lists.onebuilding.org
[mailto:equest-users-bounces@lists.onebuilding.org] <B>On Behalf Of </B>John
Aulbach<BR><B>Sent:</B> Wednesday, December 23, 2009 3:43 PM<BR><B>To:</B>
Jonathan Curtin; Fisher, Damon;
equest-users@lists.onebuilding.org<BR><B>Subject:</B> Re: [Equest-users]
Matching Utility bills<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV
style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV>Here is something I picked up from an "unimpeachable" source. Put your own
PS-E in the first Tab, and your billing data with the days in the 3rd Tab.</DIV>
<DIV> </DIV>
<DIV>Merry Christmas to all !!<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> Jonathan Curtin
<jcurtin@WylieAssociates.com><BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> "Fisher, Damon"
<Damon.Fisher@avistacorp.com>;
equest-users@lists.onebuilding.org<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thu, December 17, 2009 8:23:29
AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [Equest-users]
Matching Utility bills<BR></FONT><BR>
<STYLE>UNKNOWN {
FONT-FAMILY: Calibri
}
UNKNOWN {
MARGIN: 1in
}
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri", "sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri", "sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri", "sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri", "sans-serif"; COLOR: windowtext
}
SPAN.SpellE {
}
SPAN.GramE {
}
MsoChpDefault {
}
DIV.Section1 {
}
</STYLE>
<DIV dir=ltr align=left><SPAN class=499292116-17122009><FONT size=2
face=Arial>Damon,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=499292116-17122009><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=499292116-17122009><FONT size=2
face=Arial>You can look at the hourly reports of kW and gas (export to
Excel) and break it up on your own to match that of your actual billing
periods.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=499292116-17122009><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=499292116-17122009><FONT size=2
face=Arial>Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=499292116-17122009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=499292116-17122009>
<DIV class=Section1>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'GillSans Light'"><SPAN>
</SPAN></SPAN></B><B><SPAN
style="FONT-FAMILY: 'GillSans Light'; COLOR: #4d4d4d">Jonathan M. Curtin, EIT,
LEED</SPAN></B><SUP><SPAN
style="FONT-FAMILY: 'GillSans Light'">®</SPAN></SUP><B><SPAN
style="FONT-FAMILY: 'GillSans Light'; COLOR: #4d4d4d"> AP</SPAN></B><B><SPAN
style="FONT-FAMILY: 'GillSans Light'; COLOR: #4d4d4d"><BR></SPAN></B><B><SPAN
style="FONT-FAMILY: 'GillSans Light'; COLOR: #4d4d4d"><SPAN>
</SPAN></SPAN></B><B><SPAN
style="FONT-FAMILY: 'GillSans Light'; COLOR: #4d4d4d">Mechanical
Engineer</SPAN></B><STRONG><SPAN
style="FONT-FAMILY: 'GillSans Light'"></SPAN></STRONG></P>
<P class=MsoNormal><STRONG><SPAN
style="FONT-FAMILY: 'GillSans Light'"><SPAN></SPAN></SPAN></STRONG> </P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'GillSans Light'"><IMG
src="cid:390594600@24122009-0CDF" width=240
height=159><STRONG></STRONG></SPAN></B></P></DIV></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> equest-users-bounces@lists.onebuilding.org
[mailto:equest-users-bounces@lists.onebuilding.org] <B>On Behalf Of </B>Fisher,
Damon<BR><B>Sent:</B> Thursday, December 17, 2009 10:19 AM<BR><B>To:</B>
equest-users@lists.onebuilding.org<BR><B>Subject:</B> [Equest-users] Matching
Utility bills<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal>When calibrating a model is there any way to match the
reports to the actual billing period?<SPAN> </SPAN>Some billing periods
are 34 days some are 28 days and they never match a calendar month (reads in the
middle of the month etc.). <SPAN> </SPAN>It seems like this would be
required functionality for retrofits.<SPAN> </SPAN>I am not kind of
stumped.<SPAN> </SPAN>Thanks.</P>
<P class=MsoNormal>Damon <SPAN> </SPAN></P></DIV>
<DIV><SPAN class=469015015-07012009><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=469015015-07012009>
<DIV style="TEXT-ALIGN: center; MARGIN: 0in 0in 0pt" class=MsoNormal
align=center>
<HR align=center SIZE=2 width="100%">
</DIV><FONT color=#000000><U><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 7.5pt">Legal Disclaimer:</SPAN></U><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 7.5pt"> </SPAN><STRONG><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 7.5pt; FONT-WEIGHT: normal">The
information contained in this communication is confidential and is
</SPAN></STRONG><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 7.5pt">covered by
the Electronic Communications Privacy Act, 18 U.S.C. §§ 2510-2521; it
</SPAN><STRONG><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 7.5pt; FONT-WEIGHT: normal">may be
privileged and is intended for the exclusive use of the above named
addressee(s). If you are not the intended recipient(s), you are expressly
prohibited from copying, distributing, disseminating, or in any other way using
any of the information contained within this communication. If you have received
this communication in error, please contact the sender by telephone at
(713) 781-2526 or by response via email and permanently delete the original
email (including attachments) and any copies. </SPAN></STRONG><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 7.5pt"> <BR><BR><SPAN
style="FONT-FAMILY: Arial; COLOR: #007213; FONT-SIZE: 6.5pt">Please consider the
environment before printing this email.</SPAN></SPAN></FONT></SPAN><B><SPAN
style="FONT-FAMILY: 'GillSans Light'; FONT-SIZE: 11pt"> <SPAN>
</SPAN></SPAN></B><B><SPAN><BR></SPAN></B></DIV></DIV></DIV><!-- cg19.c2.mail.re1.yahoo.com compressed/chunked Wed Dec 23 15:13:17 PST 2009 --></DIV><BR></BODY></HTML>