Spreadsheet: 841524d1693710546-placing-text-in-a-cell-from-another-sheet-vlookup-test
Sheet: Sheet2

Grade | Condition | Description | Response | Residual Life (ie Estimated  % Asset Design Life Remaining)
0 | Not Rated | Asset has been properly decommissioned, no longer exists (or should be removed from inaccurate plans), has not been condition rated (or assigned an extrapolated condition), or is unable to be rated due to serviceability issues. | Response will vary subject to circumstances. [NAME] abandoned asset may experience infiltration, voids, collapse etc, and pose a real danger that should be both monitored and managed. | NA
1 | Very Good | Structural: Sound physical condition. Insignificant deterioration. Asset likely to perform adequately without major work for 25 years or more. Serviceability: No or insignificant loss of hydraulic capacity. | No immediate action required. Maintain standard programmed condition assessment. | 60% to 100%
2 | Good | Structural: Acceptable physical condition; minor deterioration I minor defects evident.  Serviceability: Minor loss of hydraulic performance. Negligible short-term failure risk but potential for deterioration in long-term (20 years plus). Only minor work required (if any). | No immediate action required other than possible cleaning. Maintain standard programmed condition assessment. | 35% to 60%
3 | Fair | Structural: Moderate to significant deterioration evident; Minor components or isolated sections of the asset need replacement or repair now but not affecting short term structural integrity. Serviceability: Moderate loss of hydraulic performance but asset still functions safely at adequate level of service. Failure unlikely within next 10 years but further deterioration likely and major replacement likely within next 10 to 20 years.  Work required but asset is still serviceable. | Take action as appropriate to address defects and if necessary, cleaning, silt removal, root cutting. Monitor with programmed condition assessment for rehabilitation and / or renewal in medium term. | 20% to 35%
4 | Poor | Structural: Serious deterioration and significant defects evident affecting structural integrity.  Serviceability: Significant loss of hydraulic performance. Substantial work required in short-term to keep asset serviceable. Failure likely in short to medium term. Likely need to replace most or all of asset within 10 years.  No immediate risk to health or safety but works required within 10 years to ensure asset remains safe. | Take immediate action as appropriate to address the defects. Immediately undertake risk assessment and further investigate options. Schedule appropriate action - rehabilitation or renewal in short term. | 10% to 20%
5 | Very Poor | Structural: Failed or failure imminent. Immediate need to replace most or all of asset. Serviceability: Health and safety hazards exist which present a possible risk to public safety, or asset cannot be serviced / operated without risk to personnel. Major work or replacement required urgently. | Take immediate action as appropriate to address the defects. Immediately undertake risk assessment and further investigate options. Schedule appropriate action - immediate rehabilitation or renewal. | 0 to 10%
 | Service
 | 1 | No or insignificant loss of hydraulic performance has occurred. Appears to be in good condition. | No immediate action required— Standard programmed condition assessment
 | 2 | Minor defects are present causing minor loss of hydraulic performance | No immediate action required— Standard programmed condition assessment
 | 3 | Developed defects are present causing moderate loss of hydraulic performance but asset still functions safely at adequate level of service | Take immediate action as appropriate to the defect e.g. cleaning, root cutting, point repair Monitor with programmed condition assessment for rehabilitation and/or renewal in medium term
 | 4 | Significant defects are present causing serious loss of hydraulic performance. No immediate risk for flooding, health and safety or damage to property if weather conditions are favourable. | Take immediate action as appropriate to the defect e.g. root cutting, point repairs, vermin treatment. Immediately undertake risk assessment and further investigate as required.  As appropriate to outcomes of above, schedule appropriate action which may include rehabilitation and/or renewal in the short term
 | 5 | Failure of the stormwater drain has occurred or is imminent. Potential for significant flooding, property damage, and/or health and safety hazards exist | Take immediate action as appropriate e.g. temporary support and/or removal of blockages. Immediately undertake risk assessment and further investigation, and, as necessary, take appropriate action which may include immediate rehabilitation and/or renewal
 | Structural
 | 1 | Insignificant deterioration of the stormwater drain has occurred. Appears to be in good condition | No immediate action required— Standard programmed condition assessment
 | 2 | Minor deterioration of the  stormwater drain has occurred. Minor defects are present | No immediate action required— Standard programmed condition assessment
 | 3 | Moderate deterioration of the  stormwater drain has occurred. Developed defects are present but not affecting short term structural integrity | Monitor with programmed condition assessment for rehabilitation and/or renewal in medium term
 | 4 | Serious deterioration of the  stormwater drain has occurred. Significant defects are present affecting structural integrity | Take immediate action as appropriate to the defects e.g. temporary supports Immediately undertake risk assessment and further investigate as required.  As appropriate to outcomes of above, schedule appropraite action which may include rehabilitation and/or renewal in the short term
 | 5 | Failure of the s stormwater drain has occurred or is imminent | Take immediate action as appropriate  Immediately undertake risk assessment and further investigation, and, as necessary, take appropriate action which may include immediate rehabilitation and/or renewal