Bay 12 Games Forum

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1] 2

Author Topic: Finds best video game publications  (Read 1326 times)

ran88dom99

  • Escaped Lunatic
    • View Profile
Finds best video game publications
« on: July 11, 2016, 08:05:35 pm »

Sheet: https://mega.nz/#!AEBXTD7L!xUHzf4Xhp_Xt-kUlh_4oW1YXxRE1kK84BPFXzB6zD90
Video: https://www.youtube.com/watch?v=AIZe7sKGvdY

 I made a spreadsheet that finds publications with same tastes as the user then averages their review scores into a personalized meta-score. Technical name Collaborative_filtering. People usually listen to sources of info that have been honest or useful because those sources usually continue to be useful. This sheet just speeds up the process. If publications rate relatively objectively, using this sheet will punish hype and selling out. Bad publications don't matter if no one sees them. This approach should also solve all the metacritic, rating and belly flop controversy. 
 
In a more general sense the sheet is supposed to teach open office, what can be accomplished with CPU & net and how to filter through the flood of misinformation to find productive truth. That last one is critical to democracy in current society. PMC sheet can also be used for a bunch of statistics, like which games are most divisive (highest average deviation, column N) or which publications agree most with averaged user reviews (copy 'user reviews' column in to input "by me" AD column).

It works. I found and subscribed to PCGamer because of this sheet. The metrics almost always say the new PMC fits my scores much more than the MC. You will know everything works when 'Emphasis' marks games you forgot to rate. Unfortunately rankings/recommendations will only slightly move the games around due to the "objective" and commonly agreed apon effect.

Help with continued development: Genera are somewhat incorrect. A real statistician going over it all would be nice. Those numbers, I mean what do they REALLY mean? A real OOO pro too. Some find function that outputs arrays of cell references and can be used IN an array calculation. Or a RANKIF. I need a way to hash? new data into the already existent sort and categories. Average user can contribute clearly obviously over/under rated games. More data with similar game names format. Make it all look nicer.  Maybe reduce the difference between platforms. Maybe get more independent publications or Shows instead of Games. I live off comments and suggestions.

Blue is what you edit and yellow is the more important information. You need the latest libreoffice to run the actual sheet. When you are done entering or tweaking press F9 to run calculations.  Use Ctrl-f to find 1s representing one of choosing algorithm's chosen rows or columns. Some data from http://evilasahobby.com/2013/09/27/metacritic-the-data/.  Other from Portia and Importio and Metcritic.com. Thanks OOO calc forum and NP++. Similar sites include opencritic.com, the defunct everyonesacritc, and for user based recommendations try listal, tastekid, critiker.

               USAGE   GUIDE

First you must input your scores into column AD using one of three methods: Just the games you like and high scores for them.-(taste only) Include games you found over rated or just hated and maybe borrow from the common over-under rated list or user review to publication average score difference.-(objectivity) The point of scores is to say which games are better than another so select a genera you know very well and (first sort into categories) first rank, then rate all the games in it.-(taste) You can rate games with one of two goals; what the games objectively deserve (objectivity) and what you feel they deserve (taste).
Don't rate a game higher or lower than max or min respectively. If you are using Base Difference, rating more extremely than BD will penalize a publication that gave it a score close to your own, more than ones that avoided it entirely. Check 'Friction' for games chosen publications think you misrated.


Set the publications choosing algorithm: AE5 sets number of publications to use. Adjust according to metrics and use more publications if scoring goal is objectivity. Using few publications means the recommendations get alot more exciting but Emphasis becomes weird.
 Three nomials make up the polynomial that decides the final score. Average difference X percentage intersections + Base Difference X (100 - percentage intersections)  -  correlation X 1/(1-Sqrt(number intersections-4)). Correlation AE8 does not really work without many game scores in common.
 Base Difference should start around the average difference calculations AB11:AE13. AE9 sets minimal % of games user scored that chosen publications must review aka Intersections. If both Base Difference and Intersections are set too low, user input scores get all the Emphasis but the recommendations will show that this PMC is useless.

 Each publication and user uses a unique scoring system including different distributions and values such as objectivity and, for example, educational value. The only thing that reliably has the same meaning across sources is the ranking of each entertainment object against other objects in a similar category such as movies in the horror genera. There are a bunch of metrics describing how good new PMC is compared to old MC. Cell addresses stated here are for PMC. MC's equivalent is usually to the left.  Most, AB11:AE13 AC7-8, show how much closer to user ratings the new PMC is. AC9,10,3 describe volume of reviews.  3 cells at column S describe how much chosen publications agree with each other 'cohesion'.

All blue cells to the left modify the game choosing algorithms of columns T & Z. 'Emphasis' = (MC score for this game - PMC score for this game) X number of Chosen publications rating this game. Its supposed to represent how much PMC disagrees with MC. 'Friction' is the same thing but between you and PMC. Input in W10 amount of most emphasized games to be selected in column T.  Both columns can be set to require the other in W9 & Y11. Most requirements are disabled by setting their cells to 0 or nothing. Right column can help decide which games to review.
« Last Edit: July 12, 2016, 08:02:21 am by ran88dom99 »
Logged

Tawa

  • Bay Watcher
  • the first mankind all over the world
    • View Profile
Re: Finds best video game publications
« Reply #1 on: July 11, 2016, 08:15:15 pm »

...I want to say yes, but the "signed up two years ago" bit throws me off.
Logged
I don't use Bay12 much anymore. PM me if you need to get in touch with me and I'll send you my Discord handle.

Teneb

  • Bay Watcher
  • (they/them) Penguin rebellion
    • View Profile
Re: Finds best video game publications
« Reply #2 on: July 11, 2016, 08:21:26 pm »

Looks like we got sleeper spambots now.
Logged
Monstrous Manual: D&D in DF
Quote from: Tack
What if “slammed in the ass by dead philosophers” is actually the thing which will progress our culture to the next step?

Baffler

  • Bay Watcher
  • Caveat Lector.
    • View Profile
Re: Finds best video game publications
« Reply #3 on: July 11, 2016, 08:45:24 pm »

Maybe someone sold off their account hoping it's age would throw us off?
Logged
Quote from: Helgoland
Even if you found a suitable opening, I doubt it would prove all too satisfying. And it might leave some nasty wounds, depending on the moral high ground's geology.
Location subject to periodic change.
Baffler likes silver, walnut trees, the color green, tanzanite, and dogs for their loyalty. When possible he prefers to consume beef, iced tea, and cornbread. He absolutely detests ticks.

TheBiggerFish

  • Bay Watcher
  • Somewhere around here.
    • View Profile
Re: Finds best video game publications
« Reply #4 on: July 11, 2016, 09:43:02 pm »

I think this might be an actual person.  I'm not downloading a random Internet file but I detect no shilling and they're asking for help with this thing.  And it's coherent, if perhaps mistitled.

And it's a LibreOffice file apparently.  I mean, what kind of spambot uses LibreOffice?

Then again, this is apparently their only post so...Yeah.  I'm not actually sure, but in my (probably not well-informed) judgement, they're NOT a spambot, guys.

I mean, they're misusing punctuation right, even.

And there's MATH.
« Last Edit: July 11, 2016, 09:47:44 pm by TheBiggerFish »
Logged
Sigtext

It has been determined that Trump is an average unladen swallow travelling northbound at his maximum sustainable speed of -3 Obama-cubits per second in the middle of a class 3 hurricane.

BorkBorkGoesTheCode

  • Bay Watcher
    • View Profile
Re: Finds best video game publications
« Reply #5 on: July 11, 2016, 09:46:06 pm »

I know of a guy who hasn't posted in years, yet signs into their account frequently.
Logged
https://en.wikipedia.org/wiki/The_Treachery_of_Images

Believe nothing you hear. Or everything. Have fun. Love when?

I frequently use PMs to contact people if I think they would miss a post in the deluge.

Teneb

  • Bay Watcher
  • (they/them) Penguin rebellion
    • View Profile
Re: Finds best video game publications
« Reply #6 on: July 11, 2016, 09:50:41 pm »

I think this might be an actual person.  I'm not downloading a random Internet file but I detect no shilling and they're asking for help with this thing.  And it's coherent, if perhaps mistitled.

And it's a LibreOffice file apparently.  I mean, what kind of spambot uses LibreOffice?

Then again, this is apparently their only post so...Yeah.  I'm not actually sure, but in my (probably not well-informed) judgement, they're NOT a spambot, guys.

I mean, they're misusing punctuation right, even.

And there's MATH.
Next thing we know you'll be arguing it can captcha.
Logged
Monstrous Manual: D&D in DF
Quote from: Tack
What if “slammed in the ass by dead philosophers” is actually the thing which will progress our culture to the next step?

penguinofhonor

  • Bay Watcher
  • Minister of Love
    • View Profile
Re: Finds best video game publications
« Reply #7 on: July 11, 2016, 09:53:30 pm »

There are plenty of bots nowadays that ask for people to provide them with information. You can sell information. This one could literally be doing market research for game journalism sites.

Personal information can also be used to create more realistic-looking bots. There are bots on dating sites that send out links to "applications" to meet up with them that they use to make more fake profiles.
« Last Edit: July 11, 2016, 09:55:38 pm by penguinofhonor »
Logged

BorkBorkGoesTheCode

  • Bay Watcher
    • View Profile
Re: Finds best video game publications
« Reply #8 on: July 11, 2016, 09:54:32 pm »

There are plenty of bots nowadays that ask for people to provide them with information. You can sell information. This one could literally be doing market research for game journalism sites. Personal information can also be used to create more realistic-looking bots.
This is  very plausible.
Logged
https://en.wikipedia.org/wiki/The_Treachery_of_Images

Believe nothing you hear. Or everything. Have fun. Love when?

I frequently use PMs to contact people if I think they would miss a post in the deluge.

TheBiggerFish

  • Bay Watcher
  • Somewhere around here.
    • View Profile
Re: Finds best video game publications
« Reply #9 on: July 11, 2016, 09:56:49 pm »

You're right, if there's a bot here.  But I somehow doubt a spambot's going to ask B12 to check its work.
Logged
Sigtext

It has been determined that Trump is an average unladen swallow travelling northbound at his maximum sustainable speed of -3 Obama-cubits per second in the middle of a class 3 hurricane.

TheDarkStar

  • Bay Watcher
    • View Profile
Re: Finds best video game publications
« Reply #10 on: July 11, 2016, 09:59:36 pm »

If he makes more human-seeming posts, then we know he is not a spambot. If no other posts are made, then it's a spambot.
Logged
Don't die; it's bad for your health!

it happened it happened it happen im so hyped to actually get attacked now

TheBiggerFish

  • Bay Watcher
  • Somewhere around here.
    • View Profile
Re: Finds best video game publications
« Reply #11 on: July 11, 2016, 10:00:54 pm »

Indeed.

If they reply to PMs, they are also probably human.
Logged
Sigtext

It has been determined that Trump is an average unladen swallow travelling northbound at his maximum sustainable speed of -3 Obama-cubits per second in the middle of a class 3 hurricane.

ran88dom99

  • Escaped Lunatic
    • View Profile
Re: Finds best video game publications
« Reply #12 on: July 12, 2016, 04:20:32 am »

I'm a real boy! How is the video? Do you want me to upload somewhere specific?
« Last Edit: July 12, 2016, 05:15:07 am by ran88dom99 »
Logged

ran88dom99

  • Escaped Lunatic
    • View Profile
Re: Finds best video game publications
« Reply #13 on: July 12, 2016, 12:19:52 pm »

Does anyone know publications that reviewed and gave a score to DF?
Logged

Culise

  • Bay Watcher
  • General Nuisance
    • View Profile
Re: Finds best video game publications
« Reply #14 on: July 12, 2016, 01:22:51 pm »

See this is what I hate. I still can't tell because we;ve been getting more and more intelligent spambots.

I recall one that replied in a somewhat human manner, and reported people that called it out. (Although the mod reports, rather amusingly, were apparently just things like ????????)
The true thrust of research into strong AI is no longer research labs at Caltech or Harvard, nor is it DARPA or the NSA.  No, when the end comes, it shall not be in nuclear fire or a robot horde; we shall fall under a flood of kitchen sinks. 

Does anyone know publications that reviewed and gave a score to DF?
Though there are full-length reviews out there, I don't know any reviews that gave a numeric score myself, and I didn't find any on an admittedly rather cursory search.  I would be surprised to find some, though, given that in spite of its breadth of scope and scale and in spite of the fact that it compares favorably to many game releases, Dwarf Fortress has not actually officially released yet.  We're still in alpha, basically.
Logged
Pages: [1] 2