-
Today I Received a message asking how I collated the data and put it into a useful chart. In case anyone else is interested, the process I used was this:
1. first arranged the tile data into Excel and thought what I'd most find useful to know (which I won't use, since my main gaming partner is my wife and that'd be unfair to her), which came down to frequencies of certain tiles coming up
2. next to the tile matrix, started breaking down individual tiles into their components, using "countif" functions if the row had say "MO" for movement, marking each cell with a 1. Then I summed the columns (# of 1's or 2's, etc.)
3. figured out a bunch of little scenarios that might be interesting to know and then used the same approach, totaling all column counts below, then used percentages of the entire tile set (48 tiles) to get a more useful grasp on the totals
4. then it got interesting. I'm no chart expert in that I immediately know what's going to happen when I choose certain ones, but I experimented with a few. The biggest hurdle was getting the proper axis to show the right data. It worked easier when I copied over the important percentages to new columns somewhere else and used just the data I wanted for the charts, say in two rows of about 3 items each that I would be comparing.
5. the look took me a little while but that's usually the easiest thing
Hope that helps if you're interested! -Tyson
|
|
|
