HomeMy WebLinkAbout460556 OPOWER INC - CONTRACT - RFP - 7570 HOME EFFICIENCY REPORTS (3)AMENDMENT NO. 2 TO
SERVICES AGREEMENT
This Amendment No. 2 (“Amendment No. 2”) is dated and effective as of December 16, 2015 by and
between Opower, Inc. (“Opower”), and The City of Fort Collins (“Utility”), and amends the Services
Agreement executed between the parties dated as of May 1, 2014 and including any Statements of Work
issued thereunder (the “Agreement”).
WHEREAS, on March 18, 2015 the parties executed Amendment #01 to the Agreement
(“Amendment No. 1”) to extend the Agreement term and to add an Appropriation section to the
Agreement; and
WHEREAS the parties wish to amend the Agreement as set forth herein.
NOW, THEREFORE, in consideration of the foregoing and for other good and valuable
consideration, the receipt and sufficiency of which are hereby acknowledged, the parties agree to the
following:
1. General Release Services
A new table shall be added to Section 1 of Attachment A-1 of the Agreement after the existing table,
and shall read as follows:
PROGRAM YEAR 2-5*
AMI-enabled insights
Enhanced Home Energy Reports
Load Curve Archetypes Analysis
Up to 50,000 Designated Customers
2. Services Descriptions
A new Section 2 shall be added after Section 1 of Attachment A-1 of the Agreement, and shall read
as follows:
“2. SERVICES DESCRIPTIONS
SERVICE DESCRIPTION
Enhanced
Home Energy
Reports
Initial Enhanced Home Energy Reports will focus on
information and insights derived from existing monthly
usage data while introducing customers to the benefits
immediately available from AMI data. These Enhanced
Home Energy Reports are branded with the Utility’s logo
and achieve the Utility’s look-and-feel, achieving deeper
engagement between the customer and the Utility brand.
Enhanced Home Energy Reports typically include the
following modules in addition to existing modules on Home
DocuSign Envelope ID: D779C67F-C603-4986-B419-C8297E6BBE6E
2
Energy Reports:
Average Daily Usage – The AMI reports show the
customers which hours of the day they use the most,
on average.
Heating and Cooling Comparison – These modules
break out heating and cooling consumption for AMI
customers, based on energy use and weather data
from the previous winter and summer. The results are
compared to those of their neighbors. These modules
are deployed at the appropriate time(s) of the year.
Load Curve
Archetypes
Analysis
Load Curve Archetypes are common daily energy usage
patterns extracted from the collective interval data of utility
customers. Opower will analyze interval data of Utility
customers to determine each customer’s energy usage
patterns. Based on the analysis, Opower will assign an
overall, a weekday, and a weekend Load Curve Archetype
to each customer, each demonstrating an energy usage
profile similar to a profile in Opower database. Load Curve
Archetypes data will be made available via the Inside
Opower Data Exploration Tool (“Data Exploration”).
3. AMI Setup
An additional bullet point shall be added to the list in Section 2A (Data Transfer) of Attachment A-2 of
the Agreement and shall read as follows:
“AMI Data Setup
o Utility and Opower will work together to integrate AMI data into the existing Utility data
transfer on a mutually agreed implementation timeline. Utility will adhere to the Opower
Platform Data Transfer Standards and Interval (AMI) Data Standards technical brief
provided separately to the Utility. Work to be performed by Opower to complete data
integration includes, but is not limited to: (1) receipt, testing, validation, and loading of
AMI historical files; (2) receipt, testing, validation and loading of daily AMI iterative files.
o Utility will acknowledge by email that it has received, and can meet, the data transfer
standards set forth in the Opower Platform Interval (AMI) Data Standards.
o Opower requires 13 months of historical AMI data from Utility for any customers without
this data in Opower’s system.
o Utility will provide a unique identifier between the accounts in the AMI data file and the
iterative billing transfer files. If Utility moves to a different data format than Opower’s
data specifications, Utility and Opower will work to re-scope the data transfer
implementation.”
DocuSign Envelope ID: D779C67F-C603-4986-B419-C8297E6BBE6E
3
4. Implementation Schedule
Additional paragraphs shall be added to the end of Section 2D (Opower Implementation Schedule) of
Attachment A-2 of the Agreement, and shall read read as follows:
“Utility and Opower will mutually agree to a start date for implementation of AMI-enabled
insights (the “Start Date”).
Opower anticipates that the AMI Data Setup phase will be approximately 10 weeks from the Start
Date. Upon completion of this phase, Opower will execute Heating and Cooling Comparison
modules and Load Curve Archetypes. No later than the Start Date, Opower and Utility will finalize
dates for full implementation of all AMI-enabled insights.
Implementation timelines may vary depending on data quality and the availability of Utility
resources to ensure that data adheres to Opower’s data transfer requirements and that all
applicable Utility consents are provided. Utility will work with Opower to achieve implementation
milestones and Utility acknowledges that delays in completion of Utility tasks may result in
implementation delays.”
5. Load Curve Archetypes Analysis Implementation
A new section 2F shall be added to the end of Section 2 (Program Implementation) of Attachment A-
2 of the Agreement and shall read as follows:
“F. Load Curve Archetypes Analysis Implementation
Opower will analyze interval data of up to 50,000 Utility customers to determine each customer’s
energy usage patterns. Based on the analysis, Opower will assign a Load Curve Archetype to
each customer.
The output of Opower’s analysis will be the delivery of a flat file extract to Utility containing
each customer’s identification number as well as overall, weekday, and weekend Load Curve
Archetype identifiers. Opower and Utility will mutually agree on a file format (e.g. CSV) for
data delivery.
Opower will also provide an analysis summary document comprising the number of weekday
and weekend customers assigned and the distribution across different Load Curve
Archetypes. The summary document will also include a data specification for the extract file.
Opower will load customer Load Curve Archetype data into Opower’s segmentation and
targeting tools and into Data Exploration. This data will be available to Utility for application
in existing or future Opower programs.
The analysis will be run for non-solar energy customers with active accounts (“Analysis
Group”). Utility acknowledges that a proportion of customers may not be assigned Load
Curve Archetype identifiers during the analysis. This is due to gaps in data, quality or
quantity of historical interval data, account closures, and other reasons. Typically, 10 to 20
DocuSign Envelope ID: D779C67F-C603-4986-B419-C8297E6BBE6E
4
percent of customers may be designated as unassigned after such an analysis. Should the
proportion of unassigned customers in the Analysis Group become greater than 20%, Utility
and Opower will work together to diagnose and address data issues.
6. AMI Data Setup Payment Table
An additional section shall be added immediately after the Watersmart payment table in Attachment
A-3 (Payment Table) of the Agreement and shall read as follows:
“AMI-Enabled Insights Payment Table:
Opower will invoice Utility an additional $31,000 upon execution of Amendment No. 2 and Utility
will pay such amount in accordance with the Agreement. Thereafter, Opower will invoice Utility
for each payment set forth in the table below up to 30 days prior to each payment due date set
forth in the table below. Utility will pay each such invoice prior to the applicable payment due
date and in accordance with the Agreement. Program Years 3 through 5 are designated as
optional. Utility will notify Opower in writing at least 60 days before the end of a program year if
it wishes to renew the program.
7. Except as expressly amended by this Amendment No. 2, all other terms and conditions of the
Agreement, as previously amended by Amendment #01, shall remain in full force and effect.
DocuSign Envelope ID: D779C67F-C603-4986-B419-C8297E6BBE6E
5
EXECUTED as of the date first set forth above.
OPOWER, INC. THE CITY OF FORT COLLINS, COLORADO
Chief Financial Officer
Purchasing Director
Name
Name
Title Title
DocuSign Envelope ID: D779C67F-C603-4986-B419-C8297E6BBE6E
Thomas Kramer
cfo
Gerry Paul
Director of Purchasing & Risk Management