Blood Bowl page by Visa

Tämä sivu suomeksi

Spreadsheet template for a Blood Bowl team

Using OpenOffice Calc 2.0, I built a spreadsheet template for my own team. Then I found out that there already is an MS-Excel sheet for any team (arosteamroster.xls), checked it out and decided it might be useful if I changed it a bit to my own taste. Only most of it was locked, so I had to start from scratch.

Objectives:

The results:

With the exception of the completely Finnish version, the following templates have been upgraded according to the experimental 2008 living rulebook, with the addition of three new teams: chaos pact, slann and underworld.

Instructions for use

  1. Choose your team list from the upper right of the first page (cell O2).
  2. Choose the position of each player (cells B4 - B19).
  3. It's generally not a good idea to modify cells with a formula (they start with an equal sign: =).
  4. As an exception, it's easiest to simply write over the old value of MA/ST/AG/AV in case they change. Of course you can also add "+1" to the formula.
  5. The column M/N? is for players that miss the next game or have niggling injuries. Write anything with "m" as the first letter to cause the corresponding player to be ignored when calculating the team value.
  6. The rightmost column "incr." is for increases in the player value due to improvement rolls. For example, for a player that has learned two new basic skills and gained +1 AG, you'd put 80 (=20+20+40) here.
  7. The second sheet "matches" is for recording played matches. Nothing written there affects the first sheet "players" in any way.
  8. In MS Excel (using .xlt templates), the "N/M" column seems not to work - so if a player is missing a match because of a serious injury, the easiest way to make your team value appear correct is to write into the "incr." column a negative value that nullifies the standard cost of the missing player - for example, if a human lineman (value 50k) is missing a match, write -50 in the "incr." column. The other way to fix this is to figure out how to use regular expressions (or other string-searching functions) with sumif() function in MS Excel, which is something I'm not going to do.

Feel free to use (and modify) this template, just don't claim to have written it all yourself. And I'd like to hear your feedback.
Share and enjoy!

Visa