Importing “Actual Labor Hrs†into MS Project

R

R.Scott Fleming

Has anyone written a macro for importing actual labor into MS Project? Would
you be willing to share it with the group?

I am currently trying to manage all our jobs/projects in one master file
with a common resource pool of labor resources. All of the tasks within the
master file that have assigned resources have their own unique task name per
a designated Job/WBS Task structure (using an inserted custom text field in
the Gantt Chart view (or might plan on using the WBS numbering tool that is
available).

Job/Task structure example:
300-1-1
300-3-3
319-5-2
320-1-4

We record our weekly actual labor hours in an Excel sheet using the
following fields:
Employee ID
Job/Task
Date Worked
Hrs Charged

I am hoping the procedure would be as simple as opening the master file and
running the macro using the identified/specified Excel file containing the
information.

I realize there might be some error checking issues that would need to be
addressed such as “What if the Excel file has a Job/Task ID that is not
listed in the Project file, ect…(maybe that can be solved by the routine
first checking to see if all of the Job/Task ID exist and issuing an error
message if they do not prior to import…(as you can see I am not a programmer,
but am trying to think like one).

Is this possible? Or does anyone else have any thoughts on how to get
actual labor into Project easily?

Thanks in advance for any help or suggestions….
 
J

Jack Dahlgren

Microsoft has written an application which does this. It is called Project
Server and Project Web Access

-Jack Dahlgren
 
R

R.Scott Fleming

Thanks Jack for your suggestion. Going down this path would be too much of a
corporate culture shift and would not be easily done within our company at
the present. I was hoping to incorporate this macro approach as an interim
solution.
 
J

Jack Dahlgren

It is certainly possible to do a macro to do this, but it would be a
considerable amount of work and highly dependent on they way your projects
are structured. Because of that, you are unlikely to get someone to post a
solution that you can use directly.

Take a look at some of the examples I have posted about exporting resource
work data. It should be the top post here:

http://zo-d.com/blog

The macro you are looking for does something very similar but in reverse so
most of the example code can be leveraged.


-Jack Dahlgren
 
R

R.Scott Fleming

I have been to your website and see that you can write custom macros... do
you consult for firms? If so how do I get a hold of you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top