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:
|    | A                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | B                              | C             | D                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
|---:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------------------------|:--------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|  1 | The following is a summary list of high-level steps for using this workbook. Please review and understand the steps below. More documentation and detail is provided in the other "instructions" tabs.                                                                                                                                                                                                                                                                                                                                     |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|  2 | Step number                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Tab Name                       | Action        | Instructions                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
|  3 | Note: Per Decision 20-03-028 and the Narrative Template, LSEs are required to file at least two data templates, a preferred conforming 38 MMT version and a preferred conforming 46 MMT version (and more if they wish to do multiple conforming or alternative portfolios). The instructions below describe the preparation of one data template, so LSEs should follow them for each template. Note that the instructions are effectively the same for each individual template, except for the file naming convention in the last step. |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|  4 | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | All                            | Review        | Review all tabs in this workbook to ensure that you understand the instructions. Sample data is provided for illustrative purposes--you can clear it before you enter your data, but make sure you keep the first row of the pre-written formulas, as you will be copying these later. Note the error flagging formulas and understand why they are doing so.                                                                                                                                                                                                   |
|  5 | 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | N/A                            | Review        | Review the CPUC Q&A for the Resource Data Template and Narrative Template, available here: ftp://ftp.cpuc.ca.gov/energy/modeling/Filling%20Requirement%20QA%20_%2004232020.pdf                                                                                                                                                                                                                                                                                                                                                                                  |
|  6 | [Target Cell]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | portfolio_toggle               | Enter Data    | Select 38 or 46 MMT using the dropdown menu in Cell A1, as appropriate for the resources you are entering in this template.                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|  7 | 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | estimate_system_ra_requirement | Enter Data    | Please input your LSE's 2021 System RA allocation, NQC MW in Cell B68. This will be kept confidential.                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|  8 | 5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | monthly_gwh_mw                 | Enter data    | Enter monthly energy and capacity procurement data, by contract, year, and month, into the light blue columns.                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | Enter all contracts with delivery start dates on or after January 1st, 2020, and before January 1st, 2031.                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | If an LSE opted-out of its procurement obligation under D.19-11-016, or was not assigned a procurement obligation under D.19-11-016, and thus will have a certain amount of procurement occurring on their behalf, the LSE must enter an amount and type of resource(s) communicated to it by Energy Division staff. Staff will coordinate LSEs that are not self-procuring and IOUs procuring on their behalf to prevent double counting and to ensure that reported resources align with procurement that has already occurred or is consistent with the RSP. |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | Enter all contracts that fall into either of the following two categories.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | 1) You have already executed the contract as of this filing, regardless of whether the resource is currently online or will come online in the future. Note that this set of contracts should include the ones you are currently using to serve load (e.g. you must include a contract signed in 2017 that is serving your load as of this filing).                                                                                                                                                                                                             |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | 2) You plan to execute the contract in the future with a start date before January 1st, 2031.                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | For purposes of determining the contract_status (i.e. whether a resource is planned or in development or under review by decision-makers), use June 30th, 2020 as the cutoff date.                                                                                                                                                                                                                                                                                                                                                                              |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                |               | Each contract needs an energy value in GWh and a capacity value in MW, meaning that you must enter a number >=0 in the contract_gwh column, and a number >=0 in EITHER the contracted_nqc_mw_if_known column or the nqc_fraction_if_nqc_not_known column (but not both). Note that where possible you should use only items from the list of identifiers in the green tabs (first green column of each green tab).                                                                                                                                              |
|  9 | 6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | monthly_gwh_mw                 | Copy formulas | To the right of the data just entered, in purple and gray columns, you will see some pre-written formulas in the first row. Copy these formulas down to the last row of data.                                                                                                                                                                                                                                                                                                                                                                                   |
| 10 | 7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | monthly_gwh_mw                 | Review        | Review the formulas' results.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| 11 | 8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | monthly_gwh_mw                 | Correct       | Correct any data errors in the data you entered in Step 2 that was caught by the formulas. It is OK to overwrite default values in the purple columns, but do NOT overwrite formulas in the gray columns. If you see the text "fillme" displayed in any purple cell, overwrite it with the correct value.                                                                                                                                                                                                                                                       |
| 12 | 9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | unique_contracts               | Copy formulas | In Columns B-E, copy down formulas in unique_contracts until all the unique contracts listed in monthly_gwh_mw are displayed. The template will automatically generate a list of unique contracts from the monthly data. Note this will only work if steps 1-5 are complete.                                                                                                                                                                                                                                                                                    |
| 13 | 10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | unique_contracts               | Enter data    | Enter contract data into the light blue columns.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| 14 | 11                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | unique_contracts               | Copy formulas | Adjacent to the data just entered, you will see some pre-written formulas in the first row, in purple and gray. Copy these formulas down to the last row of data.                                                                                                                                                                                                                                                                                                                                                                                               |
| 15 | 12                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | unique_contracts               | Correct       | Correct any data errors caught by the formulas. It is OK to overwrite default values in the purple columns, but do NOT overwrite formulas in the gray columns. If you see the text "fillme" displayed in any cell, overwrite it with the correct value.                                                                                                                                                                                                                                                                                                         |
| 16 | 13                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | errors                         | Review        | Review. Where there are errors in the previous tabs, they are flagged here. Trace the errors and correct as needed in monthly_gwh_mw and unique_contracts.                                                                                                                                                                                                                                                                                                                                                                                                      |



min_row: 1
max_row: 16
min_col: 1
max_col: 4
target_cell_row_idx: 6
target_cell_col_idx: 1
target_cell_value: 3
formula: =ROW()-3