{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Bottled water refill cost ","Watercooler Maintenance","Totals"],"read":"whole","date_system":"1900"}

{"sheet":"Bottled water refill cost ","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,2,5,3],[5,4,5,5],[6,0,6,1],[7,0,7,1],[12,0,12,1],[13,0,13,1],[26,0,26,1],[27,0,27,1],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[35,0,35,4],[37,0,37,5],[38,0,38,5],[39,0,39,5],[40,0,40,5]]}
[]
["PRICING SCHEDULE 3.1 "]
["FIRM PRICES"]
["REQUEST FOR PROPOSALS (RFP) FOR PROVISION OF 19-LITRE OF BOTTLED WATER REFILLS AND QUARTERLY MAINTENANCE OF WATER COOLERS FOR A PERIOD OF 3+1+1 (5) YEARS.\nGPAA 08 / 2023"]
["NAME OF BIDDER:"]
["CLOSING TIME: 11H00                           \t\t\t",null,"    CLOSING DATE:",null,"2023-11-28"]
[{"$nulls":3},"R \nVAT EXCL"]
["Office",null,"Monthly water quantities","Unit cost water cost\n(Per Bottle)","Monthly cost","Water cost  - year 1"]
["GPAA Head Office  ",null,885,{"v":0,"d":"R0.00"},{"$f":"D9*C9","v":{"v":0,"d":"R0.00"}},{"$f":"E9*12","v":{"v":0,"d":"R0.00"}}]
["Gauteng Regional Office – Pretoria ",null,225,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Johannesburg Satellite Office",null,25,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Rustenburg Satellite Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Kimberley",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Mafikeng",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Bloemfontein Regional Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Phuthaditjhaba Satellite Office ",null,25,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Polokwane Regional Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Thohoyandou Satellite Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Nelspruit Regional Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Pietermaritzburg Regional Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Durban Regional Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Mthatha Satellite  Office ",null,25,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Bisho Regional Office ",null,25,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Port Elizabeth Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Cape Town Regional Office ",null,20,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Total",null,{"$f":"SUM(C9:C25)","v":1430},{"v":0,"d":"0.00"}]
["Contingency bottled water when required",null,{"$f":"C26*60/10","v":8580},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"C27*D27","v":{"v":0,"d":"R0.00"}}]
["Sub total Year 1 (VAT EXCL)",null,{"$f":"SUM(C9:C27)","v":11440},null,{"$f":"SUM(E11:E27)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F9:F27)","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 2",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub total Year 2",{"$nulls":4},{"$f":"F28*F29+F28","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 3",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub total Year 3",{"$nulls":4},{"$f":"F30*F31+F30","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 4",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub total Year 4",{"$nulls":4},{"$f":"F32*F33+F32","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 5",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub Total Year 5 (VAT EXCL)",{"$nulls":4},{"$f":"F34*F35+F34","v":{"v":0,"d":"R0.00"}}]
[]
["1. No other form of pricing template will be accepted. Failure to comply will result in the disqualification of the bid. "]
["2. An incomplete pricing schedule (SBD 3.1) will also result in a disqualification."]
["3. Offer is valid for 120 days from the closing date of bid."]
["4. Total Bid price in RSA currency (all applicable taxes included)"]

{"sheet":"Watercooler Maintenance","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,4,5,5],[7,0,7,1],[8,0,8,1],[13,0,13,1],[14,0,14,1],[26,0,26,1],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[36,0,36,5],[37,0,37,5],[38,0,38,5],[39,0,39,5]]}
[]
["PRICING SCHEDULE 3.1 "]
["FIRM PRICES"]
["REQUEST FOR PROPOSALS (RFP) FOR PROVISION OF 19-LITRE OF BOTTLED WATER REFILLS AND QUARTERLY MAINTENANCE OF WATER COOLERS FOR A PERIOD OF 3+1+1 (5) YEARS.\nGPAA 08 / 2023"]
["NAME OF BIDDER:"]
["CLOSING TIME: 11H00                               CLOSING DATE:\t\t\t",{"$nulls":3},"2023-11-28"]
[]
["PRICING SCHEDULE 3.1 ",null,"# of watercoolers","Per watercooler"]
["Office",null,"Quantity","Unit cost","Quarterly cost","Water cost  - year 1"]
["GPAA Head Office  ",null,120,{"v":0,"d":"R0.00"},{"$f":"D10*C10","v":{"v":0,"d":"R0.00"}},{"$f":"E10*4","v":{"v":0,"d":"R0.00"}}]
["Gauteng Regional Office – Pretoria ",null,15,{"v":0,"d":"R0.00"},{"$f":"D11*C11","v":{"v":0,"d":"R0.00"}},{"$f":"E11*4","v":{"v":0,"d":"R0.00"}}]
["Johannesburg Satellite Office",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Rustenburg Satellite Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Kimberley",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Mafikeng",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Bloemfontein Regional Office ",null,4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Phuthaditjhaba Satellite Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Polokwane Regional Office ",null,4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Thohoyandou Satellite Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Nelspruit Regional Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Pietermaritzburg Regional Office ",null,4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Durban Regional Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Mthatha Satellite  Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Bisho Regional Office ",null,4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Port Elizabeth Office ",null,3,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Cape Town Regional Office ",null,4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Sub total  (VAT EXCL)",null,{"$f":"SUM(C10:C26)","v":185},null,{"$f":"SUM(E10:E26)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F10:F26)","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 2",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub total Year 2",{"$nulls":4},{"$f":"F27*F28+F27","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 3",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub total Year 3",{"$nulls":4},{"$f":"F29*F30+F29","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 4",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub total Year 4",{"$nulls":4},{"$f":"F31*F32+F31","v":{"v":0,"d":"R0.00"}}]
["Escalation % year 5",{"$nulls":4},{"v":0,"d":"0%"}]
["Sub Total Year 5 (VAT EXCL)",{"$nulls":4},{"$f":"F33*F34+F33","v":{"v":0,"d":"R0.00"}}]
[]
["1. No other form of pricing template will be accepted. Failure to comply will result in the disqualification of the bid. "]
["2. An incomplete pricing schedule (SBD 3.1) will also result in a disqualification."]
["3. Offer is valid for 120 days from the closing date of bid."]
["4. Total Bid price in RSA currency (all applicable taxes included)"]

{"sheet":"Totals","index":2,"n_rows":41,"n_cols":3,"rows_kept":41,"merged":[[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,1,4,2],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2]]}
[]
["PRICING SCHEDULE 3.1 "]
["FIRM PRICES"]
["REQUEST FOR PROPOSALS (RFP) FOR PROVISION OF 19-LITRE OF BOTTLED WATER REFILLS AND QUARTERLY MAINTENANCE OF WATER COOLERS FOR A PERIOD OF 3+1+1 (5) YEARS.\nGPAA 08/2023"]
["NAME OF BIDDER:"]
["CLOSING TIME: 11H00                   CLOSING DATE:\t\t\t",null,"2023-11-28"]
["PRICING SCHEDULE 3.1 (D)",null,"R"]
["Supply of bottled  water refills",null,{"$f":"'Bottled water refill cost '!F36","v":{"v":0,"d":"R0.00"}}]
["Watercooler Maintenance",null,{"$f":"'Watercooler Maintenance'!F35","v":{"v":0,"d":"R0.00"}}]
["Sub total (VAT EXCL)",null,{"$f":"SUM(C8:C9)","v":{"v":0,"d":"R0.00"}}]
["VAT 15%",null,{"$f":"C10*15%","v":{"v":0,"d":"R0.00"}}]
["Total Bid Price for 5 years (VAT INCL)",null,{"$f":"SUM(C10:C11)","v":{"v":0,"d":"R0.00"}}]
[]
["1. No other form of pricing template will be accepted. Failure to comply will result in the disqualification of the bid. "]
["2. An incomplete pricing schedule (SBD 3.1) will also result in a disqualification."]
["3. Offer is valid for 120 days from the closing date of bid."]
["4. Total Bid price in RSA currency (all applicable taxes included)"]
{"$rows_empty":23}
[null,"     "]