-
Hi xld,
As a first draft this looks really good.
In answer to your query, the contingent staff worksheet is a total list of all contingent staff whose status is active (i.e. working now) the Timesheet Detail worksheet shows all timesheets submitted. The Timesheet detail sheet will have multiple rows per user ID as each row reporesents one days timesheet. I will add a column ("Y") in Timesheet Detail which will show the wedate for each timesheet submitted (attached updated spreadsheet).
The idea of the report is to identify every Contingent Staff and calculate which timesheets should be present based on the contingent staff start and end date (Contingent Staff worksheet) Then cross reference this with the Timesheet Detail worksheet and only show One reference per contingent satff (user ID) with all instances of missing timesheets by wedate (perhaps in a pivot table format). The trick I guess is getting the script to only look for submiytted timesheets up the last week ending date based on the date you run the report (i.e. if I run it on Monday next week - 28 April 2008 - the script should only show timesheets missing up to week ending 27 April 2008)
I hope this helps you.
I have run the script you provided and it looks good.
Your help is greatly appreciated.
Thanks a Lot |
|
Marshybid
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules