Monday, April 16, 2012

yogi_Compute Cumulative Percentage Of Completion For Phases With Alternate Strategies

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #504    Apr 16, 2012     www.energyefficientbuild.com.

user orlando said:
sum percentage till 100% when phases are done.
hello, I have attached a sample spreadsheet, which I will use to explain what I will like to accomplish. If I have lets say four (4) phases which need to be completed, and I will like to see in a cell a percentage of completion of each phase based on the data on the row, how can this be accomplished. Will it be possible so that once one (1) phase is donde, a cell be marked with something like 25% or 1/4 etc. and when another phase is completed we the cell changes to 50% or 2/4 etc.??
https://docs.google.com/spreadsheet/ccc?key=0AlabHs3N3QIodFBpZ2UxME9WS1BXMkVyZG5BeElMckE
------------------------------------------------------------
 following is a solution to the problem