[Equest-users] Actual vs model- utiltiys

[Nick Caton]

Hi Mike,

 

Take a closer look at the tabs along the bottom of the attached worksheet:

 

Paste EG_MoEU.CSV Here  ß do what it says.  The CSV file is generated when you run a simulation in the same directory as your other project files, and can also be opened in excel.

Input Utility Data Here  ß Revise the colored cells to match your records

Graphs ß Here you'll find your model's energy consumptions/demands plotted against your utility data.  Some "multiplier" cells on that sheet help you visualize the impact of varying the different consumption types, which is occasionally useful  for determining what might attention while fine-tuning a model.

 

After doing this once, you simply paste the new CSV any time you want to check against your utility data.

 

~Nick

 

 

NICK CATON, P.E.

SENIOR ENGINEER

 

Smith & Boucher Engineers

25501 west valley parkway, suite 200

olathe, ks 66061

direct 913.344.0036

fax 913.345.0617

www.smithboucher.com 

 

From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of mike steadman
Sent: Wednesday, June 29, 2011 9:11 AM
To: equest-users at lists.onebuilding.org
Subject: [Equest-users] Actual vs model- utiltiys

 

Ok, 

here is my stupid question-I deleted my equest box with some great answers


Some one sent me this wonderful spreadsheet about utilitys-thank you

yet  I am cloudy on what the answer really means for inputting actual utilty use into my model.

 

Is that even done with equest and if so, where in the process can you do it, Schematic wizard.? DD wizard?

I see rates for block, demand , yet nothing for inputting the exact amount of therms or KWH in each month with usage numbers, I have built my model and saved in DD mode so editing the utilty use from the component tree seems to not work?

 

My memory with this attached spreadsheet - I would run my building simulation and save to a sheet like this and then revise to current usage and somehow upload back into my model. WoW.!!

Can anybody help with that process

Thanks in advance

 

Mike S

 

Energy Manager

ABI Mechanical

Traverse City Michigan 49685

231-943-4114 ext 250

msteadman at abimechanical.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110629/a5831027/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1459 bytes
Desc: image001.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110629/a5831027/attachment.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 4 - 181-185 Bill Matching vs. eQuest.xls
Type: application/vnd.ms-excel
Size: 156160 bytes
Desc: 4 - 181-185 Bill Matching vs. eQuest.xls
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110629/a5831027/attachment.xls>