{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Cover Sheet","Returnables_ Instructions","Returnables","Phase 1 Instructions","Phase 1","Phase 2 Instructions","Phase 2","Phase 3 Instructions","Phase 3_Capacity Planning","Phase 3_Base Train Planning","Phase3_Production Planning","Phase3_EMDM Functional Criteria","Phase3_ Planning & Simulation","Phase 3_Master Data","Phase 4_Instruction"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Integrated Train Planning "]
["Transnet Freight Rail"]
[]
[]
["Annexure D_Evaluation Criteria"]
[]
["To be read in conjuction with relevant section(s) of the RFP"]

{"sheet":"Returnables_ Instructions","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,1,8,2],[9,1,9,2],[5,1,5,2],[6,1,6,2],[4,1,4,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[7,1,7,2],[0,1,0,3]]}
[null,"RETURNABLES INSTRUCTIONS"]
[null,"Assessment Item",null,"Failure to provide all Returnable Documents used for purposes of scoring a bid, by the closing date and time of this bid will not result in a Respondent’s disqualification. However, Bidders will receive an automatic score of zero for the applicable evaluation criterion "]
[null,"Response  to Requirement",null,"Definition and Criteria"]
[null,"Specific Requirement",null,"Requisite documentation to be submitted by the Bidder. Specific requirements will be indicated at Transnet Freight Rail discretion."]
[null,"Evidence",null,"Proof of compliance that the Bidder should provide"]
[null,"Additional Guidelines",null,"Supporting information to guide the Bidder in responding to specific requirement."]
[null,"Customer reference",null,"List the customers at which the skill was applied."]
[null,"Reference page / paragraph",null,"Specific reference in the proposal where the requirement is addressed."]
[null,"Assumptions ( If applicable)",null,"Any assumptions you might be making as it pertains to the requirement, our organization, our use of the solution, etc."]
[null,"Any Comments",null,"Please utilize this column for any additional explanations, clarifications, or responses where the \"response criteria\" is something other than \"Y\" - Yes."]

{"sheet":"Returnables","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["\nFailure to provide all Returnable Documents used for purposes of scoring a bid, by the closing date and time of this bid will not result in a Respondent’s disqualification. However, Bidders will receive an automatic score of zero for the applicable evaluation criterion"]
["No.","Function","Supports / Implements:","Specific Requirement","Evidence","Additional Guidelines","Customer reference","Reference page / paragraph","Assumptions (If applicable)","Any Comments"]
[" ","Architecture Requirements"]
[1,"Architecture Requirements","Provide a high level solution architecture diagram that depicts the following: \nvertically integrated scenario and \nvertically separated scenario.","Provide high level solution architecture document.","High level solution architecture document.","TFR is the infrastructure owner and the main operator. "]
[2,"Architecture Requirements","Provide hardware specifications required per module / component, including processing, memory and storage requirements.","Specify the requirements in the proposal","Hardware specifications document"]
[" ","Solution Integration Requirements"]
[3,"Solution Integration Requirements","Provide the integration architecture that will be used to efficiently integrate solution components.","Provide Integration architecture document.","Integration architecture document."]
[" ","Post Implementation Support"]
[4,"Licensing, Maintenance and Support","Provide proposal for licensing, maintenance and support /  premium SME support.","Provide licensing, maintenance and support Proposal","Licensing, maintenance and support proposal document."]
[" ","Project Management"]
[5,"Project Management ","Provide project execution plan depicting delivery of the full solution and its calibrated master data over a 3 year period.","Provide project execution plan","Project execution plan"]
[6,"Project Management ","Provide value streams for how each capability will be implemented.","Provide value streams per capability","Value stream mapping"]
[7,"Project Management ","Provide Agile/DevOps project management delivery approach aligned to SAFe.","Provide delivery approach / methodology","Delivery approach "]
[8,"Project Management ","Provide a human resource plan for the programme and sub-projects.","Provide a human resource plan for the programme and sub-projects","Human resource plan for the programme and sub-projects"]
[" ","Training"]
[9,"Training","Provide a detailed training strategy and implementation plan supporting the deployment of all solutions","Provide training strategy and plan","Training strategy and plan"]
[10,"Training","Provide qualifications and accreditations for training resources with experience in the required capabilities.","Provide certification and accreditation for training resources","Certification and accreditation for training resources"]
[11,"Training","Provide customer references of where the end user training services were conducted.","Provide reference letters from customers","Reference letters from customers"]
[" ","Change Management"]
[12,"Change Management","Provide a detailed and comprehensive change management methodology, including all key facets of change management","Provide change management methodology","Change management methodology"]
[13,"Change Management","Provide customer references of where change management services were conducted.","Provide reference letters from customers","Reference letters from customers"]
[14,"Change Management","Provide a comprehensive change management plan, stating all relevant change management activities aligned with the project plan","Provide change management Plan","Change management Plan"]
[" ","Quality Assurance "]
[15,"Quality Assurance ","Provide effective end-to-end testing services, aligned with the project plan.  ","Provide test strategy and Plan","Test strategy and Plan"]
[" ","Experience and Team Composition"]
[16,"Experience and Team Composition","Provide  a breakdown of resources skill set and their qualifications aligned to each capability","Provide a breakdown of resources and their qualifications for the delivery of each capability","Actual qualifications / certifications"]
[17,"Experience and Team Composition","Provide resumes that reflects the resource experience that is relevant to the capabilities, and include an outline of any work done in the Freight Rail Industry for a minimum of five years.  ","Provide resumes ","CV for each resource"]

{"sheet":"Phase 1 Instructions","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5],[11,1,11,2],[12,1,12,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[9,1,9,2],[10,1,10,2],[8,1,8,2],[1,3,1,5],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"STAGE 1 STEP 2 INSTRUCTIONS"]
[null,"Assessment Item",null,"Bidder Instructions:\nThe Bidder needs to provide page and paragraph references to the evidence documentation  which will be used for the evaluation. \n\nEvaluator Instructions:\nThe submission will be evaluated based on the evidence provided according to the evaluation criteria question."]
[null,"Response  to Requirement",null,"Scores","Code","Definition and Criteria"]
[null,"Specific Requirement",null,null,null,"Requisite documentation to be submitted by the Bidder. Specific requirements will be indicated at Transnet Freight Rail discretion."]
[null,"No Response","No Response",0,"For office use","The Bidder did not respond to the requirement by including the specific requirement in the proposal (no evidence provided)."]
[null,"Poor","Poor",1,"For office use","Less than 80% of the components comply with the requirements."]
[null," Good"," Good",6,"For office use","More than 80%, less than 100% components comply with the requirements"]
[null,"Excellent",null,10,"For office use","All of the solutions proposed by the Bidder meets TFR requirements."]
[null,"Evidence",null,null,null,"Proof of compliance that the Bidder should provide"]
[null,"Customer reference",null,null,null,"List the customers at which the skill was applied."]
[null,"Reference page / paragraph",null,null,null,"Indicate specific reference in the proposal where the requirement is addressed. TFR reserve the right to discount the response where specific reference is not indicated in the proposal."]
[null,"Assumptions ( If applicable)",null,null,null,"Any assumptions you might be making as it pertains to the requirement, our organization, our use of the solution, etc."]
[null,"Any Comments",null,null,null,"Please utilize this column for any additional explanations, clarifications, or responses where the \"response criteria\" is something other than \"Y\" - Yes."]

{"sheet":"Phase 1","index":4,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["No.","Function","Supports / Implements:","Specific Requirement","Evidence","Additional Guidelines","Customer reference","Reference page / paragraph","Assumptions ( If Applicable)","Any Comments"]
[" ","Architecture Requirements"]
[1,"Architecture Requirements"," Do  all the solution components  run on the latest server operating system (Windows, Linux, Unix)?","Indicate operating systems per solution component","Operating systems per solution component"]
[2,"Architecture Requirements","Will each solution component that is browser based able to run on the latest version of the following browsers Google Chrome and Microsoft Edge? ","Indicate browser technology per solution(Chrome/Edge)","Browser technology per solution(Chrome/Edge)"]
[3,"Architecture Requirements","Will the solution components enable the identification of the records for delta extracts? (example daily / hourly / near real time extracts of new and changed records)?","Indicate delta extracts per solution component","Delta extracts per solution component"]
[4,"Architecture Requirements","Will the solution components be accessed through TFR Portal (Current portal is the SAP Portal)? ","Provide high level solution architecture document.","High level solution architecture document."]
[5,"Architecture Requirements","Does the Execution Monitoring and Deviation Management solution have standard mobile capability enabled?   ","Provide high level solution architecture document.","High level solution architecture document."]
[6,"Architecture Requirements","Will the solution components allow for single sign-on through TFR active directory?  ","Provide high level solution architecture document.","High level solution architecture document."]
[7,"Architecture Requirements","Are all network requirements for running all modules (catering for all users) specified in the proposal?","Specify network requirements in the proposal","Network requirements in the proposal"]
[8,"Architecture Requirements","Does the proposal specify recommended hardware specifications required per module / component, including processing, memory and storage requirements?","Specify the requirements in the proposal","Hardware specifications in the proposal"]
[9,"Architecture Requirements","Does the solution have standard GIS capability enabled?","Provide high level solution architecture document.","High level solution architecture document."]
[10,"Architecture Requirements","Are the solution components cloud ready?(if solution not cloud ready provide roadmap with timelines for cloud readiness).","Provide Cloud architecture or cloud readiness roadmap","Cloud architecture or cloud readiness roadmap"]
[11,"Architecture Requirements","Are the solution components cloud service provider agnostic?","Provide Cloud architecture or cloud readiness roadmap","Cloud architecture or cloud readiness roadmap"]
[12,"Architecture Requirements","Are the solution components containerised and able to be seamlessly migrated to any cloud platform?","Provide evidence that the solution components can be containerised (Cloud-native)","Evidence that the solution components can be containerised (Cloud-native)"]
[13,"Architecture Requirements","Are the solution components provided as Software as a Service (SaaS)?","Provide evidence that the solution components SaaS","Evidence that the solution components SaaS"]
[14,"Architecture Requirements","Are standard error handling practices followed in developing custom code?","Provide evidence that the error handling processes are as per best practice","Evidence that the error handling processes are as per best practice"]
[15,"Architecture Requirements","Does the proposal provide a high level solution architecture that depicts the vertically integrated scenario?","Provide high level solution architecture document.","High level solution architecture document.","TFR is the infrastructure owner and the main operator. "]
[16,"Architecture Requirements","Does the vertically integrated architecture diagram link the proposed solutions to the capabilities and sub capabilities in the statement of work? ","Provide high level solution architecture document.","Provide the vertically integrated architecture diagram depicting the   capabilities and sub capabilities in the statement of work.\nThe architecture diagram should indicate the relationship and integration points amongst capabilities. ","Refer to the capability diagram"]
[17,"Architecture Requirements","Does the proposal provide a high level solution architecture that depicts the vertically separated scenario?","Provide high level solution architecture document.","Provide the high level solution architecture diagram that depicts the vertically separated scenario.","The proposed architecture should define how the infrastructure owner and operators will interact on the proposed solution"]
[18,"Architecture Requirements","Does the vertically separated architecture diagram link the proposed solutions to the capabilities and sub capabilities in the TDR? ","Provide high level solution architecture document.","Vertically separated architecture diagram depicting the   capabilities and sub capabilities in the statement of work.\nThe architecture diagram should indicate the relationship and integration points amongst capabilities. "]
[19,"Architecture Requirements","Do all the solutions user interfaces run on the latest version of Windows?","Provide high level solution architecture document.","Evidence that the solution user interface run / can run on the latest operating system version. (Latest -1)"]
[20,"Architecture Requirements","Does the proposal contain evidence that the solution components uses the Microsoft active directory to do user authentication?  ","Provide high level solution architecture document.","Evidence that the solution will seamlessly integrate with Microsoft active directory for user authentication"]
[21,"Architecture Requirements","Do the solution components adhere to the best practice security standards (minimum baseline security standards as per Security standards reference number NIST.SP.800-53B)? ","Provide high level solution architecture document.","Evidence that the solution adhere to the best practice baseline security standards"]
[" ","Solution Integration Requirements"]
[22,"Solution Integration Requirements","Does the integration architecture demonstrate how the solution will consume and expose data between different components of the solution?","Provide integration architecture document.","Integration architecture document."]
[23,"Solution Integration Requirements","Does the integration architecture demonstrate how data will be integrated seamlessly and near real time within the solution components?","Provide integration architecture document.","Integration architecture document."]
[24,"Solution Integration Requirements","Does the proposed architecture demonstrate the use of TFR middleware to consume and expose data external to the proposed solution components?","Provide integration architecture document.","Integration architecture document."]
[25,"Solution Integration Requirements","Does the solution components expose and consume API's? ","Provide integration architecture document.","Integration architecture document."]
[26,"Solution Integration Requirements","Does the proposed API services align with the micro services architecture?","Provide integration architecture document.","Integration architecture document."]
[27,"Solution Integration Requirements","Does the solution components expose and consume SOAP web services? ","Provide integration architecture document.","Integration architecture document."]
[28,"Solution Integration Requirements","Can the proposed solution components integrate across on premise and cloud?","Provide integration architecture document.","Integration architecture document."]
[" ","Post Implementation Support"]
[29,"Licensing, Maintenance and Support","Did the proposal include the implementation of the product updates? ","Provide proposal document","Proposal document"]
[30,"Licensing, Maintenance and Support","Did the proposal include the implementation of the product patches? ","Provide proposal document","Proposal document"]
[31,"Licensing, Maintenance and Support","Did the proposal include the implementation of product fixes? ","Provide proposal document","Proposal document"]
[32,"Licensing, Maintenance and Support","Did the proposal include upgrades to the latest supported version of the product during the product lifecycle?","Provide proposal document","Proposal document"]
[33,"Licensing, Maintenance and Support","Did the Bidder submit the proposal for licensing, maintenance and support for 10 years? ","Licensing, maintenance and support Proposal","Proposal for licensing, maintenance and support for 10 years."]
[34,"Licensing, Maintenance and Support","Did the proposal include enablement of latest features due to product updates and upgrades during the maintenance and support period?","Licensing, maintenance and support Proposal","Provide the proposal which includes commitment to enable the latest features due to product updates and upgrades during the maintenance and support period."]
[35,"Premium SME Support","Did the proposal include training for skills transfer of work done by specialist SME?","Provide proposal document","Proposal document"]
[36,"Premium SME Support","Did the proposal include specialised tuning of environment to ensure well performing production system?","Provide proposal document","Proposal document"]
[37,"Premium SME Support","Did the proposal include consulting services on best way to implement configurations as to not impede future upgrades to the system?","Provide proposal document","Proposal document"]
[38,"Premium SME Support","Did the proposal include access to specialist  SME’S to guide on how to make best use of product capabilities to meet business need?","Provide proposal document","Proposal document"]
[39,"Premium SME Support","Did the proposal include major incident support, incident monitoring and escalation management, problem management and determination Cross platform)?","Provide proposal document","Proposal document"]
[40,"Premium SME Support","Did the proposal include monthly reports (Environment health checks)?    ","Provide proposal document","Proposal document"]
[41,"Premium SME Support","Did the proposal include performance monitoring  on the product?","Provide proposal document","Proposal document"]
[42,"Premium SME Support","Does the premium support make provision for additional changes and required customisation and configuration? ","Provide proposal document","Proposal document"]
[43,"Premium SME Support","Did the Bidder submit the proposal for premium SME support for 10 years? ","Premium SME support proposal","Evidence that the  proposal includes  premium SME support hours over a period of 10 years."]
[44,"Premium SME Support","Did the proposal include product consulting (at least optimal utilisation, improvement reviews, warranty forecasts, IMAC coordination, product guidance)?    ","Premium SME support proposal","Evidence that the  proposal include product consulting (at least optimal utilisation, improvement reviews, warranty forecasts, IMAC coordination, product guidance).    "]

{"sheet":"Phase 2 Instructions","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[11,1,11,2],[1,3,1,5],[10,1,10,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[null,"IMPLEMENTATION APPROACH INSTRUCTIONS"]
[null,"Functionality Assessment",null,"Bidder Instructions:\nThe Bidder needs to provide page and paragraph references to the evidence documentation  which will be used for the evaluation. \n\nEvaluator Instructions:\nThe submission will be evaluated based on the evidence provided according to the evaluation criteria question.  A factor of 1.5 will be applied to critical questions and 1 to non-critical questions."]
[null,"Response  to Requirement",null,"Scores","Code","Definition and Criteria"]
[null,"Critical Requirement",null,null,"Y/N","Evaluation Criteria that are the minimum requirement to support the process. "]
[null,"Specific Requirement",null,null,null,"Requisite documentation to be submitted by the Bidder. Specific requirements will be indicated at Transnet Freight Rail discretion."]
[null,"No Response","No Response",0," ","The Bidder did not respond to the requirement."]
[null,"Poor","Poor",1," ","The Bidder does not understand the requirements."]
[null,"Fair","Fair",4," ","The Bidder understands the concept, however cannot explain the application of the concept."]
[null," Good"," Good",6," ","The Bidder understands the concept and can explain the application of the concept."]
[null,"Very Good","Very Good",8," ","The Bidder understands the concept, can explain the application of the concept and provided detail on how to apply the concept on the project."]
[null,"Excellent",null,10," ","The Bidder understands the concept, can explain the application of the concept, provided detail on how to apply the concept on the project and provided proof of previous applications."]
[null,"Customer reference",null,null,null,"List the customers at which the skill was applied."]
[null,"Solution",null,null,null,"Identify the methodology and approach which will meet this requirement."]
[null,"Reference page / paragraph",null,null,null,"Specific reference in the proposal where the requirement is addressed."]
[null,"Assumptions",null,null,null,"Any assumptions you might be making as it pertains to the requirement, our organization, our use of the solution, etc."]
[null,"Comments",null,null,null,"Please utilize this column for any additional explanations, clarifications, or responses where the \"response criteria\" is something other than \"Y\" - Yes."]

{"sheet":"Phase 2","index":6,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["No.","Category","Supports / Implements:","Critical Requirement (Y/N)","Specific Requirement","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Training"]
[1,"Training","Does the proposal provide a detailed training strategy and implementation plan supporting the deployment of all solutions?","Y","Training Strategy and Plan"]
[2,"Training","Does the proposal make provision for the development of user training manuals and assessment tools for all modules for the eventual handover to Transnet Academy?","Y","Training Strategy and Plan"]
[3,"Training","Does the proposal cater for role based training material?","N"]
[4,"Training","Will the development of training material use the business process as basis?","N"]
[5,"Training","Does the proposal make provision for class-room based and e-learning training for the duration of project execution?","Y","Training Strategy and Plan"]
[6,"Training","Does the proposal identify the different user groups who will require training as part of the training approach and deployment (eg.  super users, end users, management, system administration)?","N"]
[7,"Training","Does the proposal make provision for on the job knowledge transfer over and above formal training and qualification?","Y","Knowledge Transfer Strategy"]
[8,"Training","Does the proposal suggest minimum qualification requirements for TFR for the use of the modules?","N"]
[9,"Training","Did the Bidder stipulate the qualification of resources who will be providing end user training for each capability?","Y","Certification and accreditions from accredited bodies"]
[10,"Training","Did the Bidder stipulate their experience in providing end user training for each capability?","N","Verifiable Reference letters from customers. "]
[11,"Training","Does the proposal contain verifiable customer references of where the service provider have conducted training?","Y","Verifiable Reference letters from customers. "]
[" ","Change Management"]
[12,"Change Management","Does the proposal contain the provision of a detailed and comprehensive change management methodology, including all key facets of change management?","N"]
[13,"Change Management","Does the proposal make provision for a comprehensive change management plan, stating all relevant change management activities aligned with the project plan?","Y","Provide change management methodology"]
[14,"Change Management","Does the change management methodology that has been proposed in line with TFR's methodology (Transnet Change Methodology)?","N"]
[15,"Change Management","Does the proposal provide evidence of the service provider’s ability to build change agent capabilities inside TFR to sustain the change?","N"]
[16,"Change Management","Does the proposal contain the change readiness assessment and post implementation assessment of where the service provider have conducted change management?","N"]
[17,"Change Management","Does the post implementation assessment reflect adoption and use of the solution implemented at the customer?","N"]
[18,"Change Management","Does the proposal contain customer references of where the service provider have conducted change management?","N","Verifiable Reference letters from customers, adoption and utilisation report."]
[19,"Change Management","Does the Bidder demonstrate extensive change management experience in implementing a programme of this magnitude and complexity?","N"]
[" ","Previous Demonstrated Capability"]
[20,"Previously Demonstrated Capability","Does the proposal contain evidence that submitted capability solutions have been successfully implemented in at least one reference site and still in use?","Y","Verifiable Reference letters from customers"]
[21,"Previously Demonstrated Capability","Does the proposal contain evidence that the solution been implemented successfully for a period exceeding one year?","N"]
[22,"Previously Demonstrated Capability","Does the cited reference site(s) match the complexity of the TFR operational environment (size and complexity of network, number of hubs, number of trains per day, electrified mixed traffic)?","N","Customer company statistics"]
[23,"Previously Demonstrated Capability","Does the core vendor project team possess the requisite qualifications to implement and customise a solution of this complexity and magnitude?","N"]
[24,"Previously Demonstrated Capability","Does the core project execution team (dedicated resource) members have a minimum of 5 years of relevant railway experience?","Y","Provide resumes (CV)"]
[" ","Project Management "]
[25,"Project Management ","Does the project plan proposal meet the requirement for the delivery of the full solution and its calibrated master data for completion in 3 years? ","Y","Project plan depicting delivery of the full solution and its calibrated master data over a 3 year period."]
[26,"Project Management ","Did the Bidder provide an Agile/DevOps project management delivery approach aligned to SAFe?","Y","Provide a project delivery approach aligned to Agile/DevOps (SAFe)"]
[27,"Project Management ","Did the bidder provide a program backlog and Epics that relate to the capabilites?","Y","Provide a High-Level Program Backlog with proposed Epics  "]
[28,"Project Management ","Did the bidder define the value streams for each capability?","Y","Provide value streams for how each capability will be implemented "]
[29,"Project Management ","Did the bidder provide the solution backlog with best practice features and enablers?","Y","Provide a High-Level Solution Backlog with best practice features and enablers"]
[30,"Project Management ","Did the bidder provide a development approach aligned to agile/DevOps implementation methodology?","N","Provide a development approach aligned to Agile/ DevOps "]
[31,"Project Management ","Did the bidder provide a deployment approach in an agile/DEVOPS manner?","N","Provide a deployment approach aligned to Agile/ DevOps "]
[32,"Project Management ","Did the bidder provide the flight plan for all the capabilities?","N","Provide a flight plan for the implementation of all capabilities "]
[33,"Project Management ","Did the bidder suppliy detailed project execution plans for each capability?","N","Provide detailed project execution plans for each capability"]
[34,"Project Management ","Did the bidder supply the milestones and deliverables for each capability?","N","Provide milestones and deliverables for each capability"]
[35,"Project Management ","Did the bidder supply a High-Level RACI chart for the milestones and deliverables for each capability?","N","Provide a High-Level RACI chart for the delivery of each capability "]
[36,"Project Management ","Did the bidder provide  a breakdown of resources and their qualifications for each capability?","N","Provide a breakdown of resources and their qualifications for the delivery of each capability"]
[37,"Project Management ","Did the bidder demonstrate a full understanding of the interdependecies and pre-requisites?","N","Provide a diagram of solution  interdependecies and pre-requisites "]
[38,"Project Management ","Are the qualifications aligned to the delivery of the capabilities using Agile/DEVOps? ","N","Provide proof that the execution teams qualifications are aligned to the delivery of the capabilities using Agile/DEVOps"]
[39,"Project Management ","Does the proposal provide a human resource plan for the programme and sub-projects?","N","Provide a human resource plan for the programme and sub-projects (Including RACI)"]
[40,"Project Management ","Does the proposal provide a data migration delivery approach for the programme and for each project, including data, owner and data matrix requirements?","N","Provide a data migration delivery approach for the programme and for each project, including data, owner and data matrix requirements"]
[41,"Project Management ","Did the Bidder provide resumes indicating resource familiarity with allocated Proposed Solution roles, process/capability focus areas and tasks, as well as relevant experience, and include an outline of any work done in the Freight Rail Industry over the past five years?  ","Y","Provide resumes (CV)."]
[42,"Project Management ","Did the Bidder provide a business continuity plan that denotes suitably qualified implementation team members that will be available throughout the project execution?","Y","Provide Business continuity plan for human resources"]
[43,"Project Management ","Did the Bidder provide an experienced agile coach to assist the implementation team during project execution?","N"]
[44,"Project Management ","Did the Bidder provide a knowledge and skills transfer plan?","Y","Provide a knowledge and skills transfer plan"]
[" ","Quality Assurance"]
[45,"Solution Testing ","Does the proposal provide a detailed testing strategy and implementation plan supporting of all solutions?","Y","Testing strategy and plan"]
[46,"Solution Testing ","Did the Bidder provide a list of test categories to be conducted with the relevant artefacts?","Y","Testing strategy and plan"]

{"sheet":"Phase 3 Instructions","index":7,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,2],[14,1,14,2],[16,1,16,2],[17,1,17,2],[20,1,20,2],[22,1,22,2],[15,1,15,2],[18,1,18,2],[13,1,13,2],[19,1,19,4],[12,1,12,4],[21,1,21,2],[23,1,23,2],[11,1,11,2],[3,1,3,2],[4,1,4,2],[5,1,5,4],[7,1,7,2],[10,1,10,2],[8,1,8,2],[9,1,9,2],[0,1,0,4],[1,1,1,2],[2,1,2,2],[6,1,6,2],[1,3,1,4]]}
[null,"FUNCTIONALITY REQUIREMENTS INSTRUCTION"]
[null,"Assessment Item",null,"Bidder Instructions:\nPlace an 'X\" in the appropriate response code column (Functionality assessment and Industry Assessment). The Bidder needs to provide page and paragraph references to the evidence documentation  which will be used for the evaluation. All functionality and industry responses will be verified against the Bidders submission to qualify the indicated score. If the response cannot be verified or satisfactorily substantiated against the submission the score will be moderated accordingly. \n\nEvaluator Instructions:\nThe submission will be evaluated based on the evidence provided according to the evaluation criteria question. A factor of 1.5 will be applied to critical questions and 1 to non-critical questions\n"]
[null,"Response  to Requirement",null,"Code","Definition and Criteria"]
[null,"Critical Requirement",null,"Y/N","Evaluation Criteria that are the minimum requirement to support the process."]
[null,"Specific Requirement",null,null,"Requisite documentation to be submitted by the Bidder. Specific requirements will be indicated at Transnet Freight Rail discretion."]
[null,"Functionality Assessment"]
[null,"Out Of Box",null,"OTB (10)","Functionality exists, out-of-box, with no configuration or modification.  Functionality to meet this requirement is installed and operational at other sites and can be demonstrated to the organization."]
[null,"Configuration",null,"C  (8)","Functional requirement is met through configuration changes to the existing system. “Configuration” includes changes via administration consoles or changes to parameters within system configuration files. "]
[null,"Supplied by Third Party – Embedded",null,"TE (7)","Functional requirement is met or provided by third-party software package and is included in this proposal.  Functionality to meet this requirement is installed and operational at other sites and can be demonstrated to the organization. Capability is fully embedded in and does not require maintenance of the integration with the core package. Addiitional third-party software license costs (if applicable) must be listed in the Costing Matrix."]
[null,"Supplied by Third Party - Not Embedded",null,"T (5)","Functional requirement is met or provided by third-party software package and is included in this proposal.  Functionality to meet this requirement is installed and operational at other sites and can be demonstrated to the organization. Capability is “bolt-on” and will require maintenance of the integration with the core package as well as future updates, upgrades, or software patches to the 3rd party component. Addiitional third-party software license costs must be listed in the Costing Matrix."]
[null,"Modification",null,"M (4)","Functional requirement will be met through programmatic changes, enhancements or extensions to the system source code. Such changes imply future maintenance consideration, such as analysis, planning, potential changes and enhancements, re-application during updates, upgrades, or when applying software patches."]
[null,"No  ",null,"N (0)","Functional requirement will not be provided by system or Requirement will be met by proposed solution that is currently under development, in Beta test, or otherwise not yet released."]
[null,"Industry Implementation Assessment"]
[null,"Freight Rail Industry",null,"FR (10)","The solution is implemented in the Freight Rail industry"]
[null,"Passenger Rail Industry",null,"PR (7)","The solution is implemented in the Passenger Rail industry"]
[null,"Transportation Industry",null,"TI (4)","The solution is implemented in the Transportation industry"]
[null,"Logistics Industry",null,"LI (4)","The solution is implemented in the Logistics industry"]
[null,"Other industry",null,"O (0)","The solution is implemented in other industries"]
[null,"No Industry",null,"NA (0)","The solution has not been applied at all "]
[null,"General "]
[null,"Customer reference",null,null,"List the customers at which the solution is implemented."]
[null,"Solution",null,null,"Identify the software module or tool which will meet this requirement.  If this is an additional or \"add-on\" product beyond your core offering, for which additional licensing would be required, please note this in the comments section."]
[null,"Reference page / paragraph",null,null,"Specific reference in the proposal where the requirement is addressed."]
[null,"Assumptions",null,null,"Any assumptions you might be making as it pertains to the requirement, our organization, our use of the solution, etc."]
[null,"Comments",null,null,"Please utilize this column for any additional explanations, clarifications, or responses where the \"response criteria\" is something other than \"Y\" - Yes."]

{"sheet":"Phase 3_Capacity Planning","index":8,"n_rows":92,"n_cols":22,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,5,1,10],[1,11,1,16]]}
["Base Train Planning and Capacity Planning Evaluation Criteria"]
[" ",null,null,null,null,"Functionality Assessment",null,null,null,null,null,"Industry Assessment"]
["No.","Function","Supports / Implements:","Critical Requirement","Specific Requirement","OTB","C","TE","T","M","N","FR","PR","TI","LI","O","NA","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Railway Network Capacity Planning"]
[1,"Railway Network Capacity  Planning","Does the solution use long term future demand as input?","N"]
[2,"Railway Network Capacity  Planning","Does the solution use rail infrastructure configuration baseline as an input?","N"]
[3,"Railway Network Capacity  Planning","Does the solution use the rail infrastructure conditions as an input?","N"]
[4,"Railway Network Capacity  Planning","Does the solution use current projects in execution as an input?","N"]
[5,"Railway Network Capacity  Planning","Does the solution use consolidated capacity expansion plans from Value Chain Partners and Third Party Operators as an input?","N"]
[6,"Railway Network Capacity  Planning","Does the solution use TFR strategy and corporate plan as an input?","N"]
[7,"Railway Network Capacity  Planning","Does the solution use the infrastructure strategy as an input?","N"]
[8,"Railway Network Capacity  Planning","Does the solution use the infrastructure maintenance standards as an input?","N"]
[9,"Railway Network Capacity  Planning","Does the solution use targeted availability and reliability levels  as an input?","N"]
[10,"Railway Network Capacity  Planning","Does the solution use the operational site capacity and constraints as an input?","N"]
[11,"Railway Network Capacity  Planning","Does the solution use technology implementation plans as an input?","Y","Indicate if the solution uses the tehnology implementation plans as an input."]
[12,"Railway Network Capacity  Planning","Can the solution identify the achievable demand for each scenario?","Y","Indicate if the solution can identify the achievable demand"]
[13,"Railway Network Capacity  Planning","Can the solution state which rail network capacity was unused or under utilised?","N"]
[14,"Railway Network Capacity  Planning","Can the solution determine the sequence and timing of rail network capacity expansions?","Y","Indicate if the solution can determine the sequence and timing of rail network capacity expansions"]
[15,"Railway Network Capacity  Planning","Can the solution define confidence levels for the model? ","N"]
[16,"Railway Network Capacity  Planning","Can the solution compile an optimal shutdown and occupation schedule?","Y","Indicate if the solution can compile an optimal shutdown and occupation schedule"]
[17,"Railway Network Capacity  Planning","Can the solution produce the Rail Network Capacity expansion requirements?","Y","Indicate if the solution can produce the Rail Network Capacity expansion requirements"]
[" ","Rolling Stock Capacity Planning"]
[18,"Rolling Stock Capacity Planning","Does the solution make provision to draw the information from the  Master Train Schedule Module ?","Y","Indicate if the solution can make provision to draw the information from the  Master Train Schedule Module."]
[19,"Rolling Stock Capacity Planning","Can the solution consider the required demand to determine required rolling stock capacity?","N"]
[20,"Rolling Stock Capacity Planning","Can the solution consider demand prioritisation rules during the determination of rolling stock capacity requirements?","N"]
[21,"Rolling Stock Capacity Planning","Can the solution consider the approved service specifications to determine required wagon capacity?","N"]
[22,"Rolling Stock Capacity Planning","Can the soltution consider the approved service specificatoins to determine required locomotive capacity?","N"]
[23,"Rolling Stock Capacity Planning","Can the solution consider the maintenance methodology during calculation of locomotive capacity planning?","N"]
[24,"Rolling Stock Capacity Planning","Can the solution consider the allocation rules during calculation of locomotive capacity planning?","N"]
[25,"Rolling Stock Capacity Planning","Can the solution consider the maintenance methodology during calculation of wagon capacity planning?","N"]
[26,"Rolling Stock Capacity Planning","Can the solution consider the allocation rules during calculation of wagon capacity planning?","N"]
[27,"Rolling Stock Capacity Planning","Does the solution provide the functionality to incorporate locomotive maintenance plans per asset to meet capacity requirements? ","N"]
[28,"Rolling Stock Capacity Planning","Does the solution provide the functionality to incorporate wagon maintenance plans per asset to meet capacity requirements? ","N"]
[29,"Rolling Stock Capacity Planning","Can the solution use rolling stock facility capacities as input?","N"]
[30,"Rolling Stock Capacity Planning","Can the solution use rolling stock facility availability as input?","N"]
[31,"Rolling Stock Capacity Planning","Does the solution choose the correct types of locomotives for allocation based on reliability of assets?","N"]
[32,"Rolling Stock Capacity Planning","Does the solution choose the correct types of wagons for allocation based on reliability of assets?","N"]
[33,"Rolling Stock Capacity Planning","Does the solution choose the correct types of locomotives for allocation based on availability of assets?","N"]
[34,"Rolling Stock Capacity Planning","Does the solution choose the correct types of wagons for allocation based on availability of assets?","N"]
[35,"Rolling Stock Capacity Planning","Can the solution determine the utilisation targets of locomotive types based on allocation?","N"]
[36,"Rolling Stock Capacity Planning","Can the solution determine the utilisation targets of wagon types base on allocation?","N"]
[37,"Rolling Stock Capacity Planning","Does the solution provide the necessary functionality to incorporate future procured locomotives in the scenarios?","N"]
[38,"Rolling Stock Capacity Planning","Does the solution provide the necessary functionality to incorporate future procured wagons in the scenarios?","N"]
[39,"Rolling Stock Capacity Planning","Does the solution provide the necessary functionality to incorporate  planned retired locomotives in the scenarios?","N"]
[40,"Rolling Stock Capacity Planning","Does the solution provide the necessary functionality to incorporate  planned retired wagons in the scenarios?","N"]
[41,"Rolling Stock Capacity Planning","Does the solution provide the necessary functionality to calculate required capacity vs existing capacity?","Y","Indicate if the solution can provide the necessary functionality to calculate required capacity vs existing capacity."]
[42,"Rolling Stock Capacity Planning","Can the solution optimise the use of maintenance locations based on the origin and destination of flow and to minimise the interruption of flows en route?","N"]
[43,"Rolling Stock Capacity Planning","Can the solution optimise maintenance capacity based on the origin and destination of flow and to minimise the interruption of flows en route?","N"]
[44,"Rolling Stock Capacity Planning","Can optimal locations for new maintenance depots be identified from simulated scenarios?","N"]
[45,"Rolling Stock Capacity Planning","Can the solution incorporate restrictive rail network conditions during simulation of rolling stock capacity planning e.g. overhead power supply, axle mass restrictions, speed restrictions and signalling positioning?  ","N"]
[46,"Rolling Stock Capacity Planning","Can the solution identify where excess rolling stock capacity is available and cannot be used due to restrictive rail network conditions?","N"]
[47,"Rolling Stock Capacity Planning","Does the solution identify bottleneck and constraints?","N"]
[48,"Rolling Stock Capacity Planning","Can the solution propose solutions to resolve the bottlenecks and constraints?","N"]
[49,"Rolling Stock Capacity Planning","Can the solution identify the sequence in which the bottlenecks should be resolved?","N"]
[50,"Rolling Stock Capacity Planning","Can the solution use rolling stock facility and capacity as constraints during calculation of rolling stock capacity planning?","N"]
[51,"Rolling Stock Capacity Planning","Does the solution allow for the capturing of a percentage for technical maintenance allowance per fleet as a parameter for the simulation scenario?","N"]
[52,"Rolling Stock Capacity Planning","Does the solution allow for the capturing of a percentage efficiency per fleet as a parameter for the simulation scenario?","N"]
[53,"Rolling Stock Capacity Planning","Can the solution provide a report on the performance indicators for each scenario?","N"]
[54,"Rolling Stock Capacity Planning","Does the solution allow the user to compare different simulated scenarios?","N"]
[55,"Rolling Stock Capacity Planning","Does the solution allow the user to select one scenario as a baseline?","N"]
[56,"Rolling Stock Capacity Planning","Does the solution determine the quantity of train equipment per depot required based on a scenario?","N"]
[57,"Rolling Stock Capacity Planning","Does the solution determine the quantity of auxiliary equipment required per depot based on a given scenario?","N"]
[58,"Rolling Stock Capacity Planning","Does the solution determine the facility processing capability and capacity requirements to support the given scenario?","N"]
[59,"Rolling Stock Capacity Planning","Can the solution propose optimisation of processing capabilities by identifying the most suitably located facility to support the given scenario?","N"]
[60,"Rolling Stock Capacity Planning","Can the solution propose optimisation of capacity by identifying the most suitably located facility to support the given scenario?","N"]
[61,"Rolling Stock Capacity Planning","Can optimal locations for new rolling stock facilities be identified from simulated scenarios?","N"]
[" ","Train Crew Capacity Planning"]
[62,"Train Crew Capacity Planning","Does the solution make provision to draw the information from the  Master Train Schedule Module ?","Y","Indicate if the solution can make provision to draw the information from the  Master Train Schedule Module"]
[63,"Train Crew Capacity Planning","Can the solution use validated demand as an input?","Y","Indicate if the solution can use validated demand as an input"]
[64,"Train Crew Capacity Planning","Can the solution use demand prioritisation rules as an input?","N"]
[65,"Train Crew Capacity Planning","Does the solution consider differnet working methodologies in determining capacity requirements?","Y","Indicate if the solution can consider differnet working methodologies in determining capacity requirements"]
[66,"Train Crew Capacity Planning","Does the solution allow for the input of Train Crew depot quantities and their locations?","Y","Indicate if the solution can allow for the input of Train Crew depot quantities and their locations"]
[67,"Train Crew Capacity Planning","Does the solution consider Train Crew availability rules as input to determine capacity requirements?","Y","Indicate if the solution can consider Train Crew availability rules as input to determine capacity requirements"]
[68,"Train Crew Capacity Planning","Does the solution consider Train Crew allocation rules as input to determine capacity requirements?","Y","Indicate if the solution can consider Train Crew allocation rules as input to determine capacity requirements"]
[69,"Train Crew Capacity Planning","Does the solution allow for input of Train Crew qualification (categorisation, locomotive and route) to determine Train Crew capacity requirements?","Y","Indicate if the solution can allow for input of Train Crew qualification (categorisation, locomotive and route) to determine Train Crew capacity requirements"]
[70,"Train Crew Capacity Planning","Can the solution consider Train Crew reliability factors to derive Train Crew capacity requirements?","Y","Indicate if the solution can consider Train Crew reliability factors to derive Train Crew capacity requirements"]
[71,"Train Crew Capacity Planning","Can the solution consider various Train Crew working methodologies to optimally determine the Train Crew Capacity requirements?  ","N"]
[72,"Train Crew Capacity Planning","Can the solution use book-off facilites as input?","N"]
[73,"Train Crew Capacity Planning","Can the solution use book-off facility locations as input?","N"]
[74,"Train Crew Capacity Planning","Can the solution use book-off capacities as input?","N"]
[75,"Train Crew Capacity Planning","Can the solution use the locomotive deployment strategy as an input to determine capacity requirements?","N"]
[76,"Train Crew Capacity Planning","Can the solution use the continuous learning requirements as an input to determine capacity requirements?","N"]
[77,"Train Crew Capacity Planning","Can the solution calculate Train Crew capacity at depots required for specific scenarios?","Y","Indicate if the solution can calculate Train Crew capacity at depots required for specific scenarios"]
[78,"Train Crew Capacity Planning","Can the solution calculate projected Train Crew shortages for the given MTS and demand?","N"]
[79,"Train Crew Capacity Planning","Can the solution calculate projected Train Crew surplusses for the given MTS and demand?","N"]
[80,"Train Crew Capacity Planning","Can the solution provide a report with recommendations for optimal book-off facilities?","N"]
[81,"Train Crew Capacity Planning","Can the solution calculate the number of completed train crew trips for the scenario?","N"]
[82,"Train Crew Capacity Planning","Can the solution provide a report on the Train Crew productivity KPIs for the scenario?","Y","Indicate if the solution can provide a report on the Train Crew productivity KPIs for the scenario"]
[83,"Train Crew Capacity Planning","Can the solution identify the training requirements for the depot matrix for the scenario?","N"]
[84,"Train Crew Capacity Planning","Can the solution identify the recruitment requirements for the manpower plan for the scenario?","Y","Indicate if the solution can  identify the recruitment requirements for the manpower plan for the scenario."]
[85,"Train Crew Capacity Planning","Can the solution provide the confirmed demand for the scenario with the available Train Crew?","N"]
[86,"Train Crew Capacity Planning","Can the solution provide the unmet demand for the scenario with the available Train Crew?","N"]

{"sheet":"Phase 3_Base Train Planning","index":9,"n_rows":82,"n_cols":22,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,5,1,10],[1,11,1,16]]}
["Base Train Planning Evaluation Criteria"]
[" ",null,null,null,null,"Functionality Assessment",null,null,null,null,null,"Industry Assessment"]
["No.","Function","Supports / Implements:","Critical Requirement","Specific Requirement","OTB","C","TE","T","M","N","FR","PR","TI","LI","O","NA","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Base Train Planning - Determine Slot Capacity",null,null,null,null,"x",null,null,null,null,"x",null,null,null,null,null,"Joe Rail LTD","XYZ simulation tool","Page 15 - proposal",null,"The solution takes the current rail network configuration as input"]
[1,"Determine Slot Capacity","Can the solution take the current rail network configuration as input?\n","Y","Indicate if the solution can take the current rail network configuration as input. "]
[2,"Determine Slot Capacity","Can the solution take future rail network configuration per period as input?","N"]
[3,"Determine Slot Capacity","Can the solution take train configurations as input?\n","Y","Indicate if the solution can take train configurations as input"]
[4,"Determine Slot Capacity","Can the solution combine the current and future rail network configurations to build a baseline rail network configuration model?","N"]
[5,"Determine Slot Capacity","Does the solution have the capability to create macroscopic models from the rail network configuration?","N"]
[6,"Determine Slot Capacity","Does the solution have the capability to create microscopic models from the rail network configuration?","Y","Indicate if the solution have the capability to create microscopic models from the rail network configuration."]
[7,"Determine Slot Capacity","Can the solution determine theoretical  slot capacity based on given network configuration and train configuration scenarios?","N"]
[8,"Determine Slot Capacity","Does the solution allow a user to change percentages per section before determining the operational slot capacity?","N"]
[9,"Determine Slot Capacity","Does the solution consider detailed perway, traction power supply and signal configurations when determining slot capacity?","Y","Indicate if the solution can consider detailed perway, traction power supply and signal configurations when determining slot capacity"]
[10,"Determine Slot Capacity","Does the solution allow recovery slot allocation percentages to be changed as input parameters per sub-section?","N"]
[11,"Determine Slot Capacity","Does the solution make provision to define train block buffer time parameters per section?","N"]
[12,"Determine Slot Capacity","Does the solution make provision to define train run-time recovery parameters per section?","N"]
[13,"Determine Slot Capacity","Does the solution make provision to define recovery slot allocation rules?","N"]
[14,"Determine Slot Capacity","Can the solution determine operational slot capacity as a percentage of theoretical slot capacity using the defined percentages per section?","Y","Indicate if the solution can determine operational slot capacity as a percentage of theoretical slot capacity using the defined percentages per section"]
[15,"Determine Slot Capacity","Can the solution calculate and set aside a pre-determined portion of operational slot capacity for recovery slots (not to be used for demand-to-slots) using the predefined percentages and allocation rules? ","N"]
[" ","Base Train Planning - Master Train Schedule (MTS)"]
[16,"Master Train Schedule (MTS)","Can the solution take the base rail network configuration as input?\n","N"]
[17,"Master Train Schedule (MTS)","Can the solution take the operational slot capacity as input?\n","N"]
[18,"Master Train Schedule (MTS)","Can the solution solution receive handling capacity and handling tempos from operational sites as input? ","N"]
[19,"Master Train Schedule (MTS)","Does the solution take operational site and mainline handling capacities into account when compiling an MTS?","N"]
[20,"Master Train Schedule (MTS)","Does the solution optimise schedules across the network and network sections?","Y","Indicate if the solution can optimise schedules across the network and network sections"]
[21,"Master Train Schedule (MTS)","Can the solution create a conflict free MTS that eliminate bottlenecks?","N"]
[22,"Master Train Schedule (MTS)","Can the solution eliminate congestion of operational sites and mainlines?","N"]
[23,"Master Train Schedule (MTS)","Can the solution reduce the time for planned en route dwell time?","N"]
[24,"Master Train Schedule (MTS)","Does the solution consider operating site owner constraints and capacity (eg siding layout, siding capacity, handling tempo, operating hours) when generating the optimised schedule?","N"]
[25,"Master Train Schedule (MTS)","Does the solution identify KPI's for the MTS?","N"]
[26,"Master Train Schedule (MTS)","Does the solution produce a report of KPI measurements for the MTS?","N"]
[" ","Base Train Planning -Blocking Plan"]
[27,"Blocking Plan","Can the solution take the MTS as input?\n","N"]
[28,"Blocking Plan","Does the solution have the capability for a user to capture and enhance the blocking rule parameters?","Y","Indicate if the solution have the capability for a user to capture and enhance the blocking rule parameters"]
[29,"Blocking Plan","Does the solution have the capability to accept blocking rule parameters from other data sources?","N"]
[30,"Blocking Plan","Can the solution take approved service specifications as input?\n","N"]
[31,"Blocking Plan","Does the solution take rail safety rules into account when determining blocks?","N"]
[32,"Blocking Plan","Does the solution take wagon compatibility rules into account when determining blocks?","N"]
[33,"Blocking Plan","Does the solution have the ability to differentiate between different train types (e.g. brake system and train lengths) when determining blocks? ","N"]
[34,"Blocking Plan","Does the solution consider demand prioritisation rules in determining the blocking plan?","N"]
[35,"Blocking Plan","Does the solution consider train configurations defined in the MTS to determe block sizes?","N"]
[36,"Blocking Plan","Can the solution re-group traffic for block swapping at interim locations?","N"]
[37,"Blocking Plan","Does the solution minimise block swapping during the creation of blocks?   ","Y","Indicate if the solution can minimise block swapping during the creation of blocks"]
[38,"Blocking Plan","Does the solution maximise train utilisation during the creation of blocks? ","Y","Indicate if the solution can maximise train utilisation during the creation of blocks"]
[39,"Blocking Plan","Can the the solution provide a cost report associated with the blocking plan?","N"]
[40,"Blocking Plan","Does the solution optimise the sequence of wagon blocks on each train for safety and optimal block swapping?","N"]
[41,"Blocking Plan","Is the solution able to provide different possible blocking scenarios?","N"]
[42,"Blocking Plan","Does the solution identify the performance KPIs and ranking of the different blocking scenarios?","N"]
[43,"Blocking Plan","Does the solution allow the end user to impose selected scenarios?","N"]
[" ","Base Train Planning -Resource Based Train Plan (RBTP)"]
[44,"Resource Based Train Plan (RBTP)","Can the solution use the MTS and Blocking Plan as inputs to create a baseline for the process?","Y","Indicate if the solution uses the MTS and Blocking Plan as inputs to create a baseline for the process"]
[45,"Resource Based Train Plan (RBTP)","Can the solution allocate wagons by type and quantity to the baseline schedule? ","N"]
[46,"Resource Based Train Plan (RBTP)","Does the solution consider the wagon facility capacities and processing capability during the allocation of wagons?","N"]
[47,"Resource Based Train Plan (RBTP)","Can the solution allocate locomotives by type and quantity to the baseline schedule? ","N"]
[48,"Resource Based Train Plan (RBTP)","Does the solution consider the lcomotive facility capacities and processing capability during the allocation of locomotives?","N"]
[49,"Resource Based Train Plan (RBTP)","Can the solution allocate train crew by category and quantity to the baseline schedule? ","N"]
[50,"Resource Based Train Plan (RBTP)","Can the solution allocate demand to the trains?","N"]
[51,"Resource Based Train Plan (RBTP)","Does the solution consider demand prioritisation rules and profitability calculations during simulation of the scenarios?","N"]
[52,"Resource Based Train Plan (RBTP)","Does the solution allow the user to create different simulation scenarios by altering the parameters for the scenarios?","N"]
[53,"Resource Based Train Plan (RBTP)","Can the solution produce a traffic mix report for each scenario?","N"]
[54,"Resource Based Train Plan (RBTP)","Can the solution distinguish between confirmed and unmet demand for the scenario?","N"]
[55,"Resource Based Train Plan (RBTP)","Can the solution identify spare capacity for each scenario?","N"]
[56,"Resource Based Train Plan (RBTP)","Can the solution calculate performance indicators for each scenario?","N"]
[57,"Resource Based Train Plan (RBTP)","Does the solution allow the user to compare different simulated scenarios?","N"]
[58,"Resource Based Train Plan (RBTP)","Does the solution allow the user to select one scenario as a baseline?","N"]
[59,"Resource Based Train Plan (RBTP)","Can the solution derive service specifications at an activity level?","N"]
[60,"Resource Based Train Plan (RBTP)","Can the solution obtain costs per activity for the service specification?","N"]
[61,"Resource Based Train Plan (RBTP)","Can the solution provide a report for confirmed demand?","Y","Indicate if the solution can provide a report for confirmed demand."]
[62,"Resource Based Train Plan (RBTP)","Can the solution provide a report for unmet demand with reasons?","Y","Indicate if the solution can provide a report for unmet demand with reasons."]
[63,"Resource Based Train Plan (RBTP)","Can the solution define the metrics and planned targets to track the KPI performance?","N"]
[64,"Resource Based Train Plan (RBTP)","Does the solution compile a resourced base train plan that makes provision for the balancing of wagons?","Y","Indicate if the solution can compile a resourced base train plan that makes provision for the balancing of wagons"]
[65,"Resource Based Train Plan (RBTP)","Does the solution compile a resourced base train plan that makes provision for the balancing of Locomotives?","Y","Indicate if the solution can compile a resourced base train plan that makes provision for the balancing of Locomotives"]
[66,"Resource Based Train Plan (RBTP)","Does the solution compile a resourced base train plan that makes provision for the balancing of train crew?","N"]
[67,"Resource Based Train Plan (RBTP)","Does the solution compile a resourced base train plan that includes the balancing of auxialliary equipment?","N"]
[68,"Resource Based Train Plan (RBTP)","Does the solution compile a resourced base train plan that makes provision for the balancing of train equipment?","N"]
[69,"Resource Based Train Plan (RBTP)","Does the solution consider the capacity constraints for the rail network infrastructure during the creation of the RBTP?","Y","Indicate if the solution can consider the capacity constraints for the rail network infrastructure during the creation of the RBTP"]
[70,"Resource Based Train Plan (RBTP)","Does the solution consider the capacity constraints for the locomotives during the creation of the RBTP?","Y","Indicate if the solution  considers the capacity constraints for the locomotives during the creation of the RBTP"]
[71,"Resource Based Train Plan (RBTP)","Does the solution consider the capacity constraints for the wagons during the creation of the RBTP?","Y","Indicate if the solution can"]
[72,"Resource Based Train Plan (RBTP)","Does the solution consider the capacity constraints for the Train Crew during the creation of the RBTP?","Y","Indicate if the solution considers the capacity constraints for the Train Crew during the creation of the RBTP"]
[73,"Resource Based Train Plan (RBTP)","Can the solution graphically display the RBTP?","N"]
[74,"Resource Based Train Plan (RBTP)","Can the solution provide a report with the required auxiliary equipment by type and depot to support the RBTP?","N"]
[75,"Resource Based Train Plan (RBTP)","Can the solution provide a report with the required telemeter equipment by type and depot to support the RBTP?","N"]

{"sheet":"Phase3_Production Planning","index":10,"n_rows":139,"n_cols":22,"rows_kept":139,"cut":false,"hidden":false,"merged":[[1,5,1,10],[1,11,1,16]]}
["Production Planning Evaluation Criteria"]
[" ",null,null,null,null,"Functionality Assessment",null,null,null,null,null,"Industry Assessment"]
["#","Function","Supports / Implements","Critical Requirements","Specific Requirement","OTB","C","TE","T","M","N","FR","PR","TI","LI","O","NA","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Compile Production Plan "]
[1,"Compile Production Plan ","Can the solution take validated customer orders as input to compile a production plan?","Y","Indicate if the solution can take validated customer orders as input to compile a production plan "]
[2,"Compile Production Plan ","Can the solution take backlog orders as input to compile a production plan?","N"]
[3,"Compile Production Plan ","Can the solution re-plan staged trains from the previous production period in the current production period?","N"]
[4,"Compile Production Plan ","Can the solution use the Resourced Base Train Plan as source when compiling a production plan?","Y","Indicate if the solution can tuse the Resourced Base Train Plan as source when compiling a production plan"]
[5,"Compile Production Plan ","Does the solution take all replanning requirements resulting from deviation impact assessment into account?","Y","Indicate if the solution can take all replanning requirements resulting from deviation impact assessment into account"]
[6,"Compile Production Plan ","Does the solution take Rail Network Occupations into account?","Y","Indicate if the solution can take Rail Network Occupations into account"]
[7,"Compile Production Plan ","Does the solution match validated and backlog orders to available capacity?","N"]
[8,"Compile Production Plan ","Can the solution use demand prioritisation rules to resolve conflicts in matching orders to available capacity on the RBTP?","N"]
[9,"Compile Production Plan ","Can the solution interface with a Capacity Planning Solution to obtain blocking rules to ensure adherence to the rules during re-planning?","N"]
[10,"Compile Production Plan ","Does the solution consider operational site capabilities during the creation of the production plan? ","N"]
[11,"Compile Production Plan ","Does the solution consider operational site capacities during the creation of the production plan?  ","N"]
[12,"Compile Production Plan ","Does the solution consider operational site availability and activity durations during the creation of the production plan?   ","N"]
[13,"Compile Production Plan ","Can the solution allocate wagons to the un-resourced production plan based on the results from the wagon distribution plan? ","N"]
[14,"Compile Production Plan ","Can the solution allocate locomotives to the un-resourced production plan based on the results from the locomotive distribution plan? ","N"]
[15,"Compile Production Plan ","Can the solution allocate train crew to the un-resourced production plan based on the results from the train crew allocation plan? ","N"]
[16,"Compile Production Plan ","Does the solution consolidate and integrate  resource distribution plans and capacity into the production plan?","Y","Indicate if the solution can consolidate and integrate  resource distribution plans and capacity into the production plan"]
[17,"Compile Production Plan ","Can the solution simulate the integrated resourced production plan?","N"]
[18,"Compile Production Plan ","Can the solution identify train imbalances and propose solutions to resolve these when producing a production plan?","N"]
[19,"Compile Production Plan ","Does the solution allow the user to select a suitable train imbalance correction option for application in the creation of the production plan?","N"]
[20,"Compile Production Plan ","Can the solution identify bottlenecks and propose solutions to resolve these when producing a production plan?","N"]
[21,"Compile Production Plan ","Does the solution allow the user to select a suitable bottleneck resolution option for application in the creation of the production plan?","N"]
[22,"Compile Production Plan ","Can the solution provide demand smoothing options to maximise the utilization of resources for the production period? ","N"]
[23,"Compile Production Plan ","Does the solution allow the user to select a suitable demand smoothing option for application in the creation of the production plan?","N"]
[24,"Compile Production Plan ","Does the solution allow the user to capture KPI definitions for the production plan?","N"]
[25,"Compile Production Plan ","Can the solution provide a report on the result of defined KPIs for the production plan simulated scenario?","N"]
[26,"Compile Production Plan ","Can the solution produce a report indicating possible resource imbalances for the simulated production plan scenario?","N"]
[27,"Compile Production Plan ","Does the solution allow the user to accept or decline a simulated scenario before publishing the production plan?","C"]
[28,"Compile Production Plan ","Does the solution store all simulated scenario versions?","N"]
[29,"Compile Production Plan ","Does the solution plan post-arrival activities to ensure the timely processing of arriving trains in the yard?","Y","Indicate if the solution can plan post-arrival activities to ensure the timely processing of arriving trains in the yard"]
[30,"Compile Production Plan ","Does the solution plan  Pre-departure activities to ensure the timely departure of trains from yards?","Y","Indicate if the solution can plan  Pre-departure activities to ensure the timely departure of trains from yards"]
[31,"Compile Production Plan ","Can the solution provide detailed planned activities to the ROAM program for the generation and publishing of works orders? ","N"]
[32,"Compile Production Plan ","Does the solution consider rail safety regulations when planning local pickup and delivery activities?","N"]
[33,"Compile Production Plan ","Does the solution enable other systems to access the approved production plan? ","N"]
[34,"Compile Production Plan ","Does the solution enable other systems/users to view the approved production plan in different dimensions e.g. per depot, corridor and customer time appointments? ","N"]
[35,"Compile Production Plan ","Does the solution enable other systems to access the approved wagon distribution plan? ","N"]
[36,"Compile Production Plan ","Does the solution enable other systems/users to view the approved wagon distribution plan in different dimensions e.g. per depot, corridor and customer time appointments? ","N"]
[37,"Compile Production Plan ","Does the solution enable other systems to access the approved locomotive distribution plan? ","N"]
[38,"Compile Production Plan ","Does the solution enable other systems/users to view the approved locomotive distribution plan in different dimensions e.g. per depot, corridor and customer time appointments? ","N"]
[39,"Compile Production Plan ","Does the solution enable other systems to access the approved train crew allocation plan? ","N"]
[40,"Compile Production Plan ","Does the solution enable other systems/users to view the approved train crew allocaiton plan in different dimensions e.g. per depot, corridor and customer time appointments? ","N"]
[41,"Compile Production Plan ","Can the solution determine Train crew transportation requirements to support Train crew plans?","N"]
[42,"Compile Production Plan ","Can the solution provide a report on approved occupations? ","N"]
[43,"Compile Production Plan ","Can the solution provide a report on declined occupations? ","N"]
[44,"Compile Production Plan ","Does the solution allow the user to manually decline occupations?","N"]
[45,"Compile Production Plan ","Does the solution allow the user to manuall capture reasons for the decline of occupations?","N"]
[46,"Compile Production Plan ","Can the solution provide a report on confirmed customer orders and other demand? ","Y","Indicate if the solution can provide a report on confirmed customer orders and other demand"]
[47,"Compile Production Plan ","Can the solution provide a report on unmet customer orders and other demand with reasons?","Y","Indicate if the solution can provide a report on unmet customer orders and other demand with reasons"]
[48,"Compile Production Plan ","Can the solution identify the reasons for unmet demand automatically?","N"]
[49,"Compile Production Plan ","Does the solution allow for the selection of root cause analyses reasons for the unmet orders?","N"]
[50,"Compile Production Plan ","Does the solution allow for manual capturing of reasons for unmet orders?","N"]
[51,"Compile Production Plan ","Does the solution allow for the reasons to be verified by another user?","N"]
[52,"Compile Production Plan ","Can the solution identify spare capacity?","N"]
[53,"Compile Production Plan ","Can the solution produce a meet-and-pass plan for the execution of the production plan?","N"]
[54,"Compile Production Plan ","Can the solution create a graphical view of the Production Plan train diagram? ","Y","Indicate if the solution can create a graphical view of the Production Plan train diagram"]
[55,"Compile Production Plan ","Can the solution create a tabulated view of the Production Plan?","Y","Indicate if the solution can create a tabulated view of the Production Plan"]
[" ","Compile Wagon Distribution Plan"]
[56,"Compile Wagon Distribution Plan ","Can the solution accept Validated Customer Orders, to identify required wagons per type and quantity to satify the validated orders?  ","Y","Indicate if the solution can accept Validated Customer Orders, to identify required wagons per type and quantity to satify the validated orders"]
[57,"Compile Wagon Distribution Plan ","Can the solution accept the published production plan as input?","N"]
[58,"Compile Wagon Distribution Plan ","Can the solution accept the unresourced production plan as input?","N"]
[59,"Compile Wagon Distribution Plan ","Can the solution accept Wagon Availability, Position and Status as input?","Y","Indicate if the solution can accept Wagon Availability, Position and Status as input"]
[60,"Compile Wagon Distribution Plan ","Can the solution accept production plan re-planning requirements as input?","N"]
[61,"Compile Wagon Distribution Plan ","Can the solution accept wagon allocation rules as input?","N"]
[62,"Compile Wagon Distribution Plan ","Does the solution consider wagon allocation rules during compilation of the wagon distribution plan?","N"]
[63,"Compile Wagon Distribution Plan ","Can the solution accept wagon distribution re-planning requirements as input?","N"]
[64,"Compile Wagon Distribution Plan ","Does the solution consider Wagon Maintenance Schedules to determine wagon distribution plans?","N"]
[65,"Compile Wagon Distribution Plan ","Can the solution accept wagon preparation rules as input?","N"]
[66,"Compile Wagon Distribution Plan ","Does the solution consider the impact of Wagon preparation rules when compiling an optimal wagon distribution plan?","N"]
[67,"Compile Wagon Distribution Plan ","Does the solution plan scheduled movements of wagons from and to maintenance facilities?","N"]
[68,"Compile Wagon Distribution Plan ","Does the solution plan scheduled movements of wagons from and to wagon preparation facilities?","N"]
[69,"Compile Wagon Distribution Plan ","Can the solution suggest optimised positions of holding areas to minimise empty wagon kilometers based on a predefined set of locations?","Y","Indicate if the solution can suggest optimised positions of holding areas to minimise empty wagon kilometers based on a predefined set of locations"]
[70,"Compile Wagon Distribution Plan ","Can the solution determine optimal empty wagon flows between hubs to satisfy validated orders?\n","Y","Indicate if the solution can determine optimal empty wagon flows between hubs to satisfy validated orders"]
[71,"Compile Wagon Distribution Plan ","Can the solution define the required macro wagon flows for distribution to satisfy the validated orders considering demand prioritisation rules,  wagon preparation rules and maintenance requirements?","N"]
[72,"Compile Wagon Distribution Plan ","Can the solution define the required micro flows within yard complexes to and from sidings to satisfy all validated orders in time and in full?","Y","Indicate if the solution can define the required micro flows within yard complexes to and from sidings to satisfy all validated orders in time and in full"]
[73,"Compile Wagon Distribution Plan ","Can the solution define the required micro flows within yard complexes to satisfy all movements to and from wagon facilities?","N"]
[74,"Compile Wagon Distribution Plan ","Can the solution define the required micro flows within yard complexes to satisfy all movements to and from maintenance facilities?","N"]
[75,"Compile Wagon Distribution Plan ","Does the solution consider actual current wagon turnaround times and their location when compiling the wagon distribution plan?","N"]
[76,"Compile Wagon Distribution Plan ","Does the solution assess wagon queues (at origin, en route and at destination) when optimising wagon distribution?","N"]
[77,"Compile Wagon Distribution Plan ","Can the solution provide wagon shortages and surpluses after performing wagon distribution optimisation?","N"," "]
[78,"Compile Wagon Distribution Plan ","Can the solution propose the use of surplus wagons to address the wagon shortages? ","N"]
[79,"Compile Wagon Distribution Plan ","Does the solution provide a user with the capability to accept or reject the proposed shortage solutions?","N"]
[80,"Compile Wagon Distribution Plan ","Does the solution allow the user to capture KPI definitions for the wagon distribution?","N"]
[81,"Compile Wagon Distribution Plan ","Can the solution provide a report on the result of defined KPIs for the wagon distribution plan?","N"]
[82,"Compile Wagon Distribution Plan ","Can the solution identify auxiliary equipment for wagon types to satisfy validated orders considering the auxiliary equipment allocation rules?","N"]
[83,"Compile Wagon Distribution Plan ","Can the solution provide a report for non-trackable auxiliary equipment surplus and shortages?","N"]
[84,"Compile Wagon Distribution Plan ","Can the solution create a distribution plan for trackable auxiliary equipment to satisfy the validated orders?","N"]
[85,"Compile Wagon Distribution Plan ","Can the solution provide a report for trackable auxiliary equipment surplus and shortages?","N"]
[86,"Compile Wagon Distribution Plan ","Can the solution propose surplus trackable auxiliary equipment to address the shortages?","N"]
[87,"Compile Wagon Distribution Plan ","Does the solution provide a user with the capability to accept or reject the proposed trackable auxiliary equipment shortage solutions?","N"]
[" ","Compile Locomotive Distribution Plan"]
[88,"Compile Locomotive Distribution Plan","Can the solution accept Validated Customer Orders and priorisation rules as input?  ","N"]
[89,"Compile Locomotive Distribution Plan","Can the solution apply Customer Order prioritisation rules during the allocation of locomotive to trains?","Y","Indicate if the solution can apply Customer Order prioritisation rules during the allocation of locomotive to trains"]
[90,"Compile Locomotive Distribution Plan","Can the solution accept the published production plan as input?","N"]
[91,"Compile Locomotive Distribution Plan","Can the solution accept the unresourced production plan as input?","N"]
[92,"Compile Locomotive Distribution Plan","Can the solution accept locomotive availability, position and status as input?","N"]
[93,"Compile Locomotive Distribution Plan","Can the solution accept production plan re-planning requirements as input?","N"]
[94,"Compile Locomotive Distribution Plan","Can the solution accept locomotive allocation rules as input?","N"]
[95,"Compile Locomotive Distribution Plan","Does the solution use the Locomotive Maintenance Schedules as input?","N"]
[96,"Compile Locomotive Distribution Plan","Does the solution optimise locomotive movements to and from maintenance depots ? ","Y","Indicate if the solution can optimise locomotive movements to and from maintenance depots "]
[97,"Compile Locomotive Distribution Plan","Can the solution use current locomotive cycle times as input?","N"]
[98,"Compile Locomotive Distribution Plan","Can the solution determine locomotive quantity requirements for the Production Plan, based on locomotive allocation rules ?","Y","Indicate if the solution can determine locomotive quantity requirements for the Production Plan, based on locomotive allocation rules"]
[99,"Compile Locomotive Distribution Plan","Can the solution use locomotive availability, position and status to identify locomotives for trains?","Y","Indicate if the solution can use locomotive availability, position and status to identify locomotives for trains"]
[100,"Compile Locomotive Distribution Plan","When compiling an optimised locomotive distribution plan, does the solution optimise efficiency and effectiveness of locomotive movements?  ","Y","Indicate if the solution can optimise efficiency and effectiveness of locomotive movements"]
[101,"Compile Locomotive Distribution Plan","Does the solution consider actual current locomotive cycle times and their location when compiling the locomotive distribution plan?","N"]
[102,"Compile Locomotive Distribution Plan","Can the solution consider maximum utilisation of locomotives when compiling the locomotive distribution plan?","Y","Indicate if the solution can consider maximum utilisation of locomotives when compiling the locomotive distribution plan"]
[103,"Compile Locomotive Distribution Plan","Does the solution allow the user to capture KPI definitions for locomotive distribution?","N"]
[104,"Compile Locomotive Distribution Plan","Can the solution provide a report on the result of defined KPIs for the locomotive distribution plan?","N"]
[105,"Compile Locomotive Distribution Plan","Does the solution proactively highlight locomotive shortages and surpluses when allocating locomotives to trains?  ","Y","Indicate if the solution can proactively highlight locomotive shortages and surpluses when allocating locomotives to trains"]
[106,"Compile Locomotive Distribution Plan","Can the solution propose re-distribution of surplus locomotives to areas of under supply based on locomotive allocation rules?  ","N"]
[107,"Compile Locomotive Distribution Plan","Does the solution provide a user with the capability to accept or reject the proposed shortage solutions?","N"]
[108,"Compile Locomotive Distribution Plan","Can the solution accept train equipment availability, position and status as input?","N"]
[109,"Compile Locomotive Distribution Plan","Can the solution determine Train Equipment quantities for the Production Plan?","Y","Indicate if the solution can determine Train Equipment quantities for the Production Plan"]
[110,"Compile Locomotive Distribution Plan","When compiling an optimised Train Equipment distribution plan, does the solution consider location and charge status? ","Y","Indicate if the solution considers location and charge status when compiling an optimised Train Equipment distribution plan"]
[111,"Compile Locomotive Distribution Plan","Does the solution proactively highlight train equipment shortages and surpluses during the compilation of the TE distribution plan?  ","Y","Indicate if the solution can proactively highlight train equipment shortages and surpluses during the compilation of the TE distribution plan"]
[112,"Compile Locomotive Distribution Plan","Can the solution propose re-distribution of surplus train equipment to areas of under supply based on train equipment allocation rules?  ","N"]
[113,"Compile Locomotive Distribution Plan","Does the solution provide a user with the capability to accept or reject the proposed shortage solutions?","N"]
[114,"Compile Locomotive Distribution Plan","Can the solution integrate the locomotive distribution plan into the production plan?","Y","Indicate if the solution can  integrate the locomotive distribution plan into the production plan"]
[115,"Compile Locomotive Distribution Plan","Can the solution integrate the train equipment distribution plan into the production plan?","Y","Indicate if the solution can integrate the train equipment distribution plan into the production plan"]
[" ","Compile Train Crew Allocation Plan"]
[116,"Compile Train Crew Allocation Plan","Can the solution accept the unresourced Production Plans as input?","Y","Indicate if the solution can accept the unresourced Production Plans as input"]
[117,"Compile Train Crew Allocation Plan","Can the solution accept the locomotive distribution plan as input?","Y","Indicate if the solution can accept the locomotive distribution plan as input"]
[118,"Compile Train Crew Allocation Plan","Can the solution allocate train crew to the unresourced production plan while considering allocated locomotive types?","Y","Indicate if the solution can allocate train crew to the unresourced production plan while considering allocated locomotive types"]
[119,"Compile Train Crew Allocation Plan","Can the solution allocation train crew to the unresourced production plan while considering the route knowledge of the trains? ","Y","Indicate if the solution can allocate train crew to the unresourced production plan while considering the route knowledge of the trains"]
[120,"Compile Train Crew Allocation Plan","Does the solution consider train crew availability during allocation?","N"]
[121,"Compile Train Crew Allocation Plan","Does the solution consider train crew position during allocation?","N"]
[122,"Compile Train Crew Allocation Plan","Does the solution consider train crew categories during allocation?","N"]
[123,"Compile Train Crew Allocation Plan","Does the solution consider train crew qualifications during allocation?","N"]
[124,"Compile Train Crew Allocation Plan","Does the solution consider train crew shift patterns during allocation?","N"]
[125,"Compile Train Crew Allocation Plan","Does the solution consider train crew rest periods during allocation?","N"]
[126,"Compile Train Crew Allocation Plan","Does the solution consider permissable train crew overtime hours during allocation?","N"]
[127,"Compile Train Crew Allocation Plan","Can the Solution accept re-planning requirements from MDM and re-plan the Train crew allocation based on the deviations?","N"]
[128,"Compile Train Crew Allocation Plan","Can the system revise the Train crew allocation plan by accepting replanning requirements from MDM?","N"]
[129,"Compile Train Crew Allocation Plan","Can the system identify areas of shortages of Train crew? ","Y","Indicate if the solution can identify areas of shortages of Train crew"]
[130,"Compile Train Crew Allocation Plan","Can the system identify areas of surplus of Train crew?","Y","Indicate if the solution can identify areas of surplus of Train crew"]
[131,"Compile Train Crew Allocation Plan","Does the solution allow for manual re-allocation of Train Crew to fulfill the requirements of the unresourced production plan?","Y","Indicate if the solution can allow for manual re-allocation of Train Crew to fulfill the requirements of the unresourced production plan"]
[132,"Compile Train Crew Allocation Plan","Can the solution integrate the Train Crew allocation plan into the Production Plan process?","Y","Indicate if the solution can integrate the Train Crew allocation plan into the Production Plan process"]

{"sheet":"Phase3_EMDM Functional Criteria","index":11,"n_rows":134,"n_cols":22,"rows_kept":134,"cut":false,"hidden":false,"merged":[[1,5,1,10],[1,11,1,16]]}
["Execution Monitoring and Deviation Management Evaluation Criteria"]
[null,null,null,null,null,"Functionality Assessment",null,null,null,null,null,"Industry Assessment"]
["#","Function","Supports / Implements","Critical Requirements","Specific Requirement","OTB","C","TE","T","M","N","FR","PR","TI","LI","O","NA","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Monitor Adherence to Plan - Train Crew Allocation Plan Monitoring"]
[1,"Train Crew Allocation Plan Monitoring","Can the solution take the Train Crew Allocation Plan as input?","N"]
[2,"Train Crew Allocation Plan Monitoring","Can the solution take the Production Plan as input?","N"]
[3,"Train Crew Allocation Plan Monitoring","Can the solution take the status countdown activities as input?","N"]
[4,"Train Crew Allocation Plan Monitoring","Can the solution take the current positions of trains and assets as input?","N"]
[5,"Train Crew Allocation Plan Monitoring","Can the solution take the current position of Train Crew as input?","N"]
[6,"Train Crew Allocation Plan Monitoring","Can the solution take the availability of Train Crew as input?","N"]
[7,"Train Crew Allocation Plan Monitoring","Can the solution take the Train Crew allocation rules as input?","N"]
[8,"Train Crew Allocation Plan Monitoring","Can the solution take Train Crew Transportation Requirements as input?","N"]
[9,"Train Crew Allocation Plan Monitoring","Can the solution take Train Crew re-planning requirements as input?","N"]
[10,"Train Crew Allocation Plan Monitoring","Can the solution identify if Train Crew did not report for duty as per the countdown activites?","N"]
[11,"Train Crew Allocation Plan Monitoring","Can the solution determine the impact of the non-availability of the Train Crew?","N"]
[12,"Train Crew Allocation Plan Monitoring","Can the solution send the new allocations to the Train Crew Management solution for issuing of amended works orders?","N"]
[13,"Train Crew Allocation Plan Monitoring","Can the solution identify impacts on Train Crew for delays of train movements?","N"]
[14,"Train Crew Allocation Plan Monitoring","Can the solution determine the remaining journey time for the train?","N"]
[15,"Train Crew Allocation Plan Monitoring","Can the solution determine the remaining time left for the Train Crew shift?","N"]
[16,"Train Crew Allocation Plan Monitoring","Can the solution determine if the Train Crew have sufficient time left in the shift to complete the train journey?","N"]
[17,"Train Crew Allocation Plan Monitoring","Can the solution identify the standby Train Crew that are on duty? ","N"]
[18,"Train Crew Allocation Plan Monitoring","Does the solution allow the user to manually allocate the standby Train Crew to the train?","N"]
[19,"Train Crew Allocation Plan Monitoring","Can the solution create deviation reports  for the Train Crew Allocation Plan?","N"]
[20,"Train Crew Allocation Plan Monitoring","Does the solution provide reasons for deviations from the Train Crew Allocation Plan based on the activity that is not completed?","N"]
[21,"Train Crew Allocation Plan Monitoring","Can the solution assist the user to determine the root cause of the deviation by listing historical occurences/ executed activites related to the deviated activity?","N"]
[22,"Train Crew Allocation Plan Monitoring","Does the solution allow the user to manually apture the root cause for the Train Crew delay?","N"]
[23,"Train Crew Allocation Plan Monitoring","Can the solution share the devation report including reasons and root cause analysis to the TCO and Traffic Regulator monitoring solutions for impact analysis?","N"]
[24,"Train Crew Allocation Plan Monitoring","Can the solution recalculate the Train Crew Productivity KPI reports incorporating the deviations?","N"]
[25,"Train Crew Allocation Plan Monitoring","Does the solution allow for the comparison of the recalcuated KPIs against KPIs calculated during planning?","N"]
[" ","Monitor Adherence to Plan - Locomotive Distribution Plan Monitoring"]
[26,"Locomotive Distribution Plan Monitoring","Can the solution take the Locomotive Distribution Plan as input?","N"]
[27,"Locomotive Distribution Plan Monitoring","Can the solution take the Production Plan as input?","N"]
[28,"Locomotive Distribution Plan Monitoring","Can the solution take the status countdown activities as input?","N"]
[29,"Locomotive Distribution Plan Monitoring","Can the solution take the current positions of trains and assets as input?","N"]
[30,"Locomotive Distribution Plan Monitoring","Can the solution take the current position of Locomotives as input?","N"]
[31,"Locomotive Distribution Plan Monitoring","Can the solution take the availability of Locomotives as input?","N"]
[32,"Locomotive Distribution Plan Monitoring","Can the solution take the Locomotive allocation rules as input?","N"]
[33,"Locomotive Distribution Plan Monitoring","Can the solution take locomotive movements to and from maintenance depots as input?","N"]
[34,"Locomotive Distribution Plan Monitoring","Can the solution take Locomotive re-planning requirements as input?","N"]
[35,"Locomotive Distribution Plan Monitoring","Can the solution identify if locomotives are not available for execution as per the countdown activites?","N"]
[36,"Locomotive Distribution Plan Monitoring","Can the solution determine the impact of the non-availability of locomotives?","N"]
[37,"Locomotive Distribution Plan Monitoring","Can the solution identify surplus locomotives in the same depot for allocation?","N"]
[38,"Locomotive Distribution Plan Monitoring","Can the solution allow for manual capturing of locomotive swopping rules and parameters?","N"]
[39,"Locomotive Distribution Plan Monitoring","Can the solution use the swopping rules and parameters to identifiy possible locomotives for swopping?","N"]
[40,"Locomotive Distribution Plan Monitoring","Does the solution allow the user to manually allocate the locomotives to trains to manage the deviations?","N"]
[41,"Locomotive Distribution Plan Monitoring","Can the solution send the new allocations to the Asset Management solution for issuing of amended works orders?","N"]
[42,"Locomotive Distribution Plan Monitoring","Can the solution create deviation reports  for the Locomotive Distribution Plan?","N"]
[43,"Locomotive Distribution Plan Monitoring","Can the solution provide reasons for deviations from the Locomotive Distribution Plan based on the activity that is not completed?","N"]
[44,"Locomotive Distribution Plan Monitoring","Can the solution assist the user to determine the root cause of the deviation by listing historical occurences/ executed activites related to the deviated activity?","N"]
[45,"Locomotive Distribution Plan Monitoring","Does the solution allow the user to manually capture the root cause for the locomotive delay?","N"]
[46,"Locomotive Distribution Plan Monitoring","Can the solution share the deviation report including reasons and root cause analysis to the TCO and Traffic Regulator monitoring solutions for impact analysis?","N"]
[47,"Locomotive Distribution Plan Monitoring","Can the solution recalculate the locomotive productivity KPI reports incorporating the deviations?","N"]
[48,"Locomotive Distribution Plan Monitoring","Does the solution allow for the comparison of the recalcuated KPIs against KPIs calculated during planning?","N"]
[" ","Monitor Adherence to Plan -Wagon and Auxiliary Equipment Distribution Plan Monitoring"]
[49,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the Wagon Distribution Plan as input?","N"]
[50,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the Production Plan as input?","N"]
[51,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the countdown activities status as input?","N"]
[52,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the current positions of trains and assets as input?","N"]
[53,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the current position of wagons as input?","N"]
[54,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the availability of wagons as input?","N"]
[55,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the wagon allocation rules as input?","N"]
[56,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take the wagon distribution rules as input?","N"]
[57,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take wagon movements to and from maintenance depots as input?","N"]
[58,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution take wagon re-planning requirements as input?","N"]
[59,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution identify if wagons are not available for execution as per the countdown activites?","N"]
[60,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution determine the impact of the non-availability of wagons?","N"]
[61,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution identify surplus wagons of the same type in the same depot for allocation?","N"]
[62,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution identify surplus wagons of similar types in the same depot for allocation?","N"]
[63,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution identify surplus wagons of the same type in the closest holding yard for allocation?","N"]
[64,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution identify surplus wagons of similar types in the closest holding yard for allocation?","N"]
[65,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Does the solution allow the user to manually allocate the wagons to orders to manage the deviations?","N"]
[66,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution send the new allocations to the Asset Management solution for issuing of amended works orders?","N"]
[67,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution create deviation reports  for the Wagon Distribution Plan?","N"]
[68,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution provide reasons for deviations from the Wagons Distribution Plan based on the activity that is not completed?","N"]
[69,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution create deviation reports  for the Auxiliary Equipment Distribution Plan?","N"]
[70,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution provide reasons for deviations from the Auxiliary Equipment Distribution Plan based on the activity that is not completed?","N"]
[71,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution assist the user to determine the root cause of the deviation by listing historical occurences/ executed activites related to the deviated activity?","N"]
[72,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Does the solution allow the user to manually capture the root cause for the wagon delay?","N"]
[73,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Does the solution allow the user to manually capture the root cause for the auxiliary equipment delay?","N"]
[74,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution share the deviation report including reasons and root cause analysis to the TCO and Traffic Regulator monitoring solutions for impact analysis?","N"]
[75,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Can the solution recalculate the wagon productivity KPI reports incorporating the deviations?","N"]
[76,"Wagon and Auxiliary Equipment Distribution Plan Monitoring","Does the solution allow for the comparison of the recalcuated KPIs against KPIs calculated during planning?","N"]
[" ","Monitor Adherence to Plan -TCO Train Execution Monitoring and Deviation Management"]
[77,"TCO Train Execution Monitoring and Deviation Management","Can the solution identify differences between the actual train movements and the planned movements on the production plan?","Y","Indicate if the solution can identify differences between the actual train movements and the planned movements on the production plan"]
[78,"TCO Train Execution Monitoring and Deviation Management","Is the solution able to compare actual movements to planned movements for pre-execution and countdown activities and identify any disruptions?","Y","Indicate if the solution can compare actual movements to planned movements for pre-execution and countdown activities and identify any disruptions"]
[79,"TCO Train Execution Monitoring and Deviation Management","Can the solution consider the identified thresholds to determine if a disruption should be classified as a deviation?","Y","Indicate if the solution can consider the identified thresholds to determine if a disruption should be classified as a deviation"]
[80,"TCO Train Execution Monitoring and Deviation Management","Can the solution identify the delay of execution of countdown activities that could impact the execution of the Train Allocation Plan?","N"]
[81,"TCO Train Execution Monitoring and Deviation Management","Can the solution recalculate estimated time of arrival using current position, enroute performance and production plan?","N"]
[82,"TCO Train Execution Monitoring and Deviation Management","Can the solution generate user alerts for deviations?","N"]
[83,"TCO Train Execution Monitoring and Deviation Management","Does the solution allow the end user to capture reasons for the deviation after the investigation is completed? ","N"]
[84,"TCO Train Execution Monitoring and Deviation Management","Can the solution calculate actual locomotive utilisation and efficiency KPIs? \ne.g. number of hours that locomotives are used in a 24-hour period, % time spent hauling trains, Gross Ton Kilometers/locomotive,  Nett Ton Kilometers/locomotive, locomotive kilometers over a given period)","N"]
[85,"TCO Train Execution Monitoring and Deviation Management","Can the solution calculate actual wagon utilisation and efficiency KPIs? \n(e.g. dwell time, idle time, turnaround time)","N"]
[86,"TCO Train Execution Monitoring and Deviation Management","Can the solution calculate actual Train Crew utilisation and efficiency KPIs? \n(e.g. productive time vs promised shift, driver kilometers, overtime trends)","N"]
[87,"TCO Train Execution Monitoring and Deviation Management","Can the solution determine successfull execution of occupation plans (Scheduled start & finish vs actual start & finish, % execution of plan)?","N"]
[88,"TCO Train Execution Monitoring and Deviation Management","Can the solution determine successfull execution of rolling stock maintenance plans (Scheduled start & finish vs actual start & finish, % execution of plan)?","N"]
[89,"TCO Train Execution Monitoring and Deviation Management","Does the solution allow to receive automated and manual inputs and incorporate deviations reported by Value Chain Partners?","Y","Indicate if the solution can allow to receive automated and manual inputs and incorporate deviations reported by Value Chain Partners"]
[90,"TCO Train Execution Monitoring and Deviation Management","Can the system monitor, detect and issue warnings related to Train crew on-shift-time?","N"]
[91,"TCO Train Execution Monitoring and Deviation Management","Can the solution report actual performance KPIs (e.g. On-Time Performance, Devation Alerts and Deviation reasons for all parts of the Mainline Integrated Train Plan)?","N"]
[92,"TCO Train Execution Monitoring and Deviation Management","Can the solution determine re-planning requirements for impacted production plan?","Y","Indicate if the solution can determine re-planning requirements for impacted production plan"]
[93,"TCO Train Execution Monitoring and Deviation Management","Does the solution track the execution of Yard Works Orders?","N"]
[94,"TCO Train Execution Monitoring and Deviation Management","Can the solution determine re-planning requirements for deviations? ","N"]
[" ","Monitor Adherence to Plan -Traffic Regulator Train Execution Monitoring and Deviation Management"]
[95,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution identify differences between the actual train movements and the planned movements on the production plan?","N"]
[96,"Traffic Regulator Train Execution Monitoring and Deviation Management","Is the solution able to compare actual movements to planned movements for pre-execution and countdown activities and identify any disruptions?","N"]
[97,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution consolidate all deviations from other monitoring processes?","N"]
[98,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution trigger the process to assess the impact of deviation?","N"]
[99,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution identify immediate actions to manage the impact of deviations on the execution of the plan?","N"]
[100,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution compile the re-planning requirements for the production plan?","N"]
[101,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution identify and compile re-planning requirements for MTS?","N"]
[102,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution identify and compile re-planning requirements for RBTB?","N"]
[103,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution determine the re-scheduling requirements for impacted production plan (minimising disruption to the originally planned time slots)?","Y","Indicate if the solution can determine the re-scheduling requirements for impacted production plan (minimising disruption to the originally planned time slots"]
[104,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution determine the sequence in which deviated activities should be restarted?","N"]
[105,"Traffic Regulator Train Execution Monitoring and Deviation Management","Are the accumulation of delays at any network locations visible?","N"]
[106,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the demand file be verified against actual historical train movements to identify variations between the demand file and historical movements? ","N"]
[107,"Traffic Regulator Train Execution Monitoring and Deviation Management","Can the solution track all operational movements and activities for a single demand from origin to destination?","N"]
[" ","Assess Impact of Deviations"]
[108,"Assess Impact of Deviations","Can the solution overlay deviations onto the  published production plan? ","Y","Indicate if the solution can overlay deviations onto the  published production plan"]
[109,"Assess Impact of Deviations","Can the solution identify primary impact of deviations on the production plan?","Y","Indicate if the solution can identify primary impact of deviations on the production plan"]
[110,"Assess Impact of Deviations","Can the solution identify secondary impact of deviations on the production plan?","N"]
[111,"Assess Impact of Deviations","Can the solution apply simulation techniques to determine the impact of deviations on the production plan?","Y","Indicate if the solution can apply simulation techniques to determine the impact of deviations on the production plan"]
[112,"Assess Impact of Deviations","Can the Solution determine the  impact of deviations on locomotive & train equipment distribution plan?","N"]
[113,"Assess Impact of Deviations","Can the Solution determine the  impact of deviations on wagon & auxiliary equipment distribution plans?","N"]
[114,"Assess Impact of Deviations","Can the Solution determine the  impact of deviations on crew allocation plans?","N"]
[115,"Assess Impact of Deviations","Can the Solution determine the  impact of deviations on crew transportation vehicle plans?","N"]
[116,"Assess Impact of Deviations","Can the Solution determine the  impact of deviations on planned occupations as per the production plan?","N"]
[117,"Assess Impact of Deviations","Can the Solution determine the impact of Over-border railway  deviations on the production plan?","N"]
[118,"Assess Impact of Deviations","Can the Solution determine the impact of Value chain partner deviations on the production plan?","N"]
[119,"Assess Impact of Deviations","Can the Solution determine which Value chain partners will be impacted by TFR deviations?","N"]
[120,"Assess Impact of Deviations","Can the solution determine the re-planning requirements for all impacted trains?","N"]
[121,"Assess Impact of Deviations","Can the solution determine the locomotive distribution re-planning requirements, taking locomotive-related constraints into account (eg Train Equipment availability, locomotive availability, etc)?","N"]
[122,"Assess Impact of Deviations","Can the solution determine the wagon and auxiliary equipment distribution re-planning requirements, taking wagon-related and customer constraints into account (eg wagon availability, customer loading / off-loading performance, etc)?","N"]
[123,"Assess Impact of Deviations","Can the solution identify impacted occupations as a result of re-planning?","Y","Indicate if the solution can identify impacted occupations as a result of re-planning"]
[124,"Assess Impact of Deviations","Can the solution provide reports on train cancellations, trains re-planned, trains re-scheduled (for mainline,local and yard plans)?","N"]
[125,"Assess Impact of Deviations","Can the solution provide reports on overall profitability per re-planning / re-scheduling scenario?","N"]

{"sheet":"Phase3_ Planning & Simulation","index":12,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,5,1,10],[1,11,1,16]]}
[]
[null,null,null,null,null,"Functionality Assessment",null,null,null,null,null,"Industry Assessment"]
["No.","Function","Supports / Implements:","Critical Requirement","Specific Requirement","OTB","C","TE","T","M","N","FR","PR","TI","LI","O","NA","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Railway Planning and Simulation"]
[1,"Railway Planning and Simulation","Can the solution provide a systematic simulation for the entire train service?","N"]
[2,"Railway Planning and Simulation","Does the solution have the capability to accept objective functions for specific scenarios?","N"]
[3,"Railway Planning and Simulation","Does the solution have the capability to plan for scenario experimentation?","N"]
[4,"Railway Planning and Simulation","Does the solution have a function to capture detailed parameters for a scenario?","N"]
[5,"Railway Planning and Simulation","Can the solution provide for the creation of parameters from another process for a simulation scenario?","N"]
[6,"Railway Planning and Simulation","Does the solution have a function to capture specific KPIs for a scenario?","N"]
[7,"Railway Planning and Simulation","Does the solution cater for the definition of specific constraints for a scenario?","N"]
[8,"Railway Planning and Simulation","Can the solution define scenarios based on inputs parameters received from other processes?","N"]
[9,"Railway Planning and Simulation","Can the solution incorporate rail network capacities during simulation?","N"]
[10,"Railway Planning and Simulation","Can the solution incorporate rail network constraints during simulation?","N"]
[11,"Railway Simulation","Does the solution allow for speed restrictions to be captured / uploaded as an input?","Y","Indicate if the solution can allow for speed restrictions to be captured / uploaded as an input "]
[12,"Railway Simulation","Does the solution use occupations as an input into the simulation model to determine the impact on the timetable ?","N"]
[13,"Railway Planning and Simulation","Is the solution compatible with moving block signalling?","N"]
[14,"Railway Planning and Simulation","Can the solution incorporate locomotive capacities during simulation?","N"]
[15,"Railway Planning and Simulation","Can the solution incorporate locomotive constraints during simulation?","N"]
[16,"Railway Planning and Simulation","Can the solution incorporate wagon capacities during simulation?","N"]
[17,"Railway Planning and Simulation","Can the solution incorporate wagon constraints during simulation?","N"]
[18,"Railway Planning and Simulation","Can the solution incorporate train crew capacities during simulation?","N"]
[19,"Railway Planning and Simulation","Can the solution incorporate train crew constraints during simulation?","N"]
[20,"Railway Planning and Simulation","Can the solution incorporate electrical traction capacities during simulation?","N"]
[21,"Railway Planning and Simulation","Can the solution incorporate electrical traction constraints during simulation?","N"]
[22,"Railway Planning and Simulation","Can the solution incorporate logistics support equipment capacities during simulation?","N"]
[23,"Railway Planning and Simulation","Can the solution incorporate logistics support equipment constraints during simulation?","N"]
[24,"Railway Planning and Simulation","Can the solution perform simulations on microscopic infrastructure models?","N"]
[25,"Railway Planning and Simulation","Can the solution perform simulation on macroscopic infrastructure models?","N"]
[26,"Railway Planning and Simulation","Can the solution follow a deterministic analytical approach?","N"]
[27,"Railway Planning and Simulation","Can the solution follow a stochastic analytical approach?","N"]
[28,"Railway Planning and Simulation","Can the solution consider resource reliability factors during the simulation?","N"]
[29,"Railway Planning and Simulation","Can the solution consider operational site execution reliability factors during the simulation?","N"]
[30,"Railway Planning and Simulation","Can the solution consider operational site capacities during simulation?","N"]
[31,"Railway Planning and Simulation","Can the solution consider operational site constraints during simulation?","N"]
[32,"Railway Planning and Simulation","Can the solution allocate demand to specific slots based on the service specification during simulation?","N"]
[33,"Railway Planning and Simulation","Can the solution identify bottleneck during simulation?","N"]
[34,"Railway Planning and Simulation","Can the solution identify the reason for the bottleneck?","N"]
[35,"Railway Planning and Simulation","Can the solution propose an alternate solution to avoid the bottleneck?","N"]
[36,"Railway Planning and Simulation","Can the soluiton propose a sequence of activities to resolve the bottlenecks?","N"]
[37,"Railway Planning and Simulation","Can the solution determine rail system capacity independent of demand?","N"]
[38,"Railway Planning and Simulation","Can the solution determine the number of trains on a section using the microscopic model and specified train configurations?","N"]
[39,"Railway Planning and Simulation","Does the solution provide the user with a function to compare different scenario simulation results?","N"]
[40,"Railway Planning and Simulation","Can the solution create a report for each simulated scenario depicting at least the feasibility, optimisation, profitability and KPI performance?","N"]
[41,"Railway Planning and Simulation","Can the solution test the feasibility of given demand, resources and timetable scenarios?","N"]
[42,"Railway Planning and Simulation","Can the solution test the total profitability of given demand, resources and timetable scenarios?","N"]
[43,"Railway Planning and Simulation","Can the solution test the KPI performance of given demand, resources and timetable scenarios?","N"]
[44,"Railway Planning and Simulation","Can the solution determining the optimal locations of rolling maintenance stock facilities?","Y","Indicate if the solution can determine the optimal locations of rolling maintenance stock facilities"]
[45,"Railway Planning and Simulation","Can the solution test the need for required recovery slots?","N"]
[46,"Railway Planning and Simulation","Can the solution apply a deviation on the production plan to determine the primary impacts on the production plan?","Y","Indicate if the solution can apply a deviation on the production plan to determine the primary impacts on the production plan"]
[47,"Railway Planning and Simulation","Can the solution apply a deviation on the production plan to determine the secondary impacts on the production plan?","N"]
[48,"Railway Planning and Simulation","Is the process described and documented for how to determine infrastructure constraints?","N","Approach Paper"]
[49,"Railway Planning and Simulation","Can the solution allow for the editing in the graphic view during what-if scenario simulation whilst automatically updating the dataset in the timetable?","N","What-if scenarios, update database with actual movements, integration"]

{"sheet":"Phase 3_Master Data","index":13,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
["No.","Function","Supports / Implements:","Critical Requirement (Y/N)","Specific Requirement","Customer reference","Solution","Reference page / paragraph","Assumptions","Comments"]
[" ","Master Data Build"]
[1,"Master Data Build","Does the proposal list all the required input data and their formats?","Y","Data requirements Matrix - Annexure C"]
[2,"Master Data Build","Does the proposal include the processing of master data for the calibration and resourcing of the Master Train Scheduling Module for a 10 year traffic file? (Run the full capacity planning cycle for 10 years)","Y"]
[3,"Master Data Build","Does the solution cater for the maintenance of  train configurations?","Y"]
[4,"Master Data Build","Does the solution cater for the maintenance of maximum train slot capacity percentage rules and recovery slot allocation rules?","Y"]
[5,"Master Data Build","Does the solution cater for the maintenance of blocking rules?","Y"]
[6,"Master Data Build","Does the solution cater for the upload of Operational site capacities and constraints?","Y"]
[7,"Master Data Build","Does the solution cater for the upload of Resource allocation rules?","Y"]
[8,"Master Data Build","Does the solution cater for the upload of Rolling stock Maintenance standards?","Y"]
[9,"Master Data Build","Does the solution cater for the upload of Infrastructure Maintenance standards?","Y"]
[10,"Master Data Build","Does the solution cater for the upload of rail directives and standards?","Y"]
[11,"Master Data Build","Does the solution cater for the upload of rolling stock asset maintenance plans?","Y"]
[12,"Master Data Build","Does the solution cater for the upload of Infrastructure maintenance  plans?","Y"]
[13,"Master Data Build","Does the solution cater for the maintenance of logistic support equipment maintenance schedules?","Y"]
[14,"Master Data Build","Does the solution cater for the maintenance of deviation thresholds on Service Specifications and slot activities?  ","Y"]
[15,"Master Data Build","Does the solution cater for the upload of train crewing strategies?","Y"]
[16,"Master Data Build","Does the solution cater for the upload and maintenance of Train Crew Availability Rules?","Y"]
[17,"Master Data Build","Does the solution cater for the upload of Asset Reliability Factors?","Y"]
[18,"Master Data Build","Does the solution cater for the upload of Train Crew Depot Locations, Strength and Matrix?","Y"]
[19,"Master Data Build","Does the proposal cater for the maintenance of locomotive allocation rules?","N"]
[20,"Master Data Build","Does the proposed solution enable a link with the engineering document repository to manually maintain Train Technical Specifications?","N"]
[" ","Data Management"]
[21,"Data Management","Does the solution provide for a standardized data transfer mechanism across modules?","Y"]
[22,"Data Management","Does the proposal provide the capability to configure all input and output data?","Y"]
[23,"Data Management","Is there a process developed for managing versions of the simulations in the modules?","N"]
[24,"Data Management","Is there a process developed for automatic generation of naming conventions for simulation scenarios?","N"]
[25,"Data Management","Does the proposal describe how master data will be captured and maintained in the solution?","Y"]
[26,"Data Management","Does the solution keep audit trail of all master data changes in the system?","Y"]
[27,"Data Management","Does the solution keep time stamps of all master data and transactional data changes in the system?","Y"]
[28,"Data Management","Does the solution keep time stamps of all master data and transactional data creation in the system?","Y"]

{"sheet":"Phase 4_Instruction","index":14,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,3,1,5],[1,1,1,2]]}
[null,"PRESENTATION: TECHNICAL FIT INSTRUCTIONS"]
[null,"Presentation: Technical Fit",null,"Bidder Instructions:\n\tBidders that successfully meet the criteria in STAGE 1,2 and 3 will proceed to the fourth stage. Stage 4: will focus on confirming the paper responses to establish whether the proposed solution can provide the functionality as required. \n"]