Category Archives: guides

Pallet Garden

At the end of last year I saw some vertical gardens on Pinterest made from old pallets. The idea appealed to me, and I decided to try making my own. Fortunately there was a spare pallet on the job site where my brother was working, so he brought it home for me to use.

There are plenty of guides on the internet explaining how to make one, including this one on the Bunnings website. I read a few guides and ended up taking ideas from several. Here’s the result!

This post has become quite lengthy, so I’ve divided it into four key sections:

  1. Prepare your pallet
  2. Fill the pallet with dirt
  3. Plant your garden
  4. Make it vertical

At the end you’ll also find some handy tips I’ve learnt after maintaining the garden for a year.  Post a comment if you build one of your own or have any feedback!

Continue reading

DIY Poster Hanger

I was given a Scratch Map for my birthday. The idea is you keep track of the countries you’ve visited by scratching them off to uncover the colourful map below.  The dilemma I faced was how to hang it on the wall.

I could have blue-tacked it to the wall, but I wanted to make a feature of it.  Framing it was no good, because I wouldn’t be able to scratch it under the glass. I thought about attaching it to corkboard, but had trouble finding one the right size and custom sizes were very expensive.

Continue reading

Creating dropdowns in Excel 2010 using Data Validation and Named Ranges

At work earlier this week, I was putting together an Excel spreadsheet and wanted to include a dropdown of values in some of the columns.  I knew this could be achieved using Data Validation, but I wanted something that was going to be easy to maintain as the number of entries grew and as the list of values evolved.

A combination of Data Validation and Name Ranges seemed like the best way to go and I decided to throw together a guide.

Continue reading

Rooting HTC Desire and installing CyanogenMod7

A couple of months ago I rooted my HTC Desire and installed Cyanogen Mod 7 (CM7).  The process was a bit fiddly as I worked my way through various guides and a couple of discussions on the CM7 IRC channel, but I got there.  Now, three months later I’m doing it again on another phone, and have had to go digging through the same websites!

For future reference, I’m going to document the process here.  I’ve taken most of this from two or three other sources, which I’ll link to at the end of this post.

I’m currently running Windows 7 Professional, but when I rooted the first phone I was on a computer with Windows XP Professional.  The same steps and software are applicable for both these operating systems.

Continue reading