Create a staff work rotation spreadsheet

Lukket Lagt ut 6 år siden Betales ved levering
Lukket Betales ved levering

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

Prosjekt-ID: #15757912

Om prosjektet

28 bud Eksternt prosjekt Aktiv 6 år siden

28 frilansere byr i gjennomsnitt $29 for denne jobben

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 Mer

$30 USD på 1 dag
(307 Omtaler)
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 Mer

$30 USD på 1 dag
(71 Omtaler)
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 Mer

$50 USD på 3 dager
(15 Omtaler)
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. Mer

$25 USD på 1 dag
(21 Omtaler)
4.5
AhmedHassan1122

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

$25 USD på 1 dag
(16 Omtaler)
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 på 1 dag
(7 Omtaler)
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 Mer

$20 USD på 1 dag
(14 Omtaler)
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 på 2 dager
(18 Omtaler)
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 Mer

$20 USD på 0 dager
(10 Omtaler)
2.4
kgiridhari

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

$25 USD på 2 dager
(3 Omtaler)
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 Mer

$100 USD på 15 dager
(2 Omtaler)
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 Mer

$25 USD på 1 dag
(1 anmeldelse)
0.6
shonugiri1009

A proposal has not yet been provided

$20 USD på 2 dager
(0 Omtaler)
0.0
nishu2207

A proposal has not yet been provided

$30 USD på 7 dager
(0 Omtaler)
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 Mer

$25 USD på 1 dag
(0 Omtaler)
0.0
sherinas03

A proposal has not yet been provided

$20 USD på 3 dager
(0 Omtaler)
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 Mer

$20 USD på 2 dager
(0 Omtaler)
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 på 1 dag
(0 Omtaler)
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 Mer

$25 USD på 1 dag
(0 Omtaler)
0.0
vsvinaysimha

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

$25 USD på 1 dag
(0 Omtaler)
0.0