how to save 2chart data in excel,(volt,current)every 10 seconds?

[good girl]

hi,

2friends gave their suggestions,but I couldn't do it on my application,(maybe because I am new to labview),

do you think it is possible for you to make a change on my application that I gonna attach now?

I need it to save the data of every 10 sec of the running process,in a seperated group,so that later I can reopen the excel and control each 10sec's data,

does my description make sence?

[GerdW]

Hi good girl,

how does it come that all of your wires bend in the craziest ways instead of making simple, clean, straight connections?

I replaced most of the ExpressVI parts, now you could actually see what happens in the VI.

Your DAQ-Assistent is set to 1kHz sampling rate. Do you really want to save 10,000 values in a row before starting the next row?

To do so you simply have to change the number of samples to 10k in the DAQ-Assistent

[good girl]

hi,

lol,,,,,,,,,yea when I compare your's I can guess how messy was my wires all over,sorry,
thx for your suggestion,but I have some vagues in that,

as I run the app. it asks me to save some where(giving the path to that),ok,I gave it,then for the second path,(still it's ok),but then it doesn't go and just a saving request page comes after you give path to the previous one(but normally it should just ask for 2saving path,at the beginning of the process,1 is the General save-path and the second one is the Limit exceed-path,,,,,,,,and another problem is that when I just cancel the process and tried to open one of too many files that it wantes to save(I opened it in excel),it is just 1data in 1row,(maybe just one of the factors....could be my chart data of voltage or current)and just that......some thing like this:

 
4.559    4.556    4.558    4.559    4.556    4.555    4.552    4.553    4.553    4.555       
                                        

and the raw is just continuing..................to the left,
but I want it to show me an excell,let's say like the file that I gonna attach in this post,so that I can reopen it again and zoom on each group for more controling,
(I need the groups to contain a period of 10 secs with the 3data factors:time/voltage/current in these 10 secs,
can you help me with that?

thx,

[RavensFan]

First, you need to have filenames in your file control before you start the program, otherwise the empty paths will cause it to ask for the filename each and every iteration.

Why are you reading 100 samples, but proceeding to only index out the first sample from the two channels?

See the attached VI to see how you can use the Elaspsed Time VI to add new data every 10 seconds to break up the groups.

[good girl]

1.I connected the DAQ which shows me 2signals let's say around 4,5 when I do it in the device's test panel,but it is strange for me that when I just run this current application,it neither shows me anyyyyy voltage(both raw v-chart and voltage.1-chart are off)nor it shows a correct current,if you can run this app that I am attaching it now,you may be able to see what I am talking about the off-charts but if you can not open it then I will also attach a picture of the screen so you can see the prob,

2.another thing to mention as a friend asked me:"Why are you reading 100 samples, but proceeding to only index out the first sample from the two channels?"
to tell you,I am not really sure if the previous step was right?if you thing something is wrong,could you remove the error for me plz???????the story is like this that I need to recieve 3data(Voltage,current and both of them should be based on time)........and as the process is running,it should be able to save each 10seconds of these 3data in an excel sheet(as it is doing it right now),
but as I knew this DAQ should be set on 20 at the beggining,(Hz),so I don't know how many samples will it be?
but as an example let's say it will be 1024 samples and then if we call them a block,then each second it is showing us the average of this passed block,and then goes for representing the average of the next comming block in just some milliseconds,am I right?
and it will do it for about 10seconds continously,but what it will save for me,gonna be just 10digits out of these too many blocks and averages,............,
so if anything is wrong with my lower part of the control panel images,plz help me with that,

[RavensFan]

You are doing 2 channels of 100 samples.  That is what gives you a 2-D array.  Right now I'm not sure if that is going to be 2 columns by 100 rows, or 2 rows by 100 columns.  So when you index the array to get each channel, you might need to put a 0 in either the first output's row index, (or it's column index) so you get the 0th row, (or the 0th column).  (The 2nd output of the index array would be 1st row, or 1st column as the case may be.)  I just depends on the orientation of the array.  I don't have a daq card on my PC so that I can run a DAQ assistant and figure that out right now.

If you want only 1 data point for each channel, then change the DAQ assistant to 1 sample (on demand).  If you want the average of 100 data points, then do an array average, on channel before passing it to the Write to Spreadsheet File function.

As for getting or not getting data from the DAQ assistant, you'll need to figure that out.  If it works in the test panels, that's a good sign.  Then maybe it is just an issue with the way the DAQ assistant is setup, or the way the data is being broken apart from the 2-D array.  I'd recommend making a simple VI that just does your DAQ measurements and displays them on screen and play with that until you get things working right.