Create a staff work rotation spreadsheet

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I’m trying to create a staff rota for a 3 month period for my team and there are a few rules.

I have been trying to do it manually but it is taking me ages to do so.. As an added bonus if it can take into account annual leave that would be even better.

Ideally, I am looking for a rota that can auto populate itself. If possible, I would like to include annual leave as one of the rules so that the spreadsheet does not give people shifts when they are off. This is not mandatory but it would be ideal.

One more big ask – if I have more staff joining, would it be possible to simply add their name to the list and the spreadsheet will autopopulate?

Please view the attached spreadsheet

Excel Excel Macros Excel VBA

Project ID: #15757912

About the project

28 proposals Remote project Active 6 years ago

28 freelancers are bidding on average $29 for this job

schoudhary1553

Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with exce More

$30 USD in 1 day
(307 Reviews)
7.9
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $30 More

$30 USD in 1 day
(71 Reviews)
5.5
hardikshah83

I can create a completely automated excel sheet for you where all your rules will apply. I am not sure how does the skill sheet work, but we can handle that. I will use VBA programming to achieve. Relevant Skills an More

$50 USD in 3 days
(15 Reviews)
5.1
ChinmoySarker

Hi, Being attracted with your declaration of the program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind mind and as soon as possible. More

$25 USD in 1 day
(21 Reviews)
4.5
AhmedHassan1122

Excel VBA Expert Relevant Skills and Experience Excel VBA Proposed Milestones $25 USD - Full Price

$25 USD in 1 day
(16 Reviews)
4.4
mikhailkozalski

hello if you hire me, i will complete your project perfectly. i saw your xlsx file. i can do it. Relevant Skills and Experience Excel, Excel Macros, Excel VBA Proposed Milestones $25 USD - 1

$25 USD in 1 day
(7 Reviews)
3.7
caprateekr

Hi, I would like to express my interest for the the work you posted, i can develop the sheet as per the requirements posted. This sheet will surely help you to: *Auto populate the results needed in regard to shifts of More

$20 USD in 1 day
(14 Reviews)
3.8
arslantahir87

i will make spreadsheet for ur project. please share ur details and requirements more. thanknu for ur contact in advance

$30 USD in 2 days
(18 Reviews)
4.0
Nicecreator

Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me Relevant Skills and Experience I have complited many data analytical work high quality and accuracy las More

$20 USD in 0 days
(10 Reviews)
2.4
kgiridhari

Hello, I am good in excel. You can contact to me for your job. Thanks.

$25 USD in 2 days
(3 Reviews)
2.4
nawazwasif

Hi there, instead of excel I offer you this project to be done in php or .net that will be more reliable and longlifed. Many things you mentioned in attachment are still required more detail. Relevant Skills and Exper More

$100 USD in 15 days
(2 Reviews)
1.8
anx1818

Hi, I can build a built-in macro to automate your 3-month rotation. It would only take 1 day for this work including the leaves. Relevant Skills and Experience Word, Excel and Powerpoint VBA and Java Programming Prop More

$25 USD in 1 day
(1 Review)
0.6
shonugiri1009

A proposal has not yet been provided

$20 USD in 2 days
(0 Reviews)
0.0
nishu2207

A proposal has not yet been provided

$30 USD in 7 days
(0 Reviews)
0.0
mzeeshankhan99

Hey, it’s me Zeeshan. I am data entry expert.I can provide you a reliable and on time Analysis support as per your requirement. My aim is to build trust able relationship with clients. Relevant Skills and Experience I More

$25 USD in 1 day
(0 Reviews)
0.0
sherinas03

A proposal has not yet been provided

$20 USD in 3 days
(0 Reviews)
0.0
LordDitler

Hey, this seems like an easy task we can make using excel or access. I would love to work on this. Just give me a quick shout out so we can discus this in more detail. Cheers, D. Relevant Skills and Experience Im a ne More

$20 USD in 2 days
(0 Reviews)
0.0
josuealberto777

I have experience as a Supervisor in Virtual Assistance and Customer Services and I was very proactive with my managers and giving new ideas as I learned to optimize the script and quality for customer care.

$17 USD in 1 day
(0 Reviews)
0.0
samforrest5

I have a high amount of experience in both excel and it's formula's and would be able to setup the sheet so if another member of staff was added it would automatically complete tasks. Relevant Skills and Experience M More

$25 USD in 1 day
(0 Reviews)
0.0
vsvinaysimha

Data entry,Excel, Relevant Skills and Experience Data entry,Excel, Proposed Milestones $25 USD - Data entry,Excel,

$25 USD in 1 day
(0 Reviews)
0.0