Spreadsheet: 82119d1282151472-lookups-choosing-tables-worksheet_table_test
Sheet: Sheet1

SALES REP WORKSHEET |  |  |  |  |  |  | DATE |  |  |  |  |  | CUSTOMER LAST NAME |  |  |  |  |  |  |  |  |  |  |  |  | SALES REP |  |  |  |  |  | [NAME] |  |  |  |  | INVOICE #
 | SERIES |  | UNIT QUANTITY | WHITE ULTRA |  | TOTAL WHITE ULTRA | COLOUR |  |  | WG |  |  | OPERATORS |  |  | DIA |  |  | SILVER |  |  | TRI DI |  | SILVER |  | GRILLS |  | DWR |  | B/M |  | DOOR   LIST |  | DOOR NET AT 56% |  | OTHER |  | TOTAL LINE LABOUR |  | LINE TOTAL
 |  |  |  | W | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0.02
A | U830W |  | 1 | 40 | 30 | 803.9074047610623 |  | 0 |  | Y | 200.9768511902656 |  |  | 0 |  |  | 0 |  | Y | 25 |  | 0 |  | 75 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | 929.8842559513278 |  |  |  |  | YES | 1 | 1000000 | 0.03 | 18 |  | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | 2 |  | 0.04 | 20 | 36 | 757 | 772.14 | 787.5828 | 803.334456 | 819.40114512 | 835.7891680224001 | 853.3407405508704 | 872.1142368429895 | 893.0449785272212 | 914.4780580118746 | 936.4255314041596 | 958.8997441578595 | 981.9133380176481 | 1004.497344792054
B | U890W |  | 0 |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  |  | 3 |  | 0.05 | 22 | 38 | 772.14 | 787.5828 | 803.334456 | 819.40114512 | 835.7891680224001 | 853.3407405508704 | 872.1142368429895 | 893.0449785272212 | 914.4780580118746 | 936.4255314041596 | 958.8997441578595 | 981.9133380176481 | 1004.497344792054 | 1027.600783722271
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 0.06 | 24 | 40 | 787.5828 | 803.334456 | 819.40114512 | 835.7891680224001 | 852.504951382848 | 871.2608961024386 | 891.3007500535352 | 914.4780580118746 | 936.4255314041596 | 958.8997441578595 | 981.9133380176481 | 1005.479258130072 | 1027.600783722271 | 1051.235601747883
C | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 820 | ANDREW S | CHATHAM | 0.01 |  | 0.07 | 26 | 42 | 803.334456 | 819.40114512 | 835.7891680224001 | 852.504951382848 | 869.555050410505 | 889.5573749205897 | 910.9093665547131 | 936.4255314041596 | 958.8997441578595 | 981.9133380176481 | 1005.479258130072 | 1029.610760325193 | 1051.235601747883 | 1075.414020588084
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 830 | [NAME] | WINDSOR | 0.02 |  | 0.08 | 28 | 44 | 819.40114512 | 835.7891680224001 | 852.504951382848 | 869.555050410505 | 886.9461514187152 | 908.238079793922 | 930.9493726189168 | 958.8997441578595 | 981.9133380176481 | 1005.479258130072 | 1029.610760325193 | 1054.321418572998 | 1075.414020588084 | 1100.14854306161
D | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 840 | ROB D | LONDON | 0.03 |  | 0.09 | 30 | 46 | 835.7891680224001 | 852.504951382848 | 869.555050410505 | 886.9461514187152 | 904.6850744470895 | 927.3110794695942 | 951.430258816533 | 981.9133380176481 | 1005.479258130072 | 1029.610760325193 | 1054.321418572998 | 1079.62513261875 | 1100.14854306161 | 1125.451959552027
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 850 | MARK P | SARNIA | 0.04 |  | 0.15 | 32 | 48 | 852.504951382848 | 869.555050410505 | 886.9461514187152 | 904.6850744470895 | 922.7787759360314 | 946.7846121384556 | 972.3617245104967 | 1005.479258130072 | 1029.610760325193 | 1054.321418572998 | 1079.62513261875 | 1105.5361358016 | 1125.451959552027 | 1151.337354621724
E | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 860 | [NAME] | KITCHENER | 0.05 |  |  | 34 | 50 | 869.555050410505 | 886.9461514187152 | 904.6850744470895 | 922.7787759360314 | 941.234351454752 | 966.6670889933631 | 993.7536824497276 | 1029.610760325193 | 1054.321418572998 | 1079.62513261875 | 1105.5361358016 | 1132.069003060839 | 1151.337354621724 | 1177.818113778023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 870 | MILO |  | 0.06 |  |  | 36 | 52 | 886.9461514187152 | 904.6850744470895 | 922.7787759360314 | 941.234351454752 | 960.059038483847 | 986.9670978622237 | 1015.616263463622 | 1054.321418572998 | 1079.62513261875 | 1105.5361358016 | 1132.069003060839 | 1159.238659134299 | 1177.818113778023 | 1204.907930394917
F | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 880 | BRAD |  | 0.07 |  |  | 38 | 54 | 904.6850744470895 | 922.7787759360314 | 941.234351454752 | 960.059038483847 | 979.2602192535239 | 1007.69340691733 | 1037.959821259821 | 1079.62513261875 | 1105.5361358016 | 1132.069003060839 | 1159.238659134299 | 1187.060386953522 | 1204.907930394917 | 1232.620812794
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 890 | GILLES |  | 0.08 |  |  | 40 | 56 | 922.7787759360314 | 941.234351454752 | 960.059038483847 | 979.2602192535239 | 998.8454236385944 | 1028.854968462594 | 1060.794937327538 | 1105.5361358016 | 1132.069003060839 | 1159.238659134299 | 1187.060386953522 | 1215.549836240407 | 1232.620812794 | 1260.971091488262
G | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | P3000 | CHRIS |  | 0.09 |  |  | 42 | 58 | 941.234351454752 | 960.059038483847 | 979.2602192535239 | 998.8454236385944 | 1018.822332111366 | 1050.460922800308 | 1084.132425948744 | 1132.069003060839 | 1159.238659134299 | 1187.060386953522 | 1215.549836240407 | 1244.723032310176 | 1260.971091488262 | 1289.973426592492
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000A |  |  | 0.1 |  |  | 44 | 60 | 960.059038483847 | 979.2602192535239 | 998.8454236385944 | 1018.822332111366 | 1039.198778753594 | 1072.520602179115 | 1107.983339319616 | 1159.238659134299 | 1187.060386953522 | 1215.549836240407 | 1244.723032310176 | 1274.596385085621 | 1289.973426592492 | 1319.642815404119
H | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 3000 |  |  | 0.11 |  |  | 46 | 62 | 979.2602192535239 | 998.8454236385944 | 1018.822332111366 | 1039.198778753594 | 1059.982754328666 | 1095.043534824876 | 1132.358972784647 | 1187.060386953522 | 1215.549836240407 | 1244.723032310176 | 1274.596385085621 | 1305.186698327676 | 1319.642815404119 | 1349.994600158414
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3001 |  |  | 0.12 |  |  | 48 | 64 | 998.8454236385944 | 1018.822332111366 | 1039.198778753594 | 1059.982754328666 | 1081.182409415239 | 1118.039449056198 | 1157.27087018591 | 1215.549836240407 | 1244.723032310176 | 1274.596385085621 | 1305.186698327676 | 1336.51117908754 | 1349.994600158414 | 1381.044475962057
I | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 3002 |  |  | 0.13 |  |  | 50 | 66 | 1018.822332111366 | 1039.198778753594 | 1059.982754328666 | 1081.182409415239 | 1102.806057603544 | 1141.518277486379 | 1182.73082933 | 1244.723032310176 | 1274.596385085621 | 1305.186698327676 | 1336.51117908754 | 1368.587447385641 | 1381.044475962057 | 1412.808498909184
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3003 |  |  | 0.14 |  |  | 52 | 68 | 1039.198778753594 | 1059.982754328666 | 1081.182409415239 | 1102.806057603544 | 1124.862178755615 | 1165.490161313592 | 1208.75090757526 | 1274.596385085621 | 1305.186698327676 | 1336.51117908754 | 1368.587447385641 | 1401.433546122896 | 1412.808498909184 | 1445.303094384096
J | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 3004 |  |  | 0.15 |  |  | 54 | 70 | 1059.982754328666 | 1081.182409415239 | 1102.806057603544 | 1124.862178755615 | 1147.359422330727 | 1189.965454701178 | 1235.343427541916 | 1305.186698327676 | 1336.51117908754 | 1368.587447385641 | 1401.433546122896 | 1435.067951229846 | 1445.303094384096 | 1478.54506555493
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3005 |  |  |  |  |  | 56 | 72 | 1081.182409415239 | 1102.806057603544 | 1124.862178755615 | 1147.359422330727 | 1170.306610777342 | 1214.954729249902 | 1262.520982947838 | 1336.51117908754 | 1368.587447385641 | 1401.433546122896 | 1435.067951229846 | 1469.509582059362 | 1478.54506555493 | 1512.551602062693
A2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | 3006 |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BAY |  |  |  |  |  | 60
B2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | BOW |  |  |  |  |  | 62 |  | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOOR |  |  |  |  |  | 64 | 20 | 576 | 596.16 | 617.0255999999999 | 638.6214959999999 | 660.9732483599998 | 683.4463388042399 | 706.0000679847798 | 729.2980702282774 | 752.6356084755823 | 775.9673123383253 | 800.0222990208133 | 824.0229679914378 | 848.743657031181 | 874.2059667421164 | 900.4321457443799 | 927.4451101167114 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779
C2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | SDLIGHT |  |  |  |  |  | 66 | 22 | 596.16 | 617.0255999999999 | 638.6214959999999 | 660.9732483599998 | 683.4463388042399 | 706.0000679847798 | 729.2980702282774 | 752.6356084755823 | 775.9673123383253 | 800.0222990208133 | 824.0229679914378 | 848.743657031181 | 874.2059667421164 | 900.4321457443799 | 927.4451101167114 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRD |  |  |  |  |  | 68 | 24 | 617.0255999999999 | 638.6214959999999 | 660.9732483599998 | 684.1073120525998 | 706.6835143235841 | 729.2980702282774 | 753.3649065458105 | 776.719947946801 | 800.0222990208133 | 824.8229902904585 | 848.743657031181 | 874.2059667421164 | 900.4321457443799 | 927.4451101167114 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1069.943833283473 | 1102.042148281977
D2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  | DBLDR |  |  |  |  |  | 70 | 26 | 638.6214959999999 | 660.9732483599998 | 684.1073120525998 | 708.0510679744408 | 730.710753810586 | 753.3649065458105 | 778.2259484618222 | 801.5749862810986 | 824.8229902904585 | 850.3925029894626 | 874.2059667421164 | 900.4321457443799 | 927.4451101167114 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612 | 1096.69242911556 | 1129.593201989027
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATIO |  |  |  |  |  | 72 | 28 | 660.9732483599998 | 684.1073120525998 | 708.0510679744408 | 732.8328553535462 | 755.5549194401459 | 778.2259484618222 | 803.9074047610623 | 827.2253858420938 | 850.3925029894626 | 876.7546705821359 | 900.4321457443799 | 927.4451101167114 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612 | 1107.417963639451 | 1124.109739843449 | 1157.833032038752
E2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 74 | 30 | 684.1073120525998 | 708.0510679744408 | 732.8328553535462 | 758.4820052909203 | 781.2437867011109 | 803.9074047610623 | 830.4363491181772 | 853.6965981890409 | 876.7546705821359 | 903.934065370182 | 927.4451101167114 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612 | 1107.417963639451 | 1140.640502548634 | 1152.212483339535 | 1186.778857839721
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76 | 32 | 708.0510679744408 | 732.8328553535462 | 758.4820052909203 | 785.0288754761024 | 807.8060754489487 | 830.4363491181772 | 857.840748639077 | 881.0148893310902 | 903.934065370182 | 931.9560213966575 | 955.2684634202127 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612 | 1107.417963639451 | 1140.640502548634 | 1174.859717625093 | 1181.017795423023 | 1216.448329285714
F2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 78 | 34 | 732.8328553535462 | 758.4820052909203 | 785.0288754761024 | 812.5048861177659 | 835.271482014213 | 857.840748639077 | 886.1494933441664 | 909.2073657896851 | 931.9560213966575 | 960.8466580599538 | 983.9265173228191 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612 | 1107.417963639451 | 1140.640502548634 | 1174.859717625093 | 1210.105509153846 | 1210.543240308599 | 1246.859537517857
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 36 | 758.4820052909203 | 785.0288754761024 | 812.5048861177659 | 840.9425571318876 | 863.6707124026963 | 886.1494933441664 | 915.3924266245239 | 938.3020014949551 | 960.8466580599538 | 990.6329044598123 | 1013.444312842504 | 1043.847642227779 | 1075.163071494612 | 1107.417963639451 | 1140.640502548634 | 1174.859717625093 | 1210.105509153846 | 1246.408674428461 | 1240.806821316314 | 1278.031025955803
H2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 82 | 38 | 785.0288754761024 | 812.5048861177659 | 840.9425571318876 | 870.3755466315037 | 893.0355166243879 | 915.3924266245239 | 945.6003767031331 | 968.3276655427937 | 990.6329044598123 | 1021.342524498066 | 1043.847642227779 | 1075.163071494612 | 1107.417963639451 | 1140.640502548634 | 1174.859717625093 | 1210.105509153846 | 1246.408674428461 | 1283.800934661315 | 1271.826991849221 | 1309.981801604698
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | 40 | 812.5048861177659 | 840.9425571318876 | 870.3755466315037 | 900.8386907636062 | 923.3987241896172 | 945.6003767031331 | 976.8051891343364 | 999.3141508401632 | 1021.342524498066 | 1053.004142757506 | 1075.163071494612 | 1107.417963639451 | 1140.640502548634 | 1174.859717625093 | 1210.105509153846 | 1246.408674428461 | 1283.800934661315 | 1322.314962701155 | 1303.622666645452 | 1342.731346644815
I2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 86 | 42 | 840.9425571318876 | 870.3755466315037 | 900.8386907636062 | 932.3680449403324 | 954.7942808120641 | 976.8051891343364 | 1009.039760375769 | 1031.292203667048 | 1053.004142757506 | 1085.647271182989 | 1107.417963639451 | 1140.640502548634 | 1174.859717625093 | 1210.105509153846 | 1246.408674428461 | 1283.800934661315 | 1322.314962701155 | 1361.98441158219 | 1336.213233311588 | 1376.299630310936
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88 | 44 | 870.3755466315037 | 900.8386907636062 | 932.3680449403324 | 965.0009265132439 | 987.2572863596744 | 1009.039760375769 | 1042.33807246817 | 1064.293554184394 | 1085.647271182989 | 1119.302336589662 | 1140.640502548634 | 1174.859717625093 | 1210.105509153846 | 1246.408674428461 | 1283.800934661315 | 1322.314962701155 | 1361.98441158219 | 1402.843943929655 | 1369.618564144378 | 1410.707121068709
J2 | U830W |  |  |  |  | #N/A |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 90 | 46 | 900.8386907636062 | 932.3680449403324 | 965.0009265132439 | 998.7759589412074 | 1020.824034095903 | 1042.33807246817 | 1076.735228859619 | 1098.350947918295 | 1119.302336589662 | 1154.000709023941 | 1174.859717625093 | 1210.105509153846 | 1246.408674428461 | 1283.800934661315 | 1322.314962701155 | 1361.98441158219 | 1402.843943929655 | 1444.929262247545 | 1403.859028247987 | 1445.974799095427
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92 | 48 | 932.3680449403324 | 965.0009265132439 | 998.7759589412074 | 1033.73311750415 | 1055.532051255164 | 1076.735228859619 | 1112.267491411987 | 1133.49817825168 | 1154.000709023941 | 1189.774731003683 | 1210.105509153846 | 1246.408674428461 | 1283.800934661315 | 1322.314962701155 | 1361.98441158219 | 1402.843943929655 | 1444.929262247545 | 1488.277140114971 | 1438.955503954186 | 1482.124169072812
 | DISCOUNTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL DISCOUNTED PRODUCTS |  |  |  |  |  | #N/A |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 94 | 50 | 965.0009265132439 | 998.7759589412074 | 1033.73311750415 | 1069.913776616795 | 1091.42014099784 | 1112.267491411987 | 1148.972318628582 | 1169.770119955734 | 1189.774731003683 | 1226.657747664797 | 1246.408674428461 | 1283.800934661315 | 1322.314962701155 | 1361.98441158219 | 1402.843943929655 | 1444.929262247545 | 1488.277140114971 | 1532.925454318421 | 1474.929391553041 | 1519.177273299632
 | BASE |  |  |  | 0.2 |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET ITEM 1 |  |  |  |  | NOTES: |  |  |  |  |  |  |  |  |  |  |  |  | 96 | 52 | 998.7759589412074 | 1033.73311750415 | 1069.913776616795 | 1107.360758798382 | 1128.528425791766 | 1148.972318628582 | 1186.888405143325 | 1207.202763794317 | 1226.657747664797 | 1264.684137842406 | 1283.800934661315 | 1322.314962701155 | 1361.98441158219 | 1402.843943929655 | 1444.929262247545 | 1488.277140114971 | 1532.925454318421 | 1578.913217947973 | 1511.802626341867 | 1557.156705132123
 | EARLY ORDER |  |  |  | 0.05 |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET ITEM 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 | 54 | 1033.73311750415 | 1069.913776616795 | 1107.360758798382 | 1146.118385356326 | 1166.898392268686 | 1186.888405143325 | 1226.055722513055 | 1245.833252235736 | 1264.684137842406 | 1303.88934611552 | 1322.314962701155 | 1361.98441158219 | 1402.843943929655 | 1444.929262247545 | 1488.277140114971 | 1532.925454318421 | 1578.913217947973 | 1626.280614486412 | 1549.597692000413 | 1596.085622760426
 | VOLUME |  |  |  | 1-12% |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET ITEM 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 56 | 1069.913776616795 | 1107.360758798382 | 1146.118385356326 | 1186.232528843797 | 1206.572937605822 | 1226.055722513055 | 1266.515561355986 | 1285.699916307279 | 1303.88934611552 | 1344.309915845101 | 1361.98441158219 | 1402.843943929655 | 1444.929262247545 | 1488.277140114971 | 1532.925454318421 | 1578.913217947973 | 1626.280614486412 | 1675.069032921005 | 1588.337634300424 | 1635.987763329436
 | REWARDS |  |  |  | 0.06 |  |  |  | #N/A |  |  |  |  | 1 = Yes , 2 = NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DR HDWR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102 | 58 | 1107.360758798382 | 1146.118385356326 | 1186.232528843797 | 1227.75066735333 | 1247.59641748442 | 1266.515561355986 | 1308.310574880733 | 1326.842313629112 | 1344.309915845101 | 1385.983523236299 | 1402.843943929655 | 1444.929262247545 | 1488.277140114971 | 1532.925454318421 | 1578.913217947973 | 1626.280614486412 | 1675.069032921005 | 1725.321103908635 | 1628.046075157934 | 1676.887457412672
 | 1/2 DOWN |  |  |  | 0.05 |  |  |  | #N/A |  |  |  |  | 1 = Yes , 2 = NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUB TOTAL |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104 | 60 | 1146.118385356326 | 1186.232528843797 | 1227.75066735333 | 1270.721940710696 | 1290.01469567889 | 1308.310574880733 | 1351.484823851797 | 1369.301267665244 | 1385.983523236299 | 1428.949012456624 | 1444.929262247545 | 1488.277140114971 | 1532.925454318421 | 1578.913217947973 | 1626.280614486412 | 1675.069032921005 | 1725.321103908635 | 1777.080737025894 | 1668.747227036882 | 1718.809643847989
 | HST |  |  |  | 0.13 |  |  |  | #N/A |  |  |  |  | 1 = Yes , 2 = NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOORS NET |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR CHARGE INCLUDING EXTRAS |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108
 |  | 0.07 | #N/A |  | 0.04 |  |  | #N/A |  |  |  | 0.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUB TOTAL |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110
 |  | 0.06 | #N/A |  | 0.03 |  |  | #N/A |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H.S.T |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 112
 |  | 0.05 | #N/A |  | 0.02 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL 8% COMM |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120