Talk Fantasy Football

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

BB2020 & DEATH ZONE Roster League v.8.0

BB2020 & DEATH ZONE Roster Tourney v.8.0

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.

You have the option to set tournament rules such as skills being free or having a free chef or bribes. It will also tell you if you have exceeded the amount of skills you are given for the tournament or if you have spent or have money left over.

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

Any suggestion of improvement or feedback is more than welcome to improve it.

All sounds good. I'll take a browse on pc when time allows

this is absolutely fabulous! Thank you very much for your work!

lunchmoney wrote: ↑Sat Jan 09, 2021 9:08 pm All sounds good. I'll take a browse on pc when time allows

Saebelsultan wrote: ↑Sun Jan 10, 2021 1:37 pm this is absolutely fabulous! Thank you very much for your work!

Thanks both of you. I hope it's useful and you like it

Update v1.3

Corrected error with the message "You haven't enough SPP".

Update v1.4

-Corrected error when “TR/MGN” was activated in the player #1
-Added gnoblars from Ogres to the special rule Low Cost Linemen
-Now you can add manually money to the treasury

Update v1.5

-New feature: it shows cp left to built your team (by default 1000k for leagues)
-Corrected error Ball and Chain counting as Big Guy
-Corrected Chaney error in the wrong group of teams
-Corrected experience costing error and new skills value increase

Nurgle Rotters have AG3+, should be AG4+.
Slann Linemen have Loner 4+.
Dedicated fans cannot be 0, at least 1.

This things are the part of a team:
-re-rolls
-cheerleaders 10k
-assistants 10k
-dedicated fans
-apothecary

Other extras are the inducements.
Maybe it should be separate in some way?

Anyway, good work!

Pieta wrote: ↑Thu Jan 14, 2021 11:35 amNurgle Rotters have AG3+, should be AG4+.
Slann Linemen have Loner 4+.
Dedicated fans cannot be 0, at least 1.

Thanks! I will have a look and correct them.

Pieta wrote: ↑Thu Jan 14, 2021 11:35 amThis things are the part of a team:
-re-rolls
-cheerleaders 10k
-assistants 10k
-dedicated fans
-apothecary

Other extras are the inducements.
Maybe it should be separate in some way?

I have been working on it. Three separated fields: Cost players availables (with the cost from just the players in your roster), Cost of Extras (rerolls, apo, cheerleaders, assistants) and Cost of Temporary Inducements (for Star Players and the rest of inducments).

I don't like "Cost of Extras" but I don't know which other name give it.

Update v1.6

-Corrected error with blitzers human and dwarf from Alliance
-Corrected incorrect stat from Rotter
-Eliminated skill Loner from Slann linemen
-Corrected cost Troll Slayer
-Corrected Dedicated Fans. It start always with free 1, it can be maximum 6. The cost it’s included in the team cost but it isn’t included in the team value

This is magnificent mate, thank you!

Looks great. Was trying it out with Halflings and their Master Chef is priced at 150k instead of 100k.

ceetee wrote: ↑Sat Jan 16, 2021 8:32 am This is magnificent mate, thank you!

Thank you ceetee!

Stout Youngblood wrote: ↑Sun Jan 17, 2021 12:48 am Looks great. Was trying it out with Halflings and their Master Chef is priced at 150k instead of 100k.

Which version were you using it? I have updated to v2.0 and it's fine now

Update v2.0

-Added German language, thanks to the translation of Coach Grog.
-Added French language, thanks to translation by Fennec
-Added option to add more than 1 NI
-Added option in tournaments to limit skills and attributes by money
-Added option to choose Chaos Gods
-Fixed Big Guys limit on Wood Elf Treeman
-Improved conditional formats