INTERACTIVE DEMOS

Energy

Grid Frequency Regulation EV Fleet Charging Optimization

A logistics company operates 800 electric delivery vans across 45 depots. Each van must be charged overnight to meet next-day routes, but grid demand charges during peak hours (4-9 PM) cost 3x the off-peak rate. The fleet manager needs to stagger charging across depots to minimize cost while ensuring all vans hit 80% SOC by 5 AM.

⚠Without coordination, 600 vans plugging in at 6 PM caused a $340K demand charge spike last month and tripped a depot transformer.

LIVEcharger_telemetry

van_id	depot	soc_pct	charge_rate_kw	grid_price_kwh	plug_in_time	ts
EV-0447	Depot-ATL-07	18	0	0.28	2024-03-15T17:42:00.000Z	2024-03-15T17:42:14.000Z
EV-0312	Depot-ATL-07	71	0	0.28	2024-03-15T17:38:00.000Z	2024-03-15T17:42:14.000Z
EV-0189	Depot-DFW-03	44	7.2	0.31	2024-03-15T17:15:00.000Z	2024-03-15T17:42:14.000Z
EV-0623	Depot-DFW-03	12	19.2	0.31	2024-03-15T16:55:00.000Z	2024-03-15T17:42:14.000Z
EV-0091	Depot-ORD-12	63	0	0.24	2024-03-15T17:30:00.000Z	2024-03-15T17:42:14.000Z
EV-0558	Depot-ORD-12	37	11.5	0.24	2024-03-15T17:10:00.000Z	2024-03-15T17:42:14.000Z

Streaming SQLRunning

▶Prioritize by SOC and departure time✓

CREATE MATERIALIZED VIEW charge_priority AS
SELECT
  ct.van_id,
  ct.depot,
  ct.soc_pct AS current_soc,
  r.required_kwh,
  r.departure_time,
  (80 - ct.soc_pct) * r.battery_capacity_kwh / 100.0 AS kwh_needed,
  EXTRACT(EPOCH FROM r.departure_time - NOW()) / 3600 AS hours_until_departure,
  CASE
    WHEN ct.soc_pct < 20 THEN 'P1_CRITICAL'
    WHEN ct.soc_pct < 40 THEN 'P2_URGENT'
    WHEN ct.soc_pct < 60 THEN 'P3_STANDARD'
    ELSE 'P4_DEFERRABLE'
  END AS priority,
  (80 - ct.soc_pct) * r.battery_capacity_kwh / 100.0
    / (EXTRACT(EPOCH FROM r.departure_time - NOW()) / 3600)
  AS required_charge_rate_kw
FROM charger_telemetry ct
JOIN fleet_routes r ON ct.van_id = r.van_id
WHERE ct.soc_pct < 80;

▶Optimize charge schedule against real-time grid pricing✓

charge_scheduleauto-updating

van_id	depot	current_soc	priority	scheduled_start	est_cost	window
EV-0447	Depot-ATL-07	18	P1_CRITICAL	2024-03-15T17:42:14.000Z	14.62	IMMEDIATE
EV-0623	Depot-DFW-03	12	P1_CRITICAL	2024-03-15T17:42:14.000Z	17.89	IMMEDIATE
EV-0558	Depot-ORD-12	37	P2_URGENT	2024-03-15T23:00:00.000Z	4.64	OFF_PEAK_DEFERRED
EV-0312	Depot-ATL-07	71	P4_DEFERRABLE	2024-03-15T23:00:00.000Z	0.97	OFF_PEAK_DEFERRED

✓RisingWave monitors SOC across all 800 vans in real time. Van EV-0447 arrives at 18% SOC needing priority charge, while EV-0312 at 71% SOC is deferred to the 11 PM off-peak window — saving $12K/night in demand charges.

Talk to Sales