Convert weekly to monthly data

  • Thread starter Thread starter Svilen Pachedzhiev
  • Start date Start date
S

Svilen Pachedzhiev

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

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
 
Back
Top