Overview of Basis

API Basis

Trace text charge code

fixed

c.t

Traditional Monthly Customer Charge ($) 

This is the recurring monthly cost of providing electric service to the customer regardless of usage. The amount is in the “cost” element of the single item in the “range” collection of the “customer_charge” 

“range”:[ 

{“cost”:50,”blcfctr”:0,”from”:0}, 

],”basis”:”fixed”,

fixed_kWh

ct.t

Tiered Monthly Customer Charge ($) 

Different fixed charges are applied depending on the usage peak. Will have more than one item in the range collection. The “from” of the item is where the previous range stopped. In this example, there is no charge if the monthly usage is below 43 kWh. There is a $50 charge if the usage is > 43kWh and < 425 kWh. There is a $150 charge if the usage is > 425 kWh 

“range”:[ 

{“cost”:50,”blcfctr”:0,”from”:43}, 

{“cost”:150,”blcfctr”:0,”from”:425} 

],”basis”:”fixed_kwh”,

kWh

d.t

Traditional Monthly $/kWh Base Distribution Charge 

This is the cost of providing delivery service of kWhrs from the Wholesale distribution point (substation) to the customer premise. 

Will have one item in the range collection: 

{“cost”:0.5,”blcfctr”:0,”from”:0}

kWh

dt.t

Tiered distribution charge by monthly volume 

This is the cost of providing local delivery whose charge varies for each volume range of usage during a month. Will have more than one item in the range collection: 

[{“cost”:0.12,”blcfctr”:0,”from”:0},{“cost”:0.22,”blcfctr”:0,”from”:200}]

peak_kW_bf

dtb.t

Distribution charge tiered rate by block factor 

This is the cost of local delivery Where the range of usage for Which a given $/kWh charge applies is determined first by 0 up to the customer’s monthly peak usage multiplied by a fixed Block Factor (“from”: “hours”} expressed as hours, or kWh/kW, billing demand etc. Each subsequent range begins at the outer range of the previous Tier and ends at the next block factor times monthly peak usage, this continues until all monthly usage is assigned a range (tier) and priced against the relevant price. 

“range”: [

{ “cost”: 0.02156, “blcfctr”: 0, “from”: 0 },

{ “cost”: 0.0083, “blcfctr”: 0, “from”: 275 }

],

“basis”: “peak_kw_bf”,

billdmd_bf

dtbd.t

Distribution tiered by notional and block factor (billing demand) 

This is similar in format to Billing Demand however ranges for pricing (Tiers) are bounded by either Block Factors*Peak Usage, or notional numbers, e.g. 0-2,000 kWhrs. 

“range”:[

{“cost”:0.02173,”blcfctr”:0,”from”:0}, 

{“cost”:0.01932,”blcfctr”:100,”from”:0}, 

{“cost”:0.01373,”blcfctr”:200,”from”:0}, 

{“cost”:0.01177,”blcfctr”:400,”from”:0} 

], 

“basis”:”billdmd_bf”,

billdmd_bf_ratchet

dtbr.t

Distribution charge tiered by block factor but whose peak usage component is the higher of the current monthly peak OR average usage over a set number of trailing months times a ratio, format example (.80,11), Where average peak usage over the preceding 11 months times .80 is compared to the current monthly peak and higher of two values is used. The percentage, number of months, and amount for the ratchet are in the “coincident_peak” object. 

“coincident_peak”:{“previous_months”:11,”cost”:0.03,”percent”:80}, 

“range”:[

{“cost”:0.04,”blcfctr”:100,”from”:0}, 

{“cost”:0.06,”blcfctr”:100,”from”:200}, 

{“cost”:0.13,”blcfctr”:200,”from”:200} 

],”basis”:”billdmd_bf_ratchet”,

peak_kW

dc.t

Traditional NCP (Non-Coincident Peak) Monthly Demand Charge-Separate Charge assessed against peak usage over the billing month multiplied by the Demand Rate expressed as $/kW, or initially $/kVa Which is then converted by power factor, e.g., .85. The amount is in the “cost” element of the single item in the range collection: 

“range”:[

{“cost”:7.254,”blcfctr”:0,”from”:0}

],”basis”:”peak_kw”,

peak_kW

dct.t

Traditional NCP(Non-Coincident Peak) Monthly Demand Charge W Tiers-Same type of charge as Demand Charge listed above but Whose rate ($/kW) varies based upon peak usage beginning at a level above 0 kW. The tiers are defined by multiple items in the range collection: 

“range”:[

{“cost”:3.74,”blcfctr”:0,”from”:0}, 

{“cost”:6.99,”blcfctr”:0,”from”:10} 

] 

,”basis”:”peak_kw”,

non_coincident_peak_ratchet

dcr.t

Traditional NCP(Non-Coincident Peak) Monthly Demand Charge W ratchet-Same type of charge as above but Whose peak usage is higher of current monthly peak or trailing months times a ratio. The ratchet variables are in the “coincident_peak” object: 

“coincident_peak”:{“previous_months”:11,”cost”:19.89,,”percent”:80.0}, “range”:[],”basis”:”non_coincident_peak_ratchet”

daily_peak_kW

ddc.t

NCP(Non-Coincident Peak) Daily Demand Charge-Same as Monthly NCP Demand but Whose maximum peak is measured each day and multiplied by a daily demand rate $/kW. The amount is in the “cost” element of the one item in the “range” collection: 

“range”:[

{“cost”:0.04,”blcfctr”:0,”from”:0}

],”basis”:”daily_peak_kw”,

daily_peak_kW_tr

ddct.t

NCP(Non-Coincident Peak) Daily Demand Charge +10 kW-Same as Daily Demand but Whose peak usage measurement for the day begins at a level above 0. The tiers are persisted to multiple items in the “range” collection using the “cost” and “from” elements. 

“range”:[

{“cost”:0,”blcfctr”:0,”from”:0},

{“cost”:15,”blcfctr”:0,”from”:50},

{“cost”:14,”blcfct r”:0,”from”:100},

{“cost”:13,”blcfctr”:0,”from”:200}

],”basis”:”daily_peak_kw_tr”,

dced

dced.t

Some Australia tariffs have an excess demand charge. This charge is applied to customers whose off peak peak is higher than their on peak peak. If the off peak peak is higher than the off peak peak, the charge amount is multiplied by the difference.

(offPeakPeak – onPeakPeak) * Amount

The range object will have one value in the cost element for the amount:

“range”:[{“cost”:2.65,”blcfctr”:0,”from”:0}],”basis”:”dced”,

TDL (trace text): The onPeak period is defined by a TOU formula and is required:

excess dmd|(0-+),,,(,(8:00-21:00),(M-F)

one_coincident_peak three_coincident_peak four_coincident_peak five_coincident_peak x_coincident_peak

dcXcp.t

CP (Coincident Peak) Monthly Demand Charge 

Demand Charge Which is assessed monthly using the current CP Demand Rate ($/kW) but Whose usage amount is the average of several “Coincident Peak” hours and days of the previous year as published by the Independent System Operator (ISO). 

NOTE: x_coincident_peak will eventually obsolete one,three, etc… 

Any number of coincident peak hours are supported as per the number of elements in the “coincident_dates” collection. The amount is in the “cost” element. These dates are epochs. 

“cpmax_pct”:70, 

“coincident_peak”: 

{ 

“previous_months”:0, 

“cost”:17.5, 

“coincident_dates”:[1594825200000,1597503600000], 

“year”:2021, 

“percent”:0 

},”range”:[],”basis”:”x_coincident_peak”,

dmd_tiered_ratchet

dctr.t

Traditional NCP(Non-Coincident Peak) Monthly Demand Charge Tiered W ratchet-Same Demand Charge Tiered charge as the others but Whose peak usage is higher of current monthly peak or trailing months times a ratio. The ratio is in the “percent” element of the “coincident_peak object and the number of trailing months is in the “previous_months” element. The tiers are defined in the “range” collection in its “cost” and “from” elements: 

“coincident_peak”:{“previous_months”:12,”cost”:0.0,”year”:2021,”percent”:90.0},

“range”:[

{“cost”:0.0,”blcfctr”:0,”from”:0},

{“cost”:12.0,”blcfctr”:0,”from”:2}

], “basis”:”dmd_tiered_ratchet”,

CP Excess Demand 

“excess_pct”:100

The Excess Demand shall be the difference between the highest 15-minute kW demand registered or computed by or from the City’s metering facilities, 

and the CP Billing Demand for the current month 

for excess demand we take n% of the coincident peak(s) value 

and n% of the current peak, 

and use the curMonthDemndPeak-CP if > 0

CP Max Percent

“cpmax_pct”:70

CP Min 

“cpmin”:1000, 

“cpmin_pct”:50

if you add (cpmin,1000,50) it will do: 

The Contract Demand shall be the greater of the following: 

1,000 kW or 50% of the highest 60-minute coincident peak demand established by the customer during the current or preceding 12 billing months

kwh

e.t

Monthly amount is determined by multiplying the cost per kWh by the monthly usage. The cost is persisted to the “cost” element in the single item in the “range” collection: 

“range”:[{“cost”:0.13467,”blcfctr”:0,”from”:0}],”basis”:”kwh”,

kwh

et.t

Tiered Energy charge where there is a different cost based off of the usage. The tiers are defined by multiple items in the “range” collection. In this example, if the usage is between 0 and 100 kWh, the amount is 0.166 If the usage is over 100 kWh, the amount per kWh is 0.1451 

“range”:[{“cost”:0.166,”blcfctr”:0,”from”:0}, 

{“cost”:0.1451,”blcfctr”:0,”from”:100} 

], 

“basis”:”kwh”,

daily_kwh_tr

etd.t

Calculated on daily usage totals. The tiers are defined by items in the “range” collection. Each day’s usage is examined to see what tier it falls in, and the “cost” for that tier is used for the calculation. In the following example, if the day’s usage is 0 to 200 the cost per kWh is 0.05448. From 200 to 400: 0.0199. Above 400: 0.01649 

“range”:[

{“cost”:0.05448,”blcfctr”:0,”from”:0}, 

{“cost”:0.0199,”blcfctr”:0,”from”:200}, 

{“cost”:0.01649,”blcfctr”:0,”from”:400} 

], 

“basis”:”daily_kwh_tr”,

peak_kw_bf

etb.t

Cost per block factor is defined in the “range” collection “cost” and “from” elements: 

“range”:[ 

{“cost”:0.08375,”blcfctr”:0,”from”:0}, 

{“cost”:0.03221,”blcfctr”:0,”from”:360} 

], 

“basis”:”peak_kw_bf”

billdmd_bf_ratchet

etbr.t

Energy charge (per kWh) tiered by block factor but Whose peak usage component is the higher of the current monthly peak OR average usage over a set number of trailing months times a ratio, format example (.80,11), Where average peak usage over the preceding 11 months times .80 is compared to the current monthly peak and higher of two values is used. 

The percentage, number of months, and amount for the ratchet are in the “coincident_peak” object. 

“coincident_peak”:{“previous_months”:11,”cost”:0.03,”percent”:80}, 

“range”:[

{“cost”:0.04,”blcfctr”:100,”from”:0}, 

{“cost”:0.06,”blcfctr”:100,”from”:200}, 

{“cost”:0.13,”blcfctr”:200,”from”:200} 

],”basis”:”billdmd_bf_ratchet”,

offpeak_bf

etopb.t

Energy charge tiered rate by block factor-This is the cost of local delivery Where the range of usage for Which a given $/kWh charge applies is determined first by 0 up to the customer’s monthly On-peak peak usage multiplied by a fixed Block Factor (200 hours) expressed as hours, then multiplied (Weighted) by the ratio of Off Peak/Total usage. Each subsequent range begins at the outer range of the previous Tier and ends at the next block factor times monthly peak usage times the Off Peak/Peak Usage, this continues until all monthly usage is assigned a range (tier) and priced against the relevant price. Tiers are defined per block factor by items in the “range” collection. 

“range”:[

{“cost”:0.05284,”blcfctr”:200,”from”:0}, 

{“cost”:0.02005,”blcfctr”:200,”from”:0}, 

{“cost”:0.0175,”blcfctr”:400,”from”:0} 

], 

“basis”:”offpeak_bf”,

billdmd_bf

etbd.t

Energy tiered by notional+block factor value as beginning of Tier to higher notional value+block factor value as upper bound of Tier. The tiers for each block factor and amounts are in the items of the “range” collection. 

“range”:[

{“cost”:0.152846,”blcfctr”:125,”from”:0}, 

{“cost”:0.076709,”blcfctr”:125,”from”:3000}, 

{“cost”:0.060829,”blcfctr”:125,”from”:90000}, 

{“cost”:0.105562,”blcfctr”:275,”from”:0}, 

{“cost”:0.078176,”blcfctr”:275,”from”:6000}, 

{“cost”:0.075619,”blcfctr”:275,”from”:101000}, 

{“cost”:0.06996,”blcfctr”:400,”from”:0}

], 

“basis”:”etabd”,

If the “feedin_rate” has a value > 0, it will be multiplied by the sum of all negative usage amounts and added into the total bill amount as a credit. 

“feedin_rate”: 0.24

When a charge has detail lines that are summed together to arrive at the value for the “cost” element, we record these in the “components” collection. This is a name / value collection where the “label” element is the name and the “price” element is the value. These numbers are not used in any computations in the tariff bill calculation engine. They are strictly informational. 

“components”: [ 

{ 

“price”: 0.3016, 

“label”: “VDO variable charge 1($/kWh)(0-1020 kWh)” 

}, 

{

“price”: 0.3335, 

“label”: “VDO variable charge 2($/kWh)(+1020 kWh)”} 

],

If a charge only applies for certain months, hours or days the time period it applies for is in the “time_period” object. The charge will only be applied to usage that occurs during the time period and any peaks are confined to the time period. The “time_period” element has days, hours and months collections. Hour values are 0 thru 23. “days_of_week” values are 1=Sunday thru 7=Saturday. “months” 1=January 

“time_period”: { 

“days_of_week”: [2,3,4,5,6], 

“hours”: [ 15, 16, 17,18, 19, 20]], 

“months”: [ 4,5,6, 7,8,9,10,11 ]

}

The id element is the unique auto-increment id for the tariff detail. There is one tariff detail for each effective date (revision) of the tariff: 

“id”: 11752, 

The following id is the id that links all the tariff detail rows to the distributor. “distributor_tariff_detail_id”: 65306, 

The “revision_reason” is free form text explaining if there is a special purpose for the revision. For example “updated PPA” 

“revision_reason”: “Effective Date” 

The auto-increment id of the distributor 

“distributor_id”: 2281, 

The name of the tariff 

“tariff_name”: “C-NASN12 Small business single rate demand”, 

The date this revision becomes effective. 

“effective_start_date”: “2022-07-01”, 

The Notes object contains the distributors notes regarding the applicability of the tariff and the URL for the distributors original document: 

{“notes”:”This rate is available to commercial customers who receive service at secondary voltage and who have a maximum measured demand of 300 KW or greater per billing period.”, 

“research_url”:”}