How to scale a velocity profile

Click For Summary

Discussion Overview

The discussion revolves around the methodology for scaling velocity profiles of cars to enable comparison between different profiles. Participants explore the technical aspects of scaling time and velocity values, addressing challenges related to differing durations and data representation in Excel.

Discussion Character

  • Technical explanation
  • Mathematical reasoning
  • Debate/contested

Main Points Raised

  • One participant describes a methodology for scaling velocity profiles to a uniform duration of 195 seconds, using linear interpolation.
  • Another participant suggests that scaling the time can be achieved by the formula: t x 195/tmax, where tmax is the maximum time of the original profile.
  • A participant expresses difficulty in comparing scaled profiles due to differing lengths in the number of cells in Excel, complicating the computation of differences between profiles.
  • One participant proposes methods for calculating the root mean square (RMS) velocity difference, including smoothing the profiles or using piecewise continuous functions to evaluate differences.
  • Another participant clarifies that they do not need to smooth the profiles and reiterates the challenge of mismatched time values after scaling, which prevents direct subtraction of corresponding velocities.
  • A later reply reiterates the previous advice to fill in gaps between data points with straight lines or stepwise variations for numerical integration.

Areas of Agreement / Disagreement

Participants express differing views on how to handle the scaling and comparison of velocity profiles, particularly regarding the necessity of smoothing and the method of integration. The discussion remains unresolved on the best approach to align the time values for accurate comparison.

Contextual Notes

Participants highlight limitations related to the representation of data in Excel, including the challenge of differing lengths in time values after scaling, which affects the ability to compute differences directly.

bradyj7
Messages
117
Reaction score
0
Hello,

I am reading a paper in which the author describes how he scales the velocity profile of a car.

He is doing this so that he can compare the velocity profiles of cars.

This is an extract from the text:

The first methodology consisted of evaluating the similarities between velocity profiles by computing the differences between their velocity profiles. This is a direct method, since the velocity profiles are considered in their entirety. The aim was not to quantify the links between different velocity profiles, but simply to highlight the similarities that might be present. To apply this methodology, it was first necessary to scale the velocity profiles and to perform a linear interpolation (step of 0.1 s) since all velocity profiles do not all have the same duration and the same time resolution. This was achieved by using the ECE part of the NEDC cycle as a reference. Consequently, once scaled, all the cycles had the same duration of 195 s. A comparison of the original and scaled NEDC cycles is illustrated in Figure 1.

https://dl.dropbox.com/u/54057365/All/scaleNEDC.JPG



My question is, if I had the time and velocity values of the "original NEDC" velocity profile, how would you actually scale it to achieve the "scaled NEDC". How would you scale the numbers to fit in the 195 second time frame?

Thank you

Here is the data in an excel sheet:https://dl.dropbox.com/u/54057365/All/NEDC.xlsx
 
Last edited by a moderator:
Physics news on Phys.org
bradyj7 said:
Hello,

I am reading a paper in which the author describes how he scales the velocity profile of a car.

He is doing this so that he can compare the velocity profiles of cars.

This is an extract from the text:

The first methodology consisted of evaluating the similarities between velocity profiles by computing the differences between their velocity profiles. This is a direct method, since the velocity profiles are considered in their entirety. The aim was not to quantify the links between different velocity profiles, but simply to highlight the similarities that might be present. To apply this methodology, it was first necessary to scale the velocity profiles and to perform a linear interpolation (step of 0.1 s) since all velocity profiles do not all have the same duration and the same time resolution. This was achieved by using the ECE part of the NEDC cycle as a reference. Consequently, once scaled, all the cycles had the same duration of 195 s. A comparison of the original and scaled NEDC cycles is illustrated in Figure 1.

https://dl.dropbox.com/u/54057365/All/scaleNEDC.JPG



My question is, if I had the time and velocity values of the "original NEDC" velocity profile, how would you actually scale it to achieve the "scaled NEDC". How would you scale the numbers to fit in the 195 second time frame?

Thank you

Here is the data in an excel sheet:https://dl.dropbox.com/u/54057365/All/NEDC.xlsx

From the figure, it looks like the only parameter that has been scaled is the time. If t is the running time in the experiment, and tmax is the overall maximum time, then the scaled time is t x 195/ tmax
 
Last edited by a moderator:
Thanks very much
 
Hello ChesterMiller,

You helped me scale the time parameter of velocity profiles above for a vehicle a number of weeks ago. Thank you.

I was wondering if you had the time to help me with something else?

When I scale the velocity profiles in excel the resulting times are same length (in seconds) but they occupy a different number of cells (in length).

I am trying to apply this methodology to them to compute the difference between the profiles. But because they occupy a different number of cells I cannot apply it because the "t" values are different lengths.

https://dl.dropbox.com/u/54057365/All/QD.JPG

I have attached a workbook here with two example original and scaled profiles

https://dl.dropbox.com/u/54057365/All/QD.xlsx

I would be grateful if you had the time to consider it.

Kind Regards

J
 
Last edited by a moderator:
It all depends on what you are trying to do, and what the data represents. It looks like you are trying to determine the rms velocity difference between the two velocity variations.

Do you want to smooth the differences between the two profiles first, or do you to include all the sturucture? If you want each of the profiles smoothed first, you can fit a Fourier series to the variation and include only the first few terms. Or fit another type of smooth curve.

If you want to include the sturucture, you can join all the sequential pairs points on each curve by straight lines, and interpolate between the points. Or you can represent each of the functions as a series of steps (like a bar chart), with constant values from half way between one pair of points, to half way between the next pair of points. In any event, you are fitting each of the velocity variations as a piecewise continuous function of time. Then you can evaluate the difference between the curves at any value of the time. Then you can integrate.

RMS = \frac{1}{t_{max}}\int_0^{t_{max}}(v_2(t)-v_1(t))^2dt

This equation is the continuous form of your discrete summation relationship.
 
Hello,

Thank you for your reply. I do not need to smooth the velocity profiles.

Yes, I am trying to compute rms velocity difference between the two velocity variations.

My problem is that velocity profiles have different time duration. Hence, I have scaled them to same duration.

My problem is that now that they are scaled, the time values are not the same so I cannot compute the difference between to corresponding velocity points.

For example, say profile A is 970 seconds and Profile B is 1075 seconds. So I scaled the time component of both profiles using your method above to 177 seconds.

t x 177/ tmax (970)

t x 177/ tmax (1075)

https://dl.dropbox.com/u/54057365/All/scale.JPG

This is an example of the time values after scaling.

https://dl.dropbox.com/u/54057365/All/values.JPG

Because the scaled time values are not the same, i cannot subtract the corresponding velocities.

I have been struggling with this for a few days but cannot seem to figure it out.

I'd appreciate any help you could offer.

Regards
 
Last edited by a moderator:
OK. Then just follow the advise I gave you in my previous posting. Fill in the regions between the grid points with straight lines or stepwise variations, and then integrate numerically. Use small time increments in the integration. If the times at the grid points on the scaled profiles had actually matched, doing this integration would have given you the exact same result as you summation equation.
 

Similar threads

  • · Replies 22 ·
Replies
22
Views
1K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 5 ·
Replies
5
Views
17K
  • · Replies 23 ·
Replies
23
Views
6K
  • · Replies 13 ·
Replies
13
Views
3K
  • · Replies 62 ·
3
Replies
62
Views
12K
  • · Replies 55 ·
2
Replies
55
Views
5K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 2 ·
Replies
2
Views
11K