1. #1
    Ch4er0n's Avatar Senior Member
    Join Date
    Mar 2014
    Posts
    794

    Community Project

    Edit: If you have yet to 0 fault any HD tournament, we need you! Data you can provide is the best way to verify our score formulas.

    Hey all! I would like to try and verify the HD score spreadsheet, as there is currently a discrepancy between that sheet score, added to the crash county score, and the overall global score we can find on the leaderboards. I have been using the current sheet to provide scores in the new record post, and I would like the post to be as accurate as possible.

    Current Spreadsheets:
    Trials Evo Spreadsheets

    The task: Get PB's! (and record some data for me)

    What I need: Record your global score before the pb, when you get a pb, post up your old time, old score, new time, and new score, something like this:

    Middle Name: Danger:
    Before: 0:13.800 - 36,000,000
    After: 0:13.500 - 36,003,000

    I am out of town currently, so I have not been able to start on this myself, but I will let you guys get started if you want to help out

    Tracks Still Needed:
    Beginner
    Middle Name: Danger
    The Breakdown
    The Big Ride

    Easy
    Building Blocks
    Logsplosive
    Smooth Jumps

    Medium
    Where's the Ground
    Let's Get Physical
    Groundhog Returns
    Trippin the Plywood
    Jolly Jumper

    Hard
    The Rise and Fall
    Dynamic Range
    Technique
    Concrete Dreams
    Classic

    Extreme
    Brown Boxes
    Groundhog Forever
    Inferno II

    Tournaments
    Backyard Cup
    National Bike Cup
    Regional Championship
    Masters League
    World Cup
    World Championship
    Underground Cup
    Ultimate Endurance Challenge




    Last, and somewhat unrelated, I would like a bit of a hand double checking skill game records. I have most of them just fine, but on a few, there are a lot of broken replays and bugged/glitched runs up top. I'm not 100% certain on what to list for the following records:

    Gas Problem: all top replays for me were bugged (blaze's looked good, but crashed at 536 m or so if i recall correctly when it listed 579 m)
    Sphere: all bugged replays for me, not certain on who to grab
    Balance of power: hoping callumw's replay works for someone so I can put him on the thread (#2 - weasel worked fine for me).
    Exploding man: same as Sphere

    Inside the Ball: DGCFBb_EADGC had a broken replay for me, but beauhunt was fine. If someone can get DG's to work I will use that.
    In Flames: matt's replay must have been old when i checked it, cuz it showed he didnt go farther than psy, i dunno if that has changed (willing to give matt the benefit of the doubt )
    Target Hunt: wonder if someone can get zerofault's run to work, his score seems reasonable so i might just grab him anyway
    Outside the Ball: lots of 408 m runs (assuming bugged) so i grabbed DETERMINOLOGY's run, wonder if anyone would like to verify.




    Thx guys!
    Share this post

  2. #2

    Re: Community Project

    What i found was that all single tracks i checked calculate correctly in my version of the sheet (could only test 0 fault time improvements, because 0 faulted them all already ). Some tourneys did not as they acted really weird regarding global score (didnt give any points for improving in certain fault regions until 0 fault and then gave huge amount). Tourneys are also the ones we don't have the calculation values, because they are not written to the xml files in the game (i used fault factor 0.75 and ultimate time 75% of plat)



    Tracks i checked for correct calculation:
    Hello World
    Basic Bumps
    Groundhog Begins
    Easy Wheeling
    Upwardly Mobile
    Mother of All Jumps
    Container Rush
    Under Ground
    Trials/Tribulations
    King of the Hill
    Goin' Up!

    Tourney time improvements when already 0 faulted:
    Backyard Cup
    National Bike Cup
    Master's League
    Share this post

  3. #3
    psycad's Avatar Member
    Join Date
    Mar 2014
    Location
    Helsinki, Finland
    Posts
    276

    Re: Community Project

    Keep in mind that kn000t and I don't use the same HD spreadsheet (we each made our own). But it sounds like the tournaments are the issue on both, probably because we don't have the exact Ultimate Time and/or Fault Factors. It would be nice if RedLynx could provide that data.

    I've improved a couple of individual tracks so far and they give the correct scores.

    Tracks scoring confirmed on:
    Container Rush
    Dreamscape
    Stock Market
    Tired Hill
    Rock'N'Drop
    Unfair Bombardment
    Trials/Tribulations

    I'll post more when I get some more PBs.

    For people who want those spreadsheets to calculate their scores you can find them here : Trials Evo Spreadsheets (You can add that to the OP Chaeron if you wish)
    Share this post

  4. #4
    psycad's Avatar Member
    Join Date
    Mar 2014
    Location
    Helsinki, Finland
    Posts
    276

    Re: Community Project

    So I improved backyard cup, the sheet scoring was wrong of course but I played with some numbers and got an exact score.

    Here's the new data for Backyard Cup :
    Possibility #1 - Ultimate Time : 00:30.000 / Fault Factor : 0.4
    Possibility #2 (kn000t) - Ultimate Time : 00:56.250 (75% of platinum) / Fault Factor : 0.75

    To make sure what the correct data is we need someone who doesn't have 0 fault to get a PB.

    What we need : Any HD tournament
    Time & Faults Before / LB Score Before
    Time & Faults After / LB Score After
    Share this post

  5. #5

    Re: Community Project

    So what we really need now are people that have faults on hd tournaments and can improve them.
    Ultimate Time : platinum time * fault factor
    Fault Factor : 0.xx

    0.75 fault factor is not correct as shown by psycad with his masters league improvement (he got a time that would be less than ultimate and calculation didnt result in correct values anymore)
    Share this post

  6. #6
    Ch4er0n's Avatar Senior Member
    Join Date
    Mar 2014
    Posts
    794

    Re: Community Project

    Thx for the replies guys! Seems like you were way ahead of me on this one. For clarification, what all is located in the xml files? Were ultimate times and fault factors for individual tracks there that you could just pull? Were formulas included? Are kn000t's and Psycad's sheets the same/provide the same score outputs? Seems like a number of tracks work great with the current formula, but Middle Name: Danger's ultimate time is a huge red flag for me (14s o.O) so I wanted to check that one for sure, and I thought it would be a feasible task to do the same for all.

    Awesome job guys!
    Share this post

  7. #7

    Re: Community Project

    Middle Name: Danger Ultimate is 0:11,000

    The values are stored in the tracks.xml
    Example Middle Nameanger
    [code:3uo6cuck]<Track id="838" mode="trials" leaderboard_id="120" context_id="0" fullonly="false" hdtrack="true" difficulty="1" factor="0.1" bikes="0,1,2,3,4" x="1028" y="410">
    <Limits ultimate="0:11:000" platinum="0:15:500" gold="0:19:300" silver="0:25:000" platinum_faults="0" gold_faults="0" silver_faults="0" pass="1000"/>
    <PrizeMoney grind="195" bronze="280" silver="360" gold="465" platinum="465"/>
    </Track> [/code:3uo6cuck]
    To get the file you have to unpack the data.pak with quickbms and the corresponding bms file.

    Formulas are not included, i just used the crash county sheet from http://forum.redlynx.com/forum/viewtopic.php?t=9676 (thanks to original creators )and added HD.
    The only difference between psycads and my sheet should be the tourneys, as we speculated with the values there.
    Share this post

  8. #8
    Ch4er0n's Avatar Senior Member
    Join Date
    Mar 2014
    Posts
    794

    Re: Community Project

    Thx kn000t, that really sorts things out for me. When I get home I'll check through the xml files to double check ultimate standards (and other medals probably).

    Psy's backyard cup possibility seems pretty reasonable to me, ultimate times (especially for tourneys) are usually really low, so 30 seconds follows that trend. Also, for a beginner tourney 0.4 fault factor seems reasonable.

    I'll keep workin on this later, and I guess I'll get skill games sorted out later
    Share this post

  9. #9

    Re: Community Project

    Thanks for the spreadsheet
    Share this post

  10. #10
    Ch4er0n's Avatar Senior Member
    Join Date
    Mar 2014
    Posts
    794

    Re: Community Project

    I looked for a while and can't for the life of me find the tracks.xml file. Also, what is most people's margins of error when adding spreadsheet scores together vs global score? For me:

    Crash County: 22,863,724
    HD Warehouse: 14,283,080
    Total: 37,146,804

    Leaderboard Score: 36,756,707

    Projected score for me is 390,097 too high, which is a lot. Is it possible for this amount to be fully reduced just by adjusting tournaments?
    Share this post