A data-informed planning tool for electric cooperatives — projecting EV adoption impacts across your distribution network at the substation, circuit, and transformer level.
EV Adoption Projections·Load Growth Modeling·Transformer Load Analysis·Geospatial EV Footprint·Investment Prioritization
About the Grant
What is REWIRED?
REWIRED — Rural Electric Utility Workflow Improvements for Rapid EVSE Deployment — is a cooperative agreement between NRECA Research and the U.S. Department of Energy's EERE, providing over $2 million in federal funding from June 2024 to May 2027.
Led by NRECA Research in partnership with BrillIT and guided by a Cooperative Advisory Board representing all ten NRECA regions, REWIRED is a direct response to the unique challenges cooperatives face in deploying EV charging infrastructure at scale.
Key Objectives
What REWIRED aims to accomplish
01
Improve EVSE Deployment Efficiency
Streamline and standardize EVSE deployment processes, reducing time, cost, and complexity in rural areas.
02
Support Grid Management & Reliability
Develop tools to help cooperatives manage increased EV-driven demand and ensure reliable integration of charging infrastructure.
03
Enhance Member Satisfaction
Enable faster, more informed deployment of EVSE so members have reliable and accessible charging options.
04
Establish a Cooperative Advisory Board
Engage co-op representatives from all ten NRECA regions to contribute real-world data and insights.
Capabilities
What does this tool do?
EV Adoption Projections
Projects EV growth annually through 2050 using EIA AEO scenarios — Reference, Low EV, and High EV cases.
Demand Growth & Load Modeling
Estimates incremental demand impact at the substation and circuit level with coincident peak adjustments.
Transformer Load Analysis
Evaluates transformer loading under residential non-coincident peak demand with RUS and IEEE guidance.
Geospatial EV Footprint
Interactive map of transformer load status — current state and projected 2036 — across your service territory.
Circuit & Substation Ranking
Tabular summaries ranking substations and circuits by overloaded transformer count for capital planning.
Scenario Comparison
Switch between EIA AEO scenarios without re-uploading data to stress-test against multiple futures.
Workflow
Three steps to your analysis
1
Overview
Understand the tool and methodology
Review what data you'll need, how projections are built, and what outputs the analysis provides.
You are here
2
Upload Data
Provide two CSV datasets from your cooperative
Upload a Distribution Transformer file and a Meter Data file listing each residential meter with peak load.
Upload your data →
3
Analysis
Review projections and download results
The dashboard runs load modeling and EV adoption projections producing tabular and visual outputs.
View results →
Data Privacy
Your data stays yours — always
In-Memory Processing Only
Uploaded datasets drive a one-time analysis then are wiped. Nothing is ever written to disk.
Encrypted Transit
All data paths are secured with TLS from upload through completion of analysis.
Never Stored or Shared
We never retain copies of your raw data or share it with third parties.
Session-Scoped Access
Data is available only within your active browser session and does not persist between visits.
Upload Data
Two input datasets are required. All data is validated client-side before upload and processed entirely in memory — nothing is written to disk.
Distribution Transformers
Purpose
A simplified picture of your grid — every residential transformer with capacity limits and geographic coordinates.
NOTE — Headers must match exactly. Use the template below as a starting point.
📂
Drop transformer CSV here or click to browse
CSV only · headers required
No file selected
Transformer Data Preview
First 5 rows▼
SUB #
SUB NAME
CIRCUIT #
CIRCUIT NAME
TX ID
LAT
LON
RATING
Meter Data
Purpose
A simplified view of residential demand — each meter's transformer assignment and peak load value (ideally individual peak demand within the last 12 months).
Required fields
TRANSFORMER_ID_NUMBERMETER_IDPEAK_LOAD
NOTE — Headers must match exactly. PEAK_LOAD should be in kW.
📂
Drop meter CSV here or click to browse
CSV only · headers required
No file selected
Meter Data Preview
First 5 rows▼
TRANSFORMER_ID_NUMBER
METER_ID
PEAK_LOAD
Run Analysis
Upload both datasets above then run the full EV propensity analysis. All three EIA scenarios are computed in one pass — you can switch between them on the results screen.
○Transformer data uploaded
○Meter data uploaded
✓All 3 EIA scenarios will be computed
Running Analysis
Uploading CSV files
Computing transformer capacity labels
Running EV propensity model
Aggregating all three scenarios
Rendering charts and maps
Starting…0s elapsed
Analysis Results
EV Adoption Projections
Projected EV Growth Across Your Service Territory
The charts below display projected substation and circuit-level EV penetration (left) paired with system-wide adoption curves and demand across all
EIA scenarios
(right). These projections are the result of the REWIRED EV propensity model, which estimates the number of EVs likely to be adopted by consumers in the future. Projections are based on the EIA Annual Energy Outlook report, using a proprietary modeling process to adapt to the specific cooperative's service territory based on the data provided. Further details can be found in the methodology section above.
5-Year Substation · Circuit EV Projection
Substation / Circuit
Trend
2026
2027
2028
2029
2030
2031
System EV Adoption Projection
Projected Coincident Peak Demand
kW
Transformer Load Map
EV Charging Capacity by Transformer
Each point represents a distribution transformer. Dot color shifts as projected load increases (see chart legend). Scrub or play the timeline to watch stress patterns emerge across the network.
Transformer EV Capacity Map
2025 — Current State
Load vs Rated Capacity
Overloaded (≥100%)
Heavily loaded (≥85%)
Moderately loaded (≥70%)
Lightly loaded (≥50%)
Well within capacity
Transformer Load Analysis
Distribution Transformer Loading at Peak EV Demand
This analysis evaluates distribution transformer loading under residential non-coincident peak demand conditions based on provided data, with adjustments for diversity to approximate coincident peaks in accordance with RUS and IEEE planning guidance [1][2]. Transformer classifications: Overloaded — estimated coincident demand exceeds rated capacity at 0.95 PF; Car — headroom supports one residential Level 2 charger; Truck — headroom supports a full truck-rated charger.
EV Charging Capacity by Substation
OverloadedTruckCar
Circuit Load Summary
✕
Substation
Circuit
Total
Car
Truck
Overloaded
Top Circuits by Overloaded Transformers
REWIRED Methodology · End-user Guide
How REWIRED estimates EVs today and projects future growth
REWIRED answers two planning questions: where EVs are likely located now, and how EV counts could change over time under different EIA scenarios. The sections below explain what is estimated, how it is built, and how it should be used.
2-Stage
Present-day estimate + future scenario scaling
R2 0.682
Test-set fit (EV count estimate)
MAE 50.5
EVs per tract (test set average error)
EIA
Scenario source for future growth curves
1
Scope
What the estimate represents
REWIRED estimates battery electric vehicles (BEVs) associated with residential members at a census-tract level, then projects how those local counts could evolve under selected EIA Annual Energy Outlook scenarios.
Included and excluded
The estimate includes BEVs regardless of charging method (Level 1, Level 2, or other). It does not include conventional hybrids, plug-in hybrids, or hydrogen vehicles.
Results describe community-level prevalence, not household-level ownership. They reflect resident-associated EVs rather than temporary through-traffic or visitors.
Use case: planning estimates for grid and infrastructure decisions, not exact counts for every tract or a guaranteed forecast of future adoption.
2
Stage 1
How present-day EV prevalence is estimated
BrillIT's proprietary model starts with observed adoption, adds nationwide Census descriptors, aligns boundaries with crosswalks, and estimates present-day EV prevalence in every tract.
A
Observed EV adoption signals
Atlas EV Hub provides registration information where participating agencies publish it. Coverage and geographic detail vary by source, so observed data alone is not sufficient for a complete national view.
B
Community characteristics from ACS
REWIRED uses U.S. Census American Community Survey characteristics such as households, housing, income, population density, education, and commuting patterns to describe each community consistently.
C
Geographic boundary alignment
Registration and Census datasets often use different boundaries (for example ZIP code versus tract). Standard crosswalks align these boundaries so estimates are produced at a consistent census-tract level.
D
Random Forest prevalence estimate
A Random Forest regression model learns how observed EV adoption varies with community characteristics, then estimates expected EV share in each tract and converts it to a present-day count using households, accounts, or meters.
Present-day EV count is estimated as: [Estimated household EV share] x [residential households or accounts in the tract]
3
Stage 2
How future growth is projected
Future trajectories come from the U.S. Energy Information Administration (EIA) Annual Energy Outlook. REWIRED does not invent a separate national growth curve; it applies EIA scenario multipliers to each tract's local baseline.
Projection formula
[Future EV count] = [Present-day EV count] x [EIA growth multiplier (year, scenario)]
Each census tract starts from its own estimated baseline. The selected EIA scenario then scales that baseline over time, allowing lower- and higher-growth planning ranges.
Scenario selection changes the entire growth path, not a single point estimate
Select in dashboard
Lower-growth case
Represents slower adoption conditions. Useful for downside stress testing and more conservative capacity planning.
Common planning baseline
Reference case
Policy-neutral scenario using current-law assumptions in the EIA outlook. Often used as a middle planning path.
Select in dashboard
Higher-growth case
Represents faster adoption conditions. Useful for upside sensitivity and earlier infrastructure readiness testing.
4
Model Performance
How the present-day model was evaluated
Performance metrics below are from held-out test data (locations not used for model training). They evaluate the present-day prevalence model, not the future accuracy of any EIA scenario.
Household EV share estimate
R2 0.621
Random Forest MAE 0.0106 (about 1.06 percentage points), compared with linear regression R2 0.387 and MAE 0.0145.
Random Forest
0.621
Linear
0.387
EV count estimate
R2 0.682
Random Forest MAE 50.5 EVs per tract, compared with linear regression R2 0.363 and MAE 75.9 EVs per tract.
Random Forest
0.682
Linear
0.363
These metrics indicate useful planning signal, but they are not a guarantee that every tract will be close to the average error. Some tracts will have lower error and some will have higher error.
5
Important Context
Assumptions and limitations
Like any planning model, REWIRED depends on assumptions about data coverage, transferability, boundary alignment, and local conditions that may diverge from national trends.
Data and geography
Registration inputs can vary in completeness, detail, and recency. Crosswalk alignment between ZIP, county, and tract boundaries introduces additional uncertainty.
Future trajectory
Future projections are driven by EIA national scenarios. Local adoption can move faster or slower due to policy, infrastructure, demographics, programs, or vehicle availability.
Interpretation guidance
Treat outputs as planning estimates rather than exact counts. The model estimates BEV prevalence and does not independently predict charging level mix or exact charging behavior by time and location.
As new registration data, ACS inputs, and EIA outlooks are published, the analysis should be refreshed so planning stays aligned with best-available evidence.
6
Decision Support
How cooperatives should use the results
REWIRED scenarios are intended to evaluate a range of plausible futures, not to declare one guaranteed outcome. External forecasts can provide directional reasonableness checks, but they do not validate every local tract estimate.
Planning Actions
Practical ways to apply REWIRED outputs
Identify potential stress areas early. Focus monitoring and engineering review where projected adoption and load pressure concentrate.
Compare lower and higher growth cases. Stress-test whether plans remain effective across different adoption paths.
Prioritize targeted field validation. Use results to decide where added local data collection is most valuable.
Support staged investment timing. Sequence upgrades based on projected risk windows instead of one-time all-at-once assumptions.
Refresh regularly. Update with new data releases so decisions continue to reflect current market and policy conditions.