Spreadsheet: 82099d1282144177-lookups-choosing-tables-worksheet_table_test
Sheet: Sheet1

SALES REP WORKSHEET |  |  |  |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  |  | CUSTOMER LAST NAME |  |  |  |  |  |  |  |  |  |  | SALES REP |  |  |  |  | [NAME] |  |  |  |  |  | INVOICE #
 | SERIES |  | UNIT QUANTITY | WHITE ULTRA |  |  | COLOUR |  | COLOUR COST |  | WHITE U +WG |  | WG COST |  | WHITE U + COL+WG |  | COL&WG COST |  | OPERATOR QUANTITY |  |  | SQ ' TRI DIA |  | SQ FEET SILVER |  | TRI DI |  | SILVER |  | GRILLS |  | DWR | YES 1 NO 2 | B/M | YES 1 NO 2 | DOOR   LIST |  | DOOR NET AT 56% |  | OTHER |  | TOTAL LINE LABOUR |  | LINE TOTAL
 |  |  |  | W | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
A | U890W |  | 1 | 20 | 36 | #N/A |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 | 2 | 0 |  |  |  | 0 |  |  |  |  |  | #N/A |  |  |  |  | YES | 1 | 1000000 | 0.03 | 18 |  | 18 W | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 W | 40 | 42 | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | 2 |  | 0.04 | 20 | 36 H | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 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 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 3006 |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BAY |  |  |  |  |  | 60
B2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | BOW |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOOR |  |  |  |  |  | 64
C2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | SDLIGHT |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRD |  |  |  |  |  | 68
D2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  | DBLDR |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATIO |  |  |  |  |  | 72
E2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
F2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
H2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84
I2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
J2 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92
 | DISCOUNTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL DISCOUNTED PRODUCTS |  |  |  |  |  | #N/A |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 94
 | BASE |  |  |  | 0.2 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET ITEM 1 |  |  |  |  |  | NOTES: |  |  |  |  |  |  |  |  |  |  |  |  | 96
 | EARLY ORDER |  |  |  | 0.05 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET ITEM 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98
 | VOLUME |  |  |  | 1-12% |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET ITEM 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 | REWARDS |  |  |  | 0.06 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  | 1 = Yes , 2 = NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DR HDWR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102
 | 1/2 DOWN |  |  |  | 0.05 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  | 1 = Yes , 2 = NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUB TOTAL |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104
 | 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 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUB TOTAL |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110
 |  | 0.06 | #N/A |  | 0.03 |  | #N/A |  |  |  |  | 0 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H.S.T |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 112
 |  | 0.05 | #N/A |  | 0.02 |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL 8% COMM |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120