Spreadsheet: 701489d1603794468-vlookup-to-different-sheet-bid-progress
Sheet: Asbestos

 |  |  | = Signed School |  | = Confirmed project
 |  |  | = NOT yet signed |  | = Confirmed RESUBMIT
 |  |  | = NOT signed but progress |  | = Confirmed RESUBMIT - Phase 2 part written
 |  |  |  |  | = Confirmed RESUBMIT - TENDERED
 |  |  |  |  | = TBC
 |  |  |  |  | = Awaiting Appeal / Resubmit
 |  |  |  |  | = Awaiting Appeal / Resubmit TENDERED
ROW | APPLICATION DETAILS
 |  |  |  |  |  |  |  |  | Existing R&D Surveys |  |  |  | (Need back by the Friday 16th Oct) |  |  |  |  |  |  | Ideally both at same time
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] normal hrs see quote for w'end hrs |  | Qualserve Quote
DO NOT DELETE | Bid Writer | Lead | School | code | Bid | code | Est £ | New Asbstos Brief Required / Not Required or Previously Done | Bid Resubmit   (Existing R&D Survey Exists Specific to the Bid) | Report Ref (Bid Writer to Check Sufficient) | Asbestos Brief Complete and passed onto ST | Asbestos Brief Issued to WES & Qualserve | Normal Hrs | Weekend Hrs | Normal Hrs | Weekend Hrs | Instruction Given to (WES or Qualserve) | School October half-term holidays (1 WEEK) Week Comencinjg | Appointment discussed / agreed with School | Date Survey Booked in For | Roofing Survey Date
 |  |  |  |  |  |  |  | Done | Yes | CARTWRIGHT BLOCK ONLY LK - LP17 00281 (Nov 2017) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding
 |  |  |  |  |  |  |  | Done | Yes | ? | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | [NAME] sorted | [NAME] (7/10) | 1600 |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding
 |  |  |  |  |  |  |  | Done | Yes | LK - LP17 00282 (Nov 2017)  Shield On Siet Services - S14 01661 (Jul 2014) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | WSP - 70065026 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (7/10) |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | ? | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Awaiting school if bid or not |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (7/10) |  |  | 745 |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (12/10) |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Qualsurv - Q-00900 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Qualsurv - Q 00900 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | [NAME] (July 2019) | N/A? | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-19 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (7/10) |  |  | 745 |  |  | 2020-10-19 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | [NAME] (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (12/10)
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (12/10)
 |  |  |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A
 |  |  |  |  |  |  |  | Brief not required | Brief not required | Brief not required | Brief not required |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (7/10) | 285 |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | WES - P -26527 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (7/10) |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | WSP - 70065022 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Amicus - S12969 (Nov 209) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Amicus - S12968 V3 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | [NAME] sorted |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Qualserve 11/ 19 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | WSP - 70052635 (Nov 2018) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (12/10)
 |  |  |  |  |  |  |  | Done | Yes | AEC - J100206 (Dec 2017) | N/A | Qual (7/10) |  |  | 745 |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Qualsurv - Q 00904 (Oct 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | WSP - 70039795 (Nov 2017) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-19 00:00:00
 |  |  |  |  |  |  |  | Not required | N/A | N/A | SJ advised one not required |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Ceiling Voids WES - P 24000A (May 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Several Reports (see - Y:\Minsthorpe Academy\Asbestos\WSP Survey Oct 19) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | ? | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | ? | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (7/10) | school sent report |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | ? | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00 | N/A | N/A | N/A
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (7/10) |  |  | 795 |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (8/10) |  |  | 755 |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | WES - P-26737 Dec 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | N/A | No longer a bid | N/A | N/A |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | Qualsurv - Q 00902 (Nov 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (7/10) |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Done | Yes | ? | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Scope not agreed |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (7/10) | 285
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | Qual (8/10) |  |  | 1510
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding
 |  |  |  |  |  |  |  | Done | Yes | Qualsurv - Q 00906 (Oct 2019) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Awaiting school if bid or not |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | Yes | [NAME] (7/10) | 300 |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | yes | N/A | N/A | yes | Qual (12/10) |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | n/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00