{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Total","1. Hydromechanical equipment","2. Water supply connection","3. Pumping station","4. Settling basin with grid","5. SBR_basin","6. Control house","7. Sanitary sewer","8. Electrical","9. Automation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"Total","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,4],[0,0,0,5],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4]]}
["TOTAL SUMMARY "]
[]
["I. HYDROMECHANICAL EQUIPMENT"]
["II. WATER SUPPLY CONNECTION "]
["III. PUMPING STATION"]
["IV. SETTLING BASIN WITH GRID "]
["V. SBR BASIN"]
["VI. CONTROL HOUSE"]
["VII. SANITARY SEWER SYSTEM"]
["VIII. ELECTRICAL INSTALLATIONS "]
["IX. AUTOMATION"]
[]
[]
["TOTAL: ",{"$nulls":4},"0.00"]

{"sheet":"1. Hydromechanical equipment","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[11,0,15,0],[25,0,25,4],[16,0,17,0],[0,0,0,5],[1,0,1,5],[4,0,4,5]]}
[" BILL OF QUANTITIES"]
["For hydromechanical equipment"]
[]
["No.","DESCRIPTION OF THE ITEM  ","Unit measure","Quantity","Unit price","Total"]
["Hydromechanical equipment"]
[1,"Purchase, transport and installation of automatic grid with electric motor with power of 3,00 kWh, fully in accordance with engineer drawing","piece",1,null,{"$f":"D6*E6","v":0}]
[2,"Purchase of submersible pump for waste water with characteristics:   Q=0-350 (l/min), H=10,4-3,2 (m), N=0,55 KW  and all necessary fitting parts with installation and rails.  Calculation per piece, purchased and installed pump.  See drawings. ","piece",5,null,{"$f":"D7*E7","v":0}]
[3,"Purchase of submersible pump for silt with characteristics:   Q=100-650 (l/min), H=11,5-1,0 (m), N=1,50 KW and all necessary fitting parts with installation and rails.  Calculation per piece, purchased and installed pump.  See drawings. ","piece",2,null,{"$f":"D8*E8","v":0}]
[4,"Purchase of centrifugal pump with characteristics:  Q=50-260 (l/min), H=34-17,5 (m), N=1,30 KW and all necessary fitting parts with installation.  Calculation per piece, purchased and installed pump.  See drawings. ","piece",1,null,0]
[5,"Purchase, transport and installation of an air compressor with motor power of 2.2 kW.","piece",2,null,0]
[6,"Purchase, transport and installation of a micro filtration system with structure dimensions 2.0х2.4х1.5 m, made of steel profiles 50/50/5 mm, with adequate protection, with built-in lamellar micro filters with a total capacity of 10 m3/h, with filtration pores of 0.01 mm made of polyvinylidene difluoride (PVDF)","piece",1,null,{"$f":"D11*E11","v":0}]
[7,"Purchase, transport and installation of PE100 pipes PN 10 bar with joint materials, fitting parts, etc.  Calculation per 1m of installed and tested pipe.  "]
[null," - HDPE OD32mm","m",20,null,{"$f":"D13*E13","v":0}]
[null," - HDPE OD50mm","m",30,null,{"$f":"D14*E14","v":0}]
[null," - HDPE OD75mm","m",10,null,{"$f":"D15*E15","v":0}]
[null," - HDPE OD110mm","m",22,null,{"$f":"D16*E16","v":0}]
[8,"Purchase, transport and installation of stainless steel pipes PN 10 bar with joint materials, fitting parts, etc.  Calculation per 1m of installed and tested pipe.  "]
[null," - DN 60,3/2 mm","m",5,null,{"$f":"D18*E18","v":0}]
[9,"Purchase and transport of plastic barrel with capacity of 100l, with sodium hypochlorite solution 500-1000 ppm, set with dispenser ","piece",1,null,0]
[10,"Purchase, transport and installation of water meter DN50mm ","piece",1,null,0]
[11,"Purchase, transport and installation of gate valve DN80 mm, PN10 bar","piece",2,null,0]
[12,"Purchase, transport and installation of float – level meter for wastewater ","piece",3,null,0]
[13,"Purchase, transport and installation of electromagnetic valve DN80 mm","piece",2,null,0]
[14,"Purchase, transport and placement of a container ","piece",1,null,0]
[15,"Purchase and transport of 3000 L (3m3) aerobic granular microorganisms for the purpose of faecal sludge treatment with included manual for use of the starter culture. The aerobic granules (AG) are to contain at least 109 Cfu/mL (submit a lab report).  A report on the microbiological composition of the AG solution is to be submitted together with the delivery of the AG. The pH value of the aerobic microbial culture must not be higher than 8.5. AG must be capable of degrading cellulose (toilet paper), detergent, soap, hygiene products (washing powders), etc.  AG must not endanger the environment,  contain harmful substances, heavy metals and other hazardous substances, endanger the health of people, animals and plants, contain harmful materials. In case of an accident, to provide guarantee for the possibility of delivery of AG in the next 5 years. ",null,1,null,0]
["Total hydromechanical equipment:",{"$nulls":4},{"$f":"SUM(F6:F25)","v":0}]

{"sheet":"2. Water supply connection","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,0,8,5],[24,0,24,4],[0,0,0,5],[1,0,1,5],[10,0,12,0],[23,0,23,4],[4,0,4,5],[5,0,5,5],[7,0,7,4],[17,0,18,0]]}
[" BILL OF QUANTITIES"]
["for water supply connection"]
[]
["No.","DESCRIPTION OF THE ITEM  ","Unit measure","Quantity","Unit price","Total"]
["WATER SUPPLY SYSTEM "]
["Connection"]
[1,"Making a connection to an existing water supply system, set with valve F32 mm and а holderbat","piece",1,null,{"$f":"D7*E7","v":0}]
["Total :",{"$nulls":4},{"$f":"SUM(F7)","v":0}]
["External water supply system"]
[1,"Marking the route for the excavation of a trench","m'",33.1,null,{"$f":"D10*E10","v":0}]
[2,"Combined excavation category III and IV, for the purpose of laying pipeline in a trench with width of up to 0,80m and depth of 0-2.0m                                                total V=31,78m3 of which:                                                            "," "," ",null," "]
[null,"mechanical 80%","m3",{"$f":"0.8*31.78","v":25.424000000000003},null,{"$f":"D12*E12","v":0}]
[null,"manual 20%","m3",{"$f":"0.2*31.78","v":6.3560000000000008},null,{"$f":"D13*E13","v":0}]
[3,"Planning of the bottom of the trench with accuracy of ±2сm","m2",{"$f":"D10*0.8","v":26.480000000000004},null,{"$f":"D14*E14","v":0}]
[4,"Purchase and spreading of sand on the bottom of the trench with thickness of 10cm.","m3",{"$f":"D10*0.8*0.1","v":2.6480000000000006},null,{"$f":"D15*E15","v":0}]
[5,"Backfilling of the trench in layers of up to 30 cm above the pipe crown with sand, by manual compaction.","m3",{"$f":"0.33*0.8*D10","v":8.7384000000000004},null,0]
[6,"Finalization of the backfilling of the trench in 30 cm layers with gravel and sand (from a natural source or crushed), with manual or mechanical compaction.","m3",{"$f":"31.78-(D15+D16)","v":20.393599999999999},null,0]
[7,"Purchase, transport and installation of PE100 pipes PN 10 bar with joint materials, fitting parts, etc.  Calculation per 1m of installed and tested pipe.  "]
[null," - HDPE OD32mm","m",{"$f":"D10","v":33.1},null,{"$f":"D19*E19","v":0}]
[8,"Disinfection and hydraulic testing of the pipeline","m",{"$f":"D19","v":33.1},null,{"$f":"D20*E20","v":0}]
[9,"Transport of the excess earth from the trench to a landfill that is up to 10km away.","m3",{"$f":"D15+D16","v":11.386400000000002},null,0]
[10,"Purchase and installation of a yard hydrant f1” set with oval cap made of cast iron. Calculation per installed piece.","piece",1,null,0]
[11,"Complete making of water meter manhole with dimension 1,0 х 1,2 (internal) with wall thickness of 15cm and depth 1,2 m.  The planning of the manhole should include installation of two gate valves F3/4” and water meter F3/4”. Installation of a lid F600 mm should be planned","piece",1,null,0]
["Total:",{"$nulls":4},{"$f":"SUM(F10:F23)","v":0}]
["Total water supply system:",{"$nulls":4},{"$f":"F24+F8","v":0}]

{"sheet":"3. Pumping station","index":3,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,0,90,4],[65,1,68,1],[69,1,74,1],[75,1,79,1],[80,1,83,1],[84,1,88,1],[89,0,89,4],[53,0,53,4],[54,0,54,3],[55,1,58,1],[59,1,64,1],[34,1,38,1],[39,1,43,1],[44,1,47,1],[29,1,33,1],[4,0,4,1],[5,1,9,1],[0,0,0,5],[1,0,1,5],[13,1,17,1],[18,1,22,1],[23,1,26,1],[27,0,27,4],[28,0,28,1]]}
["BILL OF QUANTITIES"]
["for Pumping station "]
[]
["No.","DESCRIPTION OF THE ITEM  ","Unit measure","Quantity","Unit price","Total"]
["                 I. Earth works",null," "," "," "," "]
[1,"Mechanical excavation and manual finalisation of the excavation category III from the foundation pit of the wet well with placing the earth around the pit and pushing it with a pusher tractor up to 50m. Calculation per m3 of excavated earth. "," "," "," "," "]
[" ",null," "," "," "," "]
[" ",null," "," "," "," "]
[" ",null," "," "," "," "]
[" ",null," "," "," "," "]
[" ","Total excavation V =20.7 m3"," "," "," "," "]
["     ","Mechanical excavation 80%V","m3",{"$f":"20.7*0.8","v":16.559999999999999},null,{"$f":"D12*E12","v":0}]
["            ","Manual finalisation of the excavation        20% V","m3",{"$f":"20.7*0.2","v":4.1399999999999997},null,{"$f":"D13*E13","v":0}]
[2,"Spreading of the sand and gravel at the bottom of the well for a 30 cm thick sub-base by compaction of the material. Calculation per m3 of used material."," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null,"m3",1.47,null,{"$f":"D18*E18","v":0}]
[3,"Mechanical and manual backfilling of the well after the laying of the pipes with the excavated earth by compaction in up to 50 cm thick layers. Calculation per m3 of backfilled and compacted earth. "," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null,"m3",10.1,null,{"$f":"D23*E23","v":0}]
[4,"Mechanical loading of the excess earth in a truck and transport to a landfill that is up to 5km away. Calculation per m3 of transported earth."," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null,"m3",10.6,null,{"$f":"D27*E27","v":0}]
["                                                                                                           Total I :",{"$nulls":4},{"$f":"SUM(F12:F27)","v":0}]
["                II. Concrete works",null," "," "," "," "]
[5,"Mechanical preparation of concrete MB10 and pouring it on the bottom of the well for flattening (sub-base d=5cm) by compaction of the concrete. Calculation per m3 of poured concrete"," "," "," "," "]
[" ",null," "," "," "," "]
[" ",null," "," "," "," "]
[" ",null," "," "," "," "]
[" ",null,"m3",0.25,null,{"$f":"D34*E34","v":0}]
[6,"Mechanical preparation of concrete MB30 and pouring it on the bottom of by forming and compaction. Calculation per m3 of poured concrete"," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null,"m3",0.98,null,{"$f":"D39*E39","v":0}]
[7,"Mechanical preparation of concrete MB30 and pouring it in the covering plate of the well by compaction of the concrete. Calculation per m3 of poured concrete"," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null,"m3",0.76,null,{"$f":"D44*E44","v":0}]
[8,"Total installed reinforcement in the bottom and the covering plate of the well. Calculation per kgr of installed iron."]
[]
[]
[]
[null,"Round bar d<12mm"]
[null,"F 8mm                    Ga-240/3600","kg",20,null,{"$f":"D50*E50","v":0}]
[null,"Ribbed bar d<12mm"," "," ",null," "]
[null,"f8 mm"," "," ",null," "]
[null,"f10mm","kg",180,null,{"$f":"D53*E53","v":0}]
["                                                                                                          Total II :",{"$nulls":4},{"$f":"SUM(F39:F53)","v":0}]
["                III. Masonry-craft works and installation works"]
[9,"Purchase of reinforced concrete elements for manhole f1500 mm, L=2,50 m. Calculation per piece, purchased and installed element"]
[" "]
[" "]
[" ",null,"pcs",1,null,{"$f":"D59*E59","v":0}]
[10,"Grouting the joints between the reinforced concrete elements of the well with two-part permanently elastic semi-sulphide putty for preventing water leakage through them   Calculation per m' of finished joint",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m'"," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null,18.84,null,{"$f":"D65*E65","v":0}]
[11,"Plastering with finishing coat of the wet well on the inside with cement mortar. Calculation per m2 of plastered inner surface of the well.","m2"," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null,31.46,null,{"$f":"D69*E69","v":0}]
[12,"Coating the inner surface of the well with elastic waterproofing material on an acrylic basis for waterproofing of the well. Calculation per m2 of coated surface.","m2"]
[]
[]
[]
[]
[null,null,null,31.46,null,{"$f":"D75*E75","v":0}]
[13,"Purchase of submersible pump for silt with characteristics:                                                                                                                                                                                                                                                                                                       Q=100-650 (l/min), H=11,5-1 (m), N=1,50 KW and all its fitting parts with installation in the wet well together with automation. Calculation per piece, purchased and installed pump.  See drawings.","pcs"]
[" "]
[" "]
[" "]
[" ",null,null,2,null,{"$f":"D80*E80","v":0}]
[14,"Purchase of manhole step irons made of round iron f20mm and installation in the well of the pumping station.  Calculation per piece, purchased and installed manhole step irons.","pcs"]
[" "]
[" "]
[" ",null,null,8,null,{"$f":"D84*E84","v":0}]
[15,"Purchase, transport and installation of rectangular lid made of cast iron 1,1x0,6m with frame and bearing capacity of 400 kN. Calculation per piece, purchased and installed lid. "," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null," "," ",null," "]
[" ",null,"pcs",1,null,{"$f":"D89*E89","v":0}]
["                                                                                                         Total III :",{"$nulls":4},{"$f":"SUM(F56:F89)","v":0}]
["                                                                                                 Grand total I- III :",{"$nulls":4},{"$f":"F90+F54+F28","v":0}]

{"sheet":"4. Settling basin with grid","index":4,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[18,1,22,1],[0,0,0,5],[1,0,1,5],[4,0,4,1],[5,1,9,1],[13,1,17,1],[65,1,68,1],[23,1,26,1],[27,0,27,4],[28,0,28,1],[29,1,33,1],[34,1,38,1],[39,1,43,1],[44,1,47,1],[53,0,53,4],[54,0,54,3],[55,1,58,1],[59,1,64,1],[92,0,92,4],[69,1,74,1],[75,1,79,1],[80,1,84,1],[85,1,89,1],[91,0,91,4]]}
[" BILL OF QUANTITIES"]
["for Settling basin with grid"]
[]
["No.","DESCRIPTION OF THE ITEM  ","Unit measure","Quantity","Unit price","Total"]
["                 I. Earth works",null," "," "," "," "]
[1,"Mechanical excavation and manual finalisation of the excavation category III from the foundation pit of the wet well with placing the earth around the pit and pushing it with a pusher tractor up to 50m. Calculation per m3 of excavated earth.  ",null," "," "," "]
[" ",null,null," "," "," "]
[" ",null,null," "," "," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ","Total excavation V =20.7 m3",null," ",null," "]
["     ","Mechanical excavation 80%V","m3",{"$f":"20.7*0.8","v":16.559999999999999},null,{"$f":"D12*E12","v":0}]
["            ","Manual finalisation of the excavation 20% V","m3",{"$f":"20.7*0.2","v":4.1399999999999997},null,{"$f":"D13*E13","v":0}]
[2,"Spreading of the sand and gravel at the bottom of the well for a 30 cm thick sub-base by compaction of the material. Calculation per m3 of used material.",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m3",1.47,null,{"$f":"D18*E18","v":0}]
[3,"Mechanical and manual backfilling of the well after the laying of the pipes with the excavated earth by compaction in up to 50 cm thick layers. Calculation per m3 of backfilled and compacted earth.  ",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m3",10.1,null,{"$f":"D23*E23","v":0}]
[4,"Mechanical loading of the excess earth in a truck and transport to a landfill that is up to 5km away. Calculation per m3 of transported earth.",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m3",10.6,null,{"$f":"D27*E27","v":0}]
["                                                                                                           Total I :",{"$nulls":4},{"$f":"SUM(F12:F27)","v":0}]
["                II. Concrete Works",null," "," "," "," "]
[5,"Mechanical preparation of concrete MB10 and pouring it on the bottom of the well for flattening (sub-base d=5cm) by compaction of the concrete. Calculation per m3 of poured concrete",null," "," "," "]
[" ",null,null," "," "," "]
[" ",null,null," "," "," "]
[" ",null,null," ",null," "]
[" ",null,"m3",0.25,null,{"$f":"D34*E34","v":0}]
[6,"Mechanical preparation of concrete MB30 and pouring it on the bottom of the well by forming and compaction. Calculation per m3 of poured concrete",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m3",5,null,{"$f":"D39*E39","v":0}]
[7,"Mechanical preparation of concrete MB30 and pouring it in the covering plate of the well by forming and compaction. Calculation per m3 of poured concrete",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m3",0.76,null,{"$f":"D44*E44","v":0}]
[8,"Total installed reinforcement in the bottom and the covering plate of the well. Calculation per kgr of installed iron."]
[]
[]
[]
[null,"Round bar d<12mm"]
[null,"F 8mm Ga-240/3600","kg",20,null,{"$f":"D50*E50","v":0}]
[null,"Ribbed bar d<12mm",null," ",null," "]
[null,"f8 mm",null," ",null," "]
[null,"ф10mm","kg",400,null,{"$f":"D53*E53","v":0}]
["                                                                                                          Total II :",{"$nulls":4},{"$f":"SUM(F39:F53)","v":0}]
["                III. Masonry-craft works and installation works"]
[9,"Purchase of reinforced concrete elements for manhole f1500 mm, L=2,50 m. Calculation per piece, purchased and installed element."]
[" "]
[" "]
[" ",null,"pcs",1,null,{"$f":"D59*E59","v":0}]
[10,"Grouting the joints between the reinforced concrete elements of the well with two-part permanently elastic semi-sulphide putty for preventing water leakage through them  Calculation per m' of finished joint",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m'",18.84,null,{"$f":"D65*E65","v":0}]
[11,"Plastering with finishing coat of the manhole on the inside with cement mortar. Calculation per m2 of plastered inner surface of the well.",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"m2",31.46,null,{"$f":"D69*E69","v":0}]
[12,"Coating the inner surface of the well with elastic waterproofing material on an acrylic basis for waterproofing of the well. Calculation per m2 of coated surface."]
[]
[]
[]
[]
[null,null,"m2",31.46,null,{"$f":"D75*E75","v":0}]
[13,"Purchase of submersible pump with impellers with characteristics:                                                                                                                                                                                                                                                                                                       Q=0-350 (l/min), H=10,4-3,2 (m), N=0,55 KW and all its fitting parts with installation in the wet well together with automation.  Calculation per piece, purchased and installed pump.  See drawings."]
[" "]
[" "]
[" "]
[" ",null,"pcs",1,null,{"$f":"D80*E80","v":0}]
[14,"Purchase, transport and installation of rectangular lid made of cast iron 0,6x0,6m with frame and bearing capacity of 400 kN. Calculation per piece, purchased and installed lid.",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"pcs",1,null,{"$f":"D85*E85","v":0}]
[15,"Purchase, transport and installation of a stainless steel bucket with dimensions 0.5х0.3х0.5 with openings f30mm installed on two steel holders",null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,null," ",null," "]
[" ",null,"pcs",1,null,{"$f":"D90*E90","v":0}]
[16,"Purchase and installation of reinforced concrete inspection manhole with height of H=2.5 m together with cast iron lid G=160 kg for heavy traffic and manhole step irons on a previously prepared 10 cm sand sub-base.","piece",1,null,{"$f":"D91*E91","v":0}]
["                                                                                                         Total III :",{"$nulls":4},{"$f":"SUM(F56:F91)","v":0}]
["                                                                                                 Grand total I- III :",{"$nulls":4},{"$f":"F92+F54+F28","v":0}]

{"sheet":"5. SBR_basin","index":5,"n_rows":104,"n_cols":6,"rows_kept":104,"cut":false,"hidden":false,"merged":[[12,2,12,4],[1,0,1,5],[2,0,2,5],[4,0,4,5],[5,0,5,5],[8,2,8,5],[38,0,39,0],[13,2,13,5],[14,0,17,0],[22,2,22,4],[23,2,23,5],[24,0,25,0],[28,0,29,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[36,2,36,4],[37,2,37,5],[79,0,80,3],[79,4,80,5],[88,0,88,2],[103,0,103,1],[40,2,40,4],[48,2,48,4],[52,2,52,4],[57,2,57,4],[73,2,73,4],[78,2,78,4]]}
[]
["BILL OF QUANTITIES "]
["CONSTRUCTION AND CONSTRUCTION - CRAFT WORKS"]
[]
["SBR BASIN"]
[]
[]
["No.","DESCRIPTION OF THE ITEM  ","Unit measure","Quantity","Unit price","Total"]
[null,"1. PREVIOUS WORKS "," "]
["1.1.","Setting and organization of a construction site according to the organization scheme by the Contractor","lump sum",1,null,{"$f":"D10*E10","v":0}]
["1.2.","Survey marking before commencement of the excavation and after the completion of the bulk excavation with planning of the bottom.  ","m2",720,null,{"$f":"D11*E11","v":0}]
["1.3.","Clearing of the existing vegetation with loading, transport and unloading with a truck to a landfill that is up to 10km away.","m2",300,null,{"$f":"D12*E12","v":0}]
[" ","                              TOTAL 1:"," ",null,null,{"$f":"SUM(F10:F12)","v":0}]
[" ","2. EARTH WORKS"," "]
["2.1.","Mechanical excavation of earth category III and IV. The dimensions are taken based on the widening of the excavation for setting of formwork and slopes against landslide.  The excavation will be performed 20% in category III and 80% in category IV.                                                                "," "," ",null," "]
[null,"Total 356,18 m3"]
[null,"·   mechanical 90%","m3",{"$f":"356.18*0.9","v":320.56200000000001},null,{"$f":"D17*E17","v":0}]
[null,"·   manual 10%","m3",{"$f":"0.1*356.18","v":35.618000000000002},null,{"$f":"D18*E18","v":0}]
["2.2.","Loading, transport and unloading of the excavated material out of the construction site. Transport to a landfill that is up to 10km away.","m3",{"$f":"356.18-(24.75+167.16+7.83)","v":156.44},null,{"$f":"D19*E19","v":0}]
["2.3.","Purchase from screening plant, loading, transport, spreading, planning and rolling of 2-5 cm granules in a 30 cm layer under the site plate.","m3",24.57,null,{"$f":"D20*E20","v":0}]
["2.4.","Purchase, loading, transport and spreading of earth to the closest borrow pit for finalization of the backfilling of the site.                                                                                                                                    "]
[null,null,"m3",167.16,null,{"$f":"D22*E22","v":0}]
[" ","                               TOTAL 2:"," ",null,null,{"$f":"SUM(F15:F22)","v":0}]
[" ","3. CONCRETE WORKS"," "]
["3.1.","Concreting a concrete base of compacted concrete MB 25 with thickness of 10 cm constructed under the foundation plates in the wet chambers and the dry chamber."," "," ",null," "]
[null,null,"m3",7.83,null,{"$f":"D26*E26","v":0}]
["3.2.","Making of reinforced concrete foundation plate d=30 cm made of waterproof concrete MB30. The works should be completely performed in accordance with the Design and the technical conditions for this type of works.                                         "]
[null,null,"m3",23.5,null,{"$f":"D28*E28","v":0}]
["3.3.","Mechanical preparation and pouring with compaction of waterproof concrete MB30 for external and internal walls (thickness of 30cm) in two-sided formwork with two-sided formwork with concreting of haunches.  The works should be completely performed in accordance with the Design and the technical conditions for this type of works.                                                                     "," "," ",null," "]
[null,null,"m3",52.86,null,{"$f":"D30*E30","v":0}]
["3.4.","Mechanical preparation and pouring with compaction of waterproof concrete MB30 for reinforced concrete pathways above the tank (thickness 25 cm) and (thickness 15 cm) with formwork with necessary scaffolding and support.  The works should be completely performed in accordance with the Design and the technical conditions for this type of works.                                                                     "," "," ",null," "]
[null,null,"m3",2.2999999999999998,null,{"$f":"D32*E32","v":0}]
["3.5.","Mechanical preparation and pouring with compaction of waterproof concrete MB30 for reinforced concrete slope stair plates, together with stair treads and formwork and the necessary support and the necessary scaffolding.  The stair treads are 30 cm wide and 15 cm high, and the stair plate is 15 cm thick. The works should be completely performed in accordance with the Design and the technical conditions for this type of works.                                                                          "]
[null,null,"m3",2.37,null,{"$f":"D34*E34","v":0}]
["3.6.","Placing of cement screed for forming an inclination, d=4-10cm, ratio 1:2 of the floor in the tank chambers."]
[null,null,"m2",63.1,null,{"$f":"D36*E36","v":0}]
[" ","TOTAL 3:"," ",null,null,{"$f":"SUM(F25:F36)","v":0}]
[" ","4. REINFORCEMENT WORKS"," "]
["4.1.","Purchase, transport, cleaning, cutting, bending and installation of reinforcement completely in accordance with the reinforcement plans and the reinforcement specification of the design.                                                                                                                                                                                                                                                                             Calculation per 1 kgr of installed reinforcement                                                                      "]
[null,null,"kg",5268.74,null,{"$f":"D40*E40","v":0}]
[" ","                               TOTAL 4:"," ",null,null,{"$f":"SUM(F40)","v":0}]
[null,"5. INSULATION WORKS"]
["5.1.","Purchase, transport and installation of protection of the vertical waterproofing with Teraplast membrane 400gr/m2 with 10 cm overlap","m2",152,null,{"$f":"D43*E43","v":0}]
["5.2.","Purchase, transport and installation of horizontal and vertical waterproofing under reinforced concrete foundation plate and around the tank walls - bituminous strips for installation with welding and 10 cm overlap.","m2",152,null,{"$f":"D44*E44","v":0}]
["5.3.","Purchase, transport and coating of internal surfaces, walls, floorboards, with two-part rigid waterproofing coating in 3 layers."]
[null,"* horizontal insulation                                                                                                                            * vertical insulation","m2",300,null,{"$f":"D46*E46","v":0}]
["5.4.","Purchase, transport and installation of PVC—band (fugenband) at the joints between the reinforced concrete canvas and reinforced concrete plate type B20 (30/20cm) gray colour in wet chambers installed with metal holders. (The length is increased by 10% due to unforeseen waste and connections)."]
[null,null,"m'",56.8,null,{"$f":"D48*E48","v":0}]
[" ","                               TOTAL 7:"," ",null,null,{"$f":"SUM(F43:F48)","v":0}]
[null,"6. FAÇADE WORKS"]
["6.1.","Purchase, transport and plastering of external overhead surfaces with waterproof facade colour, including preparation of the plastered surfaces. "]
[null,null,"m2",55,null,{"$f":"D52*E52","v":0}]
[" ","                             TOTAL 9"," ",null,null,{"$f":"SUM(F51:F52)","v":0}]
[" ","7. METALWORKS"," "," "," "," "]
[null,"The preparation of the metalwork items must be fully in accordance with the Design and the details of the manufacturer of the metalworks.  Before the metalworks, the dimensions should be recorded on the spot."," "," "," "," "]
["7.1.","Purchase of material, construction, transport and installation of steel protective fence in the dry chamber, with a height of 100 cm, made of horizontally placed rectangular profiles 5х5cm (handrail), vertical beams made of rectangular profiles 5х5cm placed at an axial distance of 1m, among which there are horizontal segments made of rectangular profiles 3х3cm, placed at an appropriate distance. The fence is fastened with an adequate number of anchor plates (12/12cm) and screws for reinforced concrete surfaces. The fence is placed along the perimeter of the side of the vertical surface of the plate of the platforms and the stairs in the dry chamber. The profiles should be coated with red lead coating and painted with white paint."]
[null,null,"m'",30,null,{"$f":"D57*E57","v":0}]
[" ","                               TOTAL 10:"," ",null,null,{"$f":"SUM(F55:F57)","v":0}]
[" ","8. PROTECTIVE FENCE"," "," "," "," "]
["8.1.","Manual excavation in narrow volume for the construction of concrete blocks for protective fence posts around the building, with dimensions 30/30cm and depth of 80cm. The excavations are carried out within a distance of 2 meters."," "," "," "," "]
[null,null,"m3",6,null,{"$f":"D61*E61","v":0}]
["8.2.","Manual excavation in narrow volume for the constructions of concrete blocks for entrance gate posts around the building, with dimensions 50/50cm and depth of 100cm."]
[null,null,"m3",0.5,null,{"$f":"D63*E63","v":0}]
["8.3.","Purchase, transport and concreting with MB 30 of concrete blocks for the installation of metal posts for the entrance gate and the fence.                                                                    "]
[null,null,"m3",6,null,{"$f":"D65*E65","v":0}]
["8.4.","Purchase, transport and installation of metal bearing posts, made of metal profiles 100/100/5mm with a height of 2.5m. Red lead coating and two coats of gray paint should be applied on the posts. The price should also include the required end caps for closing the upper side of the profiles (tin plates with a square cross section of 100/100mm and thickness of 3mm).","piece",55,null,{"$f":"D66*E66","v":0}]
["8.5.","Purchase, transport, spreading along the posts, tightening and attaching of braided wire mesh with a height of 1.5m, openings with a width of 40x40cm and a wire diameter of 2mm. "]
[null,null,"m'",110,null,{"$f":"D68*E68","v":0}]
["8.6.","Purchase, transport, spreading along the pillars and tightening of galvanized barbed wire on the top of the post."," "," ",null," "]
[" ","- galvanized wire d=3mm in three rows","m'",{"$f":"110*3","v":330},null,{"$f":"D70*E70","v":0}]
["8.7.","Purchase, transport and installation of galvanized wire (d = 3mm), spread diagonally between the metal posts, i.e. on the wire mesh.","m'",110,null,{"$f":"D71*E71","v":0}]
["8.8.","Purchase, transport and installation of entrance gate, double door with dimensions 350 / 250cm. The entrance gate is made of horizontal and vertical metal profiles 10/10/ 2,5mm; 3mm thick tin sheet metal should be placed in the lower zone, and a crimped wire mesh door core in the lower zone.. The price should include all the necessary hardware (cylinder lock, hinges, distancers). Red lead coating and gray paint should be applied on the entrance gate. (specifications given in the drawing)"]
[null,null,"piece",1,null,{"$f":"D73*E73","v":0}]
[" ","                             TOTAL 12 :"," ",null,null,{"$f":"SUM(F60:F73)","v":0}]
[" ","13. ACCESS ROAD"," "," "," "," "]
["13.1.","Excavation of humus material up to 50 cm deep for building an access road in the WWTP location and transport of the material to a landfill that is up to 10km away","m3",91.13,null,{"$f":"E76*D76","v":0}]
["13.2.","Purchase from screening plant, loading, transport, spreading, planning and rolling of 2-5cm granules in a 30cm layer under the access road and around the site, for the purpose of forming a plateau by means of machine compaction with selected material from the excavation","m3",337.44,null,{"$f":"D77*E77","v":0}]
["13.3.","Purchase, transport and construction of a 50cm layer made of crushed limestone for the construction of a sub-base layer","m3",87.95,null,{"$f":"D78*E78","v":0}]
[null,"                         TOTAL 13:"," ",null,null,{"$f":"SUM(F76:F78)","v":0}]
["                    GRAND TOTAL:",null,null,null,{"$f":"SUM(F13+F23+F41+F37+F49+F53+F74+F79+F58)","v":0}]
{"$rows_empty":8}
["SUMMARY"]
["No.","ITEM DESCRIPTION","PRICE"]
[1,"PREVIOUS WORKS",{"$f":"F13","v":0}]
[2,"EARTH WORKS",{"$f":"F23","v":0}]
[3,"CONCRETE WORKS",{"$f":"F37","v":0}]
[4,"REINFORCEMENT WORKS",{"$f":"F41","v":0}]
[5,"PLASTER WORKS",0]
[6,"PAINTER WORKS",0]
[7,"INSULATION WORKS",{"$f":"F49","v":0}]
[8,"FLOORING WORKS",0]
[9,"FAÇADE WORKS",{"$f":"F53","v":0}]
[10,"LOCKSMITH WORKS",{"$f":"F58","v":0}]
[11,"METAL WORKS",0]
[12,"PROTECTIVE FENCE",{"$f":"F74","v":0}]
[13,"OTHER WORKS",{"$f":"F79","v":0}]
["GRAND TOTAL:",null,{"$f":"SUM(C91:C103)","v":0}]

{"sheet":"6. Control house","index":6,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,2,23,4],[26,2,26,4],[27,0,27,4],[1,0,1,5],[2,0,2,5],[6,2,6,4],[12,2,12,4],[16,2,16,4],[20,2,20,4]]}
[]
["BILL OF QUANTITY"]
["CONTROL HOUSE"]
[null,"1. PREPARATORY WORKS"]
["1.1.","Survey marking and staking of the building in accordance with all technical standards for this type of works.","m2",7.3,null,{"$f":"D5*E5","v":0}]
[]
[null,null,"Total 1. :",null,null,{"$f":"SUM(F5:F6)","v":0}]
[null,"2. EARTH WORKS"]
["2.1.","Excavation of earth III category in a narrow opening with depth of 0.50m, for the construction of reinforced concrete platform and removal, loading and transport of the construction waste to a landfill that is up to 20km away.","        "]
[null,"Manual excavation: 3,65 m3 ","m3",3.65,null,{"$f":"SUM(D10*E10)","v":0}]
["2.2.","Fine planning of the bottom of the excavation for the building, rolling, adequate compaction and necessary inspection of the density of the earth.","m2",{"$f":"2.6*2.6","v":6.7600000000000007},null,{"$f":"D11*E11","v":0}]
["2.3.","Purchase of material, transport and placement of compacted gravel as a foundation substrate, with a thickness of 30cm, Ø16-32mm, along with necessary compaction and examination of the density and bearing capacity.  ","m3",{"$f":"D11*0.3","v":2.028},null,{"$f":"D12*E12","v":0}]
[null,null,"Total 2. :",null,null,{"$f":"SUM(F10+F11+F12)","v":0}]
[null,"3. CONCRETE AND REINFORCED CONCRETE WORKS"]
["3.1.","Purchase of material, transport and concreting of a substrate for the construction of a platform for the building, made of 10 cm thick lean concrete MB20, applied at an elevation of -0.30m, with necessary levelling.","m3",{"$f":"0.1*D11","v":0.67600000000000016},null,{"$f":"D15*E15","v":0}]
["3.2.","Purchase of material, transport, placement of smooth formwork and concreting of a reinforced concrete platform using 10cm thick concrete MB30, placed at an elevation of -0.10m, with necessary levelling.","m3",{"$f":"0.2*D11","v":1.3520000000000003},null,{"$f":"D16*E16","v":0}]
[null,null,"Total 3. :",null,null,{"$f":"SUM(F15+F16)","v":0}]
[null,"4. REINFORCEMENT WORKS"]
["4.1.","Purchase of material, transport, stretching, cleaning, cutting, bending, placement and fastening of reinforcement grid in the upper and lower zone of the platform."]
[null,"Reinforcement grid Q335: 35kg","кг",40,null,{"$f":"SUM(D20*E20)","v":0}]
[null,null,"Total 4. :",null,null,{"$f":"SUM(F20)","v":0}]
[null,"5. PREFABRICATED ELEMENT "]
["5.1.","Purchase, transport and installation of a portable container with additional equipment and dimensions 200/200/260cm. The container is made of a bearing steel structure with 4mm thick profiles, which is placed along the ends of the container and coated with anti-corrosion protection. As a secondary construction, 3mm thick steel C profiles are used.\nThe walls and roof of the container are made of galvanized tin sheet with a thickness of 0.5mm placed on both sides of the secondary construction of the container. Insulation of polyurethane foam d = 50 mm is placed between the secondary construction. \nThe floor of the container is made of a bearing steel structure with a galvanized tin sheet d = 0.5mm, 50mm thick stone wool insulation, PE foil, waterproof plywood d= 25mm. The finished floor has a laminate substrate d = 0,5mm and 7mm thick waterproof laminate.\nThe joinery includes one exterior door made of PVC profiles. The profiles are painted with RAL9010 according to the RAL colour chart.\n ","piece",1,null,{"$f":"D23*E23","v":0}]
[null,null,"Total 5. :",null,null,{"$f":"SUM(F23)","v":0}]
[null,"6. OTHER WORKS"]
["6.1.","Purchase, transport and installation of porcelain sink 450 mm, with a set of wall-mounted nickel-plated faucet and water supply and drainage installation","piece",1,null,{"$f":"D26*E26","v":0}]
[null,null,"Total 6. :",null,null,{"$f":"SUM(F26)","v":0}]
["TOTAL FOR CONTROL HOUSE: ",{"$nulls":4},{"$f":"SUM(F7+F13+F21+F17+F24+F27)","v":0}]

{"sheet":"7. Sanitary sewer","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[4,0,6,0],[16,0,18,0],[19,0,19,4]]}
["BILL OF QUANTITY"]
["SANITARY SEWER SYSTEM"]
["No.","DESCRIPTION OF THE ITEM ","Unit measure","Quantity","Unit price","Total"]
[1,"Marking the route for the excavation of a trench","m'",40.590000000000003,null,{"$f":"D4*E4","v":0}]
[2,"Combined excavation category III and IV for the purpose of laying pipeline and placing manholes in a trench with a width of up to 0.8m and depth of 0 - 2.0m"," "," ",null," "]
[null,"total V=37.59m3 of which:                                                            ","m3",{"$f":"0.8*37.59","v":30.072000000000003},null,{"$f":"D6*E6","v":0}]
[null,"mechanical 80%","m3",{"$f":"0.2*37.59","v":7.5180000000000007},null,{"$f":"D7*E7","v":0}]
[3,"manual 20%","m2",60,null,{"$f":"D8*E8","v":0}]
[4,"Supporting the sides of the trench with a medium pressure support. ","m2",{"$f":"D4*0.8","v":32.472000000000001},null,{"$f":"D9*E9","v":0}]
[5,"Planning of the bottom of the trench with an accuracy of ±2cm.","m3",3.25,null,0]
[6,"Purchase and spreading of sand on the bottom of the trench with a thickness of 10cm.","m3",{"$f":"D4*0.8*0.5","v":16.236000000000001},null,0]
[7,"Backfilling of the trench in layers of up to 30cm above the pipe crown with sand by manual compaction.","m3",{"$f":"37.59-(D11+D10)","v":18.104000000000003},null,0]
[8,"Finalization of the backfilling of the trench in 30cm layers with gravel and sand (from a natural source or crushed), with manual or mechanical compaction.","m3",{"$f":"(1*2*1)*5","v":10},null,{"$f":"E13*D13","v":0}]
[9,"Excavation category III and IV for the purpose of widening the manhole trench with a depth of up to 4.0m and disposal of the material at a designated distance beside the trench.","piece",5,null,0]
[10,"Purchase and installation of reinforced-concrete inspection manholes with an average height of H = 1.10 m together with cast iron cover G = 160 kg for heavy traffic and manhole step iron on a pre-prepared base of 10cm thick pre-prepared sand substrate.","m3",{"$f":"D13/2","v":5},null,{"$f":"E15*D15","v":0}]
[11,"Backfilling of the area around the manholes with gravel and sand or crushed stone by compaction in layers","m3",{"$f":"D6+D7+D15","v":42.59},null,{"$f":"D16*E16","v":0}]
[12,"Transport of the excess earth from the trench to a landfill that is up to 10km away"," "," ",null," "]
[null,"OD/ID 315/285mm","m'",27.82,null,{"$f":"D18*E18","v":0}]
[null,"OD/ID 160/138mm","m'",14.77,null,{"$f":"D19*E19","v":0}]
["Total sanitary sewer system:",{"$nulls":4},{"$f":"SUM(F4:F19)","v":0}]

{"sheet":"8. Electrical","index":8,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":10}
["Item","DESCRIPTION OF THE WORKS","Unit price","Quantity","Unit price in MKD (without VAT)","Total Price in MKD (without VAT)"]
[1,2,3,4,5,6]
[]
[null,"BILL OF QUANTITY"]
[null,"for electrical installations for"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"NOTE:"]
[null,"*All items include purchase, delivery"]
[null,"transport, storage, installation and "]
[null,"connection together with a "]
[null,"set of expendable material, in accordance with the \"ready for work\" principle."]
[null,"“*or equivalent” applies for the entire"]
[null,"planned equipment."]
[]
[" ","1. CONSTRUCTION AND EARTH WORKS AND PROTECTION OF CONDUCTORS"," "," "]
[1.1000000000000001,"Excavation of ditch III and IV category with backfilling and compaction in layers of 20 cm for laying power supply and distribution cables. This includes transporting the excess earth up to 5km away and restoring the terrain to its original state. (0,4 x 0,8 = 0,32m² х200m)","m³",64]
[1.2,"Applying a 10cm thick layer of fine quartz sand beneath and above the laid cables. (0,4 x 0,2 = 0,08m² х 200m)","m³",16]
[1.3,"Placing protective layers (PVC guards) and PVC warning tape that reads “caution electric cable) above the cables in the trench.","m",200]
[1.4,"Excavation of holes category III and IV for making foundations for metal posts (with height H = 4m). This includes transport of excess earth. It is paid by m3. (0,6 х 0,6 х 0,6 = 0,22m³ х 5)","m³",1.2]
[1.5,"Construction of concrete foundation with concrete MB-30 for the placement of metal posts H=4m, with built-in anchor bucket and plastic pipes F76mm, for \"input\" and \"output\" of the cable. (0,6 х 0,6 х 0,6 = 0,22m³)","pcs.",5]
[1.6,"Placing HDPE plastic tube Φ110mm in a trench across the street for mechanical protection of the cables. It is paid by meter of length.","m",30]
[null,"Total 1:"]
[" ","2. SWITCHBOARDS, CONDUCTORS AND POWER SUPPLY CABLES "," "," "]
[2.1,"Construction and installation of electric power connection, together with power supply cable, electronic meter for direct measurement of active electricity and fuses. All items are carried out by EVN Macedonia in accordance with the Electroenergetic conformity and the new network rules. It is paid by number.","pcs.",1]
["2.2","Purchase, delivery and laying of the power supply cable for the main switchboard (RT-PS), type:"," "]
[null,"*  NYY-Ј 5x10mm²","m'",50]
[null,"The cable is laid in the ground in an already excavated trench. It is paid by a meter of length including connection."," "]
["2.3","Purchase, delivery and laying of a power supply cable for the elements of the SBR reactor system, type:"," "]
[null,"*  NYY-Ј 4x4mm²","m'",105]
[null,"*  NYY-Ј 4x2.5mm²","m'",90]
[null,"*  NYY-Ј 3x2.5mm²","m'",190]
[null,"*  NYY-Ј 3x1.5mm²","m'",15]
[null,"Part of the cable is laid in the ground in an already excavated trench and the other part in PNK cable trays. It is paid by a meter of length including connection."," "]
[2.4,"Purchase, delivery and installation of perforated cable trays PNK for supplying power to the consumers in the SBR reactor:"," "]
[null,"*  PNK cable trays 200mm with a suitable cover","m'",20]
[null,"The PNK cable trays are placed under the sloping concrete path with appropriate holders and threads. The cable trays should have an appropriate quality certificate. It is paid by a meter of length including connection."," "]
["2.5","Placing a HDPE Φ23mm plastic tube on the wall with suitable holders fastened on the wall for mechanical protection of the cables.  It is paid by meter of length.","m",30]
[null,"Total 2:"]
[null,"3. URBAN LIGHTING INSTALLATIONS"]
["3.1","Purchase, delivery and laying of a power supply cable for ground lighting, type:"," "]
[null,"*  NАYY-Ј 4x16mm²","m'",80]
[null,"The cable is laid in the ground in an already excavated trench. It is paid by a meter of length including connection."," "]
["3.2","Purchase, delivery and installation of a hot-dip galvanized single-segment post with height H = 4m, equipped with junction box with degree of protection IP44-IK08, appropriate number of automatic fuses C10,1r, \"input-output\" clamps for 16mm² cable, wired to a lamp NYY3x1.5mm² in order to supply it with power.  The anchor bolts should be cast with hot bitumen. All items are paid by number including installation.","pcs.",5]
["3.3","Light fitting for urban planning placed directly on a post. High efficiency cone-cylinder shaped lamp made of opal diffuser, 16 highly efficient LEDs as light source, power of 26W and degree of protection of IP66, IK10.","pcs.",5]
[null,"Total 3:"]
[null,"4. PROTECTIVE GROUNDING INSTALLATIONS "]
["4.1","Delivery and laying of a FeZn-30x4mm grounding tape in the foundations of the building to the measuring circuit. The track should be welded to the reinforcement of the building at every 2-3 meters. It is paid by a meter of length including connection.","m'",85]
["4.2","Delivery and installation of a FeZn-25x4mm galvanized tape in a trench for joint grounding and grounding of metal masses (posts, floor grid, containers, etc.) It is placed in parallel with the power supply cables for the switchboards used for powering the separate buildings of the complex and the urban lighting. It is paid by a meter of length including connection.","m'",110]
["4.3","Purchase, delivery and connection of a cross piece MKS.N.B2.936 cast with hot bitumen. \nIt is paid by number.","pcs.",18]
["4.4","Inspection of the installation, commissioning and measurement of the ground resistance including attestation by an authorized organization accredited by the Ministry of Economy of the Republic of Macedonia, review of the overall installation and its submission to the investor.","lump sum",1]
[null,"Total 4:"]
[" ","5. TESTING AND TECHNICAL DOCUMENTATION"," "," "]
["5.1","Examination of the functionality of the electrical installations by measuring the continuity of the circuit, resistance, insulation, ground resistance and issuance of attestation from an accredited institution.","pcs.",1]
["5.2","Development of an as-built project certified by a company with appropriate authorizations.","pcs.",1]
[null,"Total 5:"]

{"sheet":"9. Automation","index":9,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,1,2,4]]}
[null,"AUTOMATION"]
[]
[null,"Bill of quantities ",null,null,null,"unit price","total price"]
[null,1,"MOTOR PROTECTION 7-10A",1,"pcs",null,{"$f":"F4*D4","v":0}]
[null,2,"MOTOR PROTECTION 4-6 A",2,"pcs",null,{"$f":"F5*D5","v":0}]
[null,3,"MOTOR PROTECTION 2-4 A",9,"pcs",null,0]
[null,6,"CONTACTORS 3 KW",13,"pcs",null,0]
[null,7,"Set of single-pole ROTARY SWITCHES 1-0-2",12,"pcs",null,0]
[null,8,"Set of single-pole ROTARY SWITCHES 1-0",1,"pcs",null,0]
[null,9,"AUTOMATIC FUSES CHARACTER C 3P 50 A",2,"pcs",null,0]
[null,10,"AUTOMATIC FUSES character B 1p 10 A",3,"pcs",null,0]
[null,12,"AUTOMATIC FUSES character C 1p 6 A",1,"pcs",null,0]
[null,13,"SURGE PROTECTION with a surge arrester",1,"pcs",null,0]
[null,14,"including a 35 A fuse",16,"pcs",null,0]
[null,15,"LED DIODES GREEN/RED L-59EGW",16,"pcs",null,0]
[null,16,"LED DIODES CASING CLIP5MM",30,"pcs",null,0]
[null,17,"RESISTORS FOR LED DIODES 24V 3K9 0,25 W ",1,"pcs",null,0]
[null,18,"TRANSFORMER 230 V AC / 24 V AC",1,"pcs",null,0]
[null,19,"TRANSFORMER 230 V AC / 24 V AC",15,"pcs",null,0]
[null,20,"AUXILIARY RELAYS 4P  220 V AC",5,"pcs",null,0]
[null,21,"AUXILIARY RELAYS 4p  24 V AC",20,"pcs",null,0]
[null,22,"AUXILIARY RELAY CONNECTOR 4p ",2,"pcs",null,0]
[null,23,"TIMERS 24/15",3,"pcs",null,0]
[null,24,"TIME RELAYS blinking",7,"pcs",null,0]
[null,25,"TIME RELAY multifunctional",1,"pcs",null,0]
[null,26,"CLAMP 3P+N 63 А  ",20,"met.",null,0]
[null,27,"CONDUCTOR P/F 4mm",50,"met.",null,0]
[null,28,"CONDUCTOR P/F 2,5mm",100,"met.",null,0]
[null,29,"CONDUCTOR P/F 1,5mm",50,"met.",null,0]
[null,30,"CONDUCTOR P/F 0,75mm",60,"pcs",null,0]
[null,31,"CLAMPS OF UP TO 4 mm",20,"pcs",null,0]
[null,32,"NEUTRAL CLAMPS OF UP TO 4 mm",20,"pcs",null,0]
[null,33,"MASS CLAMPS OF UP TO 4 mm",30,"pcs",null,0]
[null,34,"CLAMP STOPPERS OF UP TO 4 mm",30,"pcs",null,0]
[null,35,"TURNBUCKLE FOR CLAMPS",100,"pcs",null,0]
[null,36,"CORD-END TERMINALS 4mm",200,"pcs",null,0]
[null,37,"CORD-END TERMINALS 2,5mm",100,"pcs",null,0]
[null,38,"DOUBLE CORD-END TERMINALS 2,5mm",500,"pcs",null,0]
[null,39,"CORD-END TERMINALS 1,5mm",300,"pcs",null,0]
[null,40,"DOUBLE CORD-END TERMINALS 1,5mm",200,"pcs",null,0]
[null,41,"CORD-END TERMINALS 0.75mm",200,"pcs",null,0]
[null,42,"DOUBLE CORD-END TERMINALS 0,75mm",200,"pcs",null,0]
[null,43,"CABLE TIES 10cm",200,"pcs",null,0]
[null,44,"CABLE TIES 15cm",200,"pcs",null,0]
[null,45,"CABLE TIES 20cm",2,"pcs",null,0]
[null,46,"ELECTRICAL TAPE",4,"met.",null,0]
[null,47,"FUSE RAILS",8,"met.",null,0]
[null,49,"PERFORATED TRUNKING В х Н = 40 х 60 mm.",20,"pcs",null,{"$f":"F48*D48","v":0}]
[null,50,"BUS BAR CONNECTORS 13,5",20,"pcs",null,0]
[null,51,"BUS BAR CONNECTORS 16",2,"pcs",null,0]
[null,52,"BUS BAR CONNECTORS 25",1,"pcs",null,{"$f":"F51*D51","v":0}]
[{"$nulls":5},"Total:",{"$f":"SUM(G4:G51)","v":0}]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}