Inside FlixBus, most of the processes and calculations took (take?) place in a spreadsheet. Not only the complex line planning, the settlements, but also evaluations, project management and much more. Excel is a great tool, but not for everything.
In 2019 I worked for FlixBus. A German company that convinces bus companies to invest in material (buses) and drivers to participate in a network of international lines they manage and promote. The settlements - as the 'invoices' are called - are easy to manage, however hard to understand for anyone not deeply involved in the FlixBus logic. The complexity partly derives from it's starting point, an Excel sheet.
All companies I visited used Excel sheets to manage their bus business. The FlixBus logic fitted their expectations. Nobody complained about it.
In september 2019 I got fired. It was true, I did not like the business case logic. The Excel files where not smart, used vague assumptions and lacked precision. Nevertheless the business development team was able to work with it and could convince companies to invest. Partly because bus companies did not understand their own numbers, nor the Excel file and used a rule of thumb that did not fit the FlixBus logic. Most of them underestimate the cost part of the business case. This only became clear over time. At the beginning nobody knew.
During the Corona period I became a Coda.io expert. Today I bring this expertise into play to support bus companies. I help them to serve their clients better, faster and cheaper and to make smart decisions. Coda.io is a doc with database like functionalities integrated. Data flows in, you click buttons to confirm and the rest is taken care off based on your preferences we extensively discuss before integrating.
|Learn more about Coda