Softball/Baseball Team Calculator - SBC

 

Support

 

WARNING:
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.

SBC Revison History

Filing a support request for the SBC 

Click to view the SBC Online User Manual

Click to view the SBC Ribbon Commands Charts

Support Notes
07/23/21:Dialog Box Won't Respond to OK or Cancel Button After Entries new
06/20/21:Unable to Start The SBC After Installation new
06/29/21:Implications of web browser caching on SBC web sites updated
06/15/21:Implications of search engines on SBC web sites updated
06/08/21: Team Worksheet Corruption new 4.70
07/23/21:Enhancements for Ribbon User Interface updated 4.6x
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
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 new

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.

return to top
 

06/20/21: Unable to Start The SBC After Installation new

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.

return to top
 

06/29/21: Implications of web browser caching on SBC web sites updated

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.

return to top
 

06/15/21: Implications of Search Engines on SBC web sites updated

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.

return to top
 

06/08/21: Team Worksheet Corruption new 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:

Single-Season Mode:
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.

Multi-Season Mode:
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.

return to top
 

07/23/21: Enhancements for Ribbon User Interface updated 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.

return to top
 

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.

return to top
 

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.

return to top
 

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.

return to top
 

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.

return to top
 

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.

return to top
 

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.

return to top
 

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.
return to top
 

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 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.

trust center file locations dialog 

 

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:

trust center macro settings dialog 

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.

trust center 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.

SBC File Format Warning 

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.

security alert warning 

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.

return to top
 

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.
return to top

© 2000-2021 Softball/Baseball Team Calculator

Lightbox2 - Courtesy of Lokesh Dhakar