Organizing your woodwork tips and info

[Wongo]

You are buying a new router. There is a test report somewhere but you just cannot recall it.:(

OR

You want to get some ideas for your new Dining table. There is WIP thread somewhere on the forum?

Hmmmmmmmm

Here is a simple way to organise your WW info. It is a simple Excel spreadsheet.

Open the file and click on Enable macros.

Use the filters (column A to D) to fine tune your records.

When entering a new row, right click on the cell and choose “Pick From List….” for quick data entry.

Enter 3+ characters in B1 and B2 to search specific records

I hope you find it useful and please let me know what you think.

[AlexS]

Looks OK, I'll download & have a bit of a play. Thanks.

[savage]

Thanks Wongo, I'm not really up on this stuff but I'll try and give it a go, if I do get it right it will be great as my way is very crude and sometimes spend a lot of time looking for things.:)
A greeny for you!

[Stuart]

And I thought I had way too much time on my hands!

Wish I could organise my entire IT file collection - all 1TB or so of it.

[sea dragon]

This is a good thought but it has been posted marginally prematurely.:eek:

Surely you saw the Australian Woodsmith Index that accompanied Issue 42. It has two parts, the Project Index and the General Index.
Ideally, this can be reposted when both Indexes have been added, or at a pinch, only one part.:D
What a great prospect for a computer afficiando who loves woodwork.

[Jedo_03]

Hi Wongo
Brilliant
I'll use it
You got another fan.
Cheers
Jedo

[ss_11000]

mmm. good set up wongo.

thanx for sharing

[Wongo]

It is probably a bit hard to see the benefit without too many records. Here is what I've got so far.

[bookend]

Even better is to use Frontpage. You can download whole webpages and save them with their pictures and organise an index like you see on most webpages with links to your information or to subheadings.

It is beautiful in action.

[nickwithaz]

Even better is to use Frontpage. You can download whole webpages and save them with their pictures and organise an index like you see on most webpages with links to your information or to subheadings.

If anyone is looking for something to make saving online info easier and more convenient than this even, check out MetaProducts Inquiry (http://www.metaproducts.com/mp/Inquiry_Standard_Edition.htm). It doesn't need any technical knowledge or Frontpage, allows you to organize info into folders/sub-folders, provides thumbnails of saved pages and importantly allows you to search across all your saved pages.

It's US$30, but there's a free 30-day trial version. I use a few of their apps - all very good and easy to claim as a tax deduction :U i.e.used for work 'research.'

However, the beauty of Wongo's spreadsheet is it provides simple database functionality for non-online info (particularly search. Thanks muchly for that Wongo! :2tsup:

But any chance you can help me to get it working (search) in Excel 2000? Worked on my PC using latest Office version, but had to restore back to an old version and doesn't work (and the VBA is password protected).

Cheers,

Nick

[nickwithaz]

But any chance you can help me to get it working (search) in Excel 2000? Worked on my PC using latest Office version, but had to restore back to an old version and doesn't work (and the VBA is password protected).

Just got a PM from Wongo...

Having a look at the VBA code it seems Excel 2000 has a problem a change in syntax for setting the sort order i.e. "DataOption1:=xlSortNormal"
I took the easy option and removed it, works fine... that'll do me for now :U

Thanks again Scott,:2tsup:

Nick

[rsser]

I use Google Desktop - indexes files, Outlook emails, web search history etc.

[Wongo]

I started my entertainment unit project a few weeks ago. I remember there was a project in one of the magazines. So typed in “entertainment” and bingo. :D It is in AWR #49 page 60.:2tsup:

[Pat]

Is this a slip of the fingers :D


<TABLE style=" 110pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=146 border=0 x:str><COLGROUP><COL style=" 110pt; mso-width-source: userset; mso-width-alt: 5339" width=146><TBODY><TR style=" 11.25pt" height=15><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER- #ece9d8; BORDER- #ece9d8; 110pt; BORDER-BOTTOM: #ece9d8; 11.25pt; BACKGROUND-COLOR: transparent" width=146 height=15>Aust Woodsmooth


Gumby's been at your computer gain!

</TD></TR></TBODY></TABLE>

[NCArcher]

Is this a slip of the fingers :D

<TABLE style=" 110pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=146 border=0 x:str><COLGROUP><COL style=" 110pt; mso-width-source: userset; mso-width-alt: 5339" width=146><TBODY><TR style=" 11.25pt" height=15><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER- #ece9d8; BORDER- #ece9d8; 110pt; BORDER-BOTTOM: #ece9d8; 11.25pt; BACKGROUND-COLOR: transparent" width=146 height=15>Aust Woodsmooth


</TD></TR></TBODY></TABLE>

I think it's that new publication on sanding and sandpaper :doh: