Rate_custom_option_list

Rate custom option list

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

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • Error: Invalid rate custom options

      Issue The application is using a custom option number that doesn't exist. Explanation A custom rate allows the application to run in a different way to fill a need for a specific organization. Each custom rate is assigned to a custom rate option ...

    • Rate operators list

      Rules and guidelines for using operators in a formula that calculates a rate. Operators (+, -, *, etc.) specify the type of calculation that you want to perform on the elements of a formula. Uses standard mathematical precedence. Arithmetic operators ...

    • What is a custom option?

      Overview A custom option allows the Utility Management program to run differently from the way it was intended to run. If you would like to use a custom option, please contact Customer Service for more information. Requesting custom options Call ...

    • How do I add a rate?

      Organization use rates to calculate a billed amount for electricity, water, sewer, and other services that bill based on the amount used by a customer. The rate allows you to customize how the billed amount is calculated and define what happens when ...

    • Rate calculation variables list

      Use the calculation variables to calculate rates. CostAdjustmentFactor Description: Cost adjustment factor from the Service table. Demand Description: Demand usage. IIf Description: Conditional test function. IIf(Condition, ValueIfTrue, ValueIfFalse) ...