To help you in further managing the data from your competition, use this template Competitor Data Tracker spreadsheet. Based on the template EPA refined through seven years of managing competitions for hundreds of buildings, it includes:
- Competition Setup tab with instructions, a place to set the Baseline and Final dates, and a dropdown to select specific evaluation metrics
- Data Request tab to paste Data Request information submitted through Portfolio Manager
- Alerts and Metrics tab with many of the data-scrubbing formulas, alerts, and checks that EPA developed to assist with data analysis
- Energy and Water Winners tabs that display top properties in each building-type category
- All Results tab to create a public-facing list of winners