Advanced theory in excel - Miata Turbo Forum - Boost cars, acquire cats.

Welcome to Miataturbo.net   Members
 


ECUs and Tuning Discuss Engine Management, Tuning, & Programming

Reply
 
 
 
LinkBack Thread Tools Search this Thread
Old 06-27-2013, 01:07 PM   #1
Elite Member
Thread Starter
iTrader: (1)
 
Leafy's Avatar
 
Join Date: Jun 2012
Location: NH
Posts: 9,091
Total Cats: 90
Default Advanced theory in excel

I'm stuck and its time for advanced excel functions time.

So I have data coming in columns thats related, IE I have RPM, Wideband, MAP. How do I make a table that has RPM on one axis, MAP on the other, and the average wideband value in each cell displayed. Like if a cell overs 800-1200 rpm and 20-32 kpa it will display the average of all the wideband values that fall in that range. Size of the input data will always be different but assume it'll be in the 10,000 data points area. Does this require a macro? And what would that look like? Making macros are my excel weak-point.

This is the more simple version. The end goal is to have my target AFR table from the tune also in this spreadsheet and make a table the same size as my fueling table in the tune that displays AFR % Error, so I know where and how much to change the tune. I know how to do this part though, its the easy part.

Unneeded but will probably be asked. AEM EMS4 is the ecu in question.
Leafy is offline   Reply With Quote
Old 06-27-2013, 04:45 PM   #2
Elite Member
 
Join Date: Jul 2005
Posts: 6,454
Total Cats: 80
Default

BTDT, but forgotten how, sorry.

One thing you gotta watch out for, is that you have some kind of marker that the data is "stable", i.e., it's been in that cell for x seconds, so you weed out transients. You need to weed out the effect of throttle enrichment, and the time lag of the O2 sensor (especially at low airflows).

For such large datasets, I would use Matlab, Scilab, or R instead of Excel.
R has the advantage of being designed for statistical analysis (which is what you're doing). You can get fancy and produce a distribution curve (or median and standard deviation), per cell in your map.
JasonC SBB is offline   Reply With Quote
Old 06-27-2013, 08:05 PM   #3
Elite Member
Thread Starter
iTrader: (1)
 
Leafy's Avatar
 
Join Date: Jun 2012
Location: NH
Posts: 9,091
Total Cats: 90
Default

Pivot table is what I needed. Thats a good point about transients. I was going to add a filter to the data for dtps since I can log dtps.
Leafy is offline   Reply With Quote
Old 07-02-2013, 11:20 AM   #4
Senior Member
iTrader: (1)
 
Join Date: Oct 2009
Posts: 1,435
Total Cats: 58
Default

Pivot tables are powerful. That's what I was going to recommend. If I can't get what I need from a pivot table, usually I'll start with one, then copy paste only the information I need into other simple formulas.

Glad you figured it out.
Enginerd is offline   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
1994 Spec Miata Race Car SM/SM2/SSM For Sale Quinn Cars for sale/trade 6 10-23-2016 08:58 AM
Hey everyone another n00b here Big_gumby Meet and Greet 80 10-05-2015 05:06 PM
Back to Stock Part Out!! Turbo Parts, MS2 Enhanced 01-05, Suspension, and MOAR! StratoBlue1109 Miata parts for sale/trade 16 10-02-2015 10:39 AM
Bad head gasket or ? shooterschmidty Engine Performance 8 09-30-2015 11:28 PM
In need of base map for stock 1997 brandonbkd MEGAsquirt 0 09-29-2015 12:52 AM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 02:24 PM.