Application to extract, sort and display Excel spreadhseet data

Completado Publicado Feb 24, 2014 Pagado a la entrega
Completado Pagado a la entrega

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

Excel JavaScript PHP Arquitectura de software Desarrollo de software

Nº del proyecto: #5482116

Sobre el proyecto

28 propuestas Proyecto remoto Activo Mar 7, 2014

Adjudicado a:

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 Más

$833 AUD en 10 días
(1 comentario)
4.1

28 freelancers están ofertando un promedio de $575 por este trabajo

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 Más

$2061 AUD en 10 días
(1072 comentarios)
8.9
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 Más

$375 AUD en 7 días
(357 comentarios)
8.7
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 en 6 días
(495 comentarios)
8.2
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 en 2 días
(263 comentarios)
7.7
deepbluetech

A proposal has not yet been provided

$500 AUD en 5 días
(288 comentarios)
7.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 Más

$250 AUD en 10 días
(154 comentarios)
6.5
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 Más

$388 AUD en 6 días
(72 comentarios)
6.3
anuyadav1

A proposal has not yet been provided

$400 AUD en 3 días
(55 comentarios)
5.9
Peterpay

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

$555 AUD en 5 días
(39 comentarios)
5.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 Más

$666 AUD en 10 días
(15 comentarios)
5.2
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 Más

$250 AUD en 10 días
(51 comentarios)
5.2
tomislav1975

hello, I know I can help you with your project. I would code everything in Excel using VBA. It can be done very nicely. One of my customers named me Excel Guru. Pls check out why, and award me with trust. For details, Más

$500 AUD en 12 días
(36 comentarios)
5.4
hireatechi

Hi, I am from Zen Aspirations. I had read your requirement I can assign a dedicated team for this project. We, Zen Aspirations, is an Indian company founded by a group of aspiring and technology savvy individuals Más

$677 AUD en 18 días
(10 comentarios)
4.7
huanjason

I propose to build this project on Google App Engine (GAE), a Platform-as-a-Service cloud infrastructure (with free daily quotas). I am interested to make a simple prototype (at no cost) for you to evaluate the fe Más

$333 AUD en 5 días
(8 comentarios)
5.2
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 Más

$506 AUD en 7 días
(11 comentarios)
4.5
netchampion

A proposal has not yet been provided

$250 AUD en 10 días
(4 comentarios)
3.8
bryanyoung

I'd code this in C# using the MS Office automation libraries. I've worked on a project before in which a daily report was made in Excel from CSV files. Unfortunately, I'm not a web developer. For the product code libra Más

$526 AUD en 10 días
(2 comentarios)
4.2
subhashishkar

Hello, Thank you for posting this project. I have thoroughly reviewed your requirement and I would happy to deliver this project under its current scope. Though I am not comfortable developing this into a web based Más

$700 AUD en 10 días
(7 comentarios)
2.6
uframos

Hi there! I'm new in freelancer, however I have a lot of experience building macros to automate business processes. I care a lot about details and visual aspect of the stylesheet, I'm very responsible and I am sure you Más

$333 AUD en 3 días
(1 comentario)
2.1
idans

Give me the file, and you pay me based on your satisfaction. Not satisfy? do not pay. Just to get you know that i am (a newbie here) is an good enough with Excel & Macro more than those indians... ooops, sorry. Pleas Más

$250 AUD en 10 días
(1 comentario)
0.1