Support Central is currently experiencing issues displaying images. We are working on a resolution and apologize for any inconvenience caused.

×

You are here

Cost Worksheet Calculations

The Cost Columns table lists all the columns available, the calculations they use and any related information about how and why they are used.

Dedicated Change Columns Update

In May 2020 some of the Cost Worksheet columns were updated in an effort to better support your business requirements and provide more clarity on contract related change amount. The Change Event and Contract Change (Variation) amounts were separated on the Cost Worksheet and associated column calculations were updated.

Note: The US1 Aconex instance will be updated after the code freeze has been lifted.

The changes made are reflected the table below:

New Columns:

  • Potential Contract Change Events: Sum of Potential Changes from Contract Change Events not linked to a Contract Change (Variation)
  • Approved Contract Change Events: Sum of Approved Changes from Change Events not linked to a Contract Change (Variation)

Updated Calculations:

  • Potential ETC Changes: Budget ETC Changes with status assigned to Apply to Potential + ETC Change from Potential Change Event Items - ETC Drawdown amount
  • Potential Contract Changes: Sum of Potential Changes from Contract Changes (Variations). This value, previously, included Potential Changes from Change Events.
  • Potential EAC: Estimate at Completion + Potential ETC Changes + Potential Contract Change Events + Potential Contract Changes
  • Pending Contract Changes: Sum of Pending Changes from Contract Changes (Variations). This value, previously, included Approved Changes from Change Events.
  • Pending Contract Commitments: Pending Contracts + Pending Contract Changes + Approved Contract Change Events

Cost Columns table

See also Working with Cost.

ColumnCalculationNotes
Accrued PeriodSum of Accrued amounts from all Direct Actuals for the current reporting period
Accrued to DateSum of Accrued amounts from all Direct Actuals for all previous reporting periods plus the current reporting period
All Actuals to DateDirect Actuals to Date + Pending Contract Actuals + Approved Contract ActualsPending Contract Actuals are Payment Applications with a “Submitted” status
.
Approved Contract Actuals are Payment Applications with an “Approved” status.
All CommitmentsCurrent Commitments + Pending Contract Commitments
Approved BudgetBaseline Budget + Approved Budget Changes + Approved Budget TransfersApproved Budget Changes come from Budget Changes and/or Change Events.
Approved Budget Transfers come from Change Events.
Approved Budget ChangesIf Budget Changes is enabled for the Approved Budget, then Approved Budget Changes equals (Budget Change Items with a Budget Change amount when the status assigned to the parent Budget Change has been defined as “Apply") + (Change Event Items with a Budget Change amount and a status of “Approved").
If Budget Changes is not enabled for the Approved Budget, then Approved Budget Changes equals the sum of Change Event Items with a Budget Change amount and a status of “Approved".
Approved Budget Changes come from Budget Changes and/or Change Events.
Change Events is always enabled.
To enable Budget Changes for the Approved Budget, see Project Settings > Budget Changes.
Approved Budget TransfersSum of Budget Transfer amounts from all Change Event Items with a status of “Approved”
Approved ContractSum of the Approved Contract amounts from Contract Pay Items
Approved Contract ActualsSum of Accepted Amounts from Payment Application Items when the status of the parent Payment Application is “Approved”Amounts from “Draft” Payment Applications are excluded
Approved Contract ChangesSum of Change Amounts from Contract Change Items when the status of the parent Contract Change is “Approved”
Approved Contract Change EventsSum of Change Event Item amounts when the Change Event Items have a contract impacted, a status of “Approved” and are not linked to a Contract Change
At Completion VarianceApproved Budget - Estimate at Completion
Baseline BudgetManually defined or imported
Control BudgetManually defined or imported + Control Budget Changes
Control Budget ChangesIf Budget Changes is enabled for the Control Budget, then Control Budget Changes it is the sum of Budget Change Items with a Control Budget Change amount when the status assigned to the parent Budget Change has been defined as “Apply”.
If Budget Changes is not enabled for the Control Budget and the Link Control Budget to Baseline Budget setting is true, then Control Budget Changes equals Control Budget - Baseline Budget.
See Project Settings > Budget for the Link Control Budget to the Baseline Budget setting.
See Project Settings > Budget Changes to enable Budget Changes for the Control Budget.
Current CommitmentsCurrent Contracts + Direct Actuals to Date
Current ContractsApproved Contracts + Approved Contract Changes + Proceed Contracts + Proceed Contract Changes
Current Percent CompleteDepends on the Percent Complete Method defined for the Control Account (see below). Calculated at the Control Account level and rolled up to WBS level.Rollup of Current Percent Complete is the weighted average of the subordinates based on each Control Accounts’ Approved Budget contribution to the superior.
See the Appendix for the formulas, special rules and requirements for the Percent Complete methods available in Aconex Connected Cost.
Direct Actual PeriodSum of actual amounts from Direct Actuals for the current reporting period
Direct Actual to DateSum of actual amounts from Direct Actuals for all previous reporting periods and the current reporting period
EAC VariancePrevious EAC - Estimate at Completion
Earned PeriodApproved Budget for the current reporting period x Period Percent CompleteRequires the time phasing of data
Earned to DateApproved Budget to date x Current Percent CompleteRequires the time phasing of data
Estimate to Complete (ETC) and Estimate at Completion (EAC)Control Account ETC = Sum of Estimate to Complete (ETC) amounts from the assigned Control Elements.
Control Account EAC = Sum of Estimate at Completion (EAC) amounts from the assigned Control Elements.
Options may vary depending on the selected default Percent Complete Method ( Project Settings > Percent Complete)
The calculation of Estimate to Complete (ETC) and Estimate at Completion (EAC) at the Control Element level depends on the Forecast Method selected
See the Appendix for the formulas, special rules and requirements for the Forecast (ETC and EAC) methods available in Aconex Connected Cost
Incurred PeriodPeriod Direct Actuals + Accrued Period
Incurred to DateDirect Actuals to Date + Accrued to DateIncludes all previous reporting periods and the current reporting period 
Pending ContractSum of Original Contract amounts from Contract Pay Items when the parent Contract has a “Pending” status
Pending Contract ActualsSum of Requested Amounts from Payment Application Items when the parent Payment Application has a “Submitted” statusAmounts from “Draft” Payment Applications are excluded
Pending Contract ChangesSum of Change Amounts from Contract Change Items when the Cost Impact of the Contract Change is “Pending” and the status is “Preliminary” or “Submitted”
Pending Contract CommitmentsPending Contracts + Pending Contract Changes + Approved Contract Change Events
Percent Invoiced(Pending Contract Actuals + Approved Contract Actuals) / Current Contract Amount
Percent SpentAll Actuals to Date / Estimate at Completion
Potential BudgetApproved Budget + Potential Budget Changes + Potential Budget Transfers
Potential Budget Changes( Budget Change Items when the status assigned to the parent Budget Change has been defined as “Apply to Potential") + (Change Event Items with a Budget Change amount and a status of “Potential”)The rules for Budget Changes statuses are defined in Project Settings > Budget Changes. The rules for each status include the following options:
Apply - Adds the change amount to “approved” changes.
Apply to Potential - Adds the change amount to “potential” changes.
None - The change amount is not included.
Potential Budget TransfersSum of Budget Transfer amounts from Change Event Items with a status of “Potential”
Potential Contract ChangesSum of Contract Change Items when the parent Contract Change has a Cost Impact of “Potential” and the status is “Preliminary” or “Submitted”
Potential Contract Change EventsSum of Change Event Item amounts when the Change Event Items have a contract impacted, a status of “Potential” and are not linked to a Contract Change
Potential Control BudgetControl Budget + Potential Control Budget Changes
Potential Control Budget ChangesSum of all Budget Change Items with a Control Budget Change amount when the status of the Budget Change is one where it is set to "Apply to Potential"
Potential EACEstimate at Completion + Potential ETC Changes + Potential Contract Change Events + Potential Contract Changes
Potential ETC ChangesBudget ETC Changes with status assigned to “Apply to Potential” + ETC Change from Potential Change Event Items - ETC Drawdown amount“ETC Drawdown” is a setting on Contract Changes and Change Events and means that the cost of the change will be “drawn down” from the available ETC amount
Previous EACEstimate at Completion (EAC) amount from the previous reporting periodWhen a reporting period is closed, the EAC value is copied to the Previous EAC field
Previous Percent CompleteCurrent Percent Complete value from the previous reporting periodWhen a reporting period is closed, the Current Percent Complete value is copied to the Previous Percent Complete field
Proceed ContractSum of Original Contract amounts from Contract Pay Items when the parent Contract has a “Proceed” status
Proceed Contract ChangesSum of Change Amounts from Contract Change Items when the Contract Change has a “Proceed” status
Remaining to SpendEstimate at Completion (EAC) – All Actuals to Date

Percent Complete Methods

ColumnCalculationNotes
CAE: Actual to Date CostAll Actuals to Date / Estimate at Completion
CCB: Control Budget CostControl Budget to Date / Total Control BudgetRequires time phasing of cost data
CEB: Early Approved Budget CostEarly Approved Budget to Date / Total Approved BudgetRequires time phasing of cost data
CLB: Late Approved Budget CostLate Approved Budget to Date / Total Late Approved BudgetRequires time phasing of cost data
CLS: Closed100% Complete and Closed
FIN: Finished100% Complete
HAE: Actual to Date HoursAll Actuals to Date (H) / Estimate at Completion (H)
HCB: Control Budget HoursControl Budget to Date (H) / Total Control Budget (H)Control Budget to Date requires time phasing of hours data
HEB: Early Approved Budget HoursEarly Approved Budget to Date (H) / Total Approved Budget (H)Early Approved Budget to Date requires time phasing of hours data
HLB: Late Approved Budget HoursLate Approved Budget to Date (H) / Total Late Approved Budget (H)Late Approved Budget to Date requires time phasing of hours data
MAN: ManualManual Entry
QAE: Actual to Date QuantityAll Actuals to Date (Q) / Estimate at Completion (Q)If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each quantity element.
QCB: Control Budget QuantityControl Budget to Date (Q) / Total Control Budget (Q)If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each quantity element.
Requires time phasing of quantity data.
QEB: Early Approved Budget QuantityApproved Budget to Date (Q) / Total Approved Budget (Q)If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each quantity element.
Requires time phasing of quantity data.
QLB: Late Approved Budget QuantityLate Approved Budget to Date (Q) / Total Late Approved Budget (Q)If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each quantity element.
Requires time phasing of quantity data.
ROC: Rules of CreditComposite Rules of Credit Percent CompletePercent complete is documented for each rule assigned to the Control Account. If there are multiple rules assigned to the Control Account, then you will define a contribution weight for each rule.
SCH: Schedule ActivitiesComposite Schedule Activities Percent CompletePercent complete is documented for each Schedule Activity assigned to the Control Account. If there are multiple Schedule Activities assigned to the Control Account, then you will define a contribution weight for each activity.
TCF: Schedule Finish100% at Current Schedule FinishRequires schedule dates to be defined for the Control Account(s)
TCS: Schedule Start100% at Current Schedule StartRequires schedule dates to be defined for the Control Account(s)

Forecast Methods

ColumnCalculationNotes
ETC 1ETC = User controlled value + (automated system adjustments)EAC = All Commitments + ETC. System sets up the ETC and EAC from the Baseline Budget. System adjusts the ETC as commitments are processed until there is no ETC remaining. The EAC is then set to the value of the commitments
ETC 2ETC = Efficiency Factor x ( Approved Budget - Earned Value)
Efficiency Factor = 1
Efficiency Factor = 1 / CPI
Efficiency Factor = 1 / (CPI x SPI)
Efficiency Factor = [User Defined Value]
EAC = All Commitments + ETC. This method forecasts ETC based on manually provided efficiency ratios. It's like applying your own CPI. This is primarily used for Earned Value forecasting.
ETC 3ETC = Approved Budget - All CommitmentsEAC = All Commitments + ETC. This method essentially sets the EAC to the Approved Budget, calculating a negative ETC when commitments exceed budget. Use the negative ETC to determine what budget changes are required to balance budget and costs.
ETC 4ETC = Manually entered valueEAC = All Commitments + ETC. Set the ETC to whatever value you need. The EAC will fluctuate based on changes to commitments.
EAC 1EAC = User controlled value + (automated system adjustments)ETC = EAC - All Commitments. System sets up the ETC and EAC from the Baseline Budget. System holds the EAC as commitments are processed until there is no ETC remaining. The EAC is then set to the value of the commitments.
EAC 2EAC = Approved Budget / CPIETC = EAC - All Commitments. An Earned Value forecast method, using the CPI to scale up or down the forecast for the entire scope of work.
EAC 3EAC = All Actuals + ( Approved Budget - Earned to Date)ETC = EAC - All Commitments. Basic Earned Value forecast for use when CPI/ SPI are not available.
EAC 4EAC = All Actuals + ( Approved Budget - Earned to Date) / (CPI x SPI)ETC = EAC - All Commitments. Sophisticated Earned Value forecast method, applying the CPI and SPI to the remaining work to earn.
EAC 5EAC = Manually entered valueETC = EAC - All Commitments. User can simply set the EAC to whatever value required. This may result in credit forecasts, aka negative ETC. Consider using the first EAC forecast method instead.

Aconex Support Central content is updated constantly. For this reason, we don't recommend printing articles as content can become quickly out of date. If you're reading this support material on a piece of paper, please keep this in mind!

Was this article helpful?

Images not showing?

Let us know

Thanks. A ticket has been opened with the Support Central team.