[Equest-users] automatic calculation of peak demand month for minimum qualifiers?

[James Hess]

My $0.02 on this is that I've always done this type of calc (i.e. ratchet) in Excel using data from eQuest.  It's just easier from my perspective to do in Excel (since we already had worksheets set up to do this).

However,  eQuest appears to have some capabilities in this area to model a ratchet clause in the rate tariff.  I've just never used them.

Click on the electricity rate, then go to Ratchets, then create a new one.

[cid:image006.jpg at 01CC6D4F.CDD36910]

This new ratchet shows up in the menu on the left just under the block charges.

[cid:image003.png at 01CC6D4F.CBFBE9F0]

Click on Ratchet 1 and then edit as needed to define the demand ratchet properties.

[cid:image007.jpg at 01CC6D4F.CDD36910]

It looks like you can assign a schedule to control when the ratchet is applied (i.e. June to Sep).

RATCHET-SCH
U-name for a SCHEDULE which defines the period over which the ratchet will be calculated. If not specified, the ratchet is assumed to be active all hours. This keyword is useful when one ratchet applies to winter demand, and a different ratchet to summer demand. On-peak/off-peak ratchets can also be defined. The ratcheted demand will be the maximum demand encountered during the scheduled period. If NUM-MONTHS is less than the period defined in the RATCHET-SCH, then a sliding ratchet will occur during the scheduled period. For example, assume RATCHET-SCH is defined to be active from April through October, and NUM-MONTHS is 4. If the current month is June, then the billing demand will be the maximum of the current month's peak, May's, April's, or October's.


Hope this helps!  : )

Regards,

JAH

James A. Hess, PE, CEM, BEMP
Energy Engineer
TME, Inc.
Little Rock, AR
Mobile: (501) 351-4667

From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of James Hansen
Sent: Wednesday, September 07, 2011 9:05 AM
To: equest-users at lists.onebuilding.org
Subject: [Equest-users] automatic calculation of peak demand month for minimum qualifiers?

Here in VA, Dominion Power has a commercial rate schedule (GS-3) that is primarily a demand-based rate schedule.  Energy is provided at something like 3 cents / KWH, and the demand charges are broken down into distribution and generation.

Distribution is $2.12 per the max KW measured throughout the year (in reality it is negotiated with the provider, but I'm simplifying it this way)

Generation is the peak demand of that month or 75% of the highest demand measured from June to September of the preceding 11 months.

Has anyone successfully created a user expression to do something like this?

To use the distribution as an example:  can you even perform a routine that finds the max billing demand KW for the year, or is that outside of the scope of eQuest / DOE-2?

Thanks!

GHT Limited
James Hansen, P.E., LEED AP
Senior Associate
1010 N. Glebe Road, Suite 200
Arlington, VA  22201-4749
703-243-1200 (office)
703-338-5754 (cell)
703-276-1376 (fax)
www.ghtltd.com<http://www.ghtltd.com/>

________________________________
The information contained in this communication is confidential, may be privileged, and is intended only for the use of the addressee.  It is the property of GHT Limited.  Unauthorized use, disclosure or copying of this communication or any part thereof is strictly prohibited and may be unlawful.  If you have received this communication in error, please notify me immediately by return e-mail or by e-mail to ght at ghtltd.com<mailto:ght at ghtltd.com>, and destroy this communication and all copies thereof, including all attachments.  Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110907/6b8f3946/attachment-0002.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 4271 bytes
Desc: image003.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110907/6b8f3946/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 35726 bytes
Desc: image006.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110907/6b8f3946/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 24062 bytes
Desc: image007.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110907/6b8f3946/attachment-0005.jpg>