{"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":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"For timeafregnede erhvervskunder: beregn tarifbetaling til Evida"]
[]
[null,"Indtastning",null,null,null,null,null,"Sådan gør du"]
[null,"Forventet årlig forbrug (Nm3):",500000,null,"Forbruget skal være mellem 0 og 250.000.000 m3",null,null,"Indtast din aftalte eller beregnede kapacitet."]
[null,"Målerstørrelse","G100",null,"Målerstørrelse ikke fundet. Du kan finde din målerstørrelse på dit varslingsbrev",null,null,"Vælg din målerstørrelse. Din målerstørrelse kan findes på dit varslingsbrev."]
[null,"Kapacitet (Nm3/t)",125,null,"Er kapaciteten indtastet?",null,null,"Indtast dit forventede årsforbrug. "]
[]
[null,null,"Regning fra Evida med nye tariffer"]
[null,"Årlig forventet tarifbetaling:","Ekskl. moms\t",null,null,null,null,"Vigtigt at vide"]
[null,"Målerbetaling",{"$f":"+IFERROR(_xlfn.XLOOKUP(C5,Bilag!X:X,Bilag!AB:AB,)*Bilag!D14*Bilag!D5, )","v":3286.0949420456541},null,null,null,null,"Beregningen er KUN vejledende. "]
[null,"Volumentarif",{"$f":"+IFERROR(C4*Bilag!C14*Bilag!D5, )","v":67172.891149114992},null,null,null,null,"Tarifferne er gældende pr. 1. januar 2025, og dermed er beregningen kun gældende, "]
[null,"Systemtarif - Grundpris",{"$f":"+IFERROR(Bilag!E14, )*Bilag!D5","v":766.71357788862042},null,null,null,null,"indtil priserne evt. ændrer sig. "]
[null,"Systemtarif - Kapacitet",{"$f":"+IFERROR(C6*Bilag!F14, )*Bilag!D5","v":14856.332856729854},null,null,null,null,"Beregneren kan kun benyttes af timeafregnede kunder. "]
[null,null,null,null,null,null,null,"Er du producent, privatkunde eller ikke-timeafregnet erhvervskunde, kan du altså ikke benytte beregneren."]
[null,"I alt:",{"$f":"SUM(C10:C13)*Bilag!D5","v":86082.032525779126}]

{"sheet":"Bilag","index":1,"n_rows":23,"n_cols":28,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Forbrug i interval 0-250000000","Fejl 0/1",{"$f":"+IF(AND(Beregner!C4>=0,Beregner!C4<=250000000),1,0)*COUNT(Beregner!C4)","v":1}]
[null,"Målerstørrelse","Fejl 0/1",{"$f":"+_xlfn.XLOOKUP(Beregner!C5,Bilag!X5:X23,Bilag!W5:W23,0)","v":1}]
[null,"Kapacitet","Fejl 0/1",{"$f":"+IF(AND(Beregner!C6>=0,Beregner!C6<=50000),1,0)*COUNT(Beregner!C6)","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<=250000000),1,0)*IF(AND(Beregner!C6>=0,Beregner!C6<=50000),1,0)*COUNT(Beregner!C6)*_xlfn.XLOOKUP(Beregner!C5,Bilag!X5:X23,Bilag!W5:W23,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]