matrix0966 Posted April 6, 2015 Share Posted April 6, 2015 I am a student at UC Davis and my professor and I made an excel sheet that uses the TTB table 1 in order to change the apparent proof to True proof at 60F. I was wondering if anyone could give me suggestions regarding if the calculator is helpful and if it always works. I cannot upload excel files though. Link to comment Share on other sites More sharing options...
Griffin Claw Posted April 6, 2015 Share Posted April 6, 2015 A little info on your process would be helpful. The relationship between true proof and temperature is not easily modeled. How are you interpolating points in between given values? Are you using regressions? A formula you created or one taken from elsewhere? There are various dilution calculators out there, none officially sanctioned by the TTB as far as I know, but providing results accurate enough to satifsy gov't requirements. These all use proprietary formulas to calculate true proof. Link to comment Share on other sites More sharing options...
matrix0966 Posted April 9, 2015 Author Share Posted April 9, 2015 https://chms.ucdavis.edu/research/miller/Resources/TrueProofCalculator.xlsx This is a link to the excel spreadsheet that I made. I used ocr software to put the TTB table 1 in the second sheet. This should be officially sanctioned by the TTB. I simply call the values closest to the input values from the table and then interpolate them. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now