[Spooks] Make your own database

[Jeff Wilson]

It's easy to to an Excel Filter.

Just highlight the top row (hopefully it has column headers), click on
"Data>Filter>AutoFilter"

Excel will then create a drop down list of each column. So, for
instance, if there is a column with UTZ in it, you could rapidly pull
up all the stations broadcasting at that time.

Regards,

Jeff

On 12/16/06, Ary Boender <ary at luna.nl> wrote:
> Visit http://mailman.qth.net/mailman/listinfo/spooks to unsubscribe from this list
>
> Hi,
>
> Because most people are using Excel and not too many have Access, I removed the
> Access databases from my website about 2 years ago. I now export the data to
> Excel and put that on the N&O website. I can upload the monthly logs in Access
> format to the website if people are interested. Please let me know.
>
> Ary
>
>  On Fri, 15 Dec 2006 13:18:10 -0500, you wrote:
>
> >Visit http://mailman.qth.net/mailman/listinfo/spooks to unsubscribe from this list
> >
> >Hello Spooks,
> >     I wanted to find out what numbers station was on now without tying
> >up my phone line, so I made my own database.  I got the Numbers 2006
> >Excel list from Ary's web page and saved it.  There are several blanks
> >in the Days column, and a database won't ;ike that, so I filled those
> >in.  Every date has the day somewhere, so you won't need to have a
> >calender in front of you- just copy and paste existing days to save a
> >little time.  Be careful that you keep the right day with the right
> >date!  It is time consuming- listen to the radio while you work.  Bring
> >up Access and import your new and improved Excel Spreadsheed data and
> >there's your database.  You can use the filters to see what's on now or
> >when E10 will be on today, that you can't do in Excel.
> >73,
> >Dan
> >
> >
> >______________________________________________________________
> >Spooks mailing list
> >Home: http://mailman.qth.net/mailman/listinfo/spooks
> >Help: http://mailman.qth.net/faq.htm
> >Post: mailto:Spooks at mailman.qth.net
> >-
> >Visit http://www.spynumbers.com/ for complete information about Spy Numbers Stations
>
> ______________________________________________________________
> Spooks mailing list
> Home: http://mailman.qth.net/mailman/listinfo/spooks
> Help: http://mailman.qth.net/faq.htm
> Post: mailto:Spooks at mailman.qth.net
> -
> Visit http://www.spynumbers.com/ for complete information about Spy Numbers Stations
>


-- 
Regards,

---------------
Jeff Wilson