A Guide for Energy Efficiency Program Sponsors
Leveraging ENERGY STAR Product Finder "Advanced View"
Last Updated June 18, 2014
Introduction
It is now easier than ever to customize ENERGY STAR-certified product lists to suit your
program needs. If your program requires promotion of a subset of efficient models in a product
category, filtered views let you seamlessly identify and display only the models that meet your
criteria while enabling you to leverage the valuable ENERGY STAR brand and the validation
that comes from knowing all ENERGY STAR models are third-party certified to meet
performance criteria and are subject to verification testing. (To learn more about third party
certification requirements visit energystar.gov/3rdpartvcert)
ENERGY STAR Product Finder now has new "Advanced View" functionality offered via Socrata,
an open data platform for accessing public information. In addition to filtering ENERGY STAR
product lists, you can use this tool to sort and visualize data to support program development
and implementation. Filtered views and visualizations may be linked to or embedded in your
webpage so they are automatically updated!
Below is just a sampling of the sort features available for product categories commonly
promoted by Energy Efficiency Program Sponsors*:
Sample Filters Available through ENERGY STAR Product Finder
(product attributes in development appear in italics)
Product Category
Unique filters
Cross-cutting filters
Clothes washers
• Load configuration
• Connected functionality
• ENERGY STAR Most Efficient
• Brand name
• Model name, model
number, additional
model information
• ENERGY STAR
unique model
identifier
• Date qualified
• Date available on
market
• Markets
• Energy use
• Efficiency ratios
Dishwashers
• US federal standard
• Water use
• ENERGY STAR Most Efficient
Refrigerators
• Connected functionality
• ENERGY STAR Most Efficient
Freezers
• Defrost type
• Connected functionality
Room air
conditioners
• Reverse cycle
Dehumidifiers
• Fan continuously operates
-------
Light fixtures
• Technology
• Capacity
• Light output
• Product type
• CCT
• Meets ENERGY
• CRI
STAR Most Efficient
• Special features
Criteria
• Power factor
• Light source Life
Light bulbs
• Technology
• Base type
• Light Output
• CCT
• CRI
• Special features
• Power factor
• Life Rating
• Warranty
• Dimming capability
Pool pumps
• Horsepower
• Speed setting
Commercial
• Configuration
refrigerators and
• Door options
freezers
• Refrigerant type
Commercial fryers
• Shortening capacity
Commercial ice
• Harvest rate
makers
• Ice hardness factor
• Water use
*Central heating and cooling products are also commonly promoted by efficiency programs; ENERGY STAR
continues to work with AHRI and CEE to provide information on ENERGY STAR certified CAC/ASHP products
through the CEE Directory at http://www.ceedirectorv.org/.
Below we provide illustrative examples to demonstrate the new functionality and walk you
through common tasks. Additional information on these new features is available at
https://data.enerqvstar.gov/videos.
Getting Started
In order to save or share your work, you will need to create an account at
https://data.energystar.gov.
1. Click on the "Sign Up" link on the top right of the page, and follow the prompts
2. After you've set up your account, you will be logged in. Go to https://data.energystar.gov
to return to the datasets you would like to work with.
Creating a Filtered Dataset
As an example of how to create a filter to show a subset of ENERGY STAR products, we will
filter the residential clothes washer product list to highlight only products that have an MEF
greater than 2.39 and a Water Factor less than 4.1 (CEE Tier 3). Note that filtered data views
are already available for ENERGY STAR Most Efficient products.
-------
1
Go to https://data.enerqystar.gov and click the link "ENERGY STAR Certified Residential
Clothes Washers" (alternately use the search feature and input "clothes washer.")
2. Once the link is open, click the Filter button BHJilin the top navigation bar
3. A new Filter frame should appear on the right side of the screen, click
Add a New Filter Condition
PD ID -
(the first attribute in the data set) and scroll
4. Click on the down arrow next to
Modified Energy
down to select Factor (MEF) . g new pj^er
Modified Energy Factor (MEF) r is , , , . ,
•' •' should appear in the Filter frame.
5. Click on the down arrow next to "is" and scroll to select "greater than"
6. In the box below, enter "2.39" and check the box to the left.
7. Repeat steps 3-6, selecting PD_ID then Water Factor as the attribute, "less than" as the
condition, and inputting "4.1" as the value.
Modified Energy Factor is
greater than '
Samsung
2.39
Water Factor (WF) t is less than
Add a New Filter Condition
8. If you wish to Sort the data based on highest to lowest MEF, click on Sort & RoI|-up
above the filter subsection and select Sort. Then select Modified Energy Factor as the
Column with Descending as the Direction. You may also add a column if you want to
Apply
apply a secondary sort for other attributes. Scroll down and click
9. You can export this data set using any of the options described in "Export Options"
below or create an account to save and/or share this data view with others.
-------
Creating Visuals
Perhaps you are planning to modify the mix of technology you promote for your residential
lighting program to include more specialty bulbs and want to share background with your team
about the availability of ENERGY STAR certified models by bulb type.
Number of Different ENERGY STAR Light Bulb Types
Part 1. Structure Data needed for Visual
1. Go to https://data.eneravstar.gov and click the link for the dataset you're interested in
using.
2. On the top of the dataset click
3. Click sort a Roii-up
Y Filter
ENERGY STAR Certified Light Bulbs
Certified models meet all ENERGY STAR requirements ~
ENERGY STAR Partner
I o I Find in this Dataset
l@
# Edit I # Manage I OO More Views I f Filter I Visualize I Q Export I Discuss l<> Embed I About
Filter
0 IS Brand Name
Conditional Formatting 4 ~
Cande
1234 ;=
Feit Electric
Feit Electric
1235 :=
Technical Consumer Products. Inc. (TCP)
DuraBright
fsort& Roll-Up 1 4
1236 :=
Technical Consumer Products. Inc. (TCP)
DuraBright
1 Fitter
-------
Unsaved View | Save As... Revert
Based on ENERGY STAR Certified; Light Bulbs
Certified models meet all ENERGY STAR requirements as ~
Bulb Type
0 := Model Number
©;=
~ Q* Find in this Dataset
Edit I Manage I OD More Views
j/ Visualize I Q Export
Filter
{ ) Embed I About
2 ;=
JDi BA-Bulged with angular tip
2
3 :E
JDt Covered-Post
6
4 ;=
£)> Covered
Jj6_
5 :=
£)l Other
|e
6 3=
JDi Covered bullet
1
7 :=
Covered Bullet
3
s ;=
£» B-Bulged
I21
9 :=
f. > Covered Post
30
10 :=
JDt Covered Candle
97
11 :=
£)~ Covered A-line
329
12 :=
£» Covered Globe
263
13 :=
jQl> Covered Reflector
684
/ Roll-Ups & Drill-Downs
i
O Group By
~ Bulb Type
O Add Grouping Column
O Roll-Up Model Number
Function Count
-G
O Add Roll-Up Column
Apply
8. When finished, scroll down and click
g | Save As...
Apply
if you would like to come back to the filter. You can also save at any point
later when creating the visualization.
Now you have a structured view of the product dataset and can proceed with creating a
column chart, bar chart, pie chart, and many more visualizations.
Number of Different ENERGY STAR Light Bulb Types
Part 2. Create Bar Chart
1. On the top of the dataset click
2 In the Visualization section, click
Stacked
Column
3. In
Data Selection
click
Chart Definition
a. Can alphabetize and group data by clicking
~ Advanced Data Selection
-------
Unsaved View Save As... | | Revert |
Based cm ENERGY STAR Certified Light Bulbs
Certified models meet all ENERGY STAR requirements as ~
3 Find in this Dataset
m
& Etftt I # Manage I h
Y Fitter I j/ Visualize I |~^ Export I Discuss I ( ) E
6.00K
4.00K
2.0 OK
0.00
. I
Visualize
Data Selection
~ Cti art Definition
'cC10
%% % 9b/9 ^
Choose label data
Bulb Type
I Model Number
V %
Choose value data
Model Number
Bulb Type O Model Number
1 :E £)> Bare Tube-Other 23
0 =
2 := BA-Bulged with angular tip 2
3 ;= & Covered-Post
O Add Data Column
~ Advanced Data Selection
Data Presentation
~ Colors
\\\
ill
Data Presentation
Chart Details
4. and provide additional options for customizing the
visual look of your graph including colors, labels and values, and several other options.
Number of Different ENERGY STAR Light Bulb Types
Part 3: Create a Pie Chart
1. On the top of the dataset click
[/ Visualize
2. In the Visualization section, click
3.
Data Selection
In liiiiiEijttiUiUI click M&£UlSfaUlMilB and select values for required fields.
a. For example, a pie chart based on a filtering of light bulbs by bulb type, counted
by model numbers.
Light Bulbs Bulb Type Pie Chart
Based on ENERGY STAR Certified Light Bulbs
Certified models meet all ENERGY STAR requirements ~
Other
BR - Bulged Reflector
Covered Globe
MR - Multifaceted reflector
A - Arbitrary (standard incandescent shape)
Covered A-line
Non-Standard
Covered Reflector
PAR - Parabolic Aluminum Reflector
Find in this Dataset
^ Manage I CIO More Views I y Filter
nn
Visualize I Export »- <> Embed I About
Visualize
Pie Donut Line Area
Bubble Tree Map
| Bare Spiral ¦ PAR -Parabolic Aluminum Reflector ¦ Covered Reflector
¦ Non-Standard ¦ Covered A-line
M A- Arhitrarv (standard innandfisnent shane) M MR - Mnltifanftted reflector
Data Selection
w Chart Definition
Bulb Type
0 •= Model Number
e =
¦V
1 is. Bare Spiral
4.174
¦
2 i= PAR - Parabolic Aluminum Reflector 1.757
3 •= Covered Reflector
714
-
* Choose label data
Bulb Type
Choose value data
Model Number
r
-------
4.
Data Presentation Chart Details
provide additional options for customizing the
visual look of your graph including colors, labels and values, and several other options.
You may also want to view trends associated with energy use of products by size. The following
example shows how you could look at the energy use of TVs by screen size.
Energy Use of TVs by Screen Size
Part 1. Structure Data needed for Visual
1. Go to https://data.enerqystar.gov and click the link for the dataset you're interested in
using.
2. On the top of the dataset click
3. Click sort a Roii-up
4 Click ^ Rofl-Ups & Drill-Downs
5 O Group By allows comparison of items for the field selected.
6. Select "Estimated Annual Energy Use (kWh/year)"
O Add Grouping Column
7. Click then select "Size (in)".
8. © Roii-up jS w(-,at yOU vvouid ij^e to count.
a. For example, model numbers.
b. Model numbers or PD_ID, an EPA-generated identifier, is recommended if the
visualization is intended to count number of models.
9. Roll Up Function allows counting of non-numeric fields, such as Brand Name, and
provides additional options for numeric fields, such as energy use per year.
10. Click 4 Sort , select "Estimated Annual Energy Use (kWh/year)" and direction
Descending.
O Add Column
11. Click then select "Size (in.)" and direction Ascending.
12. Sorting function allows information to be more cleanly and quickly processed for
displaying visuals.
13. When finished, scroll down and click
Save As
Apply
14.
if you would like to come back to the filter. You can also save at any point
later when creating the visualization.
Energy Use of TVs by Screen Size
Part 2. Create Line Chart
1. On the top of the dataset click
f/ Visualize
2. In the Visualization section, click Line
3. In
Data Selection
click
~ Chart Definition
and select values for required fields.
-------
4. For example, a pie chart based on a filtering of televisions by estimated annual energy
5.
6.
7.
~ Axis Options |
allows for adding X-axis and Y-axis labels.
Flyout Details
allows for selecting
pop-up attributes when hovering over data,
provide additional options for customizing the
Data Presentation
and
Chart Details
visual look of your graph including colors, labels and values, and several other options.
Annual Energy Usage Compared to S.
Based on ENERGY STAR Certified Televisions —
Certified models meet all ENERGY STAR requiremrfnp
I Find in this Dataset
65
70
Size (in.) 70
Estimated Annual Energy Use
(kWh/yr) 185.7
tiVxeViews I Y Filter I Visualize I Q Export I QP Discus I Embed I 0 About
Visualize
80 80 80 80
80
' Flyout Details
70 69.51 70'
59.58
59.559 5 59 90 37
31.54
Q Annual Energy Use (kWh/year)"^]
Flyout Title
Size (in.)
Flyout Values
Estimated Annual Energ..
O Add Values
Size (in.) 0 IE Estimated Annual Energy Use (kWh/yr)
1 := £>~ 65 £>~
Totals 55,073.48
0 •= Model n'
671.7 1
122,579.2
* Axis Options
^ X-Axis Title j
Value: ZOO
l¥7I
Annual Energy Use (kWh/ye
1
T ^ Y-Axis Title | size (inches)
Embedding Visuals in Your Application
Once you have created and saved your visuals or filtered views, you can embed them in your
application, by publishing your work using the feature.
Export Options
You are able to export datasets and filtered data views in a number of different formats using
the option and downloading the data. Options include CSV, JSON, PDF, RDF, RSS,
XLS, XLSX, and XML
Please note that for select datasets with greater than 65,000 rows, Socrata does not support
downloading directly to xls or xlsx; however you can download these datasets as a CSV file and
open using Excel with minimum loss of formatting.
Datasets are also available using the Socrata Open Data API (SODA). Further guidance on
using the API is available at data.energystar.gov/api/developers.
Contact Us
Questions? Please email us at enerqvstarproducts@energvstar.gov
------- |