Computers save you time & money

While working on my new book I’d come to the point where I needed to merge the data from 6 different sources into a single file, creating one master list for each month for the years 2008-2012. I’d assumed this would be perfectly easy and not take very long – maybe a day or two at most. Boy was I wrong.

There are around 72,000 entries that need sorting in total. I tried doing it by hand but soon realised that it was extremely tedious, extremely slow, and would take about 3 weeks to do all 60 months. The deadline is tight enough as it is – I’m hoping to have the book on sale at the Winchester Writers’ Conference at the end of June – so this was an unexpected delay I could really do without. Surely a computer could help with this task?

Unfortunately it wasn’t just a case of copying the separate files into one long list and then sorting them into order. They were all in a specific format – lots of brackets and things – that made sorting impossible – and I wanted to retain that format at the end.  The data needed sorting on two criteria: number of years old and day of the month. Plus there’s the additional problem that Excel isn’t too happy about handling historic dates – and some of these are over 1,000 years old.

I started playing around with a few ideas in Word, Excel and EditPad, using advanced search and replace and macros, and manually copying the data from one application to another as it completed the various reformating and sorting stages it needed to go through.

After a couple of hours of trying different things (and getting it wrong and trying again, or coming up against a limitation in the software) I’ve finally come up with a method that works reliably. I can do each month in around 5 minutes, or about 5 hours in total. Much better than the 3 weeks it would otherwise have taken. And I can listen to internet radio while I’m doing it, since it doesn’t take a lot of thinking about.

Think about this another way: time is money. I normally charge £25 an hour for my publishing service, and if I’m working on this book then I can’t be do any publishing, so I’m losing money. If this little sorting project had taken me 3 weeks, working 7 days a week, for let’s say 8 hours a day, that’s a total of 168 hours or £4,200.  Instead it’ll take 5 hours or £125. So in the 2 or 3 hours it’s taken me to get my head around this stuff (let’s allow £75 for that too) I’ve saved myself £4000 (or 4 times what the computer cost). Not bad for an evening’s work.

How many times has your computer paid for itself?

Advertisements

One thought on “Computers save you time & money

  1. The only ‘job’ in which I’ve used a computer was as a parish priest – hence the quotes, since that is a vocation, a living, not a job. You can’t apply time and motion calculations to being a vicar – how would you measure more efficient praying? When does comforting the bereaved become inefficient? How long should one spend on writing a sermon that will take ten minutes to preach but possibly, through the grace of God, open someone’s heart to eternity?

    Another problem with assessing how much time and therefore money a computer has saved you is that you end up doing things which you wouldn’t have done without a computer.

    So I used to produce on my computer a service sheet every week with all the words of the service printed out. Now that was much quicker than if I’d done it by hand – I coud use templates, etc. But of course I wouldn’t have attempted it without a computer, so in fact the time I spent doing that was extra time, not less.

    That’s why the ‘leisure revolution’ promised by technology will never happen, for technology simply allows us to do more and more things, become busier and busier, piling more and more pressure on ourselves, working longer hours, not fewer.

    Mind you, if I were to write a bestselling book on my computer, it would pay for itself many times over – and perhaps I’d enjoy some of that leisure time at last …

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s