Update 11/1/06

Version11 allows graphing with any Group file, not just the one I've been maintaining.  There's also a handful of new features.  Read all about it here: http://forums.audiworld.com/s4/msgs/2516745.phtml

If you want to try them out, feel free to grab the latest from here:
http://ctny.audiworld.com/mark/s4/ecux/template11/

Here are examples of some of the output of each:
Single-gear template example
Multi-gear template example

The biggest change is that this version doesn't require one to use a specific group file to match the template. You can use your own group file, with variables in any order. You merely paste the corresponding column headers so the file knows what the data is.
Helpful Hint: When you first open up the csv file from your log, the cursor will already be in cell A1. Click ctrl-shift-<right_arrow> and it will highlight the header row. Then just do a ctrl-c and ctrl-v to copy/paste it into the templates.

In addition to that, I've also changed some of the Auto-Calculators to be more flexible...

In the single-gear-pull template:

- In the FATS calculator, I added the calculated/corresponding MPH for 4200/6500, so it is immediately obvious if the results are from a car with different gearing. Also it can be used to remind us what the startMPH and endMPH are for our normal FATS pulls - this info can then be used in the Any-Speed-Range calculator below for other cars to compare to ours.

Update 3/29/06

Graphing:
4runs_compare_graph_v10.7.xls :
- The FATs graph now has labels on both the left and right Y-axes to better see the time at 6500
- A new "FATS Summary" graph was created. This is similar to the existing summary table, but the graph can be easily saved as an image for posting.

Update 3/28/06

Graphing:
4runs_compare_graph_v10.6.xls :
- The starting RPM of the graphs has been changed to 2000 (instead of 3000), as well as the graphs have been widened so the resolution remains the same.
- Some of the Y-Axis ranges of the graphs have been altered slightly to better view data people have been generating.
- The "A/F Desired" graph now has a second Y-Axis which shows approximate Air Fuel values which correspond to the Lambda values.

Data Prep:
grab_data_macro_v10.1.xls :
- The "Run Me!" macro now opens a file browser so you can point to any .csv file. You no longer have to rename your csv file to "dataprep.csv" and put it in a predetermined directory.

Update 11/30/05

Graphing:
- I added a new tab called "Compare (mph)". This page uses MPH as the x-axis. This is useful when comparing two multi-gear runs as the associated RPMs will still line up.
- I renamed the file from 2runs_timebased_graph_v10.5.xls to 2runs_multigear_graph_v10.7.xls to better reflect it's current design.
- I added a 0-100 MPH calculator to 2runs_multigear_graph_v10.7.xls
- I added a check for the 0-60mph and 0-100mph calculators to ensure that the data posted included data at 0mph & 60/100mph.

Update 10/26/05

Graphing:
- I made some minor changes to scaling and format. (on both 4runs_compare_graph_v10.5.xls and 2runs_timebased_graph_v10.5.xls below)

Update 10/26/05

Graphing:
- I added a "Boost PSI - Desired Only" comparison graph to 4runs_compare_graph_v10.3.xls below.
- I changed the column width on the comparison tab to make it easier to "save as web page" for the graph column. (on both 4runs_compare_graph_v10.3.xls and 2runs_timebased_graph_v10.3.xls below)
- I fixed an incorrect color on one of the comparison graphs.

Update 9/6/05

Graphing:
- I added a FATS+ (4000-7000) auto-calculator and graph to the 4runs_compare_graph_v10.1.xls below.

Data Prep:
- The initial release of v10 still had "grab_data_template10.xls" listed in the macro. I had changed the filename to "grab_data_macro_v10.xls", but forgot to update the macro. I fixed this on 9/3/05 and uploaded v10 again (I didn't bother to give it a new filename to reflect this updated file)

Update 9/1/05 - Version 10

Group File:
- I added AcceleratorPedalPosition.  This enables the macro to grab data based on the Pedal position, and not the Throttle Body position.  As such, the macro to grab data even when the Throttle Body is not fully open (low RPMs, throttle cut, etc).
- I added EGTbank1OXS and EGTbank2OXS.  These show the Exhaust Gas Temperatures at the primary O2 sensors in the downpipes. These can be useful to get an idea of temperatures at this location when the True EGTs are not high enough to register on the real EGT sensors (which are logged as EGTbank1 and EGTbank2).
- I added OXSVoltS1B1 and OXSVoltS1B2.  These show your O2 Voltages which can indicate how rich or lean your engine is actually running. Desired A/F is what the car is trying to obtain (prior to any tweaking by Lemmiwinks, V-Tune, etc), where as O2V show what is actually occuring.
- I removed IgnitionTimingCyl1-IgnitionTimingCyl6. These were taking up 6 spots that were more useful for other variables.  Also, the combination of all 6 of these is already noted in IgnitionTimingAngleOverall.  
- I rearranged the variables in the Group File as well so they were better organized, and better match the order of graphs

Data Prep:
- The data is now being grabbed based on Accelerator Pedal Position being at >90%.  This will allow proper grabbing of data even if throttle cut occurrs.
- The "Color Legend" Excel tab in grab_data_macro_v10.xls documents the various color coding.  This is documented below in the "Color Coding" section as well.

Graphing:
- I rearranged some of the graphs to put them in more useful/logical order.
- I added graphs for the new variables listed above that were added to the Group File.
- I created an Automatic FATS Calculator.  No longer do you have to cut/paste data into the previous calculator.  Now the data is entered automatically and there is one on each tab in the single-gear template (4runs_compare_graph_v10.xls)
- I created an Automatic 0-60 MPH Calculator.  On the multi-gear / timebased template (2runs_timebased_graph_v10.xls), there is a 0-60 Calculator on each tab.

Note: Due to the various changes, mixing versions of files will not work.  Please download all new files below. All v10.* files will work with each other.

LOGGING SESSION
 
In order to log in ECUx, you utilize a Group File which contains the variables that you want to log.  You can create your own or utilize mine to start wtih.
FILE: typical10.egp

I have set this up to log the following variables:

TIME
RPM
BaroPressure
BoostPressureDesired
BoostPressureActual
BoostFrequencyValveDutyCycle
MassAirFlow
IntakeAirTemperature
AcceleratorPedalPosition
ThrottlePlateAngle
IgnitionRetardCyl1
IgnitionRetardCyl2
IgnitionRetardCyl3
IgnitionRetardCyl4
IgnitionRetardCyl5
IgnitionRetardCyl6
IgnitionTimingAngleOverall
KnockVoltCyl1
KnockVoltCyl2
KnockVoltCyl3
KnockVoltCyl4
KnockVoltCyl5
KnockVoltCyl6
VehicleSpeed
Gear
AirFuelRatioDesired
FuelInjectorOnTime
EGTbank1
EGTbank2
EGTbank1OXS
EGTbank2OXS
OXSVoltS1B1
OXSVoltS1B2
EngineLoad
EngineLoadSpecified
EngineLoadCorrectedSpecified

DATA PREP

Click on any of the screen captures below to view larger image.

FILE: grab_data_macro_v10.1.xls
After you are done logging, use ECUx to Export your log to CSV.  [see Figure 1]

Figure 1 - Sample ECUx output after being exported to CSV

I have created an Excel macro which will take this CSV file and pull out only the "good" data, as well as color-coding some of the data.  I have defined "good" data to be when Accelerator Pedal Position is >90%.  This will still grab data when the Throttle Position is lower than that due to low RPMs, Throttle Cut, etc.

1.) Open up grab_data_macrov10.1.xls (Click "Enable Macros" if/when prompted) and click on the "Macros" tab at the bottom.  Then click on the "Run Me!" button. [see Figure 3]

Figure 3 - Shows Macros tab and "Run Me!" button

2.) A file browser will pop up. Select the csv file that you wish to graph.
At some point it may say there is data on the clipboard and ask if you want to use it later.  Click NO.
When the macro finishes, you will be on the "Final Data" tab.  The data you now see is just the "good" data, and some parts of that data have been color-coded to aid in understanding what you are seeing.  Please see the "Notes" tab to see what each column's color code refers to.  [see Figures 4 & 5]

Figure 4 - Shows Final Data tab with filtered, color-coded output

Figure 5 - Another example of the Final Data tab.  Here you can easily see how the color coding shows that these are two 3rd gear runs, and both go from low to high RPMs.  This is due to: 
Column U (Gear) being all green (green = 3rd gear)
Column B (RPM) goes green to white to orange (green= <4000 RPMs, orange= >6000 RPMs)
Also note the red box in Column A.  This denotes where two different Time sections meet up.  The areas that is all white means that those timestamps are all in order, thus all from one continuous logging pull.  There was likely many minutes of "junk" cruising data between those two pulls, and thus this grab_data macro pulled out only the good stuff.

Helpful Hint: When selecting data to copy, try highlighting just the TIME column for the rows you want.  Then press Ctrl+Shift+RightArrow all at once and the rows you selected will be highlighted over to the right until there's empty cells.

Color Coding:
Adding color helps to easily identify certain aspects of the data whether it is merely informative such as which gear you are in, or whether it's to find problem areas such as high Boost or EGTs.  Here is the full list of color coding (also listed in the "Color Legend" Excel tab in grab_data_macro_v10.xls):

TIME 
Red when it's the last timestamp of a logging segment 

RPM 
Green when less than 4000 RPMs 
Orange when greater than 6000 RPMs 

BoostPressureActual 
Orange is >2500mbar (~1.5bar ~21.75psi), 
Red is >2535mbar (~1.535bar, ~22.25psi) 

AcceleratorPedalPosition 
Green when it equals 100% 

ThrottlePlateAngle 
Green when it equals 100%, 
Red when 30% less than AcceleratorPedalPosition (ie throttle cut) 

KnockVoltCyl* 
Orange is >25, 
Red is >30 

Gear 
Green = 3rd, 
Orange = 4th, 
Blue = 5th 

FuelInjectorOnTime (color coded per calculated Duty Cycle) 
Orange for >90%, 
Red for >100% 

EGTbank* 
Yellow is >1735F (945C) 
Orange is >1765F (962C) 
Red is >1796 (980C)

EGTbank*OXS 
Yellow is >850C 
Orange is >860C 
Red is >870C

GRAPHING

FILE: 4runs_compare_graph_v11.*.xls
FILE: 2runs_multigear_graph_v11.*.xls

Single Gear Pulls

Now you can easily cut and paste data from your "Final Data" tab on the grab_data_macro_v10.xls sheet into the "4runs_compare_graph_v11.*.xls" template I have created.  These files then instantly populate 24 graphs changing the raw data numbers into easy-to-see graphs of what's taking place.

When cutting/pasting the data from the Final Data page, just copy the data from a single run and paste it into one of the 4 tabs into the cell that says "paste here" (Cell B2)

If you are just graphing a single gear pull, use the "4runs_compare_graph_v11.*.xls" template.  This template includes 4 tabs that you can paste 4 different runs on, and then a "Compare" tab that overlays the data from all 4 runs.  On the Compare tab, each of the 4 runs are then graphed in a different color to easily distinguish one from the next.  Data from tabs 1 & 2 are Red-ish and tabs 3 & 4 are Blue-ish.  This way, if you have made a change to the car and did two runs with each setup, you can easily tell the Red runs from the Blue runs.  At the same time, if all 4 runs are different, the different shades of red and blue still make it easy to distinguish each of them independently.   [see Figure 6]

Figure 6 - Once the data is pasted into the template the Compare tab shows them overlaid and colored differently to easily distinguish each.

Automatic FATS Calculator
On each of the single-gear pull pages, there is an automatic FATS calculator (manual version here).  If the data you paste is for a 3rd gear pull and contains data extending from 4200 to 6500 RPMs, it will calculate the exact time it took to perform this task.  There is a graph (see below) in addition to the raw number.  Here is the calculator, which is automatically filled out:

Any-RPM-Range Auto-Calculator
Here is a generic RPM-range calculator. This can be used for 4000-7000 RPM range (which some use for "FATS+"), or for any range desired. Here is the calculator, which is automatically filled out (just enter the desired range in the yellow boxes):

Any-Speed-Range Auto-Calculator
Here is a generic Speed-range calculator. This can be used for 0-100 MPH range, or for any range desired. It can also be used in non-B5S4s (cars with different gearing) to compute a the corresponding "FATS" time. Here is the calculator, which is automatically filled out (just enter the desired range in the yellow boxes):

Multi-Gear Pulls:

If you are interesting in graphing multiple gears in a row (such as at a drag strip, 0-60mph, or similar), you can use the "2runs_multigear_graph_v11.*.xls" template.  Unlike the above template that has RPM as the x-axis, this template has Time as the x-axis.  One application where I used this was when I was graphing my Intake Air Temps at the drags.  I wanted to see how they compared with and without Aquamist active, over the course of the entire run (through 4 gears).  [see Figure 7]

Note: When using this template, do not use the grab_data macro as that would remove datapoints during shifts (when Accelerator Pedal is <90%).  Therefore, copy/paste data into this template directly from the CSV file.  You'll just have to look at the VehicleSpeed column to grab the data that you want.

Figure 7 - In the "timebased" template, the x-axis is Time, thus you can graph a multi-gear run continuously.  The above shows two separate continual drag-race style 1st-4th gear logs.  This is the Compare tab which overlays the two, pointing out differences.  In this example, I did it once with Aquamist off and once with it on.  The resulting difference in IntakeAirTempurature is dramatic.  There is also a noted difference in Timing.  This was hard to observe in single gear pulls, but much more obvious in a multi-gear run as heat builds up, which this template allows to be displayed.

Automatic 0-60 MPH calculator
On each timebased multi-gear tab, there is an automatic calculator to determine your 0-60 mph speed.  There's also a corresponding graph. Here is the calculator

So, okay, you've read all of the above stuff and basically understand it.  Below is a quick checklist to look at when trying this stuff out in simplified format:

1.) Log w/ECUx utilizing template10.egp (or your own) group file.
2.) Save log and then open it in ECUx and export it to CSV.
3.) [Optional Step - you can skip this and directly cut/paste from your CSV into step #4]
Open grab_data_macro_v10.*.xls, say yes to enable macros, go to the Macros tab and click the Run Me! button. Browse to the CSV file you wish to graph. Click "No" to saving clipboard data when/if prompted.  You'll see you filtered data in the the FinalData tab.
4.) Copy/paste a single pull into the 4runs_compare_graph_v11.*.xls template.
5.) Enjoy all of your nicely graphed data!

PS - Don't forget to save your nicely-graphed data with a new name so you don't overwrite the template

At this point, you have these nice graphs in Excel.  You may wish to post some, or all, of them to your website or a web forum, etc.  I suggest the following to make this easier

1.) First create a directory on your computer where you want to save the images you are about to create.  I suggest giving the directory a descriptive name so you can differentiate it from future logs you take.
2.) On the Compare tab, highlight columns A through D. (Click on the column header where it says "A" and drag across to where it says "D")
3.) Select:  "File", then  "Save as Web Page"
4.) Click "Re/Publish: $A:$D"
5.) Browse to the directory you created.
6.) Set the File name to be "index.html" and click "Save"

 This will create 2 things inside of your directory: 1-The index.html file and 2-A folder of images of your graphs.  You can now upload this directory to your website and easily display all graphs, or if you only wanted a few images, you can choose them from the folder of images.  Either way, this method allows you to change the Excel graphs into GIF images very easily.