MARKET PRODUCT SPENDING YEAR MONTH
A WWW $10.00 2001 Jul
A WWW $10.00 2001 Aug
B WWW $30.00 2001 Jul
B WWW $40.00 2001 Aug
C WWW $10.00 2001 Jul
C WWW $20.00 2001 Aug
C WWW $30.00 2001 Sep
Basically, in the data, each product has 12 months monthly spendings within
each market. In other words,
the file has the monthly spending data by product, market, month, year.
I will need to calculate the weekly spendings and output a weekly data.
The way I calcuate the weekly spendings will be as follows:
July, 2001 - montly spending: $100
August, 2001 - montly spending: $200
The first 4 weeks and all 7 days were in July; therefore, the weekly
spending for the first 4 weeks will be ($100/31)*7 because July has 31 days.
(i.e. for Sep, it will be $100/30)
But the 5th week was different, the first two days were in July and the rest
of the 5 days were in August; therefore, the weekly spendings would be
($100/31)*2 + ($200/31)*5 to get the weighted spendings.
I was wondering should I create a daily data first and convert it to a
weekly data, would it be easier to handle? Any advice will be greatly
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp