Some weeks ago I learnt one important lesson: sometimes, saving time is worse than learning a tiny bit of new.
That's complicated, I know. I'll explain...
Today I faced a task of transferring one 44 lines long and 2 columns wide Excel table into an XML format.
If you are related to IT in any way, I am sure, you've had such a challenge at least once in your work.
I had a choice:
That's complicated, I know. I'll explain...
Today I faced a task of transferring one 44 lines long and 2 columns wide Excel table into an XML format.
If you are related to IT in any way, I am sure, you've had such a challenge at least once in your work.
I had a choice:
- create one entry in XML manually, copy-paste 44 of them and then change the values inside by copy-pasting them from the Excel table - dumb but familiar and simple OR
- write a formula in Excel once to create an XML entry automatically, then drag it down to the end of the table, and copy-past the whole table into the XML file - unknown and difficult.
First option was easy AND quick. I am quick at typing and switching between windows.
Second option MIGHT be slower, and not so easy. It has an initial investment of time and brains to quickly produce results later. What's also important is that if the original data gets changed, I just need to copy-paste the new "2 columns" and my formula will recreate the XML.
My first intention was to use option nr. 1. This is a one time task, probably, next time if I have to do it I will have to write another formula, so what I DO now is not that reusable etc. But then it occured to me that the result of the DOING might not be reusable, but the result of LEARNING is definitely reusable.
Now, several weeks in the future, I can tell that I have used this small but very useful newly acquired skill several times by now, and getting better and quicker at it every time I do it.
So, next time you want to quickly do it the easy and familiar way, stop and think for a second - will it be worth spending some extra minutes on the task and do it a new way, learning something new on the way?
Now, several weeks in the future, I can tell that I have used this small but very useful newly acquired skill several times by now, and getting better and quicker at it every time I do it.
So, next time you want to quickly do it the easy and familiar way, stop and think for a second - will it be worth spending some extra minutes on the task and do it a new way, learning something new on the way?