Application to extract, sort and display Excel spreadhseet data
$250-750 AUD
Paid on delivery
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
Project ID: #5482116
About the project
Awarded to:
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
28 freelancers are bidding on average $575 for this job
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
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
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
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
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
please provide a full detail of your requirement to provide a more accurate bid considering effort, time and cost.
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
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, More
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 More
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 More
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 More
