ࡱ> hl  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgjkRoot Entry F`\-.iWorkbookSummaryInformation(tDocumentSummaryInformation8 \pQATutorial.com Ba=.$   !"# ThisWorkbook/ϯ=xf0"8@"1Arial1Arial1Arial1Arial1Arial1)Arial1Arial1 Arial1$Arial1Arial1Arial1Arial1Arial1.Times New Roman1.Times New Roman1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##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\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"                                                                      ff + ) , *      P  P         `           ! a> " x@ @ /   ""@ @ *  @ @  x@ @ /  @ @  `@ @  @ @     h""@ @ ,  h""@ @ , (x@ @  (0@ @   h@ @  (x@ @        """@ @ * ||TU@}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}/ 00\);_(*}A}1 a00\);_(*;_(@_) }A}2 00\);_(*;_(@_) }A}3 00\);_(*?;_(@_) }A}4 00\);_(*23;_(@_) }-}5 00\);_(*}}7 ??v00\);_(*̙;_(@_)    }A}8 }00\);_(*;_(@_) }A}9 e00\);_(*;_(@_) }x}:00\);_(*;_(  }}; ???00\);_(*;_(??? ???  ??? ???}-}= 00\);_(*}U}> 00\);_(*;_( }-}? 00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`/FProjectDetailsI EffortSummaryVTest Requirements] Test Plan)bAutomatedTestAnalysisfTest Data Design"jBlack Box Test Case Design"qWhite Box Test Case Design{tQTP Test Script DesignwQTP Test Script Coding{White Box Test Coding~Test Data ScriptingTest Environment Setup&Manual Test Execution(Desktop)&HManual Test Execution(Devices)%ӕAutomated Test Exec (Desktop)%^Automated Test Exec (Devices)%Manual V&V Test Exec(Desktop)%vManual V&V Test Exec(Devices)'Manual Regression Test(Desktop)'Manual Regression Test(Devices)% Automated Regression(Desktop)%Automated Regression(Devices)g[ ReferencesComment AssumptionsRisksRemarks!Internal Review (in Person Hours)qEffort for Preparing Test Requirements document (Functional/performance/Security/Compatibility) (in Person Hours)!External Review (in Person Hours)"Projected Rework (in Person Hours) Total Estimate (in Person Hours)5Test Requirement Document for Project < ProjectName > Feature NameiEffort for Preparing Test Plan document (Functional/performance/Security/Compatibility) (in Person Hours)@Test Plan Document for Project [ Master Test Plan ] / Features MProductivity figures ( Past Data: 3 to 4 test cases / tests per person hour )Workflow: It is defined as a set of test items, which have corresponding QTP scripts. Each QTP script represents an automated test scenario. dEffort for Preparing Test Case document (in Person Hours) ( Effort = Size divided by Productivity )Risk Buffer ( in Person Hours )dEffort for creating & modifying the test harness scripts for integrating Test data Scripts (in hrs)Estimates Prepared ByEstimates Reviewed ByEstimates Approved By< Project Name >Test Data DesignAutomated Test AnalysisBlack Box Test Case DesignWhite Box Test Case DesignWhite Box Test CodingTest Data ScriptingTest Environment SetupManual Test Execution (Devices)"Automated Test Execution (Desktop)"Automated Test Execution (Devices)#Manual V&V Test Execution (Desktop) Manual Regression Test (Desktop) Manual Regression Test (Devices)Automated Regression (Desktop)Automated Regression (Devices)ActivityEffort in Person Hours#Manual V&V Test Execution (Devices)S.No"GRAND TOTAL EFFORT IN PERSON HOURSTest Requirements DocumentTest Plan DocumentWorksheet Number_Estimate Applicable for this activity in this project and Covered in this workbook ( Yes / No )Test Cases / Tests: This is lowest possible testing unit, denotes one unique action (with i/p data variations) according to NCoE usage.Test Data: Data that is used for carrying out testing (Manual or Automated). For example, test data pertains to Email content, PIM content or Admin Settings for N1BS. Glossary/Productivity ( 3 to 4 classes per person hour )|Size Total # of Asserts per class (A1) Total # of i/o for total no. of test cases(Asserts) Per class (A2) Here A=A1+A2 FEffort for Preparing White Box Test Design document (in Person Hours)zEffort for Identifying Test data (Test data pertaining to Functional/Performance/Security/Compatibility) (in Person Hours)Size (Source Lines Of Code) BEffort for IMPLEMENTING/CODING QTP Test Reports (in Person Hours) SProductivity for Implementing QTP Scripts. (10 QTP Source Lines of Code per hour )nProductivity for Implementing JUNIT Test Scripts. 60 Lines of JUnit Code/Day with (all asserts and comments) 9Effort for White Box JUnit Test Coding (in Person Hours)?Effort for writing Test data creation macros (in Person Hours)aEstimated Effort for Setting up Test Environment for Manual and Automated Testing (in Person Hrs)LEffort for ExecutingTest Cases (Manual Testing on Desktop) (in Person Hours)3Productivity ( 5 to 6 Test Cases per person hour )Size (Number of Test Cases)LEffort for ExecutingTest Cases (Manual Testing on Devices) (in Person Hours)>Productivity ( 3 to 4 Test Cases per person hour on Devices )@Productivity ( 40 to 50 Test Cases per person hour on Desktop )REffort for Executing Test Cases - Automated Testing on Desktop (in Person Hours)6Productivity ( Not yet available. To be determined. )\Effort for Executing Test Cases - Automated Testing on Device Simulators (in Person Hours)REffort for Executing V& V Test Cases (Manual Testing on Desktop) (in Person Hours)SEffort for Executing V & V Test Cases (Manual Testing on Devices) (in Person Hours)XEffort for Executing Regression Test Cases (Manual Testing on Devices) (in Person Hours)XEffort for Executing Regression Test Cases (Manual Testing on Desktop) (in Person Hours)bEffort for Executing Automated Regression testing for Device (Automated testing) (in Person Hours)7Productivity ( Not yet available. To be determined. ) @Productivity ( 40 to 50 Test Cases per person hour on desktop )ZEffort for Executing Automated Regression testing for Desktop (Automated testing) (in hrs)Effort for Logging and Reporting Regression Test execution results. (in Person Hours) [ Productivity for logging defects: 4 to 5 defects can be logged in one person hour ]Effort for Logging and Reporting Test execution results. (in Person Hours) [ Productivity for logging defects: 4 to 5 defects can be logged in one person hour ]'Total Effort Estimate (in Person Hours)JEffort for Identifying Automated Test Workflows (QTP) (in Person Hours) Productivity (To Be Determined)@Effort for Designing QTP Test Scripts/Reports (in Person Hours) "Size ( Number of QTP scripts ) %Size ( number of Test Cases / Tests )Manual Test Execution (Desktop)QTP Test Script DesignQTP Test Script CodingSoftware Test Estimation.docb`1 3235s6C7F8X;; > 5@/CEccB   EGH  dMbP?_*+%&?'?(?)?"B??en&U} "} .            SS IJ JB JI JB JI JB JJ J Z|>@JJ 7 Sheet1ggD  /KSU  dMbP?_*+%&?'?(?)?MHP DeskJet 500C Printer(,,A^|"d,??&U} } "} I } } /@@     @@ K* K' K. K/ K(~ C? L,~ L@ LL~ C@ L-~ L@ LL~ C@ L~ L@ LL~ C@ L~ L@ LL~ C@ L~ L@ LL~ C@ L~ L @ LL~ C@ LX~ L"@ LL~ C @ LY~ L$@ LL~ C"@ L~ L&@ LL~ C$@ L~ L(@ LL~ C&@ L~ L*@ LL~ C(@ LW~ L,@ LL~ C*@ L~ L.@ LL~ C,@ L ~ L0@ LL~ C.@ L!~ L1@ LL~ C0@ L"~ L2@ LL~ C1@ L)~ L3@ LL~ C2@ L#~ L4@ LL~ C3@ L$~ L5@ LL~ C4@ L%~ L6@ LL~ C5@ L&~ L7@ LLN O+ OO OMMMMMMMMBXF8888888888888888888884  !"#$%&'()*+,-. M!M"M#M$M%M&M'M(M)M*M+M,M-M.M" >@    7ggD  Z\  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} I}  }  }    rA     D D D D D DQ D D DE EE EE F GGGCCCCCCCCCCCCCCCCCCCCCCCCCCCP~X>@CB  7ggD   $^a  dMbP?_*+%&?'?(?)?"??&U} I} } } }  } $}  } }  } } } } m }    @          D D D D D D D D DE EE EE F GGGCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCC~~X>@CB  7 Sheet3ggD   ?ce  dMbP?_*+%&?'?(?)?"??&U} m} } I } m } $   F          D DR D D D DQ D D DEEEEE F GGGCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCX~2>@CB  7 Sheet4ggD   gnj  dMbP?_*+%&?'?(?)?"??&U} I } } $ }  } I } }    F          D D6 D D D DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCB~>@CB  7ggD  lPp  dMbP?_*+%&?'?(?)?"??&U} m} } $} m   &@                 D DV D D D D D D DQ D D DCCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC  CCCCCCCCCCCC R2 P0 QQQQQQQQQQ P1 QQQQQQQQQQQQ H QQQQQQQQQQQQ  QQ  QQ  QQ &@""""""""",00>@QRA 8     7ggD  rt  dMbP?_*+%&?'?(?)?"?? &U}  } }  } I        D D4 D3 D5 D D D D DQ D D DCCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC P""">@CB  7ggD  u}w  dMbP?_*+%&?'?(?)?"?? &U} } $ } I} m   @     D DU DS DT D D D D DQ D D DCCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC P""">@CB  7ggD   y{  dMbP?_*+%&?'?(?)?"?? &U} } m } } } I        D D7 D9 D8 D D D D DQ D D DCCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC CCCCCCCCCCCC P""">@CB  7ggD  |~  dMbP?_*+%&?'?(?)?"?? &U} } m}   @     D D7 D: D; D D D D DQ D D D @ CCCCCCCCCCCCC CCCCCCCCCCCCC CCCCCCCCCCCCC CCCCCCCCCCCCC P$$$>@CB  7ggD  %  dMbP?_*+%&?'?(?)?"??C&U} m} } m} }  }  }  }  } $   F     D D< D D D D DQ D D DCCCCCCCCCC CCCCCCCCCC CCCCCCCCCC CCCCCCCCCC hP>@CB  7 Sheet5ggD  ֆ(  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} } }  A D D= D D DCCCCCCCCCCCCCCCCCCCCPF>@CB  7 Sheet6ggD  ٌÎ  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m}  } m }  } } $ } }    A     D D@ D? D> DP DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet7ggD  tN  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} } $ } $ }  } I}  }    @     D D@ DB DA DP DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet8ggD  ٛ  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} } } $ }  } } I }    zA     D D@ DC DD DP DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet9ggD  d  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} } I} } } $ }    @     D D@ DE DF DP DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet10ggD    dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} m} m }  } }  }    A A    D D@ D? DG DP DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet11ggD  |  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} m} m } m } $} }    DA A    D D@ DB DH DP DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet12ggD  .  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} m} m } $ } $} }    A A    D D@ D? DJ DO DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet13ggD    dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} m} m } } }    A A    D D@ DB DI DO DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet14ggD  6  dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} m } } }  }    A     D D@ DM DN DO DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet15ggD    dMbP?_*+%&?'?(?)?MHP LaserJet 8100 Series PCL4C odXXLetter DINU"4:"dXX??&U} m} m} m } I } $} m }    @A     D D@ DL DK DO DQ D D DCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCRP~>@CB  7 Sheet16ggD  Oh+'0D `h   $ 0<$Software Test Estimation WorkBook$Software Test Estimation WorkBookQATutorial.comQATutorial.com2010Microsoft Excel@3@?s@5.՜.+,0x X`x  SQATutorial.comQATutorial.com ProjectDetailsEffortSummaryTest Requirements Test PlanAutomatedTestAnalysisTest Data DesignBlack Box Test Case DesignWhite Box Test Case DesignQTP Test Script DesignQTP Test Script CodingWhite Box Test CodingTest Data ScriptingTest Environment SetupManual Test Execution(Desktop)Manual Test Execution(Devices)Automated Test Exec (Desktop)Automated Test Exec (Devices)Manual V&V Test Exec(Desktop)Manual V&V Test Exec(Devices) Manual Regression Test(Desktop) Manual Regression Test(Devices)Automated Regression(Desktop)Automated Regression(Devices)  Worksheets F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObjr