Time Stamp read problem with Spreadsheet String To Array

[Nishant]

Hiii,

      Right now i am leaving my office ill mail you 2moro morning so we will come in contact at 3'0 clock by the indian time( as per the GMT , i ll try at that time and do it for sure, but if not possible i ll mail you.OK

Thanks,

Nishant

[DavidJCrawford]

I am leaving shortly for the weekend so I won't be online till Monday.

Continue to post and get the help you need. There are always plenty of good people who can lend a hand.

Have a good weekend

David

[Nishant]

Hiii, David

        Thanks man, now i am getting something out of this, and i am able to plot the time onto the XY graph, so i think i ll get success now, so its not a big problem, thanks again and enjoy weekend.

Thanks,

Nishant

[Nishant]

Hiii,

  I am trying to plot the historical data on the graph, but i am unable bcpz on the x-axis it is Time Stamp and on the y graph, there are data, but as the two types are different, i cannot plot the data on any of hte graphs, i am attaching the vi here and the excel file from which i am taking the historical data in the vi you can see all the efforts i have put on, can anybody please help me?

Thanks,

Nishant

Message Edited by Nishant on 02-05-2006 11:17 PM

[DavidJCrawford]

Hi Nishant

Here is an example that I built looking by looking at the shipped examples (XY Graph.vi) and adapting it to what I think you want.

For each of your channels you need to build and array of cluster of timestamp and data. If you want multiple plots on the same graph you will need to take each of the xy clusters and bulid them into an array of clusters for the XY Graph.

It doesn't use your data file. I will leave you to study and adapt to your needs.

Hope this helps you understand a little bit better.

David

Example in 7.0 attached

[Nishant]

Hiii, David

       Actually after i post this queestion, i came to its solution but not in the XY graph, but in the Wf chart, and it is displaying the data and the time both together, thanks anyways...., but  some problems are still there, thats why still i am confuse, and sorting it out, anpther thing is if we want to take miliseconds with the time, what we should do? should we multiply it with the 1000(1 s = 1000ms)? and to give it to the time value? coz i must have to do it...

Thanks,

Nishant

[DavidJCrawford]

Timestamp is in seconds from 1904 so if your millisec field is 100 then it would be 100/1000 then add it to your timestamp.

[Nishant]

Hiii,

     Do you know that is there any option in the property node to clear the chart? mean whenever we start to plot the new data onto the chart in the current vi, is there any option to clear the chart?

Thanks,

Nishant

[DavidJCrawford]

Wire an empty array to history property.

[rolfk]

---

@Nishant wrote:

Hiii,

  I am trying to plot the historical data on the graph, but i am unable bcpz on the x-axis it is Time Stamp and on the y graph, there are data, but as the two types are different, i cannot plot the data on any of hte graphs, i am attaching the vi here and the excel file from which i am taking the historical data in the vi you can see all the efforts i have put on, can anybody please help me?

---

As I have written in an earlier post, you do not have any date in your time information so use of absolute time format is not very useful. Use relative time format instead and you do not have the issue with the timezone offset at all.

As to the XY graph you want to create an array of clusters with two arrays in there for the X and Y data for each plot. This means that you will have to use the resulting (relative) time for each plot again.

Attached is an example of how I would do it by processing the input file line by line. This may be a tiny little slower for smaller files but will allow to read in much larger files than reading in the whole file at once and waiting for LabVIEW to run out of memory.

Rolf Kalbermatter