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+unsubscr...@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