{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vejledning","Definitioner","Branchekoder","Basisoplysninger","Nuværende energiforbrug","Besparelsesprojekter","Hjælpedata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Vejledning","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,2,9,5],[12,2,14,5],[17,2,20,5],[23,2,25,5]]}
[]
[]
[null,null,"Vejledning  til energisyn"]
[null,null,"Retningslinjer for korrekt indberetning"]
[]
[null,null,"Generelt for alle faner"]
[null,null,"Det er vigtigt at alle felter udfyldes, og at nye celler og ikke-anmodede oplysninger ikke indføres. \n- De felter, der kan udfyldes, er markeret med grøn \n- Visse celler udfyldes automatisk. Dette er oftest vist ved at cellen indeholder en bindestreg."]
[]
[]
[]
[]
[null,null,"Basisoplysninger"]
[null,null,"Her indføres oplysninger om virksomheden og energisynskonsulent. \n - Angiv den dato, energisynet er udført \n"]
[]
[]
[]
[null,null,"Nuværende energiforbrug"]
[null,null,"Her oplyses energiforbruget for det indeværende år. \n- Udfyld ét skema pr. P-nummer. Husk at angive p-nummer i skemaet\n- Hvis virksomhederne har flere end 5 enheder/P-numre, skal det samlede energiforbrug angives.\n- Brug de listede omregningsfaktorer  \n"]
[]
[]
[]
[]
[null,null,"Potentielle besparelser og gennemførte besparelser "]
[null,null,"I denne fane, gives der et overblik over virksomhedens projekter. \n - Vær opmærksom på, at energi skal opgives i MWh. \n "]
[]
[]
[]
[null,null,"Der kan løbende komme justeringer til indberetningskemaet, brugere opfordres til altid at hente skemaet på www.ens.dk"]
[]
[null,null,"Har du spørgsmål til udfyldelse af blanketten, er du velkommen til at kontakte Energistyrelsen på energisyn@ens.dk eller på tlf. +45 33926688."]

{"sheet":"Definitioner","index":1,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Definitioner "]
[]
[null,"Olieprodukter"]
[null,"LPG","Liquefied Petroleum Gas (flydende gas, flaskegas). Betegnelsen for propan, butan og blandinger heraf. Anvendes i industri samt til opvarmning, madlavning og som drivmiddel. "]
[null,"Motorbenzin"]
[null,"Diesel","Omfatter også petroleum"]
[null,"Fyringsolie"]
[null,"Fuelolie","Omfatter også spildolie"]
[null,"Petroleums-koks","Et fast olieprodukt, som fremkommer ved raffinering af fuelolie i en såkaldt coker. Omkring 10% af materialet afsætter sig i cokeren som petroleumskoks. "]
[null,"Gas"]
[null,"Naturgas mv."]
[null,"Kul og Koks"]
[null,"Kul og Koks","Kul og koks slås sammen"]
[null,"Affald"]
[null,"Affald, ikke-bionedbrydeligt"]
[null,"Vedvarende energi"]
[null,"Affald, bionedbrydeligt"]
[null,"Halm"]
[null,"Skovflis"]
[null,"Træpiller"]
[null,"Træaffald og brænde"]
[null,"Biogas"]
[null,"Bioolie"]
[null,"Varmepumper – overskudsvarme","Udnyttelse af overskudsvarme i varmepumper."]
[null,"Varmepumper - omgivelsesvarme","Energimængden produceret af varmepumper beregnes som forskellen mellem den mængde energi, som varmepumpen leverer og varmepumpens elforbrug."]
[null,"Solvarme "]
[null,"Konverterede energiarter "]
[null,"El"]
[null,"Fjernvarme"]
[]
[null,"Intern energiforsyning"]
[null,"Konverterings- og nettab","Forskellen på det samlede input og output i konverteringsprocessen."]
[null,"Procesvarme"]
[null,"Opvarmning/kogning","Inklusiv pasteurisering, blanchering, ekstraktion, sterilisering, rengøringsvand til produktionsanlæg, vask af råvarer, varmeholdelse af tanke og rør. "]
[null,"Tørring","Inklusiv bagning og tørring af/hærdning af lak"]
[null,"Inddampning"]
[null,"Destillation","Inklusiv deorisering"]
[null,"Brænding/Sintring"]
[null,"Smeltning/støbning","Inklusiv varmeholdelse af smeltede materialer, plaststøbemaskiner, og varmelegemer i ekstrudere"]
[null,"Anden procesvarme","Inklusiv hærdning af stål, hærdning af betonelementer, afspændingsovne, svideovne"]
[null,"Transport"]
[null,"Arbejdskørsel, intern transport"]
[null,"Vejtransport (offentlig vej)","Al transportaktivitet bortset fra intern transport på virksomhedsarealer."]
[null,"Rumvarme mv. "]
[null,"Rumvarme","Inklusiv varmt vand til lokalrengøring og komfortformål, men eksklusiv rumvarme i særlige rum med driftstemperaturer på mindst 45 grader samt i rum til lagring af oste, spegepølser mm. "]
[null,"Rumkøling","For rumkøling menes komfortkøling hvor der betales speciel afgift. "]
[null,"Sekundær energi"]
[null,"Belysning"]
[null,"Pumpning "]
[null,"Køl/frys (eksklusiv rumkøling)"]
[null,"Rumventilation"]
[null,"Blæsere"]
[null,"Trykluft"]
[null,"Hydraulik"]
[null,"Øvrige elmotorer","Inklusiv centrifugering, presning og intern eldrevet transport"]
[null,"IT og anden elektronik"]
[null,"Anden elanvendelse","Inklusiv svejsning og elektrolyse"]

{"sheet":"Branchekoder","index":2,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Branchekode","Tilhørende bogstavskode "]
[null,"1 til 3","A - Landbrug, jagt, skovbrug og fiskeri"]
[null,"5 til 9","B - Råstofindvinding"]
[null,"10 til 33","C - Fremstillingsvirksomhed"]
[null,35,"D - El-, gas- og fjernvarmeforsyning"]
[null,"36 til 39","E - Vandforsyning; kloakvæsen, affaldshåndtering og rensning af jord og grundvand"]
[null,"41 til 43 ","F - Bygge- og anlægsvirksomhed"]
[null,"45 til 47","G - Engroshandel og detailhandel, reparation af motorkøretøjer og motorcykler"]
[null,"49 til 53 ","H - Transport og godshåndtering"]
[null,"55 til 56 ","I - Overnatningsfaciliteter og restaurationsvirksomhed"]
[null,"58 til 63 ","J - Information og kommunikation - 580000 - 639900"]
[null,"64 til 66 ","K - Pengeinstitut- og finansvirksomhed, forsikring - 640000 - 663000"]
[null,68,"L - Fast ejendom"]
[null,"69 til 75","M - Liberale, videnskabelige og tekniske tjenesteydelser - 690000 - 750000"]
[null,"77 til 82 ","N - Administrative tjenesteydelser og hjælpetjenester - 750000 - 829900"]
[null,84,"O - Offentlig forvaltning og forsvar; socialsikring"]
[null,85,"P - Undervisning"]
[null,"86 til 88","Q - Sundhedsvæsen og sociale foranstaltninger"]
[null,"90 til 93 ","R - Kultur, forlystelser og sport - 900000 - 932990"]
[null,"94 til 96","S - Andre serviceydelser"]
[null,"97 til 98","T - Private husholdninger med ansat medhjælp; husholdnin-gers produktion af varer og tjenesteydelser til eget brug, i.a.n."]
[null,99,"U - Ekstraterritoriale organisationer og organer"]

{"sheet":"Basisoplysninger","index":3,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,7,2,8],[4,7,4,8]]}
[null,"Stamdata"]
[null,"CVR",null,"Branchekode",null,"Region",null,"Energisynskonsulent",null,null,"Kontaktperson i virksomheden",null,"Dato for udførelse (DD-MM-ÅÅÅÅ)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","Energiforbrug [MWh]"]
[null,"Tilknyttede CVR",null,"Branchekode",null,"Region",null,"E-mail",null,null,"E-mail",null,null,null,"Fuldt energiforbrug "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indberettet energiforbrug"]
[]
[null,null,null,null,null,null,null,null,"Godkendt i Registreringsordningen"]
[null,null,null,null,null,null,null,null,"Energikonsulent, flerfamiliehuse"]
[null,null,null,null,null,null,null,null,"Akkrediteret af DANAK mv."]
[null,null,null,null,null,null,null,null,"Godkendt som intern konsulent"]
[null,null,null,null,null,null,null,null,"Godkendt udenlandsk konsulent"]
[null,null,null,null,null,null,null,null,"(sæt kryds)"]

{"sheet":"Nuværende energiforbrug","index":4,"n_rows":36,"n_cols":31,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,22,6,24],[6,25,6,27],[6,3,6,8],[6,12,6,21],[16,0,17,0],[16,25,29,27],[9,0,15,0],[20,0,29,0],[18,0,19,0]]}
[]
["Energiforbrug"]
["Totalt energiforbrug de seneste 12 måneder"]
[null,null,null,"Måleperiode for indtastet energiforbrug:"]
["Nr. P-enhed:",1,null,"Startdato: ",null,"Slutdato:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Omregningstabel til CO2 forbrug "]
["Nr. P-enhed:",1,"I alt","OLIEPRODUKTER",null,null,null,null,null,"GAS","KUL-KOKS","AFFALD","VEDVARENDE ENERGI",null,null,null,null,null,null,null,null,null,"KONVERTEREDE ENERGIARTER",null,null,"TEMPERATUR, ANDEL AF TOTAL PROCESVARMEFORBRUG",null,null,null,"Energiart","ton CO2 pr. MWh"]
["Nr. P-enhed:","<Indtast P-nummer>","MWh","LPG","Motor-benzin","Fyrings-olie","Diesel","Fuelolie","Petro-koks","Lednings-gas","Kul og koks","Affald, ikke-bionedbrydeligt","Affald, bionedbrydeligt","Halm","Skovflis","Træpiller","Træaffald og brænde","Biogas","Bioolie","Varme-pumper - intern ov","Varme-pumper omg. Varme","Solvarme","El i alt","heraf el til varme-pumper","Fjern-varme","<100oC","100-200oC",">200oC",null,"Affald, bionedbrydeligt",0.38750400000000002]
["Intern energiforsyning","Konverterings- og nettab",{"$f":"SUM(D9:Y9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affald, ikke bionedbrydeligt",0.33998400000000001]
["Procesvarme","Opvarmning/kogning ",{"$f":"SUM(D10:Y10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzin og LVN",0.26279999999999998]
[null,"Tørring ",{"$f":"SUM(D11:Y11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biodiesel",0.27972000000000002]
[null,"Inddampning ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bioethanol",0.25919999999999999]
[null,"Destillation ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biogas",0.29483999999999999]
[null,"Brænding/sintring",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bionaturgas",0.19763999999999998]
[null,"Smeltning/støbning ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bioolie",0.25488]
[null,"Anden procesvarme* ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektricitet (forbrug)",3.61E-2]
["Transport","Arbejdskørsel ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektricitet (produktion)",3.61E-2]
[null,"Vejtransport (offentlig vej)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fjernvarme (forbrug)",5.416E-2]
["Rumvarme mv.","Rumvarme ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fjernvarme (produktion)",4.3299999999999998E-2]
[null,"Rumkøling ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuelolie og Spildolie",0.28242]
["Sekundær energi","Belysning",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas & Dieselolie",0.26676]
[null,"Pumpning",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halm",0.36]
[null,"Køl/frys (ekskl. rumkøling)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JP1 og JP4",0.25919999999999999]
[null,"Rumventilation",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kul & Koks",0.33944400000000002]
[null,"Blæsere",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ledningsgas",0.12337200000000001]
[null,"Trykluft",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LPG",0.23327999999999999]
[null,"Hydraulik",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Naturgas",0.20393999999999998]
[null,"Øvrige elmotorer",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petrokoks",0.33479999999999999]
[null,"It og anden elektronik",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petroleum",0.25884000000000001]
[null,"Anden elanvendelse*",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raffinaderigas",0.204012]
["Produktion","Produktion af el",{"$f":"SUM(D31:Y31)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Træ Øvrig",0.37224000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Træflis",0.37224000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Træpiller",0.35064000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vægtede CO2 emissionsfaktorer KF23 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KF23 national energibalance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El-emissionsfaktor"]

{"sheet":"Besparelsesprojekter","index":5,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,7,3,11],[3,2,3,6],[24,2,24,6],[24,7,24,11],[22,1,22,4],[23,1,23,4]]}
[null,"Mulige projekter"]
[null,"Indskriv kun de 15 mest rentable besparelsesprojekter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Udregnes automatisk"]
[null,null,"Projektinformation",null,null,null,null,"Besparelse/år",null,null,null,null,null,"Tilbage- betalingstid","Besparelse i levetiden","Reduktion"]
[null,null,"Betegnelse","Anvendelsesområde","Underområde","Levetid [år]","Invest. [kr]","Energiart","Besparelse af energiart \n[MWh]","Besparelse [kr]","Forhøjet el-forbrug [MWh]","Øvrige driftsbesparelser [kr]",null,"År","DKK (1000 kr)","TCO2e/år "]
[null,1,"[Fritekst]",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G6=\"\",J6=\"\"),\"-\",G6/(J6+L6))","v":"-"},{"$f":"IF(OR(F6=\"\",J6=\"\"),\"-\",F6*(J6+L6)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(I6=\"\",H6=\"\"),\"-\",I6*VLOOKUP(H6,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,{"$f":"B6+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G7=\"\",J7=\"\"),\"-\",G7/(J7+L7))","v":"-"},{"$f":"IF(OR(F7=\"\",J7=\"\"),\"-\",F7*(J7+L7)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(I7=\"\",H7=\"\"),\"-\",I7*VLOOKUP(H7,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,{"$f":"B7+1","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G8=\"\",J8=\"\"),\"-\",G8/(J8+L8))","v":"-"},"-",{"$f":"IFERROR(IF(OR(I8=\"\",H8=\"\"),\"-\",I8*VLOOKUP(H8,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I9=\"\",H9=\"\"),\"-\",I9*VLOOKUP(H9,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,5,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I10=\"\",H10=\"\"),\"-\",I10*VLOOKUP(H10,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,6,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I11=\"\",H11=\"\"),\"-\",I11*VLOOKUP(H11,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,7,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I12=\"\",H12=\"\"),\"-\",I12*VLOOKUP(H12,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,8,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I13=\"\",H13=\"\"),\"-\",I13*VLOOKUP(H13,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,9,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I14=\"\",H14=\"\"),\"-\",I14*VLOOKUP(H14,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,10,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I15=\"\",H15=\"\"),\"-\",I15*VLOOKUP(H15,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,11,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I16=\"\",H16=\"\"),\"-\",I16*VLOOKUP(H16,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,12,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I17=\"\",H17=\"\"),\"-\",I17*VLOOKUP(H17,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,13,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I18=\"\",H18=\"\"),\"-\",I18*VLOOKUP(H18,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,14,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I19=\"\",H19=\"\"),\"-\",I19*VLOOKUP(H19,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[null,15,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I20=\"\",H20=\"\"),\"-\",I20*VLOOKUP(H20,Hjælpedata!$P$3:$Q$27,2)),\"-\")","v":"-"}]
[]
[]
[null,"Gennemførte projekter siden sidste energisyn"]
[]
[null,null,"Projektinformation",null,null,null,null,"Besparelse/år",null,null,null,null,null,"Tilbage- betalingstid","Besparelse i levetiden","Reduktion"]
[null,null,"Betegnelse","Anvendelsesområde","Underområde","Levetid [år]","Invest. [kr]","Energiart","Besparelse af energiart \n[MWh]","Besparelse [kr]",null,"Øvrige driftsbesparelser [kr]",null,"År","DKK (1000 kr)","TCO2e/år "]
[null,1,"[Fritekst]",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G27=\"\",J27=\"\"),\"-\",G27/(J27+L27))","v":"-"},{"$f":"IF(OR(F27=\"\",J27=\"\"),\"-\",F27*(J27+L27)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(I27=\"\",H27=\"\"),\"-\",I27*VLOOKUP(H27,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,{"$f":"B27+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G28=\"\",J28=\"\"),\"-\",G28/(J28+L28))","v":"-"},{"$f":"IF(OR(F28=\"\",J28=\"\"),\"-\",F28*(J28+L28)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(I28=\"\",H28=\"\"),\"-\",I28*VLOOKUP(H28,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,{"$f":"B28+1","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G29=\"\",J29=\"\"),\"-\",G29/(J29+L29))","v":"-"},"-",{"$f":"IFERROR(IF(OR(I29=\"\",H29=\"\"),\"-\",I29*VLOOKUP(H29,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(F30=\"\",J30=\"\"),\"-\",F30*(J30+L30)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(I30=\"\",H30=\"\"),\"-\",I30*VLOOKUP(H30,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,5,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I31=\"\",H31=\"\"),\"-\",I31*VLOOKUP(H31,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,6,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I32=\"\",H32=\"\"),\"-\",I32*VLOOKUP(H32,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,7,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I33=\"\",H33=\"\"),\"-\",I33*VLOOKUP(H33,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,8,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I34=\"\",H34=\"\"),\"-\",I34*VLOOKUP(H34,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,9,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I35=\"\",H35=\"\"),\"-\",I35*VLOOKUP(H35,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,10,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I36=\"\",H36=\"\"),\"-\",I36*VLOOKUP(H36,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,11,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I37=\"\",H37=\"\"),\"-\",I37*VLOOKUP(H37,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,12,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I38=\"\",H38=\"\"),\"-\",I38*VLOOKUP(H38,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,13,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I39=\"\",H39=\"\"),\"-\",I39*VLOOKUP(H39,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,14,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I40=\"\",H40=\"\"),\"-\",I40*VLOOKUP(H40,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]
[null,15,null,null,null,null,null,null,null,null,null,null,null,"-","-",{"$f":"IFERROR(IF(OR(I41=\"\",H41=\"\"),\"-\",I41*VLOOKUP(H41,Hjælpedata!$P$3:$Q$27,2)*0.001),\"-\")","v":"-"}]

{"sheet":"Hjælpedata","index":6,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":true,"merged":[[16,2,16,7],[1,2,1,6],[0,15,0,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Omregningsfaktorer"]
["Anvendelseområder",null,"Underområder",null,null,null,null,null,null,null,null,null,null,null,null,"Energiart","ton CO2 pr. MWh","Column1",null,"Uledning TJ"]
["Anvendelsesområde",null,"Intern energiforsyning","Procesvarme","Transport","Rumvarme","Sekundær energi",null,null,"Omregningsfaktorer",null,"Region","Branchekoder","VBA til P-enhed",null,"Affald, bionedbrydeligt",0.38750400000000002,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":107.63999698607999},null,"Column1","TJ/MWh","Column3"]
["Intern energiforsyning",null,"Konverterings- og nettab","Opvarmning/kogning ","Arbejdskørsel ","Rumvarme ","Belysning",null,null,"Affald, bionedbrydeligt ",null,"Nordjylland","A - Landbrug, jagt, skovbrug og fiskeri",1,null,"Affald, ikke bionedbrydeligt",0.33998400000000001,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":94.439997355679992},null,"Affald, bionedbrydeligt [CO2 ton/TJ]",107.64,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.38750400000000002}]
["Procesvarme",null,null,"Tørring ","Vejtransport (offentlig vej)","Rumkøling ","Pumpning",null,null,"Affald, ikke bionedbrydeligt ",null,"Midjylland","B - Råstofindvinding",2,null,"Benzin og LVN",0.26279999999999998,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":72.999997955999987},null,"Affald, ikke bionedbrydeligt [CO2 ton/TJ]",94.44,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.33998400000000001}]
["Transport",null,null,"Inddampning ",null,null,"Køl/frys (ekskl. rumkøling)",null,null,"Benzin og LVN ",null,"Syddanmark","C - Fremstillingsvirksomhed",3,null,"Biodiesel",0.27972000000000002,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":77.6999978244},null,"Benzin og LVN [CO2 ton/TJ]",73,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.26279999999999998}]
["Rumvarme",null,null,"Destillation ",null,null,"Rumventilation",null,null,"Biodiesel",null,"Sjælland","D - El-, gas- og fjernvarmeforsyning",4,null,"Bioethanol",0.25919999999999999,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":71.99999798399999},null,"Biodiesel [CO2 ton/TJ] {1}",77.7,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.27972000000000002}]
["Sekundær energi",null,null,"Brænding/sintring",null,null,"Blæsere",null,null,"Bioethanol",null,"Hovedstaden","E - Vandforsyning; kloakvæsen, affaldshåndtering og rensning af jord og grundvand",5,null,"Biogas",0.29483999999999999,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":81.899997706799994},null,"Bioethanol [CO2 ton/TJ]",72,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.25919999999999999}]
[null,null,null,"Smeltning/støbning ",null,null,"Trykluft",null,null,"Biogas",null,null,"F - Bygge- og anlægsvirksomhed",">5",null,"Bionaturgas",0.19763999999999998,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":54.899998462799992},null,"Biogas [CO2 ton/TJ]",81.900000000000006,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.29483999999999999}]
[null,null,null,"Anden procesvarme* ",null,null,"Hydraulik",null,null,"Bionaturgas",null,null,"G - Engroshandel og detailhandel, reparation af motorkøretøjer og motorcykler",null,null,"Bioolie",0.25488,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":70.799998017599989},null,"Bionaturgas [CO2 ton/TJ]",54.9,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.19763999999999998}]
[null,null,null,null,null,null,"Øvrige elmotorer",null,null,"Bioolie",null,null,"H - Transport og godshåndtering",null,null,"Elektricitet (forbrug)",3.61E-2,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*1000","v":36.1},null,"Bioolie [CO2 ton/TJ]",70.8,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.25488}]
[null,null,null,null,null,null,"It og anden elektronik",null,null,"Elektricitet (forbrug)",null,null,"I - Overnatningsfaciliteter og restaurationsvirksomhed",null,null,"Elektricitet (produktion)",3.61E-2,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*1000","v":36.1},null,"Fuelolie og Spildolie [CO2 ton/TJ]",78.42,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.28231200000000001}]
[null,null,null,null,null,null,"Anden elanvendelse*",null,null,"Elektricitet (produktion)",null,null,"J - Information og kommunikation - 580000 - 639900",null,null,"Fjernvarme (forbrug)",{"$f":"54.16/1000","v":5.416E-2},{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*1000","v":54.16},null,"Gas & Dieselolie [CO2 ton/TJ]",74.099999999999994,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.26676}]
[null,null,null,null,null,null,null,null,null,"Fjernvarme (forbrug)",null,null,"K - Pengeinstitut- og finansvirksomhed, forsikring - 640000 - 663000",null,null,"Fjernvarme (produktion)",{"$f":"43.3/1000","v":4.3299999999999998E-2},{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*1000","v":43.3},null,"Halm [CO2 ton/TJ]",100,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.36}]
[null,null,null,null,null,null,null,null,null,"Fjernvarme (produktion)",null,null,"L - Fast ejendom",null,null,"Fuelolie og Spildolie",0.2823,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":78.41666447099999},null,"JP1 og JP4 [CO2 ton/TJ]",72,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.25919999999999999}]
[null,null,null,null,null,null,null,null,null,"Fuelolie og Spildolie ",null,null,"M - Liberale, videnskabelige og tekniske tjenesteydelser - 690000 - 750000",null,null,"Gas & Dieselolie",0.26676,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":74.099997925199986},null,"Kul & Koks [CO2 ton/TJ]",94.41,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.33987599999999996}]
["Energityper",null,"Undertyper",null,null,null,null,null,null,"Gas & Dieselolie ",null,null,"N - Administrative tjenesteydelser og hjælpetjenester - 750000 - 829900",null,null,"Halm",0.36,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":99.999997199999981},null,"LPG [CO2 ton/TJ]",64.8,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.23327999999999999}]
["Energitype",null,"OLIEPRODUKTER","GAS","KUL-KOKS","AFFALD","VEDVARENDE ENERGI","KONVERTEREDE ENERGIARTER",null,"Halm",null,null,"O - Offentlig forvaltning og forsvar; socialsikring",null,null,"JP1 og JP4",0.25919999999999999,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":71.99999798399999},null,"Naturgas [CO2 ton/TJ]",56.71,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.204156}]
["Olieprodukter",null,"LPG","Lednings-gas","Kul og koks","Affald, ikke-bionedbrydeligt","Affald, bionedbrydeligt","El i alt",null,"JP1 og JP4 ",null,null,"P - Undervisning",null,null,"Kul & Koks",0.33987600000000001,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":94.409997356519995},null,"Petrokoks [CO2 ton/TJ]",93,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.33479999999999999}]
["Gas",null,"Motor-benzin",null,null,null,"Halm","heraf el til VP",null,"Kul & Koks ",null,null,"Q - Sundhedsvæsen og sociale foranstaltninger",null,null,"Ledningsgas",{"$f":"34.27*0.0036","v":0.12337200000000001},{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":34.269999040439998},null,"Petroleum [CO2 ton/TJ]",71.900000000000006,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.25884000000000001}]
["Kul Koks",null,"Fyrings-olie",null,null,null,"Skovflis","Fjern-varme",null,"Ledningsgas",null,null,"R - Kultur, forlystelser og sport - 900000 - 932990",null,null,"LPG",0.23327999999999999,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":64.799998185599989},null,"Raffinaderigas [CO2 ton/TJ]",56.67,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.204012}]
["Affald",null,"Diesel",null,null,null,"Træpiller",null,null,"LPG",null,null,"S - Andre serviceydelser",null,null,"Naturgas",0.204156,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":56.709998412119994},null,"Træ Øvrig [CO2 ton/TJ]",103.4,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.37224000000000002}]
["Vedvarende energi",null,"Fuelolie",null,null,null,"Træaffald og brænde",null,null,"Naturgas",null,null,"T - Private husholdninger med ansat medhjælp; husholdnin-gers produktion af varer og tjenesteydelser til eget brug, i.a.n.",null,null,"Petrokoks",0.33479999999999999,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":92.999997395999983},null,"Træflis [CO2 ton/TJ]",103.4,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.37224000000000002}]
["Konverterede energiarter",null,"Petro-koks",null,null,null,"Biogas",null,null,"Petrokoks",null,null,"U - Ekstraterritoriale organisationer og organer",null,null,"Petroleum",0.25884000000000001,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":71.899997986800003},null,"Træpiller [CO2 ton/TJ]",97.4,{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":0.35064000000000001}]
[null,null,null,null,null,null,"Bioolie",null,null,"Petroleum",null,null,null,null,null,"Raffinaderigas",0.204012,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":56.669998413239995},null,"Elektricitet",{"$f":"36.1/3.6","v":10.027777777777779},{"$f":"Table5[[#This Row],[TJ/MWh]]*0.0036","v":3.61E-2}]
[null,null,null,null,null,null,"Varme-pumper - intern ov",null,null,"Raffinaderigas",null,null,null,null,null,"Træ Øvrig",0.37224000000000002,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":103.39999710479999}]
[null,null,null,null,null,null,"Varme-pumper omg. Varme",null,null,"Træ Øvrig ",null,null,null,null,null,"Træflis",0.37224000000000002,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":103.39999710479999}]
[null,null,null,null,null,null,"Solvarme",null,null,"Træflis",null,null,null,null,null,"Træpiller",0.35064000000000001,{"$f":"Tabel2[[#This Row],[ton CO2 pr. MWh]]*277.77777","v":97.399997272799993}]
[null,null,null,null,null,null,null,null,null,"Træpiller"]