In Progress

Application to extract, sort and display Excel spreadhseet data

Project Description:

I have an existing excel spreadsheet template (I receive data regularly in a spreadsheet in the same format) that I need an application to perform multiple automated actions to convert data into a new spreadsheet output format:

The key actions include:

* Inserting new columns to average data from other columns

* Extracting and sorting data from a single cell - A single cell contains multiple space delimited "product codes" (7-8 characters each) - need a tool to either 1) extract and sort each code into a new column or 2) Ignore the Product Code depending on a set of rules from the below "library"

* The software should build a "library" of product codes that get found each time a new spreadsheet in analysed/imported - the library determines sorting actions for each import - the key sorting action being if a particular code is ignored or a new column and column title are created for it

Ultimately I would like this tool to become web-based but for now the simplest method to achieve the result is desired. Anyone demonstrating an understanding of how to make this web based will be favored

SAMPLE DATA

I will send sample data by PM to applicants who I would like to shortlist. Then give them the opportunity to confirm or refine price based on seeing the sample data.

HOW YOU WILL WIN THIS PROJECT

* Show similar projects you have completed - those with a nice design and preferably web-base front end will be favored

* Explain how you intend to code this and why you think this will be the best way

* Automated replies will be ignored - you must show you have read this brief

* NO AGENCIES TO APPLY - I prefer working with reliable individual developers for ongoing work

* If you attempt to contact me via skype you will be blocked

Thanks & good luck

Skills: Excel, Javascript, PHP, Software Architecture, Software Development

See more: understanding by design template, template tool price, spreadsheet to web application, sort sort sort, sort sort, sorting method, software application developers, sample product brief, product design brief template, product design brief sample, product design agencies, product brief template, nice web design codes, new product design brief template, new product brief template, need web application developers, how to win projects, how to get web design projects, how to get php projects, how to design web based, get found now, excel developers, convert spreadsheet to web application, c library sort, best software developers

About the Employer:
( 13 reviews ) Queenscliff, Australia

Project ID: #5482116

Awarded to:

brentmccaw

I have developed tools to parse and analyze data. What I am not clear about is why you want this to be webbased. As I understand the description you wish to process data and add additional data then review. Do you wish More

$833 AUD in 10 days
(0 Reviews)
0.0

28 freelancers are bidding on average $575 for this job

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

$2061 AUD in 10 days
(505 Reviews)
7.4
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$662 AUD in 6 days
(183 Reviews)
6.9
sainathkohta

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget More

$775 AUD in 18 days
(42 Reviews)
6.6
seaanddream

Hi, your 5-star excel and vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel and vba coding tasks, all a More

$375 AUD in 7 days
(64 Reviews)
6.2
deepbluetech

A proposal has not yet been provided

$500 AUD in 5 days
(183 Reviews)
6.1
bsubramaniam1234

Hi, I did a project similar to this, where Client had an excel sheet with him, which he needs it to be created using a form in the web. here is the form I did, Which generates an excel sheet according to the client More

$666 AUD in 10 days
(13 Reviews)
5.9
zExcel

Hi, My name is Jon and I will be happy to help you with this project. Will provide the necessary information on award or intention to award

$250 AUD in 2 days
(51 Reviews)
5.8
pkcyber

See sample projects , though they are not 100% related to your project, but they will give you idea how i use to work. [url removed, login to view] [url removed, login to view] https://ww More

$500 AUD in 4 days
(29 Reviews)
5.6
eComOS

Dear sir, I will complete your project within 12 days and provide ONE YEAR free bug guarantee.. I have gone through your outsourced requirement "Application to extract, sort and display Excel spreadhseet data" and h More

$622 AUD in 365 days
(66 Reviews)
5.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$250 AUD in 10 days
(60 Reviews)
5.4
sandeep25101982

Hi Experts here, Our core area: .[url removed, login to view],ASP.Net,HTML5,MVC,C#,VB,SQL,WPF,SL4+ and Windows Phone and Azure Applications . If you are interested ,see my detailed portfolio at: [url removed, login to view] ASP.Net applic More

$736 AUD in 15 days
(11 Reviews)
5.4
Peterpay

please provide a full detail of your requirement to provide a more accurate bid considering effort, time and cost.

$555 AUD in 5 days
(25 Reviews)
5.3
mmadi

Hi, I'll be happy to do that for you. I can make the parsing in php I have rich experince in curl regular expressions Dom and Selenium RC. I worked for [url removed, login to view] and [url removed, login to view] search engine where I gai More

$515 AUD in 10 days
(20 Reviews)
5.2
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here a More

$388 AUD in 6 days
(22 Reviews)
4.6
MuradMurad

Hi, I have lots of experience with VBA and Excel automation, as well as with Java. I can help you on this automation task as a beginning with VBA, later can do Excel processing with Java if needed. Can you please send More

$666 AUD in 10 days
(6 Reviews)
4.6
anuyadav1

A proposal has not yet been provided

$400 AUD in 3 days
(15 Reviews)
4.4
binarycodersvw

[url removed, login to view] the sample data first. I have read the description of your project and I am [url removed, login to view] name is Andrei. I am a Visual Basic .NET programmer and website developer with 10 years experience. I know you hear thin More

$1727 AUD in 17 days
(10 Reviews)
4.4
netchampion

A proposal has not yet been provided

$250 AUD in 10 days
(4 Reviews)
4.0
jawadaman

Hi, I am interested in this project. I am an experienced IT professional and am proficient in MS Exce and VBA. If interested in hiring me then please let me know so that we can discuss the scope, timelines and budget More

$250 AUD in 10 days
(16 Reviews)
3.9
Midlander

You ask for evidence of similar projects I have completed. Most of my work is done under Confidentiality and Non-Disclosure Agreements, which I am happy to apply to this assignment if required. Secondly, I can't send y More

$506 AUD in 7 days
(5 Reviews)
3.5