Rate calculation variables list

Rates

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) Returns one value if the condition is true, and another value if that condition is false.

Example: Result=IIf(Var1<.95,Var2<0) If Var1 is less than .95, then the result would be the value of Var2, otherwise, the result is zero (0).

KVar

Description: KVar usage

Max

Description: Max function, Max(Number1,Number2). Returns the largest of two numbers.

Example: Result=Max(100,50) [Result would be 100.]

Min

Description: Min function, Min(Number1,Number2). Returns the smallest of two numbers.

Example: Result=Min(100,50) [Result would be 50.]

Multiplier

Description: Multiplier from the Meter table.

Quantity

Description: Usage

Result

Description: Used to store the FINAL result of the custom billing calculation.

Example: Result=Quantity*Var2 [The final result of the billing calculation would be Quantity multiplied by the value stored in Var2.]

Round

Description: Round function. Round(Number, DecimalPlaces) Rounds a number to a specified number of decimal places.

Example: Result=Round(1.234,2) [Result would be 1.23]; Result=Round(1.5,0) [Result would be 2]

Sqrt

Description: Sqrt function, Sqrt(Number). Returns the square root of a number.

Example: Result=Sqrt(9) [Result would be 3]

Var1, Var2, Var3, Var 4, Var5, Var6, Var7, Var8, Var9

Description: Used to store the results of a calculation.

Example: Var1=Quantity*Demand, [Var1 would contain the value of Quantity multiplied by Demand]

Description: Comment indicator. Any text that follows two dashes (--) will be treated as a comment and ignored by the billing calculation. Use comments to clarify the billing calculation.

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

202205, 2022