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 Excel2003 or earlier. 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.
Make sure that 'Front' is the current sheet.
Click on the 'Edit' menu, then the 'Move or Copy sheet' command. The shortcut is Alt+E, Alt+M
Where the dialog says 'Before sheet', select 'Rear'.
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 the rear sheets have not 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 the front sheets have not 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 front and rear, LH and RH worksheets 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 of the vehicle is updated.