Softball/Baseball Team Calculator - SBC

 

Support

SBC Revison History

Filing a support request for the SBC 

Click to view the SBC Online User Manual

 

WARNING:
Beware of web sites offering keygens or uninstallers for the SBC !!!
Do not utilize these sites !!!
They are rogue sites that likely contain viruses that will infect your system if installed.

There appear to be a number of web sites that show up in searches that claim to have key generators or uninstallers for the SBC. The SBC does not require a password or key to install, use or uninstall the program.

Support Notes
04/29/21:Enhancements for Ribbon User Interface updated 4.60,4.61
04/02/21:Check for Updates new 4.60
04/02/21:Importing Player Stats From Alternate Sources updated 4.60
05/04/21:Running the SBC under Excel 2016 and later on Windows updated
04/03/21:Running the SBC under Excel on Mac OSX updated 4.60
1/19/20:Excel restarts automatically after quitting the SBC
10/02/19:Implications of search engines on SBC web sites
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

 

04/29/21: Enhancements for Ribbon User Interface updated 4.60, 4.61

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.

Version 4.61 incorporates 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. A cross reference for all commands has been included in the User Manual.

 

04/02/21: Check for Updates new 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 updated 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 updated

The SBC releases are verified on the Excel Office 2016 and 2019 on the Windows platform.

Note the following limitations (Microsoft Office restrictions):

  1. Excel 2016 and beyond on Windows do not co-exist with previous versions on the same machine.
    If you install Excel 2016 or 2019, you must first de-install older versions especially 2016 as they cannot co-exist on the same system.
  2. Excel 2019 and later run under Windows/10 ONLY.

Check out: Office Configuration Support Matrix for more details.

 

04/02/21: SBC Support under Excel Office On Mac OSX updated

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. Press the Add-ins tab
  2. Go to the Display menu
  3. Run the Restore SBC Ribbon command
  4. Go back to the SBC tab on the ribbon
If this procedure doesn't work, quit the SBC and restart.

 

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.

 

10/02/19: Implications of search engines on SBC web sites

By default, SBC-generated web site allow web search engines to index your site. You can overide this setting as desired via the Block Search Engines From Indexing Pages setting.

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 or email addresses that could be harvested. See the User Manual for more details.

 

02/21/19: Issues running the SBC under Excel 2011 on the Macintosh

  1. Unlike other versions of Excel, the Open and Save dialogs do not retain the directory that was selected during a previous Open or Save dialog. It always will revert to the directory where the SBC was launched. There is no obvious fix for this.
  2. 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. Sometimes, clicking on the Developer tab and opening and closing the VBA editor will fix this.
    Also helps to insure that the "Home" tab has been clicked.
  3. Occasional crash may occur when a Team Worksheet is opened for the first time. This can occur when it had been used with a different version of Excel, especially crossing from Windows to Mac versions. Relaunching the Team Worksheet will usually fix this.
 

05/17/15: Configuring the SBC Under Excel 2007 amd 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 Excel 2007 globeperforms 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 encounter a situation where the SBC does not deliver the expected results, check the Revision History and Errata document. Next, check the section on Troubleshooting in the SBC User Manual.

If you still have difficulty, .

Note:
Replies will originate from:
sbc.aces-softball.com
Insure that your email client and spam filters allow this address.

Please try to capture the following information:

  1. SBC version information*
  2. Version of Microsoft Excel*
  3. Operating system platform and revision
         (Microsoft Windows or Macintosh OS X)*
  4. What operation that was attempted
  5. Is the issue repeable ?
  6. The sequence of events that led to the problem
  7. The contents of the message bar
  8. Any any alert messages that were posted
  9. in the event of a macro error, capture the information
    reported in the dialog box including the fault description and the line number
    * Can be obtained from the File / About Softball Calculator command or SBC Ribbon Info button.

© 2000-2021 Softball/Baseball Team Calculator

Lightbox2 - Courtesy of Lokesh Dhakar