Agile SCRUM Google Spreadsheet template for freelancers
20 Jul 2010
As an occasional freelance worker and a passionate in GTD it’s been a while since I started reading about how to optimize my time while providing my best services. Yesterday I watched Hamids’ video explaining SCRUM in 10 minutes.
What is Agile SCRUM?
The video is really inspiring for all those people like me that try to get its productivity to the next level and hadn’t heard about or where reluctant to adopt such a professional project management method for simple solo or very small team projects.
Considering the methodology of SCRUM I’ve designed a Google Spreadsheet for freelancers or small teams ready to use. It is very basic but gives you an overall idea and accuracy in a fast and simple way on how the project is evolving during its process.
Simple Agile SCRUM template for freelancers
How to use it
First column includes all the tasks involved in the project, then the estimate timing and the remaining time to finish the tasks.
Next there is the calendar, there is an orange column that indicates the end of a Sprint (in this example, since the project is small it just means the deadline). Cells in the calendar in yellow are estimates on days that need to be dedicated to which tasks.
The graph shows in red the estimates and in blue the current progress.
At the bottom, there’s the total of hours done and left to do as well as the estimates.
NOTE: Blue and grey cells should not be edited.
Download
SCRUM Google Spreadsheet template
Feedback welcome! If you wish to add some modifications or come up with an improved design please let me know and I’ll add it to the post.
Photo by Alan Dayley
Comments
7 comments to Agile SCRUM Google Spreadsheet template for freelancers
Agile SCRUM in 10 minutes and Google Spreadsheet template for freelancers and small teams http://bit.ly/bmR89B
This comment was originally posted on Twitter
July 20th, 2010 at 9:44 pmReally useful RT @xaviesteve: Agile SCRUM in 10 minutes and Google Spreadsheet template for freelancers and small teams http://bit.ly/bmR89B
This comment was originally posted on Twitter
July 21st, 2010 at 10:55 amHey for templates, you should use the templates gallery that Google Docs has. http://docs.google.com/templates – that way you can get more exposure in that gallery. And you can provide a link that users can get to get a copy of it.
July 21st, 2010 at 1:30 pmThanks for the tip Ronald! I’ve submitted the template, should be visible soon :)
July 21st, 2010 at 1:38 pmWicked Xavi I will give it a go.. I will be putting up an excel I have created that has made me alot more efficent, by putting a theory I learnt into practce.. will let you know when it is done.
Yas
July 22nd, 2010 at 3:59 pmHi Xavi,
July 25th, 2010 at 6:33 amI liked your application very much. I am already testing it with a book project i have going on.
I would like to know if you can show me how to turn that example into a 45 or 90 day project? You could use the free Jing to put a quick video together.
I was able to extend the formulas to the right of the spreadsheet, except when it came to the “Total time done (estimate)” and “Total time left (from estimate)”.
So how do we do that?
Thanks a lot Cleia Grubb
By the Way, I see you are in Spain. Yo soy brasilena. Mucho gusto.
Hi Cleia,
Glad you find the spreadsheet useful :)
I’ll give it a try at Jing when I get some time, looks very cool.
The “Total time done (estimate)” is filled manually by you depending on your estimates on how much work time you assign every day. In my case, I use to work 3-4 hours on weekends and take Fridays off (so Fridays have an estimate of 0 and weekends of 3-4) but that’s just an estimate to draw the red line in the chart and give you a general idea. If the project evolves or changes its specifications, you can keep tweaking the estimates to adapt it.
The “Total time done left (from estimate)” is the total amount of estimated time still left to do, this row should fill automatically and it is mainly used to display the red line in the chart.
Hope this helps! Good luck with your book project :)
Salud!
July 26th, 2010 at 12:01 am