[Kst] Feature Request: Time axis in Excel numeric units

Barth Netterfield netterfield at astro.utoronto.ca
Wed May 16 16:41:47 UTC 2012

Are you suggesting that we make all data sources time-format aware?
Currently, numerical values are interpreted as dates in the plotitems.
Hmmm.... must think...


On Wed, May 16, 2012 at 3:14 AM, Brisset, Nicolas
<Nicolas.Brisset at eurocopter.com> wrote:
> Hi,
> a better handling of time is one of our pending features. I had proposed it for Google Code-In but it turned out to be too complex and the ideas were not completely clear. We did not make it for 2.0.5, but when we tackle it we'll keep your request in mind. And maybe come back to you for more information.
> If you had a sample file you can send us, that'd be great. I've started collecting different sorts of ASCII files with time vectors to figure out a way to handle them all. You can see the current status of my ideas at http://bugs.kde.org/show_bug.cgi?id=243684 so feel free to have a look and add your comments there.
> Nicolas
>> Betreff: [Kst] Feature Request: Time axis in Excel numeric units
>> Hi,
>> I like to propose a feature for the next Kst version:
>>     =>    Could it be made possible to set the time units selectable for the X-
>> axis also in the "numeric time units" of Excel and including the possibility of
>> displaying micro-seconds ?
>>             The required formula is:   UNIX_TIME_SEC = (EXCEL_TIME - 25569) *
>> 8640
>>             According
>> to http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps
>> /
>> Lately I have been using Kst with measurement data in CSV format written by
>> the PCAN Explorer and this S/W converts the CAN interface timestamps
>> when exporting to CSV into the "numeric time units" for Excel and therefore
>> every channel gets its own time vector = (X,Y).
>> As Excel is too clumsy for plotting longer data vector and especially data
>> vector with different sampling times, Kst comes in very handy, however I
>> would like to avoid having to do a formula for every time vector.
>> Thanks
>> Ralph Paul
> _______________________________________________
> Kst mailing list
> Kst at kde.org
> https://mail.kde.org/mailman/listinfo/kst

C. Barth Netterfield
University of Toronto

More information about the Kst mailing list