New Global Score Calculator - With Big Thrills! | Forums

[rlmergeuser]

I'm proud to announce a new version of my Global Score calculation spreadsheet, now with all 40 tracks and 6 tournaments from the Big Thrills DLC!

Trying to climb the leaderboards, but not sure exactly where to focus your attention? Not sure which tracks/tournaments/skill games have the most potential for a higher score? This spreadsheet will show you exactly where its worth to spend your time!

Download available at http://www.trialshd.net/GlobalScore.aspx
Thanks to GameScrub for hosting! Also thanks to Jarr3tt88 for his original version, upon which mine is based. Also thanks to Sebbbi for explaining how the calculations actually work.

Created in Excel 2007, but should be compatible with Excel 97 through 2003.

If you download and like the spreadsheet, please send me an XBox friend request! (Gamertag link in SIG) I'm trying to build up my leaderboard friend list, and am always in need of new custom tracks!

Please use this thread for questions and/or feedback.

Thanks!

[Colors_of_Life]

Thank you

[T4KShadow]

Sweet, I personally won't use it, but I checked it out and it looks SO much easier to use than the old version. That one confused me to hell.

I'm sure you'll help many out here, so thank you for taking the time to do this for the community.

[rlmergeuser]

New/improved features:

[list:3a8r2y4v]
[*:3a8r2y4v]All new tracks and tournaments from Big Thrills[/*:m:3a8r2y4v]
[*:3a8r2y4v]Added fault counts for all medals for a more accurate "medal" calculation (does not effect score)[/*:m:3a8r2y4v]
[*:3a8r2y4v]Added the ability to "collapse" sections of columns to simplify the view, especially useful when printing[/*:m:3a8r2y4v]
[*:3a8r2y4v]Your "rank" value will show in RED if your score is not in the top 5000 (ie, no replay)[/*:m:3a8r2y4v]
[*:3a8r2y4v]Redesigned score summary on the bottom of each page, including the % of the maximum score[/*:m:3a8r2y4v]
[*:3a8r2y4v]Redesigned summary sheet, including % of totals[/*:m:3a8r2y4v]
[*:3a8r2y4v]New "scorecard" sheet with a medal scorecard and a new ranking scorecard[/*:m:3a8r2y4v]
[*:3a8r2y4v]"What if" columns are now "Goal" columns, and will calculate both + and -[/*:m:3a8r2y4v]
[*:3a8r2y4v]"Track Record" values are current as of 12/11/2010[/*:m:3a8r2y4v]
[*:3a8r2y4v]"Goal" columns are pre-populated with a score that would put you in the top 100 for that track (also current as of 12/11/2010)[/*:m:3a8r2y4v]
[*:3a8r2y4v]Added a "medal override" column, which I explain further below.[/*:m:3a8r2y4v][/list:u:3a8r2y4v]

Medal override: If you expand columns P and Q, you will see an "override" column. This allows you to manually enter a medal that you might have in-game, if the calculation shows something different.

An example of when this might occur: You get a Gold medal on Pilgrimage with 20 faults and 4:00.000. Later on, you improve your faults to 15, but it takes you a 5:00.000 (which would normally only award you a Silver medal). You've just been "Ben Johnson'ed!" The fewer faults will be a better score, so that's what the game keeps. My spreadsheet, though, can't look in the past and know what you had previously, so if you want the "Medal Scorecard" summary to be accurate, you will have to type the word "Gold" in the Override column for Pilgrimage. Later on, if you improve your score further, just delete the text you typed in this column.

[rlmergeuser]

Basic instructions, if you haven't used this before:

GREEN areas are for you to enter your scores
YELLOW areas are calculated. Don't type anything here!

The only columns you HAVE to enter are your faults and your time. The Rank and the Track Record are optional, but useful.

Make sure to enter your times with a leading zero, like "0:45.123". Otherwise Excel may misinterpret it.

[Jarr3tt88]

That was fast man, how did you get all the medal times??? Awesome work

[Retribution]

This is worthy of a True Fan award.

[Elements1992]

Thanks Alot MegaTrain and Jar! Good work!

[Elements1992]

Hey, question on how to use it!
I obviously get what to put under 'My Time' 'My Faults' and 'My Rank' but Under X and Y what do i put? The ones saying 'Goal' and 'Time'' ? And where would it calculate the difference in my score?

[rlmergeuser]

That was fast man, how did you get all the medal times??? Awesome work

Thanks!
To get all the medal times I had to (carefully) get the bronze, then silver, then the gold on each track and tournament. It's actually hard to NOT get a good time on some of the easier tracks, I used the Bail button a lot to increase my faults

There were only a couple of tournaments that gave me trouble getting Gold. Platinum, however, is likely to be a different story