Completed

Automatic Scheduler

This project was successfully completed by Cherry2711 for $40 USD in 6 days.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Completed In
6 days
Total Bids
28
Project Description

I am looking to create an automatic schedule in a spreadsheet. Attached is an example of already existing schedule (Example) and the new format I would like the schedule in (new format).

In the new format there are 3 tabs. 6 month, 3 month, and Brothers. I need the schedule to follow the format as follows:

Job 1 is only filled by Group 1 and Group 2 names (equal randomness)

Job 2 is only filled by Group 2 and Group 3 names (equal randomness)

Job 3 is only filled by Group 2 and Group 3 names (Group 3 should fill the available spots 90-95% of the time)

Job 4 is only filled by Group 2 and Group 3 names (Group 3 should fill the available spots 80% of the time)

Job 5 is only filled by Group 2 and Group 3 names (Group 3 should fill the available spots 80% of the time)

Job 6 is only filled by Location names (and needs to include the the date format in the cell as shown). This is not random. It should always go in order from Group 1 through Group 6.

All members should be used before any one member gets a second job

I should be able to add and subtract members from any group. Any one group would have no more than 40 members

No one name should have multiple jobs on the same 2 week period and should not have the same job in back to back 2 week periods.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online