J
jdamron
eve_date Date sktype psi_qy
09-Jun-06 6/9/06 SET UP LEAD 1
09-Jun-06 6/9/06 SET UP ASSISTANT 1
09-Jun-06 6/9/06 SET UP LEAD 1
09-Jun-06 6/9/06 SET UP ASSISTANT 1
10-Jun-06 6/10/06 EVENT DIRECTOR 1
10-Jun-06 6/10/06 SET UP SPECIALIST 1
10-Jun-06 6/10/06 SET UP LEAD 2
10-Jun-06 6/10/06 SET UP ASSISTANT 2
10-Jun-06 6/10/06 FLORAL DESIGNER 4
10-Jun-06 6/10/06 ART DESIGNER 1
10-Jun-06 6/10/06 FLORAL ASSISTANT 2
10-Jun-06 6/10/06 STRIKE LEAD 1
10-Jun-06 6/10/06 STRIKE ASSISTANT 3
10-Jun-06 6/10/06 EVENT DIRECTOR 1
10-Jun-06 6/10/06 ART DESIGNER 2
10-Jun-06 6/10/06 FLORAL ASSISTANT 2
Then I need to have a spreadsheet that telle many how many of the different
types of employees are working on a given day. Like this:
6/9/2006 6/10/2006 6/11/2006 6/12/2006 6/13/2006 6/14/2006
Event Director #NAME?
Art Designer #NAME?
Floral Designer #NAME?
Floral Assistant #NAME?
Set Up Personnel #NAME?
Strike Personnel #NAME?
Under each date column, I want it to tell me how many Event Directors are
sheduled etc. Thanks!!
09-Jun-06 6/9/06 SET UP LEAD 1
09-Jun-06 6/9/06 SET UP ASSISTANT 1
09-Jun-06 6/9/06 SET UP LEAD 1
09-Jun-06 6/9/06 SET UP ASSISTANT 1
10-Jun-06 6/10/06 EVENT DIRECTOR 1
10-Jun-06 6/10/06 SET UP SPECIALIST 1
10-Jun-06 6/10/06 SET UP LEAD 2
10-Jun-06 6/10/06 SET UP ASSISTANT 2
10-Jun-06 6/10/06 FLORAL DESIGNER 4
10-Jun-06 6/10/06 ART DESIGNER 1
10-Jun-06 6/10/06 FLORAL ASSISTANT 2
10-Jun-06 6/10/06 STRIKE LEAD 1
10-Jun-06 6/10/06 STRIKE ASSISTANT 3
10-Jun-06 6/10/06 EVENT DIRECTOR 1
10-Jun-06 6/10/06 ART DESIGNER 2
10-Jun-06 6/10/06 FLORAL ASSISTANT 2
Then I need to have a spreadsheet that telle many how many of the different
types of employees are working on a given day. Like this:
6/9/2006 6/10/2006 6/11/2006 6/12/2006 6/13/2006 6/14/2006
Event Director #NAME?
Art Designer #NAME?
Floral Designer #NAME?
Floral Assistant #NAME?
Set Up Personnel #NAME?
Strike Personnel #NAME?
Under each date column, I want it to tell me how many Event Directors are
sheduled etc. Thanks!!