I need to make a shift-planner in Excel.
Here is the problem:
- I have a number of employees that only work night-shift.
- I have more shift-employees than I have days for them to work.
- I need a Excel -document to distribute the shifts equally amongst them, so it is fair.
- Each shift is parted into 2 categories: shift and bonus.
- Bonus is only used if there is enough to do. Normally there will only be one. This should make it easier to make it fair.
Here is what I need:
- Possibility to enter all my employees in a list
- Choose what days I want them to work (Monday - Friday)
- Make the excel document automatically distribute my employees into "shift and bonus", and put the shifts into a calendar.
- The calendar should be able to update when 'year' is changed.
Feel free to use a template. I really don't care what you do as long as it works as intended.
Bonus; If the document could fetch data and picture from another Excel file, and show their picture in the calendar, that would be great. We can look at this once we solve the first issues.
Bu iş için 74 freelancer ortalamada $141 teklif veriyor
Hi there...i am an expert in excel and i have understood your project very well..i can make it exactly as per your requirement this excel..lets discuss in chat further..thanks
Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Daha Fazla
"""""""""""""""""EXCEL EXPERT""""""""""""""""""""" "Sir, I am Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than Daha Fazla
I'm expert in MS Excel have prepared more than 100 roster plans and please check my profile for the same. About me, I'm Chartered Acccountant from Institute of the Chartered Accountants of India ( Top recognised body Daha Fazla
Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I am ready to start work right now and can assure the best service from my end. Waiting for your good res Daha Fazla