Reporting acording to Reality

[Studer]

In my company we want to integrate the HR system with our reporting in PWA.
The challenge is to import data from de HR system, which consists of an .txt
or .xls containing the hours each employee worked each day, so that using PWA
they can distribute it among the several tasks they worked on.

How can people see in PWA the total amount of hours they have to distribute?
How can I control that the hours they report are compatible with the hours
they have worked?

If people could report daily % Alocation it would be a lot easier, because
all I would have to do was to multiply the % Alocation by the number of total
hours worked. How can this be done?

Thank you very much.
Studer

 

[Rod Gill]

The only way to accurately update a schedule from a timesheet, is if the
timesheet pre-fills itself for that week with all current tasks. If you rely
on users to type task names you'll never do it!

You could provide all users with a printed schedule that shows all tasks and
their Unique ID which they use to identify their tasks. Then use the UID to
find then update the task. This won't handle a PM doing a cut and paste as
this destroys the UID.

Updating by %complete is inaccurate. 50% of a 10h task. Did it take 5h to
become 50% complete, or 4 or 6? is there 5 remaining or 6 or 8 or?

programmatically you can use VBA in Project Professional or PSI in Project
Server 2007 to update projects provided there is identifying data for each
timesheet line for the task and resource.

I have written a number of VBA macros for PMs to update their projects from
timesheet records, so if you want to go that way, email me:
rod.gillATproject-systemsDOTco.nz

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com