import & update actuals

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.
--
Carol Summa

Gérard
Thu May 12 07:25:28 CDT 2005


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

CarolSumma
Thu May 12 12:38:05 CDT 2005

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.
--
Carol Summa


"Gérard Ducouret" wrote:

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

Jayzee29
Thu Jun 16 00:31:05 CDT 2005

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

"Carol Summa" wrote:

> 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.
> --
> Carol Summa
>
>
> "Gérard Ducouret" wrote:
>
> >
> > 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
> >
> >
> >
> >
> >