{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Startsida","LCC","Förklaringar","Exempel (LCC-jämförelse pumpar)","Exempel (lönsamhet åtgärd)","Exempel (reinvestering)"],"not_rendered":{"charts":12,"images":4,"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":"Startsida","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Verktyg för beräkning av livscykelkostnad (LCC)"]

{"sheet":"LCC","index":1,"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":"Förklaringar","index":2,"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."]

{"sheet":"Exempel (LCC-jämförelse pumpar)","index":3,"n_rows":203,"n_cols":22,"rows_kept":203,"cut":false,"hidden":false,"merged":[[7,0,16,0],[110,1,110,4],[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.06]
[]
["<-\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":11.469921218565263}]
[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":11.469921218565261}]
[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":11.469921218565261}]
[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":11.469921218565261}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Pump A","Pump B"]
[null,"Investeringskostnad (kr)",8000,12000]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",8000,6000]
[null,"Årligt energibehov, energislag 2 (kWh) "]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)",250,600]
[null,"Underhållskostnad år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.94339622641509424}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.88999644001423983}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B35","v":0.8396192830323016}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B36","v":0.79209366323802044}]
[null,5,null,null,null,0.74725817286605689]
[null,6,null,null,null,0.70496054043967626]
[null,7,null,null,null,0.66505711362233599]
[null,8,null,null,null,0.62741237134182648]
[null,9,null,null,null,0.59189846353002495]
[null,10,null,null,null,0.55839477691511785]
[null,11,null,null,null,0.52678752539162055]
[null,12,null,null,null,0.4969693635770005]
[null,13,null,null,null,0.46883902224245327]
[null,14,null,null,null,0.44230096437967292]
[null,15,null,null,null,0.41726506073554037]
[null,16,null,null,null,0.39364628371277405]
[null,17,null,null,null,0.37136441859695657]
[null,18,null,null,null,0.35034379112920433]
[null,19,null,null,null,0.3305130104992493]
[null,20,null,null,null,0.31180472688608429]
[null,21,null,null,null,0.29415540272272095]
[null,22,null,null,null,0.27750509690822728]
[null,23,null,null,null,0.26179726123417668]
[null,24,null,null,null,0.24697854833412897]
[null,25,null,null,null,0.23299863050389524]
[null,26,null,null,null,0.21981002877725966]
[null,27,null,null,null,0.20736795167666003]
[null,28,null,null,null,0.1956301430911887]
[null,29,null,null,null,0.18455673876527234]
[null,30,null,null,null,0.17411013091063426]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Övriga årliga kostnader (kr/år)",0,0]
[null,"Övriga kostnader år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.94339622641509424}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.88999644001423983}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B67","v":0.8396192830323016}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B68","v":0.79209366323802044}]
[null,5,null,null,null,0.74725817286605689]
[null,6,null,null,null,0.70496054043967626]
[null,7,null,null,null,0.66505711362233599]
[null,8,null,null,null,0.62741237134182648]
[null,9,null,null,null,0.59189846353002495]
[null,10,null,null,null,0.55839477691511785]
[null,11,null,null,null,0.52678752539162055]
[null,12,null,null,null,0.4969693635770005]
[null,13,null,null,null,0.46883902224245327]
[null,14,null,null,null,0.44230096437967292]
[null,15,null,null,null,0.41726506073554037]
[null,16,null,null,null,0.39364628371277405]
[null,17,null,null,null,0.37136441859695657]
[null,18,null,null,null,0.35034379112920433]
[null,19,null,null,null,0.3305130104992493]
[null,20,null,null,null,0.31180472688608429]
[null,21,null,null,null,0.29415540272272095]
[null,22,null,null,null,0.27750509690822728]
[null,23,null,null,null,0.26179726123417668]
[null,24,null,null,null,0.24697854833412897]
[null,25,null,null,null,0.23299863050389524]
[null,26,null,null,null,0.21981002877725966]
[null,27,null,null,null,0.20736795167666003]
[null,28,null,null,null,0.1956301430911887]
[null,29,null,null,null,0.18455673876527234]
[null,30,null,null,null,0.17411013091063426]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)",0,0]
[]
[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":8000},{"$f":"D26-D96*(1+$C$6)^-$C$5","v":12000},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":2867.4803046413158},{"$f":"D32*$C$18+SUMPRODUCT(D33:D62,$F$33:$F$62)","v":6881.9527311391575},{"$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":91759.369748522091},{"$f":"D28*$C$9*$C$19+D29*$C$12*$C$20+D30*$C$15*$C$21","v":68819.527311391561},{"$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":102626.85005316341},{"$f":"IF(SUM(D100:D103)=0,\"-\",SUM(D100:D103))","v":87701.480042530718},{"$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":2.4242424242424243},{"$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":14925.370010632687},{"$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 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$26-C$96*(1+$E151)^-$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":171280.13229544615},{"$f":"D$26-D$96*(1+$E151)^-$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":142624.10583635612}]
[null,null,null,null,0.02,{"$f":"C$26-C$96*(1+$E152)^-$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":142899.32509292633},{"$f":"D$26-D$96*(1+$E152)^-$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":119919.46007434104}]
[null,null,null,null,0.04,{"$f":"C$26-C$96*(1+$E153)^-$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":120120.19234598352},{"$f":"D$26-D$96*(1+$E153)^-$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":101696.15387678682}]
[null,null,null,null,0.06,{"$f":"C$26-C$96*(1+$E154)^-$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":102626.85005316341},{"$f":"D$26-D$96*(1+$E154)^-$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":87701.480042530718}]
[null,null,null,null,0.08,{"$f":"C$26-C$96*(1+$E155)^-$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":88999.716111456626},{"$f":"D$26-D$96*(1+$E155)^-$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":76799.772889165295}]
[null,null,null,null,0.1,{"$f":"C$26-C$96*(1+$E156)^-$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":78236.9006880081},{"$f":"D$26-D$96*(1+$E156)^-$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":68189.52055040648}]
[null,null,null,null,0.12,{"$f":"C$26-C$96*(1+$E157)^-$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":69622.909900702623},{"$f":"D$26-D$96*(1+$E157)^-$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":61298.327920562093}]
[null,null,null,null,0.14000000000000001,{"$f":"C$26-C$96*(1+$E158)^-$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":62640.827050831489},{"$f":"D$26-D$96*(1+$E158)^-$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":55712.661640665196}]
[]
[]
[]
[]
[]
[]
[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+$E151)^-$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+$E151)^-$C$5)/$E151","v":19.791531187324907},{"$f":"IF($E151=$C$10,$C$5,((1-((1+$C$10)/(1+$E151))^$C$5)/((1+$E151)/(1+$C$10)-1)))","v":19.791531187326864},{"$f":"IF($E151=$C$13,$C$5,((1-((1+$C$13)/(1+$E151))^$C$5)/((1+$E151)/(1+$C$13)-1)))","v":19.791531187326864},{"$f":"IF($E151=$C$16,$C$5,((1-((1+$C$16)/(1+$E151))^$C$5)/((1+$E151)/(1+$C$16)-1)))","v":19.791531187326864},null,{"$f":"(1+$E$151)^-1","v":0.99900099900099915},{"$f":"(1+$E$152)^-1","v":0.98039215686274506},{"$f":"(1+$E$153)^-1","v":0.96153846153846145},{"$f":"(1+$E$154)^-1","v":0.94339622641509424},{"$f":"(1+$E$155)^-1","v":0.92592592592592582},{"$f":"(1+$E$156)^-1","v":0.90909090909090906},{"$f":"(1+$E$157)^-1","v":0.89285714285714279},{"$f":"(1+$E$158)^-1","v":0.8771929824561403}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E152)^-$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$151)^-2","v":0.99800299600499431},{"$f":"(1+$E$152)^-2","v":0.96116878123798544},{"$f":"(1+$E$153)^-2","v":0.92455621301775137},{"$f":"(1+$E$154)^-2","v":0.88999644001423983},{"$f":"(1+$E$155)^-2","v":0.85733882030178321},{"$f":"(1+$E$156)^-2","v":0.82644628099173545},{"$f":"(1+$E$157)^-2","v":0.79719387755102034},{"$f":"(1+$E$158)^-2","v":0.76946752847029842}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E153)^-$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$151)^-$B35","v":0.99700599001497947},{"$f":"(1+$E$152)^-$B35","v":0.94232233454704462},{"$f":"(1+$E$153)^-$B35","v":0.88899635867091487},{"$f":"(1+$E$154)^-$B35","v":0.8396192830323016},{"$f":"(1+$E$155)^-$B35","v":0.79383224102016958},{"$f":"(1+$E$156)^-$B35","v":0.75131480090157754},{"$f":"(1+$E$157)^-$B35","v":0.71178024781341087},{"$f":"(1+$E$158)^-$B35","v":0.67497151620201612}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E154)^-$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+$E155)^-$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+$E156)^-$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+$E157)^-$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+$E158)^-$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":"Exempel (lönsamhet åtgärd)","index":4,"n_rows":203,"n_cols":22,"rows_kept":203,"cut":false,"hidden":false,"merged":[[7,0,16,0],[109,1,109,4],[1,0,1,5]]}
["Lönsamhetsberäkningar med hjälp av LCC och återbetalningstid"]
["I det här exemplet analyseras en åtgärd som bedöms ge en minskad energianvändning på 6 500 kWh/år. Notera att eftersom det är skillnaden i kostnader mellan alternativen som är intressant för jämförelsen räcker uppgiften om energibesparing. Vi behöver inte ange total energianvändning för belysning före och efter åtgärd. (Vi hade alternativt kunnat ange energibehovet till −6 500 kWh/år för Alternativ B och 0 kWh/År för Alternativ A, vilket hade gett samma lönsamhetsresultat.\nÄnnu en fördel med att byta till LED-belysning som i det här exemplet är att underhållskostnaderna brukar bli lägre eftersom LED har en betydligt längre brinntid innan de behöver bytas. För att renodla och förenkla exemplet har dock inte underhållskostnaderna tagits med här."]
[null,"Generella indata"]
[]
[null,"Kalkylperiod (år)",20]
[null,"Kalkylränta (%)",0.06]
[]
["<-\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":11.469921218565263}]
[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":11.469921218565261}]
[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":11.469921218565261}]
[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":11.469921218565261}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Ingen åtgärd","LED-belysning"]
[null,"Investeringskostnad (kr)",0,50000]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",6500,0]
[null,"Årligt energibehov, energislag 2 (kWh) "]
[null,"Årligt energibehov, energislag 3 (kWh) "]
[]
[null,"Drift- och underhållskostnad (kr/år)",0,0]
[null,"Underhållskostnad år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.94339622641509424}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.88999644001423983}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B35","v":0.8396192830323016}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B36","v":0.79209366323802044}]
[null,5,null,null,null,0.74725817286605689]
[null,6,null,null,null,0.70496054043967626]
[null,7,null,null,null,0.66505711362233599]
[null,8,null,null,null,0.62741237134182648]
[null,9,null,null,null,0.59189846353002495]
[null,10,null,null,null,0.55839477691511785]
[null,11,null,null,null,0.52678752539162055]
[null,12,null,null,null,0.4969693635770005]
[null,13,null,null,null,0.46883902224245327]
[null,14,null,null,null,0.44230096437967292]
[null,15,null,null,null,0.41726506073554037]
[null,16,null,null,null,0.39364628371277405]
[null,17,null,null,null,0.37136441859695657]
[null,18,null,null,null,0.35034379112920433]
[null,19,null,null,null,0.3305130104992493]
[null,20,null,null,null,0.31180472688608429]
[null,21,null,null,null,0.29415540272272095]
[null,22,null,null,null,0.27750509690822728]
[null,23,null,null,null,0.26179726123417668]
[null,24,null,null,null,0.24697854833412897]
[null,25,null,null,null,0.23299863050389524]
[null,26,null,null,null,0.21981002877725966]
[null,27,null,null,null,0.20736795167666003]
[null,28,null,null,null,0.1956301430911887]
[null,29,null,null,null,0.18455673876527234]
[null,30,null,null,null,0.17411013091063426]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Övriga årliga kostnader (kr/år)",0,0]
[null,"Övriga kostnader år 1",null,null,null,{"$f":"(1+$C$6)^-1","v":0.94339622641509424}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.88999644001423983}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B67","v":0.8396192830323016}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B68","v":0.79209366323802044}]
[null,5,null,null,null,0.74725817286605689]
[null,6,null,null,null,0.70496054043967626]
[null,7,null,null,null,0.66505711362233599]
[null,8,null,null,null,0.62741237134182648]
[null,9,null,null,null,0.59189846353002495]
[null,10,null,null,null,0.55839477691511785]
[null,11,null,null,null,0.52678752539162055]
[null,12,null,null,null,0.4969693635770005]
[null,13,null,null,null,0.46883902224245327]
[null,14,null,null,null,0.44230096437967292]
[null,15,null,null,null,0.41726506073554037]
[null,16,null,null,null,0.39364628371277405]
[null,17,null,null,null,0.37136441859695657]
[null,18,null,null,null,0.35034379112920433]
[null,19,null,null,null,0.3305130104992493]
[null,20,null,null,null,0.31180472688608429]
[null,21,null,null,null,0.29415540272272095]
[null,22,null,null,null,0.27750509690822728]
[null,23,null,null,null,0.26179726123417668]
[null,24,null,null,null,0.24697854833412897]
[null,25,null,null,null,0.23299863050389524]
[null,26,null,null,null,0.21981002877725966]
[null,27,null,null,null,0.20736795167666003]
[null,28,null,null,null,0.1956301430911887]
[null,29,null,null,null,0.18455673876527234]
[null,30,null,null,null,0.17411013091063426]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)",0,0]
[]
[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":50000},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":74554.487920674204},{"$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":74554.487920674204},{"$f":"IF(SUM(D100:D103)=0,\"-\",SUM(D100:D103))","v":50000},{"$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":7.6923076923076925},{"$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":24554.487920674204},{"$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 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$26-C$96*(1+$E151)^-$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":128644.95271762462},{"$f":"D$26-D$96*(1+$E151)^-$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":50000}]
[null,null,null,null,0.02,{"$f":"C$26-C$96*(1+$E152)^-$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":106284.31673988134},{"$f":"D$26-D$96*(1+$E152)^-$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":50000}]
[null,null,null,null,0.04,{"$f":"C$26-C$96*(1+$E153)^-$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":88337.121242290043},{"$f":"D$26-D$96*(1+$E153)^-$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":50000}]
[null,null,null,null,0.06,{"$f":"C$26-C$96*(1+$E154)^-$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":74554.487920674204},{"$f":"D$26-D$96*(1+$E154)^-$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":50000}]
[null,null,null,null,0.08,{"$f":"C$26-C$96*(1+$E155)^-$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":63817.958148420359},{"$f":"D$26-D$96*(1+$E155)^-$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":50000}]
[null,null,null,null,0.1,{"$f":"C$26-C$96*(1+$E156)^-$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":55338.164178430619},{"$f":"D$26-D$96*(1+$E156)^-$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":50000}]
[null,null,null,null,0.12,{"$f":"C$26-C$96*(1+$E157)^-$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":48551.383558129332},{"$f":"D$26-D$96*(1+$E157)^-$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":50000}]
[null,null,null,null,0.14000000000000001,{"$f":"C$26-C$96*(1+$E158)^-$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":43050.348585503598},{"$f":"D$26-D$96*(1+$E158)^-$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":50000}]
[]
[]
[]
[]
[]
[]
[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+$E151)^-$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+$E151)^-$C$5)/$E151","v":19.791531187324907},{"$f":"IF($E151=$C$10,$C$5,((1-((1+$C$10)/(1+$E151))^$C$5)/((1+$E151)/(1+$C$10)-1)))","v":19.791531187326864},{"$f":"IF($E151=$C$13,$C$5,((1-((1+$C$13)/(1+$E151))^$C$5)/((1+$E151)/(1+$C$13)-1)))","v":19.791531187326864},{"$f":"IF($E151=$C$16,$C$5,((1-((1+$C$16)/(1+$E151))^$C$5)/((1+$E151)/(1+$C$16)-1)))","v":19.791531187326864},null,{"$f":"(1+$E$151)^-1","v":0.99900099900099915},{"$f":"(1+$E$152)^-1","v":0.98039215686274506},{"$f":"(1+$E$153)^-1","v":0.96153846153846145},{"$f":"(1+$E$154)^-1","v":0.94339622641509424},{"$f":"(1+$E$155)^-1","v":0.92592592592592582},{"$f":"(1+$E$156)^-1","v":0.90909090909090906},{"$f":"(1+$E$157)^-1","v":0.89285714285714279},{"$f":"(1+$E$158)^-1","v":0.8771929824561403}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E152)^-$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$151)^-2","v":0.99800299600499431},{"$f":"(1+$E$152)^-2","v":0.96116878123798544},{"$f":"(1+$E$153)^-2","v":0.92455621301775137},{"$f":"(1+$E$154)^-2","v":0.88999644001423983},{"$f":"(1+$E$155)^-2","v":0.85733882030178321},{"$f":"(1+$E$156)^-2","v":0.82644628099173545},{"$f":"(1+$E$157)^-2","v":0.79719387755102034},{"$f":"(1+$E$158)^-2","v":0.76946752847029842}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E153)^-$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$151)^-$B35","v":0.99700599001497947},{"$f":"(1+$E$152)^-$B35","v":0.94232233454704462},{"$f":"(1+$E$153)^-$B35","v":0.88899635867091487},{"$f":"(1+$E$154)^-$B35","v":0.8396192830323016},{"$f":"(1+$E$155)^-$B35","v":0.79383224102016958},{"$f":"(1+$E$156)^-$B35","v":0.75131480090157754},{"$f":"(1+$E$157)^-$B35","v":0.71178024781341087},{"$f":"(1+$E$158)^-$B35","v":0.67497151620201612}]
[null,null,null,null,null,null,null,{"$f":"E$26-E$96*(1+$E154)^-$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+$E155)^-$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+$E156)^-$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+$E157)^-$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+$E158)^-$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":"Exempel (reinvestering)","index":5,"n_rows":203,"n_cols":22,"rows_kept":203,"cut":false,"hidden":false,"merged":[[7,0,16,0],[109,1,109,4],[1,0,1,5]]}
["Lönsamhetsberäkningar med hjälp av LCC och återbetalningstid"]
["I det här exemplet bedöms lönsamheten för ett åtgärdspaket som består av två energibesparingsåtgärder: Optimering av värmesystem och tilläggsisolering tak. Eftersom åtgärderna påverkar varandra (tilläggsisoleringen kräver justering av inställningarna i värmesystemet) har de lagts i ett gemensamt åtgärdspaket. Åtgärderna tillsammans förväntas ge en årlig energibesparing på 200 000 kWh, men optimeringen av värmesystemet har en investeringskostnad på 350 000 kr och en ekonomisk livslängd på 15 år medan tilläggsisoleringen av taket har en investeringskostnad på 400 000 kr och en ekonomisk livslängd på 40 år. Vi väljer att använda en kalkylperiod på 40 år för att få med hela livscykelkostnaderna för tilläggsisoleringen. Notera att besparingen har lagts som ett energibehov för nollalternativet, dvs om åtgärdspaketet inte genomförs så kommer man att ha ett energibehov på 200 000 kWh/år som man slipper om man genomför investeringen."]
[null,"Generella indata"]
[]
[null,"Kalkylperiod (år)",40]
[null,"Kalkylränta (%)",7.0000000000000007E-2]
[]
["<-\nTror du att energipriserna kommer att förändras?\nTryck på plus för att ange energiprisförändring\n<-","Energislag 1","Värme"]
[null,"Energipris energislag (kr/kWh)",0.7]
[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":13.331708842638367}]
[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":13.331708842638355}]
[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":13.331708842638355}]
[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":13.331708842638355}]
[]
[null,"Data för olika åtgärder/utrustningsalternativ"]
[null,null,"Alt A","Alt B","Alt C"]
[null,"Åtgärd/utrustningsalternativ","Ingen åtgärd","Åtgärdspaket med två åtgärder (se manual)"]
[null,"Investeringskostnad (kr)",0,750000]
[]
[null,"Årligt energibehov, energislag 1 (kWh) ",200000]
[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.93457943925233644}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.87343872827321156}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B35","v":0.81629787689085187}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B36","v":0.7628952120475252}]
[null,5,null,null,null,0.71298617948366838]
[null,6,null,null,null,0.66634222381651254]
[null,7,null,null,null,0.62274974188459109]
[null,8,null,null,null,0.5820091045650384]
[null,9,null,null,null,0.54393374258414806]
[null,10,null,null,null,0.5083492921347178]
[null,11,null,null,null,0.47509279638758667]
[null,12,null,null,null,0.44401195924073528]
[null,13,null,null,null,0.41496444788853759]
[null,14,null,null,null,0.3878172410173249]
[null,15,null,null,null,0.36244601964235967]
[null,16,null,null,null,0.33873459779659787]
[null,17,null,null,null,0.31657439046411018]
[null,18,null,null,null,0.29586391632159825]
[null,19,null,null,null,0.27650833301083949]
[null,20,null,null,null,0.2584190028138687]
[null,21,null,null,null,0.24151308674193336]
[null,22,null,null,null,0.22571316517937698]
[null,23,null,null,null,0.21094688334521211]
[null,24,null,null,null,0.19714661994879637]
[null,25,null,null,null,0.18424917752223957]
[null,26,null,null,null,0.17219549301143888]
[null,27,null,null,null,0.16093036730041013]
[null,28,null,null,null,0.15040221243028987]
[null,29,null,null,null,0.1405628153554111]
[null,30,null,null,null,0.13136711715458982]
["<- 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.93457943925233644}]
[null," år 2",null,null,null,{"$f":"(1+$C$6)^-2","v":0.87343872827321156}]
[null,3,null,null,null,{"$f":"(1+$C$6)^-B67","v":0.81629787689085187}]
[null,4,null,null,null,{"$f":"(1+$C$6)^-B68","v":0.7628952120475252}]
[null,5,null,null,null,0.71298617948366838]
[null,6,null,null,null,0.66634222381651254]
[null,7,null,null,null,0.62274974188459109]
[null,8,null,null,null,0.5820091045650384]
[null,9,null,null,null,0.54393374258414806]
[null,10,null,null,null,0.5083492921347178]
[null,11,null,null,null,0.47509279638758667]
[null,12,null,null,null,0.44401195924073528]
[null,13,null,null,null,0.41496444788853759]
[null,14,null,null,null,0.3878172410173249]
[null,15,null,350000,null,0.36244601964235967]
[null,16,null,null,null,0.33873459779659787]
[null,17,null,null,null,0.31657439046411018]
[null,18,null,null,null,0.29586391632159825]
[null,19,null,null,null,0.27650833301083949]
[null,20,null,null,null,0.2584190028138687]
[null,21,null,null,null,0.24151308674193336]
[null,22,null,null,null,0.22571316517937698]
[null,23,null,null,null,0.21094688334521211]
[null,24,null,null,null,0.19714661994879637]
[null,25,null,null,null,0.18424917752223957]
[null,26,null,null,null,0.17219549301143888]
[null,27,null,null,null,0.16093036730041013]
[null,28,null,null,null,0.15040221243028987]
[null,29,null,null,null,0.1405628153554111]
[null,30,null,350000,null,0.13136711715458982]
["<- Tryck på plus för att ange kostnader för enskilda år"]
[null,"Restvärde (kr)",null,117000]
[]
[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":742186.69542120828},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":172834.59787893231},{"$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":1866439.2379693696},{"$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":1866439.2379693696},{"$f":"IF(SUM(D100:D103)=0,\"-\",SUM(D100:D103))","v":915021.29330014065},{"$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":5.3571428571428568},{"$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":951417.94466922898},{"$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 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$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":5486790.0735080717},{"$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":1322038.1801392669}]
[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":3829767.0937033477},{"$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":1150291.7880622782}]
[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":2770988.3436797052},{"$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":1027884.2915147792}]
[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":2106481.5620134859},{"$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":945606.32111426594}]
[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":1669445.8667244841},{"$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":889731.04393435759}]
[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":1369067.1005869468},{"$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":851260.10434081091}]
[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":1154128.7354539884},{"$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":824368.58941311203}]
[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":994705.73169899243},{"$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":805283.79783384176}]
[]
[]
[]
[]
[]
[]
[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":39.191357667910928},{"$f":"IF($E150=$C$10,$C$5,((1-((1+$C$10)/(1+$E150))^$C$5)/((1+$E150)/(1+$C$10)-1)))","v":39.191357667914801},{"$f":"IF($E150=$C$13,$C$5,((1-((1+$C$13)/(1+$E150))^$C$5)/((1+$E150)/(1+$C$13)-1)))","v":39.191357667914801},{"$f":"IF($E150=$C$16,$C$5,((1-((1+$C$16)/(1+$E150))^$C$5)/((1+$E150)/(1+$C$16)-1)))","v":39.191357667914801},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,27.355479240738177,27.355479240738198,27.355479240738198,27.355479240738198,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,19.792773883426474,19.792773883426467,19.792773883426467,19.792773883426467,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,15.046296871524907,15.046296871524898,15.046296871524898,15.046296871524898,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,11.924613333746324,11.924613333746315,11.924613333746315,11.924613333746315,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,9.7790507184781994,9.7790507184781923,9.7790507184781923,9.7790507184781923,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,8.2437766818142126,8.2437766818142038,8.2437766818142038,8.2437766818142038,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,7.1050409407070942,7.1050409407070889,7.1050409407070889,7.1050409407070889,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]