Do some Excel Work

Ukončen Zveřejněno před 6 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

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.

Excel

Identifikační číslo projektu: #14369952

O projektu

23 nabídek Projekt na dálku Aktivní před 6 lety

23 Freelnceři na tento projekt zveřejňují nabídky v průměru £130

asin1987

Dear Employer, I will work any formula, function, calculation, modification, automation. PFA my previous automation works for reference. I have done lot of complex formula building works. Relevant Skills and Experien Další

£250 GBP za 3 dní
(202 Recenzí)
7.8
schoudhary1553

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 Další

£150 GBP za 3 dní
(353 Recenzí)
8.0
mirniyazuddin92

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 Další

£142 GBP za 3 dní
(335 Recenzí)
7.9
P0L

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.

£150 GBP za 3 dní
(401 Recenzí)
7.6
prameswara

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

£150 GBP za 3 dní
(378 Recenzí)
7.3
cugamelover

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), Další

£130 GBP za 3 dní
(173 Recenzí)
7.1
flashsaiful

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 Další

£150 GBP za 3 dní
(141 Recenzí)
6.6
avinav606lx

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. Další

£200 GBP za 3 dní
(161 Recenzí)
6.4
axiomswb

we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience web scraping , Excel VBA , Další

£100 GBP za 2 dní
(44 Recenzí)
6.3
The24CarrotsInc

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 Další

£100 GBP za 3 dní
(56 Recenzí)
5.8
awaisjahangir25

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 Další

£150 GBP za 3 dní
(35 Recenzí)
5.3
HetoChakma

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

£111 GBP za 7 dní
(14 Recenzí)
4.4
mzdesmag

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

£28 GBP za 1 den
(5 Recenzí)
3.9
Goalaholic

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

£80 GBP za 3 dní
(18 Recenzí)
3.9
ketas

Dear, Thank for very detail request .I know how to do to make it done. Could help you finish this project with high quality.

£100 GBP za 2 dní
(13 Recenzí)
3.9
ktanmay011

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 Další

£111 GBP za 3 dní
(0 Recenzí)
0.0
suresh412raj

Please send the sheet and get the task done before 27th June.

£150 GBP za 5 dní
(0 Recenzí)
0.0