NefMoto

Technical => Data Logging => Topic started by: Zac on December 20, 2011, 05:06:19 PM



Title: Viewing Logs - Excel Conditional Formatting
Post by: Zac on December 20, 2011, 05:06:19 PM
I was playing around in Excel and the conditional formatting features are pretty awesome compared to what 2003 had. Seems like it could be a cool way to scroll through your log data.

Example - Part of a 3rd gear stomp on the gas merging onto interstate. Looks like modeled EGT goes up very quickly, possibly causing the ignition timing retard? Lambda goes rich. Blah blah blah pretty colors and shit.

Huge screenshot: http://i.imgur.com/1JVTq.png (http://i.imgur.com/1JVTq.png)

Random idea. Looks cool though. Maybe someone will get some ideas from it.


Title: Re: Viewing Logs - Excel Conditional Formatting
Post by: carlossus on December 21, 2011, 06:18:31 AM
Agreed. I've been using this for a while to find the high CF zones and WOT ranges.

I thinkg the Google apps spreadsheet also has it.


Title: Re: Viewing Logs - Excel Conditional Formatting
Post by: TTQS on December 31, 2011, 09:16:11 AM
Oh boy, that is superb. I worship Excel's capabilities but I'm still running Office 2003 and I only upgraded from Office 97 maybe three or four years ago. Looks like time to move on again, but I do hate bloatware.

TTQS