The Cost Analysis worksheet uses Pivot tables to display your data. The Cost Analysis worksheet is accessed through its tab.
The Cost Analysis worksheet uses Pivot tables to display your data. The Cost Analysis worksheet is accessed through its tab.
Every BFA workbook is associated with an internal snapshot of all approved financial information for your project. Each snapshot includes: Original Budget EAC Forecast Change Orders and CCOs Commitments Pay
“Drill-down” for more information is available on certain columns of the Data worksheet. To drill down to additional information, right-click on a cell in one of the following columns: Column Opens
The Project/Selection Analysis form consolidates and presents, in a period-based format, the amounts for the selected Cost Code or Account Category for the project. To open the Project/Selection Analysis form:
The Data worksheet provides Cost Code and Account Category information, and the Division Totals worksheet consolidates Cost Codes to provide the next level of information. A further level of consolidation
If Alerts are turned on, a colored circle in the Cost Code column indicates when an Account Category or Cost Code row has reached a trigger point. Trigger points are
Filters limit the data displayed in the Data worksheet to only those rows matching the filter criteria. Combined Filter/Sorts are possible by first creating a filtered set, then applying the
Sort options can be selected form the Spitfire menu. A Sort arranges the Cost Codes in order, based on the order selected. Compounded Filter/Sorts are possible by first creating a
You may need to changed the settings on your BFA workbook in order to see the unit-related columns The BFA workbook offers the following unit-related columns: Unit of Measure Original
For each column you want displayed, make sure the location is greater than zero. Change the location number to change the order of columns. For each column, select Y if