Completed

Detailed Scheduling Maro for Excel needed

I have a daycare center that offers the parents the ability to enter there weekly work schedule each week so thus it changes each week according to there needs. The issue arises when I have a put a schedule together that works for the students, teachers, and ratio throughout the day each day each week.

I have the set information which is :

kids schedule, teachers available to work, ratio of teachers to kids, 30 min increaments

What I need is someone to put together a "simple" :) program or macro that can take my inputs from above and come up with a detailed weekly schedule with 30 minute increments

there are six rooms (see below) so if it has to be on 6 sheets (or a drop down selector for rooms would be nicer)

I have a weekly time schedule broken down into 30 min increments 5 am to 9 pm

I have a set number of teachers (lets say I have 15 that can be put in the schedule)

I have a set number of kids that will show up each week (lets say I have 85 kids scheduled)

I have a Ratio of Teachers to Kids that I must maintain throughout the day

I have a Fours Room where the ratio is 1 teacher to 12 kids

I have a Threes Room where the ratio is 1 teacher to 8 kids

I have a Twos Room where the ratio is 1 teacher to 6 kids

I have a Toddlers Room where the ratio is 1 teacher to 4 kids

I have a Mobiles/Infants Room where the ratio is 1 teacher to 4 kids

I have a School Crew Room where the ratio is 1 teacher to 15 kids

Skills: Data Entry, Data Processing, Excel, Software Architecture, Visual Basic

See more: production scheduling template, master production schedule template excel, production planning chart in excel, manufacturing production schedule, how to set up a production schedule in excel, manufacturing capacity planning excel, production planning excel template, production planning and control excel template, writer needed to create content on the italian language will work part time with a flexible schedule freelance remote job, resource scheduling using excel, creative logo daycare center, daycare center logo, logo daycare center, example detailed data entry excel, job scheduling problem excel, suggested attractive banners daycare center, scheduling fixtures excel spreadsheet, freelance excel needed, excel charts quality call center, soccer game scheduling spreadsheet excel

About the Employer:
( 24 reviews ) SHELDON, United States

Project ID: #15478565

Awarded to:

ishamg

Room, teacher and student allocation macro. Needs to take into account age of children and room availability for allocation to rooms. Need to take into account teacher availability for allocation. Relevant Skills an More

$49 USD in 2 days
(1 Review)
1.6

23 freelancers are bidding on average $126 for this job

someka

Hi there. I can write you a macro which will take your schedule plan variables and convert it into 6 different weekly schedule. What about the roundings for teacher-kid match? Round down? Relevant Skills and Experie More

$190 USD in 7 days
(149 Reviews)
7.1
AndrejStastny

Hello, I am good at VB6, VBA for Excel. Relevant Skills and Experience VBA Proposed Milestones $250 USD - All

$250 USD in 5 days
(40 Reviews)
5.7
dynamitewebsol

Hello, I read your requirements very-well and i i have 7 years working experience with spreadsheet excel. I Hope you will give me a chance to do work with you. Thank you Relevant Skills and Experience I have 7 year More

$100 USD in 7 days
(32 Reviews)
5.8
sonarkaushik

I can create this macro to cater your requirement

$99 USD in 2 days
(111 Reviews)
6.3
zu02

Hi, I can code that via Excel or Access. Relevant Skills and Experience ms Access/Excel/VB programmer since Ms Office 97 released Proposed Milestones $250 USD - default

$250 USD in 7 days
(35 Reviews)
5.9
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective .manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experien More

$30 USD in 1 day
(83 Reviews)
5.5
beltran0404

Hello, I am Luis, it will be my pleasure to help you with this project. I can help you creating your detailed schedule with excel. Please contact me by chat and then we could discuss better your project! Kind regar More

$80 USD in 5 days
(93 Reviews)
5.1
whitehorsetechn

Greeting, I have understood your excel Macro task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Data Entry, More

$150 USD in 2 days
(14 Reviews)
5.3
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $10 More

$100 USD in 2 days
(71 Reviews)
5.4
technoweb7

Greetings, We have found this project match well with our skill & expertise level. Relevant Skills and Experience We are a team of 35 developers & 20 designers and each having more than 8 years experience in Website D More

$224 USD in 3 days
(3 Reviews)
4.8
awaisjahangir25

I've done number of projects relating to Visual Basic and Excel Macros. I can work on your project. Relevant Skills and Experience MS Excel, Visual Basic, Data Entry, Data Processing Proposed Milestones $150 USD - Up More

$150 USD in 2 days
(35 Reviews)
5.3
nurnga1218

Hi... Waawww... looks like a complicated but I like a really clearly long brief. I need the document you already have so maybe I can make a kind of a concept. Relevant Skills and Experience I did many excel macro proj More

$83 USD in 2 days
(41 Reviews)
4.5
nelumindralal

HI, This job is pretty interesting but I read few times, still not clear about it. Maybe if you can explain more I can help you to solve that I am looking forward to hearing from you thanks thushara Relevant Skills a More

$111 USD in 7 days
(24 Reviews)
4.2
ketas

A proposal has not yet been provided

$250 USD in 10 days
(14 Reviews)
3.8
ABGondal1

I can do this project as described. please review my profile for more details. Relevant Skills and Experience Data Entry, Data Processing, Excel, Software Architecture, Visual Basic Proposed Milestones $122 USD - A More

$122 USD in 3 days
(10 Reviews)
3.7
tom19468

I will modify my existing MS Excel VBA scripts to create a daycare center scheduler based on parent's weekly work schedule, kids schedule, teachers available, ratio of teachers/kids, 30 min inc. Relevant Skills and More

$111 USD in 2 days
(1 Review)
3.4
madenkhan

I am new on Freelance, but I have seven years of work experience in Data modeling, Data analysis, and workforce management. My area of expertise lies in following fields: 1. Real-time Data visualization on dashboard More

$166 USD in 3 days
(2 Reviews)
2.8
xlbymalix

Excel VBA Expert

$150 USD in 3 days
(2 Reviews)
0.8
jemeeja

Hi I am interested to your project. I saw your project and read its details. I am fully expert this job. I can do it. So i waiting for your responding. thanks. Relevant Skills and Experience Data Entry, Data Processin More

$61 USD in 3 days
(0 Reviews)
0.0
giorgigaluashvil

I will be glad to help. No impossible targets are in your requests. Relevant Skills and Experience I make such things every day. Stay tuned, I'm still working on this proposal.

$55 USD in 3 days
(0 Reviews)
0.0