Spreadsheet: 158227d1338074858-run-macro-when-workbook-opens-if-conditions-are-met-ingredients7
Sheet: Sheet1

 |  |  | Last weekly update = |  | 2012-05-19 00:00:00 | See below for sheet operating instructions
Preprep. Items |  | 41048
 |  | 41049
Pepper Mix |  |  | 3.304 |  | (Drained wt.) See dough sheets for mix instructions
 |  |  |  |  |  |  |  |  |  |  |  |  | 41055.6791380787
Pre-Soaked Millet/Wheatberry Mix |  |  | 16.4176 |  | One part wheat berries to two parts each millet and water (by weight).
Rehydrated Dried Garlic |  |  | 5.88 |  | Equal parts dried minced garlic and water (by weight)
2 Seed Mix |  |  | 0.08 |  | Equal parts poppy and sesame seeds (by weight preferred)
3 Seed Mix |  |  | 1.24 |  | Equal parts poppy, sesame and fennel seeds (by weight preferred).
 |  |  |  |  | Total needed week of
Basic Ingredients | [NAME] | Restock Amt in lbs | In Stock | Amt. Used | 2012-05-20 00:00:00 |  | Needed Mon Bake |  | Needed Thurs Bake |  | Needed FM Bake |  | Starter
Angelica, powder | ok |  | 4.75403 |  | 0.24597 |  | 0.24597 |  | 0 |  | 0
Basil, dried | ok |  | 4.2774425 |  | 0.7225575 |  | 0.2325575 |  | 0 |  | 0.49
Carob, powder | ok |  | 4.656238 |  | 0.343762 |  | 0 |  | 0.12775 |  | 0.216012
Cheese, Blue shredded | ok |  | 16.149335 |  | 3.850665 |  | 0.506415 |  | 0 |  | 3.34425
Cheese, Sharp Cheddar | REORDER |  | 7.190299999999997 |  | 18.8097 |  | 0 |  | 0 |  | 18.8097
Cinnamon, powder | ok |  | 4.503275 |  | 0.496725 |  | 0.17205 |  | 0.19795 |  | 0.126725
Coffee, fine ground | ok |  | 4.80331 |  | 0.19669 |  | 0 |  | 0.12775 |  | 0.06893999999999999
Cranberries, dried | ok |  | 22.13035 |  | 2.86965 |  | 2.86965 |  | 0 |  | 0
[NAME], Rye, medium | ok |  | 35.54614 |  | 14.45386 |  | 12.22436 |  | 0 |  | 2.2295
[NAME], Rye, dark | ok |  | 30.48586 |  | 19.51414 |  | 0 |  | 14.98325 |  | 4.530889999999999
[NAME], Spelt | ok |  | 0.1 |  | 0
[NAME], White unbleached | REORDER |  | 100.4021751666666 |  | 999.5978248333334 |  | 290.299435 |  | 298.79524 |  | 211.1127475 |  | 199.3904023333333
[NAME], [NAME], organic | REORDER |  | 19.1889 |  | 30.8111 |  | 0 |  | 30.8111 |  | 0
[NAME], [NAME], regular | REORDER |  | 120.12076 |  | 179.87924 |  | 67.808925 |  | 75.341275 |  | 36.72904
Garlic, Dried | ok |  | 22.06 |  | 2.94 |  | 0 |  | 0 |  | 2.94
[NAME], Powder | ok |  | 1.1 |  | 0
Honey | REORDER |  | 9.071350000000002 |  | 26.92865 |  | 9.68876 |  | 12.03247 |  | 5.207420000000001
Jalapenos, sliced | REORDER |  | 3.94056 |  | 1.18944 |  | 0 |  | 0 |  | 1.18944
[NAME] | ok |  | 6.652 |  | 3.348 |  | 3.348 |  | 0 |  | 0
Malt, non-diastatic (brewing) | ok |  | 46.6768 |  | 3.3232 |  | 1.206 |  | 2.1172 |  | 0
Millet, hulled | ok |  | 43.43296 |  | 6.56704 |  | 2.3832 |  | 4.18384 |  | 0
Molasses, black strap | ok |  | 17.973495 |  | 6.026505 |  | 2.303805 |  | 2.819625 |  | 0.9030749999999999
Nuts, [NAME], halves & pieces | ok |  | 19.07953 |  | 5.92047 |  | 1.802595 |  | 1.89925 |  | 2.218625
Nuts, Hazelnuts | ok |  | 22.5403 |  | 2.4597 |  | 2.4597 |  | 0 |  | 0
Oats, rolled | ok |  | 26.6768 |  | 3.3232 |  | 1.206 |  | 2.1172 |  | 0
Oil, Canola, 5 gal | ok |  | 0.1 |  | 0
Oil, Canola, spray cans | REORDER |  | -6.111519999999999 |  | 0
Oil, Olive | ok |  | 0.1 |  | 0
Onion, Dried | ok |  | 24.0465 |  | 5.953500000000001 |  | 2.1315 |  | 2.2295 |  | 1.5925
Orange Peel, dried, grated | ok |  | 4.877015 |  | 0.122985 |  | 0.122985 |  | 0 |  | 0
Oregano, dried | ok |  | 4.88355 |  | 0.11645 |  | 0.11645 |  | 0 |  | 0
Polenta (grits) | ok |  | 17.3128 |  | 7.6872 |  | 3.516 |  | 4.1712 |  | 0
Porter, Ginsing | ok |  | 61.248 |  | 1.352 |  | 0.462 |  | 0.462 |  | 0.428
Pepperocini, sliced | REORDER |  | 3.594240000000001 |  | 3.10576 |  | 0 |  | 0 |  | 3.10576
Raisins | ok |  | 25.46825 |  | 9.531749999999999 |  | 3.3015 |  | 3.7985 |  | 2.43175
Red Pepper (Pimento), sliced | ok |  | 34.75112 |  | 2.37888 |  | 0 |  | 0 |  | 2.37888
Rosemary | ok |  | 4.91 |  | 0.09 |  | 0.09 |  | 0 |  | 0
Salt | REORDER |  | -16.7619 |  | 17.7619 |  | 6.271875000000001 |  | 6.691855000000001 |  | 4.798170000000001
Seeds, Caraway | ok |  | 3.8165 |  | 1.1835 |  | 0.5265 |  | 0.657 |  | 0
Seeds, Fennel | ok |  | 4.597 |  | 0.403 |  | 0.052 |  | 0.208 |  | 0.143
Seeds, Flax | ok |  | 10.1468 |  | 4.853199999999999 |  | 1.206 |  | 3.6472 |  | 0
Seeds, Poppy | REORDER |  | 6.2338 |  | 3.7662 |  | 1.258 |  | 2.3652 |  | 0.143
Seeds, Pumpkin | ok |  | 4.68594 |  | 0.31406 |  | 0 |  | 0 |  | 0.31406
Seeds, Sesame | ok |  | 21.0538 |  | 3.9462 |  | 1.318 |  | 2.3652 |  | 0.263
Seeds, Sunflower | ok |  | 21.36274 |  | 3.63726 |  | 1.206 |  | 2.1172 |  | 0.31406
Spinach | REORDER |  | 12 |  | 24 |  | 9 |  | 9 |  | 6
Sundried Tomatoes | ok |  | 4.33555 |  | 0.66445 |  | 0.66445 |  | 0 |  | 0
Wheat Berries | ok |  | 30 |  | 3.28352 |  | 1.1916 |  | 2.09192 |  | 0
INSTRUCTIONS:
If box F2 has a date within the "Week of" date in box F16, the sheet is up to date. (Text is black)
If box F2 has a date before the "Week of" date in box [NAME] (text is red), the sheet needs updating: Press (Ctrl U) one time only.
(If you should press ([NAME]) more than once: Press (Ctrl B) to remove one update.)
Enter incoming ingredients in the "C" column as needed
All ingredients must be entered as pounds. See below for conversions.
If an "In Stock" quantity needs a downward adjustment, enter the amount to subtract in the "E" column.
It's also OK to simply select the "In Stock" box for the item and enter the correct quantity.
CONVERSIONS:
Jalapenos and Red Peppers = 37.13 lbs per case of 6 #10 cans. (6.188 lbs per can).
Pepperocini = 33.4 lbs per case of 4 one gallon containers. (8.35 lbs per gallon)
Blue and Cheddar cheese = 20 lbs per case. (4 bags @ 5 lbs each)
Spinach = 36 lbs per case of 12 3lb boxes.
Honey = 36 lbs per 3 gallon container (12 lbs per gallon)
Molasses = 48 lbs per case of 4 gallons. (12 lbs per gallon)
4 oz = .25 lbs
8 oz = .5 lbs
12 oz = .75 lbs
16 oz = 1 lb