Final-Analysis.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AJ
1
2	Energy Analysis
3
4	Default Parameters by Environment Type								Photovoltaic Calculations							Wind Turbine Data							These parameter values reflect typical user inputs by environment type. For the purpose of baseline energy and financial analysis, as well as realistic example calculations, we propose these default values based on research and commonly adopted industry standards.
5	Parameters			Dense Urban	Urban	Suburban	Rural		Parameters		Dense Urban	Urban	Suburban	Rural		Parameters		Dense Urban	Urban	Suburban	Rural
6	Parameters			Dense Urban	Urban	Suburban	Rural		Parameters		Dense Urban	Urban	Suburban	Rural		Parameters		Dense Urban	Urban	Suburban	Rural
7	Available Area (m²)			20	30	40	50		Final Area per Panel (m²)		1.26	1.51	1.68	1.85		Final Area per Panel (m²)		300	400	600	1000
8	Area per Panel (m²)			1.50	1.80	2.00	2.20		Number of Panels		16	20	24	27		Required Area (m²)		1.50	2.00	2.40	4.2
9	Panel Tilt (degrees)			33	33	33	33		Total Panel Power (W)		6359.27	7949.09	9538.91	10839.67		Diameter (m)		1.50	1.75	1.75	2.30
10	Nominal Power per Panel (W)			400	400	400	400
11	Average Annual Power Consumption per Base Station (MWh)			19.38	21.59	21.2	13.21
12	Average Annual Power Consumption per Base Station (MWh)			19.38	21.59	21.2	13.21
13
14	Single Base Station Analysis
15
16	Detailed Renewable Energy Production Analysis per Base Station by District and Environment Type (Solar, Wind, and Combined Contributions)																																	This table shows the estimated annual energy production and renewable coverage of a single base station per district, by environment type (Dense Urban, Urban, Suburban, Rural). It includes solar, wind, and total renewable energy (in MWh and %), based on standardised assumptions. ha (h): Effective solar irradiation hours per year, calculated as energy output divided by installed PV capacity. CF (%): Wind capacity factor, representing the percentage of the year the turbine operates at full capacity. Sources: Solar data from PVGIS – EU JRC Wind data from Global Wind Atlas – IEA/DTU PV specs based on typical commercial panel datasheets.
17	District	Dense Urban								Urban								Suburban								Rural
18		Solar Energy			Wind Energy			Renewable Energy		Solar Energy			Wind Energy			Renewable Energy		Solar Energy			Wind Energy			Renewable Energy		Solar Energy			Wind Energy			Renewable Energy
19		ha	E (MWh)	E (%)	CF	E (MWh)	E (%)	E (MWh)	E (%)	ha	E (MWh)	E (%)	CF	E (MWh)	E (%)	E (MWh)	E (%)	ha	E (MWh)	E (%)	CF	E (MWh)	E (%)	E (MWh)	E (%)	ha	E (MWh)	E (%)	CF	E (MWh)	E (%)	E (MWh)	E (%)
20	Lisboa	1208.0	7.68	40%	32%	0.84	4%	8.52	44%	1359.0	10.80	50%	36%	1.26	6%	12.06	56%	1510.0	14.40	68%	40%	2.10	10%	16.51	78%	1585.5	17.19	130%	52%	4.56	34%	21.74	165%
21	Porto	1152.0	7.33	38%	17%	0.45	2%	7.77	40%	1296.0	10.30	48%	19%	0.67	3%	10.97	51%	1440.0	13.74	65%	21%	1.10	5%	14.84	70%	1512.0	16.39	124%	27%	2.37	18%	18.75	88%
22	Setúbal	1224.0	7.78	40%	22%	0.58	3%	8.36	43%	1377.0	10.95	51%	24%	0.84	4%	11.79	55%	1530.0	14.59	69%	27%	1.42	7%	16.01	76%	1606.5	17.41	132%	35%	3.07	23%	20.48	97%
23	Braga	1136.0	7.22	37%	12%	0.32	2%	7.54	39%	1278.0	10.16	47%	14%	0.49	2%	10.65	49%	1420.0	13.55	64%	15%	0.79	4%	14.33	68%	1491.0	16.16	122%	20%	1.75	13%	17.91	84%
24	Aveiro	1144.0	7.28	38%	20%	0.53	3%	7.80	40%	1287.0	10.23	47%	23%	0.81	4%	11.04	51%	1430.0	13.64	64%	25%	1.31	6%	14.95	71%	1501.5	16.28	123%	33%	2.89	22%	19.17	90%
25	Coimbra	1160.0	7.38	38%	15%	0.39	2%	7.77	40%	1305.0	10.37	48%	17%	0.60	3%	10.97	51%	1450.0	13.83	65%	19%	1.00	5%	14.83	70%	1522.5	16.50	125%	25%	2.19	17%	18.69	88%
26	Leiria	1184.0	7.53	39%	36%	0.95	5%	8.48	44%	1332.0	10.59	49%	41%	1.44	7%	12.02	56%	1480.0	14.12	67%	45%	2.37	11%	16.48	78%	1554.0	16.84	128%	59%	5.17	39%	22.01	104%
27	Faro	1280.0	8.14	42%	10%	0.26	1%	8.40	43%	1440.0	11.45	53%	11%	0.39	2%	11.83	55%	1600.0	15.26	72%	12%	0.63	3%	15.89	75%	1680.0	18.21	138%	16%	1.40	11%	19.61	93%
28	Santarém	1232.0	7.83	40%	8%	0.21	1%	8.04	42%	1386.0	11.02	51%	9%	0.32	1%	11.33	52%	1540.0	14.69	69%	10%	0.53	2%	15.22	72%	1617.0	17.53	133%	13%	1.14	9%	18.67	88%
29	Évora	1288.0	8.19	42%	9%	0.24	1%	8.43	43%	1449.0	11.52	53%	10%	0.35	2%	11.87	55%	1610.0	15.36	72%	11%	0.58	3%	15.94	75%	1690.5	18.32	139%	14%	1.23	9%	19.55	92%
30	Beja	1296.0	8.24	43%	10%	0.26	1%	8.50	44%	1458.0	11.59	54%	11%	0.39	2%	11.98	55%	1620.0	15.45	73%	12%	0.63	3%	16.08	76%	1701.0	18.44	140%	16%	1.40	11%	19.84	94%
31	Portalegre	1272.0	8.09	42%	9%	0.24	1%	8.33	43%	1431.0	11.38	53%	10%	0.35	2%	11.73	54%	1590.0	15.17	72%	11%	0.58	3%	15.75	74%	1669.5	18.10	137%	14%	1.23	9%	19.32	91%
32	Bragança	1128.0	7.17	37%	18%	0.47	2%	7.65	39%	1269.0	10.09	47%	20%	0.70	3%	10.79	50%	1410.0	13.45	63%	22%	1.16	5%	14.61	69%	1480.5	16.05	121%	29%	2.54	19%	18.59	88%
33	Vila Real	1120.0	7.12	37%	16%	0.42	2%	7.54	39%	1260.0	10.02	46%	18%	0.63	3%	10.65	49%	1400.0	13.35	63%	20%	1.05	5%	14.41	68%	1470.0	15.93	121%	26%	2.28	17%	18.21	86%
34	Guarda	1112.0	7.07	36%	16%	0.42	2%	7.49	39%	1251.0	9.94	46%	18%	0.63	3%	10.58	49%	1390.0	13.26	63%	20%	1.05	5%	14.31	68%	1459.5	15.82	120%	26%	2.28	17%	18.10	85%
35	Viseu	1128.0	7.17	37%	16%	0.42	2%	7.59	39%	1269.0	10.09	47%	18%	0.63	3%	10.72	50%	1410.0	13.45	63%	20%	1.05	5%	14.50	68%	1480.5	16.05	121%	26%	2.28	17%	18.33	86%
36	Castelo Branco	1200.0	7.63	39%	12%	0.32	2%	7.95	41%	1350.0	10.73	50%	14%	0.49	2%	11.22	52%	1500.0	14.31	67%	15%	0.79	4%	15.10	71%	1575.0	17.07	129%	20%	1.75	13%	18.82	89%
37	Viana do Castelo	1112.0	7.07	36%	35%	0.92	5%	7.99	41%	1251.0	9.94	46%	40%	1.40	6%	11.35	53%	1390.0	13.26	63%	44%	2.31	11%	15.57	73%	1459.5	15.82	120%	57%	4.99	38%	20.81	98%
38
39	Network Analysis
40
41	Base Station Distribution by Environment Type (% and Absolute Number)											This table presents the distribution of mobile base stations by district, categorized by environment type — Dense Urban, Urban, Suburban, and Rural — showing both the percentage and absolute number of base stations. The percentage values per environment type were defined based on data gathered from official statistics and spatial planning studies, including sources such as the Portuguese National Statistics Institute (INE), municipal development plans (PDM), and urban-rural classification reports published by DGT (Direção-Geral do Território) and Eurostat. These inputs provide a representative approximation of the land use and population density characteristics in each district.
42	District	Total BS	Dense Urban		Urban		Suburban		Rural
43	District	Total BS	%	Number	%	Number	%	Number	%	Number
44	Lisboa	3500	20%	700	60%	2100	10%	350	10%	350
45	Porto	3000	10%	300	60%	1800	10%	300	15%	450
46	Setúbal	1400	5%	70	30%	420	35%	490	30%	420
47	Braga	1500	5%	75	40%	600	30%	450	25%	375
48	Aveiro	1300	5%	65	35%	455	30%	390	30%	390
49	Coimbra	1100	1%	11	30%	330	40%	440	29%	319
50	Leiria	1100	2%	22	30%	330	35%	385	33%	363
51	Faro	1000	2%	20	35%	350	35%	350	28%	280
52	Santarém	900	0%	0	20%	180	30%	270	50%	450
53	Évora	700	0%	0	15%	105	25%	175	60%	420
54	Beja	600	0%	0	10%	60	30%	180	60%	360
55	Portalegre	500	0%	0	10%	50	25%	125	65%	325
56	Bragança	500	0%	0	10%	50	20%	100	70%	350
57	Vila Real	650	0%	0	10%	65	25%	163	65%	423
58	Guarda	600	0%	0	10%	60	20%	120	70%	420
59	Viseu	800	1%	8	20%	160	30%	240	49%	392
60	Castelo Branco	700	1%	7	20%	140	30%	210	49%	343
61	Viana do Castelo	800	2%	16	25%	200	30%	240	43%	344
62
63	Total Renewable Energy Production Analysis by District and Environment Type (Considering All Base Stations: Solar, Wind, and Combined Contributions)																														This table shows the total annual energy production and renewable coverage of all base stations in each district, categorized by environment type (Dense Urban, Urban, Suburban, Rural). For each zone, it includes the number of base stations, the energy generated from solar and wind sources (in MWh), and the percentage of total energy consumption covered by each source and by renewables in total. The calculations are based on the sum of all base stations per environment type, using standardised energy production parameters.
64	District	Dense Urban							Urban							Suburban							Rural
65		Number of BS	Solar Energy		Wind Energy		Renewable Energy		Number of BS	Solar Energy		Wind Energy		Renewable Energy		Number of BS	Solar Energy		Wind Energy		Renewable Energy		Number of BS	Solar Energy		Wind Energy		Renewable Energy
66		Number of BS	E (MWh)	E (%)	E (MWh)	E (%)	E (MWh)	E (%)	Number of BS	E (MWh)	E (%)	E (MWh)	E (%)	E (MWh)	E (%)	Number of BS	E (MWh)	E (%)	E (MWh)	E (%)	E (MWh)	E (%)	Number of BS	E (MWh)	E (%)	E (MWh)	E (%)	E (MWh)	E (%)
67	Lisboa	176	1352.03	40%	148.01	4%	1500.04	44%	528	5703.88	50%	666.04	6%	6369.92	56%	88	1267.53	68%	185.01	10%	1452.54	78%	88	1512.39	130%	400.86	34%	1913.25	165%
68	Porto	68	498.16	38%	30.38	2%	528.54	40%	408	4203.22	48%	271.63	3%	4474.85	51%	68	934.05	65%	75.06	5%	1009.11	70%	102	1671.74	124%	241.25	18%	1912.99	142%
69	Setúbal	16	124.54	40%	9.25	3%	133.79	43%	96	1050.81	51%	80.73	4%	1131.54	55%	112	1634.59	69%	158.94	7%	1793.53	76%	96	1671.74	132%	294.34	23%	1966.07	155%
70	Braga	18	130.03	37%	5.68	2%	135.71	39%	144	1462.89	47%	70.64	2%	1533.53	49%	108	1462.89	64%	85.15	4%	1548.03	68%	90	1454.57	122%	157.68	13%	1612.25	136%
71	Aveiro	14	101.85	38%	7.36	3%	109.21	40%	98	1002.59	47%	78.98	4%	1081.57	51%	84	1145.81	64%	110.38	6%	1256.19	71%	84	1367.16	123%	242.83	22%	1609.99	145%
72	Coimbra	2	11.80	38%	0.63	2%	12.43	40%	48	497.93	48%	28.59	3%	526.52	51%	64	885.21	65%	63.91	5%	949.12	70%	46	765.76	125%	101.62	17%	867.37	142%
73	Leiria	5	36.14	39%	4.54	5%	40.68	44%	72	762.35	49%	103.44	7%	865.79	56%	84	1185.88	67%	198.68	11%	1384.55	78%	79	1334.11	128%	409.34	39%	1743.45	167%
74	Faro	4	32.56	42%	1.05	1%	33.61	43%	70	801.27	53%	26.98	2%	828.25	55%	70	1068.36	72%	44.15	3%	1112.51	75%	56	1019.80	138%	78.49	11%	1098.29	148%
75	Santarém	0	0.00	0%	0.00	0%	0.00	0%	32	352.56	51%	10.09	1%	362.65	52%	48	705.12	69%	25.23	2%	730.34	72%	80	1402.22	133%	91.10	9%	1493.32	141%
76	Évora	0	0.00	0%	0.00	0%	0.00	0%	12	138.22	53%	4.20	2%	142.42	55%	20	307.15	72%	11.56	3%	318.72	75%	48	879.57	139%	58.87	9%	938.44	148%
77	Beja	0	0.00	0%	0.00	0%	0.00	0%	8	92.72	54%	3.08	2%	95.80	55%	24	370.87	73%	15.14	3%	386.01	76%	48	885.04	140%	67.28	11%	952.31	150%
78	Portalegre	0	0.00	0%	0.00	0%	0.00	0%	8	91.00	53%	2.80	2%	93.80	54%	20	303.34	72%	11.56	3%	314.90	74%	52	941.03	137%	63.77	9%	1004.81	146%
79	Bragança	0	0.00	0%	0.00	0%	0.00	0%	6	60.52	47%	4.20	3%	64.73	50%	12	161.40	63%	13.88	5%	175.27	69%	42	674.02	121%	106.70	19%	780.72	141%
80	Vila Real	0	0.00	0%	0.00	0%	0.00	0%	8	80.13	46%	5.05	3%	85.17	49%	20	267.09	63%	21.02	5%	288.11	68%	52	828.58	121%	118.44	17%	947.02	138%
81	Guarda	0	0.00	0%	0.00	0%	0.00	0%	6	59.67	46%	3.78	3%	63.45	49%	12	159.11	63%	12.61	5%	171.72	68%	42	664.46	120%	95.66	17%	760.12	137%
82	Viseu	1	8.61	37%	0.50	2%	9.11	39%	24	242.10	47%	15.14	3%	257.23	50%	36	484.19	63%	37.84	5%	522.04	68%	59	943.63	121%	133.92	17%	1077.55	139%
83	Castelo Branco	1	6.10	39%	0.25	2%	6.36	41%	16	171.70	50%	7.85	2%	179.55	52%	24	343.40	67%	18.92	4%	362.32	71%	39	669.24	129%	68.68	13%	737.92	143%
84	Viana do Castelo	2	11.31	36%	1.47	5%	12.79	41%	20	198.89	46%	28.03	6%	226.92	53%	24	318.22	63%	55.50	11%	373.72	73%	34	544.22	120%	171.77	38%	715.99	158%
85
86	District	Overall Energy Summary by District															Discription
87		Consumed Energy (MWh)		Solar Energy				Wind Energy				Renewable Energy					Consumed Energy (MWh)		Solar Energy				Wind Energy				Renewable Energy
88		Consumed Energy (MWh)		E (MWh)		E (%)		E (MWh)		E (%)		E (MWh)		E (%)			Consumed Energy (MWh)		E (MWh)		E (%)		E (MWh)		E (%)		E (MWh)		E (%)
89	Lisboa	17838.48		9835.84		55.14%		1399.92		7.85%		11235.76		62.99%			Total Energy Consumption (MWh): Estimated total annual energy consumption of all base stations in the district (calculated based on environment type and average BS consumption).		Solar Energy Produced (MWh): Total annual solar energy generated by base stations across all environments in the district (dense urban, urban, suburban, rural).		Solar Coverage (%): Percentage of the district’s total annual base station consumption that is met by solar energy.		Wind Energy Produced (MWh): Total annual wind energy generated by base stations in the district (usually only in suburban and rural areas).		Wind Coverage (%): Percentage of the district’s total annual base station consumption that is met by wind energy.		Total Renewable Energy (MWh): Sum of solar and wind energy produced in the district.		Total Renewable Coverage (%): Percentage of the district’s total annual base station consumption that is met by renewable energy (solar + wind).
90	Porto	12915.58		7307.17		56.58%		618.32		4.79%		7925.49		61.36%
91	Setúbal	6025.28		4481.67		74.38%		543.26		9.02%		5024.93		83.40%
92	Braga	6936.30		4510.38		65.03%		319.14		4.60%		4829.53		69.63%
93	Aveiro	5277.58		3617.41		68.54%		439.54		8.33%		4056.96		76.87%
94	Coimbra	3037.07		2160.70		71.14%		194.75		6.41%		2355.45		77.56%
95	Leiria	4474.54		3318.48		74.16%		715.99		16.00%		4034.47		90.17%
96	Faro	3812.58		2921.98		76.64%		150.67		3.95%		3072.65		80.59%
97	Santarém	2765.28		2459.89		88.96%		126.42		4.57%		2586.32		93.53%
98	Évora	1317.16		1324.95		100.59%		74.64		5.67%		1399.58		106.26%
99	Beja	1315.60		1348.63		102.51%		85.50		6.50%		1434.13		109.01%
100	Portalegre	1283.64		1335.37		104.03%		78.14		6.09%		1413.51		110.12%