I need to import two spreadsheets and create one Master Spreadsheet. The Master Spreadsheet will imported all the data and display it in a specified manner, plus have the capability to sort the Master Spreadsheet in various ways. Prefer to load this program onto my computer via cd, not a web based solution.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) Specifics:
(Import Spreadsheet #1)- this spreadsheet has names of individuals and other critical data cells. The problem is that the individuals' first name, middle name, and last name are in the one cell. In another cell, that same individuals home address, city. state, and zip code are in one cell. I need this info split (first name in one cell, last name in another, home address on one, city in another, zip code in another, etc….).
(Import Spreadsheet #1) - same spreadsheet as above, but it has individual occupation license expiration dates. These dates are in a cell in this format "12082006". I need for the program to display the date in a recognized format like "Aug 12, 2006". This spreadsheet will to be cross-ref with Spreadsheet #2.
Import Spreadsheet #2) - this spreadsheet has multiple demographics data cells, specifically income by zip code. This spreadsheet needs to be used (cross ref) with Spreadsheet #1 to generate the "Master Spreadsheet".
(Master Spreadsheet- "what I want") - Using the information from the two spreadsheets above, I need to create the "Master Spreadsheet" that can:
1. Organize the data by license expiration date first (expire the soonest), then by highest income according to zip code, license number, license type, CE provider number name, address, city, state, address zip code. (we can discuss all the fields in more detail later)
I would like to be able to manipulate this data is different ways…. Like sort by "license type" using the same rule above, etc. The base line will always be list by license expiration date.
Need to be able to export the organized Master Spreadsheet to a mass mailing service. The mailing service will only need "name and address", nothing else.
Import Spreadsheets #1 & #2 (above) are updated periodically, so I will need to load it into the Master Spreadsheet often. There are 200k+ rows in import spreadsheet #1
## Platform
Laptop, windows xp