# [thelist] DB Design question

Joshua Olson joshua at waetech.com
Mon Sep 15 11:40:17 CDT 2003

```From: "Jeff Howden" <jeff at jeffhowden.com>
Sent: Monday, September 15, 2003 12:28 PM

> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > A middle of the road option (and one that will allow for
> > multiple shelters) is to put just the active/inactive
> > flag in a separate table.
> >
> > IE, the table may contain 2 columns
> >
> > BreedID, IsActive
> >
> > If you have multiple shelters, add ShelterID to that
> > table.
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> or, assume if the record exists in this joining table that the breed is
> active, otherwise it's inactive, in which case you can drop the isactive
> column entirely.

Jeff,

Really good point.  Bob, I'd second that as well.

<tip type="Time tracking" author="Joshua Olson">
If you track your time spent on projects using Excel it is common to have a
start time and an end time column.  You can calculate the time spent on any
one line by subtracting the start time from the end time.  That's typical
and easy.

On my spreadsheets I also add a rate column.  This typically doesn't change,
but if I arrange a different rate of a block of time this extra column is
good to track that.

You can calculate how much you've actually made on one line by using the
following calculation:

=HOUR([duration])*[rate]+MINUTE([duration])*[rate]/60

Swap out [duration] with the column that has the length of time calculated
and the [rate] with the column that has the rate entered.

You can easily figure out the billable amount by simply highlighting this
calculate column.
</tip>

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com
706.210.0168

```