WIP – temperature cross stitch 

It’s been a month since I got keys to our first home, and I’ve completed the first month of the temperature cross stitch. The idea is to record the daily average temperature from the day of settlement (16 Dec 2016) to the first anniversary (15 Dec 2017) and have it framed and put on the living room wall. I know crocheters do temperature blankets every year but frankly I have too many blanket CALs planned as it is and I don’t have enough beds to put them on! So framed cross stitch it became.

capture

Every week I visit BOM and copy down the min/max temperature, then use a spreasheet to average it out, and use conditional formatting to automatically have the colour filled in once the average temp is calculated. Once a month I stitch in the colours, then use white to divide the months and also fill in the days where the month is not 31 days long.

The design for the rest of the stitch is still up in the air, there will be a legend for the colours and the temperature range they refer to, the months will be below each column (maybe), and the words similar to “First Year in our First Home” above the graph. I’m thinking about designing a wooden frame chart to go around the coloured months but that may not work out as well if I want the months below the colour columns so maybe that will change to a border of some sort.

 

 

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s