Recipe Scaling Question

[Gorango]

Hello everyone.

I have what I think is a pretty complex problem. I will try my best to explain what I would like to do.

I already have a template that can scale recipes, however my issue is when scaling to a large number lets say 1024 portions, the results are not intuitive. In that example the 512 teaspoon scales to 170 tablespoons + 2 teaspoon, which is a smaller measurement but it is not the smallest measurement available. For that example I would like it to convert to cups. But yet another example would be to convert 64 quarts into gallons using the same formula in another cell.

I am using Match and Index functions but I cant seem to wrap my head around doing conversions that can accommodate large scaling.

If its easier to understand what I'm trying to do I am more than will to share my spreadsheet, I just dont know how.

Let me know if there is anything else you need from me.

 

[oldbrewer]

custard powder	2	tablespoons	560	28	lb
sugar	3	teaspoons	840				1	1 tablespoon =	4	teaspoons
milk	2	cups		560				1	cup =	5	tablespoons
PORTIONS	5							1	lb =	4	cups
								1	pint =	3	cups
scale up to	1400	portions									mytable
									tablespoons	1	1	tablespoon
scale multiplier	280									10	0.2	cup
										200	0.05	lb
										20000	0.05	lb
						this example is just for the first item (2 tablespoons)
						mytable is my lookup table
						as the scaled up quantity is 560
						it uses .05 to convert to lbs
						both 28 and the lb symbol are generated automatically

<colgroup><col><col span="8"><col><col span="5"></colgroup><tbody>
</tbody>

 

[pile-it Mark]

any progress on this? i have similar issues to resolve. but also to decrease from 1600 servings to 960 (or what ever number the cook requires)

 

[oldbrewer]

my post 11 demonstrates the principle - and scaling up or down is simple - do you have a specific question ?