SLC5/04 & Excel Query

- B
- BIGEYE
  
  Contact options for registered users
posted
16 years ago

Tue, Nov 15, 2005 8:49 PM

A number of years ago I wrote a Lotus 123 spreadsheet (with some help), that
monitored in real time, analogue inputs to a Modicon 984 PLC.
Each cell was set up as a Datalink Link, for example
@DATALINK("view","tagname","tonnerate").
Is it possible to do this with an Allen Bradley SLC5/04 PLC and Excel?
TIA

- B
- BIGEYE
  
  Contact options for registered users
posted
16 years ago

Tue, Nov 15, 2005 8:51 PM

Another cell formula we used was @DATALINK("modbus","plc1","41120")

- D
- Dimitrios Tzortzakakis
  
  Contact options for registered users
posted
16 years ago

Tue, Nov 15, 2005 10:39 PM

-- Tzortzakakis Dimitrios major in electrical engineering, freelance electrician FH von Iraklion-Kreta, freiberuflicher Elektriker dimtzort AT otenet DOT gr Ï "BIGEYE" Ýãñáøå óôï ìÞíõìá news:437a4a4e$0$23290$ snipped-for-privacy@news.zen.co.uk...

New weight-loss scales;instead of just measuring your fat, with a 400 kV blast literally ``burns``it.Prolonged usage may result in high electricity bills.

- A
- A. Paul Montgomery
  
  Contact options for registered users
posted
16 years ago

Wed, Nov 16, 2005 3:18 AM

Yes. I do not know what exactly the command is. It would depend on which ODBC drivers you have loaded. Both Labview and Wonderware have knowledge databases which describe in detail the commands necessary for the SLC family. I'm assuming that your question was more towards what the command actually is tho. Maybe someone here will know this off hand.

- M
- MARK
  
  Contact options for registered users
posted
16 years ago

Wed, Nov 16, 2005 4:24 PM

Check out

formatting link

for a Serial DF1 or DH+ ActiveX Control compatible with SLC5/04 that can be embedded in your Excel spreadsheet.
You will need to implement a very small amount of VBA code.

SLC5/04 & Excel Query

Further Reading

SLC5/04 & Excel Query

EXCEL CALCULATION SPREADSHEET

Launch an Excel Spreadsheet from AutoCad?

15 Years ago....

Twenty-two years ago

linking a spreadsheet

29 years ago today

64 years ago today!

A new way to display your Excel calculations

80 years ago today

Material Database and Excel

123 blocks

Making tools 300 years ago

Just think, 40 years ago...

Field Engineer - Instrumentation & Controls (Job #280)

driving an inductive load with a relay