Require an XL Spreadsheet designed, clearly showing a Vehicle Schedule in a date & time form to accommodate 30 separate vehicles.
Ability to plot the vehicles on the spreadsheet by way of a solid horizontal line over a period of hours shown within a day.
ie: Row of vehicles vertically down left side of page and calendar to the right of this. Vehicle ‘ABC123’ is shown on the calendar as being booked between 2pm and 6pm on Monday 24th February 2015. This booking is indicated by a thick red line running through 2pm – 6pm on Monday 24th February 2015 for Vehicle ABC123.
The spreadsheet has to be able to look at all vehicles on an Hourly/ Daily / Weekly / Yearly basis showing all current and future bookings that are indicated by solid lines.
The calendar also has to change from month to month automatically
Ie: Be able to switch from December 2013 to say October 2015 etc in order to plot future bookings.
Date 1 2
Time 0000 -0900 - 1700 - 2359 0000 -0900 - 1700 - 2359
Please see attachment for more ideas