For conversions, download and install OpenOffice and have a go with the spreadsheet.

Type in a table with your ingredients as in:

	A	B	C	D	E
1	Item 	CCM	CCH	CCL	Choice
2	Soda	54.0	50.0	16.0	B
3	Vit C	16.0	15.0	10.0	Amount
4	Kbr	0.0	0.9	2.0	=30*10
5	Coffe	40.0	40.0	40.0

The numbers on row 2 and below in columns B, C and D are the gram weights per liter from http://caffenol.blogspot.com recipes

E4 will display “300” for 30ml per fl oz and 10 oz
http://en.wikipedia.org/wiki/Conversion_of_units – for help with conversion of metric units

Now in cell F1 and below type:
=$E$4 & “ml “& INDIRECT( $E$2 & ROW(A1)  )
=$E$4 / 1000 * INDIRECT( $E$2 & ROW(A2) )
=$E$4 / 1000 * INDIRECT( $E$2 & ROW(A3) )
=$E$4 / 1000 * INDIRECT( $E$2 & ROW(A4) )
=$E$4 / 1000 * INDIRECT( $E$2 & ROW(A5) )
=$E$4 / 1000 * INDIRECT( $E$2 & ROW(A6) )

Assuming you type correctly, these will display:
300ml CCM
16.2
4.8
0
12
4.5

I hope you realize that “INDIRECT( cell-reference ) ” takes the CALCULATED cell-reference and inserts the contents of the cell it points out into the formula.

$E$4 means cell E4, but also “do not change the column or row reference” ($ before each).

“/” means divide, * is multiplication, & just concatenates – i.e. attaches values or text beside each other, what is inside “-quotes remains there as fixed ‘value’ (qoutes not shown).

Now changing the Choice is simpy typing in e.g. “C” in that cell, for CCH or “D” for CCL.
Changing the Amount for 20 oz, menas typing in
=30*20
in the cell

The changes will be immediately reflected 600ml for Amount and in column F you will see the double values compared to the previous ones (as shown above).

Advertisements