Excel Roster BLOOD BOWL SEVENS v.5.2 English, Español, Deutsch, Français, Italiano (14.03.2024)

For Fantasy Football related chat that doesn't come under any of other forum categories.

Moderator: TFF Mods

User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Excel Roster BLOOD BOWL SEVENS v.5.2 English, Español, Deutsch, Français, Italiano (14.03.2024)

Post by dreamscreator »

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

Blood Bowl Sevens Roster v.5.2

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 :)

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
lunchmoney
Legend
Legend
Posts: 8879
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: Excel Roster BLOOD BOWL SEVENS v.1.0 English, Español, Deutsch and Français (24.08.2021)

Post by lunchmoney »

Noice

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.1.1 English, Español, Deutsch and Français (24.08.2021)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.1.2 English, Español, Deutsch and Français (18.10.2021)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
lunchmoney
Legend
Legend
Posts: 8879
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: Excel Roster BLOOD BOWL SEVENS v.1.2 English, Español, Deutsch and Français (18.10.2021)

Post by lunchmoney »

Skaven 7's have Masters of Undeath and Sylvanian Spolight in your sheet 1.2.
Capture.JPG
You do not have the required permissions to view the files attached to this post.

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.0 English, Español, Deutsch, Français, Italiano (18.10.2021)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.1 English, Español, Deutsch, Français, Italiano (20.12.2021)

Post by dreamscreator »

Update v.2.1

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.2 English, Español, Deutsch, Français, Italiano (27.12.2021)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
eldritchfox
Veteran
Veteran
Posts: 231
Joined: Wed May 25, 2011 6:37 pm

Re: Excel Roster BLOOD BOWL SEVENS v.2.2 English, Español, Deutsch, Français, Italiano (27.12.2021)

Post by eldritchfox »

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

Reason: ''
Image
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.2 English, Español, Deutsch, Français, Italiano (27.12.2021)

Post by dreamscreator »

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 ;)

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.3 English, Español, Deutsch, Français, Italiano (10.01.2022)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.4 English, Español, Deutsch, Français, Italiano (12.02.2022)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.2.6 English, Español, Deutsch, Français, Italiano (02.04.2022)

Post by dreamscreator »

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
dreamscreator
Star Player
Star Player
Posts: 620
Joined: Thu Apr 24, 2014 1:03 pm
Location: Valencia (Spain)
Contact:

Re: Excel Roster BLOOD BOWL SEVENS v.3.0 English, Español, Deutsch, Français, Italiano (01.05.2022)

Post by dreamscreator »

Update v.3.0

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

Reason: ''
Image
Champion: Chimera Cup '17, Coffee Cup '18, Manticore Mug '18, Lucentum Twinbowl '20, Squig Trophy II '20, No me toques los Gnoblars '21
Stunty Cup: Exebowl '14; Bubba Bowl '17; OlletaBowl '20
User avatar
Wifflebat
Emerging Star
Emerging Star
Posts: 476
Joined: Sun Feb 02, 2014 5:56 pm
Location: Ohio, USA

Re: Excel Roster BLOOD BOWL SEVENS v.3.0 English, Español, Deutsch, Français, Italiano (01.05.2022)

Post by Wifflebat »

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

Reason: ''
I was Puzzlemonkey, but now I'm Wifflebat. Please forward my mail...
Post Reply