Converting Zulu to Pacific time

[daniellefoto]

I have this Excel Spreadsheet that I have to submit everyday at work. The only thing I can't figure out is how to convert the zulu times into Hawaii time. Can someone please help me with a formula? Below is what I need it to look like. I can't take the zulu day out, I need the formula to recogonize the date. Thanks!!
<TABLE style="WIDTH: 101pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=134 border=0><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><TBODY><TR style="HEIGHT: 24pt; mso-height-source: userset" height=32><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 24pt; BACKGROUND-COLOR: #d8d8d8" width=58 height=32>Est Day Z
</TD><TD class=xl73 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 57pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8" width=76>HIK LCL (Z-10:00)</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl72 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: white" width=58 height=13>174/2000</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">22 JUN 1000</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl72 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: white" width=58 height=13>174/2054</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">22 JUN 1054</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl72 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: white" width=58 height=13>175/0008</TD><TD class=xl74 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">22 JUN 1408</TD></TR></TBODY></TABLE>

 

[hiker95]

daniellefoto,

Welcome to the MrExcel forum.

Search on the web for "Converting Zulu to Pacific time with excel".


Got to this link and scroll down to the Solution. There is a function "GetGMTTime(Optional StartTime As Variant) As Date"
http://www.experts-exchange.com/Sof...Office_Suites/MS_Office/Excel/Q_21239407.html

 

[daniellefoto]

Already did.

 

[AlphaFrog]

Excel Workbook
	A	B	C
1	Est Day Z	HIK LCL (Z-10:00)	Calculated
2	174/2000	22 JUN 1000	22-Jun 1000
3	174/2054	22 JUN 1054	22-Jun 1054
4	175/0008	22 JUN 1408	22-Jun 1408
Sheet

Calculated cells format
d-mmm hhmm

 

[Weaver]

Bah, beaten to it!

Here's another way

=LEFT(A2,LEN(A2)-5)+DATE(YEAR(TODAY()),1,0)-TIME(10,,)+TIMEVALUE(REPLACE(RIGHT(A2,4),3,0,":"))

 

[daniellefoto]

I tried both of these and they work, but the new time doesn't come up. I get the date conversion but not the time.

 

[daniellefoto]

Lets see if this works... this is the entire chart.

<TABLE style="WIDTH: 378pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=501 border=0><COLGROUP><COL style="WIDTH: 15pt; mso-width-source: userset; mso-width-alt: 731" width=20><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1206" width=33><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><TBODY><TR style="HEIGHT: 22.5pt; mso-height-source: userset" height=30><TD class=xl92 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 100pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent" width=133 colSpan=3 height=30></TD><TD class=xl73 id=td_post_2354259 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 94pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent; mso-ignore: colspan" width=125 colSpan=3>2- Day Flow</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" vAlign=top align=left width=58><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t201 path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><vath o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"></vath><?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o:lock shapetype="t" v:ext="edit"></o:lock></v:shapetype><v:shape id=_x0000_s5121 style="MARGIN-TOP: 3pt; Z-INDEX: 7; MARGIN-LEFT: 29.25pt; WIDTH: 77.25pt; POSITION: absolute; HEIGHT: 17.25pt; mso-wrap-style: tight" o:insetmode="auto" strokeweight="2.25pt" strokecolor="windowText [64]" fillcolor="yellow [13]" type="#_x0000_t201"><v:stroke dashstyle="dash"></v:stroke><vath fillok="t" strokeok="t" shadowok="t"></vath><o:lock v:ext="edit" aspectratio="t" rotation="t"></o:lock><v:textbox style="mso-direction-alt: auto" o:singleclick="f"></v:textbox></v:shape>

<TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl73 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent" width=58 height=30></TD></TR></TBODY></TABLE></TD><TD class=xl94 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 56pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=74></TD><TD class=xl70 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=53>Date</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=58>23-Jun-10</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD class=xl89 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 294pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: #0d0d0d" width=390 colSpan=10 height=20>MSN Status Legend: Q-QT/R-RON/K-RMKS/C-Close Watch/O-Orig/N-Non-AMC Aft Spt</TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset" height=32><TD class=xl75 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 24pt; BACKGROUND-COLOR: #d8d8d8" height=32>#</TD><TD class=xl76 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 26pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8" width=35>Msn Status</TD><TD class=xl77 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">Mission #</TD><TD class=xl78 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">TAIL #</TD><TD class=xl77 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">MDS</TD><TD class=xl77 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">Event</TD><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">Est Day Z</TD><TD class=xl95 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 56pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8" width=74>HIK LCL (Z-10:00)</TD><TD class=xl77 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">Prev ICAO</TD><TD class=xl81 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #d8d8d8">Next ICAO</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>4</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>8UN319MX0173</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>23552</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>174/2000</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010

</TD><TD class=xl84 id=td_post_2354259 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KRDR</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>RODN</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>5</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>XBCRE800B169</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>457</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C5A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ADV</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>174/2054</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010

</TD>

<TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PHIK</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>6</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>6BC52790D174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>60034</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC10A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>175/0008</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PGUA</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>7</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>7PH15A01L174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>23531</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0235</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PHIK</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PHIK</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>8</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>TQCJZ440D174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>N41CX</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>DC008</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0324</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PKWA</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>9</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>XBCRE790D174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>453</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C5A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0335</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PGUA</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>10</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>PMZN504PR174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>178</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C17A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0435</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PGUA</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KNZY</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>11</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>JBCGD790D175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>465</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C5A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0553</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PGUA</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>12</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>7PH15A01L174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>23531</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0620</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PHIK</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PHIK</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>13</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>JLW91474D175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>71441</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/0810</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/23/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>14</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>XBCRE800B169</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>457</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C5A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DDV</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/1145</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PHIK</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>15</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>JLC808000175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>38029</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/1645</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>RODN</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>16</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>TQCJZ440D174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>N41CX</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>DC008</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/1744</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PKWA</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>17</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>XBCRJE20F173</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>44138</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C17A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/1830</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>YSRI</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>18</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>7PH499W11175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>318</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/1901</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53> </TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KPDX</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>19</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>6BC52790D174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>60034</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC10A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/2108</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PGUA</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>20</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>PMZN504PR174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>178</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C17A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/2135</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PGUA</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KNZY</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>21</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>XBCRE790D174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>453</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C5A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0175/2135</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PGUA</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>22</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>JLW91474D175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>71441</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/0110</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>23</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>JBCGD790D175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>465</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>C5A</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/0123</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PGUA</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>24</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>7PH15A01L174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>23531</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/0425</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PHIK</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>PHIK</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>25</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>7PH15A01L174</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>23531</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/0800</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>PHIK</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KLCK</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>26</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Q</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>TBCKU790F176</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45> </TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>B74720</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>ARR</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/0800</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/24/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>RKSO</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>27</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Q</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>TBCKU790F176</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45> </TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>B74720</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/1150</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/25/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>KSUU</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>RKSO</TD></TR><TR style="HEIGHT: 9.95pt; mso-height-source: userset" height=13><TD class=xl82 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 9.95pt; BACKGROUND-COLOR: transparent" height=13>28</TD><TD class=xl83 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 59pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=78>JLC808000175</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 34pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=45>38029</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 35pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=47>KC135R</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 25pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=33>DEP</TD><TD class=xl88 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>0176/1700</TD><TD class=xl96 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">6/25/2010</TD><TD class=xl84 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 40pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=53>RODN</TD><TD class=xl87 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white" width=58>KSUU</TD></TR></TBODY></TABLE>

 

[Brian from Maui]

What does the 174 in 174/2000 denote?

 

[daniellefoto]

That is the zulu time.

 

[AlphaFrog]

I tried both of these and they work, but the new time doesn't come up. I get the date conversion but not the time.

Did you format the cell results from the formulas to display a Date-Time?
Example: d-mmm hhmm