Hi guys,
I'm not sure where to post this but I'm looking for some assistance/guidance
on what to do with a spreadsheet we are current'y using.
We use a 'booking' sheet at work which has a series of colums which has
fields such as booking ref,booking time,arrival time,departure time etc... of
the vehicles that have been in and out of our warehouse.
What we require is for this spreadsheet to become a little more 'advanced'
and be a little easier to use and also generate reports for example :
Vehicle 1 for customer A had a booking time of 09:00, it didn't arrive till
09:45 and left at 10:15.
We'd like for that 'Customer' how many booking slots were missed and by how
long and they how long it took for the vehicle to leave in this case it would
have been :
45 minutes late
30 minutes 'turn around time'
Also one of the main things we require is multiple users can see/edit live
data which is not possible at the moment.
You can find the spreadsheet here on my webspace
http://www.nickyboyc.force9.co.uk/BOOKING.xls
Any thoughts and suggestions will be very much appreciated
Many thanks in advance
Nick
Bookmarks