a simple tool that extracts data set based on multiple criteria - excel macro with vba

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date). The spreadsheet would generate the following output: Output 1: a curve showing time on X-Axis, # of cars on the Y-Axis, # of trucks on the Y-axis (say every 5-minute time intervals) Output 2: a curve showing time on X-Axis, % trucks on the Y-axis (say every 5 minutes)

Data Processing

Excel

Software Architecture

Visual Basic

Visual Basic for Apps

Project ID: 17520730

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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:

@stanleyw12

Hi Sir I'm a new freelancer and I would be able to help you to do this at minimal cost or free as I'm just looking to get positive feedback Regards

$10 USD in 1 day

5.0

(6 reviews)

1.9

17 freelancers are bidding on average $42 USD for this job

@schoudhary1553

Hello, I can help with you in your project a simple tool that extracts data set based on multiple criteria - excel macro with vba I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$30 USD in 1 day

4.9

(319 reviews)

7.8

@ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I can develop a solution as per your requirement (2 output charts based on user selected parameters for Base #, Sensor # and Date). I have 18 years experience in using Excel as part of my daily work life. Over the last 24 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi

$35 USD in 1 day

5.0

(167 reviews)

6.7

@TonmoyRoy111

Dear client I have previously carried out a number of projects in excel using macros and formulas. I understand the scope of work in this project. I can do this project for you with perfection. Roy

$35 USD in 1 day

4.9

(288 reviews)

6.6

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.

$30 USD in 1 day

4.9

(79 reviews)

6.0

@archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana

$30 USD in 1 day

4.9

(91 reviews)

6.0

@aubrey03

I am an Excel specialist with a lot of experience in creating automation tools using complex formulas and VBA. Feel free to contact me so we can discuss the details of this project.

$30 USD in 1 day

4.7

(65 reviews)

5.3

@lightingdavid

Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thanks....

$50 USD in 1 day

4.7

(26 reviews)

5.2

@serdaryalcin

Hi If you shared your desired output, for the selected values, it would be easier for me to get the same graph, otherwise we would be talking about the graph. Best Regards, Serdar Yalcin

$29 USD in 5 days

5.0

(21 reviews)

4.4

@silicolabs

https://www.freelancer.com/projects/php/Extracting-Data-Software/ done the smilar tasks lets discuss it over chat

$172 USD in 1 day

5.0

(1 review)

3.3

@vw6417773vw

Hi, I'm a VBA expert who knows how to build custom (visual) outputs as well as many other advanced tasks in excel/access. I've been coding VBA and VB since I was 15 and it's really something I love doing. Best regards, Marko

$100 USD in 1 day

4.1

(10 reviews)

3.9

@freelancer4100r

Hi there, My name is Saurabh. I have gone through your requirements. Although I am new to freelancer, I have more than 12 + years of experience in Reporting and Data Analysis using MS Excel / BI Tool like Tableau, Report automation using VBA, MS Access, SQL queries. You may also check my portfolio, skillset. Please message me to discuss it further. Thanks, Saurabh

$15 USD in 2 days

5.0

(1 review)

0.3

@ralmelkar

I have done such requirement many times

$25 USD in 1 day

0.0

(0 reviews)

0.0

@rclevenger

I’m a CFO that has experience in Finance, Accounting, and Business operations. I’ve always enjoyed developing automated solutions for the business partners i supported. I do vba as a hobby and some consulting. I need to get a review history cause I’m new to this thing.

$45 USD in 2 days