Let's play a let's play in the let's play forum.
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 28 Sep 2013, 13:18
Having a Let's Play team from all over the world, there is of course going to be the problem of time-zones.
In order to work around this problem we need everyone in the Let's Play gang to post their name, timezone name and UTC/GMT difference in this
thread, then i can make a table and upload it bellow. Google doco here:
https://docs.google.com/spreadsheet/ccc ... sp=sharing
Get
postin editin
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Last edited by
random980 on 29 Sep 2013, 13:07, edited 2 times in total.
-
RobipodSupreme
- Retired
- Posts: 1445
- Joined: 26 May 2011, 10:30
-
Contact:
Post
by RobipodSupreme » 28 Sep 2013, 15:52
GMT
UTC +- 0
Last edited by
RobipodSupreme on 29 Sep 2013, 05:51, edited 1 time in total.
I'm like 80% gayer than when I was on here last
I was a mod once
my discord is Ryin ❄#4444 if you wanna hmu fams
Miss you
![Sad :(](./images/smilies/icon_e_sad.gif)
-
Invunarble
- Site Contributor
- Posts: 4201
- Joined: 11 Feb 2012, 18:45
- Location: Canada
Post
by Invunarble » 28 Sep 2013, 20:53
"The roses are red, but Invunarble is blue. Hit him with a puma." - Vallorn
"Baked fucking potato" - Lord Mountbatten, 2014
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 29 Sep 2013, 05:47
Remind other Let's Players to post theirs, or if you know theirs post for em.
(and please add your UTC difference like i asked >.<)
Also Invun, are you even part of the Lets Play group? I ask as your name isnt on the "games i own" table.
-
TEKNOVIRUS
- Retired
- Posts: 259
- Joined: 03 Dec 2011, 19:15
- Location: Tirol, Austria
Post
by TEKNOVIRUS » 29 Sep 2013, 06:30
UTC/GMT +1 hour
Patbutalsorick in-game
-
Thelepearchauns
- Retired
- Posts: 248
- Joined: 24 Mar 2012, 12:39
- Location: End of a Rainbow
-
Contact:
Post
by Thelepearchauns » 29 Sep 2013, 09:09
EST
Lep
____________________________________________________________________
![Image](http://i.imgur.com/OExTpRo.jpg)
____________________________________________________________________
So its a sword that acts like a key in very specific situations
Or its a key all the time...and when you stick it in someone, it unlocks their death
-
Church and
Caboose
-
shaunpat99
- Retired
- Posts: 250
- Joined: 06 Jun 2012, 17:15
- Location: Illinois
Post
by shaunpat99 » 29 Sep 2013, 09:16
That games table has several people on there that are no longer interested, and it's missing a couple of our current people.. I haven't removed them because it's still fairly useful information if they ever decide to join up again.
Here's my timezone: CST, UTC - 6
Hey you, go check out the Escapecraft Youtube Channel!
"You can't just jetpack away from all your problems!"
But he totally could, and it was awesome.
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 29 Sep 2013, 11:55
Fair enough.
Also how do i upload the table so everyone can see AND edit it? Like the "Games you have" one?
-
shaunpat99
- Retired
- Posts: 250
- Joined: 06 Jun 2012, 17:15
- Location: Illinois
Post
by shaunpat99 » 29 Sep 2013, 12:39
If it's a Google spreadsheet, there should be a setting when you save it, something along the lines of "Anyone can view or edit this document." Select that instead of sharing it with email addresses.
Hey you, go check out the Escapecraft Youtube Channel!
"You can't just jetpack away from all your problems!"
But he totally could, and it was awesome.
-
minnerthecat
- Retired
- Posts: 604
- Joined: 21 Jul 2011, 21:58
- Location: Canada
Post
by minnerthecat » 29 Sep 2013, 12:41
Canada, CST -6 hours
Orange and white, but not quite right.
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 29 Sep 2013, 13:12
Oh the wonders of Google.
Now you can all add it yourselves!
![Razz :P](./images/smilies/icon_razz.gif)
If anyone knows how to make the spreadsheet automatically sort by "column B" Z>A and then "column A" A>Z
automatically AND go "If B2=GMT, than make C2=O" Than PLEASE by all means add it and tell me how >.>
-
Invunarble
- Site Contributor
- Posts: 4201
- Joined: 11 Feb 2012, 18:45
- Location: Canada
Post
by Invunarble » 29 Sep 2013, 13:45
random980 wrote:Also Invun, are you even part of the Lets Play group? I ask as your name isnt on the "games i own" table.
Eh, I thought all of our Civ sessions made me a qualifiable Let's Player by now.
I haven't bothered initially to put my own column in on that spreadsheet because of the fact I assumed I wouldn't be doing anything in this - not to mention the spreadsheet's a bit sloppy now with all those columns
![Razz :P](./images/smilies/icon_razz.gif)
. I could still fill it in with the games I own though, if need be.
"The roses are red, but Invunarble is blue. Hit him with a puma." - Vallorn
"Baked fucking potato" - Lord Mountbatten, 2014
-
aeroeng15
- Retired
- Posts: 472
- Joined: 26 Mar 2012, 09:55
- Location: Cincinnati, Ohio
Post
by aeroeng15 » 29 Sep 2013, 13:47
random980 wrote:Oh the wonders of Google.
Now you can all add it yourselves!
![Razz :P](./images/smilies/icon_razz.gif)
If anyone knows how to make the spreadsheet automatically sort by "column B" Z>A and then "column A" A>Z
automatically AND go "If B2=GMT, than make C2=O" Than PLEASE by all means add it and tell me how >.>
Select column headers >>> Data -> Sort Range and select how you want it to sort.
I would suggest a lookup table for the TimeZone -> UTC conversion
(I can do said things if needed)
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 29 Sep 2013, 15:26
aeroeng15 wrote:random980 wrote:Oh the wonders of Google.
Now you can all add it yourselves!
![Razz :P](./images/smilies/icon_razz.gif)
If anyone knows how to make the spreadsheet automatically sort by "column B" Z>A and then "column A" A>Z
automatically AND go "If B2=GMT, than make C2=O" Than PLEASE by all means add it and tell me how >.>
Select column headers >>> Data -> Sort Range and select how you want it to sort.
I would suggest a lookup table for the TimeZone -> UTC conversion
(I can do said things if needed)
I did the sort range thing, but when new entries are put in, it still doesn't automatically sort/correct the data.
I dont really understand how to make a lookup table or what it will actually do. So can you please sort that out
![Razz :P](./images/smilies/icon_razz.gif)
I just want "UTC" to auto-fill when data in Timezone is put in.
-
aeroeng15
- Retired
- Posts: 472
- Joined: 26 Mar 2012, 09:55
- Location: Cincinnati, Ohio
Post
by aeroeng15 » 29 Sep 2013, 19:43
I wrote a quick auto-update script, which will sort by UTC descending and then player name.
The lookup table is off to the right and can be expanded as necessary.
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 29 Sep 2013, 20:20
Awesome, thanks for that!
-
shaunpat99
- Retired
- Posts: 250
- Joined: 06 Jun 2012, 17:15
- Location: Illinois
Post
by shaunpat99 » 29 Sep 2013, 21:21
Thanks to you both. I have also added two other columns for Time Availability: Weekdays and Weekends. Please put info there as well, I would prefer it in Server Time (CST), but you can go ahead and put it in your timezone and I can convert it. This just needs to be a simple approximation of when you're available to play. This is pretty much for me so I can set you up in teams with like schedules. You can see mine for an example.
Hey you, go check out the Escapecraft Youtube Channel!
"You can't just jetpack away from all your problems!"
But he totally could, and it was awesome.
-
andy25100
- Retired
- Posts: 656
- Joined: 01 Jul 2011, 18:40
- Location: Old York
Post
by andy25100 » 04 Oct 2013, 09:48
GMT.
"They'll tear you apart, bone by bone... ...and build with you a human throne. Their buck- toothed king will sit upon What once was you, but now is gone. This key unlocks the gates of Hell. Steady traveler, use it well." - Grim Fandango - Poem of the Flaming Demon Beavers
![Image](http://dl.katawa-shoujo.com/pr/banner/ks_banner.jpg)
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 06 Oct 2013, 01:19
Added a new column, DLS (daylight savings) As parts of Australia just started daylight savings. Remember to add another +1 UTC when working out timezones with DLS being observed. (so AEST is now +11 hours UTC >.<)
And remember to keep the column up to date when need be.
-
vallorn
- Posts: 8839
- Joined: 13 Nov 2010, 10:45
Post
by vallorn » 06 Oct 2013, 13:33
PST (GMT:-8)
Bloody hell west coast ya'll.
Lord_Mountbatten wrote:I didn't quite hear you over the sound of my eyebrow shooting into the sky.
OI YOU!
YES YOU!
WE HAVE A STEAM COMMUNITY GROUP!
JOIN US AND ADD PEOPLE FOR FUN TIMES!
CUT: Baldrick
-
random980
- Posts: 1852
- Joined: 23 Feb 2011, 03:32
- Location: Australia, Vic
Post
by random980 » 07 Oct 2013, 00:20
vallorn wrote:PST (GMT:-8)
Bloody hell west coast ya'll.
I thought you were GMT? Being from England?
-
vallorn
- Posts: 8839
- Joined: 13 Nov 2010, 10:45
Post
by vallorn » 07 Oct 2013, 14:00
I moved from Blighty to cali a year ago lol
Lord_Mountbatten wrote:I didn't quite hear you over the sound of my eyebrow shooting into the sky.
OI YOU!
YES YOU!
WE HAVE A STEAM COMMUNITY GROUP!
JOIN US AND ADD PEOPLE FOR FUN TIMES!
CUT: Baldrick
Who is online
Users browsing this forum: No registered users and 4 guests