Bakers Percent Re-Imagined Part 6
Now onto a not-too-difficult stage.
- Viewing multiple recipes on one sheet, to add new, update old & compare numerous simultaneously.
Generating a recipe card with all the ingredients listed along with notes, times, rating links and the bunch of percentages generated quite a few rows to work with. Using these as the location for a multitude of recipes was the obvious way to go.
Excel's grouping limitations didn’t agree and mangled the whole list initially, but another set of formulas, got it sorted. Which led to a “pick a row, any row” layout. With a couple of simple search functions & active filters, managing, reworking and comparing one recipe with several different outcomes fell into place.
Picture 1 is a condensed view of included ingredients.
Picture 2 is the actual row & columns (part) arrangement
Bakers Percent Re-Imagined Part 7 to follow