{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Cover Sheet","Functional Instructions","Data Requirements Matrix"],"not_rendered":{"images":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":8,"n_cols":1,"rows_kept":8}
[]
[]
[]
["Integrated Train Planning Technology Implementation Partner Selection"]
["Transnet Freight Rail"]
[]
[]
["Annexure_C_CPS_ITP_MDM_Data_Requirements_Matrix_V3.0"]

{"sheet":"Functional Instructions","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"merged":[[0,1,0,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],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[null,"Functionality Assessment",null,"Complete the data requirement matrix for all capabilities of the proposed solution."]
[null,"Heading",null,"Definition"]
[null,"Function  ",null,"The process in the TDR for which the data is required."]
[null,"Capability",null,"The capability in the TDR for which the data is required."]
[null,"Proposed Module",null,"The name of the proposed module for which the data is required."]
[null,"Field Name",null,"The name of the field."]
[null,"Field Description",null,"A description of the field name."]
[null,"Data Purpose",null,"The reason for the data and how it will be applied in the proposed solution."]
[null,"Data example",null,"Provide and example of the data required in the field."]
[null,"Field Criticality",null,"Indicate if the field is mandatory or optional.  "]
[null,"Field Type",null,"Indicate if the field is defined as a character, numeric, alphanumberic, variable, long text etc. in the proposed solution."]
[null,"Field Length",null,"Provide the defined length of the field in the proposed solution."]
[null,"Field Format",null,"Indicate the format of the data e.g. date is CCYYMMDD "]
[null,"Comments",null,"Provide additional information or requirements with relation to the field or data."]

{"sheet":"Data Requirements Matrix","index":2,"n_rows":33,"n_cols":12,"rows_kept":33}
["Data Requirements Matrix"]
[]
["Function","Capability","Proposed Module","Field Name","Field Description","Data Purpose","Data Example","Field Criticality","Field Type","Field Length","Field Format","Comments"]
["Master Train Scheduling"]
["Master Train Scheduling ","Slot Capacity",{"$nulls":4}," "]
["Master Train Scheduling","Blocking"]
["Master Train Scheduling ","MTS"]
["Master Train Scheduling ","Resourced Base Train Plan"]
["Master Train Scheduling ","Service specification"]
["Master Train Scheduling ","Service specification costing"]
["Master Train Scheduling ","Demand Prioritisation Optimisation"]
["Railway Simulation"]
["Railway Simulation"," "]
["Railway Network Capacity Planning"]
["Railway Network Capacity  Planning"]
["Rolling Stock Capacity Planning"]
["Rolling Stock Capacity Planning"]
["Train Crew Capacity Planning"]
["Train Crew Capacity Planning"]
["Production Plan "]
["Production Plan "]
["Yard and Local Plans"]
["Yard and Local Plans"]
["Wagon Distribution Plan"]
["Wagon Distribution Plan"]
["Locomotive Distribution Plan"]
["Locomotive Distribution Plan"]
["Train Crew Allocation Plan"]
["Train Crew Allocation Plan"]
["Monitor Adherence to Plan"]
["Monitor Adherence to Plan"]
["Assess Impact of Deviations"]
["Assess Impact of Deviations"]