How can excel recognize conversion (word to number) and multiplication factors?

I'm trying to make a table of the total amount of a liquid used throughout the day. Here is what I am trying to do: In cell D4, I want to be able to enter something similar to the following:

3cup+2bottle+1liter

and by doing so, Excel can automatically recognize that 1cup is 8oz, 1bottle is 17oz, and 1liter is 34 oz because of the reference chart provided on the side. Also, it would be able to notice the 3, 2, and 1 amounts so it would multiply accordingly so it would know to do this:

(3*8)+(2*17)+(1*34)

and then put the calculated amount in the cell. The correct answer should be 92oz. Is there a way for Excel to recognize the conversions (i.e. whenever it sees 'cup' it will multiply by 8) and multiplication factors (i.e. 3, 2, 1)?Is there a formula I can enter that I can just "drag" down to the upcoming days in column D?

I know I can just do something like this:

(3*G4)+(2*G5)+(1*G6)

but it would be a lot easier than to just type across. I attached an image to help clarify.

If you insist on typing cup, liter and bottle in D cells, then you should Use Define Names:

Please Login or Register  to view this content.

But, instead of typing: 4cup+bottle+3liter, you will have to write it as a regular XL formula:

E.g. in any cell in Col-D

=X*cup+Y*bottle+Z*liter, X, Y & Z being the amounts used.

If you put the units in separate cells and use standard abbreviations, you can use the CONVERT function to sum them in some common unit.