Rank and Cell colour
 

I've posted this message before but I don't think I explained it
properly.

I have a worksheet called Schedule that looks like:

Dr.A Dr.B Dr.C
Total Wkld 100 100 100
Avail.Wkld
Rank Weight AmtLeft
Prgm A 2 100
Prgm B 1 100
Prgm C 3 100
Prgm D 4 100

AmtLeft and Avail. Wkld gets populated as the user inputs data.

Now, I will have a button that will 'SUGGEST' the next program that the
user should work on. This suggestion is based on the rank. Obviously,
the first program suggested is the one that has Rank 1 and will
distribute the weight among the avaiable doctors (i.e in this case it
will be Prgm B (i.e. Rank 1) that has weight 100 divided by 3 (i.e 3
doctors)). The user can have the option to overwrite what was suggested.
At the same time, AmtLeft and Avail. Wkld is decreasing.

If the AmtLeft < 0 OR Avail. Wkld < 0, the cell is coloured red and the
user should NOT be able to 'SUGGEST' the next rank. Perhaps I can have
some msgbox indicated that we cannot have negative values.

If the AmtLeft = 0, then if they press the 'SUGGEST' button, the program
should then know to suggest the program with the highest rank (i.e in
this case, it will be Prgm A (i.e Rank 2) and the weight of that program
will be divided by 3).

BUT if the user is not satisfied with what was suggested then, he can
input data wherever he wants. So, let's say he has chosen to input data
in Prgm C that has rank 3, the next time he decided to 'SUGGEST' data,
the program should know to go back to Prgm A which is still the highest
rank.

I hope this makes sense,

Audrey

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!