Find Jobs
Hire Freelancers

I have 160 employees that I need to schedule daily onto 39 different routes starting at different times.

$30-250 USD

Closed
Posted 4 months ago

$30-250 USD

Paid on delivery
I need an Excel template or standalone package developed which can take care of scheduling for up to 160 plus employees into 45 different routes for different branches. The normal working hours are Monday to Friday 8 hours per day and 5 hours on Saturday with any time after normal calculated at 1.5. Sunday work is calculated at double time. Overtime should not exceed 24 hours 1.5 per week and 12 hours double time per week. Each route should be 8 hours and should have 2-6 employees of different functions (Driver, PO, LG) in it. Additionally, there may be certain restrictions in place, such as specific employees only being able to work certain shifts, or mandatory breaks like paid day off every month. We need a Excel document or stand alone package that can handle these detailed requirements and make sure the scheduling process runs smoothly. We should be able to select routes for individuals as well as specific trucks. No employee is allowed to work the same route twice in a specified cycle. Detailed specifics can be shared.
Project ID: 37608440

About the project

31 proposals
Remote project
Active 3 mos 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
31 freelancers are bidding on average $149 USD for this job
User Avatar
hi I can develop you an Excel template to manage scheduling of employees into work routes, as per your requirements. I'm available to discuss more details in chat. Abdul H.
$100 USD in 1 day
5.0 (156 reviews)
6.9
6.9
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD in 3 days
4.9 (146 reviews)
7.2
7.2
User Avatar
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within some hours
$80 USD in 1 day
4.9 (76 reviews)
6.1
6.1
User Avatar
With over a decade of experience in Excel and automation, I have the necessary skills to develop an efficient and comprehensive scheduling solution for your complex needs. My expertise spans from formulas to power pivot, power queries, dynamic charts, and macros - all vital in creating a robust yet flexible template. I understand the inherent complexities of managing large workforces with diverse roles and the need to balance various factors such as working hours, overtime restrictions, and specific shift preferences. Moreover, my proficiency in Python over the years makes me highly adept at automating repetitive tasks, which could translate into substantial time-saving advantages for your company. I can set up intelligent algorithms to ensure no employee is assigned the same route twice within a specified cycle, while respecting mandatory breaks like paid days off every month. Choosing me means you will have a dependable partner who genuinely cares about delivering on time and is always available to address any last-minute concerns or adjustments to the functionality. Let's streamline your scheduling process and ensure smooth operations for all 45 branches with 160 plus employees!
$110 USD in 2 days
5.0 (61 reviews)
5.7
5.7
User Avatar
Hi, I have expertise in Excel automation and complex scheduling, I'll develop a robust template or standalone solution to efficiently manage scheduling for over 160 employees across 45 routes. The system will seamlessly handle varied work hours, overtime calculations, employee restrictions, and route optimization, ensuring a smooth and tailored scheduling process. So I start work immediately You can visit my Profile https://www.freelancer.com/u/ExpertSoul Thank you
$175 USD in 2 days
4.7 (26 reviews)
5.8
5.8
User Avatar
Hey, I used Google OR-Tools and Gurobi tons of different times for scheduling problems. I can handle it easily. Let's have a chat? Best, Tev
$250 USD in 7 days
5.0 (55 reviews)
5.6
5.6
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$500 USD in 7 days
5.0 (33 reviews)
5.5
5.5
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$100 USD in 1 day
5.0 (15 reviews)
4.9
4.9
User Avatar
Hi there, I checked your requirements and guarantee you that i have relevant experience in Python to do this taks it's gonna be done within the next few days . Let's contact via chat so that I can start work immediately
$200 USD in 3 days
4.8 (27 reviews)
5.3
5.3
User Avatar
Dear jfakoe, I hope this message finds you well. My name is Christopher, and I have over 4 years of experience in Python development. I have carefully read the requirements for your project and I am confident that I can deliver it with perfection. I understand that you need an Excel template or a standalone package that can efficiently schedule up to 160 employees into 45 different routes for different branches. The scheduling should take into account various factors such as working hours, overtime calculations, employee restrictions, and mandatory breaks. I have extensive experience in Python and Excel VBA, which makes me well-equipped to handle this project. I can develop a solution that meets all your detailed requirements and ensures a smooth scheduling process. If you have any questions or would like to discuss the project further, please feel free to connect with me in the chat. I am available and ready to assist you. Thank you for considering my proposal. I look forward to the opportunity to work with you. Best regards, Christopher
$140 USD in 5 days
5.0 (10 reviews)
4.7
4.7
User Avatar
Hi, how are you? I go through the description and read it carefully, I know exactly what you are looking for. I have 5+ years’ experience in these skills Excel VBA, Excel Macros and Python. I have some question about this job, Please start chat, so we have detail discussion about your task. Thanks! Umair
$250 USD in 7 days
5.0 (15 reviews)
4.6
4.6
User Avatar
""""""""""""""""""""ADVANCE EXCEL EXPERT""""""""""""""""""""""""" """"""""""""""""""""EXCEL TEMPLATE EXPERT""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$99 USD in 1 day
5.0 (18 reviews)
4.6
4.6
User Avatar
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project. https://www.freelancer.com/projects/excel/Excel-VBA-Data-Entry-Analysis-32285292/reviews https://www.freelancer.com/projects/excel/Data-Analytics-Project-30073140/details https://www.freelancer.com/projects/data-mining/DATA-MINING-ANALYSIS-USING-NEURAL/reviews https://www.freelancer.com/projects/excel/Hire-Excel-Expert-15193739 I would love to discuss the project further :).
$200 USD in 3 days
5.0 (8 reviews)
3.7
3.7
User Avatar
With over six years of professional experience in Excel Macros, Excel VBA, and Python, I am confident that I have the skills needed to create a robust scheduling system for your 160 employees across 45 different routes. I understand the intricacies of handling complex scheduling with specific restrictions and requirements and have successfully developed similar solutions in the past. My ability to write efficient code paired with my commitment to detail will ensure that each shift is correctly staffed. Your requirement for managing overtime is certainly challenging but nothing I can't handle. I have implemented similar calculations in the past - considering various factors like normal working hours, weekends, and employee limits. Ensuring compliance with labor laws and avoiding any schedule conflicts is my top priority. Additionally, I can design the program in such a way that one employee doesn't work the same route twice in a specified cycle, providing equal opportunities for all. I believe efficiency is key, especially when it comes to scheduling a large workforce like yours. With my advanced Excel and Python skills, I can develop an intuitive interface that offers easy route selection for individuals as well as trucks. Regular backups will ensure zero data loss, and I'm also open to any customization or additional features you may need along the way. Trust me with your project and let's work together towards an effective scheduling solution that suits your unique needs.
$80 USD in 1 day
5.0 (5 reviews)
3.2
3.2
User Avatar
Hello there! I have great experience with Python, Excel VBA and Excel Macros. So i can help u with this job plz contact and initiate the chat so that we can discuss in detail. Meanwhile here is my profile: https://www.freelancer.com/u/ayesha0124
$250 USD in 9 days
5.0 (1 review)
3.0
3.0
User Avatar
Hi there, Good afternoon I am Talha. I can work with your project skills Excel VBA, Excel Macros and PythonI am excited to submit my proposal for your project, which focuses on a comprehensive project plan. To begin, we will thoroughly understand your project's objectives and requirements, ensuring alignment on scope and goals. We will provide a clear and realistic project timeline with manageable milestones to ensure timely completion.
$30 USD in 12 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Hello, I am an experienced Excel developer ready to create a comprehensive scheduling solution tailored to your unique requirements. With the ability to handle scheduling for over 160 employees across 45 different routes and branches, the Excel template or standalone package will efficiently manage working hours, overtime calculations, and employee restrictions. The system will ensure fair distribution of routes, considering different functions (Driver, PO, LG) and adhering to specific constraints such as breaks and restrictions on repeated routes within a specified cycle. I am well-versed in designing user-friendly interfaces for seamless route and employee selection, along with accommodating specific trucks. Rest assured, the developed solution will streamline your scheduling process, ensuring accuracy and adherence to your detailed specifications. I look forward to contributing to the efficiency of your workforce management through this tailored Excel solution. Best regards, Zafar
$100 USD in 1 day
5.0 (1 review)
2.8
2.8
User Avatar
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
$45 USD in 1 day
5.0 (3 reviews)
2.1
2.1
User Avatar
With my 15 years of industry experience in Power BI, SQL Server, Excel, VBA, and all the relevant skills, I believe I am well-equipped to help you develop your much-needed Excel template or stand-alone package. In my decade of proficiency with Excel VBA and macros, I have worked on multiple automation projects and managed various types of data sources including SQL server, Oracle, Azure databricks, and Excel sharepoint. Efficiency will be at the core of what I deliver for your scheduling needs. I understand the complexity of your task - managing 160-plus employees across 45 different routes with varying working hours and unique constraints such as specific functions for employees and restrictions on shifts. My detailed-oriented approach coupled with my extensive knowledge of Excel macros will ensure we meet these precise requirements effectively. By engaging me for this project you are not simply hiring a freelancer but gaining a partner who is dedicated to making your scheduling process run smoothly while maximizing productivity. My goal is to create a solution that allows you to efficiently map out optimal routes with just the right composition of employees in accordance with all applicable rules and altogether ensuring no employee is assigned to the same route twice in a specified cycle.
$100 USD in 2 days
5.0 (3 reviews)
2.1
2.1
User Avatar
Hey there ! With 12 years of experience in Planning & scheduling, Excel , VBA, MS SQL and SSRS, I've become adept at crafting efficient and tailored solutions for complex scheduling problems just like yours. I've been working on the Power BI and Python platforms for 3 years now, utilizing them to analyze and visualize large datasets which is crucial for managing a workforce as sizable as yours. My past work for a commercial bank in Nepal along with several US-based clients has allowed me to refine my problem-solving skills and deep understanding of complex scheduling needs. Being an expert in data analysis, I can design an Excel document or standalone package that can handle all your specific requirements down to the last detail. No one understands the importance of individual truck preferences, employee shift restrictions or mandatory breaks better than I do, guaranteeing that each employee gets assigned appropriately within the specified cycles. Choosing me means choosing not only expertise but also a strong dedication towards ensuring a smooth scheduling process. I am highly committed to timely delivery and meticulous project execution. Let's schedule everything without any hitches together!
$200 USD in 3 days
4.6 (2 reviews)
1.9
1.9

About the client

Flag of SOUTH AFRICA
South Africa
0.0
0
Member since Mar 2, 2016

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.