Klinkmann Automation Omron Ethernet DAServer

55

In this example, each time the value of <tagname> changes in the PLC, the DAServer will automatically send the new value to the cell containing the formula in Excel.

Note: Refer to the Microsoft Excel manual for complete details on entering Remote Reference formulas for cells.

Writing Values to the DAServer from Excel

Values may be written to the DAServer from Microsoft Excel by creating an Excel macro that uses the POKE command. The proper command is entered in Excel as follows:

channel=INITIATE("applicationname","topicname") =POKE(channel,"itemname", Data_Reference) =TERMINATE (channel)

=RETURN()

The following describes each of the above POKE macro statements:

channel=INITIATE("applicationname","topicname")

•Opens a channel to a specific topic name (defined in the DAServer) in a particular application name (the executable name less the .exe).

•Assigns the number of that opened channel to channel.

Note: By using the channel=INITIATE statement, the word channel must be used in the =POKE statement instead of the actual cell reference. The "application name" and "topic name" portions of the formula must be enclosed in quotation marks.

=POKE(channel,"itemname", Data_Reference)

•POKEs the value contained in the Data_Reference to the specified item name (actual location in the PLC), via the channel number returned by the previously executed INITIATE function.

•Data_Reference is the row/column ID of the cell containing the data value.

=TERMINATE(channel)

•Closes the channel at the end of the macro.

•Some applications have a limited number of channels; therefore, they should be closed when finished.

•Channel is the channel number returned by the previously executed INITIATE function.

=RETURN()

•Marks the end of the macro.

Note: Refer to the .xlm sample Excel poke macro provided on the DAServer CD. Also refer to the Microsoft Excel manual for complete details on entering Remote Reference formulas for cells.

Omron Ethernet DAServer Ver 1.x User Manual Rev 1.4

17014m14

Page 56 Page 58
Page 57
Image 57
Omron DR 170 14 Writing Values to the DAServer from Excel, Channel=INITIATEapplicationname,topicname, =TERMINATEchannel
Page 56 Page 58

DR 170 14 specifications

The Omron DR 170 14 is a leading-edge digital infrared thermometer that has established a strong reputation for its accuracy and efficiency in measuring body temperature. This advanced device is particularly noted for its user-friendly design, making it suitable for both medical professionals and home use.

One of the key features of the Omron DR 170 14 is its non-contact measurement capability, allowing users to obtain temperature readings from a distance of about 1-3 centimeters. This feature is crucial in minimizing the risk of cross-contamination, especially in healthcare settings. The thermometer utilizes infrared technology to detect the infrared energy emitted by the body, ensuring quick and reliable readings in just seconds.

The Omron DR 170 14 also boasts a large, easy-to-read LCD display that provides clear visibility of temperature readings. This display is backlit, allowing for usage in low-light conditions, making it convenient during nighttime monitoring of children's temperatures.

Furthermore, the device includes a memory function that can store multiple temperature readings, assisting users in tracking fever patterns over time. This feature is invaluable for caregivers and healthcare providers as it allows for better assessment and decision-making regarding treatment plans.

In terms of accuracy, the Omron DR 170 14 is equipped with advanced measurement algorithms that enhance precision in readings, positioning it as a reliable option for temperature measurement. The thermometer can measure not only body temperature but also surface temperatures of objects and liquids, providing versatility beyond just clinical settings.

Another notable characteristic is its compact and lightweight design, which makes it highly portable and easy to carry around, whether in a medical bag or a home setting. The thermometer is also powered by batteries, ensuring that it remains operational even in case of power outages.

Overall, the Omron DR 170 14 stands out for its combination of modern technology, ease of use, and reliable performance. With its non-contact functionality, rapid readings, and memory features, it serves as an essential tool for anyone needing accurate temperature assessments, whether in a clinical or home environment. The thermometer exemplifies Omron's commitment to creating healthcare solutions that are not only innovative but also accessible to a wide range of users.
Top Page Image Contents