Spreadsheet: 221470d1363567574-drawing-data-from-rows-into-columns-report-and-raw-results-sample
Sheet: Sheet1

 |  |  | Comments | Total Estimated COST | COST URGENCY |  | EXTERIORS | Grading | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency |  | Ponds/Swales | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Storm Sewer System | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Retaining Walls | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Landscaping | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Tree Trimming | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Other | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Asphalt Paving | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Curbs & Gutters | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Wheel Stops | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Striping | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | ADA Compliance | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Other | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Domestic Water | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Sanitary Sewer | Picture | Comments | Total Estimated Cost | Sketch | Voice Note | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Lift Stations/Treatment Plants | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Irrigation | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Lighting | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Other | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Wood Walls | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Concrete/Masonry Walls | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Sidewalks | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Fencing | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Swimming Pool | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | [NAME] | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Signage | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Other | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture (1) | Comments (1) | Sketch (1) | Voice Note (1) | Total Estimated Cost (1) | Cost Urgency (1) | Picture (2) | Comments (2) | Sketch (2) | Voice Note (2) | Total Estimated Cost (2) | Cost Urgency (2) | Take-off? | Area of Take-off (1) | Picture (1) | Comments (1) | Units (1) | Other Unit (1) | Qty (1) | Unit Cost (if known) (1) | Total Estimated Cost (1) | Cost Urgency (1) | Area of Take-off (2) | Picture (2) | Comments (2) | Units (2) | Other Unit (2) | Qty (2) | Unit Cost (if known) (2) | Total Estimated Cost (2) | Cost Urgency (2) | Signature | Qty (1) | Unit Cost (if known) (1) | Total Estimated Cost (1) | Cost Urgency (1) | Area of Take-off (2) | Picture (2) | Comments (2) | Units (2) | Other Unit (2) | Qty (2) | Unit Cost (if known) (2) | Total Estimated Cost (2) | Cost Urgency (2) | Area of Take-off (3) | Picture (3) | Comments (3) | Units (3) | Other Unit (3) | Qty (3) | Unit Cost (if known) (3) | Total Estimated Cost (3) | Cost Urgency (3) | Signature
EXTERIORS | SITE | Grading |  |  |  |  | EXTERIORS | Repair |  |  |  |  | http:/picturlink | Grading Comment 1 | 1254 | Reserve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http:/picturlink | Comment Ponds 1 | 6632 | Immediate |  | http:/picturlink |  | 9999 |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair |  |  |  |  |  | kdljhweke | 3333 | Reserve / Future |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> |  |  |  |  |  |  |  |  |  |  | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> |  | 0 | 0 | 8899 | Immediate |  |  |  |  |  | 0 | 0 | 0 |  | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin>
EXTERIORS | SITE | Storm Sewer System
EXTERIORS | SITE | Retaining Walls |  |  |  |  | INTERIORS | Water Heaters | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency |  | Air Handlers | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Condensing Units | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Duct Work | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Controls | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Exhaust Fans | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Common Corridors | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Common Area Flooring | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Common Area Walls / Ceilings | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Common Area Lighting | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Common Area FF&E | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Common Area Interior Doors | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Other | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | [NAME] | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | [NAME] | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | [NAME] | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | [NAME] | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Lobby Interior Doors | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Other | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture | Comments | Total Estimated Cost | Cost Urgency | Picture (1) | Comments (1) | Sketch (1) | Voice Note (1) | Total Estimated Cost (1) | Cost Urgency (1) | Picture (2) | Comments (2) | Sketch (2) | Voice Note (2) | Total Estimated Cost (2) | Cost Urgency (2) | Take-off? | Area of Take-off (1) | Picture (1) | Comments (1) | Units (1) | Other Unit (1) | Qty (1) | Unit Cost (if known) (1) | Total Estimated Cost (1) | Area of Take-off (2) | Picture (2) | Comments (2) | Units (2) | Other Unit (2) | Qty (2) | Unit Cost (if known) (2) | Total Estimated Cost (2) | Cost Urgency | Signature
EXTERIORS | SITE | Ponds/Swales |  |  |  |  | INTERIORS | REPLACE |  | WH comments | 654 | Immediate |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair |  |  |  |  |  | Common area air handlers were not running. Maint said they were shut down because of the warmer temperatures. Due to the age 12 years its recommended to carry a budget of 5000 per year for repairs. Recommend replacement in 5 to 7 years | 5000 | Reserve / Future |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair |  |  |  |  |  | Noticed several barroom exhaust fans were not working replace motors | 1000 | Immediate |  |  |  |  |  |  |  |  | Repair |  |  |  |  |  | Budget to upgrade common areas in years in 3 to 5 years | 350000 | Reserve / Future |  |  |  |  |  |  |  |  | REPLACE |  |  |  |  |  |  |  |  |  | Budget to upgrade commmon area flooring in 3 to 5 years Reserve / Future | 300000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Create Resident Storage in basement FS to verify pricing and feasibility with architect |  |  | 50000 |  | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> |  |  |  |  |  |  |  |  |  | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin> | <fin>
EXTERIORS | SITE | Landscaping
EXTERIORS | SITE | Tree Trimming
EXTERIORS | SITE PAVING | Asphalt Paving
EXTERIORS | SITE PAVING | Curbs & Gutters
EXTERIORS | SITE PAVING | Wheel Stops
INTERIORS | COMMON | ADA Compliance
INTERIORS | COMMON | Flooring
INTERIORS | COMMON | Entry Doors
INTERIORS | COMMON | Water Heaters
INTERIORS | COMMON | Air Handlers
INTERIORS | COMMON | Condensing Units
INTERIORS | COMMON | Duct Work
INTERIORS | COMMON | Controls
INTERIORS | COMMON | Exhaust Fans
INTERIORS | COMMON | Common Corridors
INTERIORS | COMMON | Common Area Flooring
INTERIORS | COMMON | Common Area Walls / Ceilings
INTERIORS | COMMON | Common Area FF&E
INTERIORS | COMMON | Common Area Interior Doors
INTERIORS | COMMON | Other