Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 69
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,722
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Baseball Formula KLB Excel Worksheet Functions 9 September 25th 07 07:44 PM
Baseball help. GRAPHS [email protected] Excel Discussion (Misc queries) 6 June 5th 07 01:11 PM
Baseball statistics enorment Excel Discussion (Misc queries) 0 March 23rd 06 05:33 PM
Create patient schedule based on master therapist schedule PapaBear Excel Discussion (Misc queries) 8 October 12th 05 04:56 AM
Is there a way to make P=1, C=2, as in baseball and then add them Robert Hubley Excel Discussion (Misc queries) 1 April 24th 05 01:45 AM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"