Oops, you're right. My excell sheet was booted up without showing me column one which has the correct week list, as compared to the row number which I accidently used...I will fix it.

Fixed an aesthetic mistake with the placement of color indicating past weeks from future weeks.

Updated to September 1st

Vita Weekly Predicted Sales 12/22/2011 - 12/31/2012

Vita Lifetime Predicted Sales 12/22/2011 - 12/31/2012

You could use a x weeks moving average, to hide the weekly spikes that distort your analysis. Maybe with 10 weeks moving averages, comparing to the 10 weeks average of the same weeks last year, you can calculate a much more reliable sales number that shows tendencies but hides spikes. Take a look at the green line, it shows the tendency, but makes it much softer. If you want to follow the changes faster, you could use a smaller number of weeks, as 5.

Vita back to rough numbers in Japan. Probably back under 40k WW next week, which means back to around 4m predicted 2012 sales. :/

No update on the numbers?

Two weeks of bad vita sales, two weeks without updates.

Sorry, been busy moving, still have stuff to unpack. I have the next week off so I will update and maybe look into that chart style you posted.

Updated to September 22nd

 4,117,510 Vitas sold by end of 2012!

Vita Weekly Predicted Sales 12/22/2011 - 12/31/2012

Vita Lifetime Predicted Sales 12/22/2011 - 12/31/2012

Sorry about the long wait in between updates. The Vita is back down from an up it recieved three weeks ago from Project Diva F launch in Japan. It's predicted total is now 4,117,510 which is down by 1,832,545. While it is still up a tad from a month ago the system is running out of time to make a comeback before the holiday season hits.

Wow... 3.6m projected for 2012... so close to the holidays.

Ouch. Maybe LBP will give it a little bump?