Sum around a referenced cell

[zamunda1]

I have a spreadsheet with multiple columns of information, however three are of specific interest: price, quantity sold, and total revenue (p x q). There can be 500+ rows of data to this spreadsheet.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’ve then set up a v-lookup function to find the maximum total revenue. It’s set to identify the price, quantity and total revenue in a given row. Let’s call this row of information a “hot row.” Certainly as sales progress, this row of information could / should change.
<o> </o>
What I'm trying to do is analyze the information above and below this “hot row / reference cells.” Price is listed in descending order within the columns of data.
<o> </o>
Simple example: Let’s say there were 30 units sold for $5.25, 20 units for $5.10, 100 units for $5.00, 10 units for $4.00, 20 units for $3.50. Clearly, the 100 unit row of information is the winner. Total units are 180 with 50 units above and 30 units below.
<o> </o>
How would I set this automation up as the "hot row" will change with new, data input? It’s clearly a simple sum technique, but I can't figure out how to use that reference point to manipulate around the data.

 

[Gerald Higgins]

Hi, welcome to the board.

This is probably do-able.

What exactly do you want the outputs to be ?

 

[zamunda1]

I would want the output to separately sum the unit total above and below the hot row where most transactions occurred. I don't want to include the hot row total.

 

[Gerald Higgins]

Do you only have one "hot row" in the whole of your data, or do you have lots of them, say one for each product ?

 

[zamunda1]

there is only one "hot row" however it'll change with different sales activity over time.

Since excel adds columar data - could I somehow identify that specific "hot cell" and then sum below that point? The to get above #'s - subtract from the grand total??

I've used excel to determine the address of the cell. I just don't know how to then manipulate the data.

Thanks for the help!

 

[Gerald Higgins]

Using your sample data, and assuming it is laid out like this...

ID (or whatever) in A1:A5
Quantity in B1:B5
Price in C1:C5
Total income (Qty x price) in D1:D5

Total income for rows above the hot row

=SUMPRODUCT(B1:B5,--(C1:C5>(INDEX(C1:C5,MATCH(MAX(D1:D5),D1:D5,0)))))

Replace > with < for rows below the hot row.

 

[zamunda1]

this worked GREAT! thank you!!!

have another formula or two that I'm also stuck on. would I be able to email a copy of the spreadsheet to you to see it?

 

[zamunda1]

Here's the description of what I'm trying to do. First is tally up all of the units that sold. For analytical purposes, we look at different percentages to see what price points and elasticity we can implement. For this example, let’s say we want to know the upper and lower limits of where 70% of our units sold.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
What I do is find the central point (hot row) as my starting point. The “unit #” of that price point is included in this calculation. I then add “up and down” the unit column (one row at a time) until +/- 70% of the units sold is reached. To accomplish this, I type into an empty cell a simple sum formula and have to play with it.
<o> </o>
Once I play with it to try and find an ‘even’ distribution (approximately half above hot row with half below it) - I can easily see / determine the upper and lower value (price points). This is – in reality a distribution. I don’t understand enough about the statistical tools on excel to know if those could be a part of the solution.
<o> </o>
Essentially what I want to know is the upper and lower limits (units / price points) - around the hot row (dare I say 'mean').
<o> </o>
Any help is appreciated, thanks!

 

[Gerald Higgins]

Hi, thanks for coming back to say thanks !

Please don't e-mail me the spreadsheet, nothing personal but I won't look at it and you'll probably get better responses by keeping the discussion public.

With regard to your post #8, I know roughly what you mean, but not exactly.

Could you post maybe 10 rows of dummy data, and show exactly what you want to do if those 10 were your entire data set ?

 

[zamunda1]

Here's a sample of what I'm trying to do. Column A is units, B is price, C is revenue. In this small sample of my spreadsheet, the total units sold were 107 units = so 70% were about 75 units. The yellow background accounts for 73 units. Thus the top value that I'm searching for is 92.60 and lower value is 92.30.

Essentially, I need to add up, then down - - - from the hot row until I account for the total


<TABLE style="WIDTH: 438pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=584 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ebe9ed" class=xl73 height=18 width=64 x:num>5</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff9900; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ebe9ed" class=xl74 width=64 x:num>92.600</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl75 width=64 x:num x:fmla="=B1*A1">463.00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ebe9ed" class=xl76 width=64> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff9900; WIDTH: 246pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl77 width=328 colSpan=4>Need premium price point = 92.60</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>5</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num="92.575000000000003">92.575</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B2*A2">462.88</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>6</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num>92.550</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B3*A3">555.30</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>6</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num="92.525000000000006">92.525</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B4*A4">555.15</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>6</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num>92.500</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B5*A5">555.00</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>6</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num="92.474999999999994">92.475</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B6*A6">554.85</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: lime; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl70 height=17 x:num>7</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: lime; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl71 x:num>92.450</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: lime; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl72 x:num x:fmla="=B7*A7">647.15</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: lime; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl66> </TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: lime; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl66 colSpan=4>Hot Row / Median Price</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>6</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num="92.424999999999997">92.425</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B8*A8">554.55</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>6</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num>92.400</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B9*A9">554.40</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>5</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num="92.375">92.375</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B10*A10">461.88</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=17 x:num>5</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num>92.350</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B11*A11">461.75</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 13.5pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl67 height=18 x:num>5</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl68 x:num="92.325000000000003">92.325</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: #ebe9ed; BORDER-RIGHT: windowtext 1pt solid" class=xl69 x:num x:fmla="=B12*A12">461.63</TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed" class=xl65></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD><TD style="BORDER-BOTTOM: #ebe9ed; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #ebe9ed"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ebe9ed" class=xl73 height=18 x:num>5</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff9900; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ebe9ed" class=xl74 x:num>92.300</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl75 x:num x:fmla="=B13*A13">461.50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ebe9ed" class=xl76> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff9900; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl77 colSpan=4>Need Discount price point = 92.30</TD></TR></TBODY></TABLE>