What is the formula behind the Σ Progress?

[Kumaran Veerarajan]

What is the formula behind the Σ Progress?

[Radu Dumitriu]

Effective Work (EW) = sum(time logged)

Estimated To Completion (ETC) = Time Remaining = Estimate - EW

Now, the tricky part: The estimate is either EAC (Estimate At Completion = Original Estimate) or Adjusted Estimate At Completion (EW + Remaining)

sum progress is MIN(percent of EW in Estimate, 100)

Hope I get it right.

[CelesteCS]

Hello!

For any calculations in Confluence, including any manipulations with table data, you may use CelesteCS Math for Confluence.

Assume you have a table with three columns and three rows on your page – from A1 till C3, where row 1 is the header row. The sum calculation formula for rows 2 and 3 will be simple:

SUM(Table1.A2:C3)

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.

Thanks!

[Kumaran Veerarajan]

@ Renjith V, I am using the Jira/GreenHopper

[Radu Dumitriu]

Obviously: +

[Kumaran Veerarajan]

@ Renjith V, Jira, GreenHopper

[Kumaran Veerarajan]

Based on the valuse we update in Original Estimate; Remaining Estimate;Time Spent how the Σ Progress been computed?

[Renjith Pillai]

What product are you referring to?