VVE Calculation Spreadsheet - Beta Version Ready, testing and suggestions are welcome

[LSxPoweredSorento]

Not sure if anyone has worked this one up yet but I made a calculation sheet for the VVE table. This will allow you to paste in your "LTFT + STFT" table data from VCM Scanner and your current VVE table from VCM Editor. Once you do that some mathematical black magic happens and you have your NEW calculated VVE table. Doing it outside of VCM Editor lets you fiddle around without the worry of accidentally trashing your tune.
Currently the spreadsheet applies the math to the WHOLE table but if there is interest i can add a buffer in that can ignore a specific user defined range of correction percent. Say for example you want it to not mess with values on the VVE table that are between "-2 & 2" I can add this feature and another page allowing you to input those values. I can also add a trimming option to allow you to add a specific % across the whole table... Say you wanted it to apply a -2% across the whole table range. I can add this in as well.
I am basically open to suggestions from you advanced tuners. I just whipped it up really quick for my own use but after talking with IARLLC he figured that everyone may like this... Especially if I can add features that people would love to have.

The file is in "ODS" format which is an OpenOffice "Calc" file. I use open office because its a completely FREE open source program that is as good or better then MS Office. I can export it in a different format if anyone would like. However you can obtain OpenOffice for free here (I am not paid or affiliated with OpenOffice just an FYI) = https://www.openoffice.org/

Here is a link to the VVE Correction Calculatior Spreadsheet on my Google Drive (Easy to follow instructions are on the sheet). There are 3 "pages" to the sheet; "VVE Original", "VVE % Correction", and "VVE NEW Table" that you will work with. Just do NOT mess with the other 2 pages. They are for the math calculations.

***Update Nov 1 2021***

I updated the link because the old one was behind "an old security certificate setting" or something from Google so it was making me approve everyone. If the new link doesn't work please let me know!!

https://drive.google.com/file/d/0B7a...NYokgjZVJCGi9Q

Let me know what you think!

[IARLLC]

Saying that this rocks is way too mild! Serious thanks man! HUGE time saver!

[LSxPoweredSorento]

Saying that this rocks is way too mild! Serious thanks man! HUGE time saver!

Thanks man... Again any suggestions would be great. I can work on implementing them.

[veee8]

What about the applications that will need different map and RPM axis?
Looks pretty cool though, and I will give it whirl.

[LSxPoweredSorento]

What about the applications that will need different map and RPM axis?
Looks pretty cool though, and I will give it whirl.

Well, technically because the math is irrelevent to to the rpm and kPa axis' i can just extend the regions in which the math is calculated and then the user could "copy with axis" and paste into the correct point and the axis will be ignored for the math but the values wont.

[sevinn]

I like it thanks!

[sixt9stang]

I have been using it and it seems to work for me. I still barely know what I am doing though. Thanks!

[SantafeNoob]

Thank you LSxPoweredSorento

I know this thread is a bit old, But hey so am I. I just tried it out, and it works beautifully.

I couldn't go the disable / WB method, just kept making her super lean.

[LSxPoweredSorento]

Thank you LSxPoweredSorento

I know this thread is a bit old, But hey so am I. I just tried it out, and it works beautifully.

I couldn't go the disable / WB method, just kept making her super lean.

Glad it worked out for you. I just got tired of fiddling with everything in the program so it was faster just to make the spreadsheet.
I'll have to update the shared link. Since it's so old that I had to give you permission to access it. Something about updated security stuff. I dunno... LoL

[pannetron]

I'd like to give it a try but the corrected link doesn't get me anywhere.

[LSxPoweredSorento]

I'd like to give it a try but the corrected link doesn't get me anywhere.

Ok, let me check it out and get it to work...

[LSxPoweredSorento]

Should be fixed now! I tested it myself a few times and it works. If it doesn't let YOU in let me know. I have it set as open sharing but you never know.

[pannetron]

Bingo, thank you!

[marksrig]

I cant seem to get my axis copied over. I'm 3 bar.

Edit: never mind, I just manually made it a 3 bar axis then I was able to copy/paste to the other tabs. The info seems to transfer fine.