Forum Discussion
Days Fleet Vehicle Available For Each Month
- 6 years ago
I work for a nonprofit school for children with autism and we have multiple vans for outings.
My boss has asked me to show data on whether or not we have to many vehicles and can we get rid of any.
I have the dates and number of times each vehicle was driven but I am not sure how to organize it. I did it by percentages and broke it out monthly for the last six months but that is not giving me what I need.
Here is one month of data but I'm not sure how to show the data on any vehicle can be gotten rid of. My vehicle data is van # in column 1 and dates along row 1 starting in column 2 : 4/10/2023 4/11/2023 4/12/2023 4/13/2023 4/14/2023 4/17/2023 4/18/2023 4/19/2023 4/20/2023 4/21/2023 4/24/2023 4/25/2023 4/26/2023 4/27/2023 4/28/2023
#1 (Acd) 17 6 2 11 12 6 2
#2 (Acd) 16 1 6 2 1 1 11 12 6 1 1 2 1
#5 (Acd) 16 6 2 11 12 6 2
#15 (Acd) 1 1 8 2 11 6
#16 (Acd) 1 8 11 8
#17 (Acd) 1 8 10 8
#18 (LS) 1 1 2 1 1 1 1
#19 (EA) 1 1 1 1
#23 (Res) 3 2 3 8 5 1 2 4 4 6 4
#24 (Res)
#28 (Ls)
#29 (Res) 5 9 3 9 5 4 4 5 6 2 5 5 6 4 4
Thank you so much for your help in this.