{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LCC","Pelletspanna","Fjärrvärme","Värmepump","Förklaringar"],"not_rendered":{"charts":12,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"LCC","index":0,"n_rows":203,"n_cols":22,"rows_kept":203,"cut":false,"hidden":false,"merged":[[7,0,16,0],[109,1,109,4]]}
["Lönsamhetsberäkningar med hjälp av LCC och återbetalningstid"]
[]
[null,"Generella indata"]
[]
[null,"Kalkylperiod (år)",20]
[null,"Kalkylränta (%)",0.05]
[]
["<-\nTror du att energipriserna kommer att förändras?\nTryck på plus för att ange energiprisförändring\n<-","Energislag 1","El"]
[null,"Energipris energislag (kr/kWh)",1]
[null,"Förväntad real årlig energiprisförändring (%)"]
[null,"Energislag 2"]
[null,"Energipris energislag (kr/kWh)"]
[null,"Förväntad real årlig energiprisförändring (%)"]
[null,"Energislag 3"]
[null,"Energipris energislag (kr/kWh)"]
[null,"Förväntad real årlig energiprisförändring (%)"]
[]
[null,"Nusummefaktor",{"$f":"IF($C$6=0,$C$5,(1-(1+$C$6)^-$C$5)/$C$6)","v":12.462210342539986}]
[null,"Nusummefaktor energislag 1",{"$f":"IF($C$6=$C$10,$C$5,((1-((1+$C$10)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$10)-1)))","v":12.462210342539979}]
[null,"Nusummefaktor energislag 2",{"$f":"IF($C$6=$C$13,$C$5,((1-((1+$C$13)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$13)-1)))","v":12.462210342539979}]
[null,"Nusummefaktor energislag 3",{"$f":"IF($C$6=$C$16,$C$5,((1-((1+$C$16)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$16)-1)))","v":12.462210342539979}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Ex ingen åtgärd"]
[null,"Investeringskostnad (kr)"]
[]
[null,"Årligt energibehov, energislag 1 (kWh) "]
[null,"Årligt energibehov, energislag 2 (kWh) "]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)"]
[null,"Underhållskostnad år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B35","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B36","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,{"$f":"(1+$C$6)^-B50","v":0.41552065486748313}]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Övriga årliga kostnader (kr/år)"]
[null,"Övriga kostnader år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B67","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B68","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,0.41552065486748313]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)"]
[]
[null,"Beräkningar och resultat"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Nuvärde investering minus restvärde (kr)",{"$f":"C26-C96*(1+$C$6)^-$C$5","v":0},{"$f":"D26-D96*(1+$C$6)^-$C$5","v":0},{"$f":"E26-E96*(1+$C$6)^-$C$5","v":0},"Investering minus restvärde"]
[null,"Nuvärde drift- och underhållskostnader (kr)",{"$f":"C32*$C$18+SUMPRODUCT(C33:C62,$F$33:$F$62)","v":0},{"$f":"D32*$C$18+SUMPRODUCT(D33:D62,$F$33:$F$62)","v":0},{"$f":"E32*$C$18+SUMPRODUCT(E33:E62,$F$33:$F$62)","v":0},"Drift- och underhållskostnader"]
[null,"Nuvärde övriga kostnader (kr)",{"$f":"C64*$C$18+SUMPRODUCT(C65:C94,$F$65:$F$94)","v":0},{"$f":"D64*$C$18+SUMPRODUCT(D65:D94,$F$65:$F$94)","v":0},{"$f":"E64*$C$18+SUMPRODUCT(E65:E94,$F$65:$F$94)","v":0},"Övriga kostnader"]
[null,"Nuvärde energikostnader (kr)",{"$f":"C28*$C$9*$C$19+C29*$C$12*$C$20+C30*$C$15*$C$21","v":0},{"$f":"D28*$C$9*$C$19+D29*$C$12*$C$20+D30*$C$15*$C$21","v":0},{"$f":"E28*$C$9*$C$19+E29*$C$12*$C$20+E30*$C$15*$C$21","v":0},"Energikostnader"]
[null,"Livscykelkostnad, LCC (kr)",{"$f":"SUM(C100:C103)","v":0},{"$f":"IF(SUM(D100:D103)=0,\"-\",SUM(D100:D103))","v":"-"},{"$f":"IF(SUM(E100:E103)=0,\"-\",SUM(E100:E103))","v":"-"}]
[]
[]
[null,"Lönsamhetsbedömning av åtgärd B och C (jämfört mot Alt A)"]
[null,"Rak återbetalningstid, payoff (år)",null,{"$f":"IF(AND(D26>$C$26,(D28-$C$28)*$C$9+(D29-$C$29)*$C$12+(D30-$C$30)*$C$15+(D32-$C$32)+(D64-$C$64)>0),\"återbetalas ej\",IF(OR(D104=\"-\",D26<$C$26),\"-\",(D26-$C$26)/(($C$28-D28)*$C$9+($C$29-D29)*$C$12+($C$30-D30)*$C$15+($C$32-D32)+($C$64-D64))))","v":"-"},{"$f":"IF(AND(E26>$C$26,(E28-$C$28)*$C$9+(E29-$C$29)*$C$12+(E30-$C$30)*$C$15+(E32-$C$32)+(E64-$C$64)>0),\"återbetalas ej\",IF(OR(E104=\"-\",E26<$C$26),\"-\",(E26-$C$26)/(($C$28-E28)*$C$9+($C$29-E29)*$C$12+($C$30-E30)*$C$15+($C$32-E32)+($C$64-E64))))","v":"-"}]
[null,"Nettonuvärde av investering, Minskning LCC (kr)",null,{"$f":"IF(D104=\"-\",\"-\",C104-D104)","v":"-"},{"$f":"IF(E104=\"-\",\"-\",C104-E104)","v":"-"}]
[null,{"$f":"IF(OR(AND(ISNUMBER(D104),D26<C26),AND(ISNUMBER(E104),E26<C26)),\"!!! För att uträkningen av återbetalningstid ska ge ett meningsfullt resultat behöver Alt A vara det alternativ som har lägst investeringskostnad !!!\",\"\")","v":""}]
[]
[null,"Summering av resultat"]
[null,"Av Alt A, B och C har ",{"$f":"IF(SMALL(C104:E104,1)=C104,C24,IF(D104<E104,D24,E24))","v":"Alt A"}," lägst LCC-kostnad"]
[]
[]
[null,"Jämförelse LCC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jämförelse Återbetalningstid"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Känslighetsanalys"]
[]
[null,null,null,null,null,"Alt A","Alt B"]
[null,null,null,null,1E-3,{"$f":"C$26-C$96*(1+$E150)^-$C$5+C$32*$J174+SUMPRODUCT(C$33:C$62,$O$174:$O$203)+C$64*$J174+SUMPRODUCT(C$65:C$94,$O$174:$O$203)+C$28*$C$9*$K174+C$29*$C$12*$L174+C$30*$C$15*$M174","v":0},{"$f":"D$26-D$96*(1+$E150)^-$C$5+D$32*$J174+SUMPRODUCT(D$33:D$62,$O$174:$O$203)+D$64*$J174+SUMPRODUCT(D$65:D$94,$O$174:$O$203)+D$28*$C$9*$K174+D$29*$C$12*$L174+D$30*$C$15*$M174","v":0}]
[null,null,null,null,0.02,{"$f":"C$26-C$96*(1+$E151)^-$C$5+C$32*$J175+SUMPRODUCT(C$33:C$62,$P$174:$P$203)+C$64*$J175+SUMPRODUCT(C$65:C$94,$P$174:$P$203)+C$28*$C$9*$K175+C$29*$C$12*$L175+C$30*$C$15*$M175","v":0},{"$f":"D$26-D$96*(1+$E151)^-$C$5+D$32*$J175+SUMPRODUCT(D$33:D$62,$P$174:$P$203)+D$64*$J175+SUMPRODUCT(D$65:D$94,$P$174:$P$203)+D$28*$C$9*$K175+D$29*$C$12*$L175+D$30*$C$15*$M175","v":0}]
[null,null,null,null,0.04,{"$f":"C$26-C$96*(1+$E152)^-$C$5+C$32*$J176+SUMPRODUCT(C$33:C$62,$Q$174:$Q$203)+C$64*$J176+SUMPRODUCT(C$65:C$94,$Q$174:$Q$203)+C$28*$C$9*$K176+C$29*$C$12*$L176+C$30*$C$15*$M176","v":0},{"$f":"D$26-D$96*(1+$E152)^-$C$5+D$32*$J176+SUMPRODUCT(D$33:D$62,$Q$174:$Q$203)+D$64*$J176+SUMPRODUCT(D$65:D$94,$Q$174:$Q$203)+D$28*$C$9*$K176+D$29*$C$12*$L176+D$30*$C$15*$M176","v":0}]
[null,null,null,null,0.06,{"$f":"C$26-C$96*(1+$E153)^-$C$5+C$32*$J177+SUMPRODUCT(C$33:C$62,$R$174:$R$203)+C$64*$J177+SUMPRODUCT(C$65:C$94,$R$174:$R$203)+C$28*$C$9*$K177+C$29*$C$12*$L177+C$30*$C$15*$M177","v":0},{"$f":"D$26-D$96*(1+$E153)^-$C$5+D$32*$J177+SUMPRODUCT(D$33:D$62,$R$174:$R$203)+D$64*$J177+SUMPRODUCT(D$65:D$94,$R$174:$R$203)+D$28*$C$9*$K177+D$29*$C$12*$L177+D$30*$C$15*$M177","v":0}]
[null,null,null,null,0.08,{"$f":"C$26-C$96*(1+$E154)^-$C$5+C$32*$J178+SUMPRODUCT(C$33:C$62,$S$174:$S$203)+C$64*$J178+SUMPRODUCT(C$65:C$94,$S$174:$S$203)+C$28*$C$9*$K178+C$29*$C$12*$L178+C$30*$C$15*$M178","v":0},{"$f":"D$26-D$96*(1+$E154)^-$C$5+D$32*$J178+SUMPRODUCT(D$33:D$62,$S$174:$S$203)+D$64*$J178+SUMPRODUCT(D$65:D$94,$S$174:$S$203)+D$28*$C$9*$K178+D$29*$C$12*$L178+D$30*$C$15*$M178","v":0}]
[null,null,null,null,0.1,{"$f":"C$26-C$96*(1+$E155)^-$C$5+C$32*$J179+SUMPRODUCT(C$33:C$62,$T$174:$T$203)+C$64*$J179+SUMPRODUCT(C$65:C$94,$T$174:$T$203)+C$28*$C$9*$K179+C$29*$C$12*$L179+C$30*$C$15*$M179","v":0},{"$f":"D$26-D$96*(1+$E155)^-$C$5+D$32*$J179+SUMPRODUCT(D$33:D$62,$T$174:$T$203)+D$64*$J179+SUMPRODUCT(D$65:D$94,$T$174:$T$203)+D$28*$C$9*$K179+D$29*$C$12*$L179+D$30*$C$15*$M179","v":0}]
[null,null,null,null,0.12,{"$f":"C$26-C$96*(1+$E156)^-$C$5+C$32*$J180+SUMPRODUCT(C$33:C$62,$U$174:$U$203)+C$64*$J180+SUMPRODUCT(C$65:C$94,$U$174:$U$203)+C$28*$C$9*$K180+C$29*$C$12*$L180+C$30*$C$15*$M180","v":0},{"$f":"D$26-D$96*(1+$E156)^-$C$5+D$32*$J180+SUMPRODUCT(D$33:D$62,$U$174:$U$203)+D$64*$J180+SUMPRODUCT(D$65:D$94,$U$174:$U$203)+D$28*$C$9*$K180+D$29*$C$12*$L180+D$30*$C$15*$M180","v":0}]
[null,null,null,null,0.14000000000000001,{"$f":"C$26-C$96*(1+$E157)^-$C$5+C$32*$J181+SUMPRODUCT(C$33:C$62,$V$174:$V$203)+C$64*$J181+SUMPRODUCT(C$65:C$94,$V$174:$V$203)+C$28*$C$9*$K181+C$29*$C$12*$L181+C$30*$C$15*$M181","v":0},{"$f":"D$26-D$96*(1+$E157)^-$C$5+D$32*$J181+SUMPRODUCT(D$33:D$62,$V$174:$V$203)+D$64*$J181+SUMPRODUCT(D$65:D$94,$V$174:$V$203)+D$28*$C$9*$K181+D$29*$C$12*$L181+D$30*$C$15*$M181","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Testa gärna också att variera andra osäkra indata, t.ex. investeringskostnader eller energipriser!"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Alt C"]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E150)^-$C$5+E$32*$J174+SUMPRODUCT(E$33:E$62,$O$174:$O$203)+E$64*$J174+SUMPRODUCT(E$65:E$94,$O$174:$O$203)+E$28*$C$9*$K174+E$29*$C$12*$L174+E$30*$C$15*$M174","v":0},null,{"$f":"(1-(1+$E150)^-$C$5)/$E150","v":19.791531187324907},{"$f":"IF($E150=$C$10,$C$5,((1-((1+$C$10)/(1+$E150))^$C$5)/((1+$E150)/(1+$C$10)-1)))","v":19.791531187326864},{"$f":"IF($E150=$C$13,$C$5,((1-((1+$C$13)/(1+$E150))^$C$5)/((1+$E150)/(1+$C$13)-1)))","v":19.791531187326864},{"$f":"IF($E150=$C$16,$C$5,((1-((1+$C$16)/(1+$E150))^$C$5)/((1+$E150)/(1+$C$16)-1)))","v":19.791531187326864},null,{"$f":"(1+$E$150)^-1","v":0.99900099900099915},{"$f":"(1+$E$151)^-1","v":0.98039215686274506},{"$f":"(1+$E$152)^-1","v":0.96153846153846145},{"$f":"(1+$E$153)^-1","v":0.94339622641509424},{"$f":"(1+$E$154)^-1","v":0.92592592592592582},{"$f":"(1+$E$155)^-1","v":0.90909090909090906},{"$f":"(1+$E$156)^-1","v":0.89285714285714279},{"$f":"(1+$E$157)^-1","v":0.8771929824561403}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E151)^-$C$5+E$32*$J175+SUMPRODUCT(E$33:E$62,$P$174:$P$203)+E$64*$J175+SUMPRODUCT(E$65:E$94,$P$174:$P$203)+E$28*$C$9*$K175+E$29*$C$12*$L175+E$30*$C$15*$M175","v":0},null,16.351433344597112,16.35143334459713,16.35143334459713,16.35143334459713,null,{"$f":"(1+$E$150)^-2","v":0.99800299600499431},{"$f":"(1+$E$151)^-2","v":0.96116878123798544},{"$f":"(1+$E$152)^-2","v":0.92455621301775137},{"$f":"(1+$E$153)^-2","v":0.88999644001423983},{"$f":"(1+$E$154)^-2","v":0.85733882030178321},{"$f":"(1+$E$155)^-2","v":0.82644628099173545},{"$f":"(1+$E$156)^-2","v":0.79719387755102034},{"$f":"(1+$E$157)^-2","v":0.76946752847029842}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E152)^-$C$5+E$32*$J176+SUMPRODUCT(E$33:E$62,$Q$174:$Q$203)+E$64*$J176+SUMPRODUCT(E$65:E$94,$Q$174:$Q$203)+E$28*$C$9*$K176+E$29*$C$12*$L176+E$30*$C$15*$M176","v":0},null,13.590326344967698,13.5903263449677,13.5903263449677,13.5903263449677,null,{"$f":"(1+$E$150)^-$B35","v":0.99700599001497947},{"$f":"(1+$E$151)^-$B35","v":0.94232233454704462},{"$f":"(1+$E$152)^-$B35","v":0.88899635867091487},{"$f":"(1+$E$153)^-$B35","v":0.8396192830323016},{"$f":"(1+$E$154)^-$B35","v":0.79383224102016958},{"$f":"(1+$E$155)^-$B35","v":0.75131480090157754},{"$f":"(1+$E$156)^-$B35","v":0.71178024781341087},{"$f":"(1+$E$157)^-$B35","v":0.67497151620201612}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E153)^-$C$5+E$32*$J177+SUMPRODUCT(E$33:E$62,$R$174:$R$203)+E$64*$J177+SUMPRODUCT(E$65:E$94,$R$174:$R$203)+E$28*$C$9*$K177+E$29*$C$12*$L177+E$30*$C$15*$M177","v":0},null,11.469921218565263,11.469921218565261,11.469921218565261,11.469921218565261,null,0.99600998003494456,0.9238454260265142,0.85480419102972571,0.79209366323802044,0.73502985279645328,0.68301345536507052,0.63551807840483121,0.59208027737018942]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E154)^-$C$5+E$32*$J178+SUMPRODUCT(E$33:E$62,$S$174:$S$203)+E$64*$J178+SUMPRODUCT(E$65:E$94,$S$174:$S$203)+E$28*$C$9*$K178+E$29*$C$12*$L178+E$30*$C$15*$M178","v":0},null,9.8181474074492936,9.8181474074492865,9.8181474074492865,9.8181474074492865,null,0.99501496506987486,0.90573080982991594,0.82192710675935154,0.74725817286605689,0.68058319703375303,0.62092132305915493,0.56742685571859919,0.51936866435981521]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E155)^-$C$5+E$32*$J179+SUMPRODUCT(E$33:E$62,$T$174:$T$203)+E$64*$J179+SUMPRODUCT(E$65:E$94,$T$174:$T$203)+E$28*$C$9*$K179+E$29*$C$12*$L179+E$30*$C$15*$M179","v":0},null,8.5135637197585652,8.5135637197585563,8.5135637197585563,8.5135637197585563,null,0.99402094412574937,0.88797138218619198,0.79031452573014571,0.70496054043967626,0.63016962688310452,0.56447393005377722,0.50663112117732068,0.45558654768404844]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E156)^-$C$5+E$32*$J180+SUMPRODUCT(E$33:E$62,$U$174:$U$203)+E$64*$J180+SUMPRODUCT(E$65:E$94,$U$174:$U$203)+E$28*$C$9*$K180+E$29*$C$12*$L180+E$30*$C$15*$M180","v":0},null,7.4694436243275977,7.4694436243275897,7.4694436243275897,7.4694436243275897,null,0.99302791620954001,0.87056017861391388,0.75991781320206331,0.66505711362233599,0.58349039526213387,0.51315811823070645,0.45234921533689343,0.39963732252986695]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E157)^-$C$5+E$32*$J181+SUMPRODUCT(E$33:E$62,$V$174:$V$203)+E$64*$J181+SUMPRODUCT(E$65:E$94,$V$174:$V$203)+E$28*$C$9*$K181+E$29*$C$12*$L181+E$30*$C$15*$M181","v":0},null,6.6231305516159438,6.6231305516159384,6.6231305516159384,6.6231305516159384,null,0.99203588032921075,0.85349037119011162,0.73069020500198378,0.62741237134182648,0.54026888450197574,0.46650738020973315,0.4038832279793691,0.35055905485076044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99104483549371702,0.83675526587265847,0.70258673557883045,0.59189846353002495,0.50024896713145905,0.42409761837248466,0.36061002498157957,0.3075079428515442]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99005478071300423,0.82034829987515534,0.67556416882579851,0.55839477691511785,0.46319348808468425,0.38554328942953148,0.32197323659069599,0.26974380951889843]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98906571499800655,0.80426303909328967,0.6495809315632679,0.52678752539162055,0.42888285933767062,0.3504938994813922,0.28747610409883567,0.23661737677096348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98807763736064591,0.78849317558165644,0.62459704958006512,0.4969693635770005,0.39711375864599124,0.31863081771035656,0.25667509294538904,0.20755910243066969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98709054681383213,0.77303252508005538,0.600574086134678,0.46883902224245327,0.36769792467221413,0.28966437973668779,0.22917419012981158,0.18206938809707865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.986104442371461,0.75787502458828948,0.57747508282180582,0.44230096437967292,0.34046104136316119,0.26333125430607973,0.20461981261590317,0.15970998955884091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98511932304841265,0.74301472998851925,0.55526450271327477,0.41726506073554037,0.31524170496588994,0.23939204936916339,0.18269626126419927,0.1400964820691587]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98413518786055221,0.72844581371423445,0.53390817568584104,0.39364628371277405,0.29189046756100923,0.21762913579014853,0.16312166184303503,0.12289165093785848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98315203582472765,0.7141625624649357,0.51337324585177024,0.37136441859695657,0.27026895144537894,0.19784466890013502,0.14564434093128129,0.107799693805139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98216986595876898,0.7001593749656233,0.49362812101131748,0.35034379112920433,0.25024902911609154,0.17985878990921364,0.13003959011721541,9.4561134916788581E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98118867728148773,0.68643075977021895,0.47464242404934376,0.3305130104992493,0.23171206399638106,0.16350799082655781,0.1161067768903709,8.2948363962095248E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98020846881267509,0.67297133310805779,0.45638694620129205,0.31180472688608429,0.21454820740405653,0.14864362802414349,0.1036667650806883,7.2761722773767745E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97922923957310215,0.65977581677260566,0.43883360211662686,0.29415540272272095,0.19865574759634863,0.13513057093103953,9.2559611679185971E-2,6.3826072608568193E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97825098858451787,0.64683903605157411,0.42195538665060278,0.27750509690822728,0.18394050703365611,0.12284597357367227,8.2642510427844609E-2,5.5987782989972097E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97727371486964842,0.63415591769762181,0.40572633331788732,0.26179726123417668,0.17031528429042234,0.11167815779424752,7.3787955739146982E-2,4.9112090342080778E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.976297417452196,0.62172148793884485,0.39012147434412242,0.24697854833412897,0.1576993373059466,0.10152559799477048,6.5882103338524081E-2,4.3080781001825233E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97532209535683934,0.60953087052827937,0.37511680225396377,0.23299863050389524,0.1460179049129135,9.2295998177064048E-2,5.8823306552253637E-2,3.779015877353091E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97434774760923015,0.59757928483164635,0.36068923293650368,0.21981002877725966,0.13520176380825324,8.3905452888240042E-2,5.2520809421655032E-2,3.3149262082044648E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97337437323599441,0.58586204395259456,0.3468165701312535,0.20736795167666003,0.12518681834097523,7.6277684443854576E-2,4.6893579840763415E-2,2.9078300071968988E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97240197126472983,0.57437455289470041,0.3334774712800514,0.1956301430911887,0.11591372068608817,6.9343349494413245E-2,4.1869267714967337E-2,2.5507280764885072E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97143054072400581,0.56311230675951029,0.32065141469235708,0.18455673876527234,0.10732751915378534,6.3039408631284766E-2,3.7383274745506546E-2,2.2374807688495677E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97046008064336287,0.55207088897991197,0.30831866797342034,0.17411013091063426,9.9377332549801231E-2,5.7308553301167964E-2,3.3377923879916553E-2,1.9627024288154101E-2]

{"sheet":"Pelletspanna","index":1,"n_rows":205,"n_cols":22,"rows_kept":205,"cut":false,"hidden":false,"merged":[[7,0,18,0],[111,1,111,4]]}
["Lönsamhetsberäkningar med hjälp av LCC och återbetalningstid"]
[]
[null,"Generella indata",null,null,null,null,null,"Indata beräkningsexempel"]
[]
[null,"Kalkylperiod (år)",20,null,null,null,null,"Nuvarande bränsleförbrukning (kWh/år)",100000,"Detta värde förs in i cell C30"]
[null,"Kalkylränta (%)",0.05,null,null,null,null,"Verkningsgrad oljepanna (%)",0.7]
[null,null,null,null,null,null,null,"Verkningsgrad pelletspanna (%)",0.8]
[null,"Energislag 1","Olja"]
[null,"Energipris energislag (kr/kWh)",1.2,"Se faktaruta Energipriser och utsläppsfaktorer",null,null,null,"Årligt uppvärmningsbehov (kWh/år)",{"$f":"I5*I6","v":70000}]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Bränsleförbrukning pelletspanna (kWh/år)",{"$f":"I9/I7","v":87500},"Detta värde förs in i cell D31"]
[null,"Utsläppsfaktor (gCO2e/kWh)",288,null,null,null,null,"Årliga utsläpp oljepanna (kgCO2e/år)",{"$f":"I5*C11/1000","v":28800}]
[null,"Energislag 2","Pellets",null,null,null,null,"Årliga utsläpp pelletspanna (kgCO2e/år)",{"$f":"I10*C15/1000","v":1662.5}]
[null,"Energipris energislag (kr/kWh)",0.5,"Se faktaruta Energipriser och utsläppsfaktorer",null,null,null,"Årlig energibesparing (kWh/år)",{"$f":"I5-I10","v":12500}]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Årlig energibesparing (kr/År)",{"$f":"C9*I5-I10*C13","v":76250}]
[null,"Utsläppsfaktor (gCO2e/kWh)",19,null,null,null,null,"Årlig utsläppsminskning (kgCO2e/år)",{"$f":"I11-I12","v":27137.5}]
[null,"Energislag 3"]
[null,"Energipris energislag (kr/kWh)"]
[null,"Förväntad real årlig energiprisförändring (%)"]
[null,"Utsläppsfaktor (gCO2e/kWh)"]
[null,"Nusummefaktor",{"$f":"IF($C$6=0,$C$5,(1-(1+$C$6)^-$C$5)/$C$6)","v":12.462210342539986}]
[null,"Nusummefaktor energislag 1",{"$f":"IF($C$6=$C$10,$C$5,((1-((1+$C$10)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$10)-1)))","v":22.125976740351309}]
[null,"Nusummefaktor energislag 2",{"$f":"IF($C$6=$C$14,$C$5,((1-((1+$C$14)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$14)-1)))","v":22.125976740351309}]
[null,"Nusummefaktor energislag 3",{"$f":"IF($C$6=$C$18,$C$5,((1-((1+$C$18)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$18)-1)))","v":12.462210342539979}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Behåll oljepanna","Byt till pelletspanna"]
[null,"Investeringskostnad (kr)",0,30000,null,"Se faktaruta Kostnader"]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",{"$f":"I5","v":100000}]
[null,"Årligt energibehov, energislag 2 (kWh) ",null,{"$f":"I10","v":87500}]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)"]
[null,"Underhållskostnad år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B37","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B38","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,{"$f":"(1+$C$6)^-B52","v":0.41552065486748313}]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Övriga årliga kostnader (kr/år)"]
[null,"Övriga kostnader år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B69","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B70","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,0.41552065486748313]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)"]
[]
[null,"Beräkningar och resultat"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Nuvärde investering minus restvärde (kr)",{"$f":"C28-C98*(1+$C$6)^-$C$5","v":0},{"$f":"D28-D98*(1+$C$6)^-$C$5","v":30000},{"$f":"E28-E98*(1+$C$6)^-$C$5","v":0},"Investering minus restvärde"]
[null,"Nuvärde drift- och underhållskostnader (kr)",{"$f":"C34*$C$20+SUMPRODUCT(C35:C64,$F$35:$F$64)","v":0},{"$f":"D34*$C$20+SUMPRODUCT(D35:D64,$F$35:$F$64)","v":0},{"$f":"E34*$C$20+SUMPRODUCT(E35:E64,$F$35:$F$64)","v":0},"Drift- och underhållskostnader"]
[null,"Nuvärde övriga kostnader (kr)",{"$f":"C66*$C$20+SUMPRODUCT(C67:C96,$F$67:$F$96)","v":0},{"$f":"D66*$C$20+SUMPRODUCT(D67:D96,$F$67:$F$96)","v":0},{"$f":"E66*$C$20+SUMPRODUCT(E67:E96,$F$67:$F$96)","v":0},"Övriga kostnader"]
[null,"Nuvärde energikostnader (kr)",{"$f":"C30*$C$9*$C$21+C31*$C$13*$C$22+C32*$C$17*$C$23","v":2655117.2088421569},{"$f":"D30*$C$9*$C$21+D31*$C$13*$C$22+D32*$C$17*$C$23","v":968011.48239036975},{"$f":"E30*$C$9*$C$21+E31*$C$13*$C$22+E32*$C$17*$C$23","v":0},"Energikostnader"]
[null,"Livscykelkostnad, LCC (kr)",{"$f":"SUM(C102:C105)","v":2655117.2088421569},{"$f":"IF(SUM(D102:D105)=0,\"-\",SUM(D102:D105))","v":998011.48239036975},{"$f":"IF(SUM(E102:E105)=0,\"-\",SUM(E102:E105))","v":"-"}]
[]
[]
[null,"Lönsamhetsbedömning av åtgärd B och C (jämfört mot Alt A)"]
[null,"Rak återbetalningstid, payoff (år)",null,{"$f":"IF(AND(D28>$C$28,(D30-$C$30)*$C$9+(D31-$C$31)*$C$13+(D32-$C$32)*$C$17+(D34-$C$34)+(D66-$C$66)>0),\"återbetalas ej\",IF(OR(D106=\"-\",D28<$C$28),\"-\",(D28-$C$28)/(($C$30-D30)*$C$9+($C$31-D31)*$C$13+($C$32-D32)*$C$17+($C$34-D34)+($C$66-D66))))","v":0.39344262295081966},{"$f":"IF(AND(E28>$C$28,(E30-$C$30)*$C$9+(E31-$C$31)*$C$13+(E32-$C$32)*$C$17+(E34-$C$34)+(E66-$C$66)>0),\"återbetalas ej\",IF(OR(E106=\"-\",E28<$C$28),\"-\",(E28-$C$28)/(($C$30-E30)*$C$9+($C$31-E31)*$C$13+($C$32-E32)*$C$17+($C$34-E34)+($C$66-E66))))","v":"-"}]
[null,"Nettonuvärde av investering, Minskning LCC (kr)",null,{"$f":"IF(D106=\"-\",\"-\",C106-D106)","v":1657105.7264517872},{"$f":"IF(E106=\"-\",\"-\",C106-E106)","v":"-"}]
[null,{"$f":"IF(OR(AND(ISNUMBER(D106),D28<C28),AND(ISNUMBER(E106),E28<C28)),\"!!! För att uträkningen av återbetalningstid ska ge ett meningsfullt resultat behöver Alt A vara det alternativ som har lägst investeringskostnad !!!\",\"\")","v":""}]
[]
[null,"Summering av resultat"]
[null,"Av Alt A, B och C har ",{"$f":"IF(SMALL(C106:E106,1)=C106,C26,IF(D106<E106,D26,E26))","v":"Alt B"}," lägst LCC-kostnad"]
[]
[]
[null,"Jämförelse LCC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jämförelse Återbetalningstid"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Känslighetsanalys"]
[]
[null,null,null,null,null,"Alt A","Alt B"]
[null,null,null,null,1E-3,{"$f":"C$28-C$98*(1+$E152)^-$C$5+C$34*$J176+SUMPRODUCT(C$35:C$64,$O$176:$O$205)+C$66*$J176+SUMPRODUCT(C$67:C$96,$O$176:$O$205)+C$30*$C$9*$K176+C$31*$C$13*$L176+C$32*$C$17*$M176","v":4621588.5386890462},{"$f":"D$28-D$98*(1+$E152)^-$C$5+D$34*$J176+SUMPRODUCT(D$35:D$64,$O$176:$O$205)+D$66*$J176+SUMPRODUCT(D$67:D$96,$O$176:$O$205)+D$30*$C$9*$K176+D$31*$C$13*$L176+D$32*$C$17*$M176","v":1714954.1547303814}]
[null,null,null,null,0.02,{"$f":"C$28-C$98*(1+$E153)^-$C$5+C$34*$J177+SUMPRODUCT(C$35:C$64,$P$176:$P$205)+C$66*$J177+SUMPRODUCT(C$67:C$96,$P$176:$P$205)+C$30*$C$9*$K177+C$31*$C$13*$L177+C$32*$C$17*$M177","v":3683426.5447344477},{"$f":"D$28-D$98*(1+$E153)^-$C$5+D$34*$J177+SUMPRODUCT(D$35:D$64,$P$176:$P$205)+D$66*$J177+SUMPRODUCT(D$67:D$96,$P$176:$P$205)+D$30*$C$9*$K177+D$31*$C$13*$L177+D$32*$C$17*$M177","v":1372915.9277677673}]
[null,null,null,null,0.04,{"$f":"C$28-C$98*(1+$E154)^-$C$5+C$34*$J178+SUMPRODUCT(C$35:C$64,$Q$176:$Q$205)+C$66*$J178+SUMPRODUCT(C$67:C$96,$Q$176:$Q$205)+C$30*$C$9*$K178+C$31*$C$13*$L178+C$32*$C$17*$M178","v":2949098.7004204933},{"$f":"D$28-D$98*(1+$E154)^-$C$5+D$34*$J178+SUMPRODUCT(D$35:D$64,$Q$176:$Q$205)+D$66*$J178+SUMPRODUCT(D$67:D$96,$Q$176:$Q$205)+D$30*$C$9*$K178+D$31*$C$13*$L178+D$32*$C$17*$M178","v":1105192.2345283048}]
[null,null,null,null,0.06,{"$f":"C$28-C$98*(1+$E155)^-$C$5+C$34*$J179+SUMPRODUCT(C$35:C$64,$R$176:$R$205)+C$66*$J179+SUMPRODUCT(C$67:C$96,$R$176:$R$205)+C$30*$C$9*$K179+C$31*$C$13*$L179+C$32*$C$17*$M179","v":2400000},{"$f":"D$28-D$98*(1+$E155)^-$C$5+D$34*$J179+SUMPRODUCT(D$35:D$64,$R$176:$R$205)+D$66*$J179+SUMPRODUCT(D$67:D$96,$R$176:$R$205)+D$30*$C$9*$K179+D$31*$C$13*$L179+D$32*$C$17*$M179","v":905000}]
[null,null,null,null,0.08,{"$f":"C$28-C$98*(1+$E156)^-$C$5+C$34*$J180+SUMPRODUCT(C$35:C$64,$S$176:$S$205)+C$66*$J180+SUMPRODUCT(C$67:C$96,$S$176:$S$205)+C$30*$C$9*$K180+C$31*$C$13*$L180+C$32*$C$17*$M180","v":1983778.3412811419},{"$f":"D$28-D$98*(1+$E156)^-$C$5+D$34*$J180+SUMPRODUCT(D$35:D$64,$S$176:$S$205)+D$66*$J180+SUMPRODUCT(D$67:D$96,$S$176:$S$205)+D$30*$C$9*$K180+D$31*$C$13*$L180+D$32*$C$17*$M180","v":753252.5202587496}]
[null,null,null,null,0.1,{"$f":"C$28-C$98*(1+$E157)^-$C$5+C$34*$J181+SUMPRODUCT(C$35:C$64,$T$176:$T$205)+C$66*$J181+SUMPRODUCT(C$67:C$96,$T$176:$T$205)+C$30*$C$9*$K181+C$31*$C$13*$L181+C$32*$C$17*$M181","v":1664029.598148237},{"$f":"D$28-D$98*(1+$E157)^-$C$5+D$34*$J181+SUMPRODUCT(D$35:D$64,$T$176:$T$205)+D$66*$J181+SUMPRODUCT(D$67:D$96,$T$176:$T$205)+D$30*$C$9*$K181+D$31*$C$13*$L181+D$32*$C$17*$M181","v":636677.45765821147}]
[null,null,null,null,0.12,{"$f":"C$28-C$98*(1+$E158)^-$C$5+C$34*$J182+SUMPRODUCT(C$35:C$64,$U$176:$U$205)+C$66*$J182+SUMPRODUCT(C$67:C$96,$U$176:$U$205)+C$30*$C$9*$K182+C$31*$C$13*$L182+C$32*$C$17*$M182","v":1415156.4776907573},{"$f":"D$28-D$98*(1+$E158)^-$C$5+D$34*$J182+SUMPRODUCT(D$35:D$64,$U$176:$U$205)+D$66*$J182+SUMPRODUCT(D$67:D$96,$U$176:$U$205)+D$30*$C$9*$K182+D$31*$C$13*$L182+D$32*$C$17*$M182","v":545942.46582475526}]
[null,null,null,null,0.14000000000000001,{"$f":"C$28-C$98*(1+$E159)^-$C$5+C$34*$J183+SUMPRODUCT(C$35:C$64,$V$176:$V$205)+C$66*$J183+SUMPRODUCT(C$67:C$96,$V$176:$V$205)+C$30*$C$9*$K183+C$31*$C$13*$L183+C$32*$C$17*$M183","v":1218962.8436179622},{"$f":"D$28-D$98*(1+$E159)^-$C$5+D$34*$J183+SUMPRODUCT(D$35:D$64,$V$176:$V$205)+D$66*$J183+SUMPRODUCT(D$67:D$96,$V$176:$V$205)+D$30*$C$9*$K183+D$31*$C$13*$L183+D$32*$C$17*$M183","v":474413.5367357154}]
[]
[]
[]
[]
[]
[]
[null,"Testa gärna också att variera andra osäkra indata, t.ex. investeringskostnader eller energipriser!"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Alt C"]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E152)^-$C$5+E$34*$J176+SUMPRODUCT(E$35:E$64,$O$176:$O$205)+E$66*$J176+SUMPRODUCT(E$67:E$96,$O$176:$O$205)+E$30*$C$9*$K176+E$31*$C$13*$L176+E$32*$C$17*$M176","v":0},null,{"$f":"(1-(1+$E152)^-$C$5)/$E152","v":19.791531187324907},{"$f":"IF($E152=$C$10,$C$5,((1-((1+$C$10)/(1+$E152))^$C$5)/((1+$E152)/(1+$C$10)-1)))","v":38.513237822408719},{"$f":"IF($E152=$C$14,$C$5,((1-((1+$C$14)/(1+$E152))^$C$5)/((1+$E152)/(1+$C$14)-1)))","v":38.513237822408719},{"$f":"IF($E152=$C$18,$C$5,((1-((1+$C$18)/(1+$E152))^$C$5)/((1+$E152)/(1+$C$18)-1)))","v":19.791531187326864},null,{"$f":"(1+$E$152)^-1","v":0.99900099900099915},{"$f":"(1+$E$153)^-1","v":0.98039215686274506},{"$f":"(1+$E$154)^-1","v":0.96153846153846145},{"$f":"(1+$E$155)^-1","v":0.94339622641509424},{"$f":"(1+$E$156)^-1","v":0.92592592592592582},{"$f":"(1+$E$157)^-1","v":0.90909090909090906},{"$f":"(1+$E$158)^-1","v":0.89285714285714279},{"$f":"(1+$E$159)^-1","v":0.8771929824561403}]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E153)^-$C$5+E$34*$J177+SUMPRODUCT(E$35:E$64,$P$176:$P$205)+E$66*$J177+SUMPRODUCT(E$67:E$96,$P$176:$P$205)+E$30*$C$9*$K177+E$31*$C$13*$L177+E$32*$C$17*$M177","v":0},null,16.351433344597112,30.695221206120397,30.695221206120397,16.35143334459713,null,{"$f":"(1+$E$152)^-2","v":0.99800299600499431},{"$f":"(1+$E$153)^-2","v":0.96116878123798544},{"$f":"(1+$E$154)^-2","v":0.92455621301775137},{"$f":"(1+$E$155)^-2","v":0.88999644001423983},{"$f":"(1+$E$156)^-2","v":0.85733882030178321},{"$f":"(1+$E$157)^-2","v":0.82644628099173545},{"$f":"(1+$E$158)^-2","v":0.79719387755102034},{"$f":"(1+$E$159)^-2","v":0.76946752847029842}]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E154)^-$C$5+E$34*$J178+SUMPRODUCT(E$35:E$64,$Q$176:$Q$205)+E$66*$J178+SUMPRODUCT(E$67:E$96,$Q$176:$Q$205)+E$30*$C$9*$K178+E$31*$C$13*$L178+E$32*$C$17*$M178","v":0},null,13.590326344967698,24.57582250350411,24.57582250350411,13.5903263449677,null,{"$f":"(1+$E$152)^-$B37","v":0.99700599001497947},{"$f":"(1+$E$153)^-$B37","v":0.94232233454704462},{"$f":"(1+$E$154)^-$B37","v":0.88899635867091487},{"$f":"(1+$E$155)^-$B37","v":0.8396192830323016},{"$f":"(1+$E$156)^-$B37","v":0.79383224102016958},{"$f":"(1+$E$157)^-$B37","v":0.75131480090157754},{"$f":"(1+$E$158)^-$B37","v":0.71178024781341087},{"$f":"(1+$E$159)^-$B37","v":0.67497151620201612}]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E155)^-$C$5+E$34*$J179+SUMPRODUCT(E$35:E$64,$R$176:$R$205)+E$66*$J179+SUMPRODUCT(E$67:E$96,$R$176:$R$205)+E$30*$C$9*$K179+E$31*$C$13*$L179+E$32*$C$17*$M179","v":0},null,11.469921218565263,20,20,11.469921218565261,null,0.99600998003494456,0.9238454260265142,0.85480419102972571,0.79209366323802044,0.73502985279645328,0.68301345536507052,0.63551807840483121,0.59208027737018942]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E156)^-$C$5+E$34*$J180+SUMPRODUCT(E$35:E$64,$S$176:$S$205)+E$66*$J180+SUMPRODUCT(E$67:E$96,$S$176:$S$205)+E$30*$C$9*$K180+E$31*$C$13*$L180+E$32*$C$17*$M180","v":0},null,9.8181474074492936,16.531486177342849,16.531486177342849,9.8181474074492865,null,0.99501496506987486,0.90573080982991594,0.82192710675935154,0.74725817286605689,0.68058319703375303,0.62092132305915493,0.56742685571859919,0.51936866435981521]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E157)^-$C$5+E$34*$J181+SUMPRODUCT(E$35:E$64,$T$176:$T$205)+E$66*$J181+SUMPRODUCT(E$67:E$96,$T$176:$T$205)+E$30*$C$9*$K181+E$31*$C$13*$L181+E$32*$C$17*$M181","v":0},null,8.5135637197585652,13.866913317901975,13.866913317901975,8.5135637197585563,null,0.99402094412574937,0.88797138218619198,0.79031452573014571,0.70496054043967626,0.63016962688310452,0.56447393005377722,0.50663112117732068,0.45558654768404844]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E158)^-$C$5+E$34*$J182+SUMPRODUCT(E$35:E$64,$U$176:$U$205)+E$66*$J182+SUMPRODUCT(E$67:E$96,$U$176:$U$205)+E$30*$C$9*$K182+E$31*$C$13*$L182+E$32*$C$17*$M182","v":0},null,7.4694436243275977,11.792970647422978,11.792970647422978,7.4694436243275897,null,0.99302791620954001,0.87056017861391388,0.75991781320206331,0.66505711362233599,0.58349039526213387,0.51315811823070645,0.45234921533689343,0.39963732252986695]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E159)^-$C$5+E$34*$J183+SUMPRODUCT(E$35:E$64,$V$176:$V$205)+E$66*$J183+SUMPRODUCT(E$67:E$96,$V$176:$V$205)+E$30*$C$9*$K183+E$31*$C$13*$L183+E$32*$C$17*$M183","v":0},null,6.6231305516159438,10.158023696816352,10.158023696816352,6.6231305516159384,null,0.99203588032921075,0.85349037119011162,0.73069020500198378,0.62741237134182648,0.54026888450197574,0.46650738020973315,0.4038832279793691,0.35055905485076044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99104483549371702,0.83675526587265847,0.70258673557883045,0.59189846353002495,0.50024896713145905,0.42409761837248466,0.36061002498157957,0.3075079428515442]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99005478071300423,0.82034829987515534,0.67556416882579851,0.55839477691511785,0.46319348808468425,0.38554328942953148,0.32197323659069599,0.26974380951889843]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98906571499800655,0.80426303909328967,0.6495809315632679,0.52678752539162055,0.42888285933767062,0.3504938994813922,0.28747610409883567,0.23661737677096348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98807763736064591,0.78849317558165644,0.62459704958006512,0.4969693635770005,0.39711375864599124,0.31863081771035656,0.25667509294538904,0.20755910243066969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98709054681383213,0.77303252508005538,0.600574086134678,0.46883902224245327,0.36769792467221413,0.28966437973668779,0.22917419012981158,0.18206938809707865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.986104442371461,0.75787502458828948,0.57747508282180582,0.44230096437967292,0.34046104136316119,0.26333125430607973,0.20461981261590317,0.15970998955884091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98511932304841265,0.74301472998851925,0.55526450271327477,0.41726506073554037,0.31524170496588994,0.23939204936916339,0.18269626126419927,0.1400964820691587]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98413518786055221,0.72844581371423445,0.53390817568584104,0.39364628371277405,0.29189046756100923,0.21762913579014853,0.16312166184303503,0.12289165093785848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98315203582472765,0.7141625624649357,0.51337324585177024,0.37136441859695657,0.27026895144537894,0.19784466890013502,0.14564434093128129,0.107799693805139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98216986595876898,0.7001593749656233,0.49362812101131748,0.35034379112920433,0.25024902911609154,0.17985878990921364,0.13003959011721541,9.4561134916788581E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98118867728148773,0.68643075977021895,0.47464242404934376,0.3305130104992493,0.23171206399638106,0.16350799082655781,0.1161067768903709,8.2948363962095248E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98020846881267509,0.67297133310805779,0.45638694620129205,0.31180472688608429,0.21454820740405653,0.14864362802414349,0.1036667650806883,7.2761722773767745E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97922923957310215,0.65977581677260566,0.43883360211662686,0.29415540272272095,0.19865574759634863,0.13513057093103953,9.2559611679185971E-2,6.3826072608568193E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97825098858451787,0.64683903605157411,0.42195538665060278,0.27750509690822728,0.18394050703365611,0.12284597357367227,8.2642510427844609E-2,5.5987782989972097E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97727371486964842,0.63415591769762181,0.40572633331788732,0.26179726123417668,0.17031528429042234,0.11167815779424752,7.3787955739146982E-2,4.9112090342080778E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.976297417452196,0.62172148793884485,0.39012147434412242,0.24697854833412897,0.1576993373059466,0.10152559799477048,6.5882103338524081E-2,4.3080781001825233E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97532209535683934,0.60953087052827937,0.37511680225396377,0.23299863050389524,0.1460179049129135,9.2295998177064048E-2,5.8823306552253637E-2,3.779015877353091E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97434774760923015,0.59757928483164635,0.36068923293650368,0.21981002877725966,0.13520176380825324,8.3905452888240042E-2,5.2520809421655032E-2,3.3149262082044648E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97337437323599441,0.58586204395259456,0.3468165701312535,0.20736795167666003,0.12518681834097523,7.6277684443854576E-2,4.6893579840763415E-2,2.9078300071968988E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97240197126472983,0.57437455289470041,0.3334774712800514,0.1956301430911887,0.11591372068608817,6.9343349494413245E-2,4.1869267714967337E-2,2.5507280764885072E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97143054072400581,0.56311230675951029,0.32065141469235708,0.18455673876527234,0.10732751915378534,6.3039408631284766E-2,3.7383274745506546E-2,2.2374807688495677E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97046008064336287,0.55207088897991197,0.30831866797342034,0.17411013091063426,9.9377332549801231E-2,5.7308553301167964E-2,3.3377923879916553E-2,1.9627024288154101E-2]

{"sheet":"Fjärrvärme","index":2,"n_rows":206,"n_cols":22,"rows_kept":206,"cut":false,"hidden":false,"merged":[[7,0,19,0],[112,1,112,4]]}
["Lönsamhetsberäkningar med hjälp av LCC och återbetalningstid"]
[]
[null,"Generella indata",null,null,null,null,null,"Indata beräkningsexempel"]
[]
[null,"Kalkylperiod (år)",20,null,null,null,null,"Nuvarande bränsleförbrukning (kWh/år)",100000,"Detta värde förs in i cell C30"]
[null,"Kalkylränta (%)",0.05,null,null,null,null,"Verkningsgrad panna (%)",0.7]
[null,null,null,null,null,null,null,"Verkningsgrad fjärrvärme (%)",0.9]
[null,"Energislag 1","Olja"]
[null,"Energipris energislag (kr/kWh)",1.2,"Se faktaruta Energipriser och utsläppsfaktorer",null,null,null,"Årligt uppvärmningsbehov (kWh/år)",{"$f":"I5*I6","v":70000}]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Årligt energibehov fjärrvärme (kWh/år)",{"$f":"I9/I7","v":77777.777777777781},"Detta värde förs in i cell D31"]
[null,"Utsläppsfaktor (gCO2e/kWh)",288,null,null,null,null,"Årliga utsläpp oljepanna (kgCO2e/år)",{"$f":"I5*C11/1000","v":28800}]
[null,"Energislag 2","Fjärrvärme",null,null,null,null,"Årliga utsläpp fjärrvärme (kgCO2e/år)",{"$f":"I10*C15/1000","v":4666.666666666667}]
[null,"Energipris energislag (kr/kWh)",0.65,"Se faktaruta Energipriser och utsläppsfaktorer",null,null,null,"Årlig energibesparing (kWh/år)",{"$f":"I5-I10","v":22222.222222222219}]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Årlig energibesparing (kr/år)",{"$f":"I5*C9-C13*I10","v":69444.444444444438}]
[null,"Utsläppsfaktor (gCO2e/kWh)",60,null,null,null,null,"Årlig utsläppsminskning (kgCO2e/år)",{"$f":"I11-I12","v":24133.333333333332}]
[null,"Energislag 3"]
[null,"Energipris energislag (kr/kWh)"]
[null,"Förväntad real årlig energiprisförändring (%)"]
[null,"Utsläppsfaktor (gCO2e/kWh)"]
[]
[null,"Nusummefaktor",{"$f":"IF($C$6=0,$C$5,(1-(1+$C$6)^-$C$5)/$C$6)","v":12.462210342539986}]
[null,"Nusummefaktor energislag 1",{"$f":"IF($C$6=$C$10,$C$5,((1-((1+$C$10)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$10)-1)))","v":22.125976740351309}]
[null,"Nusummefaktor energislag 2",{"$f":"IF($C$6=$C$14,$C$5,((1-((1+$C$14)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$14)-1)))","v":22.125976740351309}]
[null,"Nusummefaktor energislag 3",{"$f":"IF($C$6=$C$18,$C$5,((1-((1+$C$18)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$18)-1)))","v":12.462210342539979}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Behåll oljepanna","Installera fjärrvärme"]
[null,"Investeringskostnad (kr)",0,50000,null,"Se faktaruta Kostnader"]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",{"$f":"I5","v":100000}]
[null,"Årligt energibehov, energislag 2 (kWh) ",null,{"$f":"I10","v":77777.777777777781}]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)"]
[null,"Underhållskostnad år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B38","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B39","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,{"$f":"(1+$C$6)^-B53","v":0.41552065486748313}]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Övriga årliga kostnader (kr/år)"]
[null,"Övriga kostnader år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B70","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B71","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,0.41552065486748313]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)"]
[]
[null,"Beräkningar och resultat"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Nuvärde investering minus restvärde (kr)",{"$f":"C29-C99*(1+$C$6)^-$C$5","v":0},{"$f":"D29-D99*(1+$C$6)^-$C$5","v":50000},{"$f":"E29-E99*(1+$C$6)^-$C$5","v":0},"Investering minus restvärde"]
[null,"Nuvärde drift- och underhållskostnader (kr)",{"$f":"C35*$C$21+SUMPRODUCT(C36:C65,$F$36:$F$65)","v":0},{"$f":"D35*$C$21+SUMPRODUCT(D36:D65,$F$36:$F$65)","v":0},{"$f":"E35*$C$21+SUMPRODUCT(E36:E65,$F$36:$F$65)","v":0},"Drift- och underhållskostnader"]
[null,"Nuvärde övriga kostnader (kr)",{"$f":"C67*$C$21+SUMPRODUCT(C68:C97,$F$68:$F$97)","v":0},{"$f":"D67*$C$21+SUMPRODUCT(D68:D97,$F$68:$F$97)","v":0},{"$f":"E67*$C$21+SUMPRODUCT(E68:E97,$F$68:$F$97)","v":0},"Övriga kostnader"]
[null,"Nuvärde energikostnader (kr)",{"$f":"C31*$C$9*$C$22+C32*$C$13*$C$23+C33*$C$17*$C$24","v":2655117.2088421569},{"$f":"D31*$C$9*$C$22+D32*$C$13*$C$23+D33*$C$17*$C$24","v":1118591.0463177608},{"$f":"E31*$C$9*$C$22+E32*$C$13*$C$23+E33*$C$17*$C$24","v":0},"Energikostnader"]
[null,"Livscykelkostnad, LCC (kr)",{"$f":"SUM(C103:C106)","v":2655117.2088421569},{"$f":"IF(SUM(D103:D106)=0,\"-\",SUM(D103:D106))","v":1168591.0463177608},{"$f":"IF(SUM(E103:E106)=0,\"-\",SUM(E103:E106))","v":"-"}]
[]
[]
[null,"Lönsamhetsbedömning av åtgärd B och C (jämfört mot Alt A)"]
[null,"Rak återbetalningstid, payoff (år)",null,{"$f":"IF(AND(D29>$C$29,(D31-$C$31)*$C$9+(D32-$C$32)*$C$13+(D33-$C$33)*$C$17+(D35-$C$35)+(D67-$C$67)>0),\"återbetalas ej\",IF(OR(D107=\"-\",D29<$C$29),\"-\",(D29-$C$29)/(($C$31-D31)*$C$9+($C$32-D32)*$C$13+($C$33-D33)*$C$17+($C$35-D35)+($C$67-D67))))","v":0.72000000000000008},{"$f":"IF(AND(E29>$C$29,(E31-$C$31)*$C$9+(E32-$C$32)*$C$13+(E33-$C$33)*$C$17+(E35-$C$35)+(E67-$C$67)>0),\"återbetalas ej\",IF(OR(E107=\"-\",E29<$C$29),\"-\",(E29-$C$29)/(($C$31-E31)*$C$9+($C$32-E32)*$C$13+($C$33-E33)*$C$17+($C$35-E35)+($C$67-E67))))","v":"-"}]
[null,"Nettonuvärde av investering, Minskning LCC (kr)",null,{"$f":"IF(D107=\"-\",\"-\",C107-D107)","v":1486526.1625243961},{"$f":"IF(E107=\"-\",\"-\",C107-E107)","v":"-"}]
[null,{"$f":"IF(OR(AND(ISNUMBER(D107),D29<C29),AND(ISNUMBER(E107),E29<C29)),\"!!! För att uträkningen av återbetalningstid ska ge ett meningsfullt resultat behöver Alt A vara det alternativ som har lägst investeringskostnad !!!\",\"\")","v":""}]
[]
[null,"Summering av resultat"]
[null,"Av Alt A, B och C har ",{"$f":"IF(SMALL(C107:E107,1)=C107,C27,IF(D107<E107,D27,E27))","v":"Alt B"}," lägst LCC-kostnad"]
[]
[]
[null,"Jämförelse LCC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jämförelse Återbetalningstid"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Känslighetsanalys"]
[]
[null,null,null,null,null,"Alt A","Alt B"]
[null,null,null,null,1E-3,{"$f":"C$29-C$99*(1+$E153)^-$C$5+C$35*$J177+SUMPRODUCT(C$36:C$65,$O$177:$O$206)+C$67*$J177+SUMPRODUCT(C$68:C$97,$O$177:$O$206)+C$31*$C$9*$K177+C$32*$C$13*$L177+C$33*$C$17*$M177","v":4621588.5386890462},{"$f":"D$29-D$99*(1+$E153)^-$C$5+D$35*$J177+SUMPRODUCT(D$36:D$65,$O$177:$O$206)+D$67*$J177+SUMPRODUCT(D$68:D$97,$O$177:$O$206)+D$31*$C$9*$K177+D$32*$C$13*$L177+D$33*$C$17*$M177","v":1997058.1343551078}]
[null,null,null,null,0.02,{"$f":"C$29-C$99*(1+$E154)^-$C$5+C$35*$J178+SUMPRODUCT(C$36:C$65,$P$177:$P$206)+C$67*$J178+SUMPRODUCT(C$68:C$97,$P$177:$P$206)+C$31*$C$9*$K178+C$32*$C$13*$L178+C$33*$C$17*$M178","v":3683426.5447344477},{"$f":"D$29-D$99*(1+$E154)^-$C$5+D$35*$J178+SUMPRODUCT(D$36:D$65,$P$177:$P$206)+D$67*$J178+SUMPRODUCT(D$68:D$97,$P$177:$P$206)+D$31*$C$9*$K178+D$32*$C$13*$L178+D$33*$C$17*$M178","v":1601813.960976087}]
[null,null,null,null,0.04,{"$f":"C$29-C$99*(1+$E155)^-$C$5+C$35*$J179+SUMPRODUCT(C$36:C$65,$Q$177:$Q$206)+C$67*$J179+SUMPRODUCT(C$68:C$97,$Q$177:$Q$206)+C$31*$C$9*$K179+C$32*$C$13*$L179+C$33*$C$17*$M179","v":2949098.7004204933},{"$f":"D$29-D$99*(1+$E155)^-$C$5+D$35*$J179+SUMPRODUCT(D$36:D$65,$Q$177:$Q$206)+D$67*$J179+SUMPRODUCT(D$68:D$97,$Q$177:$Q$206)+D$31*$C$9*$K179+D$32*$C$13*$L179+D$33*$C$17*$M179","v":1292444.3598993747}]
[null,null,null,null,0.06,{"$f":"C$29-C$99*(1+$E156)^-$C$5+C$35*$J180+SUMPRODUCT(C$36:C$65,$R$177:$R$206)+C$67*$J180+SUMPRODUCT(C$68:C$97,$R$177:$R$206)+C$31*$C$9*$K180+C$32*$C$13*$L180+C$33*$C$17*$M180","v":2400000},{"$f":"D$29-D$99*(1+$E156)^-$C$5+D$35*$J180+SUMPRODUCT(D$36:D$65,$R$177:$R$206)+D$67*$J180+SUMPRODUCT(D$68:D$97,$R$177:$R$206)+D$31*$C$9*$K180+D$32*$C$13*$L180+D$33*$C$17*$M180","v":1061111.1111111112}]
[null,null,null,null,0.08,{"$f":"C$29-C$99*(1+$E157)^-$C$5+C$35*$J181+SUMPRODUCT(C$36:C$65,$S$177:$S$206)+C$67*$J181+SUMPRODUCT(C$68:C$97,$S$177:$S$206)+C$31*$C$9*$K181+C$32*$C$13*$L181+C$33*$C$17*$M181","v":1983778.3412811419},{"$f":"D$29-D$99*(1+$E157)^-$C$5+D$35*$J181+SUMPRODUCT(D$36:D$65,$S$177:$S$206)+D$67*$J181+SUMPRODUCT(D$68:D$97,$S$177:$S$206)+D$31*$C$9*$K181+D$32*$C$13*$L181+D$33*$C$17*$M181","v":885758.46785455523}]
[null,null,null,null,0.1,{"$f":"C$29-C$99*(1+$E158)^-$C$5+C$35*$J182+SUMPRODUCT(C$36:C$65,$T$177:$T$206)+C$67*$J182+SUMPRODUCT(C$68:C$97,$T$177:$T$206)+C$31*$C$9*$K182+C$32*$C$13*$L182+C$33*$C$17*$M182","v":1664029.598148237},{"$f":"D$29-D$99*(1+$E158)^-$C$5+D$35*$J182+SUMPRODUCT(D$36:D$65,$T$177:$T$206)+D$67*$J182+SUMPRODUCT(D$68:D$97,$T$177:$T$206)+D$31*$C$9*$K182+D$32*$C$13*$L182+D$33*$C$17*$M182","v":751049.50662726664}]
[null,null,null,null,0.12,{"$f":"C$29-C$99*(1+$E159)^-$C$5+C$35*$J183+SUMPRODUCT(C$36:C$65,$U$177:$U$206)+C$67*$J183+SUMPRODUCT(C$68:C$97,$U$177:$U$206)+C$31*$C$9*$K183+C$32*$C$13*$L183+C$33*$C$17*$M183","v":1415156.4776907573},{"$f":"D$29-D$99*(1+$E159)^-$C$5+D$35*$J183+SUMPRODUCT(D$36:D$65,$U$177:$U$206)+D$67*$J183+SUMPRODUCT(D$68:D$97,$U$177:$U$206)+D$31*$C$9*$K183+D$32*$C$13*$L183+D$33*$C$17*$M183","v":646200.18273082841}]
[null,null,null,null,0.14000000000000001,{"$f":"C$29-C$99*(1+$E160)^-$C$5+C$35*$J184+SUMPRODUCT(C$36:C$65,$V$177:$V$206)+C$67*$J184+SUMPRODUCT(C$68:C$97,$V$177:$V$206)+C$31*$C$9*$K184+C$32*$C$13*$L184+C$33*$C$17*$M184","v":1218962.8436179622},{"$f":"D$29-D$99*(1+$E160)^-$C$5+D$35*$J184+SUMPRODUCT(D$36:D$65,$V$177:$V$206)+D$67*$J184+SUMPRODUCT(D$68:D$97,$V$177:$V$206)+D$31*$C$9*$K184+D$32*$C$13*$L184+D$33*$C$17*$M184","v":563544.53133904899}]
[]
[]
[]
[]
[]
[]
[null,"Testa gärna också att variera andra osäkra indata, t.ex. investeringskostnader eller energipriser!"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Alt C"]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E153)^-$C$5+E$35*$J177+SUMPRODUCT(E$36:E$65,$O$177:$O$206)+E$67*$J177+SUMPRODUCT(E$68:E$97,$O$177:$O$206)+E$31*$C$9*$K177+E$32*$C$13*$L177+E$33*$C$17*$M177","v":0},null,{"$f":"(1-(1+$E153)^-$C$5)/$E153","v":19.791531187324907},{"$f":"IF($E153=$C$10,$C$5,((1-((1+$C$10)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$10)-1)))","v":38.513237822408719},{"$f":"IF($E153=$C$14,$C$5,((1-((1+$C$14)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$14)-1)))","v":38.513237822408719},{"$f":"IF($E153=$C$18,$C$5,((1-((1+$C$18)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$18)-1)))","v":19.791531187326864},null,{"$f":"(1+$E$153)^-1","v":0.99900099900099915},{"$f":"(1+$E$154)^-1","v":0.98039215686274506},{"$f":"(1+$E$155)^-1","v":0.96153846153846145},{"$f":"(1+$E$156)^-1","v":0.94339622641509424},{"$f":"(1+$E$157)^-1","v":0.92592592592592582},{"$f":"(1+$E$158)^-1","v":0.90909090909090906},{"$f":"(1+$E$159)^-1","v":0.89285714285714279},{"$f":"(1+$E$160)^-1","v":0.8771929824561403}]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E154)^-$C$5+E$35*$J178+SUMPRODUCT(E$36:E$65,$P$177:$P$206)+E$67*$J178+SUMPRODUCT(E$68:E$97,$P$177:$P$206)+E$31*$C$9*$K178+E$32*$C$13*$L178+E$33*$C$17*$M178","v":0},null,16.351433344597112,30.695221206120397,30.695221206120397,16.35143334459713,null,{"$f":"(1+$E$153)^-2","v":0.99800299600499431},{"$f":"(1+$E$154)^-2","v":0.96116878123798544},{"$f":"(1+$E$155)^-2","v":0.92455621301775137},{"$f":"(1+$E$156)^-2","v":0.88999644001423983},{"$f":"(1+$E$157)^-2","v":0.85733882030178321},{"$f":"(1+$E$158)^-2","v":0.82644628099173545},{"$f":"(1+$E$159)^-2","v":0.79719387755102034},{"$f":"(1+$E$160)^-2","v":0.76946752847029842}]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E155)^-$C$5+E$35*$J179+SUMPRODUCT(E$36:E$65,$Q$177:$Q$206)+E$67*$J179+SUMPRODUCT(E$68:E$97,$Q$177:$Q$206)+E$31*$C$9*$K179+E$32*$C$13*$L179+E$33*$C$17*$M179","v":0},null,13.590326344967698,24.57582250350411,24.57582250350411,13.5903263449677,null,{"$f":"(1+$E$153)^-$B38","v":0.99700599001497947},{"$f":"(1+$E$154)^-$B38","v":0.94232233454704462},{"$f":"(1+$E$155)^-$B38","v":0.88899635867091487},{"$f":"(1+$E$156)^-$B38","v":0.8396192830323016},{"$f":"(1+$E$157)^-$B38","v":0.79383224102016958},{"$f":"(1+$E$158)^-$B38","v":0.75131480090157754},{"$f":"(1+$E$159)^-$B38","v":0.71178024781341087},{"$f":"(1+$E$160)^-$B38","v":0.67497151620201612}]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E156)^-$C$5+E$35*$J180+SUMPRODUCT(E$36:E$65,$R$177:$R$206)+E$67*$J180+SUMPRODUCT(E$68:E$97,$R$177:$R$206)+E$31*$C$9*$K180+E$32*$C$13*$L180+E$33*$C$17*$M180","v":0},null,11.469921218565263,20,20,11.469921218565261,null,0.99600998003494456,0.9238454260265142,0.85480419102972571,0.79209366323802044,0.73502985279645328,0.68301345536507052,0.63551807840483121,0.59208027737018942]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E157)^-$C$5+E$35*$J181+SUMPRODUCT(E$36:E$65,$S$177:$S$206)+E$67*$J181+SUMPRODUCT(E$68:E$97,$S$177:$S$206)+E$31*$C$9*$K181+E$32*$C$13*$L181+E$33*$C$17*$M181","v":0},null,9.8181474074492936,16.531486177342849,16.531486177342849,9.8181474074492865,null,0.99501496506987486,0.90573080982991594,0.82192710675935154,0.74725817286605689,0.68058319703375303,0.62092132305915493,0.56742685571859919,0.51936866435981521]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E158)^-$C$5+E$35*$J182+SUMPRODUCT(E$36:E$65,$T$177:$T$206)+E$67*$J182+SUMPRODUCT(E$68:E$97,$T$177:$T$206)+E$31*$C$9*$K182+E$32*$C$13*$L182+E$33*$C$17*$M182","v":0},null,8.5135637197585652,13.866913317901975,13.866913317901975,8.5135637197585563,null,0.99402094412574937,0.88797138218619198,0.79031452573014571,0.70496054043967626,0.63016962688310452,0.56447393005377722,0.50663112117732068,0.45558654768404844]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E159)^-$C$5+E$35*$J183+SUMPRODUCT(E$36:E$65,$U$177:$U$206)+E$67*$J183+SUMPRODUCT(E$68:E$97,$U$177:$U$206)+E$31*$C$9*$K183+E$32*$C$13*$L183+E$33*$C$17*$M183","v":0},null,7.4694436243275977,11.792970647422978,11.792970647422978,7.4694436243275897,null,0.99302791620954001,0.87056017861391388,0.75991781320206331,0.66505711362233599,0.58349039526213387,0.51315811823070645,0.45234921533689343,0.39963732252986695]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E160)^-$C$5+E$35*$J184+SUMPRODUCT(E$36:E$65,$V$177:$V$206)+E$67*$J184+SUMPRODUCT(E$68:E$97,$V$177:$V$206)+E$31*$C$9*$K184+E$32*$C$13*$L184+E$33*$C$17*$M184","v":0},null,6.6231305516159438,10.158023696816352,10.158023696816352,6.6231305516159384,null,0.99203588032921075,0.85349037119011162,0.73069020500198378,0.62741237134182648,0.54026888450197574,0.46650738020973315,0.4038832279793691,0.35055905485076044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99104483549371702,0.83675526587265847,0.70258673557883045,0.59189846353002495,0.50024896713145905,0.42409761837248466,0.36061002498157957,0.3075079428515442]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99005478071300423,0.82034829987515534,0.67556416882579851,0.55839477691511785,0.46319348808468425,0.38554328942953148,0.32197323659069599,0.26974380951889843]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98906571499800655,0.80426303909328967,0.6495809315632679,0.52678752539162055,0.42888285933767062,0.3504938994813922,0.28747610409883567,0.23661737677096348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98807763736064591,0.78849317558165644,0.62459704958006512,0.4969693635770005,0.39711375864599124,0.31863081771035656,0.25667509294538904,0.20755910243066969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98709054681383213,0.77303252508005538,0.600574086134678,0.46883902224245327,0.36769792467221413,0.28966437973668779,0.22917419012981158,0.18206938809707865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.986104442371461,0.75787502458828948,0.57747508282180582,0.44230096437967292,0.34046104136316119,0.26333125430607973,0.20461981261590317,0.15970998955884091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98511932304841265,0.74301472998851925,0.55526450271327477,0.41726506073554037,0.31524170496588994,0.23939204936916339,0.18269626126419927,0.1400964820691587]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98413518786055221,0.72844581371423445,0.53390817568584104,0.39364628371277405,0.29189046756100923,0.21762913579014853,0.16312166184303503,0.12289165093785848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98315203582472765,0.7141625624649357,0.51337324585177024,0.37136441859695657,0.27026895144537894,0.19784466890013502,0.14564434093128129,0.107799693805139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98216986595876898,0.7001593749656233,0.49362812101131748,0.35034379112920433,0.25024902911609154,0.17985878990921364,0.13003959011721541,9.4561134916788581E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98118867728148773,0.68643075977021895,0.47464242404934376,0.3305130104992493,0.23171206399638106,0.16350799082655781,0.1161067768903709,8.2948363962095248E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98020846881267509,0.67297133310805779,0.45638694620129205,0.31180472688608429,0.21454820740405653,0.14864362802414349,0.1036667650806883,7.2761722773767745E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97922923957310215,0.65977581677260566,0.43883360211662686,0.29415540272272095,0.19865574759634863,0.13513057093103953,9.2559611679185971E-2,6.3826072608568193E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97825098858451787,0.64683903605157411,0.42195538665060278,0.27750509690822728,0.18394050703365611,0.12284597357367227,8.2642510427844609E-2,5.5987782989972097E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97727371486964842,0.63415591769762181,0.40572633331788732,0.26179726123417668,0.17031528429042234,0.11167815779424752,7.3787955739146982E-2,4.9112090342080778E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.976297417452196,0.62172148793884485,0.39012147434412242,0.24697854833412897,0.1576993373059466,0.10152559799477048,6.5882103338524081E-2,4.3080781001825233E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97532209535683934,0.60953087052827937,0.37511680225396377,0.23299863050389524,0.1460179049129135,9.2295998177064048E-2,5.8823306552253637E-2,3.779015877353091E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97434774760923015,0.59757928483164635,0.36068923293650368,0.21981002877725966,0.13520176380825324,8.3905452888240042E-2,5.2520809421655032E-2,3.3149262082044648E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97337437323599441,0.58586204395259456,0.3468165701312535,0.20736795167666003,0.12518681834097523,7.6277684443854576E-2,4.6893579840763415E-2,2.9078300071968988E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97240197126472983,0.57437455289470041,0.3334774712800514,0.1956301430911887,0.11591372068608817,6.9343349494413245E-2,4.1869267714967337E-2,2.5507280764885072E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97143054072400581,0.56311230675951029,0.32065141469235708,0.18455673876527234,0.10732751915378534,6.3039408631284766E-2,3.7383274745506546E-2,2.2374807688495677E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97046008064336287,0.55207088897991197,0.30831866797342034,0.17411013091063426,9.9377332549801231E-2,5.7308553301167964E-2,3.3377923879916553E-2,1.9627024288154101E-2]

{"sheet":"Värmepump","index":3,"n_rows":205,"n_cols":22,"rows_kept":205,"cut":false,"hidden":false,"merged":[[7,0,18,0],[111,1,111,4]]}
["Lönsamhetsberäkningar med hjälp av LCC och återbetalningstid"]
[]
[null,"Generella indata",null,null,null,null,null,"Indata beräkningsexempel"]
[]
[null,"Kalkylperiod (år)",20,null,null,null,null,"Nuvarande bränsleförbrukning (kWh/år)",100000,"Detta värde förs in i cell C30"]
[null,"Kalkylränta (%)",0.05,null,null,null,null,"Verkningsgrad panna (%)",0.7]
[null,null,null,null,null,null,null,"COP värmepump",4,"Se faktaruta Fakta värmepumpar"]
[null,"Energislag 1","Olja"]
[null,"Energipris energislag (kr/kWh)",1.2,"Se faktaruta Energipriser och utsläppsfaktorer",null,null,null,"Årligt upvärmningsbehov (kWh/år)",{"$f":"I5*I6","v":70000}]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Årligt energibehov el (kWh/år)",{"$f":"I9/I7","v":17500},"Detta värde förs in i cell D31"]
[null,"Utsläppsfaktor (gCO2e/kWh)",288,null,null,null,null,"Årliga utsläpp oljepanna (kgCO2e/år)",{"$f":"I5*C11/1000","v":28800}]
[null,"Energislag 2","El",null,null,null,null,"Årliga utsläpp el (kgCO2e/år)",{"$f":"I10*C15/1000","v":2187.5}]
[null,"Energipris energislag (kr/kWh)",1.2,"Se faktaruta Energipriser och utsläppsfaktorer",null,null,null,"Årlig energibesparing (kWh/år)",{"$f":"I5-I10","v":82500}]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Årlig energibesparing (kr/år)",{"$f":"I5*C9-C13*I10","v":99000}]
[null,"Utsläppsfaktor (gCO2e/kWh)",125,null,null,null,null,"Årlig utsläppsminskning (kgCO2e/år)",{"$f":"I11-I12","v":26612.5}]
[null,"Energislag 3"]
[null,"Energipris energislag (kr/kWh)"]
[null,"Förväntad real årlig energiprisförändring (%)"]
[null,"Utsläppsfaktor (gCO2e/kWh)"]
[null,"Nusummefaktor",{"$f":"IF($C$6=0,$C$5,(1-(1+$C$6)^-$C$5)/$C$6)","v":12.462210342539986}]
[null,"Nusummefaktor energislag 1",{"$f":"IF($C$6=$C$10,$C$5,((1-((1+$C$10)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$10)-1)))","v":22.125976740351309}]
[null,"Nusummefaktor energislag 2",{"$f":"IF($C$6=$C$14,$C$5,((1-((1+$C$14)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$14)-1)))","v":22.125976740351309}]
[null,"Nusummefaktor energislag 3",{"$f":"IF($C$6=$C$18,$C$5,((1-((1+$C$18)/(1+$C$6))^$C$5)/((1+$C$6)/(1+$C$18)-1)))","v":12.462210342539979}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Behåll oljepanna","Byt till värmepump"]
[null,"Investeringskostnad (kr)",0,180000,null,"Se faktaruta Kostnader"]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",{"$f":"I5","v":100000}]
[null,"Årligt energibehov, energislag 2 (kWh) ",null,{"$f":"I10","v":17500}]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)"]
[null,"Underhållskostnad år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B37","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B38","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,{"$f":"(1+$C$6)^-B52","v":0.41552065486748313}]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Övriga årliga kostnader (kr/år)"]
[null,"Övriga kostnader år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.95238095238095233}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.90702947845804982}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B69","v":0.86383759853147601}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B70","v":0.82270247479188197}]
[null,5,null,null,null,0.78352616646845896]
[null,6,null,null,null,0.74621539663662761]
[null,7,null,null,null,0.71068133013012147]
[null,8,null,null,null,0.67683936202868722]
[null,9,null,null,null,0.64460891621779726]
[null,10,null,null,null,0.61391325354075932]
[null,11,null,null,null,0.5846792890864374]
[null,12,null,null,null,0.5568374181775595]
[null,13,null,null,null,0.53032135064529462]
[null,14,null,null,null,0.50506795299551888]
[null,15,null,null,null,0.48101709809097021]
[null,16,null,null,null,0.45811152199140021]
[null,17,null,null,null,0.43629668761085727]
[null,18,null,null,null,0.41552065486748313]
[null,19,null,null,null,0.39573395701665059]
[null,20,null,null,null,0.37688948287300061]
[null,21,null,null,null,0.35894236464095297]
[null,22,null,null,null,0.3418498710866219]
[null,23,null,null,null,0.32557130579678267]
[null,24,null,null,null,0.31006791028265024]
[null,25,null,null,null,0.29530277169776209]
[null,26,null,null,null,0.28124073495024959]
[null,27,null,null,null,0.2678483190002377]
[null,28,null,null,null,0.25509363714308358]
[null,29,null,null,null,0.24294632108865097]
[null,30,null,null,null,0.23137744865585813]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)"]
[]
[null,"Beräkningar och resultat"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Nuvärde investering minus restvärde (kr)",{"$f":"C28-C98*(1+$C$6)^-$C$5","v":0},{"$f":"D28-D98*(1+$C$6)^-$C$5","v":180000},{"$f":"E28-E98*(1+$C$6)^-$C$5","v":0},"Investering minus restvärde"]
[null,"Nuvärde drift- och underhållskostnader (kr)",{"$f":"C34*$C$20+SUMPRODUCT(C35:C64,$F$35:$F$64)","v":0},{"$f":"D34*$C$20+SUMPRODUCT(D35:D64,$F$35:$F$64)","v":0},{"$f":"E34*$C$20+SUMPRODUCT(E35:E64,$F$35:$F$64)","v":0},"Drift- och underhållskostnader"]
[null,"Nuvärde övriga kostnader (kr)",{"$f":"C66*$C$20+SUMPRODUCT(C67:C96,$F$67:$F$96)","v":0},{"$f":"D66*$C$20+SUMPRODUCT(D67:D96,$F$67:$F$96)","v":0},{"$f":"E66*$C$20+SUMPRODUCT(E67:E96,$F$67:$F$96)","v":0},"Övriga kostnader"]
[null,"Nuvärde energikostnader (kr)",{"$f":"C30*$C$9*$C$21+C31*$C$13*$C$22+C32*$C$17*$C$23","v":2655117.2088421569},{"$f":"D30*$C$9*$C$21+D31*$C$13*$C$22+D32*$C$17*$C$23","v":464645.51154737751},{"$f":"E30*$C$9*$C$21+E31*$C$13*$C$22+E32*$C$17*$C$23","v":0},"Energikostnader"]
[null,"Livscykelkostnad, LCC (kr)",{"$f":"SUM(C102:C105)","v":2655117.2088421569},{"$f":"IF(SUM(D102:D105)=0,\"-\",SUM(D102:D105))","v":644645.51154737757},{"$f":"IF(SUM(E102:E105)=0,\"-\",SUM(E102:E105))","v":"-"}]
[]
[]
[null,"Lönsamhetsbedömning av åtgärd B och C (jämfört mot Alt A)"]
[null,"Rak återbetalningstid, payoff (år)",null,{"$f":"IF(AND(D28>$C$28,(D30-$C$30)*$C$9+(D31-$C$31)*$C$13+(D32-$C$32)*$C$17+(D34-$C$34)+(D66-$C$66)>0),\"återbetalas ej\",IF(OR(D106=\"-\",D28<$C$28),\"-\",(D28-$C$28)/(($C$30-D30)*$C$9+($C$31-D31)*$C$13+($C$32-D32)*$C$17+($C$34-D34)+($C$66-D66))))","v":1.8181818181818181},{"$f":"IF(AND(E28>$C$28,(E30-$C$30)*$C$9+(E31-$C$31)*$C$13+(E32-$C$32)*$C$17+(E34-$C$34)+(E66-$C$66)>0),\"återbetalas ej\",IF(OR(E106=\"-\",E28<$C$28),\"-\",(E28-$C$28)/(($C$30-E30)*$C$9+($C$31-E31)*$C$13+($C$32-E32)*$C$17+($C$34-E34)+($C$66-E66))))","v":"-"}]
[null,"Nettonuvärde av investering, Minskning LCC (kr)",null,{"$f":"IF(D106=\"-\",\"-\",C106-D106)","v":2010471.6972947794},{"$f":"IF(E106=\"-\",\"-\",C106-E106)","v":"-"}]
[null,{"$f":"IF(OR(AND(ISNUMBER(D106),D28<C28),AND(ISNUMBER(E106),E28<C28)),\"!!! För att uträkningen av återbetalningstid ska ge ett meningsfullt resultat behöver Alt A vara det alternativ som har lägst investeringskostnad !!!\",\"\")","v":""}]
[]
[null,"Summering av resultat"]
[null,"Av Alt A, B och C har ",{"$f":"IF(SMALL(C106:E106,1)=C106,C26,IF(D106<E106,D26,E26))","v":"Alt B"}," lägst LCC-kostnad"]
[]
[]
[null,"Jämförelse LCC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jämförelse Återbetalningstid"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Känslighetsanalys"]
[]
[null,null,null,null,null,"Alt A","Alt B"]
[null,null,null,null,1E-3,{"$f":"C$28-C$98*(1+$E152)^-$C$5+C$34*$J176+SUMPRODUCT(C$35:C$64,$O$176:$O$205)+C$66*$J176+SUMPRODUCT(C$67:C$96,$O$176:$O$205)+C$30*$C$9*$K176+C$31*$C$13*$L176+C$32*$C$17*$M176","v":4621588.5386890462},{"$f":"D$28-D$98*(1+$E152)^-$C$5+D$34*$J176+SUMPRODUCT(D$35:D$64,$O$176:$O$205)+D$66*$J176+SUMPRODUCT(D$67:D$96,$O$176:$O$205)+D$30*$C$9*$K176+D$31*$C$13*$L176+D$32*$C$17*$M176","v":988777.99427058315}]
[null,null,null,null,0.02,{"$f":"C$28-C$98*(1+$E153)^-$C$5+C$34*$J177+SUMPRODUCT(C$35:C$64,$P$176:$P$205)+C$66*$J177+SUMPRODUCT(C$67:C$96,$P$176:$P$205)+C$30*$C$9*$K177+C$31*$C$13*$L177+C$32*$C$17*$M177","v":3683426.5447344477},{"$f":"D$28-D$98*(1+$E153)^-$C$5+D$34*$J177+SUMPRODUCT(D$35:D$64,$P$176:$P$205)+D$66*$J177+SUMPRODUCT(D$67:D$96,$P$176:$P$205)+D$30*$C$9*$K177+D$31*$C$13*$L177+D$32*$C$17*$M177","v":824599.64532852836}]
[null,null,null,null,0.04,{"$f":"C$28-C$98*(1+$E154)^-$C$5+C$34*$J178+SUMPRODUCT(C$35:C$64,$Q$176:$Q$205)+C$66*$J178+SUMPRODUCT(C$67:C$96,$Q$176:$Q$205)+C$30*$C$9*$K178+C$31*$C$13*$L178+C$32*$C$17*$M178","v":2949098.7004204933},{"$f":"D$28-D$98*(1+$E154)^-$C$5+D$34*$J178+SUMPRODUCT(D$35:D$64,$Q$176:$Q$205)+D$66*$J178+SUMPRODUCT(D$67:D$96,$Q$176:$Q$205)+D$30*$C$9*$K178+D$31*$C$13*$L178+D$32*$C$17*$M178","v":696092.27257358632}]
[null,null,null,null,0.06,{"$f":"C$28-C$98*(1+$E155)^-$C$5+C$34*$J179+SUMPRODUCT(C$35:C$64,$R$176:$R$205)+C$66*$J179+SUMPRODUCT(C$67:C$96,$R$176:$R$205)+C$30*$C$9*$K179+C$31*$C$13*$L179+C$32*$C$17*$M179","v":2400000},{"$f":"D$28-D$98*(1+$E155)^-$C$5+D$34*$J179+SUMPRODUCT(D$35:D$64,$R$176:$R$205)+D$66*$J179+SUMPRODUCT(D$67:D$96,$R$176:$R$205)+D$30*$C$9*$K179+D$31*$C$13*$L179+D$32*$C$17*$M179","v":600000}]
[null,null,null,null,0.08,{"$f":"C$28-C$98*(1+$E156)^-$C$5+C$34*$J180+SUMPRODUCT(C$35:C$64,$S$176:$S$205)+C$66*$J180+SUMPRODUCT(C$67:C$96,$S$176:$S$205)+C$30*$C$9*$K180+C$31*$C$13*$L180+C$32*$C$17*$M180","v":1983778.3412811419},{"$f":"D$28-D$98*(1+$E156)^-$C$5+D$34*$J180+SUMPRODUCT(D$35:D$64,$S$176:$S$205)+D$66*$J180+SUMPRODUCT(D$67:D$96,$S$176:$S$205)+D$30*$C$9*$K180+D$31*$C$13*$L180+D$32*$C$17*$M180","v":527161.20972419984}]
[null,null,null,null,0.1,{"$f":"C$28-C$98*(1+$E157)^-$C$5+C$34*$J181+SUMPRODUCT(C$35:C$64,$T$176:$T$205)+C$66*$J181+SUMPRODUCT(C$67:C$96,$T$176:$T$205)+C$30*$C$9*$K181+C$31*$C$13*$L181+C$32*$C$17*$M181","v":1664029.598148237},{"$f":"D$28-D$98*(1+$E157)^-$C$5+D$34*$J181+SUMPRODUCT(D$35:D$64,$T$176:$T$205)+D$66*$J181+SUMPRODUCT(D$67:D$96,$T$176:$T$205)+D$30*$C$9*$K181+D$31*$C$13*$L181+D$32*$C$17*$M181","v":471205.17967594147}]
[null,null,null,null,0.12,{"$f":"C$28-C$98*(1+$E158)^-$C$5+C$34*$J182+SUMPRODUCT(C$35:C$64,$U$176:$U$205)+C$66*$J182+SUMPRODUCT(C$67:C$96,$U$176:$U$205)+C$30*$C$9*$K182+C$31*$C$13*$L182+C$32*$C$17*$M182","v":1415156.4776907573},{"$f":"D$28-D$98*(1+$E158)^-$C$5+D$34*$J182+SUMPRODUCT(D$35:D$64,$U$176:$U$205)+D$66*$J182+SUMPRODUCT(D$67:D$96,$U$176:$U$205)+D$30*$C$9*$K182+D$31*$C$13*$L182+D$32*$C$17*$M182","v":427652.38359588257}]
[null,null,null,null,0.14000000000000001,{"$f":"C$28-C$98*(1+$E159)^-$C$5+C$34*$J183+SUMPRODUCT(C$35:C$64,$V$176:$V$205)+C$66*$J183+SUMPRODUCT(C$67:C$96,$V$176:$V$205)+C$30*$C$9*$K183+C$31*$C$13*$L183+C$32*$C$17*$M183","v":1218962.8436179622},{"$f":"D$28-D$98*(1+$E159)^-$C$5+D$34*$J183+SUMPRODUCT(D$35:D$64,$V$176:$V$205)+D$66*$J183+SUMPRODUCT(D$67:D$96,$V$176:$V$205)+D$30*$C$9*$K183+D$31*$C$13*$L183+D$32*$C$17*$M183","v":393318.49763314339}]
[]
[]
[]
[]
[]
[]
[null,"Testa gärna också att variera andra osäkra indata, t.ex. investeringskostnader eller energipriser!"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Alt C"]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E152)^-$C$5+E$34*$J176+SUMPRODUCT(E$35:E$64,$O$176:$O$205)+E$66*$J176+SUMPRODUCT(E$67:E$96,$O$176:$O$205)+E$30*$C$9*$K176+E$31*$C$13*$L176+E$32*$C$17*$M176","v":0},null,{"$f":"(1-(1+$E152)^-$C$5)/$E152","v":19.791531187324907},{"$f":"IF($E152=$C$10,$C$5,((1-((1+$C$10)/(1+$E152))^$C$5)/((1+$E152)/(1+$C$10)-1)))","v":38.513237822408719},{"$f":"IF($E152=$C$14,$C$5,((1-((1+$C$14)/(1+$E152))^$C$5)/((1+$E152)/(1+$C$14)-1)))","v":38.513237822408719},{"$f":"IF($E152=$C$18,$C$5,((1-((1+$C$18)/(1+$E152))^$C$5)/((1+$E152)/(1+$C$18)-1)))","v":19.791531187326864},null,{"$f":"(1+$E$152)^-1","v":0.99900099900099915},{"$f":"(1+$E$153)^-1","v":0.98039215686274506},{"$f":"(1+$E$154)^-1","v":0.96153846153846145},{"$f":"(1+$E$155)^-1","v":0.94339622641509424},{"$f":"(1+$E$156)^-1","v":0.92592592592592582},{"$f":"(1+$E$157)^-1","v":0.90909090909090906},{"$f":"(1+$E$158)^-1","v":0.89285714285714279},{"$f":"(1+$E$159)^-1","v":0.8771929824561403}]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E153)^-$C$5+E$34*$J177+SUMPRODUCT(E$35:E$64,$P$176:$P$205)+E$66*$J177+SUMPRODUCT(E$67:E$96,$P$176:$P$205)+E$30*$C$9*$K177+E$31*$C$13*$L177+E$32*$C$17*$M177","v":0},null,16.351433344597112,30.695221206120397,30.695221206120397,16.35143334459713,null,{"$f":"(1+$E$152)^-2","v":0.99800299600499431},{"$f":"(1+$E$153)^-2","v":0.96116878123798544},{"$f":"(1+$E$154)^-2","v":0.92455621301775137},{"$f":"(1+$E$155)^-2","v":0.88999644001423983},{"$f":"(1+$E$156)^-2","v":0.85733882030178321},{"$f":"(1+$E$157)^-2","v":0.82644628099173545},{"$f":"(1+$E$158)^-2","v":0.79719387755102034},{"$f":"(1+$E$159)^-2","v":0.76946752847029842}]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E154)^-$C$5+E$34*$J178+SUMPRODUCT(E$35:E$64,$Q$176:$Q$205)+E$66*$J178+SUMPRODUCT(E$67:E$96,$Q$176:$Q$205)+E$30*$C$9*$K178+E$31*$C$13*$L178+E$32*$C$17*$M178","v":0},null,13.590326344967698,24.57582250350411,24.57582250350411,13.5903263449677,null,{"$f":"(1+$E$152)^-$B37","v":0.99700599001497947},{"$f":"(1+$E$153)^-$B37","v":0.94232233454704462},{"$f":"(1+$E$154)^-$B37","v":0.88899635867091487},{"$f":"(1+$E$155)^-$B37","v":0.8396192830323016},{"$f":"(1+$E$156)^-$B37","v":0.79383224102016958},{"$f":"(1+$E$157)^-$B37","v":0.75131480090157754},{"$f":"(1+$E$158)^-$B37","v":0.71178024781341087},{"$f":"(1+$E$159)^-$B37","v":0.67497151620201612}]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E155)^-$C$5+E$34*$J179+SUMPRODUCT(E$35:E$64,$R$176:$R$205)+E$66*$J179+SUMPRODUCT(E$67:E$96,$R$176:$R$205)+E$30*$C$9*$K179+E$31*$C$13*$L179+E$32*$C$17*$M179","v":0},null,11.469921218565263,20,20,11.469921218565261,null,0.99600998003494456,0.9238454260265142,0.85480419102972571,0.79209366323802044,0.73502985279645328,0.68301345536507052,0.63551807840483121,0.59208027737018942]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E156)^-$C$5+E$34*$J180+SUMPRODUCT(E$35:E$64,$S$176:$S$205)+E$66*$J180+SUMPRODUCT(E$67:E$96,$S$176:$S$205)+E$30*$C$9*$K180+E$31*$C$13*$L180+E$32*$C$17*$M180","v":0},null,9.8181474074492936,16.531486177342849,16.531486177342849,9.8181474074492865,null,0.99501496506987486,0.90573080982991594,0.82192710675935154,0.74725817286605689,0.68058319703375303,0.62092132305915493,0.56742685571859919,0.51936866435981521]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E157)^-$C$5+E$34*$J181+SUMPRODUCT(E$35:E$64,$T$176:$T$205)+E$66*$J181+SUMPRODUCT(E$67:E$96,$T$176:$T$205)+E$30*$C$9*$K181+E$31*$C$13*$L181+E$32*$C$17*$M181","v":0},null,8.5135637197585652,13.866913317901975,13.866913317901975,8.5135637197585563,null,0.99402094412574937,0.88797138218619198,0.79031452573014571,0.70496054043967626,0.63016962688310452,0.56447393005377722,0.50663112117732068,0.45558654768404844]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E158)^-$C$5+E$34*$J182+SUMPRODUCT(E$35:E$64,$U$176:$U$205)+E$66*$J182+SUMPRODUCT(E$67:E$96,$U$176:$U$205)+E$30*$C$9*$K182+E$31*$C$13*$L182+E$32*$C$17*$M182","v":0},null,7.4694436243275977,11.792970647422978,11.792970647422978,7.4694436243275897,null,0.99302791620954001,0.87056017861391388,0.75991781320206331,0.66505711362233599,0.58349039526213387,0.51315811823070645,0.45234921533689343,0.39963732252986695]
[null,null,null,null,null,null,null,{"$f":"E$28-E$98*(1+$E159)^-$C$5+E$34*$J183+SUMPRODUCT(E$35:E$64,$V$176:$V$205)+E$66*$J183+SUMPRODUCT(E$67:E$96,$V$176:$V$205)+E$30*$C$9*$K183+E$31*$C$13*$L183+E$32*$C$17*$M183","v":0},null,6.6231305516159438,10.158023696816352,10.158023696816352,6.6231305516159384,null,0.99203588032921075,0.85349037119011162,0.73069020500198378,0.62741237134182648,0.54026888450197574,0.46650738020973315,0.4038832279793691,0.35055905485076044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99104483549371702,0.83675526587265847,0.70258673557883045,0.59189846353002495,0.50024896713145905,0.42409761837248466,0.36061002498157957,0.3075079428515442]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99005478071300423,0.82034829987515534,0.67556416882579851,0.55839477691511785,0.46319348808468425,0.38554328942953148,0.32197323659069599,0.26974380951889843]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98906571499800655,0.80426303909328967,0.6495809315632679,0.52678752539162055,0.42888285933767062,0.3504938994813922,0.28747610409883567,0.23661737677096348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98807763736064591,0.78849317558165644,0.62459704958006512,0.4969693635770005,0.39711375864599124,0.31863081771035656,0.25667509294538904,0.20755910243066969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98709054681383213,0.77303252508005538,0.600574086134678,0.46883902224245327,0.36769792467221413,0.28966437973668779,0.22917419012981158,0.18206938809707865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.986104442371461,0.75787502458828948,0.57747508282180582,0.44230096437967292,0.34046104136316119,0.26333125430607973,0.20461981261590317,0.15970998955884091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98511932304841265,0.74301472998851925,0.55526450271327477,0.41726506073554037,0.31524170496588994,0.23939204936916339,0.18269626126419927,0.1400964820691587]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98413518786055221,0.72844581371423445,0.53390817568584104,0.39364628371277405,0.29189046756100923,0.21762913579014853,0.16312166184303503,0.12289165093785848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98315203582472765,0.7141625624649357,0.51337324585177024,0.37136441859695657,0.27026895144537894,0.19784466890013502,0.14564434093128129,0.107799693805139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98216986595876898,0.7001593749656233,0.49362812101131748,0.35034379112920433,0.25024902911609154,0.17985878990921364,0.13003959011721541,9.4561134916788581E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98118867728148773,0.68643075977021895,0.47464242404934376,0.3305130104992493,0.23171206399638106,0.16350799082655781,0.1161067768903709,8.2948363962095248E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98020846881267509,0.67297133310805779,0.45638694620129205,0.31180472688608429,0.21454820740405653,0.14864362802414349,0.1036667650806883,7.2761722773767745E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97922923957310215,0.65977581677260566,0.43883360211662686,0.29415540272272095,0.19865574759634863,0.13513057093103953,9.2559611679185971E-2,6.3826072608568193E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97825098858451787,0.64683903605157411,0.42195538665060278,0.27750509690822728,0.18394050703365611,0.12284597357367227,8.2642510427844609E-2,5.5987782989972097E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97727371486964842,0.63415591769762181,0.40572633331788732,0.26179726123417668,0.17031528429042234,0.11167815779424752,7.3787955739146982E-2,4.9112090342080778E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.976297417452196,0.62172148793884485,0.39012147434412242,0.24697854833412897,0.1576993373059466,0.10152559799477048,6.5882103338524081E-2,4.3080781001825233E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97532209535683934,0.60953087052827937,0.37511680225396377,0.23299863050389524,0.1460179049129135,9.2295998177064048E-2,5.8823306552253637E-2,3.779015877353091E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97434774760923015,0.59757928483164635,0.36068923293650368,0.21981002877725966,0.13520176380825324,8.3905452888240042E-2,5.2520809421655032E-2,3.3149262082044648E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97337437323599441,0.58586204395259456,0.3468165701312535,0.20736795167666003,0.12518681834097523,7.6277684443854576E-2,4.6893579840763415E-2,2.9078300071968988E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97240197126472983,0.57437455289470041,0.3334774712800514,0.1956301430911887,0.11591372068608817,6.9343349494413245E-2,4.1869267714967337E-2,2.5507280764885072E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97143054072400581,0.56311230675951029,0.32065141469235708,0.18455673876527234,0.10732751915378534,6.3039408631284766E-2,3.7383274745506546E-2,2.2374807688495677E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97046008064336287,0.55207088897991197,0.30831866797342034,0.17411013091063426,9.9377332549801231E-2,5.7308553301167964E-2,3.3377923879916553E-2,1.9627024288154101E-2]

{"sheet":"Förklaringar","index":4,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["Förklaringar"]
["Här presenteras korta förklaringar av de olika parametrarna i LCC-kalkylen. För en mer utförlig förklaring och beskrivningar av de exempel som finns inlagda på separata flikar hänvisas till den mer omfattande manualen som hör till verktyget. Manualen kan laddas ner från samma ställe som verktyget."]
["Indata anges i orangefärgade celler, och det är enbart dessa som går att ändra i."]
["För beräkningarna av livscykelkostnad (LCC) och återbetalningstid behövs följande uppgifter:"]
["Indata - parameter","Förklaring"]
["Kalkylperiod","Utrustningens faktiska brukstid/användningstid, ekonomiska livslängd eller uppskattade tekniska livslängd."]
["Kalkylränta","Kalkylräntan används för att räkna om betalningar som görs i framtiden till dagens penningvärde. Här anges den reala kalkylräntan, dvs kalkylränta utöver inflation (real kalkylränta ≈ nominell kalkylränta - inflation). Vilken kalkylränta man ska använda bestäms i allmänhet av den lägsta avkastning som är acceptabel för den som gör investeringen."]
["Energipris för olika energislag","Aktuell pris som företaget betalar för t.ex. el, fjärrvärme eller annat energislag vars användning påverkas genom investeringen. Både energislag och pris anges av användaren."]
["Förväntad real årlig energiprisförändring","Real årlig förändring av energipriset utöver inflationen (real prisförändring ≈ nominell prisförändring - inflation)"]
["Investeringskostnad","Initial engångskostnad i samband med inköp och installation."]
["Årligt energibehov för olika energislag","Årligt energibehov. Kan uppskattas utifrån effekt och drifttid för utrustningen (energibehov = effekt x drifttid). För lönsamhetsberäkning (återbetalningstid och nettonuvärde) behöver endast energbehov som skiljer mellan alternativen anges. "]
["Drift- och underhållskostnader","Kostnader för underhåll och skötsel anges i normalfallet som en fast årlig kostnad. I särskilda fall kan kostnader för enskilda år anges. (Kostnaderna ska anges utan inflation,dvs i dagens penningvärde, eftersom det är den reala kalkylräntan som används vid nuvärdesberäkningarna)"]
["Övriga årliga kostnader","Övriga kostnader som skiljer sig mellan alternativen. I övriga kostnader kan eventuella mervärden av en energieffektiviseringsåtgärd anges, om de är möjliga att sätta ett monetärt värde på. Eftersom man alltid jämför två olika alternativ kan det vara lättare att ange skillnaden mellan alternativen istället för de absoluta kostnaderna. Övriga kostnader kan också inkludera t.ex. eventuella miljökostnader. Här kan man också lägga in fasta energiavgifter (t.ex. fast elnätsavgift)."]
["Restvärde","Eventuellt återstående ekonomiskt värde efter brukstiden."]
[]
["Resultat","Förklaring"]
["Livscykelkostnad, LCC","Huvudresultatet av LCC-kalkylen är den totala livscykelkostnaden för olika alternativ. Livscykelkostnaden beräknas som summan av nuvärdet av alla kostnader."]
["Lönsamhetsbedömningar","För lönsamhetsberäkningar (med återbetalningstid eller nuvärde av investering) antas Alt A vara ett grundalternativ, som motsvarar att man inte gör någonting eller att man investerar i konventionell eller befintlig utrustning.Sedan beräknas lönsamheten i att investera i Alt B eller C istället för att välja Alt A."]
["Rak återbetalningstid","Återbetalningstiden är den tid i år det tar innan den högre investeringen för Alt B resp C jämfört med Alt A har betalat igen sig i form av lägre driftkostnader. För att uträkningen ska ge ett meningsfullt resultat behöver därför Alt A vara det alternativ som har lägst investeringskostnad. Återbetalningstiden, som den beräknas i det här verktyget, tar ej hänsyn till följande:\n- kalkylränta\n- eventuell energiprisökning\n- restvärde\n- underhåll eller övriga kostnader angivna för enskilda år"]
["Nettonuvärde av investering","Nettonuvärdet av en investering är ett lönsamhetsmått, som bygger på samma beräkningsprinciper som LCC-kalkylen. Nettonuvärdet av att investera i Alt B resp C istället för att välja Alt A motsvaras av minskningen i LCC-kostnad. En investering bedöms som lönsam om nettonuvärdet är större än noll."]