Skip to content
ProjectControls.com
Asta Powerproject

Project Percentage Likelihood

In the Open Standard
Chris LothianMember for 19 years 5 months
Created
2
1
0

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

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi ChrisYou have me

    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

    Report
  2. 0
    Chris Lothian ·
    #2

    Hi Mike, I was trying to use

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?