Skip to main content

degradation (Excel)

Relates to the battery.

Cumulative degradation​

From the template with the client's input, you copy the "Cumulative degradation at the beginning of the year" column into the corresponding percentStorageCapacityRemaining.

warning

Pay attention to when the project starts (COD) — that's where the mapping begins.

:::note Start vs end of year The numbers we get from the client are for the start of the year: e.g. the degradation value A they give us for 2042 is the value at the start of 2042.

In the databook, however, results are reported at the end of the year. So we'd expect number A to be very close to the degradation value the databook has for 2041 — i.e. for the previous year. :::

The cumulativeCycles column​

In the next column over:

  1. Check whether you need to rename cell A1 to cumulativeCycles.

  2. Below it, fill in with the formula:

    A2 = 365.25 * (battery cycles)
    A3 = A2 + 365.25 * (battery cycles)
    ...

Extending the years (important)​

danger

A number of years (e.g. 15) need to be added to both columns in the degradation tab, so that the model works correctly.

  1. Column A: continue the same formula downward, for as many years as you want to add.

  2. Column B: below the last filled row, put the formula:

    =FORECAST.LINEAR(x; known_y's; known_x's)

    where:

    • x = the cell to the left (same row, column A)
    • known_y's = the 7 cells above the current cell (column B)
    • known_x's = the 7 cells above the cell to the left (column A)

    Press Enter.

  3. Drag the column B formula down until columns A and B have the same number of rows.