Hi
I have a spreadsheet which is an export from a project management software (Primavera)
It has start date, end date and budget.
I need to somehow produce an output in Excel which shows a phased budget.
For example
Start Date End Date Budget
15/01/2013 31/03/2013 15,000
I would want somehow to produce an output which applies 15,000 split into January, February and March, but pro-rata for the days required in each month: e.g. there are 75 days in the period so 15,000 / 75 = 200 per day, then:
Jan-13 = 3,200 (16 days at 200 per day)
Feb-13 = 5,600 (28 days at 200 per day)
Mar-13 = 6,200 (31 days at 200 per day)
Is this possible?
I have a spreadsheet which is an export from a project management software (Primavera)
It has start date, end date and budget.
I need to somehow produce an output in Excel which shows a phased budget.
For example
Start Date End Date Budget
15/01/2013 31/03/2013 15,000
I would want somehow to produce an output which applies 15,000 split into January, February and March, but pro-rata for the days required in each month: e.g. there are 75 days in the period so 15,000 / 75 = 200 per day, then:
Jan-13 = 3,200 (16 days at 200 per day)
Feb-13 = 5,600 (28 days at 200 per day)
Mar-13 = 6,200 (31 days at 200 per day)
Is this possible?