+ Reply to Thread
Results 1 to 2 of 2

get condition rating based on age

  1. #1
    Registered User
    Join Date
    07-15-2015
    Location
    australia
    MS-Off Ver
    2010
    Posts
    11

    get condition rating based on age

    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

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: get condition rating based on age

    Try something like this...
    A
    B
    C
    D
    1
    Age Condition
    2
    0
    5
    0.2
    4
    3
    0.2
    4
    4
    0.4
    3
    5
    0.6
    2
    6
    0.8
    1

    C2=live
    D2=VLOOKUP(C2,$A$2:$B$6,2,1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula for Average rating based on Year
    By toxicsalmon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2015, 09:27 AM
  2. Data Validation - Based on Rating Table
    By ssanjju in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-10-2015, 02:32 AM
  3. [SOLVED] Calculate rating based on cut point table
    By som3on3_10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2014, 04:39 AM
  4. How can I display TEXT only based on number rating and calculations
    By audiman09 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2014, 01:09 AM
  5. [SOLVED] Rating Based on Daily Qty Purchased
    By clockspring in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2014, 03:42 PM
  6. [SOLVED] Performance Rating based on Percentages
    By tomlancaster in forum Excel General
    Replies: 3
    Last Post: 09-27-2012, 01:44 AM
  7. Overall rating based on an alphabetical score
    By OlSchool in forum Excel General
    Replies: 5
    Last Post: 06-23-2011, 10:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1