You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Hi
I'm a Geography teacher and would really appreciate your help if you live in the UK.
Please go outside and measure the depth of the snow at your house in cm.
Open this spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0Agsl0Wd0Ys37dDhhRXZyY1gwbUwwVVEzdDBkTVljZ3c
Fill in the first bit of your postcode as shown, then the snow depth at your house in cm. It will automatically fill in the lat/long column.
It saves automatically, so you can then just close it.
I am going to use the data to make a pretty map!
Thanks for your help,
GB
i can't edit
It doesn't let me add data, so CA13 = 0cm
N4 = 8cms
can't do it
but. BD20. 2 cms snow
S 12 = 0cms
can't edit spreadsheet..
SK2 = 3cm
Couldn't work out how to enter the data but it's
AL4 14.5cm
ol12 5cm
S6, 8cm
G75 0cm
FK6 none
Hi
I've ticked the box now! It's now editable by anyone.
GB
AL5, 13cm
Done. DY8, 4cm but melting fast.
bs32 - 0cm
done - eh45 ocm
Done. RH11 has 10cm.
GU21 6cm.
As usual, CW8 gets nowt. Are we going to get to see the results of all our hard work?
KA5 0cm
I'm just trying to figure out the best way of displaying this data - Excel used to be able to do maps but only on pre-2002 versions. I have played with GE graph before and so may try that.
I'll keep you posted....
GB
ST5 8.5cm
done - put zero, unless you want to count 1cm of slush for about 3hrs 🙁
(SO51)
I've been playing on Google Fusion, which until 30mins ago I didn't even realise existed...
Here is the first go (Red = lots of snow, green = no snow):
[img] 
[/img]
You should be able to post a live URL to that (I Think)
Google Fusion? That's far to easy. Convert lat/long to os grid, plot as x,y graph, overlay map of GB. Much better. You kids have it far too easy.
So all the soft Scots and Welsh have been spared then ?
Just as well us tough South-Easterns can take it.
I tried that on Excel but this just seemed better?
If anyone knows how to make my Fusion table auto-update from the spreadsheet everyone is typing into I'd be very grateful...
GB
dn8 14cm
Done CH64 = 0
OK - I've had a hunt around and the Fusion Table won't update itself from the Google Spreadsheet. It's a feature that's been requested a few times though, so maybe in the future. I can just delete all data and reimport every now and again.
Your map pretty much reflects the predicted forecast/snow warning :
done N7
Ernie - thanks for that - a great find!
GB
you do have to smile at a severe weather warning for 7-12cm of snow
luckily the Southampton area was spared this armageddon scenario
SA1 0cm nada zip nowt zero
BN8 = 10cm's
Sledging was great this morning but melting now.
AB24 = 0
NG13 = 8cm
Here is the latest update:
Red = loads, green = none
[img] 
[/img]
The Sponsor - what's your postcode?
GB
Gee - It's OK it's now filled in but got N/A# first time
Someone in Southampton is telling Porkies............
If you all want to post the link to the spreadsheet please do - the more points the better! I'm going to get the kids playing with the data on Monday.
GB
Nice work gee!
Looks like the kids are really lucky to have you as a teacher.
done, tw8 8cm
[img] 
[/img]