Custom Spreadsheet - OLM #1

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

Keahlian: Administrasi Basis Data, Teknik, MySQL, PHP, Perancangan Perangkat Lunak, Pengujian Perangkat Lunak, SQL

Lihat lebih lanjut: working from home on my computer, work from home using my computer, work from home spreadsheets, work from home mailing, ways of working from home, spreadsheet work from home, spreadsheet web form, spreadsheet engineering, service spreadsheet, service provider agreement format, one city one hire, mailing work from home, i want work from home with my computer, it service provider agreement, custom software license agreement, spreadsheet 2, import two, create spreadsheet, line laptop desktop, cell names, php spreadsheet, mass mailing software, custom format number, data information organize, license provider

Tentang Pemberi kerja:
( 4 ulasan )

ID Proyek: #3376015

Diberikan kepada:


See private message.

$110.5 USD dalam 15 hari
(242 Ulasan)

4 freelancer menawar dengan rata-rata $96 untuk pekerjaan ini


See private message.

$85 USD dalam 15 hari
(13 Ulasan)

See private message.

$102 USD dalam 15 hari
(4 Ulasan)

See private message.

$85 USD dalam 15 hari
(0 Ulasan)