Find Jobs
Hire Freelancers

Create an Excel file

$10-30 USD

Concluído
Publicado há mais de 9 anos

$10-30 USD

Pago na entrega
Create an excel file following the structure of supplied file to produce calculated values in the dated area (Q1 to CNxx). Code Logic: if headerdate=(startdate+activitydays),insertvalue of sum(quant/activityrate),"null") Long-Hand Description: IF the headerdate [as known from the first cell of this column] EQUALS the startdate [as known from the cell in the same row in the fifth column] PLUS the activitydays [as known from the associated croptype range determined from selectable named dropdown list from same row in the second column [croptype range on same sheet] THEN insert the value of the sum of the Quantity [as known from cell in the same row in the fourth column] DIVIVED BY the activityrate [as known from the associated croptype range determined from selectable named dropdown list from same row in the second column [different row as the acivitydays] OTHERWISE leave cell blank. sample hard-coded values in row 8 and 9. Column F to P hidden in normal use. Unless a better method can be achieved easier
ID do Projeto: 7037737

Sobre o projeto

14 propostas
Projeto remoto
Ativo há 9 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
Hello, I think I could complete this project. I could upload a YouTube video tommorow where you could see if it is done properly. I have a question whether the cells are valid values: Q9 (1) AD8 (null) AL8(empty) etc. Best Regards Jan Krzyzak
$30 USD em 3 dias
5,0 (6 avaliações)
3,0
3,0
14 freelancers estão ofertando em média $37 USD for esse trabalho
Avatar do Usuário
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to discuss with you about the project.
$50 USD em 0 dia
4,9 (261 avaliações)
7,2
7,2
Avatar do Usuário
A proposal has not yet been provided
$48 USD em 1 dia
4,9 (141 avaliações)
6,8
6,8
Avatar do Usuário
hey there - please share the excel file that you are using now...we like to have a look at it before we start..please reply...thank you...
$45 USD em 1 dia
4,8 (86 avaliações)
5,3
5,3
Avatar do Usuário
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Quick turnaround. Rgds Rohit Pithisaria
$30 USD em 1 dia
4,9 (37 avaliações)
4,8
4,8
Avatar do Usuário
A proposal has not yet been provided
$25 USD em 1 dia
4,9 (27 avaliações)
4,7
4,7
Avatar do Usuário
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$50 USD em 3 dias
4,9 (25 avaliações)
4,6
4,6
Avatar do Usuário
I can do this. See my profile and reviews, contact me if you're interested. Thanks_________________________________________________________________
$45 USD em 1 dia
4,9 (22 avaliações)
4,6
4,6
Avatar do Usuário
I have completed many tasks in Excel. I can sure do this one also. However, some seems amiss in you long hand description. First the number of opening square brackets [ is not equal to the closing square brackets ]. I am unable to find out what the activity rate is. Is it the numbers (plants/hr) in the second row?
$25 USD em 1 dia
4,9 (23 avaliações)
4,4
4,4
Avatar do Usuário
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: Please more info in PM if you are interested. Thank you. :) I await your reply. With Kind Regards Boris
$50 USD em 1 dia
5,0 (1 avaliação)
1,9
1,9
Avatar do Usuário
I have very extensive knowledge and experience (16 years) with Excel and VBA coding. The project that you describe is very simple and I believe that I've bid accordingly. I hope to have the opportunity to work with you.
$20 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$55 USD em 2 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) CANADA
Langley, Canada
5,0
5
Membro desde set. 17, 2008

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.