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

{"sheet":"PRICING SCHEDULE_01","index":0,"n_rows":42,"n_cols":17,"rows_kept":42,"merged":[[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],[38,1,41,1],[38,2,38,3],[38,4,38,5],[39,2,39,3],[40,2,40,3],[40,4,40,5],[41,2,41,3],[41,4,41,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No","RFB 2724/2022"]
["RFx Title","Design, Implementation, Maintenance and Support Of The Mining Licensing System For A Period Of One (1)-Years With An Additional Two (2)-Years Post Implementation Support Services In The Department Of Mineral Resources And Energy"]
["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":18.22,"d":"R18.22"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":19.57,"d":"R19.57"}]
[null,"1 Pound (UK)",{"v":22.15,"d":"R22.15"}]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"TOTAL"]
["Item No","Goods/Service description (Please list all goods and services to be provided) - as per scope of work on TOR","Unit of measure (Please list the unit of measure for the goods and services)","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1 ( leave it blank)","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,"[GOODS/SERVICE PACKAGE 1]",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G33)","v":0},null,null,{"$f":"SUBTOTAL(9,J21:J26)","v":0},null,null,{"$f":"SUBTOTAL(9,M21:M26)","v":0},{"$f":"SUBTOTAL(9,N21:N33)","v":0},{"$f":"SUBTOTAL(9,O21:O26)","v":0}]
[]
["1.1","Software Licencing","Number of (Annually)",{"v":0,"d":"0%"},1,null,{"$f":"E21*F21","v":0},null,0,{"$f":"H21*I21","v":0},null,0,{"$f":"K21*L21","v":0},{"$f":"SUM(G21,J21,M21)","v":0},{"$f":"D21*N21","v":0}]
[1.2,"Third Party Softwares","Number of (Annually)",{"v":0,"d":"0%"},1,null,{"$f":"E22*F22","v":0},null,0,0,null,0,0,0,0]
["1.3","Server Licensing","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.4,"Project Management","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.5,"Planning and Analysis ","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.6,"System Design and Implementation","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.6,"Professional Services","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,{"$f":"D27*N27","v":0}]
[1.7,"Coding and Development(Automation of the Solution)","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.8,"Integration with other System","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.9,"System Testing","Number of (Annually)",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
["1,10","Data Migration","once off",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
["1,11","Documentation and training of 9 provinces/ 15 regional offices  (1 group per pronvice or clustered provinces/ regions) ","once off per group",{"v":0,"d":"0%"},1,null,0,null,0,0,null,0,0,0,0]
[1.12,"Maintenance and Support ","Number of (Annually)",{"v":0,"d":"0%"},0,null,0,1,null,0,1,null,{"$f":"K33*L33","v":0},0,{"$f":"D33*N33","v":0}]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G33)","v":0},null,null,{"$f":"SUBTOTAL(9,J19:J33)","v":0},null,null,{"$f":"SUBTOTAL(9,M19:M33)","v":0},{"$f":"SUBTOTAL(9,N19:N33)","v":0},{"$f":"SUBTOTAL(9,O19:O33)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G34*0.15","v":0},null,null,{"$f":"J34*0.15","v":0},null,null,{"$f":"M34*0.15","v":0},{"$f":"N34*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G34+G35","v":0},null,null,{"$f":"J34+J35","v":0},null,null,{"$f":"M34+M35","v":0},{"$f":"N34+N35","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"]

{"sheet":"PRICING SCHEDULE_02","index":1,"n_rows":43,"n_cols":14,"rows_kept":43,"merged":[[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[16,4,16,6],[16,7,16,9],[39,1,42,1],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No","RFB 2724/2022"]
["RFx Title","Design, Implementation, Maintenance and Support Of The Mining Licensing System For A Period Of One (1)-Years With An Additional Two (2)-Years Post Implementation Support Services In The Department Of Mineral Resources And Energy"]
["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":18.22,"d":"R18.22"}]
[null,"1 Euro",{"v":19.57,"d":"R19.57"}]
[null,"1 Pound (UK)",{"v":22.15,"d":"R22.15"}]
[]
[{"$nulls":4},"YEAR 4 (Optional)",null,null,"YEAR 5 (Optional)",null,null,"TOTAL"]
["Item No","Goods/Service description (Please list all goods and services to be provided) - as per scope of work on TOR","Unit of measure (Please list the unit of measure for the goods and services)","Forex %","Qty","Unit Price \n(Excl VAT)","Line Price Y4","Qty","Unit Price \n(Excl VAT)","Line Price Y5","Line Price Term \n(Excl VAT)","Forex Price portion","BRAND / MODEL","Price clarification comment"]
[1,"[GOODS/SERVICE PACKAGE 1]",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G34)","v":0},null,null,{"$f":"SUBTOTAL(9,J21:J34)","v":0},{"$f":"K21+K22+K23+K24+K25+K26+K27+K28+K29+K30+K31+K32+K33","v":0},{"$f":"SUBTOTAL(9,L21:L34)","v":0}]
[]
["1.1","Software Licencing","Number of (Annually)",{"v":0,"d":"0%"},null,null,{"$f":"E21*F21","v":0},null,null,{"$f":"H21*I21","v":0},{"$f":"G21+J21","v":0},{"$f":"D21*K21","v":0}]
[1.2,"Third Party Softwares","Number of (Monthly)",{"v":0,"d":"0%"},null,null,{"$f":"E22*F22","v":0},null,null,{"$f":"H22*I22","v":0},{"$f":"G22+J22","v":0},0]
["1.3","Server Licensing","Number of (Monthly)",{"v":0,"d":"0%"},null,null,{"$f":"E23*F23","v":0},null,null,0,0,0]
[1.4,"Project Management","Number of (Annually)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
[1.5,"Planning and Analysis ","Number of (Annually)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
[1.6,"System Design and Implementation","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
[1.7,"Professional Services","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,{"$f":"D27*K27","v":0}]
[1.8,"Coding and Development(Automation of the Solution)","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
[1.9,"Integration with other System","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
[{"v":1.1,"d":"1.10"},"System Testing","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
[1.11,"Data Migration","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
["1.12","Documentation and training of 9 provinces/ 15 regional offices  (1 group per pronvice or clustered provinces/ regions) ","Number of (Monthly)",{"v":0,"d":"0%"},null,null,0,null,null,0,0,0]
["1.13","Maintenance and Support ","Number of (Monthly)",{"v":0,"d":"0%"},1,null,0,1,null,{"$f":"H33*I33","v":0},0,{"$f":"D33*K33","v":0}]
[{"$nulls":3},{"v":0,"d":"0%"},null,null,0,null,0,{"$f":"H34*I34","v":0},0,{"$f":"D34*K34","v":0}]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G34)","v":0},null,null,{"$f":"SUBTOTAL(9,J21:J34)","v":0},{"$f":"+K34+K33+K32+K31+K30+K29+K28+K27+K26+K25+K24+K23+K22+K21","v":0},{"$f":"SUBTOTAL(9,L19:L34)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G35*0.15","v":0},null,null,{"$f":"J35*0.15","v":0},{"$f":"K35*0.15","v":0},{"$f":"L35*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G35+G36","v":0},null,null,{"$f":"J35+J36","v":0},{"$f":"K35+K36","v":0},{"$f":"L35+L36","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,null,"Signature (above)"]