| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
On-Call schedule
We have an on-call schedule for support calls and for each day there is a
separate primary, backup, supervisor, and manager responsible for that day. Date 4/2/2006 4/3/2006 4/4/2006 4/5/2006 Primary Joe Smith Backup Tom Jones Joe Smith Supervisor Manager Each function (primary, backup, supervisor, and manager) has a different hourly rate and there are about 10 different people handling these functions during each two-week period. Right now, we manually key in the daily rate for each of these employee into a spreadsheet after looking up what function they had on each of the days Joe Smith Tom Jones John Tee Greg Miller Jane Walker 04/02/06 60.00 60.00 04/03/06 80.00 04/04/06 60.00 04/05/06 04/06/06 04/07/06 04/08/06 04/09/06 What would be the best way to set this up - vlookups didn't seem to do the job (too many conditions). I'd really appreciate any help on this. Thanks Sabine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| amortization schedule calc without interest rate known | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
| Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
| Where can I find a template for a perpetual shift schedule. | Excel Discussion (Misc queries) | |||
Threaded Mode
