Find Jobs
Hire Freelancers

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

$30-250 AUD

Terminado
Publicado hace más de 8 años

$30-250 AUD

Pagado a la 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 del proyecto: 8327965

Información sobre el proyecto

24 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
4,9 (29 comentarios)
4,4
4,4
24 freelancers están ofertando un promedio de $71 AUD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$100 AUD en 1 día
4,9 (194 comentarios)
7,2
7,2
Avatar del usuario
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 en 3 días
4,9 (65 comentarios)
5,7
5,7
Avatar del usuario
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 en 2 días
4,9 (56 comentarios)
5,6
5,6
Avatar del usuario
A proposal has not yet been provided
$75 AUD en 2 días
5,0 (49 comentarios)
5,5
5,5
Avatar del usuario
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 en 3 días
4,9 (40 comentarios)
5,0
5,0
Avatar del usuario
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 en 1 día
5,0 (31 comentarios)
4,9
4,9
Avatar del usuario
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 en 1 día
4,9 (18 comentarios)
4,6
4,6
Avatar del usuario
Hello. I have a great experience with macro. I can to do good work !
$50 AUD en 3 días
5,0 (28 comentarios)
4,5
4,5
Avatar del usuario
A proposal has not yet been provided
$88 AUD en 3 días
5,0 (23 comentarios)
3,5
3,5
Avatar del usuario
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 en 3 días
5,0 (4 comentarios)
2,7
2,7
Avatar del usuario
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 en 2 días
4,4 (3 comentarios)
1,9
1,9
Avatar del usuario
hi there... i can start immediately. am a hard worker and can give the best result for u. thank you.
$30 AUD en 1 día
4,9 (5 comentarios)
1,9
1,9
Avatar del usuario
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 en 2 días
5,0 (3 comentarios)
1,8
1,8
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,0
1,0
Avatar del usuario
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 en 2 días
5,0 (1 comentario)
0,5
0,5
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
very simple to do
$88 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Liverpool, Australia
4,8
5
Forma de pago verificada
Miembro desde ago 24, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.