Discussion in 'Computer Support' started by Mandy, Oct 19, 2005.

1. ### MandyGuest

ABV=((76.08)(OG-FG)/(1.775-OG))(FG/.794)

How do I enter this formal into a Microsoft Word Spreadsheet?

Mandy, Oct 19, 2005

2. ### SgtMinorGuest

When is this assignment due?

SgtMinor, Oct 19, 2005

3. ### MandyGuest

It is a formula for calculating Alcohol by Volume (ABV), by taking the
original and final gravity readings (OG and FG). I want to be able to take
the OG and FG and plug them into a spreadsheet to get the alcohol content.

Mandy, Oct 19, 2005
4. ### YddapGuest

In

Yddap, Oct 19, 2005
5. ### SgtMinorGuest

This assumes you'll be using Excel - given your formula
ABV=((76.08)(OG-FG)/(1.775-OG))(FG/.794):

Write the value for OG in cell A1, for FG in B1, and then, in any other

If you want it a bit fancier, type the Terms "Original Gravity" in A1,
"Final Gravity" in B1, and "Alcohol by Volume" in C1. Then enter the
actual values in cells A2 and B2, and the formula in cell C2. You'll
need the cell references for A1 to A2, etc. in the above formula.

Now, when you change the values for OG and/or FG you read out the new
ABV immediately.

SgtMinor, Oct 19, 2005
6. ### SgtMinorGuest

Read: You'll need to change the cell references for A1 to A2, and B1 to
B2 in the above formula.

SgtMinor, Oct 19, 2005
7. ### MartikGuest

Martik, Oct 19, 2005
8. ### gordonGuest

Word is NOT a spreadsheet. You can do simple calculations in a Word
document, but for complex calculations you need Excel which IS a

gordon, Oct 19, 2005
9. ### The Old SourdoughGuest

gordon wrote in 24hoursupport.helpdesk:
Or Open Office, which is a heckuvalot cheaper than MS Office.

The Old Sourdough, Oct 19, 2005
10. ### gordonGuest

Absolutely! Guess what I use.........

gordon, Oct 19, 2005
11. ### The Old SourdoughGuest

gordon wrote in 24hoursupport.helpdesk:
OO rooolz!!11!!

(At least, it does everything *I* need it to do.)

The Old Sourdough, Oct 20, 2005