{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1. Introduktion","2. LCC A1","TEMP","2. LCC A2","2. LCC A3","2. LCC A4","3. Kalkylparametrar","4. Reduktionsfaktorer, LENI-tal","5. Beräkningsfaktorer klimat ","6. Resultat","7. Svarsformulär","Blad1"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":45,"comments":5,"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":"1. Introduktion","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[35,7,35,22],[22,7,22,8],[24,7,24,20],[26,7,26,12],[28,7,28,20],[29,7,29,13],[31,7,31,20],[34,7,34,20],[78,7,78,12],[139,7,139,12],[142,7,142,13],[54,7,54,20],[40,7,40,19],[42,7,42,12],[5,19,5,22],[5,15,5,18],[33,7,33,9],[5,11,5,14],[5,1,5,2],[5,3,5,5],[8,1,8,4],[19,1,19,4],[5,6,5,10],[10,1,11,4]]}
[]
[null,null,null,null,null,null,"LCC-kalkyl för upphandling av inomhusbelysning"]
[null,null,null,null,null,null,"Version 1 .0"]
[null,null,null,null,null,null,"Datum: 2016-05-27"]
[]
[]
[]
[]
[null,"Introduktion"]
[]
[null,"Generella instruktioner kring hur verktyget används."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Vad är LCC?\n"]
[]
[null,null,null,null,null,null,null,"LCC står för \"Life Cycle Costs\" - livscykelkostnader. Med hjälp av en LCC-beräkning erhålls en totalbild över varans, tjänstens eller anläggningens kostnader under hela dess nyttjandetid. Jämförelser mellan olika produktalternativ och lösningar kan göras.  Livscykelkostnadsperspektivet kan med fördel användas i flera delar av inköpsprocessen och även i det strategiska arbetet med organisationens budget. Läs mer om LCC på Upphandlingsmyndighetens webbplats: www.upphandlingsmyndigheten.se/områden/lcc.\n"]
[]
[null,null,null,null,null,null,null,"Hur ska jag använda detta LCC-verktyg?"]
[]
[null,null,null,null,null,null,null,"Detta LCC-verktyg är specifikt utvecklat att användas vid upphandling av inomhusbelysning. Verktyget kan med fördel användas både i behovsanalysen, vid kravställande  och i anbudsutvärderingen. I denna kalkyl finns även en beräkning av klimatpåverkan inkluderad, baserad på energianvändningen under anläggningens nyttjandetid. \n\nI behovsanalysen kan verktyget användas för att i ett tidigt skede få en översikt över vilka typer av kostnader som förekommer. För en belysningsanläggning utgör exempelvis driftskostnaden för energi en stor kostnadspost. Detta kan testas med olika scenarier för energiprisökning. Beställaren kan även testa olika föreslagna belysningslösningar, exempelvis med och utan styrning.\n\nNär  LCC-beräkning ställs som krav i upphandlingen måste förfrågningsunderlaget beskriva de parametrar som ska ingå i beräkningen, hur dessa ska dokumenteras och vilka mätmetoder som ska användas. Använd gärna kriteriet \"belysningsanläggningens livscykelkostnad (LCC)\" som kan laddas hem genom Upphandlingmyndighetens kriteriewizard. En tumregel är att vid kravställande endast ta med de stora kostnadsposterna eller de kostnader som förväntas skilja sig åt mellan olika leverantörer. Miljökostnader kan tas med om dessa kan kostnadssättas på ett standardiserat sätt. \n\nVid anbudsutvärdering vägs livscykelkostnaden in som en parameter för bedömning av det ekonomiskt mest fördelaktiga anbudet. Kvalitativa krav på belysningsanläggningen, såsom ljuskvalitet, ingår inte i kalkylen utan måste kravställas i förfrågningsunderlaget."]
[null,null,null,null,null,null,null,"Hur är LCC-verktyget uppbyggt?\n"]
[]
[null,null,null,null,null,null,null,"Verktyget består av 7  flikar:\n1. Introduktion: generella instruktioner kring hur verktyget används. \n2. LCC-kalkyl A1-4: Fyra stycken kalkylblad där LCC-beräkningen utförs med standardiserade parametrar. Ett blad används per anläggning. \n3. Kalkylparametrar: Samlade instruktioner kring vad kalkylparametrarna innebär och vad som ska ingå.\n4. Reduktionsfaktorer styrning: reduktionsfaktorer för belysningsstyrning, hämtade från Belysningsbranschens handbok \"Ljus & Rum\".\n5. Beräkningsfaktorer klimatpåverkan: indata för att kunna beräkna klimatpåverkan från elenergi.\n6. Resultat: visuell översikt över LCC-beräkningens resultat.\n7. Svarsformulär: svarsformulär som leverantören bifogar anbudet. \n\nBeskrivning av anläggningen med rumstyper och storlek på dessa måste göras i förfrågningsunderlaget. \nBeställaren (upphandlande myndighet) anger kalkylförutsättningar och information kring användning; detta utgör grunden för beräkningen. Läs mer om kalkylförutsättningar och ekonomiska parametrar på www.upphandlingsmyndigheten.se/områden/lcc.\n\nAnbudsgivaren fyller i resterande uppgifter i kalkylbladet (indata) enligt de standarder eller instruktioner som anges. Kostnaderna anges utan moms. I kolumnerna anges de olika rumstyper som förekommer i belysningsanläggningen enligt beställarens beskrivning i förfrågningsunderlaget. Rummen summeras i slutet och LCC-resultatet för hela anläggningen visas. Ett kalkylblad per anläggning används. Alternativa investeringslösningar, om sådana finns, anges i  kalkylblad A2-A4. Anbudsgivaren fyller  i  svarsformuläret (ett formulär per typrum) och bifogar den till beställaren. \n\nBeställaren kan sedan föra in varje anbudsgivares uppgifter i ett nytt kalkylblad för att kunna jämföra alla anbud i resultatfliken. Beställaren kan även använda ett av kalkylbladen A1-A4 för att fylla i information kring befintlig anläggning om sådan finns; detta för att tydliggöra förbättringarna med en ny eller renoverad anläggning. \n\nLCC-kalkylerna är baserade på nuvärdesmetoden för att kunna omräkna framtida kostnader till dagens värde. Omräkningsfaktorer till nuvärde är inkluderade i formlerna. Kalkylränta, elpris och användningstid är exempel på parametrar som kan variera och som måste beslutas i den upphandlande organisationen. Kostnadsbilden påverkas beroende på valet av dessa parametrar, exempelvis innebär en hög ränta att pengarnas värde sjunker under kalkylperioden och vid låg ränta behåller pengarna sitt värde. En lång användningstid gör att driftskostnadernas betydelse ökar i kalkylen. För att få en förståelse för effekten på slutresultatet vid olika scenarier, t.ex. energiprisökning, kan kalkylen testas med ett antal olika värden. \n\n\n\n"]
[]
[null,null,null,null,null,null,null,"Kontakt"]
[null,null,null,null,null,null,null,"Upphandlingsmyndigheten utvecklar och förvaltar LCC-verktygen som är frivilliga att använda inom såväl offentlig som privat sektor. Upphandlingsmyndigheten står för innehållet i denna version. Eventuella ändringar görs på eget ansvar. Vid frågor om verktyget kan du kontakta oss via vår frågeportal på www.upphandlingsmyndigheten.se."]

{"sheet":"2. LCC A1","index":1,"n_rows":234,"n_cols":12,"rows_kept":234,"cut":false,"hidden":false,"merged":[[160,2,160,6],[156,2,156,6],[159,2,159,6],[37,2,37,6],[5,7,5,8],[20,2,20,6],[24,2,24,6],[10,2,10,4],[10,5,10,8],[11,2,11,4],[11,5,11,8],[12,2,12,4],[12,5,12,8],[14,2,14,6],[15,2,15,6],[16,2,16,6],[32,2,32,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[25,2,25,6],[5,2,5,3],[5,4,5,6],[31,2,31,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[29,2,29,6],[30,2,30,6],[26,2,26,6],[43,2,43,6],[50,2,50,6],[55,2,55,6],[62,2,62,6],[67,2,67,6],[154,2,154,4],[157,2,157,6],[216,2,216,4],[74,2,74,6],[79,2,79,6],[86,2,86,6],[91,2,91,6],[146,2,146,6],[127,2,127,6],[134,2,134,6],[139,2,139,6],[98,2,98,6],[103,2,103,6],[110,2,110,6],[115,2,115,6],[122,2,122,6],[224,2,224,4],[225,2,225,4],[148,2,148,6],[218,2,218,4],[220,2,220,4],[217,2,217,4],[219,2,219,4],[221,2,221,4],[222,2,222,4],[223,2,223,4],[149,2,149,6],[158,2,158,6],[152,2,152,6],[151,2,151,3],[177,2,177,6],[153,2,153,6]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[null,null,"LCC-kalkyl Anläggning alternativ 1"]
[]
[null,null,"Kalkylförutsättningar (anges av beställaren)"]
[null,null,"PROJEKT:",null,null,"Projektnamn"]
[null,null,"DATUM:",null,null,"2016-01-01"]
[null,null,"HANDLÄGGARE:",null,null,"NAMN"]
[]
[null,"1.1","Tid kalkylen omfattar",null,null,null,null,null,"år"]
[null,"1.2","Kalkylränta",null,null,null,null,1.7500000000000002E-2]
[null,"1.3","Elpris",null,null,null,null,null,"kr/kWh"]
[null,"1.4","Årlig energiprisökning (frivillig)"]
[null,"1.5","Klimatpåverkan elanvändning (frivillig)",null,null,null,null,null,"kgCO2/kWh"]
[null,"1.6","Drifttid",null,null,null,null,null,"h/år"]
[]
[null,null,"Beskrivning av anläggningen och belysningsförslag"]
[]
[null,null,"BESKRIVNING AV ANLÄGGNINGEN (anges av beställaren)"]
[null,null,"Rumstyper",null,null,null,null,null,"Rumstyp 1","Rumstyp 2","Rumstyp 3","Rumstyp 4"]
[null,null,"Antal rum av samma typ",null,null,null,null,"stk",1,1,1,1]
[null,null,"Antal kvadratmeter",null,null,null,null,"m2/rum",1,1,1,1]
[null,null,"BELYSNINGSFÖRSLAG (anges av anbudsgivaren)"]
[null,null,"ARMATURTYP 1"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I34=$I$232,I35,IF(I34=$I$233,I35*I36,IF(I34=$I$234,I35*I36*I37,1)))","v":1},1,1,{"$f":"IF(L34=$I$232,L35,IF(L34=$I$233,L35*L36,IF(L34=$I$234,L35*L36*L37,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 2"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,1,{"$f":"IF(J46=$I$232,J47,IF(J46=$I$233,J47*J48,IF(J46=$I$234,J47*J48*J49,1)))","v":1},{"$f":"IF(K46=$I$232,K47,IF(K46=$I$233,K47*K48,IF(K46=$I$234,K47*K48*K49,1)))","v":1},{"$f":"IF(L46=$I$232,L47,IF(L46=$I$233,L47*L48,IF(L46=$I$234,L47*L48*L49,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 3"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I58=$I$232,I59,IF(I58=$I$233,I59*I60,IF(I58=$I$234,I59*I60*I61,1)))","v":1},{"$f":"IF(J58=$I$232,J59,IF(J58=$I$233,J59*J60,IF(J58=$I$234,J59*J60*J61,1)))","v":1},{"$f":"IF(K58=$I$232,K59,IF(K58=$I$233,K59*K60,IF(K58=$I$234,K59*K60*K61,1)))","v":1},{"$f":"IF(L58=$I$232,L59,IF(L58=$I$233,L59*L60,IF(L58=$I$234,L59*L60*L61,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 4"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I70=$I$232,I71,IF(I70=$I$233,I71*I72,IF(I70=$I$234,I71*I72*I73,1)))","v":1},{"$f":"IF(J70=$I$232,J71,IF(J70=$I$233,J71*J72,IF(J70=$I$234,J71*J72*J73,1)))","v":1},{"$f":"IF(K70=$I$232,K71,IF(K70=$I$233,K71*K72,IF(K70=$I$234,K71*K72*K73,1)))","v":1},{"$f":"IF(L70=$I$232,L71,IF(L70=$I$233,L71*L72,IF(L70=$I$234,L71*L72*L73,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 5"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I82=$I$232,I83,IF(I82=$I$233,I83*I84,IF(I82=$I$234,I83*I84*I85,1)))","v":1},{"$f":"IF(J82=$I$232,J83,IF(J82=$I$233,J83*J84,IF(J82=$I$234,J83*J84*J85,1)))","v":1},{"$f":"IF(K82=$I$232,K83,IF(K82=$I$233,K83*K84,IF(K82=$I$234,K83*K84*K85,1)))","v":1},{"$f":"IF(L82=$I$232,L83,IF(L82=$I$233,L83*L84,IF(L82=$I$234,L83*L84*L85,1)))","v":1}]
[null,"2.10","Underhållskostnader ",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 6"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I94=$I$232,I95,IF(I94=$I$233,I95*I96,IF(I94=$I$234,I95*I96*I97,1)))","v":1},{"$f":"IF(J94=$I$232,J95,IF(J94=$I$233,J95*J96,IF(J94=$I$234,J95*J96*J97,1)))","v":1},{"$f":"IF(K94=$I$232,K95,IF(K94=$I$233,K95*K96,IF(K94=$I$234,K95*K96*K97,1)))","v":1},{"$f":"IF(L94=$I$232,L95,IF(L94=$I$233,L95*L96,IF(L94=$I$234,L95*L96*L97,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 7"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I106=$I$232,I107,IF(I106=$I$233,I107*I108,IF(I106=$I$234,I107*I108*I109,1)))","v":1},{"$f":"IF(J106=$I$232,J107,IF(J106=$I$233,J107*J108,IF(J106=$I$234,J107*J108*J109,1)))","v":1},{"$f":"IF(K106=$I$232,K107,IF(K106=$I$233,K107*K108,IF(K106=$I$234,K107*K108*K109,1)))","v":1},{"$f":"IF(L106=$I$232,L107,IF(L106=$I$233,L107*L108,IF(L106=$I$234,L107*L108*L109,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 8"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I118=$I$232,I119,IF(I118=$I$233,I119*I120,IF(I118=$I$234,I119*I120*I121,1)))","v":1},{"$f":"IF(J118=$I$232,J119,IF(J118=$I$233,J119*J120,IF(J118=$I$234,J119*J120*J121,1)))","v":1},{"$f":"IF(K118=$I$232,K119,IF(K118=$I$233,K119*K120,IF(K118=$I$234,K119*K120*K121,1)))","v":1},{"$f":"IF(L118=$I$232,L119,IF(L118=$I$233,L119*L120,IF(L118=$I$234,L119*L120*L121,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 9"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I130=$I$232,I131,IF(I130=$I$233,I131*I132,IF(I130=$I$234,I131*I132*I133,1)))","v":1},{"$f":"IF(J130=$I$232,J131,IF(J130=$I$233,J131*J132,IF(J130=$I$234,J131*J132*J133,1)))","v":1},{"$f":"IF(K130=$I$232,K131,IF(K130=$I$233,K131*K132,IF(K130=$I$234,K131*K132*K133,1)))","v":1},{"$f":"IF(L130=$I$232,L131,IF(L130=$I$233,L131*L132,IF(L130=$I$234,L131*L132*L133,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 10"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I142=$I$232,I143,IF(I142=$I$233,I143*I144,IF(I142=$I$234,I143*I144*I145,1)))","v":1},{"$f":"IF(J142=$I$232,J143,IF(J142=$I$233,J143*J144,IF(J142=$I$234,J143*J144*J145,1)))","v":1},{"$f":"IF(K142=$I$232,K143,IF(K142=$I$233,K143*K144,IF(K142=$I$234,K143*K144*K145,1)))","v":1},{"$f":"IF(L142=$I$232,L143,IF(L142=$I$233,L143*L144,IF(L142=$I$234,L143*L144*L145,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"STYRUTRUSTNING"]
[null,"3.1","Kostnad extern styrutrustning",null,null,null,null,"kr/år"]
[]
[null,null,"Resultat"]
[null,null,null,null,null,null,null,null,{"$f":"I25","v":"Rumstyp 1"},{"$f":"J25","v":"Rumstyp 2"},{"$f":"K25","v":"Rumstyp 3"},{"$f":"L25","v":"Rumstyp 4"}]
[null,"4.1","Totalkostnad per rumstyp",null,null,null,null,"kr",{"$f":"I210*$I$212+I175+I194*$I$196","v":0},{"$f":"J210*$I$212+J175+J194*$I$196","v":0},{"$f":"K210*$I$212+K175+K194*$I$196","v":0},{"$f":"L210*$I$212+L175+L194*$I$196","v":0}]
[null,"4.2","LENI-tal per rumstyp",null,null,null,null,"kWh/m2/år",{"$f":"I216","v":0},{"$f":"J216","v":0},{"$f":"K216","v":0},0]
[null,null,"RESULTAT FÖR HELA ANLÄGGNINGEN"]
[null,"4.3","TOTAL KOSTNAD ",null,null,null,null,"kr",{"$f":"SUM(I197,I176,I213)","v":0}]
[null,"4.4","Energikostnad per år ",null,null,null,null,"kr",{"$f":"I195","v":0}]
[null,"4.5","Energikostnader under hela livslängden",null,null,null,null,"kr",{"$f":"I197","v":0}]
[null,"4.6","Klimatpåverkan",null,null,null,null,"kgCO2/år",{"$f":"SUM(I215:XFD215)","v":0}]
[]
[null,null,"LCC-kalkyl"]
[null,null,null,null,null,null,null,null,{"$f":"I153","v":"Rumstyp 1"},{"$f":"J153","v":"Rumstyp 2"},"Rumstyp 3","Rumstyp 4"]
[null,null,"INVESTERINGSKOSTNADER"]
[null,null,"Armatur 1",null,null,null,null,"kr",{"$f":"I26*(I30*(I31+I32))","v":0},{"$f":"J26*(J30*(J31+J32))","v":0},{"$f":"K26*(K30*(K31+K32))","v":0},{"$f":"L26*(L30*(L31+L32))","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kr",{"$f":"I26*(I42*(I43+I44))","v":0},{"$f":"J26*(J42*(J43+J44))","v":0},{"$f":"K26*(K42*(K43+K44))","v":0},{"$f":"L26*(L42*(L43+L44))","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kr",{"$f":"I26*(I54*(I55+I56))","v":0},{"$f":"J26*(J54*(J55+J56))","v":0},{"$f":"K26*(K54*(K55+K56))","v":0},{"$f":"L26*(L54*(L55+L56))","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kr",{"$f":"I26*(I66*(I67+I68))","v":0},{"$f":"J26*(J66*(J67+J68))","v":0},{"$f":"K26*(K66*(K67+K68))","v":0},{"$f":"L26*(L66*(L67+L68))","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kr",{"$f":"I26*(I78*(I79+I80))","v":0},{"$f":"J26*(J78*(J79+J80))","v":0},{"$f":"K26*(K78*(K79+K80))","v":0},{"$f":"L26*(L78*(L79+L80))","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kr",{"$f":"I26*(I90*(I91+I92))","v":0},{"$f":"J26*(J90*(J91+J92))","v":0},{"$f":"K26*(K90*(K91+K92))","v":0},{"$f":"L26*(L90*(L91+L92))","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kr",{"$f":"I26*(I102*(I103+I104))","v":0},{"$f":"J26*(J102*(J103+J104))","v":0},{"$f":"K26*(K102*(K103+K104))","v":0},{"$f":"L26*(L102*(L103+L104))","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kr",{"$f":"I26*(I114*(I115+I116))","v":0},{"$f":"J26*(J114*(J115+J116))","v":0},{"$f":"K26*(K114*(K115+K116))","v":0},{"$f":"L26*(L114*(L115+L116))","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kr",{"$f":"I26*(I126*(I127+I128))","v":0},{"$f":"J26*(J126*(J127+J128))","v":0},{"$f":"K26*(K126*(K127+K128))","v":0},{"$f":"L26*(L126*(L127+L128))","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kr",{"$f":"I26*(I138*(I139+I140))","v":0},{"$f":"J26*(J138*(J139+J140))","v":0},{"$f":"K26*(K138*(K139+K140))","v":0},{"$f":"L26*(L138*(L139+L140))","v":0}]
[null,null,"Summa investeringskostnader per rumstyp",null,null,null,null,"kr",{"$f":"SUM(I165:I174)+I150","v":0},{"$f":"SUM(J165:J174)+J150","v":0},{"$f":"SUM(K165:K174)+K150","v":0},{"$f":"SUM(L165:L174)+L150","v":0}]
[null,null,"S:A investeringskostnader hela anläggningen",null,null,null,null,"kr",{"$f":"SUM(I175:XFD175)","v":0}]
[]
[null,null,"ENERGI- & UNDERHÅLLSKOSTNADER"]
[null,null,"ENERGIKOSTNADER"]
[null,null,"Energianvändning "]
[null,null,"Armatur 1",null,null,null,null,"kWh",{"$f":"(I$26*I30*I33*I38*$H$20)/1000","v":0},{"$f":"(J$26*J30*J33*J38*$H$20)/1000","v":0},{"$f":"(K$26*K30*K33*K38*$H$20)/1000","v":0},{"$f":"(L$26*L30*L33*L38*$H$20)/1000","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kWh",{"$f":"(I$26*I42*I45*I50*$H$20)/1000","v":0},{"$f":"(J$26*J42*J45*J50*$H$20)/1000","v":0},{"$f":"(K$26*K42*K45*K50*$H$20)/1000","v":0},{"$f":"(L$26*L42*L45*L50*$H$20)/1000","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kWh",{"$f":"(I$26*I54*I57*I62*$H$20)/1000","v":0},{"$f":"(J$26*J54*J57*J62*$H$20)/1000","v":0},{"$f":"(K$26*K54*K57*K62*$H$20)/1000","v":0},{"$f":"(L$26*L54*L57*L62*$H$20)/1000","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kWh",{"$f":"(I$26*I66*I69*I74*$H$20)/1000","v":0},{"$f":"(J$26*J66*J69*J74*$H$20)/1000","v":0},{"$f":"(K$26*K66*K69*K74*$H$20)/1000","v":0},{"$f":"(L$26*L66*L69*L74*$H$20)/1000","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kWh",{"$f":"(I$26*I78*I81*I86*$H$20)/1000","v":0},{"$f":"(J$26*J78*J81*J86*$H$20)/1000","v":0},{"$f":"(K$26*K78*K81*K86*$H$20)/1000","v":0},{"$f":"(L$26*L78*L81*L86*$H$20)/1000","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kWh",{"$f":"(I$26*I90*I93*I98*$H$20)/1000","v":0},{"$f":"(J$26*J90*J93*J98*$H$20)/1000","v":0},{"$f":"(K$26*K90*K93*K98*$H$20)/1000","v":0},{"$f":"(L$26*L90*L93*L98*$H$20)/1000","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kWh",{"$f":"(I$26*I102*I105*I110*$H$20)/1000","v":0},{"$f":"(J$26*J102*J105*J110*$H$20)/1000","v":0},{"$f":"(K$26*K102*K105*K110*$H$20)/1000","v":0},{"$f":"(L$26*L102*L105*L110*$H$20)/1000","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kWh",{"$f":"(I$26*I114*I117*I122*$H$20)/1000","v":0},{"$f":"(J$26*J114*J117*J122*$H$20)/1000","v":0},{"$f":"(K$26*K114*K117*K122*$H$20)/1000","v":0},{"$f":"(L$26*L114*L117*L122*$H$20)/1000","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kWh",{"$f":"(I$26*I126*I129*I134*$H$20)/1000","v":0},{"$f":"(J$26*J126*J129*J134*$H$20)/1000","v":0},{"$f":"(K$26*K126*K129*K134*$H$20)/1000","v":0},{"$f":"(L$26*L126*L129*L134*$H$20)/1000","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kWh",{"$f":"(I$26*I138*I141*I146*$H$20)/1000","v":0},{"$f":"(J$26*J138*J141*J146*$H$20)/1000","v":0},{"$f":"(K$26*K138*K141*K146*$H$20)/1000","v":0},{"$f":"(L$26*L138*L141*L146*$H$20)/1000","v":0}]
[null,null,"Summa energianvändning per rumstyp",null,null,null,null,"kWh/år",{"$f":"SUM(I181:I190)","v":0},{"$f":"SUM(J181:J190)","v":0},0,0]
[null,null,"Summa energianvändning hela anläggningen",null,null,null,null,"kWh/år",{"$f":"SUM(I191:XFD191)","v":0}]
[]
[null,null,"Årlig energikostnad per rumstyp",null,null,null,null,null,{"$f":"$H$17*I191","v":0},{"$f":"$H$17*J191","v":0},0,0]
[null,null,"Årlig energikostnad hela anläggningen",null,null,null,null,null,{"$f":"I192*H17","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"IF($H$16=$H$18,$H$15,(1/($H$16-$H$18))*(1-((1+$H$18)/(1+$H$16))^$H$15))","v":0}]
[null,null,"Energikostnader under hela livslängden",null,null,null,null,null,{"$f":"I195*I196","v":0}]
[]
[null,null,"UNDERHÅLLSKOSTNADER"]
[null,null,"Underhållskostnader armaturtyp 1 ",null,null,null,null,"kr/år",{"$f":"I39","v":0},{"$f":"J39","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 2",null,null,null,null,"kr/år",{"$f":"I51","v":0},{"$f":"J51","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 3",null,null,null,null,"kr/år",{"$f":"I63","v":0},{"$f":"J63","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 4",null,null,null,null,"kr/år",{"$f":"I75","v":0},{"$f":"J75","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 5",null,null,null,null,"kr/år",{"$f":"I87","v":0},{"$f":"J87","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 6",null,null,null,null,"kr/år",{"$f":"I99","v":0},{"$f":"J99","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 7",null,null,null,null,"kr/år",{"$f":"I111","v":0},{"$f":"J111","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 8",null,null,null,null,"kr/år",{"$f":"I123","v":0},{"$f":"J123","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 9",null,null,null,null,"kr/år",{"$f":"I135","v":0},{"$f":"J135","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 10",null,null,null,null,"kr/år",{"$f":"I147","v":0},{"$f":"J147","v":0},0,0]
[null,null,"Summa underhålllskostnader per rumstyp",null,null,null,null,"kr/år",{"$f":"SUM(I200:I209)","v":0},{"$f":"SUM(J200:J209)","v":0},{"$f":"SUM(K200:K209)","v":0},{"$f":"SUM(L200:L209)","v":0}]
[null,null,"Underhållskostnader hela anläggningen",null,null,null,null,null,{"$f":"SUM(I210:XFD210)","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"(1/$H$16)*(1-(1/(1+$H$16))^$H$15)","v":0}]
[null,null,"Underhållskostnader under hela livslängden",null,null,null,null,null,{"$f":"I211*I212","v":0}]
[]
[null,null,"Klimatpåverkan för varje rumstyp",null,null,null,null,null,{"$f":"SUM(I181:I190)*$H$19","v":0},{"$f":"SUM(J181:J190)*$H$19","v":0},0,0]
[null,null,"LENI-tal per rumstyp",null,null,null,null,"kWh/m2, år",{"$f":"SUM(I217:I226)","v":0},{"$f":"SUM(J217:J226)","v":0},{"$f":"SUM(K217:K226)","v":0},{"$f":"SUM(L217:L226)","v":0}]
[null,null,"LENI-tal armaturtyp 1",null,null,null,null,"kWh/m2, år",{"$f":"(I30*I33*$H$20*I38/1000)/I27","v":0},{"$f":"(J30*J33*$H$20*J38/1000)/J27","v":0},{"$f":"(K30*K33*$H$20*K38/1000)/K27","v":0},{"$f":"(L30*L33*$H$20*L38/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 2",null,null,null,null,"kWh/m2, år",{"$f":"(I42*I45*$H$20*I50/1000)/I27","v":0},{"$f":"(J42*J45*$H$20*J50/1000)/J27","v":0},{"$f":"(K42*K45*$H$20*K50/1000)/K27","v":0},{"$f":"(L42*L45*$H$20*L50/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 3",null,null,null,null,"kWh/m2, år",{"$f":"(I54*I57*$H$20*I62/1000)/I27","v":0},{"$f":"(J54*J57*$H$20*J62/1000)/J27","v":0},{"$f":"(K54*K57*$H$20*K62/1000)/K27","v":0},{"$f":"(L54*L57*$H$20*L62/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 4",null,null,null,null,"kWh/m2, år",{"$f":"(I66*I69*$H$20*I74/1000)/I27","v":0},{"$f":"(J66*J69*$H$20*J74/1000)/J27","v":0},{"$f":"(K66*K69*$H$20*K74/1000)/K27","v":0},{"$f":"(L66*L69*$H$20*L74/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 5",null,null,null,null,"kWh/m2, år",{"$f":"(I78*I81*$H$20*I86/1000)/I27","v":0},{"$f":"(J78*J81*$H$20*J86/1000)/J27","v":0},{"$f":"(K78*K81*$H$20*K86/1000)/K27","v":0},{"$f":"(L78*L81*$H$20*L86/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 6",null,null,null,null,"kWh/m2, år",{"$f":"(I90*I93*$H$20*I98/1000)/I27","v":0},{"$f":"(J90*J93*$H$20*J98/1000)/J27","v":0},{"$f":"(K90*K93*$H$20*K98/1000)/K27","v":0},{"$f":"(L90*L93*$H$20*L98/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 7",null,null,null,null,"kWh/m2, år",{"$f":"(I102*I105*$H$20*I110/1000)/I27","v":0},{"$f":"(J102*J105*$H$20*J110/1000)/J27","v":0},{"$f":"(K102*K105*$H$20*K110/1000)/K27","v":0},{"$f":"(L102*L105*$H$20*L110/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 8",null,null,null,null,"kWh/m2, år",{"$f":"(I114*I117*$H$20*I120/1000)/I27","v":0},{"$f":"(J114*J117*$H$20*J120/1000)/J27","v":0},{"$f":"(K114*K117*$H$20*K120/1000)/K27","v":0},{"$f":"(L114*L117*$H$20*L120/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 9",null,null,null,null,"kWh/m2, år",{"$f":"(I126*I129*$H$20*I134/1000)/I27","v":0},{"$f":"(J126*J129*$H$20*J134/1000)/J27","v":0},{"$f":"(K126*K129*$H$20*K134/1000)/K27","v":0},{"$f":"(L126*L129*$H$20*L134/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 10",null,null,null,null,"kWh/m2, år",{"$f":"(I138*I141*$H$20*I146/1000)/I27","v":0},{"$f":"(J138*J141*$H$20*J146/1000)/J27","v":0},{"$f":"(K138*K141*$H$20*K146/1000)/K27","v":0},{"$f":"(L138*L141*$H$20*L146/1000)/L27","v":0}]
[]
[null,null,"S:A ENERGI- & UNDERHÅLLSKOSTNADER",null,null,null,null,"kr",{"$f":"I213+I197","v":0}]
[null,null,"TOTALKOSTNAD HELA ANLÄGGNINGEN",null,null,null,null,"kr",{"$f":"I228+I176","v":0}]
[]
[null,null,null,null,null,null,null,null,"Ingen"]
[null,null,null,null,null,null,null,null,"Manuell"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro + Dagsljus"]

{"sheet":"TEMP","index":2,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"MSR:S LCC-KALKYL FÖR UTOMHUSBELYSNING"]
[null,null,"Version  2.1 2011-07-04"]
[]
[null,null,"Livscykelkostnader"]
[null,null,"Livscykelkostnadsanalyser beaktar den totala kostnaden för en produkt under livscykeln. Den tar därmed inte bara hänsyn till grundinvesteringen utan också till drift- och underhållskostnader. Andra kostnader som kan vara viktiga i sammanhanget är miljöskatter samt avvecklingskostnader men även inkomster såsom subventioner och restvärde kan förändra kostnadsbilden."]
[]
[null,null,"Verktyget"]
[null,null,"Utomhusbelysning är den näst största posten i kommunernas drift- och underhållskostnader och står för ca 25 % av kostnaderna. Största posten i gatubelysningen är elförbrukningen, och belysningskostnaden har ökat med ca 9 % senaste åren på grund av ökande elpriser. Kommuner kan exempelvis spara uppåt 3,2 miljoner kr/år på en investering av 301 000 kr genom att välja mer energisnål belysning.\nMiljöstyrningsrådets LCC-verktyg för utomhusbelysning är ursprungligen framtaget av Aton Teknik Konsult på uppdrag av Ljuskultur enligt riktlinjer från Energimyndigheten. Om verktyget används i anbudsutvärderingen är de viktigt att man tydligt definierar vilka parametrar som kommer att användas samt vad leverantören ska inkomma med för information. "]
[null,null,"Verktyget är i ursprungsläget låst för redigering men kan låsas upp genom menyn Verktyg /Skydd/ Ta bort bladets skydd."]
[]
[null,null,"Miljöstyrningsrådet - Vägledning för hållbar upphandling"]
[null,null,"Miljöstyrningsrådet arbetar för att bidra till en hållbar utveckling genom att stödja företag och offentlig förvaltning i deras miljöarbete på ett strategiskt och kostnadseffektivt sätt. Med tre huvudsakliga verktyg och tjänster erbjuder Miljöstyrningsråd vägledning för hållbar upphandling, miljöledning och miljörelaterad produktinformation. På Miljöstyrningsrådets hemsida, www.msr.se, hittar du mer information om LCC och övrig verksamhet."]
[]
[null,null,"Kontakt"]
[null,null,"För frågor och synpunkter angående LCC och detta verktyg kontakta helpdesk@msr.se eller tfn 08-50 10 55 50."]
[]
[]
[]
[null,null," "]
[null,null,"Miljöstyrningsrådet"]
[null,null,"Vasagatan 15-17"]
[null,null,"111 20 Stockholm"]
[null,null,"info@msr.se"]
[]
[]
[]
[]
[null,">","KLICKA HÄR FÖR ATT VISA LCC-KALKYLEN"]

{"sheet":"2. LCC A2","index":3,"n_rows":234,"n_cols":12,"rows_kept":234,"cut":false,"hidden":false,"merged":[[225,2,225,4],[219,2,219,4],[220,2,220,4],[221,2,221,4],[222,2,222,4],[223,2,223,4],[224,2,224,4],[218,2,218,4],[152,2,152,6],[153,2,153,6],[154,2,154,4],[156,2,156,6],[157,2,157,6],[158,2,158,6],[159,2,159,6],[160,2,160,6],[177,2,177,6],[216,2,216,4],[217,2,217,4],[151,2,151,3],[98,2,98,6],[103,2,103,6],[110,2,110,6],[115,2,115,6],[122,2,122,6],[127,2,127,6],[134,2,134,6],[139,2,139,6],[146,2,146,6],[148,2,148,6],[149,2,149,6],[91,2,91,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[43,2,43,6],[50,2,50,6],[55,2,55,6],[62,2,62,6],[67,2,67,6],[74,2,74,6],[79,2,79,6],[86,2,86,6],[34,2,34,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[17,2,17,6],[5,2,5,3],[5,4,5,6],[5,7,5,8],[10,2,10,4],[10,5,10,8],[11,2,11,4],[11,5,11,8],[12,2,12,4],[12,5,12,8],[14,2,14,6],[15,2,15,6],[16,2,16,6]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[null,null,"LCC-kalkyl Anläggning alternativ 2"]
[]
[null,null,"Kalkylförutsättningar (anges av beställaren)"]
[null,null,"PROJEKT:",null,null,"Projektnamn"]
[null,null,"DATUM:",null,null,"2016-01-01"]
[null,null,"HANDLÄGGARE:",null,null,"NAMN"]
[]
[null,"1.1","Tid kalkylen omfattar",null,null,null,null,null,"år"]
[null,"1.2","Kalkylränta",null,null,null,null,1.7500000000000002E-2]
[null,"1.3","Elpris",null,null,null,null,null,"kr/kWh"]
[null,"1.4","Årlig energiprisökning (frivillig)"]
[null,"1.5","Klimatpåverkan elanvändning (frivillig)",null,null,null,null,null,"kgCO2/kWh"]
[null,"1.6","Drifttid",null,null,null,null,null,"h/år"]
[]
[null,null,"Beskrivning av anläggningen och belysningsförslag"]
[]
[null,null,"BESKRIVNING AV ANLÄGGNINGEN (anges av beställaren)"]
[null,null,"Rumstyper",null,null,null,null,null,"Rumstyp 1","Rumstyp 2","Rumstyp 3","Rumstyp 4"]
[null,null,"Antal rum av samma typ",null,null,null,null,"stk",1,1,1,1]
[null,null,"Antal kvadratmeter",null,null,null,null,"m2/rum",1,1,1,1]
[null,null,"BELYSNINGSFÖRSLAG (anges av anbudsgivaren)"]
[null,null,"ARMATURTYP 1"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I34=$I$232,I35,IF(I34=$I$233,I35*I36,IF(I34=$I$234,I35*I36*I37,1)))","v":1},1,1,{"$f":"IF(L34=$I$232,L35,IF(L34=$I$233,L35*L36,IF(L34=$I$234,L35*L36*L37,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 2"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I46=$I$232,I47,IF(I46=$I$233,I47*I48,IF(I46=$I$234,I47*I48*I49,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 3"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I58=$I$232,I59,IF(I58=$I$233,I59*I60,IF(I58=$I$234,I59*I60*I61,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 4"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I70=$I$232,I71,IF(I70=$I$233,I71*I72,IF(I70=$I$234,I71*I72*I73,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 5"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I82=$I$232,I83,IF(I82=$I$233,I83*I84,IF(I82=$I$234,I83*I84*I85,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader ",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 6"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I94=$I$232,I95,IF(I94=$I$233,I95*I96,IF(I94=$I$234,I95*I96*I97,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 7"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I106=$I$232,I107,IF(I106=$I$233,I107*I108,IF(I106=$I$234,I107*I108*I109,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 8"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I118=$I$232,I119,IF(I118=$I$233,I119*I120,IF(I118=$I$234,I119*I120*I121,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 9"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I130=$I$232,I131,IF(I130=$I$233,I131*I132,IF(I130=$I$234,I131*I132*I133,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 10"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I142=$I$232,I143,IF(I142=$I$233,I143*I144,IF(I142=$I$234,I143*I144*I145,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"STYRUTRUSTNING"]
[null,"3.1","Kostnad extern styrutrustning",null,null,null,null,"kr/år"]
[]
[null,null,"Resultat"]
[null,null,null,null,null,null,null,null,{"$f":"I25","v":"Rumstyp 1"},{"$f":"J25","v":"Rumstyp 2"},{"$f":"K25","v":"Rumstyp 3"},{"$f":"L25","v":"Rumstyp 4"}]
[null,"4.1","Totalkostnad per rumstyp",null,null,null,null,"kr",{"$f":"I210*$I$212+I175+I194*$I$196","v":0},{"$f":"J210*$I$212+J175+J194*$I$196","v":0},{"$f":"K210*$I$212+K175+K194*$I$196","v":0},{"$f":"L210*$I$212+L175+L194*$I$196","v":0}]
[null,"4.2","LENI-tal per rumstyp",null,null,null,null,"kWh/m2/år",{"$f":"I216","v":0},{"$f":"J216","v":0},{"$f":"K216","v":0},0]
[null,null,"RESULTAT FÖR HELA ANLÄGGNINGEN"]
[null,"4.3","TOTAL KOSTNAD",null,null,null,null,"kr",{"$f":"SUM(I197,I176,I213)","v":0}]
[null,"4.4","Energikostnad per år ",null,null,null,null,"kr",{"$f":"I195","v":0}]
[null,"4.5","Energikostnader under hela livslängden",null,null,null,null,"kr",{"$f":"I197","v":0}]
[null,"4.6","Klimatpåverkan",null,null,null,null,"kgCO2/år",{"$f":"SUM(I215:XFD215)","v":0}]
[]
[null,null,"LCC-kalkyl"]
[null,null,null,null,null,null,null,null,{"$f":"I153","v":"Rumstyp 1"},{"$f":"J153","v":"Rumstyp 2"},"Rumstyp 3","Rumstyp 4"]
[null,null,"INVESTERINGSKOSTNADER"]
[null,null,"Armatur 1",null,null,null,null,"kr",{"$f":"I26*(I30*(I31+I32))","v":0},{"$f":"J26*(J30*(J31+J32))","v":0},{"$f":"K26*(K30*(K31+K32))","v":0},{"$f":"L26*(L30*(L31+L32))","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kr",{"$f":"I26*(I42*(I43+I44))","v":0},{"$f":"J26*(J42*(J43+J44))","v":0},{"$f":"K26*(K42*(K43+K44))","v":0},{"$f":"L26*(L42*(L43+L44))","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kr",{"$f":"I26*(I54*(I55+I56))","v":0},{"$f":"J26*(J54*(J55+J56))","v":0},{"$f":"K26*(K54*(K55+K56))","v":0},{"$f":"L26*(L54*(L55+L56))","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kr",{"$f":"I26*(I66*(I67+I68))","v":0},{"$f":"J26*(J66*(J67+J68))","v":0},{"$f":"K26*(K66*(K67+K68))","v":0},{"$f":"L26*(L66*(L67+L68))","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kr",{"$f":"I26*(I78*(I79+I80))","v":0},{"$f":"J26*(J78*(J79+J80))","v":0},{"$f":"K26*(K78*(K79+K80))","v":0},{"$f":"L26*(L78*(L79+L80))","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kr",{"$f":"I26*(I90*(I91+I92))","v":0},{"$f":"J26*(J90*(J91+J92))","v":0},{"$f":"K26*(K90*(K91+K92))","v":0},{"$f":"L26*(L90*(L91+L92))","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kr",{"$f":"I26*(I102*(I103+I104))","v":0},{"$f":"J26*(J102*(J103+J104))","v":0},{"$f":"K26*(K102*(K103+K104))","v":0},{"$f":"L26*(L102*(L103+L104))","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kr",{"$f":"I26*(I114*(I115+I116))","v":0},{"$f":"J26*(J114*(J115+J116))","v":0},{"$f":"K26*(K114*(K115+K116))","v":0},{"$f":"L26*(L114*(L115+L116))","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kr",{"$f":"I26*(I126*(I127+I128))","v":0},{"$f":"J26*(J126*(J127+J128))","v":0},{"$f":"K26*(K126*(K127+K128))","v":0},{"$f":"L26*(L126*(L127+L128))","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kr",{"$f":"I26*(I138*(I139+I140))","v":0},{"$f":"J26*(J138*(J139+J140))","v":0},{"$f":"K26*(K138*(K139+K140))","v":0},{"$f":"L26*(L138*(L139+L140))","v":0}]
[null,null,"Summa investeringskostnader per rumstyp",null,null,null,null,"kr",{"$f":"SUM(I165:I174)+I150","v":0},{"$f":"SUM(J165:J174)+J150","v":0},{"$f":"SUM(K165:K174)+K150","v":0},{"$f":"SUM(L165:L174)+L150","v":0}]
[null,null,"S:A investeringskostnader hela anläggningen",null,null,null,null,"kr",{"$f":"SUM(I175:XFD175)","v":0}]
[]
[null,null,"ENERGI- & UNDERHÅLLSKOSTNADER"]
[null,null,"ENERGIKOSTNADER"]
[null,null,"Energianvändning "]
[null,null,"Armatur 1",null,null,null,null,"kWh",{"$f":"(I$26*I30*I33*I38*$H$20)/1000","v":0},{"$f":"(J$26*J30*J33*J38*$H$20)/1000","v":0},{"$f":"(K$26*K30*K33*K38*$H$20)/1000","v":0},{"$f":"(L$26*L30*L33*L38*$H$20)/1000","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kWh",{"$f":"(I$26*I42*I45*I50*$H$20)/1000","v":0},{"$f":"(J$26*J42*J45*J50*$H$20)/1000","v":0},{"$f":"(K$26*K42*K45*K50*$H$20)/1000","v":0},{"$f":"(L$26*L42*L45*L50*$H$20)/1000","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kWh",{"$f":"(I$26*I54*I57*I62*$H$20)/1000","v":0},{"$f":"(J$26*J54*J57*J62*$H$20)/1000","v":0},{"$f":"(K$26*K54*K57*K62*$H$20)/1000","v":0},{"$f":"(L$26*L54*L57*L62*$H$20)/1000","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kWh",{"$f":"(I$26*I66*I69*I74*$H$20)/1000","v":0},{"$f":"(J$26*J66*J69*J74*$H$20)/1000","v":0},{"$f":"(K$26*K66*K69*K74*$H$20)/1000","v":0},{"$f":"(L$26*L66*L69*L74*$H$20)/1000","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kWh",{"$f":"(I$26*I78*I81*I86*$H$20)/1000","v":0},{"$f":"(J$26*J78*J81*J86*$H$20)/1000","v":0},{"$f":"(K$26*K78*K81*K86*$H$20)/1000","v":0},{"$f":"(L$26*L78*L81*L86*$H$20)/1000","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kWh",{"$f":"(I$26*I90*I93*I98*$H$20)/1000","v":0},{"$f":"(J$26*J90*J93*J98*$H$20)/1000","v":0},{"$f":"(K$26*K90*K93*K98*$H$20)/1000","v":0},{"$f":"(L$26*L90*L93*L98*$H$20)/1000","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kWh",{"$f":"(I$26*I102*I105*I110*$H$20)/1000","v":0},{"$f":"(J$26*J102*J105*J110*$H$20)/1000","v":0},{"$f":"(K$26*K102*K105*K110*$H$20)/1000","v":0},{"$f":"(L$26*L102*L105*L110*$H$20)/1000","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kWh",{"$f":"(I$26*I114*I117*I122*$H$20)/1000","v":0},{"$f":"(J$26*J114*J117*J122*$H$20)/1000","v":0},{"$f":"(K$26*K114*K117*K122*$H$20)/1000","v":0},{"$f":"(L$26*L114*L117*L122*$H$20)/1000","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kWh",{"$f":"(I$26*I126*I129*I134*$H$20)/1000","v":0},{"$f":"(J$26*J126*J129*J134*$H$20)/1000","v":0},{"$f":"(K$26*K126*K129*K134*$H$20)/1000","v":0},{"$f":"(L$26*L126*L129*L134*$H$20)/1000","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kWh",{"$f":"(I$26*I138*I141*I146*$H$20)/1000","v":0},{"$f":"(J$26*J138*J141*J146*$H$20)/1000","v":0},{"$f":"(K$26*K138*K141*K146*$H$20)/1000","v":0},{"$f":"(L$26*L138*L141*L146*$H$20)/1000","v":0}]
[null,null,"Summa energianvändning per rumstyp",null,null,null,null,"kWh/år",{"$f":"SUM(I181:I190)","v":0},{"$f":"SUM(J181:J190)","v":0},0,0]
[null,null,"Summa energianvändning hela anläggningen",null,null,null,null,"kWh/år",{"$f":"SUM(I191:XFD191)","v":0}]
[]
[null,null,"Årlig energikostnad per rumstyp",null,null,null,null,null,{"$f":"$H$17*I191","v":0},{"$f":"$H$17*J191","v":0},0,0]
[null,null,"Årlig energikostnad hela anläggningen",null,null,null,null,null,{"$f":"I192*H17","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"IF($H$16=$H$18,$H$15,(1/($H$16-$H$18))*(1-((1+$H$18)/(1+$H$16))^$H$15))","v":0}]
[null,null,"Energikostnader under hela livslängden",null,null,null,null,null,{"$f":"I195*I196","v":0}]
[]
[null,null,"UNDERHÅLLSKOSTNADER"]
[null,null,"Underhållskostnader armaturtyp 1 ",null,null,null,null,"kr/år",{"$f":"I39","v":0},{"$f":"J39","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 2",null,null,null,null,"kr/år",{"$f":"I51","v":0},{"$f":"J51","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 3",null,null,null,null,"kr/år",{"$f":"I63","v":0},{"$f":"J63","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 4",null,null,null,null,"kr/år",{"$f":"I75","v":0},{"$f":"J75","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 5",null,null,null,null,"kr/år",{"$f":"I87","v":0},{"$f":"J87","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 6",null,null,null,null,"kr/år",{"$f":"I99","v":0},{"$f":"J99","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 7",null,null,null,null,"kr/år",{"$f":"I111","v":0},{"$f":"J111","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 8",null,null,null,null,"kr/år",{"$f":"I123","v":0},{"$f":"J123","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 9",null,null,null,null,"kr/år",{"$f":"I135","v":0},{"$f":"J135","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 10",null,null,null,null,"kr/år",{"$f":"I147","v":0},{"$f":"J147","v":0},0,0]
[null,null,"Summa underhålllskostnader per rumstyp",null,null,null,null,"kr/år",{"$f":"SUM(I200:I209)","v":0},{"$f":"SUM(J200:J209)","v":0},{"$f":"SUM(K200:K209)","v":0},{"$f":"SUM(L200:L209)","v":0}]
[null,null,"Underhållskostnader hela anläggningen",null,null,null,null,null,{"$f":"SUM(I210:XFD210)","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"(1/$H$16)*(1-(1/(1+$H$16))^$H$15)","v":0}]
[null,null,"Underhållskostnader under hela livslängden",null,null,null,null,null,{"$f":"I211*I212","v":0}]
[]
[null,null,"Klimatpåverkan för varje rumstyp",null,null,null,null,null,{"$f":"SUM(I181:I190)*$H$19","v":0},{"$f":"SUM(J181:J190)*$H$19","v":0},0,0]
[null,null,"LENI-tal per rumstyp",null,null,null,null,"kWh/m2, år",{"$f":"SUM(I217:I226)","v":0},{"$f":"SUM(J217:J226)","v":0},{"$f":"SUM(K217:K226)","v":0},{"$f":"SUM(L217:L226)","v":0}]
[null,null,"LENI-tal armaturtyp 1",null,null,null,null,"kWh/m2, år",{"$f":"(I30*I33*$H$20*I38/1000)/I27","v":0},{"$f":"(J30*J33*$H$20*J38/1000)/J27","v":0},{"$f":"(K30*K33*$H$20*K38/1000)/K27","v":0},{"$f":"(L30*L33*$H$20*L38/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 2",null,null,null,null,"kWh/m2, år",{"$f":"(I42*I45*$H$20*I50/1000)/I27","v":0},{"$f":"(J42*J45*$H$20*J50/1000)/J27","v":0},{"$f":"(K42*K45*$H$20*K50/1000)/K27","v":0},{"$f":"(L42*L45*$H$20*L50/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 3",null,null,null,null,"kWh/m2, år",{"$f":"(I54*I57*$H$20*I62/1000)/I27","v":0},{"$f":"(J54*J57*$H$20*J62/1000)/J27","v":0},{"$f":"(K54*K57*$H$20*K62/1000)/K27","v":0},{"$f":"(L54*L57*$H$20*L62/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 4",null,null,null,null,"kWh/m2, år",{"$f":"(I66*I69*$H$20*I74/1000)/I27","v":0},{"$f":"(J66*J69*$H$20*J74/1000)/J27","v":0},{"$f":"(K66*K69*$H$20*K74/1000)/K27","v":0},{"$f":"(L66*L69*$H$20*L74/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 5",null,null,null,null,"kWh/m2, år",{"$f":"(I78*I81*$H$20*I86/1000)/I27","v":0},{"$f":"(J78*J81*$H$20*J86/1000)/J27","v":0},{"$f":"(K78*K81*$H$20*K86/1000)/K27","v":0},{"$f":"(L78*L81*$H$20*L86/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 6",null,null,null,null,"kWh/m2, år",{"$f":"(I90*I93*$H$20*I98/1000)/I27","v":0},{"$f":"(J90*J93*$H$20*J98/1000)/J27","v":0},{"$f":"(K90*K93*$H$20*K98/1000)/K27","v":0},{"$f":"(L90*L93*$H$20*L98/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 7",null,null,null,null,"kWh/m2, år",{"$f":"(I102*I105*$H$20*I110/1000)/I27","v":0},{"$f":"(J102*J105*$H$20*J110/1000)/J27","v":0},{"$f":"(K102*K105*$H$20*K110/1000)/K27","v":0},{"$f":"(L102*L105*$H$20*L110/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 8",null,null,null,null,"kWh/m2, år",{"$f":"(I114*I117*$H$20*I120/1000)/I27","v":0},{"$f":"(J114*J117*$H$20*J120/1000)/J27","v":0},{"$f":"(K114*K117*$H$20*K120/1000)/K27","v":0},{"$f":"(L114*L117*$H$20*L120/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 9",null,null,null,null,"kWh/m2, år",{"$f":"(I126*I129*$H$20*I134/1000)/I27","v":0},{"$f":"(J126*J129*$H$20*J134/1000)/J27","v":0},{"$f":"(K126*K129*$H$20*K134/1000)/K27","v":0},{"$f":"(L126*L129*$H$20*L134/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 10",null,null,null,null,"kWh/m2, år",{"$f":"(I138*I141*$H$20*I146/1000)/I27","v":0},{"$f":"(J138*J141*$H$20*J146/1000)/J27","v":0},{"$f":"(K138*K141*$H$20*K146/1000)/K27","v":0},{"$f":"(L138*L141*$H$20*L146/1000)/L27","v":0}]
[]
[null,null,"S:A ENERGI- & UNDERHÅLLSKOSTNADER",null,null,null,null,"kr",{"$f":"I213+I197","v":0}]
[null,null,"TOTALKOSTNAD HELA ANLÄGGNINGEN",null,null,null,null,"kr",{"$f":"I228+I176","v":0}]
[]
[null,null,null,null,null,null,null,null,"Ingen"]
[null,null,null,null,null,null,null,null,"Manuell"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro + Dagsljus"]

{"sheet":"2. LCC A3","index":4,"n_rows":234,"n_cols":12,"rows_kept":234,"cut":false,"hidden":false,"merged":[[225,2,225,4],[219,2,219,4],[220,2,220,4],[221,2,221,4],[222,2,222,4],[223,2,223,4],[224,2,224,4],[218,2,218,4],[152,2,152,6],[153,2,153,6],[154,2,154,4],[156,2,156,6],[157,2,157,6],[158,2,158,6],[159,2,159,6],[160,2,160,6],[177,2,177,6],[216,2,216,4],[217,2,217,4],[151,2,151,3],[98,2,98,6],[103,2,103,6],[110,2,110,6],[115,2,115,6],[122,2,122,6],[127,2,127,6],[134,2,134,6],[139,2,139,6],[146,2,146,6],[148,2,148,6],[149,2,149,6],[91,2,91,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[43,2,43,6],[50,2,50,6],[55,2,55,6],[62,2,62,6],[67,2,67,6],[74,2,74,6],[79,2,79,6],[86,2,86,6],[34,2,34,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[17,2,17,6],[5,2,5,3],[5,4,5,6],[5,7,5,8],[10,2,10,4],[10,5,10,8],[11,2,11,4],[11,5,11,8],[12,2,12,4],[12,5,12,8],[14,2,14,6],[15,2,15,6],[16,2,16,6]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[null,null,"LCC-kalkyl Anläggning alternativ 3"]
[]
[null,null,"Kalkylförutsättningar (anges av beställaren)"]
[null,null,"PROJEKT:",null,null,"Projektnamn"]
[null,null,"DATUM:",null,null,"2016-01-01"]
[null,null,"HANDLÄGGARE:",null,null,"NAMN"]
[]
[null,"1.1","Tid kalkylen omfattar",null,null,null,null,null,"år"]
[null,"1.2","Kalkylränta",null,null,null,null,1.7500000000000002E-2]
[null,"1.3","Elpris",null,null,null,null,null,"kr/kWh"]
[null,"1.4","Årlig energiprisökning (frivillig)"]
[null,"1.5","Klimatpåverkan elanvändning (frivillig)",null,null,null,null,null,"kgCO2/kWh"]
[null,"1.6","Drifttid",null,null,null,null,null,"h/år"]
[]
[null,null,"Beskrivning av anläggningen och belysningsförslag"]
[]
[null,null,"BESKRIVNING AV ANLÄGGNINGEN (anges av beställaren)"]
[null,null,"Rumstyp",null,null,null,null,null,"Typrum1","Typrum2","Typrum3","Typrum4"]
[null,null,"Antal rum av samma typ",null,null,null,null,"stk",1,1,1,1]
[null,null,"Antal kvadratmeter",null,null,null,null,"m2/rum",1,1,1,1]
[null,null,"BELYSNINGSFÖRSLAG (anges av anbudsgivaren)"]
[null,null,"ARMATURTYP 1"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I34=$I$232,I35,IF(I34=$I$233,I35*I36,IF(I34=$I$234,I35*I36*I37,1)))","v":1},1,1,{"$f":"IF(L34=$I$232,L35,IF(L34=$I$233,L35*L36,IF(L34=$I$234,L35*L36*L37,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 2"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I46=$I$232,I47,IF(I46=$I$233,I47*I48,IF(I46=$I$234,I47*I48*I49,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 3"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I58=$I$232,I59,IF(I58=$I$233,I59*I60,IF(I58=$I$234,I59*I60*I61,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 4"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I70=$I$232,I71,IF(I70=$I$233,I71*I72,IF(I70=$I$234,I71*I72*I73,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 5"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I82=$I$232,I83,IF(I82=$I$233,I83*I84,IF(I82=$I$234,I83*I84*I85,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader ",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 6"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I94=$I$232,I95,IF(I94=$I$233,I95*I96,IF(I94=$I$234,I95*I96*I97,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 7"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I106=$I$232,I107,IF(I106=$I$233,I107*I108,IF(I106=$I$234,I107*I108*I109,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 8"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I118=$I$232,I119,IF(I118=$I$233,I119*I120,IF(I118=$I$234,I119*I120*I121,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 9"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I130=$I$232,I131,IF(I130=$I$233,I131*I132,IF(I130=$I$234,I131*I132*I133,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 10"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I142=$I$232,I143,IF(I142=$I$233,I143*I144,IF(I142=$I$234,I143*I144*I145,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"STYRUTRUSTNING"]
[null,"3.1","Kostnad extern styrutrustning",null,null,null,null,"kr/år"]
[]
[null,null,"Resultat"]
[null,null,null,null,null,null,null,null,{"$f":"I25","v":"Typrum1"},{"$f":"J25","v":"Typrum2"},{"$f":"K25","v":"Typrum3"},{"$f":"L25","v":"Typrum4"}]
[null,"4.1","Totalkostnad per rumstyp",null,null,null,null,"kr",{"$f":"I210*$I$212+I175+I194*$I$196","v":0},{"$f":"J210*$I$212+J175+J194*$I$196","v":0},{"$f":"K210*$I$212+K175+K194*$I$196","v":0},{"$f":"L210*$I$212+L175+L194*$I$196","v":0}]
[null,"4.2","LENI-tal per rumstyp",null,null,null,null,"kWh/m2/år",{"$f":"I216","v":0},{"$f":"J216","v":0},{"$f":"K216","v":0},0]
[null,null,"RESULTAT FÖR HELA ANLÄGGNINGEN"]
[null,"4.3","TOTAL KOSTNAD",null,null,null,null,"kr",{"$f":"SUM(I197,I176,I213)","v":0}]
[null,"4.4","Energikostnad per år ",null,null,null,null,"kr",{"$f":"I195","v":0}]
[null,"4.5","Energikostnader under hela livslängden",null,null,null,null,"kr",{"$f":"I197","v":0}]
[null,"4.6","Klimatpåverkan",null,null,null,null,"kgCO2/år",{"$f":"SUM(I215:XFD215)","v":0}]
[]
[null,null,"LCC-kalkyl"]
[null,null,null,null,null,null,null,null,{"$f":"I153","v":"Typrum1"},{"$f":"J153","v":"Typrum2"},"Typrum3","Typrum4"]
[null,null,"INVESTERINGSKOSTNADER"]
[null,null,"Armatur 1",null,null,null,null,"kr",{"$f":"I26*(I30*(I31+I32))","v":0},{"$f":"J26*(J30*(J31+J32))","v":0},{"$f":"K26*(K30*(K31+K32))","v":0},{"$f":"L26*(L30*(L31+L32))","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kr",{"$f":"I26*(I42*(I43+I44))","v":0},{"$f":"J26*(J42*(J43+J44))","v":0},{"$f":"K26*(K42*(K43+K44))","v":0},{"$f":"L26*(L42*(L43+L44))","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kr",{"$f":"I26*(I54*(I55+I56))","v":0},{"$f":"J26*(J54*(J55+J56))","v":0},{"$f":"K26*(K54*(K55+K56))","v":0},{"$f":"L26*(L54*(L55+L56))","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kr",{"$f":"I26*(I66*(I67+I68))","v":0},{"$f":"J26*(J66*(J67+J68))","v":0},{"$f":"K26*(K66*(K67+K68))","v":0},{"$f":"L26*(L66*(L67+L68))","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kr",{"$f":"I26*(I78*(I79+I80))","v":0},{"$f":"J26*(J78*(J79+J80))","v":0},{"$f":"K26*(K78*(K79+K80))","v":0},{"$f":"L26*(L78*(L79+L80))","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kr",{"$f":"I26*(I90*(I91+I92))","v":0},{"$f":"J26*(J90*(J91+J92))","v":0},{"$f":"K26*(K90*(K91+K92))","v":0},{"$f":"L26*(L90*(L91+L92))","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kr",{"$f":"I26*(I102*(I103+I104))","v":0},{"$f":"J26*(J102*(J103+J104))","v":0},{"$f":"K26*(K102*(K103+K104))","v":0},{"$f":"L26*(L102*(L103+L104))","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kr",{"$f":"I26*(I114*(I115+I116))","v":0},{"$f":"J26*(J114*(J115+J116))","v":0},{"$f":"K26*(K114*(K115+K116))","v":0},{"$f":"L26*(L114*(L115+L116))","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kr",{"$f":"I26*(I126*(I127+I128))","v":0},{"$f":"J26*(J126*(J127+J128))","v":0},{"$f":"K26*(K126*(K127+K128))","v":0},{"$f":"L26*(L126*(L127+L128))","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kr",{"$f":"I26*(I138*(I139+I140))","v":0},{"$f":"J26*(J138*(J139+J140))","v":0},{"$f":"K26*(K138*(K139+K140))","v":0},{"$f":"L26*(L138*(L139+L140))","v":0}]
[null,null,"Summa investeringskostnader per rumstyp",null,null,null,null,"kr",{"$f":"SUM(I165:I174)+I150","v":0},{"$f":"SUM(J165:J174)+J150","v":0},{"$f":"SUM(K165:K174)+K150","v":0},{"$f":"SUM(L165:L174)+L150","v":0}]
[null,null,"S:A investeringskostnader hela anläggningen",null,null,null,null,"kr",{"$f":"SUM(I175:XFD175)","v":0}]
[]
[null,null,"ENERGI- & UNDERHÅLLSKOSTNADER"]
[null,null,"ENERGIKOSTNADER"]
[null,null,"Energianvändning "]
[null,null,"Armatur 1",null,null,null,null,"kWh",{"$f":"(I$26*I30*I33*I38*$H$20)/1000","v":0},{"$f":"(J$26*J30*J33*J38*$H$20)/1000","v":0},{"$f":"(K$26*K30*K33*K38*$H$20)/1000","v":0},{"$f":"(L$26*L30*L33*L38*$H$20)/1000","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kWh",{"$f":"(I$26*I42*I45*I50*$H$20)/1000","v":0},{"$f":"(J$26*J42*J45*J50*$H$20)/1000","v":0},{"$f":"(K$26*K42*K45*K50*$H$20)/1000","v":0},{"$f":"(L$26*L42*L45*L50*$H$20)/1000","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kWh",{"$f":"(I$26*I54*I57*I62*$H$20)/1000","v":0},{"$f":"(J$26*J54*J57*J62*$H$20)/1000","v":0},{"$f":"(K$26*K54*K57*K62*$H$20)/1000","v":0},{"$f":"(L$26*L54*L57*L62*$H$20)/1000","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kWh",{"$f":"(I$26*I66*I69*I74*$H$20)/1000","v":0},{"$f":"(J$26*J66*J69*J74*$H$20)/1000","v":0},{"$f":"(K$26*K66*K69*K74*$H$20)/1000","v":0},{"$f":"(L$26*L66*L69*L74*$H$20)/1000","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kWh",{"$f":"(I$26*I78*I81*I86*$H$20)/1000","v":0},{"$f":"(J$26*J78*J81*J86*$H$20)/1000","v":0},{"$f":"(K$26*K78*K81*K86*$H$20)/1000","v":0},{"$f":"(L$26*L78*L81*L86*$H$20)/1000","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kWh",{"$f":"(I$26*I90*I93*I98*$H$20)/1000","v":0},{"$f":"(J$26*J90*J93*J98*$H$20)/1000","v":0},{"$f":"(K$26*K90*K93*K98*$H$20)/1000","v":0},{"$f":"(L$26*L90*L93*L98*$H$20)/1000","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kWh",{"$f":"(I$26*I102*I105*I110*$H$20)/1000","v":0},{"$f":"(J$26*J102*J105*J110*$H$20)/1000","v":0},{"$f":"(K$26*K102*K105*K110*$H$20)/1000","v":0},{"$f":"(L$26*L102*L105*L110*$H$20)/1000","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kWh",{"$f":"(I$26*I114*I117*I122*$H$20)/1000","v":0},{"$f":"(J$26*J114*J117*J122*$H$20)/1000","v":0},{"$f":"(K$26*K114*K117*K122*$H$20)/1000","v":0},{"$f":"(L$26*L114*L117*L122*$H$20)/1000","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kWh",{"$f":"(I$26*I126*I129*I134*$H$20)/1000","v":0},{"$f":"(J$26*J126*J129*J134*$H$20)/1000","v":0},{"$f":"(K$26*K126*K129*K134*$H$20)/1000","v":0},{"$f":"(L$26*L126*L129*L134*$H$20)/1000","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kWh",{"$f":"(I$26*I138*I141*I146*$H$20)/1000","v":0},{"$f":"(J$26*J138*J141*J146*$H$20)/1000","v":0},{"$f":"(K$26*K138*K141*K146*$H$20)/1000","v":0},{"$f":"(L$26*L138*L141*L146*$H$20)/1000","v":0}]
[null,null,"Summa energianvändning per rumstyp",null,null,null,null,"kWh/år",{"$f":"SUM(I181:I190)","v":0},{"$f":"SUM(J181:J190)","v":0},0,0]
[null,null,"Summa energianvändning hela anläggningen",null,null,null,null,"kWh/år",{"$f":"SUM(I191:XFD191)","v":0}]
[]
[null,null,"Årlig energikostnad per rumstyp",null,null,null,null,null,{"$f":"$H$17*I191","v":0},{"$f":"$H$17*J191","v":0},0,0]
[null,null,"Årlig energikostnad hela anläggningen",null,null,null,null,null,{"$f":"I192*H17","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"IF($H$16=$H$18,$H$15,(1/($H$16-$H$18))*(1-((1+$H$18)/(1+$H$16))^$H$15))","v":0}]
[null,null,"Energikostnader under hela livslängden",null,null,null,null,null,{"$f":"I195*I196","v":0}]
[]
[null,null,"UNDERHÅLLSKOSTNADER"]
[null,null,"Underhållskostnader armaturtyp 1 ",null,null,null,null,"kr/år",{"$f":"I39","v":0},{"$f":"J39","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 2",null,null,null,null,"kr/år",{"$f":"I51","v":0},{"$f":"J51","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 3",null,null,null,null,"kr/år",{"$f":"I63","v":0},{"$f":"J63","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 4",null,null,null,null,"kr/år",{"$f":"I75","v":0},{"$f":"J75","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 5",null,null,null,null,"kr/år",{"$f":"I87","v":0},{"$f":"J87","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 6",null,null,null,null,"kr/år",{"$f":"I99","v":0},{"$f":"J99","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 7",null,null,null,null,"kr/år",{"$f":"I111","v":0},{"$f":"J111","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 8",null,null,null,null,"kr/år",{"$f":"I123","v":0},{"$f":"J123","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 9",null,null,null,null,"kr/år",{"$f":"I135","v":0},{"$f":"J135","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 10",null,null,null,null,"kr/år",{"$f":"I147","v":0},{"$f":"J147","v":0},0,0]
[null,null,"Summa underhålllskostnader per rumstyp",null,null,null,null,"kr/år",{"$f":"SUM(I200:I209)","v":0},{"$f":"SUM(J200:J209)","v":0},{"$f":"SUM(K200:K209)","v":0},{"$f":"SUM(L200:L209)","v":0}]
[null,null,"Underhållskostnader hela anläggningen",null,null,null,null,null,{"$f":"SUM(I210:XFD210)","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"(1/$H$16)*(1-(1/(1+$H$16))^$H$15)","v":0}]
[null,null,"Underhållskostnader under hela livslängden",null,null,null,null,null,{"$f":"I211*I212","v":0}]
[]
[null,null,"Klimatpåverkan för varje rumstyp",null,null,null,null,null,{"$f":"SUM(I181:I190)*$H$19","v":0},{"$f":"SUM(J181:J190)*$H$19","v":0},0,0]
[null,null,"LENI-tal per rumstyp",null,null,null,null,"kWh/m2, år",{"$f":"SUM(I217:I226)","v":0},{"$f":"SUM(J217:J226)","v":0},{"$f":"SUM(K217:K226)","v":0},{"$f":"SUM(L217:L226)","v":0}]
[null,null,"LENI-tal armaturtyp 1",null,null,null,null,"kWh/m2, år",{"$f":"(I30*I33*$H$20*I38/1000)/I27","v":0},{"$f":"(J30*J33*$H$20*J38/1000)/J27","v":0},{"$f":"(K30*K33*$H$20*K38/1000)/K27","v":0},{"$f":"(L30*L33*$H$20*L38/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 2",null,null,null,null,"kWh/m2, år",{"$f":"(I42*I45*$H$20*I50/1000)/I27","v":0},{"$f":"(J42*J45*$H$20*J50/1000)/J27","v":0},{"$f":"(K42*K45*$H$20*K50/1000)/K27","v":0},{"$f":"(L42*L45*$H$20*L50/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 3",null,null,null,null,"kWh/m2, år",{"$f":"(I54*I57*$H$20*I62/1000)/I27","v":0},{"$f":"(J54*J57*$H$20*J62/1000)/J27","v":0},{"$f":"(K54*K57*$H$20*K62/1000)/K27","v":0},{"$f":"(L54*L57*$H$20*L62/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 4",null,null,null,null,"kWh/m2, år",{"$f":"(I66*I69*$H$20*I74/1000)/I27","v":0},{"$f":"(J66*J69*$H$20*J74/1000)/J27","v":0},{"$f":"(K66*K69*$H$20*K74/1000)/K27","v":0},{"$f":"(L66*L69*$H$20*L74/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 5",null,null,null,null,"kWh/m2, år",{"$f":"(I78*I81*$H$20*I86/1000)/I27","v":0},{"$f":"(J78*J81*$H$20*J86/1000)/J27","v":0},{"$f":"(K78*K81*$H$20*K86/1000)/K27","v":0},{"$f":"(L78*L81*$H$20*L86/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 6",null,null,null,null,"kWh/m2, år",{"$f":"(I90*I93*$H$20*I98/1000)/I27","v":0},{"$f":"(J90*J93*$H$20*J98/1000)/J27","v":0},{"$f":"(K90*K93*$H$20*K98/1000)/K27","v":0},{"$f":"(L90*L93*$H$20*L98/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 7",null,null,null,null,"kWh/m2, år",{"$f":"(I102*I105*$H$20*I110/1000)/I27","v":0},{"$f":"(J102*J105*$H$20*J110/1000)/J27","v":0},{"$f":"(K102*K105*$H$20*K110/1000)/K27","v":0},{"$f":"(L102*L105*$H$20*L110/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 8",null,null,null,null,"kWh/m2, år",{"$f":"(I114*I117*$H$20*I120/1000)/I27","v":0},{"$f":"(J114*J117*$H$20*J120/1000)/J27","v":0},{"$f":"(K114*K117*$H$20*K120/1000)/K27","v":0},{"$f":"(L114*L117*$H$20*L120/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 9",null,null,null,null,"kWh/m2, år",{"$f":"(I126*I129*$H$20*I134/1000)/I27","v":0},{"$f":"(J126*J129*$H$20*J134/1000)/J27","v":0},{"$f":"(K126*K129*$H$20*K134/1000)/K27","v":0},{"$f":"(L126*L129*$H$20*L134/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 10",null,null,null,null,"kWh/m2, år",{"$f":"(I138*I141*$H$20*I146/1000)/I27","v":0},{"$f":"(J138*J141*$H$20*J146/1000)/J27","v":0},{"$f":"(K138*K141*$H$20*K146/1000)/K27","v":0},{"$f":"(L138*L141*$H$20*L146/1000)/L27","v":0}]
[]
[null,null,"S:A ENERGI- & UNDERHÅLLSKOSTNADER",null,null,null,null,"kr",{"$f":"I213+I197","v":0}]
[null,null,"TOTALKOSTNAD HELA ANLÄGGNINGEN",null,null,null,null,"kr",{"$f":"I228+I176","v":0}]
[]
[null,null,null,null,null,null,null,null,"Ingen"]
[null,null,null,null,null,null,null,null,"Manuell"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro + Dagsljus"]

{"sheet":"2. LCC A4","index":5,"n_rows":234,"n_cols":12,"rows_kept":234,"cut":false,"hidden":false,"merged":[[225,2,225,4],[219,2,219,4],[220,2,220,4],[221,2,221,4],[222,2,222,4],[223,2,223,4],[224,2,224,4],[218,2,218,4],[152,2,152,6],[153,2,153,6],[154,2,154,4],[156,2,156,6],[157,2,157,6],[158,2,158,6],[159,2,159,6],[160,2,160,6],[177,2,177,6],[216,2,216,4],[217,2,217,4],[151,2,151,3],[98,2,98,6],[103,2,103,6],[110,2,110,6],[115,2,115,6],[122,2,122,6],[127,2,127,6],[134,2,134,6],[139,2,139,6],[146,2,146,6],[148,2,148,6],[149,2,149,6],[91,2,91,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[43,2,43,6],[50,2,50,6],[55,2,55,6],[62,2,62,6],[67,2,67,6],[74,2,74,6],[79,2,79,6],[86,2,86,6],[34,2,34,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[17,2,17,6],[5,2,5,3],[5,4,5,6],[5,7,5,8],[10,2,10,4],[10,5,10,8],[11,2,11,4],[11,5,11,8],[12,2,12,4],[12,5,12,8],[14,2,14,6],[15,2,15,6],[16,2,16,6]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[null,null,"LCC-kalkyl Anläggning alternativ 4"]
[]
[null,null,"Kalkylförutsättningar (anges av beställaren)"]
[null,null,"PROJEKT:",null,null,"Projektnamn"]
[null,null,"DATUM:",null,null,"2016-01-01"]
[null,null,"HANDLÄGGARE:",null,null,"NAMN"]
[]
[null,"1.1","Tid kalkylen omfattar",null,null,null,null,null,"år"]
[null,"1.2","Kalkylränta",null,null,null,null,1.7500000000000002E-2]
[null,"1.3","Elpris",null,null,null,null,null,"kr/kWh"]
[null,"1.4","Årlig energiprisökning (frivillig)"]
[null,"1.5","Klimatpåverkan elanvändning (frivillig)",null,null,null,null,null,"kgCO2/kWh"]
[null,"1.6","Drifttid",null,null,null,null,null,"h/år"]
[]
[null,null,"Beskrivning av anläggningen och belysningsförslag"]
[]
[null,null,"BESKRIVNING AV ANLÄGGNINGEN (anges av beställaren)"]
[null,null,"Rumstyp",null,null,null,null,null,"Rumstyp 1","Rumstyp 2","Rumstyp 3","Rumstyp 4"]
[null,null,"Antal rum av samma typ",null,null,null,null,"stk",1,1,1,1]
[null,null,"Antal kvadratmeter",null,null,null,null,"m2/rum",1,1,1,1]
[null,null,"BELYSNINGSFÖRSLAG (anges av anbudsgivaren)"]
[null,null,"ARMATURTYP 1"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I34=$I$232,I35,IF(I34=$I$233,I35*I36,IF(I34=$I$234,I35*I36*I37,1)))","v":1},1,1,{"$f":"IF(L34=$I$232,L35,IF(L34=$I$233,L35*L36,IF(L34=$I$234,L35*L36*L37,1)))","v":1}]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 2"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Reduktionsfaktor manuell styrning "]
[null,"2.7","Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,"2.8","Reduktionsfaktor dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I46=$I$232,I47,IF(I46=$I$233,I47*I48,IF(I46=$I$234,I47*I48*I49,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 3"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I58=$I$232,I59,IF(I58=$I$233,I59*I60,IF(I58=$I$234,I59*I60*I61,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 4"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I70=$I$232,I71,IF(I70=$I$233,I71*I72,IF(I70=$I$234,I71*I72*I73,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 5"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I82=$I$232,I83,IF(I82=$I$233,I83*I84,IF(I82=$I$234,I83*I84*I85,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader ",null,null,null,null,"kr/år"]
[]
[null,null,"ARMATURTYP 6"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I94=$I$232,I95,IF(I94=$I$233,I95*I96,IF(I94=$I$234,I95*I96*I97,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 7"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I106=$I$232,I107,IF(I106=$I$233,I107*I108,IF(I106=$I$234,I107*I108*I109,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 8"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I118=$I$232,I119,IF(I118=$I$233,I119*I120,IF(I118=$I$234,I119*I120*I121,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 9"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I130=$I$232,I131,IF(I130=$I$233,I131*I132,IF(I130=$I$234,I131*I132*I133,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"ARMATURTYP 10"]
[null,"2.1","Antal armaturer ",null,null,null,null,"stk"]
[null,"2.2","Armaturpris",null,null,null,null,"kr/stk"]
[null,"2.3","Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,"2.4","Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,"2.5","Typ av styrning (Välj)",null,null,null,null,null,"Ingen","Ingen","Ingen","Ingen"]
[null,"2.6","Manuell styrning "]
[null,"2.7","Närvaro-/frånvarostyrning "]
[null,"2.8","Dagsljusstyrning"]
[null,"2.9","Total reduktionsfaktor för styrning",null,null,null,null,null,{"$f":"IF(I142=$I$232,I143,IF(I142=$I$233,I143*I144,IF(I142=$I$234,I143*I144*I145,1)))","v":1},1,1,1]
[null,"2.10","Underhållskostnader",null,null,null,null,"kr/stk"]
[]
[null,null,"STYRUTRUSTNING"]
[null,"3.1","Kostnad extern styrutrustning",null,null,null,null,"kr/år"]
[]
[null,null,"Resultat"]
[null,null,null,null,null,null,null,null,{"$f":"I25","v":"Rumstyp 1"},{"$f":"J25","v":"Rumstyp 2"},{"$f":"K25","v":"Rumstyp 3"},{"$f":"L25","v":"Rumstyp 4"}]
[null,"4.1","Totalkostnad per rumstyp",null,null,null,null,"kr",{"$f":"I210*$I$212+I175+I194*$I$196","v":0},{"$f":"J210*$I$212+J175+J194*$I$196","v":0},{"$f":"K210*$I$212+K175+K194*$I$196","v":0},{"$f":"L210*$I$212+L175+L194*$I$196","v":0}]
[null,"4.2","LENI-tal per rumstyp",null,null,null,null,"kWh/m2/år",{"$f":"I216","v":0},{"$f":"J216","v":0},{"$f":"K216","v":0},0]
[null,null,"RESULTAT FÖR HELA ANLÄGGNINGEN"]
[null,"4.3","TOTAL KOSTNAD",null,null,null,null,"kr",{"$f":"SUM(I197,I176,I213)","v":0}]
[null,"4.4","Energikostnad per år ",null,null,null,null,"kr",{"$f":"I195","v":0}]
[null,"4.5","Energikostnader under hela livslängden",null,null,null,null,"kr",{"$f":"I197","v":0}]
[null,"4.6","Klimatpåverkan",null,null,null,null,"kgCO2/år",{"$f":"SUM(I215:XFD215)","v":0}]
[]
[null,null,"LCC-kalkyl"]
[null,null,null,null,null,null,null,null,{"$f":"I153","v":"Rumstyp 1"},{"$f":"J153","v":"Rumstyp 2"},"Rumstyp 3","Rumstyp 4"]
[null,null,"INVESTERINGSKOSTNADER"]
[null,null,"Armatur 1",null,null,null,null,"kr",{"$f":"I26*(I30*(I31+I32))","v":0},{"$f":"J26*(J30*(J31+J32))","v":0},{"$f":"K26*(K30*(K31+K32))","v":0},{"$f":"L26*(L30*(L31+L32))","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kr",{"$f":"I26*(I42*(I43+I44))","v":0},{"$f":"J26*(J42*(J43+J44))","v":0},{"$f":"K26*(K42*(K43+K44))","v":0},{"$f":"L26*(L42*(L43+L44))","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kr",{"$f":"I26*(I54*(I55+I56))","v":0},{"$f":"J26*(J54*(J55+J56))","v":0},{"$f":"K26*(K54*(K55+K56))","v":0},{"$f":"L26*(L54*(L55+L56))","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kr",{"$f":"I26*(I66*(I67+I68))","v":0},{"$f":"J26*(J66*(J67+J68))","v":0},{"$f":"K26*(K66*(K67+K68))","v":0},{"$f":"L26*(L66*(L67+L68))","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kr",{"$f":"I26*(I78*(I79+I80))","v":0},{"$f":"J26*(J78*(J79+J80))","v":0},{"$f":"K26*(K78*(K79+K80))","v":0},{"$f":"L26*(L78*(L79+L80))","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kr",{"$f":"I26*(I90*(I91+I92))","v":0},{"$f":"J26*(J90*(J91+J92))","v":0},{"$f":"K26*(K90*(K91+K92))","v":0},{"$f":"L26*(L90*(L91+L92))","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kr",{"$f":"I26*(I102*(I103+I104))","v":0},{"$f":"J26*(J102*(J103+J104))","v":0},{"$f":"K26*(K102*(K103+K104))","v":0},{"$f":"L26*(L102*(L103+L104))","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kr",{"$f":"I26*(I114*(I115+I116))","v":0},{"$f":"J26*(J114*(J115+J116))","v":0},{"$f":"K26*(K114*(K115+K116))","v":0},{"$f":"L26*(L114*(L115+L116))","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kr",{"$f":"I26*(I126*(I127+I128))","v":0},{"$f":"J26*(J126*(J127+J128))","v":0},{"$f":"K26*(K126*(K127+K128))","v":0},{"$f":"L26*(L126*(L127+L128))","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kr",{"$f":"I26*(I138*(I139+I140))","v":0},{"$f":"J26*(J138*(J139+J140))","v":0},{"$f":"K26*(K138*(K139+K140))","v":0},{"$f":"L26*(L138*(L139+L140))","v":0}]
[null,null,"Summa investeringskostnader per rumstyp",null,null,null,null,"kr",{"$f":"SUM(I165:I174)+I150","v":0},{"$f":"SUM(J165:J174)+J150","v":0},{"$f":"SUM(K165:K174)+K150","v":0},{"$f":"SUM(L165:L174)+L150","v":0}]
[null,null,"S:A investeringskostnader hela anläggningen",null,null,null,null,"kr",{"$f":"SUM(I175:XFD175)","v":0}]
[]
[null,null,"ENERGI- & UNDERHÅLLSKOSTNADER"]
[null,null,"ENERGIKOSTNADER"]
[null,null,"Energianvändning "]
[null,null,"Armatur 1",null,null,null,null,"kWh",{"$f":"(I$26*I30*I33*I38*$H$20)/1000","v":0},{"$f":"(J$26*J30*J33*J38*$H$20)/1000","v":0},{"$f":"(K$26*K30*K33*K38*$H$20)/1000","v":0},{"$f":"(L$26*L30*L33*L38*$H$20)/1000","v":0}]
[null,null,"Armatur 2",null,null,null,null,"kWh",{"$f":"(I$26*I42*I45*I50*$H$20)/1000","v":0},{"$f":"(J$26*J42*J45*J50*$H$20)/1000","v":0},{"$f":"(K$26*K42*K45*K50*$H$20)/1000","v":0},{"$f":"(L$26*L42*L45*L50*$H$20)/1000","v":0}]
[null,null,"Armatur 3",null,null,null,null,"kWh",{"$f":"(I$26*I54*I57*I62*$H$20)/1000","v":0},{"$f":"(J$26*J54*J57*J62*$H$20)/1000","v":0},{"$f":"(K$26*K54*K57*K62*$H$20)/1000","v":0},{"$f":"(L$26*L54*L57*L62*$H$20)/1000","v":0}]
[null,null,"Armatur 4",null,null,null,null,"kWh",{"$f":"(I$26*I66*I69*I74*$H$20)/1000","v":0},{"$f":"(J$26*J66*J69*J74*$H$20)/1000","v":0},{"$f":"(K$26*K66*K69*K74*$H$20)/1000","v":0},{"$f":"(L$26*L66*L69*L74*$H$20)/1000","v":0}]
[null,null,"Armatur 5",null,null,null,null,"kWh",{"$f":"(I$26*I78*I81*I86*$H$20)/1000","v":0},{"$f":"(J$26*J78*J81*J86*$H$20)/1000","v":0},{"$f":"(K$26*K78*K81*K86*$H$20)/1000","v":0},{"$f":"(L$26*L78*L81*L86*$H$20)/1000","v":0}]
[null,null,"Armatur 6",null,null,null,null,"kWh",{"$f":"(I$26*I90*I93*I98*$H$20)/1000","v":0},{"$f":"(J$26*J90*J93*J98*$H$20)/1000","v":0},{"$f":"(K$26*K90*K93*K98*$H$20)/1000","v":0},{"$f":"(L$26*L90*L93*L98*$H$20)/1000","v":0}]
[null,null,"Armatur 7",null,null,null,null,"kWh",{"$f":"(I$26*I102*I105*I110*$H$20)/1000","v":0},{"$f":"(J$26*J102*J105*J110*$H$20)/1000","v":0},{"$f":"(K$26*K102*K105*K110*$H$20)/1000","v":0},{"$f":"(L$26*L102*L105*L110*$H$20)/1000","v":0}]
[null,null,"Armatur 8",null,null,null,null,"kWh",{"$f":"(I$26*I114*I117*I122*$H$20)/1000","v":0},{"$f":"(J$26*J114*J117*J122*$H$20)/1000","v":0},{"$f":"(K$26*K114*K117*K122*$H$20)/1000","v":0},{"$f":"(L$26*L114*L117*L122*$H$20)/1000","v":0}]
[null,null,"Armatur 9",null,null,null,null,"kWh",{"$f":"(I$26*I126*I129*I134*$H$20)/1000","v":0},{"$f":"(J$26*J126*J129*J134*$H$20)/1000","v":0},{"$f":"(K$26*K126*K129*K134*$H$20)/1000","v":0},{"$f":"(L$26*L126*L129*L134*$H$20)/1000","v":0}]
[null,null,"Armatur 10",null,null,null,null,"kWh",{"$f":"(I$26*I138*I141*I146*$H$20)/1000","v":0},{"$f":"(J$26*J138*J141*J146*$H$20)/1000","v":0},{"$f":"(K$26*K138*K141*K146*$H$20)/1000","v":0},{"$f":"(L$26*L138*L141*L146*$H$20)/1000","v":0}]
[null,null,"Summa energianvändning per rumstyp",null,null,null,null,"kWh/år",{"$f":"SUM(I181:I190)","v":0},{"$f":"SUM(J181:J190)","v":0},0,0]
[null,null,"Summa energianvändning hela anläggningen",null,null,null,null,"kWh/år",{"$f":"SUM(I191:XFD191)","v":0}]
[]
[null,null,"Årlig energikostnad per rumstyp",null,null,null,null,null,{"$f":"$H$17*I191","v":0},{"$f":"$H$17*J191","v":0},0,0]
[null,null,"Årlig energikostnad hela anläggningen",null,null,null,null,null,{"$f":"I192*H17","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"IF($H$16=$H$18,$H$15,(1/($H$16-$H$18))*(1-((1+$H$18)/(1+$H$16))^$H$15))","v":0}]
[null,null,"Energikostnader under hela livslängden",null,null,null,null,null,{"$f":"I195*I196","v":0}]
[]
[null,null,"UNDERHÅLLSKOSTNADER"]
[null,null,"Underhållskostnader armaturtyp 1 ",null,null,null,null,"kr/år",{"$f":"I39","v":0},{"$f":"J39","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 2",null,null,null,null,"kr/år",{"$f":"I51","v":0},{"$f":"J51","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 3",null,null,null,null,"kr/år",{"$f":"I63","v":0},{"$f":"J63","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 4",null,null,null,null,"kr/år",{"$f":"I75","v":0},{"$f":"J75","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 5",null,null,null,null,"kr/år",{"$f":"I87","v":0},{"$f":"J87","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 6",null,null,null,null,"kr/år",{"$f":"I99","v":0},{"$f":"J99","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 7",null,null,null,null,"kr/år",{"$f":"I111","v":0},{"$f":"J111","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 8",null,null,null,null,"kr/år",{"$f":"I123","v":0},{"$f":"J123","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 9",null,null,null,null,"kr/år",{"$f":"I135","v":0},{"$f":"J135","v":0},0,0]
[null,null,"Underhållskostnader armaturtyp 10",null,null,null,null,"kr/år",{"$f":"I147","v":0},{"$f":"J147","v":0},0,0]
[null,null,"Summa underhålllskostnader per rumstyp",null,null,null,null,"kr/år",{"$f":"SUM(I200:I209)","v":0},{"$f":"SUM(J200:J209)","v":0},{"$f":"SUM(K200:K209)","v":0},{"$f":"SUM(L200:L209)","v":0}]
[null,null,"Underhållskostnader hela anläggningen",null,null,null,null,null,{"$f":"SUM(I210:XFD210)","v":0}]
[null,null,"Omräkningsfaktor till nuvärde",null,null,null,null,null,{"$f":"(1/$H$16)*(1-(1/(1+$H$16))^$H$15)","v":0}]
[null,null,"Underhållskostnader under hela livslängden",null,null,null,null,null,{"$f":"I211*I212","v":0}]
[]
[null,null,"Klimatpåverkan för varje rumstyp",null,null,null,null,null,{"$f":"SUM(I181:I190)*$H$19","v":0},{"$f":"SUM(J181:J190)*$H$19","v":0},0,0]
[null,null,"LENI-tal per rumstyp",null,null,null,null,"kWh/m2, år",{"$f":"SUM(I217:I226)","v":0},{"$f":"SUM(J217:J226)","v":0},{"$f":"SUM(K217:K226)","v":0},{"$f":"SUM(L217:L226)","v":0}]
[null,null,"LENI-tal armaturtyp 1",null,null,null,null,"kWh/m2, år",{"$f":"(I30*I33*$H$20*I38/1000)/I27","v":0},{"$f":"(J30*J33*$H$20*J38/1000)/J27","v":0},{"$f":"(K30*K33*$H$20*K38/1000)/K27","v":0},{"$f":"(L30*L33*$H$20*L38/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 2",null,null,null,null,"kWh/m2, år",{"$f":"(I42*I45*$H$20*I50/1000)/I27","v":0},{"$f":"(J42*J45*$H$20*J50/1000)/J27","v":0},{"$f":"(K42*K45*$H$20*K50/1000)/K27","v":0},{"$f":"(L42*L45*$H$20*L50/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 3",null,null,null,null,"kWh/m2, år",{"$f":"(I54*I57*$H$20*I62/1000)/I27","v":0},{"$f":"(J54*J57*$H$20*J62/1000)/J27","v":0},{"$f":"(K54*K57*$H$20*K62/1000)/K27","v":0},{"$f":"(L54*L57*$H$20*L62/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 4",null,null,null,null,"kWh/m2, år",{"$f":"(I66*I69*$H$20*I74/1000)/I27","v":0},{"$f":"(J66*J69*$H$20*J74/1000)/J27","v":0},{"$f":"(K66*K69*$H$20*K74/1000)/K27","v":0},{"$f":"(L66*L69*$H$20*L74/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 5",null,null,null,null,"kWh/m2, år",{"$f":"(I78*I81*$H$20*I86/1000)/I27","v":0},{"$f":"(J78*J81*$H$20*J86/1000)/J27","v":0},{"$f":"(K78*K81*$H$20*K86/1000)/K27","v":0},{"$f":"(L78*L81*$H$20*L86/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 6",null,null,null,null,"kWh/m2, år",{"$f":"(I90*I93*$H$20*I98/1000)/I27","v":0},{"$f":"(J90*J93*$H$20*J98/1000)/J27","v":0},{"$f":"(K90*K93*$H$20*K98/1000)/K27","v":0},{"$f":"(L90*L93*$H$20*L98/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 7",null,null,null,null,"kWh/m2, år",{"$f":"(I102*I105*$H$20*I110/1000)/I27","v":0},{"$f":"(J102*J105*$H$20*J110/1000)/J27","v":0},{"$f":"(K102*K105*$H$20*K110/1000)/K27","v":0},{"$f":"(L102*L105*$H$20*L110/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 8",null,null,null,null,"kWh/m2, år",{"$f":"(I114*I117*$H$20*I120/1000)/I27","v":0},{"$f":"(J114*J117*$H$20*J120/1000)/J27","v":0},{"$f":"(K114*K117*$H$20*K120/1000)/K27","v":0},{"$f":"(L114*L117*$H$20*L120/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 9",null,null,null,null,"kWh/m2, år",{"$f":"(I126*I129*$H$20*I134/1000)/I27","v":0},{"$f":"(J126*J129*$H$20*J134/1000)/J27","v":0},{"$f":"(K126*K129*$H$20*K134/1000)/K27","v":0},{"$f":"(L126*L129*$H$20*L134/1000)/L27","v":0}]
[null,null,"LENI-tal armaturtyp 10",null,null,null,null,"kWh/m2, år",{"$f":"(I138*I141*$H$20*I146/1000)/I27","v":0},{"$f":"(J138*J141*$H$20*J146/1000)/J27","v":0},{"$f":"(K138*K141*$H$20*K146/1000)/K27","v":0},{"$f":"(L138*L141*$H$20*L146/1000)/L27","v":0}]
[]
[null,null,"S:A ENERGI- & UNDERHÅLLSKOSTNADER",null,null,null,null,"kr",{"$f":"I213+I197","v":0}]
[null,null,"TOTALKOSTNAD HELA ANLÄGGNINGEN",null,null,null,null,"kr",{"$f":"I228+I176","v":0}]
[]
[null,null,null,null,null,null,null,null,"Ingen"]
[null,null,null,null,null,null,null,null,"Manuell"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro"]
[null,null,null,null,null,null,null,null,"Manuell + Närvaro/frånvaro + Dagsljus"]

{"sheet":"3. Kalkylparametrar","index":6,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,15,5,18],[16,8,16,10],[17,6,17,8],[22,8,22,10],[26,8,26,10],[24,8,24,10],[19,8,19,10],[18,8,18,10],[23,8,23,10],[25,8,25,10],[20,8,20,10],[5,3,5,5],[5,6,5,7],[12,8,12,10],[11,8,11,10],[33,8,33,10],[13,8,13,10],[14,8,14,10],[9,6,9,10],[15,8,15,10],[31,8,31,10],[29,8,29,10],[28,8,28,10],[27,8,27,10],[9,1,10,3],[21,6,21,8],[34,8,34,10],[35,8,35,10],[36,8,36,10],[37,8,37,10],[38,8,38,10]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[]
[null,"Kalkylparametrar"]
[null,"Samlade instruktioner kring kalkylparametrarna. ",null,null,null,null,"KALKYLFÖRUTSÄTTNINGAR (anges av beställaren)"]
[null,null,null,null,null,null,"Not ","Parameter","Instruktion"]
[null,null,null,null,null,null,"1.1","Tid kalkylen omfattar","Kalkylen bör utgå från den armatur med bäst teknisk livslängd. 20 år kan ses som ett referensvärde men det kan också vara längre."]
[null,null,null,null,null,null,"1.2","Kalkylränta","Kalkylränta (diskonteringsränta) ligger till grund för nuvärdesberäkning och räknar om framtida kostnader och intäkter till dagens värde. Kalkylräntan bör grunda sig på den kalkylränta som organisationen använder sig av vid investeringar, och den kan vara nominell eller real. Ofta används internräntan i LCC-kalkyler. SKL tar fram rekommendationer för internränta för kommuner och landsting. Internräntan föreslås för år 2018 att vara 1,75 procent. En hög ränta tillskriver drift- och underhållskostnader mindre betydelse i den totala kalkylen."]
[null,null,null,null,null,null,"1.3","Elpris","Organisationens avtalade elpris (kr/kWh) anges. Alternativt anges schablonpris på mellan 1,00- 1,50kr/kWh. "]
[null,null,null,null,null,null,"1.4","Årlig energiprisökning","Faktor för beräkning av energiprisökning utöver inflation."]
[null,null,null,null,null,null,"1.5","Klimatpåverkan elanvändning","För att kunna beräkna klimatpåverkan från elanvändningen anges här elleverantörens uppgifter om klimatpåverkan från sin elmix (koldioxidutsläpp per kilowattimme). Du kan också använda riktvärden från flik 5. "]
[null,null,null,null,null,null,"1.6","Drifttid","Här ska drifttid (timmar per år) för belysningen anges. Tiden ska i första hand vara baserad på befintlig driftdata. I andra hand kan man utgå från driftdata (schablonvärden) enligt standard SS-EN 15193: kontor 2500h/år, skolor 2000h/år, sporthallar 4000h/år, kök 2500h/år, sjukhus 5000h/år. Dessa värden finns även nämnda i \"Ljus & Rum\" kapitel 10."]
[null,null,null,null,null,null,"Beskrivning av anläggningen (anges av beställaren)"]
[null,null,null,null,null,null,null,"Rumstyper","Beskrivning av anläggningen med rumstyper och storlek på dessa måste göras i förfrågningsunderlaget. Ange rumstyp i första hand enligt benämningar i belysningsbranschens planeringsguide \"Ljus och Rum\" kap 10, eller som det benämns i förfrågningsunderlaget. Om flera typer och storlekar finns på t.ex. kontorsrum, benämns dessa cellkontor 1, cellkontor 2 osv."]
[null,null,null,null,null,null,null,"Antal rum av samma typ","Fyll i antal rum per rumstyp, dvs rum med samma funktion och storlek."]
[null,null,null,null,null,null,null,"Antal kvadratmeter","Rummets yta matas in för att kunna beräkna rumstypens LENI-tal. Utifrån detta kan sedan byggnadens LENI-tal enkelt beräknas om detta efterfrågas i upphandlingen."]
[null,null,null,null,null,null,"INDATA från anbudsgivaren"]
[null,null,null,null,null,null,"2.1","Antal armaturer ","Här ifylles antal armaturer som ingår i den föreslagna lösningen per rumstyp. Om fler typer av armaturer förekommer så ifylles dessa som armaturtyp 1, armaturtyp 2 osv. Fler rader kan läggas till vid behov genom att använda knapparna."]
[null,null,null,null,null,null,"2.2","Armaturpris","Här ska totala priset för armatur, ljuskälla, driftdon samt inbyggd styrutrustning anges (pris per styck). Om en armatur har fler än en ljuskälla ska dessa läggas ihop.  \n"]
[null,null,null,null,null,null,"2.3","Material- och arbetskostnader armatur","Här ingår material- och arbetskostnader för installationen, exklusive extern styrutrustning. Även kostnader för driftsättning ingår här (injustering och provning). Material kan exempelvis vara kablar. Arbetskostnader kan vara personal och maskinhyra. Om entreprenaden ingår i anbudet ska kostnaden för detta anges. Om entreprenad inte ingår får kostnaderna bli en uppskattning. Beräkning ska kunna uppvisas för den upphandlande organisationen."]
[null,null,null,null,null,null,"2.4","Effekt per armatur inkl driftsförluster","Effekt per armatur (W), driftsförluster inkluderade, fylls i här."]
[null,null,null,null,null,null,"2.5","Typ av styrning","Välj typ av styrning (ingen, manuell, närvaro/frånvarostyrning, dagsljusstyrning) och olika kombinationer av dessa."]
[null,null,null,null,null,null,"2.6- 2.8","Reduktionsfaktor manuell styrning, närvaro-/frånvarostyrning, dagsljusstyrning","En energireduktionsfaktor (reducering av drifttiden) läggs in om manuell/närvaro-frånvaro/ dagsljusstyrning har valts i rad 2.5. Välj aktuell reduktionsfaktorfaktor per rumstyp i flik 4. Tabellerna är hämtade från \"Ljus och Rum\" del 10. Om ingen styrning finns sätts samtliga rutor till 1,00. Om data inte finns för den aktuella rumstypen kan hänsyn till driftreducering inte tas i denna kalkyl och detta värde sätts till 1,00."]
[null,null,null,null,null,null,"2.9","Total reduktionsfaktor för styrning","Här visas den totala reduktionsfaktorn, d.v.s multiplicering av värdena från rad 2.6-2.8, som kommer användas vidare i beräkningarna.\n\n\n"]
[null,null,null,null,null,null,"2.10","Underhållskostnader","Kostnader för armaturens underhåll anges per armaturtyp och år och ska inkludera:\n- Kostnad för rengöring \n- Kostnad för tillsyn\n- Kostnad för ljuskällebyten\n- Kostnad för byte av driftdon \n- Kostnad för material- och installationskostnader vid byte av ljuskällor och driftdon.\nGrad av rengöring anges i förfrågningsunderlaget; detta beror på miljön som armaturen ska sitta i. Tillsyn sker i enlighet med driftsplanen. Antal byten av ljuskällor ska beräknas baserat på årlig drifttid och ljuskällans livslängd enligt gällande standarder. Livslängd för LED beräknas enligt IEC 62722-2-1 \"Särskilda krav för LED armaturer\". Driftdon beräknas ha samma livslängd som ljuskällan. "]
[null,null,null,null,null,null,"Styrutrustning"]
[null,null,null,null,null,null,"3.1","Kostnad extern styrutrustning","Styrutrustning ingår oftast som en del av armaturen, men det förekommer också separat. Här anges kostnaden för den utrustning som inte ingår i armaturpriset, som ligger utanför själva armaturen. Kostnaden anges när förutsättningarna finns för denna typ av styrning och när det efterfrågats i upphandlingen. Annars lämnas rutan tom. Även installationskostnaderna för den externa styrutrustningen ska ingå. Kostnaden anges per rumstyp. Används en central router anges ett medelvärde per rum."]
[null,null,null,null,null,null,"RESULTAT"]
[null,null,null,null,null,null,"4.1","Total kostnad per rumstyp","Total kostnad för respektive rumstyp under hela dess nyttjandetid summeras här."]
[null,null,null,null,null,null,"4.2","LENI-tal per rumstyp","Rumstypernas energianvändning per kvadratmeter och år redovisas här, det så kallade LENI-talet (Lighting Energy Numeric Indicator). Rekommenderade värden finns framtagna för kontor, skolor, vårdlokaler och sporthallar, se flik 4. Utifrån detta kan sedan hela anläggningens LENI-tal enkelt beräknas, om detta efterfrågas i upphandlingen.Se Upphandlingsmyndighetens kriterium för belysningsprojektering - \"Energikrav för belysningsanläggningar - kontor, skola, vård\"."]
[null,null,null,null,null,null,"4.3","Total kostnad per anläggning ","Här summeras kostnaderna för alla typrum som ingår i belysningsanläggningen."]
[null,null,null,null,null,null,"4.4","Energikostnad per år","Årlig energikostnad visas här för att öka medvetenheten kring anläggningens energianvändning."]
[null,null,null,null,null,null,"4.5","Energikostnad hela livslängden","Anläggningens totala energikostnader under dess livslängd anges här. I vissa fall kan renovering under nyttjandetiden bidra till förbättrad energiprestanda."]
[null,null,null,null,null,null,"4.6","Klimatpåverkan","Årlig klimatpåverkan, mätt i CO2-ekvivalenter, beräknas utifrån anläggningens energianvändning."]

{"sheet":"4. Reduktionsfaktorer, LENI-tal","index":7,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,18,5,21],[10,12,10,14],[8,6,8,14],[13,6,14,6],[22,6,23,6],[31,6,32,6],[36,6,37,6],[5,3,5,5],[5,6,5,7],[9,1,23,3]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[]
[null,"Reduktionsfaktorer",null,null,null,null,"Riktlinjer installerad effekt, eduktionsfaktorer för belysningsstyrning samt riktlinjer för årlig energianvändning per rumstyp\n"]
[null,"I tabellen anges:\n1. Riktlinjer för installerad effekt per rumstyp.\n2. Energireduktionsfaktorer för belysningsstyrning (reducering av drifttid)\n3. Riktlinjer för årlig energianvändning (LENI-tal) per rumstyp. \n\nInformationen är hämtad från Belysningsbranschens handbok \"Ljus & Rum\", kap 10. Riktlinjerna för installerad effekt gäller under normala förutsättningar och bör inte överstiga värdena i tabellen."]
[null,null,null,null,null,null,null,"Rumstyp","Riktlinjer max installerad effekt (W/m2)","Reduktionsfaktor Manuell styrning","Reduktionsfaktor Frånvaro-/ närvarostyrning","Reduktionsfaktor Dagsljusstyrning","Maximal årlig energianvändning (LENI-tal) per rumstyp (kWh/m2, år)\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manuell ","Frånvaro-/närvaro","Dagsljusstyrning"]
[null,null,null,null,null,null,"KONTOR","Cellkontor >10 kvm",10,0.8,0.75,0.56000000000000005,20,15,8]
[null,null,null,null,null,null,"Drifttid 2500h/år","Storkontor >12 kvm",12,1,0.9,0.77,30,27,21]
[null,null,null,null,null,null,null,"Korridor",8,1,0.75,0.56999999999999995,20,15,9]
[null,null,null,null,null,null,null,"Pausrum större",10,0.7,0.86,0.82,18,15,12]
[null,null,null,null,null,null,null,"Pausrum mindre",10,0.7,0.86,0.74,18,15,11]
[null,null,null,null,null,null,null,"Konferensrum",12,0.7,0.71,0.77,21,15,11]
[null,null,null,null,null,null,null,"Förråd",9,0.3,0.33,1,7,2,2]
[null,null,null,null,null,null,null,"Trapphus",9,1,0.4,1,23,9,9]
[null,null,null,null,null,null,null,"Garage (75-100 lux)",4,1,0.1,1,10,1,1]
[null,null,null,null,null,null,"SKOLA","Klassrum",12,0.95,0.79,0.82,23,18,15]
[null,null,null,null,null,null,"Drifttid 2000h/år","Grupprum",12,0.9,0.89,0.82,22,19,16]
[null,null,null,null,null,null,null,"Korridor",8,1,0.55000000000000004,0.56999999999999995,16,9,5]
[null,null,null,null,null,null,null,"Aula",16,0.8,0.75,0.64,26,19,12]
[null,null,null,null,null,null,null,"Uppehållsrum",10,1,0.6,0.82,20,12,10]
[null,null,null,null,null,null,null,"Matsal",11,1,1,0.86,28,28,24]
[null,null,null,null,null,null,null,"Kök",12,1,1,1,30,30,30]
[null,null,null,null,null,null,null,"Kök/förråd",9,0.7,0.86,1,16,14,14]
[null,null,null,null,null,null,null,"Personalrum <30 kvm",10,0.7,0.86,0.81,18,15,12]
[null,null,null,null,null,null,"SPORTHALL","Sporthall",16,1,0.7,0.84,64,45,37]
[null,null,null,null,null,null,"Drifttid 4000h/år","Omklädning",7,0.7,0.86,1,20,17,17]
[null,null,null,null,null,null,null,"Förråd",9,0.3,0.33,1,11,4,4]
[null,null,null,null,null,null,null,"Kommunikationsytor < 3m höjd",9,1,0.75,0.71,36,27,19]
[null,null,null,null,null,null,null,"Kommunikationsytor < 6m höjd",13,1,0.75,0.71,52,39,28]
[null,null,null,null,null,null,"SJUKHUS","Vård/patientrum, multifunktion",24,1,0.64,0.9,120,77,69]
[null,null,null,null,null,null,"Drifttid 5000h/år","Vård/patientrum",10,1,1,0.75,50,50,37]
[null,null,null,null,null,null,null,"Undersökning 500 lux",15,0.8,0.88,0.75,60,53,39]
[null,null,null,null,null,null,null,"Operation",22,1,1,1,110,110,110]
[null,null,null,null,null,null,null,"Korridor, normal samt städning",9,1,1,1,45,45,45]
[null,null,null,null,null,null,null,"Korridor, multifunktion och OP-avdelning",13,1,1,1,65,65,65]
[null,null,null,null,null,null,null,"Väntrum",10,1,1,1,50,50,50]
[null,null,null,null,null,null,null,"Kulvert",7,1,0.45,0.9,35,16,14]
[null,null,null,null,null,null,"Källa: Ljus och Rum, kapitel 10. "]

{"sheet":"5. Beräkningsfaktorer klimat ","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,15,5,18],[13,8,13,10],[15,8,15,10],[16,8,16,10],[17,8,17,10],[11,1,15,4],[21,8,21,10],[5,3,5,5],[5,6,5,7],[18,8,18,10],[19,8,19,10],[20,6,20,8],[9,1,10,4],[17,6,17,7],[16,6,16,7],[36,8,36,10],[37,8,37,10],[38,8,38,10],[9,6,9,7],[28,8,28,10],[29,8,29,10],[30,8,30,10],[32,8,32,10],[34,8,34,10],[35,8,35,10],[22,8,22,10],[23,8,23,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[27,8,27,10]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[]
[null,"Klimatpåverkan"]
[null,"Riktvärden för att kunna beräkna klimatpåverkan från elenergi. Används som frivillig indata i rad 1.5 i LCC-kalkylen.",null,null,null,null,"Värden för beräkning av klimatpåverkan från elanvändning  [kgCO2/kWh]"]
[null,null,null,null,null,null,"Ursprungsmärkt el",0]
[null,null,null,null,null,null,"Svensk elmix (normalår)",0.02]
[null,null,null,null,null,null,"Nordisk elmix",0.1]
[null,null,null,null,null,null,"El av okänt ursprung (Norden)",0.34399999999999997]
[null,null,null,null,null,null,"EU (25)",0.41499999999999998]
[]
[null,null,null,null,null,null,"Källa: Svensk Energi (www.svenskenergi.se) 2016-05-25. \nVärdet för EU 25 är hämtat från rapporten \"Den svenska elens miljöpåvekan\" från 2010."]

{"sheet":"6. Resultat","index":9,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,6,22,8],[22,9,22,11],[22,12,22,14],[22,15,22,17],[5,19,5,22],[15,18,15,20],[17,6,17,8],[17,9,17,11],[17,12,17,14],[17,15,17,17],[17,18,17,20],[16,6,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,17],[16,18,16,20],[5,1,5,2],[5,3,5,6],[5,7,5,11],[5,12,5,14],[5,15,5,18],[9,1,9,2],[9,3,9,9],[10,1,10,2],[10,3,10,9],[11,1,11,2],[11,3,11,9],[13,1,13,3],[15,6,15,8],[15,9,15,11],[15,12,15,14],[15,15,15,17],[21,18,21,20],[18,6,18,8],[18,9,18,11],[18,12,18,14],[18,15,18,17],[18,18,18,20],[19,6,19,8],[19,9,19,11],[19,12,19,14],[19,15,19,17],[19,18,19,20],[21,1,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14],[21,15,21,17],[24,6,24,8],[24,9,24,11],[24,12,24,14],[24,15,24,17],[24,18,24,20],[23,6,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,17],[23,18,23,20],[49,6,49,8],[49,9,49,11],[49,12,49,14],[49,15,49,17],[49,18,49,20]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[]
[null,"Resultat LCC-kalkyl för upphandling av inomhusbelysning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sida 1 av 1"]
[null,"Projekt:",null,{"$f":"'2. LCC A1'!F11","v":"Projektnamn"}]
[null,"Datum:",null,{"$f":"'2. LCC A1'!F12","v":"2016-01-01"}]
[null,"Handläggare:",null,{"$f":"'2. LCC A1'!F13","v":"NAMN"}]
[]
[null,"Beräkning baserad på",null,null,{"$f":"'2. LCC A1'!$H$15","v":0},null,"år",null,"Kalkylränta",null,{"$f":"'2. LCC A1'!$H$16","v":1.7500000000000002E-2},null,"Resultaten är beräknade enligt nuvärdesmetoden."]
[]
[null,"LCC-kostnader",null,null,null,null,"Anläggning 1",null,null,"Anläggning 2",null,null,"Anläggning 3",null,null,"Anläggning 4"]
[null,"Investeringskostnader",null,null,null,null,{"$f":"'2. LCC A1'!$I$176","v":0},null,null,{"$f":"'2. LCC A2'!$I$176","v":0},null,null,{"$f":"'2. LCC A3'!$I$176","v":0},null,null,{"$f":"'2. LCC A4'!$I$176","v":0}]
[null,"Energikostnader",null,null,null,null,{"$f":"'2. LCC A1'!$I$197","v":0},null,null,{"$f":"'2. LCC A2'!$I$197","v":0},null,null,{"$f":"'2. LCC A3'!$I$197","v":0},null,null,{"$f":"'2. LCC A4'!$I$197","v":0}]
[null,"Underhållskostnader",null,null,null,null,{"$f":"'2. LCC A1'!$I$213","v":0},null,null,{"$f":"'2. LCC A2'!$I$213","v":0},null,null,{"$f":"'2. LCC A3'!$I$213","v":0},null,null,{"$f":"'2. LCC A4'!$I$213","v":0}]
[null,"Totala LCC-kostnader",null,null,null,null,{"$f":"SUM(G17:I19)","v":0},null,null,{"$f":"SUM(J17:L19)","v":0},null,null,{"$f":"SUM(M17:O19)","v":0},null,null,{"$f":"SUM(P17:R19)","v":0}]
[]
[null,"Energianvändning & klimatpåverkan ",null,null,null,null,{"$f":"G16","v":"Anläggning 1"},null,null,{"$f":"J16","v":"Anläggning 2"},null,null,{"$f":"M16","v":"Anläggning 3"},null,null,{"$f":"P16","v":"Anläggning 4"}]
[]
[null,"Energianvändning ",null,null,"[kWh/år]",null,{"$f":"'2. LCC A1'!$I$192","v":0},null,null,{"$f":"'2. LCC A2'!$I$192","v":0},null,null,{"$f":"'2. LCC A3'!$I$192","v":0},null,null,{"$f":"'2. LCC A4'!$I$192","v":0}]
[null,"Klimatpåverkan",null,null,"[kgC02-e/år]",null,{"$f":"'2. LCC A1'!$I$160","v":0},null,null,{"$f":"'2. LCC A2'!$I$160","v":0},null,null,{"$f":"'2. LCC A3'!$I$160","v":0},null,null,{"$f":"'2. LCC A4'!$I$160","v":0}]

{"sheet":"7. Svarsformulär","index":10,"n_rows":70,"n_cols":29,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,26,69,29],[12,26,12,29],[39,10,39,13],[54,10,54,13],[36,26,36,29],[47,26,47,29],[58,26,58,29],[47,10,47,13],[34,10,34,13],[35,10,35,13],[36,10,36,13],[41,10,41,13],[42,10,42,13],[40,10,40,13],[43,10,43,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,10,24,13],[25,10,25,13],[31,10,31,13],[32,10,32,13],[33,10,33,13],[28,10,28,13],[29,10,29,13],[30,10,30,13],[5,1,5,2],[5,3,5,5],[5,6,5,10],[5,11,5,14],[5,15,5,18],[11,10,11,13],[17,10,17,13],[18,10,18,13],[5,19,5,22],[12,10,12,13],[13,10,13,13],[14,10,14,13],[69,10,69,13],[25,26,25,29],[61,10,61,13],[62,10,62,13],[63,10,63,13],[50,10,50,13],[51,10,51,13],[52,10,52,13],[53,10,53,13],[55,10,55,13],[56,10,56,13],[57,10,57,13],[58,10,58,13],[44,10,44,13],[45,10,45,13],[46,10,46,13],[64,10,64,13],[65,10,65,13],[66,10,66,13],[67,10,67,13],[68,10,68,13]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[]
[null,null,null,"Svarsformulär för anbudsgivare",null,null,null,null,null,null,null,null,"Sida 1 av 2",null,null,null,null,null,null,"Svarsformulär för anbudsgivare",null,null,null,null,null,null,null,null,"Sida 2 av 2"]
[null,null,null,"LCC-kalkyl för upphandling av inomhusbelysning.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCC-kalkyl för upphandling av inomhusbelysning"]
[null,null,null,"Bifoga/ skriv ut ett blad per rumstyp. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bifoga/ skriv ut ett blad per rumstyp. "]
[null,null,null,"Rumstyp 1",null,null,null,null,"namn"]
[null,null,null,"Antal rum av samma typ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"forts. rumstyp 1",null,null,null,null,"namn"]
[null,null,null,"Antal kvadratmeter",null,null,null,null,"kvm/rum"]
[null,null,null,"Kostnad extern styrutrustning",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 6"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 7"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 8"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 9"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 10"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]

{"sheet":"Blad1","index":11,"n_rows":70,"n_cols":29,"rows_kept":70,"cut":false,"hidden":false,"merged":[[5,19,5,22],[5,1,5,2],[5,3,5,5],[5,6,5,10],[5,11,5,14],[5,15,5,18],[24,10,24,13],[11,10,11,13],[12,10,12,13],[12,26,12,29],[13,10,13,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[36,26,36,29],[25,10,25,13],[25,26,25,29],[28,10,28,13],[29,10,29,13],[30,10,30,13],[31,10,31,13],[44,10,44,13],[32,10,32,13],[33,10,33,13],[34,10,34,13],[35,10,35,13],[36,10,36,13],[39,10,39,13],[40,10,40,13],[41,10,41,13],[42,10,42,13],[43,10,43,13],[57,10,57,13],[45,10,45,13],[46,10,46,13],[47,10,47,13],[47,26,47,29],[50,10,50,13],[51,10,51,13],[52,10,52,13],[53,10,53,13],[54,10,54,13],[55,10,55,13],[56,10,56,13],[69,26,69,29],[58,10,58,13],[58,26,58,29],[61,10,61,13],[62,10,62,13],[63,10,63,13],[64,10,64,13],[65,10,65,13],[66,10,66,13],[67,10,67,13],[68,10,68,13],[69,10,69,13]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G2","v":"LCC-kalkyl för upphandling av inomhusbelysning"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G3","v":"Version 1 .0"}]
[null,null,null,null,null,null,{"$f":"'1. Introduktion'!G4","v":"Datum: 2016-05-27"}]
[]
[]
[]
[]
[null,null,null,"Svarsformulär för anbudsgivare",null,null,null,null,null,null,null,null,"Sida 1 av 2",null,null,null,null,null,null,"Svarsformulär för anbudsgivare",null,null,null,null,null,null,null,null,"Sida 2 av 2"]
[null,null,null,"LCC-kalkyl för upphandling av inomhusbelysning.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCC-kalkyl för upphandling av inomhusbelysning"]
[null,null,null,"Bifoga/ skriv ut ett blad per typrum. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bifoga/ skriv ut ett blad per typrum. "]
[null,null,null,"Typrum 1",null,null,null,null,"namn"]
[null,null,null,"Antal rum av samma typ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"forts. typrum 1",null,null,null,null,"namn"]
[null,null,null,"Antal kvadratmeter",null,null,null,null,"kvm/rum"]
[null,null,null,"Kostnad extern styrutrustning",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 6"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 7"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 8"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 9"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]
[]
[null,null,null,"Armaturtyp 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armaturtyp 10"]
[null,null,null,"Antal armaturer ",null,null,null,null,"stk",null,null,null,null,null,null,null,null,null,null,"Antal armaturer ",null,null,null,null,"stk"]
[null,null,null,"Armaturpris",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Armaturpris",null,null,null,null,"kr/stk"]
[null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk",null,null,null,null,null,null,null,null,null,null,"Material- och arbetskostnader armatur",null,null,null,null,"kr/stk"]
[null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk",null,null,null,null,null,null,null,null,null,null,"Effekt per armatur, inkl. driftsförluster",null,null,null,null,"W/stk"]
[null,null,null,"Typ av styrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typ av styrning"]
[null,null,null,"Reduktionsfaktor manuell styrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor manuell styrning "]
[null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor närvaro-/frånvarostyrning "]
[null,null,null,"Reduktionsfaktor dagsljusstyrning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduktionsfaktor dagsljusstyrning"]
[null,null,null,"Underhållskostnader",null,null,null,null,"kr/år",null,null,null,null,null,null,null,null,null,null,"Underhållskostnader",null,null,null,null,"kr/år"]