Skip to main content
Planview Customer Success Center

How to allocate recurring planned hours in Project Planning Worksheet? (CP2017 SP2)

You can allocate planned effort of the same amount over a number of consecutive daily or fiscal periods. 

First, ensure that you use a task assignment view that includes the "Effort distribution" field and has daily or fiscal periods displayed.

To allocate the same number of planned hours to consecutive daily or fiscal periods

Using the following formula, enter the recurring planned hours into the daily or fiscal period where you want the allocations to begin:

[Planned hours amount]x[Number of daily or fiscal periods]

For example, to allocate 5 hours each to the next 10 daily or fiscal periods, enter "5x10" in the first daily or fiscal period.

To evenly distribute planned hours over consecutive daily or fiscal periods

Enter the recurring planned hours based on the following formula into the daily or fiscal period where you want the allocations to begin:

[Planned effort amount]/[Number of daily or fiscal periods]

For example, to evenly distribute 50 hours over the next 10 daily or fiscal periods, enter "50/10" in the first daily or fiscal period. Five hours would then be allocated to each of the 10 consecutive daily or fiscal periods.