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….
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….