Skip to content

Integrate P6 with Esimate

Rob KaneMember for 22 years 9 months
Created
4
3
0

Hi Guys,

Has anyone out there had any experience with integrating the schedule with the estimate.

My organisation currently works with an estimating depatment that goes off and builds an estimate (they use expert & or Candy) at the same time we have the planners building a project schedule in P6.

We dont currently have a system to integrate the two sources of data. So I have the crazy situation where I have an estimate with 40 000 lline items, right down to litres of fuel and a project schedule that has around 1000 activities.

There is notihng that ties them together.

Does anyone have any info on the correct process /  procedure to get this working that they are willing to share?

Thanks

Rob

 

 

 

4 replies

Oldest first
  1. 0
    Mike Testro ·

    Hi Rob This is where your WBS

    Hi Rob

    This is where your WBS numbers are most effective.

    I assume that your estimate breakdown is on some sort of Spreadsheet.

    You need to go through it and allocate your programme WBS codes to the estimate lines.

    Then summarise the cost elements to each WBS entry to transfer to the programme resource section.

    This is very cumbersome in Excell but works very simply in Lotus 123.

    In some organisations they have standard WBS codes that both the estimators and planners use - maybe you should discuss this with your managers.

    Best regards

    Mike Testro

  2. 0
    Rob Kane ·

    Thanks for the reply Mike, I

    Thanks for the reply Mike, I think we are following similar thought processes. This is what we have had to do to get the alignment with Estimate & Schedule - we have had to go back to it and allocate a scope ID / WBS to each line and then summarize up to Plant Labour Material etc.

     

    I suppose the obvious answer to my question is the steps need to be followed properly 1. Identify Scope 2. Define WBS 3. Build estimate & Build Schedule (and get these built together not independently).

  3. 0
    Mimoune Djouallah ·

    Robwe are more or less in the

    Rob

    we are more or less in the same situation, i made a presentation and a couple of simple excel tools for integrating scope and planning, hope you find it useful.

    https://www.box.net/s/ryfxdtnnyhz7qpufgp5l

     

    regards

    mimoune djouallah

  4. 0
    Sankar Vijayan ·

    HiThe best software for

    Hi

    The best software for integration is CCS Candy .I  am a costing Engineer & i am now using Excel for preparing various MIS reports .I think if u use candy & give good inputs its a fantastic software

     

    Regards

    Sankar

Log in or join to reply

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

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