By using this site, you agree to our Privacy Policy and our Terms of Use. Close

Forums - Sales Discussion - What constitutes a "Month"?

Sqrl on 24 July 2007

Just wondering what the general rules are about how you determine which weeks are part of a given month and which weeks are not?

 

Just wondering because I have put a spreadsheet together and I need to know so I can properly allocate sales to a given month...

 I have been using the simple rule of "the last day of the week determines the month it is attributed to". Please advise...

pic of the spreadsheet  (just added new sales data)
To Each Man, Responsibility
Around the Network
Sqrl on 25 July 2007

bump...nobody knows???
To Each Man, Responsibility
shams on 25 July 2007

Its broken down into a number of whole(full) weeks. It will either be 4 or 5 weeks.

Not sure what "day" it is, but the number of weeks will be determined by the number of Fridays(?) that are present in the month.

June had 5(?) - 1st, 8th, 15th, 22nd, 29th

July gets 4, etc.

(again - not sure what day it is, but Friday works for June/July...).



Gesta Non Verba

Nocturnal is helping companies get cheaper game ratings in Australia:

Game Assessment website

Wii code: 2263 4706 2910 1099

omgwtfbbq on 25 July 2007

I believe it's much simpler that that.

every month is 4 weeks, except the last of any quarter (March, June, Sep, Dec). As well as that, every once in a while there's an extra 5 week month (which happened this year, hence January)

At least, I'm pretty sure that's how NPD does it. Anyone have any objections?



Help! I'm stuck in a forum signature!

WiteoutKing on 25 July 2007

omgwtfbbq's sounds like it would be the one used, especially by NPD and such.

My guess (until that post) would have been the set of weeks that have at least 4 days in that month (ex: January 28 - February 3 would be January, whereas January 29 - February 4 would be February). But that gets messy.



PS3: 5.51m/51w, avg 108,039/w (up 239)
360: 12.93m/102w, avg 126,764/w (up 625), leads PS3 by 7.42m (up 70k), avg lead 18,725/w (up 386)
Wii: 13.52m/51w, avg 265,098/w (dn 1,102), leads PS3 by 8.01m (up 90k), avg lead 157,059/w (dn 1,341)

If 360 sales stabilize, PS3 sales increases needed to pass 360 by...
01/08: (008w) +875.8%, 04/08: (021w) +344.4%, 07/08: (034w) +219.3%, 10/08: (047w) +163.5%
01/09: (060w) +131.8%, 04/09: (073w) +111.4%, 07/09: (085w) +098.1%, 10/09: (099w) +086.7%
If Wii sales stabilize, PS3 sales increases needed to pass Wii by...
01/08: (008w) +1072.%, 04/08: (021w) +498.4%, 07/08: (034w) +363.4%, 10/08: (047w) +303.1%
01/09: (060w) +269.0%, 04/09: (073w) +246.9%, 07/09: (085w) +232.6%, 10/09: (099w) +220.3%
If PS2 sales freeze, Wii sales increases needed to pass PS2 (as of Mar07, 108.4m) by...
2008: (008w) +4373.8%, 2009: (060w) +0496.5%, 2010: (112w) +0219.6%, 2011: (165w) +0116.9%
2012: (217w) +0064.9%, 2013: (269w) +0033.1%, 2014: (321w) +0011.5%, 2015: (376w) -0004.8%
At +0% it will pass it in 358w, the week ending September 19th, 2014, at an age of 409w (7y44w).
Current age of PS2: 7y37w.

Last update: Week ending November 3, 2007

Around the Network
Sqrl on 25 July 2007

thanks,


so then Q1 going by "omgwtfbbq" this year would look like this?
(all dates are for the week ending on that day in the US)

April: April 7th, April 14th, April 21st, and April 28th
May: May 5th, May 12th, May 19th, and May 26th
June: June 2nd, June 9th, June 16th, June 23rd, and June 30th
To Each Man, Responsibility