{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Results","Recommendations","I - Regulation","II - Resources","III - Compliance Processes","Compl processes list","Definitions","Recom list","Reg list","Res list","Scorecard lists"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Introduction","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,1,12,16],[14,1,37,16]]}
[]
[]
[null,null,null,null,null,"Non-Compliance Risk Assessment Tool (NC-RAT)"]
[]
[]
[null,"INTRODUCTION"]
[null,"Compliance protects national markets from non-compliant products and safeguards benefits from adopted energy efficiency and quality policies. Despite playing a key role in policy implementation, compliance is often overlooked or delayed by the governments, funders and development partners. One reason is that significant efforts and resources are required to design and enforce robust compliance frameworks, but it is challenging to evaluate associated impacts.  There is no clear methodology to estimate the benefits of compliance such as reduced number of non-compliant products on the market to provide a compelling reasoning for the investment in compliance-related initiatives. Testing a large number of products from the market to assess non-compliance rate is also cost prohibitive for many. \n\nRecognizing the challenge that governments face to measure market non-compliance rate and build the case for compliance, CLASP has developed Non-Compliance Risk Assessment Tool (NC-RAT). The Tool serves an initial step for the  policy makers and others to:\n\n        • Assess national compliance processes for product energy efficiency and quality programs, and associated market non-compliance risk\n        • Advance policy compliance and enforcement by identifying specific  gaps, prioritize investment in compliance processes with greatest impact to strengthening them\n        • Build a case for investment in policy compliance and enforcement initiatives\n        • Track progress/improvement of compliance efforts, e.g.  conduct initial assessment to set the benchmark and assess the compliance program regularly, i.e. on annual basis.\n\nNC-RAT is an easy-to-use Tool that is based on qualitative assessment  of  national compliance program and organized under five Indicators: Regulation, Resources, Certification & Registration, Market Surveillance & Enforcement, and Compliance Communication. Each Indicator includes relevant questions for the user to respond to, based on which the Tool calculates scores 1) for each Indicator and 2) a corresponding overall score for market non-compliance risk. The Tool also provides initial recommendations for strengthening compliance program, which are informed by gap assessment based on responses.\n\nThe estimated time for completing this assessment is 30-60 minutes if the user has the necessary information at hand. \n\nFor questions and inquiries on the Tool, suggestions for improvement, sharing country's assessment results, etc. please contact Lina Kelpsaite at lkelpsaite@clasp.ngo. For additional compliance resources, please visit  clasp.ngo. "]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS TO USE NC-RAT TOOL"]
[null,"\nSTEP 1. Visit 'Results' tab to complete initial information such as Country, Assessment Year, Product Energy Source, as well as your Name, Position and Organization. Additionally, respond to two Risk Considerations and Factors questions for more conclusive assessment.\n\nSTEP 2. Next go to Regulation Indicator under I-Regulation tab to start the assessment. Respond to Initial Assessment Question I, which will then prompt you to the next step.  If the country has regulation (or provisions) to implement and enforce product energy efficiency or quality policies or is in process of development, proceed with responding to the questions under this indicator.  Complete the questions under this and other indicators to best of your ability and select the answers that best reflect your compliance program.\nNote, if the country does not have a regulation (or provisions), the Tool is not applicable and prompts you to reference CLASP compliance resources for developing  compliance framework for policy implementation.\n\nSTEP 3.  Go to II-Resources tab to complete questions for Resources Indicator, which include questions on institutional capcaity and collaboration, access to infrastructure and funding. \n\nSTEP 4. Complete the questions for the remaining three Indicators under III-Compliance Processes tab: Certification & Registration, Market Surveillance & Enforcement, and Compliance Communication. For each indicator, complete the Initial Assessment Question and then, if prompted, continue responding to the questions. E.g. if the country does not have conformity assessment (certification and registration processes) in place then there is no benefit in responding the questions related to that indicator. In this case the corresponding indicator score will be 0.0 and you can refer to Recommendations tab for proposed actions to set up the conformity assessment processes.\n\nThis tab also includes a set of questions on Regional Collaboration, which fall under Market Surveillance & Enforcement indicator for the assessment.\n\nNote, that some questions will appear  'non applicable' if they become not relevant based on your previous responses. \n\nSTEP 5.  After answering all available questions under  five Indicators, return to Results tab to see assessment results. Indicator table provides individual scores for each Indicator which varies between 0.0 (min) -1.0 (max). Responses under each question have assigned scores, the sum of which is the Indicator score (normalized). The maximum score corresponds to the policy compliance best practices for minimizing number of non-compliance products on the market. For reference, the individual indicator scores are also listed under tabs with assessment questions. \nThe coloring of the cells with individual indicator scores corresponds to the scores with red corresponding to poorer compliance performance as compared to yellow  - adequate performance and green - compliance program performance is satisfactory. Assessment of Compliance Program chart (spider chart) provides a visual representation of the indicators' scores. The Assessment of the Resources chart show where the compliance program is in terms of needed resources.\n\nThe overall market non-compliance risk score varies between 0 (min) -100 (max) with the same corresponding cell colors. The overall score is calculated based on the assigned weights for each indicator and the indicator scores. The scale of 100 is used rather than 1.0 for the overall score for better visual representation. Note, that overall score does NOT indicate non-compliance level of the product market but rather the market risk of non-compliance based on the exising compliance processes.\n\nSTEP 6. If assessment scores for individual Indicators are below 1.0, refer to the Recommendations tab to review the proposed Recommendations on improving compliance program. The Tool provides two types of recommendations: 1) key recommendations for a particular aspect of the programs that has a major gap as identified by this Tool, and 2) secondary recommendations for the program aspects which can benefit from further improvement. Recommendations include proposed action, estimated level of effort and stakeholders, who can support the implementation of recommendation. If you are seeking for more detailed recommendations, please contact CLASP or refer to CLASP's compliance resources on clasp.ngo.\n\nThe Results and Recommendations tabs are set up for printing.\n\n As this Tool is a downloadable spreadsheet, the results of this assessment are only visible to you. You are welcome to share the results with CLASP compliance team, which we will keep confidential. We would be happy to  assist you in clarifying the recommendations and answering your questions  -  see contact information above.  "]

{"sheet":"Results","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[16,5,17,7],[18,5,18,7],[0,10,1,12],[0,0,1,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[9,1,9,2],[10,1,10,2]]}
["MARKET NON-COMPLIANCE RISK ASSESSMENT RESULTS "]
[]
[]
[null,"Country (select)",null,null,null,"Name (write in):"]
[null,"Assessment Year (select)",null,null,null,"Role (write in):"]
[null,"Product Energy Source (select)",null,null,null,"Organization (write in):"]
[null,null,null,null,null,"Date (write in):"]
[]
[null,"Risk Considerations and Factors"]
[null,"Are you aware of known incidents of high non-compliance in country's product market (e.g. due to smuggling, lack of enforcement, etc.)?"]
[null,"Are regulated products primarily imported, locally manufactured or both?"]
[]
[]
[null,"Indicator","Indicator Score (out of 1)"]
[null,"Regulation",{"$f":"'I - Regulation'!D2","v":0},null,"Overall score (out of 100)",{"$f":"SUM(L20:L25)","v":0}]
[null,"Resources ",{"$f":"'II - Resources'!D2","v":0},null,"Evaluation: ",{"$f":"IF((F15=0),\"Not available\",IF((F15<=15),\"EXTREMELY HIGH NON-COMPLIANCE RISK\",IF((F15<=40),\"HIGH NON-COMPLIANCE RISK\",IF((F15<=70),\"MEDIUM NON-COMPLIANCE RISK\",IF((F15<=90),\"LOW NON-COMPLIANCE RISK\",IF((F15<=100),\"MINIMAL NON-COMPLIANCE RISK\",\"N/A\"))))))","v":"Not available"}]
[null,"Processes - Conformity Assessment",{"$f":"'III - Compliance Processes'!D6","v":0},null,"Explanation: ",{"$f":"IF(F16=\"MINIMAL NON-COMPLIANCE RISK\",'Scorecard lists'!F7,IF(F16=\"LOW NON-COMPLIANCE RISK\",'Scorecard lists'!F6,IF(F16=\"MEDIUM NON-COMPLIANCE RISK\",'Scorecard lists'!F5,IF(F16=\"HIGH NON-COMPLIANCE RISK\",'Scorecard lists'!F4,IF(F16=\"EXTREMELY HIGH NON-COMPLIANCE RISK\",'Scorecard lists'!F3,IF(F16=\"Not Available\",\"Not Available\",\"Not Available\"))))))","v":"Not Available"}]
[null,"Processes - Market Surveillance & Enforcement",{"$f":"'III - Compliance Processes'!D7","v":0}]
[null,"Compliance Communication",{"$f":"'III - Compliance Processes'!D8","v":0},null,"Additional consideration:",{"$f":"IF(Results!D10=\"Yes\", \"The non-compliance risk may be higher due to known non-compliance incidents.\", \" \")","v":" "},null,null,null,null,"Indicator","Weighted Score","Adjusted Score","Max Score"]
[null,null,null,null,"Next:","refer to Recommendations tab for proposed actions to improve national compliance program",null,null,null,null,{"$f":"B15","v":"Regulation"},{"$f":"C15*M20","v":0},{"$f":"N20","v":25},25]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B16","v":"Resources "},{"$f":"C16*M21","v":0},{"$f":"N21","v":25},25]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B17","v":"Processes - Conformity Assessment"},{"$f":"C17*M22","v":0},{"$f":"IF(D11='Scorecard lists'!G3, N22+2, IF(Results!D11='Scorecard lists'!G5,N22-2,N22))","v":20},20]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B18","v":"Processes - Market Surveillance & Enforcement"},{"$f":"C18*M23","v":0},{"$f":"IF(D11='Scorecard lists'!G3, N23-2, IF(Results!D11='Scorecard lists'!G5,N23+2,N23))","v":20},20]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B19","v":"Compliance Communication"},{"$f":"C19*M24","v":0},{"$f":"N24","v":10},10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please direct your questions, comments and suggestions for improvement to Lina Kelpsaite at lkelpsaite@clasp.ngo."]

{"sheet":"Recommendations","index":2,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["RECOMMENDATIONS"]
[" Provided here are recommendations for improving compliance program to minimize country's market risk of non-compliance. These recommedations are informed by the assessment results in this Tool and  are organized by compliance indicators and sub-indicators. The recommended actions are categorised by the priority level:\n   - Key Priority recommendations are provided for the sub-indicators that  require significant improvement. This corresponds to a gap of above 40% from the max possible sub-indicator score.\n   - Secondary Priority recommendations  are provided for sub-indicators under which program performs quite well but additional improvements can be made. This corresponds to a gap of under 40% as compared to max sub-indicator score.\n\nThe areas that perform as per compliance best practices indicated in this assessment, there is No improvement to be made.\n\nUse drop-down menu below to select Priority level. The recommended actions for improving and strengthening compliance program, level of effort, suggested stakeholders are displayed in the table below.  Please contact CLASP compliance team at lkelpsaite@clasp.ngo if you have questions about recommendations or are interested in support for compliance program.",null,null,null,null,null,null,null,null,"Indicator","Evaluation  Score","Max score","Gap","Needs improvement"]
[null,null,null,null,null,null,null,null,null,"Regulation",{"$f":"Results!C15","v":0},1,{"$f":"(L3-K3)/L3","v":1},{"$f":"VLOOKUP(O6, J10:N12,5)","v":"Key Priority"}]
[null,"Priority Level  (select)",null,null,null,null,null,null,null,"Resources",{"$f":"Results!C16","v":0},{"$f":"SUM(L13:L18)","v":1},{"$f":"(L4-K4)/L4","v":1},{"$f":"VLOOKUP(O6, J13:N18,5)","v":"Key Priority"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'III - Compliance Processes'!A18","v":"Processes - Certification & Registration"},{"$f":"Results!C17","v":0},{"$f":"SUM(L19:L20)","v":1},{"$f":"(L5-K5)/L5","v":1},{"$f":"VLOOKUP(O6, J19:N20,5)","v":"Key Priority"},"No Improvement"]
[null,null,null,null,null,null,null,null,null,{"$f":"Results!B18","v":"Processes - Market Surveillance & Enforcement"},{"$f":"Results!C18","v":0},{"$f":"SUM(L21:L24)","v":1},{"$f":"(L6-K6)/L6","v":1},{"$f":"VLOOKUP(O6, J21:N24,5)","v":"Key Priority"},"Secondary Priority"]
[null,"Key Improvement Areas",null,null,null,null,null,null,null,{"$f":"Results!B19","v":"Compliance Communication"},{"$f":"Results!C19","v":0},{"$f":"SUM(L25:L26)","v":1},{"$f":"(L7-K7)/L7","v":1},{"$f":"VLOOKUP(O6, J25:N26,5)","v":"Key Priority"},"Not Priority"]
[null,"Indicator","Sub-Indicator","Recommendation ","Level of Effort","Who?"]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A1)), COLUMNS($A$3:A3)), \" \")","v":"Regulation"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B1)), COLUMNS($A$3:B3)),\" \")","v":"Regulations - Key Provisions"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G1)), COLUMNS($A$3:G3)),\" \")","v":"Adopt or revise the existing regulation with critical provisions such as roles and responsibilities, offences and penalties, which is foundational to effective policy compliance. "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H1)), COLUMNS($A$1:H1)),\" \")","v":"Low"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I1)), COLUMNS($A$1:I1)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance "},null,null,"Indicator","Indicator - area","Evaluation  Score","Max score","Gap","Needs improvement","Recomendation - Key Priority","Level of Effort - Key Priority","Who? -  Key priority"]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A2)), COLUMNS($A$3:A4)), \" \")","v":"Regulation"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B2)), COLUMNS($A$3:B4)),\" \")","v":"Regulations - Additional Provisions"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G2)), COLUMNS($A$3:G4)),\" \")","v":"Adopt or revise the existing regulation with additional provisions for product ceritfication and registration and market surveillance powers, which are essential for effectively setting up  policy compliance processes. "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H2)), COLUMNS($A$1:H2)),\" \")","v":"Low"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I2)), COLUMNS($A$1:I2)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance "},null,null,{"$f":"$J$3","v":"Regulation"},{"$f":"'I - Regulation'!A13","v":"Regulations - Key Provisions"},{"$f":"'I - Regulation'!H29","v":0},{"$f":"'I - Regulation'!I29","v":0.61538461538461542},{"$f":"(L10-K10)/L10","v":1},{"$f":"IF(M10=0,'Recom list'!C3, IF(M10<0.4,'Recom list'!C2, IF(M10>=0.4,'Recom list'!C1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N10='Recom list'!$C$1,'Recom list'!C6, (IF(Recommendations!N10='Recom list'!$C$2,'Recom list'!F6, (IF(Recommendations!N10='Recom list'!$C$3, \"None\")))))","v":"Adopt or revise the existing regulation with critical provisions such as roles and responsibilities, offences and penalties, which is foundational to effective policy compliance. "},{"$f":"IF(N10='Recom list'!$C$1,'Recom list'!D6, (IF(Recommendations!N10='Recom list'!$C$2,'Recom list'!G6, (IF(Recommendations!N10='Recom list'!$C$3, \"None\")))))","v":"Low"},{"$f":"IF(N10='Recom list'!$C$1,'Recom list'!E6, (IF(Recommendations!N10='Recom list'!$C$2,'Recom list'!H6, (IF(Recommendations!N10='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A3)), COLUMNS($A$3:A4)), \" \")","v":"Regulation"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B3)), COLUMNS($A$3:B4)),\" \")","v":"Other - Administrative Guidelines"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G3)), COLUMNS($A$3:G4)),\" \")","v":"Develop administrative guidance to complement the regulation that outlines in detail compliance processes and requirements."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H3)), COLUMNS($A$1:H3)),\" \")","v":"Medium "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I3)), COLUMNS($A$1:I3)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance "},null,null,{"$f":"$J$3","v":"Regulation"},{"$f":"'I - Regulation'!A18","v":"Regulations - Additional Provisions"},{"$f":"'I - Regulation'!H30","v":0},{"$f":"'I - Regulation'!I30","v":0.30769230769230771},{"$f":"(L11-K11)/L11","v":1},{"$f":"IF(M11=0,'Recom list'!$C$3, IF(M11<0.4,'Recom list'!$C$2, IF(M11>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N11='Recom list'!$C$1,'Recom list'!C7, (IF(Recommendations!N11='Recom list'!$C$2,'Recom list'!F7, (IF(Recommendations!N11='Recom list'!$C$3, \"None\")))))","v":"Adopt or revise the existing regulation with additional provisions for product ceritfication and registration and market surveillance powers, which are essential for effectively setting up  policy compliance processes. "},{"$f":"IF(N11='Recom list'!$C$1,'Recom list'!D7, (IF(Recommendations!N11='Recom list'!$C$2,'Recom list'!G7, (IF(Recommendations!N11='Recom list'!$C$3, \"None\")))))","v":"Low"},{"$f":"IF(N11='Recom list'!$C$1,'Recom list'!E7, (IF(Recommendations!N11='Recom list'!$C$2,'Recom list'!H7, (IF(Recommendations!N11='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A4)), COLUMNS($A$3:A5)), \" \")","v":"Resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B4)), COLUMNS($A$3:B5)),\" \")","v":"Institutional Collaboration"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G4)), COLUMNS($A$3:G5)),\" \")","v":"Identify Regulator, assign responsibilities and establish institutional collaboration with key agencies (e.g. customs) reponsible for policy enforcement before setting up compliance processes."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H4)), COLUMNS($A$1:H4)),\" \")","v":"Low"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I4)), COLUMNS($A$1:I4)),\" \")","v":" - Relevant government agency(-ies)"},null,null,{"$f":"$J$3","v":"Regulation"},{"$f":"'I - Regulation'!A23","v":"Other - Administrative Guidelines"},{"$f":"'I - Regulation'!H31","v":0},{"$f":"'I - Regulation'!I31","v":7.6923076923076927E-2},1,{"$f":"IF(M12=0,'Recom list'!$C$3, IF(M12<0.4,'Recom list'!$C$2, IF(M12>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N12='Recom list'!$C$1,'Recom list'!C8, (IF(Recommendations!N12='Recom list'!$C$2,'Recom list'!F8, (IF(Recommendations!N12='Recom list'!$C$3, \"None\")))))","v":"Develop administrative guidance to complement the regulation that outlines in detail compliance processes and requirements."},{"$f":"IF(N12='Recom list'!$C$1,'Recom list'!D8, (IF(Recommendations!N12='Recom list'!$C$2,'Recom list'!G8, (IF(Recommendations!N12='Recom list'!$C$3, \"None\")))))","v":"Medium "},{"$f":"IF(N12='Recom list'!$C$1,'Recom list'!E8, (IF(Recommendations!N12='Recom list'!$C$2,'Recom list'!H8, (IF(Recommendations!N12='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A5)), COLUMNS($A$3:A6)), \" \")","v":"Resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B5)), COLUMNS($A$3:B6)),\" \")","v":"Human Capital"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G5)), COLUMNS($A$3:G6)),\" \")","v":"Ensure sufficient staffing with adequate training and knowledge to implement compliance processes."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H5)), COLUMNS($A$1:H5)),\" \")","v":"Medium "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I5)), COLUMNS($A$1:I5)),\" \")","v":" - Internal resources\n - Knowledge sharing opportunities, trainings\n - Expert technical assistance "},null,null,{"$f":"$J$4","v":"Resources"},"Institutional Collaboration",{"$f":"'II - Resources'!H37","v":0},{"$f":"'II - Resources'!I37","v":0.3125},1,{"$f":"IF(M13=0,'Recom list'!$C$3, IF(M13<0.4,'Recom list'!$C$2, IF(M13>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N13='Recom list'!$C$1,'Recom list'!C9, (IF(Recommendations!N13='Recom list'!$C$2,'Recom list'!F9, (IF(Recommendations!N13='Recom list'!$C$3, \"None\")))))","v":"Identify Regulator, assign responsibilities and establish institutional collaboration with key agencies (e.g. customs) reponsible for policy enforcement before setting up compliance processes."},{"$f":"IF(N13='Recom list'!$C$1,'Recom list'!D9, (IF(Recommendations!N13='Recom list'!$C$2,'Recom list'!G9, (IF(Recommendations!N13='Recom list'!$C$3, \"None\")))))","v":"Low"},{"$f":"IF(N13='Recom list'!$C$1,'Recom list'!E9, (IF(Recommendations!N13='Recom list'!$C$2,'Recom list'!H9, (IF(Recommendations!N13='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)"}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A6)), COLUMNS($A$3:A7)), \" \")","v":"Resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B6)), COLUMNS($A$3:B7)),\" \")","v":"Product Registration System"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G6)), COLUMNS($A$3:G7)),\" \")","v":"Invest in product registration system - a tool to record  information on all registered products available on the market. "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H6)), COLUMNS($A$1:H6)),\" \")","v":"High"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I6)), COLUMNS($A$1:I6)),\" \")","v":"  - Expert technical assistance\n -  Software developer "},null,null,"Resources","Human Capital",{"$f":"'II - Resources'!H38","v":0},{"$f":"'II - Resources'!I38","v":0.125},1,{"$f":"IF(M14=0,'Recom list'!$C$3, IF(M14<0.4,'Recom list'!$C$2, IF(M14>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N14='Recom list'!$C$1,'Recom list'!C10, (IF(Recommendations!N14='Recom list'!$C$2,'Recom list'!F10, (IF(Recommendations!N14='Recom list'!$C$3, \"None\")))))","v":"Ensure sufficient staffing with adequate training and knowledge to implement compliance processes."},{"$f":"IF(N14='Recom list'!$C$1,'Recom list'!D10, (IF(Recommendations!N14='Recom list'!$C$2,'Recom list'!G10, (IF(Recommendations!N14='Recom list'!$C$3, \"None\")))))","v":"Medium "},{"$f":"IF(N14='Recom list'!$C$1,'Recom list'!E10, (IF(Recommendations!N14='Recom list'!$C$2,'Recom list'!H10, (IF(Recommendations!N14='Recom list'!$C$3, \"None\")))))","v":" - Internal resources\n - Knowledge sharing opportunities, trainings\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A7)), COLUMNS($A$3:A8)), \" \")","v":"Resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B7)), COLUMNS($A$3:B8)),\" \")","v":"Access to testing"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G7)), COLUMNS($A$3:G8)),\" \")","v":"Identify existing independent testing facilities in country/region/outside region for testing products. Alternatively, when financially viable, build national testing lab."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H7)), COLUMNS($A$1:H7)),\" \")","v":"Low/High"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I7)), COLUMNS($A$1:I7)),\" \")","v":" -  Lab equipment provider and expert technical assistance (establishing Lab)"},null,null,"Resources","Product Registration System",{"$f":"'II - Resources'!H39","v":0},{"$f":"'II - Resources'!I39","v":0.1875},1,{"$f":"IF(M15=0,'Recom list'!$C$3, IF(M15<0.4,'Recom list'!$C$2, IF(M15>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N15='Recom list'!$C$1,'Recom list'!C11, (IF(Recommendations!N15='Recom list'!$C$2,'Recom list'!F11, (IF(Recommendations!N15='Recom list'!$C$3, \"None\")))))","v":"Invest in product registration system - a tool to record  information on all registered products available on the market. "},{"$f":"IF(N15='Recom list'!$C$1,'Recom list'!D11, (IF(Recommendations!N15='Recom list'!$C$2,'Recom list'!G11, (IF(Recommendations!N15='Recom list'!$C$3, \"None\")))))","v":"High"},{"$f":"IF(N15='Recom list'!$C$1,'Recom list'!E11, (IF(Recommendations!N15='Recom list'!$C$2,'Recom list'!H11, (IF(Recommendations!N15='Recom list'!$C$3, \"None\")))))","v":"  - Expert technical assistance\n -  Software developer "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A8)), COLUMNS($A$3:A9)), \" \")","v":"Resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B8)), COLUMNS($A$3:B9)),\" \")","v":"Other resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G8)), COLUMNS($A$3:G9)),\" \")","v":"Assess what tools and other resources are needed for effective compliance enforcement,  secure funding for and obtain the needed tools and resources."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H8)), COLUMNS($A$1:H8)),\" \")","v":"Medium/High"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I8)), COLUMNS($A$1:I8)),\" \")","v":" - "},null,null,"Resources","Access to testing",{"$f":"'II - Resources'!H40","v":0},{"$f":"'II - Resources'!I40","v":0.125},1,{"$f":"IF(M16=0,'Recom list'!$C$3, IF(M16<0.4,'Recom list'!$C$2, IF(M16>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N16='Recom list'!$C$1,'Recom list'!C12, (IF(Recommendations!N16='Recom list'!$C$2,'Recom list'!F12, (IF(Recommendations!N16='Recom list'!$C$3, \"None\")))))","v":"Identify existing independent testing facilities in country/region/outside region for testing products. Alternatively, when financially viable, build national testing lab."},{"$f":"IF(N16='Recom list'!$C$1,'Recom list'!D12, (IF(Recommendations!N16='Recom list'!$C$2,'Recom list'!G12, (IF(Recommendations!N16='Recom list'!$C$3, \"None\")))))","v":"Low/High"},{"$f":"IF(N16='Recom list'!$C$1,'Recom list'!E12, (IF(Recommendations!N16='Recom list'!$C$2,'Recom list'!H12, (IF(Recommendations!N16='Recom list'!$C$3, \"None\")))))","v":" -  Lab equipment provider and expert technical assistance (establishing Lab)"}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A9)), COLUMNS($A$3:A10)), \" \")","v":"Resources"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B9)), COLUMNS($A$3:B10)),\" \")","v":"Budget/Funding"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G9)), COLUMNS($A$3:G10)),\" \")","v":"Secure sustainable funding that is appropriate for country's policy compliance enforcement."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H9)), COLUMNS($A$1:H9)),\" \")","v":" - "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I9)), COLUMNS($A$1:I9)),\" \")","v":" - "},null,null,"Resources","Other resources",{"$f":"'II - Resources'!H41","v":0},{"$f":"'II - Resources'!I41","v":6.25E-2},1,{"$f":"IF(M17=0,'Recom list'!$C$3, IF(M17<0.4,'Recom list'!$C$2, IF(M17>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N17='Recom list'!$C$1,'Recom list'!C13, (IF(Recommendations!N17='Recom list'!$C$2,'Recom list'!F13, (IF(Recommendations!N17='Recom list'!$C$3, \"None\")))))","v":"Assess what tools and other resources are needed for effective compliance enforcement,  secure funding for and obtain the needed tools and resources."},{"$f":"IF(N17='Recom list'!$C$1,'Recom list'!D13, (IF(Recommendations!N17='Recom list'!$C$2,'Recom list'!G13, (IF(Recommendations!N17='Recom list'!$C$3, \"None\")))))","v":"Medium/High"},{"$f":"IF(N17='Recom list'!$C$1,'Recom list'!E13, (IF(Recommendations!N17='Recom list'!$C$2,'Recom list'!H13, (IF(Recommendations!N17='Recom list'!$C$3, \"None\")))))","v":" - "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A10)), COLUMNS($A$3:A11)), \" \")","v":"Processes - Certification & Registration"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B10)), COLUMNS($A$3:B11)),\" \")","v":"Product certification and registration"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G10)), COLUMNS($A$3:G11)),\" \")","v":"Set up certification and regsitration processes that minimize the non-compliant products entering the country including accepting test reports only from independent accredited labs and certified by independent certification bodies/government agencies. "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H10)), COLUMNS($A$1:H10)),\" \")","v":"Medium/High"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I10)), COLUMNS($A$1:I10)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance "},null,null,"Resources",{"$f":"'II - Resources'!A18","v":"Budget/Funding"},{"$f":"'II - Resources'!H42","v":0},{"$f":"'II - Resources'!I42","v":0.1875},1,{"$f":"IF(M18=0,'Recom list'!$C$3, IF(M18<0.4,'Recom list'!$C$2, IF(M18>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N18='Recom list'!$C$1,'Recom list'!C14, (IF(Recommendations!N18='Recom list'!$C$2,'Recom list'!F14, (IF(Recommendations!N18='Recom list'!$C$3, \"None\")))))","v":"Secure sustainable funding that is appropriate for country's policy compliance enforcement."},{"$f":"IF(N18='Recom list'!$C$1,'Recom list'!D14, (IF(Recommendations!N18='Recom list'!$C$2,'Recom list'!G14, (IF(Recommendations!N18='Recom list'!$C$3, \"None\")))))","v":" - "},{"$f":"IF(N18='Recom list'!$C$1,'Recom list'!E14, (IF(Recommendations!N18='Recom list'!$C$2,'Recom list'!H14, (IF(Recommendations!N18='Recom list'!$C$3, \"None\")))))","v":" - "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A11)), COLUMNS($A$3:A12)), \" \")","v":"Processes - Certification & Registration"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B11)), COLUMNS($A$3:B12)),\" \")","v":"Customs check"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G11)), COLUMNS($A$3:G12)),\" \")","v":"Set up collaboration mechanism with Customs (or equivalent) to check product compliance at the port of entry to prevent non-compliant products from entering the country."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H11)), COLUMNS($A$1:H11)),\" \")","v":"Medium"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I11)), COLUMNS($A$1:I11)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance "},null,null,{"$f":"$J$5","v":"Processes - Certification & Registration"},{"$f":"'III - Compliance Processes'!E82","v":"Product certification and registration"},{"$f":"'III - Compliance Processes'!H82","v":0},{"$f":"'III - Compliance Processes'!I82","v":0.63636363636363635},1,{"$f":"IF(M19=0,'Recom list'!$C$3, IF(M19<0.4,'Recom list'!$C$2, IF(M19>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N19='Recom list'!$C$1,'Recom list'!C15, (IF(Recommendations!N19='Recom list'!$C$2,'Recom list'!F15, (IF(Recommendations!N19='Recom list'!$C$3, \"None\")))))","v":"Set up certification and regsitration processes that minimize the non-compliant products entering the country including accepting test reports only from independent accredited labs and certified by independent certification bodies/government agencies. "},{"$f":"IF(N19='Recom list'!$C$1,'Recom list'!D15, (IF(Recommendations!N19='Recom list'!$C$2,'Recom list'!G15, (IF(Recommendations!N19='Recom list'!$C$3, \"None\")))))","v":"Medium/High"},{"$f":"IF(N19='Recom list'!$C$1,'Recom list'!E15, (IF(Recommendations!N19='Recom list'!$C$2,'Recom list'!H15, (IF(Recommendations!N19='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A12)), COLUMNS($A$3:A13)), \" \")","v":"Processes - Market Surveillance & Enforcement"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B12)), COLUMNS($A$3:B13)),\" \")","v":"Market inspections"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G12)), COLUMNS($A$3:G13)),\" \")","v":"Develop plan for surveilling product market. Select budget- and market-appropriate  monitoring activities to effectively identify suspicious and  non-compliant products."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H12)), COLUMNS($A$1:H12)),\" \")","v":"Medium/High"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I12)), COLUMNS($A$1:I12)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance "},null,null,{"$f":"$J$5","v":"Processes - Certification & Registration"},{"$f":"'III - Compliance Processes'!E83","v":"Customs check"},{"$f":"'III - Compliance Processes'!H83","v":0},{"$f":"'III - Compliance Processes'!I83","v":0.36363636363636365},1,{"$f":"IF(M20=0,'Recom list'!$C$3, IF(M20<0.4,'Recom list'!$C$2, IF(M20>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N20='Recom list'!$C$1,'Recom list'!C16, (IF(Recommendations!N20='Recom list'!$C$2,'Recom list'!F16, (IF(Recommendations!N20='Recom list'!$C$3, \"None\")))))","v":"Set up collaboration mechanism with Customs (or equivalent) to check product compliance at the port of entry to prevent non-compliant products from entering the country."},{"$f":"IF(N20='Recom list'!$C$1,'Recom list'!D16, (IF(Recommendations!N20='Recom list'!$C$2,'Recom list'!G16, (IF(Recommendations!N20='Recom list'!$C$3, \"None\")))))","v":"Medium"},{"$f":"IF(N20='Recom list'!$C$1,'Recom list'!E16, (IF(Recommendations!N20='Recom list'!$C$2,'Recom list'!H16, (IF(Recommendations!N20='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A13)), COLUMNS($A$3:A14)), \" \")","v":"Processes - Market Surveillance & Enforcement"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B13)), COLUMNS($A$3:B14)),\" \")","v":"Verification testing"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G13)), COLUMNS($A$3:G14)),\" \")","v":"Budget permitted, conduct verification testing as per best practices (e.g. target the high-risk products) to ensure the accuracy and reliability of testing results. If the in-coutry test lab is not available, seek out to outsource testing to test labs outside the country."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H13)), COLUMNS($A$1:H13)),\" \")","v":"Medium/High"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I13)), COLUMNS($A$1:I13)),\" \")","v":" - Relevant government agency(-ies)"},null,null,{"$f":"$J$6","v":"Processes - Market Surveillance & Enforcement"},{"$f":"'III - Compliance Processes'!E85","v":"Market inspections"},{"$f":"'III - Compliance Processes'!H85","v":0},{"$f":"'III - Compliance Processes'!I85","v":0.5},1,{"$f":"IF(M21=0,'Recom list'!$C$3, IF(M21<0.4,'Recom list'!$C$2, IF(M21>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N21='Recom list'!$C$1,'Recom list'!C17, (IF(Recommendations!N21='Recom list'!$C$2,'Recom list'!F17, (IF(Recommendations!N21='Recom list'!$C$3, \"None\")))))","v":"Develop plan for surveilling product market. Select budget- and market-appropriate  monitoring activities to effectively identify suspicious and  non-compliant products."},{"$f":"IF(N21='Recom list'!$C$1,'Recom list'!D17, (IF(Recommendations!N21='Recom list'!$C$2,'Recom list'!G17, (IF(Recommendations!N21='Recom list'!$C$3, \"None\")))))","v":"Medium/High"},{"$f":"IF(N21='Recom list'!$C$1,'Recom list'!E17, (IF(Recommendations!N21='Recom list'!$C$2,'Recom list'!H17, (IF(Recommendations!N21='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance "}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A14)), COLUMNS($A$3:A15)), \" \")","v":"Processes - Market Surveillance & Enforcement"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B14)), COLUMNS($A$3:B15)),\" \")","v":"Record keeping"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G14)), COLUMNS($A$3:G15)),\" \")","v":"Set up procedures to record and keep the records from market surveillance activities, and utilize them to inform enforcement actions and future market surveillance."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H14)), COLUMNS($A$1:H14)),\" \")","v":"Low"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I14)), COLUMNS($A$1:I14)),\" \")","v":" - Relevant government agency(-ies)"},null,null,{"$f":"$J$6","v":"Processes - Market Surveillance & Enforcement"},{"$f":"'III - Compliance Processes'!E86","v":"Verification testing"},{"$f":"'III - Compliance Processes'!H86","v":0},{"$f":"'III - Compliance Processes'!I86","v":0.1875},1,{"$f":"IF(M22=0,'Recom list'!$C$3, IF(M22<0.4,'Recom list'!$C$2, IF(M22>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N22='Recom list'!$C$1,'Recom list'!C18, (IF(Recommendations!N22='Recom list'!$C$2,'Recom list'!F18, (IF(Recommendations!N22='Recom list'!$C$3, \"None\")))))","v":"Budget permitted, conduct verification testing as per best practices (e.g. target the high-risk products) to ensure the accuracy and reliability of testing results. If the in-coutry test lab is not available, seek out to outsource testing to test labs outside the country."},{"$f":"IF(N22='Recom list'!$C$1,'Recom list'!D18, (IF(Recommendations!N22='Recom list'!$C$2,'Recom list'!G18, (IF(Recommendations!N22='Recom list'!$C$3, \"None\")))))","v":"Medium/High"},{"$f":"IF(N22='Recom list'!$C$1,'Recom list'!E18, (IF(Recommendations!N22='Recom list'!$C$2,'Recom list'!H18, (IF(Recommendations!N22='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)"}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A15)), COLUMNS($A$3:A16)), \" \")","v":"Processes - Market Surveillance & Enforcement"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B15)), COLUMNS($A$3:B16)),\" \")","v":"Enforcement"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G15)), COLUMNS($A$3:G16)),\" \")","v":"Set up procedures and processes for taking appropriate and proportionate enforcement actions to rectify non-compliance."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H15)), COLUMNS($A$1:H15)),\" \")","v":"Low"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I15)), COLUMNS($A$1:I15)),\" \")","v":" - Relevant government agency(-ies)"},null,null,{"$f":"$J$6","v":"Processes - Market Surveillance & Enforcement"},{"$f":"'III - Compliance Processes'!E87","v":"Record keeping"},{"$f":"'III - Compliance Processes'!H87","v":0},{"$f":"'III - Compliance Processes'!I87","v":6.25E-2},1,{"$f":"IF(M23=0,'Recom list'!$C$3, IF(M23<0.4,'Recom list'!$C$2, IF(M23>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N23='Recom list'!$C$1,'Recom list'!C19, (IF(Recommendations!N23='Recom list'!$C$2,'Recom list'!F19, (IF(Recommendations!N23='Recom list'!$C$3, \"None\")))))","v":"Set up procedures to record and keep the records from market surveillance activities, and utilize them to inform enforcement actions and future market surveillance."},{"$f":"IF(N23='Recom list'!$C$1,'Recom list'!D19, (IF(Recommendations!N23='Recom list'!$C$2,'Recom list'!G19, (IF(Recommendations!N23='Recom list'!$C$3, \"None\")))))","v":"Low"},{"$f":"IF(N23='Recom list'!$C$1,'Recom list'!E19, (IF(Recommendations!N23='Recom list'!$C$2,'Recom list'!H19, (IF(Recommendations!N23='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)"}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A16)), COLUMNS($A$3:A17)), \" \")","v":"Compliance Communication"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B16)), COLUMNS($A$3:B17)),\" \")","v":"Communicating requirements"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G16)), COLUMNS($A$3:G17)),\" \")","v":"Identify and set up appropriate approaches to communicate compliance requirements and procedures to improve compliance."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H16)), COLUMNS($A$1:H16)),\" \")","v":"Low/Medium "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I16)), COLUMNS($A$1:I16)),\" \")","v":" - Relevant government agency(-ies)\n - Expert technical assistance \n - Associations, other Organizations "},null,null,{"$f":"$J$6","v":"Processes - Market Surveillance & Enforcement"},{"$f":"'III - Compliance Processes'!E88","v":"Enforcement"},{"$f":"'III - Compliance Processes'!H88","v":0},{"$f":"'III - Compliance Processes'!I88","v":0.25},1,{"$f":"IF(M24=0,'Recom list'!$C$3, IF(M24<0.4,'Recom list'!$C$2, IF(M24>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N24='Recom list'!$C$1,'Recom list'!C20, (IF(Recommendations!N24='Recom list'!$C$2,'Recom list'!F20, (IF(Recommendations!N24='Recom list'!$C$3, \"None\")))))","v":"Set up procedures and processes for taking appropriate and proportionate enforcement actions to rectify non-compliance."},{"$f":"IF(N24='Recom list'!$C$1,'Recom list'!D20, (IF(Recommendations!N24='Recom list'!$C$2,'Recom list'!G20, (IF(Recommendations!N24='Recom list'!$C$3, \"None\")))))","v":"Low"},{"$f":"IF(N24='Recom list'!$C$1,'Recom list'!E20, (IF(Recommendations!N24='Recom list'!$C$2,'Recom list'!H20, (IF(Recommendations!N24='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)"}]
[null,{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:A17)), COLUMNS($A$3:A18)), \" \")","v":"Compliance Communication"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:B17)), COLUMNS($A$3:B18)),\" \")","v":"Communicating non-compliance"},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:G17)), COLUMNS($A$3:G18)),\" \")","v":"Establish country-relevant  procedures to report market surveillance actions and non-compliance to stakeholders  to deter future non-compliance."},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:H17)), COLUMNS($A$1:H17)),\" \")","v":"Low/Medium "},{"$f":"IFERROR(INDEX($I$10:$Q$26, SMALL(IF((INDEX($I$10:$N$26,,$C$3)=$C$4),MATCH(ROW($N$10:$N$26),ROW($N$10:$N$26)),\"\"), ROWS($A$1:I17)), COLUMNS($A$1:I17)),\" \")","v":" - Relevant government agency(-ies)"},null,null,{"$f":"$J$7","v":"Compliance Communication"},{"$f":"'III - Compliance Processes'!E90","v":"Communicating requirements"},{"$f":"'III - Compliance Processes'!H90","v":0},{"$f":"'III - Compliance Processes'!I90","v":0.8},1,{"$f":"IF(M25=0,'Recom list'!$C$3, IF(M25<0.4,'Recom list'!$C$2, IF(M25>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N25='Recom list'!$C$1,'Recom list'!C21, (IF(Recommendations!N25='Recom list'!$C$2,'Recom list'!F21, (IF(Recommendations!N25='Recom list'!$C$3, \"None\")))))","v":"Identify and set up appropriate approaches to communicate compliance requirements and procedures to improve compliance."},{"$f":"IF(N25='Recom list'!$C$1,'Recom list'!D21, (IF(Recommendations!N25='Recom list'!$C$2,'Recom list'!H21, (IF(Recommendations!N25='Recom list'!$C$3, \"None\")))))","v":"Low/Medium "},{"$f":"IF(N25='Recom list'!$C$1,'Recom list'!E21, (IF(Recommendations!N25='Recom list'!$C$2,'Recom list'!#REF!, (IF(Recommendations!N25='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)\n - Expert technical assistance \n - Associations, other Organizations "}]
[null,null,null,null,null,null,null,null,{"$f":"$J$7","v":"Compliance Communication"},{"$f":"'III - Compliance Processes'!E91","v":"Communicating non-compliance"},{"$f":"'III - Compliance Processes'!H91","v":0},{"$f":"'III - Compliance Processes'!I91","v":0.2},1,{"$f":"IF(M26=0,'Recom list'!$C$3, IF(M26<0.4,'Recom list'!$C$2, IF(M26>=0.4,'Recom list'!$C$1, \"Error\")))","v":"Key Priority"},{"$f":"IF(N26='Recom list'!$C$1,'Recom list'!C22, (IF(Recommendations!N26='Recom list'!$C$2,'Recom list'!F22, (IF(Recommendations!N26='Recom list'!$C$3, \"None\")))))","v":"Establish country-relevant  procedures to report market surveillance actions and non-compliance to stakeholders  to deter future non-compliance."},{"$f":"IF(N26='Recom list'!$C$1,'Recom list'!D22, (IF(Recommendations!N26='Recom list'!$C$2,'Recom list'!H22, (IF(Recommendations!N26='Recom list'!$C$3, \"None\")))))","v":"Low/Medium "},{"$f":"IF(N26='Recom list'!$C$1,'Recom list'!E22, (IF(Recommendations!N26='Recom list'!$C$2,'Recom list'!#REF!, (IF(Recommendations!N26='Recom list'!$C$3, \"None\")))))","v":" - Relevant government agency(-ies)"}]
[]
[null,null,null,null,null,null,null,null,"Regional collaboration????"]

{"sheet":"I - Regulation","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,0,9,1],[11,0,11,3],[12,0,12,2],[17,0,17,2],[22,0,22,2],[15,1,15,2],[14,1,14,2],[13,1,13,2],[16,1,16,2],[0,0,1,2],[2,0,2,3],[6,0,6,2],[7,0,7,1],[8,0,8,1],[23,1,23,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[18,1,18,2]]}
[" REGULATORY FRAMEWORK",null,null,"INDICATOR SCORE (out of 1)"]
[null,null,null,{"$f":"IF(C9='Reg list'!A5,0,(SUM(F14:F24)-0)/(SUM(E14:E24)-0))","v":0}]
["This indicator evaluates the status of country's regulations and provisions for compliance processes, i.e. whether regulations cover all necessary provisions, whether the country has adminstrative guidelines to complement the regulations, etc. "]
[]
[null,"Reset response cells?",null," Please select \"Yes\" each time you would like to clear resposes"]
[]
["Initial Assessment"]
["Question  I",null,{"$f":"'Reg list'!A2","v":"Does the country have regulation (or provisions) to implement and enforce product energy efficiency or quality policies, including offences, penalties, etc.?"}]
["Response - select applicable option",null,"  "]
["Next Step",null,{"$f":"IF(C9='Reg list'!A3,'Reg list'!C3,(IF(C9='Reg list'!A4,'Reg list'!C4,(IF('I - Regulation'!C9='Reg list'!A5,'Reg list'!C5,\" \")))))","v":" "}]
[]
["Detailed Assessment of Regulatory Framework for  Implementing Efficiency Policies for Products"]
["Regulations - Key Provisions",null,null,"Response - select applicable option","Max score","Question Score ","Adjusted score"]
["I.1",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!A8)","v":"Does the regulation identify and define roles and responsibilities of key actors (i.e. regulator/enforcement authority, product manufacturer, retailer, etc. )?"},null,"  ",{"$f":"'Reg list'!B9","v":2},{"$f":"IF(D14='Reg list'!A9,'Reg list'!B9,(IF(D14='Reg list'!A10,'Reg list'!B10,(IF(D14='Reg list'!A11,'Reg list'!B11,0)))))","v":0},{"$f":"(F14-0)/(SUM($E$14:$E$24)-0)","v":0}]
["I.2",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!C8)","v":"Does the regulation identify and define potential offences? "},null,"  ",{"$f":"'Reg list'!D9","v":2},{"$f":"IF(D15='Reg list'!C9,'Reg list'!D9,(IF(D15='Reg list'!C10,'Reg list'!D10,(IF(D15='Reg list'!C11,'Reg list'!D11,0)))))","v":0},{"$f":"(F15-0)/(SUM($E$14:$E$24)-0)","v":0}]
["I.3",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!E8)","v":"Does the regulation provide a range of penalties or other enforcement actions for non-compliance? "},null,"  ",{"$f":"'Reg list'!F9","v":2},{"$f":"IF(D16='Reg list'!E9,'Reg list'!F9,(IF(D16='Reg list'!E10,'Reg list'!F10,(IF(D16='Reg list'!E11,'Reg list'!F11,0)))))","v":0},{"$f":"(F16-0)/(SUM($E$14:$E$24)-0)","v":0}]
["I.4",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!G8)","v":"Does the regulation define manufacturer, importer, and retailer requirements? "},null,"  ",{"$f":"'Reg list'!H9","v":2},{"$f":"IF(D16='Reg list'!G9,'Reg list'!H9,(IF(D16='Reg list'!G10,'Reg list'!H10,(IF(D16='Reg list'!G11,'Reg list'!H11,0)))))","v":0},{"$f":"(F17-0)/(SUM($E$14:$E$24)-0)","v":0}]
["Regulations - Additional Provisions",null,null,"Response - select applicable option"]
["I.5",{"$f":"IF(C9='Reg list'!A5,\"Not applicable\",'Reg list'!A14)","v":"What type of test report is required to prove the product is compliant with the standards? "},null,"  ",{"$f":"'Reg list'!B15","v":1},{"$f":"IF('I - Regulation'!D19='Reg list'!A15,'Reg list'!B15,(IF('I - Regulation'!D19='Reg list'!A16,'Reg list'!B16,(IF('I - Regulation'!D19='Reg list'!A17,'Reg list'!B17,(IF('I - Regulation'!D19='Reg list'!A18,'Reg list'!B18,(IF('I - Regulation'!D19='Reg list'!A19,'Reg list'!B19,0)))))))))","v":0},{"$f":"(F19-0)/(SUM($E$14:$E$24)-0)","v":0}]
["I.6",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!C14)","v":"How are the product certified, to be authorized for sale on the market? "},null,"  ",{"$f":"'Reg list'!D15","v":1},{"$f":"IF('I - Regulation'!D20='Reg list'!C15,'Reg list'!D15,(IF('I - Regulation'!D20='Reg list'!C16,'Reg list'!D16,(IF('I - Regulation'!D20='Reg list'!C17,'Reg list'!D17,0)))))","v":0},{"$f":"(F20-0)/(SUM($E$14:$E$24)-0)","v":0}]
["I.7",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!E14)","v":"Do products need to be registered in a national/regional product registry (database), before they can be sold on the market? "},null,"  ",{"$f":"'Reg list'!F15","v":1},{"$f":"IF('I - Regulation'!D21='Reg list'!E15,'Reg list'!F15,(IF('I - Regulation'!D21='Reg list'!E16,'Reg list'!F16,(IF('I - Regulation'!D21='Reg list'!E17,'Reg list'!F17,0)))))","v":0},{"$f":"(F21-0)/(SUM($E$14:$E$24)-0)","v":0}]
["I.8",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!G14)","v":"Does the regulation define market surveillance powers for regulator/compliance authority? "},null,"  ",{"$f":"'Reg list'!H15","v":1},{"$f":"IF(D22='Reg list'!G15,'Reg list'!H15,(IF(D22='Reg list'!G16,'Reg list'!H16,0)))","v":0},{"$f":"(F22-0)/(SUM($E$14:$E$24)-0)","v":0}]
["Other - Administrative Guidelines",null,null,"Response - select applicable option"]
["I.9",{"$f":"IF(C9='Reg list'!A5, \"Not applicable\", 'Reg list'!A22)","v":"Is any explanation on processes and requirements made available, in addition to the regulation, for example in the form of Administrative Guidelines  (i.e. guidelines, FAQs, or standard operating procedures) that provide more detail and guidance on how to implement and comply with the policy? "},null,"  ",{"$f":"'Reg list'!B23","v":1},{"$f":"IF(D24='Reg list'!A23,'Reg list'!B23,(IF(D24='Reg list'!A24,'Reg list'!B24,(IF(D24='Reg list'!A25,'Reg list'!B25,(IF(D24='Reg list'!A26,'Reg list'!B26,0)))))))","v":0},{"$f":"(F24-0)/(SUM($E$14:$E$24)-0)","v":0}]
[null,null,null,null,{"$f":"SUM(E14:E24)","v":13},{"$f":"SUM(F14:F24)","v":0},{"$f":"SUM(G14:G24)","v":0}]
["Next, please go to II-Resources indicator tab"]
[null,null,null,null,"For recommendations"]
[null,null,null,null,null,"Max score","Question Score ","Adjusted score","max adjusted score"]
[null,null,null,null,{"$f":"A13","v":"Regulations - Key Provisions"},{"$f":"SUM(E14:E17)","v":8},{"$f":"SUM(F14:F17)","v":0},{"$f":"SUM(G14:G17)","v":0},{"$f":"F29/$E$25","v":0.61538461538461542}]
[null,null,null,null,{"$f":"A18","v":"Regulations - Additional Provisions"},{"$f":"SUM(E19:E22)","v":4},{"$f":"SUM(F19:F22)","v":0},{"$f":"SUM(G19:G22)","v":0},{"$f":"F30/$E$25","v":0.30769230769230771}]
[null,null,null,null,{"$f":"A23","v":"Other - Administrative Guidelines"},{"$f":"E24","v":1},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"F31/$E$25","v":7.6923076923076927E-2}]

{"sheet":"II - Resources","index":4,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,0,7,2],[6,0,6,2],[0,0,1,2],[15,1,15,2],[16,1,16,2],[2,0,2,3],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[18,1,18,2],[19,1,19,2],[13,0,13,2],[17,0,17,2],[34,4,34,6],[14,1,14,2]]}
["RESOURCES",null,null,"INDICATOR SCORE (out of 1)"]
[null,null,null,{"$f":"IF('I - Regulation'!C9='Reg list'!A5,0,(SUM(F9:F20)-0)/(SUM(E9:E20)-0))","v":0}]
["This indicator evaluates the status of your country's financial, human, and infrastructure resources for enforcing policy compliance, i.e. whether the program has sufficient staff, budget and access to testing facilities. "]
[]
[null,"Reset response cells?",null," Please select \"Yes\" each time you would like to clear resposes"]
[]
["Assessing Avaiablity of Required Resources for Implementing Efficiency Policies for Products"]
["Institutional Framework and Human Capital",null,null,"Response - select applicable option","Max score","Question Score ","Adjusted score"]
["II.1",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!A2)","v":"Has a Regulator been assigned responsibility for ensuring compliance with the regulations? "},null,"  ",{"$f":"'Res list'!B3","v":2},{"$f":"IF(D9='Res list'!A2,'Res list'!B2,(IF(D9='Res list'!A3,'Res list'!B3,(IF(D9='Res list'!A4,'Res list'!B4,0)))))","v":0},{"$f":"(F9-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.2",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!C2)","v":"Is the Regulator actively implementing all their assigned responsibilities (ie. conformity assessment, market surveillance, enforcement, reporting, etc.)?"},null,"  ",{"$f":"'Res list'!D3","v":2},{"$f":"IF(D10='Res list'!C2,'Res list'!D2,(IF(D10='Res list'!C3,'Res list'!D3,(IF(D10='Res list'!C4,'Res list'!D4,0)))))","v":0},{"$f":"(F10-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.3",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!E2)","v":"Have the roles and responsibilities been clearly defined and assigned between agencies if there is a need for their support for compliance processes?"},null,"  ",{"$f":"'Res list'!F3","v":1},{"$f":"IF(D11='Res list'!E2,'Res list'!F2,(IF(D11='Res list'!E3,'Res list'!F3,(IF(D11='Res list'!E4,'Res list'!F4,0)))))","v":0},{"$f":"(F11-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.4",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!G2)","v":"Is compliance program sufficiently staffed? "},null,"  ",{"$f":"'Res list'!H3","v":1},{"$f":"IF(D12='Res list'!G3,'Res list'!H3,(IF(D12='Res list'!G4,'Res list'!H4,(IF(D12='Res list'!G5,'Res list'!H5,(IF(D12='Res list'!G6,'Res list'!H6,0)))))))","v":0},{"$f":"(F12-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.5",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!I2)","v":"Is compliance staff trained, knowledgeable, and able to execute their duties? "},null,"  ",{"$f":"'Res list'!J3","v":1},{"$f":"IF(D13='Res list'!I3,'Res list'!J3,(IF(D13='Res list'!I4,'Res list'!J4,(IF(D13='Res list'!I5,'Res list'!J5,0)))))","v":0},{"$f":"(F13-0)/(SUM($E$9:$E$20)-0)","v":0}]
["Access to Infrastructure",null,null,"Response - select applicable option"]
["II.6",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!A8)","v":"Does the energy efficiency program use a product registration system (database)?"},null,"  ",{"$f":"'Res list'!B9","v":3},{"$f":"IF(D15='Res list'!A9,'Res list'!B9,(IF(D15='Res list'!A10,'Res list'!B10,(IF(D15='Res list'!A11,'Res list'!B11,0)))))","v":0},{"$f":"(F15-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.7",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!C8)","v":"Does the Regulator have access to test facilities, in-country or abroad, to conduct verification testing of products?"},null,null,{"$f":"'Res list'!D9","v":2},{"$f":"IF(D16='Res list'!C9,'Res list'!D9,(IF(D16='Res list'!C10,'Res list'!D10,(IF(D16='Res list'!C11,'Res list'!D11,(IF(D16='Res list'!C12,'Res list'!D12,0)))))))","v":0},{"$f":"(F16-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.8",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!E8)","v":"Does the team have the tools and physical resources they need to conduct compliance activities  (e.g. computers, mobile phones, etc.)? "},null,"  ",{"$f":"'Res list'!F9","v":1},{"$f":"IF(D17='Res list'!E9,'Res list'!F9,(IF(D17='Res list'!E10,'Res list'!F10,(IF(D17='Res list'!E11,'Res list'!F11,0)))))","v":0},{"$f":"(F17-0)/(SUM($E$9:$E$20)-0)","v":0}]
["Budget/Funding",null,null,"Response - select applicable option"]
["II.9",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!A14)","v":"Is there sufficient funding to conduct compliance activities?"},null,"  ",{"$f":"'Res list'!B15","v":1},{"$f":"IF(D19='Res list'!A15,'Res list'!B15,(IF(D19='Res list'!A16,'Res list'!B16,(IF(D19='Res list'!A17,'Res list'!B17,(IF(D19='Res list'!A18,'Res list'!B18,0)))))))","v":0},{"$f":"(F19-0)/(SUM($E$9:$E$20)-0)","v":0}]
["II.10",{"$f":"IF('I - Regulation'!C9='Reg list'!A5, \"Not applicable\", 'Res list'!C14)","v":"How is the energy efficiency program implementation and enforcement funded? "},null,"  ",{"$f":"'Res list'!D15","v":2},{"$f":"IF(D20='Res list'!C15,'Res list'!D15,(IF(D20='Res list'!C16,'Res list'!D16,(IF(D20='Res list'!C17,'Res list'!D17,(IF(D20='Res list'!C18,'Res list'!D18,(IF(D20='Res list'!C19,'Res list'!D19,0)))))))))","v":0},{"$f":"(F20-0)/(SUM($E$9:$E$20)-0)","v":0}]
[null,null,null,null,{"$f":"SUM(E9:E20)","v":16},{"$f":"SUM(F9:F20)","v":0},{"$f":"SUM(G9:G20)","v":0}]
["Next, please go to III-Compliance processes indicator tab"]
[null,null,null,null,null,"Max score","Question Score ","Adjusted score","max adjusted score"]
[null,null,null,null,{"$f":"A8","v":"Institutional Framework and Human Capital"},{"$f":"SUM(E9:E13)","v":7},{"$f":"SUM(F9:F13)","v":0},{"$f":"SUM(G9:G13)","v":0},{"$f":"F24/E21","v":0.4375}]
[null,null,null,null,{"$f":"A14","v":"Access to Infrastructure"},{"$f":"SUM(E15:E17)","v":6},{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},{"$f":"F25/E21","v":0.375}]
[null,null,null,null,{"$f":"A18","v":"Budget/Funding"},{"$f":"SUM(E19:E20)","v":3},{"$f":"SUM(F19:F20)","v":0},{"$f":"SUM(G19:G20)","v":0},{"$f":"F26/E21","v":0.1875}]
[]
[null,null,null,null,"For graph"]
[null,null,null,null,null,"adjusted score","gap"]
[null,null,null,null,{"$f":"A8","v":"Institutional Framework and Human Capital"},{"$f":"H24/I24","v":0},{"$f":"1-F30","v":1}]
[null,null,null,null,{"$f":"A14","v":"Access to Infrastructure"},{"$f":"H25/I25","v":0},{"$f":"1-F31","v":1}]
[null,null,null,null,{"$f":"A18","v":"Budget/Funding"},{"$f":"H26/I26","v":0},{"$f":"1-F32","v":1}]
[null,null,null,null,"Total Resources",{"$f":"SUM(H24:H26)/SUM(I24:I26)","v":0},{"$f":"1-F33","v":1}]
[]
[null,null,null,null,"For recommendations"]
[null,null,null,null,null,"Max score","Question Score ","Adjusted score","max adjusted score"]
[null,null,null,null,{"$f":"Recommendations!J13","v":"Institutional Collaboration"},{"$f":"SUM(E9:E11)","v":5},{"$f":"SUM(F9:F11)","v":0},{"$f":"SUM(G9:G11)","v":0},{"$f":"F37/$F$43","v":0.3125}]
[null,null,null,null,{"$f":"Recommendations!J14","v":"Human Capital"},{"$f":"SUM(E12:E13)","v":2},{"$f":"SUM(F12:F13)","v":0},{"$f":"SUM(G12:G13)","v":0},0.125]
[null,null,null,null,{"$f":"Recommendations!J15","v":"Product Registration System"},{"$f":"E15","v":3},{"$f":"F15","v":0},0,0.1875]
[null,null,null,null,{"$f":"Recommendations!J16","v":"Access to testing"},{"$f":"E16","v":2},0,0,0.125]
[null,null,null,null,"Other resources",{"$f":"E17","v":1},0,0,6.25E-2]
[null,null,null,null,{"$f":"Recommendations!J18","v":"Budget/Funding"},{"$f":"E19+E20","v":3},{"$f":"F19+F20","v":0},0,0.1875]
[null,null,null,null,"Total",{"$f":"SUM(F37:F42)","v":16},{"$f":"SUM(G37:G42)","v":0},{"$f":"SUM(H37:H42)","v":0},{"$f":"SUM(I37:I42)","v":1}]

{"sheet":"III - Compliance Processes","index":5,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":false,"merged":[[56,0,56,1],[57,0,57,1],[58,0,58,1],[50,0,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[55,0,55,2],[0,0,1,1],[2,0,2,3],[11,0,11,1],[12,0,12,1],[13,0,13,1],[25,1,25,2],[78,4,78,6],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[27,0,27,2],[28,0,28,1],[29,0,29,1],[30,0,30,1],[32,0,32,2],[60,0,60,2],[45,0,45,2],[46,0,46,1],[47,0,47,1],[48,0,48,1],[14,0,14,1],[16,0,16,3],[17,0,17,2],[37,1,37,2],[38,1,38,2],[18,1,18,2],[20,1,20,2],[19,1,19,2],[21,1,21,2],[22,1,22,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[23,1,23,2],[24,1,24,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2]]}
["COMPLIANCE PROCESSES"]
[]
["This indicator evaluates the status of your country's compliance processes, i.e. product registration, market monitoring activities, etc. "]
[]
[null,null,null,"INDICATOR SCORE"]
[null,null,"Certification & Registration",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,0,IF(C14='Compl processes list'!A5,0,(SUM(F19:F26)-0)/(SUM(E19:E26)-0)))","v":0}]
[null,null,"Market Surveillance and Enforcement",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,0,IF(C30='Compl processes list'!E5,0,G56))","v":0}]
[null,null,"Compliance Communication",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,0,IF(C58='Compl processes list'!I5,0,(SUM(F62:F65)-0)/(SUM(E62:E65)-0)))","v":0}]
[]
[null,"Reset response cells?",null," Please select \"Yes\" each time you would like to clear resposes"]
[]
["Initial Assessment - Cetification & Registration"]
["Question III-A",null,{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",'Compl processes list'!A2)","v":"Has the country set up product market entry requirements and processes (e.g. product registration)?"}]
["Response - select applicable option",null,"  "]
["Next Step",null,{"$f":"IF(C14='Compl processes list'!A3,'Compl processes list'!C3,(IF(C14='Compl processes list'!A4,'Compl processes list'!C4,(IF(C14='Compl processes list'!A5,'Compl processes list'!C5,\" \")))))","v":" "}]
[]
["Assessing  Processes for Implementing Efficiency Policies for Products"]
["Processes - Certification & Registration",null,null,"Response - select applicable option","Max score","Question Score ","Adjusted score"]
["III.1",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",'Compl processes list'!A8))","v":"Does the Regulator or certification body review test reports to confirm compliance with the regulatory requirements, before certifying products?"},null,"  ",{"$f":"'Compl processes list'!B9","v":2},{"$f":"IF(D19='Compl processes list'!A9,'Compl processes list'!B9,(IF(D19='Compl processes list'!A10,'Compl processes list'!B10,(IF(D19='Compl processes list'!A11,'Compl processes list'!B11,0)))))","v":0},{"$f":"(F19-0)/(SUM($E$19:$E$26)-0)","v":0}]
["III.2",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",IF('II - Resources'!D15='Res list'!A11,\"Not applicable\",'Compl processes list'!C8)))","v":"Which products are registered in product registration system (database)?"},null,"  ",{"$f":"'Compl processes list'!D9","v":2},{"$f":"IF(D20='Compl processes list'!C9,'Compl processes list'!D9,(IF(D20='Compl processes list'!C10,'Compl processes list'!D10,IF(D20='Compl processes list'!C12,'Compl processes list'!D12,0))))","v":0},0]
["III.3",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",IF('II - Resources'!D15='Res list'!A11,\"Not applicable\",'Compl processes list'!E8)))","v":"What type of product registration system (database)  is used to register products?"},null,"  ",{"$f":"'Compl processes list'!F9","v":1},{"$f":"IF(D21='Compl processes list'!E9,'Compl processes list'!F9,(IF(D21='Compl processes list'!E10,'Compl processes list'!F10,IF(D21='Compl processes list'!E12,'Compl processes list'!F12,0))))","v":0},0]
["III.4",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",'Compl processes list'!G8))","v":"What action is taken against suspicious or wrong product certification application (i.e. incomplete applications, applications with innaccuracies and errors, suspicious test reports, etc.)?"},null,"  ",{"$f":"'Compl processes list'!H9","v":1},{"$f":"IF(D22='Compl processes list'!G9,'Compl processes list'!H9,(IF(D22='Compl processes list'!G10,'Compl processes list'!H10,IF(D22='Compl processes list'!G11,'Compl processes list'!H11,0))))","v":0},0]
["III.5",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",'Compl processes list'!I8))","v":"If the country has labeling program, how is the energy or quality label generated? "},null,"  ",{"$f":"IF(D23='Compl processes list'!I11,0, 'Compl processes list'!J9)","v":1},{"$f":"IF(D23='Compl processes list'!I9,'Compl processes list'!J9,(IF(D23='Compl processes list'!I10,'Compl processes list'!J10,IF(D23='Compl processes list'!I11,'Compl processes list'!J11,0))))","v":0},0]
["III.6",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",'Compl processes list'!A15))","v":"Do Customs Officers (or equivalent) check products and  documentation for  compliance at the border/ports? "},null,"  ",{"$f":"'Compl processes list'!B16","v":2},{"$f":"IF(D24='Compl processes list'!A16,'Compl processes list'!B16,(IF(D24='Compl processes list'!A17,'Compl processes list'!B17,(IF(D24='Compl processes list'!A18,'Compl processes list'!B18, (IF(D24='Compl processes list'!A19,'Compl processes list'!B19,0)))))))","v":0},0]
["III.7",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",IF(D21='Compl processes list'!E11,\"Not applicable\", 'Compl processes list'!C15)))","v":"Do Customs Officers (or equivalent) at the border/ports have access to the product registration system (database), so they can cross-check whether products are authorized to enter the country?"},null,"  ",{"$f":"'Compl processes list'!D16","v":1},{"$f":"IF(D25='Compl processes list'!C16,'Compl processes list'!D16,(IF(D25='Compl processes list'!C17,'Compl processes list'!D17,0)))","v":0},0]
["III.8",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C14='Compl processes list'!A5,\"Not applicable\",'Compl processes list'!E15))","v":"What action is taken if products do not meet entry requirements at the border/port (i.e. do not have required or correct documentation, not registered in the database, etc.)?"},null,"  ",{"$f":"'Compl processes list'!F16","v":1},{"$f":"IF(D26='Compl processes list'!E16,'Compl processes list'!F16,(IF(D26='Compl processes list'!E17,'Compl processes list'!F17,IF(D26='Compl processes list'!E18,'Compl processes list'!F18,IF(D26='Compl processes list'!E19,'Compl processes list'!F19,0)))))","v":0},0]
[null,null,null,null,{"$f":"SUM(E19:E26)","v":11},{"$f":"SUM(F19:F26)","v":0},{"$f":"SUM(G19:G26)","v":0}]
["Initial Assessment - Market Surveillance & Enforcement"]
["Question III-B",null,{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",'Compl processes list'!E2)","v":"Does the program have market surveillance procedures and enforcement actions? "}]
["Response - select applicable option",null,"  "]
["Next Step",null,{"$f":"IF(C30='Compl processes list'!E3,'Compl processes list'!G3,(IF(C30='Compl processes list'!E4,'Compl processes list'!G4,(IF(C30='Compl processes list'!E5,'Compl processes list'!G5, \" \")))))","v":" "}]
[]
["Processes - Market Surveillance & Enforcement",null,null,"Response - select applicable option","Max score","Question Score ","Adjusted score"]
["III.9",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!A22))","v":"Does the Regulator regularly conduct market surveillance activities? "},null,"  ",{"$f":"'Compl processes list'!B23","v":2},{"$f":"IF(D34='Compl processes list'!A23,'Compl processes list'!B23,(IF(D34='Compl processes list'!A24,'Compl processes list'!B24,0)))","v":0},{"$f":"(F34-0)/(SUM($E$34:$E$44)-0)","v":0}]
["III.10",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!C22))","v":"How frequently does the Regulator conduct in-store and/or product document  inspections?"},null,"  ",{"$f":"'Compl processes list'!D23","v":1},{"$f":"IF(D35='Compl processes list'!C23,'Compl processes list'!D23,(IF(D35='Compl processes list'!C24,'Compl processes list'!D24,(IF(D35='Compl processes list'!C25,'Compl processes list'!D25,0)))))","v":0},0]
["III.11",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!E22))","v":"Does the Regulator gather compliance intelligence through other methods (i.e. complaints, customs, product registration system)?"},null,"  ",{"$f":"'Compl processes list'!F23","v":1},{"$f":"IF(D36='Compl processes list'!E23,'Compl processes list'!F23,(IF(D36='Compl processes list'!E24,'Compl processes list'!F24,(IF(D36='Compl processes list'!E25,'Compl processes list'!F25,0)))))","v":0},0]
["III.12",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!G22))","v":"Does the Regulator monitor online sales for potential non-compliance (ie. missing labels, suspicious claims, unregistered models, etc.)? "},null,"  ",{"$f":"IF(D37='Compl processes list'!G26,0, 'Compl processes list'!H23)","v":1},{"$f":"IF(D37='Compl processes list'!G23,'Compl processes list'!H23,(IF(D37='Compl processes list'!G24,'Compl processes list'!H24,(IF(D37='Compl processes list'!G25,'Compl processes list'!H25,(IF(D37='Compl processes list'!G26,'Compl processes list'!H26,0)))))))","v":0},0]
["III.13",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!A29))","v":"Does the Regulator conduct verification testing, to check whether products perform to standard and as claimed? "},null,"  ",{"$f":"'Compl processes list'!B30","v":1},{"$f":"IF(D38='Compl processes list'!A30,'Compl processes list'!B30,(IF(D38='Compl processes list'!A31,'Compl processes list'!B31,(IF(D38='Compl processes list'!A32,'Compl processes list'!B32,0)))))","v":0},0]
["III.14",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",IF(D38='Compl processes list'!A32,\"Not applicable\",'Compl processes list'!C29)))","v":"How are product selected for verification testing? "},null,"  ",{"$f":"'Compl processes list'!D30","v":1},{"$f":"IF(D39='Compl processes list'!C30,'Compl processes list'!D30,(IF(D39='Compl processes list'!C31,'Compl processes list'!D31,(IF(D39='Compl processes list'!C32,'Compl processes list'!D32,0)))))","v":0},0]
["III.15",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",IF(D38='Compl processes list'!A32,\"Not applicable\",'Compl processes list'!E29)))","v":"Where are products procured for verification testing?"},null,"  ",{"$f":"'Compl processes list'!F30","v":1},{"$f":"IF(D40='Compl processes list'!E30,'Compl processes list'!F30,(IF(D40='Compl processes list'!E31,'Compl processes list'!F31,(IF(D40='Compl processes list'!E32,'Compl processes list'!F32,0)))))","v":0},0]
["III.16",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!G29))","v":"Does the Regulator keep an accessible record of market monitoring and verification testing activities, results, and non-compliant cases?"},null,"  ",{"$f":"'Compl processes list'!H30","v":1},{"$f":"IF(D41='Compl processes list'!G30,'Compl processes list'!H30,(IF(D41='Compl processes list'!G31,'Compl processes list'!H31,(IF(D41='Compl processes list'!G32,'Compl processes list'!H32,0)))))","v":0},0]
["III.17",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!A35))","v":"Does the Regulator take enforcement action, both informal or formal, against non-compliant suppliers and products? "},null,"  ",{"$f":"'Compl processes list'!B36","v":2},{"$f":"IF(D42='Compl processes list'!A36,'Compl processes list'!B36,(IF(D42='Compl processes list'!A37,'Compl processes list'!B37,(IF(D42='Compl processes list'!A38,'Compl processes list'!B38,0)))))","v":0},0]
["III.18",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!C35))","v":"Are enforcement actions proportionate to the severity and impact of the offence (i.e. large fines or prosecution for worst, intentional, and most serious offences / informal warnings or requests to correct issues for small, unintentional, least serious offences)?"},null,"  ",{"$f":"'Compl processes list'!D36","v":1},{"$f":"IF(D43='Compl processes list'!C36,'Compl processes list'!D36,(IF(D43='Compl processes list'!C37,'Compl processes list'!D37,(IF(D43='Compl processes list'!C38,'Compl processes list'!D38,0)))))","v":0},0]
["III.19",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C30='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!E35))","v":"Does the Regulator follow up with the supplier until the offence is corrected?"},null,"  ",{"$f":"'Compl processes list'!F36","v":1},{"$f":"IF(D44='Compl processes list'!E36,'Compl processes list'!F36,(IF(D44='Compl processes list'!E37,'Compl processes list'!F37,(IF(D44='Compl processes list'!E38,'Compl processes list'!F38,0)))))","v":0},0]
[]
["Initial Assessment - Regional Collaboration"]
["Question III-C",null,{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",'Compl processes list'!M2)","v":"Is regional or bi-lateral collaboration on compliance with other countries possible?"}]
["Response - select applicable option",null,"  "]
["Next Step",null,{"$f":"IF(C48='Compl processes list'!M3,'Compl processes list'!N3,(IF(C48='Compl processes list'!M4,'Compl processes list'!N4,(IF(C48='Compl processes list'!M5,'Compl processes list'!N5,\" \")))))","v":" "}]
[]
["Regional Collaboration and Information Sharing",null,null,null,"Max score","Question Score ","Adjusted score"]
["III.24",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C48='Compl processes list'!M5,\"Not applicable\",'Compl processes list'!A50))","v":"Does the Regulator engage in available regional or bi-lateral collaborations on compliance?"},null,"  ",{"$f":"'Compl processes list'!B51","v":1},{"$f":"IF('III - Compliance Processes'!D52='Compl processes list'!A51,'Compl processes list'!B51,(IF('III - Compliance Processes'!D52='Compl processes list'!A52,'Compl processes list'!B52,(IF('III - Compliance Processes'!D52='Compl processes list'!A53,'Compl processes list'!B53, 0)))))","v":0},{"$f":"(F52-0)/(SUM($E$52:$E$54)-0)","v":0}]
["III.25",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C48='Compl processes list'!M5,\"Not applicable\",'Compl processes list'!C50))","v":"Does the Regulator share compliance intelligence with other collaborating countries through available channels? "},null,"  ",{"$f":"'Compl processes list'!D51","v":1},{"$f":"IF('III - Compliance Processes'!D53='Compl processes list'!C51,'Compl processes list'!D51,(IF('III - Compliance Processes'!D53='Compl processes list'!C52,'Compl processes list'!D52,(IF('III - Compliance Processes'!D53='Compl processes list'!C53,'Compl processes list'!D53,0)))))","v":0},{"$f":"(F53-0)/(SUM($E$52:$E$54)-0)","v":0}]
["III.26",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C48='Compl processes list'!M5,\"Not applicable\",IF(D53='Compl processes list'!C53,\"Not applicable\",'Compl processes list'!E50)))","v":"What  compliance intelligence and information does the Regulator share with other countries?"},null,"  ",{"$f":"'Compl processes list'!F51","v":1},{"$f":"IF('III - Compliance Processes'!D54='Compl processes list'!E51,'Compl processes list'!F51,(IF('III - Compliance Processes'!D54='Compl processes list'!E52,'Compl processes list'!F52,(IF('III - Compliance Processes'!D54='Compl processes list'!E53,'Compl processes list'!F53,0)))))","v":0},{"$f":"(F54-0)/(SUM($E$52:$E$54)-0)","v":0}]
[null,null,null,null,{"$f":"SUM(E34:E44)","v":13},{"$f":"SUM(F34:F44)","v":0},{"$f":"SUM(G34:G44)","v":0}]
["Initial Assessment - Commuincating Compliance Requirements, Activities, and Results",null,null,null,{"$f":"E55+E76","v":16},{"$f":"F55+F76","v":0},{"$f":"(F56-0)/(E56-0)","v":0},"Adjusted (with regional collaboration)"]
["Question III-C",null,{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",'Compl processes list'!I2)","v":"Does the program communicate compliance requirements, market surveillance actions, and compliance results to stakeholders? "}]
["Response - select applicable option",null,"  "]
["Next Step",null,{"$f":"IF(C58='Compl processes list'!I3,'Compl processes list'!K3,(IF(C58='Compl processes list'!I4,'Compl processes list'!K4,(IF(C58='Compl processes list'!I5,'Compl processes list'!K5,\" \")))))","v":" "}]
[]
["Communicating Compliance Requirements, Activities, and Results",null,null,"Response - select applicable option","Max score","Question Score ","Adjusted score"]
["III.20",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C58='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!A42))","v":"Is information or guidance on policy compliance (i.e. how to comply, processes, FAQs) easily and publically accessible to stakeholders? "},null,"  ",{"$f":"'Compl processes list'!B43","v":2},{"$f":"IF('III - Compliance Processes'!D62='Compl processes list'!A43,'Compl processes list'!B43,(IF('III - Compliance Processes'!D62='Compl processes list'!A44,'Compl processes list'!B44,(IF('III - Compliance Processes'!D62='Compl processes list'!A45,'Compl processes list'!B45,0)))))","v":0},{"$f":"(F62-0)/(SUM($E$62:$E$65)-0)","v":0}]
["III.21",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C58='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!C42))","v":"How is compliance information communicated to stakeholders? "},null,"  ",{"$f":"'Compl processes list'!D43","v":1},{"$f":"IF('III - Compliance Processes'!D63='Compl processes list'!C43,'Compl processes list'!D43,(IF('III - Compliance Processes'!D63='Compl processes list'!C44,'Compl processes list'!D44,(IF('III - Compliance Processes'!D63='Compl processes list'!C45,'Compl processes list'!D45,0)))))","v":0},{"$f":"(F63-0)/(SUM($E$62:$E$65)-0)","v":0}]
["III.22",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C58='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!E42))","v":"How regularly is compliance information communicated to stakeholders? "},null,"  ",{"$f":"'Compl processes list'!F43","v":1},{"$f":"IF('III - Compliance Processes'!D64='Compl processes list'!E43,'Compl processes list'!F43,(IF('III - Compliance Processes'!D64='Compl processes list'!E44,'Compl processes list'!F44,(IF('III - Compliance Processes'!D64='Compl processes list'!E45,'Compl processes list'!F45,0)))))","v":0},{"$f":"(F64-0)/(SUM($E$62:$E$65)-0)","v":0}]
["III.23",{"$f":"IF('I - Regulation'!C9='Reg list'!A5,\"Not applicable\",IF(C58='Compl processes list'!I5,\"Not applicable\",'Compl processes list'!G42))","v":"Is information on market surveillance activities and results (anonomized or not) publically accessible to stakeholders? "},null,"  ",{"$f":"'Compl processes list'!H43","v":1},{"$f":"IF('III - Compliance Processes'!D65='Compl processes list'!G43,'Compl processes list'!H43,(IF('III - Compliance Processes'!D65='Compl processes list'!G44,'Compl processes list'!H44,(IF('III - Compliance Processes'!D65='Compl processes list'!G45,'Compl processes list'!H45,0)))))","v":0},{"$f":"(F65-0)/(SUM($E$62:$E$65)-0)","v":0}]
[null,null,null,null,{"$f":"SUM(E62:E65)","v":5},{"$f":"SUM(F62:F65)","v":0},{"$f":"SUM(G62:G65)","v":0}]
["Please go to Results tab to see assessment resuts"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E52:E54)","v":3},{"$f":"SUM(F52:F54)","v":0},{"$f":"SUM(G52:G54)","v":0}]
[]
[]
[null,null,null,null,"For recommendations"]
[null,null,null,null,null,"Max score","Question Score ","Adjusted score","max adjusted score"]
[null,null,null,null,"Total - CA",{"$f":"SUM(F82:F83)","v":11},{"$f":"SUM(G82:G83)","v":0},{"$f":"SUM(H82:H83)","v":0},{"$f":"SUM(I82:I83)","v":1}]
[null,null,null,null,"Product certification and registration",{"$f":"SUM(E19:E23)","v":7},{"$f":"SUM(F19:F23)","v":0},{"$f":"SUM(G19:G23)","v":0},{"$f":"F82/F81","v":0.63636363636363635}]
[null,null,null,null,"Customs check",{"$f":"SUM(E24:E26)","v":4},{"$f":"SUM(F24:F26)","v":0},{"$f":"SUM(G24:G26)","v":0},{"$f":"F83/F81","v":0.36363636363636365}]
[null,null,null,null,"Total - MS",{"$f":"SUM(F85:F88)","v":16},{"$f":"SUM(G85:G88)","v":0},{"$f":"SUM(H85:H88)","v":0},{"$f":"SUM(I85:I88)","v":1}]
[null,null,null,null,"Market inspections",{"$f":"SUM(E34:E37)+E76","v":8},{"$f":"SUM(F34:F37)+F76","v":0},{"$f":"SUM(G34:G37)+G76","v":0},{"$f":"F85/$F$84","v":0.5}]
[null,null,null,null,"Verification testing",{"$f":"SUM(E38:E40)","v":3},{"$f":"SUM(F38:F40)","v":0},{"$f":"SUM(G38:G40)","v":0},{"$f":"F86/$F$84","v":0.1875}]
[null,null,null,null,"Record keeping",{"$f":"E41","v":1},{"$f":"F41","v":0},{"$f":"G41","v":0},{"$f":"F87/$F$84","v":6.25E-2}]
[null,null,null,null,"Enforcement",{"$f":"SUM(E42:E44)","v":4},{"$f":"SUM(F42:F44)","v":0},{"$f":"SUM(G42:G44)","v":0},{"$f":"F88/$F$84","v":0.25}]
[null,null,null,null,"Total - Comms",{"$f":"SUM(F90:F91)","v":5},{"$f":"SUM(G90:G91)","v":0},{"$f":"SUM(H90:H91)","v":0},{"$f":"SUM(I90:I91)","v":1}]
[null,null,null,null,"Communicating requirements",{"$f":"SUM(E62:E64)","v":4},{"$f":"SUM(F62:F64)","v":0},{"$f":"SUM(G62:G64)","v":0},{"$f":"F90/F89","v":0.8}]
[null,null,null,null,"Communicating non-compliance",{"$f":"SUM(E65:E65)","v":1},{"$f":"SUM(F65:F65)","v":0},{"$f":"SUM(G65:G65)","v":0},{"$f":"F91/F89","v":0.2}]

{"sheet":"Compl processes list","index":6,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":true,"merged":[[60,8,60,9],[60,10,60,11],[60,0,60,1],[60,2,60,3],[49,2,49,3],[60,6,60,7],[60,4,60,5]]}
["Compliance processes - gateaway question"]
["Has the country set up product market entry requirements and processes (e.g. product registration)?",null,"Action",null,"Does the program have market surveillance procedures and enforcement actions? ",null,"Action",null,"Does the program communicate compliance requirements, market surveillance actions, and compliance results to stakeholders? ",null,"Action",null,"Is regional or bi-lateral collaboration on compliance with other countries possible?","Action"]
["Yes",null,"Go to Question III.1",null,"Yes",null,"Go to Question III.9",null,"Yes",null,"Go to Question III.20",null,"Yes","Go to Question III.24"]
["Under development",null,"Go to Question III.1",null,"Under development",null,"Go to Question III.9",null,"Somewhat",null,"Go to Question III.20",null,"Somewhat","Go to Question III.24"]
["No",null,"Go to Question III-B (on Market Surveillance)",null,"No",null,"Go to Question III-C (on Communications)",null,"No",null,"Go to Question III-D (on Regional Collaboration)",null,"No","Go to Results tab"]
[]
["Certification and Registration"]
["Does the Regulator or certification body review test reports to confirm compliance with the regulatory requirements, before certifying products?",null,"Which products are registered in product registration system (database)?",null,"What type of product registration system (database)  is used to register products?",null,"What action is taken against suspicious or wrong product certification application (i.e. incomplete applications, applications with innaccuracies and errors, suspicious test reports, etc.)?",null,"If the country has labeling program, how is the energy or quality label generated? "]
["Yes",{"$f":"IF('III - Compliance Processes'!D23=I11,(2+J9),2)","v":2},"Only government or third party certified products",2,"National or regional web-based system",1,"Application is rejected and supplier is required to resubmit corrected application or missing information ",1,"Regulator approves the label request or provides a label for the certified product",1]
["Test reports are required, but not reviewed for accuracy by government or certification body",{"$f":"IF('III - Compliance Processes'!D23=I11,(1+J10),1)","v":1},"Mainly government or third party certified products, with exceptions (e.g. regulator or certification body missed certification approval deadline and products are automatically are approved) ",1,"Off-line product database (e.g. MS Excel based) ",0.5,"Application is given conditional approval, with a deadline to address issues ",0.5,"Supplier generates their own label, with no prior approvals from the Regulator",0.5]
["Test reports are not required ",0,"Products that are self certified by supplier",1,"None",0,"No action taken ",0,"No labels required",0]
[null,null,"Products are not registered ",0,null,null,"Products are self-certified by supplier",0.5]
[]
["Customs "]
["Do Customs Officers (or equivalent) check products and  documentation for  compliance at the border/ports? ",null,"Do Customs Officers (or equivalent) at the border/ports have access to the product registration system (database), so they can cross-check whether products are authorized to enter the country?",null,"What action is taken if products do not meet entry requirements at the border/port (i.e. do not have required or correct documentation, not registered in the database, etc.)?"]
["Yes, they conduct thorough inspections",2,"Yes",1,"Products are not allowed into the country or should be stored in a warehouse at the border/port of entry until the issues are addressed ",1]
["Customs officers (or equivalent) are aware of regulartory requirements and check produt energy efficiency or quality documentation, inspect the labels (when applicable) but do not check whether products are registered ",1.5,"No",0,"Products are allowed into the country on the condition that supplier addresses the issues before selling the products",0.5]
["Customs officers (or equivalent) have limited capacity - they check minimal requirements and/or check shipments at random",1,null,null,"Products are confiscated and destroyed ",0.25]
["No",0,null,null,"Products are not checked at the border ",0]
[]
["Market Monitoring"]
["Does the Regulator regularly conduct market surveillance activities? ",null,"How frequently does the Regulator conduct in-store and/or product document  inspections?",null,"Does the Regulator gather compliance intelligence through other methods (i.e. complaints, customs, product registration system)?",null,"Does the Regulator monitor online sales for potential non-compliance (ie. missing labels, suspicious claims, unregistered models, etc.)? "]
["Yes ",2,"Regularly (i.e. monthly, quarterly, every 6 months)",{"$f":"IF('III - Compliance Processes'!D37='Compl processes list'!G26,(1+'Compl processes list'!H23), 1)","v":1},"Yes",1,"Yes",1]
["No",0,"Occasionally (i.e. after policy revision, when donor or government funding is available, etc.)",{"$f":"IF('III - Compliance Processes'!D37='Compl processes list'!G26,(0.5+'Compl processes list'!H24), 0.5)","v":0.5},"Sometimes",0.5,"Not regularly",0.5]
[null,null,"No inspections are conducted",0,"No",0,"No",0]
[null,null,null,null,null,null,"Not applicable",0]
[]
["Verification Testing & Recording "]
["Does the Regulator conduct verification testing, to check whether products perform to standard and as claimed? ",null,"How are product selected for verification testing? ",null,"Where are products procured for verification testing?",null,"Does the Regulator keep an accessible record of market monitoring and verification testing activities, results, and non-compliant cases?"]
["Yes, regularly",1,"Based on risk levels (e.g. based on market intelligence information, previous test results, etc.) ",1,"From retail shops",1,"Yes",1]
["Ocassionally, when funding is available",0.5,"At random",0.5,"From supplier warehouses and/or retail shops",0.5,"Only certain results, such as verification testing and/or in-store labeling inspections",0.5]
["No",0,"No verification testing is conducted",0,"From supplier warehouses",0,"No",0]
[]
["Enforcement Actions"]
["Does the Regulator take enforcement action, both informal or formal, against non-compliant suppliers and products? ",null,"Are enforcement actions proportionate to the severity and impact of the offence (i.e. large fines or prosecution for worst, intentional, and most serious offences / informal warnings or requests to correct issues for small, unintentional, least serious offences)?",null,"Does the Regulator follow up with the supplier until the offence is corrected?"]
["Yes",2,"Yes",1,"Yes",1]
["Sometimes",1,"Sometimes",0.5,"Sometimes",0.5]
["No",0,"No",0,"No",0]
[]
[]
["Communicating Compliance Requirements, Activities, and Results"]
["Is information or guidance on policy compliance (i.e. how to comply, processes, FAQs) easily and publically accessible to stakeholders? ",null,"How is compliance information communicated to stakeholders? ",null,"How regularly is compliance information communicated to stakeholders? ",null,"Is information on market surveillance activities and results (anonomized or not) publically accessible to stakeholders? "]
["Yes - open access for all stakeholders ",2,"Diverse mechanisms - on regulator website, in the product registration system (database), via stakeholder distribution lists, in public announcements, in stakeholder meetings, and trainings",1,"Proactively - regularly and on an ongoing basis, continuous engagement with stakeholders",1,"Yes - information on activities and results are accessible ",1]
["Somewhat - limited access, for a fee, or only upon request ",1,"Limited mechanisms (e.g. on regulator website or via stakeholder distribution lists)",0.5,"Reactively - only when new information is available, when requested, or when funding available",0.5,"Somewhat - only information for some activities OR results are accessible ",0.5]
["No",0,"No communications",0,"Not at all ",0,"No ",0]
[]
[]
[]
["Regional Collaboration "]
["Does the Regulator engage in available regional or bi-lateral collaborations on compliance?",null,"Does the Regulator share compliance intelligence with other collaborating countries through available channels? ",null,"What  compliance intelligence and information does the Regulator share with other countries?"]
["Yes",1,"Yes, actively through regional or regionally connected product registration system (database), Mutual Recognition Agreement, or regular communication (e.g. regular meetings, online discussion forums, calls, etc.) ",1,"Information such as testing plans, test results, data on suspicious products, questions and lessons learned about compliance activities and challenges",1]
["Somewhat - on some aspects or occasionally",0.5,"Only some information",0.5,"Very limited information on test results, products and compliance processes",0.5]
["No",0,"No",0,"No",0]

{"sheet":"Definitions","index":7,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,14],[14,0,14,14],[9,0,9,14],[10,0,10,14],[11,0,11,14],[12,0,12,14],[0,0,1,14],[5,0,5,14],[6,0,6,14],[7,0,7,14],[8,0,8,14],[2,0,2,14]]}
["DEFINITIONS"]
[]
["Here we provide definitions for common compliance terms used in this assessment."]
[]
[]
["Administrative Guidelines are a complementary to the legislation providing clear and consistent guidance to the energy efficiency compliance program administrators and stakeholders to better understand processes and requirements."]
["Certification  is the validation of performance by a third-party (i.e. not the product suppliers) in order to demonstrate that the product meets labelling or standards requirements, ensuring consistency, and giving credibility to claims about energy efficiency. In cases of Supplier's Declaration of Conformity, the certification is declared by the supplier."]
["Compliance  is a conformance to a rule, such as a law, policy, specification or standards. In this case conformance is to the requirements for all participants in the energy efficiency or quality program, as specified in relevant laws, regulations and associated administrative arrangements for appliances, lighting, and equipment."]
["Conformity Assessment  is a demonstration that specified requirements relating to a product, process, system, person or body are fulfilled. (ISO/IEC 17000: 2004) Includes testing, certifying, and registering products to ensure they conform to requirements, before they are allowed on a market."]
["Enforcement includes the actions taken by an authority in response to incidents of non-compliance with the rules of a program."]
["Market Surveillance includes activities required to monitor and check compliance with energy efficiency or quality program requirements, once products are in the marketplace (e.g. market monitoring and inspections, verification testing)."]
["Non-Compliance is any instance deemed by the compliance authority to be discordant with requirements of a program."]
["Product Registration System (or Database)  is an energy efficiency program tool  that  captures energy efficiency specific  information  on  products  available  on  the  market, serving as the initial  gateway for products to  be placed  on  a market."]
["Supplier encompasses manufacturer, importer or distributor of appliances or products included in energy efficiency or quality program."]
["Verification Testing in energy efficiency and quality programs is used to prove the performance of a product with regard to its performance and quality in accordance with the specified test methodology. This can be done, depending on program requirements, either independently, via a third party laboratory or in government laboratory."]

{"sheet":"Recom list","index":8,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,null,"Key Priority","High"]
[null,null,"Secondary Priority","Medium "]
[null,null,"No Improvement","Low"]
[]
["Indicator","Areas","Recommendation - Key Priority","Level of Effort - Key Priority","Who? -  Key priority","Recommendation - Secondary Priority","Level of Effort - Secondary Priority","Who - Secondary Priority"]
["Regulation","Regulations - Key Provisions","Adopt or revise the existing regulation with critical provisions such as roles and responsibilities, offences and penalties, which is foundational to effective policy compliance. ","Low"," - Relevant government agency(-ies)\n - Expert technical assistance ","Revise appropriate regulation(s) for policy enforcement to include missing key provisions such as roles and responsibilities, offences and penalties. ","Low"," - Relevant government agency(-ies)\n -  Expert technical assistance "]
["Regulation","Regulations - Additional Provisions","Adopt or revise the existing regulation with additional provisions for product ceritfication and registration and market surveillance powers, which are essential for effectively setting up  policy compliance processes. ","Low"," - Relevant government agency(-ies)\n - Expert technical assistance ","Revise appropriate regulation(s) to include missing provisions for product ceritfication and registration, and market surveillance powers, which are essential for effectively setting up policy compliance processes. ","Low"," - Relevant government agency(-ies)\n - Expert technical assistance "]
["Regulation","Other - Administrative Guidelines","Develop administrative guidance to complement the regulation that outlines in detail compliance processes and requirements.","Medium "," - Relevant government agency(-ies)\n - Expert technical assistance ","Ensure that available administrative guidance is comprehensive and clear for stakeholders. ","Low"," - Relevant government agency(-ies)\n - Expert technical assistance "]
["Resources","Institutional Collaboration","Identify Regulator, assign responsibilities and establish institutional collaboration with key agencies (e.g. customs) reponsible for policy enforcement before setting up compliance processes.","Low"," - Relevant government agency(-ies)","Before setting up compliance processes, ensure that responsibilities are identified for key agencies and  institutional collaboration is established with key agencies engaged in policy enforcement.","Low","Relevant government agency(-ies)"]
["Resources","Human Capital","Ensure sufficient staffing with adequate training and knowledge to implement compliance processes.","Medium "," - Internal resources\n - Knowledge sharing opportunities, trainings\n - Expert technical assistance ","Ensure that compliance staff is sufficient with adequate training and knowledge to implement compliance processes.","Medium "," - Internal resources\n - Knowledge sharing opportunities, trainings\n - Expert technical assistance "]
["Resources","Product Registration System","Invest in product registration system - a tool to record  information on all registered products available on the market. ","High","  - Expert technical assistance\n -  Software developer ","Ensure that appropriate registration system is developed and and used to support policy compliance processes."," - "," - "]
["Resources","Access to testing","Identify existing independent testing facilities in country/region/outside region for testing products. Alternatively, when financially viable, build national testing lab.","Low/High"," -  Lab equipment provider and expert technical assistance (establishing Lab)","Seek access to independent testing facilities in country/region/outside region for testing products. Alternatively, when financially viable, build national testing laboratory.","Low/High"," -  Lab equipment provider and expert technical assistance (establishing Lab)"]
["Resources","Other Resources","Assess what tools and other resources are needed for effective compliance enforcement,  secure funding for and obtain the needed tools and resources.","Medium/High"," - ","Assess what additional tools and resources are needed for effective compliance enforcement,  secure funding for and obtain the necessary tools and resources.","Medium/High"," - "]
["Resources","Budget/Funding","Secure sustainable funding that is appropriate for country's policy compliance enforcement."," - "," - ","Ensure country's policy compliance enforcement has adequate funding from the sustainable sources."," - "," - "]
["Processes - Certification & Registration","Product certification and registration","Set up certification and regsitration processes that minimize the non-compliant products entering the country including accepting test reports only from independent accredited labs and certified by independent certification bodies/government agencies. ","Medium/High"," - Relevant government agency(-ies)\n - Expert technical assistance ","Ensure that existing certification and regsitration processes minimize the non-compliant products entering the market. ","Low/Medium"," - Relevant government agency(-ies)\n - Expert technical assistance "]
["Processes - Certification & Registration","Customs check","Set up collaboration mechanism with Customs (or equivalent) to check product compliance at the port of entry to prevent non-compliant products from entering the country.","Medium"," - Relevant government agency(-ies)\n - Expert technical assistance ","Improve collaboration mechanism with Customs (or equivalent) to check product compliance at the port of entry and prevent non-compliant products from entering the country.","Low/Medium"," - Relevant government agency(-ies)\n - Expert technical assistance "]
["Processes - Market Surveillance & Enforcement","Market inspections","Develop plan for surveilling product market. Select budget- and market-appropriate  monitoring activities to effectively identify suspicious and  non-compliant products.","Medium/High"," - Relevant government agency(-ies)\n - Expert technical assistance ","Improve market surveillance strategies that are budget- and market-appropriate to effectively identify suspicious and  non-compliant products.","Medium/High"," - Relevant government agency(-ies)\n - Expert technical assistance "]
["Processes - Market Surveillance & Enforcement","Verification testing","Budget permitted, conduct verification testing as per best practices (e.g. target the high-risk products) to ensure the accuracy and reliability of testing results. If the in-coutry test lab is not available, seek out to outsource testing to test labs outside the country.","Medium/High"," - Relevant government agency(-ies)","Budget permitted, conduct regular verification testing as per best practices to ensure the accuracy and reliability of testing results and target the high-risk products.","Medium/High"," - Relevant government agency(-ies)"]
["Processes - Market Surveillance & Enforcement","Record keeping","Set up procedures to record and keep the records from market surveillance activities, and utilize them to inform enforcement actions and future market surveillance.","Low"," - Relevant government agency(-ies)","Improve procedures to record and keep the records from market surveillance activities to inform enforcement actions and future market surveillance.","Low"," - Relevant government agency(-ies)"]
["Processes - Market Surveillance & Enforcement","Enforcement","Set up procedures and processes for taking appropriate and proportionate enforcement actions to rectify non-compliance.","Low"," - Relevant government agency(-ies)","Ensure that procedures and processes are appropriate and proportionate enforcement actions are taken for to rectify each non-compliance.","Low"," - Relevant government agency(-ies)"]
["Compliance Communication","Communicating requirements","Identify and set up appropriate approaches to communicate compliance requirements and procedures to improve compliance.","Low/Medium "," - Relevant government agency(-ies)\n - Expert technical assistance \n - Associations, other Organizations ","Ensure that existing approaches to communicate compliance requirements and procedures are appropriate to inform stakeholders of requirements and compliance processes. ","Low/Medium "," - Relevant government agency(-ies)\n - Expert technical assistance \n - Associations, other Organizations "]
["Compliance Communication","Communicating non-compliance","Establish country-relevant  procedures to report market surveillance actions and non-compliance to stakeholders  to deter future non-compliance.","Low/Medium "," - Relevant government agency(-ies)","Ensure that appropriate procedures are in place to report relevant market surveillance actions and non-compliances to stakeholders  to deter future non-compliance.","Low/Medium "," - Relevant government agency(-ies)"]

{"sheet":"Reg list","index":9,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":true,"merged":[[13,2,13,3]]}
["Regulatory Framework - gateaway question"]
["Does the country have regulation (or provisions) to implement and enforce product energy efficiency or quality policies, including offences, penalties, etc.?",null,"Action"]
["Yes",null,"Go to Question I.1"]
["The regulation is under development ",null,"Go to Question I.1"]
["No",null,"This assessment is not applicable for the country. You do not need to answer any further questions. To get more guidance and information on how to set up regulatory framework and compliance processes, please refer to the CLASP Guidebook and compliance resources on clasp.ngo."]
[]
["Key provisions"]
["Does the regulation identify and define roles and responsibilities of key actors (i.e. regulator/enforcement authority, product manufacturer, retailer, etc. )?",null,"Does the regulation identify and define potential offences? ",null,"Does the regulation provide a range of penalties or other enforcement actions for non-compliance? ",null,"Does the regulation define manufacturer, importer, and retailer requirements? "]
["Yes",2,"Yes",2,"Yes, a range of penalties are provided to address different types of offences",2,"Yes, there are requirements for all ",2]
["Some is covered, but some is missing",1,"Some offences are defined",1,"Only severe penalties are provided to address severe offences",1,"There are requirements for some, but not all",1]
["No",0,"No",0,"No, the regulation includes no penalties",0,"No, there are no requirements",0]
[]
["Additional provisions"]
["What type of test report is required to prove the product is compliant with the standards? ",null,"How are the product certified, to be authorized for sale on the market? ",null,"Do products need to be registered in a national/regional product registry (database), before they can be sold on the market? ",null,"Does the regulation define market surveillance powers for regulator/compliance authority? "]
["Report from only an accredited 3rd party laboratory",1,"3rd party or government certification ",1,"Products must be registered in an electronic product registry (database)",1,"Yes",1]
["Report from any 3rd party laboratory",0.75,"Self-certification by the supplier",0.5,"Products must be registered in a paper-based system",0.5,"No",0]
["Report from an accredited 3rd party or manufacturer laboratory",0.5,"No certification required",0,"No, products do not need to be registered in a product registry (database)",0]
["Report from any 3rd party or manufacturer laboratory",0.25]
["No test report is required OR testing is done by government",0]
[]
["Other - Administrative Guidelines"]
["Is any explanation on processes and requirements made available, in addition to the regulation, for example in the form of Administrative Guidelines  (i.e. guidelines, FAQs, or standard operating procedures) that provide more detail and guidance on how to implement and comply with the policy? "]
["Yes, the program has clear guidance complimenting regulation",1]
["There is guidance in different documents, but not in one document",0.5]
["The guidance is under development",0.5]
["No",0]

{"sheet":"Res list","index":10,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Institutional Framework and Human Capital"]
["Has a Regulator been assigned responsibility for ensuring compliance with the regulations? ",null,"Is the Regulator actively implementing all their assigned responsibilities (ie. conformity assessment, market surveillance, enforcement, reporting, etc.)?",null,"Have the roles and responsibilities been clearly defined and assigned between agencies if there is a need for their support for compliance processes?",null,"Is compliance program sufficiently staffed? ",null,"Is compliance staff trained, knowledgeable, and able to execute their duties? "]
["Yes",2,"Yes",2,"Yes",1,"Yes",1,"Yes",1]
["In process",1,"The regulator performs some but not all responsibilities ",1,"Partially",0.5,"The program is partially staffed",0.5,"Partially",0.5]
["No",0,"Not yet or responsibilities have not been set yet",0,"No",0,"Not staffed at all",0,"No",0]
[null,null,null,null,null,null,"I don't know",0]
["Access to Infrastructure"]
["Does the energy efficiency program use a product registration system (database)?",null,"Does the Regulator have access to test facilities, in-country or abroad, to conduct verification testing of products?",null,"Does the team have the tools and physical resources they need to conduct compliance activities  (e.g. computers, mobile phones, etc.)? "]
["Yes",3,"Yes, government and/or third party laboratories",2,"Yes",1]
["Under development",2,"Yes, manufacturer laboratories",1,"Some, but not all that are needed",0.5]
["No",0,"No access to testing facilities",0,"No",0]
[null,null,"I do not know",0]
["Budget/Funding"]
["Is there sufficient funding to conduct compliance activities?",null,"How is the energy efficiency program implementation and enforcement funded? "]
["Yes",1,"Government funding, supplemented by application and registration fees",2]
["Some, but not enough",0.5,"Government funding only ",2]
["No",0,"Government funding, supplemented by donor funding",1]
["I don't know",0,"Donor funding only ",0.5]
[null,null,"No funding",0]

{"sheet":"Scorecard lists","index":11,"n_rows":96,"n_cols":10,"rows_kept":96,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Country","Year","Products","Policy Instrument","Evaluation","Product Market","Compliance",null,"Product Energy Source"]
[null,"Algeria",2020,"Air Conditioner","Minimum Energy Performance Standards (MEPS)","Extremely High Non-Compliance Risk indicates that the likelihood of non-compliant products circulating the market is very high and of grave concern.","Imported","Yes","Yes","On-grid"]
[null,"Argentina",2021,"Refrigerator","Energy Labeling ","High Non-Compliance Risk indicates that the likelihood of non-compliant products circulating the market is high and of great concern.","Imported and Locally Manufactured","No ","No ","Off-grid"]
[null,"Australia",2022,"Lighting","MEPS and Energy Labeling ","Medium Non-Compliance Risk indicates that the likelihood of non-compliant products circulating the market is somewhat concerning.","Locally Manufactured","Under development","Don't know"]
[null,"Bahrain",2023,"Electric Motor",null,"Low Non-Compliance Risk indicates that the likelihood of non-compliant products circulating the market is relatively low."]
[null,"Bangladesh",2024,"Television",null,"Minimal Non-Compliance Risk indicates that the likelihood of non-compliant products circulating the market is very low."]
[null,"Barbados",2025,"Transformers",null,"Refer to CLASP Guidebook and Decision Tree for guidance on developing accompanying regulation and setting up policy compliance processes"]
[null,"Botswana",2026,"Electric Fans"]
[null,"Brazil",2027,"Washing Machines "]
[null,"Brunei Darussalam"]
[null,"California"]
[null,"Cambodia"]
[null,"Canada"]
[null,"Chile"]
[null,"China "]
[null,"Colombia"]
[null,"Cook Islands"]
[null,"Costa Rica"]
[null,"Cuba"]
[null,"Dominican Republic"]
[null,"ECOWAS"]
[null,"Ecuador"]
[null,"Egypt"]
[null,"El Salvador"]
[null,"Ethiopia"]
[null,"European Union"]
[null,"Fiji"]
[null,"Ghana"]
[null,"Guatemala"]
[null,"Guyana"]
[null,"Honduras"]
[null,"Hong Kong"]
[null,"Iceland"]
[null,"India"]
[null,"Indonesia"]
[null,"Iran"]
[null,"Israel"]
[null,"Jamaica"]
[null,"Japan"]
[null,"Jordan"]
[null,"Kenya"]
[null,"Kingdom of Saudi Arabia"]
[null,"Kiribati"]
[null,"Kuwait"]
[null,"Lao's People Democratic Republic"]
[null,"Lebanon"]
[null,"Madagascar"]
[null,"Malaysia"]
[null,"Maldives"]
[null,"Mauritius"]
[null,"Mexico"]
[null,"Namibia"]
[null,"New Zealand"]
[null,"Nicaragua"]
[null,"Nigeria"]
[null,"Norway"]
[null,"Oman"]
[null,"Pakistan"]
[null,"Pakistan"]
[null,"Panama"]
[null,"Paraguay"]
[null,"Peru"]
[null,"Philippines"]
[null,"Qatar"]
[null,"Republic of Korea"]
[null,"Russia"]
[null,"Russia"]
[null,"Rwanda"]
[null,"Saint Lucia"]
[null,"Samoa"]
[null,"Senegal"]
[null,"Seychelles"]
[null,"Singapore"]
[null,"Solomon Islands"]
[null,"South Africa"]
[null,"Sri Lanka"]
[null,"Switzerland"]
[null,"Taiwan (Republic of China)"]
[null,"Tajikistan"]
[null,"Tanzania"]
[null,"Thailand"]
[null,"The Gambia"]
[null,"Tonga"]
[null,"Tunisia"]
[null,"Turkey"]
[null,"Tuvalu"]
[null,"Uganda"]
[null,"Ukraine"]
[null,"United Arab Emirates"]
[null,"United Kingdom"]
[null,"United States of America"]
[null,"Uruguay"]
[null,"Vanuatu"]
[null,"Venezuela"]
[null,"Vietnam"]