S3.11 Use of sold products (PC) data input sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	V	X	Y
1	INSTRUCTIONS • This worksheet is for inputting data from end-user devices to measure (or estimate, when data is not available) the energy consumption and emissions of these devices from playing your games • Read instructions for each method before completing (smaller text below each large heading) • Working from left to right, one row at a time, fill red shaded boxes with your collected user, sales, and other data (ensure collected data is broken down by region at a minimum). • For questions and feedback, please reach out to ben@sustainablegamesalliance.org • Year selector now functioning correctly – set once on main data input tab (Example tab 1 has separate function) *** INCOMPLETE FEATURES: – Multiplayer module to calculate DC & internet transmission component for multiplayer"
2
3	Reporting period selector	2024
4
5	OPTION 1 – Measured power consumption (kWh, by region) For this option, a studio internally collects regional data (country level) that measures the direct power consumption across all its player's devices, through the use of a energy collecting telemetry system (e.g. Wattwiser) to measure usage.
6	Game	Location (country as 1st preference, use continent, region, or world only as last resort)	Location EF (automatic) (gCO2e per kWh)	Total player hours in Region	Total regional energy consumption of PC devices, as measured by studio (kWh)	%age playtime time in VR (If title is VR exclusive = 100%, if no VR = 0%)	VR headset overhead (W) (12 W HMD + 5W controllers)	VR power consumption (kWh)	Display – 92W (kWh)	Audio – 30W (kWh)	Device + system + VR energy consumption (kWh)	PC device emisisons (kg CO2e)	System components emisisons (kg CO2e)	Subtotal (kg CO2e)		TOTAL (kg CO2e)
7	Game 1	Australia	551.59	30,000.00	1,000.00	5%	17	25.5	2760	900	4,685.50	551.59	2032.884945	2,584.47		730,116.03
8	Game 1	France	44.18	9,000.00	2,500.00	5%	17	7.65	828	270	3,605.65	110.45	48.847617	159.30
9	Game 1	Finland	72.25	20,000.00	60,000.00	5%	17	17	1840	600	62,457.00	4335	177.51825	4,512.52
10	Game 1	Denmark	143.3	20,000.00	5,000,000.00	5%	17	17	1840	600	5,002,457.00	716500	352.0881	716,852.09
11	Game 1	Germany	344.14	20,000.00	15,000.00	5%	17	17	1840	600	17,457.00	5162.1	845.55198	6,007.65
12								0	0	0	0.00	0	0	0.00
13								0	0	0	0.00	0	0	0.00
14								0	0	0	0.00	0	0	0.00
15								0	0	0	0.00	0	0	0.00
16								0	0	0	0.00	0	0	0.00
17								0	0	0	0.00	0	0	0.00
18								0	0	0	0.00	0	0	0.00
19								0	0	0	0.00	0	0	0.00
20								0	0	0	0.00	0	0	0.00
21								0	0	0	0.00	0	0	0.00
22								0	0	0	0.00	0	0	0.00
23								0	0	0	0.00	0	0	0.00
24								0	0	0	0.00	0	0	0.00
25								0	0	0	0.00	0	0	0.00
26								0	0	0	0.00	0	0	0.00
27								0	0	0	0.00	0	0	0.00
28								0	0	0	0.00	0	0	0.00
29								0	0	0	0.00	0	0	0.00
30								0	0	0	0.00	0	0	0.00
31								0	0	0	0.00	0	0	0.00
32
33	OPTION 2 – Estimated consumption by player duration (hours, PC level, by region) For this option, a studio internally collects regional data (country level) that measures the hours that players play for, and applies assumptions about the split of low/medium/high spec PCs in the playerbase (informed by Steam Hardware survey).
34							Split of players on low/med/high end PCs			Using default split (or contents of override if used) – assign % and calculate power for each system			Add system components								TOTAL (kg CO2e)
35	Game	Location (country as 1st preference, use continent, region, or world only as last resort)	Location EF (automatic) (gCO2e per kWh)	Total player hours in Region	%age playtime time in VR (If title is VR exclusive = 100%, if no VR = 0%)	VR headset overhead (W) (12 W HMD + 5W controllers)	OVERRIDE % of players on low-end systems	OVERRIDE % of players on medium-end systems	OVERRIDE % of players on high-end systems	Energy consumption – low-end PCs (kWh)	Energy consumption – medium-end PCs (kWh)	Energy consumption – high-end PCs (kWh)	VR power consumption (kWh)	Display – 92W (kWh)	Audio – 30W (kWh)	Low-end PC emissions (kg CO2e)	Mid range PC emissions (kg CO2e)	High-end PC emissions (kg CO2e)	System component emisisons (kg CO2e)	Subtotals	10,601.99	Australian elec price	User cost in Australia
36		Australia	551.59	20,000.00	50%	17				2,600.00	2,469.60	1,584.80	170	1840	600	1,434.13	1,362.21	874.16	1439.6499	5,110.15		0.3	1996.32
37		France	44.18	20,000.00	0	17				2,600.00	2,469.60	1,584.80	0	1840	600	114.87	109.11	70.02	107.7992	401.79
38		Finland	72.25	20,000.00	0	17				2,600.00	2,469.60	1,584.80	0	1840	600	187.85	178.43	114.50	176.29	657.07
39		Denmark	143.3	20,000.00	0	17				2,600.00	2,469.60	1,584.80	0	1840	600	372.58	353.89	227.10	349.652	1,303.23
40		Germany	344.14	20,000.00	0	17				2,600.00	2,469.60	1,584.80	0	1840	600	894.76	849.89	545.39	839.7016	3,129.75
41										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
42										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
43										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
44										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
45										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
46										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
47										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
48										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
49										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
50										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
51										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
52										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
53										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
54										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
55										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
56										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
57										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
58										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
59										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
60										0.00	0.00	0.00	0	0	0	0.00	0.00	0.00	0	0.00
61
62
63
64
65
66
67
68
69
70
71
72	OPTION 3 – JYROS method – (minimum system requirements, player hours, by region) For this option, a studio uses the minimum system specifications for the game as a 'baseline' floor for energy consumption & emisisons, combined with either player hours or sales numbers (and playtime assumptions).
73
74	SET MINIMUM SPECS – GAME 1 NOTE: Pick only Intel OR AMD CPU, do not select both			Expected Minimum System Specs Total (Watts)		SET MINIMUM SPECS – GAME 2 NOTE: Pick only Intel OR AMD CPU, do not select both			Expected Minimum System Specs Total (Watts)		SET MINIMUM SPECS – GAME 3 NOTE: Pick only Intel OR AMD CPU, do not select both			Expected Minimum System Specs Total (Watts)		SET MINIMUM SPECS – GAME 4 NOTE: Pick only Intel OR AMD CPU, do not select both			Expected Minimum System Specs Total (Watts)
75	GAME NAME	Test 1		198		GAME NAME	Test 2		342.1		GAME NAME	Test 3		242		GAME NAME	Test 4		803
76		Component Name		Power (W)			Component Name		Power (W)			Component Name		Power (W)			Component Name		Power (W)
77	Intel CPU					Intel CPU	Intel Core i7-7700K Processor		91		Intel CPU					Intel CPU
78	AMD CPU	AMD Ryzen 5 3600		65		AMD CPU					AMD CPU	AMD Ryzen 9 7900X3D		120		AMD CPU	AMD Ryzen Threadripper 3990X		280
79	GPU	NVIDIA GeForce RTX 4060		115		GPU	NVIDIA GeForce RTX 3070		220		GPU	Radeon RX 5300 XT		100		GPU	NVIDIA GeForce RTX 4090		450
80	Rest of system overhead (10%)			18		Rest of system overhead (10%)			31.1		Rest of system overhead (10%)			22		Rest of system overhead (10%)			73
81
87
88									Add system components							TOTAL (kg CO2e)
89	Game	Location (country as 1st preference, use continent, region, or world only as last resort)	Location EF (automatic) (gCO2e per kWh)	Total player hours in Region	%age playtime time in VR (If title is VR exclusive = 100%, if no VR = 0%)	VR headset overhead (W) (12 W HMD + 5W controllers)	Minimum Device Spec expected power	Device Power Consumption (kWh)	VR power consumption (kWh)	Display – 92W (kWh)	Audio – 30W (kWh)	Device Emissions (kg CO2e)	System Emissions (kg CO2e)	Subtotals (kg CO2e)		102,602.92
90	Test 1	Australia	551.59	20,000.00	50%	17	198	3,960	170	1840	600	2184.2964	1439.6499	3623.9463
91	Test 1	France	44.18	20,000.00	0%	17	198	3,960	0	1840	600	174.9528	107.7992	282.752
92	Test 1	Finland	72.25	20,000.00	0%	17	198	3,960	0	1840	600	286.11	176.29	462.4
93	Test 1	Denmark	143.3	20,000.00	0%	17	198	3,960	0	1840	600	567.468	349.652	917.12
94	Test 2	Australia	551.59	1,000.00	100%	17	342.1	342	17	92	30	188.698939	76.67101	265.369949
95	Test 2	France	44.18	1,000.00	100%	17	342.1	342	17	92	30	15.113978	6.14102	21.254998
96	Test 2	Finland	72.25	1,000.00	100%	17	342.1	342	17	92	30	24.716725	10.04275	34.759475
97	Test 2	Denmark	143.3	1,000.00	100%	17	342.1	342	17	92	30	49.02293	19.9187	68.94163
98	Test 3	Australia	551.59	300,000.00	0%	17	242	72,600	0	27600	9000	40045.434	20188.194	60233.628
99	Test 3	France	44.18	300,000.00	0%	17	242	72,600	0	27600	9000	3207.468	1616.988	4824.456
100	Test 3	Finland	72.25	300,000.00	0%	17	242	72,600	0	27600	9000	5245.35	2644.35	7889.7
101	Test 3	Denmark	143.3	300,000.00	0%	17	242	72,600	0	27600	9000	10403.58	5244.78	15648.36
102	Test 4	Australia	551.59	11,100.00	0%	17	803	8,913	0	1021.2	333	4916.487147	746.963178	5663.450325
103	Test 4	France	44.18	11,100.00	0%	17	803	8,913	0	1021.2	333	393.789594	59.828556	453.61815
104	Test 4	Finland	72.25	11,100.00	0%	17	803	8,913	0	1021.2	333	643.985925	97.84095	741.826875
105	Test 4	Denmark	143.3	11,100.00	0%	17	803	8,913	0	1021.2	333	1277.27589	194.05686	1471.33275