{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Introduction","Instructions","Notes","General","Cross Section (0)","Centre","End","Layers","Overthrows","Dynamics","Tolerances"],"not_rendered":{"charts":3,"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":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,3,1,8],[7,3,7,5],[10,3,10,6],[11,3,11,5],[14,3,17,5]]}
[]
[null,null,null,"8073SVGD - LG2  "]
[null,null,null,"Issue",4]
[null,null,null,"Date","December 2020"]
[]
[]
[]
[null,null,null,"Standard Vehicle Gauge data - LG2"]
[]
[]
[null,null,null,"Synopsis"]
[null,null,null,"This workbook sets out the movements of the established suspensions associated with locomotive gauge LG2."]
[]
[]
[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":[[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],[0,0,0,7],[5,0,5,7],[6,0,6,7],[3,3,3,6],[2,3,2,6]]}
["Issue Record"]
[]
["Issue","Issue date","Template Version","Comments"]
["4","December  2020",8,"First issue to align with GERT8073 issue 4"]
[]
["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 LG2.  \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 established suspensions associated with the LG2.\n\nTo comply with the requirements for LG2, 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 LG2, 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. "]
[]
["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":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,12,1,14],[18,2,18,8],[19,2,19,8],[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",8,"(Workbook template version)"]
[null,null,null,null,null,null,null,null,null,null,"Date","2020-12-05"]
[]
[]
[]
[null,"Reference",{"$f":"IF(General!B4<>\"\",+General!B4,\"\")","v":"LG2"}]
[]
[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, Overthrows and Tolerances worksheets."]
[null,5,"The workbook includes five 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."]
[null,9,"The notes tab should be used to record any information that may be necessary to clarify information provided, for the benefit of those constructing the vehicle gauging model."]

{"sheet":"Notes","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,0,3,3],[4,1,4,3],[13,1,13,3],[11,1,11,3],[12,1,12,3],[9,1,9,3],[10,1,10,3],[7,1,7,3],[8,1,8,3],[5,1,5,3],[6,1,6,3]]}
["Notes","Version",8]
[null,"Date","2015-03-07"]
[]
["Notes"]
[1,"Dynamic movements encapsulate ' worst case' of locomotives available for T995 analysis"]
[2,"Wheelset movement tables encapsulate 'worst case' of locomotives available for T995 assessment (Class 67, Class 70, Class 90, Class 91)"]
[3,"Dynamic movements locked in for 0 - 50mm Cant Deficiency"]
[4,"No additional vehicle tolerances applied"]
[5,"Nominal bogie geometry and axle spacing derived to generate worst case central overthrow largest of locomotives available for T995 analysis"]
[6,"Proposed to set-up vehicle as twin axle bogie with central cross section (0.00 m) and end cross section (10.34 m)"]
[7]
[8,"Height dynamically capped to 3990 mm ARL on a +/- 500 m vertical curve by KE Template"]
[9,"Width reduced by Type A & Type D passing clearance analysis to vehicles listed in T995 report."]
[10]

{"sheet":"General","index":4,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,0,8,12],[9,1,9,12],[20,4,23,5],[19,0,19,2],[32,0,32,3],[27,0,27,2],[16,2,16,3],[16,4,16,5],[16,0,16,1],[41,1,41,3],[42,1,42,3],[44,1,44,3],[35,0,35,3],[36,1,36,3],[37,1,37,3],[43,1,43,3],[38,1,38,3],[39,1,39,3],[40,1,40,3]]}
["General Data","Version",8]
[null,"Date","2015-03-07"]
["Vehicle","2018 Locomotive Gauge"]
["Document Ref","LG2"]
["Issue",1,"Date","2019-07-05"]
["Input by","Ryan Wareing"]
["Checked by","Neil Barker"]
[]
["Worksheet Index"]
["Type","Worksheet Name(s)"]
["Cross Sections","Centre","End"]
["Layers","Layers"]
["Overthrows","Overthrows"]
["Dynamics","Dynamics"]
["Tolerances","Tolerances"]
[]
["Dynamic Tables",null,"Maximum Speed",null,"Maximum Cant"]
["Dyn1","Dynamics",225,"km/h",150,"mm"]
[]
["Bogies"]
["Bogie Centres",13260,"mm",null,"Values for example only, to illustrate overthrow formulae"]
["Bogie Wheelbase",4200,"mm"]
["Track Gauge",1435,"mm"]
["Wheelset Front - Front",1419,"mm"]
["Bogie 1 Type","N/A"]
["Bogie 2 Type","N/A"]
[]
["Datum Points"]
["Cantrail height",3300,"mm"]
["Waist height",2000,"mm"]
["Solebar height",1100,"mm"]
[]
["Drawing Numbers"]
["Type","Number","Issue","Date"]
[]
["Notes"]
[1,"Dynamic movements encapsulate ' worst case' of locomotives available for T995 analysis"]
[2,"Wheelset movement tables encapsulate 'worst case' of locomotives available for T995 assessment (Class 67, Class 70, Class 90, Class 91)"]
[3,"Dynamic movements locked in for 0 - 50mm Cant Deficiency"]
[4,"No additional vehicle tolerances applied"]
[5,"Nominal bogie geometry and axle spacing derived to generate worst case central overthrow largest of locomotives available for T995 analysis"]
[6,"Proposed to set-up vehicle as twin axle bogie with central cross section (0.00 m) and end cross section (10.34 m)"]
[7]
[8,"Height dynamically capped to 3990 mm ARL on a +/- 500 m vertical curve by KE Template"]
[9,"Width reduced by Type A & Type D passing clearance analysis to vehicles listed in T995 report."]

{"sheet":"Cross Section (0)","index":5,"n_rows":108,"n_cols":8,"rows_kept":108,"cut":false,"hidden":true,"merged":[[42,6,42,8],[43,6,43,8],[44,6,44,8],[3,1,3,4],[0,6,0,14],[1,7,1,14],[2,7,2,14],[40,6,40,8],[41,6,41,8]]}
["Cross Section",null,"Version",8,null,null,"Notes on Cross Sections"]
[null,null,"Date","2015-03-07",null,null,1,"Distance relates to the longitudinal centre of the vehicle"]
["Distance",null,"mm",null,null,null,{"$f":"+G2+1","v":2},"Positive Distances are towards bogie 1, negative distances are towards bogie 2"]
["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,"List of Standard Features"]
[null,null,true,true,null,null,"Step"]
[null,null,true,true,null,null,"Indicator Light"]
[null,null,true,true,null,null,"Cantrail"]
[null,null,true,true,null,null,"Waist"]
[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":"Centre","index":6,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,1,3,4],[44,6,44,8],[0,6,0,14],[1,7,1,14],[2,7,2,14],[40,6,40,8],[41,6,41,8],[42,6,42,8],[43,6,43,8]]}
["Cross Section",null,"Version",8,null,null,"Notes on Cross Sections"]
[null,null,"Date","2015-03-07",null,null,1,"Distance relates to the longitudinal centre of the vehicle"]
["Distance",0,"mm",null,null,null,{"$f":"+G2+1","v":2},"Positive Distances are towards bogie 1, negative distances are towards bogie 2"]
["Name","Centre"]
["Bogie",false]
[]
["x","y","Join","Critical","Feature"]
["mm","mm"]
[0,3968.8,false,true]
[-68.097999999999999,3968.8,true,true]
[-192,3961,true,true]
[-524.74300000000005,3876.7109999999998,true,true]
[-741.51899999999898,3783.0039999999999,true,true]
[-797.34399999999903,3765.9209999999998,true,true]
[-1020.317,3650.16,true,true]
[-1078.9770000000001,3604.7449999999999,true,true]
[-1162.6199999999999,3548.2510000000002,true,true]
[-1199.345,3507.799,true,true]
[-1285.3,3408.4,true,true]
[-1327.8320000000001,3353.9929999999999,true,true]
[-1370.8769130027199,3267.53226155528,true,true]
[-1400.49919288361,2000.08922416053,true,true]
[-1413.0158460953901,1098.91422296418,true,true]
[-1370.634,1074.248,true,true]
[-1349.1369999999999,1068.3209999999999,true,true]
[-1238.047,1017.7,true,true]
[-1214.086,1003.568,true,true]
[-1201.06,949.70899999999995,true,true]
[0,949.70899999999995,true,true]
[1201.06,949.70899999999995,true,true]
[1214.086,1003.568,true,true]
[1238.047,1017.7,true,true]
[1349.1369999999999,1068.3209999999999,true,true]
[1370.634,1074.248,true,true]
[1413.0158460953901,1098.91422296418,true,true]
[1400.49919288361,2000.08922416053,true,true]
[1370.8769130027199,3267.53226155528,true,true]
[1327.8320000000001,3353.9929999999999,true,true]
[1285.3,3408.4,true,true]
[1199.345,3507.799,true,true]
[1162.6199999999999,3548.2510000000002,true,true,null,null,"List of Standard Features"]
[1078.9770000000001,3604.7449999999999,true,true,null,null,"Step"]
[1020.317,3650.16,true,true,null,null,"Indicator Light"]
[797.34399999999903,3765.9209999999998,true,true,null,null,"Cantrail"]
[741.51899999999898,3783.0039999999999,true,true,null,null,"Waist"]
[524.74300000000005,3876.7109999999998,true,true]
[192,3961,true,true]
[68.097999999999999,3968.8,true,true]
[0,3968.8,true,true]

{"sheet":"End","index":7,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,1,3,4],[44,6,44,8],[0,6,0,14],[1,7,1,14],[2,7,2,14],[40,6,40,8],[41,6,41,8],[42,6,42,8],[43,6,43,8]]}
["Cross Section",null,"Version",8,null,null,"Notes on Cross Sections"]
[null,null,"Date","2015-03-07",null,null,1,"Distance relates to the longitudinal centre of the vehicle"]
["Distance",9836,"mm",null,null,null,{"$f":"+G2+1","v":2},"Positive Distances are towards bogie 1, negative distances are towards bogie 2"]
["Name","End"]
["Bogie",false]
[]
["x","y","Join","Critical","Feature"]
["mm","mm"]
[0,3968.8,false,true]
[-68.097999999999999,3968.8,true,true]
[-192,3961,true,true]
[-524.74300000000005,3876.7109999999998,true,true]
[-741.51899999999898,3783.0039999999999,true,true]
[-797.34399999999903,3765.9209999999998,true,true]
[-1020.317,3650.16,true,true]
[-1078.9770000000001,3604.7449999999999,true,true]
[-1162.6199999999999,3548.2510000000002,true,true]
[-1199.345,3507.799,true,true]
[-1285.3,3408.4,true,true]
[-1327.8320000000001,3353.9929999999999,true,true]
[-1370.8769130027199,3267.53226155528,true,true]
[-1400.49919288361,2000.08922416053,true,true]
[-1413.0158460953901,1098.91422296418,true,true]
[-1370.634,1074.248,true,true]
[-1349.1369999999999,1068.3209999999999,true,true]
[-1238.047,1017.7,true,true]
[-1214.086,1003.568,true,true]
[-1201.06,949.70899999999995,true,true]
[0,949.70899999999995,true,true]
[1201.06,949.70899999999995,true,true]
[1214.086,1003.568,true,true]
[1238.047,1017.7,true,true]
[1349.1369999999999,1068.3209999999999,true,true]
[1370.634,1074.248,true,true]
[1413.0158460953901,1098.91422296418,true,true]
[1400.49919288361,2000.08922416053,true,true]
[1370.8769130027199,3267.53226155528,true,true]
[1327.8320000000001,3353.9929999999999,true,true]
[1285.3,3408.4,true,true]
[1199.345,3507.799,true,true]
[1162.6199999999999,3548.2510000000002,true,true,null,null,"List of Standard Features"]
[1078.9770000000001,3604.7449999999999,true,true,null,null,"Step"]
[1020.317,3650.16,true,true,null,null,"Indicator Light"]
[797.34399999999903,3765.9209999999998,true,true,null,null,"Cantrail"]
[741.51899999999898,3783.0039999999999,true,true,null,null,"Waist"]
[524.74300000000005,3876.7109999999998,true,true]
[192,3961,true,true]
[68.097999999999999,3968.8,true,true]
[0,3968.8,true,true]

{"sheet":"Layers","index":8,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,4,1,9],[6,4,6,8]]}
["Layers","Version",8]
[null,"Date","2015-03-07",null,"Sign Convention"]
[null,null,null,null,"Camber","+ve","Up","Distance","+ve","To Front (Bogie 1)"]
[null,null,null,null,"Sag","-ve","Down","Distance","+ve","To Rear (Bogie 2)"]
[]
[]
[null,null,null,null,"Camber (+ve) or Sag (-ve)"]
["Number","Name","Distance","Bogie","Dyn1"]
[null,null,"mm",null,"mm"]
[1,{"$f":"+Centre!$B$4:$E$4","v":"Centre"},{"$f":"+Centre!$B$3","v":0},{"$f":"+Centre!$B$5","v":false},0]
[{"$f":"+A10+1","v":2},{"$f":"+End!$B$4:$E$4","v":"End"},{"$f":"+End!$B$3","v":9836},{"$f":"+End!$B$5","v":false},0]

{"sheet":"Overthrows","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,3,8,4],[8,6,8,7],[8,8,8,9],[0,6,0,13],[4,7,4,13],[5,7,5,13],[1,7,1,13],[2,7,2,13],[3,7,3,13]]}
["Overthrows","Version",8,null,null,null,"Notes on Overthrows"]
[null,"Date","2015-03-07",null,null,null,1,"+ve Overthrows are towards the outside of a curve (end throw)"]
["Bogie Centres",{"$f":"+General!B21","v":13260},"mm",null,null,null,{"$f":"+G2+1","v":2},"-ve Overthrows are towards the centre of a curve (centre throw)"]
["Axle Spacing",{"$f":"+General!B22","v":4200},"mm",null,null,null,3,"Bogie overthrows should be added if not included in the cross section dimensions"]
["Semi Width",1410,"mm",null,null,null,4,"Overthrow calculation formulae relate to a standard, bogied vehicle"]
["Height",3921.8,"mm",null,null,null,5,"Semi Width and Height refer to the nominal dimensions for the calculation of delta"]
[]
["Lateral",null,null,null,null,null,"Vertical"]
["Section",{"$f":"+Centre!$B$4","v":"Centre"},null,{"$f":"+End!$B$4","v":"End"},null,null,{"$f":"+B9","v":"Centre"},null,{"$f":"+D9","v":"End"}]
["Section Dist",{"$f":"+Centre!$B$3","v":0},"mm",{"$f":"+End!$B$3","v":9836},"mm",null,{"$f":"+Centre!$B$3","v":0},"mm",{"$f":"+End!$B$3","v":9836},"mm"]
["Curve","C/L","Delta","C/L","Delta",null,"C/L","Delta","C/L","Delta"]
["m","mm","mm","mm","mm",null,"mm","mm","mm","mm"]

{"sheet":"Dynamics","index":10,"n_rows":39,"n_cols":31,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,2],[0,22,0,30],[0,9,0,20],[17,23,17,24],[17,25,17,26],[17,17,17,18],[17,19,17,20],[16,27,16,30],[17,27,17,28],[17,29,17,30],[16,15,16,20],[6,22,6,24],[17,13,17,14],[17,15,17,16],[12,17,12,18],[13,17,13,18],[3,1,3,2],[4,1,4,2],[12,5,12,6],[13,5,13,6],[8,2,8,3],[9,2,9,3],[11,0,11,3],[6,0,6,3],[7,2,7,3],[16,3,16,8],[16,9,16,14],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[16,23,16,26],[2,10,2,20],[1,10,1,20],[2,23,2,30],[1,23,1,30],[3,23,3,30],[15,23,15,30]]}
["Dynamic Analysis","Version",8,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,"Date","2015-03-07",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","Dynamics",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",1260,"mm","ARL",null,"Bogie 1 Load",null,0,"kg",null,null,null,null,null,null,null,null,"Bogie 2 Load",null,{"$f":"+H13","v":0},"kg"]
["Bogie Centres",14300,"mm",null,null,"Primary Stiffness",null,0,"N/mm",null,null,null,null,null,null,null,null,"Primary Stiffness",null,{"$f":"+H14","v":0},"N/mm"]
["Track Gauge",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 (Front)",null,null,null,null,null,"Wheelsets and Body at Vehicle Centre",null,null,null,null,null,"Wheelsets and Body at Bogie 2 (Rear)",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"]
[null,0,0,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,null,89,0.8,0.8,0.4,0.4,0.8,0.8,0.4,0.4]
[null,0,225,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,null,90,0.8,0.8,0.4,0.4,0.8,0.8,0.4,0.4]
[null,50,0,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,null,100,0.7,0.7,0.4,0.4,0.7,0.7,0.4,0.4]
[null,50,225,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,10,11.7,0,6.7,0.2,0.3,null,150,0.8,0.8,0.4,0.4,0.8,0.8,0.4,0.4]
[null,75,0,18,11.9,0.1,6.7,0.5,0.2,18,11.9,0.1,6.7,0.5,0.2,18,11.9,0.1,6.7,0.5,0.2,null,200,2.1,2.1,0.4,0.4,2.1,2.1,0.4,0.4]
[null,75,225,18,11.9,0.1,6.7,0.5,0.2,18,11.9,0.1,6.7,0.5,0.2,18,11.9,0.1,6.7,0.5,0.2,null,250,3.7,3.7,0.4,0.4,3.7,3.7,0.4,0.4]
[null,100,0,25.5,12.4,0.2,6.7,0.6,0.2,25.5,12.4,0.2,6.7,0.6,0.2,25.5,12.4,0.2,6.7,0.6,0.2,null,300,4.5999999999999996,4.5999999999999996,0.5,0.5,4.5999999999999996,4.5999999999999996,0.5,0.5]
[null,100,225,25.5,12.4,0.2,6.7,0.6,0.2,25.5,12.4,0.2,6.7,0.6,0.2,25.5,12.4,0.2,6.7,0.6,0.2,null,400,5.3,5.3,0.6,0.6,5.3,5.3,0.6,0.6]
[null,125,0,33.799999999999997,12.4,0.2,6.7,0.7,0.2,33.799999999999997,12.4,0.2,6.7,0.7,0.2,33.799999999999997,12.4,0.2,6.7,0.7,0.2,null,450,5.5,5.5,1.5,1.5,5.5,5.5,1.5,1.5]
[null,125,225,33.799999999999997,12.4,0.2,6.7,0.7,0.2,33.799999999999997,12.4,0.2,6.7,0.7,0.2,33.799999999999997,12.4,0.2,6.7,0.7,0.2,null,500,5.6,5.6,2.2999999999999998,2.2999999999999998,5.6,5.6,2.2999999999999998,2.2999999999999998]
[null,150,0,39,13.5,0.3,6.8,0.8,0.25,39,13.5,0.3,6.8,0.8,0.25,39,13.5,0.3,6.8,0.8,0.25,null,700,6.4,6.4,4,4,6.4,6.4,4,4]
[null,150,225,39,13.5,0.3,6.8,0.8,0.25,39,13.5,0.3,6.8,0.8,0.25,39,13.5,0.3,6.8,0.8,0.25,null,1000,6.9,6.9,5.0999999999999996,5.0999999999999996,6.9,6.9,5.0999999999999996,5.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500,7.3,7.3,6,6,7.3,7.3,6,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000,7.5,7.5,4.5,4.5,7.5,7.5,4.5,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3000,7.6,7.6,1.8,1.8,7.6,7.6,1.8,1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8000,5.0999999999999996,5.0999999999999996,0.3,0.3,5.0999999999999996,5.0999999999999996,0.3,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,2,2,0.2,0.2,2,2,0.2,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20001,2,2,-2,-2,2,2,-2,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20002,2,2,-2,-2,2,2,-2,-2]

{"sheet":"Tolerances","index":11,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,4,2,5],[8,0,8,11]]}
["Tolerances","Version",8]
[null,"Date","2015-03-07"]
["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","Dyn1","CS1","CS2"]