Scribd Logo
Upload

Welcome to Scribd!

  • 66 views

    Calculation of Train Resistance

    Uploaded by

    ttcbfb
    The document appears to be an excel sheet containing calculations for train resistance parameters like locomotive resistance, grade resistance, curvature resistance, and total train resistance for different train loads, speeds, gradients, locomotive weights, and curvatures. It also includes calculations for power required and current drawn from overhead electric lines for various scenarios. The data is presented in multiple tables with parameters like load, speed, gradient, etc. and corresponding resistance and current values.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Calculation of Train Resistance

    Uploaded by

    ttcbfb
    66 views5 pages
    The document appears to be an excel sheet containing calculations for train resistance parameters like locomotive resistance, grade resistance, curvature resistance, and total train resistance for different train loads, speeds, gradients, locomotive weights, and curvatures. It also includes calculations for power required and current drawn from overhead electric lines for various scenarios. The data is presented in multiple tables with parameters like load, speed, gradient, etc. and corresponding resistance and current values.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document appears to be an excel sheet containing calculations for train resistance parameters like locomotive resistance, grade resistance, curvature resistance, and total train resistance for different train loads, speeds, gradients, locomotive weights, and curvatures. It also includes calculations for power required and current drawn from overhead electric lines for various scenarios. The data is presented in multiple tables with parameters like load, speed, gradient, etc. and corresponding resistance and current values.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    66 views5 pages

    Calculation of Train Resistance

    Uploaded by

    ttcbfb
    The document appears to be an excel sheet containing calculations for train resistance parameters like locomotive resistance, grade resistance, curvature resistance, and total train resistance for different train loads, speeds, gradients, locomotive weights, and curvatures. It also includes calculations for power required and current drawn from overhead electric lines for various scenarios. The data is presented in multiple tables with parameters like load, speed, gradient, etc. and corresponding resistance and current values.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 5

    excel sheet for calculation of train

    WAG 5
    load speed gradient Loco Weight curvature train resistance T1
    4750.00 20.00 0.00 120.00 0.00 4192.42
    4750.00 40.00 400.00 120.00 0.00 5604.69
    4750.00 57.50 400.00 120.00 0.00 7068.70
    4750.00 54.00 360.00 120.00 0.00 6758.85
    4750.00 49.00 300.00 120.00 0.00 6331.00
    4750.00 30.00 200.00 120.00 0.00 4863.77
    4750.00 30.00 150.00 120.00 0.00 4863.77
    load speed gradient Loco Weight curvature train resistance T1
    4750.00 20.00 555555.00 120.00 2.00 4192.42
    4750.00 40.00 400.00 120.00 2.00 5604.69
    4750.00 57.50 400.00 120.00 2.00 7068.70
    4750.00 54.00 360.00 120.00 2.00 6758.85
    4750.00 49.00 300.00 120.00 2.00 6331.00
    4750.00 30.00 200.00 120.00 2.00 4863.77
    4750.00 100.00 150.00 120.00 2.00 11511.14
    load speed gradient Loco Weight curvature train resistance T1
    3300.00 85.50 400.00 120.00 0.00 6846.12
    3300.00 63.00 400.00 120.00 0.00 5261.11
    3300.00 75.00 400.00 120.00 0.00 6076.00
    3300.00 71.50 360.00 120.00 0.00 5831.14
    3300.00 66.00 300.00 120.00 0.00 5458.31
    3300.00 52.00 200.00 120.00 0.00 4575.28
    3300.00 42.00 150.00 120.00 0.00 4002.53
    3300.00 30.50 100.00 120.00 0.00 3403.63
    WAG 7 0.00
    load speed gradient Loco Weight curvature train resistance T1
    4700.00 0.00 200.00 123.00 2.00 18800.00
    4750.00 66.00 400.00 123.00 0.00 7856.66
    4750.00 56.50 300.00 123.00 0.00 6979.30
    4750.00 51.00 250.00 123.00 0.00 6500.05
    4750.00 44.00 200.00 123.00 0.00 5920.54
    4700.00 50.00 200.00 123.00 2.00 6347.65
    load speed gradient Loco Weight train resistance T1
    3300.00 96.50 0.00 123.00 0.00 7710.06
    3300.00 85.00 400.00 123.00 0.00 6808.24
    3300.00 75.50 300.00 123.00 0.00 6111.46
    3300.00 60.00 200.00 123.00 2.00 5068.27
    3300.00 49.50 150.00 123.00 0.00 4427.56
    3300.00 41.50 120.00 123.00 0.00 3975.17
    3300.00 36.00 100.00 123.00 0.00 3682.09
    3300.00 29.50 80.00 123.00 0.00 3354.57
    compesated gradient wrt curve

    gradient G curvature compesated


    S gradient
    200.00 2.00 172.41
    200.00 4.00 151.52
    100.00 2.00 92.59
    100.00 4.00 86.21
    100.00 6.00 80.65
    100.00 8.00 75.76
    100.00 10.00 71.43
    for calculation of train resistance
    loco resistance T2 grade resistanceT3 curvature resistanceT4 total train resistance power
    201.85 0.00 4394.27 325.50
    292.64 12175.00 0.00 18072.33 2677.38
    409.49 12175.00 0.00 19653.19 4185.40
    383.33 13527.78 0.00 20669.96 4133.99
    348.38 16233.33 0.00 22912.71 4158.23
    241.55 24350.00 0.00 29455.32 3272.81
    241.55 32466.67 0.00 37571.99 4174.67
    loco resistance T2 grade resistanceT3 curvature resistanceT4 total train resistance power
    201.85 8.77 3896.00 8299.04 614.74
    292.64 12175.00 3896.00 21968.33 3254.57
    409.49 12175.00 3896.00 23549.19 5015.11
    383.33 13527.78 3896.00 24565.96 4913.19
    348.38 16233.33 3896.00 26808.71 4865.28
    241.55 24350.00 3896.00 33351.32 3705.70
    838.62 32466.67 3896.00 48712.43 18041.64
    loco resistance T2 grade resistanceT3 curvature resistanceT4 total train resistance power
    669.07 8550.00 0.00 16065.19 5087.31
    453.43 8550.00 0.00 14264.54 3328.39
    561.26 8550.00 0.00 15187.25 4218.68
    528.11 9500.00 0.00 15859.24 4199.76
    478.85 11400.00 0.00 17337.16 4237.97
    369.01 17100.00 0.00 22044.28 4245.57
    304.23 22800.00 0.00 27106.76 4216.61
    243.83 34200.00 0.00 37847.46 4275.36
    #VALUE!
    loco resistance T2 grade resistanceT3 curvature resistanceT4 total train resistance power
    158.60 24115.00 3858.40 46932.00 0.00
    482.63 12182.50 0.00 20521.79 5016.44
    405.40 16243.33 0.00 23628.03 4944.38
    365.39 19492.00 0.00 26357.44 4978.63
    319.45 24365.00 0.00 30604.98 4987.48
    358.48 24115.00 3858.40 34679.53 6422.14
    loco resistance T2 grade resistanceT3 curvature resistanceT4 total train resistance power
    800.14 0.00 0.00 8510.20 3041.61
    667.97 8557.50 0.00 16033.71 5047.65
    570.16 11410.00 0.00 18091.62 5058.95
    432.66 17115.00 2738.40 25354.32 5634.29
    355.07 22820.00 0.00 27602.63 5060.48
    304.39 28525.00 0.00 32804.56 5042.18
    273.79 34230.00 0.00 38185.87 5091.45
    242.06 42787.50 0.00 46384.13 5067.90
    current drawn from ohe
    15.83
    130.24
    203.60
    201.09
    202.27
    159.20
    203.07
    current drawn from ohe
    29.90
    158.32
    243.96
    239.00
    236.67
    180.26
    877.62
    current drawn from ohe
    247.47
    161.91
    205.21
    204.29
    206.15
    206.52
    205.11
    207.97
    0.00
    current drawn from ohe
    0.00
    244.02
    240.52
    242.18
    242.61
    312.40
    current drawn from ohe
    147.96
    245.54
    246.09
    274.08
    246.16
    245.27
    247.67
    246.52

    You might also like