Home 
Search 
Today's Posts 
#11




Frustrated Cook
On Mon, 21 Nov 2005 10:28:04 0500, "Mike G" wrote:
With all the corrections, I am staying out of the kitchen!! Mike Well I'm no cook  just a wannabee chemist :)) ron 
#12




Frustrated Cook
Ron,
I can not seem to replicate your spreadsheet  any chance of you sending it to my email address by taking the "NoSpam" out of my address? By the way, do you like pizza's? Thank you Guru Swami, Wazza McG "Ron Rosenfeld" wrote in message ... The same basic formulas that I posted can be used. But since you are changing the number of grams per cup depending on the substance, you'll need to change those equivalents in a table. The rewritten formulas (eliminating the 1/3 cups) A2: Weight in grams B2 Cups: =ROUNDDOWN(A2/GmPerCup*4,0)/4 C2 Tbsp: =INT((A2(B2*GmPerCup))/GmPerTbsp) D2 Tsp: =ROUND((A2B2*GmPerCupC2*GmPerTbsp)/GmPerTsp*4,0)/4 GmPerCup: 160 or whatever GmPerTbsp: =GmPerCup/12.5 GmPerTsp: =GmPerCup/50 Using these formulas, and taking 270 gm @ 160 gm/cup, I get 1.5C 2T 1.5t That is rounding 't' to the nearest 1/4 tsp (since I have a 1/4 tsp measure). It actually calculates to 1.375t You could also use a lookup table to insert the GmPerCup. Have a column with the substance and a table with the conversions: Table H1:K4 And the values for GmPerTbsp and GmPerTsp were generated by the same formulas above. Substance HiGFlour StdFlour Sugar GmPerCup 160 120 260 GmPerTbsp 12.8 9.6 20.8 GmPerTsp 3.2 2.4 5.2 Then set up the following: A1: Substance B1: Cups C1: Tbsp D1: Tsp A2: e.g. HiGFlour B2: e.g. 270 C2: =ROUNDDOWN(B2/HLOOKUP(A2,$H$1:$K$4,2,FALSE)*4,0)/4 D2: =INT((B2(C2*HLOOKUP(A2,$H$1:$K$4,2,FALSE)))/HLOOKUP(A2,$H$1:$K$4,3,FALSE)) E2: =ROUND((B2C2*HLOOKUP(A2,$H$1:$K$4,2,FALSE) D2*HLOOKUP(A2,$H$1:$K$4,3,FALSE))/HLOOKUP( A2,$H$1:$K$4,4,FALSE)*4,0)/4 Best, ron On Mon, 21 Nov 2005 18:33:59 +1000, "Wazza McG" wrote: Hi All, Oh, I just researched the delemma and I now understand the argument regarding the amount of teaspoons in a tablespoon due to the difference in conversions between US, British, Canada and Australia measurements. This site has a Standard Liquid Measurement  http://www.ozevillage.com.au/gs/tips...pic=conversion . a.. 5ml = 1/6fl oz = 1 teaspoon (50 teaspoons in 1 cup) a.. 20ml = 2/3fl oz = 1 tablespoon (12.5 Tablespoons in 1 cup) a.. 30ml = 1 fl oz = 1 tablespoon plus 2 teaspoons a.. 60ml = 2fl oz = 1/4 cup a.. 125ml = 4fl oz = 1/2 cup a.. 185ml = 6fl oz = 3/4 cup a.. 250ml = 8fl oz = 1 cup a.. 500ml = 16fl oz = 2 cups a.. 1 litre = 35fl oz = 4 cups As you can see, I have made some corrections to my initial query. I know the math in some of the conversions is not brilliant to say the least, however, I am happy enough to use the above table. I agree with Ron Rosenfeld  give the 1/3 and 2/3 of a Cup the flick. I do own a metric scale, but, it is a real pain having to measure with it all the time. This is the reason why, High Gluten Flour is 160g for 1 cup and standard Flour is 120g for 1 cup. Sugar is 250g for 1 cup  the same as water. I was hoping to measure 1 cup of an ingedient and then use that to work out the imperial volume of random measurements eg ; 270g of sugar = 1C, 1T,0t ; 270g of High Gluten Flour is 1 C, 2T,1t. Where 1C = 1 Cup, 1T = 1 Tablespoon and 1t = 1 teaspoon. I know this is doosy of an equation, however, I am hoping there is an excel guru out there that can shine some light on this. Regards, Wazza McG "Ron Rosenfeld" wrote in message . .. On Mon, 21 Nov 2005 06:41:18 +1000, "Wazza McG" wrote: Hi, I have been having trouble trying to work out a formula for the following. One cup of flour weighs 160g. If I had 240g of flour I would have 1 1/2 Cups. Now the hard bit, there are 16 Tablespoons and 48 teaspoons in a cup of flour. If I had 270g of flour I want the formula to have an end result of  1 1/2 C, 2T and 3t  rounded off as close as possible. In the cup measures, I would only want to use 1/4 C, 1/3 C, 1/2 C, 2/3 C, 3/4 C and 1C and so on. I know 5t should read 1T and 1t, however, getting a formula to work is beyond me at this stage. If anyone can help, It would be greatly appreciated. Regards, Wazza McG If you could eliminate those pesky 1/3 and 2/3 cup measures, it would be much simpler (rounding Tsp to the nearest 1/4 tsp) With the weight in A2: Cups B2: =ROUNDDOWN(A2/160*4,0)/4 Tbsp C2: =INT((A2(B2*160))/10) Tsp D2: =ROUND((A2B2*160C2*10)/3*4,0)/4 If you insist on using those 1/3 and 2/3 cup measures, then the formula for Cups becomes more complicated, as I believe you would want the most accurate measu Cups B2: =MAX(ROUNDDOWN(A2/160*4,0)/4,ROUNDDOWN(A2/160*3,0)/ IF(ABS(A2(ROUNDDOWN(A2/160*4,0)/4*160+INT((A2( ROUNDDOWN(A2/160*4,0)/4*160))/10)*10+ROUND((A2 ROUNDDOWN(A2/160*4,0)/4*160INT((A2(ROUNDDOWN( A2/160*4,0)/4*160))/10)*10)/3*4,0)/4*3))<ABS(A2(ROUNDDOWN( A2/160*3,0)/3*160+INT((A2(ROUNDDOWN(A2/160*3,0)/3*160)) /10)*10+ROUND((A2ROUNDDOWN(A2/160*3,0)/3*160INT((A2 (ROUNDDOWN(A2/160*3,0)/3*160))/10)*10)/3*4,0)/4*3)),30,3)) ron ron 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
FRUSTRATED!!! COMBO BOX AND PROGRAMMING IT  Excel Discussion (Misc queries) 