Results 1 to 13 of 13

how to let excel plan out work schedule by itself based on conflicting criteria

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2019
    Location
    Singapore
    MS-Off Ver
    2016 EXCEL
    Posts
    14

    how to let excel plan out work schedule by itself based on conflicting criteria

    Hi guys,

    Need some help here. I have a library of recipes which acquire several systems.

    All recipes have a specific number of hours in which they will take when you run them.

    Now I wanted to run multiple recipes together but some of the recipes conflict with each other as they acquire the same systems. Therefore, other recipes can only wait until the systems have been released for acquiring.

    How can I teach excel to plan out a schedule if I pick some recipes out from the library which some of them acquire the same systems.

    Please see attached for the working excel sheet. As I wanted flexibility in choosing my recipes, I have done up a VLOOKUP table for your convenience.

    Hope you can help me!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorting production plan in to schedule my category
    By Bjourne in forum Excel General
    Replies: 1
    Last Post: 02-20-2019, 09:49 AM
  2. Preventive Schedule Automatic Plan Visit
    By dontbugme1 in forum Excel General
    Replies: 2
    Last Post: 03-11-2016, 08:01 PM
  3. Choose possible schedule based on 4 day work week, type of shift, etc.
    By ChristenPoynter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-01-2015, 07:44 PM
  4. [SOLVED] Conflicting dates with certain criteria
    By irmaosver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2014, 01:04 PM
  5. Replies: 1
    Last Post: 09-19-2011, 08:07 PM
  6. Figuring out Availability based upon work/task schedule
    By B. Baumgartner in forum Excel General
    Replies: 0
    Last Post: 05-03-2007, 10:58 AM
  7. schedule plan for every 3 month in one sheet excel
    By jameela in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2006, 07:35 AM

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