Gravity, Sugar and ABV Calculation tool

[hypnoticmonkey]

Hi all,

I've just created this, which I think I'll be using quite a bit:

https://docs.google.com/leaf?id=0B31DFi ... MDMy&hl=en

EDIT: Version 1.1 - https://docs.google.com/leaf?id=0B31DFi ... ODIz&hl=en

I can't guarantee 100% accuracy. The formulae behind it were calculated from a trend line on Open Office, and seems to give a reading of 0999 for 0g sugar, but other than that works out quite well, and is accurate enough for what most of us will be using it for, I'm sure.

Feel free to download and share and ask questions.

 

[hypnoticmonkey]

Now corrected and uploaded, should work only be able to enter values into cells which you need to now and not in cells that are designed to give you a result.

 

[hypnoticmonkey]

Have just uploaded Gravity Document 1.1, snazzed it up a bit, corrected the 0g sugar error and added a couple of graphs.

https://docs.google.com/leaf?id=0B31DFi ... ODIz&hl=en

Any feedback at all would be warmly appreciated.

 

[ciderbob]

i cant open the file ...??

 

[hypnoticmonkey]

Are you unable to download the file or unable to open it once downloaded?

Do you have Microsoft Office Excel, or Open Office?

 

[ciderbob]

it seems i dont have them .. will look into gettinmg them :hmm:

 

[hypnoticmonkey]

Open Office is free. I would recommend it, if you don't feel like shelling out a couple hundred quid or breaking the law with a pirate copy (both of which are to be thoroughly discouraged, one more than the other)

http://www.openoffice.org/