Data retrieval

Cancelled Posted Nov 27, 2005 Paid on delivery
Cancelled Paid on delivery

I'm a final year university student in the U.K. working on a project looking at measuring the drag force exerted on trees by river flood flows. To do this, the strains exerted on a steel cantilever by the flows are measured by 2 strain gauges connected to a logger (V.V. old!). This then gives a data file, with 3 lines of text for each measurement.

I need a program that extracts the relevant data from this file and processes it as described in detail below, preferably via both a VB Version 6 program, and also a stand-alone program to run in windows XP.

Thanks,

Will

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

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

Details of data file and required analysis:

The data file is of the format:

RUN 13:11:28 21-11

S T 8 13:11:32.7

C 001 00034.8 u E C 003 00029.1 u E

D T 8

S T 6 13:11:34.0

C 001 00035.1 u E C 003 00029.2 u E

D T 6

S T 5 13:11:38.9

C 001 00038.0 u E C 003 00030.5 u E

D T 5

S T 6 13:11:39.0

C 001 00037.0 u E C 003 00031.8 u E

D T 6

S T 6 13:11:44.0

...(for up to 1000 measurements)...

HALT 13:13:27 21-11

where obviously the first and last lines give the time and date the test is started and ended at.

For each measurement:

S T '#' gives the start ('S') of the task ('T') number ('#')

C '00#' gives the channel ('C') number ('00#')

* (2 channels,one for each strain gauge)

*'6sf #' u E gives the strain gauge reading for that

channel followed by the units (usually u E)

D T '#' gives the end ('D') of the task ('T') number ('#')

I need the data to be sorted into groups according to the test number. The average strain for each channel then needs to be calculated, and these need to be written to a table or excel file with headings 'Task #', 'Date', 'Time', 'Strain 1', 'Strain 2. (Date and time being those at 'RUN'.

An example data file is attatched.

I'm sure this is a relatively simple task, but I know next to nothing about programming/coding, so any help would be greatly appreciated!

Thanks for your time,

Will

## Platform

Either VB version 6, or a stand-alone windows program that would run on Windows XP (including XP Tablet)

PHP

Project ID: #3120273

About the project

17 proposals Remote project Active Dec 2, 2005

17 freelancers are bidding on average $41 for this job

themasta

See private message.

$42.5 USD in 10 days
(252 Reviews)
6.3
rajgopalnayak

See private message.

$34 USD in 10 days
(18 Reviews)
4.1
cinudata

See private message.

$42.5 USD in 10 days
(26 Reviews)
4.2
connextiontec

See private message.

$127.5 USD in 10 days
(9 Reviews)
4.0
shankara

See private message.

$51 USD in 10 days
(16 Reviews)
3.6
laxmitirupathi

See private message.

$25.5 USD in 10 days
(19 Reviews)
3.4
Arachnaphobe

See private message.

$42.5 USD in 10 days
(1 Review)
3.2
dexter1285vw

See private message.

$29.75 USD in 10 days
(17 Reviews)
2.8
maynkvw

See private message.

$21.25 USD in 10 days
(4 Reviews)
2.7
eurotechvw

See private message.

$8.5 USD in 10 days
(4 Reviews)
2.2
monark

See private message.

$5.95 USD in 10 days
(2 Reviews)
0.9
amish2k

See private message.

$59.5 USD in 10 days
(1 Review)
0.5
petefield

See private message.

$36.55 USD in 10 days
(1 Review)
0.0
reonvw

See private message.

$21.25 USD in 10 days
(0 Reviews)
0.0
jatinnagda

See private message.

$85 USD in 10 days
(0 Reviews)
0.0
Fabricio1

See private message.

$29.75 USD in 10 days
(0 Reviews)
0.0
dexter1285

See private message.

$25.5 USD in 10 days
(0 Reviews)
0.0