What's new in Softball/Baseball Team Calculator 5.21

Mar 29, 2024
  • Fixes:
  • One Step Web Site – Corrected problem where some Google font families were not loaded.
  • One Step Web Site –Added Audiowide Google font as an option.
  • Delete Player Stats By Game Range - Corrected updating issues for Box Score, Batting Leaders and Division Standings.
  • User Notes / Format – Command did not scroll to the User Notes page correctly.

New in Softball/Baseball Team Calculator 5.20 (Feb 19, 2024)

  • Enhancements:
  • One Step Web Site - Added option for Privacy and Security Notice web page.
  • Added Mouse/Touch Mode control to Quick Access Toolbar. Controls spacing of Ribbon buttons on screen.
  • General cleanup of message, progress, and alert boxes.
  • Fixes:
  • Division Standings - Games Behind Leader display setting was not preserved on re-launch.
  • Pasted Graphics Processing - Corrected reporting of missing picture links during One Step Web Site Command.
  • File Processing - Fixed condition where the current directory setting was not preserved for subsequent selections.
  • Misc bug fixes.

New in Softball/Baseball Team Calculator 5.10 (Sep 29, 2023)

  • Enhancements:
  • One Step Web Site:
  • Added section in User Manual with procedures to Creating a Web Site With Multiple Seasons and Career Stats that is easy for user navigation and web site maintainence.
  • Added 11 new masthead icons.
  • Box Scores Web Page – No longer needs Javascript to display
  • Box Scores:
  • Added ability to handle games that go beyond 10 innings.
  • A blank line score entry in an inning for one team will assume to be 0 if the other team has a valid runs entry.
  • Fixes:
  • Web Themes:
  • Masthead fill color on screen was not getting updated when a web theme change occurred via manual selection/modification or by importing a web theme file. This did not affect web page generation.
  • Batting Leaders Update – Corrected calculations for minimum PA/AB qualifier to account for forfeited games.
  • Calculate Box Score:
  • Total runs scored by Home Team verification should be supressed if the game is marked as a Foreit/Forfeit – Win/Forfeit – Loss.
  • One Step Web Site:
  • Minor fixes to zebra striping of content tables.
  • Corrected issue where the Home Page URL did not update correctly if Inlcude Files Processing mode had been changed.
  • Corrected some

New in Softball/Baseball Team Calculator 5.00 (Aug 14, 2023)

  • Enhancements:
  • Major Rewrite of Print System
  • Integrated into Excel Backstage Print for print, preview, reformating and save as pdf.
  • Removed the need for multiple print dialogs.
  • Added Print Options / Configure command to select content areas to be printed. Also selectable at invocation of Print command. Includes option for Box Scores printing: Best Fit or One per page
  • Added Print Player Stats command to print a selected player stats.
  • Content Area Block Titles – The attributes of any block title (eg: Division Standings) can be modified by using Format / Cells commands or by loading a Web Theme. The changes can be optionally propagated to the other block titles.
  • One Step Web Site –
  • All content block titles use the styles of the Division Standings title as a reference.
  • Improved font family processing for better cross-browser compatibilty.
  • Improved color processing for text and backgrounds.
  • Box Scores – Main Team Name highlighting option added.
  • Division Standings – Main Team Name highlighting option added.
  • Fixes:
  • Print Preview – Fixed problems by integrating into Backstage print.
  • General / Print commands no longer result in a macro error if a printer has not been configured.
  • Update Batting Leaders - A manual request to recalculate the Minimum AB/PA computed an incorrect result.
  • Add Player Name – Switching the target roster selection in the dialog box inadvertantly cleared the new player name.
  • Division Standings, Import Standings – Detection of duplicate team names and invalid WLT entries corrected.
  • One Step Web Site – Corrected some issues related to printing a web page, especially Google Chrome.

New in Softball/Baseball Team Calculator 4.86 (Jun 26, 2023)

  • Box Scores Web Page – Added display of Main Team Name WLT record. Improved overall layout.
  • Fixes:
  • Simulated Page Break Mode - Background fill color was not getting set properly in some cases (eg: adding or removing games in schedule).
  • Update Batting Leaders – Fixed some conditions where the initial minimum AB/PA initial value was not computed correctly.
  • Web Themes - Masthead Banner Text and Fill Colors are now set correctly on older versions of Excel on the Mac.
  • Miscellaneous bug fixes

New in Softball/Baseball Team Calculator 4.85 (Jun 11, 2023)

  • Version 4.85 incorporates new Web themes and modifications to existing themes. If you are using one of the existing pre-defined web themes, use the Web Composer / Preferences / Web Themes command to update the changes

New in Softball/Baseball Team Calculator 4.84 (Apr 3, 2023)

  • Bug fixes and enhancements.

New in Softball/Baseball Team Calculator 4.83 (Sep 25, 2022)

  • Attempting to navigate selection of player name or player name plus game number dialogs via keyboard inputs editing did not work correctly and could cause unpredictable results.
  • Game Range display command was broken.
  • Rename Player - Corrected player name validations.
  • Consildate Expansion Roster – Could crash if a duplicate player name situation was detected after a stats import.
  • Navigating to the Batting Leaders page did not properly scroll to the top of the page.
  • Corrected some additional instances that could cause Can’t Empty Clipboard messages.
  • Miscellaneous stability and bug fixes.

New in Softball/Baseball Team Calculator 4.82 (Jun 25, 2022)

  • Bug fixes and enhancements.

New in Softball/Baseball Team Calculator 4.81 (May 13, 2022)

  • Bug fixes and enhancements.

New in Softball/Baseball Team Calculator 4.80 (Apr 16, 2022)

  • Miscellaneous stability and bug fixes.

New in Softball/Baseball Team Calculator 4.771 (Mar 27, 2022)

  • Corrected access problems to Online User Manual, SBC web site, revision verification, etc. Resulted from server upgrade to secure site (https

New in Softball/Baseball Team Calculator 4.77 (Mar 21, 2022)

  • Fixes:
  • Select Player Stats - Didn’t include TOTALS: line for Active Roster players when copying to clipboard.
  • Corrected problems with file selection handling.
  • Miscellaneous bug fixes.
  • Stats Importer:
  • Some forms of comment lines were not bypassed.
  • Corrected file format validation issues.
  • Count of new players added was incorrect under some conditions.
  • Auto-Fill Player Position did not work correctly for players in the Expansion roster.
  • Some documents that were open when importer was invoked were not properly closed.
  • Auto-player position processing fixed.
  • Enhancements:
  • Stats Importer - Added support for 3rd party apps: Game Changer (Classic and Manager), FixedIt Baseball Scorebook and Sleek Stats
  • Roster Exporter – Added quting of player names in file for better compatibility with other apps.
  • Roster Importer – Enhanced to accept Number Plus Player Name formatted files.
  • Player Name processing enhanced to handle common surname suffixes (eg: Jr, Sr, etc.).
  • Improved file selection and type validation for Save As, import and export functions.
  • Standings Importer:
  • Added support for 3rd party apps: Sleek Stats
  • Enhanced General stats importer to accept user-defined stats field formats.

New in Softball/Baseball Team Calculator 4.76 (Jan 31, 2022)

  • Fixes:
  • One Step Web Site - Home page navigation link wasn’t re-computed properly after some commands (eg: Configure New Season).
  • On startup, detection of an unsupported version of Excel might result in macro error instead of an alert to the user.
  • Calculate Box Score – Corrected formula that created a #SPILL condition in the Line Score Totals (Excel 2021).
  • Enhancements:
  • Verified SBC operation on Excel/2021 on Windows platform.
  • Added Data tab with commands to manage links to external documents.

New in Softball/Baseball Team Calculator 4.75 (Dec 14, 2021)

  • Fixes:
  • Check for SBC Revision - Corrected alert message options when unable to access SBC web site.
  • Update Batting Leaders – Fixed problem where incorrect game range parameters were shown under certain conditions.
  • Dialog boxes centering issues.
  • Enhancements:
  • One Step Web Site - Reordered content blocks for better fit.
  • Update Batting Leaders –Streamlined dialog boxes for runtime options.
  • Modified for access to secure SBC web site.
  • On-Line User Manual converted to use browser pdf capabilities for better navigation and searching.

New in Softball/Baseball Team Calculator 4.74 (Nov 12, 2021)

  • Fixes:
  • Documents did not display a standard ribbon tab set.
  • Quick Action Toolbar (QAT) functions and shortcuts incorrectly mapped to SBC functions.
  • Closing documents that had been modified did not prompt to save changes (Windows versions of Excel).
  • One Step Web Site
  • Corrected formatting of robots.txt file.
  • Corrected zebra striping on Division Standings block with odd number of teams.
  • Activating the home page weather forecast option corrupted the home page display.
  • Import Summary and Export Summary did not show all commands with previous command summaries.
  • Update Player Stats – Did not test correctly for all cases where Box Score or Batting Leaders required updating.
  • Repair Player Stats – Did not post alert if Box Score or Batting Leaders required updating after repairs.
  • Enhancements:
  • Results of Stats Export command can be recalled via Export / Export Summary.
  • Added Batting Leaders / Clear command to SBC Ribbon.
  • Added Excel Watch Window tool to View menu.
  • Added options to automatically update Box Score and Batting Leaders when needed.
  • Enhanced testing for cases where Box Score or Batting Leaders require updating.
  • Where possible, previous dialog box parameter selections are preserved for subsequent calls.
  • One Step Web Site Weather service changed to weatherWX.com
  • Added support for Canadian cities
  • Added support for location using zipcode (US locations only)
  • Added option for forecast display

New in Softball/Baseball Team Calculator 4.73 (Oct 4, 2021)

  • Fixes:
  • Some import functions did not gracefully exit if an invalid file format was detected.
  • Player Stats Edit - Played But Did Not Bat function did not operate correctly
  • Misc bug fixes.
  • One Step Web Site
  • Corrected a situation where Line Score overflowed the display on small mobile devices.
  • User-defined navigation tab links did not follow position option setting. Always appeared after pre-defined links.
  • Corrected some instances where zebra table striping did not work correctly.
  • Enhancements:
  • Overall performance improvements.
  • Schedule Analyzer – Improved analysis of completed games.
  • Progress displays show more detail during long operations such as roster optimizations.
  • Batting Leaders – Streamlined runtime options dialog
  • One Step Web Site:
  • Enhanced validation of URL entries to be compliant with W3C stnadards.
  • Added option to display masthead icon examples.
  • Added a sample file for user-defined Home Page Content to the 4.73 distribution file.
  • Export Stats:
  • Added support for Multi-Season Mode exports.
  • Added Batting Summary stats export option.
  • Added progress display.

New in Softball/Baseball Team Calculator 4.72 (Aug 5, 2021)

  • Fixes:
  • One Step Web Site - Corrected some styling inconsistencies.
  • SBC Ribbon - Some commands were not disabled under certain conditions.
  • 4. Some keyboard shortcut commands were not blocked under certain conditions.
  • Box Score:
  • Corrected a condition where Box Score add/update function was prevented.
  • Corrected instances where the current Box Score wasn’t flagged to be updated
  • Add/Update function did not properly test for changes in the displayed line score vs. stored version before updating.
  • Enhancements:
  • One Step Web Site / Masthead Icon - Added option for no mastehad icon.
  • 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).

New in Softball/Baseball Team Calculator 4.71 (Jul 7, 2021)

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

New in Softball/Baseball Team Calculator 4.70 (Jun 19, 2021)

  • Fixes:
  • Web Themes Selection - Dropdown list did not allow new theme selection.
  • Stats Importers - Fixed instances where FINES and Slow-Pitch Tracking Mode entries weren’t processed correctly.
  • Consolidate Expansion Roster - Command was disabled incorrectly on SBC Ribbon.
  • Convert Worksheet Format - Fixed some issues when converting a Multi-Season mode file to Single Season format.
  • Commands that allow traversal of rosters didn’t work correctly under some conditions.
  • Fixed situations where the screen display was jumpy during commands.
  • Add Player - Fixed player name chaining for next command.
  • Validate Player Stats - Reported an incorrect count of stats entried analyzed.
  • Configure New Season / Team - Fixed corruption if executed Multi-Season mode.
  • Enhancements:
  • Update Masthead Banners is now an interactive dialog.
  • Added Export Stats command.
  • Added Export Standings command.
  • Stats Importers - Improved stats verification and progress displays
  • Standings Import - Added format flexibility for identifying labels.
  • One Step Web Site - Enhanced code to prevent web browser caching of web pages.

New in Softball/Baseball Team Calculator 4.620 (May 26, 2021)

  • Maintenance release - Misc bug fixes.

New in Softball/Baseball Team Calculator 4.610 (May 3, 2021)

  • Pending notifications count in the Ribbon was incorrect under some conditions.
  • Edit Schedule - did not process entries with no opponent specified correctly unde some conditions
  • Analyze Schedule - did not report some missing entries correctly.
  • Schedule Export - did not show the default filename if vCal export file format.
  • Division Standings - GBL display wasn’t reactivated under some conditions.
  • Enhancements:
  • Schedule Import - Improved General Format processing.
  • SBC Ribbon - Improved stability.

New in Softball/Baseball Team Calculator 4.600 (Apr 2, 2021)

  • Fixes:
  • Game Schedule - Display was incorrect under some conditions.
  • Clear Player Stats by Game/Year - Fixed problems when deleting entries for players.
  • Keyboard shortcut (ctl+alt+?) displayed incorrect dialog box on Windows platforms.
  • Fixed problem where keyboard shortcuts display would disappear without user intervention.
  • Corrected SBC ribbon commands, labels and tooltips.
  • Copy to Clipboard of predefinded areas commands didn’t work properly.
  • Leaders Update - Fixed crash in Muti-Season Mode if user hit Cancel to options prompt.
  • Corrected issues importing into Muti-Season Mode files using the General Import File Format.
  • Save As - Fixed problem that caused a macro error after the save operation.
  • Consolidate Expansion Roster - Did not process single season selections correctly.
  • Rename Player - Corrected mapping of suffixes that may be appended to player names.
  • Division Standings - Corrected errors that occurred if non-numeric values were entered in the W-L-T records.
  • Enhancements:
  • Performance enhancements when running under the Ribbon UI.
  • Added Import Standings feature.
  • Check For Updates added.
  • SBC can be conditionally run with other Excel Add-ins active.
  • Enhanced error detection and reporting for all file import operations.
  • Improved Schedule Analyzer.
  • Multi-Season Mode:
  • Added Configure New Season function.
  • Added option to clear all player stats for selected seasons range.
  • Web Site Processing:
  • Added user-selectable icons for web page mastheads.
  • Added ability to preview built-in web themes.
  • Division Standings - Improved validation of W-L-T entries (non-positive integer values).

New in Softball/Baseball Team Calculator 4.500 (Jun 8, 2020)

  • Enhancements:
  • Stats Importer
  • a.Added Generalfile formatsfor importing from non-SBCsources. Game-by-Game (Single Season) and Season Totals (Multi-Season) formats.
  • b.Improved mapping of import file player name syntax to match target Team
  • Worksheet.
  • Schedule Page-If game numbers disaply is off, games will appear based on Date/Time sort order. This allows more flexibility in assigning game numbers to practice games, playoffs, etc.
  • AutoFill Player Postions (POS)-Added user control of this function for stats updating and importing.
  • Reformat Player Names -New command to change player name formats LastName, FirstName<> FirstName LastName. Useful after stats importing especially from non-SBCsources.
  • Stats Validator-Enhanced to work with Multi-Season Mode stats.
  • Fixes:
  • SBC Ribbontab did not appear as the active tab after startup on some versions of Excel/Windows.
  • .Corrected initial SBCwindow sizing and positioning under some conditionsduring startup.
  • Fixed a problem where crashes occurred after posting alerts during some import operations (Windows Excel versions).4.Check Rostercommand -Fixed error if there were players with markers set from previous import operation.
  • Refresh and Display Schedulecommand -Did not change focus to schedule page after refresh.
  • Edit Schedule Manager-Removed extraneous debugging code that occurred when a new game entry was processed.
  • Corrected some situations where the schedule did not get refreshed.
  • Save As-Fixed error that would occur if the new file was not an .xlsworkbook format.
  • Transfer Player Stats-Corrected problems when transferring stats from Expansion Roster to Active Roster.
  • Duplicate Players in Roster -Fixed condition that names could not be resolved under someconditions in Multi-Season Mode

New in Softball/Baseball Team Calculator 4.400 (Mar 20, 2020)

  • Enhancements:
  • .Division Team Names Editor
  • Improved processing and validation of team names.b.Added function to change Main Team Name
  • Schedule Editor -Games can be entered withouttheteam present in the Division.
  • Stats Importer-Added documentationand sample filesto perform stats importing from unsupported 3rdparty apps.
  • Schedule / Next Unplayed Game Highlighting
  • Added user override option to force highlighting.
  • Added User Manual documentation and file templates for importing stats from alternative sources.
  • Fixes:
  • SBC Ribbon (Windows 2010 or newer)
  • Ribbon commands for Box Score were incorrectly blocked under some conditions
  • Tips and Supertips cleanup.c.Label for Standings / Auto Calcuate from Standingsshould read: Auto Update Standingsd.Corrected issues whenStandings / Auto Update Standingsmode was changed.
  • Edit / Schedulecommand
  • Now allows user to enter a blank opponent team name under some conditions
  • One Step Web Site -robots.txtfile was always created.
  • Did not follow Block Search Engines From Indexing Pagesoption setting.

New in Softball/Baseball Team Calculator 4.300 (Jan 31, 2020)

  • Version 4.30 incorporates enhancements, bug fixes and stability improvements, primarily to the SBC Ribbonuser interface introduced in version 4.20. The SBC_RH_ER_v4.30.pdffile details the changes, revision history and known errata.

New in Softball/Baseball Team Calculator 4.200 (Dec 30, 2019)

  • SBC Version 4.20 - Complete Package with User Manual (19 MB compressed zip file) new !
  • SBC Version 4.20 - User Manual only (8.6 MB pdf) new !
  • SBC Version 4.20 - Release Notes only (pdf) new !
  • SBC Version 4.20 - Revision History and Errata only (pdf)

New in Softball/Baseball Team Calculator 4.100 (Jun 14, 2019)

  • Version 4.10incorporates enhancements, bug fixes and stability improvements.The SBC_RH_ER_v4.10.pdffile details the changes, revision history and known errata.

New in Softball/Baseball Team Calculator 4.000 (Apr 10, 2019)

  • Version 4.000 introduces user-selectable Web Themes for use in generating web sites. The User Manual and on-line Tutorialdetails the selection and useof these themesas well as examples of each theme. In addition to the new themes, the legacy SBCtheme is included as well. More themes are being developed for future SBCreleases.

New in Softball/Baseball Team Calculator 3.993 (Feb 21, 2019)

  • Fixes:
  • Edit Schedule – Command would not terminate properly under some conditions.
  • Refresh and Display Schedule - Did not work correctly.
  • Pending Notifications were incorrect when switching between different team worksheets.
  • Edit General Preferences - Corrected crash that occurred when changing the Main Team Name selection.
  • Division Standings - Corrected erroneous fractional Games Behind Leader value that could occur under some conditions.
  • Links to SBC web site for Support and PayPal Donations did not work correctly on some versions of Excel on Windows.
  • Enhancements:
  • Edit Schedule - Enhanced sub-status display in dialog box for better detail.
  • Initialization - a. Speeded up by only refreshing schedule if needed. b. Display warning if there are pending notifications that need to be evaluated.
  • Refresh and Display Schedule - Added to Display menu.
  • One Step Web Site - Generates a default title when user saves a page as bookmark (eg: iOS Add To Home Screen).
  • Command Progress Windows - Implemented on additional commands.

New in Softball/Baseball Team Calculator 3.992 (Oct 12, 2018)

  • Fixes:
  • One Step Web Site – Excel 2011 Mac: Previously used folder selections are now preserved for subsequent use.
  • File / Save As – Fixed problems that could occur after the file save operation.
  • File / Import SBC Stats – Fixed condition where two prompts would occur to update batting leaders after importing.
  • Calculate / Batting Leaders - Fixed condition where an extraneous entry could occur in a leader category under some
  • Conditions.
  • File / Export Schedule - Fixed condition where control would enter Export Roster processing under some conditions.
  • Enhancements:
  • One Step Web Site – Directory selections for processed web pages converted to use standard directory selection dialogs.
  • Enhanced notification reporting for stats importing and box score processing.
  • Calculate / Batting Leaders - Improved calculation time.
  • SBC Toolbar - Export tool can now perform Schedule and Roster export operations.

New in Softball/Baseball Team Calculator 3.991 (Jun 17, 2018)

  • Removed extraneous debugging code from Box Score updater

New in Softball/Baseball Team Calculator 3.98 (Apr 2, 2018)

  • Edit Schedule command – Added detection and user alerts of some additional entry error conditions.
  • Fixed incorrect window positioning problems on launch under some versions of Excel on Windows.
  • Fixed hidden zoom slider problem on launch under some versions of Excel on Windows.
  • Fixed incorrect dialog box centering problems under some versions of Excel on Windows.
  • Fixed additional stability issues running under Excel/2011 on Mac OS X.
  • Fixed some dialog box labels that displayed truncated on some Windows versions of Excel.
  • Fixes:
  • File / Convert Worksheet format command:
  • Command was not functional in Version 3.97 release
  • Dialog and alert boxes weren’t centered when running under some versions of Excel on Windows.
  • SBC Toolbar:
  • The first option in the list from the System and Command Summary Info tool could not be executed.
  • The General Preferences option from the Edit Preferences tool could not be executed.

New in Softball/Baseball Team Calculator 3.97 (Mar 5, 2018)

  • Enhancements:
  • Box Score stats option selections now check for duplicates.
  • Enhanced Calculate/ Batting Leaders dialog box options.
  • Overall performance and stability improvements.
  • Game Schedule Manager:
  • Added Edit / Game Number. Allows renumbering of a single game or resequencing of all game numbers with variety of options.
  • Added Game Schedule Analyzer to check validity of schedule entries (eg: duplicate game numbers, duplicate entries with same Date and Time, etc). Invoked any time schedule has been modified either manually or via import. Can be invoked manually as well.
  • Added File / Export Schedule for calendar apps such as gCal, iOS Calendar, Outlook, etc.
  • Added computation of Main Team Streak (Wins, Losses or Ties) to Schedule Page summaries.
  • Enhanced Edit Schedule command dialog box processing.
  • Schedule importer now allows team opponent notation of ‘@’ as well as ‘at ‘ to denote an away game.
  • User Interface:
  • Enhanced SBC Toolbar with additional commands and custom icons.
  • Added progress completion percentage display to long commands (eg: One Step Web Site ). Appears on-screen in new Progress box (under Windows Excel versions only) or in Status Bar (Mac OS X Excel versions).
  • Added online SBC Help / SBC Revision History display command.
  • Division Standings:
  • Added user display control of Games Behind Leader in the Division Standings. Useful to turn off if the standings are kept as WLT records against the Main Team (eg: Auto Update Division Standings From Schedule mode)
  • Roster Management:
  • Added option to Consolidate Expansion Roster player entries during stats importing operation (Multi-Season Mode).
  • Added Previous Player Stats area command to Select menu.
  • Fixes:
  • Corrected parameter checking and calculation of default values in Calculate/ Batting Leaders dialog box options.
  • Calculate / Division Standings command incorrectly showed a date of Jan 01 in the Division Standings display if the user had entered a blank value for the date in the command dialog options box.
  • One Step Web Site might crash building the game schedule web page under some conditions.
  • Commands that traversed the rosters in the reverse direction didn’t work properly under some roster boundary conditions.
  • On startup, previous size of Team Worksheet window is maintained from previous session.
  • Fixed stability issues running under Excel/2011 on Mac OS X. 2.
  • User Interface:
  • Keyboard equivilent mapping for Display Previous/Next Player Stats areas were incorrect.
  • Quit of SBC caused an incorrect save of the SBC_Macros file on some versions of Excel.
  • Box Score:
  • Team batting average in Box Score was incorrectly calculated if Plate Appearances option was selected.
  • Box Score user selectable stats options weren’t properly saved under some conditions.
  • Game Schedule Manager:
  • Schedule display wasn’t getting updated under certain conditions.
  • Schedule Manager wasn’t blocking non-integer game number parameters correctly.

New in Softball/Baseball Team Calculator 3.96 (Jul 12, 2017)

  • Enhancements:
  • 1. Added ability to traverse rosters in reverse direction for player selection during player-related commands. 2. One Step Web Site: Modified web page generation to speed up web page load times. 3. Improved message bar display of game counts. 4. Improved Game Schedule Manager processing. 5. Improved roster import file validity checking. 6. Added status indicator on Schedule page and Edit Schedule command if an entry has player stats but no schedule entry.
  • Fixes:
  • 1. Fixed instability and crash issues when running under Excel 2011 on the Mac. 2. Corrected false prompt to save the SBC_Macros.xlm file on some versions of Excel when quitting the SBC. 3. Corrected automatic updating of Next Game in Notices area. 4. Corrected problem where file importing did not allow all file types to be selected (older versions of Excel on Mac platform only). 5. When starting an Update Player Stats session, the game number now correctly defaults to the number of games played by the Home Team. 6. Posted processing date in footer area (Updated: mm/dd/yyyy) on player stats pages was incorrect under some conditions during One Step Web Site processing. 7. Corrected comands that did not properly test conditions to prompt the user to update the Leaders or Box Scores. 8. Corrected conditions where the repeat last command entry was getting cleared out incorrectly to Can’t Repeat.
  • 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 Palette:
  • 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 does not work under Excel Office 2016 due to lack of critical functionality to create custom menus.
  • 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 of on 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/2008 and 2011 Macintosh Platform Specific:
  • Excel 2008 and 2011:
  • 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 2008 and 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 prompted for file or directories, the previously used directory location is not preserved. There is no workaround for this.
  • 5. 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.
  • 6. A script menu is displayed on the custom SBC menu bar. The SBC cannot block this.
  • Excel 2008 Only:
  • 1. The SBC custom toolbars are not available (limitation in XL2008 macros). Use the equivilent menu commands instead.
  • 2. The SBC Team Worksheets are normally configured for display in Page Break Preview mode. This mode is not available. The button for Normal View located at the lower left corner of the window must be selected manually for proper SBC operation.
  • 3. On Excel 2008, custom content area graphics are not supported. Working with non-SBC documents is supported. However, switching windows must be done via the Window menu in order to get the menus and toolbars to switch correctly.
  • Excel 2011:
  • 1. When qutting the SBC, a prompt to save the SBC_Macros.xlm file occurs. This cannot be prevented like on other versions of Excel. Always answer Don’t Save to this prompt.

New in Softball/Baseball Team Calculator 3.95 (Feb 27, 2017)

  • ENHANCES:
  • Added on-line SBC User Manual from SBC Help menu
  • Added Display / Box Score command to recall a specific game to the Summary Page
  • Added additional conditions to prompt the user to update the Leaders/Box Score when changes to the stats might cause them to be incorrect.
  • Print command enhanced to allow selective printing of each major stats area.
  • SBC Support and Donate to SBC Development commands now invoke the applicable page at the SBC Web Site.
  • FIXES:
  • Under some conditions, the current selected Box Score display wasn’t restored on the Summary Page after the Box Score web page was processed.
  • Web and print options to "Show Completed Games Only" didn’t include games that had a line score entry but no stats.
  • Update Player Stats command did not show the correct default game number under some situations.
  • Import Stats comands would alert the user to update the batting leaders even if no stats were imported.
  • Import Schedule would interpret a blank opponent name entry as a zero and incorrectly create a bad division team name.
  • Edit / Custom Hyperlink command flushed the clipboard contents prior to displayed the dialog box. This prevented copy/paste of a URL from an external source.
  • Custom hyperlinks that had id= embedded in the URI where incorrectly interpreted as an anchor ID field
  • Erroreous macro error with message “Can’t Enable Built-in Commands” would occur occasionally. This was mostly when running under Excel/2011 on the Mac.
  • Corrected automatic posting of Next Game in Notices block if Time, Field, or Opponent were not defined.

New in Softball/Baseball Team Calculator 3.94 (May 30, 2016)

  • GENERAL INFORMATION:
  • Version 3.94 incorporates enhancements and fixes. The SBC_RH_ER_v3.94.pdf file details the changes, revision history and known errata.
  • The SBC represents hundreds of hours of development and testing. If you find the program to be useful, a donation via PayPal would be appreciated ! The SBC website at: http://sbc.aces-softball.com/ has instructions for donations.
  • The SBC website at: http://sbc.aces-softball.com/ has a quick overview of the program features under the HIGHLIGHTS tab. An introduction to the operation of the SBC can be found under the TUTORIAL tab.
  • A full user manual with detailed installation and operating instructions is available.
  • Comments and suggestions welcomed via email to: [email protected]
  • INSTALLATION:
  • Section 2 of the User Manual gives detailed step-by-step installation instructions.
  • EXCEL COMPATIBILITY:
  • The SBC is an application that runs with a legal copy of Microsoft Excel® (not supplied). A 1 GHz processor or faster is recommended for best performance.
  • The SBC has been validated in the following environments:
  • Excel 2000, 2003, 2007, 2010, 2013 and 2016 under Microsoft Windows® • Excel/X, 2004, 2008 and 2011 under Macintosh® OS X
  • The SBC has not been recently validated and may not work on older versions of Excel such as Office ’97.
  • The SBC does not work on Excel 2016 on the Mac platform.
  • The SBC may not work on some internationalized versions of Excel, especially non-English versions, due to major differences in the Excel macro engines on these versions.
  • The SBC is not supported under OpenOffice®, NeoOffice® , Office365 or other spreadsheet programs due to the lack of macro support. 4 SECURITY SETTINGS The SBC is implemented in Excel XLM macros. On initial launch, the user will be prompted to enable the macros to proceed. The dialog posted by Excel will vary depending on the version of Excel and the current Excel security settings. To continue, enable the macro execution. If prompted, set the security settings to medium.
  • Some newer versions of Excel on the Windows platforms require some Trust Center security settings for the SBC to operate. Review Section 1 of the SBC User Manual for configuration details.
  • The SBC makes modifications to the team worksheet only. The only external file operations occur via user commands during creation of web page files, stats importing and creation of roster export files. The user has total control over the destination of all generated files.
  • The SBC does not perform any network operations. The SBC is internally password protected to prevent inadvertent corruption. 5 UPGRADING FROM PREVIOUS SBC VERSIONS The SBC provides forward compatibility for team worksheets that were created using previous releases.
  • To upgrade from a previous version of the SBC, simply replace the existing macros file with the SBC_Macros.xlm file included in the 3.94 distribution package. When a previous team worksheet is first launched with the v3.94 version of the SBC, a series of
  • SOFTBALL / BASEBALL TEAM CALCULATOR:
  • patches will be applied to the worksheet. This may take some time depending on the speed of the processor, version of Excel, and the previous version number. The message bar will show the progress of the patch application processing. When all the patches have been applied, the message bar will show SBC READY. After the team worksheet is saved, the patches are permanent.
  • On first launch of a team worksheet with the new macros, some informational messages may appear depending on the version of Excel that is being used. Once the team worksheet is saved, these messages will not appear on subsequent launches. 5.1 One Step Web Site Changes Version 3.60 introduced a major rework of the One Step Web Site command. All web pages are now generated as Responsive Design pages that dynamically adapt the content to mobile or deskop browsers. Thus, there is now only one URL per web page generated. This includes the main home page.
  • If you have existing team web sites, it is desireable to regenerate them using version 3.60 or later. If you have implemented userdefined links, check to insure that these links are still valid as there is only one link specification for each.

New in Softball/Baseball Team Calculator 3.90 (Apr 16, 2016)

  • Version 3.90 incorporates a number of new features, enhancements and fixes.
  • The SBC_RH_ER_v3.90.pdf file details the changes, revision history and known errata.
  • The SBC represents hundreds of hours of development and testing. If you find the program to be useful, a donation via PayPal would be appreciated ! The SBC website at: http://sbc.aces-softball.com/ has instructions for donations.
  • The SBC website at: http://sbc.aces-softball.com/ has a quick overview of the program features under the HIGHLIGHTS tab. An introduction to the operation of the SBC can be found under the TUTORIAL tab.
  • A full user manual with detailed installation and operating instructions is available.
  • Comments and suggestions welcomed via email to: [email protected] 2 INSTALLATION Section 2 of the User Manual gives detailed step-by-step installation instructions. 3 EXCEL COMPATIBILITY The SBC is an application that runs with a legal copy of Microsoft Excel® (not supplied). A 1 GHz processor or faster is recommended for best performance.
  • The SBC has been validated in the following environments:
  • Excel 2000, 2003, 2007, 2010, 2013 and 2016 under Microsoft Windows® • Excel/X, 2004, 2008 and 2011 under Macintosh® OS X
  • The SBC has not been recently validated and may not work on older versions of Excel such as Office ’97.
  • The SBC does not work on Excel 2016 on the Mac platform.
  • The SBC may not work on some internationalized versions of Excel, especially non-English versions, due to major differences in the Excel macro engines on these versions.
  • The SBC is not supported under OpenOffice®, NeoOffice® , Office365 or other spreadsheet programs due to the lack of macro support. 4 SECURITY SETTINGS The SBC is implemented in Excel XLM macros. On initial launch, the user will be prompted to enable the macros to proceed. The dialog posted by Excel will vary depending on the version of Excel and the current Excel security settings. To continue, enable the macro execution. If prompted, set the security settings to medium.
  • Some newer versions of Excel on the Windows platforms require some Trust Center security settings for the SBC to operate. Review Section 1 of the SBC User Manual for configuration details.
  • The SBC makes modifications to the team worksheet only. The only external file operations occur via user commands during creation of web page files, stats importing and creation of roster export files. The user has total control over the destination of all generated files.
  • The SBC does not perform any network operations. The SBC is internally password protected to prevent inadvertent corruption. 5 UPGRADING FROM PREVIOUS SBC VERSIONS The SBC provides forward compatibility for team worksheets that were created using previous releases.
  • To upgrade from a previous version of the SBC, simply replace the existing macros file with the SBC_Macros.xlm file included in the 3.90 distribution package. When a previous team worksheet is first launched with the v3.90 version of the SBC, a series of patches will be applied to the worksheet. This may take some time depending on the speed of the processor, version of Excel, and the previous version number. The message bar will show the progress of the patch application processing. When all the patches have been applied, the message bar will show SBC READY. After the team worksheet is saved, the patches are permanent.
  • On first launch of a team worksheet with the new macros, some informational messages may appear depending on the version of Excel that is being used. Once the team worksheet is saved, these messages will not appear on subsequent launches. One Step Web Site Changes Version 3.60 introduced a major rework of the One Step Web Site command. All web pages are now generated as Responsive Design pages that dynamically adapt the content to mobile or deskop browsers. Thus, there is now only one URL per web page generated. This includes the main home page.
  • If you have existing team web sites, it is desireable to regenerate them using version 3.60 or later. If you have implemented userdefined links, check to insure that these links are still valid as there is only one link specification for each.

New in Softball/Baseball Team Calculator 3.80 (Oct 8, 2015)

  • GENERAL INFORMATION:
  • Version 3.80 incorporates support for Excel/2016 on Windows as well as a number of other enhancements and fixes. The SBC_RH_ER_v3.80.pdf file details the changes, revision history and known errata.
  • The SBC represents hundreds of hours of development and testing. If you find the program to be useful, a donation via PayPal would be appreciated ! The SBC website at: http://sbc.aces-softball.com/ has instructions for donations.
  • The SBC website at: http://sbc.aces-softball.com/ has a quick overview of the program features under the HIGHLIGHTS tab. An introduction to the operation of the SBC can be found under the TUTORIAL tab.
  • A full user manual with detailed installation and operating instructions is available.
  • Comments and suggestions welcomed via email to: [email protected]
  • INSTALLATION:
  • Section 2 of the User Manual gives detailed step-by-step installation instructions.
  • EXCEL COMPATIBILITY:
  • The SBC is an application that runs with a legal copy of Microsoft Excel® (not supplied). A 1 GHz processor or faster is recommended for best performance.
  • The SBC has been validated in the following environments:
  • Excel 2000, 2003, 2007, 2010, 2013 and 2016 under Microsoft Windows® • Excel/X, 2004, 2008 and 2011 under Macintosh® OS X
  • The SBC has not been recently validated and may not work on older versions of Excel such as Office ’97.
  • The SBC does not work on Excel 2016 on the Mac platform.
  • The SBC may not work on some internationalized versions of Excel, especially non-English versions, due to major differences in the Excel macro engines on these versions.
  • The SBC is not supported under OpenOffice®, NeoOffice® , Office365 or other spreadsheet programs due to the lack of macro support. 4 SECURITY SETTINGS The SBC is implemented in Excel XLM macros. On initial launch, the user will be prompted to enable the macros to proceed. The dialog posted by Excel will vary depending on the version of Excel and the current Excel security settings. To continue, enable the macro execution. If prompted, set the security settings to medium.
  • Some newer versions of Excel on the Windows platforms require some Trust Center security settings for the SBC to operate. Review Section 1 of the SBC User Manual for configuration details.
  • The SBC makes modifications to the team worksheet only. The only external file operations occur via user commands during creation of web page files, stats importing and creation of roster export files. The user has total control over the destination of all generated files.
  • The SBC does not perform any network operations. The SBC is internally password protected to prevent inadvertent corruption.
  • UPGRADING FROM PREVIOUS SBC VERSIONS:
  • The SBC provides forward compatibility for team worksheets that were created using previous releases.
  • To upgrade from a previous version of the SBC, simply replace the existing macros file with the SBC_Macros.xlm file included in the 3.80 distribution package. When a previous team worksheet is first launched with the v3.80 version of the SBC, a series of Softball / Baseball Team Calculator v3.80 patches will be applied to the worksheet. This may take some time depending on the speed of the processor, version of Excel, and the previous version number. The message bar will show the progress of the patch application processing. When all the patches have been applied, the message bar will show SBC READY. After the team worksheet is saved, the patches are permanent.
  • On first launch of a team worksheet with the new macros, some informational messages may appear depending on the version of Excel that is being used. Once the team worksheet is saved, these messages will not appear on subsequent launches.
  • One Step Web Site Changes:
  • Version 3.60 introduced a major rework of the One Step Web Site command. All web pages are now generated as Responsive Design pages that dynamically adapt the content to mobile or deskop browsers. Thus, there is now only one URL per web page generated. This includes the main home page.
  • If you have existing team web sites, it is desireable to regenerate them using version 3.60 or later. If you have implemented userdefined links, check to insure that these links are still valid as there is only one link specification for each.

New in Softball/Baseball Team Calculator 3.71 (May 12, 2015)

  • Box Score Processing:
  • Previously entered line scores were not recalled correctly for box score web pages or printing. Manual recall by game number was OK.

New in Softball/Baseball Team Calculator 3.70 (May 9, 2015)

  • Enhancements:
  • Web Site Processing:
  • Masthead, graphics and banner text now resizes dynamically for desktop or mobile screen sizes.
  • Enhanced masthead text banner overrides.
  • URL’s are now verified whenever a link parameter is modified and when One Step Web Site Processing is started.
  • Enhanced processing of reserved characters in player filename hyperlinks.
  • Added option to save CSS styles as a standalone .css file.
  • Misc:
  • Enhanced player name processing to allow selective overrides of proper name processing.
  • Fixes:
  • Web Site Processing:
  • Option to create a hyperlink to the site webmaster created an incorrectly formatted email address in some instances.
  • Navigation links were not created correctly under some instances when the Player Files Directory option was active.
  • Fixed syntax for masthead and navigation bar gradients.
  • Player hyperlinks in Box Score and Leaders can corrupt User Defined Hyperlinks under some conditions. Solution is Player hyperlinks in Box Scores and Leaders are no longer supported. Player hyperlinks from Team Summary area still supported.
  • Web Masthead Preferences command – Clicking on masthead Position check box caused dialog box to close.
  • Web Graphics Info command caused macro error under some conditions.
  • Misc:
  • Adding player game stats with only one player in the roster resulted in a macro error.
  • Corrected clipped text displays of several dialog boxes.
  • Fixed some instances when running under Excel on Windows where the “Can’t Empty Clipboard” message might occur.
  • Deleting all player stats by selected game range with resequencing option did not resequence the line score game numbers corectly.
  • Select All command did not work correctly.
  • Previous game Box Score was not restored after the Print command was run.
  • Rename Player command incorrectly reported an entry error if the Cancel button was entered.
  • Rename Player command prevented cosmetic changes to player names (eg: forced capitalization).
  • Changes to the Expansion Roster label name was not processed.

New in Softball/Baseball Team Calculator 3.60 (Feb 24, 2015)

  • Enhancements:
  • Web Site Processing:
  • Enhanced to produce “Responsive Design” web pages - common pages for both mobile and desktop browsers.
  • Box scores for all games with stats now shown on a composite Box Scores web page.
  • Added user options for “zebra” striping of stats (batting summary, detailed player stats, leaders, user notes, etc).
  • Restructured Web Page Composer and One Step Web Site Preferences commands for ease of use.
  • Improved parameter validation.
  • Added run-time options for user modification of the web site update date that will be shown in the page footer area and
  • optional template file generation.
  • Added option to include a hyperlink to the site’s webmaster via a user-defined email address.
  • Added user option to block web bots from indexing web pages.
  • Web page file extension types are now set automatically.
  • Improved User Notes web page generation.
  • Enhanced template file generation to facilitate automatic style and navigation updating.
  • Added Font Family Override option.
  • Printing:
  • Added printing of all game line and box scores.
  • Added user option to suppress printing of the top banner to save ink.
  • Batting Leaders printing compacted by removing excess blank lines.
  • Added File / Printer Setup command to allow printer selections from within the SBC (Windows platforms only).
  • Stats Importer:
  • Updated the mobile stats file importer to accept latest iScore Baseball® file formats.
  • Misc:
  • Added ability to use the Excel Formula Bar for easier editing of non-protected cells.
  • Added additional keyboard mapping to traverse the player stats area by using PAGE UP, PAGE DOWN and END keys.
  • Added additional keyboard mapping with modifier keys for the HOME key.
  • Added Format / Restore Column Widths command to restore widths to pre-determined values.
  • Added Format / Number command for use in the User Notes area.
  • Added styling option to highlight stats category column labels. User controllable. Visible on printed and web pages.
  • Added styling option to globally change the base text color.
  • Fixes:
  • Printing:
  • Corrected problem of incorrect player stats and extraneous blank pages generated when printing.
  • Corrected problem that caused type size on printed pages to be very small.
  • Web Page Processing:
  • Some WPC URL parameters were not completely verified.
  • Corrected problem that caused incorrect player stats web file names to be created if the player name syntax of “first last” is used.
  • After editing a previous user-defined hyperlink, the actual hyperlink was updated correctly but the updated value would not display properly in the “comment” box.
  • Masthead gradient control did not disable the gradient if the option was unchecked.
  • Word wrapping of long text lines was not processed correctly.
  • Display Computed URL’s command crashed if the check box for Include File Processsing was changed during the dialog box display.
  • The user-defined footer did not appear in the page footer under all conditions.
  • Stats Importer:
  • Under some situations after an SBC file import, the Importer Summary dialog would erroneously report that statistics for
  • a season were over-written in the target file when they were actually new statistics.
  • Misc:
  • Launching the SBC from the macros file caused a macro error on some Windows/Excel versions.
  • The first game line score entry for the home team got corrupted if the One Step Web Site command was ever run. An
  • alert will occur on launch and when the box score command is run with the instructions to correct this. This only needed
  • to be performed once.
  • Batting Leaders did not handle overflows and tie-breakers correctly.
  • When multiple worksheets are active, some window conditions would cause a macro error.
  • Select / User Notes Area command incorrectly scrolled to Page 1 instead of User Notes area.
  • Some toolbar item pressed/not pressed states were not getting updated under some conditions.
  • The Format User Notes Area did not work correctly if the General format was selected.
  • Fixed inability to copy/paste across windows on some Excel versions on Windows platforms.
  • File / Open command caused a macro error if the file could not be properly opened.

New in Softball/Baseball Team Calculator 3.50 (Mar 21, 2014)

  • Fixes:
  • The SBC would crash under certain conditions on startup when running under Excel 2008 on the Macintosh.
  • Changing the display state of the SBC toolbar or restoring it left the team worksheet unprotected.
  • Launching the SBC from the SBC_Macros.xlm file caused a macro error trying to restore window positions.
  • Purging all player stats commands resulted in incorrect Batting Leaders and Box Score display under some conditions.
  • Purging all player stats caused a macro error if the game number resequencing option was selected.
  • Hyperlinks to individual player stats pages weren’t being created correctly under some circumstances.
  • Enhancements:
  • Web Page Processing
  • One Step Web Site Processing Summary statistics now includes full date and time of creatation of the web site files. Any
  • missing graphics links and overlength cells indicators are also flagged.

New in Softball/Baseball Team Calculator 3.40 (Sep 19, 2013)

  • Enhancements:
  • Web Page Processing:
  • Custom cell hyperlinks now have the option of opening a new window when clicked.
  • One Step Web Site processing summary now shows processing date and web site type.
  • Misc:
  • Non-SBC documents can be opened via the File/Open command or by double-clicking on a file after the SBC has
  • started. See Errata section below for limitations under certain versions of Excel.
  • Added keyboard shortcut (Windows: ctl+alt+Q Mac: cmd+option+Q) to Quit the SBC.
  • The stats importer now checks for an attempt to import a full-stats file into a slow-pitch only file and allows for au
  • correction.
  • Added Consolidate Expansion Roster command for maintenance in Multi-Season Mode.
  • Fixes:
  • Custom cell hyperlinks URL’s incorrectly prepended the player files directory under some conditions.
  • The current cell selection was not retained after a custom hyperlink command was performed.
  • Keyboard shortcut for Display User Notes Page changed to alt+K to prevent protected cell error message.
  • Display Computed URL’s comman did not show correct directory processing results under some conditions.
  • Active roster player stats were not sorted by season after a Transfer Player Stats command in Multi-Season mode.

New in Softball/Baseball Team Calculator 3.30 (Jul 22, 2013)

  • Enhancements:
  • Web Page Processing:
  • One Step Web Site now produces detailed player stats pages for mobile devices. Pages are hyperlinked from the player names on the mobile “Stats” page.
  • Removed instances when the screen display jumps around during One Step Web Site processing.
  • One Step Web Site command now reports processing statistics at end of command.
  • Single-Season Mode:
  • Added Clear Player Stats By Game command.
  • All player commands that request player name now show a quick stats summary for the player in the dialog.
  • Improved progress messages during mobile stats file importing.
  • Multi-Season Mode:
  • Processing time for SBC stats file importing has been significantly reduced.
  • Improved display of detailed player stats pages by swapping GAME and YEAR columns. Applicable to screen display,web pages and print.
  • Added display of total number of seasons for the team in Batting Summary area and for Expansion Roster players.
  • All player commands that request player name now show a quick stats summary for the player in the dialog.
  • User Interface:
  • At startup, the screen display mode (Page Break Preview or Normal View) is automatically activated on all versions except Excel 2008 on the Mac where it must be set manually.
  • At startup on Excel Windows versions with the Ribbon interface, the Add-ins tab is automatically activated for access to the SBC menus and toolbars.
  • Misc:
  • Added Display / Import Stats Summary and Display / One Step Web Site Summary commands.
  • Added keyboard equivilents for menu commands: Display/Batting Leaders and Display/User Notes.
  • SBC and Mobile stats importer commands now report processing statistics at end of command.
  • Improved roster size optimizations.
  • Overall speed improvements.
  • Fixes:
  • Mobile Stats File Importer - Corrected the count of new roster players processed shown in the processing summary.
  • When running under Excel/2011 on the Mac or on Windows versions with the Ribbon Interface, the SBC Toolbar was not deactivated during long routines.
  • On Windows versions with the Ribbon Interface, the SBC Toolbar might appear when Excel is opened with documents other than SBC worksheets.
  • On Windows versions without the Ribbon Interface, user changes to the location or size of the SBC Toolbar were not being saved correctly for subsequent relaunches.
  • On Windows platforms, file save and open dialogs weren’t always closing properly during long commands.
  • Corrected positioning of SBC dialog boxes on Windows platforms.

New in Softball/Baseball Team Calculator 3.20 (May 28, 2013)

  • Enhancements
  • Web Page Processing:
  • Backlinks on web pages to alternate desktop or mobile spaces now link directly to the equivilent content page if present. Otherwise, the links will point back to the alternate space home page.
  • Box Score:
  • User now has choice of either Plate Appearances or At Bats in the box score calculations.
  • Line score, date, time and field location information are now saved for future recall.
  • “Filter Innings Labels” option is now the default.
  • Misc:
  • After completing a merge operation, the Merge Player Stats command will prompt for another player name.
  • Merge Player Stats and Transfer Player Stats commands now display the current season count, game count, and plate appearances in the player select dialogs. This aids roster maintenance operations after stats import operations.
  • Text alignment, borders and fills/patterns tools are now part of the primary SBC Toolbar. Usable when running the SBC on all versions of Excel on Windows and on Excel/2011 on the Mac.
  • Player menu command: Delete Players Stats By Game Range renamed to more definitive: Delete All Players Stats By Game Range. Functionality unchanged.
  • Fixes Misc:
  • Parameter prompt for batting leaders calculations did not handle changes to Minimum AB/APP values correctly.
  • Edit / Update Masthead Banners command failed due to protection error.

New in Softball/Baseball Team Calculator 3.10 (Mar 18, 2013)

  • Enhancements Excel Support:
  • Support added under Excel/2008 and 2011 on Mac OS X.
  • Web Page Processing:
  • Added selective inclusion of current weather conditions on desktop and mobile home pages.
  • Added user selection of desktop home page contents.
  • Improved default parameter settings for One Step Web Site command.
  • Improved code generation to prevent browser caching of web pages.
  • Include File Configuration:
  • User is now alerted to check file extensions for proper .php settings if any include file is activated.
  • Edit Command:
  • Added Update Masthead Banners command
  • Fixes Web Page Processing:
  • Duplicate titles were displayed in the Expansion players detailed batting stats web page.
  • Web pages were being created for content areas that were un-selected.
  • User-defined hyperlinks weren’t generated on mobile home pages.
  • Web pictures in the Summary Page notices block are now correctly processed.
  • Web pictures placed in a merged cell group are now correctly identified and processed.
  • A team name that is more than one word is now converted to a proper URL.
  • Cells where the content is too long to fit (ie “####” shown) are now correctly processed with the actual content for web pages and printing.
  • Misc:
  • Dialog boxes were not positioned correctly on some Excel versions on Windows platform.
  • Resized large dialog boxes for better display on smaller screens.
  • View menu removed from menu bar under Excel versions with Ribbon UI.
  • Streamlined processing of the SBC app when closed via a window close button.
  • Removed some instances where “Can’t Empty Clipboard” messages occurrred when executing some commands under Excel/2010 on Windows.
  • Removed debugging code that caused a halt in processing during the “Rename Player” command.

New in Softball/Baseball Team Calculator 3.00 (Mar 5, 2013)

  • Enhancements:
  • Multi-Season Mode:
  • Major new feature to create composite career stats from multiple team team worksheets.
  • Mobile Stats Applications Support:
  • Major new feature to import game stats collected via selected iPhone and Android mobile stats apps.
  • Roster export command added.
  • Excel Compatibility:
  • Added support for Excel/2013 on Windows.
  • Active Player Roster:
  • Modifed so that an unlimited number of players can be added. Roster now increases or decreases in size as
  • required.
  • Batting Stats Categories:
  • Abbreviations for Plate Appearances, Slugging Percentage, Strikeouts now conform to MLB standards.
  • One Step Web Site Processing:
  • Modified to prompt for user selectable target directory for detailed player stats.
  • User Notes Area:
  • Relocated to a separate area of the team worksheet for easier user modifications of column widths.
  • Line and Box Score:
  • Innings labels are now unprotected and can be modified by the user.
  • Extraneous spaces between line score and runs totals removed after computation of Box Score.
  • Box Score now shows Plate Appearances instead of At Bats.
  • Division Standings:
  • Team names can now be a purely numeric value.
  • Web Page Processing:
  • User defined hyperlinks can now be attached to cells in the masthead notices area.
  • Background specifications can now accept full range of CSS options.
  • Background specification added for masthead.
  • Include File Configuration:
  • User is now alerted to check file extensions for proper .php settings if any include file is activated.
  • Excel Help:
  • Command to invoke Excel Help system added to Help menu.
  • Fixes:
  • Internationalized Versions:
  • Fixed problem where the SBC would not work with some internationalized versions of Excel.
  • Web Page Processing:
  • Blank lines in the Batting Leaders areas are now properly suppressed.
  • User defined hyperlinks appended an incorrect .html suffix under certain conditions.
  • Blank row suppressor now works correctly.
  • Adding custom hyperlink incorrectly resulted in HTML file suffix appended if the link didn’t have a prefined
  • suffix.
  • Custom hyperlinks in the masthead notices area were not processed.
  • Printing of web pages now supresses box shadow effects.
  • Body trailer include file processing now works correctly.
  • PHP include file processing now encodes file descriptors that start at web site root locations (eg: “/”) correctly.
  • Hyperlink colors were not always correctly processed.
  • Misc:
  • File / Save As command was functional but caused macro error after completion.
  • Changing Display / Informational Messages state caused screen position to change.
  • Clearing player stats did not always clear ROE entries.
  • Several commands resulted in unpredictable window contents position at termination.
  • SBC Toolbar occasionally becomes non-functional resulting in “SBC_Macros.xlm file is already open”
  • warning. Added Display/Rebuild SBC Toolbar command to regenerate.

New in Softball/Baseball Team Calculator 2.0 (Nov 21, 2012)

  • Enhancements:
  • One Step Web Site Processing:
  • Generates an integrated desktop and mobile web site. Web pages content optimized for each enviroment (9)
  • Web site styling enhanced with new color schemes and gradients (Fig. 35)
  • User Notes Area can now be optionally incorporated into One Step Web Site structure (9.4.2).
  • Execution time of the One Step Web Site generation has been improved (9.2).
  • User Defined Navation Links increased from one to three (14.3.1.5).
  • User Defined Navation Links can now be placed at the left-most or right-most postion on the navigation
  • masthead (14.3.1.5).
  • Enhanced URL processing for files and directories (14.4.3).
  • SBC can now clean up some basic file/directory parameter entry errors (14.4.5).
  • Added display of computed URL Paths to aid in diagnosis (14.4.5.1).
  • Cells that contain too many characters are now marked and reported for user correction.
  • User Interface:
  • Enhancements for SBC operation under the Excel Ribbon UI on Windows platforms. (2.3.1)
  • Menu positions revised to be more uniform when switching between Basic and Enhanced Command modes (Fig
  • 5,6,40,41).
  • The cmd+E keyboard combination allows the user to switch between Basic and Expanded command set modes
  • (3.3.3, 3.6.2).
  • User Notes Area:
  • Added options for inclusion on printing and web page generation. Expands possible use for posting team notices,
  • rosters, schedules, etc as part of web site. (2.3.4.2, 9.4.2)
  • Increased size of area.
  • Added command to assist in reformatting of the area (3.2.6)
  • Added ability to incorporate user-defined hyperlinks (2.3.4.2).
  • Batting Leaders:
  • Added user selectable AB or APP qualifier for leaders calculations (6.4.1.1)
  • Hyperlinks for player names now generated in main leader area as well as summary area (6.4).
  • SBC Toolbars:
  • Sizes and positions saved for next launch of SBC (3.3.6).
  • New formatting toolbar with toolset customized for SBC functions (3.3.6)
  • New tools added for:
  • Move to Summary Page
  • Display Next Player Stats
  • Update Player Stats
  • Game Range Selection
  • User defined hyperlinks
  • Diagnostics of web site issues (14.4.2.4)
  • Fixes:
  • Web Page Processing:
  • Include files variables were not being retrieved or saved for re-use (14.5).
  • and include file processing did not properly pre-pend Base URL value (14.4.1.3, 14.4.1.4)
  • area include file processing did not properly pre-pend "include files" values (14.5.1.1)
  • Not all non-web compliant characters in home team name were mapped to underscores (9.3.1).
  • One Step Web Site Preferences would not accept a URL of domain name only for the optional link parameters
  • (14.4.3)
  • Font size variations were not always correctly scaled.
  • Batting Leaders:
  • Select All Leaders did not block selections of SB, SACB, HBP stats in slow pitch mode (6.4.1.5).
  • Minimum AB/APP leader qualifier could show as a fraction under some conditions. Changed to round down to nearest whole number (6.4.1.1)
  • Box score:
  • Clearing the game line score did not always restore the innings labels correctly (7.2.2).
  • Misc:
  • Completion of some commands caused incorrect area displays or scrolling.
  • Document formatting changes were not being saved if SBC was closed with enhanced document formatting
  • mode still active
  • Keyboard equivilent for Save (cmd+s) was not mapped to SBC.
  • Some keyboard equivalents were not blocked under certain conditions.
  • Paste command caused macro error if the target was a protected area of the team worksheet.

New in Softball/Baseball Team Calculator 1.64 (Oct 19, 2010)

  • Enhancements:
  • Added option for box score sort by player name or position (7.2.3).
  • Added support for separate tracking of Reached on Error and Fielder’s Choice stats (6.2.3.8, 6.3).
  • Batting leaders can now track 19 different categories (6.4.1.5)
  • Division standings calculations modified for WPCT and GBL to account for ties (5.5.1).
  • Streamlined the options processing dialogs for web page include file processing (14.5, 14.6).
  • Player name hyperlink options are now separately controlled in the Box Score (7.2) and Leaders updating dialogs (6.4).
  • Hyperlinked player stats pages can now be optionally opened in a new page or tab (14.5.3.3).
  • Fixes:
  • Improved error handling in the event of opening a non-SBC team worksheet.
  • Corrected issue with the “Select All” option for batting leaders selections.