{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions & Tool","Summary & Results","Radio Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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 & Tool","index":0,"n_rows":64,"n_cols":17,"rows_kept":64,"cut":false,"hidden":false,"merged":[[4,1,4,11],[7,1,7,7],[9,1,9,7],[21,13,21,14],[21,15,21,16],[11,1,11,8],[20,1,20,8],[21,3,21,8],[63,1,63,2],[57,3,57,8],[58,3,58,8],[63,3,63,8],[45,1,45,2],[59,3,59,8],[60,3,60,8],[61,3,61,8],[51,3,51,8],[52,3,52,8],[54,3,54,8],[56,1,56,8],[54,1,54,2],[22,3,22,8],[23,3,23,8],[38,1,38,8],[39,3,39,8],[40,3,40,8],[24,3,24,8],[25,3,25,8],[27,3,27,8],[29,1,29,8],[30,3,30,8],[27,1,27,2],[36,1,36,2],[36,3,36,8],[31,3,31,8],[32,3,32,8],[33,3,33,8],[34,3,34,8],[50,3,50,8],[41,3,41,8],[42,3,42,8],[43,3,43,8],[49,3,49,8],[45,3,45,8],[47,1,47,8],[48,3,48,8]]}
[]
[]
[]
[]
[null,"R-SEAT Center Technology Transfer and Transformation Potential Documentation "]
[]
[null,"Instructions"]
[null,"This Excel Workbook is developed to document R-SEAT Center projects' technology transfer and transformation potential (mainly through throughstakeholder engagement) at proposal and post-project completion stages. The document the has been developed by R-SEAT Center with modifications on New York State Energy and Research Development Authority's (NYSERDA)  documentation on Technology Readiness Level (TRL) and Commercial Readiness Level (CRL) of emerging products/innovations (which is in turn based on the systems developed by NASA, DOE, and ARPA-E). \n\nFor each category, select the button next to the description that best fits the status of your project. Once all categories have been completed, go to \"Summary & Results\" tab to view your scores and answers. "]
[]
[]
[]
[null,"Profile"]
[]
[null,"Company/Organization Name"]
[]
[null,"Proposal Title"]
[]
[null,"Product/Innovation Description"]
[]
[]
[null,"Technology Readiness Level",null,null,null,null,null,null,null,null,1,"Progress in Category"]
[null,null,1,"Basic Research (Basic principles and research; Application formulated)",null,null,null,null,null,null,"TRL 1",{"$f":"IF($K$21>=1,1,0)","v":1},null,"TRL",null,"CRL"]
[null,null,2,"Basic Research (Proof of concept )",null,null,null,null,null,null,"TRL 2",{"$f":"IF($K$21>=2,1,0)","v":0},null,1,{"$f":"IF(L22=1,\"Yes\", \"No\")","v":"Yes"},1,{"$f":"IF(AND(L49=1,L58=1),\"Yes\",\"No\")","v":"Yes"}]
[null,null,3,"Applied Research (Components validated in a laboratory environment;Integrated components demonstrated in a laboratory environment)",null,null,null,null,null,null,"TRL 3",{"$f":"IF($K$21>=3,1,0)","v":0},null,2,{"$f":"IF(L23=1,\"Yes\", \"No\")","v":"No"},2,{"$f":"IF(AND(L50=1,L59=1),\"Yes\",\"No\")","v":"No"}]
[null,null,4,"Development (Prototype demonstrated in a relevant environment; Prototype demonstrated in operational environment; Technology proven in operational environment)",null,null,null,null,null,null,"TRL 4",{"$f":"IF($K$21>=4,1,0)","v":0},null,3,{"$f":"IF(L24=1,\"Yes\",\"No\")","v":"No"},3,{"$f":"IF(AND(L31=1,L40=1,L51=1,L59=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,null,5,"Implementation (Technology refined and adopted)",null,null,null,null,null,null,"TRL 5",{"$f":"IF($K$21>=5,1,0)","v":0},null,4,{"$f":"IF(L25=1,\"Yes\",\"No\")","v":"No"},4,{"$f":"IF(AND(L41=1,L52=1,L60=1,#REF!=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(L26=1,\"Yes\",\"No\")","v":"No"},5,{"$f":"IF(AND(L43=1,L53=1,L60=1,#REF!=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,"Answer",null,{"$f":"VLOOKUP(K21,C22:H26,2)","v":"Basic Research (Basic principles and research; Application formulated)"},null,null,null,null,null,null,null,null,null,6,{"$f":"IF(AND(L32=1,L42=1),\"Yes\",\"No\")","v":"No"},6,{"$f":"IF(AND(L44=1,L61=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(L33=1,\"Yes\",\"No\")","v":"No"},7,{"$f":"IF(AND(L61=1,#REF!=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,"Public Sector Stakeholder Engagement",null,null,null,null,null,null,null,null,1,null,null,8,{"$f":"IF(L34=1,\"Yes\",\"No\")","v":"No"},8,{"$f":"IF(AND(L62=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,null,1,"No communication or engagement with public stakeholders ",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$30>=1,1,0)","v":1},null,9,{"$f":"IF(L35=1,\"Yes\",\"No\")","v":"No"},9,{"$f":"IF(AND(L62=1,#REF!=1),\"Yes\",\"No\")","v":{"$error":"#REF!"}}]
[null,null,2,"Public stakeholder(s) are identified but NOT communicated/engaged",null,null,null,null,null,null,"TRL 6",{"$f":"IF($K$30>=2,1,0)","v":0}]
[null,null,3,"Public stakeholder(s) are communicated/engaged (requires proof of engagement, such as emails, meeting notes, letters of support)",null,null,null,null,null,null,"TRL 7",{"$f":"IF($K$30>=3,1,0)","v":0}]
[null,null,4,"Public stakeholder(s) are a part of the study (requires proof of engagement such as data/time/personnel commitment, data/information sharing agreement, letter of support, pilot study partnering)",null,null,null,null,null,null,"TRL 8",{"$f":"IF($K$30>=4,1,0)","v":0},null,"TRL Score",{"$f":"IF(O31=\"Yes\",9,IF(O30=\"Yes\",8,IF(O29=\"Yes\",7,IF(O28=\"Yes\",6,IF(O27=\"Yes\",5,IF(O26=\"Yes\",4,IF(O25=\"Yes\",3,IF(O24=\"Yes\",2,IF(O23=\"Yes\",1,\"Error\")))))))))","v":1}]
[null,null,5,"Public stakeholder(s) adopted the project solutions/recommendations (requires proof of engagement such as modifications in actual policy/planning/operations)",null,null,null,null,null,null,"TRL 9",{"$f":"IF($K$30>=5,1,0)","v":0},null,"CRL Score",{"$f":"IF(Q31=\"Yes\",9,IF(Q30=\"Yes\",8,IF(Q29=\"Yes\",7,IF(Q28=\"Yes\",6,IF(Q27=\"Yes\",5,IF(Q26=\"Yes\",4,IF(Q25=\"Yes\",3,IF(Q24=\"Yes\",2,IF(Q23=\"Yes\",1,\"Error\")))))))))","v":{"$error":"#REF!"}}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K30,C31:H35,2)","v":"No communication or engagement with public stakeholders "}]
[]
[null,"Private Sector Stakeholder Engagement",null,null,null,null,null,null,null,null,1]
[null,null,1,"No communication or engagement with private stakeholders ",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$39>=1,1,0)","v":1}]
[null,null,2,"Private stakeholder(s) are identified but NOT communicated/engaged",null,null,null,null,null,null,"CRL 4",{"$f":"IF($K$39>=2,1,0)","v":0}]
[null,null,3,"Private stakeholder(s) are communicated/engaged (requires proof of engagement, such as emails, meeting notes, letters of support)",null,null,null,null,null,null,"TRL 6",{"$f":"IF($K$39>=3,1,0)","v":0}]
[null,null,4,"Private stakeholder(s) are a part of the study (requires proof of engagement such as data/time/personnel commitment, data/information sharing agreement, app/technology development pilot study partnering, letters of support)",null,null,null,null,null,null,"CRL 5",{"$f":"IF($K$39>=4,1,0)","v":0}]
[null,null,5,"Private stakeholder(s) adopted the project solutions/recommendations (requires proof of engagement such as modifications in business plans, mobile app)",null,null,null,null,null,null,"CRL 6",{"$f":"IF($K$39>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K39,C40:H44,2)","v":"No communication or engagement with private stakeholders "}]
[]
[null,"Community Stakeholder Engagement",null,null,null,null,null,null,null,null,1]
[null,null,1,"No communication or engagement with community stakeholders ",null,null,null,null,null,null,"CRL 1",{"$f":"IF($K$48>=1,1,0)","v":1}]
[null,null,2,"Community stakeholder(s) are identified but NOT communicated/engaged",null,null,null,null,null,null,"CRL 2",{"$f":"IF($K$48>=2,1,0)","v":0}]
[null,null,3,"Community stakeholder(s) are communicated/engaged (requires proof of engagement, such as emails, meeting notes, letters of support)",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$48>=3,1,0)","v":0}]
[null,null,4,"Community stakeholder(s) are a part of the study (requires proof of engagement such as data/time/personnel commitment, data/information sharing agreement, app/technology development pilot study partnering, letters of support)",null,null,null,null,null,null,"CRL 4",{"$f":"IF($K$48>=4,1,0)","v":0}]
[null,null,5,"Community stakeholder(s) adopted the project solutions/recommendations (requires proof of engagement such as modifications in business plans, mobile app)",null,null,null,null,null,null,"CRL 5",{"$f":"IF($K$48>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K48,C49:H53,2)","v":"No communication or engagement with community stakeholders "}]
[]
[null,"Education/Training Partner Engagement",null,null,null,null,null,null,null,null,1]
[null,null,1,"No communication or engagement with education/training partner",null,null,null,null,null,null,"CRL 1",{"$f":"IF($K$57>=1,1,0)","v":1}]
[null,null,2,"Education/training partner(s) are identified but NOT communicated/engaged",null,null,null,null,null,null,"CRL 2-3",{"$f":"IF($K$57>=2,1,0)","v":0}]
[null,null,3,"Education/training partner(s) are communicated/engaged (requires proof of engagement, such as emails, meeting notes, letters of support)",null,null,null,null,null,null,"CRL 4-5",{"$f":"IF($K$57>=3,1,0)","v":0}]
[null,null,4,"Education/training partner(s) are a part of the study (requires proof of engagement such as data/time/personnel commitment, letters of support)",null,null,null,null,null,null,"CRL 6-7",{"$f":"IF($K$57>=4,1,0)","v":0}]
[null,null,5,"Private stakeholder(s) adopted the project solutions/recommendations (requires proof of engagement such as training programs, new courses, etc.)",null,null,null,null,null,null,"CRL 8-9",{"$f":"IF($K$57>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K57,C58:H62,2)","v":"No communication or engagement with education/training partner"}]

{"sheet":"Summary & Results","index":1,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,1,4,11],[6,1,6,12],[22,6,22,12],[23,6,23,12],[24,6,24,12],[24,1,24,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[21,6,21,12],[20,6,20,12],[19,6,19,12]]}
[]
[]
[]
[]
[null,"R-SEAT Center Technology Transfer and Transformation Potential Documentation "]
[]
[null,"Profile"]
[]
[null,"Company/Organization Name:",null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Tool'!H14","v":0}]
[]
[null,"Proposal Title:",null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Tool'!H16","v":0}]
[]
[null,"Product/Innovation Description:",null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Tool'!H18","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Category",null,null,null,null,"Answer"]
[null,{"$f":"'Radio Data'!B2","v":"Technology Readiness Level"},null,null,null,null,{"$f":"'Instructions & Tool'!D28","v":"Basic Research (Basic principles and research; Application formulated)"}]
[null,{"$f":"'Radio Data'!B3","v":"Public Sector Stakeholder Engagement"},null,null,null,null,{"$f":"'Instructions & Tool'!D37","v":"No communication or engagement with public stakeholders "}]
[null,{"$f":"'Radio Data'!B4","v":"Private Sector Stakeholder Engagement"},null,null,null,null,{"$f":"'Instructions & Tool'!D46","v":"No communication or engagement with private stakeholders "}]
[null,{"$f":"'Radio Data'!B5","v":"Community Stakeholder Engagement"},null,null,null,null,{"$f":"'Instructions & Tool'!D55","v":"No communication or engagement with community stakeholders "}]
[null,{"$f":"'Radio Data'!B6","v":"Education/Training Partner Engagement"},null,null,null,null,{"$f":"'Instructions & Tool'!D64","v":"No communication or engagement with education/training partner"}]

{"sheet":"Radio Data","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"'Instructions & Tool'!B21","v":"Technology Readiness Level"},{"$f":"'Instructions & Tool'!K21","v":1}]
[null,{"$f":"'Instructions & Tool'!B30","v":"Public Sector Stakeholder Engagement"},{"$f":"'Instructions & Tool'!K30","v":1}]
[null,{"$f":"'Instructions & Tool'!B39","v":"Private Sector Stakeholder Engagement"},{"$f":"'Instructions & Tool'!K39","v":1}]
[null,{"$f":"'Instructions & Tool'!B48","v":"Community Stakeholder Engagement"},{"$f":"'Instructions & Tool'!K48","v":1}]
[null,{"$f":"'Instructions & Tool'!B57","v":"Education/Training Partner Engagement"},{"$f":"'Instructions & Tool'!K57","v":1}]
[null,{"$f":"'Instructions & Tool'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions & Tool'!#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Instructions & Tool'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions & Tool'!#REF!","v":{"$error":"#REF!"}}]