ETTV & Building Cooling Energy Calculator Template.xlsx

	A	B	C	D	E	F	G	H	I	K	L	O
1	BUILDING ENERGY CALCULATOR
2									HOW TO USE THE CALCULATOR
3		Parameter	Units	Input			Details of Input	Notes	Go down the list of parameters 1-10 on the left, and fill in the inputs (column D) according to your buildings specification. Details of the input tells you how to input the values.
4	1	Building Gross Floor Area	m2				User Input	Accepted values from >= 5000
5	1a	Building Size Classification		Large			User Select from Dropdown	Select from dropdown only if Parameter 1 is left empty
6	2	Window-to-Wall Ratio (WWR)		0.5			User Input	Accepted values from 0 to 1
7	3	Wall U-Value	W/m2K	0.8		1	User Input	Default value is 1				TRUE
8	4	Fenestration Types		Aluminium Curtain Wall			User Select from Dropdown
9	5	Glazing Types		Double Glazing			User Select from Dropdown
10	6	Number of Panels		Double Panel			User Select from Dropdown				Select...
11	7	Aluminium Curtain Wall Glass U-Value	W/m2K	1.5			User Input	Frame is accounted for separately
12	8	Aluminium Curtain Wall Glass SHGC		0.25			User Input			Image 1-
13	9	Fenestration Width	m	1			User Input	Dimensions for each fenestration system (i.e. one slab)		Configurations for window and curtain walls (CW)
14	10	Fenestration Height	m	2			User Input	Refer to Image 1 on the right		a in the image is width (W), b is height (H)
15
16
17	RESULTS
18		RESULT PARAMETER	UNITS	Non TB	Basic TB	Advanced TB		Please refer to 'Behind the Scenes Calculation' for more details on how each of these results are generated.
19		Building Size		Large
20		Window Frame U-Value	W/m2K	15	5	3		As discussed, users will not be able to select window frame parameters in the initial prototype.
21		Window Frame SHGC		0.281	0.094	0.056		It will be selected for them. If required, user inputs can be enabled in the future.
22		Overall Window U-Value	W/m2K	5.275	3.415	2.915
23		Overall Window SHGC		0.258	0.211	0.202
24		ETTV	W/m2	45.016	36.180	34.195		Calculated using formula
25		ETTV Percentage Difference	%	NA	19.63	24.04
26		Enhanced ETTV	W/m2	53.666	42.564	39.986		Calculated using formula			Image 2-
27		Yearly HVAC Energy Consumption	kWh/yr	1,950,377	1,813,754	1,783,064					Definitions obtained from BCA Building Energy Benchmark Report 2021
28		Energy Use Intensity (EUI)	kWh/m2.yr	188.6	179.5	177.4		NEW: Refer to defintions in image 2 to the right.
29		Energy Savings	kWh/yr	NA	136,624	167,313		Energy savings and carbon emission savings are relative to the non thermally-broken scenario.
30		HVAC Energy Savings	%	NA	7.00	8.58
31		EUI Improvement	%	NA	4.83	5.92
32		Carbon Emission	kg CO2/yr	1,178,915	1,121,970	1,109,179
33		Carbon Emission Savings	kg CO2/yr	NA	56,945	69,736
34		Carbon Payback	yr	NA	0.0686	0.0846		Time taken to offset lifecycle carbon emission. Function of the total mass of the thermal break.
35		Estimated ROI	yr	NA	2.1040	2.4880		Function of the energy savings minus initial costs.
36								Note: the carbon emission & ROI cells in have not been implemented fully. Further discussions needed. Refer to 'Behind the Scenes Calculation'
37
38
39
40
41
42		Further Notes on base case building: GFA = 7500m2
43		This would classify our 12-storey building as medium office.
44		Depending on the parameters used, this will put the energy consumption in the 2nd quartile, as per the screenshot below.
45		Note that we are using HVAC energy consumption which does not account for the appliances.
46		bca-building-energy-benchmarking-report-(bebr)-2021.pdf			BCA Building Energy Benchmark Report 2021
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100