|
|
|
|
Thread Tools | Display Modes |
02-01-2008, 12:17 AM | #51 | |
Scooby Newbie
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:2005 WRX STi |
Quote:
Best general tuning post of the year.
* Registered users of the site do not see these ads.
|
|
02-01-2008, 06:21 PM | #52 |
Scooby Newbie
Member#: 121154
Join Date: Jul 2006
Chapter/Region:
South East
Location: Knoxville, TN
Vehicle:2002 Impreza WRX PSM Stage 47, Romraided |
Yes, agreed.
|
02-07-2008, 11:25 AM | #53 |
Scooby Guru
Member#: 32792
Join Date: Feb 2003
Chapter/Region:
NESIC
Location: lincoln, ri
Vehicle:2003 GGA MBP 12.9 / 105+ |
i'm glad you know what you're talking about, will... it saves me a lot of time typing in corrections and caveats!
-ken |
02-07-2008, 01:41 PM | #54 |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
|
02-07-2008, 07:27 PM | #55 | |
Scooby Newbie
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:2005 WRX STi |
Quote:
I've never taken a statistics class so I suck at teh numberz. |
|
02-07-2008, 07:33 PM | #56 |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
I bet you could tell it to look at the entire data set, then select only the portion that was within one standard deviation of the minimum value (since in both IAT and dMAFv/dt we're selecting for low values).
|
02-07-2008, 07:37 PM | #57 |
Scooby Specialist
Member#: 15652
Join Date: Feb 2002
Chapter/Region:
TXIC
Location: sugar land, katy
Vehicle:2002 2.5L WRX Wag. 160K club |
apply the 80-20 rule??? take 80% of the data that is closest to 0 is a start.
|
02-07-2008, 08:11 PM | #58 |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
I'd go the other way around, only keep the 20% closest to minimum. Maybe 40%. Definitely less than half.
|
02-07-2008, 11:17 PM | #59 | |
Scooby Newbie
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:2005 WRX STi |
Quote:
Something related to standard deviation sounds like the right route. The 80/20 stuff might be a simpler version. Gonna go look into both methods. I'll take a peak into the ratio of used to discarded data from the manual mehod I did last time. |
|
02-08-2008, 12:26 AM | #60 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
will,
i just sat here, from 9pm-1215am, walking through this 'excel nightmare' LOL my mean & modes are both positives, and close to each other. so i think ive got something wrong. also, every cell in the two columns, with formulas, has an error stating something about grouped cells having data in adjacent cells..?? Oh, I'm so confused LOL screenshot: |
02-08-2008, 12:50 AM | #61 | |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
Quote:
Also, I googled your error and it sounds like it's just excel bitching about the fact that you didn't select all your data. Ignore it. |
|
02-08-2008, 09:59 AM | #62 |
Scooby Newbie
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:2005 WRX STi |
The excel error is just letting you know that the formula is different in one cell than it's neighboring cells. Each of your formulas is looking at a different size data set. It's just trying to help you in case you intend them to all have the same formula. Placing $ in front of the cell column and row pointes should fix it.
ex... change =MODE(E104:E251) to =MODE($E$104:$E$251) OK, I looked at one set of data that I did manually and I ended up using 73% of the data. I'll try to play with STDEV and the other excel functions tonight. |
02-08-2008, 12:15 PM | #63 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
thanks. As long as it isn't an issue, I'm not too worried, then.
I guess I am now concerned with the Corr% column, as I don't quite understand what it's doing, or how I am supposed to use it. As you can see, my Mean/Mode values are very close to one another. I suppose it's the lack of complete data I have come up with, that is really throwing me off.?? |
02-08-2008, 06:24 PM | #64 | |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
Quote:
Don't worry about the mean and mode being similar, that's a good thing. |
|
02-08-2008, 06:59 PM | #65 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
sweet! so I did it right? LOL
I thought I pissed the hours away! So, I guess, this increase in the MAF table that I need to change would, in essence, "add" fuel, or richen it up, for that given example? btw, Excel 2007 blows goats. The "dots" are little diamonds. I had to reduce the size to "2" for the dots, just to make the scatter plot less muddy. Still sucked, tho, but workable. I hate Vista more and more each day. |
02-08-2008, 07:06 PM | #66 | |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
Quote:
Yup, if the correction is positive, the ECU is adding fuel to hit the target AFR. If you tell the ECU more air is coming in, it'll add more fuel and hit the target to begin with and not have to rely on corrections. BTW, plot your modal correction values. Then compare them to the 3 types of fueling error I talked about earlier in the thread. I haven't graphed it, but I think you'll see something. |
|
02-08-2008, 07:55 PM | #67 | |
Scooby Newbie
Member#: 67483
Join Date: Aug 2004
Location: Sacramento, CA
Vehicle:2005 WRX STi |
Quote:
BTW you can use whatever image you want in place of the diamonds. |
|
02-08-2008, 08:35 PM | #68 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
I will say, that some stuff is much easier, like freezing pains, etc. as for changing from dots, my options were diamonds, squares, dashes, and a couple other odd-balls.. why not just a "." LOL
|
02-08-2008, 09:06 PM | #69 |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
Did you plot your modal corrections yet?
|
02-08-2008, 09:15 PM | #70 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
no, not yet... I am at work, but plan to look into it again, here in an hour or so..
|
02-09-2008, 07:25 AM | #71 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
so I piddled with it some more, trying to plot the last part... My plot looks like arse, as I can't figure out the graphing functions. Yes, it is true, I'm not well-versed in Excel.. But here's a screenshot of my Mean/Mode columns, after re-reading the directions, and using the Cor% column for my data, rather than the MAFv column....
the LEFT Mead/Mode columns are where I used the incorrect MAFv column for calcs. The RIGHT Mean/Mode is using Cor% column. The one with #N/A, I've got no idea why. It's =MODE(E5:E6). Cells E5 and E6 are the Cor% column, containing 17.96 & 16.4, respectively. It's a "value not available" error, so I've got no idea.. But as for the scatter plot, using Cor%, Mean, and Mode, I can't get that to work for crap.. |
02-09-2008, 07:41 AM | #72 |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
If you only have 2 values for the 1.74 MAFv cell, you can't have a modal value because neither of the values occur more often than the other
I'm not sure what you're on about by the right/left columns, but in both columns I see a trend you might want to look into. Have you changed injectors by any chance? |
02-10-2008, 11:58 AM | #73 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
ok, ignore the above data. i did it wrong..
So Ive been working on it this morning, and I've got the correct data for Mean/Mode/Cor%.. The last scatter plot, though, with the dotted Cor%, and the lined Mean/Mode values, I cannot duplicate. IOW, I cant figure out how to create that type of chart. Again, I am not Excel literate, by any means! I'm running 3" intake (MAF housing), modded stock injectors.. |
02-10-2008, 12:02 PM | #74 |
Scooby Specialist
Member#: 142133
Join Date: Feb 2007
Chapter/Region:
MAIC
Location: Virginia - hate it
Vehicle:2011 CC Sport and a Cummins Dually |
This is my current results:
My Cor% is about 20k lines deep. |
02-10-2008, 12:08 PM | #75 |
Scooby Guru
Member#: 71092
Join Date: Sep 2004
Chapter/Region:
MWSOC
Location: Licking County, Ohio
Vehicle:2005 2.5RS Wagon Regal Blue Pearl |
OK, let me see if I can remember the order of the steps. I'm doing this without Excel in front of me, so I might be missing things...
1) Make sure MAFv is to the left of the Cor%, Mean, and Mode columns 2) Highlight the MAFv, Cor%, Mean, and Mode columns 3) Click the Chart Wizard 4) Select the XY (Scatter) plot and make sure it has selected the one that doesn't link the points together 5) Let it generate the chart 6) Adjust the X and Y scales to make the chart make sense 7) Pull the chart out to fill the screen left to right 8) Rightclick on one of the data points for Cor% and select format Dataseries 9) Set the foreground and background color to black, set the size to the minimum, set the opacity to 50%. 10) Rightclick on one of the data points for Mean and select Format Dataseries 11) Reduce the size of the marker to the minimum and tell it to add a line between points 12) Do the same thing to Mode 13) ????? 14) Profit! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need help with scaling the MAF | 07wrx4life | Open Source Reflashes | 11 | 05-21-2008 02:21 PM |
One man's trek across 5 dealerships in the Bay Area... | fluxwl | Dealership Reviews | 1 | 07-14-2004 06:45 PM |
One man's junk is another man's needed subaru part | mynew02 | Private 'For Sale' Classifieds | 44 | 05-01-2004 08:40 PM |
One man's junk.... | chkltcow | Off-Topic | 15 | 04-12-2004 04:41 PM |
One man's trash is another man's treasure... | Jarvis | Texas Impreza Club Forum -- TXIC | 13 | 04-22-2002 11:07 PM |