|
RomRaider
Documentation
Community
Developers
|
| Author |
Message |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Sun Nov 02, 2008 12:41 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
|
you probably don't have the table headers in the correct location. Compare a non-modified spreadsheet and yours.
The gearing information has to be manually added if you want to use values other than the "defaults". Scroll over to the right on that page and you'll see the table.
|
|
| Top |
|
 |
|
gto7419
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Nov 03, 2008 6:21 pm |
|
 |
| Newbie |
Joined: Sat Apr 26, 2008 3:57 pm Posts: 39
|
|
I have - the headers appear to be in the right spots - when I can get an internet connection on my comp, Ill upload the spreadsheet so you can take a look... Ive repeatedly tried "copy table" from romraider ecu editor, pasted it below the graph, and pressed the align button. Then I press interpolate and the two left most cells get "marked".
Any chance you can tell me how to manually enter 2nd gear into the calc for accel? Im assuming I have to find the proper ratio and enter it into the the "v" column?
|
|
| Top |
|
 |
|
gto7419
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Nov 04, 2008 12:28 pm |
|
 |
| Newbie |
Joined: Sat Apr 26, 2008 3:57 pm Posts: 39
|
|
Here it is... (removed)
Last edited by gto7419 on Thu Nov 06, 2008 12:40 am, edited 1 time in total.
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Nov 04, 2008 12:38 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
|
Looks like you logged MAFv and used the Calculate Load function to get Load (g/rev). That macro is intended to convert MAF(g/s) to Load (g/rev), not MAFv.
|
|
| Top |
|
 |
|
gto7419
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Nov 04, 2008 12:42 pm |
|
 |
| Newbie |
Joined: Sat Apr 26, 2008 3:57 pm Posts: 39
|
Airboy wrote: Looks like you logged MAFv and used the Calculate Load function to get Load (g/rev). That macro is intended to convert MAF(g/s) to Load (g/rev), not MAFv. ahhh, whoops  - that explains that - any info on the timing issue Im having? hmm - thats probably the issue for both isnt it... THANKS FOR THE HELP!!!!! 
|
|
| Top |
|
 |
|
PolarisSnT
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Dec 08, 2008 4:38 pm |
|
 |
| Newbie |
Joined: Thu Dec 14, 2006 12:17 am Posts: 54
|
|
I was hoping this update would contain it but it does not.
How come there is no load or RPM scaling on the AFR Target page like there is on the Timing page
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Dec 08, 2008 5:06 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
PolarisSnT wrote: I was hoping this update would contain it but it does not.
How come there is no load or RPM scaling on the AFR Target page like there is on the Timing page You could use the one in the "Rescaler" tab (one of the last Tabs off to the right). Copy the Fuel table over and then use whatever header values you need.
|
|
| Top |
|
 |
|
Tronner
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 2:37 pm |
|
 |
| RomRaider Donator |
Joined: Tue Sep 04, 2007 3:56 pm Posts: 170
|
|
I am having a small issue when I try to plot the data in the spreadsheet. I have attached the one I just did. The "Plots" page has funny numbers for Manifold Relative Pressure, and the lines on the graph don't go out to the end of the rpm range?
This is from an 08 STi
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 3:00 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
Tronner wrote: I am having a small issue when I try to plot the data in the spreadsheet. I have attached the one I just did. The "Plots" page has funny numbers for Manifold Relative Pressure, and the lines on the graph don't go out to the end of the rpm range?
This is from an 08 STi Try running the macros again. The data series in "Plots" page in your attached file does not have "x-axis" data for some reason. Plots fine if I re-run the macro on my computer. If it still fails then it could be compatibility of Excel 2008 or something.
|
|
| Top |
|
 |
|
Tronner
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 3:14 pm |
|
 |
| RomRaider Donator |
Joined: Tue Sep 04, 2007 3:56 pm Posts: 170
|
|
OK, it's still not working. Maybe I should try to get an older version of Excel. Every time I do it the X-axis is screwed up.
Thanks for the reply!
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 3:27 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
Tronner wrote: OK, it's still not working. Maybe I should try to get an older version of Excel. Every time I do it the X-axis is screwed up.
Thanks for the reply! Try the following steps: - use "Grab Headers" on Data page - select RPM for x-axis data (should be done automatically with Grab Headers) - select just one item (eg.manifold relative pressure) to plot for the Y1 axis - Plot data and see what comes out
|
|
| Top |
|
 |
|
Tronner
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 3:34 pm |
|
 |
| RomRaider Donator |
Joined: Tue Sep 04, 2007 3:56 pm Posts: 170
|
|
Tried that. I plotted boost error, but the X axis still has values that go from -1000 to 7000 and the line only plots out to about 50 rpms.
Do I have to have data in the log for Throttle, MAF, etc?
I only have boost error, rpm, FBKC, FLKC, Primary WGDC, Man Rel Pressure, both turbo dynamics, target boost, IAM and IAT
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 3:48 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
Tronner wrote: Tried that. I plotted boost error, but the X axis still has values that go from -1000 to 7000 and the line only plots out to about 50 rpms.
Do I have to have data in the log for Throttle, MAF, etc?
I only have boost error, rpm, FBKC, FLKC, Primary WGDC, Man Rel Pressure, both turbo dynamics, target boost, IAM and IAT No, you can select any data item for "x-axis" and combination of data items for "y-axis". Try using a fresh copy of the spreadsheet from this thread and try the plotting function. It might be a change in syntax in the newer version of Excel. You are using Excel 2008?
|
|
| Top |
|
 |
|
Tronner
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 4:17 pm |
|
 |
| RomRaider Donator |
Joined: Tue Sep 04, 2007 3:56 pm Posts: 170
|
|
Well, I think I had the right version - ver4p0j public
I re-downloaded it and tried again. Still the same issue every time in the plot. The funny thing is, the boost and wg tab works just fine.
I am using Excel 2007
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 4:45 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
Tronner wrote: Well, I think I had the right version - ver4p0j public
I re-downloaded it and tried again. Still the same issue every time in the plot. The funny thing is, the boost and wg tab works just fine.
I am using Excel 2007 Sounds like a change in syntax for some of the Visual Basic references then. I'll have to find a PC with Excel 2007 to debug this...I'll pm you if I have anything for you to try.
|
|
| 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
|
|