Create a staff work rotation spreadsheet

Lukket Opslået 6 år siden Betalt ved levering
Lukket Betalt 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

Projekt ID: #15757912

Om projektet

28 bud Remote projekt Aktiv 6 år siden

28 freelancere byder i gennemsnit $29 timen for dette 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 Flere

$30 USD på 1 dag
(307 bedømmelser)
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 Flere

$30 USD på 1 dag
(71 bedømmelser)
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 Flere

$50 USD in 3 dage
(15 bedømmelser)
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. Flere

$25 USD på 1 dag
(21 bedømmelser)
4.5
AhmedHassan1122

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

$25 USD på 1 dag
(16 bedømmelser)
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 bedømmelser)
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 Flere

$20 USD på 1 dag
(14 bedømmelser)
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 dage
(18 bedømmelser)
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 Flere

$20 USD in 0 dage
(10 bedømmelser)
2.4
kgiridhari

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

$25 USD in 2 dage
(3 bedømmelser)
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 Flere

$100 USD in 15 dage
(2 bedømmelser)
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 Flere

$25 USD på 1 dag
(1 bedømmelse)
0.6
shonugiri1009

A proposal has not yet been provided

$20 USD in 2 dage
(0 bedømmelser)
0.0
nishu2207

A proposal has not yet been provided

$30 USD in 7 dage
(0 bedømmelser)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
0.0
sherinas03

A proposal has not yet been provided

$20 USD in 3 dage
(0 bedømmelser)
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 Flere

$20 USD in 2 dage
(0 bedømmelser)
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 bedømmelser)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
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 bedømmelser)
0.0