Creating Excel worksheets for LH and RH data
This Excel tutorial uses Excel V16. 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.
The Front LH and RH both reference the 'Front' worksheet and the Rear LH and RH both reference the 'Rear' worksheet.
Note also that the datum side is shown.
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.
Right click on the 'Front' 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' and 'Front (2)' to 'Front RH'.
Note that the worksheet name is case insensitive, and can have a space between the 'Front' and the 'LH'. A worksheet name has a maximum of 31 characters.
Similarly, copy the 'Rear' worksheet and rename the two sheets to 'Rear LH' and 'Rear RH'.
In the Calc2Excel tool, click on the worksheet refresh button so that it can
update with the new worksheet names.
Check that each worksheet combobox references the correct worksheet.
Back to SusProg3D and change to [Front].
Go to Roll&Bump and do a Roll&Bump Calc.
Calc2Excel will make each of the Front worksheets 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
Calc2Excel will make each of the Rear worksheets 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 Excel V16 and SusProg3D V5.106A on Windows 10 (64-bit) Nov 2020