Using Excel - 1

Home ] What's new! ] Suspension types ] Tutorials ] Downloads ] Data files ] FAQ ] Purchase here ] Contact us ]

Using Excel to graph SusProg3D data

This Excel tutorial requires Excel2003 or earlier. Check the supported versions of Excel here.

This tutorial demonstrates a method for displaying multiple SusProg3D calculated data items graphically.

This tutorial uses the Nascar demo file, but you can use your own data.

Start SusProg3D, and open the demo file, Nascar.s3d

Go to Roll&Bump. Make sure that you are using [Front], and then do a Roll&Bump Calc.
Your screen should now look something like this.
tutorial01.jpg (74921 bytes)

Go to the Tools tab, and then Calc2Excel. This will open the "Export calculated data to Excel" dialog.
If the number of calculated data points is greater than the Excel range, then all Excel cells will be blank, so make sure that the Excel range size matches the Roll&Bump calculation range.
The required number of cells is shown in the "Export calculated data to Excel" dialog. For the camber graph we only need the front bump and droop data points.

Start Excel. It will open with Book1 and Sheet1.

Add some text to cell A1, "Travel", B1 "LH" and C1 "RH"

This tutorial assumes 11 data points in bump and droop. If you have more data points, then increase the range of cells by the appropriate number in the following instructions.
For example, if you have 21 data points then A12 will become A22, B12 will become B22, etc.

Select a the block of cells A2 to A12. Then go to Insert -> Name -> Define, and name this group as S3D_BUMP, then "OK"
tutorial03.jpg (96734 bytes)

Repeat with a second block of cells, B2 to B12, and name as S3D_CAMBER_LH

Repeat with a third block of cells, C2 to C12, and name as S3D_CAMBER_RH

Back to SusProg3D, and close and reopen the "Export calculated data to Excel" dialog.
Because Excel was open, SusProg3D will connect to the currently open workbook. If you had closed Excel before doing the Calc, you will need to use the Open button to open the required workbook.
Leave it open, don't close the dialog as this is the connection between SusProg3D and Excel.

Go back to the Roll&Bump tab, and Calc.

The three blocks of cells have been updated with the travel and camber values.
tutorial04.jpg (250796 bytes)

Now, back to Excel.

Highlight the cells A2 to C12, then go to Insert -> Chart. Choose the chart type "XY (Scatter)" and the subtype "Scatter with data points connected by smoothed lines".
tutorial05.jpg (131106 bytes)
Click on "Next".
In the "Data Range" tab, the data range should be =Sheet1!$A$2$C$12, series should be "Columns" .
In the "Series" tab, highlight Series1, and change the X values to =Sheet1!$B$2$B$12 and the Y values to =Sheet1!$A$2$A$12.
Highlight Series2, and change the to X values to =Sheet1!$C$2$C$12 and the Y values to =Sheet1!$A$2$A$12.
Click on "Finish".

You should now have a graph showing the LH and RH wheel camber curves. Because they are the same, you only see one.
tutorial06.jpg (71969 bytes)

Now we will change the static camber of the LH wheel (and make it different to the RH wheel).

Go back to SusProg3D, and go to Geometry. Make sure it is [Front] and [LH]. Then Alignment.
Change the Camber to 0.5 and "untick" the "RH identical", then "Apply". This will leave the RH camber at the original setting and change the LH camber to the new setting. Do not close the dialog, just move it out of the way if you wish.
tutorial07.jpg (259802 bytes)

Now go to Roll&Bump and Calc. The graph will update, and you will see the two curves. Also, because the Alignment dialog was left open, it has also updated with the calculated values. And, of course, the display has also updated
tutorial08.jpg (260127 bytes)