Using worksheets
Worksheets provide quick access to a group of properties, enabling you to easily maintain all of a model's properties in one place.
A worksheet is a table that assigns property values to option items:
- Rows represent option items
- Columns represent properties
Each worksheet belongs to a model and can be used
to set the values of properties of that model. You can still set the
values for properties as described in Attach a property.
Note: In some cases, properties
are not required for every row of a worksheet and so the corresponding
cells are empty. If a cell is empty and you do not want to assign
a property to the corresponding item, select "If no value: Do not
assign the property". If you want to assign the property, select "If
no value: Assign the property".
For example, suppose that a model of a computer has an option class for hard drives. Each hard drive option item has a number of properties such as capacity, RPM, latency, and buffer cache. You can create a worksheet to maintain the hard drive properties, similar to the following table:
| Option Item | Capacity | RPM | Latency | Buffer Cache |
|---|---|---|---|---|
| WD Protege | 160 | 5400 | 5.00 | 2 |
| WD Caviar | 250 | 7200 | 4.20 | 2 |
| WD Caviar SE | 250 | 7200 | 4.20 | 8 |
| WD Essential | 250 | 7200 | 4.20 | 2 |