July 13th, 2010· 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.
July 13th, 2010· Changed Buy and Get Player’s Names macro buttons from ActiveX to UserForm to be more Mac compatible.
· Modified formulas on Bat Stats and Season Stats page to not display zero’s in unused name cells.
· Fixed BA and OPB formulas in Season Stats worksheet.
· Removed offending Option commands from Get Player’s Name sort macro.
July 13th, 2010· Three games have been added for total of 21 game season.
· The spreadsheet now supports a 16th player.
· Batting Stats and Season Hitting Statistics worksheets have been added. On the Bat Stats page, each game’s final score can be entered. This information is then used on the Season Stats page to calculate the overall team performance.
· A Team Roster page has been added that lists all of the team administrators’ and players’ contact information.
· The LineUp worksheet now has a macro that auto populates the player list and then automatically sorts it in the proper alphabetical order.
· The Unlock Button on the BUY worksheet now opens a dialog box to ask for the Unlock Code. This eliminated the need for the user to hit the ENTER key prior to executing the macro.
· The Game Sheets now contain a Box Score Table at the bottom.
July 13th, 2010· Removed the offending DataOption1 line from the sort macros to avoid the "named argument not found" macro error when used on older versions of Excel.
July 13th, 2010· Modified graphic on About Page to reflect simplified product name of “LineUp Manager”.
· Implemented an Auto Sort macro function on the LineUp worksheet that executes upon “LineUp” worksheet activation. When LineUp worksheet is activated, the team roster is selected and sorted in Ascending order.
· Implemented an AutoGrey macro that automatically grey’s out all position cells for players not designated to be in a specific games batting rotation as marked by an “X” on the LineUp worksheet. The AutoGrey macro runs upon Position worksheet activation.
· Added Pitch Card worksheet.
· Added Pitch Stats Worksheet.
· Addded PayPal BuyNow button to the BUY worksheet.
· Expanded the Position Stats page to track infield positions separately.
· Replaced multiple Game worksheets with a single Game worksheet that auto populates with the specific Lineup and position information for the Game Number entered into the yellow box at the top.
July 13th, 2010· Corrected an issue on the “Position Stats” page in which the reported times played in the Infield may be in error if the players’ name ended with the letter “b”.
July 13th, 2010· Combined the Day / Date fields in the Schedule to simplify date entry.
· Implemented an Auto Sort macro function on the LineUp worksheet. Upon ENTER key event, team roster is selected and sorted in Ascending order.
· Added Position Stats and the BUY worksheets.
July 13th, 2010· Addressed misc Formatting issues associated with version 1.6.
· Added Check for Duplicate Position Assignments. Inning number cell shades RED when duplicate positions assigned for that inning.
July 13th, 2010· Added Division Entry Cell and Umpire column to Schedule worksheet.
· Unlocked Format Control on Schedule worksheet.
· Added Conditional Formatting option on Player No. column to indicate whether Player Name Cell is blank. Gold Shading Player No. cell indicates adjacent Player Name cell is not empty.
· Added cutout lines to around Lineup Cards.
· Modified LineUp worksheet information on HELP tab to explain GOLD shading check for blank name cells.
· Added product name and product URL to Schedule, LineUp Cards, and Game worksheets.