Lukket

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.

Evner: Excel, Excel Macros, Excel VBA, Visual Basic

Se mere: 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, 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, data processing, excel, visual basic, microsoft access, visual basic for apps, microsoft excel, create master template powerpoint, excel scheduling template, employee scheduling excel template scripting

Om arbejdsgiveren:
( 25 bedømmelser ) Woodbridge, United States

Projekt ID: #15433191

29 freelancere byder i gennemsnit $89 på dette 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 Flere

$100 USD in 7 dage
(160 bedømmelser)
6.8
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 Flere

$75 USD in 2 dage
(60 bedømmelser)
5.7
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 Flere

$83 USD in 2 dage
(91 bedømmelser)
5.7
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 dage
(32 bedømmelser)
5.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 Flere

$75 USD in 10 dage
(14 bedømmelser)
5.3
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 Flere

$100 USD in 10 dage
(13 bedømmelser)
4.5
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 Flere

$100 USD in 7 dage
(30 bedømmelser)
4.5
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 Flere

$77 USD in 4 dage
(40 bedømmelser)
4.5
jasalaz100

Immediate [login to view URL], 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 Flere

$77 USD in 3 dage
(26 bedømmelser)
4.7
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 Flere

$87 USD in 5 dage
(12 bedømmelser)
4.1
mpunn2007

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

$97 USD in 7 dage
(9 bedømmelser)
3.1
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 Flere

$100 USD in 7 dage
(3 bedømmelser)
2.3
xlbymalix

Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones $111 USD - Full Price

$111 USD på 1 dag
(1 bedømmelse)
0.8
mhfhusmi

hello sir i can complete your project perfectly i will try my best for your project

$77 USD in 3 dage
(2 bedømmelser)
0.6
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 Flere

$97 USD in 4 dage
(1 bedømmelse)
0.5
Rmedina7

A proposal has not yet been provided

$88 USD på 1 dag
(0 bedømmelser)
0.0
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 Flere

$100 USD in 5 dage
(0 bedømmelser)
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 Flere

$100 USD in 2 dage
(0 bedømmelser)
0.0
tuyuansheng2012

A proposal has not yet been provided

$111 USD på 1 dag
(0 bedømmelser)
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 Flere

$75 USD in 5 dage
(0 bedømmelser)
0.0