Find Jobs
Hire Freelancers

Automated excel task - repost

$10-30 USD

Concluído
Publicado há mais de 10 anos

$10-30 USD

Pago na entrega
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?
ID do Projeto: 5336348

Sobre o projeto

16 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 2 dias
0,0 (0 avaliações)
0,0
0,0
16 freelancers estão ofertando em média $28 USD for esse trabalho
Avatar do Usuário
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 em 2 dias
5,0 (22 avaliações)
5,0
5,0
Avatar do Usuário
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 em 1 dia
5,0 (7 avaliações)
2,7
2,7
Avatar do Usuário
Propunerea nu a fost încă furnizată
$25 USD em 3 dias
5,0 (1 avaliação)
1,0
1,0
Avatar do Usuário
Will complete this task as per the time limit........................................................................................
$30 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello you forget to attach the excel , maybe in repost you forget it the general solution is using .net office control
$34 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Proposal belum diberikan
$25 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED KINGDOM
Nottingham, United Kingdom
5,0
5
Método de pagamento verificado
Membro desde set. 12, 2009

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.