Task: Formula-prediction-context (source dataset: pge-random)

You are given an table region extracted from a real Excel spreadsheet, which is centered around a cell called "Target Cell" (labeled as "[Target Cell]" shown in the table below). The table region below includes up to 10 rows above/below the Target Cell, and 10 columns to the left/right of the Target Cell. 

Your task is to analyze the table context surrounding the Target Cell, and predict the most likely Excel formula that should go in the Target Cell. If multiple formulas are possible, choose the most reasonable or commonly used based on context.

1. Please follow the standard formula syntax in Excel, e.g. always begins with an equal sign (=).
2. Base your predicted formula on the surrounding table context, e.g., column headers, annotations, and data values in nearby cells.
3. No explanation — just output the formula itself in a JSON format: {"formula": "your_formula_here"}.

Input Excel Snippet in Markdown format:
|    | G                                                                                                                                                                                                                                                                                                                                                                                | H                                                                                                                                                                                                     | I          | J                   | K   | L                                |                M | N                         |                O |                P | Q                  |      R | S                                                                                                                                                   | T                                                                                                                                                                       | U   | V   | W                   | X                                                                                                                                                                                                           | Y                                                                                                                                                                                                                                                                                                                                                           | Z                         | AA                                                                                                                                                                              |
|---:|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-----------|:--------------------|:----|:---------------------------------|-----------------:|:--------------------------|-----------------:|-----------------:|:-------------------|-------:|:----------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----|:----|:--------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 11 | • Demonstrate whether the ever-increasing amounts of data can be mined and combined for targeted, cost-effective use for improved asset management.                                                                                                                                                                                                                              | • Overview of existing applications and data sources.                                                                                                                                                 | 2.25 years | 2013-09-19 00:00:00 | No  | Transmission; Distribution       |      1.2495e+06  | $1,900,000 - $2,320,000   |      1.79662e+06 | 316022           | 2112640.0500000003 |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for performance | N/A                                                                                                                                                                                                         | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | • 11 total bidders        | Space Time Insight                                                                                                                                                              |
|    | • Potential scenarios include risk-based asset management, safety hazard mitigation and proactive outage prediction using self-serve and virtual integration environments.                                                                                                                                                                                                       | • Assessment of existing data source quality.                                                                                                                                                         |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             | • 7 passed initial screen |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • High-level future business processes by functional area.                                                                                                                                            |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Inventory of asset risk algorithms (formulas or complexity) for “In Scope” asset classes.                                                                                                           |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • High-level Change Management Approach.                                                                                                                                                              |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Prioritized and phased implementation plan.                                                                                                                                                         |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Cost estimate for full implementation of the STAR project.                                                                                                                                          |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Proof of concept prototype.                                                                                                                                                                         |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 12 | • Test new tools and techniques for safe operation of Solid Blade in Oil Rotatory Switches.                                                                                                                                                                                                                                                                                      | • A working prototype for the various Solid Blade in Oil Rotatory Switch tools.                                                                                                                       | 2.5 years  | 2013-09-19 00:00:00 | No  | Transmission; Distribution       | 301808           | $464,000 - $567,000       | 383991           | 131277           | 515267.87999999966 |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for Performance | N/A                                                                                                                                                                                                         | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | 4                         | Two vendors chosen from RFP:                                                                                                                                                    |
|    | • Evaluate alternatives to decrease probability of injury to workers and public.                                                                                                                                                                                                                                                                                                 |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           | • Inertia Switch                                                                                                                                                                |
|    | • Help design a robotic tool to allow remote operation.                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           | • Trayer                                                                                                                                                                        |
|    | • Develop the necessary parts/adaptors to be used on various types (manufacturer, brand, age, etc.) of Solid Blade in Oil Rotatory Switches.                                                                                                                                                                                                                                     |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           | Issued Direct Award for Remote Solutions. They not respond to RFP, but shortly after competitive bid process completed, they announced independent creation of similar product. |
| 13 | • Assess new technologies and feasibility of application on the Distribution Networks.                                                                                                                                                                                                                                                                                           | • Modified or improved components identified for use on Distribution Network Monitoring System.                                                                                                       | 3.25 years | 2013-09-19 00:00:00 | No  | Transmission; Distribution       | 484250           | $450,000 - $550,000       | 543414           |   4267           | 547681             |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for performance | N/A                                                                                                                                                                                                         | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | Phase I: 5 bids           | Phase 1: Black and Veach                                                                                                                                                        |
|    | • Primary focus on technologies, components and work methods to extend the life expectancy of monitoring systems equipment and reduce long term maintenance costs.                                                                                                                                                                                                               | • Improved installation and construction work methods.                                                                                                                                                |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             | Phase 2: 8 bids           | Phase 2: Exponent                                                                                                                                                               |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Economic model for maintenance variables based on life expectancy testing of components.                                                                                                            |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Changes to components.                                                                                                                                                                              |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 14 | • Install and test 90 DSR units on the Las Positas-Newark 230 kV line.                                                                                                                                                                                                                                                                                                           | • Installation, testing and analysis of DSR and server communication links.                                                                                                                           | 3.25 years | 2013-09-19 00:00:00 | No  | Transmission                     |      1.44984e+06 | $2,2100,00 - $2,710,000   |      1.55735e+06 | 902381           | 2459732.3000000017 |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for Performance | N/A                                                                                                                                                                                                         | Sole Source - Smart Wires, Inc. selected as they are the developer and sole supplier of DSR devices.                                                                                                                                                                                                                                                        | N/A                       | N/A                                                                                                                                                                             |
|    | • Install and test Server at PG&E’s San Francisco General Office (SFGO) headquarters, complete with Smart Wire System Manager Software.                                                                                                                                                                                                                                          | • Procure, construct and test the DSRs.                                                                                                                                                               |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | • Communication links between the DSRs and server to support the DSR monitoring and control.                                                                                                                                                                                                                                                                                     | • White paper describing project including go/no go recommendation.                                                                                                                                   |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Final report describing overall project, including finding from the operations and testing of DSR units and a recommendation as to whether or not to install the DSRs elsewhere in the PG&E system. |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 15 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Transmission; Distribution       |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 16 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Distribution                     |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 17 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Transmission; Distribution       |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 18 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Transmission; Distribution       |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 19 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Transmission; Distribution       |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 20 | • Leverage the existing SmartMeter™ network to support additional applications.  Inform future uses of the SmartMeter™ network such as message capability, security, latency, and engineering constraints.  Specifically focus on:                                                                                                                                               | • Evaluate new applications and devices, their associated data traffic impact on the SmartMeter™ network, and recommend which items warrant consideration for full scale deployment.                  | 3.25years  | 2013-09-19 00:00:00 | No  | Distribution;                    |      3.98628e+06 | $3,780,000 - $4,550,000   |      3.32588e+06 | 809376           | 4135257.490000001  |   0    | No                                                                                                                                                  | N/A                                                                                                                                                                     | N/A | N/A | Pay for Performance | • Provisional patent filed for Smart Pole Meter and Meter Socket                                                                                                                                            | Sole Source - Silver Springs Network selected as they solutions provider for PG&E’s AMI electric network. It is necessary to work with SSN to ensure that devices and applications can communicate across the AMI network.                                                                                                                                  | N/A                       | N/A                                                                                                                                                                             |
|    | - Test new devices to support network functions and capabilities not previously envisioned (e.g., new data streams, faster data collection).                                                                                                                                                                                                                                     | • Develop business case based on findings for full deployment consideration.                                                                                                                          |            |                     |     | Grid Operation/Market Design;    |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     | • Full patent filed for development of Wire Down Algorithm.                                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | - Evaluate alternatives to decrease future upgrade, maintenance and/or operational costs.                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                       |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | - Demonstrate different network applications, each focused on separate use cases.                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 21 | • Scope includes the integration of data (network model, loading, SmartMeter™ devices, outages, weather, etc.) and a real-time data visualization platform for Distribution Operations.                                                                                                                                                                                          | • Demonstrate Real-time Data Visualization Platform, including data integration from a variety of data sources and a visual interface that includes geospatial, list, and trending layers.            | 3.25 years | 2013-09-19 00:00:00 | No  | Distribution;                    |      1.33403e+06 | $3,780,000  -  $4,620,000 |      1.60562e+06 |      2.52755e+06 | [Target Cell]      |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay For Performance | New Intellectual Property (IP) has been created through co-development with the vendor. PG&E retains ownership rights to the IP and will provide free unlimited use rights to CA IOUs per the CPUC decision | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | 3                         | BitStew                                                                                                                                                                         |
|    | • The Distribution Management System (DMS) platform and predictive analytics are not included in the scope.                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                       |            |                     |     | Grid Operation/Market Design;    |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                                                                                       |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 22 | • Develop nominally 120 kilowatt exportable power capabilities from a plug in hybrid electric truck.  Seek to create the protocols necessary to safely connect the truck to the appropriate grid connection points.  The portfolio of fleet vehicles (higher and lower weight classes) may broaden the range of available power ratings demonstrated by the project.             | • Develop operating requirements for the vehicle.                                                                                                                                                     | 3.25 years | 2013-09-19 00:00:00 | No  | Distribution                     | 643840           | $3,600,000 - $4,400,000   |      2.48816e+06 |      1.52163e+06 | 4009787.7999999993 | 124.65 | Department of Energy (DOE) provided test services using National Renewable Energy Lab (NREL) facilities.  Approximate cost share to date: $120,000. | DOE/NREL;  Edison Electric Institute engaged for elec. utility industry staging events; Portland General Electric closely collaborating for industry-level requirements | N/A | N/A | Pay for performance | N/A                                                                                                                                                                                                         | • Phase 1 (Mule Phase): 2 Direct Awards - Efficient Drivetrains, Inc. (EDI) and Electric Vehicle International (EVI) selected due to short-term availability of prototype driveline and capability of generating utility-grade export power on F550 - diesel/gasoline configuration                                                                         | 2 (Phase 3 - Beta Phase)  | Efficient Drivetrains, Inc. (EDI)  (Phase 3 - Beta Phase)                                                                                                                       |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Understand engineering challenges with high power export with collaborative supplier development to solve.                                                                                          |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             | • Phase 2 (Alpha Phase): Based on results of Mule phase, moved forward with EDI, which was designed to help formulate specs for Phase 3                                                                                                                                                                                                                     |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Develop safety and interconnection protocols to connect the vehicle to the grid leveraging existing protocols for temporary local generator set connection.                                         |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             | • Phase 3 (Beta Phase): Competitive solicitation. 10 potential bidders. Received 2 final bids.                                                                                                                                                                                                                                                              |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Define and document power requirements for different outage/usage scenarios.                                                                                                                        |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Develop operating protocols (when and how the vehicles will be used).                                                                                                                               |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Develop unplanned outage protocols.                                                                                                                                                                 |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Develop the hardware and software (if required) to connect the vehicle to PG&E’s system.                                                                                                            |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Build vehicles for field testing.                                                                                                                                                                   |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 23 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Transmission; Distribution       |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 24 | • This project will use the data enabled by the SmartMeter™ platform to provide appliance level itemization of monthly bill charges to customers, without their completing any audit or subscribing to any new service.  This project assumes that minute level meter data is available.                                                                                         | • Quantify disaggregation accuracy and compare vendors.                                                                                                                                               | 2.5years   | 2013-09-19 00:00:00 | No  | Demand-Side Management           |      1.39925e+06 | $1,080,000 - $1,320,000   |      1.2312e+06  |  65639.7         | 1296841.6600000001 |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for performance | N/A                                                                                                                                                                                                         | Sole Source - Silver Springs Network, as they are the solutions provider for PG&E’s AMI electric network. It is necessary to work with SSN to ensure that devices and applications can communicate across the AMI network.                                                                                                                                  | N/A                       | N/A                                                                                                                                                                             |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Based on results, provide recommendations for deployment strategy of appliance level billing.                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 25 | • Demonstrate the collection of new data from SmartMeter™ devices.  Example use cases include:                                                                                                                                                                                                                                                                                   | • Evaluate new data and analytic methodologies, their associated impact on the SmartMeter™.                                                                                                           | 3.25 years | 2013-09-19 00:00:00 | No  | Distribution;                    |      1.05179e+06 | $1,780,000 - $2,180,000   | 841884           |      1.13862e+06 | 1980498.7799999998 |   0    | Leveraging existing AMI network investments.                                                                                                        | N/A                                                                                                                                                                     | N/A | N/A | Pay for Performance | N/A                                                                                                                                                                                                         | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | 3                         | BitStew & Primestone                                                                                                                                                            |
|    | - Power Quality Data (C12.19 format).                                                                                                                                                                                                                                                                                                                                            | • Recommendation of which data warrants consideration for full-scale deployment.                                                                                                                      |            |                     |     | Grid Operation/Market Design;    |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | - New Data Channels.                                                                                                                                                                                                                                                                                                                                                             | • Evaluation should provide key inputs to a business case for general deployment.                                                                                                                     |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | - Mobile data collection methods.                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | - Power theft detection methodology using SmartMeter™ data for revenue assurance purposes.                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                       |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 26 | N/A                                                                                                                                                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                   | N/A        | NA                  | No  | Demand-Side Management           |      0           | 0                         |      0           |      0           | 0                  |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | N/A                 | N/A                                                                                                                                                                                                         | N/A                                                                                                                                                                                                                                                                                                                                                         | N/A                       | N/A                                                                                                                                                                             |
| 27 | • Identify vendor to develop or pilot software.                                                                                                                                                                                                                                                                                                                                  | • Successful integration of software with PG&E’s Customer Care and Billing (CC&B) system.                                                                                                             | 2.5years   | 2014-05-01 00:00:00 | No  | Distribution;                    | 868495           | $1,200,000 - $1,460,000   | 902652           | 435173           | 1337824.8099999994 |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for performance | Patent No. 10,557,720 Unauthorized Electrical Grid Connection Detection and Characterization System and Resource Mapping Server and System will be granted on February 11, 2020.                            | Sole Source - Nexant selected due to expertise in PG&E's CC&B database, PV generation data analysis and AMI network.                                                                                                                                                                                                                                        | N/A                       | N/A                                                                                                                                                                             |
|    | • Develop integration and communication platform for auto identification of Unauthorized Interconnections (UI).                                                                                                                                                                                                                                                                  | • Successful tracking of all UIs identified.                                                                                                                                                          |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    | • Demonstrate ability to automatically integrate software with billing and interconnection.                                                                                                                                                                                                                                                                                      | • Successful tracking of communication and “conversion” of UIs to interconnection.                                                                                                                    |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 28 | • Electric Vehicle (EV) submetering pilot will entail EV Meter Data Management Agents (MDMA) delivering submeter data to IOU for subtraction from customer’s primary meter to create an EV and a house bill.  Customer will be responsible for both bills.  In Phase 2, an additional business model will be introduced where the MDMA will be responsible for the bill to PG&E. | • Process to receive MDMA submetered data.                                                                                                                                                            | 5years     | 2013-11-14 00:00:00 | No  | Distribution;                    |      2.75619e+06 | $1,730,000 - $2,120,000   |      2.04278e+06 | 256299           | 2299078            |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for Performance | N/A                                                                                                                                                                                                         | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | 15                        | Nexant, Inc.                                                                                                                                                                    |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Process to subtract EV data from primary meter to create two bills.                                                                                                                                 |            |                     |     | Grid Operation/Market Design;    |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Inclusion of EV portion of bill on customer’s monthly bill.                                                                                                                                         |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Process for billing MDMA for participant submeter charges.                                                                                                                                          |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Obtain third party evaluator for both phases of pilot through a Request for Proposal (RFP).                                                                                                         |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Incentive payments to MDMA.                                                                                                                                                                         |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 29 | • Explore four different methods for obtaining PV generation data (Dedicated SmartMeter™, submeter communication via ZigBee radio, third party estimates, and data exchange with solar companies, and work with vendor to relay data to customer.                                                                                                                                | • Implement pilot program for dedicated smart meters and third party estimates.                                                                                                                       | 2.5 years  | 2014-05-01 00:00:00 | No  | Grid Ops and                     | 950313           | $1,200,000 - $1,460,000   | 873453           | 450363           | 1323816.5499999993 |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for performance | N/A                                                                                                                                                                                                         | • Sole Source -                                                                                                                                                                                                                                                                                                                                             | N/A                       | N/A                                                                                                                                                                             |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Explore opportunities for submetering technology and solar company data exchange.                                                                                                                   |            |                     |     | Mkt. Design / Distribution / DSM |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             | - Opower - PG&E's customer facing web portal, My Energy. Given the project is integrated PV generation interval data into My Energy, it was necessary to work with them.                                                                                                                                                                                    |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Modify existing Customer Data Warehouse (CDW)/MyEnergy interface to allow for additional data streams and visualization.                                                                            |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             | - Clean Power Research - Purchased subscription to estimated generation data.                                                                                                                                                                                                                                                                               |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Evaluate relative merits of various generation measurement/estimation approaches.                                                                                                                   |            |                     |     |                                  |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 30 | • Improve ability to estimate Heating, Ventilation and Air Conditioning (HVAC) Direct Load Control (DLC) load impacts at the distribution feeder level to aid in better understanding of the localized impact of HVAC DLC devices on meeting distribution feeder level reliability concerns.                                                                                     | • Deploy data logging devices on a scientific sample of existing SmartAC™ Cycling customers, to enable real time monitoring of device performance and load impacts at feeder level.                   | 2 years    | 2014-05-01 00:00:00 | No  | Transmission;                    |      1.20648e+06 | $1,327,000 - $1,621,000   |      1.26277e+06 |  77583.3         | 1340352.84         |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for performance | N/A                                                                                                                                                                                                         | Sole sourced - Enetics is a consulting firm that performed a study that assessed the available technologies that would best address the need of the project and determined Enetics provides that solution. They were also willing to make enhancements to their device to further meet the need of PG&E and were the lowest cost and immediately available. | N/A                       | N/A                                                                                                                                                                             |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Develop infrastructure to make real-time data available on feeder-level load impacts of SmartAC™ Cycling to distribution operations.                                                                |            |                     |     | Distribution;                    |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Produce report describing a case study methodology of targeting and valuing customer side peak load reductions at the feeder level.                                                                 |            |                     |     | Grid Operation/Market Design;    |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                                                                                       |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |
| 31 | • Acquire travel pattern data and grid infrastructure capability data to identify low cost, high utilization areas in which to integrate DC fast chargers into Pacific Gas and Electric Company’s (PG&E) distribution system.                                                                                                                                                    | • Develop a process to identify optimal DC fast charging sites.                                                                                                                                       | 2.5 years  | 2014-05-01 00:00:00 | No  | Distribution;                    | 391425           | $400,000 - $490,000       | 308232           | 132537           | 440769.2           |   0    | N/A                                                                                                                                                 | N/A                                                                                                                                                                     | N/A | N/A | Pay for Performance | N/A                                                                                                                                                                                                         | Competitive Bid                                                                                                                                                                                                                                                                                                                                             | 4                         | Energy and Environmental Economics, Inc. (E3)                                                                                                                                   |
|    |                                                                                                                                                                                                                                                                                                                                                                                  | • Develop a map that presents the locations of optimal DC fast charging sites in a meaningful manner to customers.                                                                                    |            |                     |     | Demand-Side Management           |                  |                           |                  |                  |                    |        |                                                                                                                                                     |                                                                                                                                                                         |     |     |                     |                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                             |                           |                                                                                                                                                                                 |



min_row: 11
max_row: 31
min_col: 7
max_col: 27
target_cell_row_idx: 21
target_cell_col_idx: 17
target_cell_value: 4133173.3300000005
formula: =O21+P21