{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Beregner","Bilag"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Beregner","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,2,7,4]]}
[null,"For privatkunder og ikke-timeafregnede erhvervskunder: beregn tarifbetalingen til Evida"]
[]
[null,"Indtastning",null,null,null,null,null,"Sådan gør du"]
[null,"Forventet årligt forbrug (m3):",1600,null,"Forbruget skal være mellem 0 og 500.000 m3",null,null,"Indtast din målerstørrelse. Din målerstørrelse kan findes på dit varslingsbrev."]
[null,"Målerstørrelse*","G4",null,"Målerstørrelse ikke fundet. Du kan finde din målerstørrelse på dit varslingsbrev",null,null,"Er du privatkunde, vil din målerstørrelse som oftest fremgå som G1,6, G2,5 eller G4."]
[null,"*Er du privatkunde, vil din målerstørrelse som oftest fremgå som G1,6; G2,5 eller G4.",null,null,null,null,null,"Indtast dit forventede årsforbrug. "]
[null,null,null,null,null,null,null,"Du finder det forventede årsforbrug på dit varslingsbrev eller den seneste regning fra Evida."]
[null,null,"Regning fra Evida med nye tariffer",null,null,null,null,"Vær opmærksom på, at dit forventede årsforbrug bliver beregnet på ny hvert kvartal,"]
[null,"Årlig forventet tarifbetaling:","Ekskl. moms\t",null,"Inkl. moms",null,null,"når du har afleveret en aflæsning til Evida. Dit forventede årsforbrug kan altså ændre "]
[null,"Målerbetaling",{"$f":"+IFERROR(_xlfn.XLOOKUP(C5,Bilag!X:X,Bilag!AB:AB,)*Bilag!D13*Bilag!D4, )","v":339.60735661378209},null,{"$f":"+C10*1.25","v":424.5091957672276},null,null,"sig i løbet af året."]
[null,"Volumentarif",{"$f":"+IFERROR(C4*Bilag!C13*Bilag!D4, )","v":214.953251677168},null,{"$f":"+C11*1.25","v":268.69156459646001}]
[null,"Systemtarif",{"$f":"+IFERROR(Bilag!E13+_xlfn.XLOOKUP(C5,Bilag!X:X,Bilag!AA:AA,)*Bilag!F13, )*Bilag!D4","v":1301.5415607308951},null,{"$f":"+C12*1.25","v":1626.9269509136188}]
[]
[null,"I alt:",{"$f":"SUM(C10:C12)*Bilag!D4","v":1856.1021690218452},null,{"$f":"SUM(E10:E12)*Bilag!D4","v":2320.1277112773064}]
[]
[null,"Årlig forventet afgifter til staten:",null,null,null,null,null,"Vigtigt at vide"]
[null,"Nødforsyningstarif (Energinet):",{"$f":"+IFERROR(C4*Bilag!J13*Bilag!D4,0)","v":57.376000000000005},null,{"$f":"+C17*1.25","v":71.72},null,null,"Beregningen er KUN vejledende. "]
[null,"Naturgasafgift",{"$f":"+IFERROR(C4*Bilag!G13*Bilag!D4,0)","v":4361.6000000000004},null,{"$f":"+C18*1.25","v":5452},null,null,"Tarifferne er gældende pr. 1. januar 2025, og dermed er beregningen kun gældende, "]
[null,"CO2-afgift",{"$f":"+IFERROR(C4*Bilag!H13*Bilag!D4,0)","v":707.2},null,{"$f":"+C19*1.25","v":884},null,null,"indtil priserne evt. ændrer sig. "]
[null,"NOx-afgift",{"$f":"+IFERROR(C4*Bilag!I13*Bilag!D4,0)","v":14.399999999999999},null,18,null,null,"Afgifter til staten er satserne for 2024, som kan ændre sig i 2025 og dermed påvirke din regning."]
[null,null,null,null,null,null,null,"Beregneren kan kun benyttes af privatkunder og erhvervskunder, som ikke er timeafregnede."]
[null,"I alt tarifbetaling og afgifter:",{"$f":"+SUM(C14:C20)*Bilag!D4","v":6996.678169021845},null,{"$f":"+SUM(E14:E20)","v":8745.8477112773071},null,null,"Er du producent eller timeafregnet erhvervskunde, kan du altså ikke benytte beregneren."]

{"sheet":"Bilag","index":1,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Forbrug i interval 0-20000","Fejl 0/1",{"$f":"+IF(AND(Beregner!C4>=0,Beregner!C4<=500000),1,0)*COUNT(Beregner!C4)","v":1}]
[null,"Målerstørrelse","Fejl 0/1",{"$f":"+_xlfn.XLOOKUP(Beregner!C5,Bilag!X4:X22,Bilag!W4:W22,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Målertype","Max","Enhed","Kapacitetsvægtning","Målervægte"]
[null,null,"Fejl 0/1",{"$f":"+IF(AND(Beregner!C4>=0,Beregner!C4<=500000),1,0)*_xlfn.XLOOKUP(Beregner!C5,Bilag!X4:X22,Bilag!W4:W22,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G1,6",2.5,"m³",4.5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G2,5",4,"m³",4.5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G4",6,"m³",4.5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G6",10,"m³",7.5,1.0364548056421432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G10",16,"m³",12,1.5414143736332271]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G16",25,"m³",18.75,1.5581329284225833]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G25",40,"m³",30,1.8544660374958237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G40",100,"m³",75,8.1389802786471765]
[null,null,"Volumentarif","Måler- og Administrationsgebyr","Grundpris","Kapacitetstarif","Naturgasafgift","CO2-afgift","NOx-afgift","Nødforsyningstarif til Energinet",null,null,null,null,null,null,null,null,null,null,null,null,1,"G65",100,"m³",75,8.1389802786471765]
[null,"Evida",0.13434578229822999,339.60735661378209,766.71357788862042,118.85066285383883,2.726,0.442,8.9999999999999993E-3,3.5860000000000003E-2,null,null,null,null,null,null,null,null,null,null,null,null,1,"G100",160,"m³",120,9.6761594766710548]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G160",250,"m³",187.5,15.794454474900155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G250",400,"m³",300,20.647666237887922]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G400",650,"m³",487.5,26.964076613748247]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G650",1000,"m³",750,26.964076613748247]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G1000",1600,"m³",1200,29.445410768546171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G1600",2500,"m³",1875,39.64481681834701]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G2500",4000,"m³",3000,54.501083135767537]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G4000",6500,"m³",4875,54.501083135767537]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"G6500",10000,"m³",7500,54.501083135767537]