{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Cover Page","Version Control & Certification","Contents","1a - Operation Detail","1b - Mgmnt Operation (W-A)","2 - Action Points","3 - LP Checks","4 - Operation Checks","5 - Finance & Declaration","6a - Recipient - ESF","6b - Non Recipient - ESF","7a - Recipient - ERDF","7b - Non Recipient - ERDF","8 - Results","9 - Procurement","10 - State Aid Checks","11 - Horizontal Themes","12 - Further Checks","13 - Staff Interviews","14 - MA Pre-Visit Checklist"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,1,31,9],[32,1,32,9],[33,1,33,9],[30,1,30,9],[24,0,24,13],[28,1,28,9],[29,1,29,9],[11,0,11,13],[12,0,12,13],[15,0,15,13],[16,0,16,13],[17,0,17,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["European Structural and Investment Funds"]
["2014-2020 Programmes"]
[]
[]
["Article 125 (5)(b) On the Spot Verifications of Operations"]
[]
["Stage 2: Post-Payment Verification Check "]
[]
[]
[]
[]
[]
["INTRODUCTION"]
["The Stage 2 On-the-Spot Check is undertaken in accordance with section 2.2.3.6 of the MA’s Management and Control System.  These visits have been designed to meet Key Requirement 4 of the MCS as detailed in Annex 1 of the attached EC guidelines \n\nhttp://ec.europa.eu/regional_policy/sources/docgener/informat/2014/guidance_common_mc assessment_en.pdf\n\nThe visit will be carried out when at least one claim per operation has been paid, and through this the risks associated with the operation been considered. The visit will include some further high level checks of Lead Partner’s systems and processes for managing operations following on from the Stage 1 systems check previously concluded. This template questionnaire will form the backbone of the visit which will also include interviews with staff whose salaries are funded through the operation.  Further visits may be required depending on the remit and scale of the Operation. The need for such a visit will be at the discretion of the MA’s Senior Portfolio and Compliance Manager for the Operation. In operations for infrastructure delivery that span a number of years, further on-the-spot visits are likely, including one at completion to verify the physical presence of the infrastructure. These will follow the same format as the first Stage 2 On-the-Spot visit.  The MA will do a small additional cost check, along with some additional output and result checks, as necessary.  \n"]
[]
["KEY REQUIREMENT"]
[]
["KR1","Adequate separation of functions"]
["KR3","Adequate information to beneficiaries"]
["KR4","Adequate management verifications"]
["KR5","Effective system in place to ensure that all documents regarding expenditure and audits are held to ensure an adequate audit trail"]
["KR6","Reliable system for collecting, recording and storing data for monitoring, evaluation, financial management, verification and audit purposes, including links with electronic data exchange systems with beneficiaries"]
["KR7","Effective implementation of proportionate anti-fraud measures"]

{"sheet":"Version Control & Certification","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,0,25,0],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3],[15,4,17,4],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[30,0,31,0],[30,3,31,3],[30,1,31,1],[30,2,31,2],[30,4,31,4],[26,0,27,0],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4]]}
["Article 125 (5)(b) Template - Version Control"]
[]
["Date","Issue","Change Made","Author"]
["2016-06-01",1,"First issue at Designation","David Anderson"]
["2017-09-01",1.1000000000000001,"Updates for Annual Review","Isobel McNeil"]
["2018-01-15",1.2,"Further Updates for Annual Review","Tracey Gillon"]
["2018-01-19",2,"Issued","Tracey Gillon"]
["2018-04-19",2.1,"Changes to form following pilot visits","T Gillon, A Cumming, S Kettings, K Robertson, J Findlay, E Steele, F Ainslie"]
["2018-06-07",3,"Issued","Tracey Gillon"]
["2019-09-22",3.1,"Change to Macro for section 3 LP Checks & Adding a field for Date of Wash-Up Meeting","Tracey Gillon"]
["2019-09-23",4,"Issued","Tracey Gillon"]
[]
["Certification"]
[]
[]
[null,"Name","Job Title","Signature","Date"]
[]
[]
["Lead Officer"]
[]
["Visiting Officer"]
[]
["Visiting Officer"]
[]
["Procurement Manager (W/A)"]
[]
["PCM From GT"]
[]
[]
[]
["SPCM Review"]

{"sheet":"Contents","index":2,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["REPORT CONTENTS"]
[]
[1,"a) Main Details - Delivery Operation"]
[null,"b) Main Details - LP Management Operation (Where Applicable)"]
[2,"Action Points Summary"]
[3,"Lead Partner Checks"]
[4,"Operation Checks"]
[5,"Financial Management & Declaration of Expenditure"]
[6,"a) Recipient Analysis & Records - ESF (Where Applicable)"]
[null,"b) Non Recipient Analysis & Records - ESF (Where Applicable)"]
[7,"a) Recipient  Analysis & Records - ERDF (Where Applicable)"]
[null,"b) Non Recipient Analysis & Records - ERDF (Where Applicable)"]
[8,"Results"]
[9,"Procurement Checks (Where Applicable)"]
[10,"State Aid Checks"]
[11,"Horizontal Themes"]
[12,"Further Checks - Publicity, Evaluations, Good Practice"]
[13,"Staff Interviews (MA Copy Only)"]
[14,"MA Pre-Meeting Checklist (MA Copy Only)"]

{"sheet":"1a - Operation Detail","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,6,9,7],[9,2,9,3],[42,0,42,6],[43,0,46,6],[33,7,35,7],[24,0,24,7],[33,5,35,5],[33,6,35,6],[25,1,25,3],[26,1,26,3],[33,0,35,0],[32,5,32,7],[32,0,32,3],[33,3,35,3],[33,1,35,1],[33,2,35,2],[0,0,0,7],[2,0,2,7],[4,1,4,7],[5,1,5,7],[8,1,8,7],[6,1,6,7],[7,1,7,7],[16,8,16,9],[16,5,16,6],[17,5,17,6],[16,1,16,3],[17,1,17,3],[28,1,28,3],[26,5,26,7],[27,5,27,7],[28,5,28,7],[25,5,25,7],[27,1,27,3]]}
["1a.   MAIN DETAIL - DELIVERY OPERATION"]
[]
["1.1   Operation Detail - This section will be pre-populated by Admin"]
[]
["Lead Partner:"]
["SI Title:"]
["Operation Title:"]
["EUMIS Reference:"]
["Programme:"]
["Programme Area:",null,"Is there an associated LP Management Cost Operation (If Yes, See Section 1b)",null,null,"Operation Type"]
[]
["Start Date:",null,"Physical End Date:",null,"Financial End Date:"]
[]
["Approved Expenditure:",null,"Approved Grant:"]
["Approved Match:",null,"Intervention Rate:"]
[]
["Date of Stage 1 Pre-Claim Visit (where applicable):",null,null,null,"Any Outstanding Actions from Stage 1 Check",null,null,"If yes, refer to 3.2"]
["Date Offer(s) Issued:",null,null,null,"Any Conditions of Offer(s):",null,null,"If yes, refer to 3.3"]
[]
["1.2   Visit Detail - This section will be pre-populated by Admin"]
[]
["Visit Start Date:",null,"Date of Wash-up Meeting with LP",null,"Completion Date:"]
["Financial Check Obj ID:",null,"File (Achievement) Check Obj ID:",null,"Procurement Check Required"]
[]
["Non MA Attendees (Lead Partner/Delivery Agent/Other)"]
["Name:",null,null,null,"Organisation & Job Title:"]
["Name:",null,null,null,"Organisation & Job Title:"]
["Name:",null,null,null,"Organisation & Job Title:"]
["Name:",null,null,null,"Organisation & Job Title:"]
[]
["1.3   Claim Detail - This section will be pre-populated by Admin"]
[]
["Claim Information as at <Insert date sample created>",null,null,null,null,"Stage 2 Findings"]
["Claim Number","Expenditure \nIn Claims","Grant Paid","Date Paid by SG",null,"Expenditure \nChecked","Irregular Expenditure Found","Error Rate"]
[]
[]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$f":"G37/F37","v":{"$error":"#DIV/0!"}}]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$f":"G38/F38","v":{"$error":"#DIV/0!"}}]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$error":"#DIV/0!"}]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"SUM(B37:B40)","v":0},{"$f":"SUM(C37:C40)","v":0},null,null,{"$f":"SUM(F37:F40)","v":0},{"$f":"SUM(G37:G40)","v":0},{"$f":"AVERAGE(H37:H40)","v":{"$error":"#DIV/0!"}}]
[]
["LEAD OFFICER COMMENTS - DELIVERY OPERATION"]

{"sheet":"1b - Mgmnt Operation (W-A)","index":4,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,0,61,7],[62,0,65,7],[8,2,8,3],[8,6,8,7],[12,5,12,7],[13,5,13,7],[28,6,30,6],[28,7,30,7],[37,0,37,6],[46,0,49,6],[27,0,27,3],[27,5,27,7],[28,0,30,0],[28,1,30,1],[28,2,30,2],[28,3,30,3],[0,0,0,7],[2,0,2,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[17,1,17,3],[17,5,17,6],[18,1,18,3],[18,5,18,6],[28,5,30,5],[56,0,56,6],[57,0,59,6],[38,0,41,6],[43,4,43,7],[44,5,44,7],[43,0,43,3],[44,1,44,3],[45,0,45,6],[51,0,51,7],[52,0,54,7],[50,0,50,6]]}
["1b.   MAIN DETAIL - LP MANAGEMENT OPERATION"]
[]
["1.1   Operation Detail - This section will be pre-populated by Admin"]
[]
["Lead Partner:"]
["SI Title:"]
["Operation Title:"]
["EUMIS Reference:"]
["Programme",null,"Programme Area:"]
[]
["Start Date:",null,"Physical End Date:",null,"Financial End Date:"]
[]
["Approved Expenditure:",null,"Approved Grant:"]
["Approved Match:",null,"Intervention Rate:"]
[]
["Match Received (as at date of arrangement of visit)"]
[]
["Date of Stage 1 Pre-Claim Visit:",null,null,null,"Any Outstanding Actions from Stage 1",null,null,"If yes, refer to 3.2"]
["Date Offer(s) Issued:",null,null,null,"Any Conditions of Offer(s):",null,null,"If yes, refer to 3.3"]
[]
["1.2   Visit Detail - This section will be pre-populated by Admin"]
[]
["Start Visit Date:",null,"Completion Visit Date:"]
["Financial Check Obj ID:"]
[]
["1.3   Claim Detail - This section will be pre-populated by Admin"]
[]
["Claim Information as at <Insert date sample created>",null,null,null,null,"Stage 2 Findings"]
["Claim Number","Expenditure \nIn Claims","Grant Paid","Date Paid by SG",null,"Expenditure \nChecked","Irregular Expenditure Found","Error Rate"]
[]
[]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$f":"G32/F32","v":{"$error":"#DIV/0!"}}]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$f":"G33/F33","v":{"$error":"#DIV/0!"}}]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$error":"#DIV/0!"}]
["<Insert EUMIS Claim No.>","<From EUMIS>","<From EUMIS>","<From EUMIS>",null,null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"SUM(B32:B35)","v":0},{"$f":"SUM(C32:C35)","v":0},null,null,{"$f":"SUM(F32:F35)","v":0},{"$f":"SUM(G32:G35)","v":0},{"$f":"AVERAGE(H32:H35)","v":{"$error":"#DIV/0!"}}]
[]
["1.4  Have any of the timescales changed?\nIf so, what were the reasons for the change, and have these been subject to a formal change request?",null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["Estimated Forecast Spend to date \n(at time of arrangement of the visit)",null,null,null,"Actual claimed \n(at time of arrangement of the visit)"]
["Total","Pre-populated by Admin",null,null,"Total","Pre-populated by Admin"]
["1.5 Has the profile changed/likely to change, and has this been subject to a formal change request?  ",null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
["*The forecast spend is provided per year not per month so is estimated based on the date of visit."]
["1.6   How have you ensured the Management Costs are in-line with the delivery operation?"]
[]
[]
[]
[]
["1.7   How many staff are working on the management operation?  \nIs this sufficient to ensure compliance with the Offer of Grant?",null,null,null,null,null,null,"<No of Staff>"]
[]
[]
[]
[]
["LEAD OFFICER COMMENTS - LP MANAGEMENT OPERATION"]

{"sheet":"2 - Action Points","index":5,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,3],[10,0,10,3],[2,0,2,3]]}
["2.   Action Points Summary"]
[]
["Main Report Actions (Delete any rows not required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General","General"]
["Action Point No.","Section","Question","Finding","Responsible ","Action Required","Deadline","Final Position","Irregularity Reference from EUMIS \n(if appropriate)","Status","Closed by                          (PCM Name)","Evidence Provided to Close Action \n(Obj ID)",null,null,null,"1a",1.1000000000000001]
[1,"Choose an item.","Choose an item.",null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,"1b",1.2]
[2,"Choose an item.","Choose an item.",null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,3,1.3]
[3,"Choose an item.","Choose an item.",null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,4,1.4]
[4,"Choose an item.","Choose an item.",null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,5,1.5]
[5,"Choose an item.","Choose an item.",null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,"6a",1.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6b",1.7]
["File or Cost Check Actions (Delete any rows not required)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7a",3.1]
["Action Point No.","File or Cost Check","Item Number","Finding","Responsible ","Action Required","Deadline","Final Position","Irregularity Reference from EUMIS \n(if appropriate)","Status","Closed by                          (PCM Name)","Evidence Provided to Close Action \n(Obj ID)",null,null,null,"7b",3.2]
[1,"Choose an item.",null,null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,8,3.3]
[2,"Choose an item.",null,null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,9,3.4]
[3,"Choose an item.",null,null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,10,3.5]
[4,"Choose an item.",null,null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,11,3.6]
[5,"Choose an item.",null,null,"Choose an item.",null,null,null,null,"Choose an item.",null,null,null,null,null,12,4.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,4.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.3000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.4]

{"sheet":"3 - LP Checks","index":6,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[6,0,7,2],[2,3,2,4],[3,3,3,4],[28,0,28,4],[29,0,31,4],[23,0,26,4],[22,0,22,4],[2,0,2,2],[19,0,19,4],[3,0,5,2],[9,0,9,4],[13,0,13,4],[15,0,15,4],[10,0,10,4],[16,0,16,4],[17,0,17,4],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[42,1,42,2],[41,1,41,2],[43,1,43,2],[44,1,44,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[55,1,55,2],[56,1,56,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[44,3,44,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[18,0,18,4],[55,3,55,4],[56,3,56,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[42,3,42,4],[41,3,41,4],[43,3,43,4]]}
["3.   Lead Partner Checks ",null,null,null,null,null,"ESF","ERDF"]
[null,null,null,null,null,null,"Y","Y"]
["3.1 Have there been any fundamental changes to the systems being used in the management of the operation?  These should be checked against the systems noted from the Stage 1 Pre-Claim Check.",null,null,"Yes/No",null,null,"Y","Y"]
["These checks should include the following:\n'- Management and Reporting Structures\n- Data Management Systems (including Data Capture/Management Information Systems)\n- Financial Management Systems\n- Compliance Systems\n- Procurement Systems and Guidance\n- Financial Instruments\nIf there are no changes - note this and move on to Q3.2.\nIf there are changes - note these changes and consider if this has an impact on the successful delivery of the operation - discuss with LP",null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
["3.2 List of outstanding Actions from Stage 1 Pre-Claim Check - You must check these actions with the LP to determine if the action has been resolved and can be closed.  Pre-populated by Admin",null,null,null,null,null,"Y","Y"]
["OA1.",null,null,null,null,null,"Y","Y"]
["OA2.",null,null,null,null,null,"Y","Y"]
["OA3.",null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
["3.3 List here the conditions of grant from all of the offer letters issued to the LP, (there may be new conditions in revised offers).  How is the Lead Partner ensuring compliance with these conditions?    Pre-populated by Admin",null,null,null,null,null,"Y","Y"]
["COG1.",null,null,null,null,null,"Y","Y"]
["COG2.",null,null,null,null,null,"Y","Y"]
["COG3.",null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
["Retention of Operation Documentation\nAll documentation relating to the implementation of the operation and its financing must be retained as per the Managing Authority’s Document Retention Guidance available on the ESFD website.",null,null,null,null,null,"Y","Y"]
["3.4   What processes are in place to ensure that all evidence is being retained in accordance with the guidance?",null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
["3.5   Where there are other organisations involved in the implementation of the operation, what processes are in place to ensure that all evidence is being retained in accordance with the guidance?",null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,"Y","Y"]
["3.6   The LP should provide evidence (either in hard copy or electronically) that they have retained the documents marked to be checked.  If the LP does not have the evidence for those sampled, you are required to check all documents listed.","Check",null,"Yes/No/N/A",null,null,"Y","Y",null,"ESF"]
["Approved Strategic Intervention Application Form",{"$f":"IF(K35<=4,\"X\",\"\")","v":""},null,null,null,null,"Y","Y",null,{"$f":"IF(AND($J$34=\"esf\",G35=\"y\"),RAND(),IF(AND($J$34=\"erdf\",H35=\"y\"),RAND(),\"x\"))","v":0.35657814873059168},{"$f":"IF(J35=\"x\",999,RANK(J35,$J$35:$J$57))","v":10}]
["Original Strategic Intervention Approval Letter ",{"$f":"IF(K36<=4,\"X\",\"\")","v":""},null,null,null,null,"Y","Y",null,{"$f":"IF(AND($J$34=\"esf\",G36=\"y\"),RAND(),IF(AND($J$34=\"erdf\",H36=\"y\"),RAND(),\"x\"))","v":0.48134164422676451},8]
["Acceptance of Strategic Intervention Approval Letter","",null,null,null,null,"Y","Y",null,0.5406729097424815,6]
["Operation Application Form","X",null,null,null,null,"Y","Y",null,0.76825964382744116,2]
["Operation Offer of Grant","X",null,null,null,null,"Y","Y",null,0.72404446746727358,4]
["Operation Acceptance of Grant ","",null,null,null,null,"Y","Y",null,2.7936136539396972E-2,21]
["Operation Verification Plan","",null,null,null,null,"Y","Y",null,0.15221721291861889,16]
["National Rules","X",null,null,null,null,"Y","Y",null,0.85380303928261259,1]
["Challenge Fund Guidance","",null,null,null,null,"Y","Y",null,0.33879967610792427,11]
["Grant Scheme Manager Guidance","",null,null,null,null,"Y","Y",null,0.20782257978344643,13]
["Publicity Requirements","",null,null,null,null,"Y","Y",null,0.1315502756362712,17]
["Document Retention Guidance","",null,null,null,null,"Y","Y",null,0.19614225974691546,14]
["ESF Participants Records","",null,null,null,null,"Y",null,null,0.25319419113469577,12]
["ESF Participant Guidance","",null,null,null,null,"Y",null,null,0.11042535800855302,19]
["Final Recipient Organisation Records","",null,null,null,null,null,"Y",null,"x",999]
["Qualifications Table","",null,null,null,null,"Y",null,null,9.5986165275117052E-2,20]
["Scottish Local Authority – Rural Area Postcodes","",null,null,null,null,"Y","Y",null,0.19156136212445662,15]
["Scottish Local Authority – Employment Deprived Area Postcodes","X",null,null,null,null,"Y","Y",null,0.76622741844296793,3]
["Monitoring and Evaluation Strategy","",null,null,null,null,"Y","Y",null,0.50410717803901162,7]
["EC Guidance for Monitoring and Evaluation - ESF","",null,null,null,null,"Y",null,null,0.37943873564399155,9]
["EC Guidance for Monitoring and Evaluation - ERDF","",null,null,null,null,null,"Y",null,"x",999]
["EC Guidance for Monitoring and Evaluation – Annex D","",null,null,null,null,"Y",null,null,0.12029523566229283,18]
["EC Guidance for the Youth Employment Initiative","",null,null,null,null,"Y",null,null,0.6241483325183933,5]

{"sheet":"4 - Operation Checks","index":7,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,12],[10,0,10,3],[10,4,10,11],[11,1,11,3],[11,5,11,11],[2,2,2,3],[2,5,2,6],[2,7,2,9],[4,0,4,9],[4,10,4,11],[5,0,8,9],[5,10,5,11],[13,0,16,9],[13,10,13,11],[12,0,12,9],[12,10,12,11],[18,0,18,11],[17,0,17,11],[24,0,24,11],[25,0,28,11],[19,0,22,11],[35,0,35,9],[30,0,30,9],[31,0,34,9],[30,10,30,11],[31,10,31,11]]}
["4.   Operation Checks",null,null,null,null,null,null,null,null,null,null,null,null,null,"ESF","ERDF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["Start Date:",{"$f":"'1a - Operation Detail'!B12","v":"00:00:00"},"Physical End Date:",null,{"$f":"'1a - Operation Detail'!D12","v":"00:00:00"},"Financial End Date:",null,{"$f":"'1a - Operation Detail'!F12","v":"00:00:00"},null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["4.1  Have any of the timescales changed?\nIf so, what were the reasons for the change, and have these been subject to a formal change request?",null,null,null,null,null,null,null,null,null,"Yes/No",null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["Estimated Forecast Spend to date \n(at time of arrangement of the visit)",null,null,null,"Actual claimed \n(at time of arrangement of the visit)",null,null,null,null,null,null,null,null,null,"Y","Y"]
["Total","Pre-populated by Admin",null,null,"Total","Pre-populated by Admin",null,null,null,null,null,null,null,null,"Y","Y"]
["4.2 Has the profile changed/likely to change, and has this been subject to a formal change request?  ",null,null,null,null,null,null,null,null,null,"Yes/No",null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["*The forecast spend is provided per year not per month so is estimated based on the date of visit.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["4.3   How have you ensured the delivery is in-line with the approved operation application",null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["4.4  If the operation is using any of the flexibility options (Fund Flexibility/Geographical Flexibility/Transnational Flexibility), how is this being monitored",null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["4.5  Is the Operation location as prescribed? (ERDF On-Site Visit Only)",null,null,null,null,null,null,null,null,null,"Yes/No",null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["*If an on-site visit is undertaken (all ERDF operations must be subject to an on-site visit), please ensure to photograph the facility and the site signage to be retained on file - see further publicity checks at section 12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]

{"sheet":"5 - Finance & Declaration","index":8,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,0,16,13],[18,0,18,13],[19,0,22,13],[6,0,6,15],[7,0,10,15],[12,0,12,13],[12,14,12,15],[13,14,13,15],[0,0,0,13],[2,14,2,15],[4,14,4,15],[2,8,2,13],[2,6,2,7],[2,0,2,5],[4,0,4,13],[24,0,24,13],[25,0,28,13],[31,0,34,13],[30,0,30,13],[23,0,23,5],[30,14,30,15],[31,14,31,15],[24,14,24,15],[25,14,25,15],[18,14,18,15],[19,14,19,15]]}
["5.   Financial Management & Declaration of Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESF","ERDF"]
["Pre-populated by Admin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["Total Approved Match Funding\n",null,null,null,null,null,{"$f":"'1a - Operation Detail'!B15","v":0},null,"Total Match Funding declared as at <Insert date of visit arrangements>",null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["FINANCIAL CHECK UNDERTAKEN IN CONJUNCTION WITH THIS REPORT (OBJ ID)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1a - Operation Detail'!B23","v":0},null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["5.1   What procedures are in place to record, monitor and verify the match funding? \n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["5.2   Are there any in-kind contributions within the Operation?  \n(NB:  This only applies to ERDF Capital projects)  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No/N/A",null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["5.3   Has there been any Income received during delivery of the operation?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No/N/A",null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["5.4    Has the Grant been awarded in compliance with EC Regulation Article 61 of 1303/2013 re. Operations generating net revenue after completion? (ERDF Only)  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No/N/A",null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["5.5   Can the LP provide evidence of their VAT Status?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No",null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]

{"sheet":"6a - Recipient - ESF","index":9,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,0,22,8],[23,0,26,8],[28,0,28,8],[29,0,32,8],[2,7,2,8],[4,0,4,8],[5,0,8,8],[10,0,10,8],[11,0,14,8],[16,0,16,8],[17,0,20,8]]}
["6a.   Recipient Analysis & Records - ESF"]
[]
["FILE CHECK UNDERTAKEN IN CONJUNCTION WITH THIS REPORT (OBJ ID)",null,null,null,null,null,null,{"$f":"'1a - Operation Detail'!D23","v":0}]
[]
["6.1   How are participants recruited to the Operation, and are numbers as anticipated?"]
[]
[]
[]
[]
[]
["6.2   How does the LP ensure that all participants meet the eligibility criteria?"]
[]
[]
[]
[]
[]
["6.3   What systems does the LP have in place to ensure there is no duplication of activity with another SI/Operation."]
[]
[]
[]
[]
[]
["6.4   What systems does the LP have in place to monitor participants who exit an operation and re-engage at a later date?"]
[]
[]
[]
[]
[]
["6.5   How is participant information collected and reported?"]

{"sheet":"6b - Non Recipient - ESF","index":10,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[29,0,32,8],[34,0,34,8],[35,0,38,8],[40,0,40,8],[41,0,44,8],[17,0,20,8],[22,0,22,8],[23,0,26,8],[28,0,28,8],[2,7,2,8],[5,0,8,8],[10,0,10,8],[16,0,16,8],[11,0,14,8],[4,0,4,8]]}
["6b.   Non-Recipient Analysis & Records - ESF"]
[]
["FILE CHECK UNDERTAKEN IN CONJUNCTION WITH THIS REPORT (OBJ ID)",null,null,null,null,null,null,{"$f":"'1a - Operation Detail'!D23","v":0}]
[]
["6.1   How are projects/organisations selected to meet the ESF specific Programme criteria and objectives?"]
[]
[]
[]
[]
[]
["6.2   Have any problems been encountered in engaging eligible projects/organisations?"]
[]
[]
[]
[]
[]
["6.3   Have you had to make any changes to your selection process as a result of engagement issues or external / market changes?"]
[]
[]
[]
[]
[]
["6.4   What systems does the LP have in place to ensure there is no duplication of activity with another SI/Operation?"]
[]
[]
[]
[]
[]
["6.5   How do you ensure that ESF output targets are being met?"]
[]
[]
[]
[]
[]
["6.6   How do you ensure that achievement information is recorded correctly?"]
[]
[]
[]
[]
[]
["6.7   Are problems being encountered with progress at individual project level?"]

{"sheet":"7a - Recipient - ERDF","index":11,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,6],[34,7,34,8],[35,0,38,6],[35,7,35,8],[22,0,22,8],[28,0,28,8],[29,0,32,8],[23,0,26,8],[2,7,2,8],[4,0,4,8],[5,0,8,8],[10,0,10,6],[10,7,10,8],[2,0,2,6],[11,0,14,6],[11,7,11,8],[16,0,16,6],[16,7,16,8],[17,0,20,6],[17,7,17,8]]}
["7a.   Recipient Analysis & Records - ERDF"]
[]
["FILE CHECK UNDERTAKEN IN CONJUNCTION WITH THIS REPORT (OBJ ID)",null,null,null,null,null,null,{"$f":"'1a - Operation Detail'!D23","v":0}]
[]
["7.1   How are recipients selected to meet specific ERDF eligibility criteria e.g. growth business?"]
[]
[]
[]
[]
[]
["7.2   Have problems been encountered in engaging eligible SMEs/organisations? ",null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["7.3   Have you had to make any changes to your selection process as a result?",null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["7.4   How do you ensure that achievement information is recorded correctly?"]
[]
[]
[]
[]
[]
["7.5   How do you ensure that ERDF output targets are being met?"]
[]
[]
[]
[]
[]
["7.6   Are problems being encountered with achievements/outputs?",null,null,null,null,null,null,"Yes/No"]

{"sheet":"7b - Non Recipient - ERDF","index":12,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,6],[35,0,38,6],[34,7,34,8],[35,7,35,8],[2,0,2,5],[2,7,2,8],[23,0,26,8],[28,0,28,8],[29,0,32,8],[0,0,0,3],[17,0,20,6],[17,7,17,8],[16,0,16,6],[16,7,16,8],[4,0,4,8],[5,0,8,8],[10,0,10,6],[10,7,10,8],[11,0,14,6],[11,7,11,8]]}
["7b.   Non-Recipient Analysis & Records - ERDF"]
[]
["FILE CHECK UNDERTAKEN IN CONJUNCTION WITH THIS REPORT (OBJ ID)",null,null,null,null,null,null,{"$f":"'1a - Operation Detail'!D23","v":0}]
[]
["7.1   How were the projects selected to meet specific the ERDF specific Programme criteria or objectives"]
[]
[]
[]
[]
[]
["7.2   Have problems been encountered in engaging eligible projects/organisations? ",null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["7.3   Have you had to make any changes to your selection process as a result of engagement issues or external / market changes?",null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["7.4   How do you ensure that ERDF output targets are being met?"]
[]
[]
[]
[]
[]
["7.5   How do you ensure that achievement information is recorded correctly?"]
[]
[]
[]
[]
[]
["7.6   Are problems being encountered with progress at individual project level?",null,null,null,null,null,null,"Yes/No"]

{"sheet":"8 - Results","index":13,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,0,12,13],[13,0,15,13],[0,0,0,13],[2,0,2,13],[3,0,5,13],[7,0,7,13],[8,0,10,13]]}
["8.   Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESF","ERDF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["8.1   How are results captured, monitored and verified?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["8.2.    What arrangements are in place to monitor the longer-term results? (ESF Only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
["8.3   How realistic are the figures achieved to date compared to the approved operation application?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]

{"sheet":"9 - Procurement","index":14,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,0,6,13],[0,0,0,11],[33,0,33,2],[19,0,19,2],[26,0,26,4],[13,0,13,2],[2,0,2,13],[8,0,8,13],[27,0,27,13],[28,0,31,13],[9,0,12,13],[14,0,14,13],[15,0,18,13],[20,0,20,13],[21,0,24,13]]}
["9.   Procurement - Contract Management and Implementation\n(These checks will be undertaken by the MA Procurement Team. These can be done desk-based or on-site)"]
[]
["9.1  Can you please provide information on contract management. \n\n"]
[]
[]
[]
[]
[]
["9.2.  Is delivery performance as expected and in line with the contract?  \n       2a. How is this monitored?\n       2b. How is quality of service measured e.g. KPIs?\n       2c. How do they ensure value for money?"]
[]
[]
[]
[]
[]
["9.3  How is spend monitored, especially in framework agreements?"]
[]
[]
[]
[]
[]
["9.4   How are potential modifications/variations controlled?\n        4a. What is the system for reporting these to the Managing Authority?\n        4b. Have there been any modifications/variations that have not been reported to the Managing Authority?\n        4c. Are justifications, as per Regulation 72 of The Public Contracts (Scotland) Regulations 2015, available for all               \n        contract modifications?"]
[]
[]
[]
[]
[]
["General Information"]
["9.5   Check Lead Partner is aware of document retention in relation to procurement documents.\n        5a. Remind Lead Partner to update EUMIS procurement information after each claim (print off EUMIS procurement \n        checklist prior to visit in excel for to confirm with LP information is up-to-date).\n        5b. How does the LP ensure that the contract spend values to date (and including the result of any modifications an \n        the contract value/eligible cost boxes) are updated prior to any claims being submitted? Is there a review of the \n        procurement tab before a claim is submitted to ensure it is up to date? Where contracts and frameworks are \n        managed by partners or other organisations, how is this information provided and updated on EUMIS? \n        5c. Obtain information from LP about their plans on Phase 2 in relation to awarding further procurement contracts?\n \n"]

{"sheet":"10 - State Aid Checks","index":15,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,0,5,11],[6,0,9,11],[0,0,0,11],[1,0,1,11],[3,1,3,2],[18,0,21,11],[11,0,11,9],[11,10,11,11],[12,0,15,9],[12,10,12,11],[17,0,17,11]]}
["10.   State Aid Checks"]
["Further guidance on State Aid is available here:  http://www.gov.scot/Topics/Government/State-Aid/Structural-Funds"]
[]
["State Aid Application Assessment Obj ID","Pre-populated by Admin"]
[]
["10.1   What evidence is available that recommended actions from the State Aid assessment have been implemented."]
[]
[]
[]
[]
[]
["10.2   Have there been any changes in the implementation of the operation that could affect the initial State Aid assessment? ",null,null,null,null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["10.3   What State Aid advice did you receive and who provided it?"]

{"sheet":"11 - Horizontal Themes","index":16,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,13],[26,0,26,11],[26,12,26,13],[3,0,6,13],[28,0,31,11],[2,0,2,13],[8,0,8,13],[9,0,12,13],[14,0,14,13],[15,0,18,13],[20,0,20,13],[21,0,24,13],[27,12,27,13],[27,0,27,11]]}
["11.   Horizontal Themes (See Objective ID - A20985809)"]
[]
["11.1   What plan is in place to monitor delivery against the Horizontal Themes?"]
[]
[]
[]
[]
[]
["11.2   How has the operation supported the Horizontal Theme of Sustainable Development"]
[]
[]
[]
[]
[]
["11.3   How has the operation supported the Horizontal Theme of Equal Opportunities and Non-Discrimination"]
[]
[]
[]
[]
[]
["11.4   How has the operation supported the Horizontal Theme of Equality Between Men and Women"]
[]
[]
[]
[]
[]
["11.5  Is the lead partner working with other organisations (e.g. through partnership, procurement or challenge fund)?  ",null,null,null,null,null,null,null,null,null,null,null,"Yes/No"]
["If yes, how do they a) ensure these organisations are considering Horizontal Themes? b) report delivery from these organisations to the lead partner?"]

{"sheet":"12 - Further Checks","index":17,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,0,2,2],[16,0,16,11],[16,12,16,13],[17,0,20,11],[17,12,17,13],[10,0,10,13],[11,0,14,13],[4,0,4,13],[5,0,8,13],[15,0,15,2],[37,0,40,11],[37,12,37,13],[24,0,27,11],[24,12,24,13],[29,0,29,11],[29,12,29,13],[35,0,35,2],[30,0,33,11],[22,0,22,2],[23,0,23,11],[23,12,23,13],[36,0,36,11],[36,12,36,13]]}
["12.   FURTHER CHECKS"]
[]
["Publicity"]
[]
["12.1   How does the LP publicise Structural Fund support in line with EC legislation?"]
[]
[]
[]
[]
[]
["12.2   How does the Lead Partner ensure delivery agents/contractors are aware of the European Structural Funds contribution?"]
[]
[]
[]
[]
[]
["12.3   Is the Operation in receipt of any awards, i.e. design, environmental, training standards?  Or any good news stories",null,null,null,null,null,null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["Evaluations"]
["12.4   Do you intend to undertake an evaluation of the activity.  If yes, please explain what type of evaluation this will be e.g. survey based, counterfactual. ",null,null,null,null,null,null,null,null,null,null,null,"Yes/No"]
[]
[]
[]
[]
[]
["12.5   At what stage will you do this?",null,null,null,null,null,null,null,null,null,null,null,"Estimated Date"]
[]
[]
[]
[]
[]
["Lessons Learned"]
["12.6   Are there any examples of good practice that the Lead Partner would like to share?",null,null,null,null,null,null,null,null,null,null,null,"Yes/No"]

{"sheet":"13 - Staff Interviews","index":18,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,1,9,3],[9,5,9,7],[20,1,20,3],[20,5,20,7],[10,1,10,3],[11,1,11,3],[12,1,12,3],[10,5,10,7],[11,5,11,7],[12,5,12,7],[13,5,13,7],[13,1,13,3],[14,1,14,3],[18,1,18,3],[19,1,19,3],[16,1,16,3],[2,5,2,7],[3,5,3,7],[7,5,7,7],[8,5,8,7],[2,1,2,3],[3,1,3,3],[7,1,7,3],[8,1,8,3],[5,1,5,3],[5,5,5,7],[4,1,4,3],[4,5,4,7],[6,1,6,3],[6,5,6,7],[16,5,16,7],[21,1,21,3],[22,1,22,3],[14,5,14,7],[18,5,18,7],[19,5,19,7],[21,5,21,7],[22,5,22,7],[15,1,15,3],[15,5,15,7],[17,1,17,3],[17,5,17,7]]}
["13 - STAFF INTERVIEWS (Staff not to be interviewed together)"]
[]
["Staff Member Name/Reference (13.1)","Pre-populated by admin",null,null,"Staff Member Name/Reference (13.2)","Pre-populated by admin"]
["Job Title",null,null,null,"Job Title"]
["Who do you report to?",null,null,null,"Who do you report to?"]
["Roughly what percentage of your time do you work on the operation?",null,null,null,"Roughly what percentage of your time do you work on the operation?"]
["(If not 100%) Have you seen our template timesheet?",null,null,null,"(If not 100%) Have you seen our template timesheet?"]
["Can you please provide an outline of your duties",null,null,null,"Can you please provide an outline of your duties"]
["How long have you worked on the Operation?",null,null,null,"How long have you worked on the Operation?"]
["Are you aware of what the project is trying to achieve?",null,null,null,"Are you aware of what the project is trying to achieve?"]
["Are you aware your post is funded through ESF/ERDF",null,null,null,"Are you aware your post is funded through ESF/ERDF"]
["How were you made aware of this?",null,null,null,"How were you made aware of this?"]
[]
["Staff Member Name/Reference (13.3)","Pre-populated by admin",null,null,"Staff Member Name/Reference (13.4)","Pre-populated by admin"]
["Job Title",null,null,null,"Job Title"]
["Who do you report to?",null,null,null,"Who do you report to?"]
["Roughly what percentage of your time do you work on the operation?",null,null,null,"Roughly what percentage of your time do you work on the operation?"]
["(If not 100%) Have you seen our template timesheet?",null,null,null,"(If not 100%) Have you seen our template timesheet?"]
["Can you please provide an outline of your duties",null,null,null,"Can you please provide an outline of your duties"]
["How long have you worked on the Operation?",null,null,null,"How long have you worked on the Operation?"]
["Are you aware of what the project is trying to achieve?",null,null,null,"Are you aware of what the project is trying to achieve?"]
["Are you aware your post is funded through ESF/ERDF",null,null,null,"Are you aware your post is funded through ESF/ERDF"]
["How were you made aware of this?",null,null,null,"How were you made aware of this?"]

{"sheet":"14 - MA Pre-Visit Checklist","index":19,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,2,2],[12,0,13,0],[14,0,15,0]]}
["14.   PRE-VISIT CHECKLIST"]
[]
["The PPT will confirm the date of a visit with the LP and MA staff, and send them the visit paperwork via email.  This paperwork will also be issued to the Lead Officer (LO).  It is then the responsibility of the LO to: \n\n• Finalise the arrangements for the visit with the LP, including: start/finish times, location of visit, informing of attendees for security purposes \n  and travel arrangements for the visiting team.  \n• Ensure they have all the appropriate documents to undertake the check.  Including: the report, the samples, application forms, Job Descriptions for the staff \n  interviews (where applicable)national rules \n  and any other appropriate guidance e.g. Verification of Outputs Guidance.\n• Review the report to ensure pre-populated information is accurate, including a review of the Stage 1 outstanding actions and conditions of \n  grant.\n• Completing the checklist below prior to the visit."]
[]
["Check ","Tab Name","Detail","Checked"]
["Pre-Visit Meeting","Not Applicable","LO has held a pre-visit meeting with the other officers attending the Article 125 (5)(b) On The Spot Check - including reviewing the forms, and all the arrangements listed in the note above"]
["1a","Main Detail - Delivery Operation\nTo note: Forecast spend to date will be estimated on a pro-rata basis as the forecast is broken down per year not per month.","All of the cells in this tab will be pre-populated by the Admin Team, with the exception of the operation type.  \n\nLO has determine the operation type (selecting from DD list as appropriate) and hidden (do not delete) the tabs that are not relevant to the check (range: tabs 6a to 7b).\nLO has reviewed all pre-populated information for accuracy.\n\n"]
["1b","Main Detail - LP Management Cost Operation (Where Applicable)\nTo note:  Where there is no associated Management Operation, this tab will be hidden.","All of the cells, down to section 1.3, and the financial information under section 1.5 will be pre-populated by the Admin Team.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n\n"]
[2,"Action Points Summary\nTo note: N/A always selected, this is a post-visit section.","This section is to be completed during and following the check.  The LO must ensure all action points noted throughout the form are copied to this section and the appropriate tab and question numbers are selected.  The deadline set for these action must be realistic and where possible within the 90 day deadline for completion of the report.","N/A"]
[3,"Lead Partner Checks","The Admin Team will list (as appropriate) any o/s actions from the stage 1 check at section 3.2 and any COG at section 3.3.\nThe Admin Team will randomly select the documents to be checked at the visit at section 3.6\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n\n"]
[4,"Operation Checks\nTo note: Question 4.5 is only applicable to ERDF.  Where an ESF check is being undertaken, question 4.5 will disappear from the report.\nForecast spend to date will be estimated on a pro-rata basis as the forecast is broken down per year not per month.","The Admin Team will pre-populate the start/end dates, and the financial information at question 4.2.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\nWhere a site visit is necessary, the LO has arranged this with the LP and has the means to take photographic evidence of the site and site signage to be retained on file."]
[5,"Financial Management & Declaration of Expenditure\nTo note: Question 5.2 and 5.4 are only applicable to ERDF.  Where an ESF check is being undertaken, these questions will disappear from the report.","The Admin Team will pre-populate the match funding information, and the financial check objective ID.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n"]
[6,"a) Recipient Analysis & Records - ESF (Where Applicable)\nTo note: the presence of this tab is determined by the operation type selected at section 1a.","The Admin Team will pre-populate the file check objective ID.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n"]
[null,"b) Non Recipient Analysis & Records - ESF\nTo note: the presence of this tab is determined by the operation type selected at section 1a.\n","The Admin Team will pre-populate the file check objective ID.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n"]
[7,"a) Recipient  Analysis & Records - ERDF\nTo note: the presence of this tab is determined by the operation type selected at section 1a.","The Admin Team will pre-populate the file check objective ID.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n"]
[null,"b) Non Recipient Analysis & Records - ERDF\nTo note: the presence of this tab is determined by the operation type selected at section 1a.","The Admin Team will pre-populate the file check objective ID.\n\nLO has reviewed all pre-populated information for accuracy.\nLO has reviewed all the questions to be asked prior to the visit.\n"]
[8,"Results","LO has reviewed all the questions to be asked prior to the visit."]
[9,"Procurement Checks\nTo note: the presence of this tab is determined by whether a procurement check is necessary - this is selected at section 1a.","Procurement checks will be undertaken by the MA Procurement team.  The team will undertake these checks either by attending the visit with the LP, or doing them desk based in communication with the LP via email and receiving any evidence electronically.\n\nLO to ensure this has been appropriately selected by the Admin Team.\nLO to liaise with the Procurement Manager to ensure either their attendance at the visit or the deadlines for a desk based check."]
[10,"State Aid Checks","The Admin Team will pre-populate the State Aid Application Assessment objective ID.\n\nLO to ensure the Assessment objective ID is accurate and review the information in the assessment to allow accurate reporting at this section.\nLO has reviewed all the questions to be asked prior to the visit.\n\n"]
[11,"Horizontal Themes","LO has reviewed the Horizontal Themes Guidance (obj ID provided).\nLO has reviewed all the questions to be asked prior to the visit."]
[12,"Further Checks - Publicity, Evaluations, Good Practice","LO has reviewed all the questions to be asked prior to the visit.\nLO is aware of the need to share any evaluation evidence or details of good practice with the comms team when completing this report."]
[13,"Staff Interviews (MA Copy Only)\nTo note:  The LP does not receive this tab in their version of the form prior to the visit to ensure effective responses from the individual staff.\n","LO has not sent the staff interview questions to the LP.\nLO is aware they are required to identify the person being interviewed and they match the staff selected at this section.\nLO is aware that where multiple staff are selected for interview, they must be interviewed individually and without influence or prompting.\nLO has reviewed the job descriptions for the selected staff prior to the visit."]
[14,"MA Pre-Meeting Checklist\nTo note: This section is only visible for MA Staff.","Not applicable.","N/A"]