The purpose of this spreadsheet is to create a table to summarize knock data. It is meant to fine tune the timing table after it has been set up using WOT logs. This spreadsheet assumes that the ROM is set up such that an IAM of 1 can be maintained.
This is based upon the information that merchgod provided here: viewtopic.php?t=1840
and was inspired by varmint's request here:
When romraider was down, I posted version 12 on nasioc and received some feedback from normally aspirated users.http://forums.nasioc.com/forums/showthr
This spreadsheet keeps track of fine learning knock correction. So far, I have been able to track it reasonably well when I used merchgod's learning viewer tool.
This spreadsheet does not include knock from poor tip-in. I eliminated that on purpose because I didn’t want to subtract base timing due to throttle changes which really are not dependent upon rpm-load location in the base timing table.Instructions
Instructions are embedded in the spreadsheet.VE Added
Since all the parameters are logged, I added a VE table as well. This was recommended by Freon in his post here:
This is useful for tuning AVCS.
There are some caveats with the VE table. The VE includes a rudimentary correction for temperature (absolute temperature ratio). Also, you have to be careful that some data points may be anomalies. It uses an average for each cell but each cell may have as little as one data point in it.
EDIT: Added a subroutine to VE spreadsheet that automatically color cells with too little data as light grey.
EDIT: The pivot tables in the VE spreadsheet were changed so that the fields are ascending.
EDIT: Added Intake Air temperature to air density calculation. IAT is set up for Fahrenheit. Note that if you don't log IAT, you can enter in a default value in the box provided.
EDIT: Added fine learning tracking.
EDIT: Uses merchgod learning view tool and FLKC offset parameter.