The Return of Talking Time

Go Back   The Return of Talking Time > Talking about media > Talking about television games

Reply
 
Thread Tools Display Modes
  #61  
Old 01-27-2014, 01:54 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Alright, I've added the temporary "Demo Tab - Hotness Column" sheet, all the way at the end with data from the PS2 sheet. I had to tweak the formula just a little bit to not break on space since we have peeps with spaces in their handles. As long as everyone uses commas (or ; or . or ? or !) to separate we'll be apples.

I also deviated from the current color scheme by going with rainbow in increments of three to demonstrate the possibilities.

So go check 'er out! Add more peeps to the bandwagon and see what happens. Try sorting by hotness. Add a new title or three. Let me know how it goes.
Reply With Quote
  #62  
Old 01-27-2014, 01:58 PM
bobbywatson's Avatar
bobbywatson bobbywatson is offline
Random guy
 
Join Date: Feb 2010
Location: Saguenay, QC, Canada
Posts: 2,876
Default

Also: Can we set the Vertical alignment of cells to 'Top'? I think it would be a big help for lines where the comments go for quite a while. I'm fine with long comments, but scrolling to see the name of the game that go with it is a bit annoying.
Reply With Quote
  #63  
Old 01-27-2014, 01:59 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Quote:
Originally Posted by Destil View Post
ARGH, why are we mixing carriage returns and comas when delimiting names in the likes column!?

Any way to enforce transformation to one method via a macro in google sheets?
Yes, human turks. :P

Where do you see it? I'd like to know in case it's breaking my Hotness formula.
Reply With Quote
  #64  
Old 01-27-2014, 02:02 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Quote:
Originally Posted by bobbywatson View Post
Also: Can we set the Vertical alignment of cells to 'Top'? I think it would be a big help for lines where the comments go for quite a while. I'm fine with long comments, but scrolling to see the name of the game that go with it is a bit annoying.
Yes. In the icon function bar, it's the sixth from the right. Looks like an arrow pointing down at a horizontal bar. I just applied it to the "Demo Tab - Hotness Column" in case you'd like to see what it's like.
Reply With Quote
  #65  
Old 01-27-2014, 02:06 PM
Kirin's Avatar
Kirin Kirin is online now
Not a Beer
 
Join Date: Jun 2007
Location: NC
Posts: 18,405
Default

Quote:
Originally Posted by estragon View Post
Deleting the names for a MOST OF is a bad idea, because then how does it count to 15 for an ALL OF. Also, depending on participation 10/15 might be too low of a standard.

I guess people could add names to a MOST OF, but some people might forget whether or not they were part of the original MOST OF group.
The names aren't being (or aren't supposed to be) deleted - they're moved to a note you can see by hovering over the cell. So you can still check if you're already in there, and you can add to the list within the note. Part of the idea is to stop rows from getting really tall just from all the names being displayed.
Reply With Quote
  #66  
Old 01-27-2014, 02:08 PM
Destil's Avatar
Destil Destil is offline
Red Mage
 
Join Date: Jul 2007
Location: Tucson, AZ
Posts: 19,627
Default

Quote:
Originally Posted by Ted View Post
Yes, human turks. :P

Where do you see it? I'd like to know in case it's breaking my Hotness formula.
I fixed the ones I saw, may be more since I only noticed when I was adding my name.
Reply With Quote
  #67  
Old 01-27-2014, 02:23 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Something else to consider: shall we freeze the first column so we always see the game name? I suspect horizontal scrolling will be inevitable.
Reply With Quote
  #68  
Old 01-27-2014, 02:26 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Quote:
Originally Posted by Destil View Post
I fixed the ones I saw, may be more since I only noticed when I was adding my name.
No worries, I checked things out in the sandbox. As long as we still have a delimiter the newlines won't break the hotness.

Still, puzzling how they got there in the first place. I had to Ctrl-Enter to get one in.
Reply With Quote
  #69  
Old 01-27-2014, 02:29 PM
MCBanjoMike's Avatar
MCBanjoMike MCBanjoMike is offline
Hot sports journalist
 
Join Date: Jul 2007
Location: Montreal
Posts: 15,162
Default

The Hotness column is a decent idea, but from looking at the demo page, I feel like color coding every game just makes things visually noisy. We've already got a lot of lesser known games on this list because one or two people want to evangelize them, so keeping most of the rows white will help the ones that have critical mass really stand out.

That said, the Hotness Index could be useful for a separate tab where we sort the games by popularity, as an informal way of generating TT's Top Games list. That list could also benefit from a "System" column.

Also, I'm really not sure we should divide PC games by "Steam" and "Not Steam" categories. They all run on the same computer, and games often appear/disappear from the service. I doubt that anyone really wants to take on the job of moving games as they get added to Steam.
Reply With Quote
  #70  
Old 01-27-2014, 02:40 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Quote:
Originally Posted by MCBanjoMike View Post
The Hotness column is a decent idea, but from looking at the demo page, I feel like color coding every game just makes things visually noisy. We've already got a lot of lesser known games on this list because one or two people want to evangelize them, so keeping most of the rows white will help the ones that have critical mass really stand out.
You make a good point, and fortunately the color-coding levels are easily tuned. I set the colors back to the current set up (10+ = green, 15+ = yellow) in the sandbox.
Reply With Quote
  #71  
Old 01-27-2014, 02:57 PM
dosboot's Avatar
dosboot dosboot is offline
Senior Member
 
Join Date: Jun 2007
Posts: 4,007
Default

Quote:
Originally Posted by MCBanjoMike View Post
Also, I'm really not sure we should divide PC games by "Steam" and "Not Steam" categories. They all run on the same computer, and games often appear/disappear from the service. I doubt that anyone really wants to take on the job of moving games as they get added to Steam.
Yeah, I don't like dividing them either. Here's another reason: when a new game is added by someone, what are the chances they'll want to check if a game is even currently on Stream before adding it to non-Steam?

The "Other Notes" column seems like a better place to put "Available on Steam".
Reply With Quote
  #72  
Old 01-27-2014, 03:00 PM
Destil's Avatar
Destil Destil is offline
Red Mage
 
Join Date: Jul 2007
Location: Tucson, AZ
Posts: 19,627
Default

Other notes is already clogged with remakes, reboots and alternate systems a game is available on. Perhaps just a dedicated 'Other Versions' column?

What about big multi-platform stuff? Where does Saint's Row IV go on this list? Is it easier to make these their own sheet?
Reply With Quote
  #73  
Old 01-27-2014, 03:09 PM
aturtledoesbite's Avatar
aturtledoesbite aturtledoesbite is offline
hi there
 
Join Date: Jun 2013
Location: Lafayette, LA
Posts: 14,053
Default

Quote:
Originally Posted by dosboot View Post
Yeah, I don't like dividing them either. Here's another reason: when a new game is added by someone, what are the chances they'll want to check if a game is even currently on Stream before adding it to non-Steam?

The "Other Notes" column seems like a better place to put "Available on Steam".
To be fair, I checked if Aces Wild had been released on Steam when thinking about putting it on the list.

Then I got too busy playing Aces Wild to put it on the list.
Reply With Quote
  #74  
Old 01-27-2014, 03:18 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Quote:
Originally Posted by aturtledoesbite View Post
To be fair, I checked if Aces Wild had been released on Steam when thinking about putting it on the list.

Then I got too busy playing Aces Wild to put it on the list.
Sounds like you're doing it right!
Reply With Quote
  #75  
Old 01-27-2014, 03:27 PM
Googleshng's Avatar
Googleshng Googleshng is offline
Senior Member
 
Join Date: Jul 2008
Location: CT
Posts: 15,357
Default

Quote:
Originally Posted by Destil View Post
Other notes is already clogged with remakes, reboots and alternate systems a game is available on. Perhaps just a dedicated 'Other Versions' column?

What about big multi-platform stuff? Where does Saint's Row IV go on this list? Is it easier to make these their own sheet?
It probably really is, yeah. Or, really, merge PS3 and 360 together, make a note that Demon's Souls is PS3 exclusive, and take it for granted that anything on that list is also on steam.

Also, I can't help but wonder if 15 seconds is maybe too low a bar for "ALL THE TYRANTS." I mean heck, FF10 is halfway to that point.
Reply With Quote
  #76  
Old 01-27-2014, 03:29 PM
Galadrome's Avatar
Galadrome Galadrome is online now
Senior Member
 
Join Date: May 2013
Location: The Capital of Canada
Posts: 2,093
Default

I added the Smash Bros. games but don't feel like writing about them. I'll let someone else do that.
Reply With Quote
  #77  
Old 01-27-2014, 03:29 PM
aturtledoesbite's Avatar
aturtledoesbite aturtledoesbite is offline
hi there
 
Join Date: Jun 2013
Location: Lafayette, LA
Posts: 14,053
Default

I top-aligned all the pages. Feel free to change it back if you think bottom-align is better.
Reply With Quote
  #78  
Old 01-27-2014, 03:36 PM
Ted Ted is online now
Senior Member
 
Join Date: Aug 2010
Posts: 4,019
Default

Quote:
Originally Posted by Destil View Post
What about big multi-platform stuff? Where does Saint's Row IV go on this list? Is it easier to make these their own sheet?
The only other option I can come up with at the moment is to have an entry for each relevant tab, with all but one saying "see tab X", and that sounds like work.

At the moment I can get behind a combined PS360 tab.

Quote:
Originally Posted by aturtledoesbite
I top-aligned all the pages. Feel free to change it back if you think bottom-align is better.
Good work, sir! I think it looks dandy.
Reply With Quote
  #79  
Old 01-27-2014, 03:41 PM
Destil's Avatar
Destil Destil is offline
Red Mage
 
Join Date: Jul 2007
Location: Tucson, AZ
Posts: 19,627
Default

PCS36ii?
Reply With Quote
  #80  
Old 01-27-2014, 03:55 PM
aturtledoesbite's Avatar
aturtledoesbite aturtledoesbite is offline
hi there
 
Join Date: Jun 2013
Location: Lafayette, LA
Posts: 14,053
Default

Quote:
Originally Posted by Destil View Post
PCS36ii?
I think the least-unwieldy portmanteau is PSWii60.

But the Wii isn't in that category anyway.
Reply With Quote
  #81  
Old 01-27-2014, 03:56 PM
Destil's Avatar
Destil Destil is offline
Red Mage
 
Join Date: Jul 2007
Location: Tucson, AZ
Posts: 19,627
Default

You're missing the PC, there.

PS36C?
Reply With Quote
  #82  
Old 01-27-2014, 03:57 PM
Falselogic's Avatar
Falselogic Falselogic is offline
Threadcromantosaurus Rex
 
Join Date: Aug 2007
Location: California
Posts: 27,959
Default

just call the tab Multi - talks in the multi thread should say which version to get is best
Reply With Quote
  #83  
Old 01-27-2014, 03:59 PM
Patrick's Avatar
Patrick Patrick is offline
is Earnest
 
Join Date: Aug 2007
Posts: 16,916
Default

This spreadsheet desperately wants to be a database.
Reply With Quote
  #84  
Old 01-27-2014, 04:24 PM
Kazin's Avatar
Kazin Kazin is offline
The 6 Million Gil Catboi
 
Join Date: Aug 2008
Posts: 5,201
Default

Apparently, Googleshng and I have very similar tastes, it seems, from how often his name is already in the "seconded" box by the time I go to add mine to it.

I like this thing. This spreadsheet is good.
Reply With Quote
  #85  
Old 01-27-2014, 04:46 PM
Mogri's Avatar
Mogri Mogri is offline
Yes, let's feast!
 
Join Date: Sep 2011
Location: Austin, TX
Posts: 13,675
Default

Quote:
Originally Posted by Googleshng View Post
Also, I can't help but wonder if 15 seconds is maybe too low a bar for "ALL THE TYRANTS." I mean heck, FF10 is halfway to that point.
Needs a "CONTROVERSIAL" designation, then.
Reply With Quote
  #86  
Old 01-27-2014, 05:18 PM
Seven Seven is offline
Senior Member
 
Join Date: Jul 2012
Location: Texas
Posts: 1,693
Default

This is a great idea, looking forward to all the different games everyone will be adding to the list.
Reply With Quote
  #87  
Old 01-27-2014, 05:25 PM
woofbro woofbro is offline
goodbye
 
Join Date: Jul 2010
Location: Australia
Posts: 355
Default

Quote:
Originally Posted by patrick View Post
This spreadsheet desperately wants to be a database.
I don't know if somewhere down the line this would be considered. But I know members of /v/ keep an archive of recommended games on a Wikia.

I like the design of the document we have thus far though. It's super easy/efficient to just add new content and comment on something pre-existing.
Reply With Quote
  #88  
Old 01-27-2014, 08:46 PM
breakman's Avatar
breakman breakman is offline
do-do-doo do-doo
 
Join Date: Dec 2009
Posts: 3,013
Default

Quote:
Originally Posted by Googleshng View Post
Also, I can't help but wonder if 15 seconds is maybe too low a bar for "ALL THE TYRANTS." I mean heck, FF10 is halfway to that point.
Not seeing a problem there. I do find it troubling that Super Metroid hasn't reached "ALL THE TYRANTS" status yet.

BTW, Donkey Kong '94 already has enough names for "ALL THE TYRANTS," but I didn't want to try and figure out how to change it right now.
Reply With Quote
  #89  
Old 01-27-2014, 08:49 PM
aturtledoesbite's Avatar
aturtledoesbite aturtledoesbite is offline
hi there
 
Join Date: Jun 2013
Location: Lafayette, LA
Posts: 14,053
Default

Quote:
Originally Posted by breakman View Post
BTW, Donkey Kong '94 already has enough names for "ALL THE TYRANTS," but I didn't want to try and figure out how to change it right now.
Done.
Reply With Quote
  #90  
Old 01-27-2014, 10:35 PM
Rascally Badger's Avatar
Rascally Badger Rascally Badger is online now
This Guy
 
Join Date: Jan 2008
Location: Hell, Earth
Posts: 8,273
Default

I went around seconding some stuff. Maybe tomorrow I'll get around to adding some games.
Reply With Quote
Reply

Tags
good games , i made a spreadsheet , recommendations

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Your posts İyou, 2007