|
Central IL | If I understand your post correctly, I believe this should work. This assumes, the elevator will not accept corn over 28% and you are not going to haul any at that level. The drying rates are set at moisture - 15%. In other words, not a sliding scale where drying from 25% to 23% is rated at .05, then .045 from 23% to 20%, then .04 from 20% down to 15% where drying from 25% to 15% would be 2 * .05, 3 * .045, and 5 * .04, but rather just 10 * .05. This also assumes they aren't splitting drying rates on half points or full points but the actual difference to the tenth.
Hope it helps.
=IF(B7>23,(A7*(B7-15)*0.05),IF(B7>20,(A7*(B7-15)*0.045),IF(B7>15,(A7*(B7-15)*0.04),0)))
EDIT: Don't forget to check if the elevator also uses a shrink factor. If they use a 1.4% shrink factor as my local does, you may be disappointed on copmaring your wet bushels scale tickets to the dry bushel settlement sheet.
Edited by IL_no_till 10/8/2008 12:10
| |
|
Excel formula IF statements help
