Announcement

Collapse
No announcement yet.

Need help from excel experts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Need help from excel experts

    we have been trying to make an excel usable enough to produce hp+Nm figures from raw data from the perfomance box (speed vs time) however it seems that the high accuracy of the thing makes the data unsuable.

    I enclose the excel file with one of my most recent runs,in which you can see that the power figures and torgue figures are all over the place.Surelly there could be a way to make it work...i just don know much about excel so..

    here you go!If you drag the columns down you can have more figures of each column.

    the idea was that i can take the time vs speed from the PB and paste it on the first 2 columns,and then all the columns would get the data.However as the PB has a speed value every 0.1sec you end up with so many figures and so many data there.

    I have tried to pick values from the PB data,but although the graphs make more sense they are not at all near the power/torgue figures you actually have.It depends on your choise of figures you use really.

    Any help is appreciated!
    thanks
    vasilis
    Last edited by A80Avant; 29 August 2009, 20:21.

  • #2
    I am good with Excel, but a bit lost in all this data... Andy Casey must have similar spreadsheets that he crunches from his GPS based device - which I also believe provides updates on 0.1second basis.
    Paul Nugent
    Webmaster http://S2central.net
    Administrator http://S2forum.com

    1994 S2 Coupe ABY - aka Project Lazarus
    2001 A6 allroad 2.5TDi - family tank
    2003 S4 Avant 4.2 V8 - daily burble

    Purveyor of HomeFries and Exclusive agent for Samco hose kits (S2/RS2)

    There are only 10 kinds of people that understand binary - those that do, and those that don't

    Comment


    • #3
      where is ANdy!!!!!

      i thought that the N95 software or GPS system on navi systems were not as accurate as this one,but if there is a spreadsheet i can test with my raw data then please let me see!!!
      cheers
      vasilis

      Comment

      Working...
      X