Excel Data Format and Import

Completed Posted Apr 9, 2004 Paid on delivery
Completed Paid on delivery

We are collecting data at 3 different locations using handheld barcode scanners. A barcoded ticket is given to a truck driver for each job, the barcode is scanned at each location he visits. The scanners will be returned to a central location and a text file(CSV?) will be downloaded from each. We want to import the data into Excel 2000. Each file will contain fields for "Location", "Barcoded Number (Ticket Number)" and a Date/Time stamp. We can change the layout/format of the text file if required.

We want to:

1) Calculate total elapsed time for a Ticket Number even if only 1 or 2 location files have been imported .

2) Calculate elapsed time between each location even if only 2 location files have been imported .

3) Delete records older than 1 month

4) Not import previous records already imported.

5) Indicate when a ticket number has only been scanned at 1 or 2 locations(ticket not scanned into file or not imported yet)

Please note that a driver will complete the circuit multiple times for 1 job ticket. Files could look as follows:

File 1:

Plant, 123456, 4/8/04 23:23:01

Plant, 123457, 4/8/04 23:27:01

Plant, 123456, 4/9/04 02:30:30

Plant, 123456, 4/9/04 04:30:30

Plant, 123457, 4/9/04 01:32:30

File 2:

Paver, 123456, 4/8/04 01:03:55

Paver, 123457, 4/8/04 00:20:50

Paver, 123456, 4/9/04 03:30:30

Paver, 123456, 4/9/04 05:00:30

File 3:

Miller, 123456, 4/8/04 01:23:55

Miller, 123457, 4/8/04 01:10:50

Miller, 123456, 4/9/04 03:50:30

Please let me know if more information is required.

Time is crucial for this job.

A sample spreadsheet and text files are available.

## 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

The Data will be collected on a W2K PC with Excel 2000

Engineering Excel Microsoft Access Microsoft Exchange MySQL PHP Powerpoint Software Architecture Software Testing Word

Project ID: #3165899

About the project

8 proposals Remote project Active Apr 9, 2004

Awarded to:

PeakeyEnterprise

See private message.

$170 USD in 3 days
(26 Reviews)
4.9

8 freelancers are bidding on average $154 for this job

icodeinvb

See private message.

$85 USD in 3 days
(316 Reviews)
7.1
thebestdeve

See private message.

$140.25 USD in 3 days
(18 Reviews)
4.7
sbcomvw

See private message.

$340 USD in 3 days
(5 Reviews)
4.4
devsoftindia

See private message.

$127.5 USD in 3 days
(3 Reviews)
3.4
bigursusvw

See private message.

$85 USD in 3 days
(12 Reviews)
2.9
oceanboysoftware

See private message.

$106.25 USD in 3 days
(5 Reviews)
2.5
e711vw

See private message.

$177.65 USD in 3 days
(0 Reviews)
3.5