This spreadsheet is used to manage the units in which the CLA database and its entities are expressed:
Seven ComboBox buttons are used to select the units for length, mass, force, etc.
The “SetDbUnits” button sets the unit system associated with the composite database, but does not change anything for the entities stored in the DB.
The “SetUnitsAllEntities” button sets the unit system of the CLA database and of all its entities (materials, laminates and loads).
The “SetUnitsAllMaterials” button sets the units of all material entities stored in the database.
The “SetUnitsAllLaminates” button sets the units of all laminate entities stored in the database.
The “SetUnitsAllLoads” button sets the units of all load entities stored in the database.
The “ChangeUnitsAllEntities” button changes the unit system of the CLA database and of all its entities (materials, laminates and loads).
The “ChangeUnitsAllMaterials” button changes the units of all material entities stored in the database.
The “ChangeUnitsAllLaminates” button changes the units of all laminate entities stored in the database.
The “ChangeUnitsAllLoads” button changes the units of all load entities stored in the database.
Remember that the difference between the “SetUnits*” and “ChangeUnits*” methods is that the second group of methods performs unit conversions between old and new units, whereas the “SetUnits*” methods modify the units associated with entities without modifying the values of the different quantities.
At present, the workbook does not allow the unit system of CLA entities to be modified individually. This could be achieved by adding a few buttons to the corresponding “MatEdit”, “LamEdit” and “LoadEdit” worksheets. We believe, however, that it is a bad idea to try to define CLA entities with different units within the same database. In fact, the number of buttons already defined in the “DbUnitsEdit” spreadsheet is probably already too large.