Charge City
Charge City: moving an EV charging network off spreadsheets
- Product
- Charge City
- Year
- 2023
- Industry
- Automotive
- Contributors
- Tarandeep R., Vineet M.
Results
- Faster maintenance response
- 50%
- More charger uptime
- 25%
- Saved per employee each month
- 30+ hrs
Context
An EV network run on spreadsheets
Charge City ran EV chargers across Delhi NCR, and a fault only surfaced when someone noticed and reported it. Interviews with 15+ operators showed the problem wasn't data entry: 80% of maintenance delays came from not knowing a charger was down. I designed the internal platform that replaced the sheets, with Tarandeep R. and Vineet M.
01Dashboard
First thing in the morning: is anything broken?
The control centre puts faults first, then sessions, revenue and energy, with a station view and inline controls to fix things.
Why: A fault should be something you click into, so every chart is paired with a list you can act on.
02Usage
Usage and energy
Sessions next to live energy and revenue, plus heatmaps for consumption, cost and peak usage across locations.
Why: Session data is huge, so operators start from a summary and drill in with filters and grouping.
03Payouts
Payouts and reports
Reports and payouts on one screen, with a live invoice preview before export.
Why: Revenue leakage was one of the starting problems, so finance sees exactly what they sign off without going back to a spreadsheet.
04Setup
The setup screens
Vehicles, locations, credentials and permissions, given the same care as the dashboards.
Why: Configuration is where mistakes get expensive, and different people run different parts of the network.
Outcome
What changed
- Maintenance response times dropped 50%.
- Charger uptime went up 25%.
- Accurate session tracking stopped the revenue leakage, and revenue transparency went up 15%.
- Each employee saved an estimated 30+ hours a month that used to go into spreadsheets.
- Energy insights helped cut waste and operating costs, and expansion and maintenance decisions could finally be based on data.
“Thanks again, the designs look amazing and the process had been smooth”
Hiring for product design, or building something new? Send the context and we can talk it through.
