Lineup Manager is an Excel spreadsheet made to help head coaches generate and keep track of Batting Line-Ups and Fielding positions. Lineup Manager has a built in feature that will warn against duplicate positions.
Specifically designed for a maximum 15 player roster and an 18 game season schedule, it's easy to use and allows a coach to do all of his / her work within the "Schedule", "LineUp" and "Positions" worksheets (yellow sheet tabs at the bottom).
Once the Schedule, Line-Up, and Player Position information is entered, the individual game worksheets (blue sheet tabs at the bottom) are automatically filled out based on the information entered into the "LineUp" and "Positions" worksheets.
The names of the players with their assigned positions will automatically be entered, in the batting order you assigned, into the corresponding "Game" worksheet. The spreadsheet is partially filled out as an example.
Here are some key features of "Lineup Manager (formerly Little League Lineup Manager)":
· Schedule Tab
The teams schedule is entered by filling in the Day, Date, Time, Location, Home / Visitor, and Opponent information for games 1 through 18:
· LineUp Tab
Individual player names along with their jersey numbers are entered on the "LineUp" worksheet:
· Positions Tab
Under the Positions Tab, a seven inning matrix exists for each Game, 1 through 18:
· Game Tabs
The Game worksheets (blue sheet tabs 1 through 18 at the bottom) are automatically filled out based on the information entered into the "LineUp" and "Positions" worksheets and are thus protected from being edited:
· LineUp Cards Tab
· The worksheet is formatted to generate two lineup cards for any specific game that can then be handed out to the opposing coach and umpire
Requirements:
· Microsoft Excel
Limitations:
· 2-game limit
What's New in This Release: [ read full changelog ]
· Added entry area on Pitcher Availability worksheet for league mandated pitching rest rules.
· Added support for partial innings pitched.
· Add Player Position matrix table at bottom of Game sheet.
· Game sheet will now reflect past game box scores based on data entered into the Bat Stats page.
· Change Pitch Card sheet so you can enter Outs & Pitches thrown.
· Add feature to tell coach which positions have yet to assigned on Positions worksheet.
· Added support for 9-man batting rotation with subs.
· Modified Bat Stats worksheet so players are listed according to each games batting rotation.
· Modified Team Stats page to reflect both batting and pitching statistics.