Completed

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

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)

Skills: Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps

See more: useful statistical tool analysis data questionnaire, sum multiple data multiple cells excel, simple script import data php, vbscript to filter multiple data in excel, excel vba filter based on cell value on another sheet, excel vba advanced filter multiple criteria not equal, excel vba copy filtered data to another sheet, excel vba filter pivot table based on multiple cell values, extract data using advanced filter and vba, excel macro filter criteria list, macro to filter data based on input criteria by user, excel, poker data set, simple script extract data urls, economic stat tools data set, online data entry based company, extracting data html based tags perl, summing excel based multiple data, simple tool creating web application based mysql javascript, copy multiple columns excel macro visual basic

About the Employer:
( 2 reviews ) OVIEDO, United States

Project ID: #17520730

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
(6 Reviews)
1.9

18 freelancers are bidding on average $42 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (go More

$35 USD in 1 day
(648 Reviews)
8.3
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 Archite More

$30 USD in 1 day
(305 Reviews)
7.7
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 sele More

$35 USD in 1 day
(166 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
(278 Reviews)
6.6
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 More

$30 USD in 1 day
(90 Reviews)
5.9
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
(68 Reviews)
5.8
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
(55 Reviews)
5.1
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
(21 Reviews)
4.4
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
(13 Reviews)
4.2
dataexplorer

"Hello, I am ready to work with "a simple tool that extracts data set based on multiple criteria - excel macro with vba". I would love to chat with you to know more details about your project . Price Negotiable. Norm More

$30 USD in 1 day
(16 Reviews)
3.5
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 r More

$100 USD in 1 day
(10 Reviews)
3.9
$25 USD in 1 day
(3 Reviews)
2.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 More

$15 USD in 2 days
(1 Review)
0.3
$25 USD in 3 days
(0 Reviews)
0.0
silicolabs

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

$172 USD in 1 day
(0 Reviews)
0.0
ralmelkar

I have done such requirement many times

$25 USD in 1 day
(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 nee More

$45 USD in 2 days
(0 Reviews)
0.0