Closed

Application to extract, sort and display Excel spreadhseet data

This project was awarded to brentmccaw for $833 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$250 - $750 AUD
Total Bids
31
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online