The main difference between rows and columns are discussed in this article. Row is an order in which people, objects or figures are placed alongside or in a straight line. A vertical division of facts, figures or any other details based on category, is called column. Jul 29, 2017 - After entering data, one of the most common mistakes is realizing you transposed columns and rows.
Refer to Rows and Columns. 3 minutes to read.In this articleUse the Rows property or the Columns property to work with entire rows or columns. These properties return a Range object that represents a range of cells.
In the following example, Rows(1) returns row one on Sheet1. The Bold property of the Font object for the range is then set to True.
Sub RowBoldWorksheets('Sheet1').Rows(1).Font.Bold = TrueEnd SubThe following table illustrates some row and column references using the Rows and Columns properties. ReferenceMeaningRows(1)Row oneRowsAll the rows on the worksheetColumns(1)Column oneColumns('A')Column oneColumnsAll the columns on the worksheetTo work with several rows or columns at the same time, create an object variable and use the Union method, combining multiple calls to the Rows or Columns property. The following example changes the format of rows one, three, and five on worksheet one in the active workbook to bold.
Sub SeveralRowsWorksheets('Sheet1').ActivateDim myUnion As RangeSet myUnion = Union(Rows(1), Rows(3), Rows(5))myUnion.Font.Bold = TrueEnd SubSample code provided by: Dennis Wallentin,This example deletes the empty rows from a selected range.
Just realized i never made an a9l2 sticky!!!The A9L calibration as well as all the stock foxbody calibrations are not optimal by any means. Henry's engineer's working on the foxbody calibrations obviously did not fully understand the functioning of the ECU's, this is evident by the 'band-aiding' they did to the fuel table and WOT multiplier to get fuel where they wanted it. The stock calibrations require extensive changes in order to sucessfully calibrate a vehicle even in bone stock form. The A9L2 base calibration, is a theoretical stock calibration for the foxbody ecu's created by decipha.
This base calibration is adjusted for highly modified naturally aspirated and boosted engines including: turbocharged, supercharged, and nitrous, as well as bone stock factory engines. This base calibration can be used on ALL 1989-1993 foxbody mustang ECU's. However, for Tweecer users you cannot change strategies.
If you have a tweecer and wish to use this calibration verify your ecu is a GUFB strategy ecu.A9L2 write up is on the homepageTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. Not really, just need to adjust the throttle body set screw correctly to get IPSIBR below 0.05 at a warm stabilized idle and your doneTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. Decipha wrote:updated and posted the A9L2 base cal, now idle air correction isn't saved, this prevents many idle issues from ever being possible with cold enrichment, this is identical to the 'mechanical' idle control but still allows the ecu to stabilize idle, best of both worldsJust to clarify, all of the red text in Idle Air 101 can be ignored because of this, right? General Poster Posts: 39 Joined: Sat Apr 12, 2014 4:39 pm Vehicle Information: 1992 Ford Mustang GTA9L/GUFBBE/EAQuarterhorse347 Stroker10.5:1 CRXE274HR CamEdelbrock Victor Jr headsEdelbrock Victor EFI 5.0 IntakeBosch 36LBGranatelli BA2400 MAF Vehicle 2 Information: 1998 Chevrolet K3500 SilveradoHeath Max E Tork PCM6.5L Diesel21.5:1 CRJardine 4' exhaustMarine Hi-Pop injectorsGM-8 Turbo with manual wastegate control set to 15psi.
Michael - just wanted to see if these updates were made to your idle air 101 write-up. Trying to ramp up on this area and it is making sense, but curious about how it would change. Thanks for the time to keep us newbies in the learning process.Rob Premium Member Posts: 63 Joined: Thu Apr 24, 2014 3:46 pm Location: Colleyville, TX Name: Rob Vehicle Information: 66 Mustang331, AFR 185's, FTI Cam, tmoss ported GT40 Intake, Explorer TB, GUFB, Moates QH, NGK AFX WB, 4R70W Tranny with USShift (Baumann) controller- Vehicle 2 Information: 74 Bronco5.0L stock motor, Explorer GT40 Intake and TB, GUFB, Moates QH, NGK AFX WB. I see now your using tunerpro, dont think dex added it to that defmaybe one day when i finally get around to it ill add it inTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. You can use it no probjust tune it as u would otherwiseTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer.
Cool, be sure to post back i'd like to know and im sure others would as well, transition should be smoothTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. I got the A9L2 tune loaded. I made zero changes to it, just ran it, and well unfortunately it doesn't run so great. Idle is all over the place, and part throttle is whacky too. Didn't even go near WOT before I brought it back in.The car is basically a 'stock' fox, just the explorer heads/intake, still has 19lb injectors, and has a C&L 73mm, but with the 19lb 'calibrated' flow tube. Runs fine with the stock tune.
Not really sure where to start here. After reading all through the 101s several times, I can't really see what else should be done other than setting the idle. General Poster Posts: 9 Joined: Sun Jun 15, 2014 2:20 pm Name: David Vehicle Information: 1989 Ford Mustang White Notch SSP5.0LT5GT40p headsExplorer intakeCrane 1.7rrC&L 73mmStock HO CamStock 3.08sStock 19lbersStock fuel pumpStreet Tires13.8@102.
You got me curious nowcan u start your own garage thread and post a datalogExplain in that thread what it was doing at idle and part throttleTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. I was comparing the old A9L2 cal with the updated one and the only change concerning the type of gas being used is the e10 being selected in the ZAFR slot. I thought there were other changes that needed to be made to use e10.Would you list the parameters that need to be modified when going to e10 from gasoline? Also I want to go to the new A9L2 and interested to know what will it take to make the switch?
Will I have to manually go in and update every field to the tuning that I have already done or do I start tuning all over again?S.Paul General Poster Posts: 96 Joined: Thu Oct 03, 2013 10:00 pm Location: Baton Rouge, La. Name: Sylvester Paul Vehicle Information: 89' mustang, 351w, A9L2, BE, Quarterhorse, Z303 cam, GT40-X305 heads, 70mmMAF 30# inj. Accufab 75mm TB, Professional Products RPM styled EFI intake,BBK Fenderwell CAI, 9:1 comp.ratio, Ford 3:55, 5-speedMac 1.75' Swap 3' Prochamber 2.5' flowmasters. Hey Decipha,First, thanks for all of the very valuable information you have on this site.Is it possible for you to list all of the 'hacks' that are built into the A9L2 base tune? For example the ACT/ECT timing retard, etc.Also, you have referenced in several posts that maybe there are changes to some tables and scalers that are not acceptable with the existing open GUFB def file. Is it possible to elaborate more on this?Thanks in advance,TimXR4X4Ti General Poster Posts: 24 Joined: Sun Oct 13, 2013 9:43 pm Vehicle Information: Turbo 327, A9L. Thanks once again for your quick response.The reason I asked the question, is that last fall I tried an experiment after I swapped to a blow through slot MAF.
What I did was take my existing tune and do a 'compare' with the A9L2 tune in BE and changed everything in the A9L2 tune that was vehicle specific, like MAF transfer, injector size, idle air, etc. This didn't work at all and the car would barely run. I then took my 2 year old tune and put in the new MAF curve and it fired up and I drove it around. I thought I was pretty good at this stuff and I went through every variable that was different between the two tunes and I couldn't remotely find one that should cause it to go from running great to almost not running. I had already done most of you suggestions to the old tune so there really wasn't that much different and that is what didn't make any sense.Thoughts?TimXR4X4Ti General Poster Posts: 24 Joined: Sun Oct 13, 2013 9:43 pm Vehicle Information: Turbo 327, A9L.
I down loaded the A9L2 last fall and I'm just now getting all my mechanical changes done to the car. So now I am back to looking over the A9L2 and reading some of your write ups.
In the timing write up for GUFB it states 'NEVER allow the ACT spark function to add timing only retard timing.' So I checked the ECT table.
The Values showing are positive numbers. 90=1, 96=2, 130=3, 190=4, etc. The ACT table which is actually ECT does have negative numbers in it.
So I am a bit confused with the ECT table (A9L2 is actually for the ACT). As my air charge temp increases is this table going to add or subtract timing with positive numbers in it?Also are the numbers in the table realistic for temp reading in the MAF meter (in the pipe)?
General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr. Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. Theres only one table and in the A9L2 tune its ACTif ACT is in the inlet pipe just copy the 190 column to 130 and all is wellTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. Bear with me I'm new at this. I think I miss-used the term 'table' when I should have used 'Function.'
In the A9L2 these two functions have been switched.PT Spark Adder for ACT FN126PT Spark Scaler for ECT FN1133PT Spark Adder for ACT FN126: -256 0 -256 0 224 0 234 -4 254 -8 PT Spark Scaler for ECT FN1133: -65536 0 86 0 90 1 96 2 130 3 190 4 210 5 254 6 65534 6 So FN1133 has positive numbers in it. Is this going to reduce timing as the air temp increases? General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr. Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. Thats not FN1133, that's just the scaling function for FN1133, FN1133 is a tablego check out the table FN1133 and it will all make senseTooner Posts: 17330 Joined: Mon Jul 15, 2013 5:29 pm Location: New Orleans, LA Name: Michael Ponthieux Vehicle Information: Supercoupin' x1090 (4x 5spds) - Dante, Ruby, Daja, Ava91 4r70w - Skarlett92 (2x) 5spd & auto - Bianqa, Andrea93 auto - Danika94 5spd Rionda95 auto Aisha Vehicle 2 Information: Others:00 Lincoln LS - Luanda98 Camaro SS - Bounquisha02 Harley F-150 - Sasasha03 Marauder - DyShyKy00 Explorer 5L - Bernyce07 GMC 2500HD 6L - Veranafer. Yes that makes much more sense now.
Still a little confused on the move the 190 column to the 130, as in FN1133 table both columns are full of zeros. At first I thought you intended in FN1133 to copy paste each column one spot to the left, but re-reading I'm not sure. Are you meaning I should be changing the scaling function or changing the FN1133 table?While I'm asking questions.
Does the A9L2 pull timing out based on both engine temp and air temp, or just air temp? FN126 Pt spark Adder for ACT - is this being used to pull timing based on ECT or not? I thought it did, but a few things confused me.
General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr. Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. Thanks a lot for getting me straightened out.I left the 254 column the same as the 210. I doubt the air could get to 210 anyway.
I'm pretty sure that was what you intended. General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr. Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. In the A9L2 write up, it stated 'FN875N must be set to all 0.6'The table now has:row; des rpm; lb/min1; 0; 02; 0; 03; 0; 04; 0; 05; 800; 1.1486; 4080; 1.992I see the need to change row 4 and 5 (I assume row 2 and 3 wouldn't matter either way). I'm hesitate to change row 1 or 6 as often it is warned not to change the bottom or top rows (or are these warning only for the scaling). Do I change all rows?Also I was reading the mechanical idle section of the idle air write up. It list all the things to change to do this on your own.
I noticed not all of these are set in the A9L2 as listed in the write up. I assume that is because the A9L2 handles some of this differently than an A9L or other factory GUFB tune. I just wanted to verify that with you.Sorry to be such a pain, but I am very green at this. I am trying to learn and understand what I am doing, not just get. I expect understanding more is going to come in handy real soon.
Again thank you very much for everything you do for all of us. General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr. Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. I was going through the New A9L2 finding the stuff associated with the idle and making those changes to the Old A9L2 (from Sep 2014) that I have already modified for my engine. I noticed that there is more changes than just the idle air.
I tried using the compare tool, but it flags every memory location. Not sure why.Should I continue to use the older file or should I take a copy of the newer and start over putting in my modifications? General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr. Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. Now to get all the parts back on it and start tuning.A couple trips to the hospital for kidney stones (boulders) has de-railed my efforts. General Poster Posts: 14 Joined: Fri May 30, 2014 7:21 pm Name: Rick Gayheart Vehicle Information: Replica: 427 Shelby Cobra, EEC 4 A9L, TunerPro RT, QH, 5.0 347 stroker, 10.5:1 comp, cam: 236/242 @50 110 LSA, Edle performer rpm heads, 5sp manual, MassFlow EFI Edle vic jr.
Intake with efi bungs welded in - 1000 cfm throttle body looks like a carb - GM MAF inside air cleaner on top TB - 36 lb/hr injectors, headers and side pipes. Decipha,In the A9L2 tune, why do you have the Adaptive Control ACT Minimum (AFACT1) set to 258F. Did you purposely do this to keep the adaptive fuel table from updating? If so, what's the benefit?Thanks,Rich General Poster Posts: 83 Joined: Sun Dec 06, 2015 8:16 am Name: Rich Vehicle Information: 65 Mustang Vert, A9L, Moates QH, Innovate LM-2 WB302 w/ TF heads, F-cam, ported GT-40 lower/tubular upper, Vortech T-trim s/c, 60 lb/hr inj, Methanol injection, PMAS HPX blow-thru MAF, 400 lph pump. Vehicle 2 Information: 92 Mustang GT, A9L, Moates QH, Innovate LM-2 WB302 w/ TF heads, B-cam, ported GT-40 lower/tubular upper, Powerdyne BD-11 s/c, 42 lb/hr inj, 75 mm Pro-M MAF, 255 lph pump. Vehicle 3 Information: 95 Lightning, ICY1, Moates QH, Innovate LC-1 WB393 w/ TF heads, custom cam, GT-40 lower/tubular upper, 30 lb/hr inj, speed density. Additional Vehicles: 62 Mercury Comet, LLX4, Moates QH32V 4.6L, IMRC delete, stock rebuild.
Decipha wrote:its not, its set to -254 to null the clip, the memory location is a signed byte so it is impossible to have a value of 258, your definition file is showing the value incorrectlywelcome to the forumHey, i see this too. Been using the Crey8's Rev 94 def forever and that's how it shows it, 258. It also comes up withZWSPKSW Spark - WOT Mode Spark Control Enable/Disable is enabled.
Think the that slightly older def is doing that?Yet an older version of your A9L2 shows 20 degrees and control disabled. Advanced Tuner Posts: 239 Joined: Thu Oct 17, 2013 7:23 pm Name: Hank Vehicle Information: 85 Mustang GT. 5.0, QH, A9L Vehicle 2 Information: 91 Caprice 5.0 TunerPro RT Vehicle 3 Information: 95 Caprice 4.3 TunerPro RT.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |