Satoshi Ookami Posted April 18, 2016 Share Posted April 18, 2016 No i meant just copy their PSN name on the forum to google docs. That way you just can't make a mistake. Oh, that way, yea, that could work. But the problem would be the font you copy. =D Or if you were to copy a link, it would be formatted as link =D It has been made. Oho, sasuga! Link to comment Share on other sites More sharing options...
HcG Clawz Posted April 18, 2016 Share Posted April 18, 2016 Oh, that way, yea, that could work. But the problem would be the font you copy. =D Or if you were to copy a link, it would be formatted as link =D Oho, sasuga! Well if you go to someones profile the link would be psnprofiles.com/username then just copy the username and everything is alright. At least this is how i always do it and there is no possible way that this could go wrong. Link to comment Share on other sites More sharing options...
Matto_lsi Posted April 18, 2016 Share Posted April 18, 2016 I thought we resolved everything pretty quickly? Iirc there weren't many tabs not updated. There was more an issue with the spelling of your name as well as one tab giving you the wrong rank. That aside, i agree that the leaderboard spreadsheet is far from perfect. Between the loading times and spelling mistakes there are a few of PP creators that forget to update or are just too busy, which i totally understand. Anyway, having one person in charge is just not doable. I don't think anybody would be willing to be responsible for something like that. It was resolved quickly (and thank you for that), but afterward I went through a few leaderboards (which have since been updated) and they were missing a lot of other people from ranks the specific PP said they had earned. And for me personally that was actually the second time it wasn't correct, and not all the missing points were due to misspelled username. I was just speculating that it might be an issue with so many different people needing to update the file for it to be complete that there might be a reason to find a volunteer to keep it updated regularly. Of course this means the PP owners would need to have their lists updated too, but it would mean less chance of missing people. It does look like things are up to date now, I'm just speaking of past experience and thinking that over time people will be checking their PPs less and less and those who've added plats or recently joined might get lost among the large number of PP threads. And I think the leaderboard is great. It's not like the board is failing to do the job, it's just that it needs regular updates (and that's dependent on humans, and lots of them). I'm not sure if any of the other programs linked will help to streamline or automate the process, but for what it is, I do like it. Link to comment Share on other sites More sharing options...
xZoneHunter Posted April 18, 2016 Author Share Posted April 18, 2016 It was resolved quickly (and thank you for that), but afterward I went through a few leaderboards (which have since been updated) and they were missing a lot of other people from ranks the specific PP said they had earned. And for me personally that was actually the second time it wasn't correct, and not all the missing points were due to misspelled username. I was just speculating that it might be an issue with so many different people needing to update the file for it to be complete that there might be a reason to find a volunteer to keep it updated regularly. Of course this means the PP owners would need to have their lists updated too, but it would mean less chance of missing people. It does look like things are up to date now, I'm just speaking of past experience and thinking that over time people will be checking their PPs less and less and those who've added plats or recently joined might get lost among the large number of PP threads. And I think the leaderboard is great. It's not like the board is failing to do the job, it's just that it needs regular updates (and that's dependent on humans, and lots of them). I'm not sure if any of the other programs linked will help to streamline or automate the process, but for what it is, I do like it. Ofcourse if someone would be in charge to update the leaderboard regulary, there will be less mistakes. But as i said, i don't think we're going to find such a volunteer. Link to comment Share on other sites More sharing options...
Hemiak Posted April 18, 2016 Share Posted April 18, 2016 just an fyi, as I was updating my pages today and re-entering A-Brawl3r's name, it tried to auto-fill it with a fully non-capitalized version, so somebody made a booboo. Link to comment Share on other sites More sharing options...
Shana Alter Posted April 18, 2016 Share Posted April 18, 2016 just an fyi, as I was updating my pages today and re-entering A-Brawl3r's name, it tried to auto-fill it with a fully non-capitalized version, so somebody made a booboo. I am fairly certain upper/lower-case makes no difference to the leaderboard unlike an extra space, wrong letter or either of these added wrong -_. Link to comment Share on other sites More sharing options...
xZoneHunter Posted April 19, 2016 Author Share Posted April 19, 2016 (edited) just an fyi, as I was updating my pages today and re-entering A-Brawl3r's name, it tried to auto-fill it with a fully non-capitalized version, so somebody made a booboo. It will always do that, as the source from which the list is compiled is column A of the 'Alpha Sorted' tab. All the names there are uncapitalized. Which is necessary because the sheets treats capitalized letters as unique variables. Oho, sasuga! But whatever the case, i don't think it'll work. I've been doing some testing and once i add a new user the whole thing dies on me. Basically what i did was make a validation rule for each cel in column A of each tab. The rule states that each cell's content has to match anything that is in the Source ('Alpha Sorted') Column A. But once you add a name that doesn't exist it'll error and i just get the usual "N/A" response. I have no idea why really, i thought it'd work well. I hate excel... Where is Ric when i need him. Now what i could do is make an extra tab to just type in new users, so they'll get added to the source tab first before going through the validation rule but that would be pretty orthodox. Don't you program? AFAIK google sheets works with javascript. Why don't you write something for us.... Anyway i'll be going to fix this ASAP but as for now the leaderboard will be under maintenance, meaning nobody can edit. Edited April 19, 2016 by Zone Hunter Link to comment Share on other sites More sharing options...
Satoshi Ookami Posted April 19, 2016 Share Posted April 19, 2016 But whatever the case, i don't think it'll work. I've been doing some testing and once i add a new user the whole thing dies on me. Basically what i did was make a validation rule for each cel in column A of each tab. The rule states that each cell's content has to match anything that is in the Source ('Alpha Sorted') Column A. But once you add a name that doesn't exist it'll error and i just get the usual "N/A" response. I have no idea why really, i thought it'd work well. I hate excel... Where is Ric when i need him. Ah, crap it :/ I thought it would work :/ Now what i could do is make an extra tab to just type in new users, so they'll get added to the source tab first before going through the validation rule but that would be pretty orthodox. But it could work Don't you program? AFAIK google sheets works with javascript. Why don't you write something for us.... I'm not sure if you can edit the core structure... I may check it =D Link to comment Share on other sites More sharing options...
Doom Posted April 19, 2016 Share Posted April 19, 2016 Problems aside, copy/pasting the username in the profile's url is the best way to avoid misspelling. Link to comment Share on other sites More sharing options...
xZoneHunter Posted April 19, 2016 Author Share Posted April 19, 2016 (edited) Leaderboad is fixed, so PP creators can edit again. Ah, crap it :/ I thought it would work :/ But it could work I'm not sure if you can edit the core structure... I may check it =D In google sheets there is a script editor. I'm not entirely sure you can access it with just editing rights, but it's located at Tools > Script Editor. Currently we're using some script that Ric found that pretty much does everything in the sheet. Edited April 19, 2016 by Zone Hunter Link to comment Share on other sites More sharing options...
Satoshi Ookami Posted April 19, 2016 Share Posted April 19, 2016 In google sheets there is a script editor. I'm not entirely sure you can access it with just editing rights, but it's located at Tools > Script Editor. Currently we're using some script that Ric found that pretty much does everything in the sheet. Yea, it seems I can access it at least. Guess I will try some things on personal spreadsheet to see if something can be done =D Link to comment Share on other sites More sharing options...
Wavergray Posted April 20, 2016 Share Posted April 20, 2016 I saw that post linked on the first page and I might say that there are two games that should be added: Platinum: Shantae and the Pirate's Curse (released tomorrow) 100%: ShantaeShantae: Risky's Revenge - Director's Cut Both are metroidvanias in a similar style to Guacamelee: One big interconnected map with several mini-dungeons, upgrades that help you to reach new places and some backtracking. They will be added to the PP as will Shadow Complex Remastered when it's released on may 3rd. Also a question for everyone, should Salt and Sanctuary be in the metroidvania PP or should it be saved for the Soulslike PP? 1 Link to comment Share on other sites More sharing options...
ThiophenSJ Posted April 20, 2016 Share Posted April 20, 2016 They will be added to the PP as will Shadow Complex Remastered when it's released on may 3rd. Also a question for everyone, should Salt and Sanctuary be in the metroidvania PP or should it be saved for the Soulslike PP? Damn, and I was thinking I could go auto-plat-rank when the PP starts. But anyway, cool that new Metroidvania games are coming - can never get too much of that genre. Link to comment Share on other sites More sharing options...
zajac9999 Posted April 20, 2016 Share Posted April 20, 2016 Damn, and I was thinking I could go auto-plat-rank when the PP starts. But anyway, cool that new Metroidvania games are coming - can never get too much of that genre. Lol same, guess I'll have to put a bit of work in. Was also gonna auto-plat-rank Ship Scrollers and look what happened to that. :'( Link to comment Share on other sites More sharing options...
HcG Clawz Posted April 20, 2016 Share Posted April 20, 2016 Lol same, guess I'll have to put a bit of work in. Was also gonna auto-plat-rank Ship Scrollers and look what happened to that. :'( There's one thing you can do about it Link to comment Share on other sites More sharing options...
zajac9999 Posted April 20, 2016 Share Posted April 20, 2016 There's one thing you can do about it I was thinking about running it actually, I don't have a lot of time atm though so I was gonna ask Zone about how much work is involved in the set-up and initial running of a PP. I imagine one like that would quieten down pretty quickly. Link to comment Share on other sites More sharing options...
xZoneHunter Posted April 20, 2016 Author Share Posted April 20, 2016 I was thinking about running it actually, I don't have a lot of time atm though so I was gonna ask Zone about how much work is involved in the set-up and initial running of a PP. I imagine one like that would quieten down pretty quickly. Not much work is involved honestly. I mean you have to make the thread, maybe ask somebody to make a fancy banner and some trophy images. All that's left then is adding sign ups to your thread as well as the leaderboard, but it's not too much of a hassle. There are a few less popular PPs that haven't had a reply in a while, but overall i'm pretty surprised that a lot of them are still getting almost daily activity. Link to comment Share on other sites More sharing options...
Hemiak Posted April 20, 2016 Share Posted April 20, 2016 I'd like to put a couple games on reserve for the ps4 Challenge Accepted thread. I think what I'm going to do is have a reserve section that lasts until the game has been out for 2-3 months, so that I can be sure it meets the requirements, before adding it and changing rankings around. Games I'd like to reserve (unless somebody has a better home for them) Trackmania Turbo Enter the Gungeon Mirrors Edge Catalyst (when it releases) 2 Link to comment Share on other sites More sharing options...
xZoneHunter Posted April 20, 2016 Author Share Posted April 20, 2016 I'd like to put a couple games on reserve for the ps4 Challenge Accepted thread. I think what I'm going to do is have a reserve section that lasts until the game has been out for 2-3 months, so that I can be sure it meets the requirements, before adding it and changing rankings around. Games I'd like to reserve (unless somebody has a better home for them) Trackmania Turbo Enter the Gungeon Mirrors Edge Catalyst (when it releases) Trackmania definitely fits the bill, the black tracks are insane. 1 Link to comment Share on other sites More sharing options...
Wavergray Posted April 21, 2016 Share Posted April 21, 2016 I'd like to put a couple games on reserve for the ps4 Challenge Accepted thread. I think what I'm going to do is have a reserve section that lasts until the game has been out for 2-3 months, so that I can be sure it meets the requirements, before adding it and changing rankings around. Games I'd like to reserve (unless somebody has a better home for them) Enter the Gungeon I think Enter the Gungeon should be saved for a PP that uses it, The Binding of Isaac: Rebirth and Crypt of the NecroDancer. Link to comment Share on other sites More sharing options...
zadorvp Posted April 21, 2016 Share Posted April 21, 2016 Hey, I'll claim Blues and Bullets for my Choice & Consequence PP, though it won't be required just yet on account of being episodic and unfinished (hopefully it does get finished someday now that the PS4 version they've been working on is out...) right now. Link to comment Share on other sites More sharing options...
zajac9999 Posted April 21, 2016 Share Posted April 21, 2016 Not much work is involved honestly. I mean you have to make the thread, maybe ask somebody to make a fancy banner and some trophy images. All that's left then is adding sign ups to your thread as well as the leaderboard, but it's not too much of a hassle. There are a few less popular PPs that haven't had a reply in a while, but overall i'm pretty surprised that a lot of them are still getting almost daily activity. Put me down to run the ship scrollers one then please Zone. Doesn't sound too bad tbh, assuming someone more talented than myself makes the banner and images. 1 Link to comment Share on other sites More sharing options...
GarciaFever Posted April 21, 2016 Share Posted April 21, 2016 (edited) Yeah, I agree. Recently it became that popular as "vita has no games".. Some people probably say that because they probably want more AAA games for the vita, which I think is sad. Edited April 21, 2016 by GarciaFever Link to comment Share on other sites More sharing options...
OmegaFenron Posted April 21, 2016 Share Posted April 21, 2016 Ship Scroller PP Velocity Ultra Velocity 2X Resogun Super Stardust Ultra PixelJunk Shooter Ultimate If you know others, make sure to let me know so they can be added! (I know I'm short on posts so I can't host it but I'm just making the list ) Blast Factor for an extra bonus Link to comment Share on other sites More sharing options...
Xionx Posted April 22, 2016 Share Posted April 22, 2016 assuming someone more talented than myself makes the banner and images. Im sure you find someone who makes you HAPPY ! 3 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now