{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Technical requirements","Evaluation Criteria"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Technical requirements","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"merged":[[1,0,2,1],[5,0,5,4],[6,0,7,0],[6,1,7,1],[6,2,6,3],[6,4,7,4],[11,0,11,1],[13,0,13,1]]}
[]
["Name of the Bidder:"]
[]
[]
[]
["MANDATORY REQUIREMENTS"]
["No","Description","Response",null,"Comments"]
[null,null,"COMPLY","NOT COMPLY"]
[1,"Design a powered Modular Conveyor Platform roller table to accommodate tray sizes of 1 570 mm X 410 mm X 720 mm. The new tables must fit 100% with existing Interrolll roller tables or similar (see Photo A).\nSupporting specifications:\nRoller pitch 90mm\nZone Conveyor lengths = 1620 mm\nThe design should include both powered, straight roller conveyors as well as powered roller conveyor curves to change the transport direction of core trays. Number of each unit to be determine by design.\nCore trays can weigh up to 35 kg\nRoller material - steel\nFull powered installation for conveyor system must be included\nSupport and end caps must be included\nAdjustable support feet based on the approved design must be included "]
[]
[]
["Signature:"]
[]
["Date: "]

{"sheet":"Evaluation Criteria","index":1,"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,"   "]