Re: [libreoffice-users] Re: Generate a column of times

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 things, eliminated most of the time
stamps. I then provided an user option in the UI to either
display/export the raw data or a representation of the full details.

What the OP describes is simple raw data and maybe there is a similar
display/export option in the capture software being used here.

Dave

Paul D. Mirowsky wrote:
> 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, William Drago wrote:
> > 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.
> > >
> > >                                            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 incrementation
> > > that
> > > takes place in this technique to try to get the last cell to say the
> > > stop
> > > time.  It comes pretty close but is always off by a few minutes. The
> > > reason
> > > for this is theres a limit to the precision you can do with Times in
> > > OpenOffice Calc. Using the hr/mn/sec format you can't generate small
> > > enough
> > > increments to get the generated times to match the stop time. If
> > > there was a
> > > hr/mn/sec/fraction of a second format you could do it. In Calc theres  a
> > > time format that looks like this, but in practice it doesn't 'roll over'
> > > like say minutes or seconds.
> > >
> > > It looks like Calc's stock functions won't do the job. I'm thinking of
> > > getting around this by finding some source for a stopwatch program, and
> > > maybe modifiying it to do something similar, but with a greater
> > > precision of
> > > incrementation.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted