Page 1 of 1

Cal between Program Types

Posted: Tue Feb 02, 2010 8:13 pm
by ToyHicko
I've been busy writing some excel formulas to try and convert tables for me is there a better way? For example plan to use $12P but as a starting point need to load all the values from the existing file e.g. $5D. I've started to write a function macro that scans one table to calculate the new value required. As it's been ages since I've coded in VBA (6 year) so little rusty so before I got to carried away just thought I'd ask if there was an easier way.

Also hoping to also get the code working in Open office to make it more accessible to others but have to learn the code.

Jason

Re: Cal between Program Types

Posted: Tue Feb 02, 2010 8:30 pm
by Holden202T
well theres really only a few tables that need to be adjusted due to changes in columns etc so i don't really think its worth much other than excel ?

just pick a bin file from someone else thats the closest to your setup and go from there ?

Re: Cal between Program Types

Posted: Tue Feb 02, 2010 9:41 pm
by antus
Yeah I agree with Holden 202. For your engine i'd take my base tune, import the VE, Spark, and AFR tables from your source and calculate and set the injrate and PPK. That should get you pretty close. Jayme's spread sheet can be used to increase the resolution of the VE table. Its really only averaging the cells either side of the new rows. I dont think you should need to break out to VBA.