|GTD(GS) by Mike Sturm|
|This is a GTD template I created to be used as a multi-platform tool for a GTD implementation. For any cells with formulas prepopulated (those are highlighted in Orange) drag them down as you add rows.|
|Note: Please read the notes on each tab, so that you understand what certain cells (prepopulated with formulas) do. Cells with notes are listed below. Simply hover over the cell to see the notes. Cells with notes have a small blue triangle in the top right hand corner.|
|CLICK HERE TO SAVE YOUR OWN COPY OF THIS SHEET|
|There is now a course available to guide you through how to get the most out of this spreadsheet. Get access to it here:|
|(this color means "the formula in this cell is integral to the function of the sheet, change at your own risk")||NOTE:|
<-- Cells highlighted with this color orange have formulas that you should not change. Also, add columns carefully, so that the formulas still work correctly.
|Tab||Description||Cells with important notes to read|
|Core Values||Just my core values that I try to examine daily. Use or delete as you see fit.|
|Inbox||A place for your random thoughts and things to process later. Copy and paste or delete as you make them into projects, actions, or put them in the incubator.|
|Projects||Store your projects here. Use the hashtag system to number your projects. Be sure to read ALL of the comments so that the system works as it is supposed to.||C2, F2, G2, H2, I2, K1|
|Next Actions||park your next actions here||A1, C1, E1, G1|
|Waiting for||list any items you're waiting for that relate to a project. Be sure to list the project ID.||D1|
|Agendas||list any items you need to address with people that you have regular meetings with.|
|Hours/Day||Simply a pivot table that takes the open action items and the estimated hours, and shows you your day's work in hours|
|Incubator||Either put a project you'd like to work on one day, or cut an entire row from your projects sheet and paste it in a new row here when it becomes no longer active.|
|Projects (completed)||As you complete projects, cut the row from "projects" and paste it as a new row here. I also cut and paste projects that I decided to kill or hand of completely, and I put notes in the final column as to when and why.||K1|
|GTD||A handy-dandy resource to remember and use GTD methods and best practices.|
|Additional Note on Project IDs:||It is a really handy trick to use #p1, #p2, and so on to name folders and documents for your projects in other apps. I have Gmail folders, Outlook folders, Evernote notebooks, and Dropbox Folders that all have #p project IDs. It has saved me a ton of time in finding various documents and notes related to projects.|
Note on subprojects:
You can use a decimal point after the project ID to indicate subprojects. They should work the same way as project IDs. For example, some subprojects of #p12 is #p12.1, #p12.2, etc.
If you like this, please pass it on to others, and I would appreciate any donations via PayPal
|If you prefer to tip in Bitcoin, you can do so to this address: 1AcGRZ3meRQK9mHtgHDUv5iwYKr3KVQkkb|
If you have any questions, feel free to shoot me an email, and I will get back to you as I am able.