{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome!","Quick Survey","Summary & Results","ARL","Radio Data"],"not_rendered":{"charts":0,"images":2,"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":"Welcome!","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Quick Survey","index":1,"n_rows":82,"n_cols":17,"rows_kept":82,"cut":false,"hidden":false,"merged":[[21,15,21,16],[21,13,21,14],[54,1,54,2],[42,3,42,8],[4,0,4,9],[47,1,47,8],[48,3,48,8],[45,1,45,2],[36,3,36,8],[41,3,41,8],[27,1,27,2],[51,3,51,8],[52,3,52,8],[54,3,54,8],[50,3,50,8],[45,3,45,8],[70,3,70,8],[72,3,72,8],[63,1,63,2],[72,1,72,2],[66,3,66,8],[69,3,69,8],[63,3,63,8],[65,1,65,8],[67,3,67,8],[68,3,68,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],[59,3,59,8],[60,3,60,8],[61,3,61,8],[56,1,56,8],[57,3,57,8],[58,3,58,8],[43,3,43,8],[49,3,49,8],[38,1,38,8],[39,3,39,8],[40,3,40,8],[11,1,11,8],[20,1,20,8],[21,3,21,8],[36,1,36,2],[22,3,22,8],[23,3,23,8],[24,3,24,8],[25,3,25,8],[27,3,27,8],[29,1,29,8],[30,3,30,8],[31,3,31,8],[32,3,32,8],[33,3,33,8],[34,3,34,8]]}
[]
[]
[]
[null,null,null,null,null,null,null,"              🧾   Quick Survey"]
[]
[]
[]
[]
[]
[null,"✍ ",null,"Please tell us about yourself"]
[]
[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,"Your Response",null,{"$f":"IF('Radio Data'!C2=0,\"No Answer\",VLOOKUP(K21,C22:H26,2))","v":"No Answer"},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,\"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$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,\"0\")))))))))","v":"0"}]
[]
[null,"Your Response",null,{"$f":"IF('Radio Data'!C3=0,\"No Answer\",VLOOKUP(K30,C31:H35,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$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,"Your Response",null,{"$f":"IF('Radio Data'!C4=0,\"No Answer\",VLOOKUP(K39,C40:H44,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$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,"Your Response",null,{"$f":"IF('Radio Data'!C5=0,\"No Answer\",VLOOKUP(K48,C49:H53,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$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,"Your Response",null,{"$f":"IF('Radio Data'!C6=0,\"No Answer\",VLOOKUP(K57,C58:H62,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$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,"Your Response",null,{"$f":"IF('Radio Data'!C7=0,\"No Answer\",VLOOKUP(K66,C67:H71,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$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,"Your Response",null,{"$f":"IF('Radio Data'!C8=0,\"No Answer\",VLOOKUP(K75,C76:H80,2))","v":"No Answer"}]

{"sheet":"Summary & Results","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,13],[4,0,4,12],[8,7,8,11],[10,7,10,11],[12,7,12,11],[6,1,6,13],[21,6,21,13],[22,6,22,13],[23,6,23,13],[24,6,24,13],[25,6,25,13],[26,6,26,13],[27,6,27,13],[28,6,28,13],[26,1,26,5],[19,7,19,12],[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,null,null,null,null,null,null,null,"       📃    Your Summary & Results"]
[]
[]
[null,"   Profile"]
[]
[null,"Company/Organization Name:",null,null,null,null,null,{"$f":"IF(ISBLANK('Quick Survey'!H14),\"Enter Information on Instructions & Calculator Tab\", 'Quick Survey'!H14)","v":"Enter Information on Instructions & Calculator Tab"}]
[]
[null,"Proposal Title:",null,null,null,null,null,{"$f":"IF(ISBLANK('Quick Survey'!H16),\"Enter Information on Instructions & Calculator Tab\", 'Quick Survey'!H16)","v":"Enter Information on Instructions & Calculator Tab"}]
[]
[null,"Product/Innovation Description:",null,null,null,null,null,{"$f":"IF(ISBLANK('Quick Survey'!H18),\"Enter Information on Instructions & Calculator Tab\", 'Quick Survey'!H18)","v":"Enter Information on Instructions & Calculator Tab"}]
[]
[]
[null,"Technology Readiness Level",null,null,null,null,null,null,null,null,{"$f":"'Quick Survey'!O34","v":"0"}]
[]
[null,"Commercialization Readiness Level",null,null,null,null,null,null,null,null,{"$f":"'Quick Survey'!O35","v":"0"}]
[]
[null,"Your Relevant Programs",null,null,null,null,null,{"$f":"IF(AND(K16 >= 1, K16 <= 10), \"Internship Program\", \"\") &\nIF(AND(K16 >= 2, K16 <= 4), \", Catalyst / DICES\", \"\") &\nIF(AND(K16 >= 2, K16 <= 8), \", AmplifyMass\", \"\") &\nIF(AND(K16 >= 5, K16 <= 8), \", InnovateMass\", \"\") &\nIF(AND(K16 >= 8, K16 <= 10), \", CriticalMass\", \"\") & IF(AND(K16 >= 3, K16 <=10), \", 2030 Investment Fund\", \"\") & IF(AND(K16 >= 3, K16 <= 7), \", Massachusetts Climatetech Studio\", \"\")","v":""}]
[]
[null,"   Category",null,null,null,null,"Your Responses"]
[null,{"$f":"'Radio Data'!B2","v":"Technology"},null,null,null,null,{"$f":"'Quick Survey'!D28","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B3","v":"Product Development"},null,null,null,null,{"$f":"'Quick Survey'!D37","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B4","v":"Product Definition/Design"},null,null,null,null,{"$f":"'Quick Survey'!D46","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B5","v":"Competitive Landscape"},null,null,null,null,{"$f":"'Quick Survey'!D55","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B6","v":"Team"},null,null,null,null,{"$f":"'Quick Survey'!D64","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B7","v":"Go-To-Market"},null,null,null,null,{"$f":"'Quick Survey'!D73","v":"No Answer"}]
[null,{"$f":"'Radio Data'!B8","v":"Manufacturing/Supply Chain"},null,null,null,null,{"$f":"'Quick Survey'!D82","v":"No Answer"}]
[]
[]
[null,"This calculator is based on resources and frameworks prodcued by NYSERDA, NASA, DOE, and ARPA-E. This tool is provided for informational purposes only, with the understanding that MassCEC is not rendering any professional opinion or advice. Please consult with a professional advisor before taking any action based on the content of this tool."]

{"sheet":"ARL","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"CARAT [Commercial Adoption Readiness Assessment Tool]"]

{"sheet":"Radio Data","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"'Quick Survey'!B21","v":"Technology"},{"$f":"'Quick Survey'!K21","v":0}]
[null,{"$f":"'Quick Survey'!B30","v":"Product Development"},{"$f":"'Quick Survey'!K30","v":0}]
[null,{"$f":"'Quick Survey'!B39","v":"Product Definition/Design"},{"$f":"'Quick Survey'!K39","v":0}]
[null,{"$f":"'Quick Survey'!B48","v":"Competitive Landscape"},{"$f":"'Quick Survey'!K48","v":0}]
[null,{"$f":"'Quick Survey'!B57","v":"Team"},{"$f":"'Quick Survey'!K57","v":0}]
[null,{"$f":"'Quick Survey'!B66","v":"Go-To-Market"},{"$f":"'Quick Survey'!K66","v":0}]
[null,{"$f":"'Quick Survey'!B75","v":"Manufacturing/Supply Chain"},{"$f":"'Quick Survey'!K75","v":0}]