Posts by RichardS

RichardS · Dec 20th 2004

Hi all,

There is another post like this which I thought would solve my problem, but as always there is something slightly different.
http://www.ozgrid.com/forum/sh…light=chart+legend+labels

I have a client who wants to chart the results of antibiotic audits. There is an audit every week for six months. There are 32 doctors to be audited. We only want to show the cumulative result and current weeks result for those doctors who have had an audit undertaken. To achieve this, we hide the rows for each doctor with no audit, and all the columns except the cumulative and current week. This works fine, but as the number of doctors who have undertaken an audit increases, it becomes difficult to identify which column in the chart belongs to which doctor. I tried the solution in the above thread, by unhiding all doctors, adding data lables, and then over-typing these with the doctor code. The problem occured when I hid the unused doctors again, all the unused labels ended up on the first column.

Any suggestions?

Richard

RichardS · Dec 14th 2004

Re: grouped running sum

Hi Camper,

Is your data layout as shown? Is there a row between each incident? If so, try this.

Column E, Days =D3-C3
Column F Sum =IF(A3="Repair",0,IF(F2>0,F2+E3,E3))
Column G Running Sum =IF(B3=B2,G2+E3,E3)

Bound to be more elegant solutions out there, but it does what you asked for. There must be a blank row between the headers and your first row of data. You also need to have an end date for the repair the same as the start date.

Richard

RichardS · May 11th 2004

Try this

=IF(ISNA(MATCH($C1,$A$1:$A$12,0)=1),MATCH($C1,$B$1:$B$12,0)*2,MATCH($C1,$A$1:$A$12,0)*2-1)

Bit of a mouthful, but it seemed to work for the data you provided.

Richard

RichardS · May 11th 2004

Not to detract from Derks formula solution, which will be more reliable, but if you click on the Tools Menu, select Options, and select the Edit Tab, there is a check box there for "Extend list formats and formulas". If this is checked, Excel will try and interpret your actions, and autofill formulae. I'm running Excel 2000. Effectiveness probably varies depending on your version. Stick with Derk's solution.

Richard

RichardS · Mar 23rd 2004

There is a utility called asap utilities, available free from
http://www.asap-utilities.com
One option on the text menu is to reverse text in selected cells. Works well.

Richard

RichardS · Mar 22nd 2004

I was assuming your VLOOKUP formula is in a seperate file. What I am suggesting is you run your macro to create the source file from the .csv file, then when it is ready, open the file with the VLOOKUP formula. Below is my macro. I run this to open a .txt file, it then adds headers etc, names the used range, and saves as an excel file. When that is finished, I open my report file, which is full of VLOOKUP formulae referring to the named range. Works fine. So I have three files. one for the macro, the source .txt file, and finally my "real" file with the VLOOKUP's.

Richard

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 5/10/2001 by Richard.Staude
'

'
Application.DisplayAlerts = False
Call Shell("f:\Get Coleraine ACTD.bat", vbNormalFocus)
Application.Wait (Now + TimeValue("0:00:10"))
Workbooks.OpenText Filename:="F:\EXCELDTA\Coleraine\ACTD.txt", Origin:=xlWindows, _
StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(12 _
, 9), Array(41, 1), Array(53, 1), Array(66, 1), Array(79, 1), Array(92, 1), Array(105, 9))
ActiveCell.FormulaR1C1 = "1"
Range("B1").Select
ActiveCell.FormulaR1C1 = "2"
Range("C1").Select
ActiveCell.FormulaR1C1 = "3"
Range("D1").Select
ActiveCell.FormulaR1C1 = "4"
Range("E1").Select
ActiveCell.FormulaR1C1 = "5"
Range("F1").Select
ActiveCell.FormulaR1C1 = "6"
ActiveSheet.UsedRange.Name = "ledger"
Range("a2", "a" & Range("ledger").Rows.Count).Name = "find"
Range("A1").Select
ActiveWorkbook.SaveAs Filename:="F:\EXCELDTA\Coleraine\ledger.xls", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False
Application.DisplayAlerts = True
End Sub

RichardS · Mar 22nd 2004

Try leaving the file with the VLOOKUP formulae closed until your source file is ready. By deleting a row, you are deleting part of the data the formula is referring to, hence the #REF.

Richard

RichardS · Feb 17th 2004

[quote]Originally posted by Imbuzi
a paper thing what they called again...:biggrin::biggrin: [/quote

A book? :o

RichardS · Feb 10th 2004

Depending on what data entry is required, you could use Excels built in data entry form. If you put all your formulae in the first row (record) of your data, then hide those columns, then select Form from the Data menu, the only fields available on the form will be the unhidden ones. As data is entered, (using Tab between fields, and enter to complete a record), the formulae will be automatically filled down in your database. If there is a heap of data per record, this may be a bit cumbersome, but I hope it gives you an option.

Richard

RichardS · Jan 29th 2004

Refer to Dave's post. You need to establish priorities. Factory workers always get called back before office workers, priority 1. Seniority rules. Priority 2. On day off counts. Priority 3, and so on. Then you sort by each column in the reverse order so that the last column sorted by is factory or office. This can all be recorded using the macro recorder, and the macro can be attached to a button.

Is that clearer?

Richard

RichardS · Jan 29th 2004

If on sheet one, you have email addresses in column A, with Salesman in column B, then on Sheet 2 you have bounced email addresses in column A, in column B enter;

=VLOOKUP(A2,Sheet1!$A$2:$B$4,2,0)

Change the row numbers as appropriate.

Richard

RichardS · Jan 29th 2004

More info please. Is there anything that indicates which Salesman belongs to which email addresses? What is a bounce report? Please clarify.

Richard

RichardS · Dec 23rd 2003

Sounds to me like an advanced filter would meet your requirements. In what format is the other data sheet with the trailers on it? Say it has Trailer Number and Cargo, on the current sheet, you could have a cell with Cargo in it. Type Apples in the cell directly below. This becomes your Criteria. Then in another cell, type Trailer Number. This becomes you destination. Now select a blank cell clear of any data, choose Filter from the Data menu, and select Advaced. Expand the list range and select your data sheet, and the range, then select the criteria range, and finally destination. That should give you your data.

Post back if you need more help.

Richard

RichardS · Dec 17th 2003

I've made some improvements using SUMPRODUCT, but can't see where to upload the file. If you U2U me an email address, I will send it to you.

Column A is the amount you want broken down.
Row 1 is your denomications, starting at column B

Formula for B3
=IF(A3>+$B$1,ROUNDDOWN(A3/$B$1,0.1),0)

Formula for C3
=IF(A3-(B$1*B3)>=$C$1,ROUNDDOWN((A3-(B$1*B3))/$C$1,0.1),0)

Formula for D3
=IF($A3-SUMPRODUCT($B3:C3,$B$1:C$1)>=D$1,ROUNDDOWN(($A3-SUMPRODUCT($B3:C3,$B$1:C$1))/D$1,0.1),0)

This last one is copied across for as many denominations you have. Copy down as far as needed. It will give you the total number of each denomication yu need by summing at the bottom.

HTH

Richard

RichardS · Dec 17th 2003

OK, so it doesn't work too well, but you can see the formulae if you click on the cells. Gives you the number of each denomination required to make up the value of the pay packet.

Richard

RichardS · Dec 17th 2003

Does Colo's HTML maker work here? Not elegant, and someone could reduce to one line line by adding a SUMPRODUCT formulae, but it does work.

Richard

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=14><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Currency.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2000 : OS = Windows Windows 2000 </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=14><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp <A onclick=show_popup(); href="javascript:void(0)">(<U>A</U>)bout</A></TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=14><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value="=IF(A3>+$B$1,ROUNDDOWN(A3/$B$1,0.1),0)" selected>B3<OPTION value="=IF(A3-$B4>=$C$1,ROUNDDOWN((A3-$B4)/$C$1,0.1),0)">C3<OPTION value="=IF($A3-SUM($B4:C4)>=D$1,ROUNDDOWN(($A3-SUM($B4:C4))/D$1,0.1),0)">D3<OPTION value="=IF($A3-SUM($B4:D4)>=E$1,ROUNDDOWN(($A3-SUM($B4:D4))/E$1,0.1),0)">E3<OPTION value="=IF($A3-SUM($B4:E4)>=F$1,ROUNDDOWN(($A3-SUM($B4:E4))/F$1,0.1),0)">F3<OPTION value="=IF($A3-SUM($B4:F4)>=G$1,ROUNDDOWN(($A3-SUM($B4:F4))/G$1,0.1),0)">G3<OPTION value="=IF($A3-SUM($B4:G4)>=H$1,ROUNDDOWN(($A3-SUM($B4:G4))/H$1,0.1),0)">H3<OPTION value="=IF($A3-SUM($B4:H4)>=I$1,ROUNDDOWN(($A3-SUM($B4:H4))/I$1,0.1),0)">I3<OPTION value="=IF($A3-SUM($B4:I4)>=J$1,ROUNDDOWN(($A3-SUM($B4:I4))/J$1,0.1),0)">J3<OPTION value="=IF($A3-SUM($B4:J4)>=K$1,ROUNDDOWN(($A3-SUM($B4:J4))/K$1,0.1),0)">K3<OPTION value="=IF($A3-SUM($B4:K4)>=L$1,ROUNDDOWN(($A3-SUM($B4:K4))/L$1,0.1),0)">L3<OPTION value==B$1*B3>B4<OPTION value==C$1*C3>C4<OPTION value==D$1*D3>D4<OPTION value==E$1*E3>E4<OPTION value==F$1*F3>F4<OPTION value==G$1*G3>G4<OPTION value==H$1*H3>H4<OPTION value==I$1*I3>I4<OPTION value==J$1*J3>J4<OPTION value==K$1*K3>K4<OPTION value==L$1*L3>L4<OPTION value==SUM(B4:L4)>M4<OPTION value="=IF(A5>+$B$1,ROUNDDOWN(A5/$B$1,0.1),0)">B5<OPTION value="=IF(A5-$B6>=$C$1,ROUNDDOWN((A5-$B6)/$C$1,0.1),0)">C5<OPTION value="=IF($A5-SUM($B6:C6)>=D$1,ROUNDDOWN(($A5-SUM($B6:C6))/D$1,0.1),0)">D5<OPTION value="=IF($A5-SUM($B6:D6)>=E$1,ROUNDDOWN(($A5-SUM($B6:D6))/E$1,0.1),0)">E5<OPTION value="=IF($A5-SUM($B6:E6)>=F$1,ROUNDDOWN(($A5-SUM($B6:E6))/F$1,0.1),0)">F5<OPTION value="=IF($A5-SUM($B6:F6)>=G$1,ROUNDDOWN(($A5-SUM($B6:F6))/G$1,0.1),0)">G5<OPTION value="=IF($A5-SUM($B6:G6)>=H$1,ROUNDDOWN(($A5-SUM($B6:G6))/H$1,0.1),0)">H5<OPTION value="=IF($A5-SUM($B6:H6)>=I$1,ROUNDDOWN(($A5-SUM($B6:H6))/I$1,0.1),0)">I5<OPTION value="=IF($A5-SUM($B6:I6)>=J$1,ROUNDDOWN(($A5-SUM($B6:I6))/J$1,0.1),0)">J5<OPTION value="=IF($A5-SUM($B6:J6)>=K$1,ROUNDDOWN(($A5-SUM($B6:J6))/K$1,0.1),0)">K5<OPTION value="=IF($A5-SUM($B6:K6)>=L$1,ROUNDDOWN(($A5-SUM($B6:K6))/L$1,0.1),0)">L5<OPTION value==B$1*B5>B6<OPTION value==C$1*C5>C6<OPTION value==D$1*D5>D6<OPTION value==E$1*E5>E6<OPTION value==F$1*F5>F6<OPTION value==G$1*G5>G6<OPTION value==H$1*H5>H6<OPTION value==I$1*I5>I6<OPTION value==J$1*J5>J6<OPTION value==K$1*K5>K6<OPTION value==L$1*L5>L6<OPTION value==SUM(B6:L6)>M6<OPTION value="=IF(A7>+$B$1,ROUNDDOWN(A7/$B$1,0.1),0)">B7<OPTION value="=IF(A7-$B8>=$C$1,ROUNDDOWN((A7-$B8)/$C$1,0.1),0)">C7<OPTION value="=IF($A7-SUM($B8:C8)>=D$1,ROUNDDOWN(($A7-SUM($B8:C8))/D$1,0.1),0)">D7<OPTION value="=IF($A7-SUM($B8:D8)>=E$1,ROUNDDOWN(($A7-SUM($B8:D8))/E$1,0.1),0)">E7<OPTION value="=IF($A7-SUM($B8:E8)>=F$1,ROUNDDOWN(($A7-SUM($B8:E8))/F$1,0.1),0)">F7<OPTION value="=IF($A7-SUM($B8:F8)>=G$1,ROUNDDOWN(($A7-SUM($B8:F8))/G$1,0.1),0)">G7<OPTION value="=IF($A7-SUM($B8:G8)>=H$1,ROUNDDOWN(($A7-SUM($B8:G8))/H$1,0.1),0)">H7<OPTION value="=IF($A7-SUM($B8:H8)>=I$1,ROUNDDOWN(($A7-SUM($B8:H8))/I$1,0.1),0)">I7<OPTION value="=IF($A7-SUM($B8:I8)>=J$1,ROUNDDOWN(($A7-SUM($B8:I8))/J$1,0.1),0)">J7<OPTION value="=IF($A7-SUM($B8:J8)>=K$1,ROUNDDOWN(($A7-SUM($B8:J8))/K$1,0.1),0)">K7<OPTION value="=IF($A7-SUM($B8:K8)>=L$1,ROUNDDOWN(($A7-SUM($B8:K8))/L$1,0.1),0)">L7<OPTION value==B$1*B7>B8<OPTION value==C$1*C7>C8<OPTION value==D$1*D7>D8<OPTION value==E$1*E7>E8<OPTION value==F$1*F7>F8<OPTION value==G$1*G7>G8<OPTION value==H$1*H7>H8<OPTION value==I$1*I7>I8<OPTION value==J$1*J7>J8<OPTION value==K$1*K7>K8<OPTION value==L$1*L7>L8<OPTION value==SUM(B8:L8)>M8</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8><B>=</B></TD><TD align=left bgColor=white><INPUT size=80 value="=IF(A3>+$B$1,ROUNDDOWN(A3/$B$1,0.1),0)" name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><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%"><BR></TD><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><CENTER>A</CENTER></TD><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><CENTER>B</CENTER></TD><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><CENTER>C</CENTER></TD><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><CENTER>D</CENTER></TD><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><CENTER>E</CENTER></TD><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><CENTER>F</CENTER></TD><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><CENTER>G</CENTER></TD><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><CENTER>H</CENTER></TD><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><CENTER>I</CENTER></TD><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><CENTER>J</CENTER></TD><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><CENTER>K</CENTER></TD><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><CENTER>L</CENTER></TD><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><CENTER>M</CENTER></TD></TR><TR><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%"><CENTER>1</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Denomination >></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">100</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">50</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">20</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">10</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">5</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">2</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0.5</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0.2</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0.1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0.05</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><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%"><CENTER>2</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Pay</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Total</TD></TR><TR><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%"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">               256.25 </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[0].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            2 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[1].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[2].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[3].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[4].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[5].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[6].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[7].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[8].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[9].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[10].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><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%"><CENTER>4</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[11].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">    200.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[12].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">     50.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[13].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[14].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[15].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">       5.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[16].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[17].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">       1.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[18].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[19].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">       0.20 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[20].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[21].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">       0.05 </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[22].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">    256.25 </FONT></A></TD></TR><TR><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%"><CENTER>5</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">            3,652.00 </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[23].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          36 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[24].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[25].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[26].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[27].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[28].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[29].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[30].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[31].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[32].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[33].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><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%"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[34].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">  3,600.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[35].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">     50.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[36].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[37].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[38].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[39].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">       2.00 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[40].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[41].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[42].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[43].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[44].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[45].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">  3,652.00 </FONT></A></TD></TR><TR><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%"><CENTER>7</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">            2,265.35 </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[46].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          22 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[47].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[48].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[49].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[50].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[51].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[52].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[53].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">          -   </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[54].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[55].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"><A onclick="document.formFb078704.sltNb935705.options[56].selected=true; document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value;" href="javascript:void(0);">            1 </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: r

RichardS · Dec 17th 2003

Something like

=IF(COUNTIF(A1:H1,"x")=8,"Yes","No")

RichardS · Nov 4th 2003

Quote

Originally posted by WillR

My granfather used to build cars... (this was starting in 1896) - imagine if he'd said "15mph should be enough for anyone" .... where would we be ?? (probably still trying to get to work :biggrin: :biggrin: )

Will

But what would the road toll be? And if we only had 640k, would our software be as full of superfluous code (read bugs) as it is now?

RichardS · Sep 29th 2003

When I started at my current employer, the computer was a micromation, about 200mm high by 300mm wide by 350mm deep. Boot disk was an 8" floppy, and you turned a key to start it up. 40Mb HDD, and I think about 128Kb RAM.

BUT, we had a line printer attached that used to spit out A3 computer paper at a phenomonal rate. :o

RichardS · Sep 5th 2003

Hover your mouse over the bottom right hand corner of the active cell until the cursor turns into a cross, hold down your left mouse key and drag as required.

Richard

Posts by RichardS

Chart Legend as Labels

grouped running sum

Formula

Need to understand why

[Solved] Formulas : Inverting number

[Solved] VLOOKUP ... Input varies

[Solved] VLOOKUP ... Input varies

Board was down?

[Solved] Formulas : Automatically fill down formulas when a

[Solved] Data Validation : I need to sort data based on five

[Solved] Formulas : help looking up info on another workshee

[Solved] Formulas : help looking up info on another workshee

Formulas : Need Help.....

Formulas: HELP!!XL spreadsheet for cash breakdown

Formulas: HELP!!XL spreadsheet for cash breakdown

Formulas: HELP!!XL spreadsheet for cash breakdown

Logical Functions in Excel

Wisdom From Bill Gag Gates

Down the memory lane

[Solved] Formulas: Quickly entering formulas