I truly loved this. The recent staff additions at the Dice Tower (the Yi's, Camilla, Mike - not as recent but still) have breathed fresh life into an already great channel - I can't say it enough!
8:05 If you don't already know about INDEX(MATCH(...)), Chris, look it up, it made a HUGE difference for me as an Excel user versus VLOOKUP(). (Basically doing index(match(...)) allows you to look up things regardless of the order of the columns in the lookup table and you match columns up by the name in the column header versus trying to count how many columns over something is.)
@@vettels6 I'm not actually a fan of XLOOKUP compared to INDEX(MATCH(...)) because XLOOKUP() doesn't dynamically change columns and rows if the table it's looking in is reordered. It's also harder to parse in that INDEX(MATCH(...)) you simply type in the row or column header names while XLOOKUP it's a lot more convuluted if you want to do anything other than put in the row number or column letter. For example, say I have a table where column $G:$G is States, and another is Population. With Index/Match I can do a lookup like = Index($A:$Z, Match("AL", $G:$G, 0), match("Population", $1:$1, 0)) Notice that I don't need to know which column Population is, it could move around and it wouldn't matter. It's also clear in that function exactly what I'm looking up, namely the Population value in the row with "AL" in it. XLOOKUP would have to look more like: = XLOOKUP("AL", $G:$G, $N:$N) But notice that I can't tell what "Column N" is from this. And if the underlying table changes its order of columns, and the Population column isn't actually in column $N:$N any more, then it might not even be looking in the right place. XLOOKUP is definitely better than VLOOKUP, for sure. And it does have an advantage in that you can do approximate lookups which Index(Match()) can't. But for exact match lookups in a table with shifting columns and rows where I want to be able to see at a glance what I'm looking up I like Index(Match()) better.
@@Bodyknock I'm gonna look into both of these! Appreciate the recommendations. Wouldn't mind being able to refine the processes a bit. Though I'll look forward to not have to make all the formulas from scratch next time.
@@DTChrisYi , if you don't mind me saying, you could also use = SUM(put an array here) - MAX(put here the same array) in 13:00 next time to eliminate the highest case of cross-overs instead of manually correcting each formula. It'll save you some time.
This was my favorite DT video! As a retired accountant, I just LOVED the statistical analyses! I even learned a thing or two about Excel! See you in July at DTE!
I've only played it a couple times, so maybe I don't get it yet, but I got to agree with the Dice Tower on this one... I don't YET see the magic of this game.
I knew I was a nerd, but didn’t realize how big a nerd until this video - perusing an Excel spreadsheet - hit the hour mark and I wanted to keep watching
Mike got me back into the dice tower. His energy is so positive and welcoming, I’ve noticed when someone mocks him he never defends he just joins in which totally diffuses whatever is being said. Great guy.
As someone who's always enjoyed and owned a few board games but never got too in depth with it, this has been eye opening. Recently started looking into board games more which is how I found Dice Tower, and it's both daunting and encouraging to learn that there's 450 games across people's top 100. Had no idea how many board games are out there. Thanks for the vids guys
Thank you for this video 🙂 next time, I suggest also adding a couple of visualisations. The mind often tends to grasp these easier than raw numbers and it lightens everything up ✌️ Keep up the good work. I watch most of your videos guys and they bring me so much joy
Tom, I would really appreciate it if you would advertise the voting of the people's choice Top 100 a bit more next time, cause I completely missed it last year! Other than that, great analysis guys :))
Yeah good idea and I can also say its much more fun to watch if you took part in the vote. Its always exciting to see a game come up which you voted on.
You guys need to make a spreadsheet of games each of you hasn't played so you can stay organized & play 'em. There are many Dice Tower videos where someone says "I haven't played this" & someone responds "WHAT??!! We'll have to play that together!" But it doesn't happen partly (probably) because everyone forgets due to...well, life happening. Would be fun to see a video (or 2 or 3) of everyone's ratings of "Catchupalooza" games after a 3-6 month period.
We have a Catchupalooza spreadsheet we're slowly working through. It does need to be updated a tad since the A-Team top 100 though, but we're working on some of those as well. Two are airing late this week actually! That could be a fun idea to look at the different Catchupalooza games we've already done.
One thing you might look into is Tableau Public. Last time I looked, as long as you make the datasets open, you should be able to utilize the tool for free
I'd like to see some analysis on the types of games (mechanics), weights, themes, etc. on these lists. Obviously, Roy's would be heavy on superheroes and space themes. Zee's would trend toward the lighter/quicker end of things. It'd be fun to see some data on that. Charts and graphs too! :)
Regarding Netrunner: project Nisei were at ukge, they are the non-profit fan group that are keeping the game going but aren't using the netrunner name on their products. As for the netrunner trademark, it is currently in limbo. WotC explicitly abandoned the trademark a month after R.Talsorian games applied for the trademark. That application is due to be evaluated next month(ish) so I doubt anyone is currently producing anything official for it.
I'd be interested in that for sure, but it would have to be in a more robust system than this spreadsheet I threw together. If I could have all of BGG data in a SQL database, I would let rip!
The analysis of the raw numbers themselves is very interesting and well done. However, when the lists are (for some members more than others) so much of a "What's On My Mind Right Now" thing, in an ideal world you would almost want to see lists where campaign/legacy games and non-campaign games are separated, just because it's so easy to differ in how one approaches a campaign game's role on this type of Top List. In other words, if a criteria is "Need to have reason to keep playing it", campaign/legacy games is not completely on "equal footing" with other games in terms of potential staying power. I also totally get it - these lists are meant to be FUN (and they are) and garner traffic, and they should also be fun to make listing games high that you into and playing right now (even though it might not be 110% fair for the amaaaaazing legacy game experiences you had with games (still in print) you finished 1, 2 or 3 years ago and are not exactly lying awake for right now).
How easy it would be to get all those top 100 or something files released for people to play around with the data? I mean there are so many people that are full into statistics and can produce nice graphics using R or python, mainly R.
I believe that an Epilogue is also known as a Resolution. Every story has one. Unfortunately however, they are sometimes extremely short; like 2 minutes.
Great analysis! Here is an interesting data point... Back on Jan 28 stream, Peoples Choice #1 of all time was Wingspan. The recent A-Team's top 100 of all time didn't mention Wingspan at all for any A-Team member! I was thinking on this when Chris was discussing People's choice games that did not cross over. Granted, I think Tom, Zee and Mike did rate Wingspan in there, that's why it didn't show up so directly. Interesting to me at least!
Tom, Zee, and Mike all had Wingspan in their top 100, and none of the A-Team did. Conversely, the A-Team all had Gizmos in their top 100, and none of the others did. Should we rename these groupings Team Wingspan and Team Gizmos?
No other game in the same weight as Stone age is as good. frankly Its surprisingly more streamlined then others, plus with worker placement, luck of the dice(excitement), engine building, and hidden score(cards) makes it perfect Worker placement for me.
Also, I think it's easy to undersell how much people like the dice rolling. It gives the game a gambling / Ameri-trash/thrash feel that many other games don't have (which admittedly turns a lot of people off). BUT because you roll so many times during the game, the odds tend to work out. I know it's not the most complicated game, but it's my gaming "comfort food" for sure. I also think it has a deceptively high skill ceiling.
Minus the dice rolling, Lords of Waterdeep is up there with Stone Age as an introductory worker placement game in the same weight. Mandatory quests can be optional (though IMO, it's just a minor annoyance)
@@mjjjuly water deep and Stone Age use to be my fav when i started playing board games so they both feels very close to my heart but I think Stone Age wins out
Hiya, I'm just reading one of your dice tower promo cards for flick of faith. Could someone please explain what is meant by `top 1`? I don't get it.. 🤷🏻♂️
1:07:42 It's important to say about Dwellings of Eldervale that there's a difference between a 'second round of printing still costing 100$ in average' and being widely available. But those who are willing and wanting to buy it will vote for it.
Like, what if I wanted to know what game and who was involved in multiple people crossovers? What was the maximum crossover (person-wise)? You can’t answer that question easily with this format.
Yeah totally put an asterisk on all of the data and had me as the viewer doing a lot of work to try to parse out the way their choices affected everything
Biggest shock of this video for me was that Chris loves Brass: Birmingham but really dislikes Great Western Trail, because for me they scratch a lot of similar itches/fire on a lot of the same cylinders/some other not great metaphor for each one generating similar feelings in me as the other. Both feel so fun and thematic and "smooth" to operate the mechanisms, and the rules don't inhibit or get in the way of the actual strategy meat of the game. At least that was my feel for them. Very different games, but they immediately make me think of each other.
Though Roy and my personal styles of games do not line up, I think that his enthusiasm during his Top 10's might influence people trying out the games he likes. For example, though I don't personally like too many Marvel or Space games, I might try them out due to his enjoyment of these themes. I bought Xia prior to knowing Roy likes it a lot, but am more enthusiastic to try it out due to his expression of the game. Now I just need to find a gaming group that would want to play it with me... lol
Would be a simple task maybe to have each person vote yes/no whilst everyone goes through their top 100. Maybe with a little buzzer that pops a graphic onto the screen. Then you could tabulate that data later.
Would you consider sharing the workbook with other data nerds? To see what other funs stuff we could extrapolate? Not interested in personal data but then again what is more personal than your favorite games?
This was an interesting video, but I don't understand what you were trying to do with the points being from 101-200? It doesn't change the averages unless you're using a different number than the number of crossovers. ((x+100)+(y+100))/2 becomes (X+y+200)/2 which is the same as ((x+y)/2) + 100. The plus 100 isn't changing anything.
It isn't to change the averages, but it's to prevent huge swings in the total "points" each game gets. For example, if a game is #1 on a single persons list and gets 100 points, it is immeasurably higher up than a game ranked at #95 but on five people's lists for a total of 25 points. The model of 200 down to 101 points favors games that cross over on more people's lists because that really is more of a feat than being high on a single person's list. Like Tom said, I'm not saying that my #1 game is 100x better than my #100 game, so the points reflect that with the system we used.
I've found that a lot of 'greats' are great because they were firsts, leaders, innovators, trend-setters, genre-makers, but were actually improved upon by cheap imitators (such as adding features or alternative stories/characters) that never make such lists. Maybe the originals would be on a Play This Version First list in a genre, so that the improvements that good (value-adding) imitators introduce can be appreciated... As far as the people's list, curious would be knowing the effect that marketing dollars spent (paying to be on a prime Target shelf or featured on Amazon, for example) has on it (people buying whatever is placed in front of them)... maybe a list of how many times a game has been played this year would be a measure (or a secretly like list! (game you won't admit you like)... then an 'immersion' list - games that immerse you in their worlds (better if historic - revealing the culture and mindsets of the era)... may you have many fun lists in the upcoming future...
Any analysis with weighting the game based on rank/number, ie people’s top 1 is weighted more so maybe Mike or Zee have a higher crossover in terms of that weighting?
Interference pattern on images created by interaction of lines with image sensor is called moire or moire pattern. As a spreadsheet nerd I enjoyed the data and the discussion!
Ha! I created a spreadsheet very similar to Chris's spreadsheet. I crossed over with The People, and Camilla 9 times. Tom next at 8 and Mike with 6. Zee and Roy at 4. Chris and Wendy at 3 and 1 respectively. I'm an accountant by profession so numbers, spreadsheets and comparisons is how my brain works lol I have 34 Unique games on my list lol
Mike - I'd love to get in a game of Outlive with you at Dice Tower East if I can! I've been interested in it ever since Tom, Zee and Sam did the playthrough when it first came out. I haven't picked it up yet because it was getting a little pricy and I wanted to make sure I liked it first.
5:17 Why not use PowerBI Desktop - which is free - and make a Dashboard/visualizations with that? I am sure that’s what Alex did last you. Perhaps ask him!
Using the number of people who included the game on their list to create an average seems meaningless. If 7 of the 8 people didn't like a game enough to include it then that tells me the game "sucks" and that the one person who liked it is unusual. The average for just those that included the game is misleading since it skews the game to look better than it clearly is to the group of 8 people. What you need to do is get the list of all games on all lists and then for those that didn't include a game, have them give the game some points. Then we can get a slightly meaningful number for all of these games.
It's just creating a different data point. All it's saying is for the people who put it on their lists, is it typically higher up or lower down. It's not there to skew or mislead. If anything, your point is proven, "This game has an average score of 199 points, based on only one rating. Clearly that means one person LOVES it and it's not to the other people's tastes nearly as much." That isn't meaningless, because you just inferred meaning from it. Your idea would give us a broader perspective on each single game, which is a neat idea. But it would be much easier to compare our actual ratings (1-10 scores) on a game rather than try to put it in context of the Top 100 list. Also keep in mind that it would be a ridiculous amount of effort for all 7 of us to go through everybody else's lists and assign points for every game that wasn't also on our list. Especially given that we haven't played every came on each other's lists so how would we determine those numbers? Appreciate you watching, and if you have any other thoughts I'd be happy to consider them for next year.
Without any evidence I think Dixit might have jumped because it got mentioned a lot. “A Dixit type game” sometimes makes me get out Dixit and play it instead of buying more games. ;)
I truly loved this. The recent staff additions at the Dice Tower (the Yi's, Camilla, Mike - not as recent but still) have breathed fresh life into an already great channel - I can't say it enough!
8:05 If you don't already know about INDEX(MATCH(...)), Chris, look it up, it made a HUGE difference for me as an Excel user versus VLOOKUP(). (Basically doing index(match(...)) allows you to look up things regardless of the order of the columns in the lookup table and you match columns up by the name in the column header versus trying to count how many columns over something is.)
Doug, if you like INDEX/MATCH you may love XLOOKUP. I think it was added in Office 2019 and works how a lookup function should have always worked.
@@vettels6 I'm not actually a fan of XLOOKUP compared to INDEX(MATCH(...)) because XLOOKUP() doesn't dynamically change columns and rows if the table it's looking in is reordered. It's also harder to parse in that INDEX(MATCH(...)) you simply type in the row or column header names while XLOOKUP it's a lot more convuluted if you want to do anything other than put in the row number or column letter.
For example, say I have a table where column $G:$G is States, and another is Population. With Index/Match I can do a lookup like
= Index($A:$Z, Match("AL", $G:$G, 0), match("Population", $1:$1, 0))
Notice that I don't need to know which column Population is, it could move around and it wouldn't matter. It's also clear in that function exactly what I'm looking up, namely the Population value in the row with "AL" in it.
XLOOKUP would have to look more like:
= XLOOKUP("AL", $G:$G, $N:$N)
But notice that I can't tell what "Column N" is from this. And if the underlying table changes its order of columns, and the Population column isn't actually in column $N:$N any more, then it might not even be looking in the right place.
XLOOKUP is definitely better than VLOOKUP, for sure. And it does have an advantage in that you can do approximate lookups which Index(Match()) can't. But for exact match lookups in a table with shifting columns and rows where I want to be able to see at a glance what I'm looking up I like Index(Match()) better.
@@Bodyknock I'm gonna look into both of these! Appreciate the recommendations. Wouldn't mind being able to refine the processes a bit. Though I'll look forward to not have to make all the formulas from scratch next time.
Thanks. Always used vlookup. Will look into index(match) and and xlookup
@@DTChrisYi , if you don't mind me saying, you could also use = SUM(put an array here) - MAX(put here the same array) in 13:00 next time to eliminate the highest case of cross-overs instead of manually correcting each formula. It'll save you some time.
I love everything the dice tower does but that was easily the best content ever. More spreadsheets please
This was my favorite DT video! As a retired accountant, I just LOVED the statistical analyses! I even learned a thing or two about Excel! See you in July at DTE!
Glad you enjoyed, and I'm very much looking forward to DTE as well!
Same. I'm an accountant and love statistics too. This was so interesting!
@@MrFettuccine I think they need to report to us monthly, don't you? LOL!
Castles of Burgundy not being in any of y’all’s lists is EGREGIOUS. EGREGIOUS!
I've only played it a couple times, so maybe I don't get it yet, but I got to agree with the Dice Tower on this one... I don't YET see the magic of this game.
@@CharlesHepburn2 Dang it, not you too, mack. This is a HEINOUS TRAVESTY I tell you!
No Great Western trail also
I knew I was a nerd, but didn’t realize how big a nerd until this video - perusing an Excel spreadsheet - hit the hour mark and I wanted to keep watching
Wouldn't it be wild if Tom's cross-over count with the people's choice was indicative of his influence to the hobby space.
That spreadsheet was really interesting!! I love these kind of stats!! :) Good job guys! Is it possible to have a copy of this??
Yes, I'd love a copy!
Mike got me back into the dice tower. His energy is so positive and welcoming, I’ve noticed when someone mocks him he never defends he just joins in which totally diffuses whatever is being said. Great guy.
As someone who's always enjoyed and owned a few board games but never got too in depth with it, this has been eye opening. Recently started looking into board games more which is how I found Dice Tower, and it's both daunting and encouraging to learn that there's 450 games across people's top 100. Had no idea how many board games are out there. Thanks for the vids guys
Don't do it. Run the other way
I am glad to see that you’ve done this again. I look forward to the top 100s series every year and this analysis is fascinating
This was amazing work, super kudos to Chris here. Well presented and very interesting!
Love this! Loved it when Alex at BoardGameCo did it and glad you have now picked it up. Please keep doing this each year.
You know our hobby is nerdy when a video about excel spreadsheets and data analysis gets us excited. Loved it!
Thank you for this video 🙂 next time, I suggest also adding a couple of visualisations. The mind often tends to grasp these easier than raw numbers and it lightens everything up ✌️
Keep up the good work. I watch most of your videos guys and they bring me so much joy
This was great, would love to see more of this. Would love to see all of tom's lists data included as well. Please do more
Tom, I would really appreciate it if you would advertise the voting of the people's choice Top 100 a bit more next time, cause I completely missed it last year! Other than that, great analysis guys :))
I miss every vote. Need a link on their TH-cam videos
Yeah good idea and I can also say its much more fun to watch if you took part in the vote. Its always exciting to see a game come up which you voted on.
100% agree
I was right. They are taking new impressions
Great job Chris Yi really useful data points and all in Excel!
A weirdly enjoyable video. Hope to see more break down like this in the future.
This was a lot of fun and very interesting. Thanks for the work, Chris!
You guys need to make a spreadsheet of games each of you hasn't played so you can stay organized & play 'em. There are many Dice Tower videos where someone says "I haven't played this" & someone responds "WHAT??!! We'll have to play that together!" But it doesn't happen partly (probably) because everyone forgets due to...well, life happening. Would be fun to see a video (or 2 or 3) of everyone's ratings of "Catchupalooza" games after a 3-6 month period.
We have a Catchupalooza spreadsheet we're slowly working through. It does need to be updated a tad since the A-Team top 100 though, but we're working on some of those as well. Two are airing late this week actually! That could be a fun idea to look at the different Catchupalooza games we've already done.
@@DTChrisYi Awesome,Chris! Will watch for play through videos. I'm glad they have you on the team. I enjoy all the content you do.
@@jeffdekorne7944 thanks man! I really appreciate that!
Chris, this spreadsheet is a work of art!
Loved watching the top 100 videos and the analysis - thank you all for producing such entertaining content!
One thing you might look into is Tableau Public. Last time I looked, as long as you make the datasets open, you should be able to utilize the tool for free
I'd like to see some analysis on the types of games (mechanics), weights, themes, etc. on these lists. Obviously, Roy's would be heavy on superheroes and space themes. Zee's would trend toward the lighter/quicker end of things. It'd be fun to see some data on that. Charts and graphs too! :)
Regarding Netrunner: project Nisei were at ukge, they are the non-profit fan group that are keeping the game going but aren't using the netrunner name on their products. As for the netrunner trademark, it is currently in limbo. WotC explicitly abandoned the trademark a month after R.Talsorian games applied for the trademark. That application is due to be evaluated next month(ish) so I doubt anyone is currently producing anything official for it.
I love Stats so much. I hope you can make this spreadsheet available! :)
Nice work on the stat work, Chris. :-) This was fun. You should incorporate years games came out in the future, I think. That would be fun to see too.
I agree. Great work. And I love to know when games came out so that I can see which games are likely to become “classics”
I'd be interested in that for sure, but it would have to be in a more robust system than this spreadsheet I threw together. If I could have all of BGG data in a SQL database, I would let rip!
Is the Excel Spreadsheet released somewhere? I would like to download it and see how everything was done.
The analysis of the raw numbers themselves is very interesting and well done. However, when the lists are (for some members more than others) so much of a "What's On My Mind Right Now" thing, in an ideal world you would almost want to see lists where campaign/legacy games and non-campaign games are separated, just because it's so easy to differ in how one approaches a campaign game's role on this type of Top List. In other words, if a criteria is "Need to have reason to keep playing it", campaign/legacy games is not completely on "equal footing" with other games in terms of potential staying power.
I also totally get it - these lists are meant to be FUN (and they are) and garner traffic, and they should also be fun to make listing games high that you into and playing right now (even though it might not be 110% fair for the amaaaaazing legacy game experiences you had with games (still in print) you finished 1, 2 or 3 years ago and are not exactly lying awake for right now).
This was fantastic. Great work, Chris.
Has this spreadsheet been made available anywhere yet?
Awesome video. Really interesting analysis of data. Will be interesting to see how it evolves moving forward. Thanks Chris!
I agree with Tom. Statistics are more interesting, useful and less intuitive than algebra and should be taught more
How easy it would be to get all those top 100 or something files released for people to play around with the data? I mean there are so many people that are full into statistics and can produce nice graphics using R or python, mainly R.
I second this
Chris really nailed this. And all just in excel 😭😂 so good
You should do a 7's celebration. Doesn't have to be ranked, but go over the "high" sevens.
I like this idea
I believe that an Epilogue is also known as a Resolution. Every story has one. Unfortunately however, they are sometimes extremely short; like 2 minutes.
Chris and I have the most in common and I’m not talking games. I love spreadsheets.
Amazing way to close the top 100 cycle for the year! Loved it
Great analysis! Here is an interesting data point... Back on Jan 28 stream, Peoples Choice #1 of all time was Wingspan. The recent A-Team's top 100 of all time didn't mention Wingspan at all for any A-Team member! I was thinking on this when Chris was discussing People's choice games that did not cross over. Granted, I think Tom, Zee and Mike did rate Wingspan in there, that's why it didn't show up so directly. Interesting to me at least!
Tom, Zee, and Mike all had Wingspan in their top 100, and none of the A-Team did. Conversely, the A-Team all had Gizmos in their top 100, and none of the others did. Should we rename these groupings Team Wingspan and Team Gizmos?
Absolutely
Is there a link to these charts somewhere?
I love numbers!! Thank you, Chris, for amassing these statistics!
Help anyone,
We arebonly getting 1,
should we get Kingdomino or Barenpark???
I don't see a table with the results. Where can I find them?
Consider adding designer to the analysis. It would be fun to see highest rated designers
Great video! Thanks for putting all that data together, Chris!
I would like to second the request someone made earlier for the spreadsheet being available for download.
Yes, and I will third it
I can't find the results of the table. Where can I find them?
No other game in the same weight as Stone age is as good. frankly Its surprisingly more streamlined then others, plus with worker placement, luck of the dice(excitement), engine building, and hidden score(cards) makes it perfect Worker placement for me.
Also, I think it's easy to undersell how much people like the dice rolling. It gives the game a gambling / Ameri-trash/thrash feel that many other games don't have (which admittedly turns a lot of people off). BUT because you roll so many times during the game, the odds tend to work out. I know it's not the most complicated game, but it's my gaming "comfort food" for sure. I also think it has a deceptively high skill ceiling.
I don't know how you could know that?
Minus the dice rolling, Lords of Waterdeep is up there with Stone Age as an introductory worker placement game in the same weight. Mandatory quests can be optional (though IMO, it's just a minor annoyance)
@@mjjjuly water deep and Stone Age use to be my fav when i started playing board games so they both feels very close to my heart but I think Stone Age wins out
This is a lot of fancy and impressive Excel crunching. What's Chris' background prior to the BG life?
Corporate Accountant
Your intros are getting pretty good quality
Were these stats made available?
Great video, is there a way to access the file?
Where can I get the file? :)
3:25 No your TV did not randomly turn off.
That was the cutest thing ever when Mike just started typing on the game like it was an actual computer XD
Hiya, I'm just reading one of your dice tower promo cards for flick of faith. Could someone please explain what is meant by `top 1`? I don't get it.. 🤷🏻♂️
1:07:42
It's important to say about Dwellings of Eldervale that there's a difference between a 'second round of printing still costing 100$ in average' and being widely available.
But those who are willing and wanting to buy it will vote for it.
Like, what if I wanted to know what game and who was involved in multiple people crossovers? What was the maximum crossover (person-wise)? You can’t answer that question easily with this format.
I think this makes a strong case for never putting Chris and Wendy in the same ranking show again or put them in as a duo.
It's nice that a married couple have so many games in ccommon they find fun, but it doesn't always make for the most interesting of videos.
@@petercsm5769 that's a better/nicer way to discribe it 😄
Yeah totally put an asterisk on all of the data and had me as the viewer doing a lot of work to try to parse out the way their choices affected everything
I think on Points - Total PTS, Wendy and Chris scores that crossed over should be averaged and counted as one person or I rather say one playgroup
Biggest shock of this video for me was that Chris loves Brass: Birmingham but really dislikes Great Western Trail, because for me they scratch a lot of similar itches/fire on a lot of the same cylinders/some other not great metaphor for each one generating similar feelings in me as the other.
Both feel so fun and thematic and "smooth" to operate the mechanisms, and the rules don't inhibit or get in the way of the actual strategy meat of the game. At least that was my feel for them.
Very different games, but they immediately make me think of each other.
i guess both have pros and cons, but i would prefer to see medians instead of average points
Though Roy and my personal styles of games do not line up, I think that his enthusiasm during his Top 10's might influence people trying out the games he likes. For example, though I don't personally like too many Marvel or Space games, I might try them out due to his enjoyment of these themes. I bought Xia prior to knowing Roy likes it a lot, but am more enthusiastic to try it out due to his expression of the game. Now I just need to find a gaming group that would want to play it with me... lol
Where can I download the data?
I have 25 crossovers with Wendy, 23 with Chris and 18 with Tom.
Love you Wendy! 🤗
The person running the stream should be mic'd also considering the amount of time they cross tot he person behind the controls.
I have been waiting for this for so long!
I might not enjoy this some days but today this was the perfect background companion. Thanks!
Thanks Chris, that was just over an hour of nerd Valhalla for me!!
Mike doesn't have Calico on his list because he still prefers the game "German Shepard".
OMG yes!!
this file available somewhere?
that sweet sweet data!
Would be a simple task maybe to have each person vote yes/no whilst everyone goes through their top 100. Maybe with a little buzzer that pops a graphic onto the screen. Then you could tabulate that data later.
Would you consider sharing the workbook with other data nerds? To see what other funs stuff we could extrapolate? Not interested in personal data but then again what is more personal than your favorite games?
This was an interesting video, but I don't understand what you were trying to do with the points being from 101-200? It doesn't change the averages unless you're using a different number than the number of crossovers. ((x+100)+(y+100))/2 becomes (X+y+200)/2 which is the same as ((x+y)/2) + 100. The plus 100 isn't changing anything.
It isn't to change the averages, but it's to prevent huge swings in the total "points" each game gets. For example, if a game is #1 on a single persons list and gets 100 points, it is immeasurably higher up than a game ranked at #95 but on five people's lists for a total of 25 points. The model of 200 down to 101 points favors games that cross over on more people's lists because that really is more of a feat than being high on a single person's list. Like Tom said, I'm not saying that my #1 game is 100x better than my #100 game, so the points reflect that with the system we used.
I've found that a lot of 'greats' are great because they were firsts, leaders, innovators, trend-setters, genre-makers, but were actually improved upon by cheap imitators (such as adding features or alternative stories/characters) that never make such lists. Maybe the originals would be on a Play This Version First list in a genre, so that the improvements that good (value-adding) imitators introduce can be appreciated...
As far as the people's list, curious would be knowing the effect that marketing dollars spent (paying to be on a prime Target shelf or featured on Amazon, for example) has on it (people buying whatever is placed in front of them)... maybe a list of how many times a game has been played this year would be a measure (or a secretly like list! (game you won't admit you like)... then an 'immersion' list - games that immerse you in their worlds (better if historic - revealing the culture and mindsets of the era)... may you have many fun lists in the upcoming future...
did you know you were filming the spreadsheet part?
Yes? I believe that was the point!
@@DTChrisYi i was afraid of that
I love data! Thanks for the video
Great job, @ChrisYi! P.S. You're still wrong about Great Western Trail. :)
Average/ideal play time for each dice tower personality & people’s choice?
Any analysis with weighting the game based on rank/number, ie people’s top 1 is weighted more so maybe Mike or Zee have a higher crossover in terms of that weighting?
Interference pattern on images created by interaction of lines with image sensor is called moire or moire pattern. As a spreadsheet nerd I enjoyed the data and the discussion!
Funny, as I was watching Camilla's top 100, I kept thinking, this is basically Zee's top 100. Guess I wasn't too far off
I love a good spreadsheet. I wish there were more things you guys could do spreadsheets for.
Ha! I created a spreadsheet very similar to Chris's spreadsheet. I crossed over with The People, and Camilla 9 times. Tom next at 8 and Mike with 6. Zee and Roy at 4. Chris and Wendy at 3 and 1 respectively. I'm an accountant by profession so numbers, spreadsheets and comparisons is how my brain works lol I have 34 Unique games on my list lol
Great video!!
Mike - I'd love to get in a game of Outlive with you at Dice Tower East if I can! I've been interested in it ever since Tom, Zee and Sam did the playthrough when it first came out. I haven't picked it up yet because it was getting a little pricy and I wanted to make sure I liked it first.
Let's make it happen!
This is awesome. More data!
5:17 Why not use PowerBI Desktop - which is free - and make a Dashboard/visualizations with that? I am sure that’s what Alex did last you. Perhaps ask him!
Using the number of people who included the game on their list to create an average seems meaningless. If 7 of the 8 people didn't like a game enough to include it then that tells me the game "sucks" and that the one person who liked it is unusual. The average for just those that included the game is misleading since it skews the game to look better than it clearly is to the group of 8 people. What you need to do is get the list of all games on all lists and then for those that didn't include a game, have them give the game some points. Then we can get a slightly meaningful number for all of these games.
It's just creating a different data point. All it's saying is for the people who put it on their lists, is it typically higher up or lower down. It's not there to skew or mislead. If anything, your point is proven, "This game has an average score of 199 points, based on only one rating. Clearly that means one person LOVES it and it's not to the other people's tastes nearly as much." That isn't meaningless, because you just inferred meaning from it.
Your idea would give us a broader perspective on each single game, which is a neat idea. But it would be much easier to compare our actual ratings (1-10 scores) on a game rather than try to put it in context of the Top 100 list. Also keep in mind that it would be a ridiculous amount of effort for all 7 of us to go through everybody else's lists and assign points for every game that wasn't also on our list. Especially given that we haven't played every came on each other's lists so how would we determine those numbers? Appreciate you watching, and if you have any other thoughts I'd be happy to consider them for next year.
GWT is so far the only game I sold after 1 play. Decision paralysis was too high for me.
Hope 2023 version is at the oven! Great content!
Without any evidence I think Dixit might have jumped because it got mentioned a lot. “A Dixit type game” sometimes makes me get out Dixit and play it instead of buying more games. ;)
good stuff chris
GWT and Terra Mystica… so underrepresented on Dice Tower lists…
If currently in print.
Last year printed.
Price point.
i like the live shows. but always close the chat window. Sometimes i wish the panel wasn't so distracted by the chat (unless it's a Q&A)
I'm on the other side. I think chat is a big part of what makes the lives enjoyable for me.
This was great, my nerd