Spreadsheet: 156417d1337282127-excel-2007-need-to-create-batting-order-depending-on-stats-and-cant-have-a-player-twice-in-line-up-softball-stats-monday-night
Sheet: Totals

 | Team | JBC |  |  |  |  |  |  | Runs / Innings Avg. |  |  |  |  |  |  |  |  |  | Season Leaders
 | Season | Summer 2012 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Division | Men's Softball ASA Monday Night |  |  |  |  |  |  | 5 | 2 | 0 | 5 | 5 | 1 | 8 |  |  |  |  | Average |  |  | At Bats |  |  |  | 1 | Jared | 0.6 | BA
 | Record | 1 | Wins | 0 | Loses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scott | 1 |  | Jared | 5 |  |  | 2 | [NAME] | 0.6 | BA
 | Runs For | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Joel | 1 |  | [NAME] | 5 |  |  | 3 | [NAME] | 1.5 | SLG
 | Runs Against | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.75 |  | Joel | 5 |  |  | 4 | Scott | 3.333333333333333 | SLG
 | Difference | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.75 |  | [NAME] | 5 |  |  | 5 | Joel | 2.4 | OPS
Summer 2012 Season Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jared | 0.6 |  |  |  |  |  | 6 | [NAME] | 2.05 | OPS
# | Name | G | AB | H | 1B | 2B | 3B | HR | BB | ROE | SAC | R | RBI | BA | OBP | SLG | OPS |  |  | [NAME] | 0.6 |  | Hits |  |  |  | 7 | [NAME] | 0.5 | BA
1 | Scott | 1 | 3 | 3 | 0 | 1 | 0 | 2 | 0 | 1 | 1 | 4 | 9 | 1 | 0.8 | 3.333333333333333 | 4.133333333333334 |  |  |  |  |  | Joel | 5 |  |  | 8 | [NAME] | 0.5 | BA
2 | [NAME] | 1 | 4 | 2 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 0.5 | 0.6 | 0.5 | 1.1 |  |  | OBP |  |  | Scott | 3 |  |  | 9 | [NAME] | 0.5 | BA
3 | Jared | 1 | 5 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 0.6 | 0.6 | 0.8 | 1.4 |  |  | Joel | 1 |  | Jared | 3 |  |  | 10 | [NAME] | 0.4 | BA
4 | [NAME] | 1 | 4 | 3 | 1 | 2 | 0 | 0 | 0 | 1 | 0 | 4 | 1 | 0.75 | 0.8 | 1.25 | 2.05 |  |  | Scott | 0.8 |  | [NAME] | 3 |  |  | 11 | Kris | 0.25 | BA
5 | [NAME] | 1 | 5 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0.6 | 0.6 | 1 | 1.6 |  |  | [NAME] | 0.8
6 | Joel | 1 | 5 | 5 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 1 | 1 | 1.4 | 2.4 |  |  | [NAME] | 0.6 |  | 1B |  |  |  |  | SLG |  | OPS |  | BA
7 | [NAME] | 1 | 4 | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 3 | 0.75 | 0.6 | 1.5 | 2.1 |  |  | Jared | 0.6 |  | Joel | 3 |  |  |  | 3.333333333333333 | 1 |  |  |  |  | Scott
8 | [NAME] | 1 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0.5 | 0.5 | 0.75 | 1.25 |  |  | [NAME] | 0.6 |  | [NAME] | 2 |  |  |  | 0.5 | 8 | 1.1 | 6 | 0.5 | 3 | [NAME]
9 | [NAME] | 1 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 2 | 0.5 | 0.6 | 0.5 | 1.1 |  |  |  |  |  | Jared | 2 |  |  |  | 0.8 | 6 | 1.4 | 4 | 0.6 | 1 | Jared
10 | Kris | 1 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0.25 | 0.25 | 0.25 | 0.5 |  |  | Slugging |  |  | [NAME] | 2 |  |  |  | 1.25 | 4 | 2.05 | 2 |  |  | [NAME]
11 | [NAME] | 1 | 5 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0.4 | 0.4 | 0.4 | 0.8 |  |  | Scott | 3.333333333333333 |  |  |  |  |  |  | 1 | 5 | 1.6 | 3 | 0.6 | 2 | [NAME]
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a |  |  | [NAME] | 1.5 |  | 2B |  |  |  |  | 1.4 | 3 | 2.4 | 1 |  |  | Joel
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a |  |  | Joel | 1.4 |  | [NAME] | 2 |  |  |  | 1.5 | 2 |  |  |  |  | [NAME]
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a |  |  | [NAME] | 1.25 |  | [NAME] | 2 |  |  |  | 0.75 | 7 | 1.25 | 5 | 0.5 | 4 | [NAME]
 | TOTAL | 1 | 47 | 29 | 16 | 10 | 1 | 2 | 1 | 3 | 2 | 26 | 25 | 0.3404255319148936 | 0.34 | 0.723404255319149 | 1.063404255319149 |  |  | [NAME] | 1 |  | Joel | 2 |  |  |  | 0.5 | 9 | 1.1 | 7 | 0.5 | 5 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jared | 0.8 |  | Scott | 1 |  |  |  | 0.25 | 11 | 0.5 | 9 | 0.25 | 7 | Kris
 | [NAME] |  | 5 | 5 | 3 | 2 | 1 | 2 | 1 | 1 | 1 | 4 | 9 | 1 | 1 | 3.333333333333333 | 4.133333333333334 |  |  |  |  |  |  |  |  |  |  | 0.4 | 10 | 0.8 | 8 | 0.4 | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPS |  |  | 3B
 | Team Rank | AB | H | 1B | 2B | 3B | HR | BB | ROE | SAC | R | RBI | BA | OBP | SLG | OPS |  |  |  | Scott | 4.133333333333334 |  | [NAME] | 1
1 | Scott | 11 | 2 | 11 | 4 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 |  |  |  | Joel | 2.4
2 | [NAME] | 5 | 7 | 2 | 8 | 3 | 2 | 1 | 4 | 3 | 6 | 7 | 7 | 4 | 8 | 8 |  |  |  | [NAME] | 2.1
3 | Jared | 1 | 3 | 3 | 5 | 4 | 3 | 3 | 5 | 4 | 3 | 4 | 5 | 5 | 6 | 6 |  |  |  | [NAME] | 2.05
4 | [NAME] | 6 | 4 | 6 | 1 | 5 | 4 | 4 | 2 | 5 | 2 | 8 | 3 | 3 | 4 | 4 |  |  |  | [NAME] | 1.6
5 | [NAME] | 2 | 5 | 7 | 2 | 6 | 5 | 5 | 6 | 6 | 4 | 11 | 6 | 6 | 5 | 5 |  |  |  | Jared | 1.4 |  | HR
6 | Joel | 3 | 1 | 1 | 3 | 7 | 6 | 6 | 7 | 7 | 7 | 2 | 2 | 1 | 3 | 2 |  |  |  |  |  |  | Scott | 2
7 | [NAME] | 7 | 6 | 8 | 6 | 1 | 7 | 7 | 8 | 2 | 9 | 3 | 4 | 7 | 2 | 3 |  |  |  | RBI |  |  | [NAME] | 0
 | [NAME] | 8 | 8 | 9 | 7 | 8 | 8 | 8 | 9 | 8 | 8 | 9 | 8 | 9 | 7 | 7 |  |  |  | Scott | 9 |  | Jared | 0
 | [NAME] | 9 | 9 | 4 | 9 | 9 | 9 | 9 | 3 | 9 | 5 | 5 | 9 | 8 | 9 | 9 |  |  |  | Joel | 3 |  | [NAME] | 0
 | Kris | 10 | 11 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 6 | 11 | 11 | 11 | 11 |  |  |  | [NAME] | 3
 | [NAME] | 4 | 10 | 5 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 10 | 10 | 10 | 10 | 10 |  |  |  | Jared | 2 |  | BB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Runs |  |  | Scott | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scott | 4 |  | Jared | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jared | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3