system assigns work

N

newbie_010108

Hi, I’m 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:
(e-mail address removed)

Really need this project completed.... thanks a lot!
 
J

Joel

The task assignments really shouldn't be performed in a shared file in excel.
It should be stored in an access database. The excel workbook can contain a
query to the access database to display the assignments.

Excel in not designed to handle conflicts that can occur in a sha4rred
workbook. Access is designed to handle an application were multiple people
are writing data.
 
N

newbie_010108

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.
 
P

Patrick Molloy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert text to numeric values 8
auto assign project 9
alert for shared calendar 2
The controls Visual Studio doesn't want you to see 1
cells to behave like check boxes 4
Msgbox preventing workbook save 2
WriteLine function 2
Table/Query Design 1

Top