Walkerok Posted July 20, 2015 Report Posted July 20, 2015 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
Alexander Posted July 20, 2015 Report Posted July 20, 2015 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.
Walkerok Posted July 20, 2015 Author Report Posted July 20, 2015 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
Alexander Posted July 21, 2015 Report Posted July 21, 2015 The only way to write the information would be to separate it into multiple lines, is this an option for this application?
Walkerok Posted July 25, 2015 Author Report Posted July 25, 2015 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now