{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Template","Completed Example","Inputs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":4,"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":"Instructions","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,2,2,3],[4,2,4,3],[6,2,6,3]]}
[null,"EVALUABILITY MAPPING TOOL"]
[]
[null,"HOW TO USE THE TOOL\n\nThis section explains how to read, interpret, and populate this tool.","The \"Template\" worksheet tab is a blank slate with columns and prompts (the colorful questions shown above the columns) to collect and examine qualitative program data in different programs. \nThe prompts provide guidance to both fill in the data and understand/compare results. \nThe \"Timeframe\" column includes options for results expected in the short-term, mid-term, and long-term, or any combination of those options.\nThis tool has some macro-enabled functionality, so please see the section below to create new worksheet tabs that retain this functionality.\nPlease review the \"Completed Example\" worksheet tab for an example of how to complete and interpret the information contained in this tool."]
[]
[null,"HOW TO CREATE NEW WORKSHEET TABS\n\nThis section describes the method to add new worksheets and maintain the macros/code functionality.","Right-click the Template tab below and select \"Move or Copy…\" \nFor the \"To Book\" option, leave the default workbook the same (this one).\nFor the \"Before Sheet\" option, select \"(move to end)\".\nCheck the box next to \"Create a copy\" and click OK.\nDouble-click the name of the new tab and change the name as appropriate."]
[]
[null,"ADDITIONAL NOTES\n\nThis section covers some additional topics and questions to help you make the most of this tool.","There is an \"Additional Info/Notes\" column included in the tool as a place to provide additional information or context. \nThere is a hidden \"Inputs\" worksheet tab that populates the drop-down menu in the template. To show this worksheet tab, right-click on any worksheet tab at the bottom of your screen, select \"Unhide,\" choose \"Inputs\" (or any other hidden tab you want to see), and click OK. The \"Inputs\" worksheet tab will now be visible and you can add or edit as needed. To re-hide the worksheet tab, right-click on the \"Inputs\" worksheet tab at the bottom of your screen and select \"Hide.\""]

{"sheet":"Template","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4],[4,3,4,4],[5,7,6,7],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,5,6]]}
[null,"EVALUABILITY MAP"]
[null,null,"PROJECT TITLE","SECTOR/DIVISION",null,"PROJECT MANAGER","DATE","VERSION"]
[null,null,null,null,null,null,null,"0.0.0"]
[]
[null,null,"WHAT are your strategies for accelerating adoption of the technology/practice/policy you are targeting?","WHAT evidence do we expect to see in the market If we conduct these interventions? In 1-2 years? In 3-4 years? In 5 years (List All)",null,"WHAT will we count/estimate/track to know we're making progress?","WHAT data sources will we use to count/estimate/track?"]
[null,"MPI #","LINKAGE (cause and effect)","MARKET PROGRESS INDICATOR","TIMEFRAME","METRICS",null,"ADDITIONAL INFO/NOTES"]
[null,null,null,null,null,"DEFINITION","DATA SOURCE"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]

{"sheet":"Completed Example","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,5,5,6],[5,7,6,7],[7,2,9,2],[10,2,11,2],[13,2,14,2],[15,2,17,2],[1,3,1,4],[2,3,2,4],[4,3,4,4],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4]]}
[null,"EVALUABILITY MAP"]
[null,null,"PROJECT TITLE","SECTOR/DIVISION",null,"PROJECT MANAGER","DATE","VERSION"]
[null,null,null,null,null,null,null,"0.0.0"]
[]
[null,null,"WHAT are your strategies for accelerating adoption of the technology/practice/policy you are targeting?","WHAT evidence do we expect to see in the market If we conduct these interventions? In 1-2 years? In 3-4 years? In 5 years (List All)",null,"WHAT will we count/estimate/track to know we're making progress?","WHAT data sources will we use to count/estimate/track?"]
[null,"MPI #","LINKAGE (cause and effect)","MARKET PROGRESS INDICATOR","TIMEFRAME","METRICS",null,"ADDITIONAL INFO/NOTES"]
[null,null,null,null,null,"DEFINITION","DATA SOURCE"]
[null,1,"Develop, deploy, and support training, tools and resources to increase code and policy compliance and support authorities having jurisdiction with their enforcement duties","Code officials trained​","ST"," Number trained​","Training registration data​"]
[null,2,null,"Trained professionals demonstrate increased capability and expertise​","MT","Self-reported number/ proportion trained making code implementation changes​","Training follow-up surveys​"]
[null,3,null,"Increased code compliance​","LT","Estimated compliance​","Expert panel​"]
[null,4,"Develop stretch energy codes and uniform codes revisions to promote efficiency, flexibility and decarbonization. Develop and advance other policies and regulations to promote similar outcomes. ​","Regulations/policies developed by NYSERDA and shared with policymakers​","ST, MT","Number developed and shared​","NYSERDA program documentation​"]
[null,5,null,"Regulations/policies updated ​","MT, LT","Number updated​","Jurisdiction policy documents​"]
[null,6,"Use pilots to test, refine, and scale new approaches to code and policy development, advancement, enactment, compliance and enforcement ​","Communities adopt pilot approaches​","MT","Number of communities piloting​","- Targeted community decision makers (interviews)​\n- Official documentation of pilot implementation​"]
[null,7,"Work with partners and stakeholders to support adoption and enactment of State & local policies to promote efficiency, flexibility, and decarbonization in buildings ","Stakeholders/influencers support adoption/ enactment","MT","Number of targeted stakeholders/influencers supporting (X of Y)​","- Targeted SH/influencer interviews​\n- Code proceedings"]
[null,8,null,"Policies/codes adopted at the state or local level ​","LT",null,"Policy documents​"]
[null,9,"Engage and develop capabilities of design and construction professionals via New Construction and Buildings of Excellence initiatives, to prove the feasibility, performance, and cost-effectiveness of CNB","Design & construction professionals engaged​","ST","Number of builders engaged​","- Program documentation​\n- Builder survey​\n- Design professional survey"]
[null,10,null,"Buildings constructed​","MT","Buildings built​","- Program data​\n- Building permit or Dodge data"]
[null,11,null,"Performance data provided to policymakers​","LT","- Documentation of data submitted​\n- Self reported data influence","- Code proceedings​\n- Targeted decision-maker Interviews"]
[null,12,"Codes and policies are adopted and enacted faster than they would without NYSERDA’s intervention","N/A","N/A","Policies/compliance rate/% impact that would have been achieved without CSCNB","Delphi panel (expert judging)"]

{"sheet":"Inputs","index":3,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Timeframe"]
["ST"]
["MT"]
["LT"]
["N/A"]