PittsEngineer
Member
Hi there,
I'm struggling with a project right now that involves collecting data from power meters in load centers. The data format is Modulus 10 - 4 Registers (Mod10L4), and it is collected via a Modbus TCP/IP OPC.
Initial attempt was to retrieve these numbers in RSView 32, but immediately that proved to be difficult as RSView32 is not setup to deal with that type of dataformat.
Because I really only need these numbers in excel, I have chosen to use an OPC client that allows me to import numbers to excel, but again I'm stuck at the obstacle where the OPC only wants to grab the first register or the first two registers as either an integer or real number. So my option now is grab all four registers individually and re-assemble the Mod 10 number in excel.
I suspect this cannot be accomplished by the function commands internal to excel and will probably involve visual basic code. Has anybody else attempted such a task? If so, how'd you go about it? Thanks.
I'm struggling with a project right now that involves collecting data from power meters in load centers. The data format is Modulus 10 - 4 Registers (Mod10L4), and it is collected via a Modbus TCP/IP OPC.
Initial attempt was to retrieve these numbers in RSView 32, but immediately that proved to be difficult as RSView32 is not setup to deal with that type of dataformat.
Because I really only need these numbers in excel, I have chosen to use an OPC client that allows me to import numbers to excel, but again I'm stuck at the obstacle where the OPC only wants to grab the first register or the first two registers as either an integer or real number. So my option now is grab all four registers individually and re-assemble the Mod 10 number in excel.
I suspect this cannot be accomplished by the function commands internal to excel and will probably involve visual basic code. Has anybody else attempted such a task? If so, how'd you go about it? Thanks.