I changed the Y-O-Y for the 53-week years since it wasn't proper. Week 52 and 53 of 2015 for example were compared both with week 52 of 2014. Now the comparison will be with what was sold 52 weeks ago.
HARDWARE
Code:+-------+------------+------------+------------+------------+------------+-------------+ |System | This Week | Last Week | Last Year | YTD | Last YTD | LTD | +-------+------------+------------+------------+------------+------------+-------------+ | 3DS # | 120.105 | 154.818 | 153.166 | 2.347.554 | 153.166 | 20.185.999 | | PS4 | 65.427 | 53.023 | 42.216 | 1.330.410 | 42.216 | 2.301.077 | | PSV # | 64.481 | 74.330 | 58.005 | 1.069.471 | 58.005 | 4.593.398 | | WIU | 53.547 | 92.801 | 30.031 | 877.082 | 30.031 | 3.020.662 | | PS3 | 4.221 | 3.994 | 17.867 | 219.103 | 17.867 | 10.388.094 | | XB1 | 765 | 490 | 637 | 20.624 | 637 | 63.891 | +-------+------------+------------+------------+------------+------------+-------------+ | ALL | 308.546 | 379.456 | 301.922 | 5.864.244 | 301.922 | 40.553.121 | +-------+------------+------------+------------+------------+------------+-------------+ | PSVTV | 670 | 1.167 | 1.305 | 35.239 | 1.305 | 185.452 | | PSV | 63.811 | 73.163 | 56.700 | 1.034.232 | 56.700 | 4.407.946 | |n-3DSLL| 73.778 | 107.374 | 76.439 | 1.603.058 | 76.439 | 2.470.116 | | n-3DS | 21.501 | 29.252 | 40.338 | 463.142 | 40.338 | 832.448 | | 3DSLL | 3.205 | 5.083 | 19.096 | 110.640 | 19.096 | 6.943.263 | | 3DS | 21.621 | 13.109 | 17.293 | 170.714 | 17.293 | 9.940.172 | +-------+------------+------------+------------+------------+------------+-------------+
Thanks a bunch! I knew there was somethig a bit werid with the YTD comparison.
However, you put the wrong numbers for last year YTD (it's just last year weekly numbers, not the YTD total).