The Hotness
Games|People|Company
Eclipse
Gunship: First Strike!
Mage Knight: Board Game
Midnight Men
Agricola: Die Bauern und das liebe Vieh
Hawaii
Star Wars: Battle of Hoth
Wiz-War
Ora et Labora
Rex: Final Days of an Empire
Snowdonia
Barbarian Prince
The Lord of the Rings: The Card Game
Twilight Struggle
War of the Ring
Agricola
7 Wonders
A Game of Thrones: The Board Game (second edition)
Dominion
7 Wonders: Cities
Kingdoms
A Few Acres of Snow
Risk Legacy
Arkham Horror
Through the Ages: A Story of Civilization
Thunderstone Advance: Towers of Ruin
1812: The Invasion of Canada
Dixit: Journey
Elder Sign
D-Day Dice
The Castles of Burgundy
Le Havre
Kingdom Builder
Sid Meier's Civilization: The Board Game
Race for the Galaxy
Cosmic Encounter
Dominant Species
Dungeon Petz
Battlestar Galactica
Power Grid
Mansions of Madness
Last Will
Twilight Imperium (third edition)
Nexus Ops
Agents of SMERSH
Puerto Rico
Star Trek: Fleet Captains
Kairo
Core Worlds
Sherlock Holmes Consulting Detective
Recommend
15 
 Thumb up
 Thumb up
12 Posts

BoardGameGeek» Forums » BoardGameGeek Related » BGG General

Subject: Collection overlap calculator rss

Your Tags: Add tags
Popular Tags: collection [+] stats [+] xmlapi [+] [View All]
Matthew Gray
United States
Reading
Massachusetts
admin
Avatar
mbmbmbmbmb
Inspired in part by msaari's resurrection of the correlation calculator ( http://www.boardgamegeek.com/thread/130097/page/1), I thought it would be neat to be able to easily calculate collection overlap as well as identify the rarest portions of that overlap. So, using the XML API (with one small extension, which will be generally available soon), I made a tool that does just that:

http://boardgamestuff.com/cgi/bggcolloverlap

The "score" is simply an average of the percentage overlaps relative to each collection. I like this number in that it captures what I subjectively think of as "collection similarity".

For me, a few examples:


User Games in common "Score" Rarest overlap
Aldie 333 43 Spinball
Kaelistus 130 38 Pagoda
Octavian 91 35 Techno Witches
TomVasel 258 33 Moby Pick
msaari 65 27 Klondike
 
 Thumb up
 tip
 Thumb up
Mikko Saari
Finland

http://www.lautapeliopas.fi/ - the best Finnish board game resource!
badge
Avatar
mbmbmbmbmb
Ooh, nice! This is pretty cool (and I'm curious what the small extension is about...).
 
 Thumb up
 tip
 Thumb up
Ray
United States
Carpentersville
Illinois
Avatar
mbmbmbmbmb
Stop it! I'm running out of quickbar!
 
 Thumb up
 tip
 Thumb up
Play Games - Interact - Have Fun!
United States

California
Avatar
mbmbmbmbmb
mkgray wrote:
Inspired in part by msaari's resurrection of the correlation calculator ( http://www.boardgamegeek.com/thread/130097/page/1), I thought it would be neat to be able to easily calculate collection overlap as well as identify the rarest portions of that overlap. So, using the XML API (with one small extension, which will be generally available soon), I made a tool that does just that:

http://boardgamestuff.com/cgi/bggcolloverlap

The "score" is simply an average of the percentage overlaps relative to each collection. I like this number in that it captures what I subjectively think of as "collection similarity".

For me, a few examples:


User Games in common "Score" Rarest overlap
Aldie 333 43 Spinball
Kaelistus 130 38 Pagoda
Octavian 91 35 Techno Witches
TomVasel 258 33 Moby Pick
msaari 65 27 Klondike



My examples:
User Games in common "Score" Rarest overlap
mkgray................154................24.5......Camelot
Aldie.................209................26........Infinity (Cool!)
TomVasel..............203................25.5......Weapons & Warriors
DWTripp...............63.................26........Fury of the Clansmen
ynnen.................173................29........Red Hot Yott
tinytimidfluffybunny 59.................33........Streets of Fire -ASL
Thommy8...............53.................33........Trivial Pursuit #5
Sky Knight X..........80.................26........Battlecards: World Conflict


It's an interesting tool. I have yet to find anyone above the 33 I have with Thommy8.




 
 Thumb up
 tip
 Thumb up
  • Last edited Mon Oct 16, 2006 9:25 am (Total Number of Edits: 3)
  • Posted Mon Oct 16, 2006 9:20 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • QuickReply
    •  
    • QuickQuote
    •  
    • Reply
    •  
    • Quote
Matthew Gray
United States
Reading
Massachusetts
admin
Avatar
mbmbmbmbmb
msaari wrote:
Ooh, nice! This is pretty cool (and I'm curious what the small extension is about...).


Games in the /xmlapi/collection view now have an "owners" attribute which says how many people have listed that game as owned. It lets you see, for example, which games you have that are the rarest among the BGG community.

Eg, I'm the only one who lists "Hat In The Ring" and one of two who owns "Stapelei" and "Rutschpartie mit Winnie the Pooh".
 
 Thumb up
 tip
 Thumb up
Sure.
Netherlands
Rijen
Noord Brabant
Avatar
mbmbmbmbmb
manowarplayer wrote:
It's an interesting tool. I have yet to find anyone above the 33 I have with Thommy8.


Quote:
Overlap score: 34


Me.
 
 Thumb up
 tip
 Thumb up
Richard Pardoe
United States
San Ramon
California
Avatar
mb
manowarplayer wrote:
I have yet to find anyone above the 33 I have with Thommy8.


Sorry, Scott (and Bas)....

Overlap score: 40
 
 Thumb up
 tip
 Thumb up
King of the Dead
United States
Portland
Oregon
Avatar
mbmbmbmbmb
EDIT: WOOPS never mind... i was reading the stats wrong...

blush
 
 Thumb up
 tip
 Thumb up
  • Last edited Thu Oct 19, 2006 7:54 am (Total Number of Edits: 1)
  • Posted Thu Oct 19, 2006 7:51 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • QuickReply
    •  
    • QuickQuote
    •  
    • Reply
    •  
    • Quote
Jeff M
United States
Winter Park
Florida
Avatar
mbmbmbmbmb
mkgray wrote:
Games in the /xmlapi/collection view now have an "owners" attribute which says how many people have listed that game as owned.

It looks like /xmlapi/game/123?stats=1 also now returns an owned tag? Or was it returning it before and I missed it?
 
 Thumb up
 tip
 Thumb up
Matthew Gray
United States
Reading
Massachusetts
admin
Avatar
mbmbmbmbmb
JeffyJeff wrote:
mkgray wrote:
Games in the /xmlapi/collection view now have an "owners" attribute which says how many people have listed that game as owned.

It looks like /xmlapi/game/123?stats=1 also now returns an owned tag? Or was it returning it before and I missed it?


Oh, yeah, that too. I forgot I put that in.
1 
 Thumb up
 tip
 Thumb up
Ricardo Madeira
Portugal
Porto Salvo
Avatar
mbmbmbmbmb
mkgray wrote:
Games in the /xmlapi/collection view now have an "owners" attribute which says how many people have listed that game as owned. It lets you see, for example, which games you have that are the rarest among the BGG community.


Nice!!

How about a "wishers" attribute too, giving the total number of people that have the game in their wishlists? Might be something fun about comparing the numbers of owners and wishers across several games... or not.

 
 Thumb up
 tip
 Thumb up
Juan Carlos Goyes
Colombia
Bogota
Cundinamarca
Avatar
mbmbmbmbmb
It does´t appear to be working anymore
 
 Thumb up
 tip
 Thumb up
  • Last edited Tue Aug 16, 2011 8:31 pm (Total Number of Edits: 1)
  • Posted Tue Aug 16, 2011 8:31 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • QuickReply
    •  
    • QuickQuote
    •  
    • Reply
    •  
    • Quote
Front Page | Welcome | Contact | Privacy Policy | Terms of Service | Advertise | Support BGG | Feeds RSS
Geekdo, BoardGameGeek, the Geekdo logo, and the BoardGameGeek logo are trademarks of BoardGameGeek, LLC.