The requirement which falls under the below-mentioned criteria are considered to calculate the total requirement cost
Requirement uniformat should be: A / B / C / D / E / F / H
Requirement status should be: Open/In plan/In project
Requirement priority should be: 1 / 2 / 3 / 4 / 5
Requirement action year should be: less than or equal to current year + 1
Asset CRV: Total of All System CRV.
Here is a step by step guide:
To calculate the FCI of an asset please follow the steps below:
Step 1: Create the "FCI Query"
Step 2: Hit next, choose the asset you would like to calculate the FCI for
Step 3: Hit next, then click on Download Report (In case the report doesn't download, make sure you enable Pop-Up blockers from the top right corner of the browser)
Step 4: Open FCI Query and delete the first 2 rows.
Step 5: Click on a cell below the Requirement Cost's last cell with a value, and then click on AutoSum
Step 6: Create the "CRV Query"
Step 7: Hit next and choose the asset you chose in step 2
Step 8: Copy the value of the Asset Current Replacement Value from the list obtained
Step 9: Paste that value underneath the AutoSum value obtained in Step 5
Step 10: Click on a cell underneath and write the following equation "=(click on AutoSum cell)/(click on cell with CRV value)" then hit Enter
