Find Jobs
Hire Freelancers

a macro written for sorting time based data that needs to be averaged with rules

$30-250 AUD

Concluído
Publicado há mais de 8 anos

$30-250 AUD

Pago na entrega
I have 6 columns of data, each with about 3000 rows. I need to average the results of 4 of these columns. Limits need to be applied eg 11pm-3am. However, then whenever an event happens that scores in the activity column more than 3, I need that reading at that time point removed as well as for 5 mins before and after.
ID do Projeto: 8327965

Sobre o projeto

24 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
Appears to be a simple job. Please attach the spreadsheet. I did not quite understand "limits need to be applied". The spreadsheet may clarify this.
$30 AUD em 3 dias
4,9 (29 avaliações)
4,4
4,4
24 freelancers estão ofertando em média $71 AUD for esse trabalho
Avatar do Usuário
A proposal has not yet been provided
$100 AUD em 1 dia
4,9 (194 avaliações)
7,2
7,2
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, models and macros. Check my reviews. They speak for themselves. Best regards
$140 AUD em 3 dias
4,9 (65 avaliações)
5,7
5,7
Avatar do Usuário
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
$55 AUD em 2 dias
4,9 (56 avaliações)
5,6
5,6
Avatar do Usuário
A proposal has not yet been provided
$75 AUD em 2 dias
5,0 (49 avaliações)
5,5
5,5
Avatar do Usuário
I am Chartered Management Accountant as well as an expert in VB programming & Excel Macros, having 6 years of practical experience. We can help you with the requirements though we will be needing some further information. Awaiting your response, Cheers, AHK
$100 AUD em 3 dias
4,9 (40 avaliações)
5,0
5,0
Avatar do Usuário
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$54 AUD em 1 dia
5,0 (31 avaliações)
4,9
4,9
Avatar do Usuário
Hi, We are experts in Excel based designing, data processing, VBA coding etc. We can do this job quickly for you. Kindly let me know the details of it. Regards, Pal
$35 AUD em 1 dia
4,9 (18 avaliações)
4,6
4,6
Avatar do Usuário
Hello. I have a great experience with macro. I can to do good work !
$50 AUD em 3 dias
5,0 (28 avaliações)
4,5
4,5
Avatar do Usuário
A proposal has not yet been provided
$88 AUD em 3 dias
5,0 (23 avaliações)
3,5
3,5
Avatar do Usuário
Hi, Based on the requirement of the project, I am excited to work for you on this project. I am writing VB code for various project since 2004 and I just love Macro development for Excel. The project is similar to the one completed earlier. So, by hiring me you'll have the advantage to Skill as well as experience. Let me know if my services interests you. Thanks Lal
$55 AUD em 3 dias
5,0 (4 avaliações)
2,7
2,7
Avatar do Usuário
I am a MS office certified professional. and an expert data entry Freelancer with a professional experience of 4 years and expertise in MS Excel, Word or whole MS Office related tasks,. I have very good knowledge of Macros and VBA coding. I can do it ASAP I can right away start this project and can complete within your deadline with 100% accuracy , quality work and timely deliverable. Let me when we can discuss ASAP
$138 AUD em 2 dias
4,4 (3 avaliações)
1,9
1,9
Avatar do Usuário
hi there... i can start immediately. am a hard worker and can give the best result for u. thank you.
$30 AUD em 1 dia
4,9 (5 avaliações)
1,9
1,9
Avatar do Usuário
Dear Client, I have a lot of experience with VBA and Excel. I can complete this project without any problems. Send me a message for more information. Kind Regards, Rens Slenders SlenDATA
$60 AUD em 2 dias
5,0 (3 avaliações)
1,8
1,8
Avatar do Usuário
Good Day Sir, I am a IT Professional with 6 years of experience in Excel, VBA/Macros working with Accenture Services Pvt Ltd(Proof of employment available). Please see my feedback and reviews I will be able to assist you with the request. Please ping me to discuss the same in detailed, I will respond as soon as possible. My primary goal here is to build a long working relationship with my employers and to deliver a quality solution exceeding their expectations, and also to achieve a 5* Feedback. Hopefully I will get an opportunity to work with and for you. Regards, Mohammad Faisal
$30 AUD em 1 dia
5,0 (2 avaliações)
1,0
1,0
Avatar do Usuário
Hello, in interesting into your project which match with my experiences. I placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. I will create macro do the jobs as per your requirement Appreciate If you would like to talk thru PM before awarding this project as I'm online now. Hope to hear from you soon. Thank & Regards, gsanggara
$50 AUD em 2 dias
5,0 (1 avaliação)
0,5
0,5
Avatar do Usuário
I am software engineering student you can rely on me for your requirement. I can build macro according to your requirement let's discuss the project.
$50 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
very simple to do
$88 AUD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I can do a really good job if given a chance to prove the quality of my work.I know that the work will be perfect and quality of work the best
$155 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have been working with VBA for more than two years for companies like IBM, MSCI and Ford Motor Company. As I am new on Freelancer I am ready to do the job on low price for positive feedback.
$35 AUD em 1 dia
5,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
Being qualified and having worked on these kind of projects earlier as part of my regular job, I would like to be graced with this offer. I am ready to work on this project at the lowest possible price to earn my client's goodwill. I will complete this task with my ability in Excel as I already have the experience of Excel-VBA. Regards Vinod Gupta
$30 AUD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Liverpool, Australia
4,8
5
Método de pagamento verificado
Membro desde ago. 24, 2015

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.