Quick Help

The knowledgebase is a categorized collection of answers to frequently asked questions (FAQ) and articles. You can read articles in this category or select a subcategory that you are interested in.



 Display the ITEM1 value, obtained by reading the MODBUS RTU at COM1 port on Excel

Problem

The PC is coupled with a PLC with MOBBUS-RTU. For a single register configured to be read at 40001 address, I obtain on the screen the following format:

#01#03#00#00#00#01#0A
#01#03#02#01#01#78#14 (bolded char are the data in register 40001),

For different decimal values in 40001 register I’m obtaining the following responses on screen:

For 40001 = 0 on PLC
#01#03#00#00#00#01#0A
#01#03#02#00#00#44
 
For 40001 = 10 on PLC
#01#03#00#00#00#01#0A
#01#03#02#00#0A#38#43
 
For 40001 = 100 on PLC
#01#03#00#00#00#01#84#0A
#01#03#02#00#64#B9#AF
 
For 40001 = 1000 on PLC
#01#03#00#00#00#01#84#0A
#01#03#02#03#E8#B8#FA
 
and so on…, with „View characters with code” options:.
0x00h – 0x1Fh As Hex #XX code
0x20h – 0x7Fh As Hex #XX code
0x80h – 0xFFh As Hex #XX code
 
I’m trying toobtain on excel file the coresponding for ITEM1 selected but all that obtain is columns with FULL_DATA_PACKET, DATA_PACKET, MODBUS_DEVICE_ID, MODBUS_FUNC. If I’m deleting all items and I let only ITEM1 on A1 column, nothing will be displayed.
 
Please help me to make the correct configuration in order to display the ITEM 1 value, obtained by reading the MODBUS RTU at COM1 port. I want to have at least this registered value on excel in order to continue with the others register data.
 

Solution

Please, configure your modbus request as:



 
Was this article helpful? yes / no

Article details

Article ID: 10

Category: Data Loggers

Date added: 2011-04-26 07:20:33

Views : 138

Rating (Votes): Article rated 3.7/5.0 (3)