to me anyway, your original mail isn't very clear.
Would be best if you rephrase the question - and feel free to send me your
excel workbook
"newbie_010108" wrote in message
...
not yet... :(
"Patrick Molloy" wrote:
i see, thanks.
Has your problem been resolved now?
"newbie_010108" wrote in message
...
hi Patrick,
this is different. The previous one is the system will pre-assigned the
workload to the analysts but this one the system will not assigned
workload
to the analysts unless he completed the bid that was assigned to him
and
also
the system will not assigned a work to an analysts if he is not working
on
that state.
"Patrick Molloy" wrote:
do a search on analysts - I've already answered this almost exact
question
....
http://www.xl-expert.com/analysts.htm
about June 8th
"newbie_010108" wrote in
message
...
Hi, Im doing a project which will assign work to analysts. We were
working
in a shared file excel 2003. The process would be once the analysts
hit
the
button €śget work€ť the next available BID that was not yet assigned
to
anyone
will be assigned to her and the system should not assign that BID to
anyone.
There are state that can only be work on by specific. This is the
inventory
file:
State BID # of provs Analysts Status #of analyzed item Loader
Status
#of loaded item
CA 1 4
MD 2 5
TX 3 6
List of analysts:
Josan -
Mel €“ should not assign BID which is in CA
Leo
Edison €“ Should not assign BID which is in CA
List of loaders:
Ferdy
Cha
Kathy €“ should not assign BID which is in CA
There should be a button €śGet Work€ť, if this is click by Mel, since
the
first available BID is in the CA state this should not be assign to
her,
the
system will give her the BID 2 instead, the system will prompt a
message
box
€śPlease work on BID 2€ť. The system will then populate the name €śMel€ť
in
the
analysts column. Only the system is allowed to update the €śAnalysts€ť
column.
The system will not give another BID to Mel unless the BID 2 that
was
assigned to her has a status and # of analyzed item column is
populated.
The
system will not allow the analyzer to input # in the €ś# of analyzed
item€ť
which is greater than the €ś# of provs€ť. If the 2 columns is
populated
then
if
she click on €śGet Work€ť again the system will assign to her the next
available BID but if its not then the system will prompt €śPlease
complete
the
BID 2 and populate Status and # of analyzed item column€ť. For the
loaders
work assignment. There should be a button €śGet analyzed item€ť, this
will
be
click by the Loaders same algorithm for analyzers the difference is
only
the
BIDs which has a status of analyzed will be assigned to them loaders
should
also need to populate the status and # of loaded item. # of loaded
item
should only equal to or less than # of analyzed item. Like for the
analyzer,
if the next €śanalyzed BID€ť is CA and the loader who clicks the
button
is
Kathy, the system will get the next analyzed BID which is not CA.
The
system
should work FIFO.
Please feel free to shoot me email if you have questions:
Really need this project completed.... thanks a lot!