Tools & systems
The systems you touch regularly and what they're for.
| Tool | File | What it's for |
|---|---|---|
| BESS & Colocation Tool | BESS & Colocation Tool.xlsm | CAPEX estimation and co-location savings for BESS projects |
| RES Generation Tool | res_generation_tool.xlsm | Generates hourly RES production time series for 2023–2060 |
BESS & Colocation Tool
File: BESS & Colocation Tool.xlsm
Calculates BESS CAPEX and co-location savings for standalone or co-located battery projects across Romania (ROU), Bulgaria (BGR), and Greece (GRC).
Inputs
Country CAPEX tabs (ROU / BGR / GRC)
Updated regularly. Each country tab contains CAPEX for 1h / 2h / 4h battery durations, broken down by component:
| Component | Unit |
|---|---|
| Battery system | €/kW |
| Inverter | €/kW |
| Balance of system (BoS) | €/kW |
| Development | €/kW |
| Grid connection | €/kW |
| EPC soft costs | €/kW |
Values are given per construction year (2025–2039).
CAPEX assumptions tab (Solar PV & Wind)
Country is selected from cell E2. Values are updated manually from the Pan-EU cost tools.
| Technology | Components |
|---|---|
| Solar PV | Module, Inverter, BoS, Installation & development, Grid connection (€/kW) |
| Onshore Wind | Turbine, BoS, Development (€/kW) |
Calculator tab — project inputs
| Input | Unit | Example |
|---|---|---|
| (A) RES DC peak capacity | MW | 1 |
| (B) RES Inverter capacity | MW | 1 |
| (C) BESS capacity | MW | 1 |
| (D) Grid capacity | MW | 1 |
| Co-location configuration | — | AC New-Build / AC Retrofit / DC |
| Battery duration | — | 1h / 2h / 4h |
| Technology | — | Solar PV / Onshore Wind |
| COD Year | — | e.g. 2027 |
Interpolation tab — custom durations
For durations outside the standard 1h / 2h / 4h options:
| Input | Description |
|---|---|
| Country | ROU / BGR / GRC |
| Duration (hours) | Target battery duration |
| Daily cycle target | Target number of daily cycles |
Outputs
Calculator tab
| Output | Unit |
|---|---|
| Standalone CAPEX BESS | €/kW system |
| Co-location savings — Grid connection | €/kW system |
| Co-location savings — BoS | €/kW system |
| Co-location savings — Development | €/kW system |
| Total co-location savings | €/kW system |
Calculator – Chronos tab
Same structure as the Calculator tab, adapted for project-specific setups. Inputs are entered in cells P10:P16. The main output is at row 206: Total system co-located savings (€/kW system).
End of Life tab
CAPEX components for 1h / 2h / 4h batteries, used for End-of-Life analysis.
Interpolation tab (rows 33–53)
CAPEX for the target duration and target daily cycles, derived via double linear interpolation.
RES Generation Tool
File: res_generation_tool.xlsm
Generates an hourly RES generation time series covering all years 2023–2060, using one reference year of data as the base.
Inputs
Settings tab
| Cell | Input | Description |
|---|---|---|
| B4 | Input data year | The year the reference data comes from (2023–2060) |
| B5 | Data column | RES type identifier, e.g. sol, wof_fixed |
Data tab (column B)
- 8,760 values (or 8,784 for a leap year)
- Hourly RES generation for the reference year
- Pasted in manually
Macros (buttons)
| Button | Action |
|---|---|
| Update Dates | Fills the date column in the Data sheet based on the reference year |
| Create All Years | Runs the calculation and populates the Result sheet for all years |
Outputs
Result tab
| Column | Content |
|---|---|
date | Hourly timestamps from 2023 to 2060 |
sol (or selected type) | Hourly generation values for every year |
Leap year handling
If the reference year is not a leap year, 29 February in leap output years is assigned the same values as 28 February.