+ Reply to Thread
Results 1 to 8 of 8

scheduling the Sunday service Please help me

  1. #1
    Registered User
    Join Date
    07-06-2022
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    4

    Post scheduling the Sunday service Please help me

    Capture1.PNG
    We have a Chinese church here, and a friend of mine is responsible for scheduling the Sunday service.
    Each Sunday the church has eight tasks, so priority will be given to preparing four tasks.
    My friend is responsible for scheduling the last four tasks with the vacant staff. It takes a month at a time, and there are four to five Sundays a month. But since the number of people available on each Sunday is different, the number of people available for the last four tasks is also different. However, the church requires that the same person should not take up the same task more than twice in a month. This condition gives me a big headache and I don't know how to arrange Excel.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: scheduling the Sunday service Please help me

    Please attach your actual file. See yellow banner at the top of the page.

    I can't see how this picture relates to your description. I see what may be tasks here (the orange cells) but four, not eight. Do you just do four an ignore the other four? How do you determine the people available for each Sunday? Does it matter which person does which task?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-06-2022
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: scheduling the Sunday service Please help me

    My browser could not allow me to upload the file.
    Please download the file from my google drive.
    docs.google.com/spreadsheets/d/12fKobr3Az-QqpINzcabDYhjc5YYeISo-/edit?usp=sharing&ouid=115429212705750733443&rtpof=true&sd=true
    Currently, I just want to solve the major quest first.
    Thank you very much.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: scheduling the Sunday service Please help me

    I successfully downloaded your file but you didn't answer any of my other questions.

    You have a list of 7 names for each date, and they are all the same. What does that mean?

    How do you determine the people available for each Sunday? Does it matter which person does which task?

  5. #5
    Registered User
    Join Date
    07-06-2022
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: scheduling the Sunday service Please help me

    The name list is not the same for each Sunday, which has slightly different from each other.
    We can arrange the 4 tasks for people available on that Sunday randomly.
    The requirement is that no one person will do the same task more than twice in one month.
    Or, only do the same task for any two Sundays in one month.
    Thank you very much.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: scheduling the Sunday service Please help me

    This would not be considered random unless the names are listed randomly in rows 13:17, however it seems to meet the criteria of not having the same person do that same task twice in a month of 5 weeks.
    1. Populate I13:I17 using: =COUNTA(B13:H13)
    2. Populate J13:M17 using: =MOD(SUM(COLUMNS($J13:J13),ROWS(J$13:J13)-1)-1,$I13)+1
    3. Populate C4:F8 using: =INDEX($B13:$H13,J13)
    Let us know if you have any questions.
    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.

  7. #7
    Registered User
    Join Date
    07-06-2022
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: scheduling the Sunday service Please help me

    Thank you very much.

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: scheduling the Sunday service Please help me

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. [SOLVED] VBA to Insert Vehicle Services per Service Group on the Service Log Sheet
    By BillySpivy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-16-2022, 06:34 AM
  2. Replies: 4
    Last Post: 03-06-2022, 11:37 AM
  3. Need Cumulative Length of Service - Sum of 2 lengths of service
    By mmrsp418 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2020, 10:03 AM
  4. [SOLVED] Compare Price List for Duplicate Service Code & Service Description.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-27-2016, 12:58 PM
  5. Scheduling: Calendar style scheduling based on scheduling list
    By denkatprieto in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 11:10 AM
  6. Replies: 0
    Last Post: 07-20-2006, 12:20 PM
  7. Need formula to tie cost of service to service code
    By mkrebs in forum Excel General
    Replies: 1
    Last Post: 03-23-2005, 01:53 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