How to Cost Effec,vely Get Energy & Billing Data for 1,000+ Metered
Loca,ons
featuring:
Introduc,ons Erik Becker VP Sales Urjanet
Robert Fairey Director of Energy Procurement Cox Enterprises
Paul Baier VP, Sustainability Consulting & Research Groom Energy
Agenda Urjanet Introduction
Robert Fairey • Cox Enterprises Overview • Utility Data Challenges • Evaluating Potential Solutions • Results • Lessons Learned
Paul Baier • Don’t Underestimate the Cost of Obtaining Energy Data • Highlights of Greenbiz/Groom Survey of Corp. Energy Mgrs. • Overview of Enterprise Smart Grid Framework
Q&A
The Problem Urjanet Addresses
“Data acquisition can represent up to 50% of the overall energy or sustainability management project cost and causes risk to the project success.”
Paul Baier VP, Sustainability Consulting & Research
What Is Urjanet? A single, automated, consistent stream of energy and
resource data from a diversity of data sources
A A A
Utility Bills
> Electric
> Water
> Natural Gas
Weather Data
Advanced Metering Data
Urjanet Partner Apps & Services
Urjanet Products
Automated access to utility bill data across the thousands of providers in North America and abroad. Learn more ›
Access to AMI (Advanced Metering Infrastructure) interval data from the utility providers without installing any hardware or software. Learn more ›
Framework for being notified of billing and consumption irregularities and anomalies to enable quick action. Learn more ›
Calculate the impact of seasonal shi9s and weather events on your loca=on’s energy use. Learn more ›
Cox Enterprises Overview
Cox Enterprises is a leading communications, media and automotive services company with revenues of nearly $15B and more than 60,000 employees.
Television and radio stations, digital media, newspapers, and advertising sales rep firms
Online automotive classifieds; Kelley Blue Book, vAuto and HomeNet Automotive
subsidiaries
Cable TV distribution, telephone, high-speed Internet access, commercial telecommunications
& advertising solutions
Vehicle auctions, repair and certification services, and web-based technology products
Energy Procurement Roles at Cox
• Elevate De-Regulated Market Awareness • Provide Visibility & Transparency • Collaboration with Departments & Subsidiaries • Dependable Resource for Energy Information • Increase Free Cash Flow • Asset Optimization
Data is Key to All of This!
Challenges Data Volume: • $100 + million annual spend on electricity & natural gas
• 32,000 separate accounts across 310 utility providers
Inefficient Data Collection Practices: • Contacting Cox subsidiaries across the U.S. for data
• Spreadsheets with manual data entry
Results: • Always falling behind with time-consuming collection process
• Data entry errors
• Data wasn’t current
• Limited visibility into consumption & pricing
Objec,ves: Energy Repor,ng Project • Eliminate manual data entry – create an automated
data feed to collect, reconcile, analyze and report on energy consumption & costs
• Connectivity to in-house energy dashboard
• Deliver highly accurate data
• Flexible solution that scales as needed
• Make data available company-wide
• Cost-effective
• Create view of current consumption & spending, as well as a accurate view over time
Solu,on & System Evalua,ons
We evaluated many systems, but all had flaws:
• No connection to our Energy Dashboard
• Were primarily bill payment providers
• Ultimately, the vendors wanted to put us into inflexible model that wouldn’t help us meet our primary objective: to get smarter around energy rates, pricing & consumption.
Ultimately chose Urjanet’s energy data service because of service quality, flexibility & cost.
Results
How Cox Enterprises Operates Today
Suppor,ng Systems / Processes • Financial Data (ERP) • Business Metrics
ETL
ETL
Data Delivered by the Cox Energy Group • Weather Data (HDD, CDD) • U=lity Account to ERP Loca=on Mapping • Weather Zone
Energy Data Warehouse
Hyperion Essbase
Dashboard
• Calculate CFP • Calculate Energy Metrics
CCI Accoun,ng (Blackline)
Collects data from 1000s of
U=lity accounts at the meter level and provides FTP
to Cox
Power Supply Op,miza,on
Priority MARKET / U,lity
Name #
Metered
Metered kWh's / Mos Apiece
# Un-‐Metered
Un-‐Metered KWh's / Mos Apiece
Calculated Avg Price /
kWh
1 OMAHA/SUN VALLEY
OPPD 796 1500 $0.112
Mid American
Energy 119 942 Idaho Power ? 160704 $0.072 2 SAN DIEGO SDG&E 1859 1100 $0.154
3 LOUISIANA, NEW ORLEANS
Lafaye_e U=li=es 154 450 $0.124 CLECO Entergy Louisiana 1052 500 $0.137 Entergy Gulf States 97 411 $0.131
Entergy New
Orleans 492 797 1094 376 $0.129 Dixie Electric 40 890 4 $0.099 SLEMCO 11 395 4 LAS VEGAS Nevada Energy 2280 684 $0.106 5 ARKANSAS SWEP (AEP) 496 349 $0.061 Entergy 172 438 $0.088
1) Exhaus=ve rate study for all power supplies na=onwide a) Rate Changes (NV Energy TOU rate
$93k annual savings) b) Metered vs. Un-‐Metered (un-‐
metered $.02 / kWh cheaper) c) Iden=fy incremental $ / kWh
2) Bill QA a) Zero-‐usage accounts (85 in Las
Vegas = $18k annual) b) Over-‐billed accounts
3) CCI Asset Management a) Omaha 121 / 295 eliminated
Energy Rate Analysis – Urjanet data
Tucson Electric Power • MTC GS-‐10 to LGS-‐13 saves $79,560 annual • TOU conversion 297 power supplies saves $15,414 annual Mid American Energy • TOU conversion 116 power supplies saves $51,442 annual Nevada Energy • TOU conversion 2280 power supplies saves $93,571 annual Salt River Project • TOU conversion 2143 power supplies saves $236,000
annual PSCO, OG&E analysis pending TOTAL = $475,987 annual so far
Overview, Account Detail
Custom Reports – VA Facili,es
Carbon Footprint Overview
Lessons Learned Automation Isn’t Just a Matter of Convenience • Be more strategic & get out of the data management business. • Not only saves time, but gives access to data weeks faster.
Ensure Buy-In From Executive Team on KPIs Be clear on KPIs that will be tracked – improving energy efficiency, tracking carbon footprint, etc.
Don’t Only Focus on the Front-End Reporting Tools Data is the foundation of any front-end tool you’ll use.
Involve Other Departments Energy data is used by many departments – involve them early in the project and take advantage of economies of scale!
Paul Baier, Groom Energy
Key Lesson
Don’t Underestimate the Cost of Obtaining Energy Data!
Securing accurate and complete energy data is a perennial implementation challenge that increases budgets and delays rollouts.
Types of Energy Data
Monthly Utility Billing Data
Interval Data • Interval data from main meter (delayed). • Interval data from main meter (real time). • Interval data from specific loads (real time).
Formula,ng a Strategy
1. Prioritize to Business Imperatives & Use Cases
2. Start With Utility Bill Data
3. Then Move to Selective Use of Interval Data for Certain Facilities
4. From Those, Develop Cost-Effective Energy Data Acquisition Strategy
Greenbiz/Groom Survey of Corporate Energy Managers
Top Two KPIs
Top Desired Features for EEMS
Enterprise Smart Grid Framework
200+ EMS Vendors in Confusing Market
Enterprise Smart Grid Framework The C&I Demand-‐Side
29
Visibility, Control and Management Integra,on
ESG Simplifies the Vendor Landscape
Summary
It simply does not matter how fancy the graphics, reports or dashboard from your EMS are if the data are not accurate, complete, and timely.
Key Takeaways
ü Get Executives Engaged in Developing KPIs
ü Keep Key Stakeholders Involved
ü Ensure Underlying Data Is Current & Accurate
ü Automated Data Aggregation Is Key
Q&A
Questions?