Damn way over on wii. Such a dumb mistake.
But carl you said "you can be tenth this week and then be the clear winner". I'll take that as a sign that i ill win :D

Never mind im not way over on wii.
How is it that im off by 5k and get 7 points??
Whats the point system again?

In easy terms your score is an approximation of the percentage you are off.

In more advanced terms your score is [((Real-Predicted)/Real+(Real-Predicted)/Predicted))/2]*100 then round and take the absolute value. The maximum score has been set at 100.

This table shows some of the scores for under or overpredicting

Being 5k off a 75k week gets you the same score as being 100k off a 1500k week

As to why this method is used, this may be insightful.

The green curve represents (Real-Predicted)/Predicted). This one would encourage overpredicting.

The red curve represents (Real-Predicted)/Real). This one would encourage underpredicting.

The blue curve is the average of the two which we use. This one tries to find a balance.

I am number 1 with weave on 360 woot. But vita and Wii will kill me.

I win big on Nintendo. Not so much for Sony... but at least I tried to play it safe. :)

PS3 is going to ruin me. Vita is not so bad thus far.

Hmm, so the higher the number, the more you can be off while having a better score. Unsure whether that favors the first weeks or the later weeks. Seems odd that being off by 5k this week will get me 7, but being off by 30k in another could get me 4.

It's not so much that the numbers don't make sense, but that as total sales increases, the "number of slots" you can hit to get a good score also increases. At 600k, you have 10-15 slots (going by every 5k) to get 7, but this week, being off by one slot will get you 7 also. Kinda sucks to be so close and get such a big score.

NPD really crapped on us all.

Any significant downward adjustments will hurt!

Seemingly pretty happy in the middle; I'll take that as a start...

I don't see where you are adding the REAL values for each week. Maybe add it at the bottom/top of the prediction tables with a name like REALVALUE.. .kinda how you have Mr Average.

You have your formula wrong.... its an average so it should be: [((Real-Predicted)/Real+(Real-Predicted)/Predicted)/2]*100

Then of course rounded and absolute value. I only noticed as i have my own spreadsheet and was trying to figure out how you got the score.