I've been looking at the MS Access sheet posted above. I've got some learning to do.
dave w
Printable View
I've been looking at the MS Access sheet posted above. I've got some learning to do.
dave w
so do I, learning as I go.
here is the latest. I would have used it to process my logs from last night but my laptop died before I could save the log:mad1:, so all was lost. what I did was set up a few more linked tables to copy the vetables out of tunerpro and paste them into the linked files in the working directory. Access then will calculate what your new values should be based off the logfile. I haven't set it to average the old and new tables together yet, but you get the idea where I'm headed with this. next I will work on getting it to do the BLM's and maybe chart PE & AE. instructions are in the zip file enjoy.
just an update, I found a typo in one of the formulas in the above file. I havent had a chance to work on it much. I've been pretty busy lately trying to get my daughters jeep running before she gets her permit. I did some datalogging the other day and noticed that I was at almost 8ms pulse width and over 72% DC at 5200 rpm with ve in the low 90's the WB was showing 14.7 and PE was not active. is this an indication that i need more fuel pressure or bigger injectors? I don't think that lowering the injector constraint will solve this, or maybe I don't understand how it will.
Not sure about your other questions but seems PE should be active at that RPM? Does your PE ever work?
not right now. I have it set to 98% tps. I was running about 80% throttle trying to hit cells up higher in the table.
so do you think this will be fine once PE is enabled?
That's a pretty vague question?
But if you got your VE tables in order then yes enable PE, turn off PE delay time, set other PE factors the way you want like TPS %, PE AFR and PE engine RPM. Makes a big HP/Tourque differnce to have PE!
Ok since I haven't been able to work on my truck because of the weather I've done some more work on my access 2007 based VE calculator.
there is an Instructions.txt included in the zip file. I would like someone else to try it and see if there are any bugs in the calculations. I've added the ability for it to calculate ve off of BLM as well as from WBO2 readings. I threw some other odds and ends in it too.
dave did you get a chance to check this out?
I think I have firgure out how to get the Access spreadsheet to work. I have attached a .zip file that I've been working with. I pasted in a new tplog.csv file, but I renamed the original tplog.csv as tplog_01.csv. I'll need to verify the Access spreadsheet vs. the Excel spreadsheet to see if there is a difference between the "NEW" VE Tables. Basically, with WIN7 I had to make myself the administrator of every file in the vecals folder to get the Access Macro to work.
dave w
I run XP. I don't have anything with enough prossesor to run win7. with xp all I had to to do was add the folder in the access trust center.
Ok, Maybe better late than never to reply back to a post.
The data in the attached files are from an engine $OD currently being tuned. It's real world data! The EGR has been disabled, and as a result a good tune needs to be corrected. If there are any mistakes, well I guess we will learn.:yikes:
I have used the VECALCS and my Excel Macro on the same data log. The results / comparison can be found in the attached Access vs Excel spreadsheet .zip file. The results are very similar, but there are some difference. I think with the VECALCS doing the sorting and averaging, then using the attached E6~OD~OE~31 AFR VE Correction Table for TunerPro.xlsx spreadsheet would yeild a decent WBO2 tune. I think it would be a good idea to disable BLM update, because WBO2 data and BLM data with contradict with one another.
dave w