{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Pricing Annexure"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Pricing Annexure","index":0,"n_rows":81,"n_cols":7,"rows_kept":81,"merged":[[1,3,1,6],[2,3,2,6],[3,3,3,6],[5,3,5,6],[80,2,80,6]]}
[null,null,"ANNEXURE C 2.2 PRICE SCHEDULE/ BILL OF QUANTITIES ( BOQ)"]
[null,null,"BID NUMBER","RW10413976/25"]
[null,null,"BID DESCRIPTION","SUPPLY AND DELIVERY OF CALCIUM HYPOCHLORITE GRANULES TO RAND WATER SITES FOR A PERIOD OF SIXTY (60) MONTHS"]
[null,null,"BIDDER NAME"]
[]
[{"$nulls":3},"Supply and delivery as per schedule below:"]
[null,null,"DELIVERABLES (DESCRIPTION)","QTY (A)","UNIT OF MEASURE","RATE (B)","(A*B)"]
[null,null,"Calcium Hypochlorite Granular 25kg"]
[null,1,"ZUIKERBOSCH WATER TREATMENT PLANT"]
[null,"1.1","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 1.",250,"25KG BUCKET",null,{"$f":"D10*F10","v":0}]
[null,"1.2","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 1.",250,"25KG BUCKET",null,{"$f":"D11*F11","v":0}]
[null,"1.3","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 1.",250,"25KG BUCKET",null,0]
[null,"1.4","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 1.",250,"25KG BUCKET",null,0]
[null,"1.5","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 2.",250,"25KG BUCKET",null,0]
[null,"1.6","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 2.",250,"25KG BUCKET",null,0]
[null,"1.7","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 2.",250,"25KG BUCKET",null,0]
[null,"1.8","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 2.",250,"25KG BUCKET",null,0]
[null,"1.9","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 3.",250,"25KG BUCKET",null,0]
[null,"1.10","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 3.",250,"25KG BUCKET",null,0]
[null,"1.11","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 3.",250,"25KG BUCKET",null,0]
[null,"1.12","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 3.",250,"25KG BUCKET",null,0]
[null,"1.13","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 4.",250,"25KG BUCKET",null,0]
[null,"1.14","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 4.",250,"25KG BUCKET",null,0]
[null,"1.15","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 4.",250,"25KG BUCKET",null,0]
[null,"1.16","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 4.",250,"25KG BUCKET",null,0]
[null,"1.17","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 5.",250,"25KG BUCKET",null,0]
[null,"1.18","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 5.",250,"25KG BUCKET",null,0]
[null,"1.19","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 5.",250,"25KG BUCKET",null,0]
[null,"1.20","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 5.",250,"25KG BUCKET",null,0]
[null,null,"TOTAL QUANTITIES FOR ZUIKER BOSCH WATER TREATMENT PLANT",{"$f":"SUM(D10:D29)","v":5000},"TOTAL EXCLUDING 15% VAT",null,{"$f":"SUM(G10:G29)","v":0}]
[null,null,"VEREENIGING WATER TREATMENT PLANT"]
[null,"1.21","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 1.",100,"25KG BUCKET",null,{"$f":"D32*F32","v":0}]
[null,"1.22","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 1.",100,"25KG BUCKET",null,{"$f":"D33*F33","v":0}]
[null,"1.23","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 1.",100,"25KG BUCKET",null,0]
[null,"1.24","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 1.",100,"25KG BUCKET",null,0]
[null,"1.25","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 2.",100,"25KG BUCKET",null,0]
[null,"1.26","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 2.",100,"25KG BUCKET",null,0]
[null,"1.27","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 2.",100,"25KG BUCKET",null,0]
[null,"1.28","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 2.",100,"25KG BUCKET",null,0]
[null,"1.29","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 3.",100,"25KG BUCKET",null,0]
[null,"1.30","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 3.",100,"25KG BUCKET",null,0]
[null,"1.31","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 3.",100,"25KG BUCKET",null,0]
[null,"1.32","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 3.",100,"25KG BUCKET",null,0]
[null,"1.33","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 4.",100,"25KG BUCKET",null,0]
[null,"1.34","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 4.",100,"25KG BUCKET",null,0]
[null,"1.35","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 4.",100,"25KG BUCKET",null,0]
[null,"1.36","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 4.",100,"25KG BUCKET",null,0]
[null,"1.37","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 5.",100,"25KG BUCKET",null,0]
[null,"1.38","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 5.",100,"25KG BUCKET",null,0]
[null,"1.39","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 5.",100,"25KG BUCKET",null,0]
[null,"1.40","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 5.",100,"25KG BUCKET",null,0]
[null,null,"TOTAL QUANTITIES FOR VEREENIGING WATER TREATMENT  PLANT",{"$f":"SUM(D32:D51)","v":2000},"TOTAL EXCLUDING 15% VAT",null,{"$f":"SUM(G32:G51)","v":0}]
[null,null,"BULK WATER DISTRIBUTION"]
[null,"1.41","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 1.",150,"25KG BUCKET",null,{"$f":"D54*F54","v":0}]
[null,"1.42","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 1.",150,"25KG BUCKET",null,{"$f":"D55*F55","v":0}]
[null,"1.43","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 1.",150,"25KG BUCKET",null,0]
[null,"1.44","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 1.",150,"25KG BUCKET",null,0]
[null,"1.45","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 2.",150,"25KG BUCKET",null,0]
[null,"1.46","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 2.",150,"25KG BUCKET",null,0]
[null,"1.47","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 2.",150,"25KG BUCKET",null,0]
[null,"1.48","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 2.",150,"25KG BUCKET",null,0]
[null,"1.49","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 3.",150,"25KG BUCKET",null,0]
[null,"1.50","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 3.",150,"25KG BUCKET",null,0]
[null,"1.51","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 3.",150,"25KG BUCKET",null,0]
[null,"1.52","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 3.",150,"25KG BUCKET",null,0]
[null,"1.53","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 4.",150,"25KG BUCKET",null,0]
[null,"1.54","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 4.",150,"25KG BUCKET",null,0]
[null,"1.55","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 4.",150,"25KG BUCKET",null,0]
[null,"1.56","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 4.",150,"25KG BUCKET",null,0]
[null,"1.57","Calcium Hypochlorite Granular 25kg - DELIVERY IN JANUARY YEAR 5.",150,"25KG BUCKET",null,0]
[null,"1.58","Calcium Hypochlorite Granular 25kg - DELIVERY IN APRIL YEAR 5.",150,"25KG BUCKET",null,0]
[null,"1.59","Calcium Hypochlorite Granular 25kg - DELIVERY IN JULY YEAR 5.",150,"25KG BUCKET",null,0]
[null,"1.60","Calcium Hypochlorite Granular 25kg - DELIVERY IN OCTOBER YEAR 5.",150,"25KG BUCKET",null,0]
[null,null,"TOTAL QUANTITIES FOR BULK WATER DISTRIBUTION",{"$f":"SUM(D54:D73)","v":3000},"EXCLUDING 15% VAT",null,{"$f":"SUM(G54:G73)","v":0}]
[null,null,"TOTAL QUANTITIES FOR ALL THREE SITES MENTIONED ABOVE",{"$f":"D30+D52+D74","v":10000},"EXCLUDING 15% VAT",null,{"$f":"G30+G52+G74","v":0}]
[]
[null,null,"TOTAL COSTS FOR  ALL THREE SITES EXCLUDING 15% VAT",{"$f":"G75","v":0}]
[null,null,"15% VAT ",{"$f":"D77","v":0}]
[null,null,"TOTAL COSTS FOR ALL THREE SITES INCLUDING 15% VAT",{"$f":"D78*0.15","v":0}]
[]
[null,null,"NOTE : Goods/services will be called-off as and when required by Rand Water after the award of the contract. Rand Water reserves the right not to acquire all the estimated quantities at once. Suppliers are therefore advised not to procure goods/services upfront and only procure upon the instruction of Rand Water."]