The Halfling Scribe's League Management Excel Workbook V3.03 is © Tim Ibe in Jan. 2007.
This workbook is offered to the Blood Bowl community free of charge.
 
  This work is build on intellectual property of Games Workshop and acknowledges this. This sheet is made to be used with a boxed set of Games Workshop's BloodBowl game and can not replace it.
If you found this sheet on a different web site than mine please contact me!
 
 
  Features:        
  - Manages a complete league of Blood Bowl teams with league ranking, top 25 team and player statistics for several categories.  
  - Manages all team sheets, calculating SPP, team value and monitoring player position maximums, skill proression and inducements.  
  - Complete database of all positional players for all races and all star players according to LRB 5.0.  
  - Helps you to plan your next match with full support of all possible inducements as well as Journeymen.  
 
  How to use this Excel workbook:  
  - Use Sheets T1 to T4 for your teams in consecutive order.  
  - When building a team, start with selecting a race. RR cost will be determined and availiable positions can be selected by drop down box.  
    Everything else will be entered and calculated automatically, you just have to change the fields with the yellow font, do not touch the ones with white font.  
  - A team name is required, player names are optional, but very useful for the Top25 stats.  
  - If you need more than 4 team sheets, copy the sheet 'Team Template' to a new sheet named 'Tx' with x being the next consecutive team number.  
    To do this, rightclick on the sheet 'Team Template' and select Move/Copy, then flag 'Make a Copy' and press OK. To rename the new sheet,  
    doubleclick on the sheet register.  
  - If a player gains a skill, select the skill from the dropdown in the green 'Improvements' area. The skill will be added into column K and you don't have to  
    overwrite the formula there. Profile upgrades and downgrades (ST+, MA-, etc.) will now be automatically calculated into the players profile. Just select  
    upgrades in the skill boxes and write downgrades into the 'Injuries' box at the end of the green 'Improvements' area.  
  - You can easily retire a player to the HallofFame, by placing the selection on the player's row in the teamsheet (Tx) and calling the RetirePlayer macro by  
    pressing CTRL+SHIFT+R.  
  - To plan the inducements for next game, you can select Star Players and Mercenaries using the dropdown lists, as well as other inducements by entering  
    the number purchased. If you play with cards, you can also state an amount reserved for card purchases.  
  - The sheet will tell you when you are able to use Journeymen. To add a Journeyman, add a lineman position in an empty slot of your roster and select   
    'Journeyman' from the dropdown in the status field (column P).  
  - Try not to delete formulas and NEVER DELETE A COMPLETE ROW OR COLUMN. This may delete important formulas in hidden cells. The sheets are  
    protected to avoid this happening accidentially. However, the sheets are not password protected, so if you want, you can mess them up.  
  - All race, position and star player data is stored in a hidden sheet called ""Database"". In that sheet you'll also find the point scheme for league ranking and   
    several other customizing options. Please be careful when editing that sheet.  
  - If your sheet does not update properly, it's Excel's fault. I found out it's a little lazy sometimes ... save it and press F9 to recalulate, this will fix it.   
     
 
  Maximum league size Current league size:   Contact:  
  max. 25 teams 15 teams   halflingscribe@gmx.net  
  max. 500 players 201 players   http://bbowl.gmxhome.de/scribe  
  max. 500 matches 52 matches      
  max. 100 HallOfFamers 22 players