xZoneHunter Posted August 26, 2016 Author Share Posted August 26, 2016 Now that the Worms WMD trophy list is up I'd like to put forward the idea of a Worms PP again, the series now has the five minimum platinums needed. Games required for rankings: • Worms 2: Armageddon • Worms Ultimate Mayhem • Worms Revolution (PS3) -or- Worms Revolution Extreme (Vita) • Worms Battlegrounds • Worms WMD Bonus games: • Worms • Worms: Crazy Golf I'd also like to suggest a Vikings PP into Pending Suggestions. I think we'll have enough to fill a PP soon. Plats: - Jotun [PS4] (Release Date: September 9, 2016) - The Banner Saga [PS4, Maybe PS Vita?] - The Banner Saga 2 [PS4] - The Banner Saga 3 [PS4] (Release Date TBD) - Vikings: Wolves of Midgard [PS4] (Release Date: Early 2017) 100%: - When Vikings Attack Anyone can feel free to claim it - I want to get Big Brother done before trying anything else. I don't see why not. Will add them to the OP! 1 Link to comment Share on other sites More sharing options...
xZoneHunter Posted August 27, 2016 Author Share Posted August 27, 2016 (edited) UPDATE So, for the first time in 11 months - i sat down and tried to check how accurate the online leaderboard actually is. And unfortunately, there was a lot of need for improvement. I also noticed that most people don't really have much interest for the leaderboard anymore. Which is why i don't think i should be forcing it upon members any logner. Especially because of the diminishing quality of the sheet. It's getting pretty big and it's noticeable on the loading times and amount of crashes That's why i wanted to suggest to just put an end to the spreadsheet all together. It was a good idea, but badly executed. I know that some of you did care to get into that famous TOP 5 spot, so i'll be doing some sort of giveaway in memory of my little excel project. And probably give a bunch of those premium memberships i promised a while back. In case you don't know what the hell i'm talking about. TL;DR Everything stays the same just no more TOP 5 & online leaderboard spreadsheet. Edited August 27, 2016 by xZoneHunter Link to comment Share on other sites More sharing options...
Gibbo_0113 Posted August 27, 2016 Share Posted August 27, 2016 TL;DR Everything stays the same just no more TOP 5 & online leaderboard spreadsheet. Damn im not gonna lie, without the leaderboard and points system it makes me less interested in project platinum 3 Link to comment Share on other sites More sharing options...
Satoshi Ookami Posted August 27, 2016 Share Posted August 27, 2016 (edited) I gotta agree with Gibbo, online leaderboard was a fun addition to the whole PP business... I propose a suggestion: We do not make a new list for each new PP, instead, we make lists for PP creators. We also abolish the ranks on leaderboard and let creators add points manually. Example: I have Plat in Despair PP (12pts), Silver in J-Gems (2pts) and Silver in Kiseki (2pts), that means in SatoshiOokami list, I would write 16 for satoshiookami. Supposedly, I increase my rank in Kiseki to Gold (6pts) which would raise my point count by 4. Therefore, I would replace 16 with 20. Sure, it will be more work for the PP creators at the start but at least it would save the leaderboard... Feel free to dismiss this idea =D Edited August 27, 2016 by Satoshi Ookami 3 Link to comment Share on other sites More sharing options...
Xionx Posted August 27, 2016 Share Posted August 27, 2016 Damn im not gonna lie, without the leaderboard and points system it makes me less interested in project platinum ^ ^ ^ This ! .... I was always looking for PPs i can complete to get my 12 point boost to get higher in rank . But i have to agree that spreadsheet is not loading or crashing 90% of times i try ... which is very annoying . 2 Link to comment Share on other sites More sharing options...
HcG Clawz Posted August 27, 2016 Share Posted August 27, 2016 I agree with Gibbo aswell. The leaderboards is what actually motivates me to get the other games from ceratin PP's. 1 Link to comment Share on other sites More sharing options...
zajac9999 Posted August 27, 2016 Share Posted August 27, 2016 Yep same, I only do PP pretty much for the leaderboards and the competition side of things. The idea is nice and I'd still want to do things like the Challenge Accepted PP's. But I'd lose a lot of motivation regarding them and interest in the idea in general. I imagine a lot of people would tbh. I'm pretty sure there's a lot of people who are at least somewhat interested in the leaderboards and that friendly competition. 2 Link to comment Share on other sites More sharing options...
xZoneHunter Posted August 27, 2016 Author Share Posted August 27, 2016 (edited) Well, i suppose i can keep a small part of the leaderboard going. So what i suggest is to have a Top 10 or 20 (depending on how many are interested) in the same form as the Top 5 in the OP right now. But you guys would have to keep track of your own points and just let me know when you gain some more points. Then there is still room for competition for those who want that. Would that be a good solution? Edited August 27, 2016 by xZoneHunter Link to comment Share on other sites More sharing options...
Wavergray Posted August 27, 2016 Share Posted August 27, 2016 The top 20 sounds good to me, but Satoshi idea sounds pretty good if people really want the current leaderboard to stay. Link to comment Share on other sites More sharing options...
zajac9999 Posted August 27, 2016 Share Posted August 27, 2016 Well, i suppose i can keep a small part of the leaderboard going. So what i suggest is to have a Top 10 or 20 (depending on how many are interested) in the same form as the Top 5 in the OP right now. But you guys would have to keep track of your own points and just let me know when you gain some more points. Then there is still room for competition for those who want that. Would that be a good solution? I'm happy with either that, preferably top 50 though. Or Satoshi's idea. Definitely want some form of leaderboard though. Link to comment Share on other sites More sharing options...
Dragon-Archon Posted August 27, 2016 Share Posted August 27, 2016 (edited) What if other members take over the inaccurate PP tabs and keep them up to date? I gotta agree with Gibbo, online leaderboard was a fun addition to the whole PP business... I propose a suggestion: We do not make a new list for each new PP, instead, we make lists for PP creators. We also abolish the ranks on leaderboard and let creators add points manually. Example: I have Plat in Despair PP (12pts), Silver in J-Gems (2pts) and Silver in Kiseki (2pts), that means in SatoshiOokami list, I would write 16 for satoshiookami. Supposedly, I increase my rank in Kiseki to Gold (6pts) which would raise my point count to 4. I would replace 16 with 20. Sure, it will be more work for the PP creators at the start but at least it would save the leaderboard... Feel free to dismiss this idea =D But that still doesn't solve the problem of creators not updating the leaderboard. Damn im not gonna lie, without the leaderboard and points system it makes me less interested in project platinum Yeah, the point system was a nice addition to the PPs. Edited August 27, 2016 by Dragon-Archon 1 Link to comment Share on other sites More sharing options...
Satoshi Ookami Posted August 27, 2016 Share Posted August 27, 2016 (edited) But that still doesn't solve the problem of creators not updating the leaderboard. Sure, those would have to be handled differently. I just think handling lagging leaderboard is a priority. We can obviously give the less active creators' tabs to active participants. It's not like the lists were locked =D Edited August 27, 2016 by Satoshi Ookami Link to comment Share on other sites More sharing options...
Dragon-Archon Posted August 27, 2016 Share Posted August 27, 2016 Sure, those would have to be handled differently. I just think handling lagging leaderboard is a priority. We can obviously give the less active creators' tabs to active participants. It's not like the lists were locked =D So are you volunteering? . 1 Link to comment Share on other sites More sharing options...
sundrew Posted August 28, 2016 Share Posted August 28, 2016 Well, i suppose i can keep a small part of the leaderboard going. So what i suggest is to have a Top 10 or 20 (depending on how many are interested) in the same form as the Top 5 in the OP right now. But you guys would have to keep track of your own points and just let me know when you gain some more points. Then there is still room for competition for those who want that. Would that be a good solution? Sure, those would have to be handled differently. I just think handling lagging leaderboard is a priority. We can obviously give the less active creators' tabs to active participants. It's not like the lists were locked =D I think there are two separate problems here: 1) Leaderboard sheet has gotten too big so it lags and crashes a ton. 2) Leaderboard sheet is not always up to date. I like Satoshi's idea, and have my own suggestions too. 1) Leaderboard sheet has gotten too big --> Consolidate the leaderboard into a single excel sheet. Rows are Project Platinum participants. Each column represents a different PP (for example, first column = Hyperdimension Neptunia, second column = Ratchet & Clank, etc). Values in cells represent points that user has earned for that PP. There would be another column somewhere that would sum up total PP points for that user and this way the leaderboard can still autoupdate. Also, without all the sheets and extra graphical frills, the sheet should be much more stable. I can make a quick mock up sheet if that would help everyone visualize. 2) Leaderboard sheet is not always up to date --> Every participant is responsible for updating their own PP points. This way only the users who are interested in their leaderboard rank will participate while helping to remove the burden of constant updates for PP creators. This would require giving everyone permission to update the google doc + we have to trust that everyone is being honest, but we can always double-check the points listed for any user before updating the top 10/20/50/etc. PP creators would obviously continue to keep their PP forum topics updated and maybe help change everyone's points for their PP when a new game is released and all the platinum ranked people are demoted, etc. I feel like these suggestions help ensure that the people who are most interested in the leaderboard have more control over how accurate their rankings are, while making things easier for the PP creators. I think the ideas work well together, but just #1 or #2 could be fine too. What does everyone think? 2 Link to comment Share on other sites More sharing options...
xZoneHunter Posted August 28, 2016 Author Share Posted August 28, 2016 1) Leaderboard sheet has gotten too big --> Consolidate the leaderboard into a single excel sheet. Rows are Project Platinum participants. Each column represents a different PP (for example, first column = Hyperdimension Neptunia, second column = Ratchet & Clank, etc). Values in cells represent points that user has earned for that PP. There would be another column somewhere that would sum up total PP points for that user and this way the leaderboard can still autoupdate. Also, without all the sheets and extra graphical frills, the sheet should be much more stable. I can make a quick mock up sheet if that would help everyone visualize. This was basically how the first sheet worked With your post in mind, the current sheet could still work if i just remove the script (since that's why the sheet is so slow) It'd mean a bit more work to adjust rankings but if everyone was in charge for their own it doesn't really matter. I actually really like that idea. 1 Link to comment Share on other sites More sharing options...
sundrew Posted August 28, 2016 Share Posted August 28, 2016 This was basically how the first sheet worked With your post in mind, the current sheet could still work if i just remove the script (since that's why the sheet is so slow) It'd mean a bit more work to adjust rankings but if everyone was in charge for their own it doesn't really matter. I actually really like that idea. Glad you liked the idea . Ahh I see that's how the sheet is setup now. I personally like the idea of hardcoding my points for each PP into a single sheet because: 1) removing all those HLOOKUPs and VLOOKUPs will make things go faster for sure, and 2) if there's any discrepancy between my leaderboard points and what I think my points should be, it's easy to identify. And as you pointed out, if everyone is responsible for keeping track of their own points, there shouldn't be a big burden on any one person when we migrate the leaderboard sheet format. Link to comment Share on other sites More sharing options...
bladesoframen Posted August 28, 2016 Share Posted August 28, 2016 Is the problem now mostly just having people to update the google docs? If so, we might be able to script the updating of the spreadsheet. When I was writing a script for the team league, I noticed that it is really easy to check if a user has a platinum or not in a game. I haven't fully thought this out yet, but we could use a script that would run every other day and check every PP user's last played games for the last 2 days and see if there is a plat, and if there is a plat, add it to the spreadsheet. (Saying every 2 days to lower server load, which hopefully won't bother Sly) In this way, the only things that need to be maintained, are the member list, the game list, and the PP's game thresholds. (Just voicing my idea out there. I need to look into GDocs to see how to do it on their side, but I can write the crawler for the plats pretty quickly if you want me to) Link to comment Share on other sites More sharing options...
Satoshi Ookami Posted August 28, 2016 Share Posted August 28, 2016 So are you volunteering? . Nope. But you obviously should Link to comment Share on other sites More sharing options...
Dragon-Archon Posted August 28, 2016 Share Posted August 28, 2016 (edited) I think there are two separate problems here: 1) Leaderboard sheet has gotten too big so it lags and crashes a ton. 2) Leaderboard sheet is not always up to date. I like Satoshi's idea, and have my own suggestions too. 1) Leaderboard sheet has gotten too big --> Consolidate the leaderboard into a single excel sheet. Rows are Project Platinum participants. Each column represents a different PP (for example, first column = Hyperdimension Neptunia, second column = Ratchet & Clank, etc). Values in cells represent points that user has earned for that PP. There would be another column somewhere that would sum up total PP points for that user and this way the leaderboard can still autoupdate. Also, without all the sheets and extra graphical frills, the sheet should be much more stable. I can make a quick mock up sheet if that would help everyone visualize. 2) Leaderboard sheet is not always up to date --> Every participant is responsible for updating their own PP points. This way only the users who are interested in their leaderboard rank will participate while helping to remove the burden of constant updates for PP creators. This would require giving everyone permission to update the google doc + we have to trust that everyone is being honest, but we can always double-check the points listed for any user before updating the top 10/20/50/etc. PP creators would obviously continue to keep their PP forum topics updated and maybe help change everyone's points for their PP when a new game is released and all the platinum ranked people are demoted, etc. I feel like these suggestions help ensure that the people who are most interested in the leaderboard have more control over how accurate their rankings are, while making things easier for the PP creators. I think the ideas work well together, but just #1 or #2 could be fine too. What does everyone think? As long as participants sort their names alphabetically per rank in the PP R&C and Dragons tabs, I'm ok with it . Nope. But you obviously should I'll humbly stay on the sidelines, so you can step up and be a hero for the PP community . Is the problem now mostly just having people to update the google docs? If so, we might be able to script the updating of the spreadsheet. When I was writing a script for the team league, I noticed that it is really easy to check if a user has a platinum or not in a game. I haven't fully thought this out yet, but we could use a script that would run every other day and check every PP user's last played games for the last 2 days and see if there is a plat, and if there is a plat, add it to the spreadsheet. (Saying every 2 days to lower server load, which hopefully won't bother Sly) In this way, the only things that need to be maintained, are the member list, the game list, and the PP's game thresholds. (Just voicing my idea out there. I need to look into GDocs to see how to do it on their side, but I can write the crawler for the plats pretty quickly if you want me to) Is it possible to filter the script for specific plats? Because, unlike THTL, not every plat counts and I imagine there would be a script for every PP. Edited August 28, 2016 by Dragon-Archon Link to comment Share on other sites More sharing options...
bladesoframen Posted August 28, 2016 Share Posted August 28, 2016 Is it possible to filter the script for specific plats? Because, unlike THTL, not every plat counts and I imagine there would be a script for every PP. We have a game name with every plat icon, so I need to change my script a bit, but it is quite possible to make 1 large script which has sections for each PP and only check for those platinums. Link to comment Share on other sites More sharing options...
Dragon-Archon Posted August 28, 2016 Share Posted August 28, 2016 We have a game name with every plat icon, so I need to change my script a bit, but it is quite possible to make 1 large script which has sections for each PP and only check for those platinums. That's impressive and sounds like it would be very useful. Link to comment Share on other sites More sharing options...
bladesoframen Posted August 28, 2016 Share Posted August 28, 2016 (edited) That's impressive and sounds like it would be very useful. I'll see if I'm motivated enough to make a prototype tonight for at least crawling the psnp website. Trying to catch up on other things since I forsaked a lot during THTL. Edit: I started it tonight, but didn't have enough time to get very far. Will spend a bit more time tomorrow. Edited August 29, 2016 by bladesoframen Link to comment Share on other sites More sharing options...
xZoneHunter Posted August 29, 2016 Author Share Posted August 29, 2016 Is the problem now mostly just having people to update the google docs? If so, we might be able to script the updating of the spreadsheet. When I was writing a script for the team league, I noticed that it is really easy to check if a user has a platinum or not in a game. I haven't fully thought this out yet, but we could use a script that would run every other day and check every PP user's last played games for the last 2 days and see if there is a plat, and if there is a plat, add it to the spreadsheet. (Saying every 2 days to lower server load, which hopefully won't bother Sly) In this way, the only things that need to be maintained, are the member list, the game list, and the PP's game thresholds. (Just voicing my idea out there. I need to look into GDocs to see how to do it on their side, but I can write the crawler for the plats pretty quickly if you want me to) Well there is that, as well as the sheet being ridiculously slow. Right now i have a script running that just operates on Google sheets. It doesn't do that much, basically it just calculates each user's total score and compiles them to the main sheet. I would imagine, with what you intend to do it would run even more slower. Link to comment Share on other sites More sharing options...
bladesoframen Posted August 29, 2016 Share Posted August 29, 2016 Well there is that, as well as the sheet being ridiculously slow. Right now i have a script running that just operates on Google sheets. It doesn't do that much, basically it just calculates each user's total score and compiles them to the main sheet. I would imagine, with what you intend to do it would run even more slower. Well the idea was that if we have a script input a number, and not equation into the sheet (the script will make things up to date, not as much automatic syncing), it should be pretty fast because there is no need for a constant syncing between sheets.. As a result, I don't think there will be a speed drop. Link to comment Share on other sites More sharing options...
Gibbo_0113 Posted August 30, 2016 Share Posted August 30, 2016 I noticed the spreadsheet is slow when you first load up but give it 5 minutes and its fine. It still gets the job done I'd say. 2 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