{"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":116,"n_cols":17,"rows_kept":116,"merged":[[12,2,12,3],[13,2,13,3],[13,5,15,5],[14,2,14,3],[15,2,15,3],[17,4,17,6],[17,7,17,9],[17,10,17,12],[35,1,38,1],[35,2,35,3],[35,4,35,5],[36,2,36,3],[37,2,37,3],[37,4,37,5],[38,2,38,3],[38,4,38,5],[43,4,43,6],[43,7,43,9],[43,10,43,12],[61,1,64,1],[61,2,61,3],[61,4,61,5],[62,2,62,3],[63,2,63,3],[63,4,63,5],[64,2,64,3],[64,4,64,5],[68,4,68,6],[68,7,68,9],[68,10,68,12],[86,1,89,1],[86,2,86,3],[86,4,86,5],[87,2,87,3],[88,2,88,3],[88,4,88,5],[89,2,89,3],[89,4,89,5],[93,4,93,6],[93,7,93,9],[93,10,93,12],[112,1,115,1],[112,2,112,3],[112,4,112,5],[113,2,113,3],[114,2,114,3],[114,4,114,5],[115,2,115,3],[115,4,115,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFB No","WO70175"]
["RFB Title","REQUEST FIR BID FOR THE SUPPLY, DELIVERY, SUPPORT AND MAINTENANCE OF BODY WORN AND VEHICLE DASHBOARD CAMERAS AND RELATED SOFTWARE SOLUTIONS FOR THE SOUTH AFRICAN POLICE SERVICE FOR A PERIOD OF THREE (3) YEARS"]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  THIS PRICING SCHEDULE MUST BE SUBMITTED SEPARATELY FROM THE TECHNICAL RESPONSE, failing which the BID may be DISQUALIFIED."]
["(b)  Bidder must complete/enter YELLOW cells only"]
["(c)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(e) 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"]
["(f)  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":15.97,"d":"R15.97"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":18.56,"d":"R18.56"}]
[null,"1 Pound (UK)",{"v":21.61,"d":"R21.61"}]
[]
[{"$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,"Body Worn Cameras",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G28)","v":0},null,null,{"$f":"SUBTOTAL(9,J21:J28)","v":0},null,null,{"$f":"SUBTOTAL(9,M21:M28)","v":0},{"$f":"SUBTOTAL(9,N21:N28)","v":0},{"$f":"SUBTOTAL(9,O21:O28)","v":0}]
["1.1","Supply of body worn cameras per unit","Each",{"v":0,"d":"0%"},1,0,{"$f":"E21*F21","v":0},1,0,{"$f":"H21*I21","v":0},1,0,{"$f":"K21*L21","v":0},{"$f":"SUM(G21,J21,M21)","v":0},{"$f":"D21*N21","v":0}]
["1.2","Additional Body Worn Cameras will be procured per unit on as and when needed basis via this contract.","Ad-Hoc",{"v":0,"d":"0%"},1,0,{"$f":"E22*F22","v":0},1,0,{"$f":"H22*I22","v":0},1,0,{"$f":"K22*L22","v":0},{"$f":"SUM(G22,J22,M22)","v":0},{"$f":"D22*N22","v":0}]
["1.3","Configure and customise the solution as required by SAPS.","Ad-Hoc",{"v":0,"d":"0%"},1,0,{"$f":"E23*F23","v":0},1,0,0,1,0,0,0,0]
["1.4","Install the latest software and data capturing equipments when required.","Ad-Hoc",{"v":0,"d":"0%"},1,0,{"$f":"E24*F24","v":0},1,0,0,1,0,0,0,0]
["1.5","Provide hardware and software maintenance (fixes, upgrades and patches) of the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.6","Provide second and third line technical and functional support for the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.7","Provide complete training manuals, in English, with each unit purchased, and train members in the use of body cameras.","Each",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.8","Provide training if the software package is enhanced (upgrade of software) on the units purchased, in order to enhance user skills of members.","Ad Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
[]
[]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G28)","v":0},null,null,{"$f":"SUBTOTAL(9,J20:J28)","v":0},null,null,{"$f":"SUBTOTAL(9,M20:M28)","v":0},{"$f":"SUBTOTAL(9,N20:N28)","v":0},{"$f":"SUBTOTAL(9,O20:O28)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G31*0.15","v":0},null,null,{"$f":"J31*0.15","v":0},null,null,{"$f":"M31*0.15","v":0},{"$f":"N31*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G31+G32","v":0},null,null,{"$f":"J31+J32","v":0},null,null,{"$f":"M31+M32","v":0},{"$f":"N31+N32","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"]
[]
[]
[]
[]
[{"$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,"Vehicle Dashboard Cameras",{"$nulls":4},{"$f":"SUBTOTAL(9,G47:G54)","v":0},null,null,{"$f":"SUBTOTAL(9,J47:J54)","v":0},null,null,{"$f":"SUBTOTAL(9,M47:M54)","v":0},{"$f":"SUBTOTAL(9,N47:N54)","v":0},{"$f":"SUBTOTAL(9,O47:O54)","v":0}]
["1.1","Supply of Vehicle cameras per unit","Each",{"v":0,"d":"0%"},1,0,{"$f":"E47*F47","v":0},1,0,{"$f":"H47*I47","v":0},1,0,{"$f":"K47*L47","v":0},{"$f":"SUM(G47,J47,M47)","v":0},{"$f":"D47*N47","v":0}]
["1.2","Additional Vehicle Dashboard Cameras will be procured per unit on as and when needed basis via this contract.","Ad-Hoc",{"v":0,"d":"0%"},1,0,{"$f":"E48*F48","v":0},1,0,{"$f":"H48*I48","v":0},1,0,{"$f":"K48*L48","v":0},{"$f":"SUM(G48,J48,M48)","v":0},{"$f":"D48*N48","v":0}]
["1.3","Configure and customise the solution as required by SAPS.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.4","Install the latest software and data capturing equipments when required.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.5","Provide hardware and software maintenance (fixes, upgrades and patches) of the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.6","Provide second and third line technical and functional support for the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.7","Provide complete training manuals, in English, with each unit purchased, and train members in the use of vehicle dash cameras.","Each",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.8","Provide training if the software package is enhanced (upgrade of software) on the units purchased, in order to enhance user skills of members.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
[]
[]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G46:G54)","v":0},null,null,{"$f":"SUBTOTAL(9,J46:J54)","v":0},null,null,{"$f":"SUBTOTAL(9,M46:M54)","v":0},{"$f":"SUBTOTAL(9,N46:N54)","v":0},{"$f":"SUBTOTAL(9,O46:O54)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G57*0.15","v":0},null,null,{"$f":"J57*0.15","v":0},null,null,{"$f":"M57*0.15","v":0},{"$f":"N57*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G57+G58","v":0},null,null,{"$f":"J57+J58","v":0},null,null,{"$f":"M57+M58","v":0},{"$f":"N57+N58","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"]
[]
[]
[]
[{"$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,"Video Management Software",{"$nulls":4},{"$f":"SUBTOTAL(9,G72:G79)","v":0},null,null,{"$f":"SUBTOTAL(9,J72:J79)","v":0},null,null,{"$f":"SUBTOTAL(9,M72:M79)","v":0},{"$f":"SUBTOTAL(9,N72:N79)","v":0},{"$f":"SUBTOTAL(9,O72:O79)","v":0}]
["1.1","Supply of Video Management Software","Each",{"v":0,"d":"0%"},1,0,{"$f":"E72*F72","v":0},1,0,{"$f":"H72*I72","v":0},1,0,{"$f":"K72*L72","v":0},{"$f":"SUM(G72,J72,M72)","v":0},{"$f":"D72*N72","v":0}]
["1.2","Additional Video Management Software licenses will be procured on as and when needed basis via this contract.","Ad-Hoc",{"v":0,"d":"0%"},1,0,{"$f":"E73*F73","v":0},1,0,{"$f":"H73*I73","v":0},1,0,{"$f":"K73*L73","v":0},{"$f":"SUM(G73,J73,M73)","v":0},{"$f":"D73*N73","v":0}]
["1.3","Configure and customise the solution as required by SAPS.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.4","Install the latest software and data capturing equipments when required.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.5","Provide software maintenance (fixes, upgrades and patches) of the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.6","Provide second and third line technical and functional support for the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.7","Provide complete training manuals, in English, and train members in the use of Video Management Software.","Each",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.8","Provide training if the software package is enhanced (upgrade of software), in order to enhance user skills of members.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
[]
[]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G71:G79)","v":0},null,null,{"$f":"SUBTOTAL(9,J71:J79)","v":0},null,null,{"$f":"SUBTOTAL(9,M71:M79)","v":0},{"$f":"SUBTOTAL(9,N71:N79)","v":0},{"$f":"SUBTOTAL(9,O71:O79)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G82*0.15","v":0},null,null,{"$f":"J82*0.15","v":0},null,null,{"$f":"M82*0.15","v":0},{"$f":"N82*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G82+G83","v":0},null,null,{"$f":"J82+J83","v":0},null,null,{"$f":"M82+M83","v":0},{"$f":"N82+N83","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"]
[]
[]
[]
[{"$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,"Digital Evidence Management System",{"$nulls":4},{"$f":"SUBTOTAL(9,G97:G105)","v":0},null,null,{"$f":"SUBTOTAL(9,J97:J105)","v":0},null,null,{"$f":"SUBTOTAL(9,M97:M105)","v":0},{"$f":"SUBTOTAL(9,N97:N105)","v":0},{"$f":"SUBTOTAL(9,O97:O105)","v":0}]
["1.1","Supply of  Digital Evidence Management System","Each",{"v":0,"d":"0%"},1,0,{"$f":"E97*F97","v":0},1,0,{"$f":"H97*I97","v":0},1,0,{"$f":"K97*L97","v":0},{"$f":"SUM(G97,J97,M97)","v":0},{"$f":"D97*N97","v":0}]
["1.2","Additional Digital Evidence Management System licenses will be procured on as and when needed basis via this contract.","Ad-Hoc",{"v":0,"d":"0%"},1,0,{"$f":"E98*F98","v":0},1,0,{"$f":"H98*I98","v":0},1,0,{"$f":"K98*L98","v":0},{"$f":"SUM(G98,J98,M98)","v":0},{"$f":"D98*N98","v":0}]
["1.3","Configure and customise the solution as required by SAPS.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.4","Install the latest software and data capturing equipments when required.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.5","Provide software maintenance (fixes, upgrades and patches) of the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.6","Provide second and third line technical and functional support for the solution provided.","Monthly",{"v":0,"d":"0%"},12,0,0,12,0,0,12,0,0,0,0]
["1.7","Provide complete training manuals, in English, and train members in the use of Digital Evidence Management System.","Each",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.8","Provide training if the software package is enhanced (upgrade of software) on the units purchased, in order to enhance user skills of members.","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
["1.9","Ensure availability of Subject Matter Experts to testify in a court of law as and when required by SAPS","Ad-Hoc",{"v":0,"d":"0%"},1,0,0,1,0,0,1,0,0,0,0]
[]
[]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G96:G105)","v":0},null,null,{"$f":"SUBTOTAL(9,J96:J105)","v":0},null,null,{"$f":"SUBTOTAL(9,M96:M105)","v":0},{"$f":"SUBTOTAL(9,N96:N105)","v":0},{"$f":"SUBTOTAL(9,O96:O105)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G108*0.15","v":0},null,null,{"$f":"J108*0.15","v":0},null,null,{"$f":"M108*0.15","v":0},{"$f":"N108*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G108+G109","v":0},null,null,{"$f":"J108+J109","v":0},null,null,{"$f":"M108+M109","v":0},{"$f":"N108+N109","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"]