Spreadsheet: 718207d1613045342-locking-formulas-and-constants-from-sheet-1-in-sheet-2-janine
Sheet: 8 Feb 21 (2)

 | Units sold |  |  |  |  |  | Refill Units |  |  |  |  | Total sold glass |  | Total sold plastic |  |  |  |  | Refills |  |  |  | Glass Profits/Loss |  | Plastics Profits/Loss |  |  |  |  | Refill Profits/Loss |  |  |  |  |  | CONSIGNMENT |  |  |  |  |  |  | SAMPLE |  |  | TOTAL LOSS
WEEK 1 | [NAME] | 300ml | 500ml glass | 500ml plastic | 1l | 2l | 300ml | 500ml glass | 500ml plastic | 1l | 2l | [NAME] | 500ml | 300ml | 500ml | 1l | 2l | 500ml glass | 300ml | 500ml plastic | 1l | 2l | [NAME] | 500ml | 300ml | 500ml | 1l | 2l | 500ml glass | 300ml | 500ml plastic | 1l | 2l |  |  | [NAME] | 300ml | 500ml glass | 500ml plastic | 1l | 2l |  | [NAME] | 300ml | 1L
2021-02-08 00:00:00
Nina's |  |  |  | 6 |  |  |  |  |  |  |  | 0 | 0 | 0 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 188.0013333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1 |  |  | 15.71677777777778
Inn Food | 12 |  | 6 |  |  |  |  |  |  |  |  | 480 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 188.6013333333333 | 135.2013333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 6 |  |  |  |  |  |  | 2 | 56.33422222222222
Jeanne |  |  |  |  | 2 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 56.33422222222222 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1 |  |  | 15.71677777777778
Petro |  |  | 6 |  |  |  |  |  | 1 |  |  | 0 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 135.2013333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 27.83355555555556 | 0 | 0
[NAME] |  |  | 1 |  |  |  |  |  |  |  |  | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.53355555555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 1 |  |  |  |  |  |  |  |  | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.53355555555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 1 |  |  |  |  |  |  |  |  | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.53355555555555 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marina Wharf |  |  |  |  |  | 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48.73422222222223 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15.71677777777778 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crofty | 1 |  |  |  |  |  |  |  |  |  |  | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15.71677777777778 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ant |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1 |  |  | 15.71677777777778
Freebies |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  |  |  |  |  |  |  |  |  |  |  | 480 | 900 | 0 | 360 | 160 | 160 | 0 | 0 | 50 | 0 | 0 | 188.6013333333333 | 338.0033333333333 | 0 | 188.0013333333333 | 56.33422222222222 | 48.73422222222223 | 0 | 0 | 27.83355555555556 | 0 | 0 | 847.508 |  |  |  |  |  |  |  |  |  |  |  | 103.4845555555556
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand P/L
WEEK 2
 | Units sold |  |  |  |  |  | Refill Units |  |  |  |  | Total sold glass |  | Total sold plastic |  |  |  |  | Refills |  |  |  | Glass Profits/Loss |  | Plastics Profits/Loss |  |  |  |  | Refill Profits/Loss |  |  |  |  |  | CONSIGNMENT |  |  |  |  |  |  | SAMPLE |  |  | TOTAL LOSS
 | [NAME] | 300ml | 500ml glass | 500ml plastic | 1l | 2l | 300ml | 500ml glass | 500ml plastic | 1l | 2l | [NAME] | 500ml | 300ml | 500ml | 1l | 2l | 500ml glass | 300ml | 500ml plastic | 1l | 2l | [NAME] | 500ml | 300ml | 500ml | 1l | 2l | 500ml glass | 300ml | 500ml plastic | 1l | 2l |  |  | [NAME] | 300ml | 500ml glass | 500ml plastic | 1l | 2l |  | [NAME] | 300ml | 1L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand P/L