Softball/Baseball Team Calculator

 

Click on any graphic for a larger image

02/19/17: Searching the SBC On-Line SBC User Manual

The Custom Google Search bar periodically indexes the contents of the On-Line User Manual. However, it is not always a complete or accurate index of the contents. If you do not find what you are looking for, use your browsers' Find command when viewing the on-line manual.

02/01/16: Adjusting SBC Toolbar Icons Sizes Under Windows Ribbon

On the Windows platforms, the default SBC toolbar icons and tooltip sizes may be tool small. They can be changed by the following Windows procedure:

  1. Right-click on any area of the Windows desktop
  2. Click on the Personalize item
  3. In the Personalization window, click on Window Color
  4. In the Window Color and Appearance window, select the Menu item
  5. Adjust the Size item as desired
  6. Hit Apply to view the change
  7. Hit OK to make it permanent

This will adjust the sizes of the menu text, tooltips text, and tooltip icons. This will apply to Excel as well as other windows and applications.

modifying SBC toolbar icons size

09/05/15: SBC Support under Excel Office 2016

Starting with v3.80, the SBC release has been verified on the Excel Office 2016 General Release on the Windows platform.

It should be noted that Excel 2016 on Windows does not co-exist with previous versions on the same machine. Attempts to run the SBC will likely fail. Best to run Excel 2016 on a different machine with no other versions of Office.

The Excel Office 2016 Release for Mac OS X is not supported as some critical functionality for SBC operation has been dropped.

09/21/15: Schedule Manager and Web Site Link Conflicts

Starting with v3.80, theSBC implements a new Schedule and Results Manager capability. The user can optionally generate a web page and link to the schedule if desired during One Step Web Site processing.

If enabled, this may cause conflicts with user-generated links to schedules (ie: using the User Notes area or an optional link to an external schedule) as the Schedule link label and filename are automatically generated. The One Step Web Site command and associated Preferences commands will warn the user if a conflict exists and to take corrective action.

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.

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.

 

3) Menus and Toolbar Locations

SBC menus under ribbon UI

With the Excel Ribbon Interface, the SBC menus and toolbar now appear under the Add-Ins tab.

Excel customize ribbon options dialog

If the Add-Ins tab is not visible, make sure it is enabled via the File/Options/Customize Ribbon dialog.

 

3) Saving Team Worksheet Files

When saving an SBC team worksheet, make sure to save it in the orginal .xls format. If you save it in the new .xlsx format, you will not be able to re-launch the SBC.

return to top

05/10/15: Line Score Processing Bug in Version 3.70

Version 3.70 has a bug that causes incorrect lines scores to be retrieved on box score web pages and when printing. Manual retrieval of a selected game line and box score was not affected. A fix has been incorporated into Version 3.71.

03/12/15: WARNING: Rogue Web Sites Claiming Keygens and Uninstallers for the SBC

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.

Do not utilize these sites !!!
They are rogue sites that likely contain viruses that will infect your system if installed.

The SBC does not require a password or key to install, use or uninstall the program. To uninstall the SBC, simply drag the SBC_Macros.xlm file to the trash.

02/21/14: One Step Web Site Command Changes (Version 3.60 and greater)

Starting with version 3.60, web sites generated via the One Step Web Site Command generate Responsive Design web pages. This means that there are no longer separate web pages for desktop and mobile browsers. If you have team web sites that were generated with Version 3.50 or earlier, it it suggested that they be regenerated using version 3.60. Check any user-defined links to insure that they will point to the correct web pages.

11/28/14: Problems running the SBC under international versions of Excel

This problem appears primarily on non-English versions of Excel. It is a result of major differences and lack of some critical functionality in the underlying macro engine in the internationalized versions of Excel.

The SBC does not have language support for non-English languages.

The solution is to try to obtain an English language version of Excel (Mac or Windows), preferably a US version.

10/13/13: Possible crashes using the SBC under Excel 2008 on Mac Platforms

On version 3.40 and prior, the SBC may crash on startup due to a defect in the way Excel/2008 manages custom toolbars. A fix for this is has been incorporated into Release 3.50

07/14/13: Using the SBC Under Excel 2008 and 2011 on Mac Platforms

Review the SBC User Manual Section 1.4.1 for more details.

1) User Interface Changes

With the advent of Excel 2008, Excel has implemented a new Ribbon User Interface. This is a hybrid approach with the SBC menu bar still appearing at the top and a ribbon similar to that found on Windows versions of Excel. The SBC floating toolbar is still available.

The support of Page Break Preview mode has been dropped in these versions. The SBC will automatically switch to Normal View when launched under Excel 2011. This needs to be performed manually under Excel 2008.

2) Excel 2008 Limitations

This version of Excel dropped support of some ciritical macro functionality needed to support user defined web graphics objects placed in the content area of a Team Worksheet. Any web graphics that were present in previous Team Worksheets will still be visible on the screen and on printed pages. However, they will not appear on web pages. The web graphics are still retained in the Team Worksheet for SBC compatibility with other versions of Excel. Support for masthead logo graphics is still supported.

10/16/10: SBC Issues With Excel 2004 (Mac) and Security Update 11.6.1

Microsoft's 11.6.1 security update released 10/12/2010 has caused a major issue with previously created Excel worksheets. The SBC team worksheets will experience this problem and will fail to open or launch the SBC macros.

On 10/15/2010, Microsoft released the Microsoft Office 2004 for Mac 11.6.2 Update that fixes the problem. The SBC works properly with this revision and beyond.

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, send a support request email.

Note:
Replies will originate from:
support@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 Calcolator command.

© 2000-2017 Softball Team Calculator

Lightbox2 - Courtesy of Lokesh Dhakar