Do some Excel Work
£20-250 GBP
Pago na entrega
Attached is a document that provides some analysis of colleagues shift patterns. You can see you paste the data into the Paste 1 and Paste 2 tab. It creates an output by using the control tab and then a summary screen to show how many colleagues are working in each slot. You can see at the bottom it present a 'match score' that tells me what the most and least number of colleagues are working during a number of weeks.
You can see there are some big differences in the example data. My aim is to increase the scores by moving colleagues shifts to reduce the difference in the numbers and create a better balance in the rotations
I would like paste 1 to remain as the base data but the paste 2 sheet to reflect the optimal changes to shifts to increase the score as much as possible. We should be able to show a before and after. The sheet should try different combinations until it gets to the best one.
WE cannot ask the colleagues to change their hours but we can move their shift rotation i.e move their pattern to the left or the right but it has to be in FULL weeks and the order of their pattern cannot be changed. You can see on Paste 2 i have moved colleague 3 to the right by 1 week manually. i.e moved 1st week (19th June) to the right and then moved the last week back to week 1 to keep the pattern going. As a result you can see that the colleague has come out of Saturday 1 July as their Saturdays now fall another week.
Making moves like that across the colleagues we should be able to balance out and reduce the differences.
The scores need to be as high as possible with the fewest moves. The sheet should confirm who has been moved.
ID do Projeto: #14369952
Sobre o projeto
23 freelancers estão ofertando em média £130 nesse trabalho
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o Mais
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the informatio Mais
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.
Hello Sir Im excel VBA macro and formula Expert :) i can do this job Relevant Skills and Experience my main skill is excel VBA macro and formula Excel Proposed Milestones £150 GBP - after job completed
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in optimization of business processes and schedules in Excel using custom dashboards, macros (VBA scripts), Mais
I am a professional Freelancer. I would like to work on this project. I have done a lot of similar project of this. Feel free to let me know if you would like to look a sample Relevant Skills and Experience I am a pr Mais
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Mais
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills an Mais
I’ve 5 years of experience of MS Excel especially with pivot tables, charts, advance formulas and VBA codes. Relevant Skills and Experience MS Excel Proposed Milestones £150 GBP - Upon Completion I've read the detai Mais
I have experience in Microsoft Office suite and use Microsoft Excel as my daily spreadsheet software. I have also experience in research Relevant Skills and Experience excel Proposed Milestones £111 GBP - Excel Work
Dear client we can provide complete solution on your project as we have executed it before. Relevant Skills and Experience excel Proposed Milestones £28 GBP - initial
We are team of excel experts who have done various jobs of macros and vba related tasks. Relevant Skills and Experience Excel, vba and macros Proposed Milestones £80 GBP - Project completion
Dear, Thank for very detail request .I know how to do to make it done. Could help you finish this project with high quality.
The amount I have bid is fully negotiable. The employer has the last say in what i get paid. Relevant Skills and Experience I have skills and experiences in data entry, excel, and other spreadsheet packages. I strive Mais