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
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Addding Data with DIFFERENT Scales
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
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Addding Data with DIFFERENT Scales
RE: Addding Data with DIFFERENT Scales
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
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
RE: Addding Data with DIFFERENT Scales
http://ww
TTFN
FAQ731-376: Eng-Tips.com Forum Policies