Skip to main content

Tools & systems

The systems you touch regularly and what they're for.

ToolFileWhat it's for
BESS & Colocation ToolBESS & Colocation Tool.xlsmCAPEX estimation and co-location savings for BESS projects
RES Generation Toolres_generation_tool.xlsmGenerates 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:

ComponentUnit
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.

TechnologyComponents
Solar PVModule, Inverter, BoS, Installation & development, Grid connection (€/kW)
Onshore WindTurbine, BoS, Development (€/kW)

Calculator tab — project inputs​

InputUnitExample
(A) RES DC peak capacityMW1
(B) RES Inverter capacityMW1
(C) BESS capacityMW1
(D) Grid capacityMW1
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:

InputDescription
CountryROU / BGR / GRC
Duration (hours)Target battery duration
Daily cycle targetTarget number of daily cycles

Outputs​

Calculator tab​

OutputUnit
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​

CellInputDescription
B4Input data yearThe year the reference data comes from (2023–2060)
B5Data columnRES 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)​

ButtonAction
Update DatesFills the date column in the Data sheet based on the reference year
Create All YearsRuns the calculation and populates the Result sheet for all years

Outputs​

Result tab​

ColumnContent
dateHourly 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.