Results 1 to 3 of 3

Logic methods in excel?

Threaded View

skreech Logic methods in excel? 03-22-2011, 04:06 AM
Fidd$ Re: Logic methods in excel? 03-24-2011, 12:46 PM
Fidd$ Re: Logic methods in excel? 03-24-2011, 01:00 PM
  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    Logic methods in excel?

    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
    Attached Files Attached Files
    Last edited by skreech; 03-22-2011 at 05:22 AM. Reason: Creating a function method that fits this?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1