Logic methods in excel?

**skreech** · 03-22-2011, 04:06 AM

Hi,
I'm new to excel, but i've been working with java for a long time, therefore my logic is built with java in mind, i cant seem to find functions that will solve my problems. please help me do this, I've reached a wall, and do not know how to proceed.

Simple summary of the model,
1. Doctors have core and secondary competencies, and shifts.
2. Patients have illnesses(which is correspondent to doctors competencies), the time they walk in, (also categorized in shifts)
3. Core competencies are faster to do than secondary

So i need to effectively plot a "most optimized" way where doctors can treat the patients

The logic is-
a. Look at the the patients illness,
b. find the doctor with the core competency which corresponds with the patients illness
c. if doctor with core competency do not correspond, look at secondary competency
d. check whether doctor is free, if free- assign, else find next doctor
e. once doctor is assigned, find the amount of time needed (in another table)
f. book the doctor in the table

I know it sounds complicated, but look at the table attached, it would seem so much easier

click right here: http://www.excelforum.com/attachment...1&d=1300781256

**Fidd$** · 03-24-2011, 12:46 PM

Hi there Skreech. Just a few questions regarding this.
At which points are there going to be user input in the table? (and I'm assuming there is, as you need a trigger for any logic statements to kick in)
You have listed the order in which the 'plotting' of the outcome should proceed but not where a user has to make a decision.

Just makes it a bit easier for me to figure a way to solve what you're trying to achieve.

Cheers,
Tony

**Fidd$** · 03-24-2011, 01:00 PM

I'm thinking you are better with the tables on another sheet and have one 'input' sheet which will give you the results.
Effectively like a database, with a front end and a back end.

Apologies Skreech, I thought this one was going to be easy until I re-read your outline of the logic you wanted to be incorporated. Taking longer than I thought and I'm also learning too!

Get back to you when I get something working.

Cheers,
Tony