|
RomRaider
Documentation
Community
Developers
|
| Author |
Message |
|
Tronner
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Fri Jan 02, 2009 4:46 pm |
|
 |
| RomRaider Donator |
Joined: Tue Sep 04, 2007 3:56 pm Posts: 170
|
|
| Top |
|
 |
|
zigzagzok
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Feb 03, 2009 5:12 am |
|
 |
| Newbie |
Joined: Thu Aug 24, 2006 12:42 pm Posts: 34
|
hi anyone know how to add cols into the timing. afr, wastegate and avcs maps in the sheets? think they are currently configured for 16bit ecus ... most excellent tool! 
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Feb 03, 2009 5:22 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
zigzagzok wrote: hi anyone know how to add cols into the timing. afr, wastegate and avcs maps in the sheets? think they are currently configured for 16bit ecus ... most excellent tool!  Use the method (Aligna and Move Copied Table) outlined in the first sheet to transfer the primary 3D tables from RomRaider to Excel. The macros will do most of it for you (clear out old table, move new table into position, etc).
|
|
| Top |
|
 |
|
Wideboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Tue Feb 17, 2009 10:29 am |
|
 |
| Newbie |
 |
Joined: Wed Feb 06, 2008 11:40 am Posts: 16 Location: Leicester, UK
|
|
I am starting to understand this spreadsheet (a little)
I have found my MAF error and have a little graph of it.
Is there some way to automagically update the MAF table or do I have to do that by hand?
_________________ 2001 EDM WRX, RCM Inlet & K&N; RCM Tubular Manifold & 3" TBE Walbro255 & STi Pinks Eibach springs & STi Dampers; Prodrive 330mm Brakes Silver Scoop
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Feb 26, 2009 4:47 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
Wideboy wrote: I am starting to understand this spreadsheet (a little)
I have found my MAF error and have a little graph of it.
Is there some way to automagically update the MAF table or do I have to do that by hand? Update to the MAF table has to be done manually.
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Feb 26, 2009 4:50 pm |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
Bump for new version Some additional functionality: -Total Timing table can be adjusted and new Base timing table can be calculated from "Total - Adv" -Total timing headers now evenly spaced, with max values taken from Base and Adv (higher of the two). Min Load is taken from Base Timing -Accel page can now handle data logs with Seconds as time units (Cobb AP2 logs) Visual stuff: -Color scale for contour plots set to be similar to the cell colors -Throttle map interpolated results uses evenly spaced accelerator pedal angle values -FLKC grid can be toggled on/off
|
|
| Top |
|
 |
|
dwmoss
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Feb 26, 2009 5:37 pm |
|
 |
| Newbie |
Joined: Tue May 02, 2006 12:02 pm Posts: 96 Location: NE PA
|
Airboy wrote: Bump for new version Many thanks for all your work on this! dm
|
|
| Top |
|
 |
|
tabrad
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Mar 02, 2009 1:31 am |
|
 |
| Newbie |
Joined: Thu Feb 07, 2008 9:14 pm Posts: 18
|
|
Do you mind telling me the calculation that you used to get the horsepower and tq numbers? I have been looking at the sheet and cant really find it
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Mon Mar 02, 2009 3:20 am |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
tabrad wrote: Do you mind telling me the calculation that you used to get the horsepower and tq numbers? I have been looking at the sheet and cant really find it The equations used for the calculations are "inside" the macros. If you open up the Visual Basic Editor in Excel, you can see the code. The acceleration macros are commented with references to wikipedia pages.
|
|
| Top |
|
 |
|
bcs925
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Wed Mar 04, 2009 7:55 pm |
|
 |
| Newbie |
Joined: Sun Jul 27, 2008 1:37 pm Posts: 7
|
|
Am I just dumb or can anyone else not figure how to use the dyno plot. I dont have a log of just time and rpm but that doesnt seem to matter based off the log thats pre loaded when I downloaded the file. I am uploading my spreadsheet with my log on it and if anyone can tell me what I did wrong I would greatly appreciate it. The log on there is a 4th gear pull, its not the best but its the only one I have on this computer. Car is a 2007 WRX sdn.
P.S. I am going to do some logging tonight so if theres any parameters I should log lmk. I will definatley be doing a rpm only log. 3rd gear from 2k to close to redline.
***EDIT*** did a pull with just rpms and boost... works like a charm, awesome spreadsheet, got 252hp/325tq, which is about what I expected but always nice to know.
|
|
| Top |
|
 |
|
SUPERAnimal
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Mar 05, 2009 1:15 am |
|
 |
| Newbie |
Joined: Sat Feb 21, 2009 2:44 am Posts: 21
|
|
Whenever i open the spreadsheet i get an error. The error says; This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error046240_01.xml</logFileName> <summary>Errors were detected in file 'C:\DOCUME~1\JONBER~1\LOCALS~1\Temp\Temporary Directory 3 for Log file interpolation ver4p0w public.zip\Log file interpolation ver4p0w public.xls'</summary> - <additionalInfo> <info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info> </additionalInfo> </recoveryLog>
I dont know if that does anything for you, but it sure confuses me. Thanks for any help you can give.
|
|
| Top |
|
 |
|
Airboy
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Mar 05, 2009 11:51 am |
|
 |
| RomRaider Donator |
Joined: Wed Aug 02, 2006 9:40 pm Posts: 1067 Location: Calgary
|
SUPERAnimal wrote: Whenever i open the spreadsheet i get an error. The error says; This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error046240_01.xml</logFileName> <summary>Errors were detected in file 'C:\DOCUME~1\JONBER~1\LOCALS~1\Temp\Temporary Directory 3 for Log file interpolation ver4p0w public.zip\Log file interpolation ver4p0w public.xls'</summary> - <additionalInfo> <info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info> </additionalInfo> </recoveryLog>
I dont know if that does anything for you, but it sure confuses me. Thanks for any help you can give. What are you using to open the spreadsheet?
|
|
| Top |
|
 |
|
snikkels
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Mar 05, 2009 4:34 pm |
|
 |
| Experienced |
Joined: Sun Sep 02, 2007 10:08 am Posts: 119
|
|
Can someone tell me how the timing sheet works?
I have search on this topic but i don't get it.
What must i change and why must it change?
|
|
| Top |
|
 |
|
SUPERAnimal
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Mar 05, 2009 5:19 pm |
|
 |
| Newbie |
Joined: Sat Feb 21, 2009 2:44 am Posts: 21
|
|
microsoft office excel 2007
|
|
| Top |
|
 |
|
rodney757
|
Post subject: Re: Spreadsheet to import and graph log files Posted: Thu Mar 05, 2009 8:34 pm |
|
 |
| Newbie |
Joined: Wed Feb 18, 2009 5:06 pm Posts: 37
|
|
I am also a little confused on the timing sheet. When I hit interpolate I see that some cells are outlined. Are these the cells that need to be changed? Thanks
|
|
| 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
|
|