Time Stamp read problem with Spreadsheet String To Array

[Nishant]

Hiii, Rolfk

        Thanks for the help man, but i have overcome this problem now and it is on the waveform chart, which is better than XY-graph for my particular project. but i think one thing can help me for sure and that is about you told that relative time could be used, because i am already in a problem with displaying the time.

Thanks,

Nishant

[Nishant]

Hiii, David and Rolfk,

       Hey Rolf,as you told me that, there is no date in my project,but no now i came to know before somewhile that i have to also include the date with that, so what i should do to include date with the time,and both will be displayed on the graph.

Thanks,

Nishant

[Nishant]

Hiii,

        Is there any option to enable the cursor legend in the waveform chart? cos waveform graph is not taking the cluster data, it only takes the array data, which i don't want,so is there any option to display cluster in the waveform graph? one of both will work for me.

Thanks,

Nishant 

[DavidJCrawford]

Nishant

If you want include date for your chart or graphs then you need to look at the process where you generate your data file and change it accordingly.

Charts don't have cursors so if you want them you will need to change how you construct the data to allow the connection to XY Graph.

Rolf has given you a great example if not the solution to your question on how to read your file for XY Graph. You can then use cursors.

David

[Nishant]

Hiii, David

    Ya i got the point regarding date, but is there any method like time, to convert everything? mean,we r converting all into the seconds, as shoul dwe convert the date into the days? or is there any method? coz date and time will be in different columns, so we have to combine it, so how we can conbine, that is also a big question.

I dont get this point what you wrote"Charts don't have cursors so if you want them you will need to change how you construct the data to allow the connection to XY Graph."?

Thanks,

Nishant

[DavidJCrawford]

Hi Nishant

All I meant by that is that data type that connects to a chart will be different to the data type required for XY-Graph. Three different methods in the image below and attached.

Graph which is an Array of DBL [DBL]

XY Graph which is an Array Of Cluster Of {[DBL], [DBL]}

If you are using a Chart at the moment and need to use cursors then you would need to change your code to be inline with data type appropriate with using Graph or XY Graph.

Yes we have taken your timestamp data strings, converted from string then converted into seconds.

Rolf mentioned that you should consider working in relative instead of absolute. The timestamp functions can be found in the Time and Dialog palette. Look in there and experiment with them. Also experiment with a DBL indicator in absolute and relative time formats.

This shows the difference between the Relative and Absolute

As you can see Relative is an elasped time which might be what your want.

David

Message Edited by David Crawford on 02-07-2006 02:38 AM

[Nishant]

Hiii, David

      Actually, as i am taking records, one by one there is an array o fdata but, there wont be the array of time and only single time record will be there so i wont be able to create XY-graph. another thing i want to ask is there is no way possible to implement cursor in the chart? bcoz of this reasons, i can't plot the data on any o fother graphs, and we must have to give the cursor, which is in the requirements of hte projects. so i am somewhat confused now what to do?

         And in the case of date what should i do? i still not understand that thing. should i have to convert date ib the relative Time? please give me some explaination.

Thanks,

Nishant

[DavidJCrawford]

Hi Nishant

Sorry but I am getting a bit confused myself but hey I am easily confused.

I want to reset the discussion to make sure that we are working from the same page.

Charts don't have cursors

In Reply #13 you provided a data file to be graphed.

In Reply #40 Rolf gave a solution to read data file and graph the results from your file.

So I think you have the solution to your orginal requirement. Has this changed?

David

[roboticstudent]

Hello, David,

Since you were able to answer so many DBT questions really well, I hope you can help with mine.

I have this file in notepad and I want to insert the data into MS Access db.  DO you know how to do that ?

Thanks:).

(Anyone else is welcome to answer.)

Here's the attachment:

Message Edited by roboticstudent on 02-07-2006 10:18 AM

[DavidJCrawford]

roboticstudent

LOL, your very kind.

Start a new thread. This one is getting a bit lengthy. See you there.

David