Automating the calculation process by linking Excel sheets to SCIA

Many Excel sheets are used in construction to do calculations. A lot of time and energy has gone into developing the sheets, especially to get it verified and validated afterwards. Heijmans has linked the Excel sheet with reinforcement calculations for concrete cross-sections to SCIA in an application on the VIKTOR platform for the reinforcement of slabs. For example, fewer numbers now have to be copied, so that one can work more efficiently and the risk of error is reduced.
Download the White Paper and get INSPIRED

Learn about the trends on digital transformation and how to take the next step.

Collecting everything in one place

Roland Snelders has been involved in the development of the concrete slab reinforcement application for Heijmans. “We could read the internal moments from a SCIA file and these were collected in the report, usually in a table. Then those moments could be entered in Excel and the reinforcement was determined and tested in an iterative process. That calculation was therefore copied to the report. ” This way of working could be done more efficiently. It would be easy if copying numbers is no longer necessary, because everything is collected in one place.

No more copy + paste

That's exactly what the application they created does. Snelders: “From SCIA we can now export an XML file and read it into the application on the VIKTOR platform. The Excel sheet is also linked to this. After selecting the concrete cross-section data and various reinforcement options, I get a picture with colors that indicate where the reinforcement should be.” This ensures that you go directly from the SCIA file with a once-off data entry to a visualisation of the results that come from the Excel sheet, without having to copy anything.

Centralizing data

The Excel sheet has not been completely transferred into the application, but rather has been linked to it. This has the advantage that it does not have to be recreated, which would then have to be validated. In addition, all manufacturers know how to make a calculation in Excel, you can still continue to do that. “The application ensures that everyone now works with the same Excel sheet, since it can only be opened centrally,” says Snelders. This significantly reduces the risk of errors.

General use of the application

The application can be used in any construction that contains a slab, for example a floor, a wall, a roof or a bridge. “Initially, only rectangular slabs could be calculated and analysed, which was a major limitation,” says Snelders, “This has now been improved to allow for all types of slab shapes to be calculated.” The application is made by developers of VIKTOR, because Heijmans did not yet have the required knowledge to do it themselves.

Excel and SCIA connected.png

Partial automation for now

This is the beginning in terms of automation. "For the time being it is not going to be possible to calculate entire constructions completely, because there is a lot of variation in every project." Snelders explains, "But it is very useful to have components of that construction automatically calculated." There is less variation in the components themselves, so they can be calculated perfectly with an application. This allows the structural engineer to have more time for the more complex and challenging aspects of his/her work.

More space left for challenging work

Snelders: “The application makes work more fun. I do not find completing an Excel sheet challenging work. ” When filling in cells and copying data, a structural engineer adds little knowledge to the process. Where they do add knowledge is during the schematisation of the construction and the making of a calculation model, in order to subsequently arrive at an optimal and practical choice of reinforcement. "That work still remains, we have mainly automated the repetitive calculations."


Related Customer Cases

Optimal pile foundation design saves tons of CO2

Read more

Automating the design of the longest immersed tunnel in the world

Read more

The Digital Engineering Community is Accelerating

Read more