MES Model Examiner with Excel Adapter Gives Consistent Data Formats and Efficient System Integration

Embedded systems in vehicles are becoming increasingly complex. Individual components are developed in a distributed manner and subsequently integrated into a functional overall system by the OEM or first-tier supplier. This distributed process makes the need for consistent data formats and interfaces essential. The application of MES Model Examiner® with the MS Excel® Adapter allows inconsistencies to be detected and rectified automatically, resulting in shorter development cycles and making the embedded system less susceptible to error.

The challenge

In software and system development, a multitude of proprietary data is used to describe interfaces and data formats and enable exchange between development partners. In this context MS Excel® is a powerful tool that allows data to be saved in a structured manner and exchanged automatically to a degree. In practice however, the tables become increasingly complex and unwieldy as the project progresses, so verifying accuracy and consistency manually is no longer feasible. In particular analysis across multiple spreadsheets, which is crucial in revealing the most serious errors, must be executed with the support of tools.

Consistent data thanks to MES Model Examiner® with MS Excel® Adapter

MES offers a solution that automates complex checks with Excel data: MES Model Examiner®. This tool was developed to evaluate and improve the quality of a software model early in the development process using modeling guidelines. The MES Model Examiner development team has now applied this methodology to checking data within MS Excel® tables. With the help of the MS Excel® Adapter, the consistency of the data can be assessed within a single Excel table or across multiple spreadsheets. This way, inconsistencies and deviations from defined data formats are identified and eliminated early on in the development process.

Guidelines as a basis for checking Excel tables

In order for the MES Model Examiner and the Excel Adapter to be used efficiently in a project, guidelines for Excel data are defined according to the project requirements and subsequently implemented. The MES Model Examiner can then perform automated analysis of the changing Excel data status at any time. To ensure that guidelines can be reused, they are integrated and function independently from the position of the data in the columns and spreadsheets. It is possible to modify or insert a new column at a later stage. Furthermore, a guideline check may be carried out across multiple Excel files. The Excel Adapter also provides the option of adding comments on guideline violations within MS Excel® to aid error correction. These are inserted directly into the erroneous Excel cell for improved readability.

Obtained results

The MES Model Examiner with the Excel Adapter allows large amounts of specified Excel data to be automatically checked for consistency, either within one spreadsheet or across multiple Excel documents. The high degree of automation means these checks can be applied early and often in the development process. As a result, the quality of the data pool and the system under development is increased.

Examples of current application in industry

Bernd Kunkel, Director of Gateway Development and Data Definition at Volkswagen AG sums up the benefits based on his experience, “We employed MES’s tools and expertise to improve the integration of software components in software development. Being able to quickly check the consistency of our specifications means an increase in efficiency.” As data consistency is key in many aspects of system development, MES can already visualize many more application examples for the MS Excel Adapter.