Log analysis: Calculating average pwr consumption of specific time period

Hey guys,
I am actually writing my thesis about power consumption of different UAVs.

After I calibrated all necessary sensors, I did a lot of test flights. Now I want to analyze these data.

My aim is it to take a specific time period (e.g. 10sec in FBWB or loiter mode) and calculate everage current, voltage, speed, vertical speed and so on and deviation.

First I opened the log file with Excel. That worked but some data have strange units and I do not the seconds when someting happened.

So I tried that the file from this guy: https://www.youtube.com/watch?v=Qd9irkB-lk4
But time and distance is not calculated correctly:

Then I tried this program but I could not open the converted txt file. Maybe it is incompatible with new versions. https://diydrones.com/profiles/blogs/extracting-data-from-tlog-files-for-plotting-in-excel:

Are there any other possibilities? A graphical interface where I can set in and out points would be much easier. The box of log browser is not so precisely. Maybe there are other tools for analyzing.


It’s not a graphical solution, but are you willing to use MATLAB and your .BIN filies (not MAVLink logs)?

A friend and I have made this Matlab tool which reads a .BIN file and builds arrays with the included data, which (at least for me) are easier to manipulate.
Time is also handled a bit better.

We haven’t had a release yet, but you can find and download the code from here: https://github.com/Georacer/ardupilog

From the top of my head, from inside the code directory, type my_log = Ardupilog(), and a file browser will open.
If that doesn’t work, let me know and I’ll give you more specific instructions.

I am not so familiar with Matlab but I will try later.
Edit: Matlab not possible at the moment. I do not get any Matlab licence next months. 30 days test version would not be enough.
Edit 2: I found somebody that helped me writing a small matlab code for calculating the everage.