Reporting on Timesheets

T

Tara Mattison

What is the most efficient method for me to report on who
has and has not submitted time in a given day or week? I
have 9 team members and about 50 projects in
various "stages" so looking at some of the default views
in PSWA is not helpful in determining quickly who has and
has not submitted time.
 
G

Gary Chefetz [MVP]

Tara:

In Project Web Access, select the Resource Center, and then click the link
on the activities menu: View Resource Assignments. This view is like looking
into the collective timesheets of all your resources. Apply grouping and
filtering to suit your needs.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
G

Gary Chefetz [MVP]

Tara:

The Subitted On field is also quite useful.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
G

Greg Horodeck

There was a post that I saved which we have started using that might be
quite helpful as well;



To solve the problem is accounting for unsubmitted Actual Work in PWA, I
have created a special PWA Assignment view called "_Actuals Not Yet
Submitted" to report this information. This special View is defined as
follows in PWA:

View Type -- Assignment

Name -- _Actuals Not Yet Submitted

Fields -- Task Name, Status, Submitted On, Start, Finish

Gantt Chart Format -- Personal Gantt (Tasks)

Grouping Format -- Timesheet or Views (I actually created my own custom
grouping format for this View) Categories -- My Organization, My Projects

This View can be applied by an executive or project manager by doing the

following:

1. Log into PWA

2. Click the Resources menu

3. Click the "View resource assignments" link in the sidepane

4. Click the "Timesheet format" link at the top of the sidepane

5. Click the new View from the "Choose a view" drop-down list in the upper
right corner

6. Click the View, Group, Search tab

7. Set the Group By field to "Status"

8. Set the first Then By field to "Resource"

9. Set the second Then By field to "Project"

10. Click the Filter, Group, Search tab again

11. Roll up the "No change since last update" occurrences (click the minus
sign in front of the words)

All updates that have been saved and not yet submitted to the project
manager will be shown in the second grouping, which is the "Changes not yet
submitted" group. The Actual Work hours that have not yet been submitted are
visible in the timesheet portion of this view. Hope this helps.

--

Dale A. Howard

Project Management Trainer/Consultant

Denver, CO







Tara:

The Subitted On field is also quite useful.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 

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