Lukket

Shift Rotation Generator

I am looking for someone to create a worksheet that has a few macros or functions for me to identify some parameters and then generate a "shift rotation" to assign employees to various fire vehicles.

I would need to be able to define the following:

- number of days in a work week (in my case 5)

- number and type of vehicles (ladder, engine, rescue, etc.)

- type of people on each vehicle type (driver, officer, firefighter)

- Any special certifications required on a vehicle (i.e. medic, which could be a certification held by any type of person)

- number and type of people available.

- preference for rotating people (more often or less often)

The goal would be to fill in the above information, then generate a rotation that would display a work week broken into individual days. For each day it would show each vehicle and who was assigned to each vehicle. There are two goals. First, to ensure each vehicle is staffed with the required type and number of people. Second, that people get a "fair" rotation on the vehicles. "Fair" means trying to get the number of days on each vehicle to even out as much as possible over time.

I would like to be able to define the variables, because at a specific station there may be a different number of vehicles than at another station. Also, different vehicle types have different requirements for the number and type of people required.

Evner: C++ Programmering, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: looking company contact information email address companies pakistan, looking special chars editor, looking 400 per hour outsourcing person, monthly employee shift schedule template, 8 hour rotating shift schedules examples, 12 hour rotating shift schedule template, 8 hour shift schedules for 5 days a week, 24 7 shift schedule template, 4 on 4 off shift pattern template, shift rotation calculator, 3 person schedule rotation, enter pedigree generator information, grap information requirements, rapidshare megaupload premium link generator requirements, shift schedule generator, shift table generator, business requirements analyst special learning, looking to recruit a sales person in guangzhou, im looking to hire a sales person, looking for data entry job from mobile anything for me out there

Om arbejdsgiveren:
( 0 bedømmelser ) Las Vegas, United States

Projekt ID: #18561560

15 freelancere byder i gennemsnit $171 på dette job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Flere

$250 USD in 3 dage
(667 bedømmelser)
8.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

$160 USD in 3 dage
(327 bedømmelser)
7.8
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have a shift generator application in Excel. I plan to use a combination of formulas Flere

$150 USD in 3 dage
(188 bedømmelser)
7.0
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Flere

$155 USD in 3 dage
(48 bedømmelser)
6.7
SShtv

Hi, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a lot of experience in Excel, including the problem of automatic generation of schedules. These are screenshots of some Flere

$150 USD in 3 dage
(70 bedømmelser)
5.9
akritisood94

Dear Recruiter, I am Akriti. I have completed my Diploma in Graphics Design and Text Illusion from Arena Chandigarh. For the past few years I have designed many logos, banners, 3D textures, Auto Cad, Cartoons etc. S Flere

$50 USD på 1 dag
(31 bedømmelser)
5.0
daniyal3214

I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform data analysis, automation etc. I will be happy to discuss in detail.

$50 USD på 1 dag
(45 bedømmelser)
5.3
IFI91

Hello, Sir Weebside Inc. is a professional freelancer service provided to worthy clients like you. We can provide our best developers to provide you High-Quality Product with 100% Delivery Rate, 100% Satisfaction. Flere

$30 USD på 1 dag
(42 bedømmelser)
4.9
alexanderrubtsov

Hello. This is an interesting task. I don't know a deterministic optimization algorithm for this (although it very well can exist), but I think the problem may be solved in a drafting manner. I'll briefly describe Flere

$60 USD in 3 dage
(21 bedømmelser)
4.6
sdroberts

Hello I would love to help with your rotation spreadsheet. This sounds like an interesting tool to get involved with! My name is Steve, I have worked with excel/vba for over 10 years for a global financial services c Flere

$222 USD in 3 dage
(5 bedømmelser)
3.7
ksd711

Hello, Hope you are doing well :) Please check my profile for my proficiency and expertness https://www.freelancer.com/u/ksd711 Please check some of my recent apps all are live Web View Apps https://it Flere

$600 USD in 7 dage
(4 bedømmelser)
3.8
sandipbelote1288

I read your project description . I will complete your project within deadline .so consider my proposal for your project

$77 USD in 5 dage
(1 bedømmelse)
0.5
SpeakerToRobots

I develop windows desktop applications to solve this kind of problem. Examples: assign pilots to crop dusting planes, assign guides to tour buses, assign doctors to emergency room shifts. This work is based on a gene Flere

$222 USD in 20 dage
(0 bedømmelser)
2.6
Dchiuch

This would be for a simple program, not just a worksheet. You click a button and it would accomplish the task. You will also be able to add/remove employees and manually move shifts. Relevant Skills and Experience 15 Flere

$277 USD in 7 dage
(0 bedømmelser)
0.0
agusto0824

Good morning, I'm an information systems engineer. I have more than two years developing macros in excel and databases, I would like to be able to talk with you about this project.

$111 USD in 6 dage
(0 bedømmelser)
0.0