{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Proposed Pricing schedule","Sheet2"],"read":"whole","date_system":"1900"}

{"sheet":"Proposed Pricing schedule","index":0,"n_rows":69,"n_cols":19,"rows_kept":69,"merged":[[0,0,0,12],[2,0,2,4],[6,0,6,7],[12,0,15,0],[12,2,15,2],[12,5,15,5],[12,8,15,8],[12,11,15,11],[12,14,15,14],[24,0,27,0],[24,3,27,3],[24,6,27,6],[24,9,27,9],[24,12,27,12],[24,15,27,15],[29,0,29,16],[33,0,33,16],[35,1,38,1],[35,3,38,3],[35,6,38,6],[35,9,38,9],[35,12,38,12],[35,15,38,15],[42,0,42,16],[44,0,44,16],[46,0,49,0],[46,2,49,2],[46,5,49,5],[46,8,49,8],[46,11,49,11],[46,14,49,14],[52,0,52,16],[53,0,53,16],[55,0,55,5]]}
["Bidders must provide the NHLS with the total Bid price inclusive vat for a period of 5 years. "]
["Terms and Conditions of pricing are as follows:"]
["a) Bidder must complete the pricing as per tables below."]
["b) Prices must be provided in South African Rand (R)."]
["c) Line Prices are all VAT EXCLUSIVE and TOTAL PRICE is VAT INCLUSIVE."]
["d) Bidder to ensure that the Prices listed below are included on the Total Declared Price."]
["e) Bidders who fail to price according to the costing template provided will be disqualified."]
["f) NHLS shall not be bound by the quantities indicated below, as the contract is for the procurement of consumables on an as-and-when-required basis"]
[]
[]
["PRICING SCHEDULE SECTION A: GROSSING STATIONS"]
[]
["Item Description",null,"Quantity Year 1","Monthly Rate","Total Cost ","Quantity Year 2","Monthly  Rate","Total Cost ","Quantity Year 3","Monthly Unit Rate","Total Cost ","Quantity Year 4","Monthly  Rate","Total Cost ","Quantity Year 5","Monthly  Rate","Total Cost ","Total Annual Cost "]
[null,"Unit of measure",null,"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
[{"$nulls":3},"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":3},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["Grosing Stations Placement","Monthly",2,null,"R ",2,null,"R ",2,null,"R ",2,null,"R ",2,null,"R ","R "]
[{"$nulls":16},"Subtotal (VAT Excl.)","R "]
[{"$nulls":16},"Vat","R "]
[{"$nulls":16},"Total ( Vat Incl)","R "]
[]
[]
[]
["Pricing Schedule B: Service and Maintenance Costs as the manufacturer’s instructions (x2 instruments)"]
["Item Description",null,null,"Estimated Year 1","Unit Rate","Total Cost ","Estimated  Year 2","Unit Rate","Total Cost ","Estimated  Year 3","Unit Rate","Total Cost ","Estimated  Year 4","Unit Rate","Total Cost ","Estimated Year 5","Unit Rate","Total Cost ","Total Annual Cost "]
[{"$nulls":4},"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
[null,"Unit of measure","Number of Station",null,"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":4},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["Service and Maintanace","Per Station",2,null,null,"R ",null,null,"R ",null,null,"R ",null,null,"R ",null,null,"R"]
[{"$nulls":17},"Subtotal (VAT Excl.)","R "]
[{"$nulls":17},"Vat","R "]
[{"$nulls":17},"Total ( Vat Incl)","R "]
[]
[]
["Pricing Schedule C:(Carbon Filters)"]
[null,"Estimated Quantity per Year",null,"Estimated  Year 1","Unit Rate","Total Cost ","Estimated Year 2","Unit Rate","Total Cost ","Estimated  Year 3","Unit Rate","Total Cost ","Estimated  Year 4","Unit Rate","Total Cost ","Estimated  Year 5","Unit Rate","Total Cost ","Total Annual Cost "]
[{"$nulls":4},"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
["Item Description",null,"Unit of measure",null,"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":4},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["Active Carbon Filter Cartridge formalin and neutralise","6 times yearly ","Each",null,null,"R",null,null,"R",null,null,"R",null,null,"R",null,null,"R","R"]
["Pre-filter","6 times yearly  ","Each",null,null,"R",null,null,"R",null,null,"R",null,null,"R",null,null,"R","R"]
[]
[{"$nulls":17},"Subtotal (VAT Excl.)","R"]
[{"$nulls":17},"Vat","R"]
[{"$nulls":17},"Subtotal (VAT Incl.)","R"]
["Pricing Schedule D: TRAINING"]
["Item Description",null,"Estimated Officials Year 1","Unit Rate","Total Cost ","Estimated OfficialsYear 2","Unit Rate","Total Cost ","Estimated OfficialsYear 3","Unit Rate","Total Cost ","Estimated Officials Year 4","Unit Rate","Total Cost ","Estimated Officials Year 5","Unit Rate","Total Cost ","Total Annual Cost "]
[{"$nulls":3},"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
[null,"Unit of measure",null,"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":3},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["Initial Operator Training ","Per delegate",20,null,"R",10,null,"R",10,null,"R",10,null,"R",10,null,"R","R"]
[]
["Subtotal (VAT Excl.)",{"$nulls":16},"R"]
["VAT (15%)",{"$nulls":16},"R "]
[{"$nulls":16},"Subtotal (VAT Incl.)","R"]
["Pricing Schedule E: Cleaning Reagents  (For the period of 5 years) Quote as per the below estimated quantities"]
["Reagent Description","Material Number","Unit of Measure","Estimated quantities","Unit Price (VAT excl.)","Total Price Excl. VAT)","Total Price (VAT Incl.)"]
["Stainless steel cleaner / polish – 250 ml",null,"Each","120 bottles","R","R"]
["Enzymatic cleaning and disinfecting reagent 10 L",null,"Litre","1200 L","R","R"]
["Formaldehyde neutralizer – ammonia based or aldehyde neutralizing solution 5 L",null,"Litre","600 L","R","R"]
[]
[]
["Summary of the pricing scehdule",null,"Bid Amount"]
["Pricing Schedule A","Grosing Stations Placement","R"]
["Pricing Schedule B"," Service and Maintenance Costs ","R"]
["Pricing Schedule C","Carbon Filters","R"]
["Pricing Schedule D","Training","R"]
["Pricing Schedule E","Reagents","R"]
["Total Bid Offer for 5 years (All inclusive)",null,"R"]

{"sheet":"Sheet2","index":1,"n_rows":28,"n_cols":20,"rows_kept":28,"hidden":true}
[]
[]
[]
[]
[974513,81209,{"$f":"+B5*12","v":974508}]
[{"$nulls":4},17.69,{"$nulls":6},90.94,938,{"$f":"+M6*L6","v":85301.72}]
[{"$nulls":4},10.88,{"$nulls":7},12]
[{"$nulls":4},62.37,{"$nulls":7},{"$f":"+M6*M7","v":11256}]
[{"$nulls":4},{"$f":"SUM(E6:E8)","v":90.94},938,{"$f":"+F9*E9","v":85301.72},12,{"$f":"+G9*H9","v":1023620.64},{"$nulls":3},5]
[{"$nulls":6},{"$f":"+B5","v":81209},{"$nulls":5},{"$f":"+M8*M9","v":56280}]
[{"$nulls":6},{"$f":"+G10-G9","v":-4092.720000000001},12,{"$f":"+G11*H11","v":-49112.640000000014},{"$nulls":3},{"$f":"+M10*E9","v":5118103.2},5122360,{"$f":"+N11-M11","v":4256.799999999814},{"$f":"+O11/N11","v":8.3102320024360128E-4}]
[{"$nulls":17},{"$f":"4092*2.5%","v":102.30000000000001}]
[{"$nulls":13},938,{"$nulls":3},4092]
[null,null,974513,998876,{"$f":"+D14-C14","v":24363},{"$f":"+E14/C14","v":{"v":0.025000179576875833,"d":"0.03"}},{"$nulls":7},60,{"$nulls":3},{"$f":"+R13+R12","v":4194.3}]
[{"$nulls":13},{"$f":"+N14*N13","v":56280},56330]
[null,null,1023848,{"$f":"+D14","v":998876},{"$f":"+D16-C16","v":-24972},{"$f":"+E16/C16","v":{"v":-0.02439033919097366,"d":"(0.02)"}},{"$nulls":7},{"$f":"+N15-O15","v":-50}]
[{"$nulls":10},{"v":0.025,"d":"2.50%"}]
[null,null,974513,null,{"$f":"+C18","v":974513},null,81209,null,null,{"$f":"+G18","v":81209},{"$f":"+J18*$K$17","v":2030.2250000000001},{"$f":"+K18+J18","v":83239.225}]
[null,{"$f":"+C18/C19-1","v":{"v":-0.024390414826264695,"d":"-2%"}},998876,{"$f":"+C19/C18","v":1.0250001795768757},null,{"$f":"+G18/G19-1","v":{"v":-0.024399327246516056,"d":"-2%"}},83240,{"$f":"+G19/G18","v":{"v":1.025009543277223,"d":"102.5%"}},null,{"$f":"+G19","v":83240},{"$f":"+J19*$K$17","v":2081},{"$f":"+K19+J19","v":85321},{"$nulls":3},938,12,{"$f":"+Q19*P19","v":11256},5,{"$f":"+R19*S19","v":56280}]
[null,{"$f":"+C19/C20-1","v":{"v":-0.024390339190973664,"d":"-2%"}},1023848,{"$f":"+C20/C19","v":1.0250001001125264},null,{"$f":"+G19/G20-1","v":{"v":-0.024390243902439046,"d":"-2%"}},85321,{"$f":"+G20/G19","v":{"v":1.025,"d":"102.5%"}},null,{"$f":"+G20","v":85321},{"$f":"+J20*$K$17","v":2133.025},{"$f":"+K20+J20","v":87454.025}]
[null,{"$f":"+C20/C21-1","v":{"v":-0.024390057973555535,"d":"-2%"}},1049444,{"$f":"+C21/C20","v":1.024999804658504},null,{"$f":"+G20/G21-1","v":{"v":-0.024389965010176762,"d":"-2%"}},87454,{"$f":"+G21/G20","v":{"v":1.0249997069889007,"d":"102.5%"}},null,{"$f":"+G21","v":87454},{"$f":"+J21*$K$17","v":2186.35},{"$f":"+K21+J21","v":89640.35}]
[null,{"$f":"+C21/C22-1","v":{"v":-0.024390153205414267,"d":"-2%"}},1075680,{"$f":"+C22/C21","v":1.0249999047114473},null,{"$f":"+G21/G22-1","v":{"v":-0.024386434627398534,"d":"-2%"}},89640,{"$f":"+G22/G21","v":{"v":1.0249959978960368,"d":"102.5%"}},null,{"$f":"+G22","v":89640},{"$f":"+J22*$K$17","v":2241},{"$f":"+K22+J22","v":91881}]
[]
[null,null,{"$f":"+J18","v":81209},{"$f":"+C24/$E$9","v":892.9953815702661}]
[null,null,{"$f":"+J19","v":83240},{"$f":"+C25/$E$9","v":915.3287882120079},{"$f":"+D25/D24","v":1.025009543277223}]
[null,null,{"$f":"+J20","v":85321},{"$f":"+C26/$E$9","v":938.2120079173081},{"$f":"+D26/D25","v":1.0250000000000001}]
[null,null,{"$f":"+J21","v":87454},{"$f":"+C27/$E$9","v":961.6670332087091},{"$f":"+D27/D26","v":1.0249997069889007}]
[null,null,{"$f":"+J22","v":89640},{"$f":"+C28/$E$9","v":985.7048603474818},{"$f":"+D28/D27","v":1.0249959978960368}]