LinkBack URL
About LinkBacks
You need to organize your table.
Would be this close enough?
However, I don't get your result...
Book1.xls
How did you get 70/((20*40%)+(30*19%)+(20*20%))= 0.253.?
I assume you need (), but even then result is 70/17,7=3,95480226 as in example
You need to organize your table.
Would be this close enough?
However, I don't get your result...
Book1.xls
How did you get 70/((20*40%)+(30*19%)+(20*20%))= 0.253.?
I assume you need (), but even then result is 70/17,7=3,95480226 as in example
Last edited by zbor; 09-01-2009 at 09:27 AM.
Never use Merged Cells in Excel
Thanks for the reply, I don't know where I got the .253 from but it was on my spreadsheet before I erased the calculation, doh.
I shall try your calc unfortunately I cannot rearrange the sheet as I have week1 to week52 and I have planned hours, actual hours and then the estimate for the percentage complete for each week.
Yes the actual divided by planned gives me % complete but some tasks are easy compared to others and the hours do not necessarily reflect the complexity of the task. Estimating % complete is easier than adding in fudge factors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks