By using this site, you agree to our Privacy Policy and our Terms of Use. Close
non-gravity on 10 November 2012
Edit Thread
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.