×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Addding Data with DIFFERENT Scales

Addding Data with DIFFERENT Scales

Addding Data with DIFFERENT Scales

(OP)
I've got two sets of data that I need to do some basic math with.  One is set at 5 min intervals while the other is set at 6 min intervals.  Is there some way to do this without manually manipulating one set of data?

RE: Addding Data with DIFFERENT Scales

The general approach would be to run a spline fit on one set of data and interpolate to get matching time scales

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: Addding Data with DIFFERENT Scales

(OP)
Thanks IRstuff for your response.  I thought about your suggestion before, but it doesn't work out so well.  I've monitored supply and return water temps from a chilled water loop as well as the flow.  I need to apply the following formula for each data point to calculate tons cooling: Tons = gpm x dT / 24.

Basically I need a value for gpm, CHWS temp and CHWR temp to align at the same time.  The overall average is easily calculated but is not as helpful as the overall trend of cooling tons over the period measured.

I've also tried using the VLOOKUP function of the dates in a numerical format.  I even tried ROUNDING the values to one, two and three decimal points but couldn't make it happen.  (Not sure if that's explained clearly but I could forward a portion of the data to anyone out there.)

RE: Addding Data with DIFFERENT Scales

I don't understand what you think you've tried.  The only way to align the data is through interpolation.  You can use either linear or spline.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: Addding Data with DIFFERENT Scales

How about just pasting some of it here?

RE: Addding Data with DIFFERENT Scales

I agree with IRstuff, you'll have to interpolate. I would think that the data you have for gpm should be pretty constant, so you could almost take the average over the time period, unless you have a step change, then you would take two or more separate time periods.

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: Addding Data with DIFFERENT Scales

This problem sounds just like what I working at a couple of weeks ago.

IRstuff, do you have specific plugin or macro you would suggest using to do a spline fit?  Google found a bunch for me, but I am a bit hesitant to run randomly downloaded macros.

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources