{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Tool","Summary","Handout"],"not_rendered":{"charts":3,"images":1,"external_links":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Tool","index":0,"n_rows":215,"n_cols":24,"rows_kept":215,"merged":[[3,8,3,9],[3,12,3,13],[3,16,3,17],[5,4,5,5]]}
[null,{"$f":"[0]!Title_Model","v":"RAE: ALLOWED REVENUE MODEL"}]
[null,{"$f":"Title_Project","v":{"$error":"#REF!"}}]
[]
[{"$nulls":7},{"$f":"IF(H11<>\"\",H10&\": \"&H11,\"\")","v":"1: Project A"},{"$f":"J164","v":""},null,null,{"$f":"IF(L11<>\"\",L10&\": \"&L11,\"\")","v":"2: Project B"},{"$f":"N164","v":""},null,null,{"$f":"IF(P11<>\"\",P10&\": \"&P11,\"\")","v":"3: Project C"},{"$f":"R164","v":""},null,null,"Annex: Answer options"]
[]
[null,null,"Question",null,"Overall importance {weight}",null,null,"Answer","Score \n(1-5)","Weighted score",null,"Answer","Score \n(1-5)","Weighted score",null,"Answer","Score \n(1-5)","Weighted score",null,1,2,3,4,5]
[]
[null,null,"Project details"]
[]
[null,null,"No.",{"$nulls":4},{"$f":"IF(H11<>\"\",MAX(G10:$G10)+1,\"\")","v":1},{"$nulls":3},{"$f":"IF(L11<>\"\",MAX($G10:K10)+1,\"\")","v":2},{"$nulls":3},{"$f":"IF(P11<>\"\",MAX($G10:O10)+1,\"\")","v":3}]
[null,null,"Title",{"$nulls":4},"Project A",{"$nulls":3},"Project B",{"$nulls":3},"Project C"]
[null,null,"Description",{"$nulls":4},"Sector etc."]
[]
[null,"A","How supportive is the PPP environment?"]
[]
[null,"I","Public sector capacity and experience"]
[]
[null,{"$f":"IF(C18<>\"\",MAX(B$14:B17)+1,\"\")","v":1},"Does the sponsoring entity have the capabilities to procure PPPs?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E18,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H18,$T18:$X18,0))","v":{"$error":"#N/A"}},{"$f":"I18*INDEX($F$202:$F$205,MATCH($E18,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L18,$T18:$X18,0))","v":{"$error":"#N/A"}},{"$f":"M18*INDEX($F$202:$F$205,MATCH($E18,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P18,$T18:$X18,0))","v":{"$error":"#N/A"}},{"$f":"Q18*INDEX($F$202:$F$205,MATCH($E18,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No capabilities","Very little capability","Some capabilities","Good capability","Full set of capabilities"]
[]
[null,{"$f":"IF(C20<>\"\",MAX(B$14:B19)+1,\"\")","v":2},"Does the sponsoring entity have the capabilities to manage and monitor a PPP contract?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E20,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H20,$T20:$X20,0))","v":{"$error":"#N/A"}},{"$f":"I20*INDEX($F$202:$F$205,MATCH($E20,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L20,$T20:$X20,0))","v":{"$error":"#N/A"}},{"$f":"M20*INDEX($F$202:$F$205,MATCH($E20,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P20,$T20:$X20,0))","v":{"$error":"#N/A"}},{"$f":"Q20*INDEX($F$202:$F$205,MATCH($E20,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No capabilities","Very little capability","Some capabilities","Good capability","Full set of capabilities"]
[]
[null,{"$f":"IF(C22<>\"\",MAX(B$14:B21)+1,\"\")","v":3},"Does the sponsoring entity have previous experience with PPPs?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E22,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H22,$T22:$X22,0))","v":{"$error":"#N/A"}},{"$f":"I22*INDEX($F$202:$F$205,MATCH($E22,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L22,$T22:$X22,0))","v":{"$error":"#N/A"}},{"$f":"M22*INDEX($F$202:$F$205,MATCH($E22,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P22,$T22:$X22,0))","v":{"$error":"#N/A"}},{"$f":"Q22*INDEX($F$202:$F$205,MATCH($E22,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No previous PPP experience","Some experience with dissimilar PPPs","Limited experience (1 project), for a similar PPP","Significant experience (2-4 projects), including similar PPPs","Extensive experience (5+ projects), including similar PPPs"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F17:F23)*$X$6","v":{"v":11.25,"d":"11.25)"}},{"$nulls":3},{"$f":"SUM(J17:J23)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N17:N23)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R17:R23)","v":{"$error":"#N/A"}}]
[]
[null,"II","Public sector funding"]
[]
[null,{"$f":"IF(C28<>\"\",MAX(B$14:B27)+1,\"\")","v":4},"Is funding assistance available for project preparation?",null,"Low",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E28,$C$202:$C$205,0),1),0)","v":{"v":0.25,"d":"{25%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H28,$T28:$X28,0))","v":{"$error":"#N/A"}},{"$f":"I28*INDEX($F$202:$F$205,MATCH($E28,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L28,$T28:$X28,0))","v":{"$error":"#N/A"}},{"$f":"M28*INDEX($F$202:$F$205,MATCH($E28,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P28,$T28:$X28,0))","v":{"$error":"#N/A"}},{"$f":"Q28*INDEX($F$202:$F$205,MATCH($E28,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Not at all","Unlikely","Possible","Likely","Guaranteed"]
[]
[null,{"$f":"IF(C30<>\"\",MAX(B$14:B29)+1,\"\")","v":5},"Is viability gap funding available for the PPP project?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E30,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H30,$T30:$X30,0))","v":{"$error":"#N/A"}},{"$f":"I30*INDEX($F$202:$F$205,MATCH($E30,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L30,$T30:$X30,0))","v":{"$error":"#N/A"}},{"$f":"M30*INDEX($F$202:$F$205,MATCH($E30,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P30,$T30:$X30,0))","v":{"$error":"#N/A"}},{"$f":"Q30*INDEX($F$202:$F$205,MATCH($E30,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Not at all","Unlikely","Possible","Likely","Guaranteed"]
[]
[null,{"$f":"IF(C32<>\"\",MAX(B$14:B31)+1,\"\")","v":6},"Is the PPP project eligible for significant funding from other sources?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E32,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H32,$T32:$X32,0))","v":{"$error":"#N/A"}},{"$f":"I32*INDEX($F$202:$F$205,MATCH($E32,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L32,$T32:$X32,0))","v":{"$error":"#N/A"}},{"$f":"M32*INDEX($F$202:$F$205,MATCH($E32,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P32,$T32:$X32,0))","v":{"$error":"#N/A"}},{"$f":"Q32*INDEX($F$202:$F$205,MATCH($E32,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Not at all","Unlikely","Possible","Likely","Guaranteed"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F27:F33)*$X$6","v":{"v":7.5,"d":"7.50)"}},{"$nulls":3},{"$f":"SUM(J27:J33)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N27:N33)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R27:R33)","v":{"$error":"#N/A"}}]
[]
[null,"III","Private sector capability and appetite"]
[]
[null,{"$f":"IF(C38<>\"\",MAX(B$14:B37)+1,\"\")","v":7},"Are multiple firms active in the project sector and likely to be interested?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E38,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H38,$T38:$X38,0))","v":{"$error":"#N/A"}},{"$f":"I38*INDEX($F$202:$F$205,MATCH($E38,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L38,$T38:$X38,0))","v":{"$error":"#N/A"}},{"$f":"M38*INDEX($F$202:$F$205,MATCH($E38,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P38,$T38:$X38,0))","v":{"$error":"#N/A"}},{"$f":"Q38*INDEX($F$202:$F$205,MATCH($E38,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No interest expected","Extent of interest among qualified firms is not yet known","Some interest expected","5+ qualified firms are expected to be interested","5+ qualified firms have competed for similar opportunities"]
[]
[null,{"$f":"IF(C40<>\"\",MAX(B$14:B39)+1,\"\")","v":8},"Have similar PPP projects been successfully financed in Afghanistan?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E40,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H40,$T40:$X40,0))","v":{"$error":"#N/A"}},{"$f":"I40*INDEX($F$202:$F$205,MATCH($E40,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L40,$T40:$X40,0))","v":{"$error":"#N/A"}},{"$f":"M40*INDEX($F$202:$F$205,MATCH($E40,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P40,$T40:$X40,0))","v":{"$error":"#N/A"}},{"$f":"Q40*INDEX($F$202:$F$205,MATCH($E40,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No PPP projects recently financed","No similar PPP projects recently financed","Dissimilar PPP projects financed in last 2 years","At least one similar PPP project successfully financed in last 2 years","Multiple similar PPP projects successfully financed in last 2 years"]
[]
[null,{"$f":"IF(C42<>\"\",MAX(B$14:B41)+1,\"\")","v":9},"Have similar PPP projects been successfully financed in countries similar to Afghanistan?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E42,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H42,$T42:$X42,0))","v":{"$error":"#N/A"}},{"$f":"I42*INDEX($F$202:$F$205,MATCH($E42,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L42,$T42:$X42,0))","v":{"$error":"#N/A"}},{"$f":"M42*INDEX($F$202:$F$205,MATCH($E42,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P42,$T42:$X42,0))","v":{"$error":"#N/A"}},{"$f":"Q42*INDEX($F$202:$F$205,MATCH($E42,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No PPP projects recently financed","No similar PPP projects recently financed","Somewhat similar PPP projects financed in last 2 years","At least one very similar PPP project successfully financed in last 2 years","Multiple very similar PPP projects successfully financed in last 2 years"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F37:F43)*$X$6","v":{"v":13.75,"d":"13.75)"}},{"$nulls":3},{"$f":"SUM(J37:J43)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N37:N43)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R37:R43)","v":{"$error":"#N/A"}}]
[]
[null,"B","How suitable is the project for PPP?"]
[]
[null,"IV","Key project characteristics"]
[]
[null,{"$f":"IF(C50<>\"\",MAX(B$14:B49)+1,\"\")","v":10},"What is the project value?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E50,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H50,$T50:$X50,0))","v":{"$error":"#N/A"}},{"$f":"I50*INDEX($F$202:$F$205,MATCH($E50,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L50,$T50:$X50,0))","v":{"$error":"#N/A"}},{"$f":"M50*INDEX($F$202:$F$205,MATCH($E50,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P50,$T50:$X50,0))","v":{"$error":"#N/A"}},{"$f":"Q50*INDEX($F$202:$F$205,MATCH($E50,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Project is less than USD 5m","Project is between USD 5m and 20m","Project is between USD 20m and 100m","Project is between USD 100m and 300m","Project is greater than USD 300m"]
[]
[null,{"$f":"IF(C52<>\"\",MAX(B$14:B51)+1,\"\")","v":11},"What is the expected project duration (including construction)?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E52,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H52,$T52:$X52,0))","v":{"$error":"#N/A"}},{"$f":"I52*INDEX($F$202:$F$205,MATCH($E52,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L52,$T52:$X52,0))","v":{"$error":"#N/A"}},{"$f":"M52*INDEX($F$202:$F$205,MATCH($E52,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P52,$T52:$X52,0))","v":{"$error":"#N/A"}},{"$f":"Q52*INDEX($F$202:$F$205,MATCH($E52,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Less than five years","5 to 10 years","10 to 15 years","15 to 20 years","> 20 years"]
[]
[null,{"$f":"IF(C54<>\"\",MAX(B$14:B53)+1,\"\")","v":12},"Are outputs easily definable, measurable and verifiable?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E54,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H54,$T54:$X54,0))","v":{"$error":"#N/A"}},{"$f":"I54*INDEX($F$202:$F$205,MATCH($E54,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L54,$T54:$X54,0))","v":{"$error":"#N/A"}},{"$f":"M54*INDEX($F$202:$F$205,MATCH($E54,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P54,$T54:$X54,0))","v":{"$error":"#N/A"}},{"$f":"Q54*INDEX($F$202:$F$205,MATCH($E54,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No ability to define, measure or verify outputs","Multiple outputs, difficult to define and/or measure and/or verify","Few outputs, difficult to define and/or measure and/or verify","Multiple outputs, each easily definable, measureable and verifiable","Few outputs, each easily definable, measureable and verifiable"]
[]
[null,{"$f":"IF(C56<>\"\",MAX(B$14:B55)+1,\"\")","v":13},"How complex is the project?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E56,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H56,$T56:$X56,0))","v":{"$error":"#N/A"}},{"$f":"I56*INDEX($F$202:$F$205,MATCH($E56,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L56,$T56:$X56,0))","v":{"$error":"#N/A"}},{"$f":"M56*INDEX($F$202:$F$205,MATCH($E56,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P56,$T56:$X56,0))","v":{"$error":"#N/A"}},{"$f":"Q56*INDEX($F$202:$F$205,MATCH($E56,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Very complex","Challenging","Middle","Fairly simple","Straight forward"]
[]
[null,{"$f":"IF(C58<>\"\",MAX(B$14:B57)+1,\"\")","v":14},"Are operational (non-construction) costs are a large part of the total costs of the project?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E58,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H58,$T58:$X58,0))","v":{"$error":"#N/A"}},{"$f":"I58*INDEX($F$202:$F$205,MATCH($E58,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L58,$T58:$X58,0))","v":{"$error":"#N/A"}},{"$f":"M58*INDEX($F$202:$F$205,MATCH($E58,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P58,$T58:$X58,0))","v":{"$error":"#N/A"}},{"$f":"Q58*INDEX($F$202:$F$205,MATCH($E58,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Operational costs are almost non-existent relative to construction costs","Operational costs are significantly lower than construction costs","Operational costs are similar to construction costs","Operational costs are higher than construction costs","Operational costs greatly exceed construction costs"]
[]
[null,{"$f":"IF(C60<>\"\",MAX(B$14:B59)+1,\"\")","v":15},"Are there fixed time constraints on project award?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E60,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H60,$T60:$X60,0))","v":{"$error":"#N/A"}},{"$f":"I60*INDEX($F$202:$F$205,MATCH($E60,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L60,$T60:$X60,0))","v":{"$error":"#N/A"}},{"$f":"M60*INDEX($F$202:$F$205,MATCH($E60,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P60,$T60:$X60,0))","v":{"$error":"#N/A"}},{"$f":"Q60*INDEX($F$202:$F$205,MATCH($E60,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Project must be awarded within 6 months","Project must be awarded with 1 year","Project must be awarded within 2 years","Project must be awarded within 3 years","No time constraints"]
[]
[null,{"$f":"IF(C62<>\"\",MAX(B$14:B61)+1,\"\")","v":16},"How secure is the project location?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E62,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H62,$T62:$X62,0))","v":{"$error":"#N/A"}},{"$f":"I62*INDEX($F$202:$F$205,MATCH($E62,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L62,$T62:$X62,0))","v":{"$error":"#N/A"}},{"$f":"M62*INDEX($F$202:$F$205,MATCH($E62,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P62,$T62:$X62,0))","v":{"$error":"#N/A"}},{"$f":"Q62*INDEX($F$202:$F$205,MATCH($E62,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Extreme security issues","Serious security issues likely","Some security issues likely","Low risk of security issues","No known security issues"]
[]
[null,{"$f":"IF(C64<>\"\",MAX(B$14:B63)+1,\"\")","v":17},"Are staff and/or resources to be sourced locally or abroad?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E64,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H64,$T64:$X64,0))","v":{"$error":"#N/A"}},{"$f":"I64*INDEX($F$202:$F$205,MATCH($E64,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L64,$T64:$X64,0))","v":{"$error":"#N/A"}},{"$f":"M64*INDEX($F$202:$F$205,MATCH($E64,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P64,$T64:$X64,0))","v":{"$error":"#N/A"}},{"$f":"Q64*INDEX($F$202:$F$205,MATCH($E64,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"All foreign resources with prior capacity building required","Local resources with prior capacity building required","Foreign staff ready with local leadership","Local staff ready with foreign leadership","All local experts ready to go"]
[]
[null,{"$f":"IF(C66<>\"\",MAX(B$14:B65)+1,\"\")","v":18},"Does the project require the development of new/advanced technology?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E66,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H66,$T66:$X66,0))","v":{"$error":"#N/A"}},{"$f":"I66*INDEX($F$202:$F$205,MATCH($E66,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L66,$T66:$X66,0))","v":{"$error":"#N/A"}},{"$f":"M66*INDEX($F$202:$F$205,MATCH($E66,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P66,$T66:$X66,0))","v":{"$error":"#N/A"}},{"$f":"Q66*INDEX($F$202:$F$205,MATCH($E66,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Requires the development of new technologies","Requires advanced technology","Some advanced technology required","Low amounts of easily implemented advanced technology required","No new/advanced technology required"]
[]
[null,{"$f":"IF(C68<>\"\",MAX(B$14:B67)+1,\"\")","v":19},"Is the project reliant on other projects yet to be constructed?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E68,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H68,$T68:$X68,0))","v":{"$error":"#N/A"}},{"$f":"I68*INDEX($F$202:$F$205,MATCH($E68,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L68,$T68:$X68,0))","v":{"$error":"#N/A"}},{"$f":"M68*INDEX($F$202:$F$205,MATCH($E68,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P68,$T68:$X68,0))","v":{"$error":"#N/A"}},{"$f":"Q68*INDEX($F$202:$F$205,MATCH($E68,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Very reliant on projects that are likely to cause delays ","Reliant on projects that are due to be completed around the time of this PPP","Reliant on projects that are likely to be completed well ahead of this PPP","Minimal reliance on other projects","Not at all reliant"]
[]
[null,{"$f":"IF(C70<>\"\",MAX(B$14:B69)+1,\"\")","v":20},"Does operation of the project rely heavily on a single supplier of goods or services?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E70,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H70,$T70:$X70,0))","v":{"$error":"#N/A"}},{"$f":"I70*INDEX($F$202:$F$205,MATCH($E70,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L70,$T70:$X70,0))","v":{"$error":"#N/A"}},{"$f":"M70*INDEX($F$202:$F$205,MATCH($E70,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P70,$T70:$X70,0))","v":{"$error":"#N/A"}},{"$f":"Q70*INDEX($F$202:$F$205,MATCH($E70,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"It is not clear where the supply is coming from","Yes, without a long-term supply contract","Long term supply contract, with either non-investment grade company or SOE without government guarantee","Long term supply contract, with either investment grade company or SOE with government guarantee","Not heavily reliant"]
[]
[null,{"$f":"IF(C72<>\"\",MAX(B$14:B71)+1,\"\")","v":21},"Would the physical infrastructure pass through multiple jurisdictions?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E72,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H72,$T72:$X72,0))","v":{"$error":"#N/A"}},{"$f":"I72*INDEX($F$202:$F$205,MATCH($E72,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L72,$T72:$X72,0))","v":{"$error":"#N/A"}},{"$f":"M72*INDEX($F$202:$F$205,MATCH($E72,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P72,$T72:$X72,0))","v":{"$error":"#N/A"}},{"$f":"Q72*INDEX($F$202:$F$205,MATCH($E72,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Project in multiple jurisdictions with NO experience of shared PPPs","Project in multiple jurisdictions with limited experience of shared PPPs","Project in multiple jurisdictions with previous experience of shared PPPs","Project in two jurisdictions","Project fully contained within one jurisdiction "]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F49:F73)*$X$6","v":{"v":41.25,"d":"41.25)"}},{"$nulls":3},{"$f":"SUM(J49:J73)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N49:N73)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R49:R73)","v":{"$error":"#N/A"}}]
[]
[null,"V","Fit with development priorities"]
[]
[null,{"$f":"IF(C78<>\"\",MAX(B$14:B77)+1,\"\")","v":22},"Does the project fit into national development priorities?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E78,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H78,$T78:$X78,0))","v":{"$error":"#N/A"}},{"$f":"I78*INDEX($F$202:$F$205,MATCH($E78,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L78,$T78:$X78,0))","v":{"$error":"#N/A"}},{"$f":"M78*INDEX($F$202:$F$205,MATCH($E78,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P78,$T78:$X78,0))","v":{"$error":"#N/A"}},{"$f":"Q78*INDEX($F$202:$F$205,MATCH($E78,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Not at all","Low","Medium","High","Top"]
[]
[null,{"$f":"IF(C80<>\"\",MAX(B$14:B79)+1,\"\")","v":23},"Is the project part of a sector plan?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E80,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H80,$T80:$X80,0))","v":{"$error":"#N/A"}},{"$f":"I80*INDEX($F$202:$F$205,MATCH($E80,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L80,$T80:$X80,0))","v":{"$error":"#N/A"}},{"$f":"M80*INDEX($F$202:$F$205,MATCH($E80,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P80,$T80:$X80,0))","v":{"$error":"#N/A"}},{"$f":"Q80*INDEX($F$202:$F$205,MATCH($E80,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Conflicts with sector plan","Ad hoc project- but not in conflict with sector plan","Ad hoc project- but in line with sector plan","Part of sector plan","Forms integral part of sector plan"]
[]
[null,{"$f":"IF(C82<>\"\",MAX(B$14:B81)+1,\"\")","v":24},"Is the development of this project a prerequisite to other potential projects?",null,"Low",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E82,$C$202:$C$205,0),1),0)","v":{"v":0.25,"d":"{25%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H82,$T82:$X82,0))","v":{"$error":"#N/A"}},{"$f":"I82*INDEX($F$202:$F$205,MATCH($E82,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L82,$T82:$X82,0))","v":{"$error":"#N/A"}},{"$f":"M82*INDEX($F$202:$F$205,MATCH($E82,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P82,$T82:$X82,0))","v":{"$error":"#N/A"}},{"$f":"Q82*INDEX($F$202:$F$205,MATCH($E82,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Prevents the development of further projects","Detrimental to the feasibility of other projects","Does not affect the feasibility of other projects","Important to development","Yes-central to development"]
[]
[null,{"$f":"IF(C84<>\"\",MAX(B$14:B83)+1,\"\")","v":25},"What is the potential impact on export earnings",null,"Low",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E84,$C$202:$C$205,0),1),0)","v":{"v":0.25,"d":"{25%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H84,$T84:$X84,0))","v":{"$error":"#N/A"}},{"$f":"I84*INDEX($F$202:$F$205,MATCH($E84,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L84,$T84:$X84,0))","v":{"$error":"#N/A"}},{"$f":"M84*INDEX($F$202:$F$205,MATCH($E84,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P84,$T84:$X84,0))","v":{"$error":"#N/A"}},{"$f":"Q84*INDEX($F$202:$F$205,MATCH($E84,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Major negative overseas trade and/or tourism impact","Limited negative overseas trade and/or tourism impact","No positive or negative overseas trade and/or tourism impact","Limited positive overseas trade and/or tourism impact","Major positive overseas trade and/or tourism impact"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F77:F85)*$X$6","v":{"v":8.75,"d":"8.75)"}},{"$nulls":3},{"$f":"SUM(J77:J85)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N77:N85)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R77:R85)","v":{"$error":"#N/A"}}]
[]
[null,"VI","Land acquisition"]
[]
[null,{"$f":"IF(C90<>\"\",MAX(B$14:B89)+1,\"\")","v":26},"Will the PPP require land acquisition?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E90,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H90,$T90:$X90,0))","v":{"$error":"#N/A"}},{"$f":"I90*INDEX($F$202:$F$205,MATCH($E90,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L90,$T90:$X90,0))","v":{"$error":"#N/A"}},{"$f":"M90*INDEX($F$202:$F$205,MATCH($E90,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P90,$T90:$X90,0))","v":{"$error":"#N/A"}},{"$f":"Q90*INDEX($F$202:$F$205,MATCH($E90,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Major land acquisition","Significant land acquisition","Some land acquisition","Minor land acquisition","No land acquisition"]
[]
[null,{"$f":"IF(C92<>\"\",MAX(B$14:B91)+1,\"\")","v":27},"If land acquisition is required, will the public sector do this?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E92,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H92,$T92:$X92,0))","v":{"$error":"#N/A"}},{"$f":"I92*INDEX($F$202:$F$205,MATCH($E92,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L92,$T92:$X92,0))","v":{"$error":"#N/A"}},{"$f":"M92*INDEX($F$202:$F$205,MATCH($E92,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P92,$T92:$X92,0))","v":{"$error":"#N/A"}},{"$f":"Q92*INDEX($F$202:$F$205,MATCH($E92,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Public sector will not acquire land","Public sector will acquire some land before construction start","Public sector will acquire land before construction start","Public sector will acquire land before project tendered","No land acquisition"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F89:F93)*$X$6","v":{"v":10,"d":"10.00)"}},{"$nulls":3},{"$f":"SUM(J89:J93)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N89:N93)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R89:R93)","v":{"$error":"#N/A"}}]
[]
[null,"VII","Environmental and social impacts"]
[]
[null,{"$f":"IF(C98<>\"\",MAX(B$14:B97)+1,\"\")","v":28},"Will the PPP have significant negative environmental impacts?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E98,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H98,$T98:$X98,0))","v":{"$error":"#N/A"}},{"$f":"I98*INDEX($F$202:$F$205,MATCH($E98,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L98,$T98:$X98,0))","v":{"$error":"#N/A"}},{"$f":"M98*INDEX($F$202:$F$205,MATCH($E98,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P98,$T98:$X98,0))","v":{"$error":"#N/A"}},{"$f":"Q98*INDEX($F$202:$F$205,MATCH($E98,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Major negative impacts","Significant negative impacts","Some negative impacts","Minimal negative impacts","No negative impacts"]
[]
[null,{"$f":"IF(C100<>\"\",MAX(B$14:B99)+1,\"\")","v":29},"Will the PPP have significant negative social impacts, including resettlement of houses, businesses etc.",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E100,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H100,$T100:$X100,0))","v":{"$error":"#N/A"}},{"$f":"I100*INDEX($F$202:$F$205,MATCH($E100,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L100,$T100:$X100,0))","v":{"$error":"#N/A"}},{"$f":"M100*INDEX($F$202:$F$205,MATCH($E100,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P100,$T100:$X100,0))","v":{"$error":"#N/A"}},{"$f":"Q100*INDEX($F$202:$F$205,MATCH($E100,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Major negative impacts","Significant negative impacts","Some negative impacts","Minimal negative impacts","No negative impacts"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F97:F101)*$X$6","v":{"v":10,"d":"10.00)"}},{"$nulls":3},{"$f":"SUM(J97:J101)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N97:N101)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R97:R101)","v":{"$error":"#N/A"}}]
[]
[null,"VIII","Labour and employment"]
[]
[null,{"$f":"IF(C106<>\"\",MAX(B$14:B105)+1,\"\")","v":30},"Will a significant transfer of employees take place under the PPP?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E106,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H106,$T106:$X106,0))","v":{"$error":"#N/A"}},{"$f":"I106*INDEX($F$202:$F$205,MATCH($E106,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L106,$T106:$X106,0))","v":{"$error":"#N/A"}},{"$f":"M106*INDEX($F$202:$F$205,MATCH($E106,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P106,$T106:$X106,0))","v":{"$error":"#N/A"}},{"$f":"Q106*INDEX($F$202:$F$205,MATCH($E106,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Very large numbers (>25%) transferred","Large numbers (15-25%) transferred","Significant numbers (5-15%) transferred","Moderate numbers (2-5%) transferred","Insignificant numbers (<2%) transferred"]
[]
[null,{"$f":"IF(C108<>\"\",MAX(B$14:B107)+1,\"\")","v":31},"Have there been successful transfers under previous PPPs?",null,"Low",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E108,$C$202:$C$205,0),1),0)","v":{"v":0.25,"d":"{25%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H108,$T108:$X108,0))","v":{"$error":"#N/A"}},{"$f":"I108*INDEX($F$202:$F$205,MATCH($E108,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L108,$T108:$X108,0))","v":{"$error":"#N/A"}},{"$f":"M108*INDEX($F$202:$F$205,MATCH($E108,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P108,$T108:$X108,0))","v":{"$error":"#N/A"}},{"$f":"Q108*INDEX($F$202:$F$205,MATCH($E108,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No previous transfers","Most past transfers have been unsuccessful","Past transfers have had mixed results","Most past transfers have been successful","No significant transfers required OR successful past transfers completed"]
[]
[null,{"$f":"IF(C110<>\"\",MAX(B$14:B109)+1,\"\")","v":32},"Is the project likely to result in job losses or create new jobs?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E110,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H110,$T110:$X110,0))","v":{"$error":"#N/A"}},{"$f":"I110*INDEX($F$202:$F$205,MATCH($E110,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L110,$T110:$X110,0))","v":{"$error":"#N/A"}},{"$f":"M110*INDEX($F$202:$F$205,MATCH($E110,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P110,$T110:$X110,0))","v":{"$error":"#N/A"}},{"$f":"Q110*INDEX($F$202:$F$205,MATCH($E110,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Significant job losses likely (>10% of existing workforce)","Some job losses likely (<10% of existing workforce)","No job losses are expected","The project is expected to create a few new jobs","The project is expected to create many new jobs"]
[]
[null,{"$f":"IF(C112<>\"\",MAX(B$14:B111)+1,\"\")","v":33},"What proportion of the project works, goods, and services will be acquired locally?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E112,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H112,$T112:$X112,0))","v":{"$error":"#N/A"}},{"$f":"I112*INDEX($F$202:$F$205,MATCH($E112,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L112,$T112:$X112,0))","v":{"$error":"#N/A"}},{"$f":"M112*INDEX($F$202:$F$205,MATCH($E112,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P112,$T112:$X112,0))","v":{"$error":"#N/A"}},{"$f":"Q112*INDEX($F$202:$F$205,MATCH($E112,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Insignificant proportion (< 10%)","Moderate proportion (10 - 30%)","Significant proportion (30 - 50%)","Large proportion (50 - 80%)","Very large proportion (> 80%)"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F105:F113)*$X$6","v":{"v":8.75,"d":"8.75)"}},{"$nulls":3},{"$f":"SUM(J105:J113)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N105:N113)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R105:R113)","v":{"$error":"#N/A"}}]
[]
[null,"IX","Demand and payment risk"]
[]
[null,{"$f":"IF(C118<>\"\",MAX(B$14:B117)+1,\"\")","v":34},"What is the main revenue source for the project?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E118,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H118,$T118:$X118,0))","v":{"$error":"#N/A"}},{"$f":"I118*INDEX($F$202:$F$205,MATCH($E118,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L118,$T118:$X118,0))","v":{"$error":"#N/A"}},{"$f":"M118*INDEX($F$202:$F$205,MATCH($E118,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P118,$T118:$X118,0))","v":{"$error":"#N/A"}},{"$f":"Q118*INDEX($F$202:$F$205,MATCH($E118,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"As yet unknown","Other","Charges (user pays)","Shadow charges (government pays)","Annuity payments"]
[]
[null,{"$f":"IF(C120<>\"\",MAX(B$14:B119)+1,\"\")","v":35},"How much demand risk is there?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E120,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H120,$T120:$X120,0))","v":{"$error":"#N/A"}},{"$f":"I120*INDEX($F$202:$F$205,MATCH($E120,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L120,$T120:$X120,0))","v":{"$error":"#N/A"}},{"$f":"M120*INDEX($F$202:$F$205,MATCH($E120,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P120,$T120:$X120,0))","v":{"$error":"#N/A"}},{"$f":"Q120*INDEX($F$202:$F$205,MATCH($E120,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Very high demand risk","High demand risk","Moderate demand risk","Low demand risk","No demand risk"]
[]
[null,{"$f":"IF(C122<>\"\",MAX(B$14:B121)+1,\"\")","v":36},"How are user charges (or shadow charges) set?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E122,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H122,$T122:$X122,0))","v":{"$error":"#N/A"}},{"$f":"I122*INDEX($F$202:$F$205,MATCH($E122,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L122,$T122:$X122,0))","v":{"$error":"#N/A"}},{"$f":"M122*INDEX($F$202:$F$205,MATCH($E122,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P122,$T122:$X122,0))","v":{"$error":"#N/A"}},{"$f":"Q122*INDEX($F$202:$F$205,MATCH($E122,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Set by ministry / public enterprise using discretion","Set by independent regulator using discretion","Set by ministry / public enterprise using formula in contract","Set by independent regulator using formula in contract","Fixed for contract life OR no user charges payable"]
[]
[null,{"$f":"IF(C124<>\"\",MAX(B$14:B123)+1,\"\")","v":37},"Are the entity's subsidies / annuity payments guaranteed by central government?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E124,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H124,$T124:$X124,0))","v":{"$error":"#N/A"}},{"$f":"I124*INDEX($F$202:$F$205,MATCH($E124,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L124,$T124:$X124,0))","v":{"$error":"#N/A"}},{"$f":"M124*INDEX($F$202:$F$205,MATCH($E124,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P124,$T124:$X124,0))","v":{"$error":"#N/A"}},{"$f":"Q124*INDEX($F$202:$F$205,MATCH($E124,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No guarantee, very poor track record of paying subsidies / annuities","No guarantee, unreliable track record of paying subsidies / annuities","No guarantee, no previous requirement to pay subsidies / annuities","No guarantee, good track record of paying subsidies / annuities","No subsidies/annuities payable OR payment backed by a central government guarantee"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F117:F125)*$X$6","v":{"v":15,"d":"15.00)"}},{"$nulls":3},{"$f":"SUM(J117:J125)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N117:N125)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R117:R125)","v":{"$error":"#N/A"}}]
[]
[null,"X","Commercial viability"]
[]
[null,{"$f":"IF(C130<>\"\",MAX(B$14:B129)+1,\"\")","v":38},"Is the financial viability of the project dependent on receiving a grant/subsidy?",null,"Very high",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E130,$C$202:$C$205,0),1),0)","v":{"v":1,"d":"{100%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H130,$T130:$X130,0))","v":{"$error":"#N/A"}},{"$f":"I130*INDEX($F$202:$F$205,MATCH($E130,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L130,$T130:$X130,0))","v":{"$error":"#N/A"}},{"$f":"M130*INDEX($F$202:$F$205,MATCH($E130,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P130,$T130:$X130,0))","v":{"$error":"#N/A"}},{"$f":"Q130*INDEX($F$202:$F$205,MATCH($E130,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Completely","Likely","Somewhat","Unlikely","Not at all"]
[]
[null,{"$f":"IF(C132<>\"\",MAX(B$14:B131)+1,\"\")","v":39},"How soon after the start of the project are positive cash flows expected to start",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E132,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H132,$T132:$X132,0))","v":{"$error":"#N/A"}},{"$f":"I132*INDEX($F$202:$F$205,MATCH($E132,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L132,$T132:$X132,0))","v":{"$error":"#N/A"}},{"$f":"M132*INDEX($F$202:$F$205,MATCH($E132,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P132,$T132:$X132,0))","v":{"$error":"#N/A"}},{"$f":"Q132*INDEX($F$202:$F$205,MATCH($E132,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"5 Years +","3-5 Years","2-3 Years","1-2 Years","<1 Year"]
[]
[null,{"$f":"IF(C134<>\"\",MAX(B$14:B133)+1,\"\")","v":40},"What overall level of risk is assumed by the private sector?",null,"High",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E134,$C$202:$C$205,0),1),0)","v":{"v":0.75,"d":"{75%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H134,$T134:$X134,0))","v":{"$error":"#N/A"}},{"$f":"I134*INDEX($F$202:$F$205,MATCH($E134,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L134,$T134:$X134,0))","v":{"$error":"#N/A"}},{"$f":"M134*INDEX($F$202:$F$205,MATCH($E134,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P134,$T134:$X134,0))","v":{"$error":"#N/A"}},{"$f":"Q134*INDEX($F$202:$F$205,MATCH($E134,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"High","Moderate to high","Moderate","Minimal to moderate","Minimal"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F129:F135)*$X$6","v":{"v":11.25,"d":"11.25)"}},{"$nulls":3},{"$f":"SUM(J129:J135)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N129:N135)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R129:R135)","v":{"$error":"#N/A"}}]
[]
[null,"XI","Level of project preparation"]
[]
[null,{"$f":"IF(C140<>\"\",MAX(B$14:B139)+1,\"\")","v":41},"To what level has the project been prepared already?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E140,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H140,$T140:$X140,0))","v":{"$error":"#N/A"}},{"$f":"I140*INDEX($F$202:$F$205,MATCH($E140,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L140,$T140:$X140,0))","v":{"$error":"#N/A"}},{"$f":"M140*INDEX($F$202:$F$205,MATCH($E140,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P140,$T140:$X140,0))","v":{"$error":"#N/A"}},{"$f":"Q140*INDEX($F$202:$F$205,MATCH($E140,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"Very basic project concept only","Project concept currently under preparation","Project concept clearly defined, including needs and benefit assessment","Pre-feasibility study completed","Feasibility study completed"]
[]
[null,{"$f":"IF(C142<>\"\",MAX(B$14:B141)+1,\"\")","v":42},"Is there sufficient data to allow project preparation?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E142,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H142,$T142:$X142,0))","v":{"$error":"#N/A"}},{"$f":"I142*INDEX($F$202:$F$205,MATCH($E142,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L142,$T142:$X142,0))","v":{"$error":"#N/A"}},{"$f":"M142*INDEX($F$202:$F$205,MATCH($E142,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P142,$T142:$X142,0))","v":{"$error":"#N/A"}},{"$f":"Q142*INDEX($F$202:$F$205,MATCH($E142,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"None","Little","Some","Most","All data available"]
[]
[null,{"$f":"IF(C144<>\"\",MAX(B$14:B143)+1,\"\")","v":43},"Have similar past projects been implemented by the government as PPPs?",null,"Medium",{"$f":" IFERROR(INDEX($F$202:$F$205,MATCH($E144,$C$202:$C$205,0),1),0)","v":{"v":0.5,"d":"{50%}"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(H144,$T144:$X144,0))","v":{"$error":"#N/A"}},{"$f":"I144*INDEX($F$202:$F$205,MATCH($E144,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(L144,$T144:$X144,0))","v":{"$error":"#N/A"}},{"$f":"M144*INDEX($F$202:$F$205,MATCH($E144,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX($T$6:$X$6,1,MATCH(P144,$T144:$X144,0))","v":{"$error":"#N/A"}},{"$f":"Q144*INDEX($F$202:$F$205,MATCH($E144,$C$202:$C$205,0),1)","v":{"$error":"#N/A"}},null,"No previous experience and no standard documents","Previous dissimilar projects with no standard documents","Previous dissimilar projects but standard documents prepared","Similar projects previously tendered","Similar projects previously tendered using standard documents"]
[]
[null,null,"Sub-total",null,"(Max score:",{"$f":"SUM(F139:F145)*$X$6","v":{"v":7.5,"d":"7.50)"}},{"$nulls":3},{"$f":"SUM(J139:J145)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N139:N145)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R139:R145)","v":{"$error":"#N/A"}}]
[]
[null,null,"Total score"]
[]
[null,{"$f":"B16","v":"I"},{"$f":"C16","v":"Public sector capacity and experience"},null,"(Max score:",{"$f":"F24","v":{"v":11.25,"d":"11.25)"}},{"$nulls":3},{"$f":"J24","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N24","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R24","v":{"$error":"#N/A"}}]
[null,{"$f":"B26","v":"II"},{"$f":"C26","v":"Public sector funding"},null,"(Max score:",{"$f":"F34","v":{"v":7.5,"d":"7.50)"}},{"$nulls":3},{"$f":"J34","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N34","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R34","v":{"$error":"#N/A"}}]
[null,{"$f":"B36","v":"III"},{"$f":"C36","v":"Private sector capability and appetite"},null,"(Max score:",{"$f":"F44","v":{"v":13.75,"d":"13.75)"}},{"$nulls":3},{"$f":"J44","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N44","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R44","v":{"$error":"#N/A"}}]
[null,{"$f":"B48","v":"IV"},{"$f":"C48","v":"Key project characteristics"},null,"(Max score:",{"$f":"F74","v":{"v":41.25,"d":"41.25)"}},{"$nulls":3},{"$f":"J74","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N74","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R74","v":{"$error":"#N/A"}}]
[null,{"$f":"B76","v":"V"},{"$f":"C76","v":"Fit with development priorities"},null,"(Max score:",{"$f":"F86","v":{"v":8.75,"d":"8.75)"}},{"$nulls":3},{"$f":"J86","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N86","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R86","v":{"$error":"#N/A"}}]
[null,{"$f":"B88","v":"VI"},{"$f":"C88","v":"Land acquisition"},null,"(Max score:",{"$f":"F94","v":{"v":10,"d":"10.00)"}},{"$nulls":3},{"$f":"J94","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N94","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R94","v":{"$error":"#N/A"}}]
[null,{"$f":"B96","v":"VII"},{"$f":"C96","v":"Environmental and social impacts"},null,"(Max score:",{"$f":"F102","v":{"v":10,"d":"10.00)"}},{"$nulls":3},{"$f":"J102","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N102","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R102","v":{"$error":"#N/A"}}]
[null,{"$f":"B104","v":"VIII"},{"$f":"C104","v":"Labour and employment"},null,"(Max score:",{"$f":"F114","v":{"v":8.75,"d":"8.75)"}},{"$nulls":3},{"$f":"J114","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N114","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R114","v":{"$error":"#N/A"}}]
[null,{"$f":"B116","v":"IX"},{"$f":"C116","v":"Demand and payment risk"},null,"(Max score:",{"$f":"F126","v":{"v":15,"d":"15.00)"}},{"$nulls":3},{"$f":"J126","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N126","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R126","v":{"$error":"#N/A"}}]
[null,{"$f":"B128","v":"X"},{"$f":"C128","v":"Commercial viability"},null,"(Max score:",{"$f":"F136","v":{"v":11.25,"d":"11.25)"}},{"$nulls":3},{"$f":"J136","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N136","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R136","v":{"$error":"#N/A"}}]
[null,{"$f":"B138","v":"XI"},{"$f":"C138","v":"Level of project preparation"},null,"(Max score:",{"$f":"F146","v":{"v":7.5,"d":"7.50)"}},{"$nulls":3},{"$f":"J146","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"N146","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"R146","v":{"$error":"#N/A"}}]
[null,null,"Total",null,"(Max score:",{"$f":"SUM($F$149:$F$160)","v":{"v":145,"d":"145.00)"}},{"$nulls":3},{"$f":"SUM(J149:J160)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(N149:N160)","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"SUM(R149:R160)","v":{"$error":"#N/A"}}]
[]
[null,null,"Final score (as % of max)",{"$nulls":6},{"$f":"IFERROR(J161/$F$161,\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(N161/$F$161,\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(R161/$F$161,\"\")","v":""}]
[null,null,"Suitability for PPP",{"$nulls":6},{"$f":"IFERROR(INDEX($C$209:$C$213,MATCH(J163,$F$209:$F$213,1),1),\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(INDEX($C$209:$C$213,MATCH(N163,$F$209:$F$213,1),1),\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(INDEX($C$209:$C$213,MATCH(R163,$F$209:$F$213,1),1),\"\")","v":""}]
[]
[null,null,"Rank against other projects",{"$nulls":6},{"$f":"IFERROR(_xlfn.RANK.EQ(J163,$G$163:$S$163,0)+COUNTIF($G$163:J163,J163)-1,\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(_xlfn.RANK.EQ(N163,$G$163:$S$163,0)+COUNTIF($G$163:N163,N163)-1,\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(_xlfn.RANK.EQ(R163,$G$163:$S$163,0)+COUNTIF($G$163:R163,R163)-1,\"\")","v":""}]
[]
[null,{"$f":"IF(MAX(B14:B147)=COUNT(B14:B147),\"\",\"ERROR\")","v":""},"CHECK",null,null,{"$f":"IF(F161=SUMIF(F14:F147,\"<=1\")*X6,\"\",\"ERROR\")","v":""},{"$nulls":3},{"$f":"IFERROR(IF(AND(SUM(J14:J147)=SUM(J150:J161),J161=SUM(J137:J145,J127:J135,J115:J125,J103:J113,J95:J101,J87:J93,J75:J85,J45:J73,J35:J43,J25:J33,J16:J23,#REF!,J14:J15)),\"\",\"ERROR\"),\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(IF(AND(SUM(N14:N147)=SUM(N150:N161),N161=SUM(N137:N145,N127:N135,N115:N125,N103:N113,N95:N101,N87:N93,N75:N85,N45:N73,N35:N43,N25:N33,N16:N23,#REF!,N14:N15)),\"\",\"ERROR\"),\"\")","v":""},{"$nulls":3},{"$f":"IFERROR(IF(AND(SUM(R14:R147)=SUM(R150:R161),R161=SUM(R137:R145,R127:R135,R115:R125,R103:R113,R95:R101,R87:R93,R75:R85,R45:R73,R35:R43,R25:R33,R16:R23,#REF!,R14:R15)),\"\",\"ERROR\"),\"\")","v":""}]
{"$rows_empty":29}
[null,"Annexes"]
[]
[null,"Importance weights"]
[]
[null,null,"Low",null,null,{"v":0.25,"d":"25%"}]
[null,null,"Medium",null,null,{"v":0.5,"d":"50%"}]
[null,null,"High",null,null,{"v":0.75,"d":"75%"}]
[null,null,"Very high",null,null,{"v":1,"d":"100%"}]
[]
[null,"Suitability rating"]
[]
[null,null,"Very difficult",null,null,{"v":0,"d":"0%"}]
[null,null,"Difficult",null,null,{"v":0.2,"d":"20%"}]
[null,null,"Possible",null,null,{"v":0.4,"d":"40%"}]
[null,null,"Attractive",null,null,{"v":0.6,"d":"60%"}]
[null,null,"Very attractive",null,null,{"v":0.8,"d":"80%"}]
[]
[null,"End of sheet"]

{"sheet":"Summary","index":1,"n_rows":79,"n_cols":6,"rows_kept":79,"merged":[[4,2,5,2],[4,3,4,5],[65,2,66,2],[65,3,66,3]]}
[null,{"$f":"[0]!Title_Model","v":"RAE: ALLOWED REVENUE MODEL"}]
[null,{"$f":"Title_Project","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Category","Score"]
[{"$nulls":3},{"$f":"IF(Tool!H11<>\"\",Tool!H11,\"\")","v":"Project A"},{"$f":"IF(Tool!L11<>\"\",Tool!L11,\"\")","v":"Project B"},{"$f":"IF(Tool!P11<>\"\",Tool!P11,\"\")","v":"Project C"}]
[null,null,{"$f":"Tool!C150","v":"Public sector capacity and experience"},{"$f":"Tool!J150","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N150,\"\")","v":""},{"$f":"IFERROR(Tool!R150,\"\")","v":""}]
[null,null,{"$f":"Tool!C151","v":"Public sector funding"},{"$f":"Tool!J151","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N151,\"\")","v":""},{"$f":"IFERROR(Tool!R151,\"\")","v":""}]
[null,null,{"$f":"Tool!C152","v":"Private sector capability and appetite"},{"$f":"Tool!J152","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N152,\"\")","v":""},{"$f":"IFERROR(Tool!R152,\"\")","v":""}]
[null,null,{"$f":"Tool!C153","v":"Key project characteristics"},{"$f":"Tool!J153","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N153,\"\")","v":""},{"$f":"IFERROR(Tool!R153,\"\")","v":""}]
[null,null,{"$f":"Tool!C154","v":"Fit with development priorities"},{"$f":"Tool!J154","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N154,\"\")","v":""},{"$f":"IFERROR(Tool!R154,\"\")","v":""}]
[null,null,{"$f":"Tool!C155","v":"Land acquisition"},{"$f":"Tool!J155","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N155,\"\")","v":""},{"$f":"IFERROR(Tool!R155,\"\")","v":""}]
[null,null,{"$f":"Tool!C156","v":"Environmental and social impacts"},{"$f":"Tool!J156","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N156,\"\")","v":""},{"$f":"IFERROR(Tool!R156,\"\")","v":""}]
[null,null,{"$f":"Tool!C157","v":"Labour and employment"},{"$f":"Tool!J157","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N157,\"\")","v":""},{"$f":"IFERROR(Tool!R157,\"\")","v":""}]
[null,null,{"$f":"Tool!C158","v":"Demand and payment risk"},{"$f":"Tool!J158","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N158,\"\")","v":""},{"$f":"IFERROR(Tool!R158,\"\")","v":""}]
[null,null,{"$f":"Tool!C159","v":"Commercial viability"},{"$f":"Tool!J159","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N159,\"\")","v":""},{"$f":"IFERROR(Tool!R159,\"\")","v":""}]
[null,null,{"$f":"Tool!C160","v":"Level of project preparation"},{"$f":"Tool!J160","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N160,\"\")","v":""},{"$f":"IFERROR(Tool!R160,\"\")","v":""}]
[null,null,{"$f":"Tool!C161","v":"Total"},{"$f":"Tool!J161","v":{"$error":"#N/A"}},{"$f":"IFERROR(Tool!N161,\"\")","v":""},{"$f":"IFERROR(Tool!R161,\"\")","v":""}]
[null,null,{"$f":"Tool!C163","v":"Final score (as % of max)"},{"$f":"Tool!J163","v":""},{"$f":"Tool!N163","v":""},{"$f":"Tool!R163","v":""}]
[null,null,{"$f":"Tool!C164","v":"Suitability for PPP"},{"$f":"Tool!J164","v":""},{"$f":"Tool!N164","v":""},{"$f":"Tool!R164","v":""}]
{"$rows_empty":45}
[null,null,"Category","Category contribution to maximum score (based on importance weights)"]
[]
[null,null,{"$f":"Tool!C150","v":"Public sector capacity and experience"},{"$f":"Tool!F150/Tool!F$161","v":{"v":0.07758620689655173,"d":"8%"}}]
[null,null,{"$f":"Tool!C151","v":"Public sector funding"},{"$f":"Tool!F151/Tool!F$161","v":{"v":0.05172413793103448,"d":"5%"}}]
[null,null,{"$f":"Tool!C152","v":"Private sector capability and appetite"},{"$f":"Tool!F152/Tool!F$161","v":{"v":0.09482758620689655,"d":"9%"}}]
[null,null,{"$f":"Tool!C153","v":"Key project characteristics"},{"$f":"Tool!F153/Tool!F$161","v":{"v":0.28448275862068967,"d":"28%"}}]
[null,null,{"$f":"Tool!C154","v":"Fit with development priorities"},{"$f":"Tool!F154/Tool!F$161","v":{"v":0.0603448275862069,"d":"6%"}}]
[null,null,{"$f":"Tool!C155","v":"Land acquisition"},{"$f":"Tool!F155/Tool!F$161","v":{"v":0.06896551724137931,"d":"7%"}}]
[null,null,{"$f":"Tool!C156","v":"Environmental and social impacts"},{"$f":"Tool!F156/Tool!F$161","v":{"v":0.06896551724137931,"d":"7%"}}]
[null,null,{"$f":"Tool!C157","v":"Labour and employment"},{"$f":"Tool!F157/Tool!F$161","v":{"v":0.0603448275862069,"d":"6%"}}]
[null,null,{"$f":"Tool!C158","v":"Demand and payment risk"},{"$f":"Tool!F158/Tool!F$161","v":{"v":0.10344827586206896,"d":"10%"}}]
[null,null,{"$f":"Tool!C159","v":"Commercial viability"},{"$f":"Tool!F159/Tool!F$161","v":{"v":0.07758620689655173,"d":"8%"}}]
[null,null,{"$f":"Tool!C160","v":"Level of project preparation"},{"$f":"Tool!F160/Tool!F$161","v":{"v":0.05172413793103448,"d":"5%"}}]
[null,null,"Total",{"$f":"Tool!F161/Tool!F$161","v":{"v":1,"d":"100%"}}]

{"sheet":"Handout","index":2,"n_rows":70,"n_cols":12,"rows_kept":70,"merged":[[3,1,4,1],[3,2,4,2],[3,4,3,8],[3,9,3,11],[61,2,61,10],[62,2,62,10],[63,2,63,10],[64,2,64,10],[65,2,65,8],[66,2,66,8],[67,2,67,8],[68,2,68,8],[69,2,69,8]]}
[null,{"$f":"[0]!Title_Model","v":"RAE: ALLOWED REVENUE MODEL"}]
[null,{"$f":"Title_Project","v":{"$error":"#REF!"}}]
[]
[null,"No.","Question",null,"Answers",{"$nulls":4},"Scoring"]
[{"$nulls":4},1,2,3,4,5,"Initial score \n(1 to 5)","Multiplied by weighting","Equals weighted score"]
[null,"A",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B6,Tool!$B$14:$B$147,0),1)","v":"How supportive is the PPP environment?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B6,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B6,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B6,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B6,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B6,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B6,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B6,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B6,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B6,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B6,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B6,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B6,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(J6<>\"\",K6*J6,\"\")","v":""}]
[null,"I",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B7,Tool!$B$14:$B$147,0),1)","v":"Public sector capacity and experience"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B7,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B7,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B7,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B7,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B7,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B7,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B7,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B7,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B7,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B7,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B7,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B7,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B7)+1","v":1},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B8,Tool!$B$14:$B$147,0),1)","v":"Does the sponsoring entity have the capabilities to procure PPPs?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B8,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B8,Tool!$B$14:$B$147,0),1),\"\")","v":"No capabilities"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B8,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B8,Tool!$B$14:$B$147,0),1),\"\")","v":"Very little capability"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B8,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B8,Tool!$B$14:$B$147,0),1),\"\")","v":"Some capabilities"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B8,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B8,Tool!$B$14:$B$147,0),1),\"\")","v":"Good capability"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B8,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B8,Tool!$B$14:$B$147,0),1),\"\")","v":"Full set of capabilities"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B8,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B8,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B8)+1","v":2},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B9,Tool!$B$14:$B$147,0),1)","v":"Does the sponsoring entity have the capabilities to manage and monitor a PPP contract?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B9,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B9,Tool!$B$14:$B$147,0),1),\"\")","v":"No capabilities"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B9,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B9,Tool!$B$14:$B$147,0),1),\"\")","v":"Very little capability"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B9,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B9,Tool!$B$14:$B$147,0),1),\"\")","v":"Some capabilities"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B9,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B9,Tool!$B$14:$B$147,0),1),\"\")","v":"Good capability"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B9,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B9,Tool!$B$14:$B$147,0),1),\"\")","v":"Full set of capabilities"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B9,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B9,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B9)+1","v":3},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B10,Tool!$B$14:$B$147,0),1)","v":"Does the sponsoring entity have previous experience with PPPs?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B10,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B10,Tool!$B$14:$B$147,0),1),\"\")","v":"No previous PPP experience"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B10,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B10,Tool!$B$14:$B$147,0),1),\"\")","v":"Some experience with dissimilar PPPs"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B10,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B10,Tool!$B$14:$B$147,0),1),\"\")","v":"Limited experience (1 project), for a similar PPP"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B10,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B10,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant experience (2-4 projects), including similar PPPs"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B10,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B10,Tool!$B$14:$B$147,0),1),\"\")","v":"Extensive experience (5+ projects), including similar PPPs"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B10,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B10,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,"II",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B11,Tool!$B$14:$B$147,0),1)","v":"Public sector funding"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B11,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B11,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B11,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B11,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B11,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B11,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B11,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B11,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B11,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B11,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B11,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B11,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B11)+1","v":4},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B12,Tool!$B$14:$B$147,0),1)","v":"Is funding assistance available for project preparation?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B12,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B12,Tool!$B$14:$B$147,0),1),\"\")","v":"Not at all"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B12,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B12,Tool!$B$14:$B$147,0),1),\"\")","v":"Unlikely"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B12,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B12,Tool!$B$14:$B$147,0),1),\"\")","v":"Possible"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B12,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B12,Tool!$B$14:$B$147,0),1),\"\")","v":"Likely"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B12,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B12,Tool!$B$14:$B$147,0),1),\"\")","v":"Guaranteed"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B12,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B12,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.25,"d":"25%"}},""]
[null,{"$f":"MAX(B$6:B12)+1","v":5},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B13,Tool!$B$14:$B$147,0),1)","v":"Is viability gap funding available for the PPP project?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B13,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B13,Tool!$B$14:$B$147,0),1),\"\")","v":"Not at all"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B13,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B13,Tool!$B$14:$B$147,0),1),\"\")","v":"Unlikely"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B13,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B13,Tool!$B$14:$B$147,0),1),\"\")","v":"Possible"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B13,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B13,Tool!$B$14:$B$147,0),1),\"\")","v":"Likely"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B13,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B13,Tool!$B$14:$B$147,0),1),\"\")","v":"Guaranteed"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B13,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B13,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B13)+1","v":6},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B14,Tool!$B$14:$B$147,0),1)","v":"Is the PPP project eligible for significant funding from other sources?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B14,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B14,Tool!$B$14:$B$147,0),1),\"\")","v":"Not at all"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B14,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B14,Tool!$B$14:$B$147,0),1),\"\")","v":"Unlikely"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B14,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B14,Tool!$B$14:$B$147,0),1),\"\")","v":"Possible"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B14,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B14,Tool!$B$14:$B$147,0),1),\"\")","v":"Likely"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B14,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B14,Tool!$B$14:$B$147,0),1),\"\")","v":"Guaranteed"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B14,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B14,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,"III",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B15,Tool!$B$14:$B$147,0),1)","v":"Private sector capability and appetite"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B15,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B15,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B15,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B15,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B15,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B15,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B15,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B15,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B15,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B15,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B15,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B15,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B15)+1","v":7},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B16,Tool!$B$14:$B$147,0),1)","v":"Are multiple firms active in the project sector and likely to be interested?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B16,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B16,Tool!$B$14:$B$147,0),1),\"\")","v":"No interest expected"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B16,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B16,Tool!$B$14:$B$147,0),1),\"\")","v":"Extent of interest among qualified firms is not yet known"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B16,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B16,Tool!$B$14:$B$147,0),1),\"\")","v":"Some interest expected"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B16,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B16,Tool!$B$14:$B$147,0),1),\"\")","v":"5+ qualified firms are expected to be interested"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B16,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B16,Tool!$B$14:$B$147,0),1),\"\")","v":"5+ qualified firms have competed for similar opportunities"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B16,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B16,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,{"$f":"MAX(B$6:B16)+1","v":8},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B17,Tool!$B$14:$B$147,0),1)","v":"Have similar PPP projects been successfully financed in Afghanistan?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B17,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B17,Tool!$B$14:$B$147,0),1),\"\")","v":"No PPP projects recently financed"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B17,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B17,Tool!$B$14:$B$147,0),1),\"\")","v":"No similar PPP projects recently financed"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B17,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B17,Tool!$B$14:$B$147,0),1),\"\")","v":"Dissimilar PPP projects financed in last 2 years"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B17,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B17,Tool!$B$14:$B$147,0),1),\"\")","v":"At least one similar PPP project successfully financed in last 2 years"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B17,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B17,Tool!$B$14:$B$147,0),1),\"\")","v":"Multiple similar PPP projects successfully financed in last 2 years"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B17,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B17,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(J17<>\"\",K17*J17,\"\")","v":""}]
[null,{"$f":"MAX(B$6:B17)+1","v":9},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B18,Tool!$B$14:$B$147,0),1)","v":"Have similar PPP projects been successfully financed in countries similar to Afghanistan?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B18,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B18,Tool!$B$14:$B$147,0),1),\"\")","v":"No PPP projects recently financed"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B18,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B18,Tool!$B$14:$B$147,0),1),\"\")","v":"No similar PPP projects recently financed"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B18,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B18,Tool!$B$14:$B$147,0),1),\"\")","v":"Somewhat similar PPP projects financed in last 2 years"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B18,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B18,Tool!$B$14:$B$147,0),1),\"\")","v":"At least one very similar PPP project successfully financed in last 2 years"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B18,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B18,Tool!$B$14:$B$147,0),1),\"\")","v":"Multiple very similar PPP projects successfully financed in last 2 years"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B18,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B18,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,"B",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B19,Tool!$B$14:$B$147,0),1)","v":"How suitable is the project for PPP?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B19,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B19,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B19,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B19,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B19,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B19,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B19,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B19,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B19,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B19,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B19,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B19,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,"IV",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B20,Tool!$B$14:$B$147,0),1)","v":"Key project characteristics"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B20,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B20,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B20,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B20,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B20,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B20,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B20,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B20,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B20,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B20,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B20,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B20,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B20)+1","v":10},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B21,Tool!$B$14:$B$147,0),1)","v":"What is the project value?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B21,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B21,Tool!$B$14:$B$147,0),1),\"\")","v":"Project is less than USD 5m"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B21,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B21,Tool!$B$14:$B$147,0),1),\"\")","v":"Project is between USD 5m and 20m"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B21,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B21,Tool!$B$14:$B$147,0),1),\"\")","v":"Project is between USD 20m and 100m"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B21,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B21,Tool!$B$14:$B$147,0),1),\"\")","v":"Project is between USD 100m and 300m"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B21,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B21,Tool!$B$14:$B$147,0),1),\"\")","v":"Project is greater than USD 300m"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B21,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B21,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B21)+1","v":11},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B22,Tool!$B$14:$B$147,0),1)","v":"What is the expected project duration (including construction)?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B22,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B22,Tool!$B$14:$B$147,0),1),\"\")","v":"Less than five years"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B22,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B22,Tool!$B$14:$B$147,0),1),\"\")","v":"5 to 10 years"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B22,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B22,Tool!$B$14:$B$147,0),1),\"\")","v":"10 to 15 years"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B22,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B22,Tool!$B$14:$B$147,0),1),\"\")","v":"15 to 20 years"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B22,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B22,Tool!$B$14:$B$147,0),1),\"\")","v":"> 20 years"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B22,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B22,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B22)+1","v":12},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B23,Tool!$B$14:$B$147,0),1)","v":"Are outputs easily definable, measurable and verifiable?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B23,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B23,Tool!$B$14:$B$147,0),1),\"\")","v":"No ability to define, measure or verify outputs"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B23,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B23,Tool!$B$14:$B$147,0),1),\"\")","v":"Multiple outputs, difficult to define and/or measure and/or verify"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B23,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B23,Tool!$B$14:$B$147,0),1),\"\")","v":"Few outputs, difficult to define and/or measure and/or verify"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B23,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B23,Tool!$B$14:$B$147,0),1),\"\")","v":"Multiple outputs, each easily definable, measureable and verifiable"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B23,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B23,Tool!$B$14:$B$147,0),1),\"\")","v":"Few outputs, each easily definable, measureable and verifiable"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B23,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B23,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(J23<>\"\",K23*J23,\"\")","v":""}]
[null,{"$f":"MAX(B$6:B23)+1","v":13},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B24,Tool!$B$14:$B$147,0),1)","v":"How complex is the project?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B24,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B24,Tool!$B$14:$B$147,0),1),\"\")","v":"Very complex"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B24,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B24,Tool!$B$14:$B$147,0),1),\"\")","v":"Challenging"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B24,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B24,Tool!$B$14:$B$147,0),1),\"\")","v":"Middle"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B24,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B24,Tool!$B$14:$B$147,0),1),\"\")","v":"Fairly simple"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B24,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B24,Tool!$B$14:$B$147,0),1),\"\")","v":"Straight forward"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B24,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B24,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B24)+1","v":14},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B25,Tool!$B$14:$B$147,0),1)","v":"Are operational (non-construction) costs are a large part of the total costs of the project?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B25,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B25,Tool!$B$14:$B$147,0),1),\"\")","v":"Operational costs are almost non-existent relative to construction costs"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B25,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B25,Tool!$B$14:$B$147,0),1),\"\")","v":"Operational costs are significantly lower than construction costs"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B25,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B25,Tool!$B$14:$B$147,0),1),\"\")","v":"Operational costs are similar to construction costs"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B25,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B25,Tool!$B$14:$B$147,0),1),\"\")","v":"Operational costs are higher than construction costs"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B25,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B25,Tool!$B$14:$B$147,0),1),\"\")","v":"Operational costs greatly exceed construction costs"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B25,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B25,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B25)+1","v":15},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B26,Tool!$B$14:$B$147,0),1)","v":"Are there fixed time constraints on project award?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B26,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B26,Tool!$B$14:$B$147,0),1),\"\")","v":"Project must be awarded within 6 months"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B26,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B26,Tool!$B$14:$B$147,0),1),\"\")","v":"Project must be awarded with 1 year"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B26,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B26,Tool!$B$14:$B$147,0),1),\"\")","v":"Project must be awarded within 2 years"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B26,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B26,Tool!$B$14:$B$147,0),1),\"\")","v":"Project must be awarded within 3 years"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B26,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B26,Tool!$B$14:$B$147,0),1),\"\")","v":"No time constraints"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B26,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B26,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B26)+1","v":16},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B27,Tool!$B$14:$B$147,0),1)","v":"How secure is the project location?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B27,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B27,Tool!$B$14:$B$147,0),1),\"\")","v":"Extreme security issues"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B27,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B27,Tool!$B$14:$B$147,0),1),\"\")","v":"Serious security issues likely"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B27,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B27,Tool!$B$14:$B$147,0),1),\"\")","v":"Some security issues likely"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B27,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B27,Tool!$B$14:$B$147,0),1),\"\")","v":"Low risk of security issues"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B27,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B27,Tool!$B$14:$B$147,0),1),\"\")","v":"No known security issues"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B27,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B27,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,{"$f":"MAX(B$6:B27)+1","v":17},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B28,Tool!$B$14:$B$147,0),1)","v":"Are staff and/or resources to be sourced locally or abroad?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B28,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B28,Tool!$B$14:$B$147,0),1),\"\")","v":"All foreign resources with prior capacity building required"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B28,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B28,Tool!$B$14:$B$147,0),1),\"\")","v":"Local resources with prior capacity building required"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B28,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B28,Tool!$B$14:$B$147,0),1),\"\")","v":"Foreign staff ready with local leadership"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B28,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B28,Tool!$B$14:$B$147,0),1),\"\")","v":"Local staff ready with foreign leadership"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B28,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B28,Tool!$B$14:$B$147,0),1),\"\")","v":"All local experts ready to go"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B28,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B28,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B28)+1","v":18},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B29,Tool!$B$14:$B$147,0),1)","v":"Does the project require the development of new/advanced technology?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B29,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B29,Tool!$B$14:$B$147,0),1),\"\")","v":"Requires the development of new technologies"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B29,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B29,Tool!$B$14:$B$147,0),1),\"\")","v":"Requires advanced technology"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B29,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B29,Tool!$B$14:$B$147,0),1),\"\")","v":"Some advanced technology required"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B29,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B29,Tool!$B$14:$B$147,0),1),\"\")","v":"Low amounts of easily implemented advanced technology required"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B29,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B29,Tool!$B$14:$B$147,0),1),\"\")","v":"No new/advanced technology required"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B29,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B29,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B29)+1","v":19},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B30,Tool!$B$14:$B$147,0),1)","v":"Is the project reliant on other projects yet to be constructed?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B30,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B30,Tool!$B$14:$B$147,0),1),\"\")","v":"Very reliant on projects that are likely to cause delays "},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B30,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B30,Tool!$B$14:$B$147,0),1),\"\")","v":"Reliant on projects that are due to be completed around the time of this PPP"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B30,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B30,Tool!$B$14:$B$147,0),1),\"\")","v":"Reliant on projects that are likely to be completed well ahead of this PPP"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B30,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B30,Tool!$B$14:$B$147,0),1),\"\")","v":"Minimal reliance on other projects"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B30,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B30,Tool!$B$14:$B$147,0),1),\"\")","v":"Not at all reliant"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B30,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B30,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},{"$f":"IF(J30<>\"\",K30*J30,\"\")","v":""}]
[null,{"$f":"MAX(B$6:B30)+1","v":20},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B31,Tool!$B$14:$B$147,0),1)","v":"Does operation of the project rely heavily on a single supplier of goods or services?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B31,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B31,Tool!$B$14:$B$147,0),1),\"\")","v":"It is not clear where the supply is coming from"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B31,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B31,Tool!$B$14:$B$147,0),1),\"\")","v":"Yes, without a long-term supply contract"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B31,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B31,Tool!$B$14:$B$147,0),1),\"\")","v":"Long term supply contract, with either non-investment grade company or SOE without government guarantee"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B31,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B31,Tool!$B$14:$B$147,0),1),\"\")","v":"Long term supply contract, with either investment grade company or SOE with government guarantee"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B31,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B31,Tool!$B$14:$B$147,0),1),\"\")","v":"Not heavily reliant"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B31,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B31,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},{"$f":"IF(J31<>\"\",K31*J31,\"\")","v":""}]
[null,{"$f":"MAX(B$6:B31)+1","v":21},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B32,Tool!$B$14:$B$147,0),1)","v":"Would the physical infrastructure pass through multiple jurisdictions?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B32,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B32,Tool!$B$14:$B$147,0),1),\"\")","v":"Project in multiple jurisdictions with NO experience of shared PPPs"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B32,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B32,Tool!$B$14:$B$147,0),1),\"\")","v":"Project in multiple jurisdictions with limited experience of shared PPPs"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B32,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B32,Tool!$B$14:$B$147,0),1),\"\")","v":"Project in multiple jurisdictions with previous experience of shared PPPs"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B32,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B32,Tool!$B$14:$B$147,0),1),\"\")","v":"Project in two jurisdictions"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B32,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B32,Tool!$B$14:$B$147,0),1),\"\")","v":"Project fully contained within one jurisdiction "},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B32,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B32,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,"V",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B33,Tool!$B$14:$B$147,0),1)","v":"Fit with development priorities"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B33,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B33,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B33,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B33,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B33,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B33,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B33,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B33,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B33,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B33,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B33,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B33,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B33)+1","v":22},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B34,Tool!$B$14:$B$147,0),1)","v":"Does the project fit into national development priorities?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B34,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B34,Tool!$B$14:$B$147,0),1),\"\")","v":"Not at all"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B34,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B34,Tool!$B$14:$B$147,0),1),\"\")","v":"Low"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B34,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B34,Tool!$B$14:$B$147,0),1),\"\")","v":"Medium"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B34,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B34,Tool!$B$14:$B$147,0),1),\"\")","v":"High"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B34,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B34,Tool!$B$14:$B$147,0),1),\"\")","v":"Top"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B34,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B34,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B34)+1","v":23},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B35,Tool!$B$14:$B$147,0),1)","v":"Is the project part of a sector plan?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B35,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B35,Tool!$B$14:$B$147,0),1),\"\")","v":"Conflicts with sector plan"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B35,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B35,Tool!$B$14:$B$147,0),1),\"\")","v":"Ad hoc project- but not in conflict with sector plan"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B35,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B35,Tool!$B$14:$B$147,0),1),\"\")","v":"Ad hoc project- but in line with sector plan"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B35,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B35,Tool!$B$14:$B$147,0),1),\"\")","v":"Part of sector plan"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B35,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B35,Tool!$B$14:$B$147,0),1),\"\")","v":"Forms integral part of sector plan"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B35,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B35,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B35)+1","v":24},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B36,Tool!$B$14:$B$147,0),1)","v":"Is the development of this project a prerequisite to other potential projects?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B36,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B36,Tool!$B$14:$B$147,0),1),\"\")","v":"Prevents the development of further projects"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B36,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B36,Tool!$B$14:$B$147,0),1),\"\")","v":"Detrimental to the feasibility of other projects"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B36,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B36,Tool!$B$14:$B$147,0),1),\"\")","v":"Does not affect the feasibility of other projects"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B36,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B36,Tool!$B$14:$B$147,0),1),\"\")","v":"Important to development"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B36,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B36,Tool!$B$14:$B$147,0),1),\"\")","v":"Yes-central to development"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B36,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B36,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.25,"d":"25%"}},""]
[null,{"$f":"MAX(B$6:B36)+1","v":25},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B37,Tool!$B$14:$B$147,0),1)","v":"What is the potential impact on export earnings"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B37,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B37,Tool!$B$14:$B$147,0),1),\"\")","v":"Major negative overseas trade and/or tourism impact"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B37,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B37,Tool!$B$14:$B$147,0),1),\"\")","v":"Limited negative overseas trade and/or tourism impact"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B37,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B37,Tool!$B$14:$B$147,0),1),\"\")","v":"No positive or negative overseas trade and/or tourism impact"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B37,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B37,Tool!$B$14:$B$147,0),1),\"\")","v":"Limited positive overseas trade and/or tourism impact"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B37,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B37,Tool!$B$14:$B$147,0),1),\"\")","v":"Major positive overseas trade and/or tourism impact"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B37,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B37,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.25,"d":"25%"}},""]
[null,"VI",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B38,Tool!$B$14:$B$147,0),1)","v":"Land acquisition"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B38,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B38,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B38,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B38,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B38,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B38,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B38,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B38,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B38,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B38,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B38,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B38,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B38)+1","v":26},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B39,Tool!$B$14:$B$147,0),1)","v":"Will the PPP require land acquisition?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B39,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B39,Tool!$B$14:$B$147,0),1),\"\")","v":"Major land acquisition"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B39,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B39,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant land acquisition"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B39,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B39,Tool!$B$14:$B$147,0),1),\"\")","v":"Some land acquisition"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B39,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B39,Tool!$B$14:$B$147,0),1),\"\")","v":"Minor land acquisition"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B39,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B39,Tool!$B$14:$B$147,0),1),\"\")","v":"No land acquisition"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B39,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B39,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,{"$f":"MAX(B$6:B39)+1","v":27},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B40,Tool!$B$14:$B$147,0),1)","v":"If land acquisition is required, will the public sector do this?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B40,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B40,Tool!$B$14:$B$147,0),1),\"\")","v":"Public sector will not acquire land"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B40,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B40,Tool!$B$14:$B$147,0),1),\"\")","v":"Public sector will acquire some land before construction start"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B40,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B40,Tool!$B$14:$B$147,0),1),\"\")","v":"Public sector will acquire land before construction start"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B40,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B40,Tool!$B$14:$B$147,0),1),\"\")","v":"Public sector will acquire land before project tendered"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B40,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B40,Tool!$B$14:$B$147,0),1),\"\")","v":"No land acquisition"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B40,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B40,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,"VII",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B41,Tool!$B$14:$B$147,0),1)","v":"Environmental and social impacts"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B41,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B41,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B41,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B41,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B41,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B41,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B41,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B41,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B41,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B41,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B41,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B41,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B41)+1","v":28},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B42,Tool!$B$14:$B$147,0),1)","v":"Will the PPP have significant negative environmental impacts?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B42,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B42,Tool!$B$14:$B$147,0),1),\"\")","v":"Major negative impacts"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B42,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B42,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant negative impacts"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B42,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B42,Tool!$B$14:$B$147,0),1),\"\")","v":"Some negative impacts"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B42,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B42,Tool!$B$14:$B$147,0),1),\"\")","v":"Minimal negative impacts"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B42,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B42,Tool!$B$14:$B$147,0),1),\"\")","v":"No negative impacts"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B42,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B42,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,{"$f":"MAX(B$6:B42)+1","v":29},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B43,Tool!$B$14:$B$147,0),1)","v":"Will the PPP have significant negative social impacts, including resettlement of houses, businesses etc."},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B43,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B43,Tool!$B$14:$B$147,0),1),\"\")","v":"Major negative impacts"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B43,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B43,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant negative impacts"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B43,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B43,Tool!$B$14:$B$147,0),1),\"\")","v":"Some negative impacts"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B43,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B43,Tool!$B$14:$B$147,0),1),\"\")","v":"Minimal negative impacts"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B43,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B43,Tool!$B$14:$B$147,0),1),\"\")","v":"No negative impacts"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B43,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B43,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,"VIII",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B44,Tool!$B$14:$B$147,0),1)","v":"Labour and employment"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B44,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B44,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B44,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B44,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B44,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B44,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B44,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B44,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B44,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B44,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B44,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B44,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B44)+1","v":30},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B45,Tool!$B$14:$B$147,0),1)","v":"Will a significant transfer of employees take place under the PPP?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B45,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B45,Tool!$B$14:$B$147,0),1),\"\")","v":"Very large numbers (>25%) transferred"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B45,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B45,Tool!$B$14:$B$147,0),1),\"\")","v":"Large numbers (15-25%) transferred"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B45,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B45,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant numbers (5-15%) transferred"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B45,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B45,Tool!$B$14:$B$147,0),1),\"\")","v":"Moderate numbers (2-5%) transferred"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B45,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B45,Tool!$B$14:$B$147,0),1),\"\")","v":"Insignificant numbers (<2%) transferred"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B45,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B45,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B45)+1","v":31},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B46,Tool!$B$14:$B$147,0),1)","v":"Have there been successful transfers under previous PPPs?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B46,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B46,Tool!$B$14:$B$147,0),1),\"\")","v":"No previous transfers"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B46,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B46,Tool!$B$14:$B$147,0),1),\"\")","v":"Most past transfers have been unsuccessful"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B46,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B46,Tool!$B$14:$B$147,0),1),\"\")","v":"Past transfers have had mixed results"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B46,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B46,Tool!$B$14:$B$147,0),1),\"\")","v":"Most past transfers have been successful"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B46,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B46,Tool!$B$14:$B$147,0),1),\"\")","v":"No significant transfers required OR successful past transfers completed"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B46,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B46,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.25,"d":"25%"}},""]
[null,{"$f":"MAX(B$6:B46)+1","v":32},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B47,Tool!$B$14:$B$147,0),1)","v":"Is the project likely to result in job losses or create new jobs?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B47,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B47,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant job losses likely (>10% of existing workforce)"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B47,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B47,Tool!$B$14:$B$147,0),1),\"\")","v":"Some job losses likely (<10% of existing workforce)"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B47,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B47,Tool!$B$14:$B$147,0),1),\"\")","v":"No job losses are expected"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B47,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B47,Tool!$B$14:$B$147,0),1),\"\")","v":"The project is expected to create a few new jobs"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B47,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B47,Tool!$B$14:$B$147,0),1),\"\")","v":"The project is expected to create many new jobs"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B47,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B47,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B47)+1","v":33},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B48,Tool!$B$14:$B$147,0),1)","v":"What proportion of the project works, goods, and services will be acquired locally?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B48,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B48,Tool!$B$14:$B$147,0),1),\"\")","v":"Insignificant proportion (< 10%)"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B48,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B48,Tool!$B$14:$B$147,0),1),\"\")","v":"Moderate proportion (10 - 30%)"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B48,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B48,Tool!$B$14:$B$147,0),1),\"\")","v":"Significant proportion (30 - 50%)"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B48,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B48,Tool!$B$14:$B$147,0),1),\"\")","v":"Large proportion (50 - 80%)"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B48,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B48,Tool!$B$14:$B$147,0),1),\"\")","v":"Very large proportion (> 80%)"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B48,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B48,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,"IX",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B49,Tool!$B$14:$B$147,0),1)","v":"Demand and payment risk"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B49,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B49,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B49,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B49,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B49,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B49,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B49,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B49,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B49,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B49,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B49,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B49,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B49)+1","v":34},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B50,Tool!$B$14:$B$147,0),1)","v":"What is the main revenue source for the project?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B50,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B50,Tool!$B$14:$B$147,0),1),\"\")","v":"As yet unknown"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B50,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B50,Tool!$B$14:$B$147,0),1),\"\")","v":"Other"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B50,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B50,Tool!$B$14:$B$147,0),1),\"\")","v":"Charges (user pays)"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B50,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B50,Tool!$B$14:$B$147,0),1),\"\")","v":"Shadow charges (government pays)"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B50,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B50,Tool!$B$14:$B$147,0),1),\"\")","v":"Annuity payments"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B50,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B50,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B50)+1","v":35},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B51,Tool!$B$14:$B$147,0),1)","v":"How much demand risk is there?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B51,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B51,Tool!$B$14:$B$147,0),1),\"\")","v":"Very high demand risk"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B51,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B51,Tool!$B$14:$B$147,0),1),\"\")","v":"High demand risk"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B51,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B51,Tool!$B$14:$B$147,0),1),\"\")","v":"Moderate demand risk"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B51,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B51,Tool!$B$14:$B$147,0),1),\"\")","v":"Low demand risk"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B51,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B51,Tool!$B$14:$B$147,0),1),\"\")","v":"No demand risk"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B51,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B51,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B51)+1","v":36},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B52,Tool!$B$14:$B$147,0),1)","v":"How are user charges (or shadow charges) set?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B52,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B52,Tool!$B$14:$B$147,0),1),\"\")","v":"Set by ministry / public enterprise using discretion"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B52,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B52,Tool!$B$14:$B$147,0),1),\"\")","v":"Set by independent regulator using discretion"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B52,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B52,Tool!$B$14:$B$147,0),1),\"\")","v":"Set by ministry / public enterprise using formula in contract"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B52,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B52,Tool!$B$14:$B$147,0),1),\"\")","v":"Set by independent regulator using formula in contract"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B52,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B52,Tool!$B$14:$B$147,0),1),\"\")","v":"Fixed for contract life OR no user charges payable"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B52,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B52,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,{"$f":"MAX(B$6:B52)+1","v":37},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B53,Tool!$B$14:$B$147,0),1)","v":"Are the entity's subsidies / annuity payments guaranteed by central government?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B53,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B53,Tool!$B$14:$B$147,0),1),\"\")","v":"No guarantee, very poor track record of paying subsidies / annuities"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B53,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B53,Tool!$B$14:$B$147,0),1),\"\")","v":"No guarantee, unreliable track record of paying subsidies / annuities"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B53,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B53,Tool!$B$14:$B$147,0),1),\"\")","v":"No guarantee, no previous requirement to pay subsidies / annuities"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B53,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B53,Tool!$B$14:$B$147,0),1),\"\")","v":"No guarantee, good track record of paying subsidies / annuities"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B53,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B53,Tool!$B$14:$B$147,0),1),\"\")","v":"No subsidies/annuities payable OR payment backed by a central government guarantee"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B53,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B53,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,"X",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B54,Tool!$B$14:$B$147,0),1)","v":"Commercial viability"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B54,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B54,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B54,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B54,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B54,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B54,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B54,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B54,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B54,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B54,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B54,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B54,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B54)+1","v":38},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B55,Tool!$B$14:$B$147,0),1)","v":"Is the financial viability of the project dependent on receiving a grant/subsidy?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B55,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B55,Tool!$B$14:$B$147,0),1),\"\")","v":"Completely"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B55,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B55,Tool!$B$14:$B$147,0),1),\"\")","v":"Likely"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B55,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B55,Tool!$B$14:$B$147,0),1),\"\")","v":"Somewhat"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B55,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B55,Tool!$B$14:$B$147,0),1),\"\")","v":"Unlikely"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B55,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B55,Tool!$B$14:$B$147,0),1),\"\")","v":"Not at all"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B55,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B55,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":1,"d":"100%"}},""]
[null,{"$f":"MAX(B$6:B55)+1","v":39},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B56,Tool!$B$14:$B$147,0),1)","v":"How soon after the start of the project are positive cash flows expected to start"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B56,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B56,Tool!$B$14:$B$147,0),1),\"\")","v":"5 Years +"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B56,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B56,Tool!$B$14:$B$147,0),1),\"\")","v":"3-5 Years"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B56,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B56,Tool!$B$14:$B$147,0),1),\"\")","v":"2-3 Years"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B56,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B56,Tool!$B$14:$B$147,0),1),\"\")","v":"1-2 Years"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B56,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B56,Tool!$B$14:$B$147,0),1),\"\")","v":"<1 Year"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B56,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B56,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B56)+1","v":40},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B57,Tool!$B$14:$B$147,0),1)","v":"What overall level of risk is assumed by the private sector?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B57,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B57,Tool!$B$14:$B$147,0),1),\"\")","v":"High"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B57,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B57,Tool!$B$14:$B$147,0),1),\"\")","v":"Moderate to high"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B57,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B57,Tool!$B$14:$B$147,0),1),\"\")","v":"Moderate"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B57,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B57,Tool!$B$14:$B$147,0),1),\"\")","v":"Minimal to moderate"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B57,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B57,Tool!$B$14:$B$147,0),1),\"\")","v":"Minimal"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B57,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B57,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.75,"d":"75%"}},""]
[null,"XI",{"$f":"INDEX(Tool!C$14:C$147,MATCH($B58,Tool!$B$14:$B$147,0),1)","v":"Level of project preparation"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B58,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B58,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B58,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B58,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B58,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B58,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B58,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B58,Tool!$B$14:$B$147,0),1),\"\")","v":""},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B58,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B58,Tool!$B$14:$B$147,0),1),\"\")","v":""},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B58,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B58,Tool!$B$14:$B$147,0),1),\"\")","v":""},""]
[null,{"$f":"MAX(B$6:B58)+1","v":41},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B59,Tool!$B$14:$B$147,0),1)","v":"To what level has the project been prepared already?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B59,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B59,Tool!$B$14:$B$147,0),1),\"\")","v":"Very basic project concept only"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B59,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B59,Tool!$B$14:$B$147,0),1),\"\")","v":"Project concept currently under preparation"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B59,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B59,Tool!$B$14:$B$147,0),1),\"\")","v":"Project concept clearly defined, including needs and benefit assessment"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B59,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B59,Tool!$B$14:$B$147,0),1),\"\")","v":"Pre-feasibility study completed"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B59,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B59,Tool!$B$14:$B$147,0),1),\"\")","v":"Feasibility study completed"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B59,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B59,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B59)+1","v":42},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B60,Tool!$B$14:$B$147,0),1)","v":"Is there sufficient data to allow project preparation?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B60,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B60,Tool!$B$14:$B$147,0),1),\"\")","v":"None"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B60,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B60,Tool!$B$14:$B$147,0),1),\"\")","v":"Little"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B60,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B60,Tool!$B$14:$B$147,0),1),\"\")","v":"Some"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B60,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B60,Tool!$B$14:$B$147,0),1),\"\")","v":"Most"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B60,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B60,Tool!$B$14:$B$147,0),1),\"\")","v":"All data available"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B60,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B60,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,{"$f":"MAX(B$6:B60)+1","v":43},{"$f":"INDEX(Tool!C$14:C$147,MATCH($B61,Tool!$B$14:$B$147,0),1)","v":"Have similar past projects been implemented by the government as PPPs?"},null,{"$f":"IF(INDEX(Tool!T$14:T$147,MATCH($B61,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!T$14:T$147,MATCH($B61,Tool!$B$14:$B$147,0),1),\"\")","v":"No previous experience and no standard documents"},{"$f":"IF(INDEX(Tool!U$14:U$147,MATCH($B61,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!U$14:U$147,MATCH($B61,Tool!$B$14:$B$147,0),1),\"\")","v":"Previous dissimilar projects with no standard documents"},{"$f":"IF(INDEX(Tool!V$14:V$147,MATCH($B61,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!V$14:V$147,MATCH($B61,Tool!$B$14:$B$147,0),1),\"\")","v":"Previous dissimilar projects but standard documents prepared"},{"$f":"IF(INDEX(Tool!W$14:W$147,MATCH($B61,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!W$14:W$147,MATCH($B61,Tool!$B$14:$B$147,0),1),\"\")","v":"Similar projects previously tendered"},{"$f":"IF(INDEX(Tool!X$14:X$147,MATCH($B61,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!X$14:X$147,MATCH($B61,Tool!$B$14:$B$147,0),1),\"\")","v":"Similar projects previously tendered using standard documents"},null,{"$f":"IF(INDEX(Tool!F$14:F$147,MATCH($B61,Tool!$B$14:$B$147,0),1)<>\"\",INDEX(Tool!F$14:F$147,MATCH($B61,Tool!$B$14:$B$147,0),1),\"\")","v":{"v":0.5,"d":"50%"}},""]
[null,null,"Total weighted score",{"$nulls":8},{"$f":"IF(SUM(L6:L61)>0,SUM(L6:L61),\"\")","v":""}]
[null,null,"Max possible weighted score",{"$nulls":8},{"$f":"SUM(K6:K61)*I5","v":145}]
[null,null,"Final score (as % of max)",{"$nulls":8},{"$f":"IF(L62<>\"\",L62/L63,\"\")","v":""}]
[null,null,"Suitability rating:",{"$nulls":8},"Tick below"]
[null,null,"Very difficult",{"$nulls":6},"Final score >=",{"$f":"Tool!F209","v":{"v":0,"d":"0%"}},{"$f":"IF(AND($L$64>=K66,$L$64<K67),C66,\"\")","v":""}]
[null,null,"Difficult",{"$nulls":6},"Final score >=",{"$f":"Tool!F210","v":{"v":0.2,"d":"20%"}},{"$f":"IF(AND($L$64>=K67,$L$64<K68),C67,\"\")","v":""}]
[null,null,"Possible",{"$nulls":6},"Final score >=",{"$f":"Tool!F211","v":{"v":0.4,"d":"40%"}},{"$f":"IF(AND($L$64>=K68,$L$64<K69),C68,\"\")","v":""}]
[null,null,"Attractive",{"$nulls":6},"Final score >=",{"$f":"Tool!F212","v":{"v":0.6,"d":"60%"}},{"$f":"IF(AND($L$64>=K69,$L$64<K70),C69,\"\")","v":""}]
[null,null,"Very attractive",{"$nulls":6},"Final score >=",{"$f":"Tool!F213","v":{"v":0.8,"d":"80%"}},{"$f":"IF(AND($L$64>=K70,$L$64<=1),C70,\"\")","v":""}]