ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Taxi scheduling database using Excel? (https://www.excelbanter.com/excel-programming/348230-taxi-scheduling-database-using-excel.html)

WTAMadison

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.

Tom Ogilvy

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.




Harald Staff

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