2 Bar OS VE Table Converter

[hjtrbo]

Hey all,

This sheet will take your existing co-efficient based GMVE table and convert it to the HP 2 Bar OS VE format. This will get you real close and not have to lose all your had GMVE tuning work when choosing to convert. A very good point to start from.

This sheet was created in MS Excel 365 so is the latest version. I do not know if it will work with old versions of Excel. The sheet is password protected, this is just so you don't wipe out any formulas so as not to break the sheet function. It supports an additional 6 rows and columns over default if you have increased the resolution of your GMVE table.

Please watch my very boring video of how to use it before using it for yourself.

https://www.youtube.com/watch?v=px6dg-iKIPM

Edits:
1. Increased column widths

[GHuggins]

Either I'm doing something wrong - which is more than possible - or this possibly doesn't work with every OS or something? I'm trying to plug in the coefficients according to your video and a lot of them are just turning into hash marks - for zero's - even though the cells aren't zero's - if that makes sense? It's not creating the new VVE table from the coefficients. I'm also noticing that every time I post the values in I have to fix the pasting so it goes into the cells correctly - maybe this is the whole problem?

Again, I'm probably doing something wrong, but did try it twice from the video. I'm attaching the tune that I'm trying to use for an experiment.

[hjtrbo]

If they aren't pasting in correctly its usually because Excel is not automatically pasting delimited. If that is the case, then use the text to columns tool. Don't worry about the hashes, that's just excel saying there isn't enough column width to display the value. I have made an edit to increase the column widths.

I used your files. Went good as gold.

[GHuggins]

Well, it's posting the coefficients in correctly now, but still won't populate the VVE table on the second page. I pasted in the VVE table from the tune and 2bar axis - the 2bar axis is the only one that still requires fixing the cell spacing.

It's probably just because I'm using an older version of excel. May have to use a different computer as this one won't update it.

[hjtrbo]

Might pay to pause the video in a few spots and go step by step. Have used it on a few files the last few days and it works a charm. It is excel though so you kinda have to have a little experience to recognise if something didn't go right and fix it. There is no error checking or anything like that so it relies on the inputs been correct.

[BigTuner]

I tried this and everything looks perfect but nothing generates in the final tables, I'm not great at excel but I don't see any formulas or macros, maybe something is lost in the upload? Anyone else get this working?

[hjtrbo]

I downloaded the sheet just now and tested it again on a fresh base test tune and converted it to 2 bar. Works fine on my PC.

Maybe watch the video again... If still having dramas post your spreadsheet and tune here and I'll take a look.

[GHuggins]

I'll see if I can post one up tonight, but really just thinking it's the older versions of excel that most of us are running - I never could get it to work - something isn't jiving with the older excel versions.

[eXo3901]

Xlookup is only compatible with 365 and 2019. That is the biggest issue. Iferror is only compatible back to 2007.

Everyone needs to get newer versions of excel or the formulas need to be reworked taking backwards compatibility into consideration.

[hjtrbo]

I won't be going back to make it work for older versions. Thanks eXo3901 for pointing out the version compatibility.

[yevgenievich]

Sorry for bringing this up, but was trying to use the excel sheet and came up with a question regarding kpa value labels. I was trying to change to have labels to go from 15 to 239 (increments of 7). But on the output table after 175, labels all will show 175. It seem to take 175 as maximum number to be calculated

[JayRolla]

Sorry for bringing this up, but was trying to use the excel sheet and came up with a question regarding kpa value labels. I was trying to change to have labels to go from 15 to 239 (increments of 7). But on the output table after 175, labels all will show 175. It seem to take 175 as maximum number to be calculated

I just want to 2bar OS today. Just inverted the table on hptuners and copy pasted my old vve table to the ve table and it was pretty much perfect.

[hjtrbo]

Transpose works good. Try that. But if wanting to change labels and increase map my sheet is the go. Can you post the 2 tunes you're using and your worksheet and I'll take a look for you. Unfortunately there is no prize money for finding bugs.

[yevgenievich]

Attached is the worksheet. I did not really need the transfer of data above 100kpa on this one, but the table it self needed to go to 220kpa. For now I just left it at the default transfer and focusing on ironing out NA portions before going to boost.

GMVE Converter to 2bar OS_Rev7.xlsx

[Cringer]

Guys you do not need to use the spreadsheet converter anymore.

Method 1 (the best)
In the 2 Bar OS, right click the table and select Invert Axis (this is available on VCM 5.x)
Define the RPM breakpoints in the 2 bar OS that you want
Copy those RPM breakpoints to the original tune with VVE table
Copy and paste from VVE to 2 Bar VE

Method 2 (OK)
Same as above, but if you are on VCM 4.x and don't have the invert axis option, just match your RPM break points as above, but copy and paste special into Excel or Google Sheets and select the TRANSPOSE option. This will invert the axis for you, then you can copy from Excel directly into the 2 Bar OS.