Beware of web sites offering license key generators or uninstallers for the SBC !!!
Do not utilize these sites !!!
These are rogue sites that contain viruses that will infect your system if installed.
The SBC does not require a license key to install, use or uninstall the program.
Click to view the SBC Online User Manual
Click to view the SBC Ribbon Commands Charts
|07/23/21:||Dialog Box Won't Respond to OK or Cancel Button After Entries|
|06/20/21:||Unable to Start The SBC After Installation|
|06/29/21:||Implications of web browser caching on SBC web sites|
|06/15/21:||Implications of search engines on SBC web sites|
|06/08/21:||Team Worksheet Corruption 4.70|
|07/23/21:||Enhancements for Ribbon User Interface 4.6x|
|04/02/21:||Check for Updates 4.60|
|04/02/21:||Importing Player Stats From Alternate Sources 4.60|
|05/04/21:||Running the SBC under Excel 2016 and later on Windows|
|04/03/21:||Running the SBC under Excel on Mac OSX 4.60|
|1/19/20:||Excel restarts automatically after quitting the SBC|
|02/21/19:||Issues running the SBC under Excel 2011 on the Macintosh|
|05/17/15:||Configuring the SBC Under Excel 2007 and later on Windows Platforms|
Click on any graphic for a larger image
07/23/21: Dialog Box Won't Respond to OK or Cancel Button After Entries
Dialog boxes that have editable entries are configured for the expected type of values. An example is game number entries that expect positive integer values. Most SBC dialog boxes will describe the expected data types.
On Excel on the Mac, the native dialog manager will alert the user when attempting to enter the wrong data type.
Not all versions of Excel on Windows will report an incorrect data type entry with an alert. Hitting any button to continue will appear that the program is hung (Excel 2019 is an example). In place of the alert, the focus will highlight the first entry that is incorrect. The only solution is to visibly check the entry for incorrect type and correct before proceeding.
06/20/21: Unable to Start The SBC After Installation
Section 3 of the User Manual details the steps to install the necessary files and set the various macro security and Trusted Locations settings for proper operation. It is suggested that a separate directory be created to hold your team worksheets, SBC Macros and Ribbon file. Aliases/shortcuts to the team worksheets may be created to launch from another directory if desired.
If the SBC stil won't start, the issue is likely due to directory permissions. Review the steps for Trusted Locations. Some versions of Excel have a check box for enabling sub-directories as well.
When running on Excel on Windows, the SBC Ribbon is the primary User Interface (UI). If you are upgrading from a previous SBC version, ensure that you place the SBC_Ribbon.xlam file that came with the distribution .zip file in the same directory as the SBC_Macros.xlm file. Do not place it in the traditional Excel Add-ins directory. This ensures that the SBC Ribbon is active only when the SBC is running. After a sucessful launch, the SBC will test that the ribbon file is the correct version for this SBC revision.
06/29/21: Implications of web browser caching on SBC web sites
During the course of the season, your web site will likely undergo frequent updates. The SBC incorporates code in each web page to prevent browsers from caching the web pages. This ensures that the visitors will always see the most recent version of the pages. As the SBC-generated web pages are relatively small, this has minimal impact on the response time to render the pages.
Unfortunately, not all browsers obey these "no cache" directives. So it is good practice to inform your players to hit "refresh" on the page if they don't see the most recent stats updates.
There are other techniques to ensure the web pages are not cached, but they require special web configuration files (.htaccess) that are more complex to create and maintain. They are typically used on Apache-based web servers and may not work on your specific web host. If the SBC caching directives fail to prevent caching, contact your web hosting service for possible solutions.
06/15/21: Implications of Search Engines on SBC web sites
By default, SBC-generated web sites allow web search engines to index your site.
You can overide this setting as desired via the Block Search Engines From Indexing Pages setting. If you activate this setting, a unique robots.txt file is generated that must be placed at the top (root) level of your web site for this to be effective.
If you disable this feature in the future, insure that the robots.txt file is removed from your web site.
It should be noted that legitimate search engine indexing bots (e.g.: Google, Bing, etc) will honor this setting. However, malicious web bots usually don't.
When the Webmaster contact link is enabled, the SBC uses a technique to obfuscate the webmaster email address from the bots, but no method is 100% fool-proof.
So use caution when including any content that could be harvested by a malicious bot. This would include any links, email addresses, personal information (telephone numbers, addresses, etc.) that could be harvested. Best practice is to employ a unique email address for the Webmaster contact in the event the address is compromised.
06/08/21: Team Worksheet Corruption 4.70
An SBC Team Worksheet, like any other Excel file, can get corrupted due to a variety of reasons. Thus, it is important to keep backups of your Team Worsheets for recovery. Notes of your user-modified settings, especially web site customizations, should be kept separately in the event that they need to be re-entered. Keeping separate backups using export functions such as Stats, Schedules, Rosters can be helpful as well.
If reverting to backups fails, the following strategies can be used to assist in saving and recovering of player statistics:
Version 4.70 has incorporated an Export / Stats command that saves the game-by-game player stats into .csv files. The format is the SBC General file. This is normally used for exporting to other apps but can be helpful to migrate the stats from one SBC Team Worksheet to another. Best practice is to periodically export the stats in this format. Then, in the event that a backup file is not usable, the stats can be imported into a known clean Single-Season Mode SBC Team Worksheet.
Good practice is to keep copies of all of the Single Season files that have been imported into a Multi-Season Mode Team Worksheet. Then, in the event that a backup file is not usable, the stats can be imported into a known clean Multi_Season Mode SBC Team Worksheet.
07/23/21: Enhancements for Ribbon User Interface 4.6x
Version 4.60 incorporates major performance enhancements for running the SBC under Excel on the Windows OS. The User Manual (pdf and on-line versions) have been restructured to focus on the SBC Ribbon UI which is the preferred UI when running under Excel on Windows platforms.
Subsequent versions incorporate additional enhancements for Ribbon performance and stability.
Ribbon command charts are available for each major operating mode for download.
The SBC Legacy UI menus and toolbars are still supported for all platforms., They are initially disabled when the SBC Ribbon UI is active for better performance. The General/Configure/SBC Legacy UI command will activate/deactivate this UI as desired. A cross reference between the two UI's for all commands has been included in the User Manual.
04/02/21: Check for Updates 4.60
Version 4.60 performs a check for a newer version at startup. The results are reported to the user. If a newer version is found, the user has the option to download. Requires an active internet connection.
The test can also be invoked manually.
This cannot be performed automatically on Excel versions on the Mac platform. Instead, the user will be alerted to navigate to the SBC web site to perform this test manually.
04/02/21: Importing Player Stats From Alternate Sources 4.60
The SBC can import player stats from a number of popular 3rd pary apps.
Stats from other sources can be imported as well. The User Manual details the file formats for importing Game-based stats into Single Season mode team worksheets and Season-based stats into Multi Season mode team worksheets.
Excel template files have been included in the 4.60 distribution to assist in this process.
05/4/21: SBC Support under Excel Office 2016 and Later Under Windows
The SBC releases are verified on the Excel Office 2016 and 2019 on the Windows platform.
Note the following limitations (Microsoft Office restrictions):
Check out: Office Configuration Support Matrix for more details.
04/02/21: SBC Support under Excel Office On Mac OSX
The Mac versions of Excel are totally different implementations than their Windows counterparts.
Currently, only Excel 2004 and 2011 are supported. The SBC Ribbon UI is not available on any Mac version of Excel.
The SBC cannot run under Excel 2008 due to non-existant in macro support.
The SBC cannot run under Excel 2016 and beyond due to major limitations in macro support.
01/23/20: Using the new SBC Ribbon interface under Windows version of Excel
SBC version 4.20 introduced a new Ribbon interface for the SBC when running under Excel 2010 or later versions under Windows. To use the new ribbon, simply place the file: SBC_Ribbon.xlam in the same directory as the SBC_Macros.xlm file prior to starting the SBC. If you are upgrading from a previous version, make sure that you replace both files with the latest versions from the distribution .zip file.
The use of the new Ribbon interface is optional. The legacy SBC menus and toolbars are always available under the Add-ins tab in either case.
The SBC establishes its’ own Excel Ribbon configuration. Excel ribbons are very fussy little beasts and there can be conflicts with other Excel addins especially those that attempt to access the ribbon interface.
During startup, a test is performed to determine if any other Excel Addins are active. If found, the user will be alerted to this condition. You may continue with the possibility of conflicts.
Not all Excel Add-ins, especially from 3rd party sources, play nicely with others. If you encouter problems, restart and instruct the SBC to deactivate the Add-ins. Restart the SBC via your team worksheet for proper operation.
If the ribbon becomes unresponsive, perform the following steps:
1/19/20: Excel restarts automatically after quitting the SBC
This is an infrequent occurance and not an SBC bug. It is a known problem under Windows that can have several causes. On Windows/10 there are system settings that allow this behavior such as Hover/Select and others.
There are also reported problems with Office that can exhibit this behavior. A minor repair of the Office installation can sometimes correct this. A full repair may be required. This does a complete reinstall of Office and will require re-entering the registration key ! A web search on the topic provides more insight.
02/21/19: Issues running the SBC under Excel 2011 on the Macintosh
05/17/15: Configuring the SBC Under Excel 2007 and Later on Windows Platforms
With the advent Excel 2007, the user needs to be aware of the following compatibility and configuration issues for proper operation of the SBC. Note that in Excel 2007, the File tab is not present - Clicking on the Excel globe performs this function. In Excel 2010 and beyond, the File tab was restored.
1) Security Configuration Changes
Excel must be configured to allow the SBC to execute from the directory where the SBC files are intended to be stored. This is performed in the Trust Center under the File/Options/Trust Center/Trusted Locations tab.
In addition, macro security must be configured to allow the SBC to execute. This is also performed in the Trust Center under the File/Options/Trust Center/Macro Settings tab:
The default setting is Disable all macros with notification. This is the safest setting.
The version 4 workbook, worksheet and macro sheets should be unblocked as shown in the File Block Settings dialog.
2) First Time Launch of the SBC
After the Trust Center configuration has been completed, launch the SBC by clicking on the SBC_Macros.xlm file. After Excel loads, you may see an alert warning about the file format, answer Yes.
You will then see a security prompt to allow macro execution. Depending on the version of Excel, the alert will show in the message bar at the bottom of the window or just under the Ribbon area. Click on the Enable Content button to continue.
A standard file open dialog will appear. Select a Team Worskheet file to open. The SBC should launch normally at this point. The file will be verified that it is a Team Worksheet.
After you see the SBC READY message in the message bar, quit the SBC via the File/Quit Softball Team Calculator menu command. No need to save the file at this point.
This sequence only needs to be performed once. Subsequent launches of the SBC can then be performed by clicking on a Team Worksheet.
Filing a support request for the SBC
Every effort has been made to validate the functionality of the SBC under a variety of versions of Excel®, multiple releases of Microsoft Windows® and Macintosh® operating systems and a variety of popular web browsers.
If you still have difficulty, .
Please try to capture the following information:
© 2000-2021 Softball/Baseball Team Calculator
Lightbox2 - Courtesy of Lokesh Dhakar