Page 15 of 18

Re: NAF Data for Number-Crunchers

Posted: Mon Jul 02, 2018 1:03 pm
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

Re: NAF Data for Number-Crunchers

Posted: Mon Jul 02, 2018 2:37 pm
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

Re: NAF Data for Number-Crunchers

Posted: Mon Jul 02, 2018 5:59 pm
by sann0638
Too many versions at work!

Back tomorrow...

Re: NAF Data for Number-Crunchers

Posted: Wed Jul 04, 2018 6:45 pm
by sann0638

Re: NAF Data for Number-Crunchers

Posted: Wed Jul 04, 2018 9:52 pm
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

Re: NAF Data for Number-Crunchers

Posted: Thu Jul 05, 2018 6:53 am
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.

Re: NAF Data for Number-Crunchers

Posted: Fri Jul 06, 2018 6:59 am
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

Re: NAF Data for Number-Crunchers

Posted: Fri Jul 06, 2018 8:17 am
by sann0638
Good to hear - sorry about the wasted time!

Re: NAF Data for Number-Crunchers

Posted: Sat Jul 07, 2018 7:44 am
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

Re: NAF Data for Number-Crunchers

Posted: Tue Jul 31, 2018 10:39 pm
by sann0638
Putting a new thing together. What else would be good? Will be updating data in next couple of days.
June 2018.png

Re: NAF Data for Number-Crunchers

Posted: Wed Aug 01, 2018 1:02 pm
by sann0638
Success v Popularity.png
Fun graph.

Re: NAF Data for Number-Crunchers

Posted: Wed Aug 01, 2018 1:43 pm
by straume
Poor Orcs....when will they find their rightful place in tier2?

Re: NAF Data for Number-Crunchers

Posted: Wed Aug 01, 2018 1:53 pm
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.

Re: NAF Data for Number-Crunchers

Posted: Wed Aug 01, 2018 2:18 pm
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

Re: NAF Data for Number-Crunchers

Posted: Thu Aug 02, 2018 7:34 am
by sann0638