<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Yu Gothic";
panose-1:2 11 4 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@Yu Gothic";
panose-1:2 11 4 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">The group I work with has an arsenal of excel-based templates used to perform financial analyses of these sorts directly off of eQuest-generated outputs (proprietary, sorry). While I can’t share these with outside parties, I can assert
they aren’t that hard to make if you have a real business need to develop something for repeated use. There isn’t any particularly special programming or economic analysis knowledge required to hook eQuest outputs into Excel, but as a key tip you can open
up the hourly results of any simulation or parametric run by pointing Excel towards the .hsr file generated with any baseline or parametric run. That can be opened as a CSV file, and from there you have all of your savings down to an hourly interval to work
from.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">That said, it might be easier/faster to develop a workflow process leveraging the built-in LCI featuresetj. It has been some time since I explored that, but IIRC this does allow you to arrive at a robustly determined present value for
savings over a specified period, right? That would represent the bulk of the effort in arriving at an savings investment ratio.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">You might get some more locality/task-specific advice from other eQuest users if you can identify the “funding sources” you’re trying to comply with.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">~Nick <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><img width="624" height="8" style="width:6.5in;height:.0833in" id="Picture_x0020_1" src="cid:image002.jpg@01D5FF6F.D4225450"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="color:#3A7A46"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="724" style="width:543.0pt;border-collapse:collapse">
<tbody>
<tr>
<td width="230" valign="top" style="width:172.3pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469"> Senior Energy Engineer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:4.5pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469"> Energy and Sustainability Services</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469"> Energy Performance Contracting
</span><span style="font-size:9.0pt;color:#1F497D"><o:p></o:p></span></p>
</td>
<td width="16" valign="top" style="width:11.8pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#57B069">D </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#57B069">M </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#57B069">E </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#57B069"> </span><span style="font-size:9.0pt;color:#1F497D">
<o:p></o:p></span></p>
</td>
<td width="275" valign="top" style="width:206.5pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6361<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">785 . 410 . 3317<o:p></o:p></span></p>
<p class="MsoNormal"><u><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469"><a href="mailto:nicholas.caton@se.com"><span style="font-family:"Calibri",sans-serif;color:#626469">nicholas.caton@se.com</span></a></span></u><span style="font-size:9.0pt;color:#1F497D"><o:p></o:p></span></p>
</td>
<td width="203" valign="top" style="width:152.4pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">15200 Santa Fe Trail Drive<br>
Suite 204<br>
Lenexa, KS 66219<br>
<br>
</span><span style="font-size:9.0pt;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:4.0pt">
<td width="724" colspan="4" valign="top" style="width:543.0pt;padding:0in 0in 0in 0in;height:4.0pt">
<p class="MsoNormal" style="mso-line-height-alt:4.0pt"><span style="color:#3A7A46"><img border="0" width="722" height="49" style="width:7.5208in;height:.5104in" id="Picture_x0020_2" src="cid:image003.png@01D5FF6E.2FF0BFD0"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Equest-users <equest-users-bounces@lists.onebuilding.org>
<b>On Behalf Of </b>Boyle, Daniel via Equest-users<br>
<b>Sent:</b> Wednesday, March 18, 2020 5:50 PM<br>
<b>To:</b> equest-users@lists.onebuilding.org<br>
<b>Subject:</b> [Equest-users] new user SIR and funding inquiry<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span style="color:red">[External email: Use caution with links and attachments]</span><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p> <o:p></o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Hello, I am a new user who is trying out the software (eQuest) as a possible weatherization program tool.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I have signed up to the user group but have not received my confirmation e-mail yet. I have been getting familiar with eQuest for about a total of 20 hours.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">My first task after doing some basic modeling is to try out the SIR calculation in the financial tools.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">The SIR calculation in eQuest is completely different than the SIR calculation in our current software which is accepted by our funding sources.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Is there any overlay, plug-in, script, or similar that might allow for different financial formulas to be inserted into the program?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Anyone with any ideas, leads on where to look, or organizations to contact, about modifying, proposing or implementing equest into government program guidelines would be fantastic.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Thanks,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Daniel Boyle<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________<o:p></o:p></p>
</div>
</div>
</body>
</html>