{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions & Tool","Summary & Results","Radio Data"],"not_rendered":{"charts":1,"images":1,"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":82,"n_cols":17,"rows_kept":82,"cut":false,"hidden":false,"merged":[[51,3,51,8],[52,3,52,8],[54,3,54,8],[56,1,56,8],[81,3,81,8],[74,1,74,8],[75,3,75,8],[76,3,76,8],[77,3,77,8],[78,3,78,8],[79,3,79,8],[81,1,81,2],[31,3,31,8],[32,3,32,8],[33,3,33,8],[34,3,34,8],[50,3,50,8],[54,1,54,2],[59,3,59,8],[60,3,60,8],[61,3,61,8],[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],[70,3,70,8],[72,3,72,8],[45,3,45,8],[47,1,47,8],[48,3,48,8],[63,1,63,2],[72,1,72,2],[66,3,66,8],[57,3,57,8],[58,3,58,8],[63,3,63,8],[65,1,65,8],[67,3,67,8],[68,3,68,8],[69,3,69,8],[45,1,45,2],[36,3,36,8],[41,3,41,8],[42,3,42,8],[43,3,43,8],[49,3,49,8],[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]]}
[]
[]
[]
[]
[null,"Technology & Commercialization Readiness Level Calculator"]
[]
[null,"Instructions"]
[null,"This Excel Workbook has been developed by NYSERDA to help emerging and growing companies determine the level of technical and commercial maturity of their products/innovations through the use of a customized and integrated Technology Readiness Level (TRL) and Commercial Readiness Level (CRL) tool. This TRL/CRL tool is based on the systems developed by NASA, DOE, and ARPA-E, and has been designed specifically for ventures in the clean energy industry.\n\nFor each category, select the button next to the description that best fits the status of your product/innovation, this tool will determine the appropriate TRL and CRL levels based on your answers. Once all categories have been completed, go to \"Summary & Results\" tab to view your TRL and CRL scores and answers."]
[]
[null,"PLEASE NOTE: This TRL/CRL tool is provided for informational purposes only, with the understanding that NYSERDA is not rendering any professional opinion or advice. You should consult with a professional advisor before taking any action based on the content of this tool."]
[]
[null,"Profile"]
[]
[null,"Company/Organization Name"]
[]
[null,"Proposal Title"]
[]
[null,"Product/Innovation Description"]
[]
[]
[null,"Technology",null,null,null,null,null,null,null,null,0,"Progress in Category"]
[null,null,1,"Project work is beyond basic research and technology concept has been defined",null,null,null,null,null,null,"TRL 1",{"$f":"IF($K$21>=1,1,0)","v":0},null,"TRL",null,"CRL"]
[null,null,2,"Applied research has begun and practical application(s) have been identified",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":"No"},1,{"$f":"IF(AND(L49=1,L58=1),\"Yes\",\"No\")","v":"No"}]
[null,null,3,"Preliminary testing of technology components has begun, and technical feasibility has been established 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,"Initial testing of integrated product/system has been completed in a laboratory 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,L67=1),\"Yes\",\"No\")","v":"No"}]
[null,null,5,"Laboratory scale integrated product/system demonstrates performance in the intended application(s)",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,L68=1,L76=1),\"Yes\",\"No\")","v":"No"}]
[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,L69=1,L77=1),\"Yes\",\"No\")","v":"No"}]
[null,"Answer",null,{"$f":"VLOOKUP(K21,C22:H26,2)","v":{"$error":"#N/A"}},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,L70=1),\"Yes\",\"No\")","v":"No"}]
[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,L71=1,L78=1),\"Yes\",\"No\")","v":"No"}]
[null,"Product Development",null,null,null,null,null,null,null,null,0,null,null,8,{"$f":"IF(L34=1,\"Yes\",\"No\")","v":"No"},8,{"$f":"IF(AND(L62=1,L79=1),\"Yes\",\"No\")","v":"No"}]
[null,null,1,"Initial product/market fit has been defined",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$30>=1,1,0)","v":0},null,9,{"$f":"IF(L35=1,\"Yes\",\"No\")","v":"No"},9,{"$f":"IF(AND(L62=1,L80=1),\"Yes\",\"No\")","v":"No"}]
[null,null,2,"Pilot scale product/system has been tested in the intended application(s)",null,null,null,null,null,null,"TRL 6",{"$f":"IF($K$30>=2,1,0)","v":0}]
[null,null,3,"Demonstration of a full scale product/system prototype has been completed in the intended application(s)",null,null,null,null,null,null,"TRL 7",{"$f":"IF($K$30>=3,1,0)","v":0}]
[null,null,4,"Actual product/system has been proven to work in its near-final form under a representative set of expected conditions and environments",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":"Error"}]
[null,null,5,"Product/system is in final form and has been operated under the full range of operating conditions and environments",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"}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K30,C31:H35,2)","v":{"$error":"#N/A"}}]
[]
[null,"Product Definition/Design",null,null,null,null,null,null,null,null,0]
[null,null,1,"One or more initial product hypotheses have been defined",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$39>=1,1,0)","v":0}]
[null,null,2,"Mapping product/system attributes against customer needs has highlighted a clear value proposition",null,null,null,null,null,null,"CRL 4",{"$f":"IF($K$39>=2,1,0)","v":0}]
[null,null,3,"The product/system has been scaled from laboratory to pilot scale and issues that may affect achieving full scale have been identified",null,null,null,null,null,null,"TRL 6",{"$f":"IF($K$39>=3,1,0)","v":0}]
[null,null,4,"Comprehensive customer value proposition model has been developed, including a detailed understanding of product/system design specifications, required certifications, and trade-offs",null,null,null,null,null,null,"CRL 5",{"$f":"IF($K$39>=4,1,0)","v":0}]
[null,null,5,"Product/system final design optimization has been completed, required certifications have been obtained, and product/system has incorporated detailed customer and product requirements",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":{"$error":"#N/A"}}]
[]
[null,"Competitive Landscape",null,null,null,null,null,null,null,null,0]
[null,null,1,"Secondary market research has been performed and basic knowledge of potential applications and competitive landscape have been identified",null,null,null,null,null,null,"CRL 1",{"$f":"IF($K$48>=1,1,0)","v":0}]
[null,null,2,"Primary market research to prove the product/system commercial feasibility has been completed and basic understanding of competitive products/systems has been demonstrated",null,null,null,null,null,null,"CRL 2",{"$f":"IF($K$48>=2,1,0)","v":0}]
[null,null,3,"Comprehensive market research to prove the product/system commercial feasibility has been completed and intermediate understanding of competitive products/systems has been demonstrated",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$48>=3,1,0)","v":0}]
[null,null,4,"Competitive analysis to illustrate unique features and advantages of the product/system compared to competitive products/systems has been completed",null,null,null,null,null,null,"CRL 4",{"$f":"IF($K$48>=4,1,0)","v":0}]
[null,null,5,"Full and complete understanding of the competitive landscape, target application(s), competitive products/systems, and market has been achieved",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":{"$error":"#N/A"}}]
[]
[null,"Team",null,null,null,null,null,null,null,null,0]
[null,null,1,"No team or company in place (single individual, no legal entity)",null,null,null,null,null,null,"CRL 1",{"$f":"IF($K$57>=1,1,0)","v":0}]
[null,null,2,"Solely technical or non-technical founder(s) running the company with no outside assistance",null,null,null,null,null,null,"CRL 2-3",{"$f":"IF($K$57>=2,1,0)","v":0}]
[null,null,3,"Solely technical or non-technical founder(s) running the company with assistance from outside advisors/mentors and/or incubator/accelerator",null,null,null,null,null,null,"CRL 4-5",{"$f":"IF($K$57>=3,1,0)","v":0}]
[null,null,4,"Balanced team with technical and business development/commercialization experience running the company with assistance from outside advisors/mentors",null,null,null,null,null,null,"CRL 6-7",{"$f":"IF($K$57>=4,1,0)","v":0}]
[null,null,5,"Balanced team with all capabilities onboard (e.g. sales, marketing, customer service, operations, etc.) running the company with assistance from outside advisors/mentors",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":{"$error":"#N/A"}}]
[]
[null,"Go-To-Market",null,null,null,null,null,null,null,null,0]
[null,null,1,"Initial business model and value proposition have been defined",null,null,null,null,null,null,"CRL 3",{"$f":"IF($K$66>=1,1,0)","v":0}]
[null,null,2,"Customers/partners have been interviewed to understand their pain points/needs, and business model and value proposition have been refined based on customer/partner feedback",null,null,null,null,null,null,"CRL 4",{"$f":"IF($K$66>=2,1,0)","v":0}]
[null,null,3,"Market and customer/partner needs and how those translate to product requirements have been defined, and initial relationships have been developed with key stakeholders across the value chain",null,null,null,null,null,null,"CRL 5",{"$f":"IF($K$66>=3,1,0)","v":0}]
[null,null,4,"Partnerships have been formed with key stakeholders across the value chain (e.g. suppliers, partners, service providers, and customers)",null,null,null,null,null,null,"CRL 6",{"$f":"IF($K$66>=4,1,0)","v":0}]
[null,null,5,"Supply agreements with suppliers and partners are in place and initial purchase orders from customers have been received",null,null,null,null,null,null,"CRL 7",{"$f":"IF($K$66>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K66,C67:H71,2)","v":{"$error":"#N/A"}}]
[]
[null,"Manufacturing/Supply Chain",null,null,null,null,null,null,null,null,0]
[null,null,1,"Potential suppliers, partners, and customers have been identified and mapped in an initial value chain analysis",null,null,null,null,null,null,"CRL 4",{"$f":"IF($K$75>=1,1,0)","v":0}]
[null,null,2,"Relationships have been established with potential suppliers, partners, service providers, and customers and they have provided input on product and manufacturability requirements",null,null,null,null,null,null,"CRL 5",{"$f":"IF($K$75>=2,1,0)","v":0}]
[null,null,3,"Manufacturing process qualifications (e.g. QC/QA) have been defined and are in progress",null,null,null,null,null,null,"CRL 7",{"$f":"IF($K$75>=3,1,0)","v":0}]
[null,null,4,"Products/systems have been pilot manufactured and sold to initial customers",null,null,null,null,null,null,"CRL 8",{"$f":"IF($K$75>=4,1,0)","v":0}]
[null,null,5,"Full scale manufacturing and widespread deployment of product/system to customers and/or users has been achieved",null,null,null,null,null,null,"CRL 9",{"$f":"IF($K$75>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"VLOOKUP(K75,C76:H80,2)","v":{"$error":"#N/A"}}]

{"sheet":"Summary & Results","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,1,4,11],[6,1,6,12],[21,6,21,12],[22,6,22,12],[23,6,23,12],[24,6,24,12],[25,6,25,12],[26,6,26,12],[27,6,27,12],[28,6,28,12],[26,1,26,5],[27,1,27,5],[28,1,28,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,5]]}
[]
[]
[]
[]
[null,"Technology & Commercialization Readiness Level Calculator"]
[]
[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,"Technology Readiness Level:",null,null,null,null,null,null,null,null,{"$f":"'Instructions & Tool'!O34","v":"Error"}]
[]
[null,"Commercialization Readiness Level:",null,null,null,null,null,null,null,null,{"$f":"'Instructions & Tool'!O35","v":"Error"}]
[]
[]
[null,"Category",null,null,null,null,"Answer"]
[null,{"$f":"'Radio Data'!B2","v":"Technology"},null,null,null,null,{"$f":"'Instructions & Tool'!D28","v":{"$error":"#N/A"}}]
[null,{"$f":"'Radio Data'!B3","v":"Product Development"},null,null,null,null,{"$f":"'Instructions & Tool'!D37","v":{"$error":"#N/A"}}]
[null,{"$f":"'Radio Data'!B4","v":"Product Definition/Design"},null,null,null,null,{"$f":"'Instructions & Tool'!D46","v":{"$error":"#N/A"}}]
[null,{"$f":"'Radio Data'!B5","v":"Competitive Landscape"},null,null,null,null,{"$f":"'Instructions & Tool'!D55","v":{"$error":"#N/A"}}]
[null,{"$f":"'Radio Data'!B6","v":"Team"},null,null,null,null,{"$f":"'Instructions & Tool'!D64","v":{"$error":"#N/A"}}]
[null,{"$f":"'Radio Data'!B7","v":"Go-To-Market"},null,null,null,null,{"$f":"'Instructions & Tool'!D73","v":{"$error":"#N/A"}}]
[null,{"$f":"'Radio Data'!B8","v":"Manufacturing/Supply Chain"},null,null,null,null,{"$f":"'Instructions & Tool'!D82","v":{"$error":"#N/A"}}]

{"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"},{"$f":"'Instructions & Tool'!K21","v":0}]
[null,{"$f":"'Instructions & Tool'!B30","v":"Product Development"},{"$f":"'Instructions & Tool'!K30","v":0}]
[null,{"$f":"'Instructions & Tool'!B39","v":"Product Definition/Design"},{"$f":"'Instructions & Tool'!K39","v":0}]
[null,{"$f":"'Instructions & Tool'!B48","v":"Competitive Landscape"},{"$f":"'Instructions & Tool'!K48","v":0}]
[null,{"$f":"'Instructions & Tool'!B57","v":"Team"},{"$f":"'Instructions & Tool'!K57","v":0}]
[null,{"$f":"'Instructions & Tool'!B66","v":"Go-To-Market"},{"$f":"'Instructions & Tool'!K66","v":0}]
[null,{"$f":"'Instructions & Tool'!B75","v":"Manufacturing/Supply Chain"},{"$f":"'Instructions & Tool'!K75","v":0}]