Formula to distribute hours based on different types of distributions

[ToddL]

Hi -

I'm trying to come up with a formula that will take the total number of hours needed for a project and distribute them across the duration using different allocations. The 4 allocations I've identified are Front Loaded, Back Loaded, Evenly Distributed and Unevenly Distributed. The way I'm trying to distribute them is as follows:

Front Loaded: Divided evenly across first third of project
Back Loaded: Divided evenly across back third of project
Even Distribution: Evenly distributed across entire duration
Uneven Distribution: 40% allocated to first and last third of project, and 20% allocated to middle third.

The result would look something like this. Any ideas on formulas that could accomplish this. Thank you in advance.

Total Hours	Distribution	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6
24	Even	4	4	4	4	4	4
24	Front Loaded	12	12	0	0	0	0
24	Back Loaded	0	0	0	0	12	12
24	Uneven	4.8	4.8	2.4	2.4	4.8	4.8

<tbody>
</tbody><colgroup><col><col><col span="6"></colgroup>

 

[oldbrewer]

Total Hours	Distribution	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6
24	Even	4	4	4	4	4	4
24	Front Loaded	12	12	0	0	0	0			this table just defines the distribution for a 6 month project
24	Back Loaded	0	0	0	0	12	12
24	Uneven	4.8	4.8	2.4	2.4	4.8	4.8
									this is J7	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6
									BL	0	0	0	0	0.5	0.5
									EV	0.166667	0.166667	0.166667	0.16666667	0.166666667	0.166667
									FL	0.5	0.5	0	0	0	0
									UN	0.2	0.2	0.1	0.1	0.2	0.2
col a
Total Hours	Distribution	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6		row 15
24	EV	4	4	4	4	4	4
36	FL	18	18	0	0	0	0
72	BL	0	0	0	0	36	36
144	UN	28.8	28.8	14.4	14.4	28.8	28.8
	this lower table is generated by formula
	the first 4 in the top row comes from
	=$A16*OFFSET($J$7,MATCH($B16,$J$8:$J$11,0),MATCH(C$15,$K$7:$P$7,0))

<colgroup><col><col><col span="6"><col><col span="4"><col><col><col span="2"></colgroup><tbody>
</tbody>