forecasting issue

[cashmire]

I'm currently working on a forecasting sheet but am running into a slight problem over which I've been cracking my head. Problem is as follows:
the cattle comes in on date in column E and stays on feed for an average of 85days. However, the first sales date will be E+70days (50% of # heads, column D) and the final sales date will be E+100 (the remaining 50% of #heads). In my current formula the sales are spread out of a duration (column H). I have now been asked to make visible a split as per descriped above and am at a loss on how to do this. Does anyone have any idea?
Thanks!

PS column J=Dec-05, K=Jan-06, etc.

RMLC livestock division 2yr Forecast.xls
	D	E	F	G	H	I	J	K	L	M	N	O	P
21	450	1/1/2006	4/1/06	392.50	1	100%	0	0	0	0	450	0	0
22	450	2/1/2006	5/1/06	391.10	1	100%	0	0	0	0	0	450	0
23	450	3/1/2006	6/1/06	395.30	1	100%	0	0	0	0	0	0	450
24	450	4/1/2006	7/1/06	393.90	1	100%	0	0	0	0	0	0	0
feedlotting

 

[Aladin Akyurek]

Describing a problem by means of non-working formulas is not the best thing to do. Try to put up the desired results along with a description of how you obtain them.