PCM Diagnostics & Tuning HP Tuners | Holley | Diablo

New MAF Table Spreadsheet and RAF Table

Thread Tools
 
Search this Thread
 
Old May 5, 2005 | 03:56 AM
  #61  
dr.mike's Avatar
Staging Lane
 
Joined: Mar 2005
Posts: 78
Likes: 2
From: So Cal.
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
Reply
Old May 5, 2005 | 11:23 AM
  #62  
RedHardSupra's Avatar
TECH Fanatic
iTrader: (1)
 
Joined: Sep 2003
Posts: 1,904
Likes: 2
From: Laurel, MD
Default

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

http://redhardsupra.blogspot.com/200...olumetric.html
Reply
Old Jun 11, 2005 | 04:21 PM
  #63  
vette.se's Avatar
Teching In
 
Joined: Jun 2004
Posts: 39
Likes: 0
From: Stockholm/Sweden
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
Reply
Old Jun 11, 2005 | 06:49 PM
  #64  
02sierraz71_5.3's Avatar
TECH Junkie
iTrader: (2)
 
Joined: Oct 2004
Posts: 3,473
Likes: 0
From: Cornelius, NC
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..
Reply
Old Jun 11, 2005 | 09:54 PM
  #65  
Robert56's Avatar
TECH Senior Member
iTrader: (2)
 
Joined: Aug 2003
Posts: 9,557
Likes: 1
From: Tacoma, WA
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.
Reply
Old Jun 12, 2005 | 01:44 AM
  #66  
Dixit's Avatar
TECH Regular
iTrader: (1)
 
Joined: May 2005
Posts: 434
Likes: 0
From: Canton GA
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
Reply
Old Jun 12, 2005 | 11:26 AM
  #67  
Robert56's Avatar
TECH Senior Member
iTrader: (2)
 
Joined: Aug 2003
Posts: 9,557
Likes: 1
From: Tacoma, WA
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?
Reply
Old Jun 16, 2005 | 01:41 PM
  #68  
vette.se's Avatar
Teching In
 
Joined: Jun 2004
Posts: 39
Likes: 0
From: Stockholm/Sweden
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.

Reply
Old Jun 16, 2005 | 01:53 PM
  #69  
RedHardSupra's Avatar
TECH Fanatic
iTrader: (1)
 
Joined: Sep 2003
Posts: 1,904
Likes: 2
From: Laurel, MD
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 ?
Reply
Old Jun 16, 2005 | 03:38 PM
  #70  
Black02SS's Avatar
Thread Starter
TECH Junkie
iTrader: (36)
 
Joined: Oct 2002
Posts: 3,291
Likes: 1
From: Kokomo, IN
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.
Reply
Old Jun 16, 2005 | 04:16 PM
  #71  
RedHardSupra's Avatar
TECH Fanatic
iTrader: (1)
 
Joined: Sep 2003
Posts: 1,904
Likes: 2
From: Laurel, MD
Default

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

Reply
Old Jun 16, 2005 | 05:18 PM
  #72  
Black02SS's Avatar
Thread Starter
TECH Junkie
iTrader: (36)
 
Joined: Oct 2002
Posts: 3,291
Likes: 1
From: Kokomo, IN
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.
Reply
Old Aug 21, 2005 | 07:42 PM
  #73  
DaleMX's Avatar
TECH Junkie
iTrader: (4)
 
Joined: Jul 2002
Posts: 3,078
Likes: 0
From: Atlanta, Georgia!
Default

The Link doesn't work any more.
Reply
Old Aug 21, 2005 | 07:43 PM
  #74  
Black02SS's Avatar
Thread Starter
TECH Junkie
iTrader: (36)
 
Joined: Oct 2002
Posts: 3,291
Likes: 1
From: Kokomo, IN
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.
Reply
Old Aug 21, 2005 | 09:40 PM
  #75  
RedHardSupra's Avatar
TECH Fanatic
iTrader: (1)
 
Joined: Sep 2003
Posts: 1,904
Likes: 2
From: Laurel, MD
Default

there shell be no fear, cause I is here!

www.allmod.net/hpt/RAF_1_1.zip

enjoy, test, report
Reply
Old Aug 21, 2005 | 10:37 PM
  #76  
Black02SS's Avatar
Thread Starter
TECH Junkie
iTrader: (36)
 
Joined: Oct 2002
Posts: 3,291
Likes: 1
From: Kokomo, IN
Default

Reply




All times are GMT -5. The time now is 12:19 AM.