ࡱ> HG #@`\p Bill Meacham Ba== , 8X@"1Arial1Arial1Arial1Arial1Arial1* MS Sans Serif1* MS Sans Serif1* MS Sans Serif1* MS Sans Serif1* MS Sans Serif1Arial1Arial1* MS Sans Serif1* MS Sans Serif1Arial1* MS Sans Serif1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0%4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)83_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_)0.0                + ) , *    A    A (@ @      Q)x   H  A H  A H A( A*8 A* A H  H A h A , A H A , A A  A h    ,  A ,` A (  a   A A      A# A A , A L A*\ A l A L A l  L A l`  a L a L  A L  A la@    @  H A#x  h A h   h A h  ( A h@ @ / A*x!@ @ / A*|!!@ @ / A*x!@@ /   h@ /   h@/ A*x@ @/   h@ /   h@ / A h@ /  A h@ /  A h@/ A h@ / Q)x@ /Q)x@/ A#x@ /  A#x@/  A!x@ /  A!x@/  A h@ /  A h@/  A h@ /  A h@ / A h@/  H/ #x/ A l/ A L/ #X/ A H/ A#x/ A$<@    A h A#8 #8  Normal_FPA Normal_Sheet18 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`! Instructions!%Standard Levels of EffortR0 Feature Point Detail Body;8   ;<   ; title; `io XTotal Data TablesReportsUsability Design.Following are the definitions of complexity 1:ZTabular format, no calculations other than column totals; effort includes underlying query\Small; single page, one record or few enough records to be able to display them all at once.QDoes not require Next and Previous buttons. If it does, the complexity is higher.7If the page includes a chart, the complexity is higher.`One table, no joins, simple Where clause, no need for record control -- i.e., the result set can_be processed all at once, no need for saving one's position in the cursor for Previous and NextFqueries. If the data set returned is large, the complexity is higher.5If the database is updated, the complexity is higher.<Small, single page, not too long or wide to fit on a screen. Other notes:VolumeRate ComplexityDatabase TablesStandard Level of EffortTotal for Database TablesTotal for ReportsTotal for Usability DesignProject Management Subtotal: Project EstimateTotal Project Estimate Web PagesTotal for Web Pages$Determine site layout and navigationTNo forms or 1 form. Add 1 for each additional form. Number of links is not relevant.Report 1OtherInstallOther 1Total for Other Instructions`factor. Enter the formulas to multiply the complexity factor times the standard level of effort.how the formulas work.ZNote -- if you have a large number of features with the same complexity factor, instead ofWlisting each one, you can put them all on the same line. Put how many there are under WVolume and the complexity factor under Rate. Compute Complexity Factor = Volume * Rate.JBe sure to have someone audit the spreadsheet before you show your client!SAfter you have completed a project, update the Standard Levels of Effort to reflect Contingency(excluding proj. mgmt)\Use this spreadsheet to estimate the size of a project and the effort needed to complete it.YOn the Feature Point Detail tab, enter each feature (table, page etc.) and its complexitycThis template has a few lines filled in for each section in the feature point detail so you can see>Fewer than 20 columns, three or fewer constraints, no triggersrThis table shows the effort needed to produce one feature (table, web page etc.) that has a complexity of one (1). Staff Weeks Staff MonthsTotal for All Components Documentation Documents Document 1Total for DocumentsTechnology: TBDyour experience. Req. Analysis UI Design System DesignCodeTestDocument & Train-Standard Levels of EffortTThis spreadsheet includes seven development phases. If you want to change the phase[names, do so on both the Standard Levels of Effort tab and on the Feature Point Detail tab.;do a feature (table, program, etc.) of complexity factor 1.\On the Standard Levels of Effort tab, enter your estimate of how much effort it will take toNOTE -- These assumptions are assumptions!"illustrative only. Enter your ownRequirements analysis is lowbecause we assume a lot of ithas already been done by thetime you get here. This is toestimate the time needed forimplementation.XThis includes both the layout of the page and the underlying logic to query the database Simple tablesMore complex tables Simple pages Complex pages Medium pages Hrs / Week:Wks/Mo:Z9 W(yL J   #@ #o%  dMbP?_*+%&A&#&LVersion 3.0&CPage &P of &N&R&D &TMHP LaserJet 5MP - Copier Room@gXX@MSUDOHP LaserJet 5MP<d "dXX??U ;         D# - C D F E . $ / % & ' ( ) F*EEEEEEEE F:FFFFFFFF$T,(>@7 #@ !'/0  dMbP?_*+%&C&A'$&LVersion 3.0&CPage &P of &N&R&D &T&Q?'Q?MHP LaserJet 5MP - Copier Room@g,,@MSUDOHP LaserJet 5MP<d "c,,??U} !                                  B  mG 1  I  H N; N< N= N> N? N N@ O ~ ?$?????M@  -(  J ~ ?$@@@??M$@  K ~ @M@   L ~ ?$@@@??M$@  M 5  ??  ?? M@ N   M O    0  P                  BXp{g{S      ">@7 #@ $2PQhcpgxkl  dMbP?_*+%/&C&A63&L Version 1.0&CPage &P of &N&R&D &T&Q?'Q?MHP LJ5 Copier Room@g ,,@MSUDOHP LaserJet 5MP<d "d,,??U} } &0} $0} 0} }  I} } I*} $ Column B,   " @ @ @ @ @ @       @ @       @ @ @ @      N P9 N N N N; N< N= N> N? N N@ O #HQRS!! :% G TUV&?Z&Z&?Z&?Z &? Z &? Z &? Z# ;@ % ('IWXY lA lA lA lA  lA  lA  lA < QZ?[?!W? DD(? LL@((?(?  LL@ (?  (?  (? # <@ %  RZ?[@!W@ DD(@((?(@ (?  (?  (? # < @ % ' WXY lA lA lA lA  lA  lA  lA <j k \]Yg@   -pg g? g@  g?  g?  g? # g(@ %  HQRY(((((((=  % G TUV &? Z & Z &@ Z &@ Z &@ Z &? Z &? Z# ;$@ %   +JQRY lA lA lA lA lA lA lA = , JS Z?[?! W? D D  (?    LL @" (  D D @" (@  D D @" (@  D D @" (@ D D @ (?    LL @ (?  # <$@- %   , JU Z?[@! W@  D D  (@   (   (@  " ((@  D D @" (@ D D @ (?   (?  # <>@ %   , JT Z?[@! W@  D D  (@  (  ($@ " (4@ D D @" ($@ D D @ (@   (@  # <I@ %  'HQRY lA lA lA lA  lA  lA  lA >j k ^_Yg"@  -pgg2@gB@ g2@  g@  g@ # hV@ %  #K`aY(()))))< % G bcV&Z&@Z&Z&Z & Z & Z & Z# ;@ % IWXY lA lA lA lA  lA  lA  lA < ,JZ?[?!W?  DD)  LL@)@)) )  )  ) # <@ % 'HQRY lA lA lA lA  lA  lA  lA =i f ^_Yg  -pg@gg g  g  g # h@ %  #K`aY(()))))< % G bcV&?Z&Z&@Z&@Z &@ Z &? Z &? Z# ;$@ % IWXY lA lA lA lA  lA  lA  lA < IZ?[?!W? DD(?  LL@((@(@ (@  (?  (? # <$@ % 'HQRY lA lA lA lA  lA  lA  lA =j k ^_Yg?  -pgg@g@ g@  g?  g? # h$@ %  +JWXY(((((((= #6K`aY(()))))< % G bcV& Z & Z &? Z &? Z  & Z  &? Z  &? Z # ;@ % IWXY lA lA lA lA  lA  lA  lA <Dl.6SC06aaC06mC06lC$06 !"#$%&'()* +,-./0123456@7@8@ 9@:@;@<@=@>@?@ , J7 Z?[?! W? D D  )"    LL@ )"  )?"  )?"  )"   )?"   )?"  # <@ %  !'HQRY !lA !lA !lA !lA ! lA ! lA ! lA! ="i "f8 "^_Y"g%"""  -p"g%""g?%""g?%"" g% "" g?% "" g?% "#" h@ %""  #+JWXY(((((((= $n$K`aY(()))))< %% %G %bcV%&'Z %&'Z %&'Z %&'Z % &' Z % &' Z % &' Z #% ;" %%% &IWXY &lA &lA &lA &lA & lA & lA & lA& <', 'J!'Z?[?!'W?  D'D'"')) D'D%@'))'''  LL%@'))''))'' )) '' )) '' )) '#' <% %'' ('HQRY (lA (lA (lA (lA ( lA ( lA ( lA( =)i )f" )^_Y)g,)))  -p)g,))g,))g,)) g, )) g, )) g, )#) h' %))  *+JWXY///////? +$L`dY--.....> ,e ,f4 ,`aY,g*@,-,, #LLLLLL,g@,,g6@,,gF@ ,, g5@ ,, g@ ,, g@, ,#, h^@1 %,, ,)-0=-1?) 'D,  D,D, B-1?--1-- 'L  LL B-1?---1wwwwww?--- 1?--- 1?- -- 1?- -#- @? %-- - 2.011111 . 2!. A@/ D, D//0 /oV~ /)D@ /111 / 3!/ <5eMYS?- D. D1000)11111A 10 1pW~ 1z@1, 1~ 1 3.@"1 <2@3 D, D1 202 4,5B 26630 3"3 B@a@4 D, D1  37740 4 2!4 A @5 D3 D/ 47750 5 3!5 <lʚ?7 D4 D1 57760 6+6 <70 7,~ 7 8?"7 ;>@8 D7 D, 80 8"8 Ce@: D3 D7 8,909 <:0 : 2": <@; D8 D/;0 ; 3!; <}A?. D: D1<0< 9=0>0?0DlmC$06tC$$ckIi"r*LKK"LH>= @@A@B@C@D@E@F@G@H@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@@0A0B0C0D0E0F0G0H0I0J0K0L0M0N0O0P0Q0R0S0T0U0V0W0X0Y0Z0[0\0]0^0_0Dl `@a@b@c@d@e@f@g@h@i@j@k@l@m@n@o@p@q@r@s@t@u@v@w@x@y@z@{@|@}@~@@`0a0b0c0d0e0f0g0h0i0j0k0l0m0n0o0p0q0r0s0t0u0v0w0x0y0z0{0|0}0~00Dl @@@000 Z( >@A 7 Oh+'04 hp   ,!Estimation Spreadsheet by Phases Exsti Bill Meachamreaillill Bill MeachamreaMicrosoft Excel@N8'@ө3'@WX՜.+,0 PXx  Bill Meacham Consulting  InstructionsStandard Levels of Effort Feature Point Detail  Worksheets  !"#$%&'()*+,-./012345689:;<=>@ABCDEFRoot Entry FWorkbooklSummaryInformation(7DocumentSummaryInformation8?