Calcul autoproiect EXCEL

download Calcul autoproiect EXCEL

of 39

description

Calculul de tractiune

Transcript of Calcul autoproiect EXCEL

  • = = = Pmax=0.469 2.092 1.561 184

    teoreticn= pas 237.5 P= M=

    750 30.37 38.69987.5 44.18 42.751225 59.26 46.23

    1462.5 75.18 49.121700 91.48 51.42

    1937.5 107.74 53.132175 123.51 54.26

    2412.5 138.37 54.802650 151.86 54.75

    2887.5 163.55 54.123125 173.01 52.90

    '= '= '= Pmax=0.531 1.938 1.469 184

    teoreticn= pas 62.5 P= M=

    3125 172.63 52.783187.5 174.69 52.37

    3250 176.56 51.913312.5 178.25 51.42

    3375 179.73 50.883437.5 181.00 50.31

    3500 182.06 49.703562.5 182.90 49.06

    3625 183.51 48.373687.5 183.88 47.65

    3750 184.00 46.88

    P1= np1= P2= np2=177 4000 179 4200

    M1 M2n= P1= P2= M1= M2= n/np P/Pmax P/Pmax

    800 30.43 28.87 36.35 34.48 0.20 0.17 0.161120 47.50 45.02 40.52 38.41 0.28 0.27 0.251440 66.15 62.76 43.90 41.65 0.36 0.37 0.35

  • 1760 85.61 81.39 46.48 44.19 0.44 0.48 0.452080 105.06 100.21 48.26 46.03 0.52 0.59 0.562400 123.71 118.52 49.25 47.19 0.60 0.70 0.662720 140.77 135.62 49.45 47.64 0.68 0.80 0.763040 155.42 150.82 48.85 47.41 0.76 0.88 0.843360 166.88 163.42 47.46 46.47 0.84 0.94 0.913680 174.34 172.72 45.27 44.85 0.92 0.98 0.964000 177.00 178.03 42.28 42.53 1.00 1.00 0.994200 179.00 40.72 1.00

    model 1

    500 1000 1500 2000 2500 3000 3500 4000 45000.00

    10.00

    20.00

    30.00

    40.00

    50.00

    60.00

    0.00

    20.00

    40.00

    60.00

    80.00

    100.00

    120.00

    140.00

    160.00

    180.00

    200.00

    MomentPutere

    Turaia[rot/min]

    Moment[daNm]

  • np= n= P= M=3750 750 30.37 38.69

    teoretic 988 44.18 42.75P/Pmax n/np 1225 59.26 46.23

    0.17 0.20 1463 75.18 49.120.24 0.26 1700 91.48 51.420.32 0.33 1938 107.74 53.130.41 0.39 2175 123.51 54.260.50 0.45 2413 138.37 54.800.59 0.52 2650 151.86 54.750.67 0.58 2888 163.55 54.120.75 0.64 3125 173.01 52.900.83 0.71 3188 174.69 52.370.89 0.77 3250 176.56 51.910.94 0.83 3313 178.25 51.42

    3375 179.73 50.883438 181.00 50.313500 182.06 49.703563 182.90 49.06

    np= 3625 183.51 48.373750 3688 183.88 47.65

    teoretic 3750 184.00 46.88P/Pmax n/np

    0.94 0.830.95 0.850.96 0.870.97 0.880.98 0.900.98 0.920.99 0.930.99 0.951.00 0.971.00 0.981.00 1.00

    M2n/np

    0.190.270.34

    0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00 1.100.00

    0.20

    0.40

    0.60

    0.80

    1.00

    1.20

    n/np

    P/Pmax

  • 0.420.500.570.650.720.800.880.951.00

    500 1000 1500 2000 2500 3000 3500 4000 45000.00

    10.00

    20.00

    30.00

    40.00

    50.00

    60.00

    0.00

    20.00

    40.00

    60.00

    80.00

    100.00

    120.00

    140.00

    160.00

    180.00

    200.00

    MomentPutere

    Turaia[rot/min]

    Moment[daNm]

    500 1000 1500 2000 2500 3000 3500 4000 45000.00

    10.00

    20.00

    30.00

    40.00

    50.00

    60.00

    0.00

    20.00

    40.00

    60.00

    80.00

    100.00

    120.00

    140.00

    160.00

    180.00

    200.00

    MomentPutere

    Turaia[rot/min]

    Moment[daNm]

  • P/Pmax n/np0.17 0.200.24 0.260.32 0.330.41 0.390.50 0.450.59 0.520.67 0.580.75 0.640.83 0.710.89 0.770.94 0.830.95 0.850.96 0.870.97 0.880.98 0.900.98 0.920.99 0.930.99 0.951.00 0.971.00 0.981.00 1.00

    0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00 1.100.00

    0.20

    0.40

    0.60

    0.80

    1.00

    1.20

    Model 1 Model 2 Model teoretic

    n/np

    P/Pmax

    0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00 1.100.00

    0.20

    0.40

    0.60

    0.80

    1.00

    1.20

    n/np

    P/Pmax

    500 1000 1500 2000 2500 3000 3500 4000 45000

    20

    40

    60

    80

    100

    120

    140

    160

    180

    200

    0

    10

    20

    30

    40

    50

    60

    70

    80

    90

    100

    Putere Moment

    n [rot/min]

    P [kW] M [daNm]

  • model 2

    500 1000 1500 2000 2500 3000 3500 4000 45000.00

    10.00

    20.00

    30.00

    40.00

    50.00

    60.00

    0.00

    20.00

    40.00

    60.00

    80.00

    100.00

    120.00

    140.00

    160.00

    180.00

    200.00

    MomentPutere

    Turaia[rot/min]

    Moment[daNm]

  • 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00 1.100.00

    0.20

    0.40

    0.60

    0.80

    1.00

    1.20

    Model 1 Model 2 Model teoretic

    n/np

    P/Pmax

    500 1000 1500 2000 2500 3000 3500 4000 45000

    20

    40

    60

    80

    100

    120

    140

    160

    180

    200

    0

    10

    20

    30

    40

    50

    60

    70

    80

    90

    100

    Putere Moment

    n [rot/min]

    P [kW] M [daNm]

  • 500 1000 1500 2000 2500 3000 3500 4000 45000.00

    10.00

    20.00

    30.00

    40.00

    50.00

    60.00

    0.00

    20.00

    40.00

    60.00

    80.00

    100.00

    120.00

    140.00

    160.00

    180.00

    200.00

    MomentPutere

    Turaia[rot/min]

    Moment[daNm]

  • 500 1000 1500 2000 2500 3000 3500 4000 45000

    20

    40

    60

    80

    100

    120

    140

    160

    180

    200

    0

    10

    20

    30

    40

    50

    60

    70

    80

    90

    100

    Putere Moment

    n [rot/min]

    P [kW] M [daNm]

  • Ca= Ce=1.17 0.67

    = = = '= '= '=0.46924 2.09183 1.56107 0.53076 1.93848 1.46924

  • M0=VW M1=Q7 M2=Cayenne

    Nr. crt. Pmax [kW] nP [rot/min] Mmax [Nm]nM [rot/min]M1 1 177 3800-4400 550 1750-2250

    2 175 3750 550 17503 163 3800 510 1600

    M2 4 179 4000-4400 550 2000-2250M0 5 152 3750-4750 400 1400-3500

    media

    Model1 1.13 0.752 1.20 0.603 1.20 0.594 1.17 0.655 1.09 0.826 1.22 0.567 1.16 0.688 1.20 0.609 1.20 0.60

    10 1.21 0.5811 1.21 0.5812 1.22 0.5713 1.20 0.6014 1.20 0.60

    Ca sx

    val medie 0.00380211 0.03731649381.19 0.0001779222

    0.00031984470.00014539720.00916847640.00096600890.00067324510.0001779222

    Ca Ce

  • 0.00017792220.00061887550.00061887550.00090032490.00017792220.0001779222

    Ce sxVal medie 0.0152084401 0.07463298760.626677 0.0007116888

    0.00127937880.00058158890.03667390560.00386403550.00269298030.00071168880.00071168880.00247550220.00247550220.00360129960.00071168880.0007116888

  • valori aleseca ce

    1.24 0.51 np=nmax nm ca ce1.27 0.47 3750 2500 1.17 0.6666671.29 0.421.24 0.51 nmed= nVmax=1.13 0.74 3125 3600

    1.24 0.53

    Pmax nP Mmax nM1 50 6400 93 48002 50 6000 93 36003 44 5500 95 32504 48 6300 105 41005 51 5500 99 45006 51 6200 94 35007 48 5600 90 38008 50 6000 93 36009 44 5500 94 3300

    10 44 5200 108 300011 44 5200 108 300012 50 6000 90 340013 51 6000 93 360014 50 6000 93 3600

    cvx ix xales

    3.144663 1.165119 1.191.208203

  • cvx ix xales11.90931 0.583593 0.63

    0.669762

  • nmin nmax,r750 3900 VW_m

  • V [km/h] f [-]0 0.01611 42.93 0.00 0.00 0.00

    10 0.01604 42.74 0.45 1.19 0.0120 0.01603 42.71 1.81 2.37 0.1030 0.01607 42.83 4.07 3.57 0.3440 0.01618 43.11 7.24 4.79 0.8050 0.01634 43.54 11.31 6.05 1.5760 0.01656 44.13 16.29 7.36 2.7270 0.01684 44.87 22.18 8.73 4.3180 0.01718 45.77 28.96 10.17 6.4490 0.01757 46.83 36.66 11.71 9.16100 0.01803 48.04 45.26 13.34 12.57110 0.01854 49.40 54.76 15.09 16.73120 0.01911 50.92 65.17 16.97 21.72130 0.01974 52.60 76.48 18.99 27.62140 0.02042 54.43 88.70 21.17 34.50150 0.02117 56.42 101.83 23.51 42.43160 0.02197 58.56 115.86 26.03 51.49170 0.02283 60.85 130.79 28.74 61.76180 0.02375 63.31 146.63 31.65 73.32190 0.02473 65.91 163.38 34.79 86.23200 0.02577 68.68 181.03 38.15 100.57210 0.02687 71.60 199.58 41.76 116.42215 0.02744 73.11 209.20 43.67 124.94220 0.02802 74.67 219.04 45.63 133.86225 0.02862 76.27 229.11 47.67 143.20

    f0= f01= f02=0.01611 -0.000010002 2.9152E-007

    Rrul [daN] Ra [daN] Prul [kW] Pa [kW]

    0 50 100 150 200 2500

    50

    100

    150

    200

    250

    300

    RrulRaRtot

    V[km/h]

    R[daN]

  • 0 50 100 150 200 2500

    50

    100

    150

    200

    250

    300

    RrulRaRtot

    V[km/h]

    R[daN]

    0 20 40 60 80 100 120 140 160 180 200 2200

    20

    40

    60

    80

    100

    120

    140

    160

    180

    PrulPaPtotal

    V[km/h]

    P[kW]

  • R P Cos p= Ga= k=42.93 0.00 1 2665 0.0220543.20 1.2044.52 2.4746.91 3.9150.35 5.5954.86 7.6260.42 10.0767.05 13.0474.74 16.6183.49 20.8793.29 25.91104.16 31.83116.09 38.70129.08 46.61143.13 55.66158.24 65.93174.41 77.52191.65 90.50209.94 104.97229.29 121.02249.71 138.73271.18 158.19282.31 168.60293.71 179.49305.38 190.86

    0 50 100 150 200 2500

    50

    100

    150

    200

    250

    300

    RrulRaRtot

    V[km/h]

    R[daN]

  • 0 50 100 150 200 2500

    50

    100

    150

    200

    250

    300

    RrulRaRtot

    V[km/h]

    R[daN]

    0 20 40 60 80 100 120 140 160 180 200 2200

    20

    40

    60

    80

    100

    120

    140

    160

    180

    PrulPaPtotal

    V[km/h]

    P[kW]

  • A= V [km/h] f [-]2.66 0 0.01611 42.7966540906

    10 0.016039132 42.608391317120 0.016026568 42.575014708630 0.016072308 42.696524265340 0.016176352 42.972919987150 0.0163387 43.40420187460 0.016559352 43.990369926170 0.016838308 44.731424143280 0.017175568 45.627364525590 0.017571132 46.6781910729100 0.018025 47.8839037855110 0.018537172 49.2445026631120 0.019107648 50.7599877059130 0.019736428 52.4303589138140 0.020423512 54.2556162868150 0.0211689 56.2357598249160 0.021972592 58.3707895282

    Rrul [daN]

    0 20 40 60 80 100 120 140 160 1800

    50

    100

    150

    200

    250

    300

    350

    400

    450

    Rrul(V)Ra(V)Rp(V)Rtot

    V[km/h]

    R[daN]

    0 20 40 60 80 100 120 140 160 1800

    20406080

    100120140160180200

    Prul(V)Pa(V)Pp(V)Ptot(V)

    V[km/h]

    P[kW]

  • 0 20 40 60 80 100 120 140 160 1800

    20406080

    100120140160180200

    Prul(V)Pa(V)Pp(V)Ptot(V)

    V[km/h]

    P[kW]

  • PANTAR

    0 212.3392080885 0 0 0 255.13586217910.451176923 212.3392080885 1.1835664255 0.0125326923 5.8983113358 255.39877632861.804707692 212.3392080885 2.3652785949 0.1002615385 11.7966226716 256.71893048944.060592308 212.3392080885 3.5580436888 0.3383826923 17.6949340074 259.09632466157.218830769 212.3392080885 4.7747688875 0.8020923077 23.5932453432 262.530958844811.27942308 212.3392080885 6.0283613714 1.5665865385 29.491556679 267.022833039516.24236923 212.3392080885 7.331728321 2.7070615385 35.3898680147 272.571947245322.10766923 212.3392080885 8.6977769167 4.2987134615 41.2881793505 279.178301462528.87532308 212.3392080885 10.139414339 6.4167384615 47.1864906863 286.841895690936.54533077 212.3392080885 11.6695477682 9.1363326923 53.0848020221 295.562729930745.11769231 212.3392080885 13.3010843848 12.5326923077 58.9831133579 305.340804181654.59240769 212.3392080885 15.0469313693 16.6810134615 64.8814246937 316.176118443964.96947692 212.3392080885 16.919995902 21.6564923077 70.7797360295 328.0686727174

    76.2489 212.3392080885 18.9331851633 27.534325 76.6780473653 341.018467002388.43067692 212.3392080885 21.0994063337 34.3897076923 82.5763587011 355.0255012983101.5148077 212.3392080885 23.4315665937 42.2978365385 88.4746700369 370.0897756057115.5012923 212.3392080885 25.9425731236 51.3339076923 94.3729813727 386.2112899243

    Ra [daN] Rp [daN] Prul [kW] Pa [kW] Pp [kW]

    0 20 40 60 80 100 120 140 160 1800

    50

    100

    150

    200

    250

    300

    350

    400

    450

    Rrul(V)Ra(V)Rp(V)Rtot

    V[km/h]

    R[daN]

    0 20 40 60 80 100 120 140 160 1800

    20406080

    100120140160180200

    Prul(V)Pa(V)Pp(V)Ptot(V)

    V[km/h]

    P[kW]

  • 0 20 40 60 80 100 120 140 160 1800

    20406080

    100120140160180200

    Prul(V)Pa(V)Pp(V)Ptot(V)

    V[km/h]

    P[kW]

  • P cos p=0 0.9968207 0.079677

    7.094410453614.26216280521.591360388529.170106538337.086504588845.428657874254.284669728863.742643486973.890682482784.816890050596.6093695245

    109.3562242391123.1455575286138.0654727271154.204073169

    171.6494621886

    sinp=

    0 20 40 60 80 100 120 140 160 1800

    50

    100

    150

    200

    250

    300

    350

    400

    450

    Rrul(V)Ra(V)Rp(V)Rtot

    V[km/h]

    R[daN]

    0 20 40 60 80 100 120 140 160 1800

    20406080

    100120140160180200

    Prul(V)Pa(V)Pp(V)Ptot(V)

    V[km/h]

    P[kW]

  • 0 20 40 60 80 100 120 140 160 1800

    20406080

    100120140160180200

    Prul(V)Pa(V)Pp(V)Ptot(V)

    V[km/h]

    P[kW]

  • Vv=-15

    1.0151480.1127940.1127941.0151482.8198565.5269179.136333

    13.648119.06223

    25.378732.5975340.71872

    Ra [daN] pentru Vv=-

    15 km/h

  • 49.7422659.6681570.4963982.2269994.85995

    0 20 40 60 80 1001201401601800

    20406080

    100120140160

    Ra(V), Vv=15 km/hRa(V), Vv=0 km/hRa(V), Vv=-15 km/h

    V[km/h]

    Ra[daN]

    0 50 100 150 2000

    10

    20

    30

    40

    50

    60

    70

    Pa[kW], Vv=15km/hPa[kW], Vv=0 km/hPa[kW], Vv=-15 km/h

    V[km/h]

    Pa[kW]

  • Vv=15

    1.015148 0 02.819856 0.003133 0.0783295.526917 0.006266 0.3070519.136333 0.084596 0.761361

    13.6481 0.313317 1.51645619.06223 0.767627 2.647531

    25.3787 1.522722 4.22978432.59753 2.653798 6.33840940.71872 4.23605 9.04860449.74226 6.344675 12.4355659.66815 9.05487 16.5744970.49639 12.44183 21.54056

    Ra [daN] pentru

    Vv=15 km/h

    Pa [kW] pentru Vv=-

    15 km/h

    Pa [kW] pentru

    Vv=15 km/h

  • 82.22699 16.58075 27.40994.85995 21.54683 34.25498108.3953 27.41526 42.15371122.8329 34.26125 51.18038138.1729 42.15998 61.41019

    0 20 40 60 80 1001201401601800

    20406080

    100120140160

    Ra(V), Vv=15 km/hRa(V), Vv=0 km/hRa(V), Vv=-15 km/h

    V[km/h]

    Ra[daN]

    0 50 100 150 2000

    10

    20

    30

    40

    50

    60

    70

    Pa[kW], Vv=15km/hPa[kW], Vv=0 km/hPa[kW], Vv=-15 km/h

    V[km/h]

    Pa[kW]

  • 235/60 R18255/55 R18265/50 R20245/65 R17275/40 R20235/60 R17235/65 R17285/65 R17235/65 R17235/65 R17

    6 R172 R180 R192 R20

    V [km/h] f [-]0 0.01611

    10 0.01603920 0.01602730 0.01607240 0.01617650 0.01633960 0.01655970 0.01683880 0.01717690 0.017571

    100 0.018025110 0.018537120 0.019108130 0.019736140 0.020424150 0.021169160 0.021973170 0.022835180 0.023755190 0.024733200 0.02577210 0.026866220 0.028019

    R17 R18 R19 R200

    1

    2

    3

    4

    5

    6

    76

    2

    0

    2

    Diametrul jantelor

    Intervalul mrimii analizate [inch]

    Nr. modele

    0 50 100 150 200 2500.010

    0.015

    0.020

    0.025

    0.030

    V [km/h]

    f [-]

  • R17 R18 R19 R200

    1

    2

    3

    4

    5

    6

    76

    2

    0

    2

    Diametrul jantelor

    Intervalul mrimii analizate [inch]

    Nr. modele

    0 50 100 150 200 2500.010

    0.015

    0.020

    0.025

    0.030

    V [km/h]

    f [-]

  • 0 50 100 150 200 2500.010

    0.015

    0.020

    0.025

    0.030

    V [km/h]

    f [-]

  • v= P0 0 0 0 0.0 0.00 0.00 0.0

    167 165 167 10 4.6 4.52 4.57 1.2334 330 333 20 10.5 10.39 10.51 2.5501 495 500 30 17.7 17.46 17.67 3.9668 660 667 40 25.9 25.57 25.90 5.6834 825 833 50 35.1 34.59 35.04 7.6

    1001 991 1000 60 45.0 44.37 44.94 10.11168 1156 1167 70 55.6 54.76 55.46 13.01335 1321 1333 80 66.6 65.61 66.43 16.61502 1486 1500 90 77.9 76.77 77.72 20.91669 1651 1666 100 89.3 88.10 89.17 25.91836 1816 1833 110 100.8 99.46 100.62 31.82003 1981 2000 120 112.1 110.69 111.94 38.72169 2146 2166 130 123.1 121.64 122.95 46.62336 2311 2333 140 133.7 132.18 133.52 55.72503 2476 2500 150 143.7 142.15 143.50 65.92670 2642 2666 160 152.9 151.41 152.72 77.52837 2807 2833 170 161.2 159.80 161.05 90.53004 2972 3000 180 168.5 167.19 168.32 105.03171 3137 3166 190 174.5 173.42 174.40 121.03338 3302 3333 200 179.2 178.35 179.12 138.73504 3467 3500 210 182.4 181.83 182.33 158.23588 3550 3583 215 183.4 182.98 183.33 168.63671 3632 3666 220 184.3 183.91 183.71 183.93755 3715 3749 225 185.3 184.00 184.01 184.0

    ni0.pred ni0.1 ni0.2 Pi0.pred Pi0.1 Pi0.2

  • 0 50 100 150 200 2500

    20

    40

    60

    80

    100

    120

    140

    160

    180

    200

    P Pi0.pred Pi0.1 Pi0.2

    v [km/h]

    P [kW]

  • 0 50 100 150 200 2500

    20

    40

    60

    80

    100

    120

    140

    160

    180

    200

    P Pi0.pred Pi0.1 Pi0.2

    v [km/h]

    P [kW]

  • = = = Pmax=0.469 2.092 1.561 184

    '= '= '= Pmax=0.531 1.938 1.469 184

    ni0.pred ni0.1 ni0.2 P= P=0 0 0 0.00 0.00

    167 165 167 4.58 4.52334 330 333 10.53 10.39501 495 500 17.70 17.46668 660 667 25.94 25.57834 825 833 35.10 34.59

    1001 991 1000 45.02 44.371168 1156 1167 55.56 54.761335 1321 1333 66.56 65.611502 1486 1500 77.86 76.771669 1651 1666 89.33 88.101836 1816 1833 100.80 99.462003 1981 2000 112.12 110.692169 2146 2166 123.15 121.642336 2311 2333 133.72 132.182503 2476 2500 143.70 142.152670 2642 2666 152.92 151.412837 2807 2833 161.23 159.803004 2972 3000 168.49 167.193171 3137 3166 174.54 173.423338 3302 3333 179.23 178.353504 3467 3500 182.40 181.833588 3550 3583 183.37 182.983671 3632 3666 183.91 183.713755 3715 3749 183.99 184.01

  • np=3750

    np=3750

    P=0.004.57

    10.5117.6725.9035.0444.9455.4666.4377.7289.17

    100.62111.94122.95133.52143.50152.72161.05168.32174.40179.12182.33183.33183.89184.00

    puteri,momentealfa,beta,gamaca,cerezistentepneui0pi0