New MAF Table Spreadsheet and RAF Table
#22
TECH Fanatic
iTrader: (1)
my spreadsheet uses calibration point -62 and +63, so a sample bin would look like:
2063(lo) <---- 2125(calibration point) ----> 2188
Look in the code, unlike Chad, I don't lock my formulas
Other than that, good job on the RAF stuff! You really prettied it up too.
So i'd like a general opinion here:
Guys, should we make it into an app, or should we keep it as a spreadsheet?
I am pushing Excel to its limits as far as pure excel functionality goes (as in no VB). I refuse to do VB in Excel, because then you are a victim to the limits of both. Also, I haven't touched Basic since 8bit ATARI Basic
I'm thinking of a Perl app, but compiled into a standalone. This way we have the power of normal programming language, but ease of use of any other script. I don't want people to copy, paste, filter, etc because that's just error prone (people make mistakes, computers don't). I want to be able to feed a raw csv and get a calibration on the other end, with NO other interaction. I want to do things like composite/historical data, automatic data cleanup, and other more advanced stuff, which excel is just really not suited for.
Or should we have two separate things--the pretty Chad spreadsheet for quick'n'dirty stuff, and my more advanced standalone app? I talked with Chat extensively yesterday, and we are doing a lot of the same things, but we have very different approaches to it, so I'm not sure where we should take it. I personally don't care, I can use it all, but eventually it is for you, The Peoples of HPT, that will use it, without the need to dive into the nasty details.
Let me know, as I am stuck right now contemplating what to do, I can go any way you want me to, so hint me in the right direction. Let's hear it!
2063(lo) <---- 2125(calibration point) ----> 2188
Look in the code, unlike Chad, I don't lock my formulas
Other than that, good job on the RAF stuff! You really prettied it up too.
So i'd like a general opinion here:
Guys, should we make it into an app, or should we keep it as a spreadsheet?
I am pushing Excel to its limits as far as pure excel functionality goes (as in no VB). I refuse to do VB in Excel, because then you are a victim to the limits of both. Also, I haven't touched Basic since 8bit ATARI Basic
I'm thinking of a Perl app, but compiled into a standalone. This way we have the power of normal programming language, but ease of use of any other script. I don't want people to copy, paste, filter, etc because that's just error prone (people make mistakes, computers don't). I want to be able to feed a raw csv and get a calibration on the other end, with NO other interaction. I want to do things like composite/historical data, automatic data cleanup, and other more advanced stuff, which excel is just really not suited for.
Or should we have two separate things--the pretty Chad spreadsheet for quick'n'dirty stuff, and my more advanced standalone app? I talked with Chat extensively yesterday, and we are doing a lot of the same things, but we have very different approaches to it, so I'm not sure where we should take it. I personally don't care, I can use it all, but eventually it is for you, The Peoples of HPT, that will use it, without the need to dive into the nasty details.
Let me know, as I am stuck right now contemplating what to do, I can go any way you want me to, so hint me in the right direction. Let's hear it!
#23
I really don't care, either is fine with me. I have it locked so the formulas and such don't get altered. If anyone wants to see the code, just let me know and I'll PM or Email you the password.
I do appologize on the calibration aspect of your sheet, it is the same as mine then. Any ideas anyone has, let us know. We all are after the same goal here. What we are doing in these spreadsheets, other programs have built in. Maybe with 2.0 we can get rid of all these sheets.
I do appologize on the calibration aspect of your sheet, it is the same as mine then. Any ideas anyone has, let us know. We all are after the same goal here. What we are doing in these spreadsheets, other programs have built in. Maybe with 2.0 we can get rid of all these sheets.
#24
TECH Fanatic
iTrader: (1)
so i decided to try blogging :/ yea, i know, lame..but it actually might work well for this purpose, since it looks like there's 5 people that actually really look at this stuff intensly, and i hate to spread my thoughts between different boards. this is meant as 'thoughts and development quandries' sort of thing. the big results/releases i will post on boards as usual. check it out:
http://redhardsupra.blogspot.com/
i got some other writeups waiting to be finished, for right now it's just mostly experiment of how does this stuff work. oh yea, anyone can comment, so no need to register or any of that.
http://redhardsupra.blogspot.com/
i got some other writeups waiting to be finished, for right now it's just mostly experiment of how does this stuff work. oh yea, anyone can comment, so no need to register or any of that.
#32
TECH Resident
iTrader: (2)
Alright, I am the Novice Tuner that doesnt want to mess anything up.
What does RAF stand for? (dynamic airflow values??)
What does this spreadsheet use to calculate the new table? Does it search through my pasted log sheet that I upload and then use the STIT and LTIT (p/n and gear) values to calculate the new table??
All it asks me to do is input my current RAF(??) table values into the spreadsheet and click calculate new table. What does it use to calculate these new values and how does it know where to get them from?
How do the STIT and LTIT values come into play?
What does RAF stand for? (dynamic airflow values??)
What does this spreadsheet use to calculate the new table? Does it search through my pasted log sheet that I upload and then use the STIT and LTIT (p/n and gear) values to calculate the new table??
All it asks me to do is input my current RAF(??) table values into the spreadsheet and click calculate new table. What does it use to calculate these new values and how does it know where to get them from?
How do the STIT and LTIT values come into play?
#33
TECH Junkie
iTrader: (9)
Originally Posted by 99whitews6
Alright, I am the Novice Tuner that doesnt want to mess anything up.
What does RAF stand for? (dynamic airflow values??)
What does this spreadsheet use to calculate the new table? Does it search through my pasted log sheet that I upload and then use the STIT and LTIT (p/n and gear) values to calculate the new table??
All it asks me to do is input my current RAF(??) table values into the spreadsheet and click calculate new table. What does it use to calculate these new values and how does it know where to get them from?
How do the STIT and LTIT values come into play?
What does RAF stand for? (dynamic airflow values??)
What does this spreadsheet use to calculate the new table? Does it search through my pasted log sheet that I upload and then use the STIT and LTIT (p/n and gear) values to calculate the new table??
All it asks me to do is input my current RAF(??) table values into the spreadsheet and click calculate new table. What does it use to calculate these new values and how does it know where to get them from?
How do the STIT and LTIT values come into play?
Chad can elaborate on the code. It appears to average the LTIT+STIT values around each cell (so the 4800RPM cell might include values from 4770-4830), and create a new value based upon your current value.
I believe the first worksheet tells you which PID's to capture for all portions of the spreadsheet to work.
#35
Originally Posted by RedHardSupra
my spreadsheet uses calibration point -62 and +63, so a sample bin would look like:
2063(lo) <---- 2125(calibration point) ----> 2188
Look in the code, unlike Chad, I don't lock my formulas
Other than that, good job on the RAF stuff! You really prettied it up too.
So i'd like a general opinion here:
Guys, should we make it into an app, or should we keep it as a spreadsheet?
I am pushing Excel to its limits as far as pure excel functionality goes (as in no VB). I refuse to do VB in Excel, because then you are a victim to the limits of both. Also, I haven't touched Basic since 8bit ATARI Basic
I'm thinking of a Perl app, but compiled into a standalone. This way we have the power of normal programming language, but ease of use of any other script. I don't want people to copy, paste, filter, etc because that's just error prone (people make mistakes, computers don't). I want to be able to feed a raw csv and get a calibration on the other end, with NO other interaction. I want to do things like composite/historical data, automatic data cleanup, and other more advanced stuff, which excel is just really not suited for.
Or should we have two separate things--the pretty Chad spreadsheet for quick'n'dirty stuff, and my more advanced standalone app? I talked with Chat extensively yesterday, and we are doing a lot of the same things, but we have very different approaches to it, so I'm not sure where we should take it. I personally don't care, I can use it all, but eventually it is for you, The Peoples of HPT, that will use it, without the need to dive into the nasty details.
Let me know, as I am stuck right now contemplating what to do, I can go any way you want me to, so hint me in the right direction. Let's hear it!
2063(lo) <---- 2125(calibration point) ----> 2188
Look in the code, unlike Chad, I don't lock my formulas
Other than that, good job on the RAF stuff! You really prettied it up too.
So i'd like a general opinion here:
Guys, should we make it into an app, or should we keep it as a spreadsheet?
I am pushing Excel to its limits as far as pure excel functionality goes (as in no VB). I refuse to do VB in Excel, because then you are a victim to the limits of both. Also, I haven't touched Basic since 8bit ATARI Basic
I'm thinking of a Perl app, but compiled into a standalone. This way we have the power of normal programming language, but ease of use of any other script. I don't want people to copy, paste, filter, etc because that's just error prone (people make mistakes, computers don't). I want to be able to feed a raw csv and get a calibration on the other end, with NO other interaction. I want to do things like composite/historical data, automatic data cleanup, and other more advanced stuff, which excel is just really not suited for.
Or should we have two separate things--the pretty Chad spreadsheet for quick'n'dirty stuff, and my more advanced standalone app? I talked with Chat extensively yesterday, and we are doing a lot of the same things, but we have very different approaches to it, so I'm not sure where we should take it. I personally don't care, I can use it all, but eventually it is for you, The Peoples of HPT, that will use it, without the need to dive into the nasty details.
Let me know, as I am stuck right now contemplating what to do, I can go any way you want me to, so hint me in the right direction. Let's hear it!
...let me know if you want to work on this
#39
TECH Fanatic
Join Date: Mar 2003
Location: La Porte, TX
Posts: 1,839
Likes: 0
Received 0 Likes
on
0 Posts
I still stand by the belief that RAF portion only works if you set one condition at a time. ie park/nuet then drive. In order for this to work correctly you 1st need to let the ECT drop and log all the data in park/nuetral. Load the values into the RAF spreadsheet, and calculate the new values. Only copy the Park/Nuetral values back into your tune. Go inside and watch TV for four hours and let the car cool off again. After the ECt has dropped log the values again but this time in drive. Use the spreadsheet to calculate the values, and then copy the "in drive" values into your tune. Now load the new tune and you should be pretty damn close. The problem with changing both is simple. The spreadsheet is basically calculating your STIT, and LTIT's and coming up with new values. However your STIT's are not the same in park and drive. For example lets say that at 177 ECT in drive and my STIT is -.4 and my LTIT in Drive is -.1 This would give me a correction factor of -.5 for my in drive range. That calculates to a -3.79 g/sec correction to my RAF table in drive at 177*. OK great that should zero out my idle trims in drive...now for comparisions sake through that bitch in park, and watch what happens to the STIT's. They change!!! STIT's are not consistant in park and drive. What I'm getting at, is the spreadsheet is using one STIT value for correcting both the park and drive values. This can not be done. The spreadsheet can not determine weather your car is in park or drive. This will seriously scew your STIT data. Your STIT in Dive might be -.03 (damn near perfect), while your STIT at the same coolant temp might be .43 Sure you might get lucky on a less modded car and get it "close enough", but for us guys with big cammed cars "close enough" will not work. The only solution, and I have said this before, is to split the spread sheet up into two different sections. One for correcting the RAF in park (ie log values with low ECT, and fans off until the temp reaches 219* in PARK) and correct those values. Then make a serperate section for logging the same values in DRIVE. I have used the sheet in this way and it works damn near perfect. Black02SS please make this correction, it will make everyones life a whole lot easier. I am by no means an Excel expert, or I would change it myself and send you a copy to look over. Hopefully I explained it pretty good, I'm not real good at explaing things over the net. I wish I could show you an example.
#40
12 Second Club
iTrader: (2)
Join Date: Feb 2004
Location: Front Royal, VA
Posts: 1,011
Likes: 0
Received 0 Likes
on
0 Posts
Testing shows my new maf table is almost identical to the one BLACK02ss's excel sheet created for me. So the excel sheets WILL get you very close then if you are a perfectionist like me, you can tweak till you are happy.