LumberJocks

Does everyone save their woodworking magazines?.. want a spreadsheet to index useful articles?

  • Advertise with us

« back to Coffee Lounge forum

Forum topic by Chardt posted 05-05-2009 05:23 PM 1053 views 0 times favorited 14 replies Add to Favorites Watch
View Chardt's profile

Chardt

169 posts in 2256 days


05-05-2009 05:23 PM

This weekend I was poring over my huge box of magazines looking for the article on making a crosscut sled, and one on new sawhorses, and a fence for my router table..and it dawned on me that if I had a spreadsheet I could immediately find every article by magazine, issue, date, page number, etc.

I have it broken out now by separate worksheets for books, websites (*including lumberjocks projects), magazines, etc.

I’m creating a spreadsheet in Excel to track them all.. I should have a rough draft in a couple of days. If anyone is interested I’ll happily send out a copy.

Just out of curiosity, does anyone already have a system like this? ...would you be interested in it?

I’d love to hear your thoughts, suggestions..

-- When my wife ask's what I have to show for my wood working hobby, I just show her the splinters.


14 replies so far

View lew's profile

lew

10031 posts in 2409 days


#1 posted 05-05-2009 05:25 PM

That’s Cool!

Why didn’t you use Access? It would have been easier/faster to search and provided additional search criteria.

Lew

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View wpreman's profile

wpreman

1610 posts in 2367 days


#2 posted 05-05-2009 05:30 PM

Sounds good! I look forward to seeing what you come up with.

-- Bill, Florida

View a1Jim's profile

a1Jim

112089 posts in 2231 days


#3 posted 05-05-2009 05:31 PM

I’m not familiar with either but it sounds like a great idea. I have full collections of FWW FHB WOOD WOODSMITH AMERICAN WW and more I don’t know if I would live long enough to index every thing.

-- http://artisticwoodstudio.com Custom furniture

View Chardt's profile

Chardt

169 posts in 2256 days


#4 posted 05-05-2009 05:31 PM

I don’t know access very well. I’m pretty good with SQL programming, but I figured a lot more people use Excel, and it would be easier for people to tweak a spreadsheet to suit their own needs.

..and also that’s why I posted this so early into the project. So I could get feedback and ideas on how to make it better. Thanks Lew!

-- When my wife ask's what I have to show for my wood working hobby, I just show her the splinters.

View lew's profile

lew

10031 posts in 2409 days


#5 posted 05-05-2009 05:36 PM

Actually, an Excel spreadsheet can be imported into a simple Access database with just a few clicks.

I tried to learn SQL and VBA but I can’t think logically. My mind resembles a flea market after an earthquake :^)

Lew

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View Chardt's profile

Chardt

169 posts in 2256 days


#6 posted 05-05-2009 05:38 PM

I’ll look into that. Thanks Lew.

-- When my wife ask's what I have to show for my wood working hobby, I just show her the splinters.

View lew's profile

lew

10031 posts in 2409 days


#7 posted 05-05-2009 05:42 PM

If you need any help, let me know.

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View out2sea71's profile

out2sea71

36 posts in 2333 days


#8 posted 05-05-2009 06:44 PM

I am interested in a copy. My wife is tired of the perpetual pile of books and magazines I drag out every time I am looking for something specific. Les

-- kein Schaden ohne Nutzen

View WhitePineLane's profile

WhitePineLane

5 posts in 2060 days


#9 posted 05-05-2009 09:18 PM

I haven’t tried any of them, but I know there are a few ready-made programs out there for doing just this thing. Here’s one:
Magazine Organizer PS Bombay 4.0
If anyone’s tried this one, i’d love to hear about it!
Otherwise I can’t wait to see the spreadsheet you come up with—finding things in old magazines is definitely a problem!

-- WhitePineLane

View leonmcd's profile

leonmcd

204 posts in 2626 days


#10 posted 05-05-2009 09:33 PM

Did a google search and came up with this

http://www.woodbin.com/docs/software/wwmagazinesoftware.htm

-- Leon -- Houston, TX - " I create all my own designs and it looks like it "

View pashley's profile

pashley

1023 posts in 2372 days


#11 posted 05-05-2009 11:47 PM

What I do is simply gently tear out the pages I like and nicely punch them, and sort them into a 3-ring binder.

-- Have a blessed day! http://newmissionworkshop.com

View Douglas Bordner's profile

Douglas Bordner

3964 posts in 2718 days


#12 posted 05-06-2009 12:00 AM

I certainly applaud your diligence and look forward to the final outcome. I have for the last several years taken both FWW magazine and a subscription to FWW.com. It certainly tames the data hunt for that particular magazine.

-- "Bordnerizing" perfectly good lumber for over a decade.

View Mario's profile

Mario

902 posts in 2705 days


#13 posted 05-06-2009 02:00 PM

That sounds great My wife and I try to do this using 3X5 cards which is ok but not great. I have been considering moving them into Access but have not done so yet. I work in the IT industry and tend to stay away from computers when not a t work.

-- Hope Never fails

View Greg Wurst's profile

Greg Wurst

781 posts in 2486 days


#14 posted 05-06-2009 06:01 PM

I scan my magazines to PDF’s and then bookmark the articles in the PDF.

-- You're a unique and special person, just like everyone else.

Have your say...

You must be signed in to reply.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com

Latest Projects | Latest Blog Entries | Latest Forum Topics

GardenTenders.com :: gardening showcase