Creating Excel worksheets for LH and RH data
![]()
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.
You will need SusProg3D V4.91(or later) and Excel97 (or later).
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
sheet(s) 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 sheet(s) 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.
What you may prefer, is that the four source data sheets 'Front LH', 'Front
RH', 'Rear LH' and 'Rear RH'
are updated by SusProg3D, and that your graphs and calculations are on other
sheets, referencing back to the source data sheets.
This way you can see the results (perhaps graphs) in which you are interested as
you do the SusProg3D calculations.