Rate custom option list

Rates

Use a custom option to activate special billing functionality. The options in this list will change how Connect calculates a rate.

If you need assistance, please contact customer service at (800) 243-8275 for more information.

Use a custom formula to create your own billing calculation. You can write a formula in the Calculation field. Click the Modify button to open the Formula Designer. The Formula Designer provides you with a list of available operators, variables, and an option to check the formula syntax (the code in the formula) for errors. Here are some examples of formulas.

Examples

This custom billing calculation is similar to rate custom option #1:

Var1=Round(125*Demand,0) -- Level 1 Quantity

Var2=Round(250*Demand,0) -- Level 2 Quantity

Var3=Min(Quantity,Var1)*2.1 -- Level 1 Billing

Var3=Var3+Min(Max(Quantity-Var1,0),Var2)*1.7 -- Level 2 Billing

Var3=Var3+Max(Quantity-Var1-Var2,0)*1.6 -- Level 3 Billing

Result=Var3

This custom billing calculation is similar to service custom option #17:

Var1=Quantity/Sqrt(Quantity*Quantity+KVar*KVar) -- Power Factor

Var2=(Demand*.95/Var1*4.6)-(Demand*4.6) -- Power Factor Billing

Result=IIF(Var1<.95,Var2,0)

This is one used by Sutherlin, OR for their water base rate:

Var1=Round(Quantity/4200,1) -- EDU Factor

Result=Var1*21.00

This custom billing calculation is similar to demand option #6 in Classic:

Var1=Round(RelatedRegister1Usage/Sqrt(RelatedRegister1Usage*RelatedRegister1Usage+Quantity*Quantity),4)

Var2=RelatedRegister2Usage*(1+DemandFactor-Var1)

Var3=(Var2-RelatedRegister2Usage)*Demand Amount

Result=Var3

Rate structure example:

This example shows you how to reproduce a four-tier rate structure with multiple levels to a rate structure for a custom billing calculation.

Explanation: Calculation of Bill Quantity
Formula: Var1 = [Formula]

Explanation: Level 1 Billing
Formula: Var2=Min(Var1, Level1Quantity)*Level1Rate

Explanation: Level 2 Billing
Formula: Var3=Max(Min((Var1-Level1Quantity), Level 2Quantity, 0)*Level2Rate

Explanation: Level 3 Billing
Formula: Var4=Max(Min((Var1-(Level1Quantity+Level2Quantity+Level3Quantity)),0)*Level4Rate

Explanation: Calculation Billing Amount
Formula: Result = Var2+Var3+Var4+Var5

Explanation: Billing Quantity
Formula: QuantityBilled=Var1

202205, 2022Jun29