{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Read Me Sheet","Tool Sheet","Comments Sheet","Queries Sheet"],"not_rendered":{"charts":2,"images":19,"macros":1,"external_links":0,"defined_names":127,"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":"Read Me Sheet","index":0,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,1,8,8],[9,1,9,8],[39,1,39,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[11,1,11,8],[19,1,19,8],[14,1,14,8],[13,1,13,8],[12,1,12,8],[18,1,18,8],[21,1,21,8],[25,1,25,8],[22,1,22,8],[20,1,20,8],[0,0,0,9],[2,0,2,8],[5,1,5,8],[6,1,6,8],[7,1,7,8],[23,1,23,8],[24,1,24,8],[26,1,26,8],[27,1,27,8],[32,1,32,8],[33,1,33,8],[29,1,29,8],[28,1,28,8],[30,1,30,8],[41,1,41,8],[40,1,40,8],[45,1,45,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[42,1,42,8],[44,0,44,9]]}
["Read Me Sheet"]
[]
["Sustainability Assessment Tool for Mini-grids "]
[]
[]
[null,"Introduction"]
[null,"Sustainability describes the ability of a system to maintain its capacity to deliver a set of functions over a period of time. For Mini-grids, the function is the provision of electricity. The capacity to deliver for a long period of time depends on a complex range of criteria. "]
[null,"This assessment tool is built around a checklist of criteria that are likely to affect the sustainability of Mini-grids ('the queries'). By choosing a set of queries and selecting their signifiance, the user of the tool can evaluate the strengths and weaknesses of one or a set of mini-grids in a given context."]
[null," Project implementers and government officials can hence use the tool to reflect on possible risks that could undermine the sustainability of a Mini-grid. The tool can be used for planning, spot-checks or periodic re-assessments. "]
[null,"One-time use of the tool can help to develop risk minitgation strategies. Through repeated use of the tool, a change in conditions can be detected and responded to. "]
[]
[null,"Overview"]
[null,"After filling out the background information selection, the evaluator selects up to (but not more than) 7 queries in each of the 8 categories of sustainability. Next, the extent to which they are in place must be selected from a drop-down menu, and their significance evaluated. Results will be visualised grahpically at the bottom of the sheet."]
[null,"Step 1. Enter Background Information"]
[null,"The first step consists of filling out the background information of the evaluation. Input such as name of the evaluating organisation, development stage, type of technology or project owner help you and others to navigate through subsequent data entries."]
[null,"Step 2. Select Queries"]
[null,"After familiarising yourself with the 8 categories, you can choose queries for each category by clicking on the \"Select Queries\" button. You can select out of the suggested queries or add your own queries. "]
[null,"Please note: The tool was designed for 7 queries per category. You can choose less, but you cannot choose more. In case you choose fewer than 7 queries, please note that the output visualisation will be affected. "]
[null,"Step 3. Assign Values for 'In Effect' and 'Significance'"]
[null,"The next step is to assign values from the drop-down buttons 'In Effect' and 'Significance'. The response selected corresponds to a set score (in %). "]
[null,"Through 'In Effect' the evaluator selects the level to which a certain query is in place in the given context of the assessment (e.g. yes, the query is fully in place in the area in which the Mini-grid is to be developed). Answer choices for 'In Effect' are:"]
[null,"Yes: the criterion is fully met (100%)\nMostly: the criterion is mostly met (75%)\nPartially: the criterion is partially met (35%)\nNo: the criterion is not met (0%)\nNot known: no information available (0%)\nNot relevant: the criterion does not apply in this instance (100%)"]
[null,"Besides the level to which a query is in place, a significance value must be selected from the drop-down list. (E.g. the query that is fully in place is of high significance for the sustainability of the Mini-grid.) Again, the choice corresponds to a set factor:"]
[null,"Critical: of utmost significance, which, if not fulfilled, seriously undermines sustainability (0,4)\nHigh: of important significance, which, if not fulfilled, poses high risks (0,6)\nNormal: of general significance, which, if not fulfilled, poses a minor risk (0,8)\nLow: of low significance, which, if not fullfilled, does not pose a great overal risk (0,9)\nNot relevant: insignificant, which if not fulfilled, poses no risk at all or is simply not relevant (1,0)"]
[null,"The logic behind the factorisation is as follows: If a particular query is of critical importance, then even if were is in place in a particular Mini-grid context, changes would significantly threaten the likelihood for sustainability of the entire system. Hence, the penalty factorisation flags threats to the overall likelihood for sustainability, even when they appear to be fully, mostly, or partially met. Equally, if a query is not met but of critical significance, the section score in the output will drop to 0."]
[null,"Please note: Since answering the level of fulfilment or significance will depend on a subjective perspective, it is possible to explain the choice via the comment button. Comments will be collected and can be reviewed in the comments sheet."]
[null,"Please also note: The values for both sections can be altered through the fine-tuning section on the right side of tool. When changing list text in the fine tuning and re-calibration tables, best do this BEFORE answering all queries and setting their significance. Changes in text after answering the queries, would require re-answering all queries. "]
[null,"Step 3. Review results"]
[null,"The resulting scores are visualised in form of a spiderweb and bar diagram. "]
[null,"The spiderweb diagram shows the relative and comparative strengths and weaknesses for all categories. Hence the reviewer is able to spot areas which may be more or less likely to impact the sustainability of the system."]
[null,"The bar diagram shows the actual score for each category. "]
[]
[null,"Tips & Tricks"]
[null,"When assessing a collection of several sites, try to cluster sites according to similarities (e.g. compare only Solar PV sites, or only completed sites, or sites located only in a specific location, or sites implemented by a certain project owner). This simplifies choosing a query answer and reduces vagueness. "]
[null,"When choosing \"Not relevant\" for \"Significance\" the score will be 100% regardless of the query answer chosen.  Similarly, query answers \"No\" and \"Not known\" are both scored with 0% (unless of course they are \"Not relevant\"), since not knowing something poses a risk. BE AWARE that, if you choose \"Not relevant\" as your query answer, but give it a significance other than \"Not relevant\", you will score less than 100% (this is to reflect the uncertainty of your answer, because if you say something is irrelevant, but it is still significant, then obviously there is a contradiction)."]
[null,"Query answers specified in the drop-down list are potentially vague. After all, how do we determine \"mostly\" or \"partially\"? Here the assessors prudence and experience is valuable. The tool is primarily qualitative. Choose \"Not known\" if you are uncertain and / or let other evaluators know the reasoning for your choice. "]
[null,"Some queries might be subject to interpretation. Opt for \"Not relevant\" and adjust the significance, rather than get bogged down. Alternatively select another query from the drop-down list or add your own wording. "]
[null,"When setting a significance to \"Critical\" and answering the query with \"No\" or \"Not known\" then the total score for that category will be 0%. Regardless of the score for other queries in that category. This is because \"Critical\" is regarded a killer criteria. Similarly, the higher the significance the lower the score (even if answered with \"Yes\", since a change in circumstance can have a high impact on sustainability prospects)."]
[]
[null,"About"]
[null,"Authors: Robert Schultz, Caspar Priesemann, Malte Jütting"]
[null,"Version: 2.0 (September 2016)"]
[null,"Password (for tool administrator): GIZ-HERA "]
[]
["Download link: https://energypedia.info/wiki/File:GIZ_HERA_Mini-Grid_Sustainability_Assessment_Tool_(MG_SAT).xlsm"]
[null,"Contact: hera@giz.de; caspar.priesemann@giz.de"]

{"sheet":"Tool Sheet","index":1,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,3],[2,6,2,7],[2,8,2,9],[0,0,0,9],[1,0,1,1],[1,2,1,4],[1,7,1,9],[3,0,3,1],[3,2,3,3],[4,2,4,3],[5,0,5,1],[6,0,6,1],[6,2,6,3],[4,0,4,1],[55,11,56,12],[7,0,7,1],[8,0,8,1],[8,2,8,3],[10,11,10,13],[42,11,42,12],[54,11,54,12]]}
["Mini-grid Sustainability Assessment Tool (MG SAT)"]
["Country and location:",null,"Site(s) current status:",null,null,null,"Date of Assessment:"]
["Organisation of Evaluator:",null,"Planning phase",null,null,null,"Technology:",null,"Project owner:"]
["Contact person:",null,"Implementation phase",null,null,null,"Solar PV",null,"Government"]
["Email:",null,"Completed",null,null,null,"Micro-hydro",null,"Community"]
["If individual single site:",null,null,null,null,null,"Wind",null,"Cooperative"]
["Site name",null,null,null,null,null,"Diesel",null,"Utility"]
["If collection of several sites:",null,null,null,null,null,"Hybrid",null,"Private sector"]
["Number of sites",null,null,null,null,null,null,null,"Donor"]
[]
[null,{"$f":"'Queries Sheet'!A4","v":"1. Enabling institutional environment"},"In Effect:","Significance:","Score:",null,{"$f":"'Queries Sheet'!A51","v":"5. Market and economics"},"In Effect:","Significance:","Score:",null,"For fine tuning or re-calibration only"]
[null,null,"Not known","Normal",{"$f":"IF(D12=$L$28,$M$19,VLOOKUP(C12,$L$15:$M$20,2,FALSE)*VLOOKUP(D12,$L$24:$M$28,2,FALSE))","v":0},null,null,"Not known","Normal",{"$f":"IF(I12=$L$28,$M$19,VLOOKUP(H12,$L$15:$M$20,2,FALSE)*VLOOKUP(I12,$L$24:$M$28,2,FALSE))","v":0}]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"to change the text and score allocation"]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"\"Choose\" drop-down list:","Score:","Default:"]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"Yes",1,1]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"Mostly",0.75,0.75]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"Partially",0.35,0.35]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"No",0,0]
[null,{"$f":"'Queries Sheet'!A17","v":"2. Energy resource and environment"},"In Effect:","Significance:","Score:",null,{"$f":"'Queries Sheet'!A64","v":"6. Scheme implementation"},"In Effect:","Significance:","Score:",null,"Not relevant",1,1]
[null,null,"Not known","Normal",{"$f":"IF(D20=$L$28,$M$19,VLOOKUP(C20,$L$15:$M$20,2,FALSE)*VLOOKUP(D20,$L$24:$M$28,2,FALSE))","v":0},null,null,"Not known","Normal",{"$f":"IF(I20=$L$28,$M$19,VLOOKUP(H20,$L$15:$M$20,2,FALSE)*VLOOKUP(I20,$L$24:$M$28,2,FALSE))","v":0},null,"Not known",0,0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"to change the text and factor weight"]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"\"Significance\" drop-down list:","Factor:","Default:"]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"Critical",0.4,0.4]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"High",0.6,0.6]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0,null,"Normal",0.8,0.8]
[null,{"$f":"'Queries Sheet'!A27","v":"3. Implementation and technical planning"},"In Effect:","Significance:","Score:",null,{"$f":"'Queries Sheet'!A76","v":"7. Management, operation and maintenance"},"In Effect:","Significance:","Score:",null,"Low",0.9,0.9]
[null,null,"Not known","Normal",{"$f":"IF(D28=$L$28,$M$19,VLOOKUP(C28,$L$15:$M$20,2,FALSE)*VLOOKUP(D28,$L$24:$M$28,2,FALSE))","v":0},null,null,"Not known","Normal",{"$f":"IF(I28=$L$28,$M$19,VLOOKUP(H28,$L$15:$M$20,2,FALSE)*VLOOKUP(I28,$L$24:$M$28,2,FALSE))","v":0},null,"Not relevant",1,1]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,{"$f":"'Queries Sheet'!A39","v":"4. Client and/or community preparation"},"In Effect:","Significance:","Score:",null,{"$f":"'Queries Sheet'!A88","v":"8. Monitoring and evaluation"},"In Effect:","Significance:","Score:"]
[null,null,"Not known","Normal",{"$f":"IF(D36=$L$28,$M$19,VLOOKUP(C36,$L$15:$M$20,2,FALSE)*VLOOKUP(D36,$L$24:$M$28,2,FALSE))","v":0},null,null,"Not known","Normal",{"$f":"IF(I36=$L$28,$M$19,VLOOKUP(H36,$L$15:$M$20,2,FALSE)*VLOOKUP(I36,$L$24:$M$28,2,FALSE))","v":0}]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,"Not known","Normal",0,null,null,"Not known","Normal",0]
[null,null,null,null,null,null,null,null,null,null,null,"Results overview"]
[null,null,null,null,null,null,null,null,null,null,null,"Final scores with consideration of relevance factor"]
[null,null,null,null,null,null,null,null,null,null,null,"Category:","Score:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$11","v":"1. Enabling institutional environment"},{"$f":"IF(M59>0,0,(AVERAGE(E12:E18)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$19","v":"2. Energy resource and environment"},{"$f":"IF(M60>0,0,(AVERAGE(E20:E26)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$27","v":"3. Implementation and technical planning"},{"$f":"IF(M61>0,0,(AVERAGE(E28:E34)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$35","v":"4. Client and/or community preparation"},{"$f":"IF(M62>0,0,(AVERAGE(E36:E42)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$11","v":"5. Market and economics"},{"$f":"IF(M63>0,0,(AVERAGE(J12:J18)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$19","v":"6. Scheme implementation"},{"$f":"IF(M64>0,0,(AVERAGE(J20:J26)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$27","v":"7. Management, operation and maintenance"},{"$f":"IF(M65>0,0,(AVERAGE(J28:J34)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$35","v":"8. Monitoring and evaluation"},{"$f":"IF(M66>0,0,(AVERAGE(J36:J42)))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Critical instances"]
[null,null,null,null,null,null,null,null,null,null,null,"Number of instances \"No\" and \"Not known\" are chosen as answer for a \"Critical\" query (i.e. killer criteria):"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Category:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$11","v":"1. Enabling institutional environment"},{"$f":"COUNTIFS(D12:D18,\"Critical\",E12:E18,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$19","v":"2. Energy resource and environment"},{"$f":"COUNTIFS(D20:D26,\"Critical\",E20:E26,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$27","v":"3. Implementation and technical planning"},{"$f":"COUNTIFS(D28:D34,\"Critical\",E28:E34,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$35","v":"4. Client and/or community preparation"},{"$f":"COUNTIFS(D36:D42,\"Critical\",E36:E42,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$11","v":"5. Market and economics"},{"$f":"COUNTIFS(I12:I18,\"Critical\",J12:J18,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$19","v":"6. Scheme implementation"},{"$f":"COUNTIFS(I20:I26,\"Critical\",J20:J26,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$27","v":"7. Management, operation and maintenance"},{"$f":"COUNTIFS(I28:I34,\"Critical\",J28:J34,\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$35","v":"8. Monitoring and evaluation"},{"$f":"COUNTIFS(I36:I42,\"Critical\",J36:J42,\"0\")","v":0}]

{"sheet":"Comments Sheet","index":2,"n_rows":78,"n_cols":4,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Comments"]
["This sheet summarises comments by the evaluator to justify her/his query selection, answering choices or provide other information"]
["I) Comments regarding Queries"]
["Query","Comment","Date","User"]
["1. Enabling institutional environment"]
[{"$f":"IF(ISTEXT('Tool Sheet'!B12),'Tool Sheet'!B12,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B13),'Tool Sheet'!B13,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B14),'Tool Sheet'!B14,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B15),'Tool Sheet'!B15,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B16),'Tool Sheet'!B16,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B17),'Tool Sheet'!B17,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B18),'Tool Sheet'!B18,\"\")","v":""}]
[]
["2. Energy resource and environment"]
[{"$f":"IF(ISTEXT('Tool Sheet'!B20),'Tool Sheet'!B20,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B21),'Tool Sheet'!B21,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B22),'Tool Sheet'!B22,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B23),'Tool Sheet'!B23,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B24),'Tool Sheet'!B24,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B25),'Tool Sheet'!B25,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B26),'Tool Sheet'!B26,\"\")","v":""}]
[]
["3. Implementation and technical planning"]
[{"$f":"IF(ISTEXT('Tool Sheet'!B28),'Tool Sheet'!B28,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B29),'Tool Sheet'!B29,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B30),'Tool Sheet'!B30,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B31),'Tool Sheet'!B31,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B32),'Tool Sheet'!B32,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B33),'Tool Sheet'!B33,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B34),'Tool Sheet'!B34,\"\")","v":""}]
[]
["4. Client and/or community preparation"]
[{"$f":"IF(ISTEXT('Tool Sheet'!B36),'Tool Sheet'!B36,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B37),'Tool Sheet'!B37,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B38),'Tool Sheet'!B38,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B39),'Tool Sheet'!B39,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B40),'Tool Sheet'!B40,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B41),'Tool Sheet'!B41,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!B42),'Tool Sheet'!B42,\"\")","v":""}]
[]
["5. Market and economics"]
[{"$f":"IF(ISTEXT('Tool Sheet'!G12),'Tool Sheet'!G12,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G13),'Tool Sheet'!G13,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G14),'Tool Sheet'!G14,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G15),'Tool Sheet'!G15,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G16),'Tool Sheet'!G16,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G17),'Tool Sheet'!G17,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G18),'Tool Sheet'!G18,\"\")","v":""}]
[]
["6. Scheme implementation"]
[{"$f":"IF(ISTEXT('Tool Sheet'!G20),'Tool Sheet'!G20,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G21),'Tool Sheet'!G21,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G22),'Tool Sheet'!G22,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G23),'Tool Sheet'!G23,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G24),'Tool Sheet'!G24,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G25),'Tool Sheet'!G25,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G26),'Tool Sheet'!G26,\"\")","v":""}]
[]
["7. Management, operation and maintenance"]
[{"$f":"IF(ISTEXT('Tool Sheet'!G28),'Tool Sheet'!G28,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G29),'Tool Sheet'!G29,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G30),'Tool Sheet'!G30,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G31),'Tool Sheet'!G31,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G32),'Tool Sheet'!G32,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G33),'Tool Sheet'!G33,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G34),'Tool Sheet'!G34,\"\")","v":""}]
[]
["8. Monitoring and evaluation"]
[{"$f":"IF(ISTEXT('Tool Sheet'!G36),'Tool Sheet'!G36,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G37),'Tool Sheet'!G37,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G38),'Tool Sheet'!G38,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G39),'Tool Sheet'!G39,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G40),'Tool Sheet'!G40,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G41),'Tool Sheet'!G41,\"\")","v":""}]
[{"$f":"IF(ISTEXT('Tool Sheet'!G42),'Tool Sheet'!G42,\"\")","v":""}]
[]
["II) General Comments"]
["Topic","Comment","Date","User"]

{"sheet":"Queries Sheet","index":3,"n_rows":97,"n_cols":1,"rows_kept":97,"cut":false,"hidden":true,"merged":[]}
["List of Queries"]
["                   In preparing for the sustainability assessment, please review the list of queries below. \n                   Identify seven (7) queries for subsequent  analysis (NOTE: exactly 7 queries should be selected for each category)\n                   Please add additional queries to the categories as deemed valuable and relevant\n                   In the sheet \"HERA SAT\" please select your chosen queries from the drop-down list in each category\n"]
[]
["1. Enabling institutional environment"]
["Training and capacity development institutions and resources are available"]
["Ownership of infrastructure is clear and legally concluded"]
["Officially endorsed Rural Electrification Plans are in place, available and up-to-date"]
["Suitable infrastructure location(s) is identified and detailed site data is available"]
["Long-term private sector warranty system or supportive engagement is secure"]
["Development is part of long-term programme (as opposed to once-off short-term \"project\") "]
["Transparent procurement tender processes, with quality-assurance during commissioning, are in place"]
["Clear regulatory guidelines for electricity generation, distribution and sales are available and can be fulfilled"]
["Rural Electrification Plans inclusive of all stakeholders (utility, IPP), all technologies (conventional and alternative) and approaches (grid, off-grid)"]
["Import duties and tax regimes do not pose competitive barriers"]
["Funding mechanisms, investment subsidies or other incentives are available and accessible"]
[]
["2. Energy resource and environment"]
["Energy resources are readily available"]
["Energy resources are not influenced by seasonal variations (e.g. rainfall, sunshine hours, drought, etc.)"]
["Energy resources are not vulnerable to interference from neighbouring communities (e.g. upstream communities)"]
["Energy resources are not vulnerable to other development initiatives and programmes"]
["Disposal of broken parts or spent consumables poses no health or environmental risk"]
["Recycling or scrap vendors for broken components is available within 1 day travel"]
["Environmental awareness and education is included in community sensitisation"]
["Environmental Impact Assessment (EIA) has been conducted and approved"]
[]
["3. Implementation and technical planning"]
["Energy resource access rights are ensured and legally binding (e.g. water usage right, biomass harvesting, etc.)"]
["Land rights are clearly defined, along with agreed accessibility during construction and operation"]
["Detailed technical feasibility study conducted with positive results"]
["Robust, appropriate and accurate technical design"]
["National grid access more than 5 km from site"]
["Modularity (for future upgrade) sufficiently considered in technical design"]
["Technical components selection based on local availability and access to service personnel"]
["Construction logistics are accurately determined and external influences considered (e.g. dry/wet season, mountainous terrain)"]
["Social and environmental impact during construction phase is addressed"]
["Energy efficiency on supply and demand side has been considered"]
[]
["4. Client and/or community preparation"]
["A community-based approach is pursued and implemented by specialist(s)"]
["General sensitisation and awareness raising activities are conducted"]
["Attention to socialisation and integration into prevailing socio-cultural conditions or paradigms is given"]
["Frequent community participation and joint appraisal activities are undertaken"]
["Promotion of productive use initiatives and rural businesses, through energy access, improved appliances and other means"]
["Promotion of social service infrastructure, through energy access, improved appliances and other means"]
["Funds for pre- and post-implementation community development are allocated"]
["Community facilitator active on site for several months"]
["Clients are clearly identified and have expressed interest in being connected"]
["Operations and maintenance personnel are recruited from within the community"]
[]
["5. Market and economics"]
["At least 10% of connected beneficiaries are businesses active in the community"]
["Active businesses include more than 3 different types of business "]
["Medium to large-scale businesses (within the community context) are present and interested in being connected"]
["Businesses tariff is higher than household tariff, but with guaranteed supply (while households will be subject to load shedding)"]
["Accessibility to financial institutions (for bank account) is within 1 day travel"]
["Market survey has been conducted with positive results"]
["Community has the theoretical ability to pay a cost-reflective tariff (as determined through market survey)"]
["Community has demonstrated a willingness to pay a cost-reflective tariff (as determined through active signing up)"]
["Mature and competitive national market for mini-grid technologies is established (for competitive supplier negotiations)"]
["Business plan has been compiled with positive results"]
["Attractive funding has been secured"]
[]
["6. Scheme implementation"]
["Civil construction is sturdy and of good quality as per industry norms and standards"]
["Quality components and materials used with proven track records and supplier warranties"]
["Installation of electro-mechanical equipment adheres to best practices and safety standards"]
["Monitoring and metering equipment is installed"]
["Installation of distribution network and client connections adheres to best practices and safety standards"]
["Overall health and safety criteria are adhered to and protection systems installed"]
["Contractor responsibility and accountability on workmanship quality is enforced"]
["Local community is involved in construction process and fairly remunerated "]
["Local community and/or operating personnel is involved in on-the-job training during construction process"]
["Post-construction clean-up is performed and rehabilitation (filling excavated areas, re-growing vegetation, etc.) done where necessary"]
[]
["7. Management, operation and maintenance"]
["Theoretical and practical training of operators and management team is conducted"]
["System overload warning and protection system installed"]
["Spare parts vendors and technicians identified and available within 1 day travel"]
["Operation and Management Plan has been elaborated and is in place "]
["Management Plan makes distinction between consumptive and productive clients with their own appropriate processes"]
["Motivated and sufficiently skilled management team has been recruited"]
["Record keeping (log books, client books, cash books, etc.) systems and tools are in place and regularly used"]
["Regular meetings, consultations and feed-back sessions with community and/or clients are held"]
["Financial savings are collected for re-investment into infrastructure"]
["Mentor or other mechanism available to support management team and operating personnel for several months"]
[]
["8. Monitoring and evaluation"]
["Query and troubleshooting support system for community is in place"]
["Project owner, developer and/or operator has active monitoring and evaluation programme in place"]
["Monitoring system for technical performance is in place"]
["Monitoring system for administrative and management performance is in place"]
["For key data a data capture, transmission and storage system is in place"]
["Regular review and evaluation of data is conducted and findings summarised and disseminated"]
["Lessons learnt are captured and shared with key decision makers and other interested parties"]
[]
["The queries were extracted from: \nHERA Sustainability factors 2008 (https://energypedia.info/wiki/File:HERA_Sustainability_Factors_2008.pdf)\nHERA Sustainability Assessment 2014 (https://energypedia.info/wiki/File:HERA_Sustainability_Assessment_Framework_2014.pdf), \nEnDev Indonesia Best Practice Guidelines 2011 (https://energypedia.info/wiki/File:Best_Practice_Guideline.pdf),\nEnDev Indonesia Comparative Study 2013 (https://energypedia.info/wiki/File:130724_EnDev2_Impact_on_Sustainability_-_A_Comparative_Study_(EnDev_Indonesia_2013).pdf)."]