{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["COVER","0 - NAVIGATION","QUESTIONNAIRE","OVERALL ASSESSMENT","PROJECT2LOAD","DATABASE","Lists"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":2,"defined_names":17,"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","index":0,"n_rows":4,"n_cols":18,"rows_kept":4,"cut":false,"hidden":false,"merged":[[14,2,51,17],[5,2,5,17],[6,2,6,17],[7,2,7,17],[8,2,8,17]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPP Project Preparation Status Tool "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version of October 2016"]

{"sheet":"0 - NAVIGATION","index":1,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"MAIN MENU"]

{"sheet":"QUESTIONNAIRE","index":2,"n_rows":490,"n_cols":13,"rows_kept":490,"cut":false,"hidden":false,"merged":[[461,3,461,4],[464,3,464,4],[463,3,463,4],[465,3,465,4],[467,3,467,4],[451,3,451,4],[453,3,453,4],[455,3,455,4],[457,3,457,4],[459,3,459,4],[441,3,441,4],[410,3,410,4],[412,3,412,4],[409,3,409,4],[408,3,408,4],[443,3,443,4],[445,3,445,4],[447,3,447,4],[449,3,449,4],[429,3,429,4],[431,3,431,4],[433,3,433,4],[437,3,437,4],[439,3,439,4],[360,3,360,4],[362,3,362,4],[375,3,375,4],[388,3,388,4],[392,3,392,4],[335,3,335,4],[337,3,337,4],[343,3,343,4],[345,3,345,4],[347,3,347,4],[244,3,244,4],[243,3,243,4],[297,3,297,4],[303,3,303,4],[305,3,305,4],[307,3,307,4],[331,3,331,4],[264,3,264,4],[266,3,266,4],[287,3,287,4],[289,3,289,4],[295,3,295,4],[301,3,301,4],[69,3,69,4],[110,3,110,4],[311,3,311,4],[309,3,309,4],[108,3,108,4],[112,3,112,4],[116,3,116,4],[124,3,124,4],[134,3,134,4],[138,3,138,4],[142,3,142,4],[144,3,144,4],[146,3,146,4],[179,3,179,4],[183,3,183,4],[185,3,185,4],[186,3,186,4],[188,3,188,4],[162,3,162,4],[258,3,258,4],[260,3,260,4],[231,3,231,4],[235,3,235,4],[239,3,239,4],[148,3,148,4],[150,3,150,4],[160,3,160,4],[233,3,233,4],[339,3,339,4],[164,3,164,4],[166,3,166,4],[175,3,175,4],[177,3,177,4],[211,3,211,4],[215,3,215,4],[221,3,221,4],[223,3,223,4],[229,3,229,4],[189,3,189,4],[191,3,191,4],[192,3,192,4],[194,3,194,4],[196,3,196,4],[245,3,245,4],[254,3,254,4],[256,3,256,4],[217,3,217,4],[219,3,219,4],[482,2,482,4],[484,2,484,4],[486,2,486,4],[488,2,488,4],[390,3,390,4],[198,3,198,4],[420,3,420,4],[341,3,341,4],[270,2,270,4],[272,2,272,4],[278,2,278,4],[414,2,414,4],[373,2,373,4],[319,2,319,4],[291,2,291,4],[418,3,418,4],[379,3,379,4],[377,3,377,4],[396,3,396,4],[398,3,398,4],[400,3,400,4],[402,3,402,4],[406,3,406,4],[213,3,213,4]]}
[]
[null,null,null,null,"QUESTIONNAIRE PAGE"]
[]
[]
[]
[null,null,null,"Now working on project:",{"$f":"+F18&\"_\"&YEAR(F20)&\"-\"&MONTH(F20)&\"-\"&DAY(F20)","v":"Example2_2017-1-1"}]
[]
[]
[]
[null,null,null,null,null,null,null,"Project's scoring"]
[null,"NOTE: The symbol ∞ is used to signal to the user the interdependence of the question with other sections of the questionnaire marked in bold."]
[null,null,"General Information",null,null,0]
[null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,"Project  name",null,null,"Example2"]
[null,null,null,null,null,"DD / MM / YYYY"]
[null,null,"Assessment date",null,null,"2017-01-01"]
[]
[null,null,"Procuring authority's name ",null,null,"PROCURING AUTHORITY"]
[]
[null,null,"Basic project description",null,null,"NEW PROJECT"]
[]
[]
[null,null,"Selecting and defining the investment"]
[]
[]
[null,null,null,null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"+H34*K34+H46*K46+H56*K56+H66*K66","v":0.99999999999999989},null,null,null,null,{"$f":"+AVERAGE(M34,M46,M56,M66)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"+IF($F$40=\"YES\",SUM($I$36:$I$44),SUM($I$36,$I$38,$I$44))","v":9}]
[]
[null,null,"Has the need for the investment been identified in a regional/national infrastructure plan or sector investment programme?",null,null,"YES",null,{"$f":"+IF(F34=\"YES\",1+SUM(H36:H44),0)","v":1},1,{"$f":"SUM(J36:J44)","v":-1},{"$f":"+I34/+SUM($I$34,$I$46,$I$56,$I$66)","v":0.1111111111111111},null,{"$f":"+IF(F34=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has the infrastructure plan/sector investment programme been approved by the national or sub-national government?",null,"YES",null,{"$f":"+IF(F36=\"YES\",0,J36)","v":0},3,{"$f":"-I36/$I$32","v":-0.33333333333333331}]
[]
[null,null,null,"Are the potential funding sources to implement the investment  broadly identified in the infrastructure plan/investment programme?",null,"YES",null,{"$f":"+IF(F38=\"YES\",0,J38)","v":0},2,{"$f":"-I38/$I$32","v":-0.22222222222222221}]
[]
[null,null,null,"Is there any other related infrastructure that needs to be in place in order for the investment to be delivered?",null,"YES"]
[]
[null,null,null,"      If YES, have the other related infrastructure investments been planned/approved to be delivered in coordination with the investment?",null,"YES",null,{"$f":"+IF(OR(AND(F42=\"YES\",F40=\"YES\"),F40=\"NO\",F40=\"--Please Select--\"),0,J42)","v":0},3,{"$f":"-I42/$I$32","v":-0.33333333333333331}]
[]
[null,null,null,"Has a check been carried out to determine whether the investment is part of an EU infrastructure development programme (e.g. TEN-T, TEN-E)? ",null,"YES",null,{"$f":"+IF(F44=\"YES\",0,J44)","v":0},1,{"$f":"-I44/$I$32","v":-0.1111111111111111}]
[]
[null,null,"Has a preliminary study regarding the need for the investment been carried out?",null,null,"YES",null,{"$f":"+IF(F46=\"YES\",1+SUM(H48:H54),0)","v":1},3,{"$f":"SUM(J47:J54)","v":-1},{"$f":"+I46/+SUM($I$34,$I$46,$I$56,$I$66)","v":0.33333333333333331},null,{"$f":"+IF(F46=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has a recent analysis been carried out using a widely recognised methodology for cost-benefit analysis?",null,"YES",null,{"$f":"+IF(F48=\"YES\",0,J48)","v":0},3,{"$f":"-+I48/SUM($I$48:$I$54)","v":-0.3}]
[]
[null,null,null,"Have different investment options been assessed and ranked?",null,"YES",null,{"$f":"+IF(F50=\"YES\",0,J50)","v":0},2,{"$f":"-+I50/SUM($I$48:$I$54)","v":-0.2}]
[]
[null,null,null,"Has approval for the preferred investment option been sought from the appropriate authority?",null,"YES",null,{"$f":"+IF(F52=\"YES\",0,J52)","v":0},3,{"$f":"-+I52/SUM($I$48:$I$54)","v":-0.3}]
[]
[null,null,null,"Is there evidence of political support for the preferred investment option?",null,"YES",null,{"$f":"+IF(F54=\"YES\",0,J54)","v":0},2,{"$f":"-+I54/SUM($I$48:$I$54)","v":-0.2}]
[]
[null,null,"Have the interests of stakeholders been considered?",null,null,"YES",null,{"$f":"+IF(F56=\"YES\",1+SUM(H58:H64),0)","v":1},3,{"$f":"SUM(J58:J64)","v":-1},{"$f":"+I56/+SUM($I$34,$I$46,$I$56,$I$66)","v":0.33333333333333331},null,{"$f":"+IF(F56=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Have the parties likely to be affected/concerned by the investment been identified (e.g. users, local residents)?",null,"YES",null,{"$f":"+IF(F58=\"YES\",0,J58)","v":0},3,{"$f":"-+I58/SUM($I$58:$I$64)","v":-0.25}]
[]
[null,null,null,"Have the relevant stakeholders been consulted?",null,"YES",null,{"$f":"+IF(F60=\"YES\",0,J60)","v":0},3,{"$f":"-+I60/SUM($I$58:$I$64)","v":-0.25}]
[]
[null,null,null,"Is there a process to ensure that the consultation feedback is taken into consideration throughout the project preparation process?",null,"YES",null,{"$f":"+IF(F62=\"YES\",0,J62)","v":0},3,-0.25]
[]
[null,null,null,"Has a plan been established for the ongoing management of and communication with stakeholders?",null,"YES",null,{"$f":"+IF(F64=\"YES\",0,J64)","v":0},3,-0.25]
[]
[null,null,"Has a preliminary assessment been carried out as to whether the technical and legal aspects of the investment are suitable to PPP? ",null,null,"YES",null,{"$f":"+IF(F66=\"YES\",1+SUM(H68:H74),0)","v":1},2,{"$f":"SUM(J67:J74)","v":-1},{"$f":"+I66/+SUM($I$34,$I$46,$I$56,$I$66)","v":0.22222222222222221},null,{"$f":"+IF(F66=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has the stability of the investment scope and output requirements over time been assessed?",null,"YES",null,{"$f":"+IF(F68=\"YES\",0,J68)","v":0},2,{"$f":"-+I68/SUM($I$68:$I$74)","v":-0.2}]
[]
[null,null,null,"Has an analysis been carried out to demonstrate that the investment requirements can be broadly expressed in service output terms and translated in contractual provisions? ",null,"YES",null,{"$f":"+IF(F70=\"YES\",0,J70)","v":0},3,{"$f":"-+I70/SUM($I$68:$I$74)","v":-0.3}]
[]
[null,null,null,"Have these service output terms been developed taking into consideration existing precedents or available sector guidance?",null,"YES",null,{"$f":"+IF(F72=\"YES\",0,J72)","v":0},2,{"$f":"-+I72/SUM($I$68:$I$74)","v":-0.2}]
[]
[null,null,null,"Has preliminary advice been sought to confirm that the Authority has the legal powers to procure and enter into the PPP contract and related agreements?",null,"YES",null,{"$f":"+IF(F74=\"YES\",0,J74)","v":0},3,{"$f":"-+I74/SUM($I$68:$I$74)","v":-0.3}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"+H34*K34+H46*K46+H56*K56+H66*K66","v":0.99999999999999989}]
[]
[null,null,null,null,null,0]
[null,null,"Readiness to start preparing the project as a PPP",null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[null,"→","Has the need for the project been clearly identified?",null,null,"YES"]
[]
[null,"→","Has consideration been given to a wide range of possible project solutions to address this need?",null,null,"YES"]
[]
[null,"→","Has the preferred project solution, including its scope, been initially identified?",null,null,"YES"]
[]
[null,"→","Has the preferred delivery approach been initially identified - specifically, has the PPP option been found to be potentially a suitable delivery choice?",null,null,"YES"]
[]
[null,"→","Is there initial stakeholder support for the project and proposed delivery approach?",null,null,"YES"]
[]
[null,"→","Is the contracting authority ready and prepared to manage the project preparation phase?",null,null,"NO"]
[null,null,null,null,null,null,null,{"$f":"+IF(AND(F84=\"YES\",F86=\"YES\",F88=\"YES\",F90=\"YES\",F92=\"YES\",F94=\"YES\"),1,0)","v":0}]
[null,null,null,null,null,0]
[]
[null,null,"Preparing the project as a PPP"]
[]
[]
[null,null,"Managing and planning the process"]
[]
[null,null,"Setting up a project team and governance structure",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H107*K107+H115*K115+H141*K141","v":1},null,null,null,null,{"$f":"+AVERAGE(M107,M115,M125)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I107,I115,I141)","v":9}]
[]
[null,null,"Has a steering committee been established to oversee the preparation and delivery of the project?",null,null,"YES",null,{"$f":"+IF(F107=\"YES\",1+SUM(H109:H113),0)","v":1},3,{"$f":"SUM(J108:J113)","v":-1},{"$f":"I107/$I$105","v":0.33333333333333331},null,{"$f":"+IF(F107=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has a senior official at the Authority been appointed to lead the steering committee and take overall responsibility for delivering the project?",null,"YES",null,{"$f":"+IF(F109<>\"YES\",J109,0)","v":0},3,{"$f":"-I109/SUM($I$109:$I$113)","v":-0.375}]
[]
[null,null,null,"Have other members of the steering committee been appointed on the basis of their availability and capabilities to oversee and take decisions through the preparation and procurement stages?",null,"YES",null,{"$f":"+IF(F111<>\"YES\",J111,0)","v":0},3,{"$f":"-I111/SUM($I$109:$I$113)","v":-0.375}]
[]
[null,null,null,"Have the governing rules for the steering committee been agreed by the appropriate authority?",null,"YES",null,{"$f":"+IF(F113=\"YES\",0,J113)","v":0},2,{"$f":"-I113/SUM($I$109:$I$113)","v":-0.25}]
[]
[null,null,"Has a project team been established for the project?",null,null,"YES",null,{"$f":"+IF(F115=\"YES\",H117*K117+H125*K125+H139*K139,0)","v":1},3,{"$f":"H117*K117+H125*K125+H139*K139","v":1},{"$f":"I115/$I$105","v":0.33333333333333331},null,{"$f":"+IF(F115=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has a project director/manager from the Authority been assigned to the project?",null,"YES",null,{"$f":"+IF(F117=\"YES\",1+SUM(H119:H123),0)","v":1},3,{"$f":"SUM(J118:J123)","v":-1},{"$f":"I117/SUM($I$117,$I$125,$I$139)","v":0.375}]
[]
[null,null,null,"      Has the project director/manager worked on similar projects (sector, size and technical complexity) in the past? ",null,"YES",null,{"$f":"+IF(F119<>\"YES\",J119,0)","v":0},2,{"$f":"-I119/SUM($I$119:$I$123)","v":-0.25}]
[]
[null,null,null,"      Has the project director/manager worked on one or more PPP projects in the past? ",null,"YES",null,{"$f":"+IF(F121<>\"YES\",J121,0)","v":0},3,{"$f":"-I121/SUM($I$119:$I$123)","v":-0.375}]
[]
[null,null,null,"      Is the project director/manager dedicated full time to the project?",null,"YES",null,{"$f":"+IF(F123<>\"YES\",J123,0)","v":0},3,{"$f":"-I123/SUM($I$119:$I$123)","v":-0.375}]
[]
[null,null,null,"Have the resources needed to manage the preparation and procurement of the project been assessed?",null,"YES",null,{"$f":"+IF(F125=\"YES\",1+SUM(H127:H137),0)","v":1},3,{"$f":"SUM(J127:J137)","v":-1},{"$f":"I125/SUM($I$117,$I$125,$I$139)","v":0.375}]
[]
[null,null,null,"       Does this assessment consider the expertise and the quantity of resources required?",null,"YES",null,{"$f":"+IF(F127=\"YES\",0,J127)","v":0},3,{"$f":"-I127/SUM($I$127:$I$137)","v":-0.21428571428571427}]
[]
[null,null,null,"       Does this assessment rely on a resource analysis of other similar projects?",null,"YES",null,{"$f":"+IF(F129=\"YES\",0,J129)","v":0},2,{"$f":"-I129/SUM($I$127:$I$137)","v":-0.14285714285714285}]
[]
[null,null,null,"       Does the scope of this assessment comprise the resources available within the Authority and services that will need to be contracted? ",null,"YES",null,{"$f":"+IF(F131=\"YES\",0,J131)","v":0},2,{"$f":"-I131/SUM($I$127:$I$137)","v":-0.14285714285714285}]
[]
[null,null,null,"       Has the total cost of the required internal and external activities been assessed?",null,"YES",null,{"$f":"+IF(F133=\"YES\",0,J133)","v":0},2,{"$f":"-I133/SUM($I$127:$I$137)","v":-0.14285714285714285}]
[]
[null,null,null,"Has a budget been approved to cover for the required resource need?",null,"YES",null,{"$f":"+IF(F135=\"YES\",0,J135)","v":0},3,{"$f":"-I135/SUM($I$127:$I$137)","v":-0.21428571428571427}]
[]
[null,null,null,"       Has the budget for the services contracted out been based on an assessment of the current market cost? ",null,"YES",null,{"$f":"+IF(F137=\"YES\",0,J137)","v":0},2,{"$f":"-I137/SUM($I$127:$I$137)","v":-0.14285714285714285}]
[]
[null,null,null,"Have the necessary powers been delegated to the project team to manage the preparation and procurement process?",null,"YES",null,{"$f":"+IF(F139=\"YES\",1,0)","v":1},2,null,{"$f":"I139/SUM($I$117,$I$125,$I$139)","v":0.25}]
[]
[null,null,"Have experienced legal, financial and technical Advisers been appointed? ",null,null,"YES",null,{"$f":"+IF(F141=\"YES\",1+SUM(H143:H151),0)","v":1},3,{"$f":"SUM(J143:J151)","v":-0.99999999999999989},{"$f":"I141/$I$105","v":0.33333333333333331},null,{"$f":"+IF(F141=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Have the Advisers been selected through a competitive process?",null,"YES",null,{"$f":"+IF(F143=\"YES\",0,J143)","v":0},1,{"$f":"-I143/SUM($I$143:$I$151)","v":-8.3333333333333329E-2}]
[]
[null,null,null,"Have the Advisers been provided with clear terms of reference for the advisory mandate?",null,"YES",null,{"$f":"+IF(F145=\"YES\",0,J145)","v":0},3,{"$f":"-I145/SUM($I$143:$I$151)","v":-0.25}]
[]
[null,null,null,"Have possible conflicts of interest between Advisers and potential bidders been taken into account?",null,"YES",null,{"$f":"+IF(F147=\"YES\",0,J147)","v":0},3,{"$f":"-I147/SUM($I$143:$I$151)","v":-0.25}]
[]
[null,null,null,"Do the individuals in the Advisers' firms assigned to the project have proven experience and expertise in their respective fields?",null,"YES",null,{"$f":"+IF(F149=\"YES\",0,J149)","v":0},3,{"$f":"-I149/SUM($I$143:$I$151)","v":-0.25}]
[]
[null,null,null,"Has the need for other advisory services (e.g. insurance, tax, modelling, environmental) been assessed?",null,"YES",null,{"$f":"+IF(F151=\"YES\",0,J151)","v":0},2,{"$f":"-I151/SUM($I$143:$I$151)","v":-0.16666666666666666}]
[]
[]
[]
[null,null,"Managing authorisations",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H159","v":1}]
[]
[]
[null,null,"Has an assessment of all the necessary authorisation, permits and approvals required to implement the project been carried out? ",null,null,"YES",null,{"$f":"+IF(F159=\"YES\",1+SUM(H161:H167),0)","v":1},null,{"$f":"SUM(J161:J167)","v":-0.99999999999999989},null,null,{"$f":"+IF(F159=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Does the assessment include land acquisition, expropriation, environmental, health and safety requirement of the project?",null,"YES",null,{"$f":"+IF(F161=\"YES\",0,J161)","v":0},3,{"$f":"-I161/SUM($I$161:$I$167)","v":-0.5}]
[]
[null,"∞ ",null,"Have the costs of obtaining these been factored into the project preparation budget (see Setting up a project team and governance structure)",null,"YES",null,{"$f":"+IF(F163=\"YES\",0,J163)","v":0},1,{"$f":"-I163/SUM($I$161:$I$167)","v":-0.16666666666666666}]
[]
[null,null,null,"Does the assessment identify the parties responsible for obtaining these?",null,"YES",null,{"$f":"+IF(F165=\"YES\",0,J165)","v":0},1,{"$f":"-I165/SUM($I$161:$I$167)","v":-0.16666666666666666}]
[null,null,null,null," "]
[null,null,null,"Have the risks associated with obtaining these been assessed and the risk matrix updated?",null,"YES",null,{"$f":"+IF(F167=\"YES\",0,J167)","v":0},1,{"$f":"-I167/SUM($I$161:$I$167)","v":-0.16666666666666666}]
[]
[]
[null,null,"Developing a plan and a timetable",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H174*K174+H182*K182","v":1},null,null,null,null,{"$f":"+AVERAGE(M174,M182)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"I174+I182","v":6}]
[]
[null,null,"Does the Authority have an agreed plan to manage the project development and procurement process? ",null,null,"YES",null,{"$f":"+IF(F174=\"YES\",1+SUM(H176:H180),0)","v":1},3,{"$f":"SUM(J175:J180)","v":-1},{"$f":"I174/$I$172","v":0.5},null,{"$f":"+IF(F174=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Have the roles of all members of the project team been defined?",null,"YES",null,{"$f":"+IF(F176<>\"YES\",J176,0)","v":0},3,{"$f":"-I176/SUM($I$176:$I$180)","v":-0.5}]
[]
[null,null,null,"Is there a process to record any changes in the development of the technical features and contractual arrangements of the project during its preparation?",null,"YES",null,{"$f":"+IF(F178<>\"YES\",J178,0)","v":0},1,{"$f":"-I178/SUM($I$176:$I$180)","v":-0.16666666666666666}]
[]
[null,null,null,"Is there a process for managing all required authorisation, permits and approvals during the preparation and procurement process?",null,"YES",null,{"$f":"+IF(F180<>\"YES\",J180,0)","v":0},2,{"$f":"-I180/SUM($I$176:$I$180)","v":-0.33333333333333331}]
[]
[null,null,"Has a timetable that reflects the requirements of the project preparation and procurement been put in place?  ",null,null,"YES",null,{"$f":"+IF(F182=\"YES\",1+SUM(H184:H199),0)","v":1},3,{"$f":"SUM(J184:J199)","v":-1},{"$f":"I182/$I$172","v":0.5},null,{"$f":"+IF(F182=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Does the timetable accommodate any required public consultation processes?",null,"YES",null,{"$f":"+IF(F184<>\"YES\",J184,0)","v":0},3,{"$f":"-I184/SUM($I$184:$I$199)","v":-0.17647058823529413}]
[]
[null,"∞ ",null,"Does the timetable allow for enough time to obtain all required authorisations, permits and approvals? ",null,"YES",null,{"$f":"+IF(F186<>\"YES\",J186,0)","v":0},3,{"$f":"-I186/SUM($I$184:$I$199)","v":-0.17647058823529413}]
[null,null,null,"(see Managing authorisations)"]
[]
[null,"∞ ",null,"Does the timetable allow for enough time to obtain approvals for any external funding sources (e.g. grants)? ",null,"YES",null,{"$f":"+IF(F189<>\"YES\",J189,0)","v":0},3,{"$f":"-I189/SUM($I$184:$I$199)","v":-0.17647058823529413}]
[null,null,null,"(see Developing the affordability analysis)"]
[]
[null,"∞ ",null,"Does the timetable allow for enough time to run the procurement process adequately, including raising the financing? ",null,"YES",null,0,3,{"$f":"-I192/SUM($I$184:$I$199)","v":-0.17647058823529413}]
[null,null,null,"(see Performing market sounding and bankability analysis)"]
[]
[null,null,null,"Does the timetable identify key milestones in the preparation and procurement process and show the relationships between tasks?",null,"YES",null,{"$f":"+IF(F195<>\"YES\",J195,0)","v":0},2,{"$f":"-I195/SUM($I$184:$I$199)","v":-0.11764705882352941}]
[]
[null,null,null,"Has the timetable been fully accepted and approved by the steering committee and the appropriate authority?",null,"YES",null,{"$f":"+IF(F197<>\"YES\",J197,0)","v":0},1,{"$f":"-I197/SUM($I$184:$I$199)","v":-5.8823529411764705E-2}]
[]
[null,null,null,"Has an initial plan been developed for the post-contract signature phase to manage the project including contract management, identification and training of key individuals and ensuring effective continuation of project information?",null,"YES",null,{"$f":"+IF(F199<>\"YES\",J199,0)","v":0},2,{"$f":"-I199/SUM($I$184:$I$199)","v":-0.11764705882352941}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"AVERAGE(H171,H156,H104)","v":1}]
[]
[null,null,"Developing the PPP project",null,null,0]
[]
[null,null,"Developing the affordability analysis",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"+H210","v":1},null,null,null,null,{"$f":"+M210","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"(+IF(F236=\"YES\",I238,0)+SUM(I246,I244,I242,I212:I234))","v":35}]
[]
[null,null,"Has an affordability analysis been prepared to demonstrate that the Authority and/or the end-users have the capacity to pay for the project? ",null,null,"YES",null,{"$f":"+IF(F210=\"YES\",1+SUM(H212:H246),0)","v":1},null,{"$f":"SUM(J212:J246)","v":-1.0000000000000002},null,null,{"$f":"+IF(F210=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Have all project costs over the life of the project been estimated?",null,"YES",null,{"$f":"+IF(F212=\"YES\",0,J212)","v":0},3,{"$f":"-I212/$I$208","v":-8.5714285714285715E-2}]
[]
[null,null,null,"Does the cost analysis cover capital expenditure, operation and maintenance costs, lifecycle costs, financing costs, land acquisition costs, public sector management costs, insurance costs, project preparation costs, transaction costs and taxes?",null,"YES",null,{"$f":"+IF(F214=\"YES\",0,J214)","v":0},3,{"$f":"-I214/$I$208","v":-8.5714285714285715E-2}]
[]
[null,null,null,"Does the financing cost analysis reflect current market conditions for pricing, debt maturity, equity returns, gearing and debt cover ratios?",null,"YES",null,{"$f":"+IF(F216=\"YES\",0,J216)","v":0},2,{"$f":"-I216/$I$208","v":-5.7142857142857141E-2}]
[]
[null,"∞ ",null,"Are the cost estimates consistent with the findings of the market sounding and bankability analysis, stakeholder analysis and the required service outputs for the project?",null,"YES",null,{"$f":"+IF(F218=\"YES\",0,J218)","v":0},2,{"$f":"-I218/$I$208","v":-5.7142857142857141E-2}]
[]
[null,"∞ ",null,"Have the Advisers been used to help prepare the cost estimates and financing assumptions? (see Setting up a project team and a governance structure)",null,"YES",null,{"$f":"+IF(F220=\"YES\",0,J220)","v":0},2,{"$f":"-I220/$I$208","v":-5.7142857142857141E-2}]
[]
[null,null,null,"Have funding sources for the project been identified (e.g. user payments, capital grants, Authority budgetary resources)?",null,"YES",null,{"$f":"+IF(F222=\"YES\",0,J222)","v":0},3,{"$f":"-I222/$I$208","v":-8.5714285714285715E-2}]
[]
[null,null,null,"Has an analysis been carried to determine the feasibility of any end-user payments? ",null,"YES"]
[]
[null,null,null,"      If yes, does the analysis cover the end-user willingness to pay for the services?",null,"YES",null,{"$f":"+IF(AND(F226=\"YES\",F224=\"YES\"),0,J226)","v":0},3,{"$f":"-I226/$I$208","v":-8.5714285714285715E-2}]
[]
[null,null,null,"      if yes, does the analysis follow a recognised methodology for the sector?",null,"YES",null,{"$f":"+IF(AND(F228=\"YES\",F224=\"YES\"),0,J228)","v":0},2,{"$f":"-I228/$I$208","v":-5.7142857142857141E-2}]
[]
[null,null,null,"Has the availability, timing and likelihood of third party grants been assessed?",null,"YES",null,{"$f":"+IF(F230=\"YES\",0,J230)","v":0},2,{"$f":"-I230/$I$208","v":-5.7142857142857141E-2}]
[]
[null,null,null,"Has the availability and timing of internal budgetary resources to fund part of the capital cost of the project been assessed?",null,"YES",null,{"$f":"+IF(F232=\"YES\",0,J232)","v":0},3,{"$f":"-I232/$I$208","v":-8.5714285714285715E-2}]
[]
[null,null,null,"Has the availability and timing of public resources (other than the Authority's resources) to support the Authority's periodic payments over the life of the project been assessed?",null,"YES",null,{"$f":"+IF(F234=\"YES\",0,J234)","v":0},3,{"$f":"-I234/$I$208","v":-8.5714285714285715E-2}]
[]
[null,null,null,"Has the disposal of existing assets been identified as a potential source of funding?",null,"YES"]
[]
[null,null,null,"      If yes, has an analysis been carried out to assess the value and timing of the related proceeds?",null,"YES",null,{"$f":"+IF(OR(AND(F238=\"YES\",F236=\"YES\"),F236=\"NO\",F236=\"--Please Select--\"),0,J238)","v":0},1,{"$f":"-I238/$I$208","v":-2.8571428571428571E-2}]
[]
[null,null,null,"Has a financial model been prepared to assess that the funding sources identified will cover the costs of the project, when needed, over its lifetime?",null,"YES"]
[]
[null,"∞ ",null,"      If yes, have Advisers been involved in preparing the financial model? (see Setting up a project team and a governance structure)",null,"YES",null,{"$f":"+IF(AND(F242=\"YES\",F240=\"YES\"),0,J242)","v":0},1,{"$f":"-I242/$I$208","v":-2.8571428571428571E-2}]
[]
[null,null,null,"Has a sensitivity analysis been carried to test the robustness of the project affordability? ",null,"YES",null,{"$f":"+IF(F244=\"YES\",0,J244)","v":0},2,{"$f":"-I244/$I$208","v":-5.7142857142857141E-2}]
[]
[null,null,null,"Has the affordability analysis taken into consideration contingent payment commitments of the Authority (e.g. revenue guarantees)?",null,"YES",null,{"$f":"+IF(F246=\"YES\",0,J246)","v":0},3,{"$f":"-I246/$I$208","v":-8.5714285714285715E-2}]
[]
[]
[null,null,"Developing the risk analysis",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H253*K253+H263*K263+H269*K269+H271*K271+H273*K273+H275*K275+H277*K277+H279*K279","v":1},null,null,null,null,{"$f":"+AVERAGE(M253,M263,M269,M271,M273,M275,M277,M279)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"I253+I263+SUM(I269:I279)","v":21}]
[]
[null,null,"Have the risks associated with the project been identified? ",null,null,"YES",null,{"$f":"+IF(F253=\"YES\",1+SUM(H255:H261),0)","v":1},3,{"$f":"SUM(J255:J261)","v":-0.99999999999999978},{"$f":"I253/$I$251","v":0.14285714285714285},null,{"$f":"+IF(F253=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Does the analysis cover all the phases of the project and all the classes of risks (e.g. legal, technical, financial, environment)? ",null,"YES",null,{"$f":"+IF(F255=\"YES\",0,J255)","v":0},3,{"$f":"-I255/SUM($I$255:$I$261)","v":-0.42857142857142855}]
[]
[null,null,null,"Does the analysis cover the risks associated with the public sector's obligations and ability to deliver the project?",null,"YES",null,{"$f":"+IF(F257=\"YES\",0,J257)","v":0},2,{"$f":"-I257/SUM($I$255:$I$261)","v":-0.2857142857142857}]
[]
[null,null,null,"Has a detailed risk matrix been prepared to register these risks?",null,"YES",null,{"$f":"+IF(F259=\"YES\",0,J259)","v":0},1,{"$f":"-I259/SUM($I$255:$I$261)","v":-0.14285714285714285}]
[]
[null,null,null,"Have the risks been broken down into appropriate sub-risks to ensure a complete and clear understanding of the extent of each Risk ?",null,"YES",null,{"$f":"+IF(F261=\"YES\",0,J261)","v":0},1,{"$f":"-I261/SUM($I$255:$I$261)","v":-0.14285714285714285}]
[]
[null,null,"Has a risk evaluation exercise been carried out? ",null,null,"YES",null,{"$f":"+IF(F263=\"YES\",1+SUM(H265:H267),0)","v":1},3,{"$f":"+SUM(J265:J267)","v":-1},{"$f":"I263/$I$251","v":0.14285714285714285},null,{"$f":"+IF(F263=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has the likelihood of each risk been estimated?",null,"YES",null,{"$f":"+IF(F265=\"YES\",0,J265)","v":0},2,{"$f":"-I265/SUM($I$265:$I$267)","v":-0.5}]
[]
[null,null,null,"Has the impact of risks been assessed in terms of cost and time?",null,"YES",null,{"$f":"+IF(F267=\"YES\",0,J267)","v":0},2,{"$f":"-I267/SUM($I$265:$I$267)","v":-0.5}]
[]
[null,null,"Has a preliminary allocation/sharing of risks been carried out on the basis of allocating each risk to the party best able to manage that risk?",null,null,"YES",null,{"$f":"+IF(F269=\"YES\",1,0)","v":1},3,null,{"$f":"I269/$I$251","v":0.14285714285714285},null,{"$f":"+IF(F269=\"YES\",10,0)","v":10}]
[]
[null,null,"Have measures to mitigate any of the project risks been assessed and reflected in the project plan and the technical features and contractual arrangements of the project?",null,null,"YES",null,{"$f":"+IF(F271=\"YES\",1,0)","v":1},3,null,{"$f":"I271/$I$251","v":0.14285714285714285},null,{"$f":"+IF(F271=\"YES\",10,0)","v":10}]
[]
[null,"∞ ","Has the overall risk analysis involved Advisers, in particular in the identification, evaluation and allocation exercise? (see Setting up a project team and a governance structure)",null,null,"YES",null,{"$f":"+IF(F273=\"YES\",1,0)","v":1},2,null,{"$f":"I273/$I$251","v":9.5238095238095233E-2},null,{"$f":"+IF(F273=\"YES\",10,0)","v":10}]
[]
[null,"∞ ","Is the risk analysis informed by the service output requirements, the Market Sounding & Bankability and Affordability assessments?",null,null,"YES",null,{"$f":"+IF(F275=\"YES\",1,0)","v":1},3,null,{"$f":"I275/$I$251","v":0.14285714285714285},null,{"$f":"+IF(F275=\"YES\",10,0)","v":10}]
[]
[null,null,"Has the risk analysis been based on any relevant precedent?",null,null,"YES",null,{"$f":"+IF(F277=\"YES\",1,0)","v":1},2,null,{"$f":"I277/$I$251","v":9.5238095238095233E-2},null,{"$f":"+IF(F277=\"YES\",10,0)","v":10}]
[]
[null,null,"Has a risk management process been put in place that will enable the project risks to be monitored, reviewed and updated over the development and operation of the project?",null,null,"YES",null,{"$f":"+IF(F279=\"YES\",1,0)","v":1},2,null,{"$f":"I279/$I$251","v":9.5238095238095233E-2},null,{"$f":"+IF(F279=\"YES\",10,0)","v":10}]
[]
[]
[null,null,"Performing market sounding and bankability analysis",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H286*K286+H292*K292+H294*K294+H300*K300+H314*K314+H316*K316+H318*K318+H320*K320+H322*K322","v":1},null,null,null,null,{"$f":"+AVERAGE(M286,M292,M294,M300,M314,M320,M318)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"I286+I292+I294+I300+SUM(I314:I322)","v":22}]
[]
[null,null,"Has the level of interest/capacity of private sector stakeholders (e.g. contractors, financiers) to participate in the project been assessed? ",null,null,"YES",null,{"$f":"+IF(F286=\"YES\",1+SUM(H288:H290),0)","v":1},3,{"$f":"+SUM(J288:J290)","v":-1},{"$f":"I286/$I$284","v":0.13636363636363635},null,{"$f":"+IF(F286=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has a market sounding plan been developed that identifies the key project features (e.g. risk profile, contract duration) to be tested with the market? ",null,"YES",null,{"$f":"+IF(F288=\"YES\",0,J288)","v":0},3,{"$f":"-I288/SUM($I$288:$I$290)","v":-0.6}]
[]
[null,null,null,"Does this plan set out a clear approach to engaging with all the relevant market players at the appropriate time? ",null,"YES",null,{"$f":"+IF(F290=\"YES\",0,J290)","v":0},2,{"$f":"-I290/SUM($I$288:$I$290)","v":-0.4}]
[]
[null,null,"Has research been carried out to identify comparable projects (e.g. size, sector, risk profile) that have reached financial close recently in the country or wider area? ",null,null,"YES",null,{"$f":"+IF(F292=\"YES\",1,0)","v":1},2,null,{"$f":"I292/$I$284","v":9.0909090909090912E-2},null,{"$f":"+IF(F292=\"YES\",10,0)","v":10}]
[]
[null,null,"Has an analysis been carried out to assess the capability of contractors and service providers to construct and operate the project?",null,null,"YES",null,{"$f":"+IF(F294=\"YES\",1+SUM(H296:H298),0)","v":1},3,{"$f":"+SUM(J296:J298)","v":-1},{"$f":"I294/$I$284","v":0.13636363636363635},null,{"$f":"+IF(F294=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Does the analysis cover their past experience of PPP projects?",null,"YES",null,{"$f":"+IF(F296=\"YES\",0,J296)","v":0},2,{"$f":"-I296/SUM($I$296:$I$298)","v":-0.4}]
[]
[null,null,null,"Does the scope of the analysis include the capacity of the market to deliver the required project outputs to the envisaged quality, cost and timetable?",null,"YES",null,{"$f":"+IF(F298=\"YES\",0,J298)","v":0},3,{"$f":"-I298/SUM($I$296:$I$298)","v":-0.6}]
[]
[null,null,"Has an analysis been carried out to assess the capacity/appetite of potential financiers to finance the project? ",null,null,"YES",null,{"$f":"+IF(F300=\"YES\",1+SUM(H302:H312),0)","v":1},3,{"$f":"+SUM(J302:J312)","v":-1},{"$f":"I300/$I$284","v":0.13636363636363635},null,{"$f":"+IF(F300=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Does the analysis cover all potential financing sources (e.g. commercial banks, international or domestic public financing institutions, equity investors) for the project? ",null,"YES",null,{"$f":"+IF(F302=\"YES\",0,J302)","v":0},2,{"$f":"-I302/SUM($I$302:$I$312)","v":-0.14285714285714285}]
[]
[null,null,null,"Does the analysis focus on their experience of financing PPP projects (e.g. non-recourse project financing)?",null,"YES",null,{"$f":"+IF(F304=\"YES\",0,J304)","v":0},2,{"$f":"-I304/SUM($I$302:$I$312)","v":-0.14285714285714285}]
[]
[null,null,null,"Does the analysis assess whether the project features (e.g. risk profile) are likely to attract financing on reasonable terms (e.g. long debt maturity)? ",null,"YES",null,{"$f":"+IF(F306=\"YES\",0,J306)","v":0},3,{"$f":"-I306/SUM($I$302:$I$312)","v":-0.21428571428571427}]
[]
[null,null,null,"Does the analysis assess whether financiers are likely to require public guarantees (e.g. minimum demand guarantees)?",null,"YES",null,{"$f":"+IF(F308=\"YES\",0,J308)","v":0},2,{"$f":"-I308/SUM($I$302:$I$312)","v":-0.14285714285714285}]
[]
[null,null,null,"Where public sector payment obligations are expected to arise, does the analysis assess whether the financiers will be comfortable with the relevant public bodies' ability to meet these obligations?",null,"YES",null,{"$f":"+IF(F310=\"YES\",0,J310)","v":0},3,{"$f":"-I310/SUM($I$302:$I$312)","v":-0.21428571428571427}]
[]
[null,null,null,"Does the analysis assess whether the financiers will be comfortable with the financial standing and technical capacity of potential contractors and service providers? ",null,"YES",null,{"$f":"+IF(F312=\"YES\",0,J312)","v":0},2,{"$f":"-I312/SUM($I$302:$I$312)","v":-0.14285714285714285}]
[]
[null,"∞ ","Have the Advisers been involved in the Market Sounding and Bankability Analysis?",null,null,"YES",null,{"$f":"+IF(F314=\"YES\",1,0)","v":1},2,null,{"$f":"I314/$I$284","v":9.0909090909090912E-2},null,{"$f":"+IF(F314=\"YES\",10,0)","v":10}]
[]
[null,null,"Does the analysis ensure that the number and scope of organisations contacted is sufficiently wide?",null,null,"YES",null,{"$f":"+IF(F316=\"YES\",1,0)","v":1},1,null,{"$f":"I316/$I$284","v":4.5454545454545456E-2}]
[]
[null,null,"Have the findings of the analysis been taken into account in the technical features and contractual arrangements of the project?",null,null,"YES",null,{"$f":"+IF(F318=\"YES\",1,0)","v":1},2,null,{"$f":"I318/$I$284","v":9.0909090909090912E-2},null,{"$f":"+IF(F318=\"YES\",10,0)","v":10}]
[]
[null,null,"Does the overall analysis of the market assess whether there is likely to be a strong level of competition between bidders in the procurement of the project?",null,null,"YES",null,{"$f":"+IF(F320=\"YES\",1,0)","v":1},3,null,{"$f":"I320/$I$284","v":0.13636363636363635},null,{"$f":"+IF(F320=\"YES\",10,0)","v":10}]
[]
[null,null,"Has the assessment included a focus on identifying constraints to strong competition?",null,null,"YES",null,{"$f":"+IF(F322=\"YES\",1,0)","v":1},3,null,{"$f":"I322/$I$284","v":0.13636363636363635},null,{"$f":"+IF(F322=\"YES\",10,0)","v":10}]
[]
[]
[]
[null,null,"Assessing the PPP option against alternative project delivery options",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H330","v":1},null,null,null,null,{"$f":"+M330","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"IF($F$332=\"YES\",I334,0)+SUM($I$336:$I$348)","v":20}]
[]
[null,null,"Has the PPP option been compared against alternative private and public project delivery options?",null,null,"YES",null,{"$f":"+IF(F330=\"YES\",1+SUM(H334:H348),0)","v":1},null,{"$f":"SUM(J332:J348)","v":-1},null,null,{"$f":"+IF(F330=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Is there a mandatory approach to carrying out this comparison assessment?",null,"YES"]
[]
[null,null,null,"      If yes, has this approach been applied?",null,"YES",null,{"$f":"+IF(OR(AND(F334=\"YES\",F332=\"YES\"),F332=\"--Please Select--\"),0,J334)","v":0},3,{"$f":"-I334/$I$328","v":-0.15}]
[]
[null,null,null,"Has the assessment involved a comparison of the overall long-term cost of various project delivery options of similar scope and service requirements?",null,"YES",null,{"$f":"+IF(F336=\"YES\",0,J336)","v":0},3,{"$f":"-I336/$I$328","v":-0.15}]
[]
[null,null,null,"Has this assessment valued the impact of risks associated with each project delivery option?",null,"YES",null,{"$f":"+IF(F338=\"YES\",0,J338)","v":0},3,{"$f":"-I338/$I$328","v":-0.15}]
[]
[null,null,null,"Has this assessment considered qualitative factors for each project delivery option, such as scope for flexibility, opportunities for innovation, management and organisational consequences for the Authority, commencement of service? ",null,"YES",null,{"$f":"+IF(F340=\"YES\",0,J340)","v":0},3,{"$f":"-I340/$I$328","v":-0.15}]
[]
[null,null,null,"Has this assessment been based on evidence available from previous projects?",null,"YES",null,{"$f":"+IF(F342=\"YES\",0,J342)","v":0},1,{"$f":"-I342/$I$328","v":-0.05}]
[]
[null,"∞ ",null,"Has the assessment included the level of competition in the market for each project delivery option ? (see Market sounding and bankability analysis)",null,"YES",null,{"$f":"+IF(F344=\"YES\",0,J344)","v":0},2,{"$f":"-I344/$I$328","v":-0.1}]
[]
[null,"∞ ",null,"Have the capacity and resources of the project team to manage each project delivery option been assessed? (see Setting up a project team and a governance structure)",null,"YES",null,{"$f":"+IF(F346=\"YES\",0,J346)","v":0},3,{"$f":"-I346/$I$328","v":-0.15}]
[]
[null,"∞ ",null,"Has the timetable of each project delivery option been assessed with respect  to the required deadline? (see Developing a plan and a timetable)",null,"YES",null,{"$f":"+IF(F348=\"YES\",0,J348)","v":0},2,{"$f":"-I348/$I$328","v":-0.1}]
[]
[]
[null,null,"Budgeting, accounting and statistical treatment",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H355*K355+H357*K357+IF(F359=\"YES\",H361*K361+H363*K363,0)","v":1},null,null,null,null,{"$f":"+AVERAGE(M355:M360)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F359=\"YES\",SUM($I$361,$I$363),0)+SUM($I$355:$I$357)","v":8}]
[]
[null,null,"Has an assessment of the impact of the project on the Authority’s budget been carried out in accordance with the Authority’s own budgeting rules?",null,null,"YES",null,{"$f":"+IF(F355=\"YES\",1,0)","v":1},3,null,{"$f":"I355/$I$353","v":0.375},null,{"$f":"+IF(F355=\"YES\",10,0)","v":10}]
[]
[null,null,"Has an analysis of the likely accounting treatment of the project in the Authority’s financial statements been carried out?",null,null,"YES",null,{"$f":"+IF(F357=\"YES\",1,0)","v":1},2,null,{"$f":"I357/$I$353","v":0.25},null,{"$f":"+IF(F357=\"YES\",10,0)","v":10}]
[]
[null,null,"Is the country subject to Eurostat's European System of Accounts?",null,null,"YES",null,null,null,null,null,null,{"$f":"+IF((AND(F359=\"YES\",F361=\"YES\",F363=\"YES\")),10,\"\")","v":10}]
[]
[null,null,null,"If yes, has an analysis of the likely statistical treatment of the project (in accordance with Eurostat rules on PPPs and concessions) been carried out?",null,"YES",null,{"$f":"+IF(AND(F361=\"YES\",F359=\"YES\"),1,0)","v":1},2,null,{"$f":"I361/$I$353","v":0.25}]
[]
[null,"∞ ",null,"If yes, has this analysis been performed with the support of the Advisers or the national statistical office? (see Setting up a project team and a governance structure)",null,"YES",null,{"$f":"+IF(AND(F363=\"YES\",F359=\"YES\"),1,0)","v":1},1,null,{"$f":"I363/$I$353","v":0.125}]
[]
[]
[]
[null,null,"Preparing for procurement"]
[]
[]
[null,null,"Selecting the procurement approach",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"+H374","v":1},null,null,null,null,{"$f":"+M415","v":10}]
[]
[]
[null,null,"Has an analysis been carried out to select the most appropriate procurement approach (e.g. competitive dialogue, negotiated procedure) for the project? ",null,null,"YES",null,{"$f":"+IF(F374=\"YES\",1+SUM(H376:H380),0)","v":1},null,{"$f":"SUM(J376:J380)","v":-1},null,null,{"$f":"+IF(F374=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has this analysis considered the requirements of the applicable legislation (e.g. national public procurement legislation)? ",null,"YES",null,{"$f":"+IF(F376=\"YES\",0,J376)","v":0},3,{"$f":"-I376/SUM($I$376:$I$380)","v":-0.33333333333333331}]
[]
[null,null,null,"Has this analysis considered the features of the project (e.g. complexity, size) as well as the willingness and capacity of the Authority to predefine the technical and contractual solutions?",null,"YES",null,{"$f":"+IF(F378=\"YES\",0,J378)","v":0},3,{"$f":"-I378/SUM($I$376:$I$380)","v":-0.33333333333333331}]
[]
[null,"∞ ",null,"Has this analysis considered the capacity of the Authority to manage the procurement  approach (see Setting up a project team and governance structure)?",null,"YES",null,{"$f":"+IF(F380=\"YES\",0,J380)","v":0},3,{"$f":"-I380/SUM($I$376:$I$380)","v":-0.33333333333333331}]
[]
[]
[null,null,"Defining the procurement process",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H387*K387+H395*K395+H405*K405+H415*K415+H417*K417","v":1},null,null,null,null,{"$f":"+AVERAGE(M395,M405)","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"I387+I395+I405+I415+I417","v":10}]
[]
[null,null,"Has an analysis been carried out to define the pre-qualification criteria to be used in the selection of the potential bidders? ",null,null,"YES",null,{"$f":"+IF(F387=\"YES\",1+SUM(H389:H393),0)","v":1},2,{"$f":"SUM(J389:J393)","v":-0.99999999999999989},{"$f":"I387/$I$385","v":0.2},null,{"$f":"+IF(F387=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has this analysis considered how the technical, financial and legal capacities of potential bidders will be appraised?",null,"YES",null,{"$f":"+IF(F389=\"YES\",0,J389)","v":0},3,{"$f":"-I389/SUM($I$389:$I$393)","v":-0.5}]
[]
[null,null,null,"Has a pre-qualification questionnaire been prepared that describes the information that must be provided by potential bidders?",null,"YES",null,{"$f":"+IF(F391=\"YES\",0,J391)","v":0},2,{"$f":"-I391/SUM($I$389:$I$393)","v":-0.33333333333333331}]
[]
[null,null,null,"Has this analysis considered the maximum number of potential bidders that may be pre-qualified?",null,"YES",null,{"$f":"+IF(F393=\"YES\",0,J393)","v":0},1,{"$f":"-I393/SUM($I$389:$I$393)","v":-0.16666666666666666}]
[]
[null,null,"Has an analysis been carried out to define and support the selection of the tender evaluation criteria? ",null,null,"YES",null,{"$f":"+IF(F395=\"YES\",1+SUM(H397:H403),0)","v":1},3,{"$f":"SUM(J397:J403)","v":-1},{"$f":"I395/$I$385","v":0.3},null,{"$f":"+IF(F395=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Has this analysis considered technical, financial and legal aspects as areas for evaluation?",null,"YES",null,{"$f":"+IF(F397=\"YES\",0,J397)","v":0},3,{"$f":"-I397/SUM($I$397:$I$403)","v":-0.33333333333333331}]
[]
[null,null,null,"Has this analysis identified a scoring and weighting mechanism for each of the evaluation criteria? ",null,"YES",null,{"$f":"+IF(F399=\"YES\",0,J399)","v":0},2,{"$f":"-I399/SUM($I$397:$I$403)","v":-0.22222222222222221}]
[]
[null,null,null,"Have the criteria, scoring and weighting been checked to reflect the Authority's priorities (e.g. functionality, price, aesthetics)?",null,"YES",null,{"$f":"+IF(F401=\"YES\",0,J401)","v":0},2,{"$f":"-I401/SUM($I$397:$I$403)","v":-0.22222222222222221}]
[]
[null,null,null,"Has the project steering committee/senior management approved the selection criteria?",null,"YES",null,{"$f":"+IF(F403=\"YES\",0,J403)","v":0},2,{"$f":"-I403/SUM($I$397:$I$403)","v":-0.22222222222222221}]
[]
[null,null,"Has a tender evaluation team been established? ",null,null,"YES",null,{"$f":"+IF(F405=\"YES\",1+SUM(H407:H413),0)","v":1},1,{"$f":"SUM(J407:J413)","v":-1},{"$f":"I405/$I$385","v":0.1},null,{"$f":"+IF(F405=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Have the members of the tender evaluation team been identified taking into account their capability?",null,"YES",null,{"$f":"+IF(F407=\"YES\",0,J407)","v":0},3,{"$f":"-I407/SUM($I$407:$I$413)","v":-0.3}]
[]
[null,null,null,"Have the persons within the team that will be in charge of evaluating each criterion been nominated?",null,"YES",null,{"$f":"+IF(F409=\"YES\",0,J409)","v":0},2,{"$f":"-I409/SUM($I$407:$I$413)","v":-0.2}]
[]
[null,null,null,"Have potential conflict of interest issues been addressed when establishing the tender evaluation team?",null,"YES",null,{"$f":"+IF(F411=\"YES\",0,J411)","v":0},3,{"$f":"-I411/SUM($I$407:$I$413)","v":-0.3}]
[]
[null,null,null,"Have governance arrangements for the operation of the tender evaluation team and decision-making processes been established and approved?",null,"YES",null,{"$f":"+IF(F413=\"YES\",0,J413)","v":0},2,{"$f":"-I413/SUM($I$407:$I$413)","v":-0.2}]
[]
[null,null,"Have a project promotion plan (e.g. road shows) and a procurement notice been prepared taking into account the technical features and contractual arrangements of the project in order to raise interest of the market?",null,null,"YES",null,{"$f":"+IF(F415=\"YES\",1,0)","v":1},2,null,{"$f":"I415/$I$385","v":0.2},null,{"$f":"+IF(F415=\"YES\",10,0)","v":10}]
[]
[null,null,"Have the draft documents comprising the invitation to tender been prepared? ",null,null,"YES",null,{"$f":"+IF(F417=\"YES\",1+SUM(H419:H421),0)","v":1},2,{"$f":"SUM(J419:J421)","v":-1},{"$f":"I417/$I$385","v":0.2},null,{"$f":"+IF(F417=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Do these documents describe the key rules, steps and the requirements to be met (e.g. confidentiality undertakings, deadlines and heads of terms of the key agreements)?",null,"YES",null,{"$f":"+IF(F419=\"YES\",0,J419)","v":0},3,{"$f":"-I419/SUM($I$419:$I$421)","v":-0.5}]
[]
[null,null,null,"Do these documents provide potential bidders with sufficient background information to help them understand the project features and the Authority’s requirements (e.g. project information memorandum, document dataroom)?",null,"YES",null,{"$f":"+IF(F421=\"YES\",0,J421)","v":0},3,{"$f":"-I421/SUM($I$419:$I$421)","v":-0.5}]
[]
[]
[null,null,"Developing the service output requirements and preparing the draft PPP contract",null,null,null,null,"Score","Importance","Weight 2","Weight 1",null,"You said"]
[null,null,null,null,null,null,null,{"$f":"H428*K428+H436*K436","v":1},null,null,null,null,{"$f":"+M436","v":0}]
[]
[]
[null,null,"Have the service output requirements and payment mechanism been developed? ",null,null,"YES",null,{"$f":"+IF(F428=\"YES\",1+SUM(H430:H434),0)","v":1},3,{"$f":"SUM(J430:J434)","v":-1},{"$f":"I428/($I$428+$I$436)","v":0.5},null,{"$f":"+IF(F428=\"YES\",10,0)","v":10}]
[null,null,"If yes:"]
[null,null,null,"Have the service output requirements been checked to ensure that they continue reflect the need for the investment?",null,"YES",null,{"$f":"+IF(F430=\"YES\",0,J430)","v":0},3,{"$f":"-I430/SUM($I$430:$I$434)","v":-0.375}]
[]
[null,null,null,"Has the payment mechanism been designed to provide the appropriate incentives for the private partner to deliver the service output requirements?",null,"YES",null,{"$f":"+IF(F432=\"YES\",0,J432)","v":0},3,{"$f":"-I432/SUM($I$430:$I$434)","v":-0.375}]
[]
[null,null,null,"Has the payment mechanism been assessed to be consistent with the Affordability, Market Sounding and Bankability Analyses?",null,"YES",null,{"$f":"+IF(F434=\"YES\",0,J434)","v":0},2,{"$f":"-I434/SUM($I$430:$I$434)","v":-0.25}]
[]
[null,null,"When preparing the draft PPP contract have the following matters been taken into consideration:",null,null,null,null,{"$f":"1+SUM(H438:H468)","v":1},3,{"$f":"SUM(J438:J468)","v":-1},{"$f":"I436/($I$428+$I$436)","v":0.5},null,{"$f":"+IF(F436=\"YES\",10,0)","v":0}]
[]
[null,null,null,"Duration of the PPP contract?",null,"YES",null,{"$f":"+IF(F438=\"YES\",0,J438)","v":0},2,{"$f":"-I438/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,"∞ ",null,"Allocation and sharing of the risks? (see Developing the risk analysis)",null,"YES",null,{"$f":"+IF(F440=\"YES\",0,J440)","v":0},3,{"$f":"-I440/SUM($I$438:$I$468)","v":-8.1081081081081086E-2}]
[]
[null,null,null,"Performance requirements set by the Authority? ",null,"YES",null,{"$f":"+IF(F442=\"YES\",0,J442)","v":0},3,{"$f":"-I442/SUM($I$438:$I$468)","v":-8.1081081081081086E-2}]
[]
[null,null,null,"Payment mechanism?",null,"YES",null,{"$f":"+IF(F444=\"YES\",0,J444)","v":0},3,{"$f":"-I444/SUM($I$438:$I$468)","v":-8.1081081081081086E-2}]
[]
[null,null,null,"Procedure for dealing with changes (e.g. price indexation, changes to the service requirements)?",null,"YES",null,{"$f":"+IF(F446=\"YES\",0,J446)","v":0},3,{"$f":"-I446/SUM($I$438:$I$468)","v":-8.1081081081081086E-2}]
[]
[null,null,null,"Construction completion procedure?",null,"YES",null,{"$f":"+IF(F448=\"YES\",0,J448)","v":0},2,{"$f":"-I448/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Force majeure events?",null,"YES",null,{"$f":"+IF(F450=\"YES\",0,J450)","v":0},2,{"$f":"-I450/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Transfer of staff to the private partner?",null,"YES",null,{"$f":"+IF(F452=\"YES\",0,J452)","v":0},2,{"$f":"-I452/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Monitoring requirements of the Authority during the contract life?",null,"YES",null,{"$f":"+IF(F454=\"YES\",0,J454)","v":0},2,{"$f":"-I454/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Direct agreement with the lenders and lenders’ step-in rights?",null,"YES",null,{"$f":"+IF(F456=\"YES\",0,J456)","v":0},2,{"$f":"-I456/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Authority step-in rights?",null,"YES",null,{"$f":"+IF(F458=\"YES\",0,J458)","v":0},2,{"$f":"-I458/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Dispute resolution?",null,"YES",null,{"$f":"+IF(F460=\"YES\",0,J460)","v":0},2,{"$f":"-I460/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Insurance requirements?",null,"YES",null,{"$f":"+IF(F462=\"YES\",0,J462)","v":0},2,{"$f":"-I462/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Sharing of benefits arising from refinancing?",null,"YES",null,{"$f":"+IF(F464=\"YES\",0,J464)","v":0},2,{"$f":"-I464/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,"Early termination of the PPP contract and compensation payments?",null,"YES",null,{"$f":"+IF(F466=\"YES\",0,J466)","v":0},3,{"$f":"-I466/SUM($I$438:$I$468)","v":-8.1081081081081086E-2}]
[]
[null,null,null,"Hand-back of the project assets at expiry of the PPP contract?",null,"YES",null,{"$f":"+IF(F468=\"YES\",0,J468)","v":0},2,{"$f":"-I468/SUM($I$438:$I$468)","v":-5.4054054054054057E-2}]
[]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,{"$f":"+AVERAGE(H425,H384,H371)","v":1}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,"READINESS TO PROCURE THE PROJECT",null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"→","Does the proposed project still address the needs of the contracting authority?",null,null,"YES"]
[]
[null,"→","Is a PPP approach still identified as the preferred delivery approach for the project?",null,null,"YES"]
[]
[null,"→","Is the PPP project considered affordable?",null,null,"YES"]
[]
[null,"→","Are the proposed contractual arrangements and procurement procedures likely to produce a strong competitive response from prospective bidders?",null,null,"YES"]
[]
[null,"→","Is there continued stakeholder support for the proejct ad for the PPP delivery approach?",null,null,"YES"]
[]
[null,"→","Is the contracting authority ready and prepared to manage the procurement phase and has it obtained the relevant project consents, approvals and authorisations?",null,null,"YES"]
[null,null,null,null,null,0,null,{"$f":"+IF(AND(F479=\"YES\",F481=\"YES\",F483=\"YES\",F485=\"YES\",F487=\"YES\",F489=\"YES\"),1,0)","v":1}]

{"sheet":"OVERALL ASSESSMENT","index":3,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OVERALL ASSESSMENT PAGE"]
[]
[]
[]
[null,"Now working on project:",{"$f":"QUESTIONNAIRE!E6","v":"Example2_2017-1-1"}]
[]
[]
[]
[null,null,null,null,null,null,1]
[null,"ACTIVITY",null,"STATUS",null,"section","Score"]
[]
[null,{"$f":"QUESTIONNAIRE!C27","v":"Selecting and defining the investment"},null,{"$f":"IF($G$10=1,G13,0)","v":0.99999999999999989},null,1,{"$f":"QUESTIONNAIRE!H77","v":0.99999999999999989}]
[]
[null,null,"Readiness to start preparing the project as a PPP",{"$f":"IF(AND(G15=1,G13=1)=TRUE,1,0)","v":0},null,{"$f":"IF(G15=1,1,0)","v":0},{"$f":"+QUESTIONNAIRE!H95","v":0}]
[]
[null,{"$f":"QUESTIONNAIRE!C101","v":"Managing and planning the process"}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C103","v":"       - Setting up a project team and governance structure"},null,{"$f":"IF($G$10=1,G18,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H104","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C155","v":"       - Managing authorisations"},null,{"$f":"IF($G$10=1,G19,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H156","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C170","v":"       - Developing a plan and a timetable"},null,{"$f":"IF($G$10=1,G20,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H171","v":1}]
[]
[null,{"$f":"QUESTIONNAIRE!$C$204","v":"Developing the PPP project"}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C206","v":"       - Developing the affordability analysis"},null,{"$f":"IF($G$10=1,G23,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H207","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C249","v":"       - Developing the risk analysis"},null,{"$f":"IF($G$10=1,G24,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H250","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C282","v":"       - Performing market sounding and bankability analysis"},null,{"$f":"IF($G$10=1,G25,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H283","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C326","v":"       - Assessing the PPP option against alternative project delivery options"},null,{"$f":"IF($G$10=1,G26,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H327","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C351","v":"       - Budgeting, accounting and statistical treatment"},null,{"$f":"IF($G$10=1,G27,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H352","v":1}]
[]
[null,{"$f":"QUESTIONNAIRE!C367","v":"Preparing for procurement"}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C370","v":"       - Selecting the procurement approach"},null,{"$f":"IF($G$10=1,G30,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H371","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C383","v":"       - Defining the procurement process"},null,{"$f":"IF($G$10=1,G31,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H384","v":1}]
[null,{"$f":"\"       - \"&QUESTIONNAIRE!C424","v":"       - Developing the service output requirements and preparing the draft PPP contract"},null,{"$f":"IF($G$10=1,G32,0)","v":1},null,2,{"$f":"QUESTIONNAIRE!H425","v":1}]
[]
[null,null,"Readiness to procure the project",{"$f":"IF(AND(D15=1,G18=1,G19=1,G20=1,G23=1,G24=1,G25=1,G26=1,G27=1,G30=1,G31=1,G32=1,G34=1)=TRUE,1,0)","v":0},null,{"$f":"IF(G34=1,2,0)","v":2},{"$f":"QUESTIONNAIRE!H490","v":1}]
[]
[]
[null,null,"All areas in the relevant activity are likely to be complete",{"$f":"+G37","v":1},null,null,1]
[null,null,"Some areas in the relevant activity may still need to be completed",{"$f":"+G38","v":0.7},null,null,0.7]
[null,null,"Many areas in the relevant activity may still need to be completed",0.4,null,null,0.4]
[null,null,"No areas in the relevant activity are currently completed",{"$f":"+G40","v":0},null,null,0]

{"sheet":"PROJECT2LOAD","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Chose the project you want to load"]
[]
[null,"Example2_2017-1-1"]

{"sheet":"DATABASE","index":5,"n_rows":509,"n_cols":12,"rows_kept":509,"cut":false,"hidden":false,"merged":[[138,3,138,4],[114,2,114,4],[140,2,140,4],[106,2,106,4],[139,3,139,4],[116,3,116,4],[124,3,124,4],[203,1,203,3],[158,2,158,4],[142,3,142,4],[143,3,143,4],[144,3,144,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[148,3,148,4],[149,3,149,4],[150,3,150,4],[160,3,160,4],[161,3,161,4],[162,3,162,4],[163,3,163,4],[164,3,164,4],[165,3,165,4],[97,0,97,4],[53,3,53,4],[45,2,45,4],[35,3,35,4],[37,3,37,4],[38,3,38,4],[43,3,43,4],[47,3,47,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[73,3,73,4],[65,2,65,4],[54,2,54,4],[55,2,55,4],[57,3,57,4],[84,2,84,4],[87,2,87,4],[89,2,89,4],[85,2,85,4],[86,2,86,4],[92,2,92,4],[88,2,88,4],[166,3,166,4],[181,2,181,4],[173,2,173,4],[209,2,209,4],[183,3,183,4],[184,3,184,4],[185,3,185,4],[186,3,186,4],[187,3,187,4],[188,3,188,4],[189,3,189,4],[190,3,190,4],[191,3,191,4],[192,3,192,4],[193,3,193,4],[194,3,194,4],[195,3,195,4],[196,3,196,4],[197,3,197,4],[198,3,198,4],[270,2,270,4],[211,3,211,4],[212,3,212,4],[214,3,214,4],[215,3,215,4],[216,3,216,4],[238,3,238,4],[239,3,239,4],[229,3,229,4],[230,3,230,4],[231,3,231,4],[232,3,232,4],[234,3,234,4],[224,3,224,4],[225,3,225,4],[226,3,226,4],[227,3,227,4],[228,3,228,4],[235,3,235,4],[236,3,236,4],[237,3,237,4],[213,3,213,4],[217,3,217,4],[218,3,218,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[223,3,223,4],[245,3,245,4],[240,3,240,4],[241,3,241,4],[242,3,242,4],[243,3,243,4],[244,3,244,4],[219,3,219,4],[233,3,233,4],[329,2,329,4],[299,2,299,4],[285,2,285,4],[287,3,287,4],[288,3,288,4],[289,3,289,4],[295,3,295,4],[296,3,296,4],[297,3,297,4],[301,3,301,4],[309,3,309,4],[311,3,311,4],[302,3,302,4],[303,3,303,4],[304,3,304,4],[305,3,305,4],[306,3,306,4],[307,3,307,4],[308,3,308,4],[313,2,313,4],[314,2,314,4],[315,2,315,4],[316,2,316,4],[317,2,317,4],[318,2,318,4],[320,2,320,4],[321,2,321,4],[319,2,319,4],[355,2,355,4],[356,2,356,4],[357,2,357,4],[358,2,358,4],[331,3,331,4],[332,3,332,4],[333,3,333,4],[334,3,334,4],[335,3,335,4],[336,3,336,4],[337,3,337,4],[338,3,338,4],[340,3,340,4],[342,3,342,4],[343,3,343,4],[344,3,344,4],[339,3,339,4],[341,3,341,4],[354,2,354,4],[346,3,346,4],[347,3,347,4],[345,3,345,4],[375,3,375,4],[376,3,376,4],[378,3,378,4],[360,3,360,4],[361,3,361,4],[362,3,362,4],[399,3,399,4],[400,3,400,4],[401,3,401,4],[373,2,373,4],[377,3,377,4],[379,3,379,4],[386,2,386,4],[402,3,402,4],[388,3,388,4],[389,3,389,4],[391,3,391,4],[392,3,392,4],[390,3,390,4],[463,3,463,4],[464,3,464,4],[465,3,465,4],[394,2,394,4],[406,3,406,4],[407,3,407,4],[408,3,408,4],[409,3,409,4],[410,3,410,4],[411,3,411,4],[412,3,412,4],[396,3,396,4],[397,3,397,4],[398,3,398,4],[452,3,452,4],[453,3,453,4],[454,3,454,4],[455,3,455,4],[456,3,456,4],[457,3,457,4],[414,2,414,4],[467,3,467,4],[458,3,458,4],[459,3,459,4],[460,3,460,4],[461,3,461,4],[462,3,462,4],[429,3,429,4],[430,3,430,4],[431,3,431,4],[432,3,432,4],[416,2,416,4],[450,3,450,4],[451,3,451,4],[484,2,484,4],[486,2,486,4],[488,2,488,4],[404,2,404,4],[433,3,433,4],[437,3,437,4],[438,3,438,4],[439,3,439,4],[440,3,440,4],[441,3,441,4],[442,3,442,4],[443,3,443,4],[444,3,444,4],[445,3,445,4],[446,3,446,4],[418,3,418,4],[420,3,420,4],[478,2,478,4],[480,2,480,4],[482,2,482,4],[447,3,447,4],[448,3,448,4],[449,3,449,4],[466,3,466,4],[6,1,7,2],[39,3,39,4],[10,1,10,4],[67,3,67,4],[110,3,110,4],[93,2,93,4],[83,2,83,4],[90,2,90,4],[91,2,91,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[17,2,17,4],[19,2,19,4],[21,2,21,4],[23,2,23,4],[26,0,26,4],[33,2,33,4],[278,2,278,4],[291,2,291,4],[293,2,293,4],[268,2,268,4],[275,2,275,4],[276,2,276,4],[277,2,277,4],[252,2,252,4],[262,2,262,4],[254,3,254,4],[255,3,255,4],[256,3,256,4],[257,3,257,4],[258,3,258,4],[259,3,259,4],[260,3,260,4],[264,3,264,4],[265,3,265,4],[266,3,266,4],[269,2,269,4],[271,2,271,4],[272,2,272,4],[273,2,273,4],[274,2,274,4]]}
[]
[]
[]
[null,"DATABASE"]
[]
[null,"NOW READING:",null,{"$f":"+PROJECT2LOAD!B5","v":"Example2_2017-1-1"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"DO NOT DELETE COLUMN"]
[null,null,null,null,null,null,null,null,"Number of ROW"]
[]
[{"$f":"+QUESTIONNAIRE!C12","v":"General Information"},null,null,null,{"$f":"+QUESTIONNAIRE!E12","v":0},{"$f":"+QUESTIONNAIRE!F12","v":0},null,null,null,null,0]
[{"$f":"+QUESTIONNAIRE!A13","v":0},{"$f":"+QUESTIONNAIRE!B13","v":0},{"$f":"+QUESTIONNAIRE!C13","v":0},{"$f":"+QUESTIONNAIRE!D13","v":0},{"$f":"+QUESTIONNAIRE!E13","v":0},{"$f":"+QUESTIONNAIRE!F13","v":0},null,{"$f":"+QUESTIONNAIRE!$F$18&\"_\"&YEAR(QUESTIONNAIRE!$F$20)&\"-\"&MONTH(QUESTIONNAIRE!$F$20)&\"-\"&DAY(QUESTIONNAIRE!$F$20)","v":"Example2_2017-1-1"},1,"NEW PROJECT","Example1_2014-1-1","Example2_2017-1-1"]
[{"$f":"+QUESTIONNAIRE!A14","v":0},{"$f":"+QUESTIONNAIRE!B14","v":0},{"$f":"+QUESTIONNAIRE!C14","v":0},{"$f":"+QUESTIONNAIRE!D14","v":0},{"$f":"+QUESTIONNAIRE!E14","v":0},null,null,null,{"$f":"+I13+1","v":2}]
[{"$f":"+QUESTIONNAIRE!A15","v":0},{"$f":"+QUESTIONNAIRE!B15","v":0},{"$f":"+QUESTIONNAIRE!C15","v":0},{"$f":"+QUESTIONNAIRE!D15","v":0},{"$f":"+QUESTIONNAIRE!E15","v":0},null,null,null,{"$f":"+I14+1","v":3}]
[{"$f":"+QUESTIONNAIRE!A16","v":0},{"$f":"+QUESTIONNAIRE!B16","v":0},{"$f":"+QUESTIONNAIRE!C16","v":0},{"$f":"+QUESTIONNAIRE!D16","v":0},{"$f":"+QUESTIONNAIRE!E16","v":0},null,null,null,4]
[{"$f":"+QUESTIONNAIRE!A17","v":0},{"$f":"+QUESTIONNAIRE!B17","v":0},{"$f":"+QUESTIONNAIRE!C17","v":0},{"$f":"+QUESTIONNAIRE!D17","v":0},{"$f":"+QUESTIONNAIRE!E17","v":0},null,null,null,5]
[{"$f":"+QUESTIONNAIRE!A18","v":0},{"$f":"+QUESTIONNAIRE!B18","v":0},{"$f":"+QUESTIONNAIRE!C18","v":"Project  name"},null,null,{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I18,FALSE)","v":"Example2"},null,null,6,"NAME","Example1","Example2"]
[{"$f":"+QUESTIONNAIRE!A19","v":0},{"$f":"+QUESTIONNAIRE!B19","v":0},{"$f":"+QUESTIONNAIRE!C19","v":0},{"$f":"+QUESTIONNAIRE!D19","v":0},{"$f":"+QUESTIONNAIRE!E19","v":0},null,null,null,7,"DD/MM/YY","DD/MM/YY","DD/MM/YY"]
[{"$f":"+QUESTIONNAIRE!A20","v":"00:00:00"},{"$f":"+QUESTIONNAIRE!B20","v":"00:00:00"},{"$f":"+QUESTIONNAIRE!C20","v":"Assessment date"},{"$f":"+QUESTIONNAIRE!D20","v":"00:00:00"},{"$f":"+QUESTIONNAIRE!E20","v":"00:00:00"},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I20,FALSE)","v":"2017-01-01"},null,null,8,"2017-01-01","2014-01-01","2017-01-01"]
[{"$f":"+QUESTIONNAIRE!A21","v":0},{"$f":"+QUESTIONNAIRE!B21","v":0},{"$f":"+QUESTIONNAIRE!C21","v":0},{"$f":"+QUESTIONNAIRE!D21","v":0},{"$f":"+QUESTIONNAIRE!E21","v":0},null,null,null,9]
[{"$f":"+QUESTIONNAIRE!A22","v":0},{"$f":"+QUESTIONNAIRE!B22","v":0},{"$f":"+QUESTIONNAIRE!C22","v":"Procuring authority's name "},{"$f":"+QUESTIONNAIRE!D22","v":0},{"$f":"+QUESTIONNAIRE!E22","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I22,FALSE)","v":"PROCURING AUTHORITY"},null,null,10,"PROCURING AUTHORITY","PROCURING AUTHORITY","PROCURING AUTHORITY"]
[{"$f":"+QUESTIONNAIRE!A23","v":0},{"$f":"+QUESTIONNAIRE!B23","v":0},{"$f":"+QUESTIONNAIRE!C23","v":0},{"$f":"+QUESTIONNAIRE!D23","v":0},{"$f":"+QUESTIONNAIRE!E23","v":0},null,null,null,11]
[{"$f":"+QUESTIONNAIRE!A24","v":0},{"$f":"+QUESTIONNAIRE!B24","v":0},{"$f":"+QUESTIONNAIRE!C24","v":"Basic project description"},{"$f":"+QUESTIONNAIRE!D24","v":0},{"$f":"+QUESTIONNAIRE!E24","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I24,FALSE)","v":"NEW PROJECT"},null,null,12,"NEW PROJECT","NEW PROJECT","NEW PROJECT"]
[{"$f":"+QUESTIONNAIRE!A25","v":0},{"$f":"+QUESTIONNAIRE!B25","v":0},{"$f":"+QUESTIONNAIRE!C25","v":0},{"$f":"+QUESTIONNAIRE!D25","v":0},{"$f":"+QUESTIONNAIRE!E25","v":0},null,null,null,13]
[{"$f":"+QUESTIONNAIRE!A26","v":0},{"$f":"+QUESTIONNAIRE!B26","v":0},{"$f":"+QUESTIONNAIRE!C26","v":0},{"$f":"+QUESTIONNAIRE!D26","v":0},{"$f":"+QUESTIONNAIRE!E26","v":0},null,null,null,14]
[{"$f":"+QUESTIONNAIRE!C27","v":"Selecting and defining the investment"},null,null,null,null,null,null,null,15]
[{"$f":"+QUESTIONNAIRE!A28","v":0},{"$f":"+QUESTIONNAIRE!B28","v":0},{"$f":"+QUESTIONNAIRE!C28","v":0},{"$f":"+QUESTIONNAIRE!D28","v":0},{"$f":"+QUESTIONNAIRE!E28","v":0},null,null,null,16]
[{"$f":"+QUESTIONNAIRE!A29","v":0},{"$f":"+QUESTIONNAIRE!B29","v":0},{"$f":"+QUESTIONNAIRE!C29","v":0},{"$f":"+QUESTIONNAIRE!D29","v":0},{"$f":"+QUESTIONNAIRE!E29","v":0},null,null,null,17]
[{"$f":"+QUESTIONNAIRE!A30","v":0},{"$f":"+QUESTIONNAIRE!B30","v":0},{"$f":"+QUESTIONNAIRE!C30","v":0},{"$f":"+QUESTIONNAIRE!D30","v":0},{"$f":"+QUESTIONNAIRE!E30","v":0},null,null,null,18]
[{"$f":"+QUESTIONNAIRE!A31","v":0},{"$f":"+QUESTIONNAIRE!B31","v":0},{"$f":"+QUESTIONNAIRE!C31","v":0},{"$f":"+QUESTIONNAIRE!D31","v":0},{"$f":"+QUESTIONNAIRE!E31","v":0},null,null,null,19]
[{"$f":"+QUESTIONNAIRE!A32","v":0},{"$f":"+QUESTIONNAIRE!B32","v":0},{"$f":"+QUESTIONNAIRE!C32","v":0},{"$f":"+QUESTIONNAIRE!D32","v":0},{"$f":"+QUESTIONNAIRE!E32","v":0},null,null,null,20]
[{"$f":"+QUESTIONNAIRE!A33","v":0},{"$f":"+QUESTIONNAIRE!B33","v":0},{"$f":"+QUESTIONNAIRE!C33","v":0},{"$f":"+QUESTIONNAIRE!D33","v":0},{"$f":"+QUESTIONNAIRE!E33","v":0},null,null,null,21]
[{"$f":"+QUESTIONNAIRE!A34","v":0},{"$f":"+QUESTIONNAIRE!B34","v":0},{"$f":"+QUESTIONNAIRE!C34","v":"Has the need for the investment been identified in a regional/national infrastructure plan or sector investment programme?"},{"$f":"+QUESTIONNAIRE!D34","v":0},{"$f":"+QUESTIONNAIRE!E34","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I34,FALSE)","v":"YES"},null,null,22,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A35","v":0},{"$f":"+QUESTIONNAIRE!B35","v":0},{"$f":"+QUESTIONNAIRE!C35","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D35","v":0},{"$f":"+QUESTIONNAIRE!E35","v":0},null,null,null,23]
[{"$f":"+QUESTIONNAIRE!A36","v":0},{"$f":"+QUESTIONNAIRE!B36","v":0},{"$f":"+QUESTIONNAIRE!C36","v":0},{"$f":"+QUESTIONNAIRE!D36","v":"Has the infrastructure plan/sector investment programme been approved by the national or sub-national government?"},{"$f":"+QUESTIONNAIRE!E36","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I36,FALSE)","v":"YES"},null,null,24,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A37","v":0},{"$f":"+QUESTIONNAIRE!B37","v":0},{"$f":"+QUESTIONNAIRE!C37","v":0},{"$f":"+QUESTIONNAIRE!D37","v":0},{"$f":"+QUESTIONNAIRE!E37","v":0},null,null,null,25]
[{"$f":"+QUESTIONNAIRE!A38","v":0},{"$f":"+QUESTIONNAIRE!B38","v":0},{"$f":"+QUESTIONNAIRE!C38","v":0},{"$f":"+QUESTIONNAIRE!D38","v":"Are the potential funding sources to implement the investment  broadly identified in the infrastructure plan/investment programme?"},{"$f":"+QUESTIONNAIRE!E38","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I38,FALSE)","v":"YES"},null,null,26,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A39","v":0},{"$f":"+QUESTIONNAIRE!B39","v":0},{"$f":"+QUESTIONNAIRE!C39","v":0},{"$f":"+QUESTIONNAIRE!D39","v":0},{"$f":"+QUESTIONNAIRE!E39","v":0},null,null,null,27]
[{"$f":"+QUESTIONNAIRE!A40","v":0},{"$f":"+QUESTIONNAIRE!B40","v":0},{"$f":"+QUESTIONNAIRE!C40","v":0},{"$f":"+QUESTIONNAIRE!D40","v":"Is there any other related infrastructure that needs to be in place in order for the investment to be delivered?"},{"$f":"+QUESTIONNAIRE!E40","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I40,FALSE)","v":"YES"},null,null,28,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A41","v":0},{"$f":"+QUESTIONNAIRE!B41","v":0},{"$f":"+QUESTIONNAIRE!C41","v":0},{"$f":"+QUESTIONNAIRE!D41","v":0},{"$f":"+QUESTIONNAIRE!E41","v":0},null,null,null,29]
[{"$f":"+QUESTIONNAIRE!A42","v":0},{"$f":"+QUESTIONNAIRE!B42","v":0},{"$f":"+QUESTIONNAIRE!C42","v":0},{"$f":"+QUESTIONNAIRE!D42","v":"      If YES, have the other related infrastructure investments been planned/approved to be delivered in coordination with the investment?"},{"$f":"+QUESTIONNAIRE!E42","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I42,FALSE)","v":"YES"},null,null,30,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A43","v":0},{"$f":"+QUESTIONNAIRE!B43","v":0},{"$f":"+QUESTIONNAIRE!C43","v":0},{"$f":"+QUESTIONNAIRE!D43","v":0},{"$f":"+QUESTIONNAIRE!E43","v":0},null,null,null,31]
[{"$f":"+QUESTIONNAIRE!A44","v":0},{"$f":"+QUESTIONNAIRE!B44","v":0},{"$f":"+QUESTIONNAIRE!C44","v":0},{"$f":"+QUESTIONNAIRE!D44","v":"Has a check been carried out to determine whether the investment is part of an EU infrastructure development programme (e.g. TEN-T, TEN-E)? "},{"$f":"+QUESTIONNAIRE!E44","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I44,FALSE)","v":"YES"},null,null,32,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A45","v":0},{"$f":"+QUESTIONNAIRE!B45","v":0},{"$f":"+QUESTIONNAIRE!C45","v":0},{"$f":"+QUESTIONNAIRE!D45","v":0},{"$f":"+QUESTIONNAIRE!E45","v":0},null,null,null,33]
[{"$f":"+QUESTIONNAIRE!A46","v":0},{"$f":"+QUESTIONNAIRE!B46","v":0},{"$f":"+QUESTIONNAIRE!C46","v":"Has a preliminary study regarding the need for the investment been carried out?"},{"$f":"+QUESTIONNAIRE!D46","v":0},{"$f":"+QUESTIONNAIRE!E46","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I46,FALSE)","v":"YES"},null,null,34,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A47","v":0},{"$f":"+QUESTIONNAIRE!B47","v":0},{"$f":"+QUESTIONNAIRE!C47","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D47","v":0},{"$f":"+QUESTIONNAIRE!E47","v":0},null,null,null,35]
[{"$f":"+QUESTIONNAIRE!A48","v":0},{"$f":"+QUESTIONNAIRE!B48","v":0},{"$f":"+QUESTIONNAIRE!C48","v":0},{"$f":"+QUESTIONNAIRE!D48","v":"Has a recent analysis been carried out using a widely recognised methodology for cost-benefit analysis?"},{"$f":"+QUESTIONNAIRE!E48","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I48,FALSE)","v":"YES"},null,null,36,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A49","v":0},{"$f":"+QUESTIONNAIRE!B49","v":0},{"$f":"+QUESTIONNAIRE!C49","v":0},{"$f":"+QUESTIONNAIRE!D49","v":0},{"$f":"+QUESTIONNAIRE!E49","v":0},null,null,null,37]
[{"$f":"+QUESTIONNAIRE!A50","v":0},{"$f":"+QUESTIONNAIRE!B50","v":0},{"$f":"+QUESTIONNAIRE!C50","v":0},{"$f":"+QUESTIONNAIRE!D50","v":"Have different investment options been assessed and ranked?"},{"$f":"+QUESTIONNAIRE!E50","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I50,FALSE)","v":"YES"},null,null,38,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A51","v":0},{"$f":"+QUESTIONNAIRE!B51","v":0},{"$f":"+QUESTIONNAIRE!C51","v":0},{"$f":"+QUESTIONNAIRE!D51","v":0},{"$f":"+QUESTIONNAIRE!E51","v":0},null,null,null,39]
[{"$f":"+QUESTIONNAIRE!A52","v":0},{"$f":"+QUESTIONNAIRE!B52","v":0},{"$f":"+QUESTIONNAIRE!C52","v":0},{"$f":"+QUESTIONNAIRE!D52","v":"Has approval for the preferred investment option been sought from the appropriate authority?"},{"$f":"+QUESTIONNAIRE!E52","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I52,FALSE)","v":"YES"},null,null,40,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A53","v":0},{"$f":"+QUESTIONNAIRE!B53","v":0},{"$f":"+QUESTIONNAIRE!C53","v":0},{"$f":"+QUESTIONNAIRE!D53","v":0},{"$f":"+QUESTIONNAIRE!E53","v":0},null,null,null,41]
[{"$f":"+QUESTIONNAIRE!A54","v":0},{"$f":"+QUESTIONNAIRE!B54","v":0},{"$f":"+QUESTIONNAIRE!C54","v":0},{"$f":"+QUESTIONNAIRE!D54","v":"Is there evidence of political support for the preferred investment option?"},{"$f":"+QUESTIONNAIRE!E54","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I54,FALSE)","v":"YES"},null,null,42,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A55","v":0},{"$f":"+QUESTIONNAIRE!B55","v":0},{"$f":"+QUESTIONNAIRE!C55","v":0},{"$f":"+QUESTIONNAIRE!D55","v":0},{"$f":"+QUESTIONNAIRE!E55","v":0},null,null,null,43]
[{"$f":"+QUESTIONNAIRE!A56","v":0},{"$f":"+QUESTIONNAIRE!B56","v":0},{"$f":"+QUESTIONNAIRE!C56","v":"Have the interests of stakeholders been considered?"},{"$f":"+QUESTIONNAIRE!D56","v":0},{"$f":"+QUESTIONNAIRE!E56","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I56,FALSE)","v":"YES"},null,null,44,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A57","v":0},{"$f":"+QUESTIONNAIRE!B57","v":0},{"$f":"+QUESTIONNAIRE!C57","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D57","v":0},{"$f":"+QUESTIONNAIRE!E57","v":0},null,null,null,45]
[{"$f":"+QUESTIONNAIRE!A58","v":0},{"$f":"+QUESTIONNAIRE!B58","v":0},{"$f":"+QUESTIONNAIRE!C58","v":0},{"$f":"+QUESTIONNAIRE!D58","v":"Have the parties likely to be affected/concerned by the investment been identified (e.g. users, local residents)?"},{"$f":"+QUESTIONNAIRE!E58","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I58,FALSE)","v":"YES"},null,null,46,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A59","v":0},{"$f":"+QUESTIONNAIRE!B59","v":0},{"$f":"+QUESTIONNAIRE!C59","v":0},{"$f":"+QUESTIONNAIRE!D59","v":0},{"$f":"+QUESTIONNAIRE!E59","v":0},null,null,null,47]
[{"$f":"+QUESTIONNAIRE!A60","v":0},{"$f":"+QUESTIONNAIRE!B60","v":0},{"$f":"+QUESTIONNAIRE!C60","v":0},{"$f":"+QUESTIONNAIRE!D60","v":"Have the relevant stakeholders been consulted?"},{"$f":"+QUESTIONNAIRE!E60","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I60,FALSE)","v":"YES"},null,null,48,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A61","v":0},{"$f":"+QUESTIONNAIRE!B61","v":0},{"$f":"+QUESTIONNAIRE!C61","v":0},{"$f":"+QUESTIONNAIRE!D61","v":0},{"$f":"+QUESTIONNAIRE!E61","v":0},null,null,null,49]
[{"$f":"+QUESTIONNAIRE!A62","v":0},{"$f":"+QUESTIONNAIRE!B62","v":0},{"$f":"+QUESTIONNAIRE!C62","v":0},{"$f":"+QUESTIONNAIRE!D62","v":"Is there a process to ensure that the consultation feedback is taken into consideration throughout the project preparation process?"},{"$f":"+QUESTIONNAIRE!E62","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I62,FALSE)","v":"YES"},null,null,50,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A63","v":0},{"$f":"+QUESTIONNAIRE!B63","v":0},{"$f":"+QUESTIONNAIRE!C63","v":0},{"$f":"+QUESTIONNAIRE!D63","v":0},{"$f":"+QUESTIONNAIRE!E63","v":0},null,null,null,51]
[{"$f":"+QUESTIONNAIRE!A64","v":0},{"$f":"+QUESTIONNAIRE!B64","v":0},{"$f":"+QUESTIONNAIRE!C64","v":0},{"$f":"+QUESTIONNAIRE!D64","v":"Has a plan been established for the ongoing management of and communication with stakeholders?"},{"$f":"+QUESTIONNAIRE!E64","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I64,FALSE)","v":"YES"},null,null,52,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A65","v":0},{"$f":"+QUESTIONNAIRE!B65","v":0},{"$f":"+QUESTIONNAIRE!C65","v":0},{"$f":"+QUESTIONNAIRE!D65","v":0},{"$f":"+QUESTIONNAIRE!E65","v":0},null,null,null,53]
[{"$f":"+QUESTIONNAIRE!A66","v":0},{"$f":"+QUESTIONNAIRE!B66","v":0},{"$f":"+QUESTIONNAIRE!C66","v":"Has a preliminary assessment been carried out as to whether the technical and legal aspects of the investment are suitable to PPP? "},null,null,{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I66,FALSE)","v":"YES"},null,null,54,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A67","v":0},{"$f":"+QUESTIONNAIRE!B67","v":0},{"$f":"+QUESTIONNAIRE!C67","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D67","v":0},{"$f":"+QUESTIONNAIRE!E67","v":0},null,null,null,55]
[{"$f":"+QUESTIONNAIRE!A68","v":0},{"$f":"+QUESTIONNAIRE!B68","v":0},{"$f":"+QUESTIONNAIRE!C68","v":0},{"$f":"+QUESTIONNAIRE!D68","v":"Has the stability of the investment scope and output requirements over time been assessed?"},{"$f":"+QUESTIONNAIRE!E68","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I68,FALSE)","v":"YES"},null,null,56,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A69","v":0},{"$f":"+QUESTIONNAIRE!B69","v":0},{"$f":"+QUESTIONNAIRE!C69","v":0},{"$f":"+QUESTIONNAIRE!D69","v":0},{"$f":"+QUESTIONNAIRE!E69","v":0},null,null,null,57]
[{"$f":"+QUESTIONNAIRE!A70","v":0},{"$f":"+QUESTIONNAIRE!B70","v":0},{"$f":"+QUESTIONNAIRE!C70","v":0},{"$f":"+QUESTIONNAIRE!D70","v":"Has an analysis been carried out to demonstrate that the investment requirements can be broadly expressed in service output terms and translated in contractual provisions? "},{"$f":"+QUESTIONNAIRE!E70","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I70,FALSE)","v":"YES"},null,null,58,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A71","v":0},{"$f":"+QUESTIONNAIRE!B71","v":0},{"$f":"+QUESTIONNAIRE!C71","v":0},{"$f":"+QUESTIONNAIRE!D71","v":0},{"$f":"+QUESTIONNAIRE!E71","v":0},null,null,null,59]
[{"$f":"+QUESTIONNAIRE!A72","v":0},{"$f":"+QUESTIONNAIRE!B72","v":0},{"$f":"+QUESTIONNAIRE!C72","v":0},{"$f":"+QUESTIONNAIRE!D72","v":"Have these service output terms been developed taking into consideration existing precedents or available sector guidance?"},{"$f":"+QUESTIONNAIRE!E72","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I72,FALSE)","v":"YES"},null,null,60,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A73","v":0},{"$f":"+QUESTIONNAIRE!B73","v":0},{"$f":"+QUESTIONNAIRE!C73","v":0},{"$f":"+QUESTIONNAIRE!D73","v":0},{"$f":"+QUESTIONNAIRE!E73","v":0},null,null,null,61]
[{"$f":"+QUESTIONNAIRE!A74","v":0},{"$f":"+QUESTIONNAIRE!B74","v":0},{"$f":"+QUESTIONNAIRE!C74","v":0},{"$f":"+QUESTIONNAIRE!D74","v":"Has preliminary advice been sought to confirm that the Authority has the legal powers to procure and enter into the PPP contract and related agreements?"},{"$f":"+QUESTIONNAIRE!E74","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I74,FALSE)","v":"YES"},null,null,62,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A75","v":0},{"$f":"+QUESTIONNAIRE!B75","v":0},{"$f":"+QUESTIONNAIRE!C75","v":0},{"$f":"+QUESTIONNAIRE!D75","v":0},{"$f":"+QUESTIONNAIRE!E75","v":0},null,null,null,63]
[{"$f":"+QUESTIONNAIRE!A76","v":0},{"$f":"+QUESTIONNAIRE!B76","v":0},{"$f":"+QUESTIONNAIRE!C76","v":0},{"$f":"+QUESTIONNAIRE!D76","v":0},{"$f":"+QUESTIONNAIRE!E76","v":0},null,null,null,64]
[{"$f":"+QUESTIONNAIRE!A77","v":0},{"$f":"+QUESTIONNAIRE!B77","v":0},{"$f":"+QUESTIONNAIRE!C77","v":0},{"$f":"+QUESTIONNAIRE!D77","v":0},{"$f":"+QUESTIONNAIRE!E77","v":0},null,null,null,65]
[{"$f":"+QUESTIONNAIRE!A78","v":0},{"$f":"+QUESTIONNAIRE!B78","v":0},{"$f":"+QUESTIONNAIRE!C78","v":0},{"$f":"+QUESTIONNAIRE!D78","v":0},{"$f":"+QUESTIONNAIRE!E78","v":0},null,null,null,66]
[{"$f":"+QUESTIONNAIRE!A79","v":0},{"$f":"+QUESTIONNAIRE!B79","v":0},{"$f":"+QUESTIONNAIRE!C79","v":0},{"$f":"+QUESTIONNAIRE!D79","v":0},{"$f":"+QUESTIONNAIRE!E79","v":0},{"$f":"+QUESTIONNAIRE!F79","v":0},null,null,{"$f":"+I78+1","v":67},null,0]
[{"$f":"+QUESTIONNAIRE!A80","v":0},{"$f":"+QUESTIONNAIRE!B80","v":0},{"$f":"+QUESTIONNAIRE!#REF!","v":{"$error":"#REF!"}},{"$f":"+QUESTIONNAIRE!C80","v":"Readiness to start preparing the project as a PPP"},{"$f":"+QUESTIONNAIRE!E80","v":0},{"$f":"+QUESTIONNAIRE!F80","v":0},null,null,68,null,0]
[{"$f":"+QUESTIONNAIRE!A81","v":0},{"$f":"+QUESTIONNAIRE!B81","v":0},{"$f":"+QUESTIONNAIRE!C81","v":0},{"$f":"+QUESTIONNAIRE!D81","v":0},{"$f":"+QUESTIONNAIRE!E81","v":0},{"$f":"+QUESTIONNAIRE!F81","v":0},null,null,69,null,0]
[{"$f":"+QUESTIONNAIRE!A82","v":0},{"$f":"+QUESTIONNAIRE!B82","v":0},{"$f":"+QUESTIONNAIRE!C82","v":0},{"$f":"+QUESTIONNAIRE!D82","v":0},{"$f":"+QUESTIONNAIRE!E82","v":0},{"$f":"+QUESTIONNAIRE!F82","v":0},null,null,70,null,0]
[{"$f":"+QUESTIONNAIRE!A83","v":0},{"$f":"+QUESTIONNAIRE!B83","v":0},{"$f":"+QUESTIONNAIRE!C83","v":0},{"$f":"+QUESTIONNAIRE!D83","v":0},{"$f":"+QUESTIONNAIRE!E83","v":0},null,null,null,71]
[{"$f":"+QUESTIONNAIRE!A84","v":0},{"$f":"+QUESTIONNAIRE!B84","v":"→"},{"$f":"+QUESTIONNAIRE!C84","v":"Has the need for the project been clearly identified?"},{"$f":"+QUESTIONNAIRE!D84","v":0},{"$f":"+QUESTIONNAIRE!E84","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I84,FALSE)","v":"YES"},null,null,72,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A81","v":0},{"$f":"+QUESTIONNAIRE!B85","v":0},{"$f":"+QUESTIONNAIRE!C85","v":0},{"$f":"+QUESTIONNAIRE!D85","v":0},{"$f":"+QUESTIONNAIRE!E85","v":0},null,null,null,73]
[{"$f":"+QUESTIONNAIRE!A86","v":0},{"$f":"+QUESTIONNAIRE!B86","v":"→"},{"$f":"+QUESTIONNAIRE!C86","v":"Has consideration been given to a wide range of possible project solutions to address this need?"},{"$f":"+QUESTIONNAIRE!D86","v":0},{"$f":"+QUESTIONNAIRE!E86","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I86,FALSE)","v":"YES"},null,null,74,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A83","v":0},{"$f":"+QUESTIONNAIRE!B87","v":0},{"$f":"+QUESTIONNAIRE!C87","v":0},{"$f":"+QUESTIONNAIRE!D87","v":0},{"$f":"+QUESTIONNAIRE!E87","v":0},null,null,null,75]
[{"$f":"+QUESTIONNAIRE!A82","v":0},{"$f":"+QUESTIONNAIRE!B88","v":"→"},{"$f":"+QUESTIONNAIRE!C88","v":"Has the preferred project solution, including its scope, been initially identified?"},{"$f":"+QUESTIONNAIRE!D88","v":0},{"$f":"+QUESTIONNAIRE!E88","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I88,FALSE)","v":"YES"},null,null,76,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A89","v":0},{"$f":"+QUESTIONNAIRE!B89","v":0},{"$f":"+QUESTIONNAIRE!C89","v":0},{"$f":"+QUESTIONNAIRE!D89","v":0},{"$f":"+QUESTIONNAIRE!E89","v":0},null,null,null,77]
[{"$f":"+QUESTIONNAIRE!A90","v":0},{"$f":"+QUESTIONNAIRE!B90","v":"→"},{"$f":"+QUESTIONNAIRE!C90","v":"Has the preferred delivery approach been initially identified - specifically, has the PPP option been found to be potentially a suitable delivery choice?"},{"$f":"+QUESTIONNAIRE!D90","v":0},{"$f":"+QUESTIONNAIRE!E90","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I90,FALSE)","v":"YES"},null,null,78,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A85","v":0},{"$f":"+QUESTIONNAIRE!B91","v":0},{"$f":"+QUESTIONNAIRE!C91","v":0},{"$f":"+QUESTIONNAIRE!D91","v":0},{"$f":"+QUESTIONNAIRE!E91","v":0},null,null,null,79]
[{"$f":"+QUESTIONNAIRE!A86","v":0},{"$f":"+QUESTIONNAIRE!B92","v":"→"},{"$f":"+QUESTIONNAIRE!C92","v":"Is there initial stakeholder support for the project and proposed delivery approach?"},{"$f":"+QUESTIONNAIRE!D92","v":0},{"$f":"+QUESTIONNAIRE!E92","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I92,FALSE)","v":"YES"},null,null,80,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A93","v":0},{"$f":"+QUESTIONNAIRE!B93","v":0},{"$f":"+QUESTIONNAIRE!C93","v":0},{"$f":"+QUESTIONNAIRE!D93","v":0},{"$f":"+QUESTIONNAIRE!E93","v":0},null,null,null,81]
[{"$f":"+QUESTIONNAIRE!A94","v":0},{"$f":"+QUESTIONNAIRE!B94","v":"→"},{"$f":"+QUESTIONNAIRE!C94","v":"Is the contracting authority ready and prepared to manage the project preparation phase?"},{"$f":"+QUESTIONNAIRE!D94","v":0},{"$f":"+QUESTIONNAIRE!E94","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I94,FALSE)","v":"YES"},null,null,82,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A95","v":0},{"$f":"+QUESTIONNAIRE!B95","v":0},{"$f":"+QUESTIONNAIRE!C95","v":0},{"$f":"+QUESTIONNAIRE!D95","v":0},{"$f":"+QUESTIONNAIRE!E95","v":0},null,null,null,83]
[{"$f":"+QUESTIONNAIRE!A96","v":0},{"$f":"+QUESTIONNAIRE!B96","v":0},{"$f":"+QUESTIONNAIRE!C96","v":0},{"$f":"+QUESTIONNAIRE!D96","v":0},{"$f":"+QUESTIONNAIRE!E96","v":0},{"$f":"+QUESTIONNAIRE!F96","v":0},null,null,84,null,0]
[{"$f":"+QUESTIONNAIRE!A97","v":0},{"$f":"+QUESTIONNAIRE!B97","v":0},{"$f":"+QUESTIONNAIRE!C97","v":0},{"$f":"+QUESTIONNAIRE!D97","v":0},{"$f":"+QUESTIONNAIRE!E97","v":0},null,null,null,85]
[{"$f":"+QUESTIONNAIRE!C98","v":"Preparing the project as a PPP"},null,null,null,null,null,null,null,86]
[{"$f":"+QUESTIONNAIRE!A99","v":0},{"$f":"+QUESTIONNAIRE!B99","v":0},{"$f":"+QUESTIONNAIRE!C99","v":0},{"$f":"+QUESTIONNAIRE!D99","v":0},{"$f":"+QUESTIONNAIRE!E99","v":0},null,null,null,87]
[{"$f":"+QUESTIONNAIRE!A100","v":0},{"$f":"+QUESTIONNAIRE!B100","v":0},{"$f":"+QUESTIONNAIRE!C100","v":0},{"$f":"+QUESTIONNAIRE!D100","v":0},{"$f":"+QUESTIONNAIRE!E100","v":0},null,null,null,88]
[{"$f":"+QUESTIONNAIRE!A101","v":0},{"$f":"+QUESTIONNAIRE!C101","v":"Managing and planning the process"},null,{"$f":"+QUESTIONNAIRE!D101","v":0},{"$f":"+QUESTIONNAIRE!E101","v":0},null,null,null,89]
[{"$f":"+QUESTIONNAIRE!A102","v":0},{"$f":"+QUESTIONNAIRE!B102","v":0},{"$f":"+QUESTIONNAIRE!C102","v":0},{"$f":"+QUESTIONNAIRE!D102","v":0},{"$f":"+QUESTIONNAIRE!E102","v":0},null,null,null,90]
[{"$f":"+QUESTIONNAIRE!A103","v":0},{"$f":"+QUESTIONNAIRE!C103","v":"Setting up a project team and governance structure"},null,{"$f":"+QUESTIONNAIRE!D103","v":0},{"$f":"+QUESTIONNAIRE!E103","v":0},null,null,null,91]
[{"$f":"+QUESTIONNAIRE!A104","v":0},{"$f":"+QUESTIONNAIRE!B104","v":0},{"$f":"+QUESTIONNAIRE!C104","v":0},{"$f":"+QUESTIONNAIRE!D104","v":0},{"$f":"+QUESTIONNAIRE!E104","v":0},null,null,null,92]
[{"$f":"+QUESTIONNAIRE!A105","v":0},{"$f":"+QUESTIONNAIRE!B105","v":0},{"$f":"+QUESTIONNAIRE!C105","v":0},{"$f":"+QUESTIONNAIRE!D105","v":0},{"$f":"+QUESTIONNAIRE!E105","v":0},null,null,null,93]
[{"$f":"+QUESTIONNAIRE!A106","v":0},{"$f":"+QUESTIONNAIRE!B106","v":0},{"$f":"+QUESTIONNAIRE!C106","v":0},{"$f":"+QUESTIONNAIRE!D106","v":0},{"$f":"+QUESTIONNAIRE!E106","v":0},null,null,null,94]
[{"$f":"+QUESTIONNAIRE!A107","v":0},{"$f":"+QUESTIONNAIRE!B107","v":0},{"$f":"+QUESTIONNAIRE!C107","v":"Has a steering committee been established to oversee the preparation and delivery of the project?"},{"$f":"+QUESTIONNAIRE!D107","v":0},{"$f":"+QUESTIONNAIRE!E107","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I107,FALSE)","v":"YES"},null,null,95,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A108","v":0},{"$f":"+QUESTIONNAIRE!B108","v":0},{"$f":"+QUESTIONNAIRE!C108","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D108","v":0},{"$f":"+QUESTIONNAIRE!E108","v":0},null,null,null,96]
[{"$f":"+QUESTIONNAIRE!A109","v":0},{"$f":"+QUESTIONNAIRE!B109","v":0},{"$f":"+QUESTIONNAIRE!C109","v":0},{"$f":"+QUESTIONNAIRE!D109","v":"Has a senior official at the Authority been appointed to lead the steering committee and take overall responsibility for delivering the project?"},{"$f":"+QUESTIONNAIRE!E109","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I109,FALSE)","v":"YES"},null,null,97,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A110","v":0},{"$f":"+QUESTIONNAIRE!B110","v":0},{"$f":"+QUESTIONNAIRE!C110","v":0},{"$f":"+QUESTIONNAIRE!D110","v":0},{"$f":"+QUESTIONNAIRE!E110","v":0},null,null,null,98]
[{"$f":"+QUESTIONNAIRE!A111","v":0},{"$f":"+QUESTIONNAIRE!B111","v":0},{"$f":"+QUESTIONNAIRE!C111","v":0},{"$f":"+QUESTIONNAIRE!D111","v":"Have other members of the steering committee been appointed on the basis of their availability and capabilities to oversee and take decisions through the preparation and procurement stages?"},{"$f":"+QUESTIONNAIRE!E111","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I111,FALSE)","v":"YES"},null,null,99,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A112","v":0},{"$f":"+QUESTIONNAIRE!B112","v":0},{"$f":"+QUESTIONNAIRE!C112","v":0},{"$f":"+QUESTIONNAIRE!D112","v":0},{"$f":"+QUESTIONNAIRE!E112","v":0},null,null,null,100]
[{"$f":"+QUESTIONNAIRE!A113","v":0},{"$f":"+QUESTIONNAIRE!B113","v":0},{"$f":"+QUESTIONNAIRE!C113","v":0},{"$f":"+QUESTIONNAIRE!D113","v":"Have the governing rules for the steering committee been agreed by the appropriate authority?"},{"$f":"+QUESTIONNAIRE!E113","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I113,FALSE)","v":"YES"},null,null,101,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A114","v":0},{"$f":"+QUESTIONNAIRE!B114","v":0},{"$f":"+QUESTIONNAIRE!C114","v":0},{"$f":"+QUESTIONNAIRE!D114","v":0},{"$f":"+QUESTIONNAIRE!E114","v":0},null,null,null,102]
[{"$f":"+QUESTIONNAIRE!A115","v":0},{"$f":"+QUESTIONNAIRE!B115","v":0},{"$f":"+QUESTIONNAIRE!C115","v":"Has a project team been established for the project?"},{"$f":"+QUESTIONNAIRE!D115","v":0},{"$f":"+QUESTIONNAIRE!E115","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I115,FALSE)","v":"YES"},null,null,103,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A116","v":0},{"$f":"+QUESTIONNAIRE!B116","v":0},{"$f":"+QUESTIONNAIRE!C116","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D116","v":0},{"$f":"+QUESTIONNAIRE!E116","v":0},null,null,null,104]
[{"$f":"+QUESTIONNAIRE!A117","v":0},{"$f":"+QUESTIONNAIRE!B117","v":0},{"$f":"+QUESTIONNAIRE!C117","v":0},{"$f":"+QUESTIONNAIRE!D117","v":"Has a project director/manager from the Authority been assigned to the project?"},{"$f":"+QUESTIONNAIRE!E117","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I117,FALSE)","v":"YES"},null,null,105,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A118","v":0},{"$f":"+QUESTIONNAIRE!B118","v":0},{"$f":"+QUESTIONNAIRE!C118","v":0},{"$f":"+QUESTIONNAIRE!D118","v":0},{"$f":"+QUESTIONNAIRE!E118","v":0},null,null,null,106]
[{"$f":"+QUESTIONNAIRE!A119","v":0},{"$f":"+QUESTIONNAIRE!B119","v":0},{"$f":"+QUESTIONNAIRE!C119","v":0},{"$f":"+QUESTIONNAIRE!D119","v":"      Has the project director/manager worked on similar projects (sector, size and technical complexity) in the past? "},{"$f":"+QUESTIONNAIRE!E119","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I119,FALSE)","v":"YES"},null,null,107,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A120","v":0},{"$f":"+QUESTIONNAIRE!B120","v":0},{"$f":"+QUESTIONNAIRE!C120","v":0},{"$f":"+QUESTIONNAIRE!D120","v":0},{"$f":"+QUESTIONNAIRE!E120","v":0},null,null,null,108]
[{"$f":"+QUESTIONNAIRE!A121","v":0},{"$f":"+QUESTIONNAIRE!B121","v":0},{"$f":"+QUESTIONNAIRE!C121","v":0},{"$f":"+QUESTIONNAIRE!D121","v":"      Has the project director/manager worked on one or more PPP projects in the past? "},{"$f":"+QUESTIONNAIRE!E121","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I121,FALSE)","v":"YES"},null,null,109,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A122","v":0},{"$f":"+QUESTIONNAIRE!B122","v":0},{"$f":"+QUESTIONNAIRE!C122","v":0},{"$f":"+QUESTIONNAIRE!D122","v":0},{"$f":"+QUESTIONNAIRE!E122","v":0},null,null,null,110]
[{"$f":"+QUESTIONNAIRE!A123","v":0},{"$f":"+QUESTIONNAIRE!B123","v":0},{"$f":"+QUESTIONNAIRE!C123","v":0},{"$f":"+QUESTIONNAIRE!D123","v":"      Is the project director/manager dedicated full time to the project?"},{"$f":"+QUESTIONNAIRE!E123","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I123,FALSE)","v":"YES"},null,null,111,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A124","v":0},{"$f":"+QUESTIONNAIRE!B124","v":0},{"$f":"+QUESTIONNAIRE!C124","v":0},{"$f":"+QUESTIONNAIRE!D124","v":0},{"$f":"+QUESTIONNAIRE!E124","v":0},null,null,null,112]
[{"$f":"+QUESTIONNAIRE!A125","v":0},{"$f":"+QUESTIONNAIRE!B125","v":0},{"$f":"+QUESTIONNAIRE!C125","v":0},{"$f":"+QUESTIONNAIRE!D125","v":"Have the resources needed to manage the preparation and procurement of the project been assessed?"},{"$f":"+QUESTIONNAIRE!E125","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I125,FALSE)","v":"YES"},null,null,113,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A126","v":0},{"$f":"+QUESTIONNAIRE!B126","v":0},{"$f":"+QUESTIONNAIRE!C126","v":0},{"$f":"+QUESTIONNAIRE!D126","v":0},{"$f":"+QUESTIONNAIRE!E126","v":0},null,null,null,114]
[{"$f":"+QUESTIONNAIRE!A127","v":0},{"$f":"+QUESTIONNAIRE!B127","v":0},{"$f":"+QUESTIONNAIRE!C127","v":0},{"$f":"+QUESTIONNAIRE!D127","v":"       Does this assessment consider the expertise and the quantity of resources required?"},{"$f":"+QUESTIONNAIRE!E127","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I127,FALSE)","v":"YES"},null,null,115,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A128","v":0},{"$f":"+QUESTIONNAIRE!B128","v":0},{"$f":"+QUESTIONNAIRE!C128","v":0},{"$f":"+QUESTIONNAIRE!D128","v":0},{"$f":"+QUESTIONNAIRE!E128","v":0},null,null,null,116]
[{"$f":"+QUESTIONNAIRE!A129","v":0},{"$f":"+QUESTIONNAIRE!B129","v":0},{"$f":"+QUESTIONNAIRE!C129","v":0},{"$f":"+QUESTIONNAIRE!D129","v":"       Does this assessment rely on a resource analysis of other similar projects?"},{"$f":"+QUESTIONNAIRE!E129","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I129,FALSE)","v":"YES"},null,null,117,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A130","v":0},{"$f":"+QUESTIONNAIRE!B130","v":0},{"$f":"+QUESTIONNAIRE!C130","v":0},{"$f":"+QUESTIONNAIRE!D130","v":0},{"$f":"+QUESTIONNAIRE!E130","v":0},null,null,null,118]
[{"$f":"+QUESTIONNAIRE!A131","v":0},{"$f":"+QUESTIONNAIRE!B131","v":0},{"$f":"+QUESTIONNAIRE!C131","v":0},{"$f":"+QUESTIONNAIRE!D131","v":"       Does the scope of this assessment comprise the resources available within the Authority and services that will need to be contracted? "},{"$f":"+QUESTIONNAIRE!E131","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I131,FALSE)","v":"YES"},null,null,119,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A132","v":0},{"$f":"+QUESTIONNAIRE!B132","v":0},{"$f":"+QUESTIONNAIRE!C132","v":0},{"$f":"+QUESTIONNAIRE!D132","v":0},{"$f":"+QUESTIONNAIRE!E132","v":0},null,null,null,120]
[{"$f":"+QUESTIONNAIRE!A133","v":0},{"$f":"+QUESTIONNAIRE!B133","v":0},{"$f":"+QUESTIONNAIRE!C133","v":0},{"$f":"+QUESTIONNAIRE!D133","v":"       Has the total cost of the required internal and external activities been assessed?"},{"$f":"+QUESTIONNAIRE!E133","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I133,FALSE)","v":"YES"},null,null,121,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A134","v":0},{"$f":"+QUESTIONNAIRE!B134","v":0},{"$f":"+QUESTIONNAIRE!C134","v":0},{"$f":"+QUESTIONNAIRE!D134","v":0},{"$f":"+QUESTIONNAIRE!E134","v":0},null,null,null,122]
[{"$f":"+QUESTIONNAIRE!A135","v":0},{"$f":"+QUESTIONNAIRE!B135","v":0},{"$f":"+QUESTIONNAIRE!C135","v":0},{"$f":"+QUESTIONNAIRE!D135","v":"Has a budget been approved to cover for the required resource need?"},null,{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I135,FALSE)","v":"YES"},null,null,123,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A136","v":0},{"$f":"+QUESTIONNAIRE!B136","v":0},{"$f":"+QUESTIONNAIRE!C136","v":0},{"$f":"+QUESTIONNAIRE!D136","v":0},{"$f":"+QUESTIONNAIRE!E136","v":0},null,null,null,124]
[{"$f":"+QUESTIONNAIRE!A137","v":0},{"$f":"+QUESTIONNAIRE!B137","v":0},{"$f":"+QUESTIONNAIRE!C137","v":0},{"$f":"+QUESTIONNAIRE!D137","v":"       Has the budget for the services contracted out been based on an assessment of the current market cost? "},{"$f":"+QUESTIONNAIRE!E137","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I137,FALSE)","v":"YES"},null,null,125,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A138","v":0},{"$f":"+QUESTIONNAIRE!B138","v":0},{"$f":"+QUESTIONNAIRE!C138","v":0},{"$f":"+QUESTIONNAIRE!D138","v":0},{"$f":"+QUESTIONNAIRE!E138","v":0},null,null,null,126]
[{"$f":"+QUESTIONNAIRE!A139","v":0},{"$f":"+QUESTIONNAIRE!B139","v":0},{"$f":"+QUESTIONNAIRE!C139","v":0},{"$f":"+QUESTIONNAIRE!D139","v":"Have the necessary powers been delegated to the project team to manage the preparation and procurement process?"},{"$f":"+QUESTIONNAIRE!E139","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I139,FALSE)","v":"YES"},null,null,127,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A140","v":0},{"$f":"+QUESTIONNAIRE!B140","v":0},{"$f":"+QUESTIONNAIRE!C140","v":0},{"$f":"+QUESTIONNAIRE!D140","v":0},{"$f":"+QUESTIONNAIRE!E140","v":0},null,null,null,128]
[{"$f":"+QUESTIONNAIRE!A141","v":0},{"$f":"+QUESTIONNAIRE!B141","v":0},{"$f":"+QUESTIONNAIRE!C141","v":"Have experienced legal, financial and technical Advisers been appointed? "},{"$f":"+QUESTIONNAIRE!D141","v":0},{"$f":"+QUESTIONNAIRE!E141","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I141,FALSE)","v":"YES"},null,null,129,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A142","v":0},{"$f":"+QUESTIONNAIRE!B142","v":0},{"$f":"+QUESTIONNAIRE!C142","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D142","v":0},{"$f":"+QUESTIONNAIRE!E142","v":0},null,null,null,130]
[{"$f":"+QUESTIONNAIRE!A143","v":0},{"$f":"+QUESTIONNAIRE!B143","v":0},{"$f":"+QUESTIONNAIRE!C143","v":0},{"$f":"+QUESTIONNAIRE!D143","v":"Have the Advisers been selected through a competitive process?"},{"$f":"+QUESTIONNAIRE!E143","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I143,FALSE)","v":"YES"},null,null,131,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A144","v":0},{"$f":"+QUESTIONNAIRE!B144","v":0},{"$f":"+QUESTIONNAIRE!C144","v":0},{"$f":"+QUESTIONNAIRE!D144","v":0},{"$f":"+QUESTIONNAIRE!E144","v":0},null,null,null,132]
[{"$f":"+QUESTIONNAIRE!A145","v":0},{"$f":"+QUESTIONNAIRE!B145","v":0},{"$f":"+QUESTIONNAIRE!C145","v":0},{"$f":"+QUESTIONNAIRE!D145","v":"Have the Advisers been provided with clear terms of reference for the advisory mandate?"},{"$f":"+QUESTIONNAIRE!E145","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I145,FALSE)","v":"YES"},null,null,133,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A146","v":0},{"$f":"+QUESTIONNAIRE!B146","v":0},{"$f":"+QUESTIONNAIRE!C146","v":0},{"$f":"+QUESTIONNAIRE!D146","v":0},{"$f":"+QUESTIONNAIRE!E146","v":0},null,null,null,134]
[{"$f":"+QUESTIONNAIRE!A147","v":0},{"$f":"+QUESTIONNAIRE!B147","v":0},{"$f":"+QUESTIONNAIRE!C147","v":0},{"$f":"+QUESTIONNAIRE!D147","v":"Have possible conflicts of interest between Advisers and potential bidders been taken into account?"},{"$f":"+QUESTIONNAIRE!E147","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I147,FALSE)","v":"YES"},null,null,135,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A148","v":0},{"$f":"+QUESTIONNAIRE!B148","v":0},{"$f":"+QUESTIONNAIRE!C148","v":0},{"$f":"+QUESTIONNAIRE!D148","v":0},{"$f":"+QUESTIONNAIRE!E148","v":0},null,null,null,136]
[{"$f":"+QUESTIONNAIRE!A149","v":0},{"$f":"+QUESTIONNAIRE!B149","v":0},{"$f":"+QUESTIONNAIRE!C149","v":0},{"$f":"+QUESTIONNAIRE!D149","v":"Do the individuals in the Advisers' firms assigned to the project have proven experience and expertise in their respective fields?"},{"$f":"+QUESTIONNAIRE!E149","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I149,FALSE)","v":"YES"},null,null,{"$f":"+I148+1","v":137},"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A150","v":0},{"$f":"+QUESTIONNAIRE!B150","v":0},{"$f":"+QUESTIONNAIRE!C150","v":0},{"$f":"+QUESTIONNAIRE!D150","v":0},{"$f":"+QUESTIONNAIRE!E150","v":0},null,null,null,138]
[{"$f":"+QUESTIONNAIRE!A151","v":0},{"$f":"+QUESTIONNAIRE!B151","v":0},{"$f":"+QUESTIONNAIRE!C151","v":0},{"$f":"+QUESTIONNAIRE!D151","v":"Has the need for other advisory services (e.g. insurance, tax, modelling, environmental) been assessed?"},{"$f":"+QUESTIONNAIRE!E151","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I151,FALSE)","v":"YES"},null,null,139,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A152","v":0},{"$f":"+QUESTIONNAIRE!B152","v":0},{"$f":"+QUESTIONNAIRE!C152","v":0},{"$f":"+QUESTIONNAIRE!D152","v":0},{"$f":"+QUESTIONNAIRE!E152","v":0},null,null,null,140]
[{"$f":"+QUESTIONNAIRE!A153","v":0},{"$f":"+QUESTIONNAIRE!B153","v":0},{"$f":"+QUESTIONNAIRE!C153","v":0},{"$f":"+QUESTIONNAIRE!D153","v":0},{"$f":"+QUESTIONNAIRE!E153","v":0},null,null,null,141]
[{"$f":"+QUESTIONNAIRE!A154","v":0},{"$f":"+QUESTIONNAIRE!B154","v":0},{"$f":"+QUESTIONNAIRE!C154","v":0},{"$f":"+QUESTIONNAIRE!D154","v":0},{"$f":"+QUESTIONNAIRE!E154","v":0},null,null,null,142]
[{"$f":"+QUESTIONNAIRE!A155","v":0},{"$f":"+QUESTIONNAIRE!C155","v":"Managing authorisations"},null,{"$f":"+QUESTIONNAIRE!D155","v":0},{"$f":"+QUESTIONNAIRE!E155","v":0},null,null,null,143]
[{"$f":"+QUESTIONNAIRE!A156","v":0},{"$f":"+QUESTIONNAIRE!B156","v":0},{"$f":"+QUESTIONNAIRE!C156","v":0},{"$f":"+QUESTIONNAIRE!D156","v":0},{"$f":"+QUESTIONNAIRE!E156","v":0},null,null,null,144]
[{"$f":"+QUESTIONNAIRE!A157","v":0},{"$f":"+QUESTIONNAIRE!B157","v":0},{"$f":"+QUESTIONNAIRE!C157","v":0},{"$f":"+QUESTIONNAIRE!D157","v":0},{"$f":"+QUESTIONNAIRE!E157","v":0},null,null,null,145]
[{"$f":"+QUESTIONNAIRE!A158","v":0},{"$f":"+QUESTIONNAIRE!B158","v":0},{"$f":"+QUESTIONNAIRE!C158","v":0},{"$f":"+QUESTIONNAIRE!D158","v":0},{"$f":"+QUESTIONNAIRE!E158","v":0},null,null,null,146]
[{"$f":"+QUESTIONNAIRE!A159","v":0},{"$f":"+QUESTIONNAIRE!B159","v":0},{"$f":"+QUESTIONNAIRE!C159","v":"Has an assessment of all the necessary authorisation, permits and approvals required to implement the project been carried out? "},{"$f":"+QUESTIONNAIRE!D159","v":0},{"$f":"+QUESTIONNAIRE!E159","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I159,FALSE)","v":"YES"},null,null,147,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A160","v":0},{"$f":"+QUESTIONNAIRE!B160","v":0},{"$f":"+QUESTIONNAIRE!C160","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D160","v":0},{"$f":"+QUESTIONNAIRE!E160","v":0},null,null,null,148]
[{"$f":"+QUESTIONNAIRE!A161","v":0},{"$f":"+QUESTIONNAIRE!B161","v":0},{"$f":"+QUESTIONNAIRE!C161","v":0},{"$f":"+QUESTIONNAIRE!D161","v":"Does the assessment include land acquisition, expropriation, environmental, health and safety requirement of the project?"},{"$f":"+QUESTIONNAIRE!E161","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I161,FALSE)","v":"YES"},null,null,149,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A162","v":0},{"$f":"+QUESTIONNAIRE!B162","v":0},{"$f":"+QUESTIONNAIRE!C162","v":0},{"$f":"+QUESTIONNAIRE!D162","v":0},{"$f":"+QUESTIONNAIRE!E162","v":0},null,null,null,150]
[{"$f":"+QUESTIONNAIRE!A163","v":0},{"$f":"+QUESTIONNAIRE!B163","v":"∞ "},{"$f":"+QUESTIONNAIRE!C163","v":0},{"$f":"+QUESTIONNAIRE!D163","v":"Have the costs of obtaining these been factored into the project preparation budget (see Setting up a project team and governance structure)"},{"$f":"+QUESTIONNAIRE!E163","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I163,FALSE)","v":"YES"},null,null,151,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A164","v":0},{"$f":"+QUESTIONNAIRE!B164","v":0},{"$f":"+QUESTIONNAIRE!C164","v":0},{"$f":"+QUESTIONNAIRE!D164","v":0},{"$f":"+QUESTIONNAIRE!E164","v":0},null,null,null,152]
[{"$f":"+QUESTIONNAIRE!A165","v":0},{"$f":"+QUESTIONNAIRE!B165","v":0},{"$f":"+QUESTIONNAIRE!C165","v":0},{"$f":"+QUESTIONNAIRE!D165","v":"Does the assessment identify the parties responsible for obtaining these?"},{"$f":"+QUESTIONNAIRE!E165","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I165,FALSE)","v":"YES"},null,null,153,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A166","v":0},{"$f":"+QUESTIONNAIRE!B166","v":0},{"$f":"+QUESTIONNAIRE!C166","v":0},{"$f":"+QUESTIONNAIRE!D166","v":0},{"$f":"+QUESTIONNAIRE!E166","v":" "},null,null,null,154]
[{"$f":"+QUESTIONNAIRE!A167","v":0},{"$f":"+QUESTIONNAIRE!B167","v":0},{"$f":"+QUESTIONNAIRE!C167","v":0},{"$f":"+QUESTIONNAIRE!D167","v":"Have the risks associated with obtaining these been assessed and the risk matrix updated?"},{"$f":"+QUESTIONNAIRE!E167","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I167,FALSE)","v":"YES"},null,null,155,"--Please Select--","NO","YES"]
[{"$f":"+QUESTIONNAIRE!A168","v":0},{"$f":"+QUESTIONNAIRE!B168","v":0},{"$f":"+QUESTIONNAIRE!C168","v":0},{"$f":"+QUESTIONNAIRE!D168","v":0},{"$f":"+QUESTIONNAIRE!E168","v":0},null,null,null,156]
[{"$f":"+QUESTIONNAIRE!A169","v":0},{"$f":"+QUESTIONNAIRE!B169","v":0},{"$f":"+QUESTIONNAIRE!C169","v":0},{"$f":"+QUESTIONNAIRE!D169","v":0},{"$f":"+QUESTIONNAIRE!E169","v":0},null,null,null,157]
[{"$f":"+QUESTIONNAIRE!A170","v":0},{"$f":"+QUESTIONNAIRE!C170","v":"Developing a plan and a timetable"},null,{"$f":"+QUESTIONNAIRE!D170","v":0},{"$f":"+QUESTIONNAIRE!E170","v":0},null,null,null,158]
[{"$f":"+QUESTIONNAIRE!A171","v":0},{"$f":"+QUESTIONNAIRE!B171","v":0},{"$f":"+QUESTIONNAIRE!C171","v":0},{"$f":"+QUESTIONNAIRE!D171","v":0},{"$f":"+QUESTIONNAIRE!E171","v":0},null,null,null,159]
[{"$f":"+QUESTIONNAIRE!A172","v":0},{"$f":"+QUESTIONNAIRE!B172","v":0},{"$f":"+QUESTIONNAIRE!C172","v":0},{"$f":"+QUESTIONNAIRE!D172","v":0},{"$f":"+QUESTIONNAIRE!E172","v":0},null,null,null,160]
[{"$f":"+QUESTIONNAIRE!A173","v":0},{"$f":"+QUESTIONNAIRE!B173","v":0},{"$f":"+QUESTIONNAIRE!C173","v":0},{"$f":"+QUESTIONNAIRE!D173","v":0},{"$f":"+QUESTIONNAIRE!E173","v":0},null,null,null,161]
[{"$f":"+QUESTIONNAIRE!A174","v":0},{"$f":"+QUESTIONNAIRE!B174","v":0},{"$f":"+QUESTIONNAIRE!C174","v":"Does the Authority have an agreed plan to manage the project development and procurement process? "},{"$f":"+QUESTIONNAIRE!D174","v":0},{"$f":"+QUESTIONNAIRE!E174","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I174,FALSE)","v":"YES"},null,null,162,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A175","v":0},{"$f":"+QUESTIONNAIRE!B175","v":0},{"$f":"+QUESTIONNAIRE!C175","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D175","v":0},{"$f":"+QUESTIONNAIRE!E175","v":0},null,null,null,163]
[{"$f":"+QUESTIONNAIRE!A176","v":0},{"$f":"+QUESTIONNAIRE!B176","v":0},{"$f":"+QUESTIONNAIRE!C176","v":0},{"$f":"+QUESTIONNAIRE!D176","v":"Have the roles of all members of the project team been defined?"},{"$f":"+QUESTIONNAIRE!E176","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I176,FALSE)","v":"YES"},null,null,164,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A177","v":0},{"$f":"+QUESTIONNAIRE!B177","v":0},{"$f":"+QUESTIONNAIRE!C177","v":0},{"$f":"+QUESTIONNAIRE!D177","v":0},{"$f":"+QUESTIONNAIRE!E177","v":0},null,null,null,165]
[{"$f":"+QUESTIONNAIRE!A178","v":0},{"$f":"+QUESTIONNAIRE!B178","v":0},{"$f":"+QUESTIONNAIRE!C178","v":0},{"$f":"+QUESTIONNAIRE!D178","v":"Is there a process to record any changes in the development of the technical features and contractual arrangements of the project during its preparation?"},{"$f":"+QUESTIONNAIRE!E178","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I178,FALSE)","v":"YES"},null,null,166,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A179","v":0},{"$f":"+QUESTIONNAIRE!B179","v":0},{"$f":"+QUESTIONNAIRE!C179","v":0},{"$f":"+QUESTIONNAIRE!D179","v":0},{"$f":"+QUESTIONNAIRE!E179","v":0},null,null,null,167]
[{"$f":"+QUESTIONNAIRE!A180","v":0},{"$f":"+QUESTIONNAIRE!B180","v":0},{"$f":"+QUESTIONNAIRE!C180","v":0},{"$f":"+QUESTIONNAIRE!D180","v":"Is there a process for managing all required authorisation, permits and approvals during the preparation and procurement process?"},{"$f":"+QUESTIONNAIRE!E180","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I180,FALSE)","v":"YES"},null,null,168,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A181","v":0},{"$f":"+QUESTIONNAIRE!B181","v":0},{"$f":"+QUESTIONNAIRE!C181","v":0},{"$f":"+QUESTIONNAIRE!D181","v":0},{"$f":"+QUESTIONNAIRE!E181","v":0},null,null,null,169]
[{"$f":"+QUESTIONNAIRE!A182","v":0},{"$f":"+QUESTIONNAIRE!B182","v":0},{"$f":"+QUESTIONNAIRE!C182","v":"Has a timetable that reflects the requirements of the project preparation and procurement been put in place?  "},{"$f":"+QUESTIONNAIRE!D182","v":0},{"$f":"+QUESTIONNAIRE!E182","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I182,FALSE)","v":"YES"},null,null,170,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A183","v":0},{"$f":"+QUESTIONNAIRE!B183","v":0},{"$f":"+QUESTIONNAIRE!C183","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D183","v":0},{"$f":"+QUESTIONNAIRE!E183","v":0},null,null,null,171]
[{"$f":"+QUESTIONNAIRE!A184","v":0},{"$f":"+QUESTIONNAIRE!B184","v":0},{"$f":"+QUESTIONNAIRE!C184","v":0},{"$f":"+QUESTIONNAIRE!D184","v":"Does the timetable accommodate any required public consultation processes?"},{"$f":"+QUESTIONNAIRE!E184","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I184,FALSE)","v":"YES"},null,null,172,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A185","v":0},{"$f":"+QUESTIONNAIRE!B185","v":0},{"$f":"+QUESTIONNAIRE!C185","v":0},{"$f":"+QUESTIONNAIRE!D185","v":0},{"$f":"+QUESTIONNAIRE!E185","v":0},null,null,null,173]
[{"$f":"+QUESTIONNAIRE!A186","v":0},{"$f":"+QUESTIONNAIRE!B186","v":"∞ "},{"$f":"+QUESTIONNAIRE!C186","v":0},{"$f":"+QUESTIONNAIRE!D186","v":"Does the timetable allow for enough time to obtain all required authorisations, permits and approvals? "},{"$f":"+QUESTIONNAIRE!E186","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I186,FALSE)","v":"YES"},null,null,174,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A187","v":0},{"$f":"+QUESTIONNAIRE!B187","v":0},{"$f":"+QUESTIONNAIRE!C187","v":0},{"$f":"+QUESTIONNAIRE!D187","v":"(see Managing authorisations)"},{"$f":"+QUESTIONNAIRE!E187","v":0},null,null,null,175]
[{"$f":"+QUESTIONNAIRE!A188","v":0},{"$f":"+QUESTIONNAIRE!B188","v":0},{"$f":"+QUESTIONNAIRE!C188","v":0},{"$f":"+QUESTIONNAIRE!D188","v":0},{"$f":"+QUESTIONNAIRE!E188","v":0},null,null,null,176]
[{"$f":"+QUESTIONNAIRE!A189","v":0},{"$f":"+QUESTIONNAIRE!B189","v":"∞ "},{"$f":"+QUESTIONNAIRE!C189","v":0},{"$f":"+QUESTIONNAIRE!D189","v":"Does the timetable allow for enough time to obtain approvals for any external funding sources (e.g. grants)? "},{"$f":"+QUESTIONNAIRE!E189","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I189,FALSE)","v":"YES"},null,null,177,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A190","v":0},{"$f":"+QUESTIONNAIRE!B190","v":0},{"$f":"+QUESTIONNAIRE!C190","v":0},{"$f":"+QUESTIONNAIRE!D190","v":"(see Developing the affordability analysis)"},{"$f":"+QUESTIONNAIRE!E190","v":0},null,null,null,178]
[{"$f":"+QUESTIONNAIRE!A191","v":0},{"$f":"+QUESTIONNAIRE!B191","v":0},{"$f":"+QUESTIONNAIRE!C191","v":0},{"$f":"+QUESTIONNAIRE!D191","v":0},{"$f":"+QUESTIONNAIRE!E191","v":0},null,null,null,179]
[{"$f":"+QUESTIONNAIRE!A192","v":0},{"$f":"+QUESTIONNAIRE!B192","v":"∞ "},{"$f":"+QUESTIONNAIRE!C192","v":0},{"$f":"+QUESTIONNAIRE!D192","v":"Does the timetable allow for enough time to run the procurement process adequately, including raising the financing? "},{"$f":"+QUESTIONNAIRE!E192","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I192,FALSE)","v":"YES"},null,null,180,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A193","v":0},{"$f":"+QUESTIONNAIRE!B193","v":0},{"$f":"+QUESTIONNAIRE!C193","v":0},{"$f":"+QUESTIONNAIRE!D193","v":"(see Performing market sounding and bankability analysis)"},{"$f":"+QUESTIONNAIRE!E193","v":0},null,null,null,181]
[{"$f":"+QUESTIONNAIRE!A194","v":0},{"$f":"+QUESTIONNAIRE!B194","v":0},{"$f":"+QUESTIONNAIRE!C194","v":0},{"$f":"+QUESTIONNAIRE!D194","v":0},{"$f":"+QUESTIONNAIRE!E194","v":0},null,null,null,182]
[{"$f":"+QUESTIONNAIRE!A195","v":0},{"$f":"+QUESTIONNAIRE!B195","v":0},{"$f":"+QUESTIONNAIRE!C195","v":0},{"$f":"+QUESTIONNAIRE!D195","v":"Does the timetable identify key milestones in the preparation and procurement process and show the relationships between tasks?"},{"$f":"+QUESTIONNAIRE!E195","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I195,FALSE)","v":"YES"},null,null,183,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A196","v":0},{"$f":"+QUESTIONNAIRE!B196","v":0},{"$f":"+QUESTIONNAIRE!C196","v":0},{"$f":"+QUESTIONNAIRE!D196","v":0},{"$f":"+QUESTIONNAIRE!E196","v":0},null,null,null,184]
[{"$f":"+QUESTIONNAIRE!A197","v":0},{"$f":"+QUESTIONNAIRE!B197","v":0},{"$f":"+QUESTIONNAIRE!C197","v":0},{"$f":"+QUESTIONNAIRE!D197","v":"Has the timetable been fully accepted and approved by the steering committee and the appropriate authority?"},{"$f":"+QUESTIONNAIRE!E197","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I197,FALSE)","v":"YES"},null,null,185,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A198","v":0},{"$f":"+QUESTIONNAIRE!B198","v":0},{"$f":"+QUESTIONNAIRE!C198","v":0},{"$f":"+QUESTIONNAIRE!D198","v":0},{"$f":"+QUESTIONNAIRE!E198","v":0},null,null,null,186]
[{"$f":"+QUESTIONNAIRE!A199","v":0},{"$f":"+QUESTIONNAIRE!B199","v":0},{"$f":"+QUESTIONNAIRE!C199","v":0},{"$f":"+QUESTIONNAIRE!D199","v":"Has an initial plan been developed for the post-contract signature phase to manage the project including contract management, identification and training of key individuals and ensuring effective continuation of project information?"},{"$f":"+QUESTIONNAIRE!E199","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I199,FALSE)","v":"YES"},null,null,187,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A200","v":0},{"$f":"+QUESTIONNAIRE!B200","v":0},{"$f":"+QUESTIONNAIRE!C200","v":0},{"$f":"+QUESTIONNAIRE!D200","v":0},{"$f":"+QUESTIONNAIRE!E200","v":0},null,null,null,188]
[{"$f":"+QUESTIONNAIRE!A201","v":0},{"$f":"+QUESTIONNAIRE!B201","v":0},{"$f":"+QUESTIONNAIRE!C201","v":0},{"$f":"+QUESTIONNAIRE!D201","v":0},{"$f":"+QUESTIONNAIRE!E201","v":0},null,null,null,189]
[{"$f":"+QUESTIONNAIRE!A202","v":0},{"$f":"+QUESTIONNAIRE!B202","v":0},{"$f":"+QUESTIONNAIRE!C202","v":0},{"$f":"+QUESTIONNAIRE!D202","v":0},{"$f":"+QUESTIONNAIRE!E202","v":0},null,null,null,190]
[{"$f":"+QUESTIONNAIRE!A203","v":0},{"$f":"+QUESTIONNAIRE!B203","v":0},{"$f":"+QUESTIONNAIRE!C203","v":0},{"$f":"+QUESTIONNAIRE!D203","v":0},{"$f":"+QUESTIONNAIRE!E203","v":0},null,null,null,191]
[{"$f":"+QUESTIONNAIRE!A204","v":0},{"$f":"+QUESTIONNAIRE!C204","v":"Developing the PPP project"},null,null,{"$f":"+QUESTIONNAIRE!E204","v":0},{"$f":"+QUESTIONNAIRE!F204","v":0},null,null,192,null,0]
[{"$f":"+QUESTIONNAIRE!A205","v":0},{"$f":"+QUESTIONNAIRE!B205","v":0},{"$f":"+QUESTIONNAIRE!C205","v":0},{"$f":"+QUESTIONNAIRE!D205","v":0},{"$f":"+QUESTIONNAIRE!E205","v":0},null,null,null,193]
[{"$f":"+QUESTIONNAIRE!A206","v":0},{"$f":"+QUESTIONNAIRE!C206","v":"Developing the affordability analysis"},null,{"$f":"+QUESTIONNAIRE!D206","v":0},{"$f":"+QUESTIONNAIRE!E206","v":0},null,null,null,194]
[{"$f":"+QUESTIONNAIRE!A207","v":0},{"$f":"+QUESTIONNAIRE!B207","v":0},{"$f":"+QUESTIONNAIRE!C207","v":0},{"$f":"+QUESTIONNAIRE!D207","v":0},{"$f":"+QUESTIONNAIRE!E207","v":0},null,null,null,195]
[{"$f":"+QUESTIONNAIRE!A208","v":0},{"$f":"+QUESTIONNAIRE!B208","v":0},{"$f":"+QUESTIONNAIRE!C208","v":0},{"$f":"+QUESTIONNAIRE!D208","v":0},{"$f":"+QUESTIONNAIRE!E208","v":0},null,null,null,196]
[{"$f":"+QUESTIONNAIRE!A209","v":0},{"$f":"+QUESTIONNAIRE!B209","v":0},{"$f":"+QUESTIONNAIRE!C209","v":0},{"$f":"+QUESTIONNAIRE!D209","v":0},{"$f":"+QUESTIONNAIRE!E209","v":0},null,null,null,197]
[{"$f":"+QUESTIONNAIRE!A210","v":0},{"$f":"+QUESTIONNAIRE!B210","v":0},{"$f":"+QUESTIONNAIRE!C210","v":"Has an affordability analysis been prepared to demonstrate that the Authority and/or the end-users have the capacity to pay for the project? "},{"$f":"+QUESTIONNAIRE!D210","v":0},{"$f":"+QUESTIONNAIRE!E210","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I210,FALSE)","v":"YES"},null,null,198,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A211","v":0},{"$f":"+QUESTIONNAIRE!B211","v":0},{"$f":"+QUESTIONNAIRE!C211","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D211","v":0},{"$f":"+QUESTIONNAIRE!E211","v":0},null,null,null,199]
[{"$f":"+QUESTIONNAIRE!A212","v":0},{"$f":"+QUESTIONNAIRE!B212","v":0},{"$f":"+QUESTIONNAIRE!C212","v":0},{"$f":"+QUESTIONNAIRE!D212","v":"Have all project costs over the life of the project been estimated?"},{"$f":"+QUESTIONNAIRE!E212","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I212,FALSE)","v":"YES"},null,null,200,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A213","v":0},{"$f":"+QUESTIONNAIRE!B213","v":0},{"$f":"+QUESTIONNAIRE!C213","v":0},{"$f":"+QUESTIONNAIRE!D213","v":0},{"$f":"+QUESTIONNAIRE!E213","v":0},null,null,null,{"$f":"+I212+1","v":201}]
[{"$f":"+QUESTIONNAIRE!A214","v":0},{"$f":"+QUESTIONNAIRE!B214","v":0},{"$f":"+QUESTIONNAIRE!C214","v":0},{"$f":"+QUESTIONNAIRE!D214","v":"Does the cost analysis cover capital expenditure, operation and maintenance costs, lifecycle costs, financing costs, land acquisition costs, public sector management costs, insurance costs, project preparation costs, transaction costs and taxes?"},{"$f":"+QUESTIONNAIRE!E214","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I214,FALSE)","v":"YES"},null,null,202,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A215","v":0},{"$f":"+QUESTIONNAIRE!B215","v":0},{"$f":"+QUESTIONNAIRE!C215","v":0},{"$f":"+QUESTIONNAIRE!D215","v":0},{"$f":"+QUESTIONNAIRE!E215","v":0},null,null,null,203]
[{"$f":"+QUESTIONNAIRE!A216","v":0},{"$f":"+QUESTIONNAIRE!B216","v":0},{"$f":"+QUESTIONNAIRE!C216","v":0},{"$f":"+QUESTIONNAIRE!D216","v":"Does the financing cost analysis reflect current market conditions for pricing, debt maturity, equity returns, gearing and debt cover ratios?"},{"$f":"+QUESTIONNAIRE!E216","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I216,FALSE)","v":"YES"},null,null,204,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A217","v":0},{"$f":"+QUESTIONNAIRE!B217","v":0},{"$f":"+QUESTIONNAIRE!C217","v":0},{"$f":"+QUESTIONNAIRE!D217","v":0},{"$f":"+QUESTIONNAIRE!E217","v":0},null,null,null,205]
[{"$f":"+QUESTIONNAIRE!A218","v":0},{"$f":"+QUESTIONNAIRE!B218","v":"∞ "},{"$f":"+QUESTIONNAIRE!C218","v":0},{"$f":"+QUESTIONNAIRE!D218","v":"Are the cost estimates consistent with the findings of the market sounding and bankability analysis, stakeholder analysis and the required service outputs for the project?"},{"$f":"+QUESTIONNAIRE!E218","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I218,FALSE)","v":"YES"},null,null,206,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A219","v":0},{"$f":"+QUESTIONNAIRE!B219","v":0},{"$f":"+QUESTIONNAIRE!C219","v":0},{"$f":"+QUESTIONNAIRE!D219","v":0},{"$f":"+QUESTIONNAIRE!E219","v":0},null,null,null,207]
[{"$f":"+QUESTIONNAIRE!A220","v":0},{"$f":"+QUESTIONNAIRE!B220","v":"∞ "},{"$f":"+QUESTIONNAIRE!C220","v":0},{"$f":"+QUESTIONNAIRE!D220","v":"Have the Advisers been used to help prepare the cost estimates and financing assumptions? (see Setting up a project team and a governance structure)"},{"$f":"+QUESTIONNAIRE!E220","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I220,FALSE)","v":"YES"},null,null,208,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A221","v":0},{"$f":"+QUESTIONNAIRE!B221","v":0},{"$f":"+QUESTIONNAIRE!C221","v":0},{"$f":"+QUESTIONNAIRE!D221","v":0},{"$f":"+QUESTIONNAIRE!E221","v":0},null,null,null,209]
[{"$f":"+QUESTIONNAIRE!A222","v":0},{"$f":"+QUESTIONNAIRE!B222","v":0},{"$f":"+QUESTIONNAIRE!C222","v":0},{"$f":"+QUESTIONNAIRE!D222","v":"Have funding sources for the project been identified (e.g. user payments, capital grants, Authority budgetary resources)?"},{"$f":"+QUESTIONNAIRE!E222","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I222,FALSE)","v":"YES"},null,null,210,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A223","v":0},{"$f":"+QUESTIONNAIRE!B223","v":0},{"$f":"+QUESTIONNAIRE!C223","v":0},{"$f":"+QUESTIONNAIRE!D223","v":0},{"$f":"+QUESTIONNAIRE!E223","v":0},null,null,null,211]
[{"$f":"+QUESTIONNAIRE!A224","v":0},{"$f":"+QUESTIONNAIRE!B224","v":0},{"$f":"+QUESTIONNAIRE!C224","v":0},{"$f":"+QUESTIONNAIRE!D224","v":"Has an analysis been carried to determine the feasibility of any end-user payments? "},{"$f":"+QUESTIONNAIRE!E224","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I224,FALSE)","v":"YES"},null,null,212,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A225","v":0},{"$f":"+QUESTIONNAIRE!B225","v":0},{"$f":"+QUESTIONNAIRE!C225","v":0},{"$f":"+QUESTIONNAIRE!D225","v":0},{"$f":"+QUESTIONNAIRE!E225","v":0},null,null,null,213]
[{"$f":"+QUESTIONNAIRE!A226","v":0},{"$f":"+QUESTIONNAIRE!B226","v":0},{"$f":"+QUESTIONNAIRE!C226","v":0},{"$f":"+QUESTIONNAIRE!D226","v":"      If yes, does the analysis cover the end-user willingness to pay for the services?"},{"$f":"+QUESTIONNAIRE!E226","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I226,FALSE)","v":"YES"},null,null,214,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A227","v":0},{"$f":"+QUESTIONNAIRE!B227","v":0},{"$f":"+QUESTIONNAIRE!C227","v":0},{"$f":"+QUESTIONNAIRE!D227","v":0},{"$f":"+QUESTIONNAIRE!E227","v":0},null,null,null,215]
[{"$f":"+QUESTIONNAIRE!A228","v":0},{"$f":"+QUESTIONNAIRE!B228","v":0},{"$f":"+QUESTIONNAIRE!C228","v":0},{"$f":"+QUESTIONNAIRE!D228","v":"      if yes, does the analysis follow a recognised methodology for the sector?"},{"$f":"+QUESTIONNAIRE!E228","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I228,FALSE)","v":"YES"},null,null,216,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A229","v":0},{"$f":"+QUESTIONNAIRE!B229","v":0},{"$f":"+QUESTIONNAIRE!C229","v":0},{"$f":"+QUESTIONNAIRE!D229","v":0},{"$f":"+QUESTIONNAIRE!E229","v":0},null,null,null,217]
[{"$f":"+QUESTIONNAIRE!A230","v":0},{"$f":"+QUESTIONNAIRE!B230","v":0},{"$f":"+QUESTIONNAIRE!C230","v":0},{"$f":"+QUESTIONNAIRE!D230","v":"Has the availability, timing and likelihood of third party grants been assessed?"},{"$f":"+QUESTIONNAIRE!E230","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I230,FALSE)","v":"YES"},null,null,218,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A231","v":0},{"$f":"+QUESTIONNAIRE!B231","v":0},{"$f":"+QUESTIONNAIRE!C231","v":0},{"$f":"+QUESTIONNAIRE!D231","v":0},{"$f":"+QUESTIONNAIRE!E231","v":0},null,null,null,219]
[{"$f":"+QUESTIONNAIRE!A232","v":0},{"$f":"+QUESTIONNAIRE!B232","v":0},{"$f":"+QUESTIONNAIRE!C232","v":0},{"$f":"+QUESTIONNAIRE!D232","v":"Has the availability and timing of internal budgetary resources to fund part of the capital cost of the project been assessed?"},{"$f":"+QUESTIONNAIRE!E232","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I232,FALSE)","v":"YES"},null,null,220,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A233","v":0},{"$f":"+QUESTIONNAIRE!B233","v":0},{"$f":"+QUESTIONNAIRE!C233","v":0},{"$f":"+QUESTIONNAIRE!D233","v":0},{"$f":"+QUESTIONNAIRE!E233","v":0},null,null,null,221]
[{"$f":"+QUESTIONNAIRE!A234","v":0},{"$f":"+QUESTIONNAIRE!B234","v":0},{"$f":"+QUESTIONNAIRE!C234","v":0},{"$f":"+QUESTIONNAIRE!D234","v":"Has the availability and timing of public resources (other than the Authority's resources) to support the Authority's periodic payments over the life of the project been assessed?"},{"$f":"+QUESTIONNAIRE!E234","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I234,FALSE)","v":"YES"},null,null,222,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A235","v":0},{"$f":"+QUESTIONNAIRE!B235","v":0},{"$f":"+QUESTIONNAIRE!C235","v":0},{"$f":"+QUESTIONNAIRE!D235","v":0},{"$f":"+QUESTIONNAIRE!E235","v":0},null,null,null,223]
[{"$f":"+QUESTIONNAIRE!A236","v":0},{"$f":"+QUESTIONNAIRE!B236","v":0},{"$f":"+QUESTIONNAIRE!C236","v":0},{"$f":"+QUESTIONNAIRE!D236","v":"Has the disposal of existing assets been identified as a potential source of funding?"},{"$f":"+QUESTIONNAIRE!E236","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I236,FALSE)","v":"YES"},null,null,224,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A237","v":0},{"$f":"+QUESTIONNAIRE!B237","v":0},{"$f":"+QUESTIONNAIRE!C237","v":0},{"$f":"+QUESTIONNAIRE!D237","v":0},{"$f":"+QUESTIONNAIRE!E237","v":0},null,null,null,225]
[{"$f":"+QUESTIONNAIRE!A238","v":0},{"$f":"+QUESTIONNAIRE!B238","v":0},{"$f":"+QUESTIONNAIRE!C238","v":0},{"$f":"+QUESTIONNAIRE!D238","v":"      If yes, has an analysis been carried out to assess the value and timing of the related proceeds?"},{"$f":"+QUESTIONNAIRE!E238","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I238,FALSE)","v":"YES"},null,null,226,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A239","v":0},{"$f":"+QUESTIONNAIRE!B239","v":0},{"$f":"+QUESTIONNAIRE!C239","v":0},{"$f":"+QUESTIONNAIRE!D239","v":0},{"$f":"+QUESTIONNAIRE!E239","v":0},null,null,null,227]
[{"$f":"+QUESTIONNAIRE!A240","v":0},{"$f":"+QUESTIONNAIRE!B240","v":0},{"$f":"+QUESTIONNAIRE!C240","v":0},{"$f":"+QUESTIONNAIRE!D240","v":"Has a financial model been prepared to assess that the funding sources identified will cover the costs of the project, when needed, over its lifetime?"},{"$f":"+QUESTIONNAIRE!E240","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I240,FALSE)","v":"YES"},null,null,228,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A241","v":0},{"$f":"+QUESTIONNAIRE!B241","v":0},{"$f":"+QUESTIONNAIRE!C241","v":0},{"$f":"+QUESTIONNAIRE!D241","v":0},{"$f":"+QUESTIONNAIRE!E241","v":0},null,null,null,229]
[{"$f":"+QUESTIONNAIRE!A242","v":0},{"$f":"+QUESTIONNAIRE!B242","v":"∞ "},{"$f":"+QUESTIONNAIRE!C242","v":0},{"$f":"+QUESTIONNAIRE!D242","v":"      If yes, have Advisers been involved in preparing the financial model? (see Setting up a project team and a governance structure)"},{"$f":"+QUESTIONNAIRE!E242","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I242,FALSE)","v":"YES"},null,null,230,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A243","v":0},{"$f":"+QUESTIONNAIRE!B243","v":0},{"$f":"+QUESTIONNAIRE!C243","v":0},{"$f":"+QUESTIONNAIRE!D243","v":0},{"$f":"+QUESTIONNAIRE!E243","v":0},null,null,null,231]
[{"$f":"+QUESTIONNAIRE!A244","v":0},{"$f":"+QUESTIONNAIRE!B244","v":0},{"$f":"+QUESTIONNAIRE!C244","v":0},{"$f":"+QUESTIONNAIRE!D244","v":"Has a sensitivity analysis been carried to test the robustness of the project affordability? "},{"$f":"+QUESTIONNAIRE!E244","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I244,FALSE)","v":"YES"},null,null,232,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A245","v":0},{"$f":"+QUESTIONNAIRE!B245","v":0},{"$f":"+QUESTIONNAIRE!C245","v":0},{"$f":"+QUESTIONNAIRE!D245","v":0},{"$f":"+QUESTIONNAIRE!E245","v":0},null,null,null,233]
[{"$f":"+QUESTIONNAIRE!A246","v":0},{"$f":"+QUESTIONNAIRE!B246","v":0},{"$f":"+QUESTIONNAIRE!C246","v":0},{"$f":"+QUESTIONNAIRE!D246","v":"Has the affordability analysis taken into consideration contingent payment commitments of the Authority (e.g. revenue guarantees)?"},{"$f":"+QUESTIONNAIRE!E246","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I246,FALSE)","v":"YES"},null,null,234,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A247","v":0},{"$f":"+QUESTIONNAIRE!B247","v":0},{"$f":"+QUESTIONNAIRE!C247","v":0},{"$f":"+QUESTIONNAIRE!D247","v":0},{"$f":"+QUESTIONNAIRE!E247","v":0},null,null,null,235]
[{"$f":"+QUESTIONNAIRE!A248","v":0},{"$f":"+QUESTIONNAIRE!B248","v":0},{"$f":"+QUESTIONNAIRE!C248","v":0},{"$f":"+QUESTIONNAIRE!D248","v":0},{"$f":"+QUESTIONNAIRE!E248","v":0},null,null,null,236]
[{"$f":"+QUESTIONNAIRE!A249","v":0},{"$f":"+QUESTIONNAIRE!C249","v":"Developing the risk analysis"},null,{"$f":"+QUESTIONNAIRE!D249","v":0},{"$f":"+QUESTIONNAIRE!E249","v":0},null,null,null,237]
[{"$f":"+QUESTIONNAIRE!A250","v":0},{"$f":"+QUESTIONNAIRE!B250","v":0},{"$f":"+QUESTIONNAIRE!C250","v":0},{"$f":"+QUESTIONNAIRE!D250","v":0},{"$f":"+QUESTIONNAIRE!E250","v":0},null,null,null,238]
[{"$f":"+QUESTIONNAIRE!A251","v":0},{"$f":"+QUESTIONNAIRE!B251","v":0},{"$f":"+QUESTIONNAIRE!C251","v":0},{"$f":"+QUESTIONNAIRE!D251","v":0},{"$f":"+QUESTIONNAIRE!E251","v":0},null,null,null,239]
[{"$f":"+QUESTIONNAIRE!A252","v":0},{"$f":"+QUESTIONNAIRE!B252","v":0},{"$f":"+QUESTIONNAIRE!C252","v":0},{"$f":"+QUESTIONNAIRE!D252","v":0},{"$f":"+QUESTIONNAIRE!E252","v":0},null,null,null,240]
[{"$f":"+QUESTIONNAIRE!A253","v":0},{"$f":"+QUESTIONNAIRE!B253","v":0},{"$f":"+QUESTIONNAIRE!C253","v":"Have the risks associated with the project been identified? "},{"$f":"+QUESTIONNAIRE!D253","v":0},{"$f":"+QUESTIONNAIRE!E253","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I253,FALSE)","v":"YES"},null,null,241,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A254","v":0},{"$f":"+QUESTIONNAIRE!B254","v":0},{"$f":"+QUESTIONNAIRE!C254","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D254","v":0},{"$f":"+QUESTIONNAIRE!E254","v":0},null,null,null,242]
[{"$f":"+QUESTIONNAIRE!A255","v":0},{"$f":"+QUESTIONNAIRE!B255","v":0},{"$f":"+QUESTIONNAIRE!C255","v":0},{"$f":"+QUESTIONNAIRE!D255","v":"Does the analysis cover all the phases of the project and all the classes of risks (e.g. legal, technical, financial, environment)? "},{"$f":"+QUESTIONNAIRE!E255","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I255,FALSE)","v":"YES"},null,null,243,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A256","v":0},{"$f":"+QUESTIONNAIRE!B256","v":0},{"$f":"+QUESTIONNAIRE!C256","v":0},{"$f":"+QUESTIONNAIRE!D256","v":0},{"$f":"+QUESTIONNAIRE!E256","v":0},null,null,null,244]
[{"$f":"+QUESTIONNAIRE!A257","v":0},{"$f":"+QUESTIONNAIRE!B257","v":0},{"$f":"+QUESTIONNAIRE!C257","v":0},{"$f":"+QUESTIONNAIRE!D257","v":"Does the analysis cover the risks associated with the public sector's obligations and ability to deliver the project?"},{"$f":"+QUESTIONNAIRE!E257","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I257,FALSE)","v":"YES"},null,null,245,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A258","v":0},{"$f":"+QUESTIONNAIRE!B258","v":0},{"$f":"+QUESTIONNAIRE!C258","v":0},{"$f":"+QUESTIONNAIRE!D258","v":0},{"$f":"+QUESTIONNAIRE!E258","v":0},null,null,null,246]
[{"$f":"+QUESTIONNAIRE!A259","v":0},{"$f":"+QUESTIONNAIRE!B259","v":0},{"$f":"+QUESTIONNAIRE!C259","v":0},{"$f":"+QUESTIONNAIRE!D259","v":"Has a detailed risk matrix been prepared to register these risks?"},{"$f":"+QUESTIONNAIRE!E259","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I259,FALSE)","v":"YES"},null,null,247,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A260","v":0},{"$f":"+QUESTIONNAIRE!B260","v":0},{"$f":"+QUESTIONNAIRE!C260","v":0},{"$f":"+QUESTIONNAIRE!D260","v":0},{"$f":"+QUESTIONNAIRE!E260","v":0},null,null,null,248]
[{"$f":"+QUESTIONNAIRE!A261","v":0},{"$f":"+QUESTIONNAIRE!B261","v":0},{"$f":"+QUESTIONNAIRE!C261","v":0},{"$f":"+QUESTIONNAIRE!D261","v":"Have the risks been broken down into appropriate sub-risks to ensure a complete and clear understanding of the extent of each Risk ?"},{"$f":"+QUESTIONNAIRE!E261","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I261,FALSE)","v":"YES"},null,null,249,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A262","v":0},{"$f":"+QUESTIONNAIRE!B262","v":0},{"$f":"+QUESTIONNAIRE!C262","v":0},{"$f":"+QUESTIONNAIRE!D262","v":0},{"$f":"+QUESTIONNAIRE!E262","v":0},null,null,null,250]
[{"$f":"+QUESTIONNAIRE!A263","v":0},{"$f":"+QUESTIONNAIRE!B263","v":0},{"$f":"+QUESTIONNAIRE!C263","v":"Has a risk evaluation exercise been carried out? "},{"$f":"+QUESTIONNAIRE!D263","v":0},{"$f":"+QUESTIONNAIRE!E263","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I263,FALSE)","v":"YES"},null,null,251,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A264","v":0},{"$f":"+QUESTIONNAIRE!B264","v":0},{"$f":"+QUESTIONNAIRE!C264","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D264","v":0},{"$f":"+QUESTIONNAIRE!E264","v":0},null,null,null,252]
[{"$f":"+QUESTIONNAIRE!A265","v":0},{"$f":"+QUESTIONNAIRE!B265","v":0},{"$f":"+QUESTIONNAIRE!C265","v":0},{"$f":"+QUESTIONNAIRE!D265","v":"Has the likelihood of each risk been estimated?"},{"$f":"+QUESTIONNAIRE!E265","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I265,FALSE)","v":"YES"},null,null,253,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A266","v":0},{"$f":"+QUESTIONNAIRE!B266","v":0},{"$f":"+QUESTIONNAIRE!C266","v":0},{"$f":"+QUESTIONNAIRE!D266","v":0},{"$f":"+QUESTIONNAIRE!E266","v":0},null,null,null,254]
[{"$f":"+QUESTIONNAIRE!A267","v":0},{"$f":"+QUESTIONNAIRE!B267","v":0},{"$f":"+QUESTIONNAIRE!C267","v":0},{"$f":"+QUESTIONNAIRE!D267","v":"Has the impact of risks been assessed in terms of cost and time?"},{"$f":"+QUESTIONNAIRE!E267","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I267,FALSE)","v":"YES"},null,null,255,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A268","v":0},{"$f":"+QUESTIONNAIRE!B268","v":0},{"$f":"+QUESTIONNAIRE!C268","v":0},{"$f":"+QUESTIONNAIRE!D268","v":0},{"$f":"+QUESTIONNAIRE!E268","v":0},null,null,null,256]
[{"$f":"+QUESTIONNAIRE!A269","v":0},{"$f":"+QUESTIONNAIRE!B269","v":0},{"$f":"+QUESTIONNAIRE!C269","v":"Has a preliminary allocation/sharing of risks been carried out on the basis of allocating each risk to the party best able to manage that risk?"},{"$f":"+QUESTIONNAIRE!D269","v":0},{"$f":"+QUESTIONNAIRE!E269","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I269,FALSE)","v":"YES"},null,null,257,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A270","v":0},{"$f":"+QUESTIONNAIRE!B270","v":0},{"$f":"+QUESTIONNAIRE!C270","v":0},{"$f":"+QUESTIONNAIRE!D270","v":0},{"$f":"+QUESTIONNAIRE!E270","v":0},null,null,null,258]
[{"$f":"+QUESTIONNAIRE!A271","v":0},{"$f":"+QUESTIONNAIRE!B271","v":0},{"$f":"+QUESTIONNAIRE!C271","v":"Have measures to mitigate any of the project risks been assessed and reflected in the project plan and the technical features and contractual arrangements of the project?"},{"$f":"+QUESTIONNAIRE!D271","v":0},{"$f":"+QUESTIONNAIRE!E271","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I271,FALSE)","v":"YES"},null,null,259,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A272","v":0},{"$f":"+QUESTIONNAIRE!B272","v":0},{"$f":"+QUESTIONNAIRE!C272","v":0},{"$f":"+QUESTIONNAIRE!D272","v":0},{"$f":"+QUESTIONNAIRE!E272","v":0},null,null,null,260]
[{"$f":"+QUESTIONNAIRE!A273","v":0},{"$f":"+QUESTIONNAIRE!B273","v":"∞ "},{"$f":"+QUESTIONNAIRE!C273","v":"Has the overall risk analysis involved Advisers, in particular in the identification, evaluation and allocation exercise? (see Setting up a project team and a governance structure)"},{"$f":"+QUESTIONNAIRE!D273","v":0},{"$f":"+QUESTIONNAIRE!E273","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I273,FALSE)","v":"YES"},null,null,261,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A274","v":0},{"$f":"+QUESTIONNAIRE!B274","v":0},{"$f":"+QUESTIONNAIRE!C274","v":0},{"$f":"+QUESTIONNAIRE!D274","v":0},{"$f":"+QUESTIONNAIRE!E274","v":0},null,null,null,262]
[{"$f":"+QUESTIONNAIRE!A275","v":0},{"$f":"+QUESTIONNAIRE!B275","v":"∞ "},{"$f":"+QUESTIONNAIRE!C275","v":"Is the risk analysis informed by the service output requirements, the Market Sounding & Bankability and Affordability assessments?"},{"$f":"+QUESTIONNAIRE!D275","v":0},{"$f":"+QUESTIONNAIRE!E275","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I275,FALSE)","v":"YES"},null,null,263,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A276","v":0},{"$f":"+QUESTIONNAIRE!B276","v":0},{"$f":"+QUESTIONNAIRE!C276","v":0},{"$f":"+QUESTIONNAIRE!D276","v":0},{"$f":"+QUESTIONNAIRE!E276","v":0},null,null,null,264]
[{"$f":"+QUESTIONNAIRE!A277","v":0},{"$f":"+QUESTIONNAIRE!B277","v":0},{"$f":"+QUESTIONNAIRE!C277","v":"Has the risk analysis been based on any relevant precedent?"},{"$f":"+QUESTIONNAIRE!D277","v":0},{"$f":"+QUESTIONNAIRE!E277","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I277,FALSE)","v":"YES"},null,null,{"$f":"+I276+1","v":265},"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A278","v":0},{"$f":"+QUESTIONNAIRE!B278","v":0},{"$f":"+QUESTIONNAIRE!C278","v":0},{"$f":"+QUESTIONNAIRE!D278","v":0},{"$f":"+QUESTIONNAIRE!E278","v":0},null,null,null,266]
[{"$f":"+QUESTIONNAIRE!A279","v":0},{"$f":"+QUESTIONNAIRE!B279","v":0},{"$f":"+QUESTIONNAIRE!C279","v":"Has a risk management process been put in place that will enable the project risks to be monitored, reviewed and updated over the development and operation of the project?"},{"$f":"+QUESTIONNAIRE!D279","v":0},{"$f":"+QUESTIONNAIRE!E279","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I279,FALSE)","v":"YES"},null,null,267,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A280","v":0},{"$f":"+QUESTIONNAIRE!B280","v":0},{"$f":"+QUESTIONNAIRE!C280","v":0},{"$f":"+QUESTIONNAIRE!D280","v":0},{"$f":"+QUESTIONNAIRE!E280","v":0},null,null,null,268]
[{"$f":"+QUESTIONNAIRE!A281","v":0},{"$f":"+QUESTIONNAIRE!B281","v":0},{"$f":"+QUESTIONNAIRE!C281","v":0},{"$f":"+QUESTIONNAIRE!D281","v":0},{"$f":"+QUESTIONNAIRE!E281","v":0},null,null,null,269]
[{"$f":"+QUESTIONNAIRE!A282","v":0},{"$f":"+QUESTIONNAIRE!C282","v":"Performing market sounding and bankability analysis"},null,{"$f":"+QUESTIONNAIRE!D282","v":0},{"$f":"+QUESTIONNAIRE!E282","v":0},null,null,null,270]
[{"$f":"+QUESTIONNAIRE!A283","v":0},{"$f":"+QUESTIONNAIRE!B283","v":0},{"$f":"+QUESTIONNAIRE!C283","v":0},{"$f":"+QUESTIONNAIRE!D283","v":0},{"$f":"+QUESTIONNAIRE!E283","v":0},null,null,null,271]
[{"$f":"+QUESTIONNAIRE!A284","v":0},{"$f":"+QUESTIONNAIRE!B284","v":0},{"$f":"+QUESTIONNAIRE!C284","v":0},{"$f":"+QUESTIONNAIRE!D284","v":0},{"$f":"+QUESTIONNAIRE!E284","v":0},null,null,null,272]
[{"$f":"+QUESTIONNAIRE!A285","v":0},{"$f":"+QUESTIONNAIRE!B285","v":0},{"$f":"+QUESTIONNAIRE!C285","v":0},{"$f":"+QUESTIONNAIRE!D285","v":0},{"$f":"+QUESTIONNAIRE!E285","v":0},null,null,null,273]
[{"$f":"+QUESTIONNAIRE!A286","v":0},{"$f":"+QUESTIONNAIRE!B286","v":0},{"$f":"+QUESTIONNAIRE!C286","v":"Has the level of interest/capacity of private sector stakeholders (e.g. contractors, financiers) to participate in the project been assessed? "},{"$f":"+QUESTIONNAIRE!D286","v":0},{"$f":"+QUESTIONNAIRE!E286","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I286,FALSE)","v":"YES"},null,null,274,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A287","v":0},{"$f":"+QUESTIONNAIRE!B287","v":0},{"$f":"+QUESTIONNAIRE!C287","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D287","v":0},{"$f":"+QUESTIONNAIRE!E287","v":0},null,null,null,275]
[{"$f":"+QUESTIONNAIRE!A288","v":0},{"$f":"+QUESTIONNAIRE!B288","v":0},{"$f":"+QUESTIONNAIRE!C288","v":0},{"$f":"+QUESTIONNAIRE!D288","v":"Has a market sounding plan been developed that identifies the key project features (e.g. risk profile, contract duration) to be tested with the market? "},{"$f":"+QUESTIONNAIRE!E288","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I288,FALSE)","v":"YES"},null,null,276,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A289","v":0},{"$f":"+QUESTIONNAIRE!B289","v":0},{"$f":"+QUESTIONNAIRE!C289","v":0},{"$f":"+QUESTIONNAIRE!D289","v":0},{"$f":"+QUESTIONNAIRE!E289","v":0},null,null,null,277]
[{"$f":"+QUESTIONNAIRE!A290","v":0},{"$f":"+QUESTIONNAIRE!B290","v":0},{"$f":"+QUESTIONNAIRE!C290","v":0},{"$f":"+QUESTIONNAIRE!D290","v":"Does this plan set out a clear approach to engaging with all the relevant market players at the appropriate time? "},{"$f":"+QUESTIONNAIRE!E290","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I290,FALSE)","v":"YES"},null,null,278,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A291","v":0},{"$f":"+QUESTIONNAIRE!B291","v":0},{"$f":"+QUESTIONNAIRE!C291","v":0},{"$f":"+QUESTIONNAIRE!D291","v":0},{"$f":"+QUESTIONNAIRE!E291","v":0},null,null,null,279]
[{"$f":"+QUESTIONNAIRE!A292","v":0},{"$f":"+QUESTIONNAIRE!B292","v":0},{"$f":"+QUESTIONNAIRE!C292","v":"Has research been carried out to identify comparable projects (e.g. size, sector, risk profile) that have reached financial close recently in the country or wider area? "},{"$f":"+QUESTIONNAIRE!D292","v":0},{"$f":"+QUESTIONNAIRE!E292","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I292,FALSE)","v":"YES"},null,null,280,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A293","v":0},{"$f":"+QUESTIONNAIRE!B293","v":0},{"$f":"+QUESTIONNAIRE!C293","v":0},{"$f":"+QUESTIONNAIRE!D293","v":0},{"$f":"+QUESTIONNAIRE!E293","v":0},null,null,null,281]
[{"$f":"+QUESTIONNAIRE!A294","v":0},{"$f":"+QUESTIONNAIRE!B294","v":0},{"$f":"+QUESTIONNAIRE!C294","v":"Has an analysis been carried out to assess the capability of contractors and service providers to construct and operate the project?"},{"$f":"+QUESTIONNAIRE!D294","v":0},{"$f":"+QUESTIONNAIRE!E294","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I294,FALSE)","v":"YES"},null,null,282,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A295","v":0},{"$f":"+QUESTIONNAIRE!B295","v":0},{"$f":"+QUESTIONNAIRE!C295","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D295","v":0},{"$f":"+QUESTIONNAIRE!E295","v":0},null,null,null,283]
[{"$f":"+QUESTIONNAIRE!A296","v":0},{"$f":"+QUESTIONNAIRE!B296","v":0},{"$f":"+QUESTIONNAIRE!C296","v":0},{"$f":"+QUESTIONNAIRE!D296","v":"Does the analysis cover their past experience of PPP projects?"},{"$f":"+QUESTIONNAIRE!E296","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I296,FALSE)","v":"YES"},null,null,284,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A297","v":0},{"$f":"+QUESTIONNAIRE!B297","v":0},{"$f":"+QUESTIONNAIRE!C297","v":0},{"$f":"+QUESTIONNAIRE!D297","v":0},{"$f":"+QUESTIONNAIRE!E297","v":0},null,null,null,285]
[{"$f":"+QUESTIONNAIRE!A298","v":0},{"$f":"+QUESTIONNAIRE!B298","v":0},{"$f":"+QUESTIONNAIRE!C298","v":0},{"$f":"+QUESTIONNAIRE!D298","v":"Does the scope of the analysis include the capacity of the market to deliver the required project outputs to the envisaged quality, cost and timetable?"},{"$f":"+QUESTIONNAIRE!E298","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I298,FALSE)","v":"YES"},null,null,286,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A299","v":0},{"$f":"+QUESTIONNAIRE!B299","v":0},{"$f":"+QUESTIONNAIRE!C299","v":0},{"$f":"+QUESTIONNAIRE!D299","v":0},{"$f":"+QUESTIONNAIRE!E299","v":0},null,null,null,287]
[{"$f":"+QUESTIONNAIRE!A300","v":0},{"$f":"+QUESTIONNAIRE!B300","v":0},{"$f":"+QUESTIONNAIRE!C300","v":"Has an analysis been carried out to assess the capacity/appetite of potential financiers to finance the project? "},{"$f":"+QUESTIONNAIRE!D300","v":0},{"$f":"+QUESTIONNAIRE!E300","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I300,FALSE)","v":"YES"},null,null,288,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A301","v":0},{"$f":"+QUESTIONNAIRE!B301","v":0},{"$f":"+QUESTIONNAIRE!C301","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D301","v":0},{"$f":"+QUESTIONNAIRE!E301","v":0},null,null,null,289]
[{"$f":"+QUESTIONNAIRE!A302","v":0},{"$f":"+QUESTIONNAIRE!B302","v":0},{"$f":"+QUESTIONNAIRE!C302","v":0},{"$f":"+QUESTIONNAIRE!D302","v":"Does the analysis cover all potential financing sources (e.g. commercial banks, international or domestic public financing institutions, equity investors) for the project? "},{"$f":"+QUESTIONNAIRE!E302","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I302,FALSE)","v":"YES"},null,null,290,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A303","v":0},{"$f":"+QUESTIONNAIRE!B303","v":0},{"$f":"+QUESTIONNAIRE!C303","v":0},{"$f":"+QUESTIONNAIRE!D303","v":0},{"$f":"+QUESTIONNAIRE!E303","v":0},null,null,null,291]
[{"$f":"+QUESTIONNAIRE!A304","v":0},{"$f":"+QUESTIONNAIRE!B304","v":0},{"$f":"+QUESTIONNAIRE!C304","v":0},{"$f":"+QUESTIONNAIRE!D304","v":"Does the analysis focus on their experience of financing PPP projects (e.g. non-recourse project financing)?"},{"$f":"+QUESTIONNAIRE!E304","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I304,FALSE)","v":"YES"},null,null,292,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A305","v":0},{"$f":"+QUESTIONNAIRE!B305","v":0},{"$f":"+QUESTIONNAIRE!C305","v":0},{"$f":"+QUESTIONNAIRE!D305","v":0},{"$f":"+QUESTIONNAIRE!E305","v":0},null,null,null,293]
[{"$f":"+QUESTIONNAIRE!A306","v":0},{"$f":"+QUESTIONNAIRE!B306","v":0},{"$f":"+QUESTIONNAIRE!C306","v":0},{"$f":"+QUESTIONNAIRE!D306","v":"Does the analysis assess whether the project features (e.g. risk profile) are likely to attract financing on reasonable terms (e.g. long debt maturity)? "},{"$f":"+QUESTIONNAIRE!E306","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I306,FALSE)","v":"YES"},null,null,294,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A307","v":0},{"$f":"+QUESTIONNAIRE!B307","v":0},{"$f":"+QUESTIONNAIRE!C307","v":0},{"$f":"+QUESTIONNAIRE!D307","v":0},{"$f":"+QUESTIONNAIRE!E307","v":0},null,null,null,295]
[{"$f":"+QUESTIONNAIRE!A308","v":0},{"$f":"+QUESTIONNAIRE!B308","v":0},{"$f":"+QUESTIONNAIRE!C308","v":0},{"$f":"+QUESTIONNAIRE!D308","v":"Does the analysis assess whether financiers are likely to require public guarantees (e.g. minimum demand guarantees)?"},{"$f":"+QUESTIONNAIRE!E308","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I308,FALSE)","v":"YES"},null,null,296,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A309","v":0},{"$f":"+QUESTIONNAIRE!B309","v":0},{"$f":"+QUESTIONNAIRE!C309","v":0},{"$f":"+QUESTIONNAIRE!D309","v":0},{"$f":"+QUESTIONNAIRE!E309","v":0},null,null,null,297]
[{"$f":"+QUESTIONNAIRE!A310","v":0},{"$f":"+QUESTIONNAIRE!B310","v":0},{"$f":"+QUESTIONNAIRE!C310","v":0},{"$f":"+QUESTIONNAIRE!D310","v":"Where public sector payment obligations are expected to arise, does the analysis assess whether the financiers will be comfortable with the relevant public bodies' ability to meet these obligations?"},{"$f":"+QUESTIONNAIRE!E310","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I310,FALSE)","v":"YES"},null,null,298,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A311","v":0},{"$f":"+QUESTIONNAIRE!B311","v":0},{"$f":"+QUESTIONNAIRE!C311","v":0},{"$f":"+QUESTIONNAIRE!D311","v":0},{"$f":"+QUESTIONNAIRE!E311","v":0},null,null,null,299]
[{"$f":"+QUESTIONNAIRE!A312","v":0},{"$f":"+QUESTIONNAIRE!B312","v":0},{"$f":"+QUESTIONNAIRE!C312","v":0},{"$f":"+QUESTIONNAIRE!D312","v":"Does the analysis assess whether the financiers will be comfortable with the financial standing and technical capacity of potential contractors and service providers? "},{"$f":"+QUESTIONNAIRE!E312","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I312,FALSE)","v":"YES"},null,null,300,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A313","v":0},{"$f":"+QUESTIONNAIRE!B313","v":0},{"$f":"+QUESTIONNAIRE!C313","v":0},{"$f":"+QUESTIONNAIRE!D313","v":0},{"$f":"+QUESTIONNAIRE!E313","v":0},null,null,null,301]
[{"$f":"+QUESTIONNAIRE!A314","v":0},{"$f":"+QUESTIONNAIRE!B314","v":"∞ "},{"$f":"+QUESTIONNAIRE!C314","v":"Have the Advisers been involved in the Market Sounding and Bankability Analysis?"},{"$f":"+QUESTIONNAIRE!D314","v":0},{"$f":"+QUESTIONNAIRE!E314","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I314,FALSE)","v":"YES"},null,null,302,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A315","v":0},{"$f":"+QUESTIONNAIRE!B315","v":0},{"$f":"+QUESTIONNAIRE!C315","v":0},{"$f":"+QUESTIONNAIRE!D315","v":0},{"$f":"+QUESTIONNAIRE!E315","v":0},null,null,null,303]
[{"$f":"+QUESTIONNAIRE!A316","v":0},{"$f":"+QUESTIONNAIRE!B316","v":0},{"$f":"+QUESTIONNAIRE!C316","v":"Does the analysis ensure that the number and scope of organisations contacted is sufficiently wide?"},{"$f":"+QUESTIONNAIRE!D316","v":0},{"$f":"+QUESTIONNAIRE!E316","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I316,FALSE)","v":"YES"},null,null,304,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A317","v":0},{"$f":"+QUESTIONNAIRE!B317","v":0},{"$f":"+QUESTIONNAIRE!C317","v":0},{"$f":"+QUESTIONNAIRE!D317","v":0},{"$f":"+QUESTIONNAIRE!E317","v":0},null,null,null,305]
[{"$f":"+QUESTIONNAIRE!A318","v":0},{"$f":"+QUESTIONNAIRE!B318","v":0},{"$f":"+QUESTIONNAIRE!C318","v":"Have the findings of the analysis been taken into account in the technical features and contractual arrangements of the project?"},{"$f":"+QUESTIONNAIRE!D318","v":0},{"$f":"+QUESTIONNAIRE!E318","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I318,FALSE)","v":"YES"},null,null,306,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A319","v":0},{"$f":"+QUESTIONNAIRE!B319","v":0},{"$f":"+QUESTIONNAIRE!C319","v":0},{"$f":"+QUESTIONNAIRE!D319","v":0},{"$f":"+QUESTIONNAIRE!E319","v":0},null,null,null,307]
[{"$f":"+QUESTIONNAIRE!A320","v":0},{"$f":"+QUESTIONNAIRE!B320","v":0},{"$f":"+QUESTIONNAIRE!C320","v":"Does the overall analysis of the market assess whether there is likely to be a strong level of competition between bidders in the procurement of the project?"},{"$f":"+QUESTIONNAIRE!D320","v":0},{"$f":"+QUESTIONNAIRE!E320","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I320,FALSE)","v":"YES"},null,null,308,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A321","v":0},{"$f":"+QUESTIONNAIRE!B321","v":0},{"$f":"+QUESTIONNAIRE!C321","v":0},{"$f":"+QUESTIONNAIRE!D321","v":0},{"$f":"+QUESTIONNAIRE!E321","v":0},null,null,null,309]
[{"$f":"+QUESTIONNAIRE!A322","v":0},{"$f":"+QUESTIONNAIRE!B322","v":0},{"$f":"+QUESTIONNAIRE!C322","v":"Has the assessment included a focus on identifying constraints to strong competition?"},{"$f":"+QUESTIONNAIRE!D322","v":0},{"$f":"+QUESTIONNAIRE!E322","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I322,FALSE)","v":"YES"},null,null,310,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A323","v":0},{"$f":"+QUESTIONNAIRE!B323","v":0},{"$f":"+QUESTIONNAIRE!C323","v":0},{"$f":"+QUESTIONNAIRE!D323","v":0},{"$f":"+QUESTIONNAIRE!E323","v":0},null,null,null,311]
[{"$f":"+QUESTIONNAIRE!A324","v":0},{"$f":"+QUESTIONNAIRE!B324","v":0},{"$f":"+QUESTIONNAIRE!C324","v":0},{"$f":"+QUESTIONNAIRE!D324","v":0},{"$f":"+QUESTIONNAIRE!E324","v":0},null,null,null,312]
[{"$f":"+QUESTIONNAIRE!A325","v":0},{"$f":"+QUESTIONNAIRE!B325","v":0},{"$f":"+QUESTIONNAIRE!C325","v":0},{"$f":"+QUESTIONNAIRE!D325","v":0},{"$f":"+QUESTIONNAIRE!E325","v":0},null,null,null,313]
[{"$f":"+QUESTIONNAIRE!A326","v":0},{"$f":"+QUESTIONNAIRE!C326","v":"Assessing the PPP option against alternative project delivery options"},null,{"$f":"+QUESTIONNAIRE!D326","v":0},{"$f":"+QUESTIONNAIRE!E326","v":0},null,null,null,314]
[{"$f":"+QUESTIONNAIRE!A327","v":0},{"$f":"+QUESTIONNAIRE!B327","v":0},{"$f":"+QUESTIONNAIRE!C327","v":0},{"$f":"+QUESTIONNAIRE!D327","v":0},{"$f":"+QUESTIONNAIRE!E327","v":0},null,null,null,315]
[{"$f":"+QUESTIONNAIRE!A328","v":0},{"$f":"+QUESTIONNAIRE!B328","v":0},{"$f":"+QUESTIONNAIRE!C328","v":0},{"$f":"+QUESTIONNAIRE!D328","v":0},{"$f":"+QUESTIONNAIRE!E328","v":0},null,null,null,316]
[{"$f":"+QUESTIONNAIRE!A329","v":0},{"$f":"+QUESTIONNAIRE!B329","v":0},{"$f":"+QUESTIONNAIRE!C329","v":0},{"$f":"+QUESTIONNAIRE!D329","v":0},{"$f":"+QUESTIONNAIRE!E329","v":0},null,null,null,317]
[{"$f":"+QUESTIONNAIRE!A330","v":0},{"$f":"+QUESTIONNAIRE!B330","v":0},{"$f":"+QUESTIONNAIRE!C330","v":"Has the PPP option been compared against alternative private and public project delivery options?"},{"$f":"+QUESTIONNAIRE!D330","v":0},{"$f":"+QUESTIONNAIRE!E330","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I330,FALSE)","v":"YES"},null,null,318,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A331","v":0},{"$f":"+QUESTIONNAIRE!B331","v":0},{"$f":"+QUESTIONNAIRE!C331","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D331","v":0},{"$f":"+QUESTIONNAIRE!E331","v":0},null,null,null,319]
[{"$f":"+QUESTIONNAIRE!A332","v":0},{"$f":"+QUESTIONNAIRE!B332","v":0},{"$f":"+QUESTIONNAIRE!C332","v":0},{"$f":"+QUESTIONNAIRE!D332","v":"Is there a mandatory approach to carrying out this comparison assessment?"},{"$f":"+QUESTIONNAIRE!E332","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I332,FALSE)","v":"YES"},null,null,320,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A333","v":0},{"$f":"+QUESTIONNAIRE!B333","v":0},{"$f":"+QUESTIONNAIRE!C333","v":0},{"$f":"+QUESTIONNAIRE!D333","v":0},{"$f":"+QUESTIONNAIRE!E333","v":0},null,null,null,321]
[{"$f":"+QUESTIONNAIRE!A334","v":0},{"$f":"+QUESTIONNAIRE!B334","v":0},{"$f":"+QUESTIONNAIRE!C334","v":0},{"$f":"+QUESTIONNAIRE!D334","v":"      If yes, has this approach been applied?"},{"$f":"+QUESTIONNAIRE!E334","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I334,FALSE)","v":"YES"},null,null,322,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A335","v":0},{"$f":"+QUESTIONNAIRE!B335","v":0},{"$f":"+QUESTIONNAIRE!C335","v":0},{"$f":"+QUESTIONNAIRE!D335","v":0},{"$f":"+QUESTIONNAIRE!E335","v":0},null,null,null,323]
[{"$f":"+QUESTIONNAIRE!A336","v":0},{"$f":"+QUESTIONNAIRE!B336","v":0},{"$f":"+QUESTIONNAIRE!C336","v":0},{"$f":"+QUESTIONNAIRE!D336","v":"Has the assessment involved a comparison of the overall long-term cost of various project delivery options of similar scope and service requirements?"},{"$f":"+QUESTIONNAIRE!E336","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I336,FALSE)","v":"YES"},null,null,324,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A337","v":0},{"$f":"+QUESTIONNAIRE!B337","v":0},{"$f":"+QUESTIONNAIRE!C337","v":0},{"$f":"+QUESTIONNAIRE!D337","v":0},{"$f":"+QUESTIONNAIRE!E337","v":0},null,null,null,325]
[{"$f":"+QUESTIONNAIRE!A338","v":0},{"$f":"+QUESTIONNAIRE!B338","v":0},{"$f":"+QUESTIONNAIRE!C338","v":0},{"$f":"+QUESTIONNAIRE!D338","v":"Has this assessment valued the impact of risks associated with each project delivery option?"},{"$f":"+QUESTIONNAIRE!E338","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I338,FALSE)","v":"YES"},null,null,326,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A339","v":0},{"$f":"+QUESTIONNAIRE!B339","v":0},{"$f":"+QUESTIONNAIRE!C339","v":0},{"$f":"+QUESTIONNAIRE!D339","v":0},{"$f":"+QUESTIONNAIRE!E339","v":0},null,null,null,327]
[{"$f":"+QUESTIONNAIRE!A340","v":0},{"$f":"+QUESTIONNAIRE!B340","v":0},{"$f":"+QUESTIONNAIRE!C340","v":0},{"$f":"+QUESTIONNAIRE!D340","v":"Has this assessment considered qualitative factors for each project delivery option, such as scope for flexibility, opportunities for innovation, management and organisational consequences for the Authority, commencement of service? "},{"$f":"+QUESTIONNAIRE!E340","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I340,FALSE)","v":"YES"},null,null,328,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A341","v":0},{"$f":"+QUESTIONNAIRE!B341","v":0},{"$f":"+QUESTIONNAIRE!C341","v":0},{"$f":"+QUESTIONNAIRE!D341","v":0},{"$f":"+QUESTIONNAIRE!E341","v":0},null,null,null,{"$f":"+I340+1","v":329}]
[{"$f":"+QUESTIONNAIRE!A342","v":0},{"$f":"+QUESTIONNAIRE!B342","v":0},{"$f":"+QUESTIONNAIRE!C342","v":0},{"$f":"+QUESTIONNAIRE!D342","v":"Has this assessment been based on evidence available from previous projects?"},{"$f":"+QUESTIONNAIRE!E342","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I342,FALSE)","v":"YES"},null,null,330,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A343","v":0},{"$f":"+QUESTIONNAIRE!B343","v":0},{"$f":"+QUESTIONNAIRE!C343","v":0},{"$f":"+QUESTIONNAIRE!D343","v":0},{"$f":"+QUESTIONNAIRE!E343","v":0},null,null,null,331]
[{"$f":"+QUESTIONNAIRE!A344","v":0},{"$f":"+QUESTIONNAIRE!B344","v":"∞ "},{"$f":"+QUESTIONNAIRE!C344","v":0},{"$f":"+QUESTIONNAIRE!D344","v":"Has the assessment included the level of competition in the market for each project delivery option ? (see Market sounding and bankability analysis)"},{"$f":"+QUESTIONNAIRE!E344","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I344,FALSE)","v":"YES"},null,null,332,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A345","v":0},{"$f":"+QUESTIONNAIRE!B345","v":0},{"$f":"+QUESTIONNAIRE!C345","v":0},{"$f":"+QUESTIONNAIRE!D345","v":0},{"$f":"+QUESTIONNAIRE!E345","v":0},null,null,null,333]
[{"$f":"+QUESTIONNAIRE!A346","v":0},{"$f":"+QUESTIONNAIRE!B346","v":"∞ "},{"$f":"+QUESTIONNAIRE!C346","v":0},{"$f":"+QUESTIONNAIRE!D346","v":"Have the capacity and resources of the project team to manage each project delivery option been assessed? (see Setting up a project team and a governance structure)"},{"$f":"+QUESTIONNAIRE!E346","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I346,FALSE)","v":"YES"},null,null,334,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A347","v":0},{"$f":"+QUESTIONNAIRE!B347","v":0},{"$f":"+QUESTIONNAIRE!C347","v":0},{"$f":"+QUESTIONNAIRE!D347","v":0},{"$f":"+QUESTIONNAIRE!E347","v":0},null,null,null,335]
[{"$f":"+QUESTIONNAIRE!A348","v":0},{"$f":"+QUESTIONNAIRE!B348","v":"∞ "},{"$f":"+QUESTIONNAIRE!C348","v":0},{"$f":"+QUESTIONNAIRE!D348","v":"Has the timetable of each project delivery option been assessed with respect  to the required deadline? (see Developing a plan and a timetable)"},{"$f":"+QUESTIONNAIRE!E348","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I348,FALSE)","v":"YES"},null,null,336,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A349","v":0},{"$f":"+QUESTIONNAIRE!B349","v":0},{"$f":"+QUESTIONNAIRE!C349","v":0},{"$f":"+QUESTIONNAIRE!D349","v":0},{"$f":"+QUESTIONNAIRE!E349","v":0},null,null,null,337]
[{"$f":"+QUESTIONNAIRE!A350","v":0},{"$f":"+QUESTIONNAIRE!B350","v":0},{"$f":"+QUESTIONNAIRE!C350","v":0},{"$f":"+QUESTIONNAIRE!D350","v":0},{"$f":"+QUESTIONNAIRE!E350","v":0},null,null,null,338]
[{"$f":"+QUESTIONNAIRE!A351","v":0},{"$f":"+QUESTIONNAIRE!C351","v":"Budgeting, accounting and statistical treatment"},null,{"$f":"+QUESTIONNAIRE!D351","v":0},{"$f":"+QUESTIONNAIRE!E351","v":0},null,null,null,339]
[{"$f":"+QUESTIONNAIRE!A352","v":0},{"$f":"+QUESTIONNAIRE!B352","v":0},{"$f":"+QUESTIONNAIRE!C352","v":0},{"$f":"+QUESTIONNAIRE!D352","v":0},{"$f":"+QUESTIONNAIRE!E352","v":0},null,null,null,340]
[{"$f":"+QUESTIONNAIRE!A353","v":0},{"$f":"+QUESTIONNAIRE!B353","v":0},{"$f":"+QUESTIONNAIRE!C353","v":0},{"$f":"+QUESTIONNAIRE!D353","v":0},{"$f":"+QUESTIONNAIRE!E353","v":0},null,null,null,341]
[{"$f":"+QUESTIONNAIRE!A354","v":0},{"$f":"+QUESTIONNAIRE!B354","v":0},{"$f":"+QUESTIONNAIRE!C354","v":0},{"$f":"+QUESTIONNAIRE!D354","v":0},{"$f":"+QUESTIONNAIRE!E354","v":0},null,null,null,342]
[{"$f":"+QUESTIONNAIRE!A355","v":0},{"$f":"+QUESTIONNAIRE!B355","v":0},{"$f":"+QUESTIONNAIRE!C355","v":"Has an assessment of the impact of the project on the Authority’s budget been carried out in accordance with the Authority’s own budgeting rules?"},{"$f":"+QUESTIONNAIRE!D355","v":0},{"$f":"+QUESTIONNAIRE!E355","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I355,FALSE)","v":"YES"},null,null,343,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A356","v":0},{"$f":"+QUESTIONNAIRE!B356","v":0},{"$f":"+QUESTIONNAIRE!C356","v":0},{"$f":"+QUESTIONNAIRE!D356","v":0},{"$f":"+QUESTIONNAIRE!E356","v":0},null,null,null,344]
[{"$f":"+QUESTIONNAIRE!A357","v":0},{"$f":"+QUESTIONNAIRE!B357","v":0},{"$f":"+QUESTIONNAIRE!C357","v":"Has an analysis of the likely accounting treatment of the project in the Authority’s financial statements been carried out?"},{"$f":"+QUESTIONNAIRE!D357","v":0},{"$f":"+QUESTIONNAIRE!E357","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I357,FALSE)","v":"YES"},null,null,345,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A358","v":0},{"$f":"+QUESTIONNAIRE!B358","v":0},{"$f":"+QUESTIONNAIRE!C358","v":0},{"$f":"+QUESTIONNAIRE!D358","v":0},{"$f":"+QUESTIONNAIRE!E358","v":0},null,null,null,346]
[{"$f":"+QUESTIONNAIRE!A359","v":0},{"$f":"+QUESTIONNAIRE!B359","v":0},{"$f":"+QUESTIONNAIRE!C359","v":"Is the country subject to Eurostat's European System of Accounts?"},{"$f":"+QUESTIONNAIRE!D359","v":0},{"$f":"+QUESTIONNAIRE!E359","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I359,FALSE)","v":"YES"},null,null,347,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A360","v":0},{"$f":"+QUESTIONNAIRE!B360","v":0},{"$f":"+QUESTIONNAIRE!C360","v":0},{"$f":"+QUESTIONNAIRE!D360","v":0},{"$f":"+QUESTIONNAIRE!E360","v":0},null,null,null,348]
[{"$f":"+QUESTIONNAIRE!A361","v":0},{"$f":"+QUESTIONNAIRE!B361","v":0},{"$f":"+QUESTIONNAIRE!C361","v":0},{"$f":"+QUESTIONNAIRE!D361","v":"If yes, has an analysis of the likely statistical treatment of the project (in accordance with Eurostat rules on PPPs and concessions) been carried out?"},{"$f":"+QUESTIONNAIRE!E361","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I361,FALSE)","v":"YES"},null,null,349,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A362","v":0},{"$f":"+QUESTIONNAIRE!B362","v":0},{"$f":"+QUESTIONNAIRE!C362","v":0},{"$f":"+QUESTIONNAIRE!D362","v":0},{"$f":"+QUESTIONNAIRE!E362","v":0},null,null,null,350]
[{"$f":"+QUESTIONNAIRE!A363","v":0},{"$f":"+QUESTIONNAIRE!B363","v":"∞ "},{"$f":"+QUESTIONNAIRE!C363","v":0},{"$f":"+QUESTIONNAIRE!D363","v":"If yes, has this analysis been performed with the support of the Advisers or the national statistical office? (see Setting up a project team and a governance structure)"},{"$f":"+QUESTIONNAIRE!E363","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I363,FALSE)","v":"YES"},null,null,351,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A364","v":0},{"$f":"+QUESTIONNAIRE!B364","v":0},{"$f":"+QUESTIONNAIRE!C364","v":0},{"$f":"+QUESTIONNAIRE!D364","v":0},{"$f":"+QUESTIONNAIRE!E364","v":0},null,null,null,352]
[{"$f":"+QUESTIONNAIRE!A365","v":0},{"$f":"+QUESTIONNAIRE!B365","v":0},{"$f":"+QUESTIONNAIRE!C365","v":0},{"$f":"+QUESTIONNAIRE!D365","v":0},{"$f":"+QUESTIONNAIRE!E365","v":0},null,null,null,353]
[{"$f":"+QUESTIONNAIRE!A366","v":0},{"$f":"+QUESTIONNAIRE!B366","v":0},{"$f":"+QUESTIONNAIRE!C366","v":0},{"$f":"+QUESTIONNAIRE!D366","v":0},{"$f":"+QUESTIONNAIRE!E366","v":0},null,null,null,354]
[{"$f":"+QUESTIONNAIRE!A367","v":0},{"$f":"+QUESTIONNAIRE!C367","v":"Preparing for procurement"},null,{"$f":"+QUESTIONNAIRE!D367","v":0},{"$f":"+QUESTIONNAIRE!E367","v":0},null,null,null,355]
[{"$f":"+QUESTIONNAIRE!A368","v":0},{"$f":"+QUESTIONNAIRE!B368","v":0},{"$f":"+QUESTIONNAIRE!C368","v":0},{"$f":"+QUESTIONNAIRE!D368","v":0},{"$f":"+QUESTIONNAIRE!E368","v":0},null,null,null,356]
[{"$f":"+QUESTIONNAIRE!A369","v":0},{"$f":"+QUESTIONNAIRE!B369","v":0},{"$f":"+QUESTIONNAIRE!C369","v":0},{"$f":"+QUESTIONNAIRE!D369","v":0},{"$f":"+QUESTIONNAIRE!E369","v":0},null,null,null,357]
[{"$f":"+QUESTIONNAIRE!A370","v":0},{"$f":"+QUESTIONNAIRE!C370","v":"Selecting the procurement approach"},{"$f":"+QUESTIONNAIRE!#REF!","v":{"$error":"#REF!"}},{"$f":"+QUESTIONNAIRE!D370","v":0},{"$f":"+QUESTIONNAIRE!E370","v":0},null,null,null,358]
[{"$f":"+QUESTIONNAIRE!A371","v":0},{"$f":"+QUESTIONNAIRE!B371","v":0},{"$f":"+QUESTIONNAIRE!C371","v":0},{"$f":"+QUESTIONNAIRE!D371","v":0},{"$f":"+QUESTIONNAIRE!E371","v":0},null,null,null,359]
[{"$f":"+QUESTIONNAIRE!A372","v":0},{"$f":"+QUESTIONNAIRE!B372","v":0},{"$f":"+QUESTIONNAIRE!C372","v":0},{"$f":"+QUESTIONNAIRE!D372","v":0},{"$f":"+QUESTIONNAIRE!E372","v":0},null,null,null,360]
[{"$f":"+QUESTIONNAIRE!A373","v":0},{"$f":"+QUESTIONNAIRE!B373","v":0},{"$f":"+QUESTIONNAIRE!C373","v":0},{"$f":"+QUESTIONNAIRE!D373","v":0},{"$f":"+QUESTIONNAIRE!E373","v":0},null,null,null,361]
[{"$f":"+QUESTIONNAIRE!A374","v":0},{"$f":"+QUESTIONNAIRE!B374","v":0},{"$f":"+QUESTIONNAIRE!C374","v":"Has an analysis been carried out to select the most appropriate procurement approach (e.g. competitive dialogue, negotiated procedure) for the project? "},{"$f":"+QUESTIONNAIRE!D374","v":0},{"$f":"+QUESTIONNAIRE!E374","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I374,FALSE)","v":"YES"},null,null,362,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A375","v":0},{"$f":"+QUESTIONNAIRE!B375","v":0},{"$f":"+QUESTIONNAIRE!C375","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D375","v":0},{"$f":"+QUESTIONNAIRE!E375","v":0},null,null,null,363]
[{"$f":"+QUESTIONNAIRE!A376","v":0},{"$f":"+QUESTIONNAIRE!B376","v":0},{"$f":"+QUESTIONNAIRE!C376","v":0},{"$f":"+QUESTIONNAIRE!D376","v":"Has this analysis considered the requirements of the applicable legislation (e.g. national public procurement legislation)? "},{"$f":"+QUESTIONNAIRE!E376","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I376,FALSE)","v":"YES"},null,null,364,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A377","v":0},{"$f":"+QUESTIONNAIRE!B377","v":0},{"$f":"+QUESTIONNAIRE!C377","v":0},{"$f":"+QUESTIONNAIRE!D377","v":0},{"$f":"+QUESTIONNAIRE!E377","v":0},null,null,null,365]
[{"$f":"+QUESTIONNAIRE!A378","v":0},{"$f":"+QUESTIONNAIRE!B378","v":0},{"$f":"+QUESTIONNAIRE!C378","v":0},{"$f":"+QUESTIONNAIRE!D378","v":"Has this analysis considered the features of the project (e.g. complexity, size) as well as the willingness and capacity of the Authority to predefine the technical and contractual solutions?"},{"$f":"+QUESTIONNAIRE!E378","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I378,FALSE)","v":"YES"},null,null,366,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A379","v":0},{"$f":"+QUESTIONNAIRE!B379","v":0},{"$f":"+QUESTIONNAIRE!C379","v":0},{"$f":"+QUESTIONNAIRE!D379","v":0},{"$f":"+QUESTIONNAIRE!E379","v":0},null,null,null,367]
[{"$f":"+QUESTIONNAIRE!A380","v":0},{"$f":"+QUESTIONNAIRE!B380","v":"∞ "},{"$f":"+QUESTIONNAIRE!C380","v":0},{"$f":"+QUESTIONNAIRE!D380","v":"Has this analysis considered the capacity of the Authority to manage the procurement  approach (see Setting up a project team and governance structure)?"},{"$f":"+QUESTIONNAIRE!E380","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I380,FALSE)","v":"YES"},null,null,368,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A381","v":0},{"$f":"+QUESTIONNAIRE!B381","v":0},{"$f":"+QUESTIONNAIRE!C381","v":0},{"$f":"+QUESTIONNAIRE!D381","v":0},{"$f":"+QUESTIONNAIRE!E381","v":0},null,null,null,369]
[{"$f":"+QUESTIONNAIRE!A382","v":0},{"$f":"+QUESTIONNAIRE!B382","v":0},{"$f":"+QUESTIONNAIRE!C382","v":0},{"$f":"+QUESTIONNAIRE!D382","v":0},{"$f":"+QUESTIONNAIRE!E382","v":0},null,null,null,370]
[{"$f":"+QUESTIONNAIRE!A383","v":0},{"$f":"+QUESTIONNAIRE!C383","v":"Defining the procurement process"},null,{"$f":"+QUESTIONNAIRE!D383","v":0},{"$f":"+QUESTIONNAIRE!E383","v":0},null,null,null,371]
[{"$f":"+QUESTIONNAIRE!A384","v":0},{"$f":"+QUESTIONNAIRE!B384","v":0},{"$f":"+QUESTIONNAIRE!C384","v":0},{"$f":"+QUESTIONNAIRE!D384","v":0},{"$f":"+QUESTIONNAIRE!E384","v":0},null,null,null,372]
[{"$f":"+QUESTIONNAIRE!A385","v":0},{"$f":"+QUESTIONNAIRE!B385","v":0},{"$f":"+QUESTIONNAIRE!C385","v":0},{"$f":"+QUESTIONNAIRE!D385","v":0},{"$f":"+QUESTIONNAIRE!E385","v":0},null,null,null,373]
[{"$f":"+QUESTIONNAIRE!A386","v":0},{"$f":"+QUESTIONNAIRE!B386","v":0},{"$f":"+QUESTIONNAIRE!C386","v":0},{"$f":"+QUESTIONNAIRE!D386","v":0},{"$f":"+QUESTIONNAIRE!E386","v":0},null,null,null,374]
[{"$f":"+QUESTIONNAIRE!A387","v":0},{"$f":"+QUESTIONNAIRE!B387","v":0},{"$f":"+QUESTIONNAIRE!C387","v":"Has an analysis been carried out to define the pre-qualification criteria to be used in the selection of the potential bidders? "},{"$f":"+QUESTIONNAIRE!D387","v":0},{"$f":"+QUESTIONNAIRE!E387","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I387,FALSE)","v":"YES"},null,null,375,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A388","v":0},{"$f":"+QUESTIONNAIRE!B388","v":0},{"$f":"+QUESTIONNAIRE!C388","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D388","v":0},{"$f":"+QUESTIONNAIRE!E388","v":0},null,null,null,376]
[{"$f":"+QUESTIONNAIRE!A389","v":0},{"$f":"+QUESTIONNAIRE!B389","v":0},{"$f":"+QUESTIONNAIRE!C389","v":0},{"$f":"+QUESTIONNAIRE!D389","v":"Has this analysis considered how the technical, financial and legal capacities of potential bidders will be appraised?"},{"$f":"+QUESTIONNAIRE!E389","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I389,FALSE)","v":"YES"},null,null,377,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A390","v":0},{"$f":"+QUESTIONNAIRE!B390","v":0},{"$f":"+QUESTIONNAIRE!C390","v":0},{"$f":"+QUESTIONNAIRE!D390","v":0},{"$f":"+QUESTIONNAIRE!E390","v":0},null,null,null,378]
[{"$f":"+QUESTIONNAIRE!A391","v":0},{"$f":"+QUESTIONNAIRE!B391","v":0},{"$f":"+QUESTIONNAIRE!C391","v":0},{"$f":"+QUESTIONNAIRE!D391","v":"Has a pre-qualification questionnaire been prepared that describes the information that must be provided by potential bidders?"},{"$f":"+QUESTIONNAIRE!E391","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I391,FALSE)","v":"YES"},null,null,379,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A392","v":0},{"$f":"+QUESTIONNAIRE!B392","v":0},{"$f":"+QUESTIONNAIRE!C392","v":0},{"$f":"+QUESTIONNAIRE!D392","v":0},{"$f":"+QUESTIONNAIRE!E392","v":0},null,null,null,380]
[{"$f":"+QUESTIONNAIRE!A393","v":0},{"$f":"+QUESTIONNAIRE!B393","v":0},{"$f":"+QUESTIONNAIRE!C393","v":0},{"$f":"+QUESTIONNAIRE!D393","v":"Has this analysis considered the maximum number of potential bidders that may be pre-qualified?"},{"$f":"+QUESTIONNAIRE!E393","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I393,FALSE)","v":"YES"},null,null,381,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A394","v":0},{"$f":"+QUESTIONNAIRE!B394","v":0},{"$f":"+QUESTIONNAIRE!C394","v":0},{"$f":"+QUESTIONNAIRE!D394","v":0},{"$f":"+QUESTIONNAIRE!E394","v":0},null,null,null,382]
[{"$f":"+QUESTIONNAIRE!A395","v":0},{"$f":"+QUESTIONNAIRE!B395","v":0},{"$f":"+QUESTIONNAIRE!C395","v":"Has an analysis been carried out to define and support the selection of the tender evaluation criteria? "},{"$f":"+QUESTIONNAIRE!D395","v":0},{"$f":"+QUESTIONNAIRE!E395","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I395,FALSE)","v":"YES"},null,null,383,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A396","v":0},{"$f":"+QUESTIONNAIRE!B396","v":0},{"$f":"+QUESTIONNAIRE!C396","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D396","v":0},{"$f":"+QUESTIONNAIRE!E396","v":0},null,null,null,384]
[{"$f":"+QUESTIONNAIRE!A397","v":0},{"$f":"+QUESTIONNAIRE!B397","v":0},{"$f":"+QUESTIONNAIRE!C397","v":0},{"$f":"+QUESTIONNAIRE!D397","v":"Has this analysis considered technical, financial and legal aspects as areas for evaluation?"},{"$f":"+QUESTIONNAIRE!E397","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I397,FALSE)","v":"YES"},null,null,385,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A398","v":0},{"$f":"+QUESTIONNAIRE!B398","v":0},{"$f":"+QUESTIONNAIRE!C398","v":0},{"$f":"+QUESTIONNAIRE!D398","v":0},{"$f":"+QUESTIONNAIRE!E398","v":0},null,null,null,386]
[{"$f":"+QUESTIONNAIRE!A399","v":0},{"$f":"+QUESTIONNAIRE!B399","v":0},{"$f":"+QUESTIONNAIRE!C399","v":0},{"$f":"+QUESTIONNAIRE!D399","v":"Has this analysis identified a scoring and weighting mechanism for each of the evaluation criteria? "},{"$f":"+QUESTIONNAIRE!E399","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I399,FALSE)","v":"YES"},null,null,387,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A400","v":0},{"$f":"+QUESTIONNAIRE!B400","v":0},{"$f":"+QUESTIONNAIRE!C400","v":0},{"$f":"+QUESTIONNAIRE!D400","v":0},{"$f":"+QUESTIONNAIRE!E400","v":0},null,null,null,388]
[{"$f":"+QUESTIONNAIRE!A401","v":0},{"$f":"+QUESTIONNAIRE!B401","v":0},{"$f":"+QUESTIONNAIRE!C401","v":0},{"$f":"+QUESTIONNAIRE!D401","v":"Have the criteria, scoring and weighting been checked to reflect the Authority's priorities (e.g. functionality, price, aesthetics)?"},{"$f":"+QUESTIONNAIRE!E401","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I401,FALSE)","v":"YES"},null,null,389,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A402","v":0},{"$f":"+QUESTIONNAIRE!B402","v":0},{"$f":"+QUESTIONNAIRE!C402","v":0},{"$f":"+QUESTIONNAIRE!D402","v":0},{"$f":"+QUESTIONNAIRE!E402","v":0},null,null,null,390]
[{"$f":"+QUESTIONNAIRE!A403","v":0},{"$f":"+QUESTIONNAIRE!B403","v":0},{"$f":"+QUESTIONNAIRE!C403","v":0},{"$f":"+QUESTIONNAIRE!D403","v":"Has the project steering committee/senior management approved the selection criteria?"},{"$f":"+QUESTIONNAIRE!E403","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I403,FALSE)","v":"YES"},null,null,391,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A404","v":0},{"$f":"+QUESTIONNAIRE!B404","v":0},{"$f":"+QUESTIONNAIRE!C404","v":0},{"$f":"+QUESTIONNAIRE!D404","v":0},{"$f":"+QUESTIONNAIRE!E404","v":0},null,null,null,392]
[{"$f":"+QUESTIONNAIRE!A405","v":0},{"$f":"+QUESTIONNAIRE!B405","v":0},{"$f":"+QUESTIONNAIRE!C405","v":"Has a tender evaluation team been established? "},null,null,{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I405,FALSE)","v":"YES"},null,null,{"$f":"+I404+1","v":393},"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A406","v":0},{"$f":"+QUESTIONNAIRE!B406","v":0},{"$f":"+QUESTIONNAIRE!C406","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D406","v":0},{"$f":"+QUESTIONNAIRE!E406","v":0},null,null,null,394]
[{"$f":"+QUESTIONNAIRE!A407","v":0},{"$f":"+QUESTIONNAIRE!B407","v":0},{"$f":"+QUESTIONNAIRE!C407","v":0},{"$f":"+QUESTIONNAIRE!D407","v":"Have the members of the tender evaluation team been identified taking into account their capability?"},{"$f":"+QUESTIONNAIRE!E407","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I407,FALSE)","v":"YES"},null,null,395,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A408","v":0},{"$f":"+QUESTIONNAIRE!B408","v":0},{"$f":"+QUESTIONNAIRE!C408","v":0},{"$f":"+QUESTIONNAIRE!D408","v":0},{"$f":"+QUESTIONNAIRE!E408","v":0},null,null,null,396]
[{"$f":"+QUESTIONNAIRE!A409","v":0},{"$f":"+QUESTIONNAIRE!B409","v":0},{"$f":"+QUESTIONNAIRE!C409","v":0},{"$f":"+QUESTIONNAIRE!D409","v":"Have the persons within the team that will be in charge of evaluating each criterion been nominated?"},{"$f":"+QUESTIONNAIRE!E409","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I409,FALSE)","v":"YES"},null,null,397,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A410","v":0},{"$f":"+QUESTIONNAIRE!B410","v":0},{"$f":"+QUESTIONNAIRE!C410","v":0},{"$f":"+QUESTIONNAIRE!D410","v":0},{"$f":"+QUESTIONNAIRE!E410","v":0},null,null,null,398]
[{"$f":"+QUESTIONNAIRE!A411","v":0},{"$f":"+QUESTIONNAIRE!B411","v":0},{"$f":"+QUESTIONNAIRE!C411","v":0},{"$f":"+QUESTIONNAIRE!D411","v":"Have potential conflict of interest issues been addressed when establishing the tender evaluation team?"},{"$f":"+QUESTIONNAIRE!E411","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I411,FALSE)","v":"YES"},null,null,399,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A412","v":0},{"$f":"+QUESTIONNAIRE!B412","v":0},{"$f":"+QUESTIONNAIRE!C412","v":0},{"$f":"+QUESTIONNAIRE!D412","v":0},{"$f":"+QUESTIONNAIRE!E412","v":0},null,null,null,400]
[{"$f":"+QUESTIONNAIRE!A413","v":0},{"$f":"+QUESTIONNAIRE!B413","v":0},{"$f":"+QUESTIONNAIRE!C413","v":0},{"$f":"+QUESTIONNAIRE!D413","v":"Have governance arrangements for the operation of the tender evaluation team and decision-making processes been established and approved?"},{"$f":"+QUESTIONNAIRE!E413","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I413,FALSE)","v":"YES"},null,null,401,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A414","v":0},{"$f":"+QUESTIONNAIRE!B414","v":0},{"$f":"+QUESTIONNAIRE!C414","v":0},{"$f":"+QUESTIONNAIRE!D414","v":0},{"$f":"+QUESTIONNAIRE!E414","v":0},null,null,null,402]
[{"$f":"+QUESTIONNAIRE!A415","v":0},{"$f":"+QUESTIONNAIRE!B415","v":0},{"$f":"+QUESTIONNAIRE!C415","v":"Have a project promotion plan (e.g. road shows) and a procurement notice been prepared taking into account the technical features and contractual arrangements of the project in order to raise interest of the market?"},{"$f":"+QUESTIONNAIRE!D415","v":0},{"$f":"+QUESTIONNAIRE!E415","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I415,FALSE)","v":"YES"},null,null,403,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A416","v":0},{"$f":"+QUESTIONNAIRE!B416","v":0},{"$f":"+QUESTIONNAIRE!C416","v":0},{"$f":"+QUESTIONNAIRE!D416","v":0},{"$f":"+QUESTIONNAIRE!E416","v":0},null,null,null,404]
[{"$f":"+QUESTIONNAIRE!A417","v":0},{"$f":"+QUESTIONNAIRE!B417","v":0},{"$f":"+QUESTIONNAIRE!C417","v":"Have the draft documents comprising the invitation to tender been prepared? "},{"$f":"+QUESTIONNAIRE!D417","v":0},{"$f":"+QUESTIONNAIRE!E417","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I417,FALSE)","v":"YES"},null,null,405,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A418","v":0},{"$f":"+QUESTIONNAIRE!B418","v":0},{"$f":"+QUESTIONNAIRE!C418","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D418","v":0},{"$f":"+QUESTIONNAIRE!E418","v":0},null,null,null,406]
[{"$f":"+QUESTIONNAIRE!A419","v":0},{"$f":"+QUESTIONNAIRE!B419","v":0},{"$f":"+QUESTIONNAIRE!C419","v":0},{"$f":"+QUESTIONNAIRE!D419","v":"Do these documents describe the key rules, steps and the requirements to be met (e.g. confidentiality undertakings, deadlines and heads of terms of the key agreements)?"},{"$f":"+QUESTIONNAIRE!E419","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I419,FALSE)","v":"YES"},null,null,407,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A420","v":0},{"$f":"+QUESTIONNAIRE!B420","v":0},{"$f":"+QUESTIONNAIRE!C420","v":0},{"$f":"+QUESTIONNAIRE!D420","v":0},{"$f":"+QUESTIONNAIRE!E420","v":0},null,null,null,408]
[{"$f":"+QUESTIONNAIRE!A421","v":0},{"$f":"+QUESTIONNAIRE!B421","v":0},{"$f":"+QUESTIONNAIRE!C421","v":0},{"$f":"+QUESTIONNAIRE!D421","v":"Do these documents provide potential bidders with sufficient background information to help them understand the project features and the Authority’s requirements (e.g. project information memorandum, document dataroom)?"},{"$f":"+QUESTIONNAIRE!E421","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I421,FALSE)","v":"YES"},null,null,409,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A422","v":0},{"$f":"+QUESTIONNAIRE!B422","v":0},{"$f":"+QUESTIONNAIRE!C422","v":0},{"$f":"+QUESTIONNAIRE!D422","v":0},{"$f":"+QUESTIONNAIRE!E422","v":0},null,null,null,410]
[{"$f":"+QUESTIONNAIRE!A423","v":0},{"$f":"+QUESTIONNAIRE!B423","v":0},{"$f":"+QUESTIONNAIRE!C423","v":0},{"$f":"+QUESTIONNAIRE!D423","v":0},{"$f":"+QUESTIONNAIRE!E423","v":0},null,null,null,411]
[{"$f":"+QUESTIONNAIRE!A424","v":0},{"$f":"+QUESTIONNAIRE!C424","v":"Developing the service output requirements and preparing the draft PPP contract"},null,{"$f":"+QUESTIONNAIRE!D424","v":0},{"$f":"+QUESTIONNAIRE!E424","v":0},null,null,null,412]
[{"$f":"+QUESTIONNAIRE!A425","v":0},{"$f":"+QUESTIONNAIRE!B425","v":0},{"$f":"+QUESTIONNAIRE!C425","v":0},{"$f":"+QUESTIONNAIRE!D425","v":0},{"$f":"+QUESTIONNAIRE!E425","v":0},null,null,null,413]
[{"$f":"+QUESTIONNAIRE!A426","v":0},{"$f":"+QUESTIONNAIRE!B426","v":0},{"$f":"+QUESTIONNAIRE!C426","v":0},{"$f":"+QUESTIONNAIRE!D426","v":0},{"$f":"+QUESTIONNAIRE!E426","v":0},null,null,null,414]
[{"$f":"+QUESTIONNAIRE!A427","v":0},{"$f":"+QUESTIONNAIRE!B427","v":0},{"$f":"+QUESTIONNAIRE!C427","v":0},{"$f":"+QUESTIONNAIRE!D427","v":0},{"$f":"+QUESTIONNAIRE!E427","v":0},null,null,null,415]
[{"$f":"+QUESTIONNAIRE!A428","v":0},{"$f":"+QUESTIONNAIRE!B428","v":0},{"$f":"+QUESTIONNAIRE!C428","v":"Have the service output requirements and payment mechanism been developed? "},{"$f":"+QUESTIONNAIRE!D428","v":0},{"$f":"+QUESTIONNAIRE!E428","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I428,FALSE)","v":"YES"},null,null,416,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A429","v":0},{"$f":"+QUESTIONNAIRE!B429","v":0},{"$f":"+QUESTIONNAIRE!C429","v":"If yes:"},{"$f":"+QUESTIONNAIRE!D429","v":0},{"$f":"+QUESTIONNAIRE!E429","v":0},null,null,null,417]
[{"$f":"+QUESTIONNAIRE!A430","v":0},{"$f":"+QUESTIONNAIRE!B430","v":0},{"$f":"+QUESTIONNAIRE!C430","v":0},{"$f":"+QUESTIONNAIRE!D430","v":"Have the service output requirements been checked to ensure that they continue reflect the need for the investment?"},{"$f":"+QUESTIONNAIRE!E430","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I430,FALSE)","v":"YES"},null,null,418,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A431","v":0},{"$f":"+QUESTIONNAIRE!B431","v":0},{"$f":"+QUESTIONNAIRE!C431","v":0},{"$f":"+QUESTIONNAIRE!D431","v":0},{"$f":"+QUESTIONNAIRE!E431","v":0},null,null,null,419]
[{"$f":"+QUESTIONNAIRE!A432","v":0},{"$f":"+QUESTIONNAIRE!B432","v":0},{"$f":"+QUESTIONNAIRE!C432","v":0},{"$f":"+QUESTIONNAIRE!D432","v":"Has the payment mechanism been designed to provide the appropriate incentives for the private partner to deliver the service output requirements?"},{"$f":"+QUESTIONNAIRE!E432","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I432,FALSE)","v":"YES"},null,null,420,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A433","v":0},{"$f":"+QUESTIONNAIRE!B433","v":0},{"$f":"+QUESTIONNAIRE!C433","v":0},{"$f":"+QUESTIONNAIRE!D433","v":0},{"$f":"+QUESTIONNAIRE!E433","v":0},null,null,null,421]
[{"$f":"+QUESTIONNAIRE!A434","v":0},{"$f":"+QUESTIONNAIRE!B434","v":0},{"$f":"+QUESTIONNAIRE!C434","v":0},{"$f":"+QUESTIONNAIRE!D434","v":"Has the payment mechanism been assessed to be consistent with the Affordability, Market Sounding and Bankability Analyses?"},{"$f":"+QUESTIONNAIRE!E434","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I434,FALSE)","v":"YES"},null,null,422,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A435","v":0},{"$f":"+QUESTIONNAIRE!B435","v":0},{"$f":"+QUESTIONNAIRE!C435","v":0},{"$f":"+QUESTIONNAIRE!D435","v":0},{"$f":"+QUESTIONNAIRE!E435","v":0},null,null,null,423]
[{"$f":"+QUESTIONNAIRE!A436","v":0},{"$f":"+QUESTIONNAIRE!B436","v":0},{"$f":"+QUESTIONNAIRE!C436","v":"When preparing the draft PPP contract have the following matters been taken into consideration:"},{"$f":"+QUESTIONNAIRE!D436","v":0},{"$f":"+QUESTIONNAIRE!E436","v":0},null,null,null,424]
[{"$f":"+QUESTIONNAIRE!A437","v":0},{"$f":"+QUESTIONNAIRE!B437","v":0},{"$f":"+QUESTIONNAIRE!C437","v":0},{"$f":"+QUESTIONNAIRE!D437","v":0},{"$f":"+QUESTIONNAIRE!E437","v":0},null,null,null,425]
[{"$f":"+QUESTIONNAIRE!A438","v":0},{"$f":"+QUESTIONNAIRE!B438","v":0},{"$f":"+QUESTIONNAIRE!C438","v":0},{"$f":"+QUESTIONNAIRE!D438","v":"Duration of the PPP contract?"},{"$f":"+QUESTIONNAIRE!E438","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I438,FALSE)","v":"YES"},null,null,426,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A439","v":0},{"$f":"+QUESTIONNAIRE!B439","v":0},{"$f":"+QUESTIONNAIRE!C439","v":0},{"$f":"+QUESTIONNAIRE!D439","v":0},{"$f":"+QUESTIONNAIRE!E439","v":0},null,null,null,427]
[{"$f":"+QUESTIONNAIRE!A440","v":0},{"$f":"+QUESTIONNAIRE!B440","v":"∞ "},{"$f":"+QUESTIONNAIRE!C440","v":0},{"$f":"+QUESTIONNAIRE!D440","v":"Allocation and sharing of the risks? (see Developing the risk analysis)"},{"$f":"+QUESTIONNAIRE!E440","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I440,FALSE)","v":"YES"},null,null,428,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A441","v":0},{"$f":"+QUESTIONNAIRE!B441","v":0},{"$f":"+QUESTIONNAIRE!C441","v":0},{"$f":"+QUESTIONNAIRE!D441","v":0},{"$f":"+QUESTIONNAIRE!E441","v":0},null,null,null,429]
[{"$f":"+QUESTIONNAIRE!A442","v":0},{"$f":"+QUESTIONNAIRE!B442","v":0},{"$f":"+QUESTIONNAIRE!C442","v":0},{"$f":"+QUESTIONNAIRE!D442","v":"Performance requirements set by the Authority? "},{"$f":"+QUESTIONNAIRE!E442","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I442,FALSE)","v":"YES"},null,null,430,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A443","v":0},{"$f":"+QUESTIONNAIRE!B443","v":0},{"$f":"+QUESTIONNAIRE!C443","v":0},{"$f":"+QUESTIONNAIRE!D443","v":0},{"$f":"+QUESTIONNAIRE!E443","v":0},null,null,null,431]
[{"$f":"+QUESTIONNAIRE!A444","v":0},{"$f":"+QUESTIONNAIRE!B444","v":0},{"$f":"+QUESTIONNAIRE!C444","v":0},{"$f":"+QUESTIONNAIRE!D444","v":"Payment mechanism?"},{"$f":"+QUESTIONNAIRE!E444","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I444,FALSE)","v":"YES"},null,null,432,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A445","v":0},{"$f":"+QUESTIONNAIRE!B445","v":0},{"$f":"+QUESTIONNAIRE!C445","v":0},{"$f":"+QUESTIONNAIRE!D445","v":0},{"$f":"+QUESTIONNAIRE!E445","v":0},null,null,null,433]
[{"$f":"+QUESTIONNAIRE!A446","v":0},{"$f":"+QUESTIONNAIRE!B446","v":0},{"$f":"+QUESTIONNAIRE!C446","v":0},{"$f":"+QUESTIONNAIRE!D446","v":"Procedure for dealing with changes (e.g. price indexation, changes to the service requirements)?"},{"$f":"+QUESTIONNAIRE!E446","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I446,FALSE)","v":"YES"},null,null,434,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A447","v":0},{"$f":"+QUESTIONNAIRE!B447","v":0},{"$f":"+QUESTIONNAIRE!C447","v":0},{"$f":"+QUESTIONNAIRE!D447","v":0},{"$f":"+QUESTIONNAIRE!E447","v":0},null,null,null,435]
[{"$f":"+QUESTIONNAIRE!A448","v":0},{"$f":"+QUESTIONNAIRE!B448","v":0},{"$f":"+QUESTIONNAIRE!C448","v":0},{"$f":"+QUESTIONNAIRE!D448","v":"Construction completion procedure?"},{"$f":"+QUESTIONNAIRE!E448","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I448,FALSE)","v":"YES"},null,null,436,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A449","v":0},{"$f":"+QUESTIONNAIRE!B449","v":0},{"$f":"+QUESTIONNAIRE!C449","v":0},{"$f":"+QUESTIONNAIRE!D449","v":0},{"$f":"+QUESTIONNAIRE!E449","v":0},null,null,null,437]
[{"$f":"+QUESTIONNAIRE!A450","v":0},{"$f":"+QUESTIONNAIRE!B450","v":0},{"$f":"+QUESTIONNAIRE!C450","v":0},{"$f":"+QUESTIONNAIRE!D450","v":"Force majeure events?"},{"$f":"+QUESTIONNAIRE!E450","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I450,FALSE)","v":"YES"},null,null,438,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A451","v":0},{"$f":"+QUESTIONNAIRE!B451","v":0},{"$f":"+QUESTIONNAIRE!C451","v":0},{"$f":"+QUESTIONNAIRE!D451","v":0},{"$f":"+QUESTIONNAIRE!E451","v":0},null,null,null,439]
[{"$f":"+QUESTIONNAIRE!A452","v":0},{"$f":"+QUESTIONNAIRE!B452","v":0},{"$f":"+QUESTIONNAIRE!C452","v":0},{"$f":"+QUESTIONNAIRE!D452","v":"Transfer of staff to the private partner?"},{"$f":"+QUESTIONNAIRE!E452","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I452,FALSE)","v":"YES"},null,null,440,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A453","v":0},{"$f":"+QUESTIONNAIRE!B453","v":0},{"$f":"+QUESTIONNAIRE!C453","v":0},{"$f":"+QUESTIONNAIRE!D453","v":0},{"$f":"+QUESTIONNAIRE!E453","v":0},null,null,null,441]
[{"$f":"+QUESTIONNAIRE!A454","v":0},{"$f":"+QUESTIONNAIRE!B454","v":0},{"$f":"+QUESTIONNAIRE!C454","v":0},{"$f":"+QUESTIONNAIRE!D454","v":"Monitoring requirements of the Authority during the contract life?"},{"$f":"+QUESTIONNAIRE!E454","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I454,FALSE)","v":"YES"},null,null,442,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A455","v":0},{"$f":"+QUESTIONNAIRE!B455","v":0},{"$f":"+QUESTIONNAIRE!C455","v":0},{"$f":"+QUESTIONNAIRE!D455","v":0},{"$f":"+QUESTIONNAIRE!E455","v":0},null,null,null,443]
[{"$f":"+QUESTIONNAIRE!A456","v":0},{"$f":"+QUESTIONNAIRE!B456","v":0},{"$f":"+QUESTIONNAIRE!C456","v":0},{"$f":"+QUESTIONNAIRE!D456","v":"Direct agreement with the lenders and lenders’ step-in rights?"},{"$f":"+QUESTIONNAIRE!E456","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I456,FALSE)","v":"YES"},null,null,444,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A457","v":0},{"$f":"+QUESTIONNAIRE!B457","v":0},{"$f":"+QUESTIONNAIRE!C457","v":0},{"$f":"+QUESTIONNAIRE!D457","v":0},{"$f":"+QUESTIONNAIRE!E457","v":0},null,null,null,445]
[{"$f":"+QUESTIONNAIRE!A458","v":0},{"$f":"+QUESTIONNAIRE!B458","v":0},{"$f":"+QUESTIONNAIRE!C458","v":0},{"$f":"+QUESTIONNAIRE!D458","v":"Authority step-in rights?"},{"$f":"+QUESTIONNAIRE!E458","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I458,FALSE)","v":"YES"},null,null,446,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A459","v":0},{"$f":"+QUESTIONNAIRE!B459","v":0},{"$f":"+QUESTIONNAIRE!C459","v":0},{"$f":"+QUESTIONNAIRE!D459","v":0},{"$f":"+QUESTIONNAIRE!E459","v":0},null,null,null,447]
[{"$f":"+QUESTIONNAIRE!A460","v":0},{"$f":"+QUESTIONNAIRE!B460","v":0},{"$f":"+QUESTIONNAIRE!C460","v":0},{"$f":"+QUESTIONNAIRE!D460","v":"Dispute resolution?"},{"$f":"+QUESTIONNAIRE!E460","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I460,FALSE)","v":"YES"},null,null,448,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A461","v":0},{"$f":"+QUESTIONNAIRE!B461","v":0},{"$f":"+QUESTIONNAIRE!C461","v":0},{"$f":"+QUESTIONNAIRE!D461","v":0},{"$f":"+QUESTIONNAIRE!E461","v":0},null,null,null,449]
[{"$f":"+QUESTIONNAIRE!A462","v":0},{"$f":"+QUESTIONNAIRE!B462","v":0},{"$f":"+QUESTIONNAIRE!C462","v":0},{"$f":"+QUESTIONNAIRE!D462","v":"Insurance requirements?"},{"$f":"+QUESTIONNAIRE!E462","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I462,FALSE)","v":"YES"},null,null,450,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A463","v":0},{"$f":"+QUESTIONNAIRE!B463","v":0},{"$f":"+QUESTIONNAIRE!C463","v":0},{"$f":"+QUESTIONNAIRE!D463","v":0},{"$f":"+QUESTIONNAIRE!E463","v":0},null,null,null,451]
[{"$f":"+QUESTIONNAIRE!A464","v":0},{"$f":"+QUESTIONNAIRE!B464","v":0},{"$f":"+QUESTIONNAIRE!C464","v":0},{"$f":"+QUESTIONNAIRE!D464","v":"Sharing of benefits arising from refinancing?"},{"$f":"+QUESTIONNAIRE!E464","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I464,FALSE)","v":"YES"},null,null,452,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A465","v":0},{"$f":"+QUESTIONNAIRE!B465","v":0},{"$f":"+QUESTIONNAIRE!C465","v":0},{"$f":"+QUESTIONNAIRE!D465","v":0},{"$f":"+QUESTIONNAIRE!E465","v":0},null,null,null,453]
[{"$f":"+QUESTIONNAIRE!A466","v":0},{"$f":"+QUESTIONNAIRE!B466","v":0},{"$f":"+QUESTIONNAIRE!C466","v":0},{"$f":"+QUESTIONNAIRE!D466","v":"Early termination of the PPP contract and compensation payments?"},{"$f":"+QUESTIONNAIRE!E466","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I466,FALSE)","v":"YES"},null,null,454,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A467","v":0},{"$f":"+QUESTIONNAIRE!B467","v":0},{"$f":"+QUESTIONNAIRE!C467","v":0},{"$f":"+QUESTIONNAIRE!D467","v":0},{"$f":"+QUESTIONNAIRE!E467","v":0},null,null,null,455]
[{"$f":"+QUESTIONNAIRE!A468","v":0},{"$f":"+QUESTIONNAIRE!B468","v":0},{"$f":"+QUESTIONNAIRE!C468","v":0},{"$f":"+QUESTIONNAIRE!D468","v":"Hand-back of the project assets at expiry of the PPP contract?"},{"$f":"+QUESTIONNAIRE!E468","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I468,FALSE)","v":"YES"},null,null,456,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A469","v":0},{"$f":"+QUESTIONNAIRE!B469","v":0},{"$f":"+QUESTIONNAIRE!C469","v":0},{"$f":"+QUESTIONNAIRE!D469","v":0},{"$f":"+QUESTIONNAIRE!E469","v":0},null,null,null,{"$f":"+I468+1","v":457}]
[{"$f":"+QUESTIONNAIRE!A470","v":0},{"$f":"+QUESTIONNAIRE!B470","v":0},{"$f":"+QUESTIONNAIRE!C470","v":0},{"$f":"+QUESTIONNAIRE!D470","v":0},{"$f":"+QUESTIONNAIRE!E470","v":0},{"$f":"+QUESTIONNAIRE!F470","v":0},null,null,458,null,0]
[{"$f":"+QUESTIONNAIRE!A471","v":0},{"$f":"+QUESTIONNAIRE!B471","v":0},{"$f":"+QUESTIONNAIRE!C471","v":0},{"$f":"+QUESTIONNAIRE!D471","v":0},{"$f":"+QUESTIONNAIRE!E471","v":0},{"$f":"+QUESTIONNAIRE!F471","v":0},null,null,459,null,0]
[{"$f":"+QUESTIONNAIRE!A472","v":0},{"$f":"+QUESTIONNAIRE!B472","v":0},{"$f":"+QUESTIONNAIRE!C472","v":0},{"$f":"+QUESTIONNAIRE!D472","v":0},{"$f":"+QUESTIONNAIRE!E472","v":0},{"$f":"+QUESTIONNAIRE!F472","v":0},null,null,460,null,0]
[{"$f":"+QUESTIONNAIRE!A473","v":0},{"$f":"+QUESTIONNAIRE!B473","v":0},null,null,{"$f":"+QUESTIONNAIRE!E473","v":0},{"$f":"+QUESTIONNAIRE!F473","v":0},null,null,461,null,0]
[{"$f":"+QUESTIONNAIRE!A474","v":0},{"$f":"+QUESTIONNAIRE!B474","v":0},{"$f":"+QUESTIONNAIRE!C474","v":"READINESS TO PROCURE THE PROJECT"},null,null,{"$f":"+QUESTIONNAIRE!F474","v":0},null,null,462,null,0]
[{"$f":"+QUESTIONNAIRE!A475","v":0},{"$f":"+QUESTIONNAIRE!B475","v":0},{"$f":"+QUESTIONNAIRE!C475","v":0},null,null,{"$f":"+QUESTIONNAIRE!F475","v":0},null,null,463,null,0]
[{"$f":"+QUESTIONNAIRE!A476","v":0},{"$f":"+QUESTIONNAIRE!B476","v":0},{"$f":"+QUESTIONNAIRE!C476","v":0},{"$f":"+QUESTIONNAIRE!D476","v":0},{"$f":"+QUESTIONNAIRE!E476","v":0},{"$f":"+QUESTIONNAIRE!F476","v":0},null,null,464,null,0]
[{"$f":"+QUESTIONNAIRE!A477","v":0},{"$f":"+QUESTIONNAIRE!B477","v":0},{"$f":"+QUESTIONNAIRE!C477","v":0},{"$f":"+QUESTIONNAIRE!D477","v":0},{"$f":"+QUESTIONNAIRE!E477","v":0},{"$f":"+QUESTIONNAIRE!F477","v":0},null,null,465,null,0]
[{"$f":"+QUESTIONNAIRE!A478","v":0},{"$f":"+QUESTIONNAIRE!B478","v":0},{"$f":"+QUESTIONNAIRE!C478","v":0},{"$f":"+QUESTIONNAIRE!D478","v":0},{"$f":"+QUESTIONNAIRE!E478","v":0},{"$f":"+QUESTIONNAIRE!F478","v":0},null,null,466,null,0]
[{"$f":"+QUESTIONNAIRE!A479","v":0},{"$f":"+QUESTIONNAIRE!B479","v":"→"},{"$f":"+QUESTIONNAIRE!C479","v":"Does the proposed project still address the needs of the contracting authority?"},{"$f":"+QUESTIONNAIRE!D479","v":0},{"$f":"+QUESTIONNAIRE!E479","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I479,FALSE)","v":"YES"},null,null,467,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A480","v":0},{"$f":"+QUESTIONNAIRE!B480","v":0},{"$f":"+QUESTIONNAIRE!C480","v":0},{"$f":"+QUESTIONNAIRE!D480","v":0},{"$f":"+QUESTIONNAIRE!E480","v":0},null,null,null,468]
[{"$f":"+QUESTIONNAIRE!A481","v":0},{"$f":"+QUESTIONNAIRE!B481","v":"→"},{"$f":"+QUESTIONNAIRE!C481","v":"Is a PPP approach still identified as the preferred delivery approach for the project?"},{"$f":"+QUESTIONNAIRE!D481","v":0},{"$f":"+QUESTIONNAIRE!E481","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I481,FALSE)","v":"YES"},null,null,469,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A482","v":0},{"$f":"+QUESTIONNAIRE!B482","v":0},{"$f":"+QUESTIONNAIRE!C482","v":0},{"$f":"+QUESTIONNAIRE!D482","v":0},{"$f":"+QUESTIONNAIRE!E482","v":0},null,null,null,470]
[{"$f":"+QUESTIONNAIRE!A483","v":0},{"$f":"+QUESTIONNAIRE!B483","v":"→"},{"$f":"+QUESTIONNAIRE!C483","v":"Is the PPP project considered affordable?"},{"$f":"+QUESTIONNAIRE!D483","v":0},{"$f":"+QUESTIONNAIRE!E483","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I483,FALSE)","v":"YES"},null,null,471,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A484","v":0},{"$f":"+QUESTIONNAIRE!B484","v":0},{"$f":"+QUESTIONNAIRE!C484","v":0},{"$f":"+QUESTIONNAIRE!D484","v":0},{"$f":"+QUESTIONNAIRE!E484","v":0},null,null,null,472]
[{"$f":"+QUESTIONNAIRE!A485","v":0},{"$f":"+QUESTIONNAIRE!B485","v":"→"},{"$f":"+QUESTIONNAIRE!C485","v":"Are the proposed contractual arrangements and procurement procedures likely to produce a strong competitive response from prospective bidders?"},{"$f":"+QUESTIONNAIRE!D485","v":0},{"$f":"+QUESTIONNAIRE!E485","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I485,FALSE)","v":"YES"},null,null,473,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A486","v":0},{"$f":"+QUESTIONNAIRE!B486","v":0},{"$f":"+QUESTIONNAIRE!C486","v":0},{"$f":"+QUESTIONNAIRE!D486","v":0},{"$f":"+QUESTIONNAIRE!E486","v":0},null,null,null,474]
[{"$f":"+QUESTIONNAIRE!A487","v":0},{"$f":"+QUESTIONNAIRE!B487","v":"→"},{"$f":"+QUESTIONNAIRE!C487","v":"Is there continued stakeholder support for the proejct ad for the PPP delivery approach?"},{"$f":"+QUESTIONNAIRE!D487","v":0},{"$f":"+QUESTIONNAIRE!E487","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I487,FALSE)","v":"YES"},null,null,475,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A488","v":0},{"$f":"+QUESTIONNAIRE!B488","v":0},{"$f":"+QUESTIONNAIRE!C488","v":0},{"$f":"+QUESTIONNAIRE!D488","v":0},{"$f":"+QUESTIONNAIRE!E488","v":0},null,null,null,476]
[{"$f":"+QUESTIONNAIRE!A489","v":0},{"$f":"+QUESTIONNAIRE!B489","v":"→"},{"$f":"+QUESTIONNAIRE!C489","v":"Is the contracting authority ready and prepared to manage the procurement phase and has it obtained the relevant project consents, approvals and authorisations?"},{"$f":"+QUESTIONNAIRE!D489","v":0},{"$f":"+QUESTIONNAIRE!E489","v":0},{"$f":"+HLOOKUP($D$6,$J$13:$Q$491,I489,FALSE)","v":"YES"},null,null,477,"--Please Select--","YES","YES"]
[{"$f":"+QUESTIONNAIRE!A490","v":0},{"$f":"+QUESTIONNAIRE!B490","v":0},{"$f":"+QUESTIONNAIRE!C490","v":0},{"$f":"+QUESTIONNAIRE!D490","v":0},{"$f":"+QUESTIONNAIRE!E490","v":0},{"$f":"+QUESTIONNAIRE!F490","v":0},null,null,478,null,0]
[{"$f":"+QUESTIONNAIRE!A491","v":0},{"$f":"+QUESTIONNAIRE!B491","v":0},{"$f":"+QUESTIONNAIRE!C491","v":0},{"$f":"+QUESTIONNAIRE!D491","v":0},{"$f":"+QUESTIONNAIRE!E491","v":0},{"$f":"+QUESTIONNAIRE!F491","v":0},null,null,479]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Lists","index":6,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"PROCUREMENT TOOLS"]
["PROCUREMENTMETHOD","Procurement Method"]
[null,"Open Procurement"]
[null,"Restricted Procurement"]
[null,"Negotiated Procedure"]
[null,"Competitive Dialogue"]
[]
[]
[null,"Maturity Questions"]
["YESNO","Yes / NO",null,"YES/NO"]
[null,"--Please Select--",null,"YES"]
[null,"YES"]
[null,"NO",null,"NO"]
[]
[]
["WhereIsTheProject","WhereIsTheProject"]
[null,"Identifying and selecting the project investment",1]
[null,"The project has been selected to be implemented",2]
[null,"Assessing the PPP option",3]
[null,"Preparing the PPP project for procurement",4]
[null,"The project is ready to got ot the market",5]
[]
[]
[null,"Identifying and selecting the project investment"]
[null,"Assessing the PPP option"]
[null,"Preparing the PPP project for procurement"]
[null,"Running the procurement process"]
[null,"Reaching contract signature and financial close"]