[Equest-users] new user SIR and funding inquiry

[David Eldridge]

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


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

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.


Regards,

~Nick

[cid:image001.jpg at 01D5FF83.8FD0EB90]
Nick Caton, P.E., BEMP
  Senior Energy Engineer
  Energy and Sustainability Services
  Energy Performance Contracting
D
M
E

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.

Thanks,
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/20200321/ca4fbd49/attachment.htm>
-------------- 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/20200321/ca4fbd49/attachment-0002.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/20200321/ca4fbd49/attachment-0002.png>