Find Jobs
Hire Freelancers

Excel Monthly Scheduling Program

$30-250 USD

Awarded
Posted over 9 years ago

$30-250 USD

Paid on delivery
I am in need of an excel program that will generate a monthly shift schedule that will auto complete dates in calendar format. I will need the shift times/employee initials listed in color code included (see attached excel example) Details of Info required to be displayed. shifts will be 9 hours. There will be 3 shifts times of each shift: Shift 1: 0600-1500L Shift 2: 1400L-2300L shift 3: 2200L-0700L (next day.) There will be rotating weekend coverage from 0700-2300L Shift 1 will cover first weekend Shift 2 will cover second weekend Mgr will cover 3rd weekend Shift 3 will not be included in weekend coverage rotation. Ideally i would like day cells to be large enough to include time and 2 letter initial of employee ie: 0600-1500L (2 letter initial) // 1400-2300L (2 letter initial) // 2200-0700L (2 letter initial) every 3 months (based on calendar dates 1 Nov-Feb 1) employee on shift 1 will move to shift two. Employee on shift two will move to shift 3. Employee on shift three will move to shift one. Example attached is just for visual aid. Willing to accept different layouts as long as schedule can be auto populated.
Project ID: 6592722

About the project

17 proposals
Remote project
Active 9 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
17 freelancers are bidding on average $137 USD for this job
User Avatar
Hi, I'll be happy to help you with this project. Guaranteed quick turnaround Please feel free to message me if you need to discuss any questions
$155 USD in 1 day
4.9 (112 reviews)
6.5
6.5
User Avatar
Hi, my name is Sevinc. I am a 5-star excel and vba coding expert here. pls check my profile and feedbacks first to have some idea bout the quality of my previous works. I had many similar excel tasks, including creating schedules/timeplans, all achieved with 5/5 rating.. I read your scheduling program project descriptions carefully, I checked your template as well...I exactly got what you need and ready to go ahead...kindly get back to me if you wish to proceed with a top-rated and reliable partner here. pls note that I only deliver best quality at a reasonable price...I bid my best for you to start...regards,
$600 USD in 7 days
4.9 (107 reviews)
6.4
6.4
User Avatar
So basically you need to enter a starting date in cell A3 and then a button to click to update subsequent dates in the calendar and also update the color codes based on shift schedule system, is that correct? You said 3 months but the example shows Nov 1 until Feb 28 (4 months). I am assuming that I can just prepare a template for 3 months, is that correct? Let me know if you want to work with me on this. Regards - Daniel
$100 USD in 3 days
5.0 (118 reviews)
6.1
6.1
User Avatar
Hi. I am Usman and I have designed a very similar scheduling application in Excel before. I can design one according to the attached sheet as well. Kindly discuss. Regards.
$160 USD in 2 days
5.0 (44 reviews)
6.0
6.0
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$98 USD in 2 days
4.9 (75 reviews)
5.9
5.9
User Avatar
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and a high completion rated since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$100 USD in 3 days
5.0 (78 reviews)
5.8
5.8
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 7 days
5.0 (47 reviews)
5.5
5.5
User Avatar
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
$100 USD in 5 days
5.0 (21 reviews)
5.1
5.1
User Avatar
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on business analysis, excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$155 USD in 3 days
4.9 (18 reviews)
4.9
4.9
User Avatar
Good day, I am expert, an advance Excel user ready to help. Please check my profile for more information. Warm regards.
$122 USD in 3 days
5.0 (39 reviews)
4.8
4.8
User Avatar
Hello, I would envision setting this up with a table that would allow the user to change who is in shift 1, 2, 3 manager, etc. and then having a "RUN PROGRAM" button that would generate the next 3 months worth of calenders. I would also propose that each month be located on separate sheets and in Landscape mode to maximize the visibility of the data. I hope to possibly lend a hand, let me know if you have any questions.
$95 USD in 3 days
4.9 (22 reviews)
4.3
4.3
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. I can create exactly what you need. Check my reviews and chat with me. Best regards.
$83 USD in 3 days
4.9 (17 reviews)
4.3
4.3
User Avatar
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Regards, Hardik Shah
$100 USD in 3 days
5.0 (6 reviews)
3.8
3.8
User Avatar
Hello, I am an advanced excel programmer and could help you with your project. I have studied project description in details and can assure you job completion in next 3 days at most. Kind Regards, Mohab
$111 USD in 3 days
5.0 (11 reviews)
3.6
3.6
User Avatar
Dear hiring Executive, I am expert in, Web Design and Theme Development, Graphics Design (Adobe Photoshop, Illustrator), Logo design, classified posting, E-bay listing, Data Entry, Email Marketing, Keyword Research, Web Research, MS Office, OCR, Download/Upload, I provide services in a fast & efficient manner including 100% accuracy. Desire you will hire me for this position for excellent results. I have also great experience in the following area.... 1. Great knowledge about all kinds of software Installation. 2. I am expert on Team viewer support remotely. 3. I am available in online. (50-60 hours per week). 4. I have high speed internet connection, Skype, Google drive and drop box and 4shared 5. I have Following ID: Face book/twitter/Google+/eBay/Printest/LinkedIn 6. I have 7 members team, this might increase in future. Waiting for your positive response please. All the best, Md. Syfullah
$88 USD in 3 days
4.7 (10 reviews)
2.9
2.9
User Avatar
Hi there! My name is Conrad Gillard and I would like to help you with your project to develop a spreadsheet to generate a monthly shift schedule. I have extensive experience with VBA programming to process data, and I am confident that I can develop the macro that you require. I guarantee that I will complete this project within 48 hours of you awarding it to me. To give you an example of my abilities, I recently completed a Freelancer project to extract data from an Excel file and generate a PowerPoint presentation, while allowing the user to specify their preferences. This project also required the development of a simple interface and the use of VBA. If you check my profile you will see that I received extremely positive feedback on this project, due to the fact that I exceeded the clients expectations in terms of developing a reliable and user friendly spreadsheet. The client was also pleased by the fact that I responded promptly to all communications, and completed the job quicker than my promised schedule. Finally, you may be wondering why my bid is so low. The answer is that I am new to Freelancer.com and am currently in the phase of establishing a good reputation for myself. As I mentioned, if you check my profile you will see that the first 7 employers who gave me the opportunity to prove my skills were extremely impressed. Thank you for your time to read my proposal and I look forward to working with you! Regards Conrad
$60 USD in 2 days
5.0 (7 reviews)
2.7
2.7
User Avatar
Hi there- My name is imran.I am highly Expert in this field. I'll provide you satisfaction. So your time and money will be safe when you will award me project. take a look at my Freelancer Portfolio
$263 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, dear. I am very glad to meet you and your project. I have already done similar project in matlab and excel. I have experience in scheduling program. I have done nurse roaster scheduling with very low cost. if you have same problem please contact me. regards.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Katy, United States
5.0
24
Payment method verified
Member since Mar 29, 2006

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.