Grain moisture correction formula

[snarling bee]

Has anybody got a grain moisture correction formula?
I can find plenty of tables but I want to put a formula into a spread sheet. I have seen 3 tabulated correction sheets, but they don't always agree.
When we put grain into store dry the intake weights are very close to the outtake. If we have to dry anything I always seem to underestimate the moisture loss, even by doubling the %age. For eg if we dry from 17% to 14.5% I would deduct 5%, but it never seems enough.

 

[Agrobi]

I have been told if you take 1.2% in weight for every % moisture it isn’t far off. Ie 5tonnes at 20% moisture becomes 4.7tonnes when dried to 15... not sure if this applies to grains other than cereal.

 

[PSQ]

I have been told if you take 1.2% in weight for every % moisture it isn’t far off. Ie 5tonnes at 20% moisture becomes 4.7tonnes when dried to 15... not sure if this applies to grains other than cereal.

I do similar but reduce the weight by 1.5% per 1% moisture. Doesn't seem too far out when accounting for losses through the drier and cleaners, and any loss of weight due to 'in store' ventilation through winter.

 

[fudge]

Has anybody got a grain moisture correction formula?
I can find plenty of tables but I want to put a formula into a spread sheet. I have seen 3 tabulated correction sheets, but they don't always agree.
When we put grain into store dry the intake weights are very close to the outtake. If we have to dry anything I always seem to underestimate the moisture loss, even by doubling the %age. For eg if we dry from 17% to 14.5% I would deduct 5%, but it never seems enough.

Perhaps it’s the moisture readings which are slightly out? All measurements have some degree of inaccuracy.

 

[snarling bee]

The farm contractor costs booklet gives 4% for the first 1% then 1.25% thereafter up to 22% then 1.5%. This probably isn't very far out with an Opico drier, but we are on floor. I think it is wise to loose 1% every time it is moved anyway (or 1% just in storage)

 

[Cjm]

So what you are really trying to work out is dry matter tonnage in and then out. There is probably a much easier way to do it in Excel, but this is what I came up with

 

[Gong Farmer]

I've only got specific formulae to convert to 15% and 9%, and I'm jiggered if I can work out how to tweak the conversion for different moistures. Needs a better maths brain than mine. Anyway:

Moisture content corrections – to 15%

W(15) = W(X) x ((100 – X) / 100) x 1.1764705

Where W(15) = weight at 15% moisture content

W(X) = weight at X% moisture

X = actual moisture content

- To 9%

W(9) = W(X) x ((100 – X) / 100) x 1.098901

Where W(9) = weight at 9% moisture content

W(X) = weight at X% moisture

X = actual moisture content

 

[eagleye]

I think of it based on dry matter.
wet weight (dry matter %) which for a sample at 20% moisture would be 80% dry matter or 0.80 of the initial wet weight.
when dried to 14% moisture the dry matter weight should be the same but is now 86% of the final weight or 0.86 of the finished weight.
formula is then
wet weight x(0.80) /(0.86)= dry weight
substitute the figures based on starting dry matter% and final dry matter%.
should be correct except for any cleaning and dust loss (typically 1%)

looks the same as Cjm's post above really

 

[Spud]

I work on 1.5% weight loss for every 1% removed, and work it back to 14% rather than 14.5, because some does come off too dry - difficult keeping the dryer set perfect when it can be anywhere from 15.5-18 going into it in a given day. 15.5% would get a docking, so it would get tipped on the 'to dry' heap, but in reality, its not easily possible to take 1% out, so it finishes up less than the target.
Customers are happy to accept an average moisture, and anything under 15% not counted (cos it wouldn't get dried)

 

[An Gof]

Has anybody got a grain moisture correction formula?
I can find plenty of tables but I want to put a formula into a spread sheet. I have seen 3 tabulated correction sheets, but they don't always agree.
When we put grain into store dry the intake weights are very close to the outtake. If we have to dry anything I always seem to underestimate the moisture loss, even by doubling the %age. For eg if we dry from 17% to 14.5% I would deduct 5%, but it never seems enough.

I have done this on a spreadsheet in the past for a coop store. We took the theoretical calculated value and then had to add an arbitrary % figure over and above the calculated loss to ensure that the store was not losing out. In the case of cereals we added (charged) 1% handling loss over and above the calculated weight loss to 15%
In reality we all over dry to ensure a safety margin on delivery of the grain. I am sure it is quite common for people to have a 0.5% safety margin I.e. dry to 14.5% to meet 15% contract spec. This is particularly likely where the grain is stored for any length of time after drying before delivery.

 

[bankrupt]

had to add an arbitrary % figure over and above the calculated loss to ensure that the store was not losing out. In the case of cereals we added (charged) 1% .

Enough to pay off one's own new store at today's rediculously low IRs.

 

[bravheart]

I have been told if you take 1.2% in weight for every % moisture it isn’t far off. Ie 5tonnes at 20% moisture becomes 4.7tonnes when dried to 15... not sure if this applies to grains other than cereal.

Think that’s the calculation maltsters use to pay the dry weight of wet weight barley delivered iyswim.

 

[robbie]

At the moment I'm loading wheat out of the shed at 11.4% how much more wheat would I have if it all averaged 14.5%????

 

[bankrupt]

At the moment I'm loading wheat out of the shed at 11.4% how much more wheat would I have if it all averaged 14.5%????

Your delivered weight x (88.6-85.5)/85.5.

Just over a tonne in every 29.

 

[robbie]

Bugger on the last load dad took in today we lost out on 575kg or £77.62 [emoji26] does anyone know how to wet wheat successfully.

 

[snarling bee]

With water, carefully!!!!!!!!!!!!!!!!