Merge and condense formulas

[FROGGER24]

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.

 

[repairman615]

Hello,

Not exactly pretty, yet this may do.

I am using 2007:

=IF(D3="Barge",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",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"))))),"---"))

 

[Ruddles]

Don't forget you have maybe 16,300+ completely empty columns over to the right of your data, so don't be afraid to use one more of them if it makes life simpler.

 

[repairman615]

...Mahoosive...

 

[Ruddles]

Mahoosive and humungous.

 

[Atroxell]

^^Would that then be "gi-hugic"?

 

[Ruddles]

Almost as big as that, but not quite.

 

[FROGGER24]

Wow, everyone likes that formula . I have tried to come up with something better to fit my needs. In column Y I will need to look at columns D,E,F to see which tolerance band to apply for the move. IE:If you have a ship with one tank you would use table SVV, if you had a ship and multiple tanks then you would use table TVV--(I24:L)Once the table is determined then you will have to look in column AQ to determine the correct barrel range to use in the table and to determine which tolerance you need to apply to that row, and Column X will have to be => column BH.

Excel Workbook
	B	C	D	F	G	H	I	J	K	L	M
1	D	E	F	X	Y	AQ	BD	BE	BF	BG	BH
2	Barge Or Ship	# of Vessels	# Of Shore Tanks	Delta Barrels	OOT Flag	BB6	SVV	Low	High	Variance	Difference
3	Ship	1	1	336.5		92856.78	SVV	0	5999.99	3	100
4	Barge	1	3	(87.4)		9740.74	SVV	6000	10999.99	2	200
5	Barge	1	1	(25.4)		9828.22	SVV	11000	50999.99	1	350
6	Barge	1	1	(74.4)		11474.30	SVV	51000	201000	0.9	550
7	Barge	1	2	(87.8)		9976.24	SVV	201000	1000000	0.4
8	Barge	1	1	38.0		9890.34
9	Barge	1	1	(55.0)		9949.62	CVV	Low	High	Variance	Difference
10	Barge	1	1	(80.3)		11415.83	CVV	0	25999.99	1.5	250
11	Barge	2	3	(583.9)		75738.10	CVV	26000	50999.99	0.7	300
12	Barge	2	2	(54.5)		59564.79	CVV	51000	75999.99	0.7	400
13	Barge	2	2	(566.9)		60105.03	CVV	76000	101000	0.6	450
14	Barge	2	1	(982.4)		68252.97	CVV	101000	1000000	0.4
15	Barge	2	2	(722.6)		66664.65
16	Barge	2	1	(425.9)		35327.34	TVV	Low	High	Variance	Difference
17	Barge	1	1	(20.1)		3306.85	TVV	0	25999.99	1	250
18	Barge	1	1	9.7		6049.10	TVV	26000	50999.99	1	250
19	Ship	1	2	(476.0)		456874.72	TVV	51000	75999.99	0.6	300
20	Barge	1	3	27.9		14883.69	TVV	76000	101000	0.6	400
21	Barge	1	2	(97.1)		10901.50	TVV	101000	1000000	0.5	500
22	Ship	1	2	(74.8)		80046.71
23	Ship	1	4	345.7		103326.77
24	Ship	1	1	220,551.1		220551.13	Barge Or Ship	# of Vessels	# Of Tanks	Expected Results
25	Ship	1	1	675.7		220551.13	Ship	1	1	SVV
26	Barge	5	2	(80.0)		117966.15	Ship	1	>1	TVV
27	Ship	1	3	(1,173.1)		324624.33	Barge	1	1	SVV
28	Barge	2	1	122.0		34741.10	Barge	1	>1	SVV
29	Barge	1	3	(618.9)		235037.44	Barge	>1	1	CVV
30	Barge	1	1	(70.1)		6301.21	Barge	>1	>1	CVV
Sheet2

Excel 2007

 

[markmzz]

Trimmer69,

If I understand correctly what you want, then I think this can help you (the formula in Z3 is a array formula - use Ctrl+Shift+Enter and not only Enter):

Note: I use names for the tables - SVV, CVV and TVV)

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></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></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></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></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</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">336.5</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">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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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]

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