Spreadsheet: 178187d1346691639-subtotalling-variable-data-sample-customer-spreadsheet-oeldere-
Sheet: Sheet 2

PASTE A COPY OF THIS SHEET INTO A NEW ARCHIVE DOCUMENT EVERY WEEK |  |  |  |  |  |  |  |  |  | *Enter manually |  | Calculated
No. of Boxes/Bags |  |  |  |  |  |  |  |  | No. of Portions before substitutions
[NAME] | Standard | Green | Dairy | Large | Extra Veg | Cheese | Eggs |  | [NAME] | Standard | Green | Dairy | Large | Extra Veg | Cheese | Eggs | TOTAL
1 | 19 | 8 | 4 | 5 | 1 | 0 | 20 |  | 0.5 | 19 | 8 | 4 | 10 |  |  |  | 41.5 | Potatoes
 |  |  |  |  |  |  |  |  | 0.5 | 19 | 8 | 4 | 10 |  |  |  | 41.5 | Onions/Carrots
No. of Substitutions |  |  |  |  |  |  |  |  | 0.5 | 19 | 8 | 4 | 5 |  |  |  | 36.5 | Veg 1 | Beetroot Golden/red
A | B | C | D | E | F | G |  |  | 0.5 | 19 | 8 | 4 | 5 |  |  |  | 36.5 | Veg 2 | French/borlotti beans
2 | 3 |  |  |  |  | 2 |  |  |  |  | 8 |  | 5 |  |  |  | 13 | Veg 3 | Mange tout
 |  |  |  |  |  |  |  |  |  |  | 8 |  | 5 |  |  |  | 13 | Veg 4 | Salad lvs
H | I | J | K | L | M |  |  |  |  |  |  |  |  | 1 |  |  | 1 | Veg 5 | Courgette
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Veg 6 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Veg 7 | 0
A: Veg 3 for potatoes |  | E: Veg 4 for onions |  | I: Veg 4 for Veg 1 |  | M: Veg 5 for fruit/salad |  |  | 0.5 | 19 | 8 | 4 | 10 |  |  |  | 41.5 | Fruit/Salad - 0.5kg
B: Veg 3 for onions |  | F: Veg 4 for fruit/salad |  | J: Veg 4 for Veg 2 |  |  |  |  |  |  |  | 4 |  |  | 0 |  | 4 | Cheese - 0.25kg
C: Veg 3 for fruit/salad |  | G: Veg 3 for Veg 1 |  | K: Veg 5 for potatoes |  |  |  |  |  |  |  | 4 |  |  |  | 20 | 24 | Eggs - 1/2 dozen
D: Veg 4 for potatoes |  | H: Veg 3 for Veg 2 |  | L: Veg 5 for Veg 1 or 2
Order Weights/ Unit Equivalent & Prices |  |  |  |  |  |  |  |  |  |  |  | [NAME] (on a per box basis, assuming no substitutions)
Item |  |  | Supplier | Portion (Kg) | Weight OR No. of units |  | Leftovers | Cost (per) |  | Total Cost |  |  | [NAME] | Standard | Green | Dairy | Large | Xtra veg | Xtra eggs | TOTAL
Potatoes |  |  | fasbourn | 1 | 39.5 |  | 0 | 0 | Kg | 0 |  | Av box £ | 3.25 | 5.48 | 7.977272727272728 | 9.5625 | 10.6 | 1.25 | 1.388888888888889 | 39.50866161616161
Onions/Carrots |  |  | green barn | 0.5 | 20.75 |  | 0 | 0 | Kg | 0 |  | Costs | 0 | 0 | 0 | 2.84 | 0 | 0 | 0.68 | 3.52
Veg: |  |  |  |  |  |  |  |  |  |  |  | Gross | 3.25 | 5.48 | 7.977272727272728 | 6.7225 | 10.6 | 1.25 | 0.7088888888888888 | 35.98866161616161
1 | Beetroot Golden/red |  | fasbourn | 0.5 | 17.25 |  |  | 0 | Kg | 0 |  | % | 1 | 1 | 1 | 0.7030065359477125 | 1 | 1 | 0.5104 | 0.9109056126932914
2 | French/borlotti beans |  | fasbourn | 0.4 | 14.6 |  |  | 0 | Kg | 0
3 | Mange tout |  | fasbourn |  | 0 | 12 |  | 0 | Unit | 0
4 | Salad lvs |  | fasbourn | 0.2 | 2.6 | 6 |  | 0 | Unit | 0
5 | Courgette |  | fasbourn | 0.5 | 0.5 |  |  | 0 | Kg | 0
6 |  |  |  |  | 0 |  |  |  | Kg | 0
7 |  |  |  |  | 0 |  |  |  | Kg | 0
Fruit/Salad | tomatoes |  | fasbourn | 0.5 | 20.75 |  |  | 0 | Kg | 0
Cheese |  |  | Rodwell SmSh | 0.18 | 0.72 |  |  | 12 | Kg | 8.64
Eggs - box |  |  | Fasbourn |  |  | 24 |  | 0.68 | Unit | 16.32
 |  |  |  |  |  |  |  |  | TOTAL | 24.96
 | Egg box calculations |  |  | Extra veg calculations
 | 16 | 1/2 dozen |  | 1 | 1 portion
 | 2 | dozen |  | 0 | 2 portions
 |  |  |  | 0 | 3 portions