I'm building a length of stay study for a county jail and would like to do the entire thing in excel.
I have gathered data regarding in date, out date, time of booking in time of booking out and charges. I need to be able to display data like:
number of assault and battery charges on a given day and how many of these charges stayed in jail 5 - 10 days, 10 - 20 days, etc.
How could I set this up so people could choose the offense and time and get the correct data?
Thanks
I have gathered data regarding in date, out date, time of booking in time of booking out and charges. I need to be able to display data like:
number of assault and battery charges on a given day and how many of these charges stayed in jail 5 - 10 days, 10 - 20 days, etc.
How could I set this up so people could choose the offense and time and get the correct data?
Thanks