Softball/Baseball Team Calculator

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 Version 2016. 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  3.99 . 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  3.97. 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   3.97. 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  3.97. 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  3.97. 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  3.97. 47

5.3    Game Number Manager  3.97. 47

5.4    Schedule Exporter  3.97. 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     One Step Web Site Processing Summary. 70

9.3    Notes on Generating Web Sites. 71

9.3.1     File Name Conventions. 71

9.3.1.1    Player Filename Encoding. 71

9.3.2     Game Range Parameter Validation. 71

9.4    Options. 71

9.4.1     Incorporating User Notes Area as a Web Page. 72

9.4.1.1    User Notes Web Pages Content and Layout 72

9.4.1.2    Zebra Striping. 72

9.4.2     Game Schedule and Results Page. 72

9.4.3     Current Weather 72

9.4.4     Graphics, WebClip and Favicon Icons. 73

9.4.4.1    Masthead Logo File. 73

9.4.4.2    WebClip Bookmark Files. 73

9.4.4.3    Favicon Icon File. 73

9.4.5     Additional Options. 74

9.5    Caching of Web Sites. 74

9.6    Search Engine Indexing of Web Pages. 74

9.6.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    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.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   Banners Text Color 99

14.3.2.4   Content Block Fill Color 99

14.3.2.5   Zebra Stripe Color 99

14.3.2.6   Font Family Override. 99

14.3.2.7   Default Worksheet Font Family and Text Color 100

14.3.2.8   User Notes Web Page Processing. 100

14.3.3    Masthead 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 Graphics 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 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

APPENDIX A - DEFINED HTML WEB COLOR NAMES. 132

A.1    SRGB Color Names. 132

APPENDIX B - EXCEL COLOR VALUES. 135

B.1 Excel Color Index Values Conversion. 135