KEG inventory by weigth Formulas

[bootleg]

hi Guys I'm try to do a excel sheet with the keg 1/2 barrel and 1/4 barrel
the fluid oz. per keg
1/2 = 1984 fluid oz 1/4=992 fluid oz fluid oz 0.065 15.4 fluid oz = 1LB

1/2 keg empty is 30 LB 1/2 keg full is 161 LB

=(1kegfull*1kegempty-30)/(161-30)

I try to to do the variance inventory

starting weight end weight cost usage price by oz

thank you

[shg]

	A	B	C
1	empty wgt	29.7	lb
2	full wgt	161.5	lb
3	volume	1984	oz
4
5	weight	vol
6	29.7	0.0	B6: =(A6 -$B$1) / ($B$2 - $B$1) * $B$3
7	40	155.0
8	50	305.6
9	60	456.1
10	70	606.6
11	80	757.2
12	90	907.7
13	100	1058.2
14	110	1208.8
15	120	1359.3
16	130	1509.8
17	140	1660.4
18	150	1810.9
19	161.5	1984.0