Find Jobs
Hire Freelancers

I need an Excel Guru

$30-250 USD

Closed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
I have to track when an aircraft takes off, reaches it's highest point, and lands, which is considered one cycle. Then the same cycle has to be measured therefore, one flight could have 30 cycles. Altitude (ALT) information is found in column "I." You will see a plane takeoff at 6535 then land at the same altitude. I would like this to be done in VBA to help automate this process.
Project ID: 20358102

About the project

14 proposals
Remote project
Active 5 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
14 freelancers are bidding on average $121 USD for this job
User Avatar
Dear Client I am an experienced excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I have reviewed your job and ready to proceed and discuss the minor details. Will be therefore waiting for your response. Warm Regards Z
$140 USD in 1 day
5.0 (195 reviews)
8.2
8.2
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD in 4 days
4.9 (380 reviews)
8.1
8.1
User Avatar
Dear Employer, I have gone through your sheet. Just to make you sure of that, your sheet has 9 columns, till Col I which is Alt. Please message me , I am a VBA expert with over 12 years of experience. Will do a perfect job for you. Thanks and Regards, Ash
$200 USD in 7 days
5.0 (203 reviews)
7.8
7.8
User Avatar
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor
$50 USD in 1 day
4.9 (320 reviews)
7.1
7.1
User Avatar
"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 8 years of experience in Sales, Marketing and Advertising. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$160 USD in 7 days
4.9 (271 reviews)
7.0
7.0
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$200 USD in 3 days
5.0 (274 reviews)
7.1
7.1
User Avatar
I am excel guru, I have completed more than 200 projects with 5 start rating. Mohsan
$250 USD in 7 days
5.0 (94 reviews)
6.4
6.4
User Avatar
Hi, I have understand the project requirement & interested to make vab for this project. Please send a message so we can discuss more & start the project. Thanks.
$30 USD in 1 day
5.0 (174 reviews)
6.2
6.2
User Avatar
I have extensive experience with VBA in Excel and I am also a military aviator with a Masters in Systems Engineering (Space Systems). I can easily create a VBA subroutine that will comb through your data and identify all of the cycles (as defined above as when the ALT becomes equal to the initial ALT value). I will assume that you do not want to count a cycle unless the Airframe Hours (column H) has also changed - so as to eliminate any fluctuations due to the inherent errors in the altimeter system. Alternatively, this could be assured by setting a threshold of change in either absolute value of ALT change or a percentage change value. In order to confirm my understanding of your algorithm, the provided file would have 12 separate cycles if only counting occasions where the ALT actually equals the initial value of 6534 (1: Row 3-473, 2: Row 474-649, 3: Row 650-841, 4: Row 842-996, 5: Row 997-1467, 6: Row 1468-1749, 7: Row 1750-2814, 8: Row 2815-2996, 9: Row 2997-3215, 10: Row 3216-3413, 11: Row 3414-3651, 12: Row 3652-3684). Alternatively, if the condition were less than or equal to the initial ALT value of 6534, this would produce 41 separate cycles. Should any of what I have written require further explanation, please PM me and I would be happy to discuss.
$120 USD in 3 days
5.0 (23 reviews)
5.3
5.3
User Avatar
I can do the job! I have a lot of working experience in data processing. I do have some doubts about the excel file which we can chat over if the project is awarded to me. I'm an engineer with advanced working knowledge and experience in Excel, VBA and VBA interaction between different software (Word, Excel, Powerpoint, Outlook, Access, Autocad, Project, etc.). Also, have extensive experience with processing very large data files in different formats with VBA (especially csv data acquisition files). If voice call is required (via freelancer web), communication won't be an issue because I was raised in USA (Charlottesville Virginia) so English is my second mother tongue.
$40 USD in 2 days
5.0 (21 reviews)
4.2
4.2
User Avatar
Dear Client, I am Expert in Excel. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari
$30 USD in 1 day
5.0 (25 reviews)
3.8
3.8
User Avatar
Hi, tasks of this type are my favorites! I can do VBA macro for you to find highest and lowest altitude points in many cycles. Flight can start and end at different altitudes, therefore I can add wise solution. Best regards, Remis
$30 USD in 3 days
4.7 (11 reviews)
3.3
3.3
User Avatar
Hello there! I think I can help you with this project, and create an Excel Macro for you. First I need more details on what exactly you need (maybe you need to explain to me what exactly is needed, as it's a bit confusing, but I think I can do it with the right explanation). If the project is finished then I'll gladly help you with additional stuff (for free, depending on what you need help with).
$70 USD in 7 days
5.0 (2 reviews)
2.7
2.7

About the client

Flag of UNITED STATES
Peyton, United States
0.0
0
Payment method verified
Member since Jul 16, 2019

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.