{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["LCC","LCC (Byte T8 till LED)","LCC (Rörelsevakt)","Förklaringar"],"not_rendered":{"charts":9,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"LCC (Byte T8 till LED)","index":1,"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)",10,null,null,null,null,"Märkeffekt befintlig belysning (W/ljuskälla)",58]
[null,"Kalkylränta (%)",0.05,null,null,null,null,"Förluster befintlig (% av märkeffekt)",0.25,"Se faktaruta Fakta LED-lysrör"]
[null,null,null,null,null,null,null,"Märkeffekt ny belysning (W/ljuskälla) ",22.4]
[null,"Energislag 1","El",null,null,null,null,"Antal befintlig belysning (st)",52]
[null,"Energipris energislag (kr/kWh)",1.2,null,null,null,null,"Antal ny belysning (st)",52]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Kostnad ny belysning (kr/st)",237,"Se faktaruta Kostnader"]
[null,"Utsläppsfaktor (gCO2e/kWh)",125,null,null,null,null,"Drifttimmar per år (h/år)",3000]
[null,"Energislag 2",null,null,null,null,null,"Arbetskostnad installation (kr)",{"$f":"1500+575*8","v":6100},"Se faktaruta Kostnader"]
[null,"Energipris energislag (kr/kWh)",null,null,null,null,null,"Underhållskostnad befintlig belysning (kr/år)",818,"Se faktaruta Kostnader. Förs in i cell C35"]
[null,"Förväntad real årlig energiprisförändring (%)",null,null,null,null,null,"Underhållskostnad ny belysning (kr/år)",0,"Förs in i cell D35"]
[null,"Utsläppsfaktor (gCO2e/kWh)"]
[null,"Energislag 3",null,null,null,null,null,"Årligt energibehov före (kWh/år)",{"$f":"I11*I5*(1+I6)/1000*I8","v":11310},"Detta värde förs in i cell C31"]
[null,"Energipris energislag (kr/kWh)",null,null,null,null,null,"Årligt energibehov efter (kWh/år)",{"$f":"I11*I7/1000*I9","v":3494.4},"Detta värde förs in i cell D31"]
[null,"Förväntad real årlig energiprisförändring (%)",null,null,null,null,null,"Investering (kr)",{"$f":"I9*I10+I12","v":18424},"Detta värde förs in i cell D29"]
[null,"Utsläppsfaktor (gCO2e/kWh)",null,null,null,null,null,"Årlig energibesparing (kWh/år)",{"$f":"I16-I17","v":7815.6}]
[null,null,null,null,null,null,null,"Årlig utsläppsminskning (kgCO2e/år)",{"$f":"I19*C11/1000","v":976.95}]
[null,"Nusummefaktor",{"$f":"IF($C$6=0,$C$5,(1-(1+$C$6)^-$C$5)/$C$6)","v":7.7217349291848132}]
[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":10.539064413943366}]
[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":7.7217349291848114}]
[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":7.7217349291848114}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Behåll T8-belysning","Byt till LED-belysning "]
[null,"Investeringskostnad (kr)",0,{"$f":"I18","v":18424}]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",{"$f":"I16","v":11310},{"$f":"I17","v":3494.4}]
[null,"Årligt energibehov, energislag 2 (kWh) "]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)",{"$f":"I13","v":818},{"$f":"I14","v":0}]
[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":18424},{"$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":6316.379172073177},{"$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":143036.18222603938},{"$f":"D31*$C$9*$C$22+D32*$C$13*$C$23+D33*$C$17*$C$24","v":44193.248025700435},{"$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":149352.56139811256},{"$f":"IF(SUM(D103:D106)=0,\"-\",SUM(D103:D106))","v":62617.248025700435},{"$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":1.8068555378592333},{"$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":86735.313372412129},{"$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":196629.46577823351},{"$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":76662.231605419991}]
[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":176070.1066338307},{"$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":70553.38878636455}]
[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":157570.6129313256},{"$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":65057.988470585035}]
[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":141740.55120805724},{"$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":60356.799999999996}]
[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":128125.75707743104},{"$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":56314.57648338443}]
[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":116358.63731182404},{"$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":52821.866810946347}]
[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":106140.14140061932},{"$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":49789.641390064753}]
[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":97225.773194286376},{"$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":47145.122611611696}]
[]
[]
[]
[]
[]
[]
[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":9.9452192869957656},{"$f":"IF($E153=$C$10,$C$5,((1-((1+$C$10)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$10)-1)))","v":13.888467167806585},{"$f":"IF($E153=$C$14,$C$5,((1-((1+$C$14)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$14)-1)))","v":9.9452192869966396},{"$f":"IF($E153=$C$18,$C$5,((1-((1+$C$18)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$18)-1)))","v":9.9452192869966396},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,8.9825850062422337,12.431649874648139,8.9825850062422425,8.9825850062422425,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,8.1108957793550367,11.12112438725414,8.1108957793550385,8.1108957793550385,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,7.3600870514147028,10,7.3600870514147019,7.3600870514147019,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,6.7100813989414476,9.0360234669243251,6.7100813989414432,6.7100813989414432,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,6.1445671057046853,8.2030932375005605,6.1445671057046791,6.1445671057046791,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,5.650223028410867,7.4799778192881838,5.6502230284108608,5.6502230284108608,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,5.2161156462935825,6.8493214408796215,5.216115646293578,5.216115646293578,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":"LCC (Rörelsevakt)","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)",10,null,null,null,null,"Märkeffekt  (W/ljuskälla)",58]
[null,"Kalkylränta (%)",0.05,null,null,null,null,"Förlust (% av märkeffekt)",0.25]
[null,null,null,null,null,null,null,"Antal belysning (st)",52]
[null,"Energislag 1","El",null,null,null,null,"Drifttimmar utan rörelsevakt (h/år)",{"$f":"300*10","v":3000}]
[null,"Energipris energislag (kr/kWh)",1.2,null,null,null,null,"Drifttimmar med rörelsevakt (h/år)",{"$f":"300*8.75","v":2625},"Se faktaruta Fakta rörelsevakt"]
[null,"Förväntad real årlig energiprisförändring (%)",0.06,null,null,null,null,"Kostnad rörelsevakt (kr)",579]
[null,"Utsläppsfaktor (gCO2e/kWh)",125,null,null,null,null,"Arbetskostnad installation (kr)",575]
[null,"Energislag 2"]
[null,"Energipris energislag (kr/kWh)",null,null,null,null,null,"Investeringskostnad (kr)",{"$f":"I10+I11","v":1154},"Detta värde förs in i cell D29"]
[null,"Förväntad real årlig energiprisförändring (%)",null,null,null,null,null,"Årligt energibehov utan vakt (kWh/år)",{"$f":"I8*(1+I6)*I5*I7/1000","v":11310},"Detta värde förs in i cell C31"]
[null,"Utsläppsfaktor (gCO2e/kWh)",null,null,null,null,null,"Årligt energibehov med vakt (kWh/år)",{"$f":"I9*I7*I5*(1+I6)/1000","v":9896.25},"Detta värde förs in i cell D31"]
[null,"Energislag 3",null,null,null,null,null,"Årlig energibesparing (kWh/år)",{"$f":"I14-I15","v":1413.75}]
[null,"Energipris energislag (kr/kWh)",null,null,null,null,null,"Årlig utsläppsminskning (kgCO2e/år)",{"$f":"I16*C11/1000","v":176.71875}]
[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":7.7217349291848132}]
[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":10.539064413943366}]
[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":7.7217349291848114}]
[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":7.7217349291848114}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","T8 58 W\n(Ingen åtgärd)","T8 58 W (Installera rörelsevakt)"]
[null,"Investeringskostnad (kr)",0,{"$f":"I13","v":1154}]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",{"$f":"I14","v":11310},{"$f":"I15","v":9896.25}]
[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)^-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":1154},{"$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":143036.18222603938},{"$f":"D31*$C$9*$C$22+D32*$C$13*$C$23+D33*$C$17*$C$24","v":125156.65944778445},{"$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":143036.18222603938},{"$f":"IF(SUM(D103:D106)=0,\"-\",SUM(D103:D106))","v":126310.65944778445},{"$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.6802239905688181},{"$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":16725.522778254934},{"$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*$J180+SUMPRODUCT(C$36:C$65,$O$177:$O$206)+C$67*$J180+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":188494.27640147097},{"$f":"D$29-D$99*(1+$E153)^-$C$5+D$35*$J180+SUMPRODUCT(D$36:D$65,$O$177:$O$206)+D$67*$J180+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":166086.49185128711}]
[null,null,null,null,0.02,{"$f":"C$29-C$99*(1+$E154)^-$C$5+C$35*$J181+SUMPRODUCT(C$36:C$65,$P$177:$P$206)+C$67*$J181+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":168722.35209872454},{"$f":"D$29-D$99*(1+$E154)^-$C$5+D$35*$J181+SUMPRODUCT(D$36:D$65,$P$177:$P$206)+D$67*$J181+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":148786.05808638397}]
[null,null,null,null,0.04,{"$f":"C$29-C$99*(1+$E155)^-$C$5+C$35*$J182+SUMPRODUCT(C$36:C$65,$Q$177:$Q$206)+C$67*$J182+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":150935.90018381318},{"$f":"D$29-D$99*(1+$E155)^-$C$5+D$35*$J182+SUMPRODUCT(D$36:D$65,$Q$177:$Q$206)+D$67*$J182+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":133222.91266083653}]
[null,null,null,null,0.06,{"$f":"C$29-C$99*(1+$E156)^-$C$5+C$35*$J183+SUMPRODUCT(C$36:C$65,$R$177:$R$206)+C$67*$J183+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":135720},{"$f":"D$29-D$99*(1+$E156)^-$C$5+D$35*$J183+SUMPRODUCT(D$36:D$65,$R$177:$R$206)+D$67*$J183+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":119909}]
[null,null,null,null,0.08,{"$f":"C$29-C$99*(1+$E157)^-$C$5+C$35*$J184+SUMPRODUCT(C$36:C$65,$S$177:$S$206)+C$67*$J184+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":122636.91049309693},{"$f":"D$29-D$99*(1+$E157)^-$C$5+D$35*$J184+SUMPRODUCT(D$36:D$65,$S$177:$S$206)+D$67*$J184+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":108461.29668145982}]
[null,null,null,null,0.1,{"$f":"C$29-C$99*(1+$E158)^-$C$5+C$35*$J185+SUMPRODUCT(C$36:C$65,$T$177:$T$206)+C$67*$J185+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":111332.38141935761},{"$f":"D$29-D$99*(1+$E158)^-$C$5+D$35*$J185+SUMPRODUCT(D$36:D$65,$T$177:$T$206)+D$67*$J185+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":98569.83374193791}]
[null,null,null,null,0.12,{"$f":"C$29-C$99*(1+$E159)^-$C$5+C$35*$J186+SUMPRODUCT(C$36:C$65,$U$177:$U$206)+C$67*$J186+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":101518.25896337924},{"$f":"D$29-D$99*(1+$E159)^-$C$5+D$35*$J186+SUMPRODUCT(D$36:D$65,$U$177:$U$206)+D$67*$J186+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":89982.476592956824}]
[null,null,null,null,0.14000000000000001,{"$f":"C$29-C$99*(1+$E160)^-$C$5+C$35*$J187+SUMPRODUCT(C$36:C$65,$V$177:$V$206)+C$67*$J187+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":92958.990595618219},{"$f":"D$29-D$99*(1+$E160)^-$C$5+D$35*$J187+SUMPRODUCT(D$36:D$65,$V$177:$V$206)+D$67*$J187+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":82493.116771165951}]
[]
[]
[]
[]
[]
[]
[null,"Testa gärna också att variera andra osäkra indata, t.ex. investeringskostnader eller energipriser!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E153=$C$10,$C$5,((1-((1+$C$10)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$10)-1)))","v":13.888467167806585},{"$f":"IF($E153=$C$14,$C$5,((1-((1+$C$14)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$14)-1)))","v":9.9452192869966396},{"$f":"IF($E153=$C$18,$C$5,((1-((1+$C$18)/(1+$E153))^$C$5)/((1+$E153)/(1+$C$18)-1)))","v":9.9452192869966396},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,null,null,null,12.431649874648139,8.9825850062422425,8.9825850062422425,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,"Alt C",null,null,11.12112438725414,8.1108957793550385,8.1108957793550385,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+$E153)^-$C$5+E$35*$J180+SUMPRODUCT(E$36:E$65,$O$177:$O$206)+E$67*$J180+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":9.9452192869957656},10,7.3600870514147019,7.3600870514147019,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+$E154)^-$C$5+E$35*$J181+SUMPRODUCT(E$36:E$65,$P$177:$P$206)+E$67*$J181+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,8.9825850062422337,9.0360234669243251,6.7100813989414432,6.7100813989414432,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+$E155)^-$C$5+E$35*$J182+SUMPRODUCT(E$36:E$65,$Q$177:$Q$206)+E$67*$J182+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,8.1108957793550367,8.2030932375005605,6.1445671057046791,6.1445671057046791,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+$E156)^-$C$5+E$35*$J183+SUMPRODUCT(E$36:E$65,$R$177:$R$206)+E$67*$J183+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,7.3600870514147028,7.4799778192881838,5.6502230284108608,5.6502230284108608,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+$E157)^-$C$5+E$35*$J184+SUMPRODUCT(E$36:E$65,$S$177:$S$206)+E$67*$J184+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,6.7100813989414476,6.8493214408796215,5.216115646293578,5.216115646293578,null,0.99203588032921075,0.85349037119011162,0.73069020500198378,0.62741237134182648,0.54026888450197574,0.46650738020973315,0.4038832279793691,0.35055905485076044]
[null,null,null,null,null,null,null,{"$f":"E$29-E$99*(1+$E158)^-$C$5+E$35*$J185+SUMPRODUCT(E$36:E$65,$T$177:$T$206)+E$67*$J185+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,6.1445671057046853,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,{"$f":"E$29-E$99*(1+$E159)^-$C$5+E$35*$J186+SUMPRODUCT(E$36:E$65,$U$177:$U$206)+E$67*$J186+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,5.650223028410867,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,{"$f":"E$29-E$99*(1+$E160)^-$C$5+E$35*$J187+SUMPRODUCT(E$36:E$65,$V$177:$V$206)+E$67*$J187+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,5.2161156462935825,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":3,"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."]