Spreadsheet Designed For Scheduling Vehicles

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

Skills: Data Entry, Data Processing, Excel

See more: vehicle scheduling spreadsheet, weekly hourly schedule, hourly calendar, vehicle booking, row spreadsheet, data plot, booking scheduling, plot time excel, 2015, vehicle spreadsheet, excel change row order, excel plot time, february month, booking calendar excel, data vehicle, vehicle data entry, calendar entry excel, excel data entry ideas, excel booking calendar, excel horizontal data entry

About the Employer:
( 13 reviews ) Hexham, United Kingdom

Project ID: #5107179

4 freelancers are bidding on average $112 for this job


First of all: i have done number of excel automation projects. you can see in my list. Now regarding your project: I want to develop a simple application for you which has features described below: 1. You can add/ More

$100 USD in 3 days
(24 Reviews)

Hi dear Sir, I can do this for you... ...thanks

$147 USD in 5 days
(31 Reviews)

Dear sir As per your requirement I can do the work as I am good in excel and very dedicated and honest towards my work and I am recently competed this kind of project. So Please give me a chance to work for you. More

$45 USD in 4 days
(2 Reviews)

good knowledge for work in excel :) worked in company for data entry work in excel and my wpm speed is almost 45

$155 USD in 3 days
(0 Reviews)