Using Excel - 1

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

Using Excel to graph SusProg3D data

horizontal rule

This Excel tutorial requires Excel2007 or later. 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 do a Roll&Bump Calc.
Your screen should now look something like this.

graphic01.jpg (180840 bytes)

If you have other graphic elements showing, then go to the Display tab, then Control. Untick all the items in "Show" except IC lines. Because we are only calculating the basic roll and bump geometry, other elements (like the shock absorber and springs) are not calculated and may display incorrectly.

Go to the Tools tab, 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.

Go to Windows Start, then All Programs, then Microsoft 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 the block of 11 cells A2 to A12. Then go to Formulas -> Define Name. Name this group S3D_Point_Bump, change the Scope to Sheet1, and then OK.

graphic02.jpg (155233 bytes)

Repeat with a second block of 11 cells, B2 to B12, and name as S3D_Point_Camber_LH, scope as Sheet1.

Repeat with a third block of 11 cells, C2 to C12, and name as S3D_Point_Camber_RH, scope as Sheet1.

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 will now update with the travel and camber values.

graphic03.jpg (214334 bytes)

Now, back to Excel.

Highlight the cells A2 to C12, then go to Insert -> Charts. Choose the chart type "Scatter" and the subtype "Scatter with smooth lines and data".

graphic04.jpg (162276 bytes)

The graph will be selected, so you can edit its properties.
Go to Select Data. This will open the Select Data Source dialog.
Under Legend Entries (series) select Series1 and then Edit.
Change the Series X Values from Sheet1!$A$2$A$12 to Sheet1!$B$2$B$12, and Series Y Values from Sheet1!$B$2$B$12 to Sheet1!$A$2$A$12. Click OK.
Repeat for Series2 changing the Series X Values from Sheet1!$A$2$A$12 to Sheet1!$C$2$C$12, and Series Y Values from Sheet1!$C$2$C$12 to Sheet1!$A$2$A$12. Click OK.
Back in the Select Data Source dialog click OK.

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

graphic05.jpg (159514 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.

graphic06.jpg (380897 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

graphic07.jpg (390350 bytes)

Tutorial developed using Excel2003 and SusProg3D V4.516B on Windows 7 Ultimate (64-bit) 13 Jan 2013