I have an existing excel spreadsheet template that I need multiple different scripts/actions automated to convert data into a new spreadsheet format:
The key actions include:
* Inserting new columns to average data from other columns
* A single cell contains multiple "product codes" (7-8 characters) separated by spaces - need a tool to either 1) extract each code into a new columns for each Product Code or 2) Ignore the Product Code
* The software should build a "library" of product codes that get found each time a new spreadsheet in analysed/imported - with the ability to go back and determine if a particular code is ignored or a new column 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
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.
NO AGENCIES TO APPLY
Thanks & good luck
33 freelancers are bidding on average $442 for this job
Hi, We have excellent eCommerce .Net,and PHP expertise. Please have a look at private message for relevant work done. Awaiting a positive response from your end and looking forward to work with you. Thanks
Hi, Converting this excel data sounds pretty straight forward. We would probably build it in excel for the first phase and then if you wanted to go forward build it in asp/.net. Cheers Nashtrump
We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.
Having vast exp in such utilities. Even currently working on similar projects for wireless technology domain. I am parsing and converting many CSV files in a multi threaded application for many complex business logic.