Most energy consultants spend 60% of project time on data prep. Not analysis. Just getting numbers into spreadsheets.
I got a call last week from an energy consultant.
“Jan, I need help. My client sent me 47 PDF bills. Different formats. Three different utilities. I’m supposed to have insights ready by Friday.”
Sound familiar?
Here’s what usually happens:
BEFORE: THE DATA PREP NIGHTMARE
Week 1: Extract numbers from PDFs
- Manual typing from scanned bills
- Cross-reference meter IDs
- Hunt down missing months
- Build spreadsheet structure
Week 2: Clean and organize
- Fix date formats
- Match consumption periods
- Calculate missing kWh values
- Debug formula errors
Week 3: Set up analysis
- Research building coordinates
- Download weather data
- Build regression models
- Second-guess every calculation
Week 4: Create reports
- Format charts manually
- Write explanations
- Rebuild when client questions numbers
Four weeks. Every project.
AFTER: ED HANDLES THE HEAVY LIFTING
Day 1: Upload everything Setup projects for Client AB + drag 47 PDFs Ed extracts consumption data automatically Coordinates and metadata populated from address list
Same day: Initial insights ready Dashboards built from uploaded data Energy trends identified Anomalies flagged for review
Week 2: Advanced analysis 15-minute interval data added Submeters created for detailed tracking Weather normalization running Regression models validated
One day for data prep. One week for complete analysis. Same accuracy.
The difference? Ed doesn’t waste time on tasks computers should handle.
It focuses on what matters: Finding the story in your data.
Ready to try Ed?
Start with a 7-day free trial — upload data, normalize for weather, and generate savings reports in minutes.