We require a 'pickup and pace excel report to track demand for our rental cars, and the pace at which people are booking them for any given date in the future.
What I would like is what is commonly called a "Pickup and Pace report" in the hotel industry.
What I want is to be able to do is input the data from our 'New Booking report' and then see areas where the pace of demand is increasing over any given date range, for another date range, or not.
Attached is our "New Booking report" which shows the date when the booking was made, the daily rate, and the dates of hire. Also important is the vehicle category and pickup location.