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)

Evner: Databehandling, Excel, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 2 bedømmelser ) OVIEDO, United States

Projekt ID: #17520730

Tildelt til:


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 på 1 dag
(6 bedømmelser)

17 freelancere byder i gennemsnit $42 på dette job


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 Flere

$35 USD på 1 dag
(669 bedømmelser)

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 Flere

$30 USD på 1 dag
(319 bedømmelser)

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 Flere

$35 USD på 1 dag
(167 bedømmelser)

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 på 1 dag
(288 bedømmelser)

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 på 1 dag
(79 bedømmelser)

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 Flere

$30 USD på 1 dag
(91 bedømmelser)

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 på 1 dag
(65 bedømmelser)

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 på 1 dag
(26 bedømmelser)

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 dage
(21 bedømmelser)

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

$172 USD på 1 dag
(1 bedømmelse)

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 Flere

$100 USD på 1 dag
(10 bedømmelser)
$25 USD på 1 dag
(3 bedømmelser)

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 Flere

$15 USD in 2 dage
(1 bedømmelse)
$25 USD in 3 dage
(0 bedømmelser)

I have done such requirement many times

$25 USD på 1 dag
(0 bedømmelser)

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 Flere

$45 USD in 2 dage
(0 bedømmelser)