Torque Log Analyzer

[Alessandro Iacopetti]

Torque Log Analyzer is a Google Spreadsheet add-on that process Torque logs and reports a summary of your trip.
The report highlights driving behaviors that are bad for your mileage, so you can improve your driving style.
Torque Log Analyzer was written specifically for Toyota HSD hybrid cars, but now supports Ford hybrid cars also.

As I've just added support for Ford hybrid, I'm looking for testers.

The apps is free and just a for-fun project for me.

Please, have a look and tell me what you think.

The app is available on the chrome store at https://chrome.googl...ccfkjgkicenlbng

Take a look at the web site for info and instructions: http://torqueloganalyzer.blogspot.it/

[HighwayJerk]

Is there anyway to port this or have it work with Excel, OpenOffice or the like?

Giving google access to your GPS data and driving habits is just a bad idea in my opinion.

[Alessandro Iacopetti]

Excel is not a free software, and OpenOffice just don't have a well documented scripting API, so I opted for Google Docs, that is cross-platform and cloud-based

As for your concern about sharing GPS data with google, GPS data can be excluded from the logs, but if you're using an Android phone to gather Torque data, you're already sold your soul to big G.

Anyway, full source of Torque Log Analyzer is available and I will support anyone willing to port it to Libre/OpenOffice and Excel as a last resort.

[HighwayJerk]

So because I use the torque app I just had to give this a go. (Made some 10minutemail google account to do it)

Must say it is very nice, lots of useful info. Great job! Love the Analysis. Gonna add and log some of the PIDs that seem to be missing according to the Logs so I can get more info .

Small things I noticed: I get the following error a lot:

ERROR: Trip Distance\(km\) PID missing, could't add column EV Distance

(Besides the spelling error: could't)

I am logging trip distance but mine is in Miles. Is there going to be support for Miles, MPGs and the rest of the US units?

(Speed data is labeled as Km/h below, but I'm pretty sure it's actually MPH in my logs)

I would love to be able to see some of my MPG Data and EV distance info.

Going to Add most of the Missing PIDs the Log tab shows as missing and report back.

 

Here is a sample of the Analysis Summary this outputs (Besides all the nice charts) for anyone interested in trying this:

Start SOC %		47.22	Value of HV Battery at the beginning of the trip
End SOC %		39.64	Value of HV Battery at the end of the trip
SOC difference %	-7.58	Difference between end and beginning
SOC % charged by ICE	55.76	HV Battery amount produced by engine
Average SOC %		48.52	Mean value during the trip
Min SOC %		38.76	Minimum value of HV Battery in the whole trip
Max SOC %		55.95	Maximum value of HV Battery in the whole trip
		
ICE off %		44.93	Percentage of trip time where the engine was off
EV %			47.81	Percentage of trip time where the car was running in EV
Ignitions		52.00	Times ICE was turned on
		
		
Avg Coolant Temperature	176.17	Engine coolant fluid
Max Coolant Temperature	195.80	Engine coolant fluid
		
Average Speed		37.94	Km/h (this does seem to be MPH actually)
Top Speed		67.73	Km/h (this does seem to be MPH actually)
Avg Absolute Speed Variation	1.52	Speed variations during the trip (only while moving): measure your driving style
Max RPM			4694.75	RPMs
Average RPM		1541.03	RPMs

Edited September 26, 2014 by HighwayJerk

[HighwayJerk]

OK, So I went ahead and added some of the Missing PIDs and I got much better results.

And I'm really loving what this has to offer.
The Log I analyzed yesterday was just an old one I had on my PC that I was playing around in Excel with.

I get lots of errors with some torque logs and others seem to work fine.

There does appear to be a bunch of required PIDs that I don't get any data for like:
Accel Pedal Pos #1
Actual Engine Torque (I do get data for torque though)

I don't have PIDs for the following which show as missing in the Torque Log File Analyzer log:
ERROR: Batt Pack Current Val PID missing
ERROR: Regen Cooperation PID missing
ERROR: Wheel Cylinder Pressure Sensor PID missing
ERROR: Regen Cooperation PID missing
ERROR: HV System Indicator PID missing

I believe some of these are Toyota specific even though I specified Ford hybrid so this could be a bug.

I do probably need to add all the PIDs linked here in your blog:
http://i-fix.us/Torque-Pro-Settings-for-Ford-Fusion-and-C-MAX-Energi.php
(Just imported them so will see how it goes next trip)

I do have a 1st Gen Lincoln Hybrid so that could be why some of the PIDs are Missing or contain no data. I'm not sure if the Ford Stuff on your Log analyzer was optimized for the 2013+ Ford Hybrids though.

Here is another example of the Summary Analysis generated.
Things are still in Metric units but it's easy enough to convert to US units.
But it's so much easier to do if you export to Excel or Open Document format first.
I have to say google spreadsheets is the slowest, clunkiest spreadsheet software I have ever worked with.
I am amazed that anyone actually uses it for anything. I understand it is all web based but there are much better offerings out there than googles...you get what you pay for here...and with anything google...You're the Product, not the Customer.

Start SOC %                            37.76    Value of HV Battery at the beginning of the trip
End SOC %                              43.35    Value of HV Battery at the end of the trip
SOC difference %                        5.59    Difference between end and beginning
SOC % charged by ICE                   13.38    HV Battery amount produced by engine
Average SOC %                          46.08    Mean value during the trip
Min SOC %                              36.98    Minimum value of HV Battery in the whole trip
Max SOC %                              53.44    Maximum value of HV Battery in the whole trip
        
ICE off %                              66.33    Percentage of trip time where the engine was off
EV %                                   68.74    Percentage of trip time where the car was running in EV
EV Range                                5.05    Total distance traveled in EV mode
Trip length                             7.91    km
Ignitions                              18.00    Times ICE was turned on
Battery Stress                         24.31    Quadratic average of battery current flow
Max Current                            68.40    Maximum output current from HV battery
Min Current                           -96.30    Maximum charge current to HV battery
        
ParaGlide %                             0.85    Percentage of driving time where the car was moving gliding 
                                                (approximate value)
Longest ParaGlide sequence              3.00    Longest paraglide, in seconds
        
Average Coolant Temperature           164.61    Engine coolant fluid
Max Coolant Temperature               181.40    Engine coolant fluid
        
Average Engine Load                    77.49    Mean value considering only non-zero values
Min Engine Load                        28.24    Excluding zero values
Max Engine Load                       100.00    Maximum value
        
Average Speed                          36.33    Km/h
Top Speed                              79.00    Km/h
Average Absolute Speed Variation        4.21    Speed variations during the trip 
                                                (only while moving): measure your driving style
Max RPM                              2898.75    RPMs
Average RPM                          1498.12    RPMs
Trip length                             7.91    km
Fuel used                               0.40    litres, as reported by Torque
Fuel economy                           19.90    Km/L
Best fuel economy                      19.90    Km/L
Fuel consumption                        5.02    L/100Km
        
Average Accelerator %                  21.38    Accelerator Pedal Usage
Standard Deviation                      8.00    
Avg Absolute Accelerator Variation      4.26    Accelerator variations during the trip 
                                               (only while moving): measure your driving style

	

Edited September 27, 2014 by HighwayJerk

[Alessandro Iacopetti]

 

(Speed data is labeled as Km/h below, but I'm pretty sure it's actually MPH in my logs)

 

actually labels are hard-coded in SI base units, but the raw numbers are picked up from the torque logs

so if you're logging in miles, you'll get miles in charts and analysis

I'll work on that on later releases if I'll get enough requests

[Alessandro Iacopetti]

 

OK, So I went ahead and added some of the Missing PIDs and I got much better results.

I don't have PIDs for the following which show as missing in the Torque Log File Analyzer log:

ERROR: Batt Pack Current Val PID missing

ERROR: Regen Cooperation PID missing

ERROR: Wheel Cylinder Pressure Sensor PID missing

ERROR: Regen Cooperation PID missing

ERROR: HV System Indicator PID missing

I believe some of these are Toyota specific even though I specified Ford hybrid so this could be a bug.

 

I do have a 1st Gen Lincoln Hybrid so that could be why some of the PIDs are Missing or contain no data. I'm not sure if the Ford Stuff on your Log analyzer was optimized for the 2013+ Ford Hybrids though.

 

I have to say google spreadsheets is the slowest, clunkiest spreadsheet software I have ever worked with.

 

those pids are toyota's

just ignore the messages, I'm going to fix them in the next release

I can't really test Ford or Lincoln hybrids since they are not available in Italy, so I have to work from internet docs and feedbacks like your.

 

I agree with you on google spreadsheet, but it's actually fun to develop on, and it has a lot of potential (cross platform and cloud)

[HighwayJerk]

 

those pids are toyota's

just ignore the messages, I'm going to fix them in the next release

I can't really test Ford or Lincoln hybrids since they are not available in Italy, so I have to work from internet docs and feedbacks like your.

 

I agree with you on google spreadsheet, but it's actually fun to develop on, and it has a lot of potential (cross platform and cloud)

 

OK, so I think we can find the Ford Equivalents to most of those Toyota PIDs and also the one I still get no Data for: Actual Engine Torque

 

I guess what I need to know is what kind of data those PIDs give you so I can find the Ford Equivalents here.

Can you give an explanation of the Data they provide.

As for Actual Engine Torque

I am able to get some torque data from other PIDs. What is the difference between the regular Torque PID and the Actual Engine Torque PID?

 

Update: So after looking at the FAQ on your blog I see there are items listed on "What to Log" that I was missing.

I have added them and will take a trip to see how this affects the data.

Edited September 27, 2014 by HighwayJerk

[Alessandro Iacopetti]

Let me know how it works after reading the FAQ

[HighwayJerk]

Let me know how it works after reading the FAQ

 

After updating what I'm logging, now I'm only missing the Following (which are all Toyota PIDs right?):

ERROR: Brake PID missing

ERROR: Regen Cooperation PID missing

ERROR: Wheel Cylinder Pressure Sensor PID missing

ERROR: Regen Cooperation PID missing

ERROR: HV System Indicator PID missing

 

And I'm now getting battery Info as shown in my Updated Analysis shown in the post above

 

Seems like there may be equivalents to the the Brake PID and HV System Indicator.

Any Ideas on the Actual Engine Torque PID and Just Torque PID?

Edited September 27, 2014 by HighwayJerk

[Alessandro Iacopetti]

The PIDs reported as missing are Toyota specific, related to braking and the hybrid system.

I've found no equivalents for Ford.

The actual engine torque should be a native torque app pid.

[HighwayJerk]

The PIDs reported as missing are Toyota specific, related to braking and the hybrid system.

I've found no equivalents for Ford.

The actual engine torque should be a native torque app pid.

 

Yes, I have it set to log, But I do not get any data for it. So it appears my car doesn't support it. I have just Regular Torque (ft/lb) also set to log and I do get data for it.

Is there any difference between the two?

So besides having to make some unit conversions everything seems to be working great now.

Edited September 27, 2014 by HighwayJerk

[Alessandro Iacopetti]

I don't know about difference between the two.

Actually "actual engine torque" is used to detect when the petrol engine is beeing passively spinned by the electric engine. On Toyota hybrids, this is a condition that happen while running in EV at over 70km/h.

Maybe it doesn't even apply on fords, maybe with some logs we can test it out.

Regarding the braking PIDs, what we have on Toyota is a PID that monitor the pressure of the braking system (under a given level, there is no braking applied) and a PID that tells if there's some regen energy collected from the brakes.

Careful braking activate only the second PID, while the first triggers only under 12km/h or on fast brakings.

[Alessandro Iacopetti]

New version available:

• New Ford PIDs: previous ones were slightly wrong, download the new ones from the download section. (thanks to larryh and HighwayJerk)
• Altitude statistics: start, end, min, max, delta.
• Options are saved and restored when the sidebar is displayed.