RaceMX-M3
03-13-2010, 09:56 PM
One of the guys from E46fanatics who's a much bigger nerd than me spent the last few weeks putting all of this together. This is based on real world on the track data and beats the hell out of any dyno results. :)
From SPDu4ea
First, a big thanks to Scott (Racemx-m3) and Chris (HPF Chris) for providing ample data for me to use to test and refine this spreadsheet. I couldn't have done it without them...
Part 1 was mostly proving that the theory would translate into practice, and I had a couple people ask for the spreadsheet so they could use on their own. Now that I'm confident in the various corrections, I have tried to make the spreadsheet as user friendly as possible. You can download it here: http://www.mediafire.com/file/nnhyjn22okk/PBOXdyno.ods (http://www.mediafire.com/file/nnhyjn22okk/PBOXdyno.ods)
If you don't recognize the ".ods" format, it is open office calc (available for free: http://www.openoffice.org/ (http://www.openoffice.org/) ). Many of you have excel, but some don't so this seemed to be the easiest way.
When you open it up, it should look like this (sorry in advance if screen shots are too big for some monitors):
http://img188.imageshack.us/img188/419/ss1bq.jpg (http://img188.imageshack.us/i/ss1bq.jpg/)
You will only need to enter data into the red boxes (green box is optional if you want to graph rpm instead of speed). Don't touch anything else unless you know what you're doing...
Now open up the Vbox software and load your run. I'm using the driftbox tools software so it may be a little different.
Here I'll be demonstrating with a pump gas run for a HPF stage 1 car (actually stage 2 -- but without meth):
http://img19.imageshack.us/img19/9606/ss2dd.jpg (http://img19.imageshack.us/i/ss2dd.jpg/)
Under the "graph data" window, make sure Speed (mph), Height (feet), and Distance (feet) are checked (and nothing else). If the units are not in mph/feet, you can change the settings under "options" --> "units of measurement."
http://img706.imageshack.us/img706/4633/ss3aa.jpg (http://img706.imageshack.us/i/ss3aa.jpg/)
Now move the cursor to the start of the run, click "edit data" and "cut all data before cursor" (you can also hotkey shift-x):
http://img35.imageshack.us/img35/4483/ss4pn.jpg (http://img35.imageshack.us/i/ss4pn.jpg/)
Now move the cursor to the end of the run, click "edit data" and "cut all data after cursor" (or hit ctrl-x):
http://img35.imageshack.us/img35/7793/ss5ue.jpg (http://img35.imageshack.us/i/ss5ue.jpg/)
Now click "export" --> "chart" and a TeeExportForm dialogue box pops up. Click the "Data" tab, and make sure format is "text" and delimiter is "tab"
http://img194.imageshack.us/img194/3799/ss6y.jpg (http://img194.imageshack.us/i/ss6y.jpg/)
Click save, pick whatever name you want -- just make sure you know where it saved to (I prefer the desktop). Now open that file in notepad/wordpad, hit ctrl+a (selects all) and ctrl+c (copies):
http://img189.imageshack.us/img189/1856/ss7v.jpg (http://img189.imageshack.us/i/ss7v.jpg/)
Then go back to the open office calc spreadsheet, click on cell A2, and hit ctrl+v (pastes). A pop-up window will appear -- just hit OK:
http://img51.imageshack.us/img51/3796/ss8wt.jpg (http://img51.imageshack.us/i/ss8wt.jpg/)
Most of the spreadsheet should now automatically fill. Now look at the other red box and make sure the values are correct for your car & the weather at the time of your run. The e46 M3 has a Cd of .32, the frontal area is somewhere in the 22-24' area (this one isn't too critical), weight is 3500-3600lbs + turbo kit + driver. For the weather I go to wunderground.com -- type in "Portland, OR" scroll down to "history & almanac" and put in 11/29/09 (when I believe Chris made this run). At 3:53 that afternoon, I get:
http://img718.imageshack.us/img718/3824/ss10.jpg (http://img718.imageshack.us/i/ss10.jpg/)
From the vbox data, I see Chris was running on a 30-33* heading (NNE) so the 6mph WNW wind was pretty much at his side. You can leave headwind as zero, or do 1/2 of the wind (since x-winds do add drag). 2.6mph is nothing, but I'll put it in anyway. Pressure was 30.33, temp 43, and humidity 74% For the Green box, these gear multipliers are about right for e46 M3 stock gearing and typical slightly larger (diameter) rear tires although feel free to adjust them to your specs:
http://img718.imageshack.us/img718/7844/ss11.jpg (http://img718.imageshack.us/i/ss11.jpg/)
If this run had been done over multiple gears, I'd probably just plot speed vs rwhp. To do this, just highlight cells AA9 - AD9 and scroll down until you get "#DIV/0!" -- then click insert chart (and follow the steps under "graphing" below).
But since this run was all done in 4th gear, we can easily get rpm (and from rpm & HP -- we can get torque). So scroll over to AF10, highlight the cell, type in "=$I$14*B10" -- then hit enter. Click back on AF10, right click copy, then click AF11 and drag down as far as AG has valid data (in this case AF 167). Right click again, and select paste. This section of the spreadsheet should now be filled in (the torque values specifically).
Graphing:
highlight all of the cells (including the first row with the titles) you want to graph, click Insert --> chart. A graph appears with a chart wizard. Select "XY (Scatter)" and "lines only"
http://img59.imageshack.us/img59/3006/ss12e.jpg (http://img59.imageshack.us/i/ss12e.jpg/)
Click next, make sure "data series in columns" and "first row as label" are checked, then click next again. Step 3 -- just click next again. Step 4, chart elements. You can add a title ("Terry HPF M3"), subtitle (Pump Gas (no meth)), X-axis title: RPM, Y-axis title: RWHP/RWTQ. I generally like the legend on the left, and I like to check display grids for X and Y axis:
http://img51.imageshack.us/img51/7653/ss13f.jpg (http://img51.imageshack.us/i/ss13f.jpg/)
You're pretty much done unless you want to spend a little time expanding the graph, changing the scale of the axis, changing the color and thickness of the lines, etc. Here's what I come up with:
http://img130.imageshack.us/img130/5237/ss14kz.jpg (http://img130.imageshack.us/i/ss14kz.jpg/)
I've done some techniques to help with smoothing, but keep in mind the data is taken every 0.1 second (whereas a dyno probably samples 10x as fast) so there are going to be some bumps and dips that probably aren't really there. This graph also happened to be one of the most jagged -- most should be better. Anyway, the general trends should be very accurate (and, as many outside the US have long known, in most cases will be lower than "dynojet" figures)
Other notes: I added SAE and STD correction factors. I'm not really a fan of using correction for FI vehicles (especially turbo), but everyone seems to want SAE. Keep in mind the "actual" numbers are what the car truly made that day -- SAE/STD are basically an educated guess as to what they would make under those preset atmospheric conditions.
other graphs:
Terry pump+meth:
http://img51.imageshack.us/img51/2546/hpfs2.jpg (http://img51.imageshack.us/i/hpfs2.jpg/)
Terry Race (no meth):
http://img682.imageshack.us/img682/16/hpfs2r.jpg (http://img682.imageshack.us/i/hpfs2r.jpg/)
Terry Race+meth:
http://img714.imageshack.us/img714/5235/hpfs2rm.jpg (http://img714.imageshack.us/i/hpfs2rm.jpg/)
Scott's 4th gear pull last year:
http://img36.imageshack.us/img36/4241/scott4th.jpg (http://img36.imageshack.us/i/scott4th.jpg/)
Compare the above with the dynojet runs, and you'll typically see +100ftlbs ~4000rpm (from turbo being able to spool much faster on the road), but also 20-40hp less peak hp...
Scott's recent 5.83 60-130 run on the new HPF stage 2.5 tune:
http://img718.imageshack.us/img718/7613/scott583.jpg (http://img718.imageshack.us/i/scott583.jpg/)
Scott's friend (TT viper -- estimated weight 3650, estimated temp 60* estimated pressure 30.3)
http://img51.imageshack.us/img51/4463/ttviper.jpg (http://img51.imageshack.us/i/ttviper.jpg/)
From SPDu4ea
First, a big thanks to Scott (Racemx-m3) and Chris (HPF Chris) for providing ample data for me to use to test and refine this spreadsheet. I couldn't have done it without them...
Part 1 was mostly proving that the theory would translate into practice, and I had a couple people ask for the spreadsheet so they could use on their own. Now that I'm confident in the various corrections, I have tried to make the spreadsheet as user friendly as possible. You can download it here: http://www.mediafire.com/file/nnhyjn22okk/PBOXdyno.ods (http://www.mediafire.com/file/nnhyjn22okk/PBOXdyno.ods)
If you don't recognize the ".ods" format, it is open office calc (available for free: http://www.openoffice.org/ (http://www.openoffice.org/) ). Many of you have excel, but some don't so this seemed to be the easiest way.
When you open it up, it should look like this (sorry in advance if screen shots are too big for some monitors):
http://img188.imageshack.us/img188/419/ss1bq.jpg (http://img188.imageshack.us/i/ss1bq.jpg/)
You will only need to enter data into the red boxes (green box is optional if you want to graph rpm instead of speed). Don't touch anything else unless you know what you're doing...
Now open up the Vbox software and load your run. I'm using the driftbox tools software so it may be a little different.
Here I'll be demonstrating with a pump gas run for a HPF stage 1 car (actually stage 2 -- but without meth):
http://img19.imageshack.us/img19/9606/ss2dd.jpg (http://img19.imageshack.us/i/ss2dd.jpg/)
Under the "graph data" window, make sure Speed (mph), Height (feet), and Distance (feet) are checked (and nothing else). If the units are not in mph/feet, you can change the settings under "options" --> "units of measurement."
http://img706.imageshack.us/img706/4633/ss3aa.jpg (http://img706.imageshack.us/i/ss3aa.jpg/)
Now move the cursor to the start of the run, click "edit data" and "cut all data before cursor" (you can also hotkey shift-x):
http://img35.imageshack.us/img35/4483/ss4pn.jpg (http://img35.imageshack.us/i/ss4pn.jpg/)
Now move the cursor to the end of the run, click "edit data" and "cut all data after cursor" (or hit ctrl-x):
http://img35.imageshack.us/img35/7793/ss5ue.jpg (http://img35.imageshack.us/i/ss5ue.jpg/)
Now click "export" --> "chart" and a TeeExportForm dialogue box pops up. Click the "Data" tab, and make sure format is "text" and delimiter is "tab"
http://img194.imageshack.us/img194/3799/ss6y.jpg (http://img194.imageshack.us/i/ss6y.jpg/)
Click save, pick whatever name you want -- just make sure you know where it saved to (I prefer the desktop). Now open that file in notepad/wordpad, hit ctrl+a (selects all) and ctrl+c (copies):
http://img189.imageshack.us/img189/1856/ss7v.jpg (http://img189.imageshack.us/i/ss7v.jpg/)
Then go back to the open office calc spreadsheet, click on cell A2, and hit ctrl+v (pastes). A pop-up window will appear -- just hit OK:
http://img51.imageshack.us/img51/3796/ss8wt.jpg (http://img51.imageshack.us/i/ss8wt.jpg/)
Most of the spreadsheet should now automatically fill. Now look at the other red box and make sure the values are correct for your car & the weather at the time of your run. The e46 M3 has a Cd of .32, the frontal area is somewhere in the 22-24' area (this one isn't too critical), weight is 3500-3600lbs + turbo kit + driver. For the weather I go to wunderground.com -- type in "Portland, OR" scroll down to "history & almanac" and put in 11/29/09 (when I believe Chris made this run). At 3:53 that afternoon, I get:
http://img718.imageshack.us/img718/3824/ss10.jpg (http://img718.imageshack.us/i/ss10.jpg/)
From the vbox data, I see Chris was running on a 30-33* heading (NNE) so the 6mph WNW wind was pretty much at his side. You can leave headwind as zero, or do 1/2 of the wind (since x-winds do add drag). 2.6mph is nothing, but I'll put it in anyway. Pressure was 30.33, temp 43, and humidity 74% For the Green box, these gear multipliers are about right for e46 M3 stock gearing and typical slightly larger (diameter) rear tires although feel free to adjust them to your specs:
http://img718.imageshack.us/img718/7844/ss11.jpg (http://img718.imageshack.us/i/ss11.jpg/)
If this run had been done over multiple gears, I'd probably just plot speed vs rwhp. To do this, just highlight cells AA9 - AD9 and scroll down until you get "#DIV/0!" -- then click insert chart (and follow the steps under "graphing" below).
But since this run was all done in 4th gear, we can easily get rpm (and from rpm & HP -- we can get torque). So scroll over to AF10, highlight the cell, type in "=$I$14*B10" -- then hit enter. Click back on AF10, right click copy, then click AF11 and drag down as far as AG has valid data (in this case AF 167). Right click again, and select paste. This section of the spreadsheet should now be filled in (the torque values specifically).
Graphing:
highlight all of the cells (including the first row with the titles) you want to graph, click Insert --> chart. A graph appears with a chart wizard. Select "XY (Scatter)" and "lines only"
http://img59.imageshack.us/img59/3006/ss12e.jpg (http://img59.imageshack.us/i/ss12e.jpg/)
Click next, make sure "data series in columns" and "first row as label" are checked, then click next again. Step 3 -- just click next again. Step 4, chart elements. You can add a title ("Terry HPF M3"), subtitle (Pump Gas (no meth)), X-axis title: RPM, Y-axis title: RWHP/RWTQ. I generally like the legend on the left, and I like to check display grids for X and Y axis:
http://img51.imageshack.us/img51/7653/ss13f.jpg (http://img51.imageshack.us/i/ss13f.jpg/)
You're pretty much done unless you want to spend a little time expanding the graph, changing the scale of the axis, changing the color and thickness of the lines, etc. Here's what I come up with:
http://img130.imageshack.us/img130/5237/ss14kz.jpg (http://img130.imageshack.us/i/ss14kz.jpg/)
I've done some techniques to help with smoothing, but keep in mind the data is taken every 0.1 second (whereas a dyno probably samples 10x as fast) so there are going to be some bumps and dips that probably aren't really there. This graph also happened to be one of the most jagged -- most should be better. Anyway, the general trends should be very accurate (and, as many outside the US have long known, in most cases will be lower than "dynojet" figures)
Other notes: I added SAE and STD correction factors. I'm not really a fan of using correction for FI vehicles (especially turbo), but everyone seems to want SAE. Keep in mind the "actual" numbers are what the car truly made that day -- SAE/STD are basically an educated guess as to what they would make under those preset atmospheric conditions.
other graphs:
Terry pump+meth:
http://img51.imageshack.us/img51/2546/hpfs2.jpg (http://img51.imageshack.us/i/hpfs2.jpg/)
Terry Race (no meth):
http://img682.imageshack.us/img682/16/hpfs2r.jpg (http://img682.imageshack.us/i/hpfs2r.jpg/)
Terry Race+meth:
http://img714.imageshack.us/img714/5235/hpfs2rm.jpg (http://img714.imageshack.us/i/hpfs2rm.jpg/)
Scott's 4th gear pull last year:
http://img36.imageshack.us/img36/4241/scott4th.jpg (http://img36.imageshack.us/i/scott4th.jpg/)
Compare the above with the dynojet runs, and you'll typically see +100ftlbs ~4000rpm (from turbo being able to spool much faster on the road), but also 20-40hp less peak hp...
Scott's recent 5.83 60-130 run on the new HPF stage 2.5 tune:
http://img718.imageshack.us/img718/7613/scott583.jpg (http://img718.imageshack.us/i/scott583.jpg/)
Scott's friend (TT viper -- estimated weight 3650, estimated temp 60* estimated pressure 30.3)
http://img51.imageshack.us/img51/4463/ttviper.jpg (http://img51.imageshack.us/i/ttviper.jpg/)