{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Introduction","Instructions","General","Cross Section (0)","Cross Section (1)","Cross Section (2)","Cross Section (3)","Layers","Overthrows","Dynamic (1)","Dynamic (2)","Dynamic (3)","Tolerances"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":0,"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","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[15,3,18,5],[12,3,12,6],[9,3,9,5],[13,3,13,5],[1,3,1,5],[1,6,1,8]]}
[]
[null,null,null,"8073SVGD - PG3  "]
[null,null,null,"Issue",4]
[null,null,null,"Date","December 2020"]
[]
[]
[]
[]
[]
[null,null,null,"Standard Vehicle Gauge data - PG3"]
[]
[]
[null,null,null,"Synopsis"]
[null,null,null,"This workbook sets out the movement associated with PG3."]
[]
[null,null,null,"Copyright in the Railway Group documents is owned by Rail Safety and Standards Board Limited.  All rights are hereby reserved.  No Railway Group document (in whole or in part) may be reproduced, stored in a retrieval system, or transmitted, in any form or means, without the prior written permission of Rail Safety and Standards Board Limited, or as expressly permitted by law.\nRSSB members are granted copyright licence in accordance with the Constitution Agreement relating to Rail Safety and Standards Board Limited.\nIn circumstances where Rail Safety and Standards Board Limited has granted a particular person or organisation permission to copy extracts from Railway Group documents, Rail Safety and Standards Board Limited accepts no responsibility for, nor any liability in connection with, the use of such extracts, or any claims arising therefrom.  This disclaimer applies to all forms of media in which extracts from Railway Group documents may be reproduced."]
[]
[]
[]
[]
[null,null,null,"Published by:"]
[]
[null,null,null,"RSSB"]
[]
[]
[]
[]
[]
[]
[null,null,null,"© Copyright 2020"]
[null,null,null,"Rail Safety and Standards Board Limited"]

{"sheet":"Introduction","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[5,0,5,7],[6,0,6,7],[2,3,2,6],[3,3,3,6],[15,0,15,7],[17,0,17,6],[20,0,20,6],[7,2,7,7],[8,2,8,7],[10,0,10,7],[11,0,11,7],[13,0,13,7],[14,0,14,7]]}
["Issue Record"]
[]
["Issue","Issue date","Template Version","Comments"]
["4","December  2020",7,"First issue to align with GERT8073 which has been revised and reissued to issue four. \n"]
[]
["Superseded documents"]
["The following Railway Group documents are superseded, either in whole or in part as indicated:"]
["Superseded documents","Sections superseded","Date when sections are superseded"]
["-","-","-"]
[]
["Supply"]
["The authoritative version of this document is available athttp://www.rssb.co.uk/railway-group-standards. Enquiries on this document can be submitted through the RSSB Customer Self-Service Portal https://customer-portal.rssb.co..uk/"]
[]
["Purpose of this document"]
["This workbook is required to be used to calculate the movements of established suspensions associated with PG3.  \nThis workbook contains only dynamic envelopes associated with the applicable gauges as defined in the index worksheet.\nThe workbook is designed to be read by a computer and thus requires the format and naming of worksheets to be preserved.  It is allowable to annotate where required, or to add additional worksheets.\n\nThis workbook is associated with GERT8073 issue 4, Requirements for the Application of Standard Vehicle Gauges, which documents the movements of PG3.\n\nTo comply with the requirements for the PG3, this workbook is to be used without amendment. If you are having problems complying with this workbook and wish to use an alternative way of calculating the PG3, you are required to apply for a deviation from GERT8073.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Users of this workbook are reminded of the terms and conditions agreed to when registering to access RSSB content, the full terms and conditions are available on the RSSB website. "]
["\n\n"]
["Approval and authorisation of this document"]
["The content of this document was approved by Rolling Stock Standards Committee on 04 September 2020.\n\nThis document was authorised by RSSB on 16 October 2020."]
[]
["Health and Safety responsibilities"]
["Users of documents published by RSSB are reminded of the need to consider their own responsibilities to ensure health and safety at work and their own duties under health and safety legislation.  RSSB does not warrant that compliance with all or any documents published by RSSB is sufficient in itself to ensure safe systems of work or operation or to satisfy such responsibilities or duties."]

{"sheet":"Instructions","index":2,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,11,1,13],[6,2,6,5],[16,2,16,8],[17,2,17,8],[10,2,10,8],[11,2,11,8],[12,2,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Version 7","(Workbook template version)"]
[null,null,null,null,null,null,null,null,null,null,"2020-12-05"]
[]
[]
[]
[null,"Reference",{"$f":"IF(General!B4<>\"\",+General!B4,\"\")","v":"LV-PG3"}]
[]
[null,"Notes:"]
[]
[null,1,"This workbook has been produced as a standard template for transmitting and storing vehicle gauging data for use in the absolute gauging process. "]
[null,{"$f":"+B11+1","v":2},"The workbook is designed to be read by a computer and thus requires the format and naming of worksheets to be preserved. It is allowable to annotate where required, or to add additional worksheets."]
[null,3,"The workbook includes single General, Overthrows, Layers and Tolerances worksheets."]
[null,4,"The workbook includes five Cross Section worksheets. Where additional Cross Section worksheets are required, a macro has been provided which generates a blank Cross Section and modifies the General, Layers and Overthrow worksheets. If adding a Cross Section manually, it is important to also update the General, Layers and Ovethrows worksheets."]
[null,5,"The workbook includes four Dynamics worksheets. If more are required, they can be added. The index on the General worksheet should also be updated."]
[null,6,"The user is required to complete the cells highlighted in yellow. Each cell has a tool tip explaining what is required for that particular cell."]
[null,7,"Cells highlighted in green are automatically updated from the primary entry of the particular value, or duplicate primary values where they would normally be the same. The user may over-write green cells with appropriate values should they not match the primary values."]
[null,8,"Each worksheet is locked, but without a password. This is to prevent inadvertant changing of identification parameters."]

{"sheet":"General","index":3,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,0,34,3],[29,0,29,2],[16,2,16,3],[8,0,8,5],[9,1,9,5],[16,4,16,5],[16,0,16,1],[21,0,21,2]]}
["General Data"]
[]
["Vehicle","Passenger Gauge 3"]
["Document Ref","LV-PG3"]
["Issue",1,"Date","2017-05-18"]
["Input by"]
["Checked by"]
[]
["Worksheet Index"]
["Type","Worksheet Name(s)"]
["Cross Sections","Cross Section (1)","Cross Section (2)","Cross Section (3)"]
["Layers","Layers"]
["Overthrows","Overthrows"]
["Dynamics","Dynamic (1)","Dynamic (2)","Dynamic (3)"]
["Tolerances","Tolerances"]
[]
["Dynamic Conditions",null,"Maximum Speed",null,"Maximum Cant"]
["Dyn1",{"$f":"+'Dynamic (1)'!B3:C3","v":"Case 1"},200,"km/h",150,"mm"]
["Dyn2",{"$f":"+'Dynamic (2)'!B3:C3","v":"Case 2"},200,"km/h",{"$f":"+E18","v":150},"mm"]
["Dyn3",{"$f":"+'Dynamic (3)'!B3:C3","v":"Case 3"},{"$f":"+C18","v":200},"km/h",{"$f":"+E19","v":150},"mm"]
[]
["Bogies"]
["Bogie Centres",17000,"mm"]
["Bogie Wheelbase",2700,"mm"]
["Track Gauge",1435,"mm"]
["Wheelset Front - Front",1419,"mm"]
["Bogie 1 Type","N/A"]
["Bogie 2 Type",{"$f":"+B27","v":"N/A"}]
[]
["Datum Points"]
["Cantrail height",3000,"mm"]
["Waist height",1800,"mm"]
["Solebar height",1100,"mm"]
[]
["Drawing Numbers"]
["Type","Number","Issue","Date"]

{"sheet":"Cross Section (0)","index":4,"n_rows":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":true,"merged":[[3,1,3,4]]}
["Cross Section"]
[]
["Distance",null,"mm"]
["Name","Blank"]
["Bogie",false]
[]
["x","y","Join","Critical","Feature"]
["mm","mm"]
[null,null,false,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]
[null,null,true,true]

{"sheet":"Cross Section (1)","index":5,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Cross Section"]
[]
["Distance",0,"mm"]
["Name","Gauge Centre"]
["Bogie",false]
[]
["x","y","Join","Critical","Feature"]
["mm","mm"]
[570.89930000000004,3869.8598000000002,false,true]
[494.00279999999998,3896.0868,true,true]
[35.433399999999999,3902.9832000000001,true,true]
[0,3903.2256000000002,true,true]
[-35.433399999999999,3902.9832000000001,true,true]
[-494.00279999999998,3896.0868,true,true]
[-570.89930000000004,3869.8598000000002,true,true]
[-825.24590000000001,3743.7431999999999,true,true]
[-1206.8726999999999,3447.5608000000002,true,true]
[-1281.1039000000001,3331.4499000000001,true,true]
[-1392.1759,1472.2863,true,true]
[-1392.1759,1120.7619,true,true]
[-1244.0702000000001,1118.5153,true,true]
[-1243.5778,1118.009,true,true]
[-1171.4992999999999,1037.0944,true,true]
[-1164.2815000000001,1016.3493999999999,true,true]
[-1148.6355000000001,958.46569999999997,true,true]
[-1148.4086,950,true,true]
[0,950,true,true]
[1148.4086,950,true,true]
[1148.6355000000001,958.46569999999997,true,true]
[1164.2815000000001,1016.3493999999999,true,true]
[1171.4992999999999,1037.0944,true,true]
[1243.5778,1118.009,true,true]
[1244.0702000000001,1118.5153,true,true]
[1392.1759,1120.7619,true,true]
[1392.1759,1472.2863,true,true]
[1281.1039000000001,3331.4499000000001,true,true]
[1206.8726999999999,3447.5608000000002,true,true]
[825.24590000000001,3743.7431999999999,true,true]
[570.89930000000004,3869.8598000000002,true,true]

{"sheet":"Cross Section (2)","index":6,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Cross Section"]
[]
["Distance",11400,"mm"]
["Name","Start of Body Taper"]
["Bogie",false]
[]
["x","y","Join","Critical","Feature"]
["mm","mm"]
[570.89930000000004,3869.8598000000002,false,true]
[494.00279999999998,3896.0868,true,true]
[35.433399999999999,3902.9832000000001,true,true]
[0,3903.2256000000002,true,true]
[-35.433399999999999,3902.9832000000001,true,true]
[-494.00279999999998,3896.0868,true,true]
[-570.89930000000004,3869.8598000000002,true,true]
[-825.24590000000001,3743.7431999999999,true,true]
[-1206.8726999999999,3447.5608000000002,true,true]
[-1281.1039000000001,3331.4499000000001,true,true]
[-1392.1759,1472.2863,true,true]
[-1392.1759,1120.7619,true,true]
[-1244.0702000000001,1118.5153,true,true]
[-1243.5778,1118.009,true,true]
[-1171.4992999999999,1037.0944,true,true]
[-1164.2815000000001,1016.3493999999999,true,true]
[-1148.6355000000001,958.46569999999997,true,true]
[-1148.4086,950,true,true]
[0,950,true,true]
[1148.4086,950,true,true]
[1148.6355000000001,958.46569999999997,true,true]
[1164.2815000000001,1016.3493999999999,true,true]
[1171.4992999999999,1037.0944,true,true]
[1243.5778,1118.009,true,true]
[1244.0702000000001,1118.5153,true,true]
[1392.1759,1120.7619,true,true]
[1392.1759,1472.2863,true,true]
[1281.1039000000001,3331.4499000000001,true,true]
[1206.8726999999999,3447.5608000000002,true,true]
[825.24590000000001,3743.7431999999999,true,true]
[570.89930000000004,3869.8598000000002,true,true]

{"sheet":"Cross Section (3)","index":7,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Cross Section"]
[]
["Distance",13000,"mm"]
["Name","End of Body Taper"]
["Bogie",false]
[]
["x","y","Join","Critical","Feature"]
["mm","mm"]
[-1206.8726999999999,3447.5608000000002,false,true]
[-825.24590000000001,3743.7431999999999,true,true]
[-570.89930000000004,3869.8598000000002,true,true]
[-557.93230000000005,3874.2824999999998,true,true]
[-35.151400000000002,3882.1444999999999,true,true]
[0,3882.3850000000002,true,true]
[35.151400000000002,3882.1444999999999,true,true]
[557.93230000000005,3874.2824999999998,true,true]
[570.89930000000004,3869.8598000000002,true,true]
[825.24590000000001,3743.7431999999999,true,true]
[1206.8726999999999,3447.5608000000002,true,true]
[1281.1039000000001,3331.4499000000001,true,true]
[1293.5535,3123.0643,true,true]
[1305.9036000000001,2592.1833000000001,true,true]
[1305.9036000000001,1119.4531999999999,true,true]
[1244.0702000000001,1118.5153,true,true]
[1226.9695999999999,1099.3648000000001,true,true]
[1108.6107,1096.2095999999999,true,true]
[1091.3721,1073.6135999999999,true,true]
[1063.1167,1025.6439,true,true]
[1057.2354,1003.7867,true,true]
[1057.2354,950,true,true]
[0,950,true,true]
[-1057.2354,950,true,true]
[-1057.2354,1003.7867,true,true]
[-1063.1167,1025.6439,true,true]
[-1091.3721,1073.6135999999999,true,true]
[-1108.6107,1096.2095999999999,true,true]
[-1226.9695999999999,1099.3648000000001,true,true]
[-1244.0702000000001,1118.5153,true,true]
[-1305.9036000000001,1119.4531999999999,true,true]
[-1305.9036000000001,2592.1833000000001,true,true]
[-1293.5535,3123.0643,true,true]
[-1281.1039000000001,3331.4499000000001,true,true]
[-1206.8726999999999,3447.5608000000002,true,true]

{"sheet":"Layers","index":8,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,4,5,6],[1,4,1,6]]}
["Layers"]
[null,null,null,null,"Sign Convention"]
[null,null,null,null,"Camber","+ve","Up"]
[null,null,null,null,"Sag","-ve","Down"]
[]
[null,null,null,null,"Camber (+ve) or Sag (-ve)"]
["Number","Name","Distance","Bogie","Dyn1","Dyn2","Dyn3"]
[null,null,"mm",null,"mm","mm","mm"]
[1,{"$f":"+'Cross Section (1)'!B4:E4","v":"Gauge Centre"},{"$f":"+'Cross Section (1)'!B3","v":0},{"$f":"+'Cross Section (1)'!B5","v":false},0,0,0]
[2,{"$f":"+'Cross Section (2)'!B4:E4","v":"Start of Body Taper"},{"$f":"+'Cross Section (2)'!B3","v":11400},{"$f":"+'Cross Section (2)'!B5","v":false},0,0,0]
[3,{"$f":"+'Cross Section (3)'!$B$4","v":"End of Body Taper"},{"$f":"+'Cross Section (3)'!$B$3","v":13000},{"$f":"+'Cross Section (3)'!$B$5","v":false},0,0,0]

{"sheet":"Overthrows","index":9,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,11,8,12],[8,13,8,14],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,9,8,10]]}
["Overthrows"]
[]
["Bogie Centres",{"$f":"+General!B23","v":17000},"mm"]
["Axle Spacing",{"$f":"+General!B24","v":2700},"mm"]
["Semi Width",1,"mm"]
["Height",1,"mm"]
[]
["Lateral",null,null,null,null,null,null,null,"Vertical"]
["Section",{"$f":"+'Cross Section (1)'!B4","v":"Gauge Centre"},null,{"$f":"+'Cross Section (2)'!B4","v":"Start of Body Taper"},null,{"$f":"+'Cross Section (3)'!$B$4","v":"End of Body Taper"},null,null,"Section",{"$f":"+B9","v":"Gauge Centre"},null,{"$f":"+D9","v":"Start of Body Taper"},null,{"$f":"+F9","v":"End of Body Taper"}]
["Section Dist",{"$f":"+'Cross Section (1)'!B3","v":0},"mm",{"$f":"+'Cross Section (2)'!B3","v":11400},"mm",{"$f":"+'Cross Section (3)'!$B$3","v":13000},"mm",null,"Section Dist",{"$f":"+B10","v":0},"mm",{"$f":"+D10","v":11400},"mm",{"$f":"+F10","v":13000},"mm"]
["Curve","C/L","Delta","C/L","Delta","C/L","Delta",null,"Curve","ARL","Delta","ARL","Delta","ARL","Delta"]
["m","mm","mm","mm","mm","mm","mm",null,"m","mm","mm","mm","mm","mm","mm"]

{"sheet":"Dynamic (1)","index":10,"n_rows":32,"n_cols":31,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,13,17,14],[2,10,2,20],[17,7,17,8],[3,1,3,2],[11,0,11,3],[13,5,13,6],[17,19,17,20],[17,17,17,18],[17,3,17,4],[17,5,17,6],[17,9,17,10],[17,11,17,12],[17,27,17,28],[17,29,17,30],[16,15,16,20],[12,17,12,18],[13,17,13,18],[15,23,15,30],[16,27,16,30],[17,25,17,26],[17,23,17,24],[17,15,17,16],[0,2,0,7],[6,0,6,3],[7,2,7,3],[4,1,4,2],[12,5,12,6],[8,2,8,3],[9,2,9,3],[2,1,2,2],[1,23,1,30],[3,23,3,30],[6,22,6,24],[16,3,16,8],[16,9,16,14],[1,10,1,20],[16,23,16,26],[2,23,2,30]]}
["Dynamic Analysis",null,null,null,null,null,null,null,null,"Notes on Body and Wheelset movements",null,null,null,null,null,null,null,null,null,null,null,null,"Notes on Wheelset Movements"]
[null,null,null,null,null,null,null,null,null,1,"Body and wheelset movements refer to the movement due to speed and cant on tangent track.",null,null,null,null,null,null,null,null,null,null,null,1,"Bogie 2 curving movements are only required if they differ from bogie 1."]
["Condition","Case 1",null,null,null,null,null,null,null,{"$f":"+J2+1","v":2},"Movements at Vehicle Centre and Bogie 2 need only be provided when the analysis of vehicle roll and pitch is required.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W2+1","v":2},"Where only Bogie movements are available, these values should be entered for both leading and trailing values."]
["Track Quality","Limit State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W3+1","v":3},"Curving movements are the offset to the outside or inside resulting from curvature without applied cant."]
["Wind","0 m/s"]
[]
["Sign Convention",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sign Convention"]
["Lateral","+ve","Outside",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheels","+ve","Outside"]
["Vertical","+ve","Down"]
["Roll","+ve","Outside"]
[]
["Dimensions"]
["Datum Height",1300,"mm","ARL",null,"Bogie 1 Load",null,null,"kg",null,null,null,null,null,null,null,null,"Bogie 2 Load",null,{"$f":"+H13","v":0},"kg"]
["Bogie Centres",{"$f":"+General!B23","v":17000},"mm",null,null,"Primary Stiffness",null,null,"N/mm",null,null,null,null,null,null,null,null,"Primary Stiffness",null,{"$f":"+H14","v":0},"N/mm"]
["Track Gauge",{"$f":"+General!B25","v":1435},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheelset Lateral Movements"]
[null,null,null,"Wheelsets and Body at Bogie 1",null,null,null,null,null,"Wheelsets and Body at Vehicle Centre",null,null,null,null,null,"Wheelsets and Body at Bogie 2",null,null,null,null,null,null,null,"Curving Bogie 1",null,null,null,"Curving Bogie 2"]
[null,"Cant","Speed","Lateral avg",null,"Vertical avg",null,"Roll avg",null,"Lateral avg",null,"Vertical avg",null,"Roll avg",null,"Lateral avg",null,"Vertical avg",null,"Roll avg",null,null,null,"New profile",null,"Worn profile",null,"New profile",null,"Worn profile"]
[null,null,null,"Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD",null,"Curve","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing"]
["Reference","mm","km/h","mm","mm","mm","mm","deg","deg","mm","mm","mm","mm","deg","deg","mm","mm","mm","mm","deg","deg",null,"m","mm","mm","mm","mm","mm","mm","mm","mm"]
[1,0,0,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,null,2001,0,0,0,0,0,0,0,0]
[2,0,200,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,null,2000,0,0,0,0,0,0,0,0]
[3,50,0,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,null,1999,9.0939619999999988E-3,9.0939619999999988E-3,1.643622E-3,1.643622E-3,9.0939619999999988E-3,9.0939619999999988E-3,1.643622E-3,1.643622E-3]
[4,50,200,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,23.633180574695089,8.1286884081626898,0.82390183463057198,4.7283610068358497,0.48,0.18,null,1000,9.0939619999999994,9.0939619999999994,1.6436219999999999,1.6436219999999999,9.0939619999999994,9.0939619999999994,1.6436219999999999,1.6436219999999999]
[5,75,0,35.461091692680689,8.7023152393015604,1.4375519032796955,4.7356181754465903,0.72,0.18,35.461091692680689,8.7023152393015604,1.4375519032796955,4.7356181754465903,0.72,0.18,35.461091692680689,8.7023152393015604,1.4375519032796955,4.7356181754465903,0.72,0.18,null,800,11.03158,11.03158,1.8997170000000001,1.8997170000000001,11.03158,11.03158,1.8997170000000001,1.8997170000000001]
[6,75,200,35.461091692680689,8.7023152393015604,1.4375519032796955,4.7356181754465903,0.72,0.18,35.461091692680689,8.7023152393015604,1.4375519032796955,4.7356181754465903,0.72,0.18,35.461091692680689,8.7023152393015604,1.4375519032796955,4.7356181754465903,0.72,0.18,null,600,12.418620000000001,12.418620000000001,1.9346239999999999,1.9346239999999999,12.418620000000001,12.418620000000001,1.9346239999999999,1.9346239999999999]
[7,100,0,46.638337144394129,9.4621051205688094,1.7672023681486966,4.7390744513054104,0.96,0.18,46.638337144394129,9.4621051205688094,1.7672023681486966,4.7390744513054104,0.96,0.18,46.638337144394129,9.4621051205688094,1.7672023681486966,4.7390744513054104,0.96,0.18,null,500,12.591010000000001,12.591010000000001,1.783561,1.783561,12.591010000000001,12.591010000000001,1.783561,1.783561]
[8,100,200,46.638337144394129,9.4621051205688094,1.7672023681486966,4.7390744513054104,0.96,0.18,46.638337144394129,9.4621051205688094,1.7672023681486966,4.7390744513054104,0.96,0.18,46.638337144394129,9.4621051205688094,1.7672023681486966,4.7390744513054104,0.96,0.18,null,400,12.03265,12.03265,1.4346650000000001,1.4346650000000001,12.03265,12.03265,1.4346650000000001,1.4346650000000001]
[9,125,0,56.768204768239897,9.5168845432830604,2.497788840135426,4.7488887284787298,1.18,0.2,56.768204768239897,9.5168845432830604,2.497788840135426,4.7488887284787298,1.18,0.2,56.768204768239897,9.5168845432830604,2.497788840135426,4.7488887284787298,1.18,0.2,null,300,10.14883,10.14883,0.80305099999999996,0.80305099999999996,10.14883,10.14883,0.80305099999999996,0.80305099999999996]
[10,125,200,56.768204768239897,9.5168845432830604,2.497788840135426,4.7488887284787298,1.18,0.2,56.768204768239897,9.5168845432830604,2.497788840135426,4.7488887284787298,1.18,0.2,56.768204768239897,9.5168845432830604,2.497788840135426,4.7488887284787298,1.18,0.2,null,201,6.1031464899999994,6.1031464899999994,-9.2251900000000012E-3,-9.2251900000000012E-3,6.1031464899999994,6.1031464899999994,-9.2251900000000012E-3,-9.2251900000000012E-3]
[11,150,0,65.170024604020469,9.0509317905563798,2.8356701301522271,4.76178503023438,1.38,0.22,65.170024604020469,9.0509317905563798,2.8356701301522271,4.76178503023438,1.38,0.22,65.170024604020469,9.0509317905563798,2.8356701301522271,4.76178503023438,1.38,0.22,null,200,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2]
[12,150,200,65.170024604020469,9.0509317905563798,2.8356701301522271,4.76178503023438,1.38,0.22,65.170024604020469,9.0509317905563798,2.8356701301522271,4.76178503023438,1.38,0.22,65.170024604020469,9.0509317905563798,2.8356701301522271,4.76178503023438,1.38,0.22,null,199,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2]

{"sheet":"Dynamic (2)","index":11,"n_rows":32,"n_cols":31,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,23,1,30],[17,13,17,14],[6,22,6,24],[12,17,12,18],[13,17,13,18],[1,10,1,20],[17,23,17,24],[2,10,2,20],[16,9,16,14],[17,11,17,12],[15,23,15,30],[16,15,16,20],[16,27,16,30],[17,27,17,28],[17,29,17,30],[16,23,16,26],[2,1,2,2],[3,1,3,2],[4,1,4,2],[6,0,6,3],[7,2,7,3],[17,15,17,16],[17,25,17,26],[2,23,2,30],[3,23,3,30],[17,3,17,4],[17,5,17,6],[17,7,17,8],[11,0,11,3],[17,9,17,10],[16,3,16,8],[17,17,17,18],[17,19,17,20],[12,5,12,6],[13,5,13,6],[8,2,8,3],[9,2,9,3]]}
["Dynamic Analysis",null,null,null,null,null,null,null,null,"Notes on Body and Wheelset movements",null,null,null,null,null,null,null,null,null,null,null,null,"Notes on Wheelset Movements"]
[null,null,null,null,null,null,null,null,null,1,"Body and wheelset movements refer to the movement due to speed and cant on tangent track.",null,null,null,null,null,null,null,null,null,null,null,1,"Bogie 2 curving movements are only required if they differ from bogie 1."]
["Condition","Case 2",null,null,null,null,null,null,null,{"$f":"+J2+1","v":2},"Movements at Vehicle Centre and Bogie 2 need only be provided when the analysis of vehicle roll and pitch is required.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W2+1","v":2},"Where only Bogie movements are available, these values should be entered for both leading and trailing values."]
["Track Quality","Limit State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W3+1","v":3},"Curving movements are the offset to the outside or inside resulting from curvature without applied cant."]
["Wind","0 m/s"]
[]
["Sign Convention",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sign Convention"]
["Lateral","+ve","Outside",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheels","+ve","Outside"]
["Vertical","+ve","Down"]
["Roll","+ve","Outside"]
[]
["Dimensions"]
["Datum Height",{"$f":"+'Dynamic (1)'!B13","v":1300},"mm","ARL",null,"Bogie 1 Load",null,{"$f":"+'Dynamic (1)'!H13","v":0},"kg",null,null,null,null,null,null,null,null,"Bogie 2 Load",null,{"$f":"+H13","v":0},"kg"]
["Bogie Centres",{"$f":"+General!B23","v":17000},"mm",null,null,"Primary Stiffness",null,{"$f":"+'Dynamic (1)'!H14","v":0},"N/mm",null,null,null,null,null,null,null,null,"Primary Stiffness",null,{"$f":"+H14","v":0},"N/mm"]
["Track Gauge",{"$f":"+General!B25","v":1435},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheelset Lateral Movements"]
[null,null,null,"Wheelsets and Body at Bogie 1",null,null,null,null,null,"Wheelsets and Body at Vehicle Centre",null,null,null,null,null,"Wheelsets and Body at Bogie 2",null,null,null,null,null,null,null,"Curving Bogie 1",null,null,null,"Curving Bogie 2"]
[null,"Cant","Speed","Lateral avg",null,"Vertical avg",null,"Roll avg",null,"Lateral avg",null,"Vertical avg",null,"Roll avg",null,"Lateral avg",null,"Vertical avg",null,"Roll avg",null,null,null,"New profile",null,"Worn profile",null,"New profile",null,"Worn profile"]
[null,null,null,"Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD",null,"Curve","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing"]
["Reference","mm","km/h","mm","mm","mm","mm","deg","deg","mm","mm","mm","mm","deg","deg","mm","mm","mm","mm","deg","deg",null,"m","mm","mm","mm","mm","mm","mm","mm","mm"]
[1,0,0,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,null,2001,0,0,0,0,0,0,0,0]
[2,0,200,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,null,2000,0,0,0,0,0,0,0,0]
[3,50,0,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,null,1999,9.0939619999999988E-3,9.0939619999999988E-3,1.643622E-3,1.643622E-3,9.0939619999999988E-3,9.0939619999999988E-3,1.643622E-3,1.643622E-3]
[4,50,200,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,38.251180574695098,8.1286884081626898,27.292160329317301,4.7283610068358497,0.84,0.28000000000000003,null,1000,9.0939619999999994,9.0939619999999994,1.6436219999999999,1.6436219999999999,9.0939619999999994,9.0939619999999994,1.6436219999999999,1.6436219999999999]
[5,75,0,53.823091692680684,8.7023152393015604,27.711874105182819,4.7356181754465903,1.22,0.28000000000000003,53.823091692680684,8.7023152393015604,27.711874105182819,4.7356181754465903,1.22,0.28000000000000003,53.823091692680684,8.7023152393015604,27.711874105182819,4.7356181754465903,1.22,0.28000000000000003,null,800,11.03158,11.03158,1.8997170000000001,1.8997170000000001,11.03158,11.03158,1.8997170000000001,1.8997170000000001]
[6,75,200,53.823091692680684,8.7023152393015604,27.711874105182819,4.7356181754465903,1.22,0.28000000000000003,53.823091692680684,8.7023152393015604,27.711874105182819,4.7356181754465903,1.22,0.28000000000000003,53.823091692680684,8.7023152393015604,27.711874105182819,4.7356181754465903,1.22,0.28000000000000003,null,600,12.418620000000001,12.418620000000001,1.9346239999999999,1.9346239999999999,12.418620000000001,12.418620000000001,1.9346239999999999,1.9346239999999999]
[7,100,0,65.440337144394121,9.4621051205688094,28.003397458793273,4.7390744513054104,1.54,0.26,65.440337144394121,9.4621051205688094,28.003397458793273,4.7390744513054104,1.54,0.26,65.440337144394121,9.4621051205688094,28.003397458793273,4.7390744513054104,1.54,0.26,null,500,12.591010000000001,12.591010000000001,1.783561,1.783561,12.591010000000001,12.591010000000001,1.783561,1.783561]
[8,100,200,65.440337144394121,9.4621051205688094,28.003397458793273,4.7390744513054104,1.54,0.26,65.440337144394121,9.4621051205688094,28.003397458793273,4.7390744513054104,1.54,0.26,65.440337144394121,9.4621051205688094,28.003397458793273,4.7390744513054104,1.54,0.26,null,400,12.03265,12.03265,1.4346650000000001,1.4346650000000001,12.03265,12.03265,1.4346650000000001,1.4346650000000001]
[9,125,0,73.062204768239909,9.5168845432830604,29.498015531546052,4.7488887284787298,1.8,0.24,73.062204768239909,9.5168845432830604,29.498015531546052,4.7488887284787298,1.8,0.24,73.062204768239909,9.5168845432830604,29.498015531546052,4.7488887284787298,1.8,0.24,null,300,10.14883,10.14883,0.80305099999999996,0.80305099999999996,10.14883,10.14883,0.80305099999999996,0.80305099999999996]
[10,125,200,73.062204768239909,9.5168845432830604,29.498015531546052,4.7488887284787298,1.8,0.24,73.062204768239909,9.5168845432830604,29.498015531546052,4.7488887284787298,1.8,0.24,73.062204768239909,9.5168845432830604,29.498015531546052,4.7488887284787298,1.8,0.24,null,201,6.1031464899999994,6.1031464899999994,-9.2251900000000012E-3,-9.2251900000000012E-3,6.1031464899999994,6.1031464899999994,-9.2251900000000012E-3,-9.2251900000000012E-3]
[11,150,0,80.124024604020462,9.0509317905563798,31.47868198135221,4.76178503023438,2.02,0.24,80.124024604020462,9.0509317905563798,31.47868198135221,4.76178503023438,2.02,0.24,80.124024604020462,9.0509317905563798,31.47868198135221,4.76178503023438,2.02,0.24,null,200,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2]
[12,150,200,80.124024604020462,9.0509317905563798,31.47868198135221,4.76178503023438,2.02,0.24,80.124024604020462,9.0509317905563798,31.47868198135221,4.76178503023438,2.02,0.24,80.124024604020462,9.0509317905563798,31.47868198135221,4.76178503023438,2.02,0.24,null,199,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2]

{"sheet":"Dynamic (3)","index":12,"n_rows":32,"n_cols":31,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,11,17,12],[17,13,17,14],[1,10,1,20],[2,1,2,2],[3,1,3,2],[4,1,4,2],[12,17,12,18],[2,10,2,20],[6,0,6,3],[7,2,7,3],[13,5,13,6],[8,2,8,3],[9,2,9,3],[17,19,17,20],[15,23,15,30],[16,27,16,30],[17,27,17,28],[17,29,17,30],[16,23,16,26],[17,23,17,24],[17,25,17,26],[1,23,1,30],[2,23,2,30],[3,23,3,30],[17,3,17,4],[17,5,17,6],[17,7,17,8],[11,0,11,3],[17,9,17,10],[16,3,16,8],[16,9,16,14],[6,22,6,24],[16,15,16,20],[13,17,13,18],[12,5,12,6],[17,15,17,16],[17,17,17,18]]}
["Dynamic Analysis",null,null,null,null,null,null,null,null,"Notes on Body and Wheelset movements",null,null,null,null,null,null,null,null,null,null,null,null,"Notes on Wheelset Movements"]
[null,null,null,null,null,null,null,null,null,1,"Body and wheelset movements refer to the movement due to speed and cant on tangent track.",null,null,null,null,null,null,null,null,null,null,null,1,"Bogie 2 curving movements are only required if they differ from bogie 1."]
["Condition","Case 3",null,null,null,null,null,null,null,{"$f":"+J2+1","v":2},"Movements at Vehicle Centre and Bogie 2 need only be provided when the analysis of vehicle roll and pitch is required.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W2+1","v":2},"Where only Bogie movements are available, these values should be entered for both leading and trailing values."]
["Track Quality","Limit State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W3+1","v":3},"Curving movements are the offset to the outside or inside resulting from curvature without applied cant."]
["Wind","0 m/s"]
[]
["Sign Convention",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sign Convention"]
["Lateral","+ve","Outside",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheels","+ve","Outside"]
["Vertical","+ve","Down"]
["Roll","+ve","Outside"]
[]
["Dimensions"]
["Datum Height",{"$f":"+'Dynamic (2)'!B13","v":1300},"mm","ARL",null,"Bogie 1 Load",null,null,"kg",null,null,null,null,null,null,null,null,"Bogie 2 Load",null,{"$f":"+H13","v":0},"kg"]
["Bogie Centres",{"$f":"+General!B23","v":17000},"mm",null,null,"Primary Stiffness",null,{"$f":"+'Dynamic (1)'!H14","v":0},"N/mm",null,null,null,null,null,null,null,null,"Primary Stiffness",null,{"$f":"+H14","v":0},"N/mm"]
["Track Gauge",{"$f":"+General!B25","v":1435},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheelset Lateral Movements"]
[null,null,null,"Wheelsets and Body at Bogie 1",null,null,null,null,null,"Wheelsets and Body at Vehicle Centre",null,null,null,null,null,"Wheelsets and Body at Bogie 2",null,null,null,null,null,null,null,"Curving Bogie 1",null,null,null,"Curving Bogie 2"]
[null,"Cant","Speed","Lateral avg",null,"Vertical avg",null,"Roll avg",null,"Lateral avg",null,"Vertical avg",null,"Roll avg",null,"Lateral avg",null,"Vertical avg",null,"Roll avg",null,null,null,"New profile",null,"Worn profile",null,"New profile",null,"Worn profile"]
[null,null,null,"Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD","Mean","SD",null,"Curve","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing","Avg Leading","Avg Trailing"]
["Reference","mm","km/h","mm","mm","mm","mm","deg","deg","mm","mm","mm","mm","deg","deg","mm","mm","mm","mm","deg","deg",null,"m","mm","mm","mm","mm","mm","mm","mm","mm"]
[1,0,0,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,null,2001,0,0,0,0,0,0,0,0]
[2,0,200,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,null,2000,0,0,0,0,0,0,0,0]
[3,50,0,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,null,1999,9.0939619999999988E-3,9.0939619999999988E-3,1.643622E-3,1.643622E-3,9.0939619999999988E-3,9.0939619999999988E-3,1.643622E-3,1.643622E-3]
[4,50,200,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,26.953180574695089,8.1286884081626898,62.441720843117992,4.7283610068358497,0.42,0.14000000000000001,null,1000,9.0939619999999994,9.0939619999999994,1.6436219999999999,1.6436219999999999,9.0939619999999994,9.0939619999999994,1.6436219999999999,1.6436219999999999]
[5,75,0,38.60709169268069,8.7023152393015604,62.46451969439272,4.7356181754465903,0.6,0.14000000000000001,38.60709169268069,8.7023152393015604,62.46451969439272,4.7356181754465903,0.6,0.14000000000000001,38.60709169268069,8.7023152393015604,62.46451969439272,4.7356181754465903,0.6,0.14000000000000001,null,800,11.03158,11.03158,1.8997170000000001,1.8997170000000001,11.03158,11.03158,1.8997170000000001,1.8997170000000001]
[6,75,200,38.60709169268069,8.7023152393015604,62.46451969439272,4.7356181754465903,0.6,0.14000000000000001,38.60709169268069,8.7023152393015604,62.46451969439272,4.7356181754465903,0.6,0.14000000000000001,38.60709169268069,8.7023152393015604,62.46451969439272,4.7356181754465903,0.6,0.14000000000000001,null,600,12.418620000000001,12.418620000000001,1.9346239999999999,1.9346239999999999,12.418620000000001,12.418620000000001,1.9346239999999999,1.9346239999999999]
[7,100,0,48.866337144394137,9.4621051205688094,62.666618490688727,4.7390744513054104,0.76,0.14000000000000001,48.866337144394137,9.4621051205688094,62.666618490688727,4.7390744513054104,0.76,0.14000000000000001,48.866337144394137,9.4621051205688094,62.666618490688727,4.7390744513054104,0.76,0.14000000000000001,null,500,12.591010000000001,12.591010000000001,1.783561,1.783561,12.591010000000001,12.591010000000001,1.783561,1.783561]
[8,100,200,48.866337144394137,9.4621051205688094,62.666618490688727,4.7390744513054104,0.76,0.14000000000000001,48.866337144394137,9.4621051205688094,62.666618490688727,4.7390744513054104,0.76,0.14000000000000001,48.866337144394137,9.4621051205688094,62.666618490688727,4.7390744513054104,0.76,0.14000000000000001,null,400,12.03265,12.03265,1.4346650000000001,1.4346650000000001,12.03265,12.03265,1.4346650000000001,1.4346650000000001]
[9,125,0,57.740204768239906,9.5168845432830604,64.122543513312877,4.7488887284787298,0.88,0.14000000000000001,57.740204768239906,9.5168845432830604,64.122543513312877,4.7488887284787298,0.88,0.14000000000000001,57.740204768239906,9.5168845432830604,64.122543513312877,4.7488887284787298,0.88,0.14000000000000001,null,300,10.14883,10.14883,0.80305099999999996,0.80305099999999996,10.14883,10.14883,0.80305099999999996,0.80305099999999996]
[10,125,200,57.740204768239906,9.5168845432830604,64.122543513312877,4.7488887284787298,0.88,0.14000000000000001,57.740204768239906,9.5168845432830604,64.122543513312877,4.7488887284787298,0.88,0.14000000000000001,57.740204768239906,9.5168845432830604,64.122543513312877,4.7488887284787298,0.88,0.14000000000000001,null,201,6.1031464899999994,6.1031464899999994,-9.2251900000000012E-3,-9.2251900000000012E-3,6.1031464899999994,6.1031464899999994,-9.2251900000000012E-3,-9.2251900000000012E-3]
[11,150,0,64.520024604020477,9.0509317905563798,65.705492480698069,4.76178503023438,1,0.12,64.520024604020477,9.0509317905563798,65.705492480698069,4.76178503023438,1,0.12,64.520024604020477,9.0509317905563798,65.705492480698069,4.76178503023438,1,0.12,null,200,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2]
[12,150,200,64.520024604020477,9.0509317905563798,65.705492480698069,4.76178503023438,1,0.12,64.520024604020477,9.0509317905563798,65.705492480698069,4.76178503023438,1,0.12,64.520024604020477,9.0509317905563798,65.705492480698069,4.76178503023438,1,0.12,null,199,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2,6.0622809999999996,6.0622809999999996,-1.7430000000000001E-2,-1.7430000000000001E-2]

{"sheet":"Tolerances","index":13,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,0,8,12],[2,0,2,2],[2,4,2,5]]}
["Tolerances"]
[]
["Sign Convention",null,null,null,"Code"]
[null,{"$f":"\"+ve\"","v":"+ve"},{"$f":"\"-ve\"","v":"-ve"},null,"L","Lateral"]
["Lateral (L)","Wider","Narrower",null,"V","Vertical"]
["Vertical (V)","Upwards","Downwards",null,"R","Roll"]
["Roll (R)","Wider","Narrower"]
[]
["Condition and Position Related Tolerances and Allowances"]
["Parameter","Units","Min","Max","Mean","SD","Distribution","Direction","L At ARL","Bogie","Dyn1","Dyn2","Dyn3"]
["Uncompensated Radial Wheel Wear","mm",-6,0,null,null,"Linear","V",null,false,false,true,true]
["Primary Creep","mm",-6,0,null,null,"Linear","V",null,false,true,true,true]
["Secondary Creep","mm",-2,0,null,null,"Linear","V",null,false,false,false,true]
["Height Setting","mm",-3,3,null,null,"Normal","V",null,false,true,true,false]