{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Evaluation Criteria","Fixed Price","Rate based Price","Bid Summary"],"not_rendered":{"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Evaluation Criteria","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"hidden":true,"merged":[[0,0,0,2]]}
["Council for Geoscience Evaluation Criteria"]
["No","Criteria","Scoring","Notes"]
[1,"Provide functional proposal that meets our specifications and related service requirements. A minimun score of 75% is required for each section.\n\n(Meets functional requirements)\n•   Average is 90% - 100% = 40 points\n•   Average is 80% - 89%   = 20 points\n•   Average is 75% - 79%   = 10 points\n•  Average is < 74%             =   0 points\n\nNB: Submit completed specifications spreadsheet (Functional Requirements)",40,{"$f":"IF(F20 <> FALSE, AVERAGE(E11:E19), \"One or more section is less than 75%\")","v":{"$error":"#REF!"}}]
[2,"Provide technical proposal that meets our specifications and related service requirements.\n\n(Meets technical requirements)\n•   Average is 90% - 100% =  20 points\n•   Average is 75% - 89%   =   10 points\n•  Average is < 74%             =   0 points\n\nNB: Submit completed specifications spreadsheet Technical Requirements)",20,{"$f":"E21","v":{"$error":"#REF!"}}]
[3,"Approach and Methodology: Describe the approach, methodology and plan (AMP) to be adopted during the review, implementation, execution and hosting. \n\nThe scoring will be based on the following:\n• No or incomplete AMP = 0 points\n• Complete and detailed AMP = 10 points\n",10]
[4,"Project Plan: Bidders are required to submit a project plan with their proposals. (Note: Go-live must be within 12 months) \n\nProject plan must also include the following tasks and deliverables:\n• Project Initiation\n• Change and Communication Management\n• Requirements Gathering\n• Implementation\n• Training\n• Skills Transfer \n• Data Management\n\nThe scoring will be based on the following:\n• No or incomplete project plan = 0 points\n• Complete and detailed project plan within the requested period = 10 points\n",10]
[5,"Provide signed letters from contactable references stipulating where an ERP implementation project of a similar size (minimum 500 users) has been successfully delivered by the Bidder in the last 10 years\n\n•   5 and more implementation references = 10 points\n•  3 - 4 implementation references = 5 points\n•  0 - 3 implementation references = 0 points",10]
[6,"Capacity and experience of the proposed team. The proposed team must demonstrate experience, qualifications and capabilities. The team leader must have al least 7 years' experience in the ERP environment (Attach CV, profile, past and current projects).\n\n•   7 or more years experience = 10 points\n•   5 -  7 years experience           =   5 points\n•   0 or less than  5 years experience           =   0 points",10]
[]
[null,null,"Total Points Achievable","Total Points Achieved","%","Check if >75"]
[null,"Human Resource Management",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B11)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"D11*100/C11","v":{"$error":"#REF!"}},{"$f":"AND(E11>75)","v":{"$error":"#REF!"}}]
[null,"Financial Management",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B12)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"D12*100/C12","v":{"$error":"#REF!"}},{"$f":"AND(E12>75)","v":{"$error":"#REF!"}}]
[null,"Supply Chain Management",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B13)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Geological Resources & Applied Geoscience",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B14)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Assets and Logistics Management",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B15)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Safety, Health, Environment & Quality (SHEQ)",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B16)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Marketing & Communication",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B17)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Internal Audit",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B18)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Risk & Compliance Management",{"$f":"COUNTIF(#REF!,'Evaluation Criteria'!B19)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":5},{"$f":"AND(E11>75, E12>75, E13>75, E14>75, E15>75, E16>75,E17>75,E18>75,E19>75)","v":{"$error":"#REF!"}}]
[null,"Technology",{"$f":"COUNTA(#REF!)","v":1},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[]
[]
[null,null,"   "]

{"sheet":"Fixed Price","index":1,"n_rows":20,"n_cols":2,"rows_kept":20}
["                                 FIXED  PRICING SCHEDULE"]
["Work Breakdown Structure","Fixed Costs VAT inclusive"]
["(1) VALUE ASSURANCE EXERCISE THE PROJECT WITH SAP"]
["Conduct a Value assurance exercise with SAP",0]
["(2)PROJECT MANAGEMENT",0]
["(3)CHANGE MANAGEMENT",0]
["(4)TRAINING",0]
["Execute Training as per scope of work",0]
["(5) SUPPORT AND MAINTENANCE"]
["Ongoing OEM Software Maintenance on retainer basis (i.e. SAP B1 and SAP 4/Hana) for 24 months",0]
["Value Added Reseller (VAR) Implementation Support on retainer basis for 24 months",0]
["Other (please specify)",0]
["GRAND TOTAL (VAT Inclusive)",{"$f":"SUM(B4:B12)","v":0}]
[]
[]
[]
["NAME OF THE BIDDER","SIGNATURE"]
[]
[]
[null,"DATE"]

{"sheet":"Rate based Price","index":2,"n_rows":116,"n_cols":5,"rows_kept":116,"merged":[[0,0,0,1],[109,0,109,4]]}
["                                 RATE  PRICING SCHEDULE"]
[]
["Work Breakdown Structure","Indicate Role ","Estimated Hours","Fixed Rate/Hour VAT inclusive","Fixed Rate/Hour VAT inclusive"]
["(1) RESOURCES FOR IMPLEMENTATION"]
["(A) Teamleads and SMME's"]
[" Project management"]
["e.g. (1) Lead consultant",null,50,null,{"$f":"D7*C7","v":{"v":0,"d":"R0.00"}}]
["        (2) Consultant",null,50,null,{"$f":"D8*C8","v":{"v":0,"d":"R0.00"}}]
["Change Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
["Finance"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" HR"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Audit"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Data Governance"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
["Analytics"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
["Integration"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
["Security and access control"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
["(B) Technical and Functional "]
["Finance"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Supply Chain Management & electronic Procurement"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Project Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Assets Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Contract Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Sales and Distribution"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Customer Relationship Management (CRM) & CRM Portal"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Inventory Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Travel Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Compensation Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Payroll"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Cross-Application Timesheets"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Performance Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"$f":"D72*C72","v":{"v":0,"d":"R0.00"}}]
[" Portal Employee Self Service and Manager Self Service"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Electronic Recruitment"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Learning Solution"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Organizational Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Personnel Administration"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Time Management (Leave)"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Safety Health Environmental and Quality"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Corporate Scorecard (Analytics and Reporting)"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Audit Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Risk Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[" Facilities Management (Plant Maintenance)"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
["Fleet Management"]
["e.g. (1) Lead consultant",null,50,null,{"v":0,"d":"R0.00"}]
["        (2) Consultant",null,50,null,{"v":0,"d":"R0.00"}]
[null,null,"TOTAL PRICE VAT INCLUSIVE",null,{"$f":"SUM(E7:E108)","v":{"v":0,"d":"R0.00"}}]
["NB: After the review exercise the service provider will be expected to submit a fixed price for milestones based on the consultants fixed price.  The estimated hours and total price are for evaluation purpose only"]
[]
[]
["NAME OF THE BIDDER",null,null,"SIGNATURE"]
[]
[]
[{"$nulls":3},"DATE"]

{"sheet":"Bid Summary","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,0,4,4],[5,1,5,6],[6,1,6,6],[7,1,7,6],[9,0,9,7]]}
["ESTIMATED TOTAL BID SUMMARY"]
[]
[]
[]
[]
["FIXED PRICE",{"$nulls":6},{"$f":"'Fixed Price'!B13","v":0}]
["RATE BASED PRICE",{"$nulls":6},{"$f":"'Rate based Price'!E109","v":0}]
["ESTIMATED TOTAL BID",{"$nulls":6},{"$f":"SUM(H6:H7)","v":0}]
[]
["NB: Estimated total for rate based prices are for evaluation purpose only"]
[]
["NAME OF THE BIDDER",{"$nulls":5},"SIGNATURE"]
[]
[]
[{"$nulls":6},"DATE"]