Why isn't there a User Defined Function to calculate FIFO?

[Excelanil]

Hi:

I'm curious as to why hasn't anyone created an "open" Excel UDF to calculate FIFO as it relates to Stocks and Mutual Funds.

Don't get me wrong, there is one available. I found it on the Web --a template; but trying to adopt it for use is a nightmare of an an experience because the VBA code is protected; so you can't add any other VBA code or Macros. Or, if your existing Workbook/Sheet contains any VBA code or Macro, it is not possible to pull the template in for use.

The thing works well if it is used standalone; but the standalone does not conform to how most people track buying and selling and accounting for other things like: Interest Earned, Dividends Earned, Cash In, Cash Out; etc. in a spreadsheet.

I've been struggling with the available template I downloaded and have had nothing but problems in getting it to work in my situation. Most of the times I ended up with a lot of #VALUE errors in the column where the FIFO calculations are done.

Any ideas or anyone shedding light of this topic may ease my frustration.

Thank to all for supporting this forum. It is a great place to get answers.

Cheers!

 

[Andrew Poulsom]

If you are referring to the template here:

http://www.excel-it.com/workbook_downloads.htm

Someone seems to have posted the function here:

http://www.ozgrid.com/forum/showthread.php?t=26338

 

[Excelanil]

Thanks Andrew.

I didn't see the code other than http://www.excel-it.com/workbook_downloads.htm .

Now, I need to make this work. I think it requires two parameters as follows:

=FIFO(ProductCode,UnitsSold)

I'm not sure what it means by "As Currency"

I have no VBA experience; but I'm willing to learn.

Cheers!

 

[Andrew Poulsom]

The second link I posted has this code:

Function FIFO(ProductCode As Range, UnitsSold As Range) As Currency
    Dim StartCount As Range, UnitCost As Range, Products As Range, PurchaseUnits As Range
    Dim Counter As Integer, RemainingUnits As Long, UnitsAccountedFor As Long
    FIFO = 0
    Set Products = Range("ProductCode")
    Set StartCount = Range("StartCount")
    Set UnitCost = Range("UnitCost")
    Set PurchaseUnits = Range("PurchaseUnits")
    UnitsAccountedFor = UnitsSold
    For Counter = 1 To StartCount.Rows.Count
        If ProductCode = Products(Counter, 1) Then
            RemainingUnits = Application.WorksheetFunction.Max(0, StartCount(Counter, 1) + _
            PurchaseUnits(Counter, 1) - UnitsAccountedFor)
            FIFO = FIFO + UnitCost(Counter, 1) * RemainingUnits
            UnitsAccountedFor = UnitsAccountedFor - (StartCount(Counter, 1) + _
            PurchaseUnits(Counter, 1) - RemainingUnits)
        End If
    Next Counter
End Function

The function relies on the data being laid out in a certain way. Currency is a VBA data type:

Currency data type

A data type with a range of -922,337,203,685,477.5808 to 922,337,203,685,477.5807. Use this data type for calculations involving money and for fixed-point calculations where accuracy is particularly important. The at sign (@) type-declaration character represents Currency in Visual Basic.

 

[Excelanil]

Hi Andrew:

Thanks for this code

I do want to work with you to inplement this Function and make it work. Based on my experience working with the Template provided by this site:

http://www.excel-it.com/workbook_downloads.htm I think I understand how the data is laid out in that certain way. But time will tell when I get to the testing.

Now, what I have done so far is start a new workbook and copy and pasted the Function in a Macro sheet.

As a result, it created a Module1 (where the code resides) under the VBA Modules folder panel on the Left.

I named the VBA Sheet that now has the code, FIFO and got out of the VBA editor.

What's next? Or, am I going about it in the wronf way?

Thanks

 

[Andrew Poulsom]

Now you need to set up a worksheet as detailed in the instructions.

 

[Excelanil]

Hi Andrew:

Thanks. I'll try that.

In fact, I sort'a tried it this morning; but got the #VALUE error message again. However, it was a different approach than the one I used when I first downloaded the UDF from http://www.excel-it.com/workbook_downloads.htm.

I'm going to work on it some more and will let you know.

Cheers!

 

[Excelanil]

Hi Andrew:

I need some additional help.

So far, I've set up a worksheet with the following columns, A thru F:

<TABLE style="WIDTH: 292pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=388><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><TBODY><TR style="HEIGHT: 43.5pt" height=58><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 1.5pt solid; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; HEIGHT: 43.5pt; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl91 height=58 width=70>Date Purchased</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92 width=70>Product Code</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 45pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92 width=60>Opening Stock</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 50pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92 width=66>Quantity Purchased</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92 width=71>Unit Cost</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 38pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 1.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl93 width=51>Units Sold</TD></TR></TBODY></TABLE>

Along-side these columns, I have another three columns, H thru J:

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 43.5pt" height=58><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 1.5pt solid; WIDTH: 48pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; HEIGHT: 43.5pt; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 height=58 width=64>Product</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 48pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92 width=64>Sales</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 48pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 1.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl93 width=64>FIFO</TD></TR></TBODY></TABLE>

Now, these columns are all in Table Format

My data would like like this in Column A thru Column F:

<TABLE style="WIDTH: 292pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=388><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><TBODY><TR style="HEIGHT: 43.5pt" height=58><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 1.5pt solid; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; HEIGHT: 43.5pt; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl93 height=58 width=70>Date Purchased</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=70>Product Code</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 45pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=60>Opening Stock</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 50pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=66>Quantity Purchased</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=71>Unit Cost</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 38pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 1.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl95 width=51>Units Sold</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl96 height=22 align=right>4/10/2006</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>WITS</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91 align=right>23.78374359</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>195</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl96 height=20 align=right>4/10/2006</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>WITS</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>1</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>100</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91 align=right>23.7837</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl96 height=20 align=right>2/27/2007</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>VIMC</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>800</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91 align=right>7.00995</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl96 height=20 align=right>2/27/2007</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>VIMC</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>3</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>200</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91 align=right>7.00995</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl96 height=20 align=right>2/28/2007</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>BRCD</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>4</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>1000</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91 align=right>8.93995</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl96 height=20 align=right>3/1/2007</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>BRCD</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>5</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>1000</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91 align=right>8.76995</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl92>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl96 height=20 align=right>4/5/2007</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>SGI</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>6</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>1000</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91 align=right>14.50995</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD></TR></TBODY></TABLE>

and my data to the other table, Column H thru J would look something like this:

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 43.5pt" height=58><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 1.5pt solid; WIDTH: 48pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; HEIGHT: 43.5pt; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 height=58 width=64>Product</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 48pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92 width=64>Sales</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 48pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 1.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl93 width=64>FIFO</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl95 height=22>WITS</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl95 height=20>VIMC</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl95 height=20>SGI</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl95 height=20>BRCD</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" class=xl91></TD></TR></TBODY></TABLE>

I'm not sure how to apply the following formulae:

ProductCode =$B$6:OFFSET($B$6,COUNTA($B$6:$B$65536)-1,0)
PurchaseUnits =$D$6:OFFSET($D$6,COUNTA($D$6:$D$65536)-1,0)
StartCount =$C$6:OFFSET($C$6,COUNTA($C$6:$C$65536)-1,0)
UnitCost =$E$6:OFFSET($E$6,COUNTA($E$6:$E$65536)-1,0)
UnitsSold =$F$6:OFFSET($F$6,COUNTA($F$6:$F$65536)-1,0)

Column I supposed to have something like this:

Sales=SUMIF(ProductCode,$BK2,UnitsSold)

and Coulmn J supposed to have something like this:

=fifo($H2,$I2)

With the above and assuming I have the FIFO VBA Macro installed in Module 1, can you please help me here on out?

Thanks.

 

[Andrew Poulsom]

First a question. How can you sell 195 of WITS on 10 April 2006 when you only have 100 (purchased on the same day)?

 

[Excelanil]

Opps, my mistake.

It should have been Bought 195

<TABLE style="WIDTH: 292pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=388><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><TBODY><TR style="HEIGHT: 24pt" height=32><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 1.5pt solid; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; HEIGHT: 24pt; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl93 height=32 width=70>Date Purchased</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=70>Product Code</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 45pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=60>Opening Stock</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 50pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=66>Quantity Purchased</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 0.5pt dashed; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=71>Unit Cost</TD><TD style="BORDER-BOTTOM: #002060 1.5pt solid; BORDER-LEFT: #002060 0.5pt dashed; WIDTH: 38pt; FONT-FAMILY: Arial; BACKGROUND: #a5a5a5; COLOR: navy; FONT-SIZE: 8pt; BORDER-TOP: #002060 1.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #002060 1.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl95 width=51>Units Sold</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl96 height=21 align=right>4/10/2006</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>WITS</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>195</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl91 align=right>23.78374359</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Arial; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" class=xl92>0</TD></TR></TBODY></TABLE>

Sorry about that