{"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":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"For producenter: beregn tarifbetaling til Evida"]
[]
[null,"Indtastning",null,null,null,null,null,"Sådan gør du"]
[null,"Forventet årlig produktion (Nm3):",50000000,null,"Produktionen skal være mellem 0 og 250.000.000 m3",null,null,"Indtast jeres forventede årsproduktion. "]
[null,"Kapacitet (Nm3/t)",5000,null,"Er kapaciteten indtastet?",null,null,"Indtast jeres aftalte kapacitet. Kapaciteten fremgår af varslingsbrevet og jeres kontrakt"]
[]
[null,null,"Betaling til Evida, indfødningstarif"]
[null,"Årlig forventet tarifbetaling:","Ekskl. moms\t"]
[null,"Volumentarif",{"$f":"+IFERROR(C4*Bilag!C7*Bilag!D4, )","v":5207337.7412059596},null,null,null,null,"Vigtigt at vide"]
[null,"Systemtarif",{"$f":"+IFERROR(C5*Bilag!F7, )*Bilag!D4","v":5098490.6191249182},null,null,null,null,"Beregningen er KUN vejledende. "]
[null,null,null,null,null,null,null,"Priserne er gældende pr. 1. januar 2025, og dermed er beregningen kun gældende, "]
[null,"I alt:",{"$f":"+SUM(C9:C10)*Bilag!D4","v":10305828.360330878},null,null,null,null,"indtil priserne evt. ændrer sig."]
[null,null,null,null,null,null,null,"Beregneren kan kun benyttes af producenter. "]
[null,null,null,null,null,null,null,"Er du gasforbruger, kan du altså ikke benytte beregneren."]

{"sheet":"Bilag","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Produktion op til 250 mio Nm3/år","Fejl 0/1",{"$f":"+IF(AND(Beregner!C4>=0,Beregner!C4<=250000000),1,0)*COUNT(Beregner!C4)","v":1}]
[null,"Kapacitet op til 50t Nm3/t","Fejl 0/1",{"$f":"+IF(AND(Beregner!C5>=0,Beregner!C5<=50000),1,0)*COUNT(Beregner!C5)","v":1}]
[null,null,"Fejl 0/1",{"$f":"+IF(AND(Beregner!C4>=0,Beregner!C4<=250000000),1,0)*IF(AND(Beregner!C5>=0,Beregner!C5<=50000),1,0)*COUNT(Beregner!C5)","v":1}]
[]
[null,null,"Volumentarif","Måler- og Administrationsgebyr","Grundpris","Kapacitetstarif","Naturgasafgift","CO2-afgift","NOx-afgift","Nødforsyningstarif til Energinet"]
[null,"Evida Producent",0.1041467548241192,null,null,1019.6981238249837]