Value Rank Calculator

This Azure DevOps extension automatically calculates the Value Rank field based on your custom scoring fields.

Features

• Real-time calculation: Value Rank is automatically updated as you enter values
• Custom formula support: Uses your existing Excel formula logic
• Easy to use: No manual calculation required

How it works

The extension monitors these fields and automatically calculates Value Rank:

• Effort to Implement
• PO Customer Value
• PO Efficiency/Trust
• PO Portfolio Impact
• PO Service Growth
• Override

Formula

Value Rank = IF(Override=1, 10 + base_value, base_value)
where base_value = sum of (field_value * weight) for all scoring fields

Installation

After installing this extension, the Value Rank field will automatically update when you modify any of the input fields in your work items.