MS Log Visual Viewer

[kyle242gt]

Ooookay, so here about the time I thought I knew a lot about MS, I decided to try something new! Not new, in fact, it's old as the hills, but quite fun and informative to use.

MS Log Visual Viewer (http://www.msefi.com/dload.php?action=file&file_id=99)

You will probably need to register and log in to download it.

Upon DL, unzip (no installation) and run TBLGEN.exe It starts set up for Innovate (I think) so you need to enter data if you use a different WB, such as Tech Edge:
http://wbo2.com/2a0/afrlin.gif

Then you open your datalog, and enjoy the play by play. It took a few minutes to get acclimated, but then, holey jeebuz, it's like driving the same trip again. I really enjoyed seeing the wind up through first, shift, second, shift, third, while monitoring TPS, boost, AFR, and duty cycle.

This may be old news (it IS old news) but it's still extremely cool.

After some jacking around uploading from my laptop, I'll be back to show you some interesting things, and of course ask questions aplenty. :rockon: Feel free to DL the dlupload.zip, it's a short datalog... no way to get it off my laptop except by posting it :roll:

Okay and I'm back.

In Log1, I get great satisfaction from the fact that I'm exceeding 100DC% without issue. And if you look at the second area, where the TPS (light blue) spikes up, settles down, and spikes up again, watch MAP (purple) spike up, sit back down, and spike again. Really cool.

In Log2, my question. This is just an example, but I'm finding that the desired increase/decrease in AFR seems to trail the TPS/MAP events by .1 to .5 seconds. Is that just because the WB02 is two feet downstream of the engine?

[CountOfNowhere]

Mmm... Jared was playing with this a while ago. It's quite quite cool.

Quite very much cool-ness

[The Aspirator]

You just figured out the log viewer? Now I've never really used MSTweak3k, but I've been using the log viewer since the beginning, that new beta version is pretty sweet. Here's something you might not know, while logging in MegaTune, hit the spacebar at a certain point you want to remember, then in the log viewer you can see these points :-D . It's super nice, for example "my car runs chuggs right...... HERE! hit the spacebar" then check it in the log.

I've also noticed that the AFR trails the TPS/MAP/RPM by a little bit, but think about it, the MAP and TPS are essentially registered "before" the engine, with RPM sorta "being" the engine, and AFR being read quite a while later.

Logs are pretty fun, and I think you can change some of the basic lines (like GEO) to be something more useful like..... I dunno.... spark advance or something. I know it datalogs spark advance, but the log viewer doesn't show it. You'll have to bust out Excel to view that and many others.

John

[kyle242gt]

Thanks John, appreciate the insight. The spacebar is handy to know as well.

New updated MST3K is also on my agenda.

[adrianpike]

I <3 MST3k. Been using it since the beginning to get my maps tuned in.

[kyle242gt]

.

[ovlov760]

I usually prefer to view log in Excel when I'm tuning. In the Excel logs your AFR is shows as 0-5v. I know the formula to convert the number to but how do I apply the formula to the entire column in Excel? I know how to apply it to one cell but not all of them. The formula is show here:
http://wbo2.com/2a0/afrlin.gif
=(v*2)+9

[Two 87s]

I usually prefer to view log in Excel when I'm tuning. In the Excel logs your AFR is shows as 0-5v. I know the formula to convert the number to but how do I apply the formula to the entire column in Excel? I know how to apply it to one cell but not all of them.

You know how you can copy the formula cell and paste into the next cell, and it updates so that it's using the data from that line? Well, if you click into the next cell, and then scroll to the last row, and then holding shift, click that cell, it will select all the cells in between. Then paste. It should paste the formula, but update it to use the correct data from each row. Then that entire column will have that formula in it.

My next problem is that I wanted to be able to paste that info into another spreadsheet (Poi's tuning sheet). But you want to paste the data, not the formulas. Well, select that whole column again in the same manner, and paste "special" it into the next column. One of the "paste special" options is to paste the values instead of the formulas. That gets me in the raw data that I want.

Hope that helps.

Aaron

[kyle242gt]

Tweekers: does MST use the MSnS-E WB target AFR as the crossover point for generating VEs?

I assumed it did not, IE, it plotted at 14.7 (that's what is set as crossover point in MST's setup).

Funny thing, the proposed MST VE is about what I've got now at 16:1. But when I scale that to 16:1 in MST, it's too lean.

I asked this in the MST forum, but it's a graveyard.

[ovlov760]

You know how you can copy the formula cell and paste into the next cell, and it updates so that it's using the data from that line? Well, if you click into the next cell, and then scroll to the last row, and then holding shift, click that cell, it will select all the cells in between. Then paste. It should paste the formula, but update it to use the correct data from each row. Then that entire column will have that formula in it.

My next problem is that I wanted to be able to paste that info into another spreadsheet (Poi's tuning sheet). But you want to paste the data, not the formulas. Well, select that whole column again in the same manner, and paste "special" it into the next column. One of the "paste special" options is to paste the values instead of the formulas. That gets me in the raw data that I want.

Hope that helps.

Aaron
Thanks for the tips. I still can't get it to apply the formula to more than one cell. Maybe i'm entering it wrong? I try telling it to do =F2:F??*2+9 but it comes back with a 0 or something about a circular calculation

[Two 87s]

Thanks for the tips. I still can't get it to apply the formula to more than one cell. Maybe i'm entering it wrong? I try telling it to do =F2:F??*2+9 but it comes back with a 0 or something about a circular calculation

Start with the first row you want to do this to. Let's assume A1 is the cell with the voltage value in it, and you want the AFR in cell A2. In cell A2, your formula should be =(A1*2)+9. Try that. It should give the correct AFR. (That is, if I got the formula correct from looking above.) Now, you also have a voltage in B1. To copy the formula, select cell A2, and hit Ctrl-C. Now select cell B2 and hit Ctrl-V. Your formula will be pasted, but Excel should automatically update it so that it uses B1 instead of A1 in the formula.

If that works correctly, then all you have to do is try copying to larger sets of cells. Say that you have the voltage in C1 through F1 as well. Go to A2 or B2 (either one is fine) and hit Ctrl-C. Now, go to C2. Hit shift and scroll down until you've selected all the cells from C2 to F2. Now hit Ctrl-V to paste. It should paste the formula into each cell and update which cell it uses in the formula.

If that works, you can easily paste the same formula into an entire column. First select and copy your formila. Then, I suggest starting at the very bottom cell that you want. Click it in and then scroll all the way up to the top. Hold shift and click in the first cell you want to paste into. Now copy. It should do them all correctly.

Then, like I said, if you want to have the plain values, select the entire column and "paste special" it into a new column. Under paste special, use "paste values" and it will paste just the end result of the formula (what is displayed) instead of pasting the formula. Now you can copy that column to another spreadsheet (like Poi's tuning sheet).

Did I make it clearer that time, or am I not understanding what you want to do?

Aaron

[Boris740]

Thanks John, appreciate the insight. The spacebar is handy to know as well.

New updated MST3K is also on my agenda.

You can now also log knock thanks to my agenda ;-)