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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Obviously: +
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Based on the valuse we update in Original Estimate; Remaining Estimate;Time Spent how the Σ Progress been computed?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What product are you referring to?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.