Automatic Scheduler

En curso Publicado hace 7 años Pagado a la entrega
En curso 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.

Entrada de datos Procesamiento de datos Excel

Nº del proyecto: #11819027

Sobre el proyecto

21 propuestas Proyecto remoto Activo hace 7 años

21 freelancers están ofertando un promedio de $117 por este trabajo

jaylancer43

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

$200 USD en 3 días
(901 comentarios)
9.4
schoudhary1553

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

$100 USD en 2 días
(568 comentarios)
8.5
cugamelover

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

$160 USD en 3 días
(203 comentarios)
7.3
beltran0404

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

$70 USD en 4 días
(177 comentarios)
6.1
MoohHHooM

Hi, i am ready for this project, please let me know more about your requirements. Más

$80 USD en 1 día
(26 comentarios)
5.3
ChinmoySarker

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

$100 USD en 3 días
(30 comentarios)
4.8
aticul

Hi, I can take 100% confidently your project. I can give high quality service from others. I am expert about it. You can see my full profile and feedback to check the experience. I available online any time. We will se Más

$35 USD en 3 días
(26 comentarios)
4.4
akbar333

I am BS in Computer Science,easily manage and work with computer. I work as a freelancer from more than 2 years as a word, excel, power point, copy/paste and many more. being an computer graduate I can handle difficul Más

$111 USD en 3 días
(2 comentarios)
2.6
maklo

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.

$111 USD en 5 días
(0 comentarios)
0.0
Tpamudi

Hi, I have good knowledge regarding computer literacy including Ms Excel, Ms Word, Power Point etc. Since I have been working as a course coordinator I have good practice in data entry. I hope that I have the rig Más

$150 USD en 3 días
(0 comentarios)
0.0
muhammadhuzefa1

Hi, I would like to take your project you may check my portofolio

$45 USD en 5 días
(0 comentarios)
0.0
akshaypiyush

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.

$50 USD en 2 días
(0 comentarios)
0.0
praful001

I will give you best work as par your requirements sir .

$112 USD en 2 días
(0 comentarios)
0.0
kaomotsisi

A proposal has not yet been provided

$133 USD en 2 días
(0 comentarios)
0.0
Meyluphicious

Please give me a project. I'll do it earnestly and get it done quickly. I will not disappoint you.

$111 USD en 3 días
(0 comentarios)
0.0
vivalmorbee

Hi, I create dynamic automated excel template for reporting purposes. Hope to hear fro you for further discussion. Regards, Hazel

$100 USD en 3 días
(0 comentarios)
0.0