The first step toward systematization begins with "careful requests."

Thank you for your hard work today as well.

I feel that being able to dedicate time to work efficiency today was a major point.

Until now, I had been performing the task of looking at an Excel table with dates for next week's schedule and moving the relevant information to another Excel file.

However, I always thought that this task could definitely be automated.

So, I proceeded while asking ChatGPT.

My goal image was,

to automatically extract next week's dates and output the corresponding information and tasks as a table.

That was it.

It involved reading dates, task names, and outputting various information associated with those tasks.

Also, the original Excel data was a bit complex, with cells sometimes merged and sometimes not, and dates written on even-numbered rows.

I decided to do it one step at a time, because if I made all my requests at once and it ended up in a mess, it would be a hassle to fix.

Through my conversation with ChatGPT, it became clear that it would be best to automate the Excel file by creating code called VBA.

First, I carefully wrote to ChatGPT,

The dates are written in even-numbered rows of column O, and the task titles are written in column O, spanning two rows. Please extract the tasks for next week's dates and create a table.

I wrote it like that.

Then, I pasted the VBA code into the Excel standard module and executed it.

It didn't work a few times, but as I explained the situation in detail, it started to take a good shape.

And after confirming that the task names were appearing correctly, I increased the information to be output one by one, such as Information A, Information B, etc., and proceeded reliably.

It was a repetition of making a request, copying and pasting the code, executing it, and making a request...

I felt that if you write your requests as carefully and detailed as possible to make them easy to understand, and have the determination to keep going until it's done, you can do it.

I had a vague feeling that if I just kept at it, I would eventually be able to do it, but I think the reason I felt that way was probably because I had read this book.

And, in the middle of that trial and error, my boss came over to me, so

I showed them the situation, saying, "I'm making something like this right now."

Then, they said, "Oh! That's great!" and I thought, "Yes!"

After some trial and error and getting it organized, I felt a sense of accomplishment, and even though it was already finished, I kept opening that Excel file over and over again.

By doing this task this time,

・Eliminating oversights
・Saving time on creating next week's schedule
・Since this system will remain even if I'm not here, it will also help people in the future

These are the effects that are expected.

In particular, once you create a system, everything else is easy. It's wonderful that it saves time and helps others.

So, from now on, I will continue to keep an eye out for things that could be systemized or automated.

I wanted to keep this experience as a success story within myself, so I wrote it down here as well.

Is there anything you would like to systemize?

Thank you for reading again this time!