|
RomRaider
Documentation
Community
Developers
|
| Author |
Message |
|
Merp
|
Post subject: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Fri Feb 10, 2012 2:15 pm |
|
 |
| Experienced |
 |
Joined: Thu Jul 23, 2009 1:46 pm Posts: 863
|
|
This spreadsheet is used to build a VE base map using your current MAF.
Notes: Designed for excel 2003. Compatible with Cobb SD, just paste your SD table in the ROM section.
Changelog: v0.2 sorting bug fix v0.3b added more auto-selection, allows different units of MAP, added compatibility for Cobb SD v0.4b added AFR Tuning, error% = (wideband - FFB)/FFB
Thanks to Airboy for the MRP comp spreadsheet that this is heavily based on.
_________________ Please do not send me support questions via PM, use the forum instead!
Last edited by Merp on Thu Apr 05, 2012 4:22 pm, edited 2 times in total.
|
|
| Top |
|
 |
|
GRawSTi
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sat Feb 11, 2012 12:26 pm |
|
 |
| Newbie |
Joined: Mon Jan 30, 2012 10:18 pm Posts: 22
|
|
I like where you're going with the Tune Table from AFR. Should this be functional in v0.3b? The button doesn't appear to do anything. Also, I get two errors when I open up the table:
The PivotTable field name is not valid. x2
|
|
| Top |
|
 |
|
Merp
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sat Feb 11, 2012 5:48 pm |
|
 |
| Experienced |
 |
Joined: Thu Jul 23, 2009 1:46 pm Posts: 863
|
|
v0.3b doesn't have table tuning active, but will be in the next revision.
I just checked and I only get those errors on excel 2010, I'll have to check it out.
_________________ Please do not send me support questions via PM, use the forum instead!
|
|
| Top |
|
 |
|
td-d
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Wed Apr 04, 2012 11:37 am |
|
 |
| Moderator |
Joined: Thu May 20, 2010 4:01 am Posts: 3117 Location: Johannesburg, South Africa
|
|
Hey Merp - did you ever get round to implementing the AFR error part of this spreadsheet? Been running a pretty solid map now, also slowly tinkering with the MAF / IAT comp tables - would be great to be able to automate some of the grunt work...
Cheers
_________________ He who dies with the most gadgets wins.
Please do not PM me - use the email option.
|
|
| Top |
|
 |
|
Merp
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Thu Apr 05, 2012 2:30 pm |
|
 |
| Experienced |
 |
Joined: Thu Jul 23, 2009 1:46 pm Posts: 863
|
|
Updated with a beta for the AFR tuning. Creates a pivot table of AFR error against FFB. Of course, you can use OL target as the reference as well.
Error % is calculated as (Wideband - FFB)/FFB, so a positive error translates to a lean condition, requiring an increase in VE table. This is the opposite of the MAF-table-build function, where a positive error translates to a rich condition.
Next revision I will try to add a referencing routine if possible, for IAT comps.
For every file you import I could have it calculate an average % error and average IAT, then store them in a table for long-term IAT tuning.
_________________ Please do not send me support questions via PM, use the forum instead!
|
|
| Top |
|
 |
|
dj-phoenixx
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sat Jul 21, 2012 8:29 am |
|
 |
| Newbie |
Joined: Sat Feb 13, 2010 3:33 pm Posts: 31 Location: Germany
|
|
Hi, what Final Fueling Base must been logged? 2 byte or 4 byte. and it is estimatet AFR, Lambda or fuel air equivalence ratio?
And what BOV setting must been driven? Fully closed or the later setting I'ld drive?
Greets Marcel
_________________ 2005 USDM Legacy GT TwinScroll 6MT DCCD 1999 BMW 323ti
|
|
| Top |
|
 |
|
Merp
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sat Jul 21, 2012 12:45 pm |
|
 |
| Experienced |
 |
Joined: Thu Jul 23, 2009 1:46 pm Posts: 863
|
|
Either 2-byte or 4-byte should work, but I normally log 4-byte parameters only to avoid issues with 2-byte range limits.
Fueling parameters in the spreadsheet are all in AFR units.
As for the BOV, I think the results will be more consistent if you keep it closed while building the VE map.
_________________ Please do not send me support questions via PM, use the forum instead!
|
|
| Top |
|
 |
|
RAGETuning
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sat Jul 21, 2012 4:30 pm |
|
 |
| Newbie |
Joined: Mon Jan 05, 2009 10:53 am Posts: 18
|
|
Okay. Here is my delima.
I need the spreadsheet to calulate maf g/sec for a table that is RPM vs Manifold Absolute Pressue (BAR).
It seems none of the are working for me. I have a driving data log and I need the spreadsheet to take the log and create the table using the log data.
Example: MAP (Absolute) -------------------------------------------------------------------- RPM
500 1.15
Last edited by RAGETuning on Wed Sep 19, 2012 12:02 pm, edited 2 times in total.
|
|
| Top |
|
 |
|
dj-phoenixx
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sun Jul 22, 2012 4:59 pm |
|
 |
| Newbie |
Joined: Sat Feb 13, 2010 3:33 pm Posts: 31 Location: Germany
|
|
Hi, what is the best driving circuit for the best result? Driving around for an half hour up to two hours. And very small throttle changes? Maybe with cruise control?
And what VE table can paste in ROM section if I have'nt one. I'ld use NSFW's Rom Patch and they are no VE's entered.
Marcel
_________________ 2005 USDM Legacy GT TwinScroll 6MT DCCD 1999 BMW 323ti
|
|
| Top |
|
 |
|
RAGETuning
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Wed Sep 19, 2012 12:03 pm |
|
 |
| Newbie |
Joined: Mon Jan 05, 2009 10:53 am Posts: 18
|
RAGETuning wrote: Okay. Here is my delima.
I need the spreadsheet to calulate maf g/sec for a table that is RPM vs Manifold Absolute Pressue (BAR).
It seems none of the are working for me. I have a driving data log and I need the spreadsheet to take the log and create the table using the log data.
Example: MAP (Absolute) -------------------------------------------------------------------- RPM
500 1.15 bump
|
|
| Top |
|
 |
|
fastblueufo
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Mon Sep 24, 2012 2:08 pm |
|
 |
| Senior Member |
Joined: Thu Mar 27, 2008 1:00 pm Posts: 1333 Location: Bama, 02 wrx, stroked ej22t, pt5857, ppg, E85 (fear the ear) ed@fastperformancetuning.com
|
|
What exactly are you looking for? No spreadsheet is going to auto tune the car for you. Why are you wanting to calculate maf g/s when you are not tuning with the maf?
|
|
| Top |
|
 |
|
h$h
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Wed Feb 20, 2013 6:09 pm |
|
 |
| Newbie |
Joined: Wed Feb 20, 2013 6:03 pm Posts: 1
|
|
Any idea about SD for an 07 STI? Where can i find it? Anyone currently running 32bit SD on an 07 sti with out having the access port?
|
|
| Top |
|
 |
|
Merp
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Fri Feb 22, 2013 12:39 am |
|
 |
| Experienced |
 |
Joined: Thu Jul 23, 2009 1:46 pm Posts: 863
|
|
07 STi is very very close. Has been for some time but time is in short supply.. Soon!
_________________ Please do not send me support questions via PM, use the forum instead!
|
|
| Top |
|
 |
|
STI2NR
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Fri May 03, 2013 8:55 am |
|
 |
| Experienced |
Joined: Wed Dec 21, 2011 10:37 pm Posts: 429
|
|
What are you using for input of VE SD flow g/s?? Is there a way to log this value??
4th gear pull attached.
If I paste my rom ve table in the rom page does the spreadsheet modify the table for me?
_________________ 2005 BAJA with a complete 2005 STI conversion ADF lifted 6" tube framed sitting on mattracks.
|
|
| Top |
|
 |
|
STI2NR
|
Post subject: Re: SPREADSHEET: 32-Bit Speed Density Map Builder Posted: Sun May 05, 2013 10:36 pm |
|
 |
| Experienced |
Joined: Wed Dec 21, 2011 10:37 pm Posts: 429
|
|
How do I apply the el comp page to the rom page?? I have been doing it one cell at a time manually.
Is there a formula button I am not seeing??
I understand everything else now but am stumped at how to transfer the EL comp page to the rom ve table.
Any help would be greatly appreciated.
_________________ 2005 BAJA with a complete 2005 STI conversion ADF lifted 6" tube framed sitting on mattracks.
|
|
| 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
|
|