This is a compilation of pertinent instructions and header row hints embedded in SuperSweeperScore. It was created because some users said they would like to have a manual they could print out or view separately on screen from SuperSweeperScore.
This file is current as of May 3, 2013, and matches SuperSweeperScore version M3.
Although you may wish to consult Microsoft manuals on how to generally operate Excel – and we don’t mean to repeat their entire manual here – these fairly detailed instructions should be sufficient to teach you everything you need to know to run Excel in general and to operate all the features of SuperSweeperScore quite well, even if you have never used Excel previously.
Games & Totals Worksheet
Basic lessons: (In Column A)
Welcome:
Welcome to the world of RCP Software featuring cutting edge data management software. This software features a self-teaching tutorial. To take the lessons, just pass your mouse over the cells below which contain a red triangle in the corner. For additional details on the regular features of Excel, such as printing, screen display, etc. consult your Microsoft Manuals and the Microsoft Help menu. However, what you will need to know is covered in the RCP Software instructions.
There is some sample data entered on the Games & Totals worksheet, in both the men's and women's sections. And there is some in the Team Names column, Column AO. After you have familiarized yourself with how SuperSweeperScore works, you can remove the sample data using the Clear Contents command on your right mouse button. Also please return the Handicap Per Game amounts to 0 in Column F. Then you may save the cleared file as a template on your hard drive. Then, each time you run an event, you will open a copy of that stored template using the New command on the File menu. All the data fields will then be blank. And you will give the copy a name that describes the tournament event, usually including the date, then save it to your hard drive.
If you inadvertently foul up some cells while learning, remember that you still have an undisturbed master copy on disk. You can copy that file to your hard drive later, then use Clear Contents to prepare it as a blank template for future use.
Lesson 1: Some basics
RCP SuperSweeperScore is a customized spreadsheet-type database powered by Microsoft Excel. It can be customized by adding one or more event scoring modules (also referred to as results sheets) to the basic team and mixed doubles scoring modules. Depending on which event modules you purchased, some instructions may not apply.
Most of you have used Excel previously but for those of you who have not, the general instructions below (Lessons 1-16) should help you get around an Excel spreadsheet pretty well. If you have never used Excel or any spreadsheet application before, you may want to also read some of Microsoft's general instructions. EVEN IF you're an experienced Excel user, you still need to quickly read Lessons 1-16 to get the parts that apply specifically to this customized application. Okay, here we go with spreadsheet basics.
Spreadsheets have numbered rows (1, 2, 3, etc.) and lettered columns (A, B, C, etc.)
The top row contains column titles or headings and is known as the Header Row. DO NOT change any of the column headings except where it is specifically mentioned that you may do so.
Rows and columns contain cells. Cells are designated by column and row. For example, this lesson is contained in cell A5. If you click on a cell with your mouse, or move there with the cursor arrows, it becomes the Active Cell. The active cell will have a bold border. The Active Cell is "where you are" at any given moment.
You can also move through a spreadsheet with the Enter and Tab keys. At this time, make cell S5 the active cell. Then try the Enter key, followed by the Tab key so you can see what happens. Then try the cursor keys. Good! You're on your way.
Lesson 2: Color codings
In this application, there are some standardized color codings to assist you. The dark blue background cells in Column I indicate men and the pink background cells (starting at Row 202) indicate women. In mixed leagues, be sure to put everyone in the right section!
For the few huge all-male leagues that have more than 200 bowlers (we have heard there are a few), you can ignore the male/female distinction and just put the men in right down this worksheet in Column I, all the way up to 400 bowlers. For such leagues, the "Mixed Doubles" results sheet would not be used for round robin or even opt-in doubles. Instead, the Generic Doubles scoring module would be used, at least up to a limit of 200 bowlers (115 from men's section; 85 from women's) in the Basic Generic Doubles module or up to 325 bowlers in the Enhanced module. Also note the Generic Singles results sheet which can accommodate 400 bowlers.
One cardinal rule to remember: If it's white, that's where you write; IF IT'S GRAY STAY AWAY!
NEVER CHANGE OR DELETE ANY DATA IN A GRAYED AREA.
Cells with a gray background are computed columns or contain data that is not to be changed by the user. If you accidentally alter such a cell, immediately use the Undo command to backtrack and restore what you damaged. You can't just manually replace some number that you saw in the gray area. There is usually code hidden underneath and that can only be replaced by using the Undo command. There are also some cells with colored backgrounds (e.g. light green) that likewise you must not change. There are cautions about these in header row cells comments.
There are also some colored cells that contain computed results that you cannot alter even if you try. See for example Column AP and to the right of that on this sheet.
If you see something in red text, that's to get your attention. As an example, the designations for fives, threes, and fours in Column AM on this sheet are in red to remind you to scroll down to the right section before entering team names.
Lesson 3: Worksheets
The page you are looking at now is called a worksheet in Excel. The entire file is called a workbook. This workbook contains a number of customized worksheets. Look down at the bottom of the page and you will see what look like tabs. Each tab is connected to a worksheet. You can move to a different worksheet by clicking on its tab. You can also use Ctl + Page Up or Page Down.
The present worksheet is where you will enter the core data such as bowlers' names, their scratch scores, their handicaps, team names, etc. The other worksheets are generally used to sort results for specific events such as the team event, mixed doubles, or women's singles. As explained later, you may also be making limited data entries on some results sheets to indicate entry into pot games or entry into doubles events by the alternative opt-in method. You may also mark bowlers as continuing qualifiers in an elimination event. And after you have your results, you may be importing a payout list from DivvyItUp! or some other source.
Lesson 4: Data entry/clear
You enter data in a cell by making it the active cell, then just typing in the data. Then just move away with an arrow, Tab, or Enter key. Any associated results are calculated when you exit the cell. Try entering some sample data in a cell or two now. To remove data, use your right mouse button and click on Clear Contents. Do NOT use the Delete key or command. You may clear data from a group of cells by highlighting them as a group and then using the Clear Contents command. It's on the shortcut menu which you access with your right mouse button.
NEVER clear or delete or change the contents of any grayed cell. If you accidentally do so, immediately use the Undo command to restore the data and the code contained in the cell. Grayed cells generally contain code underneath what you see. If you manually change anything in such a cell, and do not immediately UNDO what you just did, you will likely damage the data management code irreparably.
And here's a hint as to how to clear a lot of cells quickly if they are grouped together. To clear all the data in columns Game 1, Game 2, and Game 3 (as you will do after learning the software), make the active cell the top blank cell in a nearby totally blank column such as Column Game 4 in this worksheet. Hold down the Shift key. Press End, then the down cursor arrow. That highlights the entire column. Then press the left cursor arrow until the columns are highlighted over through Game 1. Then use the Clear Contents command on the right mouse button. Do the same kind of thing from Columns Match Team Number and RR Gen D to quickly clear all the nearby sample data in those areas.
Lesson 5: Saving Files
For each new sweeper or other event you score with SuperSweeperScore, save the new file with a name to indicate the date and title such as Merced Sweethearts Sweeper 20100825.xlsx to indicate a sweeper bowled on August 25, 2010. Save the workbooks in some convenient folder so you can refer back to the results in case someone asks you about them later.
Each new file is a copy of the template. The template remains unaltered.
Lesson 6: Classic menus option
If Microsoft's ribbon drives you nuts, and you generally like to get commands from the toolbar menus, you might want to get a tool from www.addintools.com that restores the classic menus so you can find things. Instructional references here will be to the classic menus and commands, primarily, which are also found on the right mouse button shortcut menu.
Note that the commands that you are most likely to use in this application are also generally on the right mouse button shortcut menu and that's where most people go to get to those commands.
Lesson 7: Data sorting
When it comes time to sort data to determine how people did, go to the Sort command on the Data menu or just use the right mouse button to get to the Sort command on the shortcut menu. For multi-level sorts use the Custom Sort choice. Always make sure the active cell or where you click is inside the range of data to be sorted. If you are on the other side of a sorting barrier (solid colored cells) or outside the range of data to be sorted, the Sort command will not work.
Take a look at that Custom Sort dialog box now. You will generally do a Sort On "values." You can select the column or columns to sort in the Sort By part.
You can add a second, third, etc. level of sorting by clicking on the Add Level button. If you are using a sort level to isolate at the top those who are in an event as opposed to those who are not, always sort by that value first. An example of that is found in events such as Mixed Doubles where you will sort at the first level by either Round Robin or Opt-In, largest to smallest, to bring the entrants to the top. Then you will sort at the next level by the scores, largest to smallest.
Lesson 8: Splitting
You may find it convenient to look at something way to the right and something way to the left at the same time. Or you may want to line up columns side by side or panes one above the other. At this time try the Split command on the Window menu (or Window group on the View ribbon) or just enter Alt, w, s. There is already a horizontal split bar in the default configuration of this worksheet. It's just below the Header Row. The Split command is a toggle switch. Alt, w, s will remove the default split bar.
Create a horizontal split bar by selecting a row first. Then use Alt, w, s. Then remove it.
Next, create a vertical split bar by selecting a column first. Click on the letter at the top to do that.
Next, create both vertical and horizontal bars by selecting a cell before using the Split command. Note where the split bars appear (above and to left) and try out the horizontal and vertical scrolling to get the feel of independently scrolling sections.
Try creating a horizontal split bar, then switching from the top pane to the bottom pane with Shift + F6, and back again with F6.
Note that if you highlight Row 2 (click on the #2 at the far left), then use the Split command, you can now vertically scroll through data while leaving the Header Row visible. That is the default setting.
You can move a split bar around the screen by grabbing it with your mouse and dragging it around.
Splitting the window into two panes, one above the other, is very useful when initially entering names for a mixed league. You can easily switch back and forth between entering men and entering women as you go down the league sheet.
Lesson 9: Pre-sorting
At this time take a quick look at the other worksheets to get a feel for what the various results worksheets that you purchased look like.
Just make a mental note at this time that before you use any of the non-team worksheets, you must FIRST pre-sort the Games & Totals worksheet by Event ID# in ascending (smallest to largest) order. That is the default position.
Before you use any of the team worksheets (Fives, Fours, Trios), you must FIRST pre-sort the Games & Totals worksheets by Team # in ascending (smallest to largest) order. This is the pre-sorted position most secretaries use while entering scores because that sorting makes it easy to find bowlers by their team number.
IF YOU DO NOT HAVE THE G&T WORKSHEET PRE-SORTED AS REQUIRED, NONE OF THE RESULTS ON THE RESULTS SHEETS WILL MAKE ANY SENSE.
Lesson 10: EasyEnter/Round Robin Doubles
At this time, scroll this sheet to the right gradually, noting the general layout. Columns RR Mxd D through RR Wom D are where you "enter" bowlers into various events, except for opt-in entries, which are explained below.