Hi Guys!
I have resently got my hands on a small project, getting data from a check weigher that speaks Modbus RTU.
I want to use the ML1100 to communicate with the weight and I need to collect values continously. Theese values have to end up in a report made every friday by the ML1100 and then collected with Excell on monday. Report is to hold average, min and max values for 3 weight groups - 1,0 kg, 1,5 kg and 2,0 kg.
Now what I was planning to do was use a FIFO to collect the data and then when it is filled up (or the group changes), use the AVA instruction to make the average of that part of the production. Do the same for the next filled FIFO and collect that into another FIFO and at some point do an average on that FIFO as well.
My problems began as I tested this in Excell, doing a MIDDEL instruction on 102 different numbers gives me 112192,9, splitting it up in 4 MIDDEL instructions and then adding a fifth on those 4 gives me 95447,45
Not excactly the same number!
So I guess I'll have to use an ADD instruction to add all the weight data to one another and another to count the number of times that weight group has been added and then using those to do my average calculation on fridays.
Now my question for the esteemed members of this board is this: Is there another simpler way of doing this? As the accumulated value of all the weighings in say the 1,0 kg group could/will exceed the max value for a tag of the typr REAL.
I expect somewhere between 30-50 weighings per minute 8 hours a day - for normal production.
I have resently got my hands on a small project, getting data from a check weigher that speaks Modbus RTU.
I want to use the ML1100 to communicate with the weight and I need to collect values continously. Theese values have to end up in a report made every friday by the ML1100 and then collected with Excell on monday. Report is to hold average, min and max values for 3 weight groups - 1,0 kg, 1,5 kg and 2,0 kg.
Now what I was planning to do was use a FIFO to collect the data and then when it is filled up (or the group changes), use the AVA instruction to make the average of that part of the production. Do the same for the next filled FIFO and collect that into another FIFO and at some point do an average on that FIFO as well.
My problems began as I tested this in Excell, doing a MIDDEL instruction on 102 different numbers gives me 112192,9, splitting it up in 4 MIDDEL instructions and then adding a fifth on those 4 gives me 95447,45
Not excactly the same number!
So I guess I'll have to use an ADD instruction to add all the weight data to one another and another to count the number of times that weight group has been added and then using those to do my average calculation on fridays.
Now my question for the esteemed members of this board is this: Is there another simpler way of doing this? As the accumulated value of all the weighings in say the 1,0 kg group could/will exceed the max value for a tag of the typr REAL.
I expect somewhere between 30-50 weighings per minute 8 hours a day - for normal production.