Energy Data Collection and Tracking for Internal - PowerPoint Presentation

Energy Data Collection and Tracking for Internal Benchmarking and Energy Management:Best Practices from State and Local Governments and School Districts December 18, 2014 Mona KhalilDepartment of EnergyEEREWeatherization and Intergovernmental Program

DOE’s State & Local Technical Assistance

Visit the Solution Center www.eere.energy.gov/wip/solutioncenter/ Sign up for TAP Alerts, the TAP mailing list, for updates on our latest and greatest TechnicalAssistanceProgram@ee.doe.gov How to Tap into T hese and Other TAP Offerings

WIP – Who we are and what we do Mission: Accelerate deployment of energy efficiency and renewable energy technologies over a wide range of stakeholders in partnership with states and local governments. Strategic objective: “ Deploy the clean energy technologies we have” through near-term activities that result in greater energy efficiency, expanded renewable energy capacity, and economic development. Pathways: Financial assistance: Formula and competitive awards > $200 M per year to weatherize low-income homes, and assist states to deploy EE and RE projects and programs Voluntary programs: Better Buildings Challenge (BBC) & Accelerators Technical assistance: R esources to assist the public sector with planning, financing, evaluating and deploying EE and RE programs and projects

Coming in 2015 Best Practices in Energy Data Collection and Tracking in the Public Sector A new step-by-step guide on data tracking for internal benchmarking and energy management purposes featuring effective and replicable solutions that states, locals and K-12 are using to enhance their energy data management practices Step-by-step framework with five key elements for establishing a robust and sustainable energy data management system Detailed best practice profiles and tactics featuring state, municipal and K-12 practitioners Checklists, tools, and templates

Outline for Today’s PresentationBest Practices in Energy Data Collection and Tracking Study methodology Benefits of tracking energy useFive key elements for effective energy data tracking Examples of cities and a StateCase Study: Portland Public SchoolsKey takeaways

Best Practices Study Methodology Approach: Primary research through in-depth interviews with ~60 state and local governments, school districts and subject matter experts 10 states (NY, CA, DE, MA, MD, MN, RI, WI, NC, IA) 26 local governments (14 large cities, 7 medium, 5 small) 3 school districts (one small, one medium, and one large)  18 subject matter experts from public and not-for-profit organizations Best Practice Criteria: Solutions screened against specific criteria:EffectivenessReplicability SustainabilityImpactMetrics: Specific metrics to compare and rank solutionsEntities provided data/results as evidence of level of efficacy Principal metric: Energy and cost savings; Secondary metrics: time savings; change in resource requirements (cost, time, human capital); etc.

Interviewees report the ability to: Improve strategic energy management capabilitiesBuild the case to leadership on the value of energy management and gain additional support Improve control and transparency of energy costs and budgetsImprove operational efficiencyFacilitate demand response and energy purchasing Why track energy data? “Measuring your energy usage and cost is the first step to properly managing energy ” - City of Virginia Beach Mayor William Sessoms , Jr.

How did they get there? Asset Inventory Data Access Tools and Analytics Engagement Communication Organizational Structure Best Practices in Energy Data Management Five Elements for Success Comprehensive Centralized Verified Up to Date Comprehensive Streamlined Automatic Prompt Flexible Secure Accessible QA/QC Integrated Centralized Dedicated StaffStreamlined TargetedClearTransparent Mission-focused

Comprehensive Asset Inventory Asset Inventory

Streamlining Data Access Benefits Speed to data receipt: lower time gap between usage period and when data can be viewed Cost savings: use consumption, cost, demand charges, rate schedules, etc. to maximize savings Data quality: r educe errors introduced during data transfer, perform audits Operational efficiency: save staff time, reduce redundancy in operations, add value What do we mean by “streamlined data access ”? Electronic data transfer from utility to customer Efficient and timely access to comprehensive utility billing data Monthly or more frequent energy use intervals Minimal manual data entry Data for all commodities and all energy- and water-using assets Data Access Utility 3 Utility 2 Your Organization Utility 1 Database

Most common approach for entities with municipal utilities with no other data access options Feasible to develop custom solutions Good option for entities with >100 accounts with EDI-capable utility Generally limited to electric and some natural gas IOUs Streamlines data transfer to Portfolio Manager facilitating benchmarking; additional sectors and functionalities added A growing number of utilities offer this solution Best option for medium to large entities with many vendors and data formats Least common but effective Emerging best practice solution for sharing near real-time and comprehensive bill data A growing number of utilities are adopting Green Button Consolidated Billing Electronic Data Interchange (EDI) Portfolio Manager Data Exchange Web Services Green Button Connect My Data Third Party Services Solutions for Streamlining Data Access

Contribution to Organizational Goals

Data Tools and Analytics Tools and Analytics

Organizational Structure Organizational Structure Accounts Payable Energy or Sustainability Office Data Entry Utility Bill Data Decentralized Accounts Payable Data Entry Accounts Payable Data Entry Energy or Sustainability Office Utility Bill Data Accounts Payable Data Entry Accounts Payable Centralized Accounts Payable

Organizational Structure Third Party Energy Database Energy Manager/ Engineer Energy Coordinator Accounts Payable Agencies/ Departments Department of General Services Utility Organizational Structure Example of a Partially-Centralized Organizational Structure

Engagement and Communications Engagement Communication Tailor Reports to Individual Audiences Create Transparency Drive participation through a uniform collection platform Establish Effective Working Groups Incentivize and Recognize Key Stakeholders Develop Partnerships

City of Knoxville, TN: Consolidated Billing Goal: Track and manage the city’s progress in achieving a 20% reduction in energy intensity by 2020 Solution: The City of Knoxville worked with the municipal utility to develop a consolidated bill containing electric, natural gas, water, and sewer cost and consumption data for the city’s facilities and non-metered fire hydrant and outdoor lighting infrastructure

City of Virginia Beach: Integrated Tracking & PaymentGoal: Improve efficiency of operations and control of energy budget Solution: The City of Virginia Beach has eliminated nearly 1,000 paper bills monthly, reducing staff time needed for data entry by 85% . VB metropolitan area is now ranked fourth among mid-sized cities for ENERGY STAR certified buildings. CVB received the Government Finance Officers Association’s Award for Innovation in Government for the utility bill management process

State of Maryland: Centralized Energy DatabaseGoal: Track consumption across all facilities (124 vendors, >16,000 utility accounts, 120 accounts payable departments, 58 agencies) Solution: A centralized energy data collection and tracking process using a third party to assist in the compilation of a central energy database, development of streamlined utility data access solutions, and maintenance of a transparent web-based portal . Annual energy budget >$200MM, Cost of contract: $0.8-1MM   FY2013 Block & Index Commodity Purchasing Savings ( Millions $)

Case Study: Portland Public Schools Leveraging a Third Party Service Provider to Streamline Data Entry Jeff Hamman, CEMEnergy SpecialistBuildings Operations and Energy Program Manager Portland Public Schoolsjhamman@pps.net

Portland Public Schools: Portland, ORLargest School District North of San Francisco Over 9 Million Square Feet Managed104 Facilities Managed 65 years Ave Building Age800+ Utility Accounts47,000+ Students6,000+ Staff$10.4M FY 13-14 Utility Budget Portland Public Schools: Building Portfolio

Portland Public Schools: Goals Achieve a 20% reduction in energy intensity by 2020 as per the Better Buildings Challenge goal Quicker access to data for analysis and reportingReallocate staff time to more productive matters Simplify invoice payment and processing Comply with a statewide mandate to report annual energy consumption

Portland Public Schools: Barrier Implementation cost Cost effectivenessProcurement, project management and implementation Accounts payable process integration Process Timeline from Bill Date Invoiced Received 1-2 weeks Payment Processed 2-3 weeks Manual Data Entry 4-12 weeks Usage and Cost Review 4-12 weeks Address Issues 6-12 weeksReporting 12-14 weeks Manual Data Entry

Portland Public Schools: Barrier School District Personnel Average Monthly Hours Saved Equivalent Internal Personnel and Other Savings Energy Specialist 20 $10,468 Resource Conservation Manager 8 $4,395 Finance Clerk I 18 $6,359 Annual Service Fee for Utility Database - $1,975 Total Savings 46$23,897

Portland Public Schools: Solution Portland Public Schools (PPS) contracted with a third party energy and utility management company to develop a comprehensive solution for its utility data access, tracking, and processing needs. Continuous utility bill data entry Invoice processing and auditing Late fee avoidance Missing invoice/late arriving notification Correspondence and bill insert Invoice archiving Improved reporting capabilities including custom reports Budget tracking, analysis and modeling Annual review of utility rate schedules Automatic Energy Star upload Web-based platform, enabling access to data to a greater number of staff Training and technical assistance Utility Bill Management Energy Management Tool

Portland Public Schools: Solution New Data Portal and Invoice Processing Work Flow

Portland Public Schools: Outcomes Manual data entry of utility bills is virtually eliminated through the third party vendor contract Staff time reallocated to address usage anomalies and improve the energy performance of school facilitiesDecreased invoice processing timesAutomated usage and cost notifications Process flow efficienciesAccess to data

Portland Public Schools: Outcomes

Portland Public Schools: Outcomes Current Issues

Portland Public Schools: Outcomes

Portland Public Schools: Outcomes

Key TakeawaysA robust data tracking strategy is a foundation for strategic energy management and pays additional dividends Development of a robust tracking system takes time Dialogue and collaboration with utilities is critical to develop and implement a streamlined data access solutionsMedium to large entities use a combination of approaches to gain access to data A robust analysis tool is critical for “making good use of the data collected”An integrated and centralized structure can create a win-win situation for all stakeholders It’s important to implement available solutions, while remaining flexible to adopt new and more efficacious solutions as they become available

ContactsMona Khalil Policy and Technical AssistanceWeatherization and Intergovernmental ProgramDOE EERE Mona.Khalil@ee.doe.govPhone: 202-586-7983 Jeff Hamman, CEM Energy Specialist Buildings Operations and Energy Program Manager Portland Public Schools jhamman@pps.net WIP State & Local Solution Center