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

Page 57

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

Image 57
Contents Ver 1.x Rev DR 170 Omron Ethernet Direct DAServer User’s GuideContents Contents About This User GuideIndex Overview IntroductionCommunication Protocols Application Communications ProtocolsSuiteLink Fins Message Communication Accessing Items via the DAServerFastDDE NetDDEDDE/SuiteLink Demo Mode FeaturesKlinkmann Automation Omron Ethernet DAServer Before 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 Example program for sending unsolicited data from PLC Comments on example program ladder diagramKlinkmann Automation Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer To prepare the Omron Ethernet DAServer Getting Started Quickly with the DAServerConfiguring the DAServer NewSOCKET000 by defaultAdd Controller Object To prepare the Omron Ethernet DAServer Klinkmann Automation Omron Ethernet DAServer DASOmronEth Hierarchy in the DAServer Manager To create Socket objects from the Configuration branchHost 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 Enabling Software License Key for DASOmronEth Device Group Definitions Configuring Device Group DefinitionsTo make edits on device groups To create or add device groupsKlinkmann Automation Omron Ethernet DAServer To configure default update intervals To delete device groupsScan-Based Message Handling Archiving Configuration Sets Configuring Device Item DefinitionsTo archive configuration sets To use different configuration sets from the current oneName Item Reference Device Item DefinitionsTo create or add device items To add item referencesHot Configuration Klinkmann Automation Omron Ethernet DAServer PnS Item Name General FormatPnb or Pnbb or Pn.b or Pn.bb Pn-PhSLong Format Signed/BCD BCD FormatFloating Point Format IEEE/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 Step Status Flag or Bit StatusCPM2x PLCs Klinkmann Automation Omron Ethernet DAServer CQM1 PLCs DAServer Standard System Items DAServer Global System Item System Item Type Description Values Name Access RightsDAServer Device-Specific System Items System Item Type Description ValuesKlinkmann Automation Omron Ethernet DAServer Range DAServer Device-Group-Specific System ItemsRange AREA10.VESSEL1.TIC1.PLC.D100 Generic OPC SyntaxYourOPCAccessPath.$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 Channel=INITIATEapplicationname,topicname Writing Values to the DAServer from Excel=POKEchannel,itemname, DataReference =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 Error code Logger Message Log Flag Server-Specific Error CodesFins Response Codes 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 DAServers DAServer ArchitecturePlug-ins DAS EnginePLC Protocol Layer Component Environments Klinkmann Automation
Related manuals
Manual 67 pages 16.17 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.