Lengkap

Automated excel task - repost

Hi,

This excercise may not even be able be possible but I am trying to prevent a very very time consuming manual task!

I have a spreadsheet (attached). The sheet covers 72 people (U7:CN7) and the timeframe of 2014(Q8:Q372).

Each day needs a certain demand ( Column R) and this means that column R needs an equal number of days shifts (D12) and night shifts(N12). For example 01/01/14 requires 7 made up of 7 D12 and 7 N12 etc etc throughout the year.

Other criteria, each person needs to do roughly the same amount of D12 and equally the same amount of N12. So i wouldn't want to see one person doing 30 N12 and another doing 50 N12 etc. The stats panal at the top of theshift automatically how many D12 and N12 have been inputted into the sheet. Column S and T automatically counts the number of D12 and N12 shifts have been inputted into the orange cells.

D12's should not be mixed in with N12 and hence a person should have a min of 2 N12 and a maximum of 2 D12 ina "block".

What is filled in tab 1 should sort of explain.

Also, wherever possible D12 blocks should be. followed by N12 blocks and then followed by D12 etc.

Each person should have at leat 2 days off between each block of D12 or N12.

Tab 2 is blank canvas and this is what needs completing (orange cells)

Please DO NOT bid unless you actually understand the requirment as i have already wasted 2 hours this morning :)

Macro maybe?

Kemahiran: Pemasukan Data, Excel

Lihat lagi: what is manual data entry, ina t, excel macro how to, what is macro in excel, excel stats, excel macro sort, sort macro, excel 2014 macro, excel maximum column, excercise, shifts days, min sheet excel, excel automated sort, night data excel, repost macro, excel task, task spreadsheet, number excel macro, spreadsheet excercise, macro sort spreadsheet

Tentang Majikan:
( 5 ulasan ) Nottingham, United Kingdom

ID Projek: #5336348

Dianugerahkan kepada:

analyzer25

There are some details that I need to know to start working on it and submit a partial accomplishment, or the manner it will be done, along with my proposal. I hope you can attach the spreadsheet. Thank you.

$25 USD dalam 2 hari
(0 Ulasan)
0.0

16 pekerja bebas membida secara purata $28 untuk pekerjaan ini

maverick44000

Hi Simon. I have been doing very similar tricky tasks before and I believe I can come up with a solution for your problem too. I have read the description and VB macros seems to be the only way to get it automated. Let Lagi

$60 USD dalam 2 hari
(22 Ulasan)
5.0
safiqulislam67

Hello, I can very well understand that I am very new here and my profile shows that also. But I have vast experience in working on another site. You will have the details about my ability in doing this type of work. Pl Lagi

$30 USD dalam sehari
(5 Ulasan)
2.9
rakeshkr552

I have examined the details provided and may be suitable to conduct the job. I am ready to start the job. I can send work samples if need. I expect your PM to discuss more [login to view URL] you

$25 USD dalam sehari
(4 Ulasan)
2.9
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Lagi

$30 USD dalam sehari
(7 Ulasan)
2.7
chbelt7

Propunerea nu a fost încă furnizată

$25 USD dalam 3 hari
(1 Ulasan)
1.0
Bimankumarmishra

Will complete this task as per the time limit........................................................................................

$30 USD dalam sehari
(0 Ulasan)
0.0
simalik92

I am an expert user of MS Excel and was awarded with a "Top in the World" award for ICT by the University of Cambridge. I have worked on many macros in the past and think I will be able to this task fairly well. I have Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
cyruszargar

Hello you forget to attach the excel , maybe in repost you forget it the general solution is using .net office control

$34 USD dalam sehari
(0 Ulasan)
0.0
indu0806

I'm a professional Data Entry Operator with 2 years experience on MS Word 2003/2007 and Excel 2003/2007. Having expert typing speed with excellent vocabulary skills in [login to view URL] a great eye for detail. A trustworthy Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
saqibiqbal85

Dear Sir, Hope everything is fine at your end. Reference to your requirements of project you posted, I hereby take the opportunity to offer my services for this project. As you can look into my credentials that Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
ruwaniranasinghe

I can do your tasks. Please send me your details. If you give me the job I will do my best.I have 10 year experience in work with excel.

$25 USD dalam sehari
(0 Ulasan)
0.0
UdanInfotech

A proposal has not yet been provided

$15 USD dalam sehari
(0 Ulasan)
0.0
olaf105

Hi, I'm new here and looking for work. I'm more than capable of doing this job. I can send you a sample of my work if you want. Thanks!

$25 USD dalam sehari
(0 Ulasan)
0.0
rezmaster

i can do this because i've experience do data entry images. You have to admit it sounds awfully good. Travel the world, write your experiences, and write off all your expenses on your taxes. Trouble is, someone thou Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
Lidda

Proposal belum diberikan

$25 USD dalam 3 hari
(0 Ulasan)
0.0