Using Excel - 4

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

Creating Excel worksheets for LH and RH data

This Excel tutorial requires Excel2007 or later. Check the supported versions of Excel here.

This tutorial builds on the previous tutorial, Creating Excel worksheets for front and rear suspensions and will show how to build a complete set of worksheets, FrontLH, FrontRH, RearLH, and RearRH.

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

Because we are demonstrating the ability to update data according to the worksheet name you should change one or more input dimensions to force the results to be asymmetric. Then it is easy to see that the correct data is updated on the correct worksheet.

Start Excel, and open the same Workbook used for the previous tutorial (if it is not already open).

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

Go to the Tools tab, and then Calc2Excel. This will open the "Export calculated data to Excel" dialog, and connect to the open workbook.

Notice that (just under the 'Open Excel' button) it shows 'Book1'. This is the name of the current Excel workbook.
Note also that the datum side is shown.
Don't close the "Export to Excel" dialog. You can minimize it, just don't close it.

Previously, we didn't append the range names with "LH" or "RH", so we only updated data for the datum side. But now we will use the worksheet name to determine the data side.

So now we need to create a 'Front LH' worksheet.

But before we do, make sure that you add all the named ranges to the 'Front' sheet that you will need.
This saves having to create them multiple times.

Now, we need to copy the 'Front' sheet.
Click on the 'Front' sheet tab (to make sure that is the current sheet).
On the Home tab, in the Cells group, click Format and then under Organize Sheets, click Move or Copy Sheet.
You can also right-click on a selected sheet tab, and then click Move or Copy.
Where the dialog says 'Before sheet', select 'Sheet2'.
Then 'tick' the 'Create a copy' box, then OK.

Excel will copy the 'Front' sheet, and create a new sheet called 'Front (2)'.
Rename the 'Front' sheet to 'FrontLH', 'Front (2)' to 'Front RH'.
Note that the worksheet name is case insensitive, and can have a space between the 'Front' and the 'LH'.

Similarly, copy the 'Rear' worksheet and rename the two sheets to 'Rear LH' and 'Rear RH'.

Back to SusProg3D and change to [Front].
Go to Roll&Bump and do a Roll&Bump Calc.
Because there are worksheets named 'Front', SusProg3D will make them the active worksheet, and update the Travel and Camber cells. Verify that the LH data has been written to the 'Front LH' worksheet, and the RH data to the 'Front RH' worksheet. Verify that neither of the rear sheets have been updated.

Change to [Rear] and do a Roll&Bump Calc.
Because there are worksheets named 'Rear', SusProg3D will make them the active worksheet, and update the Travel and Camber cells. Verify that the LH data has been written to the 'Rear LH' worksheet, and the RH data to the 'Rear RH' worksheet. Verify that neither of the front sheets have been updated.

For the front and rear calculations we have just done, we could have used ECalc with the "Roll and Bump" ticked. The results are the same.

We could also use the VCalc dialog. The difference is that ECalc only does one end of the vehicle whereas VCalc does both ends of the vehicle.
If you use VCalc with the "Roll and Bump" ticked, then all four worksheets, Front LH, Front RH, Rear LH and Rear RH will be updated.

So what we have now done, is to ensure that the front and rear, LH and RH data is correctly identified in the Excel workbook, and that only that data for the appropriate end and side of the vehicle is updated.

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