Excel-Access
New Member
- Joined
- Jul 18, 2012
- Messages
- 3
Dear Community
I am hoping someone can help me.
In the attachment, I have costs which are phased depending on when we start.
Row 2 £84,000 is split from April to October by judgement assuming a normal distribution manner, starts off high, peaks and then tails off.
Is there an Excel formula if I put start date, end date or start date and split by 8.5, it will produce more or less these numbers/patterns please?
[TABLE="width: 961"]
<colgroup><col span="13"><col><col></colgroup><tbody>[TR]
[TD]CTA (£ value)
assessed[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD][/TD]
[TD]CTA Total (£ value)[/TD]
[/TR]
[TR]
[TD="align: right"]£84,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£7,000[/TD]
[TD="align: right"]£5,000[/TD]
[TD="align: right"]£2,000[/TD]
[TD="align: right"]£0[/TD]
[TD="align: right"]£0[/TD]
[TD][/TD]
[TD="align: right"]£84,000[/TD]
[/TR]
</tbody>[/TABLE]
I am hoping someone can help me.
In the attachment, I have costs which are phased depending on when we start.
Row 2 £84,000 is split from April to October by judgement assuming a normal distribution manner, starts off high, peaks and then tails off.
Is there an Excel formula if I put start date, end date or start date and split by 8.5, it will produce more or less these numbers/patterns please?
[TABLE="width: 961"]
<colgroup><col span="13"><col><col></colgroup><tbody>[TR]
[TD]CTA (£ value)
assessed[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD][/TD]
[TD]CTA Total (£ value)[/TD]
[/TR]
[TR]
[TD="align: right"]£84,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£20,000[/TD]
[TD="align: right"]£10,000[/TD]
[TD="align: right"]£7,000[/TD]
[TD="align: right"]£5,000[/TD]
[TD="align: right"]£2,000[/TD]
[TD="align: right"]£0[/TD]
[TD="align: right"]£0[/TD]
[TD][/TD]
[TD="align: right"]£84,000[/TD]
[/TR]
</tbody>[/TABLE]