Enter data into Import Spreadsheet #
Basic #
Ingredient names #
Enter your Ingredients' names in the Ingredient column.
When you use these Ingredients in Recipes, the Recipe Ingredients will use these names.
Ingredient prices #
Example
| Ingredient | Price | Amount | Unit | Supplier |
|---|---|---|---|---|
| Apples | 3.00 | 3.00 | kg | Farmer #1 |
| Bananas | 4.00 | 2.00 | kg | Farmer #2 |
| Oranges | 5.00 | 1.00 | kg | Farmer #1 |
| Tomatoes | 6.00 | 0.50 | lb | Farmer #3 |
| Garlic | 7.00 | 1.00 | bag | Farmer #3 |
| Onion | 8.00 | 1.00 | bag | Farmer #3 |
| Honey | 9.00 | 1.00 | L | Natural foods supplier |
| Almonds | 10.00 | 1.00 | kg | Natural foods supplier |
Ingredient suppliers #
Advanced #
Ingredients in a Recipe #
You can also use Fillet’s Import Spreadsheet to specify what Recipes use which Ingredients.
After you import your data, the Fillet apps can do automatic calculations for you.
Example
| Ingredient | Amount | Unit | Recipe |
|---|---|---|---|
| Apples | 3.00 | kg | Fruit cake |
| Bananas | 3.00 | g | Fruit cake |
| Oranges | 3.00 | L | Fruit cake |
| Tomatoes | 3.00 | kg | Pasta sauce |
| Garlic | 2.00 | each | Pasta sauce |
| Onion | 1.50 | lb | Pasta sauce |
| Olive oil | 500.00 | mL | Pasta sauce |
Measurement units #
Enter measurement units in the Units column.
When you use these Ingredients in Recipes, these measurement units are used with the quantities you entered in the Amounts column.
This is Ingredient quantity in a Recipe.
Enter measurement units in the Units column.
When you Order these Ingredients from your suppliers, these measurement units are used with the quantities you entered in the Amounts column.
This is Ingredient price per unit.
Enter custom measurement units (Abstract Units) that you want to use in the Recipes sheet or Prices sheet.
After you import your data, you can use these units in Fillet apps.