Jump to content
Sign in to follow this  
Walkerok

Enhanced Vision Write Delimeted Line Question

Recommended Posts

We are creating an Excel delimited line in ladder and ultimately there are about 1200 MIs that have to be recorded.  Is there a non-painful way to make the line that to one by one make and set the values.  Asked another way is there a way to use a vector so I do not have to write appends manually?

 

If there is no way around this then I would like to suggest that this become a development consideration item.

 

Thank You

Keith

Share this post


Link to post
Share on other sites

It may be possible using a combination of the indirect addressing functions and vector stores. The issue is that for each MI used in a delimited line it will take up a vector of 3 MI's. Therefore the 1200 base MI's will take up a combined vector of 3600 MI's. Since there are only a maximum of 4095 MI's it will not be possible to write all of the information within a single vector, whether you enter it line by line or try to implement a faster solution.

 

Is it possible to enter a smaller amount of information 100 MI's at a time?

 

If so it may be possible if the original 1200 are in sequential vectors. Please let us know if this is an option and we can try to create an example.

 

Otherwise I would recommend logging the information to data tables which have more memory available. If the tables are then stored onto the SD card then we have a standalone data table to Excel converter.

Share this post


Link to post
Share on other sites

Yes all MIs are sequential.  I can not use the data tables because my understanding is that there is a limitation of 32 columns in a data table and I need many more than 32 columns to write a single excel line of this many MI variables.

 

Thanks

Keith

Share this post


Link to post
Share on other sites

Since the PLC will not execute the write commands quickly enough over time we have installed a time function that after the write time exceeds 1.5 seconds we are just going to create a new delimited file.  (1.5 seconds is the maximum time allowed and still be able to write the next line of data when it needs to be written).  This is a very ugly solution and should not really be necessary, but oh well.

 

No Im sorry it is completely unacceptable to write the data into multiple lines.  The project involves graphing each completed action and holding historical data for each action the pain involved on the excell side is just too high.

 

Thank You

Keith

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...