I've been homebrewing for close to 25 years, and finally stepping up my game on data collection and building a custom spreadsheet for everything. From my malt database, I'm inputing extract as FGDB% and percent moisture from each malt COA, and based on that and recipe calculating total theoretical extract (kg), and actual extract and losses at each step: conversion/un-converted extract in kg for conversion efficiency; lautered pre-boil extract vs unlautered extract for lauter efficiency, etc.
I want to make sure I'm calculating max theoretical extract correctly. I've always assumed extract % FGDB excludes that moisture weight of the grain, and base my theoretical extract calcuation based on moisture corrected grain weight x FGDB%. For example:
10 kg 2-row, with 5% moisture and 81% FGDB from COA would produce a theoretical max extract of 10 kg - (10 kg x 5%) x 81% = 9.5 kg x 81% = 7.695 kg theoretical max extract.
Alternatively if extract is reported as "as-is", you don't correct for moisture, and multiply grain weight x "as is" extract %.
Just want to make sure I'm doing this right.
I want to make sure I'm calculating max theoretical extract correctly. I've always assumed extract % FGDB excludes that moisture weight of the grain, and base my theoretical extract calcuation based on moisture corrected grain weight x FGDB%. For example:
10 kg 2-row, with 5% moisture and 81% FGDB from COA would produce a theoretical max extract of 10 kg - (10 kg x 5%) x 81% = 9.5 kg x 81% = 7.695 kg theoretical max extract.
Alternatively if extract is reported as "as-is", you don't correct for moisture, and multiply grain weight x "as is" extract %.
Just want to make sure I'm doing this right.