{"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":228,"n_cols":18,"rows_kept":228,"merged":[[0,0,0,12],[2,0,2,4],[5,0,5,7],[11,0,14,0],[11,2,14,2],[11,5,14,5],[11,8,14,8],[11,11,14,11],[11,14,14,14],[16,0,16,16],[17,0,17,16],[18,0,18,16],[22,0,25,0],[22,2,25,2],[22,5,25,5],[22,8,25,8],[22,11,25,11],[22,14,25,14],[27,0,27,16],[29,0,29,16],[45,0,48,0],[45,2,48,2],[45,5,48,5],[45,8,48,8],[45,11,48,11],[45,14,48,14],[52,0,52,16],[54,0,54,16],[55,0,55,16],[62,0,65,0],[62,2,65,2],[62,5,65,5],[62,8,65,8],[62,11,65,11],[62,14,65,14],[69,0,69,16],[71,0,71,16],[73,0,76,0],[73,2,76,2],[73,5,76,5],[73,8,76,8],[73,11,76,11],[73,14,76,14],[82,0,82,16],[84,0,84,16],[86,0,89,0],[86,2,89,2],[86,5,89,5],[86,8,89,8],[86,11,89,11],[86,14,89,14],[96,0,96,16],[98,0,98,16],[100,0,103,0],[100,2,103,2],[100,5,103,5],[100,8,103,8],[100,11,103,11],[100,14,103,14],[106,0,106,16],[108,0,108,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],[117,0,117,16],[119,0,119,16],[135,0,138,0],[135,2,138,2],[135,5,138,5],[135,8,138,8],[135,11,138,11],[135,14,138,14],[142,0,142,16],[144,0,144,16],[145,0,145,16],[152,0,155,0],[152,2,155,2],[152,5,155,5],[152,8,155,8],[152,11,155,11],[152,14,155,14],[159,0,159,16],[161,0,161,16],[163,0,166,0],[163,2,166,2],[163,5,166,5],[163,8,166,8],[163,11,166,11],[163,14,166,14],[172,0,172,16],[174,0,174,16],[176,0,179,0],[176,2,179,2],[176,5,179,5],[176,8,179,8],[176,11,179,11],[176,14,179,14],[186,0,186,16],[188,0,188,16],[191,0,194,0],[191,2,194,2],[191,5,194,5],[191,8,194,8],[191,11,194,11],[191,14,194,14],[197,0,197,16],[199,0,199,16],[201,0,204,0],[201,2,204,2],[201,5,204,5],[201,8,204,8],[201,11,204,11],[201,14,204,14],[208,0,208,16],[209,0,209,16],[210,0,210,16],[212,0,212,7],[213,1,213,7],[214,1,214,7],[215,1,215,7],[216,1,216,7],[217,1,217,7],[218,1,218,7],[219,1,219,7],[220,1,220,7],[221,1,221,7],[222,1,222,7],[223,1,223,7],[224,1,224,7],[225,1,225,7],[226,1,226,7],[227,0,227,7]]}
["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: INSTRUMENT 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.)"]
["Small Laboratory Haematology Analyser Placement","Monthly",29,null,{"$f":"D16*12","v":{"v":0,"d":"R0.00"}},29,null,{"$f":"G16*12","v":{"v":0,"d":"R0.00"}},29,null,{"$f":"J16*12","v":{"v":0,"d":"R0.00"}},29,null,{"$f":"M16*12","v":{"v":0,"d":"R0.00"}},29,null,{"$f":"P16*12","v":{"v":0,"d":"R0.00"}},{"$f":"E16+H16+K16+N16+Q16","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R16:R16)","v":{"v":0,"d":"R0.00"}}]
["VAT",{"$nulls":16},{"$f":"R17*1.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R17+R18","v":{"v":0,"d":"R0.00"}}]
[]
["SECTION B: SMALL LABORATORY COSTING (29 ANALYSERS)"]
["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.)"]
["Cost of all reagents required per test","Per test",null,null,{"$f":"C27*D27","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F27*G27","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I27*J27","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L27*M27","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O27*P27","v":{"v":0,"d":"R0.00"}},{"$f":"E27+H27+K27+N27+Q27","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R26:R27)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R28*1.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R28+R29","v":{"v":0,"d":"R0.00"}}]
["B1.a) Reagents (List of all reagents)"]
["Reagent Description","Material No.","Pack Size","Unit of Measure","Unit Price (Exc VAT) Year 1 ","Unit Price (Exc VAT) Year 2","Unit Price (Exc VAT) Year 3","Unit Price (Exc VAT) Year 4","Unit Price (Exc VAT) Year 5"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},"R","R","R","R","R"]
[{"$nulls":4},{"$f":"SUM(E33:E42)","v":0},{"$f":"SUM(F33:F42)","v":0},{"$f":"SUM(G33:G42)","v":0},0,0]
[]
["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.)"]
["Normal Control","each",null,null,{"$f":"C50*D50","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F50*G50","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I50*J50","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L50*M50","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O50*P50","v":{"v":0,"d":"R0.00"}},{"$f":"E50+H50+K50+N50+Q50","v":{"v":0,"d":"R0.00"}}]
["Low Control","each",null,null,{"$f":"C51*D51","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F51*G51","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I51*J51","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L51*M51","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O51*P51","v":{"v":0,"d":"R0.00"}},{"$f":"E51+H51+K51+N51+Q51","v":{"v":0,"d":"R0.00"}}]
["High Control","each",null,null,{"$f":"C52*D52","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R50:R52)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R53*1.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R53+R54","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B2a: Quality Control Materials price breakdown"]
["Item Description","Catalogue No.","Pack size",null,"Unit Price (ZAR)"]
[]
[]
[]
[]
["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,{"$f":"C67*D67","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F67*G67","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I67*J67","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L67*M67","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O67*P67","v":{"v":0,"d":"R0.00"}},{"$f":"E67+H67+K67+N67+Q67","v":{"v":0,"d":"R0.00"}}]
[null,"Each",null,null,{"$f":"C68*D68","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F68*G68","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I68*J68","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L68*M68","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O68*P68","v":{"v":0,"d":"R0.00"}},{"$f":"E68+H68+K68+N68+Q68","v":{"v":0,"d":"R0.00"}}]
[null,"Each",null,null,{"$f":"C69*D69","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R67:R69)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R70*0.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R70+R71","v":{"v":0,"d":"R0.00"}}]
["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.)"]
[null,"Per test",null,null,{"$f":"C78*D78","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F78*G78","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I78*J78","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L78*M78","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O78*P78","v":{"v":0,"d":"R0.00"}},{"$f":"E78+H78+K78+N78+Q78","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},{"$f":"C79*D79","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F79*G79","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I79*J79","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L79*M79","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O79*P79","v":{"v":0,"d":"R0.00"}},{"$f":"E79+H79+K79+N79+Q79","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R78:R82)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R83*0.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R83+R84","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B5: Cost per Reportable Result"]
["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.)"]
["Full Blood Count (FBC)","Per result"]
["Differential Count","Per result"]
["Reticulocyte Count ","Per result"]
["Heamoglobin","Per result"]
["Platelet Count","Per result"]
["White Blood Cell Count ","Per result"]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R92:R96)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R97*0.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R97+R98","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B6: Service and maintenace costs (Stiplulate the required service interval e.g semi annually/annually)"]
["Item Description",null,"Number of Service Intervals Year 1","Unit Rate","Total Cost ","Number of Service Intervals Year 2","Unit Rate","Total Cost ","Number of Service Intervals Year 3","Unit Rate","Total Cost ","Number of Service Intervals Year 4","Unit Rate","Total Cost ","Number of Service Intervals 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.)"]
["Comprehensive preventative maintenance contract","Each",null,null,{"$f":"C105*D105","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F105*G105","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I105*J105","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L105*M105","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O105*P105","v":{"v":0,"d":"R0.00"}},{"$f":"E105+H105+K105+N105+Q105","v":{"v":0,"d":"R0.00"}}]
["Corrective maintenance and breakdown support","Each",null,null,{"$f":"C106*D106","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F106*G106","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I106*J106","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L106*M106","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O106*P106","v":{"v":0,"d":"R0.00"}},{"$f":"E106+H106+K106+N106+Q106","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R105:R106)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R107*0.15","v":{"v":0,"d":"R0.00"}}]
["Total Price (VAT Incl.)",{"$nulls":16},{"$f":"R107+R108","v":{"v":0,"d":"R0.00"}}]
[]
["SECTION C: MEDIUM LABORATORY COSTING (5 ANALYSERS)"]
["C1. 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.)"]
["Cost of all reagents required per test","Per test",null,null,{"$f":"C117*D117","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F117*G117","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I117*J117","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L117*M117","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O117*P117","v":{"v":0,"d":"R0.00"}},{"$f":"E117+H117+K117+N117+Q117","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R116:R117)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R118*1.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R118+R119","v":{"v":0,"d":"R0.00"}}]
["C1.a) Reagents (List of all reagents)"]
["Reagent Description","Catalogue No.","Pack Size","Unit of Measure","Tests per Pack","Unit Price (ZAR)"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[{"$nulls":5},"R"]
[]
[]
["Pricing Schedule C2: 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.)"]
["Normal Control","each",null,null,{"$f":"C140*D140","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F140*G140","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I140*J140","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L140*M140","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O140*P140","v":{"v":0,"d":"R0.00"}},{"$f":"E140+H140+K140+N140+Q140","v":{"v":0,"d":"R0.00"}}]
["Low Control","each",null,null,{"$f":"C141*D141","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F141*G141","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I141*J141","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L141*M141","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O141*P141","v":{"v":0,"d":"R0.00"}},{"$f":"E141+H141+K141+N141+Q141","v":{"v":0,"d":"R0.00"}}]
["High Control","each",null,null,{"$f":"C142*D142","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R140:R142)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R143*1.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R143+R144","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C2a: Quality Control Materials price breakdown"]
["Item Description","Catalogue No.","Pack size",null,"Unit Price (ZAR)"]
[]
[]
[]
[]
["Pricing Schedule C3: 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,{"$f":"C157*D157","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F157*G157","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I157*J157","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L157*M157","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O157*P157","v":{"v":0,"d":"R0.00"}},{"$f":"E157+H157+K157+N157+Q157","v":{"v":0,"d":"R0.00"}}]
[null,"Each",null,null,{"$f":"C158*D158","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F158*G158","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I158*J158","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L158*M158","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O158*P158","v":{"v":0,"d":"R0.00"}},{"$f":"E158+H158+K158+N158+Q158","v":{"v":0,"d":"R0.00"}}]
[null,"Each",null,null,{"$f":"C159*D159","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R157:R159)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R160*0.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R160+R161","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C4: 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.)"]
[null,"Per test",null,null,{"$f":"C168*D168","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F168*G168","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I168*J168","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L168*M168","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O168*P168","v":{"v":0,"d":"R0.00"}},{"$f":"E168+H168+K168+N168+Q168","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},{"$f":"C169*D169","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F169*G169","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I169*J169","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L169*M169","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O169*P169","v":{"v":0,"d":"R0.00"}},{"$f":"E169+H169+K169+N169+Q169","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R168:R172)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R173*0.15","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Incl.)",{"$nulls":16},{"$f":"R173+R174","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C5: Cost per Reportable Result"]
["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.)"]
["Full Blood Count (FBC)","Per result"]
["Differential Count","Per result"]
["Reticulocyte Count ","Per result"]
["Heamoglobin","Per result"]
["Platelet Count","Per result"]
["White Blood Cell Count ","Per result"]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R185:R186)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R187*0.15","v":{"v":0,"d":"R0.00"}}]
["Total Price (VAT Incl.)",{"$nulls":16},{"$f":"R187+R188","v":{"v":0,"d":"R0.00"}}]
[]
["Pricing Schedule C6: Service and maintenace costs (Stiplulate the required service interval e.g semi annually/annually)"]
["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/interval",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.)"]
["Comprehensive preventative maintenance contract",{"$nulls":3},{"$f":"C196*D196","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F196*G196","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I196*J196","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L196*M196","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O196*P196","v":{"v":0,"d":"R0.00"}},{"$f":"E196+H196+K196+N196+Q196","v":{"v":0,"d":"R0.00"}}]
["Corrective maintenance and breakdown support",{"$nulls":3},{"$f":"C197*D197","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F197*G197","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I197*J197","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L197*M197","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O197*P197","v":{"v":0,"d":"R0.00"}},{"$f":"E197+H197+K197+N197+Q197","v":{"v":0,"d":"R0.00"}}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R196:R197)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT",{"$f":"R198*0.15","v":{"v":0,"d":"R0.00"}}]
["Total Price (VAT Incl.)",{"$nulls":16},{"$f":"R198+R199","v":{"v":0,"d":"R0.00"}}]
["SECTION D: TRAINING AND APPLICATION SUPPORT (29 Small Laboratories + 5 Medium Laboratories = 34)"]
["Item Description",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":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 session",34,null,{"$f":"C206*D206","v":{"v":0,"d":"R0.00"}},0,null,{"$f":"F206*G206","v":{"v":0,"d":"R0.00"}},0,null,{"$f":"I206*J206","v":{"v":0,"d":"R0.00"}},0,null,{"$f":"L206*M206","v":{"v":0,"d":"R0.00"}},0,null,{"$f":"O206*P206","v":{"v":0,"d":"R0.00"}},{"$f":"E206+H206+K206+N206+Q206","v":{"v":0,"d":"R0.00"}}]
["Refresher Training (per session; (starting from year 2)","Per session",0,null,{"$f":"C207*D207","v":{"v":0,"d":"R0.00"}},34,null,{"$f":"F207*G207","v":{"v":0,"d":"R0.00"}},34,null,{"$f":"I207*J207","v":{"v":0,"d":"R0.00"}},34,null,{"$f":"L207*M207","v":{"v":0,"d":"R0.00"}},34,null,{"$f":"O207*P207","v":{"v":0,"d":"R0.00"}},{"$f":"E207+H207+K207+N207+Q207","v":{"v":0,"d":"R0.00"}}]
["Super User Training","Per session",34,null,{"v":0,"d":"R0.00"},0,null,{"v":0,"d":"R0.00"},0,null,{"v":0,"d":"R0.00"},0,null,{"v":0,"d":"R0.00"},0,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Subtotal (VAT Excl.)",{"$nulls":16},{"$f":"SUM(R205:R208)","v":{"v":0,"d":"R0.00"}}]
["VAT (15%)",{"$nulls":16},{"$f":"R209*1.15","v":{"v":0,"d":"R0.00"}}]
["Total Price (VAT Incl.)",{"$nulls":16},{"$f":"R209+R210","v":{"v":0,"d":"R0.00"}}]
[]
["Summary of the pricing scehdule",{"$nulls":7},"Bid Amount"]
["Pricing Schedule A","Analyzer Placement",{"$nulls":6},{"$f":"R19","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B1","Reagents",{"$nulls":6},{"$f":"R30","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B2","Quality Control Materials",{"$nulls":6},{"$f":"R55","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B3","Calibrators",{"$nulls":6},{"$f":"R72","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B4","Consumables",{"$nulls":6},{"$f":"R85","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B5","Cost per Reportable Result",{"$nulls":6},{"$f":"R99","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B6","Service and maintenace costs",{"$nulls":6},{"$f":"R109","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C1","Reagents",{"$nulls":6},{"$f":"R120","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C2","Quality Control Materials",{"$nulls":6},{"$f":"R145","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C3","Calibrators",{"$nulls":6},{"$f":"R162","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C4","Consumables",{"$nulls":6},{"$f":"R175","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C5","Cost per Reportable Result",{"$nulls":6},{"$f":"R189","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C6","Service and maintenace costs",{"$nulls":6},{"$f":"R200","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule D","Training and Application Support",{"$nulls":6},{"$f":"R211","v":{"v":0,"d":"R0.00"}}]
["Total Bid Offer for 5 years (All inclusive)",{"$nulls":7},{"$f":"SUM(I214:I227)","v":{"v":0,"d":"R0.00"}}]

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