J2Ski logo J2Ski logo
Login Forum Search Recent Forums

Sleeps till ski time

Sleeps till ski time

Login
To Create or Answer a Topic

Started by Ian Wickham in Ski Chatter - 2661 Replies

J2Ski

AllyG
reply to 'Sleeps till ski time'
posted Oct-2012

Far Queue has been helping me to do this as an Excel sheet, so that I don't have to count the days because Excel does it for me. And he's collected this data from the last few pages (the same as I used to do).

But when I copy and paste it into J2Ski the layout changes - it doesn't seem to like Excel much!

However, as long as everyone calculates their own number of sleeps I can still do it manually anyway, like I did last year.

So, those who can use those very clever doo-dahs, or a calendar and their fingers to work out the number of sleeps please do so. But for those that can't work it out I can use Far Queue's very clever Excel sheet.

This is what J2Ski does to an Excel sheet (but don't worry about it because I can type it in manually and make it look nicer):

J2skiers resorts and dates for 2012/2013

Geno68 Davos 21/12/2012 62
Snowy0000 Morzine 30/12/2012 71
Smartski La Plagne 06/01/2013 78
AlistairS Lech and Zurs 06/01/2013 78
AllyG Tignes 12/01/2013 84
Ian W Manigod 12/01/2013 84
Far Queue Tignes 13/01/2013 85
Brooksy Tignes 13/01/2013 85
Michelle63 Sauze D'Oulx 17/02/2013 120
Far Queue Lech 23/02/2013 126

Edited 1 time. Last update at 20-Oct-2012

Far Queue
reply to 'Sleeps till ski time'
posted Oct-2012

Removed to clean thread. FQ

Edited 1 time. Last update at 21-Oct-2012

AllyG
reply to 'Sleeps till ski time'
posted Oct-2012

I've just noticed that Smartski has put 77 sleeps for the 6th Jan, and Excel reckons it's 78.
Smartski - are you going to miss out on a night of sleep or what?

And Far Queue - I prefer it with the actual dates as well - I find all these sleeps very confusing :shock:

Snowy0000
reply to 'Sleeps till ski time'
posted Oct-2012

This is a very useful little site
http://www.timeanddate.com/
www  Snowy

AllyG
reply to 'Sleeps till ski time'
posted Oct-2012

Thanks for that Snowy :D

According to that calculator I've got 84 days, 11 hours and 40 minutes until I start ski-ing at Tignes-Les-Brevieres at 9 a.m. on Sunday 13th January.

But it wouldn't let me put Tignes in, so I had to put in Geneva, which isn't really right, but it's sort of close enough.

AllyG
reply to 'Sleeps till ski time'
posted Oct-2012

This is the latest attempt to stop an Excel sheet from going all wobbly when I paste it up on here. Far Queue has fixed the problem with something called concatenation - to combine the required data into one column on the sheet, whilst still allowing Excel to calculate the date/number of days.

If you want to be on this list would you please say where and when you are going and how many sleeps you reckon it is (unless you are a secret agent in which case you can just give me the date!). Excel will let me know if there's a discrepancy, but perhaps some people will be missing out on a night of sleep.

Unless I get 50,000 J2skiers all posting up on here I will try and list you all.

List of J2Skiers going ski-ing/boarding in 2012/2013

Geno68 going to Davos in 61 days on the 21/12/2012
Bedrock Barney going to Val d'Isere in 70 days on the 30/12/2012
Snowy0000 going to Morzine in 70 days on the 30/12/2012
Smartski going to La Plagne in 77 days on the 06/01/2013
Ian W going to Manigod in 83 days on the 12/01/2013
Catp going to Tignes in 83 days on the 12/01/2013
AllyG going to Tignes in 83 days on the 12/01/2013
Tiger7 going to Tignes in 84 days on the 13/01/2013
Daved going to Tignes in 84 days on the 13/01/2013
Ade73 going to Tignes in 84 days on the 13/01/2013
Joe Colin going to Tignes in 84 days on the 13/01/2013
Felthorpe going to Tignes in 84 days on the 13/01/2013
Far Queue going to Tignes in 84 days on the 13/01/2013
Brooksy going to Tignes in 84 days on the 13/01/2013
Lizzie-B going to Morillon in 118 days on the 16/02/2013
Michelle63 going to Sauze D'Oulx in 119 days on the 17/02/2013
Far Queue going to Lech in 125 days on the 23/02/2013

Edited 1 time. Last update at 21-Oct-2012

Lizzie-B
reply to 'Sleeps till ski time'
posted Oct-2012

snowy0000 wrote:This is a very useful little site
http://www.timeanddate.com/

It certainly is - Thanks for that
Loving the new list Ally. 117 sleeps to Morillon for me. Going on the 16/2/2013 :D

Edited 1 time. Last update at 21-Oct-2012

Bedrock barney
reply to 'Sleeps till ski time'
posted Oct-2012

Off to Val d'Isere on dec 30th.

2nd ski hol still being planned.

Might be going to tignes in July as well!
slippy slidey snow......me likey!

Topic last updated on 19-November-2013 at 14:34