Setting Your BFA PreferencesSetting Your BFA Preferences

You set your BFA preferences on the Setup worksheet. The primary function of the Setup worksheet is to configure the Data worksheet of the BFA workbook to present the available

BFA Workbook SettingsBFA Workbook Settings

You can see which settings are in use by selecting About Spitfire from the Spitfire menu in the BFA workbook. Note: The ability to see revenue columns/data requires proper permission

Changing BFA Workbook Local SettingsChanging BFA Workbook Local Settings

You indicate your BFA preferences and settings on the Setup worksheet. However, the parts of the Setup worksheet you use depends on if you are changing local settings or site

Changing BFA Workbook Column HeadingsChanging BFA Workbook Column Headings

Spitfire- or Site-recommended column descriptions fill the Recommended Column Headings (shown below in green). These descriptions also fill the Your Column Headings cells (shown in yellow) until you make changes.

BFA Workbook – Other Global SettingsBFA Workbook – Other Global Settings

Other Global Settings affect all modes of the BFA workbook. Division Subtotals The Division Totals worksheet is created when you select the Division Totals command on the Spitfire menu. You

BFA Workbook – Other Global Settings continuedBFA Workbook – Other Global Settings continued

Filter and Sort Descriptions Like Column headings, Filter and Sort descriptions may be edited. Your edits will appear in the Filter and Sort drop-down menus in the Filter and Sort

Changing BFA Workbook Site SettingsChanging BFA Workbook Site Settings

System Administrators (and anyone with PART | Can Customize BFA Settings (RS) role capability) can set site-specific settings for the BFA workbook that are then used instead of Spitfire defaults.

Changing BFA Workbook Site Settings continuedChanging BFA Workbook Site Settings continued

To indicate a code for a User Calc Field column: Scroll to a User Calc Field column. On row 67, select a code from the drop-down to indicate how you

BFA Workbook – Data Worksheet ColumnsBFA Workbook – Data Worksheet Columns

Note: Depending on the choices on the Setup worksheet, some of these columns may not be visible. In addition, they may not be reordered or renamed at your site. Data

BFA Supplemental WorkbooksBFA Supplemental Workbooks

BFA Report Supplemental Workbook The BFA Report template is created through the BFA Report Tool to organize the data from the BFA workbook in custom ways in order to produce