Closed

data extraction from excel

We have a large spreadsheet of components (lets call them spark plugs) and the vehicle application data that each spark plug fits. We need the data manipulated following some basic rules: Maximum length 40 characters Data sorted by MAKE, plug part number and number of cylinders. Each time legth exceeds 40 characters, MAKE changes or PLUG changes or number of cylinders change then a new line will commence. Vehicle MODELS will be amalgamated in to one line unless critera are met. Amalgamations of all data will be put into seperate columns or tables. This task is actually relatively simple but I don't have enough concentration span to complete it!

## 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 web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) 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).

## Platform

Excel.

Skills: Database Administration, Microsoft Access, MySQL, SQL

See more: data extraction form, request vehicle extraction, vehicle hire software, vehicle hire, sorted data, microsoft excel software, excel sites, excel party hire, web extraction, web data extraction, install lets, hire excel, data source sql, code columns excel access, vehicle spreadsheet, sql server access excel, excel spreadsheet source code, changes data access, excel line work, seperate line, data vehicle, excel form access, data platform, excel data tables, spreadsheet sql server

About the Employer:
( 0 reviews ) channel islands, United Kingdom

Project ID: #2795199

45 freelancers are bidding on average $115 for this job

fastudiovw

See private message.

$85 USD in 14 days
(721 Reviews)
7.5
pShankar2

See private message.

$170 USD in 14 days
(405 Reviews)
7.1
schandraram

See private message.

$106.25 USD in 14 days
(146 Reviews)
6.8
frostrl

See private message.

$170 USD in 14 days
(24 Reviews)
6.4
shikhamehta

See private message.

$114.75 USD in 14 days
(171 Reviews)
6.1
svtsigmavis

See private message.

$276.25 USD in 14 days
(44 Reviews)
5.8
gopisoft

See private message.

$170 USD in 14 days
(55 Reviews)
5.6
bamunu

See private message.

$170 USD in 14 days
(30 Reviews)
5.4
tusharjohri

See private message.

$85 USD in 14 days
(73 Reviews)
5.4
themazeeu

See private message.

$85 USD in 14 days
(40 Reviews)
5.2
sonarkaushik

See private message.

$127.5 USD in 14 days
(18 Reviews)
5.2
eastcoastjoevw

See private message.

$85 USD in 14 days
(25 Reviews)
5.0
crowdata

See private message.

$85 USD in 14 days
(25 Reviews)
5.2
DenisSmolentsev

See private message.

$85 USD in 14 days
(70 Reviews)
5.0
LGLSoftware

See private message.

$85 USD in 14 days
(69 Reviews)
4.8
contexturetech

See private message.

$153 USD in 14 days
(47 Reviews)
4.6
techism

See private message.

$85 USD in 14 days
(39 Reviews)
4.6
rcnvw

See private message.

$170 USD in 14 days
(12 Reviews)
4.5
johncl007

See private message.

$109.65 USD in 14 days
(10 Reviews)
4.4
bondarenkosergey

See private message.

$85 USD in 14 days
(31 Reviews)
4.8