Gather Spreadsheet for Captains

tudy
5568
Posts
169
Location
Germany
Joined
30 June 2013
21 March 2015 - 08:17 EDT
#1
I don't know if it is really needed, but it took me not long to make it anyways. This might be a help for team-captains in gathers: It is a form asking you about the Division you play in, if you can com, and your preferred lifeforms. All the data is collected and sorted into a public spreadsheet.

So, if you fill out the form the captains can find the info regarding you in that spreadsheet and can pick based on that, instead of frantically browsing through the - not always so fast - ensl.org.

The form is made such that you can:
* Edit your info later (if you pick up another lifeform, or start comming)
* Send in multiple answers

In theory the latter should not be needed. But I bet there will be people who loose the link, with which they could edit their old info.

EDIT: The Sorting of players alphabetically does not work automatically. I don't know if people, who have no write-access can actually sort their view on the spreadsheet themselves. But, as said, there is still CTRL+F and we can sort it manually every now and then...

The spreadsheet should be sorted by player's name alphabetically. If not, or if it becomes hard to browse you can still use CTRL+F to find the player you are searching for. The division is color-coded for a slightly quicker overview.

Again this could be a help for the people, who play gathers regularly. If people rather like to put a lot of bullshit into that form it will just become useless. As there are currently not people running us over to help with the webpage an interal overview is out of reach. So, we need to rely on a service from the outside, which always gives people the opportunity to spoil things.

Here are the links again:
The Form
The Spreadsheet
Don't forget to save the link, which allows you to edit your info later.
Hyste
Noavatar
Posts
104
Location
France
Joined
9 March 2014
21 March 2015 - 08:46 EDT
#2
Very great idea, thanks !
Syknik
2026
Skill Issue
Posts
57
Location
Canada
Joined
27 December 2009
21 March 2015 - 09:03 EDT
#3
I'm always one for stuff like this, but people can be lazy. What would be great is if that information was linked to each player signed up to the NSL. So if i'm a captain and mouse over one of the players, a box will show up showing their division, if they comm, lerk, fade, etc..Also if they have it set that they are a commander, maybe have it so that beside their flag (or on the other side of their name) it shows the commander icon.

loMe
6335
Alski Syndrome
Posts
183
Location
United States of America
Joined
29 June 2014
21 March 2015 - 11:30 EDT
#4
Put the link to the doc on the Gather page for more convenience please.
Paskie
5945
Posts
69
Location
Finland
Joined
14 December 2013
25 March 2015 - 10:12 EDT
#5
Let players fill an info box every gather they join as they sign up for it. This would be visible the way syknik suggested.
gg
swalk
2129
Xeon
Posts
908
Location
Copenhagen, Denmark
Joined
9 May 2010
25 March 2015 - 22:11 EDT
#6
Paskie says
Let players fill an info box every gather they join as they sign up for it. This would be visible the way syknik suggested.

Been suggested many times, but it requires someone with knowledge of Ruby on Rails(coding language of the page) and the time and willingness to make it.
http://www.youtube.com/user/swalken/videos
Decoy
Noavatar
Posts
73
Location
United States of America
Joined
5 October 2012
26 March 2015 - 05:32 EDT
#7
This is nice, could also be really handy when teams are looking for mercs.
PandaClaws
Noavatar
Posts
29
Location
Denmark
Joined
31 October 2012
15 April 2015 - 06:38 EDT
#8
You can sort by right clicking on the coloumn you want to sort by. That way you can sort for divisions as well if you're a captain.

You can also filter stuff with the custom filter button (icon looks like a tiny funnel).
simple
5870
Posts
131
Location
Germany
Joined
16 November 2013
19 April 2015 - 06:18 EDT
#9
loMe says
Put the link to the doc on the Gather page for more convenience please.

Done
Ixian
6200
Posts
110
Location
Denmark
Joined
16 March 2014
19 April 2015 - 10:43 EDT
#10
Edit: brain achieved and fixed myself
"It is wisdom to recognize necessity, when all other courses have been weighed, despite as folly it may appear to those who cling to false hope" - J.R.R. Tolkien
simple
5870
Posts
131
Location
Germany
Joined
16 November 2013
21 April 2015 - 06:17 EDT
#11
swalk says
Paskie says
Let players fill an info box every gather they join as they sign up for it. This would be visible the way syknik suggested.

Been suggested many times, but it requires someone with knowledge of Ruby on Rails(coding language of the page) and the time and willingness to make it.

How important to you guys think that is?
Can you live with the spreadsheet?
Ixian
6200
Posts
110
Location
Denmark
Joined
16 March 2014
21 April 2015 - 20:45 EDT
#12
Sure can live with the spreadsheet - but a fomular to fill in as joining would be awesome!
"It is wisdom to recognize necessity, when all other courses have been weighed, despite as folly it may appear to those who cling to false hope" - J.R.R. Tolkien
Mega
1942
pubstars
Posts
225
Location
Germany
Joined
27 September 2009
22 April 2015 - 13:30 EDT
#13
ur welcome this thing is years old but still the case:

http://www.ensl.org/topics/1165#post_14762
Nightsy
6452
Alski Syndrome
Posts
102
Location
Munich, Bhutan
Joined
18 September 2014
22 April 2015 - 14:24 EDT
#14
Mega_noComm says
ur welcome this thing is years old but still the case:

http://www.ensl.org/topics/1165#post_14762


Thats actually good. Why isnt it still implemented?
simple
5870
Posts
131
Location
Germany
Joined
16 November 2013
22 April 2015 - 15:04 EDT
#15
Nightsy says
Mega_noComm says
ur welcome this thing is years old but still the case:

http://www.ensl.org/topics/1165#post_14762


Thats actually good. Why isnt it still implemented?

It never was. Its a mock up.
Nightsy
6452
Alski Syndrome
Posts
102
Location
Munich, Bhutan
Joined
18 September 2014
22 April 2015 - 16:29 EDT
#16
simple says
Nightsy says
Mega_noComm says
ur welcome this thing is years old but still the case:

http://www.ensl.org/topics/1165#post_14762


Thats actually good. Why isnt it still implemented?

It never was. Its a mock up.


then gogo :]
simple
5870
Posts
131
Location
Germany
Joined
16 November 2013
22 April 2015 - 17:26 EDT
#17
Nightsy says

then gogo :]

pffff
New Reply