| A | 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | INSTRUCTIONS • This worksheet is for inputting data for disclosures under GHG Protocol Scope 3, Category 9 "Downstream transport and distributions" (i.e. game files downloaded by users) • This sheet includes sections for INITIAL DOWNLOAD based on the number of installs (e.g. for games on mobile) or sales data (console & PC) • This sheet also includes tabs for UPDATES to already installed 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 the red shaded boxes with your collected data • For questions and feedback, please reach out to ben@sustainablegamesalliance.org *** FUTURE FEATURES: – Validation of end user device threshholds for materiality – Platform specific game install file sizes – Supplier specific DC energy consumption data for major platforms (Steam, App Store, PSStore, etc) | ||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||
3 | Basic game settings Input some basic paramaters about each game | ||||||||||||||||||||||||||
4 | Game | Install file size (GB) (Use an approx figure if unure) | Released version(s) in reporting period | Reporting period selector **NB – Example sheet uses selector from other tab ** | 2024 | ||||||||||||||||||||||
5 | Squeepo | 6.900 | *not in use* | Network intensity assumption (kWh/GB): | 0.023 | Source: Aslan et al. (2018) using lowest measurement – dervied from Malmodin and Lundén (2016) | |||||||||||||||||||||
6 | Bleepo | 90.000 | *not in use* | DC data processing energy intensity default value (kWh/GB): | 0.277 | Source: SGA Calculations (see DC energy use) | |||||||||||||||||||||
7 | BKPC | 0.200 | *not in use* | 2024 Global Download Performance (MBps) (Mobile) | 56.11 | Source: OOKLA | |||||||||||||||||||||
8 | *not in use* | 2024 Global Download Performance (MBps) (Fixed) | 94.2 | Source: OOKLA | |||||||||||||||||||||||
9 | *not in use* | MBPs > GB/s multiplier | 0.000125 | ||||||||||||||||||||||||
10 | *not in use* | CPE power assumption (W) | 10 | ||||||||||||||||||||||||
11 | *not in use* | CPE allocation (%) | 50% | ||||||||||||||||||||||||
12 | *not in use* | ||||||||||||||||||||||||||
13 | *not in use* | ||||||||||||||||||||||||||
14 | *not in use* | Install GHG (tCO2e) | Update GHG totals (tCO2e) | End user device (tCO2e) | |||||||||||||||||||||||
15 | *not in use* | 30,919.55 | 23.40 | 3.42 | |||||||||||||||||||||||
16 | *not in use* | ||||||||||||||||||||||||||
17 | *not in use* | ||||||||||||||||||||||||||
18 | *not in use* | ||||||||||||||||||||||||||
19 | *not in use* | ||||||||||||||||||||||||||
20 | |||||||||||||||||||||||||||
21 | |||||||||||||||||||||||||||
22 | Installs (Measured by total installs, per region) and Updates by update file size (by region) For this option, a studio collects region-based data about the number of copies of the game installed on devices, using data reported by digital distribution platforms (Steam, Play Store, App Store, Unreal Store, etc). There are three components to this method: • Component A – Installs (to be completed by all reporters using the Standard – options for GENERIC platform, IMPORT FROM STEAM, and IMPORT FROM APP STORE). Users gather download data per region (country) and file size of installs. • Component B – Updates (to be completed by all users of the Standard, except those without game updates during the reporting period). NB: It is permitted to report game update data aggregated to the level of continent in a reporting period with several updates, however this will reduce accuracy. • Component C – End user energy consumption while downloading (OPTIONAL – only required when game file sizes are very large 100+ GB, or when player counts for a game are >1 million) If game versions are the same size download across all regions, leave "regional file size override" blank – however if some regions have larger/smaller game files (from extra language or localization files, etc) then use this column to record where different file sizes exist for a specific region. (Optional) | ||||||||||||||||||||||||||
23 | Component A: Installs (Generic platform) To be completed by all | Network component | DC component * If you have supplier-specific DC processing EF (kWh/GB) use override * | ||||||||||||||||||||||||
24 | Game | Location (country as 1st preference, use continent, region, or world only as last resort) | Number of installs | Location EF (automatic) (gCO2e per kWh) | Regional file size OVERRIDE (GB) (if no regional variation leave blank) | Energy consumption (kWh) | GHG emissions (tCO2e) | DC processing EF (kWh/GB) OVERRIDE (if no supplier data, use SGA default) | Energy consumption (kWh) | GHG emissions (tCO2e) | TOTAL energy consumption (kWh) | TOTAL GHG emissions (tCO2e) | |||||||||||||||
25 | Bleepo | Afghanistan | 100,000 | 123.71 | 207,000.00 | 25.60797 | 2,496,000.00 | 308.78016 | 2,703,000.00 | 334.38813 | |||||||||||||||||
26 | Bleepo | Austria | 50,000 | 102.62 | 103,500.00 | 10.62117 | 1,248,000.00 | 128.06976 | 1,351,500.00 | 138.69093 | |||||||||||||||||
27 | Bleepo | Brazil | 10,000 | 103.2 | 20,700.00 | 2.13624 | 249,600.00 | 25.75872 | 270,300.00 | 27.89496 | |||||||||||||||||
28 | Bleepo | Finland | 100,000 | 72.25 | 207,000.00 | 14.95575 | 2,496,000.00 | 180.336 | 2,703,000.00 | 195.29175 | |||||||||||||||||
29 | Bleepo | China | 66,500 | 559.55 | 85 | 130,007.50 | 72.74569663 | 1,659,840.00 | 928.763472 | 1,789,847.50 | 1001.509169 | ||||||||||||||||
30 | Bleepo | Australia | 1,000 | 551.59 | 2,070.00 | 1.1417913 | 24,960.00 | 13.7676864 | 27,030.00 | 14.9094777 | |||||||||||||||||
31 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
32 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
33 | Squeepo | India | 5,000,000 | 708.32 | 793,500.00 | 562.05192 | 9,568,000.00 | 6777.20576 | 10,361,500.00 | 7339.25768 | |||||||||||||||||
34 | Squeepo | China | 3,000,000 | 559.55 | 476,100.00 | 266.401755 | 5,740,800.00 | 3212.26464 | 6,216,900.00 | 3478.666395 | |||||||||||||||||
35 | Squeepo | Viet Nam | 3,000,000 | 471.16 | 476,100.00 | 224.319276 | 5,740,800.00 | 2704.835328 | 6,216,900.00 | 2929.154604 | |||||||||||||||||
36 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
37 | World | 473.13 | 0 | 0 | 0.00 | 0 | |||||||||||||||||||||
38 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
39 | <<< Expand row for more entries if required | | 0 | 0 | 0.00 | 0 | |||||||||||||||||||||
40 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
41 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
42 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
43 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
44 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
45 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
46 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
47 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
48 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
49 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
50 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
51 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
52 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
53 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
54 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
55 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
56 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
57 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
58 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
59 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
60 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
61 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
62 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
63 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
64 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
65 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
66 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
67 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
68 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
69 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
70 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
71 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
72 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
73 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
74 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
75 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
76 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
77 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
78 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
79 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
80 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
81 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
82 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
83 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
84 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
85 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
86 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
87 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
88 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
89 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
90 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
91 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
92 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
93 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
94 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
95 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
96 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
97 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
98 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
99 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||
100 | | 0 | 0 | 0.00 | 0 | ||||||||||||||||||||||