NAF Data for Number-Crunchers

News and announcements from the worldwide Blood Bowl players' association

Moderator: TFF Mods

User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Data updated to yesterday. Half way through the year, and well on course to smash the 2017 number of games played!
map.png
You do not have the required permissions to view the files attached to this post.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

Nice!
But did you somehow manage to delete the new table that you linked to at the Bottom of page 14?
It seems to be gone now.
Cheers
Martin

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Too many versions at work!

Back tomorrow...

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »


Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

There it is :orc:

Mike, Quick tableau question:
I can select all the cells in any given table, but is there some way to actually cut and paste the table, so that one might paste it into, say, Excel?
If there is, I can't figure out how.
Cheers
Martin

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Press button 1 then button 2 (crosstab) and you will get the data in that format in Excel.
download.png
Otherwise button 1 then Data will give you the data in a format for using a pivot table.
You do not have the required permissions to view the files attached to this post.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

Wow. That Works like a charm. Thanks yet again.
Looks like I wasted an hour of Work yesterday.
But on the plus side I'll have my Excel sheet automated and then I'll never have to put in any data manually again. Spectacular!
Cheers
Martin

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Good to hear - sorry about the wasted time!

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

Just to be clear: Not your fault!
I googled a bit and saw that Tableau Public couldn't do it (but something called Tableau Private could), so I went ahead and improved my Excel sheet by letting one half of the cells be generated by the other half = half the ammount of manual typing.

And then you posted up that it could in fact be done. Yay. And changing it to full automated mode only took an hour.

So - thanks again
Cheers
Martin

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Putting a new thing together. What else would be good? Will be updating data in next couple of days.
June 2018.png
You do not have the required permissions to view the files attached to this post.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Success v Popularity.png
Fun graph.
You do not have the required permissions to view the files attached to this post.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
straume
Emerging Star
Emerging Star
Posts: 364
Joined: Fri Mar 28, 2014 9:21 am

Re: NAF Data for Number-Crunchers

Post by straume »

Poor Orcs....when will they find their rightful place in tier2?

Reason: ''
User avatar
rolo
Super Star
Super Star
Posts: 1188
Joined: Wed May 27, 2015 9:38 am
Location: Paradise Stadium, where the pitch is green and the cheerleaders are pretty.

Re: NAF Data for Number-Crunchers

Post by rolo »

"Amazons" are missing a label in the second graph.

@straume - depends on what people are using tiers *for*. If it's to encourage a more diverse set of races, they *should* be based on race popularity and not on performance.

Reason: ''
"It's 2+ and I have a reroll. Chill out. I've got this!"
Image
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

rolo wrote:"Amazons" are missing a label in the second graph.

@straume - depends on what people are using tiers *for*. If it's to encourage a more diverse set of races, they *should* be based on race popularity and not on performance.
Underworld and Necro are the missing labels :D

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »


Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Post Reply