Cost Estimates Spreadsheet

Cost Estimate and AFE Report

The Cost Estimates spreadsheet is used to report planned costs for the operation and is located in the General section of the Cost Estimate and AFE report.

For information on using spreadsheets, see the Using Spreadsheets and Tables topic.

Special Fields and Functions

Class

Use the Class picklist to select the cost class code. By default, the Class, Code, Subcode, and Description fields are populated by this selection through a picklist multi-column update.

Quantity/Item Cost

Enter the number of items and their cost in these fields.

Cost Est Base Curr

The Cost Estimate Base Currency is calculated as follows:

Cost Est Base Curr = Quantity * Item Cost + Surcharge.

Cumulative Cost

The Cum Cost is calculated as the ∑ Cost Est Base Curr for all line items.

Copy to Event Button

The Copy to Event button updates the Authorized Cost and Last Estimated Cost fields in the Event Properties dialog with the Cum Cost value.

Note: At times the fields used to calculate a stored value in the database and the stored value itself can become out of synch. Use the and buttons located in the toolbar to update calculated fields. For more information on these buttons, see the Calculate Current Field Command and Calculate All Fields Command topics.

Attachment Support ( )

The Cost Estimate spreadsheet allows for one or more documents to be attached to a row in the spreadsheet (e.g., tender document from a vendor).

To attach a file to a row in the spreadsheet, left-click the cell in the (Attachment) row and select New.... The Attachment Properties dialog appears that allows the user to attach a document to the cost item. For more information see the Using Attachments in Spreadsheets topic.

Dual Currency Support

When Dual Currency is activated a number of fields become available in this section. For more information, see the Dual Currency Support topic.

Note: Alternate Currency calculations are recalculated when the exchange rate is changed.