{"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":140,"n_cols":18,"rows_kept":140,"merged":[[2,0,2,12],[4,0,4,4],[7,0,7,7],[13,0,16,0],[13,2,16,2],[13,5,16,5],[13,8,16,8],[13,11,16,11],[13,14,16,14],[18,0,18,16],[26,0,29,0],[26,2,29,2],[26,5,29,5],[26,8,29,8],[26,11,29,11],[26,14,29,14],[33,0,33,16],[35,0,35,16],[52,0,55,0],[52,2,55,2],[52,5,55,5],[52,8,55,8],[52,11,55,11],[52,14,55,14],[59,0,59,16],[60,0,60,15],[61,0,61,16],[65,0,68,0],[65,2,68,2],[65,5,68,5],[65,8,68,8],[65,11,68,11],[65,14,68,14],[74,0,74,16],[76,0,76,16],[78,0,81,0],[78,2,81,2],[78,5,81,5],[78,8,81,8],[78,11,81,11],[78,14,81,14],[90,0,90,16],[92,0,92,16],[94,0,97,0],[94,2,97,2],[94,5,97,5],[94,8,97,8],[94,11,97,11],[94,14,97,14],[107,0,107,16],[109,0,109,16],[112,0,115,0],[112,2,115,2],[112,5,115,5],[112,8,115,8],[112,11,115,11],[112,14,115,14],[119,0,119,16],[120,0,120,16],[121,0,121,16],[131,0,131,7],[132,1,132,7],[133,1,133,7],[134,1,134,7],[135,1,135,7],[136,1,136,7],[137,1,137,7],[138,1,138,7],[139,0,139,7]]}
["ANNEXURE 1 - PRICING SCHEDULE - RFB231/25/26"]
[]
["Bidders must provide the NHLS with costing information for a 5 years’ contract duration.  The bid price quoted must be inclusive as per the scope of work."]
["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) Bidders who fail to price according to the costing template provided will be disqualified."]
["e) NHLS is not bound by the below quantities as this contract is for procurement of the consumables on an as and when required basis."]
["f) NHLS will appoint based on the rates therefore the total bid offer is for comparison purposes only. "]
[]
["PRICING SCHEDULE SECTION A: ANALYSER PLACEMENT COSTS"]
[]
["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 "]
[{"$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.)"]
["Placement of HLA (Human Leucocyte Antigen) Typing and Antibodies Analysers ","Each",1,null," ",1,null," ",1,null," ",1,null," ",1,null," "," "]
["Subtotal (VAT Excl.)",{"$nulls":16}," "]
[{"$nulls":16},"VAT"]
[{"$nulls":16},"Total Cost (vat Incl)"]
[]
[]
[]
["SECTION B: BRAAMFONTEIN IMMUNOLOGY LABORATORY COSTING (1 ANALYSER)"]
["B1. Reagents (Cost of reagents for each test)"]
["Item Description",null,"Estimated Quantity Year 1","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity 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.)"]
["HLA tissue typing","Per Test",1060,null," ",1060,null," ",1060,null," ",1060,null," ",1060,null," "," "]
["HLA Single Antigen class 1","Per Test",467,null,null,467,null,null,467,null,null,467,null,null,467]
["HLA Single Antigen class 2","Per Test",467,null,null,467,null,null,467,null,null,467,null,null,467]
["Subtotal (VAT Excl.)",{"$nulls":16}," "]
[{"$nulls":16},"VAT"," "]
["Subtotal (VAT Incl.)",{"$nulls":16}," "]
["B1.a) Reagents (List of all reagents) - If BSC know them, please list. If don't know, the bidder must list and price"]
["Reagent Description","Catalogue No.","Pack Size","Tests per Pack","Unit Price","Cost per Test"]
["HLA tissue typing",{"$nulls":3},"R","R"]
["HLA Single Antigen class 1",{"$nulls":3},"R","R"]
["HLA Single Antigen class 2",{"$nulls":3},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[{"$nulls":4},"R","R"]
[]
[]
["Pricing Schedule B2: Quality Control Materials (List of all QC)"]
["Item Description",null,"Estimated Quantity Year 1","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity 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.)"]
["Negative Control","Each",null,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
[null," "]
[" "," "]
["Subtotal (VAT Excl.)",{"$nulls":16}," "]
[{"$nulls":16},"VAT"," "]
["Subtotal (VAT Incl.)",{"$nulls":16}," "]
[]
[]
["Pricing Schedule B3: Calibrators (List of all calibrators)"]
["Item Description",null,"Estimated Quantity Year 1","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity 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.)"]
[null,"Each",null,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
[null,"Each"]
[null,"Each"]
[null,"Each",null,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
[null,"Each",null,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
["Subtotal (VAT Excl.)",{"$nulls":16}," "]
[{"$nulls":16},"VAT"," "]
["Subtotal (VAT Incl.)",{"$nulls":16}," "]
["Pricing Schedule B4: Consumables (List of all consumables)"]
["Item Description",null,"Estimated Quantity Year 1","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity 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.)"]
[" ","Per test",null,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
[null,"Per test",null,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
[null,"Per test"]
[null,"Per test"]
[null,"Per test"]
[null,"Per test"]
[null,"Per test"]
[null,"Per test"]
["Subtotal (VAT Excl.)",{"$nulls":16}," "]
[{"$nulls":16},"VAT"," "]
["Subtotal (VAT Incl.)",{"$nulls":16}," "]
["Pricing Schedule B5: List Individual tests "]
["Item Description",null,"Estimated Quantity Year 1","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity 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.)"]
["HLA Class I","Per result"]
["HLA Class II","Per result"]
["HLA A","Per result"]
["HLA B","Per result"]
["HLA C","Per result"]
["HLA DRB1","Per result"]
["HLA DQA/B","Per result"]
["HLA DPA/B","Per result"]
["HLA DRB345","Per result"]
["Subtotal (VAT Excl.)",{"$nulls":16}," "]
[{"$nulls":16},"VAT"," "]
["Subtotal (VAT Incl.)",{"$nulls":16}," "]
[]
["SECTION C: TRAINING AND APPLICATION SUPPORT "]
["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,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["Initial Operator Training (per session)","Per session",16,null," ",null,null," ",null,null," ",null,null," ",null,null," "," "]
["Refresher Training (per session; for any analysis software upgrade) ","Per session",16]
["Application Specialist support","Per visit"," ",null,null," "]
["VAT Excl.) ",{"$nulls":16}," "]
["VAT (15%)",{"$nulls":16}," "]
["Total Price (VAT Incl.)",{"$nulls":16}," "]
["VOLUMES"]
["HLA tissue typing",88,1060]
["HLA Single Antigen class 1",40,467]
["HLA Single Antigen class 2",40,467]
[]
[]
[]
[]
[]
["Summary of the pricing scehdule",{"$nulls":7},"Bid Amount"]
["Pricing Schedule A","Analyzer Placement",{"$nulls":6}," "]
["Pricing Schedule B1","Reagents",{"$nulls":6}," "]
["Pricing Schedule B2","Quality Control Materials",{"$nulls":6}," "]
["Pricing Schedule B3","Calibrators",{"$nulls":6}," "]
["Pricing Schedule B4","Consumables",{"$nulls":6}," "]
["Pricing Schedule B5","List of individual tests",{"$nulls":6}," "]
["Pricing Schedule C","Training",{"$nulls":6}," "]
["Total Bid Offer for 5 years (All inclusive)",{"$nulls":7}," "]

{"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}]