Hi everybody
if I have asset database based on asset age (overall life, current age, remaining life)
is there a professional way to convert this lives to condition rating from 1 to 5
say if kerb has 60 year overall life and its remaining life is 40 that means it is condition 2
I assume I have to prepare a table in another sheet for conditions, so if remaining life/whole life > 0.8 -------> condition 1 (Excellent)
<0.8 and >0.6------>condition 2
<0.6 and > 0.4 ---------->condition 3
<0.4 and >0.2 ------>condition 4
<0.2 ------> condition 5 (Very Poor)
and then have a lookup, but how would I get a range value? what formula used so that if the percentage between 0.8 and 0.6, the result is condition 2?
that is my initial thought but if someone has better way please pass it to me. thanks
Bookmarks