Calculate an even spread of data over a 12 month period

**vsiepen** · 06-15-2012, 10:59 AM

Can anyone please help me spread data evenly across 12 months? I am trying to determine a head count increase and wonder if there is an easy way to do this. For example how would I spread the increase from 125 to 483 across 12 months. I am used to using a spread function in Cognoscenti TM1.

Thanks so much

Victoria

**gjlindn** · 06-15-2012, 11:00 PM

Hi Victoria...hopefully you're looking for something like the attached. If not, could you provide an example? Thanks!

**vsiepen** · 06-16-2012, 02:38 AM

Thanks so much - worked a treat

**gjlindn** · 06-16-2012, 11:42 PM

Glad to help Victoria. If you could please mark this thread as solved, I'd appreciate it. Thanks!

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save