SLIC Decision Support Tool

Tool Information

The purpose of SLIC decision support tool is to help municipalities in indicative assessment of economic, environmental and social impacts related to public outdoor lighting. The tool helps assessing electricity consumption before and after the investment. Furthermore, the tool also gives information about carbon dioxide (CO2) emissions. Most importantly, the tool also provides an alternative option of lighting system.

The tool provides tables and visual charts to aid the understanding of the impacts and potential benefits of a public lighting system. The results of the calculation done by the tool can be printed out as a PDF for further use.

Scenarios considered in the tool

The tool considers three scenarios: Baseline, Upgrade and Alternative scenarios. The Baseline scenario describes the current situation. The Upgrade scenario describes the situation after implementation of energy saving lighting technologies and the Alternative scenario provides an alternative lighting scenario based on optimisation. This scenario is generated based on an optimisation algorithm that takes into account the importance level of each sustainability dimension (economic, environmental and social). Computational analysis provides a set of options (lighting options) with their costs and impacts of each dimension. A key feature of this tool is the ability to compare the scenarios.

Inputs collection for the DST

*This is a crucial step for the calculation and generation of results in the tool. This step must not be missed!

The inputs used for calculation in the DST can be provided in two ways – uploading data or inputting data. It is recommended to comprehensively collect and verify data to improve the accuracy of the assessment. The two ways to provide data are described below:


*Downloaded Excel templates must be filled using exact template format and converted to txt. No additional text or reformatting otherwise, files cannot be uploaded*

(Excel to txt conversion guide)

In the Inputs collection step in lighting system inputs - step 6, the tool collects data about lamp details, technics details such as cost of dimming or sensor equipment (in the case of new installation) or maintenance cost. This step is optional and contains downloadable Excel templates that can be used to collect data and upload to the tool. The inputs collected in this step is used in designing the scenarios - step 7.

The inputs collection in lighting system inputs - step 6 are divided into three stages:

  • Lamps: Here, we collect data about the luminaire (operating cost and investment cost, luminaire power). Here, you can also download an Excel template, collect data using the template and convert the template to txt before uploading the txt into the tool. Download Lamps Template
  • Technics: Here, we collect data about costs of the smart technics used in the lighting system. Download Technic Template
  • Energy: Here, we collect data about costs of the energy equipment used in the lighting system and price of energy (Kwh). Data collected include costs of procuring and installing energy harvesting modules for solar energy or other equipment costs associated with energy provision for the lighting system. Download Energy Template


If lighting system inputs - step 6 is skipped, lighting system data must be provided in the next step - scenario design - step 7. The inputs collected in this step is used in scenario design - step 7. To provide data for building the scenarios, Excel templates can be downloaded for each scenario below.

*Downloaded excel templates must be filled using exact template format, converted to txt and uploaded under each scenario to calculate impacts. No additional text or reformatting otherwise, files cannot be uploaded*

(Excel to txt conversion guide)

Outputs of the DST

The results provided in this tool provides a high level overview of the costs and impacts of the scenarios in respect to the lighting systems. The output addresses three sustainability dimensions – Economic, Environmental and Social. The outputs can be printed for each dimension using the print button.

The aim of the DST is to provide support for public outdoor lighting policy/decisions e.g. a project or a program. You will find more information on the SLIC website at