Primavera p6 user defined fields formula
Step 1. The technique for calculating ETC is established at the Work Breakdown Structure (WBS). This Primavera P6 training tutorial illustrates the various methods for calculating ETC to forecast the performance of the project at completion. The formula is TCPI = (BAC – EV ) / (EAC – AC). Remaining money is calculated as Estimate at Completion (EAC) minus the Actual Cost (AC). Work remaining is calculated as the Budget at Completion (BAC) minus the Earned Value (EV). This is accomplished by calculating how much work is remaining on the project divided by how much money is remaining for the project.
PF = 1/ (CPI)* (Budget at Completion – Earned Value Cost)
#Primavera p6 user defined fields formula install
However you have to do it right after install software. Base Currency stored in the Database cannot be changed once live data is in the database. You can change Base Currency to another one beside USD.Simply Add a new currency, Exchange Rate and display that currency.įor example I will display in Indian Rupee Simply Go to menu Edit -> User Preferences. When you need to display in USD, it is possible. The 1000 RM is stored to database in 226 USD So when you define labor price is 10 RM/h, in fact Primavera store 10 / 4.43 = 2.26 USD to database. The data is stored in database in Base Currency which is USD. Now project is displayed in Malaysia Ringgit
Create a new resource and enter Price : 10 RM/h We will create a labor resource and define his salary in MYR. Now we will change to display currency in MYR. To create new currency, we go to menu Admin -> Currencies.Ĭlick Add and enter information like below: This project will use Malaysia Ringgit (MYR).
The module supports work breakdown structures (WBS), organizational breakdown structures (OBS), user-defined fields and codes, critical-path-method (CPM) scheduling, and resource leveling.
#Primavera p6 user defined fields formula how to
I will show you how to create new currency and using it for the new project. This blog is a help for those who would like to take the exams: Primavera P6 Enterprise Project Portfolio Management 8 Essentials 1Z0-567 or Primavera P6 Enterprise Project Portfolio Management Essentials (1Z0-535). P6 Professional can stand alone for project and resource management, and it enables your organization to store and manage its projects in a central location. Sometimes we work in a project which use a different currency other than US dollar.