Making Excel -shift planner

Închis Postat la acum 1 an S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

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 Introducere date Procesare date Visual Basic Microsoft Office

ID Proiect: #34763803

Detalii despre proiect

70 propuneri Proiect la distanță Activ acum 1 an

70 freelanceri plasează o ofertă medie de 141$ pentru proiect

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 Mai multe

$180 USD în 4 zile
(598 recenzii)
8.5
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 Mai multe

$200 USD în 5 zile
(355 recenzii)
7.9
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 Mai multe

$98 USD în 1 zi
(267 recenzii)
7.3
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 Mai multe

$140 USD în 7 zile
(288 recenzii)
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 în 2 zile
(470 recenzii)
6.9
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 Mai multe

$100 USD în 1 zi
(228 recenzii)
7.3
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 Mai multe

$250 USD în 12 zile
(9 recenzii)
5.6
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 Mai multe

$50 USD în 2 zile
(10 recenzii)
4.9
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 Mai multe

$200 USD în 1 zi
(31 recenzii)
5.1
GKEvans

Hello, I would like to help you with your project. I have a BEng in Software Engineering and 15 years of experience working with Excel including developing macros. Thanks.

$140 USD în 7 zile
(3 recenzii)
4.9
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 Mai multe

$100 USD în 2 zile
(16 recenzii)
4.9
umairnoor32

Hello! I am expert and professional in this work, I have read all your details and I will work on your project with low price and unlimited revisions. Give me this project and get extraordinary and 100% work. Thanks ? Mai multe

$50 USD în 1 zi
(47 recenzii)
4.1
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 Mai multe

$100 USD în 1 zi
(21 recenzii)
4.3
Daksheshmahaur96

Hi There, As an Excel and VBA Developer, I can help you to make shift planning excel and i can do this according to your Condition and i can create a code accordingly so that you can handle easily. I have also worked Mai multe

$250 USD în 4 zile
(16 recenzii)
3.8
jeremytay

Hi there! Very thanks to your project because it well fits to my skills. I have watched your description carefully and got interested. Well as you can see I am a professional developer good at mentioned skills I have a Mai multe

$200 USD în 2 zile
(1 părere)
3.2
freelancer96500

Hi, I checked your requirement, i have Experience in below technical work. Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Excel Dashboard dynamically with V Mai multe

$200 USD în 5 zile
(3 recenzii)
2.5
MiguelMonteroADD

Hi I am a Certified Expert Data Analyst in Excel, I work with automations with VBA as well as database management with Power Pivot and Power Query. I can help you with the distribution of your employees automatically, Mai multe

$200 USD în 2 zile
(6 recenzii)
3.0
yousrymohamed11

Hi, I can do this Job. shift-planner in Excel as I am an Expert in using Excel and Performing Calculations as I have finished 3 Nanodegrees from UDACITY for Data Analysis using Excel and Python, In Addition to applyi Mai multe

$50 USD în 2 zile
(5 recenzii)
2.5
RobiDeLeon

hi! I am very interested in this project. I already finished a couple of excel projects and I know I can make this project as you want it to be. Data entry is one of my skills and based on the job description, I alrea Mai multe

$140 USD în 7 zile
(1 părere)
2.2
alaatarek7

Hey! I can help you in this job, I have already good experience in excel, I have also experience in data entry so once you choose me I will start working on that project. Send me more details so I can meet you needs a Mai multe

$140 USD în 4 zile
(2 recenzii)
1.8