+- +-

+-Newcomers Start Here

+-Harlequins/Rugby Links


+-Articles


Author Topic: Team picker  (Read 8517 times)

0 Members and 0 Guests are viewing this topic.

never sleep

  • Lions Captain
  • ******
  • Posts: 1991
Team picker
« on: Monday 11-Nov-2019, 14:54* »
Here the link to the Team Picker:
https://tinyurl.com/y4gshkxx
Go into the form and select who you would choose for the next game. There is also an opportunity to suggest what you think the result will be.

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 on this link:
https://tinyurl.com/y54z7qg9
The results are refreshed every 5 minutes - so, your selection may take a little while to appear.

My aim is to create a summary every week before the teams are officially announced (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 is 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".  No action is needed to update the results. The squad list is updated from the "Squad/Contracts/Injuries" page.

There are charts on the Forwards and Backs pages which analyse the results.

As for pricacy - 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.

Many thanks to InsertQuinsPunHere who has introduced me to the amazing "=query()" function.  Without this, the dashboards would need constant refreshing.
« Last Edit: Wednesday 11-Aug-2021, 14:31* by never sleep »
Like Like x 1 Winner Winner x 1 View List

deadlyfrom5yardsout

  • Lions Captain
  • ******
  • Posts: 3014
Re: Team picker
« Reply #1 on: Thursday 12-Aug-2021, 08:48* »
Nice!

never sleep

  • Lions Captain
  • ******
  • Posts: 1991
Re: Team picker
« Reply #2 on: Thursday 31-Mar-2022, 11:09* »
I have moved a few players round in the backs.
I think we are a bit thin on the ground in our back 3 - so, I assume that players such as Marchant won't be seen in the centres for a while

 

+-User

Welcome, Guest.
Please login or register.
 
 
 

Login with your social network

Forgot your password?

+-Site Statistics

Members
Total Members: 1059
Latest: Uptown Top Rank Quin
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 94998
Total Topics: 5219
Most Online Today: 74
Most Online Ever: 4089
(Sunday 10-Oct-2021, 12:56*)
Users Online
Members: 12
Guests: 51
Total: 63