Calculation based on variable labels and variable ranges

brakiachi

New Member
Joined
Jan 7, 2016
Messages
17
I'm having a hard time coming up with an elegant solution for this. I have a table that explains legal tolerances for nutrition based on certain analytes and their values

Table look like this, but has many more values in it

AnalyteDeclared Content Tolerance BelowTolerance Above
Fat<1624
Fat16-2412.5%25%
Fat>2436
Moisture<2no limit0.4
Moisture2-5no limit20%
Moisture5-12.5no limit1
Moisture>12.5no limit8%
Ash<821
Ash8-3225%12.5%
Ash>3284

<tbody>
</tbody>

Just to give an example:
If the declared content of fat is 8, the tolerance below is 8-2=6, and above is 8+4=12
If the declared content of fat is 20, the tolerance below is 20-20*12.5%=17.5, and the tolerance above is 20+20*25%=25

So on the input side we will have a table that has the analytes and the declared values, and the output side will have the tolerances.
The input side can also have the analytes arranged in any order, not necessarily the same order.

The only solution I have is creating a table to arrange the analytes in a specific order and then having to to put in if statements based on specific analytes and ranges
eg. for fat putting in: =if(A2<16,A2-B2,if(A2>24,A2-3,A2-A2*0.125))

Is there an elegant solution where I won't have to change each formula should the tolerances change? That is, I can just update the table, and not have to update each formula when the table changes?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,395
Office Version
  1. 365
Platform
  1. Windows
The problem here is that there are two lookup values and they are used in three lookups. I thought it best to use IF statements and mutiply arrays; this way, the data can be sorted in any manner and the formulas will still work. The solution I have here is hardly elegant and it reqiuires you to alter the table of data - for the upper bounds, just leave them blank. I assume that "no limit" on the lower bound means zero.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="background-color: #FFF2CC;;">Analyte</td><td style="background-color: #FFF2CC;;">Declared Content Low</td><td style="background-color: #FFF2CC;;">Declared Content High</td><td style="background-color: #FFF2CC;;">Tolerance Below</td><td style="background-color: #FFF2CC;;">Type_Below</td><td style="background-color: #FFF2CC;;">Tolerance Above</td><td style="background-color: #FFF2CC;;">Type_Above</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Fat</td><td style="text-align: right;;">0.0</td><td style="text-align: right;;">16.0</td><td style="text-align: right;;">2.00</td><td style=";">value</td><td style="text-align: right;;">4.00</td><td style=";">value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Fat</td><td style="text-align: right;;">16.0</td><td style="text-align: right;;">24.0</td><td style="text-align: right;;">12.50%</td><td style=";">rate</td><td style="text-align: right;;">25.00%</td><td style=";">rate</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Fat</td><td style="text-align: right;;">24.0</td><td style="text-align: right;;"></td><td style="text-align: right;;">3.00</td><td style=";">value</td><td style="text-align: right;;">6.00</td><td style=";">value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Moisture</td><td style="text-align: right;;">0.0</td><td style="text-align: right;;">2.0</td><td style="text-align: right;;">0</td><td style=";">value</td><td style="text-align: right;;">0.40</td><td style=";">value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Moisture</td><td style="text-align: right;;">2.0</td><td style="text-align: right;;">5.0</td><td style="text-align: right;;">0</td><td style=";">value</td><td style="text-align: right;;">20.00%</td><td style=";">rate</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Moisture</td><td style="text-align: right;;">5.0</td><td style="text-align: right;;">12.5</td><td style="text-align: right;;">0</td><td style=";">value</td><td style="text-align: right;;">1.00</td><td style=";">value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Moisture</td><td style="text-align: right;;">12.5</td><td style="text-align: right;;"></td><td style="text-align: right;;">0</td><td style=";">value</td><td style="text-align: right;;">8%</td><td style=";">rate</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Ash</td><td style="text-align: right;;">0.0</td><td style="text-align: right;;">8.0</td><td style="text-align: right;;">2.00</td><td style=";">value</td><td style="text-align: right;;">1.00</td><td style=";">value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Ash</td><td style="text-align: right;;">8.0</td><td style="text-align: right;;">32.0</td><td style="text-align: right;;">25.00%</td><td style=";">rate</td><td style="text-align: right;;">12.50%</td><td style=";">rate</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">Ash</td><td style="text-align: right;;">32.0</td><td style="text-align: right;;"></td><td style="text-align: right;;">8.00</td><td style=";">value</td><td style="text-align: right;;">4.00</td><td style=";">value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</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="color: rgb(22,17,32);text-align: center;">14</td><td style="background-color: #FCE4D6;;">Analyte</td><td style="background-color: #FCE4D6;;">Declared Content</td><td style="background-color: #FCE4D6;;">Tolerance Below</td><td style="background-color: #FCE4D6;;">Tolerance Above</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="color: rgb(22,17,32);text-align: center;">15</td><td style="background-color: #F4B084;;">Fat</td><td style="text-align: right;background-color: #F4B084;;">8.000</td><td style="text-align: right;background-color: #C6E0B4;;">6.000</td><td style="text-align: right;background-color: #C6E0B4;;">12.000</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></tbody></table><p style="width:5.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet48</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C15</th><td style="text-align:left">=IF(<font color="Blue">MIN(<font color="Red">IF(<font color="Green">IF(<font color="Purple">IF(<font color="Teal">(<font color="#FF00FF">A15=$A$3:$A$12</font>)*(<font color="#FF00FF">B15>=$B$3:$B$12</font>)*(<font color="#FF00FF">B15<IF(<font color="Navy">ISBLANK(<font color="Blue">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$E$3:$E$12</font>)="rate",1,0</font>),(<font color="Purple">(<font color="Teal">1-IF(<font color="#FF00FF">(<font color="Navy">A15=$A$3:$A$12</font>)*(<font color="Navy">B15>=$B$3:$B$12</font>)*(<font color="Navy">B15<IF(<font color="Blue">ISBLANK(<font color="Red">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$D$3:$D$12</font>)</font>)*B15</font>),B15-IF(<font color="Purple">(<font color="Teal">A15=$A$3:$A$12</font>)*(<font color="Teal">B15>=$B$3:$B$12</font>)*(<font color="Teal">B15<IF(<font color="#FF00FF">ISBLANK(<font color="Navy">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$D$3:$D$12</font>)</font>)</font>)=B15,0,MIN(<font color="Red">IF(<font color="Green">IF(<font color="Purple">IF(<font color="Teal">(<font color="#FF00FF">A15=$A$3:$A$12</font>)*(<font color="#FF00FF">B15>=$B$3:$B$12</font>)*(<font color="#FF00FF">B15<IF(<font color="Navy">ISBLANK(<font color="Blue">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$E$3:$E$12</font>)="rate",1,0</font>),(<font color="Purple">(<font color="Teal">1-IF(<font color="#FF00FF">(<font color="Navy">A15=$A$3:$A$12</font>)*(<font color="Navy">B15>=$B$3:$B$12</font>)*(<font color="Navy">B15<IF(<font color="Blue">ISBLANK(<font color="Red">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$D$3:$D$12</font>)</font>)*B15</font>),B15-IF(<font color="Purple">(<font color="Teal">A15=$A$3:$A$12</font>)*(<font color="Teal">B15>=$B$3:$B$12</font>)*(<font color="Teal">B15<IF(<font color="#FF00FF">ISBLANK(<font color="Navy">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$D$3:$D$12</font>)</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D15</th><td style="text-align:left">=MAX(<font color="Blue">IF(<font color="Red">IF(<font color="Green">IF(<font color="Purple">(<font color="Teal">A15=$A$3:$A$12</font>)*(<font color="Teal">B15>=$B$3:$B$12</font>)*(<font color="Teal">B15<IF(<font color="#FF00FF">ISBLANK(<font color="Navy">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$G$3:$G$12</font>)="rate",1,0</font>),(<font color="Green">(<font color="Purple">1+IF(<font color="Teal">(<font color="#FF00FF">A15=$A$3:$A$12</font>)*(<font color="#FF00FF">B15>=$B$3:$B$12</font>)*(<font color="#FF00FF">B15<IF(<font color="Navy">ISBLANK(<font color="Blue">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$F$3:$F$12</font>)</font>)*B15</font>),B15+IF(<font color="Green">(<font color="Purple">A15=$A$3:$A$12</font>)*(<font color="Purple">B15>=$B$3:$B$12</font>)*(<font color="Purple">B15<IF(<font color="Teal">ISBLANK(<font color="#FF00FF">$C$3:$C$12</font>),9.99999999999999E+307,$C$3:$C$12</font>)</font>),$F$3:$F$12</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br />[/FONT]

 
Last edited:

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
4,191
Office Version
  1. 365
Platform
  1. Windows
C14: =B14-SUMPRODUCT(--(ROW(A$2:A$11)=MATCH(B14,IF(A14=A$2:A$11,B$2:B$11),1)+ROW(A$2)-1),C$2:C$11+D$2:D$11*B14)
D14: =B14+SUMPRODUCT(--(ROW(A$2:A$11)=MATCH(B14,IF(A14=A$2:A$11,B$2:B$11),1)+ROW(A$2)-1),E$2:E$11+F$2:F$11*B14)
(array-entered)

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="font-weight: bold;color: #333333;;">Analyte</td><td style="font-weight: bold;text-align: center;color: #333333;;">Declared</td><td style="font-weight: bold;text-align: center;;">Tolerance -</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;">Tolerance +</td><td style="font-weight: bold;text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="color: #333333;;">Fat</td><td style="text-align: center;;">0</td><td style="text-align: center;;">2</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">4</td><td style="text-align: center;color: #333333;;">0%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="color: #333333;;">Fat</td><td style="text-align: center;;">16</td><td style="text-align: center;;">0</td><td style="text-align: center;;">12.50%</td><td style="text-align: center;;">0</td><td style="text-align: center;;">25.00%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="color: #333333;;">Fat</td><td style="text-align: center;;">24</td><td style="text-align: center;;">3</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">6</td><td style="text-align: center;color: #333333;;">0%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Moisture</td><td style="text-align: center;;">0</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">0.4</td><td style="text-align: center;color: #333333;;">0%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Moisture</td><td style="text-align: center;;">2</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">0</td><td style="text-align: center;;">20%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Moisture</td><td style="text-align: center;;">5</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">1</td><td style="text-align: center;color: #333333;;">0%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Moisture</td><td style="text-align: center;;">12.5</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">0</td><td style="text-align: center;;">8%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Ash</td><td style="text-align: center;;">0</td><td style="text-align: center;;">2</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">1</td><td style="text-align: center;color: #333333;;">0%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Ash</td><td style="text-align: center;;">8</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">25%</td><td style="text-align: center;;">0</td><td style="text-align: center;;">12.5%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Ash</td><td style="text-align: center;;">32</td><td style="text-align: center;;">8</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">4</td><td style="text-align: center;color: #333333;;">0%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">Declared</td><td style="font-weight: bold;text-align: center;;">Tolerance -</td><td style="font-weight: bold;text-align: center;;">Tolerance +</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style=";">Fat</td><td style="text-align: center;;">8</td><td style="text-align: center;;">6</td><td style="text-align: center;;">12</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style=";">Ash</td><td style="text-align: center;;">20</td><td style="text-align: center;;">5</td><td style="text-align: center;;">22.5</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)"></p><br /><br />
 

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
4,191
Office Version
  1. 365
Platform
  1. Windows
... but maybe your table can look like this (one change highlighted).

In which case, more robustly:

C14: =B14-SUMPRODUCT(--(ROW(A$2:A$11)=MATCH(B14,IF(A14=A$2:A$11,B$2:B$11),1)+ROW(A$2)-1),C$2:C$11+D$2:D$11*(B14-B$2:B$11))
D14: =B14+SUMPRODUCT(--(ROW(A$2:A$11)=MATCH(B14,IF(A14=A$2:A$11,B$2:B$11),1)+ROW(A$2)-1),E$2:E$11+F$2:F$11*(B14-B$2:B$11))

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="font-weight: bold;color: #333333;;">Analyte</td><td style="font-weight: bold;text-align: center;color: #333333;;">Declared</td><td style="font-weight: bold;text-align: center;;">Tolerance -</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;">Tolerance +</td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Analyte</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Declared</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Tolerance -</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Tolerance +</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="color: #333333;;">Fat</td><td style="text-align: center;;">0</td><td style="text-align: center;;">2</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">4</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Fat</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;"><16</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="color: #333333;;">Fat</td><td style="text-align: center;;">16</td><td style="text-align: center;;">2</td><td style="text-align: center;;">12.50%</td><td style="text-align: center;;">4</td><td style="text-align: center;;">25%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Fat</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">16-24</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">12.50%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">25%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="color: #333333;;">Fat</td><td style="text-align: center;;">24</td><td style="text-align: center;;">3</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">6</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Fat</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">>24</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">6</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Moisture</td><td style="text-align: center;;">0</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">0.4</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Moisture</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;"><2</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">no limit</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">0.4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Moisture</td><td style="text-align: center;;">2</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">0.4</td><td style="text-align: center;;">20%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Moisture</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">2-5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">no limit</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">20%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Moisture</td><td style="text-align: center;;">5</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">1</td><td style="text-align: center;color: #333333;;">10%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Moisture</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">5-12.5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">no limit</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FFFF00;;">10%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Moisture</td><td style="text-align: center;;">12.5</td><td style="text-align: center;;">0</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">1.75</td><td style="text-align: center;;">8%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Moisture</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">>12.5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">no limit</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">8%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Ash</td><td style="text-align: center;;">0</td><td style="text-align: center;;">2</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">1</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Ash</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;"><8</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">1</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Ash</td><td style="text-align: center;;">8</td><td style="text-align: center;;">2</td><td style="text-align: center;color: #333333;;">25%</td><td style="text-align: center;;">1</td><td style="text-align: center;;">12.5%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Ash</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">8-32</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">25%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">12.50%</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Ash</td><td style="text-align: center;;">32</td><td style="text-align: center;;">8</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: center;;">4</td><td style="text-align: center;color: #333333;;">0%</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">Ash</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">>32</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">8</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #333333;background-color: #FAFAFA;;">4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">Declared</td><td style="font-weight: bold;text-align: center;;">Tolerance -</td><td style="font-weight: bold;text-align: center;;">Tolerance +</td><td style="text-align: center;;"></td><td style="text-align: center;;"></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="color: rgb(22,17,32);text-align: center;">14</td><td style=";">Moisture</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1.4</td><td style="text-align: right;;"></td><td style="text-align: center;;"></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="color: rgb(22,17,32);text-align: center;">15</td><td style=";">Moisture</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4.8</td><td style="text-align: right;;"></td><td style="text-align: center;;"></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="color: rgb(22,17,32);text-align: center;">16</td><td style=";">Moisture</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">7.1</td><td style="text-align: center;;"></td><td style="text-align: center;;"></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="color: rgb(22,17,32);text-align: center;">17</td><td style=";">Moisture</td><td style="text-align: center;;">10</td><td style="text-align: center;;">10</td><td style="text-align: center;;">11.5</td><td style="text-align: center;;"></td><td style="text-align: center;;"></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="color: rgb(22,17,32);text-align: center;">18</td><td style=";">Moisture</td><td style="text-align: center;;">12.5</td><td style="text-align: center;;">12.5</td><td style="text-align: center;;">14.25</td><td style="text-align: center;;"></td><td style="text-align: center;;"></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="color: rgb(22,17,32);text-align: center;">19</td><td style=";">Moisture</td><td style="text-align: center;;">20</td><td style="text-align: center;;">20</td><td style="text-align: center;;">22.35</td><td style="text-align: center;;"></td><td style="text-align: center;;"></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></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)"></p><br /><br />
 

Forum statistics

Threads
1,136,300
Messages
5,674,961
Members
419,536
Latest member
Mohammed Jaffer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top