[dba-VB] [AccessD] SCRUM: Northwind .NET Product BackLogPlanning Game...

Salakhetdinov Shamil mcp2004 at mail.ru
Wed Mar 18 14:36:55 CDT 2009


Hi SCRUM Team members,

I have got estimations from Doug and I have made combined workbook with all estimatiions, which I have got published here on MS Live dba-VB:

https://cid-000971dc34dc18c0.groups.skydrive.live.com/browse.aspx/.Documents/NorthWind.NET/ProductBackLog?uc=1&isFromRichUpload=1

Is it available for everybody? (please get MS Live ID if you still do not have it and make a request to join MS Live dba-VB) 

In the above workbook you can find that there is an AVG value of all estimations and manually corrected AVG value to fit the SCRUM evaluation numbers set: 0, 1/2, 1, 2, 3, 5, 8, 13, 20, ???

The total number of ideal hours we have now is 86, which fits our original plan of 20x5 = 100 hours.
Please check my arithmetics and correct if there are some mistakes.

If everybody feels OK with that evaluation we can get it as DONE and spend rest of the time during this week to try to get source code control up&running.

If you feel not OK about some positions lets discuss them here - please post your considerations.

Note: in real life product planing discussion/meetings it usually takes several rounds to come to a common set of evaluations but the total number of hours spent on this meeting should be within 4 hours.

Please note also that (most of) the current evaluations (whatever they will finally be) will inevitably change during actual development... 

I have also put combined workbook temporarily here:

http://smsconsulting.spb.ru/scrum/nwbl.zip

Thank you.

--
Shamil



-----Original Message-----
From: Salakhetdinov Shamil <mcp2004 at mail.ru>
To: dba-VB <dba-vb at databaseadvisors.com>
Date: Wed, 18 Mar 2009 21:47:36 +0300
Subject: Re: [dba-VB][AccessD]  SCRUM: Northwind .NET Product BackLogPlanning Game...

> Hi SCRUM team members,
> 
> Still no e-mail with estimations from Doug.
> I have asked him today again to make the estimation worksheet and to send it to me for me to make and to publish combined worksheet.
> 
> Let's wait for today, and if the estimations from Doug will not come we can start discussion based on our estimations and then Doug will join us?
> 
> Thank you.
> 
> --
> Shamil
> 
> > 
> > -----Original Message-----
> > From: John W Colby <jwcolby at gmail.com>
> > To: Salakhetdinov Shamil <mcp2004 at mail.ru>, "Discussion concerning
> > Visual Basic and related programming issues."
> > <dba-vb at databaseadvisors.com>
> > Date: Tue, 17 Mar 2009 13:23:16 -0400
> > Subject: Re: [dba-VB] SCRUM: Northwind .NET Product BackLog Planning
> > Game...
> > 
> > > That sounds good to me also.
> > > 
> > > John W. Colby
> > > www.ColbyConsulting.com
> > > 
> > > 
> > > 
> > > Salakhetdinov Shamil wrote:
> > > > Hi SCRUM team at all,
> > > >  
> > > > I have got ProductBacklog items estimations from Mike, Gustav, John
> > and myself.
> > > >
> > > > I'm waiting for estimations to come from Doug. He has just informed
> > me he has important private events today, and it may happen he will not
> > have time to make his estimations.
> > > >
> > > > What we can do now? I'd propose to wait for Doug's estimations to
> > come, and meanwhile start constructive discussion how we can get this
> > project developed in context when we have different .NET experience but
> > taking into account that most of the work to do is simple for
> > experienced developers(whatever modern developmen tools they use) mainly
> > design and almost no coding work. At least it looks so from here (as
> > shown in some samples I have posted already on MS Live dba-VB Group's
> > SkyDrive).
> > > >
> > > > I'd expect that adding some simple introductory tutorials consisting
> > mainly from screenshots we should be able to get the team members
> > beginning their .NET development practice skilled enough to develop any
> > NorthWind .NET form or report...
> > > >
> > > > I suppose we plan develop *not* "industry strong" .NET application
> > in this project but a sample .NET Winform desktop application. When that
> > done we can go further... where? we will decide as we proceed...
> > > >
> > > > When I will get estimations from Doug I plan to post all of our
> > estimations here - is that OK with you? 
> > > > I must say the current estimations do differ considerably therefore
> > there is some work to do in coordinating them.
> > > > In SCRUM four hours are usually spent for the ProductBackLog initial
> > planning: I'd propose to "spread" these four hours within this week
> > discussion IOW no still real C# development within this week but
> > discussing ProductBacklog and planning first SCRUM Sprint and related
> > issues, and starting real development next Monday - OK?
> > > >
> > > > Thank you.
> > > >
> > > > --
> > > > Shamil
> > > >
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Salakhetdinov Shamil <mcp2004 at mail.ru>
> > > > To: "Discussion concerning Visual Basic and related programming 
> > > > issues."<dba-vb at databaseadvisors.com>
> > > > Date: Mon, 16 Mar 2009 19:15:09 +0300
> > > > Subject: Re: [dba-VB]SCRUM: Northwind .NET Product BackLog Planning
> > Game...
> > > >
> > > >   
> > > >> Hi SCRUM team at all,
> > > >>
> > > >> I have got ProductBacklog items estimations from Mike.
> > > >> I have made mine over weekend.
> > > >>
> > > >> Waiting here for estimations from Gustav, Doug and John to come
> > today then I will immediately post all of them here to start
> > coordination of our estimations for everybody to get comfortable with
> > them, and to present them after coordination to ProductOwner (Mark) to
> > plan implementation/release...
> > > >>
> > > >> Thank you.
> > > >>
> > > >> --
> > > >> Shamil
> > > >>
> > > >> -----Original Message-----
> > > >> From: Salakhetdinov Shamil <mcp2004 at mail.ru>
> > > >> To: dba-VB <dba-vb at databaseadvisors.com>
> > > >> Date: Sat, 14 Mar 2009 21:21:13 +0300
> > > >> Subject: [dba-VB] SCRUM: Northwind .NET Product BackLog Planning
> > Game...
> > > >>
> > > >>     
> > > >>> Hi SCRUM Team,
> > > >>>
> > > >>> Please estimate "ideal hours" to develop our first project product
> > backlog items using "SCRUM planning poker cards" with the following
> > values:
> > > >>>
> > > >>> 0, 1/2, 1, 2, 3, 5, 8, 13, 20, ???
> > > >>>
> > > >>> Please send your estimations to me (Shamil.Salakhetdinov AT
> > gmail.com) to make here a common worksheet with all the estimations to
> > use them on the next estimation round.
> > > >>>
> > > >>> Please do not post your estimations here on this first round to 
> > > >>> make first round estimantions as independent as possible - 
> > > >>> http://www.crisp.se/planningpoker/
> > > >>>
> > > >>> Below is the list of BackLog items with some estimations I made - 
> > > >>> just as examples. Three question marks estimation means that it's 
> > > >>> unclear how much time it will take to make that item implemented 
> > > >>> (Here it's a pivot form, which doesn't have built-in direct 
> > > >>> correspondence in .NET WinForms hence it's unclear what we will do
> > 
> > > >>> here and how much time this work will take. If you know the answer
> > 
> > > >>> - please make your more definitive estimation for this item.)
> > > >>>
> > > >>> I made my below several estimations assuming we will use built-in
> > WinForms features as in samples I used previously.
> > > >>>
> > > >>> I have made my own estimation of all the items already - it looks
> > like we should fit well 100 hours (20x5). 
> > > >>>
> > > >>> Please ask your questions.
> > > >>> Please make your estimations.
> > > >>>
> > > >>> You can download workbook with BackLog items here:
> > > >>>
> > > >>> https://cid-000971dc34dc18c0.groups.skydrive.live.com/self.aspx/.D
> > > >>> ocuments/NorthWind.NET/SCRUM%7C_Planning%7C_Game.xls?ccr=365
> > > >>>
> > > >>> or here:
> > > >>>
> > > >>> http://www1.atwiki.com/dba-vb/pages/5.html 
> > > >>> (http://www1.atwiki.com/dba-vb?cmd=upload&act=open&pageid=5&file=S
> > > >>> CRUM_Planning_Game.xls)
> > > >>>
> > > >>>
> > > >>> Thank you.
> > > >>>
> > > >>> --
> > > >>> Shamil
> > > >>>
> > > >>> P.S.
> > > >>>
> > > >>>
> > > >>> FORMS
> > > >>> =====
> > > >>>
> > > >>> 1	 Categories	
> > > >>> 2	 Customer Labels Dialog =>	1
> > > >>> 3	 Customer Orders	
> > > >>> 4	 Customer Orders Subform1 => 1
> > > >>> 5	 Customer Orders Subform2	
> > > >>> 6	 Customer Phone List	
> > > >>> 7	 Customers => 2
> > > >>> 8	 Employees => 5
> > > >>> 9	 Main Switchboard	
> > > >>> 10	 Orders	
> > > >>> 11	 Orders Subform => 1
> > > >>> 12	 Product List	
> > > >>> 13	 Products	
> > > >>> 14	 Quarterly Orders	
> > > >>> 15	 Quarterly Orders Subform	
> > > >>> 16	 Sales Analysis =>	???
> > > >>> 17	 Sales Analysis Subform1 => ???
> > > >>> 18	 Sales Analysis Subform2 => ???
> > > >>> 19	 Sales by Year Dialog	
> > > >>> 20	 Sales Reports Dialog	
> > > >>> 21	 Startup	
> > > >>> 22	 Suppliers
> > > >>>
> > > >>> REPORTS
> > > >>> =======	
> > > >>> 1	 Alphabetical List of Products	=> 2
> > > >>> 2	 Catalog	
> > > >>> 3	 Catalog Subreport	
> > > >>> 4	 Customer Labels	
> > > >>> 5	 Employee Sales by Country	
> > > >>> 6	 Invoice	=> 5
> > > >>> 7	 Products by Category	
> > > >>> 8	 Sales by Category	
> > > >>> 9	 Sales by Category Subreport	
> > > >>> 10	 Sales by Year	
> > > >>> 11	 Sales by Year Subreport	
> > > >>> 12	 Sales Totals by Amount	
> > > >>> 13	 Summary of Sales by Quarter	
> > > >>> 14	 Summary of Sales by Year	
> > > >>>
> > > >>> _______________________________________________
> > > >>> dba-VB mailing list
> > > >>> dba-VB at databaseadvisors.com
> > > >>> http://databaseadvisors.com/mailman/listinfo/dba-vb
> > > >>> http://www.databaseadvisors.com
> > > >>>
> > > >>>       
> > > >> _______________________________________________
> > > >> dba-VB mailing list
> > > >> dba-VB at databaseadvisors.com
> > > >> http://databaseadvisors.com/mailman/listinfo/dba-vb
> > > >> http://www.databaseadvisors.com
> > > >>
> > > >>     
> > > >
> > > > _______________________________________________
> > > > dba-VB mailing list
> > > > dba-VB at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > > > http://www.databaseadvisors.com
> > > >
> > > >
> > > >   
> > > 
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 




More information about the dba-VB mailing list