Transcript Slide 1

ELCAP Database Walkthrough of
Web Portal
Regional Technical Forum
March 20, 2013
Purpose of Project
Assemble the digital and written elements
of the End Use Load and Consumer
Assessment Program (ELCAP) data and
convert them into a searchable database
Principal Investigators:
•
•
•
•
Aaron Jenniges
Ryan Kilkenny
Niko Drake-McLaughlin
Matei Perussi
The Cadmus Group, Inc.
Four Main Components
• Raw hourly site level meter and weather station data
– 458 building sites, 41 weather sites
– Data range April 1, 1987 to August 31, 1989
• Pacific Northwest National Laboratory (PNNL) data,
containing site characteristics
• Summary files containing aggregated tables based on
summarized hourly load data
• Reports on analysis conducted on ELCAP load data
Number of Sites by Category
Category
Commercial1
63
Commercial Audit Program
16
Multifamily2
5
Purchase of Energy Savings3
0
Residential4
Residential Standards Demonstration Program
1
Number of
Sites
256
83
There were 81 commercial sites in the raw data; 18 sites could not be linked to characteristics data and were excluded from the
searchable database.
1 There were 17 multifamily sites in the raw data; 12 sites could not be linked to characteristics data and were excluded from the
searchable database.
1 There were 4 PES sites in the raw data; 4 sites could not be linked to characteristics data and were excluded from the searchable
database.
1 There were 257 residential sites in the raw data; 1 site could not be linked to characteristics data and were excluded from the
searchable database.
Products
• Report on File Contents
– Describes what found in raw data files
– Identifies data files excluded
– Describes Adobe Acrobat and Microsoft Word
document reports are included
– Lays out database schema
– Appendices A-M: Excel workbook of
ELCAP Data Assembly and
Conversion Project: Report
on File Contents
• File descriptions, abbreviations, translations
• Data field comparisons
• Matrix of site numbers
• Modern Accessible Database!
December 14, 2012
Available for All the World
http://rtf.nwcouncil.org/ELCAP/