+- +-

+-Newcomers Start Here

+-Harlequins/Rugby Links


+-Articles


Author Topic: Team picker  (Read 2884 times)

0 Members and 0 Guests are viewing this topic.

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Team picker
« on: Monday 11-Nov-2019, 14:54* »
During my copious free time last week, I created a "Team picker".

And here it is -
https://tinyurl.com/y4gshkxx

You can go into the team picker from Monday morning and start picking your team for the next game.

The results can be viewed after you make your selection, but are best viewed on this link:
https://tinyurl.com/y54z7qg9

My aim is to create a summary every week before the teams are officially released (e.g. on Friday at 11:30am).

For anybody interested, this is how it works:
The form is a Google form that captures the responses and saves them in a Google Sheet which I have shared.
The Google Sheet has various tabs.  One of the tabs is all of the selections.  The "Current" tab shows selections since Monday morning.
The Sheet "just works".  I do not need to do anything to update the results.  I will need to make alterations to the Form though as the squad changes (e.g. I will remove Joe Marchant when he goes to the Blues).
There are charts on the Forwards and Backs pages which analyse the results.  I will be creating a "Backs 2" page in the near future.
For the people who value their privacy, there is no private information stored anywhere.  There is an option to enter a Nickname.  If you are happy to do so, then you can enter the same name as you use on this board.  From a GDPR perspective, this is essentially anonymous data.  All data collected is public.
For support purposes, all issues with the above system will be dealt with as follows:
Priority 1 - resolved within 1 hour; Priority 2 - resolved within 2 hours; Priority 3 - resolved within 1 day; Priority 4 - Best endeavours.  All issues with this system will be categorised as Priority 4.

And lastly, many thanks to InsertQuinsPunHere who has introduced me to the amazing "=query()" function.  Without this, the dashboards would need constant refreshing.
Also, thanks to the people who provided feedback on Friday.  Please continue to do so and I will endeavour to continue making this better. 

Share on Facebook Share on Twitter

Like Like x 1 Winner Winner x 1 View List

Admin

  • Administrator
  • Gold Member
  • *
  • Posts: 262
Re: Team picker
« Reply #1 on: Monday 11-Nov-2019, 23:21* »
For the moment I'll make this "sticky". When I get a moment I'll add it to the menus on the side

RodneyRegis

  • Lions Captain
  • ******
  • Posts: 1156
Re: Team picker
« Reply #2 on: Tuesday 12-Nov-2019, 07:57* »
Super. Now all we need is an injury update from the club.

Oh and stephan Lewies is down as back 3.

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #3 on: Tuesday 12-Nov-2019, 08:47* »
Thank you RR.  I have logged this as a priority 4 incident :-)
Funny Funny x 2 View List

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #4 on: Tuesday 12-Nov-2019, 08:48* »
Fixed.

DOK

  • Lions Captain
  • ******
  • Posts: 1492
Re: Team picker
« Reply #5 on: Tuesday 12-Nov-2019, 09:07* »
Hmm...I'm starting to think I may not be the only person who works in IT on this board! :)

deadlyfrom5yardsout

  • Lions Captain
  • ******
  • Posts: 2233
Re: Team picker
« Reply #6 on: Tuesday 12-Nov-2019, 09:27* »
Brilliant!

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #7 on: Tuesday 12-Nov-2019, 10:33* »
I am wanting to make the charts sort from largest to smallest.
E.g. for the Hooker (in column E), I want the person with the most votes to be on the top row and the person with the least votes to be on the bottom row.
The formula that I would use for this is =query(Selections!E:E,"SELECT E, COUNT(E) GROUP BY (E) ORDER BY COUNT(E) DESC",-1)

Now then, I can't work out how to do this for the locks or back rows, etc.
I need to use some sort of union (e.g. select lock from (select G as lock union select H as lock) as temp ) as the base for the formula.  Can anyone work out how I should do this?  My feeling is that there is some possibility of using a combo of PIVOT and GROUP By - or maybe there is another function that I can use?





deadlyfrom5yardsout

  • Lions Captain
  • ******
  • Posts: 2233
Re: Team picker
« Reply #8 on: Tuesday 12-Nov-2019, 10:48* »
What'd he just say?
Funny Funny x 1 View List

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #9 on: Tuesday 12-Nov-2019, 11:06* »
I think I have figured it out. (I am VERY busy at work today.)
Funny Funny x 1 View List

The Absolute Quintet

  • Club Member
  • ***
  • Posts: 204
Re: Team picker
« Reply #10 on: Tuesday 12-Nov-2019, 19:08* »
Itís a beautiful thing.

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #11 on: Tuesday 12-Nov-2019, 23:27* »
Thank you

deadlyfrom5yardsout

  • Lions Captain
  • ******
  • Posts: 2233
Re: Team picker
« Reply #12 on: Wednesday 13-Nov-2019, 12:01* »
Couldn't be sure if Smith was now injured so selected Herron and have included Sinckler but I guess he might still be going through concussion protocols. Elewise I was very close to the majority which in itself is very interesting.......

Queue PG rotating the hell out of things....

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #13 on: Wednesday 13-Nov-2019, 14:12* »
Unlikely that PG will rotate the hell out of things.
I am certain that Gussy will just view the spreadsheet and copy/paste into his press release. The reason that I left off "finishers" as I still want him to do a little bit of work :-)
« Last Edit: Wednesday 13-Nov-2019, 14:55* by never sleep »
Funny Funny x 1 View List

never sleep

  • Lions Captain
  • ******
  • Posts: 971
Re: Team picker
« Reply #14 on: Monday 18-Nov-2019, 13:14* »
The form is now available for your picks for the Bath game.

 

+-User

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+-Site Statistics

Members
Total Members: 792
Latest: Narbia
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 45882
Total Topics: 2728
Most Online Today: 54
Most Online Ever: 705
(Monday 02-Dec-2019, 13:56*)
Users Online
Members: 13
Guests: 40
Total: 53