top of page

From the 2030 Agenda of the Metropolitan City of Milan to Municipal Urban Planning Documents (DUP) through shared climate change adaptation indicators and targets.

Calculation of Threshold-Free CAGR for a Sectoral Indicator:

Prepared Excel spreadsheets:

Usage Instructions:

  • Enter the base year and target year in the yellow-highlighted cells as indicated;

  • Fill in the indicator values for the corresponding reference years.

​​

The file automatically computes the Compound Annual Growth Rate (CAGR), providing:

  • The calculated CAGR value;

  • A graphical symbol indicating the progress direction based on the entered data.

tabella esempio indicatore.png

Legend: Compound growth rate (CAGR) in the desired direction.

Immagine1.png

Operational Note:
In the provided example (2019–2022), the indicator analysis reveals a significant deviation from Climate Adaptation objectives, highlighting a critical trend requiring close monitoring.

Indicator progress

bottom of page