{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input og resultat","Timer og LCE","BC TBV","BC ","Elpris","Investering","Teknik","Ledning"],"not_rendered":{"charts":6,"images":2,"macros":1,"external_links":0,"defined_names":54,"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":"Input og resultat","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,3,18,4]]}
["FVF BC"]
["Kalkulationsrente",null,3.5000000000000003E-2]
["T_fj_frem","C",75]
["T_fj_retur","C",40]
["Fjernvarme produktion","MW",{"$f":"'BC TBV'!C6","v":23.884834824258647}]
["VP COP",null,{"$f":"'BC TBV'!C7","v":4.8895890410958911}]
["Fjernvarme produktion","MWh/år",{"$f":"'BC TBV'!D10","v":112969.73580868496}]
["Fuldlaststimer","timer",{"$f":"'BC TBV'!D8","v":4729.7683504994211}]
["Variabel ","kr/MWh varme",{"$f":"'BC TBV'!D19","v":123.28066341682074}]
["LCE ref",null,{"$f":"-0.0019*C9*C9+1.13*C9+181.55","v":291.98071791327368},{"$f":"C10-C13","v":-9.9999999747524271E-7}]
["Investering ekls. Betaling","mio.kr",{"$f":"Investering!C20/1000","v":119.46824817442022}]
["Betaling","mio. kr",{"$f":"C24","v":125.81108845055994},113]
["LCE","kr/MWh varme",{"$f":"'BC TBV'!E25","v":291.98071891327368}]
[]
["Varmekilde leverandør"]
["Bindingsperiode","år",15,"min 5","max 25"]
["Geo effekt","MW",19,"min 5","max 50"]
["T_geo,frem","C",27,"min 10","max 40"]
["T_geo,retur","C",15,"min 5C og min 5C lavere end T_geo,frem"]
["Total afstand","m",100,"min 100","max 20000"]
["Overskudsvarme produktion","MWh",{"$f":"'BC TBV'!D9","v":89865.598659488998}]
["Masseflow geo","kg/s",{"$f":"1000*C17/((C18-C19)*4.18)","v":378.78787878787881}]
["Volumen flow geo","m3/h",{"$f":"C22/1000*3600","v":1363.6363636363635}]
["Indtægt","mio. kr",125.81108845055994,125.81108714944108]
[]
[null,"Start","Slut","Peak dato"]
["Årlige leveringsperiode",{"$f":"D27-(C8/24/2)-15","v":"2019-10-10T11:06:56.969"},{"$f":"D27+(C8/24/2)+15","v":"2020-05-24T12:53:03.031"},"2020-02-01"]
[null,"2019-10-31T19:16:02.740","2020-05-03T04:43:57.260"]
["Rød tekst: leveringsbetingelse for varmekilde leverandør"]
["Grøntekst: leveringsbetingelse for FVF"]

{"sheet":"Timer og LCE","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,2],[9,0,9,2],[17,0,17,2],[25,0,25,2]]}
[]
["1. 100-120 kr/MWh"]
["Varme effekt","Timer","LCE",{"$f":"-3.291*Teknik!$C$13+5130.8","v":5052.1950085933649}]
[10,5092.8922000000002,268]
[20,5067.2303500000007,269]
[30,5037.2218666666686,270]
[40,5001.673200000002,271]
[50,4961.1220800000019,272]
[]
["2. 120-160 kr/MWh"]
["Varme effekt","Timer","LCE",{"$f":"-6.6121*Teknik!$C$13+4743.8","v":4585.8710836585196}]
[10,4676.361799999996,301]
[20,4613.556650000005,303]
[30,4545.4999666666654,306]
[40,4478.474524999996,308]
[50,4413.2975000000015,310]
[]
["3. 160-200 kr/MWh"]
["Varme effekt","Timer","LCE",{"$f":"-7.665*Teknik!$C$13+3920.1","v":3737.0227410720572}]
[10,3840.5865000000022,364]
[20,3767.6867999999981,367]
[30,3693.92266666667,371]
[40,3615.039925000011,375]
[50,3533.6607600000098,379]
[]
["4. 200-260 kr/MWh"]
["Varme effekt","Timer","LCE",{"$f":"-8.5779*Teknik!$C$13+3129.1","v":2924.2182753609918}]
[10,3042.7778000000008,425]
[20,2957.7227499999972,430]
[30,2872.2226666666693,436]
[40,2786.8402250000031,443]
[50,2699.3221000000071,450]
[]
[110,{"$f":"AVERAGE(B4:B8)","v":5032.0279393333349},280,270]
[130,{"$f":"AVERAGE(B12:B16)","v":4545.4380883333333},300,305.60000000000002]
[180,{"$f":"AVERAGE(B20:B24)","v":3690.1793303333384},320,371.2]
[230,{"$f":"AVERAGE(B28:B32)","v":2871.7771083333355},340,436.8]

{"sheet":"BC TBV","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Bindingsperiode","år",{"$f":"'Input og resultat'!C16","v":15}]
["Kalkulationsrente",null,{"$f":"'Input og resultat'!C2","v":3.5000000000000003E-2}]
[null,null,null,"pr år","NPV"]
["Teknik"]
["Geo effekt","MW",{"$f":"'Input og resultat'!C17","v":19}]
["VP effekt","MW",{"$f":"Teknik!C13","v":23.884834824258647}]
["COP VP",null,{"$f":"Teknik!C11","v":4.8895890410958911}]
["Fuldlaststimer","timer",null,{"$f":"(0.029*D19*D19-27.552*D19+7684.5)+(24-C6)*10","v":4729.7683504994211},null,null,null,"Kontrol NPV"]
["Geo varme ","MWh",null,{"$f":"D8*C5","v":89865.598659488998},{"$f":"D9*((1+$C$2)^$C$1-1)/($C$2*(1+$C$2)^$C$1)","v":1035019.0252153763},null,null,{"$f":"$C$1*D9","v":1347983.9798923349}]
["VP varme","MWh",null,{"$f":"D8*C6","v":112969.73580868496},{"$f":"D10*((1+$C$2)^$C$1-1)/($C$2*(1+$C$2)^$C$1)","v":1301118.8661702347},null,null,{"$f":"$C$1*D10","v":1694546.0371302743}]
["Elforbrug","MWh",null,{"$f":"D10/C7","v":23104.137149195943},266099.84095485829,null,null,{"$f":"$C$1*D11","v":346562.05723793915}]
["Omkostning"]
["Geo varme sats","kr/MWh"]
["Geo varme betaling","kr",null,{"$f":"D9*C13/10^3","v":0},0]
["Elpris","kr/MWh el",{"$f":"Elpris!C5","v":505}]
["El omkostning per varme","kr/MWh varme",{"$f":"C15/C7","v":103.28066341682074}]
["El omkostning",null,null,{"$f":"C15*D11/1000","v":11667.589260343952},{"$f":"D17*((1+$C$2)^$C$1-1)/($C$2*(1+$C$2)^$C$1)","v":134380.41968220341}]
["Variable D&V","kr/MWh varme",null,20,{"$f":"D18*((1+$C$2)^$C$1-1)/($C$2*(1+$C$2)^$C$1)","v":230.34821792868286}]
["Variable varmepris","kr/MWh varme",null,{"$f":"C13+C16+D18","v":123.28066341682074}]
["Faste D&V","t. kr/år",null,1,{"$f":"D20*((1+$C$2)^$C$1-1)/($C$2*(1+$C$2)^$C$1)","v":11.517410896434145}]
["Investering",null,null,null,{"$f":"Investering!C20","v":119468.24817442022}]
["Engangsbeløb","t. kr",null,null,{"$f":"'Input og resultat'!C24*1000","v":125811.08845055994}]
["Total omkostning","t. kr",null,{"$f":"SUM(D13:D16)","v":0},{"$f":"SUM(E15:E22)","v":379901.62193600868},null,null,{"$f":"$C$1*D23","v":0}]
[]
["LCE","kr/MWh",null,null,{"$f":"1000*E23/E10","v":291.98071891327368}]
["LCE ref","kr/MWh",null,null,{"$f":"-0.001*D19*D19+0.565*D19+220.8","v":275.25545285801229}]
[null,null,null,null,{"$f":"E25-E26","v":16.725266055261386}]
[null,null,null,null,{"$f":"-0.0015*D19*D19+1.8814*D19+83.212","v":292.35505719366938}]

{"sheet":"BC ","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Elpris","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Lokal tarif","kr/MWh el",20]
["Transmissionstarif","kr/MWh el",80]
["Elspot","kr/MWh el",250]
["Elvarmeafgift","kr/MWh el",155]
["Elpris","kr/MWh el",{"$f":"SUM(C1:C4)","v":505}]

{"sheet":"Investering","index":5,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["COP varme",null,{"$f":"Teknik!C11","v":4.8895890410958911},null,null,null,"Ref","Projekt","Afvigelse","Afvigelse for VP, mio.kr","Afvigelse for rest, mio.kr",null,"min","max"]
["Geo effekt","MW",{"$f":"Teknik!C12","v":19},null,"Varme effekt","MW",23.8,{"$f":"C4","v":23.884834824258647},{"$f":"H3-G3","v":8.483482425864608E-2},{"$f":"0.9*I3*G9","v":192.48237436835663},{"$f":"I3*G10*0.9","v":187.34951105186713},null,5,50]
["VP effekt","MW",{"$f":"Teknik!C13","v":23.884834824258647},null,"T_varmest","C",75,{"$f":"'Input og resultat'!C3","v":75},{"$f":"H4-G4","v":0},{"$f":"I4*0.01*G6","v":0},{"$f":"I4*0.005*G7","v":0},null,50,80]
[null,null,null,null,"T_koldest","C",15,{"$f":"'Input og resultat'!C19","v":15},{"$f":"H5-G5","v":0},{"$f":"-I5*0.02*G6","v":0},{"$f":"-I5*0.01*G7","v":0},null,10,40]
["Specifik anlægsinvestering","t. kr/MW",7000,null,"VP invest","t.kr",60000,{"$f":"G6+J3+J4+J5","v":60192.482374368359}]
[null,null,null,null,"Rest invest","t.kr",{"$f":"(133000-G6)*0.8","v":58400},{"$f":"G7+K3+K4+K5","v":58587.349511051871},null,null,{"$f":"G7*I7","v":0}]
[null,null,null,null,"Total anlæg","t.kr",{"$f":"G6+G7","v":118400},{"$f":"H6+H7","v":118779.83188542022}]
[null,null,null,null,"VP specifik","t.kr/MW",{"$f":"G6/G3","v":2521.0084033613443},{"$f":"H6/H3","v":2520.1129845467394}]
[null,null,null,null,"Rest specifik","t.kr/MW",{"$f":"G7/G3","v":2453.7815126050418},{"$f":"H7/H3","v":2452.9099716254932}]
[null,null,null,null,"Anlæg specifik","t.kr/MW",{"$f":"G8/G3","v":4974.7899159663866},{"$f":"H8/H3","v":4973.0229561722326}]
[]
["Længde","m",{"$f":"'Input og resultat'!C20","v":100}]
["Geo effekt","MW",{"$f":"'Input og resultat'!C17","v":19}]
["Pris per meter","kr/m",{"$f":"-0.6241*C14*C14+159.17*C14+3459.4","v":6258.3298999999997}]
["Ledningspris","t.kr",{"$f":"C13*C15/1000","v":625.83299}]
["Pumpe og diverse","t.kr",{"$f":"C16*0.1","v":62.583299000000004}]
["Total ledning",null,{"$f":"SUM(C16:C17)","v":688.41628900000001}]
[]
["Total investering",null,{"$f":"C18+H8","v":119468.24817442022}]

{"sheet":"Teknik","index":6,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Middel metode",null,"Ln metode",null,null,null,null,null,null,"Middel metode",null,"Ln metode"]
["T_fj_frem",{"$f":"'Input og resultat'!C3","v":75},{"$f":"B2+273","v":348},null,null,null,null,null,null,"T_fj_frem",75,{"$f":"K2+273","v":348}]
["T_fj_retur",{"$f":"'Input og resultat'!C4","v":40},{"$f":"B3+273","v":313},null,null,null,null,null,null,"T_fj_retur",40,{"$f":"K3+273","v":313}]
["T_fj_mid",{"$f":"(B2+B3)/2","v":57.5},{"$f":"(C2+C3)/2","v":330.5},"T_lmH",{"$f":"(C2-C3)/(LN(C2/C3))","v":330.1908932863625},null,null,null,null,"T_fj_mid",{"$f":"(K2+K3)/2","v":57.5},{"$f":"(L2+L3)/2","v":330.5},"T_lmH",{"$f":"(L2-L3)/(LN(L2/L3))","v":330.1908932863625}]
["T_geo_frem",{"$f":"'Input og resultat'!C18","v":27},300,null,null,null,null,null,null,"T_geo_frem",27,300]
["T_geo_retur",{"$f":"'Input og resultat'!C19","v":15},288,null,null,null,null,null,null,"T_geo_retur",15,288]
["T_geo_mid",{"$f":"(B5+B6)/2","v":21},{"$f":"(C5+C6)/2","v":294},"T_lmL",{"$f":"(C5-C6)/(LN(C5/C6))","v":293.95917913922108},null,null,null,null,"T_geo_mid",{"$f":"(K5+K6)/2","v":21},{"$f":"(L5+L6)/2","v":294},"T_lmL",{"$f":"(L5-L6)/(LN(L5/L6))","v":293.95917913922108}]
[]
["eff_VP",null,0.54,null,{"$f":"C9","v":0.54},null,null,null,null,"eff_VP",null,0.55000000000000004,null,{"$f":"L9","v":0.55000000000000004}]
["COP_L",null,{"$f":"C4/(C4-C7)","v":9.0547945205479454},"COP_L",{"$f":"E4/(E4-E7)","v":9.1133113919318571},null,null,null,null,"COP_L",null,{"$f":"L4/(L4-L7)","v":9.0547945205479454},"COP_L",{"$f":"N4/(N4-N7)","v":9.1133113919318571}]
["Faktisk COP",null,{"$f":"C9*C10","v":4.8895890410958911},null,{"$f":"E9*E10","v":4.9211881516432028},null,null,null,null,null,null,{"$f":"L9*L10","v":4.9801369863013702},null,{"$f":"N9*N10","v":5.0123212655625222},"Afvigelse",{"$f":"(N11-L11)/E11","v":6.5399408170170288E-3},null,"Faktisk COP"]
["Geo effekt","MW",{"$f":"'Input og resultat'!C17","v":19},null,null,null,null,null,null,null,null,null,null,null,"Konklusion: simplere at bruge middel metode"]
["VP effekt","MW",{"$f":"C12+C12/(C11-1)","v":23.884834824258647}]

{"sheet":"Ledning","index":7,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Længde","m",500]
["Effekt","MW",{"$f":"'Input og resultat'!C17","v":19}]
["Pris per meter","kr/m",{"$f":"-0.6241*C2*C2+159.17*C2+3459.4","v":6258.3298999999997}]
["Ledningspris","kr",{"$f":"C1*C3","v":3129164.9499999997}]
["Pumpe og diverse","kr",{"$f":"C4*0.1","v":312916.495}]
["Total ledning",null,{"$f":"SUM(C4:C5)","v":3442081.4449999998}]