{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Self-assessment questionnaire","Drop-down values"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Self-assessment questionnaire","index":0,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,1,11,7],[12,3,12,6],[49,8,49,9],[44,2,44,7],[25,1,26,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please complete questions 1 through 12. Depending on your answers you may be asked another few questions to determine your final PML."]
[null,"No","Question","Answer options",null,null,null,"Pick answer from drop-down","Subscore","Subscore","Subscore","Subscore","Score"]
[null,1,"Problems and opportunities of the project have been analysed. ","Yes","No",null,null,"No",{"$f":"IF(H14=\"Yes\", 1, 0)","v":0},{"$f":"IF(I14=\"No\", 0, 0)","v":0},null,null,{"$f":"SUM(I14:L14)","v":0}]
[null,2,"The target sector of the project has been identified (positive and clean energy, energy efficiency in buildings, renewables, ICT, mobility, other).","Yes","No",null,null,"No",0,{"$f":"IF(I15=\"No\", 0, 0)","v":0},null,null,{"$f":"SUM(I15:L15)","v":0}]
[null,3,"The geographical area in which the project is planned has been defined.","Yes","No",null,null,"No",0,0,null,null,0]
[null,4,"The main goals of the project have been defined.","Yes","No",null,null,"No",0,0,null,null,0]
[null,5,"The main target beneficiaries of the project have been identified.","Yes","No",null,null,"No",0,0,null,null,0]
[null,6,"Political and institutional ownership has been achieved (signed letter of commitment).","Yes","No",null,null,"No",0,0,null,null,0]
[null,7,"Stakeholders to be engaged have been identified.","Yes","Partially","No",null,"No",{"$f":"IF(H20=\"Yes\",1,0)","v":0},{"$f":"IF(I20=\"No\",0,0)","v":0},{"$f":"IF(H20=\"Partially\",0.5,0)","v":0},null,0]
[null,8,"Links to any relevant strategic frameworks have been identified (e.g. SEAP, SECAP, SUMP, or plan of similar ambition).","Yes","No ","Not applicable",null,"No",{"$f":"IF(H21=\"Yes\", 0, 0)","v":0},{"$f":"IF(I21=\"No\", 0, 0)","v":0},{"$f":"IF(J21=\"Not applicable\", 0, 0)","v":0},null,0]
[null,9,"Links to other relevant initiatives/projects have been identified (e.g., Scalable Cities, EUCF, SCC, etc).","Yes","No ","Not applicable",null,"No",{"$f":"IF(H22=\"Yes\", 0, 0)","v":0},{"$f":"IF(I22=\"No\", 0, 0)","v":0},{"$f":"IF(J22=\"Not applicable\", 0, 0)","v":0},null,0]
[null,10,"Capacities and resources to implement the project have been identified.","Yes","Partially","No",null,"No",{"$f":"IF(H23=\"Yes\",1,0)","v":0},{"$f":"IF(I23=\"No\",0,0)","v":0},{"$f":"IF(H23=\"Partially\",0.5,0)","v":0},null,0]
[null,11,"The timeline for the project investment has been defined.","Yes, indicatively","Yes, in detail","No",null,"No",{"$f":"IF(H24=\"Yes, indicatively\", 0.5, 0)","v":0},{"$f":"IF(H24=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H24=\"No\", 0,0)","v":0},null,0]
[null,12,"The technical and space requirements of the selected technology are clear.","Yes","No",null,null,"No",{"$f":"IF(H25=\"Yes\", 1, 0)","v":0},{"$f":"IF(I25=\"No\", 0, 0)","v":0},null,null,0,{"$f":"SUM(M14:M25)","v":0}]
[null,"Based on your responses above, you meet the minimum criteria for PML 3. We will now assess whether you have an even higher PML.\nPlease answer the following questions to the best of your knowledge."]
[]
[null,13,"Investment costs have been estimated.","Yes, indicatively","Yes, in detail","No",null,"No",{"$f":"IF(H28=\"Yes, indicatively\", 0.5, 0)","v":0},{"$f":"IF(H28=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H28=\"No\", 0,0)","v":0},null,0]
[null,14,"Funding sources have been identified (e.g. own funding, other sources).","Yes","Partially","No",null,"No",{"$f":"IF(H29=\"Yes\",1,0)","v":0},{"$f":"IF(I29=\"No\",0,0)","v":0},{"$f":"IF(H29=\"Partially\",0.5,0)","v":0},null,0]
[null,15,"Financing sources have been identified (e.g. loan, equity, debt, grant/subsidies, guarantee, other).","Yes","Partially","No","Not applicable","No",{"$f":"IF(H30=\"Yes\", 1, 0)","v":0},{"$f":"IF(H30=\"Partially\", 0.5,0)","v":0},{"$f":"IF(H30=\"No\", 0,0)","v":0},{"$f":"IF(H30=\"Not applicable\", 0,0)","v":0},0]
[null,16,"Funding sources have been quantified  (e.g. own funding, other sources).","Yes","Partially","No",null,"No",{"$f":"IF(H31=\"Yes\",1,0)","v":0},{"$f":"IF(I31=\"No\",0,0)","v":0},{"$f":"IF(H31=\"Partially\",0.5,0)","v":0},null,0]
[null,17,"Financing sources have been quantified (e.g. loan, equity, debt, grant/subsidies, guarantee, other).","Yes","Partially","No","Not applicable","No",{"$f":"IF(H32=\"Yes\", 1, 0)","v":0},{"$f":"IF(H32=\"Partially\", 0.5,0)","v":0},{"$f":"IF(H32=\"No\", 0,0)","v":0},{"$f":"IF(H32=\"Not applicable\", 0,0)","v":0},0]
[null,18,"Options for business models have been identified (identification of the products or services the business plans to sell, identification of target markets, anticipation of expenses).","Yes, indicatively","Yes, in detail","No",null,"No",{"$f":"IF(H33=\"Yes, indicatively\", 0.5, 0)","v":0},{"$f":"IF(H33=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H33=\"No\", 0,0)","v":0},null,0]
[null,19,"Necessary technical measures have been planned (investments in projects reliant on unabated fossil fuels will not be supported).","Yes","No",null,null,"No",{"$f":"IF(H34=\"Yes\", 1, 0)","v":0},{"$f":"IF(I34=\"No\", 0, 0)","v":0},null,null,0]
[null,20,"Operating costs have been estimated.","Yes, indicatively","Yes, in detail","No",null,"No",{"$f":"IF(H35=\"Yes, indicatively\", 0.5, 0)","v":0},{"$f":"IF(H35=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H35=\"No\", 0,0)","v":0},null,0]
[null,21,"Revenues have been estimated.","Yes, indicatively","Yes, in detail","No","Not applicable","No",{"$f":"IF(H36=\"Yes, indicatively\", 0.5,0)","v":0},{"$f":"IF(H36=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H36=\"No\", 0,0)","v":0},{"$f":"IF(H36=\"Not applicable\", 0,0)","v":0},0]
[null,22,"Economic viability has been defined (e.g., simple payback period; net present value; internal rate of return).","Yes, indicatively","Yes, in detail","No","Not applicable","No",{"$f":"IF(H37=\"Yes, indicatively\", 0.5,0)","v":0},{"$f":"IF(H37=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H37=\"No\", 0,0)","v":0},{"$f":"IF(H37=\"Not applicable\", 0,0)","v":0},0]
[null,23,"The approach for generating profit through the project has been defined.","Yes, indicatively","Yes, in detail","No","Not applicable","No",{"$f":"IF(H38=\"Yes, indicatively\", 0.5,0)","v":0},{"$f":"IF(H38=\"Yes, in detail\", 1, 0)","v":0},{"$f":"IF(H38=\"No\", 0,0)","v":0},{"$f":"IF(H38=\"Not applicable\", 0,0)","v":0},0]
[null,24,"Risks associated to the project have been identified and assessed, and risk response measures have been planned.","Yes","No",null,null,"No",{"$f":"IF(H39=\"Yes\", 1, 0)","v":0},{"$f":"IF(I39=\"No\", 0, 0)","v":0},null,null,0]
[null,25,"The expected impacts have been estimated (e.g. energy savings, renewable energy production, GHG emission reduction, jobs created, etc).","Yes","No",null,null,"Yes",{"$f":"IF(H40=\"Yes\", 1, 0)","v":1},0,null,null,1]
[null,26,"The project’s potential for scalability has been assessed. ","Yes","No",null,null,"No",{"$f":"IF(H41=\"Yes\", 1, 0)","v":0},0,null,null,0]
[null,27,"The project’s potential for replicability has been assessed.","Yes","No",null,null,"No",{"$f":"IF(H42=\"Yes\", 1, 0)","v":0},0,null,null,0]
[]
[]
[null,null,"Based on your answers, we believe your project maturity level is:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M14:M42)","v":1},{"$f":"IF(AND(M45>=0, M45<7), \"PML 1\", IF(AND(M45>=7, M45<9), \"PML 2\", IF(AND(M45>=9, M45<11), \"PML 3\", IF(AND(M45>=11, M45<15.5), \"PML 4\", IF(AND(M45>=15.5, M45<25), \"PML 5\", IF(AND(M45>=25, M45<27), \"PML 6\"))))))","v":"PML 1"}]

{"sheet":"Drop-down values","index":1,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Yes-no list","Yes-partially-no list","Yes-no-not applicable list","Yes indicatively -yes in detail-no list","Yes-partially-no-not applicable list","Yes indicatively-yes in detail-no-not applicable list"]
["Yes","Yes","Yes","Yes, indicatively","Yes","Yes, indicatively"]
["No","Partially","No","Yes, in detail","Partially","Yes, in detail"]
[null,"No","Not applicable","No","No","No"]
[null,null,null,null,"Not applicable","Not applicable"]