Spreadsheet: 104605d1302140655-excel-2007-complex-formulas-for-multiple-sheets-book1
Sheet: Sheet1

Detailed Deliveries to LCBO Stores
Customer Number | LCBO Store # | Type | Delivery Slip # |  | Unit Number | Sku # | [NAME] | Invoice Quantity | # of Cases | Case Price | Freight per Case | Store Deliveries | Freight | HST | Total Payable
1 | LCBO 1 - Tor | 12 PK |  |  | 12 | 10001 | Ale | 12 | 1 | 19.56 | 1.41 | 19.56 | 1.41 | 2.7261 | 23.6961
1 | LCBO 1 - Tor | 12 PK |  |  | 12 | 10003 | Dark | 48 | 4 |  | 1.41 | 0 | 5.64 | 0.7332 | 6.3732
1 | LCBO 1 - Tor | 12PK |  |  | 12 | 10017 | Bottle | 72 | 6 |  | 1.41 | 0 | 8.459999999999999 | 1.0998 | 9.5598
1 | LCBO 1 - Tor | 12 PK |  |  | 12 | 10047 | Summer | 240 | 20 |  | 1.41 | 0 | 28.2 | 3.666 | 31.866
1 | LCBO 1 - Tor | 12PK |  |  | 12 | 10005 | Lager |  |  |  | 1.41
1 | LCBO 1 - Tor | 12 PK |  |  | 12 | 10002 | [NAME] | 1 | 1 |  | 1.41 | 0 | 1.41 | 0.1833 | 1.5933
001 Total |  |  |  |  |  |  |  |  |  |  | 1.41 | 19.56 | 7.05 | 3.4593 | 30.0693
2 | LCBO 2 - Tor | 12 PK |  |  | 12 | 10001 | Ale | 0 | 0 | 19.56 | 1.41 | 0 | 0 | 0 | 0
2 | LCBO 2 - Tor | 12 PK |  |  | 12 | 10003 | Dark | 48 | 4 |  | 1.41 | 0 | 5.64 | 0.7332 | 6.3732
2 | LCBO 2 - Tor | 12 PK |  |  | 5 | 10017 | Bottle |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
2 | LCBO 2 - Tor | EACH |  |  | 1 | 10047 | Summer |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
2 | LCBO 2 - Tor | 12 PK |  |  | 12 | 10005 | Lager |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
2 | LCBO 2 - Tor | 12 PK |  |  | 12 | 10002 | [NAME] |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
 | LCBO 2 - Tor |  |  |  |  |  |  |  |  |  | 1.41
002 Total |  |  |  |  |  |  |  |  |  |  | 1.41 | 0 | 5.64 | 0.7332 | 6.3732
3 | LCBO 3 - Tor. | 12 PK |  |  | 12 | 10001 | Ale | 48 | 4 | 19.56 | 1.41 | 78.24 | 5.64 | 10.9044 | 94.78439999999999
3 | LCBO 3 - Tor. | 12 PK |  |  | 12 | 10003 | Dark | 48 | 4 |  | 1.41 | 0 | 5.64 | 0.7332 | 6.3732
3 | LCBO 3 - Tor. | 12 PK |  |  | 5 | 10017 | Bottle |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
3 | LCBO 3 - Tor. | EACH |  |  | 1 | 10047 | Summer |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
3 | LCBO 3 - Tor. | 12 PK |  |  | 12 | 10005 | Lager |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
3 | LCBO 3 - Tor. | 12 PK |  |  | 12 | 10002 | [NAME] |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 1.41
003 Total |  |  |  |  |  |  |  |  |  |  | 1.41 | 78.24 | 11.28 | 11.6376 | 101.1576
4 | LCBO 4 - Tor. | 12 PK |  |  | 12 | 10001 | Ale | 48 | 4 | 19.56 | 1.41 | 78.24 | 5.64 | 10.9044 | 94.78439999999999
4 | LCBO 4 - Tor. | 12 PK |  |  | 12 | 10003 | Dark | 48 | 4 |  | 1.41 | 0 | 5.64 | 0.7332 | 6.3732
4 | LCBO 4 - Tor. | 12 PK |  |  | 5 | 10017 | Bottle |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
4 | LCBO 4 - Tor. | EACH |  |  | 1 | 10047 | Summer |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
4 | LCBO 4 - Tor. | 12 PK |  |  | 12 | 10005 | Lager |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
4 | LCBO 4 - Tor. | 12 PK |  |  | 12 | 10002 | [NAME] |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 1.41
004 Total |  |  |  |  |  |  |  |  |  |  | 1.41 | 78.24 | 11.28 | 11.6376 | 101.1576
5 | LCBO 5 - Tor. | 12 PK |  |  | 12 | 10001 | Ale | 48 | 4 | 19.56 | 1.41 | 78.24 | 5.64 | 10.9044 | 94.78439999999999
5 | LCBO 5 - Tor. | 12 PK |  |  | 12 | 10003 | Dark | 48 | 4 |  | 1.41 | 0 | 5.64 | 0.7332 | 6.3732
5 | LCBO 5 - Tor. | 12 PK |  |  | 5 | 10017 | Bottle |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
5 | LCBO 5 - Tor. | EACH |  |  | 1 | 10047 | Summer |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
5 | LCBO 5 - Tor. | 12 PK |  |  | 12 | 10005 | Lager |  | 0 |  | 1.41 | 0 | 0 | 0 | 0
5 | LCBO 5 - Tor. | 12 PK |  |  | 12 | 10002 | [NAME] |  | 0 |  | 1.41 | 0 | 0 | 0 | 0