Teensy datalogger... now how to parse/graph results

Status
Not open for further replies.
G

Gibbedy

Well-known member
Hello,
I have a teensy 3.2 logging telemetry from an rc plane to an sdcard.
Looks like this:
Code: 
Time;602588;FCS150_Current;8.05;
Time;602588;mAh_Consumed;1736;
Time;602588;mWh_Consumed;20088;
Time;602588;Power(W);91.05;
Time;602604;AirSpeed;22.00;
Time;602612;Vario_VSI;0;
Time;602621;RPM;20697.00;
Time;602633;RSSI;2802974720.00;
Time;602645;FLVSS_Voltage;3.79;3.77;3.75;0.00;0.00;0.00;
Time;602712;Vario_Altitude;28;
Time;602724;GPS_Speed;23.91;
Time;602760;AirSpeed;23.00;
Time;602796;Vario_VSI;0;
Time;602928;FCS150_Current;8.25;
.....

I thought I would be able to dump this into excel and get a multiline graph showing each sensor.
I'm finding the only way I can do this is to manually arrange the data into series columns like this:
Code: 
Time	AirSpeed	FCS150_Current
602588		8.05
602604	22	
602760	23	
602928		8.25
603108	24	
603360	22	
603432		8.15
603696	27

Can anyone tell me the easiest way to get my data graphed that doesn't require manually editing the log file.
 
Last edited:
You could use an if statement for each parameter. For example, if parameter is column c and data is column d, then in column e you could put airspeed:

Put in row 2 and copy to each subsequent row:
=if($c2="AirSpeed",$d2,"")
 
Gibbedy said:
Hello,
I have a teensy 3.2 logging telemetry from an rc plane to an sdcard.
Looks like this:
Code: 
Time;602588;FCS150_Current;8.05;
Time;602588;mAh_Consumed;1736;
Time;602588;mWh_Consumed;20088;
Time;602588;Power(W);91.05;
Time;602604;AirSpeed;22.00;
Time;602612;Vario_VSI;0;
Time;602621;RPM;20697.00;
Time;602633;RSSI;2802974720.00;
Time;602645;FLVSS_Voltage;3.79;3.77;3.75;0.00;0.00;0.00;
Time;602712;Vario_Altitude;28;
Time;602724;GPS_Speed;23.91;
Time;602760;AirSpeed;23.00;
Time;602796;Vario_VSI;0;
Time;602928;FCS150_Current;8.25;
.....

I thought I would be able to dump this into excel and get a multiline graph showing each sensor.
I'm finding the only way I can do this is to manually arrange the data into series columns like this:
Code: 
Time	AirSpeed	FCS150_Current
602588		8.05
602604	22	
602760	23	
602928		8.25
603108	24	
603360	22	
603432		8.15
603696	27

Can anyone tell me the easiest way to get my data graphed that doesn't require manually editing the log file.
Click to expand...

you could parse every line (looking for key words), and generate programmatically for every key word a new entry, inserting comma as appropriate
that is you generate a csv file with fixed number of columns
say
Code: 
Time;602588;FCS150_Current;8.05;
Time;602588;mAh_Consumed;1736;
Time;602588;mWh_Consumed;20088;
Time;602588;Power(W);91.05;
Time;602604;AirSpeed;22.00;
etc.
would become
Code: 
Time, FCS150_Current, mAh_Consumed, mWh_Consumed, Power(W), AirSpeed
602588, 8.05, , , ,
602588, ,1736, , ,
602588, , ,20088, ,
602588, , , ,91.05, 
602604, , , , ,22.00
etc

for N keywords you will have N-1 commas
above example limited to 6 keywords

if you open such a file with excel you will find the columns organized for you
 
Status
Not open for further replies.
Back
Top