Hey Guys,
First you need to download the included files. Start off with the first sheet and press each 3 buttons to get acquired with the program.
1. The next step is the off idle sheet. This is going to fill in a table in the tuning program that we will burn into a chip that goes into the motorola based coded computer. I want to only allow 128 in a certain column called INT in the datalog. We only want A datalog reading there to be 128.This is just a reading of all sensors on a truck. Im making a program to Maximize Power and Fuel economy with performahNea
a. Near Idle only has values that are less than 2% TPS
b. Off Idle is anything More Than 2%.
2. After that I want to Sort The MAP KPA to round to the following list:
20
25
30
35
40
50
60
70
80
90
100
3. After that round the RPM's to a list of the following:
400
800
1200
1600
2000
2400
2800
3200
3600
4000
4400
4800
5200
5600
6000
6400
Note: for steps 1 2 and 3 i just want those rows of data cleared and cells of column deleted.
4. Now for the tricky part.
X/128*Y= New Value
X= Current BLM in datalog
Y= Current VE Value at that MAP and RPM in datalog and in Populated charts
The only problem I see here is populating unpopulated areas with a smoothing function using numbers on each side of them and averaging for a complete table to paste into the tuning program
Also attached i have a how to. Scroll down to page 6 and read that little blurb. Itll help you out more.
I really appreciate any contribution to the project. Even if you do a little area i can integrate.
ALSO I want all sheets to have one button that finishes off at the next step (spreadsheeet in book). first 2 steps are first steps, and 3,4 and 5,6 work along side eachother off starting data.
- Brandon
EDIT: Please email me for the macro excel file. [email protected]. It is saying
file upload failed right nowr.
We may best off using this for a round numbers macro http://excel.bigresource.com/Track/excel-bQaNOgRp/
Bookmarks