Using the power of Excel for machine data

Excel has been an essential tool in industry for decades. But what exactly makes Excel so useful and how can you utilise its strengths for your machine data?

Content overview

Easy handling and flexibility

Excel offers an intuitive user interface that appeals to both beginners and experienced users. You can easily enter and edit data manually or use our DataSuite software to automatically read data from the machine control system. This makes Excel a flexible tool for various areas of application.

Display lots of data clearly

You can create complex data analyses and visualisations and use them to efficiently manage and analyse large amounts of data. Excel offers many functions and templates for this, such as pivot tables. The Excel slides created can be displayed as a website with simple clicks using the DataSuite or used as a dashboard to share data from the PLC with others.

Everyone knows and can use Excel

As Excel is often taught at school in the 7th grade, everyone has already had contact with Excel and can implement simple projects with the knowledge they have already learnt. There are also numerous tutorials, training courses and forums that can help you solve problems and expand your knowledge.

Using the power of Excel for machine data

Discover the strengths of Excel and how you can use this functionality as a power tool for your machine data.

9. July 2024

Testimonial: Print PDF file from PLC with DataSuite

The company MSB GmbH approached us with a customer project. Find out here what solution we created to print PLC data on a label.

5. July 2024

Retrofitting – Old machines with new possibilities

The useful life of solid machine technology is increased by retrofitting. Old machines and new possibilities.

28. April 2023

DataSuite News EN 1/23

You know our DataSuite software and therefore know that it is very versatile and offers many functions. In conversations with customers, I notice again and again that particularly exciting features are often not known. I have therefore compiled some interesting little-known features in this newsletter.

21. March 2023

DataSuite News EN 5/22

wouldn’t it be nice if you could provide data of machines and plants easily and quickly as web pages? Maybe even with a diagram and your logo? We have built exactly this function and many more into our [MB] DataSuite. Forget the S7 web server and use the fast and easy alternative in the form of our software.

8. December 2022

DataSuite News EN 4/22

After a long search we have found a new home. From now on you will find us in the middle of the city of Wissen (Sieg) in one of the most modern office buildings in the region.

16. August 2022

Testimonial: Print PDF file from PLC with DataSuite

The company MSB GmbH & Co. KG approached us with a problem. Labels are to be printed with a machine control system. A specific paper tray is to be used for printing, the print data is available as PDF files.

From an idea to a component of the DataSuite

Fortunately, Mr Plaßmann asked us for advice first. Our DataSuite software has had a print function for some time. This means that Excel files or individual spreadsheets could be printed out without any problems. However, he would like to print a PDF file. Until now, this was not part of the software. No problem for us: we have expanded our software entirely according to the customer’s wishes.

Alternatively, Mr Plaßmann could have had customised software developed. This would have been considerably more expensive and would have taken several weeks, if not months.

"It was the right solution for us at the right time." (translated)

Mr Plaßmann from MSB GmbH & Co KG

Planning and implementation

It was easy for our team to develop this new function and implement the requirements, including tests, in a short space of time, enabling Mr Plaßmann to complete his project successfully and on time.

The function is now included in DataSuite from version 3.4.4. and is accessible to every user.
With just a few clicks, you can now print CSV, XLSX and PDF files from the machine control system and save yourself a few manual steps.

"We are all delighted with the software and the simple, easy-to-adjust parameterisations as well as the integrated interfaces, including to the PLC. It was the right solution for us at the right time." (translated)

Mr Plaßmann from MSB GmbH & Co KG

Do you also have specific requirements?

Our DataSuite software is very universal and can be used in a wide variety of applications. Over the last few years, the range of functions has increased from year to year. It is very likely that your industrial data application can also be realised with the DataSuite software.

If not, you are welcome to contact us at any time with an enquiry:

Free and non-binding enquiry

Anleitung zum selbst testen

In unserem anderen Blog “PDF-Dateien aus der SPS heraus drucken” finden Sie eine Anleitung, wie Sie es selbst testen können, um Ihre Druckprozesse automatisieren zu können.

Hier geht es zu unserem Blog: (kommt noch)