Spreadsheet: 178099d1346659022-subtotalling-variable-data-sample-customer-spreadsheet
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
0 | 15 | 6 | 3 | 1 | 1 | 0 | 20 |  | 0 | 15 | 6 | 3 | 2 |  |  |  | 26 | Potatoes
 |  |  |  |  |  |  |  |  | 0 | 15 | 6 | 3 | 2 |  |  |  | 26 | Onions/Carrots
No. of Substitutions |  |  |  |  |  |  |  |  | 0 | 15 | 6 | 3 | 1 |  |  |  | 25 | Veg 1 | Beetroot Golden/red
A | B | C | D | E | F | G |  |  | 0 | 15 | 6 | 3 | 1 |  |  |  | 25 | Veg 2 | French/borlotti beans
2 | 3 |  |  |  |  | 2 |  |  |  |  | 6 |  | 1 |  |  |  | 7 | Veg 3 | Mange tout
 |  |  |  |  |  |  |  |  |  |  | 6 |  | 1 |  |  |  | 7 | 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 | 15 | 6 | 3 | 2 |  |  |  | 26 | Fruit/Salad - 0.5kg
B: Veg 3 for onions |  | F: Veg 4 for fruit/salad |  | J: Veg 4 for Veg 2 |  |  |  |  |  |  |  | 3 |  |  | 0 |  | 3 | Cheese - 0.25kg
C: Veg 3 for fruit/salad |  | G: Veg 3 for Veg 1 |  | K: Veg 5 for potatoes |  |  |  |  |  |  |  | 3 |  |  |  | 20 | 23 | 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 | 24 |  | 0 | 0 | Kg | 0 |  | Av box £ | #N/A | 5.525 | 7.916666666666667 | 9.5 | 10.75 | 1.25 | 1.388888888888889 | 36.33055555555555
Onions/Carrots |  |  | green barn | 0.5 | 13 |  | 0 | 0 | Kg | 0 |  | Costs | 0 | 0 | 0 | 2.84 | 0 | 0 | 0.68 | 3.52
Veg: |  |  |  |  |  |  |  |  |  |  |  | Gross | #N/A | 5.525 | 7.916666666666667 | 6.66 | 10.75 | 1.25 | 0.7088888888888888 | 32.81055555555555
1 | Beetroot Golden/red |  | fasbourn | 0.5 | 11.5 |  |  | 0 | Kg | 0 |  | % | #N/A | 1 | 1 | 0.7010526315789474 | 1 | 1 | 0.5104 | 0.903111858704794
2 | French/borlotti beans |  | fasbourn | 0.4 | 10 |  |  | 0 | Kg | 0
3 | Mange tout |  | fasbourn |  | 0 | 12 |  | 0 | Unit | 0
4 | Salad lvs |  | fasbourn | 0.2 | 1.4 | 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 | 13 |  |  | 0 | Kg | 0
Cheese |  |  | Rodwell SmSh | 0.18 | 0.54 |  |  | 12 | Kg | 6.48
Eggs - box |  |  | Fasbourn |  |  | 23 |  | 0.68 | Unit | 15.64
 |  |  |  |  |  |  |  |  | TOTAL | 22.12
 | Egg box calculations |  |  | Extra veg calculations
 | 16 | 1/2 dozen |  | 1 | 1 portion
 | 2 | dozen |  | 0 | 2 portions
 |  |  |  | 0 | 3 portions