A Practical Approach to Computer Systems Design and Architecture

Nirosh
Rate me:
4.69/5 (121 votes)
11 Dec 2013CPOL40 min read
450.2K
1.2K
414
This article gives an introduction to system designing and architecture. It introduces a new concept that allows beginners to easily break and design complex software systems. It uses a modular based development approach with a pattern that we all practice in our day to day life.
project_estimate.zip
- Desktop
  - Project_Estimate.htm
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<link rel=File-List href="./Project_Estimate_files/filelist.xml">
<link rel=Edit-Time-Data href="./Project_Estimate_files/editdata.mso">
<link rel=OLE-Object-Data href="./Project_Estimate_files/oledata.mso">
<title>Software Project Estimate</title>
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Subject>Estimation and Costing</o:Subject>
  <o:Author>Anil Almeida</o:Author>
  <o:LastAuthor>Anil</o:LastAuthor>
  <o:Created>2004-09-07T04:06:39Z</o:Created>
  <o:LastSaved>2004-09-09T05:57:25Z</o:LastSaved>
  <o:Version>9.3821</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:DownloadComponents/>
  <o:LocationOfComponents HRef="file://dhcp/D/msowc.cab"/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:1.0in .75in 1.0in .75in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;}
tr
	{mso-height-source:auto;}
col
	{mso-width-source:auto;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	border:none;
	mso-protection:locked visible;
	mso-style-name:Normal;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial;
	mso-generic-font-family:auto;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl24
	{mso-style-parent:style0;
	vertical-align:top;
	white-space:normal;}
.xl25
	{mso-style-parent:style0;
	mso-number-format:Standard;
	vertical-align:top;
	white-space:normal;}
.xl26
	{mso-style-parent:style0;
	text-align:left;
	vertical-align:top;
	white-space:normal;}
.xl27
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-weight:700;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl28
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-weight:700;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl29
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl30
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl31
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-weight:700;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl32
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	mso-number-format:"\0022$\0022\#\,\#\#0\.00";
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl33
	{mso-style-parent:style0;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl34
	{mso-style-parent:style0;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	mso-number-format:Standard;
	text-align:left;
	vertical-align:top;
	white-space:normal;
	padding-left:12px;
	mso-char-indent-count:1;}
.xl35
	{mso-style-parent:style0;
	font-size:8.0pt;
	vertical-align:top;
	white-space:normal;}
.xl36
	{mso-style-parent:style0;
	font-size:8.0pt;
	mso-number-format:Standard;
	vertical-align:top;
	white-space:normal;}
.xl37
	{mso-style-parent:style0;
	font-size:8.0pt;
	text-align:left;
	vertical-align:top;
	white-space:normal;}
.xl38
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-weight:700;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	vertical-align:top;
	white-space:normal;}
.xl39
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-weight:700;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	text-align:right;
	vertical-align:top;
	white-space:normal;}
.xl40
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-weight:700;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	mso-number-format:Standard;
	vertical-align:top;
	white-space:normal;}
.xl41
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:center;
	vertical-align:top;
	white-space:normal;}
.xl42
	{mso-style-parent:style0;
	text-align:center;
	vertical-align:top;
	white-space:normal;}
.xl43
	{mso-style-parent:style0;
	font-size:18.0pt;
	font-weight:700;
	text-decoration:underline;
	text-underline-style:single;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:center;
	vertical-align:top;
	white-space:normal;}
.xl44
	{mso-style-parent:style0;
	font-size:16.0pt;
	font-weight:700;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:center;
	vertical-align:top;
	white-space:normal;}
.xl45
	{mso-style-parent:style0;
	font-size:14.0pt;
	font-weight:700;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:center;
	vertical-align:middle;
	white-space:normal;}
.xl46
	{mso-style-parent:style0;
	font-size:8.0pt;
	font-family:"Palatino Linotype", serif;
	mso-font-charset:0;
	text-align:left;
	vertical-align:top;
	white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Abstract</x:Name>
    <x:WorksheetOptions>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:HorizontalResolution>600</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>22</x:ActiveRow>
       <x:ActiveCol>4</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>9345</x:WindowHeight>
  <x:WindowWidth>15180</x:WindowWidth>
  <x:WindowTopX>120</x:WindowTopX>
  <x:WindowTopY>60</x:WindowTopY>
  <x:TabRatio>530</x:TabRatio>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple class=xl24>

<table x:str border=0 cellpadding=0 cellspacing=0 width=1461 style='border-collapse:
 collapse;table-layout:fixed;width:1098pt'>
 <col class=xl24 width=50 style='mso-width-source:userset;mso-width-alt:1828;
 width:38pt'>
 <col class=xl24 width=177 style='mso-width-source:userset;mso-width-alt:6473;
 width:133pt'>
 <col class=xl24 width=47 style='mso-width-source:userset;mso-width-alt:1718;
 width:35pt'>
 <col class=xl24 width=70 style='mso-width-source:userset;mso-width-alt:2560;
 width:53pt'>
 <col class=xl24 width=81 style='mso-width-source:userset;mso-width-alt:2962;
 width:61pt'>
 <col class=xl24 width=77 style='mso-width-source:userset;mso-width-alt:2816;
 width:58pt'>
 <col class=xl25 width=69 style='mso-width-source:userset;mso-width-alt:2523;
 width:52pt'>
 <col class=xl25 width=92 style='mso-width-source:userset;mso-width-alt:3364;
 width:69pt'>
 <col class=xl26 width=222 style='mso-width-source:userset;mso-width-alt:8118;
 width:167pt'>
 <col class=xl24 width=64 span=9 style='width:48pt'>
 <tr height=49 style='mso-height-source:userset;height:36.75pt'>
  <td colspan=9 height=49 class=xl43 width=885 style='height:36.75pt;
  width:666pt'>Software Project Estimate</td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
  <td class=xl24 width=64 style='width:48pt'></td>
 </tr>
 <tr height=32 style='mso-height-source:userset;height:24.0pt'>
  <td colspan=9 height=32 class=xl44 width=885 style='height:24.0pt;width:666pt'>Abstract</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl27 width=50 style='height:26.25pt;width:38pt'>S.N.</td>
  <td class=xl27 width=177 style='width:133pt'>Item</td>
  <td class=xl27 width=47 style='width:35pt'>Unit</td>
  <td class=xl27 width=70 style='width:53pt'>Quantity</td>
  <td class=xl27 width=81 style='width:61pt'>Role/Skill</td>
  <td class=xl27 width=77 style='width:58pt'>Man days</td>
  <td class=xl27 width=69 style='width:52pt'>Rate (INR)</td>
  <td class=xl28 width=92 style='width:69pt'>Amount (INR)</td>
  <td class=xl27 width=222 style='width:167pt'>Remarks</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>1</td>
  <td class=xl29 width=177 style='width:133pt'>Visionary doc</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D27">1</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=F27*D27">2</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000" x:fmla="=+H4/F4">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="8000" x:fmla="=H27">8,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>2</td>
  <td class=xl29 width=177 style='width:133pt'>Workflows/Subworkflows</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D28">55</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=F28*D28">55</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000" x:fmla="=+H5/F5">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="220000" x:fmla="=H28">220,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>3</td>
  <td class=xl29 width=177 style='width:133pt'>Use cases</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D29">50</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=F29*D29+F57*D57">250</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3200" x:fmla="=+H6/F6">3,200.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="800000" x:fmla="=H29+H57">800,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>4</td>
  <td class=xl29 width=177 style='width:133pt'>Objects in hierarchy tree</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D30">210</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=F30*D30+F55*D55">262.5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3200" x:fmla="=+H7/F7">3,200.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="840000" x:fmla="=H30+H55">840,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>5</td>
  <td class=xl29 width=177 style='width:133pt'>Technology</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>10</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F31*D31+F43*D43">5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4700" x:fmla="=+H8/F8">4,700.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="23500" x:fmla="=H31+H43">23,500.00</td>
  <td class=xl29 width=222 style='width:167pt' x:str="gathering+analysis ">gathering+analysis
  </td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>6</td>
  <td class=xl29 width=177 style='width:133pt'>Non-functional req doc</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D32">1</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F32*D32">2</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000" x:fmla="=+H9/F9">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="8000" x:fmla="=H32">8,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 colspan=2 class=xl27 style='height:13.5pt;mso-ignore:colspan'></td>
  <td colspan=4 class=xl29 style='mso-ignore:colspan'></td>
  <td colspan=2 class=xl30 style='mso-ignore:colspan'></td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>7</td>
  <td class=xl29 width=177 style='width:133pt'>Tiers</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D38">4</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F38*D38">2</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000" x:fmla="=+H11/F11">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="10000" x:fmla="=H38">10,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>8</td>
  <td class=xl29 width=177 style='width:133pt'>Activity diagrams</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D39">100</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F39*D39+F53*D53">1050</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3047.6190476190477"
  x:fmla="=+H12/F12">3,047.62</td>
  <td class=xl30 width=92 style='width:69pt' x:num="3200000" x:fmla="=H39+H53">3,200,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>9</td>
  <td class=xl29 width=177 style='width:133pt'>Flowchart/Processes</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D40">100</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F40*D40+F52*D52">800</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000" x:fmla="=+H13/F13">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="2400000" x:fmla="=H40+H52">2,400,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>10</td>
  <td class=xl29 width=177 style='width:133pt'>Components</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D41">7</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F41*D41+F59*D59">98</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000" x:fmla="=+H14/F14">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="392000" x:fmla="=H41+H59">392,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>11</td>
  <td class=xl29 width=177 style='width:133pt'>Objects in framework tree</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D42">150</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F42*D42+F42*D42">300</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3500" x:fmla="=+H15/F15">3,500.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="1050000" x:fmla="=H42+H56">1,050,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 colspan=6 class=xl29 style='height:13.5pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl30 style='mso-ignore:colspan'></td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>12</td>
  <td class=xl29 width=177 style='width:133pt'>Deployment</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D44">2</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F44*D44+F58*D58">22</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3181.818181818182"
  x:fmla="=+H17/F17">3,181.82</td>
  <td class=xl30 width=92 style='width:69pt' x:num="70000" x:fmla="=H44+H58">70,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>13</td>
  <td class=xl29 width=177 style='width:133pt'>Test case designs</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D45">400</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F45*D45+F54*D54">500</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3200" x:fmla="=+H18/F18">3,200.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="1600000" x:fmla="=H45+H54">1,600,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>14</td>
  <td class=xl29 width=177 style='width:133pt'>Tools Requirement</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num x:fmla="=D46">6</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F46*D46">3</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000" x:fmla="=+H19/F19">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="15000" x:fmla="=H46">15,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>15</td>
  <td class=xl29 width=177 style='width:133pt'>User Acceptance Testing</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>1</td>
  <td class=xl29 width=81 style='width:61pt'>n/a</td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=+F60*D60">900</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000" x:fmla="=+H20/F20">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="2700000" x:fmla="=H60">2,700,000.00</td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl27 style='height:13.5pt'></td>
  <td class=xl29></td>
  <td colspan=4 class=xl27 style='mso-ignore:colspan'></td>
  <td class=xl28></td>
  <td class=xl30></td>
  <td class=xl27></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl27 style='height:13.5pt'></td>
  <td class=xl27 width=177 style='width:133pt'>total</td>
  <td class=xl29></td>
  <td class=xl27></td>
  <td class=xl29></td>
  <td class=xl27 width=77 style='width:58pt' x:num x:fmla="=SUM(F4:F20)">4251.5</td>
  <td class=xl28 width=69 style='width:52pt' x:num="3136.8928613430553"
  x:fmla="=+H22/F22">3,136.89</td>
  <td class=xl28 width=92 style='width:69pt' x:num="13336500"
  x:fmla="=SUM(H4:H20)">13,336,500.00</td>
  <td class=xl31 width=222 style='width:167pt' x:num="296366.66666666669"
  x:fmla="=+H22/45">$296,366.67</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 style='height:13.5pt'></td>
  <td class=xl29 width=177 style='width:133pt'>Add Risk Factor</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>3</td>
  <td colspan=2 class=xl29 style='mso-ignore:colspan'></td>
  <td class=xl30 width=69 style='width:52pt' x:num>1.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="40009500" x:fmla="=+H22*D23">40,009,500.00</td>
  <td class=xl32 width=222 style='width:167pt' x:num="889100" x:fmla="=+H23/45">$889,100.00</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=20 style='height:15.0pt'>
  <td height=20 colspan=6 class=xl33 style='height:15.0pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl34 style='mso-ignore:colspan'></td>
  <td class=xl33></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=32 style='mso-height-source:userset;height:24.0pt'>
  <td colspan=9 height=32 class=xl45 width=885 style='height:24.0pt;width:666pt'>Requirements
  Gathering</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=42 style='mso-height-source:userset;height:31.5pt'>
  <td height=42 class=xl27 width=50 style='height:31.5pt;width:38pt'>S.N.</td>
  <td class=xl27 width=177 style='width:133pt'>Item</td>
  <td class=xl27 width=47 style='width:35pt'>Unit</td>
  <td class=xl27 width=70 style='width:53pt'>Quantity</td>
  <td class=xl27 width=81 style='width:61pt'>Role/Skill</td>
  <td class=xl27 width=77 style='width:58pt'>Man days/Unit</td>
  <td class=xl28 width=69 style='width:52pt'>Rate</td>
  <td class=xl28 width=92 style='width:69pt'>Amount</td>
  <td class=xl27 width=222 style='width:167pt'>Remarks</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>1</td>
  <td class=xl29 width=177 style='width:133pt'>Visionary doc</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>1</td>
  <td class=xl29 width=81 style='width:61pt'>BA</td>
  <td class=xl29 width=77 style='width:58pt' x:num>2</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="8000" x:fmla="=D27*F27*G27">8,000.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>2</td>
  <td class=xl29 width=177 style='width:133pt'>Workflows/Subworkflows</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>55</td>
  <td class=xl29 width=81 style='width:61pt'>BA</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="220000"
  x:fmla="=D28*F28*G28">220,000.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>3</td>
  <td class=xl29 width=177 style='width:133pt'>Use cases (major only)</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>50</td>
  <td class=xl29 width=81 style='width:61pt'>BA</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="200000"
  x:fmla="=D29*F29*G29">200,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>user interface, user process
  components</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>4</td>
  <td class=xl29 width=177 style='width:133pt'>Objects in hierarchy tree</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>210</td>
  <td class=xl29 width=81 style='width:61pt'>Designer</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.25</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="210000"
  x:fmla="=D30*F30*G30">210,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>business components</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>5</td>
  <td class=xl29 width=177 style='width:133pt'>Technology</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>3</td>
  <td class=xl29 width=81 style='width:61pt'>BA</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="6000" x:fmla="=D31*F31*G31">6,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>IE, asp.net, sqlserver</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>6</td>
  <td class=xl29 width=177 style='width:133pt'>Non-functional req doc</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>1</td>
  <td class=xl29 width=81 style='width:61pt'>BA</td>
  <td class=xl29 width=77 style='width:58pt' x:num>2</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="8000" x:fmla="=D32*F32*G32">8,000.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 colspan=6 class=xl29 style='height:13.5pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl30 style='mso-ignore:colspan'></td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 style='height:13.5pt'></td>
  <td class=xl27 width=177 style='width:133pt'>total</td>
  <td class=xl29></td>
  <td class=xl27 width=70 style='width:53pt' x:num x:fmla="=SUM(D27:D33)">320</td>
  <td colspan=2 class=xl29 style='mso-ignore:colspan'></td>
  <td class=xl30></td>
  <td class=xl28 width=92 style='width:69pt' x:num="652000"
  x:fmla="=SUM(H27:H32)">652,000.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=20 style='height:15.0pt'>
  <td height=20 colspan=9 class=xl33 style='height:15.0pt;mso-ignore:colspan'></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=31 style='mso-height-source:userset;height:23.25pt'>
  <td colspan=9 height=31 class=xl45 width=885 style='height:23.25pt;
  width:666pt'>Requirement Analysis</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=42 style='mso-height-source:userset;height:31.5pt'>
  <td height=42 class=xl27 width=50 style='height:31.5pt;width:38pt'>S.N.</td>
  <td class=xl27 width=177 style='width:133pt'>Item</td>
  <td class=xl27 width=47 style='width:35pt'>Unit</td>
  <td class=xl27 width=70 style='width:53pt'>Quantity</td>
  <td class=xl27 width=81 style='width:61pt'>Role/Skill</td>
  <td class=xl27 width=77 style='width:58pt'>Man days/Unit</td>
  <td class=xl28 width=69 style='width:52pt'>Rate</td>
  <td class=xl28 width=92 style='width:69pt'>Amount</td>
  <td class=xl27 width=222 style='width:167pt'>Remarks</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>1</td>
  <td class=xl29 width=177 style='width:133pt'>Tiers</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>4</td>
  <td class=xl29 width=81 style='width:61pt'>Architect</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="10000" x:fmla="=D38*F38*G38">10,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>presentation, business, data
  format, data storage</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>2</td>
  <td class=xl29 width=177 style='width:133pt'>Activity diagrams</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>100</td>
  <td class=xl29 width=81 style='width:61pt'>Designer</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="200000"
  x:fmla="=D39*F39*G39">200,000.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='mso-height-source:userset;height:12.75pt'>
  <td height=17 class=xl29 width=50 style='height:12.75pt;width:38pt' x:num>3</td>
  <td class=xl29 width=177 style='width:133pt'>Flowchart/Processes</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>100</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="300000"
  x:fmla="=D40*F40*G40">300,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>workflow components</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>4</td>
  <td class=xl29 width=177 style='width:133pt'>Components</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>7</td>
  <td class=xl29 width=81 style='width:61pt'>Architect/Designer</td>
  <td class=xl29 width=77 style='width:58pt' x:num>7</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="245000"
  x:fmla="=D41*F41*G41">245,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>interfaces, controller, data
  entities</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>5</td>
  <td class=xl29 width=177 style='width:133pt'>Objects in framework tree</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>150</td>
  <td class=xl29 width=81 style='width:61pt'>Designer</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="600000"
  x:fmla="=D42*F42*G42">600,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>service interfaces, data access,
  external interface, security</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>6</td>
  <td class=xl29 width=177 style='width:133pt'>Technology</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>7</td>
  <td class=xl29 width=81 style='width:61pt'>Architect</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="17500" x:fmla="=D43*F43*G43">17,500.00</td>
  <td class=xl29 width=222 style='width:167pt'
  x:str="html, xml, jscript, c#, asp.net, sql, com+, ">html, xml, jscript, c#,
  asp.net, sql, com+, </td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>7</td>
  <td class=xl29 width=177 style='width:133pt'>Deployment</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>2</td>
  <td class=xl29 width=81 style='width:61pt'>Architect</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="10000" x:fmla="=D44*F44*G44">10,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>design</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>8</td>
  <td class=xl29 width=177 style='width:133pt'>Test case designs</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>400</td>
  <td class=xl29 width=81 style='width:61pt'>Test lead</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.25</td>
  <td class=xl30 width=69 style='width:52pt' x:num="4000">4,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="400000"
  x:fmla="=D45*F45*G45">400,000.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>9</td>
  <td class=xl29 width=177 style='width:133pt'>Tools Requirement</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>6</td>
  <td class=xl29 width=81 style='width:61pt'>Architect</td>
  <td class=xl29 width=77 style='width:58pt' x:num>0.5</td>
  <td class=xl30 width=69 style='width:52pt' x:num="5000">5,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="15000" x:fmla="=D46*F46*G46">15,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>vs.net, load runner, win runner,
  nunit, vss, xml spy</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 style='height:13.5pt'></td>
  <td class=xl27 width=177 style='width:133pt'>total</td>
  <td class=xl29></td>
  <td class=xl27 width=70 style='width:53pt' x:num x:fmla="=SUM(D38:D46)">776</td>
  <td class=xl29></td>
  <td class=xl29 width=77 style='width:58pt' x:num x:fmla="=SUM(F38:F46)">12.25</td>
  <td class=xl30></td>
  <td class=xl28 width=92 style='width:69pt' x:num="1797500"
  x:fmla="=SUM(H38:H46)">1,797,500.00</td>
  <td class=xl29></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=20 style='height:15.0pt'>
  <td height=20 colspan=6 class=xl33 style='height:15.0pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl34 style='mso-ignore:colspan'></td>
  <td class=xl33></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=20 style='height:15.0pt'>
  <td height=20 colspan=6 class=xl33 style='height:15.0pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl34 style='mso-ignore:colspan'></td>
  <td class=xl33></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td colspan=9 height=30 class=xl45 width=885 style='height:22.5pt;width:666pt'>Development
  and Testing Entities in Above Items</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=42 style='mso-height-source:userset;height:31.5pt'>
  <td height=42 class=xl27 width=50 style='height:31.5pt;width:38pt'>S.N.</td>
  <td class=xl27 width=177 style='width:133pt'>Item</td>
  <td class=xl27 width=47 style='width:35pt'>Unit</td>
  <td class=xl27 width=70 style='width:53pt'>Quantity</td>
  <td class=xl27 width=81 style='width:61pt'>Role/Skill</td>
  <td class=xl27 width=77 style='width:58pt'>Man days/Unit</td>
  <td class=xl28 width=69 style='width:52pt'>Rate</td>
  <td class=xl28 width=92 style='width:69pt'>Amount</td>
  <td class=xl27 width=222 style='width:167pt'>Remarks</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>1</td>
  <td class=xl29 width=177 style='width:133pt'>Flowchart/Processes</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>100</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>7</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="2100000"
  x:fmla="=D52*F52*G52">2,100,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>Development of the workflow
  components</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=54 style='height:40.5pt'>
  <td height=54 class=xl29 width=50 style='height:40.5pt;width:38pt' x:num>2</td>
  <td class=xl29 width=177 style='width:133pt'>Activity diagrams</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>100</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>10</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="3000000"
  x:fmla="=D53*F53*G53">3,000,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>Development of the workflow
  components other than those developed from the flowchart</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>3</td>
  <td class=xl29 width=177 style='width:133pt'>Test case designs</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>400</td>
  <td class=xl29 width=81 style='width:61pt'>Test lead</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="1200000"
  x:fmla="=D54*F54*G54">1,200,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>Testing</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>4</td>
  <td class=xl29 width=177 style='width:133pt'>Objects in hierarchy tree</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>210</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="630000"
  x:fmla="=D55*F55*G55">630,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>Development of the business
  components</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=90 style='height:67.5pt'>
  <td height=90 class=xl29 width=50 style='height:67.5pt;width:38pt' x:num>5</td>
  <td class=xl29 width=177 style='width:133pt'>Objects in framework tree</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>150</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="450000"
  x:fmla="=D56*F56*G56">450,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>development of service
  interfaces, data access, external interface, security, logging, event
  handling, constants, enumerations, globalization, localization</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>6</td>
  <td class=xl29 width=177 style='width:133pt'>Use cases</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>200</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="600000"
  x:fmla="=D57*F57*G57">600,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>user interface, user process
  components</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=36 style='height:27.0pt'>
  <td height=36 class=xl29 width=50 style='height:27.0pt;width:38pt' x:num>7</td>
  <td class=xl29 width=177 style='width:133pt'>Deployment</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>20</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>1</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="60000" x:fmla="=D58*F58*G58">60,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>deployment script/files for sql,
  dll's and exe's</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>8</td>
  <td class=xl29 width=177 style='width:133pt'>Components</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>7</td>
  <td class=xl29 width=81 style='width:61pt'>Sr.Dev/Dev</td>
  <td class=xl29 width=77 style='width:58pt' x:num>7</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="147000"
  x:fmla="=D59*F59*G59">147,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>interfaces, controller, data
  entities</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl29 width=50 style='height:13.5pt;width:38pt' x:num>9</td>
  <td class=xl29 width=177 style='width:133pt'>User Acceptance Testing</td>
  <td class=xl29 width=47 style='width:35pt'>Nos</td>
  <td class=xl29 width=70 style='width:53pt' x:num>1</td>
  <td class=xl29 width=81 style='width:61pt'>Dev. Team</td>
  <td class=xl29 width=77 style='width:58pt' x:num>900</td>
  <td class=xl30 width=69 style='width:52pt' x:num="3000">3,000.00</td>
  <td class=xl30 width=92 style='width:69pt' x:num="2700000"
  x:fmla="=D60*F60*G60">2,700,000.00</td>
  <td class=xl29 width=222 style='width:167pt'>interfaces, controller, data
  entities</td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=8 class=xl35 style='height:12.75pt;mso-ignore:colspan'></td>
  <td class=xl37></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl35 style='height:12.75pt'></td>
  <td class=xl39 width=177 style='width:133pt'>total</td>
  <td class=xl35></td>
  <td class=xl38 align=right width=70 style='width:53pt' x:num
  x:fmla="=SUM(D52:D61)">1188</td>
  <td colspan=2 class=xl35 style='mso-ignore:colspan'></td>
  <td class=xl36></td>
  <td class=xl40 align=right width=92 style='width:69pt' x:num="7980000"
  x:fmla="=SUM(H52:H57)">7,980,000.00</td>
  <td class=xl37></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=6 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
  <td class=xl26></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=6 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
  <td class=xl26></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=6 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
  <td class=xl26></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=6 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
  <td class=xl26></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=6 class=xl24 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
  <td class=xl26></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=41 style='mso-height-source:userset;height:30.75pt'>
  <td height=41 class=xl41 width=50 style='height:30.75pt;width:38pt'
  x:str="Entities: ">Entities: </td>
  <td colspan=8 class=xl46 width=835 style='width:628pt'
  x:str="These are the objects in the diagrams created and/or items identified in requirement gathering &amp; analysis . The diagrams include the object hierarchy tree (framework, business objects, forms), work flows, flow charts, activity, use cases, components and deployment ">These
  are the objects in the diagrams created and/or items identified in
  requirement gathering &amp; analysis . The diagrams include the object
  hierarchy tree (framework, business objects, forms), work flows, flow charts,
  activity, use cases, components and deployment </td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=9 class=xl42 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=9 class=xl42 style='height:12.75pt;mso-ignore:colspan'></td>
  <td colspan=9 class=xl24 style='mso-ignore:colspan'></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=50 style='width:38pt'></td>
  <td width=177 style='width:133pt'></td>
  <td width=47 style='width:35pt'></td>
  <td width=70 style='width:53pt'></td>
  <td width=81 style='width:61pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=69 style='width:52pt'></td>
  <td width=92 style='width:69pt'></td>
  <td width=222 style='width:167pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
 </tr>
 <![endif]>
</table>

</body>

</html>
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Written By
Nirosh
Architect Virtusa Pvt. Ltd.
Sri Lanka
In-depth coverage of Microsoft .Net, Cloud and many other cutting-edge Technologies.

- The Mandelbrot set – someone has called it the thumb-print of God – is one of the most beautiful and remarkable discoveries in the entire history of mathematics. My profile picture is generated with that equation.
You may contact Nirosh for Consultations, Code Reviews and Architecture Guide Workshops via c_nir*o*sh@hotmail.com (Remove * to use)
View Nirosh L.W.C.'s profile on LinkedIn

Other Links
A Practical Approach to Computer Systems Design and Architecture

License

Comments and Discussions
