Log Analyzer Quick Tuner -- Tuning Made Easy

[84Elky]

Attached is an updated Log Analyzer Quick Tuner program. Any .csv, .xls or .xlsx log file that contains BLM and INT with 128 as the base value is analyzed in just a few seconds, providing data to quickly adjust a tune.

The previous version has been in use for several years to aid in Speed Density (SD) tuning but has been significantly revised. This version now supports Turbo and Mass Air Flow (MAF) tuning. It also supports BINs with left and right bank data such as MAF $EE and SD $DA0/2/3.

For SD, BLM data are reported relative to MAP kPa; and for MAF, BLM relative to Air Flow Rate, MAF Sensor Frequency or LV8 Load depending upon the information provided. A BLM Correction table provides adjustments required to achieve a BLM of 128.

Two demo logs are provided:

MAF $6E DEMO (With WBo2)
SD $8D DEMO (v7 With Turbo & WBo2)

To view how log information is analyzed:

Load the program (LOG ANALYZER v32). The analyzed MAF $6E log will be presented.
Review each Tab.

To view the SD $8D demo log:

Click the “Select Engine Type” Tab at the far left.
Select the “Click here to Select Engine Type” button.
A menu will be presented. Select “Speed Density”.
A Speed Density INPUT page will be presented. It contains the information needed to analyze a $8D v7 Turbo log. Nothing needs to be entered or changed, but it can be to alter how the log is analyzed (temperature ranges, Loop Status, etc.).
Press F9. A File Open Dialog will be presented.
Locate the $8D demo log file and select it. Once selected, it will be opened and analysis will begin.

To analyze any other log, repeat the procedure above for the SD $8D demo log. The only requirements to analyze a log are:

Select the Engine Type (MAF or SD) to present the INPUT page.
Ensure that Log File Column Titles entered on the INPUT page exactly match those in the Log File. Column Titles of various ADX files are provided on the MAF and SD INPUT pages as a starting point. To use them, merely highlight a Mask’s data and copy it to the area on the INPUT sheet where Log Column Titles are entered.
Press F9 to analyze


Feedback appreciated, especially regarding improvements or changes.

Elky

[Drnhandy]

Does this work on Open Office? Does this work with MAP systems?

[84Elky]

Does this work on Open Office? Does this work with MAP systems?You can try it with OO, but it's not guaranteed to work because despite being an Excel clone, some operations have been reported as being different. But please try and report back. Also note that Excel 2007 or later is required.

Yes MAP supported. That's Speed Density.

[NomakeWan]

Does this work on Open Office? Does this work with MAP systems?
Just a minor note, but Open Office isn't really supported anymore if I recall correctly. I moved to Libre Office so I could actually open modern Excel files.

84Elky, thanks for this! I'll give it a shot and see how it does with MAF stuff, should be fun.

EDIT: As for LibreOffice, it doesn't seem to work. The first error the macros throw is with a development function that was left in that lets you exit without saving. Once I removed that development function, the sheet loaded properly. But then when I select MAF or SD, it throws a BASIC runtime error 423 related to "value2" in ThisWorkbook.

So sadly, looks like it really will require real MS Office to run this unless the code gets refactored for compatibility.

[84Elky]

Just a minor note, but Open Office isn't really supported anymore if I recall correctly. I moved to Libre Office so I could actually open modern Excel files.

84Elky, thanks for this! I'll give it a shot and see how it does with MAF stuff, should be fun.

EDIT: As for LibreOffice, it doesn't seem to work. The first error the macros throw is with a development function that was left in that lets you exit without saving. Once I removed that development function, the sheet loaded properly. But then when I select MAF or SD, it throws a BASIC runtime error 423 related to "value2" in ThisWorkbook.

So sadly, looks like it really will require real MS Office to run this unless the code gets refactored for compatibility.Thanks for the feedback. Yes, it will unfortunately not run on any of the open source platforms (discontinued OpenOffice, LibreOffice, NeoOffice, ApacheOffice, etc.). This is because of differences in how MS integrates VBA and how other versions of BASIC are integrated in the open source. Also regrettable that MS is constantly changing programming standards that open source developers cannot keep up with! This is also the reason I cannot unfortunately do the same which would require multiple versions to support open source. Again, regretable.

[dave w]

I'm unsure if there is truly a free version of Microsoft 365 . . . but . . . https://www.cnet.com/tech/services-and-software/get-microsoft-office-for-free-how-to-get-word-excel-and-powerpoint-without-spending-a-dime/

Might work with MS account while connected to a web browser?

dave w

[84Elky]

I'm unsure if there is truly a free version of Microsoft 365 . . . but . . . https://www.cnet.com/tech/services-and-software/get-microsoft-office-for-free-how-to-get-word-excel-and-powerpoint-without-spending-a-dime/

Might work with MS account while connected to a web browser?

dave wUnfortunately this won't work Dave, but thanks for the post. Macros are not supported in the Web Office version. Grrr.

[dave w]

I've used the Log File Analyzer several times (older versions), nothing but many miles of smiles!:jfj:

Worth the price of a free trial for Microsoft 365? . . . YES:thumbsup: https://www.microsoft.com/en-us/microsoft-365/try?rtc=1 . . . just be sure to cancel before the trial period ends!!!:yikes:

dave w

[NomakeWan]

Thanks for the feedback. Yes, it will unfortunately not run on any of the open source platforms (discontinued OpenOffice, LibreOffice, NeoOffice, ApacheOffice, etc.). This is because of differences in how MS integrates VBA and how other versions of BASIC are integrated in the open source. Also regrettable that MS is constantly changing programming standards that open source developers cannot keep up with! This is also the reason I cannot unfortunately do the same which would require multiple versions to support open source. Again, regretable.
Hey, thanks for the response! I figured it would be a difference between BASIC and VisualBasic. Microsoft is notorious for doing exactly this sort of thing in order to make sure your only option is to use their products (remember win32s? DR-DOS? WordPerfect?), so it doesn't surprise me one iota.

I'm sure I have a copy of Office sitting around somewhere. Might as well toss it onto the same laptop I use for tuning stuff and try this again.

[84Elky]

Hey, thanks for the response! I figured it would be a difference between BASIC and VisualBasic. Microsoft is notorious for doing exactly this sort of thing in order to make sure your only option is to use their products (remember win32s? DR-DOS? WordPerfect?), so it doesn't surprise me one iota.

I'm sure I have a copy of Office sitting around somewhere. Might as well toss it onto the same laptop I use for tuning stuff and try this again.Will need 2007 or higher.

[85 Frankenstein]

Hello,
I am trying to download the Log Analyzer but all it does is open up a page like this:

19148

Just a blank page. I tried in Firefox and then Chrome. Am I making a mistake or is there an issue with the file?

Any help is appreciated.

Thank you!

[85 Frankenstein]

Found it!
I searched in Google for the file name. Found another link from the thirdgen.org forum

https://www.thirdgen.org/forums/diy-prom/778399-log-analyzer-quick-tuner.html

[NomakeWan]

Hello,
I am trying to download the Log Analyzer but all it does is open up a page like this:

19148

Just a blank page. I tried in Firefox and then Chrome. Am I making a mistake or is there an issue with the file?

Any help is appreciated.

Thank you!
There was a software update on Gearhead-EFI that unfortunately nuked a whole lot of user attachments in the process. This was clearly one of them.