Copy worksheet and obtain data from newly created sheet

B

bangchaq

New Member
Joined
Mar 30, 2009
Messages
4
Hi all
I have this template that I would like to copy, rename the copied sheet to tag no and name the tag no with the provided tag no.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
I manage to get to the point of copy the sheet, rename and place the tag no in the required cell.
What I would like to do next to be able to get more information from the newly created sheet to Summary sheet. There are quite a few information that I would like to transfer to Summary sheet. However, for assistance, you can guide me to fetch the WO No in S5, value of L24. If possible, I want to have the data in the Summary refers to cell in the copied sheet, instead of copy the value.
Below is the code I have so far (which I obtained from the forum :biggrin: but cannot give the credit, forget where I got the code :() and snapshot of my template and Summary sheet.
Your kind assistance in solving is highly appreciated.
The code

Sub CreateNewSheet()
Dim NewSheet As Worksheet
Dim NewName As String
Do
NewName = Application.InputBox("Tag No (Click Cancel to stop)", Type:=2)
If NewName = "False" Then Exit Sub: Rem cancel pressed
On Error Resume Next
'copy the template into a new worksheet
Sheets("Template").Copy After:=Sheets(1)
ActiveSheet.Name = NewName
'Put the new tag no in worksheet
Sheets(NewName).Cells(4, 6).Value = NewName

Loop Until NewName = vbNullString
----------------------------------------------------------

Template

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 12pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 43px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 42px"><COL style="WIDTH: 52px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 72px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">A</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">B</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">C</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">D</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">E</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">F</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">G</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">H</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">I</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">J</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">K</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">L</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">M</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">N</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">O</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">P</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">Q</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">R</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">S</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">T</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">U</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">V</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">W</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">4</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; BORDER-LEFT: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=2>TAG NO </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">PLANT </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">SERVICE</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=4>AREA (UNIT)</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=5> </TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">5</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; BORDER-LEFT: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=5>EQUIPMENT DESC. </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt"></TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=4>WO NO</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid" colSpan=5> </TD></TR><TR style="HEIGHT: 33px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">6</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; BORDER-LEFT: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=2>JOB TITLE </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid" colSpan=12> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=4>DWG NO</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid" colSpan=5> </TD></TR><TR style="HEIGHT: 42px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">7</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">NO.</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ACTIVITY DESCRIPTION</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">DUR-HRS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold">SC</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; FONT-WEIGHT: bold">IS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=2>FT</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=2>WE</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=2>EL</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=2>IP</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 2px solid">TOTAL MAN HOURS</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">8</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Q</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">H</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Q</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">H</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Q</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">H</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Q</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">H</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Q</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">H</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Q</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">H</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid"> </TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">9</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: left; FONT-SIZE: 10pt; FONT-WEIGHT: bold">PRE-EXECUTION WORKS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid"> </TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">10</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">11</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">12</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Sub Total</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">13</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">14</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold">EXECUTION WORKS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">15</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">16</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">17</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Sub Total</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">18</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">19</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold">POST EXECUTION WORKS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">20</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">21</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">22</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Sub Total</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid">0</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">23</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 2px solid"> </TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">24</TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: left; BORDER-LEFT: #000000 2px solid; FONT-SIZE: 10pt; FONT-WEIGHT: bold">GRAND TOTAL</TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: right; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: right; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: right; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 3px double; TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 2px solid">0</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>J10</TD><TD>=MAX(L10,N10,P10,R10,T10,V10)</TD></TR><TR><TD>W10</TD><TD>=K10*L10+M10*N10+O10*P10+Q10*R10+S10*T10+U10*V10</TD></TR><TR><TD>J11</TD><TD>=MAX(L11,N11,P11,R11,T11,V11)</TD></TR><TR><TD>W11</TD><TD>=K11*L11+M11*N11+O11*P11+Q11*R11+S11*T11+U11*V11</TD></TR><TR><TD>J12</TD><TD>=SUBTOTAL(9,J10:J11)</TD></TR><TR><TD>W12</TD><TD>=K12*L12+M12*N12+O12*P12+Q12*R12+S12*T12+U12*V12</TD></TR><TR><TD>W13</TD><TD>=K13*L13+M13*N13+O13*P13+Q13*R13+S13*T13+U13*V13</TD></TR><TR><TD>W14</TD><TD>=K14*L14+M14*N14+O14*P14+Q14*R14+S14*T14+U14*V14</TD></TR><TR><TD>J15</TD><TD>=MAX(L15,N15,P15,R15,T15,V15)</TD></TR><TR><TD>W15</TD><TD>=K15*L15+M15*N15+O15*P15+Q15*R15+S15*T15+U15*V15</TD></TR><TR><TD>J16</TD><TD>=MAX(L16,N16,P16,R16,T16,V16)</TD></TR><TR><TD>W16</TD><TD>=K16*L16+M16*N16+O16*P16+Q16*R16+S16*T16+U16*V16</TD></TR><TR><TD>J17</TD><TD>=SUBTOTAL(9,J15:J16)</TD></TR><TR><TD>W17</TD><TD>=K17*L17+M17*N17+O17*P17+Q17*R17+S17*T17+U17*V17</TD></TR><TR><TD>W18</TD><TD>=K18*L18+M18*N18+O18*P18+Q18*R18+S18*T18+U18*V18</TD></TR><TR><TD>W19</TD><TD>=K19*L19+M19*N19+O19*P19+Q19*R19+S19*T19+U19*V19</TD></TR><TR><TD>J20</TD><TD>=MAX(L20,N20,P20,R20,T20,V20)</TD></TR><TR><TD>W20</TD><TD>=K20*L20+M20*N20+O20*P20+Q20*R20+S20*T20+U20*V20</TD></TR><TR><TD>J21</TD><TD>=MAX(L21,N21,P21,R21,T21,V21)</TD></TR><TR><TD>W21</TD><TD>=K21*L21+M21*N21+O21*P21+Q21*R21+S21*T21+U21*V21</TD></TR><TR><TD>J22</TD><TD>=SUBTOTAL(9,J20:J21)</TD></TR><TR><TD>W22</TD><TD>=K22*L22+M22*N22+O22*P22+Q22*R22+S22*T22+U22*V22</TD></TR><TR><TD>J24</TD><TD>=SUBTOTAL(9,J10:J22)</TD></TR><TR><TD>L24</TD><TD>=SUMPRODUCT(K10:K21,L10:L21)</TD></TR><TR><TD>N24</TD><TD>=SUMPRODUCT(M10:M21,N10:N21)</TD></TR><TR><TD>P24</TD><TD>=SUMPRODUCT(O10:O21,P10:P21)</TD></TR><TR><TD>R24</TD><TD>=SUMPRODUCT(Q10:Q21,R10:R21)</TD></TR><TR><TD>T24</TD><TD>=SUMPRODUCT(S10:S21,T10:T21)</TD></TR><TR><TD>V24</TD><TD>=SUMPRODUCT(U10:U21,V10:V21)</TD></TR><TR><TD>W24</TD><TD>=SUM(W8:W23)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Summary

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 12pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 80px"><COL style="WIDTH: 81px"><COL style="WIDTH: 81px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"><COL style="WIDTH: 80px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">A</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">B</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">C</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">D</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">E</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">F</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">G</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">H</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">I</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">V</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">W</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">X</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">Y</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">Z</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AA</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AB</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AC</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AD</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AE</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AF</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">AG</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">BF</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; BORDER-LEFT: #f0f0f0 3px solid; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">BG</TD></TR><TR style="HEIGHT: 43px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 1px solid; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" rowSpan=2>Tag No</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" rowSpan=2>WO</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" rowSpan=2>Dur</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-TOP: #000000 3px double; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=3>SC</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-TOP: #000000 3px double; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=3>IS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 3px double; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=3>FT</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-TOP: #000000 3px double; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=3>WE</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-TOP: #000000 3px double; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=3>EL</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-TOP: #000000 3px double; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" colSpan=3>IP</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 1px solid; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" rowSpan=2>TOTAL MAN HOURS</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-TOP: #000000 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid" rowSpan=2>Total Cost</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Mhr</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Rate</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Cost</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Mhr</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Rate</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Cost</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 1px solid; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Mhr</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Rate</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Cost</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Mhr</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Rate</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Cost</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Mhr</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Rate</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Cost</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Mhr</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Rate</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">Cost</TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">3</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; COLOR: #0000ff; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; COLOR: #0000ff; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD></TR><TR style="HEIGHT: 17px"><TD style="BORDER-BOTTOM: #f0f0f0 3px solid; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px solid; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px solid; BORDER-RIGHT: #f0f0f0 3px solid">4</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; COLOR: #0000ff; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; COLOR: #0000ff; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> </TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
You must log in or register to reply here.

Similar threads

V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
313
VBAEXCELNew
V
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
817
gvsumich
G
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
345
esben
E
E
  • Question
Create mails with table - standard header specific row
Replies
1
Views
931
esben
E
E
  • Question
Adding a custom message.
Replies
1
Views
422
Micron
M

Forum statistics

Threads
1,214,646
Messages
6,120,717
Members
448,985
Latest member
chocbudda

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top