
Closed
Posted
Paid on delivery
I am looking for someone for help building an automated schedule generator. The shift generator should be user centric and is likely to require the following requirements from the user: - staff ID (may require security) - staff qualification/training - How many staff with the respective training/qualification required per shift - Consider equity, defined by user, for each staff to rotate between day and night shifts, rest days and training days - Consider hours clocked per staff - to fulfill minimum hours, adjust hours within specified limitations etc. while considering equity as mentioned above - Export to excel such that the user is able to modify manually - Allow user to insert previous schedule so that the generator will consider past roster to generate the new one. - Track sick leaves, training days, leave days. - This generator should be local, therefore it has to be on a platform that we can ship to the user, and provide help or updates to their generator when and if they require This initial project will be less complicated and will not require all of the above conditions. The list is just to give you an idea what the final product would look like in its ideal state. Strict requirements for this project: - I need this to be Excel native as much as possible, VBA included - I need you to document your process on how you developed each feature. You will need to meet me regularly on how you’ve built certain features, and I should be able to re-create it. In a way, you’ll be my tutor too. We are looking for someone experienced, reliable, willing to try new things, willing to work on what may seem impossible, quick turn around, timely and communicative. If you believe that possibilities are only limited to your imagination, then we are aligned - please apply!
Project ID: 40412942
62 proposals
Remote project
Active 10 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
62 freelancers are bidding on average $213 SGD for this job

⭐⭐⭐⭐⭐ Create an Automated Schedule Generator for Your Needs ❇️ Hi My Friend, I hope you are doing well. I just reviewed your project requirements and see you are looking for help building an automated schedule generator. You don't need to look any further; Zohaib is here to assist you! My team has successfully completed 50+ similar projects for schedule automation. I will create a user-friendly generator that meets your requirements, ensuring it’s Excel-native with VBA support. ➡️ Why Me? I can easily build your automated schedule generator as I have 5 years of experience in Excel automation, specializing in VBA programming, data management, and user-centric solutions. Not only this, but I also have a strong grip on project documentation and communication, ensuring you can recreate the features we develop together. ➡️ Let's have a quick chat to discuss your project in detail. I can show you samples of my previous work and how I can meet your needs. Looking forward to discussing this with you! ➡️ Skills & Experience: ✅ Excel Automation ✅ VBA Programming ✅ Data Management ✅ User-Centric Design ✅ Shift Scheduling ✅ Process Documentation ✅ Communication Skills ✅ Problem Solving ✅ Time Management ✅ Reporting Tools ✅ User Training ✅ Local Software Deployment Waiting for your response! Best Regards, Zohaib
$150 SGD in 2 days
8.0
8.0

Hi, This is a great use case for an Excel + VBA–driven scheduling engine, and I can both build it and guide you step-by-step so you can fully understand and extend it. Approach: I’ll design a modular Excel system with VBA automation—keeping everything local, fast, and editable. What I’ll build (Phase 1): • Staff database (ID, qualifications, availability) • Shift requirement setup (roles per shift) • Smart schedule generator (rule-based + fairness rotation) • Hours tracking + constraints (min/max, rest rules) • Leave/sick/training tracking • Import previous roster for continuity • One-click export (clean, editable Excel output) Logic Design: Weighted rule engine in VBA (priority: coverage → constraints → fairness). Built to scale toward your full vision. Your Tutor Requirement: I’ll document each feature + walk you through live (calls + notes), so you can rebuild and modify confidently. Timeline: 2–3 weeks (Phase 1) Future-ready: Can evolve into advanced optimizer later. Let’s build something powerful—and make sure you fully own it.
$140 SGD in 7 days
8.2
8.2

Hi there, I understand you need an Excel-native automated scheduling system that balances staffing rules, fairness, and constraints, while also being transparent enough for you to learn and recreate. I’m confident I can build a practical, scalable solution and guide you through it step by step. My approach is to design a structured Excel model with a clear input layer for staff details (IDs, qualifications, availability), rule settings (shift requirements, min/max hours, equity rules), and historical data (previous schedules, leave, training). On top of this, I will build a scheduling engine using VBA combined with formula logic to generate optimized rosters that respect constraints like coverage, fairness between day/night shifts, and hour balancing. The generator will output a clean, editable schedule in Excel, allowing manual adjustments without breaking the logic. I will also include tracking for leave types and a mechanism to reference past rosters so future schedules remain consistent and fair. Deliverables include the working Excel tool with VBA, full documentation, and guided walkthrough sessions. To start effectively, could you share how many staff and shifts you typically manage per cycle? I’m ready to begin immediately. Warm Regards, Aneesa.
$100 SGD in 1 day
7.5
7.5

Hello, I see you need an automated staff schedule generator that simplifies shift planning while handling complex constraints efficiently. A hidden challenge is ensuring flexibility for last-minute changes without breaking the schedule integrity. Our team excels in backend development with Laravel and frontend skills in Vue.js and React.js, perfect for building intuitive and robust scheduling tools. You can check samples from our work at https://www.freelancer.com/u/eliaa. Let's discuss how we can turn your scheduling needs into a seamless, automated solution.
$250 SGD in 7 days
6.9
6.9

With my extensive experience in automation, data analysis, Excel, and PHP, I'm confident that I can develop an exceptional automated staff schedule generator for your unique needs. At Zayer Tech, we have a proven track record of delivering AI-driven solutions that drive efficiency and innovation. And this project aligns perfectly with our expertise. Equally important is the platform's usability, especially when handling multiple variables like staff ID, qualifications, hours clocked,& equity. I intend to build a user-centric solution that covers all scenarios you outlined while ensuring a quick turnaround for updates and maintenance. Choose Zayer Tech for limitless possibilities limited only by your imagination.
$140 SGD in 7 days
6.8
6.8

Hi, this is a great fit. At SolutionzHere, we’ve built Excel/VBA scheduling engines with constraints (skills, coverage, fairness, hours). Approach: • Excel-native model (tables + validation) • VBA engine (constraint-based: qualifications, min staffing, hours caps, rotation fairness) • Handles leave/sick/training + previous roster input • One-click generate + export/editable Excel • Step-by-step sessions so you can rebuild/extend it yourself We’ll keep it simple for v1, then scale logic. Budget fits—$20–30 SGD/hr, 1–2 weeks for initial version. We’ve done similar roster tools. One question: roughly how many staff and shifts per day are we planning for?
$1,400 SGD in 10 days
6.3
6.3

I ALREADY MADE SIMILAR PROJECT LIKE THAT BEFORE. I can build an Excel + VBA schedule generator with fair shift rotation, skills-based assignment, and easy manual editing. Fully documented with step-by-step guidance. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$90 SGD in 1 day
6.6
6.6

Hello, With over 7 years of experience in Excel and Excel Macros, I have the expertise to develop an automated staff schedule generator tailored to your requirements. I have carefully reviewed the project description and understand the need for a user-centric shift generator with specific functionalities. To address your needs, I propose to develop a customized Excel-based solution that incorporates features such as staff ID security, qualification/training tracking, equitable shift rotations, hours management, manual modification capabilities, historical data integration, and leave tracking. Utilizing VBA, I will ensure that the generator is Excel-native and user-friendly, with detailed documentation provided for each feature developed. I am committed to meeting your strict requirements and collaborating closely with you throughout the development process. If you are interested in discussing the project further, please feel free to connect with me in the chat. You can visit my profile at https://www.freelancer.com/u/HiraMahmood4072 Thank you.
$100 SGD in 2 days
6.4
6.4

⭐⭐⭐⭐⭐ Automated Staff Schedule Generator Development ❇️ Hello! After reviewing your project requirements for an Automated Staff Schedule Generator, I am confident in my ability to deliver a high-quality solution that meets your needs. With extensive experience in developing complex Excel-based applications, including the use of VBA for automation, I am well-equipped to handle the demands of this project. ➡️ Why Me? I hold a PhD in Computer Science and have over 10 years of experience in software development, with a strong focus on automation tools and Excel programming. My expertise includes creating sophisticated scheduling systems that incorporate various user-defined criteria, such as staff qualifications, shift rotations, and hour tracking. I have successfully implemented similar systems that are currently in use by organizations for managing their workforce efficiently. ➡️ Lets schedule a meeting to discuss this project further, where I can also provide demonstrations of previous projects similar to your requirements. ➡️ Key features I have developed in past projects: ✅ Integration of complex user input forms in Excel to capture diverse data requirements ✅ Advanced VBA scripting to automate scheduling tasks and data manipulation ✅ Dynamic reports generation and export functionalities to formats like Excel, allowing manual adjustments ✅ Implementation of security features for sensitive data handling within Excel ✅ Development of user-friendly interfaces for non-technical users to manage system operations easily I am excited about the possibility of working on this project and bringing your vision for an Automated Staff Schedule Generator to life. I am committed to delivering a system that not only meets the initial requirements but also includes scalable features for future enhancements. Looking forward to our collaboration on this innovative project! Best Regards, Dr. Muhammad Asad
$187 SGD in 6 days
6.5
6.5

Hi There!!! ★★★★ (Excel VBA-based smart staff scheduler with fairness logic & training guidance ★★★★ Project understanding: I understand you need an Excel-native automated schedule generator using VBA that considers staff qualifications, shift requirements, fairness (day/night rotation), and hours tracking. Also, you want it to be educational—clear documentation and walkthroughs so you can recreate and expand it yourself. Services mentioned here based on project details ⚜ Build Excel/VBA-based schedule generator (local solution) ⚜ Implement staff rules (skills, shift needs, hours limits) ⚜ Add fairness logic for rotation & workload balance ⚜ Include leave, training, and past roster consideration ⚜ Export-ready structured Excel with manual edit option ⚜ Step-by-step documentation + live walkthrough sessions ⚜ Modular design for future feature expansion I have experiance in Excel automation, VBA scripting, and building logic-driven tools where usability matters. I enjoy teaching alongside development, so you’ll clearly understand how each part works. My approach is to start with a simple working model, then gradually layer logic (fairness, constraints), while documenting each step. We’ll review together so you can confidently rebuild or modify it. Happy to collaborate and build this step-by-step with you. Warm Regards, Farhin B.
$110 SGD in 10 days
6.6
6.6

Hi there, I like how you have outlined your project description with clear expectations and ambitions for the automated staff schedule generator. You are looking for an Excel-native, VBA-based solution that intelligently schedules staff shifts by considering qualifications, equity in shift rotation, hours worked, and leave tracking, all while remaining user-centric and allowing manual adjustments. Additionally, you want a well-documented process with regular updates and tutoring to ensure you can maintain and extend the tool independently. With over 7 years of experience developing advanced Excel VBA applications for workforce management, I have created custom shift planners incorporating dynamic constraints similar to what you described. I understand the importance of balancing technical complexity with user-friendliness and will deliver a solution that is intuitive yet powerful. My approach prioritizes clean, modular VBA code with comprehensive documentation and frequent communication to keep you involved every step of the way. I am comfortable working on innovative challenges and adopting iterative development with quick turnarounds, ensuring your vision is translated into a practical, sustainable tool. Let’s discuss how I can help bring your automated schedule generator to life and empower you to manage your staff effortlessly. Looking forward to your response!
$175 SGD in 14 days
5.9
5.9

Hello Dear! Greetings from Toriqul Global Solutions! We are pleased to introduce our company as a reliable and experienced provider of Web Design & Development services. Founded and led by Engineer Toriqul Islam, a B.Sc. graduate in Computer Science & Engineering from Rajshahi University of Engineering & Technology (RUET), our team brings over 10 years of industry experience. At Toriqul Global Solutions, we specialize in building modern, user-friendly, and high-performance websites that help businesses grow and stand out in the digital world. Our design approach focuses on simplicity, elegance, and functionality to ensure maximum user engagement. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB What you'll get? • Fully Responsive Website on All Devices • Reusable Components • Quick response • Clean, tested and documented code • Completely met deadlines and requirements • Clear communication We would be honored to discuss your project requirements and help bring your ideas to life. Thank you for your time and consideration. Warm Regards, Toriqul Global Solutions
$80 SGD in 4 days
6.0
6.0

Hello Client, I hope you are doing well. I’m an independent developer with deep hands-on experience in Excel, VBA automation, and building user-friendly tools that live locally on the user’s machine. I specialize in crafting robust, Excel-native solutions that minimize dependencies while delivering clear, maintainable code. My approach is practical, focused on delivering a smooth, dependable experience for end users who rely on accurate scheduling and easy data export. In past work I’ve built and refined schedule generators and data-tracking workflows that handle staff qualifications, shift requirements, equity considerations, and clocked hours, all with strong data validation and export capabilities to Excel. I design with security and auditor-friendly logging in mind, and I document each feature so you can follow along and recreate it if needed, with code comments and a concise development diary. I can deliver an MVP focused on Excel-native functionality with VBA, structured to expand toward your ideal state as requirements evolve. You’ll get clear milestones, a dependable build, and ongoing accessibility for updates and support. Please feel free to contact me so we can discuss more details. I am looking forward to the chance of working together. Best regards, Billy Bryan
$250 SGD in 2 days
5.2
5.2

Interesting project, I will build your Excel + VBA shift generator with inputs for staff/qualifications/equity rules, a greedy assigner rotating day/night/rest/training while honouring min hours, leave tracking, plus export and previous-roster import. For a generator you can recreate, I will keep VBA modular (inputs, engine, output) with inline docs and a walkthrough each milestone, not a Solver black box. Questions: 1) MVP staff count and shift roles to size the initial scope? 2) Equity rules: tier-based (e.g., max 2 nights in a row) or scored across a window? Ready to start whenever you are. Faizan
$130 SGD in 7 days
5.5
5.5

Hi, I am ready to start working on this with you right away. I have strong experience building automated scheduling and rostering systems in Excel using VBA, including shift rotation logic, equity balancing, hour tracking, and exportable outputs. I also have experience documenting development processes clearly so that clients can understand, replicate, and maintain the system independently. I will build your schedule generator as an Excel native solution with VBA, starting with the core shift generation logic and gradually layering in features like staff qualifications, equity based rotation, hour balancing, and previous schedule imports. I will document every step of the development process thoroughly and meet with you regularly to walk through how each feature works so you are fully equipped to recreate and manage it on your own. Best regards, Huzaifa
$60 SGD in 2 days
5.0
5.0

Greetings, I believe we are aligned in our approach to creating an automated staff schedule generator tailored to your needs. The goal is to build a user-friendly tool that can handle staff qualifications, manage shift rotations, and track attendance while also being flexible enough to allow for manual adjustments in Excel. To tackle this, I would use Excel and VBA to develop the core functionality, ensuring that it meets your requirements around security and data management. I will make sure to document each step of the process clearly, so you can follow along and learn how each feature is built. Regular meetings will help us stay aligned and address any challenges together. I’m excited about the opportunity to bring this project to life and to explore innovative solutions along the way. Best regards, Muhammad Arshman
$100 SGD in 4 days
4.7
4.7

Hello, I can build your Excel based automated schedule generator using VBA with a strong focus on logic, flexibility, and user control. I will design a user centric system that handles staff roles, shift requirements, and fair rotation between day, night, and rest periods. The generator will consider hours worked, minimum requirements, and balance equity across all staff. I will include tracking for leave, sick days, and training while allowing past schedules to influence new ones. Output will be cleanly structured in Excel so you can easily adjust it manually. The solution will run fully locally with no external dependencies. I will document every step and explain how each feature is built so you can recreate and understand the system. We can meet regularly to review progress and go through the logic together. I am experienced with complex Excel automation and ready to build this with you step by step.
$160 SGD in 7 days
4.8
4.8

With more than five years of experience in Python and automation development, I am confident I can address your critical need for an automated staff schedule generator. My expertise lies in building reliable backend systems and automation strategies that increase efficiency and reduce manual work, which aligns perfectly with your project goals. Using my modern skills in Python, I can create the user-centric platform you need to streamline your staffing process. One area that sets me apart from others is my proficiency in Excel and VBA. Building your automated generator using Excel native features is something I excel at. Additionally, my extensive knowledge of automation will aid in generating a system capable of adjusting hours, accommodating staff qualifications, rotating shifts based on equity, and even tracking leave days or training days as outlined in your requirements. Furthermore, as a freelancer who focuses on clear communication, regular updates, realistic timelines and transparent delivery, you can count on me to meet with you frequently reviewing each feature's progress so that you are able to recreate them if needed. I understand the importance of a system that doesn't lock you down but empowers you to make changes and improvements as you need to. Let's work together to make your ideal staff schedule generator a reality!
$140 SGD in 7 days
5.8
5.8

Hi there, I am senior software developer having 10+ years experience in php, MySQL , javascript etc. Assure you for quality service. Ready to start asap. Let us discuss further. Thanks, Prasy
$280 SGD in 12 days
5.4
5.4

Hi there, I understand you need an Excel-based automated schedule generator that balances staff qualifications, shift coverage, fairness, and hour tracking, while staying flexible and easy to update. You also want full transparency so you can learn and recreate the system. My approach will start with a structured data model for staff, shift requirements, and past schedules. I will build a rule-based scheduling engine using Excel formulas and VBA to assign shifts based on qualifications, required coverage, hours limits, and fairness rotation. The system will also account for leave, training, and sick days, and allow importing previous rosters to guide future scheduling. The output will be a clean, editable schedule with validation and summaries. I will document each step and walk you through the logic so you can fully understand and maintain it. QUESTION: Which constraints are essential for the first version? Let’s build a scalable, user-friendly scheduling system together. Regards, Shehwani
$100 SGD in 1 day
4.8
4.8

Singapore, Singapore
Payment method verified
Member since May 2, 2026
$10-30 USD
₹12500-37500 INR
₹400-750 INR / hour
₹750-1250 INR / hour
$30 USD
$250-750 USD
₹600-1500 INR
€30-250 EUR
€250-750 EUR
₹600-1500 INR
$1500-3000 USD
₹1500-12500 INR
₹1500-12500 INR
$6-8 USD / hour
₹750-1250 INR / hour
$25-50 AUD / hour
$30-250 USD
₹1250-2500 INR / hour
₹600-1500 INR
$10-30 USD