Find Jobs
Hire Freelancers

EXCEL: Create a master employee scheduling TEMPLATE

$75-100 USD

Closed
Posted over 6 years ago

$75-100 USD

Paid on delivery
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.
Project ID: 15433191

About the project

28 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
28 freelancers are bidding on average $90 USD for this job
User Avatar
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 period. Proposed Milestones $100 USD - You are satisfied by the end product. When can we chat or talk? I am online from 3 to 11 pm (GMT+3).
$100 USD in 7 days
4.9 (395 reviews)
8.1
8.1
User Avatar
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 experience with excellent knowledge. please give me a chance to work on your project. Proposed Milestones $83 USD - Payment once project is complete
$83 USD in 2 days
4.9 (94 reviews)
6.1
6.1
User Avatar
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
4.8 (41 reviews)
6.1
6.1
User Avatar
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 experience in Excel, Excel Macros, Excel VBA, Visual Basic Proposed Milestones $75 USD - Create a master employee scheduling TEMPLATE
$75 USD in 10 days
4.8 (14 reviews)
5.3
5.3
User Avatar
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 understanding to the project owner. So this will be base of our long term relationships.....
$100 USD in 10 days
5.0 (16 reviews)
4.8
4.8
User Avatar
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 do your project directly. Proposed Milestones $77 USD - Excel Employee Template
$77 USD in 4 days
5.0 (46 reviews)
4.7
4.7
User Avatar
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 Experience Excel, Excel Macros, Excel VBA, Visual Basic Proposed Milestones $100 USD - Final Delivery
$100 USD in 7 days
4.9 (30 reviews)
4.6
4.6
User Avatar
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 closed few projects using Excel VBA including Dashboards. Proposed Milestones $87 USD - Employee Scheduling Template Please confirm the operating system and excel version you are using.
$87 USD in 5 days
5.0 (14 reviews)
4.2
4.2
User Avatar
, Relevant Skills and Experience , Proposed Milestones $40 USD - 1st milestone $57 USD - 2nd milestone
$97 USD in 7 days
5.0 (9 reviews)
3.2
3.2
User Avatar
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 almost the same concept. I can write a VBA code whenever it's needed. But my approach is to minimize it as possible, to improve your ability to makes changes in future. looking forward to hear from you
$100 USD in 7 days
5.0 (4 reviews)
3.3
3.3
User Avatar
hello sir i can complete your project perfectly i will try my best for your project
$77 USD in 3 days
5.0 (2 reviews)
0.6
0.6
User Avatar
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 Experience Several excel pages with macros so no problem for this task . also no problem with replicating for next months. Proposed Milestones $10 USD - First sample for client options $70 USD - For work delivery $17 USD - For final changes as needed
$97 USD in 4 days
5.0 (1 review)
0.5
0.5
User Avatar
Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones $111 USD - Full Price
$111 USD in 1 day
4.0 (1 review)
0.9
0.9
User Avatar
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 doing Data entry and Web Searcher. I have always made quality my top priority while also balancing a large quantity of work. Proposed Milestones $75 USD - payment
$75 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, I have been developing Excel/VBA tools from a while. I am a graduate of IIT Kharagpur and have been working as a junior consultant for a while. this is my first time freelancing. please give me the option to work for you. I hope I could be of help -Manu
$111 USD in 7 days
1.0 (1 review)
0.5
0.5
User Avatar
A proposal has not yet been provided
$75 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$88 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more then 10 years of experience in accounting specially in Payroll and good command over Excel. Relevant Skills and Experience Good command over Excel. Proposed Milestones $83 USD - Within 5 days
$83 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
If you need a scheduling template, I’m the perfect man for the job. On a weekly basis, I, myself, create a schedule for my employees for the business that I currently own. It does seem that you’re asking for something a bit more complicated than I’m used to, but surely it’s something I can figure out given my experience with the Excel program. Feel free to message me anytime if you want to view the samples of my scheduling template. Thank you and have a blessed day.
$77 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Woodbridge, United States
5.0
28
Payment method verified
Member since Jun 19, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.