Ditutup

Create a staff work rotation spreadsheet

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

Kemahiran: Excel, Excel Macros, Excel VBA

Lihat lagi: vba create spreadsheet xml, create spreadsheet gathering emails, wordpress create spreadsheet, rotating shift schedule template, monthly employee shift schedule template, rotating schedule maker, shift rotation calculator, team rotation schedule template, weekly employee shift schedule template excel, monthly employee schedule template excel, 24 7 shift schedule template, php, mysql, css, html, sql, .net, javascript, microsoft excel, create spreadsheet form

Tentang Majikan:
( 22 ulasan ) San Fernando, Trinidad and Tobago

ID Projek: #15757912

29 pekerja bebas membida secara purata $28 untuk pekerjaan ini

SShtv

Your task is clear to me and I am ready to solve it. I have successful experience performing similar work. Relevant Skills and Experience For example, I bring screenshots of some of my work done. https://drive.google. Lagi

$25 USD dalam sehari
(57 Ulasan)
5.6
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 Lagi

$30 USD dalam sehari
(67 Ulasan)
5.3
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 Lagi

$50 USD dalam 3 hari
(15 Ulasan)
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. Lagi

$25 USD dalam sehari
(17 Ulasan)
3.6
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 dalam sehari
(7 Ulasan)
3.6
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 Lagi

$20 USD dalam sehari
(9 Ulasan)
3.2
JackieXu

. Relevant Skills and Experience . Proposed Milestones $25 USD - .

$25 USD dalam sehari
(37 Ulasan)
3.8
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 Lagi

$100 USD dalam 15 hari
(2 Ulasan)
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 Lagi

$25 USD dalam sehari
(1 Ulasan)
0.7
AhmedHassan1122

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

$25 USD dalam sehari
(16 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
0.0
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 Lagi

$30 USD dalam sehari
(251 Ulasan)
0.0
vsvinaysimha

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

$25 USD dalam sehari
(0 Ulasan)
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 Lagi

$25 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
arslantahir87

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

$30 USD dalam 2 hari
(16 Ulasan)
0.0
$25 USD dalam 0 hari
(0 Ulasan)
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 Lagi

$20 USD dalam 2 hari
(0 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
0.0
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc Lagi

$30 USD dalam sehari
(60 Ulasan)
0.0