Automatic Scheduler

Closed

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.

Skills: Data Entry, Data Processing, Excel

See more: excel vba find date active cell, cell ping find cell location, iphone profile cell location, android cell location, ping cell location, sqlite cell location, cell location device, nokia e63 cell location, cell location display, display cell location e63, iphone gps find cell location, excel csv automatic change field date, cell location j2me, cell location info, cell location latitude longitude, cell location macros excel 2003, excel macro saves next cell textbox, work excel file, contract work excel, excel macro moving data cell cell, excel code paste cut cell csv, online contract work excel, excel system created date, data entry work excel, excel macro copy selected cell data cell

Project ID: #11819027

Awarded to:

Cherry2711

I have been working with excel for more than 10 years but new as a freelancer. I can do this job for you with a very competitive price. Please award this job to me, you would not regret. Thanks.

$40 USD in 6 days
(0 Reviews)
0.0

26 freelancers are bidding on average $124 for this job

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 More

$200 USD in 3 days
(350 Reviews)
7.6
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, More

$160 USD in 3 days
(140 Reviews)
6.8
wsh2

Greetings Bob from Easton PA, USA.. {smile} Highly experienced (25+ years) MsExcel Business System, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exchange.com and www More

$155 USD in 3 days
(28 Reviews)
5.8
$150 USD in 4 days
(125 Reviews)
5.6
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 More

$100 USD in 2 days
(53 Reviews)
5.1
MoohHHooM

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

$80 USD in 1 day
(7 Reviews)
4.3
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 More

$35 USD in 3 days
(25 Reviews)
4.4
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 More

$70 USD in 4 days
(28 Reviews)
4.2
jssinfosys

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens More

$88 USD in 3 days
(2 Reviews)
2.2
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 More

$111 USD in 3 days
(2 Reviews)
2.3
$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 4 days
(0 Reviews)
0.0
faddy81

I have 7 years of working experience as a Sales Administrative Assistant and Senior Business Support Executive. I am proficient in all Microsoft Office programs, also familiar with the internet and all its applications More

$155 USD in 3 days
(0 Reviews)
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 in 3 days
(0 Reviews)
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 in 3 days
(0 Reviews)
0.0
kaomotsisi

A proposal has not yet been provided

$133 USD in 2 days
(0 Reviews)
0.0
praful001

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

$112 USD in 2 days
(0 Reviews)
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 More

$150 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$200 USD in 7 days
(0 Reviews)
0.0