Digital Rail are responsible for producing Safety Cases for the Manchester Metrolink Tram Management System (TMS). With almost 30 sites to cover, we opted to use Microsoft Office tools to streamline the production of the site Safety Cases – each of which has an identical document structure based on EN50129,
The tool was developed in Excel + Word + VBA. We created a template in Word which uses tokens that are replaced by values from an Excel spreadsheet. The tool also integrated with the client Document Management System and DOORS.
The tool also provides management facilities to track progress for document production for each site. We estimate that this approach has saved 20% on project costs and we are currently investigating further uses of this approach on a wide range of projects.