{"text_format":"5","workbook":"xlsx","n_sheets":1,"sheets":["PL Banja Luka - BoQ "],"props":{"creator":"Darkec-HP","last_modified_by":"Elvis Hadzikadic"},"custom":{"ContentTypeId":"0x010100387FA97CA5D44542AF8049F70420372C"},"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"PL Banja Luka - BoQ ","index":0,"n_rows":125,"n_cols":6,"rows_kept":125,"merged":[[0,0,6,0],[0,1,0,5],[1,1,6,1],[1,2,2,5],[3,2,4,5],[5,2,6,5],[11,1,11,5],[12,1,12,5],[14,1,14,4],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,0,88,0],[90,0,107,0],[109,0,110,0],[113,0,114,0],[121,1,121,2],[122,1,122,2],[123,1,123,2],[124,1,124,2],[128,3,128,5]]}
[null,"BoQ FOR MATERIAL AND WORKS"]
[null,null,"CONSTRUCTION SITE:        \nCity of Banja Luka                                 "]
[]
[null,null,"SUBJECT: EE Reconstruction of the part of the public lighting system                                  "]
[]
[null,null,"DATE: "]
[]
[]
[null,null,"Unit","Quantity","Unit price","BAM"]
[null,"Description of works:"]
[]
["I","PREPARATORY WORKS/DISASSEMBLY OF THE EXISTING LIGHTS"]
[null,"Works on the disassembly of the old lights include the disassembly of the existing lights, their loading onto trucks and transport to a location designated by the supervisory body (storage up to 10 km away).\nPrior to development of the bid, the bidder must review the scope of works and envisaged technical solutions by means of review of the technical documentation or by means of consulting with the investor and the designer."]
[1,"Disassembly of the existing lights, transport and logbook-confirmed delivery at the storage facility in \"Rakovacke bare\" location.","pcs.",{"v":1503,"d":"1,503"},null,{"$f":"D14*E14","v":{"v":0,"d":"0.00"}}]
[null,"Total I / PREPARATORY WORKS / DISASSEMBLY OF THE EXISTING LIGHTS:",{"$nulls":3},{"$f":"SUM(F14)","v":{"v":0,"d":"0.00"}}]
[]
["II","INSTALLATION OF NEW LED LIGHTS"]
[null,"Works on the installation of the new lights include procurement, supply and assembly of the new lights, including all of the works, equipment and material up to full functioning of the newly installed lights.\nPrior to development of the bid, the bidder must review the scope of works and envisaged technical solutions by means of review of the technical documentation or by means of consulting with the investor and the designer.\nThe method for the installation of lights including the types, characteristics, appearance and the schedule are given by the designer and the investor."]
[null,"REQUIRED CHARACTERISTICS OF LIGHTS FOR ALL TYPES.\n• Every light/lamp must be supplied with installed light source, all of the modules and equipment necessary for operation, suspension accessories and other belonging equipment.. \n• Depending on the type, lights must satisfy general characteristics of road or residential lights.\n• Upper and lower part of the light housing  must be made out of aluminum alloy cast under pressure, with anti-corrosion coating, painted with electrostatic procedure and manufactured so that electrical and optical units are physically separated.\n• Lower part of the housing must have a profiled silicone or rubber sealing gasket that ensures appropriate degree of protection of the part of housing with the electronic control gear (electronic ballast). \n• Protector made of tempered glass resistant to UV radiation, weather and temperature dilatation,\n• All of the applied screws, nuts and washers must be made of stainless steel or other equally corrosion resistant material.\n• Light assembly system: horizontally to the console with diameter Ø 42-60mm.\n• Optical block: Shaded - full cutoff with ULOR = 0%.\n• Temperature of the light color: 3700K-4300K (NW-neutral white).\n• Mechanical impact resistance of the light IK08, in accordance with IEC-EN 62262.\n• Sealing degree (optical part and the control gear part) min. IP65, in accordance with IEC-EN 60598\n• Minimum life of the light source: 100,000 hours. \n• Light flux of the light source at 100% load after 100,000 hours min. 70% of initial flux (L70/B10).\n• Color reproduction index: Ra ≥ 70.\n• Luminescence class min. G4.\n• Efficiency of the light ≥ 105 lm/W.\n• Power supply: 230 VAC ± 10%, 50/60 Hz. \n• Power factor: for 100% load: min. cos φ ≥ 0,95.  \n• Electrical protection class: II.\n• Overvoltage/current protection: 4 kV.\n• Overvoltage protection must have a fuse for load separation at the end of the life.\n• Operating temperature should be within -40 ͦC to +35 ͦC.\n• Minimum waranty period: 5 years."]
[null,"In order to confirm that required characteristics are met, following is to be submitted for every type of offered light:\n- Technical specification of the product with the image of the product, which must contain information on all technical parameters required in the tender documentation - original copy certified by the manufacturer/supplier.\n- Declaration of compliance with the CE mark, issued by the manufacturer.\n- Declaration of compliance with the RoHS and WEEE directives, issued by the manufacturer.\n- ENEC certificate, EMC certificate\n- Safety certificate according to EN 62471 standard, vibration resistance testing report, photometric report, maps ''Life B10\" according to EN 67222, corrosion resistance testing according to EN ISO 9227.\n- Impact resistance testing report (IK test) according to the EN 62262 standard..\n- Mechanical protection testing report (IP test) according to the EN 60598-1 standard.\n- Photometric report issued by the manufacturer for the light in question, according to the LM79-08, CIE 121-1996 and  EN 13032-1 standards, or certificates issued by an appropriate certification laboratory, proving the required photometric properties of the light.\n- Report issued by the manufacturer of the LED chips or LED lights on the expected lifetime and maintaining of the light flux according to the LM70/TM21 standards.\n- Corrosion resistance testing report according to the EN 60068 standard.\n\nCertificates and reports for the lights can be submitted in one of official languages in Bosnia and Herzegovina or in English language.\nIn order to check whether the technical requirements for light are met, it is necessary to provide name of the manufacturer, exact name of the product, model and type of the product, for every offered type of light, and provide a separate CD with appropriate LTD and IES files with the manufacturer ‘s names for the model and type."]
[2,"Procurement, supply and installation of the LED light TYPE-1,\n• Total power of the light: max 30W, \n• Usable light flux: min 3.000lm (at Ta=25°C),\n• Focus of the optical block: type M (medium width of the beam focus).\nManufacturer, type, model (fill in):__________________________________","pcs.",1076,null,{"$f":"D21*E21","v":{"v":0,"d":"0.00"}}]
[null,"Ul. Manastira Mostanice",null,8]
[null,"Ul. Petra Radjenovica",null,8]
[null,"Ul. Radoslava Lakica",null,3]
[null,"Ul. Ranka Sipke",null,47]
[null,"Ul. Vozdovacka",null,29]
[null,"Ul. Zivojina Preradovica",null,11]
[null,"Ul. Federika Garsije Lorke",null,7]
[null,"Ul. Nedeljka Cubrinovica",null,7]
[null,"Ul. Pave Radana",null,17]
[null,"Ul. Petra Radjenovica",null,7]
[null,"Ul. Tarasa Sevcenka",null,9]
[null,"Ul. Brace i sestara Glumac",null,9]
[null,"Ul. Relje Krilatice",null,11]
[null,"Ul. Save Kovačevića",null,37]
[null,"Ul. Urosa Predica",null,7]
[null,"Ul. Patrijarha Arsenija Carnojevica",null,14]
[null,"Ul. Stevana Bulajica",null,32]
[null,"Ul. Milana Vasica",null,12]
[null,"Ul. Frana Supila",null,32]
[null,"Ul. Caire",null,10]
[null,"Ul. Branka Zagorca",null,6]
[null,"Ul. Maksima Gorkog",null,58]
[null,"Ul. Nikole Bokana",null,10]
[null,"Ul. Krajiska",null,12]
[null,"Ul. Ilije Grbica",null,11]
[null,"Ul. Rade Marjanca",null,9]
[null,"Ul. Moslovacka",null,10]
[null,"Ul. Igmanska",null,7]
[null,"Ul. Romanijska",null,20]
[null,"Ul. Davida Strpca",null,33]
[null,"Ul. Natalije Jovic",null,4]
[null,"Ul. Leskovacka",null,4]
[null,"Ul. Dalibora Dace Stojica",null,4]
[null,"Ul. Fruskogorska",null,11]
[null,"Ul. Dr Velimira Covica",null,8]
[null,"Ul. Vojvode Sindjelica",null,24]
[null,"Ul. Novosadska",null,5]
[null,"Ul. Vojvođanska",null,15]
[null,"Ul. Sumadijska",null,4]
[null,"Ul. Marka Lipovca",null,40]
[null,"Ul. Petra Pecije",null,11]
[null,"Ul. Plitvicka",null,4]
[null,"Ul. Stojana Jankovica",null,61]
[null,"Ul. Vladimira Zvonara",null,4]
[null,"Ul. Ilije Smiljanica",null,8]
[null,"Ul. Alekse Dundica",null,4]
[null,"Ul. Brace Sola",null,5]
[null,"Ul. Mirjane Jotanovic",null,5]
[null,"Ul. Save Tekelije",null,9]
[null,"Ul. Majora Drage Bajalovica",null,8]
[null,"Ul. Radovana Vulina",null,11]
[null,"Ul. Hajduk Veljka",null,13]
[null,"Ul. Vasilija Ostroskog",null,13]
[null,"Ul. Kajmakcalanska",null,6]
[null,"Ul. Vojvode Prijezde",null,44]
[null,"Ul. Zmaj Ognjenog Vuka",null,61]
[null,"Ul. Milana Mirica",null,5]
[null,"Ul. Milutina Bojica",null,9]
[null,"Ul. Monahinje Jefimije",null,7]
[null,"Ul. Milosa Popovica",null,9]
[null,"Ul. Mojkovacka",null,31]
[null,"Ul. Sretena Stojanovica",null,14]
[null,"Ul. Dubicka",null,79]
[null,"Ul. Mire Cikote",null,10]
[null,"Ul. Luke Vukalovica",null,7]
[null,"Ul. Serdara Janka Vukotica",null,7]
[null,"Ul. Marsala Zukova",null,5]
[null,"Ul. Paje Jovanovica",null,14]
[]
[3,"Procurement, supply and installation of the LED light TYPE-2,\n• Total power of the light: max 39W, \n• Usable light flux: min 4.600lm (at Ta=25°C),\n• Focus of the optical block : type M (medium width of the beam focus).\nManufacturer, type, model (fill in):_____________________________\nLights are installed in parts of the following streets:","pcs. ",275,null,{"$f":"D91*E91","v":{"v":0,"d":"0.00"}}]
[null,"Ul. Dragise Vasica",null,13]
[null,"Ul. Jovana Ducica",null,20]
[null,"Ul. Srpskih pilota",null,11]
[null,"Ul. Vozdovacka",null,2]
[null,"Ul. Slobodana Jovanovića",null,14]
[null,"Ul. Beogradska",null,9]
[null,"Ul. Djure Djakovica",null,22]
[null,"Ul. Sumadijska",null,15]
[null,"Ul. Marka Lipovca",null,12]
[null,"Ul. Petra Pecije",null,18]
[null,"Ul. Kraljice Marije",null,22]
[null,"Ul. Milana Cvijetica",null,21]
[null,"Ul. Vasilija Ostroškog",null,12]
[null,"Ul. Kojića put",null,14]
[null,"Ul. Vojvode Prijezde",null,48]
[null,"Ul. Ivana Kosancica",null,11]
[null,"Ul. Milana Mirica",null,11]
[]
[4,"Procurement, supply and installation of the LED light TYPE-3,\n• Total power of the light: max 57W, \n• Usable light flux: min 6.100lm (at Ta=25°C),\n• Focus of the optical block: type M (medium width of the beam focus).\nManufacturer, type, model (fill in):______________________________\nLights are installed according in the  parts of the path in the following streets:","pcs.",53,null,{"$f":"D110*E110","v":{"v":0,"d":"0.00"}}]
[null,"Street. Zmaj Ognjenog Vuka","pcs.",53]
[]
[]
[5,"Procurement, supply and installation of the LED light TYPE-4,\n• Total power of the light: max 97W, \n• Usable light flux : min 13.800lm (at Ta=25°C),\n• Focus of the optical block : type M (medium width of the beam focus).\nManufacturer, type, model (fill in):_______________________________\nLights are installed according in the  parts of the path in the following streets:",null,100,null,{"$f":"D114*E114","v":{"v":0,"d":"0.00"}}]
[null,"Expressway, from the roundabout to the Prijedor loop","pcs.",100]
[]
[]
[6,"Procurement and installation of the connecting cable type PP00 3x2,5mmPP00 3x2,5mm2  for additional wiring (where necessary).\nSurplus unused cable should be placed at warehouse according to investor’s orders.","m",{"v":1000,"d":"1,000"},null,{"$f":"D118*E118","v":{"v":0,"d":"0.00"}}]
[7,"Minor installation accessories, insulation tape, cable glands in case of replacement of the cable from the connection board to the light.","Lump sum",1,null,{"$f":"D119*E119","v":{"v":0,"d":"0.00"}}]
[8,"Perform all the necessary tests of the touch voltage and establish test protocols.  ","Lump sum",1,null,{"$f":"D120*E120","v":{"v":0,"d":"0.00"}}]
[9,"Perform tests of illumination after the end of works and submit protocols on performed measurements.","Lump sum",1,null,{"$f":"D121*E121","v":{"v":0,"d":"0.00"}}]
[null,"TOTAL BAM:",{"$nulls":3},{"$f":"SUM(F118:F121,F114,F110,F91,F21,F15)","v":{"v":0,"d":"0.00"}}]
[null,"DISCOUNT (%)",null,{"v":0,"d":"0%"},null,{"$f":"F122*D123","v":{"v":0,"d":"0.00"}}]
[null,"VAT (17%):",{"$nulls":3},{"$f":"(F122-F123)*0.17","v":{"v":0,"d":"0.00"}}]
[null,"GRAND TOTAL BAM:",{"$nulls":3},{"$f":"(F122-F123)+F124","v":{"v":0,"d":"0.00"}}]