Saving values to external file

[krotzer]

I have two questions:

1. Using a Micrologix 1000, can I turn on and off certain functions based on the time of day? I've searched for a clock function to use and am coming up empty-handed.

2. At the end of each day I would like to transfer information from my counters and timers to an external excel spreadsheet/database. Is this possible and how can I get started?

Any help is appreciated.

Thank you,

Ty

 

[ztransform]

I'm not familiar with Micrologix 1000, but with other AB PLC's you can set up DDE links in you spreadsheet to read specific registers through RSLinx. Another other option invovles custom VB program with OPC or DDE link to data files.

 

[ADMIRALKEN]

The lowest AB processor with a real time clock is the ML1200, and you must buy and install a 1762-RTC module. For data collection in Excel you must have something other than RsLinx lite, the lite version doesn't support DDE or OPC.

You might find some interesting examples here:

http://forums.mrplc.com/index.php?dlcategory=3

 

[marshg]

If you have to trasfer data to an excel sheet, then you can use Excel's VBA to get the computer's date and time. When you transfer data to excel, it will create a 'change' event where you can move the date and time values into some PLC registers and keep track of the time in the PLC by monitoring these values.

To transfer data to/from excel, you set up DDE or OPC topics up in RSLinx. I think you need RSLinx Professional to use OPC and DDE.

Hope this helps.