Talk Fantasy Football

I have created a fully automated roster in Excel with BB2020 rules in English, Spanish, German, French and Italian.

Blood Bowl Sevens Roster v.7.1

This roster calculates player and incentive costs as well as experience points. It also calculates the experience points expenditure according to the raises and cost increase of the players. They are highlighted with colours when the attributes go up or down, or if the player is MNG.

It also keeps track of matches and calculates your winning ratio, your average TD per match and much more.

The roster is compatible with Google Sheets, so you can use it online. Also include player cards which are filled automatically.

Any sugestions or point errors are welcome

Noice

Update v1.1

-Add the special rule “Masters of Undeath” to Undead and Necromantic
-Corrected translation in French “Poignardilité” by “Stabilité”
-Unblock logos and card picture cells
-Corrected the rerolls
-Corregido el error de razas que faltaban

Update v1.2

-Fixed error in counting matches won, drawn or lost with home result of 0
-Fixed the Animosity skill in Pact coming out in German instead of English with English language
-Fixed error in the fourth skill that didn’t count SPP cost
-Fixed error in the total sum of inducements costs
-Fixed duplicate race error in race selection
-Fixed error with maximum number of non-line players exceeded in Lizardmen

Skaven 7's have Masters of Undeath and Sylvanian Spolight in your sheet 1.2.

Update v.2.0

-Translated into Italian
-Added Spike 13
-Corrected Bloodweiser Barrels could only take one instead of two
-Corrected doctor that vampires could not pick up
-Corrected the race list
Changed four-digit numbers to seven digits
-Revised cell sizes to fit better when printing
-Corrected Chaos Dwarves couldn’t take White Dwarf
-Added a treasury cell in the Games tab to be able to start the league with more money.
-Added a cell to modify the price and spp of the skills manually, in case you don’t choose an attribute increase and you choose a secondary or primary skill.
-Fixed problem with NI

Update v.2.1

-Small corrections on the Italian translation
-Fixed the prize of Morg and Hakflem as per GW FAQ

Update v.2.2

BLOOD BOWL SEVENS ROSTER 2020:
-Added possibility to lose 2 Dedicated Fans in the Games tab
-Added the option to add free Dedicated Fans for second seasons

Hi. Do you plan to create a spreadsheet for Dungeon Bowl colleges?

eldritchfox wrote: ↑Thu Dec 30, 2021 3:37 pm Hi. Do you plan to create a spreadsheet for Dungeon Bowl colleges?

Yes, that's one of my plans when I have a bit of time. I have started to work on it

Update v.2.3

BLOOD BOWL SEVENS ROSTER 2020:
-Fixed error with team value
-Deleted links which cause alert
-Added option to start with 0 Dedicated Fans
-Fixed error in the race list

Update v.2.4

BLOOD BOWL SEVENS ROSTER 2020:
-Translated and fixed: draw, win and loss in the Games tab for each match.
-Solved that 0-0 was not counted as a draw in Games tab
-Changed DF option to -2 per game
-Resolved the limit for non-line Wood Elf players

Update v.2.6

BLOOD BOWL SEVENS ROSTER 2020:
-Corrected the appearance of Chosen or Random instead of the skill name
-Fixed the player’s value being manually modified next to the player skills
-Added cell in the Games tab to indicate the treasury spent on incentives

Update v.3.0

ALL ROSTERS
-Add the new Norse GW roster, star players and inducements

When I try to make a Wood Elf team, I get Amazon players in the dropdowns. Just me? Am I doing something wrong?