+ Reply to Thread
Results 1 to 2 of 2

Team Roster Creation

  1. #1
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Team Roster Creation

    Hi
    I am struggling with a solution to create a Team Roster in Excel which gives each member of each team an equal share of time in each of the other two teams. If anyone can help it would be really appreciated.
    I attach a sample of where I have failed so far.
    Thanks in advance.
    Tony
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,856

    Re: Team Roster Creation

    According the the table the claims dept. will be triple staffed every day, whereas there won't be anyone assigned to the customer service dept on days 3 and 4.No one seems to be assigned to the sales dept. on days 1, 2 and 5. Seems as if the assignments would have persons assigned to their own departments first and then, on their off days, work in other departments, as shown on sheet2. Also would Cl1 always work in the claims dept. on days 1, 3 and 5 or is there a rotation such that Cl1 works days 2 and 4 the next week? If the latter then it would seem as if a 10 day rotation is needed.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-06-2021, 01:10 AM
  2. Replies: 5
    Last Post: 11-25-2015, 01:34 AM
  3. Excel 2007 Invoice Roster Creation
    By Chelle2311 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2015, 03:21 PM
  4. Replies: 2
    Last Post: 12-06-2012, 06:02 PM
  5. [SOLVED] Dependent Data Validation - Team Roster
    By ktwainscott in forum Excel General
    Replies: 7
    Last Post: 06-24-2012, 01:42 AM
  6. Rotating sport team roster
    By h0mbre in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-30-2012, 03:25 AM
  7. Populate a calendar using team roster data in excel
    By Patrick56 in forum Excel General
    Replies: 0
    Last Post: 06-10-2010, 10:29 PM

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