Hi,
I've allocated income value of £1m to a line in a project, then I've allocated income value of £2m to another line in a project, (same programme) and allocated a likelihood of 50% likelihood to both projects.
Is there a way of getting the income values with % likelihood applied (so would be £0.5m & £1m) in the spreadsheet and this to roll-up to summaries (I can do a formula for the income values % likelihood, but can't get them to roll up)?
I've used the Apply % likelihood in a histogram which works well, but would like to be able to display the values in the spreadsheet too.
Thanks in advance,
Chris
Hi Mike,
I was trying to use it for a potential work pipeline in terms of planning / forecasting unconfirmed projects (i.e. those that we're tendering, are in consultation etc etc). With this tool, I can put the forecast value for each project, but when projecting for business planning / forecasting pruposes I don't want to assume that every project is a winner / goer, therefore applying the % likelihood (which applies to resources & £ values) to it enables a more likely forecast.
It works for histograms (all you have to do is tick the box "apply % likelihood"), but with the spreadsheet it doesn't roll % likelihood values up, it just does sums the whole value (i.e. 100% value for each project).
Any ideas for get around?
Chris
Hi Chris
You have me puzzled.
Why are you doing this and what are you trying to achieve.
This is a genuine query - I have been using powerproject for the last 25 years and never heard of this process before.
Best regards
Mike Testro