Spreadsheet: 54261d1254280548-if-function-example
Sheet: Sept

 | Hospital Daily Census |  |  | COLUMN KEY |  |  |  |  |  |  | PATIENT DAY KEY |  |  |  |  |  |  | FINANCIAL CLASS
 | September |  |  | FC | Financial Class |  |  |  |  |  | X | Admit Date & Other |  |  |  |  |  | 1 | SP |  |  |  | 5 | MCD |  |  |  | 9 | CHMP |  |  |  | 18 | UI
 |  |  |  | AS | Admission Service |  |  |  |  |  | D | Discharge Date |  |  |  |  |  | 2 | MCR |  |  |  | 6 | BCBS |  |  |  | 14 | INDG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | ADV |  |  |  | 7 | OTH |  |  |  | 19 | HSPC
 | Patient Name | FC | AS | Admit | Dischg | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total
1 | a;kljdfa | 2 | MD | 2009-08-30 00:00:00 | 2009-09-02 00:00:00 | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 | lkjeinf | 2 | MD | 2009-08-31 00:00:00 | 2009-09-02 00:00:00 | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
3 | ivnonavao | 2 | MD | 2009-09-03 00:00:00 | 2009-09-05 00:00:00 |  |  | X | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
4 | voinavokn | 2 | MD | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 |  |  |  |  |  |  |  | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
5 | kdmavslk | 2 | MD | 2009-09-09 00:00:00 | 2009-09-13 00:00:00 |  |  |  |  |  |  |  |  | X | X | X | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
6 | pskvmoikeim | 2 | MD | 2009-09-10 00:00:00 | 2009-09-13 00:00:00 |  |  |  |  |  |  |  |  |  | X | X | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
7 | [NAME] | 18 | MD | 2009-09-11 00:00:00 | 2009-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
8 | [NAME] , , | 2 | MD | 2009-09-11 00:00:00 | 2009-09-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
9 | sjaioek | 2 | MD | 2009-09-13 00:00:00 | 2009-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | X | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
10 | onnvoeia | 2 | SB | 2009-09-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S | S | S | S |  |  |  |  | 10
11 | [NAME] | 2 | MD | 2009-09-18 00:00:00 | 2009-09-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | D |  |  |  |  |  |  |  |  |  |  | 3
12 | klajsvi | 2 | MD | 2009-09-20 00:00:00 | 2009-09-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | D |  |  |  |  |  |  |  |  |  | 2
13 | viuaweyrt | 2 | SB | 2009-09-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S | S | S | S |  |  |  |  | 7
14 | ioyepg | 6 | MD | 2009-09-21 00:00:00 | 2009-09-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | D |  |  |  |  |  |  |  | 3
15 | piojcx | 2 | MD | 2009-09-23 00:00:00 | 2009-09-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | D |  |  |  |  |  |  | 2
16 | [NAME] | 2 | MD | 2009-09-23 00:00:00 | 2009-09-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | D |  |  |  |  |  |  | 2
17 | poijsdoin | 2 | SB | 2009-09-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S | S |  |  |  |  | 4
18 | oijiasdf | 2 | MD | 2009-09-24 00:00:00 | 2009-09-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | D |  |  |  |  |  | 2
19 | poijasbpo | 2 | MD | 2009-09-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X |  |  |  |  | 4
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Census |  |  |  |  | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | 4 | 3 | 2 | 1 | 1 | 0 | 0 | 2 | 2 | 3 | 4 | 3 | 5 | 7 | 5 | 4 | 4 | 0 | 0 | 0 | 0 | 58