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

No. | Description | Base Unit of Measure | Variant Code | Customer No. | Customer Name | Invoiced Quantity | [NAME] (Actual) | Profit | Profit Percent | Discount Amount
10001 | Ale | 1CAN |  | 111 | LCBO 111 - Westport | 24 | 54.24 | 45.7 | 0.843 | 0
10001 | Ale | 1CAN |  | 13 | LCBO 13 - Tor. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 130 | LCBO 130 - Bracebridge | 120 | 271.2 | 228.48 | 0.842 | 0
10001 | Ale | 1CAN |  | 15 | LCBO 15 - Tor. | 60 | 135.6 | 114.24 | 0.842 | 0
10001 | Ale | 1CAN |  | 163 | LCBO 163 -Scar. | 60 | 135.6 | 114.24 | 0.842 | 0
10001 | Ale | 1CAN |  | 187 | LCBO 187 - Barrie | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 188 | LCBO 188 - Whitby | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 2 | LCBO 2 - Tor. | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 244 | LCBO 2 - Tor. | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 20 | LCBO 20 - Tor. | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 22 | LCBO 22 - Barrie | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 226 | LCBO 226 - Newmarket | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 228 | LCBO 228 - Scar. | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 237 | LCBO 237 - Brooklin | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 243 | LCBO 243 - Ott. | 24 | 54.24 | 45.7 | 0.843 | 0
10001 | Ale | 1CAN |  | 102 | LCBO 3 - Tor. | 24 | 54.24 | 45.7 | 0.843 | 0
10001 | Ale | 1CAN |  | 31 | LCBO 31 - Collingwood | 96 | 216.96 | 182.79 | 0.843 | 0
10001 | Ale | 1CAN |  | 311 | LCBO 311 - Aurora | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 347 | LCBO 347 - Rosseau | 24 | 54.24 | 45.7 | 0.843 | 0
10001 | Ale | 1CAN |  | 378 | LCBO 378 - Osh. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 38 | LCBO 38 - Ott. | 96 | 216.96 | 182.78 | 0.842 | 0
10001 | Ale | 1CAN |  | 389 | LCBO 389 - Kingston | 60 | 135.6 | 114.24 | 0.842 | 0
10001 | Ale | 1CAN |  | 394 | LCBO 394 - Ott. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 403 | LCBO 403 - Port Carling | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 428 | LCBO 428 - Tor. | 24 | 54.24 | 45.7 | 0.843 | 0
10001 | Ale | 1CAN |  | 431 | LCBO 431 - Ott. | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 453 | LCBO 453 - Newmarket | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 465 | LCBO 465 - Osh. | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 5 | LCBO 5 - Tor. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 511 | LCBO 511 - Tor. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 515 | LCBO 515 - Ott. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 532 | LCBO 532 - Tor. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 556 | LCBO 556 - Ott. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 568 | LCBO 568 - Tor. | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 587 | LCBO 587 - Whitby | 24 | 54.24 | 45.7 | 0.843 | 0
10001 | Ale | 1CAN |  | 589 | LCBO 589 - Ott. | 72 | 162.72 | 137.09 | 0.842 | 0
10001 | Ale | 1CAN |  | 605 | LCBO 605 - Innisfil/Alcona | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 624 | LCBO 624 - Ott/Orleans | 36 | 81.36 | 68.54 | 0.842 | 0
10001 | Ale | 1CAN |  | 635 | LCBO 635 - Maple | 48 | 108.48 | 91.39 | 0.842 | 0
10001 | Ale | 1CAN |  | 771 | LCBO 771 - Ajax | 60 | 135.6 | 114.24 | 0.842 | 0
10003 | Dark | 1CAN |  | 102 | LCBO 102 - Gravenhurst | 24 | 54.24 | 45.11 | 0.832 | 0
10003 | Dark | 1CAN |  | 111 | LCBO 111 - Westport | 24 | 54.24 | 45.11 | 0.832 | 0
10003 | Dark | 1CAN |  | 14 | LCBO 14 -Tor. | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 140 | LCBO 140 - Ottawa - Vanier | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 15 | LCBO 15 - Tor. | 60 | 135.6 | 112.79 | 0.832 | 0
10003 | Dark | 1CAN |  | 163 | LCBO 163 -Scar. | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 187 | LCBO 187 - Barrie | 24 | 54.24 | 45.12 | 0.832 | 0
10003 | Dark | 1CAN |  | 188 | LCBO 188 - Whitby | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 19 | LCBO 19 - Tor. | 48 | 108.48 | 90.23 | 0.832 | 0
10003 | Dark | 1CAN |  | 2 | LCBO 2 - Tor. | 24 | 54.24 | 45.11 | 0.832 | 0
10003 | Dark | 1CAN |  | 201 | LCBO 201 - Ajax | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 209 | LCBO 209 - Alliston | 48 | 108.48 | 90.23 | 0.832 | 0
10003 | Dark | 1CAN |  | 226 | LCBO 226 - Newmarket | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 228 | LCBO 228 - Scar. | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 243 | LCBO 243 - Ott. | 24 | 54.24 | 45.11 | 0.832 | 0
10003 | Dark | 1CAN |  | 31 | LCBO 31 - Collingwood | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 347 | LCBO 347 - Rosseau | 48 | 108.48 | 90.23 | 0.832 | 0
10003 | Dark | 1CAN |  | 38 | LCBO 38 - Ott. | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 389 | LCBO 389 - Kingston | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 428 | LCBO 428 - Tor. | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 431 | LCBO 431 - Ott. | 24 | 54.24 | 45.11 | 0.832 | 0
10003 | Dark | 1CAN |  | 434 | LCBO 434 - Pickering | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 465 | LCBO 465 - Osh. | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 5 | LCBO 5 - Tor. | 48 | 108.48 | 90.23 | 0.832 | 0
10003 | Dark | 1CAN |  | 525 | LCBO 525 - Tor. | 72 | 162.72 | 135.34 | 0.832 | 0
10003 | Dark | 1CAN |  | 568 | LCBO 568 - Tor. | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 572 | LCBO 572 - Tor. | 13 | 29.38 | 24.44 | 0.832 | 0
10003 | Dark | 1CAN |  | 587 | LCBO 587 - Whitby | 24 | 54.24 | 45.11 | 0.832 | 0
10003 | Dark | 1CAN |  | 605 | LCBO 605 - Innisfil/Alcona | 36 | 81.36 | 67.67 | 0.832 | 0
10003 | Dark | 1CAN |  | 635 | LCBO 635 - Maple | 48 | 108.48 | 90.23 | 0.832 | 0
10003 | Dark | 1CAN |  | 771 | LCBO 771 - Ajax | 36 | 81.36 | 67.67 | 0.832 | 0
10005 | Premium Lager | 1CAN |  | 102 | LCBO 102 - Gravenhurst | 24 | 54.24 | 46.97 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 111 | LCBO 111 - Westport | 24 | 54.24 | 46.97 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 15 | LCBO 15 - Tor. | 84 | 189.84 | 164.39 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 188 | LCBO 188 - Whitby | 72 | 162.72 | 140.91 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 20 | LCBO 20 - Tor. | 24 | 54.24 | 46.97 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 201 | LCBO 201 - Ajax | 72 | 162.72 | 140.91 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 209 | LCBO 209 - Alliston | 48 | 108.48 | 93.94 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 22 | LCBO 22 - Barrie | 36 | 81.36 | 70.45 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 237 | LCBO 237 - Brooklin | 60 | 135.6 | 117.42 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 243 | LCBO 243 - Ott. | 36 | 81.36 | 70.45 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 244 | LCBO 244 - Wasaga Beach | 48 | 108.48 | 93.94 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 288 | LCBO 288  - Barrie | 72 | 162.72 | 140.91 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 347 | LCBO 347 - Rosseau | 48 | 108.48 | 93.94 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 353 | LCBO 353 - Markham | 72 | 162.72 | 140.91 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 38 | LCBO 38 - Ott. | 24 | 54.24 | 46.97 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 388 | LCBO 388 - Nepean | 72 | 162.72 | 140.91 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 389 | LCBO 389 - Kingston | 60 | 135.6 | 117.42 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 428 | LCBO 428 - Tor. | 12 | 27.12 | 23.48 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 465 | LCBO 465 - Osh. | 36 | 81.36 | 70.45 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 568 | LCBO 568 - Tor. | 36 | 81.36 | 70.45 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 572 | LCBO 572 - Tor. | 120 | 271.2 | 234.84 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 587 | LCBO 587 - Whitby | 24 | 54.24 | 46.97 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 605 | LCBO 605 - Innisfil/Alcona | 12 | 27.12 | 23.48 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 624 | LCBO 624 - Ott/Orleans | 36 | 81.36 | 70.45 | 0.866 | 0
10005 | Premium Lager | 1CAN |  | 771 | LCBO 771 - Ajax | 36 | 81.36 | 70.45 | 0.866 | 0
10017 | Mixer Pack | EA |  | 19 | LCBO 19 - Tor. | 12 | 130.08 | 100.8 | 0.775 | 0
10017 | Mixer Pack | EA |  | 38 | LCBO 38 - Ott. | 8 | 86.72 | 67.2 | 0.775 | 0
10017 | Mixer Pack | EA |  | 403 | LCBO 403 - Port Carling | 12 | 130.08 | 100.8 | 0.775 | 0
10017 | Mixer Pack | EA |  | 431 | LCBO 431 - Ott. | 12 | 130.08 | 100.8 | 0.775 | 0
10017 | Mixer Pack | EA |  | 556 | LCBO 556 - Ott. | 20 | 216.8 | 168 | 0.775 | 0