TLog to Friendlier Format

I am trying to get graph how my quad uses power as it flies for a research project. I am running the APM 2.5 on a DJI F450 with the 3DR power module hooked up.

 

I found that the voltage/current information is stored in the .tlog format. I used the Mission Planner utility to take the .tlog into .txt, but I can't figure out how to get Excel to look at it to create a graph with voltage vs time.

 

So, I decided to write a C++ program to take the text file and turn it into another text file that is more excel friendly. So far, the program is slow and I have only been searching for one value.

 

Any ideas?

 

 

-Jake

You need to be a member of diydrones to add comments!

Join diydrones

Email me when people reply –

Replies

  • Doesn't the planner do graphs already anyway?

  • I have been plotting altitude and voltage the past week using excel. It takes me 20 to 25 minutes to process tlog exported as csv. If you have a faster way, I would love to know your solution and perhaps share the code (especially if its a macro within excel to cut on processing time). Anyways, open csv in excel, format resulting data based on column Q (that's where voltage_battery is located). I then remove all rows that do not have the voltage_battery information. Removed also all columns except those with the time and columns Q & R. Re-sort the cleaned data using time column. The result is data waiting for your plotting methodology.

    Best.

  • Does anyone know what the current in the .tlog is in? mA?

     

    -Jake

  • Use python with matplotlib :)  Should not be more than 30 lines of code...

This reply was deleted.

Activity

DIY Robocars via Twitter
RT @a1k0n: Did I get rid of hand-tuned parameters? Yes. Am I still hand-tuning more parameters? Also yes. I have a few knobs to address the…
yesterday
DIY Robocars via Twitter
RT @a1k0n: I'm not going to spoil it, but (after charging the battery) this works way better than it has any right to. The car is now faste…
yesterday
DIY Robocars via Twitter
RT @a1k0n: Decided to just see what happens if I run the sim-trained neural net on the car, with some safety rails around max throttle slew…
yesterday
DIY Robocars via Twitter
Saturday
DIY Robocars via Twitter
RT @SmallpixelCar: @a1k0n @diyrobocars I learned from this. This is my speed profile. Looks like I am too conservative on the right side of…
Saturday
DIY Robocars via Twitter
RT @a1k0n: @SmallpixelCar @diyrobocars Dot color is speed; brighter is faster. Yeah, it has less room to explore in the tighter part, and t…
Saturday
DIY Robocars via Twitter
RT @a1k0n: I'm gonna try to do proper offline reinforcement learning for @diyrobocars and throw away all my manual parameter tuning for the…
Friday
DIY Robocars via Twitter
RT @circuitlaunch: DIY Robocars & Brazilian BBQ - Sat 10/1. Our track combines hairpin curves with an intersection for max danger. Take tha…
Thursday
DIY Robocars via Twitter
RT @SmallpixelCar: Had an great test today on @RAMS_RC_Club track. However the car starts to drift at 40mph. Some experts recommended to ch…
Sep 11
DIY Robocars via Twitter
RT @gclue_akira: 世界最速 チームtamiyaのaiカー https://t.co/1Qq2zOeftG
Sep 10
DIY Robocars via Twitter
RT @DanielChiaJH: Always a good time working on my @diyrobocars car at @circuitlaunch. Still got some work to do if I’m to beat @a1k0n howe…
Sep 10
DIY Robocars via Twitter
RT @SmallpixelCar: My new speed profile for @RAMS_RC_Club track https://t.co/RtLb7TcgIJ
Sep 10
DIY Robocars via Twitter
RT @SmallpixelCar: Practiced at @RAMS_RC_Club today with my new @ARRMARC car https://t.co/AEu2hCx89T
Aug 28
DIY Robocars via Twitter
Aug 24
DIY Robocars via Twitter
RT @gclue_akira: 柏の葉で走行させてるjetracerの中身 #instantNeRF #jetracer https://t.co/giVvuE4hP7
Jul 4
DIY Robocars via Twitter
Cool web-based self-driving simulator. Click save when the AI does the right thing https://github.com/pncsoares/self-driving-car
Jul 4
More…