Formula for Counting Downtime Percentage (%)
Hi,
I would like request Experts help to build formula to count accumulation total downtime percentage in Row-E,sheet 2(Channel Downtime).
e.g, in cell-E2 the downtime percentage is 99.89%. By right in cell-E3, it should maintain with 99.89% because no downtime was captured in week-2, same situation in week-3, the percentage in cell-E4 should remain unchanged because of no downtime captured in week-3, but in week-4 the percentage should minus with downtime (D5) and this counting will continue until week-53.
Hope Experts can help me to create this formula in row-E,sheet-2. I've attached the xls for your perusal.
Copy-of-Channel-Daily-Report-Mas.xls
I would like request Experts help to build formula to count accumulation total downtime percentage in Row-E,sheet 2(Channel Downtime).
e.g, in cell-E2 the downtime percentage is 99.89%. By right in cell-E3, it should maintain with 99.89% because no downtime was captured in week-2, same situation in week-3, the percentage in cell-E4 should remain unchanged because of no downtime captured in week-3, but in week-4 the percentage should minus with downtime (D5) and this counting will continue until week-53.
Hope Experts can help me to create this formula in row-E,sheet-2. I've attached the xls for your perusal.
Copy-of-Channel-Daily-Report-Mas.xls
>it should maintain with 99.89% because no downtime was captured in week-2
That is not correct. The percentage will improve (move higher) as you accumulate additional weeks without downtime.
Kevin
That is not correct. The percentage will improve (move higher) as you accumulate additional weeks without downtime.
Kevin
I see what you are doing. You are looking at downtime for the year when you only have one week of data. That is not a correct interpretation. You can't assume that you are going to have no down time the rest of the year starting week 2. You have to work with what you have at that time. If you only have one week of data then you have to calculate based on one week, not 52.
Kevin
Kevin
What you can do, but I don't recommend it because it gives a false sense of overly positive results, is to include a second column of annualized results. See attached. But, again, you are fooling the reader with assumptions that you have no idea are true or false.
Kevin
Copy-of-Copy-of-Channel-Daily-Re.xls
Kevin
Copy-of-Copy-of-Channel-Daily-Re.xls
ASKER
Hi Zorvek,
You're right Zorver, I'm prefer using your annualized column. One more, is there any possibilities to show annualized percentage value only when we update the data in row-D. E.g. The % appeared from cell E2 to E5, but it shouldn't show the % value in E-6 because we haven't any data in D-6.
Because my intention is to show this result in Line Chart. If you have better idea please do share with me.
You're right Zorver, I'm prefer using your annualized column. One more, is there any possibilities to show annualized percentage value only when we update the data in row-D. E.g. The % appeared from cell E2 to E5, but it shouldn't show the % value in E-6 because we haven't any data in D-6.
Because my intention is to show this result in Line Chart. If you have better idea please do share with me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks for the advice and I'm stick with your approach.
Thanks for the advice and I'm stick with your approach.
=((ROW()-1)*24*60-SUM(D$2:
Kevin