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.
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,
Either VB version 6, or a stand-alone windows program that would run on Windows XP (including XP Tablet)