Find Jobs
Hire Freelancers

Timetabling program

$250-750 USD

Completed
Posted almost 8 years ago

$250-750 USD

Paid on delivery
I want a timetabling program that allows me to allocate about 30 people to their workstations. The ones I found through simple googling had WAY too many features and were cumbersome to use. I want a simple program, where I specify certain rules for both workers, and workstations, and the program outputs an excel-file of the optimized timetable. The program can run on Excel, or be a standalone program, as long as it outputs and excel file or something equally familiar. Something akin to the Primetimetable -program used for scheduling school classes - but less features, and the user interface doesn’t have to be so friendly. Timetabling program rules: Workstation: for each workstation, specify who can work there, and who works there preferentially. (i.e. for Workstation 1: person A, person R, person Q - where now the Workstation1 is preferentially worked by A, and if he’s not available then R, and only then Q). Also, some workstations can be closed (if no worker is available) but some must always remain open. There should be a list of workstations that are closed preferentially (e.g. stations that can be closed: 1, 3, 4, 7, 8 - where now station 1 is the first one to close if required) Worker: for each worker, specify the workstations where he can work. (e.g. Person A: can work stations 1, 4, 6, and 7) And then a “Go!” -button, that establishes the “default state”, where all workstations are occupied by the “first choice -worker”, and the workstations that must always remain occupied, are occupied. The output should be a calendar, where the first cell of each row is the worker’s name, and the following cells specify his working station for the next month. Simple so far, I should hope. Now, there should be an option to tick off days when a person cannot work - e.g. when he is on holiday. IF he occupies a workstation that cannot be closed, another person is chosen to replace the one on holiday. The replacement person must be picked from a workstation that can be closed. If there are several possibilities, use the workstation’s “preferred people” to choose the worker. Similarly, I want to be able to close workstations, and the program should then relocate the person to another workstation where he can work. The key here is to keep moving people around to a minimum - it’s much better to close a station, than to relocate 10 people to optimize the preferences to each workstation. That I can do manually if required. This would get me well started. But to really make a difference, I should be able to group several workstations together and specify a rule for them, of the form “Between workstations 1, 2, 5, 6, 8, and 9 there must always be 1-2 of the people A, B, F, H, T, or Y working there” For these “grouping rules” each workstation will appear only once, but a person can appear in several groups. So, specify workstations, specify workers, click Go! to get the "default". Then tick off days when workstations are closed or people are on holiday, click "Go!" again to reschedule everything with minimal changes from the “default state”, to minimize moving people around. The result doesn’t have to be 100 % optimal, just close to it. Final adjustments will be made manually anyway. Could you program this to me? At what cost? Or if something like this already exists, please direct me to it, thank you!
Project ID: 10450718

About the project

22 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel, VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentations to board for a leading US bank. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
$250 USD in 10 days
4.6 (14 reviews)
3.9
3.9
22 freelancers are bidding on average $476 USD for this job
User Avatar
Hi, my name is Sevinc. I read your "Timetabling program" project descriptions carefully before bidding. Thank you for detailed explanations. I got what you need and ready to go ahead as soon as we can clarify further project details. I will write a vba code for excel, so you run all the relevant business within a given excel workbook. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. 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, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$475 USD in 5 days
4.9 (230 reviews)
7.4
7.4
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, models and macros. Check my reviews. They speak for themselves. Best regards
$555 USD in 10 days
5.0 (173 reviews)
6.7
6.7
User Avatar
A proposal has not yet been provided
$500 USD in 10 days
4.9 (215 reviews)
6.8
6.8
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$400 USD in 7 days
4.8 (180 reviews)
7.1
7.1
User Avatar
HI there. I would be glad to help you out with this project. I am a professional programmer, with experience building excel dashboards such as the one you need. I appreciate the quality of the project description as it is pretty clear what you are looking for. I can achieve what you want and deliver as soon as possible. Hope to hear back from you soon. Thanks, Daniel
$500 USD in 10 days
4.8 (84 reviews)
6.7
6.7
User Avatar
I love to do this job. I like optimization problems, and I like scheduling problems, so I understand all the functionalitys that you need to be implemented. I think of something simple in Excel, using VBA and the solver to optimize the preferences, obtaining a final schedule for each person and each workstation. I can add the options you want through formulas. For example, you can group the workstations if you just optimize groups of workstations in replace of just workstation, where the trivial case is that the group contains only 1 workstation. All I need to start with this is some example of the file, or something like that. Just a simple dummy file with 3 sheets: the first with the raw data, the second with the rules interface (or something like that), and the third, the output. The second is not really important, and I can design it for you. If you are interested in hire me, just write a message so we can discuss the details of this job. Thanks!
$388 USD in 10 days
4.8 (17 reviews)
4.1
4.1
User Avatar
I have written a complex Python script like this. Please check my portfolio (Python Script for Sales Report) I am 30 years old software developer. I have a BS in Computer Science. I am fluent in English. I am very good with Python, PHP and Java. Please feel free to pm me.
$250 USD in 5 days
4.9 (8 reviews)
4.0
4.0
User Avatar
Hi, I'm relatively new to freelancing, but I have 19 years of experience in IT and software development. What you're asking for seems relatively straightforward: -Create a simplified timetable program (simpler than Prime Timetable) to schedule workers to workstations and output the result to an Excel file (first cell of each row is worker; next cells are workstation assignments for month). -The rules, as I understand, are: -Workstations are assigned workers preferentially (i.e. weighted) -Workstations can be closed (preferentially) if no worker available -Some workstations must remain open -Workers are assigned a list of "can work" workstations -"Grouping Rules" can be used to ensure workstation groups have a minimum selection of workers -The above rules create the "default state". -Additional modifications to the schedule (eg. worker unavailable) minimize worker relocations. -Manual final adjustments can be made. I propose the following: -I assume the platform is Windows based (by reference to Excel and standalone program), not a web app; my bid is based on that assumption (let me know otherwise). -A standalone Windows based app coded in Delphi implementing the above scheduling functionality with a simple GUI interface that saves information into a SQLite data store (for data persistence). The app "exports" the timetable to an Excel spreadsheet. If you'd like to discuss further, I'd be happy to do so. Looking forward to providing you my services. Regards, Gavin
$500 USD in 10 days
5.0 (1 review)
3.3
3.3
User Avatar
I have a lot of experience with Python. Reading your requirements I think I should be able to do it. Just have more questions about it so please contact me with more details about it.
$400 USD in 10 days
4.9 (10 reviews)
3.1
3.1
User Avatar
Greetings! I have 15+ year experience with MS Excel/Access/VBA, so I can meet the strongest requirements in this respect. I don't think it is necessary to create side application that will export data to Excel, everything needed must be created inside Excel instead. So, the result file could contain: - tabs with input data like workplaces, users/groups, rules etc - dashboard for a lookup and initiating creating of a month schedule - month schedules created with possibilities to tune while approving planed schedule for coming month as well as for making changes in case of some circumstances Looking forward for more details regarding your expectations. Please feel free to contact me. Regards, Sergey
$500 USD in 14 days
4.4 (6 reviews)
3.2
3.2
User Avatar
Hi Please consider me for your job. I am very resourceful and I am sure that I am capable of meeting your needs. I currently work in the insurance field as an IT systems analyst and we provide support for software that does something similar to what you would like to create. So I have experience and knowledge with systems that manage and optimize workflow based on roles and indicators that are linked to individuals. Thanks and regards
$350 USD in 5 days
5.0 (8 reviews)
3.0
3.0
User Avatar
That sounds like a lot of fun! Please check my ratings as an employer here... I don't take jobs usually, but I'd really like to put my python skills to use for something that actually matters - something that will be used. Here is what I propose and can do: I suggest we make it excel based. You will be able to have a master excel file, for which I help you figure out the best, lean, and intuitive layout to enter/change all data. Workstations, ones that may be closed, preferred workers for stations, vacation days, grouping of workstations ect ect. Whatever you like. I would suggest we design the program in a way that you don't have to come back and mark people on leave ect and run it twice. We should design a nice input excel sheet in a way that all the information is there. Then I'll write you a python code, which you simply execute by double clicking on it. That's it. No buttons, inputs ect. It will create you a separate excel file within a second or so with all your schedules. The code will be highly flexible, meaning we can easily do any changes you like. My offer includes the grouping of workstations you mentioned in the lower part of your description. I estimate that I can get everything done within 5 days max. Most likely faster. I anticipate the result to be 100% optimal.. if not something is wrong. I'm looking forward to hearing from you to discuss the details! Cheers, Stefan
$250 USD in 10 days
5.0 (1 review)
2.0
2.0
User Avatar
Hi, I'm very interested in this project, which I can accomplish due to my knowledge and experience. I'm thinking of few possibilites as solutions. Thank you for your time. Kind regards, Cerim
$300 USD in 7 days
5.0 (3 reviews)
1.6
1.6
User Avatar
Hi, I can write this as a routine inside the Excel file itself. I teach in Excel training classes and this will be a good task for me to try. I will provide a button on the Excel sheet and when you click it my routine will run and give you the time table. Please give me an idea regarding how many workstations you are thinking to have. Regards, Anil
$500 USD in 10 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i will prepare following things for you - Technical Project Proposal - Flow chart for this Project - Execution plan (Step by step procedure with explanation how and at what that we are going to execute a particular task)
$773 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FINLAND
Turku, Finland
5.0
1
Payment method verified
Member since May 9, 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.