How To Manage Your Priorities with Excel


	How To Manage Your Priorities with Excel
weirdguy
8-20-2008 3:16 PM
245 views
tags:
howto, to-do, management, priorities, work, gtd
weirdguy says:
Are you a fan of GTD? Then this could be for you.
Add a Comment
Login to Comment. Not a member yet? Sign up
Today's Top Clips

visit the Top Clips page
View the Top Clips from August 20, 2008
Embed This Clip In Your Site...
<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/955479ae-3a74-4282-bbb7-b1dc73cc79f5/9FCC3E44-1F52-406B-9208-5EABF34EE3A5/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.wikihow.com/Manage-Priorities-With-Excel" href="http://www.wikihow.com/Manage-Priorities-With-Excel" style="font-size: 11px;">www.wikihow.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Create a "Home" or "Office" tab.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content9.clipmarks.com/blog_cache/www.wikihow.com/img/77688DCE-5A23-4921-918F-327FCE470B69" alt="Click on Rename and enter "Home"" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Rename Sheet2 as "Template" and Sheet3 as "Points"</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content6.clipmarks.com/blog_cache/www.wikihow.com/img/C6D4610E-F214-44D2-AFEA-6A85EBC12433" alt="Tabs for Priorities Spreadsheet" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Create the Importance table.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content7.clipmarks.com/blog_cache/www.wikihow.com/img/A3D854D1-9839-4986-8D44-A8BD213AE1AC" alt="Importance table" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Define the name "Importance".</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content8.clipmarks.com/blog_cache/www.wikihow.com/img/DBAB7336-45FD-4279-8614-1E1D561B6790" alt="Image:Excel_Priority_Define_198.JPG" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content9.clipmarks.com/blog_cache/www.wikihow.com/img/619C1922-3A53-40FC-8607-B032AD5AD00F" alt="Click OK when done" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Create the Effort Table.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content6.clipmarks.com/blog_cache/www.wikihow.com/img/20F57BB9-6250-4AFF-A45C-74B68396F769" alt="Select Cells E2:G6 and define as "Effort"" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Create the Urgency table.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content7.clipmarks.com/blog_cache/www.wikihow.com/img/ADBBA77D-B95E-4C84-B8CC-DFB3A2C4E868" alt="The Urgency points table" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><DIV><B>Enter headings on Home tab.</B> Click on the Home tab and
insert headings in row 1:</DIV></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">A - <B>Priority</B> A formula, 1 for the most important task,
but can be over 100</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">B - <B>Task</B> Name of the task.</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">C - <B>Importance</B> An A, B, C, D, E, or F from the
table.</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">D - <B>Effort</B> A 1-5, from the Effort table.</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">E - <B>Urgency</B> A formula based on Due date.</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Due</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">G - <B>Ramp Up</B> Days prior to Due date you could start
task.</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">H - <B>Extension</B> Automatic extension of Due date</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Days Left</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Finished</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Comment</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Enter your list of tasks.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content8.clipmarks.com/blog_cache/www.wikihow.com/img/65464277-4658-42C9-A52B-1BE39A7CA526" alt="Sample Tasks for Priority Spreadsheet" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Enter formulas for Days Left, Urgency and Priority.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">I (Days Left) =F2-IF(ISBLANK(J2),TODAY(),J2)</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><li style="margin-left:16px;padding-left: 0px;">E (Urgency)
=IF(I2&gt;G2,5,IF(I2&gt;0,4,IF(I2=0,3,IF(I2+H2&gt;0,2,1))))</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Change the format for Cell I2 to Integer</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content9.clipmarks.com/blog_cache/www.wikihow.com/img/CE6A5137-DDB5-45E1-BEF5-2BCD0A8A147E" alt="Format cell as Number" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><B>Copy formulas for Priority, Urgency and Days Left to the
remaining cells in each column.</B></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel">Sort the rows</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content6.clipmarks.com/blog_cache/www.wikihow.com/img/4B3B14C8-D825-48C2-AE26-15F18E22B624" alt="Sort rows by Priority" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel"><div align="center"><img src="http://content7.clipmarks.com/blog_cache/www.wikihow.com/img/AB4ED9C8-472E-4E88-9EFB-BA611B3EC918" alt="Priorities escalate over time" /></div></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel">download</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel">[1]</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wikihow.com/Manage-Priorities-With-Excel">Save your priorities</blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/9FCC3E44-1F52-406B-9208-5EABF34EE3A5/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>
New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!
Clipmarks: Home; New Clips; Top Clips; Dashboard
Popular Topics: News; Life; Science; Technology; Entertainment
Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch
Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map
About Clipmarks: About Us; Contact; Copyright; Privacy; EULA
Search Options

Today's Top Clips
