Excel VBA loop named range paste non blank cells to Summary Sheet

B

Biz

Well-known Member
Joined
May 18, 2009
Messages
1,773
Office Version
  1. 2021
Platform
  1. Windows
Dear All,

I have made an extract of main file. There are multiple tabs called UK and UK1


Name Range
<TABLE style="WIDTH: 187pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=249><COLGROUP><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=117>UK_Loss</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=132>=UK!$A$14:$C$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK_Loss_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK!$K$14:$K$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK_rec</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK!$A$27:$C$30</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK_rec_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK!$K$27:$K$30</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_Loss</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$A$14:$C$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_Loss_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$K$14:$K$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_rec</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$A$30:$C$33</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_rec_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$K$30:$K$33</TD></TR></TBODY></TABLE>

Goal is to use vba loop or vba arrays (ubound and lbound) etc loop through ranged name copy and paste special non blanks in Summary worksheet tab.

UK

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 209px"><COL style="WIDTH: 93px"><COL style="WIDTH: 64px"><COL style="WIDTH: 102px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Losses</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold" colSpan=3>Reason</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">XYZ</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">6564</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">6564</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Lost to X factor on Price</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">BTW</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3804</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3804</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Decommissioned</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 10,368 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$5,184</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Recoveries</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From Whom</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">BMX</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$8,568</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Recovered from Install no FM Period</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 8,568 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" colSpan=3> </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>D14</TD><TD>=C14/B14</TD></TR><TR><TD>D15</TD><TD>=C15/B15</TD></TR><TR><TD>B24</TD><TD>=SUM(B14:B23)</TD></TR><TR><TD>C24</TD><TD>=SUM(C14:C23)</TD></TR><TR><TD>D24</TD><TD>=C24/B24</TD></TR><TR><TD>D27</TD><TD>=C27/B27</TD></TR><TR><TD>B31</TD><TD>=SUM(B27:B30)</TD></TR><TR><TD>C31</TD><TD>=SUM(C27:C30)</TD></TR><TR><TD>D31</TD><TD>=C31/B31</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

UK 1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 209px"><COL style="WIDTH: 93px"><COL style="WIDTH: 64px"><COL style="WIDTH: 102px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Losses</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold" colSpan=3>Reason</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">try</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">6564</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3282</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Lost to X factor on Price & Qty</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Fly</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3804</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1902</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Product Failure</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 10,368 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$2,592</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Recoveries</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From Whom</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Fly</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$857</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">FX</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 856.80 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" colSpan=3> </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>D14</TD><TD>=C14/B14</TD></TR><TR><TD>D15</TD><TD>=C15/B15</TD></TR><TR><TD>B24</TD><TD>=SUM(B14:B23)</TD></TR><TR><TD>C24</TD><TD>=SUM(C14:C23)</TD></TR><TR><TD>D24</TD><TD>=C24/B24</TD></TR><TR><TD>D30</TD><TD>=C30/B30</TD></TR><TR><TD>B34</TD><TD>=SUM(B30:B33)</TD></TR><TR><TD>C34</TD><TD>=SUM(C30:C33)</TD></TR><TR><TD>D34</TD><TD>=C34/B34</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Summary

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 104px"><COL style="WIDTH: 93px"><COL style="WIDTH: 44px"><COL style="WIDTH: 112px"><COL style="WIDTH: 221px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-WEIGHT: bold">Desired Results</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Losses</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Reason</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>XYZ</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">6564</TD><TD style="TEXT-ALIGN: right">6564</TD><TD>Lost to X factor on Price</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>BTW</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">3804</TD><TD style="TEXT-ALIGN: right">3804</TD><TD>Decommissioned</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>try</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">6564</TD><TD style="TEXT-ALIGN: right">3282</TD><TD>Lost to X factor on Price & Qty</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Fly</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3804</TD><TD style="TEXT-ALIGN: right">1902</TD><TD>Product Failure</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Recoveries</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From Whom</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD>BMX</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">8568</TD><TD style="TEXT-ALIGN: right">8568</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Recovered from Install no FM Period</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD>Fly</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">8568</TD><TD style="TEXT-ALIGN: right">856.8</TD><TD>FX</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>D10</TD><TD>=C10/B10</TD></TR><TR><TD>D11</TD><TD>=C11/B11</TD></TR><TR><TD>D12</TD><TD>=C12/B12</TD></TR><TR><TD>D13</TD><TD>=C13/B13</TD></TR><TR><TD>D25</TD><TD>=C25/B25</TD></TR><TR><TD>D26</TD><TD>=C26/B26</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Workbook can be download from weblink below
http://www.megaupload.com/?d=1A8JX0U9

Your help would be greatly appreciated.

Biz
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
Dear All,

I have made an extract of main file. There are multiple tabs called UK and UK1


Name Range
<TABLE style="WIDTH: 187pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=249><COLGROUP><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=117>UK_Loss</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=132>=UK!$A$14:$C$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK_Loss_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK!$K$14:$K$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK_rec</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK!$A$27:$C$30</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK_rec_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK!$K$27:$K$30</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_Loss</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$A$14:$C$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_Loss_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$K$14:$K$23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_rec</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$A$30:$C$33</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>UK1_rec_Reason</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">=UK1!$K$30:$K$33</TD></TR></TBODY></TABLE>

Goal is to use vba loop or vba arrays (ubound and lbound) etc loop through ranged name copy and paste special non blanks in Summary worksheet tab.

UK

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 209px"><COL style="WIDTH: 93px"><COL style="WIDTH: 64px"><COL style="WIDTH: 102px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Losses</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold" colSpan=3>Reason</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">XYZ</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">6564</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">6564</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Lost to X factor on Price</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">BTW</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3804</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3804</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Decommissioned</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 10,368 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$5,184</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Recoveries</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From Whom</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">BMX</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$8,568</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Recovered from Install no FM Period</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 8,568 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" colSpan=3></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>D14</TD><TD>=C14/B14</TD></TR><TR><TD>D15</TD><TD>=C15/B15</TD></TR><TR><TD>B24</TD><TD>=SUM(B14:B23)</TD></TR><TR><TD>C24</TD><TD>=SUM(C14:C23)</TD></TR><TR><TD>D24</TD><TD>=C24/B24</TD></TR><TR><TD>D27</TD><TD>=C27/B27</TD></TR><TR><TD>B31</TD><TD>=SUM(B27:B30)</TD></TR><TR><TD>C31</TD><TD>=SUM(C27:C30)</TD></TR><TR><TD>D31</TD><TD>=C31/B31</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

UK 1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 209px"><COL style="WIDTH: 93px"><COL style="WIDTH: 64px"><COL style="WIDTH: 102px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Losses</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold" colSpan=3>Reason</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">try</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">6564</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3282</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Lost to X factor on Price & Qty</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Fly</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3804</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1902</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Product Failure</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 10,368 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$2,592</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Recoveries</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From Whom</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Fly</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">$857</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">FX</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 8,568 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">$ 856.80 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" colSpan=3></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>D14</TD><TD>=C14/B14</TD></TR><TR><TD>D15</TD><TD>=C15/B15</TD></TR><TR><TD>B24</TD><TD>=SUM(B14:B23)</TD></TR><TR><TD>C24</TD><TD>=SUM(C14:C23)</TD></TR><TR><TD>D24</TD><TD>=C24/B24</TD></TR><TR><TD>D30</TD><TD>=C30/B30</TD></TR><TR><TD>B34</TD><TD>=SUM(B30:B33)</TD></TR><TR><TD>C34</TD><TD>=SUM(C30:C33)</TD></TR><TR><TD>D34</TD><TD>=C34/B34</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Summary UK

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 104px"><COL style="WIDTH: 93px"><COL style="WIDTH: 44px"><COL style="WIDTH: 112px"><COL style="WIDTH: 221px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-WEIGHT: bold">Desired Results</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Losses</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Reason</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>XYZ</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">6564</TD><TD style="TEXT-ALIGN: right">6564</TD><TD>Lost to X factor on Price</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>BTW</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">3804</TD><TD style="TEXT-ALIGN: right">3804</TD><TD>Decommissioned</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>try</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">6564</TD><TD style="TEXT-ALIGN: right">3282</TD><TD>Lost to X factor on Price & Qty</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Fly</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3804</TD><TD style="TEXT-ALIGN: right">1902</TD><TD>Product Failure</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Recoveries</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Number Units</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Average Value</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From Whom</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD>BMX</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">8568</TD><TD style="TEXT-ALIGN: right">8568</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Recovered from Install no FM Period</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD>Fly</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">8568</TD><TD style="TEXT-ALIGN: right">856.8</TD><TD>FX</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>D10</TD><TD>=C10/B10</TD></TR><TR><TD>D11</TD><TD>=C11/B11</TD></TR><TR><TD>D12</TD><TD>=C12/B12</TD></TR><TR><TD>D13</TD><TD>=C13/B13</TD></TR><TR><TD>D25</TD><TD>=C25/B25</TD></TR><TR><TD>D26</TD><TD>=C26/B26</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

There are multiple countries UK and USA. Please not each country has Summary Tab

Updated ** Workbook can be download from weblink below
http://www.megaupload.com/?d=ENISUOCYhttp://www.megaupload.com/?d=1A8JX0U9

Your help would be greatly appreciated.

Biz
 
Upvote 0
Guys any help please.

Biz
 
Upvote 0
Hi Guys,

I have progressed bit further but concentrating on UK only. Problems now I am having not sure way when copying and pasting information regarding Recoveries it paste generates multiple entries (refer to UK Summary tab) which copying from UK A27:C27 but pasting it too many times.

Code: 
Sub TEST()
    Dim aNamePrefix, aNameSuffix, aDestination
    Dim i As Long, j As Long, Counter As Long, aSummary As Range
    Dim aName As Variant, aStartRef As Variant
 
    aNamePrefix = Array("UK", "UK1")
    aNameSuffix = Array("Loss", "Loss_Reason", "rec", "rec_Reason")
 
    'ClearContents in Summary Worksheet
     Range("UK_Loss_Sum").ClearContents
     Range("UK_Loss_Reason_Sum").ClearContents
     Range("UK_rec_Reason_Sum").ClearContents
     Range("UK_rec_Sum").ClearContents
 
    For j = 1 To UBound(aNameSuffix)
        For i = 1 To UBound(aNamePrefix)
            Set aName = Range(aNamePrefix(i) & "_" & aNameSuffix(j))
 
                aDestination = AlphaNum(CStr(aNamePrefix(i)), True) 'Get Worksheet Name
                Set aSummary = Nothing
                Set aSummary = Sheets(aDestination & " " & "Summary").Range(aDestination & "_" & aNameSuffix(j) & "_Sum")
 
                'Populates Losses & Recoveries
 
               If InStr(("Loss,rec"), aNameSuffix(j)) > 0 Then
               'If (aNameSuffix(j) = "Loss") Or (aNameSuffix(j) = "rec") Then
                    Counter = Application.CountA(Range(aDestination & "_" & aNameSuffix(j) & "_Sum")) / 3
                    aName.SpecialCells(xlCellTypeConstants).Copy 'Copy Cells
                    aSummary.Offset(Counter, 0).PasteSpecial Paste:=xlPasteValues
                    Application.CutCopyMode = False
                Else
                    Counter = Application.CountA(Range(aDestination & "_" & aNameSuffix(j) & "_Sum"))
                    aName.SpecialCells(xlCellTypeConstants).Copy 'Copy Cells
                    aSummary.Offset(Counter, 0).PasteSpecial Paste:=xlPasteValues
                    Application.CutCopyMode = False
               End If
        Next i
    Next j
 
    'Release memory
    Set aSummary = Nothing
    Set aName = Nothing
End Sub
 
Function AlphaNum(txt As String, Optional Alpha As Boolean = True) As String
'Use in cell like _
=AlphaNum(A1,True) '<- True for Alphabets, False for Numbers
 '// \d+ Matches a digit character of any length.
 '// \D Matches a nondigit character of any length.
With CreateObject("VBScript.RegExp")
    .Pattern = IIf(Alpha, "\d+", "\D+")
    .Global = True
    AlphaNum = .Replace(txt, "")
End With
End Function

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
Any help would be appreciated.

Biz
 
Last edited:
Upvote 0
Hi Biz,

Would you be open to approaching this a little differently - still using your interesting structure of Prefix and Suffixes to communicate the relationships?

Instead of iterating through each combination of your Prefix and Suffix arrays, I'd suggest you:
1. Step through each worksheet
2. If it is a summary sheet, skip it...else copy the parts of that sheet to the correct summary sheet and range using your naming relationships.

IMO this would be much simpler and less prone to matching errors.

Also one note on your current coding...when you make an array using this statement:

Code: 
aNamePrefix = Array("UK", "UK1")
The default is typically for the first element to be item 0 instead of 1

So unless you have Option Base 1 at the top of your module this code...
Code: 
For i = 1 To UBound(aNamePrefix)
...will skip Item 0.

No worries...I'm hoping you will eliminate that control structure making this moot.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
448
Micron
M
C
  • Question
Picture won't paste in cell overlay
Replies
0
Views
86
Cerka
C
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
854
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,215,606
Messages
6,125,814
Members
449,262
Latest member
hideto94

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