Friday 26 December 2008

Excel Progress Monitoring System - A "Should-be" Handy Excel Toy

Here's a new tool for me to monitor my task and sub-tasks progress (oh yes I am well-organized. =) ). Have fun. =)


Screenshots:



^~ (my list. Too many To-Do.s.... sigh....) Name: Progress Monitoring System v0.8

Description: A small tool for office people to monitor all his/her tasks (and sub-tasks) progress with ease (and fancy looking! XD)

Download Here: Click Me

Origin: As multi-tasking is becoming more significant during my work, I need to have something to keep track on my little task in details, especially for those requiring a link-by-link checking during UAT. An Excel-based non-macro tool is thus developed for such dirty task.

Good:
- Excel-based without any embedded macro script, perfectly fits those business PC with MS Office + high security check
- The appearance is designed to be similar to a reporting tool, fairly easy to present to your boss if he/she would like to "learn" more about your progress (kind-of show-off to me. =P)
- Support maximum a four-level-depth task description (i.e. a 1.3.2 level task .... etc.)

Bad:
- May not be user friendly enough (as lack of support of macros)
- Not easy to start without manual (Personally, I prefer no-manual-and-no-experience-required tools =) )
- Difficult for maintenance due to heavy usage of cell referencing and conditional formatting.


Simple Tutorial: (it's simply too large to fit in here, so please click to enlarge if necessary)



Further To-Do:
- May convert to Google Excel program.
- User Manual will be created in a day or two. (Done!~)


Feel free to let me know what do you think.

Dickson W.



P.S. This is also the first entry for "A.I. Eve's Toys Collection" label, a portion of my blog that stores mainly my "little toys", plus, a portion of Nekotopia's story. We shall see. =)

No comments:

Post a Comment