A cool new statistic ?

[FawltyPowers]

11 hours ago, JoesusHCrust said:

Thanks, that’s brilliant. Where did you get these data from? 

 

It's data pulled from this site to create an overview of statistics that motivates me. It's certainly something you could do yourself if you wanted to.

[GT__Jedi]

Anything in color and bling on my profile would be nice. ?

[sepheroithisgod]

14 hours ago, FawltyPowers said:

 

 

Your completion rate has been steadily increasing for the past 3 years and is currently at the highest it's been (Ignore Maximum Achievable Completion, it may/may not be accurate)

Can you share how you made this?

 

Edited August 26, 2022 by sepheroithisgod

[serrated-banner9]

29 minutes ago, sepheroithisgod said:

Can you share how you made this?

 

same i want to know too

[IntroPhenom]

I'm leaderbored of these...oh, wait. This isn't lame leader board nonsense. It's a cool idea!

[BlindMango]

3 hours ago, sepheroithisgod said:

Can you share how you made this?

 

 

Looks to me like some kind of really fancy (and technically impressive) Excel table

[Helyx]

3 hours ago, sepheroithisgod said:

Can you share how you made this?

 

This is really impressive and looks slick. I guess ol' @HusKy is gonna be the only viable solution to getting something like this added to PSNP.

[FawltyPowers]

The way I did it was to download the trophy log and total points for each game (less platinum), now create a list with four columns

 

Column 1 - the date, dating from your first trophy earned to today.

Column 2 - points earned, contains the cumulative points of trophies earned

column 3 - total points, the total points of each game where trophies have been earned

column 4 - column 2 divided by column 3

 

Loop through the trophy log

 

for each trophy earned on that day add the points value to column 2, when a trophy is earned on a new game then add the points total for that game in Column 3.

 

it may not be 100% accurate depending on when dlc trophies are released, you could add this for further accuracy if you wish but its not that important to me to be that accurate.

 

Then just create a graph in excel to display that data.

[djb5f]

5 minutes ago, FawltyPowers said:

The way I did it was to download the trophy log and total points for each game (less platinum), now create a list with four columns

 

Column 1 - the date, dating from your first trophy earned to today.

Column 2 - points earned, contains the cumulative points of trophies earned

column 3 - total points, the total points of each game where trophies have been earned

column 4 - column 2 divided by column 3

 

Loop through the trophy log

 

for each trophy earned on that day add the points value to column 2, when a trophy is earned on a new game then add the points total for that game in Column 3.

 

it may not be 100% accurate depending on when dlc trophies are released, you could add this for further accuracy if you wish but its not that important to me to be that accurate.

 

Then just create a graph in excel to display that data.

Nicely done.
 

Yeah, I have no issues with creating views in Excel, it is obtaining the dataset that I am not sure how you did.  You say you downloaded the data sets by where/how?  

[HusKy]

1 minute ago, djb5f said:

You say you downloaded the data sets by where/how?  

 

Unless there's a different source which I don't know about, you would have to scrape log pages one by one.

For example, in my case I would have to start at https://psnprofiles.com/HusKyCode/log and continue from there for all 157 pages.

[FawltyPowers]

38 minutes ago, HusKy said:

 

Unless there's a different source which I don't know about, you would have to scrape log pages one by one.

For example, in my case I would have to start at https://psnprofiles.com/HusKyCode/log and continue from there for all 157 pages.

Precisely, I enter a user ID and it pulls in the trophy log pages one by one, obtains each games trophy list, owners etc and then creates various sheets. Subsequent runs just pull through any new trophies, dlc additions and every now and then I update all rarity statistics. All done in Excel.

[HusKy]

On 26. 8. 2022 at 8:41 PM, FawltyPowers said:

Precisely, I enter a user ID and it pulls in the trophy log pages one by one, obtains each games trophy list, owners etc and then creates various sheets. Subsequent runs just pull through any new trophies, dlc additions and every now and then I update all rarity statistics. All done in Excel.

 

There's probably a lot more nuance to this. You need to also visit every unique trophy list too, right? Where do the "unachievable" trophies come from?

[serrated-banner9]

6 minutes ago, HusKy said:

 

There's probably a lot more nuance to this. You need to also visit every unique trophy list too, right? Where do the "unachievable" trophies come from?

that must be a pain

[FawltyPowers]

On 28/08/2022 at 6:29 PM, HusKy said:

 

There's probably a lot more nuance to this. You need to also visit every unique trophy list too, right? Where do the "unachievable" trophies come from?

 

It's not too bad, all trophy lists I default to "Offline", then I have a repository of trophies that are "Online" and "Unachievable". It's the only part that is manual, aside from being able to add games to a backlog, build a planner and then have a progress sheet where you can add detail such as collectables, or % progress. I don't think I could have gotten through the Uncharted grinds back in 2014/15 without them.

 

Online / Offline / Unachievable would be a terrific addition to have to this site, though it obviously requires maintenance, plenty of willing volunteers though. I'm sure many people would love to know their maximum achievable completion. Mine is 99.91%

[serrated-banner9]

2 hours ago, FawltyPowers said:

 

It's not too bad, all trophy lists I default to "Offline", then I have a repository of trophies that are "Online" and "Unachievable". It's the only part that is manual, aside from being able to add games to a backlog, build a planner and then have a progress sheet where you can add detail such as collectables, or % progress. I don't think I could have gotten through the Uncharted grinds back in 2014/15 without them.

 

Online / Offline / Unachievable would be a terrific addition to have to this site, though it obviously requires maintenance, plenty of willing volunteers though. I'm sure many people would love to know their maximum achievable completion. Mine is 99.91%

me too, this should be added