Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

?Links to online pdf's showing connecting estimating software and P6 - I need to show it is not that hard...

1 reply [Last post]
John Reeves
User offline. Last seen 1 day 10 hours ago. Offline
Joined: 10 May 2013
Posts: 156
Groups: None

Links to online pdf's showing connection between estimating software and P6 - I need to show it is not that hard...I commonly find contractors telling owners that can't do cost and resource loading because it is too hard.  I need some pdf materials showing it isn't.  Not as easy to find as I thought.  I need to tell them the pros and cons as well.


Zoltan Palffy
User offline. Last seen 13 hours 17 min ago. Offline
Joined: 13 Jul 2009
Posts: 2983
Groups: None

The key is that schedule resembles the takeoff used in the estimating software. You have ot make a correlation between the two.

1. All most all estimating software has the ability to export the cost and manhours to excel. So export this information to excel.

2. create a resource in P6 call it LUMPSUM this is where the dollars and manhours will reside.

(make sure that calculate costs from units is not checked)

3. select all activities and rigth click and select assign resource and select the LUMPSUM resource.

4. export all of the activities that have resources to excel and make sure to include the budgedted units field and the budgeted costs field.

5. use the export from the estimating software to populate the budgeted units (manhours) and budgeted costs in the export from P6 to excel. Populate each activity.

6. Import the spreadsheet back into P6.

DONE ! now you have a cost and resource loaded schedule that was derived from the estimate.

I dont have this info on line