Excel /Spread sheet masters. Question 4 U

[Guest]

In an effort to make tuning considerably more precise and direct, is their a command sequence deployable that can go down the list of say a Tunerpro datalog in spread sheet form and selectively pull out and place in order parameters for a specific RPM only?

For example, I datalog over various throttle applications in the 3000 rpm range instead of looking at say 30 minutes of data, I have the spread sheet systematically find all of the 3000 rpm points, then place them in order according to Kpa value and then all the TPS positions at 3k rpm and X Kpa value and then the O2 reading at that point to help direct to the exact area of the fuel table that needs to be changedl

Illustration could appear like this:

3000 rpm____Kpa______TPS___WBO2 (or AFR etc.)
____________30_______.20___rich
_____________________.35____rich
_____________________.40____rich/lean
_________etc.
____________40_______.20____lean
_____________________.35____lean

and so on.

With a data log organized this way you can immediately go to the rpm, Kpa and TPS position on the VE table of choice and make a near pinpoint adjustment to the problem area and although not in the example you will also have multiple readings at the same Kpa and TPS position to check for bias where if 10 points at the same address show 7 out of 10 readings lean then at that location it is most likely lean despite three rich readings. Am I to ambitious with my idea?

[Joseph Upson]

Had to go back and add under scores to hold the position of the values since the way they appeared in edit was not how they appeared in the post

[SappySE107]

There has to be because other programs do what you are asking. Well, the 3800 owners have an excel sheet program anyway. I don't know how to do it so I can't really help you there. DHP forums has it I think, but I don't have access.

[bszopi]

Send me over your excel file, and I can probably figure it out. I've done some avmazing things in excel before.

[Joseph Upson]

Send me over your excel file, and I can probably figure it out. I've done some avmazing things in excel before.

I'd like to but it's to big for the forum parameters although it is relatively small by standards.

[bszopi]

bszopi@60degreev6.com

[bszopi]

Looking at the way this works, I almost think it might be easier to do via a database. But I'd have to write the interface to make it work. I'll mess with it some more in excel, but I'm not sure its possible the way you want to do it. But I'll try.

[Joseph Upson]

Looking at the way this works, I almost think it might be easier to do via a database. But I'd have to write the interface to make it work. I'll mess with it some more in excel, but I'm not sure its possible the way you want to do it. But I'll try.

Thanks Brad, actually it is very doable, I fiddled with the Excel long enough to find out that you can write a function that calls on a spacific row and column data figure from another file and import it into your blank sheet. Since I'm supposed to be studying, I don't have the time necessary to spend reading the help section long enough to learn all the commands necessary to retrieve values systematically in an algorithm and evaluate them, like for instance retrieve "X" value, if = to XXXX rpm save in A1, and so on for it's related pertinant values.

[bszopi]

With macros, you can do just about anything. But I've never messed with writing macros, so I can't help out on that part.

[ryan.hess]

There is a "sort" function, but the problem is that it sorts a column, and doesn't move the row that the cell is in too, just the cells in the column.

[ghrarhg]

You can do it with the sort function. Just make sure that the 4 columns that you want are next to each other.

If you have it like you mentioned, RPM,MAP,TPS,AFR, select across the top (ie drag from A to D or C to F) to get all 4 columns the whole length of the sheet, then select sort. I have Excel 2007 so it's under the data tab. I don't remember where it is in 2003. If you have you columns labeled at the top, it will say sort by: and there is a drop down menu, pick rpm or the column label that represents rpm, and all 4 columns will be sorted by rpm, and each row will stay with it's respective rpm.