E90Post
 


MINHS Auto Care Center
 
BMW 3-Series (E90 E92) Forum > E90 / E92 / E93 3-series Powertrain and Drivetrain Discussions > N54 Turbo Engine / Drivetrain / Exhaust Modifications - 335i > Requesting YOUR datalog, testing excel-based dyno



Reply
 
Thread Tools Search this Thread
      08-11-2011, 09:20 AM   #1
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

Smile Requesting YOUR datalog, testing excel-based dyno

All,

I'm nearly ready to beta test an excel-based dyno spreadsheet that uploads a datalog (.csv, .txt) from your computer and produces accurate HP/TQ results. There are similar programs out there (airboy, etc) however I ensure you that my spreadsheet will be the most accurate, useful tool of its kind available (free too ).

I'm alpha testing the spreadsheet using datalogs from my team's personal vehicles (evo X, '11 wrx, and '08 135i), and now I'd like to expand the testing to YOUR datalogs. The only data I absolutely NEED to do the calcs are time and RPM, and the info below. If your datalog has more info like timing, boost, etc, that's even better!

Looking for ~2,000 steady, then WOT to redline in 3rd or 4th. If you don't pull to redline your numbers will be low!

Please feel free to attach here, or email to srplaske[at]gmail[dot]com, your datalogs for a 3rd or 4th gear pull. With the attachment or email please provide as much of the following as you can:

• Car [year,make,model,trans]
• Gear or diff mods (if not stock)
• Drive tire make/model/size (I use this to find rev/mile from manufacturer spec sheets).
• Cargo weight [driver, passenger(s), cargo]
• Fuel amount in tank (1/4, 1/2, full, almost empty, etc)
• Weather data if availible (altitude, temp, humidity %)
• CF preference (None, STD, SAE... Note: I can only do SAE/STD with accurate weather data)

In return I will post up the dyno sheet printout of your pull and send you a beta release of the spreadsheet when it's ready so you can play around with it.







Thanks fellas,

Steve
__________________
//ecg//

Last edited by dfv2; 08-15-2011 at 10:27 PM. Reason: added chart
Appreciate 0
      08-11-2011, 09:36 AM   #2
dzenno
Banned
Canada
114
Rep
5,883
Posts

 
Drives:
Join Date: Feb 2006

iTrader: (1)

I'd love to see hotrod182's spreadsheet dyno, he's got tons of logs
Appreciate 0
      08-11-2011, 10:07 AM   #3
themyst
Major General
themyst's Avatar
South Korea
86
Rep
6,602
Posts

 
Drives: E90 335i LCI
Join Date: Feb 2009
Location: NYC

iTrader: (8)

Send a message via AIM to themyst
I can do one better, I have datalogs of 4th gear pulls while on the dyno.
__________________
E90 LCI N54 6AT
Appreciate 0
      08-11-2011, 10:12 AM   #4
OneThreeFive
Lieutenant
OneThreeFive's Avatar
United_States
13
Rep
582
Posts

 
Drives: 2008 E90 M3
Join Date: May 2009
Location: NoVA

iTrader: (11)

Garage List
Quote:
Originally Posted by themyst View Post
I can do one better, I have datalogs of 4th gear pulls while on the dyno.
Same. Op, I'll send what I have over from my last time on the dyno.
Appreciate 0
      08-11-2011, 10:17 AM   #5
dzenno
Banned
Canada
114
Rep
5,883
Posts

 
Drives:
Join Date: Feb 2006

iTrader: (1)

A datalog that has a dyno chart associated with it would be the best actually especially for beta testing...cool, will be interesting to see..
Appreciate 0
      08-11-2011, 10:20 AM   #6
OneThreeFive
Lieutenant
OneThreeFive's Avatar
United_States
13
Rep
582
Posts

 
Drives: 2008 E90 M3
Join Date: May 2009
Location: NoVA

iTrader: (11)

Garage List
Quote:
Originally Posted by dzenno View Post
A datalog that has a dyno chart associated with it would be the best actually especially for beta testing...cool, will be interesting to see..
Just sent my 9 data logs and 9 dyno charts from last month.
Appreciate 0
      08-11-2011, 10:29 AM   #7
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

Thanks. Can't wait to run these!

Now for the record, my spreadhseet does it's magic by combining raw G force (moving a mass through space and time), wind resistance (for given mph), and roll resistance (assumed scalar).

A dyno pull will be nothing more than rpm vs time and I'll have fun backwards-engineering the dyno's CF and drum characteristics. In other words, it'l be very useful but is NOT what the sheet does (lol). In any case I'll report back with the findings.
__________________
//ecg//
Appreciate 0
      08-11-2011, 10:37 AM   #8
jpsimon
Team Zissou
jpsimon's Avatar
United_States
164
Rep
9,017
Posts

 
Drives: 2015 STi
Join Date: Dec 2006
Location: CT

iTrader: (6)

can't wait to see how accurate this is! should be a fun toy
__________________
2015 STi / 335xi (solid)
www.datazap.me - fast, free, interactive data log viewing

Appreciate 0
      08-11-2011, 10:46 AM   #9
Joshboody
Lieutenant Colonel
25
Rep
1,708
Posts

 
Drives: pickemuptruck
Join Date: Jul 2009
Location: Phoenix, AZ

iTrader: (7)

Cool, just sent a bunch
Appreciate 0
      08-11-2011, 11:01 AM   #10
OneThreeFive
Lieutenant
OneThreeFive's Avatar
United_States
13
Rep
582
Posts

 
Drives: 2008 E90 M3
Join Date: May 2009
Location: NoVA

iTrader: (11)

Garage List
Please only post the results if the findings show a gain... don't want to hurt my car's e-peen.
Appreciate 0
      08-11-2011, 11:13 AM   #11
ETS Michael
ETS Michael's Avatar
United_States
29
Rep
1,160
Posts

 
Drives: 335i
Join Date: May 2009
Location: Vancouver, WA

iTrader: (4)

Send a message via AIM to ETS Michael
The Evo market has a tool like this for a while, people sale it's pretty accurate.. I have seen some heated arguments over virtual dyno runs though lol.
Appreciate 0
      08-11-2011, 11:15 AM   #12
Jeff@TopGearSolutions
BimmerPost Supporting Vendor
Jeff@TopGearSolutions's Avatar
United_States
247
Rep
18,427
Posts


 
Drives: C6 Z06, GSXR-750, 09 335i
Join Date: Dec 2008
Location: TopGearSolutions.com

iTrader: (32)

Send a message via AIM to Jeff@TopGearSolutions
We had one on my last platform as well, it could only give you torque of course.

The number itself was fairly close but the important part was if you changed your modifications or tune you could then ideally run the same stretch of road, ambients, wind ETC and see if the change has helped.

We used this primarily for maximizing street tunes although it has its obvious limits when it comes to uncontrollable exterior changes.
Appreciate 0
      08-11-2011, 11:38 AM   #13
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

You shall see, my spreasheet is extremely accurate so long as you're using the same stretch of flat pavement and it's not terribly windy. Corrections (if you choose to apply them with decent weather data) are SAE accurate (J1349) and you can always run the data with CF set to none.

Wind is the only real variable that cannot be controlled and thus, DOES impact results if you compare a strong headwind run to a strong tailwind run. It comes down to how much HP was used to combat drag.

Bottom line, the datalog does not lie about what actually happened when you nailed the throttle - this spreadhseet converts raw numerical data to comparable graphic data. Oh, it archives data records and overlays any 3 runs from your database with drop downs.

Enough hype, I'll post back when I run some of these logs.
__________________
//ecg//
Appreciate 0
      08-11-2011, 12:10 PM   #14
dzenno
Banned
Canada
114
Rep
5,883
Posts

 
Drives:
Join Date: Feb 2006

iTrader: (1)

It'd be nice if you could use multiple worksheets inside the workbook for multiple runs and then be able to plot them against each other for a visual comparo

Hey what about this?

http://www.bradbarnhill.com/projects/VirtualDyno/

Last edited by dzenno; 08-11-2011 at 12:16 PM.
Appreciate 0
      08-11-2011, 12:16 PM   #15
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

Quote:
Originally Posted by dzenno View Post
It'd be nice if you could use multiple worksheets inside the workbook for multiple runs and then be able to plot them against each other for a visual comparo
Wayy ahead of you!

As dyno runs are exported (as new sheets via export button) they are added to the reference archive. Dropdowns overlay the data on the dyno chart automatically.
__________________
//ecg//
Appreciate 0
      08-15-2011, 09:40 PM   #16
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

Alpha copies sent out to those who emailed me, let me know what you think guys!!
__________________
//ecg//
Appreciate 0
      08-15-2011, 09:54 PM   #17
TLO03
Second Lieutenant
3
Rep
207
Posts

 
Drives: E61
Join Date: Jun 2010
Location: CT

iTrader: (0)

Will this be 335's only?
Appreciate 0
      08-15-2011, 09:57 PM   #18
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

Any datalog, just add your car to the customer database and it will work. I preloaded a GR sti, 135i, 335i, 11+ WRX, evo X.

Right now it natively supports Cobb format logs, but will accept and work with anything that resembles a datalog so long as it is a 1 row header with "Time" and "RPM" somewhere up there (looking to expand to support procede logs very soon).
__________________
//ecg//
Appreciate 0
      08-15-2011, 10:11 PM   #19
Joshboody
Lieutenant Colonel
25
Rep
1,708
Posts

 
Drives: pickemuptruck
Join Date: Jul 2009
Location: Phoenix, AZ

iTrader: (7)

Thanks, but oh man this is blowing my mind. I have excel 2003, should it matter? And a debugger keeps popping up... can't get past the error type windows. Got worse when I tried to reduce macro security. maybe beyond my putering skills. any advise?
Appreciate 0
      08-15-2011, 10:11 PM   #20
lawwailok
Lieutenant Colonel
lawwailok's Avatar
United_States
34
Rep
1,923
Posts

 
Drives: E90 335i, E70 X5
Join Date: Aug 2009
Location: Sacramento, CA

iTrader: (18)

Garage List
Quote:
Originally Posted by dfv2 View Post
Any datalog, just add your car to the customer database and it will work. I preloaded a GR sti, 135i, 335i, 11+ WRX, evo X.

Right now it natively supports Cobb format logs, but will accept and work with anything that resembles a datalog so long as it is a 1 row header with "Time" and "RPM" somewhere up there (looking to expand to support procede logs very soon).

so did my log help? i've sent you email last week... if not i'll try to do another log and send over =)
__________________
-eric
E90 335i TiAg *STOCK* see my garage for mod list..
E70 X5 SGM *try to stay stock* :/
Appreciate 0
      08-15-2011, 10:17 PM   #21
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

@ law - Yessir I replied too! Let me know if you did not get my email.

Quote:
Originally Posted by Joshboody View Post
Thanks, but oh man this is blowing my mind. I have excel 2003, should it matter? And a debugger keeps popping up... can't get past the error type windows. Got worse when I tried to reduce macro security. maybe beyond my putering skills. any advise?
You have to unzip the file into a fresh folder, and fully enable macros - it should work. Might be a 2007+ version so I may need to send you an "older excel" version. PM me the exact error and I'll work on a fix!
__________________
//ecg//
Appreciate 0
      08-15-2011, 10:24 PM   #22
dfv2
Lieutenant
dfv2's Avatar
United_States
7
Rep
474
Posts

 
Drives: 2009 CTS-V
Join Date: Apr 2010
Location: Upstate NY

iTrader: (3)

http://www.microsoft.com/download/en...aylang=en&id=3
__________________
//ecg//
Appreciate 0
Reply

Bookmarks

Tags
datalog, dyno

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 05:10 AM.




e90post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST