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.

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.