error in fix charge charges

[anandkp92]

Noted by @bfgerke:

Some of the OpenEI JSON files report fixed charges as $/month, and others report them as $/day. But the calculator seems to ignore the stated units and assume everything is reported in $/month.

For instance, a tariff might have entries like

{
...
fixedchargefirstmeter:0.91565
fixedchargeunits:"$/day"
...
}

In this case, the code returns monthly fixed charges that are around $0.91, when they should be closer to $27.

TODO: Need to look at fixedchargeunits in the json.

[anandkp92]

@bfgerke Could you share the example you worked on/ tariff json?

The reason I ask is I see that we are handling the daily rates here:

• in openei_tariff_analyzer.py
• in tariff_structure.py and
• in rate_manager.py

I want to replicate the costs that you are seeing, so I'd appreciate any information you can provide.

Thanks
Anand

[bfgerke]

Sure. Below is a tariff JSON that has fixed charges in $/day. When I run this through the calculator to get monthly bills, the fixed-charge components appear to be the daily value, rather than the monthly value. It's possible that this is user error and there's something I'm supposed to do to process these correctly, but if I naively just add up the different components, the fixed piece is wrong. In a somewhat related issue, some tariffs (especially SDG&E) specify a minimum bill, which as far as I can tell is just a fixed charge by a different name. The calculator ignores these values. I'm including a second JSON file below that has this specification, so you can decide if you want to handle that case. Also, to be clear, I've already modified all of our JSON files to produce the desired outputs, so there's no great urgency to fix this from my perspective. Tariff with $/day fixed charges [ { "is_default": false, "label": "5e167d8d5457a3d50873e3b1", "name": "B-1 Small General Service TOU (Single-Phase)", "peakkwcapacitymax": 75, "phasewiring": "Single Phase", "sector": "Commercial", "servicetype": "Bundled", "source": " https://www.pge.com/tariffs/assets/pdf/tariffbook/ELEC_SCHEDS_A-1.pdf", "sourceparent": "https://www.pge.com/tariffs/index.page", "startdate": "1970-01-01T00:00:00.000Z", "supersedes": "5e16798b5457a3223473e3b1", "uri": "https://openei.org/IURDB/rate/view/5e167d8d5457a3d50873e3b1", "utility": "Pacific Gas & Electric Co", "approved": false, "basicinformationcomments": "Fixed Monthly Charge is the Total Customer Charge per day, averaged out for a month. ($0.32854 per meter per day * 365 days/ 12 months).", "country": "USA", "demandrateunit": "kW", "demandunits": "kW", "description": "This schedule is also not available to customers whose meter indicates a maximum demand of 75 kW or greater for three consecutive months.", "dgrules": "Net Metering", "eiaid": 14328, "enddate": "2022-02-18T22:21:40.000Z", "energyratestructure": [ [ { "rate": 0.24754, "unit": "kWh" } ], [ { "rate": 0.26396, "unit": "kWh" } ], [ { "rate": 0.28008, "unit": "kWh" } ], [ { "rate": 0.28546, "unit": "kWh" } ], [ { "rate": 0.30627, "unit": "kWh" } ], [ { "rate": 0.3555, "unit": "kWh" } ] ], "energyweekdayschedule": [ [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ] ], "energyweekendschedule": [ [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 5, 5, 5, 5, 5, 4, 4, 3 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ], [ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 1 ] ], "fixedchargefirstmeter": 0.32854, "fixedchargeunits": "$/day", "flatdemandunit": "kW" } ] Tariff with minimum charge instead of fixed charge: [ { "approved": true, "country": "USA", "demandrateunit": "kW", "demandunits": "kW", "description": "This Schedule is optionally available to domestic service for lighting, heating, cooking, water heating, and power, or combination thereof, in single family dwellings, flats, and apartments, separately metered by the utility; to service used in common for residential purposes by tenants in multi-family dwellings under Special Condition 3; to any approved combination of residential and nonresidential service on the same meter; and to incidental farm service under Special Condition 7. In order for this Schedule to take effect, the customer must have &#x;fffdappropriate electric metering&#x;fffd as defined under Special Condition 1. This Schedule is also applicable to customers qualifying for the California Alternate Rates for Energy (CARE) Program and/or Medical Baseline, residing in single-family accommodations, separately metered by the Utility, and may include Non-profit Group Living Facilities and Qualified Agricultural Employee Housing Facilities, if such facilities qualify to receive service under the terms and conditions of Schedule E-CARE. The rates for CARE and Medical Baseline customers are identified in the rates tables below as TOU-DR-LI and TOU-DR-MB rates, respectively. Customers on this schedule may also qualify for a semi-annual California Climate Credit $(17.44) per Schedule GHG-ARR.", "dgrules": "Net Metering", "eiaid": 16609, "enddate": "2021-11-29T19:06:27.000Z", "energyratestructure": [ [ { "rate": 0.69702, "unit": "kWh daily" } ], [ { "rate": 0.45514, "unit": "kWh daily" } ], [ { "rate": 0.32809, "unit": "kWh daily" } ], [ { "rate": 0.54157, "unit": "kWh daily" } ], [ { "rate": 0.47995, "unit": "kWh daily" } ], [ { "rate": 0.46102, "unit": "kWh daily" } ] ], "energyweekdayschedule": [ [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ] ], "energyweekendschedule": [ [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1 ], [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ], [ 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 4, 4, 3, 3, 3, 3, 3, 4, 4, 4 ] ], "fixedchargeunits": "$/month", "flatdemandunit": "kW", "is_default": false, "label": "61255bf65457a3df091da5b5", "mincharge": 10.64, "minchargeunits": "$/month", "name": "TOU-DR Desert Baseline Region", "revisions": [ 1629816726, 1629816852 ], "sector": "Residential", "servicetype": "Bundled", "source": "http://regarchive.sdge.com/tm2/pdf/ELEC_ELEC-SCHEDS_TOU-DR.pdf", "sourceparent": " https://www.sdge.com/rates-and-regulations/current-and-effective-tariffs", "startdate": "2017-01-01T08:00:00.000Z", "supersedes": "5cafb82a5457a3600d7780e2", "uri": "https://openei.org/apps/IURDB/rate/view/61255bf65457a3df091da5b5", "utility": "San Diego Gas & Electric Co" } ]

…

On Thu, Mar 31, 2022 at 10:15 AM Anand Prakash ***@***.***> wrote: @bfgerke <https://github.com/bfgerke> Could you share the example you worked on/ tariff json? The reason I ask is I see that we are handling the daily rates here: - in openei_tariff_analyzer.py <https://github.com/LBNL-ETA/elecprice/blob/main/electricitycostcalculator/openei_tariff/openei_tariff_analyzer.py#L268-L271> - in tariff_structure.py <https://github.com/LBNL-ETA/elecprice/blob/main/electricitycostcalculator/electricity_rate_manager/tariff_structure.py#L188-L191> and - in rate_manager.py <https://github.com/LBNL-ETA/elecprice/blob/main/electricitycostcalculator/electricity_rate_manager/rate_manager.py#L123> I want to replicate the costs that you are seeing, so I'd appreciate any information you can provide. Thanks Anand — Reply to this email directly, view it on GitHub <#10 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AWXFQW635UAIWM263GCZYO3VCXMSXANCNFSM5SF7HBBA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Brian F. Gerke Research Scientist Energy Analysis and Environmental Impacts Division Lawrence Berkeley National Laboratory (he/him/his)