D
Dr. Compynei
Hi All,
I don't work with Excel all that often, and its been some time since it was
involved in my Computing A-Level!
The scenario for the problem I have is this:
I work in the theme park industry, in the Rides Management Team. The system
for training a ride operator is somewhat over complicated, and we are hoping
to move across to excel to help us better manage our team of around 80
staff.
When an operator is trained on a ride, they are listed on a competent
operator form twice, by hand, one kept on the ride, one kept in the office.
This contains the following information: Ride, Operator column for the name
to be listed, date trained and who they were trained by.
The date trained is then added to a spreadsheet in Excel, basically so we
can keep an eye on where staff are trained, and where we can best place
staff each operational day. Other aspects of the training process obviously
come in, such as ride training acknowledgements and operator assesments,
however these are kept outside of this system.
Basically, what I am trying to create is the following:
An excel workbook, which has a table of staff names running down one side,
and then ride names running across the top, thus allowing dates to be
inserted for various rides.
I then want a sheet for each ride, which will be a competent operator form.
So for example, Ride A will have its own sheet, we will pick staff names
from a dropdown box, enter the date they were trained and who by. This will
then cross reference into the matrix sheet, which will show the date they
were trained, in the correct ride column, by their name.
The problems I'm having at the moment is:
- Getting staffs names into a dropdown box
- Finding a formula that will look up when someone has been added, and place
the date.
I realise this is alot of info, and is probably quite hard to understand
unless you know the training model of the park, I am happy to post my work
if this helps anyone. I also do realise that this would probably be more
suited to excel, but due to the varying IT skills in the department of
employees, and all of them knowing excel (well, working with it), this seems
the only solution to us keeping better records, with less hassle.
Many thanks.
I don't work with Excel all that often, and its been some time since it was
involved in my Computing A-Level!
The scenario for the problem I have is this:
I work in the theme park industry, in the Rides Management Team. The system
for training a ride operator is somewhat over complicated, and we are hoping
to move across to excel to help us better manage our team of around 80
staff.
When an operator is trained on a ride, they are listed on a competent
operator form twice, by hand, one kept on the ride, one kept in the office.
This contains the following information: Ride, Operator column for the name
to be listed, date trained and who they were trained by.
The date trained is then added to a spreadsheet in Excel, basically so we
can keep an eye on where staff are trained, and where we can best place
staff each operational day. Other aspects of the training process obviously
come in, such as ride training acknowledgements and operator assesments,
however these are kept outside of this system.
Basically, what I am trying to create is the following:
An excel workbook, which has a table of staff names running down one side,
and then ride names running across the top, thus allowing dates to be
inserted for various rides.
I then want a sheet for each ride, which will be a competent operator form.
So for example, Ride A will have its own sheet, we will pick staff names
from a dropdown box, enter the date they were trained and who by. This will
then cross reference into the matrix sheet, which will show the date they
were trained, in the correct ride column, by their name.
The problems I'm having at the moment is:
- Getting staffs names into a dropdown box
- Finding a formula that will look up when someone has been added, and place
the date.
I realise this is alot of info, and is probably quite hard to understand
unless you know the training model of the park, I am happy to post my work
if this helps anyone. I also do realise that this would probably be more
suited to excel, but due to the varying IT skills in the department of
employees, and all of them knowing excel (well, working with it), this seems
the only solution to us keeping better records, with less hassle.
Many thanks.