Convert weekly to monthly data

Hi,
I have such question:
My data is on weekly base in columns like this:

date smth.
..... ...
27.08.02 471059
20.08.02 452789
13.08.02 465509
06.08.02 420657
30.07.02 430325
23.07.02 446067
16.07.02 486180
09.07.02 452964
.... ...

And I want to organize it monthly on average. Could anyone help me with
advise?

Thanks,

Svilen

Hi Svilen

Create a Pivot table. See
http://www.cpearson.com/excel/pivots.htm
Use "date" as row source and "smth" as data source. Rightclick the Date
table header, choose the "group" menu, group by month.

HTH. Best wishes Harald

"Svilen Pachedzhiev" <[email protected]> skrev i melding
news:[email protected]...
> Hi,
> I have such question:
> My data is on weekly base in columns like this:
>
> date smth.
> .... ...
> 27.08.02 471059
> 20.08.02 452789
> 13.08.02 465509
> 06.08.02 420657
> 30.07.02 430325
> 23.07.02 446067
> 16.07.02 486180
> 09.07.02 452964
> ... ...
>
> And I want to organize it monthly on average. Could anyone help me with
> advise?
>
> Thanks,
>
> Svilen
>
>

Create a pivot table

http://peltiertech.com/Excel/Pivots/pivotstart.htm

and group the data by month:

http://www.contextures.com/xlPivot07.html



In article <[email protected]>,
"Svilen Pachedzhiev" <[email protected]> wrote:

> Hi,
> I have such question:
> My data is on weekly base in columns like this:
>
> date smth.
> .... ...
> 27.08.02 471059
> 20.08.02 452789
> 13.08.02 465509
> 06.08.02 420657
> 30.07.02 430325
> 23.07.02 446067
> 16.07.02 486180
> 09.07.02 452964
> ... ...
>
> And I want to organize it monthly on average. Could anyone help me with
> advise?
>
> Thanks,
>
> Svilen

Thanks a lot!

Hi

Depends on, how exact montly report do you need. Some weeks belongs
partially to 2 different months. Possible solutions:
a) the week belongs to month of week's first or last day. Harald's advice
will do;
b) the weekly production/amount/sum is divided between months proportionally
to number of(work)days, wchich belong to one or another month. Probably
you'll need some sdditional columns, or you get huge formulas.
c) Your table has an additional column for month. When the week belongs to 2
different months, you enter 2 rows of data with same week, but different
months. Whem summarizing data, your use for condition comparision data in
week or month columns.


P.S. I myself prefer in tables like this to use the week in format
"yyyy.ww" - i.e. 2005.01 means the 1st week of year 2005.


Arvi Laanemets


"Svilen Pachedzhiev" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I have such question:
> My data is on weekly base in columns like this:
>
> date smth.
> .... ...
> 27.08.02 471059
> 20.08.02 452789
> 13.08.02 465509
> 06.08.02 420657
> 30.07.02 430325
> 23.07.02 446067
> 16.07.02 486180
> 09.07.02 452964
> ... ...
>
> And I want to organize it monthly on average. Could anyone help me with
> advise?
>
> Thanks,
>
> Svilen
>
>