NAF Logo
leftstar Nov 21, 2024 - 11:06 AM
capleft
spacer
NAF World Headquarters
home forum rankings tourneys nyleague faq
Bribe the ref today! rightstar
capright

Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
dreamscreatorOffline
Post subject: Excel Roster BB2020 & DEATH ZONE v9.0 En, Es, De, Fr, It  PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
tzosceyOffline
Post subject: RE: Excel Roster BB2020 v.2.0 En, Es, De and Fr  PostPosted: Jan 23, 2021 - 11:07 AM



Joined: Oct 18, 2008

Posts: 2

Status: Offline
thanks man
 
 View user's profile Send private message  
Reply with quote Back to top
dreamscreatorOffline
Post subject: RE: Excel Roster BB2020 v.2.0 En, Es, De and Fr  PostPosted: 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!!!
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
tulkasOffline
Post subject:   PostPosted: 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 Smile
 
 View user's profile Send private message  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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.
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
tulkasOffline
Post subject:   PostPosted: 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 !
 
 View user's profile Send private message  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
tulkasOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message  
Reply with quote Back to top
tulkasOffline
Post subject:   PostPosted: 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 Smile
 
 View user's profile Send private message  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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 Smile

Yes, in the previous version, data from different teams were crossed, now everything should be fine Smile
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
dreamscreatorOffline
Post subject:   PostPosted: 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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2009 The Zafenio Team
Credits