+ Reply to Thread
Results 1 to 1 of 1

Help with Solver function

  1. #1
    Registered User
    Join Date
    07-31-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Help with Solver function

    Hi,
    I am using 2007 version.
    I am trying to calculate the correct shift schedule based on the efforts for that time.
    I have enclosed the xls sheet where I have already calculated the followings
    A. Column D contains the efforts for the time mentioned in column A ( this is for the month of Feb
    B. Column F contains the required number of staff for that 30 min. For example between 00:00 to 00:30 , I need the 0.69 FTE ( Staff) to process the data

    Now I want to use Solver function ( if there are better ways, I am open to suggestions) which will help me to give the optimal shift pattern.

    Can you please help me with this? I have enclosed the sample xls.

    Regards, Sanjiv
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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