Phasing Costs In Normal Distribution Manner Between Months

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?

CTA (£ value)
assessed
JanFebMarAprMayJunJulAugSepOctNovDecCTA 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>
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,114,445
Messages
5,547,962
Members
410,820
Latest member
Prepost
Top