Hackies

Problem: Employees struggle to find suitable transport, often overlooking the EV fleet and mixed transport options. They must manually re-enter transport data into SAP, risking errors like misspelled locations that harm analysis. At year-end, they report kilometres by transport mode, but mixed-mode trips lead to poor estimates. The current process is time-consuming, error-prone, and fails to leverage available sustainable resources.

Solution: We use the current EV fleet to find the closest branch along the optimal route from A to B. Then we analyse the trade-off between added travel time and saved emissions. The algorithm is based on revealed preferences—now based on our input, but it could be personalised per employee. We also autofill names, routes (car and non-car), and log the exact distance by mode in a database, which can be linked to SAP via API.

Impact: The impact of our solution goes far beyond significant cost savings for Česká Spořitelna. It also saves employees valuable time by finding the optimal routes and transferring travel data into SAP. Employees avoid long trips in their own cars by using EVs, reducing wear and preserving their car’s value. Lastly, our solution helps the planet by cutting CO₂ emissions. If just 25% of 2023 business trips had used EVs via our system, it could’ve saved 1,000 trees and over 1 million CZK in fuel.

Feasibility & financials: Our solution can be seamlessly integrated into SAP, utilizing data that is already being collected. It leverages the Google Maps API, which is a cost-effective tool, ensuring minimal implementation expenses. Overall, the solution has the potential to generate savings of up to 4 million CZK.

What is new about your solution?: We created a centralized system for planning routes, integrated with company data on electric cars, this has not been done before. We simplified the process of searching for possible routes and made it simple to compare different alternatives. We included data such that these comparisons can be made not only on time efficiency but also on cost and carbon emissions. We created a website that allows for the use of these functions.

What you have built at the hackathon - text explanation + code (e.g. GitHub link): Team development code: https://github.com/dominik-sv/TripPlanner.git Production code: https://github.com/typekjezeqcz/hackathon_next.git

What you had before the hackathon, please mention open source as well: We began creating everything related to this project at the hackathon. We used the Google Routes API and Google Maps API for finding the best routes between two points and for showing us the possible means of transport between them. We used the Česká Spořitelna API to get a dataset of all the branches in the Czech Republic. We also used data provided to us by Česká Spořitelna on business trips conducted by employees in 2023. We used Vercel for web hosting.

What comes next and what you wish to achieve: Next, we plan to enable in-app train ticket purchases through centralised procurement for better pricing. We aim to launch our internal reservation system to support car sharing between employees and boost efficiency. Finally, we plan to finish the integration of branch vehicles with public transport to offer the fastest combined routes—an innovative solution not available elsewhere.