Individual Capacity Calculator
From the Drunken PM Blog
by Dave Prior
Drunken Boxing for Project Managers
“The main feature of the drunkard boxing is to hide combative hits in drunkard-like, unsteady movements and actions so as to confuse the opponent. The secret of this style of boxing is maintaining a clear mind while giving a drunken appearance.”
Yeah... just like that… but with network diagrams and burndown charts… and a wee bit less vodka.
Recent Posts
Certified Agile Leadership Training with Olaf
Don Kim - I Think, Therefore I Plan
Agile Coach to Agile Gamer - Peter Saddington
Scrum in School - A Case Study of Grandview Prep's Transformation
Forecasting Tools Based on Team Performance with Troy Magennis
Categories
20 Hour,
211,
4-Hour Body,
4-Hour Chef,
4-Hour Work Week,
Aakash Srinivasan,
Aaron Smith,
Adam Weisbart,
Adrian Howard,
Agile,
agile digitalpm,
Agile 2010,
agile 2015,
Agile Alliance,
Agile Classroom,
Agile Enterprise,
Agile Mindset,
agile reporting,
agile transformation,
Agile Tribes,
agile2015,
AgileClassroom,
AgileCraft,
AgileScout,
AgileThinking,
Ainsley Nies,
Al Goernor,
Al Shalloway,
Alistair Cockburn,
Angela Harms,
Anna Beatrice Scott,
Ansley Nies,
AOW4PM,
apocalypse now,
apple,
art of war,
Bas De Baar,
Bas Vodde,
Beyond Legacy Code,
Big Visible,
BigVIsible,
bimodal,
Blackie,
Bob Sarni,
body language,
book review,
braintrust,
branding,
breaking gantt,
Brent Beer,
Brett Pohlman,
Brian Bozzuto,
brian flatow,
brian rabon,
business agility,
Business Model Canvas,
CAL,
Canvas,
capacity,
carson pierce,
Catherine Louis,
Center for Non-Violent Communication,
Certification,
Certified Agile Leadership,
certified scrum trainer,
Charter,
Chet Hendrickson,
Chris Li,
Chris Spagnuolo,
Christine Neidhardt,
cloud,
cloud worker,
co-working,
Coach's Clinic,
Coaching,
cochlear,
commitment,
conteneo,
Corkulous,
coworking,
Craig Larman,
Crystal,
CSM for PMP,
cst,
DAD,
Dan Brown,
Dan Greening,
dan markovitz,
data,
Dave Prior,
David Anderson,
David Bernstein,
David Bland,
David J Anderson,
Dean Leffingwell,
Dean Stevens,
Declan Whelan,
Denise Jacobs,
Dennis Stevens,
Designing Together Design,
Dhaval Panchal,
diana larsen,
Digital Pm Summit,
Digital Project Management,
digitalpm,
Disciplined Agile Delivery,
Distributed Teams,
Docs to Go,
Don Kim,
dpm,
dpm2013,
drunkenpm,
drunkenpm radio,
eduscrum,
Eight Shapes,
Elizabeth Harrin,
Elizabeth Hendrickson,
Elizabeth McClellan,
EMEA,
emotional intelligence,
Enterprise Scrum,
Essential Scrum,
esther derby,
EVEF,
Evernote,
Every Voice Engaged,
Experience,
Explore It!,
facebook,
field guide,
FIRM REPORT,
First 20 Hours,
Flight Levels,
Flipboard,
FocusedObjective,
forecast,
Forecasting,
Frank Illenberger,
Fred George,
fred kluth,
funny garbage,
Gil Broza,
Github,
Global Economics,
Grandview Prep,
Greg Balestrero,
GTD,
Happy Cog,
Heartline,
Howard Sublett,
hybrid,
I Think Therefore I Plan,
Iain Frasier,
ICAgile,
Idea Wallets,
improvisation,
InfoQ,
InspireMe!,
International Consortium for Agi,
IOS4,
iPad,
iPad 2,
iPad2,
iPhone,
IT&T SIG,
J.B. Rainsberger,
James Tamm,
Jason LIttle,
Jean Tabaka,
Jeff Patton,
Jesse Fewell,
Jessica Kerr,
Jessie Shternshus,
jim benson,
Jim Tamm,
johanna rothman,
John D Cook,
john miller,
Judith Lasater,
Jutta Eckstein,
kamal manglani,
kanban,
kanbanfor1,
kanbanpad,
Kate Sullivan,
Kathy Compton,
Ken Rubin,
Ken Schwaber,
Kenny Rubin,
Keynote,
Kuala Lumpur,
lacey,
Large Scale Scrum,
Larman,
Larry Maccherone,
Larsen,
Lasater,
Leadership Meeting,
LeadingAgile,
lean,
Lean Kanban University,
Lean Systems Engineering,
LeanKit,
Leffingwell,
LESS,
Liftoff,
Linda Rising,
Lithespeed,
Livescribe,
Livescribe Pulse,
LSE,
Luis Garcia,
luke hohmann,
lyssa adkins,
Mac,
MacWorld,
Macworld 2011,
Magennis,
Malaysia,
Malaysia Scrum User Group,
Management,
Managing the Unmanagable,
Manny Gonzalez,
Marc Johnson,
Marshall Rosenberg,
Martin Rosenqvist,
mashup,
matt barcomb,
MDEC,
Merlin,
metrics,
Michael Sahota,
Michele Sliger,
Mickey W. Mantle,
Mike Cohn,
Mike Cottmeyer,
Mike Sutton,
Mike Vizdos,
mitch lacey,
MITPM,
Mode 1,
Mode 2,
modus cooperandi,
Modus Institute,
Nanette Brown,
Natalie Warnert,
Nic Sementa,
NLP,
Non Violent Communication,
Non-violent communication,
Notes Plus,
NVC,
off shore,
Offshore,
Olaf Lewitz,
Open Space,
Oredev,
Øredev,
oredev 2013,
organizational agility,
Organizational Change,
overcommitment,
pag,
Panda Transport,
Panel Picker,
Papershow,
Paul Hammond,
personal agility canvas,
personal branding,
personal kanban,
personal productivity,
personal project management,
personal projectmanagement,
Peter Saddington First15,
Petra Goltz,
Philamade,
pk,
Planning,
PM4Girls,
PMI,
PMI Portugal,
PMP,
podcast,
Product Owner,
Product Ownership,
productivity,
Project,
project management,
project manaqement,
project planning,
Project Potion,
Projects At Work,
projectshrink,
ProjectWizards,
Projet Chartering,
pulse,
rachel howard,
Radical Collaboration,
reach the peak,
Rebecca Wirfs-Brock,
review,
riaan rottier,
Ricardo Vargas,
Robyn Meredith,
Ron Jeffries,
Ron Lichty,
Rosenberg,
SAFE,
Safety,
Sam Barnes,
Sanjiv Augustine,
Scaled Agile Framework,
Schneider and Associates,
School of Rock,
Scott Ambler,
Scrum,
Scrum Alliance,
scrum but,
scrum field guide,
Scrum Gathering,
Scrum in Education,
Scrum in Schools,
scrum in waterfall,
ScrumFest,
Shane Hastie,
Showing Up,
SK Khor,
social media,
SolutionsIQ,
sprint planning,
Steffan Surdek,
stephen denning,
Steve Elliott,
Stewart Copeland,
Story Mapping,
Sun Tzu,
Swarming,
SXSW,
SXSW2012,
Tabaka,
Team Performance,
Teams,
Telecommunications,
Telepresence,
Temenos,
Test Obsessed,
the adstore,
The Ron,
theStrayMuse Louder than Ten,
Thierry Holoweck,
Things,
Thushara,
Tim Ferriss,
Tim Ferriss Experiment,
To Be Agile,
Tobias Mayer,
Tom Kealey,
Tom Mellor,
Tom Perry,
Tom Smallwood,
Tribes,
Tricia Broderick,
troy magennis,
TrustTemenos,
twitter,
Unicat,
User Stories,
value,
VCP,
video conferencing,
Virgin Digital,
Vivek Angiras,
VLC,
vocal technique,
waste,
Weisbart,
What We Say Matters,
Wijewardena,
WIzewerks,
Woody Zuill,
WWDC,
yellowpencil,
Zeldman
Date
Note: The link to the file has been updated. It can be found here. (3-4-13)
(This is an update to my 10/28/12 post on How to Avoid Overcommitment During Sprint Planning. )
For awhile now I have been using an excel spreadsheet I put together to work out the calculations I detailed in the post on avoiding overcommitment. I have also been sharing it with the students in my CSM classes. I recently updated it so that the times allocated for the different Scrum meetings is in sync with the current version of the Scrum Guide and I thought it would be a good idea to post here just in case it can be of help to anyone.
In case you missed the earlier post, the intention of this calculator is to help individual team members on a Scrum Team gain a better (more true) understanding of the amount of time the can realistically commit/forecast to be able to contribute to the work the team will do during a Sprint. I have found this to be very helpful for teams who are struggling with understanding their capacity.
An example of how this could be used in s Sprint Planning is...
1. Once a Scrum Team has forecasted the amount of Story Points it can expect to get through during a given Sprint based on average historical velocity.
2. And defined tasks for all the stories.
3. And estimated the ideal engineering hours required to complete each individual task.
4. And totalled up the collective ideal engineering hours required to complete all the work they are forecasting to complete in the Sprint.
5. Each team member can use this calculator to determine how much time he/she can expect to be able to contribute in the Sprint.
6. Once each team member has come up with his/her number, you would total those up to get the total amount of ideal engineering hours the Team expects to be able to working during the Sprint.
7. If the value resulting from Step 4 is greater than the value from Step 6, then you may need to reconsider the amount of work your team is forecasting to complete in the Sprint, or modify the scope (and tasks) for one of the stories.
8. If the value resulting from Step 4 is significantly less than the value resulting from Step 6, you may need to consider adding some additional stories/work into what is being forecasted for the Sprint.
* Some teams I have worked with have taken the additional step of applying this technique by work type within a Sprint, i.e. Development, QA, UX, etc.
Posted on: February 19, 2013 02:31 AM |
Permalink
Comments (3)
Please login or join to subscribe to this item
Chuck Blevins
Experienced Project Management Leader| Consultant
Mission Viejo, Ca, United States
Hey, Dave.
Thanks for this post. I was unable to retrieve your Excel file from the link, however. Help?
Thanks again.
Dave Prior
Trainer/Consultant| LeadingAgile
New York, Ny, United States
Hi, I just tested it again - seems to be working fine. The download is from Mega. Here is a direct link: https://mega.co.nz/#!sowHiZoC!KplgCGZzPaqr9SxaBxGXVgOv3TJzQYXkwJhpoFDFnVo
Please Login/Register to leave a comment.
