Softball/Baseball Team Calculator - SBC

 

Version 4.71. Version History, Known Errata, and Limitations
Last Updated: 07/07/21

Check out the previous revision history for previous revisions.

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.

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.

4.62 - General Release

4.62 - Fixes

  1. Maintenance release - Misc bug fixes.

4.61 - General Release

4.61 - Fixes

  1. Pending notifications count in the Ribbon was incorrect under some conditions.
  2. Edit Schedule - did not process entries with no opponent specified correctly unde some conditions
  3. Analyze Schedule - did not report some missing entries correctly.
  4. Schedule Export - did not show the default filename if vCal export file format.
  5. Division Standings - GBL display wasn’t reactivated under some conditions.

4.61 - Enhancements

  1. Schedule Import - Improved General Format processing.
  2. SBC Ribbon - Improved stability.

4.60 - General Release

4.60 - Fixes

  1. Game Schedule - Display was incorrect under some conditions.
  2. Clear Player Stats by Game/Year - Fixed problems when deleting entries for players.
  3. Keyboard shortcut (ctl+alt+?) displayed incorrect dialog box on Windows platforms.
  4. Fixed problem where keyboard shortcuts display would disappear without user intervention.
  5. Corrected SBC ribbon commands, labels and tooltips.
  6. Copy to Clipboard of predefinded areas commands didn’t work properly.
  7. Leaders Update - Fixed crash in Muti-Season Mode if user hit Cancel to options prompt.
  8. Corrected issues importing into Muti-Season Mode files using the General Import File Format.
  9. Save As - Fixed problem that caused a macro error after the save operation.
  10. Consolidate Expansion Roster - Did not process single season selections correctly.
  11. Rename Player - Corrected mapping of suffixes that may be appended to player names.
  12. Division Standings - Corrected errors that occurred if non-numeric values were entered in the W-L-T records.

4.60 - Enhancements

  1. Performance enhancements when running under the Ribbon UI.
  2. Added Import Standings feature.
  3. Check For Updates added.
  4. SBC can be conditionally run with other Excel Add-ins active.
  5. Enhanced error detection and reporting for all file import operations.
  6. Improved Schedule Analyzer.
  7. Multi-Season Mode:
    1. Added Configure New Season function.
    2. Added option to clear all player stats for selected seasons range.
  8. Web Site Processing:
    1. Added user-selectable icons for web page mastheads.
    2. Added ability to preview built-in web themes.
  9. Division Standings - Improved validation of W-L-T entries (non-positive integer values).

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. 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. 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.
  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 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.
  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. 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.
  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. 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.
  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. The Window menu has no function under versions of Excel with the Ribbon Interface and therefore does not appear on the SBC menu bar.
  9. 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.
  10. 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.
  11. 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