Thanks Thanks:  0
Likes Likes:  0
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Results 1 to 15 of 15
  1. 27th September 2006, 05:10 PM #1
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default Organizing your woodwork tips and info

    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.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  2. 27th September 2006 05:10 PM # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Age
    2010
    Posts
    Many





     
  3. 27th September 2006, 07:16 PM #2
    AlexS's Avatar
    AlexS
    AlexS is offline Dehydrated Hydrographer
    Join Date
    Jun 1999
    Location
    Westleigh, Sydney
    Age
    77
    Posts
    9,550

    Default

    Looks OK, I'll download & have a bit of a play. Thanks.
    Visit my website
    Website
    Facebook
    Reply With Quote Reply With Quote
  4. 27th September 2006, 08:01 PM #3
    savage's Avatar
    savage
    savage is offline Hitter of thumbs, Arrrgh!
    Join Date
    Sep 2005
    Location
    campbelltown NSW
    Age
    67
    Posts
    623

    Default

    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!
    savage(Eric)

    Never, under any circumstances, take a sleeping pill and a laxative on the same night.
    Reply With Quote Reply With Quote
  5. 27th September 2006, 08:26 PM #4
    Stuart's Avatar
    Stuart
    Stuart is offline Electron Murderer
    Join Date
    Aug 2002
    Location
    Melbourne, Victoria
    Posts
    5,513

    Default

    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.
    "Clear, Ease Springs"
     www.Stu's Shed.com

    Reply With Quote Reply With Quote
  6. 27th September 2006, 09:09 PM #5
    sea dragon
    sea dragon is offline Senior Member
    Join Date
    Jun 2006
    Location
    Waverton
    Posts
    222

    Default

    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.
    What a great prospect for a computer afficiando who loves woodwork.
    CJ
    Just when the caterpillar thought the world was over, it became a butterfly Anon
    Be the change you wish to see in the world Ghandi
    Reply With Quote Reply With Quote
  7. 27th September 2006, 09:11 PM #6
    Jedo_03
    Jedo_03 is offline SENIOR MEMBER
    Join Date
    Apr 2006
    Location
    Broken Hill
    Posts
    540

    Default EXCEL-ent. . .

    Hi Wongo
    Brilliant
    I'll use it
    You got another fan.
    Cheers
    Jedo
    Reply With Quote Reply With Quote
  8. 27th September 2006, 09:41 PM #7
    ss_11000
    ss_11000 is offline You've got to risk it to get the biscuit
    Join Date
    Jan 2006
    Location
    Canberra
    Age
    32
    Posts
    4,195

    Default

    mmm. good set up wongo.

    thanx for sharing
    S T I R L O
    Reply With Quote Reply With Quote
  9. 5th October 2006, 11:11 PM #8
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    It is probably a bit hard to see the benefit without too many records. Here is what I've got so far.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  10. 6th October 2006, 04:40 AM #9
    bookend
    bookend is offline Senior Member
    Join Date
    Mar 2006
    Location
    Perth
    Age
    57
    Posts
    338

    Default

    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.
    Graeme
    Reply With Quote Reply With Quote
  11. 23rd May 2007, 09:58 PM #10
    nickwithaz
    nickwithaz is offline Senior Member
    Join Date
    May 2006
    Location
    Sydney
    Posts
    102

    Default

    Quote Originally Posted by bookend View Post
    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. 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 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!

    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
    Reply With Quote Reply With Quote
  12. 24th May 2007, 01:12 AM #11
    nickwithaz
    nickwithaz is offline Senior Member
    Join Date
    May 2006
    Location
    Sydney
    Posts
    102

    Default

    Quote Originally Posted by nickwithaz View Post
    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

    Thanks again Scott,

    Nick
    Reply With Quote Reply With Quote
  13. 25th May 2007, 08:36 AM #12
    rsser
    rsser is offline Hewer of wood
    Join Date
    Jan 2002
    Location
    Melbourne, Aus.
    Age
    71
    Posts
    12,746

    Default

    I use Google Desktop - indexes files, Outlook emails, web search history etc.
    Cheers, Ern
    Reply With Quote Reply With Quote
  14. 25th May 2007, 10:16 AM #13
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    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. It is in AWR #49 page 60.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  15. 25th May 2007, 10:38 AM #14
    Pat's Avatar
    Pat
    Pat is offline Good Wood Ruined!
    Join Date
    Jan 2004
    Location
    Towradgi
    Posts
    4,839

    Default

    Is this a slip of the fingers


    Aust Woodsmooth


    Gumby's been at your computer gain!

    Pat
    Work is a necessary evil to be avoided. Mark Twain
    Reply With Quote Reply With Quote
  16. 25th May 2007, 12:45 PM #15
    NCArcher's Avatar
    NCArcher
    NCArcher is offline The Laird
    Join Date
    Jan 2007
    Location
    Katoomba NSW
    Posts
    4,774

    Default

    Quote Originally Posted by Pat View Post
    Is this a slip of the fingers

    Aust Woodsmooth


    I think it's that new publication on sanding and sandpaper
    Those were the droids I was looking for.
    https://autoblastgates.com.au
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. lookin for some tips on a budget boat.
    By holmsy2000 in forum BOAT BUILDING / REPAIRING
    Replies: 5
    Last Post: 20th August 2006, 05:23 PM
  2. EBay - Info, tips, etc. on buying and selling
    By scooter in forum NOTHING AT ALL TO DO WITH WOODWORK
    Replies: 11
    Last Post: 31st October 2004, 06:50 PM
  3. Planner Attachment Tips
    By barrysumpter in forum TRITON / GMC
    Replies: 9
    Last Post: 29th March 2001, 10:07 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules