Automate everything! Automate it yourself! Together with AI!
At the beginning of my career, as a consultant for SAP Transportation Management, I performed several tasks to collect information - distances and durations between points A and B using Google Maps.
The exercise was simple:
-Ctrl+C from an Excel file with addresses,
-Ctrl+V - in the start of the journey field,
-Ctrl+C from the file,
-Ctrl+V - in the destination field,
-copy or remember the distance values between these points and the planned travel time,
-enter these values in Excel .
Not difficult.
But we were collecting this information for a transportation network, which means that we needed data “all points - to all points”. In both directions. When using 50 locations, this was 2450 times of repeated actions. We did not know how to use GIS at that time.
So we did and suffered. :)
From time to time, I am remembering this experience and had a desire to somehow automate this process. Not for the sake of a current need, but to prove to the past that it could have been done easier.
Smarter.
Faster.
Simpler.
And, behold, the time of accessible AI has come. The first attempt at programming with its help was successful. Therefore, I decided to close that long-standing case for myself.
And I started with what I wrote in Copilot: “Write a program in Python that…”, and then what I usually write in the specification for developers.