📝 “Time spent in reconnaissance is seldom wasted” – John Marsden

I sometimes wonder if my strength of just diving in and getting it done is sometimes a weakness. Today I was given a spreadsheet with roughly 40000 rows to review. I started out adding in a few conditional formulas to use colour to break up the data. However, I soon realised what 40000 rows actually meant. I therefore decided to take a step back and think about how I could clean up the data. I spent sometime trying a number of approaches. After a few hours, I managed to hone the data down to roughly 4000 rows. This was a lot easier to review. It was all a reminder that time spent in reconnaissance is well spent.