table

[kardus]

Hallo

Hi, my name is Luky and I'm working with labview for the last 3 months . I'm working with labview to control a machine that could do dielectric measurement. The machine is woriking and controlled well. The result can be seen on the PC monitor. I'm using a table in my program and later on the user is given a possibility to get the measurement result in a excel file once it's activated. My problem is in table. Since the result is calculated/updated in every second, it should be placed in each row of the table (each rows is related to each second). What I've got here is, I had the result but it always appears in the 3rd row of the table (the table is counted from 0,1,2.....n-1) while the other rows show 00000 or inf. That 3rd row is changing/updating the result each second. For more information, I took an example from "find example" to have a table and write it to XL.

Any suggestion maybe....????

Thanks a million for your help

Groetjes from NL
Luky

[RikPrins]

Hello Lucky,

Could you be a little more specific about this matter? ARe you writing the data continously to exel? or Are you writing the table to exel in total when you finished your measurement? Could you matbe post your program so I can take a look at it and give you some advice?

Best regards,

RikP
Application Engineering
National Instruments

[kardus]

Thank you for your response .....a bit late for me to reply it back though......Hmmm...actually I'm writing the table to exel in total when I finished your measurement. For writing the table to excel, there is no problem at all. I could have excel file just the same as what I get in the table. But the table it self shows the correct data but only in 1 of its rows. And the result which is shown in that row, is re-writed all over again each second. It suppose to write the other data into another row not into the same row. I attached my VI along with this message....

Dankje

Groetjes

Luky

[kardus]

Sorry.....Mistype......I meant "actually I'm writing the table to exel in total when I finished "My" measurement".

Groetjes

Luky

[RikPrins]

I tried to take a look at your program. The problem does not occur in writing the data to excel, that part is working correctly. The problem occurs earlier in the program since the data that is written to the table already contains the NaN's and the zero's. But because of the size of the block diagram it is almost impossible for me to see where the problem comes from. I consider you to take a good look at the formulas used and bit by bit dig down to see where the faulty data first occurs.

I also advise you to consider revising your program. Because of the large block diagram it is very hard to debug and maintain such an application. Try to break down your application in logical steps and create subvi's of these steps so you can maintain and tests separate parts of your program on functionality. It also gives a much better overview of you total application.

Best Regards,

RikP
Application Engineering
National Instruments

[kardus]

Yes it is a very big program.....the previous trainee made it....now it is my job to make it more simple and develope it to be more friendly for the user .......I will take your suggestion into consideration......

Thanks for your suggestion and advice

Regards

Luky