Automated excel task - repost

$10-30 USD

Completed

Posted

about 10 years ago

$10-30 USD

Paid on delivery

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?

Data Entry

Excel

Project ID: 5336348

About the project

16 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 2 days

0.0

(0 reviews)

0.0

16 freelancers are bidding on average $28 USD for this job

@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. Lets discuss and get on with it. I can understand how tedious it is to manually fill it up. Regards. Usman.

$60 USD in 2 days

5.0

(22 reviews)

5.0

@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 quality.

$30 USD in 1 day

5.0

(7 reviews)

2.7

@chbelt7

Propunerea nu a fost încă furnizată

$25 USD in 3 days

5.0

(1 review)

1.0

@Bimankumarmishra

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

$30 USD in 1 day

0.0

(0 reviews)

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 gone through your spreadsheet in your previous post and understood what you need to achieve, but just had one doubt. You have mentioned that there need to be at least two days off between each block of D12 or N12. However, in the example in Tab 1, this point is not followed everywhere. Please PM me so that we may discuss details further. Thanks.

$30 USD in 1 day

0.0

(0 reviews)

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 in 1 day

0.0

(0 reviews)

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 I have hands on experience in Accounts and Finance, furthermore I have worked on many data entry assignments, which give me edge over other freelancers applying for this very project. I assure you that I will not let you down once you give an opportunity to work with you. For the discussion boards, Let me tell that I have the best knowledge of such things, As a freelancer. I will discuss the whole requirements with you first to get clear understanding and then I will start working on my own and will give you my 100%. This is a Piece of cake for me Just give this opportunity to me and I believe that it will be a start of our long term relationship. I look forward to the positive response from your kind side. Regards, Saqib Iqbal Freelancer

$25 USD in 1 day

0.0

(0 reviews)

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 in 1 day

0.0

(0 reviews)

0.0

@UdanInfotech

A proposal has not yet been provided

$15 USD in 1 day

0.0

(0 reviews)

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 in 1 day

0.0

(0 reviews)

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 thought of it before you, and the IRS said no. Not only that, the courts said no too. Of course, your case could be different, but these are tough to win. In a case called Michael Oros, the Ninth Circuit Court of Appeals agreed with the Tax Court that Mr. Oros couldn’t write off his big trip on his taxes. Oros was a full-time employee of Intel. But he got the idea that a trip around the world and writing about it wouldn’t be bad. So in 2006, Mr. Oros began a long to South America, Asia, Africa, and Australia.

$25 USD in 1 day