ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LegendOptie 1Introduction
This is an open-source calculation-tool to calculate the CO2 storage of construction works with biobased building materials (a.k.a. products). Sources are transparently reported in the data worksheet 'CO2-storage factors'. Calculations can be transparently reviewed wherever they are used. However, all worksheets are protected from editting to protect the intigrity of the tool. Only the fields where input is required are unprotected. There are a few columns that both contain Excel-formulas and can require input, it is therefore useful to be careful when filling in required input. However, when you like to reverse the input either use Ctrl+z or select and copy a cell in the same column with the Excel-formula still in place. If there are any questions, or you like me (the developer of the tool) to complete the calculation, feel free to contact me.

Project_data
This is an empty worksheet available to you to put in all your required project data needed for the 'Calculation-input' worksheet. This should make it easier for you to fill in/work with your data in this tool rather then working in two separate Excel-files. It also avoids that there are references created to external and/or not local Excel-files which can cause errors when the tool is shared with others.

Calculation-input
This is basically the only sheet in which you work. Here you find columns with input-cells, this is where you are required to fill in particular information. You can fill in the project name, the number of residencies (this is 1 by default) and the (average) living area of the residency/ies.
In column A of the table, you can select the construction level (this is optional);
In column B, you have to select a product category. If you are not sure to which category your desired product belongs to, you can check the worksheet 'Drop-down_lists';
In column C, you can finally select the biobased builiding material;
In column D, cells will format as input cell whenever more information is required. Cells can also provide important additional information, it is therefore a good idea to read the text appearing in these cells closely;
In column E, the average density of the product is retrieved from the worksheet 'CO2-storage factors' and shown in here. You are allowed to replace or add (if missing) the density or the product. It is important to note that whenever there is no density available and the cell in column E remains empty, you cannot use quantity of products in volumetric units (i.e. m3) which are selected in column G;
In column F, the quantity of the product you selected in column C can be filled in here;
In column G, you select the unit that corresponds to the quantity filled in column F. With some products there is a fixed unit and you should not change the pre-input unit unless you have filled-in the density and the pre-input unit is "kg"; and finally
In column H, the CO2 stored in the quantity of selected product is calculated.
In cell G1, the total stored CO2 is calculated. In cell G2, the CO2 stored per residency is calculated and in cell G3, the CO2 stored per 120m2 is calculated. The CO2 stored per 120m2 serves as a comparison unit enabling to compare it with a modale residency (and other projects calculated using this tool).

Add custom biobased products
It is possible to add custom biobased products (or biobased products that are not yet included or have better performance than the products included in the 'CO2-storage factors' worksheet/table). Please note that, when you decide to add a custom product, you are required to possess all required data (CO2 storage/kg product and density). If you like to add a custom biobased product, it is important to follow the instructions provided below and in the 'Calculation-input' worksheet. You can follow the following steps:
1) Select 'Custom' in column B under 'Product category';
2) Provide a name in column C;
3) Provide the amount of CO2 stored in kgCO2/kg product in column D;
4) In column E, provide the density of the product in kg/m3;
5) Fill in the rest of the columns as described previously in 'Calculation-input'.

CO2-storage factors
This worksheet contains the data required behind the calculations, data of CO2 storage and density of products. If you have products that you like to be added to the data-list, please tell me by contacting bart@climatecleanup.org. Next to the name of the product and what it is used for, if possible/known also provide the amount of CO2 storage and density with a source!

Wood-types
This worksheet contains wood densities of a wide variety of wood types that could be used for calculating CO2 storage in the respective wood type. Sequestration is based on the wood densities and calculated according to the NEN 16449. The equation used to calculated the CO2 storage of the wood is also shown on this worksheet.

Drop-down_lists
Simply contains the information required for generating the drop-down lists that are used in the 'Calculation-input' worksheet.
2
abc / 123Input cell
3
123
Calculation
4
123
Fixed unit
5
abc / 123Warning
6
!@#$
Invalid value
7
8
Developed by:
9
Bart van Valenberg | LinkedIn
10
bart@climatecleanup.org
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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