{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["PRICING SCHEDULE"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":36,"n_cols":17,"rows_kept":36,"merged":[[3,1,3,7],[11,2,11,3],[12,2,12,3],[12,5,14,5],[13,2,13,3],[14,2,14,3],[16,4,16,6],[16,7,16,9],[16,10,16,12],[32,1,35,1],[32,2,32,3],[32,4,32,5],[33,2,33,3],[34,2,34,3],[34,4,34,5],[35,2,35,3],[35,4,35,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFB No","RFB-0000001070"]
["RFB Title","Procurement of Laboratory Information Management System (LIMS) for SAPS for a period of three years"]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  Bidder must complete/enter YELLOW cells only"]
["(b)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(c) The price must include all cost to deliver the goods or render the service, including all applicable taxes, duty fees, logistics/delivery, storage, labour, overtime and subsistance and travel"]
["(d)  Prices that are dependent on Rate of Exchange (ROE) must use ROE indicated below, then enter in Column \"Forex %\" the percentage of the price that is ROE dependent (0% means the price is not ROE dependent)"]
[null,"Foreign currency","South African Rand (ZAR) exchange rate "]
[null,"1 US Dollar",{"v":14.79,"d":"R14.79"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":17.34,"d":"R17.34"}]
[null,"1 Pound (UK)",{"v":20.2,"d":"R20.20"}]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Qty","Unit Price \n(Excl VAT)","Line Price Y2","Qty","Unit Price \n(Excl VAT)","Line Price Y3","Line Price Term \n(Excl VAT)","Forex Price portion","BRAND / MODEL","Price clarification comment"]
[1,"Laboratory Information Management System (LIMS)",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G25)","v":0},null,null,{"$f":"SUBTOTAL(9,J20:J25)","v":0},null,null,{"$f":"SUBTOTAL(9,M20:M25)","v":0},{"$f":"SUBTOTAL(9,N20:N25)","v":0},{"$f":"SUBTOTAL(9,O20:O25)","v":0}]
["1.1","Development / Configuration of Case related modules at Ballistics Sections, at all Biology sites (KZN and Eastern Cape), Questioned Document Sections, Chemistry Sections and Victim Identification Sections in all the Laboratories. ",null,{"v":0,"d":"0%"},null,0,{"$f":"E20*F20","v":0},0,0,{"$f":"H20*I20","v":0},0,0,{"$f":"K20*L20","v":0},{"$f":"SUM(G20,J20,M20)","v":0},{"$f":"D20*N20","v":0}]
["1.2","Training (cost per member) for LIMS administrators",null,{"v":0,"d":"0%"},20,0,{"$f":"E21*F21","v":0},0,0,{"$f":"H21*I21","v":0},0,0,{"$f":"K21*L21","v":0},{"$f":"SUM(G21,J21,M21)","v":0},{"$f":"D21*N21","v":0}]
["1.3","Rollout the Case related modules at Ballistics Sections, Biology Sections, Questioned Document Sections, Chemistry Sections and Victim Identification Sections in all the Laboratories.","4 Provinces",{"v":0,"d":"0%"},2,0,0,0,0,0,0,0,0,{"$f":"SUM(G22,J22,M22)","v":0},0]
["1.4","Rollout of LIMS Generic modules developed for Scientific Analysis Section at Ballistics, Quality management, Questioned Documents,Chemistry and Victim Identification Sections national at all Laboratories.",null,{"v":0,"d":"0%"},null,0,0,0,0,0,0,0,0,0,0]
["1.5","End user training for all modules developed.",null,{"v":0,"d":"0%"},2,0,0,0,0,0,0,0,0,0,0]
["1.6","Support and Maintenance Services for LIMS at SAPS Forensic Science Laboratories for the period of three years",null,{"v":0,"d":"0%"},1,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G25:G26)","v":0},null,null,{"$f":"SUBTOTAL(9,J19:J25:J26)","v":0},null,null,{"$f":"SUBTOTAL(9,M19:M25:M26)","v":0},{"$f":"SUBTOTAL(9,N19:N25:N26)","v":0},{"$f":"SUBTOTAL(9,O19:O27)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G28*0.15","v":0},null,null,{"$f":"J28*0.15","v":0},null,null,{"$f":"M28*0.15","v":0},{"$f":"N28*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G28+G29","v":0},null,null,{"$f":"J28+J29","v":0},null,null,{"$f":"M28+M29","v":0},{"$f":"N28+N29","v":0}]
[]
[]
[null,"I, the bidder, confirm that the price(s) and rate(s) quoted cover all the goods and/or works specified in the bidding documents; that the price(s) or rate(s) cover all my obligations and I accept that any mistakes regarding price(s), rate(s) or calculations will be at my own risk.\n[Note: First convert to PDF, then add signature]"]
[null,null,"Name",null,"Capacity"]
[]
[null,null,"Signature (above)",null,"Date"]