****Please note that this spreadsheet was designed and tested for the 2006-2011 Honda Civic Si ONLY!!!! It may not work for other accessport vehicles.****
Don't understand all that MAF Calibration math in your ATR handbook? No problem, this speadsheet will do it all for you!
This is our latest speadsheet verison:
Excel ProA Spreadsheet **NEW** & *UPDATED* to v1.3 (Tested with Excel 2003, 2007, and 2010)
Updates in the New ProA Spreadsheet:
- Improved forecasting accuracy for values not found in the datalogs.
- Improved design and logic for more smooth MAF Calibrations.
- More efficient code for faster calculations.
- Ability to delete bogus data and recalculate your calibration
- Go to the Data sheet, find the bogus data values and delete the entire row of data
- Go to the ProA spreadsheet and click the Recalculate sheet and click the recalculate button
- That's it your new recalculated output should pop up
Excel Spreadsheet (original) **UPDATED** (Tested with Excel 2003, 2007, and 2010)
Updates to the Original Excel Spreadsheet:
- Updated to allow the use of ATR Datalogs
PDF Demo (Requires Adobe Reader 9+)
-------------------------
How do I calibrate my MAF?
If your doing things right, you should be able to get your MAF Cal near perfect with 3 revisions. If you use too many revisions, (7+) then things will drift slowly further apart, and your better to start over then try to correct what went wrong.
This speadsheet can handle 5 datalogs. So lets take advantage of that. Lets treat it as a 3 step process. Start with the stock MAF Cal. After your vehicle is ready to go, monitor your MAF sensor with the AP.
Drive for no less then 20 mins through the city, keeping your MAF between 2-80 g/s. The more steady you are with your foot, the better your reliminary cal will be.The city will calibrate your MAF from 2-20 g/s typically. After 20 mins, try and find some highway. Cruise at 50 MPH for 1 min, then 55 MPH, then 60 and so on up to 80 MPH if possible. Ease into the throttle in 5th gear, to make the MAF read 70-80 g/s at least 10 times. Respect your local traffic laws. After 20 mins your ready to head back.
Run the spreadsheet and upload the datalog. Look at the graph for inconsistencies, PARTICUARLY above 40 g/s. If you see one, check the data analysis portion of the spread sheet to see how many times it averaged that value. Chances are it was only one or two. So instead don't use that value, take a guess with it should be, IE instead of -9% it might look like it should be -4% based on neighboring values. So multiply that stock MAF cal by .96 (- 4%) and paste that overtop value the new yellow value IN the corrosponding location. Keep in mind not ALL MAF values are implemented. In the higher G/S readings the MAF sensor skips and goes 55 to 65 to 85 etc.... so a dip at 57 has no impact, as its not implemented.
Use common sense and when your done, paste this new calibration into your first revsion map. I would recommend driving on this map for a day. Logging when you get a chance city and highway like above, try to get at least 3 30 min logs.
Rinse and repeat the next day for Rev 2. The more logs the better. Cruising at 30 MPH, 35 MPH all the way up, really helps the calibrations. If you take a few logs over several days, you will get more accurrate results then several smaller logs done quickly. The less revisions the better. By the 3rd revision consider monitoring STFT and not MAF, so you can get an idea at different MPH's what the calibration looks like.
Finally in your final revision make sure the MAF Cal curve itself, in ATR, looks like a curve, no straight or flat spots. If its outs double check your numbers. It COULD just be your intake, but its not a very good intake if thats the case. The more exponential the graph looks the closer to the way airflow really affects the MAF.
Good luck and happy tuning!
The AccessTuners Team

Comments
I just realised if you decide
I just realised if you decide to edit any of the data in the generated spreadsheet, everything updates, except for the New MAF Cal. These cells are a fixed value rather than a formula.
(Probably a bad idea, but I was playing around trying to smooth out my graph a little across the values where I only had a few readings)
Yeah, there's another
Yeah, there's another spreadsheet that I have comin out soon that will smooth the line out a little automatically. The calculations are built into the code. They aren't actual cell formulas so they won't show up as the new values.
Ooh, sounds good. Any chance
Ooh, sounds good.
Any chance you could also make it so that the cells contain the formula, instead of calculating the value in the macro?
It can't show the formula for
It can't show the formula for those, because they are done in VBA not through a formula.
Thanks, Dan! Checking these
Thanks, Dan! Checking these out now.
I cannot download any of the
I cannot download any of the spreadsheets from the whole site.
i dont have the full version of microsoft office yet, just the temp. do i need the full version?
if not is there a program or link i can download to be able to open these files?
thanks, chris
^ Do you mean you can't
^ Do you mean you can't download the files from the site, or once you have downloaded them, you can't open them?
To download them try right-clicking on the link and selecting "save as..." or "save link as..."
If you have a version of excel in your office installation, then you should be able to use that to open them. Otherwise, you will need to figure out a way to get excel, I don't think you can use open office (which is free).
^ Yeah that. And No these
^ Yeah that. And No these Macro's won't work in OpenOffice.org only Microsoft Excel (possibly the trial also)
Great thanks ive got office
Great thanks ive got office at my sisters
can someone do this for me =D
can someone do this for me =D
common it's not that hard,
common it's not that hard, I took all the work out of it for you with the SS! It used to be a pita
why can't we cut and paste
why can't we cut and paste the maf cal cobb used in their tune for each intake. my ltft hover around 0 on their tune.the tune is calibrated for each intake.
You can certainly start
You can certainly start there.
Is there any other way I can
Is there any other way I can aquire this information? My excel will not load this.
Got it to work now but it won't load my datalogs. Do I need to rename them or something?
I've had this problem as
I've had this problem as well. For some reason excel thinks the datalogs are text files and not comma delimited. What you'll want to do is download the datalogs off your AP, then click Save As. Then at the bottom of the pop-up box where it says text, you'll want to click there and select comma delimited (.csv). At this point you can use the datalogs in the excel ss that I made. Don't know why excel does that?? It's some kind of glitch I have yet to figure out.
The worksheet is not working
The worksheet is not working for me. I get "Run-time error '91': Object varioable or With block variable not set"
I'm guessing either, my logs don't look like yours (in my Mazda), or the number of MAF values/cels is different. Any insight? I wouldn't mind tweaking the macro, but it's password protected.
I fixed the spreadsheet for
I fixed the spreadsheet for the error that I could find. If you want to send me a datalog I could take a look if this doesn't work... I could also alter this for the MAF sensor that is in your car, but I would need your MAF voltage row from ATR.
Trying to cal my MAF so
Trying to cal my MAF so I have a basepoint for when I install the cams, but it says the new updated spreadsheet is password protected. I am trying to use Microsoft Works Spreadsheet, does this make a difference?
Let me know boys,
Thanks,
Vantage.
Don't think it will work with
Don't think it will work with works. I ended up just downloading a free office 2007 trial version and that did the trick. Its good for 60 days. Just google it.
Any way I can upload a
Any way I can upload a datalog here without crashing the site?
Trying to run the spreadsheet
Trying to run the spreadsheet ,but when i try to uplaod datalog it puts it in a seperate table. then if I try to move some data it says its password protected? using office 2010
What do you mean you can't
What do you mean you can't download any spreadsheets? It works fine for me. Thanks for the link to the classes but I'm a professional VBA programmer and could probably school the teachers. Please do not post any more advertisements.
I'm getting the same error as
I'm getting the same error as soybean... "Run time error 91" I do have a mazda just like him. I was wondering if you can help me calibrate my MAF Dan? Is there something special i need to do with the spreadsheet? I'm running stage 1, for my rx8, and i have few modifications like headers/high flow cat/intake and i know the stock cobb doesn't have much maps. Please let help me out