|
RomRaider
Documentation
Community
Developers
|
 
|
Page 1 of 1
|
[ 5 posts ] |
|
| Author |
Message |
|
nsfw
|
Post subject: NSFW's Log Analysis Spreadsheet  Posted: Sat Oct 16, 2010 5:38 am |
|
 |
| Moderator |
Joined: Wed Nov 22, 2006 10:23 pm
Posts: 2565
|
|
The basic idea behind this spreadsheet is to combine several logs and illustrate the data with scatter plots, so that a bunch of logs can be analyzed at once.
There are several pages in this spreadsheet... The first page has instructions for using it.
The next page ("Raw") is a place to page a series of data logs, and the next page after that ("Calculated") is where all of the remaining pages get their data. After pasting logs in to the Raw page, I add or remove columns so that it matches the Calculated page, and then copy-paste everything from Raw to Calculated. The Calculated page includes a bunch of columns that are calculated from what got logged, for example there's an "AFR Error" column that contains the difference between the logged AFR and the desired AFR.
The remaining pages mostly hold scatter plots of the Calculated data, so you can look at it from different perspectives. Some of those scatter plots are useful. Some are useless and were just added out of curiosity. Most of the pages have some hints about what's useful and what's not.
This is a thread for questions and answers about how to use the spreadsheet itself. This is not a thread for questions and answers about my tune, or my logs. I'm going to revise the attached spreadsheet over time, and the data will change every time, so any questions or comments about the logs or the tune will be meaningless to someone who looks at the spreadsheet a couple months later.
I have a high-resolution 24" monitor (1920x1200), so feel free to resize and rearrange things to fit on your screen. You will almost certainly need to do some re-arranging to make the spreadsheet usable if you have a smaller monitor.
| Attachments: |
File comment: Same thing as below, but in an older Excel format.
v126-General.xls [18.5 MiB]
Downloaded 708 times
|
File comment: This one contains a couple dozen pulls, some longer and some shorter. I typically only load 5-7 pulls at a time, though. Also, if you look closely, you'll see early signs of clutch slip.
v126-General.xlsx [3.43 MiB]
Downloaded 975 times
|
_________________
2005 Legacy GT w/ ATP 3076, IWG, MBC, BCS, BC 272, LC, FFS, OMG
Please don't send questions via PM. Post a thread and send me a link to it instead. Thanks!
Last edited by nsfw on Thu Nov 04, 2010 5:37 am, edited 1 time in total.
|
|
| Top |
|
 |
|
Mohamamdov
|
Post subject: Re: NSFW's Log Analysis Spreadsheet Posted: Tue Oct 26, 2010 8:11 am |
|
|
| Experienced |
Joined: Sun Aug 24, 2008 3:37 pm
Posts: 107
Location: Jordan
|
|
Thanx man,seems very cool tool.
|
|
| Top |
|
|
|
Woody
|
Post subject: Re: NSFW's Log Analysis Spreadsheet Posted: Sat Oct 30, 2010 1:12 am |
|
|
| Newbie |
Joined: Sat Jan 16, 2010 3:22 pm
Posts: 64
|
|
Hi,
I'm guessing this is in a newer excel program, having trouble opening it.
regards
|
|
| Top |
|
|
|
nsfw
|
Post subject: Re: NSFW's Log Analysis Spreadsheet Posted: Thu Nov 04, 2010 5:52 am |
|
|
| Moderator |
Joined: Wed Nov 22, 2006 10:23 pm
Posts: 2565
|
|
I've added a copy that should be compatible with older versions of Excel. I don't think anything important was lost in the conversion.
_________________
2005 Legacy GT w/ ATP 3076, IWG, MBC, BCS, BC 272, LC, FFS, OMG
Please don't send questions via PM. Post a thread and send me a link to it instead. Thanks!
|
|
| Top |
|
|
|
sureshot007
|
Post subject: Re: NSFW's Log Analysis Spreadsheet Posted: Wed Dec 19, 2012 10:02 am |
|
|
| Newbie |
Joined: Fri Aug 31, 2007 7:43 pm
Posts: 49
|
|
I was just about to do something similar (ok, not anywhere near as complex), and I found this!
My question is what do I do if I don't have "Knock Sum" available?
|
|
| Top |
|
|
|
|
Page 1 of 1
|
[ 5 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
|
