DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

time formats

 
Post new topic   Reply to topic    DPlot Forum Index -> Suggestions/Questions
View previous topic :: View next topic  
Author Message
eugene



Joined: 29 Feb 2004
Posts: 1
Location: Scotland

PostPosted: Sun Feb 29, 2004 7:01 am    Post subject: time formats Reply with quote

Is it possible to plot time in the format mm:ss.00 (including hundreths of seconds) against dates eg 12/05/2003.

I have downloaded a trial version but am not clear how, or if, this can be done presently.
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Sun Feb 29, 2004 4:04 pm    Post subject: Reply with quote

This is a timely question... I was about to upload an update, started to answer your question and noticed a few problems with reading times from files.

Reading a file of dates and times that looks like this:

1/01/2004,12:00:00.00 AM
1/02/2004,12:00:00.20 AM
1/03/2004,12:00:00.40 AM
1/04/2004,12:00:00.60 AM

should work, but doesn't. DPlot won't correctly parse the times unless they're preceded by a date, as in

1/01/2004,1/01/2004 12:00:00.00 AM
1/02/2004,1/01/2004 12:00:00.20 AM
1/03/2004,1/01/2004 12:00:00.40 AM
1/04/2004,1/01/2004 12:00:00.60 AM

This will be fixed ASAP.

I'll also have an Excel Add-In that will handle this problem as well. If you check back late tonight (US Central time) you should see a fix.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Mon Mar 01, 2004 1:01 am    Post subject: Reply with quote

Eugene,
I believe the latest update (1.931) will do what you want. If you have date and time values in an ASCII text file:

1/1/2004,12:00:00.36 AM
1/3/2004,1:00:03.40 AM
1/4/2004,4:01:00.60 AM

etc., use file type 'D Multiple columns (2D)' to open the file. DPlot will correctly parse the dates and times (including the fractional seconds) and automatically select the appropriate number formatting for the X and Y axes.

If your dates and times are in an Excel spreadsheet, take a look at the new Add-In, which does essentially the same thing.

Please let me know if you have any questions on this.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Suggestions/Questions All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group