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

Help, converting files, .hpl to .csv

Thread Tools
 
Search this Thread
 
Old 08-12-2007, 02:24 PM
  #1  
TECH Senior Member
Thread Starter
iTrader: (2)
 
Robert56's Avatar
 
Join Date: Aug 2003
Location: Tacoma, WA
Posts: 9,557
Likes: 0
Received 1 Like on 1 Post

Default Help, converting files, .hpl to .csv

Can't figure this out, must be brain dead. I have some converted, but can't get my current logs to open in excel. Need to convert HP Tuner logs .hpl to MS Excell .csv. Man this is driving me crazy, maybe my comp is on the blink. Any insight would be great.

I am using MS 2000 OS, Excel 2000 and the lastest version of HP Tuner.
Robert
Old 08-12-2007, 02:50 PM
  #2  
Moderator
iTrader: (11)
 
jimmyblue's Avatar
 
Join Date: Mar 2002
Location: East Central Florida
Posts: 12,605
Likes: 0
Received 6 Likes on 6 Posts

Default

You just have to open the file as if you were going to view it
( Scan > Open Log File ) and then Scan > Export (pick a file
name, or let it use the base name from the .hpl, the export
will automatically append the .csv unless you mess with it.
Old 08-12-2007, 05:49 PM
  #3  
TECH Senior Member
Thread Starter
iTrader: (2)
 
Robert56's Avatar
 
Join Date: Aug 2003
Location: Tacoma, WA
Posts: 9,557
Likes: 0
Received 1 Like on 1 Post

Default

Thanks Jimmy.
Robert
Old 08-12-2007, 06:03 PM
  #4  
TECH Senior Member
Thread Starter
iTrader: (2)
 
Robert56's Avatar
 
Join Date: Aug 2003
Location: Tacoma, WA
Posts: 9,557
Likes: 0
Received 1 Like on 1 Post

Default

Jimmy is there a formula for converting Mass Airflow Lb/min to g/sec or gms/cly?
Thanks
Robert
Old 08-12-2007, 06:21 PM
  #5  
Moderator
iTrader: (11)
 
jimmyblue's Avatar
 
Join Date: Mar 2002
Location: East Central Florida
Posts: 12,605
Likes: 0
Received 6 Likes on 6 Posts

Default

g/sec = lb/min * (454 g/lb) * (min/60sec) = lb/min * 7.57

I think that's roughly right, normal WOT NA numbers ought
to fall about 300 g/sec or so.

g/cyl has to factor in the RPM:

lb/min * (454 g/lb) * (rev / 4 cyl) / RPM or
g/cyl = 454/4/RPM = lb/min*113.5/RPM I think is it.

I leave all the units in so I can check that dimensions are
cancelled leaving only the desired ones.

The VCM Scanner has a nice little units conversion tool in
Tools > Unit Conversion that does both of these (though
for Excel fiddling you would have to do the formulas yourself).
Old 08-12-2007, 07:31 PM
  #6  
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

or you can just set the units in the scanner to metric or imperial and when you export it's gonna export with the units you set
Old 08-12-2007, 09:42 PM
  #7  
TECH Senior Member
Thread Starter
iTrader: (2)
 
Robert56's Avatar
 
Join Date: Aug 2003
Location: Tacoma, WA
Posts: 9,557
Likes: 0
Received 1 Like on 1 Post

Default

Here's what I have so far.
(gm/sec*15) / rpm = gms/cly

So,
486.88 * 15 = 7303.2 / 4377 = 1.66 gm/cly, and at this spot I have my timing set for 18* on the spray

The minute I get past n/a max gm/sec, and it's micro quick, it goes to pulling timing I need/want for the dry hit, very simple. Works well. The minute the spray hits the MAF, instant timing pull. Not to mention instant spray nice safe a/f in micro seconds, no lean spike. Both will not effect your performance n/a tune, and my n/a tune is on the edge, on the new 408.
Robert



Quick Reply: Help, converting files, .hpl to .csv



All times are GMT -5. The time now is 07:23 AM.