Facility Rating Codes are used in the database to determine the buildings condition. The following are the Facility Rating Codes to be used on the blank spreadsheet. For further help, see an example of a completed spread sheet here.

1. Description = Brief description of the facility (user input)
   
   
2. Maintenance Levels = The Maintenance Level codes have been adopted from FSH 7309.11, 42.2-Exhibit 01-Maintenance Levels. (user input)
   
   

   I = 10

   II = 20

   III = 30

   IV = 40

   V = 50

3. Year Constructed = The year when the building was constructed (user input)
   
   
4. Years Old = (calculated) by subtracting the current year minus the year constructed
   
   
5. Building Condition (Overall) F. Minimum Suitability Standards (user input) Dilapidated = 0 Poor = 10 Fair = 20 Good = 30 Excellent = 40
   
   
6. Minimum Suitability Standards (user input) Does not meet any = -40 Partially meets = -20 Fully meets = 0 Not a dwelling = 0
   
   
7. Accessibility (user input) Does not meet = 0 Partially meets = 20 Fully meets = 40
   
   
8. Miles to main Office(user input)
   
   
9. Miles to main Office score = Miles to main office/30 miles = +score(calculated)
   
   
10. $'s to bring to Standard (user input) $15k = lead base paint $5k = exhaust system $5k = bedroom or bath remodel $10k = kitchen or accessibility remodel or structural problems
    
    
11. $'s Standard score = $'s to bring to Standard/$3000 (calculated)
    
    
12. Standards Remarks (user input)
    
    
13. Liability Score = Standards required when rating government housing adopted from FSH 7309.11, 34.13c-Exhibit 01 -Minimum Suitability Standards for Government Furnished Housing. (user input) Bldg to Standard = 0 Moderate Risk = -3 High Risk = -5
    
    
14. Liability Remarks (user input)
    
    
15. Potential revenue days Generated (REC) (user input)
    
    
16. Potential Revenue Score ($30 per night) x (Potential Revenue Days)/$3000 (calculated)