Spreadsheet: 852330d1702396766-formula-quit-working-sample
Sheet: Sheet1

ROOM | NAME |  |  | MCD CERT Y/N |  |  | ROOM | NAME |  |  | MCD CERT Y/N |  |  | ROOM | NAME |  |  | MCD CERT Y/N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A-WALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B-WINDOW
101A | MEDICAID |  |  | Y |  |  | 208A | MEDICAID |  |  | Y |  |  | 505A | MEDICAID |  |  | Y |  |  | 301-304 |  | HALL 2
101B | MEDICAID |  |  | Y |  |  | 208B | MEDICAID |  |  | Y |  |  | 505B | MEDICAID |  |  | Y |  |  | 305-307 |  | HALL 1
102A | MEDICAID |  |  | Y |  |  | 209A | MEDICAID |  |  | Y |  |  | 506A | MEDICAID |  |  | Y |  |  | 308-310 |  | HALL 6
102B | MEDICAID |  |  | Y |  |  | 209B | MEDICAID |  |  | Y |  |  | 506B | MEDICAID |  |  | Y |  |  |  |  | REHAB TO HM
103A | MEDICAID |  |  | Y |  |  | 210A | MEDICAID |  |  | Y |  |  | 509A | MEDICAID |  |  | Y |  |  |  |  | IN HOSPITAL
103B | MEDICAID |  |  | Y |  |  | 210B | MEDICAID |  |  | Y |  |  | 509B | MEDICAID |  |  | Y |  |  |  |  | TEMP MOVE
104A | MEDICAID |  |  | Y |  |  | 211A | MEDICAID |  |  | Y |  |  | 510A | MEDICAID |  |  | Y |  |  | Total # dual certified beds
104B | MEDICAID |  |  | Y |  |  | 211B | MEDICAID |  |  | Y |  |  | 510B | MEDICAID |  |  | Y |  |  | Avail DCB
105A | MEDICAID |  |  | Y |  |  | 212A | MEDICAID |  |  | Y |  |  | 511A | MEDICAID |  |  | Y
105B | MEDICAID |  |  | Y |  |  | 212B | MCR/PRIVATE |  |  |  |  |  | 511B | MEDICAID |  |  | Y |  |  | VIDOR HEALTH AND REHAB
106A | MEDICAID |  |  | Y |  |  | 213A | MEDICAID |  |  | Y |  |  | 512A | MEDICAID |  |  | Y
106B | MEDICAID |  |  | Y |  |  | 213B | MEDICAID |  |  | Y |  |  | 512B | MEDICAID |  |  | Y
107A | MEDICAID |  |  | Y |  |  | 214A | MEDICAID |  |  | Y |  |  | 601A | MEDICAID |  |  | Y
107B | MEDICAID |  |  | Y |  |  | 214B | MEDICAID |  |  | Y |  |  | 601B | MEDICAID |  |  | Y
108A | MEDICAID |  |  | Y |  |  | 301A | MCR/PRIVATE |  |  |  |  |  | 602A | MEDICAID |  |  | Y
108B | MEDICAID |  |  | Y |  |  | 301B | MEDICAID |  |  | Y |  |  | 602B | MEDICAID |  |  | Y
109A | MEDICAID |  |  | Y |  |  | 303A | MCR/PRIVATE |  |  |  |  |  | 603A | MEDICAID |  |  | Y
109B | MEDICAID |  |  | Y |  |  | 303B | MEDICAID |  |  | Y |  |  | 603B | MEDICAID |  |  | Y
110A | MEDICAID |  |  | Y |  |  | 304A | MCR/PRIVATE |  |  |  |  |  | 604A | MEDICAID |  |  | Y
110B | MEDICAID |  |  | Y |  |  | 304B | MCR/PRIVATE |  |  |  |  |  | 604B | MEDICAID |  |  | Y
111A | MEDICAID |  |  | Y |  |  | 305A | MCR/PRIVATE |  |  |  |  |  | 605A | MEDICAID |  |  | Y
111B | MEDICAID |  |  | Y |  |  | 305B | MCR/PRIVATE |  |  |  |  |  | 605B | MEDICAID |  |  | Y
112A | MEDICAID |  |  | Y |  |  | 306A | MCR/PRIVATE |  |  |  |  |  | 606A | MEDICAID |  |  | Y
112B | MEDICAID |  |  | Y |  |  | 306B | MCR/PRIVATE |  |  |  |  |  | 606B | MEDICAID |  |  | Y
113A | MEDICAID |  |  | Y |  |  | 307A | MCR/PRIVATE |  |  |  |  |  | 607A | MEDICAID |  |  | Y
113B | MEDICAID |  |  | Y |  |  | 307B | MCR/PRIVATE |  |  |  |  |  | 607B | MEDICAID |  |  | Y
201A | MEDICAID |  |  | Y |  |  | 308A | MCR/PRIVATE |  |  |  |  |  | 608A | MEDICAID |  |  | Y
201B | MEDICAID |  |  | Y |  |  | 308B | MCR/PRIVATE |  |  |  |  |  | 608B | MEDICAID |  |  | Y
202A | MEDICAID |  |  | Y |  |  | 309A | MCR/PRIVATE |  |  |  |  |  | 609A | MEDICAID |  |  | Y
202B | MEDICAID |  |  | Y |  |  | 309B | MCR/PRIVATE |  |  |  |  |  | 609B | MEDICAID |  |  | Y
203A | MEDICAID |  |  | Y |  |  | 310A | MEDICAID |  |  | Y |  |  | 610A | MEDICAID |  |  | Y
203B | MEDICAID |  |  | Y |  |  | 310B | MCR/PRIVATE |  |  |  |  |  | 610B | MEDICAID |  |  | Y
204A | MEDICAID |  |  | Y |  |  | 501A | MEDICAID |  |  | Y |  |  | 611A | MEDICAID |  |  | Y
204B | MEDICAID |  |  | Y |  |  | 501B | MEDICAID |  |  | Y |  |  | 611B | MEDICAID |  |  | Y
205A | MEDICAID |  |  | Y |  |  | 502A | MEDICAID |  |  | Y |  |  | 612A | MEDICAID |  |  | Y
205B | MEDICAID |  |  | Y |  |  | 502B | MEDICAID |  |  | Y |  |  | 612B | MEDICAID |  |  | Y
206A | STORAGE |  |  |  |  |  | 503A | MEDICAID |  |  | Y |  |  | 613A | MEDICAID |  |  | Y
206B | STORAGE |  |  |  |  |  | 503B | MEDICAID |  |  | Y |  |  | 613B | MEDICAID |  |  | Y
207A | MEDICAID |  |  | Y |  |  | 504A | MEDICAID |  |  | Y
207B | MEDICAID |  |  | Y |  |  | 504B | MEDICAID |  |  | Y