Закрыт

Making Excel -shift planner

Hi there!

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.

Навыки: Excel, Ввод данных, Обработка данных, Visual Basic, Microsoft Office

О клиенте:
( 7 отзыв(-а, -ов) ) Ås, Norway

ID проекта: #34763803

73 фрилансеров(-а) готовы выполнить эту работу в среднем за $141

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Больше

$180 USD за 4 дней(-я)
(569 отзывов(-а))
8.5
(606 отзывов(-а))
8.1
bouslimi1979

Hello, I can provide the Excel app with VBA macros where you can put the employee list, and the calendar will be generated. I just need a sample output file you want to get, even a draft so we can start from there. Tha Больше

$200 USD за 5 дней(-я)
(353 отзывов(-а))
7.9
(337 отзывов(-а))
7.4
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel VBA Macro Coding, Formula Generation and Automation/scripting. Developing and designing complicated VBA/Macro programs are part and parcel of my da Больше

$140 USD за 7 дней(-я)
(287 отзывов(-а))
7.2
rohitagarberg

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

$100 USD за 2 дней(-я)
(462 отзывов(-а))
6.8
AccountantArman

"""""""""""""""""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 Больше

$98 USD за 1 день
(213 отзывов(-а))
6.8
daniyal3214

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 Больше

$100 USD за 1 день
(193 отзывов(-а))
7.1
(121 отзывов(-а))
6.5
(214 отзывов(-а))
6.6
SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including the solving task of Больше

$150 USD за 3 дней(-я)
(126 отзывов(-а))
6.6
(64 отзывов(-а))
6.1
(55 отзывов(-а))
6.2
(112 отзывов(-а))
6.9
sohailhost

Hi, this is Ahmed. Bidding Executive, SA Solutions Providers (Already Verified and Preferred Freelancers with good ratings and clientele feedback). We have read the project details and are confident that our experien Больше

$250 USD за 12 дней(-я)
(9 отзывов(-а))
5.6
(40 отзывов(-а))
5.2
huzaifarizwan995

I am an accounting,STATS, economics, marketing and finance and excel expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad ran Больше

$50 USD за 2 дней(-я)
(9 отзывов(-а))
4.8
hritikdanng

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 Больше

$200 USD за 1 день
(25 отзывов(-а))
4.9
ismail80196

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 Больше

$100 USD за 1 день
(18 отзывов(-а))
4.2
anenkovakateryna

✅✅✅ Experiences in Excel VBA ✅✅✅ Hi, Dear! I have a full experiences and knowledge in Excel VBA for plan management. I read your requirement carefully and so I can do your work perfectly. I can start Your work right n Больше

$100 USD за 2 дней(-я)
(7 отзывов(-а))
4.1