Spreadsheet: 377371d1423931562-how-to-get-the-best-from-my-spreadsheet-complete-excel-novice-spice-list-posted-ndm
Sheet: Sheet2

Item | Supplier | Sum of Cost (Pack) | Sum of Weight (g) | Sum of Price p/gram | Sum of Price p/100 gram
All Spice
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 1.05 | 100 | 0.0105 | 1.05
 | Spice Co | 5.46 | 500 | 0.01092 | 1.092
 | [NAME] |  |  | 0 | 0
Almonds (Flaked)
 | East End | 80.7 | 10000 | 0.00807 | 0.807
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 7.49 | 800 | 0.009362500000000001 | 0.9362500000000001
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
Almonds (Ground)
 | East End | 76.85 | 10000 | 0.007684999999999999 | 0.7685
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 35.99 | 5000 | 0.007198 | 0.7198
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
[NAME]
 | East End | 24.66 | 10000 | 0.002466 | 0.2466
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 5.6 | 1000 | 0.0056 | 0.5599999999999999
 | [NAME] | 0 |  | 0 | 0
[NAME] (Dried)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] | 29.5 | 1000 | 0.0295 | 2.95
 | Paks |  |  | 0 | 0
 | Spice Co | 44.89 | 5000 | 0.008978 | 0.8977999999999999
 | [NAME] |  |  | 0 | 0
[NAME]
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 12.99 | 10000 | 0.001299 | 0.1299
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Bay Leaves (Indian)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 5.49 | 1000 | 0.00549 | 0.549
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Cardamom (Black)
 | East End | 54.1 | 2000 | 0.02705 | 2.705
 | M&T | 4.99 | 200 | 0.02495 | 2.495
 | [NAME] |  |  | 0 | 0
 | Paks | 17.49 | 700 | 0.02498571428571428 | 2.498571428571429
 | Spice Co | 167.44 | 5000 | 0.033488 | 3.3488
 | [NAME] | 0 |  | 0 | 0
Cardamom (Green)
 | East End | 56.76 | 4200 | 0.01351428571428571 | 1.351428571428571
 | M&T | 7.99 | 700 | 0.01141428571428572 | 1.141428571428571
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 108.44 | 5000 | 0.021688 | 2.1688
 | [NAME] | 9.15 | 750 | 0.0122 | 1.22
Cardamom (Seed)
 | East End | 48.5 | 3000 | 0.01616666666666667 | 1.616666666666667
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 13.55 | 500 | 0.0271 | 2.71
 | [NAME] | 16.65 | 750 | 0.0222 | 2.22
Cashews (Broken)
 | East End | 54.5 | 10000 | 0.00545 | 0.545
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Cashews (Whole)
 | East End | 64.6 | 10000 | 0.00646 | 0.6459999999999999
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
[NAME]
 | East End | 25.17 | 6000 | 0.004195 | 0.4195
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 49.02 | 5000 | 0.009804 | 0.9804
 | [NAME] | 6.49 | 2000 | 0.003245 | 0.3245
Cassia Ground
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Chilli (Dried, Red, Whole)
 | East End | 9.4 | 2000 | 0.0047 | 0.47
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 5.25 | 1000 | 0.00525 | 0.525
[NAME] (Dried)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
[NAME]
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
[NAME] (Dried)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] | 18.5 | 1000 | 0.0185 | 1.85
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
[NAME]
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 3.74 | 1000 | 0.00374 | 0.374
 | [NAME] | 1.65 | 400 | 0.004125 | 0.4125
Cloves (Whole)
 | East End | 104.45 | 8000 | 0.01305625 | 1.305625
 | M&T | 18.99 | 1000 | 0.01899 | 1.899
 | [NAME] |  |  | 0 | 0
 | Paks | 14.49 | 600 | 0.02415 | 2.415
 | Spice Co | 85.43 | 5000 | 0.017086 | 1.7086
 | [NAME] | 13.5 | 800 | 0.016875 | 1.6875
Coconut (Blocks)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 23.45 | 40 | 0.5862499999999999 | 58.62499999999999
Coriander (Ground)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 14.18 | 5000 | 0.002836 | 0.2836
 | [NAME] | 0 |  | 0 | 0
Coriander Seed
 | East End | 15.86 | 6000 | 0.002643333333333333 | 0.2643333333333333
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 9.99 | 5000 | 0.001998 | 0.1998
 | Spice Co | 15.6 | 5000 | 0.00312 | 0.312
 | [NAME] | 0 |  | 0 | 0
Cumin (Ground)
 | East End |  |  | 0 | 0
 | M&T | 17.99 | 5000 | 0.003598 | 0.3598
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 23.87 | 5000 | 0.004774 | 0.4774
 | [NAME] |  |  | 0 | 0
[NAME]
 | East End | 34.67 | 12000 | 0.002889166666666667 | 0.2889166666666667
 | M&T | 3.49 | 1000 | 0.00349 | 0.349
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 21.3 | 5000 | 0.00426 | 0.426
 | [NAME] |  |  | 0 | 0
Fenel Seed
 | East End | 29.92 | 10000 | 0.002992 | 0.2992
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 4.75 | 800 | 0.0059375 | 0.59375
 | Spice Co | 19.52 | 5000 | 0.003904 | 0.3904
 | [NAME] | 1.35 | 200 | 0.006750000000000001 | 0.675
Fenugreek Seed (Methi Seed)
 | East End | 17.57 | 12000 | 0.001464166666666667 | 0.1464166666666667
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 4.11 | 1000 | 0.00411 | 0.411
 | [NAME] | 0 |  | 0 | 0
Garam Masala
 | East End | 59.37 | 15000 | 0.003958 | 0.3958
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 20.99 | 5000 | 0.004197999999999999 | 0.4198
 | Spice Co | 18.1 | 5000 | 0.00362 | 0.362
 | [NAME] | 19.99 | 5000 | 0.003998 | 0.3998
[NAME]
 | East End | 10.99 | 12000 | 0.0009158333333333334 | 0.09158333333333334
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Lentils (Split, Red, Masoor, Dhaal)
 | East End | 24.46 | 25000 | 0.0009784 | 0.09784
 | M&T | 2.99 | 2000 | 0.001495 | 0.1495
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
[NAME] (Moong, Dhal, Washed)
 | East End | 33.2 | 20000 | 0.00166 | 0.166
 | M&T | 3.69 | 2000 | 0.001845 | 0.1845
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
Limes (Dried)
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 1.39 | 75 | 0.01853333333333333 | 1.853333333333333
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Methi Leaves (Dried)
 | East End | 14.11 | 6000 | 0.002351666666666666 | 0.2351666666666666
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 5.65 | 500 | 0.0113 | 1.13
 | [NAME] | 0 |  | 0 | 0
Mexican Oregano
 | East End |  |  | 0 | 0
 | M&T |  |  | 0 | 0
 | [NAME] | 14.9 | 400 | 0.03725 | 3.725
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
[NAME] (Black)
 | East End | 12.25 | 9000 | 0.001361111111111111 | 0.1361111111111111
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 13.54 | 5000 | 0.002708 | 0.2708
 | [NAME] | 0 |  | 0 | 0
[NAME]
 | East End | 45.12 | 2000 | 0.02256 | 2.256
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 1.29 | 50 | 0.0258 | 2.58
 | Spice Co | 21.75 | 1000 | 0.02175 | 2.175
 | [NAME] | 0 |  | 0 | 0
Onion Seed ([NAME])
 | East End | 37.33 | 10000 | 0.003733 | 0.3733
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Oregano
 | East End | 61.75 | 10000 | 0.006175 | 0.6174999999999999
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 4.2 | 500 | 0.008400000000000001 | 0.8400000000000001
 | [NAME] | 0 |  | 0 | 0
Paprika
 | East End | 39.8 | 15000 | 0.002653333333333333 | 0.2653333333333333
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 14.99 | 5000 | 0.002998 | 0.2998
 | Spice Co | 30.57 | 5000 | 0.006114 | 0.6113999999999999
 | [NAME] |  |  | 0 | 0
Peppercorns (Wholes, Black)
 | East End | 86.92 | 10000 | 0.008692 | 0.8692
 | M&T | 9.99 | 1000 | 0.00999 | 0.9990000000000001
 | [NAME] |  |  | 0 | 0
 | Paks |  |  | 0 | 0
 | Spice Co | 35.48 | 5000 | 0.007095999999999999 | 0.7095999999999999
 | [NAME] | 4.85 | 400 | 0.012125 | 1.2125
Poppy Seed
 | East End | 28.97 | 6000 | 0.004828333333333333 | 0.4828333333333333
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 2.49 | 300 | 0.0083 | 0.83
 | Spice Co |  |  | 0 | 0
 | [NAME] | 0 |  | 0 | 0
Thyme Leaves (Dried)
 | East End | 57 | 10000 | 0.0057 | 0.5700000000000001
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 2.89 | 250 | 0.01156 | 1.156
 | Spice Co | 3.59 | 500 | 0.00718 | 0.718
 | [NAME] | 0 |  | 0 | 0
[NAME]
 | East End | 22.75 | 15000 | 0.001516666666666667 | 0.1516666666666667
 | M&T |  |  | 0 | 0
 | [NAME] |  |  | 0 | 0
 | Paks | 9.49 | 5000 | 0.001898 | 0.1898
 | Spice Co | 16.89 | 5000 | 0.003378 | 0.3378
 | [NAME] | 0 |  | 0 | 0
Grand Total |  | 2362.259999999999 | 428015 | 1.417087546825396 | 141.7087546825397