rslinx excel need help

I need help with trying to expand a program that takes pressure and position from a ram follower machine and puts it into excel. The excel sheet already has cells to get data
=(rslinx|'T15'!'N101:1')/1000--0.01
=(rslinx|'T15'!'N101:2')/1000--0.01
=(rslinx|'T15'!'N100:3')/1000--0.01
...
etc all the way to 200
I need to expand this to go to 400, so I copied and pasted and changed the numbers manually from 201-400. When I ran the machine only the original cells got data the rest were #N/A. Is typing in the number not allowed? Does it have to be programmed in?

If anyone knows how to make this work please help! All I know is that rslinx program has to be open and when the machine runs the data should come in, and it does but when it hits the 200th cell it doesnt change the cell from #N/A to a number it just stays #N/A, while the machine keeps running (runs for 90 seconds no matter what)

Do the higher numbered addresses exist in the PLC?

thats probably the problem, how would I go about making these addresses. We are thinking it has to do something with RSLogix

What PLC do you have? Complete catalog number and series would get get you the best answer.

What PLC type is it? Yes you need RSLogix 5 or 500 depending on your PLC type. You have to expand the data table. You can do this online, but not in run mode. The PLC will have to be put in program mode. But remember if this is your issue, there won't be any data there after you dreate the additional addresses. Program code modifications will have to be made. I would go online with the PLC first and see if the addresses that you are trying to read exist.

I looked in the machine and found these numbers and dont know what they mean (i dont know much about this plc stuff):

SLC 5/03 CPU
DH485
RS232

does that help?
otherwise i can go ask what plc type is

That PLC will only support data files with 256 elements e.g. N100:0 to N100:255.

If you want more then you will need to create another data file e.g. N101:0 to N101:255

Mickey said:

That PLC will only support data files with 256 elements e.g. N100:0 to N100:255.

If you want more then you will need to create another data file e.g. N101:0 to N101:255

Click to expand...

It may be an advantage to create the files thus...

N100:00 to 99
N101:00 to 99
N102:00 to 99
N103:00 to 99
N104:00 to 99

The actual position in the whole data structure is easily read as the last three numeric digits - and if you want to find reading number 357, then it is simply N103:57

Ok so, I opened up the RSLogix project file and found a big thing of ladder logic, I was looking for N101:200, since the calls only work up until N101:200, but in the code it only went to N101:129 (shown in the attachments) does anyone know what this means? And how would i create another data file N102:0 to N102:200?

does anyone know what that means?

Yes, there's a lot of info in those two FFLs to decipher.

1. You haven't shown what conditional instructions are on the left of the rung. Presumably the rung gets triggered each time a new "recording" of N7:68 is to be made.

2. Assume "starting conditions" with both FFL instructions at position 0 : The first "false-to-true" rung transition (see 1. above) will load the value from N7:68 into the indexed address #N101:1 (the # indicates an indexed address). The actual address will be N101 ( 1 + the .POS of the FFL control), in this case 0, so a copy of N7:68 is placed into N101:1

3. The FFL then increments the .POS register, and waits for the next "false-to-true" rung transition. When that occurs, a copy of N7:68 will be put into N101: ( 1 + 1) = N101:2.

4. This carries on until the first FFL instruction gets DN, (i.e.when the .POS = 127) and the subsequent "false-to-true" rung transitions continue to record N7:68 into addresses N101:129 onwards.

5. It has been split up like this because of the 256-element file size limit.

6. To create a new data-file, you will have to go offline, create the new files, and do a download.

ok i attached the left side of that rung

Also, i kind of understand (except not really cuz i know pretty much nothing about plc/ladder programming)
omg, i found these data files, ok, now i understand a little more, so in N101 it goes up to N101:248, how come the code from the excel sheet (=(rslinx|'T15'!'N101:201')/1000--0.01) does not return anything?

And if I made the data file N102, would i just add, in parallel, another FFL but this one saying #N102:1

Yes! The first top FFL loads to memory locations N101:1 to N101:128. The second FFL loads to memory locations N101:129 to N101:248.

How come the code from the excel sheet (=(rslinx|'T15'!'N101:201')/1000--0.01) does not return anything?

Click to expand...

Probably because you have not modified the program to store anything into that memory address. Does your Excel sheet show a blank or a 0? A FFL does not create data, but only moves it from one place to another.

the excel spreadsheet gives #N/A past N101:200

Can you post a zipped copy of the .rss?