PCM Diagnostics & Tuning HP Tuners | Holley | Diablo
Sponsored by:
Sponsored by:

New MAF Table Spreadsheet and RAF Table

Thread Tools
 
Search this Thread
 
Old 05-05-2005, 03:56 AM
  #61  
Staging Lane
 
dr.mike's Avatar
 
Join Date: Mar 2005
Location: So Cal.
Posts: 78
Likes: 0
Received 2 Likes on 2 Posts

Default

Originally Posted by RedHardSupra
oh wow this is cool! why didn't i think of this? i have a spreadsheet that is one step away from this! alright, i'm off to update it with this formula of yours
almost forgot.

AirFlowg/s = AirFlowlbs/hr x 0.126
Old 05-05-2005, 11:23 AM
  #62  
TECH Fanatic
iTrader: (1)
 
RedHardSupra's Avatar
 
Join Date: Sep 2003
Location: Laurel, MD
Posts: 1,904
Likes: 0
Received 1 Like on 1 Post

Default

check it out, and let me know what you think:

http://redhardsupra.blogspot.com/200...olumetric.html
Old 06-11-2005, 04:21 PM
  #63  
Teching In
 
vette.se's Avatar
 
Join Date: Jun 2004
Location: Stockholm/Sweden
Posts: 39
Likes: 0
Received 0 Likes on 0 Posts
Default

Ok, what am I missing here ??

I've tried the spreadsheet on two different computers, one with Office 2000 and one with Office 2003 - same result on both.

I paste the RAF table in 'Idle tables 98-00', I paste the gathered data in the 'Data' sheet (exactly the Pids that are listed in the Readme sheet) and hit the 'Calculate RAF' button. It starts working showing the 'Data' sheet, after a while all cells starts to flicker and it hangs there for a long time and when I get a Run time error 91.

Any ideas ?

I'm only interested in the RAF part because I have no MAF (Running in SD all the time).

Thanks
Old 06-11-2005, 06:49 PM
  #64  
TECH Junkie
iTrader: (2)
 
02sierraz71_5.3's Avatar
 
Join Date: Oct 2004
Location: Cornelius, NC
Posts: 3,473
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by vette.se
Ok, what am I missing here ??

I've tried the spreadsheet on two different computers, one with Office 2000 and one with Office 2003 - same result on both.

I paste the RAF table in 'Idle tables 98-00', I paste the gathered data in the 'Data' sheet (exactly the Pids that are listed in the Readme sheet) and hit the 'Calculate RAF' button. It starts working showing the 'Data' sheet, after a while all cells starts to flicker and it hangs there for a long time and when I get a Run time error 91.

Any ideas ?

I'm only interested in the RAF part because I have no MAF (Running in SD all the time).


Thanks
I get the same thing normally run time errors are a problem with math or something is looping dividing by 0 etc..
Old 06-11-2005, 09:54 PM
  #65  
TECH Senior Member
iTrader: (2)
 
Robert56's Avatar
 
Join Date: Aug 2003
Location: Tacoma, WA
Posts: 9,557
Likes: 0
Received 1 Like on 1 Post

Default

Yea, I got the run time error 91 also, couldn't figure it out. E-mailed one of the authors but no answer? I finally used soundengineer's spreed sheet with great results.
Old 06-12-2005, 01:44 AM
  #66  
TECH Regular
iTrader: (1)
 
Dixit's Avatar
 
Join Date: May 2005
Location: Canton GA
Posts: 434
Likes: 0
Received 0 Likes on 0 Posts

Default

I remember getting this error because I didnt log all the PIDs. I was only trying to calibrate the RAF table and only logged the STIT and LTIT pids, I didnt bother with the MAF Hz and others. Then I got the error.

Went back to a scan that I had all the PIDs and it worked fine. It looks like his programming is looking for all PIDs for some reason. So I just add them all that he needs when using his spreadsheet.

Dixit
Old 06-12-2005, 11:26 AM
  #67  
TECH Senior Member
iTrader: (2)
 
Robert56's Avatar
 
Join Date: Aug 2003
Location: Tacoma, WA
Posts: 9,557
Likes: 0
Received 1 Like on 1 Post

Default

As far as I know I had all the pids and the ones specified. Because when adding dynamic/cly had to drop one in order for this addition?
Old 06-16-2005, 01:41 PM
  #68  
Teching In
 
vette.se's Avatar
 
Join Date: Jun 2004
Location: Stockholm/Sweden
Posts: 39
Likes: 0
Received 0 Likes on 0 Posts
Default

Tried everything I can think of but can't get this to work.

Is there any alternative to calculate the RAF numbers. Someone else made a spreadsheet ?


Thanks.

Old 06-16-2005, 01:53 PM
  #69  
TECH Fanatic
iTrader: (1)
 
RedHardSupra's Avatar
 
Join Date: Sep 2003
Location: Laurel, MD
Posts: 1,904
Likes: 0
Received 1 Like on 1 Post

Default

hey, Chad, could you gimme a rundown on how it works, and i'll make it pure excel so it always works, not some VBA crap ?
Old 06-16-2005, 03:38 PM
  #70  
TECH Junkie
Thread Starter
iTrader: (36)
 
Black02SS's Avatar
 
Join Date: Oct 2002
Location: Kokomo, IN
Posts: 3,291
Likes: 0
Received 1 Like on 1 Post

Default

I will look again at it tonight at work. I will fix it but do not want it to be in straight excel. **** takes too long and won't auto find.
Old 06-16-2005, 04:16 PM
  #71  
TECH Fanatic
iTrader: (1)
 
RedHardSupra's Avatar
 
Join Date: Sep 2003
Location: Laurel, MD
Posts: 1,904
Likes: 0
Received 1 Like on 1 Post

Default

<darth vader voice> I find your lack of faith disturbing

Old 06-16-2005, 05:18 PM
  #72  
TECH Junkie
Thread Starter
iTrader: (36)
 
Black02SS's Avatar
 
Join Date: Oct 2002
Location: Kokomo, IN
Posts: 3,291
Likes: 0
Received 1 Like on 1 Post

Default

My sheet works just like yours does, except mine doesn't require the user to input the correct data into a certain column and wait for the output. Really not that big of a deal, if I get a chance to work on it I will. I have since sold my HPT and have no use for it to be honest as EFI Live does all of this for me already.
Old 08-21-2005, 07:42 PM
  #73  
TECH Junkie
iTrader: (4)
 
DaleMX's Avatar
 
Join Date: Jul 2002
Location: Atlanta, Georgia!
Posts: 3,078
Likes: 0
Received 0 Likes on 0 Posts
Default

The Link doesn't work any more.
Old 08-21-2005, 07:43 PM
  #74  
TECH Junkie
Thread Starter
iTrader: (36)
 
Black02SS's Avatar
 
Join Date: Oct 2002
Location: Kokomo, IN
Posts: 3,291
Likes: 0
Received 1 Like on 1 Post

Default

Sorry for the inconvience. I have since removed the link to the spreadsheet and no longer support it. I have changed from HPT to EFI Live and there is no need for me to have it any longer.
Old 08-21-2005, 09:40 PM
  #75  
TECH Fanatic
iTrader: (1)
 
RedHardSupra's Avatar
 
Join Date: Sep 2003
Location: Laurel, MD
Posts: 1,904
Likes: 0
Received 1 Like on 1 Post

Default

there shell be no fear, cause I is here!

www.allmod.net/hpt/RAF_1_1.zip

enjoy, test, report
Old 08-21-2005, 10:37 PM
  #76  
TECH Junkie
Thread Starter
iTrader: (36)
 
Black02SS's Avatar
 
Join Date: Oct 2002
Location: Kokomo, IN
Posts: 3,291
Likes: 0
Received 1 Like on 1 Post

Default




Quick Reply: New MAF Table Spreadsheet and RAF Table



All times are GMT -5. The time now is 02:26 AM.