Spreadsheet: 456678d1460991952-change-row-and-cell-colours-depending-upon-certain-values-case-tracker-template
Sheet: Completed Cases

From | First Name | Last Name | Reference | Face to Face Mtg | Lender | DIP Completed | FMA Completed | Offered Date |  | Suitability Rep Sent | Added to TP and Factfind Done | Submitted | Fee | Fee Rec'd | Proc Fee | Stage | Date of Last Action | Notes
FFS | Col | Turner |  | 2015-06-01 00:00:00 | Nationwide | 2015-06-15 00:00:00 | 2015-09-01 00:00:00 | 2015-11-02 00:00:00 |  | 2015-11-02 00:00:00 | 2015-11-02 00:00:00 | 2015-11-02 00:00:00 | 250 | 2015-12-01 00:00:00 | 445.49
Yaqub | Fiazian | Begum | 70100605 | 2015-06-01 00:00:00 | BM | Done | Done | 2015-10-15 00:00:00 |  | 2015-06-01 00:00:00 | 2015-06-01 00:00:00 | 2015-06-01 00:00:00 | 395 |  | 191.07 | Need Fee from [NAME]?
Reids |  | Hussain | 10/51655504-6 | 2015-06-11 00:00:00 | Halifax | Done | Done | 2015-07-01 00:00:00 |  | Yes | Yes | 2016-01-08 00:00:00 | 250 | 2015-06-20 00:00:00 | 267.75
Reids |  | [NAME] | 788014500 | 2015-06-15 00:00:00 | Natwest | Done | Done | 2015-07-23 00:00:00 |  | Yes | Yes | 2015-07-23 00:00:00 | 250 | 2015-09-02 00:00:00 | 225
Reids | Tasawar & Halima | Bi & Khaliq | 10/51691899 | 2015-06-23 00:00:00 | Halifax | Done | Done | 2015-07-28 00:00:00 |  | 2015-07-21 00:00:00 | 2015-07-21 00:00:00 | 2015-07-21 00:00:00 | 250 | 2015-09-02 00:00:00 | N/a
Reids | Kamran | Rashid | 37606156 | 2015-05-15 00:00:00 | Santander | Done | Done | 2015-06-01 00:00:00 |  | 2015-06-22 00:00:00 | 2015-06-22 00:00:00 | 2016-01-08 00:00:00 | 250 | 2015-06-20 00:00:00
FFS | [NAME] | Thompson | 63548545 | 2015-08-01 00:00:00 | Leeds | 2015-11-11 00:00:00 | 2015-11-19 00:00:00 | 2016-01-29 00:00:00 |  | 2015-12-03 00:00:00 | 2015-12-04 00:00:00 | 2015-12-04 00:00:00 | 395 | 2016-03-18 00:00:00 | 407
Yaqub | Nicola | Jennings |  | 2015-10-01 00:00:00 | Natwest | 2015-10-22 00:00:00 | 2015-11-05 00:00:00 | 2015-12-15 00:00:00 |  | 2015-12-11 00:00:00 | 2015-12-14 00:00:00 | 2016-04-05 00:00:00 | 395 |  | 225 | Need Fee from Yaqub
FFS | Kevin & Sam | Parker | 80752514 | 2015-11-05 00:00:00 | NatWest | 2015-11-15 00:00:00 | 2015-11-19 00:00:00 | 2016-01-04 00:00:00 |  | 2015-12-22 00:00:00 | 2016-01-05 00:00:00 | 2016-01-05 00:00:00 | 395 | 2016-04-05 00:00:00
Reids | [NAME] | Akhtar | 20025225081 | 2016-01-11 00:00:00 | BM | 2016-01-07 00:00:00 | 2016-01-10 00:00:00 | 2016-02-16 00:00:00 |  | 2015-10-29 00:00:00 | 2016-03-10 00:00:00 | 2016-04-06 00:00:00 | 250 | 2016-02-26 00:00:00
Reids | Haroon & Furhana | Adam | 81003987 | 2015-12-17 00:00:00 | Natwest | 2015-12-14 00:00:00 | 2016-01-18 00:00:00 | 2016-02-18 00:00:00 |  | 2016-02-19 00:00:00 | 2016-03-10 00:00:00 | 2016-04-06 00:00:00 | 250 | 2016-02-26 00:00:00 | 288
FFS | Dan & Alice | [NAME] | 9225483334 | 2016-01-08 00:00:00 | Woolwich | 2016-01-25 00:00:00 | 2016-02-10 00:00:00 | 2016-03-01 00:00:00 |  | 2016-03-01 00:00:00 | 2016-03-04 00:00:00 | 2016-04-06 00:00:00 | 200 |  |  | Need Fee from Client
Reids | Ayub & Safira | Rekhad | 80735049 | 2015-11-04 00:00:00 | Natwest | 2015-11-04 00:00:00 | 2015-11-18 00:00:00 | 2016-01-15 00:00:00 |  | 2016-04-06 00:00:00 | 2016-03-15 00:00:00 | 2016-04-06 00:00:00 | 250 | 2015-12-17 00:00:00 | 256
Reids | [NAME] | Cheema | 10/51895770-2 | 2015-12-01 00:00:00 | Halifax | 2016-01-05 00:00:00 | 2016-01-05 00:00:00 | 2016-02-26 00:00:00 |  | 2016-04-06 00:00:00 | 2016-03-14 00:00:00 | 2016-04-06 00:00:00 | 250 | 2016-02-08 00:00:00
Reids | Asif & Fozia | Qureshi | 80942764 | 2015-12-17 00:00:00 | Natwest | 2016-01-05 00:00:00 | 2016-01-05 00:00:00 | 2016-03-08 00:00:00 |  | needs checking | 2016-03-14 00:00:00 | 2016-04-06 00:00:00 | 250 | 2016-02-08 00:00:00 | 400
Reids | Naheed | Akhtar | 81047985 | 2016-01-18 00:00:00 | Natwest | 2016-01-13 00:00:00 | 2016-01-21 00:00:00 | 2016-02-18 00:00:00 |  | needs checking | 2016-03-11 00:00:00 | 2016-04-06 00:00:00 | 250 | 2016-02-26 00:00:00
Yaqub | Farooq | Udden | 81157189 | 2015-10-06 00:00:00 | Natwest | 2015-10-12 00:00:00 | 2015-10-19 00:00:00 | 2016-03-24 00:00:00 |  | 2016-03-17 00:00:00 | 2016-03-15 00:00:00 | 2016-04-07 00:00:00 | 395 | 2016-04-04 00:00:00
Yaqub | Wajid & Khatoon | Shaheen & Bi | 80392725 | 2015-09-22 00:00:00 | Natwest | 2015-09-23 00:00:00 | 2015-11-01 00:00:00 | 2015-11-15 00:00:00 |  | 2015-10-30 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 395 | 2016-02-01 00:00:00 | 256
 |  |  |  |  |  |  |  |  |  |  |  | Total |  | Total
 |  | *[NAME] When Mortgage Has Been Offered, Report Sent and Submission but keep fee columns in Red until received