doubt regarding writing to spreadsheetfile.vi

[sukumar]

here i put the boolean and shift register and I am not finding any difference in recording even if I press the boolean. And I find the time is same all through the recording.  its not changing at all. It just gives the time of start of run but all values are different. I don't know why time is not displayed properly.

[RavensFan]

---

@sukumar wrote:
here i put the boolean and shift register and I am not finding any difference in recording even if I press the boolean. And I find the time is same all through the recording.  its not changing at all. It just gives the time of start of run but all values are different. I don't know why time is not displayed properly.

---

In your VI you are recording 1500 samples per second in batches of 100.  So for 15 batches you will have readings with the same second.  Also, your cell formatting in Excel is not showing seconds.  Edit the cell formatting so it is a customer format.  m/d/yy h:mm:ss.   This will show seconds.  Do this through the whole Excel file and you will see that your time does change.

I don't understand what you mean by "pressing the boolean".  The booleans in your write file VI's are constants.  So there is no way to "press" them while running.

Message Edited by Ravens Fan on 08-14-2007 02:23 PM

[Dennis_Knutson]

This whole thread is getting as silly as the thread you insisted all of the graphs were showing the same data. They weren't and the data being generated does have hours, minutes, and SECONDS in it. Just look at the file with a text editor such as Notepad. As Ravens Fan says, you have a problem with how you are formatting the Excel cells. If you need help with that, go to www.microsoft.com.

[sukumar]

here i want to implement the start button for recording. so thats why i put the boolean indicator in my VI. Is that not the way to implement it? if no, Please give me some ideas of how to do it. Thanks.

[sukumar]

I have selected the write to file by browse button for path file and ran the program. Then afterwards I  deleted it and again ran the program but there is no popup coming for write to file. Any one has any idea of what might happened.

[Dennis_Knutson]

I really don't want to get too offensive but I also think it's time to say rtfm.

[sukumar]

Hi Ravens,

        My functionality is almost done with some minor defects. As per u said, that I am getting the 15 batches of 100 samples each for every second but for the first second I am getting sometimes 10 batches and sometimes 13 and its random.  And one more thing is that when I first give the path to file it is writing only to the notepad but not to excel file. But this is not the case with when I chose write to file as it asks for. These are the things that make me unable to get full functionality.  Hope u understood it and solve my problem. Thanks.

[Brian_R]

When using hardware timing set to 1500 samples per second, you will deterministically get 1500 samples per second.  Depending on how you are computing time, you may not be allowing the DAQ card to initialize and start its task. 

Your file I/O looks like it is writing ASCII text to a delimeted file.  This can be opened in both notepad and Microsoft Excel.  You have to specify which software you want to use to open your file.  If this is a custom file type (i.e. a custom file extension) you can have the operating system default to using a specific program for your file.