{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Preambles","SOW","Preliminaries","ECC Building Wau","ECC Juba","Summary","Milestones","Financial Evaluation (2)"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"defined_names":0,"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":"Cover","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,2,14,3],[16,3,16,8],[17,3,17,8],[22,5,22,7],[20,1,20,2],[22,2,22,3],[12,0,12,8],[11,0,11,8],[8,0,8,8],[3,0,3,8],[4,0,4,8],[5,1,5,8],[10,0,10,8]]}
[]
[]
[]
["UNITED NATIONS DEVELOPMENT PROGRAMME"]
["ACCESS TO JUSTICE, SECURITY AND HUMAN RIGHTS"]
[]
[]
[]
["BOOK 1: SCHEDULE OF QUANTITIES"]
[]
["SUPPLY AND REPLACEMENT OF SOLAR ACCESSORIES; "]
["BATTERIES, SOLAR PANELS AND CABLES  AT ECC WAU AND JUBA, "]
["SOUTH SUDAN"]
[]
[null,null,"SITE LOCATIONS:"]
[]
[null,null,1,"WAU ECC , WESTERN BAHR EL GAZAL STATE"]
[null,null,2,"JUBA ECC, CENTRAL EQUATORIA"]
[]
[]
[null,"All prices in US Dollars"]
[]
[null,null,"Budget Estimated cost:",null,"USD ",50000]
[]
[]
[null,"Project No.:","………"]
[]
[null,"Date:","2022-02-21"]
[]
[null,"Document No:","ECC/01"]

{"sheet":"Preambles","index":1,"n_rows":116,"n_cols":1,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[]
[]
["PRICING PREAMBLES "]
[]
["1.0  General"]
[{"$f":"Cover!C28","v":"2022-02-21"}]
[]
["1.1  The Bill of Quantities shall be read in conjunction with the Conditions of Contract, Specifications, Drawings and Employer’s requirements and the Tenderer shall provide against the bill rates or in the prices for the full scope of the work covered by the Contract, no claim or variations shall be considered on account of the Tender’s failure to comply with this provision."]
["1.2  The various documents collectively referred to herein as the Bill of Quantities shall jointly constitute the Bill of Quantities referred to in the Conditions of Contract and these preambles are to be read in conjunction with item descriptions in the Bill of Quantities."]
["1.3  Lump Sum values shall not be inserted where unit rates are applicable and the Tenderer shall ensure that identical items occurring in separate bills are not priced at different rates, unless this is the deliberate intention."]
["1.4  The Tenderer shall check against the summaries that each copy of the Bill of Quantities is complete in the number of pages and in the reproduction of each page. The Tenderer’s unit rates, prices and extensions shall be entered clearly by hand in black ink."]
["1.5  Unit rates, prices and extensions shall be given in the United state Dollar with cents taken to two decimal places or any other valid currency value taken to two decimal places."]
["1.6  The Bill of Quantities has generally been measured in accordance with the Principals of Measurement (International) for Works of Construction (June 1979), as published by the Royal Institution of Chartered Surveyors with amendments made to suit local practice and conditions. The Quantities inserted against items in the Bill of Quantities are estimated quantities for the Works for the purpose of Tender evaluation, and the Tenderer shall be deemed to have checked and verified such quantities in the compilation of his Tender Price prior to the submission of his Tender. Upon the award of the Contract, the priced Bill of Quantities shall be used solely for evaluating interim payments due to the Contractor, and as a schedule of rates for establishing the value of variations."]
["1.7  The Contractor shall not use the Bill of Quantities for the purpose of ordering materials or arranging Subcontractors. References to these activities shall be the Specifications and Drawings and instructions issued by the Engineer."]
["1.8  All items in the Bill of Quantities shall be deemed to have a monetary value, whether priced or unpriced. In the absence of a unit rate or price against any item, the cost shall be deemed to have been included elsewhere within the Contract Price and the work described to that item shall be executed by the Contractor without any additional payment."]
["1.9  The descriptions in the Bill of Quantities may be incomplete and the Tenderer is referred to the Drawings, Photographs and Specifications for complete information in respect of all the relevant descriptions, quality, dimensions, capacities, design parameters and the like."]
[]
["2.0  Format of Descriptions"]
[]
["2.1 In addition to common abbreviations the following have been adopted; POM (I), Principal of    Measurement (International) for Works of construction dated June 1979 as published by the  royal Institution of Charted Surveyors, London  "]
[]
["mm- Millimeter                       Pr-Pair"]
["M-Linear Meter                      No-Number"]
["m2- Square Meter                   Kg-Kilograms            "]
["m3- Cubic Meter"]
[]
["3.0 Rates"]
[]
["3.1 Rates and Prices shall be all inclusive, comprehensive and include the following:"]
["a)     All obligations imposed by the Contract."]
["b)     Complying in every respect with the requirements and the considerations of the Specifications and Drawings."]
["c)     All considerations arising from the definitions incorporated in each Preamble section."]
["d)     Labour for fixing and all associated costs."]
["e)     Materials and goods and all associated costs"]
["f)     Fitting and /or fixing materials and goods in any position, hoisting to any height."]
["g)     Use of Scaffolding, plant, equipment and tools."]
["h)    Any additional labours usually associated with measured items."]
["i)      All necessary protection of the Works, removing all casings and temporary covering and making good and clearing away upon completion."]
["j)      All applicable taxes, duties, charges, government levies, landing charges and transport."]
["k) Overheads & profit."]
[]
["4.0 Measurements"]
[]
["4.1 All measurements are net and the rates shall include for all laps, waste, working space and   trade or traditional allowances."]
["4.2 The pricing of materials shall take account of the following:"]
["a) Pricing Preambles, Drawings and specifications shall apply reciprocally between the  various sections of the Works, unless otherwise described."]
["b) Materials shall be of the specified quality unless otherwise described."]
["c) All materials shall be transported, handled, stored and fixed in accordance with the  printed instruction or recommendations of their manufacturer or suppliers."]
["d) Protection of completed work, all casings and temporary coverings and making good  and clearing away upon completion."]
["4.3 Contingency: In the event that the contractor meets unmeasured works, the contractor shall inform the engineer in writing. The engineer shall ascertain the unmeasured works to verify the contractors claim. The contractor shall submit its claim and wait for approval from the engineer/client. The contractor shall use the same rates as in the contract for similar items. No new rates shall be applied unless the unmeasured work in its nature does not exist in the already mentioned items in the priced bill of quantities."]
["5.0 Discrepancies"]
[]
["5.1 Any discrepancy arising in terms of these Preambles and the items contained within the Bill of Quantities must be brought to the attention of the Engineer for his clarification prior to the submission of tender."]
[]
["EARTH WORKS"]
[]
["§  All quantities for excavation have been measured net with no allowance for increase in bulk or working space."]
["§  The Tenderer shall allow in this excavation rates for excavating in any material, including running sand and rock, commencing excavation at any depth, excavating below the normal water table, excavating around existing services and mains, supporting the vertical sides of excavations, working space and filling soft spots."]
["§  Rates and Prices to include,"]
["a)     Excavating by whatever means are necessary including hand excavation in any kind of ground, except rock and boulder rock."]
["b) Trimming or grading ground to produce level surfaces or surfaces to falls or slopes."]
["c) Ramming and compacting sides and bottoms of excavations and supports to sides."]
["d) Keeping free from water including any dewatering as necessary."]
["e) Any hand excavation required around existing services or the like."]
[]
["CONCRETE WORK"]
[]
["§  The rates for all concrete work shall include for the following:"]
["a) Concrete test cubes and testing costs wherever required."]
["b) Mixing, hoisting and placing and compacting on the surfaces of any material or on      formwork."]
["b)     The forming any construction joints, including any required preparation for adjacent pours, together with expansion joints or the like."]
["d) Curing and protecting concrete surfaces from harmful weather conditions"]
["e) All necessary keys to concrete surfaces to receive in-situ finishes."]
[]
["REINFORCEMENT"]
[]
["§  The rates for bar reinforcement shall include for the following;"]
["a) Positioning and protecting starter bars, Straightening (If required) cutting to length and     bending reinforcement to required shapes."]
["b) Cleaning and wire brushing."]
["c) Provision of supports (excluding links and stirrups) steel binding wire and     "]
["    approved/proprietary distance pieces."]
[]
["SHUTTERING"]
[]
["§  The rates for Shuttering or moulds as appropriate shall include for the followings;"]
[]
["a)     All cutting and waste including raking curved or circular cutting and notching around pipes, ducting and fittings."]
["b)     Setting up, strutting and supporting at any height above the structure subject to any limitations imposed by the engineer including all pops, stays struts, wedges and bolts etc."]
["c)     Carefully coating with shutter oil ensuring that no shutter oil is applied to surfaces of  reinforcement."]
["d)     Rubbing down, filling and making good the surface of concrete after removal of shuttering."]
[]
["MASONRY"]
[]
["§  The rates for brick walls shall include the following:"]
["a)     Straight raking curved and circular rough or fair cutting, plumbing at angles, cutting and bonding at angles, openings and intersections, building in to and/or against adjacent work, wedging and pinning up to soffits."]
["b) All necessary keys for in-situ finishing."]
["c) All necessary wall ties, dowels, straps, sleeves. Channels and other like fixings built-in "]
["     at  junctions between brick work and insitu concrete including casting in, drilling, "]
["    bolting and the like."]
["d) All necessary brick work reinforcement at junctions between brick work and walls   "]
["                construction joints or the like and openings."]
[]
["WOODWORK"]
[]
["§  The rates for wood work shall include for the following;"]
["a) All joints in the running length including structural joints."]
["b) Cutting and fitting to steelwork, trimming around opening, notching, boring and "]
["   sinking."]
["b)     Wood work shall be fixed with non-corroding nails and screws and unless otherwise  described all plugging and pellating shall be deemed to be included."]
[]
["FINISHES"]
["§  The rates for all work-in this section shall include for the followings:"]
["a) Straight, racking, curved and circular cuttings or the like and all consequent wastages."]
["b) All setting out temporary rules, screeds, templates and supports."]
["c) Curing and cleaning off/down upon completion."]
["d) All labours and making good around pipes, ducting and fittings and the like"]

{"sheet":"SOW","index":2,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
["UNDP"]
["PROJECT:"]
[{"$f":"Cover!A12","v":"BATTERIES, SOLAR PANELS AND CABLES  AT ECC WAU AND JUBA, "}]
[]
["SCOPE OF WORK"]
[{"$f":"Cover!C28","v":"2022-02-21"}]
["This document serves as a Scope of Work (SOW) to the Independent Contractor Agreement for the renovation of ECC at Wau and Juba"]
[]
["These being renovation/repairs for communication systems, the intending bidders are strong advised to visit the site before developing their bids for submission."]
[]
["1.         Description of Services."]
[]
["Location: Wau ECC and Juba ECC"]
["Method of Performing Services: Contractor will determine the method, details, and means of completing the Project. Contractor agrees to devote the required personnel for a minimum 90 calendar days to the Project."]
["Tools and Instrumentalities: Contractor, at its own expense, will supply all tools, instrumentalities and all building and installation materials for the Project, including without limitation paint, steel metal frames, ceiling mounted fan units, plumbing materials, iron poles, rain gutters and iron sheets etc."]
[" Finishing Materials: Company shall be responsible for procuring the finishing materials as provided herein in the BoQ."]
[]
["Work Items:"]
[]
["ECC Office blocks."]
["Exterior Work"]
["Painting works;"]
["Fill exterior surfaces as necessary, prime all the plaster work"]
["Paint siding, trim, doors, soffits, fascia, shutters, gutters, downspouts using 3-color paint scheme (weather guard – cream paint) "]
[]
["Interior Work"]
["Painting works;"]
["Fill interior surfaces as necessary, prime all the plaster work"]
["Paint siding, trim, doors, soffits, fascia, shutters, gutters, downspouts using 3-color paint scheme (vinyl silk – white paint) "]
["Electrical wiring with all the required accessories "]
["Fixing the roof mounted ceiling fans"]
[]
["ECC Office blocks."]
["Internal Work"]
["Applying plaster to internal identified places"]
["Painting works;"]
["Fill exterior surfaces as necessary, prime all the plaster work"]
["Electrical wiring with all the required accessories "]
[]
["2.    Contractor’s payments."]
["In consideration for the Services to be performed by Contractor, UNDP agrees to pay Contractor the amount awarded based on the following payment schedule/milestones:"]
["1.       Milestone 1: 95% of contract amount upon approval of satisfactory completed activities as per stated in the bills of quantities;"]
[]
["2.       Milestone 2: 05% after defect liability period of 12-month;"]
[]
["3. Deadline."]
["Contractor shall complete the Project within 120 calendar days. For each additional duration, the conditions stated in the conditions of contract shall be applied."]

{"sheet":"Preliminaries","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,0,2,5],[3,0,3,5],[5,0,5,5],[8,1,8,5],[11,1,11,3],[9,1,9,5]]}
[]
[]
["UNITED NATIONS DEVELOPMENT PROGRAMME"]
["ACCESS TO JUSTICE AND RULE OF LAW"]
[]
[{"$f":"[1]Cover!A9","v":"BOOK 1: SCHEDULE OF QUANTITIES"}]
["Project No.:",{"$f":"Cover!C26","v":"………"}]
[]
["Project:",{"$f":"Cover!#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"Cover!A12","v":"BATTERIES, SOLAR PANELS AND CABLES  AT ECC WAU AND JUBA, "}]
[]
["Item:","BILLS OF QUANTITIES FOR PRELIMINARY WORKS"]
[]
["Date:",{"$f":"Cover!C28","v":"2022-02-21"}]
[]
["Item ","Description","Unit","Qty","Rate","Amount"]
[1," General"]
[1.1000000000000001,"Pre-construction work, mobilization activities. The bidders are strongly advised to visit the site before submitting their quotations to familiarize with the existing status of the undelaying strata","LS",1,null,{"$f":"D18*E18","v":0}]
[null,"The contractor shall provide and maintain temporary sheds for the storage of materials, tools, and tackle and the use of all persons employed on the Site.  Those used for the storage of cement and other perishable materials and the like are to be weatherproofed at all times"]
[null,"Provide, maintain and keep in a clean condition adequate temporary sanitary accommodation and facilities in accordance with local regulations for all persons employed on the Works."]
[null,"Allow for supplying temporary electricity for the Works and facilities of the contractor including 'connection, distribution system for the work, internal arrangements and all payment to the authorities for connections. It is the responsibility of the Contractor to ensure steady and uninterrupted power supply to Works.  The Contractor shall not be entitled to claim and the Employer shall not pay cost incurred by the Contractor for using electric power generators or for using other alternative power supply method in case there happened to be disruptions to normal power supply due to any reason."]
[1.2,"Allow for providing and maintenance of name board and advertising board to the specifications and as directed by the Engineer.","Item",1,null,{"$f":"E22*D22","v":0}]
[1.3,"Post construction works and clean up, all debris as a result of construction activities, shall be dumped to locations/sites approved by governing authorities within the jurisdiction of construction site.","LS",1,null,{"$f":"E23*D23","v":0}]
[1.4,"Allow for providing branding with marble stone or a plaque to the specifications and as directed by the UNDP management in conjunction with other partners "]
[null,"TOTAL FOR PRELIMINARIES",null,null,null,{"$f":"SUM(F18:F24)","v":0}]

{"sheet":"ECC Building Wau","index":4,"n_rows":107,"n_cols":6,"rows_kept":107,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[8,1,8,5]]}
[]
["UNITED NATIONS DEVELOPMENT PROGRAMME"]
["ACCESS TO JUSTICE, SECURITY AND HUMAN RIGHTS PROGRAM"]
[]
[{"$f":"Cover!A9","v":"BOOK 1: SCHEDULE OF QUANTITIES"}]
[]
["Project No:",{"$f":"Cover!C26","v":"………"}]
[]
["Project:",{"$f":"Cover!#REF!","v":{"$error":"#REF!"}}]
[]
["Item:","BILL OF QUANTITIES FOR ECC WAU"]
[]
["Date:",{"$f":"Cover!C28","v":"2022-02-21"}]
[]
["ITEM","BRIEF DESCRIPTION","UNIT","QTY","RATE ","AMOUNT "]
[]
["A","SOLAR INSTALLATIONS"]
[]
["a","Unless otherwise stated, Rates in Bill of Quantities shall include all necessary materials Cables, conduits, PVC sunk box, bulbs, switches etc.) and labour required to complete the electrical installation to good working order."]
[]
["b","Except where specifically stated, all costs associated with provision of all holes, openings, chases, ducts and other builders' work required for installation and make them good, shall be included in the rates. "]
[]
["c","Testing and commissioning of the electrical installation is to be carried out by the contractor and Cost of such testing and reports to be included in the rates unless otherwise mention separately."]
[]
["d","All types of fittings, materials, painting and finishes shall be approved by the Engineer prior to installation."]
[]
[null,"Final  Circuit  Wiring"]
[]
[null,"Rates for final circuit wiring shall include all necessary switches, sockets, materials Cables, conduits, PVC sunk box, & junction boxes, draw wires, etc. and labour required to complete the electrical installation to good working order."]
[]
[null,"Light Point Wiring"]
[]
["A1","Wiring and installation (including supply of all materials) of the light points using approved type PVC insulated PVC sheathed 1 mm² copper cable and 2.5mm² Earth cable drawn through securely fixed concealed existing PVC conduit. (Switches shall be ABB / Clipsal /","Nos.",10,null,{"$f":"D33*E33","v":0}]
[]
[null,"Ditto: eternal","Nos.",4,null,{"$f":"D35*E35","v":0}]
[]
[null,"13A Socket Outlet"]
[]
["A2","Supply & installation of 13A fused shuttered switched  socket outlet  to comply with relevant BS standard  (Clipsal, Orange, Crabtree/ Tenby/ABB or equivalent). Wiring (including supply of earth wire & all other material required ) of above socket outlet to already fixed conduits. Double sockets","Nos.",5,null,{"$f":"D39*E39","v":0}]
[]
[null,"Ditto: Single sockets","Nos.",5,null,{"$f":"D41*E41","v":0}]
[]
[null,"Light Switch"]
[]
["A3","Supply & installation of switches to comply with relevant BS standard  (Clipsal, Orange, Crabtree/ Tenby/ABB or equivalent). Wiring (including supply of all other material required ) of above switch proper functioning. (Internal)","Nos.",10,null,{"$f":"D45*E45","v":0}]
[]
[null,"Ditto: External lighting switch","Nos.",1,null,{"$f":"D47*E47","v":0}]
[]
[null,"Fittings &  Equipment's"]
[]
[null,"Light Fittings"]
[]
["A4","Supply and installation of 15 Watt LED (Philips or equivalent) Lamp, with color rendering index (CRI) greater than 80, minimum light output of 200 lumens and life span of more than 20,000 hours suitable for indoor use including all other necessary accessories like terminal block etc. (accessories - thorn / Philips or equivalent & fitting)  ","Nos.",10,null,{"$f":"D53*E53","v":0}]
[]
["A5","Supply and installation of All-weather exterior light, 40 watt LED (Philips or equivalent) Lamp with color rendering index (CRI) greater than 75, minimum light out put of 450 lumens and  life span of more than 20,000 hours suitable for outdoor use including all other necessary accessories like terminal block etc. (accessories - thorn / Philips or equivalent & fitting)  ","Nos.",4,null,{"$f":"D55*E55","v":0}]
[]
["A6","Supply and installation of approved type Air condition system split level 18,000 BTU (LG or equivalent) complete with all necessary accessories to make it functional as approved by the engineer. With all the necessary accessories, including wiring to make it functional","No.s",1,null,{"$f":"D57*E57","v":0}]
[]
[null,"Earthing Arrangement"]
[]
["A7","Supply and installation of approved type earthing system as approved by the engineer in order to keep the earth resistance below 10 ohms. The earth bar at the main distribution board should connect to the earth electrode with a 16mm2 PVC/CU cables","item",1,null,{"$f":"D61*E61","v":0}]
[]
[null,"Lightning Protection"]
[]
["A8","Supply and installation of approved type Lightning conductor system including lightning arrester, 1\"copper tape clipped at every 300mm to wall and copper earth rode embedded in earth as approved by the engineer.","item",1,null,{"$f":"D65*E65","v":0}]
[]
[null,"Socket Outlet for internet connections"]
[]
["A9","Chisel the wall to provide trunking for 25mm trunking pipe (ms)  for the 10 computers","M",22,null,{"$f":"D69*E69","v":0}]
[]
["A10","Supply and fix 25mm PVC pipe to trunking in the wall  and make good with plaster and paint to match the existing surface","M",22,null,{"$f":"D71*E71","v":0}]
[]
["A11","Supply and fix plastic condute/MK-boxes; RJ45 Sockets -double and RJ45 face plate double to 10 outlet computer connection points","No",10,null,{"$f":"D73*E73","v":0}]
[]
["A12","Wiring and installation (including supply of all materials) for internet connection to ten (10) computers using approved cat-6-cable and RJ45 connectors drawn through a securely fixed concealed existing 25mm PVC conduit. ","Nos.",10,null,{"$f":"D75*E75","v":0}]
[]
[null,"Solar System"]
[]
["A13","Provide and replace damaged PV module performance model TPS105 rating at 1000W/m2 (100 mw/cm2) with the following performance specifications: at 250C; Pmax 250w, Ipmax 8.14A DC Vpmax 30.7v DC Isc 8.52A DC and at 270C Pmax 185W, Ipmax 6.69A DC, Vpma 27.33 V DC, Isc 7.18 A DC. Series fuse 16A and Roof fire class C.","No",3,null,{"$f":"D79*E79","v":0}]
[]
["A14","Solar charge controller","No",2,null,{"$f":"D81*E81","v":0}]
[]
["A15","Supply and install UPS of 1000w","No",1,null,{"$f":"D83*E83","v":0}]
[]
["A16","Repair the existing doors ","No.s",3,null,{"$f":"D85*E85","v":0}]
[]
["A17","Repair the existing doors and provide new mortice locks","No.s",3,null,{"$f":"D87*E87","v":0}]
[]
["A18","Supply and install lead battery: Gel Deep Cycle Battery, Rechargeable battery, Nonspillable with the following specification: 2V1500AH@10h Rate; Constant voltage charge, standby use: 2.25-2.30v: Cyclic use:2.35-2.40V Maximum initial current: less than 600A to match the existing solar batteries","Nos.",24,null,{"$f":"D89*E89","v":0}]
[]
["A19","Control panel for 100A, 3 Phase supply: 01 Nos 63A;  01 Nos 30 A , include the wiring and other installation costs.","Nos.",1,null,{"$f":"D91*E91","v":0}]
[]
[null,"Painting"]
[]
["a","Rate shall include for preparation of surface cleaning down, smoothing, knotting, puttying, stepping etc. protection of floors and fitting, removing & replacing door and window, furniture, and cleaning windows etc. upon completion.",null,"Note"]
[]
["b","Paint shall be from approved colour with approved manufacturer. ",null,"Note"]
[]
[null,"Walls"]
[]
["A20","Prepare and apply one coat of primer and two coats of vinyl silk paint white in colour of good quality to internal plastered faces of walls","m²",140,null,{"$f":"D101*E101","v":0}]
[]
["A21","Prepare and apply one coat of primer and two coats of Ceiling paint white in colour of good quality to Ceiling plastered faces of walls","m²",45,null,{"$f":"D103*E103","v":0}]
[]
["A22","Prepare and apply one coat of primer and two coats of weather guard paint cream in colour and of good quality to external plastered faces of walls","m²",95,null,{"$f":"D105*E105","v":0}]
[]
[null,"TOTAL FOR ECC WAU ",null,null,null,{"$f":"SUM(F17:F106)","v":0}]

{"sheet":"ECC Juba","index":5,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[8,1,8,5]]}
[]
["UNITED NATIONS DEVELOPMENT PROGRAMME"]
["ACCESS TO JUSTICE, SECURITY AND HUMAN RIGHTS PROGRAM"]
[]
[{"$f":"Cover!A9","v":"BOOK 1: SCHEDULE OF QUANTITIES"}]
[]
["Project No:",{"$f":"Cover!C26","v":"………"}]
[]
["Project:",{"$f":"Cover!A12","v":"BATTERIES, SOLAR PANELS AND CABLES  AT ECC WAU AND JUBA, "}]
[]
["Item:","BILL OF QUANTITIES FOR ECC JUBA"]
[]
["Date:",{"$f":"Cover!C28","v":"2022-02-21"}]
[]
["ITEM","BRIEF DESCRIPTION","UNIT","QTY","RATE ","AMOUNT "]
[]
["B","SOLAR INSTALLATIONS"]
[]
["a","Unless otherwise stated, Rates in Bill of Quantities shall include all necessary materials Cables, conduits, PVC sunk box, bulbs, switches etc.) and labour required to complete the electrical installation to good working order."]
[]
["b","Except where specifically stated, all costs associated with provision of all holes, openings, chases, ducts and other builders' work required for installation and make them good, shall be included in the rates. "]
[]
["c","Testing and commissioning of the electrical installation is to be carried out by the contractor and Cost of such testing and reports to be included in the rates unless otherwise mention separately."]
[]
["d","All types of fittings, materials, painting and finishes shall be approved by the Engineer prior to installation."]
[]
[null,"Solar System"]
[]
["B1","Solar charge controller","No",3,null,{"$f":"D29*E29","v":0}]
[]
["B2","Supply and install lead battery: Gel Deep Cycle Battery, Rechargeable battery, Nonspillable with the following specification: 2V1500AH@10h Rate; Constant voltage charge, standby use: 2.25-2.30v: Cyclic use:2.35-2.40V Maximum initial current: less than 600A to match the existing solar batteries","Nos.",24,null,{"$f":"D31*E31","v":0}]
[]
[null,"Electrical"]
[]
["B3","Provide and fix a new distribution board 250A -16way to replace the existing one. Make good the walls to match the existing one","Nos.",1,null,{"$f":"D35*E35","v":0}]
[]
["B4","Isolator switches 200A -2pcs, ","Nos.",2,null,{"$f":"D37*E37","v":0}]
[]
["B5","60 A -10pcs, Circuit breaker 40 A -6pcs ","Nos.",16,null,{"$f":"D39*E39","v":0}]
[]
["B6","Change over switch 250A","Nos.",1,null,{"$f":"D41*E41","v":0}]
[]
["B7","Wiring and installation 4.0 mm2 2-core to socket out lets using the existing drawn through securely fixed concealed PVC conduit.\n","Roles",5,null,{"$f":"D43*E43","v":0}]
[" "]
["B8","Wiring and installation 2.5 mm2 2-core to light points using the existing drawn through securely fixed concealed PVC conduit.\n","Role",5,null,{"$f":"D45*E45","v":0}]
[]
[null,"Walls"]
[]
["B9","Provide 90mm thick cement-sand (1:3 mix) plaster, applying in layers at an average layer of 20mm thickness finished smooth with wooden float and steel float to all internal wall faces, on brick walls surfaces finishing neatly ready for painting (internal closed door opening)","m²",1.89,null,{"$f":"D49*E49","v":0}]
[]
[null,"Painting"]
[]
["a","Rate shall include for preparation of surface cleaning down, smoothing, knotting, puttying, stepping etc. protection of floors and fitting, removing & replacing door and window, furniture, and cleaning windows etc. upon completion.",null,"Note"]
[]
["b","Paint shall be from approved colour with approved manufacturer. ",null,"Note"]
[]
["B10","Prepare and apply one coat of primer and two coats of vinyl silk paint white in colour of good quality to internal plastered faces of walls","m²",1.89,null,{"$f":"D57*E57","v":0}]
[null,"Doors"]
["B11","Supply and fix mortice lock to aluminium door shutter, and repair the existing doors ","No.s",1,null,{"$f":"D59*E59","v":0}]
[]
["B12","Supply and fix mortice lock to wooden door and repair the existing doors.","No.s",1,null,{"$f":"D61*E61","v":0}]
[]
[null,"TOTAL FOR ECC WAU ",null,null,null,{"$f":"SUM(F27:F62)","v":0}]

{"sheet":"Summary","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[]
[]
["SHEET SUMMARY"]
[{"$f":"[2]Preliminaries!A4","v":"Book 1: SCHEDULE OF QUANTITIES"}]
[]
["BILL NO","DESCRIPTION",null,null,"TOTAL AMOUNT "]
[]
[1,{"$f":"Preliminaries!B25","v":"TOTAL FOR PRELIMINARIES"},null,null,{"$f":"Preliminaries!F25","v":0}]
[]
[2,{"$f":"'ECC Building Wau'!B107","v":"TOTAL FOR ECC WAU "},null,null,{"$f":"'ECC Building Wau'!F107","v":0}]
[]
[3,{"$f":"'ECC Juba'!B63","v":"TOTAL FOR ECC WAU "},null,null,{"$f":"'ECC Juba'!F63","v":0}]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E8:E13)","v":0}]
[]
[null,"ADD 10% CONTINGENCY ",null,0.1,{"$f":"D16*E14","v":0}]
[]
[null,"TOTAL FOR ALL WORKS",null,null,{"$f":"SUM(E14:E17)","v":0}]

{"sheet":"Milestones","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[{"$nulls":4},{"$f":"Summary!E14","v":0}]
["Milestone","Description of work","Percentage","Delivery date.","Executed work in USD"]
[]
["Milestone 1","Upon satisfactory completion of 45% of Civil works as stated in the BoQ.",0.45,null,{"$f":"C5*E2","v":0}]
[]
["Milestone 2","Upon satisfactory completion of 50% of Civil works as stated in the BoQ",0.5,null,{"$f":"C7*E2","v":0}]
[]
["Milestone 3","Upon completion of defect liability period of 12 month 05%",0.05,null,{"$f":"C9*E2","v":0}]
[]
["Milestone 4","Contingency 10%",0.1,null,{"$f":"Summary!E16","v":0}]
[]
["Total","Total Contract Sum ",{"$f":"SUM(C5:C11)","v":1.1000000000000001},null,{"$f":"SUM(E5:E11)","v":0}]

{"sheet":"Financial Evaluation (2)","index":8,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[[17,1,17,3],[15,1,15,3],[16,1,16,3],[0,2,0,4],[14,1,14,3]]}
["items","Description/Bidders","JGH - 50 kWp "]
[null,null,"Qty","Unit Price","Total","$/W(h)","Qty","Unit Cost","Cost","Reduction","Comments"]
[1,"Solar panels",159,133.04,{"$f":"D3*C3","v":21153.359999999997},null,{"$f":"40000/315","v":126.98412698412699},{"$f":"(E3/C3)/315","v":0.42234920634920631},{"$f":"H3*30000","v":12670.476190476189},{"$f":"E3-I3","v":8482.8838095238079},"40 kWp"]
[2,"Solar Charge controller",5,532.13,2660.65,null,4,{"$f":"D4","v":532.13},{"$f":"H4*G4","v":2128.52},532.13000000000011,"BlueSolar MPPT 150/85. Reduced by 1 unit"]
[3,"Lithium Batteries - 125 kWh",1,54658.39,54658.39,null,2,{"$f":"E5/10","v":5465.8389999999999},{"$f":"G5*H5","v":10931.678},43726.712,"50 kWh - B-Box 12.8. From 10 units to 3"]
[4,"Inverters and Smart Power management unit/assembly",1,10491.27,10491.27,null,1,{"$f":"D6-2529.91","v":7961.3600000000006},{"$f":"H6*G6","v":7961.3600000000006},2529.91,"Removed 1 unit of Quattro 48/8000/110/100"]
[5,"Ancillaries, Cables, Mounting System",1,12931.14,12931.14,null,null,null,{"$f":"E7","v":12931.14}]
[6,"Lightning and Surge Protection",1,0,0]
[7,"Technical Room Elements",1,1111.8,1111.8,null,null,null,{"$f":"E9","v":1111.8}]
[8,"Design, sizing and documentation",1,0,0]
[9,"Site Preparation and Civil Works",1,0,0]
[10,"Installation, Initial PV System Training, UAT and Commissioning",1,27373.25,27373.25,null,null,null,{"$f":"E12","v":27373.25}]
[11,"Integration with Existing Local Office Electric Distribution and Wiring",1,0,0]
[12,"Bi Annual maintenance by the  local partner (for 3 years): after-sales services including maintenance (preventative and corrective) and technical support (on-site and/or remote) including  continues online system and performance monitoringm included commissioning",6,2175.46,13052.76,null,null,null,{"$f":"E14","v":13052.76}]
[15,"Freight Cost to Maiduguri, Nigeria",null,null,16055.89,null,null,null,16055.89]
[16,"Site Survey including Survey Reporting",null,null,0]
[17,"Total  DAP  price Juba, South Sudan – (Acquisition Cost)",null,null,{"$f":"SUM(E3:E16)","v":159488.51},null,"Total",null,{"$f":"SUM(I3:I15)","v":104216.87419047618},55271.63580952381]
[null,"Estimated Equipment Delivery Time (in weeks)",null,null,"27 Weeks ",{"$nulls":4},{"$f":"I17+J17","v":159488.51}]