Creating Attributes

Attributes form the rows in any ClearFactr Plan, and their abbreviations are what enable the Self-Describing Spreadsheet to work. So the first step after creating a new plan is to add some attributes to it. To add an attribute, simply double-click one of the rows in the “Plan Attribute” section and start typing an attribute name:

null

The abbreviations for your attributes are generated automatically, but if you want to edit them manually you can toggle the abbreviations section from the “View” menu:

null

You can further customize the settings for an attribute by right-clicking on the attribute name, going to “Row/Attribute” and selecting “Rename/Format”:

null

This will bring up the Attribute Editor window, which allows you to change the name, auto abbreviation style, abbreviation name, and number format. The Number Format selector lets you control how values for that attribute are displayed in the grid, such as number of decimal places, or if you want it displayed as a percent.

null

Here are some notes per field:

ItemDescription
Attribute NameThe name of the attribute, which will become the header for its row in your Plan. Attribute Names have no restrictions, but their length will affect the legibility of formulas in Natural Language mode. Also, be careful when embedding symbols like ‘+’ or % that could lead to confusion with formula legibility.
Auto AbbrevThis selector allows you to choose one of several schemes for automatically generating abbreviations from your attribute names. The behaviors of each of the choices are described below.
AbbreviationEvery attribute name requires a unique abbreviation, which is used within formulas. You can allow the Auto Abbrev setting to generate these for you, or you can type them in yourself (overriding whatever Auto Abbrev creates). There are some rules:
They must be unique within their Tab
They cannot contain space characters
They are case sensitive, and contain letters A..Z, a..z, the underbar character and the digits 0..9
They cannot start with a digit

Auto Abbrev Schemes

Auto Abbrev will automatically convert the text of your attribute name to an abbreviation. Depending on your attribute name and abbreviation scheme, the result can be perfectly acceptable, or perfectly cryptic. In the latter case, you’ll probably want to type something in yourself.

Let’s go through an example, based on the attribute name “Total Profit”:

Auto Abbrev SchemeResulting Abbreviation
CamelBacktotalProfit
CamelBack Without VowelsttlPrft
All Upper CaseTOTALPROFIT
All Lower Casetotalprofit
Spaces To Underbarstotal_profit
None*Requires your intervention*