Softball/Baseball Team Calculator - SBC


Version 4.74 - Version History, Known Errata, and Limitations
Last Updated: 11/12/21

Check out the full revision history for previous revisions.

4.74 - General Release

4.74 - Fixes

  1. Non-SBC Document Handling -
    1. Documents did not display a standard ribbon tab set.
    2. Quick Action Toolbar (QAT) functions and shortcuts incorrectly mapped to SBC functions.
    3. Closing documents that had been modified did not prompt to save changes (Windows versions of Excel).
  2. One Step Web Site
    1. Corrected formatting of robots.txt file.
    2. Corrected zebra striping on Division Standings block with odd number of teams.
    3. Activating the home page weather forecast option corrupted the home page display.
  3. Import Summary and Export Summary did not show all commands with previous command summaries.
  4. Update Player Stats – Did not test correctly for all cases where Box Score or Batting Leaders required updating.
  5. Repair Player Stats – Did not post alert if Box Score or Batting Leaders required updating after repairs.

4.74 - Enhancements

  1. Results of Stats Export command can be recalled via Export / Export Summary.
  2. Added Batting Leaders / Clear command to SBC Ribbon.
  3. Added Excel Watch Window tool to View menu.
  4. Added options to automatically update Box Score and Batting Leaders when needed.
  5. Enhanced testing for cases where Box Score or Batting Leaders require updating.
  6. Where possible, previous dialog box parameter selections are preserved for subsequent calls.
  7. One Step Web Site Weather service changed to
    1. Added support for Canadian cities
    2. Added support for location using zipcode (US locations only)
    3. Added option for forecast display

4.73 - General Release

4.73 - Fixes

  1. One Step Web Site
    1. Corrected a situation where Line Score overflowed the display on small mobile devices.
    2. User-defined navigation tab links did not follow position option setting. Always appeared after pre-defined links.
    3. Corrected some instances where zebra table striping did not work correctly.
  2. Some import functions did not gracefully exit if an invalid file format was detected.
  3. Player Stats Edit - Played But Did Not Bat function did not operate correctly
  4. Misc bug fixes.

4.73 - Enhancements

  1. One Step Web Site -
    1. Enhanced validation of URL entries to be compliant with W3C stnadards.
    2. Added option to display masthead icon examples.
    3. Added a sample file for user-defined Home Page Content to the 4.73 distribution file.
  2. Schedule Analyzer – Improved analysis of completed games.
  3. Progress displays show more detail during long operations such as roster optimizations.
  4. Batting Leaders – Streamlined runtime options dialog
  5. Export Stats -
    1. Added support for Multi-Season Mode exports.
    2. Added Batting Summary stats export option.
    3. Added progress display.
  6. Where possible, previous dialog box parameter selections are preserved for subsequent calls.
  7. Overall performance improvements.

4.72 - General Release

4.72 - Fixes

  1. One Step Web Site -
    1. Corrected some styling inconsistencies.
    2. Enhanced validation of URL entries to be compliant with W3C stnadards.
  2. SBC Ribbon - Some commands were not disabled under certain conditions.
  3. Some keyboard shortcut commands were not blocked under certain conditions.
  4. Box Score -
    1. Corrected a condition where Box Score add/update function was prevented.
    2. Corrected instances where the current Box Score wasn’t flagged to be updated
    3. Add/Update function did not properly test for changes in the displayed line score vs. stored version before updating.

4.72 - Enhancements

  1. One Step Web Site / Masthead Icon - Added option for no mastehad icon.
  2. Recall/Calculate Box Score - Where possible, the initial game number selection will default to the last game number used in previous commands (eg: Update Player Stats).

4.71 - General Release

4.71 - Fixes

  1. One Step Web Site
    1. Preferences - Corrected dropdown array for Next Game Marker selection.
    2. Corrected syntax error for caching directives.
    3. Corrected Content Peferences dialog box sizing.
    4. Corrected some web theme parameters.
    5. Current game box score display wasn’t restored under some conditions.
    6. Corrected some minor HTML/CSS syntax violation errors.

4.71 - Enhancements

  1. None.

4.70 - General Release

4.70 - Fixes

  1. Web Themes Selection - Dropdown list did not allow new theme selection.
  2. Stats Importers - Fixed instances where FINES and Slow-Pitch Tracking Mode entries weren’t processed correctly.
  3. Consolidate Expansion Roster - Command was disabled incorrectly on SBC Ribbon.
  4. Convert Worksheet Format - Fixed some issues when converting a Multi-Season mode file to Single Season format.
  5. Commands that allow traversal of rosters didn’t work correctly under some conditions.
  6. Fixed situations where the screen display was jumpy during commands.
  7. Add Player - Fixed player name chaining for next command.
  8. Validate Player Stats - Reported an incorrect count of stats entried analyzed.
  9. Configure New Season / Team - Fixed corruption if executed Multi-Season mode.
  10. Misc bug fixes

4.70 - Enhancements

  1. Update Masthead Banners is now an interactive dialog.
  2. Added Export Stats command.
  3. Added Export Standings command.
  4. Stats Importers - Improved stats verification and progress displays
  5. Standings Import - Added format flexibility for identifying labels.
  6. One Step Web Site - Enhanced code to prevent web browser caching of web pages.
  7. Export Stats –
    1. Added support for Multi-Season Mode exports.
    2. Added progress display.

Known Errata and limitations

  1. The SBC is designed to operate on US versions of Excel and may not work on some international versions, especially non-English language versions due to major functional limitations in the underlying Excel macro engines.
  2. The File / Print command will result in more than one print dialog.
  3. Performance of the SBC varies on different versions of Excel. This is due to implementation differences of the various Excel versions.
  4. Closing the SBC via the Excel / Exit command, or X close buttons on some versions of Excel may result in a prompt to save the SBC_Macros.xlm file. Answering Don’t Save will allow proper termination. Preferable to use the SBC File/Quit Softball Calculator command. See User Manual for more details.
Toolbars and Palettes
  1. The checked/unchecked state of the toolbar items on the View menu do not immediately reflect the state of the toolbars if a toolbar is closed via a toolbar close button. They will reflect the correct states after the next SBC menu command is executed. This is a limitation as the macros do not have dynamic access to these events.
  2. On some versions of Excel on the Macintosh, some of the Excel built-in toolbars are not available. These toolbars will appear dimmed on the View menu.
  3. On Excel versions with the Ribbon UI, the SBC View menu is no longer present.
Web Page Processing
  1. Relative URL addresses cannot be used if the Player Files Directory option is activated. Use addresses that result in absolute URL’s. Otherwise, incorrect links may be generated in the player files. The SBC will test for this situation and alert the user to correct the URL’s.
  2. The save areas for web pages and HTML tables must be contiguous cell selections. This is an issue only for the File / Save Selection As Web Page or Save Selection As HTML Table commands as they allow user selectable cell areas.
  3. Graphics objects for web pages may not match the images pasted on the team worksheet if the user specifies an incorrect file link for the web graphic or if the user modifies the graphic on screen. Printed pages are not affected.
Windows Platform Specific
  1. Dialog boxes that have editable entries are configured for the expected type of values. Examples are game numbers expect positive integer values. On Excel on the Mac, the native dialog manager will alert the user when attempting to enter the wrong data type. However, not all versions of Excel on Windows will report an incorrect data type entry with an alert message. Instead, hitting any button to continue will appear that the program is hung (Excel 2019 is an example). The focus will usually highlight the first entry that is incorrect. The only solution is to visibly check the entries for mismatches.
  2. On some Windows versions of Excel, the SBC Help / Excel Help command is not functional. In addition, the standard Excel Help toolbar button may not be displayed in the SBC Toolbar. To view the standard Excel Help, click on the icon in the window or in any dialog box drag bar.
  3. Dialogs with dropdown menu lists may have blank slots in the list. This is an anomaly of the Windows dialog item processing in some Excel versions.
  4. The File / Page Setup and File / Print commands may result in a macro error if executed without a printer selected previously. This is most prevalent on the Windows platform. Solution is to insure that a printer has been selected prior to executing either of these commands. Use the File / Printer Setup command.
  5. Several dialogs have combination edit/dropdown menu items such as player names, color number/name selection. If the user activates the dropdown menu and decides to not select one of the items, the first item in the list will be selected and will override any user value in the edit box. This is an anomaly of the Windows dialog item processing. If this occurs, hit the Cancel button to preserve the original value and retry the command again.
  6. Occasionally on some commands, an error dialog of Can’t Empty Clipboard may occur. The internal operation is usually exceuted correctly. This is a well-documented problem on older versions of Excel and other Office products on Windows. There are a number of causes for this. The SBC attempts to bypass most of these instances. Unfortunately, some are beyond the capabilities of the SBC to address.
  7. On some Excel versions, the Help key does not get mapped to the SBC Shortcuts. The keyboard equivilent: ctl+alt+? and toolbar button do work correctly.
  8. Performance on Excel/2013 is slower than on other versions such as Excel/2010 on equivilent systems.
  9. The Window menu has no function under versions of Excel with the Ribbon Interface and therefore does not appear on the SBC menu bar.
  10. The File Open command cannot be used to open additional documents under versions of Excel with the Ribbon Interface. Double-click on the document to open it.
  11. On some versions of Excel (eg: 2007, 2010), the Print Preview option results in what appears to be a hang condition with no controls to terminate the mode. This is an anomoly of Excel. To terminate the mode, go to the Windows Task Bar, right-click on the Excel icon, and run the End Window command. This will return control to the SBC.
  12. The File / About Softball Calculator command will usually report the underlying operating system as: Windows NT 6.01 regardless of the actual operating system. This is an inherent Excel macros issue. No work-around.
Macintosh Platform Specific:
  1. The SBC is supported under Excel Office/2004 or 2011 only. The SBC Ribbon UI is not supported, only the legacy menus and toolbar interface. Other Office versions lack of critical macro functionality for SBC operation.
  2. Performance of the SBC on most version of Excel on the Macintosh platform is inherently slower than on the Windows platform, given similar hardware. This is an inherent limitation due to the Excel macro language implementation differences between the two platforms.
  3. The Format / Alignment, Format / Patterns and Format / Borders and equivalent toolbar buttons are disabled on the Mac versions of Excel prior to Excel/2011 due to bugs in the underlying Excel macros.
  4. The About Softball Calculator command will report the system environment as PowerPC, not Intel if the version of Excel is running under the Rosetta PowerPC emulator (Example: Excel 2004 under OSX 10.4 on an Intel-based Mac).
Excel/2011 Macintosh Platform Specific:
  1. Starting with Excel 2008, a new Ribbon User Interface was introduced. This is a hybrid implementaion compared to the Windows Ribbon UI. The SBC menus will still appear in the menu bar at the top of the window and the SBC toolbars are still floating toolbars as in previous versions.
  2. Many of the built-in Excel tools and functions formally available via floating toolbars have been relocated to the Ribbon UI.
  3. The SBC Team Worksheets are configured to show page breaks. On Excel 2011, this function is broken. This is primarily for aesthetic purposes. Printing and web page generation are not affected There is no workaround for this.
  4. When executing commands that take a fair amount of time to execute, the contents of the window may appear to jump or flash. This is cosmetic only.
  5. A Script menu is displayed on the custom SBC menu bar. The SBC cannot block this.
  6. The Formula button on the SBC toolbar is disabled as the supporting macros under XL2011 are broken. Use the formula button on the Excel quick function toolbar instead.
  7. The mouse cursor doesn't change to a watch cursor when an SBC command is running. Check the Status Bar at the bottom of the window or the progress bar box for activity.
  8. On completion of program startup, the SBC may lose window focus. Clicking on the window will restore focus.
    This can be caused by previous use of the Excel Developer tab and the VBA editor. Insure that the Home tab is the active tab. Sometimes, clicking on the Developer tab and opening and closing the VBA editor will fix this.

© 2000-2021 Softball/Baseball Team Calculator

Lightbox2 - Courtesy of Lokesh Dhakar