Posts by Sevcav

    I have a range of cells in Column N and would like to copy the first cell in the range 30 times (variable set in Cell C1) to the first empty row in column M. Then I would like to increment to the next cell in the range and repeat the copy/paste process until the range has been looped through.


    Any assistance would be greatly appreciated, I am getting stuck on stepping through the range.


    Thank you in advance

    I am trying to convert a monthly spreadsheet via formula or code to a Access friendly format for export. The spreadsheet has 2 categories on the Y axis (columns) and one category on the X axis (rows) that need to be matched in a data table to return that intersection point value. I have attached a sample spreadsheet of data, and the format I am trying to get to.


    Thanks in advance for any help.


    ozgrid.com/forum/core/index.php?attachment/43006/

    Files

    • Help.xlsx

      (32.07 kB, downloaded 60 times, last: )

    Re: Adjust Date Range Plotted On Chart


    Dave,


    Thanks! I don't always understand what I should be looking for, Scrolling charts pretty much hit the nail on the head for me. Great forum, and great support as always.


    Again Thank You,
    Cav

    I am trying to get some help by adjusting my datarange dynamically based on what days I select. I would hope the chart could adjust to display for example 10/3/2008 to 10/10/2008 values and only those values.


    I have been trying to figure out how the datarange varies in this post http:// www.ozgrid.com/forum/showthread.php?t=58206 and although I believe the named ranges SEx and SEy are the variable dataranges, I do not understand how to apply them to the charts source data. Ultimately Krish's chart would be ideal to understand and I belive is the keystone to where I am trying to go.


    I have attached a sample of my workbook and the source data and chart I am trying to manipulate.


    Thanks in advance for any help.
    Cav

    Files

    • DYN Help.xls

      (37.38 kB, downloaded 88 times, last: )

    I am a little lost on this, and have tried to remedy my issue by searches to no avail.


    I have a cell formula that references another cell:


    Cell A1 (=A3) where Cell A3 = 1


    Cell A1 displays the text "=A3" and not the value of 1


    Autocalc is on, and the worsheet and workbook is unprotected. Any ideas or help would be greatly appreciated.


    Thanks in Advance

    Re: Combo Box To Update Cell Value Then Perform Code Actions


    I believe I follow what you are saying. I tried to run the code after re-naming combobox "Drop Down 357" to ComboBox1, but it never updates "Aircraft1" cell, nor changes the object "arrow1" color. Could this be because I have used the Excel Forms Combobox feature vice creating in VBA?


    Please pardon my VBA knowledge as I am trying to learn some basics here.


    Thanks again for any hlep on my problem.

    Hi all,


    I am trying to use a userform (Combo Box) to update my named cell "Aircraft1" then based on the value selected change the color of an object.


    The code works great if I manually enter the value in the cell "Aircraft1", however if the dropdown list selects the value the object does not update its color.


    Is there a way to update the cell via a combo box, and then have the VB code change the color of the object?


    Thanks in advance for any possible solution to my problem.


    This is my code:


    This is the calander sheet (small clip)
    <SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"&gt;</SCRIPT&gt;<CENTER&gt;<TABLE cellSpacing=0 cellPadding=0 align=center&gt;<TBODY&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=10&gt;<TABLE width="100%" align=center border=0&gt;<TBODY&gt;<TR&gt;<TD align=left&gt;<FONT color=white&gt;Microsoft Excel - FLTSNIVc_04.XLS</FONT&gt;</TD&gt;<TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right&gt;___Running: xl2000 : OS = Windows Windows 2000 </FONT&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=10&gt;<TABLE width="100%" align=center border=0 VALIGN="MIDDLE"&gt;<TBODY&gt;<TR&gt;<TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption"&gt;(<U&gt;F</U&gt;)ile (<U&gt;E</U&gt;)dit (<U&gt;V</U&gt;)iew (<U&gt;I</U&gt;)nsert (<U&gt;O</U&gt;)ptions (<U&gt;T</U&gt;)ools (<U&gt;D</U&gt;)ata (<U&gt;W</U&gt;)indow (<U&gt;H</U&gt;)elp <A onclick=show_popup(); href="#javascript:void(0)"&gt;(<U&gt;A</U&gt;)bout</A&gt;</TD&gt;<TD vAlign=center align=right&gt;<FORM name=formCb059465&gt;<INPUT onclick='window.clipboardData.setData("Text",document.formFb543420.sltNb142651.value);' type=button value="Copy Formula" name=btCb290334&gt;</FORM&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=10&gt;<TABLE border=0&gt;<TBODY&gt;<TR&gt;<FORM name=formFb543420&gt;<TD style="WIDTH: 60px" align=middle bgColor=white&gt;<SELECT onchange="document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value" name=sltNb142651&gt;<OPTION value==TODAY()+L1-150 selected&gt;A1<OPTION value==A1+1&gt;A3<OPTION value==SUM(D132:D497)&gt;D4<OPTION value==SUM(E9:E131)&gt;E4<OPTION value==SUM(F132:F497)&gt;F4<OPTION value==SUM(G9:G131)&gt;G4<OPTION value==SUM(H9:H131)&gt;H4<OPTION value==SUM(I132:I497)&gt;I4<OPTION value==$A$3-$A5+1&gt;B5<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B5,$B$10:$B$589)+22,COLUMN(D$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(D$1))))&gt;D5<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B5,$B$10:$B$589)+22,COLUMN(E$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(E$1))))&gt;E5<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B5,$B$10:$B$589)+22,COLUMN(F$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(F$1))))&gt;F5<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B5,$B$10:$B$589)+22,COLUMN(G$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(G$1))))&gt;G5<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B5,$B$10:$B$589)+22,COLUMN(H$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(H$1))))&gt;H5<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B5,$B$10:$B$589)+22,COLUMN(I$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(I$1))))&gt;I5<OPTION value==$A$3-$A6+1&gt;B6<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B6,$B$10:$B$589)+22,COLUMN(D$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(D$1))))&gt;D6<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B6,$B$10:$B$589)+22,COLUMN(E$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(E$1))))&gt;E6<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B6,$B$10:$B$589)+22,COLUMN(F$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(F$1))))&gt;F6<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B6,$B$10:$B$589)+22,COLUMN(G$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(G$1))))&gt;G6<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B6,$B$10:$B$589)+22,COLUMN(H$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(H$1))))&gt;H6<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B6,$B$10:$B$589)+22,COLUMN(I$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(I$1))))&gt;I6<OPTION value==$A$3-$A7+1&gt;B7<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B7,$B$10:$B$589)+22,COLUMN(D$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(D$1))))&gt;D7<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B7,$B$10:$B$589)+22,COLUMN(E$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(E$1))))&gt;E7<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B7,$B$10:$B$589)+22,COLUMN(F$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(F$1))))&gt;F7<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B7,$B$10:$B$589)+22,COLUMN(G$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(G$1))))&gt;G7<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B7,$B$10:$B$589)+22,COLUMN(H$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(H$1))))&gt;H7<OPTION value==SUM(INDIRECT(ADDRESS(MATCH($B7,$B$10:$B$589)+22,COLUMN(I$1))):INDIRECT(ADDRESS(MATCH($A$3,$B$10:$B$589)+22,COLUMN(I$1))))&gt;I7<OPTION value="=SUM(D4+'F-14 & F-4'!D17)"&gt;D8<OPTION value="=SUM(E4+'F-14 & F-4'!E17)"&gt;E8<OPTION value==SUM(F4)&gt;F8<OPTION value==SUM(I4)&gt;I8<OPTION value='=MID(CHOOSE(MONTH(B10),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"),DAY(B10),1)'&gt;A10<OPTION value='=CHOOSE(WEEKDAY(B10),"SU","M","TU","W","TH","F","SA")'&gt;C10<OPTION value='=MID(CHOOSE(MONTH(B11),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"),DAY(B11),1)'&gt;A11<OPTION value='=CHOOSE(WEEKDAY(B11),"SU","M","TU","W","TH","F","SA")'&gt;C11<OPTION value='=MID(CHOOSE(MONTH(B12),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"),DAY(B12),1)'&gt;A12<OPTION value='=CHOOSE(WEEKDAY(B12),"SU","M","TU","W","TH","F","SA")'&gt;C12<OPTION value='=MID(CHOOSE(MONTH(B13),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"),DAY(B13),1)'&gt;A13<OPTION value='=CHOOSE(WEEKDAY(B13),"SU","M","TU","W","TH","F","SA")'&gt;C13</OPTION&gt;</SELECT&gt;</TD&gt;<TD align=right width="3%" bgColor=#d4d0c8&gt;<B>=</B&gt;</TD&gt;<TD align=left bgColor=white&gt;<INPUT size=80 value==TODAY()+L1-150 name=txbFb965317&gt;</TD&gt;</FORM&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<BR&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;A</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;B</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;C</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;D</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;E</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;F</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;G</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;H</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;I</CENTER&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;1</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: TimesNewRomanPS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left" colSpan=3&gt;<A onclick="document.formFb543420.sltNb142651.options[0].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;23-Jan-04</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center" colSpan=6&gt;F/A&nbsp;18&nbsp;PILOTS</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;2</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: TimesNewRomanPS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left" colSpan=3&gt;UPDATED&nbsp;FOR&nbsp;:</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2&gt;RABENS</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;SPARE&nbsp;1</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2&gt;BRUNN</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2&gt;McFARLAND</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;3</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 9pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: TimesNewRomanPS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left" colSpan=3&gt;<A onclick="document.formFb543420.sltNb142651.options[1].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;24-Jan-04</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;4</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 6pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #003366; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Total</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=2&gt;FY04</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[2].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;4.9</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[3].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[4].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;22.8</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[5].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[6].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[7].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;21.9</FONT&gt;</A&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;5</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #003366; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;30</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=2&gt;<A onclick="document.formFb543420.sltNb142651.options[8].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;12/26</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[9].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;0.0</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[10].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[11].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;0.0</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[12].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[13].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[14].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;0.0</FONT&gt;</A&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;6</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #003366; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;60</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=2&gt;<A onclick="document.formFb543420.sltNb142651.options[15].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;11/26</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[16].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;0</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[17].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[18].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;3.6</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[19].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[20].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[21].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;2.7</FONT&gt;</A&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;7</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #003366; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;90</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #000000; TEXT-ALIGN: center" colSpan=2&gt;<A onclick="document.formFb543420.sltNb142651.options[22].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;10/27</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[23].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;0</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[24].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[25].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;11.4</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[26].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[27].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[28].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;12.3</FONT&gt;</A&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;8</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 2pt solid; FONT-SIZE: 6pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=3&gt;TOTAL&nbsp;FLT&nbsp;TIME</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[29].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;19.6</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[30].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[31].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;22.8</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[32].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;21.9</FONT&gt;</A&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;9</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #003366; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"&gt;FY03hrs<6/1/03</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: TimesNewRomanPS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #800080; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: TimesNewRomanPS; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;22.3</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;66.9</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #0000ff; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;36.8</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;10</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 0.5pt solid; COLOR: #008000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[33].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;J</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[34].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;SU</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;11</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 0.5pt solid; COLOR: #008000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[35].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;U</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;2</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[36].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;M</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;12</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 0.5pt solid; COLOR: #008000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[37].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;N</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;3</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[38].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;TU</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1.2&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;13</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 0.5pt solid; COLOR: #008000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[39].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;&nbsp;<BR&gt;</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;4</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: bottom; COLOR: #008000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;<A onclick="document.formFb543420.sltNb142651.options[40].selected=true; document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value;" href="#javascript:void(0);"&gt;W</FONT&gt;</A&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;3.0&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1.5&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 7pt; VERTICAL-ALIGN: middle; COLOR: #ff0000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial MT; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" colSpan=10&gt;<TABLE width="100%" align=left VALIGN="TOP"&gt;<TBODY&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; WIDTH: 120pt; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff" align=left&gt;<U&gt;FA-18</U&gt;</TD&gt;<TD&gt;&nbsp;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;<BR&gt;<FONT color=#339966 size=1&gt;[HtmlMaker 2.41] </FONT&gt;<FONT color=#339966 size=1&gt;To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT&gt;<BR&gt;<FONT color=red size=1&gt;PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT&gt;</CENTER&gt;


    Again thanks for any help

    I have this formula that works great in extracting data from a worksheet, but I am using it to track 134 personnel (columns) for a year (365 rows). My problem is it takes a half hour to update, as it is doing some 48000 calculations! I have tried breaking the personnel into different workbooks but the time to update is still too long. Does anyone have an idea of something easier? I can use pivot tables to sum the data, but I need to post the data on a calander for visaul references of when someone is due to work next.
    The Formula:
    {=IF(ISNA(INDEX(FHData!$K$2:$K$3000,MATCH($Y$16&D$15&$B262,FHData!$N$2:$N$3000&FHData!$B$2:$B$3000&FHData!$A$2:$A$3000,0))),"",(INDEX(FHData!$K$2:$K$3000,MATCH($Y$16&D$15&$B262,FHData!$N$2:$N$3000&FHData!$B$2:$B$3000&FHData!$A$2:$A$3000,0))))}


    The Data sheet
    <SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"&gt;</SCRIPT&gt;<CENTER&gt;<TABLE cellSpacing=0 cellPadding=0 align=center&gt;<TBODY&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=15&gt;<TABLE width="100%" align=center border=0&gt;<TBODY&gt;<TR&gt;<TD align=left&gt;<FONT color=white&gt;Microsoft Excel - Flight Data Input.XLS</FONT&gt;</TD&gt;<TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right&gt;___Running: xl2000 : OS = Windows Windows 2000 </FONT&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=15&gt;<TABLE width="100%" align=center border=0 VALIGN="MIDDLE"&gt;<TBODY&gt;<TR&gt;<TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption"&gt;(<U&gt;F</U&gt;)ile (<U&gt;E</U&gt;)dit (<U&gt;V</U&gt;)iew (<U&gt;I</U&gt;)nsert (<U&gt;O</U&gt;)ptions (<U&gt;T</U&gt;)ools (<U&gt;D</U&gt;)ata (<U&gt;W</U&gt;)indow (<U&gt;H</U&gt;)elp <A onclick=show_popup(); href="#javascript:void(0)"&gt;(<U&gt;A</U&gt;)bout</A&gt;</TD&gt;<TD vAlign=center align=right&gt;<FORM name=formCb755237&gt;<INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980&gt;</FORM&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=15&gt;<TABLE border=0&gt;<TBODY&gt;<TR&gt;<FORM name=formFb078704&gt;<TD style="WIDTH: 60px" align=middle bgColor=white&gt;<SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705&gt;<OPTION value=4 selected&gt;C20</OPTION&gt;</SELECT&gt;</TD&gt;<TD align=right width="3%" bgColor=#d4d0c8&gt;<B>=</B&gt;</TD&gt;<TD align=left bgColor=white&gt;<INPUT size=80 name=txbFb426622&gt;</TD&gt;</FORM&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<BR&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;A</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;B</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;C</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;D</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;E</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;F</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;G</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;H</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;I</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;J</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;K</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;L</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;M</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle&gt;<CENTER&gt;N</CENTER&gt;</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;1</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Date</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Name</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1st&nbsp;Pilot&nbsp;Time</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Co-Pilot&nbsp;Time</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;A-Time</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Inst&nbsp;Time</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Night&nbsp;Time</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Pappr.</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Npappr.</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Landings</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Spec&nbsp;Time</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Type&nbsp;A/C</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Prof/Proj</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Type&nbsp;A/C&nbsp;Code</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;2</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1/26/2004</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Barry</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;2.5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;2.5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;NP-3D</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Proj</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;4</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;3</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1/26/2004</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Bowser</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;2.5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;2.5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;NP-3D</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Proj</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;4</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"&gt;<CENTER&gt;4</CENTER&gt;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;1/26/2004</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;Esparza</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;5</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;NP-3D</TD&gt;<TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;&nbsp;</TD&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"&gt;4</TD&gt;</TR&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" colSpan=15&gt;<TABLE width="100%" align=left VALIGN="TOP"&gt;<TBODY&gt;<TR&gt;<TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; WIDTH: 120pt; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff" align=left&gt;<U&gt;FHData</U&gt;</TD&gt;<TD&gt;&nbsp;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;<BR&gt;<FONT color=#339966 size=1&gt;[HtmlMaker 2.41] </FONT&gt;<FONT color=#339966 size=1&gt;To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT&gt;<BR&gt;<FONT color=red size=1&gt;PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT&gt;</CENTER&gt;

    I am having a problem with a nested Formula. If my lookup function returns a #N/A I would like it the cell to display "" else the lookup value. However I am having problems nexting the formula. Any Help would be welcome.


    {=IF(INDEX(Time,MATCH(Aircrew&Date,RANGE1&RANGE2,0))=ISNA,"",(INDEX(Time,MATCH(Aircrew&Date,RANGE1&RANGE2,0))))}


    Thanks