By using this site, you agree to our Privacy Policy and our Terms of Use. Close

Forums - Sales Discussion - 10 Week Countdown 2012 - Final Results

non-gravity on 10 November 2012
superchunk said:
non-gravity said:

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)]*100 then round and take the absolute value. The maximum score has been set at 100.

 


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.

Yes that is correct, in my spreadsheet it's all fine though and the above graphs and table.

=IF(OR(VLOOKUP(N;NS;V;0)=0;D4=0);"";IF(D4="*";100;MIN(ROUND(AVERAGE(ABS(VLOOKUP(N;NS;V;0)-D4)/VLOOKUP(N;NS;V;0);ABS(VLOOKUP(N;NS;V;0)-D4)/D4)*100;0);100)))

Would you like a copy of my spreadsheet now?

 

As for your other post:

I'd normally just post the REAL values in a post in the thread. In my spreadsheet they are just below the prediction tables. I like the idea of adding them to the prediction tables in this thread, but that would mean I'd have to upload 5 more tables each week. Again you may just want a copy of my spreadsheet.



Around the Network
think-man on 10 November 2012

Uhhh my predictions are way off ahahaha



 

How to Make friends In Dark Souls 3

darkjonnyx on 10 November 2012

Nice first round, Wii number almost perfect!



Michael-5 on 11 November 2012

Dammmit!!!

I'm doing so bad this year, last year I finished in 2nd! This year I'm in 19th, and my best positions are 13-14th for PS3/360/3DS.

I hope this turns around in my favor...



What is with all the hate? Don't read GamrReview Articles. Contact me to ADD games to the Database
Vote for the March Most Wanted / February Results

Michael-5 on 11 November 2012
pezus said:
Nailed PS3 and 3DS, a bit over on everything else :/

Nice, I seem to have below average estimates for the first 2 weeks, and I did underball almost everything this week. Hopefully I can catchup, I came 2nd last year

Damn Wii.....I just don't understand you!



What is with all the hate? Don't read GamrReview Articles. Contact me to ADD games to the Database
Vote for the March Most Wanted / February Results

Around the Network
menx64 on 11 November 2012

quite spot on for the 3ds! wii a bit off... but it seems like I am going to be the overall last place, as I didnt make any predictions for ps3/360 nor vita... oh well maybe next year!



Menx64

3DS code: 1289-8222-7215

NNid: Menx064

theprof00 on 11 November 2012

So excited for next weeks numbers. Damn why does it have to be another 5 days away!



Michael-5 on 11 November 2012
pezus said:
Michael-5 said:
pezus said:
Nailed PS3 and 3DS, a bit over on everything else :/

Nice, I seem to have below average estimates for the first 2 weeks, and I did underball almost everything this week. Hopefully I can catchup, I came 2nd last year

Damn Wii.....I just don't understand you!

You still have adjustments to count on. I suspect there will be some adjustments soon because of the NPD results

Yea, but still I won't be doing as good as last year. I had 3DS and 360 spot on and my HD guesses were #2. I kinda rushed my predictions. Hopefully change in my favor after 2 weeks, I think I'm the most optimistic about 3DS sales. Still beat you on 360 predictions, I dunno why I am good with those.

Good job on 14th.



What is with all the hate? Don't read GamrReview Articles. Contact me to ADD games to the Database
Vote for the March Most Wanted / February Results

Michael-5 on 11 November 2012
pezus said:
Michael-5 said:

Yea, but still I won't be doing as good as last year. I had 3DS and 360 spot on and my HD guesses were #2. I kinda rushed my predictions. Hopefully change in my favor after 2 weeks, I think I'm the most optimistic about 3DS sales. Still beat you on 360 predictions, I dunno why I am good with those.

Good job on 14th.

Well, we'll both be pretty far off 360 if it is adjusted down in USA

Skeezer and superchunk are more optimistic about 3DS sales . 

Just by a bit in overall, but I'm the only one who thinks 3DS will sell more then 1600 units on christmas week. Will be interesting



What is with all the hate? Don't read GamrReview Articles. Contact me to ADD games to the Database
Vote for the March Most Wanted / February Results

non-gravity on 15 November 2012
think-man said:
You should note that persona 4 for vita is coming out on you're notable games table.

I feel I've been wrong on this one.

Persona 4 may very well have the biggest launch on Vita in America this holiday, seeing how COD:Declassified and AC:Liberation are doing