Rule of Thumb

Let’s start with basic question: how much is each resource allocated on the project? With this we’ll replicate Microsoft Project’s Resource Sheet, with Work field added to it.

To get this out of Microsoft Project database, you need to construct something like:

Step by step instructions, assuming you know how you pull the data out of Microsoft Project:

1. Add tables MSP_PROJECTS and MSP_RESOURCES.
2. Add PROJ_NAME from MSP_PROJECTS into Criteria pane and set criteria value to the name of the project. In the above sample its SOFTDEV.
3. Add RES_UID from MSP_RESOURCES into Criteria pane and set criteria value to >0. Only resources with unique ID greater than 0 are valid actually resources. Other records in resource table are for the purpose of Project.
4. Add RES_NAME and RES_WORK from MSP_RESOURCES to the query.
5. Now double click RES_WORK in the query and change it to MSP_RESOURCES.RES_WORK / MSP_PROJECTS.PROJ_OPT_MINUTES_PER_DAY / 1000 to have the work displayed in days.
6. Change the work column heading by double clicking it and putting Work into Column heading field.
7. Change resource name column heading in the same way to Resource Name.
8. To sort the resulting table, click anywhere in the resource name column and click Sort Ascending button.
9. Click Return Data button and you’ll get the table in the Excel.