{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Vejledning","Definitioner","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":"Basisoplysninger","index":2,"n_rows":12,"n_cols":13,"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,"Tilknyttede CVR",null,"Branchekode",null,"Region",null,"E-mail",null,null,"E-mail"]
[]
[]
[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":3,"n_rows":30,"n_cols":38,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,29,6,37],[18,0,19,0],[20,0,29,0],[9,0,15,0],[16,25,29,27],[6,22,6,24],[6,25,6,27],[6,3,6,8],[6,12,6,21],[16,0,17,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:"]
[]
["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,"OMREGNINGSFAKTORER"]
["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,"Energiart","MWh pr. enhed","kg CO2 pr. MWh","Energiart","MWh pr. enhed","kg CO2 pr. MWh","Energiart","MWh pr. enhed","kg CO2 pr. MWh"]
["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 (ton)",2.94,133,"Flybenzin (ton)",12.17,263,"Stenkul i øvrigt (ton)",6.75,342]
["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 (m3)",9.1300000000000008,263,"Fuelolie (tons)",11.29,284,"Træaffald (ton)",4.08,0]
[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 (m3)",10.42,0,"Gasolie (fyringsolie, Liter)",0.01,266,"Træaffald, MWh/rummeter",0.89,0]
[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 (ton)",7.42,0,"Gasolie (fyringsolie, tons)",11.86,266,"Træpiller (ton)",4.8600000000000003,0]
[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 (1000 m3)",6.39,0,"Halm (15 % vandindhold) (ton)",4.03,0]
[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,"Biomasse tørt (7% vand)(ton)",4.8,0,"JP1 (ton)",12.08,259]
[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,"Biomasse vådt (40 % vand)(ton)",2.6,0,"JP4 (ton)",12.17,259]
[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,"Bionaturgas, MWh/1000 m3",11.01,0,"Koks (ton)",8.1,385]
["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,"Bioolie (ton)",10.33,0,"Kul (tons)",6.83,351]
[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,"Bitumen (ton)",11.06,0,"LPG (ton)",12.78,227]
["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,"Brunkulsbriketter (ton)",5.08,351,"LVN (ton)",12.36,234]
[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,"Brænde, løvtræ (m3)",2.89,0,"Methanol (ton)",5.54,196]
["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,"Brænde, nåletræ (m3)",2.11,0,"Mineralsk terpentin",12.08,0]
[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,"Bygas (1000 m3)",5.6,0,"Naturgas (1000 m3)",11,205]
[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,"Diesel (m3)",9.9600000000000009,266,"Orimulsion (ton)",7.68,288]
[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,"Elektricitet (MWh)",1,306,"Petroleum (ton)",12.1,259]
[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,"Elværkskul (ton)",6.75,342,"Petroleumskoks (ton)",8.7200000000000006,335]
[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,"Energipil (50 % vandindhold) (ton)",6.39,0,"Raffinaderigas (ton)",14.44,206]
[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,"Ethanol (m3)",6.2,243,"Skovflis (ton)",2.58,0]
[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,"Fjernvarme (m3)",0.04,90,"Smøreolie (ton)",11.64,0]
[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,"Fjernvarme (MWh)",1,90,"Spildolie (ton)",11.64,264]
[null,"Anden elanvendelse*",0]

{"sheet":"Besparelsesprojekter","index":4,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,7,3,10],[3,2,3,6],[24,2,24,6],[24,7,24,10],[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,"Udregnes automatisk"]
[null,null,"Projektinformation",null,null,null,null,"Besparelse/år",null,null,null,null,"Omregnet \nforbrug","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]","Øvrige driftsbesparelser [kr]",null,"MWh/år","År","DKK (1000 kr)","TCO2e/år "]
[null,1,"[Fritekst]",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H6=\"\",I6=\"\"),\"-\",I6*VLOOKUP(Besparelsesprojekter!H6,Hjælpedata!$P$3:$R$48,2))","v":"-"},{"$f":"IF(OR(G6=\"\",J6=\"\"),\"-\",G6/(J6+K6))","v":"-"},{"$f":"IF(OR(F6=\"\",J6=\"\"),\"-\",F6*(J6+K6)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(M6=\"\",H6=\"\"),\"-\",M6*VLOOKUP(H6,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,{"$f":"B6+1","v":2},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H7=\"\",I7=\"\"),\"-\",I7*VLOOKUP(Besparelsesprojekter!H7,Hjælpedata!$P$3:$R$48,2))","v":"-"},{"$f":"IF(OR(G7=\"\",J7=\"\"),\"-\",G7/(J7+K7))","v":"-"},{"$f":"IF(OR(F7=\"\",J7=\"\"),\"-\",F7*(J7+K7)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(M7=\"\",H7=\"\"),\"-\",M7*VLOOKUP(H7,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,{"$f":"B7+1","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I8=\"\"),\"-\",I8*VLOOKUP(Besparelsesprojekter!H8,Hjælpedata!$P$3:$R$48,2))","v":"-"},{"$f":"IF(OR(G8=\"\",J8=\"\"),\"-\",G8/(J8+K8))","v":"-"},"-",{"$f":"IFERROR(IF(OR(M8=\"\",H8=\"\"),\"-\",M8*VLOOKUP(H8,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H9=\"\",I9=\"\"),\"-\",I9*VLOOKUP(Besparelsesprojekter!H9,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M9=\"\",H9=\"\"),\"-\",M9*VLOOKUP(H9,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H10=\"\",I10=\"\"),\"-\",I10*VLOOKUP(Besparelsesprojekter!H10,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M10=\"\",H10=\"\"),\"-\",M10*VLOOKUP(H10,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,6,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H11=\"\",I11=\"\"),\"-\",I11*VLOOKUP(Besparelsesprojekter!H11,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M11=\"\",H11=\"\"),\"-\",M11*VLOOKUP(H11,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,7,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H12=\"\",I12=\"\"),\"-\",I12*VLOOKUP(Besparelsesprojekter!H12,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M12=\"\",H12=\"\"),\"-\",M12*VLOOKUP(H12,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,8,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H13=\"\",I13=\"\"),\"-\",I13*VLOOKUP(Besparelsesprojekter!H13,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M13=\"\",H13=\"\"),\"-\",M13*VLOOKUP(H13,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,9,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H14=\"\",I14=\"\"),\"-\",I14*VLOOKUP(Besparelsesprojekter!H14,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M14=\"\",H14=\"\"),\"-\",M14*VLOOKUP(H14,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,10,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H15=\"\",I15=\"\"),\"-\",I15*VLOOKUP(Besparelsesprojekter!H15,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M15=\"\",H15=\"\"),\"-\",M15*VLOOKUP(H15,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,11,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H16=\"\",I16=\"\"),\"-\",I16*VLOOKUP(Besparelsesprojekter!H16,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M16=\"\",H16=\"\"),\"-\",M16*VLOOKUP(H16,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H17=\"\",I17=\"\"),\"-\",I17*VLOOKUP(Besparelsesprojekter!H17,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M17=\"\",H17=\"\"),\"-\",M17*VLOOKUP(H17,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,13,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H18=\"\",I18=\"\"),\"-\",I18*VLOOKUP(Besparelsesprojekter!H18,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M18=\"\",H18=\"\"),\"-\",M18*VLOOKUP(H18,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,14,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H19=\"\",I19=\"\"),\"-\",I19*VLOOKUP(Besparelsesprojekter!H19,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M19=\"\",H19=\"\"),\"-\",M19*VLOOKUP(H19,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,15,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H20=\"\",I20=\"\"),\"-\",I20*VLOOKUP(Besparelsesprojekter!H20,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M20=\"\",H20=\"\"),\"-\",M20*VLOOKUP(H20,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[]
[]
[null,"Gennemførte projekter siden sidste energisyn"]
[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,"Omregnet \nforbrug","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]","Øvrige driftsbesparelser [kr]",null,"MWh/år","År","DKK (1000 kr)","TCO2e/år "]
[null,1,"[Fritekst]",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H27=\"\",I27=\"\"),\"-\",I27*VLOOKUP(Besparelsesprojekter!H27,Hjælpedata!$P$3:$R$48,2))","v":"-"},{"$f":"IF(OR(G27=\"\",J27=\"\"),\"-\",G27/(J27+K27))","v":"-"},{"$f":"IF(OR(F27=\"\",J27=\"\"),\"-\",F27*(J27+K27)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(M27=\"\",H27=\"\"),\"-\",M27*VLOOKUP(H27,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,{"$f":"B27+1","v":2},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H28=\"\",I28=\"\"),\"-\",I28*VLOOKUP(Besparelsesprojekter!H28,Hjælpedata!$P$3:$R$48,2))","v":"-"},{"$f":"IF(OR(G28=\"\",J28=\"\"),\"-\",G28/(J28+K28))","v":"-"},{"$f":"IF(OR(F28=\"\",J28=\"\"),\"-\",F28*(J28+K28)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(M28=\"\",H28=\"\"),\"-\",M28*VLOOKUP(H28,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,{"$f":"B28+1","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H29=\"\",I29=\"\"),\"-\",I29*VLOOKUP(Besparelsesprojekter!H29,Hjælpedata!$P$3:$R$48,2))","v":"-"},{"$f":"IF(OR(G29=\"\",J29=\"\"),\"-\",G29/(J29+K29))","v":"-"},"-",{"$f":"IFERROR(IF(OR(M29=\"\",H29=\"\"),\"-\",M29*VLOOKUP(H29,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H30=\"\",I30=\"\"),\"-\",I30*VLOOKUP(Besparelsesprojekter!H30,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-",{"$f":"IF(OR(F30=\"\",J30=\"\"),\"-\",F30*(J30+K30)*0.001)","v":"-"},{"$f":"IFERROR(IF(OR(M30=\"\",H30=\"\"),\"-\",M30*VLOOKUP(H30,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H31=\"\",I31=\"\"),\"-\",I31*VLOOKUP(Besparelsesprojekter!H31,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M31=\"\",H31=\"\"),\"-\",M31*VLOOKUP(H31,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,6,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H32=\"\",I32=\"\"),\"-\",I32*VLOOKUP(Besparelsesprojekter!H32,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M32=\"\",H32=\"\"),\"-\",M32*VLOOKUP(H32,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,7,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H33=\"\",I33=\"\"),\"-\",I33*VLOOKUP(Besparelsesprojekter!H33,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M33=\"\",H33=\"\"),\"-\",M33*VLOOKUP(H33,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,8,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H34=\"\",I34=\"\"),\"-\",I34*VLOOKUP(Besparelsesprojekter!H34,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M34=\"\",H34=\"\"),\"-\",M34*VLOOKUP(H34,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,9,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H35=\"\",I35=\"\"),\"-\",I35*VLOOKUP(Besparelsesprojekter!H35,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M35=\"\",H35=\"\"),\"-\",M35*VLOOKUP(H35,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,10,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H36=\"\",I36=\"\"),\"-\",I36*VLOOKUP(Besparelsesprojekter!H36,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M36=\"\",H36=\"\"),\"-\",M36*VLOOKUP(H36,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,11,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H37=\"\",I37=\"\"),\"-\",I37*VLOOKUP(Besparelsesprojekter!H37,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M37=\"\",H37=\"\"),\"-\",M37*VLOOKUP(H37,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H38=\"\",I38=\"\"),\"-\",I38*VLOOKUP(Besparelsesprojekter!H38,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M38=\"\",H38=\"\"),\"-\",M38*VLOOKUP(H38,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,13,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H39=\"\",I39=\"\"),\"-\",I39*VLOOKUP(Besparelsesprojekter!H39,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M39=\"\",H39=\"\"),\"-\",M39*VLOOKUP(H39,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,14,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H40=\"\",I40=\"\"),\"-\",I40*VLOOKUP(Besparelsesprojekter!H40,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M40=\"\",H40=\"\"),\"-\",M40*VLOOKUP(H40,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]
[null,15,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H41=\"\",I41=\"\"),\"-\",I41*VLOOKUP(Besparelsesprojekter!H41,Hjælpedata!$P$3:$R$48,2))","v":"-"},"-","-",{"$f":"IFERROR(IF(OR(M41=\"\",H41=\"\"),\"-\",M41*VLOOKUP(H41,Hjælpedata!$P$3:$R$48,3)*0.001),\"-\")","v":"-"}]

{"sheet":"Hjælpedata","index":5,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":true,"merged":[[16,2,16,7],[1,2,1,6],[0,15,0,17]]}
[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","MWh pr. enhed","kg CO2 pr. MWh"]
["Anvendelsesområde",null,"Intern energiforsyning","Procesvarme","Transport","Rumvarme","Sekundær energi",null,null,"Omregningsfaktorer",null,"Region","Branchekoder","VBA til P-enhed",null,"Affald (ton)",2.94,133]
["Intern energiforsyning",null,"Konverterings- og nettab","Opvarmning/kogning ","Arbejdskørsel ","Rumvarme ","Belysning",null,null,"Affald (ton)",null,"Nordjylland","A - Landbrug, jagt, skovbrug og fiskeri",1,null,"Benzin (m3)",9.1300000000000008,263]
["Procesvarme",null,null,"Tørring ","Vejtransport (offentlig vej)","Rumkøling ","Pumpning",null,null,"Benzin (m3)",null,"Midjylland","B - Råstofindvinding",2,null,"Biodiesel (m3)",10.42,0]
["Transport",null,null,"Inddampning ",null,null,"Køl/frys (ekskl. rumkøling)",null,null,"Bioethanol (ton)",null,"Syddanmark","C - Fremstillingsvirksomhed",3,null,"Bioethanol (ton)",7.42,0]
["Rumvarme",null,null,"Destillation ",null,null,"Rumventilation",null,null,"Biodiesel (m3)",null,"Sjælland","D - El-, gas- og fjernvarmeforsyning",4,null,"Biogas (1000 m3)",6.39,0]
["Sekundær energi",null,null,"Brænding/sintring",null,null,"Blæsere",null,null,"Biogas (1000 m3)",null,"Hovedstaden","E - Vandforsyning; kloakvæsen, affaldshåndtering og rensning af jord og grundvand",5,null,"Biomasse tørt (7% vand)(ton)",4.8,0]
[null,null,null,"Smeltning/støbning ",null,null,"Trykluft",null,null,"Biomasse tørt (7% vand)(ton)",null,null,"F - Bygge- og anlægsvirksomhed",">5",null,"Biomasse vådt (40 % vand)(ton)",2.6,0]
[null,null,null,"Anden procesvarme* ",null,null,"Hydraulik",null,null,"Biomasse vådt (40 % vand)(ton)",null,null,"G - Engroshandel og detailhandel, reparation af motorkøretøjer og motorcykler",null,null,"Bionaturgas, MWh/1000 m3",11.01,0]
[null,null,null,null,null,null,"Øvrige elmotorer",null,null,"Bioolie (ton)",null,null,"H - Transport og godshåndtering",null,null,"Bioolie (ton)",10.33,0]
[null,null,null,null,null,null,"It og anden elektronik",null,null,"Bionaturgas, MWh/1000 m3",null,null,"I - Overnatningsfaciliteter og restaurationsvirksomhed",null,null,"Bitumen (ton)",11.06,0]
[null,null,null,null,null,null,"Anden elanvendelse*",null,null,"Bitumen (ton)",null,null,"J - Information og kommunikation - 580000 - 639900",null,null,"Brunkulsbriketter (ton)",5.08,351]
[null,null,null,null,null,null,null,null,null,"Brunkulsbriketter (ton)",null,null,"K - Pengeinstitut- og finansvirksomhed, forsikring - 640000 - 663000",null,null,"Brænde, løvtræ (m3)",2.89,0]
[null,null,null,null,null,null,null,null,null,"Brænde, løvtræ (m3)",null,null,"L - Fast ejendom",null,null,"Brænde, nåletræ (m3)",2.11,0]
[null,null,null,null,null,null,null,null,null,"Brænde, nåletræ (m3)",null,null,"M - Liberale, videnskabelige og tekniske tjenesteydelser - 690000 - 750000",null,null,"Bygas (1000 m3)",5.6,0]
["Energityper",null,"Undertyper",null,null,null,null,null,null,"Bygas (1000 m3)",null,null,"N - Administrative tjenesteydelser og hjælpetjenester - 750000 - 829900",null,null,"Diesel (m3)",9.9600000000000009,266]
["Energitype",null,"OLIEPRODUKTER","GAS","KUL-KOKS","AFFALD","VEDVARENDE ENERGI","KONVERTEREDE ENERGIARTER",null,"Diesel (m3)",null,null,"O - Offentlig forvaltning og forsvar; socialsikring",null,null,"Elektricitet (MWh)",1,306]
["Olieprodukter",null,"LPG","Lednings-gas","Kul og koks","Affald, ikke-bionedbrydeligt","Affald, bionedbrydeligt","El i alt",null,"Elektricitet (MWh)",null,null,"P - Undervisning",null,null,"Elværkskul (ton)",6.75,342]
["Gas",null,"Motor-benzin",null,null,null,"Halm","heraf el til VP",null,"Elværkskul (ton)",null,null,"Q - Sundhedsvæsen og sociale foranstaltninger",null,null,"Energipil (50 % vandindhold) (ton)",6.39,0]
["Kul Koks",null,"Fyrings-olie",null,null,null,"Skovflis","Fjern-varme",null,"Energipil (50 % vandindhold) (ton)",null,null,"R - Kultur, forlystelser og sport - 900000 - 932990",null,null,"Ethanol (m3)",6.2,243]
["Affald",null,"Diesel",null,null,null,"Træpiller",null,null,"Ethanol (m3)",null,null,"S - Andre serviceydelser",null,null,"Fjernvarme (m3)",0.04,90]
["Vedvarende energi",null,"Fuelolie",null,null,null,"Træaffald og brænde",null,null,"Fjernvarme (MWh)",null,null,"T - Private husholdninger med ansat medhjælp; husholdnin-gers produktion af varer og tjenesteydelser til eget brug, i.a.n.",null,null,"Fjernvarme (MWh)",1,90]
["Konverterede energiarter",null,"Petro-koks",null,null,null,"Biogas",null,null,"Fjernvarme (m3)",null,null,"U - Ekstraterritoriale organisationer og organer",null,null,"Flybenzin (ton)",12.17,263]
[null,null,null,null,null,null,"Bioolie",null,null,"Flybenzin (ton)",null,null,null,null,null,"Fuelolie (tons)",11.29,284]
[null,null,null,null,null,null,"Varme-pumper - intern ov",null,null,"Fuelolie (tons)",null,null,null,null,null,"Gasolie (fyringsolie, Liter)",0.01,266]
[null,null,null,null,null,null,"Varme-pumper omg. Varme",null,null,"Gasolie (fyringsolie, Liter)",null,null,null,null,null,"Gasolie (fyringsolie, tons)",11.86,266]
[null,null,null,null,null,null,"Solvarme",null,null,"Gasolie (fyringsolie, tons)",null,null,null,null,null,"Halm (15 % vandindhold) (ton)",4.03,0]
[null,null,null,null,null,null,null,null,null,"Halm (15 % vandindhold) (ton)",null,null,null,null,null,"JP1 (ton)",12.08,259]
[null,null,null,null,null,null,null,null,null,"JP1 (ton)",null,null,null,null,null,"JP4 (ton)",12.17,259]
[null,null,null,null,null,null,null,null,null,"JP4 (ton)",null,null,null,null,null,"Koks (ton)",8.1,385]
[null,null,null,null,null,null,null,null,null,"Koks (ton)",null,null,null,null,null,"Kul (tons)",6.83,351]
[null,null,null,null,null,null,null,null,null,"Kul (tons)",null,null,null,null,null,"LPG (ton)",12.78,227]
[null,null,null,null,null,null,null,null,null,"LPG (ton)",null,null,null,null,null,"LVN (ton)",12.36,234]
[null,null,null,null,null,null,null,null,null,"LVN (ton)",null,null,null,null,null,"Methanol (ton)",5.54,196]
[null,null,null,null,null,null,null,null,null,"Methanol (ton)",null,null,null,null,null,"Mineralsk terpentin",12.08,0]
[null,null,null,null,null,null,null,null,null,"Mineralsk terpentin",null,null,null,null,null,"Naturgas (1000 m3)",11,205]
[null,null,null,null,null,null,null,null,null,"Naturgas (1000 m3)",null,null,null,null,null,"Orimulsion (ton)",7.68,288]
[null,null,null,null,null,null,null,null,null,"Orimulsion (ton)",null,null,null,null,null,"Petroleum (ton)",12.1,259]
[null,null,null,null,null,null,null,null,null,"Petroleum (ton)",null,null,null,null,null,"Petroleumskoks (ton)",8.7200000000000006,335]
[null,null,null,null,null,null,null,null,null,"Petroleumskoks (ton)",null,null,null,null,null,"Raffinaderigas (ton)",14.44,206]
[null,null,null,null,null,null,null,null,null,"Raffinaderigas (ton)",null,null,null,null,null,"Skovflis (ton)",2.58,0]
[null,null,null,null,null,null,null,null,null,"Skovflis (ton)",null,null,null,null,null,"Smøreolie (ton)",11.64,0]
[null,null,null,null,null,null,null,null,null,"Smøreolie (ton)",null,null,null,null,null,"Spildolie (ton)",11.64,264]
[null,null,null,null,null,null,null,null,null,"Spildolie (ton)",null,null,null,null,null,"Stenkul i øvrigt (ton)",6.75,342]
[null,null,null,null,null,null,null,null,null,"Stenkul i øvrigt (ton)",null,null,null,null,null,"Træaffald (ton)",4.08,0]
[null,null,null,null,null,null,null,null,null,"Træpiller (ton)",null,null,null,null,null,"Træaffald, MWh/rummeter",0.89,0]
[null,null,null,null,null,null,null,null,null,"Træaffald (ton)",null,null,null,null,null,"Træpiller (ton)",4.8600000000000003,0]
[null,null,null,null,null,null,null,null,null,"Træaffald, MWh/rummeter"]