So I set up an I/O field, tie it to the ET on one of my timers by clicking thru the PLC program blocks to the timer I'm wanting to monitor in the HMI (if it matters any its a 45 second timer) and selecting the ET (time) option, mode set to "output" display, display format "decimal" decimal places 0, field length 3, format pattern "S999". Have a ladder program with several TON timers and I'd like to monitor the elapsed time on all of them on one screen for diagnostic purposes. PLC and HMI and laptop with TIA portal are all on a cheap netgear switch while I'm writing and revising project until I get it the way I want it. Keep in mind to close the excel window whenever new data is added, otherwise, the script won’t work and result in an error.S7-1200 CPU 6ES7 212-1BE31-OXBO V3.0 with an SM1222 6ES7-222-1HF32-0XB0 module Now you can check the new data is inserted into the excel file. Now close the Excel file and Start WinCC Runtime in Simulation mode.Įnter any values in the IO- Field and after that press the “Insert New Data” Button. Whenever I press the button new data is inserted into the excel report.Ĭonfigure the Alarm window with the following setting, it will be helpful to find any error in the script and troubleshoot it, if the code does not work as expected. Change this if you change the Excel file format.Ĭhange these tags if you want to add new tags and do not change any other part of the code if you don’t have any clear idea.Ĭonfigure the SCADA Screen with the following items as shown in the image.įor sample reporting, I have configured this button to trigger the excel data. Tag named excel row is for use of VB Script counting.Īdd a new VB Script and copy the code from this article.Įxcel file Starting cell number of every tag. Here we have added three tags as an example Flow, Pressure, Temperature. Export Data from WinCC Runtime Advanced into Excel Many a Times when you want to develop sophisticated and perfect SCADA with many features then to enable that features you have to use scripting language.Why do we need to use any scripting language in SCADA? It is very commonly found scripting language in various SCADA System such as Siemens, Schneider, Indusoft, AVEVA etc.VB Script is programming language developed by Microsoft.This article will focus on the usage of VB Script to log data into an excel file. These data can be of any type such as Batch Data, Alarms log, Process Data, Utility Data, etc. Data reporting is a very crucial process in Industrial Automation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |