Update Oct 28, 2007: Check out my for a free, “as is” version of my GTD System for Excel. Use at your own risk. Read all warning and usage texts in the Excel sheet itself. You have been warned! NO SUPPORT for this version. Updates and more stable, commercial versions may follow. Feedback is appreciated. Update Aug 03, 2007: I’ve stopped using my Excel sheet for GTD about 3 months ago as I’m using a PDA with ListPro as the core of my GTD system at the moment. I’ve decided to release a free, “as is” version of the Excel sheet. I need to brush it up a little first. If you don’t see it appearing for download on my site in, say, a couple of weeks, then remind me nicely Update Mar 18, 2007: This article describes my current GTD system in words and pictures. At this moment there is no downloadable Excel sheet! If this changes, my blog readers will be the first to know. See the comments section of this post for further discussion. It is perfectly possible to implement GTD in Excel. In fact, I think Excel is a perfect tool for many purposes. For your search query Wonderful Life MP3 we have found 1000000 songs matching your query but showing only top 10 results. Wonderful life film. Now we recommend you to Download first result Black Wonderful Life MP3 which is uploaded by BlackVEVO of size 6.54 MB, duration 4 minutes and 58 seconds and bitrate is 192 Kbps. Using a combination of built-in Excel formulas and my own custom made VBA code, I have implemented a basic GTD system for myself. It is in fact an ongoing project, but I am using the system successfully every day. These are my requirements for any useful GTD system: • flexible • easy to use • fast • working the way I want it to! • intuitive grouping, sorting and filtering of actions and projects • overview and details separated • configurable • compatible with I have been playing around with quite a few GTD tools, but none of them has satisfied all of these requirements. My own GTD system satisfies all my requirements and more. The most important property of any tool is that is easy and fun to use, otherwise the tool will not be used properly and certainly not regularly. /r/gtd is a reddit for discussing ways or tools to Getting Things Done. GTD Implementation Excel. Project list, project plans, someday/maybe, calendar, etc. The Best Productivity Templates for Microsoft Excel to Get Things Done. Templates How to Make Your Project a Success with Excel Templates Excel templates are an. Instead of conforming my ideas to other GTD tools, I have created my own GTD tool that conforms to my own ideas. So what does it actually look like? First, let me show you the overview and data entry screen, the “dashboard” screen if you will. Please note that I have taken the liberty of blurring certain parts of the following screenshots to protect my own privacy. GTD – dashboard (click image for larger version) The dashboard is used to get a quick overview of how many actions and projects are active or finished. It also shows the oldest and newest 5 actions (this doesn’t work properly yet and I am starting to doubt the usefulness of this information anyway). One thing to bear in mind is that all the information on the dashboard is generated automatically and dynamically from the other sheets. The righthand side of the screen is used for data entry. Actions, projects, someday/maybe’s and other data are entered here. Some more details about adding a new action: you simply type a description of the action, optionally select a project from the list, optionally select a context from the list and optionally enter a due date for this action. If the action is actually a “waiting for” action then check the appropriate checkbox. Finally, click on the Add button to actually add a new action. Actually, with some Excel magic, I have been able to construct dynamic pull-down lists for projects and contexts. No manual editing or maintenance required whatsoever! The following screenshot shows part of the projects pull-down list: GTD – dashboard – detail of projects list (click image for larger version) The next sheet shows a detailed overview of (all, or part of) the list of next actions. Using standard Excel tools, like autofiltering and sorting, it is very easy and convenient to show e.g. Unfinished actions for a certain context (or project). This is what the screen looks like: GTD – next actions (click image for larger version) Note how finished next actions (tasks, if you will) are automatically greyed out and waiting for actions are automatically highlighted. Example: Using Excel’s autofilter it is easy to show only the next actions that are unfinished in the context of @Calls: GTD – next actions – detail of filtered list (click image for larger version) Actions can be manipulated directly on this sheet by using the 3 buttons in the upper-right corner of the screen: Finish Action(s), Unfinish Action(s) and Mark deleted. Just select any number of actions and click one of the buttons to perform the corresponding operation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |