Find Jobs
Hire Freelancers

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

$30-250 AUD

Completed
Posted over 8 years ago

$30-250 AUD

Paid on delivery
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.
Project ID: 8327965

About the project

24 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

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:
User Avatar
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 in 3 days
4.9 (29 reviews)
4.4
4.4
24 freelancers are bidding on average $71 AUD for this job
User Avatar
A proposal has not yet been provided
$100 AUD in 1 day
4.9 (194 reviews)
7.2
7.2
User Avatar
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 in 3 days
4.9 (65 reviews)
5.7
5.7
User Avatar
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 in 2 days
4.9 (56 reviews)
5.6
5.6
User Avatar
A proposal has not yet been provided
$75 AUD in 2 days
5.0 (49 reviews)
5.5
5.5
User Avatar
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 in 3 days
4.9 (40 reviews)
5.0
5.0
User Avatar
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 in 1 day
5.0 (31 reviews)
4.9
4.9
User Avatar
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 in 1 day
4.9 (18 reviews)
4.6
4.6
User Avatar
Hello. I have a great experience with macro. I can to do good work !
$50 AUD in 3 days
5.0 (28 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$88 AUD in 3 days
5.0 (23 reviews)
3.5
3.5
User Avatar
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 in 3 days
5.0 (4 reviews)
2.7
2.7
User Avatar
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 in 2 days
4.4 (3 reviews)
1.9
1.9
User Avatar
hi there... i can start immediately. am a hard worker and can give the best result for u. thank you.
$30 AUD in 1 day
4.9 (5 reviews)
1.9
1.9
User Avatar
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 in 2 days
5.0 (3 reviews)
1.8
1.8
User Avatar
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 in 1 day
5.0 (2 reviews)
1.0
1.0
User Avatar
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 in 2 days
5.0 (1 review)
0.5
0.5
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
very simple to do
$88 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Liverpool, Australia
4.8
5
Payment method verified
Member since Aug 24, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.