Softball/Baseball Team Calculator

On-Line User Manual v4.10 - 061819

Click for downloadable version in .pdf format
Optimized for tablet and desktop browser viewing

1    GENERAL INFORMATION.. 1

1.1    Program Availability and Licensing. 1

1.2    Specifications. 2

1.3    Operating Environment 2

1.4    Excel Compatibility. 2

1.4.1     User Interface Differences in Excel Versions. 3

1.4.1.1    Excel/Windows Versions Prior to 2007. 3

1.4.1.2    Excel/Windows Versions 2007 and Beyond. 3

1.4.1.3    Excel/Windows Versions 2016, 2019. 3

1.4.1.4    Excel/Mac Versions Prior to 2008. 3

1.4.1.5    Excel/Mac Version 2008 and Beyond. 4

1.4.2     Security Differences In Excel Versions. 4

1.4.2.1    Security Configuration For Windows/Excel 2007 and Later 5

1.4.2.2    Launching the SBC On Windows/Excel 2007 and Later 7

1.4.3     File Format Differences in Excel Versions 12 and Greater 7

1.4.4     Team Worksheet Compatibility. 7

1.5    Running The SBC With Other Excel Documents Open. 7

1.6    Support 7

1.6.1     On-Line Support 7

1.6.2     Contacting Support 7

1.6.3     Revision History. 8

1.6.4     Comments and Feedback. 8

2    GETTING STARTED.. 9

2.1    Program Installation. 9

2.1.1     Deinstalling the SBC.. 9

2.2    Starting the SBC.. 9

2.2.1     Activating the SBC Menus and Toolbars under The Windows Ribbon UI. 10

2.2.2     Screen View Under Excel 2008 / Mac. 10

2.2.3     Operating Environment Detection. 10

2.3    User Interface. 10

2.3.1     Overview.. 10

2.3.2     Command Set Organization. 10

2.3.3     Custom Menus. 11

2.3.4     SBC Toolbar 11

2.3.5     SBC Toolbar Organization. 11

2.3.5.1    Group 1 Tools – Quit/File/Print/Repeat 11

2.3.5.2    Group 2 Tools – Display Navigation. 12

2.3.5.3    Group 3 Tools – Game Schedule. 12

2.3.5.4    Group 4 Tools – Batting Leaders and Box Score. 12

2.3.5.5    Group 5 Tools – Roster and Stats. 12

2.3.5.6    Group 6 Tools – Web Site Generator 12

2.3.5.7    Group 7 Tools – Configuration /Help/Info. 12

2.3.5.8    Group 8 Tools - Misc. 12

2.3.5.9    Non-Ribbon Mode Tools. 13

2.3.5.10   Toolbar Icon and Tooltip Size. 13

2.3.6     Status Bar and Progress Messages.

2.3.7     Pending Notifications   14

2.4    Major Operating Modes. 14

2.4.1     Basic Command Set Mode – Single Season. 14

2.4.2     Expanded Command Set Mode – Single Season. 14

2.4.3     Expanded Command Set Mode – Multi-Season. 14

2.5    Active and Expansion Rosters. 14

2.6    Statistics Tracking Mode. 15

2.7    Team Worksheet Organization. 15

2.7.1     Top Level Team Summaries Page. 15

2.7.2     User Notes Area. 16

2.7.3     Team Batting Statistics. 17

2.7.3.1    Formulas Used in Statistics Calculations. 17

2.7.4     Detailed Batting Leaders. 18

2.7.5     Game-by-Game Player Statistics Pages. 18

2.7.6     Game Schedule and Results. 19

2.8    Setting Up A Team Worksheet 19

2.9    Quitting the SBC.. 19

3    BASIC COMMAND SET REFERENCE.. 21

3.1    File Menu. 21

3.1.1     About Softball Calculator 21

3.1.2     Open. 22

3.1.3     Save (cmd+S) / Save As. 22

3.1.3.1    File Details/Properties  . 22

3.1.4     Import Schedule. 22

3.1.5     Import Roster 22

3.1.6     Configure New Season. 22

3.1.7     Configure New Team... 23

3.1.8     Export Rosters. 23

3.1.9     Export Schedule. 23

3.1.10    Team Worksheet Protected. 23

3.1.11    One Step Web Site (cmd+opt+W) 23

3.1.12    Page Setup. 23

3.1.13    Default Page Setup. 23

3.1.14    Printer Setup. 23

3.1.15    Print (cmd+P) 23

3.1.16    Print Selection (cmd+opt+P) 23

3.1.17    Quit Softball Team Calculator (option+cmd+Q) 23

3.2    Edit Menu. 23

3.2.1     Repeat (cmd+opt+Y) 23

3.2.2     Select All (cmd+A) 23

3.2.3     Schedule. 24

3.2.4     Game Numbers. 24

3.2.5     Screen Size. 24

3.2.6     Game Display Range (opt+R) 24

3.2.7     General Preferences. 24

3.2.8     Batting Leaders Preferences. 24

3.2.9     One Step Web Site Preferences. 24

3.2.10    Format User Notes Area. 24

3.2.11    Update Masthead Banners. 25

3.2.12    Division Team Names Locked. 25

3.3    Display Menu. 25

3.3.1     Player Stats. 25

3.3.2     Next or Previous Player Stats   . 26

3.3.3     Schedule (opt+S) 26

3.3.4     Summary Statistics (HOME) 26

3.3.5     Batting Leaders (opt+L or cmd+HOME) 26

3.3.6     Team Batting Summary (opt+B or opt+HOME) 26

3.3.7     User Notes Area (opt+N or cmd+opt+HOME) 26

3.3.8     Box Score…... 26

3.3.9     Next/Previous Box Score (opt+ê) 26

3.3.10    Formula Bar  (opt+cmd+F) 26

3.3.11    Import Summary. 26

3.3.12    One Step Web Site Summary. 26

3.3.13    Expanded Commands (cmd+E) 26

3.3.14    Informational Messages. 26

3.3.15    Gridlines and Headings (cmd+opt+G) 26

3.3.16    Pending Notifications 26

3.3.15    Gridlines and Headings (cmd+opt+G) 26

3.4    Calculate Menu. 27

3.4.1     Analyze Schedule. 27

3.4.2     Batting Leaders (opt+cmd+L) 27

3.4.3     Box Score (opt+cmd+B) 27

3.4.4     Division Standings (opt+cmd+K) 27

3.5    Player Menu. 27

3.6    Window Menu. 27

3.7    SBC Help. 28

3.7.1     SBC Support 28

3.7.2     SBC On-Line User Manual 28

3.7.3     SBC Revision History  . 28

3.7.4     Donate To SBC Development 28

3.7.5     SBC Keyboard Shortcuts. 28

4    USER CONFIGURABLE OPTIONS – BASIC COMMAND SET.. 30

4.1    General Preferences Command. 30

4.1.1     Identity Settings. 30

4.1.1.1    Team Name. 30

4.1.1.2    Stats File Description. 30

4.1.2     Expansion Roster Settings. 30

4.1.2.1    Expansion Roster Label 30

4.1.2.2    Sort Expansion Roster 30

4.1.3     Stats Tracking Options. 30

4.1.3.1    Track Slow-Pitch Stats Only. 30

4.1.3.2    Track Fines. 31

4.1.3.3    Enable GBL Display  . 31

4.1.4     Schedule Page Options. 31

4.1.5     Box Score Controls. 31

4.1.5.1    Box Score Games Sort Order 31

4.1.5.2    Completed Games Only (Print, Web) 31

4.1.6     Miscellaneous Settings. 31

4.1.6.1    Include User Notes for Printing. 31

4.1.6.2    Include Masthead Banners for Printing. 31

4.1.6.3    Source File Filtering. 31

4.1.6.4    Shade Stats Category Titles. 31

4.1.6.5    Default Text Color 31

4.2    Statistics Display Ranges. 31

4.2.1     Game Range Display Conventions. 32

4.3    User Alterable Cells. 32

4.3.1     Team Summary Area. 32

4.3.2     Team Batting Summary Area. 34

4.3.3     Batting Leaders Area. 34

4.3.4     User Notes Area. 35

4.3.5     Game Schedule Page. 36

4.4    Formatting Changes in Basic Command Set Mode. 36

4.4.1     Cell Border Mapping. 36

4.4.1.1    Screen and Printed Pages. 36

4.4.1.2    Border Mapping for Web Pages. 36

4.4.2     Align Text 37

4.4.3     Fills and  Patterns. 37

5    DIVISION STANDINGS AND GAME SCHEDULE MANAGER.. 38

5.1    Division Standings. 38

5.1.1     Changing The Division Name. 38

5.1.2     Entering Team Names. 38

5.1.3     Automatic Entry of Team Names. 39

5.1.4     Selecting The Main Team Name. 39

5.1.4.1    Renaming The Main Team Name. 39

5.1.5     Division Standings Maintenance. 39

5.1.5.1    Team Name Modifications. 39

5.1.5.2    Purging All Team Names. 39

5.1.5.3    Purging All W/L/T Records. 40

5.1.6     Updating Division Standings. 40

5.1.6.1    Automatic Updating of Division Standings. 40

5.1.6.2    Processing Options. 40

5.1.6.3    Division Standings Calculations. 40

5.2    Game Schedule Manager 41

5.2.1     Game Schedule Attributes. 41

5.2.2     Importing a Game Schedule. 41

5.2.2.1    Schedule File Format - SBC.. 41

5.2.2.2    Schedule File Format – General 42

5.2.2.3    Import Processing Options. 43

5.2.2.4    Import Processing File Validation. 44

5.2.2.5    Import Processing Summary. 44

5.2.2.6    Modifying Imported Schedule Entries. 45

5.2.3     Managing Game Schedule Entries. 45

5.2.3.1    Modify An Existing Game Schedule Entry. 45

5.2.3.2    Adding A Game Schedule Entry. 46

5.2.3.3    Deleting A Game Schedule Entry. 46

5.2.3.4    Clearing Dialog Box Attribute Fields. 46

5.2.3.5    Deleting All Game Schedule Entries. 46

5.2.3.6    Deleting a Line Score. 46

5.2.3.7    Deleting All Line Scores. 46

5.2.3.8    Impact on Box Score. 46

5.2.4     Schedule Processing Options. 46

5.2.4.1    Display Game Numbers. 46

5.2.4.2    Auto-Update Division Standings. 46

5.2.4.3    Mark Unplayed/Unreported Games. 47

5.2.4.4    Highlight First Unplayed Game. 47

5.2.4.5    Include for Print and Web. 47

5.2.5     Schedule Analyzer  . 47

5.3    Game Number Manager  . 47

5.4    Schedule Exporter  . 48

5.4.1     vCalendar File Format (.ics) 48

5.4.1.1    Special Processing. 48

5.4.2     Comma-Separated Variable File Format (.csv) 49

5.4.3     Procedure. 49

5.4.4     Transferring the File to a Calendar Application. 50

5.4.5     Calendar Issues. 50

6    PLAYER BATTING STATISTICS. 51

6.1    Overview.. 51

6.1.1     Player Selection Dialog. 51

6.1.2     Player Name Selection Preservation. 51

6.1.3     Game Number Parameter Limits. 51

6.2    Setting Up and Maintaining the Team Roster 52

6.2.1     Player Name Selection and Entry Rules. 52

6.2.2     Setting Up a New Player Roster 52

6.2.3     Modifying an Existing Roster 52

6.2.3.1    Adding a New Player to the Roster 52

6.2.3.2    Modifying a Player Name in the Roster 53

6.2.3.3    Removing a Player From the Roster 53

6.3    Player Batting Statistics. 53

6.3.1     Entering Statistics From a Recent Game. 53

6.3.2     Options During Player Update Dialog. 54

6.3.2.1    Update. 54

6.3.2.2    No Update. 54

6.3.2.3    Clear 54

6.3.2.4    Cancel 54

6.3.2.5    Played But Did Not Bat 54

6.3.3     Purging Game Stats. 54

6.3.4     Updating Statistics From a Previous Game. 54

6.3.5     Notes on Player Statistics Updating. 54

6.3.5.1    Stats Entry Verification. 55

6.3.6     Optional Player Position Tracking. 55

6.3.6.1    Player Postion Dropdown List 55

6.3.7     Player Roster and Stats Maintenance. 55

6.3.7.1    Deleting Stats for Individual Player Name. 55

6.3.7.2    Deleting Player Stats for a Specific Game. 55

6.3.7.3    Delete All Player Names and Stats From the Roster 56

6.3.7.4    Delete All Player Stats by Game Range. 56

6.3.7.5    Transfer Player Stats. 56

6.3.7.6    Merge Player Stats. 56

6.4    Updating Team Batting Leaders. 57

6.4.1     Static Parameters For Batting Leader Calculations. 57

6.4.1.1    Min At Bats or Appearances Per Game. 57

6.4.1.2    Maximum Leaders. 57

6.4.1.3    Maximum Leaders Plus Ties. 57

6.4.1.4    Include Expansion Roster Players. 58

6.4.1.5    Leader Board Categories. 58

6.4.2     Calculating Batting Leaders. 58

6.4.2.1    Runtime Parameter Overrides. 59

6.4.3     Leaders Summary Area. 59

6.5    Validating Player Statistics. 59

7    BOX SCORES. 61

7.1    Game Schedule Information. 61

7.2    Generating a Box Score. 61

7.2.1     Calculate Box Score Command Functions. 61

7.2.1.1    Add New Game. 61

7.2.1.2    Recall Previous Games. 62

7.2.1.3    Update a Previous Game. 62

7.2.1.4    Clear Line Score Display. 62

7.2.1.5    Clear Box Score Display. 62

7.2.2     Calculate Box Score Processing Options. 62

7.2.2.1    Box Score Statistics Selections. 62

7.2.2.2    Box Score Sort Order 62

7.2.2.3    Line Score Innings Labels Filtering. 62

7.2.3     Box Score Command Processing. 62

7.3    Resolving Current vs. Saved Line Scores. 63

7.4    Box Scores for Web Pages and Printed Reports. 63

7.4.1     General Preferences Options. 63

7.4.2     One Step Web Site Options. 63

8    PRINTING REPORTS. 64

8.1    General 64

8.1.1     Header/Banner Rows. 64

8.2    Print Command. 65

8.2.1     File / Print (cmd+P) 65

8.2.1.1    Selective Printing Options. 66

8.2.2     Print Preview.. 66

8.2.2.1    Excel on the Macintosh. 66

8.2.2.2    Excel on Windows. 66

8.3    Printing Problems. 66

8.3.1     Small Print 66

9    CREATING A BASIC WEB SITE.. 67

9.1    Overview.. 67

9.1.1     Browser Compatibility. 68

9.1.2     One Step Web Site Navigation. 68

9.1.3     Box Scores Summary Web Page. 69

9.2    Procedure. 70

9.2.1    Web Themes  4.000

9.2.2     One Step Web Site Processing Summary. 70

9.4    Notes on Generating Web Sites. 71

9.4.1     File Name Conventions. 71

9.4.1.1    Player Filename Encoding. 71

9.4.2     Game Range Parameter Validation. 71

9.5    Options. 71

9.5.1     Incorporating User Notes Area as a Web Page. 72

9.5.1.1    User Notes Web Pages Content and Layout 72

9.5.1.2    Zebra Striping. 72

9.5.2     Game Schedule and Results Page. 72

9.5.3     Current Weather 72

9.5.4     Graphics, WebClip and Favicon Icons. 73

9.5.4.1    Masthead Logo File. 73

9.5.4.2    WebClip Bookmark Files. 73

9.5.4.3    Favicon Icon File. 73

9.5.5     Additional Options. 74

9.6    Caching of Web Sites. 74

9.7    Search Engine Indexing of Web Pages. 74

9.7.1     Google Mobile Friendly Compatibility. 74

10            WARNING MESSAGES AND TROUBLESHOOTING.. 75

10.1  Warning Messages. 75

10.2  Problems Launching the SBC.. 81

10.2.1    Mac OS X Platform... 81

10.2.2    Windows Platform... 81

10.3  Game Selection Mismatch Warnings. 81

10.4  ### Value Appears in Cells. 81

10.5  Web Site File Name Extensions Incorrect 81

10.6  Web Site Navigation Does Not Work Correctly. 81

10.6.1    One Step Web Site. 81

10.6.2    Manual Web Page Creation. 82

10.6.3    Relative Addressing URL Error Warnings. 82

10.6.4    User Defined Custom Hyperlinks. 82

10.7  Dropdown Navigation Bar on Mobile Web Site Pages Not Functional 82

10.8  Web Site Graphics Do Not Appear on Web Pages. 82

10.9  Web Site Favicon Icon Does Not Appear in Browser 82

10.10 WebClip Bookmark Icons Do Not Appear 82

10.11 Web Site Graphics Do Not Appear 82

10.11.1  Masthead Graphics. 82

10.11.2  Web Page Background Graphics. 82

10.12 Player Stats Validation Errors. 82

10.13 Platform Specific Issues. 83

10.13.1  Font Library Variations. 83

10.13.2  Page Breaks. 83

10.13.3  “Can’t Empty Clipboard” Alert 83

10.13.4  Dimmed Format Menu Items. 83

10.13.5  Graphics Files Interchange Problems Between Mac and Windows. 83

10.13.6  Macro Error During Page Setup or Print Commands. 83

10.13.7  Web Page Styling Does Not Match SBC Examples. 83

10.13.8  Box Scores Web Page Issues. 84

10.13.8.1 Detailed Box Score Won’t Display. 84

10.13.8.2 Box Scores Printing Issues. 84

10.13.9  Link URL Modifications for Responsive Design. 84

10.13.10  Import Dialog File Selection Problems. 84

11            EXPANDED COMMAND SET MODE.. 85

11.1  File Menu. 85

11.2  Edit Menu. 86

11.2.1    Additional Commands. 86

11.2.2    Custom Hyperlink (cmd+opt+H) 86

11.3  View Menu. 87

11.4  Format Menu. 87

11.4.1    Font, Style, Number, Alignment, Borders, Patterns. 87

11.4.2    Row and Column Settings. 87

11.4.3    Color Palette Editor 88

11.5  Select Menu. 88

11.6  Display Menu. 88

11.7  Player Menu. 89

11.7.1    Check Rosters. 89

12            USER CONFIGURABLE OPTIONS – EXPANDED COMMAND SET.. 90

12.1  Formatting Modifications in Expanded Mode. 90

12.1.1    Safe Mode Formatting. 90

12.1.2    Unprotected Mode Formatting. 90

12.1.2.1   Activation. 90

12.1.2.2   Available Tools. 91

12.1.2.3   Ending the Unprotected Mode Formatting Session. 91

12.2  Picture Processing Options. 91

12.3  Web Page Processing Options. 91

13            IMAGES / PICTURES PROCESSING.. 92

13.1  Traditional Pictures and Graphics. 92

13.2  Web Graphics. 92

13.2.1    Masthead Icon/Background Graphics. 92

13.2.2    Content Area Graphics. 92

13.2.2.1   Edit / Web Graphics Info Command. 93

13.2.2.2   Modification or Deleting Web Graphics. 93

13.2.2.3   Printed vs. Web Page Differences. 93

13.2.2.4   Customizing WebClip Icons. 93

13.3  Platform Issues With Graphics. 93

14            ENHANCED WEB PAGE GENERATION.. 94

14.1  Web Page Generation Overview.. 94

14.2  One Step Web Site Command. 94

14.2.1    Processing Options. 95

14.2.1.1   Home Page Navigation Label 95

14.2.1.2   Home Page URL.. 95

14.2.1.3   Home Page Content 95

14.2.1.4   User Defined Navigation Links. 95

14.2.2    Customizing Web Themes .  4.000

14.2.3    One Step Web Site Processing Summary. 95

14.3  User Modifiable Attributes for Web Page Processing. 96

14.3.1    General Processing Options. 96

14.3.1.1   HTML File Suffix. 96

14.3.1.2   Files and Directory Processing. 97

14.3.1.3   Prepend Base URL.. 97

14.3.1.4   Image File Directory URL.. 97

14.3.1.5   Player Files Directory Processing. 97

14.3.1.6   CSS Style Sheet URL.. 98

14.3.1.7   Include favicon <link> tag. 98

14.3.1.8   Include Webmaster Email Link. 98

14.3.1.9   Append Footer Text 98

14.3.1.10 Block Search Engines From Indexing Pages. 98

14.3.1.11 HTML Document Type. 99

14.3.1.12 Generate Inline CSS Styles.  4.00099

14.3.2    Content Processing Options. 99

14.3.2.1   Page Background Fill Color 99

14.3.2.2   Page Background File URL.. 99

14.3.2.3   Content Block Fill Color 99

14.3.2.4   Content Areas Box Shadow 99

14.3.2.5   Content Areas Border Radius 99

14.3.2.6   Banners Text Color 99

14.3.2.7   Zebra Stripe Color 99

14.3.2.8   Font Family Override. 99

14.3.2.9   Hyperlink Text Colors. 99

14.3.2.10   Default Worksheet Font Family and Text Color 100

14.3.2.8   User Notes Web Page Processing. 100

14.3.3    Masthead and Navigation Processing Options. 100

14.3.3.1   Masthead Banner Text 100

14.3.3.2   Masthead Banner Text Height 100

14.3.3.3   Masthead Background Icon File URL.. 100

14.3.3.4   Masthead Background Fill Color and Gradient 101

14.3.3.5   Navigation Bar Styling. 101

14.3.3.6   Navigation Bar Links Text Tab Styling. 101

14.3.3.7   Navigation Bar Borders Styling. 101

14.3.3.8   Navigation Bar Link Tabs Styling. 101

14.4  Include File Processing. 101

14.4.1    Include Files Directory URL.. 102

14.4.2    Include <head> Selector Stub File URL.. 102

14.4.3    Body Area Files. 102

14.4.3.1   Body Header File. 102

14.4.3.2   Body Trailer File. 102

14.4.4    Home Page Content Include Files. 102

14.5  Issues Resulting From URL Processing. 102

14.5.1    Display Computed URL Paths. 103

14.5.2    Absolute vs. Relative Include File Processing. 104

14.6  Other User Modifiable Attributes. 104

14.7  Cascading Style Sheets. 104

14.7.1    Saving CSS Styles. 104

14.8  Custom Web Site. 105

14.8.1    Generate HTML Table From Area. 105

14.8.2    Web Page From Predefined Area. 106

14.8.2.1   Invoke Web Save After Select 106

14.8.2.2   Prompt for Options on Web Save. 106

14.8.3    Web Page From Custom Area. 107

14.8.4    Save All Player Stats as Web Pages. 107

14.9  HTML Color Management 107

14.9.1    Color Selection and Specification. 107

14.9.2    SBC Color Palette. 107

14.9.3    Modification of the Color Palette. 108

14.10 Web Browser Compatibility Issues. 109

14.10.1  Fonts. 109

14.10.1.1 Font Family Selection. 109

14.10.2  Advanced Styling. 109

14.10.3  Mobile and Tablet Web Browsers. 109

14.11 Template Files. 110

14.11.1  Template File Structure. 110

14.11.2  Template File Generation. 111

14.11.3  Customization of Template Files. 111

14.11.3.1 Predefined CSS Styles. 111

14.11.3.2 Linking Template Files to Navigation Links. 111

14.11.3.3 Processing Date. 111

14.11.4  Integrating Template Files Into the Website. 112

14.11.5  Template File Development 112

14.11.5.1 Mobile vs. Desktop Browser Display. 112

14.11.5.2 Local Development of PHP Web Pages. 113

14.11.6  Additional Tools For Development 114

15            MULTI-SEASON MODE.. 115

15.1  Overview.. 115

15.2  Strategies For Organizing Stats. 115

15.2.1    Conventional Approach. 115

15.2.2    Alternative Approaches. 115

15.3  Functional Differences in Multi-Season Mode. 115

15.3.1    Batting Leaders. 116

15.3.2    Division Standings. 116

15.3.3    Game Schedule Manager 116

15.3.4    Box Score. 116

15.3.5    Stats Validation. 116

15.3.6    Multi-Season Web Site. 116

15.4  Command Set Differences In Multi-Season Mode. 116

15.4.1    File Menu Commands in Multi-Season Mode. 116

15.4.1.1   Import Stats. 116

15.4.1.2   Configure Worksheet Format 116

15.4.2    General Preferences in Multi-Season Mode. 117

15.4.2.1   Sort Expansion Roster Option. 117

15.4.2.2   Display Season Totals. 117

15.5  Assembling a Multi-Season Mode Team Worksheet 117

15.5.1    Importing Statistics From a Team Worksheet 117

15.5.1.1   Importing of Expansion Roster Stats. 118

15.5.1.2   Roster and Stats Importing Methodology. 118

15.5.1.3   Roster Conflicts. 118

15.6  Managing Multi-Season Statistics. 118

15.6.1    Player Menu Commands in Multi-Season Mode. 119

15.6.1.1   Check Rosters. 119

15.6.1.2   Merge Player Stats. 119

15.6.1.3   Rename Stats Season. 119

15.6.1.4   Delete Player Stats By Season. 119

15.6.1.5   Delete All Players Stats By Season. 119

15.6.1.6   Consolidate Expansion Roster 120

15.7  Resolving Issues From Imported Stats. 120

15.7.1    Incorrect Player Name. 120

15.7.2    Player Exists in Both Rosters. 120

15.7.3    Modifying the Stats File Description. 120

15.7.4    Removing Stats Based On the Stats File Description. 121

15.8  Calculating Batting Leaders. 121

15.9  Division Standings. 121

15.10 Creating a Web Site With Multi-Season Stats. 121

15.10.1  One Step Web Site Mode. 121

15.10.2  Cross-Linking to Main Team Web Site. 121

15.10.3  Resolving Problems. 123

16            USING THE SBC WITH 3rd PARTY MOBILE STATS APPS. 124

16.1  Overview.. 124

16.1.1    Statistics Imported. 124

16.1.1.1   Selecting Statistics for iScore. 125

16.1.2    Statistics Not Imported. 125

16.1.3    Player Name Conventions. 125

16.2  Transfering Stats From a Mobile App to the SBC.. 125

16.2.1    Procedure. 125

16.2.1.1   Unknown Player Detection. 127

16.2.1.2   Player Stats Validation Errors. 127

16.2.2    Post-Import Processing. 127

16.2.2.1   Resolving Non-Roster Player Issues. 127

16.3  Managing Rosters. 128

16.3.1    Transferring the SBC Roster to a Mobile App. 128

16.3.2    Transferring a Roster From a Mobile App to the SBC.. 128

17            Roster Importing and Exporting.. 130

17.1  Importing Rosters. 130

17.1.1    Importing a Roster From a Mobile App. 130

17.1.2    Importing a Roster From a File. 130

17.2  Exporting Rosters. 131

17.2.1    Formats for Mobile Apps. 131

17.2.2    Generic Formats. 131

17.2.2.1   SBC Roster File Format 131

17.2.2.2   Number Plus Player Name Format 131

17.3  Editing Roster Files. 131

1                    GENERAL INFORMATION

top_level_structure

Figure 1-1  SBC Overview

The SOFTBALL/BASEBALL STATISTICS CALCULATOR (referred to as the SBC) is a simple yet powerful application for keeping team batting statistics and division standings.

 

It is very easy to use and menu-driven allowing the user to:

 

·         Create a new team worksheet

·         Add players to either of two rosters 

·         Add teams to the division

·         Maintain a game schedule and results

·         Transcribe/update the batting results from the game scoresheets

·         Import game statistics collected via an Android or iPhone/iPad mobile stats app

·         Combine stats from individual seasons into a unified multi-season (career) team worksheet

·         Calculate team batting leaders in up to 19 categories

·         Maintain and automatically calculate the division standings 

·         Create a line score and box score for a selected game

·         Print reports

·         Create a web site optimized for both desktop and mobile web browsers with a single command !

 

1.1                              Program Availability and Licensing

The SBC is ADD-FREE and is offered as Donationware and is available for download at the SBC website at:

 

http://sbc.aces-softball.com/

 

The SBC represents thousands 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.

 

Known errata, limitations and revision history are available at the SBC web site under the Downloads tab.

 

The author encourages your comments/suggestions via email at: support@sbc.aces-softball.com

 

Excel, Windows, Microsoft Office, Internet Explorer are trademarks of Microsoft Corporation.

MacOS, Macintosh, OS X, iOS, Safari, iPhone, iPad are trademarks of Apple Computer, Inc.

SeaMonkey and Firefox are trademarks of the Mozilla Foundation.

W3C is a trademark of the World Wide Web Consortium.

Google, Google Analytics, Android OS are trademarks of Google, Inc..

PayPal is a trademark of PayPal, Inc.

iScore and iScore Baseball are trademarks of iScore Sports,  Faster Than Monkeys

League Lineup is a trademark of Leaguelineup.com

Find Local Weather is a trademark of the Find Local Weather  web service

HTML5 Enabling JavaScript (aka: "the shiv") for older IE browsers –

   Courtesy: Sjoerd Visscher  http://html5shiv.googlecode.com/svn/trunk/html5.js.

Mac VBA Tricks and Fixes –

   Courtesy of Ron DeBruin https://www.rondebruin.nl/mac.htm

All other programs and applications are trademarks of their respective organizations.

1.2                              Specifications

Maximum number of teams in division:35
Maximum schedule entries - Single-Season Mode:500
Maximum game entries per player - Single-Season Mode:500
Maximum season entries - Multi-Season Mode:500
Maximum number of Active (full-time) roster players:unlimited*
Expansion roster size for alternates/part-time players:unlimited*
Number of batting leader categories:19
Maximum number of entries in each leader category:10
Number of player entries in the game box score:30
Number of linkable web graphics images:25

 

* Limited only by the capacity of Excel worksheets which can vary by version. However,  the recent versions are more than adequate for single and multi-season Team Worksheets. Rosters increase/decrease in size as required.

1.3                              Operating Environment

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.  In addition to processor speed, actual performance may vary among specific versions of Excel.

 

All user functions are invoked via the custom SBC menus and toolbars.


The SBC operates within the confines of the user’s system and does not perform any Internet operations other than invoking the default system browser for acess to the on-line user manual, revision history and SBC web site when desired. Both the SBC macro and team worksheet files are internally password protected to prevent corruption.  File operations are all under user control and are limited to web site files creation, importing stats files or creation of a roster export file.

1.4                              Excel Compatibility

The SBC has been validated on the following US English language versions of Excel in these environments:

 

                Microsoft Windows:

·         Office 2019  (v16) – See note in Section 1.4.1.3

·         Office 2016  (v16) – See note in Section 1.4.1.3

·         Office 2013  (v15)

·         Office 2010  (v14)

·         Office 2007  (v12)

·         Office 2003  (v11)

 

                Macintosh:

·         Office 2011 (v14)

·         Office 2008 (v12)

·         Office 2004 (v11)

·         Office/X      (v10)

`

The SBC is not supported under Office 2016 on the Macintosh due to lack of support for key macro functions.

Running the SBC under Office 2008 on the Mac will result in reduced functionality due to reduced macro capabilities and is not reccommended.

 

The SBC has not been recently validated and may not work on older versions of Excel. The SBC may not function on some international versions of Excel.

 

Attempts have been made to validate the functionality of the SBC on both Macintosh OS X and Microsoft Windows platforms under a number of versions of Microsoft Excel. Due to platform availability and time, validation is a work in progress.  If you encounter a situation where the SBC does not function correctly, please file a technical support request (Section 1.6).

1.4.1                        User Interface Differences in Excel Versions

1.4.1.1                  Excel/Windows Versions Prior to 2007

Excel versions prior to 2007 employ a fixed custom SBC menu bar (Figure 2-1) at the top of the window and floating toolbars for the user interface (Figure 3-6).

1.4.1.2                  Excel/Windows Versions 2007 and Beyond

Starting with 2007, a new Ribbon User Interface was introduced. With these versions, the SBC menus and toolbar will appear under the Add-Ins tab (Figure 2-2).  The SBC will activate this tab at startup time if it is visible on the ribbon. If not, the user will be notified to enable this tab via the File/Options/Customize Ribbon command (Figure 1-2).

 

customize ribbon

Figure 1-2  Excel Options Under Windows Ribbon Interface

Note that in Excel 2007, the File tab is not present - Clicking on the Excel globe: excel2007_globe performs this function. Starting with Excel 2010, the File tab has been restored.

 

The Window menu has no function under the Ribbon Interface and therefore does not appear on the SBC menu bar.

1.4.1.3                  Excel/Windows Versions 2016, 2019

The SBC The SBC is compatible with Excel 2016 and 2019 on Windows. Note that version 2019 runs under Windows 10 ONLY. It should be noted that these versions do not co-exist well with previous versions on the same machine.

Also note that Microsoft has not changed the base revision for 2019. So the File / About Softball Team Calculator command will still show as Excel version 16.

1.4.1.4                  Excel/Mac Versions Prior to 2008

Excel versions prior to 2008 employ a fixed custom SBC menu bar (Figure 2-1) at the top of the window and floating toolbars for the user interface (Figure 3-6).

1.4.1.5                  Excel/Mac Version 2008 and Beyond

Starting with Excel 2008, a new Ribbon User Interface (UI) was introduced. This is a hybrid implementaion as compared to the Windows Ribbon UI. The SBC menus still appear in the menu bar at the top of the windo. The SBC toolbars appear as floating toolbars as in previous versions. Many of the built-in Excel tools and functions formally available via floating toolbars have been relocated to the Ribbon.

 

The following limitations apply:

 

Excel 2008 only

Running the SBC under Office 2008 on the Mac will result in reduced functionality due to reduced macro capabilities and is not reccommended.

 

1)       Visual Basic macros not supported (an unfortunate omission that was addressed by Microsoft in Excel 2011). At startup an alert will be posted (Figure 1-3). Hit the Open button. Do not hit the “Open and Remove Macros” button.

2)       The SBC Team Worksheets are configured for display in Page Break Preview mode. This mode is not available. The icon for Normal View located at the bottom left corner of the window must be selected for proper SBC operation. The SBC cannot detect whether Normal View mode is active nor can it change it. A reminder alert to do this will be displayed at startup.

3)       The ability to work with user-defined web graphics is broken (Section 13.2.2). However, any web graphics that are present in a Team Worksheet will not be affected.

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

5)       The custom SBC toolbars are not available due to limitations in the Excel macro functions. Use the menu command equivilents instead.

Screen shot 2013-07-05 at 3

Figure 1-3  Visual Basic Alert

Excel 2008 and 2011

1) The SBC Team Worksheets are configured to show page breaks (Page Break View). The Excel macro support for this is broken. This is strictly cosmetic for screen viewing. Printing and web page generation are not affected. There is no workaround for this.

2) When prompted for file or directories, the previously used directory location is not always preserved. There is no workaround for this.

3) When executing commands that take a fair amount of time, the contents of the window may appear to jump or flash. This is cosmetic only.

4) A script menu and separate Excel Help menu is displayed on the custom SBC menu bar.  The SBC cannot block these.

 

Excel 2016, 2019

The SBC is not supported as critical macro functionality has been dropped in these versions of Excel on the Mac.

Use Excel 2011 or previous on the Mac or any Windows version of Excel.

1.4.2                        Security Differences In Excel Versions

The SBC operates within the confines of the user’s system. The only Internet operations are those invoked explicitly by the user (eg: on-line user manual, on-line revision history, etc). Both the SBC macro and team worksheet files are internally password protected to prevent formula corruption.  File operations are all under user control and are limited to saving a Team Worksheet file, web site creation, importing stats and schedule files,  creation of a roster export file or CSS style sheet file.

 

Each version of Excel has its’ own method of dealing with macro security. For the SBC to operate, Excel must be configured to allow macros to execute. In some versions, this is accomplished via a dialog box during launch prompting the user to enable Macros. Hit the Open button. Do not hit the “Open and Remove Macros” button. This alert may appear twice on some versions (once for XLM macros, once for VBA macros).

 

xl2008 macros enable alert

Figure 1-4  Macros Enable Dialog Example

Later Excel versions require the user to configfure the security preferences settings.  A medium level of security is sufficient for proper SBC operation.

1.4.2.1                  Security Configuration For Windows/Excel 2007 and Later

With the advent Excel 2007, the user needs to configure the security settings for proper operation of the SBC. Note that in Excel 2007, the File tab is not present - Clicking on the Excel globe: excel2007_globe performs this function. In Excel 2010 and beyond, the File tab has been restored.

 

Excel must be configured to allow the SBC to execute from the directory where the SBC files are intended to be stored. This is controlled in the Trust Center by the File/Options/Trust Center/Trusted Locations tab:

 

trust_center_file_locations_dialog

Figure 1-5  Trust Center Trusted Locations Dialog

Click on the Add New Location tab to add the directory/directories.

 

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_macros_dialog

Figure 1-6  Trust Center Macro Settings Dialog

The default setting is Disable all macros with notification. This is the safest setting. 

 

It is also desireable to configure the File Block Settings to allow Excel/4 worsksheets,workbooks and macros by unchecking the associated Open checkboxes:

 

trust center file block settings

Figure 1-7  Trust Center File Block Settings Dialog

1.4.2.2                  Launching the SBC On Windows/Excel 2007 and Later

After the Trust Center configuration has been completed, a one-time sequence needs to be performed.

 

1) Launch the SBC by clicking on the SBC_Macros.xlm file. If you see an alert  warning about the file format, answer Yes:

 

file_format_warning

Figure 1-8  File Format Warning Notification

2) After Excel loads, you will 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_msg_bar

Figure 1-9  Security Warning Notification

3) Select a Team Worskheet file to open. The SBC should launch normally at this point.

 

4) After you see the SBC READY message in the message bar, quit the SBC  via File/Quit Softball Team Calculator. No need to save the Team Worksheet file at this point. 

 

Subsequent launches of the SBC can then be performed by clicking on a Team Worksheet.

1.4.3                        File Format Differences in Excel Versions 12 and Greater

Starting with Version 12, Excel was enhanced to the support the Office Open XML standard. Files in this format have an .xlsx suffix. When saving an SBC team worksheet, make sure to save it in the orginal .xls format. If you save it in the .xlsx format, you may not be able to re-launch the SBC next time.

1.4.4                        Team Worksheet Compatibility

The SBC provides forward compatibility for team worksheets that were created using previous SBC versions. When a previous version team worksheet is first launched with the latest version of the SBC, all applicable patches will be applied. The message bar will show the progress of the patch processing. When all the patches have been applied, the message bar will show SBC READY. Once the team worksheet is saved, the patches are permanent. The team worksheets supplied with the SBC releases already incorporates these patches.

1.5                              Running The SBC With Other Excel Documents Open

Only a single Team Worksheet can be open at one time. Once the SBC has been started, non-SBC documents may be opened, if desired. Users may switch between documents by clicking on them or by using the Window menu (non-Ribbon UI versions of Excel). See Sections 1.4.1 thru 1.4.3 for limitations when running under certain versions of Excel.

 

Import operations (eg: Schedule, Stats, Roster) will close all open documents except the active Team Worksheet. The user will be prompted to save any documents that have been modified.

1.6                              Support

1.6.1                        On-Line Support

On-line support can be found at the SBC web site at http://www.sbc.aces-softball.com.  There are helpful hints plus an on-line user manual.

1.6.2                        Contacting Support

If you run into a situation that is not documented or where the SBC does not perform as expected, file a technical support request via email to: support@sbc.aces-softball.com

 

Responses to email queries will originate from:

support@sbc.aces-softball.com

Insure that you add this to your email address book and/or spam filter whitelist as a valid 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 was attempted ?

5.          Is the issue repeatable ?

6.          The sequence of events that led to the problem

7.          Any alert messages that were posted

8.          Contents of the window message bar area

9.          In the event of a macro error fault, capture the information reported and the line number.

 

*This information is available via the File / About Softball Calculator command.

1.6.3                        Revision History

Enhancements and bug fixes for the current version plus known limitiations can be viewed via the SBC Help / SBC Revision History command (active internet connection required).

 

History for previous versions can be viewed at the SBC web SBC web site at: http://www.sbc.aces-softball.com

1.6.4                        Comments and Feedback

General comments and suggestions via email to: support@sbc.aces-softball.com

 

 

Return to Table of Contents

 


 

2                    GETTING STARTED

2.1                              Program Installation

WARNING:

The SBC does not require a password to use or a deinstaller to remove from your system.

There are web sites that claim to offer keygen or deinstaller programs for the SBC. These are rogue programs that can install viruses and/or cause damage to your system if executed.

 

The distribution contains the following files and folders:

   

SBC_Macros.xlm - The main controlling functions for the program

Single-Season Mode Files - Folder with example files for Single Season Mode

       SBC_Blank_Team.xls - A blank team worksheet

       SBC_Sample_Team.xls - A sample team worksheet with active teams and players

       6-4-3 Sample Import File.csv – Sample file as generated by the 6-4-3 Baseball Scorecard mobile app (Section 16)

       iScore Sample Import File.csv – Sample file as generated by the iScore Baseball mobile app (Section 16)

       example schedule – sbc format.xls – Sample file to display the SBC schedule import file format (Section 5)

       example schedule – general format.xls – Sample file to display the general schedule import file format (Section 5)

       SBC Sample Roster File FN LN.csv – Sample file to display the roster import file First Name / Last Name format (Section 17)

       SBC Sample Roster File LN FN .csv – Sample file to display the roster import file Last Name / First Name format (Section 17)

 

Multi-Season Mode Files - Folder with example files for Multi-Season Mode (Section 15)

       SBC_Blank_Team_MS.xls - A blank team worksheet

       SBC_Sample_Team_MS.xls - A sample team worksheet with active teams and players

Web Site Files – Folder with files for web site processing

       sbc-logo-72.png SBC logo graphics file for web page mastheads (Section 9)

       favicon.ico – Graphics file for desktop browser icon display (Section 9)

       apple-touch-icon-xxx.png Nine files used for bookmarks on mobile devices (Section 9)

                                                                

Copy these files into a working folder on your hard disk. No restriction on folder names is enforced, except that the SBC_Macros.xlm and team worksheet files must be in the same folder. However, an alias of a team worksheet file may be created to launch the SBC from a different location. The web site files should be placed in a separate folder.

 

WARNING:

The macro file:  SBC_Macros.xlm  must not be renamed.

2.1.1                        Deinstalling the SBC

WARNING:

The SBC does not require a password to use or a deinstaller to remove from your system. There are web sites that claim to offer keygen or deinstaller programs for the SBC. These are rogue programs that can install viruses and/or cause damage to your system if executed.

 

The SBC may be deinstalled by simply dragging the SBC_Macros.xlm file to the trash. The team worksheets and supporting web files may be deleted as desired.  The SBC  does not require a password or key to install, use or uninstall the program. 

2.2                              Starting the SBC

After doing the basic installation of the files,  and reviewing the overall sturcture of the SBC, it is beneficial to get a flavor of what a working team worksheet looks like. Insure that the Excel application is not active. Then, double-click on the SBC_Sample_Team.xls file. 

 

The SBC  Macros will be loaded and automatically started. Custom menus and toolbars will be built. Watch the Excel message bar at the bottom left of the team worksheet  for progress information. When the watch/hourglass cursor stops, you’ll see SBC READY. You are now ready to begin !

 

When a Team Worksheet is launched with a new revision of the SBC, a “thank-you for downloading”  message will appear. After the Team Worksheet is saved, this message will no longer appear on subseqent launches. Configuration messages may also appear depending on the version of Excel.

 

Alternatively, the SBC may started by double-clicking the SBC_Macros.xlm file. A Prompt for a Team Worksheet will appear. Note that some versions of Excel may post an alert indicating a possible file format issue with the SBC_Macros.xlm file. These can be ignored by clicking the Yes button.

 

If you encounter security alerts, check the Trust Center configurations (Section 1).

 

Screen shot 2013-10-02 at 2

Figure 2-10  File Format Warning Example

2.2.1                        Activating the SBC Menus and Toolbars under The Windows Ribbon UI

On Excel versions on Windows with the Ribbon user interface, the SBC menus and toolbar appear under the Add-ins tab.  The SBC will activate this tab at startup time if it is visible on the ribbon. If not, the user will be notified to enable this tab via the File/Options/Customize Ribbon command.

2.2.2                        Screen View Under Excel 2008 / Mac

Excel/2008 does not support the Page Break Preview display mode. The Normal View mode must be selected via the icon at the bottom left of the page. A reminder alert to perform this operation will occur at start-up time if the Display / Informational Messages option is checked. Once the Team Worksheet is saved, the Normal View mode is permanent.

2.2.3                        Operating Environment Detection

At startup, the SBC will automatically configure its environment based on the version of Excel and the operating system (Macintosh or Windows). If this cannot be determined, the user will be prompted to select the version of Excel:

 

select excel version dialog

Figure 2-11  Manual Selection of Excel Version

This prompt will occur any time the SBC cannot detect the operating environment. However, the SBC will attempt to preserve the previous selection as the default for subsequent launches under this situation.

 

Due to major differences/limitations in the underlying macro support, the SBC may not be usable under international versions of Excel, especially non-English language versions.

2.3                              User Interface

2.3.1                        Overview

The SBC is controlled via a custom set of commands. These commands are organized by major areas of functionality and accessed through a traditional menu-driven interface. Keyboard equivilents are provided for most commands as well.

 

A custom toolbar provides rapid access to commonly used commands.

2.3.2                        Command Set Organization

The SBC commands allow the user to:

 

·         Create and maintain a team roster

·         Create and maintain a game schedule and results

·         Transcribe/update the entries from the game scoresheets or 3rd party mobile stats apps

·         Calculate team batting leaders

·         Create a line score and box score for a selected game

·         Maintain the division standings 

·         Print reports

·         Create a web site optimized for both desktop and mobile browsers with a single command

2.3.3                        Custom Menus

On non-Ribbon versions of Excel (pre-2007 on Windows and all supported Mac OS X versions), the menu bar appears at the top of the screen.

 

On ribbon versions of Excel on windows, the menus appear under the Add-ins tab on the ribbon.

 

menu basic

Figure 2-1  Basic Command Set Menu Bar

2.3.4                        SBC Toolbar

When active, a custom toolbar will appear with a number of frequently used commands. (Figures  2-2a, 2-2b). Sliding the cursor over the tool will show a literal description of the tool function.


NOTE: The tool icons may vary in appearance on different versions of Excel.

 

Figure 2-2a  SBC Toolbar Under Ribbon UI

Figure 2-2b  SBC Toolbar Under non-Ribbon UI

The SBC Toolbar appears as a floating toolbar on all Mac versions of Excel, and on non-Ribbon UI versions on Windows platforms.  The toolbar can be resized and repositioned on the screen as desired.

 

On Excel with the Ribbon UI on Windows platforms, it appears as a fixed toolbar under the Add-ins tab on the Ribbon interface. Under the Ribbon UI, the toolbar position and size is fixed and cannot be modified.  Note that most formatting tools are not included as they are rapidly available under the Home Ribbon tab.

2.3.5                        SBC Toolbar Organization

The tools have been selected to provide a basic set of common functionality in the Basic Command Set mode without the possibility of corruption of the team worksheet. Additional tools are available in Expanded Command Set Mode.

Dimmed tools are not available in the Basic Command Set mode or on some versions of Excel.

Tools marked with an asterisk (*) are only active in Expanded Commands mode.

2.3.5.1                  Group 1 Tools – Quit/File/Print/Repeat

Quit

Save

Import – Allows Schedule and Roster importing in Single Season Mode. Stats and Web Theme importing in Expanded Commands mode.

Export Allows Schedule (Single Season Mode only) and Roster exporting. Web Theme exporting in Expanded Commands mode.

Print  - Structured printing of the contents of theTeam Worksheet

Repeat SBC Command – Where applicable, the last SBC command will be repeated. The name of the command will be shown in the tooltip.

2.3.5.2                  Group 2 Tools – Display Navigation

Home

Batting Summary

Game Range Display

User Notes =

2.3.5.3                  Group 3 Tools – Game Schedule

Display Game Schedule  

Analyze Game Schedule  

Edit Game Schedule

Export Schedule

Edit/Resequence Game Numbers

2.3.5.4                  Group 4 Tools – Batting Leaders and Box Score

Display Batting Leaders

Caculate Batting Leaders

Calculate Box Score

2.3.5.5                  Group 5 Tools – Roster and Stats

Display Detailed Player Stats

Validate Player Stats

Update Player Stats

Add Player to Roster

Delete Player from Roster

Transfer Player Stats

Rename Player

Merge Player Stats*  

2.3.5.6                  Group 6 Tools – Web Site Generator

One Step Web Site

Display Computed URL’s*

Edit Custom Hyperlink *

2.3.5.7                  Group 7 Tools – Configuration /Help/Info

Edit Preferences  - Multi-functional selections

Open the On-Line SBC User Manual

Display SBC Keyboard Shortcuts

Information  - Multi-functional selections that display program information and summaries from recently executed import and export commands.

Pending Notifications  - Displays any pending notifications that may need to be reviewed (eg: Stats validation errors from importing). See Section 2.3.7.

2.3.5.8                  Group 8 Tools - Misc

Display Gridlines and Headings

Show/Hide Formula Bar

Worksheet Protection *

Select All

Protected Mode Formatting

2.3.5.9                  Non-Ribbon Mode Tools

The Copy  , Paste , Paste Format , and Paste Values  tools are equivalent to the functions found on Mac and Windows platforms. These tools are usable only on unprotected areas of the Team Worksheet. See Section 4.3 for more details.

 

The Undo   and Repeat   tools are provided but are limited in scope to basic Excel functions. A separate Edit/Repeat function is available for SBC-specific commands.

 

Some basic formatting tools are provided for a cell or range of cells. The Align Text , Borders  and Fills and Patterns  tools provide similar modifications for their respective attributes. See Section  4  for notes on using these tools.

 

 On some versions of Exel, the Excel Help  toolbar button is not displayed. To view the standard Excel Help, click on the  Screen shot 2013-01-09 at 8 icon in the main Excel tab bar or use the commands in the Help menu or tab.

 

In the event that the toolbar becomes non-functional/visible, the Restore SBC Toolbar command will restore proper operation.

2.3.5.10              Toolbar Icon and Tooltip Size

Screen shot 2016-01-31 at 5 

Figure 2-3  Modifying Toolbar and Tooltip Size

On the Windows platforms, the default 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 change the menu and toolbar settings for all applications, not just for Excel.

 

NOTE: Toolar icon size cannot be changed running under Excel on the Mac L.

 

2.3.6                        Status Bar and Progress Messages

The standard Excel Status Bar area at the bottom left of the active window is used for status and progress messages from SBC operations. When the SBC is ready to accept a command from the user, the status bar will display:

 

SBC READY – xx Games

 

Where xx indicates the number games. When a command is running, the Status Bar will indicate  the operation(s) being performed.

 

If there are any notifications that need to be addressed, the Status Bar will indicate this:

status bar notifications

Figure 2-4 Status Bar With Notifications Alert Example

The Display / Pending Notifications command or tool icon can then be used to view the specifics (Section 2.3.7).

For long oprations (eg: Initialization, One Step Web Site, Calculation of Batting Leaders), the Status Bar will also indicate the percentage completion of the command.

 

When running the SBC under Windows Excel, the progress will appear in a small modeless dialog on the screen  . No user intervention is required:

 

progress box

Figure 2-5  Progress Window Display

--------------

2.3.7                        Pending Notifications

Several operations of the SBC may require follow-up intervention after the command has been executed. If this occurs, the user will be alerted in the Status Bar message (Figure 2-4). The Display / Pending Notifications command or tool icon can then be used to view the specific items that may need fixing:

pending notifications summary example

Figure 2-6 Pending Notifications Summary Example

Dimmed items do not require attention. Select the desired item and then Fix to run the appropriate supporting command.

Batting Leaders needs updating

Usually the result of deferring this operation after running a command where one or more players appears in the current Batting Leaders. Re-run Calculate Leaders command.

Box Score needs updating

Usually the result of deferring this operation after running a Player command where one or more players appears in the current Box Score. Can also indicate errors as a result of Box Score calculations such as missing field(s), mismatch of line score runs vs Box Score runs totals. Correct as necessary and re-run Calculate Box Score command.

Division Standings needs updating

An attempt to enter more than the maximum number of teams into the Division Standings. This could be the result of an incorrect schedule import. Correct as required and re-import the schedule.

Can be the result of the Main Team Name not selected. Correct and re-run Division Standings update.

Player stats validation errors

This can result from importing a corrupted stats import file. Run the Validate Stats command for details. Ideally, they should be corrected at the source. Then, rerun the import operation.

Schedule entries incomplete

This is common at the beginning of the season when an incomplete schedule has been entered (eg: Date only but time/field/opponent may not be defined). Correct as necessary.

Unknown or duplicate players in roster

During stats or roster importing, player names that do not already exist in the rosters or exist in both rosters will be flagged. Ideally, the issues should be corrected at the source. Then, re-run the import operation.

2.4                              Major Operating Modes

2.4.1                        Basic Command Set Mode – Single Season

This is the default mode of operation. This mode allows tracking of a team’s batting statistics for a single season.  Statistics are tracked on a game-by-game basis. The sample and blank single season team worksheets are configured in this mode.

 

The commands in Basic Command Set Mode have been selected to provide a simplified user interface that should be adaequate for most users.

 

In addition to printed reports, a complete web site can be automatically generated with a single One Step Web Site command.   Web pages are generated for optimum viewing on both desktop and mobile browsers. No additional apps are necessary.  No web page authoring knowledge is required. Section 9 describes how to use this feature.

 

As the SBC can be configured to track statistics collated from multiple team worksheet files (Multi-Season Mode), it is suggested that statistics from the regular season, tournaments, playoffs, etc. be maintained in separate team worksheet files. A new team worksheet can be created in Multi-Season mode to create composite/career statistics and a new web site with these statistics.

2.4.2                        Expanded Command Set Mode – Single Season

In this mode, additional functionality is available including features such as customization of the look of the SBC and the style of generated web pages  (Sections 11– 14). Also, support for game statistics collected via a third-party app on a mobile or tablet device is available in this mode (Section 16).

2.4.3                        Expanded Command Set Mode – Multi-Season

In this mode, the SBC can generate a collated set of statistics and a web site from multiple team worksheets.  The main intent of this mode is to track batting statistics over multiple seasons. It may be also be used to combine statistics from regular season, playoffs, tournaments, etc. into a composite season stats file (Section 15).

2.5                              Active and Expansion Rosters

The roster is divided into two areas referred to as the Active and Expansion rosters. The Active roster is intended for full-time players. The Expansion roster is intended for part-time or substitute players.  The use of the Expansion roster is optional.

 

The same statistics categories can be entered for players in either roster.  Players and their stats can be transferred from one roster to the other at any time. Stats from multiple players can be merged into a single entry.

 

The major differences between the two rosters are shown in Table 2-1. Applicable specifications are shown in Section 1.2. The Expansion roster can be renamed as desired

 

Feature

Active Roster

Expansion Roster

Statistics Organization

Separate page for each player

Single page for all players

Roster Limits

No limit*

No limit*

Number of Single Season Game Entries

500

500

Number of Multi-Season Season Entries

500

500

Batting Leaders

All players included

Selectable inclusion

* limited only by the version of Excel.

Table 2-1  Active vs. Expansion Rosters

2.6                              Statistics Tracking Mode

The SBC can track statistics for slow or fast pitch softball, and baseball. The Track Slow Pitch Stats Only option  controls this mode (Section 4).

 

When this mode is disabled, the full set of statistics is tracked.  This is the mode for fast-pitch softball or baseball. By default, the SBC is configured for fast pitch softball and baseball.

 

When the Track Slow Pitch Stats Only mode is enabled, SB, HBP and SACB stats are not tracked. This applies to the player stats, player updating, batting leaders, box score, web site generation and printing.

2.7                              Team Worksheet Organization

The team worksheet displays the results of all entered and calculated statistics. Critical areas of the team worksheet are protected against accidental user corruption. The major areas are as follows:

2.7.1                        Top Level Team Summaries Page

Screen shot 2014-09-28 at 10

Figure 2-7  Team Summary Page

The Team Summary Page is visibly organized into the following areas:

 

·         Header / masthead area

·         User customizable area for notices and general team information

·         Division standings including wins/losses/ties, winning percentage and Games Behind Leader (Section 5)

·         Box score and line score for a selected game (Section 7)

·         Summary of team batting leaders with top player in each category (Section 6)

 

This page is also a framework for a team web site home page (Section 9).

2.7.2                        User Notes Area

user notes

Figure 2-8  User Notes Area

This area is a separate page with an unprotected block of cells. Some possible uses of this area are:

 

  • Personal notes for the maintainer of the statistics
  • Notices for the team, league, etc.
  • Custom game schedule and upcoming events
  • Detailed team roster information (eg. player contact information)

 

The cells in this area are normally formatted for text entries but can be reformatted as desired via the Edit / Format User Notes Area command.

 

Entries in an individual cell are limited to a maximum of approximately 200 characters. Entries wider than the cell will span across adjacent cells.

 

The User Notes area may be included when the Team Worksheet is printed via the option in the General Preferences command dialog (Section 4). If selected, it will appear as a separate page.

 

This area may be optionally generated as a separate web page during the One Step Web Site command (Section 9. When a web page is generated, the area will be minimized both horizontally and vertically to the non-blank cell area and then centered in the web page content area.  The first non-blank cell in the area will be interpreted as a title line and highlighted in the web page. If this is not desired, place a single space in one of the cells in the first active row.

 

If your users will be utilizing mobile/handheld devices to view the web site, the content should be kept sparse and more vertical in structure. This will improve readability. 

 

In Expanded Commands mode, custom hyperlinks can be added to cells in the User Notes area via the Edit / Custom Hyperlink command.

 

If a web page is generated for the User Notes area, use discretion when including personal contact information to prevent possible misuse or indexing by web search engines.

2.7.3                        Team Batting Statistics

Screen shot 2014-09-28 at 10

Figure 2-9  Batting Summary Page

This is a summary of batting statistics for each Active roster player plus a composite summary of all player statistics in the Expansion roster. The Expansion roster players line will be blank if there are no player entries in that category. See Section 6 for more details on the creation and maintenance of the rosters.

2.7.3.1                  Formulas Used in Statistics Calculations

The SBC uses commonly accepted formulas for statistics calculations and abbreviations as defined by Major League Baseball at:

http://mlb.mlb.com/mlb/official_info/baseball_basics/abbreviations.jsp. The formulas are also sumarized at the Baseball Reference web site:

 

At Bats (AB): H + Outs + FC + ROE – BB – SF – SACB – HBP – CI
Batting Average (AVG.): H / AB
Slugging Pct (SLG): (1B + 2*(2B) + 3*(3B) + 4*(HR)) / AB
On Base Pct (OBP): (H + BB + HBP ) / (AB + BB + HBP + SF)
On Base Plus Slugging Pct (OPS): OBP + SLG

 

The SBC does not track CI (reached on catcher’s interference) as a unique statistic. However, if you record a Plate Appearance in this case, the overall statistics will be correct.

 

When the SBC is in the Slow-Pitch Stats Tracking mode, SB, HBP and SACB stats are not tracked and therefore, not factored into the AB, OBP or OPS calculations.

2.7.4                        Detailed Batting Leaders

leaders

Figure 2-10  Batting Leaders Page

A display of the results of calculation of batting leaders in each category. In addition, the top leader in each category is displayed on the Summary Page. The user can choose AB or Appearances for the Batting Avg, Slugging Pct, On-Base Pct, and On-Base Plus Slugging Pct categories and the minimum number to qualify. The categories and number of players posted are selectable as well.  Ties for the last position are posted.

2.7.5                        Game-by-Game Player Statistics Pages

player stats ng

Figure 2-11  Player Game-by-Game Stats Pages

Subsequent pages hold individual batting statistics for each Active roster player for each game played. A separate page tracks game statistics for the Expansion roster area (for reserves/alternates/part-timers/subs/wannabe’s).

2.7.6 Game Schedule and Results

Screen Shot 2017-08-04 at 5

Figure 2-12  Game Schedule Page

A composite schedule of all games is compiled on a separate page. This is the results of all completed and scheduled games. Team W-L-T record, current Streak, averages of runs scored/allowed, winning/losing margins are displayed as well.  Options for annotating game status, plus automatic marking of unplayed games as TBP (To Be Played) or NR (Not Reported) , highlighting the next unplayed game, and updating of Division Standings from the schedule are provided.

 

A blank entry with identifying Game number will appear for games that have player stats but do not have attribute information or a line score. The Status field will be marked as Stats Only.

 

See Section 5.2 for more details.

 

2.8                              Setting Up A Team Worksheet

Start with a copy of a blank team worksheet or run the File / Configure New Team command.

 

Then perform the following steps to organize a new team worksheet:

 

1.       Set up the teams in the division standings  (Section 5)

2.       Set up your user configurable parameters  (Section 4)

3.       If available, set up the game schedule  (Section 5)

4.       Set up the player entries for your rosters (Section 6)

5.       Set up the print options by executing the File / Page Setup command (Section 8)

2.9                              Quitting the SBC

The preferred way to quit the SBC is via the toolbar icon =16 height=16 id="Picture86" src="images/image078.png">, the  File / Quit Softball Team Calculator command, or by the option+cmd+Q keyboard shortcut. The user will be prompted with a file save dialog box for the team worksheet. The SBC and the Excel application will be terminated normally. The SBC closes the SBC_Macros.xlm  file automatically at termination. In the unlikely event that a prompt occurs to save this file, always hit the Don’t Save button.

 

WARNING:

If you are running the SBC under Excel 2007 or greater, make sure to save the Team Worksheet as an .xls file.

 

The window close control in the window title bar (red button on the Mac or the  “X” box on Windows) may be used. However, if depressed, the Cancel dialog button will be ignored. This is due to the inability of the SBC to detect the cancel action in this  situation.

 

It is not recommended to exit via the Excel/Quit or Excel/Exit command as extraneous prompts to save the SBC_Macros.xlm macro sheet may appear. As is the case with the window close button, the Cancel dialog button will be ignored.  In addition, when executing this command on some Windows versions of Excel, a macro error may occur.

 

Return to Table of Contents

 


 

3                     BASIC COMMAND SET REFERENCE

This section summarizes the basic command set of the SBC. For the majority of users, these commands are sufficient to create and maintain team statistics, perform basic text style modifications, print reports and generate a basic web site. Dimmed items are not available in Basic Command Set.  A number of frequently used commands are also available on the SBC Toolbar.

Commands that are dimmed are not available in Basic Commands Set mode.

 

In the Apple Macintosh environment, cmd is the Mac_cmd key and the opt key is the option key. In the Windows environment, cmd is the control key and the opt key is the alt key.

 

Keyboard equivalents and toolbar icons for common commands are identified where applicable. See Table 3-1 for a summary of all keyboard shortcuts.

3.1                              File Menu

Figure 3-1  File Menu in Basic Commands Mode

3.1.1                        About Softball Calculator

Screen shot 2016-01-22 at 8

Figure 3-2  About Softball Calculator Dialog Box

Shows program information and how to access the SBC website. The link may be copied into your browser. In adition to download information, latest support info, there is a link to contact SBC support are available as well on the site. Note that not all versions of Excel suport copying of the link from this dialog box. The web site may also be accessed via the commands in the SBC Help menu and toolbar.

3.1.2                        Open

Opens a new document. Only non-SBC Excel documents can be opened as the SBC allows only a single Team Worksheet to be active at a time. Non-Excel documents (eg: text files, csv files) can be opened by double-clicking on the file.

 

This command is not available on Excel versions with the Ribbon Interface on the Windows platform. Double-click on documents to open them.

3.1.3                        Save (cmd+S) / Save As

Same as normal Excel File menu functions to save the Team Worksheet or a copy.

 

WARNING:

If you are running under Excel 2007 or greater, make sure to save the Team Worksheet as an .xls file, not an .xlsx file.  Otherwise, you will may not be able to re-launch the SBC from this Team Worksheet.

3.1.3.1                  File Details/Properties

An SBC Team Worksheet has identifying information that can retrieved via operating system commands. On the Mac, this is achieved by performing a Get Info command. On Windows, right-click on the file and select Properties. An example of the results is shown from the Mac:

Figure 3-3  Get Info / Properties Example

3.1.4                        Import Schedule

This command will import a game schedule from a comma-separated variable (.csv) or  Excel workbook file. See Section 5 for details.

3.1.5                        Import Roster

This command will import a set of player names from an external file. See Section 17 for details.

3.1.6                        Configure New Season

This will reconfigure the Team Worksheet for a new season. Main Team Name, roster entries and division teams are left unchanged. This command will clear out:

 

·            Player stats

·            Division WLT records

·            Batting Leaders

·            Box Score display

·            Schedule and Game Results

 

No other parameters will be modified. The user will be prompted to modify the Stats File Description and the Masthead Banners as desired.

3.1.7                        Configure New Team

Similar to the Configure New Season command but will also clear the rosters and division teams. No other parameters will be modified. The user will be prompted to modify the main Team Name,  Stats File Description and the Masthead Banners as desired.

3.1.8                        Export Rosters

This command will export the Active and Expansion roster player names to a file. See Section 17 for details.

3.1.9                        Export Schedule

This command will create a vCalendar-compatible file for subsequent importing into popular calendar apps such as Google Calendar, Outlook, iOS and OSX Calendar. See Section 5 for details.

3.1.10                    Team Worksheet Protected

This command is not available in Basic Command mode as the Team Worksheet is always protected.

3.1.11                    One Step Web Site (cmd+opt+W)

Generates a web site for both desktop and mobile browsers with one menu command (Section 9).

3.1.12                    Page Setup

Same as normal Excel File / Page Setup

3.1.13                    Default Page Setup

Same as Page Setup, except reverts to built-in default settings.

3.1.14                    Printer Setup

Allows selection of the printer from within the SBC. Only available when running on Windows platforms.

3.1.15                    Print (cmd+P)

See Section 8 for more details on printing options.

3.1.16                    Print Selection (cmd+opt+P)

Allows a specific area of the team worksheet to be printed.

3.1.17                    Quit Softball Team Calculator (option+cmd+Q)

This command quits the SBC application.

3.2                              Edit Menu

The traditional Edit / Copy, and Select All commands are supported. As most of the worksheet area is protected, the Cut command is blocked. The Paste and Paste Special functions are blocked from the menu to prevent internal errors. However, the keyboard shortcuts, right click mouse and toolbar buttons provide some of their functions.

3.2.1                        Repeat (cmd+opt+Y)

Repeats execution of the previously executed SBC command. The title of the command will be shown when applicable or Can’t Repeat if not feasible. This is unique to SBC commands. The standard Excel Repeat (cmd+Y or toolbar function =16 height=13 id="Picture92" src="images/image083.jpg">) can be used in some limited instances as well for non-SBC commands such as Copy, Paste, Format Text, etc.

3.2.2                        Select All (cmd+A)

This command will select all active areas of the team worksheet. The header areas are not included in the selection. This is useful for making global formatting changes. See Section 4 for more details on text format modifications.

 


edit basic

Figure 3-4  Edit Menu in Basic Commands Mode

3.2.3                        Schedule

This command invokes the Game Schedule Manager (Section 5). This capability provides for maintenance of information unique to each game. Games can be added/modified/deleted.

3.2.4                        Game Numbers

This command invokes the Game Number Manager (Section 5). This capability provides for modifying or resequencing game numbers.

3.2.5                        Screen Size

This command allows the user to change the size of the content of the team worksheet from 10% to 400% of normal size.  It does not change the window size nor does it have any effect on the generated web pages. 

3.2.6                        Game Display Range (opt+R)

This command allows display of a subset of statistics via a user-selectable game number range (Section 4). This feature is useful when it is desired to view a set of statistics for a set of games that may be part of a tournament, for example.

3.2.7                        General Preferences 

This command allows the user to modify parameters that are applicable to general operation of the SBC (Section 4).

3.2.8                        Batting Leaders Preferences

This command allows the user to modifiy parameters that are applicable to the calculation of batting leaders (Section 6).

3.2.9                        One Step Web Site Preferences

This command allows the user to modify parameters that are applicable to the generation of a team website (Section 9).

3.2.10                    Format User Notes Area

This command allows the user to clear or re-format the User Notes area. The command will invoke the dialog shown.:

 

format user notes

Figure 3-5  Format User Notes Area Dialog

The default parameters are shown. The user has the option of selective re-formatting of a cell, or group of cells by checking the Apply to Selection Only option. If unchecked, the operations are performed on the entire User Notes area.  Standard formating tools may also be used for individual cells.

3.2.11                    Update Masthead Banners

This command will use the banner text and format from the Summary Page header to update the headers on the Team Summary, User Notices and Leaders pages.

3.2.12                    Division Team Names Locked

This command controls the ability to modify the team names in the Division Standings (Section 5).

3.3                              Display Menu

display basic

Figure 3-6  Display Menu

These commands allow rapid display of a selected area of the team worksheet and display control of additional items of interest.

3.3.1                        Player Stats

Prompts the user for a specific player name (default is the first Active roster player name in the team worksheet) and display the detailed stats for the player. The Expansion roster players may also be displayed with this command.

3.3.2                        Next or Previous Player Stats  

Displays the next ((ctl+ê/Page Down) or previous (ctl+é/Page Up)  player name in the roster. This command will traverse the Active and Expansion rosters. These commands will be dimmed out if there are less than two roster entries.

3.3.3                        Schedule (opt+S)

Displays the Game Schedule page. shift+opt+S refreshes the schedule before display.

3.3.4                        Summary Statistics (HOME)

Displays the Summary Statistics page.

3.3.5                        Batting Leaders (opt+L or cmd+HOME)

Displays the Batting Leaders page.

3.3.6                        Team Batting Summary (opt+B or opt+HOME)

Displays the Team Batting Summary page.

3.3.7                        User Notes Area (opt+N or cmd+opt+HOME)

This is a separate area of the team worksheet reserved for user notes. See Section 2 for more details on the uses of this area.

3.3.8                        Box Score…

Recalls a specific line score or line score/box score for the available games.

3.3.9                        Next/Previous Box Score (opt+ê)

Displays the next or previous available line score or line score/box score depending on the General Preferences / Box Score Game Sort Order setting (Section 4).

3.3.10                    Formula Bar  (opt+cmd+F)

In addition to in-cell editing, the standard Excel Formula Bar can be activated for editing of non-protected cells on the Team Worksheet.

 

This control is not available via the SBC menus or toolbar when running under Excel/2011 on the Mac.

Use the  fx tool  tool icon in the Excel Ribbon area instead.

3.3.11                    Import Summary

Recalls the processing summary from the previous stats, schedule or roster import command operation.

3.3.12                    One Step Web Site Summary

Recalls the processing summary from the previous One Step Web Site command (Section 9).

3.3.13                    Expanded Commands (cmd+E)

When checked, this command invokes an enhanced set of features for the power user (Sections 11-16). When unchecked, the Basic Command Set mode is enabled. This latter set of commands is usually sufficient for the majority of users.

3.3.14                    Informational Messages

Controls the display of messages that are not considered critical errors or warnings (Section 10). It is recommended to keep this option checked until the user is familiar with the operation of the SBC.

3.3.15                    Gridlines and Headings (cmd+opt+G)

When active, the Gridlines And Headings option activates the display of a gridline around the cells plus the row and column headings identifiers. This can be helpful when reformatting or modifying cells on the team worksheet. The gridlines and headings will not be visible on web pages. They can be made visible on printed pages depending on the Page Setup settings (Section 8).

-------

3.3.15                    Pending Notifications

Displays any pending notifications of issues that may need to be addressed (eg: Stats validation errors from importing) (Section 2.3.7).

3.4                              Calculate Menu

Figure 3-7  Calculate Menu

3.4.1                        Analyze Schedule

This command will inspect the Game Schedule for possible inconsitencies such as duplicate game numbers, duplicate entires with same date and times, etc. This function is automatically invoked whenever changes are made to the schedule but is included here and on the SBC Toolbar for convenience.

3.4.2                        Batting Leaders (opt+cmd+L)

Recalculates the team batting leaders in up to 19 selectable categories (Section 6).

 

3.4.3                        Box Score (opt+cmd+B)

This command generates a box score for a selected game number. (Section 7).

3.4.4                        Division Standings (opt+cmd+K)

Recalculates the division standings and locks the team names area (Section 5).

3.5                              Player Menu

player basic

Figure 3-8  Player Menu

These commands are used for creating and maintaining the roster entries and to update individual player batting statistics (Section 6).  The Merge Player Stats command is available in Expanded Commands mode . The Check Rosters and Validate Player Stats commands are used by the Import Stats (Sections 15, 16) and Import Roster (Section 17) features. The remaining dimmed and commands are used only in Multi-Season Mode (Section 15).

3.6                              Window Menu

Similar to standard Excel Window menu except that the functionality is limited to switching windows by window name when multiple documents are open.  This menu does not appear when running under versions of Excel with the Ribbon UI on Windows platforms. The standard Excel keyboard shortcut (cmd/F6) can be used to display the next active window.

3.7                              SBC Help

Screen Shot 2017-12-26 at 9

Figure 3-9  SBC Help Menu

The commands in this menu provide assistance for the SBC.

 

On-Line Help for basic Excel functions is available via the Excel Help command or under the Help menu on some versions of Excel. This function is not supported on some Windows versions of Excel. Alternatively, click on the “question mark” icon or use the commands in the Help menu.

3.7.1                        SBC Support

Opens a web page in the default system web browser with  SBC support notes and contact information. Requires active internet connection.

3.7.2                        SBC On-Line User Manual

Opens the SBC User Manual as a web page in the default system web browser. Requires active internet connection.

3.7.3                        SBC Revision History

Displays  enhancements and bug fixes for the current version plus known errata and limitations. History for previous versions can be viewed at the SBC web site at: http://www.sbc.aces-softball.com.  Requires active internet connection.

3.7.4                        Donate To SBC Development

Opens a web page in the default system web browser with instructions to make a donation (always appreciated J) for on-going SBC support and future development.  Requires active internet connection. Donations can be made via PayPal.

3.7.5                        SBC Keyboard Shortcuts

The following keyboard shortcuts are available for selected SBC commands. The mappings have been chosen to avoid conflicts with common Excel shortcuts. In the Apple Macintosh environment, cmd is the =9 height=11 id="Picture102" src="images/image097.png" alt="Mac_cmd"> key and the opt key is the option key. In the Windows environment, cmd is the control key and the opt key is the alt key.

 

This command as well as the HELP key (or cmd+opt+?) will display the keyboard shortcuts. The display is customized based on the current operating environment (Windows or Mac).

 

Command

Shortcut

Add Player

cmd+opt+A

Display Next Player Stats Area

ctl+ê or  PAGE DOWN

Display Previous Player Stats Area

ctl+é or PAGE UP

Display Expansion Roster Player Stats Area

END

Select Next Player Stats Area

Select Previous Player Stats Area

cmd+ê

cmd+é

Update Player Stats

cmd+opt+U

 

 

Display Summary Page

HOME  

Display Team Batting

opt+B  or  cmd+HOME

Display Batting Leaders

Display User Notes Page

Game Display Range

opt+L  or  opt+HOME

opt+K  or  cmd+opt+HOME

opt+R

Display Schedule and Results

opt+S (shift+opt+S refreshes schedule first)

Display Next/Previous Box Score

opt+ê

 

 

Calculate Batting Leaders

cmd+opt+L

Calculate Box Score

cmd+opt+B

Calculate Division Standings

cmd+opt+K

Edit Game Numbers

cmd+opt+N

Edit Schedule

cmd+opt+S

One Step Web Site

cmd+opt+W

 

 

Switch: Basic<>Extended Command Set

cmd+E

Show/Hide Formula Bar

cmd+opt+F

Show/Hide Gridlines and Headings

cmd+opt+G

Edit Custom Hyperlink

cmd+opt+H

Print Selection

cmd+opt+P

Repeat Previous SBC Command

cmd+opt+Y

Display Keyboard Shortcuts

HELP   or   cmd+opt+?

Quit SBC

cmd+opt+Q

Table 3-1  Keyboard Shortcuts

 

Return to Table of Contents


 

4                    USER CONFIGURABLE OPTIONS – BASIC COMMAND SET

4.1                              General Preferences Command

000200

Figure 4-1  General Preferences Dialog in Single Season Mode

Allows selection of the following parameters:

4.1.1                        Identity Settings

4.1.1.1                  Team Name 

This parameter is used to identify your main Team Name. A dropdown selection list displays the available team names extracted from the division standings area of the team worksheet. If you do not see a list of names, this indicates that the team names in the Division Standings have not been configured. A minimum of one team must be entered in the Division Standings.

4.1.1.2                  Stats File Description

This field is used to provide a unique identifier for the statistics contained in this team worksheet. Traditionally, the calendar year associated with the stats is entered. However, it can be any non-blank text value such as playoffs, tournaments, etc.  This field is used during stats importing with other team worksheets in Multi-Season Mode.

4.1.2                        Expansion Roster Settings

4.1.2.1                  Expansion Roster Label

This parameter controls the label that is shown for this player category. It can be any non-blank text value.

4.1.2.2                  Sort Expansion Roster 

In Single Season Mode, the user has a choice of sorting the Expansion roster player stats by game number first or by player name first. In Multi-Season Mode, the choices are by season or player name.

4.1.3                        Stats Tracking Options

4.1.3.1                  Track Slow-Pitch Stats Only

When checked, SB, SACB, HBP stats are not tracked.  

 

When the SBC is switched from full stats tracking to Track Slow-Pitch Stats Only mode, statistics that are not applicable to slow-pitch softball will be cleared. This is to prevent erroneous calculations of average, on-base pct., slugging pct., and on-base plus slugging pct. As this is an un-doable action, the user will be warned prior to performing this. In addition, the user will be alerted to the fact that the box score and/or batting leaders may need to be re-calculated.  This mode affects these catergories in team batting summary, individual player stats, batting leaders, box scores, printed pages and web sites.

4.1.3.2                  Track Fines

This command controls the display of the optional Fines category in team batting summary, individual player stats, batting leaders, printed pages and web sites. When checked, Fines statistics are displayed. When unchecked, Fines statistics are not displayed. Disabling the Fines category does not delete any player Fines entries.

4.1.3.3                  Enable GBL Display

This option controls the display of the Games Behind Leader (GBL) in the Division Standings. If you are using the Auto-Update of Division Standings option, then GBL is of dubious value when tracking WLT records against the Main Team. Thus, you should disable this option.

4.1.4                        Schedule Page Options

See Section 5 for more details on the use of these options. These options are only active in Single Season Mode.

4.1.5                        Box Score Controls

4.1.5.1                  Box Score Games Sort Order

This controls the sequential display of box scores by game number during the Calculate Box Score command, Display Next/Previous Box Score command, and for web and printed pages, The options are: ascending or decending.

4.1.5.2                  Completed Games Only (Print, Web)

If checked, only games that have stats, a line score or both will be shown on the Box Score pages. If un-checked, all games will be processed.

4.1.6                        Miscellaneous Settings

4.1.6.1                  Include User Notes for Printing

When enabled, the area assigned for User Notes will be printed after the Team Summary and Leaders pages.

4.1.6.2                  Include Masthead Banners for Printing

When checked, the masthead which appears over the top of each page will be printed. When unchecked, it will be supressed. This can save on printer ink.

4.1.6.3                  Source File Filtering

On older versions of Excel on the Mac (eg: Excel 2004 and earlier), the source file filtering does not always allow all file types to be allowed for import operations (Stats, Rosters, Schedules). If this happens, uncheck the Source File Filtering option. This option is always enabled on the Windows versions of Excel.

4.1.6.4                  Shade Stats Category Titles

When checked, the Shade Fill Color will be applied to all category titles. This will be visible on the screen as well as on printed and web pages. This can be disabled as desired to save on printer ink.

4.1.6.5                  Default Text Color

This option allows global modification of the primary text color.  This color wil be reflected on the screen as well as on printed and web pages.  Individual cells can override this setting as desired.

4.2                              Statistics Display Ranges

The content of the batting summary and individual player statistics areas is selected by the game range via the Edit / Game Display Range (opt+cmd+R) command.  When this command is invoked, the default game range will be set to the maximum game range found in the individual batting statistics area:

 

game display range

Figure 4-2  Game Display Range Selection Dialog

The user may choose to alter this range to view a subset of the total games statistics.  This can be useful to view a set of games that are from a tournament. A separate web site or printed results could be generated. Banners over selected areas of the Team Worksheet could be modified as well. A single game may be selected by setting the Start and End range to the same value.

 

The user may choose to update the batting leaders at the same time by checking the Update Leaders. The update will use the same game range. If a different range is desired, leave this box unchecked and run the Calculate / Batting Leaders command separately.

 

The user may choose to update the box score at the same time by checking Update Box Score. The update will use the End value of the game range. If a different game is desired, leave this box unchecked and run the Calculate / Box Score command separately.

 

Updating the Box Score will result in the correct box score for the selected game number.

 

When this command is executed, an analysis of the selected range will be performed versus the maximum game number, current leader board game selection range, and box score game selection and number of games played by the main Team Name. Any discrepancies will be reported. This is for informational purposes and not considered an error. Entering a blank or 0 value for either game number will invoke this analysis without changing the display range or performing either the leaders or box score updating.

 

The Division Standings display is independent of this setting. In addition, player statistics updating can be performed on the entire statistics data set, regardless of this setting.

4.2.1                        Game Range Display Conventions

The current game range is shown at:

 

·         Message bar display

·         Totals line the Team Batting Summary. This value always reflects total number of games in the selection range.

 

The conventions for the game number are as follows where max is the highest number of unique games found in the individual batting statistics area, schedule or the total number of games played by the home team (from Division Standings). The current range or subrange will be shown in the Message Bar area of the window as:

 

Game range from 1-max:max
Subset of games:Game Start-End Stats Only
Single game selection where Start=End:Game Start Stats Only
Games in schedule but no stats entries:No Stats
No schedule entries:No Games

 

The resulting game number in the Team Summary, Batting Leaders and Batting Leaders Summary may be edited or blanked out as desired.

4.3                              User Alterable Cells

Certain cells on the team worksheet may be customized. The View / Gridlines and Headings command may be useful when performing these operations.

4.3.1                        Team Summary Area

Use the Display / Summary Statistics command to navigate to this area:

 

 

Page1 annotated

Figure 4-3  Team Summary Page Layout

The user may alter certain cells directly:

  

·         Masthead (header) area banner test

·         Masthead area graphics (Expanded Command Set Mode only)

·         Title over division standings

·         Date over division standings 

·         Individual team names in the division standings plus applicable wins, losses and ties

·         Title lines and game number over the box score and batting leaders summary areas

·         Additional lines under the box score line score area

 

The header area from the Team Summary is used as the header for the first printed page.  It is also used as the masthead area for all web pages. The user can propagate these changes to the other masthead banners via the Edit / Update Masthead Banners command.

 

The banner above the division standings (“Division Standings As Of:”), box score (“Box Score For Game:”), and leader summary (“Top Leaders Thru Game:”) areas may be modified as desired. This might be case at the end of the season. The dates and game numbers next to the banners could be blanked out if desired as well.

 

The SBC will check to see if any of these label areas are blank at startup and when the applicable Calculate command is invoked. If this is the case, the default banners for the areas will be regenerated.

4.3.2                        Team Batting Summary Area

Screen shot 2014-09-28 at 10

Figure 4-4  Batting Summary Page Layout

Use the Display / Batting Leaders command to navigate to this area. The gridlines have been activated and areas of interest have been highlighted.

 

The header area above the team batting summary is separate from the header areas above the team summary and batting leaders areas and is used only on printed pages for the team batting summary, leaders, and individual player statistics pages. It is not used on web pages.

 

The banner above the team batting summary (“Team Batting Statistics”) may be altered as desired. For example, at the end of the season, you might want to change this to “Final Season Statistics”.

4.3.3                        Batting Leaders Area

This area is the result of calculation of the team batting leaders and contains the top players in selected batting categories. Use the Display / Team Batting Stats command to navigate to this area.

 

The user can select the categories of interest as well as control the number of leaders displayed and the range of games (Section 6).

 

The header area above the batting leaders is separate from the header areas above the team summary and team batting areas and is used only on printed pages for the team batting summary, leaders, and individual player statistics pages. It is not used on web pages.

 

The banner above the batting leaders (“Batting Leaders Thru Game:”) may be altered as desired. For example, at the end of the season, you might change this to “Final 2011 Batting Leaders”.  The SBC will check to see if this label area is blank at startup. If this is the case, the default banner will be regenerated. The game number next to the banner could be blanked out if desired as well.

 

leaders annotated

Figure 4-5  Batting Leaders Page Layout

4.3.4                        User Notes Area

The user may reformat the text in this area as desired using the Format Text tool in the SBC Toolbar. 

 

The area can be selectively cleared or reformatted by using the Edit / Format User Notes Area command.

 

The user can optionally include this area as a separate web page during the One Step Web Site generation. The title of the navigation link can be modified as desired. If the content is tabular in nature, Zebra striping may be applied for better readability on web pages. See Section 9 for more details.

4.3.5                        Game Schedule Page

Screen shot 2016-03-16 at 3

Figure 4-6  Game Schedule Page Layout

The banners above the table in cells GO6 and GO7 may be altered as desired. The cells in the Game column (GO9 and below) are unlocked as well. The General Preferences command has an option to toggle the display of games numbers . All others are locked.

4.4                              Formatting Changes in Basic Command Set Mode

In this mode, the user can make some basic text formatting changes to the team worksheet.  

 

The primary color for the text can be changed by the Default Text Color option. Formats of individual cells can be modified. Select the cell(s) of interest. If you wish to make other global changes to all text on the team worksheet (except the header areas), click on the Select All tool first. Then click on the Format Text, Number, Alignment, Borders or Fills and Patterns tool in the SBC Toolbar. A dialog box will appear with the various attribute modifications that can be made. The contents of the team worksheet are modified as desired. The Extended Command Set has a more extensive set of formatting capabilities for the power user (Section 12).

 

The Borders, Alignment and Patterns tools are not available when running the SBC on the Mac versions of Excel

prior to version 2011.

4.4.1                        Cell Border Mapping

4.4.1.1                  Screen and Printed Pages

There are a large number of potential border styles that can be applied to a cell via the formatting commands and tools. Any of these styles can be used for screen viewing and printed pages.

4.4.1.2                  Border Mapping for Web Pages

It is only possible to map the four perimeter cell borders. Any of the more esoteric styles (e.g.: 45º, center cell lines) do not have a comparable web style and, therefore, will be ignored. Each of the four cell borders can be mapped separately with style and color.  Adjacent cells with borders are mapped into a single border.

 

The CSS styles define four possible border styles: solid, double, dotted and dashed. Thus, it is not possible to map every Excel border style to an equivalent web page border style. Table 4-1 shows the available mapping of Excel border styles to the equivalent CSS style. Styles mapped to the closeset CSS style are marked with an asterisk:

 

 

Excel Style

Web Style Mapping

excel border styles

thin solid

1px solid

hairline

1px dotted

thin dotted

1px dotted

thin dash

1px dashed

thin dot-dash

1px dashed*

thin dot-dot-dash

1px dashed*

thin double

2px double*

medium solid

2px solid

medium dash

2px dashed

medium dot-dash

2px dashed*

medium dot-dot-dash

2px dashed*

medium hashed

2px dashed*

thick solid

3px solid

Table 4-1  Cell Border Style Mapping

4.4.2                        Align Text

The Align Text =12 height=12 id="Picture111" src="images/image110.png"> tool provides for basic changes for in text alignment within a cell or group of cells.  These include left, center, right and justify. As this tool includes cell merge and center across columns capabilities, it must be limited to cells within the User Notes area of the Team Worksheet. Otherwise, unprodictable web pages will result.

 

Some of the more esoteric alignment styles such as text rotation, vertical text display, etc. will not be reflected on web pages.

4.4.3                        Fills and  Patterns

The Fills and Patterns =11 height=13 id="Picture112" src="images/image111.png"> tool provides both foreground and background color and pattern fill control. As there is no equivilent web page style for patterns, they will be not be reflected on web pages. The pattern fills will be reflected on the screen and on printed pages.

 

 

Return to Table of Contents


5                    DIVISION STANDINGS AND GAME SCHEDULE MANAGER

5.1                              Division Standings

This section describes the operations to configure and maintain the team and division standings. The user may choose to bypass tracking of division standings. However, a minimum entry of your team name in this area is required as it is used in other functions.  This will be refererred to as the main Team Name via the General Preferences command. The user interface is streamlined to minimize the number of operations required. A large number of teams can be entered to accommodate for inter-divisional or tournament teams.

 

The Division Standings is maintained manually if the standings are used to track all WLT records of all teams. The standings can be automatically derrived from the schedule results if the user is just tracking WLT records against the Main Team. This can be involked via the General Preferences / Auto Update Division Standings option.

 

A snapshot of the division standings area is shown:

Page1 div stgs

Figure 5-1 – Division Standings Display / Data Entry Area

The gridlines have been activated and areas of interest have been highlighted.

5.1.1                        Changing The Division Name

1.       Go to the division standings area of the worksheet via the Display / Division Standings command.

2.       Move the cursor to the title cell area over the division standings and enter the appropriate title for your league/division. Note that the cell immediately following is automatically updated with the standings date when the division standings are calculated.

 

The banner above the division standings (“Division Standings As Of:”) area may be modified as desired. The SBC will check to see if this label is blank at startup. If this is the case, the default banner for the area will be regenerated.

 

For example, you may want a title such as:  "Over The Hill Division Standings as of:” during the season. At the end of the season, you may wish to change the title to something like:  "Final Over The Hill Division Standings".  The date cell may be altered or blanked out as desired.

5.1.2                        Entering Team Names

1.       Uncheck the Edit /Division Team Names Locked command.

2.       The area for team names in the division standings will be highlighted and a set of numerical markers will appear as an assist.  If a main Team Name has previously been selected, it will be highlighted in bold text.

3.       Enter each of the names of the teams in your division in any order, one team name per slot, up to the maximum defined in Section 1. A team name can be a text, alphanumeric or purely numeric value. As each team name is entered, the Pct. and GBL entries in the row will be activated.  

4.       Run the Calculate / Division Standings command or Recheck the Edit /Division Team Names Locked command.

5.       The team names will be sorted automatically by standings.

6.       The team names area will be re-locked to prevent inadvertent changes and the numerical assist markers turned off.

5.1.3                        Automatic Entry of Team Names

The Import Schedule command has an option to add new team names to the Division. This can be useful to populate the Division at the beginning of the season or whenever the schedule is imported. If active, the Auto Update Division Standings option will populate the team names from the Game Schedule.

5.1.4                        Selecting The Main Team Name

NOTE:

The main Team Name is utilized exensively so it is important to set this parameter.

This selection should be made before any other operations (eg: Schedule entries) are performed.

 

1.       Go to the Edit / General Preferences command.

2.       Select your team from the Team Name dropdown list of team names.

 

The main Team Name will be highlighted in the Division Standings.

5.1.4.1                  Renaming The Main Team Name

Renaming the main Team Name after the team matchups in the Schedule have been entered can be performed as long as the new main Team Name does not match an existing team name in the standings. To perform this operation:

 

1.       Uncheck the Edit / Division Team Names Locked command.

2.       Edit the existing main Team Name.

3.       Go to Edit / General Preferences.

4.       Select your team from the Team Name dropdown list of team names.

 

The main Team Name will be updated in the matchups in the Game Schedule.

5.1.5                        Division Standings Maintenance

5.1.5.1                  Team Name Modifications

If it becomes necessary to remove or rename a team in the division standings, perform the following steps:

 

1.       Show the division standings area of the worksheet via the Display / Division Standings command.

2.       Go to the Edit menu. Uncheck the Lock Division Team Names command.

3.       The area for team names will be highlighted and a set of numerical markers will appear as an assist (Figure 5-1). The Games Behind Leaders (GBL) will be inactivated.

4.       Rename or remove the desired team name(s) in the division standings area.

5.       Run the Calculate / Division Standings command.

6.       Won/loss/ties values for teams that were removed will be deleted.

7.       The numerical assist markers will be turned off. The team names area will be locked to prevent inadvertent changes.

8.       The Games Behind Leaders (GBL) values for each team will be recalculated and displayed if Enable GBL Display  is enabled.

9.       If the team name that was removed or renamed is the main Team Name, re-select a new main Team Name via the Edit / General Preferences.

5.1.5.2                  Purging All Team Names

The entire set of team names can be removed via the Calculate / Division Standings command and checking the Purge Team Names option. Note that the main Team Name will be preserved. This can be useful when your team has moved to a new division, or for a tournament.

 

After the purge, the user will be prompted whether to purge the game entries in the Game Schedule.

5.1.5.3                  Purging All W/L/T Records

All W/L/T records for all teams can be purged via the Calculate / Division Standings command by checking the Purge W/L/T Records option.  This can be useful at the beginning of the season or at the start of a tournament.

 

After the purge, the user will be prompted to purge the results in the Game Schedule.

 

WARNING:

The Purge Team Names and Purge W/L/T Records options are not undo-able !!!

5.1.6                        Updating Division Standings

1.       Show the division standings area by running the Display / Division Standings command.

2.       Update the wins, losses, and ties as required for each team (Figure 5-1).

3.       Run the Calculate / Division Standings command.

4.       You will be prompted for the standings date (default is today's date) and other options.

 

The displayed date may be changed manually or, as might be the case at the end of the season, blanked out.

5.1.6.1                  Automatic Updating of Division Standings

In Single Season Mode, the user can choose to automatically recompute the Division Standings from the scores that have been entered into the Game Schedule. This is useful when just tracking the results of the other teams in the division to your team (head-to-head match-ups).

 

When this mode is active, you may wish to turn off the GBL display as the GBL has limited value when this mode is active.

 

Turn this option off if you wish to enter the W/L/T values and compute the Division Standings manually.

 

standings update

Figure 5-2 – Division Standings Options Dialog

5.1.6.2                  Processing Options

Highlight Main Team Name

If a main Team Name has been selected via the Edit / General Preferences command, it will be shown in bold text.

 

Purge Team Names

Purges all team names and WLT records. The Main Team name will remain.

 

Purge W/L/T Records

All WLT results are set to 0-0-0 for all teams.

5.1.6.3                  Division Standings Calculations

Division standings are calculated and then sorted using the following rules for tiebreakers (as required):

 

1.       Highest winning percentage

2.       Most Wins

3.       Most Ties

4.       Fewest Losses

5.       Team Name

 

Winning (WP) percentage is calculated as:

 

WP = (Wins +  (Ties/2)) / (Wins + Losses + Ties)

 

Games Behind Leader (GBL) is calculated relative to the first place team (highest WP) as:

 

+1/2 point  for a win + 1/4 point for a tie -1/2 point for a loss

 

The GBL values are updated when the division standings are recalculated.

 

5.2                              Game Schedule Manager

NOTE:

This capability is not active in Multi-Season Mode (Section 15) as individual game by game statistics are combined into composite season statistics.

 

The SBC maintains identifying information for individual games.  A separate Game Schedule page is generated (Figure 2-10).  The Display / Schedule command can be used to view the current Schedule. Games are displayed in ascending order by Game Number. Schedule information can be entered from an external schedule file  or manually.

 

A blank entry with identifying Game number will appear for games that have player stats but do not have attribute information or a line score. The Status field will be marked with Stats Only. The Game number display can be supressed as desired.

The contents of the schedule page are automatically generated. There are five lines above the column headers that can be used for user-defined information.

5.2.1                        Game Schedule Attributes

For each game, the following attributes are maintained:

 

1.       Game Number

2.       Home Team Name

3.       Visiting Team Name

4.       Date

5.       Time

6.       Field

7.       Status (optional)

 

The Status field is optional and can be used for additional identifying information for the game. Examples might be to flag a game as cancelled, rained out, postponed, tournament info, highlights, etc.

5.2.2                        Importing a Game Schedule

A game schedule may be imported into a Team Worksheet via the File / Import Schedule command or tool Screen shot 2016-04-05 at 2.  This command is available as long as the main Team Name has been selected from the General Preferences options. The file can be either an Excel .xls, .xlsx worksheet or a comma-separated variables .csv file.

 

The supported file formats are:

 

·         SBC

·         General

5.2.2.1                  Schedule File Format - SBC

 

Screen shot 2015-09-01 at 2

Figure 5-3 – Schedule Import File Format With Opponents - SBC

Three game entries are shown for simplicity.

 

The first line of the file identifies the file as an SBC formatted schedule file with the entry SBC Schedule in cell A1.  The Title1 and Title2 lines contain optional identifying information in cells B2 and B3 respectively for the schedule and will be placed on on the first two lines of the Schedule page if the Process Titles option is selected. If the B2 or B3 cell is blank, then the corresponding line on the Schedule page will be unchanged.

A header line (A4-F4) describes the cell locations of the attributes of each game. Subsequent lines describe individual game entries. The games can be in any order. A blank line entry (Example: Row 8) terminates the import process.

 

The rules for the game attributes are as follows:

 

Game                             Positive integer value identifying the game by number.

Date, Time, Field       Attributes that identify the game. These can be any value or blank.

Status                             Optional information about the game. This can be any value or blank.

Opponent                      This can be another division or non-division team. If the Opponent team is not known, leave the field blank. If this is an away game, annotate the game with a leading ‘at ‘ or “@” prefix before the Opponent team name.  

                                        NOTE: The Opponent team name cannot be the same as the Main Team name.

 

Alternatively, the matchups may be entered with the Visitor and Home teams.  Either the Visitor or Home team (but not both !) must be the main Team Name:

 

Screen shot 2016-03-25 at 11

Figure 5-4 – Schedule Import File Format With Visitor/Home - SBC

5.2.2.2                  Schedule File Format – General

A truncated schedule is shown for simplicity:

Screen shot 2016-03-15 at 4

Figure 5-5 – Schedule Import File Format – General

The General format is a flexible format that automatically detects the locations of the field identifiers.  Schedules can be created by a user with a text editor or Excel or via an export file from a third-party scheduling program.

 

A header line describes the ten possible cell locations of the field identifiers. Subsequent lines describe individual game entries.

 

Only the minimum field identifiers are necessary. Any others that may appear are ignored. The minimum required field identifiers are as follows:

 

·         Date                                                                                      

·         Time

·         Field or Location                                                              

 

Team matchups must be specified as well. The General format can accept one of two team matchup definition methods:

 

Visitor or Visiting Team

Home or Home Team                   One of these teams should be the main Team Name. If the matchups are not determined,

                                        leave the field(s) blank.

 

or:

 

Opponent                      This can be another division or non-division team. If this is an away game, annotate the game with a leading ‘at ‘ or ‘@‘ prefix.  If the Opponent team is not known, leave the field blank.

                                        NOTE: The Opponent team name cannot be the same as the Main Team name.

 

Game or Game #

The General formats allow for a Game number field but this is not required. If not specified, a sequential Game number will be assigned to each entry during the import process.

 

An optional Status or Notes field may be included. This can be any value or blank.

 

A blank line entry (Example: Row 7) terminates the import process.

 

NOTE:

If the import file type is .csv, entries cannot have a embedded commas (eg: MMM DD, YYYY).

5.2.2.3                  Import Processing Options

Invoking the Import Schedule command will prompt the user for processing options:

 

smi sbc   Screen shot 2016-03-25 at 11

Figure 5-6 – Schedule Import Processing Options

File Format:

Select the file format consistant with the source of your schedule.

 

Processing Modes:

Sync Games With Existing Schedule

This option will add any new games from the import file to the existing schedule.

 

Entries that match an existing game schedule entry will be overwritten if the team names match. Existing line score will be preserved. If the team names do not match, the user will be prompted for confirmation. If confirmed, the schedule information and will be overwritten and the line score will be cleared.

 

Append New Games Only

Only games from the file that do not exist in the schedule will be added. Matching games will be ignored.

 

Overwrite Existing Schedule

Any existing Game Schedule entries and associated line scores (if any) will be cleared. The user will be alerted to confirm this operation.

 

Processing Options:

Add New Teams to Division

Any new team names that do not exist in the Division will be added with a record of 0-0-0. This will only occur for processed schedule entries. This can be useful when setting up a new schedule to automatically populate the divison teams. The number of new teams added will be reported at the end of the import process.

 

Process Titles (SBC Format Only)  

Controls whether the Title1 and Title2 entries will be placed on the title lines of the Schedule page. If unchecked, the existing titles on the Schedule page remain unchanged.

 

Processing option settings will be preserved for subsequent recalls of the Import Schedule command.

5.2.2.4                  Import Processing File Validation

The importer will pre-scan the import file for basic formatting and data entry errors:

 

SBC Format:

1.       Cell A1: Missing SBC Schedule identifier

2.       Cell A2: Missing Title1 field identifier

3.       Cell A3: Missing Title2 field identifier

4.       Missing or incorrect labels in Cells A4-F4

5.       Game numbers that are not positive integer values

6.       Invalid team matchup names

7.       Duplicate game numbers

8.       Duplicate Date/Time combinations

 

 

General Format:

1.       Missing or incorrect labels in first row

2.       Invalid team matchup names

3.       Duplicate game numbers (if game numbers were specified)

4.       Duplicate Date/Time combinations

 

Any errors detected will be reported to the user with the source line where it occurred and a description. The schedule will not be updated.

5.2.2.5                  Import Processing Summary

At the end of the import process, a summary of the processing will be displayed:

 

sched import summary

Figure 5-7 – Schedule Import Processing Summary

This can be recalled by the Display / Import Summary command.

 

The Starting Schedule Size and Updated Schedule Size values reflect the number of games that have schedule entries. This may be less than the total number of active games if some game stats were entered without schedule information.

 

If the Add New Teams to Division option was enabled, a count of the number of new teams added to the Division is diplayed. If there was insufficient space in the Division to add all new teams, an asterisk will be shown next to the count. The user will be alerted to this condition. If this occurs, check the Opponent team names in the source schedule file and the resulting Division area to resolve.

 

 If the Add New Teams to Division option was disabled, the New Teams Added: will show as n.a.

5.2.2.6                  Modifying Imported Schedule Entries

After importing, an entry may be modified by using the Edit / Schedule command, cmd+opt+S,  or  toolbar button.  Any bulk changes can be made in the source schedule import file and re-imported.

 


The Game Numbers may be modified individually or as a group via the Edit / Game Numbers command or the    toolbar button.

5.2.3                        Managing Game Schedule Entries

The user can manually create a new entry or modify an existing entry via the Edit / Schedule command or  toolbar botton which will invoke the following dialog:

Screen shot 2016-03-16 at 3

Figure 5-9 – Edit Schedule Dialog

The dropdown Game list will show all available games. A game may have a schedule entry only, game stats only or both.  If there is a line Score for the game, it will be displayed. If not, n.a. will be shown. The current attributes for the game will be displayed.  If these are all blank, this indicates that there are player stats for this game but no schedule information.  A status line indicating No schedule entry for this game. Stats only. will appear as well.

 

Changing the game selection via the dropdown list will update the display.The Next and Previous buttons can be used as well to sequence through the game list.

5.2.3.1                  Modify An Existing Game Schedule Entry

The attributes for a specific game can be modified as desired.  Any line score or player stats associated with this game are unchanged. The use of the Status field is optional. Some common entries are contained in the dropdown list. Hit Add/Update to update:

 

Screen shot 2016-03-16 at 3

Figure 5-10 – Predefined Status Field Values

NOTE:

Use caution when modifying Opponent team or Home Game status for a game that has been played as it may have an impact on an existing line score for that game. The user will be warned if this condition exists.

5.2.3.2                  Adding A Game Schedule Entry

An entry for a new game which is not in the list can be added by modifying the Game field and associated attributes.  Hit Add/Update to add. The new Game number can be any unassigned positive integer value.  The Game Number Manager can be useful to resequence the game numbers especially if this new game is between existing games in the schedule.

5.2.3.3                  Deleting A Game Schedule Entry

The Delete Game function will remove the schedule entry for the selected game. This will also remove the line score associated with this game if one had been entered.  A check will be performed to see if there are player stats for this game. The user will be asked to verify this operation as it is un-doable.  This operation will not delete any player stats for this game. If desired, this can be performed by the Player / Delete All Player Stats By Game Range command.

5.2.3.4                  Clearing Dialog Box Attribute Fields

The Clear Attributes function will reset all of the fields in the dialog to blank entries.  The dialog box remains open.

5.2.3.5                  Deleting All Game Schedule Entries

The Delete All Games function will remove all game schedule and associated line score entries.  Use caution as this is an un-doable operation. The user will be prompted to confirm this operation. Optionally, the W/L/T records for all teams in the Division Standings can be cleared at this time.

5.2.3.6                  Deleting a Line Score

The Clear Score function will remove the line score entry for the selected game.  Use caution as this is an un-doable operation. The user will be prompted if the line score does not exist.

5.2.3.7                  Deleting All Line Scores

The Delete All Scores function will purge all available line scores. Game attribute information will remain unchanged. Use caution as this is an un-doable operation. The user will be prompted to confirm this operation. Optionally, the W/L/T records for all teams in the Division Standings can be cleared at this time.

5.2.3.8                  Impact on Box Score

If the selected game is the same as the current game displayed in the Box Score, the user will be prompted to update the attribute fields in the Box Score area. The Line Score (if any) will be unchanged.

5.2.4                        Schedule Processing Options

These options are selected via the General Preferences command.

5.2.4.1                  Display Game Numbers

When checked, the Game Numbers assigned to each game will be displayed in the first column.

 

If unchecked, these cells and the column title will be blanked out initially. As these cells are unprotected, the user may leave them blank or chose to put other information (eg: an arrow to indicate next game to be played). Subsequent schedule updates will not affect these cells.

 

Games will appear in ascending order by Game Number regardless of this setting.

5.2.4.2                  Auto-Update Division Standings

When checked, this option automatically recomputes the Division Standings from the scores that have been entered into the Game Schedule. The update will occur anytime there have been changes in the scores including when game(s) have been deleted. This is useful when just tracking the results of the other teams in the division to your team (head-to-head match-ups). 

 

Uncheck this option if you wish to enter the W/L/T values and compute the Division Standings manually.

5.2.4.3                  Mark Unplayed/Unreported Games

If checked, a schedule entry without a line score can be marked:

 

·            TBP (To Be Played)  -  If the game date is today or beyond

·            NR (Not Reported)  - If the game date has passed

 

A non-blank Status field entry (eg: Rainout) will override the marking.

5.2.4.4                  Highlight First Unplayed Game

When checked, the first game in the schedule that has not been played and not marked with a Status field entry (eg: Rainout) will be highlighted.  A Hightlight Color can be selected.

 

If there is space, this will be posted in the first empty slot in the Notices area on the Summary page. An example is:

 

Next Game: Thu Sep 20 9:20PM at Marvin vs. Misfits

 

The font and styling in the Notices block for this entry is unchanged. This entry will be removed from the Notices area if there are no unplayed games left.

5.2.4.5                  Include for Print and Web

This controls the inclusion of the Schedule page for both printing and web page. If you use a custom formatted schedule via the User Notes page or via a custom external link to a league web site., you may choose to disable this option. The internal schedule page will still be visible and active. Auto-update of division standings and display of game numbers are still functional.

5.2.5                        Schedule Analyzer

Any time the schedule has been modified, a verification will be performed for consistency. The following conditions will be reported:

·      Duplicate entries with the same Game Number

·      Games with stats entries but no Schedule entry

·      Schedule entries with the same Date and Time

·      Schedule entries without Date and Time

 

This analysis can also be performed manually by the Calculate / Analyze Schedule command or toolbar command.

5.3                              Game Number Manager

Each game is identified by a unique game number. Thus, it is possible for the game numbers to be out of sequence with the Date/Time values in the schedule. This can occur with an imported schedule or via manual modifications. 

 

The game numbers can be modified individually or as a group via the Edit  / Game Numbers command, cmd+opt+N,  or  =22 height=19 id="Picture134" src="images/image125.png"> toolbar button:

game number1

Figure 5-11 – Game Number Processing Options

Use of this command will modify the game number in the Game Schedule as well as the associated individual player stats (if any) as well.

 

The following processing options are available:

 

Renumber Selected Game

The game number from the selected game in the dropdown list of available games can be modified to a different number. The current schedule information (if any) will be shown for validation. The New Game Number cannot match an existing game.

 

Resequence All Games

This will re-assign a new number to all game number references sequentially starting wtith the Starting Game Number. The logical order of the games does not change. The Starting Game Number value can be any positive integer value. The Select Game Number dropdown list has no function.

 

Resequence All Games Sorted by Date/Time

This is the same as the Resequence All Games option except that the games are first re-ordered by Date/Time before the new game numbers are assigned. This option will be dimmed (inactive) if there are player stats entries for a game without a corresponding schdule entry as the results could be misleading.

5.4                              Schedule Exporter

The game schedule can be exported to a file for subsequent importing into popular Calendar apps. Each entry in the schedule will result in a unique calendar event:

 

Figure 5-12 – Calendar Event Example

The Game Number and team matchup will be shown as the event title. If the opponent team hasn’t been entered in the schedule, it will appear as TBD. The Location and game times will be shown if available as well. Times will be displayed based on the user’s local time setting. The game score (if available), and Status info will be shown as well (Figure 5-12 note example).

5.4.1                        vCalendar File Format (.ics)

This type is suitable for importing to most popular calendar apps. The generated file conforms to Version 2 of the  RFC5445 Internet Calendaring and Scheduling Core Object Specification. Most calendar apps such as Google Calendar, Outlook, Android, iOS and OS X Calendar, BusyCal and others recognize this format. The SBC avoids any calendar app-specific entensions to insure the best compatibility.

5.4.1.1                  Special Processing

Games that have been marked in the schedule with status field values: Canceled, Rainout or Postponed will be encoded as canceled. Most calendar apps will flag this to the user. For example, Apple Macintosh OS X or iOS calendar apps will display the title of the event with a strike-through the text. The example above would be displayed as:

 

Game 20: Aces at Nomads

 

 The note field will show the actual status (Canceled, Rainout or Postponed).

 

Games that do not have a starting time specified in the schedule will normally be shown in the calandar app as an All Day event. Games that have a starting time specified but where the Game Duration has been set to 0 will be be shown just with the starting time.

5.4.2                        Comma-Separated Variable File Format (.csv)

This is a tabular format for calendar apps that cannot accept the vCalendar format. It can be modified as desired with a text editor or other applications for use with other calendar apps. This format does not have the extent of features of the vCalendar format but is significantly easier to modify by the casual user.

 

An example of this file which has been imported into Excel is shown:

 

 Figure 5-13 – CSV Formatted File Example

This format conforms to the Google Calendar specification for .csv formatted calendars. Text fields will be quoted to accommodate entries that may have embedded commas.

5.4.3                        Procedure

Run the File / Export Schedule command. The schedule will be analyzed to insure that a calendar file can be created. A minimum of the game date must be specified. Any problems will be reported for correction.

 

The following processing options will be shown:

 

Figure 5-14 – Schedule Export Processing Options

File Format

Choose the desired file format type.

 

Game Duration

This parameter is used to compute the ending time for each calendar event. A dropdown list has common values. However, the use may enter any integer value greater than or equal to 0. This field cannot be blank.

 

Private

When unchecked, this option will mark all calendar events for the games as Public which allows viewing  by others that have permission to view the calendar. When checked, this option will mark all calendar events for the games as Private which prevents viewing  by others.

 

The following options apply only to the vCalendar format:

 

Name

A unique name for the schedule should be entered. Most calendar programs will detect this name and place the game events there. Some calendar apps will offer the user to choose an alternative calendar. This name can be any length but it is suggested that it be kept short as it will appear in the list of calendars in the users’ calendar app. This field cannot be blank.

 

 

 

Version

The calendar apps use this value to resolve instances where there may be more than one instance of the same event. The event with the highest version number will take precidence.

 

The first time you create a calendar, set this value to 0. Then, for subsequent updates, increment the value by 1. A dropdown list of common values is provided. This field cannot be blank.

 

Time Zone

Select the time zone from the available dropdown list of US time zones.

 

After options have been selected, a standard File Dialog box will appear for the file to be created. The file name and destination directory can be changed as desired.

 

Do not change the file suffix (.ics or .csv)

 

At the completion of processing, a summary will appear with the processing results.

5.4.4                        Transferring the File to a Calendar Application

After the file has been created, it can be imported into your calendar app. Most apps have an Import capability for this. It is strongly suggested that a unique calendar be used. This will aid in resolving any problems that might occur as the calendar can be simply deleted without affecting other personal calendar entries.

 

Most calendar apps that support the vCalendar format will detect the calendar Name (above) and ask to create a new calendar by that name if it does not already exist. If yours does not, create a unique calendar name before importing.

 

If you plan to re-issue schedule updates during the season, the new file can be re-imported into the same calendar. Each schedule entry creates a unique identifier based on Main Team Name, Season ID and Game Number. Most calendar apps will recognize the updates accordingly. If this causes problems, instruct your users to delete the calendar on their app prior to doing a new import.

 

If your calendar app supports subscription services, you may use that feature as an alternative to importing.

5.4.5                        Calendar Issues

The generated .ics files have been tested on a number of calendar apps. However, compatibility issues can still occur. Contact SBC support at support@sbc.aces-softball.com for assistance if you have problems.

 

 

Return to Table of Contents


 

 

6                    PLAYER BATTING STATISTICS

6.1                              Overview

All commands for these activities are located under the Player menu unless noted otherwise. Commands that are dimmed indicate the command cannot be executed. This might be the case if the rosters and/or player statistics are empty or for commands that are specific to Single-Season or Multi-Season modes only.

 

The SBC will dynamically increase or decrease the roster size(s) as required. This may take some time to perform depending on processor speed. The progress will be shown in the message bar.

 

Player batting statistics are tracked by individual player and summarized in the Team Batting Statistics. Formulae used in the calculations are defined by Major League Baseball (Section 2).

6.1.1                        Player Selection Dialog

All commands that request a player name and game number or just a player name utilize common dialogs:

 

name and game    =267 height=139 id="Picture141" src="images/image131.jpg" alt="name only">

Figure 6-1  Select Player Dialogs

Two buttons in the Player Group allow selection of a player from the Active or Expansion roster (“Substitutes” in the example). The button will be dimmed if no players exist in the respective group.

 

A player name from the group is selected from the alphabetical dropdown list of players followed by pressing the OK button. Alternatively, the next or previous player in the roster list can be selected by hitting the Next or the Prev button followed by pressing the OK button to perform the desired operation. These button will traverse both rosters. If a game number selection is not needed for the command, the game number box will not be present.

 

The Next and Prev buttons will be dimmed if there are less than two roster entries total.

 

For the Update Player Stats command, an indication of whether there are stats for the selected game will be shown. For all other player commands, the game count and plate appearences will be shown for this player. This is useful when performing roster maintenance operations. In Multi-Season mode, the count of the number of seasons will also be shown.

6.1.2                        Player Name Selection Preservation

Where applicable, the SBC will attempt to preserve the player name selection as the default for subsequent commands. Thus, an Add Player to Roster command could be followed immediately by an Update Player Stats command for the new player.  Repetitive operations can be performed by using the Edit / Repeat command (cmd+opt+Y) which will re-invoke the most recent SBC command.

6.1.3                        Game Number Parameter Limits

In general, when a game number parameter or range is requested during an SBC command dialog, the default game number(s) will be set to the current display range settings. This range is usually the full range of games where there are player stats. Where applicable, a subrange of values can entered.

 

The exception to these limits is the Player / Update Player Stats command that can operate on any game. The SBC does not impose a limit on the game numeric value or number of game entries per player.

 

The Player / Delete Player From Roster , Rename Player, Transfer Player Stats,  Merge Player Stats,  Delete Player Stats,  Delete Player Stats by Game Range, Delete All Player From Roster commands and the Format Text tool always operate on the full game range of player statistics.

6.2                              Setting Up and Maintaining the Team Roster

To minimize keystrokes, most roster maintenance commands (eg: Add Player) will prompt for a repeat of the same operation. In addition, the Edit / Repeat command (cmd+opt+Y) will re-invoke the most recent SBC command.

 

6.2.1                        Player Name Selection and Entry Rules

Whenever the SBC requires selection of a existing player name from one of the rosters, a dialog box will appear.

 

When a new or modified player name is requested (e.g.: Add Player, Rename Player, etc.), enter the desired name in the edit box. The name will be verified to insure that it is not one of the following:

 

·         Duplicate of an existing Active or Expansion roster name.

·         Reserved name (e.g.: the current name assigned to the Expansion Roster area.)

 

Player names can be in  firstname lastname  or  lastname, firstname  formatA single name is also acceptable.

 

The entries are not case sensitive. When a new player name is entered or modified, extraneous spaces and non-printable charatcers are removed. Names are automatically capitalized including the first character after a non-letter.

Examples:

dave smith is processed to: Dave Smith

dave smith (aa) is processed to: Dave Smith (Aa)

dave smith (12a) is processed to: Dave Smith (12A)

dave smith-jones is processed to: Dave Smith-Jones

dave o’neil is processed to: Dave O’Neil

 

To force capitalization within a name, use a / delimiter just prior to the letter.

For example, for the surname: MacNeil, enter in the form of: mac/neil.

 

To selectively override the proper name processing, use the \ delimeter just prior to the letter.

For example, to yield Dave (12a), enter in the form: dave (12\a).

 

To override the name processing for the entire entry, put a ! delimeter as the first character.

For example, the entry: !dave smith-jones (a/a) is processesd to: dave smith-jones (a/a) .

6.2.2                        Setting Up a New Player Roster

 To set up a brand new roster for the first time:

 

1.       Run the Delete All Players From Roster command to purge all roster names and their individual game batting stats from both rosters.

2.       Use the Add Player to Roster function to add each player to the Active or Expansion roster. If successful, the user will be prompted to add another player. When finished, hit the Cancel button.

 

The Active roster area will be re-sorted alphabetically at this time. The Expansion roster will be sorted by game number or alphabetically by name according to the setting in the General Preferences.

 

The rosters may be filled from an external file of player names via the Import Roster command (Section 17).

6.2.3                        Modifying an Existing Roster

6.2.3.1                  Adding a New Player to the Roster

Players can be added to the Active or Expansion rosters via the Add Player to Roster command.  The dialog box allows selection of either the Active or Expansion roster via the two buttons in the Player Group area. Chose the appropriate group, enter the new player name and hit OK. The player name will be verified that it doesn’t already exist in the Active or Expansion rosters and isn’t a reserved name.  If the operation was successful, the user will be prompted to add another player. When finished, hit the Cancel button.

6.2.3.2                  Modifying a Player Name in the Roster

If there is an error/misspelling/capitalization in a players’ name, use the Rename Player command. The player name will be verified that it isn’t a reserved name or doesn’t result in a duplicate entry in the Active or Expansion rosters. If successful, the user will be prompted to change another player name. When finished, hit the Cancel button.

6.2.3.3                  Removing a Player From the Roster

Use the Delete Player From Roster command. If successful and players remain in the roster, the user will be prompted to delete another player. When finished, hit the Cancel button.

 

After one of the above modifications is completed, a warning dialog may appear indicating that the leaders and/or the box score may be inaccurate. Run the Calculate / Batting Leaders and/or the Calculate / Box Score commands as required.

6.3                              Player Batting Statistics

All operations are performed via the Player / Update Player Stats command unless noted otherwise.

 

Entries can be performed/updated for any Active or Expansion roster player in any order and from any game in any order.

 

The SBC can track a full set of batting statistics or the subset of categories that are applicable to slow-pitch softball. This mode is controlled by the General Preferences / Track Slow Pitch Stats Only option.

6.3.1                        Entering Statistics From a Recent Game

To enter new statistics from a recently played game, the user transcribes the individual batting stats from the game scoresheet into the SBC. The sequence is as follows:

 


1.       Run the Player / Update Player Stats (opt+cmd+U) command or =15 height=23 id="Picture142" src="images/image132.png"> toolbar button. The user will be prompted first for the desired game number and player name. The initial game number will default to the current number of games played by the main Team Name.  Change the game number if necessary.

2.       The player name will default to the most recently used player name. A different player name may be selected from the dropdown list. Hit OK.

3.       The Player Stats Update dialog box will appear:

player update annotated

Figure 6-2  Player Stats Update Dialog

If stats were found for this player for the selected game, the dialog box drag bar will show Update Current Entry. If not, New Entry will be displayed.

4.       Transcribe the applicable stats from the game scoresheet into the corresponding fields of the dialog box. The dialog box has been constructed to streamline the data entry process. The sequence of entries mimics the sequence of statistics normally found in most baseball/softball game scorebooks.  Use the TAB key to traverse forward to the next field or Shift+TAB to the previous field.

5.       Hit the Update button. The entries will be validated for consistency. If they are OK, the stats will be updated for this player and the next player in alphabetical order in the group will be shown.

6.       Repeat steps 2-5 until all statistics have been entered for each player.

7.       Hit the Cancel button when all entries have been transcribed.

8.       Next, enter the Line Score for the game and create the Box Score.

9.       Finally, update the Division Standings.

6.3.2                        Options During Player Update Dialog

Four buttons and a check box in the dialog box control the next step in the updating session:

6.3.2.1                  Update

Entries in the update dialog box will be verified for consistency. The user will be alerted with specifics/ When the entries have been corrected, stats for this player will be transferred into the team worksheet. The stats for the next player in alphabetical sequence will be displayed.

6.3.2.2                  No Update

Any additions or changes to the stats for this player will be ignored. The stats for the next roster player in alphabetical sequence will be displayed.

6.3.2.3                  Clear

All entries in the dialog box will be cleared. The Played But Did Not Bat box will be unchecked. The dialog box remains open.

6.3.2.4                  Cancel

Same as No Update except that the user will be prompted for the next player name and/or game number.  Hitting Cancel again will exit the update session.

6.3.2.5                  Played But Did Not Bat

If the player participated in the game, but did not bat (i.e., a defensive substitution, pinch runner, runner to the package store), check the Played But Did Not Bat box. This will insure that the player gets credit for participation in the game. Only the player position field, runs scored, stolen bases and fines entries are allowed. Number of cases of beer are not tracked.

 

Checking this box will clear any existing entries in the dialog box. By un-checking the box, all statistics can be entered.

6.3.3                        Purging Game Stats

If the stats for this player were inadvertently entered (i.e.: stats were from a different player, wrong game number, player never actually played in this game, etc.), hit the Clear button. All stats will be cleared out for this player in this game and the Played But Did Not Bat box will be unchecked as well. Hit the Update button to make the purge effective.

6.3.4                        Updating Statistics From a Previous Game

Sometimes errors or omissions may have occurred when the transcribing the statistics from the game scoresheet into the SBC.  If it becomes necessary to update statistics previously entered for a player or enter missing statistics, perform the following steps:

 

1.       Run the Player / Update Player Stats command.

2.       Select the specific player name and the game number for the statistics that need to be changed.

3.       If there were entries for the player for the game specified, they will be shown in the Player Update Dialog Box. The dialog box drag bar will show Update Current Entry. If there were no stats for this game for this player, the entries will be all zeroes and the drag bar will show New Entry.

4.       Make the necessary corrections/additions to the statistics and hit the Update button.

5.       Repeat Steps 2-4 as required.

6.       Hit Cancel button to exit the update session and Cancel again to terminate the command.

6.3.5                        Notes on Player Statistics Updating

Statistics may be entered/modified from one or more games in any game or player order. After updating, the individual player statistics will be re-sorted by game number (Active Roster players). Expansion Roster entries are sorted optionally by game or player name as desired.

 

Legal at-bats (AB) will be calculated automatically from the number of plate appearances. If you do not track walks, sacrifices, sacrifice bunts, or hit-by-pitch stats, then the calculated at bats will equal the number of plate appearances.

 

By default, the SBC assumes the player did not play in the selected game if there are no plate appearances or the Played But Did Not Bat box is un-checked.

 

If the Track Slow Pitch Stats mode is active, the SB, SACB and HBP items will be dimmed.  If the Fines tracking mode is inactive, the Fines entry will be dimmed.

6.3.5.1                  Stats Entry Verification

After the Update button has been hit, the SBC will perform the following sanity checks on the entries:

 

·         Must be numeric

·         Total of hits, sacrifices, sacrifice bunts, walks, reached-on-errors, fielder’s choices, strikeouts and hit-by-pitch must be less than or equal to number of plate appearances

·         Number of runs scored must be less than or equal to plate appearances. (See exception – Played But Did Not Bat)

·         Number of extra base hits must be less than or equal to hits

 

If the entries are valid, they will be transferred into the team worksheet and the update dialog for the next player in alphabetical order for this game will be shown.

 

During the course of the season the Delete Player Stats by Game command can be used to clear out all/some of an individual player's stats by game range.  This is useful if it is determined that an individual's stats have so many errors that it would be less work to re-enter them from scratch, rather than correct the errors game by game.

6.3.6                        Optional Player Position Tracking

The user has the option of tracking the position played for each player on a game-by-game basis. The player update dialog has a Position edit/dropdown box to enter the player's position for the selected game. If stats for a new game are being entered, the SBC will suggest a position based on the most recently played game for this player. If none was found, the field will be blank.

The position abbreviations will appear in the individual player stats areas and in the box score area. New values can be entered in any of three different methods:

 

1.       Predefined positions via the dropdown menu list.

2.       A numeric value in the edit box.

3.       Manual entry of a user-defined value in the edit box.

6.3.6.1                  Player Postion Dropdown List

The dropdown menu list contains the standard scorebook positions P-C-1B-2B-3B-SS-LF-CF-RF-SF that can be selected via the menu or by their position number from 1-10.

 

An additional group of commonly recognized positions is also provided. The position can be selected via the dropdown menu, or by the relative position number in the menu.

 

Any numeric value entered in the edit box in the range of 1-18 will be converted to the equivalent abbreviation for the position. Any entry that does not match a predefined abbreviation or position number will be interpreted as a user-specified value. These could include the case where a player played multiple postions during a game (eg: LF-CF).

6.3.7                        Player Roster and Stats Maintenance

6.3.7.1                  Deleting Stats for Individual Player Name

To clear out all of the stats for a specific roster player, use the Delete Player Stats command. The player remains in the roster.

6.3.7.2                  Deleting Player Stats for a Specific Game

Use the Delete Player Stats By Game command. Select the desired player name. A dialog with the available games for this player will appear. Select the game stats to be deleted.  Hit the OK.

 

If there are no additional player stats for this game number, the user has the option to delete the line score for this game.

6.3.7.3                  Delete All Player Names and Stats From the Roster

To completely remove all entries (player names and stats) from both rosters, run the Delete All Players From Roster command. This will also clear any box score and line score calculations that might have been run previously.

6.3.7.4                  Delete All Player Stats by Game Range

This command invokes the dialog box:

clear by game range

Figure 6-3  Delete All Player Stats Dialog

It operates on all Active and Expansion roster players. The user has the choice of globally clearing all stats for all games or a selective game range clearing. By default, the entire game range of stats will be shown in the Start and End Game Range boxes. The player names remain in the rosters. This command will optionally clear any box score and line score calculations that might have been run previously.

 

Clear Entire Roster Stats

To delete all player stats from all games, simply hit the OK button. This is useful at the beginning of a new season or playoffs where the rosters are essentially intact.

 

Clear Selective Game Range Stats  

To delete all player stats selectively from a range of games, enter the desired range in the Start and End Game Range boxes.

 

Resequence Game Numbers Option  

This option is used when clearing selective game range statistics. It has no effect when performing a clear of all stats for all games.  Any box score and schedule entries will also be resequenced.

 

Consider the case where there were stats entries for games 1,2,3,4,5,6,7,8,9 with a game range of 3-5 selected:

 

Resequence Game Numbers box is unchecked:  The game numbers for the remaining stats will be unchanged. Thus, if a game range, then the remaining games would be unchanged at 1,2,6,8,9.

 

Resequence Game Numbers box is checked:  The game numbers outside the selected game range will be re-sequenced as follows:

Game numbers 1,2 stay unchanged as they are below the starting game threshold.

Game numbers 6,7,8,9 are beyond the end game threshold. They would be renumbered as 3,4,5,6 respectively.

 

The Edit Game Numbers command can also be used to adjust/resequence game numbers as well.

6.3.7.5                  Transfer Player Stats

This command allows the user to transfer a player and their statistics between the Active and Expansion roster areas. This mechanism is useful when a player moves from Active to Expansion roster status or vice-versa. 

 

After a transfer operation has completed, the user will be prompted for another player to be transferred. This speeds up roster cleanup, especially after importing operations.

6.3.7.6                  Merge Player Stats

This command (Expanded Commands Mode only) allows the user to combine the stats from two players into a single entry.

 

The stats from the first player will be merged with the stats from the second player. Then, the first player entry will be removed from the roster.  Before performing this operation, the user should examine the two player stats areas to insure that the merge operation will produce the desired results.

 

A prompt will occur for each player name. The players may be in the same or different rosters.

 

In Single Season Mode, any stats from identical game numbers will be merged into a single entry. Prior to the merge, the first and second player areas will be examined for matching game numbers in both areas. If this condition occurs, the user will be alerted to this condition and whether or not to continue. 

 

In Multi-Season Mode,  stats from each player will be merged based on matching Stats Year entries.

 

TIP:

In Multi-Season Mode, the Consolidate Expansion Roster command can be used to perform bulk merging based on a specific Stats Year or all stats years.

After a merge operation has completed, the user will be prompted for another player pair to be merged. This speeds up roster cleanup, especially after importing operations.

6.4                              Updating Team Batting Leaders

After the applicable batting statistics have been entered/updated, batting leaders in up to 19 categories can be automatically calculated via the Calculate / Batting Leaders command.

6.4.1                        Static Parameters For Batting Leader Calculations

Static parameters that effect the calculation of the leaders are in the Edit / Batting Leaders Preferences dialog:

 

leaders prefs dialog

Figure 6-4  Static Batting Leaders Preferences Dialog

The user has the option of overriding some of the limits when the Calculate / Batting Leaders command is run.

6.4.1.1                  Min At Bats or Appearances Per Game

The user may choose to use either AB or PA as a qualifier for the AVG, SLG, OBP and OPS leader categories. The parameter is multiplied by the number of games in the range to determine the total qualifying number of AB's or PA’s. This parameter can be any value greater than or equal to 0. Fractional values expressed in decimal notation are permitted.  The result will be rounded down to the nearest integer.

6.4.1.2                  Maximum Leaders

This parameter controls the number of players that will be shown in each batting leader category. This value must be less than or equal to the Maximum Leaders Plus Ties value.

6.4.1.3                  Maximum Leaders Plus Ties

This parameter controls the maximum number of leaders in a category the event of a tie for the final spot. This is an overflow area. This value must be less than or equal to 10 and greater than or equal to the Maximum Leaders value.

 

In some instances, this overflow area may be insufficient to report all the players who have tied for the final spot (common when there are a small number of AB’s or PA’s at the beginning of the season, or in a tournament). When this situation occurs, a count of the number of players that have the final spot will be reported.

 

This will be in the form:

                                                                                                                XX tied with YY

Selected categories with no entries display a value of  None…. This is common at the beginning of the season or in tournaments.

6.4.1.4                  Include Expansion Roster Players  

When enabled, statistics from players in this category are included in the batting leaders calculations. Their stats are subject to the same eligibility rules as for Active roster players. If a number of players stats have been been merged into a  single entry (eg: all substitutes for a season), you may wish to disable this option to prevent misleading leaders results.

This option can be changed as desired when the Batting Leaders are calculated.

6.4.1.5                  Leader Board Categories

This is an array of check boxes that allows the user to select which combination of leader categories will be displayed on the leader boards. Two check boxes (Select All and Deselect All) allow rapid selection or de-selection of all categories. Any combination of selections is valid. Check boxes that are dimmed are not valid for the current SBC tracking modes.

 

The enabled leader categories will be displayed in the following order:

 

1.       AVG (Batting Average)

2.       SLG (Slugging Percentage)

3.       OBP (On-base percentage)

4.       OPS (On-base plus slugging percentage)

5.       R (Runs)

6.       H  (Hits)

7.       RBI (Runs Batted In)

8.       2B (Doubles)

9.       3B (Triples)

10.    HR (Home Runs)

11.    FC (Fielder’s choice)

12.    ROE (Reached on Error)

13.    SF (Sacrifice Flies)

14.    SB (Stolen Bases)*

15.    BB (Bases on Balls / Walks)

16.    SO (Strikeouts)

17.    HBP (Hit by Pitch) *

18.    SACB (Sacrifice Bunts)*

19.    FINES **

                        *   Indicates category not available in Slow-Pitch Stats Tracking Mode.

                        ** Indicates category available when the Fines is enabled

 

A change to any of the Leader Board Categories from the current selections will result in a prompt to update the leader board. The user can chose to ignore this and update the leader board at a later time via the Calculate / Batting Leaders command.

6.4.2                        Calculating Batting Leaders

To perform this calculation:

1.       Run the Calculate / Batting Leaders (opt+cmd+L) command or =19 height=19 id="Picture146" src="images/image136.png"> toolbar button. A display of the current parameters will occur:

Screen Shot 2017-09-17 at 9

Figure 6-5  Batting Leader Parameters Dialog

2.       The Game Range will default to the current game display range.  Any sub-range may be entered.  Minimum AB or PA will be calculated based on this range.

3.       Modify any parameters as desired. Any changes are applied just for this calculation.

4.       Hit the OK button. The leaders will be automatically calculated in each of the selected categories.

6.4.2.1                  Runtime Parameter Overrides

By default, the current game display range is used for the calculations.  The Minimum Games and Minimum AB or PA values are automatically calculated based on the static settings in the Batting Leaders Preferences.  For reference, the parameter for Minimum PA or AB per Game  and number of completed games played are shown. Inclusion of Expansion Roster players can be changed.

 

The user may choose to override these values as desired.  Change the parameter value in the desired edit box and then hit the option button next to it to make the change effective and then hit OK. These changes are only valid for this leaders calculation run.

 

NOTE:

The Batting Leaders displays may be cleared by entering a Game Range of Start=0 and End=0.

6.4.3                        Leaders Summary Area

A calculation of the top leader in each selected batting category is also performed when the Calculate / Batting Leaders command is executed. Ties for first place in a category will be computed as well. This area can be viewed by the Display / Summary Statisics menu command:

Page1 leader summary

Figure 6-6  Leaders Summary / Data Entry Area

6.5                              Validating Player Statistics

During normal player stats entry and importing stats from an external file, player statistics are checked for consistency on a game-by-game basis.  This occurs only in Single Season Mode. The Validate Player Stats command can be used to rescan for any inconsistancies. A report of the number of player stats records evaluated will be displayed.

 

Screen shot 2015-12-09 at 2

Figure 6-7  Validate Player Statistics Summary – No Errors

If any inconsistancies are detected, a report of the total number detected and the first player and game number with an error will be displayed:

Screen shot 2015-12-09 at 10

Figure 6-8  Validate Player Statistics Summary – Errors Detected

The user has the option of repairing the error(s) at this point or deferring to a later run of the Validate Player Stats command.  Hitting the Repair button will report the specific error associated with each player record followed by the standard Player Update dialog box for the actual repair.  This sequence will be repeated until all detected errors have been resolved or the Cancel button has been pressed.

 

The Box Score, Batting Leaders, and One Step Web Site commands will also check for stats inconsistancies before proceeding.

 

Fixing the problems via the Validate Player Stats command does not back-annotate the changes

to the source of the errors if they were a result of importing from an external file.

 

In this case, it is usually preferable to fix the problems in the original source and then re-import the stats to the SBC. This way, the data sets are consistant and will not re-occur in the event that the same data is re-imported.

 

Return to Table of Contents

 


 

7                    BOX SCORES

A box score is a compilation of the inning-by-inning line score plus a batting statistics summary compiled from the participants of a game. The line score is entered manually for each game. Player stats are extracted automatically based on the game selection.

7.1                              Game Schedule Information

Normally, the Schedule Manager is used to maintain the schedule and attribute information as well as adding placeholders for new games. However, any changes to game information (attributes or line score) using the Box Score functions will be annotated into the master game schedule.

7.2                              Generating a Box Score

The Calculate / Box Score command is used for these operations:

 

box score annotated

Figure 7-1  Box Score / Data Entry Area

7.2.1                        Calculate Box Score Command Functions

7.2.1.1                  Add New Game

If this is the first time a box score is to be calculated for this game, run the Calculate / Box Score command. Select the game from the list. Click on the Recall button and hit OK.

 

If a schedule entry was previously entered for this game, the team names and schedule information will be recalled. If not, enter enter the team names, Date, Time and Field location as needed for this game in the Line Score area.  The use of the Status field is optional.

 

The team names are not case-sensitive. Either the Home or Away team entry must match the main Team Name. Warnings will be issued appropriately. The ability to enter a non-division name allows box scores for inter-divisional, tournament or playoff games.

 

Next, enter the inning-by-inning line scores.

 

The entries for runs in each inning can be any of the following:

 

  • Positive integer values
  • Blanks
  • Non-numeric (e.g:  x, -)

 

The blank entries allow for shortened games. A hyphen or X value might indicate an inning where the home team did not bat in the final inning(s). Only integer values are computed into the total runs scored. The total runs for each team are updated after each entry. The innings labels can be modified as desired. This might be the case if a game goes beyond 10 innings.

 

Finally, re-run the Calculate / Box Score command. Hit the Add/Update button followed by OK.

7.2.1.2                  Recall Previous Games

To recall the box score and schedule information for a previous game, run the Display / Box Score or Calculate / Box Score command. Select the desired game number. Hit the Recall button followed by OK.

 

The user can sequence through the stored line/box scores by using the Display / [Next][Previous] Box Score menu command.

7.2.1.3                  Update a Previous Game

If changes need to be made to the team names, line score, Date, Time, Field location or Status of a previously calculated game, recall the box score and make the changes. Rerun the Calculate / Box Score command. Hit the Add/Update button and then hit OK.

7.2.1.4                  Clear Line Score Display

This function will purge the home and visitor team line scores in the current display. This is useful when a new line score needs to be entered. The innings labels will be restored to the maximum number of innings. The box score, team names and game attributes (Date, Time, Field and Status) are not affected.

 

The stored line score for this game is not updated by this function. To update, run the Calculate / Box Score command. Hit the Add/Update button and then hit OK.

7.2.1.5                  Clear Box Score Display

This function will purge the stats area of the box score in the current display. This is useful if it is not desired to display the box score.  It does not delete any player stats associated with the selected game.

 

The line score and user definable areas of the box score display area (team names, Date, Time, Field and Status) are not affected.

7.2.2                        Calculate Box Score Processing Options

7.2.2.1                  Box Score Statistics Selections

The user has the option to select either AB or PA plus two selectable statistics of interest that will be displayed in the last two of the columns of the box score in this dialog. The available set of statistics is dependent on the setting of the Slow-Pitch Stats Tracking mode setting.

7.2.2.2                  Box Score Sort Order

If Player Name is chosen, the entries are sorted alphabetically by player name.

 

If Position is chosen, players with predefined positions will appear first followed by any user-defined positions.  

 

If player positions are not entered for the game, this option defaults to alphabetic sort by player name.

7.2.2.3                  Line Score Innings Labels Filtering

The Filter Innings Labels option determines how the innings labels will appear:

 

·   If the box is checked (default), the innings number labels will appear only when there is an entry for either team in an inning.

·   If the box is unchecked, all innings labels will appear.

 

After calculating the box score, the line score totals for each team will be placed after the last valid inning score entry.

7.2.3                        Box Score Command Processing

When the OK button is pressed, the following sequence occurs:

 

1.       Home and visitor team names are validated as teams in the division. One non-division team name is allowed.

2.       Home or Visitor team must be the main Team Name.

3.       The line score, date, time and field location are checked for a previous box score for the selected game. If there are differences, the user will be alerted to use the current values or revert to the previously saved values.

4.       The line score innings labels are processed.

5.       Stats for participating Active and Expansion roster stats are extracted for the selected game. This will include players with Played But Did Not Bat status for the game. Applicable entries can be displayed in alphabetical order or by position.

6.       Statistics totals for the selected game are calculated.

7.       Total runs scored for the main Team Name in the line score will be compared to the total from the individual player stats compilation. This can act as a crosscheck for possible stats and/or line score entry errors.

 

Any errors or inconsistencies will be reported to the user for reconciliation.

7.3                              Resolving Current vs. Saved Line Scores

When the Update function is run, the currently displayed line score, team names, date, time and location are checked against the stored versions for the selected game. If there are differences, the user will be prompted to use the stored version or the current version.

7.4                              Box Scores for Web Pages and Printed Reports

A compilation of all box scores can be included as part of the One Step Web Site processing (Section 9) or Print commands. Applicable options from the most recent Calculate Box Score command as well as the following options control the content.

7.4.1                        General Preferences Options

The applicable options are in the Box Score Summaries Results area (Figure 4-1).

 

The box scores are sorted by game number and can be displayed in Ascending or Decending order. Individual options for web pages and print control display/printing of all games or just Completed Games Only.

7.4.2                        One Step Web Site Options

In Basic Commands mode, the currently displayed game Box Score will be shown on the Home page as well as a separate page with all or just completed game Box scores.

 

In Expanded Commands mode, the Edit / One Step Web Site Preferences command allows the user to /include or remove the Box Score from the Home page display.

 

Return to Table of Contents


 

8                    PRINTING REPORTS

8.1                              General

Printed reports are available via the Print command in the File menu or the =13 height=16 id="Picture152" src="images/image142.png"> toolbar button.  The SBC will configure critical printing parameters.  The print parameters may be modified from the Page Setup or Properties functions in the Print dialog box. The most important settings relate to scaling and are shown in Figure 8-1 (Windows) and 8-2 (Mac OS X).   Altering these parameters may produce undesireable results.

 

print options - win

Figure 8-1  Printing Options – Windows OS

8.1.1                        Header/Banner Rows

The SBC worksheet is preconfigured with a primary header area on the Team Summary page. A unique header area is on top of the Team Summary page and is used for the Team Summary and individual player statistics pages. A third header area is on top of the Batting Leaders area. A fourth header area is on top of the User Notes area. As these are different areas of the team worksheet, any changes made to one header area are not automatically reflected in the other area.

 

By default, the header rows will not be printed as a banner on each page (saves ink J). Enable the Include Banner When Printing option under  the Edit / General Preferences command to include printing of the banners. 

 

 

print options - mac

Figure 8-2 Printing Options – Mac OSX

8.2                              Print Command

8.2.1                        File / Print (cmd+P)

This command will print the contents of the SBC team worksheet in the following sequence:

 

Group 1

1.       Team summary statistics / Home page

2.       *Schedule (if enabled from Edit / General Preferences option)

3.       Team batting leaders

4.       User Notes area (if enabled from Edit / General Preferences option)

Group 2

1.       Team batting summary

2.       Individual game-by-game stats for all Active Roster players (one page per player)

3.       Expansion Roster game-by-game stats (one page)

Group 3

1.       *Box scores

* Single Season mode only

 

A Print dialog will appear for each group.  Depending on the number of players in the rosters, Group 2 may result in more than one Print dialog.  Hit OK to print the group.

8.2.1.1                  Selective Printing Options

In the Print dialog, hitting the Cancel button will bypass printing for that group of pages. The user can continue to the next group or stop printing.

 

During the print dialog in each group, the user may select specific pages of the worksheet using the traditional print page range options. A manually selected print area may also be printed by using the File / Print Selection command.

 

The General Preferences / Completed Games Only (Print) option controls the content of the Box Score pages.  The Box Score Game Sort Order controls the display order.

 

If the  Display / Informational Messages option is checked, the SBC will inform the user if there are potential mismatches in one or more of the game selection parameters.  See Section 10 for more details.

8.2.2                        Print Preview

For each Print dialog that occurs, a Preview button will alllow the user to view the page prior to printing.

8.2.2.1                  Excel on the Macintosh

 The Preview will open up the native Preview application and switch that application to the foreground.  After viewing the preview, switch back to Excel to regain control of the SBC.

8.2.2.2                  Excel on Windows

The Preview will open the preview mode in the same window as the SBC. On most versions, there is a tab or set of controls for the preview mode functions. Once the Preview mode is terminated, control will be returned to the SBC.

 

If no controls are present in the preview window:

 

1.       Go to the Windows Task Bar

2.       right-click on the Excel icon

3.       Run the End Window or Close Window command to terminate the print preview and return control to the SBC.

8.3                              Printing Problems

The most common problems that arise can usually be solved by reviewing the basic print settings or by re-running the File / Default Page Setup command. 

8.3.1                        Small Print

If the text on the printed pages appears very small, this is usually due an incorrect printer resizing option which must be correctly manually. This is different that the Excel Print scaling factor in the Print dialog which should be set to Fit to 1 Page Wide.

 

The Fit to Pages Tall option must be left blank.

 

On Windows, this is the Resizing option which should be set to Actual Size.  On the Mac OSX, the Scale factor setting should be set to 100%.

 

Another option is to supress printing of the banners by unchecking the Include Banner When Printing option under  the Edit / General Preferences command. This also has the advantage using less printer ink.

 

 

Return to Table of Contents

 


 

9                    CREATING A BASIC WEB SITE

 

Web Top Level Hierarchy

Figure 9-1  One Step Web Site Structure

9.1                              Overview

The SBC can generate a totally integrated web site optimized for viewing on both desktop and mobile browsers.  SBC versions starting with 3.60 generate mobile-first,  Responsive Design web files that will dynamically adjust the layout and content based on the user’s device.  

NOTE

The web site pages do not contain ad-ware or hidden Internet tracking code.

All activity is soley a result of  the user’s navigation of the site.

 

A single File / One Step Web Site (opt+cmd+W) command or the  =16 height=16 id="Picture156" src="images/image146.png">toolbar item performs this task. The user does not need to know anything about web page authoring.  Figure 9-1 shows the file structure and pages generated.

 

Figures 9-2 and 9-3 show examples of the home pages as viewed on a desktop browser plus iPhone®, Samsung Galaxy® and Blackberry® mobile devices. A masthead comprising of the banner text above the team summary plus a hyperlinked navigation bar will be generated on the top of each page.  The page content for mobile devices is in a columnar structure for the reduced viewing area.

 

All generated web page files will reside in the same folder. Assuming that the user has access to a web hosting service from their Internet Service Provider or other source, all that is needed is the procedure to transfer the resulting files from your computer to the appropriate web server location. Then, inform your users of the link to the home page (See Figure 9-6). No app is needed to view the web site, only a browser.

9.1.1                        Browser Compatibility

Java is NOT used to display of the generated web pages.

However, Javascript must be enabled on the user’s browsers for proper viewing

and navigation of the generated web site pages.

 

The SBC generates efficient, standards-compliant HTML5 and CSS web pages. It does not make use of any browser-specific functionality. As a result the web pages appear similar on a variety of current browsers including Internet Explorer, Firefox, Mozilla/SeaMonkey Suite, Opera (full versions), Safari, Google Chrome, iPhone/iPad iOS Safari mobile, Andriod mobile, Blackberry and others. Minimalist browsers such as Opera Mini may not provide acceptable results.

9.1.2                        One Step Web Site Navigation

Each web page will contain a navigation bar under the masthead area. The default navigation bar contains basic navigation links for  home, box scores, stats,  and leaders. The active web page will have its’ navigation link highlighted. When viewed on a desktop browser the navigation bar and tabs are always visible in a horizontal row.

 

When viewed on a handheld/mobile device, the navigation bar is initially hidden to conserve screen space. Alternately tapping on the “hamburger” icon at the top right corner of the masthead (Second iPhone view in Figure 9-3) controls visibility of  the navigation links under the masthead.

 

The Hamburger icon wil appear in red if Javascript is disabled.

 

In either mode, tapping/clicking in the masthead icon area will navigation back to the defined Home Page for the site.

A date indicating when the web site was created will be shown in the footer area.

 

ss home page

Figure 9-2  Web Page Example Viewed on Desktop Browser

 iphonePictureclipping galaxy s2

iPhone           iPhone                 Samsung Galaxy S2

Figure 9-3  Web Page Examples Viewed on Mobile Devices

9.1.3                        Box Scores Summary Web Page

Javascript must be enabled on the user’s browsers for proper viewing or printing of the Box Score web pages.

 

The WPC generates a page with box scores for all or just completed games played. An example is shown in Figure 9-4. For each game found,  a one line summary is shown with the game date and opposing team name.  Clicking/tapping on a Game will cause the line score and box score to be displayed. In the example in Figure 9-4, the user has clicked on Game 17. Clicking on the Game again will cause the box score to disappear.  Clicking on another Game will cause the previous selection to disappear and the new selection will appear.

 

When this web page is printed, all available box scores will be printed. The order of the games is controlled by the General Preferences  / Box Score Games Sort Order option.

 

The WPC will indicate if the date and opponent can’t be found, the line score is missing, or if there is a mismatch in runs scored by the home team in the line vs. box score.

 

box scores

Figure 9-4  Box Scores Summary Web Page Example

9.2                              Procedure

The One Step Web Site generation can take a fair amount of time to complete. The progress will be displayed in a non-modal dialog box when running the SBC under Windows-based versions of Excel or in the Status Bar under Mac OSX-based versions.  No user interventionwith the progress dialog box is needed.

 

WARNING:

This operation will overwrite any web files that may exist with the same name in the selected target directory without prompting the user. This is by design to prevent the need to answer the alert:

“File exists – Do you wish to overwrite?”

that would normally appear prior to creating each file. So make sure that you’ve selected the correct directory ☺

 

To create the files for the web site, perform the following steps:

 

1.       Run the File/One Step Web Site command or =16 height=16 id="Picture163" src="images/image146.png"> toolbar button.

2.       A dialog will appear:

Screen shot 2014-11-19 at 10

Figure 9-5  One Step Web Site Runtime Options Dialog

3.       The user can modify the web site update date that will be shown in the web page footer area. By default, this will be the date from the Division Standings. If blank, then today’s date will be used. The user may override this with any text entry. Leave this field blank to omit the Update line from the footer. Hit OK.

4.       The current Web Theme selection will be shown as a reference.

5.       A Directory Select dialog will be shown with a default target directory for the team web site files:

Screen shot 2014-11-19 at 10

Figure 9-5a  One Step Web Site Target Directory Selection Dialog

       Change the target directory as desired.  All files will be saved into this directory. It is suggested that a separate folder/directory be used to save the web files so that they will not be intermingled with the SBC program or data files. Make sure that the SBC-supplied graphics files are placed in this folder. Hit OK.

5.       The SBC will generate a series of files for the web site. When the processing has completed, a summary will be displayed. This summary can be recalled at a later time if required via the Display / One Step Web Site Summary command.

6.       Copy the resulting files along with the graphics files to the web server location provided by your Internet Service Provider (ISP).  Place all files into the same directory/folder. Do not copy the SBC program or data files. They are not needed for web site viewing.

7.       Inform your users of the URL to the home page (Figure 9-6).

 

WARNING:

The One Step Web Site command automatically generates hyperlinks on each page for navigation.

Thus, it is imperative that the filenames must not be changed or the hyperlinks will not work correctly.

9.2.1              Web Themes  4.000

osws web theme flow

Figure 9-7a Web Themes

The user can choose from a selection of pre-defined themes for your web site. Choose a theme by using the Edit / Web Page Composer Preferences / Web Theme command. Samples of the themes are shown on the SBC web site under the Tutorial section. The Brown [SBC Legacy] is the theme that was the default in previous versions of the SBC. Select the desired theme from the pull-down menu and hit the Load Theme button.

osws web theme preferences

Figure 9-7b Web Theme Preferences

The Active Theme is the framework used by the One Step Web Site command to generate a web site. This selection is preserved when the Team Worksheet is saved.

In Expanded Commands mode, additional web styling changes can be performed (Section 14). Those changes can be preserved as a user-defined theme.

9.2.2                        One Step Web Site Processing Summary

After the web site files have been created, a processing summary will be displayed  (Figure 9-6).  It contains pertinent statistics from the latest One Step Web Site command processing. This can be recalled at a later time via the Display / One Step Web Site Summary command.

 

Screen shot 2015-01-13 at 10

Figure 9-6  One Step Web Site Processing Summary

9.3                              Notes on Generating Web Sites

9.3.1                        File Name Conventions

Table 9-1 summarizes the file names that are automatically generated by the One Step Web Site command where name is the main Team Name in lowercase characters.  Any blank or non-web compliant characters in the main Team Name will be mapped to underscores.

 

Content Area:

Navigation Tab:

File Name:

Home Page 

Home

name_home_page.html

Team batting stats 

Stats

batting_summary.html

Schedule (optional) 

Schedule

schedule.html

Batting leaders

Leaders

leaders.html

Box Scores

Box Scores

box_score.html

Individual player stats files

none

name1_name2.html

User Notes area (optional)

Section 9.4.1

user_notes.html

Table 9-1  Web Site Files

9.3.1.1                  Player Filename Encoding

The filenames for detailed player stats will be generated automatically in the format:

 

name1_name2.html

 

Where name1 and name2 are the last/first (or first/last) name components of the individual player names depending on how they were originally entered (Section 6.2).

9.3.2                        Game Range Parameter Validation

If the Display / Informational Messages option is checked, the SBC will inform the user if there are potential mismatches in one or more of the game selection parameters.

9.4                              Options

In Basic Command mode, most processing options are preset for ease of use. However, some are available via the Edit / One Step Web Site Preferences command:

 

osws prefs basic

Figure 9-7  One Step Web Site Preferences in Basic Command Set Mode

9.4.1                        Incorporating User Notes Area as a Web Page

The user has an option to include the User Notes area into the web site. See Section 2 for possible uses of this area in the web site.

 

When enabled, a separate navigation tab will appear in the resulting web pages. The navigation tab label will default to Notices. The user may choose to modify the label as desired as long as it does not conflict with the pre-defined navigation tab names (Table 9-1).

9.4.1.1                  User Notes Web Pages Content and Layout

The SBC is configured to automatically render the User Notes content area as a mobile-first,  Responsive Design web table. With Responsive Design,  the first 10 columns of the table are always visible on all devices. On intermediate width devices (361px to 768px wide), columns 1-15 are visible. On large width devices, all columns are visible. Consistent with mobile layout strategies, vertical scrolling is active, but horizontal scrolling is inactive.

 

Thus, if the target audience includes mobile device users, some consideration should be given to the amount of content to be incorporated for each device size range.  Mobile devices have narrower viewing areas than desktop browsers. Thus, the content should be structured in a more columar fashion with the most important content in the first 10 columns and the next most important in columns 11-15.

 

As the content of the User Notes page is under user control plus the wide range of mobile screen sizes and resolutions, this may take some experimentation.

 

WARNING:

 Use discretion when including any personal or contact information on this page if the web site will be hosted on a publicly accessible web server and therefore subject to search engine indexing (eg: Google, Yahoo, Bing,e etc)..

9.4.1.2                  Zebra Striping

The SBC generates fill patterns on alternate lines of the tables in the major content areas of the web pages (Figure 9-2). This is controlled via the Zebra Striping for Stats Tables option.

 

If the User Notes area contains tablular data, striping can be applied via the Zebra Striping for Table Area option. If the User Notes area has additional information to be included with the tabular data, place this information above the table followed by a single blank row of cells as a delimeter.

9.4.2                        Game Schedule and Results Page

The inclusion of this page is controlled by the Include Schedule Page option in the General Preferences (Section 4).

9.4.3                        Current Weather

The current weather conditions can be displayed in the first content area of the home page (Figure 9-2).  Simply enter the geographic location in the form of:

City, State

 

Then, check the Home Page Contents Weather option to enable. The full US city and state name must be entered. Two-letter state abbreviations are not acceptable. Non-US locations are not supported.

 

No verification of the City, State parameters is performed.

If you encounter problems, visit www.showmyweather.com site and verify that the City, State combination is in the correct format and is supported.

9.4.4                        Graphics, WebClip and Favicon Icons

The graphics files are included in the SBC distribution media in the Web Site Files folder.

9.4.4.1                  Masthead Logo File

A default logo file sbc_logo_72.png is provided. In order for this to appear on the mastheads, place the file in the same directory as the files generated by the One Step Web Site command.

 

Do not change the names of the logo file.

9.4.4.2                  WebClip Bookmark Files

For mobile devices, a set of files referred to as WebClip icon files are provided. These files provide a custom icon when the user saves a bookmark of one of the web pages to the device’s home screen. Originally developed by Apple for the iPhone and iPad devices, these files are supported on other mobile operating systems although this varies by manufacturer.

 

The use of the WebClip icons is optional and does not affect the functionality or operation of the web site.

 

The WebClip icons have the general filename structure of apple-touch-icon-xxx.png. To become effective, these files must be placed in the root directory of your web site (e.g.. http://www.aces-softball.com/). If your ISP does not allow access to the root directory, contact SBC support at support@sbc.aces-softball.com for a method to get around this limitation.

 

Do not change the names of the WebClip icon files.

 

webclip example

Figure 9-9  WebClip Icon Example

A default title consisting of the Main Team Name and the current Stats Year identifier will be generated by the SBC. The user may override this as desired when performing a Save to Home Screen operation on a mobile device.

9.4.4.3                  Favicon Icon File

An optional favicon.ico file is also included. This file creates an icon for the SBC web pages in the browser location bar, tab, or favorites/bookmark areas depending on the browser (Figure 9-9). To become active, this file must be placed in the root directory of your web site (e.g.. http://www.aces-softball.com/favicon.ico). It will likely not be activated if it is placed in a subdirectory below the root directory.

Do not change the name of the favicon.ico icon file.

 

If your ISP does not allow access to the root directory, the SBC provides an alternative method for advanced users to address this limitation (Section 14.3.1.8).

 

favicon example

Figure 9-9  Favicon Icon Example

9.4.5                        Additional Options

In the Basic Command Set mode, the One Step Web Site command preferences are pre-configured to produce a web site structure shown in Figure 9-1 and layout as shown in Figures 9-2 and 9-3. In the Expanded Command Set mode, additional options are available. These include the ability customize the masthead icons and colors, and to control the style of the content of areas. There are additional options for more complex web site structures. See Section 14 for more details on the use of these options.

9.5                              Caching of Web Sites

During the course of the season, your web site will likely undergo frequent updates.  Thus, it may be necessary for some users to hit the “refresh” button in their browser occasionally to get the latest version of the web site.

9.6                              Search Engine Indexing of Web Pages

The default mode of the One Step Web Site command is to allow web search engines (eg: Google, Bing, Yahoo,  etc.) to index your web site pages.  You may wish to restrict the visibility of your site from search engine results. See Section 14 for details to activate this blocking feature.

9.6.1                        Google Mobile Friendly Compatibility

The SBC generates web pages that are compliant with Google’s new mobile friendly ratings and will be given higher search rankings.

 

Return to Table of Contents

 


 

10                WARNING MESSAGES AND TROUBLESHOOTING

10.1                          Warning Messages

The following table describes common messages that may occur during the use of the SBC and the action required to reconcile the issue. Additional information can be found in the user manual section(s) identified in the Reference column. Display of informational messages (marked with an asterisk (*)) is controlled via the Display Informational / Messages option.

 

MESSAGE

USER ACTION

REFERENCE

Startup:

Unsupported version of Excel

The SBC must be started with no open worksheets.

The worksheet is not an SBC team worksheet.

*Enable Add-Ins tab to view SBC menus and toolbars.

 

 

*Activate the Nomal Page View mode icon before running any commands

 

Check the list of compatible Excel versions.

Only a single SBC team worksheet can be open.

Relaunch the SBC from a valid SBC team worksheet.

A reminder on Windows version of Excel versions with the Ribbon user interface.

 

A reminder on Excel 2008 on the Mac for proper SBC operation.

 

1.4

1.5

 

2.2

 

 

2.2

File / Open Command:

Primary team worksheet is an invalid file.

An SBC team worksheet cannot be opened.

File may be corrupted or in use by another application

 

Only non-SBC Excel documents can be opened.

Verify the file and try again.

 

3.1

 

 

 

File / Convert Worksheet Format Command:

About to convert team worksheet format … This is not undo-able. Are you sure you want to continue ?"

 

All player rosters and stats will be cleared.

 

15.4.1.2

Stats File Description must be a non-blank value

Enter a unique description for the stats file.

15.4.1.2

 

File / Save Selection As Web Page Commmand:

 

 

Area must be a contiguous selection of cells for web page creation

Insure the desired area is a contiguous selection of cells on Team Worksheet

14.3.2,14.6.2

File/ Export Roster

nn players found with >>>> player marker. Process the player names and rerun the export.

*Insure that the filename suffix is .csv in the next dialog.

Filename must have .csv suffix

Can't create the file Filename. Check to insure that the file is not open by another application and the target directory is not write-protected.

 

File/ Import Stats Command (Multi-Season Mode):

 

Reconcile the player names before exporting the roster.

Just a warning.

 

File might be busy or on a write-protected volume.

 

16

 

 

 

16

Import file is not an SBC Team Worksheet .xls file type.

File is Not an SBC Team Worksheet or Import file.

Verify the filename and try again.

15.5.1.1

Cant open file for importing.

Verify the filename. Insure it is not locked or in use by another application.

15.5.1.1

The current team worksheet cannot be imported into inself.

You’ve attempted to import the current team worksheet into itself. Check the filename and retry.

15.5.1.1

Unable to determine worksheet type ID.

Unable to access critical parameters for processing

Verify the filename and try again. If the filename is correct, it may be corrupted.

15.5.1.1

The file needs to be updated before the stats can be imported.

Quit the SBC and relauch the import file to update it. Then, repeat the import process.

15.5.1.1

The file  has no roster entries

Check the import file as it appears to be empty

15.5.1.1

The file does not have any player statistics. Do you wish to continue importing ?

The import file has a roster but no player stats. If you continue, it will import the roster names for the selected season.

15.5.1.1

Stats File Description for the imported stats must be a non-blank value.

Import file Season ID matches the target Stats File Description. Verify correct files and/or descriptions and re-import.

Enter a unique description for the stats to be imported.

15.5.1.1

The import file is configured in full stats tracking mode…

The user has the option to change the primary team worksheet mode to match.

15.5.1

Statistics already exist for the selected season

Entering OK will overwrite the exisitng stats for all players.

15.5.1.1

*Statistics importing can take a fair amount of time.

Watch the window message bar for progress.

15.5.1.1

One or more player names from the import file matches a player name found in both  rosters0.

Duplicates from import file marked with >>>>.

Correct per instructions.

15.5.1.3

 

File/ Import Stats Command (Single Season Mode):

 

 

Import file is not a .csv file type

Import file is the current team worksheet. Unpredictable results can occur. Quit the SBC and DO NOT SAVE the file.

Check filename and re-import.

16.2

The current team worksheet cannot be imported into inself.

You’ve attempted to import the current team worksheet into itself. Check the filename and retry.

16.2

Unable to open file.  

File may be corrupted or in use by another application. Check filename and re-import.

16.2

The file is not an known import stats file.

Check filename and format type and re-import.

16.2

Invalid {file format type} file format.

Check filename and format type and re-import.

16.2

nn Missing stats fields. First missing field is: aaa.

The import file is missing one or more critical stats fields. Check the stats selections in the mobile app vs. the required fields and recreate the file.

16.1

Import file has no stats.

Check filename and format type and re-import.

16.1

Game Number must be a non-blank /positive value

Pick a positive integer value.

16.2

Stats for Game Number nn exists

Hitting OK will overwrite the stats for all players.

16.2

Unknown player name detected…

 

nn  players found with new player markers. Process the new player names and rerun the import.

 

File / Change Stats Year

New Stats File Description must be a non-blank value.

New Stats File Description matches the existing Stats File Description of the Multi-Season File. Choose another value.

New Stats File Description matches an existing Season. Choose another value.

 

File / Convert to MultiSeason Format

Stats File Description for the Multi-Season stats file matches the Season for the converted stats.

One or more player names from the import file could not be found in either roster.  Players have been marked with >>>>. Correct as necessary.

 

 

 

Verify the new stats file description.

 

 

 

 

 

 

Verify the new stats file description.

16.2.1.1

 

 

 

 

 

15

 

 

 

 

 

15

 

Edit / Color Palette Editor

 

 

Color parameter must be a defined color name in hexadecimal [#RRGGBB, #RGB] or decimal [rgb(RRR,GGG,BBB), rgb(r%,g%,b%)] format.

Re-enter a valid R, G and B color code

14.9

Edit/ Screen Size Command:

 

 

Enter value from 10 to 400 without percent sign.

 

Edit / Clenaup User Notes

The Selected Cell(s) Are Not In the User Notes Area.

Re-enter a numeric integer value to resize the screen display.

 

Recheck the selected area.

3.2

Edit / Game Display Range Command:

* Possible mismatch in game numbers.

 

 

 

 

Maximum game number is: nn

 

This is just a warning. The alert box indicates the mismatched values. This may or may not be incorrect depending on what the user wishes to display.

 

An invalid game number was entered. Value cannot exceed the highest game number where there are detailed player stats.

 

3.2, 4.3, 5.0, 6.3, 7.0

 

 

 

3.2, 4.3

Edit/Leaders Preferences Command:

 

 

Max Leaders must be less than Max Leaders Plus Ties

Change one or both of the preferences.

4.1, 6.4

Max Leaders Plus Ties must be less than or equal to…

This value must be less than the program limit defined by the SBC.

1.3, 4.1, 6.4

Leader Board is no longer accurate. Hit OK to update

One of the Leader Board parameters was changed. Hitting OK will result in an update to the Leader Board. Hitting Cancel will bypass the updating.

4.1, 6.4

Edit/ General Preferences Command:

 

 

Stats File Description must be a non-blank value.

Stats File Description matches an existing season

Enter a non-blank alphanumeric value.

3.2.4

Main Team Name selection has changed. Rerun Calculate / Division Standings to update highlighting.

Multi-Season Mode: The stats file description must be unique.

3.2.4,15.4.2

 

Edit/Paste Web Graphics Command:

Paste command failed. The clipboard may be empty.

 

The clipboard item is not a graphics image.

 

 

The current selection is not a picture.

 

 

Web graphics image table entry not found for this image

 

 

Web graphics table is full. Delete unused images and retry.

 

 

Re-select the desired area and try pasting again. If the command still fails, the target cell(s) may be protected.

An attempt was made to enter a non-graphics object. If the item is a text entry, use the traditional Edit / Paste command.

Attempt made to use the Web Graphics Info command on a non-picture object.

The selected item doe not have a entry in the Web Graphics table. It may have been created by an Excel drawing tool.

The internal table that store reference information for web graphics images is full. The image will still be pasted on the page and will be visible on printed pages. However, they will be ignored on web pages. Delete unused web graphics to make room and re-paste

 

 

13

 

 

 

 

 

 

 

 

 

 

 

 

 

 

File link for this web graphics image not defined.

This image will not be displayed on web pages where it is included. Normal printing is unaffected.

 

Internal failure. Cannot paste graphics image

Each web graphics item must have an associated graphics file.

 

 

This is a fatal error and should not occur. Report this to SBC Support.

 

 

 

 

1.7,  13

View and Format Menu Commands:

Selection XXX is locked due to embedded formula. Use caution with formatting changes. OK to continue ?

 

 

 

 

 

The selected cells are not in the User Notes area. Do not perform Center Across Selection or Merge Cells operations on this selection.

 

Activating one of the toolbars via the View menu will unprotect the worksheet. Proceed with caution with any formatting changes, especially when operating on cells with embedded formulas. Re-protect the worksheet when formatting operations are completed.

 

Just a warning not to perform either of these operations on a multi-cell selection in protected areas of the Team Worksheet

 

11.3, 11.4

 

 

 

 

 

 

11.4

Player Maintenance Commands:

* [command] is not undo-able !!!

Most player maintenance functions cannot be un-done. If you inadvertently answer OK and didn’t mean to, quit the SBC but DO NOT SAVE the worksheet.

 

6.1

About to clear ALL roster names and stats. Are you sure you want to do this ?

Player name is blank !

Player name cannot contain the string: >>>>

The Year parameter must be a non-blank value.

New player name is a reserved name.

New player name already exists in the expansion or active roster.

This clears the entire team roster and associated stats.

Check the entry and try again.

6.1

 

6.1

* Changing player name will not clear stats for this player

Just a warning that the Rename Player operation leaves the stats unchanged.

6.1

* Leader board and/or box scores are no longer accurate !

This warning indicates that it may be necessary to run the Calculate/Batting Leaders… and/or Box Score… commands at some point.

6.1

 

 

Player name cannot contain the string: >>>>

This is a reserved string. Pick another name for  the player without this string.

6.1

Player name already exists in the Active Roster

Pick a unique name.

6.1

Player name already exists in the Expansion Roster

Pick a unique name.

6.1

OK to clear leaders and box score ?

 

 

 

 

 

player name is a reserved name.

 

Player/  Rename Stats Season ID Command:

New Stats File Description must be a non-blank value

 

New Stats File Description matches the existing Stats File Description of the Multi-Season File

 

New Stats File Description matches an existing Stats Description of in Multi-Season File

 

Player / Consolidate Expansion Roster

The new name for the stats group cannot be blank.

The new name cannot be a reserved name.

The new name cannot match an active roster player name.

 

SBC Toolbar

The file SBC_Macros.xlm is already open

 

This message will appear after the Player / Clear All Player Stats or Player / Delete All Players From Roster command was executed. This is a timesaver when setting up the team worksheet for a new season.

 

The name of the Expansion roster area is a reserved name.

 

Enter a unique non-blank description.

 

Enter a unique non-blank description.

 

 

Enter a unique non-blank description.

 

 

 

 

 

 

 

 

 

The SBC had been previously used in a different folder. The SBC normally corrects for this at startup. If it does occur, run Display / Restore SBC Toolbar command.

6.1

 

 

 

 

 

4.1, 6.2.5

 

 

15.7.2

 

15.7.2

 

 

15.7.2

 

 

 

 

 

 

 

 

3.3.5

Player / Update Stats Commands:

Game number must be greater than 0

 

Ener a positive integer value.

 

6.2

Appearances must be a valid number !

Enter a positive integer value.

6.2

Extra base hits exceed hits !

Entry validation error. Check the entries against the scoresheet and re-enter.

6.2

Game not specified or not valid !

An existing or new game number must be entered.

6.2

Leader board is no longer accurate !

This warning indicates that it may be necessary to run the Calculate/Batting Leaders… command before the leaders are printed or a web page created of this area.

6.4

H + BB + FC+ ROE + SAC + K + HBP must be less than or equal to appearances

Check the entries against the scoresheet and correct as needed

6.3

 

Invalid entry in one or more fields

Check to insure entries are positive numeric values

6.3

Runs scored exceed plate appearances !

Entry validation error. Check the entries against the scoresheet and re-enter.

6.3

Only R, SB or FINES entries allowed if the player did not bat.

Recheck the stats entries for this player.

6.3

Web Page Save / One Step Web Site  Commands:

* Possible mismatch in game numbers.

 

This is just a warning. The alert box indicates the mismatched values. This may or may not be incorrect depending on what the user wishes to display.

 

3.2, 4.3, 5.0, 6.3, 7.0

Invalid Custom Hyperlink Detected…

See Section 10.6.4 for corrective action.

10.6.4

* The File Save dialog that appears next is used to select the directory for the player stats web pages. The file name is ignored.

This is just a notification when the Save All Player Stats as Web Page or One Step Web Site command is about to be executed. The only parameter in the Save dialog that is used is the selection of the desired target directory. The filename field is ignored.

9, 14

The contents of one or more cells contain too many characters…

Check the marked cells on the web page(s) and correct.

9, 14

[Picture_ ID]  in the selected area does not have a link to the graphics file defined. Use the Edit/Web Graphics Info command to correct.

This message may occur at the end of a web page generation command. It indicates that one or more of the web graphics on the worksheet is missing a filename link.  Picture_ID will be set to the first missing link detected.

9, 13, 14

Unable to create file: "Dest_File_Name"

The specified filename could not be created. This may be due to a write-protected area of the users’ disk, an attempt to write to a read-only media (e.g. CD-ROM), a file that is already open for writing by another application, or a system error. Check the filename and directory location and re-run the command.

9, 14

Area must be a contiguous selection of cells !

 

 

* Web page processing terminated. No file(s) saved.

The File / Save Area As Web Page, or Save Area As HTML Table commands can only process a range of cells that are contiguous.

This is a warning to indicate that the user terminated processing

14.4

 

 

9,14

Game number selection mismatch. Do you wish to continue ?

Differences among game display, home team game count, box score and leaders display settings detected. Change display range and/or run updates as desired.

4.1.7, 4.2, 5, 6.3, 7

No content area has been specified for the home page.

Check the settings in the Edit/One Step Web Site Preferences and rerun

14.2.1

* The web site creation takes time to execute…

 

This is just an informational message to remind the user that generation of a complete web site or saving of all the player stats as web pages can take a fair amount of execution time.

9.4, 14

User Notes web page may be too wide…

See Section 10.10.8 for corrective actions.

10.10.8

Edit / WPC General Preferences Commands:

Webmaster email address not specified or has embedded spaces.

 

Edit / WPC Masthead, Content Preferences Commands:

Color parameter invalid format .

 

 

Correct webmaster email address specification

 

 

Check the format and insure that all color values are [#RRGGBB, #RGB] or decimal [rgb(RRR,GGG,BBB), rgb(r%,g%,b%)] format.

 

 

14.4

 

 

14.3.2

 

 

 

Color selection conflicts.

 

Edit / WPC Include Files Preferences Command:

URL is blank.

Insure File and Directory Processing is enabled.

 

Edit / One Step Web Site Preferences Command:

Label not specified for the Home navigation link.

Label not specified for the User Notes navigation link.

 

Name specified for User Notes navigation link matches an existing navigation bar link name.

A User Defined Navigation Link must have a label and a link value.

Name specified for User Defined Navigation Link matches an existing navigation bar link name.

 

Link specified for User Defined Navigation Link matches an existing navigation bar link.

 

Spaces found in User Defined Navigation Link parameter. Recheck the link value before continuing.

 

 

 

 

Home Page URL…. Have been updated for Responsive Design…”

 

Correct conflicts such as chosing the same color for text, borders, background.

 

Each enabled include file must have a non-blank entry.

Activate File and Directory Processing from the Edit / WPC General Preferences command

 

The label cannot be blank.

 

 

If enabled, the User Notes label must not be blank.

Change the label so that it does not conflict with the Home, Batting Summary, Leaders or optional navigation link labels.

If enabled, the User Defined Navigation Link and Label must both not be blank.

Modify the name so that it does not conflict with the Home, Batting Summary, Leaders or User Notes link labels.

Modify the link so that it does not conflict with the Home, Batting Summary, Leaders or User Notes link labels.

User Defined links cannot contain spaces

The command could not be completed due to exceeding the character count limit for Excel dialog boxes.  A partial display or inability to display anything may result.

 

See Section 10.10.10 for explanation and corrective action.

14.3.2

 

 

14.4

14.3.1, 14.4

 

 

9.2.2

 

 

9.2.2, 14.3

 

 

 

14.3

 

14.3

 

 

14.3

 

 

14.3

 

 

Calculate Batting Leaders Command:

Game range parameters are invalid.

 

Number of entries in a leader category is less than the number desired.

 

 

Game numbers must be within the range of stats available in the file.

Can occur in AVG, OBPCT, SPCT, or OPS if there are an insufficient number of players that meet the desired minimum AB or PA criteria.

 

6.4.1

 

6.4.1

Calculation Box Score Command:

Maximum game number is: nn

 

A team name does not match a team within the division

 

 

Neither the Home or Away team is the Main Team.

 

 

Unable to find any player stats for game XX

 

An invalid game number was entered.

 

Verify the spelling of the team name if both teams should be in the division. Correct the spelling and retry the command. This is not a fetal error.

One team name must match the identified main Team Name. Check the spelling, insure a main Team Name has been selected and retry the box score calculation.

A scan of the detailed player stats did not find any entries for the selected game number. Check the game number selection and retry the box score calculation.

 

7

 

7

 

 

7

 

 

7

Line score exists for game XXX…

 

 

 

Box score calculation was successful but there was no previous line score…

Home or visiting team line score is empty.

 

Date, Time or Field entry is blank

The Box Score Calculation for this game had been previously run and the currently displayed line score, date, time, or location information differs from the saved version. Choose which version to use.

Enter the line scores and re-run the command.

 

If these fields are being used, validate and correct as required, then re-rerun the command. This is not a fetal error.

7

 

 

 

7

 

7

 

 

Table 10-1  Error and Warning Messages

 

10.2                          Problems Launching the SBC

10.2.1                    Mac OS X Platform

This is usually a result of not having the SBC_Macros.xlm file and your Team Worksheet files in the same folder (Section 2.1).

10.2.2                    Windows Platform

This is usually a result of not having the SBC_Macros.xlm file and your Team Worksheet files in the same folder (Section 2.1). In addition, if you had previously saved a Team Worksheet file as an .xlsx file, you will not be able to relaunch the SBC (Section 1.4).

 

If you encounter security alerts with Excel versions 2007 or later, this is a result of incorrect or incomplete Trust Center configuration settings (Section 1.4.2).

10.3                          Game Selection Mismatch Warnings

The SBC will inform the user when there appears to be a mismatch in various game selection parameters such as display range, box score game or batting leaders range:

Picture1

Figure 10-1  Game Selection Status

 

This is informational only and does not prohibit execution of the selected command. An asterisk (*)will appear next to the settings where the SBC has detected a potential setting mismatch.

 

If the Home Team Games Played entry appears as -*, this usually indicates that a main Team Name has not been selected in the Edit / General Preferences. This could happen if the user renamed the main Team Name in the division standings and did not update the main Team Name selection in the General Preferences command.

 

The display of these messages is based on the Display / Informational Messages setting.

10.4                          ### Value Appears in Cells

This value will appear in a cell when the contents do not fit in the cell.  This is only an issue during screen viewing and printing. The SBC web page processing routines correct for this condition by FM.  

 

Modifications via the Font or Format / Column Width commands or use of the Shrink to Fit option in the Format / Alignment command for the cell can address this.

10.5                          Web Site File Name Extensions Incorrect

This is the result of the Use Filename Extensions option check box being checked in the file save dialogs during web page creation. Uncheck this box and re-run the command. This should not occur during the One Step Web Site command.

10.6                          Web Site Navigation Does Not Work Correctly

There are a number of potential causes for this. The Display Computed URL Paths command (Section 14.5) may be helpful in diagnosing these problems. If you run into a situation that you cannot resolve, contact SBC support (Section 1.6).

10.6.1                    One Step Web Site

·         The user has inadvertently renamed one or more files that were created.

·         The user has moved or deleted one or more files out of the target directory. All files generated by this command assume they will be in the same directory.

10.6.2                    Manual Web Page Creation

·         Incorrect filename extensions created due to the “Use Filename Extensions” setting in the File Save dialog.

·         Incorrect settings for one or more of the directory or base address adders (Section 14.4).

10.6.3                    Relative Addressing URL Error Warnings

If the Player Files Directory option is active (Section 14.3.1.5),  then all links must be resolved as absolute addresses so that they will be reachable on the player stats pages as well as those in the home page directory. The warning will indicate the first link found to be resolved as a relative address.  Use the Display / Computed URL’s command to validate the change(s) and to detect other possible links that need to be corrected.

10.6.4                    User Defined Custom Hyperlinks

On rare occasions, a custom hyperlink may get corrupted.  This is most comon when running under older versions of Excel. The hyperlink value will typically revert to H or O. The user will be alerted to this condition when the One Step Web Site command is started. Use the Edit / Custom Hyperlink command to correct.

10.7                          Dropdown Navigation Bar on Mobile Web Site Pages Not Functional

The dropdown navigation tab feature uses Javascript to optimize the limited viewing area on mobile devices. If Javascript is disabled or unavailable on the browser, the Hamburger will appear but will show as red bars =18 height=16 id="Picture1800" src="images/image160.png"> to indicate this.  The navigation tabs will be functional but will always be visible.

10.8                          Web Site Graphics Do Not Appear on Web Pages

This can be caused by one or more of the following (Section 13.2):

 

·         Incorrect web graphics filename link specified or file in the wrong location

·         Corrupted web graphics file

·         Incorrect directory adders’ settings.

·         Mismatch in file type extension

·         URL coded as relative address when the Player Files Directory option is active. This will be evident if graphics not appear on the individual player web pages but appear on others.

10.9                          Web Site Favicon Icon Does Not Appear in Browser

See Section 9.4.2 for the correct placement of the favicon icon file.

10.10                      WebClip Bookmark Icons Do Not Appear

See Section 9.4.4 for correct placement of the WebClip icon files.

10.11                      Web Site Graphics Do Not Appear

10.11.1                Masthead Graphics

In Basic Commands Mode, see Section 9.4.4 for correct placement of the masthead icon file. In Expanded Commands Mode,  see Section 14.3.3.3 for correct setup of the masthead graphics file. If the graphics does not appear on the player stats pages but does appear on others, the problem is related to improper coding of the file as a relative URL.

10.11.2                Web Page Background Graphics

See Section 14.3.3 for correct setup of the page background graphics file. If the graphics does not appear on the player stats pages but does appear on others, the problem is related to improper coding of the file as a relative URL.

10.12                      Player Stats Validation Errors

Player stats are evaluated for consistency with the rules described in Section 6.3.5 in Single Season Mode during:

 

1.       Manual stats entry and updating (Section 6)

2.       Stats importing from files (Section 15)

3.       Box Score command (Section 7)

4.       Batting Leaders command (Section 6)

5.       One Step Web Site command (Section 9)

6.       Validate Player Stats command (Section 6)

 

The Validate Player Stats command can be used to analyze and repair each entry that has an error.

10.13                      Platform Specific Issues

The following are known limitations of the SBC due to differences in Excel versions and/or the Macintosh and Windows operating environments.

10.13.1                Font Library Variations

The  SBC is shipped with the Trebuchet MS font family selection as a default. This font is a sans-serif font that is web-safe (available on all HTML-compliant browsers).

 

The SBC will use this font family for web page generation along with a default of a sans-serif font where this font does not exist. If you chose to use other fonts, it is best to employ web safe fonts that can be found on most browsers.

 

A list of common web-safe font families can be found at:

 

http://www.w3schools.com/cssref/css_websafe_fonts.asp and http://cssfontstack.com/

 

Note that a specific font may not render the same look and/or size on all systems, printers or browsers.  In addition, some mobile browsers do not support all of these font families. So it is best to test your font selections on your users’ expected target browsers.

10.13.2                Page Breaks

In most instances, the page breaks are only for visual screen reference. When using the File / Print or any of the web page creation commands, the SBC will paginate based on predefined areas. For example, each detailed player stats section will be printed on a separate page.

10.13.3                “Can’t Empty Clipboard” Alert

On some Excel versions on the Windows platforms, an error alert of Can’t Empty Clipboard may occur during the execution of some commands. This is a well-documented problem on Windows. Attempts have been made to limit this in the SBC. Unfortunately, some are beyond the capabilities of the SBC to block.  The SBC command operation is not affected.

10.13.4                Dimmed Format Menu Items

Some items in the Format menu may appear dimmed indicating that they are not available to the user.  This is a function of the version of Excel and/or of the ability of the SBC to manipulate these options.

10.13.5                Graphics Files Interchange Problems Between Mac and Windows

SBC team worksheets with embedded graphics that have been created on the Mac platform and then moved to the Windows platform may not be visible. This is a known Mac<>Windows issue. See Section 13.3 for more details and work-arounds.

10.13.6                Macro Error During Page Setup or Print Commands

This is usually caused by a printer not selected prior to executing these commands. This is more of an issue on the Windows platforms. Unfortunately, there is no way for the SBC to test for this condition in advance. The solution is to use the File / Printer Setup command to select a printer. Alternatively, quit the SBC, select a printer, and relaunch.

10.13.7                Web Page Styling Does Not Match SBC Examples

Some older vintage browsers or browsers that have been stripped-down for mobile applications may not support features such as gradients, rounded corners or drop shadows. In these instances where the support is absent for a particular style, the gradients will appear as solid color fills, the rounded corners will appear square and the drop shadows will not be present.

 

On some very old browsers (eg,  Internet Explorer <=7), the navigation tabs will appear stacked vertically instead of horizontally.

10.13.8                Box Scores Web Page Issues

10.13.8.1          Detailed Box Score Won’t Display

Javascript must be enabled for this feature.

10.13.8.2          Box Scores Printing Issues

When a user prints the Box Score Summary web page,  the result will be an expansion of all available box scores in the list.

 

The box scores will be packed into as few pages as possible without splitting the results across page boundaries. Most browsers will honor the coding in the page to accomplish this. However, there may be instances where a game title and asociated box score may appear on adjacent pages. Internet Explorer has difficulties accomplishing this under some conditions. Possible solutions are to adjust the page scaling factor downward,  reduce top and botom margins, or employ a different browser such as Firefox, Chrome or Safari.

10.13.9                Link URL Modifications for Responsive Design

SBC version 3.60 implements Responsive Design layouts for the web pages. As part of the update, the link URL’s for the Home Page, Home Page Content Include file, and Optional URL’s have been reduced to a single set of URL’s. No more Mobile and Desktop URL’s. The update adjusts the URL’s accordingly. However, these may not be correct for your web site layout.

 

When the One Step Web Site command is first run after this update, an alert will be posted to verify the links via the One Step Web Site and Web Page Composer Include File preferences commands.  Once this evaluation has been performed, the One Step Web Site command can be run.

 

10.13.10                Import Dialog File Selection Problems

The SBC attempts to configure the file selection dialog box to show just the relative file types (file type filtering) for each import operation. On some versions of Excel, this function does not always work correctly. If you are not able to select a desired file, terminate the dialog box and disable the Source File Filtering option in the Edit / General Preferences command. Then, rerun the import command.

 

 

Return to Table of Contents

 


 

11                EXPANDED COMMAND SET MODE

This mode enables additional functionality for the power user.  It is enabled via the Expanded Command Set command (cmd+E) in the Display menu. These commands allow additional customization of the visual appearance and operation of the SBC.

 

Additional commands and toolbar functions are enabled in this mode.

 

They also provide additional capabilities for generation of web pages.  See Section 12.1 for more details on advanced formatting options.

11.1                          File Menu

Figure 11-3  File Menu in Expanded Command Mode

Additional commands available are:

 

Save CSS Styles (Section 14.7)

This command will create a standalone .css file based on the current web processsing parameters.

 

Team Worksheet Protected (Section 12.1)

This command allows the user to control the protection of the team worksheet for advanced formatting modifications. The Lock icon =16 height=19 id="Picture4602" src="images/image162.png"> on the toolbar performs this function as well. Alternate depressions will toggle the protection on/off.

 

Save Selection As HTML Table (Section 14.8)

This command will create an HTML table stub from the area selected on the team worksheet. This command can be used when it is desired to extract a specific portion of the team worksheet and incorporate it into another web page. For example, the division standings, box score, or batting leaders summary area(s) could be saved off as an HTML table and then included in a custom web page.

 

Save Selection As Web Page (Section 14.8)

This command will create a self-contained web page from the area selected on the team worksheet.

 

Save All Player Stats As Web Pages (Section 14.8)

This command will create a separate web page with individual game stats for each Active player on the roster. A separate web page for players in the Expansion roster category will also be created.

 

Import Stats Screen shot 2016-04-05 at 2 (Sections 15, 16)

In Single Season Mode, game statistics captured via a mobile stats app can be imported directly into the SBC.  In Multi-Season Mode, other SBC Team Worksheets can be imported to form composite/career statistics.

 

Export Rosters (Section 16)

Active and Expansion rosters can be exported into a file for transfer into a mobile app.

 

Configure Worksheet Format (Section 15)

This command will convert the current format between Single and Multi-Season Mode.  Existing player rosters and batting statistics will be purged.

11.2                          Edit Menu

edit exp

Figure 11-4  Edit Menu in Expanded Command Mode

11.2.1                    Additional Commands

The Web Page Composer Preferences sub-menu commands (Section 14.3), Paste Web Graphics and Web Graphics Info commands are active (Section 13).

11.2.2                    Custom Hyperlink (cmd+opt+H)

The Custom Hyperlink command allows the user to place hyperlinks in unprotected cells for subsequent web pages. This is primarily intended for use in the Summary Notices and User Notes areas. However, these may be placed in any unprotected cell.

 

custom hyperlink dialog box

Figure 11-5  Custom Hyperlink Dialog

To add a custom hyperlink, select the cell of interest and run the Edit / Custom Hyperlink command. A dialog will appear as shown in Figure 11-5. The desired URL can be entered, modified or removed by this command. When file and directory processing is enabled, the URL’s are subject to the same processing rules for Prepend Base URL (Section 14.3.1.4).   Cells that have an active hyperlink will have a small red marker.

Note:

A custom hyperlink cannot have a value of “H” or “O”.

 

The Open link in new window option will create a new window in the user’s browser when the link is clicked.

 

The Edit / Format User Notes Area command can also be used to remove all hyperlinks in the User Notes area with or without clearing or reformatting the cell contents.

11.3                          View Menu

This menu does not appear under versions of Excel with the Ribbon UI

as these functions are readilly available in the Home tab.

 

Picture2

Figure 11-6  View Menu in Expanded Command Mode

The items on this menu allow the user to control access to additional toolbars and palettes that are applicable to the use of the SBC operation on versions of Excel without the Ribbon UI. See Section 12.1 for more details on advanced formatting options.

11.4                          Format Menu

Screen shot 2014-10-10 at 8

Figure 11-7  Format Menu in Expanded Command Mode

 

 

11.4.1                    Font, Style, Number, Alignment, Borders, Patterns

These commands allow selective formatting changes to cells or cell areas on the worksheet based on the current area selection. The formatting of the Page Setup headers and footers for printed pages are not affected by these commands.

 

See Section 12.1 for more information on advanced formatting. Dimmed items are capabilities not available on some versions of Excel.

 

The Number command is intended for use in the User Notes area. Although it can be used elsewhere, the user should exercise caution as unexpected results may occur.

 

To prevent corruption of protected areas of the Team Worksheet, the Center Across Selection and Merge Cells options of the Alignment command should only be used on cells within the User Notes area. The SBC cannot prevent this operation. The user will be alerted if this command is attempted with a multi-cell selection.

11.4.2                    Row and Column Settings

The parameter in the Format / Row Height and Format / Column Width commands is in units of displayable characters at the current font and size settings, not in pixels or points. This is same as the standard Excel commands.

 

Modifications via the Font, Row Height or Column Width commands may result in values that do not fit into some cells. These oversize values will be shown as #### in the affected cells. See Section 10.3 for a further discussion of this issue.

 

The row and column settings should be used with caution as they may affect other areas of the Team Worksheet table layouts.  The Restore Column Widths command will restore the column widths to predetermined sizes.

11.4.3                    Color Palette Editor

This command allows the user to override entries in the worksheet color palette with custom color values.

 

The Format / Colors command allows the user to view the tool for evaluating color selections via a variety of methods. See Section 14.9 for a detailed discussion of color management in the SBC.

11.5                          Select Menu

select

Figure 11-8  Select Menu in Expanded Command Mode

These commands allow rapid selection of predefined areas of the team worksheet. In addition, the area is copied to the system clipboard for exporting to another program.

 


The Next Player Stats Area (cmd+ê) command will select the detailed stats area for the next roster player in alphabetical sequence. The Prev Player Stats Area (cmd+é) command will select the previous player. Both will sequence through the Active and Expansion roster players.

 

If the Invoke Web Page Save After Select option is active, a Save As Web Page dialog will be automatically invoked. This option can be used in preparation for saving selected areas of the team worksheet as web pages. See Section 14.9 for more information on saving as web pages.

 

If the Prompt for Options on Web Save option is also active, the user will be prompted for the Web Page Composer General Preferences  (Section 14.3.1) before the web page is actually composed. This allows the user the make last minute modifications to web page parameters without the extra steps of going to the Edit / Web Page Composer Preferences command.

11.6                          Display Menu

The One StepWeb Site Summary command displays the results of the last One Step Web Site command (Section 9).

 

The Import Summary command is used with the stats, schedule and roster importing features.

 

The Computed URL Paths... command or  toolbar button displays the resulting URL’s and navigation links based on the various file and directory settings. See Section 14.5 for more details.

 

display exp

Figure 11-9  Display Menu in Expanded Command Mode

11.7                          Player Menu

player exp

Figure 11-10  Player Menu – Expanded Commands Mode

11.7.1                    Check Rosters

This command is used in conjuction with the File / Import Stats and Import Roster commands. In Single Season Mode, it will scan the rosters for new player names resulting from the import operation (Section 16). In Multi-Season Mode, it is used to detect players that may appear in both rosters (Section 15).

 

Return to Table of Contents


 

 

12                USER CONFIGURABLE OPTIONS – EXPANDED COMMAND SET

12.1                          Formatting Modifications in Expanded Mode

The Expanded Command Set provides advanced formatting options. The selection of the areas to be modified can be achieved by any of the following methods:

 

  1. Manually with the mouse
  2. A Select menu command
  3. The Edit / Select All menu or toolbar command

 

The formatting options are divided into two groups:

12.1.1                    Safe Mode Formatting

These changes can be performed on any area of the team worksheet without possibility of worksheet formula corruption. They are safer to use than the tools or palettes in the Unprotected Mode Formatting (Section 12.1.2).  Thus, they are the preferred method of making these changes.

 

General Preferences menu (Section 4):

1.       Default Text Color – Global color for all areas except masthead and banners.  

2.       Category Titles Shade Color – For print and web pages.

 

Format menu (Section 11):

3.       Font - Font style and color selection

4.       Borders – Selection of the standard set of cell borders

5.       Alignment – Text alignment within cell(s)

6.       Patterns – Cell fill patterns

7.       Row and Column sizing

 

The Font dialog may be invoked via the SBC Toolbar Font Formatting button.

 

If the Font command is executed with the Summary Page masthead text line selected, the user will be prompted to update all of the other mastheads with these changes. See Edit/Update Masthead Banners command for more details.

 

On non-ribbon versions of Excel, the SBC Formatting Toolbar has tool equivilents for Font, Borders, Alignment and Patterns. Each of these tools will invoke a dialog box for the specific formatting changes. Dimmed items are not available on some versions of Excel.

 

The Borders, Alignment and Patterns menu commands and tools are not available when running on the Mac versions of Excel prior to Excel 2011.

 

See Section 4.4 for limitations on the use of these tools.

12.1.2                    Unprotected Mode Formatting

These commands can be performed on any area of the team worksheet and provide additional formatting capabilities. The caveat is that, when activated, they operate with the Team Worksheet unprotected.

 

WARNING:

As the team worksheet contains embedded formulas in many cells, these operations should be performed with extreme caution to prevent unintentional worksheet corruption. Although the Format menu commands (Section 11.4) are more limited, they are safer to use as they keep the team worksheet protected.

12.1.2.1              Activation

Activation of the Unprotected Mode Formatting can be achieved by any of the following:

 

  1. Un-checking the File / Team Worksheet Protected command
  2. Pressing the toolbar Lock icon =16 height=19 id="Picture4349" src="images/image162.png"> on the SBC Toolbar
  3. Selecting the Formatting Toolbar via the View / Formatting Toolbar command (non-Ribbon UI versions of Excel)

 

The user will be alerted to the fact that the Team Worksheet is about to become unprotected and to proceed with caution.  If the area that is selected contains embedded formulas, that fact will be noted as well.

 


The Lock icon will switch to an Unlocked icon  and the Message Bar at the bottom of the window frame will note:  Unlocked.  Press this button again will reprotect the Team Worksheet.

12.1.2.2              Available Tools

On versions of Excel without the Ribbon user interface, a customized toolbar will appear:

 

Screen Shot 2018-01-22 at 4

Figure 12-1 – Formatting Toolbar – Non-Ribbon UI

In addition, available toolbars under the View menu may be activated on non-Ribbon UI versions of Excel. Menu items that are dimmed are not available for use.

 

On versions of Excel with the Ribbon user interface, the available formatting tools are limited. The formatting tools on the Ribbon UI under the Home may be used.

 

A number of Excel formatting tools such as cell merging are not available.

This is to prevent inadvertent corruption of the Team Worksheet while in this mode.

12.1.2.3              Ending the Unprotected Mode Formatting Session

Once the formatting changes have been completed, it is imperative that the Team Worksheet be re-protected. This can be accomplished by any of the following methods:

 

  1. Re-check the File / Team Worksheet Protected command.
  2. Pressing the Lock icon on the SBC Toolbar. The icon will switch from =19 height=16 id="Picture4854" src="images/image176.png"> to  .
  3. Execution of most non-formatting commands.

 

The Lock icon will be re-activated and the “Unlocked” message in the Message Bar will disappear.

12.2                          PictureProcessing Options                 

Pictures and web graphics objects may be manipulated. See Section 13 for more details.

12.3                          Web Page Processing Options

An extensive set of options relative to web page generation is available. They are described in detail in Section 14.

 

 

Return to Table of Contents

 


 

13                IMAGES / PICTURES PROCESSING

The SBC supports the inclusion of pictures or graphics on the team worksheet in two major classes:

13.1                          Traditional Pictures and Graphics

Graphics and pictures may be created via external applications and copied to the system clipboard. They can be pasted anywhere onto the team worksheet by first selecting a cell near where you wish the graphic to appear and then using the Edit / Paste command. These objects float on the team worksheet and may be relocated by selecting and dragging the object to the new location. The limitation of these types of pictures or graphics objects is that they will appear only on-screen and on printed pages.

 

When the Expanded Command Set is active, the Drawing Toolbar can also be used to create graphics objects. The Format / Picture Toolbar and/or Drawing Toolbar can be used to manipulate the imported or locally created objects.

13.2                          Web Graphics

13.2.1                    Masthead Icon/Background Graphics

This graphics object will appear in the masthead area. It can be either an icon or a full width masthead graphic. If a masthead graphic is specified, it will override any web graphics pictures that have be placed in the masthead area. This method of including a graphic for the masthead is preferred over the Content Area Graphics method as it is only necessary to supply the link to the graphics file.

 

These graphics can be in jpg, png, gif or any format that can be rendered by web browsers. The Edit / Web Page Composer Preferences / Masthead command has the URL, positioning and scaling preferences for the masthead graphic.

13.2.2                    Content Area Graphics

Content area web graphics processing is not supported on Excel / 2008 on the Mac platform.

 

These graphics objects will appear on the screen, printed pages and also on web pages. These objects are created via external applications. They are subsequently copied and then pasted onto the team worksheet by first selecting a cell near where you wish the graphic to appear on the team worksheet and then using the Edit / Paste Web Graphics command:

 

Screen shot 2015-06-02 at 11

Figure 13-1  Web Graphics Object Information Dialog Box

The user will be prompted to enter an image file link for the object. This link is used during web page creation to create the HTML code necessary for the web browsers to locate the image file and place the picture at the correct location on the web page. The image file link URL will be added to the Image Files Directory value (if specified) and optionally to the Base URL value to create a composite URL to the image file. The value can be modified at a later time via the Edit / Web Graphics Info command. The Display / Computed URL Paths command can be used to show the actual path.

 

If the Image File Link value is not specified, a warning alert will occur.  The user can go back and fix this situation now by hitting the Fix button. Hit the Ignore button to continue without fixing.  The link entry can be added later via the Edit / Web Graphics Info command.

 

These objects can be relocated by selecting the object and then by dragging it to a new location. However, any other manipulations via the traditional PictureToolbar and/or Drawing Toolbar will only be seen on the screen and on printed pages. Thus, any changes to a web graphics image must be performed in an external graphics application and then re-pasted onto the team worksheet.

13.2.2.1              Edit / Web Graphics Info Command

This command allows the user to examine and modify attributes associated with web graphics that have been pasted into the team worksheet via the Paste Web Graphics command. A web graphics object is usually selected prior to using this command. If an entry is found in the Web Graphics tables for this object, the identifying information will be displayed as shown in Figure 13-1. The user will be alerted if the current selection is not a graphcs object or not found in the Web Graphics table. In this case, the user may use the pulldown menu to select a particular web graphics picture of interest. If the OK button is pressed, the window will shift to display the selected graphics object.

 

Image File Link

This allows the user to specify a specific filename for the picture when a web page is composed from the team worksheet. The image file link URI will be added to the Image Files Directory value (if specified) and optionally to the Base URL value to create a composite URL to the image file.

 

Insure that the link results in an aboslute URL address if the Player Files Directory option is active.

 

Nearest Cell to Top Left Corner

This identifies the nearest cell relative to the web graphic’s top left corner. The Nearest Cell value is useful to find a particular web graphics object when selected via the dropdown menu. The Nearest Cell value will change accordingly if the web graphic object is relocated.

Changes to the image file link do not become effective until the user hits the OK button.

13.2.2.2              Modification or Deleting Web Graphics

A desired web graphics object may be deleted by selecting the object and hitting the Delete key.

 

Modification of a web graphics object must be made externally in your graphics editing application to be reflected in subsequent web pages created by the WPC.   If changes are made to a web graphics object, they will not be reflected on the screen or printed pages until the updated image is re-pasted via the Edit / Paste Web Graphics command sequence.

13.2.2.3              Printed vs. Web Page Differences

Pictures and graphics will be printed as they appear on the team worksheet via the File / Print command.

 

If web pages are to be generated, the user must supply a link to the image file for each web graphics object used. The Edit  / Web Graphics Info command allows the user to view and modify the link value for each web graphics object. Note that a situation may occur whereby the screen/printed images do not match those on the composed web page if the user encodes a different Web Graphics file link than the image that was pasted.

 

Also, any modifications to a web graphics object via the Excel picture or drawing toolbars such as contrast enhancement, resizing, etc. will be reflected in the on-screen and printed images, but will not be reflected in the composed web page images.

13.2.2.4              Customizing WebClip Icons

A custom set of WebClip icons can be created to replace the set that is supplied with the SBC distribution.  There are a number of tools available that will create the set from a base graphics file. For example, Icon Slayer is a free web-based tool.  There’s excellent documentation there as well. Contact SBC support at support@sbc.aces-softball.com for addional assistance.

13.3                          Platform Issues With Graphics

Graphics that may have been added to the Team Worksheet on the Mac platform and then viewed on Windows may appear as a marquee outline with the warning: “Quicktime and a Decompressor Program Are Required…”. This is a result of a known incompatibility between Mac and Windows on some versions of Excel. There is a fair amount of finger-pointing on both platforms as to who is at fault.

 

Possible solutions are as follows:

  1. Avoid using the Macintosh Preview app to open a graphic file and subsequently copying it to the clipboard. Better to use a graphics editor app such as Graphic Converter as a source.
  2. Move the graphics file(s) to the Windows platform. Open the graphics file with a graphics editor program on the PC. Then launch the SBC and re-paste the graphics.

 

 

Return to Table of Contents

 

14                ENHANCED WEB PAGE GENERATION

These capabilities are for advanced users that desire more extensive control over the resulting web pages.

In Basic Command Set mode, the File / One Step Web Site command (Section 9) with predefined parameters has been provided for users that do not need these extended capabilities.

Contact SBC support  if you have any issues implementing any of these features on your web site.

14.1                          Web Page Generation Overview

A custom-designed Web Page Composer (WPC) in the SBC generates the web pages. Unlike Excel’s built-in Web Page Generator, the WPC composes very compact and clean HTML and CSS code. In addition, the user has control over a number of additional options that are not available with the Excel HTML generator.

 

The WPC generates syntax-correct HTML based on the World Wide Web Consortium (W3C) standards version 5 and cascading style sheets (CSS1, CSS2, and  CSS3).  It also employs the jQuery library and Javascript. These standards are the baseline used by most popular web browsers including Internet Explorer, Firefox, Safari/Safari iOS, Opera, Mozilla/SeaMonkey, Android and others. In reality, the level of conformance to these standards varies by browser type and version.

 

Starting with Version 3.60, the WPC composes web pages using Responsive Design techniques so that each same web page will dynamically adjust the content and style based on the user’s device and size. The web pages are also compliant with Google’s mobile friendly standards which will improve search engine ranking of your site.

 

Every attempt has been made to generate code that is cross-browser compatible. The WPC does not employ any browser-specific capabilities and thus, pages should appear similar on most recent vintage browsers. However, there may be differences in page appearance among various web browsers, browser versions, or the host platforms and OS releases (Windows, Mac, Linux, Unix, iOS, Android, etc.). These differences may be due in part by font family variations or specific browser settings.

 

The WPC generates most of the content area as HTML tables in order to preserve the tabular data structure of the team worksheet.

14.2                          One Step Web Site Command

In Basic Commands Mode, a basic web site is generated with all web files placed in a flat directory structure. See Section 9 for basic operation of this method.  When the One Step Web Site command is executed, runtime processing options are presented as shown in Figure 9-5.  In Expanded Command Set mode, additional customizations are available:

 

osws prefs exp

Figure 14-1 One Step Web Site Preferences in Expanded Command Mode

Processing Options

14.2.1                    Processing Options

These options are accessible via the Edit / One Step Web Site Preferences command or Toolbar Preferences button.

14.2.1.1              Home Page Navigation Label

The label field can be any text value.  Leave the field blank to restore the default value HOME. This link always points to the home page.

14.2.1.2              Home Page URL

A unique filename or URL for the home page. If enabled, Prepend Base URL path processing can be applied.  The filename suffix will be evaluated for compliance with the settings for Include File Processing and the suffix will be automatically set to .html  or .php as required.

14.2.1.3              Home Page Content

The user may select any combination of content for home page.  If the Generate Web Pages for Unselected Content is checked, any content that is not selected (except Box Score, Top Leaders, Notices and Weather) will be generated as a separate web page with a corresponding navigation bar tab. If the Include Schedule Page (Print and Web) option is disabled, then the Schedule option is disabled for both Home Page Content and separate web page generation.

14.2.1.4              User Defined Navigation Links

This option allows additional navigation links to web pages or locations outside of the WPC generated pages.  For each active link, the Label and a Link URL must be specified. The label field can be any text value that does not conflict with any other navigation bar label. The Position on Nav Bar option determines the location of these links on the navigation bar relative to the predefined SBC tabs.

 

ss nav

Figure 14-2  Customized Navigation Bar Example

The Link URL must be a valid relative or absolute URL entry. If enabled, Prepend Base URL processing can be performed on these links.

 

For example (Figure 14-1) the user has defined the User Notes page as a schedule page plus a custom link to a career site. The Position on Nav Bar has been set to right. This would result in the navigation links as shown in Figure 14-2.

14.2.2                    Customizing Web Themes  4.000

In addition to the built-in themes as described in Section 9, the user can create their own custom theme. Typically, it is beneficial to start with one of the built-in themes as a baseline and then experiment with changes using the WPC preferences options for Masthead, Navigation and Content. There are a number of excellent resources on the web for selecting color schemes.

Your customized theme will now be the Active theme. It will be preserved for re-use as the Active theme when you save the Team Worksheet. If you wish to use your customized theme in addition to one of the predefined themes, run the Edit / Web Page Composer Preferences / Web Theme command and hit the Save Theme button. This will save the Active settings as the Saved Theme for future recall. In addition, if you attempt to load an alternate theme when there are modifications to the Active theme, the command will alert you to save the current settings if desired before loading.

If you wish to transfer your customized theme to another Team Worksheet, insure that it is the Active Theme. Then, use the File / Export / Active Web Theme command to create a file with these settings. This file can be imported into other Team Worksheets as desired via the File / Import / Active Web Theme command.

WARNING:
Do not modify the contents of this file as unexpected results can occur

14.2.3                    One Step Web Site Processing Summary

In addition to the statistics shown in Section 9, additional information about the User Notes processing area are displayed (Figure 14-3). These results can be helpful in adjusting the content/layout.

 

Page Layout

Responsive Design (default) – Content will dynamically adjust depending on the screen size and orientation. Mobile device scrolling is vertical only.

Force Wide Page – Horizontal scrolling is enabled to view all possible content .

Warn Only – Notify the user if the content may not fit on a mobile device. Content modifications, Responsive Design or Force Wide Page modes may be needed.

 

Table Layout

Automatic  (default) - Indicates that the content area layout will be optimally rendered by the web browser. 

Follow Column Widths - Indicates that the browser will use the widths of the columns from the User Notes area.

Computed Content Width - An approximation of the width of the content area in pixels. An asterisk indicates a possible over-limit condition. A value beyond the limit indicates that the content may not be totally visible on small mobile device screens even if the column limit for small screens has not been exceeded.

Computed Column Count – A count of the number of columns in the content area. An asterisk indicates an over-limit condition,  indicating that only a portion of the content area will be visible on small mobile device screens.

 

Screen shot 2015-01-23 at 10

Figure 14-3  One Step Web Site Processing Summary

14.3                          User Modifiable Attributes for Web Page Processing

The user has control over a number of attributes that control the generation of web pages. Most of these options are contained in the Edit / Web Page Composer Preferences submenu dialogs (Figure 14-4) unless noted otherwise.

 

Screen shot 2014-08-15 at 2

Figure 14-4  Web Page Composer Preferences SubMenus

14.3.1                    General Processing Options

Screen shot 2015-01-29 at 6

Figure 14-5  Web Page Composer General Preferences Dialog

14.3.1.1              HTML File Suffix

Displays the default file type extension for all web pages except One Step Web Site home pages. It will be .html if Include File Processing is inactive, the SBC is configured for Basic Commands Mode, or the File / Save Selection as HTML Table command is executed.  It will be .php if Include File Processing is active. See Section 14.5 for information on Include File Processing.

14.3.1.2              Files and Directory Processing

Your web site design may use a flat directory structure with all files in the same directory. In Basic Command Set mode, the One Step Web Site command generates a web site into a single target directory. If a more complex structure is desired, the WPC offers a number of additional capabilities for file and directory processing.

 

URL’s for files and directories can be absolute path references (e.g.: http:// or /) or relative references.  

 

WARNING:

Use absolute addressing specifications if the Player Files Directory option is employed. Do not use relative addressing.

 

When the File and Directory Processing option is enabled in Expanded Command Set mode, the WPC will evaluate each directory and file URL and makes a determination if the relevant directory prefixes should be appended.

 

For example, a path for a CSS style sheet file of:

 

my_styles.css  or styles/my_styles.css

 

would have the Prepend Base URL adder pre-pended to form the URL (if enabled). However a URL specification of:

 

./my_styles.css, ../styles/my_styles.css, or /my_styles.css

 

would be left unchanged. The same holds true for the directory adders.

 

The Prepend Base URL specification can be either relative or absolute. The ability to enable/disable/change the Append Base URL specification allows web development in a wide variety of structures.

 

NOTE:

Global URL’s (eg: http://…) are not validated as they are outside of the scope of the SBC.

14.3.1.3              Prepend Base URL

When enabled, this option will conditionally apply the prefix to the following URL/filename parameters:

 

  • Home Page URL
  • CSS Stylesheet filename
  • Favicon link filename
  • Image file directory
  • Player files directory
  • Page background image filename
  • Masthead background image filename
  • Include files and include files directory
  • Content area graphics
  • User-defined navigation links
  • Hyperlinks

14.3.1.4              Image File Directory URL

This option can be particularly useful to globally relocate the file link descriptions for the graphics file images and background images without the need to encode this for each file. 

14.3.1.5              Player Files Directory Processing

This capability allows the user to specify a directory to contain the detailed player stats files. If specified, this value will be pre-pended to the hyperlink URL of the actual player files.

 

If this is activated in the One Step Web Site Processing mode, the WPC will prompt the user for the correct directory to place these files.

Player Stats Directory Selection

Figure 14-5a  Player Stats Directory Selection Dialog

The user must insure that this directory path is consistent with the hyperlinks that will be generated for the detailed player stats files. See Section 14.3.1.2 and Figure 14-6 for an overview of file and directory processing.

 

Absolute addressing specifications must be used  if the Player Files Directory option is employed. Do not use relative addressing. Use the Display Computed URL’s command to verify that all links are absolute.

 

URL Processing Flow

Figure 14-6  File and Directory Processing Hierarchy

14.3.1.6              CSS Style Sheet URL

This option allows the use of a user-defined cascading style sheet (CSS ) file. If specified, the contents may override predefined style values from the team worksheet and/or WPC Composer Preferences dialogs (Figures 14-3 thru 14-9). See Section 14.7 for more details on the use of this option.  The CSS Stylesheet can be activated without the File and Directory Processing enabled.

14.3.1.7              Include favicon <link> tag

This option allows the inclusion of a <link> element to specify the location of your favicon file. Normally the favicon file is placed in the root directory of your web server. However, if access to this location is prohibited by your ISP, this URL may be used to specify an alternate location.  The favicon option can be activated without the File and Directory Processing enabled.

14.3.1.8              Include Webmaster Email Link

When enabled, this will append a hyperlink to contact the webmaster by email.  The link will appear as Contact Webmaster in the footer area.  If a user clicks on this link, their default email client will be invoked to with the Subject line encoded as:

 

Subject: home_team_name Web Inquiry

 

Where the home_team_name is as selected in the Edit / General Preferences command.  Insure that a valid email address is entered.

14.3.1.9              Append Footer Text

When enabled, a text line will be appended at the bottom of each web page.  The user may enter any text string as desired. If disabled or blank, the footer text will not be added to the web page. In the example in Figure 14-5, the footer entry is used to append a copyright notice with the Unicode &copy; to generate the © symbol.

14.3.1.10          Block Search Engines From Indexing Pages

This option is usually inactive which allows web search engines (eg: Google, Bing, Yahoo,  etc.) to index your web site pages. However, if you wish to restrict the visibility of your site from search engine results, activate this option. When active, special code (meta-tag) is generated to instruct web search engine crawlers from indexing the web pages.  Note that if you modify this setting, it may take several days for the web search engines to reflect the change.

14.3.1.11          HTML Document Type

Preset to HTML5. Supported by most modern desktop and mobile browsers.

14.3.1.12          Generate Inline CSS Styles  4.000

Controls ability to generate the CSS styles in each file or to use an external global CSS stylesheet. Normally this option will be checked. When this option is checked, the CSS filesheet control above can be used in addition to the generated inline styles. Any common styles in the user-specified stylesheet will override the internlly generated styles.

When this option is unchecked, an external stylesheet can be used as specified by the CSS stylesheet parameter above. This option is for experienced web developers as unexpected results may occur. An image of the current CSS styles can be generated by using the File / Save CSS Styles… command as a baseline.

14.3.2                     Content Processing Options

These options specify the overall page background and content blocks design.

14.3.2.1              Page Background Fill Color

Specifies an optional background color for the web page if a background image has not been specified or if the background image file is not found or cannot be rendered by the browser. A predefined HTML web color may be entered from the dropdown list in the edit box. Examples of the predefined colors are shown in Appendix A.

 

Alternatively, a specific color value may be entered in the standard W3C color notation. Section 14.9 describes the various formats.

 

If specific background values are not specified, the web page defaults to a value specified by the user’s browser (generally white or light gray) or, optionally, via an external CSS background, background-color property.

 

Screen shot 2016-05-05 at 5

Figure 14-7  Web Page Composer Content Preferences Dialog

14.3.2.2              Page Background File URL

Allows the user to optionally specify a path to a file that contains the desired background image. If a background image is not desired, leave the field blank.

 

This file is normally a graphics file (gif, jpg, png, etc) in web-ready format (no preview). The entry in this field should be a path name description to the file relative to the location of where the web page will reside or an absolute URL path. If specified, the Image File Directory and Prepend Base URL are applied.

14.3.2.3              Content Cards Block Fill Color

Specifies the background color for all styled blocks.

14.3.2.4              Content Cards Box Shadow

When checked, applies a dropped shadow effect to the bottom of each content area.

14.3.2.5              Content Cards Border Radius

Specifies rounded corner effect for each content area. Specify the value in pixels. Eg: 2px . Enter a value of 0px for squared corners

14.3.2.6              Block Titles Text Color

Selects the color for the title line for each major content block. Leave this blank to follow the text color from the Team Worksheet.

14.3.2.7              Notices Card Border Highlighting

When checked, this will apply a thick border to the left edge of the first content card (Notices).

14.3.2.8              Zebra Stripe Color

Controls the color of the alternate stripe color when Zebra striping is enabled.

14.3.2.9              Font Family Override

Allows selection of an alternate font family for text. This will take precedent over the Default Worksheet Font family (Figure 14-7) which will then become the second choice for the browser. Individual cell overrides of the font family/size/color/style are still processed. A dropdown list of common sans-serif and serif fonts supported by most browsers is shown. A custom font family may also be entered. Leave the field blank to instruct browsers to use the Default Worksheet Font.

Fonts identified with an asterisk in the list (*) are fonts from the Google font libraries. There are over 900 available fonts in this library ! If you enter a font from this library, make sure that you place an asterisk as the first or last character in the Font Family Override name.

 

14.3.2.9              Hyperlink Text Colors

Controls the color of hyperlinks.

A dropdown list of common sans-serif and serif fonts supported by most browsers is shown. A custom font family may also be entered.  Leave the field blank to instruct the browser to use the Default Worksheet Font

14.3.2.10              Default Worksheet Font Family and Text Color

This will display the most frequent text font and color used on the Team Worksheet.

14.3.2.11              User Notes Web Page Processing

Table Layout

·         Automatic - Instructs browsers to render the content area in as small an area as possible. This is the default and should produce satisfactory results under most conditions.

·         Follow Column Widths - Instructs browsers to render the content area column using the widths seen on the SBC application screen. This may result in a wider than necessary web page and may not produce satisfactory results, especially for mobile devices.

 

 Page Layout

·         Responsive Design – Instructs the browser to dynamically adjust the amount of content displayed based on the devices’ screen width and orientation. This is the default in Basic Command Set mode and should be sufficient for most applications.

·         Force Wide Page – This mode activates horizonal scrolling for the page. Less desireable than Responsive Design but does allow all content to be viewed on small device screens.

·         Warn Only – The user will be alerted if the limits are exceeded but the page will still be rendered by the browsers as one page wide with vertical scrolling only.

The Narrow Page Width Limit and Narrow Page Column Limit values are helpful in sizing the displayed content extracted from the User Notes page.

14.3.3                    Masthead and Navigation Processing Options

The following options control attributes of the masthead and navigation bar. The masthead height is automatically set to 50px.

14.3.3.1              Masthead Banner Text

The WPC will extract the text line from the Page 1 header area of the Team Worksheet and use this as a banner on the masthead.  The banner text will be sized to fit (Section 14.3.3.2) and centered in the masthead.  The text color and/or font family can override the worksheet values as desired.  A blank entry will follow the worksheet value. Note that the text color is a separate setting from the Content area banners color (Section 14.3.2.3). Bold and italic styling will follow the worksheet values.

 

The banner text can be suppressed by unchecking the Display Banner in Masthead option. This might be the case if a custom icon or masthead background is deployed.

 

If the target audience will be using mobile browsers to view the site, the amount of characters in the Masthead Banner should be limited to fit within the smaller viewing area. Otherwise the Hamburger and/or masthead logo icons might be occluded.

14.3.3.2              Masthead Banner Text Height

The banner text will scaled by FM to fit the size of the masthead. This can be any integer value from 20% to 80%.

14.3.3.3              Masthead Background Icon File URL

The masthead Background Icon File URL describes an optional graphics file for an icon applied onto the masthead or a custom masthead background file. If enabled, the URL may be processed with the Image File Directory and Prepend Base URL specifications.

 

Insure that the URL results in an absolute address if the Player Stats Directory option is active.

 

If the Scale Background Graphics to Masthead is checked, the WPC will automatically size the image to fit into the masthead and center it vertically.

 

If the graphic file is an icon, the Position option may be activated to offset the icon 2% from the left-most edge of the masthead. If a full-width image file is deployed, uncheck the Position option to align the graphic flush to the left edge.

 

Screen shot 2015-04-28 at 12

Figure 14-8  Web Page Composer Masthead Preferences Dialog

14.3.3.4              Masthead Background Fill Color and Gradient

The WPC can produce a gradient-filled masthead or a solid color.  The Start Color and End Color values shown style the gradient to match the color scheme of the default The SBC icon file.  If you are supplying your own icon file or masthead background file, this may cause a visual conflict. In this event, uncheck the Gradient Fill option. The Background Fill Color determines a fallback color for the masthead if the gradient is disabled or not supported by a particular browser.

14.3.3.5              Navigation Bar Styling

Screen shot 030119

Figure 14-9  Web Page Composer Navigation Preferences Dialog

The WPC can produce a gradient-filled navigation bar (Gradient Fill) or a solid color.  The Start Color and End Color values shown style the gradient to match the color scheme of the default masthead styles. The Background Fill Color determines a fallback color for the navigation bar if the gradient is disabled or not supported by a particular browser. A Drop Shadow effect on the bottom of the Navigation Bar can be applied as well as a Lower Border.

14.3.3.6              14.3.3.6 Navigation Bar Links Text Tab Styling

The style of the text in the navigation tabs can be specified by the Link Tabs Text Style selection. The options are UPPERCASE, lowercase, or Capitalized.

14.3.3.7              Navigation Bar Borders Styling

A Border Color can be specified. Tab Borders can be applied between each of the navigation tabs. A Lower Border can be added under the navigation bar.

14.3.3.8              14.3.3.8 Navigation Link Tabs Styling

The navigation link tabs Fill Color and Text Color can be styled separately for the Inactive or Active page states. Leaving a Fill Color blank will result in no fill. Leaving a Text Color value blank will result in inheriting the default color.

The Underline Active Link Tab can be enabled for the current active page tab. The Thickness can also be specified. Enter the value in pixels. Eg: 2px>  .

14.4                          Include File Processing

When the File and Directory Processing mode is enabled, the user has the ability to add additional content at pre-determined locations in the web pages by means of “include” files. The file(s) are inserted into the HTML code via “PHP include” statements in the form:

<?php include ‘path_to_file’ ;?>

 

Thus, in order to use this option, the user’s web server must support server-side PHP pre-processing. The WPC will set the file suffix to .php for any file where the included code stub(s) is to be incorporated.

 

The path_to_file URL can be an absolute or relative path and is subject to the normal File and Directory Processing (Section 14.3.1.3). The Display / Computed URL Paths… command can be useful in resolving issues regarding the use of the these options. It should be noted that not all PHP processors will interpret full URL (http://) specifications.

 

If the path_to_file is an absolute path from the web server root location (eg: begins with “/”),  then the WPC will encode the PHP statement in the form:

 

<?php include $_SERVER['DOCUMENT_ROOT'].'/path_to_file’ ;?>

 

The Edit / Web Page Composer Preferences / Include Files command invokes the dialog box shown in Figure 14-9.  The current state include file processing is shown for reference in the top line. This is conrolled by the File and Directory Processing mode .

 

The following “includes” are available. Their insertion locations into the HTML and associated usage for each are suggested.

14.4.1                    Include Files Directory URL

This option can be particularly useful to globally relocate the file link descriptions for the include files without the need to encode this for each file.

14.4.2                    Include <head> Selector Stub File URL 

This allows the inclusion of additional tags from an external file into the <head> area of the HTML. When active, the contents will be placed just prior to the closing </head> tag in each web file.  Any valid <head> area HTML, CSS, Javascript tags or PHP code may be incorporated. Another possible use for this file would be to include the Javascript code stub for Google Analytics.

 

include

Figure 14-9  WPC Include Files Dialog

14.4.3                    Body Area Files

14.4.3.1              Body Header File

This file can contain HTML, Javascript, PHP or other code. When specified, this file will be inserted at the top of the body area of the HTML just after the opening <body> element.

 

This include file must contain a <div id=body-container> entry in order to properly open this element for the remainder of the HTML code generated by the WPC. The designer has the option of placing the code inside or outside the

body-container element. If a Body Header file is not specified, the WPC will generate the opening body-container div.

14.4.3.2              Body Trailer File

Typical usage might be for visitor counters. This file can contain HTML, JavaScript, PHP or other code.

 

When specified, this file will be inserted at the bottom of the body area of the HTML just prior to the closing </body> element.

 

The designer has the option of placing the code inside or outside the body-container div. This include file must contain a closing </div> element in order to properly close this element for the remainder of the HTML code generated by the WPC. If a Body Trailer file is not specified, the WPC will generate the  </div>  to close the body-container element.

14.4.4                    Home Page Content Include Files

The contents of this file is inserted after the last content block just prior to the footer line on the home page. This file can contain any valid HTML, Javascript, or other code that can be processed by the browser.  Unlike the Body Trailer file, this file is inserted into the main content-container div and is only applicable for content unique to the home page.

14.5                          Issues Resulting From URL Processing

Due to the wide range of possible file and directory adder descriptions, the resulting web pages may not produce the expected results (eg: broken links, missing files, etc).

 

When creating a composite URL (file name plus any Base URL and/or directory adders), the WPC will make an attempt to correct some basic entry errors such as missing or duplicate backslash (/) delimeters in the parameters.  For example, if the Base URL had a value of: 

                                                                        http://mywebsite.com

 

and the Player Files Directory  had a value of:

                                                                                                       PlayerFiles/

 

the WPC would correct the computed URL to:

 

                                                                        http://mywebsite.com/PlayerFiles/

 

The WPC will perform some basic URL validation prior to executing the One Step Web Site command and alert the user for corrective action. Validation of links that point outside of the basic web site structure (eg: www.mass-asasoftball.com/) is beyond the scope of the validator.  Correction of all possible URL errors is beyond the scope of the WPC. However, there are a number of web development tools available that will detect broken and/or malformed link specifications. 

14.5.1                    Display Computed URL Paths

This command may be useful to diagnose issues when the resulting web pages do not display as desired or if a navigation link  does not activate the expected web page.  Two dialogs are displayed in sequence (Figure 14-10).

 

url 1url 2

Figure 14-10  Display Computed URL Paths Command

The first shows the computed URL’s for each possible URL processing option.  The second dialog is specific to the computed paths for the navigation bars.

 

For each dialog, the user can chose to show the results of Basic or Expanded command set mode, and the effects of the File and Directory Processing. Note that changing these settings are for purposes of display only. They do not change the current settings for these modes.

 

Due to an Excel dialog box limit, a shorthand description ( */) may appear in the URL display for the Base URL.

 

The built-in URL validator will assess the links after each dialog box display.

14.5.2                    Absolute vs. Relative Include File Processing

Although relative file processing can be specified, some precautions should be noted as each path specification to the target file will be evaluated relative to the location of each web page.  This can cause some issues if the Player Files Directory is specified as these pages will be at a different directory location than the main web pages. Therefore, it is imperative to employ absolute addressing specifications for all URL’s if a Player Files Directory is employed . This includes all Include Files, Base URL, background and icon files, etc., if specified. The built-in URL validator will assess the link integrity for possible broken links prior to web page processing.

14.6                          Other User Modifiable Attributes

The user has direct control on the worksheet of the following parameters on a cell-by-cell basis. These changes are made via the Format menu commands and toolbars:

 

·         Font Name

·         Font Size

·         Font Color

·         Font Styles (bold, italic, normal)

·         Cell Background Fill Color

·         Cell Text Alignment

·         Border styles and border colors

 

The user has the option of specifying a cascading style sheet file (CSS). This option facilitates a consistent style among other web pages that may be part of the team web site. See Section 14.7 for details.

14.7                          Cascading Style Sheets

A user-defined cascading stylesheet file may be specified via the Edit / Web Page Composer Preferences / General command (Section 14.4.1). This facilitates a unified appearance of web pages generated by the SBC and other web pages that may be part of the team web site.  It also facilitates overriding/experimenting with style changes without regenerating the web pages via the WPC.

 

If a CSS  style sheet filename is specified, it will be placed in a  <link> container:

 

<link rel="stylesheet" type="text/css" href="filename">

 

The link can be a relative or absolute path to the filename and may have the Base URL prepended subject to the File and Directory Processing Rules (Section 14.3.1.3).

 

The WPC follows the rules of CSS cascading order as defined by the W3C standards. A user-defined CSS file can override specific style settings such as background fill color, background image file description, etc.

 

The WPC creates compact HTML code and encodes style information based on the WPC parameter settings plus indivdual cell attributes in the worksheet as required.  It will make a determination of the default style values based on the most frequently used styles in the selected area of the worksheet. These values will be overridden as required with style= elements on a cell-by-cell basis as each cell is processed. Thus, there may be instances where entries in a user-defined CSS stylesheet may not be able to override the worksheet values. The use of the CSS !important modifier may be useful to assist in the override. In other cases it may be necessary to modify the cell style attributes directly in the HTML or on the worksheet via the Format menu options to achieve the desired results.

 

A full tutorial on the implementation of CSS is beyond the scope of this document. Tutorials on CSS can be found at: http://www.w3schools.com/. There are a number of other references available on the web or in book form as well.

14.7.1                    Saving CSS Styles

The WPC encodes the current css styles into each web page.  A separate .css file is not used. For users that wish to utilize the current css style framework in custom web pages, a separate .css formatted file can be saved via the File / Save CSS Styles command. The styles will be based on the current web processing parameter settings.

14.8                          Custom Web Site

Although the One Step Web Site command should satisfy the majority of user requirements, the SBC provides a series of commands for users that wish to develop a highly customized web site.

 

Figure 14-11 shows an example of one of many possible structures.

 

Note in this example, that it requires only requires four commands to generate the web pages for summary stats, team batting stats, batting leaders, and all of the individual player pages. Of course, there are an infinite variety of structures depending on the user’s expertise with web page development and desired sophistication of the final web site. Table 14-1 shows the commands used to generate the web pages.

 

Web Hierarchy

Figure 14-11  Example Custom Web Page Hierarchy

 

Web Page/Directory

Description

Web Page Creation Method

 index

Top level home page

Select / Summary Stats command or a user created home page using traditional web page authoring tools

team_summary

Composite player batting stats

Select / Team Batting Stats command

leaders

Batting leaders

Select / Batting Leaders command

player_files

Directory of web pages with individual game-by-game player statistics

File / Save All Player Stats as Web Pages command

includes

“include” files for mastheads, footers, etc.

For advanced web authoring.

images

Web graphics files directory

Clip Art or user images created via traditional graphical design applications

styles.css

CSS stylesheet file

Optional user created file to change the appearance of the web pages.

favicon.ico

Web page icon file

Icon that will be displayed in browser URL, tab and bookmarks. A sample is supplied with the  SBC. Place in same location as your root directory. See Section 14.3.1.8 for alternative method.

Table 14-1  Advanced Web Site Creation Methods

14.8.1                    Generate HTML Table From Area

The user can generate an HTML table stub from a selected range of the team worksheet via the File / Save Selection As HTML Table menu command. This command is useful to extract areas of the team worksheet for incorporation into other web pages. The range of cells selected must be contiguous.

 

This command cannot be used on an area of a non-SBC Excel worksheet that may be currently open.

 

Style overrides are applied to specific cells in the selected area based on differences from the defined reference format settings.

 

A predefined area can be selected via one of the Select menu commands. If this mode is used, disable the Select / Invoke Web Page After Select option first to prevent a full web page generation sequence. Alternatively, use the mouse to select a range of cells.

 

This command will invoke a file save dialog with a default file name of:  table.html. The user may modify the filename and directory as desired. A prompt for HTML table composer preferences will occur next.

 

config html table prefs

Figure 14-12  HTML Table Composer Preferences

As this command only generates the code for an HTML table stub rather than an entire web page, only a minimal set of options is applicable. The initial values for these options are the current WPC Preferences settings. Any changes made to these settings are temporary for the composing of the HTML table.

 

The processing options allow the user to trim the HTML down to the specific content and attributes that is desired. Column width information (<col> tags) will be generated if the Fixed Layout option is checked. When active, a table width parameter can be encoded if the Encode Table Width option is checked.

 

This command can be used to generate tables for custom content for template files (Section 14.11).  An example might be to import a csv-formatted set of data by using the File/Open command. Then, the desired data would be copied into the User Notes area. Any modifications would be performed and an HTML table created.

14.8.2                    Web Page From Predefined Area

Any of the area selection commands in the Select menu can be used to generate web pages if the Select / Invoke Web Page After Select option is active.

 

The following Select menu command options are used during web page generation:

14.8.2.1              Invoke Web Save After Select

This option determines if a web page will be created after the desired area has been selected. When this option is active, the Save As Web Page dialog will appear after a Select command has been invoked.

 

IMPORTANT:

Insure that the check box for Use File Extensions is unchecked in the File Save dialogs.

Otherwise Excel will override the default file suffix (Section 14.3.1.2) with “.xls”.

14.8.2.2              Prompt for Options on Web Save

This option controls whether the user will be prompted for the Web Page Composer Preferences / General dialog (Figure 14-5) before the web page is actually composed. This allows the user the make last minute modifications to web page parameters without the extra steps of going to the Edit / Web Page Composer Preferences / General command.

14.8.3                    Web Page From Custom Area

The user may also use the mouse to select custom areas of the team worksheet, followed by a File / Save Selection As Web Page menu command.  Prompts for the Web Page Composer Preferences / General and page title/keyword preferences will occur if the Select / Prompt For Options On Web Save option is enabled. The range of cells selected must be contiguous.

14.8.4                    Save All Player Stats as Web Pages

This command will save the detailed game-by-game statistics of the Active roster players as separate web page files for each player. A composite web page for players in the Expansion roster category will also be generated. The user will be prompted for the target directory for the files.

 

If the Select / Prompt for Options on Web Save option is checked, the user will be prompted for overrides of the web page composer general preferences prior to starting the actual page compositions.

 

The generation of a full set of player stats can take a fair amount of time depending on the speed of the computer and the amount of statistics. The progress can be viewed in the message bar at the bottom of the window.

14.9                          HTML Color Management

14.9.1                    Color Selection and Specification

The user may select colors from the predefined HTML colors in the dropdown menus for color specification. Section B1 lists the available color names and corresponding decimal and hex values. Although most browsers support the use of the color name as a color parameter, the WPC will convert the color name to its’ hex value for compliance to W3C Standards and better browser compatibility. 

 

In addition, the user may enter color values in a numerical format. These formats are defined by the W3C as follows:

 

24-Bit Hexadecimal Notation

        #RRGGBB where the RR,GG and BB values are in the range: 00-FF hex.

 

8-Bit Hexadecimal Notation

#RGB where the R,G and B values are in the range: 0-F hex.

 

24-Bit Decimal Notation

                rgb(R,G,B)where R,G,B values are in the range 0-255 decimal.

 

24-Bit Percentage Notation

                rgb(R%,G%,B%) where R,G,B values are in the range 0% - 100%.

14.9.2                    SBC Color Palette

Excel utilizes a set of 56 colors as shown in Figure 14-13.  These colors are used for foreground (eg. text) and background (eg. fills).

The palette colors in the top 40 slots are predefined and not modifiable.

 

sbc pallette annotated

Figure 14-13  SBC Color Palette Color Map

14.9.3                    Modification of the Color Palette

The user has the option to redefine up to 16 colors in the range from 17 thru 32 inclusive (Figure 14-13).  To modify a color, the Edit / Color Palette Editor command is used.

 

This Palette Location Number dropdown menu selects one of the palette locations in the range from 17 thru 32. When selected, the current red, green and blue values for the selection are shown respectively in the 3 edit boxes. These are decimal values that represent each of the 3 color intensities in the range from 0 thru 255.

 

Each of the palette locations can contain the default color value for that location or a user-defined color value.

 

color pallete editor

Figure 14-14  Color Palette Editor Dialog

If a selected color corresponds to a defined HTML color name (Appendix A), it will be shown in the HTML Names field. If it does not, this field will be blank. The 24-bit hexadecimal value for the current palette location as well as the default Excel value will also be displayed.

 

There are multiple methods to modify a color depending on the users’ frame of reference.

 

Scenario 1 – Desired Color Is Already Known 

If the desired color is known by its’ HTML color name (Appendix A), the HTML Names dropdown menu can be used. The red, green and blue values corresponding to the color name will be filled in by magic.

 

If the desired color is already known by its’ red, green and blue components, the values can be entered into the red, green and blue edit boxes, respectively. If the values are in decimal (range: 0-255), then enter them unmodified. If the value is hexadecimal, then enter them as two-digit values for each color component with a leading # symbol.

 

Scenario 2 – Desired Color Is Unknown

If the user wishes to peruse the spectrum of available colors, the View / Colors command can be used.

 

This dialog allows the user to peruse colors via several different methods. Once the desired color has been selected, use the RGB sliders view to obtain the red, green and blue decimal values. Copy these values down. Hit either OK or Cancel (doesn’t matter which one). Then follow the steps in Scenario 1 above for a known color selection.

 

The SBC cannot gain direct access to these values.

Therefore, they must be manually entered into the Color Palette Editor dialog box.

 

Updating The Palette Entry

Once scenario 1 or 2 is completed, hit the OK button. The entries will be validated. If there are no errors, the palette table entry will be updated.

 

Reverting To The Default Excel Palette Color Value

The user may revert to the default color value for a specific color number in the Color Palette Editor dialog. Simply select the desired color number and then hit the Default button. The values will be automatically updated in the dialog box. To make this choice permanent for this color, hit the OK button.

 

Viewing The Current Color Palette

To see the contents of the current color palette, follow the following steps:

 

  1. Select any cell on the SBC team worksheet.
  2. Activate the View / Formatting toolbar or the Unprotect Worksheet command or toolbar.
  3. Activate the full Format Cells dialog via cmd+1 key combination
  4. Click on the Font tab.
  5. Click on the Color dropdown menu to see the full palette (predefined plus expanded colors)
  6. When completed, hit the Cancel button.                        

Excel palette editor 1

Figure 14-15  View / Colors Dialog

14.10                      Web Browser Compatibility Issues

Creating web pages that render identically on every browser on every available desktop and mobile device platform is a non-trivial task and is beyond the scope of this document (or the author’s J). The WPC makes every attempt to generate W3C compliant HTML and CSS code that should produce acceptable results on most recent vintage browsers.  However, older versions may  produce degraded or unacceptable results.  It is beyond the scope of this document or the WPC to address all of these issues. 

 

The following sections address some specific issues and suggestions to try if the desired results are not achieved.

14.10.1                Fonts

14.10.1.1          Font Family Selection

The choice of font family affects the look and size of the text on the generated web pages on different browsers and different operating systems. In addition the available font families differ among various browers. The WPC will extract the name of the predominent font family used from the team worksheet. This value is diplayed in the Web Page Composer Content Preferences dialog (Figure 14-7).  Individual cells can override this setting. The user may override the basic font family selection via the Content Preferences command (Section 14.3.2.6).

14.10.2                Advanced Styling

The WPC employs CSS3 properties such as gradients in the masthead and navigation bar, and drop shadows in the content blocks. Most current browsers such as Firefox, Opera, Mozilla/SeaMonkey, Google Chrome, and later versions of Internet Explorer support these. However, the support varies by browser, version and operating system.  In the absence of gradient property support, the result will be solid fill colors. In the absence of drop shadow support, a simple border will appear.

14.10.3                Mobile and Tablet Web Browsers

There exists a wide variety of web browsers that are deployed on mobile and tablet devices with varying screen sizes and resolutions. Thus, designing and testing web pages for the many variations is a non-trivial task as well.  The WPC produces web pages that render properly on the most popular mobile devices such as the iPhone, iPad, Blackberry, and Android.

 

A mobile browser may have more a more limted set of fonts available than desktop browsers.

 

Some mobile devices employ a stripped down browser such as Opera Mini that may not produce acceptable results. If you uncover this situation and need to target a specific device for your users, contact SBC support at support@sbc.aces-softball.com for assistance.

14.11                      Template Files

In Expanded Commands Mode, the One Step Web Site command can generate template framework files for customized web pages.  These files can be used to incorporate custom content for your web site that is not produced by the WPC .

 

A user must have a basic knowledge of HTML and CSS structures plus a familiarity with web page editing and validation tools. If you need assistance, contact SBC support at support@sbc.aces-softball.com.

14.11.1                Template File Structure

structure

Figure 14-16  Template Files Structure

A template file contains a basic framework of HTML and CSS code so that the pages will have the same masthead and navigation capabilities plus content styling as those pages that are generated by the WPC .  Two additional files are generated that contain the HTML and CSS code for the styling and navigation. Table 14-2 shows a summary of these files.

 

Web Page/Directory

Description

 template.php

Template file

template_head_stub.html

<head> area HTML and css for template.php

template_masthead_stub.html

Masthead and navigation HTML and css for template.php

 

 

Development File

 

 template.html

Template file with head and masthead code inline for development

Table 14-2  Template Files

 

A template file makes use of PHP processing on web servers to incorporate the stub files dynamically when the template file is invoked by the browser for display.

 

A template file needs to be generated only once by the One Step Web Site command. To keep the styling and navigation consistant with any subsequent changes to the main web site, the stub files are regenerated each time a new One Step Web Site command is executed. This eases web page maintenance as any changes in the stub files are automatically integrated into the template files.

14.11.2                Template File Generation

A template file is generated by checking the Generate Template File option when the One Step Web Site command is invoked (Figure 14-17).

 

Screen shot 2015-01-23 at 12

Figure 14-17  One Step Web Site Runtime Options

14.11.3                 Customization of Template Files

Each template file has an area for user content customization. It is bounded by the HTML comment lines:

 

<!--   ............................. user defined content starts here .............................    -->

 

<!--   ............................. user defined content ends here ...............................    -->

 

The template file has several comments and examples of content that can be used as reference. The user replaces this content with customized content using any valid HTML structures such as paragraphs, headers, lists, tables, etc. 

 

As the template files employs PHP processing, the user may also incorporate additional external content via PHP include file processing.

14.11.3.1          Predefined CSS Styles

The WPC has a number of additional predefined styles that may be utilized so that the custom content can maintain the same look as WPC-generated pages. They are contained in the template_head_stub.html file.

14.11.3.2          Linking Template Files to Navigation Links

A template file can be integrated into the web site navigation link structure via a User Defined Navigation Link (Section 14.2.1.4). The link is associated with a template file at One Step Web Site command runtime by selecting one of the active User Defined Navigation Link labels via the dropdown list (Figure 14-17).  If the template file does not have a direct navigation link via the navigation bar, then select none.

 

User Defined Naviation Link

Body id Value

 

 1

optional1

2

optional2

3

optional3

unassigned

none

Table 14-3  Template File Navigation Links

 

The link selection will place the appropriate <body id=xxxx> value into the template file for highlighting in the navigation bar.  Possible values for xxxx are shown in Table 14-3.

 

An example of linking a navigation link for a roster page to a custom template file is shown in Figure 14-18.

14.11.3.3          Processing Date

The template file generates a processing date plus optional webmaster link and footer text in the area bounded by:

 

 

<!-- begin: footer area -->

 

<!-- end: footer area -->

 

These entries may be altered as desired. They are not updated by re-generation of the stub files.

linkage

Figure 14-18  Template Files Linkage Example

14.11.4                Integrating Template Files Into the Website

Once the template file(s) is customized, rename it to match the link value filename as defined by the desired User Defined Navigation Link in the One Step Web Site Preferences command (Section 14.2.1.4).

 

The filename must have the .php suffix.

 

The stub files must reside in the same directory as the template file.

 

The two stub files associated with the template file must not be renamed.

14.11.5                Template File Development

14.11.5.1          Mobile vs. Desktop Browser Display

As mobile devices are normally viewed in portrait mode and have a smaller viewing area, the content should be structured in a more columar fashion and scrolled vertically. The opposite is true for desktop browsers (landscape mode and larger viewing area).

 

A full discourse on mobile content optimzation is beyond the scope of this document. However, it is good practice to reduce the amount of content so that it can be viewed without horizontal scrolling. Alterntatively, the user can rotate the mobile device to landscape mode to increase the horizontal viewing area. Keep in mind that not all mobile devices support this capability.

 

Two solutions are available to assist:

 

Responsive Design

Techniques which dynamically adjust the amount of content that is displayed similar to how the SBC controls content.    

 

If your content is in the form of HTML tables, there are css styles in the template_head_stub.html file that can be deployed.

 

For example,  for small mobile screens in portrait mode (<360px wide), approximately 10 columns of content can be viewed. For medium width screens (360px > 768px wide), approximately 15 columns can be viewed. Beyond 768px is compatible with desktop browsers so all columns can be viewed.

 

To accomplish this, your tables can be encapsulated in a div as follows:

 

                                          <div class=”responsive-style-1 responsive-style-2 ... “>

                  your table goes here

                  </div>

 

Where responsive-style-n is a space-separated list of css styles defined by the SBC. Each of these styles controls the blocking of a group of columns based on the active viewport size. The predefined styles of interest are shown in Table 14-4.

 

css Style

Screen Viewport Size

Columns Blocked

 

rd-table-low-res

<360px

11-15

rd-table-low-med-res

<768px

16-25

Table 14-4  Responsive Design Styles

 

Thus, to allow columns 1-11 on small screens, 1-15  on medium width screens, and all columns on large screens, the <div> would be coded as:

 

                  <div class=”rd-table-low-res rd-table-low-med-res“>

 

When the viewport exceeds 360px, then the content in columns 11-15 becomes visible.  When the viewport exceeds 768px, then the content in columns 16-25 becomes visible. Any content in columns 26 and beyond is always visible.

 

These styles operate on <td> tags only. Thus your tables should not have <thead> or <tfoot> regions.

 

If you wish to have Zebra striping on your table as well, add the zebra class to the <div> or in the <table> tag.

 

If you have structures that do not match these characteristics, contact SBC support at support@sbc.aces-softball.com.

 

2) Forced Horizontal Scrolling

This approach can be used when it is desireable to have all of the content viewable on all possible devices. The masthead and navigation bar will remain fixed at the top of the mobile browser, but the content can now be scrolled both horizontally and vertically.

 

To implement this, in the template file, look for the line: 

 

<div class=content-container>    <!--- begin: content-container -->

 

Modify the div to:       

 

<div class=content-container style=”width:xxpx;”>

 

Where XX is the estimated width of the content area in pixels. Calculation of this value is  an inexact science. However, typical mobile browsers have a horizontal viewport width of around 320px in portrait mode and maxing out at 800-1000px. So use these as a guide.

14.11.5.2          Local Development of PHP Web Pages

This poses some challenges as PHP-encoded pages depend on a web server to process the PHP requests to incorporate the stub files for proper display by the browser.  Unless there is a web server configured with PHP processing on the developer’s computer or network, the browsers will not have the content to display the entire page.  In addition, any HTML or CSS code validators will have the same issue.

 

The process of editing a template file and then uploading it to a server to view/validate the results is an alternative. However, this adds steps and time to the development. To aid in this process, the WPC generates a template.html file. This file is produced with the stub files contents in-line so that they can be validated/viewed by a browser locally. When the desired result is achieved, copy the content area into the template.php file before uploading to the live web site. Figure 14-19 shows a typical development flow.

 

It is suggested that the devleoper use these files initally for development. Although they can be used for the actual pages, their limitation is that they do not load the stub files dynamically when the page is displayed by the browser. Thus, any subsequent style or navigation link changes to the main web site will not be reflected the next time the site is regenerated.

 

development

Figure 14-19  Custom Content Web Page Development Flow

14.11.6                Additional Tools For Development

Firefox Web Browser  https://www.mozilla.org/en-US/firefox/new/

Current versions have a Responsive Design View tool under the Tools/Web Developer menu. Allows simulated viewing of a web page on a variety of selected screen sizes, portrait/landscape orientations, etc. including popular mobile devices. Coupled with the Firebug add-in (https://getfirebug.com/) or other browser tools, this is a powerful combination for testing.

 

A big advantage of these tools is that the web pages can be resident on your computer or on a server. The downside is that the controls are resolution-based, not device-based like the Cowemo or iPhone simulators.

 

Cowemo Mobile Phone Emulator (http://www.mobilephoneemulator.com/)

Web-based tool for testing mobile web pages.  Emulates a wide variety of mobile devices. Adjustable parameters based on device types. The downside is that the web pages must be resident on a web server.

 

iPhone Mobile Simulators  (http://iphone4simulator.com/, http://iphone5simulator.com/)

By @DesignJockey.  iPhone-specific simulators. The downside is that the web pages must be resident on a web server.

 

CSV-to HTML Table Converter (http://www.convertcsv.com/csv-to-html.htm)

Web-based tool. Highly configurable. If you use this tool with Responsive Design styles, it is suggested that you uncheck the option for First row is column names.

 

SBC Table Generator Command (Section 14.8.1)

Generates an HTML table to a file from a selected set of cells in the User Notes area. This can be used in conjunction with the File / Open command to import non-SBC content into a secondary worksheet. Highly confgurable.

 

 

Return to Table of Contents


 

15                MULTI-SEASON MODE

15.1                          Overview

The SBC has the capability of compiling statistics from multiple single season team worksheets into a single unified multi-season worksheet. The user simply tracks the game-by-game statistics for each season in separate team worksheets.  Then, a separate team worksheet configured for Multi-Season Mode operation can then import these statistics and produce a composite set of statistics.

 

Statistics in Single Season Mode files are maintained on a game-by-game basis. Statistics imported into Multi-Season mode files are aggregated by season. Thus, if any game-specific corrections are required, they should be fixed in the appropriate Single Season Mode file(s). Any modified Single Season file can be subsequently re-imported into the composite Multi-Season stats file.  

 

In addition, a Multi-Season file can be imported into another Multi-Season stats file (Section 15.2.2). 

15.2                          Strategies For Organizing Stats

15.2.1                    Conventional Approach

The conventional approach is to maintain each seasons’ game-by-game statistics in a separate SBC Team Worksheet file and then combine these stats into a composite set of career stats (Figure 15-1).

 

 file structure-simple

Figure 15-1  Convential Multi-Season File Structure

15.2.2                    Alternative Approaches

There are other creative strategies that can be deployed based on how the user chooses to maintain statistics. Figure 15-2 shows an example where regular season, playoffs, and tournaments stats are maintained in separate SBC Team Worksheet files and then combined into a composite set of stats.  This can also be done on a single season or multiple season basis. Other combinations are possible as well.

file structure-complex

Figure 15-2  Alternative Multi-Season File Structures

15.3                          Functional Differences in Multi-Season Mode

Some features found in Single-Season mode operate differently or do not apply in Multi-Season mode.

15.3.1                    Batting Leaders

Batting leaders can be calculated from the composite stats. See Section 15.8 for details.

15.3.2                    Division Standings

Division standings can still be maintained. However, there are no provisions for automatic importing the standings from individual Single Season files in the current version of the SBC.

15.3.3                    Game Schedule Manager

In Multi-Season Mode, individual game by game statistics are combined into composite season statistics. Thus, this capability has no relevance.

15.3.4                    Box Score

In Multi-Season Mode, individual game by game statistics are combined into composite season statistics. Thus, the  Box Score function has no relevance.

15.3.5                    Stats Validation

The SBC stats validator operates on a game-by-game basis and thus is not applicable.

15.3.6                    Multi-Season Web Site

A separate web site can also be generated from these statistics. If the user maintains a primary team web site, the Multi-Season web site can be cross-linked to the primary web site. See Section 15.10 for details.

15.4                          Command Set Differences In Multi-Season Mode

As the statistics entries are now composite season values, commands that operate based on game-by-game statistics are no longer applicable. Any changes to game-specific stats can be edited in the original single season worksheet files and subsequently re-imported into the Multi-Season mode file.

 

The following commands are not active in Multi-Season Mode:

 

·         Edit / Game Display Range

·         Edit / Game Numbers…

·         Edit / Schedule…

·         File / Import Schedule, Edit / Schedule, Display / Schedule

·         Player / Add Player to Roster

·         Player / Delete Player Stats

·         Player / Delete Player Stats by Game Range

·         Player / Update Player Stats

·         Player / Validate Player Stats

·         Calculate / Box Score

·         Display / Expanded Commands – always set to Expanded Commands mode

15.4.1                    File Menu Commands in Multi-Season Mode

15.4.1.1              Import Stats

This command allows the user to import a set of statistics from another SBC Single- or Multi-Season file (Section 15.5).

15.4.1.2              Configure Worksheet Format

This command will change the Team Worksheet format from Multi-Season Mode to/from Single Season Mode.  All roster entires and batting statistics will be cleared.  The box score and batting leaders will also be cleared. This command is provided for convenience purposes.  A copy of an existing empty Single- or Multi-Season Mode file essentially serves the same function.

 

WARNING:

This operation is not undo-able !!!

 

15.4.2                    General Preferences in Multi-Season Mode

15.4.2.1              Sort Expansion Roster Option

As the statistics are tracked by season, sorting by Game number is replaced by sorting by Season (Stats File Description).

15.4.2.2              Display Season Totals

This option determines if the total number of seasons is computed and displayed for each roster entry.  This is the normal display mode when the imported stats files are a full season. 

 

If the Multi-Season stats file is comprised of multiple entities for a single season (See Figure 15-2 for 2012 Season), then this option should be unchecked. Otherwise the Season totals would be incorrect.

 

gen prefs ms

Figure 15-3  General Preferences Dialog in Multi-Season Mode

15.5                          Assembling a Multi-Season Mode Team Worksheet

Each Team Worksheet file (Single- and Multi-Season format) is identified by a unique Stats File Description parameter from the General Preferences setting in each file (Figure 15-3). This parameter may be modified for each file at import time or later as desired.  

15.5.1                    Importing Statistics From a Team Worksheet

Use the File / Import Stats command or toolbar icon to select the Team Worksheet to be imported. The SBC will test the file integrity as an SBC file and the revision number.  A test to insure that the current Team Worksheet has not been selected as the import file is also performed (attempt to import the current Team Worksheet into itself). Any issues will be reported. The user will be notified if the import file needs to be updated. If so, close the SBC.  See Section 2.5 for procedure.

 

With an open Multi-Season team worksheet, additional statistics from other seasons, tournaments, playoffs, etc. may be imported from their respective SBC Single Season team worksheet files via the File / Import Stats… command. 

 

A prompt for the Stats File Description will be shown (Figure 15-4). If the team worksheet file has a previously defined Stats File Description value, it will be shown as a default. If not, enter a unique identifier for this group of statistics.

 

Screen shot 2013-06-26 at 3

Figure 15-4  Worksheet Importing Options Dialog

Alternatively, the user can enter them under a different identifier. This might be the case if the Stats File Description in the import file was not entered correctly previously or that the user is choosing to change the identifier strategy. The stats in the import file should be verified as matching the desired identifier before performing this action. This should be performed with care to prevent duplicate stats entries.

 

If a stats group matching this identifier already exists, the user will be alerted to this condition. If this is acceptable, the imported stats will overwrite the existing stats for that Stats File Description. This is a normal situation when it is desirable to update the Multi-Season stats during the season with stats from the current season, playoff or tournaments.

 

The user will be alerted if the import file is in full stats tracking mode, but the primary Team Worksheet is in Slow Pitch Only mode (Section 2.1.6). The user will have the option to switch to full stats tracking mode at that time. 

 

At the completion of the import process, a processing summary will be displayed as shown in Figure 15-5. This summary can be recalled at a later time via the Display / Import Summary command.

 

Screen shot 2013-08-28 at 8

Figure 15-5   Worksheet Import Stats Summary

If multiple player stats entries have been imported into the Expansion roster, the user will be prompted to optionally compress the stats for these players for this season down to a single entry. See Section 15.6.1.6 for a description of the Consolidate Expansion Roster feature.  Alternatively, the user may choose to perform this operation at a later time via the Player/Consolidate Expansion Roster  menu command.

 

See Section 15.7 for details on resolving potential issues that might occur as a result of the import process.

 


As a final step, the user has the option to recompute the Batting Leaders at this time. Alternatively, the leaders can be updated via the Calculate/Batting Leaders menu command at a leter time.

15.5.1.1              Importing of Expansion Roster Stats

The user may choose to preserve the Expansion Roster entries.  It is recommended that the Expansion Roster entries be preserved. They can be renamed, merged with other players, consolidated, or deleted at a later time as desired (Section 15.7).

15.5.1.2              Roster and Stats Importing Methodology

If the player name already exists in the composite stats roster, the stats from the import file will be merged with existing stats for that player in the Multi-Season file. They will appear as a separate composite entry in their detailed stats block with the Stats File Description.  If the user is re-importing stats for the given Stats File Description, then the stats for the player will be over-written.

 

If the player name does not currently exist in the composite stats, a new roster entry will be created with the Stats File Description. The player stats will be placed in the Active or Expansion roster based on the players’ roster location in the import file.

15.5.1.3              Roster Conflicts

If the import results in a player appearing in both rosters, an alert will occur after the import. This might occur if a player was in the Active roster one season and the Expansion roster in another. All duplicates will be marked with >>> next to their name in the Expansion Roster. In addition, there are means to resolve potential player name conflicts such as player names that might be spelled differently in different stats files. See Section 15.7 for strategies to resolve these and other conflicts.

15.6                          Managing Multi-Season Statistics

The user can perform a number of operations on the imported stats on a season-by-season basis or on an individual player for a specific Stats File Description.  Transferring players between the Active and Expansion rosters is also supported.

 

Additional capabilities are provided to merge statistics from one or more players into a single entity. This can be useful if a player name might have been entered differently or or appears in different rosters in one or more single season worksheets.  Another use would be to merge a number of Expansion roster players (eg. alternates, substitutes, drive-bys, etc) into a single entry for each season.

15.6.1                    Player Menu Commands in Multi-Season Mode

Commands that are dimmed are not functional in Multi-Season mode.

 

WARNING:

Any changes made to entries in the Composite stats file will not be back annotated into the corresponding imported stats file(s).

 

player ms

Figure 15-6  Player Menu in Multi-Season Mode

The Rename Player, Delete Player From Roster and Transfer Player Stats commands operate the same.  However, the user should take into account their impact on subsequent statistics importing to prevent duplicate statistics from being created.

15.6.1.1              Check Rosters

This command checks for the existence of player names that may exist in both the Active and Expansion Rosters as a result of an import process. If no duplicates were detected, a “Roster OK” message will be reported.

 

Otherwise, a report of the number of duplicates found will be reported.  Section 15.7.2 describes the methods of resolving these issues.

15.6.1.2              Merge Player Stats

This command allows the user to combine stats from two players into a single entry.  A prompt will occur for each player name. The players may be in the same or different rosters. The stats from the first player will be merged with the stats from the second player. Then, the first player entry will be removed from the roster.  Season identifier information is maintainted in this process. Section 15.7 describes some situations where this command is utilized.

15.6.1.3              Rename Stats Season

This command allows the user to change the Stats File Description for a group of stats (Section 15.7.3).

15.6.1.4              Delete Player Stats By Season

This command allows the user to remove the stats for a specific player for the specified Stats File Description. To maintain consistency, it is suggested that the user perform this function in the individual Single Season stats files and subsequently re-import the stats.

15.6.1.5              Delete All Players Stats By Season

This command allows the user to remove the entire set of stats for the specified Stats File Description. This command is of benefit in the case where an incorrect set of stats had been previously imported.

15.6.1.6              Consolidate Expansion Roster

When a large number of stats files from multiple seasons have been merged into a Multi-Season Mode file, the number of entries in the Expansion Roster can get quite large. This command allows the user to consolidate multiple player entries for a specific season into a single composite entry.

 

Alternatively, all entries for all seasons can be condensed to one entry per season. Once executed, individual player names for the selected year will no longer appear.

 

When invoked, the user will be prompted for the parameters in Figure 15-7. The dropdown list will show the seasons that have more than one entry and therefore are candidate(s) for consolidation. After completion, the results will be reported. Then, the dialog will reappear for another operation if there are any additional seasons available.

 

Screen shot 2013-08-29 at 3

Figure 15-7  Consolidate Expansion Roster Options Dialog

TIP:

To consolidate the stats for all but a select set of players in the Expansion Roster:

 1) Use the Transfer Player Stats command to temporarily move the stats that you do not wish to consolidate to the Active Roster.

2) Run the Consolidate Expansion Roster command and click on the Select All Seasons option

3) Finally,use the Transfer Player Stats command to transfer the players back to the Expansion Roster.

15.7                          Resolving Issues From Imported Stats

A number of potential issues can arise when importing statistics from different seasons, tournaments, playoffs, etc. The SBC provides mechanisms for dealing with the most common issues that may occur.  The supporting commands are in the Player menu (Section 15.6.1).

15.7.1                    Incorrect Player Name

A situation may occur where a player’s name may have been entered in the roster differently (eg: spelling) in different stats files. The Merge Player Stats command (Section 15.6.1.2) can be used to resolve this situation by combining the stats into a single player entry.  In addition, the traditional Rename Player (Section 6.2.3.2) and Transfer Player Stats (Section 6.3.7.5) commands may be useful.

15.7.2                    Player Exists in Both Rosters

This could occur after importing if a player existed in different rosters in different stats files. The user will be alerted to this situation at the completion of the import process. Duplicate player names will be flagged with  >>> in the Expansion roster. To resolve this issue, rename one or both of the player names with a unique identifier with the Rename Player command.

 

Alternatively, use the Merge Player Stats command (Section 15.6.1.2) to merge them into a single entry. All individual Season statistics will be preserved. The resulting stats entry can reside in either the Active or Expansion roster. The Check Roster command (Section 15.6.1.1) can be used to insure that all of these situations have be resolved.

15.7.3                    Modifying the Stats File Description

It may be desirable to alter the Stats File Description for a particular block of stats. This might be necessary if the naming strategy has changed for the individual stats files or an error was detected in the Stats File Description spelling. The Rename Stats Season command (Section 15.6.1.3) is used to accomplish this. 

change stats season

Figure 15-8  Season Selection Dialog

The user is first prompted for the desired Stats File Description to be changed (Figure 15-8).  This will be followed by a prompt to enter the new Stats File Description value. The new entry will be verified for a duplicate conflict. All player statistics matching the original identifier will be changed to the value.

15.7.4                    Removing Stats Based On the Stats File Description

This situation may occur if it is determined that a wrong set of statistics had been imported.  The removal can be accomplished for all players stats matching the Stats File Description via the Delete All Players Stats By Season command (Section 15.6.1.5).

 

A single player’s stats can be removed via the Delete Player Stats By Season command.

15.8                          Calculating Batting Leaders

This capability operates essentially the same as in the Single Season mode (Section 6.4). The only difference is that a Game Range cannot be specified due to the lack of individual game statistics.

Two types of leaders are calculated in each selected category:

  • Composite leaders for all seasons.
  • Optionally, the top leaders for a single season 4.10

 

The default AB or PA eligibility value for AVG, OBP, SLG, and OPS is based on the maximum number of games played in the composite stats and the Leaders parameters in the Batting Leaders Preferences command. Alternatively, the user may override this value by selecting a minimum number of games played or a specific number of AB or PA.

 

The user may choose to include or exclude players from the Expansion Roster in the leaders calculations.  Exclusion might be desirable if a number of players have been aggregated into a single entity (eg: all substitutes) and therefore might produce a misleading leader in one or more categories.

career stats parameters

The single season parameters dialog includes a calculation of the Average Games Per Season for reference. The default Minimum PA/AB with be calcuated based on this parameter. Modify the value as desired.

career single season stats parameters

15.9                          Division Standings

The importing of Division Standings from external Team Worksheet files is not currently supported. However, the user may still update these manually and compute the results as described in Section 5.1.

15.10                      Creating a Web Site With Multi-Season Stats

15.10.1                One Step Web Site Mode

As in Single Season Mode, the user may create a web site using the One Step Web Site command as described in Sections 9 and 14.  The web site will be a standalone set of files with its’ own home page. It is recommended that the user place these files in a unique folder, especially if a main team web site exists for Single Season stats.

 

The content of the Multi-Season Mode web site is essentially the same as for Single Season Mode with the exception that the Box Score will not be included.  The User Notes capability can be deployed to contain additional information regarding the multi-season stats.

15.10.2                Cross-Linking to Main Team Web Site

The user can link the navigation of the web sites together by configuring the web site parameters using the Edit / Web Page Composer Preferences / General and the Edit / One Step Web Site Preferences commands for each set of files.  The user should be familiar with the enhanced web site capabilities (Section 14.3).

 

Consider a configuration where the two sets of web site files reside in two different folders, identified as “career” and “2014”. To achieve this configuration, the basic web file sets must be generated to reside in their respective directories. This is accomplished by the Web Page Composer Preferences / General settings show in Figure 15-9:

 

ss general prefs career general prefs

Figure 15-9  Web Page Composer General Preferences For Linked Web Sites

Note that the Prepend Base URL settings are set to the respective folder names for each set of files.

 

To achieve the proper navigation link settings, the respective One Step Preferences are configured as shown in Figure 15-10. 

 

Pictureclipping 2

Figure 15-10  One Step Web Site Preferences For Linked Web Sites

The basic Home Page Navigation for each site is configured as follows:

 

Home Page Navigation – Single Season Mode File

The label home defines the teams’ primary web site home page. The link points to the home page for the teams’ primary web site. The resulting home page URL would have its’ Base URL added to produce:

 

/2014/aces_home_page.html.

 

Home Page Navigation – Multi-Season Mode File

The label career home defines the primary home page for the multi-season web site. The links point to the home page for the multi-season web site. The resulting home page URL would have its’ Base URL added to produce:

 

/career/index.html.

 

The cross-site navigation is achieved by configuring the User Defined Navigation Links as follows:

 

Cross-Site Home Page Navigation – Single Season Mode File

The label career home refers to the web site home page for the multi-season stats. The link points to the home page to the multi-season stats web site.

 

The link is defined as:  

/career

which will default to:

/career/index.html.

 

Cross-Site Home Page Navigation – Multi-Season Mode File

The label aces home refers to the primary web site home page. The link points to the home page for the primary web site.

The link is defined as:  

/2014/aces_home_page.html

 

Note that each of the web sites have chosen to deploy different uses of the User Notes area capability.

The available Home Page Content settings are different in the Multi-Season Mode as the Box Score is not included.

 

Note that the masthead banner text is different for each site to aid in site identification.  Other attributes such as color differentiation could also be employed as desired via the Web Page Composer Preferences settings for each site.

15.10.3                Resolving Problems

It is desireable to generate each web site as a standalone entity first. This will assist in resolving the basic issues that might arise. Once this is satisfactory, then proceed to incorporate the cross-linking capabilities as desired. The techniques in Section 14.4.6 can be helpful in resolving these problems.  contact SBC support at support@sbc.aces-softball.com if you are still having difficulties obtaining the desired results.

 

 

Return to Table of Contents

 


 

16                USING THE SBC WITH 3rd PARTY MOBILE STATS APPS

16.1                           Overview

A number of popular commerical apps exist for capturing baseball and softball statistics on mobile devices such as the iPhone/iPad/iPod and Android platforms.

 

The SBC supports batting stats that have been captured on the following mobile apps:

 

iScore Baseball/Softball – iPhone, iPad and Android

6-4-3 Baseball Scorecard - Android

K-ForCE – iPhone/iPod

 

The statistics are extracted from the app via an export file and are subsequently imported and merged with existing statistics into an SBC Single Season Mode Team Worksheet.

 

It is assumed that the user has a legal copy of the mobile app. If the user intends to use the app simply as a mobile stats capture device with the SBC, it is not necessary to be proficient in the full suite of the apps’ functionality. Only the basic operations to set up a roster and capture statistics for a game plus the proecedure to export the stats into a file are needed.

 

Rosters can be exported from the SBC to a file for subsequent importing by the app. This aids in setting up the app for use with the SBC. Note that not all mobile apps support this capability. However, most allow copy/paste operations.

 

Support for other mobile apps are possible. Contact SBC support at support@sbc.aces-softball.com if there is a particular app of interest.

16.1.1                    Statistics Imported

The SBC can import batting statistics on a game-by-game basis for either the home or visitor team.  The SBC can process the statistics shown in Table 16-1 from the app. In some instances, the abbreviations are different.

 

Some apps do not track/export some specifics stats that are tracked by the SBC.  Where possible, the SBC will attempt to compute these.

 

Statistic

iScore

6-4-3 Baseball

K-ForCE

Team Name

Game Number

SBC Stats File Description

Plate Appearences

Runs

Hits

Doubles

Triples

Home Runs

Runs Batted In

Walks

Total Strikeouts

Hit by Pitch

Sacrifice Bunts

Sacrifice Flys

Stolen Bases

Reached on Error

Fielders Choice

Position

Fines

-

-

-

PA

R

H

2B

3B

HR

RBI

BB

SO

HBP

SCB

SF

SB

ROE

FC

Computed by SBC

-

Home or Away team

-

-

Computed by SBC

R

H

2B

3B

HR

RBI

BB

SO

HBP

SACB

SACF

SB

 

-

Computed by SBC

-

Home or Away team

-

-

PA

R

H

2B