Use Excel as SCADA

image_0aaab037-b614-44ac-82e9-dee3fa0242462520

You can use Excel to be SCADA buy using COPC32 ActiveX control to read and write data to OPC Server.

Download Excel SCADA example file here

First sheet shows real-time trend and gauge displaying data from OPC server.

image_d287b26f-984c-4fa7-865c-e475d1e2cca43187

Second and third sheet shows graphic animation and parameters.

image_83c9bfec-6f87-45da-af8c-708f1da802241840

image_056f69e2-4a08-4d23-bb33-b498e27a6f9724489

4th sheet shows raw data from OPC server.

image_d1b76641-ced4-4f41-bff9-97ae07f0eb4126926

 

How to use example file

1. You need to install COPC32 before (Download COPC32 Demo here ).

2. Open example file (COPC32DEMO.xlsm). If it is security warning, click enable content.

SecurityWarning

For Office 2007, In the Security Warning bar,
click the Option button to Enable this content.

SecurityRibbon

In the Security Warning bar,
select Options button > Enable this content > OK

 

3. At sheet “Main”, get in to design mode by click on  “Design Mode” icon on Developer tab.

commandbutton[3]

Then right-click on “COPC32” control to select OPC server and OPC tags (in this example use 3 tags).

image_66d0f984-756a-483f-a768-d5dac823c6b025611

Specify desired OPC Server on “OPCc_Server” tab and desired OPC tags in “OPC_Tag” tab. In this example, we use 3 tags.

image_cfb2e85c-9b44-4432-bc98-be39add14fdb8936

 

4. Exit “Design Mode” then click “Connect” button on sheet “Main” to start working (you can also programming to automatically start).

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s