Research
Financial and operating summary
FERC Form 2 (major interstate natural gas companies) as filed, from Catalyst Cooperative PUDL's raw XBRL database. Quantities in dekatherms (Dth).
Purchased power vs. market
Financial summary
Price
Data ($/MWh)
By category
By utility and category (click a utility for its items)
Items
By technology
By utility (click a utility for its plants)
Plants
By utility (click a utility to list its officers)
Officers
Trend (up to 8 utilities highlighted)
Ranking
Data
The data studies run on, beside the public data built in (FERC Form 1): data sets (each utility's facts for a test year: its books, customers, sales, tariffs and loads) and uploads kept for studies to use (hourly loads, load research samples, temperatures). By utility, newest year first: yours and those colleagues share.
Data set
Rates
Build a rate study for any Form 1 utility. Start from a pro forma template or design your own:
- Pro forma templates: a FERC transmission formula rate (Attachment O), ISO-NE regional and local network service, a state retail cost of service, or a wholesale requirements rate.
- Your own study: choose the revenue requirement type, how each function is classified, the classes, and the results.
Inputs are imported from the utility's Form 1 for the test year and can be overridden. Link a load study for allocation factors, attach workpapers, and export the study to Excel.
Study
Load
Enter or import metered class loads and turn them into allocation factors: coincident and non-coincident peaks (1CP to 12CP, seasonal, multi-year), energy, average & excess, average & peak, top hours, base-intermediate-peak and probability of dispatch. Saved load studies can be applied to a rate case in Rates' Class allocation step.
Import hourly loads (a timestamp column, then one kW column per class, and a system load column if you have one; 15- and 30-minute data work too) or monthly summaries (month, class, cp_kw, ncp_kw, mwh). Templates: hourly · monthly. Once saved, a study takes load research samples (one kW column per sampled customer), hourly temperatures for weather normalization, and produces the load research report.
Study
Sales forecast
Forecast a test year's customers, sales and billing demand by class from monthly history: each class's use per customer modeled on the weather, the calendar and the economic drivers you choose, with the diagnostics a reviewer expects, and each class's customers projected. Review the models, then apply the test year to a data set.
Upload the monthly class history (month, class, customers, mwh, kw) and the drivers (month, then hdd, cdd and any others, forecast months included). Templates: history · drivers.
Forecast
Depreciation
Create a study, then import Depreciation Workbench's upload templates: plant transactions (required), account mapping, account OLTs and depreciation scenarios. Files are recognized by their header row, so they can be chosen together in any order.
Import
Upload Depreciation Workbench's templates in order, one at a time or several together. Each file builds on the ones already on the study, and you'll see the result before anything is saved.
Curves
Delete this study
Deletes the study, its accounts, transactions, scenarios, life tables and groups. It can't be undone. Depreciation Workbench is not affected.
Regulatory
Regulatory
Welcome
Pick up where you left off, or start something new.
My studies and analytics
Your studies and saved analytics, newest first. Saved analytics re-run against the current data when opened.
Manage team
Invite people
Members use the app. Organization admins also manage this page: inviting and deactivating people, roles, study modules and password resets. Pending invitations hold a seat (and a seat in each study module chosen) until they're accepted, revoked or expire (7 days).
People
Pending invitations
Recent activity
Analyst & Company
Super admin
Organizations, licenses, every user, and the audit trail.
Organizations
Users
Super admins
Super admins are Analyst & Company staff who manage every organization, license and user. For security, super admin access can't be granted or removed in the app; it's changed directly in the database.