ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Quantifying Sustainable Practices
3
4
5
The Goal Of Quantification
6
7
• Having concrete numbers monitor change
8
• Enabling the sharing of findings in figures, articles, or even publictions to share ideas & convince others
9
• Motivate yourself by visulazing what you have achieved
10
11
12
About this Document
13
14
• Purpose: It shall be a template for you, providing the first stepping stone to quantifying your changes
15
o Editing and tailoring it to your needs is not only advised, it might be necessary at some points
16
17
• How we diverge from the average
18
o We included several partially redundant columns to provide a ready to use format for everyone & to allow you to compare several estimation methods
19
20
• About our design choices
21
o We decided for less advanced formulas and sparse use of colors to provide a well designed sheet, avoiding visual clutter and overwhelm
22
o We decided to use the more common metric system, but included $ as currency for our US users
23
24
• Tips for Handling Excel
25
o If you need more space, right click into a cell and choose “insert”, in this way, you can add a column or row. You can shift entries in a column up/down in this way. If you right click on the number of a row or letter of a column, you can select delete to delete it entirely (i.e., shift all other entries up)
26
o Formulas start with an equal sign (=) and then include the formula. Note that there are ways to copy and paste formulas across a row/column, and cells can be "fixed" by using $ signs before and after the letter. Edit formulas to include more cells by pushing control and select with your mouse or type in the command
27
o To switch “.” and “,” for the thousands separator: Click File > Options > Advanced under the Editing options heading, clear the Use system separators check box and set your preferences.
28
29
30
Remarks On Data Acquistion and Interpretation
31
32
• Results will always be more precise if measured directly, i.e., measuring power consumption with meters instead of calculating it based on manufacturer data and time used.
33
34
• Impacts will vary depending on geographical location. For example, GHG emissions per kWh depend heavily on the energy source used.
35
36
• Finally, take all data with a grain of salt. Tubes from different manufacturers weigh slightly more or less. Conversion factors, usage times, and consumption values are often just estimates. Thus, explicitly stating all assumptions/calculations and keeping used factors constant is essential.
37
38
39
Contact Point
40
41
ReAdvance
42
• Connection@re-advance.com | Patrick Penndorf
43
44
45
46
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