Merge and condense formulas

FROGGER24 · Jul 10, 2011

In Column AA I would like to merge these two formulas. If D3 = "barge" use this formula
=IF(AND(AE3<=5000, ROUND(ABS(Y3)*100, 2)>=3, ABS(X3)>=100), "Y", IF(AND(AE3<=10000, ROUND(ABS(Y3)*100, 2)>=2, ABS(X3)>=200), "Y", IF(AND(AE3<=50000, ROUND(ABS(Y3)*100, 2)>=1, ABS(X3)>=350), "Y", IF(AND(AE3<=200000, ROUND(ABS(Y3)*100, 2)>=0.9, ABS(X3)>=550), "Y", IF(AND(AE3>200000, ROUND(ABS(Y3)*100, 2)>=0.4), "Y", "N")))))
If D3 = "Ship" use this formula:
=IF(AND(AE3<=25000, ROUND(ABS(Y3)*100, 2)>=1, ABS(X3)>=250), "Y", IF(AND(AE3<=50000, ROUND(ABS(Y3)*100, 2)>=1, ABS(X3)>=250), "Y", IF(AND(AE3<=75000, ROUND(ABS(Y3)*100, 2)>=0.6, ABS(X3)>=300), "Y", IF(AND(AE3<=100000, ROUND(ABS(Y3)*100, 2)>=0.6, ABS(X3)>=400), "Y", IF(AND(AE3>100000, ROUND(ABS(Y3)*100, 2)>=0.5), "Y", "N")))))
Not sure if formulas can be condensed.

markmzz · Jul 14, 2011

trimmer69 said:
Markmzz, Thanks for your help!! I have a question though, was there a formula for column Z(Table Name)

Trimmer69,

The formula of the column Z is to determine which is the table that should be used.

Markmzz

FROGGER24 · Jul 14, 2011

that formula works for a single ship or barge with one shoretank, I get N/A if there is two or more barges, ships or tanks

markmzz · Jul 14, 2011

trimmer69 said:
that formula works for a single ship or barge with one shoretank, I get N/A if there is two or more barges, ships or tanks

Trimmer69,

In your table you don't put that information. Look at this:

Column D/E Ship and # of Vessels = 2 and

In the table - Column BI/BJ Ship and # of Vessels = 1

Look at this sheet:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>W</TH><TH>X</TH><TH>Y</TH><TH>Z</TH><TH>AP</TH><TH>AQ</TH><TH>AR</TH><TH>BC</TH><TH>BD</TH><TH>BE</TH><TH>BF</TH><TH>BG</TH><TH>BH</TH><TH>BI</TH><TH>BJ</TH><TH>BK</TH><TH>BL</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">E</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">F</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">X</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">Y</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">AQ</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">BD</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">BE</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">BF</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">BG</TD><TD style="TEXT-ALIGN: right; COLOR: #333399; FONT-WEIGHT: bold">BH</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge Or Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399"># of Vessels</TD><TD style="TEXT-ALIGN: right; COLOR: #333399"># Of Shore Tanks</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Delta Barrels</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">OOT Flag</TD><TD style="TEXT-ALIGN: center">Table</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">BB6</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Low</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">High</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Variance</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Difference</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8; COLOR: #333399">336.5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">#N/D</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #d8d8d8">#N/D</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">92856.78</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">5999.99</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">100</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-87.4</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">9740.74</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">6000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">11000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">200</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-25.4</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">9828.22</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">11000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">51000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">350</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-74.4</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">11474.3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">51000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">201000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.9</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">550</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-87.8</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">9976.24</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">201000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1000000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.4</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">38</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">9890.34</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-55</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">9949.62</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Low</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">High</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Variance</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Difference</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-80.3</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">11415.83</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">26000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1.5</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">250</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-583.9</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">75738.1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">26000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">51000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.7</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">300</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-54.5</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">59564.79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">51000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">76000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.7</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">400</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-566.9</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">60105.03</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">76000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">101000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.6</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">450</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-982.4</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">68252.97</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">101000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1000000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.4</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-722.6</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">66664.65</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-425.9</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">35327.34</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Low</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">High</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Variance</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Difference</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-20.1</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3306.85</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">26000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">250</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">9.7</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">6049.1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">26000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">51000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">250</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-476</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">TVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">456874.7</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">51000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">76000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.6</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">300</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">27.9</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">14883.69</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">76000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">101000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.6</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">400</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-97.1</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">10901.5</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">101000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1000000</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">0.5</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">500</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-74.8</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">TVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">80046.71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">345.7</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">TVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">103326.8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">220,551.10</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">220551.1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge Or Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399"># of Vessels</TD><TD style="TEXT-ALIGN: right; COLOR: #333399"># Of Tanks</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Expected Results</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge Or Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399"># of Vessels</TD><TD style="TEXT-ALIGN: right; COLOR: #333399"># Of Tanks</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Expected Results</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">675.7</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">220551.1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">5</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-80</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">117966.2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">>1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">TVV</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Ship</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-1,173.10</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">TVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">324624.3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">122</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">CVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">34741.1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">>1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">SVV</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-618.9</TD><TD style="TEXT-ALIGN: center">Y</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">235037.4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">>1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">-70.1</TD><TD style="TEXT-ALIGN: center">N</TD><TD style="TEXT-ALIGN: center">SVV</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">6301.21</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">2</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; COLOR: #333399">Barge</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">>1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">>1</TD><TD style="TEXT-ALIGN: right; COLOR: #333399">CVV</TD></TR></TBODY></TABLE>

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Y3</TH><TD style="TEXT-ALIGN: left">=IF(ABS(X3)>=VLOOKUP(AQ3,INDIRECT(Z3),4),"Y","N")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Array Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Z3</TH><TD style="TEXT-ALIGN: left">{=INDEX($BG$25:$BG$30,MATCH(1,(D3=$BD$25:$BD$30)*(MATCH(E3,{0;2},1)=$BE$25:$BE$30)*(MATCH(F3,{0;2},1)=$BF$25:$BF$30),0))}</TD></TR></TBODY></TABLE>Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

</TD></TR></TBODY></TABLE>

Markmzz

FROGGER24 · Jul 15, 2011

Mark, there was a short between the chair and the keyboard....Your table code worked great once I saw how it worked. When I copied your formula in y3 I get the #REF! error message.

repairman615 · Jul 15, 2011

trimmer69 said:
...there was a short between the chair and the keyboard...

Hilarious.

Ruddles · Jul 15, 2011

PEBCAK.

markmzz · Jul 15, 2011

trimmer69 said:
Mark, there was a short between the chair and the keyboard....Your table code worked great once I saw how it worked. When I copied your formula in y3 I get the #REF! error message.

Trimmer69,

I didn't understand. The problem is resolved or not?

If not, then give me more information.

Markmzz

FROGGER24 · Jul 15, 2011

Mark, When I copy and paste this formula =IF(ABS(X3)>=VLOOKUP(AQ3,INDIRECT(Z3),4),"Y","N") into Y3 I get this error message #Ref!, when I click on the error flag in Excel "Invalid Celle Reference Error" is highlighted.

markmzz · Jul 15, 2011

trimmer69 said:
Mark, When I copy and paste this formula =IF(ABS(X3)>=VLOOKUP(AQ3,INDIRECT(Z3),4),"Y","N") into Y3 I get this error message #Ref!, when I click on the error flag in Excel "Invalid Celle Reference Error" is highlighted.

Trimmer69,

Could you send me your example workbook for some tests?

Markmzz

FROGGER24 · Jul 15, 2011

Excel Workbook

D

E

F

X

Y

Z

AQ

BD

BE

BF

BG

BH

2

Barge Or Ship

# of Vessels

# Of Shore Tanks

BBL Difference

OOT Flag

GOM Moving Tank

Closeout Qty in BB6

3

Ship

1

336.5

#REF!

SVV

92856.78

SVV

Low

High

Variance

Difference

4

Barge

1

3

(87.4)

#REF!

SVV

9740.74

SVV

0

5999.99

3

100

5

Barge

1

(25.4)

#REF!

SVV

9828.22

SVV

6000

10999.99

2

200

6

Barge

1

(74.4)

#REF!

SVV

11474.30

SVV

11000

50999.99

1

350

7

Barge

1

2

(87.8)

#REF!

SVV

9976.24

SVV

51000

201000

0.9

550

8

Barge

1

38.0

#REF!

SVV

9890.34

SVV

201000

1000000

0.4

9

Barge

1

(55.0)

SVV

9949.62

10

Barge

1

(80.3)

SVV

11415.83

CVV

Low

High

Variance

Difference

11

Barge

2

3

(583.9)

CVV

75738.10

CVV

0

25999.99

1.5

250

12

Barge

2

(54.5)

CVV

59564.79

CVV

26000

50999.99

0.7

300

13

Barge

2

(566.9)

CVV

60105.03

CVV

51000

75999.99

0.7

400

14

Barge

2

1

(982.4)

CVV

68252.97

CVV

76000

101000

0.6

450

15

Barge

2

(722.6)

CVV

66664.65

CVV

101000

1000000

0.4

16

Barge

2

1

(425.9)

CVV

35327.34

17

Barge

1

(20.1)

SVV

3306.85

TVV

Low

High

Variance

Difference

18

Barge

1

9.7

SVV

6049.10

TVV

0

25999.99

1

250

19

Ship

1

2

(476.0)

TVV

456874.72

TVV

26000

50999.99

1

250

20

Barge

1

3

27.9

SVV

14883.69

TVV

51000

75999.99

0.6

300

21

Barge

1

2

(97.1)

SVV

10901.50

TVV

76000

101000

0.6

400

22

Ship

1

2

(74.8)

TVV

80046.71

TVV

101000

1000000

0.5

500

23

Ship

1

4

345.7

TVV

103326.77

24

Ship

1

220,551.1

SVV

220551.13

Barge Or Ship

# of Vessels

# Of Tanks

Expected Results

25

Ship

1

675.7

SVV

220551.13

Ship

1

SVV

26

Barge

5

2

(80.0)

CVV

117966.15

Ship

1

2

TVV

27

Ship

1

3

(1,173.1)

TVV

324624.33

Barge

2

CVV

28

Barge

2

1

122.0

CVV

34741.10

Barge

1

2

SVV

29

Barge

1

3

(618.9)

SVV

235037.44

Barge

2

1

CVV

30

Barge

1

(70.1)

SVV

6301.21

Barge

1

SVV

Marine Moves (2)

Excel 2007

Cell Formulas
Range	Formula
E3	=COUNTA(AU3,AW3,AY3,BA3,BC3)
E4	=COUNTA(AU4,AW4,AY4,BA4,BC4)
F4	=COUNT(AG4:AN4)
X3	=IF(R3="Load",(T3+U3),(W3+V3))
Y3	=IF(ABS(X3)>=VLOOKUP(AQ3,INDIRECT(Z3),4),"Y","N")

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Merge and condense formulas

FROGGER24

Well-known Member

markmzz

MrExcel MVP

Excel Facts

FROGGER24

Well-known Member

markmzz

MrExcel MVP

FROGGER24

Well-known Member

repairman615

Well-known Member

Ruddles

Well-known Member

markmzz

MrExcel MVP

FROGGER24

Well-known Member

markmzz

MrExcel MVP

FROGGER24

Well-known Member

Similar threads

Forum statistics

Share this page

Merge and condense formulas

Well-known Member

MrExcel MVP

Excel Facts

Well-known Member

MrExcel MVP

Well-known Member

Well-known Member

Well-known Member

MrExcel MVP

Well-known Member

MrExcel MVP

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock