VLOOKUP Tutorials

You can watch each of these lessons on YouTube. The are matching links on the pages as well.
Please share this file with anyone who is struggling with MS Excel

Example Files YouTube Links

1_0 VLOOKUP Explained https://youtu.be/JKnV64PPLos

2_0 VLOOKUP Lesson 1- EXACT https://youtu.be/bofmzS_Jb_o
3_1_1 VLOOKUP Join-1 https://youtu.be/Ik8rSkSJr_Q
3_1_2 VLOOKUP Join-1 SOL https://youtu.be/-GvZ9TzS3vc
3_2_1 VLOOKUP Missing Items-1 https://youtu.be/bDdWcqIPLnE
3_2_2 VLOOKUP Missing -1 SOL https://youtu.be/Xu4Bf3TXIK8
3_3_1a VLOOKUP- Anchor info-1a https://youtu.be/nois6jfkfOc
3_3_1b VLOOKUP- Anchor info-1b https://youtu.be/nois6jfkfOc
3_3_2a VLOOKUP- Anchor-1a-SOL https://youtu.be/x9R12NE_V4I
3_3_2b VLOOKUP- Anchor-1b-SOL https://youtu.be/x9R12NE_V4I
3_4_1 VLOOKUP- Error reason-1 https://youtu.be/D9IG33cB7Uw
3_5_1 VLOOKUP -Auto Sort-1 https://youtu.be/6r33f6F5Hxo
3_5_2 VLOOKUP -Auto Sort-1- SOL https://youtu.be/XQ4Fns6ZYbE
4_0 VLOOKUP Lesson 2-CLOSEST https://youtu.be/W6-7vj2KLec
5_1_1 VLOOKUP-Catergorise-1 https://youtu.be/qvpxZ7ZhtbI
5_1_2 VLOOKUP-Catergorise-1-SOL https://youtu.be/OBO_uNHvs3A
5_2_1 VLOOKUP-Catergorise-2 https://youtu.be/dcFEk26Rsls
5_2_2 VLOOKUP-Catergorise-2-SOL https://youtu.be/_eodUgnNp_k
5_3_1 VLOOKUP-Bands-1 https://youtu.be/SovRvrt2jLY
5_3_2 VLOOKUP-Bands-1-SOL https://youtu.be/jYj2UHPNfvg
5_4_1 VLOOKUP-Bands-2 https://youtu.be/zwQs9DFk71c
5_4_2 VLOOKUP-Bands-2-SOL https://youtu.be/JtPzpJhW5II
5_5_1 VLOOKUP-Error-Approximate https://youtu.be/uOj4vhHNH2o
9.7 VLOOKUP partial'!A1 https://youtu.be/UKRfaILKMf0
9.8.1 VLOOKUP Ex 11'!A1 https://youtu.be/kzfbxuDjwDg
9.8.2 VLOOKUP Ex 11 SOL'!A1 https://youtu.be/kzfbxuDjwDg
on the pages as well.

https://youtu.be/Hqy47yiNK9U <<Solution

https://youtu.be/Oq7PajSitcA <<Solution
Subscribe to our Channel
AuditExcel Channel- Click to Subscibe

Description

Explaining what VLOOKUP is in human terms

How to do an exact match e.g. exactly find 'John Smith' otherwise find nothing
Use VLOOKUP to join databases together
Use VLOOKUP to join databases together
Use VLOOKUP to find which items are missing when comparing 2 lists
Use VLOOKUP to find which items are missing when comparing 2 lists
Use VLOOKUP to extract key information from lists that are differently ordered each time
Use VLOOKUP to extract key information from lists that are differently ordered each time
Use VLOOKUP to extract key information from lists that are differently ordered each time
Use VLOOKUP to extract key information from lists that are differently ordered each time
Why does VLOOKUP not find an item that is obviously there
Use VLOOKUP to create an automatically sorting list with no VBA
Use VLOOKUP to create an automatically sorting list with no VBA
Use VLOOKUP to approximate a fit e.g. find where the number 123 would fit in bands of 0,100,200,300
Categorise performance scores into summary descriptions
Categorise performance scores into summary descriptions
Place staff into age groupings based on date of birth
Place staff into age groupings based on date of birth
Calculate commision to be paid based on a commision scale schedule
Calculate commision to be paid based on a commision scale schedule
Calculate tax payments required based on a sliding scale
Calculate tax payments required based on a sliding scale
Why does VLOOKUP not choose the correct band?
Use VLOOKUP to perform a partial match e.g. match 'Lotron' to 'Bio Lotron'
Match email addresses to names e.g. match 'John Smith' to '[email protected]'
Match email addresses to names e.g. match 'John Smith' to '[email protected]'
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/JKnV64PPLos

1 2 3 4 5 6 7 8 9
Team Pld W D L GF GA GD Pts
Manchester City 38 27 5 6 102 37 65 86
Liverpool 38 26 6 6 101 50 51 84
Chelsea 38 25 7 6 71 27 44 82
Arsenal 38 24 7 7 68 41 27 79
Everton 38 21 9 8 61 39 22 72
Tottenham Hotspur 38 21 6 11 55 51 4 69
Manchester United 38 19 7 12 64 43 21 64
Southampton 38 15 11 12 54 46 8 56
Stoke City 38 13 11 14 45 52 -7 50
Newcastle United 38 15 4 19 43 59 -16 49
Crystal Palace 38 13 6 19 33 48 -15 45
Swansea City 38 11 9 18 54 54 0 42
West Ham United 38 11 7 20 40 51 -11 40
Sunderland 38 10 8 20 41 60 -19 38
Aston Villa 38 10 8 20 39 61 -22 38
Hull City 38 10 7 21 38 53 -15 37
West Bromwich Albion 38 7 15 16 43 59 -16 36
Norwich City 38 8 9 21 28 62 -34 33
Fulham 38 9 5 24 40 85 -45 32
Cardiff City 38 7 9 22 32 74 -42 30

Manchester United 64
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/bofmzS_Jb_o

Student Number Result Symbol

A100 75.3% A
A120 68.0% B
A107 45.0% D
A205 92.0% A
A111 34.0% E

Student % Symbol
a111
a150
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/Ik8rSkS

Address List

Employee Employment Total Out of Office

Numbebr Date Expenses Address Answer
100129 10-Sep-04 PO Box 3284, CHIGNIK LAKE #N/A
100135 7-Sep-04 PO Box 8892, BETTLES FIELD 1518
100138 8-Sep-04 PO Box 3827, EEK 2504
100150 3-Sep-04 PO Box 8990, CLARKS POINT #N/A
100164 30-Aug-04 PO Box 8862, CHINIAK #N/A
100169 1-Sep-04 PO Box 4386, DEERING #N/A
100172 2-Sep-04 PO Box 7026, BETHEL 2359
100173 6-Sep-04 PO Box 1293, AKUTAN #N/A
100183 31-Aug-04 PO Box 5850, FORT YUKON #N/A
100195 9-Sep-04 PO Box 2352, CHEFORNAK 1883
100123 3-Sep-04 PO Box 7575, GAMBELL 2669
100132 3-Sep-04 PO Box 1399, ELFIN COVE 2669
100136 6-Sep-04 PO Box 4393, EAGLE #N/A
100141 3-Sep-04 PO Box 8550, CROOKED CREEK 2669
100142 31-Aug-04 PO Box 1072, GLENNALLEN #N/A
100147 30-Aug-04 PO Box 4698, AKHIOK #N/A
100148 3-Sep-04 PO Box 4255, DUTCH HARBOR 2669
100174 10-Sep-04 PO Box 7825, CORDOVA #N/A
100189 1-Sep-04 PO Box 2088, CRAIG #N/A
100191 7-Sep-04 PO Box 9372, BETHEL #N/A
100202 8-Sep-04 PO Box 6508, ANVIK #N/A
100146 9-Sep-04 PO Box 7507, COFFMAN COVE 1992
100154 2-Sep-04 PO Box 2177, EGEGIK 822
100165 1-Sep-04 PO Box 1872, ATKA #N/A
100175 31-Aug-04 PO Box 3401, DEERING 2213
100176 3-Sep-04 PO Box 6329, GAKONA #N/A
100181 30-Aug-04 PO Box 3524, CHICKEN #N/A
100186 7-Sep-04 PO Box 8902, HALIBUT COVE #N/A
100130 3-Sep-04 PO Box 9780, COOPER LANDING #N/A
100137 31-Aug-04 PO Box 8429, HUGHES #N/A
100139 10-Sep-04 PO Box 2426, CLEAR #N/A
100167 1-Sep-04 PO Box 2199, HOOPER BAY #N/A
100171 2-Sep-04 PO Box 7794, CLAM GULCH #N/A
100177 30-Aug-04 PO Box 3578, DUTCH HARBOR #N/A
100179 8-Sep-04 PO Box 2022, CLAM GULCH #N/A
100180 7-Sep-04 PO Box 8814, EMMONAK #N/A
100196 6-Sep-04 PO Box 9013, HAINES #N/A
100197 9-Sep-04 PO Box 8796, AKHIOK #N/A
100124 7-Sep-04 PO Box 7637, ESTER #N/A
100133 3-Sep-04 PO Box 1965, DENALI NATIONAL PAR 1886
100134 9-Sep-04 PO Box 6879, DOT LAKE #N/A
100140 31-Aug-04 PO Box 3802, CHENEGA BAY #N/A
100144 8-Sep-04 PO Box 8729, COOPER LANDING 1185
100151 2-Sep-04 PO Box 7990, GAMBELL #N/A
100155 30-Aug-04 PO Box 9196, COLDFOOT #N/A
100157 10-Sep-04 PO Box 3239, HOLY CROSS 1426
100159 1-Sep-04 PO Box 4182, ATMAUTLUAK 1802
100200 6-Sep-04 PO Box 9937, FORT WAINWRIGHT #N/A
100125 31-Aug-04 PO Box 5968, GUSTAVUS #N/A
100127 6-Sep-04 PO Box 9115, DENALI NATIONAL PAR #N/A
100149 1-Sep-04 PO Box 5381, ANCHOR POINT 2486
100156 8-Sep-04 PO Box 3614, ATQASUK 2091
100158 30-Aug-04 PO Box 6859, FALSE PASS 2142
100160 10-Sep-04 PO Box 1303, CHITINA #N/A
100178 9-Sep-04 PO Box 2490, CHITINA 1674
100182 2-Sep-04 PO Box 6509, ELIM #N/A
100187 7-Sep-04 PO Box 5701, ELFIN COVE #N/A
100192 3-Sep-04 PO Box 2020, CHIGNIK LAKE 1214
100126 7-Sep-04 PO Box 3705, BETHEL #N/A
100145 8-Sep-04 PO Box 1126, AKIAK 1586
100152 2-Sep-04 PO Box 7275, HALIBUT COVE #N/A
100153 10-Sep-04 PO Box 1605, ATKA 2200
100162 3-Sep-04 PO Box 8789, GALENA 2057
100163 6-Sep-04 PO Box 6512, HUGHES #N/A
100166 1-Sep-04 PO Box 3150, COPPER CENTER #N/A
100193 30-Aug-04 PO Box 1466, GAKONA 2385
100194 9-Sep-04 PO Box 4350, ANAKTUVUK PASS #N/A
100201 31-Aug-04 PO Box 5844, DENALI NATIONAL PAR #N/A
100128 31-Aug-04 PO Box 6119, EAGLE RIVER #N/A
100131 3-Sep-04 PO Box 8921, ANVIK #N/A
100161 30-Aug-04 PO Box 3460, AUKE BAY 1384
100170 2-Sep-04 PO Box 9406, CHEFORNAK #N/A
100185 6-Sep-04 PO Box 1917, HOONAH #N/A
100188 1-Sep-04 PO Box 6143, ANGOON 2359
100190 7-Sep-04 PO Box 6619, DUTCH HARBOR #N/A
100198 9-Sep-04 PO Box 5437, AKUTAN #N/A
100199 10-Sep-04 PO Box 7069, GALENA 2074
https://youtu.be/Ik8rSkSJr_Q

Outstanding Expenses

Employee Accomod
Number Petrol Parking ation Total Check For Employment
100162 R 976.00 R 836.00 R 245.00 R 2,057.00
100123 R 975.00 R 831.00 R 863.00 R 2,669.00
100132 R 975.00 R 831.00 R 863.00 R 2,669.00
100141 R 975.00 R 831.00 R 863.00 R 2,669.00
100148 R 975.00 R 831.00 R 863.00 R 2,669.00
100157 R 967.00 R 364.00 R 95.00 R 1,426.00
100144 R 944.00 R 206.00 R 35.00 R 1,185.00
100188 R 923.00 R 863.00 R 573.00 R 2,359.00
100133 R 897.00 R 568.00 R 421.00 R 1,886.00
100195 R 881.00 R 97.00 R 905.00 R 1,883.00
100172 R 880.00 R 740.00 R 739.00 R 2,359.00
100149 R 870.00 R 674.00 R 942.00 R 2,486.00
100158 R 863.00 R 642.00 R 637.00 R 2,142.00
100192 R 861.00 R 303.00 R 50.00 R 1,214.00
100146 R 826.00 R 931.00 R 235.00 R 1,992.00
100178 R 823.00 R 722.00 R 129.00 R 1,674.00
100193 R 821.00 R 782.00 R 782.00 R 2,385.00
100199 R 810.00 R 842.00 R 422.00 R 2,074.00
100156 R 805.00 R 642.00 R 644.00 R 2,091.00
100153 R 782.00 R 832.00 R 586.00 R 2,200.00
100145 R 757.00 R 227.00 R 602.00 R 1,586.00
100159 R 738.00 R 244.00 R 820.00 R 1,802.00
100154 R 718.00 R 7.00 R 97.00 R 822.00
100168 R 717.00 R 98.00 R 770.00 R 1,585.00
100161 R 659.00 R 554.00 R 171.00 R 1,384.00
100138 R 626.00 R 923.00 R 955.00 R 2,504.00
100135 R 594.00 R 151.00 R 773.00 R 1,518.00
100175 R 587.00 R 838.00 R 788.00 R 2,213.00
Answer
100162
100123
100132
100141
100148
100157
100144
100188
100133
100195
100172
100149
100158
100192
100146
100178
100193
100199
100156
100153
100145
100159
100154
#N/A
100161
100138
100135
100175
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/-GvZ9TzS3vc

Address List

Student Numbers Date Registered Total Bill Outstanding

100129 10-Sep-04 #N/A
100135 7-Sep-04 R 1,518
100138 8-Sep-04 R 2,504
100150 3-Sep-04 #N/A
100164 30-Aug-04 #N/A
100169 1-Sep-04 #N/A
100172 2-Sep-04 R 2,359
100173 6-Sep-04 #N/A
100183 31-Aug-04 #N/A
100195 9-Sep-04 R 1,883
100123 3-Sep-04 R 2,669
100132 3-Sep-04 R 2,669
100136 6-Sep-04 #N/A
100141 3-Sep-04 R 2,669
100142 31-Aug-04 #N/A
100147 30-Aug-04 #N/A
100148 3-Sep-04 R 2,669
100174 10-Sep-04 #N/A
100189 1-Sep-04 #N/A
100191 7-Sep-04 #N/A
100202 8-Sep-04 #N/A
100146 9-Sep-04 R 1,992
100154 2-Sep-04 R 822
100165 1-Sep-04 #N/A
100175 31-Aug-04 R 2,213
100176 3-Sep-04 #N/A
100181 30-Aug-04 #N/A
100186 7-Sep-04 #N/A
100130 3-Sep-04 #N/A
100137 31-Aug-04 #N/A
100139 10-Sep-04 #N/A
100167 1-Sep-04 #N/A
100171 2-Sep-04 #N/A
100177 30-Aug-04 #N/A
100179 8-Sep-04 #N/A
100180 7-Sep-04 #N/A
100196 6-Sep-04 #N/A
100197 9-Sep-04 #N/A
100124 7-Sep-04 #N/A
100133 3-Sep-04 R 1,886
100134 9-Sep-04 #N/A
100140 31-Aug-04 #N/A
100144 8-Sep-04 R 1,185
100151 2-Sep-04 #N/A
100155 30-Aug-04 #N/A
100157 10-Sep-04 R 1,426
100159 1-Sep-04 R 1,802
100200 6-Sep-04 #N/A
100125 31-Aug-04 #N/A
100127 6-Sep-04 #N/A
100149 1-Sep-04 R 2,486
100156 8-Sep-04 R 2,091
100158 30-Aug-04 R 2,142
100160 10-Sep-04 #N/A
100178 9-Sep-04 R 1,674
100182 2-Sep-04 #N/A
100187 7-Sep-04 #N/A
100192 3-Sep-04 R 1,214
100126 7-Sep-04 #N/A
100145 8-Sep-04 R 1,586
100152 2-Sep-04 #N/A
100153 10-Sep-04 R 2,200
100162 3-Sep-04 R 2,057
100163 6-Sep-04 #N/A
100166 1-Sep-04 #N/A
100193 30-Aug-04 R 2,385
100194 9-Sep-04 #N/A
100201 31-Aug-04 #N/A
100128 31-Aug-04 #N/A
100131 3-Sep-04 #N/A
100161 30-Aug-04 R 1,384
100170 2-Sep-04 #N/A
100185 6-Sep-04 #N/A
100188 1-Sep-04 R 2,359
100190 7-Sep-04 #N/A
100198 9-Sep-04 #N/A
100199 10-Sep-04 R 2,074
u.be/-GvZ9TzS3vc

Outstanding Bills

Student Number Tuition Fees Accomodation Extras Total Check For Address
100162 R 976.00 R 836.00 R 245.00 R 2,057.00 100162
100123 R 975.00 R 831.00 R 863.00 R 2,669.00 100123
100132 R 975.00 R 831.00 R 863.00 R 2,669.00 100132
100141 R 975.00 R 831.00 R 863.00 R 2,669.00 100141
100148 R 975.00 R 831.00 R 863.00 R 2,669.00 100148
100157 R 967.00 R 364.00 R 95.00 R 1,426.00 100157
100144 R 944.00 R 206.00 R 35.00 R 1,185.00 100144
100188 R 923.00 R 863.00 R 573.00 R 2,359.00 100188
100133 R 897.00 R 568.00 R 421.00 R 1,886.00 100133
100195 R 881.00 R 97.00 R 905.00 R 1,883.00 100195
100172 R 880.00 R 740.00 R 739.00 R 2,359.00 100172
100149 R 870.00 R 674.00 R 942.00 R 2,486.00 100149
100158 R 863.00 R 642.00 R 637.00 R 2,142.00 100158
100192 R 861.00 R 303.00 R 50.00 R 1,214.00 100192
100146 R 826.00 R 931.00 R 235.00 R 1,992.00 100146
100178 R 823.00 R 722.00 R 129.00 R 1,674.00 100178
100193 R 821.00 R 782.00 R 782.00 R 2,385.00 100193
100199 R 810.00 R 842.00 R 422.00 R 2,074.00 100199
100156 R 805.00 R 642.00 R 644.00 R 2,091.00 100156
100153 R 782.00 R 832.00 R 586.00 R 2,200.00 100153
100145 R 757.00 R 227.00 R 602.00 R 1,586.00 100145
100159 R 738.00 R 244.00 R 820.00 R 1,802.00 100159
100154 R 718.00 R 7.00 R 97.00 R 822.00 100154
100168 R 717.00 R 98.00 R 770.00 R 1,585.00 #N/A
100161 R 659.00 R 554.00 R 171.00 R 1,384.00 100161
100138 R 626.00 R 923.00 R 955.00 R 2,504.00 100138
100135 R 594.00 R 151.00 R 773.00 R 1,518.00 100135
100175 R 587.00 R 838.00 R 788.00 R 2,213.00 100175
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/bDdWcqIPLnE

VLOOKUP

List 1

Sales PersTrans ID Date A B C List 2 chec Answer

SP001 100129 10-Sep-04 446 587 363 100129
SP001 100135 7-Sep-04 594 151 773 100135
SP001 100138 8-Sep-04 626 923 955 100138
SP001 100150 3-Sep-04 59 48 419 100150
SP001 100164 30-Aug-04 465 391 349 100164
SP001 100169 1-Sep-04 203 409 240 100169
SP001 100172 2-Sep-04 880 740 739 100172
SP001 100173 6-Sep-04 72 617 190 100173
SP001 100183 31-Aug-04 464 333 382 100183
SP001 100195 9-Sep-04 881 97 905 100195
SP002 100123 3-Sep-04 975 831 863 100123
SP002 100132 3-Sep-04 975 831 863 100132
SP002 100136 6-Sep-04 553 910 380 100136
SP002 100141 3-Sep-04 975 831 863 100141
SP002 100142 31-Aug-04 184 243 369 100142
SP002 100147 30-Aug-04 442 608 535 100147
SP002 100148 3-Sep-04 975 831 863 100148
SP002 100174 10-Sep-04 151 378 656 100174
SP002 100189 1-Sep-04 132 608 352 100189
SP002 100191 7-Sep-04 235 372 779 100191
SP002 100202 8-Sep-04 13 802 991 100202
SP003 100146 9-Sep-04 826 931 235 100146
SP003 100154 2-Sep-04 718 7 97 100154
SP003 100165 1-Sep-04 162 26 518 100165
SP003 100175 31-Aug-04 587 838 788 100175
SP003 100176 3-Sep-04 421 980 393 100176
SP003 100181 30-Aug-04 527 752 963 100181
SP003 100186 7-Sep-04 40 592 27 100186
SP004 100130 3-Sep-04 67 61 587 #N/A
SP004 100137 31-Aug-04 542 705 946 #N/A
SP004 100139 10-Sep-04 458 313 831 #N/A
SP004 100167 1-Sep-04 23 343 165 #N/A
SP004 100171 2-Sep-04 310 348 294 #N/A
SP004 100177 30-Aug-04 185 236 562 #N/A
SP004 100179 8-Sep-04 524 970 831 #N/A
SP004 100180 7-Sep-04 904 985 784 #N/A
SP004 100196 6-Sep-04 483 206 881 #N/A
SP004 100197 9-Sep-04 883 915 583 #N/A
SP005 100124 7-Sep-04 131 724 231 100124
SP005 100133 3-Sep-04 897 568 421 100133
SP005 100134 9-Sep-04 372 889 686 100134
SP005 100140 31-Aug-04 233 493 839 100140
SP005 100144 8-Sep-04 944 206 35 100144
SP005 100151 2-Sep-04 82 319 867 100151
SP005 100155 30-Aug-04 532 614 613 100155
SP005 100157 10-Sep-04 967 364 95 100157
SP005 100159 1-Sep-04 738 244 820 100159
SP005 100200 6-Sep-04 433 965 992 100200
SP006 100125 31-Aug-04 489 339 62 100125
SP006 100127 6-Sep-04 169 915 400 100127
SP006 100149 1-Sep-04 870 674 942 100149
SP006 100156 8-Sep-04 805 642 644 100156
SP006 100158 30-Aug-04 863 642 637 100158
SP006 100160 10-Sep-04 167 609 862 100160
SP006 100178 9-Sep-04 823 722 129 100178
SP006 100182 2-Sep-04 299 719 145 100182
SP006 100187 7-Sep-04 222 144 294 100187
SP006 100192 3-Sep-04 861 303 50 100192
SP007 100126 7-Sep-04 192 118 68 100126
SP007 100145 8-Sep-04 757 227 602 100145
SP007 100152 2-Sep-04 67 759 54 100152
SP007 100153 10-Sep-04 782 832 586 100153
SP007 100162 3-Sep-04 976 836 245 100162
SP007 100163 6-Sep-04 210 90 222 100163
SP007 100166 1-Sep-04 141 332 558 100166
SP007 100193 30-Aug-04 821 782 782 100193
SP007 100194 9-Sep-04 101 680 771 100194
SP007 100201 31-Aug-04 431 672 322 100201
SP008 100128 31-Aug-04 515 320 181 100128
SP008 100131 3-Sep-04 195 259 916 100131
SP008 100161 30-Aug-04 659 554 171 100161
SP008 100170 2-Sep-04 97 333 293 100170
SP008 100185 6-Sep-04 148 618 659 100185
SP008 100188 1-Sep-04 923 863 573 100188
SP008 100190 7-Sep-04 274 933 951 100190
SP008 100198 9-Sep-04 183 147 82 100198
SP008 100199 10-Sep-04 810 842 422 100199
List 2

Sales PersTrans ID Date A B C List 1 Che Answer

SP002 100123 3-Sep-04 975 831 863 100123
SP005 100124 7-Sep-04 131 724 231 100124
SP006 100125 31-Aug-04 489 339 62 100125
SP007 100126 7-Sep-04 192 118 68 100126
SP006 100127 6-Sep-04 169 915 400 100127
SP008 100128 31-Aug-04 515 320 181 100128
SP001 100129 10-Sep-04 446 587 363 100129
SP008 100131 3-Sep-04 195 259 916 100131
SP002 100132 3-Sep-04 975 831 863 100132
SP005 100133 3-Sep-04 897 568 421 100133
SP005 100134 9-Sep-04 372 889 686 100134
SP001 100135 7-Sep-04 594 151 773 100135
SP002 100136 6-Sep-04 553 910 380 100136
SP001 100138 8-Sep-04 626 923 955 100138
SP005 100140 31-Aug-04 233 493 839 100140
SP002 100141 3-Sep-04 975 831 863 100141
SP002 100142 31-Aug-04 184 243 369 100142
SP003 100143 8-Sep-04 500 38 978 #N/A
SP005 100144 8-Sep-04 944 206 35 100144
SP007 100145 8-Sep-04 757 227 602 100145
SP003 100146 9-Sep-04 826 931 235 100146
SP002 100147 30-Aug-04 442 608 535 100147
SP002 100148 3-Sep-04 975 831 863 100148
SP006 100149 1-Sep-04 870 674 942 100149
SP001 100150 3-Sep-04 59 48 419 100150
SP005 100151 2-Sep-04 82 319 867 100151
SP007 100152 2-Sep-04 67 759 54 100152
SP007 100153 10-Sep-04 782 832 586 100153
SP003 100154 2-Sep-04 718 7 97 100154
SP005 100155 30-Aug-04 532 614 613 100155
SP006 100156 8-Sep-04 805 642 644 100156
SP005 100157 10-Sep-04 967 364 95 100157
SP006 100158 30-Aug-04 863 642 637 100158
SP005 100159 1-Sep-04 738 244 820 100159
SP006 100160 10-Sep-04 167 609 862 100160
SP008 100161 30-Aug-04 659 554 171 100161
SP007 100162 3-Sep-04 976 836 245 100162
SP007 100163 6-Sep-04 210 90 222 100163
SP001 100164 30-Aug-04 465 391 349 100164
SP003 100165 1-Sep-04 162 26 518 100165
SP007 100166 1-Sep-04 141 332 558 100166
SP003 100168 6-Sep-04 717 98 770 #N/A
SP001 100169 1-Sep-04 203 409 240 100169
SP008 100170 2-Sep-04 97 333 293 100170
SP001 100172 2-Sep-04 880 740 739 100172
SP001 100173 6-Sep-04 72 617 190 100173
SP002 100174 10-Sep-04 151 378 656 100174
SP003 100175 31-Aug-04 587 838 788 100175
SP003 100176 3-Sep-04 421 980 393 100176
SP006 100178 9-Sep-04 823 722 129 100178
SP003 100181 30-Aug-04 527 752 963 100181
SP006 100182 2-Sep-04 299 719 145 100182
SP001 100183 31-Aug-04 464 333 382 100183
SP003 100184 10-Sep-04 385 890 338 #N/A
SP008 100185 6-Sep-04 148 618 659 100185
SP003 100186 7-Sep-04 40 592 27 100186
SP006 100187 7-Sep-04 222 144 294 100187
SP008 100188 1-Sep-04 923 863 573 100188
SP002 100189 1-Sep-04 132 608 352 100189
SP008 100190 7-Sep-04 274 933 951 100190
SP002 100191 7-Sep-04 235 372 779 100191
SP006 100192 3-Sep-04 861 303 50 100192
SP007 100193 30-Aug-04 821 782 782 100193
SP007 100194 9-Sep-04 101 680 771 100194
SP001 100195 9-Sep-04 881 97 905 100195
SP008 100198 9-Sep-04 183 147 82 100198
SP008 100199 10-Sep-04 810 842 422 100199
SP005 100200 6-Sep-04 433 965 992 100200
SP007 100201 31-Aug-04 431 672 322 100201
SP002 100202 8-Sep-04 13 802 991 100202
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/Xu4Bf3TXIK8

VLOOKUP

List 1

Sales PersTrans ID Date A B C List 2 check

SP001 100129 10-Sep-04 446 587 363 100129
SP001 100135 7-Sep-04 594 151 773 100135
SP001 100138 8-Sep-04 626 923 955 100138
SP001 100150 3-Sep-04 59 48 419 100150
SP001 100164 30-Aug-04 465 391 349 100164
SP001 100169 1-Sep-04 203 409 240 100169
SP001 100172 2-Sep-04 880 740 739 100172
SP001 100173 6-Sep-04 72 617 190 100173
SP001 100183 31-Aug-04 464 333 382 100183
SP001 100195 9-Sep-04 881 97 905 100195
SP002 100123 3-Sep-04 975 831 863 100123
SP002 100132 3-Sep-04 975 831 863 100132
SP002 100136 6-Sep-04 553 910 380 100136
SP002 100141 3-Sep-04 975 831 863 100141
SP002 100142 31-Aug-04 184 243 369 100142
SP002 100147 30-Aug-04 442 608 535 100147
SP002 100148 3-Sep-04 975 831 863 100148
SP002 100174 10-Sep-04 151 378 656 100174
SP002 100189 1-Sep-04 132 608 352 100189
SP002 100191 7-Sep-04 235 372 779 100191
SP002 100202 8-Sep-04 13 802 991 100202
SP003 100146 9-Sep-04 826 931 235 100146
SP003 100154 2-Sep-04 718 7 97 100154
SP003 100165 1-Sep-04 162 26 518 100165
SP003 100175 31-Aug-04 587 838 788 100175
SP003 100176 3-Sep-04 421 980 393 100176
SP003 100181 30-Aug-04 527 752 963 100181
SP003 100186 7-Sep-04 40 592 27 100186
SP004 100130 3-Sep-04 67 61 587 #N/A
SP004 100137 31-Aug-04 542 705 946 #N/A
SP004 100139 10-Sep-04 458 313 831 #N/A
SP004 100167 1-Sep-04 23 343 165 #N/A
SP004 100171 2-Sep-04 310 348 294 #N/A
SP004 100177 30-Aug-04 185 236 562 #N/A
SP004 100179 8-Sep-04 524 970 831 #N/A
SP004 100180 7-Sep-04 904 985 784 #N/A
SP004 100196 6-Sep-04 483 206 881 #N/A
SP004 100197 9-Sep-04 883 915 583 #N/A
SP005 100124 7-Sep-04 131 724 231 100124
SP005 100133 3-Sep-04 897 568 421 100133
SP005 100134 9-Sep-04 372 889 686 100134
SP005 100140 31-Aug-04 233 493 839 100140
SP005 100144 8-Sep-04 944 206 35 100144
SP005 100151 2-Sep-04 82 319 867 100151
SP005 100155 30-Aug-04 532 614 613 100155
SP005 100157 10-Sep-04 967 364 95 100157
SP005 100159 1-Sep-04 738 244 820 100159
SP005 100200 6-Sep-04 433 965 992 100200
SP006 100125 31-Aug-04 489 339 62 100125
SP006 100127 6-Sep-04 169 915 400 100127
SP006 100149 1-Sep-04 870 674 942 100149
SP006 100156 8-Sep-04 805 642 644 100156
SP006 100158 30-Aug-04 863 642 637 100158
SP006 100160 10-Sep-04 167 609 862 100160
SP006 100178 9-Sep-04 823 722 129 100178
SP006 100182 2-Sep-04 299 719 145 100182
SP006 100187 7-Sep-04 222 144 294 100187
SP006 100192 3-Sep-04 861 303 50 100192
SP007 100126 7-Sep-04 192 118 68 100126
SP007 100145 8-Sep-04 757 227 602 100145
SP007 100152 2-Sep-04 67 759 54 100152
SP007 100153 10-Sep-04 782 832 586 100153
SP007 100162 3-Sep-04 976 836 245 100162
SP007 100163 6-Sep-04 210 90 222 100163
SP007 100166 1-Sep-04 141 332 558 100166
SP007 100193 30-Aug-04 821 782 782 100193
SP007 100194 9-Sep-04 101 680 771 100194
SP007 100201 31-Aug-04 431 672 322 100201
SP008 100128 31-Aug-04 515 320 181 100128
SP008 100131 3-Sep-04 195 259 916 100131
SP008 100161 30-Aug-04 659 554 171 100161
SP008 100170 2-Sep-04 97 333 293 100170
SP008 100185 6-Sep-04 148 618 659 100185
SP008 100188 1-Sep-04 923 863 573 100188
SP008 100190 7-Sep-04 274 933 951 100190
SP008 100198 9-Sep-04 183 147 82 100198
SP008 100199 10-Sep-04 810 842 422 100199
List 2

Sales PersTrans ID Date A B C List 1 Check

SP002 100123 3-Sep-04 975 831 863 100123
SP005 100124 7-Sep-04 131 724 231 100124
SP006 100125 31-Aug-04 489 339 62 100125
SP007 100126 7-Sep-04 192 118 68 100126
SP006 100127 6-Sep-04 169 915 400 100127
SP008 100128 31-Aug-04 515 320 181 100128
SP001 100129 10-Sep-04 446 587 363 100129
SP008 100131 3-Sep-04 195 259 916 100131
SP002 100132 3-Sep-04 975 831 863 100132
SP005 100133 3-Sep-04 897 568 421 100133
SP005 100134 9-Sep-04 372 889 686 100134
SP001 100135 7-Sep-04 594 151 773 100135
SP002 100136 6-Sep-04 553 910 380 100136
SP001 100138 8-Sep-04 626 923 955 100138
SP005 100140 31-Aug-04 233 493 839 100140
SP002 100141 3-Sep-04 975 831 863 100141
SP002 100142 31-Aug-04 184 243 369 100142
SP003 100143 8-Sep-04 500 38 978 #N/A
SP005 100144 8-Sep-04 944 206 35 100144
SP007 100145 8-Sep-04 757 227 602 100145
SP003 100146 9-Sep-04 826 931 235 100146
SP002 100147 30-Aug-04 442 608 535 100147
SP002 100148 3-Sep-04 975 831 863 100148
SP006 100149 1-Sep-04 870 674 942 100149
SP001 100150 3-Sep-04 59 48 419 100150
SP005 100151 2-Sep-04 82 319 867 100151
SP007 100152 2-Sep-04 67 759 54 100152
SP007 100153 10-Sep-04 782 832 586 100153
SP003 100154 2-Sep-04 718 7 97 100154
SP005 100155 30-Aug-04 532 614 613 100155
SP006 100156 8-Sep-04 805 642 644 100156
SP005 100157 10-Sep-04 967 364 95 100157
SP006 100158 30-Aug-04 863 642 637 100158
SP005 100159 1-Sep-04 738 244 820 100159
SP006 100160 10-Sep-04 167 609 862 100160
SP008 100161 30-Aug-04 659 554 171 100161
SP007 100162 3-Sep-04 976 836 245 100162
SP007 100163 6-Sep-04 210 90 222 100163
SP001 100164 30-Aug-04 465 391 349 100164
SP003 100165 1-Sep-04 162 26 518 100165
SP007 100166 1-Sep-04 141 332 558 100166
SP003 100168 6-Sep-04 717 98 770 #N/A
SP001 100169 1-Sep-04 203 409 240 100169
SP008 100170 2-Sep-04 97 333 293 100170
SP001 100172 2-Sep-04 880 740 739 100172
SP001 100173 6-Sep-04 72 617 190 100173
SP002 100174 10-Sep-04 151 378 656 100174
SP003 100175 31-Aug-04 587 838 788 100175
SP003 100176 3-Sep-04 421 980 393 100176
SP006 100178 9-Sep-04 823 722 129 100178
SP003 100181 30-Aug-04 527 752 963 100181
SP006 100182 2-Sep-04 299 719 145 100182
SP001 100183 31-Aug-04 464 333 382 100183
SP003 100184 10-Sep-04 385 890 338 #N/A
SP008 100185 6-Sep-04 148 618 659 100185
SP003 100186 7-Sep-04 40 592 27 100186
SP006 100187 7-Sep-04 222 144 294 100187
SP008 100188 1-Sep-04 923 863 573 100188
SP002 100189 1-Sep-04 132 608 352 100189
SP008 100190 7-Sep-04 274 933 951 100190
SP002 100191 7-Sep-04 235 372 779 100191
SP006 100192 3-Sep-04 861 303 50 100192
SP007 100193 30-Aug-04 821 782 782 100193
SP007 100194 9-Sep-04 101 680 771 100194
SP001 100195 9-Sep-04 881 97 905 100195
SP008 100198 9-Sep-04 183 147 82 100198
SP008 100199 10-Sep-04 810 842 422 100199
SP005 100200 6-Sep-04 433 965 992 100200
SP007 100201 31-Aug-04 431 672 322 100201
SP002 100202 8-Sep-04 13 802 991 100202
Instructions: Navigation Page WATCH, LIKE, SUBSCRIBE>>
In row 46 to 51 (yellow blocks) create a formula that will pull through the items described
Period 1
TOTAL OPENING BANK BALANCE 458,190.31
CASH RECEIVED 3,680,050.47
Receipts from Customers 400,000.00
Interest Received 2,050.47
Nedbank Call Account 66,000.00
Sundry Suppliers 3,000,000.00
Inter-Group Loans 212,000.00
TOTAL RECEIPTS 3,680,050.47
CASH PAID OUT
Payments to Suppliers 212,882.07
Advertising & Promotions 17,512.00
Bank Charges 992.65
Interest & Penalties 0.00
Insurance 674.54
Leasing Charges 3,848.97
Salaries & Wages 514,272.59
PAYE 0.00
UIF - Company Contribution 0.00
Pension Company Contribution 605.00
Subscriptions 0.00
Sundry Debtor 0.00
Nedbank Cheque 738.24
Nedbank Cheque 0.00
Nedbank Call Account 0.00
Credit Card 3,255.42
Sundry Suppliers 3,165,777.88
Inter-Group Loans 227,000.00
Loan-M 0.00
Loan -T 0.00
Vat / Tax Control Account 25,499.71
TOTAL PAYMENTS 514,272.59
NET CASH MOVEMENT 3,165,777.88
JOURNAL ENTRIES PROCESSED (65,261.76)
TOTAL CLOSING BANK BALANCE 3,558,706.43

BORDER 1 1 1

Stop the data from moving around

2
TOTAL OPENING BANK BALANCE
TOTAL RECEIPTS
TOTAL PAYMENTS
NET CASH MOVEMENT
JOURNAL ENTRIES PROCESSED
TOTAL CLOSING BANK BALANCE

Build your ratios and calcs

Receipts to payments #DIV/0!
Your answer should be -715.6%

Your answers should be

TOTAL OPENING BANK BALANCE 458,190
TOTAL RECEIPTS 3,680,050
TOTAL PAYMENTS 514,273
NET CASH MOVEMENT 3,165,778
JOURNAL ENTRIES PROCESSED (65,262)
TOTAL CLOSING BANK BALANCE 3,558,706
CH, LIKE, SUBSCRIBE>> https://youtu.be/nois6jfkfOc
hrough the items described in columns C e.g. D446 must pull through the Total opening Balance
Period 2 Period 3 Period 4 Period 5 Period 6
3,558,706.43 3,518,701.55 634,718.72 611,068.65 617,245.25

400,000.00 400,000.00 400,000.00 400,000.00 0.00

2,533.53 1,808.70 2,342.01 3,187.04 1,462.14
421,000.00 170,000.00 210,900.00 410,000.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 631,000.00 0.00 0.00 0.00
823,533.53 1,202,808.70 613,242.01 813,187.04 1,462.14

409,657.23 273,234.05 365,525.06 355,174.24 212,134.77

0.00 0.00 7,252.00 0.00 0.00
992.15 1,395.99 1,118.08 1,012.87 1,162.89
0.00 0.00 0.00 0.00 4,204.28
727.71 1,062.35 714.11 697.87 846.93
3,848.97 3,848.97 3,797.85 3,797.85 3,696.62
21,263.99 40,695.05 27,955.28 0.00 30,329.47
3,623.07 2,865.50 10,589.17 4,645.16 10,744.40
708.51 437.44 499.12 499.12 2,143.59
0.00 0.00 0.00 0.00 0.00
0.00 0.00 725.01 460.80 0.00
0.00 150,000.00 0.00 0.00 0.00
0.00 1,000.00 0.00 0.00 0.00
0.00 1,000.00 0.00 0.00 0.00
380,000.00 270,000.00 190,000.00 390,000.00 0.00
1,716.78 6,285.05 7,816.40 0.00 120.00
0.00 3,000,000.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 421,052.63 0.00 0.00 0.00
0.00 0.00 0.00 2,195.36 0.00
0.00 15,914.50 0.00 28,527.17 0.00
822,538.41 4,188,791.53 615,992.08 787,010.44 265,382.95
995.12 (2,985,982.83) (2,750.07) 26,176.60 (263,920.81)
(41,000.00) 102,000.00 (20,900.00) (20,000.00) 120.00
3,518,701.55 634,718.72 611,068.65 617,245.25 353,444.44

1 1 1 1 1

3 4 5 6 7

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 -100.1% -28.7% -99.6% -103.3% -0.6%

3,558,706 3,518,702 634,719 611,069 617,245

823,534 1,202,809 613,242 813,187 1,462
822,538 4,188,792 615,992 787,010 265,383
995 (2,985,983) (2,750) 26,177 (263,921)
(41,000) 102,000 (20,900) (20,000) 120
3,518,702 634,719 611,069 617,245 353,444
otal opening Balance
Period 7
458,190.31

2,000,000.00
13,383.89
1,277,900.00
3,000,000.00
843,000.00
7,134,283.89

1,828,607.42
24,764.00
6,674.63
4,204.28
4,723.51
22,839.23
141,507.78
32,467.30
4,287.78
605.00
1,185.81
150,000.00
1,738.24
1,000.00
1,230,000.00
19,193.65
3,000,000.00
227,000.00
421,052.63
2,195.36
69,941.38
7,193,988.00
(59,704.11)
(45,041.76)
353,444.44

#DIV/0!
 -99.2%

458,190
7,134,284
7,193,988
(59,704)
(45,042)
353,444
Instructons Navigation Page WATCH, LIKE, SUBSCRIBE>>
Using the formula from Div A, copy and paste the cells in so that it extracts the relev

TOTAL OPENING BANK BALANCE 56,724,213.72

CASH RECEIVED
Receipts from Customers 0.00
Dividends Received 0.00
Interest Received 418,658.80
Bank Charges 0.00
Legal Fees 0.00
Loan to Holding Company- 227,000.00
Nedbank Current- 22,000,000.00
Nedbank Call - 0.00
Investec Bank - 20,917,599.67
TOTAL RECEIPTS 43,563,258.47
CASH PAID OUT
Payments to Suppliers 0.00
Bank Charges 520.59
Consulting Fees 0.00
Dividends Paid 0.00
Loan to Holding Company- 422,900.00
Loan Account - M 842,105.26
Loan Account - D 0.00
Loan Account - F 0.00
Unlisted Invetsment - 12,775,000.00
Nedbank Current- 14,800,000.00
TOTAL PAYMENTS 28,840,525.85
NET CASH MOVEMENT 14,722,732.62
JOURNAL ENTRIES PROCESSED (28,117,599.67)
TOTAL CLOSING BANK BALANCE 43,329,346.67

BORDER 1 1 1

Stop the data from moving around

2
TOTAL OPENING BANK BALANCE
TOTAL RECEIPTS
TOTAL PAYMENTS
NET CASH MOVEMENT
JOURNAL ENTRIES PROCESSED
TOTAL CLOSING BANK BALANCE
Build your ratios and calcs
Receipts to payments #DIV/0!

Your answer should be -151.0%

Your answers should be

TOTAL OPENING BANK BALANCE 56,724,214
TOTAL RECEIPTS 43,563,258
TOTAL PAYMENTS 28,840,526
NET CASH MOVEMENT 14,722,733
JOURNAL ENTRIES PROCESSED (28,117,600)
TOTAL CLOSING BANK BALANCE 43,329,347
H, LIKE, SUBSCRIBE>> https://youtu.be/nois6jfkfOc
so that it extracts the relevant information

43,329,346.67 42,803,097.95 37,232,254.50 37,015,539.40 33,352,008.62

0.00 0.00 0.00 0.00 0.00

0.00 1,012,500.00 0.00 0.00 0.00
444,939.94 362,206.33 304,881.07 231,708.39 277,328.49
0.00 0.00 326.39 663.15 0.00
0.00 0.00 0.00 76,267.66 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 800,000.00 5,033,354.16 0.00
0.00 0.00 0.00 0.00 151,799.36
0.00 0.00 0.00 0.00 0.00
444,939.94 1,374,706.33 1,105,207.46 5,341,993.36 429,127.85

0.00 0.00 0.00 0.00 0.00

136.03 928.48 869.93 524.67 137.03
0.00 0.00 0.00 57,000.00 0.00
0.00 0.00 0.00 421,052.63 421,052.63
0.00 631,000.00 0.00 0.00 78,375.00
421,052.63 51,121.30 421,052.63 0.00 0.00
550,000.00 5,350,000.00 100,000.00 0.00 100,000.00
0.00 0.00 0.00 3,493,592.68 0.00
0.00 912,500.00 0.00 0.00 0.00
959,622.46 6,587,582.47 756,511.59 9,188,121.50 0.00
1,930,811.12 13,533,132.25 1,278,434.15 13,160,291.48 599,564.66
(1,485,871.18) (12,158,425.92) (173,226.69) (7,818,298.12) (170,436.81)
959,622.46 6,587,582.47 (43,488.41) 4,154,767.34 (151,799.36)
42,803,097.95 37,232,254.50 37,015,539.40 33,352,008.62 33,029,772.45

1 1 1 1 1

3 4 5 6 7
 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

-23.0% -10.2% -86.5% -40.6% -71.6%

43,329,347 42,803,098 37,232,255 37,015,539 33,352,009

444,940 1,374,706 1,105,207 5,341,993 429,128
1,930,811 13,533,132 1,278,434 13,160,291 599,565
(1,485,871) (12,158,426) (173,227) (7,818,298) (170,437)
959,622 6,587,582 (43,488) 4,154,767 (151,799)
42,803,098 37,232,255 37,015,539 33,352,009 33,029,772
56,724,213.72

0.00
1,012,500.00
2,039,723.02
989.54
76,267.66
227,000.00
27,833,354.16
151,799.36
20,917,599.67
52,259,233.41

0.00
3,116.73
57,000.00
842,105.26
1,132,275.00
1,735,331.82
6,100,000.00
3,493,592.68
13,687,500.00
32,291,838.02
59,342,759.51
(7,083,526.10)
(16,610,915.17)
33,029,772.45

8
 #DIV/0!

-88.1%

56,724,214
52,259,233
59,342,760
(7,083,526)
(16,610,915)
33,029,772
Instructions: Navigation Page WATCH, LIKE, SUBSCRIBE>>
In row 46 to 51 (yellow blocks) create a formula that will pull through the items described in
Period 1
TOTAL OPENING BANK BALANCE 458190.31
CASH RECEIVED
Receipts from Customers 400000
Interest Received 2050.47
Nedbank Call Account 66000
Sundry Suppliers 3000000
Inter-Group Loans 212000
TOTAL RECEIPTS 3680050.47
CASH PAID OUT
Payments to Suppliers 212882.07
Advertising & Promotions 17512
Bank Charges 992.65
Interest & Penalties 0
Insurance 674.54
Leasing Charges 3848.97
Salaries & Wages Salaries 21263.99
PAYE 0
UIF - Company Contribution 0
Pension Company Contribution 605
Subscriptions 0
Sundry Debtor 0
Nedbank Cheque 738.24
Nedbank Cheque 0
Nedbank Call Account 0
Credit Card 3255.42
Sundry Suppliers 0
Inter-Group Loans 227000
Loan-M 0
Loan -T 0
Vat / Tax Control Account 25499.71
TOTAL PAYMENTS 514272.59
NET CASH MOVEMENT 3165777.88
JOURNAL ENTRIES PROCESSED -65261.76
TOTAL CLOSING BANK BALANCE 3558706.43

BORDER 1 1 1

Stop the data from moving around

2
TOTAL OPENING BANK BALANCE 458,190
TOTAL RECEIPTS 3,680,050
TOTAL PAYMENTS 514,273
NET CASH MOVEMENT 3,165,778
JOURNAL ENTRIES PROCESSED -65,262
TOTAL CLOSING BANK BALANCE 3,558,706
Build your ratios and calcs
Receipts to payments -715.6%

Your answer should be -715.6%

CH, LIKE, SUBSCRIBE>> https://youtu.be/x9R12NE_V4I
hrough the items described in columns C e.g. D446 must pull through the Total opening Balance
Period 2 Period 3 Period 4 Period 5 Period 6
3558706.43 3,518,701.55 634,718.72 611,068.65 617,245.25

400000 400,000.00 400,000.00 400,000.00 -

2533.53 1,808.70 2,342.01 3,187.04 1,462.14
421000 170,000.00 210,900.00 410,000.00 -
0 - - - -
0 631,000.00 - - -
823533.53 1,202,808.70 613,242.01 813,187.04 1,462.14

409657.23 273,234.05 365,525.06 355,174.24 212,134.77

0 - 7,252.00 - -
992.15 1,395.99 1,118.08 1,012.87 1,162.89
0 - - - 4,204.28
727.71 1,062.35 714.11 697.87 846.93
3848.97 3,848.97 3,797.85 3,797.85 3,696.62
21263.99 40,695.05 27,955.28 - 30,329.47
3623.07 2,865.50 10,589.17 4,645.16 10,744.40
708.51 437.44 499.12 499.12 2,143.59
0 - - - -
0 - 725.01 460.80 -
0 150,000.00 - - -
0 1,000.00 - - -
0 1,000.00 - - -
380000 270,000.00 190,000.00 390,000.00 -
1716.78 6,285.05 7,816.40 - 120.00
0 3,000,000.00 - - -
0 - - - -
0 421,052.63 - - -
0 - - 2,195.36 -
0 15,914.50 - 28,527.17 -
822538.41 4,188,791.53 615,992.08 787,010.44 265,382.95
995.12 -2,985,982.83 -2,750.07 26,176.60 -263,920.81
-41000 102,000.00 -20,900.00 -20,000.00 120.00
3518701.55 634,718.72 611,068.65 617,245.25 353,444.44

1 1 1 1 1

3 4 5 6 7
3,558,706 3,518,702 634,719 611,069 617,245
823,534 1,202,809 613,242 813,187 1,462
822,538 4,188,792 615,992 787,010 265,383
995 -2,985,983 -2,750 26,177 -263,921
-41,000 102,000 -20,900 -20,000 120
3,518,702 634,719 611,069 617,245 353,444
-100.1% -28.7% -99.6% -103.3% -0.6%

-100.1% -28.7% -99.6% -103.3% -0.6%

otal opening Balance
Period 7
458,190.31

2,000,000.00
13,383.89
1,277,900.00
3,000,000.00
843,000.00
7,134,283.89

1,828,607.42
24,764.00
6,674.63
4,204.28
4,723.51
22,839.23
141,507.78
32,467.30
4,287.78
605.00
1,185.81
150,000.00
1,738.24
1,000.00
1,230,000.00
19,193.65
3,000,000.00
227,000.00
421,052.63
2,195.36
69,941.38
7,193,988.00
-59,704.11
-45,041.76
353,444.44

8
458,190
7,134,284
7,193,988
-59,704
-45,042
353,444
-99.2%

-99.2%
Instructons Navigation Page WATCH, LIKE, SUBSCRIBE>>
Using the formula from Div A, copy and paste the cells in so that it extracts the relev

TOTAL OPENING BANK BALANCE 56724213.72

CASH RECEIVED
Receipts from Customers 0
Dividends Received 0
Interest Received 418658.8
Bank Charges 0
Legal Fees 0
Loan to Holding Company- 227000
Nedbank Current- 22000000
Nedbank Call - 0
Investec Bank - 20917599.67
TOTAL RECEIPTS 43563258.47
CASH PAID OUT
Payments to Suppliers 0
Bank Charges 520.59
Consulting Fees 0
Dividends Paid 0
Loan to Holding Company- 422900
Loan Account - M 842105.26
Loan Account - D 0
Loan Account - F 0
Unlisted Invetsment - 12775000
Nedbank Current- 14800000
TOTAL PAYMENTS 28840525.85
NET CASH MOVEMENT 14722732.62
JOURNAL ENTRIES PROCESSED -28117599.67
TOTAL CLOSING BANK BALANCE 43329346.67

BORDER 1 1 1

Stop the data from moving around

2
TOTAL OPENING BANK BALANCE 56,724,214
TOTAL RECEIPTS 43,563,258
TOTAL PAYMENTS 28,840,526
NET CASH MOVEMENT 14,722,733
JOURNAL ENTRIES PROCESSED -28,117,600
TOTAL CLOSING BANK BALANCE 43,329,347
Build your ratios and calcs
Receipts to payments -151.0%

Your answer should be -151.0%

H, LIKE, SUBSCRIBE>> https://youtu.be/x9R12NE_V4I
so that it extracts the relevant information

43329346.67 42,803,097.95 37,232,254.50 37,015,539.40 33,352,008.62

0 - - - -
0 1,012,500.00 - - -
444939.94 362,206.33 304,881.07 231,708.39 277,328.49
0 - 326.39 663.15 -
0 - - 76,267.66 -
0 - - - -
0 - 800,000.00 5,033,354.16 -
0 - - - 151,799.36
0 - - - -
444939.94 1,374,706.33 1,105,207.46 5,341,993.36 429,127.85

0 - - - -
136.03 928.48 869.93 524.67 137.03
0 - - 57,000.00 -
0 - - 421,052.63 421,052.63
0 631,000.00 - - 78,375.00
421052.63 51,121.30 421,052.63 - -
550000 5,350,000.00 100,000.00 - 100,000.00
0 - - 3,493,592.68 -
0 912,500.00 - - -
959622.46 6,587,582.47 756,511.59 9,188,121.50 -
1930811.12 13,533,132.25 1,278,434.15 13,160,291.48 599,564.66
-1485871.18 -12,158,425.92 -173,226.69 -7,818,298.12 -170,436.81
959622.46 6,587,582.47 -43,488.41 4,154,767.34 -151,799.36
42803097.95 37,232,254.50 37,015,539.40 33,352,008.62 33,029,772.45

1 1 1 1 1

3 4 5 6 7
43,329,347 42,803,098 37,232,255 37,015,539 33,352,009
444,940 1,374,706 1,105,207 5,341,993 429,128
1,930,811 13,533,132 1,278,434 13,160,291 599,565
-1,485,871 -12,158,426 -173,227 -7,818,298 -170,437
959,622 6,587,582 -43,488 4,154,767 -151,799
42,803,098 37,232,255 37,015,539 33,352,009 33,029,772
-23.0% -10.2% -86.5% -40.6% -71.6%

-23.0% -10.2% -86.5% -40.6% -71.6%

56,724,213.72

-
1,012,500.00
2,039,723.02
989.54
76,267.66
227,000.00
27,833,354.16
151,799.36
20,917,599.67
52,259,233.41

-
3,116.73
57,000.00
842,105.26
1,132,275.00
1,735,331.82
6,100,000.00
3,493,592.68
13,687,500.00
32,291,838.02
59,342,759.51
-7,083,526.10
-16,610,915.17
33,029,772.45

8
56,724,214
52,259,233
59,342,760
-7,083,526
-16,610,915
33,029,772
-88.1%

-88.1%
Navigation Page QUES: WATCH, LIKE, SUBSCRIBE>> https://youtu.be/D9IG33cB7Uw
Symbol Table

Student Number Result Symbol Score

A100 75% A 0%
A120 68% B 35%
A107 45% D 50%
A205 92% A 60%
A111 34% E 75%

Enter the student number % Symbol

A111 #N/A #N/A
 SOL: WATCH, LIKE, SUBSCRIBE>> https://youtu.be/Hqy47yiNK9U
mbol Table
Symbol (if equal
to or above the
mark)
E
D
C
B
A
Automatic Sorting Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/6r33f6F5Hxo
Input information

RANK by TOTAL Average Unique

SALES (Column E) Sales People Units Sold Sales Price Total Sales Identifier
Adrian 100 20.00 2,000.00
Mark 52 23.50 1,222.00
Mary 67 23.00 1,541.00
Jane 89 19.50 1,735.50
Antoinette 10 35.00 350.00
Trevor 81 19.25 1,559.25
Cary 67 23.00 1,541.00

Final Rankings 2 3 4 5
1
2
3
4
5
6
7
Unique Sales
Rank
Automatic Sorting Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/XQ4Fns6ZYbE
Input information

RANK by TOTAL Average Unique

SALES (Column E) Sales People Units Sold Sales Price Total Sales Identifier
2 Adrian 78 20.00 1,560.00 0.000001
6 Mark 52 23.50 1,222.00 0.000002
5 Mary 67 23.00 1,541.00 0.000003
1 Jane 89 19.50 1,735.50 0.000004
7 Antoinette 10 35.00 350.00 0.000005
3 Trevor 81 19.25 1,559.25 0.000006
4 Cary 67 23.00 1,541.00 0.000007

Final Rankings
1 Jane 89 19.5 1735.5
2 Adrian 78 20 1560
3 Trevor 81 19.25 1559.25
4 Cary 67 23 1541
5 Mary 67 23 1541
6 Mark 52 23.5 1222
7 Antoinette 10 35 350
Q4Fns6ZYbE

Unique Sales
Rank
1,560.000001
1,222.000002
1,541.000003
1,735.500004
350.000005
1,559.250006
1,541.000007
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/W6-7vj2KLec
Symbol Table

Student Number Result Symbol Score

A100 75.3% 0%
A120 68.0% 35%
A107 45.0% 50%
A205 92.0% 60%
A111 34.0% 75%
mbol Table

Symbol (if equal

to or above the
mark)
E
D
C
B
A
 WATCH, LIKE, SUBSCRIBE>>
Navigation Page https://youtu.be/qvpxZ7ZhtbI

Employee
Number Name Rating Your answer should be
0018 Alissa Reiling 3.60 Inconsistent
0013 Arielle Uhlman 0.60 Unsatisfactory
0015 Aura Rada 5.00 Effective
0016 Debera Shore 2.30 Unsatisfactory
0001 Doreatha Navin 9.80 Highly Effective
0004 Edra Langer 3.70 Inconsistent
0010 Elissa Spies 8.50 Highly Effective
0007 Eliz Toledo 4.80 Inconsistent
0012 Kiara Mclester 7.00 Effective
0017 Kristle Bryand 2.80 Inconsistent
0009 Lue Ciesielski 4.00 Inconsistent
0019 Madison Turek 0.90 Unsatisfactory
0008 Marcia Mauzy 3.50 Inconsistent
0003 Patrick Leider 4.20 Inconsistent
0002 Polly Lotts 1.80 Unsatisfactory
0005 Scot Edenfield 3.50 Inconsistent
0006 Shawnta Pershall 8.50 Highly Effective
0020 Sunny Morford 2.50 Inconsistent
0014 Virginia Pridmore 9.60 Highly Effective
0011 Wilber Brink 6.90 Effective
Average 4.68
Rating Description
0 Unsatisfactory
2.5 Inconsistent
5 Effective
7.5 Highly Effective
10 Exceptional
 WATCH, LIKE, SUBSCRIBE>>
Navigation Page https://youtu.be/OBO_uNHvs3A

Employee
Number Name Rating
0018 Alissa Reiling 3.60 Inconsistent
0013 Arielle Uhlman 0.60 Unsatisfactory
0015 Aura Rada 5.00 Effective
0016 Debera Shore 2.30 Unsatisfactory
0001 Doreatha Navin 9.80 Highly Effective
0004 Edra Langer 3.70 Inconsistent
0010 Elissa Spies 8.50 Highly Effective
0007 Eliz Toledo 4.80 Inconsistent
0012 Kiara Mclester 7.00 Effective
0017 Kristle Bryand 2.80 Inconsistent
0009 Lue Ciesielski 4.00 Inconsistent
0019 Madison Turek 0.90 Unsatisfactory
0008 Marcia Mauzy 3.50 Inconsistent
0003 Patrick Leider 4.20 Inconsistent
0002 Polly Lotts 1.80 Unsatisfactory
0005 Scot Edenfield 3.50 Inconsistent
0006 Shawnta Pershall 8.50 Highly Effective
0020 Sunny Morford 2.50 Inconsistent
0014 Virginia Pridmore 9.60 Highly Effective
0011 Wilber Brink 6.90 Effective
Average 4.68
Rating Description
0 Unsatisfactory
2.5 Inconsistent
5 Effective
7.5 Highly Effective
10 Exceptional
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/dcFEk26Rsls

Categories
0 Less Than 20
20 Between 20 and 35
35 Between 35 and 50
50 Between 50 and 65
65 Over 65

Reporting Date 1-Jan-14

Employee Number Name Date of Birth Age Category

0001 Doreatha Navin 20-Jan-89 25.0
0002 Polly Lotts 18-Nov-98 15.1
0003 Patrick Leider 18-Feb-98 15.9
0004 Edra Langer 4-Aug-86 27.4
0005 Scot Edenfield 19-Dec-47 66.1
0001 Doreatha Navin 13-Oct-98 15.2
0002 Polly Lotts 20-Mar-63 50.8
0003 Patrick Leider 16-Mar-60 53.8
0004 Edra Langer 11-Feb-97 16.9
0005 Scot Edenfield 28-Apr-68 45.7
0001 Doreatha Navin 10-Dec-75 38.1
0002 Polly Lotts 24-May-74 39.6
0003 Patrick Leider 3-Sep-76 37.4
0004 Edra Langer 10-Feb-59 54.9
0005 Scot Edenfield 15-Apr-97 16.7
0001 Doreatha Navin 22-Oct-83 30.2
0002 Polly Lotts 9-May-92 21.7
0003 Patrick Leider 14-Jul-81 32.5
0004 Edra Langer 29-Nov-53 60.1
0005 Scot Edenfield 25-Jan-64 50.0
0001 Doreatha Navin 2-Aug-55 58.5
0002 Polly Lotts 19-Feb-95 18.9
0003 Patrick Leider 9-Aug-89 24.4
0004 Edra Langer 2-Jan-84 30.0
0005 Scot Edenfield 15-Aug-94 19.4
0001 Doreatha Navin 20-Jan-94 20.0
0002 Polly Lotts 15-Jun-65 48.6
0003 Patrick Leider 16-Apr-80 33.7
0004 Edra Langer 13-Apr-71 42.8
0005 Scot Edenfield 17-Mar-92 21.8
0001 Doreatha Navin 9-Feb-58 55.9
0002 Polly Lotts 29-May-94 19.6
0003 Patrick Leider 11-Nov-75 38.2
0004 Edra Langer 29-Mar-65 48.8
0005 Scot Edenfield 3-Jul-81 32.5
0001 Doreatha Navin 31-Dec-89 24.0
0002 Polly Lotts 4-Jun-76 37.6
0003 Patrick Leider 21-May-49 64.7
0004 Edra Langer 14-Apr-62 51.8
0005 Scot Edenfield 19-Feb-91 22.9
0001 Doreatha Navin 21-Dec-81 32.1
0002 Polly Lotts 17-Feb-59 54.9
0003 Patrick Leider 4-Jun-84 29.6
0004 Edra Langer 16-Dec-88 25.1
0005 Scot Edenfield 11-Aug-77 36.4
0001 Doreatha Navin 14-May-94 19.6
0002 Polly Lotts 16-Nov-55 58.2
0003 Patrick Leider 6-Apr-86 27.8
0004 Edra Langer 12-May-73 40.7
0005 Scot Edenfield 28-Mar-56 57.8
Your Answer Should be
Between 20 and 35
Less Than 20
Less Than 20
Between 20 and 35
Over 65
Less Than 20
Between 50 and 65
Between 50 and 65
Less Than 20
Between 35 and 50
Between 35 and 50
Between 35 and 50
Between 35 and 50
Between 50 and 65
Less Than 20
Between 20 and 35
Between 20 and 35
Between 20 and 35
Between 50 and 65
Between 35 and 50
Between 50 and 65
Less Than 20
Between 20 and 35
Between 20 and 35
Less Than 20
Less Than 20
Between 35 and 50
Between 20 and 35
Between 35 and 50
Between 20 and 35
Between 50 and 65
Less Than 20
Between 35 and 50
Between 35 and 50
Between 20 and 35
Between 20 and 35
Between 35 and 50
Between 50 and 65
Between 50 and 65
Between 20 and 35
Between 20 and 35
Between 50 and 65
Between 20 and 35
Between 20 and 35
Between 35 and 50
Less Than 20
Between 50 and 65
Between 20 and 35
Between 35 and 50
Between 50 and 65
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/_eodUgnNp_k

Categories
0 Less Than 20
20 Between 20 and 35
35 Between 35 and 50
50 Between 50 and 65
65 Over 65

Reporting Date 1-Jan-14

Employee Number Name Date of Birth Age Category

0001 Doreatha Navin 20-Jan-89 25.0 Between 20 and 35
0002 Polly Lotts 18-Nov-98 15.1 Less Than 20
0003 Patrick Leider 18-Feb-98 15.9 Less Than 20
0004 Edra Langer 4-Aug-86 27.4 Between 20 and 35
0005 Scot Edenfield 19-Dec-47 66.1 Over 65
0001 Doreatha Navin 13-Oct-98 15.2 Less Than 20
0002 Polly Lotts 20-Mar-63 50.8 Between 50 and 65
0003 Patrick Leider 16-Mar-60 53.8 Between 50 and 65
0004 Edra Langer 11-Feb-97 16.9 Less Than 20
0005 Scot Edenfield 28-Apr-68 45.7 Between 35 and 50
0001 Doreatha Navin 10-Dec-75 38.1 Between 35 and 50
0002 Polly Lotts 24-May-74 39.6 Between 35 and 50
0003 Patrick Leider 3-Sep-76 37.4 Between 35 and 50
0004 Edra Langer 10-Feb-59 54.9 Between 50 and 65
0005 Scot Edenfield 15-Apr-97 16.7 Less Than 20
0001 Doreatha Navin 22-Oct-83 30.2 Between 20 and 35
0002 Polly Lotts 9-May-92 21.7 Between 20 and 35
0003 Patrick Leider 14-Jul-81 32.5 Between 20 and 35
0004 Edra Langer 29-Nov-53 60.1 Between 50 and 65
0005 Scot Edenfield 25-Jan-64 50.0 Between 35 and 50
0001 Doreatha Navin 2-Aug-55 58.5 Between 50 and 65
0002 Polly Lotts 19-Feb-95 18.9 Less Than 20
0003 Patrick Leider 9-Aug-89 24.4 Between 20 and 35
0004 Edra Langer 2-Jan-84 30.0 Between 20 and 35
0005 Scot Edenfield 15-Aug-94 19.4 Less Than 20
0001 Doreatha Navin 20-Jan-94 20.0 Less Than 20
0002 Polly Lotts 15-Jun-65 48.6 Between 35 and 50
0003 Patrick Leider 16-Apr-80 33.7 Between 20 and 35
0004 Edra Langer 13-Apr-71 42.8 Between 35 and 50
0005 Scot Edenfield 17-Mar-92 21.8 Between 20 and 35
0001 Doreatha Navin 9-Feb-58 55.9 Between 50 and 65
0002 Polly Lotts 29-May-94 19.6 Less Than 20
0003 Patrick Leider 11-Nov-75 38.2 Between 35 and 50
0004 Edra Langer 29-Mar-65 48.8 Between 35 and 50
0005 Scot Edenfield 3-Jul-81 32.5 Between 20 and 35
0001 Doreatha Navin 31-Dec-89 24.0 Between 20 and 35
0002 Polly Lotts 4-Jun-76 37.6 Between 35 and 50
0003 Patrick Leider 21-May-49 64.7 Between 50 and 65
0004 Edra Langer 14-Apr-62 51.8 Between 50 and 65
0005 Scot Edenfield 19-Feb-91 22.9 Between 20 and 35
0001 Doreatha Navin 21-Dec-81 32.1 Between 20 and 35
0002 Polly Lotts 17-Feb-59 54.9 Between 50 and 65
0003 Patrick Leider 4-Jun-84 29.6 Between 20 and 35
0004 Edra Langer 16-Dec-88 25.1 Between 20 and 35
0005 Scot Edenfield 11-Aug-77 36.4 Between 35 and 50
0001 Doreatha Navin 14-May-94 19.6 Less Than 20
0002 Polly Lotts 16-Nov-55 58.2 Between 50 and 65
0003 Patrick Leider 6-Apr-86 27.8 Between 20 and 35
0004 Edra Langer 12-May-73 40.7 Between 35 and 50
0005 Scot Edenfield 28-Mar-56 57.8 Between 50 and 65
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/SovRvrt2jLY

Create the following spreadsheet with the relevant inputs

In the first yellow block, use a VLOOKUP to determine the commision rate to use.
In the second yellow block calculate the commision earned

Sales Band Commision

R0 0.0%
R 5,000 5.0%
R 50,000 6.0%
R 100,000 7.5%
Sales Generated Commision %(VLOOKUP) Commision Earned Answer Should Be
R 4,900 R0.00
R 15,250 R762.50
R 49,000 R2,450.00
R 55,000 R3,300.00
R 110,000 R8,250.00
swer Should Be
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/jYj2UHPNfvg

Create the following spreadsheet with the relevant inputs

In the first yellow block, use a VLOOKUP to determine the interest rate to use.
In the second yellow block calculate the interest earned

Sales BandInterest rate

R0 0.0%
R 5,000 5.0%
R 50,000 6.0%
R 100,000 7.5%
Sales Generated Commision %(V Commision Earned
R 4,900 0.0% R 0.00
R 15,250 5.0% R 762.50
R 49,000 5.0% R 2,450.00
R 55,000 6.0% R 3,300.00
R 110,000 7.5% R 8,250.00
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/zwQs9DFk71c

Per SARS you need to pay the following in taxes depending on your earnings

0- 140 000 18% of taxable income

140 001- 221 000 R25 200 +_ 25% of the amount above R140 000
221 001 - 305 000 R45 450 + 30% of the amount above R221 000
305 001- 431 000 R70 650 + 35% of the amount above R305 000
431 001- 552 000 R114 750 + 38% of the amount above R431 000
552 001 and above R160 730 + 40% of the amount above R552 000

Tax Table that is useful for Excel

Bands Fixed %
0 0 18.0%
140,000 25,200 25.0%
221,000 45,450 30.0%
305,000 70,650 35.0%
431,000 114,750 38.0%
552,000 160,730 40.0%

Amount to
Fixed Calculate % Fixed
Salary Amount % to use Lower limit on % Based Based
65,000.00 65,000.00 0.00 0.00
250,000.00 250,000.00 0.00 0.00
305,000.00 305,000.00 0.00 0.00
306,000.00 306,000.00 0.00 0.00
600,000.00 600,000.00 0.00 0.00

Total should equal

Total Answer Should be
0.00 11,700.00
0.00 54,150.00
0.00 70,650.00
0.00 71,000.00
0.00 179,930.00
0.00
387,430.00
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/JtPzpJhW5II

Per SARS you need to pay the following in taxes depending on your earnings

0- 140 000 18% of taxable income

140 001- 221 000 R25 200 +_ 25% of the amount above R140 000
221 001 - 305 000 R45 450 + 30% of the amount above R221 000
305 001- 431 000 R70 650 + 35% of the amount above R305 000
431 001- 552 000 R114 750 + 38% of the amount above R431 000
552 001 and above R160 730 + 40% of the amount above R552 000

Tax Table that is useful for Excel

Bands Fixed %
0 0 18.0%
140,000 25,200 25.0%
221,000 45,450 30.0%
305,000 70,650 35.0%
431,000 114,750 38.0%
552,000 160,730 40.0%

Amount to
Fixed Calculate Fixed
Salary Amount % to use Lower limit % on % Based Based Total
65,000.00 0.00 18.00% 0.00 65,000.00 11,700.00 0.00 11,700.00
250,000.00 45,450.00 30.00% 221,000.00 29,000.00 8,700.00 45,450.00 54,150.00
305,000.00 70,650.00 35.00% 305,000.00 0.00 0.00 70,650.00 70,650.00
306,000.00 70,650.00 35.00% 305,000.00 1,000.00 350.00 70,650.00 71,000.00
600,000.00 160,730.00 40.00% 552,000.00 48,000.00 19,200.00 160,730.00 179,930.00
387,430.00
Total should equal 387,430.00
Navigation Page QUES: WATCH, LIKE, SUBSCRIBE>> SOL: WATCH, LIKE, SUBSCRIBE>>
https://youtu.be/uOj4vhHNH2o

List 1
Product Sales Results to Pull Through
Sales Person A B C
SP001 446 587 363 SP001 SP0101
SP002 594 151 773 SP002
SP003 626 923 955 SP003
SP004 59 48 419 SP004
SP005 465 391 349 SP005
SP006 203 409 240 SP006
SP007 880 740 739 SP007
SP008 72 617 190 SP008
SP009 464 333 382 SP009
SP010 881 97 905 SP010
SP011 235 372 779 SP0101
SP0101 13 802 991 SP0102
SP0102 826 931 235 SP0103
SP0103 718 7 97 SP0104
SP0104 162 26 518 SP0105
SP0105 587 838 788 SP0106
SP0106 421 980 393 SP0107
SP0107 527 752 963 SP0108
SP0108 40 592 27 SP0109
SP0109 67 61 587 SP011
SP0110 975 831 863 SP0110
CH, LIKE, SUBSCRIBE>> https://youtu.be/Oq7PajSitcA

Results to Pull Through

A B C
881 97 905
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/UKRfaILKMf0
*
?
Full Name Selling Price Also Known As Matching Name
An String 516.00 Lotron Bio Lotron
Bam It 684.00 Voya Voya Siltam
Bam Zumtone 585.00 Saoflex Sub Saoflex
Bio Lotron 665.00 String An String
Dalt Lex 745.00 An String An String
Hot Nix 588.00 Ozer Tip Ozer Tip
Jay Ron 550.00 Red Zap Red Zap
Lam Flex 524.00 Stim Top Stim Top
Med Lax 615.00 Sontam Son Sontam
Ozer Tip 732.00 Jay Ron Jay Ron
ReFind 539.00 Re Find #N/A
Re Finlax 750.00 Bam It Bam It
Red Zap 687.00 Hot Nix Hot Nix
Ron Traxtop 609.00 Med Lax Med Lax
Round Bam 612.00 Sailtex Zum Sailtex
Silver Light 708.00 Joytip Tin Joytip
Silver Touch 596.00 Silver Touch Silver Touch
Son Sontam 566.00 Bam Zumtone Bam Zumtone
Stim Top 705.00 Dalt Lex Dalt Lex
String Eco 744.00 Trans Lex Trans Lex
Sub Saoflex 508.00 Re ReFind
Tin Joytip 628.00 Lam Flex Lam Flex
Trans Lex 657.00 Round Bam Round Bam
Voya Siltam 627.00 Silver Light Silver Light
Zum Sailtex 645.00 Traxtop Ron Traxtop
Sellling Price
665
627
508
516
516
732
687
705
566
550
#N/A
684
588
615
645
628
596
585
745
657
539
524
612
708
609
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/kzfbxuDjwDg
HR System
First Name Surname Employee # Email Address Check
Hamilton Burger 26801
Will Power 59039
Brooke Trout 89820
Anna Sasin 52712
Joy Rider 12133
Hy Ball 78834
Barbara Seville 36353
Mia Hamm 65034
Willie Leak 79596
Terence Booke 37339
Evan Keel 99831
Jack Hammer 97683
Rita Buch 92188
Ali Gaither 35398
Tess Steckle 15026
Lew Ball 98000
April May 20361
Dan Lyons 25616
Les Payne 77171
Rusty Blades 34680
Amber Green 91076
Rhoda Booke 33717
Peter Peed 90046
Lisa Carr 89744
Doris Schutt 35353
Patience Wait 54538
Joy Kil 21810
Crystal Glass 42164
Mona Lott 16712
Gladys Hughes 35309
Marty Graw 30114
Chris Cross 42938
Gil Fish 80203
Mike Lyons 85239
Pepe Roni 66981
Carrie Oakey 82655
Ray Zenz 46897
Bob Apple 37884
Keelan Early 28875
Dusty Carr 80512
Rusty Irons 10754
Ben Marcata 67909
Steven Sumey 73918
Nat Sass 53414
Easton West 62231
Therese Green 34506
Marlon Fisher 71892
Pierce Hart 91427
Luke Warm 86958
IT System
Name Email Address
A. May [email protected]
A. Sasin [email protected]
B. Apple [email protected]
B. Seville [email protected]
Ball, H [email protected]
Booke, R [email protected]
Booke, T [email protected]
Buch, R [email protected]
C. Cross [email protected]
C. Glass [email protected]
C. Oakey [email protected]
D. Carr [email protected]
D. Schutt [email protected]
E. Keel [email protected]
E. West [email protected]
Early, K [email protected]
G. Fish [email protected]
G. Hughes [email protected]
Gaither, A [email protected]
Green, A [email protected]
Green, T [email protected]
L. Ball [email protected]
H. Burger [email protected]
Hamm, M [email protected]
Hammer, J [email protected]
Irons, R [email protected]
J. Rider [email protected]
Kil, J [email protected]
L. Carr [email protected]
L. Warm [email protected]
D. Lyons [email protected]
Lyons, M [email protected]
M. Fisher [email protected]
M. Graw [email protected]
M. Lott [email protected]
Marcata, B [email protected]
P. Hart [email protected]
P. Peed [email protected]
Payne, L [email protected]
Power, W [email protected]
R. Blades [email protected]
Roni, P [email protected]
Sass, N [email protected]
Sumey, S [email protected]
T. Steckle [email protected]
Trout, B [email protected]
W. Leak [email protected]
Wait, P [email protected]
Zenz, R [email protected]
Navigation Page WATCH, LIKE, SUBSCRIBE>> https://youtu.be/kzfbxuDjwDg
HR System
First Name Surname Employee # Email Address Check
Hamilton Burger 26801 [email protected] 1
Will Power 59039 [email protected] 1
Brooke Trout 89820 [email protected] 1
Anna Sasin 52712 [email protected] 1
Joy Rider 12133 [email protected] 1
Hy Ball 78834 [email protected] 2
Barbara Seville 36353 [email protected] 1
Mia Hamm 65034 [email protected] 2
Willie Leak 79596 [email protected] 1
Terence Booke 37339 [email protected] 2
Evan Keel 99831 [email protected] 1
Jack Hammer 97683 [email protected] 1
Rita Buch 92188 [email protected] 1
Ali Gaither 35398 [email protected] 1
Tess Steckle 15026 [email protected] 1
Lew Ball 98000 [email protected] 2
April May 20361 [email protected] 1
Dan Lyons 25616 [email protected] 2
Les Payne 77171 [email protected] 1
Rusty Blades 34680 [email protected] 1
Amber Green 91076 [email protected] 2
Rhoda Booke 33717 [email protected] 2
Peter Peed 90046 [email protected] 1
Lisa Carr 89744 [email protected] 2
Doris Schutt 35353 [email protected] 1
Patience Wait 54538 [email protected] 1
Joy Kil 21810 [email protected] 1
Crystal Glass 42164 [email protected] 1
Mona Lott 16712 [email protected] 1
Gladys Hughes 35309 [email protected] 1
Marty Graw 30114 [email protected] 1
Chris Cross 42938 [email protected] 1
Gil Fish 80203 [email protected] 2
Mike Lyons 85239 [email protected] 2
Pepe Roni 66981 [email protected] 1
Carrie Oakey 82655 [email protected] 1
Ray Zenz 46897 [email protected] 1
Bob Apple 37884 [email protected] 1
Keelan Early 28875 [email protected] 1
Dusty Carr 80512 [email protected] 2
Rusty Irons 10754 [email protected] 1
Ben Marcata 67909 [email protected] 1
Steven Sumey 73918 [email protected] 1
Nat Sass 53414 [email protected] 1
Easton West 62231 [email protected] 1
Therese Green 34506 [email protected] 2
Marlon Fisher 71892 [email protected] 1
Pierce Hart 91427 [email protected] 1
Luke Warm 86958 [email protected] 1
IT System
Name Email Address
A. May [email protected]
A. Sasin [email protected]
B. Apple [email protected]
B. Seville [email protected]
Ball, H [email protected]
Booke, R [email protected]
Booke, T [email protected]
Buch, R [email protected]
C. Cross [email protected]
C. Glass [email protected]
C. Oakey [email protected]
D. Carr [email protected]
D. Schutt [email protected]
E. Keel [email protected]
E. West [email protected]
Early, K [email protected]
G. Fish [email protected]
G. Hughes [email protected]
Gaither, A [email protected]
Green, A [email protected]
Green, T [email protected]
L. Ball [email protected]
H. Burger [email protected]
Hamm, M [email protected]
Hammer, J [email protected]
Irons, R [email protected]
J. Rider [email protected]
Kil, J [email protected]
L. Carr [email protected]
L. Warm [email protected]
D. Lyons [email protected]
Lyons, M [email protected]
M. Fisher [email protected]
M. Graw [email protected]
M. Lott [email protected]
Marcata, B [email protected]
P. Hart [email protected]
P. Peed [email protected]
Payne, L [email protected]
Power, W [email protected]
R. Blades [email protected]
Roni, P [email protected]
Sass, N [email protected]
Sumey, S [email protected]
T. Steckle [email protected]
Trout, B [email protected]
W. Leak [email protected]
Wait, P [email protected]
Zenz, R [email protected]