Validate URDB gas tariffs for NY (Rate Acuity → URDB sanity check)

[jpvelez]

What

Validate that the URDB-format gas tariffs we wrote for NY (from Rate Acuity) are accurate so we can trust bill change numbers from the platform.

Why

We need to trust that the tariff data is accurate so we get accurate bill change numbers. Natalia did testing at the library level (tariff_fetch / conversion) but asked that we sanity-check the outputs.

How

1. Use the CSVs in rate_design/ny/hp_rates/config/tariffs/gas/ (raw Rate Acuity download) as the source of truth.
2. Fixed charges: Identify fixed charges in each CSV and compare them to the fixed charges in the corresponding URDB (.json) file.
3. Volumetric (per-therm) charges: Identify the subset of per-therm charges that matter for residential bills; convert these to per kWh using the same conversion factor as tariff_fetch; sum volumetric charges by month and compare with the URDB.
4. Part of this should be scripted (e.g. a script that extracts and compares fixed + volumetric); part of the value is manually looking at the data to spot mismatches or oddities.
5. Do the above for every utility–tariff combo in NY.
6. Triangulation: For 3–4 utilities, look up the current (or recent) volumetric rate from the utility’s website or a public source and compare to what we have in the CSV/URDB.

Deliverables

• cenhud.json — Fixed and volumetric check done
• coned_sf.json — Fixed and volumetric check done
• coned_mf_lowrise.json — Fixed and volumetric check done
• coned_mf_highrise.json — Fixed and volumetric check done
• kedli_sf_nonheating.json — Fixed and volumetric check done
• kedli_sf_heating.json — Fixed and volumetric check done
• kedli_mf_nonheating.json — Fixed and volumetric check done
• kedli_mf_heating.json — Fixed and volumetric check done
• kedny_sf_nonheating.json — Fixed and volumetric check done
• kedny_sf_heating.json — Fixed and volumetric check done
• kedny_mf_heating.json — Fixed and volumetric check done
• nfg.json — Fixed and volumetric check done
• nimo.json — Fixed and volumetric check done
• nyseg_nonheating.json — Fixed and volumetric check done
• nyseg_heating.json — Fixed and volumetric check done
• or.json — Fixed and volumetric check done
• rge.json — Fixed and volumetric check done
• Triangulation: 3–4 utilities’ volumetric rates looked up from the web and compared to CSV/URDB; summary in a comment or doc.

[linear]

RDP-124