Flo1966 Posted 25 Jan 2013 , 9:49pm
post #1 of

How do you figure out the right conversions for Alice's Matrix?

8 replies
jason_kraft Posted 25 Jan 2013 , 10:52pm
post #2 of

AAre you talking about the pricing matrix linked below? If so what type of conversions do you need help with?

https://docs.google.com/spreadsheet/ccc?key=0AvflfTGZ15dhcG1CRzk0dUI1Vzl6YzRYM2UxWmw4ZXc&hl=en#gid=0

Flo1966 Posted 27 Jan 2013 , 5:13pm
post #3 of

Yes! Thank you..The column that says unit conversions.. How does this work? I put in my recipe .. and the unit price does not come out right.. how do I fix that?

jason_kraft Posted 27 Jan 2013 , 6:01pm
post #4 of

AThe unit price column's calculation is (price * unit amount) / (amount * unit conversion). So if the unit amount you want to use for the unit price is different from the units on the product you purchased, you can use the conversion column to take this into account. For example, the Ribbons line shows an amount in yards (since ribbon is sold by the yard) but the unit amount is inches, so the conversion factor would be 36 (1 yard = 36 inches).

Flo1966 Posted 28 Jan 2013 , 12:43am
post #5 of

Ok so, if I bought 15 dozen eggs at $16.94.. the recipe calls for 4 eggs ..The Item would be Eggs.. The Amount would be $16.94.. the unit amount would be 4 .. the unit conversion would be ??? the price would be $16.94.. and it would calculate to me the price of 4 eggs..?? I'm sorry, I'm just confused..Please explain this way, Thank you so much for helping me!

trebakes Posted 28 Jan 2013 , 12:55am
post #6 of

If you bought ONE dozen eggs for a dollar and the recipe uses 4 eggs, you would be using 12/4=3 or 1/3 of the dozen and the unit price would be 1/3 of the dollar that you paid for the dozen eggs or 33 cents. HTH

2SweetCakeryTX Posted 28 Jan 2013 , 1:15am
post #7 of

This is awesome!  I've been looking for something like this!  Thank you!

Flo1966 Posted 28 Jan 2013 , 2:01am
post #8 of

Is there anyway I can call you and you can walk me through this?

Flo1966 Posted 28 Jan 2013 , 2:36am
post #9 of

Wait!! I think I've figured it out!!!  THank you!!

Quote by @%username% on %date%

%body%