By using this site, you agree to our Privacy Policy and our Terms of Use. Close
Symbios63 said:
I had some fun twisting the formula yesterday.

To get numbers matching more or less NPD march results, I did three main changes :

- Getting rid of Walmart and Target numbers ; those are neither hourly nor daily best selling lists meaning there are kind of useless for our future "tool".
- Twisting the point system to award more point to high ranking items (#100 = 1 point, #51 = 50 points, #49 = 52 points, #21 = 110 points, #20 = 115 points, #1 = 210 points)
- Formula used was : Gamestop*1 + Best Buy*0.3 + Amazon*0.5

I don't have my excel sheet in front of me but I am pretty sure this is what I did (will double check later).

What do you think of those changes ? We have to keep in mind that we only have one week of data for March though...

I will finish April with all 5 lists and will calculate month average with both old and new system...

Sounds good, can't wait to see the results