{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["1.  LED JR-Electrical","2. Civil works","RECAP"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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.  LED JR-Electrical","index":0,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":false,"merged":[[37,2,38,2],[37,3,38,3],[65,1,65,2],[66,1,66,2],[10,1,10,5],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[64,1,64,2],[19,1,19,5],[13,1,13,5],[14,1,14,5],[51,1,51,5],[33,5,34,5],[30,5,31,5],[39,0,40,0],[41,0,42,0],[45,0,46,0],[45,2,46,2],[45,3,46,3],[43,0,44,0],[43,2,44,2],[43,3,44,3],[37,0,38,0],[67,1,67,2],[22,1,22,5],[24,2,25,2],[24,3,25,3],[24,4,25,4],[45,4,46,4],[45,5,46,5],[43,4,44,4],[43,5,44,5],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[37,4,38,4],[37,5,38,5],[1,1,3,1],[1,2,1,5],[2,2,2,5],[3,2,3,5],[63,1,63,2],[5,0,5,5],[11,1,11,5],[20,1,20,5],[21,1,21,5],[24,0,25,0],[24,5,25,5],[26,0,27,0],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[53,0,54,0],[53,2,54,2],[53,3,54,3],[53,4,54,4],[53,5,54,5],[12,1,12,5],[47,0,48,0],[47,2,48,2],[47,3,48,3],[47,4,48,4],[47,5,48,5],[35,0,36,0],[30,0,31,0],[30,2,31,2],[30,3,31,3],[30,4,31,4],[28,0,29,0],[33,0,34,0],[33,2,34,2],[33,3,34,3],[33,4,34,4],[49,0,50,0],[49,2,50,2],[49,3,50,3],[49,4,50,4],[49,5,50,5]]}
[null,"SPECIFICATION OF MATERIALS"]
[null,null,"Subject:"]
[]
[null,null,"Location: City of Sarajevo"]
[]
["City of Sarajevo - Reconstruction of part of the public lighting system - Maršala Tita and Ferhadija Streets"]
[]
[null,null,"Unit","Qty","Unit","BAM"]
[null,"Description of Works"]
[]
["A","LIGHTING"]
["I","LIGHTING - SUPERVISION AND MANAGEMENT OF THE LIGHTING SYSTEM"]
[null,"NOTE:\n Remote monitoring and control system it must be possible to remotely control the following types of lights:\nSV1, SV4, SV5, SV6"]
[null,"Supervision and management of the lighting system for the offered lights  must be accessible using the existing IT Infrastructure (GSM, wireless) and devices (desktops, tablets, laptops, smartphones). \nIt is not desirable to invest in a special communication infrastructure such as fiber optic cable networks or radio communications due to the special requirements of regulatory bodies and physical feasibility in the old part of the city.\n The platform for remote monitoring and control of lighting should be delivered to the user as Software-as-a-Service (SaaS), available through a standard web browser and with the possibility of setting, calculating, storing and connecting to individual lights and sensors.\nThe system should be able to remotely control the lights (from any location), and obtain operational data from them. The system should provide a graphical user interface including a satellite view. The system should be able to manage resources through information on the types of equipment installed.\nThe system must be capable of interoperability with other systems and platforms via APIs (Application Programming Interfaces).\nAccess to the monitoring and management system should be provided from a device connected to the Internet and using a username and password. A user should be able to use SDNUR according to the user's role and the corresponding access rights granted to that user. SDNUR should use two levels of authentication to prevent unwanted and malicious use."]
[null,"The system of remote monitoring and control - remote management (SDNUR) must meet the following requirements: \n * must use open communication protocols TCP/IP, Http, XML, ..\n * communication between system components must be as simple and as cheap as possible\n * possibility of individual and group control and management of lights,\n * the ability to read all electrical parameters and parameters of a light, such as: voltage, current, power factor, power of an individual light, the condition of the light, fault detection signal, etc.\n * possibility of flexible adaptation of lighting levels of groups, but also of individual lights (on/off/dim),\n * possibility of geolocation of the light,\n * possibility of autonomous work in situations when SDNUR is not operational (independent switching lights on/off in accordance with the real calendar)\n * possibility of planning lighting mode using a realistic calendar,\n * automatic fault notification,\n * possibility to monitor/read energy consumption in real time\n * possibility of archiving data important for the operation of the system (energy consumption, etc.) and preparation of reports on events in the system\n * possibility to display readings from sensors\n * flexible system structure with the possibility of easy expansion of the system\n * interoperability with components from other manufacturers of lights and related equipment\n * provided technical support and service for system components in BiH\n\nManufacturer, type and name of remote control and monitoring system: \n (required): ____________________________________________\n ______________________________________________________________"]
["1.1","One-off costs of introducing remote control and monitoring systems (lease/software/licenses/additional modules and equipment... other)","set",1,null,{"$f":"D16*E16","v":0}]
["1.2","Annual operating costs of remote control and monitoring systems (lease/licenses/... other)","set",1,null,{"$f":"D17*E17","v":0}]
["1.3","One-off costs/fees for including newly installed lights in the remote control and monitoring system","per light",1,null,{"$f":"D18*E18","v":0}]
["1.4","Annual costs/fees for using the remote control and monitoring system for newly installed lights ","per light",1,null,{"$f":"D19*E19","v":0}]
["II","LIGHTING - DELIVERY AND INSTALLATION OF LIGHTS AND POLES"]
[null,"Procurement, delivery, installation of specified materials and equipment to the location determined by the Investor, including all necessary technological operations, all necessary small assembly material, as well as all necessary electrical connections and functional connections up to full functionality of the equipment, and all related preparatory and final works (cleaning, removal of dismantled or remaining material, etc.).\nInstallations must be performed in accordance with the applicable BiH Rulebooks.\nIn order to verify compliance with the lighting requirements within the offer, it is necessary to submit the data necessary for photometric calculations on a separate CD or in electronic form for each of the offered types of lights (LDT and IES files of the manufacturer with names that specify the model and type ).\nIt is necessary to state the exact name of the manufacturer, model and type of product for each of the offered types of lights."]
[null,"REQUIRED CHARACTERISTICS OF LIGHTS FOR ALL TYPES:\n • The Lights must be delivered with built-in light sources, all necessary pre-programmed modules and equipment, suspension accessories and other related equipment. All light sources and lights are fitted with fully functional programmable light intensity control devices.\n• Upper and lower part of the light housing made of aluminum or die-cast aluminum alloy, with anti-corrosion coating.\n• The lower part of the housing must have a profiled silicone or rubber seal that provides an adequate degree of protection of the light part with ballasts/modules.\n• Protector made of tempered glass resistant to UV rays, weathering and temperature expansion.\n• All applied screws, washers and nuts must be made of stainless steel or other equivalent stainless metal.\n• Minimum warranty: 5 years."]
[null,"In order to confirm that required characteristics are satisfied, for each of the offered types of lights or poles it is necessary to enclose:\n • Technical specification of the product with a picture, which must contain information on all technical parameters required in the tender documentation, in accordance with the requirements of standards IEC/EN 62722-1: 2014, IEC/EN 62722-2-1: 2014, CIE 15 and certified by manufacturer/supplier.\n• The bidder for the light sources and lights which he proposes to use must submit the manufacturer's documentation evidently showing that they are compatible with light intensity control devices (SDNUR).\n• Declaration of conformity with the CE mark, issued by the Manufacturer.\n• Declaration of Conformity with the RoHS Directive issued by the Manufacturer.\n• ENEC certificate issued by the appropriate accredited body,\n• EMC certificate issued by an appropriate accredited laboratory,\n• Certificate of photobiological safety testing according to standard EN 62471 issued by an appropriate accredited laboratory,\n• Photometric report, or certificate according to standards EN 13032-1 and EN 13032-4 proving the required characteristics of the light issued by an appropriately accredited laboratory.\n• Report of an independent accredited laboratory on impact resistance testing (IK test) according to standard EN 62262.\n• Independent accredited laboratory report on mechanical protection testing (IP test) according to standard EN 60598.\n• Report of the manufacturer of LED chips or LED lights on the designed service life and maintenance of light flux according to IES LM80/IESTM21 standards.\n• Certificate of stability of properties for metal poles according to standard EN 40-5\n\nCertificates and reports for lights as well as for other equipment and materials can be submitted in one of the official languages of BiH or in English."]
["II a","Maršala Tita Street, from Radićeva Street to the Eternal Fire monument"]
["2.1","Delivery, installation, connection to the control system and commissioning of the LED light TYPE-SV1,,\nDescription:\n• light for lighting of roads and pedestrian zones\n • The light is mounted on a primary rope (Catenary), at a height of 10 m, according to the details given in the textual and graphic part of the project documentation\n • The factory suspension for the primary rope should be included in the price of the light\n • Light grip system on a support rope with a diameter of 6 mm to 15 mm. Grip on the rope is secured with screws with nuts.\n• Light weight with primary rope gripper should not be more than 12.50 kg;\n • Housing color: dark gray shade of the final color\n • Light housing should be designed as smooth, without cooling fins, in order to prevent the retention of dirt.\n• Light communication and control protocol (ballast/antenna/sensor): DALI-2 or equivalent\n• The ballast (driver) should comply with the DiiA instructions with the DALI-2 lighting communication protocol or equivalent and should be able to accurately measure total energy consumption and total energy consumption since the last factory reset.\n• The lights must be equipped with a communication antenna for remote monitoring and control.\n• Lights should be  (system ready - SR) and equipped with one or two Zhaga connectors (Zhaga book 18) or equivalent as a standardized interface that connects SR ballasts to SR antennas of the Center for Remote Monitoring and Control (CMS) and SR sensors located on the lower or upper part of the light .\n• All antennas and sensors must be easily mounted/removed on SR connectors without the use of tools, and the connection of antennas and sensors must be possible without opening the light\n • Lights should be equipped with a service label with a QR code that is visible on the outside of the light, which allows access to information on the operating parameters and status of the lights.\n• It is necessary to supply additional service labels with QR code with the light so that they can be placed in easily accessible places\n","pcs",30,null,{"$f":"D25*E25","v":0}]
[null,"Electrical and optical Features:\n• Total light power: max 50W ± 10%,\n • Usable (output) light flux of the light: min 5,700 lm ± 5% (at Ta = 25 ° C),\n • Light efficiency  ≥ 120 lm/W.\n • Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 220-240 VAC, 50 Hz;\n • Power factor at 100% load: ≥ 0.90,\n • Protection class according to IEC: I;\n • Built-in surge protection: 10 kV, durability 10kA;\n • NTC temperature control of the optical block;\n • Durability of LED source (for tq = 25 ° C): ≥100,000 hours, with min. L96: 6,000 hours designed\n • Optical block design: Fully shaded with ULOR = 0.0%;\n • CRI color rendering ≥ 80;\n • Mechanical impact resistance of the light min. IK08;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Optics/light distribution: symmetrical\n\nManufacturer, type and model: \n (required): ____________________________________________________________\n ______________________________________________________________\n"]
["2.2","Delivery, installation and commissioning of LED lights TYPE-SV2,,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (\"wallwash/graze\")\n • The light is mounted on the facades of buildings, according to the details given in the textual and graphic part of the project documentation\n • Mounting bracket and power cables with quick connectors that allow quick and easy installation.\n• Light weight not exceeding: 1.35 kg\n• Housing color: dark gray shade of the final color","pcs",25,null,{"$f":"D27*E27","v":0}]
[null,"Electrical and optical Features:\n• Total light power: max 18W ± 10%,\n • Usable (output) light flux of the light: min 780 lm ± 5% (at Ta = 25 ° C),\n • Light efficiency  ≥ 40 lm/W.\n • Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n • Power factor at 100% load: ≥ 0.90,\n • Protection class according to IEC: I;\n • Durability of LED sources: ≥ 60,000 hours,\n • Luminous flux of the light source at 100% of the load after 60,000 hours (T = 25C): min.70% of the initial (L70)\n • CRI color rendering ≥ 80;\n • Mechanical impact resistance of the light min. IK06;\n • Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle: 10° x 50°, elliptical distribution\n\nManufacturer, type and model: \n (required): ____________________________________________________________\n ______________________________________________________________\n"]
["2.3","Delivery, installation and commissioning of LED lights TYPE-SV3,,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (spotlight)\n• The Lights are mounted on the cable tensioning system, at a height of approx. 10 m, according to the details given in the textual and graphic part of the project documentation.\n• Light weight not exceeding: 1.35 kg\n• Housing color: dark black shade of the final color","pcs",2,null,0]
[null,"Electrical and optical Features:\n• Total light power: max 30W ± 10%,\n• Usable (output) light flux of the light: min 1850 lm ± 5% (at Ta = 25 °C),\n• Light efficiency  ≥ 50 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Durability of LED sources: ≥ 90,000 hours,\n• Luminous flux of the light source at 100% of the load after 90,000 hours (T = 25C): min.70% of the initial (L70)\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK07;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle: 6 ° - narrow beam\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["2.4","Delivery, installation and commissioning of LED lights TYPE-SV10,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (spotlight)\n• The Lights are mounted on the cable tensioning system, at a height of approx. 6m-10 m, according to the details given in the textual and graphic part of the project documentation.\n• Housing color: dark black shade of the final color","pcs",10,null,{"$f":"D31*E31","v":0}]
[null,"Electrical and optical Features:\n• Total light power: max 12W ± 10%,\n• Usable (output) light flux of the light: min 680 lm ± 5% (at Ta = 25 ° C),\n• Light efficiency  ≥ 60 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Durability of LED sources: ≥ 50,000 hours,\n• Luminous flux of the light source at 100% of the load after 50,000 hours (T = 25C): min.90% of the initial (L90)\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK07;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle:  6° - 10° narrow beam\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["II b","Ferhadija Street, from Maršala Tita Street to the \"Sarajevo Meeting of Cultures\" position"]
["2.4","Delivery, installation, connection to the control system and commissioning of the LED light TYPE-SV4,\nDescription:\n• light for lighting of roads and pedestrian zones\n•The light is mounted on a primary rope (Catenary), at a height of 6 m,according to the details given in the textual and graphic part of the project documentation\n• The factory suspension for the primary rope should be included in the price of the light\n• Light grip system on a support rope with a diameter of 6 mm to 15 mm. Grip on the rope is secured with screws with nuts.\n• Light weight with primary rope gripper should not be more than 18.0 kg;\n• Housing color: dark gray shade of the final color\n• Light housing should be designed as smooth, without cooling fins, in order to prevent the retention of dirt.\n• Light communication and control protocol (ballast/antenna/sensor): DALI-2 or equivalent\n• The ballast (driver) should comply with the DiiA instructions with the DALI-2 lighting communication protocol or equivalent and should be able to accurately measure total energy consumption and total energy consumption since the last factory reset.\n• The lights must be equipped with a communication antenna for remote monitoring and control.\n• Lights should be system ready - SR and equipped with one or two Zhaga connectors (Zhaga book 18) or equivalent as a standardized interface that connects SR ballasts to SR antennas of the Center for Remote Monitoring and Control (CMS) and SR sensors located on the lower or upper part of the light .\n• All antennas and sensors must be for easy installation/removal on SR connectors without the use of tools, and the connection of antennas and sensors must be possible without opening the light\n• Lights should be equipped with a service label with a QR code that is visible on the outside of the light and which allows access to information on the operating parameters and status of the lights.\n• It is necessary to supply additional service labels with QR code with the light so that they can be placed in easily accessible places\n","pcs",31,null,0]
[null,"Electrical and optical Features:\n• Total light power: max 50W ± 10%,\n• Usable (output) light flux of the light: min 5,000 lm ± 5% (at Ta = 25 ° C),\n• Light efficiency  ≥ 110 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 220-240 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Built-in surge protection: 10 kV, durability 10kA;\n• NTC temperature control of the optical block;\n• Durability of LED source: min. L90 for ≥100,000 hours, with min. L96: 6,000 hours projected (for tq = 25 ° C)\n• Optical block design: Fully shaded with ULOR = 0.0%;\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK08;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Optics/light distribution: symmetrical\n\nManufacturer, type and model: \n (required): ____________________________________________________________\n ______________________________________________________________\n"]
["2.5.","Delivery, installation, connection to the control system and commissioning of the LED Light TYPE-SV5,\nDescription:\n• Light for lighting of roads and pedestrian zones\n• The lights are mounted on brackets that are 100 cm long, which are mounted on the facades of buildings, at a height of 6 m, according to the details given in the textual and graphic part of the project documentation.\n• The design of the light must be the same as that of the SV4 light because they are placed in close proximity\n• The price of the light should include a 100 cm long bracket;\n• The bracket and the light must be factory-prepared without stepped transitions;\n• Housing color: dark gray shade of the final color\n• Light housing must be designed as smooth, without cooling fins, in order to prevent the retention of impurities.\n• Light communication and control protocol (ballast/antenna/sensor): DALI-2 or equivalent\n• The ballast (driver) should comply with the DiiA instructions with the DALI-2 lighting communication protocol or equivalent and should be able to accurately measure total energy consumption and total energy consumption since the last factory reset.\n• The lights must be equipped with a communication antenna for remote monitoring and control.\n• Lights should be system ready - SR and equipped with one or two Zhaga connectors (Zhaga book 18) or equivalent as a standardized interface that connects SR ballasts to SR antennas of the Center for Remote Monitoring and Control (CMS) and SR sensors located on the lower or upper part of the light .\n• All antennas and sensors must be for easy installation/removal on SR connectors without the use of tools, and the connection of antennas and sensors must be possible without opening the light\n• Lights should be equipped with a service label with a QR code that is visible on the outside of the light and which allows access to information on the operating parameters and status of the lights.\n• It is necessary to supply additional service labels with QR code with the light so that they can be placed in easily accessible places\n","pcs",7,null,0]
[null,"Electrical and optical Features:\n• Total light power: max 50W ± 10%,\n• Usable (output) light flux of the light: min 5,200 lm ± 5% (at Ta = 25 ° C),\n• Light efficiency  ≥ 120 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 220-240 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Built-in overvoltage protection: 10 kV, durability 10kA;\n• NTC temperature control of the optical block;\n• Durability of LED source: min. L90 for ≥100,000 hours, with min. L96: 6,000 hours projected (for tq = 25 ° C)\n• Optical block design: Fully shaded with ULOR = 0.0%;\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK08;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Optics/light distribution: asymmetrical\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["2.6.","Delivery, installation, connection to the control system and commissioning of the LED light TYPE-SV6,\nDescription:\n• Light for lighting of roads and pedestrian zones\n • The Lights are mounted on poles, 3 pcs per pole, at a height of 6m, according to the details given in the textual and graphic part of the project documentation, and the position is the square in front of the Cathedral..\n• The design of the light must be the same as for the SV4 and SV5 lights because they are placed in close proximity\n• Housing color: dark gray shade of the final color;\n• The price of the light should include the pole adapter;\n• Pillar adapter and light factory-prepared without stepped transitions;\n• light housing designed as smooth, without cooling fins, in order to prevent the retention of impurities.\n• Light communication and control protocol (ballast/antenna/sensor): DALI-2 or equivalent\n• The ballast (driver) should comply with the DiiA instructions with the DALI-2 lighting communication protocol or equivalent and should be able to accurately measure total energy consumption and total energy consumption since the last factory reset.\n• The lights must be equipped with a communication antenna for remote monitoring and control.\n• Lights should be system ready - SR and equipped with one or two Zhaga connectors (Zhaga book 18) or equivalent as a standardized interface that connects SR ballasts to SR antennas of the Center for Remote Monitoring and Control (CMS) and SR sensors located on the lower or upper part of the light .\n• All antennas and sensors must be for easy installation/removal on SR connectors without the use of tools, and the connection of antennas and sensors must be possible without opening the light\n• Lights should be equipped with a service label with a QR code that is visible on the outside of the light and which allows access to information on the operating parameters and status of the lights.\n• It is necessary to supply additional service labels with QR code with the light so that they can be placed in easily accessible places\n","pcs",6,null,0]
[null,"Electrical and optical Features:\n• Total light power: max 50W ± 10%,\n• Usable (output) light flux of the light: min 5,200 lm ± 5% (at Ta = 25 ° C),\n• Light efficiency  ≥ 120 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 220-240 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Built-in overvoltage protection: 10 kV, durability 10kA;\n• NTC temperature control of the optical block;\n• Durability of LED source: min. L90 for ≥100,000 hours, with min. L96: 6,000 hours designed (for tq=25°C)\n• Optical block design: Fully shaded with ULOR = 0.0%;\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK08;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Optics/light distribution: asymmetrical\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________"]
["2.7","Project designation of the pole - POLE 1 - Ferhadija"]
[null,"Pole description\nConical column 8 m high. The specified height refers to the height of the column to the beginning of the sharp end of the column. \nThe column has a sharp end which is 1.4m-1.5 m long. The diameter of the column at the place of installation of the sharp end should be 55-70mm.\n3 lights eachand type SV6 are mounted on a pole , just below/above the other. Mounting height of the middle light on the pole is 6m. The lights are rotated by 120° in space. The angle of the conical inclination of the column must correspond to the factory adapter for mounting of the lights, thus creating a smooth surface. The pole comes with pre-prepared holes for the passage of the cables into the lights and openings for mounting of the light adapter.\nThe pole is installed on the previously prepared foundation and anchors, in the position according to the project documentation. The price must include the connection of the pole to the existing earthing.","pcs",2,null,{"$f":"D41*E41","v":0}]
["2.8","Project designation of the POLE 2 - Ferhadija"]
[null,"Pole description\nConical column 8 m high. The specified height refers to the height of the column to the beginning of the sharp end of the column. \nThe pole has a sharp end which is 1.4m - 1.5m long. The diameter of the column at the installation site of the sharp end should be 55-70mm.\nThe pole is installed on previously prepared foundation and anchors, in the position according to the project documentation, and primarily serves to lay the primary ropes.\nThe secondary purpose of the poles is to place a light/reflector type SV8 from this bill of quantities. The price must include the connection of the pole to the existing earthing.","pcs",7,null,{"$f":"D43*E43","v":0}]
["2.9","Delivery, installation and commissioning of LED lights TYPE-SV7,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (\"wallwash/graze\")\n• The light is mounted on the facades of buildings, at the height of 6m-8m according to the details given in the textual and graphic part of the project documentation\n• Mounting bracket and power cables with quick connectors that allow quick and easy installation.\n• Light weight not exceeding: 1.35 kg\n• Housing color: dark gray shade of the final color","pcs",56,null,0]
[null,"Electrical and optical Features:\n• Total light power: max 18W ± 10%,\n• Usable (output) light flux of the light: min 780 lm ± 5% (at Ta = 25 °C),\n• Light efficiency  ≥ 40 lm/W..\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Durability of LED sources: ≥ 60,000 hours,\n• Luminous flux of the light source at 100% of the load after 60,000 hours (T = 25C): min.70% of the initial (L70)\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK06;\n • Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle: 10 ° x 50 °, elliptical distribution\n\nManufacturer, type and model:  \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["2.10","Delivery, installation and commissioning of LED lights TYPE-SV8,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (spotlight)\n• The Lights are mounted on a pole, at a height of approx. 6m-8 m, according to the details given in the textual and graphic part of the project documentation.\n• light weight not exceeding: 2.0 kg\n• Housing color: black shade of the final color","pcs",4,null,{"$f":"D46*E46","v":0}]
[null,"Electrical and optical Features:\n• Total light power: max 15W ± 10%,\n• Usable (output) light flux of the light: min 620 lm ± 5% (at Ta = 25 ° C),\n• Light efficiency  ≥ 40 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Luminous flux of the light source at 100% of the load after 90,000 hours (T = 25C): min.70% of the initial (L70)\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK07;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle: 8 ° - narrow beam\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["2.10","Delivery, installation and commissioning of LED lights TYPE-SV9,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (spotlight)\n• The Lights are mounted on a pole, at a height of approx. 6m-8 m, according to the details given in the textual and graphic part of the project documentation.\n• Light weight not exceeding: 3.5 kg\n• Housing color: black shade of the final color","pcs",2,null,{"$f":"D48*E48","v":0}]
[null,"Electrical and optical Features:\n• Total light power: max 30W ± 10%,\n• Usable (output) light flux of the light: min 1850 lm ± 5% (at Ta = 25 °C),\n• Light efficiency  ≥ 50 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Luminous flux of the light source at 100% of the load after 90,000 hours (T = 25C): min.70% of the initial (L70)\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK07;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle: 6 ° - narrow beam\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["2.4","Delivery, installation and commissioning of LED lights TYPE-SV11,\nDescription:\n• Light for lighting of architectural details on the facades of residential buildings and cultural heritage buildings (spotlight)\n• The Lights are mounted on a console  on facade, at a height of approx. 6m-10 m, according to the details given in the textual and graphic part of the project documentation.\n• Housing color: dark black shade of the final color","pcs",6,null,{"$f":"D50*E50","v":0}]
[null,"Electrical and optical Features:\n• Total light power: max 12W ± 10%,\n• Usable (output) light flux of the light: min 680 lm ± 5% (at Ta = 25 ° C),\n• Light efficiency  ≥ 60 lm/W.\n• Light color temperature: 3000K (WW-warm white).\n• Rated voltage and frequency: 100-270 VAC, 50 Hz;\n• Power factor at 100% load: ≥ 0.90,\n• Protection class according to IEC: I;\n• Durability of LED sources: ≥ 50,000 hours,\n• Luminous flux of the light source at 100% of the load after 50,000 hours (T = 25C): min.90% of the initial (L90)\n• CRI color rendering ≥ 80;\n• Mechanical impact resistance of the light min. IK07;\n• Level of tightness of the light (optical part and part of the ballast) min. IP66,\n• Light operating temperature: within the range -35 ͦC to +35 ͦC.\n• Light angle: 6° - 10° narrow beam\n\nManufacturer, type and model: \n(required): ____________________________________________________________\n______________________________________________________________\n"]
["III","LIGHTING INSTALLATION"]
["3.1","Execution of preparatory works for installation activities of the new outdoor lighting with accompanying cable installations. Preparatory works include the following activities:\n- Detailed inspection with identification of lights and poles to be dismantled\n- Identification of outdoor lighting power supply cabinets with associated circuits for lights to be dismantled\n- Providing the necessary work permits (Ministry of Interior Affairs, Cantonal Ministry of Transport, ...)\n- Development of a detailed plan of activities for the dismantling of existing and installation of new lights\n- All other preparatory activities that need to be performed before the start of work on the dismantling of existing and installation of new outdoor lights\nEverything must be complete","lump sum",1,null,{"$f":"D53*E53","v":0}]
["3.2","Delivery and installation of power cables for lights.\n The cables must be laid in rigid PVC protective pipes. The price includes complete material necessary for installation and connecting of cables. The cables must be installed at a height of 8-16 meters with the use of a suitable truck crane. All works on the installation of cables and lights are to be performed at night, in the period from 00:00 to 05:00. Before submitting a bid, it is necessary to make a detailed review of the cable laying routes (Titova and Ferhadija streets). The cables must be of the following types and cross-sections:","m",4400,null,{"$f":"D54*E54","v":0}]
[null,"-PP00-Y 3x2.5 mm2.",null,null,null,0]
["3.3","Delivery and installation of rigid 20 mm PNT pipes for laying of cables on the facades of buildings (on the section between the junction box - beginning of the tension cable). The price includes clights and couplings. The PNT pipes must be installed at a height of 8-16 meters with the use of a suitable truck crane. All works on the installation of PNT pipes are to be performed at night, in the period from 00:00 to 05:00. Before submitting a bid, it is necessary to make a detailed review of the PNT pipes laying routes (Titova and Ferhadija streets).Complete set","m",2120,null,0]
["3.4","Delivery and installation of pass-through junction boxes which are installed on the facades of buildings in positions where there already were existing lights. Surface mounted installation, IP66, with a minimum of 4 cable glands, together with all necessary elements (cable clights).\nComplete set","pcs",175,null,0]
["3.5","Delivery and installation of hard connecting elements, for cable - suspension cable connection, together with all the necessary elements for connection and installation. They need to be resistant to external influences (weather, temperatures, etc.).\nComplete set","pcs",1958,null,0]
["3.6","Dismantling and relocation of existing electrical installations and lights which are within the project. The calculation must take into account all the necessary equipment, materials and vehicles (cranes for work at a height of up to 16 meters, vehicles for the removal of materials, etc.). The item also includes the disposal of equipment on site at the request of the investor (on the territory of the Sarajevo Canton).\nCalculation per dismantled light. The calculation must also take into account the night work. All work on the dismantling of existing lights and cables is to be performed at night, in the period from 00:00 to 05:00.\nBefore submitting an offer, it is necessary to make a detailed review of the routes and places of dismantling of lights (Titova and Ferhadija streets).","pcs",58,null,0]
["3.7","Dismantling of existing poles which are up to 8 meters high. The price must also include the dismantling of lights, and the removal of poles and lights to a location determined by the Investor (the Sarajevo Canton). The price must also include the dismantling of the concrete foundation on which the pole is installed, with non-destructive extraction of power cables and their protection before they are inserted into the new foundation, which is to be installed in the same position. Given that access is denied to external service parts of restaurants and cafes where a certain number of poles are situated, the price should also include talking to the owners of those restaurants and cafés, seeking and obtaining the necessary permits and possible relocation of certain elements or complete mobile parts of restaurants and cafes to allow free access to existing poles. Complete set","pcs",6,null,0]
["3.8","Other small material.","lump sum",1,null,0]
["3.9","It is necessary to carry out the necessary tests of the performed electrical installations after the completion of works (protection against contact of live parts, grounding) and provide test protocols. ","lump sum",1,null,0]
["3.10.","It is necessary to perform illumination measurement for the routes on which the reconstruction was carried out after the completion of the works and submit the protocols on the performed measurements.","lump sum",1,null,0]
[null,"TOTAL lights:",null,179]
[null,"TOTAL BAM:",null,null,null,{"$f":"SUM(F16:F63)","v":0}]
[null,"DISCOUNT (%)",null,0,null,{"$f":"F65*D66","v":0}]
[null,"17% VAT",null,null,null,{"$f":"(F65-F66)*0.17","v":0}]
[null,"GRAND TOTAL BAM:",null,null,null,{"$f":"(F65-F66)+F67","v":0}]

{"sheet":"2. Civil works","index":1,"n_rows":85,"n_cols":6,"rows_kept":85,"cut":false,"hidden":false,"merged":[[1,1,3,1],[1,2,1,5],[2,2,2,5],[3,2,3,5],[5,0,5,5],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[11,1,11,5],[63,1,63,4],[12,1,12,5],[65,0,76,0],[10,1,10,5],[30,1,30,4],[61,1,61,4],[14,0,29,0],[31,0,60,0]]}
[null,"SPECIFICATION OF MATERIALS"]
[null,null,"Subject:"]
[]
[null,null,"Location: City of Sarajevo"]
[]
["City of Sarajevo - Reconstruction of part of the public lighting system - Maršala Tita and Ferhadija Streets"]
[]
[null,null,"Unit","Qty","Unit","BAM"]
[null,"Description of Works"]
[]
["B","CONSTRUCTION PART"]
[null,"NOTE:\n\n The potential contractor must review the project documentation, and visit all positions of primary tension 1 - 44, and secondary suspension. It was agreed with the project coordinator that the unit price of the primary and secondary suspension should include all the necessary fittings, connection accessories, anchor bolts - anchoring for various wall structures, suspension cables - stainless steel ropes, all of AISI 316 class quality. The following is required:\n\n - Rope - suspension cables quality - steel, \"INOX\" rope, structure 7x19 mm, class AISI 316\n- The breaking strength of the rope is 1570 N / mm2\n- Modulus of elasticity E = 145 to 170 Gpa\n\n All details must be agreed with the design team before installation, after which a written approval will be issued for all technical details.\n\nThe calculation must envisage 200/300/14 mm anchor plates, 8 anchor bolts M 12 - types necessary for various materials in the wall structure. It is necessary to prepare \"suspension\" for the cable on the anchor plates. The whole position must be \"hot-dip galvanized\".\n\nUnit prices must provide for movable scaffolding, cranes, hand tools, protective equipment, cleaning and removal, restoring damaged parts of facades to their original condition, etc. Everything must comply with the requirements of the investor.\n"]
[null,"In order to confirm that the required quality characteristics are satisfied, it is necessary to enclose the following:\n• For poles: Certificate of compliance with EN 40\n• For steel ropes: Certificate of conformity to standard EN 12385-4 and quality class AISI 316\n• For MB 30 concrete foundations: Certificate according to BAS EN 206 + A1: 2018\nCertificates, and reports can be submitted in one of the official languages of BiH or in English."]
[]
[1,"Production of the primary suspension at a height of approx. 10 m in Titova Street, using Ø 8 mm suspension cables  by positions: (measurements are in \"m\"). The suspension cables are of the following lengths:"]
[null,"1. Length 29.20","m",29.2,null,{"$f":"D16*E16","v":0}]
[null,"2. Length 16.50","m",16.5,null,{"$f":"D17*E17","v":0}]
[null,"3. Length 17.00","m",17,null,0]
[null,"4. Length 18.00","m",18,null,0]
[null,"5. Length 19.20","m",19.2,null,0]
[null,"6. Length 21.75","m",21.75,null,0]
[null,"7. Length 18.60","m",18.600000000000001,null,0]
[null,"8. Length 19.50","m",19.5,null,0]
[null,"9. Length 25.90","m",25.9,null,0]
[null,"10. Length 26.10","m",26.1,null,0]
[null,"11. Length 20.90","m",20.9,null,0]
[null,"12. Length 21.30","m",21.3,null,0]
[null,"13. Length 21.70","m",21.7,null,0]
[null,"14. Length 22.10","m",22.1,null,0]
[null,"15. Length 25.10","m",25.1,null,0]
[null,"Total 1:",null,null,null,{"$f":"SUM(F16:F30)","v":0}]
[2,"Production of the primary suspension at a height of approx. 6 m in Ferhadija Street, using Ø 8 mm suspension cables by positions: (measurements are in \"m\"). The suspension cables are of the following lengths:"]
[null,"16. Length 22.10","m",22.1,null,{"$f":"D33*E33","v":0}]
[null,"17. Length 25.10","m",25.1,null,{"$f":"D34*E34","v":0}]
[null,"18. Length 10.60","m",10.6,null,0]
[null,"19. Length 11.90","m",11.9,null,0]
[null,"20. Length 11.50","m",11.5,null,0]
[null,"21. Length 11.90","m",11.9,null,0]
[null,"22 Length 9.45","m",9.4499999999999993,null,0]
[null,"23 Length 08.90","m",8.9,null,0]
[null,"24 Length 09.50","m",9.5,null,0]
[null,"25 Length 08.90","m",8.9,null,0]
[null,"26. Length 10.90","m",10.9,null,0]
[null,"27. Length 10.50","m",10.5,null,0]
[null,"28 Length 11.50","m",11.5,null,0]
[null,"29 Length 10.65","m",10.65,null,0]
[null,"30 Length 11.00","m",11,null,0]
[null,"31 Length 12.00","m",12,null,0]
[null,"32 Length 10.20","m",10.199999999999999,null,0]
[null,"33 Length 9.00","m",9,null,0]
[null,"34 Length 8.70","m",8.6999999999999993,null,0]
[null,"35 Length 8.70","m",8.6999999999999993,null,0]
[null,"36 Length 8.70","m",8.6999999999999993,null,0]
[null,"37 Length 8.70","m",8.6999999999999993,null,0]
[null,"38 Length 8.70","m",8.6999999999999993,null,0]
[null,"39 Length 13.70","m",13.7,null,0]
[null,"40 Length 13.70",null,13.7,null,0]
[null,"41 Length 9.10","m",9.1,null,0]
[null,"42 Length 8.70","m",8.6999999999999993,null,0]
[null,"43 Length 09.30","m",9.3000000000000007,null,0]
[null,"44 Length 08.90","m",8.9,null,0]
[null,"Total 2:",null,null,null,{"$f":"SUM(F33:F55)","v":0}]
[]
[null,"TOTAL 1-2 (BAM):",null,null,null,{"$f":"F62+F31","v":0}]
[]
[3,"Production of self-standing foundations - foundation feet, made from the MB 30 concrete with reinforcements Bst 500 S.\nSteel poles such as \"Philips - conica 30080\" or equivalent. The primary suspension cables will be fixed to the poles. The poles are marked S1 and S2.\nThe dimensions of the foundation feet are: foot 220/200/45 cm, \"neck\" 60/60/45 cm.\nIt is necessary to install the PVC pipe Ф 50-60mm in the foundation for the passage of cable and the FeZn strip. Installation of foundation-anchor bolts using templates.\nThe price must include all items of works, cutting of asphalt (or other surfaces), excavation, loading and removal to the landfill, underlying concrete, concrete and foundation feet, reinforcements and anchors - according to the type of the pole, backfilling and restoring the upper surface to its original condition."]
[null,"- Cutting the asphalt surface","m²",4.4000000000000004,null,{"$f":"D67*E67","v":0}]
[null,"- Excavation category III","m³",4.2,null,{"$f":"D68*E68","v":0}]
[null,"- Underlying concrete which is 5 cm thick, MB 20","m²",4.4000000000000004,null,0]
[null,"- MB 30 concrete, in excavation without formwork","m³",2,null,0]
[null,"- Concrete MB 30, in external formwork","m³",0.2,null,0]
[null,"- Reinforcements, Bst 500 S","kg",200,null,0]
[null,"- Anchors, made of reinforcement Ø 25 mm, Bst 500 S","kg",20,null,0]
[null,"- Backfilling and restoration","lump sum",1,null,0]
[]
[null,"Total for one (1) foundation (BAM):","set",1,null,{"$f":"SUM(F67:F75)","v":0}]
[null,"TOTAL FOR SEVEN (7) FOUNDATIONS (BAM):","pcs",7,{"$f":"F76","v":0},{"$f":"D77*E77","v":0}]
[]
[4,"Control testing for \"breaking\" of anchor bolts, using in situ method in different materials, stone, concrete and two different types of bricks, solid and hollow. The focus of the test is on the bricks. The test may be performed by an authorized institution. It is necessary to agree the test positions with the designer and the supervisor of the investor.\n","pcs",22,null,{"$f":"D79*E79","v":0}]
[]
[]
[null,"TOTAL BAM:",null,null,null,{"$f":"F64+F77+F79","v":0}]
[null,"DISCOUNT (%)",null,0,null,{"$f":"F82*D83","v":0}]
[null,"17% VAT",null,null,null,{"$f":"(F82-F83)*0.17","v":0}]
[null,"GRAND TOTAL BAM:",null,null,null,{"$f":"(F82-F83)+F84","v":0}]

{"sheet":"RECAP","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,0,11,6],[0,0,6,1],[0,2,0,6],[1,2,6,2],[1,3,2,6],[3,3,4,6],[5,3,6,6],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,3],[10,4,10,6],[12,0,12,1],[12,2,12,3],[12,4,12,6],[13,0,13,1],[13,2,13,3],[13,4,13,6],[14,0,14,6],[15,0,15,1],[15,2,15,3],[15,4,15,6],[16,0,16,1],[16,2,16,3],[16,4,16,6],[23,0,23,6],[24,0,24,6],[17,0,17,1],[17,2,17,3],[17,4,17,6],[19,0,19,6],[21,0,21,6],[22,0,22,6]]}
[null,null,"SUMMARY RECAPITULATION OF WORKS"]
[null,null,null,"CONSTRUCTION SITE: \"FERHADIJA-TITOVA\" SARAJEVO"]
[]
[null,null,null,"SUBJECT: \n Delivery of LED lights"]
[]
[]
[]
[]
[]
["RECAPITULATION OF WORKS"]
[{"$nulls":4},"TOTAL"]
[]
["I",null,"Electrical works",null,{"$f":"'1.  LED JR-Electrical'!F65","v":0}]
["II",null,"Civil works",null,{"$f":"'2. Civil works'!F82","v":0}]
[]
[null,null,"TOTAL (excluding VAT) BAM:",null,{"$f":"SUM(E13:G14)","v":0}]
[null,null,"VAT 17% BAM:",null,{"$f":"0.17*E16","v":0}]
[null,null,"TOTAL (including VAT) BAM:",null,{"$f":"SUM(E16:G17)","v":0}]
[]
["IMPORTANT : Regarding the bill of quantities for required materials, equipment and devices:"]
[]
["• Brands / Manufacturers / Models / Types in the bill of quantities are given as a recommendation only."]
["• Bidders may offer materials, devices and equipment of equivalent characteristics / performance /"]
["specification. (or better). Pay special attention to the dimensions of the equipment, because it is installed in "]
["existing, non-dedicated space."]