Spreadsheet: 181343d1347999381-proper-counting-of-days-daddy_beds
Sheet: Sheet1

Name | Gender | County | Type of intake | Admit Date | Discharge Date | Bed Days
 | Female | [NAME] | Diversionary | 2012-04-05 00:00:00 | 2012-04-09 00:00:00 | 4
 | Female | [NAME] | Diversionary | 2012-04-05 00:00:00 | 2012-04-10 00:00:00 | 5
 | Female | [NAME] | Diversionary | 2012-04-08 00:00:00 | 2012-04-10 00:00:00 | 2
 | Male | Barron | Diversionary | 2012-04-16 00:00:00 | 2012-04-24 00:00:00 | 8
 | Male | [NAME] | Transitional | 2012-04-16 00:00:00 | 2012-04-22 00:00:00 | 6
 | Female | Barron | Diversionary | 2012-04-17 00:00:00 | 2012-04-23 00:00:00 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | Consumers |  | Bed Days Utilized |  | Monthly Occupancy
 | Female | [NAME] | Diversionary | 2012-04-29 00:00:00 | 2012-05-05 00:00:00 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-01 00:00:00 | 8 | 120 | 42 | 5.25 | 0.35
 | Female | Barron | Transitional | 2012-05-15 00:00:00 | 2012-05-22 00:00:00 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | 10 | 124 | 61 | 6.1 | 0.4919354838709677
 | Male | Barron | Diversionary | 2012-05-17 00:00:00 | 2012-05-22 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00 | 8 | 120 | 17 | 2.125 | 0.1416666666666667
 | Female | [NAME] | Diversionary | 2012-05-17 00:00:00 | 2012-05-24 00:00:00 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00 | 4 | 124 | 62 | 15.5 | 0.5
 | Female | Barron | Transitional | 2012-05-22 00:00:00 | 2012-05-31 00:00:00 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | 33 | 1460 | 190 | 5.757575757575758 | 0.1301369863013699
 | Female | [NAME] | Transitional | 2012-06-15 00:00:00 | 2012-06-18 00:00:00 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.636805555555556 | 0.1290098566308244
 | Female | Barron | Transitional | 2012-06-20 00:00:00 | 2012-06-22 00:00:00 | 2
 | Female | [NAME] | Diversionary | 2012-06-28 00:00:00 | 2012-07-11 00:00:00 | 13
 | Male | [NAME] | Diversionary | 2012-06-29 00:00:00 | 2012-07-06 00:00:00 | 7
 | Female | [NAME] | Diversionary | 2012-06-29 00:00:00 | 2012-07-09 00:00:00 | 10
 | Male | LaCrosse |  | 2012-06-29 00:00:00 | 2012-08-03 00:00:00 | 35
 | Male | [NAME] | Diversionary | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 1
 | Female | [NAME] | Transitional | 2012-07-14 00:00:00 | 2012-07-16 00:00:00 | 2
 | Male | [NAME] | Transitional | 2012-07-17 00:00:00 | 2012-07-17 00:00:00 | 1
 | Male | Barron | Transitional | 2012-07-19 00:00:00 | 2012-07-23 00:00:00 | 4
 | Female | [NAME] | Diversionary | 2012-08-02 00:00:00 | 2012-08-06 00:00:00 | 4
 | Female | [NAME] | Diversionary | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 1
 | Female | [NAME] | Diversionary | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 1
 |  |  |  |  |  | 190