Author |
Message |
dreamscreator |
|
Post subject: Excel Roster BB2020 & DEATH ZONE v9.0 En, Es, De, Fr, It
Posted: Jan 21, 2021 - 05:21 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
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.9.0
BB2020 & DEATH ZONE Roster Tourney v.9.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. |
Last edited by dreamscreator on Nov 13, 2024 - 08:39 AM; edited 19 times in total
|
|
|
|
|
tzoscey |
|
Post subject: RE: Excel Roster BB2020 v.2.0 En, Es, De and Fr
Posted: Jan 23, 2021 - 11:07 AM
|
|
Joined: Oct 18, 2008
Posts: 2
Status: Offline
|
|
|
|
|
dreamscreator |
|
Post subject: RE: Excel Roster BB2020 v.2.0 En, Es, De and Fr
Posted: May 03, 2021 - 09:27 AM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
NOW WITH THE NEW INDUCEMENTS OF DEATH ZONE INCLUDED!!! |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Jun 20, 2021 - 05:22 AM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
Update v3.3
BOTH ROSTERS:
-Compatible with Google Sheets
-Fixed Ogre Kicker bug had pass as secondary
-Fixed bug Treeman AVM had ST skills as secondary and AG skills as primary
-Fixed bug on some teams when removing star player an error was shown
-Fixed bug when deleting some players because they had exceeded the minimum, others were left with their skills blank.
-Fixed bug with free skills and attributes for tournaments
LEAGUE ROSTER:
-Fixed bug “You have spent too much” message when adding skills to players
-Fixed bug journeys subtracting value from the treasury |
Last edited by dreamscreator on Jun 21, 2021 - 07:57 AM; edited 1 time in total
|
|
|
|
|
tulkas |
|
Post subject:
Posted: Jun 21, 2021 - 03:40 AM
|
|
Joined: Feb 09, 2012
France
Posts: 34
Location: France
Status: Offline
|
|
Thanks a lot Dreamscreator, that is very good ! And still no bugs to send you back |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Dec 19, 2021 - 03:03 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
Update v.4.0
BOTH BLOOD BOWL 2020 ROSTERS:
-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
BLOOD BOWL LEAGUE ROSTER 2020:
-Added a treasury cell in the Games tab to be able to start the league with more money.
-Added a cell to change the price and SPP of skills manually, in case you don’t choose an attribute increase and choose a secondary or primary skill.
-Added Partial Referee that was missing in the list.
-Fixed problem with NI
ROSTER BLOOD BOWL 2020 TOURNAMENTS:
-Added missing Partial Referee to the list.
-Fixed problem with SPP price and cost calculation. |
|
|
|
|
|
tulkas |
|
Post subject:
Posted: Dec 20, 2021 - 12:58 AM
|
|
Joined: Feb 09, 2012
France
Posts: 34
Location: France
Status: Offline
|
|
Oh no ... It was a perfect job, as always, but the Hackflem and Morg new prices are not implemented ... You can add this to your to-do list for the next update.
Thanks for the good work ! |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Dec 20, 2021 - 03:20 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
Update v.4.1
BOTH BLOOD BOWL 2020 ROSTERS:
-Small corrections on the Italian translation
-Fixed the prize of Morg and Hakflem as per GW FAQ |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Dec 20, 2021 - 03:21 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
tulkas wrote: Oh no ... It was a perfect job, as always, but the Hackflem and Morg new prices are not implemented ... You can add this to your to-do list for the next update.
Thanks for the good work !
Sorted! I completely forgot about the change of price of Morg and Hackflem XD |
|
|
|
|
|
tulkas |
|
Post subject:
Posted: Dec 21, 2021 - 12:57 AM
|
|
Joined: Feb 09, 2012
France
Posts: 34
Location: France
Status: Offline
|
|
Don't be sorry. That is an excellent work, happy to help !
Bravo |
|
|
|
|
|
tulkas |
|
Post subject:
Posted: Dec 21, 2021 - 03:21 AM
|
|
Joined: Feb 09, 2012
France
Posts: 34
Location: France
Status: Offline
|
|
hum, looks like Hakflem disapear from the star available, from Nurgle or underworld. Looks like there are mistake on the special rules for these team. They are not anymore favoured of nurgle or underworld challenge but sylvanian spotlight or Lustrian Superleague and Old World Classic.
edit : but price are good |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Dec 27, 2021 - 03:52 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
Update v.4.2
ALL THE ROSTERS
-Fixed bug with prices and special rules when removing Khorne Daemons
-Fixed players not being able to pick up passing skills
BLOOD BOWL LEAGUE ROSTER 2020:
-Added tab to create mercenaries that can be chosen later in the roster
-Added possibility to lose 2 Dedicated Fans in the Games tab
-Added the option to add free Dedicated Fans for second seasons
BLOOD BOWL TOURNEY ROSTER 2020:
-Added tab to create mercenaries that can be chosen later in the roster |
Last edited by dreamscreator on Dec 27, 2021 - 03:54 PM; edited 1 time in total
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Dec 27, 2021 - 03:53 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
tulkas wrote: hum, looks like Hakflem disapear from the star available, from Nurgle or underworld. Looks like there are mistake on the special rules for these team. They are not anymore favoured of nurgle or underworld challenge but sylvanian spotlight or Lustrian Superleague and Old World Classic.
edit : but price are good
Yes, in the previous version, data from different teams were crossed, now everything should be fine |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Jan 10, 2022 - 03:04 PM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
Update v.4.3
ALL THE ROSTERS
-Fixed error with team value
-Deleted links which cause alert
-Added option to start with 0 Dedicated Fans
-Fixed error in the race list
-Fixed Chaney was missing and Bryce was twice |
|
|
|
|
|
dreamscreator |
|
Post subject:
Posted: Feb 12, 2022 - 11:10 AM
|
|
Joined: Aug 04, 2014
Spain
Posts: 58
Location: Spain
Status: Offline
|
|
Update v.4.4
ALL ROSTERS
-Solved problem with missing Wood Elf players
-Changed price for Morg and Hackflem
-Added star players Kreek 'The Verminator' Rustgouger and Barik Blastfast
-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
LEAGUE ROSTER
-Added stadiums
-Added cost per player redraft option
-Modified DF option to -2 per match
TOURNEY ROSTER
-Fixed sum of skill costs
-Fixed bug with french language medic
-Added a team summary: cost, number of skills, star players, spp, etc.
-Modified default DF to 0 |
|
|
|
|
|
|