Subaru Forester Owners Forum banner
  • The "Garage" feature is for images of YOUR VEHICLE/S only - no blanks or other unrelated images please, thanks

Airboy Spreadsheet Help - 1st Time User

9.9K views 19 replies 5 participants last post by  thefoos  
#1 · (Edited)
Unable to plot dyno on Airboy's spreadsheet on my first attempt to use this great tool.

I am using the latest version: ver4p0z1

I guess my time scale units are wrong, how do I convert them to milliseconds?

Attached is the csv file.

Steps I followed:

1. import csv
2. filter WOT
3. grab headers
4. input data
5. wheel dia calc
6. calc acceleration

Am I missing something?
 

Attachments

#3 ·
Ya, the time data isn't right. That type of time stamp doesn't look familiar to me. You want to have the stamp in milliseconds.

Really, if all you want in a "dyno" plot, just log engine rpm and tp so you know where to trim the data set. This will give you the best resolution and the most accurate curve.
 
Save
#11 ·
yes, sorry, short hand. throttle position...

BTW, I just realized you are in Detroit. If you are in need of tuning help, let me know. I'm over in the Ann Arbor area fairly frequently visiting family...
 
Save
#15 ·
Yes DAM and IAM are the same thing. No need to log it really, download learning view to get your IAM/fuel trims/ and learned knock.

For those of you guys using airboy, since there is no FXT option, what number are you using for the rpm to speed converter, and what vehicle are you choosing as a supplement?
 
Save
#16 ·
I don't have the sheet infront of me, but if I remember right, I just modified the table on the 02-05 WRX. Same tranny ratios, 4.444 fd, different tire. Seems like frontal area is a bit more (22 > 24 sq ft perhaps) and so is Cd (.32 > .36). This is all from memory, so hopefully its right...
 
Save
#17 ·
Ok let's agree on some numbers to compare apples with apples:

This applies for Dyno Graph Calculation for Forester SG:

Curve Weight: 3320 lbs (from cars101.com)
Full Tank: 105 lbs (15 gal x 7 lb/gal)
Base Weight: 3215 lbs (Curve Weight - Full Tank)
Delta Weight: Driver's weight + Gas' Weight (full tank = 105lbs, half tank = 52.5 lbs, 1/4 tank = 26 lbs)
Frontal Area: 24ft^2 (estimation per "thefoos")
Cd: 0.36 (estimation per "thefoos")
Tranny Ratios: Choose 02-05 WRX
Tire: Input your tire size

Bold faced numbers denotes Airboy's entry
 
#19 ·
You need to change the Final Drive ratio as well as the Wheel diameter entries (scroll to the right on the page). Just pick one of the existing entries and rename it and fill in the gearing and tire info. Go back to the vehicle model selector and it should show up in the list.
 
#18 · (Edited)
^With above assumptions and below boundary conditions this is my curve on average of 2 runs (does anybody know how to average 4 runs?)

Mods: Cobb Stage 2 OTS, AVO High-Flow Filter, Stock wheels on winter rubber (215/55/17), 3" Catted MadDad TBE.

Environmental Conditions: temperature 40F, humidity 90%, elevation 961 ft.

HP 246 @ 6000
TQ 276 @ 3850


Unfortunately Airboy's spreadsheet does not correlate well with a Mustang Dyno Run (same mods no protune).

Image


Image
 
You have insufficient privileges to reply here.