Bill Calculations
These APIs offer endpoints that provide a tool for calculating electric bills based upon the Rates and Basis (Algorithms) described.
All billing is grouped into the following categories of charges:
- Distribution Charge
- Demand Charge
- Energy Charge
- Customer Charge
To run a calculation, you first need to authenticate, then use this tool for a variety of purposes, including the calculation of past bills, project of costs for the current month, exploration of different tariff rate plans and electives through “what-if” scenarios, or comparison of changes in electricity or other usage.
Data Definitions
| Name | Description |
| distributor | Name of distribution utility |
| iso | ISO in which the utility is located |
| state | US State in which the utility is located |
| eiaid | Unique EIA numerical identifier of utility |
| zip code | Zip codes assigned to utility service terr |
| charge category | Monthly Charge/Distribution/Demand/Energy |
Calculate Economy Tariff Prices
This endpoint lists a Tariff’s rates within a specified date range.
| Field Name | Data Type | Description | Example |
| customerCharge | Collection | Collection of customer charges |
“customerCharge“: [ { “month“: 2, “year“: 2023, “tariffEnergyCharges“: “”, “chargeRange“: [ { “blockFactor“: 0, “cost“: 177.85, “percentage“: 0, “from“: 0, “to“: 0 } ] } ], |
| distributionCharge | Collection | Collection of distribution charges |
“distributionCharge“: [ { “month“: 2, “year“: 2023, “tariffEnergyCharges“: “”, “chargeRange“: [ { “blockFactor“: 0, “cost“: 0.03871, “percentage“: 0, “from“: 0, “to“: 0 } ] } ], |
| demandCharge | Collection | Collection of demand charges |
“demandCharge“: [ { “month“: 2, “year“: 2023, “tariffEnergyCharges“: “”, “chargeRange“: [ { “blockFactor“: 0, “cost“: 7.97, “percentage“: 0, “from“: 0, “to“: 0 }, { “blockFactor“: 0, “cost“: 0.0, “percentage“: 0, “from“: 0, “to“: 4 }, { “blockFactor“: 0, “cost“: 24.59, “percentage“: 0, “from“: 5, “to“: 0 }, { “blockFactor“: 0, “cost“: 0.42, “percentage“: 0, “from“: 0, “to“: 0 }, { “blockFactor“: 0, “cost“: 0.01, “percentage“: 0, “from“: 0, “to“: 0 } ] } ], |
| energyCharge | Collection | Collection of energy charges |
“energyCharge“: [ { “month“: 2, “year“: 2023, “tariffEnergyCharges“: “[{\”excess_pct\”:0,\”chargeLabel\”:\”Total Energy ($\\/kWh)\”,\”cpmin\”:0,\”components\”:[{\”price\”:0.00101,\”label\”:\”Energy-Merchant Function Charge ($\\/kWh)\”}],\”ndx\”:true,\”cpmax_pct\”:0,\”range\”:[{\”cost\”:0.01764,\”blcfctr\”:0,\”from\”:0}],\”basis\”:\”kwh\”,\”peak_interval\”:60,\”feedin_rate\”:0,\”cpmin_pct\”:0}]”, “chargeRange“: [ { “blockFactor“: 0, “cost“: 0.01764, “percentage“: 0, “from“: 0, “to“: 0 } ] } ], |
| operatorId | Integer | Unique Clarity Grid ID of the ISO that this tariff is effective in | “operatorId“: 2 |
Charge Collections
This collection contains data pertaining to various charges that a Tariff may have. These include Distribution, Demand, Energy, and Customer/Monthly charges.
| Field Name | Data Type | Description | Example |
| month | Integer | Effective month of rate | “month“: 2, |
| year | Integer | Effective year of rate | “year“: 2023, |
| tariffEnergyCharges | String | Tariff energy charges | “tariffEnergyCharges“: “[{\”excess_pct\”:0,\”chargeLabel\”:\”Total Energy ($\\/kWh)\”,\”cpmin\”:0,\”components\”:[{\”price\”:0.00101,\”label\”:\”Energy-Merchant Function Charge ($\\/kWh)\”}],\”ndx\”:true,\”cpmax_pct\”:0,\”range\”:[{\”cost\”:0.01764,\”blcfctr\”:0,\”from\”:0}],\”basis\”:\”kwh\”,\”peak_interval\”:60,\”feedin_rate\”:0,\”cpmin_pct\”:0}]”, |
| chargeRange | Collection | Collection of charge ranges |
“chargeRange“: [ { “blockFactor“: 0, “cost“: 0.01764, “percentage“: 0, “from“: 0, “to“: 0 } ] |
Charge Range Collections
This collection contains tiered rates for various charges
|
Field Name |
Data Type |
Description |
Example |
|
blockfactor |
Float |
Block factor of the rate |
“blockFactor“: 0, |
|
cost |
Float |
Rate of the charge |
“cost“: 0.03871, |
|
percentage |
Integer |
“percentage“: 0, |
|
|
from |
Integer |
Tier starting value in kW |
“from“: 0, |
|
to |
Integer |
Tier ending value in kW |
“to“: 0 |
Sample Output
Below is a sample of JSON data you may see returned from this endpoint.
Note: The following output has been heavily condensed, and is solely to show the data structure.
{
“distributionCharge“:
[
{
“month“: 2,
“year“: 2023,
“tariffEnergyCharges“: “”,
“chargeRange“:
[
{
“blockFactor“: 0,
“cost“: 0.03871,
“percentage“: 0,
“from“: 0,
“to“: 0
}
]
}
],
“demandCharge“:
[
{
“month“: 2,
“year“: 2023,
“tariffEnergyCharges“: “”,
“chargeRange“:
[
{
“blockFactor“: 0,
“cost“: 7.97,
“percentage“: 0,
“from“: 0,
“to“: 0
},
{
“blockFactor“: 0,
“cost“: 0.0,
“percentage“: 0,
“from“: 0,
“to“: 4
},
{
“blockFactor“: 0,
“cost“: 24.59,
“percentage“: 0,
“from“: 5,
“to“: 0
},
{
“blockFactor“: 0,
“cost“: 0.42,
“percentage“: 0,
“from“: 0,
“to“: 0
},
{
“blockFactor“: 0,
“cost“: 0.01,
“percentage“: 0,
“from“: 0,
“to“: 0
}
]
}
],
“energyCharge“:
[
{
“month“: 2,
“year“: 2023,
“tariffEnergyCharges“: “[{\”excess_pct\”:0,\”chargeLabel\”:\”Total Energy ($\\/kWh)\”,\”cpmin\”:0,\”components\”:[{\”price\”:0.00101,\”label\”:\”Energy-Merchant Function Charge ($\\/kWh)\”}],\”ndx\”:true,\”cpmax_pct\”:0,\”range\”:[{\”cost\”:0.01764,\”blcfctr\”:0,\”from\”:0}],\”basis\”:\”kwh\”,\”peak_interval\”:60,\”feedin_rate\”:0,\”cpmin_pct\”:0}]”,
“chargeRange“:
[
{
“blockFactor“: 0,
“cost“: 0.01764,
“percentage“: 0,
“from“: 0,
“to“: 0
}
]
}
],
“customerCharge“:
[
{
“month“: 2,
“year“: 2023,
“tariffEnergyCharges“: “”,
“chargeRange“:
[
{
“blockFactor“: 0,
“cost“: 177.85,
“percentage“: 0,
“from“: 0,
“to“: 0
}
]
}
],
“operatorId“: 2
}
Calculate Custom Economy
This endpoint is used to calculate bills. The output contains various elements that relate to battery and wholesale data, which will be explained in more detail in Analytics.
| Field Name | Data Type | Description | Example |
| retailMonthlyCosts | Collection | Collection of monthly retail costs; Contains floating point prices |
“retailMonthlyCosts“: [ 880.8707234801188, 863.956203093061, 978.8949789784865, 993.8244161788315, 847.009498518887, 1186.3652948737931, 1030.0927287737989, 784.4345760423133, 1164.0818521965593, 1373.1842081062994, 621.4472227448363, 722.1629039519289 ], |
| totalFeedInkWh | Float | Total feed-in rate in kWh | “totalFeedInkWh“: 0.0, |
| building_filename | String | Selected building when using NREL building usage | “building_filename“: “”, |
| monthlyDemandComponents | Collection | Collection of monthly demand components |
“monthlyDemandComponents“: [ { “component_type“: “Demand12”, “components“: [], “month“: 0 } ], |
| averageNextDayTrailing12MonthPrice | Float | Average next day trailing 12 month price | “averageNextDayTrailing12MonthPrice“: 0.07569098126884537, |
| usage | Collection | Collection of hourly usage; “EPOCH”: VALUE |
“usage“: { “1670742000000”: 21.4136112903225 }, |
| monthlyEnergyComponents | Collection | Collection of monthly energy components |
“monthlyEnergyComponents“: [ { “component_type“: “Energy”, “components“: [ { “month“: 0, “price“: 0.00101, “label“: “Energy-Merchant Function Charge ($/kWh)” }, { “month“: 0, “price“: -0.00238, “label“: “MSC I (Monthly)($/kWh)-NYC” }, { “month“: 0, “price“: 0.01392, “label“: “MSC II(Monthly) ($/kWh)-NYC” }, ], “month“: 0 } ], |
| building_url | String | Contains the url to the appropriate building file when using NREL profiles for usage. | “building_url“: “”, |
| warning | String | “warning“: “”, | |
| monthlyfixedCustomerCharge | Collection | Collection of monthly fixed customer charges; Contains floating point prices |
“monthlyfixedCustomerCharge“: [ 177.85, 177.85, 177.85, 220.64, 220.64, 220.64, 220.64, 177.85, 177.85, 177.85, 177.85, 177.85 ], |
| calculationValuesPerHour | Collection | Collection of hourly calculation rates per charge type |
“calculationValuesPerHour“: [ { “demandCharge“: 1.6895711426286046, “as_6“: 0.0, “timeOfUsage“: “2023-02-28 23:00:00”, “as_5“: 0.0, “usage“: 5.436791428571402, “nodePrice“: 0.03388, “as_2“: 0.0, “energyCharge“: 1.074647178499894, “as_1“: 0.0, “as_4“: 0.0, “as_3“: 0.0, “distributionCharge“: 0.5760416667901017, “nonSeePee“: 0.0, “capacityRate“: 0.0, “capacityCharge“: 0.0 } ], |
| retailAnnualCostsCombined | Float | Total combined annual retail costs | “retailAnualCostsCombined“: 29269.162662978473, |
| monthlyfixed4CPCharge | Collection | Monthly fixed 4 coincident peak rates; Contains floating point prices; This has been deprecated |
“monthlyfixed4CPCharge“: [ 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 ], |
| retailMonthlyDemandCosts | Collection | Collection of monthly retail demand costs; Contains floating point prices |
“retailMonthlyDemandCosts“: [ 780.1189875709644, 742.0710961033238, 633.7925298999971, 855.0212115833223, 833.1439430354802, 867.5125364387056, 851.777748729989, 820.0493230096739, 907.6482875966553, 1051.7691781032215, 954.8653311612861, 1135.3918078464224 ], |
| demandChargeBasis | Collection | Explained in Basis |
“demandChargeBasis“: [ “peak_kw” ], |
| distributionChargeBasis | Collection | Explained in Basis |
“distributionChargeBasis“: [ “kwh” ], |
| energyChargeBasis | Collection | Explained in Basis |
“energyChargeBasis“: [ “kwh” ], |
| customerChargeBasis | Collection | Explained in Basis |
“customerChargeBasis“: [ “fixed” ], |
| monthlyDistributionComponents | Collection | Collection of monthly distribution components |
“monthlyDistributionComponents“: [ { “component_type“: “Distribution”, “components“: [ { “month“: 0, “price“: 0.021, “label“: “Dist Cust Charge($/kWh)” }, { “month“: 0, “price“: 0.00253, “label“: “Monthly Adj Clause (MAC) ($/kWh)” }, { “month“: 0, “price“: 0.00504, “label“: “Monthly Adj Factor (MAC) ($/kWh)” }, ], “month“: 0 } ], |
| retailAnnualCosts | Float | Total annual retail costs | “retailAnualCosts“: 11446.324606938913, |
| usage_by_month | Collection | Collection of monthly usage |
“usage_by_month“: [], |
| retailMonthlyDistributionCosts | Collection | Collection of monthly retail distribution costs |
“retailMonthlyDistributionCosts“: [ 613.1283114503843, 656.7499998403605, 552.6500000120891, 680.4400000919547, 639.9399998917925, 580.6400000580635, 562.3399998633154, 755.0499999068998, 605.9877633338978, 612.8500003788695, 564.9500000499474, 564.9500000829483 ], |
| traceText | Collection | Collection of trace text; shows results of calculations |
“traceText“: [ { “Month“: “2023-2”, “Traces“: [ “Effective Date 2023-01-01~~~~~~”, “~~~~Charge Description~Charge Type~Rate”, “~~1~$177.85000~Total Dist Cust ($)|,,(10/xx-5/xx)~c.t~177.85”, “~~10000.000002~~Dist Cust Charge($/kWh)|(0-+),,~d.1~0.021”, “~~10000.000002~~Monthly Adj Clause (MAC) ($/kWh)|(0-+),,~d.1~0.00253”, “~~10000.000002~~Monthly Adj Factor (MAC) ($/kWh)|(0-+),,~d.1~0.00504”, “~~10000.000002~~Rev Decoupling ($/kWh)|(0-+),,~d.1~0.00006”, “~~10000.000002~~Dist System Benefit Charge ($/kWh)|(0-+),,~d.1~-0.00002”, “~~10000.000002~~Clean Energy Std Supply (CESS)($/kWh)|(0-+),,~d.1~0.0052”, “~~10000.000002~~Tax Sur-Credit ($/kwh)|(0-+),,~d.1~0.0049”, “~~10000.000002~~EV Make Ready Surcharge ($/kwh)|(0-+),,~d.1~0”, “~~10000.000002~~Del Rev Surcharge ($/kWh)|(0-+),,~d.1~0”, “~~10000.000002~~Uncollet Bill Exp ($/kwh)|(0-+),,~d.1~0”, “~~10000.000002~~Trans Adj ($/kwh)|(0-+),,~d.1~0”, “~~10000.000002~$387.10000~Total Dist($/kWh)|(0-+),,~d.t~0.03871”, “~0.07221629037971829~~$545.76290~NDX|~e.ndx.t~ndx”, “~~10000.000002~~Energy-Merchant Function Charge ($/kWh)|(0-+),,~e.1~0.00101”, “~~10000.000002~~MSC I (Monthly)($/kWh)-NYC|(0-+),,~e.1~-0.00238”, “~~10000.000002~~MSC II(Monthly) ($/kWh)-NYC|(0-+),,~e.1~0.01392”, “~~10000.000002~~Clean Energy Supply-RECs ($/kwh)|(0-+),,~e.1~0.00126”, “~~10000.000002~~Clean Energy Supply-Zero Emissions ($/kwh)|(0-+),,~e.1~0.00376”, “~~10000.000002~~Clean Energy Supply-Offshore Wind ($/kwh)|(0-+),,~e.1~0”, “~~10000.000002~~Clean Energy Supply-R Value($/kwh)|(0-+),,~e.1~0.00007”, “~~10000.000002~~Energy PPA ($/kWh)|(0-+),,~e.1~0”, “~~10000.000002~~Energy ($/kwh) (4/20-3/31)|(0-+),,~e.1~0”, “~~10000.000002~$176.40000~Total Energy ($/kWh)|(0-+),,~e.t~0.01764”, “2023-02-25 06:00~37.39775107142839~37.397751~$0.00000~Demand Charge($/kW) Rate F|(0-4),,,(10/xx-5/xx)~dct.t~0”, “2023-02-25 06:00~37.39775107142839~33.397751~$821.25070~Demand Charge($/kW) Rate F|(5-+),,,(10/xx-5/xx)~dct.t~24.59”, “2023-02-25 06:00~37.39775107142839~37.397751~$298.06008~Statement of Market Supply Charge Demand ($/kWh)Rate D|(0-+),,~dc.t~7.97”, “2023-02-25 06:00~37.39775107142839~37.397751~$15.70706~Dyn Load Mngmt Demand ($/kWh) Rate H|(0-+),,~dc.t~0.42”, “2023-02-25 06:00~37.39775107142839~37.397751~$0.37398~Statement of EV Make Ready Surcharge ($/kWh)Rate I|(0-+),,~dc.t~0.01” ] } ], |
| batteryDispatchHours | Collection | Collection of battery dispatch hours; Will be described in more detail in the Analytics Section |
“batteryDispatchHours“: [] |
| monthlyPPA | Collection | RFU; Will be described in more detail in the Analytics Section |
“monthlyPPA“: [ 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 ], |
| ppacost | Integer | RFU; Will be described in more detail in the Analytics Section | “ppacost“: 0.0, |
| batteryChargingHours | Collection | Collection of battery charging hours; Will be described in more detail in the Analytics Section |
“batteryChargingHours“: [], |
| wholesalePrices | Collection | Collection of wholesale prices; Contains prices organized by EPOCH values; Will be described in more detail in the Analytics Section |
“wholesalePrices“: { “1670742000000”: 0.06797 }, |
| batteryNetSavings | Collection | Collection of battery net savings; Contains floating point prices; Will be described in more detail in the Analytics Section |
“batteryNetSavings“: [ 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 ], |
| wholesaleMonthlyCapacityCost | Collection | Collection of monthly wholesale capacity costs; Contains floating point prices; Will be described in more detail in the Analytics Section |
“wholesaleMonthlyCapacityCost“: [ 148.62430519557364, 148.69999995043148, 148.70000000479627, 148.70000002973822, 148.69999996162528, 148.70000002398342, 148.6999999405179, 148.69999997601562, 148.6999999157351, 148.70000012951243, 0.0, 0.0 ], |
| availableBatteries | Collection | Collection of available batteries; Will be described in more detail in the Analytics Section |
“availableBatteries“: [ { “duration“: 4.0, “charging_kwh“: 20000.0, “cost“: 99999.9999, “name“: “20000 Kw. 4 Hour”, “disch_kwh“: 20000.0, “id“: 36 } ], |
| wholesaleAnnualCosts | Float | Annual wholesale costs; Will be described in more detail in the Analytics Section | “wholesaleAnualCosts“: 10569.87733570417, |
| wholesaleMonthlyCosts | Collection | Collection of monthly wholesale costs; Contains floating point prices; Will be described in more detail in the Analytics Section |
“wholesaleMonthlyCosts“: [ 605.8108123179012, 664.1562031596636, 809.5949789730257, 783.7244161368138, 988.5094984823705, 1096.3652948592771, 830.9927288534416, 587.5345760740726, 602.8701871954299, 1122.5842078880357, 445.0472227220754, 545.7629039141297 ], |
| wholesaleMonthlyDistributionCosts | Collection | Collection of monthly wholesale distribution costs; Contains floating point prices; Will be described in more detail in the Analytics Section |
“wholesaleMonthlyDistributionCosts“: [ 613.1283114503843, 656.7499998403605, 552.6500000120891, 680.4400000919547, 639.9399998917925, 580.6400000580635, 562.3399998633154, 755.0499999068998, 605.9877633338978, 612.8500003788695, 564.9500000499474, 564.9500000829483 ], |
| passThruComponents | Collection | Collection of pass thru components; Will be described in more detail in the Analytics Section |
“passThruComponents“: [ { “component_type“: “Iso Pass-Thru”, “components“: [], “month“: 0 }, ], |
| batteryMonthlyCosts | Collection | Collection of monthly battery costs; Contains floating point prices; Will be described in more detail in the Analytics Section |
“batteryMonthlyCosts“: [ 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 ], |
| wholesaleAnnualCostsCombined | Float | Annual combined wholesale costs; Will be described in more detail in the Analytics Section | “wholesaleAnualCostsCombined“: 28392.715391743724, |
| wholesaleMonthlyDemandCosts | Collection | Collection of monthly wholesale demand costs; Contains floating point prices; Will be described in more detail in the Analytics Section |
“wholesaleMonthlyDemandCosts“: [ 780.1189875709644, 742.0710961033238, 633.7925298999971, 855.0212115833223, 833.1439430354802, 867.5125364387056, 851.777748729989, 820.0493230096739, 907.6482875966553, 1051.7691781032215, 954.8653311612861, 1135.3918078464224 ], |
| as1-6tot | Float | For Battery: Placeholders for up to 6 Ancillary Service total revenue amounts. The names of the Ancillary Services are in the AS_columns collection; Will be described in more detail in the Analytics Section | “as5tot“: 0.0, |
| AS_Columns | Collection | Each ISO has different Ancillary Services; This collection contains the names of those Services; Will be described in more detail in the Analytics Section |
“AS_columns“: [ “”, “”, “”, “”, “”, “” ], |
| averageNextDayaheadPrice | Float | Average next-day dayahead price; Will be described in more detail in the analytics section | “averageNextDayDayaheadPrice“: 0.049950589439699405, |
Charge Components
This collection contains information about the components that make up charges.
|
Field Name |
Data Type |
Description |
Example |
|
component_type |
String |
Type of charge component; Energy, Demand, Distribution, ISO Pass-Thru |
“component_type“: “Distribution”, |
|
components |
Collection |
Collection of components |
“components“: [ { “month“: 0, “price“: 0.021, “label“: “Dist Cust Charge($/kWh)” }, ], |
|
month |
Integer |
RFU |
“month“: 0 |
Components
This collection contains the individual rates that make up a charge
|
Field Name |
Data Type |
Description |
Example |
|
month |
Integer |
RFU |
“month“: 0, |
|
price |
Float |
Rate of the component; Not used in calculations |
“price“: 0.021, |
|
label |
String |
Label of the component |
“label“: “Dist Cust Charge($/kWh)” |
Hourly Calculation Values
This collection contains hourly rates for each type of charge.
|
Field Name |
Data Type |
Description |
Example |
|
demandCharge |
Float |
Calculated demand charge |
“demandCharge“: 1.6895711426286046, |
|
timeOfUsage |
String |
Hour calculations are for |
“timeOfUsage“: “2023-02-28 23:00:00”, |
|
usage |
Float |
Total usage in kWh for the hour |
“usage“: 5.436791428571402, |
|
energyCharge |
Float |
Calculated energy charge |
“energyCharge“: 1.074647178499894, |
|
distributionCharge |
Float |
Calculated distribution charge |
“distributionCharge“: 0.5760416667901017, |
|
nonSeePee |
Float |
RFu |
“nonSeePee“: 0.0, |
|
capacityRate |
Float |
Capacity rate |
“capacityRate“: 0.0, |
|
capacityCharge |
Float |
Capacity amount |
“capacityCharge“: 0.0 |
|
as_1-6 |
Float |
Explained in Analytics |
“as_1“: 0.0, |
|
nodePrice |
Float |
Wholesale price at node; Explained in Analytics |
“nodePrice“: 0.03388, |
Trace Text
This collection contains trace text information that lists the final results of the calculations. The data is formatted in such a way that it can be easily placed into a crosstab for easy viewing.
|
Field Name |
Data Type |
Description |
Example |
|
Month |
String |
Month of calculations |
“Month“: “2023-2”, |
|
Traces |
Collection |
Collection of trace information; shows results of calculations |
“Traces“: [ “Effective Date 2023-01-01~~~~~~”, “~~~~Charge Description~Charge Type~Rate”, “~~1~$177.85000~Total Dist Cust ($)|,,(10/xx-5/xx)~c.t~177.85”, “~~10000.000002~~Dist Cust Charge($/kWh)|(0-+),,~d.1~0.021”, “~~10000.000002~~Monthly Adj Clause (MAC) ($/kWh)|(0-+),,~d.1~0.00253”, “~~10000.000002~~Monthly Adj Factor (MAC) ($/kWh)|(0-+),,~d.1~0.00504”, “~~10000.000002~~Rev Decoupling ($/kWh)|(0-+),,~d.1~0.00006”, “~~10000.000002~~Dist System Benefit Charge ($/kWh)|(0-+),,~d.1~-0.00002”, “~~10000.000002~~Clean Energy Std Supply (CESS)($/kWh)|(0-+),,~d.1~0.0052”, “~~10000.000002~~Tax Sur-Credit ($/kwh)|(0-+),,~d.1~0.0049”, “~~10000.000002~~EV Make Ready Surcharge ($/kwh)|(0-+),,~d.1~0”, “~~10000.000002~~Del Rev Surcharge ($/kWh)|(0-+),,~d.1~0”, “~~10000.000002~~Uncollet Bill Exp ($/kwh)|(0-+),,~d.1~0”, “~~10000.000002~~Trans Adj ($/kwh)|(0-+),,~d.1~0”, “~~10000.000002~$387.10000~Total Dist($/kWh)|(0-+),,~d.t~0.03871”, “~0.07221629037971829~~$545.76290~NDX|~e.ndx.t~ndx”, “~~10000.000002~~Energy-Merchant Function Charge ($/kWh)|(0-+),,~e.1~0.00101”, “~~10000.000002~~MSC I (Monthly)($/kWh)-NYC|(0-+),,~e.1~-0.00238”, “~~10000.000002~~MSC II(Monthly) ($/kWh)-NYC|(0-+),,~e.1~0.01392”, “~~10000.000002~~Clean Energy Supply-RECs ($/kwh)|(0-+),,~e.1~0.00126”, “~~10000.000002~~Clean Energy Supply-Zero Emissions ($/kwh)|(0-+),,~e.1~0.00376”, “~~10000.000002~~Clean Energy Supply-Offshore Wind ($/kwh)|(0-+),,~e.1~0”, “~~10000.000002~~Clean Energy Supply-R Value($/kwh)|(0-+),,~e.1~0.00007”, “~~10000.000002~~Energy PPA ($/kWh)|(0-+),,~e.1~0”, “~~10000.000002~~Energy ($/kwh) (4/20-3/31)|(0-+),,~e.1~0”, “~~10000.000002~$176.40000~Total Energy ($/kWh)|(0-+),,~e.t~0.01764”, “2023-02-25 06:00~37.39775107142839~37.397751~$0.00000~Demand Charge($/kW) Rate F|(0-4),,,(10/xx-5/xx)~dct.t~0”, “2023-02-25 06:00~37.39775107142839~33.397751~$821.25070~Demand Charge($/kW) Rate F|(5-+),,,(10/xx-5/xx)~dct.t~24.59”, “2023-02-25 06:00~37.39775107142839~37.397751~$298.06008~Statement of Market Supply Charge Demand ($/kWh)Rate D|(0-+),,~dc.t~7.97”, “2023-02-25 06:00~37.39775107142839~37.397751~$15.70706~Dyn Load Mngmt Demand ($/kWh) Rate H|(0-+),,~dc.t~0.42”, “2023-02-25 06:00~37.39775107142839~37.397751~$0.37398~Statement of EV Make Ready Surcharge ($/kWh)Rate I|(0-+),,~dc.t~0.01” ] |
Sample Output
Below is a sample of JSON data you may see returned from this endpoint.
Note: The following output has been heavily condensed, and is solely to show the data structure.
{
“as5tot“: 0.0, Only relevant to Analytics
“retailMonthlyCosts“:
[
880.8707234801188,
863.956203093061,
978.8949789784865,
993.8244161788315,
847.009498518887,
1186.3652948737931,
1030.0927287737989,
784.4345760423133,
1164.0818521965593,
1373.1842081062994,
621.4472227448363,
722.1629039519289
],
“wholesaleMonthlyDemandCosts“: Only relevant to Analytics
[
780.1189875709644,
742.0710961033238,
633.7925298999971,
855.0212115833223,
833.1439430354802,
867.5125364387056,
851.777748729989,
820.0493230096739,
907.6482875966553,
1051.7691781032215,
954.8653311612861,
1135.3918078464224
],
“totalFeedInkWh“: 0.0,
“building_filename“: “”,
“monthlyDemandComponents“:
[
{
“component_type“: “Demand12”,
“components“:
[],
“month“: 0
}
],
“averageNextDayTrailing12MonthPrice“: 0.07569098126884537,
“usage“:
{
“1670742000000”: 21.4136112903225
},
“as1tot“: 0.0, Only relevant to Analytics
“wholesaleAnualCostsCombined“: 28392.715391743724, Only relevant to Analytics
“as3tot“: 0.0, Only relevant to Analytics
“monthlyEnergyComponents“:
[
{
“component_type“: “Energy”,
“components“:
[
{
“month“: 0,
“price“: 0.00101,
“label“: “Energy-Merchant Function Charge ($/kWh)”
},
{
“month“: 0,
“price“: -0.00238,
“label“: “MSC I (Monthly)($/kWh)-NYC”
},
{
“month“: 0,
“price“: 0.01392,
“label“: “MSC II(Monthly) ($/kWh)-NYC”
},
{
“month“: 0,
“price“: 0.00126,
“label“: “Clean Energy Supply-RECs ($/kwh)”
},
{
“month“: 0,
“price“: 0.00376,
“label“: “Clean Energy Supply-Zero Emissions ($/kwh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “Clean Energy Supply-Offshore Wind ($/kwh)”
},
{
“month“: 0,
“price“: 0.000070,
“label“: “Clean Energy Supply-R Value($/kwh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “Energy PPA ($/kWh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “Energy ($/kwh) (4/20-3/31)”
}
],
“month“: 0
}
],
“wholesaleMonthlyCosts“: Only relevant to Analytics
[
605.8108123179012,
664.1562031596636,
809.5949789730257,
783.7244161368138,
988.5094984823705,
1096.3652948592771,
830.9927288534416,
587.5345760740726,
602.8701871954299,
1122.5842078880357,
445.0472227220754,
545.7629039141297
],
“wholesaleMonthlyDistributionCosts“: Only relevant to Analytics
[
613.1283114503843,
656.7499998403605,
552.6500000120891,
680.4400000919547,
639.9399998917925,
580.6400000580635,
562.3399998633154,
755.0499999068998,
605.9877633338978,
612.8500003788695,
564.9500000499474,
564.9500000829483
],
“AS_columns“: Only relevant to Analytics
[
“”,
“”,
“”,
“”,
“”,
“”
],
“passThruComponents“:
[
{
“component_type“: “Iso Pass-Thru”,
“components“:
[],
“month“: 0
},
],
“batteryMonthlyCosts“: Only relevant to Analytics
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
],
“building_url“: “”,
“warning“: “”,
“monthlyfixedCustomerCharge“:
[
177.85,
177.85,
177.85,
220.64,
220.64,
220.64,
220.64,
177.85,
177.85,
177.85,
177.85,
177.85
],
“calculationValuesPerHour“:
[
{
“demandCharge“: 1.6895711426286046,
“as_6“: 0.0, Only relevant to Analytics
“timeOfUsage“: “2023-02-28 23:00:00”,
“as_5“: 0.0, Only relevant to Analytics
“usage“: 5.436791428571402,
“nodePrice“: 0.03388,
“as_2“: 0.0, Only relevant to Analytics
“energyCharge“: 1.074647178499894,
“as_1“: 0.0, Only relevant to Analytics
“as_4“: 0.0, Only relevant to Analytics
“as_3“: 0.0, Only relevant to Analytics
“distributionCharge“: 0.5760416667901017,
“nonSeePee“: 0.0,
“capacityRate“: 0.0,
“capacityCharge“: 0.0
}
],
“retailAnualCostsCombined“: 29269.162662978473,
“wholesaleAnualCosts“: 10569.87733570417, Only relevant to Analytics
“monthlyfixed4CPCharge“:
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
],
“retailMonthlyDemandCosts“:
[
780.1189875709644,
742.0710961033238,
633.7925298999971,
855.0212115833223,
833.1439430354802,
867.5125364387056,
851.777748729989,
820.0493230096739,
907.6482875966553,
1051.7691781032215,
954.8653311612861,
1135.3918078464224
],
“as6tot“: 0.0, Only relevant to Analytics
“demandChargeBasis“:
[
“peak_kw”
],
“availableBatteries“: Only relevant to Analytics
[
{
“duration“: 4.0,
“charging_kwh“: 20000.0,
“cost“: 99999.9999,
“name“: “20000 Kw. 4 Hour”,
“disch_kwh“: 20000.0,
“id“: 36
}
],
“averageNextDayDayaheadPrice“: 0.049950589439699405, Only relevant to Analytics
“distributionChargeBasis“:
[
“kwh”
],
“as4tot“: 0.0, Only relevant to Analytics
“wholesaleMonthlyCapacityCost“: Only relevant to Analytics
[
148.62430519557364,
148.69999995043148,
148.70000000479627,
148.70000002973822,
148.69999996162528,
148.70000002398342,
148.6999999405179,
148.69999997601562,
148.6999999157351,
148.70000012951243,
0.0,
0.0
],
“energyChargeBasis“:
[
“kwh”
],
“wholesalePrices“: Only relevant to Analytics
{
“1670742000000”: 0.06797
},
“batteryNetSavings“: Only relevant to Analytics
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
],
“as2tot“: 0.0, Only relevant to Analytics
“customerChargeBasis“:
[
“fixed”
],
“batteryChargingHours“: Only relevant to Analytics
[],
“monthlyDistributionComponents“:
[
{
“component_type“: “Distribution”,
“components“:
[
{
“month“: 0,
“price“: 0.021,
“label“: “Dist Cust Charge($/kWh)”
},
{
“month“: 0,
“price“: 0.00253,
“label“: “Monthly Adj Clause (MAC) ($/kWh)”
},
{
“month“: 0,
“price“: 0.00504,
“label“: “Monthly Adj Factor (MAC) ($/kWh)”
},
{
“month“: 0,
“price“: 0.000060,
“label“: “Rev Decoupling ($/kWh)”
},
{
“month“: 0,
“price“: -0.000020,
“label“: “Dist System Benefit Charge ($/kWh)”
},
{
“month“: 0,
“price“: 0.0052,
“label“: “Clean Energy Std Supply (CESS)($/kWh)”
},
{
“month“: 0,
“price“: 0.0049,
“label“: “Tax Sur-Credit ($/kwh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “EV Make Ready Surcharge ($/kwh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “Del Rev Surcharge ($/kWh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “Uncollet Bill Exp ($/kwh)”
},
{
“month“: 0,
“price“: 0.0,
“label“: “Trans Adj ($/kwh)”
}
],
“month“: 0
}
],
“ppacost“: 0.0,
“retailAnualCosts“: 11446.324606938913,
“monthlyPPA“: Only relevant to Analytics
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
],
“usage_by_month“:
[],
“retailMonthlyDistributionCosts“:
[
613.1283114503843,
656.7499998403605,
552.6500000120891,
680.4400000919547,
639.9399998917925,
580.6400000580635,
562.3399998633154,
755.0499999068998,
605.9877633338978,
612.8500003788695,
564.9500000499474,
564.9500000829483
],
“traceText“:
[
{
“Month“: “2023-2”,
“Traces“:
[
“Effective Date 2023-01-01~~~~~~”,
“~~~~Charge Description~Charge Type~Rate”,
“~~1~$177.85000~Total Dist Cust ($)|,,(10/xx-5/xx)~c.t~177.85”,
“~~10000.000002~~Dist Cust Charge($/kWh)|(0-+),,~d.1~0.021”,
“~~10000.000002~~Monthly Adj Clause (MAC) ($/kWh)|(0-+),,~d.1~0.00253”,
“~~10000.000002~~Monthly Adj Factor (MAC) ($/kWh)|(0-+),,~d.1~0.00504”,
“~~10000.000002~~Rev Decoupling ($/kWh)|(0-+),,~d.1~0.00006”,
“~~10000.000002~~Dist System Benefit Charge ($/kWh)|(0-+),,~d.1~-0.00002”,
“~~10000.000002~~Clean Energy Std Supply (CESS)($/kWh)|(0-+),,~d.1~0.0052”,
“~~10000.000002~~Tax Sur-Credit ($/kwh)|(0-+),,~d.1~0.0049”,
“~~10000.000002~~EV Make Ready Surcharge ($/kwh)|(0-+),,~d.1~0”,
“~~10000.000002~~Del Rev Surcharge ($/kWh)|(0-+),,~d.1~0”,
“~~10000.000002~~Uncollet Bill Exp ($/kwh)|(0-+),,~d.1~0”,
“~~10000.000002~~Trans Adj ($/kwh)|(0-+),,~d.1~0”,
“~~10000.000002~$387.10000~Total Dist($/kWh)|(0-+),,~d.t~0.03871”,
“~0.07221629037971829~~$545.76290~NDX|~e.ndx.t~ndx”,
“~~10000.000002~~Energy-Merchant Function Charge ($/kWh)|(0-+),,~e.1~0.00101”,
“~~10000.000002~~MSC I (Monthly)($/kWh)-NYC|(0-+),,~e.1~-0.00238”,
“~~10000.000002~~MSC II(Monthly) ($/kWh)-NYC|(0-+),,~e.1~0.01392”,
“~~10000.000002~~Clean Energy Supply-RECs ($/kwh)|(0-+),,~e.1~0.00126”,
“~~10000.000002~~Clean Energy Supply-Zero Emissions ($/kwh)|(0-+),,~e.1~0.00376”,
“~~10000.000002~~Clean Energy Supply-Offshore Wind ($/kwh)|(0-+),,~e.1~0”,
“~~10000.000002~~Clean Energy Supply-R Value($/kwh)|(0-+),,~e.1~0.00007”,
“~~10000.000002~~Energy PPA ($/kWh)|(0-+),,~e.1~0”,
“~~10000.000002~~Energy ($/kwh) (4/20-3/31)|(0-+),,~e.1~0”,
“~~10000.000002~$176.40000~Total Energy ($/kWh)|(0-+),,~e.t~0.01764”,
“2023-02-25 06:00~37.39775107142839~37.397751~$0.00000~Demand Charge($/kW) Rate F|(0-4),,,(10/xx-5/xx)~dct.t~0”,
“2023-02-25 06:00~37.39775107142839~33.397751~$821.25070~Demand Charge($/kW) Rate F|(5-+),,,(10/xx-5/xx)~dct.t~24.59”,
“2023-02-25 06:00~37.39775107142839~37.397751~$298.06008~Statement of Market Supply Charge Demand ($/kWh)Rate D|(0-+),,~dc.t~7.97”,
“2023-02-25 06:00~37.39775107142839~37.397751~$15.70706~Dyn Load Mngmt Demand ($/kWh) Rate H|(0-+),,~dc.t~0.42”,
“2023-02-25 06:00~37.39775107142839~37.397751~$0.37398~Statement of EV Make Ready Surcharge ($/kWh)Rate I|(0-+),,~dc.t~0.01”
]
}
],
“batteryDispatchHours“: Only relevant to Analytics
[]
}
