Heijmans: “With the connection of Excel to SCIA, we work more efficiently and the risk of errors is reduced”

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 have to be copied, so that one can work more efficiently and the risk of error is reduced.

Automate the boring. Engineer the awesome!

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.

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.

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.

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.

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.

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.”

Follow us on LinkedIn

More To Explore

Customer cases

DMC: “Create more insights for the customer at Xbloc”

Delta Marine Consultants (a subsidiary of the organisation BAM) has developed a special concrete breakwater element called Xbloc. These concrete blocks are placed on a breakwater to protect them. DMC has developed tools to determine the layout of the Xblocs on the breakwater. However, these layouts are unique for every case.

Customer cases

WTOP: “An algorithm makes designing noise barriers much faster”

Everyone probably recognises the noise barriers found along (rail) roads. At WTOP infrastructure, they specialise in the design and engineering of noise barriers along roads and railways. In 2014, WTOP infra switched to designing and drawing in 3D. It became increasingly clear how important it is, especially for more complex projects, to deliver complete 3D designs as soon as possible so that they can be incorporated into BIM.

Do you want to boost your business?

Drop us a line and keep in touch