BCDEFGHIJKLMNOVWXYZ
2
Version historyNavigation Area:Table of contentsFurther GuidanceSummary_ProcessesSummary_Products
3
4
5
6
Sheet "Version history"
7
8
VersionDateDescription
9
0.12023/8/21first preliminary published version
10
1.02023/10/23Sheet A: UNLOCODE made mandatory
11
Sheet B: Calculation of emissions corrected (incl. adding missing factor of 3.664 in the mass balance)
12
Sheet C: Inconsistency between cells L16 and L17 fixed
13
Sheet D: Electricity exported bug fixed
14
Sheet Summary processes: broken references to “production process 1” fixed
15
Sheet Summary products: Scrap per t steel/aluminium: values >100% can be entered now
16
1.12023/11/7Fixed bug 'CN code ranges' in sheet Summary_Products
17
2.02024/3/19Improvements and fixed bugs:
18
Sheet a_contents: Error in sheet names in table of contents for certain Excel versions
19
Sheet b: Link to implementing act corrected
20
Sheet A: Inconsistency warning for production routes added
21
Sheet B: Source stream calculation corrected (all percentage values need to be entered as numbers [0..100]). A warning for incomplete data has been added.
22
Sheet B: PFC emissions (2nd source stream) incl. further improvements
23
Sheet C: Fixed inputs and formulae in L25 and L26
24
Sheet E: Decomposed SEE (indirect) into entries for electricity consumption and emission factor. Consequently, in the summary sheets there is now consistent display of "specific embedded electricity consumption" taking into account the electricity consumption of precursors for consistent and complete calculation of embedded indirect emissions.
25
Sheet E: More completeness indicators added.
26
Sheet E: Navigation area extended to cover all 20 possible precursors
27
Sheet F: CHP tool corrected for taking into account emissions from flue gas cleaning.
28
Sheet G: Guidance texts have been revised. An additional guidance section for sheet E has been added.
29
Sheet Summary_Processes: The processes' activity levels have been added in Table 2.1.a. Corrected CP due and rebate in the sectio 3 tables.
30
Sheet Summary_Products: Consistent units for carbon price due
31
Sheet Summary_Products: Qualifying parameters (columns R to AA) made optional
32
General: Consistent units for the good "Electricity" expressed as MWh
33
General: Further clarification in guidance texts at several locations
34
General: Uniform formatting, conditional formats improved
35
2.0.12024/4/8Minor errors corrected:
Sheet a_contents: Broken hyperlinks fixed
Sheet A: Double reference to PP17 (section 5) corrected
Sheet E: Wrong guidance text under item v. corrected
36
2.12024/6/5Minor revision of the CN code list, field for further information on carbon price instruments added
37
Conditional format bug in sheet Summary_Products corrected
38
2.1.12024/12/13Addition automatic calculation of Electricity EF in Summary_Communication
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
101
102