ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   baseball fielding schedule (https://www.excelbanter.com/excel-worksheet-functions/189008-baseball-fielding-schedule.html)

Looping through

baseball fielding schedule
 
I have a weird one for you. I am tring to create a fair fielding schedule for
my tee ball team where one child can not sit on the bench more than one a
game and also can not play the outfield possitions twice in a game.

In the ideal world Child 1 would play 1 inning of infield, 1 inning of
outfield and 1 inning of bench (3 inning total). The third inning is tricky
because I have 13 kids and 10 possitions to fill. In the last inning, the
child can play the infield again (Just not the one they already played), but
can not play the outfield or bench.

Does anyone have a formula for this?

Luke M

baseball fielding schedule
 
Don't have a formula per se, but you could set up a pattern if player
position is irrelevant.
1st inning
kids 1-4 play outfield, 5-7 sit, 8-13 play infield
2nd inning
kids 5-8 play outfield, 9-11 sit, 12-4 play infield
3rd inning
kids 9-12 play outfield, 13-2 sit, 3-8 play infield

Next game, start pattern with 13-3 playing outfield

Hope it helps!
--
Best Regards,

Luke M


"Looping through" wrote:

I have a weird one for you. I am tring to create a fair fielding schedule for
my tee ball team where one child can not sit on the bench more than one a
game and also can not play the outfield possitions twice in a game.

In the ideal world Child 1 would play 1 inning of infield, 1 inning of
outfield and 1 inning of bench (3 inning total). The third inning is tricky
because I have 13 kids and 10 possitions to fill. In the last inning, the
child can play the infield again (Just not the one they already played), but
can not play the outfield or bench.

Does anyone have a formula for this?



All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com