{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Resultat","Klimateffektivitet","Material & Processer","Maskintorn","Tipphall","Transporter","Entreprenadmaskiner","Referensobjekt, Sala ","Maskiner, kringutr., elkabel"],"not_rendered":{"charts":7,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":18,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Resultat","index":0,"n_rows":89,"n_cols":8,"rows_kept":89,"cut":false,"hidden":false,"merged":[[30,0,31,3]]}
[null,"Best Case scenario ","Worst Case scenario ","Boverket + trafikverket scenario ","Skillnad i worst - Best case scenario"]
["Påverkansfaktor ","CO2e [ton]","CO2e [ton]","CO2e [ton]","CO2e [ton]",null,"Material","CO2e"]
["Betong",{"$f":"'Material & Processer'!G7","v":1393.02},{"$f":"B39","v":1893},{"$f":"D40","v":1548},{"$f":"C3-B3","v":499.98},null,{"$f":"A3","v":"Betong"},{"$f":"B3","v":1393.02}]
["Silo, galvat stål",{"$f":"'Material & Processer'!G12+Transporter!B17","v":687.06207600000016},{"$f":"B40+Transporter!B18","v":1962.607130651558},{"$f":"D39+D44","v":2348.079130651558},{"$f":"C4-B4","v":1275.5450546515578},null,"Maskiner & elektronik",{"$f":"B28","v":706.842914559919}]
["Armering",{"$f":"'Material & Processer'!G17","v":311.64},{"$f":"B41","v":516.41999999999996},{"$f":"D41","v":539.22},204.77999999999997,null,{"$f":"A4","v":"Silo, galvat stål"},{"$f":"B4","v":687.06207600000016}]
["Asfalt",{"$f":"'Material & Processer'!M77","v":108.8507597259543},{"$f":"B43","v":195.9583943608344},{"$f":"D43","v":253.59687599999998},87.1076346348801,null,{"$f":"A5","v":"Armering"},{"$f":"B5","v":311.64}]
["Drivmedel",{"$f":"Entreprenadmaskiner!B40+Transporter!E31","v":49.048435628577245},{"$f":"B42+B46","v":316.84297080113311},{"$f":"D42+D46","v":316.84297080113311},267.79453517255587,null,"Konstruktionsstål",{"$f":"B10+B21","v":645.08868785764901}]
["Krossning ",{"$f":"'Material & Processer'!L41","v":7.5138204061688354},{"$f":"B45","v":50.110609910629655},{"$f":"D45","v":50.110609910629655},42.596789504460823,null,"Torkar & isoleringskassetter",{"$f":"B27","v":231.70240000000001}]
["Maskintorn: ",{"$nulls":5},"Asfalt",{"$f":"B6","v":108.8507597259543}]
["Konstruktionsstål",{"$f":"Maskintorn!G8","v":603.49251310564898},{"$f":"B49","v":619.95419945279991},{"$f":"D49","v":1057.2937239455998},{"$f":"C10-B10","v":16.46168634715093},null,{"$f":"A11","v":"Sandwich paneler"},{"$f":"B11","v":140.76686048000002}]
["Sandwich paneler",{"$f":"Maskintorn!G18+Maskintorn!G23","v":140.76686048000002},216.81659684800002,166.64292345008002,76.049736367999998,null,{"$f":"A12","v":"Durkplåt och durkgaller"},{"$f":"B12","v":121.47580925039998}]
["Durkplåt och durkgaller",{"$f":"Maskintorn!G37+Maskintorn!G38","v":121.47580925039998},121.47580925039998,137.7983391576,0,null,{"$f":"A19","v":"Stålplåt"},{"$f":"B19","v":55.26438019199999}]
["Trappor",{"$f":"Maskintorn!G48","v":31.794020099999997},31.794020099999997,38.717661749999998,0,null,"Övrigt ",{"$f":"B8+B13+B14+B15+B16+B17+B22+B23+B25+B24+B26+B7+B20","v":189.81690512815811}]
["Takplåt (TRP)",{"$f":"Maskintorn!G30","v":8.7918325050916479},8.7918325050916479,11.197784114052952,0]
["Isolering",{"$f":"Maskintorn!G29","v":6.3242240000000001},6.3242240000000001,5.4936576000000006,0]
["Ståldörrar",{"$f":"Maskintorn!G56","v":3.7112522264999996},3.924255,4.2383999999999995,0.21300277350000041]
["Räcken",{"$f":"Maskintorn!G60","v":1.5875661920000002},1.5875661920000002,3.2076615400000006,0]
["Tipphall:"]
["Stålplåt",{"$f":"Tipphall!G42","v":55.26438019199999},{"$f":"B59","v":152.58297599999997},{"$f":"D59","v":152.58297599999997},{"$f":"C19-B19","v":97.318595807999984}]
["Takplåt ",{"$f":"Tipphall!G32","v":56.409987437999987},56.409987437999987,{"$f":"D60","v":71.847008099999996},0]
["Konstruktionsstål (inkl.portomfattning)",{"$f":"Tipphall!G12+Tipphall!G25+Tipphall!G36","v":41.596174751999996},49.423737458275198,{"$f":"D61","v":57.08862143999999},7.8275627062752022]
["Lättbalkar",{"$f":"Tipphall!G18","v":7.2764705260799998},7.2764705260799998,{"$f":"D62","v":9.1718817119999994},0]
["Isolering",{"$f":"Tipphall!G29","v":6.8868576000000008},6.8868576000000008,{"$f":"D64","v":6.2563800599999997},0]
["Dukport",{"$f":"Tipphall!G3","v":6.4239242400000016},6.4239242400000016,{"$f":"D63","v":6.4239242400000016},0]
["Vikport",{"$f":"Tipphall!G5","v":2.1530187000000001},2.1530187000000001,{"$f":"D65","v":2.1530187000000001},0]
["Ståldörr",{"$f":"Tipphall!G8","v":1.8954955657403996},1.8954955657403996,{"$f":"D66","v":1.6953600000000002},0]
["Tork och isoleringskassetter",{"$f":"'Maskiner, kringutr., elkabel'!G196","v":231.70240000000001},{"$f":"'Maskiner, kringutr., elkabel'!G196","v":231.70240000000001},{"$f":"'Maskiner, kringutr., elkabel'!G196","v":231.70240000000001},0]
["Maskiner, elektronik",{"$f":"'Maskiner, kringutr., elkabel'!G179","v":706.842914559919},{"$f":"'Maskiner, kringutr., elkabel'!G179","v":706.842914559919},{"$f":"'Maskiner, kringutr., elkabel'!G179","v":706.842914559919},0]
["Summa",{"$f":"SUM(B3:B28)","v":4591.5307931940806},{"$f":"SUM(C3:C28)","v":7167.2053911604598},{"$f":"SUM(D3:D28)","v":7726.2042237325722},2575.6745979663792]
[]
["Topp 5 klimatpåverkan + drivmedel"]
[]
[]
[]
[]
[]
[]
["Påverkansfaktor ","CO2e [ton]","Påverkansfaktor ","CO2e [ton]"]
["Betong",{"$f":"'Material & Processer'!G5","v":1893},"Silo, galvat stål",{"$f":"'Material & Processer'!G9","v":2240}]
["Silo, galvat stål",{"$f":"'Material & Processer'!G13","v":1854.528},"Betong",{"$f":"('Material & Processer'!G3+'Material & Processer'!G4+'Material & Processer'!G5+'Material & Processer'!G6+'Material & Processer'!G7)/5","v":1548}]
["Armering",{"$f":"'Material & Processer'!G20","v":516.41999999999996},"Armering",{"$f":"'Material & Processer'!G15","v":539.22}]
["Entreprenadmaskiner",{"$f":"Entreprenadmaskiner!B41","v":280.80217759999999},"Entreprenadmaskiner",{"$f":"Entreprenadmaskiner!B41","v":280.80217759999999}]
["Asfalt",{"$f":"'Material & Processer'!L76","v":195.9583943608344},"Asfalt",{"$f":"'Material & Processer'!G72","v":253.59687599999998}]
["Transporter (långa) ",{"$f":"Transporter!B18","v":108.07913065155807},"Transporter (långa) ",{"$f":"Transporter!B18","v":108.07913065155807}]
["Krossning ",{"$f":"'Material & Processer'!H41","v":50.110609910629655},"Krossning ",{"$f":"'Material & Processer'!H41","v":50.110609910629655}]
["Lokaltransporter",{"$f":"Transporter!B31","v":36.040793201133141},"Lokaltransporter",{"$f":"Transporter!B31","v":36.040793201133141}]
[]
["Maskintorn: ",null,"Maskintorn: "]
["Konstruktionsstål",{"$f":"Maskintorn!G5","v":619.95419945279991},"Konstruktionsstål",{"$f":"Maskintorn!G12","v":1057.2937239455998}]
["Sandwich paneler",{"$f":"Maskintorn!G17+Maskintorn!G25","v":216.81659684800002},"Sandwich paneler",{"$f":"SUM(Maskintorn!G16:G19)/4+SUM(Maskintorn!G23:G25)/3","v":166.64292345008002}]
["Durkplåt och durkgaller",{"$f":"Maskintorn!G39","v":121.47580925039998},"Durkplåt och durkgaller",{"$f":"Maskintorn!G40","v":137.7983391576}]
["Trappor",{"$f":"Maskintorn!G48","v":31.794020099999997},"Trappor",{"$f":"Maskintorn!G49","v":38.717661749999998}]
["Takplåt (TRP)",{"$f":"Maskintorn!G30","v":8.7918325050916479},"Takplåt (TRP)",{"$f":"Maskintorn!G33","v":11.197784114052952}]
["Isolering",{"$f":"Maskintorn!G29","v":6.3242240000000001},"Isolering",{"$f":"Maskintorn!G32","v":5.4936576000000006}]
["Dörrar",{"$f":"Maskintorn!G57","v":3.924255},"Ståldörrar",{"$f":"Maskintorn!G55","v":4.2383999999999995}]
["Räcken",{"$f":"Maskintorn!G60","v":1.5875661920000002},"Räcken",{"$f":"Maskintorn!G61","v":3.2076615400000006}]
[]
["Tipphall:",null,"Tipphall:"]
["Stålplåt",{"$f":"Tipphall!G40","v":152.58297599999997},"Stålplåt",{"$f":"Tipphall!G40","v":152.58297599999997}]
["Takplåt (TRP)",{"$f":"Tipphall!G32","v":56.409987437999987},"Takplåt (TRP)",{"$f":"Tipphall!G31","v":71.847008099999996}]
["Konstruktionsstål (inkl.portomfattning)",{"$f":"Tipphall!G11+Tipphall!G25+Tipphall!G36","v":49.423737458275198},"Konstruktionsstål (inkl.portomfattning)",{"$f":"Tipphall!G23+Tipphall!G15+Tipphall!G37","v":57.08862143999999}]
["Lättbalkar",{"$f":"Tipphall!G18","v":7.2764705260799998},"Lättbalkar",{"$f":"Tipphall!G20","v":9.1718817119999994}]
["Isolering",{"$f":"Tipphall!G29","v":6.8868576000000008},"Dukport",{"$f":"Tipphall!G3","v":6.4239242400000016}]
["Dukport",{"$f":"Tipphall!G3","v":6.4239242400000016},"Isolering",{"$f":"Tipphall!G28","v":6.2563800599999997}]
["Vikport",{"$f":"Tipphall!G5","v":2.1530187000000001},"Vikport",{"$f":"Tipphall!G5","v":2.1530187000000001}]
["Ståldörr",{"$f":"Tipphall!G8","v":1.8954955657403996},"Ståldörr",{"$f":"Tipphall!G7","v":1.6953600000000002}]
[]
["Summa:",{"$f":"SUM(B39:B65)","v":6226.7645810348013},"Summa:",{"$f":"SUM(D39:D65)","v":6785.9635491726531}]
{"$rows_empty":8}
["Påverkansfaktor ","Ton CO2e","% total klimatpåverkan","Ton CO2e"]
["Betong",{"$f":"B3","v":1393.02},{"$f":"B78/B29*100","v":30.33890139787021},{"$f":"C3","v":1893},null,null,"Material","CO2e"]
[{"$f":"A28","v":"Maskiner, elektronik"},{"$f":"B28","v":706.842914559919},{"$f":"B79/B29*100","v":15.39449361001032},{"$f":"C28","v":706.842914559919},null,null,"Betong",{"$f":"C3","v":1893}]
[{"$f":"A4","v":"Silo, galvat stål"},{"$f":"B4","v":687.06207600000016},{"$f":"B80/B29*100","v":14.963682199810494},{"$f":"C4","v":1962.607130651558},null,null,"Silo, galvat stål",{"$f":"C4","v":1962.607130651558}]
[{"$f":"A10","v":"Konstruktionsstål"},{"$f":"B10+B21","v":645.08868785764901},{"$f":"B81/B29*100","v":14.049534173087741},{"$f":"C10+C21","v":669.37793691107515},null,null,"Maskiner & elektronik",{"$f":"C28","v":706.842914559919}]
[{"$f":"A5","v":"Armering"},{"$f":"B5","v":311.64},{"$f":"B82/B29*100","v":6.7872788844612941},{"$f":"C5","v":516.41999999999996},null,null,"Konstruktionsstål",{"$f":"C10+C21","v":669.37793691107515}]
["Drivmedel",{"$f":"66+'Material & Processer'!L41","v":73.513820406168833},null,{"$f":"425+'Material & Processer'!H41","v":475.11060991062965},null,null,"Armering",{"$f":"C5","v":516.41999999999996}]
[{"$nulls":6},"Drivmedel",{"$f":"C7","v":316.84297080113311}]
[{"$nulls":6},"Torkar & isoleringskassetter",{"$f":"C27","v":231.70240000000001}]
[{"$nulls":6},"Sandwich paneler",{"$f":"C11","v":216.81659684800002}]
[{"$nulls":6},"Asfalt",{"$f":"C6","v":195.9583943608344}]
[{"$nulls":6},"Stålplåt",{"$f":"C19","v":152.58297599999997}]
[{"$nulls":6},"Övrigt ",{"$f":"C8+C13+C14+C15+C16+C17+C22+C23+C24+C26+C20+C12","v":302.90105232794167}]

{"sheet":"Klimateffektivitet","index":1,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3],[5,0,5,12],[12,0,12,4]]}
["Betong"]
["Alternativ","Besparing CO2e ton","kostnad ","Kr / ton CO2e"]
["Skanska ",{"$f":"'Material & Processer'!G5-'Material & Processer'!G6","v":401.81999999999994},500000,{"$f":"C3/B3","v":1244.3382609128466}]
["Skanska (från optionsvar)",472,500000,{"$f":"C4/B4","v":1059.3220338983051}]
[]
["Asfalt"]
[null,null,"Entreprenörs erbjudande (ton CO2e)","Baslinje (ton CO2e)","Besparing CO2e ton","Baskostnad","Besparing minskad yta","Extra Kostnad","Kr / ton CO2e","volym [ton]","Skillnad [ton]","Extra kostnad per ton [kr/ton]","Besparing kronor"]
["Best Case","Hela ytan",0,{"$f":"'Material & Processer'!L78","v":253.59687599999998},{"$f":"D8-C8","v":253.59687599999998},4000000,0,900000,{"$f":"H8/E8","v":3548.9396170637374},{"$f":"'Material & Processer'!J55","v":4681.7884799999993},{"$f":"J8-J9","v":747.22499999999991},{"$f":"H8/J8","v":192.23422925761912},{"$f":"L8*K8","v":143642.22195702442}]
[null,"Delyta",0,{"$f":"'Material & Processer'!M78","v":205.62687599999998},{"$f":"D9-C9","v":205.62687599999998},4000000,{"$f":"F9-F9/J8*J9","v":638409.87536455318},900000,{"$f":"(H9-G9)/E9","v":1272.1592124730175},{"$f":"'Material & Processer'!J56","v":3934.5634799999993}]
["Worst Case"]
[null,"Hela ytan",0,{"$f":"('Material & Processer'!L75+'Material & Processer'!L76+'Material & Processer'!L77)/3","v":160.73815626929959},{"$f":"D11-C11","v":160.73815626929959},4000000,0,900000,{"$f":"H11/E11","v":5599.1683672926183}]
[null,"Delyta",0,{"$f":"('Material & Processer'!M75+'Material & Processer'!M76+'Material & Processer'!M77)/3","v":134.72813910831823},{"$f":"D12-C12","v":134.72813910831823},4000000,{"$f":"F12-F12/J8*J9","v":638409.87536455318},900000,{"$f":"(H12-G12)/E12","v":1941.6146201287213}]
["Sammanställning"]
["Process eller material","Kommentar","Kr / ton CO2e",null,"Totalkostnad"]
["Krossning, el","El",{"$f":"'Material & Processer'!G51","v":-7241.0421986809188},"Krossning, el",-149000]
["Betong","30 % klimatförbättrad",{"$f":"D4","v":1059.3220338983051},"Betong",500000]
["Limträ",null,1500,"Limträ",{"$f":"C17*(Resultat!C10+Resultat!C21-Maskintorn!G96-Tipphall!G53)","v":959800.32495027746}]
["Transporter och entreprenadmaskiner",null,2000,"Transporter och entreprenadmaskiner",{"$f":"C18*(Resultat!D83-Resultat!B83)","v":803193.57900892163}]
["Asfalt, hel yta","Hel yta, medelvärde av 3",{"$f":"I11","v":5599.1683672926183},"Asfalt, hel yta",{"$f":"I11*E11","v":900000}]
["Asfalt, delyta","Del yta, medelvärde av 3",{"$f":"I12","v":1941.6146201287213},"Asfalt, del yta",{"$f":"I12*E12","v":261590.12463544682}]

{"sheet":"Material & Processer","index":2,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":false,"merged":[[41,0,41,15],[52,0,52,11],[72,0,72,13],[1,1,1,13],[7,1,7,13],[22,1,22,13],[13,1,13,13]]}
["Tillverkare","Material","Enhet","Mängd [ton]","Källa, mängd","LCA CO2 (A1-A5)","Tot CO2 [ton]","A1 eller A1-A3","A2","A3","A4","A5 (byggspill/instal.)","Länk EPD/källa","EN15804 + A2"]
[null,"BETONG"]
["Swerock","Swerock Eco 3","Kg/m3",{"$f":"6000","v":6000},"Tornum möte",{"$f":"SUM(H3:L3)","v":228.83},{"$f":"F3*D3/1000","v":1372.98},214,7.18,1.1200000000000001,3.16,3.37,"https://www.epd-global.no/getfile.php/1331579-1680245714/EPDer/Byggevarer/Ferdig%20betong/NEPD-2637-1350_ECO-1--2--3-Sweexp55%281%29.pdf","NEJ"]
["Sydsten","C30/37 anläggning","Kg/m3",{"$f":"D3","v":6000},{"$f":"E3","v":"Tornum möte"},{"$f":"SUM(H4:L4)","v":264.97000000000003},{"$f":"F4*D4/1000","v":1589.8200000000002},{"$f":"256","v":256},null,null,5.6,3.37,"https://www.sydsten.se/media/1274/epd-betong-med-anlaggningscement-fa.pdf","NEJ"]
["Skanska","Anläggning, ej klimatförbättr","Kg/m3",6000,{"$f":"E3","v":"Tornum möte"},{"$f":"SUM(H5:K5)","v":315.5},{"$f":"D5*F5/1000","v":1893},311.60000000000002,null,null,{"$f":"3.9","v":3.9},3.37,"https://www.epd-norge.no/getfile.php/139359-1537173252/EPDer/Byggevarer/Betongvarer/NEPD-1328-427_Frostbest--mdig-betong-med-Anl--ggning-FA_1.pdf","NEJ"]
["Skanska","Anläggning, grön btg C32/40","Kg/m3",{"$f":"D3","v":6000},{"$f":"E3","v":"Tornum möte"},{"$f":"SUM(H6:K6)","v":248.53},{"$f":"D6*F6/1000","v":1491.18},{"$f":"247.21","v":247.21},null,null,1.32,3.37,"mail ","Ja"]
["Thomas betong","Anläggning C30/37","Kg/m3",{"$f":"D3","v":6000},{"$f":"E3","v":"Tornum möte"},{"$f":"SUM(H7:L7)","v":232.17000000000002},{"$f":"D7*F7/1000","v":1393.02},225,null,null,3.8,3.37,"mail ","NEJ"]
[null,"STÅL - galvaniserat"]
["Boverket","Galvade ståprodukter","kg/ton",640,"Tornum möte",{"$f":"SUM(H9:J9)+L9","v":3500},{"$f":"(F9*D9/1000)","v":2240},3330,null,null,null,170,"https://www.boverket.se/sv/klimatdeklaration/klimatdatabas/klimatdatabas/GetResourceByCategoryID/","NEJ"]
["Acciaieria Arvedi Spa","Acciaieria Arvedi",null,640,{"$f":"E9","v":"Tornum möte"},{"$f":"(SUM(H10:J10)+M110)","v":1124.5999999999999},{"$f":"(F10*D10+K10)/1000","v":719.74400000000003},{"$f":"1120+4.6","v":1124.5999999999999},null,null,null,{"$f":"0.0119","v":1.1900000000000001E-2},"https://api.environdec.com/api/v1/EPDLibrary/Files/7115321a-5f42-4b19-561f-08dbdfa90a02/Data","JA"]
["ArcelorMittal","Xcarb Mag.coat (310 g/m2 coat)",null,640,{"$f":"E10","v":"Tornum möte"},{"$f":"SUM(H11:L11)","v":1070},{"$f":"F11*D11/1000","v":684.8},900,null,null,null,170,"Andel av mängd (kg)"]
["ArcelorMittal","Xcarb zink (310 g/m2 zink)",null,640,{"$f":"E11","v":"Tornum möte"},{"$f":"SUM(H12:L12)","v":1046.9670000000001},{"$f":"F12*D12/1000","v":670.05888000000016},{"$f":"876+0.967","v":876.96699999999998},null,null,null,170,"Mängd (ton)"]
["Dongkuk",null,null,640,{"$f":"E12","v":"Tornum möte"},{"$f":"SUM(H13:L13)","v":2897.7},{"$f":"F13*D13/1000","v":1854.528},2510,15.7,202,"Oklar transport",170,"https://api.environdec.com/api/v1/EPDLibrary/Files/60b0f30b-9ee4-4757-98f4-08db7e35bd3c/Data","JA"]
[null,"STÅL - armering"]
["Boverket","Armering","Kg/ton",{"$f":"6000*0.1","v":600},"Antagande, 100kg /m2",{"$f":"SUM(H15:L15)","v":898.7},{"$f":"F15*D15/1000","v":539.22},745,null,null,79.5,74.2]
["BE Group","Armering","kg/ton",{"$f":"D15","v":600},"Antagande, 100kg /m4",{"$f":"SUM(H16:L16)","v":501.83},301.09800000000001,{"$f":"338+19","v":357},null,null,{"$f":"77.1-6.47","v":70.63},74.2,"https://api.environdec.com/api/v1/EPDLibrary/Files/409e111a-d6da-4faa-efd7-08d966bc9806/Data","JA"]
["Celsa ","Armering","Kg/ton",{"$f":"6000*0.1","v":600},"Antagande, 100kg /m3",519.4,311.64,{"$f":"373+25","v":398},null,null,{"$f":"33.4+13.8","v":47.2},74.2,"https://api.environdec.com/api/v1/EPDLibrary/Files/71eb954a-812e-4719-df44-08dbf085b35e/Data","JA"]
["Stena Stål AB","Armering","kg/ton",{"$f":"D16","v":600},"Antagande, 100kg /m5",579.60000000000014,347.76000000000005,{"$f":"4.73*10^2","v":473.00000000000006},null,null,{"$f":"3.24*10^1","v":32.400000000000006},74.2,"https://api.environdec.com/api/v1/EPDLibrary/Files/6f91c939-1374-45ff-0309-08d8f01e26c9/Data","NEJ"]
["Hellenic Halyvourgia S.A.","Armering","kg/ton",600,"Antagande, 100kg /m5",642.23556600000006,385.34133960000008,{"$f":"213.3+1.11*10^-2","v":213.31110000000001},{"$f":"3.558-4.534*10^-3","v":3.5534659999999998},{"$f":"222.854+48.817","v":271.67099999999999},79.5,74.2,null,"JA"]
["CMC","Armering","kg/ton",600,"Antagande, 100kg /m5",860.7,516.41999999999996,707,null,null,79.5,74.2,"https://www.cmc.com/getmedia/09b46ae1-76a7-4c18-8bcc-73fdd0a50132/EPD-Concrete-Reinforcing-Steel-2020-Final.pdf","NEJ"]
["Tata Group","Armering","kg/ton",600,"Antagande, 100kg /m5",2880.3489439999998,1728.2093663999999,{"$f":"(2.52*10^3)-(4.8*10^-1)","v":2519.52},{"$f":"(2.16*10^0)-(6.56*10^-4)","v":2.1593439999999999},{"$f":"(2.05*10^2)-(3.04*10^-2)","v":204.96959999999999},79.5,74.2,"https://api.environdec.com/api/v1/EPDLibrary/Files/7ee2c00f-0b06-4767-aba8-08da599e304a/Data","JA"]
["Jindal","Armering","kg/ton",{"$f":"D20","v":600},"Antagande, 100kg /m5",3596.7,2158.02,{"$f":"3480-29.4","v":3450.6},null,null,79.5,{"$f":"33.8+32.8","v":66.599999999999994},"https://api.environdec.com/api/v1/EPDLibrary/Files/aef1f604-9bdc-4f9c-13ff-08dbca69748b/Data","NEJ"]
[null,"Krossverk"]
[null,"Krossteg","Mängd (ton)","Andel","Källa"]
[null,1,223172,1,"Rapport, NCC bergtäkt"]
[null,2,186437,{"$f":"C26/C25","v":0.83539601742154035}]
[null,3,112443,{"$f":"C27/C25","v":0.50384008746616959}]
[]
[null,"Typ av arbete",null,"Mängd (m3)","Vikt (ton)"]
["Företag","Transport av maksiner till plats","kg CO2e","m3","Ton","Källa","kg CO2/ton material","Utsläpp ton co2","Liter diesel","HVO  ton co2 ","kWh el","C02e HVO + el [ton]","kWh/ton","kWh tot","diesel liter","Källa"]
["NCC (rapport)","Borrning","kg CO2e",{"$f":"17300/2","v":8650},{"$f":"3*D31","v":25950},"Tornum",{"$f":"9055/223172","v":4.0574086354919076E-2},{"$f":"G31*E31/1000","v":1.05289754091015},{"$f":"H31/$L$46*1000","v":446.90048425727929},{"$f":"I31*$L$47/1000","v":0.15954347287984871},null,{"$f":"J31","v":0.15954347287984871},null,null,null,"Rapport, NCC bergtäkt"]
["NCC (rapport)","Sprängmedel","kg CO2e",{"$f":"17300/2","v":8650},{"$f":"3*D32","v":25950},"Tornum",{"$f":"10364/223172","v":4.6439517502195618E-2},1.2051054791819764,null,{"$f":"H32","v":1.2051054791819764},null,{"$f":"J32","v":1.2051054791819764}]
["NCC (rapport)","Skutknack","kg CO2e",{"$f":"17300/2","v":8650},{"$f":"3*D33","v":25950},"Tornum",{"$f":"11430/223172","v":5.1216102378434568E-2},1.329057856720377,{"$f":"H33/$L$46*1000","v":564.11623799676443},{"$f":"I33*$L$47/1000","v":0.20138949696484487},null,0.20138949696484487]
["NCC (rapport)","Krossteg 1","kg CO2e",{"$f":"17300/2","v":8650},{"$f":"3*D34","v":25950},"Tornum",{"$f":"56398/223172","v":0.25271091355546393},6.5578482067642891,2783.4669807997834,0.9936977121455226,{"$f":"I34*$M$46*0.35/0.85","v":11238.475342412197},{"$f":"K34*L48/1000","v":0.29220035890271712},0.98,{"$f":"E34*M34","v":25431},{"$f":"N34/9.81","v":2592.3547400611619}]
["NCC (rapport)","Krossteg 2","kg CO2e",{"$f":"17300/2*D26","v":7226.1755506963236},{"$f":"D35*3","v":21678.526652088971},"Tornum",{"$f":"87025/223172","v":0.38994587134586778},8.4534519648434507,3588.0526166568129,1.2809347841464822,{"$f":"I35*$M$46*0.35/0.85","v":14487.055581305529},{"$f":"K35*L48/1000","v":0.37666344511394373},1.8,{"$f":"M35*E35","v":39021.347973760152},{"$f":"N35/9.81","v":3977.711312309903}]
["NCC (rapport)","Krossteg 3","kg CO2e",{"$f":"D34*D27","v":4358.2167565823665},{"$f":"D36*3","v":13074.650269747101},"Tornum",{"$f":"111885/223172","v":0.50133977380674999},6.5548422088373748,2782.1910903384442,0.99324221925082457,{"$f":"I36*$M$46*0.35/0.85","v":11233.323830435123},{"$f":"K36*L48/1000","v":0.29206641959131319},4.5599999999999996,{"$f":"M36*E36","v":59620.405230046774},{"$f":"N36/9.81","v":6077.5132752341251}]
["NCC (rapport)","Transport krossteg 1","kg CO2e",{"$f":"D31","v":8650},{"$f":"D37*3","v":25950},"Tornum",{"$f":"145545/223172","v":0.65216514616528953},16.923685542989265,7183.2281591635256,2.5644124528213785,null,{"$f":"J37","v":2.5644124528213785},null,{"$f":"SUM(N34:N36)","v":124072.75320380693}]
["NCC (rapport)","Transport krossteg 2","kg CO2e",{"$f":"D31*D26","v":7226.1755506963236},{"$f":"D38*3","v":21678.526652088971},"Tornum",{"$f":"53851/223172","v":0.24129819152940332},5.230989276171039,2220.2840730776911,0.79264141408873567,null,{"$f":"J38","v":0.79264141408873567}]
["NCC (rapport)","Transport krossteg 3","kg CO2e",{"$f":"D31*D27","v":4358.2167565823665},{"$f":"D39*3","v":13074.650269747101},"Tornum",{"$f":"47840/223172","v":0.21436380907999211},2.8027318342117344,1189.6145306501419,0.42469238744210064,null,0.42469238744210064]
[]
[{"$nulls":5},"Summa:",{"$f":"SUM(G31:G39)","v":2.3900534117183159},{"$f":"SUM(H31:H39)","v":50.110609910629655},{"$f":"SUM(I31:I39)","v":20757.854172940442},{"$f":"I41*$L$47/1000+H32","v":8.6156594189217142},null,{"$f":"SUM(L31:L39)+H32","v":7.5138204061688354}]
["Fördelning över krossteg,  kostnad för diesel och CO2e besparing för krossmaskin"]
[]
[null,"Liter","Pris","Total pris","Skillnad","CO2e besparing","kr/ton CO2e besparing",null,null,null,"CO2e utsläpp - olika energikällor"]
["HVO",{"$f":"I41/N47","v":21551.536832494046},{"$f":"21.84","v":21.84},{"$f":"C45*B45","v":470685.56442166999},{"$f":"D45-D46","v":82721.269929413102},{"$f":"H41-J41","v":41.494950491707939},{"$f":"E45/(H41-J41)","v":1993.5261748521316},{"$nulls":4},"Utsläpp","Energiinnehåll kWh/l","Relativt energiinnehåll till diesel"]
["Diesel",{"$f":"I41","v":20757.854172940442},18.690000000000001,{"$f":"C46*B46","v":387964.29449225689},{"$f":"-E45","v":-82721.269929413102},{"$f":"J41-H41","v":-41.494950491707939},{"$nulls":4},"Diesel MK1 kg CO2e/liter",2.3559999999999999,{"$f":"35.3/3.6","v":9.8055555555555554}]
[{"$nulls":10},"HVO100 kg CO2e/liter",0.35699999999999998,{"$f":"34/3.6","v":9.4444444444444446},{"$f":"M47/M46","v":0.96317280453257792}]
["Energikälla","Liter eller  kWh","kr/l, kr/kWh","Total kostnad","Extra kostnad","Sparad CO2e ton","Kr / CO2e",null,null,null,"El (mix) kg/kWh",{"$f":"26/1000","v":2.5999999999999999E-2}]
["Diesel",{"$f":"B46","v":20757.854172940442},{"$f":"C46","v":18.690000000000001},{"$f":"D46","v":387964.29449225689},{"$nulls":6},"Diesel MK1 kg CO2e/kWh",{"$f":"1/M46*L46","v":0.24027195467422094}]
["HVO",{"$f":"B45","v":21551.536832494046},{"$f":"C45","v":21.84},{"$f":"D45","v":470685.56442166999},{"$f":"D50-D49","v":82721.269929413102},{"$f":"H41-J41","v":41.494950491707939},{"$f":"E50/F50","v":1993.5261748521316},null,null,null,"HVO100 kg CO2e/kWh",{"$f":"L47*1/M47","v":3.78E-2}]
["El",{"$f":"SUM(K34:K36)","v":36958.854754152853},0.59199999999999997,{"$f":"C51*B51","v":21879.642014458488},{"$f":"D51-SUM(I34:I36)*C49","v":-149203.2107404308},{"$f":"SUM(H34:H36)-SUM(L34:L36)","v":20.60521215683714},{"$f":"E51/F51","v":-7241.0421986809188}]
["HVO + el",{"$f":"(SUM(I31:I33)+SUM(I37:I39))/N47*M46+SUM(K34:K36)","v":155094.53412837535},null,{"$f":"SUM(I31:I33+I37:I39)*C50/N47+B51*C51","v":285004.2781368061},{"$f":"D52-D49","v":-102960.01635545079},{"$f":"H41-SUM(L34:L36)-SUM(J31:J33)-SUM(J37:J39)","v":43.801894983642796},{"$f":"E52/F52","v":-2350.5836081726547}]
["Asfalt"]
["Case","Yta [m2]","Bundet bärlager [m] ","Bindlager [m]","Slitlager [m]","Antagen densitet [ton/m3]","Mängd AG [ton]","Mängd ABB [ton]","Mängd ABS [ton]","Total mängd [ton]","Lastbil [ton]"]
["Hela ytan",{"$f":"25700-62.6*76.4-92.3*(142.8-92.3)","v":16256.21},{"$f":"40/1000","v":0.04},{"$f":"40/1000","v":0.04},0.04,2.4,{"$f":"C55*B55*F55","v":1560.5961599999998},{"$f":"D55*B55*F55","v":1560.5961599999998},{"$f":"E55*B55*F55","v":1560.5961599999998},{"$f":"SUM(G55:I55)","v":4681.7884799999993},30]
["Mindre delar av ytan ",{"$f":"B55-70^2/2-50*25/2","v":13181.21},{"$f":"40/1000","v":0.04},{"$f":"40/1000","v":0.04},0.04,2.4,{"$f":"C56*B56*F56","v":1265.3961599999998},{"$f":"D56*B56*F56","v":1265.3961599999998},{"$f":"E56*B56*F56+B75","v":1403.7711599999998},{"$f":"SUM(G56:I56)","v":3934.5634799999993}]
["Utsläpp asfalt",null,null,"Hela ytan","Mindre delar","Hela ytan","Mindre delar","Hela ytan","Mindre delar"]
["Fabrikat","Typ","A1-A3 [kg/ton]","A4 [ton]","A4 [ton]","A5 [ton]","A5 [ton]","Total [ton]","Total [ton]","B1 [ton]","B2 [ton]","Länk"]
["NCC","AG - 16",20,{"$f":"$J$55/$K$55*Transporter!B7*12*2/1000","v":3.059734716933511},{"$f":"$J$56/$K$55*Transporter!B7*12*2/1000","v":2.5713935021119809},{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C59*G55/1000+F59+D59","v":47.439188016933507},{"$f":"C59*G56/1000+G59+D59","v":39.044438016933512},null,null,"NCC"]
["NCC","ABB - 16",{"$f":"20","v":20},{"$f":"$J$55/$K$55*Transporter!B7*12*2/1000","v":3.059734716933511},{"$f":"$J$56/$K$55*Transporter!B7*12*2/1000","v":2.5713935021119809},{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C60*H55/1000+F60+D60","v":47.439188016933507},{"$f":"C60*H56/1000+G60+D60","v":39.044438016933512},null,null,"NCC"]
["NCC","ABS - 16",{"$f":"28","v":28},{"$f":"$J$55/$K$55*Transporter!B7*12*2/1000","v":3.059734716933511},{"$f":"$J$56/$K$55*Transporter!B7*12*2/1000","v":2.5713935021119809},{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C61*I55/1000+F61+D61","v":59.923957296933509},{"$f":"C61*I56/1000+G61+D61","v":53.042107296933509},null,null,"NCC"]
["Summa",{"$nulls":6},{"$f":"SUM(H59:H61)","v":154.80233333080054},{"$f":"SUM(I59:I61)","v":131.13098333080052},{"$f":"H62-I62","v":23.671350000000018},{"$f":"N75","v":23.671350000000018}]
["Peab ","AG - 16",26.2,{"$f":"$J$55/$K$55*Transporter!B7*50/1000","v":6.3744473269448134},{"$f":"$J$56/$K$55*Transporter!B7*50/1000","v":5.3570697960666278},{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C63*G55/1000+F63+D63","v":60.429596818944802},{"$f":"C63*G56/1000+G63+E63","v":49.187229288066625},null,null,"PEAB"]
["Peab ","ABB - 22",27.5,{"$f":"$J$55/$K$55*Transporter!B7*50/1000","v":6.3744473269448134},{"$f":"$J$56/$K$55*Transporter!B7*50/1000","v":5.3570697960666278},{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C64*H55/1000+F64+D64","v":62.458371826944806},{"$f":"C64*H56/1000+G64+E64","v":50.832244296066627},null,null,"PEAB"]
["Peab ","ABS - 11",34.299999999999997,{"$f":"$J$55/$K$55*Transporter!B7*50/1000","v":6.3744473269448134},{"$f":"$J$56/$K$55*Transporter!B7*50/1000","v":5.3570697960666278},{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C65*I55/1000+F65+D65","v":73.070425714944804},{"$f":"C65*I56/1000+G65+E65","v":64.18320068406662},null,null,"PEAB"]
["Summa",{"$nulls":6},{"$f":"SUM(H63:H65)","v":195.9583943608344},{"$f":"SUM(I63:I65)","v":164.20267426819987},{"$f":"H66-I66","v":31.755720092634533},{"$f":"N76","v":31.755720092634533}]
["Skanska","AG - 16",16.899999999999999,{"$f":"D63","v":6.3744473269448134},5.3570697960666278,{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C67*G55/1000+F67+D67","v":45.916052530944803},{"$f":"C67*$G$56/1000+G67+E67","v":37.419045000066617},null,null,"Skanska"]
["Skanska","ABB - 100",17.5,6.3744473269448134,5.3570697960666278,{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C68*$H$55/1000+F68+D68","v":46.852410226944805},{"$f":"C68*H56/1000+G68+E68","v":38.178282696066617},null,null,"Skanska"]
["Skanska","ABS ",{"$f":"15.6+0.58+0.102-4.02+0.000439+0.00422","v":12.266659000000001},6.3744473269448134,5.3570697960666278,{"$f":"0.81*$B$55/1000","v":13.1675301},{"$f":"0.81*$B$56/1000","v":10.6767801},{"$f":"C69*$I$55/1000+F69+D69","v":38.685278358374255},{"$f":"C69*I56/1000+G69+E69","v":33.253432029821063},null,null,"Skanska"]
["Summa",{"$nulls":6},{"$f":"SUM(H67:H69)","v":131.45374111626387},{"$f":"SUM(I67:I69)","v":108.8507597259543},{"$f":"H70-I70","v":22.602981390309566},{"$f":"N77","v":22.602981390309566}]
["Fabrikat","Typ","A1-A3 [kg/m2]","A4 [kg/m2]","A5 [kg/m2]","A1-A5 [kg/m2]","Hela ytan total [ton]","Mindre delar [ton]"]
["Trafikverket","Asfalt 120mm",13.19,1.6,0.81,{"$f":"SUM(C72:E72)","v":15.6},{"$f":"F72*B55/1000","v":253.59687599999998},{"$f":"B56*F72/1000","v":205.62687599999998}]
["Tunnare asfalt"]
["Yta m2","m3","Mängd [ton]","Fabrikat","Typ","A1-A3 (kg/ton)","A4 [ton]","A5 (utläggning/spill)","Ton CO2e (hela ytan)","Ton CO2e (mindre)","Fabrikör","Tot CO2e hel yta [ton]","Tot CO2e del yta [ton]","Besparning [ton]"]
[{"$f":"B55-B56","v":3075},{"$f":"(B55-B56)*0.045","v":138.375},{"$f":"B75*F55","v":332.09999999999997},"NCC","ABS - 16",26,{"$f":"$C$75/$K$55*Transporter!B7*12*2/1000","v":0.21704053992067981},{"$f":"0.81*A75/1000","v":2.4907499999999998},{"$f":"H75+G75+F75*$C$75/1000","v":11.342390539920679},null,"NCC",{"$f":"H62","v":154.80233333080054},{"$f":"I62","v":131.13098333080052},{"$f":"L75-M75","v":23.671350000000018}]
[null,null,null,"PEAB","ABS - 16",{"$f":"C65","v":34.299999999999997},{"$f":"$C$75/$K$55*Transporter!B7*50/1000","v":0.45216779150141628},{"$f":"0.81*A75/1000","v":2.4907499999999998},{"$f":"H76+G76+F76*$C$75/1000","v":14.333947791501412},null,"PEAB",{"$f":"H66","v":195.9583943608344},{"$f":"I66","v":164.20267426819987},{"$f":"L76-M76","v":31.755720092634533}]
[null,null,null,"Skanska","ABS - 17",{"$f":"C69","v":12.266659000000001},{"$f":"$C$75/$K$55*Transporter!B7*50/1000","v":0.45216779150141628},{"$f":"0.81*A75/1000","v":2.4907499999999998},{"$f":"H77+G77+F77*$C$75/1000","v":7.0166752454014159},null,"SKANSKA",{"$f":"H70","v":131.45374111626387},{"$f":"I70","v":108.8507597259543},{"$f":"L77-M77","v":22.602981390309566}]
[{"$nulls":10},"Trafikverket",{"$f":"G72","v":253.59687599999998},{"$f":"H72","v":205.62687599999998},{"$f":"L78-M78","v":47.97}]

{"sheet":"Maskintorn","index":3,"n_rows":97,"n_cols":27,"rows_kept":97,"cut":false,"hidden":false,"merged":[[11,0,11,5],[81,0,81,4],[73,1,73,3],[76,1,76,3],[13,0,13,15],[34,0,34,15],[42,0,42,15],[51,0,51,15],[57,0,57,15],[62,0,63,15],[22,16,23,21],[15,16,16,21],[82,0,82,4],[83,0,83,4],[71,0,71,15],[0,0,0,15],[34,16,35,20],[42,16,43,20],[46,16,47,20],[52,16,52,20],[4,0,4,5],[7,0,7,5],[38,0,38,5],[30,0,30,5],[33,0,33,5],[47,0,47,5],[20,0,20,15],[26,0,26,15],[0,17,1,20],[4,17,5,20],[28,17,29,20]]}
["Stålpelare och stålbalkar",{"$nulls":16},"Mängdning pelare"]
["Tillverkare","Material","Funkti. enhet","Mängd [ton]","Källa, mängd","A1-A5","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)",null,null,"A2 "]
["Tibnor","VKR","kg CO2e/ton",{"$f":"V4+S8*T8*U8*V8/1000","v":226.87732799999998},"Ritningar",{"$f":"H3+K3","v":2.6526000000000001},{"$f":"D3*F3","v":601.81480025279996},2.6,null,null,{"$f":"0.0526","v":5.2600000000000001E-2},null,{"$f":"0.00000682","v":6.8199999999999999E-6},null,"tibnor VKR","Nej",null,"Antal","Längd","Profil VKR","kg/m","vikt ton","Källa"]
["Tibnor","H/I profil","kg CO2e/ton",{"$f":"(Y8*Z8+W8*X8)/1000","v":15.249600000000001},"Ritningar",{"$f":"H4+K4","v":1.1895},{"$f":"D4*F4","v":18.1393992},1.1499999999999999,null,null,{"$f":"0.0395","v":3.95E-2},null,{"$f":"0.00000682","v":6.8199999999999999E-6},null,"tibnor H/I","Nej",null,24,38.561999999999998,"350x350",131,{"$f":"R4*S4*U4/1000","v":121.23892799999999},"https://www.tibnor.se/medias/konstruktionstabellerSWE-2023.pdf?context=bWFzdGVyfHJvb3R8MzE0ODU1NnxhcHBsaWNhdGlvbi9wZGZ8aDFhL2gwZi85MTEwNDM1ODIzNjQ2L2tvbnN0cnVrdGlvbnN0YWJlbGxlclNXRS0yMDIzLnBkZnxkZjllN2E2MzBjOGIyOTBhNDkyYTQ5ZGIwY2NiYTllMzAxNjdiN2VmZWZhZGY3MTFiZmRjMDBkMTdlYmY1NDQx"]
["Summa",{"$nulls":5},{"$f":"G3+G4","v":619.95419945279991},{"$nulls":10},"Mängdning Balkar"]
["Stena stål","VKR","kg CO2e/ton",{"$f":"D3","v":226.87732799999998},"Ritningar",{"$f":"H6+K7+M6","v":2.6125068200000001},{"$f":"D6*F6","v":592.71856670337695},2.58,null,null,{"$f":"0.0325","v":3.2500000000000001E-2},null,{"$f":"M4","v":6.8199999999999999E-6},null,"Stena VKR","Nej"]
["Stena stål","H/I profil","kg CO2e/ton",{"$f":"D4","v":15.249600000000001},"Ritningar",{"$f":"H7+K7+M7","v":0.70650681999999998},{"$f":"D7*F7","v":10.773946402272001},0.67400000000000004,null,null,{"$f":"0.0325","v":3.2500000000000001E-2},null,{"$f":"M4","v":6.8199999999999999E-6},null,"Stena Stål",null,null,"Profil VKR","Antal per våning","Längd","kg/m","Våningar","kg/m (HEA360)","Längd total","kg/m IPE360)","Längd total","Vikt ton"]
["Summa",{"$nulls":5},{"$f":"G6+G7","v":603.49251310564898},{"$nulls":10},"350x350",8,{"$f":"15.1-0.7","v":14.4},131,7,{"$f":"112","v":112},{"$f":"16*8","v":128},57.1,16,{"$f":"(S8*T8*U8*V8+W8*X8+Y8*Z8)/1000","v":120.88800000000002}]
["Stena stål","Återbrukat","kg CO2e/ton",{"$f":"D10","v":242.12692800000002},"Ritningar",{"$f":"H9+K9+M9","v":6.9206820000000002E-2},{"$f":"D9*F9","v":16.756834723248961},{"$f":"0.0532","v":5.3199999999999997E-2},null,null,1.6E-2,null,{"$f":"M7","v":6.8199999999999999E-6},null,"Stena, återbrukat","Nej"]
["Boverket","stål (100% skrot)","kg CO2e/ton",{"$f":"$V$4+$AA$8","v":242.12692800000002},"Ritningar",{"$f":"SUM(H10:M10)","v":1.2696999999999998},{"$f":"F10*D10","v":307.42856048159996},1.1299999999999999,null,null,7.9500000000000001E-2,null,6.0199999999999997E-2,null,"Boverket"]
["Boverket","stål (80% skrot)","kg CO2e/ton",{"$f":"$V$4+$AA$8","v":242.12692800000002},"Ritningar",{"$f":"SUM(H11:M11)","v":3.3904999999999998},{"$f":"F11*D11","v":820.93134938399999},3.15,null,null,7.9500000000000001E-2,null,0.161,null,"Boverket"]
["Viktat värde (KKR och HEA, boverket)",{"$nulls":5},{"$f":"D6*F11+D6*F10","v":1057.2937239455998}]
[]
["Sandwich paneler 200mm"]
["Tillverkare","Material","Funkti. enhet","Mängd [m2]","Källa, mängd","A1-A5","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)"]
["Planja (Ruuki)","Mineralull","kg CO2e/m2",{"$f":"T19+U19","v":2452.576},"Ritningar",{"$f":"SUM(H16:M16)","v":45.561},{"$f":"F16*D16/1000","v":111.741815136},38.6,null,null,0.32100000000000001,null,6.64,null,"Plannja (Ruuki)",null,"Mängdning utvändiga sandwichpaneler "]
["Bewi","Mineralull","kg CO2e/m2",{"$f":"T19+U19","v":2452.576},"Ritningar",{"$f":"SUM(H17:M17)","v":74.710499999999996},{"$f":"F17*D17/1000","v":183.233179248},{"$f":"65.5+1.53","v":67.03},null,null,{"$f":"1.04+0.0005","v":1.0405},null,6.64,null,"Bewi, mineralull"]
["Ruuki","Mineralull","kg CO2e/m2",{"$f":"T19+U19","v":2452.576},"Ritningar",{"$f":"SUM(H18:M18)","v":45.13},{"$f":"F18*D18/1000","v":110.68475488000001},36.6,null,null,1.89,null,6.64,null,"Ruuki",null,null,"Höjd [m]","Bredd [m]","Area [m2]","extra vid tak (m2)"]
["Lindab","Mineralull","kg CO2e/m2",{"$f":"T19+U19","v":2452.576},"Ritningar",{"$f":"SUM(H19:M19)","v":55.367319999999999},{"$f":"F19*D19/1000","v":135.79256021632},{"$f":"52.2-2.82","v":49.38},null,null,{"$f":"5.78+0.00232","v":5.7823200000000003},null,{"$f":"0.205","v":0.20499999999999999},null,"Lindab",null,null,37.6,16,{"$f":"S19*R19*4","v":2406.4},{"$f":"(38.562-37.6)*16*2+(38.562-37.6)*16","v":46.175999999999817}]
["Boverket ","-","-","-","-","-","-"]
["Sandwich paneler 150mm"]
["Tillverkare","Material","Funkti. enhet","Mängd [m2]","Källa, mängd","A1-A5","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)"]
["Ruuki","Mineralull","kg CO2e/m2",{"$f":"$U$27","v":729.44},"Ritningar",{"$f":"SUM(H23:M23)","v":41.239999999999995},{"$f":"F23*D23/1000","v":30.082105599999998},33.9,null,null,1.55,null,5.79,null,"Ruuki",null,"Mängdning sandwichpaneler hiss och trappa"]
["Planja (Ruuki)","Mineralull","kg CO2e/m2",{"$f":"$U$27","v":729.44},"Ritningar",{"$f":"SUM(H24:M24)","v":41.366},{"$f":"F24*D24/1000","v":30.17401504},35.299999999999997,null,null,0.27600000000000002,null,5.79,null,"Plannja (Ruuki)"]
["Lindab","Mineralull","kg CO2e/m2",{"$f":"$U$27","v":729.44},"Ritningar",46.04,{"$f":"F25*D25/1000","v":33.583417600000004},{"$f":"37.9-1.82+(H19-37.9-1.82)/2","v":40.909999999999997},null,null,{"$f":"3.79","v":3.79},null,1.34,null,"Lindab",null,null,"Höjd [m]","Bredd [m]","Area [m2]"]
["Boverket ","-","-","-","-","-","-",{"$nulls":9},"trappa",{"$f":"R19","v":37.6},12,{"$f":"S26*R26","v":451.20000000000005}]
["Tak (TRP plåt och isolering)",{"$nulls":15},"hiss",37.6,{"$f":"3.7*2","v":7.4},{"$f":"S27*R27","v":278.24},{"$f":"T27+T26","v":729.44}]
["Tillverkare","Material","Funkti. enhet","Mängd [ton]","Källa, mängd","A1-A5","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)"]
["Knauf","Mineralull","kg CO2e/kg",{"$f":"0.2*T32*90/1000","v":4.6079999999999997},"Tornum",{"$f":"SUM(H29:M29)/9","v":1.3724444444444446},{"$f":"F29*D29","v":6.3242240000000001},{"$f":"9.26","v":9.26},null,null,0.67200000000000004,null,2.42,null,"KnaufMineralull",null,null," Mängdning Tak"]
["Lindab","TRP plåt (galvad)","kg CO2e/kg",{"$f":"(120/9.82)*T32/1000","v":3.1283095723014256},"Tornum",{"$f":"SUM(H30:M30)","v":2.8104099999999996},{"$f":"F30*D30","v":8.7918325050916479},2.76,null,null,4.8800000000000003E-2,null,1.6100000000000001E-3]
["Summa",{"$nulls":5},{"$f":"G29+G30","v":15.116056505091649},{"$nulls":10},"Längd","Bredd","Area [m2]"]
["Boverket","Mineralull","kg CO2e/kg",{"$f":"D29","v":4.6079999999999997},"Tornum",{"$f":"SUM(H32:M32)","v":1.1922000000000001},{"$f":"F32*D32","v":5.4936576000000006},1.08,null,null,3.4500000000000003E-2,null,7.7700000000000005E-2,null,"Lindab",null,null,16,16,{"$f":"S32*R32","v":256}]
["Boverket","Galvad stålpr","kg CO2e/kg",{"$f":"D30","v":3.1283095723014256},"Tornum",{"$f":"SUM(H33:M33)","v":3.5794999999999999},{"$f":"F33*D33","v":11.197784114052952},3.33,null,null,7.9500000000000001E-2,null,0.17]
["Summa",{"$nulls":5},{"$f":"G32+G33","v":16.691441714052953}]
["Bjälklag (durkplåt och galler)",{"$nulls":15},"Mängdning gallerdurk/plåt"]
["Tillverkare","Material","Funkti. enhet","Mängd [ton]","Källa, mängd","A1-A5","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)"]
["Weland","Gallerdurk","kg CO2e/kg",{"$f":"18*T39/1000","v":21.672360000000001},"Ritningar",{"$f":"SUM(H37:M37)","v":3.1554999999999995},{"$f":"F37*D37","v":68.387131979999992},{"$f":"2.63+0.276","v":2.9059999999999997},null,null,7.9500000000000001E-2,null,0.17,null,"Weland"]
["BE group/weland","Tårplåt","kg CO2e/kg",{"$f":"T40*S42/1000","v":16.824172799999999},"Ritningar",{"$f":"SUM(H38:N38)","v":3.1554999999999995},{"$f":"F38*D38","v":53.088677270399991},{"$f":"2.63+0.276","v":2.9059999999999997},null,null,7.9500000000000001E-2,null,0.17,null,"BeGroup vikt",null,null,"Längd","Bredd","Area [m2]",null,"Weland vikter"]
["Summa",{"$nulls":5},{"$f":"G37+G38","v":121.47580925039998},{"$nulls":9},"Gallerdurk",15.2,15.2,{"$f":"(S39*R39-2.5*8.3-2.6*3.7)*6","v":1204.02},null,"Weland vikter"]
["Boverket","Galvaniserade produkter","kg CO2e/kg",{"$f":"18*T39/1000+D38","v":38.496532799999997},"Ritningar",{"$f":"SUM(H40:N40)","v":3.5794999999999999},{"$f":"F40*D40","v":137.7983391576},3.33,null,null,7.9500000000000001E-2,null,0.17,null,null,null,"Tårplåt",15.2,15.2,{"$f":"(S40*R40-2.5*8.3-2.6*3.7)*2","v":401.34}]
[{"$nulls":18},"kg/m2"]
[{"$nulls":17},"Tårplåt",{"$f":"131/(2.5*1.25)","v":41.92}]
["Trappor",{"$nulls":15},"Mängdning spiraltrappor"]
[]
["Tillverkare","Material","Funkti. enhet","Mängd [ton]","Källa, mängd","A1-A5 ","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)",{"$nulls":4},"Höjd","Vikt per höjdmeter (ton)"]
["Weland","Spiraltrappa, galvad","kg CO2e/kg",{"$f":"R46*S46","v":6.1124999999999998},"Ritningar",{"$f":"SUM(H46:M46)","v":2.9394},{"$f":"D46*F46","v":17.9670825},{"$f":"2.66+0.0299","v":2.6899000000000002},null,null,7.9500000000000001E-2,null,0.17,null,"Weland",null,null,{"$f":"33.45+7.3","v":40.75},0.15,null,"Weland vikter"]
["Weland","Raktrappa","kg CO2e/kg",{"$f":"U51","v":4.7039999999999997},"Ritningar",{"$f":"SUM(H47:M47)","v":2.9394},{"$f":"D47*F47","v":13.826937599999999},{"$f":"2.66+0.0299","v":2.6899000000000002},null,null,7.9500000000000001E-2,null,0.17,null,"Weland",null,"Mängdning raktrappor"]
["Summa",{"$nulls":5},{"$f":"G46+G47","v":31.794020099999997}]
["Boverket","Galvaniserade produkter","kg CO2e/kg",{"$f":"D47+D46","v":10.8165},"Ritningar",{"$f":"SUM(H49:M49)","v":3.5794999999999999},{"$f":"D49*F49","v":38.717661749999998},3.33,null,null,7.9500000000000001E-2,null,0.17]
[{"$nulls":17},"Höjd","Antal trappor","Vikt per höjdmeter","Vikt"]
[{"$nulls":17},2.8,4,{"$f":"0.42","v":0.42},{"$f":"T51*S51*R51","v":4.7039999999999997}]
["Dörrar",{"$nulls":20},"Weland vikter"]
[{"$nulls":16},"Mängdning ståldörrar"]
["Tillverkare","Material","Funkti. enhet","Mängd [ton,m2,st]","Källa, mängd","A1-A5 ","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)"]
["Boverket","Ståldörr","kg CO2e/kg",{"$f":"U56","v":1.2},"Förfrågningsunderlag",{"$f":"SUM(H55:L55)","v":3.532},{"$f":"F55*D55","v":4.2383999999999995},3.49,null,null,4.2000000000000003E-2,null,6.0169999999999995,null,"https://klimatdatabasen.boverket.se/detaljer/3/6000000115","JA",null,"Antal dörrar","Storlek (m2)","Antagen vikt (kg)","Sammanlagd vikt (ton)"]
["Sakumetall","Ståldörr","kgCO2e/kg",{"$f":"V57","v":31.5},"Förfrågningsunderlag",{"$f":"SUM(H56:M56)","v":117.81753099999999},{"$f":"F56*D56/1000","v":3.7112522264999996},109.77,null,null,2.0305309999999999,null,6.0169999999999995,null,"https://api.environdec.com/api/v1/EPDLibrary/Files/3c5a05e2-11f9-488d-1c18-08da2ccce1bd/Data","NEJ",null,15,{"$f":"2.1","v":2.1},80,{"$f":"T56*R56/1000","v":1.2},"summa storlek"]
["Daloc","Ståldörr","kg CO2e/st",{"$f":"R56","v":15},"Förfrågningsunderlag",{"$f":"SUM(H57:M57)","v":261.61700000000002},{"$f":"F57*D57/1000","v":3.924255},253,null,null,2.6,null,6.0169999999999995,null,"Daloc",{"$nulls":6},{"$f":"S56*R56","v":31.5}]
["Räcken"]
["Tillverkare","Material","Funkti. enhet","Mängd [ton]","Källa, mängd","A1-A5","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)",{"$nulls":4},"Mängdning räcke"]
["Weland","sektionsräcke","kg CO2e/kg",{"$f":"U63","v":0.89612000000000014},"Ritningar",{"$f":"SUM(H60:N60)","v":1.7715999999999998},{"$f":"F60*D60","v":1.5875661920000002},{"$f":"1.49+0.0321","v":1.5221},null,null,7.9500000000000001E-2,null,0.17,null,"Weland"]
["Boverket","Galvaniserade produkter","kg CO2e/kg",{"$f":"D60","v":0.89612000000000014},"Ritningar",{"$f":"SUM(H61:N61)","v":3.5794999999999999},{"$f":"F61*D61","v":3.2076615400000006},3.33,null,null,7.9500000000000001E-2,null,0.17,{"$nulls":4},"Antal meter ","våningar","vikt kg/m","ton"]
[{"$nulls":17},{"$f":"2.6*2+3.7*2","v":12.600000000000001},7,8.6]
["Summering",{"$nulls":16},16,1,8.6,{"$f":"(R62*S62*T62+R63*S63*T63)/1000","v":0.89612000000000014}]
[]
[null,null,"Tot CO2 [ton]"]
["Produktspecifik minimal",null,{"$f":"G8+G16+G24+G29+G30+G37+G38+G46+G47+G56+G60","v":919.09304755564062}]
["Produktspecifik maximal",null,{"$f":"G5+G17+G25+G29+G30+G37+G38+G46+G47+G55+G56+G60","v":1014.6939005747913}]
["Boverket + produktspecifk",null,{"$f":"G10+G16+G24+G33+G32+G40+G49+G55+G61","v":649.99789481925302}]
[]
[]
[]
["Limträ"]
[]
[null,"Pelare ",{"$nulls":4},"Smide"]
[null,"Längd","Tvärsnitt","Volym m3",null,"Andel av mängd (kg)",null,{"$f":"20000/(1156265+154132)","v":1.5262550204251078E-2}]
[null,{"$f":"S4*R4","v":925.48799999999994},{"$f":"0.5*0.5","v":0.25},{"$f":"C76*B76","v":231.37199999999999},null,"Mängd (ton)",null,{"$f":"H75*D93","v":2.0030617286211738}]
[null,"Balkar"]
[null,"Längd","Tvärsnitt","Volym m3"]
[null,{"$f":"T8*S8*V8+X8","v":934.4},{"$f":"0.15*0.35","v":5.2499999999999998E-2},{"$f":"C79*B79","v":49.055999999999997}]
[]
[]
["Summering",{"$nulls":4},"Exkl. biogent","Inkl. biogent"]
["Utsläpp, träkonstruktion",{"$nulls":4},{"$f":"K76+K79","v":0},{"$f":"L79+L76","v":0}]
["Besparing trä vs stål, [ton CO2e]",{"$nulls":4},{"$f":"G8-F83","v":603.49251310564898},{"$f":"G8-G83","v":603.49251310564898}]
[]
["Tillverkare","Material","Funkti. enhet","Mängd [m3,ton]","Källa, mängd","A1-A5 ","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)"]
["Stora enso (exkl.biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"D79+D76","v":280.428},"Fiktiv",{"$f":"SUM(H87:M87)","v":60.57},{"$f":"F87*D87/1000","v":16.985523959999998},{"$f":"52.6","v":52.6},null,null,{"$f":"2.59","v":2.59},null,5.38,"Stora Enso KL trä"]
["Stora enso (inkl.biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"D79+D76","v":280.428},"Fiktiv",{"$f":"SUM(H88:M88)","v":-701.41870000000006},{"$f":"F88*D88/1000","v":-196.69744320360002},{"$f":"H87-762","v":-709.4},null,null,{"$f":"K87+0.0103","v":2.6002999999999998},null,{"$f":"M87+0.001","v":5.3810000000000002},"Stora Enso KL trä"]
["Moelven (inkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"D79+D76","v":280.428},"Fiktiv",58.04,16.276041119999999,{"$f":"52.4","v":52.4},null,null,{"$f":"2.82","v":2.82},null,{"$f":"2.82","v":2.82},"Moelven Limträ"]
["Moelven (exkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"D79+D76","v":280.428},"Fiktiv",-685.30800000000011,-192.17955182400001,{"$f":"H89-744","v":-691.6},null,null,{"$f":"K89+0.326","v":3.1459999999999999},null,{"$f":"M89+0.326","v":3.1459999999999999},"Moelven Limträ"]
["Setra (exkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"D79+D76","v":280.428},"Fiktiv",56.65,15.8862462,{"$f":"44","v":44},null,null,{"$f":"4.3","v":4.3},null,{"$f":"M93","v":8.35},"Setra Limträ"]
["Setra (inkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"D79+D76","v":280.428},"Fiktiv",-695.65,-195.07973819999998,{"$f":"-704","v":-704},null,null,0,null,{"$f":"M91","v":8.35},"Setra Limträ"]
["Boverket","Limträ","kg CO2e/kg",{"$f":"D92*0.468","v":131.24030400000001},"Fiktiv",{"$f":"SUM(H93:M93)","v":175.85},{"$f":"F93*D93/1000","v":23.0786074584},133,null,null,34.5,null,8.35,"Boverket limträ"]
["Boverket","Konstruktionsstål","kg CO2e/kg",{"$f":"H76","v":2.0030617286211738},"Fiktiv",{"$f":"SUM(H94:M94)","v":3.3904999999999998},{"$f":"F94*D94","v":6.7913807908900896},3.15,null,null,7.9500000000000001E-2,null,0.161,"Boverket"]
[]
[{"$nulls":6},{"$f":"G87+G94","v":23.77690475089009}]
[{"$nulls":6},{"$f":"600-24","v":576}]

{"sheet":"Tipphall","index":4,"n_rows":59,"n_cols":19,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,14,1,16],[1,0,1,13],[5,0,5,13],[3,0,3,13],[8,0,8,13],[56,14,56,16],[20,0,20,13],[15,0,15,13],[48,0,48,13],[49,14,49,16],[52,14,52,16],[42,0,42,13],[37,0,37,13],[32,0,32,13],[29,0,29,13],[25,0,25,13]]}
["Tillverkare","Material","Funkti. enhet","Mängd [m2]","Källa, mängd","LCA CO2 (A1-A5)","Tot CO2 [ton]","A1-A3","A4",null,"A5 (byggspill/instal.)","Källa","A2 ","Kommentar"]
["Vikport",{"$nulls":13},"Mått "]
["AJAB SMIDE AB","Vikport","kg/m2",{"$f":"(4*4.5*2)*2","v":72},null,{"$f":"H3+I3+K3","v":89.221170000000015},{"$f":"(F3*D3)/1000","v":6.4239242400000016},{"$f":"(7.85*10^1)-(1.24*10^0)","v":77.260000000000005},{"$f":"1.37+(1.17*10^-3)","v":1.37117},null,{"$f":"9.31+1.28","v":10.59},"AJAB","JA","Denna är 4,5x4 meter. Ska vara 7x14m","L",17.7,"m"]
["Dukport/Takskjutport",{"$nulls":13},"B",31.5,"m"]
["Assa Abloy","Rolling door","kg CO2e/st",{"$f":"31.5*2","v":63},null,{"$f":"H5+I5+K5","v":34.174900000000001},{"$f":"(D5*F5)/1000","v":2.1530187000000001},{"$f":"32.43-4.75","v":27.68},{"$f":"1.09-(1.51*10^-2)","v":1.0749000000000002},null,{"$f":"0.78+4.64","v":5.42},"Teckentrup","JA","7x4,5= 31,5 m2","H",14.2,"m"]
["Ståldörr",{"$nulls":13},"A-tak",{"$f":"P4*P3","v":557.54999999999995},"m2"]
["Boverket","Ståldörr","kg CO2e/kg",{"$f":"80*6","v":480},null,{"$f":"SUM(H7:I7)","v":3.532},{"$f":"D7*F7/1000","v":1.6953600000000002},3.49,4.2000000000000003E-2,null,0,"Boverket","JA","Mängden är i KG och antas vara 80 kg pga: https://www.lathamssteeldoors.co.uk/steel-security-doors/","A-fasad",{"$f":"P5*P4*2+P5*P3*2","v":1397.2799999999997},"m2"]
["Sakumetall","Ståldörr","kgCO2e/kg",{"$f":"(2.18*1.23)*6","v":16.0884},null,{"$f":"SUM(H8+I8+K8)","v":117.81753099999997},{"$f":"D8*F8/1000","v":1.8954955657403996},{"$f":"1.16*10^2-6.23*10^0","v":109.76999999999998},{"$f":"2.03+5.31*10^-4","v":2.0305309999999999},null,{"$f":"1.37*10^-1+5.88*10^0","v":6.0169999999999995},"Saku Metall","NEJ",null,"L-takbalk",{"$f":"17.7*4+31.5*3","v":165.3},"m"]
["Takbalkar HEA-profil",{"$nulls":13},"L-pelare",{"$f":"14.2*23","v":326.59999999999997},"m"]
[null,null,null,"Kg  [m*kg/m]"]
["Tibnor","HEA-350","kg CO2e/kg",{"$f":"P8*112","v":18513.600000000002},"Mängdning från ritning",{"$f":"H11+I11+K11","v":1.189500682},{"$f":"D11*F11/1000","v":22.021939826275204},{"$f":"1.15*10^0","v":1.1499999999999999},{"$f":"3.95*10^-2","v":3.95E-2},null,{"$f":"6.82*10^-7","v":6.8199999999999999E-7},"Tibnor","NEJ","Val av HEA","Tibnor"]
["Stena stål","Stålprodukter","kg CO2e/kg",{"$f":"(P8*112)","v":18513.600000000002},"Mängdning från ritning",{"$f":"H12+I12+K12","v":0.76670000000000005},{"$f":"D12*F12/1000","v":14.194377120000002},{"$f":"6.74*10^2/1000","v":0.67400000000000004},{"$f":"3.25*10^1/1000","v":3.2500000000000001E-2},null,6.0199999999999997E-2,"Stena Stål","NEJ","Val av HEA","Tibnor"]
["BE-group","Stålprodukter","kg CO2e/kg",{"$f":"P8*112","v":18513.600000000002},"Mängdning från ritning",{"$f":"H13+I13+K13","v":0.8428000000000001},{"$f":"D13*F13/1000","v":15.603262080000004},{"$f":"(7.19*10^-1)","v":0.71900000000000008},{"$f":"(6.36*10^-2)","v":6.3600000000000004E-2},null,6.0199999999999997E-2,"BE-group","JA","Val av HEA","Tibnor"]
["Stena stål","Återbrukat","kg CO2e/ton",{"$f":"P8*112","v":18513.600000000002},"Mängdning från ritning",{"$f":"SUM(H14:K14)","v":6.9206820000000002E-2},{"$f":"F14*D14/1000","v":1.2812673827520003},{"$f":"0.0532","v":5.3199999999999997E-2},1.6E-2,null,{"$f":"0.00000682","v":6.8199999999999999E-6},"Stena, återbrukat","Nej"]
["Boverket","stål (100% skrot)","kg CO2e/kg",{"$f":"D13","v":18513.600000000002},"Mängdning från ritning",{"$f":"H15+I15+K15","v":1.2696999999999998},{"$f":"D15*F15/1000","v":23.50671792},1.1299999999999999,7.9500000000000001E-2,null,6.0199999999999997E-2,"Boverket","Nej","Val av HEA","Tibnor",null,"Stena stål","Återbrukat","kg CO2e/ton"]
["Lättbalk Z-profil"]
[null,null,null,"Omkrets*kg"]
["Lindab","Z-prfil 120","kg CO2e/kg",{"$f":"(P3*2+P4*2)*2.17*12","v":2562.3359999999998},null,{"$f":"H18+I18+K18","v":2.8397800000000002},{"$f":"D18*F18/1000","v":7.2764705260799998},{"$f":"2.79*10^0","v":2.79},{"$f":"4.88*10^-2","v":4.8800000000000003E-2},null,{"$f":"9.8*10^-4","v":9.8000000000000019E-4},"Lindab","NEJ","Vikten är: 2,17 kg/m. Cc 1200","Ruukki"]
["Boverket","Skrotbaserad 100%","kg CO2e/kg",{"$f":"(P4*2+P3*2)*2.17*12","v":2562.3359999999998},null,{"$f":"H19+I19+K19","v":1.2696999999999998},{"$f":"D19*F19/1000","v":3.2533980191999996},1.1299999999999999,7.9500000000000001E-2,null,6.0199999999999997E-2,"Boverket","NEJ"]
["Boverket","Galvaniserade produkter","kg CO2e/kg",{"$f":"(P4*2+P3*2)*2.17*12","v":2562.3359999999998},null,{"$f":"H20+I20+K20","v":3.5794999999999999},{"$f":"D20*F20/1000","v":9.1718817119999994},3.33,7.9500000000000001E-2,null,0.17,"Boverket","NEJ"]
["Fasadpelare och mittpelare KKR-profil"]
[null,null,null,"Kg  [m*kg/m]"]
["Boverket","stål (80% skrot)","kg CO2e/kg",{"$f":"P9*26.4","v":8622.239999999998},"Mängdning från ritning",{"$f":"SUM(H23+I23+K23)","v":3.3904999999999998},{"$f":"F23*D23/1000","v":29.233704719999992},3.15,7.9500000000000001E-2,null,0.161,"Boverket","NEJ"]
["Stena stål","Återbrukat","kg CO2e/ton",{"$f":"P9*26.4","v":8622.239999999998},"Mängdning från ritning",{"$f":"SUM(H24:K24)","v":6.9206820000000002E-2},{"$f":"F24*D24/1000","v":0.59671781167679994},{"$f":"0.0532","v":5.3199999999999997E-2},1.6E-2,null,{"$f":"0.00000682","v":6.8199999999999999E-6},"Stena, återbrukat","Nej"]
["Tibnor","KKR-150","kg CO2e/kg",{"$f":"P9*26.4","v":8622.239999999998},"Mängdning från ritning",{"$f":"SUM(H25+I25)","v":2.7488000000000001},{"$f":"D25*F25/1000","v":23.700813311999994},{"$f":"2.7","v":2.7},{"$f":"4.88*10^-2","v":4.8800000000000003E-2},null,6.0199999999999997E-2,"Tibnor","NEJ","Val av HEA","Tibnor"]
["Mineralull"]
[null,null,null,"A*tjocklek*densitet [ton]"]
["Boverket","Glasull","kg CO2e/kg",{"$f":"0.1*P6*90/1000","v":5.0179499999999999},"Mängdning från ritning",{"$f":"H28+I28+K28","v":1.2467999999999999},{"$f":"D28*F28","v":6.2563800599999997},1.2,3.4500000000000003E-2,null,1.23E-2,"Boverket","NEJ","Vikt: 90kg/m2"]
["Knauf","Mineralull","kg CO2e/kg",{"$f":"0.1*P6*90/1000","v":5.0179499999999999},"Mängdning från ritning",{"$f":"SUM(H29:K29)/9","v":1.3724444444444446},{"$f":"F29*D29","v":6.8868576000000008},{"$f":"9.26","v":9.26},0.67200000000000004,null,2.42,"Knauf","NEJ","Vikt: 90kg/m2"]
["Profilerat tak"]
["Boverket","Galvaniserade produkter","kg CO2e/kg",{"$f":"P6*36","v":20071.8},"Mängdning från ritning",{"$f":"H31+I31+K31","v":3.5794999999999999},{"$f":"D31*F31/1000","v":71.847008099999996},3.33,7.9500000000000001E-2,null,0.17,"Boverket","NEJ"]
["Lindab","Högprofilerad plåt","kg CO2e/kg",{"$f":"P6*36","v":20071.8},"Mängdning från ritning",{"$f":"H32+I32+K32","v":2.8104099999999996},{"$f":"D32*F32/1000","v":56.409987437999987},{"$f":"2.76*10^0","v":2.76},{"$f":"4.88*10^-2","v":4.8800000000000003E-2},null,{"$f":"1.61*10^-3","v":1.6100000000000001E-3},"Lindab","NEJ","36 kg/m2","Lindab"]
["Portomfattning"]
[null,null,null,"Kg  [m*kg/m]"]
["Stena stål","Återbrukat","kg CO2e/ton",{"$f":"(7+14*2+7+4.5*2)*26.4","v":1346.3999999999999},"Mängdning från ritning",{"$f":"SUM(H35:K35)","v":6.9206820000000002E-2},{"$f":"F35*D35/1000","v":9.3180062447999992E-2},{"$f":"0.0532","v":5.3199999999999997E-2},1.6E-2,null,{"$f":"0.00000682","v":6.8199999999999999E-6},"Stena, återbrukat","NEJ"]
["Tibnor","KKR-150","kg CO2e/kg",{"$f":"(7+14*2+7+4.5*2)*26.4","v":1346.3999999999999},"Mängdning från ritning",{"$f":"SUM(H36+I36)","v":2.7488000000000001},{"$f":"D36*F36/1000","v":3.7009843199999999},{"$f":"2.7","v":2.7},{"$f":"4.88*10^-2","v":4.8800000000000003E-2},null,0,"Tibnor","NEJ","Räknar med en KKR-balk runt portarna som protomfattning. De har dimensionerna 4,5x7 och 14x7.","Tibnor"]
["Boverket","stål (80% skrot)","kg CO2e/kg",{"$f":"D36","v":1346.3999999999999},"Mängdning från ritning",{"$f":"SUM(H37+I37)","v":3.2294999999999998},{"$f":"D37*F37/1000","v":4.3481987999999996},3.15,7.9500000000000001E-2,null,0.161,"Boverket"]
["Stålplåt"]
[null,null,null,"Mängd [ton]"]
["Tata","Stålplåt","kg CO2e/ton",{"$f":"P7*0.005*7.8","v":54.493919999999989},"Mängdning från ritning",{"$f":"H40","v":2800},{"$f":"F40*D40/1000","v":152.58297599999997},{"$f":"2.8*10^3","v":2800},7.9500000000000001E-2,null,6.0199999999999997E-2,"Tata","NEJ","0,005m tjock. Desitet 7,8 ton/m3","A4 och A5 från Boverkets stål 100% skrot"]
[null,null,null,"Mängd [m2]"]
["Sidma","Aluminiumplåt","kg CO2e/m2",{"$f":"P7","v":1397.2799999999997},"Mängdning från ritning",{"$f":"H42","v":39.551400000000001},{"$f":"F42*D42/1000","v":55.26438019199999},{"$f":"3.95*10^1+5.14*10^-2","v":39.551400000000001},7.9500000000000001E-2,null,6.0199999999999997E-2,"Sidma","JA","Aluminium","A4 och A5 från Boverkets stål 100% skrot"]
["Resultat"]
["Bäst",{"$f":"G3+G5+G8+G12+G25+G29+G32+G36+G42+G18","v":177.90630901382036}]
["Sämst",{"$f":"G3+G5+G7+G11+G25+G29+G31+G36+G40+G19","v":294.26628011747522}]
["Boverket",{"$f":"G3+G5+G7+G13+G25+G28+G31+G36+G40+G19","v":287.21712483120001}]
[]
[]
["Limträ"]
["Tillverkare","Material","Funkti. enhet","Mängd [m3,ton]","Källa, mängd","A1-A5 ","Tot CO2 [ton]","A1 (A1-A3)","A2","A3","A4","A4 km","A5 (byggspill/instal.)",null,"Pelare "]
["Stora enso (exkl.biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"Q52+Q55","v":98.79649999999998},"Fiktiv",{"$f":"SUM(H51:M51)","v":60.57},{"$f":"F51*D51/1000","v":5.9841040049999989},{"$f":"52.6","v":52.6},null,null,{"$f":"2.59","v":2.59},null,5.38,"Stora Enso KL trä","Längd","Tvärsnitt","Volym m3"]
["Stora enso (inkl.biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"Q52+Q55","v":98.79649999999998},"Fiktiv",-701.41870000000006,{"$f":"F52*D52/1000","v":-69.297712594549992},{"$f":"H51-762","v":-709.4},null,null,{"$f":"K51+0.0103","v":2.6002999999999998},null,{"$f":"M51+0.001","v":5.3810000000000002},"Stora Enso KL trä",{"$f":"P9","v":326.59999999999997},{"$f":"0.5*0.5","v":0.25},{"$f":"P52*O52","v":81.649999999999991}]
["Moelven (inkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"Q52+Q55","v":98.79649999999998},"Fiktiv",58.04,5.7341488599999986,{"$f":"52.4","v":52.4},null,null,{"$f":"2.82","v":2.82},null,{"$f":"2.82","v":2.82},"Moelven Limträ","Balkar"]
["Moelven (exkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"Q52+Q55","v":98.79649999999998},"Fiktiv",-685.30800000000011,-67.706031821999986,{"$f":"H53-744","v":-691.6},null,null,{"$f":"K53+0.326","v":3.1459999999999999},null,{"$f":"M53+0.326","v":3.1459999999999999},"Moelven Limträ","Längd","Tvärsnitt","Volym m3"]
["Setra (exkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"Q52+Q55","v":98.79649999999998},"Fiktiv",56.65,5.596821724999999,{"$f":"44","v":44},null,null,{"$f":"4.3","v":4.3},null,{"$f":"M57","v":8.35},"Setra Limträ",{"$f":"P9","v":326.59999999999997},{"$f":"0.15*0.35","v":5.2499999999999998E-2},{"$f":"P55*O55","v":17.146499999999996}]
["Setra (inkl. biogent kol)","Limträ ","kg CO2/m3 ",{"$f":"Q52+Q55","v":98.79649999999998},"Fiktiv",-695.65,-68.727785224999991,{"$f":"-704","v":-704},null,null,0,null,{"$f":"M55","v":8.35},"Setra Limträ"]
["Boverket","Limträ","kg CO2e/kg",{"$f":"D56*0.468","v":46.236761999999992},"Fiktiv",{"$f":"SUM(H57:M57)","v":175.85},{"$f":"F57*D57/1000","v":8.1307345976999983},133,null,null,34.5,null,8.35,"Boverket limträ","Smide"]
["Boverket","Konstruktionsstål","kg CO2e/kg",{"$f":"Q59","v":0.70569090130700829},"Fiktiv",{"$f":"SUM(H58:M58)","v":3.3904999999999998},{"$f":"F58*D58","v":2.3926450008814113},3.15,null,null,7.9500000000000001E-2,null,0.161,"Boverket","Andel av mängd (kg)",null,{"$f":"20000/(1156265+154132)","v":1.5262550204251078E-2}]
[{"$nulls":14},"Mängd (ton)",null,{"$f":"Q58*D57","v":0.70569090130700829}]

{"sheet":"Transporter","index":5,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,0,1,1],[0,0,0,5],[19,0,19,5],[20,0,20,1],[20,3,20,4]]}
["Utsläpp transport Spanien - Uddevalla",{"$nulls":5},"CO2e utsläpp - olika energikällor"]
["Trafikverket med Diesel",null,null,"Trafikverket med HVO",null,null,null,"Utsläpp","Energiinnehåll kWh/l"]
["kWh/km",3.4,"Trafikverket",{"$f":"A3","v":"kWh/km"},3.4,"Trafikverket","Diesel MK1 kg CO2e/liter",2.3559999999999999,{"$f":"35.3/3.6","v":9.8055555555555554}]
["KWh/l",{"$f":"I3","v":9.8055555555555554},"Ungefärlig siffra utifrån flera källor","KWh/l",{"$f":"I4","v":9.4444444444444446},"Ungefärlig siffra utifrån flera källor","HVO100 kg CO2e/liter",0.35699999999999998,{"$f":"34/3.6","v":9.4444444444444446},{"$f":"I4/I3","v":0.96317280453257792}]
["l/km",{"$f":"B3/B4","v":0.34674220963172803},null,"l/km",{"$f":"E3/E4","v":0.36},null,"El (mix) kg/kWh",{"$f":"26/1000","v":2.5999999999999999E-2}]
["kg CO2e/l",{"$f":"H3","v":2.3559999999999999},null,"kg CO2e/l",{"$f":"H4","v":0.35699999999999998},null,"Diesel MK1 kg CO2e/kWh",{"$f":"1/I3*H3","v":0.24027195467422094},null,{"$f":"(1-J4)*100","v":3.682719546742208}]
["kg CO2e/km",{"$f":"B6*B5","v":0.81692464589235114},null,"kg CO2e/km",{"$f":"E6*E5","v":0.12852},null,"HVO100 kg CO2e/kWh",{"$f":"H4*1/I4","v":3.78E-2}]
["km",2700,null,"km",2700]
["tot co2e [ton]",{"$f":"B7*B8/1000","v":2.2056965439093483},null,"tot co2e [ton]",{"$f":"E7*E8/1000","v":0.34700399999999998},null,"Drivmedel","Liter","Pris/liter","Kostnad","CO2e besparing ton","Kr / ton"]
[{"$nulls":6},"Diesel",{"$f":"B12*B8*B5","v":45873.994334277617},18.690000000000001,{"$f":"I10*H10","v":857384.95410764869},0,"NA"]
["Tung lastbil [ton]",40,null,{"$f":"A11","v":"Tung lastbil [ton]"},40,null,"HVO",{"$f":"E12*E8*E5","v":47628},{"$f":"21.84","v":21.84},{"$f":"I11*H11","v":1040195.52},{"$f":"B18-B17","v":91.075934651558072},{"$f":"(J11-J10)/K11","v":2007.2323890142357}]
["Antal körningar",49,null,{"$f":"A12","v":"Antal körningar"},49,"Tornum"]
["TOT CO2e [ton]",{"$f":"B12*B9","v":108.07913065155807},null,{"$f":"A13","v":"TOT CO2e [ton]"},{"$f":"E12*E9","v":17.003195999999999}]
["Kostnad",{"$f":"B8*B5*I10*B12","v":857384.95410764869},null,"Kostnad",{"$f":"E5*E8*E12*I11","v":1040195.52},null,"Drivmedel","Liter","Pris/liter","Kostnad","CO2e besparing ton","Kr / ton"]
["CO2e besparing ton",0,null,"CO2e besparing ton",{"$f":"B13-E13","v":91.075934651558072},null,"Diesel",{"$f":"B29","v":15297.450424929179},{"$f":"I10","v":18.690000000000001},{"$f":"B32","v":285909.34844192636},0,{"$f":"B34","v":"NA"}]
["Kr / ton","NA",null,"Kr / ton",{"$f":"(E14-B14)/E15","v":2007.2323890142357},null,"HVO",{"$f":"E29","v":15882.35294117647},{"$f":"I11","v":21.84},{"$f":"E32","v":346870.5882352941},{"$f":"E33","v":30.370793201133139},{"$f":"E34","v":2007.2323890142345}]
["HVO",{"$f":"E13","v":17.003195999999999}]
["Diesel",{"$f":"B13","v":108.07913065155807}]
[]
["Utsläpp transport Uddevalla - lokaltipp (25 km enkelväg, 50 km dubbelväg)"]
["Diesel",null,null,"HVO"]
["l/km",{"$f":"B5","v":0.34674220963172803},null,"l/km",{"$f":"E5","v":0.36}]
["kg CO2e/l",{"$f":"B6","v":2.3559999999999999},null,"kg CO2e/l",{"$f":"E6","v":0.35699999999999998}]
[]
["Massor [m3]",6000,null,"Massor [m3]",6000]
["Ton ",{"$f":"B25*2.5","v":15000},null,"Ton",{"$f":"E25*2.5","v":15000}]
["Antal lastbilar",{"$f":"B26/17","v":882.35294117647061},null,"Antal lastbilar",{"$f":"E26/17","v":882.35294117647061}]
["Kilometer",{"$f":"B27*50","v":44117.647058823532},null,"Kilometer",{"$f":"50*E27","v":44117.647058823532}]
["Liter bränsle",{"$f":"B28*B22","v":15297.450424929179},null,"Liter bränsle",{"$f":"E28*E22","v":15882.35294117647}]
[]
["TOT CO2e [ton]",{"$f":"B29*B23/1000","v":36.040793201133141},null,"TOT CO2e [ton]",{"$f":"E29*E23/1000","v":5.67}]
["Kostnad",{"$f":"B29*I10","v":285909.34844192636},null,"Kostnad",{"$f":"E29*I11","v":346870.5882352941}]
["CO2e besparing ton",0,null,"CO2e besparing ton",{"$f":"B31-E31","v":30.370793201133139}]
["Kr / ton","NA",null,"Kr / ton",{"$f":"(E32-B32)/E33","v":2007.2323890142345}]
["HVO",{"$f":"E31","v":5.67}]
["Diesel",{"$f":"B31","v":36.040793201133141}]

{"sheet":"Entreprenadmaskiner","index":6,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[38,0,38,9],[0,0,0,9],[8,0,8,9],[16,0,16,9],[26,0,26,9],[32,0,32,9]]}
["Grävmaskiner - schakt innan sprägning"]
["Märke","Modell","Vikt [ton]","Dielsel [l/h] ","Diesel [CO2e/h]","HVO [CO2e/h]","h","Tot CO2e diesel [ton]","Tot CO2e HVO [ton]","Källa","CO2e utsläpp - olika energikällor"]
["Volvo","EC 300",34,{"$f":"E3/$L$4","v":25.169779286926996},59.3,{"$f":"D3*1.04*$L$5","v":9.345035653650255},{"$f":"$L$10*2*$L$13","v":160},{"$f":"E3*G3/1000","v":9.4879999999999995},{"$f":"F3*G3/1000","v":1.4952057045840408},"Volvo","Drivmedel","Utsläpp (kg CO2e)","Energiinnehåll (kWh/l)","Skillnad"]
["Liebherr","R934",35,18.48,{"$f":"D4*$L$4","v":43.538879999999999},{"$f":"D4*$L$5","v":6.5973600000000001},{"$f":"$L$10*2*$L$13","v":160},{"$f":"E4*G4/1000","v":6.9662208000000003},{"$f":"F4*G4/1000","v":1.0555776000000001},"Liebherr","Diesel MK1 kg CO2e/liter",2.3559999999999999,9.8055559999999993]
["Liebherr","R938",37,20.65,{"$f":"D5*$L$4","v":48.651399999999995},{"$f":"D5*$L$5","v":7.3720499999999989},{"$f":"$L$10*2*$L$13","v":160},{"$f":"E5*G5/1000","v":7.7842239999999991},{"$f":"F5*G5/1000","v":1.1795279999999997},"Liebherr","HVO100 kg CO2e/liter",0.35699999999999998,9.4444440000000007,0.96317299999999995]
["Caterpillar","336F",37,22,{"$f":"D6*$L$4","v":51.831999999999994},{"$f":"D6*$L$5","v":7.8539999999999992},{"$f":"$L$10*2*$L$13","v":160},{"$f":"E6*G6/1000","v":8.2931199999999983},{"$f":"F6*G6/1000","v":1.25664},"Cat","Diesel MK1 kg CO2e/kWh",0.24,null,3.6827200000000002]
["Medel",null,{"$f":"SUM(C3:C6)/4","v":35.75},{"$f":"SUM(D3:D6)/4","v":21.574944821731748},{"$f":"SUM(E3:E6)/4","v":50.830569999999994},{"$f":"SUM(F3:F6)/4","v":7.7921114134125631},null,{"$f":"SUM(H3:H6)/4","v":8.1328911999999995},{"$f":"SUM(I3:I6)/4","v":1.24673782614601},null,"HVO100 kg CO2e/kWh",3.7999999999999999E-2]
[]
["Grävmaskiner  - övrig tid",{"$nulls":9},"1 arbetsdag",8,"h"]
[{"$f":"A2","v":"Märke"},"Modell","Vikt [ton]","Dielsel [l/h] ","Diesel [CO2e/h]","HVO [CO2e/h]","h","Tot CO2e diesel [ton]","Tot CO2e HVO [ton]","Källa","1 vecka",{"$f":"L9*5","v":40},"h"]
["Volvo","EC 300",34,{"$f":"E11/$L$4","v":25.169779286926996},59.3,{"$f":"D11*1.04*$L$5","v":9.345035653650255},{"$f":"$L$11*12*$L$15","v":3840},{"$f":"E11*G11/1000","v":227.71199999999999},{"$f":"F11*G11/1000","v":35.884936910016975},"Volvo","1 månad",{"$f":"L10*4","v":160},"h"]
["Liebherr","R934",35,18.48,{"$f":"D12*$L$4","v":43.538879999999999},{"$f":"D12*$L$5","v":6.5973600000000001},{"$f":"$L$11*12*$L$15","v":3840},{"$f":"E12*G12/1000","v":167.18929920000002},{"$f":"F12*G12/1000","v":25.333862400000001},"Liebherr"]
["Liebherr","R938",37,20.65,{"$f":"D13*$L$4","v":48.651399999999995},{"$f":"D13*$L$5","v":7.3720499999999989},{"$f":"$L$11*12*$L$15","v":3840},{"$f":"E13*G13/1000","v":186.82137599999999},{"$f":"F13*G13/1000","v":28.308671999999994},"Liebherr","Antal grävmaskiner schakt",2]
["Caterpillar","336F",37,22,{"$f":"D14*$L$4","v":51.831999999999994},{"$f":"D14*$L$5","v":7.8539999999999992},{"$f":"$L$11*12*$L$15","v":3840},{"$f":"E14*G14/1000","v":199.03487999999999},{"$f":"F14*G14/1000","v":30.159359999999996},"Cat"]
["Medel",null,{"$f":"SUM(C11:C14)/4","v":35.75},{"$f":"SUM(D11:D14)/4","v":21.574944821731748},{"$f":"SUM(E11:E14)/4","v":50.830569999999994},{"$f":"SUM(F11:F14)/4","v":7.7921114134125631},null,{"$f":"SUM(H11:H14)/4","v":195.18938880000002},{"$f":"SUM(I11:I14)/4","v":29.921707827504243},null,"Antal grävmaskiner",2]
[]
["Dumper",{"$nulls":9},"Antal dumper",1]
[{"$f":"A2","v":"Märke"},"Modell","Vikt [ton]","Dielsel [l/h] ","Diesel [CO2e/h]","HVO [CO2e/h]","h","Tot CO2e diesel [ton]","Tot CO2e HVO [ton]","Källa"]
["Volvo","A25",25,{"$f":"E19/$L$4","v":19.397283531409169},45.7,{"$f":"D19*1.04*$L$5","v":7.2018234295415962},{"$f":"$L$11*6*$L$17","v":960},{"$f":"E19*G19/1000","v":43.872},{"$f":"F19*G19/1000","v":6.9137504923599327},"Volvo"]
["Volvo","A30",30,{"$f":"E20/$L$4","v":21.943972835314096},51.7,8.1473582342954174,960,49.631999999999998,7.8214639049236014,"Volvo"]
["Volvo","A35",35,{"$f":"E21/$L$4","v":26.103565365025467},61.5,9.6917317487266548,960,59.04,9.3040624787775883,"Volvo"]
["Volvo","A40",40,{"$f":"E22/$L$4","v":31.366723259762313},73.900000000000006,11.64583701188455,960,70.944000000000003,11.180003531409168,"Volvo"]
["Volvo","A45",45,{"$f":"E23/$L$4","v":31.154499151103568},73.400000000000006,11.567042444821732,960,70.463999999999999,11.104360747028862,"Volvo"]
["Liebherr","TA230",25,15.06,{"$f":"D24*L4","v":35.481360000000002},5.5914768000000006,960,34.062105600000002,5.3678177280000012,"Liebherr"]
["Medel",null,{"$f":"SUM(C19:C24)/6","v":33.333333333333336},{"$f":"SUM(D19:D24)/6","v":24.171007357102436},{"$f":"SUM(E19:E24)/6","v":56.946893333333342},{"$f":"SUM(F19:F24)/6","v":8.9742116115449928},null,{"$f":"SUM(H19:H24)/6","v":54.669017599999997},{"$f":"SUM(I19:I24)/6","v":8.6152431470831932}]
[]
["Compactor/Vält"]
[{"$f":"A2","v":"Märke"},"Modell","Vikt [ton]","Dielsel [l/h] ","Diesel [CO2e/h]","HVO [CO2e/h]","h","Tot CO2e diesel [ton]","Tot CO2e HVO [ton]","Källa"]
["Volvo ","SD115",11,{"$f":"E29/$L$4","v":16.256366723259763},38.299999999999997,{"$f":"D29*1.04*$L$5","v":6.0356638370118842},{"$f":"L11*4","v":640},{"$f":"E29*G29/1000","v":24.512},{"$f":"F29*G29/1000","v":3.8628248556876059},"Volvo"]
["Caterpillar","CP56B",11.6,14,{"$f":"D30*$L$4","v":32.983999999999995},{"$f":"D30*1.04*$L$5","v":5.1979199999999999},{"$f":"G29","v":640},{"$f":"E30*G30/1000","v":21.109759999999994},{"$f":"F30*G30/1000","v":3.3266687999999998},"Cat"]
[null,null,{"$f":"SUM(C29:C30)/2","v":11.3},{"$f":"SUM(D29:D30)/2","v":15.128183361629882},{"$f":"SUM(E29:E30)/2","v":35.641999999999996},{"$f":"SUM(F29:F30)/2","v":5.6167919185059425},null,{"$f":"(H29+H30)/2","v":22.810879999999997},{"$f":"(I29+I30)/2","v":3.5947468278438031}]
[]
["CO2 besparing maskiner"]
[null,"Diesel [l]","Kostnad [kr]","HVO [l]","Kostnad [kr]","Extra kostnad [kr]","kr / sparat ton CO2e"]
["Grävmaskiner",{"$f":"D15*L10*2*L13+D15*G14","v":86299.779286927005},{"$f":"B35*'Material & Processer'!C49","v":1612942.8748726659},{"$f":"B35/N5","v":89599.458546831156},{"$f":"D35*'Material & Processer'!C50","v":1956852.1746627924},{"$f":"E35-C35","v":343909.2997901265},{"$f":"(F35)/((H15+H7)-(I15+I7))","v":1997.6859713634287}]
["Dumper",{"$f":"D25*G24","v":23204.167062818338},{"$f":"B36*'Material & Processer'!C49","v":433685.88240407477},{"$f":"B36/N5","v":24091.38032608715},{"$f":"D36*'Material & Processer'!C50","v":526155.74632174335},{"$f":"E36-C36","v":92469.863917668583},{"$f":"F36/(H25-I25)","v":2007.8672164472728}]
["Compactor/vält",{"$f":"D31*G30","v":9682.0373514431249},{"$f":"B37*'Material & Processer'!C49","v":180957.27809847202},{"$f":"B37/N5","v":10052.230857222041},{"$f":"D37*'Material & Processer'!C50","v":219540.72192172936},{"$f":"E37-C37","v":38583.443823257345},{"$f":"F37/(H31-I31)","v":2007.8672164472721}]
[]
["Resultat"]
["HVO",{"$f":"I15+I25+I31+I7","v":43.378435628577243}]
["Diesel",{"$f":"H7+H15+H25+H31","v":280.80217759999999}]
["Boverket","-"]

{"sheet":"Referensobjekt, Sala ","index":7,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[65,4,65,5],[65,6,65,7],[65,0,65,3],[1,0,1,7],[42,0,42,5],[24,0,24,12],[31,0,31,12],[4,0,4,7],[7,0,7,7],[10,0,10,7],[13,0,13,7],[16,0,16,7],[19,0,19,7],[54,0,54,3],[64,0,64,7]]}
["Mängdning betong & armering"]
["Stora silor"]
["Inre Radie [m]","Tjocklek vägg [m]","Höjd[m]","Inre area [m2]","Yttre area [m2]","Volym [m3]","Antal [st]","Totalt [m3]"]
[{"$f":"9/2","v":4.5},0.2,{"$f":"105-51.4","v":53.6},{"$f":"A4^2*PI()","v":63.617251235193308},{"$f":"(A4+B4)^2*PI()","v":69.397781717798537},{"$f":"(E4-D4)*C4","v":309.83643386764032},12,{"$f":"F4*G4","v":3718.0372064116837}]
["Små silor"]
["Radie [m]",{"$f":"B3","v":"Tjocklek vägg [m]"},{"$f":"C3","v":"Höjd[m]"},"Inre area [m2]","Yttre area [m2]","Volym [m3]",{"$f":"G3","v":"Antal [st]"},"Totalt [m3]"]
[{"$f":"6.04/2","v":3.02},0.2,{"$f":"C4","v":53.6},{"$f":"A7^2*PI()","v":28.652581637800349},{"$f":"(A7+B7)^2*PI()","v":32.573289269480412},{"$f":"(E7-D7)*C7","v":210.14992905805138},5,{"$f":"G7*F7","v":1050.7496452902569}]
["\"Tak\""]
["Tjocklek","area [m2]","Volym [m3]"]
[0.16,{"$f":"C13*B13*0.85","v":1026.5619999999999},{"$f":"B10*A10","v":164.24991999999997}]
["Betongplatta"]
["Tjocklek (m)","Längd (m)","Bredd (m)","Volym [m3]"]
[0.6,55.4,21.8,{"$f":"C13*B13*A13","v":724.63199999999995}]
["Kulvertar"]
["Höjd","Bredd","Tjocklek","Längd","Antal kulvertar","Volym [m3]"]
[{"$f":"51.4-0.6-48.8","v":2},2,0.2,{"$f":"B13","v":55.4},2,{"$f":"D16*C16*(B16+A16*2)*E16","v":132.96}]
["Sulor"]
["Tjocklek ","Höjd","Längd","Bredd [m]","Volym [m3]","Antagande"]
[1,3,{"$f":"B13","v":55.4},21.8,{"$f":"A19*B19*D19*2+A19*B19*C19*2","v":463.2},"Sulor går på både långsidor och kortsidor. Tjocklek 1m. Höjd 3m."]
["Volym betong och armering"]
[" Betongvolym  [m3]","Varav ovan mark [m3]","Varav under mark [m3]","Armering (ton)","Armering ovan mark [ton]","Armering under mark [ton]"]
[{"$f":"E19+F16+D13+H7+H4+C10","v":6253.8287717019412},{"$f":"H4+H7+C10","v":4933.0367717019408},{"$f":"D13+F16+E19","v":1320.7919999999999},{"$f":"A22*0.1","v":625.38287717019421},{"$f":"B22*0.1","v":493.30367717019408},{"$f":"C22*0.1","v":132.07919999999999}]
[]
["EPD:er"]
["Betong"]
["Tillverkare","Material","Enhet","Mängd [m3]","Källa, mängd","LCA CO2 (A1-A5)","Tot CO2 [ton]","A1 eller A1-A3","A2","A3","A4","A5 (byggspill/instal.)","Länk EPD/källa"]
["Skanska","Anläggning, ej klimatförbättr","Kg/m3",{"$f":"C22","v":1320.7919999999999},"Ritningar",{"$f":"SUM(H27:K27)","v":311.60000000000002},{"$f":"D27*F27/1000","v":411.55878720000004},311.60000000000002,null,null,{"$f":"S31","v":0},3.37,"Skanska"]
["Thomas betong","Anläggning C30/37","Kg/m3",{"$f":"C22","v":1320.7919999999999},{"$f":"E27","v":"Ritningar"},{"$f":"SUM(H28:L28)","v":232.17000000000002},{"$f":"D28*F28/1000","v":306.64827864},225,null,null,3.8,3.37,"mail "]
["Swerock","Swerock Eco 3","Kg/m3",{"$f":"C22","v":1320.7919999999999},{"$f":"E28","v":"Ritningar"},{"$f":"SUM(H29:L29)","v":228.83},{"$f":"F29*D29/1000","v":302.23683335999999},214,7.18,1.1200000000000001,3.16,3.37,"Swerock"]
["Betongindustri","VäggBI C35/45 BIO1","Kg/m3",{"$f":"B22","v":4933.0367717019408},"Ritningar",{"$f":"SUM(H30:L30)","v":266.74},{"$f":"F30*D30/1000","v":1315.8382284837755},260,null,null,3.37,3.37,"Betongindustrin"]
["Betongindustri","VäggBI C35/45 BIO3","Kg/m3",{"$f":"B22","v":4933.0367717019408},"Ritningar",{"$f":"SUM(H31:L31)","v":176.73000000000002},{"$f":"D31*F31/1000","v":871.81558866288412},170,null,null,3.36,3.37,"Betongindustrin"]
["Armering"]
["Tillverkare","Material","Enhet","Mängd [ton]","Källa, mängd","LCA CO2 (A1-A5)","Tot CO2 [ton]","A1 eller A1-A3","A2","A3","A4","A5 (byggspill/instal.)","Länk EPD/källa"]
["Boverket","Armering","Kg/ton",{"$f":"D22","v":625.38287717019421},"Antagande, 100kg /m2",{"$f":"SUM(H34:L34)","v":898.7},{"$f":"F34*D34/1000","v":562.03159171285347},745,null,null,79.5,74.2,"Boverket.se"]
["Celsa ","Armering","Kg/ton",{"$f":"D22","v":625.38287717019421},"Antagande, 100kg /m3",{"$f":"SUM(H35:L35)","v":519.4},{"$f":"F35*D35/1000","v":324.82386640219886},{"$f":"373+25","v":398},null,null,{"$f":"33.4+13.8","v":47.2},74.2,"Celsa"]
["BE Group","Armering","kg/ton",{"$f":"D22","v":625.38287717019421},"Antagande, 100kg /m4",{"$f":"SUM(H36:L36)","v":501.83},{"$f":"F36*D36/1000","v":313.83588925031853},{"$f":"338+19","v":357},null,null,{"$f":"77.1-6.47","v":70.63},74.2,"BE group"]
["Stena Stål AB","Armering","kg/ton",{"$f":"D22","v":625.38287717019421},"Antagande, 100kg /m5",{"$f":"SUM(H37:L37)","v":579.60000000000014},{"$f":"F37*D37/1000","v":362.47191560784466},{"$f":"4.73*10^2","v":473.00000000000006},null,null,{"$f":"3.24*10^1","v":32.400000000000006},74.2,"Stena Stål"]
[]
["Lagringskapacitet"]
["Uddevalla",43000]
["Sala",34000]
[]
["Buffert till galvaniserat stål"]
["Buffert till stål för Best Case Scenario"]
["Anläggning","Lagringskapacitet [ton]","CO2e btg+armering [ton]","Co2e/lagringston [ton]","Buffert för stålet [ton]","Värde på EPD [kg CO2e/ton]"]
["Uddevalla",{"$f":"B40","v":43000},{"$f":"(Resultat!B3+Resultat!B5)*0.75","v":1278.4949999999999},{"$f":"C46/B46","v":2.9732441860465114E-2},{"$f":"B46*(D47-D46)","v":603.24609955140352},{"$f":"E46/'Material & Processer'!D10*1000","v":942.57203054906802}]
["Sala",{"$f":"B41","v":34000},{"$f":"G29+G31+G36","v":1487.8883112732026},{"$f":"C47/B47","v":4.3761420919800079E-2}]
[null,null,null,{"$f":"D47-D46","v":1.4028979059334964E-2}]
["Buffert till stål för Worst Case Scenario"]
["Anläggning","Lagringskapacitet [ton]","CO2e btg+armering [ton]","Co2e/lagringston [ton]","Buffert för stålet [ton]","Värde på EPD [kg CO2e/ton]"]
["Uddevalla",{"$f":"B40","v":43000},{"$f":"(Resultat!C3+Resultat!C5)*0.75","v":1807.0650000000001},{"$f":"C51/B51","v":4.2024767441860469E-2},{"$f":"B51*(D52-D51)","v":836.00453075116684},{"$f":"E51/'Material & Processer'!D10*1000","v":1306.2570792986983}]
["Sala",{"$f":"B41","v":34000},{"$f":"G37+G30+G27","v":2089.8689312916204},{"$f":"C52/B52","v":6.1466733273282954E-2}]
[null,null,null,{"$f":"D52-D51","v":1.9441965831422485E-2}]
[]
["Galvat stål vs btg väggar"]
["Best case stål vs betong"]
["Anläggning","Vägg CO2e [ton]","CO2e /lagringskapacitet [ton]","Förändring  CO2e [ton]"]
["Uddevalla",{"$f":"Resultat!B4","v":687.06207600000016},{"$f":"B58/B40","v":1.5978187813953493E-2},{"$f":"(C59-C58)*B40","v":728.61196629469737},"Best case",{"$f":"D58","v":728.61196629469737}]
["Sala",{"$f":"B22*F31/1000+E22*F36/1000","v":1119.3701729772026},{"$f":"B59/B41","v":3.2922652146388315E-2},null,"Worst Case",{"$f":"D62","v":63.144419647844011}]
["Worst case stål vs betong",null,null,null,{"$f":"B22*F30/1000+F37*E22/1000","v":1601.7570397716202}]
["Anläggning",{"$f":"B57","v":"Vägg CO2e [ton]"},{"$f":"C57","v":"CO2e /lagringskapacitet [ton]"},{"$f":"D57","v":"Förändring  CO2e [ton]"}]
["Uddevalla",{"$f":"Resultat!C4","v":1962.607130651558},{"$f":"B62/B40","v":4.5642026294222281E-2},{"$f":"(C63-C62)*B40","v":63.144419647844011}]
["Sala",{"$f":"B22*F30/1000+F37*E22/1000","v":1601.7570397716202},{"$f":"B63/B41","v":4.7110501169753537E-2}]
[]
["Galvat stål vs btg väggar+ platta"]
["Väggar",null,null,null,"Platta",null,"Tot CO2e "]
["Best case stål vs betong",{"$nulls":7},{"$f":"A68","v":"Anläggning"},{"$f":"H68","v":"CO2e /lagringskapacitet [kg]"}]
["Anläggning","Vägg CO2e [ton]","CO2e /lagringskapacitet [ton]",{"$f":"D57","v":"Förändring  CO2e [ton]"},"Betongplatta [m3]","Platta CO2e [ton]","Tot CO2e [ton]","CO2e /lagringskapacitet [kg]","Uddevalla - best",{"$f":"H69","v":45.177222697674424}]
["Uddevalla",{"$f":"Resultat!B4","v":687.06207600000016},{"$f":"B69/B40","v":1.5978187813953493E-2},{"$f":"(C70-C69)*B40","v":728.61196629469737},{"$f":"'Material & Processer'!D3*0.75","v":4500},{"$f":"E69*F29/1000+(0.1*E69)*F36/1000","v":1255.5584999999999},{"$f":"F69+B69","v":1942.620576},{"$f":"G69/B40*1000","v":45.177222697674424},"Sala - best",{"$f":"H70","v":43.761420919800081}]
["Sala",{"$f":"B22*F31/1000+E22*F36/1000","v":1119.3701729772026},{"$f":"B70/B41","v":3.2922652146388315E-2},null,{"$f":"C22","v":1320.7919999999999},{"$f":"E70*F29/1000+F22*F36/1000","v":368.51813829599996},{"$f":"B70+F70","v":1487.8883112732026},{"$f":"G70/B41*1000","v":43.761420919800081},"Uddevalla -  worst",{"$f":"H73","v":84.316910015152516}]
["Worst case stål vs betong",{"$nulls":7},"Sala - worst",{"$f":"H74","v":61.466733273282955}]
["Anläggning",{"$f":"B68","v":"Vägg CO2e [ton]"},{"$f":"C68","v":"CO2e /lagringskapacitet [ton]"},{"$f":"D68","v":"Förändring  CO2e [ton]"},{"$f":"E68","v":"Betongplatta [m3]"}]
["Uddevalla",{"$f":"Resultat!C4","v":1962.607130651558},{"$f":"B73/B40","v":4.5642026294222281E-2},{"$f":"(C74-C73)*B40","v":63.144419647844011},{"$f":"'Material & Processer'!D3*0.75","v":4500},{"$f":"E73*F27/1000+(E73*0.1)*F37/1000","v":1663.02},{"$f":"B73+F73","v":3625.6271306515582},{"$f":"G73/B40*1000","v":84.316910015152516}]
["Sala",{"$f":"B22*F30/1000+E22*F37/1000","v":1601.7570397716202},{"$f":"B74/B41","v":4.7110501169753537E-2},null,{"$f":"C22","v":1320.7919999999999},{"$f":"E74*F27/1000+F22*F37/1000","v":488.11189152000009},{"$f":"B74+F74","v":2089.8689312916204},{"$f":"G74/B41*1000","v":61.466733273282955}]

{"sheet":"Maskiner, kringutr., elkabel","index":8,"n_rows":198,"n_cols":19,"rows_kept":198,"cut":false,"hidden":false,"merged":[[120,9,121,9],[120,10,121,10],[120,11,121,11],[120,12,121,12],[197,4,198,5],[197,6,198,6],[129,0,129,16],[142,0,142,16],[181,0,181,16],[148,0,148,16],[169,0,169,16],[110,0,110,16],[118,0,118,16],[0,0,0,16],[39,0,39,16],[48,0,48,16],[57,0,57,16],[66,0,66,16],[88,0,88,16],[92,0,92,16],[98,0,98,16],[101,0,101,16],[105,0,105,16]]}
["Elevatorer och transportörer"]
["Benämning",null,null,"Maskintyp","Antal ton","Andel galvat stål","Vikt galvat stål [ton]","Andel gummi [kg]","Vikt gummi [ton]","Andel elektronik [ton]","Vikt elektronik [kg]"]
["E41. SEH 63/33 250tph L=17,0 m",null,null,"Elevator",0.64900000000000002,0.8,{"$f":"F3*E3","v":0.51919999999999999},{"$f":"0.1","v":0.1},{"$f":"E3*H3","v":6.4899999999999999E-2},{"$f":"0.1","v":0.1},{"$f":"J3*E3","v":6.4899999999999999E-2}]
["E42. SEH 63/33 250tph L=42,75 m",null,null,"Elevator",1.633,0.8,{"$f":"F4*E4","v":1.3064},{"$f":"0.1","v":0.1},{"$f":"E4*H4","v":0.1633},{"$f":"0.1","v":0.1},{"$f":"J4*E4","v":0.1633}]
["E43. SEH 50/18 100tph L=42,0 m",null,null,"Elevator",0.89800000000000002,0.8,0.71840000000000004,0.1,8.9800000000000005E-2,0.1,8.9800000000000005E-2]
["E44. SEH 50/18 100tph L=41,5 m",null,null,"Elevator",0.88800000000000001,0.8,0.71040000000000003,0.1,8.8800000000000004E-2,0.1,8.8800000000000004E-2]
["E45. SEH 63/33 250tph L=42,0 m",null,null,"Elevator",1.6040000000000001,0.8,1.2832000000000001,0.1,0.16040000000000001,0.1,0.16040000000000001]
["E51. SEH 63/33 250tph L=21,5 m",null,null,"Elevator",0.82099999999999995,0.8,0.65680000000000005,0.1,8.2100000000000006E-2,0.1,8.2100000000000006E-2]
["E52. SEH 63/33 250tph L=42,75 m",null,null,"Elevator",1.633,0.8,1.3064,0.1,0.1633,0.1,0.1633]
["E53. SEH 50/18 100tph L=42,0 m",null,null,"Elevator",0.89800000000000002,0.8,0.71840000000000004,0.1,8.9800000000000005E-2,0.1,8.9800000000000005E-2]
["E54. SEH 50/18 100tph L=41,5 m",null,null,"Elevator",0.88800000000000001,0.8,0.71040000000000003,0.1,8.8800000000000004E-2,0.1,8.8800000000000004E-2]
["E55. SEH 63/33 250tph L=42,0 m",null,null,"Elevator",1.6040000000000001,0.8,1.2832000000000001,0.1,0.16040000000000001,0.1,0.16040000000000001]
["E61. SEH 80/33 500tph L=32,75 m",null,null,"Elevator",3.2749999999999999,0.8,2.62,0.1,0.32750000000000001,0.1,0.32750000000000001]
["E62. SEH 80/33 500tph L=42,0 m",null,null,"Elevator",4.2,0.8,3.3600000000000003,0.1,0.42000000000000004,0.1,0.42000000000000004]
["E64. SEH 50/18 60tph L=14,0 m",null,null,"Elevator",0.20499999999999999,0.8,0.16400000000000001,0.1,2.0500000000000001E-2,0.1,2.0500000000000001E-2]
["T72. KTH 50/51 250tph L=42,6 m",null,null,"Transportör",0.91700000000000004,0.75,{"$f":"E16*F16","v":0.68775000000000008},0.15,{"$f":"H16*E16","v":0.13755000000000001},0.1,9.1700000000000004E-2]
["T73. KTH 50/51 250tph L=39,2 m",null,null,"Transportör",2.8650000000000002,0.75,{"$f":"E17*F17","v":2.1487500000000002},0.15,{"$f":"H17*E17","v":0.42975000000000002},0.1,0.28650000000000003]
["T74. KTHb 30/33 100tph L=30,4 m",null,null,"Transportör",0.22900000000000001,0.75,0.17175000000000001,0.15,3.4349999999999999E-2,0.1,2.2900000000000004E-2]
["T75. KTH 50/51 250tph L=13,6 m",null,null,"Transportör",1.948,0.75,1.4609999999999999,0.15,0.29219999999999996,0.1,0.1948]
["T76. KTH 50/51 250tph L=12,6 m",null,null,"Transportör",0.91700000000000004,0.75,0.68775000000000008,0.15,0.13755000000000001,0.1,9.1700000000000004E-2]
["T77. KTH 30/33 100tph L=39,2 m",null,null,"Transportör",1.1459999999999999,0.75,0.85949999999999993,0.15,0.17189999999999997,0.1,0.11459999999999999]
["T78. KTHb 50/51 250tph L=31,6 m",null,null,"Transportör",0.57299999999999995,0.75,0.42974999999999997,0.15,8.5949999999999985E-2,0.1,5.7299999999999997E-2]
["T79. KTH 50/51 250tph L=47,6 m",null,null,"Transportör",3.0939999999999999,0.75,2.3205,0.15,0.46409999999999996,0.1,0.30940000000000001]
["T85. KTH 20/33 60tph ?",null,null,"Transportör",0.44,0.75,0.33,0.15,6.6000000000000003E-2,0.1,4.4000000000000004E-2]
["T91. KTH 50/51 250tph L=31,3 m",null,null,"Transportör",0.91700000000000004,0.75,0.68775000000000008,0.15,0.13755000000000001,0.1,9.1700000000000004E-2]
["T93. KTH 50/51 250tph L=39,2 m",null,null,"Transportör",2.8650000000000002,0.75,2.1487500000000002,0.15,0.42975000000000002,0.1,0.28650000000000003]
["T94. KTHb 30/33 100tph L=30,4 m",null,null,"Transportör",0.22900000000000001,0.75,0.17175000000000001,0.15,3.4349999999999999E-2,0.1,2.2900000000000004E-2]
["T95. KTH 50/51 250tph L=L=22,8 m",null,null,"Transportör",1.948,0.75,1.4609999999999999,0.15,0.29219999999999996,0.1,0.1948]
["T96. KTH 50/51 250tph L=22,0 m",null,null,"Transportör",0.91700000000000004,0.75,0.68775000000000008,0.15,0.13755000000000001,0.1,9.1700000000000004E-2]
["T97. KTH 30/33 100tph L=39,2 m",null,null,"Transportör",1.1459999999999999,0.75,0.85949999999999993,0.15,0.17189999999999997,0.1,0.11459999999999999]
["T98. KTH 50/51 250tph L=31,6 m",null,null,"Transportör",0.57299999999999995,0.75,0.42974999999999997,0.15,8.5949999999999985E-2,0.1,5.7299999999999997E-2]
["T99. KTH 50/51 250tph L=29,8 m",null,null,"Transportör",3.0939999999999999,0.75,2.3205,0.15,0.46409999999999996,0.1,0.30940000000000001]
["T105. KTH 70/64 500tph L=26,0 m",null,null,"Transportör",3.875,0.75,2.90625,0.15,0.58124999999999993,0.1,0.38750000000000001]
["T110. KTHg 70/64 500tph L=8,0 m",null,null,"Transportör",3.444,0.75,2.5830000000000002,0.15,0.51659999999999995,0.1,0.34440000000000004]
["T111. KTH 70/64 500tph L=37,2 m",null,null,"Transportör",4.306,0.75,3.2294999999999998,0.15,0.64590000000000003,0.1,0.43060000000000004]
["T121. KTH 20/33 5tph L=6,0 m",null,null,"Transportör",2.8000000000000001E-2,0.75,2.1000000000000001E-2,0.15,4.1999999999999997E-3,0.1,2.8000000000000004E-3]
["T123. KTH 20/33 10tph L=4,0 m",null,null,"Transportör",3.6999999999999998E-2,0.75,2.7749999999999997E-2,0.15,5.5499999999999994E-3,0.1,3.7000000000000002E-3]
["T125. KTH 20/33 10tph L=7,5 m",null,null,"Transportör",6.9000000000000006E-2,0.75,5.1750000000000004E-2,0.15,1.035E-2,0.1,6.9000000000000008E-3]
[{"$nulls":4},{"$f":"SUM(E3:E38)","v":54.77300000000001},null,{"$f":"SUM(G3:G38)","v":42.039549999999991},null,{"$f":"SUM(I3:I38)","v":7.2561499999999999},null,{"$f":"SUM(K3:K38)","v":5.4772999999999996}]
["Fläktar och filter (JKF)"]
["Benämning","Vikt ",null,null,"Vikt kg","Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["BF-55EC 3,0 + 1,0 m",1880,null,null,null,{"$f":"0.85","v":0.85},{"$f":"F43*B43","v":1598},{"$nulls":4},{"$f":"0.1","v":0.1},{"$f":"L43*B43","v":188},null,null,{"$f":"0.05","v":0.05},{"$f":"P43*B43","v":94}]
["BF-55EC 4,0 + 1,0 m",2050,null,null,null,{"$f":"0.85","v":0.85},{"$f":"F44*B44","v":1742.5},{"$nulls":4},{"$f":"0.1","v":0.1},{"$f":"L44*B44","v":205},null,null,{"$f":"0.05","v":0.05},{"$f":"P44*B44","v":102.5}]
["V60MTD",775,null,null,null,{"$f":"0.85","v":0.85},{"$f":"F45*B45","v":658.75},{"$nulls":4},{"$f":"0.1","v":0.1},77.5,null,null,{"$f":"0.05","v":0.05},38.75]
["V80MTD",1160,null,null,null,{"$f":"0.85","v":0.85},{"$f":"F46*B46","v":986},{"$nulls":4},{"$f":"0.1","v":0.1},116,null,null,{"$f":"0.05","v":0.05},58]
["Sluse JK-50S",60,null,null,null,{"$f":"0.85","v":0.85},{"$f":"F47*B47","v":51},{"$nulls":4},{"$f":"0.1","v":0.1},6,null,null,{"$f":"0.05","v":0.05},3]
[{"$nulls":6},{"$f":"SUM(G43:G47)","v":5036.25},{"$nulls":5},{"$f":"SUM(M43:M47)","v":592.5},null,null,null,{"$f":"SUM(Q43:Q47)","v":296.25}]
["Rensmaskin & aspiratörer (Westrup)"]
["Benämning","Vikt ",null,null,"Vikt [ton]","Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål kg","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["1 st Rensmaskin CC-1750-E50",7100,{"$nulls":5},0.9,{"$f":"H52*B52","v":6390},null,null,0.05,{"$f":"L52*B52","v":355},null,null,0.05,{"$f":"P52*B52","v":355}]
[]
["1 st ASP. / Halmtrumma (Dubbel) HG-2500",2000,{"$nulls":5},0.9,{"$f":"H54*B54","v":1800},null,null,0.05,{"$f":"L54*B54","v":100},null,null,0.05,{"$f":"P54*B54","v":100}]
["2 st ASP. / Halmtrumma ASP-1250-A2/B3",3000,{"$nulls":5},0.9,{"$f":"H55*B55","v":2700},null,null,0.05,150,null,null,0.05,150]
[{"$nulls":8},{"$f":"SUM(I52:I55)","v":10890},null,null,null,{"$f":"SUM(M52:M55)","v":605},null,null,null,{"$f":"SUM(Q52:Q55)","v":605}]
[]
["Sveperskruvar (elica)"]
["Pos.","Benämning","Vikt Sveperskruvar","Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["63.5","3 st Svepertransportörer",1200,{"$f":"C61*3/1000","v":3.6},null,null,{"$f":"F61*D61","v":0},0.85,{"$f":"H61*C61","v":1020},null,null,0.1,{"$f":"L61*D61","v":0.36000000000000004},null,null,{"$f":"0.05","v":0.05},{"$f":"P61*D61","v":0.18000000000000002}]
["64.5","5 st Svepertransportörer",1500,{"$f":"C62*5/1000","v":7.5},null,null,{"$f":"F62*D62","v":0},0.85,{"$f":"H62*C62","v":1275},null,null,0.1,{"$f":"L62*D62","v":0.75},null,null,{"$f":"0.05","v":0.05},{"$f":"P62*D62","v":0.375}]
[{"$nulls":6},{"$f":"SUM(G61:G62)","v":0},null,{"$f":"SUM(I61:I62)","v":2295},null,null,null,{"$f":"SUM(M61:M62)","v":1.1100000000000001},null,null,null,{"$f":"SUM(Q61:Q62)","v":0.55500000000000005}]
[]
[]
[]
["Luftningsfläktar (Åkerstedts)"]
["Benämning","Vikt Fläktar",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [kg]","Viktandel stål","Vikt stål [kg]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [kg]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["4 st Beluftningsfläktar, 22 kW",1480,null,null,null,0.85,{"$f":"F70*B70","v":1258},{"$nulls":4},0.05,{"$f":"L70*B70","v":74},null,null,{"$f":"0.1","v":0.1},{"$f":"P70*B70","v":148}]
["4 st Beluftningsfläktar, 22 kW",1480,null,null,null,0.85,{"$f":"F71*B71","v":1258},{"$nulls":4},0.05,{"$f":"L71*B71","v":74},null,null,{"$f":"0.1","v":0.1},{"$f":"P71*B71","v":148}]
[]
["2 st Beluftningsfläktar, 22 kW",740,null,null,null,0.85,{"$f":"F73*B73","v":629},{"$nulls":4},0.05,{"$f":"L73*B73","v":37},null,null,0.1,74]
["1 st Beluftningsfläkt, 22 kW",370,null,null,null,0.85,{"$f":"F74*B74","v":314.5},{"$nulls":4},0.05,{"$f":"L74*B74","v":18.5},null,null,0.1,37]
[]
["6 st Beluftningsfläktar, 22 kW",2220,null,null,null,0.85,{"$f":"F76*B76","v":1887},{"$nulls":4},0.05,{"$f":"L76*B76","v":111},null,null,0.1,222]
["10 st Beluftningsfläktar, 22 kW",3700,null,null,null,0.85,{"$f":"F77*B77","v":3145},{"$nulls":4},0.05,{"$f":"L77*B77","v":185},null,null,0.1,370]
[]
["2 st fläktar till tork FAMP-090, 90 kW",3600,1105,null,null,0.85,{"$f":"F79*B79","v":3060},{"$nulls":4},0.05,{"$f":"L79*B79","v":180},null,null,0.1,360]
["2 st fläktar till tork FAMP-090, 90 kW",3600,1105,null,null,0.85,{"$f":"F80*B80","v":3060},{"$nulls":4},0.05,{"$f":"L80*B80","v":180},null,null,0.1,360]
[]
["2 st fläktar kylluft tork FKLP-080, 18,5 kW",740,null,null,null,0.85,{"$f":"F82*B82","v":629},{"$nulls":4},0.05,{"$f":"L82*B82","v":37},null,null,0.1,74]
["2 st fläktar kylluft tork FKLP-080, 18,5 kW",740,null,null,null,0.85,{"$f":"F83*B83","v":629},{"$nulls":4},0.05,{"$f":"L83*B83","v":37},null,null,0.1,74]
[]
["Summa",{"$f":"SUM(B70:B83)","v":18670},{"$nulls":4},{"$f":"SUM(G70:G83)","v":15869.5},{"$nulls":5},{"$f":"SUM(M70:M83)","v":933.5},null,null,null,{"$f":"SUM(Q70:Q83)","v":1867}]
[]
[]
[]
["Behållarvåg (Danvaegt)"]
[null,"Vikt [kg]",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]","Alumnium [kg]"]
[null,{"$f":"SUM(I91:R91)","v":7094},{"$nulls":6},7000,null,6,null,25,null,10,null,3,50]
[]
["Kompressor (Atlas Copco)"]
[null,null,null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
["Kompressor",860,{"$nulls":5},{"$f":"0.8","v":0.8},{"$f":"H95*B95","v":688},null,null,{"$f":"0.1","v":0.1},{"$f":"L95*B95","v":86},null,null,{"$f":"0.1","v":0.1},{"$f":"P95*B95","v":86}]
["BD-tork",466,{"$nulls":5},{"$f":"0.8","v":0.8},{"$f":"H96*B96","v":372.8},null,null,{"$f":"0.1","v":0.1},{"$f":"L96*B96","v":46.6},null,null,{"$f":"0.1","v":0.1},{"$f":"P96*B96","v":46.6}]
["Tank",421,{"$nulls":5},0.8,{"$f":"H97*B97","v":336.8},null,null,0.1,{"$f":"L97*B97","v":42.1},null,null,0.1,{"$f":"P97*B97","v":42.1}]
[{"$nulls":8},{"$f":"SUM(I95:I97)","v":1397.6},null,null,null,{"$f":"SUM(M95:M97)","v":174.7},null,null,null,{"$f":"SUM(Q95:Q97)","v":174.7}]
["Magnet (Goudsmith)"]
[null,null,null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
["Magnet [kg]",200,null,0.2,null,null,null,0.75,{"$f":"H101*D101","v":0.15000000000000002},null,null,0.05,{"$f":"L101*B101","v":10},null,null,0.2,{"$f":"P101*B101","v":40}]
["Utlastningsbälgar (WAM) (\"snabel\" för utlastning av säd)"]
[null,"vikt kg",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
["Utlastningsbälgar",400,null,{"$f":"0.4","v":0.4},null,null,null,0.6,{"$f":"H104*B104","v":240},null,null,0.35,{"$f":"L104*B104","v":140},null,null,0.05,{"$f":"P104*B104","v":20}]
[]
["Avfallscontainrar"]
["Benämning","Vikt Container kg",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["6 st Avfallscontainer",72000,null,{"$f":"B109/1000","v":72},null,null,null,0.95,{"$f":"D109*H109","v":68.399999999999991},{"$nulls":6},0.05,{"$f":"P109*B109","v":3600}]
[]
["Styrskåp"]
["Benämning","Vikter Styrskåp",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
["2 st Motorställverk (MCC",12000,null,{"$f":"B113*2/1000","v":24},{"$nulls":11},1,{"$f":"P113*D113","v":24}]
["1 st PLC-skåp",1200,null,{"$f":"B114/1000","v":1.2},{"$nulls":11},1,{"$f":"P114*D114","v":1.2}]
["1-3 extra skåp i de övre planen",1500,null,{"$f":"B115*2/1000","v":3},{"$nulls":11},1,3]
[{"$nulls":6},{"$f":"SUM(G113:G115)","v":0},null,{"$f":"SUM(I113:I115)","v":0},null,{"$f":"SUM(K113:K115)","v":0},0,0,0,0,null,{"$f":"SUM(Q113:Q115)","v":28.2}]
[]
[]
["Centraldammsugare (Lajac)"]
["Benämning","Vikt Dammsugare",null,null,null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["Stoftavskiljare SDCH-3-HV",120,{"$nulls":6},120,{"$nulls":7},5]
["Rotorsluss MD-200 A",100,{"$nulls":6},100,{"$nulls":7},20]
["Explosionsventil EVN3.0 / SDCH-3",50,{"$nulls":6},50]
["Rotspump TYR 15kW i ljudkabinett",312,{"$nulls":6},312,{"$nulls":7},85]
["El/Styrskåp",20,{"$nulls":6},20,{"$nulls":7},20]
["Rörsystem",500,{"$nulls":6},500,null,null,null,10]
["Summa",{"$nulls":7},{"$f":"SUM(I122:I127)","v":1102},null,null,null,{"$f":"SUM(M121:M127)","v":10},null,null,null,{"$f":"SUM(Q122:Q127)","v":130}]
[]
["Templinor - sensor "]
["Benämning","Vikt Temperaturlinor",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["4 st Templinor till rundsilos D1-D4",1200,null,{"$f":"4*B133/1000","v":4.8},{"$nulls":11},1,{"$f":"P133*D133","v":4.8}]
["4 st Templinor till rundsilos E1-E4",1200,null,{"$f":"4*B134/1000","v":4.8},{"$nulls":11},1,{"$f":"P134*D134","v":4.8}]
[]
["2 st Templinor till rundsilos A1 & A5",600,null,{"$f":"2*B136/1000","v":1.2},{"$nulls":11},1,1.2]
["1 st Templina till rundsilo B1",300,null,{"$f":"1*B137/1000","v":0.3},{"$nulls":11},1,0.3]
[]
["3 st Templinor till rundsilos A2-A4",900,null,{"$f":"3*B139/1000","v":2.7},{"$nulls":11},1,2.7]
[]
["5 st Templinor till rundsilos B2-B6",1500,null,{"$f":"5*B141/1000","v":7.5},{"$nulls":11},1,7.5]
[null,null,null,{"$f":"SUM(D133:D141)","v":21.3},{"$nulls":12},{"$f":"SUM(Q133:Q141)","v":21.3}]
["Övergångar (Planevo)"]
["Benämning","Vikt Övergångar mm",null,"Vikt [ton]",null,"Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]"]
[]
["Diverse Övergångar mm.",1500,null,{"$f":"F146*B146/1000","v":1.5},null,1,{"$f":"D146*F146","v":1.5}]
[]
[]
["Elkabel"]
["Tillverkare","Material","Enhet","Mängd [m]","Källa, mängd","A1 - A5","Tot CO2 [ton]","A1 eller A1-A3","A2","A3","A4","A5","Länk EPD/källa"]
["Prysmian","eqlq 3g1,5","m",33000,"kg CO2e/m",{"$f":"SUM(H151:L151)","v":0.47599999999999998},{"$f":"F151*D151/1000","v":15.708},0.34399999999999997,4.3299999999999998E-2,5.1200000000000002E-2,{"$f":"0.0248","v":2.4799999999999999E-2},1.2699999999999999E-2,"https://www.epd-norge.no/getfile.php/1347961-1699876449/EPDer/Byggevarer/NEPD-5374-4678_ACEFLEX-ECO-CABLE-PURE-3G1-5mm-%281%29.pdf"]
["Prysmian","eqlq 4g1,5","m",20000,"kg CO2e/m",{"$f":"SUM(H152:L152)","v":0.63466666666666671},{"$f":"F152*D152/1000","v":12.693333333333333},{"$f":"H151*4/3","v":0.45866666666666661},{"$f":"I151*4/3","v":5.7733333333333331E-2},6.826666666666667E-2,3.3066666666666668E-2,1.6933333333333331E-2,"Baserad på 3x1,5 mm2, multiplicerat med 4/3"]
["Prysmian","eqlq 5g1,5","m",500,"kg CO2e/m",0.65159999999999996,{"$f":"F153*D153/1000","v":0.32579999999999998},0.49199999999999999,5.7200000000000001E-2,6.9800000000000001E-2,1.5599999999999999E-2,1.7000000000000001E-2,"https://www.epd-norge.no/epder/bygg/elektroniske-og-elektriske-komponenter-kabler-produkter/aceflex-eco-cable-pure-5g1-5mm"]
["Prysmian","eqlq 4g2,5","m",500,"kg CO2e/m",1.9132,{"$f":"F154*D154/1000","v":0.95660000000000001},1.66,3.04E-2,0.129,5.0099999999999999E-2,4.3700000000000003E-2,"https://www.epd-norge.no/getfile.php/1341426-1688982804/EPDer/Byggevarer/NEPD-4645-3927_LAPP--LFLEX--CLASSIC-110-CY-4G2-5mm--Elnr-1090681.pdf"]
["Prysmian","eqlq 5g2,5","m",700,"kg CO2e/m",0.92119999999999991,0.64483999999999997,0.68799999999999994,7.3099999999999998E-2,9.2299999999999993E-2,4.4699999999999997E-2,2.3099999999999999E-2,"https://www.epd-norge.no/getfile.php/1347950-1699876021/EPDer/Byggevarer/NEPD-5373-4680_ACEFLEX-ECO-CABLE-PURE-5G2-5mm--.pdf"]
["Prysmian","EXQJ Pure 3x6/6","m",3500,"kg CO2e/m",1.9059000000000001,6.6706500000000002,1.61,9.74E-2,7.7899999999999997E-2,1.7600000000000001E-2,0.10299999999999999,"https://www.epd-norge.no/getfile.php/1348541-1701443402/EPDer/Byggevarer/NEPD-5467-4780_AFUX-HF-C-PRo-500V-3x6-S-K6M-400.pdf"]
["Prysmian","FXQJ-EMC Pure 3x16 fr/16","m",3500,"kg CO2e/m",{"$f":"SUM(H157:L157)*875/285","v":3.0953508771929821},10.833728070175438,0.68200000000000005,null,null,1.6199999999999999E-2,0.31,"https://www.e-nummersok.se/infoDocs/EPD/EPD_18020_0009170.pdf"]
["Prysmian","AXQJ-EMC Pure 4x95/35","m",800,"kg CO2e/m",{"$f":"SUM(H158:L158)","v":22.841999999999995},18.273599999999995,21.3,0.36199999999999999,0.51400000000000001,0.20499999999999999,0.46100000000000002,"https://www.epd-norge.no/getfile.php/1356013-1709899023/EPDer/Byggevarer/NEPD-6248-5514_SE-N1XZ1-AS-4G95mm-.pdf"]
["Prysmian","FXQJ-EMC Pure 3x25 fr/16","m",1000,"kg CO2e/m",{"$f":"SUM(H159:L159)","v":1.5753125000000001},1.5753125000000003,{"$f":"H157*25/16","v":1.065625},null,null,{"$f":"K157*25/16","v":2.5312499999999998E-2},0.484375,"Baserad på FXQJ-EMC Pure 3x16 fr/16"]
["Prysmian","AXQJ-EMC Pure 3x95/35","m",1000,"kg CO2e/m",{"$f":"SUM(H160:L160)","v":22.955000000000002},22.955000000000005,21.6,0.315,0.30099999999999999,0.23899999999999999,0.5,"https://www.epd-norge.no/getfile.php/1351617-1704881598/EPDer/Byggevarer/NEPD-5757-5041_AXALJ-TT-Eco-Cable-3x95-35-ALCL-24kV.pdf"]
["Prysmian","EQLR 14x1,5 750V ljgrå","m",1000,"kg CO2e/m",{"$f":"SUM(H161:M161)","v":1.2807900000000001},1.2807900000000001,{"$f":"H163*7","v":1.0780000000000001},{"$f":"I163*7","v":6.0760000000000002E-2},9.6599999999999991E-2,4.5429999999999998E-2,null,"Baserad på FQAR-PG 2x2x1"]
["Prysmian","FQAR-G Pure 4x1","m",2000,"kg CO2e/m",{"$f":"SUM(H162:M162)","v":0.36593999999999999},0.73187999999999998,{"$f":"H163*2","v":0.308},{"$f":"I163*2","v":1.736E-2},2.76E-2,1.298E-2,null,"Baserad på FQAR-PG 2x2x1"]
["Prysmian","FQAR-PG 2x2x1","m",5000,"kg CO2e/m",{"$f":"SUM(H163:M163)","v":0.18296999999999999},0.91485000000000005,0.154,8.6800000000000002E-3,1.38E-2,6.4900000000000001E-3,null,"https://www.epd-norge.no/getfile.php/1340543-1689245571/EPDer/Byggevarer/NEPD-4562-3817_TwinLed-light-750V-2x1-5mm2-FR-.pdf"]
["Templina","Templina - ","ton",{"$f":"D142","v":21.3},"kg CO2e/ton",{"$f":"SUM(H164:M164)","v":4068.3760683760684},86.656410256410268,{"$f":"H151/0.000117","v":2940.17094017094},{"$f":"I151/0.000117","v":370.08547008547009},437.60683760683764,211.96581196581195,108.54700854700855,"Baserad på 3x1,5mm2, 0,117kg/m, 0,000117 ton/m"]
[]
[{"$nulls":5},"Summa",{"$f":"SUM(G151:G164)","v":180.22079415991905}]
[]
[]
[]
["Resurssammanställning"]
["Databas","Material","Enhet","Mängd [ton,m]","Källa, mängd","A1 - A3","Tot CO2 [ton]","A1-A3","A2","A3","A4","A5","Länk EPD/källa"]
["Boverket","Galvade stålprodukter","kg CO2e/kg",{"$f":"G39+G48/1000+G63+G85/1000+G146","v":64.445300000000003},"Tornum möte",{"$f":"SUM(H172:J172)+L172","v":3330},{"$f":"(F172*D172/1000)","v":214.60284900000002},3330]
["Boverket","Stål (primär råvara)","kg CO2e/kg",{"$f":"I91/1000+I128/1000+I85/1000+I56/1000+I63/1000+(I95+I96+I97)/1000+I101+I104/1000+I109+I190","v":95.274599999999978},"Tornum möte",2.52,{"$f":"F173*D173","v":240.09199199999995},2.52]
["Boverket","Rostfria vattenrör","kg CO2e/kg",{"$f":"K91/1000","v":6.0000000000000001E-3},"Tornum möte",{"$f":"SUM(H174:M174)","v":4.5},{"$f":"D174*F174","v":2.7E-2},4.5]
["Boverket","Aluminium (primär råvara)","kg CO2e/kg",{"$f":"R91/1000","v":0.05},"Tornum möte",10,{"$f":"F175*D175/1000","v":5.0000000000000001E-4},10]
["Oekubau","Gummi/plast","kg CO2e/kg",{"$f":"M48/1000+I39+M56/1000+M63/1000+M85/1000+M98/1000+M91/1000+M101/1000+M104/1000+M128/1000+O91/1000+M190","v":9.9579599999999999},"Tornum möte",{"$f":"SUM(H176:M176)","v":3.64},{"$f":"F176*D176","v":36.246974399999999},3.64,{"$nulls":4},"https://oekobaudat.de/OEKOBAU.DAT/datasetdetail/process.xhtml?uuid=eee26d67-c05d-4c1c-8502-0e42c91f37fc&version=20.23.050&stock=OBD_2023_I&lang=en"]
["CO2 data FI","Elektronik (elcentral)","kg CO2e/kg",{"$f":"K39+Q48/1000+Q56/1000+Q63+Q85/1000+Q91/1000+Q98/1000+Q101/1000+Q104/1000+Q109/1000+Q142/1000+Q116/1000+Q128/1000+Q190/1000","v":12.824749999999996},"Tornum möte",{"$f":"2.78","v":2.78},{"$f":"F177*D177","v":35.652804999999987},2.78,null,null,"-",null,"https://co2data.fi/rakentaminen/#sv_id7000000569"]
["Prysmian","Elkabel","kg CO2e/m",{"$f":"SUM(D151:D163)+D164/0.000117","v":254551.28205128206},"Tornum möte","Varierande",{"$f":"G166","v":180.22079415991905},{"$nulls":5},"https://www.epd-norge.no/epder/bygg/elektroniske-og-elektriske-komponenter-kabler-produkter/aceflex-eco-cable-pure-5g1-5mm"]
[{"$nulls":6},{"$f":"SUM(G172:G178)","v":706.842914559919}]
[]
[]
["Torkar & Fördelare"]
["Benämning","Vikt Torkar",null,null,"Vikt [ton]","Viktandel galvat stål","Vikt galvat stål [ton]","Viktandel stål","Vikt stål [ton]","Viktandel RF-stål ","Vikt RF-stål [ton]","Viktandel gummi ","Vikt gummi [ton]","Viktandel plast [ton]","Vikt plast [ton]","Viktandel elektronik ","Vikt elektronik [kg]","Viktandel stenull","Vikt stenull"]
[]
["1 st Spannmålstork REX-6-20-4",35000,null,null,{"$f":"B185/1000","v":35},{"$f":"0.9","v":0.9},{"$f":"F185*E185","v":31.5},{"$nulls":8},0.1,{"$f":"P185*E185","v":3.5}]
["1 st Spannmålstork REX-6-20-4",35000,null,null,{"$f":"B186/1000","v":35},{"$f":"0.9","v":0.9},{"$f":"F186*E186","v":31.5},{"$nulls":8},0.1,{"$f":"P186*E186","v":3.5}]
["Isoleringskassetter 2 st",4000,null,null,{"$f":"B187/1000*2","v":8},0.1,{"$f":"F187*E187","v":0.8},{"$nulls":10},0.9,{"$f":"R187*E187","v":7.2}]
["2 st Stoftavskiljare CDS-75",2000,null,null,{"$f":"B188/1000","v":2},null,null,0.95,{"$f":"H188*E188","v":1.9},null,null,{"$f":"0.05","v":0.05},{"$f":"L188*E188","v":0.1}]
["2 st Stoftavskiljare CDS-75",2000,null,null,{"$f":"B189/1000","v":2},null,null,0.95,{"$f":"H189*E189","v":1.9},null,null,{"$f":"0.05","v":0.05},{"$f":"L189*E189","v":0.1}]
[{"$nulls":6},{"$f":"SUM(G185:G189)","v":63.8},null,{"$f":"SUM(I188:I189)","v":3.8},null,null,null,{"$f":"SUM(M188:M189)","v":0.2},null,null,null,{"$f":"SUM(Q185:Q186)","v":7}]
[]
["Databas","Produkt",null,"Mängd [ton]","Källa mängd","A1 - A5","Tot CO2 [ton]","A1 eller A1-A3","A2","A3","A4","A5"]
["Boverket","Galvade ståprodukter","ton/ton ",{"$f":"G190","v":63.8},"Tornum",{"$f":"SUM(H193:K193)","v":3.33},{"$f":"F193*D193","v":212.45400000000001},{"$f":"'Material & Processer'!H9/1000","v":3.33},"-","-","-","-"]
["Boverket","Isolering (stenull)","ton/ton ",{"$f":"S187","v":7.2},"Tornum",{"$f":"SUM(H194:K194)","v":1.6},{"$f":"D194*F194","v":11.520000000000001},1.6,"-","-","-","-","Boverket"]
["CO2 data FI","Elektronik ","ton/ton ",{"$f":"Q185+Q186","v":7},"Tornum",{"$f":"SUM(H195:L195)","v":2.78},{"$f":"F195*H195","v":7.7283999999999988},{"$f":"2.78","v":2.78},"-","-","-","-","https://co2data.fi/rakentaminen/#sv_id7000000569"]
[{"$nulls":6},{"$f":"SUM(G193:G195)","v":231.70240000000001}]
[]
[{"$nulls":4},"Summa",null,{"$f":"SUM(G193:G195)","v":231.70240000000001}]