{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Introduction","TEMP","2. LCC-calc.","3. Result","3.1 CO2 Emissions","3.2 Light pollution","4. Tool parameters","5. Response sheet","6. Climate impact factors"],"not_rendered":{"charts":8,"images":6,"macros":1,"external_links":2,"defined_names":21,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"3.1 CO2 Emissions","index":4,"reason":"not_a_worksheet"},{"sheet":"3.2 Light pollution","index":5,"reason":"not_a_worksheet"}],"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. Introduction","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,1,11,4],[26,7,26,12],[28,7,28,20],[118,7,118,9],[119,7,119,22],[108,7,108,23],[109,7,109,23],[111,7,111,8],[113,7,113,20],[115,7,115,12],[92,7,92,9],[93,7,93,22],[95,7,95,22],[107,7,107,23],[117,7,117,20],[29,7,29,14],[5,1,5,2],[5,3,5,5],[8,1,8,4],[19,1,19,4],[45,7,47,20],[5,6,5,10],[5,11,5,14],[5,19,5,22],[5,15,5,18],[33,7,33,20],[32,7,32,9],[31,7,31,19],[37,7,37,19],[43,7,43,22],[22,7,22,8],[24,7,24,20]]}
[]
[null,null,null,null,null,null,{"$f":"'[2]1. Introduction'!G2","v":"LCC-calculation for procurement of outdoor lighting systems"}]
[null,null,null,null,null,null,"Version 2.14"]
[null,null,null,null,null,null,"Date: 2022-05-10"]
[null,null,null,null,null,null,"Customized by Alejandro Sánchez de Miguel"]
[]
[]
[]
[null,"Introduction"]
[null,"General instructions for how to use the tool."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"What is LCC?\n"]
[]
[null,null,null,null,null,null,null,"LCC stands for life-cycle costing. By using an LCC-tool one obtains a total picture of the costs associated with the use phase of a product, service or works. Comparisons can be made between different product alternatives and solutions. A life-cycle costing perspective can be used in many parts of the procurement process, and is also useful when working strategically with the organisation’s budget. \n\n"]
[]
[null,null,null,null,null,null,null,"How shall I use the tool?"]
[]
[null,null,null,null,null,null,null,"This tool is designed especially for the procurement of outdoor lighting. The tool can be used in the need’s analysis, when choosing criteria and in the evaluation of tenders. In this tool you can also calculate the climate impact based on the energy usage from the lighting system. \n\nIn the need’s analysis, the tool can be used to get an early indication for the costs associated with the lighting system. For a lighting system, the operating cost for energy is a large component of the overall cost. By testing different rates of price increases, one can see different cost scenarios during the usage time. The contracting authority can also compare different alternative solutions through, for example, including or excluding control systems.\n\nIf using an LCC-tool in the evaluation of tenders, the procurement documents must describe the parameters used in the calculation. How shall the parameters be documented and which methods for measurements shall the data  be based upon? Procuring entities can use the procurement criteria “The lighting system's life cycle cost (LCC)”. The criteria can be downloaded through the National Agency for Public Procurement’s website. One rule of thumb when using an LCC-tool is to only include the large cost items, or  costs that is expected to differ between different suppliers. Costs for environmental externalities can be included if their monetary value can be determined and verified in a standardised way.\n\nIn evaluation of tenders, the life-cycle cost will be included as a parameter for evaluating the most economically advantageous tender. Quality requirements for the lighting system, such as light quality, is not included in the tool and must be specified separately in the tender documents. "]
[null,null,null,null,null,null,null,"Design of the LCC tool "]
[]
[null,null,null,null,null,null,null,"The tool consists of 6 tabs:\n1. Introduction: general instructions on how to use the tool.\n2. LCC-tool: Calculation sheet where the life-cycle costing analysis is performed with standardised parameters. Instructions regarding the parameters can be found in the comments as well as in tab 4.\n3. Result: A visual view of the LCC-calculation result with the 10 most cost effective solutions.\n4. Tool parameters: Instructions on each of the cost parameters used in the tool and what data that shall be included.\n5. Respondent sheet: Sheet for the supplier to attach to the tender.\n6. Climate impact factors: Factors for calculating the environmental impact from energy.\n\nThe contracting authority (CA) quote data to the upper part of the calculation tool, that is conditions for calculation and information on use.The CA might also give information regarding current lighting system, if one exists. This might clarify the improvements with a new, or renovated, system.\n\nThe supplier will fill in remaining data according to the standards or instructions given. All costs shall be specified without VAT. Alternative lighting solutions these shall be specified in new columns. The supplier shall complete the respondent sheet and attach it to the tender. The CA may then fill in the supplier’s tender offer in a LCC-tool sheet to be able to compare the incoming tenders in the result tab.\n\nThe LCC-tools are based on present value method to be able to calculate future cost to present value. The equation for calculating present value is included in the tool. Discount rate, electricity prices and economic period are examples of parameters that might affect the result and shall be decided upon within the CA. For example, a high discount rate will make the value of money lower during the calculation period while a low discount rate will allow the value of money to consist over time. Furthermore, a longer calculation period will give the operating cost a high impact on the overall result. To get an understanding for the final result, the tool can also be tested with different values for energy price increases etc.\n\n\n"]
[null,null,null,null,null,null,null,"Contact"]
[null,null,null,null,null,null,null,"The National Agency for Public Procurement develops and administrates the LCC-tools. The tools are optional to use in the public, as well as the private, sector. The National Agency for Public Procurement is responsible for the content in this tool. Any changes are made upon the responsibility of the user. Any questions regarding the tool, please contact info@uhmynd.se."]
[null,null,null,null,null,null,null,"For the light pollution part, contact Alejandro Sánchez de Miguel, alejasan@ucm.es"]

{"sheet":"TEMP","index":1,"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-calc.","index":2,"n_rows":198,"n_cols":21,"rows_kept":198,"cut":false,"hidden":false,"merged":[[61,2,61,6],[63,2,63,6],[76,2,76,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[62,2,62,6],[67,2,67,6],[70,2,70,6],[57,2,57,3],[52,2,52,6],[53,2,53,6],[55,2,55,6],[54,2,54,6],[109,2,109,6],[110,2,110,6],[50,2,50,6],[51,2,51,6],[45,2,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[108,2,108,6],[106,2,106,6],[60,2,60,6],[64,2,64,6],[71,2,71,6],[68,2,68,6],[66,2,66,6],[101,2,101,6],[69,2,69,6],[104,2,104,6],[92,2,92,6],[59,2,59,6],[94,2,94,6],[91,2,91,6],[81,2,81,6],[84,2,84,6],[80,2,80,6],[83,2,83,6],[82,2,82,6],[79,2,79,6],[77,2,77,6],[78,2,78,6],[74,2,74,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[30,2,30,6],[32,2,32,6],[31,2,31,6],[17,2,17,6],[18,2,18,6],[27,2,27,6],[29,2,29,6],[28,2,28,6],[23,2,23,6],[26,2,26,6],[5,7,5,8],[5,2,5,3],[5,4,5,6],[8,2,8,7],[10,2,10,4],[10,5,10,8],[40,2,40,6],[41,2,41,6],[11,2,11,4],[11,5,11,8],[12,2,12,4],[20,2,20,6],[22,2,22,6],[19,2,19,6],[21,2,21,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[35,2,35,6],[33,2,33,6],[34,2,34,6],[12,5,12,8]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G2","v":"LCC-calculation for procurement of outdoor lighting systems"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G3","v":"Version 2.14"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G4","v":"Date: 2022-05-10"}]
[null,null,null,null,null,null,"Customized by Alejandro Sánchez de Miguel"]
[]
[]
[]
[null,null,"Calculation conditions (specified by the CA)"]
[]
[null,null,"PROJECT:",null,null,"Scenario 1"]
[null,null,"DATE:",null,null,"05/04/2022"]
[null,null,"ADMINISTRATOR:"]
[]
[null,"1.1","Usage time",null,null,null,null,30,"year"]
[null,"1.2","Discount rate",null,null,null,null,1.7500000000000002E-2]
[null,"1.3","Electricity price",null,null,null,null,0.12,"€/kWh"]
[null,"1.4","Annual electricity price change",null,null,null,null,0.02]
[null,"1.5","Climate impact electricity usage (optional)",null,null,null,null,0.41499999999999998,"kgCO2/kWh"]
[null,"1.6","Operating hours of the lighting system (total)",null,null,null,null,4100,"h/year"]
[null,"1.7","Operating hours full power",null,null,null,null,1095,"h/year"]
[null,"1.8","Operating hours power level 1",null,null,null,null,730,"h/year"]
[null,"1.9","Operating hours power level 2",null,null,null,null,2275,"h/year"]
[]
[null,null,"Data from supplier"]
[]
[null,null,"Name",null,null,null,null,null,"HPS 150 W cobra No diming*","HPS 150W standar diming","HPS 150W new dimming","HPS 70W standar diming","LED no diming","LED diming","NEW LED dimming","3000 k All lumens","4000k All Lumens","3000k reduced lumens","4000k reduced Lumens","PC Amber","2200 k reduced lumens"]
[null,null,"Calculation of investment costs"]
[null,"2.1","Number of luminaires",null,null,null,null,"qty",500,500,{"$f":"J29","v":500},500,500,500,500,500,500,500,500,500,500]
[null,"2.2","Price per luminaire (incl. light source, electrical ballast, control device)",null,null,null,null,"€/piece",17,17,{"$f":"J30","v":17},17,500,500,500,500,500,500,500,500,501]
[null,"2.3","Material and labour costs per luminaire",null,null,null,null,"€/piece",89,89,89,89,{"$f":"L31","v":89},89,{"$f":"N31","v":89},89,{"$f":"P31","v":89},89,{"$f":"R31","v":89},89,89]
[null,"2.4","Number of poles and foundations",null,null,null,null,"qty",500,500,500,500,{"$f":"L32","v":500},500,{"$f":"N32","v":500},500,{"$f":"P32","v":500},500,{"$f":"R32","v":500},500,500]
[null,"2.5","Price per pole and foundation",null,null,null,null,"€/piece",3240,3240,3240,3240,3240,{"$f":"M33","v":3240},{"$f":"N33","v":3240},3240,{"$f":"P33","v":3240},3240,{"$f":"R33","v":3240},3240,3240]
[null,"2.6","Material and labour costs per pole incl. foundation",null,null,null,null,"€/piece",1215,1215,1215,1215,1215,{"$f":"M34","v":1215},{"$f":"N34","v":1215},1215,{"$f":"P34","v":1215},1215,{"$f":"R34","v":1215},1215,1215]
[null,"2.7","Cost of external control device (incl. operation start-up and license fees)\n",null,null,null,null,"Euro",0,0,0,0,{"$f":"L35","v":0},0,{"$f":"N35","v":0},0,{"$f":"P35","v":0},0,{"$f":"R35","v":0},0,0]
[null,null,"Calculation of operating costs"]
[null,"3.1","Effect per luminaire incl. operating loss and system effects",null,null,null,null,"W",150,150,150,70,100,100,80,150,120,97,88,88,88]
[null,"3.2","Reduced power level 1",null,null,null,null,"W",150,{"$f":"150*0.8","v":120},120,50,100,50,40,150,120,77,70,50,50]
[null,"3.3","Reduced power level 2",null,null,null,null,"W",150,120,70,50,100,50,40,150,120,50,50,50,50]
[null,null,"Calculation of maintenance costs"]
[null,"4.1","Light source cost per luminaire",null,null,null,null,"€/piece",17,17,{"$f":"J41","v":17},{"$f":"K41","v":17},200,200,200,200,200,200,200,200,200]
[null,"4.2","Labour cost light source replacement",null,null,null,null,"€/piece",89,{"$f":"I42","v":89},{"$f":"J42","v":89},89,{"$f":"L42","v":89},89,{"$f":"N42","v":89},89,{"$f":"P42","v":89},89,{"$f":"R42","v":89},89,89]
[null,"4.3","Replacement interval light sources",null,null,null,null,"h",22000,22000,22000,22000,50000,50000,50000,50000,50000,50001,50002,50003,50004]
[null,"4.4","Electrical ballast cost",null,null,null,null,"€/piece",160,{"$f":"I44","v":160},160,160,{"$f":"L44","v":160},160,{"$f":"N44","v":160},160,{"$f":"P44","v":160},160,{"$f":"R44","v":160},160,160]
[null,"4.5","Labour cost electrical ballast replacement",null,null,null,null,"€/piece",89,{"$f":"I45","v":89},89,89,{"$f":"L45","v":89},89,{"$f":"N45","v":89},89,{"$f":"P45","v":89},89,{"$f":"R45","v":89},89,89]
[null,"4.6","Replacement interval electrical ballast",null,null,null,null,"h",80000,{"$f":"I46","v":80000},80000,80000,50000,50000,50000,50000,50000,50000,50000,50001,50002]
[null,"4.7","Lifespan luminaire",null,null,null,null,"year",30,{"$f":"I47","v":30},30,30,{"$f":"L47","v":30},30,{"$f":"N47","v":30},30,{"$f":"P47","v":30},30,{"$f":"R47","v":30},30,30]
[null,"4.8","Lifespan pole",null,null,null,null,"year",30,{"$f":"I48","v":30},30,30,{"$f":"L48","v":30},30,{"$f":"N48","v":30},30,{"$f":"P48","v":30},30,{"$f":"R48","v":30},30,30]
[null,"4.9","Labour cost inspection",null,null,null,null,"€/piece",58,{"$f":"I49","v":58},58,58,{"$f":"L49","v":58},58,{"$f":"N49","v":58},58,{"$f":"P49","v":58},58,{"$f":"R49","v":58},58,58]
[null,"4.10","Inspection interval",null,null,null,null,"year",5,{"$f":"I50","v":5},5,5,{"$f":"L50","v":5},5,{"$f":"N50","v":5},5,{"$f":"P50","v":5},5,{"$f":"R50","v":5},5,5]
[null,"4.11","Labour cost surveillance",null,null,null,null,"€/piece",1,{"$f":"I51","v":1},1,1,{"$f":"L51","v":1},1,{"$f":"N51","v":1},1,{"$f":"P51","v":1},1,{"$f":"R51","v":1},1,1]
[null,"4.12","Surveillance interval",null,null,null,null,"year",2,{"$f":"I52","v":2},2,2,{"$f":"L52","v":2},2,{"$f":"N52","v":2},2,{"$f":"P52","v":2},2,{"$f":"R52","v":2},2,2]
["Modificed colums","4.13","Correlated Colour Temperature\n",null,null,null,null,"k",2400,{"$f":"I53","v":2400},{"$f":"J53","v":2400},{"$f":"K53","v":2400},3000,{"$f":"M53","v":3000},{"$f":"N53","v":3000},{"$f":"O53","v":3000},4000,3000,4000,1800,2200]
["Modificed colums","4.14","Lighting eficiency",null,null,null,null,"lm/W",120,120,120,100,95,95,147,113,147,113,147,113,113]
[null,"4.15","Upward Light Output ratio",null,null,null,null,"%",0.05,0.05,0.05,0.05,0,0,0,0,0,0,0,0,0]
[null,"4.16","Environment",null,null,null,null,"Urban/Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural"]
[]
[null,null,"Result"]
[null,null,"Rangordning av alternativ",null,null,null,null,null,{"$f":"IF(I108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<I108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:I108=I108)*1))","v":10},{"$f":"IF(J108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<J108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:J108=J108)*1))","v":9},{"$f":"IF(K108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<K108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:K108=K108)*1))","v":2},{"$f":"IF(L108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<L108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:L108=L108)*1))","v":1},{"$f":"IF(M108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<M108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:M108=M108)*1))","v":11},{"$f":"IF(N108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<N108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:N108=N108)*1))","v":6},{"$f":"IF(O108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<O108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:O108=O108)*1))","v":3},{"$f":"IF(P108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<P108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:P108=P108)*1))","v":13},{"$f":"IF(Q108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<Q108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:Q108=Q108)*1))","v":12},{"$f":"IF(R108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<R108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:R108=R108)*1))","v":8},{"$f":"IF(S108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<S108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:S108=S108)*1))","v":7},{"$f":"IF(T108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<T108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:T108=T108)*1))","v":4},{"$f":"IF(U108=\"\",\"\",SUMPRODUCT(($I$108:$XFD$108<U108)*($I$108:$XFD$108<>\"\"))+SUMPRODUCT(($I$108:U108=U108)*1))","v":5}]
[null,null,null,null,null,null,null,null,"Current facility",{"$f":"J67","v":"HPS 150W standar diming"},{"$f":"K67","v":"HPS 150W new dimming"},"HPS 70W standar diming",{"$f":"M67","v":"LED no diming"},"LED diming",{"$f":"O67","v":"NEW LED dimming"},"3000 k All lumens",{"$f":"Q67","v":"4000k All Lumens"},"3000k reduced lumens",{"$f":"S67","v":"4000k reduced Lumens"},"PC Amber",{"$f":"U67","v":"2200 k reduced lumens"}]
[null,null,"TOTAL COST",null,null,null,null,"€",{"$f":"I108","v":3925352.297120777},3760059.0118781957,3551494.2731500352,3213756.9116227641,{"$f":"M108","v":3925457.6808387991},3649968.872101163,{"$f":"O108","v":3554716.6683479506},4301332.5945906481,{"$f":"Q108","v":4075807.6463395385},3680079.2091327393,{"$f":"S108","v":3652634.8461759365},3625854.9901469462,{"$f":"U108","v":3626344.7625308423}]
[null,null,"Energy costs per year",null,null,null,null,"€",{"$f":"I91","v":36900},31491,24666,13614,{"$f":"M91","v":24600},15585,{"$f":"O91","v":12468},36900,{"$f":"Q91","v":29520},16570.5,{"$f":"S91","v":15672.599999999999},14796.599999999999,{"$f":"U91","v":14796.599999999999}]
[null,null,"Energy costs full usage time",null,null,null,null,"€",{"$f":"I93","v":1127624.7412555474},962331.45601296588,753766.71728480572,416029.35575753445,{"$f":"M93","v":751749.8275036983},476261.01876606251,{"$f":"O93","v":381008.81501284998},1127624.7412555474,{"$f":"Q93","v":902099.79300443793},506376.85027032648,{"$f":"S93","v":478937.98156644148},452168.35356265126,{"$f":"U93","v":452168.35356265126}]
["Modificed colums",null,"Climate impact*****",null,null,null,null,"kgCO2/year",{"$f":"I90*$H$19+I190/I47","v":134070},{"$f":"J90*$H$19+J190/J47","v":114417.3},{"$f":"K90*$H$19+K190/K47","v":89619.8},{"$f":"L90*$H$19+L190/L47","v":49067.125},{"$f":"M90*$H$19+M190/M47","v":101083.45},{"$f":"N90*$H$19+N190/N47","v":64040.063750000001},{"$f":"O90*$H$19+O190/O47","v":55673.152600000001},{"$f":"P90*$H$19+P190/P47","v":156174.94500000001},{"$f":"Q90*$H$19+Q190/Q47","v":131815.16399999999},{"$f":"R90*$H$19+R190/R47","v":70132.708025},{"$f":"S90*$H$19+S190/S47","v":69982.599569999991},{"$f":"T90*$H$19+T190/T47","v":62624.883229999999},{"$f":"U90*$H$19+U190/U47","v":62638.816695000001}]
[]
[null,null,"LCC-calculation"]
[null,null,null,null,null,null,null,null,"Current facility",{"$f":"J27","v":"HPS 150W standar diming"},{"$f":"K27","v":"HPS 150W new dimming"},{"$f":"L27","v":"HPS 70W standar diming"},{"$f":"M27","v":"LED no diming"},{"$f":"N27","v":"LED diming"},{"$f":"O27","v":"NEW LED dimming"},{"$f":"P27","v":"3000 k All lumens"},{"$f":"Q27","v":"4000k All Lumens"},{"$f":"R27","v":"3000k reduced lumens"},{"$f":"S27","v":"4000k reduced Lumens"},{"$f":"T27","v":"PC Amber"},{"$f":"U27","v":"2200 k reduced lumens"}]
[null,null,"INVESTMENT COSTS"]
[null,null,"Luminaires (may include poles)"]
[null,null,"Number of luminaires",null,null,null,null,"qty",{"$f":"I29","v":500},{"$f":"J29","v":500},{"$f":"K29","v":500},{"$f":"L29","v":500},{"$f":"M29","v":500},{"$f":"N29","v":500},{"$f":"O29","v":500},{"$f":"P29","v":500},{"$f":"Q29","v":500},{"$f":"R29","v":500},{"$f":"S29","v":500},{"$f":"T29","v":500},{"$f":"U29","v":500}]
[null,null,"á-price",null,null,null,null,"€/piece",{"$f":"I30","v":17},{"$f":"J30","v":17},{"$f":"K30","v":17},{"$f":"L30","v":17},{"$f":"M30","v":500},{"$f":"N30","v":500},{"$f":"O30","v":500},{"$f":"P30","v":500},{"$f":"Q30","v":500},{"$f":"R30","v":500},{"$f":"S30","v":500},{"$f":"T30","v":500},{"$f":"U30","v":501}]
[null,null,"Total luminaire cost",null,null,null,null,"kronor",{"$f":"I70*I71","v":8500},8500,8500,8500,{"$f":"M70*M71","v":250000},250000,{"$f":"O70*O71","v":250000},250000,{"$f":"Q70*Q71","v":250000},250000,{"$f":"S70*S71","v":250000},250000,{"$f":"U70*U71","v":250500}]
[null,null,"Poles and foundations"]
[null,null,"Number of poles including foundation",null,null,null,null,"qty",{"$f":"I32","v":500},{"$f":"J32","v":500},{"$f":"K32","v":500},{"$f":"L32","v":500},{"$f":"M32","v":500},{"$f":"N32","v":500},{"$f":"O32","v":500},{"$f":"P32","v":500},{"$f":"Q32","v":500},{"$f":"R32","v":500},{"$f":"S32","v":500},{"$f":"T32","v":500},{"$f":"U32","v":500}]
[null,null,"á-price",null,null,null,null,"€/piece",{"$f":"I33","v":3240},{"$f":"J33","v":3240},{"$f":"K33","v":3240},{"$f":"L33","v":3240},{"$f":"M33","v":3240},{"$f":"N33","v":3240},{"$f":"O33","v":3240},{"$f":"P33","v":3240},{"$f":"Q33","v":3240},{"$f":"R33","v":3240},{"$f":"S33","v":3240},{"$f":"T33","v":3240},{"$f":"U33","v":3240}]
[null,null,null,null,null,null,null,null,{"$f":"I74*I75","v":1620000},{"$f":"J74*J75","v":1620000},1620000,{"$f":"L74*L75","v":1620000},1620000,{"$f":"N74*N75","v":1620000},1620000,{"$f":"P74*P75","v":1620000},1620000,{"$f":"R74*R75","v":1620000},1620000,{"$f":"T74*T75","v":1620000},1620000]
[null,null,"Cost of installation"]
[null,null,"Material and labour cost for luminaires",null,null,null,null,"€",{"$f":"I31*I29","v":44500},{"$f":"J31*J29","v":44500},{"$f":"K31*K29","v":44500},{"$f":"L31*L29","v":44500},{"$f":"M31*M29","v":44500},{"$f":"N31*N29","v":44500},{"$f":"O31*O29","v":44500},{"$f":"P31*P29","v":44500},{"$f":"Q31*Q29","v":44500},{"$f":"R31*R29","v":44500},{"$f":"S31*S29","v":44500},{"$f":"T31*T29","v":44500},{"$f":"U31*U29","v":44500}]
[null,null,"Material and labour costs for poles including foundation",null,null,null,null,"€",{"$f":"I34*I32","v":607500},{"$f":"J34*J32","v":607500},{"$f":"K34*K32","v":607500},{"$f":"L34*L32","v":607500},{"$f":"M34*M32","v":607500},{"$f":"N34*N32","v":607500},{"$f":"O34*O32","v":607500},{"$f":"P34*P32","v":607500},{"$f":"Q34*Q32","v":607500},{"$f":"R34*R32","v":607500},{"$f":"S34*S32","v":607500},{"$f":"T34*T32","v":607500},{"$f":"U34*U32","v":607500}]
[null,null,"Total cost of installation",null,null,null,null,"€",{"$f":"SUM(I78:I79)","v":652000},{"$f":"SUM(J78:J79)","v":652000},652000,652000,{"$f":"SUM(M78:M79)","v":652000},652000,{"$f":"SUM(O78:O79)","v":652000},652000,{"$f":"SUM(Q78:Q79)","v":652000},652000,{"$f":"SUM(S78:S79)","v":652000},652000,{"$f":"SUM(U78:U79)","v":652000}]
[null,null,"Cost of external control device",null,null,null,null,"€",{"$f":"I35","v":0},{"$f":"J35","v":0},{"$f":"K35","v":0},{"$f":"L35","v":0},{"$f":"M35","v":0},{"$f":"N35","v":0},{"$f":"O35","v":0},{"$f":"P35","v":0},{"$f":"Q35","v":0},{"$f":"R35","v":0},{"$f":"S35","v":0},{"$f":"T35","v":0},{"$f":"U35","v":0}]
[null,null,"SUM INVESTMENT COSTS",null,null,null,null,"€",{"$f":"I72+I76+I80+I81","v":2280500},2280500,2280500,2280500,{"$f":"M72+M76+M80+M81","v":2522000},2522000,{"$f":"O72+O76+O80+O81","v":2522000},2522000,{"$f":"Q72+Q76+Q80+Q81","v":2522000},2522000,{"$f":"S72+S76+S80+S81","v":2522000},2522000,{"$f":"U72+U76+U80+U81","v":2522500}]
[]
[null,null,"ENERGY & MAINTENANCE COSTS"]
[null,null,"ENERGY COSTS"]
[null,null,"Total installed effect",null,null,null,null,"W",{"$f":"I37*I29","v":75000},{"$f":"J37*J29","v":75000},{"$f":"K37*K29","v":75000},{"$f":"L37*L29","v":35000},{"$f":"M37*M29","v":50000},{"$f":"N37*N29","v":50000},{"$f":"O37*O29","v":40000},{"$f":"P37*P29","v":75000},{"$f":"Q37*Q29","v":60000},{"$f":"R37*R29","v":48500},{"$f":"S37*S29","v":44000},{"$f":"T37*T29","v":44000},{"$f":"U37*U29","v":44000}]
[null,null,"Energy usage full effect",null,null,null,null,"kWh",{"$f":"(I$37*($H$20-IF(I$88>0,$H$22,0)-IF(I$89>0,$H$23,0))*I$29/1000)","v":82125},{"$f":"(J$37*($H$20-IF(J$88>0,$H$22,0)-IF(J$89>0,$H$23,0))*J$29/1000)","v":82125},{"$f":"(K$37*($H$20-IF(K$88>0,$H$22,0)-IF(K$89>0,$H$23,0))*K$29/1000)","v":82125},{"$f":"(L$37*($H$20-IF(L$88>0,$H$22,0)-IF(L$89>0,$H$23,0))*L$29/1000)","v":38325},{"$f":"(M$37*($H$20-IF(M$88>0,$H$22,0)-IF(M$89>0,$H$23,0))*M$29/1000)","v":54750},{"$f":"(N$37*($H$20-IF(N$88>0,$H$22,0)-IF(N$89>0,$H$23,0))*N$29/1000)","v":54750},{"$f":"(O$37*($H$20-IF(O$88>0,$H$22,0)-IF(O$89>0,$H$23,0))*O$29/1000)","v":43800},{"$f":"(P$37*($H$20-IF(P$88>0,$H$22,0)-IF(P$89>0,$H$23,0))*P$29/1000)","v":82125},{"$f":"(Q$37*($H$20-IF(Q$88>0,$H$22,0)-IF(Q$89>0,$H$23,0))*Q$29/1000)","v":65700},{"$f":"(R$37*($H$20-IF(R$88>0,$H$22,0)-IF(R$89>0,$H$23,0))*R$29/1000)","v":53107.5},{"$f":"(S$37*($H$20-IF(S$88>0,$H$22,0)-IF(S$89>0,$H$23,0))*S$29/1000)","v":48180},{"$f":"(T$37*($H$20-IF(T$88>0,$H$22,0)-IF(T$89>0,$H$23,0))*T$29/1000)","v":48180},{"$f":"(U$37*($H$20-IF(U$88>0,$H$22,0)-IF(U$89>0,$H$23,0))*U$29/1000)","v":48180}]
[null,null,"Energy usage power level 1",null,null,null,null,"kWh",{"$f":"(I$38*$H$22*I$29)/1000","v":54750},{"$f":"(J$38*$H$22*J$29)/1000","v":43800},43800,18250,36500,18250,14600,54750,43800,28105,25550,18250,18250]
[null,null,"Energy usage power level 2",null,null,null,null,"kWh",{"$f":"(I$39*$H$23*I$29)/1000","v":170625},{"$f":"(J$39*$H$23*J$29)/1000","v":136500},{"$f":"(K$39*$H$23*K$29)/1000","v":79625},{"$f":"(L$39*$H$23*L$29)/1000","v":56875},{"$f":"(M$39*$H$23*M$29)/1000","v":113750},{"$f":"(N$39*$H$23*N$29)/1000","v":56875},{"$f":"(O$39*$H$23*O$29)/1000","v":45500},{"$f":"(P$39*$H$23*P$29)/1000","v":170625},{"$f":"(Q$39*$H$23*Q$29)/1000","v":136500},{"$f":"(R$39*$H$23*R$29)/1000","v":56875},{"$f":"(S$39*$H$23*S$29)/1000","v":56875},{"$f":"(T$39*$H$23*T$29)/1000","v":56875},{"$f":"(U$39*$H$23*U$29)/1000","v":56875}]
[null,null,"Energy usage/year",null,null,null,null,"kWh/year",{"$f":"(I$87+I$88+I$89)","v":307500},{"$f":"(J$87+J$88+J$89)","v":262425},205550,113450,205000,129875,103900,307500,246000,138087.5,130605,123305,123305]
[null,null,"Energy costs per year",null,null,null,null,"€/year",{"$f":"I$90*$H$17","v":36900},{"$f":"J$90*$H$17","v":31491},{"$f":"K$90*$H$17","v":24666},{"$f":"L$90*$H$17","v":13614},{"$f":"M$90*$H$17","v":24600},{"$f":"N$90*$H$17","v":15585},{"$f":"O$90*$H$17","v":12468},{"$f":"P$90*$H$17","v":36900},{"$f":"Q$90*$H$17","v":29520},{"$f":"R$90*$H$17","v":16570.5},{"$f":"S$90*$H$17","v":15672.599999999999},{"$f":"T$90*$H$17","v":14796.599999999999},{"$f":"U$90*$H$17","v":14796.599999999999}]
[null,null,"Factor for present value",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":30.558936077386107},{"$f":"IF($H$16=$H$18,$H$15,(1/($H$16-$H$18))*(1-((1+$H$18)/(1+$H$16))^$H$15))","v":30.558936077386107},30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107,30.558936077386107]
[null,null,"Energikostnader under hela livslängden",null,null,null,null,"€",{"$f":"I91*I92","v":1127624.7412555474},962331.45601296588,753766.71728480572,416029.35575753445,{"$f":"M91*M92","v":751749.8275036983},476261.01876606251,{"$f":"O91*O92","v":381008.81501284998},1127624.7412555474,{"$f":"Q91*Q92","v":902099.79300443793},506376.85027032648,{"$f":"S91*S92","v":478937.98156644148},452168.35356265126,{"$f":"U91*U92","v":452168.35356265126}]
[]
[null,null,"MAINTENANCE AND RE-INVESTMENT COSTS"]
[null,null,"Annual maintenance costs light sources",null,null,null,null,"€/year",{"$f":"IF(I$43>0,(((I$41+I$42)*I$29)/(I$43/$H$20)),0)","v":9877.2727272727261},{"$f":"IF(J$43>0,(((J$41+J$42)*J$29)/(J$43/$H$20)),0)","v":9877.2727272727261},9877.2727272727261,{"$f":"IF(L$43>0,(((L$41+L$42)*L$29)/(L$43/$H$20)),0)","v":9877.2727272727261},11849,11849,11849,11849,11849,11848.763024739505,11848.526058957643,11848.289102653842,11848.052155827534]
[null,null,"Annual maintenance costs electrical ballast",null,null,null,null,"€/year",{"$f":"IF(I$46>0,(((I$44+I$45)*I$29)/(I$46/$H$20)),0)","v":6380.625},{"$f":"IF(J$46>0,(((J$44+J$45)*J$29)/(J$46/$H$20)),0)","v":6380.625},6380.625,{"$f":"IF(L$46>0,(((L$44+L$45)*L$29)/(L$46/$H$20)),0)","v":6380.625},10209,10209,10209,10209,10209,10209,10209,10208.795824083518,10208.591656333747]
[null,null,"Annual costs inspection",null,null,null,null,"€/year",{"$f":"IF(I50>0,(I$49*I$29)/I$50,0)","v":5800},{"$f":"IF(J50>0,(J$49*J$29)/J$50,0)","v":5800},{"$f":"IF(K50>0,(K$49*K$29)/K$50,0)","v":5800},{"$f":"IF(L50>0,(L$49*L$29)/L$50,0)","v":5800},{"$f":"IF(M50>0,(M$49*M$29)/M$50,0)","v":5800},{"$f":"IF(N50>0,(N$49*N$29)/N$50,0)","v":5800},{"$f":"IF(O50>0,(O$49*O$29)/O$50,0)","v":5800},{"$f":"IF(P50>0,(P$49*P$29)/P$50,0)","v":5800},{"$f":"IF(Q50>0,(Q$49*Q$29)/Q$50,0)","v":5800},{"$f":"IF(R50>0,(R$49*R$29)/R$50,0)","v":5800},{"$f":"IF(S50>0,(S$49*S$29)/S$50,0)","v":5800},{"$f":"IF(T50>0,(T$49*T$29)/T$50,0)","v":5800},{"$f":"IF(U50>0,(U$49*U$29)/U$50,0)","v":5800}]
[null,null,"Annual costs surveillance",null,null,null,null,"€/year",{"$f":"IF(I$52>0,(I$51*I$29)/I$52,0)","v":250},{"$f":"IF(J$52>0,(J$51*J$29)/J$52,0)","v":250},250,{"$f":"IF(L$52>0,(L$51*L$29)/L$52,0)","v":250},250,250,250,250,250,250,250,250,250]
[null,null,"Sum of annual maintenace costs",null,null,null,null,"€/year",{"$f":"SUM(I96:I99)","v":22307.897727272728},22307.897727272728,22307.897727272728,22307.897727272728,28108,28108,28108,28108,28108,28107.763024739506,28107.526058957643,28107.08492673736,{"$f":"SUM(U96:U99)","v":28106.643812161281}]
[null,null,"Factor for present value",null,null,null,null,null,{"$f":"(1/$H$16)*(1-((1/(1+$H$16))^$H$15))","v":23.185849343073166},{"$f":"(1/$H$16)*(1-((1/(1+$H$16))^$H$15))","v":23.185849343073166},23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166,23.185849343073166]
[null,null,"Re-investment costs during usage time"]
[null,null,"Re-investment costs luminaires (present value)",null,null,null,null,"EURO",{"$f":"IF(I$47<$H$15,(((I$30+I$31)*I$29)/(1+$H$16)^I$47),0)","v":0},{"$f":"IF(J$47<$H$15,(((J$30+J$31)*J$29)/((1+$H$16)^J$47)),0)","v":0},{"$f":"IF(K$47<$H$15,(((K$30+K$31)*K$29)/((1+$H$16)^K47)),0)","v":0},{"$f":"IF(L$47<$H$15,(((L$30+L$31)*L$29)/((1+$H$16)^L47)),0)","v":0},{"$f":"IF(M$47<$H$15,(((M$30+M$31)*M$29)/((1+$H$16)^M47)),0)","v":0},{"$f":"IF(N$47<$H$15,(((N$30+N$31)*N$29)/((1+$H$16)^N47)),0)","v":0},{"$f":"IF(O$47<$H$15,(((O$30+O$31)*O$29)/((1+$H$16)^O47)),0)","v":0},{"$f":"IF(P$47<$H$15,(((P$30+P$31)*P$29)/((1+$H$16)^P47)),0)","v":0},{"$f":"IF(Q$47<$H$15,(((Q$30+Q$31)*Q$29)/((1+$H$16)^Q47)),0)","v":0},{"$f":"IF(R$47<$H$15,(((R$30+R$31)*R$29)/((1+$H$16)^R47)),0)","v":0},{"$f":"IF(S$47<$H$15,(((S$30+S$31)*S$29)/((1+$H$16)^S47)),0)","v":0},{"$f":"IF(T$47<$H$15,(((T$30+T$31)*T$29)/((1+$H$16)^T47)),0)","v":0},{"$f":"IF(U$47<$H$15,(((U$30+U$31)*U$29)/((1+$H$16)^U47)),0)","v":0}]
[null,null,"Re-investment costs poles (present value)",null,null,null,null,"EURO",{"$f":"IF(I$48<$H$15,(((I$33+I$34)*I$32)/(1+$H$16)^I$48),0)","v":0},{"$f":"IF(J$48<$H$15,(((J$33+J$34)*J$32)/(1+$H$16)^J$48),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Maintenance and re-investment costs during entire usage time",null,null,null,null,"EURO",{"$f":"(I100*I101)+I103+I104","v":517227.55586522975},{"$f":"(J100*J101)+J103+J104","v":517227.55586522975},517227.55586522975,517227.55586522975,{"$f":"(M100*M101)+M103+M104","v":651707.85333510058},651707.85333510058,{"$f":"(O100*O101)+O103+O104","v":651707.85333510058},651707.85333510058,{"$f":"(Q100*Q101)+Q103+Q104","v":651707.85333510058},651702.35886241274,{"$f":"(S100*S101)+S103+S104","v":651696.86460949492},651686.63658429508,{"$f":"(U100*U101)+U103+U104","v":651676.40896819113}]
[]
[null,null,"SUM OF ENERGY AND MAINTENANCE COSTS",null,null,null,null,"EURO",{"$f":"I93+I105","v":1644852.2971207772},1479559.0118781957,1270994.2731500354,933256.91162276419,1403457.6808387989,1127968.872101163,1032716.6683479506,1779332.5945906481,1553807.6463395385,1158079.2091327393,1130634.8461759365,1103854.9901469464,1103844.7625308423]
[null,null,"TOTAL COST",null,null,null,null,"EURO",{"$f":"IF((I82+I107)>0,(I82+I107),\"\")","v":3925352.297120777},3760059.0118781957,3551494.2731500352,3213756.9116227641,3925457.6808387991,3649968.872101163,3554716.6683479506,4301332.5945906481,4075807.6463395385,3680079.2091327393,3652634.8461759365,3625854.9901469462,3626344.7625308423]
[null,null,"Energy cost savings per year compared to current facility",null,null,null,null,"EURO",null,{"$f":"IFERROR($I$91-J91,\"\")","v":5409},{"$f":"IFERROR($I$91-K91,\"\")","v":12234},{"$f":"IFERROR($I$91-L91,\"\")","v":23286},{"$f":"IFERROR($I$91-M91,\"\")","v":12300},{"$f":"IFERROR($I$91-N91,\"\")","v":21315},{"$f":"IFERROR($I$91-O91,\"\")","v":24432},{"$f":"IFERROR($I$91-P91,\"\")","v":0},{"$f":"IFERROR($I$91-Q91,\"\")","v":7380},{"$f":"IFERROR($I$91-R91,\"\")","v":20329.5},{"$f":"IFERROR($I$91-S91,\"\")","v":21227.4},{"$f":"IFERROR($I$91-T91,\"\")","v":22103.4},{"$f":"IFERROR($I$91-U91,\"\")","v":22103.4}]
[null,null,"LIGTH POLLUTION"]
[null,null,"LIGHTING EFICIENCY",null,null,null,null,"Lum/W",{"$f":"I54","v":120},{"$f":"J54","v":120},120,100,95,95,147,113,147,113,147,113,113]
[null,null,"Lumen output per street light full power",null,null,null,null,"Lumen",{"$f":"I37*I$111","v":18000},{"$f":"J37*J$111","v":18000},{"$f":"K37*K$111","v":18000},{"$f":"L37*L$111","v":7000},{"$f":"M37*M$111","v":9500},{"$f":"N37*N$111","v":9500},{"$f":"O37*O$111","v":11760},{"$f":"P37*P$111","v":16950},{"$f":"Q37*Q$111","v":17640},{"$f":"R37*R$111","v":10961},{"$f":"S37*S$111","v":12936},{"$f":"T37*T$111","v":9944},{"$f":"U37*U$111","v":9944}]
[null,null,"Lumen output per street light level 1",null,null,null,null,"Lumen",{"$f":"I38*I$111","v":18000},{"$f":"J38*J$111","v":14400},{"$f":"K38*K$111","v":14400},{"$f":"L38*L$111","v":5000},{"$f":"M38*M$111","v":9500},{"$f":"N38*N$111","v":4750},{"$f":"O38*O$111","v":5880},{"$f":"P38*P$111","v":16950},{"$f":"Q38*Q$111","v":17640},{"$f":"R38*R$111","v":8701},{"$f":"S38*S$111","v":10290},{"$f":"T38*T$111","v":5650},{"$f":"U38*U$111","v":5650}]
[null,null,"Lumen output per street light level 2",null,null,null,null,"Lumen",{"$f":"I39*I$111","v":18000},{"$f":"J39*J$111","v":14400},{"$f":"K39*K$111","v":8400},{"$f":"L39*L$111","v":5000},{"$f":"M39*M$111","v":9500},{"$f":"N39*N$111","v":4750},{"$f":"O39*O$111","v":5880},{"$f":"P39*P$111","v":16950},{"$f":"Q39*Q$111","v":17640},{"$f":"R39*R$111","v":5650},{"$f":"S39*S$111","v":7350},{"$f":"T39*T$111","v":5650},{"$f":"U39*U$111","v":5650}]
[null,null,"Lumens emited in life time",null,null,null,null,"Glmh",{"$f":"((I112*$H$21+I113*$H$22+I114*$H$23)*30)/1000000000","v":2.214},{"$f":"((J112*$H$21+J113*$H$22+J114*$H$23)*30)/1000000000","v":1.8894599999999999},{"$f":"((K112*$H$21+K113*$H$22+K114*$H$23)*30)/1000000000","v":1.4799599999999999},{"$f":"((L112*$H$21+L113*$H$22+L114*$H$23)*30)/1000000000","v":0.68069999999999997},{"$f":"((M112*$H$21+M113*$H$22+M114*$H$23)*30)/1000000000","v":1.1685000000000001},{"$f":"((N112*$H$21+N113*$H$22+N114*$H$23)*30)/1000000000","v":0.74028749999999999},{"$f":"((O112*$H$21+O113*$H$22+O114*$H$23)*30)/1000000000","v":0.91639800000000005},{"$f":"((P112*$H$21+P113*$H$22+P114*$H$23)*30)/1000000000","v":2.0848499999999999},{"$f":"((Q112*$H$21+Q113*$H$22+Q114*$H$23)*30)/1000000000","v":2.1697199999999999},{"$f":"((R112*$H$21+R113*$H$22+R114*$H$23)*30)/1000000000","v":0.93623325000000002},{"$f":"((S112*$H$21+S113*$H$22+S114*$H$23)*30)/1000000000","v":1.1519360999999999},{"$f":"((T112*$H$21+T113*$H$22+T114*$H$23)*30)/1000000000","v":0.83600790000000003},{"$f":"((U112*$H$21+U113*$H$22+U114*$H$23)*30)/1000000000","v":0.83600790000000003}]
[null,null,"CCT",null,null,null,null,"K",2200,2200,2200,2200,{"$f":"M53","v":3000},{"$f":"N53","v":3000},{"$f":"O53","v":3000},{"$f":"P53","v":3000},{"$f":"Q53","v":4000},{"$f":"R53","v":3000},{"$f":"S53","v":4000},{"$f":"T53","v":1800},{"$f":"U53","v":2200}]
[null,null,"Ratio G/R",null,null,null,null,"ADU",{"$f":"0.000000000001438*T^3-0.00000004555*T^2+0.0004093*T- 0.336","v":0.35930982399999994},{"$f":"0.000000000001438*J116^3-0.00000004555*J116^2+0.0004093*J116- 0.336","v":0.35930982399999994},{"$f":"0.000000000001438*K116^3-0.00000004555*K116^2+0.0004093*K116- 0.336","v":0.35930982399999994},0.35930982399999994,0.52077599999999991,0.52077599999999991,0.52077599999999991,0.52077599999999991,0.66443199999999991,0.52077599999999991,0.66443199999999991,0.26154441599999995,{"$f":"0.000000000001438*U116^3-0.00000004555*U116^2+0.0004093*U116- 0.336","v":0.35930982399999994}]
[null,null,"Ratio B/G",null,null,null,null,"ADU",{"$f":"0.000000000008061*T^3-0.0000001109*T^2 + 0.0005976*T - 0.6528","v":0.21099752799999982},{"$f":"0.000000000008061*J116^3-0.0000001109*J116^2 + 0.0005976*J116 - 0.6528","v":0.21099752799999982},{"$f":"0.000000000008061*K116^3-0.0000001109*K116^2 + 0.0005976*K116 - 0.6528","v":0.21099752799999982},0.21099752799999982,0.35954699999999984,0.35954699999999984,0.35954699999999984,0.35954699999999984,0.47910399999999997,0.35954699999999984,0.47910399999999997,0.11057575199999992,{"$f":"0.000000000008061*U116^3-0.0000001109*U116^2 + 0.0005976*U116 - 0.6528","v":0.21099752799999982}]
[null,null,"Ratio V(λ)/G",null,null,null,null,"Lm/W",{"$f":"-0.0000000000257*T^3 + 0.0000003866*T^2 - 0.001909*T + 4.273","v":1.6706903999999989},{"$f":"-0.0000000000257*J116^3 + 0.0000003866*J116^2 - 0.001909*J116 + 4.273","v":1.6706903999999989},{"$f":"-0.0000000000257*K116^3 + 0.0000003866*K116^2 - 0.001909*K116 + 4.273","v":1.6706903999999989},1.6706903999999989,1.3314999999999992,1.3314999999999992,1.3314999999999992,1.3314999999999992,1.1777999999999995,1.3314999999999992,1.1777999999999995,1.9395015999999989,{"$f":"-0.0000000000257*U116^3 + 0.0000003866*U116^2 - 0.001909*U116 + 4.273","v":1.6706903999999989}]
[null,null,"Blue light per lumen***",null,null,null,null,"W/lm",{"$f":"I124*I118","v":1.8491012255643672E-4},{"$f":"J124*J118","v":1.8491012255643672E-4},1.8491012255643672E-4,1.8491012255643672E-4,3.953609712622793E-4,3.953609712622793E-4,3.953609712622793E-4,3.953609712622793E-4,5.9557648612558315E-4,3.953609712622793E-4,5.9557648612558315E-4,8.3473583046806004E-5,{"$f":"U124*U118","v":1.8491012255643672E-4}]
[null,null,"Blue light emited per street light at full power",null,null,null,null,"W/sr m2",{"$f":"I125*I$118","v":3.3283822060158612},{"$f":"J125*J$118","v":3.3283822060158612},3.3283822060158612,1.294370857895057,3.7559292269916531,3.7559292269916531,4.6494450220444046,6.7013684628956334,10.505969215255288,4.3335516060058428,7.7043774245205432,0.83006130981743886,{"$f":"U125*U$118","v":1.8387462587012067}]
[null,null,"Blue light emited per street light at level 1",null,null,null,null,"W/sr m2",{"$f":"I126*I$118","v":3.3283822060158612},{"$f":"J126*J$118","v":2.6627057648126891},2.6627057648126891,0.92455061278218365,3.7559292269916531,1.8779646134958266,2.3247225110222023,6.7013684628956334,10.505969215255288,3.4400358109530917,6.1284820422322506,0.47162574421445397,{"$f":"U126*U$118","v":1.0447421924438676}]
[null,null,"Blue light emited per street light at level 2",null,null,null,null,"W/sr m2",{"$f":"I127*I$118","v":3.3283822060158612},2.6627057648126891,1.5532450294740685,0.92455061278218365,3.7559292269916531,1.8779646134958266,2.3247225110222023,6.7013684628956334,10.505969215255288,2.2337894876318778,4.3774871730230362,0.47162574421445397,{"$f":"U127*U$118","v":1.0447421924438676}]
[null,null,"Green light per lumen***",null,null,null,null,"W/lm",{"$f":"1/I119/683","v":8.7636155887303518E-4},{"$f":"1/J119/683","v":8.7636155887303518E-4},8.7636155887303518E-4,8.7636155887303518E-4,1.0996085943208523E-3,1.0996085943208523E-3,1.0996085943208523E-3,1.0996085943208523E-3,1.2431048084039858E-3,1.0996085943208523E-3,1.2431048084039858E-3,7.5489952848619172E-4,{"$f":"1/U119/683","v":8.7636155887303518E-4}]
[null,null,"Green light emited per street light at full power",null,null,null,null,"W/sr m2",{"$f":"I112*I$124","v":15.774508059714634},{"$f":"J112*J$124","v":15.774508059714634},15.774508059714634,6.1345309121112459,10.446281646048096,10.446281646048096,12.931397069213222,18.638365673738445,21.928368820246309,12.052809802350861,16.080803801513959,7.5067209112666902,{"$f":"U112*U$124","v":8.7145393414334613}]
[null,null,"Green light emited per street light at level 1",null,null,null,null,"W/sr m2",{"$f":"I113*I$124","v":15.774508059714634},{"$f":"J113*J$124","v":12.619606447771707},12.619606447771707,4.3818077943651756,10.446281646048096,5.2231408230240479,6.4656985346066111,18.638365673738445,21.928368820246309,9.5676943791857347,12.791548478477013,4.2651823359469834,{"$f":"U113*U$124","v":4.9514428076326489}]
[null,null,"Green light emited per street light at level 2",null,null,null,null,"W/sr m2",{"$f":"I114*I$124","v":15.774508059714634},12.619606447771707,7.3614370945334953,4.3818077943651756,10.446281646048096,5.2231408230240479,6.4656985346066111,18.638365673738445,21.928368820246309,6.2127885579128153,9.1368203417692957,4.2651823359469834,{"$f":"U114*U$124","v":4.9514428076326489}]
[null,null,"Red light per lumen***",null,null,null,null,"W/lm",{"$f":"1/I117*I124","v":2.43901363207101E-3},{"$f":"1/J117*J124","v":2.43901363207101E-3},2.43901363207101E-3,2.43901363207101E-3,2.1114809329171322E-3,2.1114809329171322E-3,2.1114809329171322E-3,2.1114809329171322E-3,1.8709285651563831E-3,2.1114809329171322E-3,1.8709285651563831E-3,2.8863148371945815E-3,{"$f":"1/U117*U124","v":2.43901363207101E-3}]
[null,null,"Red light emited per street light at full power",null,null,null,null,"W/sr m2",{"$f":"I112*I$128","v":43.902245377278177},{"$f":"J112*J$128","v":43.902245377278177},43.902245377278177,17.073095424497069,20.059068862712756,20.059068862712756,24.831015771105474,35.789601812945392,33.003179889358599,23.143942505704686,24.202331918862971,28.701514741062919,{"$f":"U112*U$128","v":24.253551557314122}]
[null,null,"Red light emited per street light at level 1",null,null,null,null,"W/sr m2",{"$f":"I113*I$128","v":43.902245377278177},{"$f":"J113*J$128","v":35.121796301822542},35.121796301822542,12.195068160355049,20.059068862712756,10.029534431356378,12.415507885552737,35.789601812945392,33.003179889358599,18.371995597311969,19.251854935459182,16.307678830149385,{"$f":"U113*U$128","v":13.780427021201206}]
[null,null,"Red light emited per street light at level 2",null,null,null,null,"W/sr m2",{"$f":"I114*I$128","v":43.902245377278177},35.121796301822542,20.487714509396483,12.195068160355049,20.059068862712756,10.029534431356378,12.415507885552737,35.789601812945392,33.003179889358599,11.929867270981797,13.751324953899415,16.307678830149385,{"$f":"U114*U$128","v":13.780427021201206}]
[null,null,"ULOR (Check note)",null,null,null,null,"%",{"$f":"IF(I56=\"Rural\",I55,I55/2)","v":0.05},{"$f":"IF(J56=\"Rural\",J55,J55/2)","v":0.05},0.05,0.05,0,0,0,0,0,0,0,0,{"$f":"IF(U56=\"Rural\",U55,U55/2)","v":0}]
[null,null,"Reflectance asfalt",null,null,null,null,"%",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,null,"Reflectance snow",null,null,null,null,"%",0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,null,"Light emited to the street Full power one street light",null,null,null,null,"Lumen",{"$f":"I112*(1-I$132)","v":17100},{"$f":"J112*(1-J$132)","v":17100},17100,6650,9500,9500,11760,16950,17640,10961,12936,9944,{"$f":"U112*(1-U$132)","v":9944}]
[null,null,"Light emitedto the street asfalt Level 1 one street light",null,null,null,null,"Lumen",{"$f":"I113*(1-I$132)","v":17100},{"$f":"J113*(1-J$132)","v":13680},13680,4750,9500,4750,5880,16950,17640,8701,10290,5650,{"$f":"U113*(1-U$132)","v":5650}]
[null,null,"Light emited to the street asfalt Level 2 one street light",null,null,null,null,"Lumen",{"$f":"I114*(1-I$132)","v":17100},13680,7980,4750,9500,4750,5880,16950,17640,5650,7350,5650,{"$f":"U114*(1-U$132)","v":5650}]
[null,null,"Light emited to the space asfalt Full power one street light",null,null,null,null,"Lumen",{"$f":"I112*I$132+I112*(1-I$132)*I$133","v":2610},{"$f":"J112*J$132+J112*(1-J$132)*J$133","v":2610},2610,1015,950,950,1176,1695,1764,1096.1000000000001,1293.6000000000001,994.40000000000009,{"$f":"U112*U$132+U112*(1-U$132)*U$133","v":994.40000000000009}]
[null,null,"Light emited to the space asfalt Level 1 one street light",null,null,null,null,"Lumen",{"$f":"I113*I$132+I113*(1-I$132)*I$133","v":2610},{"$f":"J113*J$132+J113*(1-J$132)*J$133","v":2088},2088,725,950,475,588,1695,1764,870.1,1029,565,{"$f":"U113*U$132+U113*(1-U$132)*U$133","v":565}]
[null,null,"Light emited to the space asfalt Level 2 one street light",null,null,null,null,"Lumen",{"$f":"I114*I$132+I114*(1-I$132)*I$133","v":2610},{"$f":"J114*J$132+J114*(1-J$132)*J$133","v":2088},1218,725,950,475,588,1695,1764,565,735,565,{"$f":"U114*U$132+U114*(1-U$132)*U$133","v":565}]
[null,null,"Light emited to the space snow Full power one street light",null,null,null,null,"Lumen",{"$f":"I112*I$132+I112*(1-I$132)*I$134","v":16290},{"$f":"J112*J$132+J112*(1-J$132)*J$134","v":16290},16290,6335,8550,8550,10584,15255,15876,9864.9,11642.4,8949.6,{"$f":"U112*U$132+U112*(1-U$132)*U$134","v":8949.6}]
[null,null,"Light emited to the space  snow Level 1 one street light",null,null,null,null,"Lumen",{"$f":"I113*I$132+I113*(1-I$132)*I$134","v":16290},{"$f":"J113*J$132+J113*(1-J$132)*J$134","v":13032},13032,4525,8550,4275,5292,15255,15876,7830.9000000000005,9261,5085,{"$f":"U113*U$132+U113*(1-U$132)*U$134","v":5085}]
[null,null,"Light emited to the space snow Level 2 one street light",null,null,null,null,"Lumen",{"$f":"I114*I$132+I114*(1-I$132)*I$134","v":16290},{"$f":"J114*J$132+J114*(1-J$132)*J$134","v":13032},7602,4525,8550,4275,5292,15255,15876,5085,6615,5085,{"$f":"U114*U$132+U114*(1-U$132)*U$134","v":5085}]
[null,null,"Blue light emited per street light at full power asfalt",null,null,null,null,"W/sr m2",{"$f":"I147*I$118","v":329.62633177278082},{"$f":"J147*J$118","v":329.62633177278082},329.62633177278082,128.18801791163699,256.52996620352985,256.52996620352985,317.55709500563279,457.70346601577177,717.55769740193614,295.98157469019907,526.20897809475321,56.693187460531092,{"$f":"U147*U$118","v":125.58636946929245}]
[null,null,"Blue light emited per street light at level 1 asfalt",null,null,null,null,"W/sr m2",{"$f":"I148*I$118","v":329.62633177278082},{"$f":"J148*J$118","v":263.70106541822463},263.70106541822463,91.562869936883558,256.52996620352985,128.26498310176493,158.77854750281639,457.70346601577177,717.55769740193614,234.95444588809619,418.57532348446273,32.212038329847211,{"$f":"U148*U$118","v":71.35589174391616}]
[null,null,"Blue light emited per street light at level 2 asfalt",null,null,null,null,"W/sr m2",{"$f":"I149*I$118","v":329.62633177278082},263.70106541822463,153.82562149396438,91.562869936883558,256.52996620352985,128.26498310176493,158.77854750281639,457.70346601577177,717.55769740193614,152.56782200525723,298.98237391747335,32.212038329847211,{"$f":"U149*U$118","v":71.35589174391616}]
[null,null,"Green light emited per street light at full power asfalt",null,null,null,null,"W/sr m2",{"$f":"I138/I$119","v":1562.2284056938388},{"$f":"J138/J$119","v":1562.2284056938388},1562.2284056938388,607.53326888093727,713.48103642508488,713.48103642508488,883.21441982726299,1273.0003755163357,1497.7075904228229,823.20690950056382,1098.3188996434035,512.70903823951505,{"$f":"U138/U$119","v":595.20303701990554}]
[null,null,"Green light emited per street light at level 1 asfalt",null,null,null,null,"W/sr m2",{"$f":"I139/I$119","v":1562.2284056938388},{"$f":"J139/J$119","v":1249.7827245550709},1249.7827245550709,433.9523349149552,713.48103642508488,356.74051821254244,441.60720991363149,1273.0003755163357,1497.7075904228229,653.47352609838572,873.66276107997999,291.31195354517899,{"$f":"U139/U$119","v":338.18354376130992}]
[null,null,"Green light emited per street light at level 2 asfalt",null,null,null,null,"W/sr m2",{"$f":"I140/I$119","v":1562.2284056938388},1249.7827245550709,729.03992265712475,433.9523349149552,713.48103642508488,356.74051821254244,441.60720991363149,1273.0003755163357,1497.7075904228229,424.33345850544521,624.04482934284283,291.31195354517899,{"$f":"U140/U$119","v":338.18354376130992}]
[null,null,"Red light emited per street light at full power asfalt",null,null,null,null,"W/sr m2",{"$f":"I147/I$117","v":4347.858870938745},{"$f":"J147/J$117","v":4347.858870938745},4347.858870938745,1690.8340053650672,1370.0344033232811,1370.0344033232811,1695.9583771665036,2444.42980382417,2254.1171864431922,1580.73127313963,1653.0192700583409,1960.3134568145977,{"$f":"U147/U$117","v":1656.5175713645549}]
[null,null,"Red light emited per street light at level 1 asfalt",null,null,null,null,"W/sr m2",{"$f":"I148/I$117","v":4347.858870938745},{"$f":"J148/J$117","v":3478.2870967509953},3478.2870967509953,1207.7385752607624,1370.0344033232811,685.01720166164057,847.97918858325181,2444.42980382417,2254.1171864431922,1254.8072992964073,1314.9016920918621,1113.8144640992032,{"$f":"U148/U$117","v":941.20316554804242}]
[null,null,"Red light emited per street light at level 2 asfalt",null,null,null,null,"W/sr m2",{"$f":"I149/I$117","v":4347.858870938745},3478.2870967509953,2029.0008064380806,1207.7385752607624,1370.0344033232811,685.01720166164057,847.97918858325181,2444.42980382417,2254.1171864431922,814.80993460805655,939.21549435132999,1113.8144640992032,{"$f":"U149/U$117","v":941.20316554804242}]
[null,null,"Blue light emited per street light at full power snow",null,null,null,null,"W/sr m2",{"$f":"I156*I$118","v":2057.3229672714942},{"$f":"J156*J$118","v":2057.3229672714942},2057.3229672714942,800.07004282780326,2308.7696958317692,2308.7696958317692,2858.0138550506949,4119.3311941419461,6458.019276617425,2663.8341722117916,4735.8808028527774,510.23868714477976,{"$f":"U156*U$118","v":1130.277325223632}]
[null,null,"Blue light emited per street light at level 1 snow",null,null,null,null,"W/sr m2",{"$f":"I157*I$118","v":2057.3229672714942},{"$f":"J157*J$118","v":1645.8583738171953},1645.8583738171953,571.47860201985952,2308.7696958317692,1154.3848479158846,1429.0069275253475,4119.3311941419461,6458.019276617425,2114.5900129928655,3767.1779113601642,289.90834496862487,{"$f":"U157*U$118","v":642.2030256952454}]
[null,null,"Blue light emited per street light at level 2 snow",null,null,null,null,"W/sr m2",{"$f":"I158*I$118","v":2057.3229672714942},{"$f":"J158*J$118","v":1645.8583738171953},960.08405139336401,571.47860201985952,2308.7696958317692,1154.3848479158846,1429.0069275253475,4119.3311941419461,6458.019276617425,1373.1103980473151,2690.8413652572599,289.90834496862487,{"$f":"U158*U$118","v":642.2030256952454}]
[null,null,"Green light emited per street light at full power snow",null,null,null,null,"W/sr m2",{"$f":"I141/I$119","v":9750.4600493305115},{"$f":"J141/J$119","v":9750.4600493305115},9750.4600493305115,3791.8455747396429,6421.3293278257643,6421.3293278257643,7948.9297784453665,11457.003379647022,13479.368313805406,7408.8621855050733,9884.8700967906298,4614.3813441556349,{"$f":"U141/U$119","v":5356.8273331791497}]
[null,null,"Green light emited per street light at level 1 snow",null,null,null,null,"W/sr m2",{"$f":"I142/I$119","v":9750.4600493305115},{"$f":"J142/J$119","v":7800.3680394644089},7800.3680394644089,2708.4611248140309,6421.3293278257643,3210.6646639128821,3974.4648892226833,11457.003379647022,13479.368313805406,5881.261734885471,7862.9648497198195,2621.8075819066107,{"$f":"U142/U$119","v":3043.6518938517893}]
[null,null,"Green light emited per street light at level 2 snow",null,null,null,null,"W/sr m2",{"$f":"I143/I$119","v":9750.4600493305115},7800.3680394644089,4550.214689687572,2708.4611248140309,6421.3293278257643,3210.6646639128821,3974.4648892226833,11457.003379647022,13479.368313805406,3819.001126549007,5616.4034640855853,2621.8075819066107,{"$f":"U143/U$119","v":3043.6518938517893}]
[null,null,"Red light emited per street light at full power snow",null,null,null,null,"W/sr m2",{"$f":"I156/I$117","v":27136.636401376305},{"$f":"J156/J$117","v":27136.636401376305},27136.636401376305,10553.136378313005,12330.30962990953,12330.30962990953,15263.625394498533,21999.868234417529,20287.05467798873,14226.581458256669,14877.173430525067,17642.821111331377,{"$f":"U156/U$117","v":14908.658142280992}]
[null,null,"Red light emited per street light at level 1 snow",null,null,null,null,"W/sr m2",{"$f":"I157/I$117","v":27136.636401376305},{"$f":"J157/J$117","v":21709.309121101043},21709.309121101043,7537.9545559378621,12330.30962990953,6165.1548149547652,7631.8126972492664,21999.868234417529,20287.05467798873,11293.265693667665,11834.115228826759,10024.330176892827,{"$f":"U157/U$117","v":8470.8284899323808}]
[null,null,"Red light emited per street light at level 2 snow",null,null,null,null,"W/sr m2",{"$f":"I158/I$117","v":27136.636401376305},21709.309121101043,12663.763653975608,7537.9545559378621,12330.30962990953,6165.1548149547652,7631.8126972492664,21999.868234417529,20287.05467798873,7333.2894114725095,8452.9394491619696,10024.330176892827,{"$f":"U158/U$117","v":8470.8284899323808}]
[null,"TOTAL LIGHT POLLUTION per level"]
[null,null,"Blue light emited per street light at full power asfalt",null,null,null,null,"W/sr m2",{"$f":"I144*I$70","v":164813.1658863904},{"$f":"J144*J$70","v":164813.1658863904},164813.1658863904,64094.008955818492,128264.98310176493,128264.98310176493,158778.54750281639,228851.73300788589,358778.84870096808,147990.78734509952,263104.48904737661,28346.593730265547,{"$f":"U144*U$70","v":62793.184734646224}]
[null,null,"Blue light emited per instalation at level 1 asfalt",null,null,null,null,"W/sr m2",{"$f":"I145*I$70","v":164813.1658863904},131850.5327091123,131850.5327091123,45781.434968441776,128264.98310176493,64132.491550882463,79389.273751408196,228851.73300788589,358778.84870096808,117477.22294404809,209287.66174223137,16106.019164923606,{"$f":"U145*U$70","v":35677.94587195808}]
[null,null,"Blue light emited per instalation at level 2 asfalt",null,null,null,null,"W/sr m2",{"$f":"I146*I$70","v":164813.1658863904},131850.5327091123,76912.810746982184,45781.434968441776,128264.98310176493,64132.491550882463,79389.273751408196,228851.73300788589,358778.84870096808,76283.911002628607,149491.18695873668,16106.019164923606,{"$f":"U146*U$70","v":35677.94587195808}]
[null,null,"Green light emited per instalation at full power asfalt",null,null,null,null,"W/sr m2",{"$f":"I147*I$70","v":781114.20284691942},781114.20284691942,781114.20284691942,303766.63444046862,356740.51821254246,356740.51821254246,441607.20991363149,636500.18775816786,748853.79521141143,411603.45475028193,549159.44982170174,256354.51911975752,{"$f":"U147*U$70","v":297601.51850995276}]
[null,null,"Green light emited per instalation at level 1 asfalt",null,null,null,null,"W/sr m2",{"$f":"I148*I$70","v":781114.20284691942},624891.36227753549,624891.36227753549,216976.1674574776,356740.51821254246,178370.25910627123,220803.60495681575,636500.18775816786,748853.79521141143,326736.76304919284,436831.38053998997,145655.97677258949,{"$f":"U148*U$70","v":169091.77188065497}]
[null,null,"Green light emited per instalation at level 2 asfalt",null,null,null,null,"W/sr m2",{"$f":"I149*I$70","v":781114.20284691942},624891.36227753549,364519.96132856235,216976.1674574776,356740.51821254246,178370.25910627123,220803.60495681575,636500.18775816786,748853.79521141143,212166.72925272261,312022.4146714214,145655.97677258949,{"$f":"U149*U$70","v":169091.77188065497}]
[null,null,"Red light emited per instalation at full power asfalt",null,null,null,null,"W/sr m2",{"$f":"I150*I$70","v":2173929.4354693727},2173929.4354693727,2173929.4354693727,845417.00268253358,685017.20166164055,685017.20166164055,847979.18858325179,1222214.901912085,1127058.593221596,790365.63656981499,826509.63502917043,980156.7284072988,{"$f":"U150*U$70","v":828258.7856822774}]
[null,null,"Red light emited per instalation at level 1 asfalt",null,null,null,null,"W/sr m2",{"$f":"I151*I$70","v":2173929.4354693727},1739143.5483754976,1739143.5483754976,603869.28763038118,685017.20166164055,342508.60083082027,423989.59429162589,1222214.901912085,1127058.593221596,627403.64964820363,657450.84604593099,556907.23204960162,{"$f":"U151*U$70","v":470601.5827740212}]
[null,null,"Red light emited per instalation at level 2 asfalt",null,null,null,null,"W/sr m2",{"$f":"I152*I$70","v":2173929.4354693727},1739143.5483754976,1014500.4032190404,603869.28763038118,685017.20166164055,342508.60083082027,423989.59429162589,1222214.901912085,1127058.593221596,407404.96730402828,469607.74717566499,556907.23204960162,{"$f":"U152*U$70","v":470601.5827740212}]
[null,null,"Blue light emited per instalation at full power snow",null,null,null,null,"W/sr m2",{"$f":"I153*I$70","v":1028661.4836357471},1028661.4836357471,1028661.4836357471,400035.02141390165,1154384.8479158846,1154384.8479158846,1429006.9275253476,2059665.5970709731,3229009.6383087123,1331917.0861058957,2367940.4014263889,255119.34357238989,{"$f":"U153*U$70","v":565138.66261181596}]
[null,null,"Blue light emited per instalation at level 1 snow",null,null,null,null,"W/sr m2",{"$f":"I154*I$70","v":1028661.4836357471},822929.18690859771,822929.18690859771,285739.30100992974,1154384.8479158846,577192.42395794229,714503.46376267378,2059665.5970709731,3229009.6383087123,1057295.0064964327,1883588.9556800821,144954.17248431244,{"$f":"U154*U$70","v":321101.51284762268}]
[null,null,"Blue light emited per instalation at level 2 snow",null,null,null,null,"W/sr m2",{"$f":"I155*I$70","v":1028661.4836357471},822929.18690859771,480042.02569668199,285739.30100992974,1154384.8479158846,577192.42395794229,714503.46376267378,2059665.5970709731,3229009.6383087123,686555.19902365759,1345420.68262863,144954.17248431244,{"$f":"U155*U$70","v":321101.51284762268}]
[null,null,"Green light emited per instalation at full power snow",null,null,null,null,"W/sr m2",{"$f":"I156*I$70","v":4875230.024665256},4875230.024665256,4875230.024665256,1895922.7873698215,3210664.6639128821,3210664.6639128821,3974464.8892226834,5728501.6898235111,6739684.1569027025,3704431.0927525368,4942435.0483953152,2307190.6720778174,{"$f":"U156*U$70","v":2678413.6665895749}]
[null,null,"Green light emited per instalation at level 1 snow",null,null,null,null,"W/sr m2",{"$f":"I157*I$70","v":4875230.024665256},3900184.0197322043,3900184.0197322043,1354230.5624070154,3210664.6639128821,1605332.331956441,1987232.4446113417,5728501.6898235111,6739684.1569027025,2940630.8674427355,3931482.4248599098,1310903.7909533053,{"$f":"U157*U$70","v":1521825.9469258946}]
[null,null,"Green light emited per instalation at level 2 snow",null,null,null,null,"W/sr m2",{"$f":"I158*I$70","v":4875230.024665256},3900184.0197322043,2275107.3448437862,1354230.5624070154,3210664.6639128821,1605332.331956441,1987232.4446113417,5728501.6898235111,6739684.1569027025,1909500.5632745035,2808201.7320427927,1310903.7909533053,{"$f":"U158*U$70","v":1521825.9469258946}]
[null,null,"Red light emited per instalation at full power snow",null,null,null,null,"W/sr m2",{"$f":"I159*I$70","v":13568318.200688152},13568318.200688152,13568318.200688152,5276568.1891565025,6165154.8149547651,6165154.8149547651,7631812.6972492663,10999934.117208764,10143527.338994365,7113290.7291283347,7438586.7152625332,8821410.5556656886,{"$f":"U159*U$70","v":7454329.0711404961}]
[null,null,"Red light emited per instalation at level 1 snow",null,null,null,null,"W/sr m2",{"$f":"I160*I$70","v":13568318.200688152},10854654.560550522,10854654.560550522,3768977.277968931,6165154.8149547651,3082577.4074773826,3815906.3486246332,10999934.117208764,10143527.338994365,5646632.8468338326,5917057.6144133797,5012165.0884464132,{"$f":"U160*U$70","v":4235414.2449661903}]
[null,null,"Red light emited per instalation at level 2 snow",null,null,null,null,"W/sr m2",{"$f":"I161*I$70","v":13568318.200688152},10854654.560550522,6331881.8269878039,3768977.277968931,6165154.8149547651,3082577.4074773826,3815906.3486246332,10999934.117208764,10143527.338994365,3666644.7057362548,4226469.7245809846,5012165.0884464132,{"$f":"U161*U$70","v":4235414.2449661903}]
[null,"TOTAL LIGHT POLLUTION"]
[null,null,"Blue light emited per instalation at full power asfalt",null,null,null,null,"MWh/sr m2",{"$f":"(I163*$H$21+I164*$H$22+I165*$H$23)/1000000","v":675.73398013420058},{"$f":"(J163*$H$21+J164*$H$22+J165*$H$23)/1000000","v":576.68126743647997},{"$f":"(K163*$H$21+K164*$H$22+K165*$H$23)/1000000","v":451.69794997263398},{"$f":"(L163*$H$21+L164*$H$22+L165*$H$23)/1000000","v":207.75615188678879},{"$f":"(M163*$H$21+M164*$H$22+M165*$H$23)/1000000","v":525.88643071723618},{"$f":"(N163*$H$21+N164*$H$22+N165*$H$23)/1000000","v":333.16829360683442},{"$f":"(O163*$H$21+O164*$H$22+O165*$H$23)/1000000","v":412.42727713856561},{"$f":"(P163*$H$21+P164*$H$22+P165*$H$23)/1000000","v":938.29210533233208},{"$f":"(Q163*$H$21+Q164*$H$22+Q165*$H$23)/1000000","v":1470.9932796739693},{"$f":"(R163*$H$21+R164*$H$22+R165*$H$23)/1000000","v":421.35418242301915},{"$f":"(S163*$H$21+S164*$H$22+S165*$H$23)/1000000","v":780.97185890983224},{"$f":"(T163*$H$21+T164*$H$22+T165*$H$23)/1000000","v":79.438107725236208},{"$f":"(U163*$H$21+U164*$H$22+U165*$H$23)/1000000","v":175.97076462967163}]
[null,null,"Green light emited per instalation at full power asfalt",null,null,null,null,"MWh/sr m2",{"$f":"(I166*$H$21+I167*$H$22+I168*$H$23)/1000000","v":3202.5682316723701},{"$f":"(J166*$H$21+J167*$H$22+J168*$H$23)/1000000","v":2733.1185957613707},{"$f":"(K166*$H$21+K167*$H$22+K168*$H$23)/1000000","v":2140.7736586024571},{"$f":"(L166*$H$21+L167*$H$22+L168*$H$23)/1000000","v":984.6378479220333},{"$f":"(M166*$H$21+M167*$H$22+M168*$H$23)/1000000","v":1462.6361246714241},{"$f":"(N166*$H$21+N167*$H$22+N168*$H$23)/1000000","v":926.63349605707913},{"$f":"(O166*$H$21+O167*$H$22+O168*$H$23)/1000000","v":1147.0747277506578},{"$f":"(P166*$H$21+P167*$H$22+P168*$H$23)/1000000","v":2609.6507698084879},{"$f":"(Q166*$H$21+Q167*$H$22+Q168*$H$23)/1000000","v":3070.3005603667871},{"$f":"(R166*$H$21+R167*$H$22+R168*$H$23)/1000000","v":1171.9029290274134},{"$f":"(S166*$H$21+S167*$H$22+S168*$H$23)/1000000","v":1630.0674987264399},{"$f":"(T166*$H$21+T167*$H$22+T168*$H$23)/1000000","v":718.40440863776587},{"$f":"(U166*$H$21+U167*$H$22+U168*$H$23)/1000000","v":833.99443726976642}]
[null,null,"Red light emited per instalation at full power asfalt",null,null,null,null,"MWh/sr m2",{"$f":"(I169*$H$21+I170*$H$22+I171*$H$23)/1000000","v":8913.1106854244263},{"$f":"(J169*$H$21+J170*$H$22+J171*$H$23)/1000000","v":7606.5790947073328},{"$f":"(K169*$H$21+K170*$H$22+K171*$H$23)/1000000","v":5958.0159394763923},{"$f":"(L169*$H$21+L170*$H$22+L171*$H$23)/1000000","v":2740.3588272666698},{"$f":"(M169*$H$21+M170*$H$22+M171*$H$23)/1000000","v":2808.5705268127258},{"$f":"(N169*$H$21+N170*$H$22+N171*$H$23)/1000000","v":1779.3321813161112},{"$f":"(O169*$H$21+O170*$H$22+O171*$H$23)/1000000","v":2202.6259423449965},{"$f":"(P169*$H$21+P170*$H$22+P171*$H$23)/1000000","v":5011.0810978395484},{"$f":"(Q169*$H$21+Q170*$H$22+Q171*$H$23)/1000000","v":4620.9402322085434},{"$f":"(R169*$H$21+R170*$H$22+R171*$H$23)/1000000","v":2250.3013369038003},{"$f":"(S169*$H$21+S170*$H$22+S171*$H$23)/1000000","v":2453.3247927951088},{"$f":"(T169*$H$21+T170*$H$22+T171*$H$23)/1000000","v":2746.777849915045},{"$f":"(U169*$H$21+U170*$H$22+U171*$H$23)/1000000","v":2321.1011265580273}]
[null,null,"Blue light emited per instalation at full power snow",null,null,null,null,"MWh/sr m2",{"$f":"(I172*$H$21+I173*$H$22+I174*$H$23)/1000000","v":4217.5120829065636},{"$f":"(J172*$H$21+J173*$H$22+J174*$H$23)/1000000","v":3599.2865312414788},{"$f":"(K172*$H$21+K173*$H$22+K174*$H$23)/1000000","v":2819.2182394843712},{"$f":"(L172*$H$21+L173*$H$22+L174*$H$23)/1000000","v":1296.6849479830614},{"$f":"(M172*$H$21+M173*$H$22+M174*$H$23)/1000000","v":4732.9778764551265},{"$f":"(N172*$H$21+N173*$H$22+N174*$H$23)/1000000","v":2998.51464246151},{"$f":"(O172*$H$21+O173*$H$22+O174*$H$23)/1000000","v":3711.8454942470903},{"$f":"(P172*$H$21+P173*$H$22+P174*$H$23)/1000000","v":8444.6289479909901},{"$f":"(Q172*$H$21+Q173*$H$22+Q174*$H$23)/1000000","v":13238.939517065721},{"$f":"(R172*$H$21+R173*$H$22+R174*$H$23)/1000000","v":3792.1876418071729},{"$f":"(S172*$H$21+S173*$H$22+S174*$H$23)/1000000","v":7028.746730188489},{"$f":"(T172*$H$21+T173*$H$22+T174*$H$23)/1000000","v":714.9429695271258},{"$f":"(U172*$H$21+U173*$H$22+U174*$H$23)/1000000","v":1583.7368816670446}]
[null,null,"Green light emited per instalation at full power snow",null,null,null,null,"MWh/sr m2",{"$f":"(I175*$H$21+I176*$H$22+I177*$H$23)/1000000","v":19988.443101127548},{"$f":"(J173*$H$21+J174*$H$22+J175*$H$23)/1000000","v":12592.994072221647},{"$f":"(K173*$H$21+K174*$H$22+K175*$H$23)/1000000","v":12342.686444536948},{"$f":"(L173*$H$21+L174*$H$22+L175*$H$23)/1000000","v":4834.6985656094657},{"$f":"(M173*$H$21+M174*$H$22+M175*$H$23)/1000000","v":9411.0144578482978},{"$f":"(N173*$H$21+N174*$H$22+N175*$H$23)/1000000","v":8357.6382841250506},{"$f":"(O173*$H$21+O174*$H$22+O175*$H$23)/1000000","v":10345.876444348485},{"$f":"(P173*$H$21+P174*$H$22+P175*$H$23)/1000000","v":16791.231059003014},{"$f":"(Q173*$H$21+Q174*$H$22+Q175*$H$23)/1000000","v":21225.72404686705},{"$f":"(R173*$H$21+R174*$H$22+R175*$H$23)/1000000","v":10086.504063412885},{"$f":"(S173*$H$21+S174*$H$22+S175*$H$23)/1000000","v":14288.726739887932},{"$f":"(T173*$H$21+T174*$H$22+T175*$H$23)/1000000","v":5513.400143760904},{"$f":"(U173*$H$21+U174*$H$22+U175*$H$23)/1000000","v":6679.4013524381944}]
[null,null,"Red light emited per instalation at full power snow",null,null,null,null,"MWh/sr m2",{"$f":"(I178*$H$21+I179*$H$22+I180*$H$23)/1000000","v":55630.104622821418},{"$f":"(J178*$H$21+J179*$H$22+J180*$H$23)/1000000","v":47475.545384207842},{"$f":"(K178*$H$21+K179*$H$22+K180*$H$23)/1000000","v":37186.237415352662},{"$f":"(L178*$H$21+L179*$H$22+L180*$H$23)/1000000","v":17103.618887423007},{"$f":"(M178*$H$21+M179*$H$22+M180*$H$23)/1000000","v":25277.134741314538},{"$f":"(N178*$H$21+N179*$H$22+N180*$H$23)/1000000","v":16013.989631845003},{"$f":"(O178*$H$21+O179*$H$22+O180*$H$23)/1000000","v":19823.633481104967},{"$f":"(P178*$H$21+P179*$H$22+P180*$H$23)/1000000","v":45099.729880555933},{"$f":"(Q178*$H$21+Q179*$H$22+Q180*$H$23)/1000000","v":41588.462089876892},{"$f":"(R178*$H$21+R179*$H$22+R180*$H$23)/1000000","v":20252.712032134204},{"$f":"(S178*$H$21+S179*$H$22+S180*$H$23)/1000000","v":22079.923135155983},{"$f":"(T178*$H$21+T179*$H$22+T180*$H$23)/1000000","v":24721.0006492354},{"$f":"(U178*$H$21+U179*$H$22+U180*$H$23)/1000000","v":20889.910139022242}]
[null,"Manofacturing impact "]
[null,"Manofacturing impact per Glmh **",null,null,null,null,null," kg co2 eq.",175,175,175,175,822,822,822,822,822,822,822,822,823]
[null,"Manofacturing impact in live time",null,null,null,null,null," kg co2 eq.",{"$f":"(I189*I115*I29)","v":193725},{"$f":"J189*J115*J29","v":165327.74999999997},{"$f":"K189*K115*K29","v":129496.5},{"$f":"L189*L115*L29","v":59561.249999999993},{"$f":"M189*M115*M29","v":480253.50000000006},{"$f":"N189*N115*N29","v":304258.16249999998},{"$f":"O189*O115*O29","v":376639.57800000004},{"$f":"P189*P115*P29","v":856873.35},{"$f":"Q189*Q115*Q29","v":891754.91999999993},{"$f":"R189*R115*R29","v":384791.86575},{"$f":"S189*S115*S29","v":473445.73709999997},{"$f":"T189*T115*T29","v":343599.24690000003},{"$f":"U189*U115*U29","v":344017.25085000001}]
[null,"Total CO2 Emited electricity",null,null,null,null,null," Tm co2 eq.",{"$f":"(I192*1000-I190)/1000","v":3828.375},{"$f":"(J192*1000-J190)/1000","v":3267.1912499999999},2559.0974999999999,1412.4525000000001,2552.25,1616.9437499999999,1293.5550000000001,3828.3750000000005,3062.7,1719.1893749999999,1626.0322499999995,1535.14725,{"$f":"(U192*1000-U190)/1000","v":1535.14725}]
[null,"Total CO2 Emited all included *****",null,null,null,null,null," Tm co2 eq.",{"$f":"(I64*I47)/1000","v":4022.1},{"$f":"(J64*J47)/1000","v":3432.5189999999998},{"$f":"(K64*K47)/1000","v":2688.5940000000001},{"$f":"(L64*L47)/1000","v":1472.0137500000001},{"$f":"(M64*M47)/1000","v":3032.5034999999998},{"$f":"(N64*N47)/1000","v":1921.2019125000002},{"$f":"(O64*O47)/1000","v":1670.1945780000001},{"$f":"(P64*P47)/1000","v":4685.2483500000008},{"$f":"(Q64*Q47)/1000","v":3954.4549200000001},{"$f":"(R64*R47)/1000","v":2103.9812407499999},{"$f":"(S64*S47)/1000","v":2099.4779870999996},{"$f":"(T64*T47)/1000","v":1878.7464969},{"$f":"(U64*U47)/1000","v":1879.16450085}]
[]
[null,"* Phillips Master SON-T PIA Plus"]
[null,"** Tähkämö, L., & Halonen, L. (2015). Life cycle assessment of road lighting luminaires–comparison of light-emitting diode and high-pressure sodium technologies. Journal of Cleaner Production, 93, 234-242."]
[null,"*** Sánchez de Miguel, A. , Kyba, C. C., Aubé, M., Zamorano, J., Cardiel, N., Tapia, C., ... & Gaston, K. J. (2019). Colour remote sensing of the impact of artificial light at night (I): The potential of the International Space Station and other DSLR-based platforms. Remote sensing of environment, 224, 92-103."]
[null,"***** Manofacturing impact included"]
[null,"ULOR ->  Acording with Martin Aubé, when street lights are on tall buildings higher than the streetlights this value should be reduced by 50%. https://www.iau.org/static/archives/images/pdf/light-pollution-brochure.pdf"]

{"sheet":"3. Result","index":3,"n_rows":28,"n_cols":40,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,17,22,19],[5,1,5,2],[5,3,5,5],[11,1,11,2],[11,3,11,8],[11,23,11,24],[5,14,5,17],[5,6,5,10],[5,11,5,13],[5,18,5,21],[11,25,11,30],[13,1,13,3],[13,23,13,25],[9,1,9,2],[9,3,9,8],[9,23,9,24],[9,25,9,30],[10,1,10,2],[10,3,10,8],[10,23,10,24],[10,25,10,30],[15,30,15,32],[15,33,15,35],[15,36,15,38],[15,39,15,41],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[16,27,16,29],[15,5,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,16],[15,17,15,19],[15,27,15,29],[16,30,16,32],[16,33,16,35],[16,36,16,38],[16,39,16,41],[19,33,19,35],[19,36,19,38],[17,39,17,41],[18,5,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,19],[18,27,18,29],[18,30,18,32],[18,33,18,35],[18,36,18,38],[18,39,18,41],[17,5,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,16],[17,17,17,19],[17,27,17,29],[17,30,17,32],[17,33,17,35],[17,36,17,38],[23,14,23,16],[23,17,23,19],[23,27,23,29],[23,30,23,32],[23,33,23,35],[23,36,23,38],[19,39,19,41],[20,5,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,19],[20,27,20,29],[20,30,20,32],[20,33,20,35],[20,36,20,38],[20,39,20,41],[19,5,19,7],[19,8,19,10],[19,11,19,13],[19,14,19,16],[19,17,19,19],[19,27,19,29],[19,30,19,32],[21,39,21,41],[25,5,25,7],[25,8,25,10],[25,11,25,13],[25,14,25,16],[25,17,25,19],[25,27,25,29],[25,30,25,32],[25,33,25,35],[25,36,25,38],[25,39,25,41],[21,5,21,7],[21,8,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,19],[21,27,21,29],[21,30,21,32],[21,33,21,35],[21,36,21,38],[23,39,23,41],[23,5,23,7],[23,8,23,10],[23,11,23,13],[52,30,52,32],[52,33,52,35],[52,36,52,38],[52,39,52,41],[27,30,27,32],[27,33,27,35],[27,36,27,38],[27,39,27,41],[52,5,52,7],[52,8,52,10],[52,11,52,13],[52,14,52,16],[52,17,52,19],[52,27,52,29],[26,39,26,41],[26,8,26,10],[26,11,26,13],[26,14,26,16],[26,17,26,19],[26,30,26,32],[26,33,26,35],[26,36,26,38],[27,5,27,7],[27,8,27,10],[27,11,27,13],[27,14,27,16],[27,17,27,19],[27,27,27,29],[26,5,26,7],[26,27,26,29]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G2","v":"LCC-calculation for procurement of outdoor lighting systems"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G3","v":"Version 2.14"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G4","v":"Date: 2022-05-10"}]
[]
[]
[]
[]
[null,"Result LCC-calculation for procurement of outdoor lighting systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 2",null,null,null,null,null,"Result LCC-calculation for procurement of outdoor lighting systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 2"]
[null,"Project:",null,{"$f":"'2. LCC-calc.'!F11","v":"Scenario 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project:",null,{"$f":"IF(ISBLANK(D10),\"\",D10)","v":"Scenario 1"}]
[null,"Date:",null,{"$f":"'2. LCC-calc.'!F12","v":"05/04/2022"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"IF(ISBLANK(D11),\"\",D11)","v":"05/04/2022"}]
[null,"Administrator:",null,{"$f":"'2. LCC-calc.'!F13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Administrator:",null,0]
[]
[null,"Calculation based upon",null,null,{"$f":"'2. LCC-calc.'!H15","v":30},"year",null,"Discount rate",null,{"$f":"'2. LCC-calc.'!H16","v":1.7500000000000002E-2},null,"The result is calculated according to present value method",null,null,null,null,null,null,null,null,null,null,null,"Calculation based upon",null,null,{"$f":"E14","v":30},"year",null,"Discount rate",null,{"$f":"J14","v":1.7500000000000002E-2}]
[]
[null,"LCC-costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"HPS 70W standar diming"},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"HPS 150W new dimming"},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"NEW LED dimming"},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"PC Amber"},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"2200 k reduced lumens"},null,null,null,null,null,"LCC-costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"LED diming"},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"4000k reduced Lumens"},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"3000k reduced lumens"},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"HPS 150W standar diming"},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,2,FALSE))","v":"Current facility"}]
[null,"Top 1-5 most cost-effective alternatives",null,null,null,1,null,null,2,null,null,3,null,null,4,null,null,5,null,null,null,null,null,"Top 6-10 most cost-effective alternatives",null,null,null,6,null,null,7,null,null,8,null,null,9,null,null,10]
[]
[null,"Investment costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2280500},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2280500},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2522000},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2522000},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2522500},null,null,null,null,null,"Investment costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2522000},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2522000},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2522000},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2280500},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,24,FALSE))","v":2280500}]
[null,"Energy costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":416029.35575753445},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":753766.71728480572},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":381008.81501284998},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":452168.35356265126},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":452168.35356265126},null,null,null,null,null,"Energy costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":476261.01876606251},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":478937.98156644148},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":506376.85027032648},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":962331.45601296588},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,35,FALSE))","v":1127624.7412555474}]
[null,"Maintenance costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":517227.55586522975},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":517227.55586522975},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":651707.85333510058},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":651686.63658429508},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":651676.40896819113},null,null,null,null,null,"Maintenance costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":651707.85333510058},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":651696.86460949492},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":651702.35886241274},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":517227.55586522975},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,47,FALSE))","v":517227.55586522975}]
[null,"Total LCC-costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3213756.9116227641},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3551494.2731500352},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3554716.6683479506},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3625854.9901469462},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3626344.7625308423},null,null,null,null,null,"Total LCC-costs",null,null,null,{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3649968.872101163},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3652634.8461759365},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3680079.2091327393},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3760059.0118781957},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,50,FALSE))","v":3925352.297120777}]
[]
[null,"Control",null,null,null,{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,null,null,null,"Control",null,null,null,{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE))=TRUE,\"\",IF(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,30,FALSE)>0,\"Ja\",\"Nej\"))","v":"Ja"}]
[]
[null,"Energy usage & climate impact",null,null,null,{"$f":"F16","v":"HPS 70W standar diming"},null,null,{"$f":"I16","v":"HPS 150W new dimming"},null,null,{"$f":"L16","v":"NEW LED dimming"},null,null,{"$f":"O16","v":"PC Amber"},null,null,{"$f":"R16","v":"2200 k reduced lumens"},null,null,null,null,null,"Energy usage & climate impact",null,null,null,{"$f":"AB16","v":"LED diming"},null,null,{"$f":"AE16","v":"4000k reduced Lumens"},null,null,{"$f":"AH16","v":"3000k reduced lumens"},null,null,{"$f":"AK16","v":"HPS 150W standar diming"},null,null,{"$f":"AN16","v":"Current facility"}]
[null,"Energy usage",null,null,"[kWh/year]",{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE))","v":113450},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE))","v":205550},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE))","v":103900},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE))","v":123305},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,32,FALSE))","v":123305},null,null,null,null,null,"Energy usage",null,null,"[kWh/year]",{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE))","v":1127968.872101163},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE))","v":1130634.8461759365},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE))","v":1158079.2091327393},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE))","v":1479559.0118781957},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,49,FALSE))","v":1644852.2971207772}]
[null,"Climate impact",null,null,"[kgC02-e/year]",{"$f":"IF(ISNA(HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(F17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":49067.125},null,null,{"$f":"IF(ISNA(HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(I17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":89619.8},null,null,{"$f":"IF(ISNA(HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(L17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":55673.152600000001},null,null,{"$f":"IF(ISNA(HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(O17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":62624.883229999999},null,null,{"$f":"IF(ISNA(HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(R17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":62638.816695000001},null,null,null,null,null,"Climate impact",null,null,"[kgC02-e/year]",{"$f":"IF(ISNA(HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(AB17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":64040.063750000001},null,null,{"$f":"IF(ISNA(HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(AE17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":69982.599569999991},null,null,{"$f":"IF(ISNA(HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(AH17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":70132.708025},null,null,{"$f":"IF(ISNA(HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(AK17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":114417.3},null,null,{"$f":"IF(ISNA(HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE)) = TRUE, \"\",HLOOKUP(AN17,'2. LCC-calc.'!$I$59:$XFD$108,6,FALSE))","v":134070}]

{"sheet":"4. Tool parameters","index":6,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,8,54,10],[34,9,34,10],[45,8,45,10],[46,8,46,10],[38,8,38,10],[39,8,39,10],[40,8,40,10],[43,8,43,10],[44,8,44,10],[34,6,34,8],[35,8,35,10],[36,8,36,10],[42,8,42,10],[37,8,37,10],[48,8,48,10],[47,8,47,10],[9,6,9,10],[15,8,15,10],[52,8,52,10],[25,8,25,10],[27,8,27,10],[18,8,18,10],[32,8,32,10],[33,8,33,10],[22,6,22,8],[22,9,22,10],[17,8,17,10],[29,8,29,10],[30,6,30,8],[41,8,41,10],[30,9,30,10],[31,8,31,10],[5,15,5,18],[5,1,5,2],[5,3,5,5],[5,6,5,7],[28,8,28,10],[12,8,12,10],[11,8,11,10],[23,8,23,10],[24,8,24,10],[19,8,19,10],[20,6,20,8],[13,8,13,10],[9,1,11,4],[16,8,16,10],[26,8,26,10],[14,8,14,10]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G2","v":"LCC-calculation for procurement of outdoor lighting systems"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G3","v":"Version 2.14"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G4","v":"Date: 2022-05-10"}]
[]
[]
[]
[]
[null,"Tool parameters"]
[null,"Gathered instructions regarding the parameters.",null,null,null,null,"CALCULATION CONDITIONS (specified by the CA)"]
[null,null,null,null,null,null,"Note ","Parameter","Instruction"]
[null,null,null,null,null,null,"1.1","Usage time","Estimated time for using the lighting system. The calculation should be based on the luminaire with the best expected technical lifespan. 25 years might be considered as a value of reference but it might also be longer.. Poles might have a lifespan of 60 years."]
[null,null,null,null,null,null,"1.2","Discount rate","The discount rate determines the calculation of future costs to present value. The discount rate shall be based on the calculation rate the organisation uses for investments, and might be nominal as well as real. Often the internal rate of return is used for LCC-calculations. A high calculation rate gives more emphasis to the use phase costs."]
[null,null,null,null,null,null,"1.3","Electricity price","The organisation’s agreed-on electricity price (SEK/kWh) shall be inserted. Alternatively, a standard amount of 1-1,5 SEK/kWh. "]
[null,null,null,null,null,null,"1.4","Annual electricity price change","Factor for calculating price changes apart from inflation."]
[null,null,null,null,null,null,"1.5","Climate impact electricity usage","In order to calculate the impact from electricity usage one can insert the electricity supplier’s data regarding the climate impact from the used mix of electricity (carbon dioxide per kWh). Alternative emission factors can be found in tab 6.  "]
[null,null,null,null,null,null,"1.6","Operating hours system","Insert the lighting system’s total operating hours per year. "]
[null,null,null,null,null,null,"1.7","Operating hours full power","Insert the operating hours per year when the lighting system is using full power."]
[null,null,null,null,null,null,"1.8","Operating hours power level 1","Control for outdoor lighting is often using a dimmer or a reduced power level. If this is requested in the tender documents, then insert the number of hours per year when the luminaire shall be on reduced power according to the first power level. The time shall be based on actual, existing operating data. A recommendation is to use reduced power between 22-05 in places where no unprotected road user resides. This is equivalent to 2555h/year (7h x 365 days = 2555h/year). The lighting may be totally turned off at places which are not used during night time. In roads with a heavy flow of traffic the level of lighting might be reduced during night time to a level equivalent to that used in roads with a low flow of traffic, road class M5 with a mean luminance of 0,5cd/m2 at the lowest. The Swedish Transport Administration has further guidelines regarding lower lighting power during night time.\nThe LCC-tool might be used to evaluate whether or not it is profitable to use control systems for a lighting system. For some light sources, for example high pressure sodium, the luminous efficacy is lower with a dimmer."]
[null,null,null,null,null,null,"1.9","Operating hours power level 2","If more than one power level is being used,operating hours for the second power level is inserted here.\n"]
[null,null,null,null,null,null,"DATA FROM SUPPLIER"]
[null,null,null,null,null,null,null,"Name","Name of investment option."]
[null,null,null,null,null,null,"CALCULATION OF INVESTMENT COSTS"]
[null,null,null,null,null,null,"2.1","Number of luminaires","Insert the number of luminaires that is included in the suggested solution."]
[null,null,null,null,null,null,"2.2","Price per luminaire (incl. light source, electrical ballast, control device)","Insert the total price for luminaire, lighting source, electrical ballast and built-in control device. Price shall be specified per piece. If a luminaire has more than one lighting source, then these shall be added together."]
[null,null,null,null,null,null,"2.3","Material and labour costs per luminaire","Specify material and labour costs for the installation, excl. external control device. Eventual costs for operation start-up shall be included here (calibration and testing). Material can, for example, include cables. Labour cost may include personnel and machines. If the contract work is included in the tender, the cost for this shall be specified. If the contract work is not included, then the cost will be based on an estimation. How the estimation has been calculated shall be available to the CA."]
[null,null,null,null,null,null,"2.4","Number of poles and foundations","Insert number of poles that is included in the suggested solution. Poles have a longer lifespan than luminaires and is therefore not always a part of the procurement."]
[null,null,null,null,null,null,"2.5","Price per pole and foundation","If poles are included in the tender, the total price of pole and foundation (per piece) shall be inserted here."]
[null,null,null,null,null,null,"2.6","Material and labour costs per pole incl. foundation","If poles are included in the tender, the cost of material and labour for installations shall be inserted here."]
[null,null,null,null,null,null,"2.7","Cost of external control device (incl. operation start-up and license fees)","The control device is often a part of the luminaire but not always. If the control device is separated from the luminaire and not included in the price, then the cost of the external control device shall be provided here. An example is surveillance system. This is necessary only if it is specified in the tender documents, otherwise this box shall be left empty. The cost shall include the costs for installation, operation start-up, license fees as well as any costs for subscription and communication for the external device."]
[null,null,null,null,null,null,"CALCULATION OF OPERATING COSTS"]
[null,null,null,null,null,null,"3.1","Effect per luminaire incl. operating loss and system effects","Effect per luminaire (W), including operating loss and standby, shall be specified."]
[null,null,null,null,null,null,"3.2","Reduced power level 1","If control with reduced power level is requested in the procurement, then the effect (W) of power level 1 shall be inserted here. If level of dim has been specified by the CA this shall be followed. It might for example be specified as a road class or as percentage of full effect. If the exact effect is unknown then it might be presumed that it corresponds to the light quantity, i.e. if a luminaire is reduced to 70%, the effect is 70% of full effect. "]
[null,null,null,null,null,null,"3.3","Reduced power level 2","If more than one power level is being used, the second power level is inserted here."]
[null,null,null,null,null,null,"CALCULATION OF MAINTENANCE COSTS"]
[null,null,null,null,null,null,"4.1","Light source cost per luminaire","Insert costs for light sources when replacing, €/luminaire. All light sources in a luminaire shall be included.."]
[null,null,null,null,null,null,"4.2","Labour cost light source replacement","Insert labour cost for replacing light sources, €/luminaire."]
[null,null,null,null,null,null,"4.3","Replacement interval light sources","Specify the interval for replacing light sources according to the operation and maintenance plan. The lifespan shall be calculated according to standards available in the eco-design regulations."]
[null,null,null,null,null,null,"4.4","Electrical ballast cost","Electrical ballasts are expected to have the same lifespan as the light source. Sometimes replacing electrical ballasts are done collectively according to the operation and maintenance plan. The cost for this shall be specified here, with the cost broken down to cost per luminaire."]
[null,null,null,null,null,null,"4.5","Labour cost electrical ballast replacement","Insert the labour cost for collectively replacements of electrical ballasts. Price per luminaire."]
[null,null,null,null,null,null,"4.6","Replacement interval electrical ballast","Specify the interval for collective replacements of electrical ballasts according to the operation and maintenance plan. The lifespan is calculated according to standards available in the eco-design regulations."]
[null,null,null,null,null,null,"4.7","Lifespan luminaire","Insert the lifespan of luminaire in number of years. Note any requirements in the tender documents."]
[null,null,null,null,null,null,"4.8","Lifespan pole","Insert lifespan of pole in number of years. A pole might have a lifespan of between 25 to 50 years, depending on its quality and paint.  "]
[null,null,null,null,null,null,"4.9","Labour cost inspection","Insert the cost for inspection of the system, special control done by a professional person. The inspection should include searching for damages, audit documents and making sure that error protection is functioning. Cleaning the luminaires (LED) might be appropriate to conduct in connection with the inspection. Details regarding cleaning shall be specified in the tender documents, depending on the environment for the luminaires."]
[null,null,null,null,null,null,"4.10","Inspection interval","Inspection should be done according to the system’s operation and maintenance plan. Some systems have fixed intervals, for example aerial, low-tension lines every 8th year. For other system types it is up to the owner to decide upon an appropriate interval. Example: The Swedish Transport Administration have a four-year interval for their surveillance. The surveillance is often done in connection with replacement light sources."]
[null,null,null,null,null,null,"4.11","Labour cost surveillance","Insert the cost for surveillance of the system. Surveillance is the owner’s control to make sure that the system is functioning and safe from damages to persons or property due to electricity."]
[null,null,null,null,null,null,"4.12","Surveillance interval","Surveillance is done according to the system’s operation and maintenance plan. The SwedishnTransport Administration, for example, conduct surveillance twice annually. "]
[null,null,null,null,null,null,"4.13","Correlated Colour Temperature","This parameter the aspect of the colour of the light. It is heavily related wit it's envioromental impact."]
[null,null,null,null,null,null,"4.14","Lighting eficiency","This parameter represents how much light (lumens) are emited per power (watt)."]
[null,null,null,null,null,null,"RESULT"]
[null,null,null,null,null,null,null,"Total cost","Total cost of the lighting system during its entire usage time."]
[null,null,null,null,null,null,null,"Energy cost per year","Yearly energy cost is displayed here as a way to increase awareness regarding the energy usage."]
[null,null,null,null,null,null,null,"Energy cost full usage time","The system’s total energy costs during its usage time is provided here. In some cases, renovating during the usage time might help improve the energy efficiency."]
[null,null,null,null,null,null,null,"Climate impact","Yearly climate impact, measured in CO2-equivalents, calculated from the system’s energy usage."]

{"sheet":"5. Response sheet","index":7,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,5],[5,7,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[8,3,8,7],[22,11,22,14],[12,11,12,14],[13,11,13,14],[14,11,14,14],[23,11,23,14],[30,11,30,14],[31,11,31,14],[16,11,16,14],[18,11,18,14],[19,11,19,14],[20,11,20,14],[21,11,21,14],[37,11,37,14],[38,11,38,14],[33,11,33,14],[34,11,34,14],[35,11,35,14],[36,11,36,14]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G2","v":"LCC-calculation for procurement of outdoor lighting systems"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G3","v":"Version 2.14"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G4","v":"Date: 2022-05-10"}]
[]
[]
[]
[]
[null,null,null,"Response sheet for supplier"]
[null,null,null,"LCC-calculation for procurement of outdoor lighting."]
[null,null,null,"Attach one sheet per investment alternative"]
[]
[null,null,null,"Project name"]
[null,null,null,"Date"]
[null,null,null,"Administrator"]
[]
[null,null,null,"Name"]
[null,null,null,"Investment costs"]
[null,null,"2.1","Number of luminaires",null,null,null,null,null,"qty"]
[null,null,"2.2","Price per luminaire (incl. light source, electrical ballast, control device)",null,null,null,null,null,"€/piece"]
[null,null,"2.3","Material and labour costs per luminaire",null,null,null,null,null,"€/piece"]
[null,null,"2.4","Number of poles and foundations",null,null,null,null,null,"qty"]
[null,null,"2.5","Price per pole and foundation",null,null,null,null,null,"€/piece"]
[null,null,"2.6","Material and labour costs per pole incl. foundation",null,null,null,null,null,"€/piece"]
[null,null,"2.7","Cost of external control device (incl. operation start-up and license fees)\n",null,null,null,null,null,"€"]
[null,null,null,"Operating costs"]
[null,null,"3.1","Effect per luminaire incl. operatingloss and system effectst",null,null,null,null,null,"W"]
[null,null,"3.2","Reduced power level 1",null,null,null,null,null,"W"]
[null,null,"3.3","Reduced power level 2",null,null,null,null,null,"W"]
[null,null,null,"Maintenance costs"]
[null,null,"4.1","Light source cost per luminaire",null,null,null,null,null,"€/piece"]
[null,null,"4.2","Labour cost light source replacement",null,null,null,null,null,"€/piece"]
[null,null,"4.3","Replacement interval light sources",null,null,null,null,null,"h"]
[null,null,"4.4","Electrical ballast cost",null,null,null,null,null,"€/piece"]
[null,null,"4.5","Labour cost electrical ballast replacement",null,null,null,null,null,"€/piece"]
[null,null,"4.6","Replacement interval electrical ballast",null,null,null,null,null,"h"]
[null,null,"4.7","Lifespan luminaire",null,null,null,null,null,"year"]
[null,null,"4.8","Lifespan pole",null,null,null,null,null,"year"]
[null,null,"4.9","Labour cost inspection",null,null,null,null,null,"€/piece"]
[null,null,"4.10","Inspection interval",null,null,null,null,null,"year"]
[null,null,"4.11","Labour cost surveillance",null,null,null,null,null,"€/piece"]
[null,null,"4.12","Surveillance interval",null,null,null,null,null,"year"]
[null,null,"4.13","Correlated Colour Temperature\n",null,null,null,null,null,"K"]
[null,null,"4.14","Lighting eficiency",null,null,null,null,null,"lm/w"]

{"sheet":"6. Climate impact factors","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[37,8,37,10],[38,8,38,10],[39,8,39,10],[29,8,29,10],[30,8,30,10],[31,8,31,10],[33,8,33,10],[35,8,35,10],[36,8,36,10],[28,8,28,10],[17,8,17,10],[18,8,18,10],[19,8,19,10],[20,8,20,10],[21,6,21,8],[22,8,22,10],[23,8,23,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[27,8,27,10],[16,8,16,10],[5,3,5,5],[5,6,5,7],[5,15,5,18],[9,6,9,7],[15,8,15,10],[11,1,16,4],[9,1,10,4],[16,6,16,7]]}
[]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G2","v":"LCC-calculation for procurement of outdoor lighting systems"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G3","v":"Version 2.14"}]
[null,null,null,null,null,null,{"$f":"'1. Introduction'!G4","v":"Date: 2022-05-10"}]
[]
[]
[]
[]
[null,"Climate impact"]
[null,"These factors may be used to voluntarily calculate climate impact from electricity usage. The factors shall be inserted in row 1.5 in the LCC-tool.",null,null,null,null,"Factors for calculating climate impact from electricity usage [kgCO2/kWh]"]
[null,null,null,null,null,null,"Origin-labelled electricity",0]
[null,null,null,null,null,null,"Swedish mix (normal year)",0.02]
[null,null,null,null,null,null,"Nordic mix",0.1]
[null,null,null,null,null,null,"Unknown origin (Nordic)",0.34399999999999997]
[null,null,null,null,null,null,"EU (25)",0.41499999999999998]
[]
[null,null,null,null,null,null,"Source: Svensk Energi (www.svenskenergi.se) 2016-05-25. \nThe value for the EU 25-mix is from the report \"Den svenska elens miljöpåvekan\" published in 2010."]