The CustomScaleCodelist.xls workbook provides an example format for adding drawing custom attributes, such as custom scales used in the codelists. This workbook is delivered in the [Product Folder]\CatalogData\BulkLoad\SampleDataFiles folder.
The following example shows the DrawingUserSelectedScales worksheet. The values in red are delivered in the software, while the blue values are custom values that are useful for Drawings and Reports users. To add values, type A in the first column. To modify values in the codelist, type M in the first column. To delete the values from the codelist, type D in the first column.
When adding a new scale value, a Codelist Number value is required. The new scale will be added to the end of the codelist regardless
of the Codelist Number value.
DrawingUserSelectedScales ShortDescription
-
This value must be unique in the spreadsheet.
-
1000- is the prefix for all English units (as defined in row 11 on the previous figure). 2000- is the prefix for all Metric units (as defined in row 38 on the previous figure). 3000- is the prefix for all Architectural units.
-
The value following the prefix is equal to the fraction. For example, 1/240 = 0.004166667.
-
You can leave off the prefix if the value is already unique in the spreadsheet. For example, the prefix is not required in row 12 because 40 is a unique value. If you use 40 anywhere else in the spreadsheet, the prefix is required.
DrawingUserSelectedScales LongDescription
-
The software displays this value in the User Selected Scale box in drawing properties.
-
This value must be the actual scale.
-
You must use a decimal point (.) as the decimal separator.
Codelist Number
This must be a unique number that falls between the prefix numbers. For example, all English scales must use a number between 1000 and 2000.
After modifying the Excel file, save your changes, and exit Excel.
For information on creating custom drawing properties for use in drawings, see Place a Custom Drawing Property Label on a Template in the Orthographic Drawings User's Guide.