Spreadsheet: 768812d1645131543-conditional-formatting-book1
Sheet: Sheet1

 |  |  | Type of Roof and
SPS # | SPS Name | SPS Address | Year Installed | Paint    2014 | Paint    2015 | Paint    2016 | Paint    2017 | Paint    2018 | Paint    2019 | Paint    2020 | Paint    2021 | Paint    2022 | Paint    2023 | Paint    2024 | Paint    2025 | Paint    2026 | Paint    2027 | Paint    2028 | Paint    2029 | Paint    2030 | Paint    2031 | Paint    2032 | Paint    2033 | Paint    2034 | Paint    2035 | Paint    2036 | Paint    2037 | Paint    2038 | Paint    2039 | Paint    2040 | Date Inspected | Work Orders placed | Projects
100 | 83Rd Street | 8312 Atlantic Ave. | ASPHALT | X | X | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
101 | 71ST Street | 7124 Atlantic Ave. | ASPHALT | X | X | X |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
102 | 59TH Street | 5900 Atlantic Ave. | ASPHALT | X | X | X |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
103 | 48TH Street | 4802 Atlantic Ave. | ASPHALT | X | X | X |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
104 | [NAME] | 1036 Bobolink Dr. | ASPHALT |  | X |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00 | Landscape - tree branches to be cut
105 | [NAME] | 928 Boblink Dr. | ASPHALT -2014 | X |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00 | BM- [NAME] cap Repair
106 | [NAME] | 830 Boblink Dr. | ASPHALT-2013 |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
107 | [NAME] | 608 Oriole Dr. | ASPHALT -20'20 |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00 | BM-Repair door | [NAME] on 2/24/21
108 | Chanticleer | 1486 [NAME] | ASPHALT -20'20 |  |  | X |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00 | BM-Roof Repair | [NAME] on 12/04/20
109 | [NAME] | 605 [NAME] Dr. | ASPHALT | X |  |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
110 | [NAME] | 1275 [NAME]. | ASPHALT |  | X |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00 | BM-vent / wall repair
111 | 24TH Street | 809 24th. Street | ASPHALT |  |  | X |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00 | BM-Roof Repair
112 | Atlantic Park | 1377 Old Va Beach Rd. | ASPHALT-2008 | X |  |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
113 | Seatack School | 417 Integrity Way | ASPHALT | X |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
114 | Arts & Conference | 1064 19th Street | ASPHALT | X |  |  | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00
115 | Seatack Loretta | 1129 [NAME] | ASPHALT-2014 | X |  | X | X |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-27 00:00:00