M
Mikeyfyr
I am firefighter who has been given a project that I hoping someone here
can help me with. I have worked with Microsoft Access quite a bit, but
I think Excel is better for this project. I have made an inventory
progam in Access that seems fairly complicated, to me at least. So my
BC was hoping I could put something together for an overtime staffing
list. I do not know VBA. Below is brief summary of what I am trying
to accomplish.
We have 3 separate personnel lists from which to hire overtime when
nessasry, one for each rank of Captain, Operator, and Firefighter.
People are listed in order of when they last accumulated 24 or more
hours of overtime. The most recent person to accumulate 24 hours of
overtime will be the last person on the list. When an overtime coverage
is needed the BC (battalion chief) will go down the list and offer
overtime to people that are available to take overtime. The person
first on the list may be working that day or on annual leave or for
what ever reason can not work that day. So the BC continues down the
list. When he finds a person to accept the overtime, it may be a full
shift, 24 hours, in which case they will go to the bottom of the list
from where ever their current position on the list is. If the overtime
is a partial, say 10 hours, then they will not move from their current
position unless they have previously accumulated 14 hours or more and
therefore putting them over 24 hours. At which point they will be moved
to the bottom of the list. Once you are moved to the bottom all hours
are reset to 0.
This a can be a very lenghthy proccess for the BC. We currenty are
using a card file but mistakes can be made trying to track hours and
positions.
This is an example:
Name "Accrued Hours" "Accepted Hours"
Smith " 0 " " 0"
Johnson "10 " " 0"
Jones " 0 " " 0"
White " 0 " " 0"
When the BC offers someone hours (Accepted Hours), they will be added
to (Accrued Hours). Once Accrued Hours have equal or exceeded 24 that
person will be rotated to the bottom of the list. If Smith accepts a
14 hour overtime he does not move because his Accured hours will then
be 14. If Johnson accepts 14 hours he will move to the bottom of the
list and then his Accured hours will be rest to zero.
I know I am asking an impossible question. If anyone can help I will
really appreciate the assistance. Thanks for your time.
Mike Tonner
Firefighter
Sparks NV
can help me with. I have worked with Microsoft Access quite a bit, but
I think Excel is better for this project. I have made an inventory
progam in Access that seems fairly complicated, to me at least. So my
BC was hoping I could put something together for an overtime staffing
list. I do not know VBA. Below is brief summary of what I am trying
to accomplish.
We have 3 separate personnel lists from which to hire overtime when
nessasry, one for each rank of Captain, Operator, and Firefighter.
People are listed in order of when they last accumulated 24 or more
hours of overtime. The most recent person to accumulate 24 hours of
overtime will be the last person on the list. When an overtime coverage
is needed the BC (battalion chief) will go down the list and offer
overtime to people that are available to take overtime. The person
first on the list may be working that day or on annual leave or for
what ever reason can not work that day. So the BC continues down the
list. When he finds a person to accept the overtime, it may be a full
shift, 24 hours, in which case they will go to the bottom of the list
from where ever their current position on the list is. If the overtime
is a partial, say 10 hours, then they will not move from their current
position unless they have previously accumulated 14 hours or more and
therefore putting them over 24 hours. At which point they will be moved
to the bottom of the list. Once you are moved to the bottom all hours
are reset to 0.
This a can be a very lenghthy proccess for the BC. We currenty are
using a card file but mistakes can be made trying to track hours and
positions.
This is an example:
Name "Accrued Hours" "Accepted Hours"
Smith " 0 " " 0"
Johnson "10 " " 0"
Jones " 0 " " 0"
White " 0 " " 0"
When the BC offers someone hours (Accepted Hours), they will be added
to (Accrued Hours). Once Accrued Hours have equal or exceeded 24 that
person will be rotated to the bottom of the list. If Smith accepts a
14 hour overtime he does not move because his Accured hours will then
be 14. If Johnson accepts 14 hours he will move to the bottom of the
list and then his Accured hours will be rest to zero.
I know I am asking an impossible question. If anyone can help I will
really appreciate the assistance. Thanks for your time.
Mike Tonner
Firefighter
Sparks NV