![]() |
Taxi scheduling database using Excel?
We are trying to convert from paper scheduling to online, and we only have
Excel to work with. I already have a list started with all of the relevant info for each ride & rider. I also have a separate file with our driver schedule. My question is this: Is there a way to display a visual schedule, with rides listed by time and employees' schedules shown, so that it's easy to see which driver can do which ride? Barring that, I'm willing to simply sort each day's rides by time, but I still can't figure out how to incorporate driver schedules into the mix. Other relevant info: I haven't yet figured out how to make Excel act like a database - it still just looks like a spreadsheet to me. |
Taxi scheduling database using Excel?
Define "act like a database"
At best it is a flat file database. -- Regards, Tom Ogilvy "WTAMadison" wrote in message ... We are trying to convert from paper scheduling to online, and we only have Excel to work with. I already have a list started with all of the relevant info for each ride & rider. I also have a separate file with our driver schedule. My question is this: Is there a way to display a visual schedule, with rides listed by time and employees' schedules shown, so that it's easy to see which driver can do which ride? Barring that, I'm willing to simply sort each day's rides by time, but I still can't figure out how to incorporate driver schedules into the mix. Other relevant info: I haven't yet figured out how to make Excel act like a database - it still just looks like a spreadsheet to me. |
Taxi scheduling database using Excel?
Hi
You can of course teach a cat to bark. Money and time will be saved if you buy a dog do the barking, and/or hire a professional animal trainer to do the training. But you will learn how to do it, and have most fun, only by doing it yourself. You decide what's important. Best wishes Harald "WTAMadison" skrev i melding ... We are trying to convert from paper scheduling to online, and we only have Excel to work with. I already have a list started with all of the relevant info for each ride & rider. I also have a separate file with our driver schedule. My question is this: Is there a way to display a visual schedule, with rides listed by time and employees' schedules shown, so that it's easy to see which driver can do which ride? Barring that, I'm willing to simply sort each day's rides by time, but I still can't figure out how to incorporate driver schedules into the mix. Other relevant info: I haven't yet figured out how to make Excel act like a database - it still just looks like a spreadsheet to me. |
All times are GMT +1. The time now is 05:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com