Omron DR 170 14 Writing Values to the DAServer from Excel, =POKEchannel,itemname, DataReference

Page 54

Klinkmann Automation Omron Ethernet DAServer

52

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.3

17014m13

Page 53 Page 55
Image 54
Page 53 Page 55
Contents Omron Ethernet Direct DAServer User’s Guide Ver 1.x Rev DR 170Contents Contents About This User GuideIndex Introduction OverviewCommunication Protocols Application Communications ProtocolsSuiteLink FastDDE Accessing Items via the DAServerFins Message Communication NetDDEDDE/SuiteLink Features Demo ModeBefore starting the Omron Ethernet DAServer Ethernet Unit Configuration Example for CS1 PLC Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Comments on example program ladder diagram Example program for sending unsolicited data from PLCKlinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Getting Started Quickly with the DAServer To prepare the Omron Ethernet DAServerConfiguring the DAServer NewSOCKET000 by defaultAdd Controller Object To prepare the Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer To create Socket objects from the Configuration branch DASOmronEth Hierarchy in the DAServer ManagerHost Name IP Addr Port NumberTo add Controller to your Omron Ethernet hierarchy Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Configuring Device Group Definitions Device Group DefinitionsTo create or add device groups To make edits on device groups To configure default update intervals To delete device groupsTo archive configuration sets To edit update intervalsArchiving Configuration Sets Scan-Based Message HandlingDevice Item Definitions Configuring Device Item DefinitionsTo use different configuration sets from the current one Name Item ReferenceTo rename a device item from the list To create or add device itemsTo add item references To delete a device item from the listHot Configuration To export device itemsTo import device items Pnb or Pnbb or Pn.b or Pn.bb Item Name General FormatPnS Pn-PhSFloating Point Format IEEE/BCD BCD FormatLong Format Signed/BCD Ascii Strings FormatRead WriteImortant Note CS1/CJ1 PLCs = a To M= a Klinkmann Automation Omron Ethernet DAServer C200HX/C200HG/C200HE PLCs CV-series PLCs PVS Flag or Bit Status Step StatusCPM2x PLCs Klinkmann Automation Omron Ethernet DAServer CQM1 PLCs DAServer Standard System Items System Item Type Description Values Name Access Rights DAServer Global System ItemDAServer Device-Specific System Items Klinkmann Automation Omron Ethernet DAServer DAServer Device-Group-Specific System Items RangeRange Generic OPC Syntax AREA10.VESSEL1.TIC1.PLC.D100YourOPCAccessPath.$SYS$Status Monitoring Connectivity Status with the PLC=DASOmronEthPLC!$SYS$Status Using DDEStatus and IOStatus in Excel Monitoring the Status of DAS ConversationsReading Values from the DAServer into Excel =POKEchannel,itemname, DataReference Writing Values to the DAServer from ExcelChannel=INITIATEapplicationname,topicname =TERMINATEchannelError Messages and Codes DAServer Error MessagesError Message Explanation Probable Cause Solution Log Flag Item Names Creating write Invalid value poked Check Item’s DASProtFail Data, received Take into DASProtWarn Fins Response Codes Server-Specific Error CodesError code Logger Message Log Flag Main Code Sub Probable Cause Remedy Log Flag HexKlinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer DAServer Architecture DAServersPlug-ins DAS EnginePLC Protocol Layer Component Environments Klinkmann Automation
Related manuals
Manual 70 pages 30.48 Kb

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