Thanks Brian for the reply,
The data acquisition
device samples at "approximately 1 sample per second" not a nice fixed
sample rate. And unfortunately time stamps the first and last sample only.
If the sample values are in column A1, then I'd lik
Thanks for the replies.
My earlier example was a
simplified version of the data I'm working with. When Brian & Wdragos
technique is applied to the 2026 samples I really have, it sort of works so
I can see what your talking about. I keep altering the incre
Thanks again for the replies, this is what I've tried so far:
The start time was 10:25pm and the stop time was 10:55pm, with 2026 samples.
I first highlight column 'A', and format the cells as 'Time', using the
01:37:46pm format. The first cell, A1, gets the start time, 10:25:00pm. The
second cel
Thank, Brian, that last reply got it working. I can see that the timeline
created fits within the start and stop times. I can see some time values
repeated twice but that's what you'd expect with a non one sample per second
sampling rate. All I wanted was to correlate notes taken during sampling
wi
At 17:29 08/09/2014 -0700, Nobody Noname wrote:
The data acquisition device samples at "approximately 1 sample per
second" not a nice fixed sample rate.
That's odd, as your example had them over six minutes apart.
If the sample values are in column A1, ...
Hold on: A1 is a cell, not a colum
This is what Brian is trying to explain...
You've got 6 samples. The first one taken at 12:04PM, the
last one at 12:36PM.
The total elapsed time is 12:36PM - 12:04PM = 22 minutes.
22 divided by 5 (always the total number of readings minus
1) = 6.4 minutes or 6m and 24s per interval.
Adding
At 05:45 09/09/2014 -0400, William Drago wrote:
This is what Brian is trying to explain...
I was doing more than try! And no: what you
suggest here is not what I was saying.
You've got 6 samples. The first one taken at
12:04PM, the last one at 12:36PM. The total
elapsed time is 12:36PM - 1
On 9/9/2014 6:18 AM, Brian Barker wrote:
At 05:45 09/09/2014 -0400, William Drago wrote:
This is what Brian is trying to explain...
I was doing more than try! And no: what you suggest here
is not what I was saying.
You've got 6 samples. The first one taken at 12:04PM, the
last one at 12:36
At 07:22 09/09/2014 -0400, William Drago wrote:
Since the OP was confused by your instructions
(indicating his level of inexperience with
spreadsheets) and you did not explain how to
fill the column or the purpose of $, I offered
what I thought would be easier for someone at his level to under
Hi :)
I thought it was really kind to de-geekify Brain's answer. The tpyo was
unfortunate but these things happen [shrugs]. The main thing, for me, was
that i could then go back to Brian's answer and understand it more easily.
Thanks and regards from
Tom :)
On 9 September 2014 12:22, William
At 17:22 09/09/2014 -0700, Nobody Noname wrote:
My earlier example was a simplified version of the data I'm working
with. When Brian & Wdragos technique ...
They were not one technique but two different ones, in fact.
... is applied to the 2026 samples I really have, it sort of works
so I can
Hi.
I think the trick is to not calculate the difference/no. samples and
keep adding but to calculate the difference and multiply by position
over number of samples added to start time. For a quick test this seems
to give times to 0.00 of a second and the finish time is always the
finish time
At 16:58 10/09/2014 +1200, Steve Edmonds wrote:
I think the trick is to not calculate the difference/no. samples and
keep adding but to calculate the difference and multiply by position
over number of samples added to start time.
For the avoidance of doubt, you will see that this is what my
o
It might be helpful if you post the actual start/stop times
for the 2026 samples. There's more than one way to skin this
cat and I'd only look for solutions outside of Calc as a
very last resort.
-Bill
On 9/9/2014 8:22 PM, office76#xt wrote:
Thanks for the replies.
I think we understand each other, Brian. It's all good...
Regards,
-Bill
On 9/9/2014 8:03 AM, Brian Barker wrote:
At 07:22 09/09/2014 -0400, William Drago wrote:
Since the OP was confused by your instructions
(indicating his level of inexperience with spreadsheets)
and you did not explain how
Hi :)
If you are not happy with Calc and looking for a reason to use something
else then maybe try Gnumeric.
It is a specialist tool that focusses more on spreadsheeting functionality
without having to worry about any other apps as it's a stand-alone tool.
It co-operates well with LibreOffice/Open
It might also be helpful if you mentioned your data acquisition hardware.
It might be that using a standard interval reading is possible and you
don't have to guess about the readings at all.
Start 00:00:00, first interval 00:01:00, second interval 00:02:00 etc...
On 9/10/2014 7:45 AM, Willi
Also the data acquisition software. I have written a few data
acquisition programs and in some cases the sample rate was extremely
high over an extended period of time. To keep the file sizes down to
something reasonable I stored the captured data with a compression
algorithm which, amongst other t
On 2014-09-10 17:09, Brian Barker wrote:
At 16:58 10/09/2014 +1200, Steve Edmonds wrote:
I think the trick is to not calculate the difference/no. samples and
keep adding but to calculate the difference and multiply by position
over number of samples added to start time.
For the avoidance of
Well, of course not.
The difference between 10:25pm and 10:55pm is exactly 30 minutes, or
1800 seconds. But you have 2026 samples, which, at a second each, comes
to 33 minutes and 46 seconds, which is equivilent to a stop time of
10:58:46pm. The extra second is (I think) due to the first sample be
At 06:33 11/09/2014 -0700, Nobody Noname wrote:
Thanks again for the replies, this is what I've tried so far:
Why not try one of the two techniques already suggested (both of which work)?
The start time was 10:25pm and the stop time was 10:55pm, with 2026
samples. I first highlight column 'A'
At 09:24 11/09/2014 -0700, Nobody Noname wrote:
... that last reply got it working.
Good-oh!
I can see some time values repeated twice but that's what you'd
expect with a non one sample per second sampling rate.
Exactly. I meant to mention this but forgot. Remember that the
repetition is o
22 matches
Mail list logo