I feel like such a complete dork but I am having problems figuring out how to effectively use Airboys spreadsheet.
I can import my log and filter the WOT data in the data tab but beyond that I just cannot seem to find any information on how to work this wonderful tool.
I have searched several of the relative forums but I am still stumped.
Can anyone provide me with a walk through to get to the next level?
I know there are descriptions on the "info" tab of the spreadsheet so thanks in advance for pointing me to those, but i am still lost.

there was something on www.iwsti.com in the how-to section a while back if i remember correctly. i would give you the exact link, but...im lazy sorry! :lol:

The info tab of the spreadsheet tells you what you need to log for each of the interpolation tabs to work.

Basically, log the parameters required for the specific interpolate tab. Then import the data, filter WOT, then go to the specific interpolate tab, grab data, select the correct parameters (if they are not already selected), paste in your ROM map/table (if required), and then click interpolate. That is pretty much it for each tab.

First you need to put all the maps from your rom into the spreadsheet......IE open your base timing in romraider then copy/paste into a the base timing sheet, then hit the move and align button and it will move it to the right spot for you. Then do the same for advance, fuel, boost, etc.

then to use the timing interpolate sheet simply do
- grab headers (this grabs the column headers from the imported csv file)
- select the data you want to "get".....if you want to look at the base timing select base timing, total select total, etc.
- once you checked all the boxes of the data you want to get, hit the "get data" button, this imports all the data you selected from the data tab into the interpolate tab.
- then hit the interpolate button, this will use the RPM and Load data to hilight the cells on the base timing tab and advance timing tab to show you which cells you swept through during that run.

Im starting with my first map mod trying to change AFRs since Im running a bit lean at the moment. Im on the "AFR Target" spreadsheet and Ive copied my map rom tables into the spreadsheet, positioned it properly with the "Align and Move Copied Table" and hit "Re-interpolate"

Do the double bordered cells indicate where things are okay and my AFR matches the map or is it the other way around?

subscribed

Im starting with my first map mod trying to change AFRs since Im running a bit lean at the moment. Im on the "AFR Target" spreadsheet and Ive copied my map rom tables into the spreadsheet, positioned it properly with the "Align and Move Copied Table" and hit "Re-interpolate"

Do the double bordered cells indicate where things are okay and my AFR matches the map or is it the other way around?

The highlighted (double bordered) cells indicate the cells that were used by the ECU during that particular run to calculate how much fuel to use (from rpm and airflow/engine load data).

Is there an easy way to copy a table from the spreadsheet back into Romraider once youve changed it?

Yes, you need to copy the entire table, including the [table3d] tag. copy it from excel, then choose edit paste in the romraider map of your choice.

Im having trouble graphing data. I select RPM on the x axis and say MRP on the y axis and all I get is a vertical line on the left side of the graph. It happens with anything I try to graph and with all logs. Anyone know what might be wrong or what Im doing wrong? Thanks

Im having trouble graphing data. I select RPM on the x axis and say MRP on the y axis and all I get is a vertical line on the left side of the graph. It happens with anything I try to graph and with all logs. Anyone know what might be wrong or what Im doing wrong? Thanks

the data series is bigger than the scale of the graph, right click the Y axis and format the axis in excel. give it your own min/max or set both to auto.

For graphing MRP, just use the Boost Interpolate tab, that's what it's for.

the data series is bigger than the scale of the graph, right click the Y axis and format the axis in excel. give it your own min/max or set both to auto.

For graphing MRP, just use the Boost Interpolate tab, that's what it's for.

Alrite I give that a try. Thanks

Im having trouble graphing data. I select RPM on the x axis and say MRP on the y axis and all I get is a vertical line on the left side of the graph. It happens with anything I try to graph and with all logs. Anyone know what might be wrong or what Im doing wrong? Thanks

Right click on the chart and select Chart Type. Set it to x-y scatter. Save the file and try again.

I have had one report where the spreadsheet didn't keep the chart type setting and it would not plot correctly.

It was fixed but didn't make it into the version being hosted at RomRaider. I'll fix it and upload another.

Cool it works now. I tried both suggestions at the same time so Im not sure which it was but it works now. Thanks

edit: it was the chart type because it happened again and I had to go back and change the chart type

Cool it works now. I tried both suggestions at the same time so Im not sure which it was but it works now. Thanks

edit: it was the chart type because it happened again and I had to go back and change the chart type

New version posted over at RomRaider. It should have that problem fixed.

Thanks, I noticed that you posted a new version. Hopefully it fixes the problem.

Nah still does it Airboy. But as you mentioned, you just right click and change the chart type to one of the X-Y scatter types (scatter with smooth lines and markers looks best imho).

One thing to add though, after you set the chart type to one of the X-Y scatter types, you need to click back on the "Data" tab and re-click "plot selected data" for it to replot and look correct.

It fixed the problem for me.

No matter what type of romraider csv file I put into the spreadsheet and try to calculate acceleration, I get an error which reads something on the order of "data set too small (?) need to decrease smoothing factor. I put the smoothing factor as small as it can go (3) and the error is still there. I have put log files in from 2nd to 3rd to 4th gear pulls and it still won't work. What's up? Has anyone else had this happen? :unamused:

No matter what type of romraider csv file I put into the spreadsheet and try to calculate acceleration, I get an error which reads something on the order of "data set too small (?) need to decrease smoothing factor. I put the smoothing factor as small as it can go (3) and the error is still there. I have put log files in from 2nd to 3rd to 4th gear pulls and it still won't work. What's up? Has anyone else had this happen? :unamused:

I am going to guess that your data logs have a whole bunch of parameters in them (>12) leading to very long sampling intervals. For better results/resolution, collect 3rd gear pulls (default gearing info is for 3rd gear mostly) with only RPM and throttle opening data.

I have tried third gear logs, but they do have 6-8 parameters logged, depending on whether I am logging FBKC's.

One other quick question airboy... How close are these dyno #'s to a real world dynojet?

Ok, that just sounded retarded now that I look at that question, so I thought I would clarify. How close are the dyno # to crank hp after the ave. SAE correction on a dynojet?

if you select the correct vehicle and enter the correct info (weight etc) then the hp calculated in the spreadsheet is pretty close to realworld dyno results.

For me, I found 4th gear logs provided more accurate results - I was 5-7whp off when comparing to these my dyno dynamics dyno results done the same day.

Hi,

I got it working last night. Thanks for your help... I took an old 3rd gear log from a dyno run on a dyno jet that was 295hp/343trque if you add 20% for drivetrain losses to the whp figures. In airboy's spreadsheet it turned out to be 299/343!!

I would say this works pretty well (If you consider a 20% drivetrain loss on dynojet whp figures accurate on standard SAE correction, anyways).

I compared my current 3rd gear log in airboy vs. AP2 road dyno software. I get:

So chp/ctrq estimates are:

Airboy: 345/415
AP2: 339/401

Whatcha guys think? I have not had this setup on an actual "real" dyno yet, but am just trying to get an idea of where I am.

The acceleration page calculates the power needed to propel the car at a certain speed/acceleration. In other words, WHP You can not use a data log collected during a run on a Dynojet or any other chassis dyno and run it through the spreadsheet since the car is not actually moving. You are accelerating drums/rollers with inertial or eddy brake loads applied.

Well, something must be very off then if my current numbers are supposed to be whp.

I should have prolly made it a little clearer in my previous post, I did a 4th gear log from 2000rpm-redline on a straight bit of road, loaded that data into Airboy's spreadsheet, selected the correct vehicle and made sure it was set for 4th gear (most are 3rd gear, so you may need to create a new option for 4th gear) ran the calculation and the reulst provided were within 5-7WHP of my dyno runs (on a dyno dynamics dyno) done later that day.