- Status Completed
- Budget $30 - $250 USD
- Total Bids 28
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.
Get free quotes for a project like this
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online