[Equest-users] Demand Rate Modeling in Mexico

Tue Oct 4 16:22:43 PDT 2016

I will be out of the office Oct 1-Oct 9 with very limited email opportunities. I should have text available at 843-469-5111.

Otherwise, I will respond to your emails as soon as possible upon my return.

On Oct 2, 2016, at 2:19 PM, Nick Caton via Equest-users <equest-users at lists.onebuilding.org> wrote:

> Hi Coles – that is a tricky one!
>  
> It’s been awhile since I’ve revisited the capabilities of the DD wizards for handling complex rate structures, and I’m pleasantly surprised to find some improvements in the native capabilities.  (screengrabs follow).  That is in fact a pretty wacky structure from my personal experience, but while it appears you can define/map up to 5 billing periods per day and then assign those to specific week days / holidays, I don’t think you can do monthly maximum checks between each period to accurately determine billable demand within the eQUEST interface – some degree of post-processing seems unavoidable to me.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1111 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0010.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unknown.png
Type: image/png
Size: 24399 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unknown.png
Type: image/png
Size: 25452 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0011.png>
-------------- next part --------------
> 
>  
> 2 major thoughts:
> 1.       If it were me, I’d still keep an eye/ear out for a more promising contribution/reply, but in the meantime I’d just push forward with post processing your hourly outputs with excel to determine costs.  If you’ve done this before, this oddball formula doesn’t pose a terribly difficult challenge to implement (all the needed hourly outputs & month/day/hour flags are conveniently packaged in the default “… - Hourly Results.csv” reporting block borne from wizard-generated projects).  Since I’ve moved into the performance contracting world (and had to puzzle with with getting complex rate tariffs *right* on the regular) – I’ve come to embrace, even enjoy, the absolute flexibility that comes with determining costs outside of the eQUEST, even with the relative pains that come with needing to use a separate process to figure out where the dollars/cents lie during development. 
> 2.       On close inspection of that formula I notice something interesting… for each month:
> if(The peak peak demand > the peak interim demand)  .AND. (peak interim demand > peak base demand))
>   then the billable demand is simply the monthly peak (i.e. the rest of the formula zeroes itself out)!
>   else see major thought #1 above – it was worth a check =(
> endif
>  
> You might set up a couple checks for this at the top of whatever spreadsheet you use to number-crunch the hourly results.  If the above checks both turn out to be true for each month, you can simply use the eQuest’s native monthly peaks/costs as reported as the billable demand, using a very simple single-TOU demand rate structure.
> 
> Best of luck – I hope you’ll consider sharing whatever approach you land on (and everyone else dealing with Mexico)!  If there’s a trick to be learned to handle this within eQUEST or commandline doe2, I’m certainly all ears!
>  
> ~Nick
>  
>  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 4524 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0011.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unknown.png
Type: image/png
Size: 255 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0012.png>
-------------- next part --------------
> 
> Nick Caton, P.E.
>   Senior Energy Engineer
>   Energy and Sustainability Services
>   Schneider Electric
> D  913.564.6361 
> M  785.410.3317 
> E  nicholas.caton at schneider-electric.com
> F  913.564.6380
> 15200 Santa Fe Trail Drive
> Suite 204
> Lenexa, KS 66219
> United States
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 2943 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0012.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unknown.png
Type: image/png
Size: 7893 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0013.png>
-------------- next part --------------
> 
>  
>  
> From: Equest-users [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Coles Jennings via Equest-users
> Sent: Thursday, September 29, 2016 2:38 PM
> To: equest-users at lists.onebuilding.org
> Subject: [Equest-users] Demand Rate Modeling in Mexico
>  
> Hello all,
>  
> I am trying to accurately model a tricky demand structure for a project in Mexico. The utility uses a complex way to bill demand (see item 7 in link here: http://app.cfe.gob.mx/Aplicaciones/CCFE/Tarifas/Tarifas/tarifas_negocio.asp?Tarifa=HM). Here’s a snip of the translated text:
>  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1267 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0013.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: unknown.png
Type: image/png
Size: 38165 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0014.png>
-------------- next part --------------
> 
> (In the table above, the middle column is FRI and the right column is FRB)
>  
> In summary, the day is broken into three periods (peak, intermediate, and base). Demand charges are in three parts, summed together for the total charge for the month:
>  
> 1.       They charge for the max kW within the peak period
> 2.       For the intermediate period, you are charged for the difference between the peak period demand and the intermediate period demand, times a reduction factor of 30%. 
> 3.       For the base period, you are charged for the demand of the base period less the max demand of the peak and intermediate periods, times a reduction factor of 15%.
>  
> I’m sure I’m not the first to stare at this rate structure and scratch my head as to how to model in eQUEST, since it applies nationally in Mexico. Has anyone had luck modeling a demand rate like this? I’m able to model time-of-day demand, but am struggling for a way to subtract the demands from each other to get accurate values for intermediate and base period charges.
>  
> Post-processing in Excel is always an option, but not desired.
>  
> Thanks,
> 
> Coles Jennings, PE, BEMP, LEED AP BD+C 
> Sr. Energy Engineer, Building Sciences Manager | Mason & Hanger (formerly Hankins & Anderson) 
> A Day & Zimmermann Company 
> D 804.521.7045 | O 804.285.4171 | F 804.217.8520 
> 4880 Sadler Road, Suite 300 | Glen Allen, VA 23060 
> ha-inc.com (soon to be masonandhanger.com) 
> We do what we say.® 
> 
>   
> 
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> ______________________________________________________________________
> 
> This message was scanned by Exchange Online Protection Services.
> 
> _______________________________________________
> Equest-users mailing list
> http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org
> To unsubscribe from this mailing list send  a blank message to EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 5439 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161004/6de21cd8/attachment-0014.bin>