By using this site, you agree to our Privacy Policy and our Terms of Use. Close
Hyruken on 27 November 2008
Edit Thread
thx1139 said:
Hyruken said:

 Black friday last year was 22nd Nov 2007

So it goes like this

10th nov to 17th nov 2007 (1 week before Black friday 2007) http://vgchartz.com/hwtable.php?cons%5B%5D=PS3®%5B%5D=America&start=39397&end=39404

PS3 = 176k.   Compared to 91k this week, a week before Black Friday 2008.

3rd of Nov to 10th nov 2007 (2 weeks before Black Friday 2007) http://vgchartz.com/hwtable.php?cons%5B%5D=PS3®%5B%5D=America&start=39390&end=39397

PS3 = 134k.    Compared to 79k last week which was 2 weeks before Black Friday 2008.

27th of Oct to 3rd of Nov 2007 (3 weeks before Black Friday 2007) http://vgchartz.com/hwtable.php?cons%5B%5D=PS3®%5B%5D=America&start=39383&end=39390

PS3 = 99k.     Compared to 71k (1st Nov to 8th Nov 3 weeks before Black friday 2008)

Meaning for the 3 weeks before black friday last year the PS3 sold in america 409k units.

The PS3 has sold 3 weeks before black friday this year 241k units.

Thus concluding the PS3 the 3 weeks this year before black friday has sold -168k LESS units then over the same period last year. Almost losing 50% of sales.

So your numbers were wrong and my numbers were wrong in the 1st post because they included black friday. However as you can see even with out the actual sales of black friday the PS3 still has dropped 50% sales in the past 3 weeks over this time last year.

So i think that is some serious ownage there for you to try and figure your way out of Lucas :)

 

Your choosing multiple weeks in each query above.

Both the start and end week need to be the same week.

For PS3 week ending November 17th 2007 you want to use this query.

http://vgchartz.com/hwtable.php?cons%5B%5D=PS3®%5B%5D=America&start=39404&end=39404

This results in 96,546

Week ending November 10th

http://vgchartz.com/hwtable.php?cons%5B%5D=PS3®%5B%5D=America&start=39397&end=39397

This results in 79,539

Notice that is 176K.

Finally one week prior

http://vgchartz.com/hwtable.php?cons%5B%5D=PS3®%5B%5D=America&start=39390&end=39390

This results in 55,446

 

 How can a week start and end on the same day?....

If for example say 1st of january was say a monday that would be the weeks start. Then the 7th was a sunday that would be the weeks end. It makes no sense at all having the week start and end on say the monday 1st etc.. from start to end has to be a 7 day gap.