Detailed Scheduling Maro for Excel needed

Befejezett Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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

Adatbevitel Adatfeldolgozás Excel Szoftverarchitektúra Visual Basic

Projektazonosító: #15478565

A projektről

22 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

Odaítélve:

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 Továbbiak

$49 USD 2 napon belül
(1 Visszajelzés)
1.6

22 szabadúszó tett átlagosan 120$ összegű árajánlatot erre a munkára

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 Továbbiak

$190 USD 7 napon belül
(149 vélemény)
7.2
sonarkaushik

I can create this macro to cater your requirement

$99 USD 2 napon belül
(112 vélemény)
6.3
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 Továbbiak

$224 USD 3 napon belül
(7 vélemény)
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 Továbbiak

$100 USD 7 napon belül
(38 vélemény)
6.0
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 Továbbiak

$100 USD 2 napon belül
(74 vélemény)
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 Továbbiak

$80 USD 5 napon belül
(125 vélemény)
5.5
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 7 napon belül
(36 vélemény)
5.9
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 Továbbiak

$150 USD 2 napon belül
(37 vélemény)
5.4
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, Továbbiak

$150 USD 2 napon belül
(14 vélemény)
5.2
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 Továbbiak

$83 USD 2 napon belül
(42 vélemény)
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 Továbbiak

$111 USD 7 napon belül
(29 vélemény)
4.4
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 Továbbiak

$122 USD 3 napon belül
(10 vélemény)
3.7
ketas

A proposal has not yet been provided

$250 USD 10 napon belül
(15 vélemény)
3.9
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 Továbbiak

$111 USD 2 napon belül
(1 Visszajelzés)
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 Továbbiak

$166 USD 3 napon belül
(2 vélemény)
2.8
xlbymalix

Excel VBA Expert

$150 USD 3 napon belül
(2 vélemény)
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 Továbbiak

$61 USD 3 napon belül
(0 vélemény)
0.0
chrisdaviessd

Hi, I have worked in IT for over 15 years with math background also, this will be no problem removing this issue for you Thanks Chris

$88 USD 2 napon belül
(0 vélemény)
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 3 napon belül
(0 vélemény)
0.0
Zaroon364

I'm the best candidate you would find and you'll love to hire me again

$30 USD 2 napon belül
(1 Visszajelzés)
0.0