
Satori: from spreadsheets and Power BI to routing software sold to shipowners
A good idea stuck in spreadsheets
D-ICE Engineering wanted to offer its clients a routing tool: finding the best route for a ship according to the weather.
The calculation existed, but it ran on spreadsheets and Power BI. Weather data was imported by hand. There were calculation errors, nothing to visualise a route, and comparing two routes was a headache. A study took several days. Impossible to put it in a client's hands.
Taking over the existing tool and turning it into a product
This was not about starting from a blank page. A first tool existed: we took it over to complete it and make it ready to roll out to D-ICE's clients.
3 months of work.
- Route calculation, automated
- Route comparison according to the weather
- New features
- A new design
Before / after
Weather imported by hand
Calculation errors
No visualisation
Several days per study
An internal tool
Automated calculation
Reliable calculation
Routes can be seen and compared
A few minutes
Software distributed to dozens of clients
What it changed
- A route study in 7 minutesInstead of several days.
- About 15% fuel saved per voyageFor ships that follow the calculated routes.
- Hundreds of thousands of routes calculatedFor dozens of clients.
The solutions behind this project
Payout calculation and distribution, once done by hand in Excel, is now automatic. Delivered in 21 days.
Next caseThe usage of 50+ Satori users, once copied into Excel every month, now tracked in a dashboard that shows the amount to invoice. 10 days.
An internal tool that could become much more?
If you have a calculation or a process that runs on spreadsheets and deserves better, show it to us in 30 minutes.