Databases
StackOverflow2013
Postsdbo
POApproach to solve delimited scheduling
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POApproach to solve delimited scheduling
    primarykey
    data
    text
    <p>I'm facing a problem and Im having problems to decide/figure-out an approach to solve it. The problem is the following:</p> <blockquote> <p>Given N phone calls to be made, schedule in a way that the maximum of them be made.</p> </blockquote> <p>Know Info: <li>Number of phone calls pending</li> <li>Number callers (people who will talk on the phone)</li> <li>Type of phone call (Reminder, billing, negotiation, etc...)</li> <li>Estimate duration of phone call type (reminder:1min, billing:3min, negotiation:15min, etc...)</li> <li>Number of phone calls pending</li> <li>Ideal date for a given call</li> <li>"Minimum" date of the a given call (can't happen before...)</li> <li>"Maximum" date of the a given call (can't happen after...)</li> <li>A day only have 8 hours</li></p> <p>Rules: <li>Phone calls cannot be made before the "Minimum" or after the "Maximum" date</li> <li>Reminder call placed award 1 point, reminder call missed -2 points</li> <li>Billing call placed award 6 points, billing call missed -9 points</li> <li>Negotiation call placed award 20 points, Negotiation call missed -25 points</li> <li>A phone calls to John must be placed by the first person to ever call him. Notice that it does not HAVE TO, but, that call will earn extra points if you do...</li></p> <p>I know a little about A.I. and I can recognize this a problem that fits the class, but i just dont know which approach to take... should i use neural networks? Graph search?</p> <p>PS: this is not a academic question. This a real world problem that im facing.<br> PS2: Pointing system is still being created... the points here sampled are not the real ones...<br> PS3: The resulting algol can be executed several times (batch job style) or it can be resolved online depending on the performance...<br> <strong>PS4</strong>: My contract states that I will charge the client based on: (amount of calls I place) + (ratio * the duration of the call), but theres a clause about quality of service, and only placing reminders calls is not good for me, because even when reminded, people still forget to attend their appointments... which reduces the "quality" of the service I provide... i dont know yet the exact numbers</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLeonardo
    1. USLeonardo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POApproach to solve delimited scheduling
      1. USRay K
      1. VTFavorite
    2. VO
      singulars
      1. POApproach to solve delimited scheduling
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POApproach to solve delimited scheduling
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO"Extra points if you do" - is this homework?
      singulars
      1. POApproach to solve delimited scheduling
      1. USSam Axe
    2. CO@Dan-o no its not! (read last line) it's just a remark...
      singulars
      1. POApproach to solve delimited scheduling
      1. USLeonardo
    3. COAh. I commented before reading to the end. I am working on patience. :)
      singulars
      1. POApproach to solve delimited scheduling
      1. USSam Axe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload