Cost table input

Depending on the supply chain partner handling the installation of measures it is possible to overwrite default values in regards to costs and calculations when given as input.

General assumptions

Code	Description	Input	Default value
0	B.T.W. laag tarief (%)	Integer	9
1	B.T.W. hoog tarief (%)	Integer	21
2	Kosten gas vast (€/jaar)	Integer	257.58
3	Kosten gas variabel (€/m3)	Integer	0.774
4	Kosten elektriciteit vast (€/jaar)	Integer	317.6
5	Kosten elektriciteit variabel (€/kWh)	Integer	0.223
6	Kosten warmte vast (€/jaar)	Integer	493.13
7	Kosten warmte variabel (€/GJ)	Integer	0.2709
8	Looptijd (jaar)	Integer	25
9	Jaarlijkse stijging gasprijs (%)	Integer	3
10	Jaarlijkse stijging elektriciteitsprijs (%)	Integer	2
11	Jaarlijkse stijging warmteprijs (%)	Integer	3
12	Rente op besparingen (%)	Integer	1.7
13	Heffingskorting (€/jaar)	Integer	527.17
14	Isolatie aanpassingen B.T.W. tarief arbeid hoog	Integer	0
15	Overige aanpassingen B.T.W. tarief arbeid hoog	Boolean	1
21	Kosten biomassa vast (€/jaar)	Integer	0
22	Kosten biomassa variabel (€/kg)	Integer	0.3
23	Jaarlijkse stijging biomassaprijs (%)	Integer	3

Input schema

    "custom_costs": [
      {
        "code": 0,
        "value": 0
      }

Improvement costs per measure

All numbers from Material are Euro values, excluded of VAT. Download PDF for all possible default values to overwrite for the measures.

Note: all costs for insulation and glass are per square meter(m2).

Code	Description	Material	Work	Saving Material	Saving Work
10001	Wall insulation to type ''Matig/na-insulation''	22	14	20	13

Sustainability API - Input cost table - Improvement costs per measure.pdf

PDF · 152KB

Openen

Default improvement costs per measure from 1 January 2024

Default improvement costs code per measure from 1st January 2024

"improvement_costs": [
    {
        "code": 10001,
        "material": 14,
        "work": 9,
        "saving_material": 13,
        "saving_work": 8
    },
    {
        "code": 10002,
        "material": 46,
        "work": 70,
        "saving_material": 42,
        "saving_work": 65
    },
    {
        "code": 10003,
        "material": 91,
        "work": 65,
        "saving_material": 85,
        "saving_work": 60
    },
    {
        "code": 20002,
        "material": 10,
        "work": 16,
        "saving_material": 9,
        "saving_work": 15
    },
    {
        "code": 20003,
        "material": 22,
        "work": 27,
        "saving_material": 20,
        "saving_work": 25
    },
    {
        "code": 30002,
        "material": 84,
        "work": 148,
        "saving_material": 77,
        "saving_work": 137
    },
    {
        "code": 30003,
        "material": 119,
        "work": 168,
        "saving_material": 111,
        "saving_work": 155
    },
    {
        "code": 40002,
        "material": 25,
        "work": 64,
        "saving_material": 23,
        "saving_work": 60
    },
    {
        "code": 40003,
        "material": 52,
        "work": 70,
        "saving_material": 48,
        "saving_work": 66
    },
    {
        "code": 50001,
        "material": 57,
        "work": 128,
        "saving_material": 53,
        "saving_work": 119
    },
    {
        "code": 50002,
        "material": 53,
        "work": 110,
        "saving_material": 50,
        "saving_work": 100
    },
    {
        "code": 50003,
        "material": 134,
        "work": 34,
        "saving_material": 124,
        "saving_work": 32
    },
    {
        "code": 50102,
        "material": 135,
        "work": 320,
        "saving_material": 124,
        "saving_work": 295
    },
    {
        "code": 50103,
        "material": 361,
        "work": 94,
        "saving_material": 334,
        "saving_work": 86
    },
    {
        "code": 50203,
        "material": 361,
        "work": 94,
        "saving_material": 334,
        "saving_work": 86
    },
    {
        "code": 60001,
        "material": 1639,
        "work": 1661,
        "saving_material": 1518,
        "saving_work": 1538
    },
    {
        "code": 60002,
        "material": 2880,
        "work": 2681,
        "saving_material": 2667,
        "saving_work": 2482
    },
    {
        "code": 60003,
        "material": 3647,
        "work": 1689,
        "saving_material": 3378,
        "saving_work": 1564
    },
    {
        "code": 60004,
        "material": 4155,
        "work": 2339,
        "saving_material": 3848,
        "saving_work": 2165
    },
    {
        "code": 80004,
        "material": 6782,
        "work": 6755,
        "saving_material": 6281,
        "saving_work": 6254
    },
    {
        "code": 80104,
        "material": 2668,
        "work": 2354,
        "saving_material": 2470,
        "saving_work": 2180
    },
    {
        "code": 80204,
        "material": 2203,
        "work": 1363,
        "saving_material": 2040,
        "saving_work": 1262
    },
    {
        "code": 80305,
        "material": 4739,
        "work": 2076,
        "saving_material": 4388,
        "saving_work": 1923
    },
    {
        "code": 80406,
        "material": 2837,
        "work": 1243,
        "saving_material": 2627,
        "saving_work": 1152
    },
    {
        "code": 80506,
        "material": 2837,
        "work": 1243,
        "saving_material": 2627,
        "saving_work": 1152
    },
    {
        "code": 80006,
        "material": 10276,
        "work": 8841,
        "saving_material": 9516,
        "saving_work": 8186
    },
    {
        "code": 80106,
        "material": 5651,
        "work": 3738,
        "saving_material": 5232,
        "saving_work": 3461
    },
    {
        "code": 80306,
        "material": 4486,
        "work": 2329,
        "saving_material": 4154,
        "saving_work": 2157
    },
    {
        "code": 80007,
        "material": 25410,
        "work": 8416,
        "saving_material": 23527,
        "saving_work": 7793
    },
    {
        "code": 80107,
        "material": 18839,
        "work": 6087,
        "saving_material": 17445,
        "saving_work": 5635
    },
    {
        "code": 80407,
        "material": 18543,
        "work": 5991,
        "saving_material": 17170,
        "saving_work": 5547
    },
    {
        "code": 80008,
        "material": 9618,
        "work": 4640,
        "saving_material": 8906,
        "saving_work": 4297
    },
    {
        "code": 80108,
        "material": 10352,
        "work": 5199,
        "saving_material": 9585,
        "saving_work": 4814
    },
    {
        "code": 80408,
        "material": 10979,
        "work": 5514,
        "saving_material": 10165,
        "saving_work": 5105
    },
    {
        "code": 80009,
        "material": 13983,
        "work": 6731,
        "saving_material": 12948,
        "saving_work": 6233
    },
    {
        "code": 80109,
        "material": 10400,
        "work": 2476,
        "saving_material": 9629,
        "saving_work": 2292
    },
    {
        "code": 80209,
        "material": 9278,
        "work": 1608,
        "saving_material": 8590,
        "saving_work": 1489
    },
    {
        "code": 80029,
        "material": 18845,
        "work": 7515,
        "saving_material": 17449,
        "saving_work": 6958
    },
    {
        "code": 80129,
        "material": 19029,
        "work": 6627,
        "saving_material": 17619,
        "saving_work": 6136
    },
    {
        "code": 80529,
        "material": 19541,
        "work": 6115,
        "saving_material": 18093,
        "saving_work": 5662
    },
    {
        "code": 80030,
        "material": 10595,
        "work": 6888,
        "saving_material": 9810,
        "saving_work": 6378
    },
    {
        "code": 80130,
        "material": 7901,
        "work": 2295,
        "saving_material": 7317,
        "saving_work": 2124
    },
    {
        "code": 80430,
        "material": 5940,
        "work": 2376,
        "saving_material": 5500,
        "saving_work": 2200
    },
    {
        "code": 80031,
        "material": 11288,
        "work": 5205,
        "saving_material": 10452,
        "saving_work": 4820
    },
    {
        "code": 80131,
        "material": 11810,
        "work": 4683,
        "saving_material": 10935,
        "saving_work": 4337
    },
    {
        "code": 80431,
        "material": 11810,
        "work": 4683,
        "saving_material": 10935,
        "saving_work": 4337
    },
    {
        "code": 80010,
        "material": 2949,
        "work": 916,
        "saving_material": 2730,
        "saving_work": 848
    },
    {
        "code": 70000,
        "material": 140,
        "work": 164,
        "saving_material": 128,
        "saving_work": 153
    },
    {
        "code": 94001,
        "material": 547,
        "work": 111,
        "saving_material": 506,
        "saving_work": 103
    }
]

Column descriptions

Input	Format	Description	Translation
material	integer	Total investment cost per unit for material (excluding VAT).	Kosten totale investering per eenheid voor materiaal (exclusief BTW).
work	integer	Total investment cost per unit for the labor (excluding VAT)	Kosten besparingsdeel van de investering per eenheid voor arbeid (exclusief BTW).
saving_material	integer	Cost-saving part of the investment per unit for material (excluding VAT).	Kosten besparingsdeel van de investering per eenheid voor materiaal (exclusief BTW).
saving_work	integer	Cost-saving part of the investment per unit for the labor (excluding VAT).	Kosten besparingsdeel van de investering per eenheid voor de arbeid (exclusief BTW).

Input schema

"improvement_costs": [
      {
        "code": 0,  # code of a certain type measure, see General assumptions
        "material": integer,
        "work": integer,  
        "saving_material": integer,  
        "saving_work": integer 
      },
      ...
    ]

Input example

"improvement_costs": [
        {
            "code": 50001,
            "material": 57,
            "work": 128,
            "saving_material": 53,
            "saving_work": 119
        },
      ...
    ]

Saving work and -material numbers explained

The saving_material and saving_work variables per part concern the saving part of the investment, split into material and labour. This affects the final calculation of CO2 emissions and the ELG.

saving_material: cost saving part of the investment per unit for material (excluding VAT). saving_work: cost saving part of the investment per unit for labor (excluding VAT).

As a rule, the savings share is on average 92.5% (between 90 and 94%) of the investment in material and labour.