Excel for GTD

[Tom R]

For those of you that keep lists of stuff in Excel (Windows only), you
may be interested in checking out my Excel report generator. (I don't
really know what else to call it).

I use a single Excel File for my contact list, professional journal,
personal journal, next
action and waiting for lists, timesheet log, and project record. I'd
say that my system is a cross between one big text file, Evernote, and
Paper Tiger. You can create your own categories, or don't use any
categories at all. Highly structured or next to no structure. It
doesn't matter. Simply search for one or two keywords and create an
immediate ad hoc report.

It is very handy with large db lists and text. I use this system on a
usda food nutrient database (6,000 items long) and the complete King
James Bible (around 31,000 lines). For example I now know that there
are only two occurrences of the word "stinketh" in the entire text.

So If you would like to give it a try, let me know and I will e-mail a
copy of this file.
No charge, no strings attached just let me know what you think of it.

I am working on an Excel addin for this tool and I am looking for user
input to improve the system.

Tom

[bignoseduglyguy]

Tom

I'd be very interested to learn more about your one Excel file method
and trying your report generator.

bnug

--
bignoseduglyguy
http://www.bignoseduglyguy.com
http://www.bignoseduglyguy.com/no8wire
http://www.bignoseduglyguy.com/bnugwiki

[taorist]

Yes! E-mail me a copy too!

[Austin Mitchell]

Please can you send me details please. I was using an Excel file for
GTD and I'd be interested in your approach.

Thanks,

Austin.

[Cpu_Modern]

Hey Excellence,
you may be interested in this
http://www.joelonsoftware.com/articles/fog0000000245.html
Greets.

[Ozan Ozkusaksiz]

Hi,
 

I want a copy too :)

 

Ozan

[John O'Malley]

Please send it to me.

John

[jos...@gmail.com]

me too

On 03/02/06, John O'Malley <thejohn...@gmail.com> wrote:
>
> Please send it to me.
>
> John
>

[Daemonwolf]

I'd like a copy please. :)

[moonlander]

[moonlander]

Tom,
i'd appreciate a copy too

krgds
moonlander

[Justin Lilly]

Tom: if you're interested in a mirror for this file so you don't have to email it out to 100 people, contact me and I'll see what I can set up.

 

-justin

 

--
Justin Lilly
University of South Carolina
http://www.justinlilly.com  (not currently active)

[dang!]

me too

[Norm]

I don't want a full 30 minutes to pass without a request :)

me too!! please!!!

On 2/3/06, dang! <dangol...@gmail.com> wrote:

me too

[eichorsmith]

I would like it too!

Leigh

[Rita]

[Rita]

Please send me a copy too.

Regards, Rita

[engr]

Please send me a copy to.

Thanks
gh

[llw...@gmail.com]

Tom --

Please send me a copy also. Thanks...

Dale

[GeeWhiz]

Yeah, I would also like a copy.

Thanks

[rcr]

Tom,

I'd appreciate a copy. I've done something similar in Word, but prefer
Excel for lists.

Rob

[Boiler_909]

Coul you send me a copy ?

Thanks

[Morgan Parker]

May I have a copy too please?

Morgan.

[timothy...@gmail.com]

Tom:

I would be interested in using it. Please send me a copy. Thank-you.

[drumdance]

This thread reminds me of Google's discovery of the first "me too"
post: Feburary 1983.

http://www.google.com/googlegroups/archive_announce_20.html

[Justin Lilly]

Anyone looking for a copy of the Excel worksheets that Tom has, I have put up a rudamentory mirror at:

http://www.justinlilly.com/excel/ 

feel free to grab it.

[Justin Lilly]

oh... thanks from me too ;)

-justin

On 2/6/06, Morgan Parker <asrome...@gmail.com> wrote:

drumdance wrote:
>
> http://www.google.com/googlegroups/archive_announce_20.html

Um, OT I know, but this was fascinating.  Thanks.


Morgan
http://mogblog.wordpress.com

[TheOldGuy]

Tom R wrote:
> For those of you that keep lists of stuff in Excel (Windows only), you
> may be interested in checking out my Excel report generator. (I don't
> really know what else to call it).
>
> I use a single Excel File for my contact list, professional journal,
> personal journal, next
> action and waiting for lists, timesheet log, and project record. I'd
> say that my system is a cross between one big text file, Evernote, and
> Paper Tiger. You can create your own categories, or don't use any
> categories at all. Highly structured or next to no structure. It
> doesn't matter. Simply search for one or two keywords and create an
> immediate ad hoc report.
>
> It is very handy with large db lists and text. I use this system on a
> usda food nutrient database (6,000 items long) and the complete King
> James Bible (around 31,000 lines). For example I now know that there
> are only two occurrences of the word "stinketh" in the entire text.
>
> So If you would like to give it a try, let me know and I will e-mail a
> copy of this file.
> No charge, no strings attached just let me know what you think of it.
>
> I am working on an Excel addin for this tool and I am looking for user
> input to improve the system.
>
>
> Tom

Add me to the list of interested persons.

[TheOldGuy]

Thanks for posting.

[scrou...@gmail.com]

please send me a copy as well
thanks
J

[edward....@gmail.com]

Tom,

Is there somewhere I can download your spreadsheet? It's been
recommended via the David Allen forums?
Regards, Edward

[airolg]

I want a copy, too, pretty please???

Thanks! <grin>

[amaroo]

I downloaded the spreadsheet, thank Tom and thanks Justin. Now how do
you move the vb macros that Tom created from his spreadhseet to your
own? do i have to do some coding here (I have always wanted to teach
myself this)?

Dean

[engr]

Thanks for the file. The VB macros are very handy. I have used
spreadsheets before but you have taken them to a new level - I'm very
impressed.
Thanks
Glenn

[HT]

Tom,
I'd love to have a copy.
Halbert
halb...@gmail.com

[Eugene Liedel]

I-d like a copy please

--
lie...@gmail.com
deepthoughts.liedel.org

[TheCoop]

Tom,
I'd love to give your Excel project a try. I'll be glad to give you my
feedback. Thanks.
Ed

[Garrett Murphy]

I've downloaded the excel sheet and i think this is a great idea! But,
since my excel skills are pretty crap, could i ask folks what they have
on their tabs? Contacts, to-do, bookmarks, ......if anyone has a blank
one with just headings, i'll host it for them so more of us can d/load.

Regards,

Garrett

[APPLE]

I love the idea of this for keeping random bits of information but how
do you get a new setup
so I can have my own data and my own searches?

Thanks

Chris Hughes

[Tom R]

To download a copy of the file, go here:

http://www.justinlilly.com/excel/

and download both of these files:
Personal Information..> 05-Feb-2006 20:04 612k "The File"
and
Tom's screenshots.xls 05-Feb-2006 20:05 404k "Examples"

Then set up your columns and heading labels as you see fit and add your
data.

Special thanks to Justin for providing the mirror site.

I would love to hear your thoughts after you have taken a look at it.

Regards,

Tom

[APPLE]

I am using it a lot as I am able to copy all of those little notes into
it with shortcut's etc and it stay's on my usb chip with me all the
time.

When you do a search the tabs seem to stay on the bottom. Is there a
way to get rid of them once you have found the data you want?

A really great template.

Chris Hughes

[Tom R]

Chris,

When you run a "New Sheet Report" for, say "Next Actions" the tool will
create a new worksheet named "search results for_Next Actions".

To delete any worksheet, right click the tab and select Delete from the
menu. Just be sure not to delete your main data sheet!

Tom

[Dave]

Hello Tom,

I'd be interested in a copy of this.

Thanks

Dave