{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Ohje","Lähtötiedot","Tulokset","Materiaalitiedot","Ennen käyttöä (A)","Materiaalit (A1-3)","Käyttö (B)","Loppu ja lisätiedot (C+D)","Datalehti"],"not_rendered":{"charts":2,"images":7,"macros":1,"defined_names":27,"comments":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Ohje","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"merged":[[1,1,1,2],[6,1,6,2],[9,1,9,2],[13,1,13,2],[15,1,15,2],[17,1,17,2],[20,1,20,2]]}
[]
[null,"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"]
[null,"Luonnos lausuntokierrosta varten 16.11.2018"]
[]
[null,"Käyttöohje"]
[]
[null,"Tämä arviointityökalun luonnosversio on tarkoitettu rakennuksen hiilijalanjäljen laskentamenetelmän lausuntokierrosta varten. Työkalua ja sen liitteenä olevia päästötietoja kehitetään lausuntokierroksen jälkeen.\n\nAvoimen työkalun tarkoituksena on tukea ja edistää elinkaarilaskennan käyttöä rakennushankkeen valmistelussa, suunnittelussa, rakentamisessa ja rakennusten käytön aikana. Tämä työkalu on tarkoitettu rakennusten elinkaaren hiilijalanjäljen arviointiin ensisijaisesti silloin, kun käytetään ympäristöministeriön yksinkertaistettua arviointimenetelmää. Työkalua voidaan käyttää myös tarkennetulla arviointimenetelmällä tehtyjen laskelmien raportointiin. Arvioinnit voi tehdä myös muilla soveltuvilla työkaluilla. "]
[]
[null,"Työkalun sisältö"]
[null,"Työkalun eri välilehdillä kerätään tietoa hankkeesta ja sen elinkaarivaikutuksista seuraavasti:\n\nLähtötiedot: Käytetyn lähtötiedon luotettavuuden arviointi\nTulokset: Arvioinnin tulokset, tiedot arvioitavasta kohteesta ja arvioinnin teosta\nMateriaalitiedot: Työkalussa käytettävien hiilijalanjäljen ja -kädenjäljen kertoimet\nEnnen käyttöä: Valmistuksen, kuljetuksen ja rakentamisen päästöt\nMateriaalit: Rakennuksessa käytettyjen materiaalien luettelointi\nKäyttö: Korjausten ja energiankulutuksen arviointi\nLoppu ja lisätiedot:  Purkamisen ja jätteiden käsittelyn arviointi\n"]
[null,"Laskentatietojen syöttäminen "]
[]
[null,"Syötä tiedot harmaisiin soluihin."]
[null,"Tietoja voidaan lisätä tummansinisellä otsikoituihin kohtiin. Syötä tiedot harmaapohjaisiin soluihin."]
[null,"Valmiit taulukkoarvot sinisissä soluissa."]
[null,"Yksinkertaistetussa menetelmässä suurin osa laskennan tiedoista tulee hanketyyppiin ja pinta-alaan perustuvista taulukkoarvoista. Tällaiset kohdat työkalussa on otsioitu vaaleansinisellä värillä."]
[null,"Lisätietoja voit syöttää vihreisiin soluihin."]
[null,"Jos korvaat taulukkoarvoja omin laskelmin, syötä nämä tiedot vihreisiin soluihin. Taulukkoarvon vieressä olevaa plus-merkkiä painamalla aukeaa uusi tietokenttä tätä varten. Vaalean vihreisiin soluihin syötetyt arvot korvaavat oletuksena olevat taulukkoarvot. Muista kirjata ylös, mihin tietoihin omat laskelmasi perustuvat. Esimerkki:"]
[]
[null,"Käyttöoikeus ja vastuuvapaus"]
[null,"Työkalu on käytettävissä veloituksetta. Työkalun luonnosversio on tarkoitettu ainoastaan lausuntokierrosta varten.\n \nYmpäristöministeriö ei vastaa mistään vahingoista, jotka mahdollisesti aiheutuvat arviointityökalun käyttäjälle tai muulla taholle arviointityökalua käytettäessa tai muuten sovellettaessa siinä olevia toimintamalleja tai esimerkkejä."]

{"sheet":"Lähtötiedot","index":1,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[4,1,4,2],[7,1,7,7],[23,3,23,4],[23,5,23,6],[24,3,24,4],[24,5,24,6],[25,3,25,4],[25,5,25,6],[26,3,26,4],[26,5,26,6],[27,3,27,4],[27,5,27,6],[31,1,31,7]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[]
[null,"Lähtötietojen arviointi"]
[]
[null,"Tietojen laatu"]
[null,"Arvioinnissa käytettävien tietojen laatu tulee arvioida, jos arviointi tehdään käyttäen ns. tarkennettua menetelmää. Yksinkertaistettua menetelmää käytettäessä tätä välilehteä ei tarvitse täyttää. \nAlla ehdotettu lähtötietojen arviointitapa perustuu Euroopan komission Level(s)-menetelmään."]
[null,"Elinkaaren vaiheet","Teknologinen edustavuus","Maan-tieteellinen edustavuus","Ajallinen edustavuus","Epävarmuus","Yhteensä","Vähimmäisvaatimukset"]
[]
[null,"A1–3 Tuotteiden valmistus",{"$nulls":4},{"$f":"(SUM(C11:F11))","v":0},"Tiedot vähintään tasoa 2"]
[null,"A4 Kuljetus työmaalle",{"$nulls":4},{"$f":"IFERROR(SUM(C12:F12),\"\")","v":0},"Maantieteellinen edustavuus oltava tasoa 3"]
[null,"A5 Työmaan toiminnot",{"$nulls":4},0,"Maantieteellinen edustavuus vähintään tasoa 2"]
[null,"B3–4 Korjaukset ja vaihdot",{"$nulls":4},0,"Maantieteellinen edustavuus vähintään tasoa 2"]
[null,"B6 Energian kulutus",{"$nulls":4},0,"Tiedot vähintään tasoa 2"]
[null,"C1 Purkutyöt",{"$nulls":4},0,"Ei vähimmäisvaatimuksia"]
[null,"C2 Kuljetus jatkokäsittelyyn",{"$nulls":4},0,"Ei vähimmäisvaatimuksia"]
[null,"C3 Jätteenkäsittely",{"$nulls":4},0,"Ei vähimmäisvaatimuksia"]
[null,"C4 Loppusijoitus",{"$nulls":4},0,"Ei vähimmäisvaatimuksia"]
[null,"D Elinkaaren ulkopuoliset",{"$nulls":4},0,"Ei vähimmäisvaatimuksia"]
[null,"Yhteensä",{"$f":"SUM(C11:C20)","v":0},{"$f":"SUM(D11:D20)","v":0},0,0]
[]
[null,"Tietojen laadun arvioinnissa käytettävä pisteytys"]
[null,null,0,1,null,2,null,3]
[null,"Teknologinen edustavuus ","Ei arvioitu","Tieto ei vastaa tyydyttävästi tuotteen teknisiä ominaisuuksia",null,"Tieto vastaa osittain tuotteen teknisiä ominaisuuksia ",null,"Käytetty tieto vastaa hyvin tuotteen teknisiä ominaisuuksia"]
[null,"Maantieteellinen edustavuus","Ei arvioitu","Tieto viittaa täysin erilaiseen maantieteelliseen kontekstiin (esim. Italia Suomen sijaan)",null,"Tieto viittaa samankaltaiseen maantieteelliseen kontekstiin (esim. Norja Suomen sijaan)",null,"Käytetty tieto viittaa tiettyyn maantieteelliseen kontekstiin"]
[null,"Ajallinen edustavuus","Ei arvioitu","Tiedon validoinnin ja sen hyödyntämisen välillä on yli 6 vuotta ",null,"Tiedon validoinnin ja sen hyödyntämisen välillä on 2-4 vuotta",null,"Tiedon validoinnin ja sen hyödyntämisen välillä on alle 2 vuotta"]
[null,"Epävarmuus","Ei arvioitu","Käytetään mallinnettua tai vastaavaa tietoa. Paikkansapitävyys ja täsmällisyys on arvioitu laadullisesti (esim. toimittajan ja prosessin operaattorin asiantuntija-arvio)",null,"Käytetään mallinnettua tai vastaavaa tietoa, joka on arvioitu tyydyttävän paikkansapitäväksi ja täsmälliseksi, ja sitä tukee määrällinen epävarmuusarvio",null,"Käytetään hankekohtaista ja validoitua tietoa, jota voidaan pitää tyydyttävän paikkansapitävänä ja täsmällisenä (esim. tehty vahvistettu EPD)"]
[]
[null,"Selvitys käytetyistä lähteistä"]
[null,"Kirjaa alla olevaan tilaan mistä lähteistä arvioinnissa käytetyt tiedot ja oletukset ovat peräisin."]

{"sheet":"Tulokset","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[1,1,1,3],[6,1,6,4],[7,1,9,1],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,1,15,1],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[21,1,21,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,1,36,2],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[]
[null,"Laskennan tulokset"]
[]
[null,"Lähtötiedot"]
[null,"Rakennuskohteen tiedot","Rakennustunnus"]
[null,null,"Osoite"]
[null,null,"Rakennustyyppi"]
[null,"Rakennuksen tekniset tiedot","Kerrosala [kem2]"]
[null,null,"Lämmitetty nettoala [m2netto]"]
[null,null,"Kerrosten lukumäärä"]
[null,null,"Kellarikerrosten lukumäärä"]
[null,null,"Pääasiallinen runkomateriaali"]
[null,null,"Energialuokka"]
[null,"Laskennan tiedot","Laskenta-ajanjakso",{"$f":"IF(D10=\"\",\"\",IF(D10=Datalehti!H34,75,50))","v":""}]
[null,null,"Arvioinnin tekovaihe"]
[null,null,"Käytetty arviointitapa"]
[null,null,"Rakennuksen arvioitu käyttöönottovuosi"]
[]
[null,"Elinkaariarvioinnin tulokset",null,"Hiilijalanjälki","Hiilikädenjälki"]
[{"$nulls":3},"kg CO2e/m2netto","kg CO2e/m2netto"]
[null,"Elinkaaren aikana syntyvät päästöt yhteensä (A-D) ",null,{"$f":"IFERROR(('Ennen käyttöä (A)'!C8+'Käyttö (B)'!D9+'Loppu ja lisätiedot (C+D)'!D9)/$D12,\"\")","v":""},{"$f":"IFERROR(('Ennen käyttöä (A)'!D8+'Käyttö (B)'!E9+'Loppu ja lisätiedot (C+D)'!E9)/$D12,\"\")","v":""}]
[{"$nulls":7},{"$f":"D22","v":"Hiilijalanjälki"},{"$f":"E22","v":"Hiilikädenjälki"}]
[null,"Päästöt ennen käyttöä (vaiheet A1-5)",null,{"$f":"IFERROR('Ennen käyttöä (A)'!C8/$D12,\"\")","v":""},{"$f":"IFERROR('Ennen käyttöä (A)'!D8/$D12,\"\")","v":""},null,{"$f":"B35","v":"Elinkaaren ulkopuoliset vaikutukset (D)"},{"$f":"D35","v":""},""]
[null,"Tontti",null,{"$f":"IFERROR('Ennen käyttöä (A)'!C11/$D12,\"\")","v":""},{"$f":"IFERROR('Ennen käyttöä (A)'!D11/$D12,\"\")","v":""},null,{"$f":"B33","v":"Päästöt käytön jälkeen (vaihe C)"},{"$f":"D33","v":""},""]
[null,"Kantavat rakenteet",null,{"$f":"IFERROR('Ennen käyttöä (A)'!C12/$D12,\"\")","v":""},{"$f":"IFERROR('Ennen käyttöä (A)'!D12/$D12,\"\")","v":""},null,{"$f":"B31","v":"Päästöt käytön aikana (vaiheet B3-4, 6)"},{"$f":"D31","v":""},""]
[null,"Kevyet rakenteet",null,{"$f":"IFERROR('Ennen käyttöä (A)'!C13/$D12,\"\")","v":""},{"$f":"IFERROR('Ennen käyttöä (A)'!D13/$D12,\"\")","v":""},null,{"$f":"B26","v":"Päästöt ennen käyttöä (vaiheet A1-5)"},{"$f":"D26","v":""},""]
[null,"Talotekniikka",null,{"$f":"IFERROR('Ennen käyttöä (A)'!C14/$D12,\"\")","v":""},{"$f":"IFERROR('Ennen käyttöä (A)'!D14/$D12,\"\")","v":""},null,{"$f":"B30","v":"Talotekniikka"},{"$f":"D30","v":""},""]
[null,"Päästöt käytön aikana (vaiheet B3-4, 6)",null,{"$f":"IFERROR('Käyttö (B)'!D9/$D12,\"\")","v":""},{"$f":"IFERROR('Käyttö (B)'!E9/$D12,\"\")","v":""},null,{"$f":"B29","v":"Kevyet rakenteet"},{"$f":"D29","v":""},""]
[{"$nulls":6},{"$f":"B28","v":"Kantavat rakenteet"},{"$f":"D28","v":""},""]
[null,"Päästöt käytön jälkeen (vaihe C)",null,{"$f":"IFERROR(('Loppu ja lisätiedot (C+D)'!D9-'Loppu ja lisätiedot (C+D)'!D29)/$D12,\"\")","v":""},{"$f":"IFERROR(('Loppu ja lisätiedot (C+D)'!E9-'Loppu ja lisätiedot (C+D)'!E29)/$D12,\"\")","v":""},null,{"$f":"B27","v":"Tontti"},{"$f":"D27","v":""},""]
[]
[null,"Elinkaaren ulkopuoliset vaikutukset (D)",null,{"$f":"IFERROR('Loppu ja lisätiedot (C+D)'!D29/$D12,\"\")","v":""},{"$f":"IFERROR('Loppu ja lisätiedot (C+D)'!E29/$D12,\"\")","v":""}]
[]
[null,"Arvionnin tekijät"]
[null,null,"Arvioinnin laatija","Arvioinnin tarkastaja"]
[null,"Nimi"]
[null,"Koulutus"]
[null,"Päivämäärä"]

{"sheet":"Materiaalitiedot","index":3,"n_rows":237,"n_cols":10,"rows_kept":237,"merged":[[5,1,5,7]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[]
[null,"Materiaalitiedot"]
[null,"© VTT 2018. Testausvaiheen geneerinen päästötaulukko perustuu VTT:n eri lähteistä kokoamiin ja arvioimiin tuloksiin. Arvot on koottu siten, että ne kattavat elinkaaren vaiheet A1 - A5 (vaiheessa A5 vain arvioidun hukan osalta). VTT:llä on yksinomainen omistus- ja tekijänoikeus kokonaistaulukkoon. Taulukkoa saa käyttää testaamiseen eikä sitä saa muuttaa, käyttää eikä luovuttaa käytettäväksi muuhun tarkoitukseen ilman VTT:n nimenomaista suostumusta. \nTaulukko on tarkoitettu vain menetelmän testausvaiheeseen eikä VTT ota vastuuta siihen sisältyvien tietojen oikeellisuudesta."]
[null,"Materiaali","CO2e","Hiilisisältö","CO2e","Hiilijalanjälki","Hiilikädenjälki","Yksikkö"]
[null,"BETONI","kg/kg","kg CO2/kg","kg/m2"]
[null,"Betoni, lattiabetoni (35)",{"v":0.15497999999999998,"d":"0.155"},null,null,{"$f":"IF(E9=\"\",IF(C9=\"\",\"\",C9),E9)","v":{"v":0.15497999999999998,"d":"0.155"}},{"$f":"IF(F9=\"\",\"\",D9*-1)","v":{"v":0,"d":"0.00"}},{"$f":"IF(F9=\"\",\"\",(IF(E9=\"\",\"CO2e/kg\",\"CO2e/m2\")))","v":"CO2e/kg"},{"$f":"IF(F9=\"\",\"\",(IF(E9=\"\",\"kg\",\"m2\")))","v":"kg"},"Huom: Betoni- ja sementtituotteiden hiilikädenjälki (keskimääräiset karbonatisoitumistiedot) laaditaan lausuntokierroksen jälkeen."]
[null,"Betonikuori 100 mm+musta teräs",{"v":0.19142008000000002,"d":"0.191"},null,null,{"v":0.19142008000000002,"d":"0.191"},{"$f":"IF(F10=\"\",\"\",D10*-1)","v":{"v":0,"d":"0.00"}},{"$f":"IF(F10=\"\",\"\",(IF(E10=\"\",\"CO2e/kg\",\"CO2e/m2\")))","v":"CO2e/kg"},{"$f":"IF(F10=\"\",\"\",(IF(E10=\"\",\"kg\",\"m2\")))","v":"kg"}]
[null,"Betonikuori 150 mm+musta teräs",{"v":0.1931541,"d":"0.193"},null,null,{"v":0.1931541,"d":"0.193"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betonikuori 80 mm+musta teräs",{"v":0.18968605999999996,"d":"0.190"},null,null,{"v":0.18968605999999996,"d":"0.190"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoniulkokuori+ruostumaton teräs",{"v":0.21104802,"d":"0.211"},null,null,{"v":0.21104802,"d":"0.211"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Elementti, betoniväliseinä",{"v":0.20158,"d":"0.202"},null,null,{"v":0.20158,"d":"0.202"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni 16/20 Mpa",{"$f":"0.1*1.1+(20*(0.038/1000))","v":{"v":0.11076000000000001,"d":"0.111"}},null,null,{"v":0.11076000000000001,"d":"0.111"},{"v":0,"d":"0.00"},"CO2e/kg","kg","Pelkkä betoni, ei raudoituksia."]
[null,"Betoni 20/25 Mpa",{"$f":"0.107*1.1+(20*(0.038/1000))","v":{"v":0.11846000000000001,"d":"0.118"}},null,null,{"v":0.11846000000000001,"d":"0.118"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni 25/30 Mpa",{"$f":"0.113*1.1+(20*(0.038/1000))","v":{"v":0.12506,"d":"0.125"}},null,null,{"v":0.12506,"d":"0.125"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni 28/35 Mpa",{"$f":"0.12*1.1+(20*(0.038/1000))","v":{"v":0.13276000000000002,"d":"0.133"}},null,null,{"v":0.13276000000000002,"d":"0.133"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni 32/40 Mpa",{"$f":"0.132*1.1+(20*(0.038/1000))","v":{"v":0.14596000000000003,"d":"0.146"}},null,null,{"v":0.14596000000000003,"d":"0.146"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni 40/50 Mpa",{"$f":"0.151*1.1+(20*(0.038/1000))","v":{"v":0.16686,"d":"0.167"}},null,null,{"v":0.16686,"d":"0.167"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni, pihalaatta",0.137,null,null,0.137,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni, kattotiili",{"v":0.15157120000000002,"d":"0.152"},null,null,{"v":0.15157120000000002,"d":"0.152"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni, harkko",{"v":0.1012,"d":"0.101"},null,null,{"v":0.1012,"d":"0.101"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kevytbetoni, harkko (siporex)",{"v":0.29147700000000004,"d":"0.291"},null,null,{"v":0.29147700000000004,"d":"0.291"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"ERISTE",{"$nulls":3},"","","",""]
[null,"Eriste, EPS",{"v":3.4072162620000004,"d":"3.407"},null,null,{"v":3.4072162620000004,"d":"3.407"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, kierrätyspaperi 45 kg/m3",{"v":0.2224791,"d":"0.222"},null,null,{"v":0.2224791,"d":"0.222"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, kierrätyspaperi, 55 kg/m3",{"v":0.221502,"d":"0.222"},null,null,{"v":0.221502,"d":"0.222"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, kierrätyspaperi, puhallus 35 kg/m3",{"v":0.21754199999999999,"d":"0.218"},null,null,{"v":0.21754199999999999,"d":"0.218"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, lasivilla, erikoisjäykkä 100 kg/m3",{"v":1.53,"d":"1.530"},null,null,{"v":1.53,"d":"1.530"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, lasivilla, pehmeä 45 kg/m3",{"v":1.53,"d":"1.530"},null,null,{"v":1.53,"d":"1.530"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, polyuretaani, 40 kg/m3",{"v":4.353755862,"d":"4.354"},null,null,{"v":4.353755862,"d":"4.354"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, polyuretaani, 60 kg/m3",{"v":4.353755862,"d":"4.354"},null,null,{"v":4.353755862,"d":"4.354"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, vuorivilla, erikoisjäykkä, 100 kg/m3",{"v":1.0259812799999999,"d":"1.026"},null,null,{"v":1.0259812799999999,"d":"1.026"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, vuorivilla, pehmeä 35 kg/m3",{"v":1.0259812799999999,"d":"1.026"},null,null,{"v":1.0259812799999999,"d":"1.026"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, vuorivilla, puhallusvilla, 15 kg/m3",{"v":1.005864,"d":"1.006"},null,null,{"v":1.005864,"d":"1.006"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, vuorivilla, tuulensuoja, 65 kg/m3",{"v":1.0259812799999999,"d":"1.026"},null,null,{"v":1.0259812799999999,"d":"1.026"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, XPS, 50 kg/m3",{"v":3.4072162620000004,"d":"3.407"},null,null,{"v":3.4072162620000004,"d":"3.407"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Eriste, tuulensuoja, lasivilla, 75 kg/m3",1.153,null,null,1.153,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"METALLI",{"$nulls":3},"","","",""]
[null,"Alumiini",{"v":2.338112,"d":"2.34"},null,null,{"v":2.338112,"d":"2.338"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kupari",{"v":2.718246,"d":"2.72"},null,null,{"v":2.718246,"d":"2.718"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Sinkki",{"v":3.10919,"d":"3.109"},null,null,{"v":3.10919,"d":"3.109"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Galvanoitu teräs",{"v":2.75679,"d":"2.757"},null,null,{"v":2.75679,"d":"2.757"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Ruostumaton teräs",4.758,null,null,4.758,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Rauta",{"v":2.05299,"d":"2.053"},null,null,{"v":2.05299,"d":"2.053"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"MUOVIT ja KUMIT",{"$nulls":3},"","","",""]
[null,"Bitumi",{"v":0.334,"d":"0.33"},null,null,0.334,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"EPDM",{"v":2.694,"d":"2.69"},null,null,2.694,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"EPS",{"v":3.30558,"d":"3.31"},null,null,{"v":3.30558,"d":"3.306"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"MF (melamiini, laminaatti)",{"v":4.623,"d":"4.62"},null,null,4.623,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PA (nylon)",{"v":7.238,"d":"7.24"},null,null,7.238,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PC (polykarbonaatti)",{"v":4.168,"d":"4.17"},null,null,4.168,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PE-HD",{"v":1.838,"d":"1.84"},null,null,1.838,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PE-LD",{"v":1.9080000000000001,"d":"1.91"},null,null,{"v":1.9080000000000001,"d":"1.908"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PE-MD",{"v":1.828,"d":"1.83"},null,null,1.828,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PET",{"v":2.2279999999999998,"d":"2.23"},null,null,{"v":2.2279999999999998,"d":"2.228"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PEX",{"v":1.838,"d":"1.84"},null,null,1.838,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PMMA (akryyli, sheet)",{"v":4.808,"d":"4.81"},null,null,4.808,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PP",{"v":1.668,"d":"1.67"},null,null,1.668,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PS (polystyreeni)",3.43,null,null,{"v":3.43,"d":"3.430"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PUR (polyuretaani)",{"v":2.9379999999999997,"d":"2.94"},null,null,{"v":2.9379999999999997,"d":"2.938"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"PVC",{"v":2.028,"d":"2.03"},null,null,2.028,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"XPS",{"v":2.58758,"d":"2.59"},null,null,{"v":2.58758,"d":"2.588"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"KOSTEUSERISTE",{"$nulls":3},"","","",""]
[null,"Kosteussulku",{"v":3,"d":"3.00"},null,null,{"v":3,"d":"3.000"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"KATE",{"$nulls":3},"","","",""]
[null,"Kate, betonikattotiili",{"v":0.16305785599999997,"d":"0.16"},null,null,{"$f":"IF(E73=\"\",IF(C73=\"\",\"\",C73),E73)","v":{"v":0.16305785599999997,"d":"0.163"}},{"v":0,"d":"0.00"},{"$f":"IF(F73=\"\",\"\",(IF(E73=\"\",\"CO2e/kg\",\"CO2e/m2\")))","v":"CO2e/kg"},"kg"]
[null,"Kate, aluskermi, 2,4 kg/m2",{"v":2.287190412831042,"d":"2.29"},null,{"v":5.489256990794501,"d":"5.5"},{"v":5.489256990794501,"d":"5.489"},{"$f":"IF(F74=\"\",\"\",D74*-1)","v":{"v":0,"d":"0.00"}},"CO2e/m2",{"$f":"IF(F74=\"\",\"\",(IF(E74=\"\",\"kg\",\"m2\")))","v":"m2"}]
[null,"Kate, bitumikattolaatta, 8,5 kg/m2",{"v":2.293372374621794,"d":"2.29"},null,{"v":19.493665184285252,"d":"19.5"},{"v":19.493665184285252,"d":"19.494"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Kate, bitumikermi, pinta + 2 alus, 13,3 kg/m2",{"v":0.9713496345368461,"d":"0.97"},null,{"v":12.627545248978999,"d":"12.6"},{"v":12.627545248978999,"d":"12.628"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Kate, kupari",{"v":2.104,"d":"2.10"},null,null,2.104,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kate, teräs, sinkitty",2.75,null,null,{"v":2.75,"d":"2.750"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kate, teräs, sinkitty ja maali",2.91,null,null,{"v":2.91,"d":"2.910"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"LAATTA",{"$nulls":3},"","","",""]
[null,"Laatta, betoni + teräkset",{"v":0.15497999999999998,"d":"0.15"},null,null,{"v":0.15497999999999998,"d":"0.155"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, ontelolaatta, 150",{"v":0.17785,"d":"0.18"},null,null,{"v":0.17785,"d":"0.178"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, ontelolaatta, 200",{"v":0.17785,"d":"0.18"},null,null,{"v":0.17785,"d":"0.178"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, ontelolaatta, 265",{"v":0.17785,"d":"0.18"},null,null,{"v":0.17785,"d":"0.178"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, ontelolaatta, 320",{"v":0.17785,"d":"0.18"},null,null,{"v":0.17785,"d":"0.178"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, ontelolaatta, 400",{"v":0.17785,"d":"0.18"},null,null,{"v":0.17785,"d":"0.178"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, ontelolaatta, 500",{"v":0.17785,"d":"0.18"},null,null,{"v":0.17785,"d":"0.178"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Laatta, TT",{"v":0.222282,"d":"0.22"},null,null,{"v":0.222282,"d":"0.222"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Liittolaatta",{"v":0.37207900000000005,"d":"0.37"},null,null,{"v":0.37207900000000005,"d":"0.372"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"PÄÄLLYSTE",{"$nulls":3},"","","",""]
[null,"Lattiapäällyste, muovimatto",{"v":1.3956022234800003,"d":"1.396"},null,null,{"v":1.3956022234800003,"d":"1.396"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lattiapäällyste, parketti + alusrak.",{"v":0.6425351671232876,"d":"0.643"},null,null,{"v":0.6425351671232876,"d":"0.643"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lattiapäällyste, linoleum",{"v":0.38784722222222223,"d":"0.388"},null,null,{"v":0.38784722222222223,"d":"0.388"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lattiapäällyste, kumi",{"v":3.1363636363636362,"d":"3.14"},null,null,{"v":3.1363636363636362,"d":"3.136"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lattiapäällyste, epokshartsi",{"v":4.069,"d":"4.07"},null,null,4.069,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"LEVY",{"$nulls":3},"","","",""]
[null,"Levy, kipsilevy",{"v":0.41904956099999996,"d":"0.419"},null,null,{"v":0.41904956099999996,"d":"0.419"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Levy, kovalevy",{"v":0.31562670825,"d":"0.316"},null,null,{"v":0.31562670825,"d":"0.316"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Levy, kuitulevy, tuulensuoja",{"v":0.4571347512500001,"d":"0.457"},1.53,null,{"v":0.4571347512500001,"d":"0.457"},-1.53,"CO2e/kg","kg"]
[null,"Levy, lastulevy",{"v":0.6135719415,"d":"0.614"},1.06,null,{"v":0.6135719415,"d":"0.614"},-1.06,"CO2e/kg","kg"]
[null,"Levy, vaneri",{"v":0.28336097826086953,"d":"0.283"},1.64,null,{"v":0.28336097826086953,"d":"0.283"},-1.64,"CO2e/kg","kg"]
[null,"Levy, CLT",{"v":0.21,"d":"0.210"},1.55,null,{"v":0.21,"d":"0.210"},-1.55,"CO2e/kg","kg"]
[null,"Levy, kuitusementti",{"v":0.7066500000000001,"d":"0.707"},null,null,{"v":0.7066500000000001,"d":"0.707"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Levy, viilupuu",{"v":0.3950470588235295,"d":"0.395"},{"$f":"1020/680","v":{"v":1.5,"d":"1.50"}},null,{"v":0.3950470588235295,"d":"0.395"},{"v":-1.5,"d":"-1.50"},"CO2e/kg","kg"]
[null,"Levy, OSB",{"v":0.4431,"d":"0.443"},{"$f":"810/623.33","v":{"v":1.2994721896908539,"d":"1.30"}},null,{"v":0.4431,"d":"0.443"},{"v":-1.2994721896908539,"d":"-1.30"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"PINTAKÄSITTELY",{"$nulls":3},"","","",""]
[null,"Maali, sisä, akrylaatti",{"v":2.12625,"d":"2.126"},null,null,{"v":2.12625,"d":"2.126"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Maali, sisä, alkydi",{"v":1.86375,"d":"1.864"},null,null,{"v":1.86375,"d":"1.864"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Maali, punamulta",{"v":0.4454625,"d":"0.445"},null,null,{"v":0.4454625,"d":"0.445"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Maali, pellavaöljy",{"v":1.53825,"d":"1.538"},null,null,{"v":1.53825,"d":"1.538"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Maali, ulko, vesiohenteinen",{"v":1.84,"d":"1.840"},null,null,{"v":1.84,"d":"1.840"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Maali, sisä, vesiohenteinen",{"v":1.64,"d":"1.640"},null,null,{"v":1.64,"d":"1.640"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"TASOITE",{"$nulls":3},"","","",""]
[null,"Tasoite, sementtipohj.",{"v":0.1854857142857143,"d":"0.185"},null,null,{"v":0.1854857142857143,"d":"0.185"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Tasoite, polymeeripohj.",{"v":0.361132222,"d":"0.361"},null,null,{"v":0.361132222,"d":"0.361"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"MUURAUS",{"$nulls":3},"","","",""]
[null,"Muuraus, kahi 85+laasti",{"v":0.15053708139534885,"d":"0.151"},null,null,{"v":0.15053708139534885,"d":"0.151"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Muuraus, kahiharkko, 130+laasti",{"v":0.15429515209125474,"d":"0.154"},null,null,{"v":0.15429515209125474,"d":"0.154"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Muuraus, kevytsoraharkko+laasti",{"v":0.2981560729927007,"d":"0.298"},null,null,{"v":0.2981560729927007,"d":"0.298"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Muuraus, lämpöharkko+EPS+laasti",{"v":0.37843874789599996,"d":"0.378"},null,null,{"v":0.37843874789599996,"d":"0.378"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Muuraus, poltettu tiili 130+laasti",{"v":0.24089046835443037,"d":"0.241"},null,null,{"v":0.24089046835443037,"d":"0.241"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Muuraus, poltettu tiili 85+laasti",{"v":0.2038125430463576,"d":"0.204"},null,null,{"v":0.2038125430463576,"d":"0.204"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Muuraus, Siporex+ohutsaumauslaasti",{"v":0.28774520215,"d":"0.288"},null,null,{"v":0.28774520215,"d":"0.288"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"HIRSI",{"$nulls":3},"","","",""]
[null,"Hirsiseinä, 270 mm",{"v":0.11159259259259259,"d":"0.112"},1.55,{"v":10,"d":"10.0"},{"v":10,"d":"10.000"},-1.55,"CO2e/m2","m2"]
[null,"Liimahirsi",{"v":0.1421111111111111,"d":"0.142"},{"$f":"0.95*D132","v":1.4725},null,{"v":0.1421111111111111,"d":"0.142"},{"v":-1.4725,"d":"-1.47"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"ULKOVERHOILU",{"$nulls":3},"","","",""]
[null,"Verhoilu, alumiinikasetti",{"v":3.2,"d":"3.20"},null,null,{"$f":"IF(E136=\"\",IF(C136=\"\",\"\",C136),E136)","v":{"v":3.2,"d":"3.200"}},{"v":0,"d":"0.00"},{"$f":"IF(F136=\"\",\"\",(IF(E136=\"\",\"CO2e/kg\",\"CO2e/m2\")))","v":"CO2e/kg"},"kg"]
[null,"Verhoilu, keraaminen laatoitus",{"v":0.70354602,"d":"0.70"},null,null,{"v":0.70354602,"d":"0.704"},{"$f":"IF(F137=\"\",\"\",D137*-1)","v":{"v":0,"d":"0.00"}},"CO2e/kg",{"$f":"IF(F137=\"\",\"\",(IF(E137=\"\",\"kg\",\"m2\")))","v":"kg"}]
[null,"Verhoilu, kuparikasetti",{"v":2.104,"d":"2.10"},null,null,2.104,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Verhoilu, luonnonkivi, 20 mm",{"v":0.4076923076923077,"d":"0.41"},null,21.2,{"v":21.2,"d":"21.200"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Verhoilu, puu",{"v":0.09170939800000003,"d":"0.09"},1.55,null,{"v":0.09170939800000003,"d":"0.092"},-1.55,"CO2e/kg","kg"]
[null,"Verhoilu, puu, lämpökäs.",{"v":0.12210301576,"d":"0.12"},1.55,null,{"v":0.12210301576,"d":"0.122"},-1.55,"CO2e/kg","kg"]
[null,"Verhoilu, teräskasetti, ruostumaton",{"v":2.846025,"d":"2.85"},null,null,{"v":2.846025,"d":"2.846"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Verhoilu, teräskasetti+maali",2.95,null,null,{"v":2.95,"d":"2.950"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Verhoilu, tiililaatta",{"v":0.2295956,"d":"0.23"},null,null,{"v":0.2295956,"d":"0.230"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Verhoilu, turvalasi",{"v":1.338,"d":"1.34"},null,null,1.338,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Verhoilu, laminaatti",{"v":2.988235294117647,"d":"2.99"},null,null,{"v":2.988235294117647,"d":"2.988"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"RUNKO JA PILARIT JA PALKIT",{"$nulls":3},"","","",""]
[null,"Palkki, betoni+teräkset",{"v":0.195906,"d":"0.196"},null,null,{"v":0.195906,"d":"0.196"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Palkki, jännepalkki",{"v":0.265464,"d":"0.265"},null,null,{"v":0.265464,"d":"0.265"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Palkki tai pilari, kertopuu",{"v":0.28348235294117646,"d":"0.283"},null,null,{"v":0.28348235294117646,"d":"0.283"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Palkki tai pilari, liimapuu",{"v":0.35635950000000005,"d":"0.356"},1.62,null,{"v":0.35635950000000005,"d":"0.356"},-1.62,"CO2e/kg","kg"]
[null,"Palkki tai pilari, puu",0.092,1.55,null,0.092,-1.55,"CO2e/kg","kg"]
[null,"Palkki, teräsristikko, pintakäsitelty",{"v":2.72,"d":"2.720"},null,null,{"v":2.72,"d":"2.720"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Palkki, teräsputki, pintakäsitelty",{"v":2.84,"d":"2.840"},null,null,{"v":2.84,"d":"2.840"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Palkki, teräksinen deltapalkki",{"v":2.94,"d":"2.940"},null,null,{"v":2.94,"d":"2.940"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pilari, betoni+teräkset",{"v":0.214916,"d":"0.215"},null,null,{"v":0.214916,"d":"0.215"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Puuranka, sahatavara",0.092,1.55,null,0.092,-1.55,"CO2e/kg","kg"]
[null,"Pilari, teräsputki (kylmämuovaus), pintakäsitelty",{"v":2.84,"d":"2.840"},null,null,{"v":2.84,"d":"2.840"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pilari, teräspilari (kuumavalsatusta levystä), pintakäsitelty",{"v":2.72,"d":"2.720"},null,null,{"v":2.72,"d":"2.720"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Teräsranka, kuumasinkitty",2.788,null,null,2.788,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"PERUSTUS JA PORTAAT",{"$nulls":3},"","","",""]
[null,"Betoni, valmisbetoni, 35",{"v":0.1458347961,"d":"0.146"},null,null,{"v":0.1458347961,"d":"0.146"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoni, valmisbetoni, 80",{"v":0.20953199609999998,"d":"0.210"},null,null,{"v":0.20953199609999998,"d":"0.210"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Betoniteräs",0.474,null,null,0.474,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kevytsora",{"v":0.4593116,"d":"0.459"},null,null,{"v":0.4593116,"d":"0.459"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kevytsoraharkko+laasti",{"v":0.2981560729927007,"d":"0.298"},null,null,{"v":0.2981560729927007,"d":"0.298"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Kuitukangas",{"v":2.27194891,"d":"2.272"},null,null,{"v":2.27194891,"d":"2.272"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Murske, 2/32",{"v":5.872252980000001E-3,"d":"0.006"},null,null,{"v":5.872252980000001E-3,"d":"0.006"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Murske, hieno ja karkea",{"v":0.011520803000000001,"d":"0.012"},null,null,{"v":0.011520803000000001,"d":"0.012"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Noppakiveys",{"v":1.2692307692307692,"d":"1.269"},null,{"v":33,"d":"33.0"},{"v":33,"d":"33.000"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Paalut, betoni, 300x300",{"v":0.14527066117969825,"d":"0.145"},null,null,{"v":0.14527066117969825,"d":"0.145"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Paalut, betoni, 250x250",{"v":0.15770727252459016,"d":"0.158"},null,null,{"v":0.15770727252459016,"d":"0.158"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Paalut, teräsputki",{"v":2.84,"d":"2.840"},null,null,{"v":2.84,"d":"2.840"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pihalaatoitus, betoni",{"v":0.13718039999999998,"d":"0.137"},null,null,{"v":0.13718039999999998,"d":"0.137"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pilari, teräs",{"v":2.84,"d":"2.840"},null,null,{"v":2.84,"d":"2.840"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Portaat, betoni",{"v":0.24723248847926269,"d":"0.247"},null,null,{"v":0.24723248847926269,"d":"0.247"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Portaat, puu",{"v":0.08754078900000001,"d":"0.088"},1.55,null,{"v":0.08754078900000001,"d":"0.088"},-1.55,"CO2e/kg","kg"]
[null,"Portaat, teräs",{"v":2.84,"d":"2.840"},null,null,{"v":2.84,"d":"2.840"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Routaeriste, EPS",3.338,null,null,3.338,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Sora ja hiekka",{"v":0.004836304814,"d":"0.005"},null,null,{"v":0.004836304814,"d":"0.005"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Stabilointi, 30/70",0.779,null,null,0.779,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"IKKUNAT ja OVET ja LASISEINÄT",{"$nulls":3},"","","",""]
[null,"Ikkunat, 3 lasikerrosta, 4mm",null,null,{"v":20.475,"d":"20.5"},20.475,{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ikkunat, 4 lasikerrosta, 4mm",null,null,27.3,{"v":27.3,"d":"27.300"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ikkunat, 3 lasikerrosta, 6mm",null,null,{"v":30.7125,"d":"30.7"},{"v":30.7125,"d":"30.713"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ikkunat, 4 lasikerrosta, 6mm",null,null,{"v":40.95,"d":"41.0"},{"v":40.95,"d":"40.950"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ikkunat, Puuikkuna, sisältää myös lasit",null,null,{"$f":"158.75/(1.23*1.48)","v":{"v":87.20610854757196,"d":"87.2"}},{"v":87.20610854757196,"d":"87.206"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ikkunat, Puu-alumiini-ikkuna, sisältää myös lasit",null,null,{"$f":"207.73/(1.23*1.48)","v":{"v":114.11228301472204,"d":"114.1"}},{"v":114.11228301472204,"d":"114.112"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Lasiverhoilu ja seinät",null,null,{"v":9.915,"d":"9.9"},9.915,{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ovi, lasi",null,null,{"v":9.92,"d":"9.9"},{"v":9.92,"d":"9.920"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ovi, sisä",null,null,{"v":34.82349620684534,"d":"35"},{"v":34.82349620684534,"d":"34.823"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ovi, ulko metalli",null,null,{"v":20.09701304251679,"d":"20"},{"v":20.09701304251679,"d":"20.097"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[null,"Ovi, ulko, puu",null,null,{"v":61.04377815654607,"d":"61"},{"v":61.04377815654607,"d":"61.044"},{"v":0,"d":"0.00"},"CO2e/m2","m2"]
[{"$nulls":5},"","","",""]
[null,"LVI OSAT",{"$nulls":3},"","","",""]
[null,"Putki, muovi",{"v":2.1684,"d":"2.17"},null,null,{"$f":"IF(E199=\"\",IF(C199=\"\",\"\",C199),E199)","v":{"v":2.1684,"d":"2.168"}},{"v":0,"d":"0.00"},{"$f":"IF(F199=\"\",\"\",(IF(E199=\"\",\"CO2e/kg\",\"CO2e/m2\")))","v":"CO2e/kg"},"kg"]
[null,"Putki, teräs",{"v":2.538,"d":"2.54"},null,null,2.538,{"$f":"IF(F200=\"\",\"\",D200*-1)","v":{"v":0,"d":"0.00"}},"CO2e/kg",{"$f":"IF(F200=\"\",\"\",(IF(E200=\"\",\"kg\",\"m2\")))","v":"kg"}]
[null,"Putki, alumiini",{"v":2.338112,"d":"2.34"},null,null,{"v":2.338112,"d":"2.338"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, komposiitti",{"v":1.963028,"d":"1.96"},null,null,{"v":1.963028,"d":"1.963"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, salaoja",{"v":2.3894,"d":"2.39"},null,null,{"v":2.3894,"d":"2.389"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, viemäri",{"v":2.05299,"d":"2.05"},null,null,{"v":2.05299,"d":"2.053"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, maaviemäri",{"v":0.1968,"d":"0.20"},null,null,{"v":0.1968,"d":"0.197"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, käyttövesi",{"v":2.3894,"d":"2.39"},null,null,{"v":2.3894,"d":"2.389"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, lattialämmitys",{"v":1.838,"d":"1.84"},null,null,1.838,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Liitin, muovi",{"v":2.028,"d":"2.03"},null,null,2.028,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Liitin, teräs",{"v":2.75679,"d":"2.76"},null,null,{"v":2.75679,"d":"2.757"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Liitin, alumiini",{"v":2.338112,"d":"2.34"},null,null,{"v":2.338112,"d":"2.338"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Venttiili",{"v":2.8472575200000003,"d":"2.85"},null,null,{"v":2.8472575200000003,"d":"2.847"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Jakotukki",{"v":2.8472575200000003,"d":"2.85"},null,null,{"v":2.8472575200000003,"d":"2.847"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Sadevesikaivo",{"v":1.6345692307692308,"d":"1.63"},null,null,{"v":1.6345692307692308,"d":"1.635"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Peruskaivo",{"v":1.668,"d":"1.67"},null,null,1.668,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pesuallas, keraaminen",{"v":1.6480000000000001,"d":"1.65"},null,null,{"v":1.6480000000000001,"d":"1.648"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pesuallas, RST",{"v":4.758,"d":"4.76"},null,null,4.758,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"WC-istuin, keraaminen",{"v":1.6480000000000001,"d":"1.65"},null,null,{"v":1.6480000000000001,"d":"1.648"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lattiakaivo, muovi",{"v":1.668,"d":"1.67"},null,null,1.668,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lattiakaivo, RST teräs",{"v":4.758,"d":"4.76"},null,null,4.758,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Vesihana, komposiitti",{"v":2.8994,"d":"2.90"},null,null,{"v":2.8994,"d":"2.899"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Suihku ja letku komposiitti",{"v":3.6740000000000004,"d":"3.67"},null,null,{"v":3.6740000000000004,"d":"3.674"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Lautasventtiili, teräs",{"v":2.75679,"d":"2.76"},null,null,{"v":2.75679,"d":"2.757"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Putki, ilmastointi",2.75,null,null,{"v":2.75,"d":"2.750"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Säleikkö, tuloilma",{"v":2.338112,"d":"2.34"},null,null,{"v":2.338112,"d":"2.338"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Säleikkö, ulko",{"v":2.338112,"d":"2.34"},null,null,{"v":2.338112,"d":"2.338"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[{"$nulls":5},"","","",""]
[null,"SÄHKÖOSAT",{"$nulls":3},"","","",""]
[null,"Sisäkaapeli",{"v":2.1,"d":"2.10"},null,null,{"v":2.1,"d":"2.100"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Parikaapeli",3.81,null,null,{"v":3.81,"d":"3.810"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Antennikaapeli",2.05,null,null,{"v":2.05,"d":"2.050"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Asennusjohto",2.21,null,null,{"v":2.21,"d":"2.210"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Ohjauskaapeli",{"v":2.310100539130435,"d":"2.31"},null,null,{"v":2.310100539130435,"d":"2.310"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Voimakaapeli",2.21,null,null,{"v":2.21,"d":"2.210"},{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Pistorasia",{"v":2.028,"d":"2.03"},null,null,2.028,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Valaisinpistorasia",{"v":2.028,"d":"2.03"},null,null,2.028,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Jakorasia",{"v":2.028,"d":"2.03"},null,null,2.028,{"v":0,"d":"0.00"},"CO2e/kg","kg"]
[null,"Haaroitusrasia",{"v":2.028,"d":"2.03"},null,null,2.028,{"v":0,"d":"0.00"},"CO2e/kg","kg"]

{"sheet":"Ennen käyttöä (A)","index":4,"n_rows":26,"n_cols":4,"rows_kept":26,"merged":[[14,1,14,3],[18,1,18,3],[21,1,21,3],[25,1,25,3]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[null,"Ennen käyttöä syntyvien päästöjen yhteenveto"]
[]
[null,null,"Hiilijalanjälki","Hiilikädenjälki"]
[null,null,"kgCO2e","kgCO2e"]
[null,"Ennen käyttöä syntyvät päästöt yhteensä",{"$f":"C10+C21","v":0},{"$f":"D10+D21","v":0}]
[]
[null,"Valmistus ja kuljetusvaihe (A1-4)",{"$f":"IF(C17=\"\",SUM(C11:C14),C17)","v":0},{"$f":"IF(D17=\"\",SUM(D11:D14),D17)","v":0}]
[null,"Tontti",{"$f":"Tontti[[#Totals],[Column8]]","v":0},{"$f":"Tontti[[#Totals],[Column9]]","v":0}]
[null,"Kantavat rakenteet",{"$f":"Kantavat[[#Totals],[Column8]]+Vaippa[[#Totals],[Column8]]","v":0},{"$f":"Kantavat[[#Totals],[Column9]]+Vaippa[[#Totals],[Column9]]","v":0}]
[null,"Kevyet rakenteet",{"$f":"Kevyet[[#Totals],[Column8]]","v":0},{"$f":"Kevyet[[#Totals],[Column9]]","v":0}]
[null,"Talotekniikka",{"$f":"TATE[[#Totals],[Column8]]","v":0},{"$f":"TATE[[#Totals],[Column9]]","v":0}]
[null,"Valmistusvaiheen päästöjen tulokset muodostuvat automaattisesti välilehdellä \"Materiaalit\" annettujen arvojen perusteella."]
[]
[null,"Valmistus ja kuljetusvaihe (A1-4) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä. Tarkempia laskelmia käytettäessä älä syötä mitään lukuja ylempään taulukkoon tai Materiaalit - välilehdelle."]
[]
[null,"Työmaatoiminnot (A5)",{"$f":"IF(C24=\"\",Datalehti!C36*Tulokset!$D$11,C24)","v":0},{"$f":"IF(D24=\"\",Datalehti!D36*Tulokset!$D$11,D24)","v":0}]
[null,"Työmaatoimintojen arvot perustuvat neliömetrikohtaiseen taulukkoarvoon."]
[]
[null,"Työmaatoiminnot (A5) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä."]

{"sheet":"Materiaalit (A1-3)","index":5,"n_rows":51,"n_cols":11,"rows_kept":51,"merged":[[5,1,5,8],[49,1,49,2]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[]
[null,"Luettelo rakennuksessa käytetyistä materiaaleista"]
[null,"Syötä rakennuksen materiaalien paino alla olevaan listaan esim. määräluettelon pohjalta laskien. Hiilijalanjäljen ja -kädenjäljen päästöt muodostuvat automaattisesti, kun määrät on syötetty. Lisää tarvittaessa rivejä kunkin otsakkeen alle Lisää rivi -napilla.",{"$nulls":7},"kgCO2e","kgCO2e"]
[null,"Littera","Rakennusosa","Materiaalin tyyppi","Materiaali",null,"Määrä",null,null,"Hiilijalanjälki","Hiilikädenjälki"]
[]
[]
[null,"Tontti (1.1. Alueosat)"]
[{"$nulls":7},{"$f":"IF(E11=\"\",\"\",VLOOKUP(E11,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E11=\"\",\"\",G11*VLOOKUP(E11,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E11=\"\",\"\",G11*VLOOKUP(E11,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E12=\"\",\"\",VLOOKUP(E12,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E12=\"\",\"\",G12*VLOOKUP(E12,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E12=\"\",\"\",G12*VLOOKUP(E12,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E13=\"\",\"\",VLOOKUP(E13,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E13=\"\",\"\",G13*VLOOKUP(E13,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E13=\"\",\"\",G13*VLOOKUP(E13,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E14=\"\",\"\",VLOOKUP(E14,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E14=\"\",\"\",G14*VLOOKUP(E14,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E14=\"\",\"\",G14*VLOOKUP(E14,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E15=\"\",\"\",VLOOKUP(E15,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E15=\"\",\"\",G15*VLOOKUP(E15,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E15=\"\",\"\",G15*VLOOKUP(E15,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[null,"Total",{"$nulls":7},{"$f":"SUBTOTAL(109,Tontti[Column8])","v":0},{"$f":"SUBTOTAL(109,Tontti[Column9])","v":0}]
[]
[null,"Kantavat rakenteet (1.2.1-1.2.3 Talo-osat)"]
[{"$nulls":7},{"$f":"IF(E19=\"\",\"\",VLOOKUP(E19,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E19=\"\",\"\",G19*VLOOKUP(E19,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E19=\"\",\"\",G19*VLOOKUP(E19,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E20=\"\",\"\",VLOOKUP(E20,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E20=\"\",\"\",G20*VLOOKUP(E20,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E20=\"\",\"\",G20*VLOOKUP(E20,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E21=\"\",\"\",VLOOKUP(E21,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E21=\"\",\"\",G21*VLOOKUP(E21,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E21=\"\",\"\",G21*VLOOKUP(E21,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E22=\"\",\"\",VLOOKUP(E22,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E22=\"\",\"\",G22*VLOOKUP(E22,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E22=\"\",\"\",G22*VLOOKUP(E22,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E23=\"\",\"\",VLOOKUP(E23,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E23=\"\",\"\",G23*VLOOKUP(E23,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E23=\"\",\"\",G23*VLOOKUP(E23,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[null,"Total",{"$nulls":7},{"$f":"SUBTOTAL(109,Kantavat[Column8])","v":0},{"$f":"SUBTOTAL(109,Kantavat[Column9])","v":0}]
[]
[null,"Vaippa (1.2.4-1.2.6 Talo-osat)"]
[{"$nulls":7},{"$f":"IF(E27=\"\",\"\",VLOOKUP(E27,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E27=\"\",\"\",G27*VLOOKUP(E27,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E27=\"\",\"\",G27*VLOOKUP(E27,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E28=\"\",\"\",VLOOKUP(E28,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E28=\"\",\"\",G28*VLOOKUP(E28,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E28=\"\",\"\",G28*VLOOKUP(E28,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E29=\"\",\"\",VLOOKUP(E29,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E29=\"\",\"\",G29*VLOOKUP(E29,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E29=\"\",\"\",G29*VLOOKUP(E29,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E30=\"\",\"\",VLOOKUP(E30,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E30=\"\",\"\",G30*VLOOKUP(E30,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E30=\"\",\"\",G30*VLOOKUP(E30,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E31=\"\",\"\",VLOOKUP(E31,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E31=\"\",\"\",G31*VLOOKUP(E31,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E31=\"\",\"\",G31*VLOOKUP(E31,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[null,"Total",{"$nulls":7},{"$f":"SUBTOTAL(109,Vaippa[Column8])","v":0},{"$f":"SUBTOTAL(109,Vaippa[Column9])","v":0}]
[]
[null,"Kevyet rakenteet (1.3 Tila-osat)"]
[{"$nulls":7},{"$f":"IF(E35=\"\",\"\",VLOOKUP(E35,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E35=\"\",\"\",G35*VLOOKUP(E35,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E35=\"\",\"\",G35*VLOOKUP(E35,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E36=\"\",\"\",VLOOKUP(E36,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E36=\"\",\"\",G36*VLOOKUP(E36,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E36=\"\",\"\",G36*VLOOKUP(E36,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E37=\"\",\"\",VLOOKUP(E37,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E37=\"\",\"\",G37*VLOOKUP(E37,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E37=\"\",\"\",G37*VLOOKUP(E37,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E38=\"\",\"\",VLOOKUP(E38,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E38=\"\",\"\",G38*VLOOKUP(E38,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E38=\"\",\"\",G38*VLOOKUP(E38,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E39=\"\",\"\",VLOOKUP(E39,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E39=\"\",\"\",G39*VLOOKUP(E39,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E39=\"\",\"\",G39*VLOOKUP(E39,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[null,"Total",{"$nulls":7},{"$f":"SUBTOTAL(109,Kevyet[Column8])","v":0},{"$f":"SUBTOTAL(109,Kevyet[Column9])","v":0}]
[]
[null,"Talotekniikka (2.1-2.4 Tekniikkaosat)"]
[{"$nulls":7},{"$f":"IF(E43=\"\",\"\",VLOOKUP(E43,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E43=\"\",\"\",G43*VLOOKUP(E43,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E43=\"\",\"\",G43*VLOOKUP(E43,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E44=\"\",\"\",VLOOKUP(E44,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E44=\"\",\"\",G44*VLOOKUP(E44,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E44=\"\",\"\",G44*VLOOKUP(E44,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E45=\"\",\"\",VLOOKUP(E45,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E45=\"\",\"\",G45*VLOOKUP(E45,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E45=\"\",\"\",G45*VLOOKUP(E45,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E46=\"\",\"\",VLOOKUP(E46,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E46=\"\",\"\",G46*VLOOKUP(E46,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E46=\"\",\"\",G46*VLOOKUP(E46,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[{"$nulls":7},{"$f":"IF(E47=\"\",\"\",VLOOKUP(E47,Materiaalitiedot!B:I,8,FALSE))","v":""},null,{"$f":"IF(E47=\"\",\"\",G47*VLOOKUP(E47,Materiaalitiedot!B:H,5,FALSE))","v":""},{"$f":"IF(E47=\"\",\"\",G47*VLOOKUP(E47,Materiaalitiedot!B:H,6,FALSE))","v":""}]
[null,"Total",{"$nulls":7},{"$f":"SUBTOTAL(109,TATE[Column8])","v":0},{"$f":"SUBTOTAL(109,TATE[Column9])","v":0}]
[]
[null,"Kaikki materiaalit yhteensä",{"$nulls":7},{"$f":"TATE[[#Totals],[Column8]]+Kevyet[[#Totals],[Column8]]+Vaippa[[#Totals],[Column8]]+Kantavat[[#Totals],[Column8]]+Tontti[[#Totals],[Column8]]","v":0},{"$f":"TATE[[#Totals],[Column9]]+Kevyet[[#Totals],[Column9]]+Vaippa[[#Totals],[Column9]]+Kantavat[[#Totals],[Column9]]+Tontti[[#Totals],[Column9]]","v":0}]
[{"$nulls":9},"Hiilijalanjälki","Hiilikädenjälki"]

{"sheet":"Käyttö (B)","index":6,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[4,1,4,2],[15,1,15,4],[16,1,16,4],[19,1,19,4],[21,1,21,2],[22,1,22,4],[26,1,26,4]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[]
[null,"Käyttövaiheen päästöjen arviointi"]
[]
[{"$nulls":3},"Hiilijalanjälki","Hiilikädenjälki"]
[{"$nulls":3},"kgCO2e","kgCO2e"]
[null,"Ennen käyttöä syntyvät päästöt yhteensä",null,{"$f":"D11+D22","v":0},{"$f":"E11+E22","v":0}]
[]
[null,"Energiankäyttö (B6)","Energiankulutus (kWh/a)",{"$f":"IF(D18=\"\",SUM(D12:D15),D18)","v":0},{"$f":"IF(E18=\"\",SUM(E12:E15),E18)","v":0}]
[null,"Sähkö",null,{"$f":"IFERROR(C12*Datalehti!S14,\"\")","v":""},"-"]
[null,"Kaukolämpö",null,{"$f":"IFERROR(C13*Datalehti!S15,\"\")","v":""},"-"]
[null,"Fossiiliset polttoaineet",null,{"$f":"IFERROR(C14*Datalehti!S16,\"\")","v":""},"-"]
[null,"Uusiutuvat polttoaineet",null,{"$f":"IFERROR(C15*Datalehti!S17,\"\")","v":""},"-"]
[null,"Syötä yllä olevaan listaan rakennuksen laskennallinen vuotuinen ostoenergian kulutus energiaselvityksen tai vastaavan laskelman pohjalta. Enerigiankäytön päästöt muodostuvat automaattisesti eri energiamuotojen päästötietojen perusteella, kun kulutus on syötetty. Energiamuotojen päästökertoimia ei voi muuttaa. Energiamuodoilla ei tässä laskennassa voi olla hiilikädenjälkeä."]
[]
[null,"Energiankäyttö (B6) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä. Tarkempia laskelmia käytettäessä älä syötä mitään lukuja ylempään taulukkoon."]
[]
[null,"Korjaukset ja osien vaihdot (B3-4)",null,{"$f":"Datalehti!C37*Tulokset!$D$11","v":0},{"$f":"Datalehti!D37*Tulokset!$D$11","v":0}]
[null,"Korjausten ja vaihtojen päästövaikutukset perustuvat taulukkoarvoihin."]
[]
[null,"Korjaukset ja osien vaihdot (B3-4) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä."]

{"sheet":"Loppu ja lisätiedot (C+D)","index":7,"n_rows":33,"n_cols":5,"rows_kept":33,"merged":[[10,1,10,2],[11,1,11,4],[14,1,14,4],[16,1,16,2],[17,1,17,4],[20,1,20,4],[23,1,23,4],[26,1,26,4],[28,1,28,2],[29,1,29,4],[32,1,32,4]]}
[]
[null,{"$f":"Ohje!B2","v":"Rakennuksen hiilijalanjäljen arviointityökalun luonnos"}]
[null,{"$f":"Ohje!B3","v":"Luonnos lausuntokierrosta varten 16.11.2018"}]
[]
[null,"Elinkaaren lopun päästötiedot"]
[]
[{"$nulls":3},"Hiilijalanjälki","Hiilikädenjälki"]
[{"$nulls":3},"kgCO2e","kgCO2e"]
[null,"Elinkaaren lopussa syntyvät päästöt yhteensä",null,{"$f":"D23+D17+D11+D29","v":0},{"$f":"E23+E17+E11+E29","v":0}]
[]
[null,"Purkaminen (C1)",null,{"$f":"IF(D13=\"\",Datalehti!C38*Tulokset!$D$11,D13)","v":0},{"$f":"IF(E13=\"\",Datalehti!D38*Tulokset!$D$11,E13)","v":0}]
[null,"Päästötiedot pohjautuvat taulukkoarvoihin."]
[null,"Purkaminen (C1) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä."]
[]
[null,"Kuljetukset (C2)",null,{"$f":"IF(D19=\"\",Datalehti!C39*Tulokset!$D$11,D19)","v":0},{"$f":"IF(E19=\"\",Datalehti!D39*Tulokset!$D$11,E19)","v":0}]
[null,"Päästötiedot pohjautuvat taulukkoarvoihin."]
[null,"Kuljetukset (C2) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä."]
[]
[null,"Purkujätteen loppukäsittely ja sijoitus (C3-4)",null,{"$f":"IF(D25=\"\",Datalehti!C40*Tulokset!$D$11,D25)","v":0},{"$f":"IF(E25=\"\",Datalehti!D40*Tulokset!$D$11,E25)","v":0}]
[null,"Päästötiedot pohjautuvat taulukkoarvoihin."]
[null,"Purkujätteen loppukäsittely ja sijoitus (C3-4) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä."]
[]
[null,"Elinkaaren ulkopuolella syntyvät hyödyt (D)",null,{"$f":"IF(D31=\"\",Datalehti!C46*Tulokset!$D$11,D31)","v":0},{"$f":"IF(E31=\"\",Datalehti!D46*Tulokset!$D$11,E31)","v":0}]
[null,"Jos uudelleenkäytön tai kierrätyksen avulla vältetyt nettopäästöt on laskettu, syötä tiedot alle."]
[null,"Purkujätteen uusiokäyttö (D) tarkennettu laskenta"]
[]
[null,"Selitä tähän kenttään miten ja mistä tarkemmat arvot on saatu. Esitä tarvittaessa erilliset laskelmat liitteenä."]

{"sheet":"Datalehti","index":8,"n_rows":56,"n_cols":19,"rows_kept":56,"hidden":true}
[]
[]
[null,"Laskennalliset päästöt (kgCO2e /kWh)"]
[]
[null,"Energiamuoto",2010,2020,2030,2040,2050,2060,2070,2080,2090,2100,2110,2120,2130,2140,2150]
[null,"Sähkö",0.09,0.09,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,{"$f":"L6","v":0.06},{"$f":"M6","v":0.06},0.06,0.06,0.06]
[null,"Kaukolämpö",0.22,0.22,0.14,0.14,0.14,0.14,0.14,0.14,0.14,0.14,{"$f":"L7","v":0.14},0.14,0.14,0.14,0.14]
[null,"Fossiiliset ",0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26,0.26]
[null,"Uusiutuvat ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Laskennan vuodet",{"$f":"IF(C13>$E20,IF(C13<$E22,10,IF(C13<$E22+1,$E23,0)),(IF(C13>$E20-1,10-$E21,0)))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Energiamuoto",2010,2020,2030,2040,2050,2060,2070,2080,2090,2100,2110,2120,2130,2140,2150,null,"Päästökerroin"]
[null,"Sähkö",{"$f":"C$11*C6","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(C14:Q14)","v":{"$error":"#VALUE!"}}]
[null,"Kaukolämpö",{"$f":"C$11*C7","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(C15:Q15)","v":{"$error":"#VALUE!"}}]
[null,"Fossiiliset ",{"$f":"C$11*C8","v":{"$error":"#VALUE!"}},{"$f":"D$11*D8","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,"Uusiutuvat ",{"$f":"C$11*C9","v":{"$error":"#VALUE!"}},{"$f":"D$11*D9","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[]
[]
[{"$nulls":4},{"$f":"INT(LEFT(C21,3)&\"0\")","v":0}]
[null,"Valmistumisvuosi",{"$f":"Tulokset!D20","v":0},null,{"$f":"MOD(C21,10)","v":0}]
[null,"Käyttöikä",{"$f":"Tulokset!D17","v":""},null,{"$f":"INT(LEFT(C23,3)&\"0\")","v":{"$error":"#VALUE!"}}]
[null,"Loppuvuosi",{"$f":"C22+C21","v":{"$error":"#VALUE!"}},null,{"$f":"MOD(C23,10)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":8}
[{"$nulls":16},"Yksikkö","(Multiple Items)"]
[{"$nulls":6},"Hankeluokitus",{"$nulls":9},"materiaaliluokat lista"]
[null,null,"Hiilijalanjälki","Hiilikädenjälki",null,null,"A","Asuinrakennukset",{"$nulls":4},"raportointiaika",{"$nulls":3},"Row Labels"]
[null,null,"kg CO2e/kem2","kg CO2e/kem2",null,null,"B","Vapaa-ajan asuinrakennukset",{"$nulls":4},"Rakennuslupa",{"$nulls":3},"BETONI"]
[null,"Työmaatoiminnot (A5)",9.52,0,null,null,"C","Liikerakennukset",{"$nulls":4},"Käyttöönotto",{"$nulls":3},"ERISTE"]
[null,"Korjauset ja osien vaihdot (B3-4)",2.02,0,null,null,"D","Toimistorakennukset",{"$nulls":8},"HIRSI"]
[null,"Purkaminen (C1)",7.28,0,null,null,"E","Liikenteen rakennukset",{"$nulls":8},"IKKUNAT ja OVET ja LASISEINÄT"]
[null,"Kuljetukset (C2)",9.52,0,null,null,"F","Hoitoalan rakennukset",{"$nulls":4},"Tarkastelun tyyppi",{"$nulls":3},"KATE"]
[null,"Purkujätteen loppukäsittely ja sijoitus (C3-4)",14.56,0,null,null,"G","Kokoontumisrakennukset",{"$nulls":4},"Yksinkertaistettu",{"$nulls":3},"KOSTEUSERISTE"]
[null,"Purkujätteen uusiokäyttö (D?)",0,0,null,null,"H","Opetusrakennukset",{"$nulls":4},"Tarkennettu",{"$nulls":3},"LAATTA"]
[{"$nulls":6},"J","Teollisuusrakennukset",{"$nulls":8},"LEVY"]
[null,null,"Lauri: lisäsin nämä keskiarvoluvut. ",{"$nulls":3},"K","Varastorakennukset",{"$nulls":8},"LVI OSAT"]
[{"$nulls":6},"L","Palo- ja pelastustoimen rakennukset",{"$nulls":8},"METALLI"]
[{"$nulls":6},"M","Maatalousrakennukset",{"$nulls":8},"MUOVIT ja KUMIT"]
[{"$nulls":6},"N","Muut rakennukset",{"$nulls":8},"MUURAUS"]
[{"$nulls":16},"PERUSTUS JA PORTAAT"]
[{"$nulls":16},"PINTAKÄSITTELY"]
[{"$nulls":16},"PÄÄLLYSTE"]
[{"$nulls":16},"RUNKO JA PILARIT JA PALKIT"]
[{"$nulls":6},"Rakennuksen runkomateriaali",{"$nulls":9},"SÄHKÖOSAT"]
[{"$nulls":6},1,"Betoni",{"$nulls":8},"TASOITE"]
[{"$nulls":6},2,"Tiili",{"$nulls":8},"ULKOVERHOILU"]
[{"$nulls":6},3,"Teräs",{"$nulls":8},"(blank)"]
[{"$nulls":6},4,"Puu",{"$nulls":8},"Grand Total"]
[{"$nulls":6},5,"Muu"]