lookout spreadsheet

[BAH]

hi,

i'm trying to understand how the file "batch2" - included in the examples- works,  speically the opeartion of reading the data from the xls file,  HOW  they read  from the xls file  in sequence?  ???    i tried the integral objects, timers, samples: but  it's not working.

using the data member "import" it reads only the first cell of the column .

how can i  move the cursor along the column without interferring from user??

plz hekp

B.H

[Ryan.S]

It uses Datatable object to read the xls file. It does read all the data in the file, not only the first cell.  A1.txt is text value of cell A1, while B2.txt is the text value of B2. Here is an example that shows how things work. http://zone.ni.com/devzone/cda/epd/p/id/2113

If you want to import different files, have a look at this thread.

http://forums.ni.com/ni/board/message?board.id=190&message.id=4339

[BAH]

hi,

it's not really what i'm looking for 😞

in the example "batch2"  the Datatable is used, but  the whole example acts as a simualtion using integrals and timers

i tried to make an example using the same objects but didnt work also!!!!

the most thing that conflictied me is the start button!!! it's not connected to annny objects but yet it controls the start of the simulation !!!

i  need to  read from the sheet in sequence that's  "column by column" or "row by row"   and till the end to  perform a simualtion 😞 

thx for help

[Ryan.S]

In Object Explorer, right click "Procedure_Table", edit connections... you can see table.2=StartPb. This means when the StartPb is pushed, cursor1=2, points to row2 of table.  The Procedure_TableOneShot make the cursor change from 1 to 14.

For example, if cursor1=2,  Procedure_Table.e.logical is cell E2, which is used for PLC parameter PMP101.

[BAH]

that was right , thx very much  😄

but now I got another problem .............................

it's the delay time.... it's always set to 144 minutes and I can't change it.

i've made  my  own example to try the connections u told me about,

I attached the file test.l4p  and the 11.xls  file

could u  check it for me?

[BAH]

that was right , thx very much  😄

but now I got another problem .............................

it's the delay time.... it's always set to 144 minutes and I can't change it.

i've made  my  own example to try the connections u told me about,

I attached the file test.l4p  and the 11.xls  file

could u  plz check it for me?

[Ryan.S]

The time delay of OneShot timer is wrong. In Lookout, 1 means 1 day, so 0.1 equals 0.1 day, that is 144 min.

See the batch2 process, it uses 0:01, which equals 1 sec when the format is MM:SS.  And also see the BatchProc.xls in \National Instruments\Lookout 6.x\Examples\Applications\, the value of Column G is very small numbers. But the value you use in .xls file is 3, which equals 3 day.

[BAH]

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

it works 😄

and onther mistake i  made was in the one shot proprtoes , i  put the delay time max (file.d,0.1)

 so it kept reading 144 mnts   now it's working  thank you  very much  🙂