Closed

EXCEL: Create a master employee scheduling TEMPLATE

We need an EXCEL EXPERT to create an AVAILABLE master employee scheduling template.

Each month- we have to create an employee work schedule based on a bunch of different variables and roster list. We want an excel template that shows each AVAILABLE person that can work particular shifts, hours, days, etc - so we can finalize our work schedule.

The template must:

1. Input employee names, initials, position level, etc

2. Input standard work hours for each day

3. Input shift hours

4. For each employee, input their "blackout" (cannot work) dates

5. Enter the two-week pay period (it's always standard rolling two week process)

6. Be able to replicate the same template for each month

From this create an "draft" work schedule based on positions, shifts, etc

You will also need to put on the calendar - each employees, how many given shifts, how many hours in a two week pay period

There are two locations - and for each employee should also have "preferred location" - so that the calendar will try to put the preferred employee (if that employee is available) on that day on that location. (there are 3 locations).

Excel template should be modular and flexible. And LEAST hard-wired as possible.

Skills: Excel, Excel Macros, Excel VBA, Visual Basic

See more: free employee schedule template, monthly employee shift schedule template, rotating shift schedule template, free work schedule maker, weekly employee shift schedule template excel, monthly employee schedule template excel, weekly employee schedule template, free work schedule template, i have 8600 full names and addresses of people that i need to be able to find their phones numbers i have the data in excel spre, create master template existing website, create master file excel, create master template powerpoint, excel scheduling template, employee scheduling excel template scripting, create sheets excel using master sheet

About the Employer:
( 23 reviews ) Woodbridge, United States

Project ID: #15433191

31 freelancers are bidding on average $89 for this job

paris2785

Hi there - My name is Paris. I can develop a spreadsheet with the necessary code to support the roster plan you want. Relevant Skills and Experience I have developed a great number of Excel solutions over a ten years More

$100 USD in 7 days
(120 Reviews)
6.5
zu02

Hi, I can do your current project via Excel or also via Access. Relevant Skills and Experience Excel,Access,vba Proposed Milestones $100 USD - default

$100 USD in 3 days
(27 Reviews)
5.6
shafaqat11

Greetings sir, I am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement. Relevant Skills and Experience I have the 5 years of ex More

$83 USD in 2 days
(76 Reviews)
5.4
asadkhan3533

Please review my profile as i am an excel expert with more than 9 years of professional experience. I am very proficient with the formulas and macros. Relevant Skills and Experience Excel, Excel Macros, Excel VBA, Vis More

$83 USD in 10 days
(29 Reviews)
4.7
nurnga1218

I don't have many knowledge about employee but I'm expert in excel macro, template or some complicated cases. Relevant Skills and Experience Now, I'm doing 2 excel projects and they are 90% completed. So I think I can More

$77 USD in 4 days
(28 Reviews)
4.2
rajafaizan

Hi, I read your project detail. I have experience in Excel VBA to create employee schedule variable & roster list. I will use particular shifts, hours, days, etc as per your requirement. Thank You Relevant Skills and More

$100 USD in 7 days
(28 Reviews)
4.5
SShtv

Your task is clear to me and I am ready to execute the project for the 75 USD. Relevant Skills and Experience I have a successful experience of doing such work. As an example, I bring screenshots of one of the program More

$75 USD in 2 days
(22 Reviews)
4.5
Developer000

NO AUTOMATIC BIDDING........................ I am here freelancer first to discuss the details then i can sure about my price and the deadline. My way of working is not only to complete but also to provide enough u More

$100 USD in 10 days
(4 Reviews)
3.4
chintuag

I have read the project description and interested to work on it. I would like to discuss the requirements in detail. Relevant Skills and Experience I have worked on similar projects in Excel and have have recently cl More

$87 USD in 5 days
(5 Reviews)
3.3
jasalaz100

Immediate [url removed, login to view], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

$77 USD in 3 days
(6 Reviews)
3.0
mpunn2007

, Relevant Skills and Experience , Proposed Milestones $40 USD - 1st milestone $57 USD - 2nd milestone

$97 USD in 7 days
(6 Reviews)
2.8
whitehorsetechn

Greeting, I have understood your master employee scheduling template 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 ex More

$75 USD in 10 days
(1 Review)
2.0
miguelazarrivera

I'm an experience excel professionally. with more than 15 years using excel. I'm sure you will be pleased with the work done. Also, I can make all the changes for you to work fast and easy. Relevant Skills and Experi More

$97 USD in 4 days
(1 Review)
0.6
cnfolio

I would suggest a template and revise it until you have agreed that it meets your requirements. Then, I'd deliver the complete Excel and VBA file according to the agreed template. Relevant Skills and Experience Experi More

$100 USD in 5 days
(0 Reviews)
0.0
abbas46

sir, I am working in excel from last 9 years. I has develop templates at my job for my bosses. this task is related to my skill & can perform it easily. I am applying from mobile, so I can't attach my portfolio work.

$83 USD in 5 days
(0 Reviews)
0.0
jnmalau

I have completed the configuration for the schedule template. My design can be repeated every month. You merely need to change the month and enter data in the records section. Relevant Skills and Experience I have upl More

$100 USD in 2 days
(0 Reviews)
0.0
samerbadee

Hello, Basically I'm an Industrial engineer with over 15 years of experience in Production scheduling using different tools, and among them is excel spreadsheets. Scheduling workcenters in manufacturing industry is al More

$100 USD in 7 days
(0 Reviews)
0.0
tuyuansheng2012

A proposal has not yet been provided

$111 USD in 1 day
(0 Reviews)
0.0
tinyval123

I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. Relevant Skills and Experience I have worked for many respected clients do More

$75 USD in 5 days
(0 Reviews)
0.0
redkite82

The timeframe will depend largely on the quality of the data you have for inputting but the basic premise of your request is fairly simple using excel. Can use VBA depending on what you want. Relevant Skills and Exper More

$77 USD in 2 days
(0 Reviews)
0.0