Attack on Completion 2020 (sign ups Closed)

[stevenanthony88]

All,

 

The attack on completion has been a great motivator to increase completion percentage.

I do realize I'm facing some issues with achieving multiplayer trophies for some games(i.e. Far Cry 5) due to lack of gamers in my friends group.

 

Anyone open to helping out?

thanks!

Good luck all!

[ladynadiad]

54 minutes ago, stevenanthony88 said:

All,

 

The attack on completion has been a great motivator to increase completion percentage.

I do realize I'm facing some issues with achieving multiplayer trophies for some games(i.e. Far Cry 5) due to lack of gamers in my friends group.

 

Anyone open to helping out?

thanks!

Good luck all!

 

Have you tried looking at gaming sessions on here?  I saw there is one on Tuesday for Far Cry 5.  You can also create a session if that date and time doesn't work and no one here can help.  Best of luck, I don't own that game myself but I'm sure you'll find some help among the community here.

 

Now as far as my own stats go, yep they look right and I totally forgot to sync the trophies I got last night.  Vita games sometimes can be a pain about syncing because some games won't allow syncing while playing the game because you have to close it before syncing.  So now I'm back to 96.12%.  It went down due to my last minute attempt to finish something easy before RPG Mania ended, but failed to finish it in time.  Will wrap that up soon though.

 

So now that RPG Mania is over, I do want to get to really attacking my backlog of games I haven't started.  According the the PSNP Backlog add on, I have 78 games and 2,863 trophies  among the games I own and haven't started.  I want to get that number below 70, so I'm going to focus on trying to wipe out some of the easy stuff like the POWGI games, Pic-A-Pix games, and other stuff that is around 5-10 hours for the plat/100%.  I also am going to work on getting Kingdom Hearts 2 up to an A rank and then work on wrapping up Kingdom Hearts.  Doubt I'll get those done by the end of the month since this is going to be a busy month for me so that's why the focus is going to be on easy stuff from the backlog so I'll have more to show for my limited time.

[Milktastrophe]

Here's my progress update. This time around I've added some fields to my excel and also didn't cut any out. Quick link to last month for comparison.

I don't expect to be making this much of an increase in any of the upcoming months, so hopefully I can still reach my goal.

 

Progress: +0.279% (1.048% to go)

# Of Unfinished Games: -2

 

 

Games played this month:

1. Caravan Stories: I didn't really play this one this month, I just had it running to grind out battles for the last trophy.
2. Mecho Tales (Vita): This one felt like Mecho Wars by Denysoft to me. Honestly, the terrible gameplay mechanics and level design really makes this one feel more like Attacking Zegeta 2 than the actual Attacking Zegeta 2. It's definitely worth picking up for $1 whenever it goes on sale. It's pretty short (not Ratalaika short) but it's fun enough, especially since it's cross-buy.
3. Uncharted: The Lost Legacy: This is the first Uncharted game I've played since the first one. I thought I remembered the blonde girl from the first game was Chloe Fraser, but apparently Chloe is now Indian? I'm probably just misremembering. Don't be fooled by the guide's claim of 3/10 for a single playthrough! I'd put it at 6/10. Crushing is really hard in some parts and the guide doesn't even provide tips on the hardest battle, which is the first one after Sam joins your party. You don't have any weapons and have to defeat like 50 enemies that can all one shot kill you.
4. Rainbow Moon: This is the single hardest game I have ever played. Again the guide straight up lies about the difficulty. 4/10? Ha! This game is the perfect example of 10/10 difficulty. Even regular non-boss battles can be extremely deadly and the only way to beat them is to save scum before every battle and keep reloading until you get a lucky enemy placement. In the end when I was level 500 with the best equipment and maxed stats I could barely defeat the level 260 enemies, no chance at any of the level 300+ enemies. I probably spent over 150 hours getting all the trophies, but then still had to grind out an extra 20 hours for the 100 hours trophy because all that time save scumming doesn't count towards the time played.
5. Energy Cycle (NA/VITA): It's an OK puzzle game. I did it mostly legit, just using the level skip exploit to re-roll levels that were too hard or to restart at the same level after failing time attack mode. If I do the other stacks I'll probably just do the puzzle mode legit and use the exploit to skip the other two modes.
6. Metal Gear Solid V: Ground Zeroes: This game is not nearly as bad as I remember it when I first played 5 years ago. Still don't really get the hype why games like Metal Gear or Call of Duty are so popular though. I got 0.064% from this game so far, but now all that's left are the hard trophies. I haven't even attempted any of the missions in hard mode. Some of the missions were actually pretty easy and I accidentally got S rank without trying, but Ground Zeroes, Anti-Air, some of those missions are really tough. I don't know if I'll play this again any time soon.
7. Brothers: A Tale of Two Brothers: This game is really, really, terrible! None of the dialog is in English and there are no subtitles so who knows what the plot is. What I could piece together was it's about two brothers (I'm just guessing this from the title) who kidnap an old man and then go around their village being jerks and murdering people. The most interesting puzzle in the game was "help your friend move apartments simulator" where you have to figure out how to maneuver the "couch" (a pipe) around corners. Most of the puzzles were solved by simply walking to the most obvious looking spot and then it turned out that was a puzzle all along.
8. Here They Lie: I really thought Brothers was going to be the worst game I played this month then I played this one. Even for a walking simulator Here They Lie is especially bad. I hate when games try to be scary by making the screen dark and hard to see. I just turned the gamma all the way up so I could see perfectly clearly the entire time and never needed the flashlight. Another awful game mechanic is sometimes dying will respawn you past the current area so you need to either reload or backtrack to get the collectibles.
9. Paraiso Island (EU): It's less glitchy now than when it originally came out in NA, but I still hit plenty of glitches. Easy 1 hour 100%.
10. Fallout 76: I came into the month only needing 3 more trophies: I Am Become Death, kill the Scrochbeast Queen, and hit level 100. Well, I Am Become Death was my next quest so I played it. Going through the missile silo wasn't difficult so I'm not sure why people always talk about needing to form big parties to go through them. One trophy down. Since I was there I decided to fire the nuke on Fisher Price Prime to spawn the Scorchbeast Queen and try for that trophy. A level 300, two level 150s, and a level 80 showed up to help (I was level 50). We only did about 25% damage to the Queen. I was useless the entire time, you see I have a melee build and it turns out the Queen only spends about 2-3mins of the 30min time limit on the ground. Next day I was playing and server hopped to avoid a scorchbeast (even those regular enemies I can't beat because I have a melee character) and lucked out that the server I landed in had the Scorchbeast Queen event start right at that moment. And they were highly competent players who even pulled the Queen out of the nuke zone so there was no radiation to worry about. I ran over as fast as possible and whacked the Queen whenever she landed. Those guys tore the Queen apart and killed her in about 5 minutes. I did so little damage that I didn't get any experience from the kill, but since I was in the area I still got the trophy! All that's left is to hit level 100 which is going to take a long time...

 

[VASORAT13]

@Milktastrophe the blonde girl in the first encharted is Elena. Nice excel btw

 

[Slava]

1 hour ago, Milktastrophe said:

Still don't really get the hype why games like Metal Gear or Call of Duty are so popular though. 

Completely different games and different genres even. And I think CoD is 10 times more popular.

 

Have you played any other MGS games on PS1-PS2? If not, Ground Zeroes is a weird place to start playing this series, that's for sure. 

[Sword]

Stats look great for me! 

 

This month is definitely backlog month for me. Luckily I have a very small amount of games to finish so I can keep my goal in sight.

[Niilismo]

@Squirlruler I haven't actually earned a platinum yet. The percentages are accurate, though.

[Milktastrophe]

1 hour ago, Alderriz said:

Completely different games and different genres even. And I think CoD is 10 times more popular.

 

Have you played any other MGS games on PS1-PS2? If not, Ground Zeroes is a weird place to start playing this series, that's for sure. 

Ground Zeroes is the first and only one I've played. The series never really appealed to me but I've got this one from PS+ (I also have the other Metal Gear Solid 5 from PS+ but not sure I'll play it).

[igs63]

My stats look to be accurate. It seems I forgot to sync the trophies I just earned last night however, but it doesn't make a huge difference. Thanks again!

[Gumby114]

My stats are spot on. At first I couldn't remember what game I finished but then I remembered I finished AC: Odyssey. The final DLC chapter was fantastic. I really hope the new one is Vikings. 

 

A bit disappointed I started two new games this month. I have been sitting on rdr2 for the better part of 6 months and Medievil since release. 

 

O well I have 11 months of progress to make! 

[Lazmanci]

19 hours ago, Squirlruler said:

@RikuKelev

Original Starting PCG: 80.58%                Total Earned Trophies: 116
Goal PCG: 90%                        Total Earned Platinums: 4
Current PCG: 82.04%                    Total Games Started: 3
Total Increase: 1.46%                    Total Games Completed: 6

 

There's one mistake in mine. I only earned 3 platinums.

Thank you for making this. I appreciate it. It's a very nice overview.

[voyager49]

Stats look fine. I did not start any new games in January while finishing 7. I gained less than a percentage point in completion. This confirms my earlier suspicion that to reach my goal I will have to devote my entire year to games currently in my profile without starting new ones. So not going to happen!

 

That said, I started Uncharted: Lost Legacy yesterday and so far totally enjoying it. Starting Chapter 3 today and hope to get thru it and Chapter 4 without using weapons or explosives to earn the least earned trophy in the game. 

 

I finished up Call of Cthulhu this week. This is just the 2nd Horror game I have played. (The first, Bendy and the Ink Machine, I am still working on.) So I have little to compare it to. Having said that, the devs employed techniques and music to good use to heighten the suspense and crank up the horror factor. Gameplay controls handled well. Collectibles were easy to find without a guide. Trophies popped naturally without a guide up until Chapter 10. At that point your choices affect the 4 different endings required for trophies. For me, I was disappointed that the story left more questions than answers. Perhaps reading the book which the game was based upon may resolve that. Or perhaps the story is left unresolved to drive home the main character's descent into madness. Overall this game is well worth a look. 4 out of 5 stars simply because I didn't get the closure I desired on the storyline.

Edited February 2, 2020 by voyager49
Typo

[EdgeOfPortal]

23 hours ago, Alderriz said:

 

I think mine are correct, thanks.

The only thing is I see @EdgeOfPortal's numbers but don't see him tagged above.

 

Now onto February. I was going to start the month with MGSV. But I saw a boosting session for Tomb Raider MP and had to join. Got everything that i wanted from it and more thanks to those awesome people. Just need to grind for lvl 60 and buy all characters and upgrades. The Tomb Raider platinum is much closer than MGSV now, so I'm starting with that one instead.

Your stats are still super impessive. You completed more games in a month than I have on my profile ?

Yes, I’m not seeing my name there either. Been a bit of a slow start for me but I’m definitely still in the challenge.

[Sword]

18 hours ago, Milktastrophe said:

Progress: +0.279% (1.048% to go)

# Of Unfinished Games: -2

 

 

 

 

Your sheet is absolutely beautiful. Is there a template I could follow for this? I really like it. 

[Squirlruler]

On 2/1/2020 at 11:22 AM, Alderriz said:

The only thing is I see @EdgeOfPortal's numbers but don't see him tagged above.

Tagged.

 

On 2/1/2020 at 0:42 PM, VASORAT13 said:

I earned 5 platiums.

Edited.

19 hours ago, Niilismo said:

 I haven't actually earned a platinum yet. The percentages are accurate, though.

Edited.

8 hours ago, RikuKelev said:

I only earned 3 platinums.

Edited.

 

Edited February 2, 2020 by Squirlruler

[ChuckDNorris]

Thank you for the update. I'm burning out, however I started vacation today till February the 14th. I keep getting new games and pushing them off to make my percentage not go down. I added the game Sigi last night and I felt that was a mistake cause I thought it was an easy 100. I saw the game on the youtuber Ibaddriver channel as cheap easy plat on sale. I was tired, when I started and was like a potatoe and only got one trophy. updated my trophies and dropped like 0.05 percent and was like uh oh.  got some rest and busted out the easy gold trophies. I feel better now.

I assumed it was like one of the Ratalaika games.

Edited February 4, 2020 by ChuckDNorris

[jonesey46]

My stats look good! Thanks again for doing all the work you do.

[snarl14]

My stats look perfect! Thank you for tracking all of this data, it's really helping to motivate me to complete more games from my backlog ?

[MortalRikku]

My stats have changed but only after your update as i started Sims 4 and its completely killed my percentage :/ 

 

Looking to finish a few easier wins and then back to Witcher 3 

 

Thoughts of the day - Why did I install Sims 4 and start playing... why lol 

[Milktastrophe]

Some people were asking about my excel, so let's see if this works:

 

1. Create a Google Sheet, copy and paste the below into it in A1.

If you need more rows for games, hopefully you can figure it out. All of the empty cells need to be filled in manually. If someone can figure out a way to automatically pull that info from PSNP, I'd be interested to learn it. You'll also have to go through and size each column yourself, sorry.

 

EDIT: The PSN level formula here I think will only work if you're at least level 26. Levels below 26 level up with different numbers of points so the formula would be a bit different to incorporate those. There might be an error in that formula, it seems to be slightly off for what it shows my in my excel vs what PSNP shows.

EDIT2: Nevermind the PSN level formula should be right. I had forgot to update my sheet with my latest platinum so now it's showing the same as PSNP for me.

 

Unfinished Game	Golds	Silvers	Bronzes	Platinum	Has Platinum?	Points Earned	Points Available	Completion Boost
						=D2*15+C2*30+B2*90+E2*180		=($L$20+H2-G2-180*(F2))/$L$21*100-$L$23		Total Unfinished Points:	=SUM(G2:G29)
						=D3*15+C3*30+B3*90+E3*180		=($L$20+H3-G3-180*(F3-E3))/$L$21*100-$L$23		Total Unfinished Points Available:	=SUM(H2:H29)
						=D4*15+C4*30+B4*90+E4*180		=($L$20+H4-G4-180*(F4-E4))/$L$21*100-$L$23		Missing Points:	=L3-L2
						=D5*15+C5*30+B5*90+E5*180		=($L$20+H5-G5-180*(F5-E5))/$L$21*100-$L$23
						=D6*15+C6*30+B6*90+E6*180		=($L$20+H6-G6-180*(F6-E6))/$L$21*100-$L$23		Platinums:
						=D7*15+C7*30+B7*90+E7*180		=($L$20+H7-G7-180*(F7-E7))/$L$21*100-$L$23		Missing Platinums:	=SUM(F2:F29)-SUM(E2:E29)
						=D8*15+C8*30+B8*90+E8*180		=($L$20+H8-G8-180*(F8-E8))/$L$21*100-$L$23
						=D9*15+C9*30+B9*90+E9*180		=($L$20+H9-G9-180*(F9-E9))/$L$21*100-$L$23		Golds:
						=D10*15+C10*30+B10*90+E10*180		=($L$20+H10-G10-180*(F10-E10))/$L$21*100-$L$23		Silvers:
						=D11*15+C11*30+B11*90+E11*180		=($L$20+H11-G11-180*(F11-E11))/$L$21*100-$L$23		Bronzes:
						=D12*15+C12*30+B12*90+E12*180		=($L$20+H12-G12-180*(F12-E12))/$L$21*100-$L$23
						=D13*15+C13*30+B13*90+E13*180		=($L$20+H13-G13-180*(F13-E13))/$L$21*100-$L$23		Total Trophies:	=L6+L9+L10+L11
						=D14*15+C14*30+B14*90+E14*180		=($L$20+H14-G14-180*(F14-E14))/$L$21*100-$L$23		Missing Trophies:
						=D15*15+C15*30+B15*90+E15*180		=($L$20+H15-G15-180*(F15-E15))/$L$21*100-$L$23
						=D16*15+C16*30+B16*90+E16*180		=($L$20+H16-G16-180*(F16-E16))/$L$21*100-$L$23		Overall Total Points:	=180*L6+90*L9+30*L10+15*L11
						=D17*15+C17*30+B17*90+E17*180		=($L$20+H17-G17-180*(F17-E17))/$L$21*100-$L$23		Overall Points Available:	=L16+L4
						=D18*15+C18*30+B18*90+E18*180		=($L$20+H18-G18-180*(F18-E18))/$L$21*100-$L$23		PSN Level:	=(L16-128000)/10000+26
						=D19*15+C19*30+B19*90+E19*180		=($L$20+H19-G19-180*(F19-E19))/$L$21*100-$L$23
						=D20*15+C20*30+B20*90+E20*180		=($L$20+H20-G20-180*(F20-E20))/$L$21*100-$L$23		Adjusted Overall Total Points:	=90*L9+30*L10+15*L11
						=D21*15+C21*30+B21*90+E21*180		=($L$20+H21-G21-180*(F21-E21))/$L$21*100-$L$23		Adjusted Overall Points Available:	=L20+L4-L7*180
						=D22*15+C22*30+B22*90+E22*180		=($L$20+H22-G22-180*(F22-E22))/$L$21*100-$L$23
						=D23*15+C23*30+B23*90+E23*180		=($L$20+H23-G23-180*(F23-E23))/$L$21*100-$L$23		Completion:	=L20/L21*100
						=D24*15+C24*30+B24*90+E24*180		=($L$20+H24-G24-180*(F24-E24))/$L$21*100-$L$23		Distance to 99%:	=99-L23
						=D25*15+C25*30+B25*90+E25*180		=($L$20+H25-G25-180*(F25-E25))/$L$21*100-$L$23		Distance to 99.99%:	=99.99-L23
						=D26*15+C26*30+B26*90+E26*180		=($L$20+H26-G26-180*(F26-E26))/$L$21*100-$L$23
						=D27*15+C27*30+B27*90+E27*180		=($L$20+H27-G27-180*(F27-E27))/$L$21*100-$L$23		Theoretical Platinum Boost:	=($L$20+1200-180)/($L$21+1200-180)*100-$L$23
						=D28*15+C28*30+B28*90+E28*180		=($L$20+H28-G28-180*(F28-E28))/$L$21*100-$L$23		Theortiecal 100% Boost:	=($L$20+300)/($L$21+300)*100-$L$23
						=D29*15+C29*30+B29*90+E29*180		=($L$20+H29-G29-180*(F29-E29))/$L$21*100-$L$23

 

 

2. To automatically sort the games:

Select Tools > Script Editor

Add this code into the page that opens and save. This will automatically sort your games list based on how much they will boost your completion if you complete them.

If you add more rows for games then update the 29 to be whatever is the last row you have for games.

function onEdit() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getRange("A2:I29");
  range.sort({column: 9, ascending: false});
}

 

3. To automatically color the games based on completion:

Back in the spreadsheet, highlight your games rows.

Select Format > Conditional Formatting

In the pane that opens choose "+ Add another rule"

Make sure the "Apply to range" is A2:I29, same as what was in the script from step #2.

For format rule choose "Custom formula is" and "=$I2>0.5"

For "Formatting style" make the background red.

Repeat for beige and "$I2>0.2", green and "$I2>0.1".

Alternately you can choose your own colors and thresholds. It's kind of hard to describe, the pane should look something like this:

Edited February 7, 2020 by Milktastrophe

[jonesey46]

@Milktastrophe Very impressive stuff. And here I am with my mostly manual input and not very advanced spreadsheet ?

 

 

For anyone that wants a look:

https://docs.google.com/spreadsheets/d/1ngA9hPHS1g_JVQDqhi7XThT6eA-wMjDA1u5Fuvr-9X4/edit?usp=sharing

 

 

[Milktastrophe]

On 12/31/2019 at 8:39 PM, Milktastrophe said:

 

1. King's Quest. The only thing stopping me is I somehow miss every time the DLC goes on sale. Hopefully it'll come on sale again this year.

 

King's Quest Complete Collection is on sale now (grr it's never the season pass!). I'm thinking to pick it up. I sure hope it maps to the trophy list I already have on my profile and not the one specifically called King's Quest: The Complete Collection.

[gruffiiti]

27 minutes ago, Milktastrophe said:

King's Quest Complete Collection is on sale now (grr it's never the season pass!). I'm thinking to pick it up. I sure hope it maps to the trophy list I already have on my profile and not the one specifically called King's Quest: The Complete Collection.

 

99% sure its a different list and will not map.

[ladynadiad]

2 hours ago, Milktastrophe said:

King's Quest Complete Collection is on sale now (grr it's never the season pass!). I'm thinking to pick it up. I sure hope it maps to the trophy list I already have on my profile and not the one specifically called King's Quest: The Complete Collection.

 

The complete collection on the PSN store maps to this trophy list: https://psnprofiles.com/trophies/3725-kings-quest

 

I bought the complete collection on the PSN store and that's the trophy list it ended up being for me, the one you're linking is more than likely the physical version.  The digital complete collection ends up being more like a season pass because you'll have to download each episode individually rather than just have a single game download.

Edited February 7, 2020 by ladynadiad

[VASORAT13]

@Milktastrophe Thank you for your Amazing Excel Document. 
If you want to count your trophies to insert your trophies automatic your can input all your completed games and count your trophies that way.
Also you must update your formula for completion boost in row 2.