import & update actuals

[Carol Summa]

I have a large project and approximately 25 people sending me weekly
spreadsheets to update their actual hours worked. Not knowing the havoc that
it was going to create, I was importing those spreadsheets into my project
plan and updating the actual work column. Everything was working fine until
I just discovered that the actuals were updating future date. For example,
the plan allocates each resource to work 6.4 hours per day. That's a total
of 32 hours per week. If a resource sends in that they worked on a task for
40 hours that week and I increase the actual work column by 40, behind the
scenes project only puts 32 hours on the current week and then schedules the
rest for the following week.

One, I need to figure out how to get all the hours posted from the past 16
weeks to be backdated so there is no longer future dated actuals. And then,
two, I need to figure out how to post the actual hours by date instead of
just updating the actual work column....or is there a way to tell project to
force any overage to the current billing week.

Any help or insight would be appreciated.

 

[Gérard Ducouret]

Hello Carol,

<<If a resource sends in that they worked on a task for
<<40 hours that week and I increase the actual work column by 40, behind the
<<scenes project only puts 32 hours on the current week and then schedules
the
<<rest for the following week.

That's the normal behavior of Project,

If you want to say that the ressource worked 40 h during a specific week,
don't use the Work column which only do the sum of all the work periods. You
need to enter you data on a timescaled grid.
Use the Task Usage or Resource Usage view with a timescale by weeks. Display
the Actual Work field on the right pane : Right Click a yellow cell and
click Actual Work.

Gérard Ducouret

 

[Carol Summa]

That's what I was afraid of. I have too many resources posting hours to do
this manually. I was previously combining all time sheets into one Excel
spreadsheet and then importing the actuals based on task id. Is there a way
to do that and import the actuals by date? I do get the breakdown from the
resources of the Monday through Sunday hours that they post. I was summing
those up and bringing in the total but can bring in each day if I need to.

I need to have a way to import instead of manually updating each resources'
time.

 

[Jayzee29]

Did you get an answer on this? I was wondering the same thing. I wouldlike to
be able to automatically upload by bi-week