Quick Introduction on how to use the Halfling Scribe League Management Sheet V2
1. Edit Team Sheets
The Halfling Scribe comes with only 4 empty Team Sheets named T1 to T4, but you can create up to 25 of them by copying the "Team Template" Sheet (see below). To enter your team, first select a race using the dropdown list (step 1 in screenshot), and enter a team name in the field above. By selecting the race, the sheet will determine availiable player positions and the reroll cost. Then select player positions from the dropdown list in the respective cells and the starting stats, skills and cost of the player will be determined automatically (2). Entering a name for your player is not required, but it helps to identify him later in the player statistics. Finally enter Rerolls, Fan Factor, Treasury, etc. to complete a starting team (3). After every change in the sheet, your Team Rating will be recalculated.
If the team advanches in league play, enter the completions (CP), touchdowns (TD), interceptions (IN), casualties (CS) and MVP awards (VP) into the corresponding cells (step 4). The sum of starplayer points (SP) will be calculated as well as its contribution to the team reating. If your player is awarded a starplayer roll, you can see the skill categories you can normally pick from in the "Picks" column. Enter any new skills or traits in the cell next to that ("Add. Skills"), the sheet will copy skills entered in that cell to the starting skills in the team sheet itself. If a player gains a stat increase, just overwrite the formula in that square, it will be restored if you use the macro to retire the player (see below).
To retire a player, the sheet provides a macro. I recommend to use this and not delete the player manually, because you might incidentialy delete a formula. Place the cursor on any cell in the row of the player to be retired and press CRTL+SHIFT+R (or call the macro "RetirePlayer" via the menu). This will remove the player from your team sheet (restoring all formulas by copying them from the team template) and add him to the "Hall of Fame" Sheet. In the Hall of Fame, you can enter a date of retirement, the reason why he stopped playing (most obvious: death) and a comment. All players of the Hall of Fame will still be part of the player statistics. If you want to remove a player from the hall of fame, just clear the cells (do not delete the cells themselves, they are referenced in formulas. The macro will fill empty lines between players, but you can also use the sort function to eliminate them (sorting by date, for example).
Everything else in the sheet (for example overall and current record) is done automatically. After entering some games and starplayer points, you can check the player stats to see who are your leagues dominating players.
2. Add More Team Sheets
If you want to manage more than 4 teams in your league, you will have to add team sheets. To do this, copy the "Team Template" sheet, by rightclicking the "Team Template" Tab, selecting Move/Copy, checking "Create a copy", then [OK] and afterwards renaming the sheet (doubleclick on the tab) to T5, T6, T7 or whatever the next open number is in your workbook (compare picture above). It's essential for the formulas that all team sheets are named consecutively from T1, T2, T3, ... up to T25 and that you not rename them to something else like the team name.
3. Enter Game Results
To enter game results, go to the results sheet (doh!). Both teams must be created in a teamsheet before. Select the teams that played from the dropdown lists, then enter touchdown and casualty score in the respective cells (the dashes "-" between home and away score are entered automatically afetr entering the first part of the result). Enter a date for the game and the gate (both optional). Finally select a game type to seperate games that are relevant for the ranking from those that are not. There are 4 game types defined, but you can change them (see below). The game type is used in the "Ranking" Sheet, where you select the types that count towards the ranking (usually only "Season" games will count to the current ranking), old games can be excluded from the ranking by setting them to "Old Season").
By entering the results, the "Team Stats" sheet will be populated automatically.
4. Changing the sheet
Most of the sheets are proteced against changes to avoid messing them up, however, there's no password on the protection, so you can unlock the sheet to make changes. If you make changes to the sheet, make sure you understand how everything works to make sure you won't mess it up. Additionally to the sheets described above, there's a hidden sheet called "Database", which carries all the setup information. Here you can change the ranking system (points awarded for win, loss, tie or per TD or CAS), the Game Types used in the "Result" and "Ranking" sheets, or the list of races and player positions. You can overwrite any existing values to change how the sheet operates or enter changes to the team lists.
If you want to add a new teamlist, first add it to the "DBTeams" range, then add the player position to the "DBPlayers" range with the "Race" fields containing the race exactly as written in the "DBTeams" range, plus a consecutive number added to the string without any separator. For example, if you add the race "Snotlings", the player positions race must be named "Snotlings1", "Snotlings2", "Snotlings3", etc.
Most changes to the Database sheet will require inserting new cells into the sheet. When doing this, you'll have to be careful not to mess up the names that refer to the ranges for use in formulas. All the ranges that have a reference name are marked with a frame around the referenced area. To insert a new row into this range, mark all the cells of a row of that range only, then select Insert->Cells (not Rows!!!). By this the name will be expanded automatically. To check if the name is still refering the right range, select Insert -> Name -> Define ... from the menu and check the reference of the named range you edited.