Spreadsheet: 181274d1347980333-proper-counting-of-days-copy-of-bed-20days-20for-20month-1-
Sheet: Sheet1

Name | Gender | County | Type of intake | Admit Date | Discharge Date | Bed Days |  |  | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00
 | Female | [NAME] | Diversionary | 2012-04-05 00:00:00 | 2012-04-09 00:00:00 | 4 |  |  | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-04-05 00:00:00 | 2012-04-10 00:00:00 | 5 |  |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-04-08 00:00:00 | 2012-04-10 00:00:00 | 2 |  |  | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Male | Barron | Diversionary | 2012-04-16 00:00:00 | 2012-04-24 00:00:00 | 8 |  |  | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Male | [NAME] | Transitional | 2012-04-16 00:00:00 | 2012-04-22 00:00:00 | 6 |  |  | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Female | Barron | Diversionary | 2012-04-17 00:00:00 | 2012-04-23 00:00:00 | 6 |  |  | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Total Bed Days for the Month |  | Average Length of Stay
 | Female | Barron | Diversionary | 2012-04-21 00:00:00 | 2012-04-30 00:00:00 | 9 |  |  | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Month | Consumers |  | Bed Days Utilized |  | Monthly Occupancy
 | Female | [NAME] | Diversionary | 2012-04-29 00:00:00 | 2012-05-05 00:00:00 | 6 |  |  | 0 | 0 | 0 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-01-01 00:00:00 | 0 | 124 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-05-02 00:00:00 | 2012-05-04 00:00:00 | 2 |  |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-02-01 00:00:00 | 0 | 116 | 0 | 0 | 0
 | Male | Barron | Transitional | 2012-05-10 00:00:00 | 2012-05-14 00:00:00 | 4 |  |  | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-03-01 00:00:00 | 0 | 124 | 0 | 0 | 0
 | Male | Barron | Transitional | 2012-05-10 00:00:00 | 2012-05-17 00:00:00 | 7 |  |  | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-04-01 00:00:00 | 7 | 120 | 41 | 5.857142857142857 | 0.3416666666666667
 | Female | Barron | Transitional | 2012-05-15 00:00:00 | 2012-05-22 00:00:00 | 7 |  |  | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-05-01 00:00:00 | 10 | 124 | 60 | 6 | 0.4838709677419355
 | Male | Barron | Diversionary | 2012-05-17 00:00:00 | 2012-05-22 00:00:00 | 5 |  |  | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-06-01 00:00:00 | 8 | 120 | 15 | 1.875 | 0.125
 | Female | [NAME] | Diversionary | 2012-05-17 00:00:00 | 2012-05-24 00:00:00 | 7 |  |  | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-07-01 00:00:00 | 4 | 124 | 64 | 16 | 0.5161290322580645
 | Female | Barron | Transitional | 2012-05-22 00:00:00 | 2012-05-31 00:00:00 | 9 |  |  | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-08-01 00:00:00 | 3 | 124 | 8 | 2.666666666666667 | 0.06451612903225806
 | Female | [NAME] | Transitional | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 1 |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-09-01 00:00:00 | 0 | 120 | 0 | 0 | 0
 | Female | Barron | Diversionary | 2012-05-24 00:00:00 | 2012-06-01 00:00:00 | 7 |  |  | 0 | 0 | 0 | 0 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-10-01 00:00:00 | 0 | 120 | 0 | 0 | 0
 | Male | [NAME] | Diversionary | 2012-05-25 00:00:00 | 2012-06-01 00:00:00 | 6 |  |  | 0 | 0 | 0 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-11-01 00:00:00 | 0 | 120 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-06-01 00:00:00 | 2012-06-03 00:00:00 | 2 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012-12-01 00:00:00 | 0 | 124 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2012 | 32 | 1460 | 188 | 5.875 | 0.1287671232876712
 | Female | [NAME] | Transitional | 2012-06-15 00:00:00 | 2012-06-18 00:00:00 | 3 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 2.699900793650794 | 0.1275985663082437
 | Female | Barron | Transitional | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-06-28 00:00:00 | 2012-07-11 00:00:00 | 13 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 11 | 0 | 0 | 0 | 0 | 0
 | Male | [NAME] | Diversionary | 2012-06-29 00:00:00 | 2012-07-06 00:00:00 | 7 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 0 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-06-29 00:00:00 | 2012-07-09 00:00:00 | 10 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 0 | 0 | 0 | 0
 | Male | LaCrosse |  | 2012-06-29 00:00:00 | 2012-08-03 00:00:00 | 34 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 31 | 3 | 0 | 0 | 0 | 0
 | Male | [NAME] | Diversionary | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 | Female | [NAME] | Transitional | 2012-07-14 00:00:00 | 2012-07-16 00:00:00 | 2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
 | Male | [NAME] | Transitional | 2012-07-17 00:00:00 | 2012-07-17 00:00:00 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Male | Barron | Transitional | 2012-07-19 00:00:00 | 2012-07-23 00:00:00 | 4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-08-02 00:00:00 | 2012-08-06 00:00:00 | 4 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 | Female | [NAME] | Diversionary | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 41 | 60 | 15 | 64 | 8 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 31