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.

Define "act like a database"

At best it is a flat file database.

--
Regards,
Tom Ogilvy


"WTAMadison" <[email protected]> wrote in message
news:[email protected]...
> 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.

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" <[email protected]> skrev i melding
news:[email protected]...
> 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.