Spreadsheet: 525265d1498650229-cell-populated-w-character-depending-on-other-cell-value-w-superseeding-capability-template-v3-blank-data
Sheet: Example 1; No superseeding

 | 22/6/17 | (A) Continue to deliver with normal assurance | In Place? |  | (B) Continue to deliver with enhanced assurance | In Place? |  | (C) Immediate action required before being allowed to proceed with recruitment | In Place? |  | (D) Cannot continue to deliver and remove from the | In Place? |  | SNAM Recommendation |  |  | Policy |  | 10
 | Early Delivery |  | Y |  |  | Y |  |  | Y |  |  | N |  | Action Plan breakdown & Recommendation |  |  | Delivery Capability |  | 8
 |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  |  |  | Data |  | 2
 |  |  |  |  |  | Y |  |  | Y |  |  | Y
 |  |  |  |  |  | Y |  |  | Y |  |  | Y
 |  |  |  |  |  | Y |  |  | Y
 |  |  |  |  |  | Y |  |  | Y
 |  |  |  |  |  | Y
 |  |  |  |  |  | Y
 | Total Criteria in Place |  |  |  |  |  |  |  |  |  |  | 4
 | Notes
 | Action Plan | No Action Required |  |  | 2017-06-22 00:00:00 |  |  | 2017-06-22 00:00:00 |  |  | 2017-06-22 00:00:00 |  |  | 2017-06-22 00:00:00
 |  |  |  |  | Provider has proposed an action plan: | Desired Outcome |  | Provider has proposed an action plan: | Desired Outcome |  | Provider has proposed an action plan: | Desired Outcome |  | Provider has proposed an action plan:
 |  |  |  |  | Step 1 |  |  | Step 1 |  |  | Step 1 |  |  | Step 1
 |  |  |  |  | Step 2 |  |  | Step 2 |  |  |  |  |  | Step 2
 |  |  |  |  | Step 3 |  |  | Step 3 |  |  |  |  |  | Step 3
 |  |  |  |  | Date for action plan completion: | 2017-08-03 00:00:00 |  | Date for action plan completion: | 2017-08-03 00:00:00 |  | Date for action plan completion: | 2017-08-03 00:00:00 |  | Date for action plan completion:
 | Delivery | -   The provider is using funds in accordance with our contracts. |  |  | -   Some apprentices are not employed and do not have an apprenticeship agreement | - |  | -       Significant numbers of apprentices not employed and do not have an apprenticeship agreement |  |  | (D) Cannot continue to deliver and remove from the RoATP
 |  |  |  |  | -   Some apprentices are not covered by a contract for services/commitment statement between the provider and employer |  |  | -       Significant numbers of apprentices are not covered by a contract for services/commitment statement between the provider and employer |  |  | -   Data entry / ILR measures described in RoATP not in place (CA-07a)
 |  |  |  |  | -   Some off-the-job training not evidenced or planned |  |  | -       Significant off-the-job training not evidenced or planned |  |  | -   Where new financial statements are available and are below the specified level (see financial health review process)
 |  |  |  |  | -   Data sample showed some inaccuracies between evidence and data submitted |  |  | -       Data sample showed signifcant inaccuracies between evidence and data submitted |  |  | -   No awarding body in place
 |  |  |  |  | -   Evidence suggests funds are being used for ineligible costs |  |  | -       Delivery subcontractors being used that are not on RoATP / subcontractor declaration |  |  | -   No delivery structure (including qualified trainers and assessors) in place for the apprenticeships to be delivered
 |  |  |  |  |  |  |  | CATEGORY OF PROVIDER | A
 |  | http://www.excelforum.com/excel-formulas-and-functions/1190737-cell-populated-w-character-depending-on-other-cell-value-w-superseeding-capability.html#post4685134