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?
<colgroup><col span="13"><col><col></colgroup><tbody>
</tbody>
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?
| CTA (£ value) assessed | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | CTA Total (£ value) | |
| £84,000 | £20,000 | £20,000 | £20,000 | £10,000 | £7,000 | £5,000 | £2,000 | £0 | £0 | £84,000 |
<colgroup><col span="13"><col><col></colgroup><tbody>
</tbody>
