| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
system assigns work
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
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. "newbie_010108" wrote: 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
ah ok. so can you help me design this to using access?.. please.... :)
"Joel" wrote: 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. "newbie_010108" wrote: 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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
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! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
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! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
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! |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
system assigns work
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm assigns cell address to Variable | Excel Programming | |||
| Work order system | Excel Discussion (Misc queries) | |||
| Outlook, Excel, Work 2007 locking up *BRAND NEW SYSTEM* | Excel Discussion (Misc queries) | |||
| how do I create a drop down list that assigns certain information | Excel Discussion (Misc queries) | |||
| spreadsheet that assigns vacation based upon seniority/time off a. | Excel Programming | |||
Hybrid Mode
