New DLC Global Score Calculation Spreadsheet Available! | Forums

[rlmergeuser]

Umm so I've never really messed around with Excel but when I was entering stats in I accidentally messed up the information or whatever it's called (the math behind the cell) in one of the cells so the calculations for it is completely messed up.

In other words, I modified one of the yellow cells on accident.

Is there anyway to fix this?

If you've messed up the formula in a single row, then just copy and paste the formula from the row immediately above or below.

If you've messed up something on the summary sheet or at the bottom of the page, though, just download a new copy of the spreadsheet, and copy the good formula from the same cell in the other one.

[rlmergeuser]

@ megatrain:

ive looked at that spreadsheet. do i have to fill in all my times on all tracks? sounds like a lot of work.
=/

[ben1bob]

@ megatrain:

ive looked at that spreadsheet. do i have to fill in all my times on all tracks? sounds like a lot of work.
=/

it really doesn't take as long as you'd think... honest!

it's worth it to see exactly how you can improve your rank.

[rlmergeuser]

My XBox isn't right next to my computer, so I actually write all my times/scores down on paper first, then enter them into the spreadsheet. Looking them up and writing them down takes more time than actually entering them.

Yes, I think its worth it to enter all the scores, if only because you can verify that the final score my spreadsheet calculates is close to the actual score XBox Live shows.

[rlmergeuser]

since i cant fit it in my sig any more (too many characters), i'll say thanks so much for making this spreadsheet - its helped me improve my global score so much, mostly by telling me where theres points to get.

[rlmergeuser]

i'm not sure, but there might be something wrong somewhere in your spreadsheet - my calculated score is about 2500 above what it should be, which is about 2480 points further off than it is normally

i've made sure absolutly everything i've entered is correct (checked it twice because i was sure this was the problem)
also, i've put all my times into a brand new copy of the spreadsheet just in case i messed some of the calculations up somehow, and it gives the same result.

the only places i've improved recently is the world championship tounament, and a bunch of the skill games (both ring of fire, both ride the ball, both flip skill games, both wheelie games and DLC in flames), which should narrow down the search a little.

anyone else having this problem, or is it just me?

[lespritdelescal]

i'm not sure, but there might be something wrong somewhere in your spreadsheet - my calculated score is about 2500 above what it should be, which is about 2480 points further off than it is normally

i've made sure absolutly everything i've entered is correct (checked it twice because i was sure this was the problem)
also, i've put all my times into a brand new copy of the spreadsheet just in case i messed some of the calculations up somehow, and it gives the same result.

the only places i've improved recently is the world championship tounament, and a bunch of the skill games (both ring of fire, both ride the ball, both flip skill games, both wheelie games and DLC in flames), which should narrow down the search a little.

anyone else having this problem, or is it just me?

Do you have the newest version of the spready? I think it's 1.02 or something. The one I am using is only maybe 25 points off for the regular game, and less than 10 points off with the DLC.

[rlmergeuser]

nope. i've just got 1.0

i guess the newer version is available at the link in the OP

*edit*
the one you get from the link is exactly the same as the one i have (last modified andversion number are the same) so i dont know whats causing the problem

oh, and while i remember, the problem is definitly with one of the original tracks - the discrepancy is 2297 without DLC and 2304 with.

what might have happened is the global calculator wasnt updated quickly enough in game, and its still working with one old time of mine

[rlmergeuser]

Amazing thread! Thanks a lot!

[Retribution]

Im having trouble using this lol, i wanted to know how much i can jump on the leaderboards having no fault ultimate league or lowering my total faults on midnight club. Also how much would i jump if i plat world championship? Im pretty much done with everything else.