<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<div>
<div>
<div>
<div lang="en-US">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">Thank you all for your input.</span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"> </span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">The source and regulating body we are interested in proposing this solution to is; WA Department of Commerce. Specifically Wx programs for multifamily
 buildings. We are hoping to find a solution or product already approved by DOE, has a favorable SIR formula, and is on our state approved software submittal list. EQuest is on the list, and that is why I was checking it out.<br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">The list of 15 programs is on page 10,11 of this document:<br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><span style="color:black; font-size:12pt"><a href="https://www.energy.gov/sites/prod/files/2019/04/f61/wpn-19-4-attachments.pdf">https://www.energy.gov/sites/prod/files/2019/04/f61/wpn-19-4-attachments.pdf</a></span><br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">The current software we are using, TREAT, uses this formula for SIR, taking the
<i>time value of money</i> into account. WA Department of Commerce may be choosing a software product to replace TREAT.<br>
</span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"> </span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">here is the formula:</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><img size="57265" contenttype="image/jpeg" style="max-width: 100%; user-select: none;" unselectable="on" tabindex="-1" data-outlook-trace="F:1|T:1" src="cid:f043942a-d7f9-48ca-abe3-bc8ce9726749"><br>
</span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"></span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">This gives us funding amounts for measures that work well. When I use the eQuest SIR formula, the funding result is about one tenth of the same measure
 in TREAT.</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">Is it possible that the built-in LCI featuresetj
<span style="color:black; font-size:12pt">mentioned</span> (or a version of it) are DOE approved? and eQuest might, if used in the correct manor would work?<br>
</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
Do you know a program or existing Excel spreadsheet in use that will take eQuest CSV import, has a similar SIR to the TREAT formula, and might already approved by DOE?</div>
<div><br>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt">We would like to find an approved program because, at this time we can not invest ourselves in writing it and then work on getting it approved.<br>
</span></p>
</div>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
</div>
We could e<span style="font-size:12pt">xport the CSV file to LCCA spreadsheet (DOE2) if there is an approved SIR formula in existence.<br>
</span>
<div>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0"><span style="color:black; font-size:12pt"><br>
</span></p>
</div>
</div>
<div>Thanks again,<br>
</div>
<div>
<p><span style="color:black"> </span></p>
<p><span style="color:black"><img size="0" contenttype="image/png" style="max-width: 100%; user-select: none;" unselectable="on" tabindex="-1" data-outlook-trace="F:1|T:1" src="cid:768905a3-eaf5-4ec0-aa51-580cd026fed3">Daniel Boyle<br>
Property Weatherization & Rehabilitation Specialist</span><span style="color:black; font-size:10pt"><br>
</span><span style="color:black">City of Seattle, <a href="http://www.seattle.gov/housing" target="_blank" rel="noopener noreferrer">
Office of Housing</a>, HomeWise Program<br>
PO Box 94725, Seattle, WA  98124-4725</span></p>
<p><span style="color:black">O: 206.684.0237 | F: 206.233.7117 | </span><u><span style="color:blue"><a href="mailto:daniel.boyle@seattle.gov" target="_blank" rel="noopener noreferrer">daniel.boyle@seattle.gov</a></span></u></p>
<p><span style="color:black"><a href="http://www.seattle.gov/housing/housing-developers/multifamily-weatherization" target="_blank" rel="noopener noreferrer">http://www.seattle.gov/housing/housing-developers/multifamily-weatherization</a></span></p>
<p><span style="color:black"><a href="http://www.seattlecensus.org/" target="_blank" rel="noopener noreferrer"><span><img size="0" contenttype="image/png" style="max-width: 100%; user-select: none;" unselectable="on" tabindex="-1" data-outlook-trace="F:1|T:1" src="cid:7f389f2f-e1f0-42c1-bf5e-d29eb7667c97"></span></a></span></p>
<p><b><span style="color:black; font-size:10pt; font-family:Arial,sans-serif; letter-spacing:.2pt">  
<a href="http://www.seattlecensus.org/faq/" target="_blank" rel="noopener noreferrer">
FAQS</a>  | <a href="http://www.seattlecensus.org/blog/" target="_blank" rel="noopener noreferrer">
BLOG</a></span></b></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> David Eldridge <DEldridge@grummanbutkus.com><br>
<b>Sent:</b> Saturday, March 21, 2020 11:21 AM<br>
<b>To:</b> Nicholas Caton <Nicholas.Caton@se.com>; Boyle, Daniel <Daniel.Boyle@seattle.gov>; equest-users@onebuilding.org <equest-users@onebuilding.org><br>
<b>Subject:</b> RE: new user SIR and funding inquiry</font>
<div> </div>
</div>
<style>
<!--
@font-face
        {font-family:"Cambria Math"}
@font-face
        {font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
        {color:#0563C1;
        text-decoration:underline}
span.x_EmailStyle21
        {font-family:"Calibri",sans-serif;
        color:windowtext}
.x_MsoChpDefault
        {font-size:10.0pt}
@page WordSection1
        {margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
        {}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div style="background-color:#ffeb9c; width:180px; padding:2pt; font-size:10pt; font-weight:bold; line-height:12pt; font-family:'Calibri'; color:#9c6500; text-align:center; border:1pt solid #9C6500">
CAUTION: External Email</div>
<div>
<div class="x_WordSection1">
<p class="x_MsoNormal">I agree Nick, I had always used Excel for these functions (including a LCCA spreadsheet supplied on the DOE2 website) rather than the built-in functions. The flexibility and transparency is much higher. Even if “accurate” I don’t prefer
 the black box calculation in general. Same thing for BLCC program – I’d rather use a spreadsheet to do the same thing according to the NIST method in Handbook 135.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">David</p>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><b><span style="color:#1F497D">David S. Eldridge, Jr.</span></b><b><span style="color:#244061">, P</span></b><b><span style="color:#1F497D">.</span></b><b><span style="color:#244061">E</span></b><b><span style="color:#1F497D">.</span></b><b><span style="color:#244061">,
 BEMP, BEAP, HBDP, GGA</span></b></p>
<p class="x_MsoNormal"><span style="color:#1F497D">Associate</span></p>
<p class="x_MsoNormal"><span style="font-size:4.0pt; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><span style="color:#365F91">Direct: (847) 316-92</span><span style="color:#1F497D">24</span><span style="color:#365F91"> | Mobile: (</span><span style="color:#1F497D">773</span><span style="color:#365F91">)
</span><span style="color:#1F497D">490</span><span style="color:#365F91">-</span><span style="color:#1F497D">5038</span></p>
<p class="x_MsoNormal"><span style="font-size:10.0pt; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><b><span style="color:#244061">Grumman/Butkus Associates</span></b><span style="color:gray">
</span><span style="color:#365F91">| 820 Davis Street, Suite 300 | Evanston, IL 60201</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; color:gray">Energy Efficiency Consultants and Sustainable Design Engineers</span></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><u><span style="font-size:9.0pt; color:gray"><a href="http://grummanbutkus.com/"><span style="color:gray">grummanbutkus.com</span></a></span></u><span style="font-size:9.0pt; color:gray"> |
<u><a href="http://grummanbutkus.com/blog"><span style="color:gray">Blog</span></a></u> |
<u><a href="https://www.facebook.com/pages/GrummanButkus-Associates/1385285015032526"><span style="color:gray">Facebook</span></a></u> |
<u><a href="https://twitter.com/grummanbutkus"><span style="color:gray">Twitter</span></a></u></span></p>
</div>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> Equest-users <equest-users-bounces@lists.onebuilding.org>
<b>On Behalf Of </b>Nicholas Caton via Equest-users<br>
<b>Sent:</b> Saturday, March 21, 2020 11:00 AM<br>
<b>To:</b> Boyle, Daniel <Daniel.Boyle@seattle.gov><br>
<b>Cc:</b> equest-users@lists.onebuilding.org<br>
<b>Subject:</b> Re: [Equest-users] new user SIR and funding inquiry</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_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. 
</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Regards,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">~Nick </p>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="font-family:"Arial",sans-serif; color:#3A7A46"><img border="0" width="624" height="8" id="x_Picture_x0020_1" style="width:6.5in; height:.0833in" data-outlook-trace="F:1|T:1" src="cid:image001.jpg@01D5FF83.8FD0EB90"></span></p>
<p class="x_MsoNormal"><b><span style="font-family:"Arial",sans-serif; color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="color:#3A7A46"></span></p>
<table class="x_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="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">  Senior Energy Engineer</span></p>
<p class="x_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"></span></p>
</td>
<td width="16" valign="top" style="width:11.8pt; padding:0in 0in 0in 0in">
<p class="x_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">
</span></p>
</td>
<td width="275" valign="top" style="width:206.5pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">913 . 564 . 6361</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">785 . 410 . 3317</span></p>
<p class="x_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"></span></p>
</td>
<td width="203" valign="top" style="width:152.4pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal" align="right" style="margin-bottom:12.0pt; 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</span><span style="font-size:9.0pt; color:#1F497D"></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="x_MsoNormal" style=""><span style="color:#3A7A46"><img border="0" width="722" height="49" id="x_Picture_x0020_2" style="width:7.5208in; height:.5104in" data-outlook-trace="F:1|T:1" src="cid:image002.png@01D5FF83.8FD0EB90"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"> </p>
</div>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> Equest-users <<a href="mailto:equest-users-bounces@lists.onebuilding.org">equest-users-bounces@lists.onebuilding.org</a>>
<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> <a href="mailto:equest-users@lists.onebuilding.org">equest-users@lists.onebuilding.org</a><br>
<b>Subject:</b> [Equest-users] new user SIR and funding inquiry</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p><span style="color:red">[External email: Use caution with links and attachments]</span></p>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p> </p>
<div>
<div>
<div>
<p class="x_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.</span></p>
</div>
<div>
<p class="x_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.
</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_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.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_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.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_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?</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_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.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Thanks,</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Daniel Boyle</span></p>
</div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<p class="x_MsoNormal"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________</p>
</div>
</div>
</div>
</div>
</body>
</html>