YASENSE™ Excel: process live OPC and SQL data without learning a new language or interface
YASENSE Excel is an award-winning software package that allows anyone to turn MS Excel spreadsheets into live and robust calculations using OPC and/or SQL inputs. The result of the live calculations can be visualized in a web dashboard, or can be written to an OPC server. In this way it makes it easy to create robust live calculations in an industrial production environment.
RUN YOUR EXCEL CALCULATIONS LIVE IN YOUR PRODUCTION ENVIRONMENT WITH JUST A FEW CLICKS |
WHAT DOES IT DO AND HOW DOES IT WORK?
More and more data is collected by industries, from the production, the laboratory etc., but working with it and analyzing it, especially with streaming data, requires learning new software or new skills.
Many production, maintenance, quality and process engineers and managers already use Excel to perform calculations on production data. Unfortunately, they cannot use these spreadsheets on live production data for continuous data-driven quality and reliability improvements, because Excel is not made for robust 24/7 live operation. YASENSE Excel makes it simple for anyone to process live data and differs from other tools by its focus on the robust deployment of (existing) Excel-based computational models. “We have improved our plant performance with Yasense Excel. I love that I can fine-tune and update the computations myself without the need to program. And if needed any of my colleagues that know Excel can contribute too.” |
what makes yasense excel unique ? robustness and reliability + DYNAMIC MODELS
Many products simply focus on providing OPC connectivity to Excel, through the use of a plugin or add-on.
The problem with these solutions is that Excel has to run to process the data, which is not a reliable option in a production environment. Because the Excel sheets are transformed into robust programs, YASENSE Excel does not require Microsoft Excel to be running. Deployed models also restart automatically in case the underlying computer or server restarts, and a monitoring system controls the proper functioning of the computational model continuously. Finally, we have added extra functionality to Excel that enables you to create and test dynamic models. A dynamic model is mathematical model who's outputs not only depend on the current inputs but also on previous (delayed) inputs. |
It takes an (existing) Excel spreadsheet and converts it into a robust executable program (in fact a Windows Service that we call the Yasense Excel "Runtime") that continuously calculates the results of the spreadsheet based on OPC or SQL inputs.
Since Excel is only used to describe the data processing and does not need to run afterwards, YASENSE Excel offers industrial-strength robustness for on-line 24/7 operations. The calculation results are published on the industrial network using OPC and/or shown in a live web dashboard. That dashboard is also defined in the Excel file, so there is no need to learn new software tools. The OPC outputs can be visualised, used for automatic process control, for continuous monitoring and alarm generation… YASENSE Excel opens up a whole new area of production optimization opportunities. |
a simple process
-
Model
-
Convert
-
Deploy
-
Monitor
<
>
The user chooses which models to deploy, start or stop using YASENSE Excel. The models run inside the Runtime Module.
YASENSE Runtime Module is a robust online runtime platform with watchdog capabilities that runs the model and interfaces with the PLC/DCS/SCADA of your plant or laboratory, for example over OPC or SQL. Inside the PLC or DCS program, the YASENSE virtual sensor manifests itself just like any other function block like Subtraction or PID function blocks: a module with some inputs, outputs and parameters that can be easily configured and maintained by any PLC/DCS programmer.
The system is also expandable with pre- and postprocessing in the PLC or DCS (filters, averaging, limits, safety values, dynamic models,...).
YASENSE Runtime Module is a robust online runtime platform with watchdog capabilities that runs the model and interfaces with the PLC/DCS/SCADA of your plant or laboratory, for example over OPC or SQL. Inside the PLC or DCS program, the YASENSE virtual sensor manifests itself just like any other function block like Subtraction or PID function blocks: a module with some inputs, outputs and parameters that can be easily configured and maintained by any PLC/DCS programmer.
The system is also expandable with pre- and postprocessing in the PLC or DCS (filters, averaging, limits, safety values, dynamic models,...).
watch a video demonstration
use casesWith access to live plant and lab data, the possibilities are endless for easy data analysis and processing:
|
Benefitsadditional benefits
Unlike cloud based solutions, YASENSE Excel runs exclusively on your computer systems so your models never leave your factory and your intellectual property is fully protected.
Simulate and test your models offline on historical data from inside Excel
Easily create dynamic models that use values and readings from previous steps. |
Click here for the free trial!
Free Trial!