[Equest-users] new user SIR and funding inquiry

Boyle, Daniel Daniel.Boyle at seattle.gov
Mon Mar 23 16:55:23 PDT 2020

Thank you all for your input.

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.

The list of 15 programs is on page 10,11 of this document:


The current software we are using, TREAT, uses this formula for SIR, taking the time value of money into account. WA Department of Commerce may be choosing a software product to replace TREAT.

here is the formula:


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.

Is it possible that the built-in LCI featuresetj mentioned (or a version of it) are DOE approved? and eQuest might, if used in the correct manor would work?

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?

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.

We could export the CSV file to LCCA spreadsheet (DOE2) if there is an approved SIR formula in existence.

Thanks again,

[cid:768905a3-eaf5-4ec0-aa51-580cd026fed3]Daniel Boyle
Property Weatherization & Rehabilitation Specialist
City of Seattle, Office of Housing<http://www.seattle.gov/housing>, HomeWise Program
PO Box 94725, Seattle, WA  98124-4725

O: 206.684.0237 | F: 206.233.7117 | daniel.boyle at seattle.gov<mailto:daniel.boyle at seattle.gov>



   FAQS<http://www.seattlecensus.org/faq/>  | BLOG<http://www.seattlecensus.org/blog/>

From: David Eldridge <DEldridge at grummanbutkus.com>
Sent: Saturday, March 21, 2020 11:21 AM
To: Nicholas Caton <Nicholas.Caton at se.com>; Boyle, Daniel <Daniel.Boyle at seattle.gov>; equest-users at onebuilding.org <equest-users at onebuilding.org>
Subject: RE: new user SIR and funding inquiry

CAUTION: External Email

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.


David S. Eldridge, Jr., P.E., BEMP, BEAP, HBDP, GGA


Direct: (847) 316-9224 | Mobile: (773) 490-5038

Grumman/Butkus Associates | 820 Davis Street, Suite 300 | Evanston, IL 60201

Energy Efficiency Consultants and Sustainable Design Engineers

grummanbutkus.com<http://grummanbutkus.com/> | Blog<http://grummanbutkus.com/blog> | Facebook<https://www.facebook.com/pages/GrummanButkus-Associates/1385285015032526> | Twitter<https://twitter.com/grummanbutkus>

From: Equest-users <equest-users-bounces at lists.onebuilding.org> On Behalf Of Nicholas Caton via Equest-users
Sent: Saturday, March 21, 2020 11:00 AM
To: Boyle, Daniel <Daniel.Boyle at seattle.gov>
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] new user SIR and funding inquiry

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.

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.

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.



[cid:image001.jpg at 01D5FF83.8FD0EB90]

Nick Caton, P.E., BEMP

  Senior Energy Engineer

  Energy and Sustainability Services
  Energy Performance Contracting


913 . 564 . 6361

785 . 410 . 3317

nicholas.caton at se.com<mailto:nicholas.caton at se.com>

15200 Santa Fe Trail Drive
Suite 204
Lenexa, KS 66219

[cid:image002.png at 01D5FF83.8FD0EB90]

From: Equest-users <equest-users-bounces at lists.onebuilding.org<mailto:equest-users-bounces at lists.onebuilding.org>> On Behalf Of Boyle, Daniel via Equest-users
Sent: Wednesday, March 18, 2020 5:50 PM
To: equest-users at lists.onebuilding.org<mailto:equest-users at lists.onebuilding.org>
Subject: [Equest-users] new user SIR and funding inquiry

[External email: Use caution with links and attachments]


Hello, I am a new user who is trying out the software (eQuest) as a possible weatherization program tool.

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.

My first task after doing some basic modeling is to try out the SIR calculation in the financial tools.

The SIR calculation in eQuest is completely different than the SIR calculation in our current software which is accepted by our funding sources.

Is there any overlay, plug-in, script, or similar that might allow for different financial formulas to be inserted into the program?

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.


Daniel Boyle

This email has been scanned by the Symantec Email Security.cloud service.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20200323/6cab3d9f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1794 bytes
Desc: image001.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20200323/6cab3d9f/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 8477 bytes
Desc: image002.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20200323/6cab3d9f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-0mlzl45t.png
Type: image/png
Size: 138777 bytes
Desc: Outlook-0mlzl45t.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20200323/6cab3d9f/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-jusur4v3.png
Type: image/png
Size: 4359 bytes
Desc: Outlook-jusur4v3.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20200323/6cab3d9f/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-ieygez12.png
Type: image/png
Size: 22720 bytes
Desc: Outlook-ieygez12.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20200323/6cab3d9f/attachment-0003.png>

More information about the Equest-users mailing list