Recipes to Groceries
Your client works at a test kitchen. Each recipe lists its ingredients per serving as text ("3 g Fennel, 5 cups Garlic, ...") plus how many servings they'll make.
Produce the shopping list: each ingredient with the total amount to buy, written as "amount unit" (per-serving amount times servings, summed across recipes). Watch out for units — the same ingredient bought in different units needs separate rows. Row order is up to you.
Work on it
- Make a copy of the template — it becomes your private sheet.
- Solve it however you like — helper columns and extra tabs are fair game. The one rule:
the grader swaps
INPUTfor other datasets, so never put your own content insideINPUT. - Check yourself against the expected sample output shown in your copy (and below).
- Submit below — Share → "anyone with the link, Viewer", paste the link. Your sheet is graded against 2 hidden datasets, so hardcoded answers won't survive.
Sample
Input (Input!A1:C17)
| Recipe | Ingredients Per Serving | Servings Made |
| 1 | 3 g Fennel, 5 cups Garlic, 1 g Olive oil | 3 |
| 2 | 1 tsp Shrimp, 3 g Fennel, 2 lbs Onion | 4 |
| 3 | 2 cups Apple, 3 g Lamb, 1 cup Garlic | 2 |
| 4 | 2 g All purpose flour, 4 g Rice | 1 |
Expected output (Answer!A2:B40)
| Ingredient | Amount |
|---|---|
| All purpose flour | 2 g |
| Apple | 4 cups |
| Fennel | 21 g |
| Garlic | 2 cup |
| Garlic | 15 cups |
| Lamb | 6 g |
| Olive oil | 3 g |
| Onion | 8 lbs |
| Rice | 4 g |
| Shrimp | 4 tsp |
Adapted from "Recipes to Groceries" in the astral.cafe Community Practice Problems sheet.