Operate on X with _coarse_ time format data ?
Posted: Thu Oct 27, 2011 10:25 am
The following is a query because I do not claim that this should work, given that the time stamp is too coarse.
I have a file with data that is sampled faster than a second but the time tag is like
19/10/2011 15:54:50 10
(repeat 8 ) 11,13 etc
19/10/2011 15:54:50 21
19/10/2011 15:54:51 21
(repeat 8)
19/10/2011 15:54:51
So in other words my time stamp is too coarse for the data (it should have been 50.1,50.2 etc)
Regular X,Y plots all look perfect and display the time in the x-axis
which is a bonus.
In order to subtract Y=Y(n+1) - Y(n) I run Operate on X and add X+1 on a copy of the curve.
This modifies the time stamp to:
31/12/1899 0:00:00
and collapses all my data into a single point (with X=0) -
I am not sure whether this is because I execute +1 on a time stamp or
because there are gaps in my time.
When I load the data via colum=0 for X (which gives the increment) everything works fine, but I lose the nice time label in the graphs.
By the way, I really like this Plotting tool - you can make eally nice graphs quickly - my days of struggling with Excel are over !!
B.
I have a file with data that is sampled faster than a second but the time tag is like
19/10/2011 15:54:50 10
(repeat 8 ) 11,13 etc
19/10/2011 15:54:50 21
19/10/2011 15:54:51 21
(repeat 8)
19/10/2011 15:54:51
So in other words my time stamp is too coarse for the data (it should have been 50.1,50.2 etc)
Regular X,Y plots all look perfect and display the time in the x-axis
which is a bonus.
In order to subtract Y=Y(n+1) - Y(n) I run Operate on X and add X+1 on a copy of the curve.
This modifies the time stamp to:
31/12/1899 0:00:00
and collapses all my data into a single point (with X=0) -
I am not sure whether this is because I execute +1 on a time stamp or
because there are gaps in my time.
When I load the data via colum=0 for X (which gives the increment) everything works fine, but I lose the nice time label in the graphs.
By the way, I really like this Plotting tool - you can make eally nice graphs quickly - my days of struggling with Excel are over !!
B.