Welcome Back to Digital Pinball Fans - please read this first
For latest updates, follow Digital Pinball Fans on Facebook and Twitter

Reply to thread

Message: <blockquote data-quote="Tann" data-source="post: 211129" data-attributes="member: 2327">Yep, I didn't think that FS would have ever released the leaderboard master data. But they did it, kudos to them.Yes, it would be easy to implement. Something like re-using the data in the rank column:1st formula:[code]=VLOOKUP(I6-1;Data.A1:E2000;3;0)[/code]Vertical search for your rank-1 (and -2, -3, etc. if needed), in the hidden Data sheet (2000 lines for Totan), value of the 3rd column (Score).or[code]=SUMPRODUCT((Rank=I6-1)*(Table="Tales of the Arabian Nights")*Score)[/code]Same formula than your score extraction, but with a different array (rank-1 instead of your player ID)I don't know which formula induces a faster calculation time (my two cents on VLOOKUP). I have to test it.I could also extract the player ID ranked above you, by modifying the column number:[code]=VLOOKUP(I6-1;Data.A1:E2000;2;0)[/code]I think I could add all that stuff in a new sheet, named "Comparison" or something like that, with the better score on each table, and the 5 scores above you.No, as the Challenge data are not in the .csv file provided by Farsight. Maybe we could ask FS if they can build it too and post it on the official website?Fields that still need a manual filling: Goals, Challenge Data, Tournament Ranking.Nice, thanks. I will add it for the next release.Actually, you can check all the HOF scores for each table by pointing your mouse on the upper-right corner of the "HOF points" title cell on each Season card (the tiny red square for the tooltip is masked by the red color on the Season 1 sheet, so it can be easily missed.)At first, I wanted to insert a tooltip in each HOF cell, but once converted to PDF, there are ugly little icons everywhere. The other problem is that I have not much room remaining. I still can split the Score column, but I keep that for the incoming new difficulty setting, which will have its own leaderboards data (so I will need another "Rank" column, let's say "Rank Hard Difficulty"Oops, thanks! I will fix it too.Thanks for your feedback. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile    :)" loading="lazy" data-shortname=":)" /></blockquote>

Verification

Members online

No members online now.

Total: 96 (members: 1, guests: 95)