front end gui to run the software to be used on windows machines –

Software is required to convert a file with data collected by a Teensy acquisition system, which is in rows into an output file, which is in column format. The column format will allow me to import the data into software to do analysis. In the current format, I can’t use the data.

The data supplied is called TFM_0054_convertexample.txt

You can see that this is made up of two different strings, one is a GPS string, which has the GNSS text in it, the second is data from several different sources.

The GPS string consists of the following columns

Time, text, longitude_WGS84, latitude_WGS84,year,month,day,hour,minute,second

The other string consists of the following columns

Time!TMI_raw@signal_strength#altitude;altitude_firstreturn;altitude_lastreturn;Temperature&pitch;roll;heading

The columns to be output should be

Time,longitude_WGS84,latitude_WGS84,year,month,day,hour,minute,second,TMI_raw,signal_strength,altitude,altitude_firstreturn,altitude_lastreturn,laser_temp,pitch,roll,heading

In the conversion process, I don’t want to lose any data. For example if roll is to two decimal places, the output file should have roll to two decimal places.

Different data has different sampling rates, the GPS data records only once per second, where as the other data all records ten times per second. This will give us one row with all of the columns populated, followed by 9 rows of no data in the GPS related columns, but the rest of the fields populated.

The problem here is that for the row that has GPS data with a row of other data combined we have two different time values, please keep the GPS time value, but remove the time value from the other data row.

Where we have no GPS data in a row please give the longitude, latitude, year, month etc values nulls values (Please make nulls a value like 99999).

Another small adjustment, is I would like the final output for TMI_raw values to be divided by 6009.342147.

Please create a front end gui to run the software to be used on windows machines. I would also like the code at the end of the project.

Some notes to make life easier; You could clip the first 100 samples of data, as there may be missing values while sensors are warming up.