Make Excel rules easier to understand (Oracle Policy Modeling-make your Excel rules easier to understand)

Source: Internet
Author: User

There are several ways to make Excel rules easier to understand.

Shorten a property name in an Excel workbook

You can use the Legend keyword to create an abbreviated way to reference properties in Excel. This abbreviated form can be specified as appropriate.

To specify a legend keyword, do the following:

A. In Excel, open the declaration sheet.

B. Next to the attribute type and attribute text column, add the title "Legend keyword". Click the Oracle Policy Modeling tool

The Legend Keyword caption button on the bar to set the style for this cell. Note: This column already exists in the default Excel worksheet.

Therefore, you need to perform this step only when you manually delete the legend key column at a certain stage.

C. Next to each property (in the Legend key column), specify the abbreviation attribute name. Use the Legend Keyword button on the Oracle Policy Modeling toolbar to set the style of these cells.

D. Open the Rules table sheet. You can now use the Legend keyword text as a conditional title and a conclusion title.

For example, if you have the following declaration:

You can write the following rule table:

You can also use a legend in a table that uses Boolean properties.

For example, if you have the following declaration:

You can write the following rule table:

Simplify rule table layout by merging cells

When you look at the more than one condition example below, we can see that the value of the "adult" condition cell consists of only three unique values, 1, 2, and 3.

We can choose to merge cells with the same value in this column. To merge cells in Excel, select the cells that you want to merge.

Then click the Merge and center buttons on the Excel Formatting toolbar. You may see a warning that the merge will only retain the top left

Side of the data. Click OK .

This table is equivalent to the original table, but allows us to emphasize that only three different values are used for "adults" and the rows they cover.

You can also merge the concluding cells, but be aware that this changes the rule logical structure slightly.

Change the rule table direction

Typically, when you specify a rule table, the conclusions and criteria are listed in separate columns in left-to-right order, with each set of conditions and conditions

The separate rows are listed as follows. (Note: In this example, "can be trusted" means that the Boolean attribute "user can trust".) )

You can also rotate the rules table to make rows and columns interchangeable. This effectively means that we represent the rules table in y-x direction rather than X-y direction. For this example, the rotated rule table is:

The two rule tables will generate identical rules at compile time.

========================================================

More Reading,and 中文版 is important.

I ' m Hongten

E |  [Email protected] B | Http://www.cnblogs.com/hongten

========================================================

Make Excel rules easier to understand (Oracle Policy Modeling-make your Excel rules easier to understand)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.