Spreadsheet: 873777d1720347818-creating-a-list-from-between-2-dates-dean-gilgrist-sample
Sheet: LEADBANK

Leadbank |  |  |  |  |  |  |  |  |  |  | ex VAT |  |  |  | inc VAT
Customer | Reference | Lead Week | Source | Plan Week | Quote Week | Product 1 Paid | Product 2 Paid | Fit 1 Paid | Fit 2 Paid | Follow Up | Product Value | Product Cost | Fit Value | Fit Cost | Product 1 | Fit 1 | Product 1 | Fit 1 | Product 2 | Fit 2
(Customer Details) |  |  |  |  |  |  |  |  |  | (Notes)
[NAME] | Kitchen | [NAME] | Recommend | N/A | [NAME] | N/A | 2024-01-15 00:00:00 | N/A | 2024-01-15 00:00:00 | 2024-01-15 00:00:00 | 33 | 33 | 1400 | 1400 | 0 | 0 | 0 | 0 | 33 | 1400
[NAME] * | Flooring | [NAME] | Direct Contact | N/A | 1 | N/A | N/A | N/A | 2024-01-19 00:00:00 | 2024-01-19 00:00:00 | 0 | 0 | 333 | 0 | 0 | 0 | 0 | 0 | 0 | 333
[NAME] | Repairs | 1 | Recommend | N/A | 1 | N/A | N/A | N/A | 2024-01-23 00:00:00 | 2024-01-23 00:00:00 | 0 | 0 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 250
[NAME] * | Master & Casper | [NAME] | Direct Contact | [NAME] | [NAME] | 2023-11-29 00:00:00 | 2023-12-12 00:00:00 | N/A | 2024-01-28 00:00:00 | 2024-01-28 00:00:00 | 5016 | 2638 | 933 | 700 | 1428 | 0 | 1190 | 0 | 3826 | 933
[NAME] * | Master [NAME] | [NAME] | Direct Contact | [NAME] | [NAME] | 2024-01-05 00:00:00 | 2024-01-28 00:00:00 | N/A | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2048 | 1421 | 600 | 70 | 636 | 0 | 530 | 0 | 1518 | 600
[NAME] | Wk 4 | [NAME] | Direct Contact | N/A | 2 | N/A | N/A | 2024-02-02 00:00:00 | 2024-02-09 00:00:00 | 2024-02-09 00:00:00 | 0 | 0 | 1800 | 0 | 0 | 1800 | 0 | 1500 | 0 | 300
[NAME] | Boxing | 6 | Direct Contact | N/A | 6 | N/A | 2024-02-10 00:00:00 | N/A | 2024-02-10 00:00:00 | 2024-02-10 00:00:00 | 50 | 41 | 200 | 0 | 0 | 0 | 0 | 0 | 50 | 200
[NAME] | Wk 6 | 3 | Direct Contact | N/A | 6 | N/A | N/A | N/A | 2024-02-16 00:00:00 | 2024-02-16 00:00:00 | 0 | 0 | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 200
[NAME] | Wk 6 | 5 | Recommend | N/A | 6 | N/A | N/A | N/A | 2024-02-16 00:00:00 | 2024-02-16 00:00:00 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 400
[NAME] * | Master [NAME] | 1 | Direct Contact | 1 | 1 | 2024-01-07 00:00:00 | 2024-02-16 00:00:00 | N/A | 2024-02-21 00:00:00 | 2024-02-21 00:00:00 | 1835 | 0 | 700 | 70 | 626 | 0 | 522 | 0 | 1313 | 700
Adam | Airing | [NAME] | Direct Contact | 3 | 4 | 2024-02-07 00:00:00 | 2024-02-13 00:00:00 | N/A | 2024-03-11 00:00:00 | 2024-03-11 00:00:00 | 874 | 0 | 620 | 120 | 359 | 0 | 299 | 0 | 575 | 620
[NAME] | Wk 9 | 6 | Direct Contact | N/A | 9 | N/A | N/A | N/A | 2024-03-15 00:00:00 | 2024-03-15 00:00:00 | 0 | 0 | 350 | 0 | 0 | 0 | 0 | 0 | 0 | 350
[NAME] * | Master [NAME] | [NAME] | Website | [NAME] | [NAME] | 2023-11-05 00:00:00 | 2024-03-10 00:00:00 | N/A | 2024-03-21 00:00:00 | 2024-03-21 00:00:00 | 4207 | 0 | 850 | 100 | 1214 | 0 | 1012 | 0 | 3195 | 850
Maskell & Josephson | Kitchen | 3 | Recommend | 6 | 7 | 2024-02-22 00:00:00 | 2024-03-16 00:00:00 | N/A | 2024-03-25 00:00:00 | 2024-03-25 00:00:00 | 2088 | 0 | 762 | 0 | 684 | 0 | 570 | 0 | 1518 | 762
Maskell & Josephson | Showroom | 3 | Recommend | 7 | 8 | 2024-02-22 00:00:00 | 2024-03-02 00:00:00 | N/A | 2024-03-25 00:00:00 | 2024-03-25 00:00:00 | 3100 | 0 | 850 | 0 | 949 | 0 | 791 | 0 | 2309 | 850
Geo & Jen | Master [NAME] | 7 | Recommend | 8 | 11 | 2024-03-13 00:00:00 | 2024-03-25 00:00:00 | N/A | 2024-03-28 00:00:00 | 2024-03-28 00:00:00 | 1336 | 0 | 450 | 0 | 425 | 0 | 354 | 0 | 982 | 450
Geo & Jen | Kitchen | 6 | Recommend | N/A | 7 | N/A | N/A | 2024-04-04 00:00:00 | 2024-04-04 00:00:00 | 2024-04-04 00:00:00 | 20 | 0 | 1925 | 0 | 0 | 0 | 0 | 0 | 20 | 1925
Maskell & Josephson | [NAME] | 11 | Direct Contact | N/A | 13 | N/A | N/A | 2024-04-06 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 197 | 0 | 350 | 0 | 0 | 0 | 0 | 0 | 197 | 350
[NAME] | Wk 15 | 12 | Direct Contact | N/A | 15 | N/A | N/A | N/A | 2024-04-19 00:00:00 | 2024-04-19 00:00:00 | 0 | 0 | 2100 | 0 | 0 | 0 | 0 | 0 | 0 | 2100
Clare | Porch & Understairs | 6 | Website | 8 | 8 | 2024-02-26 00:00:00 | 2024-04-14 00:00:00 | 2024-04-14 00:00:00 | 2024-04-24 00:00:00 | 2024-04-24 00:00:00 | 1529 | 0 | 1150 | 0 | 685 | 205 | 571 | 171 | 959 | 979
[NAME] | Kitchen | 14 | Recommend | N/A | 14 | N/A | N/A | N/A | 2024-04-30 00:00:00 | 2024-04-30 00:00:00 | 0 | 0 | 1750 | 0 | 0 | 0 | 0 | 0 | 0 | 1750
Maskell & Josephson | Backboard | 17 | Direct Contact | N/A | 18 | N/A | 2024-05-01 00:00:00 | N/A | 2024-05-01 00:00:00 | 2024-05-02 00:00:00 | 197 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 197 | 100
[NAME] | Alcoves | 10 | Facebook | 11 | 13 | 2024-04-04 00:00:00 | 2024-04-29 00:00:00 | N/A | 2024-05-03 00:00:00 | 2024-05-03 00:00:00 | 829 | 0 | 550 | 0 | 331 | 0 | 276 | 0 | 553 | 550
[NAME] | Wtops | 6 | Recommend | N/A | 8 | 2024-02-27 00:00:00 | 2024-04-26 00:00:00 | N/A | 2024-05-14 00:00:00 | 2024-05-13 00:00:00 | 624 | 0 | 800 | 0 | 349 | 0 | 291 | 0 | 333 | 800
[NAME] | Utility | 14 | Direct Contact | 14 | 16 | 2024-04-29 00:00:00 | 2024-05-05 00:00:00 | N/A | 2024-05-15 00:00:00 | 2024-05-14 00:00:00 | 1347 | 0 | 1186 | 0 | 600 | 0 | 500 | 0 | 847 | 1186
[NAME] | [NAME] | 14 | Direct Contact | 17 | 17 | 2024-05-13 00:00:00 |  |  |  | 2024-05-28 00:00:00 | 2109 | 0 | 1150 | 100 | 783 |  | 653 | 0 | 1456 | 1150
[NAME] | [NAME] | 14 | Direct Contact | 17 | 20 | 2024-05-13 00:00:00 |  |  |  | 2024-05-28 00:00:00 | 4068 | 0 | 1470 | 100 | 1519 |  | 1266 | 0 | 2802 | 1470
[NAME] | Master [NAME] | 18 | Direct Contact | [NAME] | 19 | 2024-05-08 00:00:00 | 2024-05-24 00:00:00 | N/A | 2024-05-30 00:00:00 | 2024-05-30 00:00:00 | 1121 | 0 | 625 | 0 | 420 | 0 | 350 | 0 | 771 | 625
[NAME] | Wk 22 | 20 | Direct Contact | N/A | 22 | N/A | N/A | N/A | 2024-06-07 00:00:00 | 2024-06-07 00:00:00 | 0 | 0 | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 1400
[NAME] | Wk 24 | 24 | Direct Contact | N/A | 24 | N/A | N/A | N/A | 2024-06-14 00:00:00 | 2024-06-14 00:00:00 | 0 | 0 | 750 | 600 | 0 | 0 | 0 | 0 | 0 | 750
[NAME] | Utility | 15 | Recommend | 16 | 18 | 2024-05-19 00:00:00 | 2024-06-14 00:00:00 | N/A | 2024-06-18 00:00:00 | 2024-06-18 00:00:00 | 1523 | 0 | 975 | 0 | 600 | 0 | 500 | 0 | 1023 | 975
[NAME] | Master [NAME] | 23 | Direct Contact | 25 |  |  |  |  |  | 2024-06-24 00:00:00
[NAME] | Kitchen | 18 | Google | 21 | 19 | 2024-06-04 00:00:00 | 2024-06-06 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 2024-06-26 00:00:00 | 5969 | 3558 | 1926 | -10 | 1771 | 2172 | 1476 | 1810 | 4493 | 116
[NAME] | Flooring 2 | 26 | Direct Contact | N/A | 26 | 2024-06-26 00:00:00 | 2024-06-26 00:00:00 | N/A | N/A | 2024-06-26 00:00:00 | 1422 | 1030 | 0 | 0 | 0 | 0 | 0 | 0 | 1422 | 0
Cheshire Marble | Hocking | 22 | Direct Contact | N/A | 22 | N/A | N/A | N/A | 2024-06-27 00:00:00 | 2024-06-27 00:00:00 | 0 | 0 | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 200
Kath & Glynn Jones | [NAME] | 16 | Recommend | N/A | 17 | N/A | 2024-06-28 00:00:00 | 2024-06-08 00:00:00 | 2024-06-28 00:00:00 | 2024-06-28 00:00:00 | 362 | 163 | 875 | 0 | 0 | 1046 | 0 | 871 | 362 | 4
[NAME] | Kitchen | 22 | Recommend | 24 | 25 |  |  |  |  | 2024-07-02 00:00:00 | 5619 | 3499 | 2030 | 0 |  |  | 0 | 0 | 5619 | 2030
[NAME] | Girls Room | 23 | Direct Contact | 25 | 26 | 2024-07-02 00:00:00 |  |  |  | 2024-07-04 00:00:00 | 2394 | 1320 | 800 | 0 | 767 |  | 639 | 0 | 1754 | 800
[NAME] | Media Wall | 18 | Google | 19 | 20 | 2024-05-19 00:00:00 | 2024-06-17 00:00:00 |  |  | 2024-07-05 00:00:00 | 2246 | 1177 | 800 | 0 | 732 |  | 610 | 0 | 1636 | 800
[NAME] | Flooring | 19 | Direct Contact | N/A | 23 | 2024-06-06 00:00:00 | 2024-06-17 00:00:00 |  |  | 2024-07-05 00:00:00 | 1351 | 1228 | 700 | 0 | 493 |  | 411 | 0 | 940 | 700
Kathy | Kitchen | 25 | Recommend |  |  |  |  |  |  | 2024-07-05 00:00:00
[NAME] | Utility | 23 | Direct Contact | 23 |  |  |  |  |  | 2024-07-05 00:00:00 | 1071 | 679 | 250 | 25
[NAME] | Sample Stand | 23 | Direct Contact | 23 | 23 | N/A | 2024-07-05 00:00:00 | N/A | N/A | 2024-07-05 00:00:00 | 686 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 686 | 0
[NAME] | Media Wall | 4 | Recommend | 12 | 24 | 2024-06-14 00:00:00 |  |  |  | 2024-07-06 00:00:00 | 1562 | 942 | 800 | 0 | 567 |  | 473 | 0 | 1089 | 800
Martina | Under Stairs | 24 | Recommend |  |  |  |  |  |  | 2024-07-06 00:00:00
Dave & Dawn Currie | Walk In | 18 | Direct Contact | 23 | 26 | 2024-07-04 00:00:00 |  |  |  | 2024-07-07 00:00:00 | 4109 | 2334 | 880 | 0 | 1198 |  | 998 | 0 | 3111 | 880
[NAME] | Bedroom | 4 | Direct Contact | 20 | 22 | 2024-06-21 00:00:00 |  |  |  | 2024-07-07 00:00:00 | 1208 | 623 | 0 | 0 | 290 |  | 242 | 0 | 966 | 0
[NAME] | Eliza & Ezme | 10 |  | 14 |  |  |  |  |  | 2024-07-07 00:00:00
[NAME] | Skirts & Arcs | 26 | Direct Contact | N/A | 27 | N/A |  |  |  | 2024-07-07 00:00:00 | 696 | 504 | 0 | 0 |  |  | 0 | 0 | 696 | 0
Clare | Daughter | 18 | Direct Contact | 20 | 20 | 2024-06-02 00:00:00 | 2024-07-04 00:00:00 |  |  | 2024-07-09 00:00:00 | 2417 | 977 | 975 | 0 | 815 |  | 679 | 0 | 1738 | 975
Hooshyar | Master & Man Cave | 27 | Recommend |  |  |  |  |  |  | 2024-07-10 00:00:00
[NAME] | Master [NAME] | 23 | Recommend | 26 | 26 | 2024-07-02 00:00:00 |  |  |  | 2024-07-10 00:00:00 | 2565 | 1127 | 900 | 0 | 832 |  | 693 | 0 | 1872 | 900
Tyrone Fitzgerald | Boiler Housing | 23 | Recommend |  |  |  |  |  |  | 2024-07-11 00:00:00
[NAME] Long Lane |  | 22 | Direct Contact | N/A | 27 | N/A |  |  |  | 2024-07-12 00:00:00 | 0 | 0 | 1225 | 0 |  |  | 0 | 0 | 0 | 1225
Lynsey Evans | Sons Room | 21 |  | 23 | 23 |  |  |  |  | 2024-07-17 00:00:00 | 1251 | 533 | 800 | 0 |  |  | 0 | 0 | 1251 | 800
[NAME] | Rostherne Close | 23 | Direct Contact |  |  |  |  |  |  | 2024-07-17 00:00:00
[NAME] | Long Lane | 23 | Direct Contact |  |  |  |  |  |  | 2024-07-17 00:00:00
[NAME] | Master [NAME] | 17 | Google | 19 | 21 |  |  |  |  | 2024-07-22 00:00:00 | 3096 | 1907 | 1150 | 0 |  |  | 0 | 0 | 3096 | 1150
[NAME] | Master [NAME] | 23 | Google | 25 | 25 |  |  |  |  | 2024-07-28 00:00:00 | 852 | 471 | 450 | 0 |  |  | 0 | 0 | 852 | 450
Paula & David Lang | Master [NAME] | 16 | Recommend | 21 | 24 | 2024-06-14 00:00:00 |  |  |  | 2024-08-18 00:00:00 | 3830 | 2341 | 1150 | 0 | 1196 |  | 997 | 0 | 2833 | 1150