Please help with a ...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Please help with a formula

8 Posts
6 Users
0 Reactions
72 Views
Posts: 1503
Full Member
Topic starter
 

I help manage a kid's football team and we want to give equal game time but we have 2 GK's that each play a half.

Halves are 25 min's but the other variable is that we may have anything between 7 & 12 players!

What I want is a spreadsheet that has the 2 gk's seperate, each playing a half. And then a spreadsheet covering the remaining players, between 5 & 10 kid's. So thats 6 spreadsheets depending on absentee's

Please help


 
Posted : 18/11/2021 11:16 am
Posts: 6856
Free Member
 

How many outfield players are there on a team? 7-a-side?
Are the subs rolling? If one player comes off, is that the end of their match?


 
Posted : 18/11/2021 11:58 am
Posts: 3149
Full Member
 

I assume 6 a side if there's between 5-10 not including goalie


 
Posted : 18/11/2021 12:02 pm
Posts: 3149
Full Member
 

Surely total playing time for all outfield players is 5x25x2 =250 divide 250 by the number of players available. If there's only 5 then they play the full 50 mins, if there's 10 then it's 25 each.


 
Posted : 18/11/2021 12:06 pm
Posts: 1891
Free Member
 

Unless you can take a player off and then put them back on again later I don't think it can be done for n=6/7/8/9.


 
Posted : 18/11/2021 12:40 pm
Posts: 1503
Full Member
Topic starter
 

6 outfield players
Rolling sub's so they are off an on
@dc1988 that's fine but the problem is 6,7,8,9


 
Posted : 18/11/2021 1:08 pm
 J-R
Posts: 1179
Full Member
 

I don't understand the question!

Is the situation that:
- the goalies are completely separate and do not play outfield
- you have 6 outfield positions
- you want to give an equal playing time per game to between 5 and 10 kids who play outfield (excludes the goalies)

If the above is true, then aren't you simply trying to share 6 x 50 = 300 minutes playing time between 5,6,7,8,9 or 10 outfield kids?

If so, then doesn't each kid play for 300/N where N number of outfield kids that day? For example if 7 kids (excl 2 goalies) they each play for 300/7 = 43 minutes.

Of course that leaves the question of what are you doing if you only have 5 outfield kids turn up vs the 6 positions to fill.


 
Posted : 18/11/2021 1:42 pm
Posts: 3149
Full Member
 

As above, the amount of time each player needs to play is easy, trying to actually make it work by timing the subs correctly might be more difficult


 
Posted : 18/11/2021 1:47 pm
Posts: 185
Free Member
 

From my experience doing the same thing with kids football a few years ago - no point in trying to do this.

Kids will need to be subbed. Can't make subs until break in play. Others won't turn up when expected to or will appear because they forgot it wasn't their week. Some will want off for some random reason and others will be keen to play every minute.

In the end we just said to the kids we'd try and make it as equal as we could and they accepted that.


 
Posted : 18/11/2021 1:54 pm

6 DAYS LEFT
We are currently at 95% of our target!