E90Post
 


Studio RSR
 
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
30
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
268
Rep
5,876
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
177
Rep
6,631
Posts

Drives: '16 MK7 GTI
Join Date: Feb 2009
Location: NYC

iTrader: (8)

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
42
Rep
596
Posts

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

iTrader: (12)

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
268
Rep
5,876
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
42
Rep
596
Posts

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

iTrader: (12)

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
30
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
3058
Rep
10,197
Posts

Drives: 2022 AWD M3 Comp - SMB
Join Date: Dec 2006
Location: CT

iTrader: (7)

can't wait to see how accurate this is! should be a fun toy
Appreciate 0
      08-11-2011, 10:46 AM   #9
Joshboody
Lieutenant Colonel
65
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
42
Rep
596
Posts

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

iTrader: (12)

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
Major
ETS Michael's Avatar
United_States
76
Rep
1,155
Posts

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

iTrader: (4)

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
Jeff@TopGearSolutions's Avatar
United_States
3441
Rep
79,212
Posts

Drives: C6 Z06, 09 335i, 10 335xi
Join Date: Dec 2008
Location: www.TopGearSolutions.com

iTrader: (37)

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
30
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
268
Rep
5,876
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
30
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
30
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
First Lieutenant
15
Rep
350
Posts

Drives: E
Join Date: Jun 2010
Location: No where

iTrader: (0)

Will this be 335's only?
Appreciate 0
      08-15-2011, 09:57 PM   #18
dfv2
Lieutenant
dfv2's Avatar
United_States
30
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
65
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
146
Rep
1,922
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
30
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
30
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



All times are GMT -5. The time now is 04:49 PM.




e90post
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
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