two column lookup or macro

M

michaelsmith559

Well-known Member
Joined
Oct 6, 2013
Messages
881
Office Version
  1. 2013
  2. 2007
I have a list of numbers starting in cell a2 starting with
1600, in a3:1600.01, a4:1600.02......1600.99, 1601,
1601.01.... all the way to 1700 down column a. I have
as many numbers in column b and need to divide all
numbers in column a by every number in column b. I am
looking for a certain value that when a number in column
a is divided by a number in column b equals a certain
value. For example, somewhere in column a is a value:
1638.48. Somewhere in column b is the value:
505.4571217. When that value in column a is divided by
that value in column b the result is: 3.241580566. Is
there a macro that can let me specify the value I want
but return the corresponding values from column a & b
that make that value?
 
Sort by date Sort by votes
Try this, putting your specified value in cell C1.

It's not bombproof code .. in theory you need to allow for up to 1 million matches, but it should do what you want?

Code: 
Sub GetValues()

    Dim v As Variant
    Dim i As Long, j As Long, lNoRows As Long
    Dim lNoPlaces As Long, lCount As Long
    Dim dTarget As Double, dCombinations() As Double
    
    v = [A2:B10002].Value
    lNoPlaces = 6   'say
    dTarget = Round([C1], lNoPlaces)
    lNoRows = UBound(v)
    ReDim dCombinations(1 To 2, 1 To lNoRows) 'In theory you need to allow for up to lNoRows^2!
    On Error Resume Next
    [GetValuesResults].ClearContents
    On Error GoTo 0
    
    For i = 1 To lNoRows
        For j = 1 To lNoRows
            If v(j, 2) <> 0 Then
                If Round(v(i, 1) / v(j, 2), lNoPlaces) = dTarget Then
                    lCount = lCount + 1
                    dCombinations(1, lCount) = v(i, 1)
                    dCombinations(2, lCount) = v(j, 2)
                End If
            End If
        Next j
    Next i
    
    If lCount = 0 Then
        [C2] = "No matches found"
    Else
        ReDim Preserve dCombinations(1 To 2, 1 To lCount)
        With [C2].Resize(lCount, 2)
            .Value = Application.Transpose(dCombinations)
            .Name = "GetValuesResults"
        End With
    End If
    
End Sub
 
Upvote 0
StephenCrump, thanks for the quick reply. Just wanted to say
it will be a couple of weeks before I can try the code. My
computer's hard drive just crashed and I'm going to order
a new computer with Windows 7 Pro & Excel 2013. I
would like to know if I have any questions once I run the
code, if I could email you?
Thanks, Mike
 
Upvote 0
Thanks for the response. I'm sorry to hear about your computer:(.

It's probably better to post any follow up code questions in this thread:

1. More people available to help, correct any mistakes I make, suggest better alternatives that we can both learn from, etc.
2. Lets others learn as well as you.

There is also the option of sending PMs via this Forum, i.e. rather than e-mail.
 
Upvote 0
StephenCrump
Just got my computer in today and have excel up and running. Tried the code out and it works great. Just have a question. Would it be possible for you to change the code so that instead of me having to list all the numbers in column a and all the numbers in column b I could input them into an input box? For example, instead of column a could you have a message box pop up that asks for start number and end number (this example would be start number: 1542.00; end number: 1758.00)? And then instead of column b (too many numbers for me to list) have another box that lets me input start number and end number (this example would be start number:440.1112657; end number: 517.2568021)? And finally an input box for the target value (this example target value: 3.241580566)? I'm only asking because column b contains way too many numbers for me to input by hand or by dragging the plus sign at lower end of cell all the way down and column b would take a few sheets. I would just like to change how I can input the numbers and then let your code run. Like I said, it did great. One other question, do you know of any code that will let me find the numbers in a sum taking six at a time? I've tried solver, tm target match, and summatch.com but could not get any of them to work with values like: .3157907543. Thanks once again for the great code.

Mike
 
Upvote 0
Thanks Mike

Yes, easily done in theory, and probably easier to pick up cell values rather than create input boxes. For example, set

A1 = 1542
A2 = 1758
A3 = 0.01

and change the loop structure to something like:

Code: 
Dim a, dStartA As Double, dEndA As Double, dStepA As Double
Dim b, dStartB As Double, dEndB As Double, dStepB As Double

dStartA = [A1]
dEndA = [A2]
dStepA = [A3]
...

For a = dStartA To dEndA Step dStepA
    For b = dStartB To dEndB Step dStepB
        ....

You say that column B will take a few sheets ... are you really proposing to step from 440.1112657 to 517.2568021 in increments of 0.0000001?

If this is a real problem you are trying to solve(?) there must be a smarter way than this sledgehammer approach?

I am not sure I understand your second question. It sounds like you have a column of numbers and a target value, and you want to identify which combinations of 6 numbers from the column add to the target?

If that's the question, there are several posts on this Forum that might help, e.g.

http://www.mrexcel.com/forum/excel-questions/618614-total-126-a.html
 
Upvote 0
StephenCrump,
Where do I put the code change you suggested in the previous code? I tried to do the column b numbers by using 440, 440.1.....516.9,517. The problem is that is introduces too much rounding error and gives more than one solution. I found by doing some by hand on a calculator that if I extend the numbers to 440.1112657 etc. the answer is precisely what I need. If there is another way for me to solve this problem I am open to suggestions. I have a number or target value: 3.241580566. I don't have the exact values that make that result. I only know the range of numbers used. I guess this could be some type of subset sum problem. If so, mathematica has a webpage on subset sum problems but I don't know how you could implement it in vba and I don't have mathematica. You are correct on the second question. I have tried solver, tm target match, summatch.com, and they won't work with values like: 0.3157907543. I found a udf here: Excel udf: Find numbers in sum | Get Digital Help - Microsoft Excel resource but I need to convert it to a macro to work with the values I have like: 0.3157907543. There are 42 numbers like this in a column. An example sum would be 1.993284672. I like the udf, I just wish I could turn it into a macro to work with the type of numbers I need.
Mike
 
Upvote 0
Here is the result of your code:

<colgroup><col style="mso-width-source:userset;mso-width-alt:2340; width:48pt" span="2" width="64"> <col style="width:48pt" span="2" width="64"> </colgroup><tbody>
[TD="class: xl63, width: 64, align: right"]1542.0[/TD]
[TD="class: xl63, width: 64, align: right"]440.0[/TD]
[TD="class: xl64, width: 64, align: right"]3.2416[/TD]
[TD="width: 64"][/TD]

[TD="class: xl63, align: right"]1543.0[/TD]
[TD="class: xl63, align: right"]440.1[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]505.3[/TD]

[TD="class: xl63, align: right"]1544.0[/TD]
[TD="class: xl63, align: right"]440.2[/TD]

[TD="class: xl63, align: right"]1545.0[/TD]
[TD="class: xl63, align: right"]440.3[/TD]

[TD="class: xl63, align: right"]1546.0[/TD]
[TD="class: xl63, align: right"]440.4[/TD]

[TD="class: xl63, align: right"]1547.0[/TD]
[TD="class: xl63, align: right"]440.5[/TD]

[TD="class: xl63, align: right"]1548.0[/TD]
[TD="class: xl63, align: right"]440.6[/TD]

[TD="class: xl63, align: right"]1549.0[/TD]
[TD="class: xl63, align: right"]440.7[/TD]

[TD="class: xl63, align: right"]1550.0[/TD]
[TD="class: xl63, align: right"]440.8[/TD]

[TD="class: xl63, align: right"]1551.0[/TD]
[TD="class: xl63, align: right"]440.9[/TD]

[TD="class: xl63, align: right"]1552.0[/TD]
[TD="class: xl63, align: right"]441.0[/TD]

[TD="class: xl63, align: right"]1553.0[/TD]
[TD="class: xl63, align: right"]441.1[/TD]

[TD="class: xl63, align: right"]1554.0[/TD]
[TD="class: xl63, align: right"]441.2[/TD]

[TD="class: xl63, align: right"]1555.0[/TD]
[TD="class: xl63, align: right"]441.3[/TD]

[TD="class: xl63, align: right"]1556.0[/TD]
[TD="class: xl63, align: right"]441.4[/TD]

[TD="class: xl63, align: right"]1557.0[/TD]
[TD="class: xl63, align: right"]441.5[/TD]

[TD="class: xl63, align: right"]1558.0[/TD]
[TD="class: xl63, align: right"]441.6[/TD]

[TD="class: xl63, align: right"]1559.0[/TD]
[TD="class: xl63, align: right"]441.7[/TD]

[TD="class: xl63, align: right"]1560.0[/TD]
[TD="class: xl63, align: right"]441.8[/TD]

[TD="class: xl63, align: right"]1561.0[/TD]
[TD="class: xl63, align: right"]441.9[/TD]

[TD="class: xl63, align: right"]1562.0[/TD]
[TD="class: xl63, align: right"]442.0[/TD]

[TD="class: xl63, align: right"]1563.0[/TD]
[TD="class: xl63, align: right"]442.1[/TD]

[TD="class: xl63, align: right"]1564.0[/TD]
[TD="class: xl63, align: right"]442.2[/TD]

[TD="class: xl63, align: right"]1565.0[/TD]
[TD="class: xl63, align: right"]442.3[/TD]

[TD="class: xl63, align: right"]1566.0[/TD]
[TD="class: xl63, align: right"]442.4[/TD]

[TD="class: xl63, align: right"]1567.0[/TD]
[TD="class: xl63, align: right"]442.5[/TD]

[TD="class: xl63, align: right"]1568.0[/TD]
[TD="class: xl63, align: right"]442.6[/TD]

[TD="class: xl63, align: right"]1569.0[/TD]
[TD="class: xl63, align: right"]442.7[/TD]

[TD="class: xl63, align: right"]1570.0[/TD]
[TD="class: xl63, align: right"]442.8[/TD]

[TD="class: xl63, align: right"]1571.0[/TD]
[TD="class: xl63, align: right"]442.9[/TD]

[TD="class: xl63, align: right"]1572.0[/TD]
[TD="class: xl63, align: right"]443.0[/TD]

[TD="class: xl63, align: right"]1573.0[/TD]
[TD="class: xl63, align: right"]443.1[/TD]

[TD="class: xl63, align: right"]1574.0[/TD]
[TD="class: xl63, align: right"]443.2[/TD]

[TD="class: xl63, align: right"]1575.0[/TD]
[TD="class: xl63, align: right"]443.3[/TD]

[TD="class: xl63, align: right"]1576.0[/TD]
[TD="class: xl63, align: right"]443.4[/TD]

[TD="class: xl63, align: right"]1577.0[/TD]
[TD="class: xl63, align: right"]443.5[/TD]

[TD="class: xl63, align: right"]1578.0[/TD]
[TD="class: xl63, align: right"]443.6[/TD]

[TD="class: xl63, align: right"]1579.0[/TD]
[TD="class: xl63, align: right"]443.7[/TD]

[TD="class: xl63, align: right"]1580.0[/TD]
[TD="class: xl63, align: right"]443.8[/TD]

[TD="class: xl63, align: right"]1581.0[/TD]
[TD="class: xl63, align: right"]443.9[/TD]

[TD="class: xl63, align: right"]1582.0[/TD]
[TD="class: xl63, align: right"]444.0[/TD]

[TD="class: xl63, align: right"]1583.0[/TD]
[TD="class: xl63, align: right"]444.1[/TD]

[TD="class: xl63, align: right"]1584.0[/TD]
[TD="class: xl63, align: right"]444.2[/TD]

[TD="class: xl63, align: right"]1585.0[/TD]
[TD="class: xl63, align: right"]444.3[/TD]

[TD="class: xl63, align: right"]1586.0[/TD]
[TD="class: xl63, align: right"]444.4[/TD]

[TD="class: xl63, align: right"]1587.0[/TD]
[TD="class: xl63, align: right"]444.5[/TD]

[TD="class: xl63, align: right"]1588.0[/TD]
[TD="class: xl63, align: right"]444.6[/TD]

[TD="class: xl63, align: right"]1589.0[/TD]
[TD="class: xl63, align: right"]444.7[/TD]

[TD="class: xl63, align: right"]1590.0[/TD]
[TD="class: xl63, align: right"]444.8[/TD]

[TD="class: xl63, align: right"]1591.0[/TD]
[TD="class: xl63, align: right"]444.9[/TD]

[TD="class: xl63, align: right"]1592.0[/TD]
[TD="class: xl63, align: right"]445.0[/TD]

[TD="class: xl63, align: right"]1593.0[/TD]
[TD="class: xl63, align: right"]445.1[/TD]

[TD="class: xl63, align: right"]1594.0[/TD]
[TD="class: xl63, align: right"]445.2[/TD]

[TD="class: xl63, align: right"]1595.0[/TD]
[TD="class: xl63, align: right"]445.3[/TD]

[TD="class: xl63, align: right"]1596.0[/TD]
[TD="class: xl63, align: right"]445.4[/TD]

[TD="class: xl63, align: right"]1597.0[/TD]
[TD="class: xl63, align: right"]445.5[/TD]

[TD="class: xl63, align: right"]1598.0[/TD]
[TD="class: xl63, align: right"]445.6[/TD]

[TD="class: xl63, align: right"]1599.0[/TD]
[TD="class: xl63, align: right"]445.7[/TD]

[TD="class: xl63, align: right"]1600.0[/TD]
[TD="class: xl63, align: right"]445.8[/TD]

[TD="class: xl63, align: right"]1601.0[/TD]
[TD="class: xl63, align: right"]445.9[/TD]

[TD="class: xl63, align: right"]1602.0[/TD]
[TD="class: xl63, align: right"]446.0[/TD]

[TD="class: xl63, align: right"]1603.0[/TD]
[TD="class: xl63, align: right"]446.1[/TD]

[TD="class: xl63, align: right"]1604.0[/TD]
[TD="class: xl63, align: right"]446.2[/TD]

[TD="class: xl63, align: right"]1605.0[/TD]
[TD="class: xl63, align: right"]446.3[/TD]

[TD="class: xl63, align: right"]1606.0[/TD]
[TD="class: xl63, align: right"]446.4[/TD]

[TD="class: xl63, align: right"]1607.0[/TD]
[TD="class: xl63, align: right"]446.5[/TD]

[TD="class: xl63, align: right"]1608.0[/TD]
[TD="class: xl63, align: right"]446.6[/TD]

[TD="class: xl63, align: right"]1609.0[/TD]
[TD="class: xl63, align: right"]446.7[/TD]

[TD="class: xl63, align: right"]1610.0[/TD]
[TD="class: xl63, align: right"]446.8[/TD]

[TD="class: xl63, align: right"]1611.0[/TD]
[TD="class: xl63, align: right"]446.9[/TD]

[TD="class: xl63, align: right"]1612.0[/TD]
[TD="class: xl63, align: right"]447.0[/TD]

[TD="class: xl63, align: right"]1613.0[/TD]
[TD="class: xl63, align: right"]447.1[/TD]

[TD="class: xl63, align: right"]1614.0[/TD]
[TD="class: xl63, align: right"]447.2[/TD]

[TD="class: xl63, align: right"]1615.0[/TD]
[TD="class: xl63, align: right"]447.3[/TD]

[TD="class: xl63, align: right"]1616.0[/TD]
[TD="class: xl63, align: right"]447.4[/TD]

[TD="class: xl63, align: right"]1617.0[/TD]
[TD="class: xl63, align: right"]447.5[/TD]

[TD="class: xl63, align: right"]1618.0[/TD]
[TD="class: xl63, align: right"]447.6[/TD]

[TD="class: xl63, align: right"]1619.0[/TD]
[TD="class: xl63, align: right"]447.7[/TD]

[TD="class: xl63, align: right"]1620.0[/TD]
[TD="class: xl63, align: right"]447.8[/TD]

[TD="class: xl63, align: right"]1621.0[/TD]
[TD="class: xl63, align: right"]447.9[/TD]

[TD="class: xl63, align: right"]1622.0[/TD]
[TD="class: xl63, align: right"]448.0[/TD]

[TD="class: xl63, align: right"]1623.0[/TD]
[TD="class: xl63, align: right"]448.1[/TD]

[TD="class: xl63, align: right"]1624.0[/TD]
[TD="class: xl63, align: right"]448.2[/TD]

[TD="class: xl63, align: right"]1625.0[/TD]
[TD="class: xl63, align: right"]448.3[/TD]

[TD="class: xl63, align: right"]1626.0[/TD]
[TD="class: xl63, align: right"]448.4[/TD]

[TD="class: xl63, align: right"]1627.0[/TD]
[TD="class: xl63, align: right"]448.5[/TD]

[TD="class: xl63, align: right"]1628.0[/TD]
[TD="class: xl63, align: right"]448.6[/TD]

[TD="class: xl63, align: right"]1629.0[/TD]
[TD="class: xl63, align: right"]448.7[/TD]

[TD="class: xl63, align: right"]1630.0[/TD]
[TD="class: xl63, align: right"]448.8[/TD]

[TD="class: xl63, align: right"]1631.0[/TD]
[TD="class: xl63, align: right"]448.9[/TD]

[TD="class: xl63, align: right"]1632.0[/TD]
[TD="class: xl63, align: right"]449.0[/TD]

[TD="class: xl63, align: right"]1633.0[/TD]
[TD="class: xl63, align: right"]449.1[/TD]

[TD="class: xl63, align: right"]1634.0[/TD]
[TD="class: xl63, align: right"]449.2[/TD]

[TD="class: xl63, align: right"]1635.0[/TD]
[TD="class: xl63, align: right"]449.3[/TD]

[TD="class: xl63, align: right"]1636.0[/TD]
[TD="class: xl63, align: right"]449.4[/TD]

[TD="class: xl63, align: right"]1637.0[/TD]
[TD="class: xl63, align: right"]449.5[/TD]

[TD="class: xl63, align: right"]1638.0[/TD]
[TD="class: xl63, align: right"]449.6[/TD]

[TD="class: xl63, align: right"]1639.0[/TD]
[TD="class: xl63, align: right"]449.7[/TD]

[TD="class: xl63, align: right"]1640.0[/TD]
[TD="class: xl63, align: right"]449.8[/TD]

[TD="class: xl63, align: right"]1641.0[/TD]
[TD="class: xl63, align: right"]449.9[/TD]

[TD="class: xl63, align: right"]1642.0[/TD]
[TD="class: xl63, align: right"]450.0[/TD]

[TD="class: xl63, align: right"]1643.0[/TD]
[TD="class: xl63, align: right"]450.1[/TD]

[TD="class: xl63, align: right"]1644.0[/TD]
[TD="class: xl63, align: right"]450.2[/TD]

[TD="class: xl63, align: right"]1645.0[/TD]
[TD="class: xl63, align: right"]450.3[/TD]

[TD="class: xl63, align: right"]1646.0[/TD]
[TD="class: xl63, align: right"]450.4[/TD]

[TD="class: xl63, align: right"]1647.0[/TD]
[TD="class: xl63, align: right"]450.5[/TD]

[TD="class: xl63, align: right"]1648.0[/TD]
[TD="class: xl63, align: right"]450.6[/TD]

[TD="class: xl63, align: right"]1649.0[/TD]
[TD="class: xl63, align: right"]450.7[/TD]

[TD="class: xl63, align: right"]1650.0[/TD]
[TD="class: xl63, align: right"]450.8[/TD]

[TD="class: xl63, align: right"]1651.0[/TD]
[TD="class: xl63, align: right"]450.9[/TD]

[TD="class: xl63, align: right"]1652.0[/TD]
[TD="class: xl63, align: right"]451.0[/TD]

[TD="class: xl63, align: right"]1653.0[/TD]
[TD="class: xl63, align: right"]451.1[/TD]

[TD="class: xl63, align: right"]1654.0[/TD]
[TD="class: xl63, align: right"]451.2[/TD]

[TD="class: xl63, align: right"]1655.0[/TD]
[TD="class: xl63, align: right"]451.3[/TD]

[TD="class: xl63, align: right"]1656.0[/TD]
[TD="class: xl63, align: right"]451.4[/TD]

[TD="class: xl63, align: right"]1657.0[/TD]
[TD="class: xl63, align: right"]451.5[/TD]

[TD="class: xl63, align: right"]1658.0[/TD]
[TD="class: xl63, align: right"]451.6[/TD]

[TD="class: xl63, align: right"]1659.0[/TD]
[TD="class: xl63, align: right"]451.7[/TD]

[TD="class: xl63, align: right"]1660.0[/TD]
[TD="class: xl63, align: right"]451.8[/TD]

[TD="class: xl63, align: right"]1661.0[/TD]
[TD="class: xl63, align: right"]451.9[/TD]

[TD="class: xl63, align: right"]1662.0[/TD]
[TD="class: xl63, align: right"]452.0[/TD]

[TD="class: xl63, align: right"]1663.0[/TD]
[TD="class: xl63, align: right"]452.1[/TD]

[TD="class: xl63, align: right"]1664.0[/TD]
[TD="class: xl63, align: right"]452.2[/TD]

[TD="class: xl63, align: right"]1665.0[/TD]
[TD="class: xl63, align: right"]452.3[/TD]

[TD="class: xl63, align: right"]1666.0[/TD]
[TD="class: xl63, align: right"]452.4[/TD]

[TD="class: xl63, align: right"]1667.0[/TD]
[TD="class: xl63, align: right"]452.5[/TD]

[TD="class: xl63, align: right"]1668.0[/TD]
[TD="class: xl63, align: right"]452.6[/TD]

[TD="class: xl63, align: right"]1669.0[/TD]
[TD="class: xl63, align: right"]452.7[/TD]

[TD="class: xl63, align: right"]1670.0[/TD]
[TD="class: xl63, align: right"]452.8[/TD]

[TD="class: xl63, align: right"]1671.0[/TD]
[TD="class: xl63, align: right"]452.9[/TD]

[TD="class: xl63, align: right"]1672.0[/TD]
[TD="class: xl63, align: right"]453.0[/TD]

[TD="class: xl63, align: right"]1673.0[/TD]
[TD="class: xl63, align: right"]453.1[/TD]

[TD="class: xl63, align: right"]1674.0[/TD]
[TD="class: xl63, align: right"]453.2[/TD]

[TD="class: xl63, align: right"]1675.0[/TD]
[TD="class: xl63, align: right"]453.3[/TD]

[TD="class: xl63, align: right"]1676.0[/TD]
[TD="class: xl63, align: right"]453.4[/TD]

[TD="class: xl63, align: right"]1677.0[/TD]
[TD="class: xl63, align: right"]453.5[/TD]

[TD="class: xl63, align: right"]1678.0[/TD]
[TD="class: xl63, align: right"]453.6[/TD]

[TD="class: xl63, align: right"]1679.0[/TD]
[TD="class: xl63, align: right"]453.7[/TD]

[TD="class: xl63, align: right"]1680.0[/TD]
[TD="class: xl63, align: right"]453.8[/TD]

[TD="class: xl63, align: right"]1681.0[/TD]
[TD="class: xl63, align: right"]453.9[/TD]

[TD="class: xl63, align: right"]1682.0[/TD]
[TD="class: xl63, align: right"]454.0[/TD]

[TD="class: xl63, align: right"]1683.0[/TD]
[TD="class: xl63, align: right"]454.1[/TD]

[TD="class: xl63, align: right"]1684.0[/TD]
[TD="class: xl63, align: right"]454.2[/TD]

[TD="class: xl63, align: right"]1685.0[/TD]
[TD="class: xl63, align: right"]454.3[/TD]

[TD="class: xl63, align: right"]1686.0[/TD]
[TD="class: xl63, align: right"]454.4[/TD]

[TD="class: xl63, align: right"]1687.0[/TD]
[TD="class: xl63, align: right"]454.5[/TD]

[TD="class: xl63, align: right"]1688.0[/TD]
[TD="class: xl63, align: right"]454.6[/TD]

[TD="class: xl63, align: right"]1689.0[/TD]
[TD="class: xl63, align: right"]454.7[/TD]

[TD="class: xl63, align: right"]1690.0[/TD]
[TD="class: xl63, align: right"]454.8[/TD]

[TD="class: xl63, align: right"]1691.0[/TD]
[TD="class: xl63, align: right"]454.9[/TD]

[TD="class: xl63, align: right"]1692.0[/TD]
[TD="class: xl63, align: right"]455.0[/TD]

[TD="class: xl63, align: right"]1693.0[/TD]
[TD="class: xl63, align: right"]455.1[/TD]

[TD="class: xl63, align: right"]1694.0[/TD]
[TD="class: xl63, align: right"]455.2[/TD]

[TD="class: xl63, align: right"]1695.0[/TD]
[TD="class: xl63, align: right"]455.3[/TD]

[TD="class: xl63, align: right"]1696.0[/TD]
[TD="class: xl63, align: right"]455.4[/TD]

[TD="class: xl63, align: right"]1697.0[/TD]
[TD="class: xl63, align: right"]455.5[/TD]

[TD="class: xl63, align: right"]1698.0[/TD]
[TD="class: xl63, align: right"]455.6[/TD]

[TD="class: xl63, align: right"]1699.0[/TD]
[TD="class: xl63, align: right"]455.7[/TD]

[TD="class: xl63, align: right"]1700.0[/TD]
[TD="class: xl63, align: right"]455.8[/TD]

[TD="class: xl63, align: right"]1701.0[/TD]
[TD="class: xl63, align: right"]455.9[/TD]

[TD="class: xl63, align: right"]1702.0[/TD]
[TD="class: xl63, align: right"]456.0[/TD]

[TD="class: xl63, align: right"]1703.0[/TD]
[TD="class: xl63, align: right"]456.1[/TD]

[TD="class: xl63, align: right"]1704.0[/TD]
[TD="class: xl63, align: right"]456.2[/TD]

[TD="class: xl63, align: right"]1705.0[/TD]
[TD="class: xl63, align: right"]456.3[/TD]

[TD="class: xl63, align: right"]1706.0[/TD]
[TD="class: xl63, align: right"]456.4[/TD]

[TD="class: xl63, align: right"]1707.0[/TD]
[TD="class: xl63, align: right"]456.5[/TD]

[TD="class: xl63, align: right"]1708.0[/TD]
[TD="class: xl63, align: right"]456.6[/TD]

[TD="class: xl63, align: right"]1709.0[/TD]
[TD="class: xl63, align: right"]456.7[/TD]

[TD="class: xl63, align: right"]1710.0[/TD]
[TD="class: xl63, align: right"]456.8[/TD]

[TD="class: xl63, align: right"]1711.0[/TD]
[TD="class: xl63, align: right"]456.9[/TD]

[TD="class: xl63, align: right"]1712.0[/TD]
[TD="class: xl63, align: right"]457.0[/TD]

[TD="class: xl63, align: right"]1713.0[/TD]
[TD="class: xl63, align: right"]457.1[/TD]

[TD="class: xl63, align: right"]1714.0[/TD]
[TD="class: xl63, align: right"]457.2[/TD]

[TD="class: xl63, align: right"]1715.0[/TD]
[TD="class: xl63, align: right"]457.3[/TD]

[TD="class: xl63, align: right"]1716.0[/TD]
[TD="class: xl63, align: right"]457.4[/TD]

[TD="class: xl63, align: right"]1717.0[/TD]
[TD="class: xl63, align: right"]457.5[/TD]

[TD="class: xl63, align: right"]1718.0[/TD]
[TD="class: xl63, align: right"]457.6[/TD]

[TD="class: xl63, align: right"]1719.0[/TD]
[TD="class: xl63, align: right"]457.7[/TD]

[TD="class: xl63, align: right"]1720.0[/TD]
[TD="class: xl63, align: right"]457.8[/TD]

[TD="class: xl63, align: right"]1721.0[/TD]
[TD="class: xl63, align: right"]457.9[/TD]

[TD="class: xl63, align: right"]1722.0[/TD]
[TD="class: xl63, align: right"]458.0[/TD]

[TD="class: xl63, align: right"]1723.0[/TD]
[TD="class: xl63, align: right"]458.1[/TD]

[TD="class: xl63, align: right"]1724.0[/TD]
[TD="class: xl63, align: right"]458.2[/TD]

[TD="class: xl63, align: right"]1725.0[/TD]
[TD="class: xl63, align: right"]458.3[/TD]

[TD="class: xl63, align: right"]1726.0[/TD]
[TD="class: xl63, align: right"]458.4[/TD]

[TD="class: xl63, align: right"]1727.0[/TD]
[TD="class: xl63, align: right"]458.5[/TD]

[TD="class: xl63, align: right"]1728.0[/TD]
[TD="class: xl63, align: right"]458.6[/TD]

[TD="class: xl63, align: right"]1729.0[/TD]
[TD="class: xl63, align: right"]458.7[/TD]

[TD="class: xl63, align: right"]1730.0[/TD]
[TD="class: xl63, align: right"]458.8[/TD]

[TD="class: xl63, align: right"]1731.0[/TD]
[TD="class: xl63, align: right"]458.9[/TD]

[TD="class: xl63, align: right"]1732.0[/TD]
[TD="class: xl63, align: right"]459.0[/TD]

[TD="class: xl63, align: right"]1733.0[/TD]
[TD="class: xl63, align: right"]459.1[/TD]

[TD="class: xl63, align: right"]1734.0[/TD]
[TD="class: xl63, align: right"]459.2[/TD]

[TD="class: xl63, align: right"]1735.0[/TD]
[TD="class: xl63, align: right"]459.3[/TD]

[TD="class: xl63, align: right"]1736.0[/TD]
[TD="class: xl63, align: right"]459.4[/TD]

[TD="class: xl63, align: right"]1737.0[/TD]
[TD="class: xl63, align: right"]459.5[/TD]

[TD="class: xl63, align: right"]1738.0[/TD]
[TD="class: xl63, align: right"]459.6[/TD]

[TD="class: xl63, align: right"]1739.0[/TD]
[TD="class: xl63, align: right"]459.7[/TD]

[TD="class: xl63, align: right"]1740.0[/TD]
[TD="class: xl63, align: right"]459.8[/TD]

[TD="class: xl63, align: right"]1741.0[/TD]
[TD="class: xl63, align: right"]459.9[/TD]

[TD="class: xl63, align: right"]1742.0[/TD]
[TD="class: xl63, align: right"]460.0[/TD]

[TD="class: xl63, align: right"]1743.0[/TD]
[TD="class: xl63, align: right"]460.1[/TD]

[TD="class: xl63, align: right"]1744.0[/TD]
[TD="class: xl63, align: right"]460.2[/TD]

[TD="class: xl63, align: right"]1745.0[/TD]
[TD="class: xl63, align: right"]460.3[/TD]

[TD="class: xl63, align: right"]1746.0[/TD]
[TD="class: xl63, align: right"]460.4[/TD]

[TD="class: xl63, align: right"]1747.0[/TD]
[TD="class: xl63, align: right"]460.5[/TD]

[TD="class: xl63, align: right"]1748.0[/TD]
[TD="class: xl63, align: right"]460.6[/TD]

[TD="class: xl63, align: right"]1749.0[/TD]
[TD="class: xl63, align: right"]460.7[/TD]

[TD="class: xl63, align: right"]1750.0[/TD]
[TD="class: xl63, align: right"]460.8[/TD]

[TD="class: xl63, align: right"]1751.0[/TD]
[TD="class: xl63, align: right"]460.9[/TD]

[TD="class: xl63, align: right"]1752.0[/TD]
[TD="class: xl63, align: right"]461.0[/TD]

[TD="class: xl63, align: right"]1753.0[/TD]
[TD="class: xl63, align: right"]461.1[/TD]

[TD="class: xl63, align: right"]1754.0[/TD]
[TD="class: xl63, align: right"]461.2[/TD]

[TD="class: xl63, align: right"]1755.0[/TD]
[TD="class: xl63, align: right"]461.3[/TD]

[TD="class: xl63, align: right"]1756.0[/TD]
[TD="class: xl63, align: right"]461.4[/TD]

[TD="class: xl63, align: right"]1757.0[/TD]
[TD="class: xl63, align: right"]461.5[/TD]

[TD="class: xl63, align: right"]1758.0[/TD]
[TD="class: xl63, align: right"]461.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]461.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]461.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]461.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]462.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]463.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]464.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]465.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]466.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]467.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]468.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]469.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]470.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]471.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]472.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]473.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]474.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]475.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]476.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]477.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]478.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]479.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]480.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]481.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]482.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]483.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]484.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]485.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]486.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]487.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]488.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]489.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]490.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]491.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]492.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]493.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]494.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]495.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]496.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]497.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]498.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]499.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]500.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]501.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]502.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]503.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]504.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]505.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]506.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]507.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]508.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]509.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]510.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]511.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]512.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]513.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]514.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]515.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]516.9[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.0[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.2[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.4[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.5[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.6[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.7[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.8[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]517.9[/TD]

</tbody>
Works great. I would like column be to be able to work with the long decimal values and ranges as it increases the accuracy of the results. Also, could you please have a look at the numbers in sum problem. I think I can round the values but again the decimal values increase accuracy.

<colgroup><col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> </colgroup><tbody>
[TD="class: xl65, width: 88, align: right"]0.3097080292[/TD]

[TD="class: xl65, align: right"]0.3109245742[/TD]

[TD="class: xl65, align: right"]0.3121411192[/TD]

[TD="class: xl65, align: right"]0.3133576642[/TD]

[TD="class: xl65, align: right"]0.3145742092[/TD]

[TD="class: xl65, align: right"]0.3157907543[/TD]

[TD="class: xl65, align: right"]0.3170072993[/TD]

[TD="class: xl65, align: right"]0.3182238443[/TD]

[TD="class: xl65, align: right"]0.3194403893[/TD]

[TD="class: xl65, align: right"]0.3206569343[/TD]

[TD="class: xl65, align: right"]0.3218734793[/TD]

[TD="class: xl65, align: right"]0.3230900243[/TD]

[TD="class: xl65, align: right"]0.3243065693[/TD]

[TD="class: xl65, align: right"]0.3255231144[/TD]

[TD="class: xl65, align: right"]0.3267396594[/TD]

[TD="class: xl65, align: right"]0.3279562044[/TD]

[TD="class: xl65, align: right"]0.3291727494[/TD]

[TD="class: xl65, align: right"]0.3303892944[/TD]

[TD="class: xl65, align: right"]0.3316058394[/TD]

[TD="class: xl65, align: right"]0.3328223844[/TD]

[TD="class: xl65, align: right"]0.3340389294[/TD]

[TD="class: xl65, align: right"]0.3352554745[/TD]

[TD="class: xl65, align: right"]0.3364720195[/TD]

[TD="class: xl65, align: right"]0.3376885645[/TD]

[TD="class: xl65, align: right"]0.3389051095[/TD]

[TD="class: xl65, align: right"]0.3401216545[/TD]

[TD="class: xl65, align: right"]0.3413381995[/TD]

[TD="class: xl65, align: right"]0.3425547445[/TD]

[TD="class: xl65, align: right"]0.3437712895[/TD]

[TD="class: xl65, align: right"]0.3449878345[/TD]

[TD="class: xl65, align: right"]0.3462043796[/TD]

[TD="class: xl65, align: right"]0.3474209246[/TD]

[TD="class: xl65, align: right"]0.3486374696[/TD]

[TD="class: xl65, align: right"]0.3498540146[/TD]

[TD="class: xl65, align: right"]0.3510705596[/TD]

[TD="class: xl65, align: right"]0.3522871046[/TD]

[TD="class: xl65, align: right"]0.3535036496[/TD]

[TD="class: xl65, align: right"]0.3547201946[/TD]

[TD="class: xl65, align: right"]0.3559367397[/TD]

[TD="class: xl65, align: right"]0.3571532847[/TD]

[TD="class: xl65, align: right"]0.3583698297[/TD]

[TD="class: xl65, align: right"]0.3595863747[/TD]

</tbody>
I think I can round them and the sum to four decimal places.

<colgroup><col width="81"></colgroup><tbody>
[TD="class: xl66, width: 81, align: right"]1.993284672[/TD]

</tbody>
 
Upvote 0
Mike, I'll update the code for the first problem later today (my local time).

Precision within the target value is good, but isn't less precision better within values a and b? Suppose we know that:

a is in the range 7.9 to 8.1
b is in the range 3.9 to 4.1

and we want the target to be 2.0000000 (high precision is good).

If I know that a and b were integers, then obviously a is 8 and b is 4.
But if a and b could be three decimal places, say, then this opens up other possibilities such as 8.08 / 4.04 and 8.008 / 4.004.

The greater the precision of a and b, the more "solutions" you're going to get!
 
Upvote 0
StephenCrump,
I can't thank you enough for your time and help on this problem. I am retrying solver for the second problem. I am sorry if I have not explained what I am doing clearly. I'll try to explain better. I have the number 3.241580566. I am needing to find values in the range 1542.00 to 1758.00 (decimal places are important) when divided by values in the range 440.0000001 to 540.9999999 (decimal places are important) that equal the 3.241580566. The correct numbers would be 1638.48 & 505.4571271. If I round the values to 3.2416 it returns 1638 & 505.3. However, 1637/505=3.2416 (rounded). The results that are returned are used in another formula and depending on the accuracy of the results it effects the results of the formula it is used in and I get a wrong answer. I thought I could round and deal with the error but haven't been successful yet. The only way I have seen to overcome the error is to use the long decimal numbers. Hope this makes sense. For example, using 1637, 1638, & 1638.48 in the formula return the following results respectively: 1.991484185, 1.99270073, & 1.993284672. The last answer is correct but can only be obtained by using the 1638.48 & 505.4571271. Any other answers are wrong. No rounding allowed would be better. This is part of a multistep problem. Anyhow, I would like to try the code change you suggested instead of the input boxes. I greatly appreciate your help and really don't know how to thank you enough for your time and help. One other thing, is there a way to calculate how long solver will take to solve finding numbers in a sum problem?
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Repeat different values based on adjacent column numbered inputs
Replies
3
Views
269
Fluff
Fluff
K
  • Question Question
index/match two sheets each value in list but returns only last value match
2
Replies
19
Views
509
KDS14589
K
T
  • Question Question
Remove graph series references of deleted columns - avoid #REF! error
Replies
1
Views
139
TurpsUK
T
M
  • Question Question
Copy values to column based on date
Replies
2
Views
104
OaklandJim
O
D
  • Question Question
How to combine Two VBA into one
Replies
3
Views
171
dharv3y78
D

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top