SPPA Architects simplify reporting complexity

Merging and calculating key figures

The architectural office SPPA provides various planning services in the field of architecture. Architectural services (without construction management) are provided directly by the firm’s own employees.

SPPA not only provides engineering services, but also acts as a general planner. SPPA provides all necessary planning and construction services directly for the client. If external services are required, SPPA commissions sub-planners.

sppa-architekten-reference-1

The SPPA architecture office was able to benefit in particular from the following advantages:

  • Many years of experience in the implementation of web applications
  • Fast implementation of user management and reporting with the help of existing EPS microservices and libraries
  • Very structured and transparent way of working and documentation of all work and decisions
  • Close cooperation with the customer and short feedback cycles for optimum quality assurance
sppa-architekten-reference-2
  • Replacement of existing separate Excel solutions for project controlling contract data, expense and revenue forecasts
  • Automatic calculation of key figures
  • Automatic transfer of data from accounting software and time recording system
  • Evaluations across the entire company, e.g. number of employees required based on the effort forecast
  • Elimination of the media break between project controlling and forecasting
  • Reduction in the number of Excel sheets and complexity
sppa-architekten-reference-3

EPS Software Engineering AG analyzed the requirements together with the customer and developed the ProCon web application.

During the implementation, EPS Software Engineering AG was able to draw on tried and tested components from the EPS library set (e.g. user authentication, background services, login, etc.) and many years of experience in the implementation of web apps.

The solution was divided into 4 components, a React web application, a .NET backend API application, an identity service and a reporting service.

The master data required for project controlling is synchronized and created by the backend through an import job of customers and vendors in CSV format.

Projects can be managed in the UI and expense and income forecasts can be created. The data is stored in an SQL database via EFCore.

Various templates for reporting the evaluated data in Excel or PDF format were created using the EPS Reporting Service.

By setting up an automated build pipeline, unit tests are carried out for every new change and new test and release versions are created automatically.

sppa-architekten-reference-4

Project management

  • Jira
  • Confluence

Infrastructure

  • Bitbucket Buildserver
  • Git

EPS Components

  • EPS LibrarySet C#
  • EPS Microservice Identity (IdentityServer4)
  • EPS Microservice Reporting (Telerik)

Frontend Components

  • Node JS
  • React

Microsoft Components

  • .NET6
  • Visual Studio 2022
  • Visual Studio Code
  • Microsoft Azure
  • SQL Server & EFCore
sppa-architekten-reference-5

Similar Projects

Get a quote

tranSvias Team
Yeesss - wir haben es geschafft!!!

tranSvias LSVA ist offiziell NETS-zertifiziert!

Herzlichen Dank unseren Pilotkunden für ihre Geduld, das ehrliche Feedback und Vertrauen!