|
RomRaider
Documentation
Community
Developers
|
| Author |
Message |
|
lixid
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Wed May 07, 2008 8:34 am |
|
 |
| Newbie |
Joined: Sat Apr 14, 2007 12:37 pm Posts: 3
|
|
this is the log file that i use
|
|
| Top |
|
 |
|
lixid
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Wed May 07, 2008 8:35 am |
|
 |
| Newbie |
Joined: Sat Apr 14, 2007 12:37 pm Posts: 3
|
Airboy wrote: lixid wrote: something wrong with the graph... please help I am going to guess that the log file has a lot of items (long sampling intervals) and contained data after you let off of the accelerator and was slowing down. The calculations would have better resolution if only log RPM and throttle (so that you can filter it). i will try that when i get a chance
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 02, 2008 9:54 pm |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
|
Airboy, some of the 5EAT guys asked about using the dyno function. I added a MPH parameter to the dyno function. The parameter has a "None" button so it can always revert back to using rpm. IIRC, the 32 bit ecu's use the ABS sensor to log vehicle speed. From my own 5MT datalogs, I know that the mph and rpm match very linearly, so I'm fairly sure that the LGT 5EAT will be able to use this.
I don't have the calibrations for the LGT 5EAT, but they'll still be able to use it as a tuning tool for comparing one run to the next run. It'll be like a dyno chart using an induction pickup to read rpm.
BTW, I also added a total timing chart and a table rescaler. I deleted the load and rpm rescaler from the other charts. I didn't like the way shepard's method would screw around with some of the data. I use the 2D rescaler to change the MAFv table. It's very handy to reduce resolution in areas that don't need it and increase resolution in areas where there are erratic behavior.
[edit - bug]
Last edited by mickeyd2005 on Fri Jun 06, 2008 3:46 pm, edited 1 time in total.
|
|
| Top |
|
 |
|
williaty
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 02, 2008 10:34 pm |
|
 |
| Experienced |
Joined: Tue Jul 24, 2007 6:28 pm Posts: 349
|
mickeyd2005 wrote: IIRC, the 32 bit ecu's use the ABS sensor to log vehicle speed. From my own 5MT datalogs, I know that the mph and rpm match very linearly... Are you sure about this? The 32bit ECUs list a "VSS" parameter (which I've had to tap the wire for, hence my knowledge of this) that supposedly pulses 4x per revolution of the center diff. Picking up the speed from the ABS tone wheels would contradict this. Not saying I'm right, just saying there's different data out there.
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 02, 2008 11:07 pm |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
williaty wrote: mickeyd2005 wrote: IIRC, the 32 bit ecu's use the ABS sensor to log vehicle speed. From my own 5MT datalogs, I know that the mph and rpm match very linearly... Are you sure about this? The 32bit ECUs list a "VSS" parameter (which I've had to tap the wire for, hence my knowledge of this) that supposedly pulses 4x per revolution of the center diff. Picking up the speed from the ABS tone wheels would contradict this. Not saying I'm right, just saying there's different data out there. I'm not sure. It's what I heard. However, I know that the LGT 5MT is accurate. I also looked at the LGT 5EAT mph and rpm graphs and they look like what I expect. It's accurate enough to see when the torque converter locks up and what the stall speed is. Before Airboy completely rewrote the road dyno spreadsheet, I tried it with some LGT 5EAT and the road dyno did work as expected.
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 02, 2008 11:13 pm |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
|
| Top |
|
 |
|
williaty
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 02, 2008 11:32 pm |
|
 |
| Experienced |
Joined: Tue Jul 24, 2007 6:28 pm Posts: 349
|
|
I think that post contained the critical fact: CAN. He mentions the ABS sensors being used to derive car speed in the context of a CAN system. It wouldn't surprise me if the pre-CAN 32bit ECUs still derive speed from the VSS as the Impreza service manual says but the new CAN-based systems have moved on.
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Jun 03, 2008 12:00 am |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
williaty wrote: I think that post contained the critical fact: CAN. He mentions the ABS sensors being used to derive car speed in the context of a CAN system. It wouldn't surprise me if the pre-CAN 32bit ECUs still derive speed from the VSS as the Impreza service manual says but the new CAN-based systems have moved on. No. He is referring to CAN as in car area network. I am sure that post is referring to 2005-2006 LGTs. I do not believe he is referring to the new OBDII-CAN interface.
|
|
| Top |
|
 |
|
williaty
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Jun 03, 2008 12:42 am |
|
 |
| Experienced |
Joined: Tue Jul 24, 2007 6:28 pm Posts: 349
|
I had not realized that CAN (which I was, as you say, expanding to Car Area Network) had any valid application outside of the new-model cars as an ODB-II replacement. However, to further muddy the issue, if you look in the 2005 Impreza Service Manual (I've other years too, but this is the one I had in front of me), page 5MT-38 shows where on the tranny the VSS is and how to replace it and then page 5MT-76 shows the internal gearing that couples the VSS to the geartrain inside the tranny. Yet, in seeming contradiction to this, page IDI-11 states that: Quote: 2. OPERATION The ABS or VDC control module calculates the vehicle speed based on signals from the four wheel speed sensors and sends vehicle speed signals (4 pulses per rotation of wheel) to the speedometer drive circuit and odometer/trip meter drive circuit in the speedometer.
NOTE: Signals from the ABS or VDC control module are also used by the engine control module, automatic transmission control module, etc. To exit the realm of the tech spec, and enter the realm of the practical, things get even more confusing. I have my VSS wire tapped. I know from real-world calibration that each pulse of the VSS is worth 1/2420th of a mile, which is about 2.18ft. Multiplying this by the 4 pulses per rev that the manual claims, this would lead to 8.73ft per rev of the wheel or 605 revolutions per mile. However, the wheel actually covers about 6.30ft per rev, or 838 revolutions per mile. This discrepancy seems to imply the VSS signal seen at the ECU is NOT the pulse of the ABS tone wheels. Sadly, the math doesn't come out any better for the VSS being in the center diff and the math is too involved to be worth posting here. In other words, NFC.
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Jun 03, 2008 2:09 am |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
mickeyd2005 wrote: Airboy, some of the 5EAT guys asked about using the dyno function. I added a MPH parameter to the dyno function. The parameter has a "None" button so it can always revert back to using rpm. IIRC, the 32 bit ecu's use the ABS sensor to log vehicle speed. From my own 5MT datalogs, I know that the mph and rpm match very linearly, so I'm fairly sure that the LGT 5EAT will be able to use this.
I don't have the calibrations for the LGT 5EAT, but they'll still be able to use it as a tuning tool for comparing one run to the next run. It'll be like a dyno chart using an induction pickup to read rpm.
BTW, I also added a total timing chart and a table rescaler. I deleted the load and rpm rescaler from the other charts. I didn't like the way shepard's method would screw around with some of the data. I use the 2D rescaler to change the MAFv table. It's very handy to reduce resolution in areas that don't need it and increase resolution in areas where there are erratic behavior. Thanks for the additions, Michael. The LGT must have different way to get vehicle speed because, as I mentioned before, for my '06 WRX, RPM and MPH don't track each other very well.
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jun 06, 2008 3:47 pm |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
|
Sorry. There was a major bug in the spreadsheet that I modified for 5EAT. It calculated accel and hp but then stopped there. The calculations for torque and the graphs were based on the wrong column.
|
|
| Top |
|
 |
|
LittleBlueGT
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 09, 2008 1:08 am |
|
 |
| Experienced |
 |
Joined: Mon Apr 30, 2007 8:02 pm Posts: 521
|
|
I heard there is another revision with total timing table.
Is that ready yet...........Mike??????????
_________________ 05 LGT (ST and OS tuning) AVO380/TMIC/header/TBE/alky/AEM CAI
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 09, 2008 1:18 am |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
|
I don't know if it's ready, but it's available for checking. It's in the post right above yours.
Scroll to the far right and you will see a spreadsheet called TotalTiming. It gets its data from the base and dynamic advance table. Scroll to Column AR and you will see a plot.
|
|
| Top |
|
 |
|
LittleBlueGT
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 09, 2008 1:44 pm |
|
 |
| Experienced |
 |
Joined: Mon Apr 30, 2007 8:02 pm Posts: 521
|
|
I tried it seems to work nicely, it says 5eat only, but it seems to work OK, what is for the auto only?
_________________ 05 LGT (ST and OS tuning) AVO380/TMIC/header/TBE/alky/AEM CAI
|
|
| Top |
|
 |
|
mickeyd2005
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Jun 09, 2008 1:48 pm |
|
 |
| Administrator |
 |
Joined: Wed Oct 25, 2006 12:32 am Posts: 3040
|
LittleBlueGT wrote: I tried it seems to work nicely, it says 5eat only, but it seems to work OK, what is for the auto only? The Dyno function is for the 5EAT only although it seems to still work okay with the 5MT. I changed the MPH and RPM smoothing. MPH is either obtained from the log or it is calculated from the rpm and gear data. Then the MPH is smoothed. The dyno function that Airboy wrote smoothes out the RPM first.
|
|
| Top |
|
 |
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
|
|