Softball/Baseball Team Calculator - SBC

 

Version 4.82 - Version History, Known Errata, and Limitations
Last Updated: 06/24/22

Check out the full revision history for previous revisions.

4.82 - General Release

4.82 - Fixes

  1. Minor issues related to player name suffixes mapping.
  2. Consolidate Expansion Roster – Did not show updated results after consolidation during interactive sessions
  3. Page break display on Excel/2011 on the Mac has been fixed.
  4. Screen zoom settings changes were not retained.
  5. Setting the category labels fill color to white or no fill prevented gridline display for the labels.
  6. Edit Schedule – Did not properly test for update to current Box Score under some conditions.
  7. Update Leaders – Banner labels were not properly set after a clear of leader area displays.
  8. Game Range Display – Did not work under sonme conditions (caused macro error).
  9. Miscellaneous stability and bug fixes.

4.82 - Enhancements

  1. Page number watermarks have been removed for improved user visibility of window contents.
  2. Schedule Manager – Can highlight multiple Next Unplayed Game entries on the same date (eg: doubleheaders, tournanments).

4.81 - General Release

4.81 - Fixes

    One Step Web Site – Corrected generation of robots.txt file.
  1. Removed several instances where the display scrolled to schedule page inadvertantly.
  2. Miscellaneous stability and bug fixes.

4.81 - Enhancements

  1. Update Batting Leaders – Runtime parameters prompt now displays the PA or AB value used in the last upate computations. Useful to maintain consistency in Multi-Season leaders updating.

4.80 - General Release

4.80 - Fixes

  1. Miscellaneous stability and bug fixes.

4.80 - Enhancements

  1. Schedule Importer -
    1. Improved format processing and error reporting.
    2. Added filtering support to allow master league schedules to be used as a source file.

Known Errata and limitations

General:

  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. Performance of the SBC varies on different versions of Excel. This is due to implementation differences of the various Excel versions.
  3. Closing the SBC via the X close button 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 General / SBC Quit button.
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 selection areas for web pages and HTML tables must be contiguous cell selections. This is an issue only for the Web Composer / Selections / 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. Not all versions 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. 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.
  3. The General / Print, General / Print Selection and General / Print / Page Setup commands may result in a macro error if executed without a printer selected previously. Solution is to insure that a printer has been selected prior to executing either of these commands. Use the General / Print / Printer Setup command.
  4. 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. If this occurs, hit the Cancel button to preserve the original value and retry the command again.
  5. 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. The SBC attempts to bypass these instances.
  6. 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.
  7. Performance on Excel/2013 is slower than on other versions such as Excel/2010 on equivilent systems.
  8. 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. 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.
  9. The SBC Help/ Info 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 OSX 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).
  5. The command progress box is not implemented as non-modal forms are not supported on the Mac. Command progress is still shown on the Status Bar in the lower left corner of the Team Worksheet window.
  6. The Check for Updates function cannot perform the revision test due to lack of supporting internet libraries. It will inform the user to perform this test manually.

Excel/2011 Macintosh Platform Specific:

  1. Starting with Excel 2008, a new Ribbon 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 Excel Ribbon.
  3. 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.
  4. A Script menu is displayed on the custom SBC menu bar. The SBC cannot block this.
  5. 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.
  6. The mouse cursor doesn't change to a watch icon when an SBC command is running. Check the Status Bar at the bottom of the window or the progress bar box for activity.
  7. On completion of program startup, the SBC may lose window focus. Clicking on the window will restore focus.

© 2000-2022 Softball/Baseball Team Calculator

Lightbox2 - Courtesy of Lokesh Dhakar