|
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 |
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.”
Christian Spitters, Process Technologist Innovation & Development, Smurfit Kappa Roermond
WHAT DOES IT DO AND HOW DOES IT WORK?
|
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. |
|
Compare Editions
SPECIAL DISCOUNTED PRICES FOR THE INTRODUCTION OF YASENSE EXCEL 3.0
Compared to...
a simple process
Users build a model using Excel, with typical Excel functions.
In YASENSE Excel, the Conversion Tool converts the Excel spreadsheet into a ready-to-run model. In the industrial environment only the converted model will be used, not Excel, which brings additional robustness to the solution.
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,...).
YASENSE Excel allows you to control the status of the deployed models.
The Monitoring Tool continuously monitors the performance of the models and can be configured to generate an alert in case the performance drops or the statistical properties of the model inputs change significantly.
The Monitoring Tool continuously monitors the performance of the models and can be configured to generate an alert in case the performance drops or the statistical properties of the model inputs change significantly.
use cases
With access to live plant and lab data, the possibilities are endless for easy data analysis and processing:
- Calculate the cost of production continuously
- Real-time quality monitoring
- Process control / Supervisory control
- Real Time optimization of cost / quality
- Equipment / Condition monitoring
- Continuous KPI calculations
- Easy definition of alarms
- Predictive models ("virtual sensors")
- ...
watch a video demonstration
Benefits
|
With its watchdog and advanced monitoring functions, YASENSE Excel ensures robust and problem-free deployment and operation of your Excel models, without the need for Excel to be running.
|
|
No need to learn a new programming environment: anyone who knows Excel can design and deploy models. We deliver a template excel sheet in which you can copy-paste or build your model.
|
|
Bi-directional: Streaming data can be used as input for the model, and the results can be written back via OPC or SQL
|
|
You have full control and understanding of the model, it is not a black box.
Easily and quickly maintain the model yourself in case of changes in production, no need to pay and wait for vendor services for model changes. |
additional 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.
some customers of yazzoom
Click here for the free trial!
Free Trial!
