I thought of a much better and less cluttered-looking way to do what I was trying to do with the first workbook. In the new and improved workbook (attached), just enter your ingredient names, and base-recipe weights for each, in columns A and B. Then, just enter the percentage change you want to that base recipe in the yellow cell, B12 (e.g. 200 if you want to double it, 50 if you want to halve it), and your new weights for each ingredient, as well as total ingredient weight, will automatically calculate in column C. Additionally, I've added two columns that will automatically calculate baker's % for each ingredient, and % of total weight for each ingredient.
-
Welcome to the eG Forums, a service of the eGullet Society for Culinary Arts & Letters. The Society is a 501(c)3 not-for-profit organization dedicated to the advancement of the culinary arts. These advertising-free forums are provided free of charge through donations from Society members. Anyone may read the forums, but to post you must create a free account.
Edit History
I thought of a much better and less cluttered-looking way to do what I was trying to do with the first workbook. In the new and improved workbook (attached), just enter your ingredient names, and base-recipe weights for each, in columns A and B. Then, just enter the percentage change you want to that base recipe in the yellow cell, B12 (e.g. 200 if you want to double it, 50 if you want to halve it), and your new weights for each ingredient, as well as total ingredient weight, will automatically calculate for each ingredient in column C. Additionally, I've added two columns that will automatically calculate baker's % for each ingredient, and % of total weight for each ingredient.
I thought of a much better and less cluttered-looking way to do what I was trying to do with the first workbook. In the new and improved workbook (attached), just enter your ingredient names, and base-recipe weights for each, in columns A and B. Then, just enter the percentage change you want to that base recipe in the yellow cell, B12 (e.g. 200 if you want to double it, 50 if you want to halve it). Additionally, I've added two columns that will automatically calculate baker's % for each ingredient, and % of total weight for each ingredient.
-
Similar Content
-
- 263 replies
- 64,480 views
-
- 705 replies
- 95,741 views
-
- 186 replies
- 70,046 views
-
- 30 replies
- 4,675 views
-
Clam chowder
By jende,
- 20 replies
- 10,021 views
-
-
Recently Browsing 0 members
- No registered users viewing this page.