Illustration
Oleh Ihnatenko
SAP TM Consultant

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. 

Illustration

 I used a step-by-step development method to make it easier to test intermediate results and understand how the program works. I asked what some parts of the code meant.

“Write the first functionality…”
“Write the second functionality…”
“The code in line X does not work and gives error Y - fix it.”
“Change the implementation using the API to read directly from the site.”
“Optimize this part of the code...”
”What does this code do in a line?”
“I changed your code - check and change here...”
“Combine these programs to get this result...”

As a result of several iterations of updating and developing the code - I got a working program that did exactly what I used to do by hand. Not quickly. But without monotonous manual labor! In case of anything - I can run it and go have a coffee, take a walk, read an interesting book while the task is being performed.

Of course, in reality everything was not as simple as described. I had to, at least superficially, study a few relevant things, experiment, overcome the mistakes that AI regularly made in the code, consciously test intermediate results for optimization and error correction. Change the wording of the task and explain it more thoroughly, because if you are careless in your wishes, then you will get the corresponding result!

Of course, AI will not replace real developers for you, will not turn a person who has heard something about programming into a Senior Developer. And it certainly will not do your work for you! :)

But it can significantly expand your capabilities as a specialist, automate monotonous processes, reduce time spent and increase productivity. And learn something new!

Just look for application points.
Try.
Do.
Don't give up.
And let AI help you! 

Made with