| Owners | Position | |||||||||
| Lightning (Mike Goodman) | Catcher | |||||||||
| Evolution (Bruce) | 1st Base | |||||||||
| The Soylent Knights (Colin) | 2nd Base | |||||||||
| Woap (Mike) | 3rd Base | |||||||||
| The Dominant Brand (Brandon) | Short Stop | |||||||||
| Guzzlers (Rhonda) | Outfield #1 | |||||||||
| Trump for President (Rob) | Outfield #2 | |||||||||
| Booya's (Cathy) | Outfield #3 | |||||||||
| Freebirds (Todd) | DH | |||||||||
| Numbats (Tom) | Starting Pitcher #1 | |||||||||
| TheDunnShow (Dave) | Starting Pitcher #2 | |||||||||
| Starting Pitcher #3 | ||||||||||
| Starting Pitcher #4 | ||||||||||
| Starting Pitcher #5 | ||||||||||
| Relief Pitcher #1 | ||||||||||
| Relief Pitcher #2 | ||||||||||
| Relief Pitcher #3 | ||||||||||
| Relief Pitcher #4 | ||||||||||
| Reserve Roster #1 | ||||||||||
| Reserve Roster #2 | ||||||||||
| Reserve Roster #3 | ||||||||||
| Reserve Roster #4 | ||||||||||
| Reserve Roster #5 | ||||||||||
| Reserve Roster #6 | ||||||||||
| Reserve Roster #7 | ||||||||||
| Make sure every year to select all the players for each position and recreate the bookmark name (delete name first, then recreate name) to ensure all players get listed. | catchers | first | second | third | ss | outfield | dh | pitchers | relief | |
| Ensure that all players are listed when clicking on the button. | ||||||||||
| Change Draft Order Yearly | ||||||||||
| Freebirds (Todd) | 1 | |||||||||
| TheDunnShow (Dave) | 2 | |||||||||
| Trump for President (Rob) | 3 | |||||||||
| The Dominant Brand (Brandon) | 4 | |||||||||
| The Soylent Knights (Colin) | 5 | |||||||||
| Booya's (Cathy) | 6 | |||||||||
| Evolution (Bruce) | 7 | |||||||||
| Guzzlers (Rhonda) | 8 | |||||||||
| Lightning (Mike Goodman) | 9 | |||||||||
| Woap (Mike) | 10 | |||||||||
| Numbats (Tom) | 11 | |||||||||
| Formulas to Retreive Name and Position | ||||||||||
| =RIGHT(A1,LEN(A1)+ 5-FIND("-",A1)) | Position | |||||||||
| =LEFT(A1,FIND("-",A1) -5) | Name | |||||||||
| =Trim(cell) | Trim the positions for extra space | |||||||||