{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions & Calculator","Summary & Results","Radio Data"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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 & Calculator","index":0,"n_rows":86,"n_cols":17,"rows_kept":86,"cut":false,"hidden":false,"merged":[[11,1,11,8],[24,1,24,8],[25,3,25,8],[40,1,40,2],[26,3,26,8],[27,3,27,8],[28,3,28,8],[29,3,29,8],[31,3,31,8],[33,1,33,8],[34,3,34,8],[35,3,35,8],[36,3,36,8],[37,3,37,8],[38,3,38,8],[54,3,54,8],[49,3,49,8],[47,3,47,8],[53,3,53,8],[42,1,42,8],[43,3,43,8],[44,3,44,8],[63,3,63,8],[64,3,64,8],[65,3,65,8],[60,1,60,8],[61,3,61,8],[62,3,62,8],[85,3,85,8],[78,1,78,8],[79,3,79,8],[80,3,80,8],[81,3,81,8],[82,3,82,8],[83,3,83,8],[85,1,85,2],[74,3,74,8],[76,3,76,8],[67,1,67,2],[76,1,76,2],[70,3,70,8],[73,3,73,8],[67,3,67,8],[69,1,69,8],[71,3,71,8],[72,3,72,8],[25,15,25,16],[25,13,25,14],[58,1,58,2],[46,3,46,8],[4,0,4,9],[7,1,7,8],[9,1,9,8],[51,1,51,8],[52,3,52,8],[49,1,49,2],[40,3,40,8],[45,3,45,8],[31,1,31,2],[55,3,55,8],[56,3,56,8],[58,3,58,8]]}
[]
[]
[]
[]
["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 Commercialization Readiness Level (CRL) Calculator. This TRL/CRL Calculator 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 calculator will determine the appropriate TRL and CRL levels based on your answers. Once all categories have been completed, click the \"See Results\" button to view your TRL and CRL scores and answers."]
[]
[null,"PLEASE NOTE:  This TRL/CRL Calculator 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 calculator."]
[]
[null,"Profile"]
[]
[null,"Calculator Completion Date:"]
[]
[null,"Company/Organization Name:"]
[]
[null,"Contract Number:"]
[]
[null,"Project Name:"]
[]
[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$25>=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$25>=2,1,0)","v":0},null,1,{"$f":"IF(L26=1,\"Yes\", \"No\")","v":"No"},1,{"$f":"IF(AND(L53=1,L62=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$25>=3,1,0)","v":0},null,2,{"$f":"IF(L27=1,\"Yes\", \"No\")","v":"No"},2,{"$f":"IF(AND(L54=1,L63=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$25>=4,1,0)","v":0},null,3,{"$f":"IF(L28=1,\"Yes\",\"No\")","v":"No"},3,{"$f":"IF(AND(L35=1,L44=1,L55=1,L63=1,L71=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$25>=5,1,0)","v":0},null,4,{"$f":"IF(L29=1,\"Yes\",\"No\")","v":"No"},4,{"$f":"IF(AND(L45=1,L56=1,L64=1,L72=1,L80=1),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(L30=1,\"Yes\",\"No\")","v":"No"},5,{"$f":"IF(AND(L47=1,L57=1,L64=1,L73=1,L81=1),\"Yes\",\"No\")","v":"No"}]
[null,"Answer",null,{"$f":"IF('Radio Data'!C2=0,\"No Answer\",VLOOKUP(K25,C26:H30,2))","v":"No Answer"},null,null,null,null,null,null,null,null,null,6,{"$f":"IF(AND(L36=1,L46=1),\"Yes\",\"No\")","v":"No"},6,{"$f":"IF(AND(L48=1,L65=1,L74=1),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(L37=1,\"Yes\",\"No\")","v":"No"},7,{"$f":"IF(AND(L65=1,L75=1,L82=1),\"Yes\",\"No\")","v":"No"}]
[null,"Product Development",null,null,null,null,null,null,null,null,0,null,null,8,{"$f":"IF(L38=1,\"Yes\",\"No\")","v":"No"},8,{"$f":"IF(AND(L66=1,L83=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$34>=1,1,0)","v":0},null,9,{"$f":"IF(L39=1,\"Yes\",\"No\")","v":"No"},9,{"$f":"IF(AND(L66=1,L84=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$34>=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$34>=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$34>=4,1,0)","v":0},null,"TRL Score",{"$f":"IF(O35=\"Yes\",9,IF(O34=\"Yes\",8,IF(O33=\"Yes\",7,IF(O32=\"Yes\",6,IF(O31=\"Yes\",5,IF(O30=\"Yes\",4,IF(O29=\"Yes\",3,IF(O28=\"Yes\",2,IF(O27=\"Yes\",1,\"0\")))))))))","v":"0"}]
[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$34>=5,1,0)","v":0},null,"CRL Score",{"$f":"IF(Q35=\"Yes\",9,IF(Q34=\"Yes\",8,IF(Q33=\"Yes\",7,IF(Q32=\"Yes\",6,IF(Q31=\"Yes\",5,IF(Q30=\"Yes\",4,IF(Q29=\"Yes\",3,IF(Q28=\"Yes\",2,IF(Q27=\"Yes\",1,\"0\")))))))))","v":"0"}]
[]
[null,"Answer",null,{"$f":"IF('Radio Data'!C3=0,\"No Answer\",VLOOKUP(K34,C35:H39,2))","v":"No Answer"}]
[]
[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$43>=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$43>=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$43>=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$43>=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$43>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"IF('Radio Data'!C4=0,\"No Answer\",VLOOKUP(K43,C44:H48,2))","v":"No Answer"}]
[]
[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$52>=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$52>=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$52>=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$52>=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$52>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"IF('Radio Data'!C5=0,\"No Answer\",VLOOKUP(K52,C53:H57,2))","v":"No Answer"}]
[]
[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$61>=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$61>=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$61>=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$61>=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$61>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"IF('Radio Data'!C6=0,\"No Answer\",VLOOKUP(K61,C62:H66,2))","v":"No Answer"}]
[]
[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$70>=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$70>=2,1,0)","v":0}]
[null,null,3,"Product requirements have been defined in terms of customer needs, and initial relationships have been developed with channel partners",null,null,null,null,null,null,"CRL 5",{"$f":"IF($K$70>=3,1,0)","v":0}]
[null,null,4,"Partnerships have been formed with key channel partners, and a full communications and distribution strategy between the company and customers has been defined",null,null,null,null,null,null,"CRL 6",{"$f":"IF($K$70>=4,1,0)","v":0}]
[null,null,5,"Agreements and marketing support has been developed with partners between company and purchasers are in place and initial purchase orders from customers have been received",null,null,null,null,null,null,"CRL 7",{"$f":"IF($K$70>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"IF('Radio Data'!C7=0,\"No Answer\",VLOOKUP(K70,C71:H75,2))","v":"No Answer"}]
[]
[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$79>=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$79>=2,1,0)","v":0}]
[null,null,3,"Product design is complete and supply agreements are in place, stakeholders are involved in manufacturing qualifications and regulatory compliance for product and production operations, and financial models/projections have been developed",null,null,null,null,null,null,"CRL 7",{"$f":"IF($K$79>=3,1,0)","v":0}]
[null,null,4,"Customer qualifications are complete and products/systems have been pilot manufactured and sold to initial customers",null,null,null,null,null,null,"CRL 8",{"$f":"IF($K$79>=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$79>=5,1,0)","v":0}]
[]
[null,"Answer",null,{"$f":"IF('Radio Data'!C8=0,\"No Answer\",VLOOKUP(K79,C80:H84,2))","v":"No Answer"}]

{"sheet":"Summary & Results","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[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],[24,6,24,12],[25,6,25,12],[26,6,26,12],[27,6,27,12],[28,6,28,12],[6,1,6,12],[21,6,21,12],[22,6,22,12],[23,6,23,12],[4,0,4,12],[8,7,8,11],[10,7,10,11],[12,7,12,11]]}
[]
[]
[]
[]
["Technology & Commercialization Readiness Level Calculator"]
[]
[null,"   Profile"]
[]
[null,"Company/Organization Name:",null,null,null,null,null,{"$f":"IF(ISBLANK('Instructions & Calculator'!H16),\"Enter Information on Instructions & Calculator Tab\", 'Instructions & Calculator'!H16)","v":"Enter Information on Instructions & Calculator Tab"}]
[]
[null,"Proposal Title:",null,null,null,null,null,{"$f":"IF(ISBLANK('Instructions & Calculator'!H20),\"Enter Information on Instructions & Calculator Tab\", 'Instructions & Calculator'!H20)","v":"Enter Information on Instructions & Calculator Tab"}]
[]
[null,"Product/Innovation Description:",null,null,null,null,null,{"$f":"IF(ISBLANK('Instructions & Calculator'!H22),\"Enter Information on Instructions & Calculator Tab\", 'Instructions & Calculator'!H22)","v":"Enter Information on Instructions & Calculator Tab"}]
[]
[]
[]
[null,"Technology Readiness Level",null,null,null,null,null,null,null,null,{"$f":"'Instructions & Calculator'!O38","v":"0"}]
[]
[null,"Commercialization Readiness Level",null,null,null,null,null,null,null,null,{"$f":"'Instructions & Calculator'!O39","v":"0"}]
[]
[]
[null,"   Category",null,null,null,null,"Answer"]
[null,{"$f":"'Radio Data'!B2","v":"Technology"},null,null,null,null,{"$f":"'Instructions & Calculator'!D32","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B3","v":"Product Development"},null,null,null,null,{"$f":"'Instructions & Calculator'!D41","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B4","v":"Product Definition/Design"},null,null,null,null,{"$f":"'Instructions & Calculator'!D50","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B5","v":"Competitive Landscape"},null,null,null,null,{"$f":"'Instructions & Calculator'!D59","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B6","v":"Team"},null,null,null,null,{"$f":"'Instructions & Calculator'!D68","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B7","v":"Go-To-Market"},null,null,null,null,{"$f":"'Instructions & Calculator'!D77","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B8","v":"Manufacturing/Supply Chain"},null,null,null,null,{"$f":"'Instructions & Calculator'!D86","v":"No Answer"}]

{"sheet":"Radio Data","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"'Instructions & Calculator'!B25","v":"Technology"},{"$f":"'Instructions & Calculator'!K25","v":0}]
[null,{"$f":"'Instructions & Calculator'!B34","v":"Product Development"},{"$f":"'Instructions & Calculator'!K34","v":0}]
[null,{"$f":"'Instructions & Calculator'!B43","v":"Product Definition/Design"},{"$f":"'Instructions & Calculator'!K43","v":0}]
[null,{"$f":"'Instructions & Calculator'!B52","v":"Competitive Landscape"},{"$f":"'Instructions & Calculator'!K52","v":0}]
[null,{"$f":"'Instructions & Calculator'!B61","v":"Team"},{"$f":"'Instructions & Calculator'!K61","v":0}]
[null,{"$f":"'Instructions & Calculator'!B70","v":"Go-To-Market"},{"$f":"'Instructions & Calculator'!K70","v":0}]
[null,{"$f":"'Instructions & Calculator'!B79","v":"Manufacturing/Supply Chain"},{"$f":"'Instructions & Calculator'!K79","v":0}]