I've been wondering a little about it myself. I'd heard that stock markets use a system where a 2% increase on day one and a 2% decrease on day two brings you on exactly the same value. While when you would normally use percentages it would be 100*1,02*0,98 = 99,96.

I searched for it and a site told me it is: (new - old) / ((new plus old)/2)

So I compared its effects to our own equation and it seems they are pretty much the same for the range: 50% underpredicting to 100% overpredicting.

More extreme under and overpredicting does show significant differences

Take real sales at 100

if you had predicted 0 or infinity our method results in infinity points while the other method results in 200 points max.

This other method penalties bigger mistakes in predicting less hard.

Roaring start??? I lowballed everything, partly because of the upward adjustments in Others. And next week will certainly see the same problem with specifically PSP.

And so my process of submitting at the last minute and doing absolutely no research shows it's true colours.

Some very credible sources are saying GT5 will release on 30th November in US....1st December in EU, 2nd in Japan

LOL

He is quite impressive, always being civil, good debater.

On other thoughts, are you going to keep up with these tables weekly? That would be great appreciated. Don't worry about handhelds tables, but if you have time include them in the future. cool, and gooh job.

Last year I think TWRoO did:

A weekly totals table to see who won the week. (though now we have might have 3 if we do weekly console, handheld and overall table)

Besides that there were rankings for Wii, PS3, 360, DS, PSP, Consoles, Handhelds and Overall that combined all weeks.

It is rather a lot of work and TWRoO kept this up each week last year. I'm going to be free every Friday (when the numbers mostly come up) so I'll see what I can do.

Handheld table

Ow wow I learned how to sort these tables in Excel. This is gonna be so much easier :p

@non-gravity, can I ask how you coloured your tables?

To get a background colour on a column like that is way too much effort using VGC tables... but yours seem to be styled differently too.

I took the Excel table to Word 2007 first and then just posted to them here.

It seems this does keep the Excel tables intact.

Ah, weird... and cool... that should save me a lot of time as none of the formatting sticks when you copy from excel.