Can you not just rename the tabs? I hope so, that's what I did!zulu wrote:Fixing is not the correct word. I effectively have to do the whole thing again.Tojurub wrote:Since you have not submitted yet, you can still fix thatzulu wrote: I completely missed the part regarding the coach id and that they should relate to a specific position on the roster sheer.
WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
Moderators: lunchmoney, TFF Mods
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6626
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
-
- Experienced
- Posts: 136
- Joined: Sun Jan 22, 2012 10:52 am
- Location: Norway
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
From the newsletter....sann0638 wrote:Can you not just rename the tabs? I hope so, that's what I did!zulu wrote:Fixing is not the correct word. I effectively have to do the whole thing again.Tojurub wrote:
Since you have not submitted yet, you can still fix that
"whatever you do, PLEASE DO NOT CHANGE THE NAME OF THE TAB"
Reason: ''
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6626
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
Well, I just interchanged them. So they ended up the same...
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6626
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
Which messes things up, it seems. Bother. Time to start again...sann0638 wrote:Well, I just interchanged them. So they ended up the same...
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- Tojurub
- Super Star
- Posts: 824
- Joined: Wed Aug 20, 2003 5:56 pm
- Location: Lindau
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
yes, do not interchange them! People have done that, think we would not notice, but our automated macro will crash if you do that.sann0638 wrote:Which messes things up, it seems. Bother. Time to start again...sann0638 wrote:Well, I just interchanged them. So they ended up the same...

Reason: ''
Nuffle Sucks! Heretic, NBA
www.biboba.de
www.biboba.de
- Tojurub
- Super Star
- Posts: 824
- Joined: Wed Aug 20, 2003 5:56 pm
- Location: Lindau
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
Saebelsultan wrote:I don't think you have to. We will be asked after round 1 draw end of the month, I think. That is in the last newsletter I believe.sann0638 wrote:Ha, I missed this too. Bother. How do we say who we want on which board in game 1?
Newsletter, First Round wrote: While the draw of the squads will be done sometime in August or September, this tournament offers you a unique chance to decide your line-up for the first match. Captains have to submit the order of their squad-mates until September 29, 2019. If we do not receive any info from the captains, the order will be random. Have your best player start on the lowest table, put the Halfling coach at table 1 or expect a Chaos mirror match on table 3. Start the mind-boggling game of theory-bowling about what your opponent will come up with and how you can possible counter it the most efficient way.
Reason: ''
Nuffle Sucks! Heretic, NBA
www.biboba.de
www.biboba.de
- Tojurub
- Super Star
- Posts: 824
- Joined: Wed Aug 20, 2003 5:56 pm
- Location: Lindau
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
and just in case you guys missed more, which was written in the newsletter:
http://www.nafworldcup.sbbm-turniere.co ... ainsEN.pdf
http://www.nafworldcup.sbbm-turniere.co ... ainsEN.pdf
Reason: ''
Nuffle Sucks! Heretic, NBA
www.biboba.de
www.biboba.de
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6626
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
So how do we submit the order? Just in an email? Isn't there a super duper locked down spreadsheet? Anarchy!!!!
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- Tojurub
- Super Star
- Posts: 824
- Joined: Wed Aug 20, 2003 5:56 pm
- Location: Lindau
- Saebelsultan
- Super Star
- Posts: 760
- Joined: Wed May 07, 2014 7:02 am
- Location: Kicking off in stadiums around the Old World
- Contact:
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
With not even 50% of the rosters handed in, I suddenly seem to have a fair chance of actually winning moregames with opponents having to play horrible rosters as punishment...
That is if my captain has handed our roster in yet...

That is if my captain has handed our roster in yet...

Reason: ''
"This game is too good not to be played!" - Coach Pauli
Blood Bowl Beginner Kit
Saebelsultan's BB Dugouts
Blood Bowl Beginner Kit
Saebelsultan's BB Dugouts
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6626
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
I am better than 56% of team captains!

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- lemf
- Veteran
- Posts: 168
- Joined: Sun Apr 27, 2008 7:35 pm
- Location: Isle of Wight
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
Sorry next question. May have been previously answered.
Thanks
If you have hexagonal or square bases, please choose the diameter, which is the next larger one where the base would fit in. Possible diameters are: 25mm, 32mm and 40mm
Will they fit a 40mm square base?
Thanks
Reason: ''
Cheers
- Tojurub
- Super Star
- Posts: 824
- Joined: Wed Aug 20, 2003 5:56 pm
- Location: Lindau
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
heck, no! a square 40mm base might fit in a 57mm circle. we play BB not Warhammerlemf wrote:Sorry next question. May have been previously answered.
If you have hexagonal or square bases, please choose the diameter, which is the next larger one where the base would fit in. Possible diameters are: 25mm, 32mm and 40mmWill they fit a 40mm square base?
Thanks

Reason: ''
Nuffle Sucks! Heretic, NBA
www.biboba.de
www.biboba.de
- Loki
- Legend
- Posts: 2583
- Joined: Thu May 26, 2005 10:10 am
- Location: Bristol, UK
- Tojurub
- Super Star
- Posts: 824
- Joined: Wed Aug 20, 2003 5:56 pm
- Location: Lindau
Re: WORLD CUP 2019 in Dornbirn, 3.-6. Oct. 2019
all rosters in!!!
Dear Coaches and Captains of the World Cup,
it was another strong showing of how great the Blood Bowl community sticks together and how to make the upcoming biggest event not only an fantastic party of our beloved game (I hope), but also makes it very easy on the organizers by following (mostly) deadlines and guidelines.
When the first rosters came in last week, they were not what I had expected after writing a long newsletter about on how the rosters should be submitted.....maybe it was too long and people stopped reading after the first paragraph. People named their files wildly or even did not rename anything, which made me look up at least half the Squad ID to rename the files myself, I started sending the rosters back to ask them to rename. Some overachieved (but still did not read the newsletter), they wanted to get bonus points by renaming the tabs with their Squad ID, but that lead to a crashing of my automated macro to create the website rosters. Then there were people who wrote in the skills by hand and only used lower case letters, again crashing my macro when counting the skills for the markers. Italians seem to have the unwritten policy to write all names in upper case. And all the rosters, which were filled out by Open Office or other-non-Excel programs I had to copy and paste manually, where I learned that the Excel sheet is not as great as I thought it would be. Sorry for making it a pain for you getting all the single rosters in one combined file.
I assume that there are many squads which have disregarded the proper order of coaches, which are listed on the vouchers I have sent out to everyone. So I guess Milo and I will go through all databases again to adjust them for the main database (seems easier than re-writing the Excel sheets).
Anyway, it was a fun ride, reading all the different rosters, seeing so many rosters which are the same even down to the last skill, and then seeing rosters with a skill selections, which is so far off the mainstream, that I really wrote down the Coach ID to see how he fares at the event.
Despite my bickering at the beginning of the letter, I find it just AMAZING to get 1440 coaches to submit their rosters spot on in time. During the week we had some doubts, but it was the same feeling as during registration time when December exploded with sign-ups.
Let me say a BIG THANK YOU to all coaches for helping us and let's have a great party in Dornbirn.
Now the stats:
Top 5 chosen teams:
Wood Elves 131
Necromantic 130
Chaos Chosen 114
Humans 112
Dark Elves 111
..the stunties
Goblins 31
Halflings 28
Ogres 20
..bottom 5 chosen teams
Khemri TK 22
Ogres 20
Chaos Renegades 17
Bretonnians 16
Vampires 13
top 10 chosen Skills:
Block 3256
Guard 2168
Wrestle 1095
Dodge 1050
Leader 644
Tackle 632
Mighty Blow 620
Sure Hands 258
Strip Ball 220
Claw 173
17193 skills were given out, which leads to 68410 Skill Markers
57% are 25mm markers
38% are 32mm markers and
5% are 40mm markers
....now back to roster checking, rosters will be online by Monday morning, I hope
Dear Coaches and Captains of the World Cup,
it was another strong showing of how great the Blood Bowl community sticks together and how to make the upcoming biggest event not only an fantastic party of our beloved game (I hope), but also makes it very easy on the organizers by following (mostly) deadlines and guidelines.
When the first rosters came in last week, they were not what I had expected after writing a long newsletter about on how the rosters should be submitted.....maybe it was too long and people stopped reading after the first paragraph. People named their files wildly or even did not rename anything, which made me look up at least half the Squad ID to rename the files myself, I started sending the rosters back to ask them to rename. Some overachieved (but still did not read the newsletter), they wanted to get bonus points by renaming the tabs with their Squad ID, but that lead to a crashing of my automated macro to create the website rosters. Then there were people who wrote in the skills by hand and only used lower case letters, again crashing my macro when counting the skills for the markers. Italians seem to have the unwritten policy to write all names in upper case. And all the rosters, which were filled out by Open Office or other-non-Excel programs I had to copy and paste manually, where I learned that the Excel sheet is not as great as I thought it would be. Sorry for making it a pain for you getting all the single rosters in one combined file.
I assume that there are many squads which have disregarded the proper order of coaches, which are listed on the vouchers I have sent out to everyone. So I guess Milo and I will go through all databases again to adjust them for the main database (seems easier than re-writing the Excel sheets).
Anyway, it was a fun ride, reading all the different rosters, seeing so many rosters which are the same even down to the last skill, and then seeing rosters with a skill selections, which is so far off the mainstream, that I really wrote down the Coach ID to see how he fares at the event.
Despite my bickering at the beginning of the letter, I find it just AMAZING to get 1440 coaches to submit their rosters spot on in time. During the week we had some doubts, but it was the same feeling as during registration time when December exploded with sign-ups.
Let me say a BIG THANK YOU to all coaches for helping us and let's have a great party in Dornbirn.
Now the stats:
Top 5 chosen teams:
Wood Elves 131
Necromantic 130
Chaos Chosen 114
Humans 112
Dark Elves 111
..the stunties
Goblins 31
Halflings 28
Ogres 20
..bottom 5 chosen teams
Khemri TK 22
Ogres 20
Chaos Renegades 17
Bretonnians 16
Vampires 13
top 10 chosen Skills:
Block 3256
Guard 2168
Wrestle 1095
Dodge 1050
Leader 644
Tackle 632
Mighty Blow 620
Sure Hands 258
Strip Ball 220
Claw 173
17193 skills were given out, which leads to 68410 Skill Markers
57% are 25mm markers
38% are 32mm markers and
5% are 40mm markers
....now back to roster checking, rosters will be online by Monday morning, I hope
Reason: ''
Nuffle Sucks! Heretic, NBA
www.biboba.de
www.biboba.de