Automatic Scheduler
$30-250 USD
Pagado a la entrega
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.
Nº del proyecto: #11819027
Sobre el proyecto
21 freelancers están ofertando un promedio de $117 por este trabajo
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Más
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, Más
Hello, It will be my pleasure to assist you in your project. I know how do you want to accomplish and your rules to do this automatic scheduler. I'm oil scheduler in Venezuela, I know excel and visual basic, neccesa Más
Hi, Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. S Más
Hi! I am a new freelancer here eager to work with you. I am trying to build my reputation and sincerely want to give quality product for your task. Looking forward on working with you. Thanks in advance.
I have a lot of experience in working with excel and spreadsheets so this makes me perfect for this job. Rally looking forward to working with you. Thank You.
Please give me a project. I'll do it earnestly and get it done quickly. I will not disappoint you.
Hi, I create dynamic automated excel template for reporting purposes. Hope to hear fro you for further discussion. Regards, Hazel